In the table given below the Distribution Manager is expected to service these D
ID: 400574 • Letter: I
Question
In the table given below the Distribution Manager is expected to service these DCs as per the demands placed. If the actual sales after completing week one is as follows, what would be the quantities that would need amendment as far as Distribution Manager is concerned to service for week two and onwards? After week one the actual sales to Forecasted sales for week one ratio is as under: Mumbai did 80 % of forecast , Lucknow did 75 % of forecast Kolkata did 60 % of week one forecast Chennai did 125 % of forecast and Delhi did 150 % of week one forecast Note : Kolkata will receive transit stocks in week 2 .Explanation / Answer
Mumbai Chennai Lucknow Delhi Kolkata Op Bal 120 350 270 250 350 Safety Stocks 60 125 150 100 200 Min Order Qty 80 200 200 100 300 Lead Time Wks 1 2 3 2 3 Transit 300 Provide fresh stock 248 712.5 630 507.5 0 Sales Forecast Week 1 50 100 150 50 100 Actual Sale 40 125 112.5 75 60 week 2 35 75 100 75 150 Amended forcust 28 93.75 75 112.5 90 week 3 55 125 150 80 200 Amended forcust 44 156.25 112.5 120 120 week 4 65 100 200 55 135 Amended forcust 52 125 150 82.5 81 week 5 80 200 300 75 125 Amended forcust 64 250 225 112.5 75 week 6 125 150 200 80 165 Amended forcust 100 187.5 150 120 99 week 7 50 100 100 90 200 Amended forcust 40 125 75 135 120 Total sales 368 1062.5 900 757.5 645