HomeMy WebLinkAboutBudget Summary Report - Jun 2019CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2019 9 months ending
6/30/2019 Page 1
EXPENDITURES BUDGET ACTUAL 75%FORECAST
OPERATING EXPENDITURES
Misc. Departments/Categories
Arts 604,600 301,764 50%634,800
Building Safety 995,400 765,053 77%958,800
Customer Services 298,300 215,388 72%291,800
Economic Development 408,100 317,023 78%407,300
Emergency Services 4,215,300 2,961,352 70%4,562,400
Financial Management 855,300 599,595 70%842,700
GIS 433,600 293,819 68%400,000
Golf Courses 738,800 466,379 63%759,500
Human Resources 134,800 102,704 76%134,700
Information Technology 675,600 480,077 71%663,200
Legacy Flight Museum 91,600 28,387 31%85,700
Legal Services 248,200 184,641 74%244,600
Mayor, Council & Mayor's Youth Advisory Board 330,600 237,569 72%307,700
Miscellaneous 44,800 31,876 71%51,600
Parks & Ball Diamonds 743,000 461,078 62%756,500
Planning & Zoning 345,000 194,529 56%290,200
Recreation Administration & Programs 453,300 374,488 83%471,400
Rexburg Rapids 479,800 196,580 41%463,500
Total Misc. Departments/Categories 12,096,100 8,212,302 68%12,326,400
Police Department
Administration Division & Fund 09 1,353,100 889,125 66%1,320,800
Patrol Division & Funds 13 2,202,400 1,659,731 75%2,254,800
Investigations Division 692,300 544,159 79%731,400
Community Services Division & Funds 08,11,14 679,800 501,815 74%712,300
Total Police Department 4,927,600 3,594,830 73%5,019,300
Public Works
Building Maintenance 47,800 41,195 86%56,300
Shop 629,600 425,488 68%622,100
Sanitation 2,196,300 1,691,303 77%2,217,800
Water 3,021,900 1,980,778 66%2,776,600
Wastewater - Treatment 3,063,500 2,243,603 73%2,926,800
Wastewater - Collections 1,641,500 1,236,203 75%1,629,900
Street Operations 2,513,200 1,549,190 62%2,579,100
Street Repair Contracts 2,013,900 1,435,060 71%2,594,100
Total Public Works 15,127,700 10,602,820 70%15,402,700
TOTAL OPERATING EXPENDITURES 32,151,400 22,409,952 70%32,748,400
CAPITAL EXPENDITURES
Engineering 575,200 398,609 69%563,800
Construction 06,30,31,32,39,41,42,44,46,49,51-58,82,84,85 7,803,700 2,612,438 33%14,776,500
Contributed Capital Offset 1,675,000 0%1,675,000
Capital Reserve Funds 07,18,20,33,34,35,38 896,100 411,692 46%600,500
LID Debt Service Funds 59-69 1,073,400 79,786 7%1,169,600
Trust & RLF Funds 15,16,19,21,22,90,91 217,300 32,326 15%554,600
TOTAL CAPITAL EXPENDITURES 12,240,700 3,534,851 29%19,340,000
Contingent Operating Expenses 2,476,400 0%
Contingent Capital Expenses 6,497,400 0%
Internal Transfers Out for Operations 4,550,100 511,825 11%4,094,300
Internal Transfers Out for Capital 6,747,600 905,000 13%6,716,400
TOTAL EXPENDITURES FOR ALL FUNDS 64,663,600 27,361,628 42%62,899,100
CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2019 9 months ending
6/30/2019 Page 2
REVENUES BUDGET ACTUAL 75%FORECAST
OPERATING REVENUES
County Road Tax 830,000 581,903 70%885,000
Federal Grants 557,100 160,406 29%866,500
Franchise Fees 1,826,600 1,069,930 59%1,765,800
Fund Balances for Operations 3,221,200 0%4,217,900
Investment Earnings 147,200 162,343 110%191,500
Unrealized Gain (Loss)129,622 0%
Interfund Charges for Services - Overhead 3,402,300 2,510,474 74%3,358,000
Miscellaneous 910,200 604,872 66%726,400
Operating Contributions 3,277,700 1,450,372 44%3,200,100
Parks, Recreation, Museums, Arts, Golf 1,321,200 794,820 60%1,432,600
Permits & Licenses 855,200 614,567 72%840,200
Property Tax 4,817,300 3,118,267 65%4,817,300
State Taxes & Grants 3,772,600 2,327,631 62%3,892,600
Utility Charges -Water 2,952,500 2,161,222 73%3,114,900
Utility Charges -Wastewater 5,169,800 3,753,692 73%5,071,300
Utility Charges -Sanitation 2,235,000 1,881,960 84%2,435,100
TOTAL OPERATING REVENUES 35,295,900 21,322,081 60%36,815,200
CAPITAL REVENUES
Borrowing - DEQ Water Loan 2,131,000 819,752 38%
Capital Reserve Fees & Impact Fees 2,071,800 2,001,050 97%2,162,900
Capital Reserve Carryover Balances 4,382,200 0%5,545,100
Construction Funds 4,425,000 1,011,255 23%2,578,700
Contributed Capital 1,430,000 0%1,430,000
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 144,088 48%596,700
Trust Funds 1,886,600 644,179 34%1,844,600
TOTAL CAPITAL REVENUES 18,057,800 4,620,324 26%16,316,200
Contingent Operating Revenues 0%
Contingent Capital Revenues 0%
Internal Transfers In for Operations 4,492,900 511,825 11%4,082,300
Internal Transfers In for Capital 6,817,000 905,000 13%6,877,500
TOTAL REVENUES ALL FUNDS 64,663,600 27,359,230 42%64,091,200
OPERATIONS SUMMARY
TOTAL OPERATING REVENUES 39,788,800 21,833,906 60%40,897,500
TOTAL OPERATING EXPENDITURES 39,177,900 22,921,777 70%36,842,700
---NET OPERATIONS 610,900 -1,087,871 4,054,800
CAPITAL SUMMARY
TOTAL CAPITAL REVENUES 24,874,800 5,525,324 26%23,193,700
TOTAL CAPITAL EXPENDITURES 25,485,700 4,439,851 29%26,056,400
---NET CAPITAL TRANSACTIONS -610,900 1,085,473 -2,862,700
TOTAL ALL REVENUES 64,663,600 27,359,230 42%64,091,200
TOTAL ALL EXPENDITURES 64,663,600 27,361,628 42%62,899,100
NET ALL REVENUES OVER EXPENDITURES 0 -2,398 1,192,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 37,177 0.13%37,177
Bank of Commerce Bank CD 249,010 0.88%249,010
Beehive Credit Union CD 250,152 0.88%250,152
Cash On Hand 4,850 0.02%4,850
City Golf Cart CD 91,920 0.32%91,920
Idaho Central Credit Union CD 250,000 0.88%250,000
Idaho Central Credit Union Savings 25 0.00%25
Key Bank Checking (RLF)389,260 1.37%389,260
Moreton Asset Management 2,291,521 2,817,443 17.98%5,108,964
Real Estate Investments (Streets)307,085 1.08%307,085
State Diversified Bond Fund 1,209,835 4,988,161 1,672,497 27.70%7,870,493
State LGIP--City 3,785,946 227,417 14.13%4,013,363
State LGIP--Fire District 575,913 34,594 2.15%610,507
Wells Fargo Drug Fund Checking 14,915 0.05%14,915
Wells Fargo Fire District Banking 690,787 2.43%690,787
Zions Bank Capital Advisors 3,075,126 1,999,440 17.86%5,074,566
Zions Bank Collateralized Acct 1,500,240 5.28%1,500,240
Zions Bank General Checking 1,927,234 6.78%1,927,234
Zions Bank Payroll Checking 20,903 0.07%20,903
TOTAL 16,671,899 10,067,055 1,672,497 100%28,411,451
% OF TOTAL PORTFOLIO 58.7%35.4%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