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%.
Answers: 3
Other questions on the subject: Business
Business, 22.06.2019 13:40, dathanboyd
Jacob is a member of wcc (an llc taxed as a partnership). jacob was allocated $155,000 of business income from wcc for the year. jacob’s marginal income tax rate is 37 percent. the business allocation is subject to 2.9 percent of self-employment tax and 0.9 percent additional medicare tax. (round your intermediate calculations to the nearest whole dollar a) what is the amount of tax jacob will owe on the income allocation if the income is not qualified business income? b) what is the amount of tax jacob will owe on the income allocation if the income is qualified business income (qbi) and jacob qualifies for the full qbi duduction?
Answers: 2
Business, 22.06.2019 20:20, laidbackkiddo412
Tl & co. is following a related-linked diversification strategy, and soar inc. is following a related-constrained diversification strategy. how do the two firms differ from each other? a. soar inc. generates 70 percent of its revenues from its primary business, while tl & co. generates only 10 percent of its revenues from its primary business. b. soar inc. pursues a backward diversification strategy, while tl & co. pursues a forward diversification strategy. c. tl & co. will share fewer common competencies and resources between its various businesses when compared to soar inc. d. tl & co. pursues a differentiation strategy, and soar inc. pursues a cost-leadership strategy, to gain a competitive advantage.
Answers: 3
Business, 22.06.2019 23:30, lulustar13
Atelephone call center uses three customer service representatives (csrs) during the 8: 30 a. m. to 9: 00 a. m. time period. the standard service rate is 3.0 minutes per telephone call per csr. assuming a target labor utilization rate of 80 percent, how many calls can these three csrs handle during this half-hour period?
Answers: 1
Business, 23.06.2019 01:30, stranger123
At the end of the fiscal year, apha airlines has an outstanding non-cancellable purchase commitment for the purchase of 1 million gallons of jet fuel at a price of $4.10 per gallon for delivery during the coming summer. the company prices its inventory at the lower of cost or market. if the market price for jet fuel at the end of the year is $4.50, how would this situation be reflected in the annual financial statements?
Answers: 2
You know the right answer?
A company manufactures mechanical heart valves from the heart valves of pigs. Different heart operat...
Questions in other subjects:
Medicine, 02.10.2021 16:50
Mathematics, 02.10.2021 16:50
Mathematics, 02.10.2021 16:50
Mathematics, 02.10.2021 16:50
Health, 02.10.2021 16:50
Chemistry, 02.10.2021 16:50
