Question: PLEASE ANSWER THIS EXACTLY HOW IT GOES IN THE CHART. This is my second time asking this question, please please exactly answer it how I
PLEASE ANSWER THIS EXACTLY HOW IT GOES IN THE CHART. This is my second time asking this question, please please exactly answer it how I request. I will like your answer if it is exactly like the chart, but I will dislike if it is in a weird format and forgetting the LOAD and CAPACITY blocks like the last time! Please show work. Thank you!
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 FABRICATION Labor Machine 2 1 1 ASSEMBLY Labor Machine 1.5 1 PACKAGING Labor Machine 1 1.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! Units scheduled to be produced Product Mon Ned Thurs Tri 200 400 100 300 200 200 200 200 Tues 100 300 Click here for the Excel Data Fille 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) Day ASSEMBLY Machine PACKAGING Labor Machine Labor Mon Product A B Load Capacity FABRICATION Labor Machine 400 200 300 300 ASSEMBLY Labor Machine PACKAGING Labor Machine Day Mon FABRICATION Labor Machine 200 300 300 Product B Load Capacity 400 Tue A 800 800 400 400 200 200 B Load Capacity Wed A B Load Capacity Thurs B Load Capacity Fr B Load Capacity

Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
