HomeMy WebLinkAboutBudget Summary Report - Jul 2020CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2020 10 months ending
7/31/2020 Page 1
EXPENDITURES BUDGET ACTUAL 83%FORECAST
OPERATING EXPENDITURES
Misc. Departments/Categories
Arts 733,000 286,625 39%651,300
Building Safety 839,600 658,707 78%795,200
Customer Services 316,200 265,374 84%314,200
Economic Development 362,800 267,275 74%341,200
Emergency Services 4,634,200 3,144,513 68%4,438,000
Financial Management 894,400 693,212 78%853,300
GIS 427,400 337,520 79%402,500
Golf Courses 830,300 634,146 76%876,700
Human Resources 145,100 118,613 82%141,600
Information Technology 695,600 572,078 82%687,100
Legacy Flight Museum 117,900 58,385 50%96,000
Legal Services 273,000 222,584 82%277,700
Mayor, Council & Mayor's Youth Advisory Board 328,100 289,149 88%344,700
Miscellaneous 49,300 29,395 60%49,300
Parks & Ball Diamonds 762,200 568,756 75%749,200
Planning & Zoning 385,400 280,294 73%355,900
Recreation Administration & Programs 551,900 403,860 73%512,700
Rexburg Rapids 726,200 442,356 61%647,100
Total Misc. Departments/Categories 13,072,600 9,272,842 71%12,533,700
Police Department
Administration Division & Fund 09 1,452,500 1,137,762 78%1,420,800
Patrol Division & Funds 13 2,279,800 1,819,235 80%2,253,800
Investigations Division 793,900 660,879 83%796,100
Community Services Division & Funds 08,11,14 731,800 576,133 79%721,100
Total Police Department 5,258,000 4,194,009 80%5,191,800
Public Works
Building Maintenance 52,800 35,855 68%50,300
Shop 610,700 483,617 79%608,600
Sanitation 2,266,500 1,883,182 83%2,309,500
Water 3,039,100 2,285,029 75%3,098,100
Wastewater - Treatment 2,976,900 2,571,616 86%3,128,600
Wastewater - Collections 1,737,200 1,415,188 81%1,627,600
Street Operations 2,739,700 2,172,771 79%2,753,600
Total Public Works 13,422,900 10,847,258 81%13,576,300
TOTAL OPERATING EXPENDITURES 31,753,500 24,314,109 77%31,301,800
CAPITAL EXPENDITURES
Engineering 563,800 462,867 82%567,100
Street Repair Contracts 150,400 621,246 413%738,900
Construction 06,30,31,32,39,41,42,44,46,49,51-58,82,84,85 16,666,400 4,876,601 29%9,990,900
Contributed Capital Offset 1,675,000 20,833 1%1,175,000
Capital Reserve Funds 07,18,20,33,34,35,38 702,800 269,369 38%502,800
LID Debt Service Funds 59-69 1,169,600 57,983 5%250,100
Trust & RLF Funds 15,16,19,21,22,90,91 629,900 121,176 19%150,100
TOTAL CAPITAL EXPENDITURES 21,557,900 6,430,075 30%13,374,900
Contingent Operating Expenses 4,212,100 0%12,100
Contingent Capital Expenses 2,355,800 0%25,900
Internal Transfers Out for Operations 4,580,400 2,419,016 53%4,482,700
Internal Transfers Out for Capital 7,832,300 342,499 4%6,094,000
TOTAL EXPENDITURES FOR ALL FUNDS 72,292,000 33,505,699 46%55,291,400
CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2020 10 months ending
7/31/2020 Page 2
REVENUES BUDGET ACTUAL 83%FORECAST
OPERATING REVENUES
County Road Tax 890,000 794,278 89%870,000
Federal Grants 844,600 58,857 7%679,800
Franchise Fees 1,771,400 1,342,119 76%1,754,100
Fund Balances for Operations 2,623,400 0%2,681,200
Investment Earnings 198,600 114,107 57%147,700
Unrealized Gain (Loss)133,394 0%
Interfund Charges for Services - Overhead 3,381,300 2,786,417 82%3,384,000
Miscellaneous 543,000 518,309 95%504,500
Operating Contributions 3,283,900 2,571,037 78%3,215,100
Parks, Recreation, Museums, Arts, Golf 1,392,600 896,441 64%1,243,500
Permits & Licenses 786,600 902,567 115%849,200
Property Tax 5,054,700 5,137,569 102%5,226,453
State Taxes & Grants 3,900,200 2,905,123 74%4,416,500
Utility Charges -Water 3,169,300 2,614,211 82%3,195,000
Utility Charges -Wastewater 5,127,800 4,246,291 83%5,126,000
Utility Charges -Sanitation 2,299,300 2,128,522 93%2,424,300
TOTAL OPERATING REVENUES 35,266,700 27,149,242 77%35,717,353
CAPITAL REVENUES
Borrowing - DEQ Water Loan 2,287,300 2,603,753 114%
Capital Reserve Fees & Impact Fees 2,125,500 2,507,426 118%2,583,400
Capital Reserve Carryover Balances 2,407,200 0%5,500,200
Construction Funds 6,890,600 503,205 7%3,187,400
Contributed Capital 1,425,000 20,833 1%3,689,000
Engineering Billings 563,100 0%567,100
Fund Balances for Capital 2,747,100 0%2,924,200
Grants & Contributions 3,576,100 0%1,389,800
LID Funds 201,000 25,794 13%256,800
Trust Funds 2,019,400 956,004 47%2,024,800
TOTAL CAPITAL REVENUES 24,242,300 6,617,015 27%22,122,700
Contingent Operating Revenues 0%
Contingent Capital Revenues 0%
Internal Transfers In for Operations 4,554,900 2,406,099 53%4,451,300
Internal Transfers In for Capital 8,228,100 354,999 4%6,518,800
TOTAL REVENUES ALL FUNDS 72,292,000 36,527,355 51%68,810,153
OPERATIONS SUMMARY
TOTAL OPERATING REVENUES 39,821,600 29,555,341 77%40,168,653
TOTAL OPERATING EXPENDITURES 40,546,000 26,733,125 77%35,796,600
---NET OPERATIONS -724,400 2,822,216 4,372,053
CAPITAL SUMMARY
TOTAL CAPITAL REVENUES 32,470,400 6,972,014 27%28,641,500
TOTAL CAPITAL EXPENDITURES 31,746,000 6,772,574 30%19,494,800
---NET CAPITAL TRANSACTIONS 724,400 199,440 9,146,700
TOTAL ALL REVENUES 72,292,000 36,527,355 51%68,810,153
TOTAL ALL EXPENDITURES 72,292,000 33,505,699 46%55,291,400
NET ALL REVENUES OVER EXPENDITURES 0 3,021,656 13,518,753
CITY OF REXBURG CASH & INVESTMENT
FY 2020 BALANCE REPORT
Page 3
BALANCE AS
OF
CASH & INVESTMENTS < 1 YEAR 1-5 YEARS > 5 YEARS 7/31/2020
Bank of Commerce Bank CD 255,977 0.73%255,977
Bank of Commerce Legacy FM 28,462 0.08%28,462
Beehive Credit Union CD 250,152 0.71%250,152
Cash On Hand 4,950 0.01%4,950
City Golf Cart CD 68,940 0.20%68,940
East Idaho CU CD 251,639 0.71%251,639
Idaho Central Credit Union CD 250,025 0.71%250,025
Key Bank Checking (RLF)204,692 0.58%204,692
Moreton Asset Management 2,466,005 2,903,102 15.21%5,369,107
Mountain America Credit Union 250,331 0.71%250,331
Real Estate Investments (Streets)324,863 0.92%324,863
State Diversified Bond Fund 1,208,210 2,179,852 767,627 11.77%4,155,689
State LGIP--City 11,419,717 409,144 33.51%11,828,861
State LGIP--Fire District 601,126 21,537 1.76%622,663
TVI - Bond Investment 563,027 2,540,016 8.79%3,103,043
Wells Fargo Drug Fund Checking 14,417 0.04%14,417
Wells Fargo Fire District Banking 825,746 2.34%825,746
Westmark CD 251,212 0.71%251,212
Zions Bank Capital Advisors 3,554,893 1,629,703 14.69%5,184,596
Zions Bank Collateralized Acct 1,215,909 3.44%1,215,909
Zions Bank General Checking 819,600 2.32%819,600
Zions Bank Payroll Checking 19,949 0.06%19,949
TOTAL 24,849,842 9,683,354 767,627 100%35,300,823
% OF TOTAL PORTFOLIO 70.4%27.4%2.2%100%
I, Matthew K. Nielson, as Treasurer of the City of Rexburg, hereby under oath, certify to the best of my knowledge,
that the above accounting of expenses, revenues, and cash and investment balances is true and correct.
% of Total
Portfolio