Solve the following problem with Excel Solver: (Leave no cells blank - be certain to enter "0" wherever required. Round your answers to 2 decimal places.) Minimize Z = 3A + 4B. 4A + 10B > 57 9A +58 59 2B ? 12 Decision for A Decision for B Total cost Resources Used B A manuscturing firm has escontinued production is certain unprofitsble product line. Considerable excess production capacity wes created as a result Management is considering secting this excess capacity to one or more of three products. X, X2, 3rd X3. Machine hour required per unitare MACHINE TYPE M21.ng machine Lath Grinder PRODUCT i 22 A3 5 5 B 5 2 8 6 The available time in machine hours per week MACHINE HOURS PER WEEK Xlling eachines 285 Lathes 552 Grinders The se esseaple estimate they can sell all the units of X, and X2 that can be made. But the sales potential of X3 190 units per week maximum Unit profits for the three products are LINET PROFITS $40 25 22 X2 X .. Se up the equations ther can bezalved to maimize the profiteer week. (Leave no cells blink - be certain to enter "o wherever required.) Maximianz- X1 - X2 + st Ming Lates Grinders Sales X1 + X1 X1 + X1 + 22+ X2 X2 X35 X33 X35 X35 X1, X2, X22 b. Sove these coustions aing the Excel Solver. Leave no ceis blenk - be certain to enter "o" wherever required. Round your answers to the nearest whole number.) Decision for X1 Decision for X2 Decision for X3 Total prot Recouro Ucad Mi Lathes Grinders Sales Dassion for X1 Decision to X2 Decision Total prot Recours Ucad Ming Lates Grinders Sales c. How much of each constraint or resources unused: (Leave no cells blank-be certain to enter "0" wherever required. Round your answers to the nearest whole number.) Hourg Black Variables SI S2 53 54 d-1. Would the machines work at capacity Miling machines Lates Grinders d-2. Will X3 be at maximum sales capacity NO Yes e. Suppose that an additional 100 hours per weex can be obtained from the Grinder by working overtime. The incremental cost would be $1.50 per hour. What would be the slowable increase from the excel sensitivity reports 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 in from the Excel Sensity recortin overtime is the additional hours that can be obtained