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
Difference between historigram and histogram

Long Term Credit Decision In no more than one typed page, provide a statement of your decision to lend or not lend to this company based on your interpretation of the company'

Bonded warehouse is a storage area under Customs authority that is imported dutiable goods on which duty is unpaid and these are stored. Once the duty & other charges are paid the

A survey was conducted among the residents of Pune City, its suburbs and the Pune Cantonment area. The following three pie diagrams show their respective preferences for living in

We have two applicants who are applying for a job. They both took the high school exit exam, but different ones. Shannon took the ACT and scored 26, Frank took the SAT scored 1350.

Project I The trial balance of the Parton Wholesale Company contained the following accounts at December 31, 2010 the end of the company’s calendar year. PARTON WHOLESALE COMPA


The square of the sample correlation coefficient is typically denoted r2 and called the coefficient of determination. It estimates the fraction of the variance in Y that is explain

I need help with ledger accounts and the financial statement

Data was gathered on a group of ninth grade students. Some students have been diagnosed with a learning disability.  All students were measured on conduct, attention, hyperactivity