HomeMy WebLinkAboutBudget Summary Report - Feb 2021CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2021 5 months ending
2/28/2021 Page 1
EXPENDITURES BUDGET ACTUAL 42%FORECAST
OPERATING EXPENDITURES
Misc. Departments/Categories
Arts 401,000 304,184 76%644,900
Building Safety 857,300 365,027 43%856,800
Customer Services 339,500 139,505 41%329,400
Economic Development 382,800 148,233 39%425,600
Emergency Services 4,478,300 2,028,161 45%4,582,000
Financial Management 1,145,700 328,094 29%868,600
GIS 361,000 155,882 43%361,400
Golf Courses 819,400 270,050 33%976,400
Human Resources 175,900 67,564 38%170,200
Information Technology 711,300 264,619 37%711,300
Legacy Flight Museum 73,500 9,608 13%73,500
Legal Services 287,300 123,628 43%287,300
Mayor, Council & Mayor's Youth Advisory Board 339,200 131,341 39%339,200
Miscellaneous 301,700 276,930 92%334,400
Parks & Ball Diamonds 785,000 221,505 28%784,700
Planning & Zoning 407,300 146,296 36%374,100
Recreation Administration & Programs 561,200 205,868 37%571,000
Rexburg Rapids 470,000 72,724 15%470,000
Total Misc. Departments/Categories 12,897,400 5,259,219 41%13,160,800
Police Department
Administration Division & Fund 09 1,473,300 680,062 46%1,515,000
Patrol Division & Funds 13 2,412,800 950,665 39%2,378,400
Investigations Division 788,900 342,062 43%824,400
Community Services Division & Funds 08,11,14 735,600 275,459 37%739,600
Support Service & Logistics 4,500 49,487 1100%64,500
Total Police Department 5,415,100 2,297,735 42%5,521,900
Public Works
Building Maintenance 66,500 20,489 31%66,500
Shop 578,700 217,015 38%578,700
Sanitation 2,532,900 1,051,471 42%2,530,400
Water 3,126,000 1,193,004 38%3,119,500
Wastewater - Treatment 3,090,900 1,233,134 40%3,088,100
Wastewater - Collections 1,742,200 727,232 42%1,748,200
Street Operations 2,913,300 818,380 28%3,000,600
Total Public Works 14,050,500 5,260,725 37%14,132,000
TOTAL OPERATING EXPENDITURES 32,363,000 12,817,679 40%32,814,700
CAPITAL EXPENDITURES
Engineering 574,000 239,056 42%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,138,700 2,339,329 21%14,603,300
Contributed Capital Offset 1,325,000 10,416 1%1,325,000
Capital Reserve Funds 07,18,20,33,34,35,38 1,372,900 39,643 3%1,416,900
LID Debt Service Funds 59-69 1,112,200 15,326 1%1,112,200
Trust & RLF Funds 15,16,19,21,22,90,91 573,300 17,012 3%510,300
TOTAL CAPITAL EXPENDITURES 17,299,700 2,660,782 15%19,745,300
Contingent Operating Expenses 4,879,300 0%4,897,000
Contingent Capital Expenses 5,113,300 0%2,635,700
Internal Transfers Out for Operations 3,708,100 945,624 26%3,914,400
Internal Transfers Out for Capital 8,135,500 104,166 1%9,948,100
TOTAL EXPENDITURES FOR ALL FUNDS 71,498,900 16,528,251 23%73,955,200
CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2021 5 months ending
2/28/2021 Page 2
REVENUES BUDGET ACTUAL 42%FORECAST
OPERATING REVENUES
County Road Tax 870,000 360,947 41%870,000
Federal Grants 2,564,099 2,457,469 96%3,102,900
Franchise Fees 1,777,700 566,145 32%1,776,400
Fund Balances for Operations 3,455,201 0%2,942,400
Investment Earnings 129,100 59,099 46%128,500
Unrealized Gain (Loss)-28,224 0%
Interfund Charges for Services - Overhead 3,441,800 1,414,708 41%3,440,300
Miscellaneous 517,300 180,890 35%516,700
Operating Contributions 3,199,300 744,899 23%3,197,000
Parks, Recreation, Museums, Arts, Golf 1,471,200 174,422 12%1,578,800
Permits & Licenses 760,300 357,508 47%760,300
Property Tax 4,152,200 2,549,194 61%4,152,200
State Taxes & Grants 3,654,900 994,515 27%4,229,100
Utility Charges -Water 3,258,300 1,117,204 34%3,258,300
Utility Charges -Wastewater 5,201,900 2,150,408 41%5,201,900
Utility Charges -Sanitation 2,526,000 1,121,460 44%2,526,000
TOTAL OPERATING REVENUES 36,979,300 14,220,644 38%37,680,800
CAPITAL REVENUES
Borrowing - DEQ Water Loan 1,473,000 0%1,473,000
Capital Reserve Fees & Impact Fees 2,094,300 577,493 28%2,124,200
Capital Reserve Carryover Balances 6,464,000 0%7,308,600
Construction Funds 3,556,100 122,589 3%6,202,900
Contributed Capital 825,000 10,416 1%825,000
Engineering Billings 574,000 0%574,000
Fund Balances for Capital 1,727,900 0%1,548,000
Grants & Contributions 3,547,100 163,939 5%1,225,000
LID Funds 330,700 21,623 7%1,635,000
Trust Funds 2,104,400 601,357 29%2,238,400
TOTAL CAPITAL REVENUES 22,696,500 1,497,417 7%25,154,100
Contingent Operating Revenues 0%
Contingent Capital Revenues 0%
Internal Transfers In for Operations 3,682,600 1,269,049 34%3,888,900
Internal Transfers In for Capital 8,140,500 219,583 3%9,953,100
TOTAL REVENUES ALL FUNDS 71,498,900 17,206,693 24%76,676,900
OPERATIONS SUMMARY
TOTAL OPERATING REVENUES 40,661,900 15,489,693 38%41,569,700
TOTAL OPERATING EXPENDITURES 40,950,400 13,763,303 40%41,626,100
---NET OPERATIONS -288,500 1,726,390 -56,400
CAPITAL SUMMARY
TOTAL CAPITAL REVENUES 30,837,000 1,717,000 7%35,107,200
TOTAL CAPITAL EXPENDITURES 30,548,500 2,764,948 15%32,329,100
---NET CAPITAL TRANSACTIONS 288,500 -1,047,948 2,778,100
TOTAL ALL REVENUES 71,498,900 17,206,693 24%76,676,900
TOTAL ALL EXPENDITURES 71,498,900 16,528,251 23%73,955,200
NET ALL REVENUES OVER EXPENDITURES 0 678,442 2,721,700
CITY OF REXBURG CASH & INVESTMENT
FY 2021 BALANCE REPORT
Page 3
BALANCE AS
OF
CASH & INVESTMENTS < 1 YEAR 1-5 YEARS > 5 YEARS 2/28/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 250,152 0.71%250,152
Cash On Hand 2,970 0.01%2,970
City Golf Cart CD 68,940 0.20%68,940
East Idaho CU CD 254,502 0.72%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,015 3,209,691 15.32%5,382,706
Mountain America Credit Union 251,090 0.71%251,090
Real Estate Investments (Streets)326,663 0.93%326,663
State Diversified Bond Fund 1,209,461 2,182,111 768,423 11.84%4,159,995
State LGIP--City 6,491,013 232,559 19.13%6,723,572
State LGIP--Fire District 602,040 21,570 1.77%623,610
TVI - Bond Investment 721,236 2,339,758 589,470 10.39%3,650,463
Wells Fargo Drug Fund Checking 14,417 0.04%14,417
Wells Fargo Fire District Banking 1,084,677 3.09%1,084,677
Westmark CD 254,847 0.73%254,847
Zions Bank Capital Advisors 3,574,975 1,628,685 14.81%5,203,660
Zions Bank Collateralized Acct 4,755,907 13.53%4,755,907
Zions Bank General Checking 1,331,891 3.79%1,331,891
Zions Bank Payroll Checking 20,090 0.06%20,090
TOTAL 24,168,287 9,614,373 1,357,893 100%35,140,553
% OF TOTAL PORTFOLIO 68.8%27.4%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