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 human relations movement, Compare and contrast Scientific Managemen...

Compare and contrast Scientific Management and the Human Relations Movement

Explain what is the formula for calculating duration, Answer the following ...

Answer the following questions (use MS Project help if necessary)- Define effort-driven? Under what circumstances would you turn off effort driven scheduling? Use a real-w

Simulation, Which of the following probability distributions cannot be simu...

Which of the following probability distributions cannot be simulated ?

Explain when it comes to team identity, When it comes to team identity, wha...

When it comes to team identity, what activities would you recommend to strengthen the team identity and, presumably, improve effectiveness of the team?

Location decisions, the globalization and geographic dispersion of operatio...

the globalization and geographic dispersion of operations

Explain characterize the bacterial and bacterial-like, Characterize the bac...

Characterize the bacterial and bacterial-like STIs, focusing on infectious agents and manifestations

#production and material management, What are the features of dynamic purch...

What are the features of dynamic purchasing? How it''s affects the store keeping and warehousing?

Explain what are the primary pruposes of holding inventory, The key points ...

The key points in Chapter 12 (Chapter 13) tell us that good inventory management is important for successful organizations. The key issues are when to order and how much to order.

Explain low quality leader-member exchange, 1) Discuss two factors that cou...

1) Discuss two factors that could affect what leadership style is most appropriate in a given situation. 2) Give an example of a manager who successfully or unsuccessful balanced c

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