Question: Q3. The LP formulation and corresponding Excel Sensitivity Report for the Blending Problem of LP Applications chapter are provided below. Min800T1+400T2+600T3+500T4s.t.10T1+3T2+8T3+2T4590T1+150T2+75T3+175T410045T1+25T2+20T3+37T430T1+T2+T3+T4=1AllTi0(ARequirement)(BRequirement)(CRequirement)(Balance)(Nonnegativity) Variahle Cells Conetrainte Answer

 Q3. The LP formulation and corresponding Excel Sensitivity Report for the

Q3. The LP formulation and corresponding Excel Sensitivity Report for the Blending Problem of LP Applications chapter are provided below. Min800T1+400T2+600T3+500T4s.t.10T1+3T2+8T3+2T4590T1+150T2+75T3+175T410045T1+25T2+20T3+37T430T1+T2+T3+T4=1AllTi0(ARequirement)(BRequirement)(CRequirement)(Balance)(Nonnegativity) Variahle Cells Conetrainte Answer the following questions (Each has 5% contribution): a. What is the optimal solution and the cost represented by the objective function? b. What is the impact on cost if we increase B requirement by 10 units? c. What is the impact on cost if we decrease C requirement by 3 units? d. What is the impact on cost if we decrease C requirement by 8 units? e. It's known that we can decrease C requirement by 2 units at an additional cost of $2 per unit. What would be the impact on the objective function value? f. If the objective function coefficient of T3 increases by $50, will the optimal solution change? What about the value of the objective function

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!