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

Topic 4 Anova excel worksheet, systolic blood pressure in different age gr...

systolic blood pressure in different age groups. the following table contains a random sample of 40 women partitioned into three groups...

Commission, if someone sold a house and received a $10,000 commission, how ...

if someone sold a house and received a $10,000 commission, how would i write that into a journal

Simulate a worm propagation considering no delay, You are required to simul...

You are required to simulate simple worm propagation in a medium-scale network by using discrete-time simulation technique. Assume that in an isolated network with IP address

Business tax accounting , 1. Passive losses are fully deductible as long as...

1. Passive losses are fully deductible as long as they do not exceed $50,000 during the year. A) True B) False 2. Wages are considered "active income." A) True B) False 3. A de

Factorial anova , Assessment Two tests your ability to conduct a factorial ...

Assessment Two tests your ability to conduct a factorial ANOVA and make appropriate decisions regarding any follow up comparisons. The following data set is adapted from Jaccard an

Difference in the loss in man-hours - accidents in firms, An occupational h...

An occupational health inspector was interested in determining whether there is a difference in the loss in man-hours due to accidents  by introducing a new safety programme.  The

Define Annuity , Annuity A sequence of equivalent money payments made or o...

Annuity A sequence of equivalent money payments made or obtained at equivalent durations over a specific time period.

Cash accounting, Accounting system is one prevalent among agencies in volun...

Accounting system is one prevalent among agencies in voluntary sector. Transactions are registered in journals only when cash is in fact paid out or taken in. The primary virtue of

Allowable moving costs , Allowable moving costs Except as mentioned in Sub...

Allowable moving costs Except as mentioned in Subsection 60.20.20 and within certain restrictions, allowable moving costs involve the prices associated with moving family products

Normal distribution, Lifts usually have signs indicating their maximum capa...

Lifts usually have signs indicating their maximum capacity. Consider a sign in a lift that reads “maximum capacity 1400kg or 20 persons”. Suppose that the weights of lift-users are

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