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

What is prime cost, What is prime cost? Primary price is the combin...

What is prime cost? Primary price is the combination of a manufactured item's expenditures of immediate materials and immediate labor. In other words, prime price represent

Find the pv of the depreciation tax, PC Shopping Network may upgrade its mo...

PC Shopping Network may upgrade its modem pool. It last upgraded 2 years ago, when it spent $115 million on equipment with a life of 5 years and a salvage value of $15 million. The

Association of Attributes, In an examination 600 candidates appeared, boys ...

In an examination 600 candidates appeared, boys outnumbered girls by 16% of all candidates. number of passed candidates exceeded the number of failed candidates by 310. Boys failin

What is inference, Q. What is Inference? Ans. Inference is the pro...

Q. What is Inference? Ans. Inference is the process of deriving conclusions based on facts or premises. We often make inferences based on the results of statistical studi

Define Allocate , Define Allocate To split a lump-sum appropriation into p...

Define Allocate To split a lump-sum appropriation into parts that are specific for expenses by particular government models and/or for particular requirements, actions, or things.

Define mean, Explain what central tendency and variability are. In your ans...

Explain what central tendency and variability are. In your answer define what the mean, median, mode, variance, and standard deviation are. What is the difference between the descr

Help, How many different license plate of 5 digits can be made if the most ...

How many different license plate of 5 digits can be made if the most let digit is 4 and the second digit from left is an odd number

What is single entry system?, 1. What is Single Entry System? Ans. In...

1. What is Single Entry System? Ans. In Accounting, The program under which only one part of entrance or bookkeeping go is registered is known as single Entry System, they ar

Accrual basis in accounting , The foundation sales whereby income are ackno...

The foundation sales whereby income are acknowledged when gained and considerable regardless of when collected; and costs are noted on a corresponding basis when suffered. All amaz

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