There was a  "step by step assist" for this question in the resources and it not  super unhelpful.

 For all the yellow, it is a fixed sheet and we can not use data analytics, so it must be solved with an equation. For ES Forecast (Column C), I have tried several formulas and none of them are proving correct in the self check box. I know that the first box in the ESForecast is the revenue from the year before.. but after that nothing I input is correct. 

 

Excel File Edit View Insert Format Tools Data Window Help Modules 27-30, Budget Tools-4 (1).pdf Page 57 of 96 - Edited Search Rank Page Order Assignments Exponential smoothing is a technique applied to time series data to produce forecasts. There is a different version of exponential smoothing for trending data. Trending exponential smoothing is known as Holt exponential smoothing. TABLE 29.1 Northland: Special Revenue Fund For SES solutions, use a = 0.1. For Holt solutions, use a = 0.95 and = 0.01. 1. Recall the forecast produced for assignment 3 in Module 28 for the Northland special reve- nue fund. The original data are provided in Table 29.1. 1996 1997 1998 1999 2000 2001 2002 2003 2004 a. Using the same initial data and assumptions, refine the forecast using the exponential smoothing method appropriate for nontrending data. i b. Produce a graph showing the original data, the 5-year moving average forecast from Mod- ule 28, and the forecast produced using the exponential method. c. Which forecast would you recommend using, and why? 53,421,417 64,600,858 BUDGET TOOLS 67,053,747 24,316,124 66,110,642 93,389,137 49,686,023 20,706,410 81,238,032 DO V SES 2005 2006 2007 2008 2009 2010 2011 2012 2013 Found on 25 pages 4 C O A 2. Recall the forecast produced in assignment 5 in Module 28 for River County's property tax revenue. The original data are provided in Table 29.2. 49,055,130 124,202,747 a. Using the same initial data and assumptions, refine the forecast using the exponential smoothing method appropriate for trending data. 141 86,126,170 27,862,519 85,704,726 81,483,730 45,459,605 22,672,732 58,226,034 b. Create a matrix showing the ME and RMSE for the three scenarios of moving-average fore- casts from Module 28 and the ME and RMSE produced using the exponential method. c. Which forecast would you recommend using, and why? APR 1 57 < > X Jul 28, 2022 - To snap a screenshot of specific Mac windows, press an S Done Home C8 From From New Database HTML Text Query X fx 23 67 3 Special Revenue 4 5 8 9 10 11 12 3 45 A B 1 To show the cell checking, put a check here: 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 Year AutoSave OFF Insert Draw 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 Ready S Page Layout Refresh All Put graphs here 53,421,417 64,600,858 67,053,747 24,316,124 66,110,642 93,389,137 49,686,023 20,706,410 81,238,032 49,055,130 124,202,747 86,126,170 27,862,519 85,704,726 81,483,730 45,459,605 22,672,732 58,226,034 =80 V 8: tv Revenue ESForecast C a Connections Properties Edit Links 1 53,421,417 TRUE Formulas Put text answer here Exercise 29.1 Error D X Data Review View Stocks Geography Error SQ D E Check AL 2Y & Clear E Sort Filter Reapply Advanced Z F Assignment 4 - NP-Week 2 - BT 2e Module 29 Exercise W G Mean RMSE 5 yr MA & Error H X Text to Flash Remove Columns Fill Duplicates Validation Error SQ A E I Data Consolidate J K All Coman What-If Analysis L Grade Graph 1 Grade Graph 2 Judicial Watch Wright * Group W V @ 2 Ungroup Subtotal M Percent Correct Google N Grade Text Answer Sat Apr 1 7:39 PM Search Sheet Show Detail Hide Detail O Share ? Data Solver Analysis P Comm 1% + 12