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

Assignment, Discuss about the scalling techniques

Discuss about the scalling techniques

Shamim, the monthly income( in tk''s)persons workingin afarmis as flows ,14...

the monthly income( in tk''s)persons workingin afarmis as flows ,14870,14930,15020,14460,14750,14920,15720,15160,14680,14890 find average monthly income?

Probability, The monthly income of a company employee is normally distribut...

The monthly income of a company employee is normally distributed with the mean Rs. 20,000 and standard deviation of Rs. 5000. a) Find the probability that an employee earns more th

Hypothesis the basic short-run and long-run, In reguards to the airlines in...

In reguards to the airlines indusry, provide a minimum of 300 words for each statement. plus atleast 3 academic resources. 1. hypothesis the basic short-run and long-run behavio

Kurtosis, define kurtosis with relevant examples

define kurtosis with relevant examples

Find karl pearson''s correlation coefficient, Find Karl Pearson's correlati...

Find Karl Pearson's correlation coefficient between the sales and expenses from the data given below:

Accounting for partnerships and limited liability companies, Tim Snyder and...

Tim Snyder and Jay Wise have decided to form a partnership. They have agreed that Snyder is to invest 30000 and Wise is to invest 40000. Snyder is to devote full time to the busi

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