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

Midterm & final exams , Can you all help with midterms and final exams? mea...

Can you all help with midterms and final exams? meaning getting the assignment done within a couple hours?

Book-keeping financial, Expertsmind.com offering financial accounting help...

Expertsmind.com offering financial accounting help,The Financial Accounting vs. The Book-keeping issues itself with the producing (correctly and in a set of books) of those dealin

QUANTITATIVE METHODS., A LARGE SHIPPPING COMPANY RECORDED THE NUMBERS OF TO...

A LARGE SHIPPPING COMPANY RECORDED THE NUMBERS OF TONS SHIPPED WEEKLY ACROSS THE PACIFIC FOR 50 WEEKS. ARRANGE DATA IN A LESS THAN CUMULATIVE DISTRIBUTION USING SEVEN CLASSES OF E

Calculate operational variances -planning variances, You have recently join...

You have recently joined XYZ, an international company that produces a wide range of office supplies and stationary goods. In your new role as Group Management Accountant your firs

Applying missing data, For this assignment, you will have to review each co...

For this assignment, you will have to review each column and make a decision for how to adjust for the missing data. After you correct for missing data in each column, please des

Federal income tax, Federal income tax Another part of paycheck account...

Federal income tax Another part of paycheck accounting involves the staff's got earnings tax. A company is necessary to hold the got earnings tax that and personnel are expecte

Average, characteristics of a Good Average

characteristics of a Good Average

Perform the analysis, Your earlier comparison of three energy technologies ...

Your earlier comparison of three energy technologies showed only a borderline effect using the non-parametric Kruskal-Wallis statistic. This result left you hanging on a decision o

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