HomeMy WebLinkAboutBudget Summary Report - Nov 2020CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2021 2 months ending
11/30/2020 Page 1
EXPENDITURES BUDGET ACTUAL 17%FORECAST
OPERATING EXPENDITURES
Misc. Departments/Categories
Arts 401,000 144,488 36%636,600
Building Safety 851,800 176,391 21%856,800
Customer Services 329,400 58,579 18%329,400
Economic Development 375,600 56,100 15%425,600
Emergency Services 4,478,300 1,024,588 23%4,478,300
Financial Management 868,300 143,409 17%868,600
GIS 361,000 82,528 23%361,400
Golf Courses 859,500 152,063 18%869,500
Human Resources 170,200 26,450 16%170,200
Information Technology 711,300 110,882 16%711,300
Legacy Flight Museum 73,500 4,452 6%73,500
Legal Services 287,300 45,710 16%287,300
Mayor, Council & Mayor's Youth Advisory Board 339,200 58,599 17%339,200
Miscellaneous 44,700 241,664 541%444,700
Parks & Ball Diamonds 784,700 98,493 13%784,700
Planning & Zoning 374,100 56,704 15%374,100
Recreation Administration & Programs 557,200 69,602 12%561,200
Rexburg Rapids 579,800 20,611 4%470,000
Total Misc. Departments/Categories 12,446,900 2,571,313 21%13,042,400
Police Department
Administration Division & Fund 09 1,498,000 288,291 19%1,498,000
Patrol Division & Funds 13 2,331,400 369,341 16%2,331,400
Investigations Division 824,400 137,847 17%824,400
Community Services Division & Funds 08,11,14 739,600 109,764 15%739,600
Total Police Department 5,393,400 905,243 17%5,393,400
Public Works
Building Maintenance 66,500 7,334 11%66,500
Shop 578,700 82,681 14%578,700
Sanitation 2,530,400 356,883 14%2,530,400
Water 3,119,500 453,789 15%3,119,500
Wastewater - Treatment 3,088,100 437,889 14%3,088,100
Wastewater - Collections 1,736,200 311,561 18%1,736,200
Street Operations 2,903,100 307,763 11%2,917,700
Total Public Works 14,022,500 1,957,900 14%14,037,100
TOTAL OPERATING EXPENDITURES 31,862,800 5,434,456 17%32,472,900
CAPITAL EXPENDITURES
Engineering 574,000 94,536 16%574,000
Street Repair Contracts 1,203,600 0%203,600
Construction 06,30,31,32,39,41,42,44,46,49,51-58,82,84,85 10,765,100 1,035,301 10%15,473,500
Contributed Capital Offset 1,325,000 4,166 0%1,325,000
Capital Reserve Funds 07,18,20,33,34,35,38 1,386,400 8,065 1%1,372,900
LID Debt Service Funds 59-69 1,112,200 0%1,112,200
Trust & RLF Funds 15,16,19,21,22,90,91 573,300 10,722 2%573,300
TOTAL CAPITAL EXPENDITURES 16,939,600 1,152,790 7%20,634,500
Contingent Operating Expenses 4,492,000 0%4,988,000
Contingent Capital Expenses 4,854,500 0%4,886,200
Internal Transfers Out for Operations 3,674,900 378,249 10%3,914,400
Internal Transfers Out for Capital 7,305,400 41,666 1%9,199,000
TOTAL EXPENDITURES FOR ALL FUNDS 69,129,200 7,007,161 10%76,095,000
CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2021 2 months ending
11/30/2020 Page 2
REVENUES BUDGET ACTUAL 17%FORECAST
OPERATING REVENUES
County Road Tax 870,000 412 0%870,000
Federal Grants 649,200 -55,141 -8%2,387,400
Franchise Fees 1,777,700 104,086 6%1,777,700
Fund Balances for Operations 3,077,600 0%3,003,200
Investment Earnings 129,100 18,210 14%129,100
Unrealized Gain (Loss)-9,417 0%
Interfund Charges for Services - Overhead 3,441,800 566,133 16%3,441,800
Miscellaneous 517,300 30,313 6%517,400
Operating Contributions 3,195,300 187,374 6%3,196,300
Parks, Recreation, Museums, Arts, Golf 1,471,200 92,916 6%1,467,500
Permits & Licenses 760,300 163,915 22%760,300
Property Tax 5,554,500 24,455 0%5,554,500
State Taxes & Grants 3,129,900 -4,482 0%4,154,900
Utility Charges -Water 3,258,300 532,481 16%3,258,300
Utility Charges -Wastewater 5,201,900 850,930 16%5,701,900
Utility Charges -Sanitation 2,526,000 453,308 18%2,526,000
TOTAL OPERATING REVENUES 35,560,100 2,955,493 8%38,746,300
CAPITAL REVENUES
Borrowing - DEQ Water Loan 1,473,000 0%1,473,000
Capital Reserve Fees & Impact Fees 2,094,300 119,975 6%2,094,300
Capital Reserve Carryover Balances 6,353,500 0%7,308,600
Construction Funds 3,528,900 41,408 1%5,532,300
Contributed Capital 825,000 4,166 1%825,000
Engineering Billings 574,000 0%574,000
Fund Balances for Capital 1,298,300 0%1,421,600
Grants & Contributions 3,547,100 -40,289 -1%1,238,100
LID Funds 330,700 6,799 2%1,635,000
Trust Funds 2,104,400 20,866 1%2,238,400
TOTAL CAPITAL REVENUES 22,129,200 152,925 1%24,340,300
Contingent Operating Revenues 0%
Contingent Capital Revenues 0%
Internal Transfers In for Operations 4,205,200 368,916 9%4,227,100
Internal Transfers In for Capital 7,234,700 45,833 1%9,345,900
TOTAL REVENUES ALL FUNDS 69,129,200 3,523,167 5%76,659,600
OPERATIONS SUMMARY
TOTAL OPERATING REVENUES 39,765,300 3,324,409 8%42,973,400
TOTAL OPERATING EXPENDITURES 40,029,700 5,812,705 17%41,375,300
---NET OPERATIONS -264,400 -2,488,296 1,598,100
CAPITAL SUMMARY
TOTAL CAPITAL REVENUES 29,363,900 198,758 1%33,686,200
TOTAL CAPITAL EXPENDITURES 29,099,500 1,194,456 7%34,719,700
---NET CAPITAL TRANSACTIONS 264,400 -995,698 -1,033,500
TOTAL ALL REVENUES 69,129,200 3,523,167 5%76,659,600
TOTAL ALL EXPENDITURES 69,129,200 7,007,161 10%76,095,000
NET ALL REVENUES OVER EXPENDITURES 0 -3,483,994 564,600
CITY OF REXBURG CASH & INVESTMENT
FY 2021 BALANCE REPORT
Page 3
BALANCE AS
OF
CASH & INVESTMENTS < 1 YEAR 1-5 YEARS > 5 YEARS 11/30/2020
Bank of Commerce Bank CD 257,802 0.90%257,802
Bank of Commerce Legacy FM 36,925 0.13%36,925
Beehive Credit Union CD 250,152 0.88%250,152
Cash On Hand 1,575 0.01%1,575
City Golf Cart CD 68,940 0.24%68,940
East Idaho CU CD 253,066 0.89%253,066
Idaho Central Credit Union CD 250,025 0.88%250,025
Key Bank Checking (RLF)233,809 0.82%233,809
Moreton Asset Management 2,474,999 2,903,102 18.86%5,378,101
Mountain America Credit Union 250,710 0.88%250,710
Real Estate Investments (Streets)326,663 1.15%326,663
State Diversified Bond Fund 1,208,117 2,179,687 767,569 14.57%4,155,373
State LGIP--City 5,547,810 198,766 20.15%5,746,576
State LGIP--Fire District 602,040 21,570 2.19%623,610
TVI - Bond Investment 1,106,460 2,540,016 12.79%3,646,476
Wells Fargo Drug Fund Checking 14,417 0.05%14,417
Wells Fargo Fire District Banking 865,257 3.03%865,257
Westmark CD 253,645 0.89%253,645
Zions Bank Capital Advisors 3,568,570 1,629,703 18.23%5,198,273
Zions Bank Collateralized Acct 255,709 0.90%255,709
Zions Bank General Checking 430,766 1.51%430,766
Zions Bank Payroll Checking 20,000 0.07%20,000
TOTAL 18,277,457 9,472,844 767,569 100%28,517,870
% OF TOTAL PORTFOLIO 64.1%33.2%2.7%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