HomeMy WebLinkAboutBudget Summary Report - Mar 2019CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2019 6 months ending
3/31/2019 Page 1
EXPENDITURES BUDGET ACTUAL 50%FORECAST
OPERATING EXPENDITURES
Misc. Departments/Categories
Arts 524,400 192,161 37%647,400
Building Safety 995,400 480,756 48%1,002,900
Customer Services 298,300 141,765 48%291,300
Economic Development 403,100 213,408 53%406,400
Emergency Services 4,170,300 2,003,970 48%4,391,400
Financial Management 855,300 418,955 49%841,900
GIS 433,600 206,665 48%416,600
Golf Courses 678,800 231,543 34%727,700
Human Resources 134,800 67,049 50%134,900
Information Technology 675,600 298,717 44%652,000
Legacy Flight Museum 91,600 18,996 21%86,800
Legal Services 248,200 124,423 50%244,600
Mayor, Council & Mayor's Youth Advisory Board 326,100 152,381 47%314,000
Miscellaneous 44,800 21,621 48%51,300
Parks & Ball Diamonds 673,600 227,697 34%697,100
Planning & Zoning 345,000 146,369 42%290,900
Recreation Administration & Programs 453,300 241,059 53%488,300
Rexburg Rapids 479,800 55,167 11%473,200
Total Misc. Departments/Categories 11,832,000 5,242,702 44%12,158,700
Police Department
Administration Division & Fund 09 1,353,100 606,667 45%1,319,500
Patrol Division & Funds 13 2,202,400 1,102,704 50%2,235,000
Investigations Division 687,600 363,682 53%730,900
Community Services Division & Funds 08,11,14 679,800 330,152 49%672,700
Total Police Department 4,922,900 2,403,205 49%4,958,100
Public Works
Building Maintenance 47,800 28,394 59%56,300
Shop 629,600 283,715 45%620,100
Sanitation 2,196,300 1,041,494 47%2,229,100
Water 3,021,900 1,274,819 42%2,927,800
Wastewater - Treatment 3,063,500 1,435,740 47%2,953,700
Wastewater - Collections 1,641,500 781,570 48%1,612,900
Street Operations 2,438,200 970,282 40%2,584,300
Street Repair Contracts 778,000 1,385,730 178%1,854,100
Total Public Works 13,816,800 7,201,744 52%14,838,300
TOTAL OPERATING EXPENDITURES 30,571,700 14,847,651 49%31,955,100
CAPITAL EXPENDITURES
Engineering 575,200 276,962 48%579,500
Construction 06,30,31,32,39,41,42,44,46,49,51-58,82,84,85 8,658,000 1,295,787 15%8,606,700
Contributed Capital Offset 1,675,000 0%1,675,000
Capital Reserve Funds 07,18,20,33,34,35,38 715,400 384,260 54%893,600
LID Debt Service Funds 59-69 1,073,400 79,786 7%170,900
Trust & RLF Funds 15,16,19,21,22,90,91 217,300 30,917 14%179,000
TOTAL CAPITAL EXPENDITURES 12,914,300 2,067,712 16%12,104,700
Contingent Operating Expenses 5,079,800 0%
Contingent Capital Expenses 4,957,400 0%1,724,200
Internal Transfers Out for Operations 4,503,000 174,550 4%3,800,400
Internal Transfers Out for Capital 4,811,900 105,000 2%7,174,000
TOTAL EXPENDITURES FOR ALL FUNDS 62,838,100 17,194,913 27%56,758,400
CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2019 6 months ending
3/31/2019 Page 2
REVENUES BUDGET ACTUAL 50%FORECAST
OPERATING REVENUES
County Road Tax 830,000 541,977 65%885,000
Federal Grants 552,400 145,297 26%813,800
Franchise Fees 1,826,600 594,871 33%1,797,400
Fund Balances for Operations 3,191,100 0%4,510,300
Investment Earnings 147,200 92,920 63%162,400
Unrealized Gain (Loss)64,633 0%
Interfund Charges for Services - Overhead 3,402,300 1,681,150 49%3,384,300
Miscellaneous 878,400 320,562 36%685,700
Operating Contributions 3,188,500 748,537 23%3,118,900
Parks, Recreation, Museums, Arts, Golf 1,310,200 247,905 19%1,430,500
Permits & Licenses 855,200 319,196 37%844,700
Property Tax 4,817,300 2,915,591 61%4,817,300
State Taxes & Grants 3,772,600 1,555,938 41%3,875,600
Utility Charges -Water 2,952,500 1,328,090 45%3,093,500
Utility Charges -Wastewater 6,329,800 2,477,182 39%5,119,300
Utility Charges -Sanitation 2,235,000 1,237,997 55%2,451,500
TOTAL OPERATING REVENUES 36,289,100 14,271,846 39%36,990,200
CAPITAL REVENUES
Borrowing - DEQ Water Loan 905,000 819,752 91%1,323,800
Capital Reserve Fees & Impact Fees 2,071,800 799,399 39%2,126,300
Capital Reserve Carryover Balances 4,201,500 0%5,377,300
Construction Funds 5,675,000 120,124 2%3,010,000
Contributed Capital 1,469,100 0%1,497,100
Engineering Billings 574,500 0%574,500
Fund Balances for Capital 510,900 0%1,026,900
Grants 345,800 0%414,100
LID Funds 300,000 142,634 48%689,200
Trust Funds 1,886,600 584,367 31%1,844,800
TOTAL CAPITAL REVENUES 17,940,200 2,466,276 14%17,884,000
Contingent Operating Revenues 0%
Contingent Capital Revenues 0%
Internal Transfers In for Operations 4,467,500 174,550 4%3,781,300
Internal Transfers In for Capital 4,881,300 105,000 2%7,259,400
TOTAL REVENUES ALL FUNDS 63,578,100 17,017,672 27%65,914,900
OPERATIONS SUMMARY
TOTAL OPERATING REVENUES 40,756,600 14,446,396 39%40,771,500
TOTAL OPERATING EXPENDITURES 40,154,500 15,022,201 49%35,755,500
---NET OPERATIONS 602,100 -575,805 5,016,000
CAPITAL SUMMARY
TOTAL CAPITAL REVENUES 22,821,500 2,571,276 14%25,143,400
TOTAL CAPITAL EXPENDITURES 22,683,600 2,172,712 16%21,002,900
---NET CAPITAL TRANSACTIONS 137,900 398,564 4,140,500
TOTAL ALL REVENUES 63,578,100 17,017,672 27%65,914,900
TOTAL ALL EXPENDITURES 62,838,100 17,194,913 27%56,758,400
NET ALL REVENUES OVER EXPENDITURES 740,000 -177,241 9,156,500
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.92%250,000
Cash On Hand 2,450 0.01%2,450
Citizens Community Bank CD 248,979 0.92%248,979
City Golf Cart CD 114,900 0.42%114,900
Idaho Central Credit Union CD 250,000 0.92%250,000
Idaho Central Credit Union Savings 25 0.00%25
Key Bank Checking (RLF)369,549 1.36%369,549
Moreton Asset Management 2,291,521 2,757,243 18.64%5,048,764
Real Estate Investments (Streets)307,085 1.13%307,085
State Diversified Bond Fund 1,191,886 4,914,155 1,647,683 28.62%7,753,724
State LGIP--City 5,039,406 302,711 19.72%5,342,117
State LGIP--Fire District 572,242 34,374 2.24%606,616
Wells Fargo Drug Fund Checking 14,917 0.06%14,917
Wells Fargo Fire District Banking 541,724 2.00%541,724
Zions Bank Capital Advisors 3,075,126 1,958,804 18.58%5,033,930
Zions Bank Collateralized Acct 500,074 1.85%500,074
Zions Bank General Checking 648,606 2.39%648,606
Zions Bank Payroll Checking 20,000 0.07%20,000
TOTAL 15,475,667 9,967,287 1,647,683 100%27,090,637
% OF TOTAL PORTFOLIO 57.1%36.8%6.1%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