dont use excel. solve problem a& b

8. 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. Sales forecast Period 1 2 3 4 5 6 30 30 30 60 60 60 Warehouse Central 40 units Lot-for-lot 12 units O units 1 period 1 period 10 units O units 40 units in period 1 40 units in period 1 Ship/ord. quantity Current inventory Lead time Safety stock Sched. rec./ship 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? EXHIBIT B Distribution Requirements Planning Worksheet Week 1 2 3 4 5 6 7 8 20 20 20 20 20 20 20 20 Gro-Pup Seattle Warehouse Forecast requirements In transit Projected available balance Planned shipments Q=60LT = 1:88-1 43 Week 1 2 3 4 5 6 7 8 10 10 10 10 10 10 10 10 15 Gro-Pup Portland Warehouse Forecast requirements In transit Projected available balance 2 Planned shipments = 15;LT = 1:SS=0 Week 1 2 3 4 5 6 7 8 50 Gro-Pup Plant Warehouse Gross requirements Scheduled receipts Projected available balance Planned order release Q-50 LT -2; SS=0 30 Week 1 N 3 4 5 6 7 8 100 Gro-Pup Packaging Material Gross requirements Scheduled receipts Projected available balance Planned order release Q = 100; LT-48=0 25 8. 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. Sales forecast Period 1 2 3 4 5 6 30 30 30 60 60 60 Warehouse Central 40 units Lot-for-lot 12 units O units 1 period 1 period 10 units O units 40 units in period 1 40 units in period 1 Ship/ord. quantity Current inventory Lead time Safety stock Sched. rec./ship 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? EXHIBIT B Distribution Requirements Planning Worksheet Week 1 2 3 4 5 6 7 8 20 20 20 20 20 20 20 20 Gro-Pup Seattle Warehouse Forecast requirements In transit Projected available balance Planned shipments Q=60LT = 1:88-1 43 Week 1 2 3 4 5 6 7 8 10 10 10 10 10 10 10 10 15 Gro-Pup Portland Warehouse Forecast requirements In transit Projected available balance 2 Planned shipments = 15;LT = 1:SS=0 Week 1 2 3 4 5 6 7 8 50 Gro-Pup Plant Warehouse Gross requirements Scheduled receipts Projected available balance Planned order release Q-50 LT -2; SS=0 30 Week 1 N 3 4 5 6 7 8 100 Gro-Pup Packaging Material Gross requirements Scheduled receipts Projected available balance Planned order release Q = 100; LT-48=0 25