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 human resource management legal issues, Submit Apple, Inc.'s Human ...

Submit Apple, Inc.'s Human Resource Management Legal Issues related to Apple, Inc.'s HRM Strategic Workforce Improvement Plan project

Elements of production control, Elements of Production Control 1.Contro...

Elements of Production Control 1.Control of the Planning: Assure receipt of latest forecast data from sales and production planning bill of material data from product engineer

What are some new products organizational markets, What are some new produc...

What are some new products I could use that serve two business (organizational) markets?

Describe the lewin''s change process, Question 1: Change is often resis...

Question 1: Change is often resisted because of the uncertainty and ambiguity it creates, the concern that it might not be in the organisation's best interest. (i) Discuss

Calculate electrical, Test results from an electronic circuit board indicat...

Test results from an electronic circuit board indicate that 50% of board failures are caused by assembly defects, 30% are due to electrical components, and 20% are due to mechanica

Explain what are the advantages of adopting this technology, An accounts re...

An accounts receivable manager processes 200 checks per day with an average process time of 15 working days. What is the average number of accounts receivable checks being processe

Explain when supply exceeds demand during the lead time, A stock out occurs...

A stock out occurs when supply exceeds demand during the lead time

Explain balanced scorecard, Identify four categories of measures that might...

Identify four categories of measures that might constitute a Balanced Scorecard of performance measures and provide an example of each. Also explain how a Balanced Scorecard could

Explain conflict with the protections provided in the nlrb, The National La...

The National Labour Relations Act has been criticized as an outdated piece of legislation that is hindering, rather then helping, American cope with the realities of the new global

Explain yellow pages listed a funeral home under what, In 1980 the Yellow P...

In 1980 the Yellow Pages listed a Funeral Home under what

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