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 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
Get step-by-step solutions from verified subject matter experts
