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

Fixed position layout - process design, Fixed-position layout This co...

Fixed-position layout This configuration is typically used for low-volume, project-type operations where the product being produced is massive, and movement of the material f

How select an active engineering company, Select an active Engineering Comp...

Select an active Engineering Company, performing a brief research quote the company's mission statement, list 3 current strategies of the company and discuss how they are in alignm

Capacity planning and controlling, #theories and techniques can help if app...

#theories and techniques can help if applies properly.

Explain technique to develop a forecast for the expected, air travel on Mou...

air travel on Mountain Airlines for the past 18 weeks was: Week Passengers 1 404 2 410 3 420 4 415 5 412 6 419 7 424 8 433 9 438 10 440 11 446 12 451 13 455 14 460 15 466 16 474 17

State the term shamrock organisation, State the term Shamrock Organisation?...

State the term Shamrock Organisation? Shamrock Organisation: According to Charles Handy the 'Shamrock Organisation' used to apply a model to the workforce flexibility. Th

Explain technologies to keep the organization competitive, Select an organi...

Select an organization. Who are the stakeholders of your selected organization? How would the stakeholders be affected by the failure of the organization to keep up with new techno

Explain what factors have limited the ability of local law, 1. What factors...

1. What factors have limited the ability of local law enforcement agencies to respond to the growing threat of computer crime? Answer A. lack of training B. lack of diagnostic equi

I want examples of some of these that are associated stories, I need exampl...

I need examples of some of these that are associated with the university. Liberty University. I know what they are i just need help with stories or exaples of these things that are

Explain differentiation and low-cost strategies, Can you think of organizat...

Can you think of organizations that use a differentiation and low-cost strategies? 2. Specifically, what conceptual steps would you take to get from a differentiation or low-cost s

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