answer Q9 to 12 and show all the steps please

318 > fo 3-D CustomAble Designs & D 1 2 1 Materials and Labor Costs 4 5 Hourly Rate $ 10.50 Primary Materials 6 per unit $ 275.00 Additional Materials per 7 0 $ 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 (02) 25 11 Nling Price $ 750.00 $ 450.00 Standard Build 33 Available 350 8 Material constraints Used Labor (hound 537 Primary Materials per 60 unit 88 70 Estimated Max Demand 27 45 13 1,038 1100 Additional Materials (or) Custom Builds Standard Builds Totals 14 15 16 17 18 Revenue 19 20 Costs 21 Labor 22 Primary Materials 23 Additional Materials 24 25 Profits 26 27 Saved Solver Model 29 30 31 RecentCustomers MaximizeProfits + 8 8 9 8 10 CO In the cell range E2:E17, insert text functions to display only the last name from the left side of the clean names in column C. The names should be displayed in proper case and not include any extra spaces. Adjust the column widths so that all data are visiblemi 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 coll B11. Copy the formula over to cell C18 to calculate the revenue from standard wheelchalrs. In cell B21, calculate the costs of labor for custom-designed wheelchalrs by multiplying the hourly rate in cell B5 by the number of hours necessary to create a custom wheelchair in cel 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. 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. 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:023 and cell D25. 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:011. 11 8 12 8 13 5