Question 2 30 pts Adjustable Cells Cell $B$2 $C$2 $D$2 Name Number of units P Number of units S Number of units T Final Value 1000 200 0 Reduced Cost 0 ? -0.4 Objective Coefficient 3 5.5 4 Allowable Increase 2.5 1E+30 0.4 Allowable Decrease 1E+30 0.5 1E+30 Constraints Cell $E$7 $E$8 $E$9 $E$10 Name Cut & Dye time Sew time Inspect & Pack time Min. Polos reqd. Final Value 14000 ? 3800 Shadow Price ? 3.7 ? -2.5 Constraint R.H. Side 18000 18000 9000 1000 Allowable Increase ? 6000 ? 200 Allowable Decrease ? 3000 ? 1000 Use the Sensitivity Report (for the same Dukes Wear problem described earlier) to answer the questions below. Recall that the there were limited time available in each department. The items with "?" will be addressed in some of the questions. Write the question number and your answer (comma to separate multiple answers). 1. The expected total profit is $_ 2. The reduced cost for sweatshirts is 3. It will be profitable to produce T-shirts when 4. minutes of Sew time are used. Cell $E$7 $E$8 $E$9 $E$10 Name Cut & Dye time Sew time Inspect & Pack time Min. Polos reqd. Final Value 14000 ? 3800 ? Shadow Price ? 3.7 ? -2.5 Constraint R.H. Side 18000 18000 9000 1000 Allowablo Increase ? 6000 ? 200 Allowablo Decrease ? 3000 ? 1000 Use the Sensitivity Report (for the same Dukes Wear problem described earlier) to answer the questions below. Recall that the there were limited time available in each department. The items with "?" will be addressed in some of the questions. Write the question number and your answer (comma to separate multiple answers). 1. The expected total profit is $ 2. The reduced cost for sweatshirts is 3. It will be profitable to produce T-shirts when 4. minutes of Sew time are used. 5. Shadow price for Inspect & Pack time is 6. Inspect & Pack time has allowable decrease of and allowable increase of 7. If the profit contribution for Polos increased to $5, then the number of polos produced should be 8. If the company revised the minimum requirement for Polos to 1100, total profit will (answer must include if same/increase/decrease, and by what $ amount). 9. If there is a labor strike for 70 hours (i.e. 4200 minutes) by employees in the Cut & Dye department, then Question 2 30 pts Adjustable Cells Cell $B$2 $C$2 $D$2 Name Number of units P Number of units S Number of units T Final Value 1000 200 0 Reduced Cost 0 ? -0.4 Objective Coefficient 3 5.5 4 Allowable Increase 2.5 1E+30 0.4 Allowable Decrease 1E+30 0.5 1E+30 Constraints Cell $E$7 $E$8 $E$9 $E$10 Name Cut & Dye time Sew time Inspect & Pack time Min. Polos reqd. Final Value 14000 ? 3800 Shadow Price ? 3.7 ? -2.5 Constraint R.H. Side 18000 18000 9000 1000 Allowable Increase ? 6000 ? 200 Allowable Decrease ? 3000 ? 1000 Use the Sensitivity Report (for the same Dukes Wear problem described earlier) to answer the questions below. Recall that the there were limited time available in each department. The items with "?" will be addressed in some of the questions. Write the question number and your answer (comma to separate multiple answers). 1. The expected total profit is $_ 2. The reduced cost for sweatshirts is 3. It will be profitable to produce T-shirts when 4. minutes of Sew time are used. Cell $E$7 $E$8 $E$9 $E$10 Name Cut & Dye time Sew time Inspect & Pack time Min. Polos reqd. Final Value 14000 ? 3800 ? Shadow Price ? 3.7 ? -2.5 Constraint R.H. Side 18000 18000 9000 1000 Allowablo Increase ? 6000 ? 200 Allowablo Decrease ? 3000 ? 1000 Use the Sensitivity Report (for the same Dukes Wear problem described earlier) to answer the questions below. Recall that the there were limited time available in each department. The items with "?" will be addressed in some of the questions. Write the question number and your answer (comma to separate multiple answers). 1. The expected total profit is $ 2. The reduced cost for sweatshirts is 3. It will be profitable to produce T-shirts when 4. minutes of Sew time are used. 5. Shadow price for Inspect & Pack time is 6. Inspect & Pack time has allowable decrease of and allowable increase of 7. If the profit contribution for Polos increased to $5, then the number of polos produced should be 8. If the company revised the minimum requirement for Polos to 1100, total profit will (answer must include if same/increase/decrease, and by what $ amount). 9. If there is a labor strike for 70 hours (i.e. 4200 minutes) by employees in the Cut & Dye department, then