You have 2 main things to do:
1) Check the budget amounts actually adopted for 2018—by spending category and for the total budget (see row 42)—based on the low (in C34-C42) and high (in D34-D42) projections. Use % differences in E34-E42 (2018 budget – low projection)/low projection and F34-F42 (2018 budget – high projection)/ high projection.
2) Assess whether trending assumptions were correct—remember we expected the compensation categories to trend (check out B17 through D17 and B18 through D18 to see if those year-over-year % changes seem to be following a consistent trend) and the non-compensation categories not to trend.
Latest recorded lecture (last 40 minutes deal with Forecasting assignment):