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 sources of manpower recruitment, Explain Sources of Manpower Recrui...

Explain Sources of Manpower Recruitment. Sources of Manpower Recruitment:  (i) From in the Company The sources of manpower recruitment for any company are as following

Define what would be the percentage increase in productivity, An operation ...

An operation produces 190 units per hour with a scrap rate of 10 percent. If we could eliminate the scrap completely, what would be the percentage increase in productivity per hour

Describe what order quantity is optimal, The manager of a car wash received...

The manager of a car wash received a revised price list from the vendor who supplies soap, and a promise of a shorter lead time for deliveries. Formerly the lead time was four days

Explain the way of clear communication, On a recent trip to India, Mr. Yang...

On a recent trip to India, Mr. Yang, a prominent Chinese executive, dined with his client Himanshu Jain. Mr. Yang commented that the food was spicy, which Mr. Jain interpreted as a

Predetermined time standards (pts) - process design, Predetermined Time Sta...

Predetermined Time Standards (PTS) - Process Design This is a work measurement technique whereby times established for basic human motions (classified according to the nature

Explain low customer contact and are capital intensive, What are companies ...

What are companies that have low customer contact and are capital intensive; yet provide a service, called?

Explain objectives of job evaluation, Explain objectives of job evaluatio. ...

Explain objectives of job evaluatio. Objectives of job evaluation: a) Decides the relative values of various jobs in an organization.  b) Helps to formulate a suitable a

Explain supply base innovation and risk management, Why are supply base inn...

Why are supply base innovation and risk management two future areas that will consume more of the supply manager's day?

Explain the ftc prohibit the use of this commercial, Perfect Face Cream ran...

Perfect Face Cream ran a commercial to showcase its new Wrinkle-Free Face Cream. The commercial showed an older woman with severe wrinkles followed by images of that same woman aft

Explain how many observations would be needed, To determine the standard wo...

To determine the standard working time for a special job, following observation data is collected: Observation 1 2 3 4 5 6 7 8 Time (in second) 17 18 15 14 13 15 16 13 a) If the pe

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