6 8 On the MaximizeProfits worksheet, complete the following so that a linear Solver model can be created to maximize profits for 3-D CustomAble Designs. In cell B18, calculate the revenue of custom-designed wheelchairs, using the selling price in cell F8 and the number of units produced in cell B11. Copy the formula over to cell C18 to calculate the revenue from standard wheelchairs. 7 8 In cell B21, calculate the costs of labor for custom-designed wheelchairs by multiplying the hourly rate in cell B5 by the number of hours necessary to create a custom wheelchair in cell F5 by the number of custom wheelchairs produced in cell B11. Use appropriate cell referencing so that the formula can be copied down to cell B23 to calculate the costs of primary and additional materials for custom wheelchairs and can be copied over to calculate all costs for standard wheelchairs. 8 8 In cell B25, calculate the profit of custom wheelchairs by subtracting the total costs from the revenue. Copy the formula over to cell C25 to calculate the profit from standard wheelchairs. 9 8 In cell D18, calculate the total revenue by adding the revenue from custom and standard wheelchairs. Copy and paste the formula into the cell range D21:D23 and cell D25. 10 5 Begin creating a Solver model by setting the objective to maximize the total profit in cell D25. Set the changing cells to be the number of units to produce in the cell range B11:C11. 11 15 Create a constraint that will ensure that the number of units to produce will be whole numbers. Create a constraint that will ensure that the number of units produced will not exceed the maximum expected demand in the cell range B13:C13. Create a constraint that will ensure that the used resources in the cell range F12:F14 will not exceed the available resources in the cell range H12:H14. 12 Use the GRG Nonlinear method and save the Solver model for use later, starting in cell A28. 6 13 Run Solver and create a Solver Answer Report. 8 14 Save and close Excel_BU05_PS2_ProductMix. Exit Excel. Submit your files as directed. 0 0 A B D E F G H 3-D CustomAble Designs& D 1 2 3 Materials and Labor Costs 4 5 Hourly Rate $ 12.10 Primary Materials 6 per unit $ 315.00 Additional Materials 7 per oz $ 2.50 8 Resources Per Unit Custom Build Standard Build Labor (hours) 15 4 Primary Materials per unit 1 1 Additional Materials (oz) 25 11 Selling Price $ 750.00 $ 450.00 00 9 10 Custom Build Standard Build 27 33 11 # of Units Produced Available 350 12