1 Complete the following exercise using Straight DRP. Q = 40 / Safety Stock = 1 / Lead Time = 1 Week. The initial DRP record is shown below: SHOW ALL YOUR WORK

		1	2	3	4	5	6
FORECAST REQUIREMENTS		20	20	20	20	20	20
IN TRANSIT		40
PROJECTED BALANCE	6	26	6	26	6	26	6
PLANNED SHIPMENTS			40		40		40
ACTUAL DEMAND (1) = 24 Q = Order QTY = 40 SS = Safety Stock = 1 LT = Lead Time = 1

1.a) Develop the DRP records above for periods two (2) through Four (4) given demand 24, 16, 18 in Periods 1, 2 and 3. (10 PTS)

		2	3	4	5	6	7
FORECAST REQUIREMENTS
IN TRANSIT
PROJECTED BALANCE
PLANNED SHIPMENTS
ACTUAL DEMAND (2) = 16

		3	4	5	6	7	8
FORECAST REQUIREMENTS
IN TRANSIT
PROJECTED BALANCE
PLANNED SHIPMENTS
ACTUAL DEMAND (3) = 18

		4	5	6	7	8	9
FORECAST REQUIREMENTS
IN TRANSIT
PROJECTED BALANCE
PLANNED SHIPMENTS
Q = Order QTY = 40 SS = Safety Stock = 1 LT = Lead Time = 1