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 quantitative risk so important in risk mitigation, Why is quantitat...

Why is quantitative risk so important in risk mitigation? Explain how you have seen this in action in life or in your organization.

What are the advantages of the demand management strategies, What are the a...

What are the advantages of the demand management strategies? The advantages of the demand management strategies are as illustrated here: a. While ‘off peak’ quite than contr

Explain visual inspection, Develop a forecast for years 2 through 12 using ...

Develop a forecast for years 2 through 12 using exponential smoothing with ? = .4 and a forecast for year 1 of 6. Plot your new forecast on a graph with the actual data and the nai

Explain typical complaints, Do results from the survey illustrate typical c...

Do results from the survey illustrate typical complaints about teams and specifically about team incentive rewards?

Appropriate control limits for the data, A quality team at Milburn Textiles...

A quality team at Milburn Textiles has been charged with setting up control charts to monitor a key dyeing process that has been improved and now stable.  The ideal temperature for

Explain rules of the irs and department of labor, Rules of the IRS and depa...

Rules of the IRS and department of labor determine which workers quailfy as indenpendent contractor?

Locating production and service facilities, if you expand your existing com...

if you expand your existing company by opening a new divition in a foreign country, shouldthe new divistion be staffed by local personnel or by personnel imported from the parent o

Digitra; cell phone, Ask que Prepare Paul Jordan’s report to John Smithers ...

Ask que Prepare Paul Jordan’s report to John Smithers using regression analysis. Provide a summary of the cell phone industry outlook as part of Paul’s response. stion #Minimum 100

Explain what is the yield to maturity on this bond, Plasma TV Corporation b...

Plasma TV Corporation bonds are currently priced at $1,088. They have 12 years until maturity and a coupon rate of 6%. What is the yield to maturity on this bond?

Define summarize the organization technological solution, 1. Briefly summar...

1. Briefly summarize the organization technological solution. 2. Would you classify this as an enterprise or workgroup solution (review the Case Study Areas of Focus document in

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