Use the provided Excel spreadsheet to enter the final results of the MRP.

(MPS) Master Plan Articles Stepper 1 2 Week 3 4 5 6 7 8 100 200 400 200 150 Stock (includes Security Supply safety Epected orders Component Stepper 5 2 20 30 in perdiod A 11 10 30 in perdiod B 5 11 30/25 ( in perdiod C T 11 10 150 in perdiod D1 15 1151 20 50 200 in perdiod 2) 2) 3) 3) 2) Stepper (3) Ilu Stepper Gross Requirements Projected on-hand inventory Scheduled Receipts Net Requirements Planned Order Receipt Planned Order Release 5 6 7 8 Gross Requirements Projected on-hand inventory Scheduled Receipts Net Requirements Planned Order Receipt Planned Order Release Gross Requirements Projected on-hand Inventory Scheduled Receipts Net Requirements Planned Order Receipt Planned Order Release 5 6 7 8 Gross Requirements Projected on-hand inventory Scheduled Receipts Net Requirements Planned Order Receipt Planned Order Release D 21 5 6 7 Gross Requirements Projected on-hand inventory Scheduled Receipts Net Requirements Planned Order Receipt Planned Order Release HH Gross Requirements Projected on-hand inventory Scheduled Receipts Net Requirements Planned Order Receipt Planned Order Release 6 7 8 Gross Requirements Projected on-hand inventory Scheduled Receipts Net Requirements Planned Order Receipt Planned Order Release Gross Requirements Projected on-hand inventory Scheduled Receipts Net Requirements Planned Order Receipt Planned Order Release (MPS) Master Plan Articles Stepper 1 2 Week 3 4 5 6 7 8 100 200 400 200 150 Stock (includes Security Supply safety Epected orders Component Stepper 5 2 20 30 in perdiod A 11 10 30 in perdiod B 5 11 30/25 ( in perdiod C T 11 10 150 in perdiod D1 15 1151 20 50 200 in perdiod 2) 2) 3) 3) 2) Stepper (3) Ilu Stepper Gross Requirements Projected on-hand inventory Scheduled Receipts Net Requirements Planned Order Receipt Planned Order Release 5 6 7 8 Gross Requirements Projected on-hand inventory Scheduled Receipts Net Requirements Planned Order Receipt Planned Order Release Gross Requirements Projected on-hand Inventory Scheduled Receipts Net Requirements Planned Order Receipt Planned Order Release 5 6 7 8 Gross Requirements Projected on-hand inventory Scheduled Receipts Net Requirements Planned Order Receipt Planned Order Release D 21 5 6 7 Gross Requirements Projected on-hand inventory Scheduled Receipts Net Requirements Planned Order Receipt Planned Order Release HH Gross Requirements Projected on-hand inventory Scheduled Receipts Net Requirements Planned Order Receipt Planned Order Release 6 7 8 Gross Requirements Projected on-hand inventory Scheduled Receipts Net Requirements Planned Order Receipt Planned Order Release Gross Requirements Projected on-hand inventory Scheduled Receipts Net Requirements Planned Order Receipt Planned Order Release