B E H J M N P 0 4 5 6 7 0 0 0 0 Problem 2.4 Material Requirements a. One hundred twenty units of end item Z are needed at the beginning of veek 7. Prepare a MRP for component C. Take into account that on hand there are 40 units of Z. 70 units of A. 100 units of B. and 30 units of C. Also there is a scheduled receipt of 20 units of component C in veek 4. Lead times are two weeks for Z and B. and one week for the other components. Lot-for-lot ordering will be used for all items. Lot-for-lot means the lot size equals the gross requirement. Complete the spreadsheet cells colored in blue. Z = 120-40 - 80 units required at 2 per LT=1 w Lot-for-Lot ROP=0 veek 7 - 24k LT = veek 5 Part A Veek 1 Week 2 Veek 3 Week 4 Week 5 Gross Requirem 160 Leve Item Oty Per Net Requirements 70 0 Z Start Invent 70 70 70 70 70 -99 A Scheduled Receipts 3 Planned Order Receipt 160 D Planned Order Release B 4 2 LT-2 Lot-for-Lot ROP=0 2 Part B Veek 1 Week 2 Veek 3 Veek 1 Veek 5 Z = 120 - 40 = 80 units required at 4 per Gross Requirem! 0 0 0 0 320 veek 7 - 24k LT = veek 5 Net Requirements 100 Start Invent 100 100 100 100 -220 Scheduled Receipts Planned Order Receipt 320 Planned Order Release 320 .1 2 2 160 1 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 E 100 440 *480 LT=1 - Lot-for-Lot ROP=0 Part C Veek 1 Week 2 Veek 3 Week 4 Veek 5 A: 3 per/B: 2 per Gross Requirem! 0 0 0 Net Requirements 30 Start Invent 30 30 30 -410 Scheduled Receipts 20 Planned Order Receipt Planned Order Release TO