Paint
St. Johns & Moncton are Supplied by the Distribution Center in Halifax
St. Johns	Order Qty: 1500 Lead time: 1 week
Week	0	1	2	3		4		5		6
Gross requirements		1500	1000	1700		1800		1250		1500
Inventory on-hand	1500
Planned receipts
Planned Orders
Moncton	Order Qty: 1500 Lead time: 1 week
Week	0	1	2	3		4		5		6
Gross requirements		1,500	1,000	1,800		2,000		1,550		1,200
Inventory on-hand	1,900
Planned receipts
Planned Orders
Montreal & Quebec City are Supplied by the Distribution Center in Dorval
Montreal	Order Qty: 2000 Lead time: 1 week
Week	0	1	2	3		4		5		6
Gross requirements		1,300	1,600	1,500		1,800		2,000		2,000
Inventory on-hand	1,500
Planned receipts
Planned Orders
Quebec City	Order Qty: 3000 Lead time: 2-weeks
Week	0	1	2	3		4		5		6
Gross requirements		850	1,000	1,200		1,600		1,850		1,900
Inventory on-hand	2,500
Planned receipts
Planned Orders
Distribution Centers
Halifax	Order Qty: 5000 Lead time: 1 week
Week	0	1	2	3		4		5		6
Gross requirements
Inventory on-hand	3,500
Planned receipts
Planned Orders
Dorval	Order Qty: 5000 Lead time: 1 week
Week	0	1	2	3		4		5		6
Gross requirements
Inventory on-hand	5,000
Planned receipts
Planned Orders
Manufacturing Site
Albany, NY	Order Qty: 10000 Lead time: 1 week
Week	0	1	2	3		4		5		6
Gross requirements
Inventory on-hand	25,000
Planned receipts
Planned Production

Details for Q2 may be entered here.

Distribution Requirements Planning and the Integrated Supply Chain A leading manufacturer in Albany, NY produces household paint (Flat, Semi-gloss and High-gloss), which is sold through home improvement retailers. The manufacturing process is highly automated producing various chemical formats which are filled into 1-gallon containers and then packed in cartons containing 4, 1-gallon containers. The retail locations must order by carton specifying the type (i.e., Flat, Semigloss, High-gloss). Distribution centers will sometimes keep a selection of cartons on-hand providing interim storage for the retailer. The Distribution Center located in Dorval services retailers in Montreal and Quebec City. Distribution located in Halifax serves Moncton and St. Johns. The details provided below, represents the Gross requirements for a 6week cycle for the retail locations. Inventory currently on-hand is indicated in week - 0 . Each location has an order quantity based on inventory management policy and lead time specifications. Q1. Utilize the information, as provided to complete a 'pull' distribution requirements plan. Complete the calculation in each table and provide a numeric value in each cell. Q2. Describe any special considerations that may be needed with this type of inventory through each stage of the process and explain how costs may be impacted