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

Compute the trend-adjusting exponential smoothing forecast, Tough Face, a m...

Tough Face, a manufacturer of rock-climbing gear, been enjoying steady growth of it very reliable and colourful carabineer products. Using the following sales history, calculate th

Compute the probability that 5 stolen cars will be recover, According to po...

According to police sources a car with a certain protection system will be recovered 85% of the time. Find the probability that 5 of 7 stolen cars will be recovered.

Describe the key success factors, Select an industry or a company of your ...

Select an industry or a company of your choice. Using figure 4.3 on page 110, apply the industry or the company by identifying the segment and key success factors. Justify / explai

Different roles that need to be performed by team members, Question : (...

Question : (a) "When a team is performing at its best, you'll usually find that each team member has clear responsibilities. You'll also see that every role needed to achieve t

Explain what is the evpi, State of nature decision ...

State of nature decision S1 S2 S3 D1 250 750 500 D2 300 -250

#titCAREING FOR TODDLERle.., HOW TO CARE FOR A TODDLERn #Minimum 100 words ...

HOW TO CARE FOR A TODDLERn #Minimum 100 words accepted#

Explain difficulties of restructuring organizations, What do Klein Felds ef...

What do Klein Felds efforts at Siemens tell you about the difficulties of restructuring organizations?

Explain decentralization occurs as an organization grows, According to a re...

According to a review of major U.S. companies, four stages of structural development are consistently present. At which stage does product demand become so high that a crisis devel

Explain why is exporting the popular initial entry method, Why is exporting...

Why is exporting the most popular initial entry method?

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