HomeMy WebLinkAboutBudget Summary ReportCITY OF REXBURG BUDGET SUMMARY REPORT
FY 2019 2 months ending
11/30/2018 Page 1
EXPENDITURES BUDGET ACTUAL 17%FORECAST
OPERATING EXPENDITURES
Arts 524,400 59,807 11%524,400
Building Safety 995,400 160,202 16%995,400
Customer Services 298,300 48,068 16%298,300
Economic Development 403,100 89,632 22%410,700
Emergency Services 4,170,300 720,388 17%4,200,400
Financial Management 855,300 146,091 17%855,300
GIS 433,600 55,588 13%433,600
Golf Courses 678,800 109,467 16%699,600
Human Resources 134,800 21,975 16%134,800
Information Technology 675,600 96,337 14%675,600
Legacy Flight Museum 91,600 3,544 4%91,600
Legal Services 248,200 49,334 20%248,200
Mayor, Council & Mayor's Youth Advisory Board 326,100 56,283 17%326,100
Miscellaneous 44,800 10,929 24%45,000
Parks & Ball Diamonds 673,600 85,103 13%673,600
Planning & Zoning 345,000 56,344 16%345,000
Recreation Administration & Programs 453,300 73,700 16%469,400
Rexburg Rapids 479,800 16,984 4%479,800
Police Department
Administration Division & Fund 09 1,353,100 168,539 12%1,365,100
Patrol Division & Funds 13 2,202,400 360,939 16%2,202,400
Investigations Division 687,600 113,530 17%687,600
Community Services Division & Funds 08,11,14 679,800 97,831 14%679,800
Total Police Department 4,922,900 740,839 15%4,934,900
Public Works
Building Maintenance 47,800 8,999 19%47,800
Shop 629,600 90,307 14%629,600
Sanitation 2,196,300 356,677 16%2,196,300
Water 3,021,900 448,108 15%3,021,900
Wastewater - Treatment 3,063,500 465,197 15%3,063,500
Wastewater - Collections 1,641,500 279,270 17%1,641,500
Street Operations 2,438,200 289,126 12%2,438,200
Street Repair Contracts 778,000 452,751 58%1,278,000
Total Public Works 13,816,800 2,390,435 17%14,316,800
TOTAL OPERATING EXPENDITURES 30,571,700 4,991,050 16%31,158,500
CAPITAL EXPENDITURES
Engineering 575,200 87,943 15%575,200
Construction 06,30,31,32,39,41,42,44,46,49,51-58,82,84,85 8,658,000 777,507 9%12,199,700
Contributed Capital Offset 1,675,000 0%1,675,000
Capital Reserve Funds 07,18,20,33,34,35,38 715,400 3,484 0%761,400
LID Debt Service Funds 59-69 1,073,400 0%1,073,400
Trust & RLF Funds 15,16,19,21,22,90,91 217,300 4,992 2%175,000
TOTAL CAPITAL EXPENDITURES 12,914,300 873,926 7%16,459,700
Contingent Operating Expenses 5,079,800 0%5,079,800
Contingent Capital Expenses 4,957,400 0%4,819,300
Internal Transfers Out for Operations 4,503,000 4,850 0%3,008,000
Internal Transfers Out for Capital 4,811,900 0%6,311,900
TOTAL EXPENDITURES FOR ALL FUNDS 62,838,100 5,869,826 9%66,837,200
CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2019 2 months ending
11/30/2018 Page 2
REVENUES BUDGET ACTUAL 17%FORECAST
OPERATING REVENUES
County Road Tax 830,000 736 0%830,000
Federal Grants 552,400 0%584,400
Franchise Fees 1,826,600 100,740 6%1,826,600
Fund Balances for Operations 3,191,100 0%3,185,500
Investment Earnings 147,200 27,600 19%147,200
Unrealized Gain (Loss)-49,108 0%
Interfund Charges for Services 3,402,300 560,383 16%3,402,300
Miscellaneous 878,400 73,203 8%883,400
Operating Contributions 3,188,500 160,802 5%3,165,600
Parks, Recreation, Museums, Arts, Golf 1,310,200 103,600 8%1,311,200
Permits & Licenses 855,200 130,510 15%855,200
Property Tax 4,817,300 9,685 0%4,817,300
State Taxes & Grants 3,032,600 -52,587 -2%3,032,600
Utility Charges -Water 2,952,500 491,900 17%2,952,500
Utility Charges -Wastewater 6,329,800 831,297 13%6,329,800
Utility Charges -Sanitation 2,235,000 408,717 18%2,235,000
TOTAL OPERATING REVENUES 35,549,100 2,797,478 8%35,558,600
CAPITAL REVENUES
Borrowing 905,000 819,752 91%905,000
Capital Reserve Fees & Impact Fees 2,071,800 235,299 11%2,071,800
Capital Reserve Carryover Balances 4,201,500 0%4,201,500
Construction Funds 5,675,000 39,064 1%7,663,900
Contributed Capital 1,469,100 0%1,469,100
Engineering Billings 574,500 0%574,500
Fund Balances for Capital 510,900 0%519,200
Grants 345,800 0%345,800
LID Funds 300,000 54,480 18%300,000
Trust Funds 1,886,600 1,463 0%1,886,600
TOTAL CAPITAL REVENUES 17,940,200 1,150,058 6%19,937,400
Contingent Operating Revenues 0%
Contingent Capital Revenues 0%
Internal Transfers In for Operations 4,467,500 164,850 4%2,972,500
Internal Transfers In for Capital 4,881,300 105,000 2%6,381,300
TOTAL REVENUES ALL FUNDS 62,838,100 4,217,386 7%64,849,800
OPERATIONS SUMMARY
TOTAL OPERATING REVENUES 40,016,600 2,962,328 8%38,531,100
TOTAL OPERATING EXPENDITURES 40,154,500 4,995,900 16%39,246,300
---NET OPERATIONS -137,900 -2,033,572 -715,200
CAPITAL SUMMARY
TOTAL CAPITAL REVENUES 22,821,500 1,255,058 6%26,318,700
TOTAL CAPITAL EXPENDITURES 22,683,600 873,926 7%27,590,900
---NET CAPITAL TRANSACTIONS 137,900 381,132 -1,272,200
TOTAL ALL REVENUES 62,838,100 4,217,386 7%64,849,800
TOTAL ALL EXPENDITURES 62,838,100 5,869,826 9%66,837,200
NET ALL REVENUES OVER EXPENDITURES 0 -1,652,440 -1,987,400
CITY OF REXBURG CASH & INVESTMENT
FY 2019 BALANCE REPORT
Page 3
BALANCE AS
OF
CASH & INVESTMENTS < 1 YEAR 1-5 YEARS > 5 YEARS 11/30/2018
Bank of Commerce Legacy FM 31,601 0.13%31,601
Beehive Credit Union CD 250,000 1.04%250,000
Cash On Hand 1,050 0.00%1,050
Citizens Community Bank CDARS 753,060 3.13%753,060
City Golf Cart CD 114,900 0.48%114,900
Idaho Central Credit Union CD 250,000 1.04%250,000
Idaho Central Credit Union Savings 25 0.00%25
Key Bank Checking (RLF)312,217 1.30%312,217
Moreton Asset Management 1,472,949 2,253,496 15.50%3,726,445
Real Estate Investments (Streets)307,085 1.28%307,085
State Diversified Bond Fund 646,312 4,661,785 2,245,395 31.41%7,553,492
State LGIP--City 4,915,501 647,272 23.14%5,562,773
State LGIP--Fire District 394 52 0.00%446
Wells Fargo Drug Fund Checking 15,418 0.06%15,418
Wells Fargo Fire District Banking 528,743 2.20%528,743
Zions Bank Capital Advisors 1,037,209 2,178,317 13.37%3,215,526
Zions Bank Collateralized Acct 455,600 1.89%455,600
Zions Bank General Checking 915,637 3.81%915,637
Zions Bank Payroll Checking 50,357 0.21%50,357
TOTAL 12,058,058 9,740,922 2,245,395 100%24,044,375
% OF TOTAL PORTFOLIO 50.1%40.5%9.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