HomeMy WebLinkAboutBudget Summary Report - Dec 2020CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2021 3 months ending
12/31/2020 Page 1
EXPENDITURES BUDGET ACTUAL 25%FORECAST
OPERATING EXPENDITURES
Misc. Departments/Categories
Arts 401,000 171,511 43%636,600
Building Safety 851,800 249,827 29%856,800
Customer Services 329,400 90,408 27%329,400
Economic Development 375,600 102,386 27%425,600
Emergency Services 4,478,300 1,395,141 31%4,478,300
Financial Management 868,300 212,806 25%868,600
GIS 361,000 108,295 30%361,400
Golf Courses 859,500 193,270 22%869,500
Human Resources 170,200 41,125 24%170,200
Information Technology 711,300 163,517 23%711,300
Legacy Flight Museum 73,500 6,803 9%73,500
Legal Services 287,300 80,987 28%287,300
Mayor, Council & Mayor's Youth Advisory Board 339,200 84,211 25%339,200
Miscellaneous 44,700 255,135 571%468,100
Parks & Ball Diamonds 784,700 149,417 19%784,700
Planning & Zoning 374,100 90,090 24%374,100
Recreation Administration & Programs 557,200 109,183 20%561,400
Rexburg Rapids 579,800 29,008 5%470,000
Total Misc. Departments/Categories 12,446,900 3,533,120 28%13,066,000
Police Department
Administration Division & Fund 09 1,498,000 417,588 28%1,513,000
Patrol Division & Funds 13 2,331,400 582,382 25%2,378,400
Investigations Division 824,400 224,736 27%824,400
Community Services Division & Funds 08,11,14 739,600 171,314 23%739,600
Support Service & Logistics 0 36,278 4,700
Total Police Department 5,393,400 1,432,298 27%5,460,100
Public Works
Building Maintenance 66,500 12,276 18%66,500
Shop 578,700 133,389 23%578,700
Sanitation 2,530,400 636,952 25%2,530,400
Water 3,119,500 724,565 23%3,119,500
Wastewater - Treatment 3,088,100 705,300 23%3,088,100
Wastewater - Collections 1,736,200 463,283 27%1,736,200
Street Operations 2,903,100 486,693 17%2,999,700
Total Public Works 14,022,500 3,162,458 23%14,119,100
TOTAL OPERATING EXPENDITURES 31,862,800 8,127,876 26%32,645,200
CAPITAL EXPENDITURES
Engineering 574,000 146,933 26%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 10,335,100 1,376,744 13%14,303,100
Contributed Capital Offset 1,325,000 6,249 0%1,325,000
Capital Reserve Funds 07,18,20,33,34,35,38 1,386,400 14,177 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 11,526 2%510,300
TOTAL CAPITAL EXPENDITURES 16,509,600 1,555,629 9%19,401,100
Contingent Operating Expenses 4,492,000 0%4,975,400
Contingent Capital Expenses 4,854,500 0%4,555,900
Internal Transfers Out for Operations 3,674,900 567,374 15%3,914,400
Internal Transfers Out for Capital 7,735,400 62,499 1%9,629,000
TOTAL EXPENDITURES FOR ALL FUNDS 69,129,200 10,313,378 15%75,121,000
CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2021 3 months ending
12/31/2020 Page 2
REVENUES BUDGET ACTUAL 25%FORECAST
OPERATING REVENUES
County Road Tax 870,000 35,012 4%870,000
Federal Grants 649,200 1,955,313 301%3,358,317
Franchise Fees 1,777,700 156,299 9%1,777,200
Fund Balances for Operations 3,077,600 0%2,991,500
Investment Earnings 129,100 30,545 24%128,500
Unrealized Gain (Loss)-11,793 0%
Interfund Charges for Services - Overhead 3,441,800 849,075 25%3,440,300
Miscellaneous 517,300 94,803 18%516,500
Operating Contributions 3,195,300 473,015 15%3,189,000
Parks, Recreation, Museums, Arts, Golf 1,471,200 130,192 9%1,467,700
Permits & Licenses 760,300 199,461 26%760,300
Property Tax 5,554,500 267,531 5%4,152,200
State Taxes & Grants 3,129,900 -4,482 0%4,229,100
Utility Charges -Water 3,258,300 722,216 22%3,258,300
Utility Charges -Wastewater 5,201,900 1,298,659 25%5,201,900
Utility Charges -Sanitation 2,526,000 666,923 26%2,526,000
TOTAL OPERATING REVENUES 35,560,100 6,862,769 19%37,866,817
CAPITAL REVENUES
Borrowing - DEQ Water Loan 1,473,000 0%1,473,000
Capital Reserve Fees & Impact Fees 2,094,300 142,613 7%2,094,300
Capital Reserve Carryover Balances 6,353,500 0%7,308,600
Construction Funds 3,528,900 79,117 2%6,460,900
Contributed Capital 825,000 6,249 1%825,000
Engineering Billings 574,000 0%574,000
Fund Balances for Capital 1,298,300 0%1,527,500
Grants & Contributions 3,547,100 -33,876 -1%1,224,600
LID Funds 330,700 7,436 2%1,635,000
Trust Funds 2,104,400 30,600 1%2,238,400
TOTAL CAPITAL REVENUES 22,129,200 232,139 1%25,361,300
Contingent Operating Revenues 0%
Contingent Capital Revenues 0%
Internal Transfers In for Operations 4,205,200 560,999 13%4,227,100
Internal Transfers In for Capital 7,234,700 68,749 1%9,345,900
TOTAL REVENUES ALL FUNDS 69,129,200 7,724,656 11%76,801,117
OPERATIONS SUMMARY
TOTAL OPERATING REVENUES 39,765,300 7,423,768 19%42,093,917
TOTAL OPERATING EXPENDITURES 40,029,700 8,695,250 26%41,535,000
---NET OPERATIONS -264,400 -1,271,482 558,917
CAPITAL SUMMARY
TOTAL CAPITAL REVENUES 29,363,900 300,888 1%34,707,200
TOTAL CAPITAL EXPENDITURES 29,099,500 1,618,128 9%33,586,000
---NET CAPITAL TRANSACTIONS 264,400 -1,317,240 1,121,200
TOTAL ALL REVENUES 69,129,200 7,724,656 11%76,801,117
TOTAL ALL EXPENDITURES 69,129,200 10,313,378 15%75,121,000
NET ALL REVENUES OVER EXPENDITURES 0 -2,588,722 1,680,117
CITY OF REXBURG CASH & INVESTMENT
FY 2021 BALANCE REPORT
Page 3
BALANCE AS
OF
CASH & INVESTMENTS < 1 YEAR 1-5 YEARS > 5 YEARS 12/31/2020
Bank of Commerce Bank CD 257,802 0.83%257,802
Bank of Commerce Legacy FM 36,926 0.12%36,926
Beehive Credit Union CD 250,152 0.81%250,152
Cash On Hand 1,570 0.01%1,570
City Golf Cart CD 68,940 0.22%68,940
East Idaho CU CD 253,066 0.82%253,066
Idaho Central Credit Union CD 250,025 0.81%250,025
Key Bank Checking (RLF)233,809 0.76%233,809
Moreton Asset Management 2,171,246 3,209,691 17.41%5,380,937
Mountain America Credit Union 250,710 0.81%250,710
Real Estate Investments (Streets)326,663 1.06%326,663
State Diversified Bond Fund 1,208,117 2,179,687 767,569 13.44%4,155,373
State LGIP--City 5,547,810 198,766 18.59%5,746,576
State LGIP--Fire District 602,040 21,570 2.02%623,610
TVI - Bond Investment 723,958 2,339,758 589,470 11.82%3,653,185
Wells Fargo Drug Fund Checking 14,417 0.05%14,417
Wells Fargo Fire District Banking 536,131 1.73%536,131
Westmark CD 253,645 0.82%253,645
Zions Bank Capital Advisors 3,572,687 1,628,685 16.83%5,201,372
Zions Bank Collateralized Acct 2,755,728 8.92%2,755,728
Zions Bank General Checking 638,263 2.06%638,263
Zions Bank Payroll Checking 20,000 0.06%20,000
TOTAL 19,973,705 9,578,156 1,357,039 100%30,908,900
% OF TOTAL PORTFOLIO 64.6%31.0%4.4%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