Question: I am only needing help with steps b-e. Thank you! b. Solve these equations using the Excel Solver. (Leave no cells blank - be certain
I am only needing help with steps b-e. Thank you! 
b. Solve these equations using the Excel Solver. (Leave no cells blank - be certain to enter " 0 " wherever required. Round your answers to the nearest whole number.) c. How much of each constraint or resource is unused? (Leave no cells blank - be certain to enter "O" wherever required. Round your answers to the nearest whole number.) d-1. Would the machines work at capacity? d-2. Will X3 be at maximum sales capacity? No Yes e. Suppose that an additional 150 hours per week can be obtained from the Milling machine by working overtime. The incremental cost would be $5.00 per hour. What would be the allowable increase (from the excel sensitivity report) in overtime when compared to additional hours that can be obtained? (Round "shadow price" to 2 decimal places and the rest to the nearest whole number.) The allowable increase (from the Excel sensitivi b. Solve these equations using the Excel Solver. (Leave no cells blank - be certain to enter " 0 " wherever required. Round your answers to the nearest whole number.) c. How much of each constraint or resource is unused? (Leave no cells blank - be certain to enter "O" wherever required. Round your answers to the nearest whole number.) d-1. Would the machines work at capacity? d-2. Will X3 be at maximum sales capacity? No Yes e. Suppose that an additional 150 hours per week can be obtained from the Milling machine by working overtime. The incremental cost would be $5.00 per hour. What would be the allowable increase (from the excel sensitivity report) in overtime when compared to additional hours that can be obtained? (Round "shadow price" to 2 decimal places and the rest to the nearest whole number.) The allowable increase (from the Excel sensitivi
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
