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

Explain what changes should be made in the wage, A father decides to put hi...

A father decides to put his two sons to work landscaping. The business involved going to a customer's home and providing landscaping services (cut gras, edge sidewalk, pull weeds i

Explain which of the following is not a production activity, Which of the f...

Which of the following is not a production activity report generated by MRP? a. Planning report b. Exception report c. Planned-order schedules d. Performance contro

Explain project charter is to help the project team, One purpose of the pro...

One purpose of the project charter is to help the project team and the project sponsor to commit to the project

What are the five criteria for evaluating a selection method, What are the ...

What are the 5 criteria for evaluating a selection method?

Define the relationships among the four functions of manage, Explain the re...

Explain the relationships among the four functions of management? Please dont copy paste from google.

Lay out, how does an operation manager decide what layout type is most appr...

how does an operation manager decide what layout type is most appropriate for his or her business

Explain what is the optimal solution, Kentwood Electronics manufactures thr...

Kentwood Electronics manufactures three components for stereo systems: CD players, tape decks, and stereo tuners. The wholesale price and manufacturing cost of each item are: Compo

Explain type of investigation, William Rich is an extremely wealthy entrepr...

William Rich is an extremely wealthy entrepreneur who has owned several businesses. William sold some of the businesses while others failed and ended up in bankruptcy. Most recentl

Explain who are gmcs target market, What programs does GMC Company have for...

What programs does GMC Company have for the less advantage and children? What grade would you give this program and why? Who are GMCs target market, age, gender, income and race

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