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 interest rate risk, Please give a detailed explanation on the follo...

Please give a detailed explanation on the following scenario: You are a swap dealer and know that XYZ County finance director is clueless about how to conduct interest rate risk ma

Explain efficiently report of schedule of a project, Illustrate how to effe...

Illustrate how to effectively and efficiently report on the schedule of a project to the different stakeholder groups. Show calculations and provide rationale for each strategy.

Facility layout, critic facility layout of an organisation

critic facility layout of an organisation

Explain before formalizing the foreign relationships, Many entrepreneurial ...

Many entrepreneurial organizations have established partnerships in other countries (i.e., Toyota in the United States, Nike in Thailand, etc.). What do entrepreneurial organizatio

Factor rating method, East Coast Manufacturing, Inc. plans to locate a new ...

East Coast Manufacturing, Inc. plans to locate a new production facility in Hartford, Philadelphia, or Baltimore.  Six location factors are important:  cost per product unit, labor

Explain several influencing factors, Forecasts for groups of items tend to ...

Forecasts for groups of items tend to be less accurate than forecasts for individual items because forecasts for individual items don't include as many influencing factors.

Explain why is basic instruction valuable, Why is basic instruction valuabl...

Why is basic instruction valuable? When should it be used?

Explain what are the internal and external factors, What are the internal a...

What are the internal and external factors (HR/Business) that will affect the global organization today when doing business overseas

Explain what changes in culture are needed at the plaza inn, 1. How could t...

1. How could the Plaza Inn develop a collaborative strategy? Develop a specific plan. 2. How could technology help solve the problems at the front desk? Explain what you propose

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