HomeMy WebLinkAboutBudget Summary Report - Dec 2019CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2020 3 months ending
12/31/2019 Page 1
EXPENDITURES BUDGET ACTUAL 25%FORECAST
OPERATING EXPENDITURES
Misc. Departments/Categories
Arts 642,400 90,025 14%644,800
Building Safety 839,600 212,518 25%839,600
Customer Services 306,900 92,901 30%306,900
Economic Development 399,900 102,671 26%399,900
Emergency Services 4,617,700 972,435 21%4,634,200
Financial Management 894,400 249,731 28%895,800
GIS 427,400 127,135 30%427,400
Golf Courses 725,000 179,046 25%807,200
Human Resources 141,600 35,994 25%141,600
Information Technology 695,600 163,640 24%705,600
Legacy Flight Museum 117,900 6,230 5%118,300
Legal Services 273,000 64,404 24%273,000
Mayor, Council & Mayor's Youth Advisory Board 328,100 86,282 26%328,100
Miscellaneous 49,300 5,780 12%49,300
Parks & Ball Diamonds 732,800 163,188 22%730,300
Planning & Zoning 385,400 88,920 23%385,400
Recreation Administration & Programs 506,200 121,931 24%507,700
Rexburg Rapids 477,200 220,718 46%638,200
Total Misc. Departments/Categories 12,560,400 2,983,549 24%12,833,300
Police Department
Administration Division & Fund 09 1,309,000 337,093 26%1,309,000
Patrol Division & Funds 13 2,382,800 538,835 23%2,382,800
Investigations Division 750,900 205,321 27%750,900
Community Services Division & Funds 08,11,14 731,800 170,315 23%729,900
Total Police Department 5,174,500 1,251,564 24%5,172,600
Public Works
Building Maintenance 52,800 11,539 22%52,800
Shop 610,700 137,898 23%610,700
Sanitation 2,266,500 561,061 25%2,266,500
Water 3,039,100 683,092 22%3,039,100
Wastewater - Treatment 2,976,900 766,769 26%2,976,900
Wastewater - Collections 1,735,400 435,963 25%1,735,400
Street Operations 2,432,700 686,001 28%2,397,700
Street Repair Contracts 208,000 184,725 89%403,800
Total Public Works 13,322,100 3,467,048 26%13,482,900
TOTAL OPERATING EXPENDITURES 31,057,000 7,702,161 25%31,488,800
CAPITAL EXPENDITURES
Engineering 563,800 141,490 25%563,800
Construction 06,30,31,32,39,41,42,44,46,49,51-58,82,84,85 14,776,500 1,092,557 7%16,704,600
Contributed Capital Offset 1,675,000 6,249 0%1,675,000
Capital Reserve Funds 07,18,20,33,34,35,38 600,500 13,375 2%625,000
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 36,315 7%560,600
TOTAL CAPITAL EXPENDITURES 19,340,000 1,289,986 7%21,298,600
Contingent Operating Expenses 4,403,500 0%4,403,500
Contingent Capital Expenses 2,518,400 0%2,450,700
Internal Transfers Out for Operations 4,613,100 626,549 14%4,616,900
Internal Transfers Out for Capital 6,980,000 93,750 1%9,008,900
TOTAL EXPENDITURES FOR ALL FUNDS 68,912,000 9,712,446 14%73,267,400
CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2020 3 months ending
12/31/2019 Page 2
REVENUES BUDGET ACTUAL 25%FORECAST
OPERATING REVENUES
County Road Tax 890,000 49,050 6%890,000
Federal Grants 844,600 20,480 2%822,800
Franchise Fees 1,771,400 150,688 9%1,771,400
Fund Balances for Operations 2,163,000 0%3,283,200
Investment Earnings 198,600 44,488 22%198,600
Unrealized Gain (Loss)-3,030 0%
Interfund Charges for Services - Overhead 3,381,300 835,925 25%3,381,300
Miscellaneous 543,000 113,554 21%543,000
Operating Contributions 3,214,000 410,135 13%3,245,300
Parks, Recreation, Museums, Arts, Golf 1,365,400 92,387 7%1,366,200
Permits & Licenses 777,300 190,964 25%777,300
Property Tax 5,054,700 315,214 6%5,054,700
State Taxes & Grants 3,700,200 5,938 0%3,480,100
Utility Charges -Water 3,169,300 645,436 20%3,169,300
Utility Charges -Wastewater 7,447,800 1,347,482 18%7,447,800
Utility Charges -Sanitation 2,299,300 637,324 28%2,299,300
TOTAL OPERATING REVENUES 36,819,900 4,856,035 13%37,730,300
CAPITAL REVENUES
Borrowing - DEQ Water Loan 1,305,300 575,237 44%1,305,300
Capital Reserve Fees & Impact Fees 2,116,000 359,404 17%2,125,500
Capital Reserve Carryover Balances 2,978,300 0%5,500,200
Construction Funds 7,382,400 64,034 1%7,792,500
Contributed Capital 1,425,000 6,249 0%1,425,000
Engineering Billings 563,100 0%563,100
Fund Balances for Capital 1,147,100 0%2,931,500
Grants 1,011,800 0%1,011,800
LID Funds 201,000 17,677 9%201,000
Trust Funds 2,019,400 107,107 5%2,077,100
TOTAL CAPITAL REVENUES 20,149,400 1,129,708 6%24,933,000
Contingent Operating Revenues 0%
Contingent Capital Revenues 0%
Internal Transfers In for Operations 4,587,600 620,174 14%4,591,400
Internal Transfers In for Capital 7,355,100 99,999 1%9,202,200
TOTAL REVENUES ALL FUNDS 68,912,000 6,705,916 10%76,456,900
OPERATIONS SUMMARY
TOTAL OPERATING REVENUES 41,407,500 5,476,209 13%42,321,700
TOTAL OPERATING EXPENDITURES 40,073,600 8,328,710 25%40,509,200
---NET OPERATIONS 1,333,900 -2,852,501 1,812,500
CAPITAL SUMMARY
TOTAL CAPITAL REVENUES 27,504,500 1,229,707 6%34,135,200
TOTAL CAPITAL EXPENDITURES 28,838,400 1,383,736 7%32,758,200
---NET CAPITAL TRANSACTIONS -1,333,900 -154,029 1,377,000
TOTAL ALL REVENUES 68,912,000 6,705,916 10%76,456,900
TOTAL ALL EXPENDITURES 68,912,000 9,712,446 14%73,267,400
NET ALL REVENUES OVER EXPENDITURES 0 -3,006,530 3,189,500
CITY OF REXBURG CASH & INVESTMENT
FY 2020 BALANCE REPORT
Page 3
BALANCE AS
OF
CASH & INVESTMENTS < 1 YEAR 1-5 YEARS > 5 YEARS 12/31/2019
Bank of Commerce Bank CD 249,009 0.91%249,009
Bank of Commerce Legacy FM 44,877 0.16%44,877
Beehive Credit Union CD 250,152 0.91%250,152
Cash On Hand 1,050 0.00%1,050
City Golf Cart CD 91,920 0.33%91,920
Idaho Central Credit Union CD 250,000 0.91%250,000
Idaho Central Credit Union Savings 25 0.00%25
Key Bank Checking (RLF)350,623 1.28%350,623
Moreton Asset Management 1,991,540 3,221,775 19.00%5,213,315
Real Estate Investments (Streets)324,863 1.18%324,863
State Diversified Bond Fund 614,540 2,533,758 849,552 14.57%3,997,850
State LGIP--City 6,496,297 390,225 25.09%6,886,522
State LGIP--Fire District 581,472 34,928 2.25%616,400
TVI - Bond Investment 0 3,000,000 10.93%3,000,000
Wells Fargo Drug Fund Checking 14,416 0.05%14,416
Wells Fargo Fire District Banking 465,743 1.70%465,743
Westmark CD 249,990 0.91%249,990
Zions Bank Capital Advisors 4,016,878 1,117,917 18.71%5,134,795
Zions Bank Collateralized Acct 215,761 0.79%215,761
Zions Bank General Checking 66,410 0.24%66,410
Zions Bank Payroll Checking 19,325 0.07%19,325
TOTAL 16,294,891 10,298,603 849,552 100%27,443,046
% OF TOTAL PORTFOLIO 59.4%37.5%3.1%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