A-App 0 25 points eBook Print References Problem A-3 (Algo) Saved Help A manufacturing rm has discontinued production ofa certain unprofitable product line. Considerable excess production capacity was created as a result. Management is considering devoting this excess capacity to one or more of three products: X1, X2, and X3. Machine hours required per unit are MACHINE Milling Lathe Grinder The available time in machine hours per week is Mi lling machines Lathes Grinders TYPE machine PRODUCT X2 X3 5 7 7 0 0 4 MACHINE HOURS PER WEEK 700 602 80 The salespeople estimate they can sell all the units of X1 and X2 that can be made' But the sales potential of X3 is 90 units per week maximum. Unit profits for the three products are X1 X2 X3 UNIT PROFITS $ 39 30 29 Save & Exit Submit A-App 0 2.5 points eBook Print References Saved Help a. Set up the equations that can be solved to maximize the prot per week. (Leave no cells blank - be certain to enter "0" wherever required.) s ,t Milling Lathes Grinders Sales X1, X2, X3 2 0 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.) Decision for X1 Save 8: Exit Submit A-App 0 2.5 points eBaok Print Reierences Saved 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.) Decision for X1 Decision for X2 Decision for X3 Total prot Used Ming _ Grinders _ sales _ c. How much of each constraint or resource is unused? (Leave no cells blank - be certain to enter "0" wherever required. Round your answers to the nearest whole number.) Help Save & Exit Submit 1 c. How much of each constraint or resource is unused? (Leave no cells blank - be certain to enter "0" wherever required. Round your answers to the nearest whole number.) 2'5 Slack points Variables Hours S1 82 eBook S3 Print 34 References d-1. Would the machines work at capacity? Milling machines Grinders A-App 0 Saved Help Save& Exit Submit Check my work 2.5 points d-2. Will X3 be at maximum sales capacity? eBook Print 0 No References 0 Yes e. Suppose that an additional 250 hours per week can be obtained from the Grinder by working overtime. The incremental cost would be $1.75 per hour. What would be the allowable increase (from the excel sensitivity report) in overtime when compared to additional 1ours 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 sensitivity report) in overtime is Ithe additional hours that can be obtained