HomeMy WebLinkAboutBudget Summary Report - Mar 2020CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2020 6 months ending
3/31/2020 Page 1
EXPENDITURES BUDGET ACTUAL 50%FORECAST
OPERATING EXPENDITURES
Misc. Departments/Categories
Arts 645,400 170,509 26%657,100
Building Safety 839,600 407,703 49%796,100
Customer Services 316,200 165,556 52%318,600
Economic Development 396,400 196,010 49%327,300
Emergency Services 4,634,200 1,887,261 41%4,419,500
Financial Management 894,400 459,339 51%868,100
GIS 427,400 219,217 51%414,800
Golf Courses 813,200 260,946 32%851,400
Human Resources 145,100 71,124 49%144,700
Information Technology 695,600 363,444 52%695,700
Legacy Flight Museum 117,900 18,424 16%96,500
Legal Services 273,000 140,777 52%277,000
Mayor, Council & Mayor's Youth Advisory Board 328,100 165,980 51%330,900
Miscellaneous 49,300 12,337 25%45,200
Parks & Ball Diamonds 732,800 263,010 36%752,800
Planning & Zoning 385,400 177,103 46%347,200
Recreation Administration & Programs 547,600 261,649 48%521,800
Rexburg Rapids 726,200 266,309 37%656,900
Total Misc. Departments/Categories 12,967,800 5,506,698 42%12,521,600
Police Department
Administration Division & Fund 09 1,363,500 675,258 50%1,472,100
Patrol Division & Funds 13 2,385,800 1,093,212 46%2,316,700
Investigations Division 750,900 405,610 54%779,500
Community Services Division & Funds 08,11,14 731,800 359,011 49%729,800
Total Police Department 5,232,000 2,533,091 48%5,298,100
Public Works
Building Maintenance 52,800 22,047 42%49,700
Shop 610,700 324,121 53%573,000
Sanitation 2,266,500 1,042,277 46%2,267,300
Water 3,039,100 1,374,205 45%3,084,700
Wastewater - Treatment 2,976,900 1,526,056 51%3,029,300
Wastewater - Collections 1,735,400 848,044 49%1,600,600
Street Operations 2,669,700 1,223,166 46%2,760,100
Total Public Works 13,351,100 6,359,916 48%13,364,700
TOTAL OPERATING EXPENDITURES 31,550,900 14,399,705 46%31,184,400
CAPITAL EXPENDITURES
Engineering 563,800 282,995 50%557,500
Street Repair Contracts 150,400 184,725 123%495,500
Construction 06,30,31,32,39,41,42,44,46,49,51-58,82,84,85 14,776,500 3,124,601 21%11,836,900
Contributed Capital Offset 1,675,000 12,499 1%1,675,000
Capital Reserve Funds 07,18,20,33,34,35,38 627,200 169,539 27%494,200
LID Debt Service Funds 59-69 1,169,600 78,754 7%1,174,600
Trust & RLF Funds 15,16,19,21,22,90,91 554,600 52,950 10%618,200
TOTAL CAPITAL EXPENDITURES 19,517,100 3,906,063 20%16,851,900
Contingent Operating Expenses 4,136,600 0%51,500
Contingent Capital Expenses 2,269,400 0%
Internal Transfers Out for Operations 4,385,300 1,253,099 29%4,489,600
Internal Transfers Out for Capital 6,180,000 187,500 3%6,448,500
TOTAL EXPENDITURES FOR ALL FUNDS 68,039,300 19,746,367 29%59,025,900
CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2020 6 months ending
3/31/2020 Page 2
REVENUES BUDGET ACTUAL 50%FORECAST
OPERATING REVENUES
County Road Tax 890,000 489,086 55%870,000
Federal Grants 844,600 47,405 6%622,600
Franchise Fees 1,771,400 597,139 34%1,757,700
Fund Balances for Operations 2,246,600 0%2,681,200
Investment Earnings 198,600 72,723 37%183,100
Unrealized Gain (Loss)-24,463 0%
Interfund Charges for Services - Overhead 3,381,300 1,671,850 49%3,380,000
Miscellaneous 543,000 304,478 56%525,100
Operating Contributions 3,234,300 1,512,619 47%3,189,000
Parks, Recreation, Museums, Arts, Golf 1,380,600 202,624 15%1,295,600
Permits & Licenses 786,600 481,198 61%849,500
Property Tax 5,054,700 3,155,255 62%5,054,700
State Taxes & Grants 3,700,200 1,043,710 28%3,812,600
Utility Charges -Water 3,169,300 1,289,925 41%3,100,000
Utility Charges -Wastewater 5,127,800 2,601,583 51%5,196,000
Utility Charges -Sanitation 2,299,300 1,264,747 55%2,461,300
TOTAL OPERATING REVENUES 34,628,300 14,709,879 42%34,978,400
CAPITAL REVENUES
Borrowing - DEQ Water Loan 1,305,300 575,237 44%
Capital Reserve Fees & Impact Fees 2,125,500 1,346,808 63%2,447,000
Capital Reserve Carryover Balances 2,195,500 0%5,500,200
Construction Funds 7,382,400 129,147 2%4,415,000
Contributed Capital 1,425,000 12,499 1%1,425,000
Engineering Billings 563,100 0%563,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,067 12%196,800
Trust Funds 2,019,400 621,318 31%2,028,900
TOTAL CAPITAL REVENUES 21,696,100 2,709,076 12%20,390,000
Contingent Operating Revenues 0%
Contingent Capital Revenues 0%
Internal Transfers In for Operations 4,359,800 1,579,199 36%4,464,100
Internal Transfers In for Capital 7,355,100 304,999 4%6,819,300
TOTAL REVENUES ALL FUNDS 68,039,300 19,303,153 28%66,651,800
OPERATIONS SUMMARY
TOTAL OPERATING REVENUES 38,988,100 16,289,078 42%39,442,500
TOTAL OPERATING EXPENDITURES 40,072,800 15,652,804 46%35,725,500
---NET OPERATIONS -1,084,700 636,274 3,717,000
CAPITAL SUMMARY
TOTAL CAPITAL REVENUES 29,051,200 3,014,075 12%27,209,300
TOTAL CAPITAL EXPENDITURES 27,966,500 4,093,563 20%23,300,400
---NET CAPITAL TRANSACTIONS 1,084,700 -1,079,488 3,908,900
TOTAL ALL REVENUES 68,039,300 19,303,153 28%66,651,800
TOTAL ALL EXPENDITURES 68,039,300 19,746,367 29%59,025,900
NET ALL REVENUES OVER EXPENDITURES 0 -443,214 7,625,900
CITY OF REXBURG CASH & INVESTMENT
FY 2020 BALANCE REPORT
Page 3
BALANCE AS
OF
CASH & INVESTMENTS < 1 YEAR 1-5 YEARS > 5 YEARS 3/31/2020
Bank of Commerce Bank CD 254,165 0.79%254,165
Bank of Commerce Legacy FM 42,003 0.13%42,003
Beehive Credit Union CD 250,152 0.78%250,152
Cash On Hand 2,550 0.01%2,550
City Golf Cart CD 91,920 0.29%91,920
East Idaho CU CD 250,000 0.78%250,000
Idaho Central Credit Union CD 250,000 0.78%250,000
Idaho Central Credit Union Savings 25 0.00%25
Key Bank Checking (RLF)369,671 1.15%369,671
Moreton Asset Management 2,243,965 2,992,537 16.30%5,236,502
Real Estate Investments (Streets)324,863 1.01%324,863
State Diversified Bond Fund 1,184,244 2,136,612 752,400 12.68%4,073,256
State LGIP--City 5,861,617 210,009 18.90%6,071,626
State LGIP--Fire District 596,101 21,357 1.92%617,458
TVI - Bond Investment 0 2,990,016 9.31%2,990,016
Wells Fargo Drug Fund Checking 14,416 0.04%14,416
Wells Fargo Fire District Banking 959,594 2.99%959,594
Westmark CD 249,985 0.78%249,985
Zions Bank Capital Advisors 3,259,992 1,880,635 16.00%5,140,627
Zions Bank Collateralized Acct 3,465,979 10.79%3,465,979
Zions Bank General Checking 1,446,518 4.50%1,446,518
Zions Bank Payroll Checking 19,997 0.06%19,997
TOTAL 21,137,757 10,231,166 752,400 100%32,121,323
% OF TOTAL PORTFOLIO 65.8%31.9%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