Download E 2 (Excel download) and perform the necessary MRP calculations. Then enter selected values below.

Management Instructions Safety Stock Beginning Inventory Quantity per Parent Lead Time Amount Parent Part 1 Part 2 Lot Size 100 75 1,500 300 21,485 0 40 120 140 50.0% 80.0% 80.0% 30 15 300 300 400 Material Requirements Plan Period 1 Demand 2 3 4 6 8 500 665 790 5 1,130 1 ,205 7 1,180 975 Parent Gross Requirements Scheduled Receipts Projected On-Hand (at beginning of period) Net Requirements Planned Order Receipts Planned Order Releases Part 1 Gross Requirements 55 Scheduled Receipts Projected On-Hand (at beginning of period) Net Requirements Planned Order Receipts Planned Order Releases Part 2 Gross Requirements 165 85 Scheduled Receipts Projected On-Hand (at beginning of period) Net Requirements Planned Order Receipts Planned Order Releases Management Instructions Safety Stock Beginning Inventory Quantity per Parent Lead Time Amount Parent Part 1 Part 2 Lot Size 100 75 1,500 300 21,485 0 40 120 140 50.0% 80.0% 80.0% 30 15 300 300 400 Material Requirements Plan Period 1 Demand 2 3 4 6 8 500 665 790 5 1,130 1 ,205 7 1,180 975 Parent Gross Requirements Scheduled Receipts Projected On-Hand (at beginning of period) Net Requirements Planned Order Receipts Planned Order Releases Part 1 Gross Requirements 55 Scheduled Receipts Projected On-Hand (at beginning of period) Net Requirements Planned Order Receipts Planned Order Releases Part 2 Gross Requirements 165 85 Scheduled Receipts Projected On-Hand (at beginning of period) Net Requirements Planned Order Receipts Planned Order Releases