HomeMy WebLinkAboutBudget Summary Report - Jun 2020CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2020 9 months ending
6/30/2020 Page 1
EXPENDITURES BUDGET ACTUAL 75%FORECAST
OPERATING EXPENDITURES
Misc. Departments/Categories
Arts 733,000 215,701 29%660,400
Building Safety 839,600 599,298 71%795,200
Customer Services 316,200 241,126 76%314,200
Economic Development 362,800 266,744 74%341,200
Emergency Services 4,634,200 2,831,915 61%4,414,000
Financial Management 894,400 633,850 71%853,300
GIS 427,400 308,918 72%411,400
Golf Courses 830,300 480,943 58%853,900
Human Resources 145,100 107,484 74%141,600
Information Technology 695,600 515,564 74%687,100
Legacy Flight Museum 117,900 46,004 39%96,000
Legal Services 273,000 202,527 74%277,700
Mayor, Council & Mayor's Youth Advisory Board 328,100 265,876 81%344,700
Miscellaneous 49,300 24,001 49%49,300
Parks & Ball Diamonds 762,200 483,369 63%749,200
Planning & Zoning 385,400 254,771 66%355,900
Recreation Administration & Programs 551,900 360,314 65%513,700
Rexburg Rapids 726,200 350,582 48%645,100
Total Misc. Departments/Categories 13,072,600 8,188,987 63%12,503,900
Police Department
Administration Division & Fund 09 1,452,500 1,054,728 73%1,420,800
Patrol Division & Funds 13 2,279,800 1,630,822 72%2,249,800
Investigations Division 793,900 596,453 75%796,100
Community Services Division & Funds 08,11,14 731,800 522,281 71%721,100
Total Police Department 5,258,000 3,804,284 72%5,187,800
Public Works
Building Maintenance 52,800 32,256 61%50,300
Shop 610,700 444,379 73%616,400
Sanitation 2,266,500 1,601,832 71%2,309,500
Water 3,039,100 2,043,671 67%3,098,100
Wastewater - Treatment 2,976,900 2,324,004 78%3,128,600
Wastewater - Collections 1,737,200 1,273,009 73%1,627,600
Street Operations 2,739,700 2,006,305 73%2,753,600
Total Public Works 13,422,900 9,725,456 72%13,584,100
TOTAL OPERATING EXPENDITURES 31,753,500 21,718,727 68%31,275,800
CAPITAL EXPENDITURES
Engineering 563,800 417,787 74%567,100
Street Repair Contracts 150,400 227,800 151%609,300
Construction 06,30,31,32,39,41,42,44,46,49,51-58,82,84,85 16,666,400 4,526,344 27%9,990,900
Contributed Capital Offset 1,675,000 18,749 1%1,175,000
Capital Reserve Funds 07,18,20,33,34,35,38 702,800 269,369 38%502,800
LID Debt Service Funds 59-69 1,169,600 57,983 5%250,100
Trust & RLF Funds 15,16,19,21,22,90,91 629,900 117,830 19%150,100
TOTAL CAPITAL EXPENDITURES 21,557,900 5,635,862 26%13,245,300
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,210,166 48%4,492,300
Internal Transfers Out for Capital 7,832,300 319,583 4%6,094,000
TOTAL EXPENDITURES FOR ALL FUNDS 72,292,000 29,884,338 41%55,145,400
CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2020 9 months ending
6/30/2020 Page 2
REVENUES BUDGET ACTUAL 75%FORECAST
OPERATING REVENUES
County Road Tax 890,000 537,250 60%870,000
Federal Grants 844,600 54,374 6%634,000
Franchise Fees 1,771,400 1,072,947 61%1,754,100
Fund Balances for Operations 2,623,400 0%2,681,200
Investment Earnings 198,600 87,657 44%147,700
Unrealized Gain (Loss)92,358 0%
Interfund Charges for Services - Overhead 3,381,300 2,507,775 74%3,384,000
Miscellaneous 543,000 375,724 69%504,500
Operating Contributions 3,283,900 2,445,908 74%3,207,600
Parks, Recreation, Museums, Arts, Golf 1,392,600 701,313 50%1,241,200
Permits & Licenses 786,600 830,276 106%849,200
Property Tax 5,054,700 3,465,180 69%5,054,700
State Taxes & Grants 3,900,200 1,841,785 47%3,917,900
Utility Charges -Water 3,169,300 2,169,103 68%3,195,000
Utility Charges -Wastewater 5,127,800 3,814,815 74%5,126,000
Utility Charges -Sanitation 2,299,300 1,910,704 83%2,424,300
TOTAL OPERATING REVENUES 35,266,700 21,907,169 62%34,991,400
CAPITAL REVENUES
Borrowing - DEQ Water Loan 2,287,300 2,603,753 114%
Capital Reserve Fees & Impact Fees 2,125,500 2,384,756 112%2,583,400
Capital Reserve Carryover Balances 2,407,200 0%5,500,200
Construction Funds 6,890,600 478,625 7%3,187,400
Contributed Capital 1,425,000 18,749 1%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,389,800
LID Funds 201,000 24,630 12%256,800
Trust Funds 2,019,400 680,472 34%2,024,800
TOTAL CAPITAL REVENUES 24,242,300 6,190,985 26%22,122,700
Contingent Operating Revenues 0%
Contingent Capital Revenues 0%
Internal Transfers In for Operations 4,554,900 2,199,374 48%4,460,900
Internal Transfers In for Capital 8,228,100 329,999 4%6,518,800
TOTAL REVENUES ALL FUNDS 72,292,000 30,627,527 42%68,093,800
OPERATIONS SUMMARY
TOTAL OPERATING REVENUES 39,821,600 24,106,543 62%39,452,300
TOTAL OPERATING EXPENDITURES 40,546,000 23,928,893 68%35,780,200
---NET OPERATIONS -724,400 177,650 3,672,100
CAPITAL SUMMARY
TOTAL CAPITAL REVENUES 32,470,400 6,520,984 26%28,641,500
TOTAL CAPITAL EXPENDITURES 31,746,000 5,955,445 26%19,365,200
---NET CAPITAL TRANSACTIONS 724,400 565,539 9,276,300
TOTAL ALL REVENUES 72,292,000 30,627,527 42%68,093,800
TOTAL ALL EXPENDITURES 72,292,000 29,884,338 41%55,145,400
NET ALL REVENUES OVER EXPENDITURES 0 743,189 12,948,400
CITY OF REXBURG CASH & INVESTMENT
FY 2020 BALANCE REPORT
Page 3
BALANCE AS
OF
CASH & INVESTMENTS < 1 YEAR 1-5 YEARS > 5 YEARS 6/30/2020
Bank of Commerce Bank CD 254,165 0.79%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 4,950 0.02%4,950
City Golf Cart CD 68,940 0.21%68,940
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)386,664 1.20%386,664
Moreton Asset Management 2,457,893 2,901,083 16.57%5,358,976
Mountain America Credit Union 250,000 0.77%250,000
Real Estate Investments (Streets)324,863 1.00%324,863
State Diversified Bond Fund 1,204,797 2,173,696 765,459 12.81%4,143,952
State LGIP--City 6,508,143 233,173 20.84%6,741,316
State LGIP--Fire District 600,145 21,502 1.92%621,647
TVI - Bond Investment 450,000 2,540,016 9.25%2,990,016
Wells Fargo Drug Fund Checking 14,418 0.04%14,418
Wells Fargo Fire District Banking 558,801 1.73%558,801
Westmark CD 251,212 0.78%251,212
Zions Bank Capital Advisors 3,300,846 1,877,985 16.01%5,178,831
Zions Bank Collateralized Acct 3,715,927 11.49%3,715,927
Zions Bank General Checking 665,948 2.06%665,948
Zions Bank Payroll Checking 19,671 0.06%19,671
TOTAL 21,829,032 9,747,455 765,459 100%32,341,946
% OF TOTAL PORTFOLIO 67.5%30.1%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