HomeMy WebLinkAboutBudget Summary Report - Aug 2019CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2019 11 months ending
8/31/2019 Page 1
EXPENDITURES BUDGET ACTUAL 92%FORECAST
OPERATING EXPENDITURES
Misc. Departments/Categories
Arts 604,600 497,608 82%601,400
Building Safety 995,400 890,191 89%958,800
Customer Services 298,300 260,738 87%291,800
Economic Development 408,100 383,962 94%410,800
Emergency Services 4,215,300 3,775,220 90%4,133,200
Financial Management 855,300 715,371 84%842,700
GIS 433,600 360,050 83%394,800
Golf Courses 738,800 616,992 84%835,000
Human Resources 134,800 125,135 93%134,700
Information Technology 675,600 589,761 87%663,200
Legacy Flight Museum 91,600 50,859 56%85,700
Legal Services 248,200 220,508 89%244,600
Mayor, Council & Mayor's Youth Advisory Board 330,600 286,099 87%307,700
Miscellaneous 44,800 37,830 84%51,600
Parks & Ball Diamonds 743,000 607,731 82%756,500
Planning & Zoning 345,000 245,521 71%302,100
Recreation Administration & Programs 453,300 435,050 96%471,300
Rexburg Rapids 479,800 407,476 85%458,900
Total Misc. Departments/Categories 12,096,100 10,506,102 87%11,944,800
Police Department
Administration Division & Fund 09 1,353,100 1,080,098 80%1,330,500
Patrol Division & Funds 13 2,202,400 2,029,292 92%2,204,500
Investigations Division 692,300 674,066 97%731,200
Community Services Division & Funds 08,11,14 679,800 639,874 94%712,300
Total Police Department 4,927,600 4,423,330 90%4,978,500
Public Works
Building Maintenance 47,800 48,422 101%56,300
Shop 629,600 509,779 81%626,300
Sanitation 2,196,300 2,013,029 92%2,217,800
Water 3,021,900 2,462,667 81%2,776,600
Wastewater - Treatment 3,063,500 2,692,468 88%2,973,400
Wastewater - Collections 1,641,500 1,503,059 92%1,631,900
Street Operations 2,513,200 1,818,382 72%2,617,300
Street Repair Contracts 2,013,900 1,517,357 75%2,669,100
Total Public Works 15,127,700 12,565,163 83%15,568,700
TOTAL OPERATING EXPENDITURES 32,151,400 27,494,595 86%32,492,000
CAPITAL EXPENDITURES
Engineering 575,200 483,616 84%558,500
Construction 06,30,31,32,39,41,42,44,46,49,51-58,82,84,85 7,803,700 4,424,511 57%6,889,500
Contributed Capital Offset 1,675,000 0%1,650,000
Capital Reserve Funds 07,18,20,33,34,35,38 896,100 466,112 52%721,700
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 38,203 18%120,400
TOTAL CAPITAL EXPENDITURES 12,240,700 5,535,940 45%10,182,200
Contingent Operating Expenses 2,476,400 0%
Contingent Capital Expenses 6,497,400 0%
Internal Transfers Out for Operations 4,550,100 636,675 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 34,572,210 53%53,506,600
CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2019 11 months ending
8/31/2019 Page 2
REVENUES BUDGET ACTUAL 92%FORECAST
OPERATING REVENUES
County Road Tax 830,000 890,158 107%885,000
Federal Grants 557,100 163,577 29%476,500
Franchise Fees 1,826,600 1,444,156 79%1,765,800
Fund Balances for Operations 3,221,200 0%4,217,900
Investment Earnings 147,200 201,952 137%191,200
Unrealized Gain (Loss)203,864 0%
Interfund Charges for Services - Overhead 3,402,300 3,068,358 90%3,355,400
Miscellaneous 910,200 653,092 72%726,400
Operating Contributions 3,277,700 2,506,488 76%3,194,200
Parks, Recreation, Museums, Arts, Golf 1,321,200 1,268,452 96%1,443,000
Permits & Licenses 855,200 779,817 91%795,200
Property Tax 4,817,300 4,773,031 99%4,817,300
State Taxes & Grants 3,772,600 3,135,357 83%3,892,600
Utility Charges -Water 2,952,500 3,035,866 103%3,114,900
Utility Charges -Wastewater 5,169,800 4,605,699 89%5,071,300
Utility Charges -Sanitation 2,235,000 2,316,043 104%2,435,100
TOTAL OPERATING REVENUES 35,295,900 29,045,911 82%36,381,800
CAPITAL REVENUES
Borrowing - DEQ Water Loan 2,131,000 2,624,564 123%
Capital Reserve Fees & Impact Fees 2,071,800 2,255,540 109%2,413,900
Capital Reserve Carryover Balances 4,382,200 0%5,545,100
Construction Funds 4,425,000 1,053,755 24%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 153,642 51%663,100
Trust Funds 1,886,600 943,508 50%1,875,900
TOTAL CAPITAL REVENUES 18,057,800 7,031,009 39%16,702,100
Contingent Operating Revenues 0%
Contingent Capital Revenues 0%
Internal Transfers In for Operations 4,492,900 636,675 14%4,092,500
Internal Transfers In for Capital 6,817,000 905,000 13%6,877,500
TOTAL REVENUES ALL FUNDS 64,663,600 37,618,595 58%64,053,900
OPERATIONS SUMMARY
TOTAL OPERATING REVENUES 39,788,800 29,682,586 82%40,474,300
TOTAL OPERATING EXPENDITURES 39,177,900 28,131,270 86%36,608,000
---NET OPERATIONS 610,900 1,551,316 3,866,300
CAPITAL SUMMARY
TOTAL CAPITAL REVENUES 24,874,800 7,936,009 39%23,579,600
TOTAL CAPITAL EXPENDITURES 25,485,700 6,440,940 45%16,898,600
---NET CAPITAL TRANSACTIONS -610,900 1,495,069 6,681,000
TOTAL ALL REVENUES 64,663,600 37,618,595 58%64,053,900
TOTAL ALL EXPENDITURES 64,663,600 34,572,210 53%53,506,600
NET ALL REVENUES OVER EXPENDITURES 0 3,046,385 10,547,300
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 Bank CD 249,009 0.82%249,009
Bank of Commerce Legacy FM 37,320 0.12%37,320
Beehive Credit Union CD 250,152 0.82%250,152
Cash On Hand 2,450 0.01%2,450
City Golf Cart CD 91,920 0.30%91,920
Idaho Central Credit Union CD 250,000 0.82%250,000
Idaho Central Credit Union Savings 25 0.00%25
Key Bank Checking (RLF)326,873 1.07%326,873
Moreton Asset Management 1,949,964 3,221,775 16.96%5,171,739
Real Estate Investments (Streets)307,085 1.01%307,085
State Diversified Bond Fund 1,227,056 5,059,164 1,696,304 26.17%7,982,524
State LGIP--City 6,747,798 405,332 23.45%7,153,130
State LGIP--Fire District 575,913 34,594 2.00%610,507
Wells Fargo Drug Fund Checking 14,915 0.05%14,915
Wells Fargo Fire District Banking 400,187 1.31%400,187
Zions Bank Capital Advisors 3,979,139 1,117,917 16.71%5,097,056
Zions Bank Collateralized Acct 2,001,378 6.56%2,001,378
Zions Bank General Checking 532,783 1.75%532,783
Zions Bank Payroll Checking 20,418 0.07%20,418
TOTAL 18,964,385 9,838,782 1,696,304 100%30,499,471
% OF TOTAL PORTFOLIO 62.2%32.3%5.6%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