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

LINEAR REGRESSION, Y=C+1075x,when x was 2, and y was 239, given that y inte...

Y=C+1075x,when x was 2, and y was 239, given that y intercept was 11. calculate the residual.

Assignment , assume that your group is incorporating a business organizatio...

assume that your group is incorporating a business organization. you are required to present a detailed structure, business environment and organizational structure of the entity.

Current development project and presentation , review the financial disclos...

review the financial disclosures for two publicly traded companies. Identify recently promulgated (or proposed) accounting pronouncements that have an impact on the companies. In a

Measure of dispersion, What are the uses of measures of dispersion in the f...

What are the uses of measures of dispersion in the field of civil engineering?

Accounting standards in word countries, Accounting Standards in word countr...

Accounting Standards in word countries: Diverse countries like Peru, Australia, Kuwait, South Africa etc. have all started adopting the IFRS. The SEC has suggested that all compan

Time series analysis, what is the interpretation of plots in least square m...

what is the interpretation of plots in least square method

Co-planer forces, the resultant of two perpandicular forces of magnitude p ...

the resultant of two perpandicular forces of magnitude p each will be

Calculate the probability of monthly return income, 1. It is often a good i...

1. It is often a good idea to start by visualizing the data. Time series data should have "time" on the horizontal axis. What are you going to have on the vertical axis? If you use

Job cost sheet, Manchester Custom Fabricating Company uses a job order syst...

Manchester Custom Fabricating Company uses a job order system. At the beginning of May, Manchester had two jobs in process, Job #22 (DM = $600 and DL = $780), and Job #23 (DM = $75

Anova, How to interpret Anova

How to interpret Anova

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