Instructions: Complete all empty cells in the MRP tables below for all components shown in the product tree for Product Z (highlighted in green at right). Assume that lead-time is strictly followed, and you are not able to get or build material inside of lead-time. MRP Final Planning Data: Product Z Gross Requirements Scheduled Receipts Projected Available Net Requirements Planned Order Receipts Planned Order Releases Planning Data: Assembly B Gross Requirements Scheduled Receipts Projected Available Net Requirements Planned Order Receipts Planned Order Releases Planning Data: Component A Gross Requirements Scheduled Receipts Projected Available Net Requirements Planned Order Receipts Planned Order Releases 300 Lot Size = Lot for Lot LT=1 1 2 3 4 Sfty Stk= 5 0 6 7 8 300 325 400 350 300 350 400 400 Lot Size= 1 150 LT=2 2 3 4 Sfty Stk= 5 6 7 8 400 600 300 500 Lot Size= 1 300 LT=2 2 3 4 Sfty Stk= 5 100 6 7 8 300 Planning Data: Lot Size= 125 LT=3 Component C 1 2 3 4 Sfty Stk= 5 250 6 7 8 Gross Requirements Scheduled Receipts 375 125 0 Projected Available 375 Net Requirements Planned Order Receipts Planned Order Releases Planning Data: Component D Gross Requirements Scheduled Receipts Projected Available Net Requirements Planned Order Receipts Planned Order Releases Planning Data: Component E Gross Requirements Scheduled Receipts Projected Available Net Requirements Planned Order Receipts Planned Order Releases Lot Size= 250 LT=1 1 2 3 4 Sfty Stk= 5 150 6 7 8 500 0 500 650 Lot Size= 1 100 LT=1 2 3 4 Sfty Stk= 5 100 6 7 8 1100 350 N A (x1) D (x3) E (x1) B (x2) C (x0.5)