Given the BOM and MPS for end items A and B, complete the MRP schedules for items A, B, C, F, and G. (Leave no cells blank - be certain to enter "0" wherever required.) 1 week B 1 week C (4) 2 weeks D (2) 2 weeks G (4) 1 week 1(2) 2 weeks E (1) 2 weeks F (4) 1 week J (4) 1 week G (2) 1 week H (1) 1 week 1 2 5 7 8 Item A B 3 200 100 4 250 100 6 300 100 100 100 100 Item A B Lot size rule Safety stock Beginning inventory L4L 0 0 L4L 0 Multiples FOQ = 500 100 400 F Multiples FOQ = 1,000 500 500 Multiples FOQ = 1,000 500 800 0 Part Name: C Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 MRP Record Lead time = 2 weeks On hand = 400 Safety stock = 100 Order quantity: Multiples FOQ = 500 Gross requirements Scheduled receipts Available inventory 400 Net requirements Planned order receipts Planned order releases 0 500 0 0 0 0 X This is a numeric cell, so please enter numbers only. Part Name: F Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 MRP Record Lead time = 1 week On hand = 500 Safety stock = 500 Order quantity: Multiples FOQ = 1,000 Gross requirements Scheduled receipts Available inventory 500 Net requirements Planned order receipts Planned order releases 4,000 0 0 0 0 0 0 0 Part Name: G Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 MRP Record Lead time = 1 week On hand = 800 Safety stock = 500 Order quantity: Multiples FOQ = 1,000 Gross requirements Scheduled receipts Available inventory 800 Net requirements Planned order receipts Planned order releases This is a numeric cell, so please enter numbers only. 1,000 0 0 0