2-Sensitivity Analysis (30 pls The Excel Sensitivity Report in the table below i

Question

2-Sensitivity Analysis (30 pls The Excel Sensitivity Report in the table below is for the fallowing LP model. Max Z-5x +9x2+2x Subject to: (C1) (C2) (C3) Variable Cells Finn! Reduced Objective Allowable Allowable Name ValueCost Coefficient Incrense Decrease x2 10 0 0 3.5 0.666666667 4.4 4.4 1E 30 Constraints Final Shodow Constraint AllowobleAllowoble Side Incrense Name ValuePriceR.H. C1 C2 951495 3.521428573ES 03 15 8 333333333 9D 1E 30 Determine the optimum colution of the model and the objective function value fram the abave table. (6 points) a) bl If you are able to increaze the level of the reatrictions Icomstraint RHS- in uP model which constraint(s) do you consider to change? Why? 16 paint:) Determine the objective function value when weincreasc the constraint 38C3) RHS from 90 t 200,6 points d Determine the objective function valuethe proft of increaaed from 9 to 11 Explain 6 90 16 painte)

Explanation / Answer

a) The objective function value=5 x 15 + 9 x 10+2 x 0=165

Since the allowable increase for x1 is 0.4, the new value=15+0.4=15.4

New X2=10+3.5=13.5

New X3=0+4.4=4.4

Optimal Solution= 207.3

b) I would change the constraint 2 (C2) because it has the highest shadow price and changing it will make the obejctive function better.

c) The objective function value will remain unchanged because the shadow price is 0.

d) If the profit is increased from 9 to 11, the objective function value would be:

5 x 15+11 x 10 +2 x 0=185

e)The objective function value would decrease by 1.4 x 90=126 units

Related Questions

Navigate

• Browse (All)
• Browse 2
• Subjects

---

---

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