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

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

Velocity, A car moves with constant velocity along a straight road. Its pos...

A car moves with constant velocity along a straight road. Its position is x1 = 0m at t1 = 0 seconds and is x2 = 56 m at t2 = 5.0 s. what is the cars position at t=2.5 seconds and

Determine the probability - standard deviation & mean , 1. This question ha...

1. This question has multiple parts. For a distribution of scores with = 82 and standard deviation = 2.5, find the following: (Don't forget to sketch the normal curve to help

#titlelinear regression.., regression line drawn asY=C+1075x,when x was 2,a...

regression line drawn asY=C+1075x,when x was 2,and y was239,given that y intercept was11.calculate the residual.

Estimate the expected monetary value, 3DP, a Luxembourg-based company plans...

3DP, a Luxembourg-based company plans to develop and sell highly specialized 3D printers. The cost of product development is estimated at EUR 50,000.-, irrespective of whether or n

Surveys through schedules, Under this methods the enumerators are appointed...

Under this methods the enumerators are appointed and given training. They are provided with schedules containing relevant questions. These enumerators go to respondents with the

Characteristic, 1. Mention the characteristics of Statistics. Explain any t...

1. Mention the characteristics of Statistics. Explain any two applications of Statistics.

Explain public budget, Explain public budget A plan of financial process ...

Explain public budget A plan of financial process embodying an estimate of proposed expenditures and any other expenditure for a given era of time and the proposed means of finan

3-month absolute deviation, For our class homework we prepared a 3-month fo...

For our class homework we prepared a 3-month forecast for sales (12 months with actual sales for each month). What or how do we figure the absolute deviation of the 3-month foreast

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