HomeMy WebLinkAboutBudget Summary Report - Aug 2021CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2021 11 months ending
8/31/2021 Page 1
EXPENDITURES BUDGET ACTUAL 92%FORECAST
OPERATING EXPENDITURES
Misc. Departments/Categories
Arts 742,300 477,232 64%661,500
Building Safety 857,300 766,364 89%845,800
Customer Services 339,500 303,256 89%330,000
Economic Development 382,800 357,977 94%412,500
Emergency Services 4,736,300 4,502,042 95%4,761,600
Financial Management 1,229,700 897,120 73%998,400
GIS 361,000 316,958 88%349,200
Golf Courses 979,400 879,633 90%1,224,900
Human Resources 175,900 157,467 90%175,300
Information Technology 711,300 601,916 85%685,300
Legacy Flight Museum 73,500 50,503 69%197,900
Legal Services 287,300 257,089 89%281,000
Mayor, Council & Mayor's Youth Advisory Board 339,200 286,574 84%330,700
Miscellaneous 325,600 308,003 95%354,700
Parks & Ball Diamonds 798,000 687,180 86%832,500
Planning & Zoning 407,300 340,202 84%388,600
Recreation Administration & Programs 565,900 507,823 90%526,000
Rexburg Rapids 470,000 465,271 99%488,400
Total Misc. Departments/Categories 13,782,300 12,162,610 88%13,844,300
Police Department
Administration Division & Fund 09 1,525,300 1,419,897 93%1,528,500
Patrol Division & Funds 13 2,332,800 2,121,906 91%2,327,800
Investigations Division 832,900 749,991 90%832,600
Community Services Division & Funds 08,11,14 719,600 638,321 89%692,700
Support Service & Logistics 4,500 0%
Total Police Department 5,415,100 4,930,115 91%5,381,600
Public Works
Building Maintenance 66,500 58,784 88%66,100
Shop 578,700 487,766 84%586,300
Sanitation 2,532,900 2,211,264 87%2,625,100
Water 3,126,000 2,632,680 84%3,079,400
Wastewater - Treatment 3,090,900 2,579,254 83%3,087,800
Wastewater - Collections 1,742,200 1,508,941 87%1,785,400
Street Operations 2,913,300 2,288,130 79%3,076,600
Total Public Works 14,050,500 11,766,819 84%14,306,700
TOTAL OPERATING EXPENDITURES 33,247,900 28,859,544 87%33,532,600
CAPITAL EXPENDITURES
Engineering 574,000 508,884 89%566,300
Street Repair Contracts 1,203,600 34,498 3%310,000
Construction 06,30,31,32,39,41,42,44,46,49,51-58,82,84,85 14,596,200 3,724,417 26%8,441,200
Contributed Capital Offset 1,325,000 20,833 2%1,325,000
Capital Reserve Funds 07,18,20,33,34,35,38 1,372,900 58,199 4%577,800
LID Debt Service Funds 59-69 1,112,200 25,816 2%863,800
Trust & RLF Funds 15,16,19,21,22,90,91 573,300 19,954 3%42,100
TOTAL CAPITAL EXPENDITURES 20,757,200 4,392,601 21%12,126,200
Contingent Operating Expenses 5,048,700 0%41,700
Contingent Capital Expenses 5,113,300 0%90,700
Internal Transfers Out for Operations 4,291,400 2,210,775 52%4,178,000
Internal Transfers Out for Capital 11,497,400 313,333 3%8,810,300
TOTAL EXPENDITURES FOR ALL FUNDS 79,955,900 35,776,253 45%58,779,500
CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2021 11 months ending
8/31/2021 Page 2
REVENUES BUDGET ACTUAL 92%FORECAST
OPERATING REVENUES
County Road Tax 870,000 619,486 71%800,000
Federal Grants 5,983,999 6,086,090 102%6,373,112
Franchise Fees 1,777,700 1,468,660 83%1,780,600
Fund Balances for Operations 4,030,901 0%2,780,000
Investment Earnings 129,100 132,799 103%147,400
Unrealized Gain (Loss)-92,038 0%-16,000
Interfund Charges for Services - Overhead 3,441,800 2,829,416 82%3,441,900
Miscellaneous 517,300 797,661 154%459,000
Operating Contributions 3,279,300 2,711,346 83%3,452,100
Parks, Recreation, Museums, Arts, Golf 1,550,900 1,696,154 109%1,858,500
Permits & Licenses 760,300 901,247 119%996,500
Property Tax 4,152,200 4,358,977 105%4,152,200
State Taxes & Grants 3,891,900 3,970,228 102%5,227,300
Utility Charges -Water 3,258,300 3,139,966 96%3,428,600
Utility Charges -Wastewater 5,201,900 4,790,800 92%5,335,000
Utility Charges -Sanitation 2,526,000 2,537,777 100%2,633,500
TOTAL OPERATING REVENUES 41,371,600 35,948,569 87%42,849,712
CAPITAL REVENUES
Borrowing - DEQ Water Loan 1,473,000 0%
Capital Reserve Fees & Impact Fees 2,094,300 2,041,763 97%2,380,400
Capital Reserve Carryover Balances 6,464,000 0%7,298,400
Construction Funds 3,675,600 448,393 12%3,087,300
Contributed Capital 825,000 20,833 3%825,000
Engineering Billings 574,000 0%563,300
Fund Balances for Capital 1,727,900 0%1,555,600
Grants & Contributions 3,547,100 190,528 5%1,102,900
LID Funds 330,700 24,723 7%1,632,100
Trust Funds 2,104,400 707,906 34%2,213,200
TOTAL CAPITAL REVENUES 22,816,000 3,434,146 15%20,658,200
Contingent Operating Revenues 0%
Contingent Capital Revenues 0%
Internal Transfers In for Operations 4,265,900 2,191,068 51%4,140,800
Internal Transfers In for Capital 11,502,400 334,166 3%8,925,800
TOTAL REVENUES ALL FUNDS 79,955,900 41,907,949 52%76,574,512
OPERATIONS SUMMARY
TOTAL OPERATING REVENUES 45,637,500 38,139,637 87%46,990,512
TOTAL OPERATING EXPENDITURES 42,588,000 31,070,319 87%37,752,300
---NET OPERATIONS 3,049,500 7,069,318 9,238,212
CAPITAL SUMMARY
TOTAL CAPITAL REVENUES 34,318,400 3,768,312 15%29,584,000
TOTAL CAPITAL EXPENDITURES 37,367,900 4,705,934 21%21,027,200
---NET CAPITAL TRANSACTIONS -3,049,500 -937,622 8,556,800
TOTAL ALL REVENUES 79,955,900 41,907,949 52%76,574,512
TOTAL ALL EXPENDITURES 79,955,900 35,776,253 45%58,779,500
NET ALL REVENUES OVER EXPENDITURES 0 6,131,696 17,795,012
CITY OF REXBURG CASH & INVESTMENT
FY 2021 BALANCE REPORT
Page 3
BALANCE AS
OF
CASH & INVESTMENTS < 1 YEAR 1-5 YEARS > 5 YEARS 8/31/2021
Bank of Commerce Bank CD 261,496 0.68%261,496
Bank of Commerce Legacy FM 36,705 0.09%36,705
Beehive Credit Union CD 250,152 0.65%250,152
Cash On Hand 5,370 0.01%5,370
City Golf Cart CD 45,960 0.12%45,960
East Idaho CU CD 255,914 0.66%255,914
Idaho Central Credit Union CD 250,025 0.65%250,025
Key Bank Checking (RLF)253,901 0.66%253,901
Moreton Asset Management 3,190,199 2,192,948 13.91%5,383,147
Mountain America Credit Union 251,461 0.65%251,461
Real Estate Investments (Streets)327,298 0.85%327,298
State Diversified Bond Fund 1,203,466 2,171,294 764,614 10.70%4,139,374
State LGIP--City 8,876,927 318,041 23.76%9,194,968
State LGIP--Fire District 602,695 21,593 1.61%624,288
TVI - Bond Investment 991,137 2,339,758 589,470 10.13%3,920,364
Wells Fargo Drug Fund Checking 13,086 0.03%13,086
Wells Fargo Fire District Banking 790,890 2.04%790,890
Westmark CD 254,847 0.66%254,847
Zions Bank Capital Advisors 4,087,377 1,130,040 13.48%5,217,417
Zions Bank Collateralized Acct 6,003,279 15.51%6,003,279
Zions Bank General Checking 1,200,020 3.10%1,200,020
Zions Bank Payroll Checking 19,795 0.05%19,795
TOTAL 29,171,999 8,173,674 1,354,084 100%38,699,757
% OF TOTAL PORTFOLIO 75.4%21.1%3.5%100%
I, Matthew K. Nielson, as Treasurer of the City of Rexburg, hereby under oath, certify to the best of my knowledge,
that the above accounting of expenses, revenues, and cash and investment balances is true and correct.
% of Total
Portfolio