Question 6 Excel Output 1 Micro soft Excel 140 An swer Report worksheet: [Proble

Question

Question 6 Excel Output 1 Micro soft Excel 140 An swer Report worksheet: [Problem 2.23.xis? Solution Report Created: 10/31/2014 1:57:14 PM Result: Solver found a solution. All Con straints and optimalty conditions are satisfied. Solver Engine Engine Simplex LP Solution Time 0.010 Seconds Solver Options Max Time 100 see lt?ations 100. Preou ion 0000001 Max SUDproblems 5000, Max Integer Sols 5000. Integer Tolerance 5%, Assume NonNegative Objective Cell Ma Cell B512 Value Final Value 100 Name Function X1 Variable Cels Final Value 24.00000 8.00000 N ame Value Integer Cell SBs10 X1 (Pumpkin Bars) SC$10 X2(Carob Bars) 24.00000 800000 Contin Constraints Cell iame Cell Value 40 Formu la SB515?SDS15 SB3180 $18 Status Slack SBS15 LHS Binding 0 SBS10 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 Name Cell SB$10 X1 (Pumpkin Bars 24 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 5B516 Oatmeal 40 120 40 40 10 60 120 The range of optimality for the coefficient of the first variable (C1) is 2.5s C15 6.67 3.75 s C1 s 10 21.5s C15 25.67 O None of the above is correct

Explanation / Answer

from sensitivity report, we can easily find the range of optimality for any variable.

Here we have to find for C1 variable

C1 has objective coefficient 5 with the allowable increase of 1.67 so 5+1.67=6.67

C1 has objective coefficient 5 with the allowable decrease of 2.5 so 5-2.5=2.5

so we get 2.5<=C1<=6.67

so correct option is 1st

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

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