The file is not needed. All the data from the file is aready in the chart typed in. Thank you!

36. 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 medi- um, 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. Problem 1 Problem 3.36(a)-Manufacturing Mechanical Heart Valves (p. 127) Inputs Supplier 1 Supplier 2 Supplier 3 Cost/valve $75 $65 $50 % small 40% 30% 20% % medium % large 40% 20% 35% 35% 20% 60% Purchases Supplier 1 Supplier 2 Supplier 3 Available 2400 2000 1000 Small Medium Large Valves obtained Required Total cost Problem 2 Tom's Restaurant has an ice cream counter where it sells two main products, ice cream and frozen yogurt, each in variety of flavors. The restaurant makes one order for ice cream and yogurt each week, and the store has enough freezer space for 115 gallons of both products. A gallon of ice cream costs $0.93 and a gallon of frozen yogurt costs $0.75, and the restaurant budgets $90 each week for these products. The manager estimates that each week the restaurant sells at least twice as much ice cream as frozen yogurt. Profit per gallon of ice cream is $4.15 and profit per gallon of yogurt is $3.60. How many gallons of ice cream and frozen yogurt should restaurant order to maximize its weekly profit? Ice-cream Frozen yogurt Unit cost Unit profit Ice-cream Frozen yogurt Space used Freezer space Order per week (gal) Min required ice-cream (gal) Budget Money spent Profit