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 predict the future of the movie rental industry, Evaluate Netflix's ...

Evaluate Netflix's current strategy and determine if the strategy is sustainable. Identify a Netflix strength and suggest how this strength may be leveraged in the market place to

Describe potential key changes in technology, Discuss potential key changes...

Discuss potential key changes in technology, communications, and competition that Sigma will face in the future. Which will have the most impact on Sigma future marketing strategie

Depict serializability graphs, Draw serializability (precedence) graphs for...

Draw serializability (precedence) graphs for the following schedules and state whether each schedule is (conflict) serializable. For each serializable schedule, determine the equiv

Explain either party since the contract has been illegal, When a contract i...

When a contract is drawn up that becomes void due to illegality, do you believe that it involves the commission of a crime? Has a crime been committed by either party since the con

Explain technical or intellectual intelligence, It has been suggested that ...

It has been suggested that emotional intelligence is more important to good leadership than technical or intellectual intelligence. Do you agree or disagree with this suggestion? W

500, find the optimal location for kilroy"s distribution center in this exp...

find the optimal location for kilroy"s distribution center in this expanded version of the problem

Aid how to enter the answer after the equal sign using excel, Can someone s...

Can someone show me how to enter the answer after the equal sign using excel 2010

Explain could speed up a floor buffing machine, Consider this situation: Jo...

Consider this situation: Joseph had an idea that he could speed up a floor buffing machine by putting a different motor on it. After about 25 tries he was able to make a buffer run

Explain propose effective communication techniques, You are the civil engin...

You are the civil engineering foreman in charge of a 24-person group whose charter is to erect 3,000 tents for refugees who lost their homes in an earthquake. You have 10 days to a

Compute the appropriate loan table, You just took a $20,000, eight-year loa...

You just took a $20,000, eight-year loan. Payments at the end of each year are flat (equal in every year) at an interest rate of 8 percent. Calculate the appropriate loan table, sh

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