Question: Variable Cells Cell Name $B$3 Variables P $C$3 Variables s $D$3 Variables V $E$3 Variables C Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase

Variable Cells Cell Name $B$3 Variables P $C$3Variable Cells Cell Name $B$3 Variables P $C$3Variable Cells Cell Name $B$3 Variables P $C$3Variable Cells Cell Name $B$3 Variables P $C$3

Variable Cells Cell Name $B$3 Variables P $C$3 Variables s $D$3 Variables V $E$3 Variables C Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 0 -2 3 2 1E+30 1200 0 5 1E+30 1 0 -1 4 1 1E+30 0 -3 2 3 1E+30 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $F$6 Denim (sqm) 720 0 1000 1E+30 280 $F$7 Cutting (min) 2400 0 3000 1E+30 600 $F$8 Sewing (min) 3600 0 5000 1E+30 1400 $F$9 Packaging (min) 1200 5 1200 300 1200 Question 2 (3 points) Saved Suppose that 200 square meters of denim is found to be damaged and cannot be used. What is the impact on total profits? Profit will increase O Profit will not change Profit will decrease It is uncertain how profit will change Saved Question 3 (3 points) Suppose employees on the packaging line are willing to work overtime. The added cost will be $30 per hour. Should April Fashions accept their offer? NO, one hour of packaging time generates an additional $5 which is less than the cost of paying additional $30 per hour for packaging. YES, one hour of additional packaging time generates an additional $6000 which is more than the cost of paying additional $30 per hour for packaging. NO because this constraint is already binding. YES, one hour of additional packaging time generates an additional $300 which is more than the cost of paying additional $30 per hour for packaging. The skirts have met with unexpectedly high interest and it has been possible to increase the price such that the profit is now $10 per skirt. Does the production quantity of the skirts change? Does the total profit change? The increase per skirt profit is NOT within the allowable increase range. Therefore, the optimal solution and optimal value does not change. The increase per skirt profit is within the allowable increase range. Therefore, the optimal solution and the optimal value do not change. The increase per skirt profit is within the allowable increase range. Therefore, the optimal solution does not change. Profit, however, will increase by $12,000. The increase per skirt profit is within the allowable increase range. Therefore, the optimal solution does not change. Profit, however, will increase by $6,000

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!