Minimizing Profit

Ajax Mobility produces bicycles with three different speeds: three-speed, five-speed, and ten-speed. Each bicycle undergoes a production process that spans three departments: fabrication, painting and plating, and final assembly. The manufacturing data needed for analysis is provided in the table below. Using Excel Solver, determines how many bicycles from each bicycle type the company should manufacture per day to maximize its profit. Be sure to select Keep the Solver solution and generate an answer report.

Excel Solver Task (a) Open a NEW workbook and save it as Ajax Moblities.xlsx. Insert a Documentation worksheet and add an appropriate title for the workbook in cell A1. In cell B3, enter your name. In cell B4, enter your student number. In cell B5, enter the completion date of your assignment, and in cell B6, enter a sentence to describe the purpose of the workbook.

(b) Add a NEW worksheet and formulate and enter the above optimization problem using a new worksheet.

(c) Enter Solver Parameters (Set Objective, To, By Changing Variable Cells and Subject to the Constraints)

(d) Solve the problem. Be sure to select Keep the Solver Solution and generate an Answer report. Note: If you get an internal memory error message, remove Solver as an add-in, close the workbook, open the workbook, add Solver in again, and finish using Solver.

(e) Using the same worksheet, answer the following questions. i. How many of each type of bicycle the company should produce to maximize profit? ii. What is the maximum profit? (rounded your answer to the nearest cent)

(f) Format your workbook as desired (Headings, Font, Fill color, Number format...) (g) Save and close your workbook.

I need the each step with a excel sheet answer for examples put the answers and steps in excel sheet and upload the photo so its easy for me to do please and thank you

\begin{tabular}{|l|c|c|c|c|} \hline \multirow{2}{*}{ Departments } & \multicolumn{3}{|c|}{ Labor Hours per Bicycle } & maximum Labor-Hour \\ \cline { 2 - 4 } & Three-Speed & Five-Speed & Ten-Speed & Available per Day \\ \hline Fabrication & 2.5 & 4 & 5 & 120 \\ \hline Painting \& Plating & 5 & 3.5 & 5 & 130 \\ \hline Final Assembly & 4 & 3 & 5.5 & 120 \\ \hline Profit per bicycle & $80.00 & $70.00 & $100.00 & \multicolumn{1}{|c}{} \end{tabular}