Calculate a forecast using exponential smoothing, Basic Statistics

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.

Posted Date: 2/28/2013 1:20:56 AM | Location : United States







Related Discussions:- Calculate a forecast using exponential smoothing, Assignment Help, Ask Question on Calculate a forecast using exponential smoothing, Get Answer, Expert's Help, Calculate a forecast using exponential smoothing Discussions

Write discussion on Calculate a forecast using exponential smoothing
Your posts are moderated
Related Questions
define kurtosis with relevant examples

Study A                              Study B r = .64                          r = .77 df = 18                         df = 121 p 1. In using the data from study A to m

CBT has agreed to finance the needs of a stereo wholesaler for the next month. To complete the loan agreement, the wholesaler must estimate the cash on hand during the first 90 day

Batch costing and method of costing whereby identical units produced are treated as a single unit & the cost incurred is shown to the whole of that batch instead of each individual

Differentiate between Historigrams and Histogram

Your friend Jose is trying to decide whether to buy or lease his next vehicle. He has gathered information about each option but is not sure how to compare the alternatives. Purcha

which method is better for new product to gather the information they need,primary data or secondary data?

AA major razor blade manufacturer advertises that its twin-blade disposable razor “gets you lots more shaves” than any single-blade disposable razor on the market. A rival company

what are the disadvantages of quantatity tecqines..

Consider the sample data for plants A, B, C & D of the above company, which are tabulated in table 1. Test whether the four means are equal at the 5% level of significance. Perform