HomeMy WebLinkAboutDashboard Report - Jun 2019Dashboard Report - FY 2019 as of:6/30/2019
Infrastructure Fees
Cash, Investments and Reserves
Operating Expenses & Revenues
Operating Expenses & Revenues
-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
PoolCertificates
of Deposit
Zions Bank
Capital
AdvisorsMoreton Gov't
Securities
Federal
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
Operations Construction Capital Trust
Reserves by Type of Purpose Over Time
Sep 2015 Sep 2016 Sep 2017 Sep 2018 Jun 2019
$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 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
65%
62%
73%
73%
84%
72%59%60%70%
44%
74%
65%
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
Operating Revenues To Date
Total Budget* $35,295,900; Actual $21,322,081
(* $33,681,400 without Fund Balances-See Monthly Budget Report)
Forecast Over Budget
Remaining Budget
Actual thru June 2019 (75% of the Year)
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)
as of:
Inflation
Construction Projects
Community Growth
Community Growth
6/30/2019
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
$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
$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
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)
$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
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
January to
January
CPI is the
proposed
next fiscal
year COLA