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

Two hanging masses, Two blocks with masses and hang one under the other. ...

Two blocks with masses and hang one under the other. For this problem, take the positive direction to be upward, and use for the magnitude of the acceleration due to gravity. Fi

Employer''s fica tax rate for 2012, Employer's FICA tax rate for 2012 Th...

Employer's FICA tax rate for 2012 The employer's FICA tax amount for 2012 involves 1) the Public Protection tax amount of 6.2% of each individual's first $110,100 of income, inc

Anova 1 and 2 way, ANOVA 1 and 2 way, t and f-tests 1,2 or more means... st...

ANOVA 1 and 2 way, t and f-tests 1,2 or more means... standard deviations known/unknown. I have a project where I must use these tests, but I''m not clear on the when and how.

Index number, How to solve problems of index number fixed based method

How to solve problems of index number fixed based method

Earliest due date, Q1.(i)   A manufacturing firm has previously sequenced i...

Q1.(i)   A manufacturing firm has previously sequenced its jobs using the "Shortest Operation Time" (SOT) rule.  This has resulted in poor delivery performance with many jobs being

The smallest total monthly cost , Each month, the firm Cashco has 50% chanc...

Each month, the firm Cashco has 50% chance that an amount of $ 1,000 will be credited In its current account, and a 50% chance that the account is debited $ 1,000. As current accou

Estimate the proportion of lake trout with lamprey scars, In a certain lake...

In a certain lake a limnologist wishes to estimate the proportion of lake trout with lamprey scars. (a) How large of a random sample should be taken if the limnologist has no pr

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