MRP Planning Schedule

Week 5 -6 -5 -4 -3 -2 -1 1 2 3 4 5 6 7 8 Axles Lead Time = 6 Weeks 800 1,100 700 200 100 400 150 150 150 650 650 650 650 150 950 (250) On-hand = Safety Stock = Order Quantity = (450) 500 250 500 500 500 500 Gross Requirements Beginning Balance Scheduled or Planned Order Receipts (Purchases) Projected Available Balance Net Requirements (Negative= Deficient) Ending Balance Planned Order Releases 1,000 1,150 400 1,200 800 450 (50) 1,250 500 1,000 1,000 950 950 2,250 550 (250) 1,450 (50) 1,250 (450) 500 150 150 650 650 650 650 1,150 1,450 250 50 350 50 750 50 Scheduled Order Receipts Ordered in Week (-10) (50) 550 150 150 1,150 650 650 650 150 950 (250) 450 500 1,000 500 500 500 1,000 1,000 500 Integrated Heal & Shoe Lead Time = ? 300 On-hand = Safety Stock = Order Quantity = 120 400 Gross Requirements Beginning Available Balance Scheduled or Planned Order Receipts (Purchases) Projected Available Balance Net Requirements Ending Available Balance Planned Order Releases None Scheduled Order Receipts Wheels Lead Time = On-hand = Safety Stock = Order Quantity = Scheduled Order Receipts ? 200 100 Gross Requirements Beginning Available Balance Scheduled or Planned Order Receipts (Purchases) Projected Available Balance 500 Ordered in Week (-2) Net Requirements Ending Available Balance Planned Order Releases Week 5 -6 -5 -4 -3 -2 -1 1 2 3 4 5 6 7 8 Axles Lead Time = 6 Weeks 800 1,100 700 200 100 400 150 150 150 650 650 650 650 150 950 (250) On-hand = Safety Stock = Order Quantity = (450) 500 250 500 500 500 500 Gross Requirements Beginning Balance Scheduled or Planned Order Receipts (Purchases) Projected Available Balance Net Requirements (Negative= Deficient) Ending Balance Planned Order Releases 1,000 1,150 400 1,200 800 450 (50) 1,250 500 1,000 1,000 950 950 2,250 550 (250) 1,450 (50) 1,250 (450) 500 150 150 650 650 650 650 1,150 1,450 250 50 350 50 750 50 Scheduled Order Receipts Ordered in Week (-10) (50) 550 150 150 1,150 650 650 650 150 950 (250) 450 500 1,000 500 500 500 1,000 1,000 500 Integrated Heal & Shoe Lead Time = ? 300 On-hand = Safety Stock = Order Quantity = 120 400 Gross Requirements Beginning Available Balance Scheduled or Planned Order Receipts (Purchases) Projected Available Balance Net Requirements Ending Available Balance Planned Order Releases None Scheduled Order Receipts Wheels Lead Time = On-hand = Safety Stock = Order Quantity = Scheduled Order Receipts ? 200 100 Gross Requirements Beginning Available Balance Scheduled or Planned Order Receipts (Purchases) Projected Available Balance 500 Ordered in Week (-2) Net Requirements Ending Available Balance Planned Order Releases