A company that manufactures snow shovels has one plant

A company that manufactures snow shovels has one plant and two distribution centers (DCs) Given the following information for the two distribution centers calculate the gross requirements projected available and planned order releases for the two DCs and the gross requirements projected available and planned order releases for the central warehouse.
Distribution Center A
Transit time: 2 weeks
Order Quantity: 500 units
Week
1
2
3
4
5
Gross Requirements
300
200
150
175
200
In transit
500
Projected Available 20
Planned order Release
Distribution Center B
Transit Time: 2 Weeks
Order Quantity: 200 Units
Week
1
2
3
4
5
Gross Requirements
50
75
100
125
150
In transit
Projected Available 150
Planned Order Release
Central Supply
Lead Time: 1 week
Order Quantity: 600 unit
Week
1
2
3
4
5
Gross Requirements
Scheduled Receipt
Projected available 400
Planned Order Release
Attachments: