HomeMy WebLinkAboutDashboard Slide Show 06-30-2019 (2)Dashboard Review for the
City of Rexburg
As of June 30, 2019
Cash, Investments and Reserves
-307,085 307,085 307,085 307,085
7,184,135 7,556,824 7,565,725 7,526,746 7,870,493
964,320 444,137 450,253 --
3,645,350 3,702,450 3,761,275
5,108,964
2,528,575 3,202,267
5,074,566
5,479,813
2,131,605
1,525,050 1,367,960
841,081
3,888,295
6,419,917
4,709,400
6,891,681
4,623,870
3,436,365
1,205,295 703,101
1,505,120
1,500,240
596,339
989,060 714,816
1,685,219
3,083,888
$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 2015 Sep 2016 Sep 2017 Sep 2018 Jun 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 2015 Sep 2016 Sep 2017 Sep 2018 Jun 2019
Operating Expenses & Revenues
69%
73%
61%
73%
70%66%
66%
74%
77%
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* $34,627,800; Actual $22,409,952
(*$32,151,400 without Contingency-See Monthly Budget Report)
Forecast Over Budget
Remaining Budget
Actual thru June 2019 (75% of the Year)
Operating Expenses & Revenues
69%
73%
61%
73%
70%66%
66%
74%
77%
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* $34,627,800; Actual $22,409,952
(*$32,151,400 without Contingency-See Monthly Budget Report)
Forecast Over Budget
Remaining Budget
Actual thru June 2019 (75% 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 2015 FY 2016 FY 2017 FY 2018 Jun 2019
Streets Impact $670,875 $403,158 $369,252 $895,325 $438,034
Fire Impact $54,438 $54,382 $70,443 $98,230 $57,392
Police Impact $120,896 $64,867 $82,622 $97,053 $77,676
Parks Impact $187,051 $228,428 $425,635 $493,022 $279,580
Sewer Capacity $531,564 $379,543 $623,433 $820,064 $457,207
Water Capacity $235,365 $198,757 $231,084 $364,261 $188,146
$-
$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
Ax
i
s
T
i
t
l
e
Public Works Capacity Fees & Impact Fees
Community Growth
$173,440 $166,597 $159,698 $130,700
$73,722
$80,208
$249,512
$122,526
$554,753
$278,468
$277,365
$78,594
$112,023
$110,797
$82,133
$73,311
$80,543
$103,138
$58,950
$116,264
$-
$100,000
$200,000
$300,000
$400,000
$500,000
$600,000
$700,000
$800,000
$900,000
$1,000,000
FY 2015 FY 2016 FY 2017 FY 2018 Jun 2019
Building Permit Fees
Other (remodel, etc.)
New Commercial Buildings
New Multi Family Dwellings
New Single Family Dwellings
Community Growth
64 59 63 47 27
97
241 194
808
319
0
100
200
300
400
500
600
700
800
900
FY 2015 FY 2016 FY 2017 FY 2018 Jun 2019
Permitted Dwelling Units
Multi Family Dwellings
Single Family Dwellings
Community Growth
367,060
58,165
150,195
56,060 55,056
0
50,000
100,000
150,000
200,000
250,000
300,000
350,000
400,000
FY 2015 FY 2016 FY 2017 FY 2018 Jun 2019
Permitted Commercial Square Feet
Inflation
1.
8
8
%
1.
4
9
%
1.
6
5
%
2.
0
7
%
1.
5
5
%
0.
0
2
%
1.
7
6
%
4.
2
2
%
2.
4
2
%
1.
5
7
%
0.
9
6
%
0.
0
1
%
0.
7
3
%
3.
0
5
%
2.
9
3
%
1.
8
3
%
0.
2
8
%
0.
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 Last Month Feb
2019
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.3 $0.5 $0.8 $1.0 $1.3 $1.5 $1.8 $2.0
Moody Line & Lift Station
Water Capacity Projects
Recon. N 2nd E Yellstn-
Stationary
LID 48 Construction
N. 2nd E/Moody -URA
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 $600 $700 $800 $900
Diesel Fuel Station
Blower Replacement
SCADA System Lift Stations
Millhollow Lift Station Rebuild
Sewer Study-Collections
Upsize Sewer Line 3rd W 1st S-2nd S
Nature Park Restroom
Land Acquisition-Future Parks
Romance Remodel
Seal Coat/Chip Seal/Slurry Coat
7th S CRABS-LHTAC Grant
ROW East Parkway -DIF
Univ/Yellowstone Signal Upgrade -URA
Roundabout -Pioneer/7th S-URA
Airport Feasability Study-FAA
Sewer Plant Upgrade
Minor Construction Projects
To Date (In $Thousands)
Actual Paid
Ordered
Remaining Budget
Ordered or Paid Over Budget