HomeMy WebLinkAboutBudget Summary Report - Jul 2019CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2019 10 months ending
7/31/2019 Page 1
EXPENDITURES BUDGET ACTUAL 83%FORECAST
OPERATING EXPENDITURES
Misc. Departments/Categories
Arts 604,600 463,093 77%645,400
Building Safety 995,400 827,303 83%958,800
Customer Services 298,300 237,691 80%291,800
Economic Development 408,100 345,306 85%411,700
Emergency Services 4,215,300 3,297,355 78%4,133,200
Financial Management 855,300 660,284 77%842,700
GIS 433,600 326,120 75%400,000
Golf Courses 738,800 546,282 74%837,100
Human Resources 134,800 114,665 85%134,700
Information Technology 675,600 535,302 79%663,200
Legacy Flight Museum 91,600 49,039 54%85,700
Legal Services 248,200 202,064 81%244,600
Mayor, Council & Mayor's Youth Advisory Board 330,600 261,503 79%307,700
Miscellaneous 44,800 33,428 75%51,600
Parks & Ball Diamonds 743,000 540,652 73%756,500
Planning & Zoning 345,000 212,866 62%300,600
Recreation Administration & Programs 453,300 406,288 90%477,800
Rexburg Rapids 479,800 310,302 65%485,600
Total Misc. Departments/Categories 12,096,100 9,369,543 77%12,028,700
Police Department
Administration Division & Fund 09 1,353,100 978,663 72%1,309,000
Patrol Division & Funds 13 2,202,400 1,847,536 84%2,382,800
Investigations Division 692,300 607,449 88%750,900
Community Services Division & Funds 08,11,14 679,800 562,757 83%731,800
Total Police Department 4,927,600 3,996,405 81%5,174,500
Public Works
Building Maintenance 47,800 45,009 94%56,300
Shop 629,600 469,758 75%626,300
Sanitation 2,196,300 1,888,560 86%2,217,800
Water 3,021,900 2,260,517 75%2,776,600
Wastewater - Treatment 3,063,500 2,490,563 81%2,953,800
Wastewater - Collections 1,641,500 1,372,909 84%1,631,900
Street Operations 2,513,200 1,685,489 67%2,617,300
Street Repair Contracts 2,013,900 1,437,437 71%2,657,300
Total Public Works 15,127,700 11,650,242 77%15,537,300
TOTAL OPERATING EXPENDITURES 32,151,400 25,016,190 78%32,740,500
CAPITAL EXPENDITURES
Engineering 575,200 441,836 77%558,500
Construction 06,30,31,32,39,41,42,44,46,49,51-58,82,84,85 7,803,700 3,772,982 48%6,709,500
Contributed Capital Offset 1,675,000 0%1,650,000
Capital Reserve Funds 07,18,20,33,34,35,38 896,100 463,124 52%714,400
LID Debt Service Funds 59-69 1,073,400 123,498 12%242,100
Trust & RLF Funds 15,16,19,21,22,90,91 217,300 33,672 15%120,400
TOTAL CAPITAL EXPENDITURES 12,240,700 4,835,112 40%9,994,900
Contingent Operating Expenses 2,476,400 0%
Contingent Capital Expenses 6,497,400 0%
Internal Transfers Out for Operations 4,550,100 634,250 14%4,116,000
Internal Transfers Out for Capital 6,747,600 905,000 13%6,716,400
TOTAL EXPENDITURES FOR ALL FUNDS 64,663,600 31,390,552 49%53,567,800
CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2019 10 months ending
7/31/2019 Page 2
REVENUES BUDGET ACTUAL 83%FORECAST
OPERATING REVENUES
County Road Tax 830,000 884,365 107%885,000
Federal Grants 557,100 163,577 29%476,500
Franchise Fees 1,826,600 1,347,395 74%1,765,800
Fund Balances for Operations 3,221,200 0%4,217,900
Investment Earnings 147,200 180,108 122%191,100
Unrealized Gain (Loss)145,097 0%
Interfund Charges for Services - Overhead 3,402,300 2,789,416 82%3,358,000
Miscellaneous 910,200 627,314 69%726,400
Operating Contributions 3,277,700 2,412,660 74%3,211,400
Parks, Recreation, Museums, Arts, Golf 1,321,200 1,064,358 81%1,440,900
Permits & Licenses 855,200 688,958 81%795,200
Property Tax 4,817,300 4,744,796 98%4,817,300
State Taxes & Grants 3,772,600 2,974,555 79%3,892,600
Utility Charges -Water 2,952,500 2,574,192 87%3,114,900
Utility Charges -Wastewater 5,169,800 4,251,426 82%5,071,300
Utility Charges -Sanitation 2,235,000 2,103,176 94%2,435,100
TOTAL OPERATING REVENUES 35,295,900 26,951,393 76%36,399,400
CAPITAL REVENUES
Borrowing - DEQ Water Loan 2,131,000 2,624,564 123%
Capital Reserve Fees & Impact Fees 2,071,800 2,110,564 102%2,413,900
Capital Reserve Carryover Balances 4,382,200 0%5,545,100
Construction Funds 4,425,000 1,033,123 23%2,579,200
Contributed Capital 1,430,000 0%1,466,700
Engineering Billings 574,500 0%577,800
Fund Balances for Capital 510,900 0%1,024,900
Grants 345,800 0%555,500
LID Funds 300,000 152,502 51%663,100
Trust Funds 1,886,600 912,056 48%1,844,600
TOTAL CAPITAL REVENUES 18,057,800 6,832,809 38%16,670,800
Contingent Operating Revenues 0%
Contingent Capital Revenues 0%
Internal Transfers In for Operations 4,492,900 634,250 14%4,096,900
Internal Transfers In for Capital 6,817,000 905,000 13%6,877,500
TOTAL REVENUES ALL FUNDS 64,663,600 35,323,452 55%64,044,600
OPERATIONS SUMMARY
TOTAL OPERATING REVENUES 39,788,800 27,585,643 76%40,496,300
TOTAL OPERATING EXPENDITURES 39,177,900 25,650,440 78%36,856,500
---NET OPERATIONS 610,900 1,935,203 3,639,800
CAPITAL SUMMARY
TOTAL CAPITAL REVENUES 24,874,800 7,737,809 38%23,548,300
TOTAL CAPITAL EXPENDITURES 25,485,700 5,740,112 40%16,711,300
---NET CAPITAL TRANSACTIONS -610,900 1,997,697 6,837,000
TOTAL ALL REVENUES 64,663,600 35,323,452 55%64,044,600
TOTAL ALL EXPENDITURES 64,663,600 31,390,552 49%53,567,800
NET ALL REVENUES OVER EXPENDITURES 0 3,932,900 10,476,800
CITY OF REXBURG CASH & INVESTMENT
FY 2019 BALANCE REPORT
Page 3
BALANCE AS
OF
CASH & INVESTMENTS < 1 YEAR 1-5 YEARS > 5 YEARS
Bank of Commerce Legacy FM 249,009 0.76%249,009
Bank of Commerce Bank CD 36,054 0.11%36,054
Beehive Credit Union CD 250,152 0.76%250,152
Cash On Hand 4,850 0.01%4,850
City Golf Cart CD 91,920 0.28%91,920
Idaho Central Credit Union CD 250,000 0.76%250,000
Idaho Central Credit Union Savings 25 0.00%25
Key Bank Checking (RLF)395,949 1.21%395,949
Moreton Asset Management 2,291,521 2,840,071 15.66%5,131,592
Real Estate Investments (Streets)307,085 0.94%307,085
State Diversified Bond Fund 1,213,149 5,001,828 1,677,079 24.09%7,892,056
State LGIP--City 4,366,139 262,269 14.13%4,628,408
State LGIP--Fire District 575,913 34,594 1.86%610,507
Wells Fargo Drug Fund Checking 14,915 0.05%14,915
Wells Fargo Fire District Banking 372,852 1.14%372,852
Zions Bank Capital Advisors 3,075,126 2,009,093 15.52%5,084,219
Zions Bank Collateralized Acct 7,000,981 21.37%7,000,981
Zions Bank General Checking 426,395 1.30%426,395
Zions Bank Payroll Checking 20,000 0.06%20,000
TOTAL 20,942,035 10,147,855 1,677,079 100%32,766,969
% OF TOTAL PORTFOLIO 63.9%31.0%5.1%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