DRP EXERCISE part B Name: Lot Lead Size Time Safety It is now the beginning of week 2; the following occurred in wk 1. Stock Actual week 1 demands for product F are shown DC East 70 2 5 in the week 1 forecast cell for the two DCs and the DC West 90 3 5 gross requirements cell for the plant. DC East Product F Forecast In transit Projected Available Net Requirements* Planned In transit Planned Shipments Assume that the week 1 intransit for DC East was received. Assume that any week 1 planned shipments/order releases were released. You cannot expedite the stated lead times. Recalculate these item records starting with the actual inventory (given the actual demand) at the end of week 1. Week 2 3 4 5 6 8 Actual 30 40 30 30 50 40 70 70 received 70 15 DC West Week Product F 2 3 4 5 6 7 8 Forecast actual 60 50 90 70 100 100 80 50 In transit 90 Projected Available 105 Net Requirements* Planned In transit Planned Shipments *Use of these lines is optional; they are provided in case you find them helpful. Plant Product F actual Gross Requirements. 180 received Scheduled Receipts 200 Projected Available 70 Net Requirements* Plnd Order Receipts* Plnd Order Releases Plant Planning Data: lot size quan=200, LT-1 wk; Week 4 5 8 customer demand serviced directly by the plant 30/wk; safety stock = 15