The URL can be used to link to this page

Home My WebLink AboutFinance Dashboard Report (2)City of Rexburg Finance Dashboard Report For period ending 01/31/2018 295,795 64,416 - 307,085 307,085 307,085 6,884,741 7,041,579 7,184,135 7,556,824 7,565,725 7,495,764 - 1,105,132 964,320 444,137 450,253 452,050 5,209,156 5,339,060 5,479,813 2,131,605 1,525,050 1,452,559 533,497 2,027,432 3,888,295 6,419,917 4,709,400 7,072,887 3,645,350 3,702,450 3,696,806 2,528,575 2,519,240 3,035,492 3,796,719 3,436,365 1,205,295 703,101 1,037,429 1,446,039 772,693 596,339 989,060 714,816 914,954 $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 Sep 2013 Sep 2014 Sep 2015 Sep 2016 Sep 2017 Jan 2018 Cash & Investments Over Time Checking, Savings Municipal MM Fund Zions Bank Capital Advisors Moreton Gov't Securities State Investment Pool Certificates of Deposit Federal Agency Notes/Bonds State Diversified Bond Fund Real 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 Operations Construction Capital Trust Reserves by Type of Purpose Over Time Sep 2013 Sep 2014 Sep 2015 Sep 2016 Sep 2017 Jan 2018 32% 34% 21% 34% 36% 19% 32% 36% 32% $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 General Admin Community Dev. Recreation Police Fire Street Water Wastewater Sanitation Operating Expenses To Date Total Operating Budget $31,206,900 (See Monthly Budget Report for more detail) Over Budget Remaining Budget Actual thru Jan 2018 (33% of the Year) 59% 22% 26% 33% 37% 48% 28% 9% 61% 24% 33% 0% 12% $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 Operating Revenues To Date Total Operating Budget $31,765,400 (See Monthly Budget Report for more detail) Over Budget Remaining Budget Actual thru Jan 2018 (33% of the Year) $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 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 $489,340 $278,052 $235,365 $198,757 $231,084 $122,401 $537,856 $641,985 $531,564 $379,543 $623,433 $316,309 $514,023 $413,211 $187,051 $228,428 $425,635 $209,443 $72,194 $55,391 $120,896 $64,867 $82,622 $37,130 $55,370 $44,922 $54,438 $54,382 $70,443 $40,260 $527,009 $502,739 $670,875 $403,158 $369,252 $336,198 $- $250,000 $500,000 $750,000 $1,000,000 $1,250,000 $1,500,000 $1,750,000 $2,000,000 $2,250,000 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Public Works Capacity Fees & Impact Fees Streets Impact Fire Impact Police Impact Parks Impact Sewer Capacity Water Capacity $95,435 $107,784 $173,440 $166,597 $159,698 $32,298 $480,908 $533,225 $80,208 $249,512 $122,526 $136,170 $175,058 $271,107 $277,365 $78,594 $112,023 $17,976 $43,273 $49,025 $73,311 $80,543 $103,138 $15,784 $- $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 $700,000 $800,000 $900,000 $1,000,000 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Building Permit Fees Other (remodel, etc.) New Commercial Buildings New Multi Family Dwellings New Single Family Dwellings Community Growth 39 45 64 59 63 10 621 538 97 241 194 225 0 100 200 300 400 500 600 700 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Permitted Dwelling Units Multi Family Dwellings Single Family Dwellings 292,072 414,819 367,060 58,165 150,195 16,270 0 50,000 100,000 150,000 200,000 250,000 300,000 350,000 400,000 450,000 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Permitted Commercial Square Feet Inflation 1. 7 4 % 1. 5 3 % 2. 0 7 % 0. 5 4 % 2. 0 7 % 2. 0 7 % 2. 2 1 % 1. 6 2 % 2. 6 5 % 0. 0 0 % 2. 6 5 % 3. 3 0 % 2. 9 8 % 3. 2 5 % 0. 0 0 % 3. 2 5 % 0.00% 0.50% 1.00% 1.50% 2.00% 2.50% 3.00% 3.50% 10 Year Average 5 Year Average Last 12 Months Proposed 2019 COLA Last Month Jan 2018 Since Jan 2017 Estimated 2019 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) $0.0 $0.3 $0.5 $0.8 $1.0 $1.3 $1.5 $1.8 $2.0 $2.3 $2.5 $2.8 $3.0 Sugar City Pressure Line Riverside Field (Quad) & Lights Water Capacity Project LID 48 Construction N. 2nd E Widen,Path, Lights- 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 Water Tank Cleaning/Painting Diesel Fuel Station Millhollow Lift Station Rebuild Summerfield Lift Station Center Street Revitalization Restrooms-Evergreen Park Romance Remodel Riverside Field Lighting Recon. N 2nd E Yellstn-Stationary 5th W Widen-7th S-University Sewer Plant Upgrade LID 47 Construction Minor Construction Projects To Date (In $Thousands) Actual Paid Ordered Remaining Budget Ordered or Paid Over Budget Additional Fees Added for March 7th Public Hearing Budget Adjustments Budget Adjustments Budget Adjustments Budget Adjustments Budget Adjustments Budget Adjustments •Motion Needed From Council to Approve Budget Adjustments Review Budget Summary Report Review Budget Summary Report Review Treasurers Report •Review Treasurers Report •Audit Review 2/28/18 at noon –Tisha Flora, Brad Wolfe, Mayor Merrill –Auditors –Staff