1. Open the ATCValve.xlsx workbook from the Chapter 9 folder, and then save the file as ATCValve Production.xlsx.

2. Write the formulas that calculate the total production time used for casting, machin- ing, 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.

3. Create a constraints table in the worksheet that identifies the constraints in this problem.

4. Use Solver to determine the optimal combination of valves to build to maximize profit.

5. Produce an answer report of your solution. Which constraints could you modify to maximize the total profit? Place your recommendations in a text box on the answer report worksheet

6. Save your solution as Scenario 1.

7. Modify the constraints in your constraints table and in Solver that you determined would further improve the solution, and then run Solver again. Save this scenario as Scenario 2. Add a comment to the scenario describing the constraints you modified and why you chose to do so.

8. Produce an answer report of your revised solution. Did your solution accomplish the goals you identified in Step 5? What other changes can you recommend to maximize the total profit? Place your recommendations in a text box on the answer report worksheet.

9. Save and close the ATCValve Production.xlsx workbook.

\begin{tabular}{ll|lll} k5 & v^ & & x \\ \end{tabular} \begin{tabular}{ll|lll} k5 & v^ & & x \\ \end{tabular}