HomeMy WebLinkAboutBudget Summary Report - Jan 2020CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2020 4 months ending
1/31/2020 Page 1
EXPENDITURES BUDGET ACTUAL 33%FORECAST
OPERATING EXPENDITURES
Misc. Departments/Categories
Arts 645,400 112,011 17%644,800
Building Safety 839,600 275,182 33%839,600
Customer Services 316,200 115,738 37%306,900
Economic Development 396,400 150,239 38%399,900
Emergency Services 4,634,200 1,289,754 28%4,634,200
Financial Management 894,400 330,992 37%895,800
GIS 427,400 157,849 37%427,400
Golf Courses 813,200 203,776 25%853,700
Human Resources 145,100 47,676 33%141,600
Information Technology 695,600 212,663 31%705,600
Legacy Flight Museum 117,900 7,575 6%118,300
Legal Services 273,000 86,986 32%273,000
Mayor, Council & Mayor's Youth Advisory Board 328,100 113,819 35%329,300
Miscellaneous 49,300 7,699 16%49,600
Parks & Ball Diamonds 732,800 193,666 26%730,300
Planning & Zoning 385,400 115,133 30%385,400
Recreation Administration & Programs 547,600 168,771 31%506,400
Rexburg Rapids 726,200 231,996 32%638,200
Total Misc. Departments/Categories 12,967,800 3,821,525 29%12,880,000
Police Department
Administration Division & Fund 09 1,363,500 439,591 32%1,309,000
Patrol Division & Funds 13 2,385,800 719,812 30%2,382,800
Investigations Division 750,900 275,282 37%750,900
Community Services Division & Funds 08,11,14 731,800 228,614 31%729,900
Total Police Department 5,232,000 1,663,299 32%5,172,600
Public Works
Building Maintenance 52,800 15,247 29%52,800
Shop 610,700 176,816 29%610,700
Sanitation 2,266,500 687,862 30%2,266,500
Water 3,039,100 908,990 30%3,039,100
Wastewater - Treatment 2,976,900 1,062,666 36%2,976,900
Wastewater - Collections 1,735,400 568,787 33%1,735,400
Street Operations 2,669,700 852,721 32%2,397,700
Total Public Works 13,351,100 4,273,089 32%13,079,100
TOTAL OPERATING EXPENDITURES 31,550,900 9,757,913 31%31,131,700
CAPITAL EXPENDITURES
Engineering 563,800 189,464 34%563,800
Street Repair Contracts 150,400 184,725 123%403,800
Construction 06,30,31,32,39,41,42,44,46,49,51-58,82,84,85 14,776,500 2,156,205 15%16,808,700
Contributed Capital Offset 1,675,000 8,333 0%1,675,000
Capital Reserve Funds 07,18,20,33,34,35,38 627,200 123,693 20%564,200
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 47,134 8%596,900
TOTAL CAPITAL EXPENDITURES 19,517,100 2,709,554 14%21,782,000
Contingent Operating Expenses 4,136,600 0%4,328,200
Contingent Capital Expenses 2,269,400 0%2,415,000
Internal Transfers Out for Operations 4,385,300 835,399 19%4,616,900
Internal Transfers Out for Capital 6,180,000 125,000 2%8,208,900
TOTAL EXPENDITURES FOR ALL FUNDS 68,039,300 13,427,866 20%72,482,700
CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2020 4 months ending
1/31/2020 Page 2
REVENUES BUDGET ACTUAL 33%FORECAST
OPERATING REVENUES
County Road Tax 890,000 460,535 52%890,000
Federal Grants 844,600 40,662 5%822,800
Franchise Fees 1,771,400 484,015 27%1,771,500
Fund Balances for Operations 2,246,600 0%3,283,200
Investment Earnings 198,600 53,924 27%198,600
Unrealized Gain (Loss)3,927 0%
Interfund Charges for Services - Overhead 3,381,300 1,114,566 33%3,381,300
Miscellaneous 543,000 176,774 33%542,100
Operating Contributions 3,234,300 513,776 16%3,245,300
Parks, Recreation, Museums, Arts, Golf 1,380,600 130,508 9%1,410,100
Permits & Licenses 786,600 208,400 26%777,300
Property Tax 5,054,700 2,990,062 59%5,054,700
State Taxes & Grants 3,700,200 890,331 24%3,480,100
Utility Charges -Water 3,169,300 872,796 28%3,169,300
Utility Charges -Wastewater 5,127,800 1,739,307 34%5,127,800
Utility Charges -Sanitation 2,299,300 845,007 37%2,299,300
TOTAL OPERATING REVENUES 34,628,300 10,524,590 30%35,453,400
CAPITAL REVENUES
Borrowing - DEQ Water Loan 1,305,300 575,237 44%1,305,300
Capital Reserve Fees & Impact Fees 2,125,500 469,076 22%2,101,500
Capital Reserve Carryover Balances 2,195,500 0%5,500,200
Construction Funds 7,382,400 86,611 1%7,809,600
Contributed Capital 1,425,000 8,333 1%1,425,000
Engineering Billings 563,100 0%563,100
Fund Balances for Capital 1,147,100 0%2,931,500
Grants & Contributions 3,331,800 0%3,438,400
LID Funds 201,000 20,654 10%201,000
Trust Funds 2,019,400 118,550 6%2,097,100
TOTAL CAPITAL REVENUES 21,696,100 1,278,461 6%27,372,700
Contingent Operating Revenues 0%
Contingent Capital Revenues 0%
Internal Transfers In for Operations 4,359,800 826,899 19%4,591,400
Internal Transfers In for Capital 7,355,100 133,333 2%9,202,200
TOTAL REVENUES ALL FUNDS 68,039,300 12,763,283 19%76,619,700
OPERATIONS SUMMARY
TOTAL OPERATING REVENUES 38,988,100 11,351,489 30%40,044,800
TOTAL OPERATING EXPENDITURES 40,072,800 10,593,312 31%40,076,800
---NET OPERATIONS -1,084,700 758,177 -32,000
CAPITAL SUMMARY
TOTAL CAPITAL REVENUES 29,051,200 1,411,794 6%36,574,900
TOTAL CAPITAL EXPENDITURES 27,966,500 2,834,554 14%32,405,900
---NET CAPITAL TRANSACTIONS 1,084,700 -1,422,760 4,169,000
TOTAL ALL REVENUES 68,039,300 12,763,283 19%76,619,700
TOTAL ALL EXPENDITURES 68,039,300 13,427,866 20%72,482,700
NET ALL REVENUES OVER EXPENDITURES 0 -664,583 4,137,000
CITY OF REXBURG CASH & INVESTMENT
FY 2020 BALANCE REPORT
Page 3
BALANCE AS
OF
CASH & INVESTMENTS < 1 YEAR 1-5 YEARS > 5 YEARS 1/31/2020
Bank of Commerce Bank CD 249,009 0.81%249,009
Bank of Commerce Legacy FM 44,677 0.15%44,677
Beehive Credit Union CD 250,152 0.81%250,152
Cash On Hand 1,150 0.00%1,150
City Golf Cart CD 91,920 0.30%91,920
Idaho Central Credit Union CD 250,000 0.81%250,000
Idaho Central Credit Union Savings 25 0.00%25
Key Bank Checking (RLF)356,252 1.16%356,252
Moreton Asset Management 2,234,250 2,992,537 16.99%5,226,787
Real Estate Investments (Streets)324,863 1.06%324,863
State Diversified Bond Fund 1,172,415 2,115,273 744,886 13.11%4,032,574
State LGIP--City 5,845,135 209,418 19.68%6,054,553
State LGIP--Fire District 595,080 21,320 2.00%616,400
TVI - Bond Investment 0 2,990,016 9.72%2,990,016
Wells Fargo Drug Fund Checking 14,416 0.05%14,416
Wells Fargo Fire District Banking 465,755 1.51%465,755
Westmark CD 249,990 0.81%249,990
Zions Bank Capital Advisors 3,264,130 1,880,635 16.72%5,144,765
Zions Bank Collateralized Acct 215,841 0.70%215,841
Zions Bank General Checking 4,166,190 13.54%4,166,190
Zions Bank Payroll Checking 19,997 0.06%19,997
TOTAL 19,811,247 10,209,199 744,886 100%30,765,332
% OF TOTAL PORTFOLIO 64.4%33.2%2.4%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