HomeMy WebLinkAboutBudget Summary Report - May 2020CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2020 8 months ending
5/31/2020 Page 1
EXPENDITURES BUDGET ACTUAL 67%FORECAST
OPERATING EXPENDITURES
Misc. Departments/Categories
Arts 733,000 201,913 28%659,500
Building Safety 839,600 539,598 64%795,200
Customer Services 316,200 213,613 68%314,200
Economic Development 337,800 247,315 73%341,200
Emergency Services 4,634,200 2,526,938 55%4,376,300
Financial Management 894,400 577,273 65%853,300
GIS 427,400 279,569 65%411,400
Golf Courses 830,300 402,242 48%849,800
Human Resources 145,100 96,209 66%141,600
Information Technology 695,600 464,303 67%687,100
Legacy Flight Museum 117,900 29,184 25%96,000
Legal Services 273,000 182,426 67%277,700
Mayor, Council & Mayor's Youth Advisory Board 328,100 212,288 65%322,700
Miscellaneous 49,300 19,368 39%49,300
Parks & Ball Diamonds 762,200 410,112 54%749,200
Planning & Zoning 385,400 230,268 60%349,900
Recreation Administration & Programs 551,900 324,659 59%513,700
Rexburg Rapids 726,200 307,257 42%645,100
Total Misc. Departments/Categories 13,047,600 7,264,535 56%12,433,200
Police Department
Administration Division & Fund 09 1,363,500 931,230 68%1,420,800
Patrol Division & Funds 13 2,398,800 1,449,598 60%2,249,800
Investigations Division 750,900 536,506 71%782,100
Community Services Division & Funds 08,11,14 731,800 467,211 64%717,100
Total Police Department 5,245,000 3,384,545 65%5,169,800
Public Works
Building Maintenance 52,800 28,888 55%50,300
Shop 610,700 402,878 66%616,400
Sanitation 2,266,500 1,410,541 62%2,309,500
Water 3,039,100 1,805,002 59%3,098,100
Wastewater - Treatment 2,976,900 2,035,374 68%3,088,600
Wastewater - Collections 1,737,200 1,118,530 64%1,627,600
Street Operations 2,739,700 1,789,986 65%2,753,600
Total Public Works 13,422,900 8,591,199 64%13,544,100
TOTAL OPERATING EXPENDITURES 31,715,500 19,240,279 61%31,147,100
CAPITAL EXPENDITURES
Engineering 563,800 374,079 66%567,100
Street Repair Contracts 150,400 226,528 151%554,900
Construction 06,30,31,32,39,41,42,44,46,49,51-58,82,84,85 14,776,500 3,977,426 27%11,233,100
Contributed Capital Offset 1,675,000 16,666 1%1,175,000
Capital Reserve Funds 07,18,20,33,34,35,38 702,800 188,107 27%502,400
LID Debt Service Funds 59-69 1,169,600 78,754 7%250,100
Trust & RLF Funds 15,16,19,21,22,90,91 629,900 105,330 17%148,400
TOTAL CAPITAL EXPENDITURES 19,668,000 4,966,890 25%14,431,000
Contingent Operating Expenses 4,045,800 0%32,800
Contingent Capital Expenses 2,269,400 0%25,900
Internal Transfers Out for Operations 4,380,400 2,001,316 46%4,492,300
Internal Transfers Out for Capital 6,205,600 296,666 5%5,908,500
TOTAL EXPENDITURES FOR ALL FUNDS 68,284,700 26,505,151 39%56,037,600
CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2020 8 months ending
5/31/2020 Page 2
REVENUES BUDGET ACTUAL 67%FORECAST
OPERATING REVENUES
County Road Tax 890,000 501,670 56%870,000
Federal Grants 844,600 47,405 6%634,000
Franchise Fees 1,771,400 1,022,314 58%1,754,100
Fund Balances for Operations 2,359,100 0%2,681,200
Investment Earnings 198,600 83,019 42%147,700
Unrealized Gain (Loss)87,160 0%
Interfund Charges for Services - Overhead 3,381,300 2,229,133 66%3,384,000
Miscellaneous 543,000 336,216 62%500,600
Operating Contributions 3,258,900 2,338,161 72%3,193,800
Parks, Recreation, Museums, Arts, Golf 1,392,600 531,474 38%1,222,300
Permits & Licenses 786,600 690,657 88%849,200
Property Tax 5,054,700 3,235,067 64%5,054,700
State Taxes & Grants 3,700,200 1,822,015 49%3,905,100
Utility Charges -Water 3,169,300 1,798,145 57%3,195,000
Utility Charges -Wastewater 5,127,800 3,384,207 66%5,126,000
Utility Charges -Sanitation 2,299,300 1,662,350 72%2,424,300
TOTAL OPERATING REVENUES 34,777,400 19,768,993 57%34,942,000
CAPITAL REVENUES
Borrowing - DEQ Water Loan 1,305,300 2,603,753 199%
Capital Reserve Fees & Impact Fees 2,125,500 1,940,046 91%2,575,900
Capital Reserve Carryover Balances 2,271,100 0%5,500,200
Construction Funds 7,382,400 206,391 3%4,350,800
Contributed Capital 1,425,000 16,666 1%3,689,000
Engineering Billings 563,100 0%567,100
Fund Balances for Capital 1,147,100 0%2,924,200
Grants & Contributions 3,331,800 0%889,800
LID Funds 201,000 24,230 12%256,800
Trust Funds 2,019,400 647,662 32%2,024,800
TOTAL CAPITAL REVENUES 21,771,700 5,438,748 25%22,778,600
Contingent Operating Revenues 0%
Contingent Capital Revenues 0%
Internal Transfers In for Operations 4,354,900 1,992,649 46%4,460,900
Internal Transfers In for Capital 7,380,700 304,999 4%6,312,600
TOTAL REVENUES ALL FUNDS 68,284,700 27,505,389 40%68,494,100
OPERATIONS SUMMARY
TOTAL OPERATING REVENUES 39,132,300 21,761,642 57%39,402,900
TOTAL OPERATING EXPENDITURES 40,141,700 21,241,595 61%35,672,200
---NET OPERATIONS -1,009,400 520,047 3,730,700
CAPITAL SUMMARY
TOTAL CAPITAL REVENUES 29,152,400 5,743,747 25%29,091,200
TOTAL CAPITAL EXPENDITURES 28,143,000 5,263,556 25%20,365,400
---NET CAPITAL TRANSACTIONS 1,009,400 480,191 8,725,800
TOTAL ALL REVENUES 68,284,700 27,505,389 40%68,494,100
TOTAL ALL EXPENDITURES 68,284,700 26,505,151 39%56,037,600
NET ALL REVENUES OVER EXPENDITURES 0 1,000,238 12,456,500
CITY OF REXBURG CASH & INVESTMENT
FY 2020 BALANCE REPORT
Page 3
BALANCE AS
OF
CASH & INVESTMENTS < 1 YEAR 1-5 YEARS > 5 YEARS 5/31/2020
Bank of Commerce Bank CD 254,165 0.78%254,165
Bank of Commerce Legacy FM 41,236 0.13%41,236
Beehive Credit Union CD 250,152 0.77%250,152
Cash On Hand 2,550 0.01%2,550
City Golf Cart CD 91,920 0.28%91,920
East Idaho CU CD 250,236 0.77%250,236
Idaho Central Credit Union CD 250,025 0.77%250,025
Key Bank Checking (RLF)379,972 1.16%379,972
Moreton Asset Management 3,965,624 1,383,812 16.37%5,349,436
Mountain America Credit Union 250,000 0.77%250,000
Real Estate Investments (Streets)324,863 0.99%324,863
State Diversified Bond Fund 1,202,137 2,168,897 763,769 12.65%4,134,803
State LGIP--City 6,487,800 232,444 20.57%6,720,244
State LGIP--Fire District 600,145 21,502 1.90%621,647
TVI - Bond Investment 450,000 2,540,016 9.15%2,990,016
Wells Fargo Drug Fund Checking 14,418 0.04%14,418
Wells Fargo Fire District Banking 530,039 1.62%530,039
Westmark CD 251,212 0.77%251,212
Zions Bank Capital Advisors 3,539,949 1,629,851 15.82%5,169,800
Zions Bank Collateralized Acct 2,215,842 6.78%2,215,842
Zions Bank General Checking 2,563,438 7.85%2,563,438
Zions Bank Payroll Checking 20,000 0.06%20,000
TOTAL 23,935,723 7,976,522 763,769 100%32,676,014
% OF TOTAL PORTFOLIO 73.3%24.4%2.3%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