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 would be the increase in the safety, A local bar serves a prem...

A local bar serves a premium draft beer to its customers. The daily demand for beer is assumed to follow a normal distribution with a mean of 80 litres and a standard deviation of

What are the rules of joint venture, Windy City Balloon Port ran a balloon ...

Windy City Balloon Port ran a balloon launching facility in Illinois, offering sightseeing flights in hot-air and helium balloons owned by third parties. Windy City sold tickets fo

Describe the factors influencing customer behaviour, Question : Show or...

Question : Show origin of Collaborative Planning, Replenishment, and Forecasting (CPFR) Origin from CFAR How CFAR standard was renamed CPFR Continuing improvements

#title.supply chain management, explain how a supply chain management would...

explain how a supply chain management would enhance profitability with an analysis of supply chain network

Describe alabama electric for a claim, Fred Flowers works for Alabama Elect...

Fred Flowers works for Alabama Electric and is a resident of the State of Florida. Following a series of storms in the Northeast, Alabama Electric sent Fred to Virginia as part of

Explain exceed the amount invested in auto loans, A bank is attempting to d...

A bank is attempting to determine where its assets should be invested during the current year. At present, $500,000 is available for investment in bonds, home loans, auto loans, an

Explain why is it important for a company to orient freshers, Why is it imp...

Why is it important for a company to orient a new employee to a job? What steps would you take to orient a new employee to do what they are supposed to do?

Explain proposed investment in the warehouse extension, What overall recomm...

What overall recommendations would you make to Francis Lamouche about the proposed investment in the warehouse extension?

Explain create problems for inventory management, To be more competitive, m...

To be more competitive, many fast-food chains began to expand their menus to include a wider range of foods. Although contributing to competitiveness, this has added to the complex

Performance measurement and effectiveness of operations, Question: A ba...

Question: A bank has a section of its business which has two functions:- 1. answering credit control queries from customers both by telephone and in writing; 2. invest

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