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

Negative feedback in open system, Negative Feedback in Open System A u...

Negative Feedback in Open System A ubiquitous feature of all open systems is feedback. This is necessary for a system to maintain dynamic equilibrium despite being subjected t

Compute the minimum replenishment time to build model, Calculate the minimu...

Calculate the minimum replenishment time to build 2500 Model A fountains given the following beginning inventories?

What are the advantages of process mapping, What are the advantages of proc...

What are the advantages of process mapping? Advantages of process mapping are as follows: a. It can be used for structured ‘walk by testing to confirm knowing of workflow, c

Explain benefit from integreated software, How can a university, which is a...

How can a university, which is also a service organizaiton, benefit from integreated software?

Determine the supply and aggregate supply curve , In the food processing se...

In the food processing sector of a country, 100 identical small firms produce frozen fruits. Each producer is a price-taker in the market and faces the following cost conditions:

Explain what is your forecast of profit for a store, The XYZ Paint shop own...

The XYZ Paint shop owns and operates a dozen shops in central Missouri. Their signature paint is Green Pearl on Electric Blue Candy. Sales (X, in millions of dollars) is related to

Explain description of the purpose of prototyping, A description of the art...

A description of the article and where it was found Identification of the one thing about prototyping that surprised you the most A brief summary of why it surprised you A descript

Discuss entrepreneurship is more mundane, INC.. magazine claims, "Entrepren...

INC.. magazine claims, "Entrepreneurship is more mundane than it is sometimes portrayed . . . you don't need to be a person of mythical proportions to be very, very successful in b

How did the corporation performs in the return on investment, How did the c...

How did the corporation perform the past year overall in terms of return on investment, market share, and profitability?

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