HomeMy WebLinkAboutBudget Summary ReportCITY OF REXBURG BUDGET SUMMARY REPORT
FY 2019 5 months ending
2/28/2019 Page 1
EXPENDITURES BUDGET ACTUAL 42%FORECAST
OPERATING EXPENDITURES
Misc. Departments/Categories
Arts 524,400 137,305 26%626,200
Building Safety 995,400 396,128 40%995,400
Customer Services 298,300 120,395 40%298,300
Economic Development 403,100 186,915 46%410,700
Emergency Services 4,170,300 1,692,624 41%4,562,500
Financial Management 855,300 356,130 42%857,800
GIS 433,600 179,097 41%433,600
Golf Courses 678,800 178,436 26%716,600
Human Resources 134,800 55,789 41%134,300
Information Technology 675,600 249,089 37%675,600
Legacy Flight Museum 91,600 8,570 9%91,600
Legal Services 248,200 107,843 43%248,200
Mayor, Council & Mayor's Youth Advisory Board 326,100 130,647 40%326,100
Miscellaneous 44,800 18,873 42%46,000
Parks & Ball Diamonds 673,600 202,862 30%691,300
Planning & Zoning 345,000 129,519 38%356,200
Recreation Administration & Programs 453,300 208,265 46%482,000
Rexburg Rapids 479,800 41,869 9%479,800
Total Misc. Departments/Categories 11,832,000 4,400,356 37%12,432,200
Police Department
Administration Division & Fund 09 1,353,100 512,318 38%1,365,100
Patrol Division & Funds 13 2,202,400 934,555 42%2,202,400
Investigations Division 687,600 310,412 45%687,600
Community Services Division & Funds 08,11,14 679,800 264,703 39%679,900
Total Police Department 4,922,900 2,021,988 41%4,935,000
Public Works
Building Maintenance 47,800 24,953 52%47,800
Shop 629,600 241,337 38%629,600
Sanitation 2,196,300 902,040 41%2,196,300
Water 3,021,900 1,056,700 35%3,021,900
Wastewater - Treatment 3,063,500 1,206,295 39%2,993,500
Wastewater - Collections 1,641,500 662,318 40%1,641,500
Street Operations 2,438,200 827,545 34%2,559,000
Street Repair Contracts 778,000 1,384,851 178%1,932,100
Total Public Works 13,816,800 6,306,039 46%15,021,700
TOTAL OPERATING EXPENDITURES 30,571,700 12,728,383 42%32,388,900
CAPITAL EXPENDITURES
Engineering 575,200 227,849 40%575,200
Construction 06,30,31,32,39,41,42,44,46,49,51-58,82,84,85 8,658,000 1,268,660 15%9,128,200
Contributed Capital Offset 1,675,000 0%1,675,000
Capital Reserve Funds 07,18,20,33,34,35,38 715,400 377,220 53%933,000
LID Debt Service Funds 59-69 1,073,400 43,711 4%1,073,400
Trust & RLF Funds 15,16,19,21,22,90,91 217,300 22,123 10%177,400
TOTAL CAPITAL EXPENDITURES 12,914,300 1,939,563 15%13,562,200
Contingent Operating Expenses 5,079,800 0%3,473,400
Contingent Capital Expenses 4,957,400 0%2,263,700
Internal Transfers Out for Operations 4,503,000 172,125 4%4,221,000
Internal Transfers Out for Capital 4,811,900 105,000 2%6,434,300
TOTAL EXPENDITURES FOR ALL FUNDS 62,838,100 14,945,071 24%62,343,500
CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2019 5 months ending
2/28/2019 Page 2
REVENUES BUDGET ACTUAL 42%FORECAST
OPERATING REVENUES
County Road Tax 830,000 536,150 65%830,000
Federal Grants 552,400 145,297 26%753,400
Franchise Fees 1,826,600 544,377 30%1,826,900
Fund Balances for Operations 3,191,100 0%4,387,700
Investment Earnings 147,200 72,937 50%147,200
Unrealized Gain (Loss)23,466 0%
Interfund Charges for Services 3,402,300 1,400,958 41%3,402,300
Miscellaneous 878,400 261,200 30%929,200
Operating Contributions 3,188,500 719,865 23%3,253,200
Parks, Recreation, Museums, Arts, Golf 1,310,200 187,420 14%1,387,500
Permits & Licenses 855,200 198,244 23%855,200
Property Tax 4,817,300 2,885,807 60%4,817,300
State Taxes & Grants 3,032,600 815,938 27%3,769,600
Utility Charges -Water 2,952,500 1,095,746 37%2,952,500
Utility Charges -Wastewater 6,329,800 2,056,657 32%6,329,800
Utility Charges -Sanitation 2,235,000 1,027,968 46%2,235,000
TOTAL OPERATING REVENUES 35,549,100 11,972,030 34%37,876,800
CAPITAL REVENUES
Borrowing - DEQ Water Loan 905,000 819,752 91%905,000
Capital Reserve Fees & Impact Fees 2,071,800 356,114 17%1,889,100
Capital Reserve Carryover Balances 4,201,500 0%5,362,900
Construction Funds 5,675,000 100,262 2%3,069,800
Contributed Capital 1,469,100 0%1,479,100
Engineering Billings 574,500 0%574,500
Fund Balances for Capital 510,900 0%1,041,500
Grants 345,800 0%669,500
LID Funds 300,000 142,329 47%692,000
Trust Funds 1,886,600 573,349 30%1,897,800
TOTAL CAPITAL REVENUES 17,940,200 1,991,806 11%17,581,200
Contingent Operating Revenues 0%
Contingent Capital Revenues 0%
Internal Transfers In for Operations 4,467,500 172,125 4%4,261,200
Internal Transfers In for Capital 4,881,300 105,000 2%6,503,700
TOTAL REVENUES ALL FUNDS 62,838,100 14,240,961 23%66,222,900
OPERATIONS SUMMARY
TOTAL OPERATING REVENUES 40,016,600 12,144,155 34%42,138,000
TOTAL OPERATING EXPENDITURES 40,154,500 12,900,508 42%40,083,300
---NET OPERATIONS -137,900 -756,353 2,054,700
CAPITAL SUMMARY
TOTAL CAPITAL REVENUES 22,821,500 2,096,806 11%24,084,900
TOTAL CAPITAL EXPENDITURES 22,683,600 2,044,563 15%22,260,200
---NET CAPITAL TRANSACTIONS 137,900 52,243 1,824,700
TOTAL ALL REVENUES 62,838,100 14,240,961 23%66,222,900
TOTAL ALL EXPENDITURES 62,838,100 14,945,071 24%62,343,500
NET ALL REVENUES OVER EXPENDITURES 0 -704,110 3,879,400
CITY OF REXBURG CASH & INVESTMENT
FY 2019 BALANCE REPORT
Page 3
BALANCE AS
OF
CASH & INVESTMENTS < 1 YEAR 1-5 YEARS > 5 YEARS
Bank of Commerce Legacy FM 35,854 0.13%35,854
Beehive Credit Union CD 250,000 0.93%250,000
Cash On Hand 2,450 0.01%2,450
Citizens Community Bank CD 248,979 0.93%248,979
City Golf Cart CD 114,900 0.43%114,900
Idaho Central Credit Union CD 250,000 0.93%250,000
Idaho Central Credit Union Savings 25 0.00%25
Key Bank Checking (RLF)348,506 1.30%348,506
Moreton Asset Management 2,291,521 2,732,368 18.75%5,023,889
Real Estate Investments (Streets)307,085 1.15%307,085
State Diversified Bond Fund 0 5,753,843 1,929,225 28.67%7,683,068
State LGIP--City 0 5,330,506 19.89%5,330,506
State LGIP--Fire District 307,514 297,783 2.26%605,297
Wells Fargo Drug Fund Checking 14,917 0.06%14,917
Wells Fargo Fire District Banking 532,797 1.99%532,797
Zions Bank Capital Advisors 3,075,126 1,941,008 18.72%5,016,134
Zions Bank Collateralized Acct 750,408 2.80%750,408
Zions Bank General Checking 262,495 0.98%262,495
Zions Bank Payroll Checking 20,000 0.07%20,000
TOTAL 8,812,577 16,055,508 1,929,225 100%26,797,310
% OF TOTAL PORTFOLIO 32.9%59.9%7.2%100%
I, Matthew K. Nielson, as Treasurer of the City of Rexburg, hereby under oath, certify to best of my knowledge,
that the above accounting of expenses, revenues, and cash and investment balances is true and correct.
% of Total
Portfolio