HomeMy WebLinkAboutDashboard Report - Dec 2019Dashboard Report - FY 2020 as of:12/31/2019
Infrastructure Fees
Cash, Investments and Reserves
Operating Expenses & Revenues
Operating Expenses & Revenues
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
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 2016 Sep 2017 Sep 2018 Sep 2019 Dec 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 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
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)
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)
as of:
Inflation
Construction Projects
Community Growth
Community Growth
12/31/2019
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
$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
$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
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)
$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
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
January to
January
CPI is the
proposed
next fiscal
year COLA