|
Fiscal Year 2021
<br />ACTUAL
<br />2016
<br />ACTUAL
<br />2017
<br />ACTUAL
<br />2018
<br />ACTUAL
<br />2019
<br />BUDGET
<br />2020
<br />BUDGET
<br />2021
<br />GENERAL FUND EXPENDITURES DETAIL
<br />PARKS
<br />101-4110-51-0000 PR REGULAR EMPLOYEE 100,528$ 101,717$ 109,030$ 112,855$ 114,965$ 116,783$ 1.58%INCLUDES ESTIMATED 2020 WAGE ADJUSTMENTS
<br />101-4110-51-0100 TW REGULAR EMPLOYEE 27,130 28,145 29,007 29,970 31,158 31,621 1.49%INCLUDES ESTIMATED 2020 WAGE ADJUSTMENTS
<br />101-4110-51-0200 PR COMMITTEE 180 300 180 200 359 366 2.00%Parks commission est 3 opt-in pay-assume no change for 2020
<br />101-4111-51-0000 PR OVERTIME EMPLOYEE 2,229 1,944 1,827 2,216 3,307 3,373 2.00%BASED ON EE MAPPING
<br />101-4111-51-0100 TW OVERTIME EMPLOYEE 369 305 1,048 1,176 867 884 2.00%BASED ON EE MAPPING
<br />101-4121-51-0000 PR PERA 7,921 7,994 8,606 8,807 8,870 9,012 1.59%BASED ON CURRENT PERA FUNDING RATE
<br />101-4121-51-0100 TW PERA 2,132 2,189 2,343 2,424 2,402 2,438 1.50%BASED ON CURRENT PERA FUNDING RATE
<br />101-4122-51-0000 PR FICA/MEDICARE 7,791 8,115 8,767 9,003 9,075 9,220 1.59%BASED ON ER 7.65% OF GROSS
<br />101-4122-51-0100 TW FICA/MEDICARE 2,186 2,258 2,357 2,459 2,450 2,487 1.50%BASED ON ER 7.65% OF GROSS
<br />101-4131-51-0000 PR INSURANCE HEALTH 24,223 20,085 21,306 22,380 23,223 24,750 6.58%SPLIT 9.4% PREMUIM INCREASE IN 2021
<br />101-4131-51-0100 TW INSURANCE HEALTH 4,767 5,169 5,004 5,277 5,614 6,011 7.07%SPLIT 9.4% PREMUIM INCREASE IN 2021
<br />101-4135-51-0000 PR INSURANCE WC 3,258 3,520 3,286 3,641 3,976 4,738 19.16%SPLIT 9.4% PREMUIM INCREASE IN 2021
<br />101-4135-51-0100 TW INSURANCE WC 2,116 2,339 2,191 2,455 2,651 3,159 19.16%BASED ON 2019/2020 RENEWAL
<br />101-4212-51-0000 PW FUEL - STREET/PARKS - - - 633 - - 0.00%PW FUELS USE CONSOLIDATED UNDER STREETS DEPT
<br />101-4226-51-0000 PR GENERAL SUPPLIES 11,193 19,832 14,357 15,538 15,810 16,126 2.00%2021 PROJECTED RUN RATE
<br />101-4310-51-0100 TW MISC. CONTRACTED SERVICES 1,060 - - 190 - - 0.00%coded to 4338
<br />101-4325-51-0000 PR COMMUNICATIONS 1,285 1,370 1,622 1,522 1,760 1,810 2.84%BASED ON COMMUNICATION SPREADSHEET
<br />101-4325-51-0100 TW COMMUNICATIONS 155 171 197 147 220 230 4.55%BASED ON COMMUNICATION SPREADSHEET
<br />101-4337-51-0000 PR STRUCTURES REPAIRS & MAINT.6,687 8,108 12,365 6,682 10,500 10,710 2.00%2021 PROJECTED RUN RATE
<br />101-4338-51-0100 TW TREE REPLACEMENT 4,561 3,542 583 3,796 3,825 3,902 2.00%2021 PROJECTED RUN RATE
<br />101-4339-51-0000 PR EQUIP REPAIRS & MAINTENANCE 8,554 8,327 7,857 11,090 10,250 10,455 2.00%2021 PROJECTED RUN RATE
<br />101-4339-51-0100 TW EQUIP REPAIRS & MAINTENANCE - 52 - - 276 282 2.00%2021 PROJECTED RUN RATE
<br />101-4381-51-0000 PR ELECTRIC AND GAS UTILITIES 20,135 19,838 19,316 19,389 19,793 20,604 4.10%2021 based on usage run rates and XCEL and Centerpoint rate increases
<br />101-4415-51-0000 PR SS RENTALS 2,423 2,614 1,821 2,820 2,780 2,835 2.00%2021 PROJECTED RUN RATE
<br />101-4499-51-0000 PR MISCELLANEOUS - 427 - - 108 110 2.00%2021 PROJECTED RUN RATE
<br />101-4499-51-0100 TW MISCELLANEOUS - - 646 - 108 110 2.00%2021 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 0.00%Annual Fixed amount
<br />TOTAL 293,059$ 300,536$ 305,892$ 316,846$ 326,523$ 334,192$ 2.35%
<br />OTHER EXPENDITURES AND TRANSFERS
<br />101-4335-70-0000 INSURANCE CLAIMS 21,989$ 26,984 14,384 8,713 15,000 15,000 0.00%
<br />101-4343-70-0000 EQUITY INTITIATIVE - 9,800 5,119 9,008 10,200 10,404 2.00%Established funding and specific tracking of initiative costs
<br />101-4346-70-0000 COLLABORATIVE INTITIATIVE - - 1,055 11,573 11,500 11,730 2.00%Established funding and specific tracking of initiative costs
<br />101-4347-70-0000 PROPERTY RESOURCE INTITIATIVE - - - 593 10,200 10,404 2.00%Established funding and specific tracking of initiative costs
<br />101-4348-70-0000 SUSTAINABILITY INTITIATIVE - - 2,601 22,400 25,000 25,000 0.00%Established funding and specific tracking of initiative costs
<br />101-4499-70-0000 NB MISCELLANEOUS - - 6,298 25,947 - - 0.00%
<br />101-4499-23-0000 INCIDENT/DATA PRODUCTION EXPENSE 553,339 880,761 176,371 135,233 - - 0.00%
<br />101-4920-70-0000 TRANSFER - SEVERENCE FUND 86,300 86,300 86,300 86,300 86,300 86,300 0.00%AMOUNT TO MAINTAIN SEVERENCE FUND BALANCE
<br />TOTAL 661,628$ 1,003,845$ 292,128$ 299,767$ 158,200$ 158,838$ 0.40%
<br />TOTAL FUND EXPENDITURES 7,411,957$ 7,627,593$ 7,029,590$ 7,272,415$ 7,605,976$ 7,672,904$ 0.88%
<br />TOTAL FUND REVENUE 7,285,001$ 7,708,650$ 7,137,235$ 7,355,442$ 7,622,150$ 7,682,355$ 0.79%
<br />0.00%with 20k hi coverage
<br />CHANGE IN FUND BALANCE (126,956)$ *81,058$ 107,646$ 83,027$ 16,173$ 9,451$ -41.57%(3,826.67)$
<br />BEGINNING FUND BALANCE 2,446,012 2,319,056 2,400,114 2,507,759 2,590,787 2,606,960 0.62%
<br />0.00%
<br />ENDING FUND BALANCE 2,319,056$ 2,400,114$ 2,507,759$ 2,590,787$ 2,606,960$ 2,616,411$ 0.36%
<br />2,017$
<br />6,835,139$
<br />*SCHEDULED USE OF FUND BALANCE
<br />11
|