HomeMy WebLinkAboutBudget Summary Report - July 2021CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2021 9 months ending
7/31/2021 Page 1
EXPENDITURES BUDGET ACTUAL 83%FORECAST
OPERATING EXPENDITURES
Misc. Departments/Categories
Arts 742,300 455,135 61%656,500
Building Safety 857,300 700,595 82%845,800
Customer Services 339,500 280,275 83%330,000
Economic Development 382,800 319,104 83%407,000
Emergency Services 4,736,300 3,867,863 82%4,761,600
Financial Management 1,229,700 830,856 68%998,400
GIS 361,000 281,920 78%349,200
Golf Courses 979,400 755,828 77%1,202,100
Human Resources 175,900 145,000 82%175,300
Information Technology 711,300 545,443 77%685,300
Legacy Flight Museum 73,500 49,465 67%197,900
Legal Services 287,300 234,696 82%281,000
Mayor, Council & Mayor's Youth Advisory Board 339,200 256,900 76%330,700
Miscellaneous 325,600 305,981 94%355,800
Parks & Ball Diamonds 798,000 594,211 74%832,500
Planning & Zoning 407,300 308,710 76%388,600
Recreation Administration & Programs 565,900 462,352 82%526,000
Rexburg Rapids 470,000 342,487 73%488,400
Total Misc. Departments/Categories 13,782,300 10,736,821 78%13,812,100
Police Department
Administration Division & Fund 09 1,525,300 1,309,459 86%1,526,700
Patrol Division & Funds 13 2,332,800 1,924,020 82%2,327,800
Investigations Division 832,900 690,473 83%832,600
Community Services Division & Funds 08,11,14 719,600 572,016 79%692,700
Support Service & Logistics 4,500 0%
Total Police Department 5,415,100 4,495,968 83%5,379,800
Public Works
Building Maintenance 66,500 54,711 82%66,100
Shop 578,700 452,566 78%586,300
Sanitation 2,532,900 2,147,205 85%2,625,100
Water 3,126,000 2,547,213 81%3,079,400
Wastewater - Treatment 3,090,900 2,494,614 81%3,087,800
Wastewater - Collections 1,742,200 1,461,089 84%1,785,400
Street Operations 2,913,300 2,167,944 74%3,076,600
Total Public Works 14,050,500 11,325,342 81%14,306,700
TOTAL OPERATING EXPENDITURES 33,247,900 26,558,131 80%33,498,600
CAPITAL EXPENDITURES
Engineering 574,000 472,955 82%566,300
Street Repair Contracts 1,203,600 26,536 2%310,000
Construction 06,30,31,32,39,41,42,44,46,49,51-58,82,84,85 14,596,200 3,435,715 24%8,433,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 39,838 3%553,600
LID Debt Service Funds 59-69 1,112,200 15,326 1%863,800
Trust & RLF Funds 15,16,19,21,22,90,91 573,300 19,954 3%44,600
TOTAL CAPITAL EXPENDITURES 20,757,200 4,031,157 19%12,096,500
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 33,113,396 41%58,715,800
CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2021 9 months ending
7/31/2021 Page 2
REVENUES BUDGET ACTUAL 83%FORECAST
OPERATING REVENUES
County Road Tax 870,000 616,028 71%800,000
Federal Grants 5,983,999 6,054,385 101%6,373,112
Franchise Fees 1,777,700 1,425,234 80%1,780,800
Fund Balances for Operations 4,030,901 0%2,780,000
Investment Earnings 129,100 130,892 101%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 760,704 147%458,500
Operating Contributions 3,279,300 2,616,828 80%3,452,100
Parks, Recreation, Museums, Arts, Golf 1,550,900 1,334,364 86%1,825,500
Permits & Licenses 760,300 839,926 110%996,500
Property Tax 4,152,200 4,336,655 104%4,152,200
State Taxes & Grants 3,891,900 3,970,081 102%5,227,300
Utility Charges -Water 3,258,300 2,689,722 83%3,428,600
Utility Charges -Wastewater 5,201,900 4,352,328 84%5,335,000
Utility Charges -Sanitation 2,526,000 2,297,892 91%2,633,500
TOTAL OPERATING REVENUES 41,371,600 34,162,417 83%42,816,412
CAPITAL REVENUES
Borrowing - DEQ Water Loan 1,473,000 0%
Capital Reserve Fees & Impact Fees 2,094,300 1,626,239 78%2,380,400
Capital Reserve Carryover Balances 6,464,000 0%7,298,400
Construction Funds 3,675,600 426,292 12%3,088,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 163,939 5%1,102,900
LID Funds 330,700 22,771 7%1,632,100
Trust Funds 2,104,400 707,783 34%2,213,200
TOTAL CAPITAL REVENUES 22,816,000 2,967,857 13%20,659,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 39,655,508 50%76,542,212
OPERATIONS SUMMARY
TOTAL OPERATING REVENUES 45,637,500 36,353,485 83%46,957,212
TOTAL OPERATING EXPENDITURES 42,588,000 28,768,906 80%37,718,300
---NET OPERATIONS 3,049,500 7,584,579 9,238,912
CAPITAL SUMMARY
TOTAL CAPITAL REVENUES 34,318,400 3,302,023 13%29,585,000
TOTAL CAPITAL EXPENDITURES 37,367,900 4,344,490 19%20,997,500
---NET CAPITAL TRANSACTIONS -3,049,500 -1,042,467 8,587,500
TOTAL ALL REVENUES 79,955,900 39,655,508 50%76,542,212
TOTAL ALL EXPENDITURES 79,955,900 33,113,396 41%58,715,800
NET ALL REVENUES OVER EXPENDITURES 0 6,542,112 17,826,412
CITY OF REXBURG CASH & INVESTMENT
FY 2021 BALANCE REPORT
Page 3
BALANCE AS
OF
CASH & INVESTMENTS < 1 YEAR 1-5 YEARS > 5 YEARS 7/31/2021
Bank of Commerce Bank CD 261,496 0.65%261,496
Bank of Commerce Legacy FM 36,705 0.09%36,705
Beehive Credit Union CD 250,152 0.62%250,152
Cash On Hand 5,370 0.01%5,370
City Golf Cart CD 45,960 0.11%45,960
East Idaho CU CD 255,914 0.63%255,914
Idaho Central Credit Union CD 250,025 0.62%250,025
Key Bank Checking (RLF)253,901 0.63%253,901
Moreton Asset Management 3,190,199 2,192,948 13.34%5,383,147
Mountain America Credit Union 251,461 0.62%251,461
Real Estate Investments (Streets)337,295 0.84%337,295
State Diversified Bond Fund 1,203,466 2,171,294 764,614 10.25%4,139,374
State LGIP--City 8,876,927 318,041 22.78%9,194,968
State LGIP--Fire District 602,695 21,593 1.55%624,288
TVI - Bond Investment 991,137 2,339,758 589,470 9.71%3,920,364
Wells Fargo Drug Fund Checking 13,086 0.03%13,086
Wells Fargo Fire District Banking 790,890 1.96%790,890
Westmark CD 254,847 0.63%254,847
Zions Bank Capital Advisors 4,087,377 1,130,040 12.93%5,217,417
Zions Bank Collateralized Acct 6,003,279 14.87%6,003,279
Zions Bank General Checking 2,856,062 7.08%2,856,062
Zions Bank Payroll Checking 19,152 0.05%19,152
TOTAL 30,837,395 8,173,674 1,354,084 100%40,365,153
% OF TOTAL PORTFOLIO 76.4%20.2%3.4%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