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

Research, tools and techniques used in quantitative research

tools and techniques used in quantitative research

Eviews Task, I have one task to be done on Eviews.

I have one task to be done on Eviews.

Cost inventory, how do I find the cost of inventory?

how do I find the cost of inventory?

Calculate strengths and weaknesses , In the 2009 baseball season, the team ...

In the 2009 baseball season, the team that finished the regular season with the best record in the National League was the Los Angeles Dodgers, with a record of 95-67. (For those o

Calculate the probability of company, a)  The US Food and Drug Administrati...

a)  The US Food and Drug Administration has veto power over the choice of drug names. In 2004, it used this power regularly, rejecting 36% of the names proposed by companies for re

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

Find a p-value from a t-test, A random sample of 321 New Jersey and 77 Penn...

A random sample of 321 New Jersey and 77 Pennsylvania fast-food restaurants was selected from those fast-food restaurants in this study.  The restaurants were categorised into two

What is Accrued expenditures or expenses, Costs or expenses that connect wi...

Costs or expenses that connect with the appropriate identification requirements of the finance type engaged but have not been compensated. Acquired expenses are required to be comp

Marginal and absorption Costing Problem solving, can you provide me the pro...

can you provide me the problem with the solution base above?

Definition of Capital Market, Definition of capital market is termed as a m...

Definition of capital market is termed as a market where shares are traded after an initial issue. Capital market is the market where corporations, companies, and government debt

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