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

Explain the financial accounting., Explain the Financial Accounting. Und...

Explain the Financial Accounting. Under the Financial Accounting System the producing of economic purchase are done in the Cash and Publication, in other Bookkeeping as Sales, P

Find the mean and standard deviation, A travel agency surveyed 38 customers...

A travel agency surveyed 38 customers holidaying in Australia who took their spouses on either a skiing or a golfing vacation.  The data comprises amounts (in hundreds of dollars).

Clipping, Clipping is one form of distortion that occurs when an amplifier ...

Clipping is one form of distortion that occurs when an amplifier is overdriven, which happens when it attempts to increase voltage or current beyond its limits. When an amplifier

Time series, Methods of measuring secular trend

Methods of measuring secular trend

What is portfolio ratio, Describe portfolio ratio, i need assignment help i...

Describe portfolio ratio, i need assignment help in portfolio ratio based questions.

Employer''s fica tax rate for 2012, Employer's FICA tax rate for 2012 Th...

Employer's FICA tax rate for 2012 The employer's FICA tax amount for 2012 involves 1) the Public Protection tax amount of 6.2% of each individual's first $110,100 of income, inc

Management accounting, Defination,Advantages and Limitation, Proper Managem...

Defination,Advantages and Limitation, Proper Management of company,

Bond Relationship, Bond Relationship A debt gadget issued through a offici...

Bond Relationship A debt gadget issued through a official or just the formal legal procedure and secured either by the pledge of detailed properties or revenues or by the general

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