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
Financial evaluation of projects The net provide value of a venture is the provide value of future repayments reduced by the provide value of expenditures. The amount of lower pric

State income tax In most declares paycheck accounting will involve a condition earnings tax. In those declares a company is necessary to hold the condition earnings tax that an

Agency funds,define it Organization money is used to account for the resources presented by the state as an agent for individuals, private companies, and other health systems. Orga

AXIOM, usually, it is a saying that is commonly recognized on its own merits; in sense, it is an idea that is not vulnerable of confirmation or disproof; its reality is believed to

This question has multiple parts. Use the following information to answer the questions below: Spatial Ability Test Musical Ability Test Mean 80 74 Standard Deviation 6

In marketing research field surveys are commonly used to collect primary data from the respondents. 1. Through Personal Interviews: The investigator follows a rigid proced

Design an activity based cost system requires that: a) the job bid process redesigned b) resource costs be linked to the activities performed c)the cost of activities be linked to

Model 1:  Let's consider the logistic regression model, which we will refer to as Model 1, given by log(pi / [1-pi]) = 0.25 + 0.32*X1 + 0.70*X2 + 0.50*X3

For this second assignment you will have to use the OECD database to investigate possible changes in the policy preferences of Western welfare states. You have to develop (i) an in

explain the graphical method of measure of central tendency.