Page 31 - Pantego FY23 Budget

TOWN OF PANTEGO
GENERAL FUND - DEPARTMENTAL DETAIL
PUBLIC WORKS (135)
FOR FY 2022-2023 BUDGET 2021-2022 2021-2022 2022-2023 2021-2022/
2019-2020 2020-2021 ADOPTED Y-T-D 2021-2022 PROPOSED 2022-2023
ACC. NUM. ACCOUNT DESCRIPTION ACTUAL ACTUAL BUDGET 7/31/2022 YE ESTIMATE BUDGET % CHANGE
PERSONNEL SERVICES

101.00 Salaries / Wages $ 303,876 $ 378,345 $ 385,191 $ 367,174 $ 433,933 $ 414,842 7.7%

101.10 Part-time Wages 26,439 34,444 35,884 20,147 $ 23,810 54,148 50.9%

102.00 Overtime Wages 23,508 26,092 26,442 35,740 $ 42,239 38,364 45.1%
102.10 Car Allowance 2,669 2,607 2,600 724 $ 724 - -100.0%
102.20 Certification Pay 8,100 5,701 5,525 4,051 $ 4,787 3,250 -41.2%

103.00 Longevity 1,645 1,835 2,220 1,705 $ 1,705 1,080 -51.4%

105.00 Sick Leave Buyback 4,752 6,004 13,304 6,620 $ 6,620 4,358 -67.2%

110.00 FICA/City Contribution 22,848 28,026 29,212 26,476 $ 31,290 31,995 9.5%
110.10 Medicare/City Contribution 5,343 6,555 6,832 6,192 $ 7,318 7,483 9.5%
120.02 TMRS Contribution 64,440 72,970 73,105 66,935 $ 79,105 78,243 7.0%
130.00 Worker's Compensation 7,081 10,435 9,233 11,364 $ 11,364 11,726 27.0%
130.02 Unemployment Insurance 1,078 1,594 2,520 493 $ 583 2,520 0.0%

130.05 Health/Dental Insurance 39,057 43,032 53,563 33,121 $ 39,745 70,947 32.5%
SUBTOTAL PERSONNEL SERVICES $ 510,837 $ 617,639 $ 645,631 $ 580,741 $ 683,221 $ 718,955 11.4%
CONTRACTUAL AGREEMENTS

232.00 Engineering & Maps $ 1,359 $ 2,217 $ 10,000 $ - $ 2,500 $ 2,500 -75.0%
247.00 Insurance Expense 2,713 4,959 4,368 7,091 7,092 6,024 37.9%

346.00 Traffic Signal Maintenance 1,741 1,127 3,500 197 295 3,000 -14.3%
525.00 Other Retainer and Service Fees 22,851 24,000 35,266 42,320 32,250 34.4%

348.00 Radio Lease (Arl.) 1,764 1,764 1,764 1,470 1,764 1,764 0.0%
SUBTOTAL CONTRACTUAL $ 7,577 $ 32,918 $ 43,632 $ 44,024 $ 53,972 $ 45,538 4.4%
SUPPLIES / MAINTENANCE
238.00 Office Supplies $ 3,831 $ 3,061 $ 3,250 $ 3,586 $ 5,379 $ 5,000 53.8%

239.00 Postage Service/Maintenance 508 1,496 2,973 2,608 $ 3,150 3,000 0.9%

243.00 Animal Control 995 2,802 4,500 1,553 $ 2,106 5,500 22.2%
248.10 Planning and Zoning 292 500 361 $ 542 750 50.0%

248.20 Zoning Board of Adjustment - 100 32 $ 110 200 100.0%

282.00 Printing Expense 301 485 1,000 81 $ 122 1,000 0.0%

329.00 Uniforms 902 920 1,736 1,565 $ 2,050 5,000 188.0%

350.00 Building Maintenance 19,607 2,675 2,900 2,130 $ 3,194 5,000 72.4%

352.00 Sidewalk Maintenance & Repair 1,445 931 7,000 229 $ 344 15,000 114.3%
353.00 Street / Drainage Maintenance 8,611 4,602 22,000 3,882 $ 5,463 25,000 13.6%

356.00 Vehicle / Equipment Expense 5,137 6,019 3,000 5,228 $ 6,500 4,500 50.0%
464.00 Landscaping & Improvements 4,221 7,050 10,000 4,374 $ 5,250 5,280 -47.2%
526.00 Code Compliance 125 1,000 - $ - 1,000 0.0%
527.00 Street Signage Maint/Repair 1,970 3,849 4,200 3,848 $ 5,431 7,500 78.6%
528.00 Equipment & Supplies 3,497 4,860 6,129 5,824 $ 7,250 11,350 85.2%
528.20 Traffic Control Supplies 269 364 1,000 495 $ 593 1,500 50.0%

529.00 Lawn Equipment Maintenance 547 370 700 701 $ 842 1,500 114.3%

530.00 Mosquito Control 13,009 3,188 10,000 3,141 $ 6,500 15,000 50.0%
536.00 Storm Water Repair 1,320 217 3,500 100 $ 150 5,000 42.9%
SUBTOTAL SUPPLIES/ MAINTENANCE $ 66,171 $ 43,305 $ 85,488 $ 39,737 $ 54,975 $ 118,080 38.1%
UTILITIES & GASOLINE
362.00 Gasoline / Oil Expense $ 4,126 $ 5,951 $ 3,500 $ 6,582 $ 7,898 $ 10,000 185.7%
411.00 Natural Gas and Electricity 2,884 2,593 2,200 2,554 $ 3,065 3,500 59.1%

411.10 Telephone Expense 5,603 5,781 1,525 5,006 $ 6,007 5,000 227.9%

411.20 Cell phone Expense 834 1,783 1,980 1,460 $ 1,752 2,000 1.0%
411.30 Water Expense 17,957 13,015 22,500 14,789 $ 17,747 20,000 -11.1%
413.00 Traffic Signal Electricity 1,440 1,022 2,500 885 $ 1,062 1,500 -40.0%

450.00 Street Lighting Electricity 30,123 35,224 34,000 30,150 $ 36,166 36,500 7.4%
SUBTOTAL UTILITIES & GASOLINE $ 62,967 $ 65,370 $ 68,205 $ 61,426 $ 73,697 $ 78,500 15.1%
TRAINING / DUES / MISC.
255.00 TML Deductible $ - $ - $ -

705.00 Membership Dues 348 358 1,225 452 678 1,250 2.0%
724.00 Travel / Training 696 1,514 2,900 585 878 2,500 -13.8%
770.00 Miscellaneous 932 2,141 2,000 3,252 3,903 4,500 125.0%
775.19 COVID-19 Emer Mgmt. 1,429 - -
775.21 Feb21 Winter Disaster Recovery 1,749 -

771.00 Staffing Expense - - -
SUBTOTAL TRAINING / DUES / MISC. $ 3,406 $ 5,763 $ 6,125 $ 4,289 $ 5,459 $ 8,250 34.7%
CAPITAL OUTLAY
480.00 Asset Purchases 46,561 - -
483.00 Minor Office Equipment $ - $ - $ 266 399 $ 1,500

486.00 Minor Equipment - - -
710.00 Capital Lease Principal - - -

710.10 Capital Lease Interest - - -
SUBTOTAL CAPITAL OUTLAY $ 46,561 $ - $ - $ 266 $ 399 $ 1,500
TOTAL PUBLIC WORKS $ 697,519 $ 764,995 $ 849,081 $ 730,483 $ 871,722 $ 970,823 14.3%
ADOPTED BUDGET FY2022-23 TOWNOFPANTEGO.COM/BUDGET PAGE 29