Description
All the highlighted parts need to be filled in on Module 29 worksheet. Module 28 has to be used to complete Module 29. It is complete and attached. Questions:
For SES solutions, use α = 0.1. For Holt solutions, use α = 0.95 and β = 0.01.
1. Recall the forecast produced for assignment 3 in Module 28 for the Northland special revenue fund. The original data are provided in Table 29.1. a. Using the same initial data and assumptions, refine the forecast using the exponential smoothing method appropriate for nontrending data. b. Produce a graph showing the original data, the 5-year moving average forecast from Module 28, and the forecast produced using the exponential method. c. Which forecast would you recommend using, and why? Graphs are on first page of excel and highlighted areas are on second page. The graph can be found on pg. 57:https://study.sagepub.com/sites/default/files/Modu...
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Attached. Please let me know if you have any questions or need revisions.
Revenue
140000000
120000000
100000000
80000000
60000000
40000000
20000000
0
1 2 3
90,000,000
80,000,000
70,000,000
60,000,000
Revenue
This page for graphs only. Other pages are self-checking
Put solved data for Exercise 1 Here
Total State
and Local Per
Capita Taxes
Paid
Year
ESForecast
5 yr MA
1996
53,421,417
#N/A
1997
64,600,858
53,421,417
1998
67,053,747
54539361.1
1999
24,316,124
55790799.69
2000
66,110,642
52643332.13
55,100,558
2001
93,389,137
53990063.14
63,094,102
2002
49,686,023
57929970.53
60,111,135
2003
20,706,410
57105575.73
50,841,667
2004
81,238,032
53465659.17
62,226,049
2005
49,055,130
56242896.5
58,814,947
2006 124,202,747
55524119.89
64,977,668
2007
86,126,170
62391982.58
72,265,698
2008
27,862,519
64765401....