Loading...
HomeMy WebLinkAboutORD 3019 Adopting the 2022 Annual BudgetCity of West University PlaceCity of West University PlaceCity of West University Place Proposed FY 2022 BudgetProposed FY 2022 BudgetProposed FY 2022 Budget Exhibit A GENERAL FUND 1 GENERAL FUND STATEMENT OF REVENUES AND EXPENDITURES BY DEPARTMENT Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REVENUES: AD VALOREM TAXES $ 11,868,670 $ 12,307,661 $ 12,925,878 $ 12,908,400 $ 13,526,000 SALES TAXES 1,300,763 1,358,237 1,220,000 1,349,300 1,300,000 FRANCHISE TAXES 1,093,925 908,388 993,000 945,000 920,000 OTHER TAXES 11,219 8,382 8,000 11,700 10,000 TOTAL TAXES 14,274,577$ 14,582,667$ 15,146,878$ 15,214,400$ 15,756,000$ PERMITS, LICENSES AND FEES 727,588 648,139 606,750 709,200 695,500 CHARGES FOR SERVICES 3,414,984 1,953,402 2,872,100 2,647,000 2,884,500 FINES AND FORFEITURES 277,731 110,579 135,400 106,200 132,000 EARNINGS ON INVESTMENTS 340,194 102,657 83,500 11,000 12,000 OTHER REVENUE 343,593 1,340,343 469,800 487,400 454,200 TRANSFERS IN 1,789,454 1,640,691 1,695,300 1,728,000 1,737,400 TOTAL REVENUES 21,168,121$ 20,378,479$ 21,009,728$ 20,903,200$ 21,671,600$ EXPENDITURES BY DEPARTMENT: ADMINISTRATION $ 1,487,012 $ 1,278,449 $ 1,725,970 $ 1,615,005 $ 1,820,250 FINANCE 2,878,097 1,600,284 1,847,400 1,734,100 1,889,900 POLICE 4,541,084 4,737,561 5,531,200 4,949,250 5,560,750 FIRE 3,546,949 3,710,437 3,850,000 3,636,200 3,952,300 PUBLIC WORKS 2,992,669 3,277,667 3,621,050 3,536,200 3,663,800 PARKS & RECREATION 4,072,762 3,040,622 4,113,450 3,908,840 4,334,000 TRANSFERS OUT -283,600 587,000 7,807,000 285,000 TOTAL EXPENDITURES 19,518,573$ 17,928,621$ 21,276,070$ 27,186,595$ 21,506,000$ NET REVENUES (EXPENDITURES 1,649,548$ 2,449,858$ (266,342)$ (6,283,395)$ 165,600$ BEGINNING FUND BALANCE 8,176,398 9,825,946 10,591,614 12,275,805 5,992,410 ENDING FUND BALANCE 9,825,946$ 12,275,805$ 10,325,272$ 5,992,410$ 6,158,010$ ASSIGNED*197,000 203,000 211,000 211,000 219,000 RESTRICTED**332,455 352,432 463,708 372,432 392,432 UNASSIGNED FUND BALANCE 9,296,492$ 11,720,373$ 9,650,564$ 5,408,978$ 5,546,578$ * Assigned for City Manager's Contract ** Restricted for PEG fees ADMINISTRATION 8.5% FINANCE 8.8% POLICE 25.9% FIRE 18.4% PUBLIC WORKS 17.0% PARKS & RECREATION 20.2% TRANSFERS OUT 1.3% 2022 GENERAL FUND EXPENDITURES BY DEPARTMENT 2 GENERAL FUND STATEMENT OF REVENUES AND EXPENDITURES BY ACCOUNT Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REVENUES: AD VALOREM TAXES 11,868,670$ 12,307,661$ 12,925,878$ 12,908,400$ 13,526,000$ SALES TAXES 1,300,763 1,358,237 1,220,000 1,349,300 1,300,000 FRANCHISE TAXES 1,093,925 908,388 993,000 945,000 920,000 OTHER TAXES 11,219 8,382 8,000 11,700 10,000 TOTAL TAXES 14,274,577$ 14,582,667$ 15,146,878$ 15,214,400$ 15,756,000$ PERMITS, LICENSES AND FEES 727,588 648,139 606,750 709,200 695,500 CHARGES FOR SERVICES 3,414,984 1,953,402 2,872,100 2,647,000 2,884,500 FINES AND FORFEITURES 277,731 110,579 135,400 106,200 132,000 EARNINGS ON INVESTMENTS 340,194 102,657 83,500 11,000 12,000 OTHER REVENUE 343,593 1,340,343 469,800 487,400 454,200 TRANSFERS IN 1,789,454 1,640,691 1,695,300 1,728,000 1,737,400 TOTAL REVENUES 21,168,121$ 20,378,479$ 21,009,728$ 20,903,200$ 21,671,600$ EXPENDITURES: REGULAR WAGES $ 7,104,156 $ 7,441,332 $ 8,155,700 $ 7,798,400 $ 8,441,200 PART-TIME WAGES 673,893 509,779 745,000 641,020 781,000 ON CALL 17,291 19,479 23,800 23,400 24,500 OVERTIME 706,689 611,710 616,800 592,350 604,100 LONGEVITY 49,797 51,684 58,400 55,000 60,700 HEALTH & DENTAL 1,003,084 899,373 1,156,700 907,500 1,095,300 TMRS 1,053,654 1,086,603 1,179,800 1,136,000 1,224,500 FICA 633,495 636,157 709,550 670,000 736,200 WORKERS COMPENSATION 91,464 146,753 85,620 86,505 90,550 ALLOWANCES 64,355 62,731 69,200 63,720 69,600 RETIREE BENEFITS 188,600 94,400 98,300 94,400 98,800 OTHER BENEFITS 385,927 30,639 45,500 41,200 44,550 HSA CONTRIBUTION 15,375 112,175 110,500 76,200 111,000 EMPLOYEE RELATIONS 26,352 18,126 32,300 28,500 20,900 PERSONNEL 12,014,133$ 11,720,940$ 13,087,170$ 12,214,195$ 13,402,900$ OFFICE SUPPLIES $ 34,896 $ 38,835 $ 41,250 $ 38,700 $ 42,500 APPREHENSION & JAILING 1,861 861 1,400 1,400 1,400 OPERATING SUPPLIES 182,388 195,000 218,200 220,400 169,600 EMS SUPPLIES - - 28,000 28,000 30,000 FUEL 63,087 40,627 75,000 60,000 71,000 EMERGENCY GENERATOR FUEL 1,739 4,401 3,700 20,000 5,000 TREATMENT CHEMICALS 26,361 17,891 35,400 37,900 39,600 EQUIPMENT MAINTENANCE 91,298 85,958 118,400 107,300 135,600 VEHICLE MAINTENANCE 92,207 99,178 93,500 104,500 101,500 BUILDING & GROUNDS MAINTENANCE 135,180 65,674 80,000 80,000 88,700 SWIMMING POOL MAINTENANCE 61,890 65,053 62,500 62,500 58,500 DRAINAGE MAINTENANCE 27,254 46,576 43,000 43,000 146,000 STREET MAINTENANCE 110,761 179,489 205,000 205,000 155,000 TRAFFIC CONTROL MAINTENANCE 25,752 18,393 24,000 24,000 24,000 POSTAGE & SHIPPING 97,370 66,137 73,100 72,800 44,300 ELECTRIC SERVICE 334,404 217,299 277,000 250,500 263,000 STREET LIGHTING - ELECTRIC SERVICE 117,915 53,246 75,000 70,000 75,000 SURFACE WATER 121 - 1,000 - - NATURAL GAS SERVICE 20,326 16,473 23,400 28,000 31,200 SOFTWARE LICENSES - - - - 6,000 CONSULTANTS 70,407 54,035 76,000 83,000 35,000 LEGAL 128,813 160,501 205,000 190,000 211,000 3 GENERAL FUND STATEMENT OF REVENUES AND EXPENDITURES BY ACCOUNT Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 EQUIPMENT LEASE/RENTAL 35,664 30,893 38,800 24,200 25,500 PROFESSIONAL DUES 29,255 27,606 35,800 33,100 37,950 PUBLICATIONS 20,688 15,394 25,550 23,300 22,600 PROFESSIONAL DEVELOPMENT 128,053 74,093 184,500 126,300 192,150 CREDIT CARD FEES 57,748 38,039 60,000 60,600 66,800 OTHER CONTRACTED SERVICES 1,177,825 1,035,816 1,507,400 1,202,400 1,403,400 LOBBYIST - - 30,000 25,000 - INSTRUCTOR FEES 882,360 339,446 856,300 641,800 840,000 YOUTH SPORTS 125,000 - - 40,000 100,000 GENERAL LIABILITY INSURANCE 8,330 8,976 10,000 9,000 10,100 ERRORS & OMISSIONS 16,450 16,496 18,000 17,000 22,200 LAW ENFORCEMENT LIABILITY 15,054 14,433 17,000 17,000 23,000 CRIME COVERAGE FIDELITY 2,907 3,124 3,200 3,200 3,200 AUTO LIABILITY 38,192 39,808 42,000 41,000 46,200 AUTO PHYSICAL DAMAGE 29,529 33,144 30,000 30,000 30,000 UNDERGROUND STORAGE LIABILITY 500 500 800 500 800 REAL & PERSONAL PROPERTY 99,907 104,910 111,000 107,000 121,500 DEDUCTIBLE 1,180 (290) 10,000 10,000 10,000 PROPERTY TAXES 11,288 1,758 - - - COMMUNITY RELATIONS 33,257 22,277 139,000 105,000 313,700 BOARDS AND COMMITTEES 4,594 5,039 5,000 5,000 5,000 ELECTION EXPENSE 18,425 - 28,000 47,000 30,000 BAD DEBT EXPENSE - 145 - 1,700 200 FURNITURE & EQUIP < $5000 1,352 1,751 3,200 5,200 2,000 FURNITURE & FIXTURES 21,510 1,873 - 1,200 - AUTOMOBILES - - - 30,000 - LAND ACQUISITION 678,263 - - - - OTHER EQUIPMENT 53,931 171,992 154,500 163,900 115,300 CONSTRUCTION COSTS 6,344 - 12,000 5,000 5,000 OTHER CONSTRUCTION COSTS 28,604 70,895 51,500 194,500 85,200 TRANSFER TO CAPITAL PROJECT FUND - - 300,000 300,000 - TRANSFER TO CAPITAL RESERVE FUND - - - 7,000,000 - TRANSFER TO VEHICLE REPLACEMENT FUND 343,300 365,355 343,000 343,000 350,000 TRANSFER TO TECHNOLOGY MANAGEMENT FUND 1,435,500 1,496,400 1,541,200 1,761,200 1,734,100 TRANSFER TO ASSET REPLACEMENT FUND 575,400 576,100 539,300 539,300 443,300 TRANSFER TO EMPLOYEE BENEFIT FUND - 33,700 35,000 35,000 35,000 TRANSFER TO HUMAN RESOURCE SVCS FUND - 249,900 252,000 252,000 250,000 CONTINGENCY - 2,482 45,000 45,000 45,000 OPERATING 7,504,440$ 6,207,681$ 8,188,900$ 14,972,400$ 8,103,100$ TOTAL EXPENDITURES 19,518,573$ 17,928,621$ 21,276,070$ 27,186,595$ 21,506,000$ 4 GENERAL FUND DETAIL STATEMENT OF REVENUES Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 CURRENT YEAR PROPERTY TAXES $ 11,716,660 $ 12,170,492 $ 12,865,878 $ 12,809,900 $ 13,441,000 PRIOR YEAR PROPERTY TAXES 100,890 87,550 20,000 44,500 40,000 PENALTY AND INTEREST 51,120 49,619 40,000 54,000 45,000 AD VALOREM TAXES 11,868,670$ 12,307,661$ 12,925,878$ 12,908,400$ 13,526,000$ SALES TAX $ 1,300,763 $ 1,358,237 $ 1,220,000 $ 1,349,300 $ 1,300,000 SALES TAXES 1,300,763$ 1,358,237$ 1,220,000$ 1,349,300$ 1,300,000$ ELECTRICITY $ 547,169 $ 546,875 $ 547,000 $ 545,400 $ 545,000 NATURAL GAS 168,128 145,128 147,000 169,500 150,000 TELEPHONE 72,576 77,813 60,000 74,000 70,000 CABLE 277,022 138,573 239,000 136,100 135,000 TELEPHONE-PEG FEES 29,031 - - 20,000 20,000 FRANCHISE TAXES 1,093,925$ 908,388$ 993,000$ 945,000$ 920,000$ MIXED BEVERAGE TAX $ 11,219 $ 8,382 $ 8,000 $ 11,700 $ 10,000 OTHER TAXES 11,219$ 8,382$ 8,000$ 11,700$ 10,000$ TOTAL TAXES 14,274,577$ 14,582,667$ 15,146,878$ 15,214,400$ 15,756,000$ BUILDING PERMIT $ 310,376 $ 235,786 $ 250,000 $ 250,000 $ 275,000 PLUMBING PERMIT 87,200 84,515 70,000 85,000 90,000 HVAC PERMIT 61,267 56,270 55,000 50,000 55,000 FENCE AND SIDEWALK PERMIT 49,751 45,718 40,000 60,000 50,000 ELECTRICAL PERMIT 58,182 59,461 45,000 70,000 60,000 TREE DISPOSITION FEE 30,300 32,800 30,000 30,000 30,000 LOW IMPACT INSPECTION FEE 15,500 18,500 15,000 50,000 20,000 ALARM PERMIT 50,780 49,320 50,500 33,000 50,000 DRAINAGE PERMIT 6,905 6,635 6,500 10,000 7,000 TREE REMOVAL PERMIT 150 350 500 500 500 FIRE SPRINKLER PERMITS 2,447 1,909 3,000 2,000 2,000 PET LICENSES 1,205 1,580 1,000 1,200 1,000 ALCOHOLIC BEVERAGE PERMIT 250 6,520 250 500 5,000 ELECTRICAL CONTRACTOR PERMIT 75 - - - - CONTRACTOR PERMIT 46,200 48,775 40,000 60,000 50,000 ROW USE PERMIT 7,000 - - 7,000 - PERMITS, LICENSES AND FEES 727,588$ 648,139$ 606,750$ 709,200$ 695,500$ PLAN CHECKING FEE $ 130,249 $ 105,774 $ 100,000 $ 115,000 $ 125,000 ZPC & ZBA FEES 3,150 6,150 2,800 4,400 4,400 BUILDING STANDARDS FEE 300 600 300 300 300 RE-INSPECTION FEE 125 300 - - - PLAT REVIEW FEE 540 950 1,000 1,200 1,200 PREMATURE WORK FEE 95,206 101,174 70,000 115,000 115,000 AMBULANCE SERVICE 199,960 187,137 150,000 175,000 150,000 CHILD SAFETY 18,669 16,638 18,000 18,300 18,000 ALARM MONITORING 700,669 701,335 982,000 700,000 745,000 OTHER FEES AND PERMITS 25,410 21,240 15,000 18,000 20,000 SENIOR SERVICES CLASSES 118,796 30,855 82,500 31,000 55,000 RENTALS - COMMUNITY BUILDING 46,923 21,809 11,000 27,500 34,000 MEMBERSHIPS - RECREATION CENTER 208,663 123,649 146,000 146,000 175,200 DAY PASS - RECREATION CENTER 15,252 23,606 11,000 17,600 21,100 AQUATIC CLASS FEES - RECREATION CENTER 989,940 368,829 693,000 560,000 672,000 SPECIAL PERMIT FEES - RECREATION CENTER 72,239 15,542 36,000 36,000 36,000 RENTALS - RECREATION CENTER -6 - - 1,500 RECREATION CENTER - SPECIAL EVENTS - - - 2,500 6,000 MEMBERSHIPS - COLONIAL PARK 191,882 49,432 134,500 137,000 150,700 DAY PASS - COLONIAL PARK 51,210 30,975 36,000 36,000 43,200 COLONIAL PARK - SPECIAL EVENTS 11,423 800 8,000 100 500 POOL RENTAL - COLONIAL PARK 41,184 240 29,000 33,500 40,200 PAVILION RENTAL - COLONIAL PARK 13,818 3,900 9,500 10,200 12,200 CONCESSIONS - COLONIAL PARK 6,341 1,796 4,500 2,000 2,000 5 GENERAL FUND DETAIL STATEMENT OF REVENUES Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 SPECIAL PERMIT FEES - COLONIAL PARK 12,060 (2,521) 8,500 12,900 8,500 MISCELLANEOUS - CULTURAL & RECREATIONAL 462,398 143,186 323,500 447,500 447,500 CHARGES FOR SERVICES 3,416,405$ 1,953,402$ 2,872,100$ 2,647,000$ 2,884,500$ MUNICIPAL COURT FINES $ 259,850 $ 103,363 $ 130,000 $ 100,000 $ 125,000 LOCAL TRAFFIC FINES 4,911 2,142 2,500 2,500 3,000 CHILD SAFETY FINE 1,900 425 900 1,500 2,000 FALSE ALARM FEE 10,200 4,350 1,000 1,200 1,000 PET IMPOUNDMENT 870 300 1,000 1,000 1,000 FINES AND FORFEITURES 277,731$ 110,579$ 135,400$ 106,200$ 132,000$ EARNINGS ON INVESTMENTS $ 294,146 $ 114,412 $ 83,500 $ 12,000 $ 12,000 GAIN/LOSS ON INVESTMENT 46,048 (11,755) - (1,000) - EARNINGS ON INVESTMENTS 340,194$ 102,657$ 83,500$ 11,000$ 12,000$ FEDERAL GRANT $ 20,626 $ 914,121 $ - $ 20,000 $ 20,000 FEMA REIMBURSEMENT 1,493 23,975 - - - SOUTHSIDE PLACE 258,625 272,017 272,000 272,000 270,000 SETRAC - - - 8,500 - SALE OF CITY PROPERTY 56 - - - - SALE OF CITY PROPERTY-NON-CAPITALIZED 150 585 - - - RESEARCH & COPIES 585 306 500 500 500 AUTO DECALS 237 140 200 200 200 NSF CHECKS 310 360 - - - CASH OVER/SHORT (138,484) 20 - 2,000 - MISCELLANEOUS 53,144 22,005 15,000 18,700 15,000 CYCLONE CYCLES 55,597 57,821 59,100 9,400 - GOODE COMPANY 82,254 27,824 87,000 87,100 88,500 RENTAL PROPERTY INCOME 9,000 21,170 36,000 69,000 60,000 OTHER REVENUE 343,593$ 1,340,343$ 469,800$ 487,400$ 454,200$ TRANSFER FROM 2019 CERT OF OBLIGATION FUND $ 86,954 $ - $ - $ - $ - TRANSFER FROM WATER & SEWER FUND 1,250,000 1,250,000 1,250,000 1,250,000 1,250,000 TRANSFER FROM SOLID WASTE FUND 310,000 310,000 310,000 310,000 310,000 TRANSFER FROM EMPLOYEE BENEFIT FUND 142,500 - - - - TRANSFER FROM HUMAN RESOURCE SVCS FUND - 80,691 135,300 168,000 177,400 TRANSFERS IN 1,789,454$ 1,640,691$ 1,695,300$ 1,728,000$ 1,737,400$ TOTAL REVENUE 21,169,542$ 20,378,479$ 21,009,728$ 20,903,200$ 21,671,600$ 6 AD VALOREM TAXES 62.4% SALES TAXES 6.0%FRANCHISE TAXES 4.2%OTHER TAXES 0.1% PERMITS, LICENSES AND FEES 3.2% CHARGES FOR SERVICES 13.3% FINES AND FORFEITURES 0.6% EARNINGS ON INVESTMENTS 0.1% OTHER REVENUE 2.1%TRANSFERS IN 8.0% 2022 GENERAL FUND REVENUE BY TYPE PERSONNEL 62.3% INSURANCE 1.2% ELECTRICITY & NATURAL GAS 2.0% VEHICLE REPLACEMENT 1.6% TECHNOLOGY MANAGEMENT 8.1% ASSET REPLACEMENT 2.1% MAINTENANCE 3.3% FUEL 0.3% OTHER OPERATING 16.7% TRANSFERS 1.6%CAPITAL 1.0% 2022 GENERAL FUND EXPENDITURES BY TYPE 7 Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 Administration Personnel 942,493$ 834,228$ 1,015,500$ 958,300$ 1,005,500$ Operating 367,267 242,818 359,800 323,300 517,700 Capital - - - - 2,000 Total 1,309,760$ 1,077,046$ 1,375,300$ 1,281,600$ 1,525,200$ Council Personnel 8,659$ 2,529$ 10,170$ 11,405$ 15,550$ Operating 168,593 198,873 340,500 322,000 279,500 Total 177,252$ 201,403$ 350,670$ 333,405$ 295,050$ Total Department 1,487,012$ 1,278,449$ 1,725,970$ 1,615,005$ 1,820,250$ Administration Department Staffing Schedule 2021 2022 POSITION GRADE BUDGET BUDGET MINIMUM MAXIMUM Administration City Manager Unclassified 1 1 HR Director 12 1 1 115,000$ 178,250$ City Secretary 12 1 1 115,000$ 178,250$ Assistant to the City Manager 7 1 1 59,290$ 85,971$ Communications Coordinator 7 1 1 59,290$ 85,971$ Executive Assistant 5 1 1 49,000$ 71,050$ HR Generalist 5 1 1 49,000$ 71,050$ Total Administration Department 77 ADMINISTRATION DEPARTMENT SALARY RANGE Determined by Council 8 Administration Division Line Item Budget Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REGULAR WAGES $ 684,758 $ 611,369 $ 722,500 $ 698,800 $ 733,500 PART-TIME WAGES 19,650 - 15,000 7,500 15,000 OVERTIME 4,231 2,913 3,200 1,000 2,500 LONGEVITY 2,429 2,605 3,000 3,000 3,500 HEALTH & DENTAL 46,089 43,700 68,700 52,500 59,400 TMRS 93,065 83,436 97,900 94,800 100,100 FICA 52,061 43,259 54,600 54,300 55,200 WORKERS COMPENSATION 1,354 1,643 1,100 1,000 1,000 ALLOWANCES 22,165 20,455 22,300 20,000 22,200 OTHER BENEFITS 2,356 2,002 3,200 3,100 3,200 HSA CONTRIBUTION 1,000 9,450 8,500 6,800 8,500 EMPLOYEE RELATIONS 13,336 13,397 15,500 15,500 1,400 PERSONNEL 942,493$ 834,228$ 1,015,500$ 958,300$ 1,005,500$ OFFICE SUPPLIES $ 7,517 $ 8,021 $ 10,000 $ 10,000 $ 13,300 POSTAGE & SHIPPING 51,177 31,325 18,000 18,000 18,000 SOFTWARE LICENSES - - - - 6,000 LEGAL - 2,485 - - - EQUIPMENT LEASE/RENTAL 4,864 4,528 8,000 6,000 7,100 PROFESSIONAL DUES 5,647 4,487 8,000 6,000 7,000 PUBLICATIONS 698 1,007 2,500 1,500 1,000 PROFESSIONAL DEVELOPMENT 10,483 20,366 27,000 17,500 27,000 OTHER CONTRACTED SERVICES 153,191 30,352 40,000 35,000 31,500 COMMUNITY RELATIONS 92 464 57,000 40,000 123,200 TRANSFER TO TECHNOLOGY MANAGEMENT FUND 133,600 137,300 144,300 144,300 238,600 CONTINGENCY - 2,482 45,000 45,000 45,000 OPERATING 367,267$ 242,818$ 359,800$ 323,300$ 517,700$ FURNITURE & EQUIP <$5000 - - - - 2,000 CAPITAL -$ -$ -$ -$ 2,000$ ADMINISTRATION DIVISION TOTAL 1,309,760$ 1,077,046$ 1,375,300$ 1,281,600$ 1,525,200$ ADMINISTRATION DEPARTMENT 9 City Council Division Line Item Budget Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 PART-TIME WAGES $ 8,031 $ 2,345 $ 9,400 $ 10,600 $ 14,400 FICA 614 179 750 800 1,100 WORKERS COMPENSATION 13 5 20 5 50 PERSONNEL 8,659$ 2,529$ 10,170$ 11,405$ 15,550$ OFFICE SUPPLIES $ - $ - $ 1,500 $ 1,000 $ 1,000 CONSULTANTS - 25,620 35,000 30,000 - LEGAL 128,813 158,016 205,000 190,000 211,000 PROFESSIONAL DUES 4,240 6,552 7,000 6,000 7,000 PUBLICATIONS 6,316 5,672 15,000 15,000 15,000 PROFESSIONAL DEVELOPMENT 5,267 40 11,000 3,000 11,000 LOBBYIST - - 30,000 25,000 - COMMUNITY RELATIONS 5,533 2,974 8,000 5,000 4,500 ELECTION EXPENSE 18,425 - 28,000 47,000 30,000 OPERATING 168,593$ 198,873$ 340,500$ 322,000$ 279,500$ CITY COUNCIL DIVISION TOTAL 177,252$ 201,403$ 350,670$ 333,405$ 295,050$ ADMINISTRATION DEPARTMENT 10 Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 Finance Personnel 460,289$ 432,357$ 526,800$ 487,650$ 539,800$ Operating 427,602 431,204 507,900 479,200 523,950 Total 910,309$ 865,434$ 1,034,700$ 966,850$ 1,063,750$ Municipal Court Personnel 258,090$ 257,596$ 277,200$ 262,100$ 286,300$ Operating 12,087 8,482 13,700 10,100 12,850 Total 270,177$ 266,078$ 290,900$ 272,200$ 299,150$ City-Wide Charges Operating 1,697,611$ 468,771$ 521,800$ 495,050$ 527,000$ Total 1,697,611$ 468,771$ 521,800$ 495,050$ 527,000$ Total Department 2,878,097$ 1,600,284$ 1,847,400$ 1,734,100$ 1,889,900$ Finance Department Staffing Schedule 2021 2022 POSITION GRADE BUDGET BUDGET MINIMUM MAXIMUM Finance Accounting Finance Director 12 1 1 115,000$ 178,250$ Finance Manager 10 1 1 91,000$ 131,950$ Fiscal Services Officer 7 1 1 59,290$ 85,971$ Financial Analyst 7 1 1 59,290$ 85,971$ Municipal Court Municipal Court Clerk 6 1 1 53,900$ 78,155$ Accounting Specialist-AP 4 1 1 42,592$ 61,758$ Total Finance Department 66 FINANCE DEPARTMENT SALARY RANGE 11 Finance Division Line Item Budget Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REGULAR WAGES $ 328,734 $ 302,762 $ 366,100 $ 345,700 $ 380,700 PART-TIME WAGES 14,933 21,949 23,400 15,700 19,500 OVERTIME - 208 - - - LONGEVITY 374 520 800 600 900 HEALTH & DENTAL 37,093 35,455 43,300 39,400 42,300 TMRS 43,674 40,277 48,700 46,100 50,900 FICA 25,413 24,260 29,300 27,800 30,200 WORKERS COMPENSATION 574 937 500 500 500 ALLOWANCES 5,640 3,619 5,600 5,500 5,600 OTHER BENEFITS 1,271 1,011 1,600 1,400 1,700 HSA CONTRIBUTION - 1,050 4,000 2,450 4,000 EMPLOYEE RELATIONS 2,583 309 3,500 2,500 3,500 PERSONNEL 460,289$ 432,357$ 526,800$ 487,650$ 539,800$ OFFICE SUPPLIES $ 4,988 $ 8,238 $ 5,500 $ 5,500 $ 6,000 EQUIPMENT MAINTENANCE - - 500 200 500 POSTAGE & SHIPPING 1,214 1,043 1,300 1,500 1,300 CONSULTANTS - - - 12,000 - EQUIPMENT LEASE/RENTAL 5,708 4,887 4,500 2,500 2,500 PROFESSIONAL DUES 1,489 1,910 1,600 1,500 1,900 PUBLICATIONS 2,046 2,081 2,500 2,000 2,500 PROFESSIONAL DEVELOPMENT 3,157 3,489 11,000 5,000 8,750 OTHER CONTRACTED SERVICES 272,000 266,256 332,000 300,000 340,000 TRANSFER TO TECHNOLOGY MANAGEMENT FUND 137,000 143,300 149,000 149,000 160,500 OPERATING 427,602$ 431,204$ 507,900$ 479,200$ 523,950$ FURNITURE & EQUIP <$5000 - - - - - FURNITURE & FIXTURES $ 19,818 $ 1,873 $ - $ - $ - OTHER CONSTRUCTION COSTS 2,600 - - - - CAPITAL 22,418$ 1,873$ -$ -$ -$ FINANCE DIVISION TOTAL 910,309$ 865,434$ 1,034,700$ 966,850$ 1,063,750$ FINANCE DEPARTMENT 12 Municipal Court Division Line Item Budget Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REGULAR WAGES $ 128,319 $ 133,573 $ 137,000 $ 131,700 $ 137,900 PART-TIME WAGES 63,230 58,901 70,400 64,700 74,100 OVERTIME 10,788 4,498 8,000 5,000 8,000 LONGEVITY 2,920 3,040 3,200 3,200 3,300 HEALTH & DENTAL 17,695 17,717 17,800 19,400 22,000 TMRS 18,612 18,561 19,400 18,400 19,600 FICA 15,133 14,649 16,400 14,800 16,400 WORKERS COMPENSATION 367 516 300 300 300 OTHER BENEFITS 651 516 700 600 700 HSA CONTRIBUTION 375 5,625 4,000 4,000 4,000 PERSONNEL 258,090$ 257,596$ 277,200$ 262,100$ 286,300$ OFFICE SUPPLIES $ 1,693 $ 2,089 $ 3,000 $ 2,000 $ 2,000 POSTAGE & SHIPPING 794 844 1,000 1,000 1,000 PROFESSIONAL DUES 510 505 600 600 750 PUBLICATIONS 796 - 600 - 600 PROFESSIONAL DEVELOPMENT 4,618 1,370 4,000 2,500 4,000 CREDIT CARD FEES 210 382 500 500 500 OTHER CONTRACTED SERVICES 3,466 3,292 4,000 3,500 4,000 OPERATING 12,087$ 8,482$ 13,700$ 10,100$ 12,850$ MUNICIPAL COURT DIVISION TOTAL 270,177$ 266,078$ 290,900$ 272,200$ 299,150$ FINANCE DEPARTMENT 13 City-Wide Division Budget Detail by Line Item Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 RETIREE BENEFITS $ 188,600 $ 94,400 $ 98,300 $ 94,400 $ 98,800 OTHER BENEFITS 348,300 - - - - HSA CONTRIBUTION 1,375 6,625 5,500 5,250 6,000 BUILDINGS & GROUNDS MAINTENANCE 2,500 - - - - ELECTRIC SERVICE 149,294 91,770 115,000 100,000 100,000 STREET LIGHTING - ELECTRIC SERVICE 117,915 53,246 75,000 70,000 75,000 NATURAL GAS SERVICE 3,080 2,305 3,000 3,000 3,000 OTHER CONTRACTED SERVICES - 11,855 - 3,000 - GENERAL LIABILITY INSURANCE 8,330 8,976 10,000 9,000 10,100 ERRORS & OMISSIONS 16,450 16,496 18,000 17,000 22,200 CRIME COVERAGE FIDELITY 2,907 3,124 3,200 3,200 3,200 AUTO LIABILITY 38,192 39,808 42,000 41,000 46,200 AUTO PHYSICAL DAMAGE 29,529 33,144 30,000 30,000 30,000 UNDERGROUND STORAGE LIABILITY 500 500 800 500 800 REAL & PERSONAL PROPERTY 99,907 104,910 111,000 107,000 121,500 DEDUCTIBLE 1,180 (290) 10,000 10,000 10,000 PROPERTY TAXES 11,288 1,758 - - - BAD DEBT EXPENSE - 145 - 1,700 200 LAND ACQUISITION 678,263 - - - - CITY-WIDE DIVISION TOTAL 1,697,611$ 468,771$ 521,800$ 495,050$ 527,000$ FINANCE DEPARTMENT 14 Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 Patrol Personnel 3,026,550$ 3,130,692$ 3,388,000$ 3,131,450$ 3,459,200$ Operating 817,541 867,311 1,229,300 951,100 1,098,000 Capital - 27,716 - - - Total 3,844,091$ 4,025,719$ 4,617,300$ 4,082,550$ 4,557,200$ Support Services Personnel 696,079$ 711,784$ 911,100$ 865,700$ 998,050$ Operating 914 58 2,800 1,000 5,500 Total 696,993$ 711,842$ 913,900$ 866,700$ 1,003,550$ Total Department 4,541,084$ 4,737,561$ 5,531,200$ 4,949,250$ 5,560,750$ Police Department Staffing Schedule 2021 2022 POSITION GRADE BUDGET BUDGET MINIMUM MAXIMUM Police Department Patrol Police Chief 13 1 1 132,250$ 204,988$ Police Captain 11 1 0 104,650$ 151,743$ Patrol Lieutenant P3 0 2 97,500$ 126,750$ Police Sergeant P2 6 5 81,000$ 105,300$ Police Officer P1 18 18 67,500$ 87,750$ Community Resource Officer P1 1 1 67,500$ 87,750$ Support Services Animal Control & Parking Enforcement 4 0 1 42,592$ 61,758$ Administrative Assistant-PD 4 1 1 42,592$ 61,758$ Emergency Telecommunications Operator 4 9 9 42,592$ 61,758$ Office Assistant-Direct Link 2 1 1 35,200$ 51,000$ Total Police Department 38 39 POLICE DEPARTMENT SALARY RANGE 15 Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REGULAR WAGES $ 1,944,842 $ 2,016,890 $ 2,228,900 $ 2,098,900 $ 2,306,400 OVERTIME 286,215 303,448 245,000 245,000 250,000 LONGEVITY 11,215 11,996 14,100 12,100 13,600 HEALTH & DENTAL 264,162 231,779 317,300 227,600 283,700 TMRS 294,400 306,516 326,900 312,400 339,500 FICA 165,387 171,262 181,800 169,900 189,500 WORKERS COMPENSATION 36,639 54,607 32,000 31,400 34,300 ALLOWANCES 7,680 7,488 7,700 6,800 8,600 OTHER BENEFITS 10,703 9,503 14,800 12,500 14,100 HSA CONTRIBUTION 1,875 15,900 16,000 13,350 16,000 EMPLOYEE RELATIONS 3,432 1,302 3,500 1,500 3,500 PERSONNEL 3,026,550$ 3,130,692$ 3,388,000$ 3,131,450$ 3,459,200$ OFFICE SUPPLIES $ 9,494 $ 10,373 $ 8,600 $ 8,600 $ 8,600 APPREHENSION & JAILING 1,861 861 1,400 1,400 1,400 OPERATING SUPPLIES 17,240 60,327 53,800 53,800 45,000 FUEL 35,968 23,027 42,000 35,000 40,000 EQUIPMENT MAINTENANCE - 1,128 2,300 2,300 2,300 VEHICLE MAINTENANCE 36,557 29,499 27,500 27,500 25,000 POSTAGE & SHIPPING 1,190 894 2,000 2,000 10,000 CONSULTANTS 1,857 6,411 6,000 6,000 - EQUIPMENT LEASE/RENTAL 7,581 6,560 7,700 5,000 4,700 PROFESSIONAL DUES 4,708 2,222 3,500 4,000 3,500 PUBLICATIONS 7,391 3,863 - - - PROFESSIONAL DEVELOPMENT 23,696 7,372 36,500 20,000 36,500 OTHER CONTRACTED SERVICES - 1,903 272,500 25,000 75,500 LAW ENFORCEMENT LIABILITY 15,054 14,433 17,000 17,000 23,000 COMMUNITY RELATIONS 1,045 7,937 26,000 21,000 40,000 TRANSFER TO ASSET REPLACEMENT FUND - - 10,500 10,500 10,500 TRANSFER TO VEHICLE REPLACEMENT FUND 104,000 108,500 121,000 121,000 118,000 TRANSFER TO TECHNOLOGY MANAGEMENT FUND 549,900 582,000 591,000 591,000 654,000 OPERATING 817,541$ 867,311$ 1,229,300$ 951,100$ 1,098,000$ OTHER EQUIPMENT $ - $ 27,716 $ - $ - $ - CAPITAL -$ 27,716$ -$ -$ -$ PATROL DIVISION TOTAL 3,844,091$ 4,025,719$ 4,617,300$ 4,082,550$ 4,557,200$ POLICE DEPARTMENT Patrol Division Line Item Budget 16 Support Services Division Line Item Budget Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REGULAR WAGES $ 422,973 $ 449,871 $ 575,300 $ 568,100 $ 642,300 OVERTIME 88,938 88,576 80,000 81,700 85,000 LONGEVITY 4,586 4,670 5,300 5,300 6,000 HEALTH & DENTAL 69,929 53,659 107,800 66,600 104,200 TMRS 67,389 71,209 86,300 88,200 96,400 FICA 38,473 40,862 48,100 50,700 54,700 WORKERS COMPENSATION 888 1,360 900 900 1,000 ALLOWANCES - - - - 900 OTHER BENEFITS 2,280 1,578 2,900 2,700 3,050 HSA CONTRIBUTION 625 - 4,500 1,500 4,500 PERSONNEL 696,079$ 711,784$ 911,100$ 865,700$ 998,050$ PROFESSIONAL DEVELOPMENT $ 914 $ 58 $ 2,800 $ 1,000 $ 3,000 OPERATING SUPPLIES - - - - 2,500 OPERATING 914$ 58$ 2,800$ 1,000$ 5,500$ SUPPORT SERVICES DIVISION TOTAL 696,993$ 711,842$ 913,900$ 866,700$ 1,003,550$ POLICE DEPARTMENT 17 Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 Fire Personnel 2,911,648$ 3,041,823$ 3,192,000$ 2,976,700$ 3,218,400$ Operating 592,013 614,796 649,800 643,500 701,600 Capital 43,288 53,818 8,200 16,000 32,300 Total 3,546,949$ 3,710,437$ 3,850,000$ 3,636,200$ 3,952,300$ Total Department 3,546,949$ 3,710,437$ 3,850,000$ 3,636,200$ 3,952,300$ Fire Department Staffing Schedule 2021 2022 POSITION GRADE BUDGET BUDGET MINIMUM MAXIMUM Fire Department Fire Chief 13 1 1 132,250$ 204,988$ Fire Marshal / Assistant 11 1 1 104,650$ 151,743$ Fire Captain F4 3 3 92,500$ 120,250$ Fire Lieutenant F3 3 3 78,125$ 101,563$ Firefighter / Paramedic F2 15 15 60,000$ 81,250$ Total Fire Department 23 23 FIRE DEPARTMENT SALARY RANGE 18 Fire Division Line Item Budget Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REGULAR WAGES $ 1,818,126 $ 2,028,076 $ 2,084,400 $ 1,983,300 $ 2,143,500 OVERTIME 279,804 178,549 245,000 220,000 220,000 LONGEVITY 12,880 12,488 13,600 12,600 13,500 HEALTH & DENTAL 309,435 249,389 276,400 224,300 256,700 TMRS 277,824 291,750 307,100 291,400 313,300 FICA 155,635 162,885 173,700 163,500 176,900 WORKERS COMPENSATION 27,448 55,180 27,100 32,900 29,900 ALLOWANCES 8,880 8,658 8,900 8,700 8,900 OTHER BENEFITS 11,589 9,036 12,800 11,400 12,200 HSA CONTRIBUTION 6,875 45,150 40,000 25,600 40,000 EMPLOYEE RELATIONS 3,152 662 3,000 3,000 3,500 PERSONNEL 2,911,648$ 3,041,823$ 3,192,000$ 2,976,700$ 3,218,400$ OFFICE SUPPLIES $ 1,840 $ 2,196 $ 3,000 $ 3,000 $ 3,000 OPERATING SUPPLIES 48,415 61,639 28,000 33,000 33,000 EMS SUPPLIES - - 28,000 28,000 30,000 FUEL 8,838 5,041 10,000 8,000 10,000 EQUIPMENT MAINTENANCE 13,387 11,216 19,000 16,000 28,200 VEHICLE MAINTENANCE 33,724 40,931 45,000 45,000 45,000 POSTAGE & SHIPPING 106 320 500 500 500 PROFESSIONAL DUES 5,735 4,876 5,000 5,000 6,500 PUBLICATIONS 2,055 1,521 2,000 2,000 2,000 PROFESSIONAL DEVELOPMENT 33,059 28,825 44,500 44,500 44,500 OTHER CONTRACTED SERVICES 30,967 28,832 43,300 37,000 43,100 COMMUNITY RELATIONS 4,587 3,500 4,000 4,000 5,000 TRANSFER TO VEHICLE REPLACEMENT FUND 168,000 167,000 145,000 145,000 144,000 TRANSFER TO TECHNOLOGY MANAGEMENT FUND 222,700 231,400 239,600 239,600 263,300 TRANSFER TO ASSET REPLACEMENT FUND 18,600 27,500 32,900 32,900 43,500 OPERATING 592,013$ 614,796$ 649,800$ 643,500$ 701,600$ FURNITURE & EQUIP <$5000 $ 1,062 $ 673 $ 3,200 $ 4,000 $ - OTHER EQUIPMENT 42,225 43,245 5,000 5,000 32,300 OTHER CONSTRUCTION COSTS - 9,900 - 7,000 - CAPITAL 43,288$ 53,818$ 8,200$ 16,000$ 32,300$ FIRE DIVISION TOTAL 3,546,949$ 3,710,437$ 3,850,000$ 3,636,200$ 3,952,300$ FIRE DEPARTMENT 19 Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 Public Works Administration Personnel 44,363$ 159,965$ 400,600$ 364,200$ 400,200$ Operating 203,410 169,288 217,600 220,100 205,700 Total 247,773$ 329,253$ 618,200$ 584,300$ 605,900$ Community Development * Personnel 481,614$ 618,575$ 639,100$ 606,200$ 656,600$ Operating 70,422 125,167 156,800 143,600 249,300 Capital - - - 30,000 - Total 552,035$ 743,742$ 795,900$ 779,800$ 905,900$ Streets & Drainage Personnel 73,545$ 79,387$ 133,000$ 128,500$ 135,100$ Operating 274,409 416,974 434,600 433,100 386,200 Capital 2,966 - - - - Total 350,920$ 496,360$ 567,600$ 561,600$ 521,300$ Facilities Maintenance Personnel 179,084$ 247,501$ 257,500$ 242,700$ 258,600$ Operating 646,478 666,667 663,600 674,800 716,000 Capital 26,004 145,478 97,000 97,000 94,200 Total 851,566$ 1,059,646$ 1,018,100$ 1,014,500$ 1,068,800$ General Services Personnel 436,721$ 454,438$ 333,300$ 336,300$ 341,300$ Operating 222,259 185,956 215,950 204,700 215,600 Capital 15,084 8,272 72,000 55,000 5,000 Total 674,064$ 648,666$ 621,250$ 596,000$ 561,900$ Planning * Personnel 193,664$ -$ -$ -$ -$ Operating 122,647 - - - - Total 316,311$ -$ -$ -$ -$ Total Department 2,992,669$ 3,277,667$ 3,621,050$ 3,536,200$ 3,663,800$ * Planning division has been moved to Community Development division PUBLIC WORKS DEPARTMENT 20 Public Works Staffing Schedule (General Fund) 2021 2022 POSITION GRADE BUDGET BUDGET MINIMUM MAXIMUM Public Works Public Works Administration Public Works Director 12 1 1 115,000$ 178,250$ Assistant Director of Public Works 11 1 1 104,650$ 151,743$ Administrative Specialist 5 1 1 49,000$ 71,050$ Community Development Chief Building Official 10 1 1 91,000$ 131,950$ Administrative Coordinator (PW)6 1 1 53,900$ 78,155$ Building Inspector 5 2 2 49,000$ 71,050$ Code Enforcement Officer 4 1 1 42,592$ 61,758$ Permit Technician 2 2 2 35,200$ 51,000$ Operations Maintenance Worker III 4 1 1 42,592$ 61,758$ Maintenance Worker I 1 1 1 32,000$ 46,400$ Facilities Maintenance Facilities Maintenance Manager 9 1 1 71,741$ 104,024$ Facilities Maintenance Technician 4 2 2 42,592$ 61,758$ General Services Lead Mechanic 6 1 1 53,900$ 78,155$ Lead Traffic Technician 5 1 1 49,000$ 71,050$ Mechanic 4 1 1 42,592$ 61,758$ Traffic Technician 2 1 1 35,200$ 51,000$ Total Public Works Department 19 19 SALARY RANGE PUBLIC WORKS DEPARTMENT 21 Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REGULAR WAGES $ 29,741 $ 117,481 $ 286,000 $ 267,700 $ 288,700 LONGEVITY 1,055 1,115 1,600 1,200 1,800 HEALTH & DENTAL 2,047 6,677 36,300 23,400 30,700 TMRS 4,248 16,390 38,600 36,300 39,200 FICA 2,449 9,518 21,700 20,100 22,100 WORKERS COMPENSATION 65 319 400 300 400 ALLOWANCES 1,760 6,669 7,700 7,700 7,700 OTHER BENEFITS 109 355 1,000 1,500 1,300 HSA CONTRIBUTION - - 1,500 - 1,500 EMPLOYEE RELATIONS 2,889 1,441 5,800 5,000 5,800 PERSONNEL 44,363$ 159,965$ 400,600$ 364,200$ 400,200$ OFFICE SUPPLIES $ 4,117 $ 3,737 $ 4,500 $ 4,500 $ 4,500 OPERATING SUPPLIES 2,338 2,298 2,000 2,500 2,500 POSTAGE & SHIPPING 29 250 1,000 1,000 1,000 ELECTRIC SERVICE 6,612 3,868 6,000 4,500 6,000 CONSULTANTS 55,650 22,004 35,000 35,000 35,000 EQUIPMENT LEASE/RENTAL 6,911 6,338 7,000 3,000 3,000 PROFESSIONAL DUES 50 1,546 2,100 2,100 3,000 PROFESSIONAL DEVELOPMENT 6,464 999 7,000 6,500 10,000 CREDIT CARD FEES 11,503 13,916 12,000 20,000 - OTHER CONTRACTED SERVICES 36,707 35,434 54,000 54,000 54,000 COMMUNITY RELATIONS 428 - 5,000 5,000 8,500 TRANSFER TO TECHNOLOGY MANAGEMENT FUND 72,600 78,900 82,000 82,000 78,200 OPERATING 203,410$ 169,288$ 217,600$ 220,100$ 205,700$ PUBLIC WORKS ADMINISTRATION DIVISION TOTAL 247,773$ 329,253$ 618,200$ 584,300$ 605,900$ Public Works Administration Division Line Item Budget PUBLIC WORKS DEPARTMENT 22 Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REGULAR WAGES $ 348,801 $ 436,787 $ 447,500 $ 430,900 $ 460,200 OVERTIME 7,737 8,981 6,500 6,500 7,000 LONGEVITY 2,889 4,035 4,500 4,500 4,900 HEALTH & DENTAL 43,661 68,345 75,100 67,200 76,100 TMRS 47,161 59,297 60,200 58,200 62,200 FICA 26,765 32,666 33,600 31,900 34,700 WORKERS COMPENSATION 939 1,721 900 900 800 ALLOWANCES 2,040 1,989 2,100 2,000 2,100 OTHER BENEFITS 1,621 1,722 2,200 2,100 2,100 HSA CONTRIBUTION - 3,000 6,500 2,000 6,500 EMPLOYEE RELATIONS -32 - - - PERSONNEL 481,614$ 618,575$ 639,100$ 606,200$ 656,600$ OFFICE SUPPLIES $ 151 $ 1,955 $ - $ - $ - OPERATING SUPPLIES 2,969 4,276 6,800 6,500 6,800 FUEL 1,006 2,457 4,000 3,000 3,000 VEHICLE MAINTENANCE 3,436 3,230 2,000 2,000 2,500 POSTAGE & SHIPPING 209 1,101 3,500 3,000 3,500 SURFACE WATER - - 1,000 - - EQUIPMENT LEASE/RENTAL 1,468 1,418 1,500 1,200 1,500 PROFESSIONAL DUES 490 1,205 900 900 1,200 PUBLICATIONS 435 301 2,000 1,800 500 PROFESSIONAL DEVELOPMENT 6,365 4,389 7,900 4,700 8,100 CREDIT CARD FEES - - - - 20,000 OTHER CONTRACTED SERVICES 48,061 92,835 106,700 100,000 181,700 COMMUNITY RELATIONS 831 - 8,500 8,500 8,500 TRANSFER TO VEHICLE REPLACEMENT FUND 5,000 5,000 12,000 12,000 12,000 TRANSFER TO ASSET REPLACEMENT FUND - 7,000 - - - OPERATING 70,422$ 125,167$ 156,800$ 143,600$ 249,300$ AUTOMOBILES $ - $ - $ - $ 30,000 $ - CAPITAL -$ -$ -$ 30,000$ -$ COMMUNITY DEVELOPMENT DIVISION 552,035$ 743,742$ 795,900$ 779,800$ 905,900$ Community Development Division Line Item Budget PUBLIC WORKS DEPARTMENT 23 Streets & Drainage Division Line Item Budget Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REGULAR WAGES $ 41,309 $ 49,358 $ 75,800 $ 75,600 $ 77,500 ON CALL 1,770 1,710 3,300 3,000 3,000 OVERTIME 8,863 2,033 8,000 8,000 8,000 LONGEVITY 440 500 700 700 800 HEALTH & DENTAL 8,652 10,724 24,300 21,800 24,700 TMRS 6,832 7,366 11,500 10,600 11,700 FICA 3,935 3,952 6,100 5,900 6,300 WORKERS COMPENSATION 1,123 1,774 1,300 1,300 1,200 OTHER BENEFITS 246 170 500 400 400 HSA CONTRIBUTION 375 1,800 1,500 1,200 1,500 PERSONNEL 73,545$ 79,387$ 133,000$ 128,500$ 135,100$ OPERATING SUPPLIES $ 3,992 $ 1,548 $ 2,200 $ 2,200 $ 2,200 FUEL 2,701 2,201 3,000 2,500 4,000 EQUIPMENT MAINTENANCE 65 54 1,000 500 1,000 VEHICLE MAINTENANCE 420 - - - - DRAINAGE MAINTENANCE 27,254 46,576 43,000 43,000 146,000 STREET MAINTENANCE 110,761 179,489 205,000 205,000 155,000 TRAFFIC CONTROL MAINTENANCE 774 - 1,000 1,000 1,000 PROFESSIONAL DEVELOPMENT 600 - - - - OTHER CONTRACTED SERVICES 13,343 32,305 45,000 45,000 45,000 COMMUNITY RELATIONS - - 1,500 1,000 - TRANSFER TO VEHICLE REPLACEMENT FUND 8,000 8,000 8,000 8,000 8,000 TRANSFER TO ASSET REPLACEMENT FUND 106,500 146,800 124,900 124,900 24,000 OPERATING 274,409$ 416,974$ 434,600$ 433,100$ 386,200$ OTHER EQUIPMENT $ 2,966 $ - $ - $ - $ - CAPITAL 2,966$ -$ -$ -$ -$ STREETS & DRAINAGE DIVISION TOTAL 350,920$ 496,360$ 567,600$ 561,600$ 521,300$ PUBLIC WORKS DEPARTMENT 24 Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REGULAR WAGES $ 118,445 $ 162,446 $ 170,700 $ 163,200 $ 175,300 ON CALL 2,775 4,884 5,500 5,500 5,500 OVERTIME 1,681 3,567 3,000 3,000 3,000 LONGEVITY 345 465 700 700 900 HEALTH & DENTAL 25,372 27,204 30,500 24,100 25,300 TMRS 16,191 22,561 23,600 23,500 24,300 FICA 9,056 12,714 13,300 13,300 13,900 WORKERS COMPENSATION 2,765 5,598 3,000 3,400 3,200 ALLOWANCES 840 819 900 800 900 OTHER BENEFITS 614 642 800 800 800 HSA CONTRIBUTION 1,000 6,600 5,500 4,400 5,500 PERSONNEL 179,084$ 247,501$ 257,500$ 242,700$ 258,600$ OPERATING SUPPLIES $ 1,689 $ 2,955 $ 5,000 $ 5,000 $ 5,500 FUEL 1,032 790 2,000 1,500 1,500 EMERGENCY GENERATOR FUEL 1,739 4,401 3,700 20,000 5,000 EQUIPMENT MAINTENANCE 71,931 67,819 77,300 77,000 86,800 VEHICLE MAINTENANCE 3,099 6,593 6,000 5,000 6,000 BUILDING & GROUNDS MAINTENANCE 47,864 47,267 55,000 55,000 61,700 PROFESSIONAL DUES 410 563 1,000 1,200 1,200 PROFESSIONAL DEVELOPMENT 3,785 866 7,000 3,500 8,500 OTHER CONTRACTED SERVICES 310,729 298,659 302,000 302,000 327,600 TRANSFER TO VEHICLE REPLACEMENT FUND 8,000 31,855 12,000 12,000 13,000 TRANSFER TO TECHNOLOGY MANAGEMENT FUND 22,800 26,100 27,100 27,100 25,200 TRANSFER TO ASSET REPLACEMENT FUND 173,400 178,800 165,500 165,500 174,000 OPERATING 646,478$ 666,667$ 663,600$ 674,800$ 716,000$ OTHER EQUIPMENT $ - $ 84,484 $ 45,500 $ 45,500 $ 28,000 OTHER CONSTRUCTION COSTS 26,004 60,995 51,500 51,500 66,200 CAPITAL 26,004$ 145,478$ 97,000$ 97,000$ 94,200$ FACILITY MAINTENANCE TOTAL 851,566$ 1,059,646$ 1,018,100$ 1,014,500$ 1,068,800$ PUBLIC WORKS DEPARTMENT Facility Maintenance Division Line Item Budget 25 Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REGULAR WAGES $ 290,154 $ 296,661 $ 211,500 $ 210,700 $ 216,300 ON CALL 10,155 10,563 11,000 11,000 11,000 OVERTIME 11,329 14,748 8,500 15,000 10,000 LONGEVITY 2,290 2,890 2,800 3,200 3,000 HEALTH & DENTAL 48,646 48,807 42,800 38,200 43,400 TMRS 41,213 42,656 30,600 31,800 31,600 FICA 23,217 23,786 16,900 17,700 17,500 WORKERS COMPENSATION 5,813 8,946 4,200 5,300 4,500 ALLOWANCES 1,700 749 1,000 - - OTHER BENEFITS 1,456 1,032 1,000 1,000 1,000 HSA CONTRIBUTION 750 3,600 3,000 2,400 3,000 PERSONNEL 436,721$ 454,438$ 333,300$ 336,300$ 341,300$ OPERATING SUPPLIES $ 11,900 $ 13,641 $ 12,300 $ 12,300 $ 13,600 FUEL 6,752 4,048 7,000 5,000 7,000 EQUIPMENT MAINTENANCE 1,001 - 5,000 2,500 5,000 VEHICLE MAINTENANCE 7,877 15,992 9,000 15,000 12,000 TRAFFIC CONTROL MAINTENANCE 24,977 18,393 23,000 23,000 23,000 ELECTRIC SERVICE 5,168 3,099 5,000 4,000 5,000 NATURAL GAS SERVICE 829 787 900 1,000 1,000 EQUIPMENT LEASE/RENTAL 273 266 300 700 700 PROFESSIONAL DUES 2,603 560 2,200 1,900 1,900 PUBLICATIONS 950 950 950 1,000 1,000 PROFESSIONAL DEVELOPMENT 9,721 603 8,000 6,000 9,000 OTHER CONTRACTED SERVICES 32,787 18,252 30,000 20,000 30,000 COMMUNITY RELATIONS 3,720 (373) 2,000 2,000 - TRANSFER TO VEHICLE REPLACEMENT FUND 28,000 28,000 28,000 28,000 29,000 TRANSFER TO TECHNOLOGY MANAGEMENT FUND 30,000 30,200 31,300 31,300 26,400 TRANSFER TO ASSET REPLACEMENT FUND 55,700 51,500 51,000 51,000 51,000 OPERATING 222,259$ 185,956$ 215,950$ 204,700$ 215,600$ OTHER EQUIPMENT $ 8,740 $ 8,272 $ 60,000 $ 50,000 $ - CONSTRUCTION COSTS 6,344 - 12,000 5,000 5,000 CAPITAL 15,084$ 8,272$ 72,000$ 55,000$ 5,000$ GENERAL SERVICES DIVISION TOTAL 674,064$ 648,666$ 621,250$ 596,000$ 561,900$ General Services Division Line Item Budget PUBLIC WORKS DEPARTMENT 26 Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REGULAR WAGES $ 145,447 $ - $ - $ - $ - OVERTIME 133 - - - - LONGEVITY 1,832 - - - - HEALTH & DENTAL 13,518 - - - - TMRS 19,364 - - - - FICA 11,135 - - - - WORKERS COMPENSATION 425 - - - - ALLOWANCES 1,050 - - - - OTHER BENEFITS 761 - - - - PERSONNEL 193,664$ -$ -$-$-$ OPERATING SUPPLIES $ 1,045 $ - $ - $ - $ - FUEL 1,576 - - - - VEHICLE MAINTENANCE 3,107 - - - - COMMUNICATION 2,263 - - - - SURFACE WATER 121 - - - - CONSULTANTS 12,900 - - - - PROFESSIONAL DUES 431 - - - - TRAVEL & TRAINING 700 - - - - OTHER CONTRACTED SERVICES 94,616 - - - - COMMUNITY RELATIONS 588 - - - - TRANSFER TO VEHICLE REPLACEMENT FUND 5,300 - - - - OPERATING 122,647$ -$ -$-$-$ PLANNING DIVISION TOTAL 316,311$ -$ -$ -$ -$ * Moved to Community Development in the 2020 Budget Planning Division Line Item Budget * PUBLIC WORKS DEPARTMENT 27 Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 P&R Administration Personnel 367,194$ 384,043$ 389,500$ 378,200$ 399,900$ Operating 205,924 55,227 75,400 114,300 176,400 Capital 1,692 - - 2,400 - Total 574,809$ 439,270$ 464,900$ 494,900$ 576,300$ Senior Services Personnel 233,594$ 212,799$ 252,600$ 213,750$ 265,800$ Operating 166,398 116,654 201,900 141,200 190,000 Capital - 1,078 - 6,100 - Total 399,991$ 330,532$ 454,500$ 361,050$ 455,800$ Recreation Center Personnel 758,513$ 674,638$ 808,600$ 743,770$ 863,600$ Operating 1,290,815 654,297 1,224,850 1,040,700 1,239,800 Capital 290 8,275 32,000 45,500 29,000 Total 2,049,618$ 1,337,210$ 2,065,450$ 1,829,970$ 2,132,400$ Parks Maintenance Personnel 211,699$ 218,406$ 225,800$ 213,120$ 230,400$ Operating 386,982 341,750 423,100 426,500 418,700 Capital - - - 136,000 40,000 Total 598,681$ 560,156$ 648,900$ 775,620$ 689,100$ Colonial Park Personnel 192,059$ 159,153$ 222,600$ 194,500$ 223,800$ Operating 257,603 214,301 245,100 241,000 251,600 Capital - - 12,000 11,800 5,000 Total 449,662$ 373,454$ 479,700$ 447,300$ 480,400$ Total Department 4,072,762$ 3,040,622$ 4,113,450$ 3,908,840$ 4,334,000$ PARKS & RECREATION DEPARTMENT 28 Parks and Recreation Department Staffing Schedule 2021 2022 POSITION GRADE BUDGET BUDGET MINIMUM MAXIMUM Parks and Recreation Administration Parks and Recreation Director 12 1 1 115,000$ 178,250$ Administrative Manager 911 71,741$ 104,024$ Executive Director FWUP 7 1 1 59,290$ 85,971$ Senior Services Senior Services Manager 811 65,219$ 94,568$ Program Specialist-Sr. Services 4 1 1 42,592$ 61,758$ Recreation Center Recreation Manager 911 71,741$ 104,024$ Recreation Operations Supervisor 711 59,290$ 85,971$ Program Specialist-Aquatics & Recreation 622 53,900$ 78,155$ Parks Maintenance Park Maintenance Manager 911 71,741$ 104,024$ Parks Technician 122 32,000$ 46,400$ Total Parks and Recreation Department 12 12 SALARY RANGE 29 Parks and Recreation Administration Division Line Item Budget Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REGULAR WAGES $ 257,793 $ 271,916 $ 273,600 $ 268,800 $ 281,500 LONGEVITY 3,205 3,385 3,600 3,600 3,800 HEALTH & DENTAL 40,324 36,232 39,800 35,800 40,500 TMRS 35,236 37,247 37,400 36,800 38,600 FICA 19,097 20,326 20,700 19,900 21,400 WORKERS COMPENSATION 491 724 400 400 400 ALLOWANCES 8,880 8,658 9,200 8,700 8,900 OTHER BENEFITS 1,208 948 1,300 1,200 1,300 HSA CONTRIBUTION - 3,625 2,500 2,000 2,500 EMPLOYEE RELATIONS 959 983 1,000 1,000 1,000 PERSONNEL 367,194$ 384,043$ 389,500$ 378,200$ 399,900$ OFFICE SUPPLIES $ 970 $ 97 $ 1,000 $ 1,000 $ 1,000 OPERATING SUPPLIES 2,817 2,117 3,000 3,000 3,000 SWIMMING POOL MAINTENANCE (179) (600) - - - POSTAGE & SHIPPING 23,120 16,591 26,000 26,000 5,000 ELECTRIC SERVICE 11,893 - - - - NATURAL GAS SERVICE 876 203 - 300 300 EQUIPMENT LEASE/RENTAL 4,214 2,944 4,000 2,100 2,100 PROFESSIONAL DUES 1,817 2,466 2,600 2,600 2,600 PROFESSIONAL DEVELOPMENT 4,061 1,029 6,000 5,000 7,500 YOUTH SPORTS 125,000 - - 40,000 100,000 COMMUNITY RELATIONS 4,436 2,897 4,500 6,000 31,700 TRANSFER TO TECHNOLOGY MANAGEMENT FUND 26,900 27,100 28,300 28,300 23,200 OPERATING 205,924$ 55,227$ 75,400$ 114,300$ 176,400$ FURNITURE & FIXTURES $ 1,692 $ - $ - $ 1,200 $ - CAPITAL 1,692$ -$ -$ 2,400$ -$ PARKS AND RECREATION ADMINISTRATION DIVISION TOTAL 574,809$ 439,270$ 464,900$ 494,900$ 576,300$ PARKS AND RECREATION DEPARTMENT 30 Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REGULAR WAGES $ 139,317 $ 144,171 $ 147,100 $ 143,000 $ 150,700 PART-TIME WAGES 42,589 16,298 48,000 20,500 53,500 OVERTIME 1,187 402 1,400 50 1,400 LONGEVITY 1,317 1,535 1,700 1,700 1,800 HEALTH & DENTAL 14,798 13,627 15,000 13,500 15,200 TMRS 18,522 19,131 19,600 19,000 23,000 FICA 13,931 12,235 15,100 12,400 15,700 WORKERS COMPENSATION 867 901 1,000 500 800 OTHER BENEFITS 690 525 700 700 700 HSA CONTRIBUTION 375 3,975 3,000 2,400 3,000 PERSONNEL 233,594$ 212,799$ 252,600$ 213,750$ 265,800$ OFFICE SUPPLIES $ 876 $ 728 $ 800 $ 800 $ 800 OPERATING SUPPLIES 2,938 1,609 5,500 5,500 5,500 FUEL 1,416 385 2,000 1,000 1,500 EQUIPMENT MAINTENANCE 58 80 - - - VEHICLE MAINTENANCE 424 1,341 1,500 1,500 2,500 POSTAGE & SHIPPING 11,860 11,842 12,000 12,000 4,000 ELECTRIC SERVICE - 5,412 10,000 7,000 10,000 NATURAL GAS SERVICE - 795 1,500 700 900 EQUIPMENT LEASE/RENTAL 1,250 1,016 1,300 600 800 PROFESSIONAL DUES 255 289 300 300 300 PROFESSIONAL DEVELOPMENT 817 278 900 500 900 CREDIT CARD FEES 3,438 1,834 4,000 3,000 4,000 INSTRUCTOR FEES 64,476 19,330 71,300 27,500 55,000 COMMUNITY RELATIONS 11,997 4,877 22,500 12,500 29,600 BOARDS AND COMMITTEES 4,594 5,039 5,000 5,000 5,000 TRANSFER TO VEHICLE REPLACEMENT FUND 9,000 9,000 9,000 9,000 12,000 TRANSFER TO TECHNOLOGY MANAGEMENT FUND 49,800 50,000 51,500 51,500 54,400 TRANSFER TO ASSET REPLACEMENT FUND 3,200 2,800 2,800 2,800 2,800 OPERATING 166,398$ 116,654$ 201,900$ 141,200$ 190,000$ FURNITURE & EQUIP <$5000 $ - $ 1,078 $ - $ - $ - OTHER EQUIPMENT - - - 6,100 - CAPITAL -$ 1,078$ -$ 6,100$ -$ SENIOR SERVICES DIVISION TOTAL 399,991$ 330,532$ 454,500$ 361,050$ 455,800$ Senior Services Division Line Item Budget PARKS AND RECREATION DEPARTMENT 31 Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REGULAR WAGES $ 266,499 $ 275,595 $ 282,500 $ 271,100 $ 296,700 PART-TIME WAGES 348,282 258,708 367,500 330,300 392,000 ON CALL 945 855 2,200 2,200 3,200 OVERTIME 4,037 3,072 6,300 5,600 6,300 LONGEVITY 1,555 1,795 2,000 1,800 1,900 HEALTH & DENTAL 28,308 26,137 28,700 24,200 37,700 TMRS 51,094 50,741 52,100 49,600 53,700 FICA 46,916 41,310 50,500 47,900 53,200 WORKERS COMPENSATION 5,949 6,824 8,100 4,500 8,000 ALLOWANCES 2,880 2,808 2,900 2,620 2,900 OTHER BENEFITS 1,297 1,018 1,300 1,100 1,300 HSA CONTRIBUTION 750 5,775 4,500 2,850 4,500 EMPLOYEE RELATIONS - - - - 2,200 PERSONNEL 758,513$ 674,638$ 808,600$ 743,770$ 863,600$ OFFICE SUPPLIES $ 2,495 $ 894 $ 3,350 $ 2,300 $ 2,300 OPERATING SUPPLIES 58,961 29,204 67,200 64,200 29,400 TREATMENT CHEMICALS 13,261 7,236 15,300 15,900 16,300 EQUIPMENT MAINTENANCE 4,294 5,002 11,500 7,000 10,000 SWIMMING POOL MAINTENANCE 18,523 11,137 22,000 22,000 14,700 POSTAGE & SHIPPING 4,515 1,115 5,800 5,800 - ELECTRIC SERVICE 111,690 77,189 89,000 88,000 90,000 NATURAL GAS SERVICE 14,817 11,847 17,000 22,000 25,000 EQUIPMENT LEASE/RENTAL 3,102 2,557 4,000 2,400 2,400 PROFESSIONAL DUES 870 425 1,000 1,000 1,100 PROFESSIONAL DEVELOPMENT 10,030 3,465 7,700 5,000 10,300 CREDIT CARD FEES 39,571 21,310 39,200 34,000 39,200 INSTRUCTOR FEES 817,885 320,116 785,000 614,300 785,000 COMMUNITY RELATIONS - - - - 48,700 TRANSFER TO TECHNOLOGY MANAGEMENT FUND 104,000 102,600 106,600 106,600 118,400 TRANSFER TO ASSET REPLACEMENT FUND 86,800 60,200 50,200 50,200 47,000 OPERATING 1,290,815$ 654,297$ 1,224,850$ 1,040,700$ 1,239,800$ FURNITURE & EQUIP <$5000 $ 290 $ - $ - $ - $ - OTHER EQUIPMENT - 8,275 32,000 45,500 18,000 OTHER CONSTRUCTION COSTS - - - - 11,000 CAPITAL $ 290 $ 8,275 $ 32,000 $ 45,500 $ 29,000 RECREATION CENTER DIVISION TOTAL 2,049,618$ 1,337,210$ 2,065,450$ 1,829,970$ 2,132,400$ Recreation Center Division Line Item Budget PARKS AND RECREATION DEPARTMENT 32 Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REGULAR WAGES $ 138,898 $ 144,376 $ 146,800 $ 140,900 $ 150,000 PART-TIME WAGES 2,607 5,999 6,800 6,720 6,800 ON CALL 1,646 1,467 1,800 1,700 1,800 OVERTIME 1,370 637 1,900 500 1,900 LONGEVITY 465 645 800 800 1,000 HEALTH & DENTAL 33,354 29,921 32,900 29,500 33,400 TMRS 18,699 19,394 19,900 18,900 20,400 FICA 10,628 11,146 11,400 10,300 11,700 WORKERS COMPENSATION 2,415 3,419 1,900 2,200 1,800 ALLOWANCES 840 819 900 900 900 OTHER BENEFITS 777 582 700 700 700 PERSONNEL 211,699$ 218,406$ 225,800$ 213,120$ 230,400$ OFFICE SUPPLIES $ 275 $ 199 $ - $ - $ - OPERATING SUPPLIES 3,559 4,049 4,100 4,100 4,400 FUEL 3,798 2,677 5,000 4,000 4,000 EQUIPMENT MAINTENANCE 563 659 1,800 1,800 1,800 VEHICLE MAINTENANCE 3,565 1,592 2,500 8,500 8,500 BUILDING & GROUNDS MAINTENANCE 84,815 18,408 25,000 25,000 27,000 ELECTRIC SERVICE 14,333 6,882 12,000 12,000 12,000 PROFESSIONAL DEVELOPMENT 4,317 944 3,200 1,600 3,100 OTHER CONTRACTED SERVICES 181,958 215,841 277,900 277,900 271,000 TRANSFER TO VEHICLE REPLACEMENT FUND 8,000 8,000 8,000 8,000 14,000 TRANSFER TO TECHNOLOGY MANAGEMENT FUND 23,700 24,600 25,600 25,600 23,900 TRANSFER TO ASSET REPLACEMENT FUND 58,100 57,900 58,000 58,000 49,000 OPERATING 386,982$ 341,750$ 423,100$ 426,500$ 418,700$ OTHER EQUIPMENT - - - - 32,000 OTHER CONSTRUCTION COSTS - - - 136,000 8,000 CAPITAL $ - $ - $ - $ 136,000 $ 40,000 PARKS MAINTENANCE DIVISION TOTAL 598,681$ 560,156$ 648,900$ 775,620$ 689,100$ Parks Maintenance Division Line Item Budget PARKS AND RECREATION DEPARTMENT 33 Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REGULAR WAGES $ - $ - $ - $ - $ - PART-TIME WAGES 174,571 145,580 204,500 185,000 205,700 OVERTIME 377 78 - - - TMRS 131 70 - - - FICA 13,651 11,147 15,600 8,800 15,700 WORKERS COMPENSATION 3,329 2,279 2,500 700 2,400 PERSONNEL 192,059$ 159,153$ 222,600$ 194,500$ 223,800$ OFFICE SUPPLIES $ 481 $ 271 $ - $ - $ - OPERATING SUPPLIES 24,526 11,338 28,300 28,300 16,200 TREATMENT CHEMICALS 13,100 10,272 20,100 22,000 23,300 SWIMMING POOL MAINTENANCE 43,547 54,517 40,500 40,500 43,800 POSTAGE & SHIPPING 893 812 2,000 2,000 - ELECTRIC SERVICE 35,414 29,080 40,000 35,000 40,000 NATURAL GAS SERVICE 724 536 1,000 1,000 1,000 EQUIPMENT LEASE/RENTAL 293 380 500 700 700 CREDIT CARD FEES 3,026 596 4,300 3,100 3,100 COMMUNITY RELATIONS - - - - 14,000 TRANSFER TO TECHNOLOGY MANAGEMENT FUND 62,500 62,900 64,900 64,900 68,000 TRANSFER TO ASSET REPLACEMENT FUND 73,100 43,600 43,500 43,500 41,500 OPERATING 257,603$ 214,301$ 245,100$ 241,000$ 251,600$ OTHER EQUIPMENT $ - $ - $ 12,000 $ 11,800 $ 5,000 CAPITAL -$ -$ 12,000$ 11,800$ 5,000$ COLONIAL PARK DIVISION TOTAL 449,662$ 373,454$ 479,700$ 447,300$ 480,400$ PARKS AND RECREATION DEPARTMENT Colonial Park Division Line Item Budget 34 Transfers Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 TRANSFER FROM TRANSPORTATION IMPROVEMENT FUND $ - $ 100,000 $ - $ - $ - TRANSFER FROM 2019 CERT OF OBLIGATION FUND 86,954 - - - - TRANSFER FROM WATER & SEWER FUND 1,250,000 1,250,000 1,250,000 1,250,000 1,250,000 TRANSFER FROM SOLID WASTE FUND 310,000 310,000 310,000 310,000 310,000 TRANSFER FROM EMPLOYEE BENEFIT FUND 142,500 - - - - TRANSFER FROM HUMAN RESOURCE SVCS FUND - 80,691 135,300 168,000 177,400 TRANSFERS IN 1,789,454$ 1,740,691$ 1,695,300$ 1,728,000$ 1,737,400$ TRANSFER TO CAPITAL PROJECT FUND $ - $ - $ 300,000 $ 300,000 $ - TRANSFER TO CAPITAL RESERVE FUND - - - 7,000,000 - TRANSFER TO TECHNOLOGY MANAGEMENT FUND - - - 220,000 - TRANSFER TO EMPLOYEE BENEFIT FUND - 33,700 35,000 35,000 35,000 TRANSFER TO HUMAN RESOURCE SVCS FUND - 249,900 252,000 252,000 250,000 TRANSFERS OUT -$ 283,600$ 587,000$ 7,807,000$ 285,000$ GENERAL FUND 35 DEBT SERVICE FUND 36 DEBT SERVICE FUND STATEMENT OF REVENUES AND EXPENDITURES Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REVENUES: CURRENT YEAR PROPERTY TAXES 7,582,452$ 7,667,034$ 6,789,104$ 6,760,500$ 5,876,000$ PRIOR YEAR PROPERTY TAXES 67,846 56,848 35,000 50,000 50,000 PENALTY AND INTEREST 33,397 31,427 30,500 35,000 32,000 EARNINGS ON INVESTMENTS 4,492 10,332 7,500 1,500 2,000 TRANSFER FROM 2019 CERT OF OBLIGATION FUND 4,747 - - - - TRANSFER FROM TRANSPORTATION IMPROVEMENT FUND - 688,079 - - - TRANSFER FROM WATER & SEWER FUND 1,196,038 1,184,183 388,020 388,020 367,637 GENERAL OBLIGATION BOND PROCEEDS - 11,376,128 - - - TOTAL REVENUES 8,888,972$ 21,014,031$ 7,250,124$ 7,235,020$ 6,327,637$ EXPENDITURES: BOND PRINCIPAL 7,910,000$ 8,060,000$ 6,490,000$ 6,496,435$ 4,885,000$ INTEREST ON BONDS 920,492 930,783 683,374 1,364,103 1,411,700 FISCAL AGENT FEES 5,603 2,250 3,250 3,250 3,250 ISSUANCE COSTS 4,747 111,602 3,750 3,500 5,000 PAYMENT TO REFUNDED BOND ESCROW - 11,264,456 - - - TOTAL EXPENDITURES 8,840,842$ 20,369,091$ 7,180,374$ 7,867,288$ 6,304,950$ NET REVENUES 48,130$ 644,940$ 69,750$ (632,268)$ 22,687$ BEGINNING BALANCE 868,289$ 916,419$ 956,765$ 1,561,358$ 929,090$ ENDING BALANCE 916,419$ 1,561,358$ 1,026,515$ 929,090$ 951,777$ 37 Principal Principal Amount Outstanding Outstanding Series Obligation of Issue January 1, 2022 Principal Interest Total December 31, 2022 2011 Certificates of Obligation 910,000 490,000 240,000 8,325 248,325 250,000 2016 General Obligation Refunding 3,170,000 365,000 365,000 2,637 367,637 - 2017 General Obligation Refunding 9,965,000 6,605,000 - 132,761 132,761 6,605,000 2019 Certificates of Obligation 4,040,000 3,940,000 110,000 154,850 264,850 3,830,000 2020 General Obligation Refunding 10,780,000 8,065,000 2,705,000 225,331 2,930,331 5,360,000 2020 Certificates of Obligation 23,190,000 24,070,000 1,465,000 887,725 2,352,725 22,605,000 TOTAL 43,535,000$ 4,885,000$ 1,411,629$ 6,296,629$ 38,650,000$ CITY OF WEST UNIVERSITY PLACE GENERAL LONG TERM DEBT SCHEDULE OF FISCAL YEAR REQUIREMENTS Principal & Interest Requirements for 2022 38 Fiscal Year Principal Interest Due 2/1 Interest Due 8/1 Interest Total 2022 4,885,000 747,346 664,283 1,411,629 6,296,629 2023 2,825,000 664,283 609,971 1,274,254 4,099,254 2024 2,435,000 609,971 577,668 1,187,639 3,622,639 2025 2,500,000 577,668 546,320 1,123,988 3,623,988 2026 2,560,000 546,320 514,540 1,060,860 3,620,860 2027 2,630,000 514,540 478,159 992,699 3,622,699 2028 2,705,000 478,159 440,675 918,834 3,623,834 2029 970,000 440,675 418,025 858,700 1,828,700 2030 1,015,000 418,025 394,300 812,325 1,827,325 2031 1,065,000 394,300 369,400 763,700 1,828,700 2032 1,110,000 369,400 347,200 716,600 1,826,600 2033 1,155,000 347,200 324,100 671,300 1,826,300 2034 1,200,000 324,100 304,150 628,250 1,828,250 2035 785,000 304,150 292,375 596,525 1,381,525 2036 810,000 292,375 280,225 572,600 1,382,600 2037 835,000 280,225 267,700 547,925 1,382,925 2038 860,000 267,700 254,800 522,500 1,382,500 2039 885,000 254,800 241,525 496,325 1,381,325 2040 915,000 241,525 227,800 469,325 1,384,325 2041 945,000 227,800 208,900 436,700 1,381,700 2042 985,000 208,900 189,200 398,100 1,383,100 2043 1,025,000 189,200 168,700 357,900 1,382,900 2044 1,065,000 168,700 147,400 316,100 1,381,100 2045 1,110,000 147,400 125,200 272,600 1,382,600 2046 1,155,000 125,200 102,100 227,300 1,382,300 2047 1,200,000 102,100 78,100 180,200 1,380,200 2048 1,250,000 78,100 53,100 131,200 1,381,200 2049 1,300,000 53,100 27,100 80,200 1,380,200 2050 1,355,000 27,100 - 27,100 1,382,100 43,535,000$ 9,400,361$ 8,653,016$ 18,053,377$ 61,588,377$ CITY OF WEST UNIVERSITY PLACE GENERAL LONG TERM DEBT PRINCIPAL AND INTEREST REQUIREMENTS As of December 31, 2021 $- $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 $7,000,000 20222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050Annual Debt Service Requirements Principal Interest 39 WATER & SEWER FUND 40 WATER AND SEWER FUND STATEMENT OF REVENUES AND EXPENDITURES Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REVENUES: FEMA REIMBURSEMENT 19,897$ -$-$-$-$ WATER SERVICE 4,887,688 5,205,754 4,950,000 4,970,000 5,000,000 SEWER SERVICE 3,057,624 3,288,263 3,230,000 3,140,000 3,100,000 PENALTIES 54,562 32,276 50,000 45,000 45,000 CONNECTION FEE 92,825 68,650 81,000 78,800 80,000 EARNINGS ON INVESTMENTS 19,964 6,312 4,600 1,000 2,000 MISCELLANEOUS 1,510 1,244 5,300 (23,700) 1,500 TRANSFER FROM HUMAN RESOURCE SVCS FUND --44,600 43,200 - TOTAL REVENUE 8,134,070$ 8,602,500$ 8,365,500$ 8,254,300$ 8,228,500$ EXPENDITURES BY DEPARTMENT: DEBT SERVICE 1,196,038$ 1,202,796$ 388,020$ 573,020$ 393,020$ FINANCE 244,526 191,455 266,700 244,200 311,700 PUBLIC WORKS 4,288,106 4,183,535 4,431,300 4,358,400 4,769,300 TRANSFER TO GENERAL FUND 1,250,000 1,250,000 1,250,000 1,250,000 1,250,000 TRANSFER TO WATER & SEWER CAPITAL PROJECTS 900,000 900,000 2,700,000 2,700,000 900,000 TOTAL EXPENDITURES 7,878,670$ 7,727,786$ 9,036,020$ 9,125,620$ 7,624,020$ NET REVENUES (EXPENDITURES) 255,400$ 874,714$ (670,520)$ (871,320)$ 604,480$ BEGINNING WORKING CAPITAL 581,596$ 836,996$ 1,523,934$ 1,711,710$ 840,390$ ENDING WORKING CAPITAL 836,996$ 1,711,710$ 853,414$ 840,390$ 1,444,870$ OPERATIONS 62.6% FINANCE 4.1% DEBT SERVICE 5.2% TRANSFERS 28.2% Water & Sewer Fund 2022 Expenditures 41 WATER AND SEWER FUND STATEMENT OF REVENUES AND EXPENDITURES Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REVENUES: FEMA REIMBURSEMENT $ 19,897 $ - $ - $ - $ - WATER SERVICE 4,887,688 5,205,754 4,950,000 4,970,000 5,000,000 SEWER SERVICE 3,057,624 3,288,263 3,230,000 3,140,000 3,100,000 PENALTIES 54,562 32,276 50,000 45,000 45,000 CONNECTION FEE 92,825 68,650 81,000 78,800 80,000 EARNINGS ON INVESTMENTS 19,964 6,312 4,600 1,000 2,000 MISCELLANEOUS 1,510 1,244 5,300 (23,700) 1,500 TRANSFER FROM HUMAN RESOURCE SVCS FUND - - 44,600 43,200 - TOTAL REVENUE 8,134,070$ 8,602,500$ 8,365,500$ 8,254,300$ 8,228,500$ EXPENDITURES: REGULAR WAGES $ 728,729 $ 687,353 $ 741,700 $ 702,600 $ 745,600 ON CALL 14,445 13,647 14,800 14,800 14,500 OVERTIME 96,278 70,402 75,000 77,500 73,000 LONGEVITY 7,068 6,254 7,300 4,800 4,900 HEALTH & DENTAL 135,527 114,034 139,200 105,700 134,000 TMRS 111,054 101,995 110,000 112,400 110,300 FICA 61,517 56,769 61,300 64,300 60,900 WORKERS COMPENSATION 13,000 17,418 9,900 10,000 11,000 ALLOWANCES 3,815 3,318 3,700 2,100 2,600 OTHER BENEFITS 3,512 2,655 4,300 3,100 3,600 HSA CONTRIBUTION 1,375 13,250 17,500 4,000 17,500 EMPLOYEE RELATIONS 299 1,323 1,500 1,500 1,500 ACCRUED VACATION (46,856) (6,887) - - - PENSION EXPENSE 99,709 (19,137) - - - OPEB EXPENSE 14,062 (38,839) - - - OFFICE SUPPLIES 1,007 1,192 1,600 1,600 1,600 OPERATING SUPPLIES 13,221 26,137 30,000 30,000 30,000 FUEL 11,335 6,298 15,000 10,000 15,000 TREATMENT CHEMICALS 96,507 52,610 100,000 100,000 100,000 EQUIPMENT MAINTENANCE 19,138 15,776 27,300 27,300 30,000 VEHICLE MAINTENANCE 20,984 17,388 15,000 15,000 20,000 BUILDING & GROUNDS MAINTENANCE 37,807 25,675 30,000 30,000 30,000 WATER SYSTEM MAINTENANCE 142,271 169,806 200,000 200,000 200,000 SEWER SYSTEM MAINTENANCE 157,086 197,154 170,000 170,000 190,000 COMMUNICATION 1,948 - - - - ELECTRIC SERVICE 498,523 302,352 320,000 320,000 320,000 SURFACE WATER 1,615,576 1,538,297 1,600,000 1,600,000 1,750,000 NATURAL GAS SERVICE 346 321 400 400 400 OTHER UTILITIES - 114 - 1,000 1,000 EQUIPMENT LEASE/RENTAL 4,820 3,443 4,800 2,300 2,400 PROFESSIONAL DUES 1,916 1,431 2,800 2,800 2,800 TRAVEL & TRAINING 12,136 5,888 18,000 8,000 12,000 SLUDGE REMOVAL 45,240 67,868 71,000 90,000 95,000 CREDIT CARD FEES 46,335 72,535 83,000 78,000 80,400 OTHER CONTRACTED SERVICES 300,842 352,536 384,000 378,000 516,000 RESIDENT REIMBURSEMENT 641 - 3,000 1,500 3,000 COMMUNITY RELATIONS 6,429 3,540 12,000 10,000 25,000 FURNITURE & EQUIP <$5000 4,828 - - - - OTHER EQUIPMENT 8,244 3,725 96,000 96,000 60,000 OTHER CONSTRUCTION COSTS 14,117 168,450 - - - BAD DEBT EXPENSE - 18,613 - 185,000 5,000 TRANSFER TO DEBT SERVICE FUND 1,196,038 1,184,183 388,020 388,020 388,020 TRANSFER TO GENERAL FUND 1,250,000 1,250,000 1,250,000 1,250,000 1,250,000 TRANSFER TO WATER & SEWER CAPITAL PROJECTS 900,000 900,000 2,700,000 2,700,000 900,000 TRANSFER TO VEHICLE REPLACEMENT FUND 90,000 92,000 96,000 96,000 102,000 42 WATER AND SEWER FUND STATEMENT OF REVENUES AND EXPENDITURES Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 TRANSFER TO TECHNOLOGY MANAGEMENT FUND 137,800 140,000 139,000 139,000 145,000 TRANSFER TO ASSET REPLACEMENT FUND - 86,900 92,900 92,900 170,000 TOTAL EXPENDITURES $ 7,878,670 $ 7,727,786 $ 9,036,020 $ 9,125,620 $ 7,624,020 NET REVENUES (EXPENDITURES)255,400$ 874,714$ (670,520)$ (871,320)$ 604,480$ BEGINNING WORKING CAPITAL 581,596$ 836,996$ 1,523,934$ 1,711,710$ 840,390$ ENDING WORKING CAPITAL 836,996$ 1,711,710$ 853,414$ 840,390$ 1,444,870$ PERSONNEL 15.47% SURFACE WATER 22.95% OTHER OPERATING 13.50% WATER SYSTEM MAINT. 2.62% SEWER SYSTEM MAINT. 2.49% ELECTRIC SERVICE 4.20% DEBT SERVICE 5.09% TRANSFER TO GENERAL FUND 16.40% TRANSFER TO W&S CAPITAL FUND 11.80% OTHER TRANSFERS 5.47% Water & Sewer Fund 2022 Expenditures by Type 43 Principal Principal Amount Outstanding Outstanding Series Obligation of Issue January 1, 2022 Principal Interest Total December 31, 2022 2016 GO Refunding Bonds (W&S Portion)*3,170,000 365,000 365,000 2,637 367,637 - 365,000$ 365,000$ 2,637$ 367,637$ -$ * Portion of debt is transferred to General Debt Service Fund CITY OF WEST UNIVERSITY PLACE WATER & SEWER DEBT SERVICE SCHEDULE OF FISCAL YEAR REQUIREMENTS Principal & Interest Requirements for 2021 44 Fiscal Year Principal * Interest Due 2/1 * Interest Due 8/1 * Interest Total 2022 365,000$ 2,637$ -$ 2,637$ 367,637$ 365,000$ 2,637$ -$ 2,637$ 367,637$ CITY OF WEST UNIVERSITY PLACE WATER & SEWER DEBT SERVICE PRINCIPAL AND INTEREST REQUIREMENTS * Includes amount transferred to General Debt Service Fund for W&S portion of 2016 GO Refunding Bonds. $365,000 $2,637 $- $50,000 $100,000 $150,000 $200,000 $250,000 $300,000 $350,000 $400,000 $450,000 $500,000 2022Annual Debt Service Requirements Principal Interest 45 Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 Utility Billing & Customer Service Personnel 152,417$ 80,064$ 136,600$ 127,600$ 138,100$ Operating 91,781 111,391 130,100 116,600 173,600 Capital 328 - - - - Total 244,526$ 191,455$ 266,700$ 244,200$ 311,700$ Total Department 244,526$ 191,455$ 266,700$ 244,200$ 311,700$ Finance Department Staffing Schedule (W&S Fund) 2021 2022 POSITION GRADE BUDGET BUDGET MINIMUM MAXIMUM Finance - Utility Billing Sr. Customer Service Representative 5 1 1 49,000$ 71,050$ Accounting Specialist - Utility Billing 2 1 1 35,200$ 51,000$ Total Finance (W&S Fund)22 FINANCE DEPARTMENT SALARY RANGE 46 Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REGULAR WAGES $ 91,189 $ 69,510 $ 88,100 $ 85,600 $ 91,000 OVERTIME 9,904 7,709 5,000 2,500 3,000 LONGEVITY 248 - 200 200 300 HEALTH & DENTAL 13,583 14,401 21,600 19,300 21,700 TMRS 13,300 9,801 12,100 11,400 12,400 FICA 7,511 5,520 6,500 6,100 6,600 WORKERS COMPENSATION 182 196 100 100 100 OTHER BENEFITS 504 257 500 400 500 HSA CONTRIBUTION 375 4,125 2,500 2,000 2,500 ACCRUED VACATION 1,995 (5,538) - - - PENSION EXPENSE 11,941 (13,120) - - - OPEB EXPENSE 1,684 (12,797) - - - PERSONNEL 152,417$ 80,064$ 136,600$ 127,600$ 138,100$ OFFICE SUPPLIES $ (27) $ 549 $ - $ - $ - POSTAGE & SHIPPING 2,138 - - - - EQUIPMENT LEASE/RENTAL 3,180 2,441 3,600 1,600 1,700 PROFESSIONAL DEVELOPMENT 1,520 - 1,500 1,000 1,500 CREDIT CARD FEES 46,335 72,535 83,000 78,000 80,400 OTHER CONTRACTED SERVICES 38,635 35,866 42,000 36,000 90,000 OPERATIONS 91,781$ 111,391$ 130,100$ 116,600$ 173,600$ FURNITURE & EQUIP <$5000 $ 328 $ - $ - $ - $ - CAPITAL 328$ -$ -$ -$ -$ FINANCE DIVISION TOTAL 244,526$ 191,455$ 266,700$ 244,200$ 311,700$ WATER AND SEWER FUND FINANCE DEPARTMENT Finance Division Line Item Budget 47 Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 W&S Fund Operations Personnel 1,091,117$ 943,492$ 1,049,600$ 975,200$ 1,041,300$ Operating 3,170,128 3,067,868 3,285,700 3,287,200 3,668,000 Capital 26,861 172,175 96,000 96,000 60,000 Total 4,288,106$ 4,183,535$ 4,431,300$ 4,358,400$ 4,769,300$ Total Department 4,288,106$ 4,183,535$ 4,431,300$ 4,358,400$ 4,769,300$ Public Works Department Staffing Schedule (W&S Fund) 2021 2022 POSITION GRADE BUDGET BUDGET MINIMUM MAXIMUM Public Works - Operations Public Works Manager 10 1 1 91,000$ 131,950$ Field Services Supervisor 7 1 1 59,290$ 85,971$ Plant Supervisor 7 1 1 59,290$ 85,971$ Crew Leader 5 2 2 49,000$ 71,050$ Plant Operator, Sr.5 2 2 49,000$ 71,050$ Plant Operator 4 1 1 42,592$ 61,758$ Driver/Equipment Operator 2 1 1 35,200$ 51,000$ Maintenance Worker I 1 2 2 32,000$ 46,400$ Total Public Works (W&S Fund)11 11 PUBLIC WORKS DEPARTMENT SALARY RANGE 48 Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REGULAR WAGES $ 637,540 $ 617,843 $ 653,600 $ 617,000 $ 654,600 ON CALL 14,445 13,647 14,800 14,800 14,500 OVERTIME 86,374 62,693 70,000 75,000 70,000 LONGEVITY 6,820 6,254 7,100 4,600 4,600 HEALTH & DENTAL 121,944 99,632 117,600 86,400 112,300 TMRS 97,754 92,194 97,900 101,000 97,900 FICA 54,006 51,249 54,800 58,200 54,300 WORKERS COMPENSATION 12,818 17,222 9,800 9,900 10,900 ALLOWANCES 3,815 3,318 3,700 2,100 2,600 OTHER BENEFITS 3,007 2,398 3,800 2,700 3,100 HSA CONTRIBUTION 1,000 9,125 15,000 2,000 15,000 EMPLOYEE RELATIONS 299 1,323 1,500 1,500 1,500 ACCRUED VACATION (48,851) (1,348) - - - PENSION EXPENSE 87,768 (6,017) - - - OPEB EXPENSE 12,378 (26,042) - - - PERSONNEL 1,091,117$ 943,492$ 1,049,600$ 975,200$ 1,041,300$ OFFICE SUPPLIES $ 1,034 $ 643 $ 1,600 $ 1,600 $ 1,600 OPERATING SUPPLIES 13,221 26,137 30,000 30,000 30,000 FUEL 11,335 6,298 15,000 10,000 15,000 TREATMENT CHEMICALS 96,507 52,610 100,000 100,000 100,000 EQUIPMENT MAINTENANCE 19,138 15,776 27,300 27,300 30,000 VEHICLE MAINTENANCE 20,984 17,388 15,000 15,000 20,000 BUILDING & GROUNDS MAINTENANCE 37,807 25,675 30,000 30,000 30,000 WATER SYSTEM MAINTENANCE 142,271 169,806 200,000 200,000 200,000 SEWER SYSTEM MAINTENANCE 157,086 197,154 170,000 170,000 190,000 POSTAGE & SHIPPING (190) - - - - ELECTRIC SERVICE 498,523 302,352 320,000 320,000 320,000 SURFACE WATER 1,615,576 1,538,297 1,600,000 1,600,000 1,750,000 NATURAL GAS SERVICE 346 321 400 400 400 OTHER UTILITIES - 114 - 1,000 1,000 EQUIPMENT LEASE/RENTAL 1,640 1,002 1,200 700 700 PROFESSIONAL DUES 1,916 1,431 2,800 2,800 2,800 PROFESSIONAL DEVELOPMENT 10,616 5,888 16,500 7,000 10,500 SLUDGE REMOVAL 45,240 67,868 71,000 90,000 95,000 OTHER CONTRACTED SERVICES 262,207 316,669 342,000 342,000 426,000 RESIDENT REIMBURSEMENT 641 - 3,000 1,500 3,000 COMMUNITY RELATIONS 6,429 3,540 12,000 10,000 25,000 TRANSFER TO VEHICLE REPLACEMENT FUND 90,000 92,000 96,000 96,000 102,000 TRANSFER TO TECHNOLOGY MANAGEMENT FUND 137,800 140,000 139,000 139,000 145,000 TRANSFER TO ASSET REPLACEMENT FUND - 86,900 92,900 92,900 170,000 OPERATING 3,170,128$ 3,067,868$ 3,285,700$ 3,287,200$ 3,668,000$ FURNITURE & EQUIP <$5000 $ 4,500 $ - $ - $ - $ - OTHER EQUIPMENT 8,244 3,725 96,000 96,000 60,000 OTHER CONSTRUCTION COSTS 14,117 168,450 - - - CAPITAL 26,861$ 172,175$ 96,000$ 96,000$ 60,000$ OPERATIONS DIVISION TOTAL 4,288,106$ 4,183,535$ 4,431,300$ 4,358,400$ 4,769,300$ WATER AND SEWER FUND PUBLIC WORKS DEPARTMENT Operations Division Line Item Budget 49 SOLID WASTE FUND 50 SOLID WASTE FUND STATEMENT OF REVENUES AND EXPENDITURES Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REVENUES FEMA REIMBURSEMENT (562)$ -$ -$ -$ -$ STATE GRANT 27,500 - - - - SOLID WASTE COLLECTION 1,729,202 1,813,147 1,791,000 1,811,000 1,867,800 SOLID WASTE SPECIAL COLLECTION 3,000 650 500 500 500 SALE OF RECYCLABLES 1,440 - - 600 - EARNINGS ON INVESTMENTS 13,969 5,252 3,800 500 1,000 MISCELLANEOUS 848 741 600 (200) 800 TOTAL REVENUE 1,775,396$ 1,819,790$ 1,795,900$ 1,812,400$ 1,870,100$ EXPENDITURES BY DIVISION CITY-WIDE -$ 2,902$ -$ 35,000$ 500$ CURBSIDE SOLID WASTE 968,857 898,445 1,016,000 952,750 1,015,500 CURBSIDE RECYCLING 385,038 402,331 410,100 410,800 412,100 CURBSIDE GREEN WASTE RECYCLING 173,952 223,050 199,600 193,000 208,450 TRANSFER TO GENERAL FUND 310,000 310,000 310,000 310,000 310,000 TOTAL EXPENDITURES 1,837,847$ 1,836,729$ 1,935,700$ 1,901,550$ 1,946,550$ NET REVENUES (EXPENDITURES)(62,450)$ (16,938)$ (139,800)$ (89,150)$ (76,450)$ BEGINNING WORKING CAPITAL 493,138$ 430,688$ 487,142$ 413,749$ 324,599$ ENDING WORKING CAPITAL 430,688$ 413,749$ 347,342$ 324,599$ 248,149$ 51 Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 FEMA REIMBURSEMENT $ (562) $ - $ - $ - STATE GRANT 27,500 - - - - SOLID WASTE COLLECTION 1,729,202 1,813,147 1,791,000 1,811,000 1,867,800 SOLID WASTE SPECIAL COLLECTION 3,000 650 500 500 500 SALE OF RECYCLABLES 1,440 - - 600 - EARNINGS ON INVESTMENTS 13,969 5,252 3,800 500 1,000 CASH OVER/SHORT - - - (1,000) - MISCELLANEOUS 848 741 600 800 800 REVENUE 1,775,396$ 1,819,790$ 1,795,900$ 1,812,400$ 1,870,100$ BAD DEBT EXPENSE $ - $ 2,902 $ - $ 35,000 500$ CITY-WIDE -$ 2,902$ -$ 35,000$ 500$ REGULAR WAGES $ 234,065 $ 215,288 $ 250,100 $ 225,800 249,800$ OVERTIME 11,319 9,304 14,000 14,000 14,000 LONGEVITY 2,331 2,303 2,700 1,900 2,000 HEALTH & DENTAL 48,315 42,150 42,300 35,900 47,300 TMRS 32,342 29,478 34,800 31,100 34,900 FICA 17,880 16,340 19,400 17,300 19,100 WORKERS COMPENSATION 8,978 11,651 7,600 6,500 6,700 OTHER BENEFITS 1,277 903 1,300 1,100 1,200 HSA CONTRIBUTION 375 1,250 3,000 750 3,000 EMPLOYEE RELATIONS 848 293 1,500 1,500 1,700 ACCRUED VACATION 1,377 12,798 - - - PENSION EXPENSE 32,166 (25,374) - - - OPEB EXPENSE 3,800 (27,190) - - - OFFICE SUPPLIES 1,794 - 200 - - OPERATING SUPPLIES 6,660 8,795 12,000 12,000 12,000 FUEL 25,506 16,904 34,000 30,000 34,000 EQUIPMENT MAINTENANCE 239 605 1,500 1,500 1,500 VEHICLE MAINTENANCE 38,203 90,024 40,000 45,000 50,000 ELECTRIC SERVICE 3,733 382 700 500 700 SURFACE WATER (3,475) 908 2,500 2,000 2,000 PROFESSIONAL DUES 693 717 900 900 900 PROFESSIONAL DEVELOPMENT - - 4,500 3,000 1,500 DISPOSAL FEE 176,147 195,459 202,000 202,000 202,000 LANDFILL MAINTENANCE 9,450 9,450 12,000 12,000 12,000 OTHER CONTRACTED SERVICES 122,517 123,406 136,000 136,000 133,000 COMMUNITY RELATIONS 249 600 7,000 6,000 6,000 OTHER EQUIPMENT 27,711 - 20,000 - - CONSTRUCTION COSTS 2,555 - 3,000 3,000 3,000 TRANSFER TO GENERAL FUND 310,000 310,000 310,000 310,000 310,000 TRANSFER TO VEHICLE REPLACEMENT FUND 135,000 135,000 135,000 135,000 145,000 TRANSFER TO TECHNOLOGY MANAGEMENT FUND 26,800 27,000 28,000 28,000 32,200 CURBSIDE SOLID WASTE 1,278,857$ 1,208,445$ 1,326,000$ 1,262,750$ 1,325,500$ REGULAR WAGES $ 49,807 $ 52,210 $ 52,200 $ 52,300 $ 53,700 OVERTIME 2,388 3,500 3,000 3,000 3,000 LONGEVITY 950 1,010 1,100 1,100 1,100 HEALTH & DENTAL 5,455 5,950 6,500 5,900 6,600 TMRS 6,960 7,431 7,400 7,100 7,600 FICA 3,897 4,194 4,100 4,000 4,200 WORKERS COMPENSATION 1,915 2,900 1,500 1,500 1,400 OTHER BENEFITS 269 200 300 300 300 ACCRUED VACATION 597 1,097 - - - PENSION EXPENSE 6,921 (330) - - - OPEB EXPENSE 817 (1,992) - - - OPERATING SUPPLIES 1,149 1,374 1,200 1,200 1,200 SOLID WASTE FUND STATEMENT OF REVENUES AND EXPENDITURES 52 Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 SOLID WASTE FUND STATEMENT OF REVENUES AND EXPENDITURES FUEL 12,328 7,225 15,000 10,000 13,000 EQUIPMENT MAINTENANCE 796 7 1,000 1,000 1,000 VEHICLE MAINTENANCE 31,528 47,212 30,000 40,000 35,000 DISPOSAL FEE 126,592 133,373 120,000 120,000 120,000 OTHER CONTRACTED SERVICES 66,067 71,405 80,000 80,000 88,000 COMMUNITY RELATIONS 2,347 1,214 21,000 20,000 11,500 OTHER EQUIPMENT 7,254 7,254 8,000 5,600 8,000 TRANSFER TO VEHICLE REPLACEMENT FUND 40,000 40,000 40,000 40,000 40,000 TRANSFER TO TECHNOLOGY MANAGEMENT FUND 17,000 17,100 17,800 17,800 16,500 CURBSIDE RECYCLING 385,038$ 402,331$ 410,100$ 410,800$ 412,100$ REGULAR WAGES $ 39,311 $ 41,518 $ 41,400 $ 40,000 $ 42,100 OVERTIME 2,099 2,707 2,000 2,000 2,000 LONGEVITY 150 210 300 300 300 HEALTH & DENTAL 7,198 6,787 7,500 6,700 7,600 TMRS 5,427 5,829 5,700 5,500 5,800 FICA 3,136 3,333 3,300 3,200 3,350 WORKERS COMPENSATION 1,496 2,245 1,200 1,100 1,100 OTHER BENEFITS 233 166 200 200 200 ACCRUED VACATION 199 308 - - - PENSION EXPENSE - 26,478 - - - OPEB EXPENSE - 19,916 - - - FUEL 3,296 2,123 8,000 4,000 7,000 VEHICLE MAINTENANCE 7,812 5,842 10,000 10,000 12,000 DISPOSAL FEE 10,152 10,820 15,000 15,000 15,000 OTHER CONTRACTED SERVICES 53,444 54,767 65,000 65,000 72,000 TRANSFER TO VEHICLE REPLACEMENT FUND 40,000 40,000 40,000 40,000 40,000 CURBSIDE GREEN WASTE RECYCLING 173,952$ 223,050$ 199,600$ 193,000$ 208,450$ TOTAL EXPENDITURES 1,837,847$ 1,836,729$ 1,935,700$ 1,901,550$ 1,946,550$ 53 CURBSIDE SOLID WASTE 52.18% CURBSIDE RECYCLING 21.18% CURBSIDE GREEN WASTE RECYCLING 10.71%TRANSFER TO GENERAL FUND 15.93% Solid Waste Fund - 2022 Expenditures by Function PERSONNEL 25.45% SOLID WASTE DISPOSAL FEE 16.49% LANDFILL MAINTENANCE 0.59% OTHER CONTRACTED SERVICES 14.34% TRANSFER TO GENERAL FUND 15.17% VEHICLE MAINTENANCE 4.75% VEHICLE REPLACEMENT 11.01%TECHNOLOGY MANAGEMENT 2.38% COMMUNITY RELATIONS 0.86% OTHER OPERATING 8.95% Solid Waste Fund - 2022 Expenditures by Type 54 Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 Curbside Solid Waste Personnel 395,074$ 289,195$ 376,700$ 335,850$ 379,700$ Operating 853,516 919,250 926,300 923,900 942,800 Capital 30,266 - 23,000 3,000 3,000 Total 1,278,857$ 1,208,445$ 1,326,000$ 1,262,750$ 1,325,500$ Curbside Recycling Personnel 79,976$ 76,169$ 76,100$ 75,200$ 77,900$ Operating 297,808 318,908 326,000 330,000 326,200 Capital 7,254 7,254 8,000 5,600 8,000 Total 385,038$ 402,331$ 410,100$ 410,800$ 412,100$ Curbside Green Waste Recycling Personnel 59,248$ 109,498$ 61,600$ 59,000$ 62,450$ Operating 114,703 113,553 138,000 134,000 146,000 Total 173,952$ 223,050$ 199,600$ 193,000$ 208,450$ Total Department 1,837,847$ 1,833,826$ 1,935,700$ 1,866,550$ 1,946,050$ Public Works Department Staffing Schedule (Solid Waste Fund) 2021 2022 POSITION GRADE BUDGET BUDGET MINIMUM MAXIMUM Public Works Curbside Solid Waste Crew Chief 5 1 1 53,900$ 78,155$ Crew Leader-Solid Waste 4 1 1 42,592$ 61,758$ Driver/Equipment Operator 2 3 3 35,200$ 51,000$ Curbside Recycling Driver/Equipment Operator 2 1 1 35,200$ 51,000$ Curbside Green Waste Recycling Driver/Equipment Operator 2 1 1 35,200$ 51,000$ TOTAL SOLID WASTE FUND 77 PUBLIC WORKS SOLID WASTE SALARY RANGE 55 Curbside Solid Waste Line Item Budget Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REGULAR WAGES $ 234,065 $ 215,288 $ 250,100 $ 225,800 $ 249,800 OVERTIME 11,319 9,304 14,000 14,000 14,000 LONGEVITY 2,331 2,303 2,700 1,900 2,000 HEALTH & DENTAL 48,315 42,150 42,300 35,900 47,300 TMRS 32,342 29,478 34,800 31,100 34,900 FICA 17,880 16,340 19,400 17,300 19,100 WORKERS COMPENSATION 8,978 11,651 7,600 6,500 6,700 OTHER BENEFITS 1,277 903 1,300 1,100 1,200 HSA CONTRIBUTION 375 1,250 3,000 750 3,000 EMPLOYEE RELATIONS 848 293 1,500 1,500 1,700 ACCRUED VACATION 1,377 12,798 - - - PENSION EXPENSE 32,166 (25,374)- - - OPEB EXPENSE 3,800 (27,190)- - - PERSONNEL 395,074$ 289,195$ 376,700$ 335,850$ 379,700$ OFFICE SUPPLIES $ 1,794 $ - $ 200 $ - $ - OPERATING SUPPLIES 6,660 8,795 12,000 12,000 12,000 FUEL 25,506 16,904 34,000 30,000 34,000 EQUIPMENT MAINTENANCE 239 605 1,500 1,500 1,500 VEHICLE MAINTENANCE 38,203 90,024 40,000 45,000 50,000 ELECTRIC SERVICE 3,733 382 700 500 700 SURFACE WATER (3,475) 908 2,500 2,000 2,000 PROFESSIONAL DUES 693 717 900 900 900 PROFESSIONAL DEVELOPMENT - - 4,500 3,000 1,500 DISPOSAL FEE 176,147 195,459 202,000 202,000 202,000 LANDFILL MAINTENANCE 9,450 9,450 12,000 12,000 12,000 OTHER CONTRACTED SERVICES 122,517 123,406 136,000 136,000 133,000 COMMUNITY RELATIONS 249 600 7,000 6,000 6,000 TRANSFER TO GENERAL FUND 310,000 310,000 310,000 310,000 310,000 TRANSFER TO VEHICLE REPLACEMENT FUND 135,000 135,000 135,000 135,000 145,000 TRANSFER TO TECHNOLOGY MANAGEMENT FUND 26,800 27,000 28,000 28,000 32,200 OPERATING 853,516$ 919,250$ 926,300$ 923,900$ 942,800$ OTHER EQUIPMENT $ 27,711 $ - $ 20,000 $ - $ - CONSTRUCTION COSTS 2,555 - 3,000 3,000 3,000 CAPITAL $ 30,266 $ - 23,000$ 3,000$ 3,000$ CURBSIDE SOLID WASTE DIVISION TOTAL 1,278,857$ 1,208,445$ 1,326,000$ 1,262,750$ 1,325,500$ PUBLIC WORKS DEPARTMENT 56 Curbside Recycling Division Line Item Budget Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REGULAR WAGES $ 49,807 $ 52,210 $ 52,200 $ 52,300 $ 53,700 OVERTIME 2,388 3,500 3,000 3,000 3,000 LONGEVITY 950 1,010 1,100 1,100 1,100 HEALTH & DENTAL 5,455 5,950 6,500 5,900 6,600 TMRS 6,960 7,431 7,400 7,100 7,600 FICA 3,897 4,194 4,100 4,000 4,200 WORKERS COMPENSATION 1,915 2,900 1,500 1,500 1,400 OTHER BENEFITS 269 200 300 300 300 ACCRUED VACATION 597 1,097 - - - PENSION EXPENSE 6,921 (330)- - - OPEB EXPENSE 817 (1,992)- - - PERSONNEL 79,976$ 76,169$ 76,100$ 75,200$ 77,900$ OPERATING SUPPLIES $ 1,149 $ 1,374 $ 1,200 $ 1,200 $ 1,200 FUEL 12,328 7,225 15,000 10,000 13,000 EQUIPMENT MAINTENANCE 796 7 1,000 1,000 1,000 VEHICLE MAINTENANCE 31,528 47,212 30,000 40,000 35,000 DISPOSAL FEE 126,592 133,373 120,000 120,000 120,000 OTHER CONTRACTED SERVICES 66,067 71,405 80,000 80,000 88,000 COMMUNITY RELATIONS 2,347 1,214 21,000 20,000 11,500 TRANSFER TO VEHICLE REPLACEMENT FUND 40,000 40,000 40,000 40,000 40,000 TRANSFER TO TECHNOLOGY MANAGEMENT FUND 17,000 17,100 17,800 17,800 16,500 OPERATING 297,808$ 318,908$ 326,000$ 330,000$ 326,200$ OTHER EQUIPMENT $ 7,254 $ 7,254 $ 8,000 $ 5,600 $ 8,000 CAPITAL 7,254$ 7,254$ 8,000$ 5,600$ 8,000$ CURBSIDE RECYCLING DIVISION TOTAL 385,038$ 402,331$ 410,100$ 410,800$ 412,100$ PUBLIC WORKS DEPARTMENT 57 Curbside Green Waste Recycling Division Line Item Budget Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REGULAR WAGES $ 39,311 $ 41,518 $ 41,400 $ 40,000 $ 42,100 OVERTIME 2,099 2,707 2,000 2,000 2,000 LONGEVITY 150 210 300 300 300 HEALTH & DENTAL 7,198 6,787 7,500 6,700 7,600 TMRS 5,427 5,829 5,700 5,500 5,800 FICA 3,136 3,333 3,300 3,200 3,350 WORKERS COMPENSATION 1,496 2,245 1,200 1,100 1,100 OTHER BENEFITS 233 166 200 200 200 ACCRUED VACATION 199 308 - - - PENSION EXPENSE - 26,478 - - - OPEB EXPENSE - 19,916 - - - PERSONNEL 59,248$ 109,498$ 61,600$ 59,000$ 62,450$ FUEL $ 3,296 $ 2,123 $ 8,000 $ 4,000 $ 7,000 VEHICLE MAINTENANCE 7,812 5,842 10,000 10,000 12,000 DISPOSAL FEE 10,152 10,820 15,000 15,000 15,000 OTHER CONTRACTED SERVICES 53,444 54,767 65,000 65,000 72,000 TRANSFER TO VEHICLE REPLACEMENT FUND 40,000 40,000 40,000 40,000 40,000 OPERATING 114,703$ 113,553$ 138,000$ 134,000$ 146,000$ CURBSIDE GREEN WASTE RECYCLING DIVISION TOTAL 173,952$ 223,050$ 199,600$ 193,000$ 208,450$ PUBLIC WORKS DEPARTMENT 58 INTERNAL SERVICE FUNDS •Vehicle Replacement Fund •Technology Management Fund •Asset Replacement Fund •Employee Benefits Fund •Human Resources Service Fund 59 VEHICLE REPLACEMENT FUND STATEMENT OF REVENUES AND EXPENDITURES Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REVENUES SALE OF CITY PROPERTY 15,850$ 22,703$ -$ -$ -$ EARNINGS ON INVESTMENTS 66,044 23,597 17,200 3,000 5,000 INSURANCE REFUNDS 36,693 - - - - TRANSFER FROM GENERAL FUND 343,300 365,355 343,000 343,000 350,000 TRANSFER FROM WATER & SEWER 90,000 92,000 93,000 93,000 102,000 TRANSFER FROM SOLID WASTE FUND 215,000 215,000 215,000 215,000 225,000 TOTAL REVENUES 766,886$ 718,655$ 668,200$ 654,000$ 682,000$ EXPENDITURES AUTOMOBILES 121,944$ 160,025$ 106,000$ 106,000$ 30,000$ LIGHT TRUCKS 27,645 57,891 47,000 47,000 144,000 TRUCKS 360,840 762,747 - - 484,000 TOTAL EXPENDITURES 510,429$ 980,663$ 153,000$ 153,000$ 658,000$ NET REVENUES (EXPENDITURES)256,457$ (262,008)$ 515,200$ 501,000$ 24,000$ BEGINNING FUND BALANCE*709,618$ 966,075$ 690,676$ 704,067$ 1,205,067$ ENDING FUND BALANCE 966,075$ 704,067$ 1,205,876$ 1,205,067$ 1,229,067$ * The beginning fund balances reflect an adjustment to include capitalized purchases, which were not included in prior years. 60 VEHICLE DEPARTMENT ASSIGNED SCHEDULED REPLACEMENT YEAR ESTIMATED REPLACEMENT COST 2007 E-350 Starcraft Bus Parks 2022 80,000 2010 Ford Escape Public Works 2022 30,000 2010 Mercedes Sprinter Van Public Works 2022 45,000 2007 Ford F-450 w/ Service Body Public Works 2022 56,000 2008 Ford F-250 Extended Cab Public Works 2022 43,000 2000 GMC 5500 Jet Truck Public Works 2022 135,000 2014 International Schwarze A7 Tornado Public Works 2022 260,000 2006 Stanley Hydro Pack Public Works 2022 9,000 2022 Vehicle & Equipment Replacement Cost 658,000$ VEHICLE REPLACEMENT FUND 2022 Replacement Schedule 61 UNIT #VEHICLE DESCRIPTION DEPARTMENT ASSIGNED SCHEDULED REPLACEMENT YEAR ESTIMATED REPLACEMENT COST 1 2013 Ford Escape Public Works 2023 35,000 134 2018 Ford Interceptor Patrol - SUV Police 2023 55,000 135 2018 Ford Interceptor Patrol - SUV Police 2023 55,000 213 2003 Trailer Fire 2023 15,000 104 2013 Chevy Caprice Police 2023 47,000 702 2002 Ford F450 w/ Teletop Service Body Public Works 2023 75,000 703 2002 Ford F450 w/ Teletop Service Body Public Works 2023 75,000 704 2002 Ford F450 w/ Teletop Service Body Public Works 2023 75,000 601 2008 F-250 Extended Cab w/ Dump Body Public Works 2023 64,000 658 2016 Trailer Mounted Pressure Washer Public Works 2023 10,000 670 2013 Volvo VHD w/Heil 2500 Durapack 25 yd body Public Works 2023 327,000 707 2006 F-250 Reg. Cab (Diesel)Public Works 2023 43,000 819 2008 Kubota Excavator - Model U45 (large kubota)Public Works 2023 70,000 821 2008 Air Compressor - Ingersol Rand XP185WIR Public Works 2023 22,000 822 2008 20' Utility/Equip. Trailer Public Works 2023 14,000 827 2008 Enclosed Cargo Trailer - 20' Traffic Response Public Works 2023 12,000 994,000 101 2009 F-150 Unmarked Truck Police 2024 50,000 102 2012 Toyota Sienna Mini-Van Police 2024 41,000 136 2019 Ford Interceptor Patrol - SUV Police 2024 55,000 137 2019 Ford Interceptor Patrol - SUV Police 2024 55,000 218 2012 Surburban 4x2 - Command Vehicle Fire 2024 74,000 550 2012 F-450 Dump Truck Public Works 2024 91,000 645 2009 F-750 XLT w/Davis 5/6 Yd Dump Body Public Works 2024 117,000 671 2014 Volvo VHD w/Heil 2500 Durapack 25 yd body Public Works 2024 328,000 705 2009 F-350 XL Crewcab with Service Body Public Works 2024 68,000 735 2009 F-750 XLT Dump Truck Public Works 2024 115,000 745 2009 Case Backhoe Public Works 2024 111,000 900 2006 Ford F-250 Diesel Ext. Cab PU 4x2 / Mateco Utility Bed Public Works 2024 51,000 913 2002 Freightliner FL70 w/ Altec 42' Bucket Public Works 2024 115,000 1,271,000 City of West University Place, Texas VEHICLE REPLACEMENT SCHEDULE 2023 - 2027 2023 Vehicle & Equipment Replacement Cost 2024 Vehicle & Equipment Replacement Cost 62 UNIT #VEHICLE DESCRIPTION DEPARTMENT ASSIGNED SCHEDULED REPLACEMENT YEAR ESTIMATED REPLACEMENT COST City of West University Place, Texas VEHICLE REPLACEMENT SCHEDULE 2023 - 2027 140 2020 Ford Interceptor Patrol - SUV Police 2025 62,000 141 2020 Ford Interceptor Patrol - SUV Police 2025 62,000 411 2010 F-250 XL Ext. Cab with Tommy Lift Parks 2025 51,000 412 2010 Ford F-250 Ext. Cab w/ Service Body Parks 2025 56,000 548 2000 Ameritrail w/ Miller WEL w/ Doors Public Works 2025 12,000 642 2010 JD 410J Backhoe Public Works 2025 161,000 672 2015 Volvo HDR w/ Heil 2500 Durapack 25 yd body Public Works 2025 334,000 903 2013 Ford Explorer - 4x2 Public Works 2025 45,000 783,000 142 2021 Ford Interceptor Patrol - SUV Police 2026 67,000 143 2021 Ford Interceptor Patrol - SUV Police 2026 67,000 401 2016 Ford Escape Parks 2026 31,000 653 2006 Ameritrail 8x16 Trailer (long trailer)Public Works 2026 5,000 779 2011 Godwin Dri Prime Pump Public Works 2026 60,000 823 2011 Kubota Trackhow Kv41-VR1T4 (small kubota)Public Works 2026 42,000 272,000 818 2007 TCM Forklift - Model FD25 T7 Public Works 2027 35,000 826 2007 6' x 10' Utility Trailer Public Works 2027 5,000 40,000 * The replacement schedule is shown for informational purposes only. Depending on various factors, vehicles may get replaced before or after stated years shown. 2027 Vehicle & Equipment Replacement Cost 2025 Vehicle & Equipment Replacement Cost 2026 Vehicle & Equipment Replacement Cost 63 TECHNOLOGY MANAGEMENT FUND STATEMENT OF REVENUES AND EXPENDITURES Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REVENUES TRANSFER FROM GENERAL FUND 1,435,500$ 1,496,400$ 1,541,200$ 1,761,200$ 1,734,100$ TRANSFER FROM WATER & SEWER FUND 137,800 140,000 139,000 139,000 145,000 TRANSFER FROM SOLID WASTE FUND 43,800 44,100 45,800 45,800 48,700 FEMA REIMBURSEMENT (1,606) - - - - MISCELLANEOUS 650 - - - - EARNINGS ON INVESTMENTS 10,494 3,403 2,500 500 1,000 TOTAL REVENUES 1,626,638$ 1,683,903$ 1,728,500$ 1,946,500$ 1,928,800$ EXPENDITURES REGULAR WAGES 432,974$ 275,759$ 421,700$ 380,000$ 401,800$ PART-TIME WAGES - 47,888 - - - ON CALL 2,730 3,327 2,800 2,500 2,800 OVERTIME 8,281 16,793 8,500 6,800 8,500 LONGEVITY 1,769 1,203 1,300 1,200 1,500 HEALTH & DENTAL 55,818 40,476 61,800 33,200 37,600 TMRS 59,335 39,739 57,900 52,500 55,700 FICA 30,558 25,628 31,800 29,500 31,700 WORKERS COMPENSATION 1,284 1,718 1,000 1,000 700 ALLOWANCES 9,080 6,596 8,500 9,200 9,400 OTHER BENEFITS 1,559 1,153 1,900 1,800 1,800 HSA CONTRIBUTION 625 4,050 5,500 2,700 5,500 ACCRUED VACATION (61,116) (3,481) - - - PENSION EXPENSE 59,739 (77,343) - - - OPEB EXPENSE 13,835 (71,242) - - - PERSONNEL 616,471$ 312,263$ 602,700$ 520,400$ 557,000$ OFFICE SUPPLIES -$ 729$ 1,000$ 800$ 1,000$ OPERATING SUPPLIES - 20,551 10,500 10,500 10,500 EQUIPMENT MAINTENANCE 34,936 15,826 10,000 10,000 10,000 HARDWARE & SOFTWARE MAINTENANCE CONTRACTS 594,072 532,422 640,000 615,000 704,200 TELE-COMMUNICATIONS & DATA & RADIO 204,202 212,180 220,000 255,000 280,500 SOFTWARE LICENSES 708 - - - - CONSULTANTS 2,683 28,990 15,000 15,000 15,000 PROFESSIONAL DUES - - 1,200 300 2,800 PROFESSIONAL DEVELOPMENT 11,352 892 11,800 4,500 9,400 OTHER CONTRACTED SERVICES - 146,064 95,000 90,000 90,000 TECHNOLOGY PROJECTS 1,265 - - - - HIGH TECHNOLOGY REPLACEMENTS 57,693 74,340 100,000 320,000 150,000 TRANSFER TO ASSET REPLACEMENT FUND - 20,000 20,700 20,700 108,100 OPERATIONS 906,911$ 1,051,995$ 1,125,200$ 1,341,800$ 1,381,500$ TOTAL EXPENDITURES 1,523,382$ 1,364,258$ 1,727,900$ 1,862,200$ 1,938,500$ NET REVENUES (EXPENDITURES)103,256$ 319,645$ 600$ 84,300$ (9,700)$ BEGINNING FUND BALANCE 118,675$ 221,931$ 283,055$ 541,576$ 625,876$ ENDING FUND BALANCE 221,931$ 541,576$ 283,655$ 625,876$ 616,176$ 64 Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 Technology Management Personnel 616,471$ 312,263$ 602,700$ 520,400$ 557,000$ Operating 906,911 1,051,995 1,125,200 1,341,800 1,381,500 Total Department 1,523,382$ 1,364,258$ 1,727,900$ 1,862,200$ 1,938,500$ Technology Management Fund 2021 2022 POSITION GRADE BUDGET BUDGET MINIMUM MAXIMUM Technology Management IT Director 12 1 1 115,000$ 178,250$ IT Operations Manager 10 1 1 91,000$ 131,950$ IT Analyst 8 1 0 65,219$ 94,568$ Network Administrator 8 0 1 65,219$ 94,568$ IT Technician 6 1 1 53,900$ 78,155$ Total Technology Management Fund 4 4 TECHNOLOGY MANAGEMENT FUND SALARY RANGE ADMINISTRATION DEPARTMENT 65 Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REVENUES SALE OF CITY PROPERTY 1,875$ -$ -$ -$ -$ MISCELLANEOUS 4,907 2,270 10,000 - 10,000 TRANSFER FROM GENERAL FUND 575,400 576,100 539,300 539,300 443,300 TRANSFER FROM WATER & SEWER FUND - 86,900 92,900 92,900 170,000 EARNINGS ON INVESTMENTS 55,530 19,258 14,100 3,000 5,000 TRANSFER FROM TECHNOLOGY MANAGEMENT FUND - 20,000 20,700 20,700 108,100 TOTAL REVENUES 637,712$ 704,528$ 677,000$ 655,900$ 736,400$ EXPENDITURES OTHER EQUIPMENT 7,840$ 18,345$ 186,600$ 186,600$ 113,800$ CAPITAL PURCHASES RECLASSIFIED AS ASSET 196,382 148,378 - - - TRANSFER TO TRANSPORTATION IMPROVEMENT FUND - - - - 345,000 TOTAL EXPENDITURES 204,223$ 166,723$ 186,600$ 186,600$ 458,800$ NET REVENUES (EXPENDITURES)433,490$ 537,805$ 490,400$ 469,300$ 277,600$ BEGINNING FUND BALANCE 2,130,130$ 2,563,620$ 3,277,102$ 3,101,425$ 3,570,725$ ENDING FUND BALANCE 2,563,620$ 3,101,425$ 3,767,502$ 3,570,725$ 3,848,325$ Note: Prior to 2020, the Asset Replacement Fund was called the Equipment Replacement Fund. ASSET REPLACEMENT FUND STATEMENT OF REVENUES AND EXPENDITURES 66 SCHEDULED ESTIMATED DESCRIPTION DEPARTMENT ASSIGNED REPLACEMENT YEAR REPLACEMENT COST LifePack 15 cardiac monitor - Medic 1 Fire 2022 45,700 Non-Potable Water Booster Pump 1 (Wastewater Treatment Plant)PW Operations 2022 11,400 Lift Station #6 Fixed Equipment (Pump 1)PW Operations 2022 11,700 Lift Station #6 Fixed Equipment (Pump 2)PW Operations 2022 11,700 Judson Park Lighting PARD- Park Maintenance 2022 33,300 2022 Replacement Cost 113,800$ ASSET REPLACEMENT FUND 2022 Replacement Schedule 67 DESCRIPTION DEPARTMENT ASSIGNED SCHEDULED REPLACEMENT YEAR ESTIMATED REPLACEMENT COST PWPACK Facilities 2023 7,800 IceFD Facilities 2023 8,200 Air Handler #1 - CH Facilities 2023 25,300 Air Handler #2 - CH Facilities 2023 29,700 Air Handler #3 - CH Facilities 2023 28,700 Air Handler #4 - CH Facilities 2023 28,900 Lift Station #9 Fixed Equipment PW Operations 2023 15,300 Refrigerated Automatic Water Sampler PW Operations 2023 9,100 Submersible Pumps General Services 2023 11,100 Precor 835 EFX - Elliptical (moving arms) (2)PARD- Recreation Center 2023 17,400 Precor 833 TRM Treadmill (2-1)PARD- Recreation Center 2023 18,800 RayPak Pool Heater PARD- Recreation Center 2023 24,800 UV System-6030 PARD- Recreation Center 2023 39,700 Precor 833 EFX - Elliptical (fixed arms)PARD- Recreation Center 2023 7,100 Precor 835 AMT (2)PARD- Recreation Center 2023 19,100 Precor 833 TRM Treadmill (2)PARD- Recreation Center 2023 19,500 Wier Tennis Court Resurfacing PARD- Park Maintenance 2023 8,600 Wier Irrigation PARD- Park Maintenance 2023 39,900 Lily Pad Entry Pads PARD- Colonial Park Pool 2023 24,800 UPS Technology 2023 130,000 2023 Replacement Cost 513,800$ Pool Deck Heaters Facilities 2024 42,100 Non-Potable Water Booster Pump 2 PW Operations 2024 11,400 Precor 835 Recumbent Bike (1)PARD- Recreation Center 2024 6,300 Feature Pads (2)-1 PARD- Colonial Park Pool 2024 4,900 Feature Pads (2)-2 PARD- Colonial Park Pool 2024 4,900 Fabric for all structures PARD- Colonial Park Pool 2024 22,500 2024 Replacement Cost 92,100$ ASSET REPLACEMENT SCHEDULE FIVE YEAR REPLACEMENT SCHEDULE 2023 - 2027 68 DESCRIPTION DEPARTMENT ASSIGNED SCHEDULED REPLACEMENT YEAR ESTIMATED REPLACEMENT COST ASSET REPLACEMENT SCHEDULE FIVE YEAR REPLACEMENT SCHEDULE 2023 - 2027 Bunker Gear Replacement Fire 2025 85,700 Water Pump #1 - CH Facilities 2025 8,100 Water Pump #2 - CH Facilities 2025 8,100 Progressive Cavity Pump PW Operations 2025 24,900 Lift Station #9 Fixed Equipment PW Operations 2025 15,300 Large Grinder General Services 2025 10,100 Striper/Driver System General Services 2025 21,700 Precor 835 Recumbent Bike (2) PARD- Recreation Center 2025 5,400 Tables - Recreation Center PARD- Recreation Center 2025 8,200 Precor 833 TRM Treadmill (2-2) PARD- Recreation Center 2025 18,600 Furniture Replacement PARD- Recreation Center 2025 58,100 Defender (SP-41-48-1038) PARD- Recreation Center 2025 132,400 Town Center Irrigation PARD- Park Maintenance 2025 23,000 CB Irrigation PARD- Park Maintenance 2025 35,000 1M Dirafirm Diving Stand PARD- Colonial Park Pool 2025 14,500 4020 Marina Chaise Lounge (70)PARD- Colonial Park Pool 2025 17,700 Defender (SP-55-48-2076)PARD- Colonial Park Pool 2025 191,600 2025 Replacement Cost 678,400$ LifePack 12 cardiac monitor - Engine 1 Fire 2026 51,100 Non-Potable Water Filter Feed Pump PW Operations 2026 16,800 Non-Potable Water Filter Feed Pump PW Operations 2026 16,800 Chairs-replacement (200)$6860 purchased in 2011 PARD- Senior Services 2026 10,700 Hallway Furniture Replacement $7321 purchased 2011 PARD- Senior Services 2026 11,400 2026 Replacement Cost 106,800$ Boiler - Fire Department Facilities 2027 11,200 Refrigerated Automatic Water Sampler PW Operations 2027 9,700 Belt Press Polymer Mixer PW Operations 2027 42,100 VeederRoot General Services 2027 15,200 Fuel Master AIM II General Services 2027 59,800 2027 Replacement Cost 138,000$ 69 EMPLOYEE BENEFITS FUND STATEMENT OF REVENUES AND EXPENDITURES Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REVENUES CHARGES TO OPERATING FUNDS: ER - HEALTH $ 1,211,569 1,175,995$ 1,456,100$ 1,186,000$ 1,393,100$ ER - DENTAL 60,202 56,874 70,200 61,300 65,800 ER - LIFE 28,474 25,875 34,000 27,000 31,050 ER - DISABILITY 30,230 25,848 36,400 36,500 37,500 ER - WORKER'S COMPENSATION 118,153 182,686 106,500 102,000 110,800 ER - RETIREES 189,975 101,025 103,800 101,000 104,800 ER - OTHER BENEFITS 352,217 - - - - EMPLOYEE CONTRIBUTIONS: EE - HEALTH 292,350 289,322 380,700 310,000 344,600 EE - DENTAL 14,631 13,871 17,500 15,000 15,000 EE - VISION 13,159 11,284 11,600 11,500 11,300 COBRA CONTRIBUTIONS 43,722 46,182 54,200 58,600 69,200 EARNINGS ON INVESTMENTS 30,895 7,693 5,600 1,000 2,000 TRANSFER FROM GENERAL FUND - 33,700 35,000 35,000 35,000 TOTAL REVENUES 2,385,578$ 1,970,354$ 2,311,600$ 1,944,900$ 2,220,150$ EXPENDITURES MEDICAL PREMIUMS - ACTIVE $ 1,535,280 $ 1,439,588 $ 1,836,800 $ 1,496,000 $ 1,738,100 MEDICAL PREMIUMS - RETIRED 139,163 112,432 121,500 102,000 116,500 MEDICAL PREMIUMS - COBRA 46,034 31,474 31,600 41,000 53,300 DENTAL PREMIUMS - ACTIVE 79,550 77,763 91,900 92,500 84,600 VISION PREMIUMS - ACTIVE 14,033 12,145 11,600 12,200 11,800 WORKER'S COMPENSATION 90,112 95,112 106,600 102,000 107,000 LIFE & AD&D, DISABILITY 60,347 64,297 52,500 60,000 68,550 UNEMPLOYMENT CLAIMS 7,639 - - - - OTHER ADMINSTRATIVE COST 16,616 11,370 12,000 11,000 12,500 WELLNESS PROGRAM 7,401 4,041 15,000 8,000 10,000 RECRUITING & HIRING 14,964 - - - - EVENTS 13,296 1,691 - - - AWARDS 12,372 - - - - TUITION 18,247 - - - - SOFTWARE LICENSES 11,375 - - - - CONSULTANTS 81,108 33,810 37,500 38,500 40,000 TRANSFER TO GENERAL FUND 142,500 - - - - TRANSFER TO HUMAN RESOURCE SVCS - - - 427,366 - TOTAL EXPENDITURES 2,290,039$ 1,883,722$ 2,317,000$ 2,390,566$ 2,242,350$ NET REVENUES (EXPENDITURES)95,539$ 86,632$ (5,400)$ (445,666)$ (22,200)$ BEGINNING FUND BALANCE 1,535,930$ 1,631,469$ 1,262,603$ 1,718,102$ 1,272,436$ ENDING FUND BALANCE 1,631,469$ 1,718,102$ 1,257,203$ 1,272,436$ 1,250,236$ 70 HUMAN RESOURCES SERVICES FUND STATEMENT OF REVENUES AND EXPENDITURES Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 EARNINGS ON INVESTMENTS $ - $ 2,540 $ 1,900 $ 50 $ 100 TRANSFER FROM GENERAL FUND - 249,900 252,000 252,000 250,000 TRANSFER FROM EMPLOYEE BENEFIT - - - 427,366 - TOTAL REVENUES -$ 252,440$ 253,900$ 679,416$ 250,100$ EXPENDITURES EMPLOYEE RELATIONS $ - $ - $ - $ - $ 24,100 UNEMPLOYMENT CLAIMS - 13,049 15,000 5,000 10,000 OTHER ADMINSTRATIVE COST - 10,469 8,000 13,000 13,000 RECRUITING & HIRING - 20,663 23,000 21,000 23,000 EVENTS - 14,166 15,000 14,000 14,000 AWARDS - 6,978 7,700 7,000 7,500 TUITION - 25,090 50,000 25,000 37,500 TRANSFER TO GENERAL FUND - 80,691 135,200 168,000 177,400 TRANSFER TO WATER & SEWER FUND - - - 43,200 - TOTAL EXPENDITURES -$ 171,106$ 253,900$ 296,200$ 306,500$ NET REVENUES (EXPENDITURES)-$ 81,334$ -$ 383,216$ (56,400)$ BEGINNING FUND BALANCE -$ -$ 508,466$ 81,334$ 464,550$ ENDING FUND BALANCE -$ 81,334$ 508,466$ 464,550$ 408,150$ 71 SPECIAL REVENUE FUNDS •Parks Donation Fund •Friends of West University Parks Fund •Truancy Prevention Fund •Municipal Court Fund •Court Technology Fund •Tree Replacement Fund •Court Security Fund •METRO Fund •Police State Forfeited Property Fund •Police Training Fund •Fire Training Fund •Good Neighbor Fund 72 PARKS DONATION FUND Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REVENUES FRIENDS OF WEST U PARKS $ 11,758 $ 7,130 $ - $ 5,000 5,000$ EARNINGS ON INVESTMENTS 2,282 469 300 50 100 DONATIONS 48,130 - 40,500 30,000 30,000 TOTAL REVENUES 62,170$ 7,599$ 40,800$ 35,050$ 35,100$ EXPENDITURES OPERATING SUPPLIES $ 72,475 $ 25,112 $ 30,000 $ 24,000 17,000$ FURNITURE & EQUIP <$5000 - 9,775 - - - OTHER EQUIPMENT - - - - 23,000 TOTAL EXPENDITURES 72,475$ 34,887$ 30,000$ 24,000$ 40,000$ NET REVENUES (EXPENDITURES)(10,305)$ (27,288)$ 10,800$ 11,050$ (4,900)$ BEGINNING BALANCE 109,254$ 98,949$ 58,849$ 71,662$ 82,712$ ENDING BALANCE 98,949$ 71,662$ 69,649$ 82,712$ 77,812$ STATEMENT OF REVENUES AND EXPENDITURES  73 FRIENDS OF WEST UNIVERSITY PARKS FUND Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REVENUES FRIENDS OF WEST U PARKS $ 231,925 $ 200,762 $ 250,000 $ 594,000 187,500$ EARNINGS ON INVESTMENTS 5 - - 200 ‐                        TOTAL REVENUES 231,930$ 200,762$ 250,000$ 594,200$ 187,500$ EXPENDITURES CONSTRUCTION COSTS 240,211$ 579,730$ 250,000$ 200,000$ 187,500$ TOTAL EXPENDITURES 240,211$ 579,730$ 250,000$ 200,000$ 187,500$ NET REVENUES (EXPENDITURES)(8,281)$ (378,968)$ -$ 394,200$ -$ BEGINNING BALANCE 617$ (7,664)$ 617$ (386,632)$ 7,568$ ENDING BALANCE (7,664)$ (386,632)$ 617$ 7,568$ 7,568$ STATEMENT OF REVENUES AND EXPENDITURES  74 Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REVENUES LOCAL TRUANCY PREVENTION AND $ - $ 2,389 $ - $ 2,800 3,100$ EARNINGS ON INVESTMENTS - - - 5 - TOTAL REVENUES -$ 2,389$ -$ 2,805$ 3,100$ EXPENDITURES TOTAL EXPENDITURES -$ -$ -$ -$ -$ NET REVENUES (EXPENDITURES)-$ 2,389$ -$ 2,805$ 3,100$ BEGINNING BALANCE -$ -$ -$ 2,389$ 5,194$ ENDING BALANCE -$ 2,389$ -$ 5,194$ 8,294$ TRUANCY PREVENTION FUND STATEMENT OF REVENUES AND EXPENDITURES  75 Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REVENUES MUNICIPAL JURY FUND $ - $ 48 $ - $ 75 100$ TOTAL REVENUES -$ 48$ -$ 75$ 100$ EXPENDITURES TOTAL EXPENDITURES -$ -$ -$ -$ -$ NET REVENUES (EXPENDITURES)-$ 48$ -$ 75$ 100$ BEGINNING BALANCE -$ -$ -$ 48$ 123$ ENDING BALANCE -$ 48$ -$ 123$ 223$ MUNICIPAL COURT FUND STATEMENT OF REVENUES AND EXPENDITURES  76 Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REVENUES MUNICIPAL COURT FINES $ 9,995 $ 3,639 $ 5,000 $ 3,500 5,000$ EARNINGS ON INVESTMENTS 416 - - 10 - TOTAL REVENUES 10,411$ 3,639$ 5,000$ 3,510$ 5,000$ EXPENDITURES OTHER CONTRACTED SERVICES $ - $ 2,500 $ - $ - -$ FURNITURE & EQUIP <$5000 - 3,930 2,000 2,000 4,500 TOTAL EXPENDITURES -$ 6,430$ 2,000$ 2,000$ 4,500$ NET REVENUES (EXPENDITURES)10,411$ (2,791)$ 3,000$ 1,510$ 500$ BEGINNING BALANCE 12,175$ 22,586$ 21,087$ 19,795$ 21,305$ ENDING BALANCE 22,586$ 19,795$ 24,087$ 21,305$ 21,805$ STATEMENT OF REVENUES AND EXPENDITURES COURT TECHNOLOGY FUND  77 Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REVENUES OTHER FEES AND PERMITS $ 23,713 $ 44,750 $ 30,000 $ 50,000 50,000$ EARNINGS ON INVESTMENTS 6,262 2,342 1,700 300 500 TOTAL REVENUES 29,974$ 47,092$ 31,700$ 50,300$ 50,500$ EXPENDITURES TREE REPLACEMENT OPERATING EXPENDITURES 50,360$ 7,830$ 50,000$ 10,000$ 50,000$ TOTAL EXPENDITURES 50,360$ 7,830$ 50,000$ 10,000$ 50,000$ NET REVENUES (EXPENDITURES)(20,386)$ 39,263$ (18,300)$ 40,300$ 500$ BEGINNING BALANCE 280,344$ 259,958$ 303,458$ 299,221$ 339,521$ ENDING BALANCE 259,958$ 299,221$ 285,158$ 339,521$ 340,021$ STATEMENT OF REVENUES AND EXPENDITURES TREE REPLACEMENT FUND  78 COURT SECURITY FUND Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REVENUES MUNICIPAL COURT FINES $ 7,497 $ 3,646 $ 4,000 $ 3,350 4,000$ EARNINGS ON INVESTMENTS 1,094 345 300 50 100 TOTAL REVENUES 8,591$ 3,991$ 4,300$ 3,400$ 4,100 EXPENDITURES REGULAR WAGES $ 6,750 $ 5,620 $ 10,500 2,500$ 5,000$ PROFESSIONAL DEVELOPMENT - - 3,000 1,000 3,000 FURNITURE & EQUIP <$5000 - 168 1,500 500 1,500 TOTAL EXPENDITURES 6,750$ 5,788$ 15,000$ 4,000$ 9,500$ NET REVENUES (EXPENDITURES)1,841$ (1,796)$ (10,700)$ (600)$ (5,400)$ BEGINNING BALANCE 44,779$ 46,620$ 44,520$ 44,823$ 44,223$ ENDING BALANCE 46,620$ 44,823$ 33,820$ 44,223$ 38,823$ STATEMENT OF REVENUES AND EXPENDITURES  79 METRO FUND Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REVENUES METRO $ 650,382 $ 679,118 $ 610,000 675,000$ 675,000$ EARNINGS ON INVESTMENTS 213 99 100 100 100 TOTAL REVENUES 650,595$ 679,217$ 610,100$ 675,100$ 675,100$ EXPENDITURES TRANSFER TO TRANSPORTATION IMPROVEMENT FUND 600,000$ 550,000$ 575,000$ 575,000$ 925,000$ TOTAL EXPENDITURES 600,000$ 550,000$ 575,000$ 575,000$ 925,000$ NET REVENUES (EXPENDITURES)50,595$ 129,217$ 35,100$ 100,100$ (249,900)$ BEGINNING BALANCE 121,151$ 171,746$ 213,846$ 300,963$ 401,063$ ENDING BALANCE 171,746$ 300,963$ 248,946$ 401,063$ 151,163$ STATEMENT OF REVENUES AND EXPENDITURES  80 POLICE STATE FORFEITED PROPERTY FUND Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REVENUES EARNINGS ON INVESTMENTS 658$ 247$ 200$ 50$ 100$ TOTAL REVENUES 658$ 4,282$ 200$ 15,550$ 100$ EXPENDITURES TOTAL EXPENDITURES -$ -$ -$ -$ -$ NET REVENUES (EXPENDITURES)658$ 4,282$ 200$ 15,550$ 100$ BEGINNING BALANCE 27,382$ 28,040$ 28,340$ 32,322$ 47,872$ ENDING BALANCE 28,040$ 32,322$ 28,540$ 47,872$ 47,972$ STATEMENT OF REVENUES AND EXPENDITURES  81 POLICE TRAINING FUND Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REVENUES STATE GRANT $ 2,797 $ 2,573 $ 2,500 2,500$ 2,500$ EARNINGS ON INVESTMENTS 608 247 200 30 50 TOTAL REVENUES 3,405$ 2,820$ 2,700$ 2,530$ 2,550$ EXPENDITURES TOTAL EXPENDITURES -$ -$ -$ -$ -$ NET REVENUES (EXPENDITURES)3,405$ 2,820$ 2,700$ 2,530$ 2,550$ BEGINNING BALANCE 22,979$ 26,384$ 29,684$ 29,204$ 31,734$ ENDING BALANCE 26,384$ 29,204$ 32,384$ 31,734$ 34,284$ STATEMENT OF REVENUES AND EXPENDITURES  82 FIRE TRAINING FUND Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REVENUES FEDERAL GRANT $ 21,100 $ - $ - -$ -$ SETRAC 4,172 - - - - EARNINGS ON INVESTMENTS 236 - - 10 - DONATIONS (1,090) 158 - 30 - TRANSFER FROM GENERAL FUND 1,109 - - - - TOTAL REVENUES 25,527$ 158$ -$ 40$ -$ EXPENDITURES OPERATING SUPPLIES $ 11,468 $ - $ - -$ -$ PROFESSIONAL DEVELOPMENT 925 2,220 - - - OTHER EQUIPMENT 3,503 - - - - TOTAL EXPENDITURES 15,896$ 2,220$ -$ -$ -$ NET REVENUES (EXPENDITURES)9,631$ (2,062)$ -$ 40$ -$ BEGINNING BALANCE 8,718$ 18,349$ 17,399$ 16,287$ 16,327$ ENDING BALANCE 18,349$ 16,287$ 17,399$ 16,327$ 16,327$ STATEMENT OF REVENUES AND EXPENDITURES  83 GOOD NEIGHBOR FUND Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REVENUES EARNINGS ON INVESTMENTS 97$ -$ -$ 5$ -$ TOTAL REVENUES 97$ -$ -$ 5$ -$ EXPENDITURES COMMUNITY RELATIONS -$ -$ 2,500$ -$ 2,500$ TOTAL EXPENDITURES -$ -$ 2,500$ -$ 2,500$ NET REVENUES (EXPENDITURES)97$ -$ (2,500)$ 5$ (2,500)$ BEGINNING BALANCE 4,050$ 4,147$ 4,147$ 4,147$ 4,152$ ENDING BALANCE 4,147$ 4,147$ 1,647$ 4,152$ 1,652$ STATEMENT OF REVENUES AND EXPENDITURES  84 CAPITAL IMPROVEMENT FUNDS •Capital Project Fund •Capital Reserve Fund •Transportation Improvement Fund •2019 Certificates of Obligation Fund •Water & Sewer Capital Fund 85 CAPITAL PROJECT FUND Actual Actual Budget Estimated Carryover to Budget 2019 2020 2021 2021 2022 2022 REVENUES FEMA REIMBURSEMENT $ 15,712 $ - $ - $ - $ - $ - EARNINGS ON INVESTMENTS 16,583 3,822 2,800 300 - 300 TRANSFER FROM GENERAL FUND - - 300,000 300,000 - - TRANSFER FROM CAPITAL RESERVE FUND - 6,969 - - - 710,000 TRANSFER FROM 2019 CERT OF OBLIGATION FUND 45,542 - - - - - TOTAL REVENUES 77,837$ 10,791$ 302,800$ 300,300$ -$ 710,300$ EXPENDITURES PROJECT EXPENDITURES ANIMAL CONTROL SHELTER $ 33,310 $ - $ - $ - $ - $ - PW MAINTENANCE PARKING LOT/WASH BAY 268,191 - - - - - CITY WIDE ENGINEERING TRAFFIC STUDY/IMPLEMENTATION - 19,430 75,000 100,570 - - BRIDGE MANAGEMENT PROGRAM - 65,550 - - - - STORM WATER MANAGEMENT PROGRAM - 101,112 100,000 100,123 - - CITYWIDE FACILITIES CONDITION & SECURITY ASSESSMENT - IMPLEMENTATION - 33,600 25,000 14,400 - - CITY HALL AUDIO/VIDEO UPGRADES - 110,000 - - - - FACILITIES MASTER PLAN - - 75,000 25,000 50,000 - EMERGENCY STORAGE ROOM - - 75,000 - 75,000 - HVAC REPLACEMENT PROGRAM - - 250,000 250,000 - - FIRE APPARATUS BAY ROOF REPLACEMENT - - - - - 150,000 ENTERPRISE RESOURCE PLANNING SOFTWARE REPLACEMENT - - - - - 100,000 NETWORK FIREWALL SECURITY IMPROVEMENTS - - - - - 60,000 NETWORK SWITCH INFRASTRUCTURE REPLACEMENT - - - - - 190,000 EMERGENCY OPERATIONS CENTER IMPROVEMENTS - - - - - 120,000 RADIO REPLACEMENTS - - - - - 90,000 TOTAL EXPENDITURES 301,501$ 329,692$ 600,000$ 490,093$ 125,000$ 710,000$ BEGINNING BALANCE 1,033,063$ 809,399$ 413,999$ 490,497$ 300,704$ ENDING BALANCE 809,399$ 490,497$ 116,799$ 300,704$ 176,004$ *Virtual Gate Expenditures Moved to 2019 Cert of Obligation Fund STATEMENT OF REVENUES AND EXPENDITURES 86 CAPITAL RESERVE FUND Actual Actual Budget Estimated Budget 2019 2020 2021 2021 2022 REVENUES FEDERAL GRANT $ - $ - $ - $ 1,930,000 $ 1,930,000 EARNINGS ON INVESTMENTS - - - 2,000 3,000 TRANSFER FROM GENERAL FUND - - - 7,000,000 - TOTAL REVENUES -$ -$ -$ 8,932,000$ 1,933,000$ EXPENDITURES TRANSFER TO CAPITAL PROJECTS FUND $ - $ 6,968 $ - $ - $ 710,000 TOTAL EXPENDITURES -$ 6,968$ -$ -$ 710,000$ BEGINNING BALANCE 6,968$ 6,968$ -$ -$ 8,932,000$ ENDING BALANCE 6,968$ -$ -$ 8,932,000$ 10,155,000$ STATEMENT OF REVENUES AND EXPENDITURES 87 Actual Actual Budget Estimated Carryover to Budget 2019 2020 2021 2021 2022 2022 REVENUES EARNINGS ON INVESTMENTS $ 44,206 $ 16,471 $ 62,000 $ 8,000 $ - $ 10,000 FEDERAL GRANT * 470,323 634,237 13,398,119 5,380,000 - - TRANSFER FROM ASSET REPLACEMENT FUND - - - - - 345,000 TRANSFER FROM METRO GRANT FUND 600,000 550,000 575,000 575,000 - 925,000 CERTIFICATES OF OBLIGATION PROCEEDS - 24,070,000 - - - - PREMIUM ON BONDS - 3,871,053 - - - - TOTAL REVENUES 1,114,529$ 29,141,762$ 14,035,119$ 5,963,000$ -$ 1,280,000$ PROJECT EXPENDITURES CITY WIDE DRAINAGE STUDY $ - $ 180,000 $ - $ - $ - $ - KILMARNOCK RETAINING WALL 29,730 - - - - - ROADWAY REPAIRS/OVERLAY/ REPLACEMENT 154,814 - - - - - BUFFALO SPEEDWAY 1,447,894 1,059,209 30,039,106 18,723,348 3,061,799 - CITY WIDE STREET & DRAINAGE IMPROVEMENTS EAST - - - 500,000 1,500,000 - DRAINAGE IMPROVEMENTS WEST PHASE I - - - 400,000 4,200,000 - ALT STORMWATER DETENTION OPTIONS FEASIBILITY STUDY - 28,500 - - - - STREET MAINTENANCE (PONDING) - - 125,000 125,000 - - SIDEWALK REPLACEMENT - - 50,000 11,000 39,000 300,000 PAVEMENT CONDITION ASSESSMENT - - 75,000 55,000 20,000 - WESLAYAN TRAFFIC SIGNAL REPLACEMENTS - - - - - 475,000 EDLOE STREET PATHWAY - - - - - 468,000 TOTAL EXPENDITURES 1,632,438$ 1,267,709$ 30,289,106$ 19,814,348$ 8,820,799$ 1,243,000$ TRANSFERS TO OTHER FUNDS 1,038,591 BEGINNING BALANCE 1,875,661$ 1,357,752$ 18,809,204$ 28,193,214$ 14,341,866$ ENDING BALANCE 1,357,752$ 28,193,214$ 2,555,217$ 14,341,866$ 5,558,067$ * Estimated 2021 amount is Community Block Development Grant funding for Buffalo Speedway that is currently pending. TRANSPORTATION IMPROVEMENT FUND STATEMENT OF REVENUES AND EXPENDITURES 88 2019 CERTIFICATE OF OBLIGATION FUND Actual Actual Budget Estimated Carryover to Budget 2019 2020 2021 2021 2022 2022 REVENUES EARNINGS ON INVESTMENTS $ 58,289 $ 19,036 $ 13,900 $ 2,000 $ - $ - CERTIFICATES OF OBLIGATION PROCEEDS 4,040,000 - - - - - PREMIUM ON BONDS 559,845 - - - - - TOTAL REVENUES 4,658,134$ 19,036$ 13,900$ 2,000$ -$ -$ PROJECT EXPENDITURES VIRTUAL GATE PHASE I* $ 425,837 $ 1,606,761 $ - $ 317,359 $ - $ - VIRTUAL GATE PHASE II - - 2,160,000 1,900,000 - - TOTAL EXPENDITURES 425,837$ 1,606,761$ 2,160,000$ 2,217,359$ -$ -$ BEGINNING BALANCE -$ 4,232,297$ 2,386,276$ 2,644,572$ 429,213$ ENDING BALANCE 4,232,297$ 2,644,572$ 240,176$ 429,213$ 429,213$ * Includes Issuance Costs STATEMENT OF REVENUES AND EXPENDITURES 89 Actual Actual Budget Estimated Carryover to Budget 2019 2020 2021 2021 2022 2022 REVENUES EARNINGS ON INVESTMENTS 51,142$ 10,701$ 7,800$ 2,000$ -$ 3,000$ TRANSFER FROM WATER & SEWER FUND 900,000 900,000 2,700,000 2,700,000 - 900,000 CERTIFICATES OF OBLIGATION PROCEEDS - - - - - 20,750,000 TOTAL REVENUES 951,142$ 910,701$ 2,707,800$ 2,702,000$ -$ 21,653,000$ PROJECT EXPENDITURES BISSONNET WATER LINE REPLACEMENT -$ 639,400$ -$ -$ -$ -$ WWTP TREE REMOVAL 2,999 - - - - - WWTP FENCING 45,000 - - - - - SEWER INFLOW & INFILTRATION 42,721 - - - - - WWTP WEIR REPLACEMENT 1,781 - 500,000 499,320 - - DRINKING WATER DISINFECTION UPGRADES 50,995 241,722 - - - - WWTP EFFICIENCY STUDY 83,530 - - - - - WWTP LIGHTING REPLACEMENT 71,170 - - - - - LIFTSTATIONS 1-12 LINING PROJECT 141,930 192,786 - - - - WATER PUMPING & STORAGE STUDY - 81,420 100,000 68,360 - - WATER LINE REPLACEMENT PROGRAM - - 250,000 50,000 - 1,150,000 WWTP CLARIFIER AUTOMATION - - 80,000 67,545 - - SCADA WATER SYSTEM REPLACEMENT - 91,487 - 2,235 - - WASTEWATER REUSE - 42,700 - 110,000 - 680,000 FLOW METER REPLACEMENT/ INSTALLATION - 93,019 - - - - BOOSTER PUMP REPLACEMENT - - 300,000 - 300,000 WWTP GATE REPLACEMENT - - 300,000 - - WWTP FLOODWATER PROTECTION STUDY - 22,973 - - - - WWTP INFLOW AND INFILTRATION STUDY - 24,335 60,000 - - - WAKEFOREST TANK PIPE REPAIRS - - 150,000 150,000 - - LAW ST. WATER LINE INSTALLATION 110,000 50,000 60,000 140,000 WWTP MASTER PLAN - DESIGN & PER - - 1,800,000 300,000 1,500,000 - BELLAIRE ELEVATED STORAGE TANK REPLACEMENT - - - - - 100,000 MILTON CAST IRON WATER LINE REPLACEMENT - - - - 200,000 1,420,000 MILTON & WAKEFOREST WATER PLANT VALVE REPLACEMENT - - - - - 150,000 WAKEFOREST WATER PLANT GENERATOR - - - - - 200,000 SANITARY SEWER MANHOLE LINING PROJECT - - - - - 250,000 SANITARY SEWER IMPROVEMENTS - - - - - 100,000 WASTEWATER TREATMENT PLANT IMPROVEMENTS - - - - - 17,500,000 LIFT STATION SCADA REPLACEMENT - - - - - 430,000 MOBILE GENERATOR - - - - - 100,000 TOTAL EXPENDITURES 440,126$ 1,429,842$ 3,650,000$ 1,297,460$ 2,060,000$ 22,220,000$ BEGINNING BALANCE 1,986,014$ 2,497,030$ 1,697,259$ 1,977,890$ 3,382,430$ ENDING BALANCE 2,497,030$ 1,977,890$ 755,059$ 3,382,430$ 755,430$ WATER AND SEWER CAPITAL PROJECTS STATEMENT OF REVENUES AND EXPENDITURES 90 PERSONNEL 91 DEPARTMENT 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 GENERAL FUND Administration 5566566677 Finance 6555555666 Police 35 35 35 35 38 38 38 38 38 39 Fire 23 23 23 23 23 23 23 23 23 23 Public Works 20 19 18 18 18 18 18 19 20 20 Parks & Recreation 11 11 12 12 12 12 12 12 12 12 TECHNOLOGY MANAGEMENT FUND Administration 3344444444 WATER & SEWER FUND Finance – Utilities 2222222222 Operations 12 12 12 11 11 11 11 11 11 11 SOLID WASTE FUND Operations 8667777777 Total City FTE's 125 121 123 123 125 126 126 128 130 131 Full-Time Equivalent (FTE) Position Summary 92 3800 University Blvd.3800 University Blvd.3800 University Blvd. West University Place, TX 77005West University Place, TX 77005West University Place, TX 77005 713-668-4441713-668-4441713-668-4441 westutx.govwestutx.govwestutx.gov