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
Refund can be defined as return of a part of a purchase price by a seller to a buyer, usually on a purchase of a specified quantity or a value of goods within a specified period.

standard material qty per unit- 2 kg standard price per kg - 4 rs actual value of material purchased- 4000 rs closing stock- 200 kg actual usage- 2.5 kg finished stock sold- 200 u

Armitage-Dollmodel The model of carcinogenesis in which the basic idea is that the essential variable determining the change in the risk is not age, but time period. The model

Question: The weights shown in the figure are in equilibrium. It consists of objects held by vertical strings. The object 3 weighs 1.4 N. The horizontal bars are identical, uniform

what is an exclusive probability

#question.differentiate between historigram and histogram.

Susan’s proposed budget for 2011 includes a substantial repayment of the bank loan. If the repayment occurs, is the firm likely to break even in 2012? Explain.

formula for calculating paasches quantity index

various types of index numbers constructed in india ????

The researcher and the respondents do not come in contact with each other if this method of survey is adopted Questionnaires are mailed to the respondents with a request to re