dont use excel. solve problem a& b The Drip doces eget, the Dead Drop Dead Drup are distributed to only one of the water. The promotion is to begin in period 4 undrom og period 6. The local per prebrating the them 1 30 Sales forecast 2 30 Warehouse 40 Period 3 4 5 60 60 Central Lot for units period O units 40 units in period 1 Shipford, quantity Current inventory Lead time Safety Mack Sched, echip I period 10 unit 40 units in period Develop the warm and contra facile See the calfacility 50 per period. How would you pide the mother the Week EXHIBIT Distrito Requirements Mening 7 8 Gro Pup Seattle Warehouse Forecast requirements Intransit Projected wable balance Planned shipments Week 8 10 10 10 10 10 10 10 10 Gro Pup Portland Warehouse Forecast requirements In transit Projected available balance 2 Panned sent 15 Wieck 4 $ 1 3 6 7 8 Gro Pup Plant Warehouse Gross requirements Scheduled receipts Projected wallable balance Marved order so Gro Pup Packaging Material Gross requirements Scheduled receipt Projected avbe balance Panned order release 100 225 Inventory Open Order Scrap 0 Gro-Pup/Seattle Gro-Pup/Portland Gro-Pup/Plant Gro-Pup/Packaging Order Sales Receipts Releases (Disbursements) Adjustment 0 0 19 -3 15 15 20 +3 0 15 0 90 100 50 0 0 10 50 +4 The Drip Producers are planning a promotion of one of its products, the Dead Drop. Dead Drops are distributed through only one of the warehouses. The promotion is to begin in period 4 and run through period 6. The sales forecast is normally 30 per period, but during the promotion the com- pany expects sales to be 60 per period. This is shown here with other data. Period 1 2 3 4 5 6 Sales forecast 30 30 30 60 60 Ship/ord. quantity Current inventory Lead time Safety stock Sched. rec./ship. Warehouse 40 units 12 units 1 period 10 units 40 units in period 1 60 Central Lot-for-lot O units 1 period O units 40 units in period 1 a. Develop the warehouse and central facility's records. b. Suppose the central facility's capacity was limited to 50 units per period. How would you provide the material for the promotion in the field? Proble385 Week 1 2 3 4 EXHIBIT B Distribution Requirements Planning Warksheer 5 6 7 8 20 20 20 Gro-Pup Seattle Warehouse Forecast requirements In transit Projected available balance Planned shipments 20 20 20 20 20 43 60LT-SS0 Week 4 5 1 2. 6 7 8 10 10 10 10 10 10 10 10 15 Gro-Pup Portland Warehouse Forecast requirements In transit Projected available balance Planned shipments 0-15LT 1:50 2 Week 4 5 3 1 7 N 6 8 50 Gro-Pup Plant Warehouse Gross requirements Scheduled receipts Projected available balance Planned order release 30 050, LT2:50 Week 6 7 8 4 5 3 2 1 100 Gro-Pup Packaging Material Gross requirements Scheduled receipts Projected available balance 25 Planned order release 0-100, LT = 4.SS=0 dont use excel. solve problem a& b The Drip doces eget, the Dead Drop Dead Drup are distributed to only one of the water. The promotion is to begin in period 4 undrom og period 6. The local per prebrating the them 1 30 Sales forecast 2 30 Warehouse 40 Period 3 4 5 60 60 Central Lot for units period O units 40 units in period 1 Shipford, quantity Current inventory Lead time Safety Mack Sched, echip I period 10 unit 40 units in period Develop the warm and contra facile See the calfacility 50 per period. How would you pide the mother the Week EXHIBIT Distrito Requirements Mening 7 8 Gro Pup Seattle Warehouse Forecast requirements Intransit Projected wable balance Planned shipments Week 8 10 10 10 10 10 10 10 10 Gro Pup Portland Warehouse Forecast requirements In transit Projected available balance 2 Panned sent 15 Wieck 4 $ 1 3 6 7 8 Gro Pup Plant Warehouse Gross requirements Scheduled receipts Projected wallable balance Marved order so Gro Pup Packaging Material Gross requirements Scheduled receipt Projected avbe balance Panned order release 100 225 Inventory Open Order Scrap 0 Gro-Pup/Seattle Gro-Pup/Portland Gro-Pup/Plant Gro-Pup/Packaging Order Sales Receipts Releases (Disbursements) Adjustment 0 0 19 -3 15 15 20 +3 0 15 0 90 100 50 0 0 10 50 +4 The Drip Producers are planning a promotion of one of its products, the Dead Drop. Dead Drops are distributed through only one of the warehouses. The promotion is to begin in period 4 and run through period 6. The sales forecast is normally 30 per period, but during the promotion the com- pany expects sales to be 60 per period. This is shown here with other data. Period 1 2 3 4 5 6 Sales forecast 30 30 30 60 60 Ship/ord. quantity Current inventory Lead time Safety stock Sched. rec./ship. Warehouse 40 units 12 units 1 period 10 units 40 units in period 1 60 Central Lot-for-lot O units 1 period O units 40 units in period 1 a. Develop the warehouse and central facility's records. b. Suppose the central facility's capacity was limited to 50 units per period. How would you provide the material for the promotion in the field? Proble385 Week 1 2 3 4 EXHIBIT B Distribution Requirements Planning Warksheer 5 6 7 8 20 20 20 Gro-Pup Seattle Warehouse Forecast requirements In transit Projected available balance Planned shipments 20 20 20 20 20 43 60LT-SS0 Week 4 5 1 2. 6 7 8 10 10 10 10 10 10 10 10 15 Gro-Pup Portland Warehouse Forecast requirements In transit Projected available balance Planned shipments 0-15LT 1:50 2 Week 4 5 3 1 7 N 6 8 50 Gro-Pup Plant Warehouse Gross requirements Scheduled receipts Projected available balance Planned order release 30 050, LT2:50 Week 6 7 8 4 5 3 2 1 100 Gro-Pup Packaging Material Gross requirements Scheduled receipts Projected available balance 25 Planned order release 0-100, LT = 4.SS=0