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 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: 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 Labor and Machine may exceed the Capacity. (Round your answers to the nearest whole number.) \begin{tabular}{|c|c|c|c|c|c|c|} \hline & \multicolumn{2}{|c|}{ FABRICATION } & \multicolumn{2}{c|}{ ASSEMBLY } & \multicolumn{2}{c|}{ PACKAGING } \\ \hline Product & Labor & Machine & Labor & Machine & Labor & Machine \\ \hline A & 2.0 & 1.0 & 1.5 & 1.0 & 1.0 & 0.5 \\ \hline B & 1.0 & 1.0 & 1.0 & 1.0 & 1.5 & 0.5 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \cline { 2 - 6 } & \multicolumn{5}{|c|}{ UNITS SCHEDULED TO BE PRODUCED } \\ \hline Product & Mon & Tue & Wed & Thu & Fri \\ \hline A & 200 & 400 & 100 & 300 & 100 \\ \hline B & 300 & 200 & 200 & 200 & 200 \\ \hline \end{tabular}