Problem 3 (5 marks) Complete the following input/output report. What are the planned and actual backlogs at the end of Period 5? Total Period Planned Input Actual Input Cumulative Variance 1 78 82 2 78 80 3 78 74 4 78 82 5 78 80 X Page 4 of 17 Total Period Planned Output Actual Output Cumulative Variance 1 80 85 2 80 83 3 80 74 4 80 80 80 84 1 2 3 4 5 Period Planned Backlog Actual Backlog 45 45 Total X Problem 4: (5 marks) 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: Part 1166: Setup time = 3 standard hours Run time per piece = 4 standard hours per piece Setup time = 2 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