10. ACME Distributors stocks an item in two remote warehouses and at the central distribution warehouse....

Transcribed Image Text:

10. ACME Distributors stocks an item in two remote warehouses and at the central distribution warehouse. Calculate the projected available, planned order release and gross requirements rows in the below DRP grids. Reference the planning data for each warehouse. Warehouse 1 Safety stock/units Min order qty/units Transit time/days Lot size/units On hand/units KL-2000-10 Gross requirements DRP intransit receipts Projected available balance Net requirements 50 0 2 250 DAILY PERIODS 300 1 2 3 4 5 6 200 220 220 230 230 230 250 DRP planned order receipt DRP planned order release Warehouse 2 KL-2000-10 Safety stock/units Min order qty/units Transit time/days Lot size/units 100 0 1 500 DAILY PERIODS DRP intransit receipts On hand/units Gross requirements Projected available balance Net requirements 625 1 2 3 4 5 6 520 520 525 525 525 510 500 DRP planned order receipt DRP planned order release Central DC KL-2000-10 Safety stock/units 150 Min order qty/units Lead time/days Lot size/units 0 2 600 DAILY PERIODS On hand/units 900 1 2 3 4 5 6 Gross requirements DRP intransit receipts Projected available balance Net requirements DRP planned order receipt 0 0 0 0 0 0 600 DRP planned order release 10. ACME Distributors stocks an item in two remote warehouses and at the central distribution warehouse. Calculate the projected available, planned order release and gross requirements rows in the below DRP grids. Reference the planning data for each warehouse. Warehouse 1 Safety stock/units Min order qty/units Transit time/days Lot size/units On hand/units KL-2000-10 Gross requirements DRP intransit receipts Projected available balance Net requirements 50 0 2 250 DAILY PERIODS 300 1 2 3 4 5 6 200 220 220 230 230 230 250 DRP planned order receipt DRP planned order release Warehouse 2 KL-2000-10 Safety stock/units Min order qty/units Transit time/days Lot size/units 100 0 1 500 DAILY PERIODS DRP intransit receipts On hand/units Gross requirements Projected available balance Net requirements 625 1 2 3 4 5 6 520 520 525 525 525 510 500 DRP planned order receipt DRP planned order release Central DC KL-2000-10 Safety stock/units 150 Min order qty/units Lead time/days Lot size/units 0 2 600 DAILY PERIODS On hand/units 900 1 2 3 4 5 6 Gross requirements DRP intransit receipts Projected available balance Net requirements DRP planned order receipt 0 0 0 0 0 0 600 DRP planned order release