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

I need to cancel my order i made earlier today, I want to cancel my order I...

I want to cancel my order I made earlier today. How do I do this and get a full refund?

Economic advantage of statistical process control, Economic Advantage of St...

Economic Advantage of Statistical Process Control Since only samples of the output are measured, the cost of the measurement is substantially less than if all of the output we

How to develop an aggregate plan for product line, DAT, Inc, company needs ...

DAT, Inc, company needs to develop an aggregate plan for its product line. Relevant data are Production time: 1 hour per unit Average labor cost: $10/hour Workweek: 5 d

Define learning managerial problem solving help, In essay form how will lea...

In essay form how will learning managerial problem solving help you later in life in you job

Productivity, what is operation management in terms of productivity

what is operation management in terms of productivity

Layout, what are the objectives that an operation should seek in order to e...

what are the objectives that an operation should seek in order to ensure a good layout?

Describe assaults a waitress at a nearby restaurant, A company hires a file...

A company hires a file clerk but does not inquire into his criminal history. In fact, he has had several convictions for driving while intoxicated. On a lunch break, he gets drunk

PRoject, I need to chose a operations management concept or technique in or...

I need to chose a operations management concept or technique in order to help address the issue of the DFW security wait lines. This is a group project and my teammates have starte

Explain the front-room and back-room services, Identify the front-room and ...

Identify the front-room and back-room services for the following organizations. Could these services be improved by increasing or decreasing the degree of customer contact? By sepa

Define decision base on an expected monetary value criterion, Page Engineer...

Page Engineering designs and constructs air conditioning and heating (HVAC) systems for hospitals and clinics. Currently the company's staff is overloaded with design work. There i

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