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

Explain the effects of the transactions, Explain the effects of the transac...

Explain the effects of the transactions on Accounting Equation under a Financial Accounting System. Ans. Under the Double Entry System each of the financial transaction bring the

10-k report information, Where are Cash Equivalents and Marketable Securiti...

Where are Cash Equivalents and Marketable Securities noted on a 10-K report? What needs to be included as a minimum disclosure?

Calculate the standard error and confidence interval, 1. You have a regiona...

1. You have a regional country-year dataset over 10 years of 150 total observations, within this data you have 25 observations where the ruling party has lost power. (a) Assumin

Hypothesis and spss, The purpose of this activity is to help you learn how ...

The purpose of this activity is to help you learn how to enter data into SPSS by yourself.  You will use SPSS via Acadlabs.  You will discuss this activity in your group and will t

Describe the location of firms and equilibrium , Take the Hotelling's locat...

Take the Hotelling's location model (the linear city) discussed in class for the case in which all firms are required to charge the same fixed price. Further assume that firms choo

Tools., what do you mean by correct and remedy the equipment trouble as ins...

what do you mean by correct and remedy the equipment trouble as instructed by the expert.

Distinction between management and financial accounting, Distinction betwee...

Distinction between Management and Financial Accounting The variations between control sales and financial sales include Control sales provides details to individuals within a

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