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 traditional and horizontal organization structure, Identify the mai...

Identify the main types of traditional and horizontal organization structure. Using an organization of your choice as an example how is the structure of the organization a reflecti

Explain the concept of globalization many businesses operate, Based on the ...

Based on the concept of globalization, many businesses operate and compete in a global environment. Describe the additional factors that affect/impact global supply chains.

Describe the relevance of tqm, Explain the relevance of TQM in decision mak...

Explain the relevance of TQM in decision making and controlling processes.

Control charts for attributes - statistical process control, Control Charts...

Control Charts for Attributes - Statistical Process Control Attribute data assume only two values, such as pass/fail or good/bad: they are counted rather than measured. Many q

Scheduling - aggregate planning, Scheduling - Aggregate Planning Mean...

Scheduling - Aggregate Planning Meaning and Definition Scheduling may be defined as the assignment of work to the facility with the specification of times ,and the sequence

Define frame relay is a technology that does noerror control, Frame relay i...

Frame relay is a technology that does no error control. If a frame arrives garbled, it is dropped and frame relay does not inform the transmitter. Is this a reasonable approach?

Explain would the public approve of this campaign, The marketing team prese...

The marketing team presents a children's cereal brand manager with "Less Sugar" ad campaign for three of her brands. Large print and dynamic type on the package exclaiming "75% LES

Explain public sector unions, Public sector unions now account for more tha...

Public sector unions now account for more than half of union members, while the private sector accounts for less than half. Why has this change occurred?

Column minima method, Column Minima Method: Step 1: Determine  the  ...

Column Minima Method: Step 1: Determine  the  smallest cost in  the first  column  of the  transportation  table. Let it be  C1j  . allocate  Xi1= min ( ai bi ) in the cell

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