exhibit 9.10 Homework 1 Continue MRP explosion process until finish (for week 10 to week 17) A Master Schedule to Satisfy Demand Requirements as Specified in Exhibit 9.9 Week 9 10 11 12 13 14 15 16 17 Meter A 1,250 850 550 Meter B 470 360 560 Subassembly D 270 250 exhibit 9.12 Number of Units On-Hand and Lead Time Data That Would Appear on the Inventory Record File ITEM ON-HAND INVENTORY A 50 B D 60 40 200 LEAD TIME (WEEKS) exhibit 9.13 Item A LT = 2 weeks On-hand = 50 Safety stock=0 Order qty = lot-for-lot B Projected available balance, Projected available - balance,-1 Gross Scheduled requirements, receipts, + Planned- + order receipts, Material Requirements Planning Schedule for Meters A and B, and Subassemblies C and D Week 4 5 6 7 8 9 Gross requirements 1,250 Scheduled receipts Projected available balance 50 50 50 50 50 0 Net requirements 1,200 Planned-order receipts - 1,200 Planned-order releases -1,200 LT = 2 weeks On-hand = 60 Safety stock=0 Order qty = lot-for-lot Gross requirements 470 Scheduled receipts Projected available balance 60 11 10 70 70 70 70 0 Net requirements 400 Planned-order receipts 400 a. Pobla fa C SAFETY STOCK ON-ORDER 0 0 10 (week 5) 5 20 100 (wook 4) Planned-order releases 400 400+ LT = 1 week On-hand=40 Safety stock = 5 Order qty = 2,000 Gross requirements 1,200 Scheduled receipts Projected available balance 35 35 35 435 435 435 Net requirements 1,565 Planned-order receipts 2,000 Planned-order releases 2,000 D LT = 1 week On-hand=200 Safety stock = 20 Order qty = 5,000 40-5 Gross requirements 4,000 1,200 Scheduled receipts 100 Projected available balance 280 280 1,280 80 00 Net requirements 3,720 Planned-order receipts 5,000 Planned-order releases 5,000 270 80 4,810 190 5,000 5,000 300-20