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 significance of the brainstorming suggestions, Assess the significa...

Assess the significance of the brainstorming suggestions and determine how you might use this information to improve the chances of the project's success

Sceduling for the short term, what are the advantage to finite capacity sch...

what are the advantage to finite capacity scheduling ?

Describe ways of improving decision making process, Question 1: (a) Exp...

Question 1: (a) Explain the specific steps you would take to ensure that an individual has the appropriate abilities to satisfactorily do a given job. (b) Explain  the four

Explain the case of ellen moore living and working in korea, The case of El...

The case of Ellen Moore (A) Living and Working in Korea. Look at this case from the point of view of Andrew Kilpatrick. At this point in time, what would you do if you were Andrew?

Explain physical inventory-taking technique, Question 1 Shortage costs are ...

Question 1 Shortage costs are precise and easy to measure. Question 2 Savings from reduced inventory results in increased profit. Question 3 Using the probability approach we

Explain collaboration solutions in the face of economic, Why are unions exp...

Why are unions exploring new collaboration solutions in the face of economic/work adversity?

Assuming these are the critical attributes for perfect order, An analysis o...

An analysis of order and shipment data shows that the order fill rate is 97.1% and ABBA collected the following data concerning customer service performance: Late delivery-5 per

Describe objective functions for an lp model equivalent, Are the following ...

Are the following objective functions for an LP model equivalent? That is, if they are both used, one at a time, to solve a problem with exactly the same constraints, will the opti

Explain how many hours would the average laborer, In December, general moto...

In December, general motors produced 7,200 customized vans at its plant in Detroit. The labor productivity at this plant is known to have been 0.10 vans per labor hour during that

Explain type of antennas issues signals with equal strength, Name the type ...

Name the type of antennas issues signals with equal strength and clarity in all directions? a. directional b. bi-directional c. tri-directional d. omni-directional

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