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 do hr managers cope with stress, Why hr managers, etc. Is a lon...

Why hr managers, etc. Is a lonely job? How do hr managers cope with stress? What does it take to become a hr manager? Reference and cited

Number defective - np chart, Number Defective - Np Chart This type of ...

Number Defective - Np Chart This type of chart can be used when it is possible to establish a constant sample size n. It has the advantage that it is readily understood by use

Estimate the mean and standard deviation, 1. How do variables and attribute...

1. How do variables and attributes differ?  2. Estimate the mean and standard deviation of the following measurements.

Explain first step in your data analytical project, Your final project enta...

Your final project entails systematic extraction of decision-aiding insights out of a dataset provided to you in the Doc Sharing area. This project will provide you with hands-on e

Explain sarbanes-oxley act promote ethical behaviour, Identify three of the...

Identify three of the criminal penalties that can be charged under the Sarbanes-Oxley Act. How do these sections of the Sarbanes-Oxley Act promote ethical behaviour by corporations

Define the order quantity and expected profits, suppose the manufacturer ha...

suppose the manufacturer has an inflated demand forecast as follows: Quantity Probability 2,200 5% 2,300 6% 2,400 10% 2,500 17% 2,600 30% 2,700 17% 2,800 12% 2,900 3% (a) Suppose t

Explain how many hours would the average laborer, In December, general moto...

In December, general motors produced 7,200 customized vans at its plant in Detroit. The labor productivity at this plant is known to have been 0.10 vans per labor hour during that

Explain organization to appraise performance formally, Why is it necessary ...

Why is it necessary for an organization to appraise performance formally? Describe some situations in which an organization would be wise if it did not appraise performance formall

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