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 computer and open the database using access, In Doc Sharing, you wi...

In Doc Sharing, you will find an Access database labelled Week 4 Discussion North wind. Save the database to your computer and open the database using Access. Answer the questions

Production process, with the help of a diagram, describe the production pro...

with the help of a diagram, describe the production process.

Explain crises are a regular part of organizational life, How do you think ...

How do you think planning in today's organizations compares to planning 25 years ago? Do you think planning becomes more important or less important in a world where everything is

Explain minimization and maximization problems using lp, What are the simil...

What are the similarities and differences between minimization and maximization problems using LP

Order winners - operations strategy, Order Winners - Operations Strategy ...

Order Winners - Operations Strategy These are operational capabilities that directly contribute to winning business. They are generally cited as the reasons for the purchase o

What are the main points of the new science of leadership, Based on the Lon...

Based on the London interview with Margaret Wheatley, "The New Science of Leadership," write 2 paragraphs describing Wheatley's theories and perspectives of leadership and organiza

Explain life span of a randomly selected battery, The lifetime of a battery...

The lifetime of a battery is normally distributed with a mean life of 40 hours and a standard deviation of 1.2 hours. Find the probability to a z-value of 4.16 in 0.9998 a. A rando

Explain supply chain risk management tools, Of the barriers to supplier dev...

Of the barriers to supplier development mentioned in this chapter, which ones, in your opinion, are the most difficult to overcome? 2. Describe the major sources of supply base ris

Explain units of output per dollar of input, A hamburger factory produces 4...

A hamburger factory produces 40,000 hamburgers each week. The equipment used costs $5,000 and will remain productive for 4 years. The labor cost per year is $9,500. a. What is the

Define globalization of health care good or bad for patients, Is the global...

Is the globalization of health care good or bad for patients? Who might benefit from the globalization of health care? Who might lose?

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