Calculate a forecast using exponential smoothing, Basic Statistics

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.

Posted Date: 2/28/2013 1:20:56 AM | Location : United States







Related Discussions:- Calculate a forecast using exponential smoothing, Assignment Help, Ask Question on Calculate a forecast using exponential smoothing, Get Answer, Expert's Help, Calculate a forecast using exponential smoothing Discussions

Write discussion on Calculate a forecast using exponential smoothing
Your posts are moderated
Related Questions
what are the different types of transfer pricing?

In 2009, the average number of runs scored in the National League was approximately 4.5 per team. Therefore, a team has done an adequate job with its offense if it scores at least

CASE STUDY 1 3 MARKS An audit of the accounting records of Loch Ness Ltd. for the year ending 30 June 2012 discovered that the ending inventory balance


uses of time series with example

find the variance of least square estimator beta hat for general linear regression model when k=2 in matrix form?

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

discuss the steps in preparing product cost allocation.

THE SIGNIFICANCE OF DATA EDITING

How to write it with business implication of the analysis?