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

Describe customer service level for an inventory system, Discuss customer s...

Discuss customer service level for an inventory system within the context of quality management

Explain what is the multifactor percentage change in product, 1. Long Beach...

1. Long Beach Bank employs three loan officers, each working eight hours per day. Each officer processes an average of five loans per day. The bank's payroll cost for the officers

Who all are stakeholders affected by the stores'' decisions, Neda operates ...

Neda operates a small convenience store in a southern town that has a high tourist draw. After several years of operating the store, Neda has decided to no longer sell tobacco prod

Explain what is the utilization of the machine, Suppose jobs arrive at a si...

Suppose jobs arrive at a single? Machine workstation at a rate of 20 per hour and the average process time is 2.5 minutes. a. What is the utilization of the machine? b. Sup

Explain level production and chase production strategies, Henderson Furnitu...

Henderson Furniture sells reproductions of 18th century furniture. For a particular table, the following information is valid. Month | Demand Jan 81 Feb 89 Mar 100 Apr 130 May 97 J

Routing procedure, Routing Procedure For a new product or part the rout...

Routing Procedure For a new product or part the routing procedure consists of seven principle steps: 1.The first step is to analyze the product or articles and fabricate int

Explain career progression of individual, Explain career progression of ind...

Explain career progression of individual and performance appraisal. Performance Appraisal and Individual's Career Progressio: Performance appraisals assist in unearthing

Explain acceptability and vulnerability, Describe the four options highligh...

Describe the four options highlighted in the case in terms of their feasibility, acceptability and vulnerability.

Lpp, A paper mill produces two grades of paper viz., X and Y. Because of ra...

A paper mill produces two grades of paper viz., X and Y. Because of raw material restrictions, it cannot produce more than 400 tons of grade X paper and 300 tons of grade Y paper i

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