Loading...
HomeMy WebLinkAboutDashboard Slide Show 6-30-2020Dashboard Review for the City of Rexburg As of June 30, 2020 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 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 Pool Certificates of Deposit Zions Bank Capital Advisors Moreton Gov't Securities TVI - 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 $24,000,000 Operations Construction Capital Trust Reserves by Type of Purpose Over Time Sep 2016 Sep 2017 Sep 2018 Sep 2019 Jun 2020 Operating Expenses & Revenues 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) Operating Expenses & Revenues 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) 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 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 Community Growth $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 Note: Commercial includes institutional (the University, schools, churches, etc.) Community Growth 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 Community Growth 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 Inflation 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) 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 $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