Question 5: 15 points Extreme hired an intern last summer to develop some spreadsheets to help them manage the production floor. Unfortunately, no one can understand the spreadsheet the intern created to manage production and setup of machines to run specific products. Use the concepts, techniques and the cardinal rules" you learned in Quantitative Problem Solving to fix the Questions spreadsheet in your Excel file. (Hint: Start with Solver and work backwards and the current solution is not correct.) S.C. B S.C. C 2 3 1 Machine 1 5 Machine 2 Time A Time B 0.4 0.11 0.5 1.2 Time C 0.9 1.3 P.CA P.C. B P.CC 13 9 11 12 S.C.A 10 55 8 65 93 58 60 75 7 3 3 Production Setup Costs Enabled 8 6 3 7 0 1 0 1 1 0 1 2 Up time 1 3 Up Time 2 4 5 Total Time 1 6 Total Time 2 7 8 9 Demand A 20 Demand B 01 Demand C 1.97 5.2 Machine 1 A B Machine 2 . B 0 0 4 0 0 1 0 0 1 3 7 4 3 Supply A -4 Supply B -5 Supply C 26 Onmin oo O OFNM NO FINN 3 7 4 28 Setups 3 1 EO Enable Setup 1 2 3 Min Cost 357 Question 5: 15 points Extreme hired an intern last summer to develop some spreadsheets to help them manage the production floor. Unfortunately, no one can understand the spreadsheet the intern created to manage production and setup of machines to run specific products. Use the concepts, techniques and the cardinal rules" you learned in Quantitative Problem Solving to fix the Questions spreadsheet in your Excel file. (Hint: Start with Solver and work backwards and the current solution is not correct.) S.C. B S.C. C 2 3 1 Machine 1 5 Machine 2 Time A Time B 0.4 0.11 0.5 1.2 Time C 0.9 1.3 P.CA P.C. B P.CC 13 9 11 12 S.C.A 10 55 8 65 93 58 60 75 7 3 3 Production Setup Costs Enabled 8 6 3 7 0 1 0 1 1 0 1 2 Up time 1 3 Up Time 2 4 5 Total Time 1 6 Total Time 2 7 8 9 Demand A 20 Demand B 01 Demand C 1.97 5.2 Machine 1 A B Machine 2 . B 0 0 4 0 0 1 0 0 1 3 7 4 3 Supply A -4 Supply B -5 Supply C 26 Onmin oo O OFNM NO FINN 3 7 4 28 Setups 3 1 EO Enable Setup 1 2 3 Min Cost 357