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 how can service level agreements be monitored, How can service leve...

How can service level agreements be monitored? Construct a short service level agreement first, then discuss how this service level agreement can be monitored

Problem 8, a small assembly line for the assembly of power steering pumps n...

a small assembly line for the assembly of power steering pumps needs to be balanced. exhibit 8.11 is the precedence diagram. the cycle time is determined to be 1.5 minutes. how wou

Cellular manufacturing, Hi, How to design a cell layout after forming the p...

Hi, How to design a cell layout after forming the part families and machine routing sequence. Is there any algorithm/heuristics/ mathematical models available to do it ? Please hel

Explain most important concepts or knowledge that you gained, 1) Do you thi...

1) Do you think that the ISS Clinic investment in electronic medical records added value for the organization? How would you recommend measuring this "value"? If you do not think t

Explain disadvantages of each decision that elaine has made, Discuss the ad...

Discuss the advantages and disadvantages of each decision that Elaine has made

Could you please explain which values i need to calculate, Regarding the tr...

Regarding the trash bag case (Essentials of Business Statistics, chapter 7 exercise 50), I am not sure where the 1.9991 comes from. I tired computing the standard normal distrib

Construct the control chart, Telephone inquiries of 100 cell phone company ...

Telephone inquiries of 100 cell phone company customers are monitored daily at random.  Incidents of incorrect information or other nonconformities (such as rudeness to customers)

Describe do not have to be at the same level of the wbs, All work packages ...

All work packages in a project: Answer Do not have to be at the same level of the WBS Must be at the same level of the WBS Do not have to be referenced in the Work Brea

Negative tradeoffs associated with an outsourcing production, Toyota's safe...

Toyota's safety recalls - Are they indicators of problems associated with quality management, outsourcing or simply indicators of setting inconsistent competitive priorities in ope

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