Section B (Offline Assessment) Week Requirements MPS Inventory from Previous Week Net Inventory Before MPS Projected Inventory 1 2 3 4 5 6 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. 7 8 9 10 11 12 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) b. Main objective of aggregate planning frequently is to minimize total cost over the planning horizon. Based on Table 3.3 and 3.4 below, use chase strategy by completing Table 3.5. Table 3.0 1 2 3 4 5 6 7 9 10 11 Table 3.3 Week Forecast Orders 8 15 12 15 5 5 5 5 5 5 15 15 15 15 5 Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total Forecast 100 150 250 400 250 50 90 160 260 390 240 60 2400 3 2 18 9 Table 3.1 Table 3.4 Costs Output -Regular time Week Forecast Orders On-hand inventory MPS ATP -Hiring -Firing RM500.00 per car RM200.00 per worker RM100.00 per worker RM10.00 per car per period on average inventory RM20.00 per car per period Inventory Back orders Note: There are 20 workers and each can produce 10 cars per period, start with zero inventories on hand in the first period, and the planned ending inventory is zero. (10 Marks) Table 3.5 Month Jan Feb Mar Chase Strategy with hiring and firing Apr May Jun Jul Aug 400 250 50 90 160 Sep Oct Nov Dec Total Forecast 100 150 250 260 390 240 60 2400 Output Regular Overtime Subcontract Output-Forecast Inventory Beginning Ending Average Backlog Costs Regular Overtime Subcontract Hire/Layoff Inventory Backorders Total Section B (Offline Assessment) Week Requirements MPS Inventory from Previous Week Net Inventory Before MPS Projected Inventory 1 2 3 4 5 6 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. 7 8 9 10 11 12 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) b. Main objective of aggregate planning frequently is to minimize total cost over the planning horizon. Based on Table 3.3 and 3.4 below, use chase strategy by completing Table 3.5. Table 3.0 1 2 3 4 5 6 7 9 10 11 Table 3.3 Week Forecast Orders 8 15 12 15 5 5 5 5 5 5 15 15 15 15 5 Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total Forecast 100 150 250 400 250 50 90 160 260 390 240 60 2400 3 2 18 9 Table 3.1 Table 3.4 Costs Output -Regular time Week Forecast Orders On-hand inventory MPS ATP -Hiring -Firing RM500.00 per car RM200.00 per worker RM100.00 per worker RM10.00 per car per period on average inventory RM20.00 per car per period Inventory Back orders Note: There are 20 workers and each can produce 10 cars per period, start with zero inventories on hand in the first period, and the planned ending inventory is zero. (10 Marks) Table 3.5 Month Jan Feb Mar Chase Strategy with hiring and firing Apr May Jun Jul Aug 400 250 50 90 160 Sep Oct Nov Dec Total Forecast 100 150 250 260 390 240 60 2400 Output Regular Overtime Subcontract Output-Forecast Inventory Beginning Ending Average Backlog Costs Regular Overtime Subcontract Hire/Layoff Inventory Backorders Total
