Question 5 Excel Output 1 Micro soft Excel 140 An swer Report Worksheet: [Proble

Question

Question 5 Excel Output 1 Micro soft Excel 140 An swer Report Worksheet: [Problem 2.23 xls Solution Report Created: 10/31/2014 1:57:14PM 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 Msx Time 100 s ec Iter ations 100, Precis ion 0.000001 Max Subproblems 5000. Max Integer Sols 5000. Integer Tolerance 5%, Assume NonNegative 0? Cell SBS12 Objecthe Function X Value Final Value 100 Veriable Cels Cell SBs10 X1 (Pumpkin Bars) SCS10 X2 (Carob Bar Final Value 24.00000 8.00000 N ame Value 24.00000 8.00000 In Constraints Cell Cell Value Formula Status Slack SBS15 s0S15 SBS 16(=SD Sie Binding 0 ses15 SBS1 LHS Binding 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( SC$10 X2(Carob Bars) in Bars) 24 0 5167 25 1.25 Constraints Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease Cell SB$15 Flour 40 40 10 60 16 Oatmeal 120 120 The values of the decision variables at the optimal solution are 0x1 = 24, x2 = 8 O Constra 140, Constraint 2 120 160 O None of the above is correct

Explanation / Answer

Option 1 is correct

As it has the value we get exactly it should become the optimal solution for the above

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

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