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

Definition of bonded warehouse, Bonded warehouse is a storage area under Cu...

Bonded warehouse is a storage area under Customs authority that is imported dutiable goods on which duty is unpaid and these are stored. Once the duty & other charges are paid the

Identify interaction between estimators and jobs, Q1.(i) The logistics depa...

Q1.(i) The logistics department of a large firm employs three "estimators" whose job it is to decide the likely cost of delivering their products to their customers.  This enables

Introduction of management accounting, Introduction of Management Accountin...

Introduction of Management Accounting Management accounting or managing sales is worried with the conditions and use of sales details to professionals within companies, to off

Oecd database exercise , For this second assignment you will have to use th...

For this second assignment you will have to use the OECD database to investigate possible changes in the policy preferences of Western welfare states. You have to develop (i) an in

Estimate the variables-statistically significant, The dataset also contains...

The dataset also contains a variable y , which is the dependent variable of interest, as well as x1 , x2 , x3 , x4 , x5 , and x6 , all explanatory variables that are potentially

Sampling Error, Use the concepts of sampling error and z scores to explain ...

Use the concepts of sampling error and z scores to explain the concept of distribution of sample means.

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

Actual velocity, A boat is heading across a river at a velocity of 25 mph. ...

A boat is heading across a river at a velocity of 25 mph. The river is flowing downstream at 10 mph. What is the actual velocity of the boat?

Long term credit decision, Long Term Credit Decision In no more than o...

Long Term Credit Decision In no more than one typed page, provide a statement of your decision to lend or not lend to this company based on your interpretation of the company'

What is Nuclear holocaust, Nuclear holocaust It is the name given to large...

Nuclear holocaust It is the name given to large scale destruction and devastation that would be caused by the use of nuclear weapon. The radioactive waste will hang like a cloud i

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