|
Fiscal Year 2023 12/31/2020
<br />ACTUAL
<br />2018
<br />ACTUAL
<br />2019
<br />ACTUAL
<br />2020
<br />ACTUAL
<br />2021
<br />BUDGET
<br />2022
<br />EST. ACTUAL
<br />2022
<br />BUDGET
<br />2023
<br />GENERAL FUND EXPENDITURES DETAIL
<br />PARKS
<br />101-4110-51-0000 PR REGULAR EMPLOYEE 109,030$ 112,855$ 105,447$ 110,163$ 119,450$ 124,699$ 131,583$ 10.16% INCLUDES ESTIMATED WAGE ADJUSTMENTS
<br />101-4110-51-0100 TW REGULAR EMPLOYEE 29,007 29,970 29,401 31,510 32,373 32,575 34,854 7.66% INCLUDES ESTIMATED WAGE ADJUSTMENTS
<br />101-4110-51-0200 PR COMMITTEE 180 200 600 330 600 600 600 0.00% Parks commission all opt-in for pay
<br />101-4111-51-0000 PR OVERTIME EMPLOYEE 1,827 2,216 1,654 2,163 2,588 1,920 2,600 0.48% BASED ON EE MAPPING
<br />101-4111-51-0100 TW OVERTIME EMPLOYEE 1,048 1,176 575 1,013 1,035 1,075 1,250 20.77% BASED ON EE MAPPING
<br />101-4121-51-0000 PR PERA 8,606 8,807 8,630 8,162 9,153 9,496 10,064 9.95% BASED ON CURRENT PERA FUNDING RATE
<br />101-4121-51-0100 TW PERA 2,343 2,424 2,445 2,533 2,506 2,524 2,708 8.07% BASED ON CURRENT PERA FUNDING RATE
<br />101-4122-51-0000 PR FICA/MEDICARE 8,767 9,003 8,667 9,409 9,382 9,732 10,311 9.90% BASED ON ER 7.65% OF GROSS
<br />101-4122-51-0100 TW FICA/MEDICARE 2,357 2,459 2,486 2,588 2,556 2,574 2,762 8.07% BASED ON ER 7.65% OF GROSS
<br />101-4131-51-0000 PR INSURANCE HEALTH 21,306 22,380 23,441 21,865 28,369 29,575 31,791 12.06% SPLIT 10.85% PREMUIM INCREASE 2023/CURRENT ELECTIONS
<br />101-4131-51-0100 TW INSURANCE HEALTH 5,004 5,277 5,615 6,011 5,873 6,989 6,444 9.72% SPLIT 10.85% PREMUIM INCREASE 2023
<br />101-4135-51-0000 PR INSURANCE WC 3,286 3,641 4,255 4,482 5,524 5,524 6,315 14.32% BASED ON 2022/2023 RENEWAL and 23/24 LMC rate information
<br />101-4135-51-0100 TW INSURANCE WC 2,191 2,455 2,837 2,584 3,683 3,683 4,210 14.31% BASED ON 2022/2023 RENEWAL and 23/24 LMC rate information
<br />101-4212-51-0000 PW FUEL - STREET/PARKS - 633 40 - - - - 0.00% PW FUELS USE CONSOLIDATED UNDER STREETS DEPT
<br />101-4226-51-0000 PR GENERAL SUPPLIES 14,357 15,538 15,700 18,005 17,500 19,200 20,352 16.30% 2023 PROJECTED RUNRATE
<br />101-4310-51-0100 TW MISC. CONTRACTED SERVICES - 190 - - - - - 0.00% coded to 4338
<br />101-4325-51-0000 PR COMMUNICATIONS 1,622 1,522 1,693 1,820 1,834 3,647 4,400 139.91% BASED ON COMMUNICATION SPREADSHEET, CENTURYLINK 2022 FOR PARKS
<br />101-4325-51-0100 TW COMMUNICATIONS 197 147 67 71 204 - - -100.00% BASED ON COMMUNICATION SPREADSHEET, ADDED TO PARKS
<br />101-4337-51-0000 PR STRUCTURES REPAIRS & MAINT.12,365 6,682 1,356 5,650 15,650 9,500 10,250 -34.50% 2023 PROJECTED RUNRATE
<br />101-4338-51-0100 TW TREE REPLACEMENT 583 3,796 2,778 2,174 4,000 5,910 3,250 -18.75% 2023 PROJECTED RUNRATE
<br />101-4339-51-0000 PR EQUIP REPAIRS & MAINTENANCE 7,857 11,090 8,776 17,442 11,500 15,100 16,610 44.43% 2023 PROJECTED RUNRATE
<br />101-4339-51-0100 TW EQUIP REPAIRS & MAINTENANCE - - 691 - 350 750 500 42.86% 2023 PROJECTED RUNRATE
<br />101-4381-51-0000 PR ELECTRIC AND GAS UTILITIES 19,316 19,389 15,870 35,509 25,650 35,147 37,959 47.99% 2023 PROJECTED RUNRATE
<br />101-4415-51-0000 PR SS RENTALS 1,821 2,820 2,122 3,992 3,450 2,675 2,836 -17.81% 2023 PROJECTED RUNRATE
<br />101-4499-51-0000 PR MISCELLANEOUS - - - - 110 110 125 13.22% 2023 PROJECTED RUNRATE
<br />101-4499-51-0100 TW MISCELLANEOUS 646 - - - 110 110 125 13.22% 2023 PROJECTED RUNRATE
<br />101-4671-61-0000 CS ISD 282 REC PROGRAMS 52,176 52,176 52,176 52,176 52,176 52,176 52,176 0.00% Annual Fixed amount
<br />TOTAL 305,892$ 316,846$ 297,321$ 339,653$ 355,625$ 375,292$ 394,074$ 10.81%
<br />OTHER EXPENDITURES AND TRANSFERS
<br />101-4335-70-0000 INSURANCE CLAIMS 14,384 8,710 14,606$ 9,350 15,000 8,500 15,000 0.00%
<br />101-4343-70-0000 EQUITY INTITIATIVE 5,119 9,008 1,438 13,305 10,000 11,104 10,000 0.00% Established funding and specific tracking of initiative costs
<br />101-4346-70-0000 COLLABORATIVE INTITIATIVE 1,055 11,573 2,464 6,375 10,000 7,467 10,000 0.00% Established funding and specific tracking of initiative costs
<br />101-4347-70-0000 PROPERTY RESOURCE INTITIATIVE - 593 - - 10,000 - - -100.00% Housing resource move to HRA Fund as aligns with fund's activity
<br />101-4348-70-0000 SUSTAINABILITY INTITIATIVE 2,601 22,400 2,772 4,622 17,500 4,500 25,000 42.86% Established funding and specific tracking of initiative costs
<br />101-4499-70-0000 NB MISCELLANEOUS 6,298 25,947 7,195 - 20,000 17,900 - -100.00% 2022 COMMUNITY SURVEY
<br />101-4499-23-0000 DATA PROD/COVID-19/ EE RETENTION 176,371 135,233 379,334 16,325 - - 27,209 0.00% 2020 -2021 COVID 19 RELATED EXP/ 2023 EE RETENTION
<br />101-4920-70-0000 TRANSFER - SEVERENCE FUND 86,300 86,300 86,300 86,300 86,300 86,300 86,300 0.00% ANNUAL TRANSFER
<br />101-4920-70-0000 TRANSFER - HRA PROJECTS FUND - - - - - - - 0.00%
<br />101-4920-70-0000 TRANSFER - HRA FUND - - - - - - - 0.00%
<br />101-4920-70-0000 TRANSFER - OTHER - - 2,500 367,845 - - - 0.00% 2020 RECYCLING FUND / EST. 2021 EXCESS FUND BAL TRANSFER
<br />TOTAL 292,128$ 299,764$ 496,609$ 504,122$ 168,800$ 135,771$ 173,509$ 2.79%
<br />TOTAL FUND EXPENDITURES 7,029,590$ 7,272,412$ 7,652,254$ 8,211,634$ 8,013,767$ 7,943,857$ 8,774,588$ 9.49%
<br />TOTAL FUND REVENUE 7,137,235$ 7,355,442$ 8,459,454$ 8,690,430$ 8,027,488$ 8,027,488$ 8,788,038$ 9.47%
<br />with 20k hi coverage
<br />CHANGE IN FUND BALANCE 107,646$ 83,030$ 807,201$ 478,796$ 13,720$ 83,630$ 13,450$ -1.97%9,901.00$
<br />BEGINNING FUND BALANCE 2,400,114 2,507,759 2,590,790 3,397,990 3,876,786 3,876,786 3,960,417 2.16%
<br />ENDING FUND BALANCE 2,507,759$ 2,590,790$ 3,397,990$ 3,876,786$ 3,890,506$ 3,960,417$ 3,973,867$ 2.14%
<br />*SCHEDULED USE OF FUND BALANCE
<br />51
|