Creating a Production Plan for ATC Inc. (ATC Valve Production) The excel problem involves using solver and constraints to determine the optimal combination of valves to build to maximize profits.

ATC Valve Production Production Time per Unit (in Hours) Item Valve 102-45 Valve 102-46 Valve 102-47 Set-Up Cost Casting Machining Final Assembly $ 950.00 1.20 1.70 0.30 $ 1,000.00 3.20 1.50 0.30 $ 1,000.00 3.00 1.20 0.30 Time Used Constraints C9 D9 E9 H5:H7 H5:H7 H5:H7 = =