Find forecasted sales for week first, Operation Management

Assignment Help:

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

 


Related Discussions:- Find forecasted sales for week first

Line balancing, What happens if balance doesn''t exist

What happens if balance doesn''t exist

Elements, what are the elements of production forecasting?

what are the elements of production forecasting?

Explain significant increase in employee theft, If Textile Manufacturing, I...

If Textile Manufacturing, Inc. reduces the hourly wages of its employees so that it can compete with imported clothing, it can anticipate a significant increase in employee theft o

Explain some of the key decisions its management, Describe some of the key ...

Describe some of the key decisions its management has faced within the past year or two. Identify an ethical issue the organization either faces or has faced in the past. If it has

Explain effects of leadership, The Effects of Leadership on Innovative Prog...

The Effects of Leadership on Innovative Program Implementation. Dove, Maria G.; Freeley, Mary Ellen. Delta Kappa Gamma Bulletin, spring 2011, Vol. 77 Issue 3, p25-32. Read this art

Define the elements of method study and work measurement, Define the elemen...

Define the elements of method study and work measurement. Method study and Work Measurement are elements of Work Study.

Explain disadvantages of free international trade, What are the benefits an...

What are the benefits and disadvantages of free international trade for the United States? Illustrate your answer with examples.

Why scheduling resources is important, Of the six reasons that scheduling r...

Of the six reasons that scheduling resources is important, select which one of the six reasons appears to be the top priority and justify your position.

Calculate the path mean and network diagram, For the following data: ...

For the following data:   Time (in Days)   Activity Immediate Predecessor Optimistic Most Likely

Managing organizational change, Applying models and concepts from the cours...

Applying models and concepts from the course, analyze a significant change initiative you have observed, have been affected by or have had a hand in implementing in your organizati

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd