HomeMy WebLinkAboutBudget Summary Report - Nov 2019CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2020 2 months ending
11/30/2019 Page 1
EXPENDITURES BUDGET ACTUAL 17%FORECAST
OPERATING EXPENDITURES
Misc. Departments/Categories
Arts 642,400 48,116 7%644,800
Building Safety 839,600 114,588 14%839,600
Customer Services 306,900 49,762 16%306,900
Economic Development 399,900 46,737 12%399,900
Emergency Services 4,617,700 468,313 10%4,634,200
Financial Management 894,400 153,125 17%895,800
GIS 427,400 45,984 11%427,400
Golf Courses 725,000 138,677 19%807,200
Human Resources 141,600 19,177 14%141,600
Information Technology 695,600 81,176 12%705,600
Legacy Flight Museum 117,900 2,504 2%117,900
Legal Services 273,000 33,085 12%273,000
Mayor, Council & Mayor's Youth Advisory Board 328,100 49,853 15%328,100
Miscellaneous 49,300 3,567 7%49,300
Parks & Ball Diamonds 732,800 104,960 14%730,300
Planning & Zoning 385,400 48,227 13%385,400
Recreation Administration & Programs 506,200 69,121 14%507,700
Rexburg Rapids 477,200 170,129 36%638,200
Total Misc. Departments/Categories 12,560,400 1,647,101 13%12,832,900
Police Department
Administration Division & Fund 09 1,309,000 191,990 15%1,309,000
Patrol Division & Funds 13 2,382,800 280,274 12%2,382,800
Investigations Division 750,900 101,581 14%750,900
Community Services Division & Funds 08,11,14 731,800 88,049 12%731,800
Total Police Department 5,174,500 661,894 13%5,174,500
Public Works
Building Maintenance 52,800 6,198 12%52,800
Shop 610,700 75,608 12%610,700
Sanitation 2,266,500 350,860 15%2,266,500
Water 3,039,100 419,749 14%3,039,100
Wastewater - Treatment 2,976,900 454,783 15%2,976,900
Wastewater - Collections 1,735,400 279,599 16%1,735,400
Street Operations 2,432,700 490,684 20%2,432,700
Street Repair Contracts 208,000 184,049 88%208,000
Total Public Works 13,322,100 2,261,530 17%13,322,100
TOTAL OPERATING EXPENDITURES 31,057,000 4,570,525 15%31,329,500
CAPITAL EXPENDITURES
Engineering 563,800 74,435 13%563,800
Construction 06,30,31,32,39,41,42,44,46,49,51-58,82,84,85 14,776,500 517,571 4%15,936,200
Contributed Capital Offset 1,675,000 4,166 0%1,675,000
Capital Reserve Funds 07,18,20,33,34,35,38 600,500 13,485 2%625,000
LID Debt Service Funds 59-69 1,169,600 0%1,169,600
Trust & RLF Funds 15,16,19,21,22,90,91 554,600 18,758 3%560,600
TOTAL CAPITAL EXPENDITURES 19,340,000 628,415 3%20,530,200
Contingent Operating Expenses 4,403,500 0%4,403,500
Contingent Capital Expenses 2,518,400 0%2,517,200
Internal Transfers Out for Operations 4,613,100 426,166 9%4,616,900
Internal Transfers Out for Capital 6,980,000 62,500 1%8,021,500
TOTAL EXPENDITURES FOR ALL FUNDS 68,912,000 5,687,606 8%71,418,800
CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2020 2 months ending
11/30/2019 Page 2
REVENUES BUDGET ACTUAL 17%FORECAST
OPERATING REVENUES
County Road Tax 890,000 2,136 0%890,000
Federal Grants 844,600 432 0%844,600
Franchise Fees 1,771,400 100,553 6%1,771,400
Fund Balances for Operations 2,163,000 0%2,251,000
Investment Earnings 198,600 43,038 22%198,600
Unrealized Gain (Loss)1,257 0%
Interfund Charges for Services - Overhead 3,381,300 557,716 16%3,381,300
Miscellaneous 543,000 68,188 13%543,000
Operating Contributions 3,214,000 326,926 10%3,245,300
Parks, Recreation, Museums, Arts, Golf 1,365,400 75,849 6%1,366,200
Permits & Licenses 777,300 167,585 22%777,300
Property Tax 5,054,700 12,393 0%5,054,700
State Taxes & Grants 3,700,200 5,938 0%3,700,200
Utility Charges -Water 3,169,300 447,577 14%3,169,300
Utility Charges -Wastewater 7,447,800 876,418 12%7,447,800
Utility Charges -Sanitation 2,299,300 415,889 18%2,299,300
TOTAL OPERATING REVENUES 36,819,900 3,101,895 8%36,940,000
CAPITAL REVENUES
Borrowing - DEQ Water Loan 1,305,300 0%1,305,300
Capital Reserve Fees & Impact Fees 2,116,000 145,226 7%2,125,500
Capital Reserve Carryover Balances 2,978,300 0%2,978,300
Construction Funds 7,382,400 41,208 1%7,382,400
Contributed Capital 1,425,000 4,166 0%1,425,000
Engineering Billings 563,100 0%563,100
Fund Balances for Capital 1,147,100 0%1,145,800
Grants 1,011,800 0%1,011,800
LID Funds 201,000 16,843 8%201,000
Trust Funds 2,019,400 20,028 1%2,019,100
TOTAL CAPITAL REVENUES 20,149,400 227,471 1%20,157,300
Contingent Operating Revenues 0%
Contingent Capital Revenues 0%
Internal Transfers In for Operations 4,587,600 418,299 9%4,591,400
Internal Transfers In for Capital 7,355,100 66,666 1%8,514,800
TOTAL REVENUES ALL FUNDS 68,912,000 3,814,331 6%70,203,500
OPERATIONS SUMMARY
TOTAL OPERATING REVENUES 41,407,500 3,520,194 8%41,531,400
TOTAL OPERATING EXPENDITURES 40,073,600 4,996,691 15%40,349,900
---NET OPERATIONS 1,333,900 -1,476,497 1,181,500
CAPITAL SUMMARY
TOTAL CAPITAL REVENUES 27,504,500 294,137 1%28,672,100
TOTAL CAPITAL EXPENDITURES 28,838,400 690,915 3%31,068,900
---NET CAPITAL TRANSACTIONS -1,333,900 -396,778 -2,396,800
TOTAL ALL REVENUES 68,912,000 3,814,331 6%70,203,500
TOTAL ALL EXPENDITURES 68,912,000 5,687,606 8%71,418,800
NET ALL REVENUES OVER EXPENDITURES 0 -1,873,275 -1,215,300
CITY OF REXBURG CASH & INVESTMENT
FY 2020 BALANCE REPORT
Page 3
BALANCE AS
OF
CASH & INVESTMENTS < 1 YEAR 1-5 YEARS > 5 YEARS 11/30/2019
Bank of Commerce Bank CD 249,009 0.87%249,009
Bank of Commerce Legacy FM 39,646 0.14%39,646
Beehive Credit Union CD 250,152 0.87%250,152
Cash On Hand 1,050 0.00%1,050
City Golf Cart CD 91,920 0.32%91,920
Idaho Central Credit Union CD 250,000 0.87%250,000
Idaho Central Credit Union Savings 25 0.00%25
Key Bank Checking (RLF)343,905 1.20%343,905
Moreton Asset Management 1,984,956 3,221,775 18.21%5,206,731
Real Estate Investments (Streets)307,085 1.07%307,085
State Diversified Bond Fund 613,393 2,529,026 847,965 13.95%3,990,384
State LGIP--City 9,296,364 558,421 34.46%9,854,785
State LGIP--Fire District 578,304 34,738 2.14%613,042
Wells Fargo Drug Fund Checking 14,416 0.05%14,416
Wells Fargo Fire District Banking 406,122 1.42%406,122
Zions Bank Capital Advisors 4,008,347 1,117,917 17.93%5,126,264
Zions Bank Collateralized Acct 675,784 2.36%675,784
Zions Bank General Checking 818,318 2.86%818,318
Zions Bank Payroll Checking 357,826 1.25%357,826
TOTAL 20,286,622 7,461,877 847,965 100%28,596,464
% OF TOTAL PORTFOLIO 70.9%26.1%3.0%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