Please answer

4. Aggregate planning (AP) and master production scheduling (MPS) are two important functions in Manufacturing Resource Planning (MRP II). Proper interfaces between the two functions will greatly enhance the effectiveness of the whole manufacturing planning and control (MPC) system. a. Based on Table 3.0, you as an operation manager are required to prepare MPS for week I until week 12. There is no beginning inventory. Use Table 3.1 and Table 3.2 to determine the projected on-hand inventory, the NIPS, and the uncommitted inventory (available-to-promise, ATP). Production lot-size is 30 units. (10 Marks) Table 3.0 4 5 Week Forecast Orders 1 5 5 2 5 3 3 5 2 5 10 11 12 15 15 15 5 67 89 5 15 15 15 18 9 5 Table 3.1 Week Forecast Orders On-hand inventory MPS ATP Table 3.2 Week Requirements MPS Inventory from Previous Week Net Inventory Before MPS Projected Inventory 2 3 4 5 6 7 8 9 10 11 12 4. Aggregate planning (AP) and master production scheduling (MPS) are two important functions in Manufacturing Resource Planning (MRP II). Proper interfaces between the two functions will greatly enhance the effectiveness of the whole manufacturing planning and control (MPC) system. a. Based on Table 3.0, you as an operation manager are required to prepare MPS for week I until week 12. There is no beginning inventory. Use Table 3.1 and Table 3.2 to determine the projected on-hand inventory, the NIPS, and the uncommitted inventory (available-to-promise, ATP). Production lot-size is 30 units. (10 Marks) Table 3.0 4 5 Week Forecast Orders 1 5 5 2 5 3 3 5 2 5 10 11 12 15 15 15 5 67 89 5 15 15 15 18 9 5 Table 3.1 Week Forecast Orders On-hand inventory MPS ATP Table 3.2 Week Requirements MPS Inventory from Previous Week Net Inventory Before MPS Projected Inventory 2 3 4 5 6 7 8 9 10 11 12