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

Stepping stone method, what advantage and disadvantage stepping stone metho...

what advantage and disadvantage stepping stone method?

Explain ideas that would increase sales, Your best friend owns a small chil...

Your best friend owns a small children's clothing store located in the downtown area of a community of 50,000 citizens. Business has been slow the past year due the construction of

Customisation - service process matrix, Customisation - Service Process Mat...

Customisation - Service Process Matrix Customisation reflects the degree to which the service provided is tailored to the needs of the customer. Organisations which have a hig

Describe what these two service level mean, A cigar company stocks Cuban ci...

A cigar company stocks Cuban cigars that have variable lead times because of the difficulty in importing the product. Lead time is normally distributed with an average of 6 weeks a

Manager case, In the table given below the Distribution Manager is expected...

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 woul

Which charts is used to monitor the total number of defects, Which of the f...

Which of the following charts is used to monitor the total number of defects per unit when a constant subgroup size is employed? s-chart c-chart p-chart u-chart

Compute the cycle time for the application process, The Central Evaluation ...

The Central Evaluation Unit Task 1: Analyse and evaluate the processing of new applications at the CEUPU: • Create a process map for new applications • Calculate the cycle time for

Describe what specific planning challenges, Someone Help Please! Select one...

Someone Help Please! Select one of the following companies to study in depth over the next 4 weeks. BP Oil Kimberly-Clark Kroger Nucor Walgreens Wells Fargo Kaiser Permanente Ascen

Explain inhumane labor standards, A few years ago, several U.S. retailers w...

A few years ago, several U.S. retailers were sued in Los Angeles courts for human rights abuses associates with contract manufactures located in the Marianas Islands, a territory o

Explain what is the maximum queue length, You are to simulate arrivals and ...

You are to simulate arrivals and departures from a fictional airport with a single runway which has a capacity of handling a total 6 aircraft at once (any mix of take-offs and land

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