HomeMy WebLinkAboutBudget Summary Report - Jan 2019CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2019 4 months ending
1/31/2019 Page 1
EXPENDITURES BUDGET ACTUAL 33%FORECAST
OPERATING EXPENDITURES
Arts 524,400 115,686 22%526,800
Building Safety 995,400 320,317 32%995,400
Customer Services 298,300 98,595 33%298,300
Economic Development 403,100 161,175 40%410,700
Emergency Services 4,170,300 1,399,391 34%4,322,500
Financial Management 855,300 292,967 34%855,300
GIS 433,600 114,188 26%433,600
Golf Courses 678,800 158,766 23%702,600
Human Resources 134,800 44,053 33%134,300
Information Technology 675,600 200,129 30%675,600
Legacy Flight Museum 91,600 10,150 11%91,600
Legal Services 248,200 90,886 37%248,200
Mayor, Council & Mayor's Youth Advisory Board 326,100 107,894 33%326,100
Miscellaneous 44,800 17,018 38%45,200
Parks & Ball Diamonds 673,600 164,801 24%694,600
Planning & Zoning 345,000 106,882 31%345,000
Recreation Administration & Programs 453,300 156,114 34%482,000
Rexburg Rapids 479,800 33,236 7%479,800
Police Department
Administration Division & Fund 09 1,353,100 382,988 28%1,365,100
Patrol Division & Funds 13 2,202,400 752,735 34%2,202,400
Investigations Division 687,600 255,555 37%687,600
Community Services Division & Funds 08,11,14 679,800 212,817 31%679,900
Total Police Department 4,922,900 1,604,095 33%4,935,000
Public Works
Building Maintenance 47,800 17,384 36%47,800
Shop 629,600 193,642 31%629,600
Sanitation 2,196,300 732,018 33%2,196,300
Water 3,021,900 859,830 28%3,021,900
Wastewater - Treatment 3,063,500 975,842 32%3,063,500
Wastewater - Collections 1,641,500 540,035 33%1,641,500
Street Operations 2,438,200 613,604 25%2,512,800
Street Repair Contracts 778,000 1,384,851 178%1,828,000
Total Public Works 13,816,800 5,317,206 38%14,941,400
TOTAL OPERATING EXPENDITURES 30,571,700 10,513,549 34%31,944,000
CAPITAL EXPENDITURES
Engineering 575,200 182,764 32%575,200
Construction 06,30,31,32,39,41,42,44,46,49,51-58,82,84,85 8,658,000 1,023,906 12%14,640,800
Contributed Capital Offset 1,675,000 0%1,675,000
Capital Reserve Funds 07,18,20,33,34,35,38 715,400 -5,414 -1%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 13,046 6%175,000
TOTAL CAPITAL EXPENDITURES 12,914,300 1,214,302 9%18,900,800
Contingent Operating Expenses 5,079,800 0%3,791,800
Contingent Capital Expenses 4,957,400 0%3,999,800
Internal Transfers Out for Operations 4,503,000 169,700 4%3,010,000
Internal Transfers Out for Capital 4,811,900 105,000 2%7,711,600
TOTAL EXPENDITURES FOR ALL FUNDS 62,838,100 12,002,551 19%69,358,000
CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2019 4 months ending
1/31/2019 Page 2
REVENUES BUDGET ACTUAL 33%FORECAST
OPERATING REVENUES
County Road Tax 830,000 523,982 63%830,000
Federal Grants 552,400 1,948 0%578,400
Franchise Fees 1,826,600 480,314 26%1,826,600
Fund Balances for Operations 3,191,100 0%4,385,700
Investment Earnings 147,200 60,393 41%147,200
Unrealized Gain (Loss)4,356 0%
Interfund Charges for Services 3,402,300 1,120,766 33%3,402,300
Miscellaneous 878,400 207,703 24%883,700
Operating Contributions 3,188,500 512,037 16%3,212,100
Parks, Recreation, Museums, Arts, Golf 1,310,200 190,222 15%1,356,900
Permits & Licenses 855,200 180,450 21%855,200
Property Tax 4,817,300 2,827,890 59%4,817,300
State Taxes & Grants 3,032,600 672,813 22%3,029,600
Utility Charges -Water 2,952,500 902,953 31%2,952,500
Utility Charges -Wastewater 6,329,800 1,642,503 26%6,329,800
Utility Charges -Sanitation 2,235,000 822,301 37%2,235,000
TOTAL OPERATING REVENUES 35,549,100 10,150,631 29%36,842,300
CAPITAL REVENUES
Borrowing 905,000 819,752 91%905,000
Capital Reserve Fees & Impact Fees 2,071,800 320,102 15%1,932,800
Capital Reserve Carryover Balances 4,201,500 0%4,854,500
Construction Funds 5,675,000 80,008 1%7,169,900
Contributed Capital 1,469,100 0%1,469,100
Engineering Billings 574,500 0%574,500
Fund Balances for Capital 510,900 0%511,000
Grants 345,800 0%669,500
LID Funds 300,000 141,260 47%692,000
Trust Funds 1,886,600 135,864 7%1,886,600
TOTAL CAPITAL REVENUES 17,940,200 1,496,986 8%20,664,900
Contingent Operating Revenues 0%
Contingent Capital Revenues 0%
Internal Transfers In for Operations 4,467,500 169,700 4%3,046,700
Internal Transfers In for Capital 4,881,300 105,000 2%7,781,000
TOTAL REVENUES ALL FUNDS 62,838,100 11,922,317 19%68,334,900
OPERATIONS SUMMARY
TOTAL OPERATING REVENUES 40,016,600 10,320,331 29%39,889,000
TOTAL OPERATING EXPENDITURES 40,154,500 10,683,249 34%38,745,800
---NET OPERATIONS -137,900 -362,918 1,143,200
CAPITAL SUMMARY
TOTAL CAPITAL REVENUES 22,821,500 1,601,986 8%28,445,900
TOTAL CAPITAL EXPENDITURES 22,683,600 1,319,302 9%30,612,200
---NET CAPITAL TRANSACTIONS 137,900 282,684 -2,166,300
TOTAL ALL REVENUES 62,838,100 11,922,317 19%68,334,900
TOTAL ALL EXPENDITURES 62,838,100 12,002,551 19%69,358,000
NET ALL REVENUES OVER EXPENDITURES 0 -80,234 -1,023,100
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 35,854 0.13%35,854
Beehive Credit Union CD 250,000 0.90%250,000
Cash On Hand 1,050 0.00%1,050
Citizens Community Bank CD 248,979 0.90%248,979
City Golf Cart CD 114,900 0.42%114,900
Idaho Central Credit Union CD 250,000 0.90%250,000
Idaho Central Credit Union Savings 25 0.00%25
Key Bank Checking (RLF)348,506 1.26%348,506
Moreton Asset Management 2,291,521 2,714,153 18.11%5,005,674
Real Estate Investments (Streets)307,085 1.11%307,085
State Diversified Bond Fund 1,175,480 4,846,517 1,625,005 27.67%7,647,002
State LGIP--City 3,039,111 182,556 11.66%3,221,667
State LGIP--Fire District 569,878 34,232 2.19%604,110
Wells Fargo Drug Fund Checking 14,916 0.05%14,916
Wells Fargo Fire District Banking 109,786 0.40%109,786
Zions Bank Capital Advisors 3,075,126 1,929,546 18.11%5,004,672
Zions Bank Collateralized Acct 4,000,282 14.48%4,000,282
Zions Bank General Checking 448,079 1.62%448,079
Zions Bank Payroll Checking 20,228 0.07%20,228
TOTAL 16,300,806 9,707,004 1,625,005 100%27,632,815
% OF TOTAL PORTFOLIO 59.0%35.1%5.9%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