HomeMy WebLinkAboutBudget Summary Report - Oct 2019CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2020 1 month ending
10/31/2019 Page 1
EXPENDITURES BUDGET ACTUAL 8%FORECAST
OPERATING EXPENDITURES
Misc. Departments/Categories
Arts 642,400 28,905 4%644,800
Building Safety 839,600 68,760 8%839,600
Customer Services 306,900 33,574 11%306,900
Economic Development 399,900 37,692 9%399,900
Emergency Services 4,617,700 283,303 6%4,617,700
Financial Management 894,400 91,607 10%894,400
GIS 427,400 30,811 7%427,400
Golf Courses 725,000 73,396 10%813,200
Human Resources 141,600 13,234 9%141,600
Information Technology 695,600 49,001 7%705,600
Legacy Flight Museum 117,900 1,630 1%117,900
Legal Services 273,000 21,130 8%273,000
Mayor, Council & Mayor's Youth Advisory Board 328,100 36,845 11%328,100
Miscellaneous 49,300 1,603 3%49,300
Parks & Ball Diamonds 732,800 54,564 7%732,800
Planning & Zoning 385,400 32,447 8%385,400
Recreation Administration & Programs 506,200 30,753 6%506,200
Rexburg Rapids 477,200 10,258 2%638,200
Total Misc. Departments/Categories 12,560,400 899,513 7%12,822,000
Police Department
Administration Division & Fund 09 1,309,000 93,884 7%1,309,000
Patrol Division & Funds 13 2,382,800 180,429 8%2,382,800
Investigations Division 750,900 68,661 9%750,900
Community Services Division & Funds 08,11,14 731,800 55,456 8%731,800
Total Police Department 5,174,500 398,430 8%5,174,500
Public Works
Building Maintenance 52,800 4,237 8%52,800
Shop 610,700 40,816 7%610,700
Sanitation 2,266,500 108,487 5%2,266,500
Water 3,039,100 120,615 4%3,039,100
Wastewater - Treatment 2,976,900 154,668 5%2,976,900
Wastewater - Collections 1,735,400 70,079 4%1,735,400
Street Operations 2,432,700 344,204 14%2,432,700
Street Repair Contracts 208,000 420 0%208,000
Total Public Works 13,322,100 843,526 6%13,322,100
TOTAL OPERATING EXPENDITURES 31,057,000 2,141,469 7%31,318,600
CAPITAL EXPENDITURES
Engineering 563,800 39,207 7%563,800
Construction 06,30,31,32,39,41,42,44,46,49,51-58,82,84,85 14,776,500 212,367 1%15,818,000
Contributed Capital Offset 1,675,000 0%1,675,000
Capital Reserve Funds 07,18,20,33,34,35,38 600,500 -89 0%600,500
LID Debt Service Funds 59-69 1,169,600 0%1,169,600
Trust & RLF Funds 15,16,19,21,22,90,91 554,600 302 0%554,600
TOTAL CAPITAL EXPENDITURES 19,340,000 251,787 1%20,381,500
Contingent Operating Expenses 4,403,500 0%4,403,500
Contingent Capital Expenses 2,518,400 0%2,517,200
Internal Transfers Out for Operations 4,613,100 0%4,613,100
Internal Transfers Out for Capital 6,980,000 0%8,021,500
TOTAL EXPENDITURES FOR ALL FUNDS 68,912,000 2,393,256 3%71,255,400
CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2020 1 month ending
10/31/2019 Page 2
REVENUES BUDGET ACTUAL 8%FORECAST
OPERATING REVENUES
County Road Tax 890,000 2,292 0%890,000
Federal Grants 844,600 0%844,600
Franchise Fees 1,771,400 273,572 15%1,771,400
Fund Balances for Operations 2,163,000 0%2,251,000
Investment Earnings 198,600 15,857 8%198,600
Unrealized Gain (Loss)1,257 0%
Interfund Charges for Services - Overhead 3,381,300 0%3,381,300
Miscellaneous 543,000 23,030 4%543,000
Operating Contributions 3,214,000 205,983 6%3,217,700
Parks, Recreation, Museums, Arts, Golf 1,365,400 35,831 3%1,365,400
Permits & Licenses 777,300 105,056 14%777,300
Property Tax 5,054,700 5,530 0%5,054,700
State Taxes & Grants 3,700,200 682,385 18%3,700,200
Utility Charges -Water 3,169,300 265,256 8%3,169,300
Utility Charges -Wastewater 7,447,800 451,452 6%7,447,800
Utility Charges -Sanitation 2,299,300 208,151 9%2,299,300
TOTAL OPERATING REVENUES 36,819,900 2,275,652 6%36,911,600
CAPITAL REVENUES
Borrowing - DEQ Water Loan 1,305,300 0 0%1,305,300
Capital Reserve Fees & Impact Fees 2,116,000 135,061 6%2,116,000
Capital Reserve Carryover Balances 2,978,300 0%2,978,300
Construction Funds 7,382,400 21,366 0%7,382,400
Contributed Capital 1,425,000 0%1,425,000
Engineering Billings 563,100 0%563,100
Fund Balances for Capital 1,147,100 0%1,147,100
Grants 1,011,800 56,655 6%1,011,800
LID Funds 201,000 14,041 7%201,000
Trust Funds 2,019,400 10,660 1%2,019,100
TOTAL CAPITAL REVENUES 20,149,400 237,783 1%20,149,100
Contingent Operating Revenues 0%
Contingent Capital Revenues 0%
Internal Transfers In for Operations 4,587,600 0%4,587,600
Internal Transfers In for Capital 7,355,100 0%8,396,600
TOTAL REVENUES ALL FUNDS 68,912,000 2,513,435 4%70,044,900
OPERATIONS SUMMARY
TOTAL OPERATING REVENUES 41,407,500 2,275,652 6%41,499,200
TOTAL OPERATING EXPENDITURES 40,073,600 2,141,469 7%40,335,200
---NET OPERATIONS 1,333,900 134,183 1,164,000
CAPITAL SUMMARY
TOTAL CAPITAL REVENUES 27,504,500 237,783 1%28,545,700
TOTAL CAPITAL EXPENDITURES 28,838,400 251,787 1%30,920,200
---NET CAPITAL TRANSACTIONS -1,333,900 -14,004 -2,374,500
TOTAL ALL REVENUES 68,912,000 2,513,435 4%70,044,900
TOTAL ALL EXPENDITURES 68,912,000 2,393,256 3%71,255,400
NET ALL REVENUES OVER EXPENDITURES 0 120,179 -1,210,500
CITY OF REXBURG CASH & INVESTMENT
FY 2020 BALANCE REPORT
Page 3
BALANCE AS
OF
CASH & INVESTMENTS < 1 YEAR 1-5 YEARS > 5 YEARS 10/31/2019
Bank of Commerce Bank CD 249,009 0.85%249,009
Bank of Commerce Legacy FM 38,825 0.13%38,825
Beehive Credit Union CD 250,152 0.85%250,152
Cash On Hand 1,953 0.01%1,953
City Golf Cart CD 91,920 0.31%91,920
Idaho Central Credit Union CD 250,000 0.85%250,000
Idaho Central Credit Union Savings 25 0.00%25
Key Bank Checking (RLF)340,285 1.16%340,285
Moreton Asset Management 1,969,297 3,221,775 17.68%5,191,072
Real Estate Investments (Streets)307,085 1.05%307,085
State Diversified Bond Fund 613,393 2,529,026 847,965 13.59%3,990,384
State LGIP--City 10,239,699 615,086 36.97%10,854,785
State LGIP--Fire District 578,304 34,738 2.09%613,042
Wells Fargo Drug Fund Checking 14,416 0.05%14,416
Wells Fargo Fire District Banking 406,122 1.38%406,122
Zions Bank Capital Advisors 3,999,796 1,117,917 17.43%5,117,713
Zions Bank Collateralized Acct 1,175,724 4.00%1,175,724
Zions Bank General Checking 448,669 1.53%448,669
Zions Bank Payroll Checking 20,100 0.07%20,100
TOTAL 20,994,774 7,518,542 847,965 100%29,361,281
% OF TOTAL PORTFOLIO 71.5%25.6%2.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