Question 9 Excel Output 1 Micro soft Excel 14.0 An swer Report Worksheet: [Probl

Question

Question 9 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 optimality condition s are satisfied Solver Engine Engine Simplex LP Solution Time 0.010 Seconds Solver Options Mex Time 100 sec Iter ations 100, Precis ion 0.000001 Max Subproblems 5000, Max integer Sols 5000integer Tolerance 5%, Assume NonNegative Cell lame Value Final Value 100 SBS12 Objecthe Function X1 Variable Cells Cell SBs10 SCS10 Final Value 24.00000 8.00000 N ame Value 24.00000 8.00000 Integer X1 (Pumpkin Bars) X2(Carob Bar Constraints Cell Name Formu laS Cell Value 40 Status Slack 0 sestBc=SD$15 BS18-5D $18 Ses15 Binding SBS1 LHS Binding ?crosoft Excel 14.0 Sensitivity Report Worksheet: [Problem 2.23xlsx]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 (Pumpkin Bars) SCS10 X2 (Carob Bars) Name 1.25 Constraints Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease Cell SB$15 Flour Name 40 40 10 60 16 Oatmeal 120 120 The objective function value at the optimal solution is 160 O Constra 140, Constraint 2 0x1 = 24, x2 = 8 O None of the above is correct 120

Explanation / Answer

This sensitivity reports give us following information:

The objective function value at the optimal solution is 160 when x1=24 and x2=8

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.