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 annual number of orders, Office Supreme, Inc., a local ...

Office Supreme, Inc., a local retailer of office supplies, faces demand for one of its inventory items at a constant rate of 240,000 units per year. It costs Office Supreme $38 to

Explain should galanz have evolved from being an oem, Should Galanz have ev...

Should Galanz have evolved from being an OEM to being an OBM?Is Galanz structured to compete as an OEM? Why or why not?

Explain what would be your total cost, A manufacturing firm is considering ...

A manufacturing firm is considering two locations for a plant to produce a new product. The two locations have fixed and variable costs as follows: Site Fixed Cost (Annual) Variabl

Explain what the term data redundancy means, Describe what the term "data r...

Describe what the term "data redundancy" means in database design. Explain if it is bad and if a normalized database design is always the best design. Discuss the pros and cons of

Define challenges has the european union consortium faces, Describe what ch...

Describe what challenges has the European Union Consortium faced in the last 2-3 years

Time study - process design, Time Study - Process Design Time study by...

Time Study - Process Design Time study by stopwatch or micro-motion analysis is the original method of work measurement devised by Taylor and his followers, and is still routi

Explain the sdlc contains seven phases, The SDLC contains seven phases, whi...

The SDLC contains seven phases, which phase transforms the design into an actual system

Explain to beat the competition to a sale, During the holidays, companies o...

During the holidays, companies often provide gifts to customers. The more a client spends, the larger the gift, usually. To segment customers in this way, for what purpose is this

Explain what are the speeds of the objects after collision, A mass of 10kg ...

A mass of 10kg travelling at 5 m/s undergoes a head on elastic collision with a 7kg object travelling at 9 m/s in the opposite direction. What are the speeds of the objects after c

Explain higher level of economic performance, Can someone help me figure th...

Can someone help me figure this one out? Which firm will have a higher level of economic performance? a) A firm with valuable, rare, and costly to imitate capabilities competing in

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