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
Define BIENNIUM A 24-month fiscal era. In Washington, the biennium expands from July 1 of odd numbered years to June 30 of odd numbered or more years.

Examine the distributions of weight and height. Are there any outliers? If so deal with them appropriately. Create a new variable that divides weight into groups. Produce a tabl

All procedures that discover, recognize history, move, sustain, and review economical information to either generate economical statements or to provide inner control.

A, Suppose a CD player player tries to detect whether its partner is C player instead of a DD player by looking for external signals that are at least as typical for DD players tha

I am Hussain and I have done master in Statistics. Currently I am doing Mphil Statistics from Pakistan. I want to get online Statistics Tutor job. So contact with me as soon as pos

a business was started on January 1, 2011 and $1000 of supplies to use in the business. At the end of the month 25% of the supplies remains unpaid and 20% are still on hand. what a

Budgetary accounts Accounts used to go through the adopted budget into the all-purpose ledger as part of the administration control method of formal budgetary addition.

Write a report to an investor comparing the performance by using the financial statements between two different companies

For the month of June, Department A of Pauley Inc. had a segment margin ratio of 15%, a variable expense ratio of 60% of sales, and traceable fixed expenses of $15,000. Department