Dave's Speakers Inc. replenishes its warehouses in Chicago, Phoenix, and Los Angeles through a centrally located supply distribution center located in Boulder, Colorado. Information on the 6-week distribution schedule for one of its speaker systems, the DS-2000 is provided in the attached spreadsheet.

Use Distribution Requirement Planning logic to complete the replenishment schedule

Download the replenishment schedule of the three warehouses and the central supply warehouse.

Dave's Speakers Replenishment Schedule
Chicago Warehouse		1	2	3	4	5	6
Gross Requirements		0	40	0	110	0	0
Scheduled Receipts
Projected On-hand Inventory	20
Planned Order Releases
Q=30; LT=1; SS=5
Phoenix Warehouse		1	2	3	4	5	6
Gross Requirements		0	40	20	0	0	40
Scheduled Receipts			22
Projected On-hand Inventory	30
Planned Order Releases
Q=LFL; LT=2; SS=2
Los Angeles Warehouse		1	2	3	4	5	6
Gross Requirements		20	0	0	90	0	0
Scheduled Receipts
Projected On-hand Inventory	20
Planned Order Releases
Q=60; LT=1; SS=0
Boulder, CO Central DC		1	2	3	4	5	6
Gross Requirements
Scheduled Receipts
Projected On-hand Inventory	100
Planned Order Releases
Q=20; LT=1 SS=0