Write the formulas that calculates the total production time used for casting, machining, and final assembly. Enter a mathematical formula in the objective cell, and then enter formulas to link the objective cell with the variable cells.Add sample values to the variable cells to ensure that your worksheet is set up correctly and produces the expected results. $($Hint: Use a $1$ for each valve in the units produced.$)2.$ Create a constraints table in the worksheet that identifies the constraints in this problem. Name the relevant cells in the constraints table, production table, number produced, and profit$\mathrm{.}3.$ Use Solver to determine the optimal combination of valves to build to maximize profit$\mathrm{.}4.$ Produce an answer report of your solution. Which constraints could you modify to maximize the total profit?Place your recommendation in a text box on the answer report worksheet$\mathrm{.}5.$ Save your solution as Scenario $1\mathrm{.}6.$ Modify the constraints in your constraints table and in Solver that you determined world further improve the solution. Did you solution accomplish the goals you identified? What other changes can you recommend to maximize the total profit? Place your recommendations n a text box on the answer report Worksheet