Loading...
HomeMy WebLinkAboutDashboard Report - Jun 2020Dashboard Report - FY 2020 as of:6/30/2020 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 4,143,952 444,137 450,253 -- 2,990,016 3,645,350 3,702,450 3,761,275 5,182,398 5,358,976 - 2,528,575 3,202,267 5,104,990 5,178,831 2,131,630 1,525,075 1,367,985 841,106 1,574,730 6,419,917 4,709,400 6,891,681 7,779,742 7,362,963 1,205,295 703,101 1,505,120 20,370 3,715,927 989,035 714,791 1,685,194 1,262,746 1,691,688 $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 2016 Sep 2017 Sep 2018 Sep 2019 Jun 2020 Cash & Investments Over Time Checking, Savings Municipal MM Fund State Investment PoolCertificates of Deposit Zions Bank Capital AdvisorsMoreton Gov't Securities TVI - 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 $24,000,000 Operations Construction Capital Trust Reserves by Type of Purpose Over Time Sep 2016 Sep 2017 Sep 2018 Sep 2019 Jun 2020 $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 Q3 Streets Impact $403,158 $369,252 $895,325 $500,541 $406,281 Fire Impact $54,382 $70,443 $98,230 $70,534 $55,800 Police Impact $64,867 $82,622 $97,053 $106,151 $71,795 Parks Impact $228,428 $425,635 $493,022 $310,325 $282,440 Sewer Capacity $379,543 $623,433 $820,064 $507,861 $446,018 Water Capacity $198,757 $231,084 $364,261 $220,482 $243,187 $- $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 69% 47% 68% 74% 83% 106%61%50%60% 74%74% 38% 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* $35,266,700; Actual $21,907,169 (* $32,643,300 without Fund Balances-See Monthly Budget Report) Forecast Over Budget Remaining Budget Actual thru June 2020 (75% of the Year) 72% 71% 54% 72% 61%77%67% 76% 71% 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 Expenses To Date Total Budget* $35,965,600; Actual $21,718,727 (*$31,753,500 without Contingency-See Monthly Budget Report) Forecast Over Budget Remaining Budget Actual thru June 2020 (75% of the Year) as of: Inflation Construction Projects Community Growth Community Growth 6/30/2020 59 63 47 52 66 241 194 808 443 198 0 100 200 300 400 500 600 700 800 900 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 through Q3 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 $600 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. 8 3 % 1. 6 1 % 0. 6 5 % 1. 5 5 % 2. 4 9 % -0. 0 7 % -0. 1 6 % 1. 9 1 % 1. 6 3 % -0. 4 6 % -1. 3 5 % 2. 9 8 % 2. 7 2 % 1. 5 1 % 0. 2 8 % -2.00% -1.00% 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) $166,597 $159,698 $130,700 $132,450 $157,803 $249,512 $122,526 $554,753 $368,775 $226,697 $78,594 $112,023 $110,797 $146,657 $272,318 $80,543 $103,138 $58,950 $118,670 $78,035 $- $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 Q3 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 155,285 0 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 Q3 Permitted Commercial Square Feet January to January CPI is the proposed next fiscal year COLA