Show formulas and use solver. shower formula for solver too

Clipboard l3. B C D 1 Mctung mechanical heart valves 2 i 3 l Cost/valve % small % medium 4 Supplier 1 $75 40 40 5 Supplier 2 $65 30 35 6 Supplier 3 $50 20 20 Max available 7400 2000 1000 Alignment full 99 76 97 90 46 72 81 41 65 60 79 55 86 70 70 53 94 90 X AutoSave Off Final_Q1 (1) v Search (Alt+Q) File Home Insert Draw Page Layout Formulas Data Review View Help Calibri 11 ~AA de Wrap Text General Paste BI UV Merge & Center $ Undo Clipboard Font Alignment G12 v IX V fx A B C D E F G H Manufacturing mechanical heart valves N 3 Inputs 4 Cost/valve % small % medium % large 5 Supplier 1 6 Supplier 2 7 Supplier 3 9 Purchases Available 10 Supplier 1 11 Supplier 2 12 Supplier 3 13 14 Small Medium Large 15 Valves obtained 16 17 Required 18 19 Total cost 20 21 22 23 24 25 26 Data Model Ready 12 Accessibility: Good to goX Content X + .edu/ultra/courses/_189483_1/cl/outline Force This test can be saved and resumed later. Completion Your answers are saved automatically. Question Completion Status: QUESTION 1 10 poin 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 attached Excel file. 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. b. 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%. You can use the attached template file given here. Q1.xisx Attach File Browse Local Files Browse Content Collection QUESTION 2 10 points A company manufactures two products on two machines The number of hours of machine time and labor donands on the machine and Click Save and Submit to save and submit. Click Save All Answers to save all answers. Save All Answers U + 144 Dil DDI