*Please reply with excel math.

Garden Inc. replenishes its two distribution centers in Jacksonville and Miami from its Atlanta central supply warehouse. The distribution schedule for one of its products for the next six weeks is shown below. Use proper distribution requirements planning logic to complete the replenishment schedules of the two distribution centers and the central supply warehouse.

Jacksonville Distribution Center		1	2	3	4	5	6
Gross Requirements		0	20	10	0	15	10
Scheduled Receipts			11
Projected On-hand Inventory	20
Planned Order Releases		=

Q = LFL; LT = 2; SS = 2

Miami Distribution Center		1	2	3	4	5	6
Gross Requirements		40	0	0	55	0	30
Scheduled Receipts		30
Projected On-hand Inventory	15
Planned Order Releases

Q = LFL; LT = 1; SS = 5

Atlanta Central Warehouse		1	2	3	4	5	6
Gross Requirements
Scheduled Receipts
Projected On-hand Inventory	50
Planned Order Releases

Q = LFL; LT = 1; SS = 0