|
Fiscal Year 202212/31/2020 $14.00ACTUAL 2017ACTUAL2018ACTUAL2019ACTUAL2020BUDGET2021EST. ACTUAL2021BUDGET2022GENERAL FUND EXPENDITURES DETAILPARKS101‐4110‐51‐0000 PR REGULAR EMPLOYEE 101,717$ 109,030$ 112,855$ 105,447$ 113,176$ 111,085$ 117,225$ 3.58% INCLUDES ESTIMATED 2022 WAGE ADJUSTMENTS 101‐4110‐51‐0100 TW REGULAR EMPLOYEE 28,145 29,007 29,970 29,401 31,621 31,040 32,020 1.26% INCLUDES ESTIMATED 2022 WAGE ADJUSTMENTS 101‐4110‐51‐0200 PR COMMITTEE 300 180 200 600 474 600 600 26.50% Parks commission all opt‐in for pay101‐4111‐51‐0000 PR OVERTIME EMPLOYEE 1,944 1,827 2,216 1,654 2,500 2,500 2,588 3.50% BASED ON EE MAPPING101‐4111‐51‐0100 TW OVERTIME EMPLOYEE 305 1,048 1,176 575 1,000 1,000 1,035 3.50% BASED ON EE MAPPING101‐4121‐51‐0000 PR PERA 7,994 8,606 8,807 8,630 8,676 8,519 8,986 3.58% BASED ON CURRENT PERA FUNDING RATE 101‐4121‐51‐0100 TW PERA 2,189 2,343 2,424 2,445 2,447 2,403 2,479 1.33% BASED ON CURRENT PERA FUNDING RATE 101‐4122‐51‐0000 PR FICA/MEDICARE 8,115 8,767 9,003 8,667 8,885 8,735 9,212 3.67% BASED ON ER 7.65% OF GROSS101‐4122‐51‐0100 TW FICA/MEDICARE 2,258 2,357 2,459 2,486 2,496 2,451 2,529 1.33% BASED ON ER 7.65% OF GROSS101‐4131‐51‐0000 PR INSURANCE HEALTH 20,085 21,306 22,380 23,441 26,870 25,369 26,559 ‐1.16% SPLIT 3.2% PREMUIM DECREASE IN 2022101‐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 2022101‐4135‐51‐0000 PR INSURANCE WC 3,520 3,286 3,641 4,255 4,877 4,658 5,070 3.96% 2021/2022 RENEWAL101‐4135‐51‐0100 TW INSURANCE WC 2,339 2,191 2,455 2,837 3,252 3,103 3,380 3.94% 2021/2022 RENEWAL101‐4212‐51‐0000 PW FUEL ‐ STREET/PARKS‐ ‐ 633 40 ‐ ‐ ‐ 0.00% PW FUELS USE CONSOLIDATED UNDER STREETS DEPT101‐4226‐51‐0000 PR GENERAL SUPPLIES 19,832 14,357 15,538 15,700 16,126 17,000 17,500 8.52% 2022 PROJECTED RUN RATE101‐4310‐51‐0100 TW MISC. CONTRACTED SERVICES‐ ‐ 190 ‐ ‐ ‐ ‐ 0.00% coded to 4338101‐4325‐51‐0000 PR COMMUNICATIONS 1,370 1,622 1,522 1,693 1,810 1,829 1,834 1.33% BASED ON COMMUNICATION SPREADSHEET101‐4325‐51‐0100 TW COMMUNICATIONS 171 197 147 67 230 169 204 ‐11.30% BASED ON COMMUNICATION SPREADSHEET101‐4337‐51‐0000 PR STRUCTURES REPAIRS & MAINT. 8,108 12,365 6,682 1,356 8,750 3,500 5,750 ‐34.29% 2022 PROJECTED RUN RATE101‐4338‐51‐0100 TW TREE REPLACEMENT 3,542 583 3,796 2,778 3,902 3,500 4,000 2.52% 2022 PROJECTED RUN RATE101‐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 RATE101‐4339‐51‐0100 TW EQUIP REPAIRS & MAINTENANCE 52 ‐ ‐ 691 282 282 350 24.32% 2022 PROJECTED RUN RATE101‐4381‐51‐0000 PR ELECTRIC AND GAS UTILITIES 19,838 19,316 19,389 15,870 20,604 20,604 23,695 15.00% 2022 based on usage run rates and XCEL and CenterPoint rate increases101‐4415‐51‐0000 PR SS RENTALS 2,614 1,821 2,820 2,122 1,900 2,350 2,750 44.74% 2022 RETURNING TO PRE COVID ACTIVITY LEVEL 101‐4499‐51‐0000 PR MISCELLANEOUS 427 ‐ ‐ ‐ 110 110 110 0.00% 2022 PROJECTED RUN RATE101‐4499‐51‐0100 TW MISCELLANEOUS‐ 646 ‐ ‐ 110 110 110 0.00% 2022 PROJECTED RUN RATE101‐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 TOTAL 300,536$ 305,892$ 316,846$ 297,321$ 328,740$ 321,400$ 337,534$ 2.68%OTHER EXPENDITURES AND TRANSFERS101‐4335‐70‐0000 INSURANCE CLAIMS 26,984 14,384 8,710 14,606$ 15,000 15,000 15,000 0.00%101‐4343‐70‐0000 EQUITY INTITIATIVE 9,800 5,119 9,008 1,438 10,000 10,000 10,000 0.00% Established funding and specific tracking of initiative costs 101‐4346‐70‐0000 COLLABORATIVE INTITIATIVE‐ 1,055 11,573 2,464 10,000 10,000 10,000 0.00% Established funding and specific tracking of initiative costs 101‐4347‐70‐0000 PROPERTY RESOURCE INTITIATIVE‐ ‐ 593 ‐ 10,000 10,000 10,000 0.00% Established funding and specific tracking of initiative costs 101‐4348‐70‐0000 SUSTAINABILITY INTITIATIVE‐ 2,601 22,400 2,772 17,500 17,500 17,500 0.00% Established funding and specific tracking of initiative costs 101‐4499‐70‐0000 NB MISCELLANEOUS‐ 6,298 25,947 7,195 ‐ ‐ 20,000 0.00% 2022 COMMUINTY SURVEY 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 101‐4920‐70‐0000 TRANSFER ‐ SEVERENCE FUND 86,300 86,300 86,300 86,300 86,300 86,300 86,300 0.00% ANNUAL TRANSFER101‐4920‐70‐0000 TRANSFER ‐ OTHER‐ ‐ ‐ 2,500 ‐ 367,845 ‐ 0.00% 2020 RECYCLING FUND / EST. 2021 EXCESS FUND BAL TRANSFERTOTAL 1,003,845$ 292,128$ 299,764$ 496,609$ 148,800$ 566,645$ 168,800$ 13.44%TOTAL FUND EXPENDITURES 7,627,593$ 7,029,590$ 7,272,412$ 7,652,254$ 7,651,786$ 8,377,358$ 7,921,091$ 3.52%TOTAL FUND REVENUE 7,708,650$ 7,137,235$ 7,355,442$ 8,459,454$ 7,666,343$ 8,479,558$ 7,932,575$ 3.47%with 20k hi coverageCHANGE IN FUND BALANCE 81,058$ 107,646$ 83,030$ 807,200$ 14,557$ 102,200$ 11,484$ ‐21.11%9,901.00$ BEGINNING FUND BALANCE 2,319,056 2,400,114 2,507,759 2,590,790 3,397,990 3,397,990 3,500,190 3.01%ENDING FUND BALANCE 2,400,114$ 2,507,759$ 2,590,790$ 3,397,990$ 3,412,547$ 3,500,190$ 3,511,673$ 2.90%2,017$
|