PLEASE CAN YOU ANSWER IT IN A WAY CAN TYPE IT IN THE TABLE. PLEASE DO NOT ANSWER IT BY SENDING AN EXCLE WORKSHEET. PLEASE ANSWER IT EXACTLY HOW THE TABLE IS

A company produces two very similar products that go through a three-step sequence of fabrication, assembly, and packaging. Each step requires one day for a lot to be completely processed and moved to the next department. Processing requirements for the departments (hours per unit) are Product A B FABRICATION Labor Machine 2 1 1 ASSEMBLY Labor Machine 1.5 1 1 1 PACKAGING Labor Machine 1 .5 1.5 .5 Department capacities are all 700 hours of labor and 500 hours of machine time, except Friday, when capacities are 200 hours for both labor and machine time. The following production schedule is for next week: Mon Product B Units scheduled to be produced Tues Wed Thurs Fri 200 400 100 300 100 300 200 200 200 200 Click here for the Excel Data File Develop a production schedule for each department that shows the capacity requirements for each product and the total load for each day. Ignore changeover time. Note: The Load of Labour and Machine may exceed the Capacity. (Round your answers to the nearest whole number.) FABRICATION ASSEMBLY Labor Machine PACKAGING Labor Machine Day Product Labor Machine ASSEMBLY Product PACKAGING Labor Machine FABRICATION Labor Machine 400 200 Labor Day Mon Machine A B 300 300 Load Capacity Tue A B Load Capacity Wed A A B Load Capacity Thurs A B Load Capacity Fri A B Load Capacity