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 0 Planning Data: Product Z Lot Size = 1 300 Lot for Lot 2 325 LT = 1 3 400 Sfty Stk = 5 5 300 4 350 Z 6 350 7 7 400 8 400 A (x1) B (x2) Gross Requirements Scheduled Receipts Projected Available 300 Net Requirements Planned Order Receipts Planned Order Releases C (x0.5) D (x3) 1 E (x1) 150 0 Lot Size = 1 1 LT= 2 3 Sfty Stk = 5 2 4 6 7 8 400 600 Planning Data: Assembly B Gross Requirements Scheduled Receipts Projected Available 300 Net Requirements Planned Order Receipts Planned Order Releases 300 100 Lot Size = 1 LT = 2 3 Sfty Stk = 5 2 2 4 6 7 8 300 Planning Data: Component A Gross Requirements Scheduled Receipts Projected Available 500 Net Requirements Planned Order Receipts Planned Order Releases 125 250 Lot Size = 1 LT= 3 3 3 Sfty Stk = 5 2 4 6 7 8 375 125 0 0 Planning Data: Component C Gross Requirements Scheduled Receipts Projected Available 375 Net Requirements Planned Order Receipts Planned Order Releases 250 150 Lot Size = 1 LT= 1 3 Sfty Stk = 5 2 4 6 7 8 500 0 500 Planning Data: Component D Gross Requirements Scheduled Receipts Projected Available 650 Net Requirements Planned Order Receipts Planned Order Releases 100 100 Lot Size = 1 LT= 1 3 Sfty Stk = 5 2 4 6 7 8 1100 Planning Data: Component E Gross Requirements Scheduled Receipts Projected Available 350 Net Requirements Planned Order Receipts Planned Order Releases