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 strategy is a common term in business, Strategy is a common term in...

Strategy is a common term in business. Is it a concept and/or a construct? Explain. Define it as a concept and/or a construct.

Explain charge of maintaining hospital supplies, Barbara Flynn is in charge...

Barbara Flynn is in charge of maintaining hospital supplies at General Hospital. During the past year, the mean lead time demand for bandage BX-5 was 60 (and was normally distribut

Explain a process capacity methodology, A process capacity methodology that...

A process capacity methodology that is used to show how well parts being produced fit into a range specified by design limits is which of the following? Answers- a. Answer n

Define construct a stem-and-leaf display, Use the data in Exhibit 16-5 to c...

Use the data in Exhibit 16-5 to construct a stem-and-leaf display

Define service and manufacturing organizations, Identify and discuss five d...

Identify and discuss five differences between service and manufacturing organizations.

Describe the history of welfare reform, Discuss the history of welfare refo...

Discuss the history of welfare reform. Discuss some of the historical aspects and your opinion about how these changes were implemented and whether or not the changes were effectiv

Describe analyze the elements of a typical scope statement, Analyze the ele...

Analyze the elements of a typical scope statement and the significance of each element. As a project leader, determine how you would communicate the scope of a project to the proje

Customer interface, as a customer service employee to university explain me...

as a customer service employee to university explain measures you would recommend to make even displeased student to patronise the school canteen

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