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

Factor reversal test, factor reversal test or circfied ular test satis reve...

factor reversal test or circfied ular test satis reversal test question #Minimum 100 words accepted#

What is appropriate and parametric statistical procedure , Questions 1....

Questions 1.  What would be the appropriate statistical procedure to test the following hypothesis:  "Triglyceride values are a good predictor of weight in obese adults." 2.

Working capital, prepare an estimate of working capital requirements from t...

prepare an estimate of working capital requirements from the following information 1. project annual sales 1,00000/- 2. selling price Rs. 8/unit 3.percentage of net profit on sale

What is Agency financial reporting system (afrs), What is Agency financial ...

What is Agency financial reporting system (afrs) The state-wide sales system managed by the Workplace of Economical Control. AFRS is the condition of Washington''s established sa

Accounting is an art of recording, Accounting is an art of recording Yes...

Accounting is an art of recording Yes, we recognize upon that declaration because if we evaluate the primary features of the accounting program we will find that primary three p

Accreted value definition, An assessment time frame for certain purchases a...

An assessment time frame for certain purchases and debt equipment that reviews on the stability piece only that part of their face value that shows major and interest acquired curr

TRENDS , Why do we particularly omit the middle year when using the semi-av...

Why do we particularly omit the middle year when using the semi-average method to fit a trend line

#title.Arithmatic mean., If the mean of first 5 no. is 60 and mean of last ...

If the mean of first 5 no. is 60 and mean of last 5 no. is 55 then what is the 5th no.

Earliest due date, Q1.(i)   A manufacturing firm has previously sequenced i...

Q1.(i)   A manufacturing firm has previously sequenced its jobs using the "Shortest Operation Time" (SOT) rule.  This has resulted in poor delivery performance with many jobs being

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