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

Carl thor - performance measures, Carl Thor - Performance Measures Car...

Carl Thor - Performance Measures Carl Thor (1994) highlights the 'family of measures' concept and the alignment of measures across a company. He describes five measurement cat

Explain cause and effect diagram and pareto analysis, What are the advantag...

What are the advantages and disadvantages of using a Cause and Effect diagram and Pareto Analysis in terms of analyzing quality issues? Respond to at least two of your classmates'

Explain the manager would prefer ordering, A food processor uses approximat...

A food processor uses approximately 29,730 glass jars a month for its fruit juice product. Because of storage limitations, a lot size of 4,000 jars has been used. Monthly holding c

Explain google''s efforts in corporate strategy, Write a report to Terry Be...

Write a report to Terry Bell: Review Google's values and mission. Provide your assessment of whether the company's overall operations and strategy are aligned to support those valu

Explain the four options of feasibility, Describe the four options highligh...

Describe the four options highlighted in the case study in terms of their feasibility, acceptability and vulnerability.

Describe benefits of free international trade, What are the benefits and di...

What are the benefits and disadvantages of free international trade for the United States?

Explain the concept of merit goods, Explain the concept of merit goods with...

Explain the concept of merit goods with reference to the formal provision of education in a country.  Merit goods are those goods and services that society values and the gover

Locational break - even analysis, Locational Break - even analysis In ...

Locational Break - even analysis In comparing several  potential location on  an economic  basis,( i., e, tangible factor)  the only  revenues  and costs  that need  to be con

How much must a company pay to keep a specially-skilled, How much should a ...

How much should a company pay to keep a specially-skilled worker? Why? How would you determine the amount to pay to keep such a worker? Explain (again, use textbook concepts) Wh

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