HomeMy WebLinkAboutBudget Summary Report - May 2019CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2019 8 months ending
5/31/2019 Page 1
EXPENDITURES BUDGET ACTUAL 67%FORECAST
OPERATING EXPENDITURES
Misc. Departments/Categories
Arts 527,900 277,673 53%634,800
Building Safety 995,400 704,053 71%958,800
Customer Services 298,300 191,844 64%291,800
Economic Development 408,100 286,371 70%407,300
Emergency Services 4,215,300 2,647,554 63%4,562,400
Financial Management 855,300 537,091 63%842,700
GIS 433,600 264,628 61%400,000
Golf Courses 696,600 386,848 56%767,900
Human Resources 134,800 91,715 68%134,700
Information Technology 675,600 423,160 63%663,200
Legacy Flight Museum 91,600 27,671 30%85,700
Legal Services 248,200 161,254 65%244,600
Mayor, Council & Mayor's Youth Advisory Board 330,600 209,009 63%313,200
Miscellaneous 44,800 26,968 60%51,600
Parks & Ball Diamonds 721,000 390,060 54%756,500
Planning & Zoning 345,000 177,759 52%291,200
Recreation Administration & Programs 453,300 331,219 73%471,400
Rexburg Rapids 479,800 112,062 23%460,500
Total Misc. Departments/Categories 11,955,200 7,246,939 61%12,338,300
Police Department
Administration Division & Fund 09 1,353,100 766,618 57%1,320,800
Patrol Division & Funds 13 2,202,400 1,475,028 67%2,248,800
Investigations Division 692,300 486,615 70%731,400
Community Services Division & Funds 08,11,14 679,800 445,806 66%712,300
Total Police Department 4,927,600 3,174,067 64%5,013,300
Public Works
Building Maintenance 47,800 37,913 79%56,300
Shop 629,600 380,660 60%622,100
Sanitation 2,196,300 1,437,348 65%2,217,800
Water 3,021,900 1,701,484 56%2,776,600
Wastewater - Treatment 3,063,500 1,943,736 63%2,926,800
Wastewater - Collections 1,641,500 1,105,648 67%1,629,900
Street Operations 2,513,200 1,306,000 52%2,579,100
Street Repair Contracts 1,518,000 1,434,277 94%2,594,100
Total Public Works 14,631,800 9,347,066 64%15,402,700
TOTAL OPERATING EXPENDITURES 31,514,600 19,768,072 63%32,754,300
CAPITAL EXPENDITURES
Engineering 575,200 356,125 62%558,500
Construction 06,30,31,32,39,41,42,44,46,49,51-58,82,84,85 8,658,000 1,946,124 22%6,632,000
Contributed Capital Offset 1,675,000 0%1,650,000
Capital Reserve Funds 07,18,20,33,34,35,38 715,400 395,262 55%761,500
LID Debt Service Funds 59-69 1,073,400 79,786 7%242,100
Trust & RLF Funds 15,16,19,21,22,90,91 217,300 30,917 14%99,400
TOTAL CAPITAL EXPENDITURES 12,914,300 2,808,214 22%9,943,500
Contingent Operating Expenses 4,967,300 0%
Contingent Capital Expenses 4,957,400 0%
Internal Transfers Out for Operations 4,440,400 179,400 4%4,091,300
Internal Transfers Out for Capital 4,811,900 105,000 2%5,976,400
TOTAL EXPENDITURES FOR ALL FUNDS 63,605,900 22,860,686 36%52,765,500
CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2019 8 months ending
5/31/2019 Page 2
REVENUES BUDGET ACTUAL 67%FORECAST
OPERATING REVENUES
County Road Tax 830,000 554,472 67%885,000
Federal Grants 557,100 155,742 28%876,500
Franchise Fees 1,826,600 1,019,482 56%1,765,800
Fund Balances for Operations 3,191,100 0%4,217,900
Investment Earnings 147,200 139,626 95%191,500
Unrealized Gain (Loss)82,868 0%
Interfund Charges for Services - Overhead 3,402,300 2,241,533 66%3,358,000
Miscellaneous 910,200 475,681 52%733,200
Operating Contributions 3,258,100 1,302,953 40%3,201,000
Parks, Recreation, Museums, Arts, Golf 1,310,200 603,389 46%1,428,800
Permits & Licenses 855,200 484,054 57%844,200
Property Tax 4,817,300 2,970,994 62%4,817,300
State Taxes & Grants 3,772,600 1,560,436 41%3,876,600
Utility Charges -Water 2,952,500 1,765,105 60%3,114,900
Utility Charges -Wastewater 6,329,800 3,297,714 52%5,071,300
Utility Charges -Sanitation 2,235,000 1,667,136 75%2,435,100
TOTAL OPERATING REVENUES 36,395,200 18,321,185 50%36,817,100
CAPITAL REVENUES
Borrowing - DEQ Water Loan 905,000 819,752 91%
Capital Reserve Fees & Impact Fees 2,071,800 1,369,673 66%2,160,900
Capital Reserve Carryover Balances 4,201,500 0%5,545,100
Construction Funds 5,675,000 187,574 3%1,778,700
Contributed Capital 1,430,000 0%1,430,000
Engineering Billings 574,500 0%577,800
Fund Balances for Capital 510,900 0%1,024,900
Grants 345,800 0%555,500
LID Funds 300,000 143,912 48%629,900
Trust Funds 1,886,600 597,495 32%1,844,600
TOTAL CAPITAL REVENUES 17,901,100 3,118,406 17%15,547,400
Contingent Operating Revenues 0%
Contingent Capital Revenues 0%
Internal Transfers In for Operations 4,428,300 509,400 12%4,083,200
Internal Transfers In for Capital 4,881,300 105,000 2%6,077,500
TOTAL REVENUES ALL FUNDS 63,605,900 22,053,991 35%62,525,200
OPERATIONS SUMMARY
TOTAL OPERATING REVENUES 40,823,500 18,830,585 50%40,900,300
TOTAL OPERATING EXPENDITURES 40,922,300 19,947,472 63%36,845,600
---NET OPERATIONS -98,800 -1,116,887 4,054,700
CAPITAL SUMMARY
TOTAL CAPITAL REVENUES 22,782,400 3,223,406 17%21,624,900
TOTAL CAPITAL EXPENDITURES 22,683,600 2,913,214 22%15,919,900
---NET CAPITAL TRANSACTIONS 98,800 310,192 5,705,000
TOTAL ALL REVENUES 63,605,900 22,053,991 35%62,525,200
TOTAL ALL EXPENDITURES 63,605,900 22,860,686 36%52,765,500
NET ALL REVENUES OVER EXPENDITURES 0 -806,695 9,759,700
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 37,177 0.14%37,177
Beehive Credit Union CD 250,000 0.93%250,000
Cash On Hand 4,250 0.02%4,250
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)369,549 1.38%369,549
Moreton Asset Management 2,291,521 2,788,235 18.99%5,079,756
Real Estate Investments (Streets)307,085 1.15%307,085
State Diversified Bond Fund 1,191,886 4,914,155 1,647,683 28.98%7,753,724
State LGIP--City 5,039,406 302,711 19.97%5,342,117
State LGIP--Fire District 572,242 34,374 2.27%606,616
Wells Fargo Drug Fund Checking 14,917 0.06%14,917
Wells Fargo Fire District Banking 547,627 2.05%547,627
Zions Bank Capital Advisors 3,075,126 1,986,470 18.92%5,061,596
Zions Bank Collateralized Acct 250,189 0.94%250,189
Zions Bank General Checking 497,585 1.86%497,585
Zions Bank Payroll Checking 19,934 0.07%19,934
TOTAL 15,082,398 10,025,945 1,647,683 100%26,756,026
% OF TOTAL PORTFOLIO 56.4%37.5%6.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