Hondas Engine Co., plant manager had the following record of Master Production Schedule (MPS) for 2 different engine types they manufacture (X and Y). Total standard hours to produce X is 1.55 hours and for Y it is 5.33 hours. Historical utilization of work centers that are required to make these two products are also exported from the ERP system and given below.

Q4. Hondas Engine Co., plant manager had the following record of Master Production Schedule (MPS) for 2 different engine types they manufacture (X and Y). Total standard hours to produce X is 1.55 hours and for Y it is 5.33 hours. Historical utilization of work centers that are required to make these two products are also exported from the ERP system and given below. MPS - Hondas Engine Co. Week 14 24 34 x 104 104 152 ye 254 254 202 Work Center Utilization 100 20% 200 45% 300 35% 4 153 202 5 4 154 | 25 l de a. Calculate the total hours required for making X and Y for the following 5 weeks. Show your calculations and fill the table. (10 points) Week Total Hours Required b. Use Capacity Planning Using Overall Factors (CPOF) technique to obtain the rough estimate of capacity requirements (in terms of hours) for each work center during Week 1 and fill the table. Show your calculations next to the table. (15 points) Week 12 Week 2 Week 3 Week 4 Week 5 wce 100 200 300 Q4. Hondas Engine Co., plant manager had the following record of Master Production Schedule (MPS) for 2 different engine types they manufacture (X and Y). Total standard hours to produce X is 1.55 hours and for Y it is 5.33 hours. Historical utilization of work centers that are required to make these two products are also exported from the ERP system and given below. MPS - Hondas Engine Co. Week 14 24 34 x 104 104 152 ye 254 254 202 Work Center Utilization 100 20% 200 45% 300 35% 4 153 202 5 4 154 | 25 l de a. Calculate the total hours required for making X and Y for the following 5 weeks. Show your calculations and fill the table. (10 points) Week Total Hours Required b. Use Capacity Planning Using Overall Factors (CPOF) technique to obtain the rough estimate of capacity requirements (in terms of hours) for each work center during Week 1 and fill the table. Show your calculations next to the table. (15 points) Week 12 Week 2 Week 3 Week 4 Week 5 wce 100 200 300