13. The Allied Product Company’s sales director has decided to close the firm’s San Diego warehouse and open a new warehouse in Los Angeles. The San Diego warehouse is scheduled to close the end of week 4; the new warehouse in Los Angeles is scheduled to open for business at the start of week 5. Product B is currently stocked in the San Diego warehouse and will be stocked in the new Los Angeles warehouse. Sales forecast for product B is 100 units per week. Complete the following DRP records for product B, reflecting the change in the company’s warehousing plans for the item and the implications for the plant.

Week Product B/San Diego Warehouse 1 2 3 4 5 6 7 8 Forecast requirements In transit Projected available balance 205 Planned shipments Q = LFL; SS = 10 units; LT = 2 weeks.

Week Product B/Los Angeles Warehouse 1 2 3 4 5 6 7 8 Forecast requirements In transit Projected available balance Planned shipments Q = LFL; SS = 10 units; LT = 1 week.

388 Chapter 10 Distribution Requirements Planning Week Product B/Plant 1 2 3 4 5 6 7 8 Gross requirements Scheduled receipts Projected available balance 300 Planned order release Q = 200 units; SS = 15 units; LT = 3 weeks.