HomeMy WebLinkAboutBudget Summary Report - Jan 2020CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2021 4 months ending
1/31/2021 Page 1
EXPENDITURES BUDGET ACTUAL 33%FORECAST
OPERATING EXPENDITURES
Misc. Departments/Categories
Arts 401,000 202,812 51%642,600
Building Safety 857,300 303,373 35%856,800
Customer Services 339,500 115,230 34%329,400
Economic Development 382,800 126,808 33%425,600
Emergency Services 4,478,300 1,722,529 38%4,567,300
Financial Management 1,145,700 272,762 24%868,600
GIS 361,000 132,266 37%361,400
Golf Courses 819,400 225,206 27%905,800
Human Resources 175,900 54,310 31%170,200
Information Technology 711,300 212,132 30%711,300
Legacy Flight Museum 73,500 8,607 12%73,500
Legal Services 287,300 102,553 36%287,300
Mayor, Council & Mayor's Youth Advisory Board 339,200 106,917 32%339,200
Miscellaneous 124,700 265,019 213%325,100
Parks & Ball Diamonds 785,000 180,123 23%784,700
Planning & Zoning 407,300 112,969 28%374,100
Recreation Administration & Programs 561,200 149,435 27%571,000
Rexburg Rapids 470,000 63,176 13%470,000
Total Misc. Departments/Categories 12,720,400 4,356,227 34%13,063,900
Police Department
Administration Division & Fund 09 1,473,300 548,958 37%1,513,000
Patrol Division & Funds 13 2,412,800 762,617 32%2,378,400
Investigations Division 788,900 280,686 36%824,400
Community Services Division & Funds 08,11,14 735,600 221,873 30%739,600
Support Service & Logistics 4,500 46,180 1026%64,500
Total Police Department 5,415,100 1,860,314 34%5,519,900
Public Works
Building Maintenance 66,500 15,937 24%66,500
Shop 578,700 171,649 30%578,700
Sanitation 2,532,900 779,893 31%2,530,400
Water 3,126,000 835,210 27%3,119,500
Wastewater - Treatment 3,090,900 869,896 28%3,088,100
Wastewater - Collections 1,742,200 509,615 29%1,736,200
Street Operations 2,913,300 620,550 21%2,999,700
Total Public Works 14,050,500 3,802,750 27%14,119,100
TOTAL OPERATING EXPENDITURES 32,186,000 10,019,291 31%32,702,900
CAPITAL EXPENDITURES
Engineering 574,000 186,716 33%574,000
Street Repair Contracts 1,203,600 0%203,600
Construction 06,30,31,32,39,41,42,44,46,49,51-58,82,84,85 11,108,700 1,906,241 17%14,331,400
Contributed Capital Offset 1,325,000 6,249 0%1,325,000
Capital Reserve Funds 07,18,20,33,34,35,38 1,372,900 17,656 1%1,372,900
LID Debt Service Funds 59-69 1,112,200 0%1,112,200
Trust & RLF Funds 15,16,19,21,22,90,91 573,300 12,342 2%510,300
TOTAL CAPITAL EXPENDITURES 17,269,700 2,129,204 12%19,429,400
Contingent Operating Expenses 4,899,300 0%4,897,000
Contingent Capital Expenses 5,113,300 0%4,555,900
Internal Transfers Out for Operations 3,708,100 567,374 15%3,914,400
Internal Transfers Out for Capital 8,115,500 62,499 1%9,948,100
TOTAL EXPENDITURES FOR ALL FUNDS 71,291,900 12,778,368 18%75,447,700
CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2021 4 months ending
1/31/2021 Page 2
REVENUES BUDGET ACTUAL 33%FORECAST
OPERATING REVENUES
County Road Tax 870,000 341,517 39%870,000
Federal Grants 729,200 2,322,000 318%3,089,200
Franchise Fees 1,777,700 454,663 26%1,777,200
Fund Balances for Operations 3,710,800 0%2,942,400
Investment Earnings 129,100 48,562 38%128,500
Unrealized Gain (Loss)-19,028 0%
Interfund Charges for Services - Overhead 3,441,800 848,825 25%3,440,300
Miscellaneous 517,300 144,262 28%516,500
Operating Contributions 3,199,300 621,995 19%3,197,000
Parks, Recreation, Museums, Arts, Golf 1,471,200 157,200 11%1,578,800
Permits & Licenses 760,300 234,860 31%760,300
Property Tax 5,554,500 2,419,103 44%4,152,200
State Taxes & Grants 3,654,900 994,368 27%4,229,100
Utility Charges -Water 3,258,300 920,714 28%3,258,300
Utility Charges -Wastewater 5,201,900 1,720,602 33%5,201,900
Utility Charges -Sanitation 2,526,000 895,563 35%2,526,000
TOTAL OPERATING REVENUES 36,802,300 12,105,206 33%37,667,700
CAPITAL REVENUES
Borrowing - DEQ Water Loan 1,473,000 0%1,473,000
Capital Reserve Fees & Impact Fees 2,094,300 524,439 25%2,094,300
Capital Reserve Carryover Balances 6,464,000 0%7,308,600
Construction Funds 3,546,100 101,721 3%6,203,000
Contributed Capital 825,000 6,249 1%825,000
Engineering Billings 574,000 0%574,000
Fund Balances for Capital 1,727,900 0%1,527,500
Grants & Contributions 3,547,100 -33,876 -1%1,224,600
LID Funds 330,700 13,109 4%1,635,000
Trust Funds 2,104,400 600,638 29%2,238,400
TOTAL CAPITAL REVENUES 22,686,500 1,212,280 5%25,103,400
Contingent Operating Revenues 0%
Contingent Capital Revenues 0%
Internal Transfers In for Operations 3,682,600 560,999 15%3,888,900
Internal Transfers In for Capital 8,120,500 68,749 1%9,953,100
TOTAL REVENUES ALL FUNDS 71,291,900 13,947,234 20%76,613,100
OPERATIONS SUMMARY
TOTAL OPERATING REVENUES 40,484,900 12,666,205 33%41,556,600
TOTAL OPERATING EXPENDITURES 40,793,400 10,586,665 31%41,514,300
---NET OPERATIONS -308,500 2,079,540 42,300
CAPITAL SUMMARY
TOTAL CAPITAL REVENUES 30,807,000 1,281,029 5%35,056,500
TOTAL CAPITAL EXPENDITURES 30,498,500 2,191,703 12%33,933,400
---NET CAPITAL TRANSACTIONS 308,500 -910,674 1,123,100
TOTAL ALL REVENUES 71,291,900 13,947,234 20%76,613,100
TOTAL ALL EXPENDITURES 71,291,900 12,778,368 18%75,447,700
NET ALL REVENUES OVER EXPENDITURES 0 1,168,866 1,165,400
CITY OF REXBURG CASH & INVESTMENT
FY 2021 BALANCE REPORT
Page 3
BALANCE AS
OF
CASH & INVESTMENTS < 1 YEAR 1-5 YEARS > 5 YEARS 1/31/2021
Bank of Commerce Bank CD 259,641 0.74%259,641
Bank of Commerce Legacy FM 36,926 0.11%36,926
Beehive Credit Union CD 251,355 0.72%251,355
Cash On Hand 1,570 0.00%1,570
City Golf Cart CD 68,940 0.20%68,940
East Idaho CU CD 254,502 0.73%254,502
Idaho Central Credit Union CD 250,025 0.71%250,025
Key Bank Checking (RLF)233,809 0.67%233,809
Moreton Asset Management 2,173,349 3,209,691 15.37%5,383,040
Mountain America Credit Union 251,090 0.72%251,090
Real Estate Investments (Streets)326,663 0.93%326,663
State Diversified Bond Fund 1,208,117 2,179,687 767,569 11.87%4,155,373
State LGIP--City 6,489,596 232,508 19.20%6,722,104
State LGIP--Fire District 602,040 21,570 1.78%623,610
TVI - Bond Investment 721,236 2,339,758 589,470 10.43%3,650,463
Wells Fargo Drug Fund Checking 14,417 0.04%14,417
Wells Fargo Fire District Banking 1,098,608 3.14%1,098,608
Westmark CD 253,645 0.72%253,645
Zions Bank Capital Advisors 3,575,933 1,628,685 14.86%5,204,618
Zions Bank Collateralized Acct 1,755,816 5.01%1,755,816
Zions Bank General Checking 4,198,816 11.99%4,198,816
Zions Bank Payroll Checking 19,997 0.06%19,997
TOTAL 24,046,091 9,611,898 1,357,039 100%35,015,028
% OF TOTAL PORTFOLIO 68.7%27.5%3.9%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