a) what is the value of the optimal Z of this problem? b) which constraints are

Question

a) what is the value of the optimal Z of this problem? b) which constraints are binding? Problem 4 15 pts Consider the following Microsoft Excel 12.0 Sensitivity Report Worksheet: xxx.xIsx Report Created:.. Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name SBS4 SC$4 x1 -Lbs of Product1 x2-Lbs of Product 2 Value Cost Coefficient Increase Decrease 35 170 6 2 120 170 1E+30 70 Constraints Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease Name Cell SD$10 [11 Raw material Used SD$11 12] Workers Used 20 40 42.5 0 35 0 20 601E:30 SD$12 13] m3 of Storage 1 Used 6 SD$13 (4] m3 of Storage 2 Used2 6 3 51E-30 (a- 3 pts) What is the value of the optimal Z of this problem? (b-2 pts) Which constraint(s) are binding?

Explanation / Answer

a)

Optimal Z = 120* 6 + 170*2 = 1060

b)

A constraint is considered to be binding if changing it also changes the optimal solution. In other words if there is no slack, then the constraint is binding

Raw materials, m3 of storage 1 used are the binding constraints since there is no slack for these two constraints.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

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