Calculate a forecast using exponential smoothing, Basic Statistics

Assignment Help:

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.


Related Discussions:- Calculate a forecast using exponential smoothing

F2 test distributed populations, What is F2 Test, These tests were based o...

What is F2 Test, These tests were based on the assumption that the samples were drawn from normally distributed populations, or more accurately that the sample means were normally

Accounting equation, received security deposits from tenant how does it wil...

received security deposits from tenant how does it will be shown in accounting equation

What is a purchase allowance, What is a purchase allowance? A buy permi...

What is a purchase allowance? A buy permitting is a reduction in the customer's cost of products that it had purchased. The buy permitting is granted by the provider because of

Answer, Would like to know answer to gametes problem

Would like to know answer to gametes problem

Incomplete accounts, HOW TO PREPARE INCOMPLETE ACCOUNTS CORRECTLY?

HOW TO PREPARE INCOMPLETE ACCOUNTS CORRECTLY?

Estimate the cost of producing, Consider the manufacturing system presented...

Consider the manufacturing system presented in the article by Yu and Bricker (1993). The management would like to purchase new machine tools more reliable and more high accuracy

Recruitment process process map, What are the steps in a recruitment proces...

What are the steps in a recruitment process and who are responsible for each step?

Drawing a Diamond Card Question, Find the probability of drawing a diamond ...

Find the probability of drawing a diamond card in each of the consecutive draws from a well shuffled pack of cards, if the card drawn is not replaced after the first draw

Quantitative techniques and decision making, Let the national income model ...

Let the national income model be: Y= c+1+G C=20+0.6y I=0.2y G=20 Where y= income, C= consumption, I= investment and G=government expenditure find y, C and I from the model. By quan

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd