HomeMy WebLinkAboutBudget Summary Report - Aug 2020CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2020 11 months ending
8/31/2020 Page 1
EXPENDITURES BUDGET ACTUAL 92%FORECAST
OPERATING EXPENDITURES
Misc. Departments/Categories
Arts 733,000 304,802 42%665,000
Building Safety 839,600 716,271 85%795,200
Customer Services 316,200 288,896 91%314,200
Economic Development 362,800 289,484 80%341,200
Emergency Services 4,634,200 3,577,844 77%4,438,000
Financial Management 894,400 748,954 84%853,300
GIS 427,400 364,319 85%402,800
Golf Courses 830,300 718,387 87%883,300
Human Resources 145,100 129,725 89%141,600
Information Technology 695,600 624,155 90%687,100
Legacy Flight Museum 117,900 59,018 50%96,000
Legal Services 273,000 242,777 89%277,700
Mayor, Council & Mayor's Youth Advisory Board 328,100 311,928 95%344,700
Miscellaneous 49,300 46,154 94%46,900
Parks & Ball Diamonds 762,200 677,604 89%749,200
Planning & Zoning 385,400 311,193 81%356,800
Recreation Administration & Programs 551,900 442,885 80%522,900
Rexburg Rapids 726,200 547,647 75%654,100
Total Misc. Departments/Categories 13,072,600 10,402,043 80%12,570,000
Police Department
Administration Division & Fund 09 1,452,500 1,224,274 84%1,420,800
Patrol Division & Funds 13 2,279,800 1,992,403 87%2,253,300
Investigations Division 793,900 733,410 92%795,100
Community Services Division & Funds 08,11,14 731,800 639,002 87%730,000
Total Police Department 5,258,000 4,589,089 87%5,199,200
Public Works
Building Maintenance 52,800 39,308 74%49,300
Shop 610,700 522,574 86%608,600
Sanitation 2,266,500 2,023,401 89%2,309,500
Water 3,039,100 2,550,705 84%3,098,100
Wastewater - Treatment 2,976,900 2,822,531 95%3,128,600
Wastewater - Collections 1,737,200 1,549,364 89%1,627,600
Street Operations 2,739,700 2,284,878 83%2,753,600
Total Public Works 13,422,900 11,792,761 88%13,575,300
TOTAL OPERATING EXPENDITURES 31,753,500 26,783,893 84%31,344,500
CAPITAL EXPENDITURES
Engineering 563,800 505,588 90%567,100
Street Repair Contracts 150,400 628,961 418%738,900
Construction 06,30,31,32,39,41,42,44,46,49,51-58,82,84,85 16,666,400 6,542,868 39%10,081,100
Contributed Capital Offset 1,675,000 22,916 1%1,175,000
Capital Reserve Funds 07,18,20,33,34,35,38 702,800 298,502 42%512,800
LID Debt Service Funds 59-69 1,169,600 63,178 5%250,100
Trust & RLF Funds 15,16,19,21,22,90,91 629,900 121,176 19%150,100
TOTAL CAPITAL EXPENDITURES 21,557,900 8,183,189 38%13,475,100
Contingent Operating Expenses 4,212,100 0%12,100
Contingent Capital Expenses 2,355,800 0%25,900
Internal Transfers Out for Operations 4,580,400 2,627,866 57%4,510,400
Internal Transfers Out for Capital 7,832,300 365,416 5%6,543,900
TOTAL EXPENDITURES FOR ALL FUNDS 72,292,000 37,960,364 53%55,911,900
CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2020 11 months ending
8/31/2020 Page 2
REVENUES BUDGET ACTUAL 92%FORECAST
OPERATING REVENUES
County Road Tax 890,000 806,043 91%870,000
Federal Grants 844,600 58,880 7%802,400
Franchise Fees 1,771,400 1,432,231 81%1,753,200
Fund Balances for Operations 2,623,400 0%2,681,200
Investment Earnings 214,500 148,131 69%161,800
Unrealized Gain (Loss)139,177 0%
Interfund Charges for Services - Overhead 3,381,300 3,065,058 91%3,384,000
Miscellaneous 543,000 542,822 100%505,000
Operating Contributions 3,283,900 2,674,120 81%3,214,600
Parks, Recreation, Museums, Arts, Golf 1,392,600 1,163,025 84%1,282,900
Permits & Licenses 786,600 1,003,134 128%849,200
Property Tax 5,054,700 5,200,575 103%5,226,453
State Taxes & Grants 3,900,200 2,905,270 74%4,419,200
Utility Charges -Water 3,169,300 3,092,297 98%3,195,000
Utility Charges -Wastewater 5,127,800 4,671,821 91%5,126,000
Utility Charges -Sanitation 2,283,400 2,256,309 99%2,410,300
TOTAL OPERATING REVENUES 35,266,700 29,158,893 83%35,881,253
CAPITAL REVENUES
Borrowing - DEQ Water Loan 2,287,300 2,603,753 114%
Capital Reserve Fees & Impact Fees 2,125,500 2,710,360 128%2,590,400
Capital Reserve Carryover Balances 2,407,200 0%5,500,200
Construction Funds 6,890,600 526,252 8%3,134,500
Contributed Capital 1,425,000 22,916 2%3,689,000
Engineering Billings 563,100 0%567,100
Fund Balances for Capital 2,747,100 0%2,924,200
Grants & Contributions 3,576,100 0%1,386,300
LID Funds 201,000 28,577 14%256,800
Trust Funds 2,019,400 956,635 47%2,031,700
TOTAL CAPITAL REVENUES 24,242,300 6,848,493 28%22,080,200
Contingent Operating Revenues 0%
Contingent Capital Revenues 0%
Internal Transfers In for Operations 4,554,900 2,612,824 57%4,479,000
Internal Transfers In for Capital 8,228,100 379,999 5%6,668,700
TOTAL REVENUES ALL FUNDS 72,292,000 39,000,209 54%69,109,153
OPERATIONS SUMMARY
TOTAL OPERATING REVENUES 39,821,600 31,771,717 83%40,360,253
TOTAL OPERATING EXPENDITURES 40,546,000 29,411,759 84%35,867,000
---NET OPERATIONS -724,400 2,359,958 4,493,253
CAPITAL SUMMARY
TOTAL CAPITAL REVENUES 32,470,400 7,228,492 28%28,748,900
TOTAL CAPITAL EXPENDITURES 31,746,000 8,548,605 38%20,044,900
---NET CAPITAL TRANSACTIONS 724,400 -1,320,113 8,704,000
TOTAL ALL REVENUES 72,292,000 39,000,209 54%69,109,153
TOTAL ALL EXPENDITURES 72,292,000 37,960,364 53%55,911,900
NET ALL REVENUES OVER EXPENDITURES 0 1,039,845 13,197,253
CITY OF REXBURG CASH & INVESTMENT
FY 2020 BALANCE REPORT
Page 3
BALANCE AS
OF
CASH & INVESTMENTS < 1 YEAR 1-5 YEARS > 5 YEARS 8/31/2020
Bank of Commerce Bank CD 255,977 0.79%255,977
Bank of Commerce Legacy FM 28,462 0.09%28,462
Beehive Credit Union CD 250,152 0.77%250,152
Cash On Hand 2,550 0.01%2,550
City Golf Cart CD 68,940 0.21%68,940
East Idaho CU CD 251,639 0.78%251,639
Idaho Central Credit Union CD 250,025 0.77%250,025
Key Bank Checking (RLF)204,692 0.63%204,692
Moreton Asset Management 2,478,181 2,903,102 16.57%5,381,283
Mountain America Credit Union 250,331 0.77%250,331
Real Estate Investments (Streets)324,863 1.00%324,863
State Diversified Bond Fund 1,208,210 2,179,852 767,627 12.80%4,155,689
State LGIP--City 9,430,253 337,865 30.09%9,768,118
State LGIP--Fire District 601,126 21,537 1.92%622,663
TVI - Bond Investment 569,362 2,540,016 9.58%3,109,378
Wells Fargo Drug Fund Checking 14,417 0.04%14,417
Wells Fargo Fire District Banking 825,746 2.54%825,746
Westmark CD 252,421 0.78%252,421
Zions Bank Capital Advisors 3,559,059 1,629,703 15.98%5,188,762
Zions Bank Collateralized Acct 715,751 2.20%715,751
Zions Bank General Checking 526,407 1.62%526,407
Zions Bank Payroll Checking 20,000 0.06%20,000
TOTAL 22,088,564 9,612,075 767,627 100%32,468,266
% OF TOTAL PORTFOLIO 68.0%29.6%2.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