o 1 2 3 4 5 6 7 70 75 60 80 70 30 5 0 Master Production Schedule Period Demand Customer Orders Projected On Hand Inventory (POHI) 160 Net Inventory before MPS MPS Receipt MPS Start Available-to-promise (ATP) 50 55 105 105 0 0 60 70 0 0 70 10 60 -70 130 20 0 0 0 35 35 0 100 880 -40 100 -80 150 0 || 150 75 80 0 145 120 - A company produces an end item 'F'. One unit of item F can be made by assembling 1 unit of X, 2 units of Y, and 3 units of Z. Each X is made of 2 units of Z and 2 units of A; each Y is assembled using 3 units of B and 1 unit of C. On-hand inventories are 90 units of X and 150 units of Z. Scheduled receipts are 50 units of X at the beginning of week 1, 200 units of Z at the beginning of week 2, and 50 units of C at the beginning of week 1. Lead times for X and C are one week, and lead times for other components are two weeks. Final assembly of F requires one week. 6. Use your master production schedule in Table 1 and your MRP schedule for the subassembly X to develop a material requirement plan (MRP) for component Z using lot size ordering with a lot size of 650. [4 marks] Week 1 2 3 4 5 6 7 8 Lead time: 2 weeks On hand: 150 Z Gross Requirement Scheduled Receipts Projected On Hand Net Requirements PO Receipts PO Releases