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 is the bias, Given forecast errors of 5, 0, - 4, and 3, what i...

Given forecast errors of 5, 0, - 4, and 3, what is the bias?

Explain what is the expected growth rate, Sidman Products' common stock cur...

Sidman Products' common stock currently sells for $51 a share. The firm is expected to earn $6.10 per share this year and to pay a year-end dividend of $2.40, and it finances only

Explain expression for total revenue, There is a fixed cost of$50,000 to st...

There is a fixed cost of$50,000 to start a production process. Once the process has begun, the variable cost per unit is $25. The revenue per unit is projected to be $45. Expressio

Location analysis, explain the series of steps involved and various factor...

explain the series of steps involved and various factor effecting location decion?

Describe harley davidson has excess capacity, Harley Davidson sells motorcy...

Harley Davidson sells motorcycle X and Y. Motorcycle X sells for $10,000, has variable cost (labour and material) of $2,000, and requires 10 hours of use of machinery to produce. M

Explain sole responsibility for prioritizing, Customers have the sole respo...

Customers have the sole responsibility for prioritizing their own needs, selecting a contractor to perform their project, and terminating a project that is not working.

Explain the government affected by the bp oil spill sin usa, How was the go...

How was the government affected by the bp oil spill sin usa

Define as a labour relations specialist in the hr department, The committee...

The committee is asking you, as a labour relations specialist in the HR department, whether this wording is likely to be acceptable

Explain hospital risk pool, A hospital has contracted with an HMO to provid...

A hospital has contracted with an HMO to provide acute care inpatient services for $1,000 per day, subject to a 10 percent withhold. The proposed budget for inpatient services is b

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