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

Tandard deviation of the sample of juveniles, The National Marine Fisheries...

The National Marine Fisheries Services is part of the National Oceanic and Atmospheric Administration. NMFS's programs support the conservation and management of living marine reso

Relationship between mediation activity, Is there a relationship between me...

Is there a relationship between mediation activity and cooperation between two nations in conflict? A data set was assembled across 15 time periods. Both variables were measured on

Total stockholders equity, To determine the amount at which inventory shoul...

To determine the amount at which inventory should be reported on the December 31 Year 1 balance sheet, Monroe Company compiles the following information for its inventory of Produc

To find first quartile, how to find 1st quartile from the graph of more tha...

how to find 1st quartile from the graph of more than ogive type, please reply me with an example

Books of original entry, Books of original entry Books of original entranc...

Books of original entry Books of original entrance are a record in which the various or many other transactions are initially and formally recorded and serve up as the straight so

Kurtosis, how solve and get kurtosis

how solve and get kurtosis

Homework help, example of descriptive statistics in word form

example of descriptive statistics in word form

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