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

Psy1110 Module 2, Which of the following does Utts consider a disaster in s...

Which of the following does Utts consider a disaster in sampling?sk question #Minimum 100 words accepted#

Tootsie roll industries, I am in need of your help again. First and foremo...

I am in need of your help again. First and foremost, I thought I had created an account, but none could be found. In any event here is my assignment. Should you decide that you

Kripsy kreme, How did round trip transactions violatet the revenue recognit...

How did round trip transactions violatet the revenue recognition principle?

Graph, what is the difference between histogram and historigram

what is the difference between histogram and historigram

What is Appropriation , What is Appropriation A legal endorsement for an ...

What is Appropriation A legal endorsement for an organization to make expenses for particular requirements from particular options available or approximated to be available durin

Co-efficient of covariance., solution of problems based on coefficient of c...

solution of problems based on coefficient of covariance

Normal reaction, Normal Reaction: When two materials are in get in touch wi...

Normal Reaction: When two materials are in get in touch with, then the materials put out makes on each other. The makes are reverse to each other in route and are similar to each o

Ms 4, 2. From the following cost, production and sales data of Decors Motor...

2. From the following cost, production and sales data of Decors Motor Ltd., prepare comparative income statement for three years under (i) absorption costing method, and (ii) margi

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