show formula and use solver. show formula for solver too

Calibri - 11 - A" A E E X AutoSave Off Final_Q2 v Search (Alt+Q) File Home Insert Draw Page Layout Formulas Data Review View Help Calibri 11 ~ A A ag Wrap Text Genera LA Paste B A Merge & Center $ Undo Clipboard Font Alignment A1 VIX fx Producing two products on two machines B C D E F G H Producing two products on two machines Product 1 Product 2 Machine 1 Machine 2 Machine 1 Machine 2 Hours of machine time required 0.70 0.80 0.75 0.90 Hours of labor required 0.75 1.20 0.75 1.00 7 Unit costs $16.50 $18.00 $13.50 $14.50 8 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Data Model + Ready 12 Accessibility: Good to go OAutoSave Final Q1 (1) v File Home Insert Draw Page Layout Formulas Data Review View X Calibri * 11 " A" A " BEE x AutoSave @ off) Final_Q2 v 9 Search (Alt+Q) File Home Insert Draw Page Layout Formulas Data Review View Help Calibri ~ 11 ~ A A ag Wrap Text General Paste B I U v v Vv A v E EEE Merge & Center $ % 9 Undo Clipboard Font Is Alignment Number A1 v I X V fx Producing two products on two machines B D G H K Unit costs Machine requirements Labor requirements 1 A WIN Machine 1 Machine 2 Machine 1 Machine 2 Machine 1 Machine 2 5 Product 1 6 Product 2 7 8 Production Machine 1 Machine 2 Percent requirements on specific machines 9 Product 1 Pct of product 1 on machine 10 Product 2 Pct of product 2 on machine 1 11 12 Constraint on production 13 Total produced Total required 14 Product 1 15 Product 2 16 17 18 Constraint on machine time 19 Machine 1 Machine 2 20 Machine time used 21 22 Machine time available 23 24 Constraint on labor time 25 Labor time used 26 27 Labor time available 28 29 Constraint on machine time for product 1 30 Actual on machine 2 Required on machine 2 31 32 3 Constraint on machine time for product 2 34 Actual on machine 1 Required on machine 1 35 Product 2 36 37 Objective to minimize 38 Total cost Data Model + Ready Accessibility: Good to goQUESTION 2 A company manufactures two products on two machines. The number of hours of machine time and labor depends on the machine and product as shown in the attached file. The cost of producing a unit of each product depends on which machine produces it. These unit costs also appear in the same file. Each month, there are 200 hours available on each of the two machines, and there are 400 labor hours available total. This month at least 250 units of product 1 and at least 170 units of product 2 must be produced. Also, at least half of the product 1 requirement must be produced on machine 2, and at least half of the product 2 requirement must be produced on machine 1. a. Determine how the company can minimize the cost of meeting this month's requirements. b. Use a two-way SolverTable to see how much the "at least half requirements are costing the company. Do this by changing both of these requirements from "at least half" to "at least x percent," where x can be any multiple of 5% from 0% to 50%. You can use the attached template file given here. Q2.xisx Attach File Browse Local Files Browse Content Collection