subject
Business, 21.09.2020 17:01 AD4MF4HM1

A company manufactures mechanical heart valves from the heart valves of pigs. Different heart operations require valves of different sizes. The company purchases pig valves from three different suppliers. The cost and size mix of the valves purchased from each supplier are given in the file P03_36.xlsx. This file also contains the maximum number of valves available from each supplier per month. Each month, the company places an order with each supplier. At least 1300 large, 900 medium, and 400 small valves must be purchased each month. 1. Use Solver to determine how the company can minimize the cost of acquiring the needed valves.
2. Use SolverTable to investigate the effect on total cost of increasing its minimal purchase requirements each month. Specifically, see how the total cost changes as the minimal purchase requirements of large, medium, and small valves all increase from their original values by the same percentage. Revise your model so that SolverTable can be used to investigate these changes when the percentage increase varies from 2% to 40% in increments of 2%.

ansver
Answers: 3

Another question on Business

question
Business, 22.06.2019 03:00
Presented below is a list of possible transactions. analyze the effect of the 18 transactions on the financial statement categories indicated. transactions assets liabilities owners’ equity net income 1. purchased inventory for $80,000 on account (assume perpetual system is used). 2. issued an $80,000 note payable in payment on account (see item 1 above). 3. recorded accrued interest on the note from item 2 above. 4. borrowed $100,000 from the bank by signing a 6-month, $112,000, zero-interest-bearing note. 5. recognized 4 months’ interest expense on the note from item 4 above. 6. recorded cash sales of $75,260, which includes 6% sales tax. 7. recorded wage expense of $35,000. the cash paid was $25,000; the difference was due to various amounts withheld. 8. recorded employer’s payroll taxes. 9. accrued accumulated vacation pay. 10. recorded an asset retirement obligation. 11. recorded bonuses due to employees. 12. recorded a contingent loss on a lawsuit that the company will probably lose. 13. accrued warranty expense (assume expense warranty approach). 14. paid warranty costs that were accrued in item 13 above. 15. recorded sales of product and related service-type warranties. 16. paid warranty costs under contracts from item 15 above. 17. recognized warranty revenue (see item 15 above). 18. recorded estimated liability for premium claims outstanding.
Answers: 1
question
Business, 22.06.2019 07:20
Suppose that real interest rates increase across europe. this development will u.s. net capital outflow at all u.s. real interest rates. this causes the loanable funds to because net capital outflow is a component of that curve.
Answers: 1
question
Business, 22.06.2019 08:30
Blank is the internal operation that arranges information resources to support business performance and outcomes
Answers: 2
question
Business, 22.06.2019 09:40
Microsoft's stock price peaked at 6118% of its ipo price more than 13 years after the ipo suppose that $10,000 invested in microsoft at its ipo price had been worth $600,000 (6000% of the ipo price) after exactly 13 years. what interest rate, compounded annually, does this represent? (round your answer to two decimal places.)
Answers: 1
You know the right answer?
A company manufactures mechanical heart valves from the heart valves of pigs. Different heart operat...
Questions
question
Mathematics, 07.04.2020 23:38
question
Mathematics, 07.04.2020 23:38
question
English, 07.04.2020 23:38