Complete the MRP tables.

Please show your work on excel. Thank you!

. B D E F G H 1 J K L M N o 1 2 250 3 Order Qty Safety Stock Lead Time Periods 4 1 2 3 4 5 6 7 8 9 10 11 12 210 150 230 180 200 180 260 160 200 150 180 240 5 6 7 250 200 2 weeks Gross Requirements Scheduled Receipts Projected Available - 300 Net Requirements Planned Order Receipts Planned Order Releases Item Y 8 9 10 11 12 13 Periods 14 1 2 3 4 6 7 8 9 10 11 12 wlu 50 90 40 80 110 110 80 80 70 70 100 15 16 Order Qty 300 Safety Stock 50 Lead Time 2 weeks Gross Requirements Scheduled Receipts Projected Available - 140 Item Z Net Requirements Planned Order Receipts Planned Order Releases 300 17 18 19 20 21 22 23 300 24 5 9 25 26 Order Qty 1500 Safety Stock Periods Lead Time 3 weeks 1 2 3 4 6 7 8 10 11 12 Gross Requirements Scheduled Receipts 1500 Projected Available - 1400 Item A Net Requirements Planned Order Receipts Planned Order Releases In addition to the requirements for its direct parent (Y), item A also has service stock (independent) demand of 100 units in periods 2,4,5, 8, 10, and 12 27 28 29 30 31 Bill of Material Examples Y Z 2 2. 2 1 A B. B D N 1 4. 1 2 E D EFG 2 1 E D . B D E F G H 1 J K L M N o 1 2 250 3 Order Qty Safety Stock Lead Time Periods 4 1 2 3 4 5 6 7 8 9 10 11 12 210 150 230 180 200 180 260 160 200 150 180 240 5 6 7 250 200 2 weeks Gross Requirements Scheduled Receipts Projected Available - 300 Net Requirements Planned Order Receipts Planned Order Releases Item Y 8 9 10 11 12 13 Periods 14 1 2 3 4 6 7 8 9 10 11 12 wlu 50 90 40 80 110 110 80 80 70 70 100 15 16 Order Qty 300 Safety Stock 50 Lead Time 2 weeks Gross Requirements Scheduled Receipts Projected Available - 140 Item Z Net Requirements Planned Order Receipts Planned Order Releases 300 17 18 19 20 21 22 23 300 24 5 9 25 26 Order Qty 1500 Safety Stock Periods Lead Time 3 weeks 1 2 3 4 6 7 8 10 11 12 Gross Requirements Scheduled Receipts 1500 Projected Available - 1400 Item A Net Requirements Planned Order Receipts Planned Order Releases In addition to the requirements for its direct parent (Y), item A also has service stock (independent) demand of 100 units in periods 2,4,5, 8, 10, and 12 27 28 29 30 31 Bill of Material Examples Y Z 2 2. 2 1 A B. B D N 1 4. 1 2 E D EFG 2 1 E D