HomeMy WebLinkAboutDashboard Slide Show 12-31-2019Dashboard Review for the
City of Rexburg
As of Dec 31, 2019
Cash, Investments and Reserves
307,085 307,085 307,085 307,085 324,863
7,556,824 7,565,725 7,526,746 7,975,262
3,997,850
444,137 450,253 --
-
3,702,450 3,761,275
5,182,398
5,213,315
3,202,267
5,104,990
5,134,795
1,931,605
1,525,050
1,253,060
841,081
841,081
6,419,482
4,709,400
6,891,681
7,779,742
7,502,922
1,205,295
703,101
1,505,120
20,370
215,761
989,060
714,816
1,373,002
988,760
$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
Sep 2016 Sep 2017 Sep 2018 Sep 2019 Dec 2019
Cash & Investments Over Time
Checking, Savings
Municipal MM Fund
State Investment
Pool
Certificates of
Deposit
Zions Bank Capital
Advisors
Moreton Gov't
Securities
Federal 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
Operations Construction Capital Trust
Reserves by Type of Purpose Over Time
Sep 2016 Sep 2017 Sep 2018 Sep 2019 Dec 2019
Operating Expenses & Revenues
25%
25%
25%
24%21%33%22%
26%
25%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
Operating Expenses To Date
Total Budget* $35,460,500; Actual $7,702,161
(*$31,057,000 without Contingency-See Monthly Budget Report)
Forecast Over Budget
Remaining Budget
Actual thru Dec 2019 (25% of the Year)
Operating Expenses & Revenues
6%0%20%
18%
28%25%9%7%6%13%
25%0%11%
$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
Operating Revenues To Date
Total Budget* $36,819,900; Actual $4,856,035
(* $34,656,900 without Fund Balances-See Monthly Budget Report)
Forecast Over Budget
Remaining Budget
Actual thru Dec 2019 (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 through Q1
Streets Impact $403,158 $369,252 $895,325 $500,541 $45,788
Fire Impact $54,382 $70,443 $98,230 $70,534 $6,761
Police Impact $64,867 $82,622 $97,053 $106,151 $7,647
Parks Impact $228,428 $425,635 $493,022 $310,325 $28,200
Sewer Capacity $379,543 $623,433 $820,064 $507,861 $43,625
Water Capacity $198,757 $231,084 $364,261 $220,482 $25,490
$-
$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
$166,597 $159,698 $130,700 $132,450
$31,966
$249,512
$122,526
$554,753
$368,775
$63,131
$78,594
$112,023
$110,797
$146,657
$65,916
$80,543
$103,138
$58,950
$118,670
$3,753
$-
$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 through Q1
Building Permit Fees
Other (remodel, etc.)
New Commercial Buildings
New Multi Family Dwellings
New Single Family Dwellings
Community Growth
59 63 47 52 11
241 194
808
443
360
100
200
300
400
500
600
700
800
900
FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 through Q1
Permitted Dwelling Units
Multi Family Dwellings
Single Family Dwellings
Community Growth
58,165
150,195
56,060
184,336
8,8770
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 through Q1
Permitted Commercial Square Feet
Inflation
1.
9
0
%
1.
8
9
%
2.
2
9
%
2.
0
7
%
1.
5
5
%
2.
0
9
%
2.
2
8
%
2.
3
2
%
1.
7
4
%
1.
0
4
%
1.
3
8
%
3.
1
7
%
2.
8
1
%
1.
5
9
%
1.
4
5
%
0.00%
1.00%
2.00%
3.00%
4.00%
5.00%
6.00%
10 Year
Average
5 Year Average Last 12 Months Oct 2018
COLA
Oct 2019 COLA Since Jan 2019 Estimated 2020
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
N. 2Nd E/Moody -URA
Blower Replacement (3)-
Vfd
Baseball/Softball Quad
Construction Costs Lid 49
Major Construction Projects
To Date (In $Millions)
Actual Paid
Ordered
Remaining Budget
Ordered or Paid Over Budget
Construction Projects
$0 $100 $200 $300 $400 $500
CHP System- Rexburg Rapids
WW Plant Sewer Facilities Study
WW Millhollow Lift Stn Rebuild
Land Acquisition-Future Parks
Teton River Path
Romance Building Remodel
Seal Coat/Chip Or Slurry Seal
Street Row East Parkway-Dif
Traf Sig Upgrade-7th S/Yel-URA
Roundabout--Pioneer/7th S URA
2 E & Hwy 33 Realignment-URA
Airport Environmental Assessment
Airport Feasability Study
WW Plant Upgrade(Split W/Maint)
LID 48
LED Upgrades-City Wide
Minor Construction Projects
To Date (In $Thousands)
Actual Paid
Ordered
Remaining Budget
Ordered or Paid Over Budget