HomeMy WebLinkAboutSupplemental - Received from Bruce Bennett During Oral Communications Observation of 5 year Forecast.
Excel screenshots from the City's Model were not appended to Council packet online. Best
efforts to make copies of the revenue/expenditure bar graph from the video (see attached).
A quick takeaway:
1) A 2% inflator for Franchise Fee revenue maybe offset by use of a 3% inflator for Refuse
Services (these categories equal a bit over a $million in the budget.). If Refuse Services costs go
up by 3%, then resident revenue payments into "Charges for Services" (which are almost $1.3
million currently and make 42% of this revenue category) should also rise by some percentage.
A 0% inflator for this revenue category.
2) There is no line item for pensions in Expenditures. Possibly it is divvied up and mixed in with
categories that include employee salaries. These categories have inflators that equal CPI, when
our pension costs are known to be rising a multiple of CPI for years.
3) The model predicts a $20,000 GF operating deficit for FY 22-23. No mention of FY 23-24. The
bar graphs on the revenue vs expenditure slide seem to indicate maybe a $ million dollar
deficit. Using the 5 year forecast should allow Council a way of using what if's to see the impact
of goal you set today.
Bruce Bennett
Ganarnl Fund Revenues mnd txpttnditurs
i
1
M
1111111111 0
: II*:
90 i
"L 3 ► 44 41 1 4 4 i 10 10 f
*kW •Wit t,po*ttmr+n
w
P N
III Ilifzif15-
1
ir I 1 I f R t' # I
( 2, 111 I ill 11 %I i
n y ; iiiii A $ iiii' ,
ii 4t 1 ijii! I41
t
t
•
•
is O r • r i rr .• • •
I .1 4C215 .
• r
3• p.. Y:_ 4. S...
- - _ ,.... _ . . . . _ . .. - f . - - . . . - . - iv ,fi, . . 4
t. ___ _�._..._..__.. , saiii 1 alias ; ; Iiiit )
t
by22 2 14 alayazas
•
-"T-7
x
•
121122222rya
2ti
I.
ilIV
Z1,1 ._
YIP M _. i M