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

State income tax, State income tax In most declares paycheck accounting...

State income tax In most declares paycheck accounting will involve a condition earnings tax. In those declares a company is necessary to hold the condition earnings tax that an

Calculate the average account balance, In June 2009, the average Australian...

In June 2009, the average Australian credit card account balance was $3,127, according to data extracted Assuming that these balances are approximately Normally distributed with a

What is accounting system , The methods and records established to recogniz...

The methods and records established to recognize, set up, evaluate, move, record, and report the state’s purchases and to maintain responsibility for its obligations and resources

Regression line, regression line drawn as Y=c+1075x, when x was 2 and y was...

regression line drawn as Y=c+1075x, when x was 2 and y was 239, given that y intercept was 11. calculate the residual

Why is interest expense a no operating expense, Why is interest expense a n...

Why is interest expense a no operating expense? Attention cost is a no operating cost when it is not part of a business's primary functions. For example, a store's primary func

Sample space of an experiment, 1.The resumés of 2 males applicants for a co...

1.The resumés of 2 males applicants for a college teaching position in chemistry are places in the same file as the resumés of 2 female applicants. Two positions become available a

Explain accounting methods, Define various methods in accounting, specifica...

Define various methods in accounting, specifications and procedures.

QT, Following is the trend equation for a time series data on a monthly bas...

Following is the trend equation for a time series data on a monthly basis for years 2007 to 2009: Y=2.375+0.895X. Find Y for 2nd quarter of 2010.

Probability, 1) A certain brand of batteries has a lifetime that has a norm...

1) A certain brand of batteries has a lifetime that has a normal distribution with a mean of 3,800 hours and a standard deviation of 390 hours. b) What lifetime should the manufac

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