HomeMy WebLinkAboutDashboard Report - FY2021Dashboard Report - FY 2021 as of:12/31/2020
Infrastructure Fees
Cash, Investments and Reserves
Operating Expenses & Revenues
Operating Expenses & Revenues
307,085 307,085 307,085 326,663 326,663
7,565,725 7,526,746 7,975,262
4,156,330 4,155,373
450,253 --
3,652,337 3,653,185
3,702,450 3,761,275 5,182,398 5,371,838 5,380,937
2,528,575 3,202,267
5,104,990 5,191,679 5,201,372 1,525,075 1,367,985
841,106 1,584,339 1,584,340
4,709,400
6,891,681
7,779,742
8,166,635 6,370,186
703,101
1,505,120
20,370
755,721 2,755,728
714,791
1,685,194
1,262,746
1,490,148 1,495,386
$0
$2,500,000
$5,000,000
$7,500,000
$10,000,000
$12,500,000
$15,000,000
$17,500,000
$20,000,000
$22,500,000
$25,000,000
$27,500,000
$30,000,000
$32,500,000
$35,000,000
Sep 2017 Sep 2018 Sep 2019 Sep 2020 Dec 2020
Cash & Investments Over Time Checking,
Savings
Municipal MM
Fund
State
Investment
PoolCertificates of
Deposit
Zions Bank
Capital
AdvisorsMoreton Gov't
Securities
TVI - Agency
Notes &
BondsState
Diversified
Bond FundReal Estate
$0
$2,000,000
$4,000,000
$6,000,000
$8,000,000
$10,000,000
$12,000,000
$14,000,000
$16,000,000
$18,000,000
$20,000,000
$22,000,000
$24,000,000
Operations Construction Capital Trust
Reserves by Type of Purpose Over Time
Sep 2016 Sep 2017 Sep 2018 Sep 2019 Sep 2020 Dec 2020
$0
$2,500,000
$5,000,000
$7,500,000
$10,000,000
$12,500,000
$15,000,000
$17,500,000
$20,000,000
$22,500,000
$25,000,000
$27,500,000
$30,000,000
$32,500,000
$35,000,000
$37,500,000
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
Total Operating Budget, Revenue and Expenses
To Date
Budget Expense
Actual Revenue
Actual Expenses
FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021
Streets Impact $403,158 $369,252 $895,325 $500,541 $440,008 $14,925
Fire Impact $54,382 $70,443 $98,230 $70,534 $63,949 $4,012
Police Impact $64,867 $82,622 $97,053 $106,151 $84,792 $7,485
Parks Impact $228,428 $425,635 $493,022 $310,325 $352,193 $25,545
Sewer Capacity $379,543 $623,433 $820,064 $507,861 $535,736 $36,604
Water Capacity $198,757 $231,084 $364,261 $220,482 $328,187 $35,390
$-
$250,000
$500,000
$750,000
$1,000,000
$1,250,000
$1,500,000
$1,750,000
$2,000,000
$2,250,000
$2,500,000
$2,750,000
$3,000,000
Public Works Capacity Fees & Impact Fees
5%
22%
25%
26%26%9%9%4%15%
25%27%
0%
$0
$500,000
$1,000,000
$1,500,000
$2,000,000
$2,500,000
$3,000,000
$3,500,000
$4,000,000
$4,500,000
$5,000,000
$5,500,000
$6,000,000
$6,500,000
$7,000,000
Operating Revenues To Date
Total Budget* $32,482,500; Actual $6,862,769
(*without Fund Balances or Transfers-See Monthly Budget Report)
Forecast Over Budget
Remaining Budget
Actual thru Dec 2020 (25% of the Year)
24%28%28%27%31%
17%23%24%25%$0
$500,000
$1,000,000
$1,500,000
$2,000,000
$2,500,000
$3,000,000
$3,500,000
$4,000,000
$4,500,000
$5,000,000
$5,500,000
$6,000,000
$6,500,000
$7,000,000
Operating Expenses To Date
Total Budget* $31,862,800; Actual $8,127,876
(*without Contingency or Transfers-See Monthly Budget Report)
Forecast Over Budget
Remaining Budget
Actual thru Dec 2020 (25% of the Year)
as of:
Inflation
Construction Projects
Community Growth
Community Growth
12/31/2020
59 63 47 52 112
20
241 194
808
443
246
280
100
200
300
400
500
600
700
800
900
FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021
Permitted Dwelling Units
Multi Family Dwellings
Single Family Dwellings
$0.0 $0.5 $1.0 $1.5 $2.0 $2.5 $3.0 $3.5 $4.0 $4.5
Moody Line & Lift Station
Water Capacity Projects
7Th S Rr Crossing Upgrade URA
2 E&Hwy33 Realignment-City-Dif
Major Construction Projects
To Date (In $Millions)
Actual Paid
Ordered
Remaining Budget
Ordered or Paid Over Budget
Projects of $1,000,000 or more
$0 $200 $400 $600 $800 $1,000
Romance Building Remodel
Seal Coat/Chip Or Slurry Seal
Traf Sig Upgrade-7th S/Yel-URA
Airport Environmental Assessment
Airport Feasability Study
LED Upgrades-City Wide
N. 2nd E/Moody -URA
Blower Replacement (3)-Vfd
Baseball/Softball Quad
Construction Costs LID 49
Building Purchase/Storage Building
Water Line Extension Projects
Water Line Replacement Project
Sewer Line Camera/Vehicle
Path Past Jr. High - Grant
Restroom/Shelter at Riverside Park
Replace Nature Park Playground
E. Parkway - 7 N. Barney Street Construction
New Road 2 W. Sunrise
Construction Costs LID 50
Tyler Munis ERP City Software
Minor Construction Projects
To Date (In $Thousands)
Actual Paid
Ordered
Remaining
Budget
Ordered or Paid
Over Budget
Projects of more than $100,000 that are not Major Projects
1.
8
8
%
2.
0
3
%
1.
3
6
%
1.
5
5
%
2.
4
9
%
0.
9
7
%
1.
0
6
%
2.
0
3
%
2.
2
5
%
1.
1
6
%
1.
0
3
%
2.
9
2
%
2.
9
6
%
2.
1
3
%
1.
9
9
%
0.00%
1.00%
2.00%
3.00%
4.00%
5.00%
6.00%
10 Year
Average
5 Year
Average
Last 12
Months
Oct 2019
COLA
Oct 2020
COLA
Since Jan
2020
Estimated
2021 COLA
Consumer Price (CPI), Municipal Cost (MCI) &
Construction Cost (CCI) Indexes
CPI (US Dept of Labor)
MCI (American City & County Magazine)
CCI (American City & County Magazine)
$166,597 $159,698 $130,700 $132,450
$271,416
$64,223
$249,512
$122,526
$554,753
$368,775
$278,931
$31,569
$78,594
$112,023
$110,797
$146,657
$318,229
$31,979
$80,543
$103,138
$58,950
$118,670
$83,976
$5,789
$-
$100,000
$200,000
$300,000
$400,000
$500,000
$600,000
$700,000
$800,000
$900,000
$1,000,000
FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021
Building Permit Fees
Other (remodel, etc.)
New Commercial
Buildings
New Multi Family
Dwellings
New Single Family
Dwellings
58,165
150,195
56,060
184,336
157,085
5,2490
20,000
40,000
60,000
80,000
100,000
120,000
140,000
160,000
180,000
200,000
FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021
Permitted Commercial Square Feet
January to
January
CPI is the
proposed
next fiscal
year COLA