complete this assignment using the Windows version of Excel. ATC Inc. is a manufacturing company that produces industrial valves. As the operations manager, you need to determine the production schedule (Number Produced) for manufacturing valves in the new 102 Series, which is used in oil refineries. Producing the 102 Series Valves is a three-part process. During the casting phase, the body of the valve and some of the attaching pieces are created; during the machining phase, the casting surfaces are finished and the inner valve flange is created; and during the final phase, the valves are assembled and inspected. The plant manager has provided you with a data file that contains the production times for each production phase, and the unit cost and markup for each 102 Series valve. The plant manager also informed you that your time is limited to 500 hours in the casting department, 500 hours in the machining department, and 100 hours in the final assembly department (for a total limit of 1,100 hours for Total Assembly). The workbook also includes the set-up costs associated with a production run for each valve; you must account for these costs in the profit amounts for each valve