[solved]-Practical Management Science 6th Edition Chapter 3 Problem 36p Company Manufactures Mechan Q39739802

Practical ManagementScience (6th Edition) Chapter 3, Problem 36P. A companymanufactures mechanical heart valves from the heart valves of pigs.Different heart operations require valves of different sizes. Thecompany purchases pig valves from three different suppliers. Thecost and size mix of the valves purchased from each supplier aregiven in the data file P03_36.xlsx. This file contains the maximumnumber of valves available form each supplier per month. Eachmonth, the company places an order with each supplier. At least1300 large, 900 medium, and 400 small valves must be purchased eachmonth.

a. Use Solver todetermine how the company can minimize the cost of acquiring theneeded valves.

(I included the datafrom the file P03_36.xlsx. below and plugged in some of the values.Solver was confusing me on excel so I couldn’t get any further.Also had to make a table as I couldn’t figure out how to post myexcel document. Thanks!)

InputsCost/ Valve% Small% Medium% LargeSupplier 1$7540%40%20%Supplier 2$6530%35%35%Supplier 3$5020%20%60%PurchasesAvailableSupplier 1<=2400Supplier 2<=2000Supplier 3<=1000SmallMediumLargeValues Obtained>=>=>=Required4009001300Total Cost

Expert Answer

---

Answer to Practical Management Science (6th Edition) Chapter 3, Problem 36P. A company manufactures mechanical heart valves from t… . . .