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

Define construct the linear programming model, A farmer has 10 acres to pla...

A farmer has 10 acres to plant in wheat and barley. He has to plant at least 7 acres. However, he has only $1200 to spend and each acre of wheat costs $200 to plant and each acre o

What is the relationship among companies and profit motives, What is the re...

What is the relationship between companies, profit motives, competition and private property?

Explain identify the basic control issues at unilever, Identify the basic c...

Identify the basic control issues at Unilever from all three levels? How do you think the control function should be organized and managed at Unilever?

Explain affect your overall impression of the candidate, How does the use o...

How does the use of music in political play a role in establishing a candidate's brand? Does a candidate's use of a song you like (or dislike) affect your overall impression of the

Non-registered investment assets, They have set up two TFSAs for long-term ...

They have set up two TFSAs for long-term savings. One has a balance of $10,123 ($10,000 contributions, $123 in interest income for one year ). These funds are currently earn

Finish a net material requirements schedule, Complete a net material requir...

Complete a net material requirements schedule for: a) All items (10 schedules in all), assuming the requirement for each BOM item is 1. b) All 10 items, assum

Explain calculated values in descending order on the same, Create a procedu...

Create a procedure in VBA to do the following actions: -Create a linear series of numbers starting at 1 (e.g. 1, 2, 3,) -Display a Message Box asking if you'd like to calculate ano

Explain the stage in the product life cycle labeled a, The stage in the pro...

The stage in the product life cycle labeled A in the below figure is called introduction. maturity. growth. diversification. decline.

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