|
Fiscal Year 2022 12/31/2020 $14.00
<br />ACTUAL
<br />2017
<br />ACTUAL
<br />2018
<br />ACTUAL
<br />2019
<br />ACTUAL
<br />2020
<br />BUDGET
<br />2021
<br />EST. ACTUAL
<br />2021
<br />BUDGET
<br />2022
<br />GENERAL FUND EXPENDITURES DETAIL
<br />PARKS
<br />101-4110-51-0000 PR REGULAR EMPLOYEE 101,717$ 109,030$ 112,855$ 105,447$ 113,176$ 108,938$ 119,450$ 5.54% INCLUDES ESTIMATED 2022 WAGE ADJUSTMENTS
<br />101-4110-51-0100 TW REGULAR EMPLOYEE 28,145 29,007 29,970 29,401 31,621 31,276 32,373 2.38% INCLUDES ESTIMATED 2022 WAGE ADJUSTMENTS
<br />101-4110-51-0200 PR COMMITTEE 300 180 200 600 474 600 600 26.50% Parks commission all opt-in for pay
<br />101-4111-51-0000 PR OVERTIME EMPLOYEE 1,944 1,827 2,216 1,654 2,500 1,200 2,588 3.50% BASED ON EE MAPPING
<br />101-4111-51-0100 TW OVERTIME EMPLOYEE 305 1,048 1,176 575 1,000 1,000 1,035 3.50% BASED ON EE MAPPING
<br />101-4121-51-0000 PR PERA 7,994 8,606 8,807 8,630 8,676 8,260 9,153 5.50% BASED ON CURRENT PERA FUNDING RATE
<br />101-4121-51-0100 TW PERA 2,189 2,343 2,424 2,445 2,447 2,421 2,506 2.41% BASED ON CURRENT PERA FUNDING RATE
<br />101-4122-51-0000 PR FICA/MEDICARE 8,115 8,767 9,003 8,667 8,885 8,471 9,382 5.59% BASED ON ER 7.65% OF GROSS
<br />101-4122-51-0100 TW FICA/MEDICARE 2,258 2,357 2,459 2,486 2,496 2,469 2,556 2.41% BASED ON ER 7.65% OF GROSS
<br />101-4131-51-0000 PR INSURANCE HEALTH 20,085 21,306 22,380 23,441 26,870 23,325 28,369 5.58% SPLIT 3.2% PREMUIM DECREASE IN 2022
<br />101-4131-51-0100 TW INSURANCE HEALTH 5,169 5,004 5,277 5,615 6,011 6,011 5,873 -2.30% SPLIT 3.2% PREMUIM DECREASE IN 2022
<br />101-4135-51-0000 PR INSURANCE WC 3,520 3,286 3,641 4,255 4,877 4,658 5,524 13.27% BASED ON 2021/2022 RENEWAL and 22/23 LMC rate information
<br />101-4135-51-0100 TW INSURANCE WC 2,339 2,191 2,455 2,837 3,252 3,103 3,683 13.25% BASED ON 2021/2022 RENEWAL and 22/23 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 19,832 14,357 15,538 15,700 16,126 9,950 17,500 8.52% 2022 PROJECTED RUN RATE
<br />101-4310-51-0100 TW MISC. CONTRACTED SERVICES - - 190 - - - - 0.00% coded to 4338
<br />101-4325-51-0000 PR COMMUNICATIONS 1,370 1,622 1,522 1,693 1,810 1,829 1,834 1.33% BASED ON COMMUNICATION SPREADSHEET
<br />101-4325-51-0100 TW COMMUNICATIONS 171 197 147 67 230 169 204 -11.30% BASED ON COMMUNICATION SPREADSHEET
<br />101-4337-51-0000 PR STRUCTURES REPAIRS & MAINT.8,108 12,365 6,682 1,356 8,750 5,650 15,650 78.86% 2022 PROJECTED RUN RATE
<br />101-4338-51-0100 TW TREE REPLACEMENT 3,542 583 3,796 2,778 3,902 500 4,000 2.52% 2022 PROJECTED RUN RATE
<br />101-4339-51-0000 PR EQUIP REPAIRS & MAINTENANCE 8,327 7,857 11,090 8,776 10,455 12,296 11,500 10.00% 2022 PROJECTED RUN RATE
<br />101-4339-51-0100 TW EQUIP REPAIRS & MAINTENANCE 52 - - 691 282 282 350 24.32% 2022 PROJECTED RUN RATE
<br />101-4381-51-0000 PR ELECTRIC AND GAS UTILITIES 19,838 19,316 19,389 15,870 20,604 31,500 25,650 24.49% 2022 based on usage run rates and XCEL and CenterPoint rate increases
<br />101-4415-51-0000 PR SS RENTALS 2,614 1,821 2,820 2,122 1,900 2,850 3,450 81.58% 2022 RETURNING TO PRE COVID ACTIVITY LEVEL
<br />101-4499-51-0000 PR MISCELLANEOUS 427 - - - 110 110 110 0.00% 2022 PROJECTED RUN RATE
<br />101-4499-51-0100 TW MISCELLANEOUS - 646 - - 110 110 110 0.00% 2022 PROJECTED RUN RATE
<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 300,536$ 305,892$ 316,846$ 297,321$ 328,740$ 319,155$ 355,625$ 8.18%
<br />OTHER EXPENDITURES AND TRANSFERS
<br />101-4335-70-0000 INSURANCE CLAIMS 26,984 14,384 8,710 14,606$ 15,000 9,550 15,000 0.00%
<br />101-4343-70-0000 EQUITY INTITIATIVE 9,800 5,119 9,008 1,438 10,000 8,850 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 10,000 6,375 10,000 0.00% Established funding and specific tracking of initiative costs
<br />101-4347-70-0000 PROPERTY RESOURCE INTITIATIVE - - 593 - 10,000 3,000 10,000 0.00% Established funding and specific tracking of initiative costs
<br />101-4348-70-0000 SUSTAINABILITY INTITIATIVE - 2,601 22,400 2,772 17,500 4,750 17,500 0.00% Established funding and specific tracking of initiative costs
<br />101-4499-70-0000 NB MISCELLANEOUS - 6,298 25,947 7,195 - - 20,000 0.00% 2022 COMMUNITY SURVEY
<br />101-4499-23-0000 INCIDENT/DATA PROD/COVID-19 880,761 176,371 135,233 379,334 - 50,000 - 0.00% 2020 ACTUAL COVID 19 RELATED EXP/ EST 2021 COVID 19 EXP
<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 - OTHER - - - 2,500 - 367,845 - 0.00% 2020 RECYCLING FUND / EST. 2021 EXCESS FUND BAL TRANSFER
<br />TOTAL 1,003,845$ 292,128$ 299,764$ 496,609$ 148,800$ 536,670$ 168,800$ 13.44%
<br />TOTAL FUND EXPENDITURES 7,627,593$ 7,029,590$ 7,272,412$ 7,652,254$ 7,651,786$ 8,245,626$ 8,013,767$ 5.36%
<br />TOTAL FUND REVENUE 7,708,650$ 7,137,235$ 7,355,442$ 8,459,454$ 7,666,343$ 8,562,689$ 8,027,487$ 5.39%
<br />0.00%with 20k hi coverage
<br />CHANGE IN FUND BALANCE 81,058$ 107,646$ 83,030$ 807,200$ 14,557$ 317,063$ 13,719$ 26.30%9,901.00$
<br />BEGINNING FUND BALANCE 2,319,056 2,400,114 2,507,759 2,590,790 3,397,990 3,397,990 3,715,053 43.39%
<br />0.00%
<br />ENDING FUND BALANCE 2,400,114$ 2,507,759$ 2,590,790$ 3,397,990$ 3,412,547$ 3,715,053$ 3,728,773$ 43.32%
<br />2,017$
<br />111
|