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.
|
Mumbai
|
Chennai
|
Lucknow
|
Delhi
|
Kolkata
|
|
OP Bal
|
120
|
350
|
270
|
250
|
350
|
|
Safety Stock
|
60
|
125
|
150
|
100
|
200
|
|
Min Ord Qty
|
80
|
200
|
200
|
100
|
300
|
|
Lead time Wk
|
1
|
2
|
3
|
2
|
3
|
|
Transit
|
|
|
|
|
300
|
|
Sales Forecast
|
|
|
|
|
|
|
Wk 1
|
50
|
100
|
150
|
50
|
100
|
|
Wk 2
|
35
|
75
|
100
|
75
|
150
|
|
Wk 3
|
55
|
125
|
150
|
80
|
200
|
|
Wk 4
|
65
|
100
|
200
|
55
|
135
|
|
Wk 5
|
80
|
200
|
300
|
75
|
125
|
|
Wk 6
|
125
|
150
|
200
|
80
|
165
|
|
Wk 7
|
50
|
100
|
100
|
90
|
200
|