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

Calculate the optimum order quantity, 1. The annual demand for a product is...

1. The annual demand for a product is 8,000 units. The order cost is $30 for a single order. The cost of the item is $10 and the holding cost has been calculated at $3 to carry one

Explain the pros and cons of the theory, Explain the McGregor's Theory x-y,...

Explain the McGregor's Theory x-y, the pros and cons of the theory

Explain profits and time based competitiveness, Small businesses have been ...

Small businesses have been slower to integrate information technology into their operations than larger companies. Discuss the reasons for this state of affairs, identifying severa

Define what kind of industries does a localization strategy, What kind of i...

What kind of industries does a localization strategy makes sense? Why? When does a global standardization strategy make most sense? Why?

Define customer driven analytic to make managerial decisions, 1) What assum...

1) What assumptions are necessary when using customer driven analytics to make managerial decisions? 2) How does the IT strategy of 7/11 influence other aspects of the business

Explain why marketing managers need research, Why do marketing managers nee...

Why do marketing managers need research and what is its role in decision making?

Operation function, meaning of operation function in operation management

meaning of operation function in operation management

Explain which option is more economical, A company is the logistics vendor ...

A company is the logistics vendor for B Company. B has daily shipments of a power-steering pump from its Ohio plant to an auto assembly line in Alabama. The value of the standard s

Sample range chart - control charts for variables, Sample Range Chart - Con...

Sample Range Chart - Control Charts for Variables Whilst the sample mean chart provides control over the process setting, it provides no protection from change (increase) in t

How to be market leader in an industry?, If a company needs to maintain mar...

If a company needs to maintain market position as a leader in its segment and to increase the same in future, the company is carrying out few initiatives like Innovation

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