Calculate a forecast using exponential smoothing, Basic Statistics

Assignment Help:

The Midwestern Manufacturing Company (MMC) is a large manufacturer of electrical generators.  The firm has experienced demand for their generators as shown below:

Year  Demand

2003      74

2004      79

2005      80

2006     90

2007    105

2008    142

2009    122

For the questions below, create EXCEL worksheets naming the tabs as indicated.

a. Calculate a forecast for 2010 using a 3 year moving average. Place your results in a worksheet tab named Q1.

b. Calculate a forecast for 2010 using exponential smoothing. Use .7 as your Alpha value. Place your results in worksheet tab Q1.

c. Using Mean Absolute Deviation as your criteria, determine which method performs best. Explain your decision. Place your results in worksheet tab Q1.


Related Discussions:- Calculate a forecast using exponential smoothing

Analyze anova , A nurse researcher is investigating the effect of timing of...

A nurse researcher is investigating the effect of timing of standard pain control interventions on severity of pain in adolescents with sickle-cell disease.  She establishes three

General journal, Can you do my accounting assignment?

Can you do my accounting assignment?

What are the decision variables, Question 1 Water resources in many pa...

Question 1 Water resources in many parts of Australia are being closely watched and restrictions have been imposed on activities such as garden watering. Suppose that SA Water

Find out revised probabilities for symptoms, This problem set consists of t...

This problem set consists of three problems and a short essay.  Each problem is worth 7 points, the essay is worth 4 points for a total of 25 points. 1.  What are the chances th

Paasche` quantity index calculationca, Base year price 10,12,18,20 and quan...

Base year price 10,12,18,20 and quantity 49,25,10,5 respectively. current yr quantity 50,20,12& 2

Treatment of cst and vat, Treatment of CST and VAT in Sales Book A suppl...

Treatment of CST and VAT in Sales Book A supplier who expenses the CST for inter declares purchase by him, is responsible to first deposit the gathered CST from bought to Got Co

Electric fields, 2. Two disks, each of radius 10.0 cm, are charged so that ...

2. Two disks, each of radius 10.0 cm, are charged so that one has a charge of +10.0 nC and the other has a charge of -10.0 nC. The disks are then placed with their flat faces facin

Projectile, two object are on the same level we release the first one verti...

two object are on the same level we release the first one vertically and the other one with an initial velocity which object will land first?

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