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

Asset, what''s the asset?

what''s the asset?

Define Manufacturing Overhead Costs, In the financial statements, each prod...

In the financial statements, each product must include the costs of the given below: Direct labor Direct material Manufacturing or factory overhead The costs that would typically b

Precious harper, October Transactions Date Transaction Description Oct. 1 ...

October Transactions Date Transaction Description Oct. 1 Began business by making a deposit in a company bank account of $12,000, in exchange for 1,200 shares of $10 par value com

AUTOMATED TELLER MACHINE (ATM) , AUTOMATED TELLER MACHINE (ATM) Computer m...

AUTOMATED TELLER MACHINE (ATM) Computer managed devices placed at a financial institution division or other place, which allow a client to execute primary checking actions (such a

Statistics, 1. A search engine site claims that, on average, one out of fi...

1. A search engine site claims that, on average, one out of five visitors clicks on an ad. (a) If 8 users visit the site, what is the probability that at least three click o

Example of inference, Q. Example of inference? Ans. Thirty student...

Q. Example of inference? Ans. Thirty students from a college were surveyed and classified according to two variables: (1) gender (M/F) and (2) major (liberal arts, busines

SPSS, Assignments due 9/14/2012 Need pricing

Assignments due 9/14/2012 Need pricing

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