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 how this can affect people''s sense of responsibility, In the morde...

In the mordern world most people work in organisations. Describe how this can affect people's sense of responsibility and the morality of their conduct.

Explain assembly of power steering pumps, A small assembly line for the ass...

A small assembly line for the assembly of power steering pumps needs to be balanced. Exhibit 8.11 in the text is the precedence diagram. The cycle time is determined to be 1.5 minu

Simultaneity of production & consumption of service product, Simultaneity o...

Simultaneity of Production and Consumption of Service Products There is no opportunity to place the service in inventory. This is not always completely, for instance, petrol i

Availability of raw materials , Factors responsible for plant location choi...

Factors responsible for plant location choice - Availability of Raw Materials Areas where industrial raw materials are easily available obviously exert greater pull on locatio

Explain lean approach to supply chain management, Does a Vendor Managed Inv...

Does a Vendor Managed Inventory system support a "lean" approach to supply chain management? Explain

Make an aggregate plan, Prepare an aggregate plan for the coming year assum...

Prepare an aggregate plan for the coming year assuming that the sales forecast is perfect Use a spreadsheet Bradford Manufacturing in the spreadsheet an area has been designated fo

Explain matrix organisation, Explain matrix organisation. Matrix Organ...

Explain matrix organisation. Matrix Organisation: it is used when an organization has to handle a variety of projects, varies from small to large. While a pure project struct

Explain interest expenses and taxes, A company's net income depends on all ...

A company's net income depends on all of the following except a. amount of sales b. cost of goods sold c. interest expenses and taxes. d. inventory estimates

Explain personal and professional lives, How can you see the integration an...

How can you see the integration and the modern management theory integrated into your own personal and professional lives? Pick only one theory for there are hundreds

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