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

Resolance tube , #questionw..what is ment by resolance tube

#questionw..what is ment by resolance tube

Assignment, How to order an assignment?

How to order an assignment?

Explanation of the statistical analyses, Introduction Background inform...

Introduction Background information so the reader can better grasp the analyses you are going to present. This can include anything that puts the analyses into perspective for

STATISTICS FOR MANAGEMENT, 1. Mention the characteristics of Statistics. Ex...

1. Mention the characteristics of Statistics. Explain any two applications of Statistics. 2. Distinguish between primary and secondary data. What are the methods of collecting prim

Allocation surrounding to accounts, Allocation surrounding to accounts An a...

Allocation surrounding to accounts An aspect of a lump-sum appropriation that is specific for expenses by particular government models and/or for particular requirements, actions,

Adaptations, what are flatworms adaptations

what are flatworms adaptations

Probability, A machine that cuts corks for wine bottles operates in such a ...

A machine that cuts corks for wine bottles operates in such a way that the distribution of the diameter of the corks produced is well approximated by a normal distribution with mea

Cost management, if sales is 6800 and variable costs are 2856 what is the v...

if sales is 6800 and variable costs are 2856 what is the variable cost percentage?

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?

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