Question: I have already solved the linear programming model using the Wyndoor method and found the new profit for this problem: Suppose that the estimates for
I have already solved the linear programming model using the Wyndoor method and found the new profit for this problem:
Suppose that the estimates for the unit profits for the two new products now have been revised to $600 profit for the doors and $300 profit for the windows.
The new profit is: 3,600

I don't know what the solver results page and sensitivity report for it looks like and how to interpret the allowable increase and decrease for both the variable cells (doors and windows produced) and the constraints (Plants 1,2,3) for the problem above
X x Wyndor Glass Co. Product-Mix Problem G H E F Wyndor Glass Co. Product-Mix Problem Doors Windows Unit Profit $300 $500 Hours Hours Used Per Unit Produced Used Plant 1 2 Plant 2 0 2 12 Plant 3 3 18 Range Name Hours Available Hours Used Hours UsedPerUnitProduced TotalProfit UnitProfit Units Produced Hours Available 4 12 18 Cells G7:G9 E7:E9 C7:09 G12 04:04 C12:012
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
