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

Factors considered when recruiting salesmen, SUMIT Products Ltd. is a compa...

SUMIT Products Ltd. is a company that produces and markets steel cups, teaspoons, knives and forks for the catering industry. The company was established in 1958 in response to the

General questions, wanna know how long it takes to receive a paper

wanna know how long it takes to receive a paper

Supply chain, to what extent is SCM applicable to a service operation

to what extent is SCM applicable to a service operation

Digital Cell Phone Inc., Prepare Paul Jordan''s report to John Smithers usi...

Prepare Paul Jordan''s report to John Smithers using regression analysis. Provide a summary of the cell phone industry outlook as part of Paul''s response.n..

Explain layout need to be adjusted as demand for same goods, Base on the ca...

Base on the case study: Weldon Hand Tools; how would the layout need to be adjusted as demand for this and similar products builds up?

Operation research, A paper mill produces two grades of paper viz., X and Y...

A paper mill produces two grades of paper viz., X and Y. Because of raw material restrictions, it cannot produce more than 400 tons of grade X paper and 300 tons of grade Y paper i

How several more hours of overtime would each worker, Games4U makes video g...

Games4U makes video games on CDs at its Old Town plant. The plant produces 800 games each day, and employs 100 workers that work 8 hours each day. They use the following resources

Developing an layout, What is the difference in strategy in developing an i...

What is the difference in strategy in developing an initial layout for a new facility as comparedn to the strategy in improving the layout of an existing facility?

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