HomeMy WebLinkAboutBudget Summary Report - Feb 2020CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2020 5 months ending
2/29/2020 Page 1
EXPENDITURES BUDGET ACTUAL 42%FORECAST
OPERATING EXPENDITURES
Misc. Departments/Categories
Arts 645,400 138,818 22%656,300
Building Safety 839,600 340,801 41%802,900
Customer Services 316,200 138,769 44%307,100
Economic Development 396,400 171,492 43%400,100
Emergency Services 4,634,200 1,583,333 34%4,636,700
Financial Management 894,400 389,448 44%896,200
GIS 427,400 187,572 44%427,700
Golf Courses 813,200 227,700 28%853,100
Human Resources 145,100 59,208 41%141,800
Information Technology 695,600 264,808 38%698,200
Legacy Flight Museum 117,900 8,914 8%118,300
Legal Services 273,000 117,103 43%273,100
Mayor, Council & Mayor's Youth Advisory Board 328,100 139,084 42%331,800
Miscellaneous 49,300 10,030 20%49,600
Parks & Ball Diamonds 732,800 216,857 30%734,600
Planning & Zoning 385,400 147,162 38%385,600
Recreation Administration & Programs 547,600 220,942 40%488,500
Rexburg Rapids 726,200 256,654 35%640,200
Total Misc. Departments/Categories 12,967,800 4,618,695 36%12,841,800
Police Department
Administration Division & Fund 09 1,363,500 586,969 43%1,364,300
Patrol Division & Funds 13 2,385,800 896,525 38%2,394,700
Investigations Division 750,900 341,275 45%751,300
Community Services Division & Funds 08,11,14 731,800 282,911 39%730,200
Total Police Department 5,232,000 2,107,680 40%5,240,500
Public Works
Building Maintenance 52,800 18,637 35%52,800
Shop 610,700 216,616 35%613,300
Sanitation 2,266,500 915,805 40%2,266,800
Water 3,039,100 1,114,980 37%3,034,300
Wastewater - Treatment 2,976,900 1,307,010 44%2,976,400
Wastewater - Collections 1,735,400 696,452 40%1,731,500
Street Operations 2,669,700 1,001,096 37%2,901,100
Total Public Works 13,351,100 5,270,596 39%13,576,200
TOTAL OPERATING EXPENDITURES 31,550,900 11,996,971 38%31,658,500
CAPITAL EXPENDITURES
Engineering 563,800 232,820 41%563,800
Street Repair Contracts 150,400 184,725 123%505,500
Construction 06,30,31,32,39,41,42,44,46,49,51-58,82,84,85 14,776,500 2,614,987 18%11,866,700
Contributed Capital Offset 1,675,000 10,416 1%1,675,000
Capital Reserve Funds 07,18,20,33,34,35,38 627,200 169,539 27%578,500
LID Debt Service Funds 59-69 1,169,600 39,054 3%1,169,600
Trust & RLF Funds 15,16,19,21,22,90,91 554,600 48,168 9%623,900
TOTAL CAPITAL EXPENDITURES 19,517,100 3,299,709 17%16,983,000
Contingent Operating Expenses 4,136,600 0%4,148,800
Contingent Capital Expenses 2,269,400 0%1,097,500
Internal Transfers Out for Operations 4,385,300 1,044,249 24%4,434,800
Internal Transfers Out for Capital 6,180,000 156,250 3%6,660,500
TOTAL EXPENDITURES FOR ALL FUNDS 68,039,300 16,497,179 24%64,983,100
CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2020 5 months ending
2/29/2020 Page 2
REVENUES BUDGET ACTUAL 42%FORECAST
OPERATING REVENUES
County Road Tax 890,000 477,428 54%904,000
Federal Grants 844,600 40,662 5%822,800
Franchise Fees 1,771,400 534,149 30%1,771,500
Fund Balances for Operations 2,246,600 0%3,283,200
Investment Earnings 198,600 59,141 30%192,000
Unrealized Gain (Loss)21,305 0%
Interfund Charges for Services - Overhead 3,381,300 1,393,208 41%3,381,300
Miscellaneous 543,000 265,064 49%542,100
Operating Contributions 3,234,300 657,087 20%3,238,300
Parks, Recreation, Museums, Arts, Golf 1,380,600 174,692 13%1,410,400
Permits & Licenses 786,600 269,478 34%804,700
Property Tax 5,054,700 3,098,460 61%5,054,700
State Taxes & Grants 3,700,200 1,042,210 28%3,906,200
Utility Charges -Water 3,169,300 1,088,287 34%3,169,300
Utility Charges -Wastewater 5,127,800 2,174,020 42%5,127,800
Utility Charges -Sanitation 2,299,300 1,056,289 46%2,299,300
TOTAL OPERATING REVENUES 34,628,300 12,351,480 36%35,907,600
CAPITAL REVENUES
Borrowing - DEQ Water Loan 1,305,300 575,237 44%1,305,300
Capital Reserve Fees & Impact Fees 2,125,500 770,775 36%2,101,500
Capital Reserve Carryover Balances 2,195,500 0%5,500,200
Construction Funds 7,382,400 107,873 1%4,589,900
Contributed Capital 1,425,000 10,416 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 24,144 12%201,000
Trust Funds 2,019,400 588,053 29%2,067,100
TOTAL CAPITAL REVENUES 21,696,100 2,076,498 10%24,123,000
Contingent Operating Revenues 0%
Contingent Capital Revenues 0%
Internal Transfers In for Operations 4,359,800 1,033,624 24%4,417,500
Internal Transfers In for Capital 7,355,100 166,666 2%6,753,800
TOTAL REVENUES ALL FUNDS 68,039,300 15,628,268 23%71,201,900
OPERATIONS SUMMARY
TOTAL OPERATING REVENUES 38,988,100 13,385,104 36%40,325,100
TOTAL OPERATING EXPENDITURES 40,072,800 13,041,220 38%40,242,100
---NET OPERATIONS -1,084,700 343,884 83,000
CAPITAL SUMMARY
TOTAL CAPITAL REVENUES 29,051,200 2,243,164 10%30,876,800
TOTAL CAPITAL EXPENDITURES 27,966,500 3,455,959 17%24,741,000
---NET CAPITAL TRANSACTIONS 1,084,700 -1,212,795 6,135,800
TOTAL ALL REVENUES 68,039,300 15,628,268 23%71,201,900
TOTAL ALL EXPENDITURES 68,039,300 16,497,179 24%64,983,100
NET ALL REVENUES OVER EXPENDITURES 0 -868,911 6,218,800
CITY OF REXBURG CASH & INVESTMENT
FY 2020 BALANCE REPORT
Page 3
BALANCE AS
OF
CASH & INVESTMENTS < 1 YEAR 1-5 YEARS > 5 YEARS 2/29/2020
Bank of Commerce Bank CD 249,009 0.81%249,009
Bank of Commerce Legacy FM 44,684 0.15%44,684
Beehive Credit Union CD 250,152 0.81%250,152
Cash On Hand 2,550 0.01%2,550
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)362,969 1.18%362,969
Moreton Asset Management 2,258,387 2,992,537 17.09%5,250,924
Real Estate Investments (Streets)324,863 1.06%324,863
State Diversified Bond Fund 1,183,363 2,135,025 751,841 13.25%4,070,229
State LGIP--City 5,853,492 209,718 19.74%6,063,210
State LGIP--Fire District 596,101 21,357 2.01%617,458
TVI - Bond Investment 0 2,990,016 9.73%2,990,016
Wells Fargo Drug Fund Checking 14,416 0.05%14,416
Wells Fargo Fire District Banking 930,145 3.03%930,145
Westmark CD 249,985 0.81%249,985
Zions Bank Capital Advisors 3,273,370 1,880,635 16.78%5,154,005
Zions Bank Collateralized Acct 2,215,794 7.21%2,215,794
Zions Bank General Checking 1,564,029 5.09%1,564,029
Zions Bank Payroll Checking 20,000 0.07%20,000
TOTAL 19,735,254 10,229,288 751,841 100%30,716,383
% OF TOTAL PORTFOLIO 64.2%33.3%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