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