Compute forecasted sales, 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 . The Table datas are as follows....... Mumbai: Op Bal = 120, safety Stk = 60, Min Ord Qty = 80, Lead Time = 1 Week, Transit = NIL, Sales Forecast Week 1 to Week 7 = 50,35,55,65,80,125 & 50 Respectively. Chennai: Op Bal = 350, safety Stk = 125, Min Ord Qty = 200, Lead Time = 2 Week, Transit = NIL, Sales Forecast Week 1 to Week 7 = 100,75,125,100,200,150 & 100 Respectively. Lucknow: Op Bal = 270, safety Stk = 150, Min Ord Qty = 200, Lead Time = 3 Week, Transit = NIL, Sales Forecast Week 1 to Week 7 = 150,100,150,200,300,200 & 100 Respectively. Delhi: Op Bal = 250, safety Stk = 100, Min Ord Qty = 100, Lead Time = 2 Week, Transit = NIL, Sales Forecast Week 1 to Week 7 = 50,75,80,55,75,80 & 90 Respectively. Kolkata: Op Bal = 350, safety Stk = 200, Min Ord Qty = 300, Lead Time = 3 Week, Transit = 300, Sales Forecast Week 1 to Week 7 = 100,150,200,135,125,165 & 200 Respectively


Related Discussions:- Compute forecasted sales

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

Make an aggregate plan using a spreadsheet, Helter Industries, a company th...

Helter Industries, a company that produces a line of women's bathing suits, hires temporaries to help produce its summer product demand. For the current four-month rolling schedule

Explain the manager would prefer ordering, A food processor uses approximat...

A food processor uses approximately 29,730 glass jars a month for its fruit juice product. Because of storage limitations, a lot size of 4,000 jars has been used. Monthly holding c

Develop a spreadsheet model as well corresponding data table, The circulati...

The circulation manager of The New York Times in State College, PA is trying to decide how many copies of the upcoming Sunday edition of the paper to order so as to meet the demand

Define what changes in dividends will affect the stock price, AirJet Best P...

AirJet Best Parts, Inc. is concerned regarding recent changes in its stock prices for the company and would like to determine the stock prices for key competitors. Key competitors

What are the pros and cons of flexible schedules for staff, What are the pr...

What are the pros and cons of flexible schedules from an employee's perspective?

Ethical issues that could comes in the underwriting process, What is the di...

What is the difference between rating and underwriting and how is it used? Identify and discuss any ethical issues that could arise in the underwriting process.

Explain net income, Scott Equipment Organization is investigating various c...

Scott Equipment Organization is investigating various combinations of short- and long-term debt in financing assets. Assume the organization has decided to employ $10 million in cu

Explain what has been their global competitive advantage, Select a company ...

Select a company of your choice. What has been their global competitive advantage (either successful or not)? If not, what would be your suggestion to this company if you were hire

Capacity planning and controlling, #theories and techniques can help if app...

#theories and techniques can help if applies properly.

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