Complete the DRP records for periods 2 through 4 below, using the error Addback Method to update the records based on actual demand.

-Leave blank if no entry is needed.

-As new periods enter the planning horizon, assume a forecast of 30 units in Periods 6, 7, and 8.

-Must show all calculations in the cells below to receive full credit.

	Period
On hand		1	2	3	4	5
Forecast Requirements		30	30	30	30	30
In Transit		60
Projected Available Balance	10	40	10	40	10	40
Planned Shipments		60		60

Ship Qty= 60, Lead Time = 1; Safety Stock:10

Period 1 Actual Demand: 24

Cumulative Error

	Period
On hand		2	3	4	5	6
Forecast Requirements
In Transit
Projected Available Balance
Planned Shipments

Ship Qty=60; Lead Time=1; Safety Stock=10

Period 2 Actual Demand: 38

Cumulative Error

	Period
On hand		3	4	5	6	7
Forecast Requirements
In Transit
Projected Available Balance
Planned Shipments

Ship Qty=60; Lead Time=1; Safety Stock=10

Period 3 Actual Demand: 27

Cumulative Error

	Period
On hand		4	5	6	7	8
Forecast Requirements
In Transit
Projected Available Balance
Planned Shipments

Ship Qty=60; Lead Time=1; Safety Stock=10