please show all excel commands

A D E F H 1 J L M N 0 P R R 3-D CustomAble Designs 1 2 3 Materials and Labor Costs 4 5 Hourly Rate $ 10.50 Primary Materials 6 per unit $ 275.00 Additional Materials per 7 DZ $ 2.15 8 9 10 Custom Build 11 of Units Produced 27 12 Resources Per Unit Custom Build Standard Build Labor hours) 15 4 Primary Materials per unit 1 1 Additional Materials (az! 25 11 Selling Price $ 250.00 $ 450.00 Standard Build 33 Material Constraints Used 537 Available 350 Labor hours) Primary Materials per unit Estimated Max Demand 27 45 60 70 13 1,038 1100 Additional Materials (oz) Custom Builds Standard Builds Totals 14 15 16 17 18 Revenue 19 20 Costs 21 Labor 22 Primary Materials 23 Additional Moteriols 24 25 Profits 26 27 Saved Salver Model 28 29 30 31 32 33 34 35 9 8 On the MaximizeProfits worksheet, complete the following so that a linear Solver model can be created. In cell B18, calculate the revenue of custom-designed wheelchairs, using the selling price in cell E8 and the number of units produced in cell B11. Copy the formula over to cell C18 to calculate the revenue from standard wheelchairs. 10 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 E5 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. 11 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. 12 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. 13 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. Created On: 07/05/2019 1 YO_Excel16_BU05_PS2_v2 Grader - Instructions E Step Instructions 14 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. 15 Use the GRG Nonlinear method and save the Solver model for use later, starting in cell A28. 16 Run Solver and create a Solver Answer Report. 17 Save the workbook, exit Excel, and then submit your file as directed by your instructor. A D E F H 1 J L M N 0 P R R 3-D CustomAble Designs 1 2 3 Materials and Labor Costs 4 5 Hourly Rate $ 10.50 Primary Materials 6 per unit $ 275.00 Additional Materials per 7 DZ $ 2.15 8 9 10 Custom Build 11 of Units Produced 27 12 Resources Per Unit Custom Build Standard Build Labor hours) 15 4 Primary Materials per unit 1 1 Additional Materials (az! 25 11 Selling Price $ 250.00 $ 450.00 Standard Build 33 Material Constraints Used 537 Available 350 Labor hours) Primary Materials per unit Estimated Max Demand 27 45 60 70 13 1,038 1100 Additional Materials (oz) Custom Builds Standard Builds Totals 14 15 16 17 18 Revenue 19 20 Costs 21 Labor 22 Primary Materials 23 Additional Moteriols 24 25 Profits 26 27 Saved Salver Model 28 29 30 31 32 33 34 35 9 8 On the MaximizeProfits worksheet, complete the following so that a linear Solver model can be created. In cell B18, calculate the revenue of custom-designed wheelchairs, using the selling price in cell E8 and the number of units produced in cell B11. Copy the formula over to cell C18 to calculate the revenue from standard wheelchairs. 10 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 E5 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. 11 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. 12 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. 13 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. Created On: 07/05/2019 1 YO_Excel16_BU05_PS2_v2 Grader - Instructions E Step Instructions 14 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. 15 Use the GRG Nonlinear method and save the Solver model for use later, starting in cell A28. 16 Run Solver and create a Solver Answer Report. 17 Save the workbook, exit Excel, and then submit your file as directed by your instructor