HomeMy WebLinkAboutDashboard Slide Show 12-31-2020Dashboard Review for the
City of Rexburg
As of Dec. 31, 2020
Cash, Investments and Reserves
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
Pool
Certificates of
Deposit
Zions Bank
Capital Advisors
Moreton Gov't
Securities
TVI - Agency
Notes & Bonds
State Diversified
Bond Fund
Real Estate
Cash, Investments and Reserves
$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
Operating Expenses & Revenues
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)
Operating Expenses & Revenues
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)
Operating Expenses & Revenues
$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
Infrastructure Fees
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
Community Growth
Note: Commercial includes institutional (the University, schools, churches, etc.)
$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
Community Growth
59 63 47 52
112
20
241 194
808
443
246
28
0
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
Community Growth
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
Inflation
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)
Construction Projects
$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
Construction Projects
$0 $100 $200 $300 $400 $500 $600 $700 $800 $900 $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