Problem 3 (5 marks) Complete the following input/output report. What are the planned and actual backlogs at the end of Period 5? 1 4 Total Period Planned Input Actual Input Cumulative Variance 78 80 2 78 84 3 78 74 78 82 5 78 80 X 3 Total 1 80 83 2 80 Period Planned Output Actual Output Cumulative Variance 80 4 80 80 80 84 82 78 X 1 2 3 4 5 Period Planned Backlog Actual Backlog 45 45 Total X X Using the information in the following route file, open order file, and MRP planned orders, calculate the load on the work center. (5 marks) Routing Part 2345: Setup time = 2 standard hours Run time per piece = 4 standard hours per piece Part 1166: Setup time = 3 standard hours Run time per piece = 0.5 standard hour per piece Open Orders for Parts 1 2 Planned Orders for Parts 1 2 3 Week 3 Part 2345 Part 1166 14 16 9 6 6 5 5 4 5 10 10 15 2. 3 Released Load Load Report Week >>> 1 2345 1166 2345 1166 Planned Load Total Load