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

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

Need homework answers by midnight tonight, first question: Glaser Services ...

first question: Glaser Services acquired 30% of the outstanding common stock of Nickels Company on January 1, 2008, by paying $864,180 for the 48,010 shares. Nickels declared and p

National demand, The national demand and price for a certain type of energy...

The national demand and price for a certain type of energy-efficient exhaust fan are related by p=441-3/7q, where p is the price and q the demand. The price and supply of the exhau

Writing Appropriate Null and Alternative Hypotheses, For this assignment, y...

For this assignment, you will practice creating null and alternative hypotheses of difference based on the presented scenarios. To complete this assignment, consider the three scen

Compute the test statistic, Choose a variable and collect data consisting o...

Choose a variable and collect data consisting of at least 30 values. Before collecting the data, decide what a likely average might be, then complete the following: a. Write a b

Managerial, Manchester Custom Fabricating Company uses a job order system. ...

Manchester Custom Fabricating Company uses a job order system. At the beginning of May, Manchester had two jobs in process, Job #22 (DM = $600 and DL = $780), and Job #23 (DM = $75

Modules of probability and statistics, Question: (a) Suppose that 100 t...

Question: (a) Suppose that 100 tires made by Bridgestone last on average 21,819 miles with a standard deviation of 1,295 miles. Test the null hypothesis µ = 22, 000 miles again

What is managerial accounting system, Define the Management or Managerial A...

Define the Management or Managerial Accounting System. Ans.  As the name suggest management or managerial accounting system refers to the Management of the firm or company,

Probability, A manufacturer of VCRs plans to purchase a particular componen...

A manufacturer of VCRs plans to purchase a particular component from suppliers A, B and C. 30% of the components are to be purchased from A, 20% from B and 50% from C. In the past,

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