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 what is the roic, (Oscar's Office Building) Oscar is considering ge...

(Oscar's Office Building) Oscar is considering getting into the real estate business. He's looking at buying an existing office building for $1.8 million in cash. He wants to estim

Compute the value of cash flow based on discount rate, Calculate the presen...

Calculate the present value of a stream of cash flows based on a discount rate of 8%. Annual cash flow is as follows 1. Year 1 = $100,000 2. Year 2 = $150,000 3. Year 3 = $200,0

Explain production department says that to achieve, The sales department te...

The sales department tells management that they can increase revenue by 20 percent by increasing sales 20 percent, but the production department says that to achieve that number of

Sequencing.., program to find optimal sequence, total elapsed time and tota...

program to find optimal sequence, total elapsed time and total idle time in 6 jobs and 3 machines

Explain what does the supervisor need to be most careful, What does the sup...

What does the supervisor need to be most careful of in following up on delegation? Why?

Explain the ebq model, Applying the EBQ model, what batch size would you re...

Applying the EBQ model, what batch size would you recommend for this product? How long will each batch take to produce, and how many batches per year will be made? Should this mode

Explain bottlenecks that may occur during the project, Briargrove has agree...

Briargrove has agreed to your plan. The CLN Team is asking for a refined version of the plan making the corrections based on their recommendations. They are requesting a comprehe

What deliver the message to management, Please give a detailed explanation ...

Please give a detailed explanation for the answer for the following scenario: As the manager of a plant, you have seen production increase by 20% over the past year, but you have a

Explain labour practices requirements, From the legal perspective, what cha...

From the legal perspective, what challenges May supervisors face in filling the positions? How might they unintentionally run short of regulatory hiring and labour practices requir

Explain what is cross-functional decision making process, What is cross-fun...

What is cross-functional decision making process, strategy model, and supply chain?

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