fill out tables A, C, D, and E with the information given

Given the BOM and the MPS for end item A, complete the MRP schedule for items A, C, D, and E. (Leave no cells blank - be certain to enter "0" wherever required.) 1 week C (3) B (1) 3 weeks D (3) 2 weeks 1 week E (2) 1 week F (6) 2 weeks E (2) 1 week G (4) 1 week H(1) 3 weeks MPS Item 1 70 2 25 3 45 4 110 5 100 6 55 7 70 B 45 Item D Lot size rule Safety stock Beginning inventory Week 1 scheduled receipts L4L 0 0 L4L 0 0 L4L 0 0 E Multiples FOQ = 600 100 320 70 75 75 1,200 Part Name: A Week 1 Week 2 Week 3 Week 4 Week 5 Wook 6 Week 7 Week 8 MRP Record Lead time 1 week On hand=0 Safety stock=0 Order quantity: L4L Gross requirements Scheduled receipts Available inventory Net requirements Planned order receipts Planned order releases 70 0 0 0 0 0 Part Name: C Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Wook 7 Week 8 MRP Record Lead time 1 week On hando Safety stock = 0 Order quantity: L4L Gross requirements Scheduled receipts Available inventory Net requirements Planned order receipts Planned order releases 75 0 0 0 0 0 0 0 Part Name: D Week 1 Week 2 Wook 3 Wook 4 Week 5 Wook 6 Week 7 Week 8 MRP Record Lead time 2 week On hand Safety stock Order quantity: LAL Gross requirements Scheduled receipts Available inventory Net requirements Planned order receipts Planned order releases 75 135 0 0 0 0 0 Part Name: E Wook 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 MRP Record Lead time = 2 week On hand - 320 Safety stock = 100 Order quantity: Multiples FOQ = 600 Gross requirements Scheduled receipts Available inventory Net requirements Planned order receipts Planned order releases 1,200 0 0 0 0 0 0 Given the BOM and the MPS for end item A, complete the MRP schedule for items A, C, D, and E. (Leave no cells blank - be certain to enter "0" wherever required.) 1 week C (3) B (1) 3 weeks D (3) 2 weeks 1 week E (2) 1 week F (6) 2 weeks E (2) 1 week G (4) 1 week H(1) 3 weeks MPS Item 1 70 2 25 3 45 4 110 5 100 6 55 7 70 B 45 Item D Lot size rule Safety stock Beginning inventory Week 1 scheduled receipts L4L 0 0 L4L 0 0 L4L 0 0 E Multiples FOQ = 600 100 320 70 75 75 1,200 Part Name: A Week 1 Week 2 Week 3 Week 4 Week 5 Wook 6 Week 7 Week 8 MRP Record Lead time 1 week On hand=0 Safety stock=0 Order quantity: L4L Gross requirements Scheduled receipts Available inventory Net requirements Planned order receipts Planned order releases 70 0 0 0 0 0 Part Name: C Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Wook 7 Week 8 MRP Record Lead time 1 week On hando Safety stock = 0 Order quantity: L4L Gross requirements Scheduled receipts Available inventory Net requirements Planned order receipts Planned order releases 75 0 0 0 0 0 0 0 Part Name: D Week 1 Week 2 Wook 3 Wook 4 Week 5 Wook 6 Week 7 Week 8 MRP Record Lead time 2 week On hand Safety stock Order quantity: LAL Gross requirements Scheduled receipts Available inventory Net requirements Planned order receipts Planned order releases 75 135 0 0 0 0 0 Part Name: E Wook 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 MRP Record Lead time = 2 week On hand - 320 Safety stock = 100 Order quantity: Multiples FOQ = 600 Gross requirements Scheduled receipts Available inventory Net requirements Planned order receipts Planned order releases 1,200 0 0 0 0 0 0