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
Multi stage Sampling: This is a further development of cluster sampling. This techniques is meant for big inquiries extending to a considerably large l geographical area like an en

It's a fact of business–if an organization has workers, it has to account for paycheck and edge advantages. In this description of paycheck bookkeeping we'll present paycheck, e

Terry Co. manufactures a commercial solvent that is used for industrial maintenance. This solvent is sold by the drum and generally has a stable selling price. Due to a decrease in

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

Regression line drawn as Y =C+1075x, when x was 2, and y was 239. Given that y intercept was 11. Calculate the residual.

A game that friends and I try to play to guess how long it takes a ball to fall to the bottom of a cone and how many revolutions around the cone it will take. I do not have a lot

Three major Accounts and their Rules There are three major Records which are a) Personal Accounts b) Real Accounts c) Moderate Accounts Rule for Personal Account: Ch

Research Question: Percentage of students who drank a can, bottle, or glass of soda or pop (not including diet soda or diet pop) at least 1 time per day during the seven days

how to find mode graphically when the biggest rectangle is at the end

Certificate of participation [cop) A debt financing agenda administered by the Office of the State Treasurer, A COP is an instrument evidencing a pro rata split in a exact pledged