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

Quota sampling, Quota Sampling: in stratified the cost of taking random sam...

Quota Sampling: in stratified the cost of taking random samples from individual strata is often so expensive that interviewers are simply give quota to be filled from different str

Permutation, Find the number of different ways in which the 9 letters of th...

Find the number of different ways in which the 9 letters of the word GREENGAGE can be arranged if exactly two Gs are next to each other?

Quartile deviasion, Calculate the quartile deviation??805,796,810,785,810,7...

Calculate the quartile deviation??805,796,810,785,810,790,800 and 785

Calculate the probability of bmi, A file on DocDepot in the assignments fol...

A file on DocDepot in the assignments folder on doc-depot called bmi.mtp contains data on the Body Mass Index (BMI) of a population of Ottawa residents. The first column identifies

Administering agency solutions, Administering agency solutions A professio...

Administering agency solutions A professional specific by the Office of Economical Control to provide common management of economic sales action. An administering agency is also a

Historigrams and histogram, what is the difference between histotigrams and...

what is the difference between histotigrams and histograms?

Accounting cases, Hi I just want to know if you many be able to solve thes...

Hi I just want to know if you many be able to solve these three cases for intermediate accounting class! Thank you

Calculate npv and irr of the project, PolyCorp is considering an investment...

PolyCorp is considering an investment in new plant of $3 million.  The project will be financed with a loan of $2,000,000 which will be repaid over the next five years in equal ann

Magnet, Why Magnet show north south pole

Why Magnet show north south pole

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