A company manufactures mechanical heart valves from the heart valves of pigs. Different heart operations require valves
Question:
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. a. Use Solver to determine how the company can minimize the cost of acquiring the needed valves.
a. Use Solver to determine how the company can minimize the cost of acquiring the needed valves.
file:///C:/Users/cordovaea/Downloads/Homework((Template).pdf
Data Analysis and Decision Making
ISBN: 978-0538476126
4th edition
Authors: Christian Albright, Wayne Winston, Christopher Zappe