A company manufactures mechanical heart valves

Assignment Help Management Theories

Reference no: EM131130321

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. Each month, the company places an order with each supplier. At least 500 large, 300 medium, and 300 small valves must be purchased each month. Because of the limited availability of pig valves, at most 500 valves per month can be purchased from each supplier.

a. Use Solver to determine how the company can minimize the cost of acquiring the needed valves.

b. Use Solver Table 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 Solver Table can be used to investigate these changes when the percentage increase varies from 2% to 20% in increments of 2%. Explain intuitively what happens when this percentage is at least 16%.

Reference no: EM131130321

Questions Cloud

Manufactures the brake petals for a bicycle : 1. Jack is a production manager at the company XYZ which manufactures the brake petals for a bicycle. Annual production quantity for the petals is 12K, and average cycle time for production is 2 months for a petal. The company wants to reduce curr..

What determines the classification of the industry : What determines the classification of the industry? How does this affect the pattern of international trade?

The description of your business concept : Present the Mission of your business, e.g. fundamental reason for being; and a Vision statement, what you hope your business will become.

Discuss one of earliest accounts of policing : Discuss one of earliest accounts of policing. Indicate whether or not the crime fighting methods from these early accounts are used today. From the e-Activity, predict whether or not the addition of new forensic technological tools will bring abou..

A company manufactures mechanical heart valves : 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 purcha..

How do they affect the factor-price equalization theorem : How do they affect the factor-price equalization theorem?

What is the value per share of your firms stock : Nonconstant Growth Stock Valuation Assume that the average firm in your company's industry is expected to grow at a constant rate of 5% and that its dividend yield is 7%. If the last dividend paid (D0) was $3, what is the value per share of your firm..

What is meant by the phrase crimes are statutory offenses : Do you agree or disagree with the U.S. Supreme Court's decision in the Berghuis v. Thompkins case (textbook, 157 - 159)? Is the majority or the dissenting opinion more convincing? Please explain.

Referenced in accordance with the qutls referencing guide : Business Law Assignment:In 3500 - 4000 words please address one of the following options. Your assignment should include an introduction and a conclusion. It should be referenced in accordance with the QUTLS referencing guide and include a biblio..

User Account

All Pages