Question 8 Excel Output 1 Micro soft Excel 14.0 An swer Report Worksheet: [Problem 2.23.xls Solution Report Created: 10/31/2014 1:57-14 PM Result: Solver found a solution. All Con straints and optimaity conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time 0.010 Seconds Solver Options Max Time 100 see lterations 100, Precs ion 0.000001 Max Subproblems 5000, Max Integer Sols 5000. Integer Tolerance 5%, Assume NonNegative Objective Cell Ma Cell SB$12 Final Value 100 Name Function X1 Veriable Cell Cell SBs10 SC S10 Value 24.00000 .00000 Final Value 24.00000 8.00000 N ame In X1 (Pumpkin Bers) X2/Caroo Bars Constraints Cell iame Cell Value Formu la Status Slack Ses15 40 SBS15 D s15 Binding S8316 LHS Microsoft Excel 14.0 Sensitivity Report Worksheet: [Problem 2.23xisx]Solution Report Created: 10 31/2014 1:57:14 PM Variable Cells Final Reduced Objetive Allowable Allowable Value Cost Coefficient Increase Decrease Cell SB$10 X1 (Pumpin Bars) SC$10 X2 (Carob Bars) 1.67 2.5 1.25 Constraints Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease Cell SB$15 Flour 40 120 40 40 10 60 16 Oatmeal 120 The dual price for constraint 2 is ?120 o 40 None of the above is correct Question 8 Excel Output 1 Micro soft Excel 14.0 An swer Report Worksheet: [Problem 2.23.xls Solution Report Created: 10/31/2014 1:57-14 PM Result: Solver found a solution. All Con straints and optimaity conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time 0.010 Seconds Solver Options Max Time 100 see lterations 100, Precs ion 0.000001 Max Subproblems 5000, Max Integer Sols 5000. Integer Tolerance 5%, Assume NonNegative Objective Cell Ma Cell SB$12 Final Value 100 Name Function X1 Veriable Cell Cell SBs10 SC S10 Value 24.00000 .00000 Final Value 24.00000 8.00000 N ame In X1 (Pumpkin Bers) X2/Caroo Bars Constraints Cell iame Cell Value Formu la Status Slack Ses15 40 SBS15 D s15 Binding S8316 LHS Microsoft Excel 14.0 Sensitivity Report Worksheet: [Problem 2.23xisx]Solution Report Created: 10 31/2014 1:57:14 PM Variable Cells Final Reduced Objetive Allowable Allowable Value Cost Coefficient Increase Decrease Cell SB$10 X1 (Pumpin Bars) SC$10 X2 (Carob Bars) 1.67 2.5 1.25 Constraints Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease Cell SB$15 Flour 40 120 40 40 10 60 16 Oatmeal 120 The dual price for constraint 2 is ?120 o 40 None of the above is correct