HomeMy WebLinkAboutBudget Summary ReportCITY OF REXBURG BUDGET SUMMARY REPORT
FY 2019 3 months ending
12/31/2018 Page 1
EXPENDITURES BUDGET ACTUAL 25%FORECAST
OPERATING EXPENDITURES
Arts 524,400 95,503 18%524,400
Building Safety 995,400 247,307 25%995,400
Customer Services 298,300 75,864 25%298,300
Economic Development 403,100 133,394 33%410,700
Emergency Services 4,170,300 1,079,555 26%4,322,500
Financial Management 855,300 217,407 25%855,300
GIS 433,600 84,693 20%433,600
Golf Courses 678,800 138,912 20%702,600
Human Resources 134,800 33,010 24%134,800
Information Technology 675,600 154,578 23%675,600
Legacy Flight Museum 91,600 7,437 8%91,600
Legal Services 248,200 71,465 29%248,200
Mayor, Council & Mayor's Youth Advisory Board 326,100 81,247 25%326,100
Miscellaneous 44,800 13,518 30%45,200
Parks & Ball Diamonds 673,600 128,249 19%697,800
Planning & Zoning 345,000 92,247 27%345,000
Recreation Administration & Programs 453,300 126,360 28%475,200
Rexburg Rapids 479,800 24,676 5%479,800
Police Department
Administration Division & Fund 09 1,353,100 266,769 20%1,365,100
Patrol Division & Funds 13 2,202,400 566,457 26%2,202,400
Investigations Division 687,600 192,028 28%687,600
Community Services Division & Funds 08,11,14 679,800 162,395 24%679,900
Total Police Department 4,922,900 1,187,649 24%4,935,000
Public Works
Building Maintenance 47,800 13,581 28%47,800
Shop 629,600 143,880 23%629,600
Sanitation 2,196,300 548,497 25%2,196,300
Water 3,021,900 662,767 22%3,021,900
Wastewater - Treatment 3,063,500 701,848 23%3,063,500
Wastewater - Collections 1,641,500 408,920 25%1,641,500
Street Operations 2,438,200 447,321 18%2,512,800
Street Repair Contracts 778,000 1,384,851 178%2,278,000
Total Public Works 13,816,800 4,311,665 31%15,391,400
TOTAL OPERATING EXPENDITURES 30,571,700 8,304,736 27%32,388,500
CAPITAL EXPENDITURES
Engineering 575,200 137,777 24%575,200
Construction 06,30,31,32,39,41,42,44,46,49,51-58,82,84,85 8,658,000 965,744 11%13,919,800
Contributed Capital Offset 1,675,000 0%1,675,000
Capital Reserve Funds 07,18,20,33,34,35,38 715,400 -5,582 -1%761,400
LID Debt Service Funds 59-69 1,073,400 0%1,073,400
Trust & RLF Funds 15,16,19,21,22,90,91 217,300 9,550 4%175,000
TOTAL CAPITAL EXPENDITURES 12,914,300 1,107,489 9%18,179,800
Contingent Operating Expenses 5,079,800 0%3,798,500
Contingent Capital Expenses 4,957,400 0%3,999,800
Internal Transfers Out for Operations 4,503,000 7,275 0%3,010,000
Internal Transfers Out for Capital 4,811,900 0%7,711,600
TOTAL EXPENDITURES FOR ALL FUNDS 62,838,100 9,419,500 15%69,088,200
CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2019 3 months ending
12/31/2018 Page 2
REVENUES BUDGET ACTUAL 25%FORECAST
OPERATING REVENUES
County Road Tax 830,000 115,431 14%830,000
Federal Grants 552,400 1,910 0%578,400
Franchise Fees 1,826,600 151,031 8%1,826,600
Fund Balances for Operations 3,191,100 0%4,353,700
Investment Earnings 147,200 45,224 31%147,200
Unrealized Gain (Loss)-17,560 0%
Interfund Charges for Services 3,402,300 840,575 25%3,402,300
Miscellaneous 878,400 144,575 16%883,700
Operating Contributions 3,188,500 493,477 15%3,251,000
Parks, Recreation, Museums, Arts, Golf 1,310,200 155,836 12%1,311,200
Permits & Licenses 855,200 146,493 17%855,200
Property Tax 4,817,300 626,067 13%4,817,300
State Taxes & Grants 3,032,600 146 0%3,029,600
Utility Charges -Water 2,952,500 708,767 24%2,952,500
Utility Charges -Wastewater 6,329,800 1,246,868 20%6,329,800
Utility Charges -Sanitation 2,235,000 618,781 28%2,235,000
TOTAL OPERATING REVENUES 35,549,100 5,277,621 15%36,803,500
CAPITAL REVENUES
Borrowing 905,000 819,752 91%905,000
Capital Reserve Fees & Impact Fees 2,071,800 254,563 12%2,071,800
Capital Reserve Carryover Balances 4,201,500 0%4,201,500
Construction Funds 5,675,000 59,069 1%7,169,900
Contributed Capital 1,469,100 0%1,469,100
Engineering Billings 574,500 0%574,500
Fund Balances for Capital 510,900 0%511,000
Grants 345,800 0%669,500
LID Funds 300,000 139,466 46%692,000
Trust Funds 1,886,600 2,330 0%1,886,600
TOTAL CAPITAL REVENUES 17,940,200 1,275,180 7%20,150,900
Contingent Operating Revenues 0%
Contingent Capital Revenues 0%
Internal Transfers In for Operations 4,467,500 167,275 4%3,031,700
Internal Transfers In for Capital 4,881,300 105,000 2%7,781,000
TOTAL REVENUES ALL FUNDS 62,838,100 6,825,076 11%67,767,100
OPERATIONS SUMMARY
TOTAL OPERATING REVENUES 40,016,600 5,444,896 15%39,835,200
TOTAL OPERATING EXPENDITURES 40,154,500 8,312,011 27%39,197,000
---NET OPERATIONS -137,900 -2,867,115 638,200
CAPITAL SUMMARY
TOTAL CAPITAL REVENUES 22,821,500 1,380,180 7%27,931,900
TOTAL CAPITAL EXPENDITURES 22,683,600 1,107,489 9%29,891,200
---NET CAPITAL TRANSACTIONS 137,900 272,691 -1,959,300
TOTAL ALL REVENUES 62,838,100 6,825,076 11%67,767,100
TOTAL ALL EXPENDITURES 62,838,100 9,419,500 15%69,088,200
NET ALL REVENUES OVER EXPENDITURES 0 -2,594,424 -1,321,100
CITY OF REXBURG CASH & INVESTMENT
FY 2019 BALANCE REPORT
Page 3
BALANCE AS
OF
CASH & INVESTMENTS < 1 YEAR 1-5 YEARS > 5 YEARS 12/31/2018
Bank of Commerce Legacy FM 36,604 0.15%36,604
Beehive Credit Union CD 250,000 0.99%250,000
Cash On Hand 1,050 0.00%1,050
Citizens Community Bank CD 248,979 0.99%248,979
City Golf Cart CD 114,900 0.46%114,900
Idaho Central Credit Union CD 250,000 0.99%250,000
Idaho Central Credit Union Savings 25 0.00%25
Key Bank Checking (RLF)339,204 1.35%339,204
Moreton Asset Management 1,472,949 2,262,449 14.83%3,735,398
Real Estate Investments (Streets)307,085 1.22%307,085
State Diversified Bond Fund 652,796 4,708,555 2,267,923 30.29%7,629,274
State LGIP--City 4,925,421 648,579 22.13%5,574,000
State LGIP--Fire District 530,580 69,867 2.38%600,447
Wells Fargo Drug Fund Checking 15,418 0.06%15,418
Wells Fargo Fire District Banking 249,494 0.99%249,494
Zions Bank Capital Advisors 1,037,209 2,192,828 12.82%3,230,037
Zions Bank Collateralized Acct 2,000,198 7.94%2,000,198
Zions Bank General Checking 584,962 2.32%584,962
Zions Bank Payroll Checking 19,977 0.08%19,977
TOTAL 13,036,851 9,882,278 2,267,923 100%25,187,052
% OF TOTAL PORTFOLIO 51.8%39.2%9.0%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