Problem 14-14 (Algo) 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 "O" wherever required.) 1 week B (1) 3 weeks C(5) 1 week D (2) 2 weeks E(3) 1 week F (6) 2 weeks E (4) 1 week G (4) 1 week H(1) 3 weeks MPS Item 1 65 2 15 3 35 4 105 5 85 6 55 7 75 40 picture Click here for the Excel Data File Item A C D L4L L4L L4L 9 Lot size rule Safety stock Beginning inventory Week 1 scheduled receipts Multiples FOQ = See 12e 320 1,5ee 65 75 30 Part Name: A Week 1 Week 2 Week 3 Week 4 Week 5 Week 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 65 0 0 0 0 0 0 0 Part Name: C Week 1 Week 2 Week 3 Week 4 Week 5 Week 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 75 0 0 0 0 0 0 Part Name: D Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 MRP Record Lead time = 2 week On hand = 0 Safety stock - 0 Order quantity: L4L Gross requirements Scheduled receipts Available inventory Net requirements Planned order receipts Planned order releases 30 70 0 0 0 0 0 0 Part Name: E Week 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 = 120 Order quantity: Multiples FOQ = 500 Gross requirements Scheduled receipts Available inventory Net requirements Planned order receipts Planned order releases 1,500 0 0 0 0 0 0 0 Problem 14-14 (Algo) 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 "O" wherever required.) 1 week B (1) 3 weeks C(5) 1 week D (2) 2 weeks E(3) 1 week F (6) 2 weeks E (4) 1 week G (4) 1 week H(1) 3 weeks MPS Item 1 65 2 15 3 35 4 105 5 85 6 55 7 75 40 picture Click here for the Excel Data File Item A C D L4L L4L L4L 9 Lot size rule Safety stock Beginning inventory Week 1 scheduled receipts Multiples FOQ = See 12e 320 1,5ee 65 75 30 Part Name: A Week 1 Week 2 Week 3 Week 4 Week 5 Week 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 65 0 0 0 0 0 0 0 Part Name: C Week 1 Week 2 Week 3 Week 4 Week 5 Week 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 75 0 0 0 0 0 0 Part Name: D Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 MRP Record Lead time = 2 week On hand = 0 Safety stock - 0 Order quantity: L4L Gross requirements Scheduled receipts Available inventory Net requirements Planned order receipts Planned order releases 30 70 0 0 0 0 0 0 Part Name: E Week 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 = 120 Order quantity: Multiples FOQ = 500 Gross requirements Scheduled receipts Available inventory Net requirements Planned order receipts Planned order releases 1,500 0 0 0 0 0 0 0