HomeMy WebLinkAboutBudget Summary Report - Apr 2020CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2020 7 months ending
4/30/2020 Page 1
EXPENDITURES BUDGET ACTUAL 58%FORECAST
OPERATING EXPENDITURES
Misc. Departments/Categories
Arts 645,400 189,046 29%659,500
Building Safety 839,600 476,400 57%795,200
Customer Services 316,200 189,295 60%314,200
Economic Development 396,400 217,957 55%338,700
Emergency Services 4,634,200 2,212,291 48%4,372,200
Financial Management 894,400 520,062 58%853,300
GIS 427,400 250,116 59%411,400
Golf Courses 813,200 321,595 40%851,100
Human Resources 145,100 83,867 58%141,600
Information Technology 695,600 414,587 60%687,100
Legacy Flight Museum 117,900 27,563 23%96,000
Legal Services 273,000 162,321 59%271,700
Mayor, Council & Mayor's Youth Advisory Board 328,100 188,572 57%322,700
Miscellaneous 49,300 16,529 34%49,300
Parks & Ball Diamonds 732,800 319,359 44%751,700
Planning & Zoning 385,400 204,039 53%349,900
Recreation Administration & Programs 547,600 286,434 52%517,000
Rexburg Rapids 726,200 273,949 38%645,100
Total Misc. Departments/Categories 12,967,800 6,353,982 49%12,427,700
Police Department
Administration Division & Fund 09 1,363,500 827,855 61%1,420,000
Patrol Division & Funds 13 2,385,800 1,272,242 53%2,249,800
Investigations Division 750,900 467,578 62%777,600
Community Services Division & Funds 08,11,14 731,800 411,363 56%717,100
Total Police Department 5,232,000 2,979,038 57%5,164,500
Public Works
Building Maintenance 52,800 25,429 48%50,300
Shop 610,700 365,162 60%616,400
Sanitation 2,266,500 1,283,553 57%2,309,500
Water 3,039,100 1,588,544 52%3,098,100
Wastewater - Treatment 2,976,900 1,799,935 60%3,079,600
Wastewater - Collections 1,735,400 984,201 57%1,627,600
Street Operations 2,669,700 1,649,548 62%2,753,600
Total Public Works 13,351,100 7,696,372 58%13,535,100
TOTAL OPERATING EXPENDITURES 31,550,900 17,029,392 54%31,127,300
CAPITAL EXPENDITURES
Engineering 563,800 329,973 59%567,100
Street Repair Contracts 150,400 202,671 135%554,900
Construction 06,30,31,32,39,41,42,44,46,49,51-58,82,84,85 14,776,500 3,676,724 25%11,223,100
Contributed Capital Offset 1,675,000 14,583 1%1,075,000
Capital Reserve Funds 07,18,20,33,34,35,38 627,200 179,881 29%502,400
LID Debt Service Funds 59-69 1,169,600 78,754 7%945,100
Trust & RLF Funds 15,16,19,21,22,90,91 554,600 54,666 10%148,400
TOTAL CAPITAL EXPENDITURES 19,517,100 4,537,252 23%15,016,000
Contingent Operating Expenses 4,136,600 0%30,700
Contingent Capital Expenses 2,269,400 0%25,900
Internal Transfers Out for Operations 4,385,300 1,800,799 41%4,494,400
Internal Transfers Out for Capital 6,180,000 265,416 4%5,908,500
TOTAL EXPENDITURES FOR ALL FUNDS 68,039,300 23,632,859 35%56,602,800
CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2020 7 months ending
4/30/2020 Page 2
REVENUES BUDGET ACTUAL 58%FORECAST
OPERATING REVENUES
County Road Tax 890,000 496,227 56%870,000
Federal Grants 844,600 47,405 6%634,000
Franchise Fees 1,771,400 907,521 51%1,754,100
Fund Balances for Operations 2,246,600 0%2,681,200
Investment Earnings 198,600 77,140 39%147,700
Unrealized Gain (Loss)55,454 0%
Interfund Charges for Services - Overhead 3,381,300 1,950,492 58%3,384,000
Miscellaneous 543,000 318,941 59%500,600
Operating Contributions 3,234,300 1,618,067 50%3,181,700
Parks, Recreation, Museums, Arts, Golf 1,380,600 447,135 32%1,219,800
Permits & Licenses 786,600 612,907 78%849,200
Property Tax 5,054,700 3,200,321 63%5,054,700
State Taxes & Grants 3,700,200 1,679,903 45%3,905,100
Utility Charges -Water 3,169,300 1,526,623 48%3,195,000
Utility Charges -Wastewater 5,127,800 3,035,533 59%5,126,000
Utility Charges -Sanitation 2,299,300 1,463,370 64%2,424,300
TOTAL OPERATING REVENUES 34,628,300 17,437,039 50%34,927,400
CAPITAL REVENUES
Borrowing - DEQ Water Loan 1,305,300 575,237 44%
Capital Reserve Fees & Impact Fees 2,125,500 1,726,856 81%2,575,900
Capital Reserve Carryover Balances 2,195,500 0%5,500,200
Construction Funds 7,382,400 150,316 2%4,350,800
Contributed Capital 1,425,000 14,583 1%3,689,000
Engineering Billings 563,100 0%567,100
Fund Balances for Capital 1,147,100 0%2,924,200
Grants & Contributions 3,331,800 0%889,800
LID Funds 201,000 24,230 12%256,800
Trust Funds 2,019,400 639,664 32%2,024,800
TOTAL CAPITAL REVENUES 21,696,100 3,130,886 14%22,778,600
Contingent Operating Revenues 0%
Contingent Capital Revenues 0%
Internal Transfers In for Operations 4,359,800 1,727,591 40%4,468,900
Internal Transfers In for Capital 7,355,100 338,333 5%6,312,600
TOTAL REVENUES ALL FUNDS 68,039,300 22,633,849 33%68,487,500
OPERATIONS SUMMARY
TOTAL OPERATING REVENUES 38,988,100 19,164,630 50%39,396,300
TOTAL OPERATING EXPENDITURES 40,072,800 18,830,191 54%35,652,400
---NET OPERATIONS -1,084,700 334,439 3,743,900
CAPITAL SUMMARY
TOTAL CAPITAL REVENUES 29,051,200 3,469,219 14%29,091,200
TOTAL CAPITAL EXPENDITURES 27,966,500 4,802,668 23%20,950,400
---NET CAPITAL TRANSACTIONS 1,084,700 -1,333,449 8,140,800
TOTAL ALL REVENUES 68,039,300 22,633,849 33%68,487,500
TOTAL ALL EXPENDITURES 68,039,300 23,632,859 35%56,602,800
NET ALL REVENUES OVER EXPENDITURES 0 -999,010 11,884,700
CITY OF REXBURG CASH & INVESTMENT
FY 2020 BALANCE REPORT
Page 3
BALANCE AS
OF
CASH & INVESTMENTS < 1 YEAR 1-5 YEARS > 5 YEARS 4/30/2020
Bank of Commerce Bank CD 254,165 0.81%254,165
Bank of Commerce Legacy FM 42,003 0.13%42,003
Beehive Credit Union CD 250,152 0.80%250,152
Cash On Hand 2,550 0.01%2,550
City Golf Cart CD 91,920 0.29%91,920
East Idaho CU CD 250,000 0.80%250,000
Idaho Central Credit Union CD 250,000 0.80%250,000
Idaho Central Credit Union Savings 25 0.00%25
Key Bank Checking (RLF)373,959 1.19%373,959
Moreton Asset Management 2,320,171 2,992,537 16.91%5,312,708
Mountain America Credit Union 250,000 0.80%250,000
Real Estate Investments (Streets)324,863 1.03%324,863
State Diversified Bond Fund 1,196,413 2,158,568 760,132 13.10%4,115,113
State LGIP--City 6,480,666 232,188 21.36%6,712,854
State LGIP--Fire District 596,101 21,357 1.96%617,458
TVI - Bond Investment 0 2,990,016 9.51%2,990,016
Wells Fargo Drug Fund Checking 14,416 0.05%14,416
Wells Fargo Fire District Banking 530,030 1.69%530,030
Westmark CD 249,985 0.80%249,985
Zions Bank Capital Advisors 3,278,610 1,880,635 16.42%5,159,245
Zions Bank Collateralized Acct 2,215,883 7.05%2,215,883
Zions Bank General Checking 1,397,665 4.45%1,397,665
Zions Bank Payroll Checking 20,000 0.06%20,000
TOTAL 20,389,577 10,275,301 760,132 100%31,425,010
% OF TOTAL PORTFOLIO 64.9%32.7%2.4%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