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

Describe strategic management concepts and cases, Threadless (in Strategy H...

Threadless (in Strategy Highlight 1.1) is an example of a firm building on its customer base to use new products and also to participate in the design and vetting of popular design

Explain rules of the irs and department of labor, Rules of the IRS and depa...

Rules of the IRS and department of labor determine which workers quailfy as indenpendent contractor?

MBA-2, What do you understand by"line balancing"?What happens if balance do...

What do you understand by"line balancing"?What happens if balance doesn''t exist?

Calculating Standard time, ) A time study analyst observes a worker over a ...

) A time study analyst observes a worker over a period of time and calculates that the worker required 90.0 minutes per unit produced. The worker was rated at a 105 percent perfor

Explain pilot test to generate the variance estimate, If a pilot test revea...

If a pilot test revealed 45% perceived poor service quality, and we decide the interval range is + 10 percent with a 95% confidence level, what is the calculated sample size to con

Explain capital expense, Eric Johnson (using data from Problem 1.6) determi...

Eric Johnson (using data from Problem 1.6) determines his costs to be as follows: • Labor: $10 per hour • Resin: $5 per pound • Capital expense: 1% per month of investment • Energy

Find estimated costs for each of the three product, Madden Industries manuf...

Madden Industries manufactures three models of a product in a single plant with two departments cutting and assembly. The company has estimated costs for each of the three product

Customer satisfaction and service quality, Customer Satisfaction and Servic...

Customer Satisfaction and Service Quality - Operation Strategy Although you have seen examples of the dimensions along which companies compete and approaches to operations st

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