Loading...
FY21 Dept Requests 400-Water.pdfBWPRINT/3/BWDEPTREQ_/259899/ATLBMAB/192.88.55.23/IAEST4/1200629/134622/3C5C/0318 PREPARED 06/29/20, 13:46:22 BUDGET PREPARATION WORKSHEET PAGE 1 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST WATER FUND 400-0000-533.34-05 COLLECTN AGENCY COMMISSIN 619 2,620 2,000 359 780 2,000 400-0000-533.45-00 INSURANCE 17,943 49,904 53,271 44,907 0 58,598 400-0000-533.56-01 CITY MANAGER 34,935 34,935 34,935 17,468 0 34,935 400-0000-533.56-02 FINANCE AND ADMIN 295,448 295,448 386,843 193,422 0 386,843 400-0000-533.56-03 PUBLIC WORKS ADMIN 92,853 92,853 92,853 46,427 0 92,853 400-0000-533.56-05 HUMAN RESOURCES 11,639 11,639 11,639 5,820 0 11,639 400-0000-533.56-06 INFORMATION TECHNOLOGY 44,687 44,687 70,381 35,190 0 70,381 400-0000-533.56-07 FACILITIES MAINTENANCE 29,093 29,093 45,773 22,887 0 45,773 400-0000-533.59-01 BUILDING-PURCHASED 1,296 0 0 0 0 0 400-0000-533.59-02 BUILDING-CONTRIBUTED 1,820 0 0 0 0 0 400-0000-533.59-03 IMPR OTHER THAN BLD-PURCH 619,221 0 0 0 0 0 400-0000-533.59-04 IMP OTHER THAN BL-CONTRIB 86,361 0 0 0 0 0 400-0000-533.59-05 MACHINERY & EQUIPMENT 24,815 0 0 0 0 0 400-0000-533.59-06 MOTOR VEHICLES 21,054 0 0 0 0 0 400-0000-533.59-07 COMPUTER EQUIPMENT 2,012 0 0 0 0 0 400-0000-533.71-04 TD BANK-URB SERIES 2014 414,750 425,250 434,000 434,000 0 442,750 400-0000-533.71-09 SRF LOAN-DW160710 34,916 35,869 36,848 18,300 18,548 37,853 * 1,733,462 1,022,298 1,168,543 818,780 19,328 1,183,625 400-0000-581.91-01 FUND 001-GENERAL FUND 203,934 357,362 298,571 174,166 24,881 298,571 * 203,934 357,362 298,571 174,166 24,881 298,571 400-0000-590.73-13 2014 BOND AMORT 37,780 0 0 0 0 0 * 37,780 0 0 0 0 0 400-0000-591.72-04 TD BANK-URB SERIES 2014 81,102 80,877 70,867 70,867 0 60,653 400-0000-591.72-09 SRF LOAN-DW160710 14,552 14,010 13,032 6,640 6,392 12,026 * 95,654 94,887 83,899 77,507 6,392 72,679 PREPARED 06/29/20, 13:46:22 BUDGET PREPARATION WORKSHEET PAGE 2 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST 400-0000-599.69-14 2014 TD BANK DEBT RECLASS 414,750-425,250-0 0 0 0 400-0000-599.69-93 SRF DW160710 DEBT RECLASS 34,916-0 0 0 0 0 400-0000-599.69-99 CAPITAL EXPENSE RECLASS 268,333-0 0 0 0 0 * 717,999-425,250-0 0 0 0 ------------------------------------------- ------------------------------** WATER FUND 1,352,831 1,049,297 1,551,013 1,070,453 50,601 1,554,875 PREPARED 06/29/20, 13:46:22 BUDGET PREPARATION WORKSHEET PAGE 3 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST PRODUCTION 400-5502-533.12-00 SALARIES 136,746 153,336 121,561 80,257 17,216 115,262 LEVEL TEXT TEXT AMT DEPT CHIEF PLANT OPERATOR-WATER 51,001.60 + 3% 52,532 WASTEWATER/WATER OPERATOR TRAINEE 35,318.40 + 3% 36,378 CITY ENGINEER 102,336 + 3% X 25% 26,352 115,262 400-5502-533.14-00 OVERTIME 3,247 9,550 10,000 2,859 1,065 10,000 400-5502-533.15-00 SPECIAL PAY 13,658 4,451 10,000 3,361 485 5,000 LEVEL TEXT TEXT AMT DEPT CITY ENGINEER 121.20 X 26 3,152 3,152 400-5502-533.16-00 COMPENSATED ANNUAL LEAVE 71 71 0 0 0 0 400-5502-533.21-00 F.I.C.A. 11,248 12,276 3,832 6,382 1,384 9,959 400-5502-533.22-04 BENEFIT GROUP-GENERAL 14,715 24,424 21,008 12,255 1,751 21,639 400-5502-533.22-05 401 GENL DEF CONTR MATCH 1,340 0 1,250 118 236 1,582 LEVEL TEXT TEXT AMT DEPT CITY ENGINEER 59.04 + 3% X 26 1,582 1,582 400-5502-533.22-08 UNFUNDED LIABILITY-GEPP 39,255 177,237-27,140 11,308 0 27,955 400-5502-533.23-01 HEALTH 19,609 22,659 28,870 12,034 3,240 31,757 400-5502-533.23-02 LIFE 202 271 241 159 43 270 400-5502-533.24-00 WORKERS' COMPENSATION 597 4,859 4,459 1,513 363 4,593 400-5502-533.26-00 OTH POSTEMPLOY BENE(OPEB) 561 2,929-0 0 0 0 400-5502-533.31-00 PROFESSIONAL SERVICES 7,439 38,796 35,000 2,192 359 81,000 LEVEL TEXT TEXT AMT DEPT MEDICAL, PULMONARY FUNCTION TEST FOR RISK MGMT 1,000 MISC ENGINEERING, LEGAL, TANK INSPECTIONS, RMP 15,000 PREPARED 06/29/20, 13:46:22 BUDGET PREPARATION WORKSHEET PAGE 4 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST DISTRIBUTION SYSTEM MODELING & CIP DEVELOPMENT 65,000 81,000 400-5502-533.34-00 OTHER CONTRACTUAL SERVS. 100,394 114,859 126,500 42,212 6,652 138,500 LEVEL TEXT TEXT AMT DEPT LANDSCAPE MAINTENANCE 9,000 TREE TRIMMING NOT INCLUDED IN LANDSCAPE 4,000 BUILDING MAINTENANCE 10,000 PIPING, VALVE, ACTUATORS AND WELLS 10,000 LABORATORY TESTING 23,000 ELECTRICAL 20,000 15 HIGH SERVICE PUMPS AND MOTOR REPAIRS 10,000 9 WELLS INCLUDING PUMPS AND MOTORS 10,000 ELEV & GROUND STORAGE TANK MAINT./REP AERATORS 7,500 SCADA SYSTEM TROUBLESHOOTING & REPAIR 5,000 HVAC UNITS (5) 2,500 GENERATOR MAINTENANCE & REPAIR (5 GENSETS) 20,000 CONCRETE REPAIR 1,000 RIGGING MAINTE/REPAIR FOR CHLORINE HOISTS (3) 1,500 CHEMICAL FEED AND ALARM SYSTEM MAINT/REPAIR (CL2 AND ORTHOPHOSPHATE) (4 FACILITIES) 3,000 SECURITY SYSTEM MONITORING & REPAIR 2,000 138,500 400-5502-533.40-00 TRAVEL AND PER DIEM 0 429 3,000 47 29 3,000 400-5502-533.41-00 COMMUNICATIONS 2,240 2,064 4,750 1,887 612 4,750 LEVEL TEXT TEXT AMT DEPT DUTY PHONE (2) CELL PHONE (1), IPAD 1,400 5 TELEPHONES, AND ONE SCADA CALL OUT LINE 2,000 RADIOS 1 @55/MO 675 COMCAST 675 4,750 400-5502-533.42-00 TRANSP.,POSTAGE,MESSENGR. 38 0 200 20 43 200 400-5502-533.43-00 UTILITIES 90,473 96,834 98,000 58,271 5,801 98,000 LEVEL TEXT TEXT AMT DEPT JEA COSTS WATER TREATMENT PLANTS & WELLS INCREASED RATES DUE TO FUEL COST 98,000 98,000 PREPARED 06/29/20, 13:46:22 BUDGET PREPARATION WORKSHEET PAGE 5 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST 400-5502-533.43-01 CITY PROVIDED 10,382 10,084 11,000 5,086 1,313 11,000 400-5502-533.44-00 RENTALS & LEASES 0 42 400 0 0 400 400-5502-533.46-00 REPAIR & MAINTENANCE 9,531 28,687 31,600 9,065 13,066 78,500 LEVEL TEXT TEXT AMT DEPT REPAIRS TO SMALL EQUIPMENT NOT PART OF ENTIRE SYS 10,000 WTP GATES & ALARM REPAIR 30,000 SOFTWARE MAINTENANCE FOR TRIHEDRAL (SCADA) 3,500 WTP-4 PAINT & REHAB TANK 35,000 78,500 400-5502-533.46-01 FIRST VEHICLES/EQUIPMENT 5,605 13,925 6,000 3,076 420 7,000 400-5502-533.47-00 PRINTING AND PUBLISHING 0 85 600 0 0 600 400-5502-533.49-00 OTHER CURRENT CHARGES 4,600 5,000 5,500 0 0 5,500 LEVEL TEXT TEXT AMT DEPT RISK MGMT REGISTRATION FEE 800 DEP REGULATORY WTP LICENSE OPERATING FEE 4,000 DIESEL FUEL STORAGE FEE (3 SITES) 300 FIRE INSPECTOR FEE 400 5,500 400-5502-533.51-00 OFFICE SUPPLIES 1,471 1,475 1,500 638 290 2,000 LEVEL TEXT TEXT AMT DEPT OFFICE SUPPLIES, PRINT CARTRIDGES, COPY PAPER 2,000 2,000 400-5502-533.52-00 OPERATING SUPPLIES 30,456 44,302 48,750 31,997 9,156 52,000 LEVEL TEXT TEXT AMT DEPT CHLORING & HTH 24,000 LABORATORY CHEMICALS & SUPPLIES 4,500 INHIBITORS FOR CORROSION CONTROL 6,000 HURRICANE AND EMERGENCY SUPPLIES 2,000 BUILDINGS MAINTENANCE & SAFETY SUPPLIES 3,500 OILS & OTHER LUBRICANTS 1,000 REPAIR COMPONENTS, SPARE PARTS AND SHOP SUPPLIES 6,000 PERSONAL PROTECTIVE EQUIPMENT 1,500 INSTRUMENTATION SUPPLIES 3,500 PREPARED 06/29/20, 13:46:22 BUDGET PREPARATION WORKSHEET PAGE 6 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST 52,000 400-5502-533.52-01 GASOLINE 1,400 2,805 3,000 1,295 213 2,000 LEVEL TEXT TEXT AMT DEPT 3 VEHCILES 2,000 2,000 400-5502-533.52-02 DIESEL 1,096 895 2,500 0 0 2,500 LEVEL TEXT TEXT AMT DEPT DIESEL FUEL FOR 4 LARGE EMERGENCY GENERATORS 2,500 2,500 400-5502-533.54-00 BOOK,SUBSCRIP,MEMBERSHIPS 942 1,502 2,925 790 600 2,925 LEVEL TEXT TEXT AMT DEPT WATER ISAC (HOMELAND SECURITY) 500 AMERICAN WATER WORKS ASSOC. MEMBERSHIP 500 NE FL SAFETY COUNCIL 1,575 SAFETY MANUALS 50 FLA RURAL WATER 300 2,925 400-5502-533.55-00 TRAINING 4,057 4,864 6,000 4,526 100 8,000 LEVEL TEXT TEXT AMT DEPT JACKSONVILLE ENVIONMENTAL SYMPOSIUM FRWA ANNUAL CONFERENCE COURSES FOR CEU'S FOR OPERATORS (VARIOUS ONLINE AND CORRESPONDENCE AVAILABLE) FLORIDA SECTION AWWA ANNUAL CONFERENCE FLORIDA WATER AND POLLUTION CONTROL SHORT SCHOOLS SAFETY MANAGEMENT RESPIRATOR TRAINING AND FIT TEST PER RISK MGMT SCADA TRAINING CPR AND BASIC FIRST AID AND RMP TRAINING 400-5502-533.63-00 INFRASTRUCTURE 15,918 22,000 984,000 68,489 0 750,000 LEVEL TEXT TEXT AMT DEPT WTP2 MODERNIZATION 750,000 750,000 PREPARED 06/29/20, 13:46:22 BUDGET PREPARATION WORKSHEET PAGE 7 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST 400-5502-533.64-00 MACHINERY AND EQUIPMENT 16,284 24,290 147,500 0 0 72,500 LEVEL TEXT TEXT AMT DEPT REPLACE FLOW METERS 60,000 REPLACE TON SCALES AND LOAD CELLS ONE SET WTP1 12,500 72,500 400-5502-533.64-02 COMPUTER EQUIPMENT 0 0 1,200 0 0 1,700 LEVEL TEXT TEXT AMT DEPT COMPUTER REPLACEMENT 1,700 1,700 * 543,575 464,669 1,748,286 359,837 64,437 1,550,092 -------------------------------------------------------------------------** PRODUCTION 543,575 464,669 1,748,286 359,837 64,437 1,550,092 PREPARED 06/29/20, 13:46:22 BUDGET PREPARATION WORKSHEET PAGE 8 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST DISTRIBUTION 400-5504-533.12-00 SALARIES 280,760 235,649 297,135 142,298 40,357 277,804 LEVEL TEXT TEXT AMT DEPT ADMINISTRATIVE ASSISTANT 36,587.20 + 3% X 50% 18,842 UTILITY COLLECTIONS/DISTRIBUTION OPERATOR TRAINEE (2) 62,462.40 + 3% 64,336 UTILITY COLLECTIONS/DISTRIBUTION OPERATOR (2) 70,657.60 + 3% 72,777 LOCATOR 32,884.80 + 3% 33,871 UTILITY COLLECTIONS/DISTIRUBTION SUPERVISOR 42,432 + 3% 43,705 DISTRIBUTION DIRECTOR 85,966.40 + 3% X 50% 44,273 277,804 400-5504-533.14-00 OVERTIME 22,922 30,394 40,000 17,336 3,561 30,000 400-5504-533.15-00 SPECIAL PAY 8,459 8,644 6,000 7,261 1,625 9,752 LEVEL TEXT TEXT AMT DEPT UTILITY COLLECTIONS/DISTRIBUTION OPERATOR (2) 375.06 X 26 9,752 9,752 400-5504-533.16-00 COMPENSATED ANNUAL LEAVE 4,100 4,100 0 0 0 0 400-5504-533.21-00 F.I.C.A. 22,989 20,633 22,829 12,383 3,313 24,294 400-5504-533.22-04 BENEFIT GROUP-GENERAL 9,170 18,176 15,630 9,118 1,303 16,099 400-5504-533.22-05 401 GENL DEF CONTR MATCH 3,297 295 0 1,364 540 3,614 400-5504-533.22-08 UNFUNDED LIABILITY-GEPP 76,791 75,428 71,801 29,917 0 71,801 400-5504-533.23-01 HEALTH 56,337 47,520 69,621 31,653 10,628 76,583 400-5504-533.23-02 LIFE 589 557 487 379 105 536 400-5504-533.24-00 WORKERS' COMPENSATION 9,609 8,749 6,996 3,364 926 7,206 400-5504-533.31-00 PROFESSIONAL SERVICES 2,387 2,258 25,500 10,214 0 25,500 LEVEL TEXT TEXT AMT DEPT EMP PHYSICALS, MEDICAL EXPENSES, HEPATITIS SHOTS SCREENINGS & DRUG TESTING 500 PREPARED 06/29/20, 13:46:22 BUDGET PREPARATION WORKSHEET PAGE 9 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST MISC ENGINEERING OR SURVEYING EXPENSES 25,000 25,500 400-5504-533.34-00 OTHER CONTRACTUAL SERVS. 147,061 102,295 215,500 72,809 11,403 197,500 LEVEL TEXT TEXT AMT DEPT VALVE REPLACEMENT PROGRAM 50,000 HYDRANT REPLACEMENT/REPAIR (FIRE DEPT REQUEST) 40,000 POINT REPAIRS, PIPING ETC 40,000 ASPHALT WORK 7,500 CONCRETE REPAIR 15,000 REPLACE 2 LARGE METERS 20,000 WATER SERVICE INSTALLATION 25,000 197,500 400-5504-533.40-00 TRAVEL AND PER DIEM 280 1,456 3,200 615 1,011 1,200 400-5504-533.41-00 COMMUNICATIONS 4,171 4,170 5,200 3,448 1,488 3,400 LEVEL TEXT TEXT AMT DEPT EMPLOYEE CITY PHONES CELL ACTIVATED 400 RADIO CHARGES 2,500 FIELD TABLETS 500 3,400 400-5504-533.42-00 TRANSP.,POSTAGE,MESSENGR. 0 0 20 0 0 100 400-5504-533.43-00 UTILITIES 1,625 1,688 2,300 962 139 2,200 LEVEL TEXT TEXT AMT DEPT BASED ON CURRENT YEAR CHARGES 2,200 2,200 400-5504-533.44-00 RENTALS & LEASES 2,316 1,656 2,000 828 364 2,000 LEVEL TEXT TEXT AMT DEPT UNIFORM RENTAL 2,000 2,000 400-5504-533.46-00 REPAIR & MAINTENANCE 13,510 6,307 20,700 2,966 0 17,950 LEVEL TEXT TEXT AMT DEPT ESRI (GIS) SOFTWARE MAINTENANCE (ADD ARCGIS SVR) 16,000 PREPARED 06/29/20, 13:46:22 BUDGET PREPARATION WORKSHEET PAGE 10 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST TOKAY (CROSS CONNECTION) SOFTWARE MAINTENANCE 450 MAINTENANCE OF SMALL EQUIP (CONC CUTTING SAWS PUMPS, MUDHOG, GENERATOR, ETC) 1,500 17,950 400-5504-533.46-01 FIRST VEHICLES/EQUIPMENT 25,733 25,829 24,172 16,298 1,857 24,200 400-5504-533.47-00 PRINTING AND PUBLISHING 1,525 80 1,500 0 0 1,500 LEVEL TEXT TEXT AMT DEPT EMPLOYMENT ADS, MISCELLANEOUS 1,500 1,500 400-5504-533.51-00 OFFICE SUPPLIES 205 559 1,000 99 177 1,000 400-5504-533.52-00 OPERATING SUPPLIES 162,101 213,113 230,000 173,032 15,968 130,500 LEVEL TEXT TEXT AMT DEPT LARGE METERS, METER BOXES, REPAIR PARTS 50,000 METERS FOR METER REPLACEMENT PROGRAM (200 METERS) 35,000 PIPE AND FITTINGS, VALVES, BACKFLOW PREVENTERS 40,000 SAFETY SUPPLIES, HURRICANE SUPPLIES 3,500 HAND TOOLS, POWER TOOLS AND FIELD EQUIPMENT 2,000 130,500 400-5504-533.52-01 GASOLINE 13,328 12,305 10,000 6,609 861 10,000 400-5504-533.52-02 DIESEL 1,228 308 1,250 320 90 1,250 400-5504-533.54-00 BOOK,SUBSCRIP,MEMBERSHIPS 115 415 1,000 110 0 1,000 LEVEL TEXT TEXT AMT DEPT FLORIDA RURAL WATER ASSOC MEMBERSHIP 500 MISC AWWA MANUALS/BOOKS 500 1,000 400-5504-533.55-00 TRAINING 435 506 4,000 479 0 4,000 LEVEL TEXT TEXT AMT DEPT CEU AND TRAINING COURSES FOR DIST CREW 2,000 TRAINING FOR GIS STAFF 2,000 4,000 400-5504-533.63-00 INFRASTRUCTURE 189,957 103,063 140,000 0 0 390,000 PREPARED 06/29/20, 13:46:22 BUDGET PREPARATION WORKSHEET PAGE 11 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST LEVEL TEXT TEXT AMT DEPT DUTTON ISLAND RD TO COVE 8" WATER MAIN 200,000 MAYPORT RD CROSSING @A1A -12" WATER MAIN 150,000 CAVALLA-INSTALL LONG SIDE NEW SERVICE CONNECTIONS 40,000 390,000 400-5504-533.64-00 MACHINERY AND EQUIPMENT 44,954 27,685 0 0 0 45,000 LEVEL TEXT TEXT AMT DEPT GPR UTILITY LOCATOR 35,000 4" DOUBLE DIAPHRAGM PUMP 10,000 45,000 400-5504-533.64-01 MOTOR VEHICLES 0 25,099 0 0 0 50,000 LEVEL TEXT TEXT AMT DEPT F450 50,000 50,000 400-5504-533.64-02 COMPUTER EQUIPMENT 1,478 0 0 0 0 3,400 LEVEL TEXT TEXT AMT DEPT 2 LAPTOPS 3,400 3,400 * 1,107,432 978,937 1,217,841 543,862 95,716 1,429,389 ------------------- ------------------------------------------------------** DISTRIBUTION 1,107,432 978,937 1,217,841 543,862 95,716 1,429,389 -------------------------------------------------------------------------*** WATER FUND 3,003,838 2,492,903 4,517,140 1,974,152 210,754 4,534,356 3,003,838 2,492,903 4,517,140 1,974,152 210,754 4,534,356 410-Sewer.pdfBWPRINT/3/BWDEPTREQ_/259901/ATLBMAB/192.88.55.23/IAEST4/1200629/134639/2D2C/0304 PREPARED 06/29/20, 13:46:39 BUDGET PREPARATION WORKSHEET PAGE 1 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST SEWER FUND 410-0000-535.45-00 INSURANCE 67,990 138,148 128,321 125,069 0 141,153 410-0000-535.56-01 CITY MANAGER 63,251 63,251 63,251 31,626 0 63,251 410-0000-535.56-02 FINANCE AND ADMIN 300,558 300,558 300,558 150,279 0 300,558 410-0000-535.56-03 PUBLIC WORKS ADMIN 92,853 92,853 92,853 46,427 0 92,853 410-0000-535.56-05 HUMAN RESOURCES 24,506 24,506 24,506 12,253 0 24,506 410-0000-535.56-06 INFORMATION TECHNOLOGY 94,091 94,091 119,785 59,892 0 119,785 410-0000-535.56-07 FACILITIES MAINTENANCE 49,537 49,537 77,937 38,969 0 77,937 410-0000-535.59-01 BUILDING-PURCHASED 5,696 0 0 0 0 0 410-0000-535.59-03 IMPR OTHER THAN BLD-PURCH 1,009,596 0 0 0 0 0 410-0000-535.59-04 IMP OTHER THAN BL-CONTRIB 127,993 0 0 0 0 0 410-0000-535.59-05 MACHINERY & EQUIPMENT 50,007 0 0 0 0 0 410-0000-535.59-06 MOTOR VEHICLES 33,491 0 0 0 0 0 410-0000-535.59-07 COMPUTER EQUIPMENT 183 0 0 0 0 0 410-0000-535.59-11 LAND IMPROVEMENTS 190 0 0 0 0 0 410-0000-535.71-04 TD BANK-URB SERIES 2014 616,200 631,800 644,800 644,800 0 657,800 410-0000-535.71-10 SRF LOAN-WW160700 323,342 333,575 344,132 170,725 173,406 355,022 * 2,859,484 1,728,319 1,796,143 1,280,040 173,406 1,832,865 410-0000-581.91-01 FUND 001-GENERAL FUND 440,286 500,286 441,495 257,539 36,791 441,495 410-0000-581.91-03 FUND 300-CAPITAL PROJECTS 0 0 100,000 0 0 0 * 440,286 500,286 541,495 257,539 36,791 441,495 410-0000-590.73-13 2014 BOND AMORT 56,130 0 0 0 0 0 * 56,130 0 0 0 0 0 410-0000-591.72-04 TD BANK-URB SERIES 2014 120,493 120,160 105,288 105,288 0 90,113 410-0000-591.72-10 SRF LOAN-WW160700 184,803 178,378 167,822 85,251 82,571 156,932 * 305,296 298,538 273,110 190,539 82,571 247,045 PREPARED 06/29/20, 13:46:39 BUDGET PREPARATION WORKSHEET PAGE 2 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST 410-0000-599.69-14 2014 TD BANK DEBT RECLASS 616,200-631,800-0 0 0 0 410-0000-599.69-94 SRF WW160700 DEBT RECLASS 323,342-0 0 0 0 0 410-0000-599.69-99 CAPITAL EXPENSE RECLASS 903,869-0 0 0 0 0 * 1,843,411-631,800-0 0 0 0 ---------------------------------------- ---------------------------------** SEWER FUND 1,817,785 1,895,343 2,610,748 1,728,118 292,768 2,521,405 PREPARED 06/29/20, 13:46:39 BUDGET PREPARATION WORKSHEET PAGE 3 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST COLLECTION/TRANSMISSION 410-5506-535.12-00 SALARIES 212,625 183,446 234,055 96,334 27,268 179,212 LEVEL TEXT TEXT AMT DEPT ADMINISTRATIVE ASST 36,587.20 + 3% X 50% 18,842 DISTRIBUTION DIRECTOR 85,966.40 + 3% X 50% 44,273 CROSS CONNECTION CONTROL/INSPEC SUPERVISOR 62,524.80 + 3% 64,401 UTILITIES MAINTENANCE SUPERVISOR 50,190.40 + 3% 51,696 179,212 410-5506-535.14-00 OVERTIME 7,899 9,609 10,000 3,653 1,140 10,000 410-5506-535.15-00 SPECIAL PAY 10,171 8,322 13,390 3,170 500 3,251 LEVEL TEXT TEXT AMT DEPT CROSS CONNECTION CONTROL/INSPEC SUPERVISOR 125.02 X 26 3,251 3,251 410-5506-535.16-00 COMPENSATED ANNUAL LEAVE 522 522 0 0 0 0 410-5506-535.21-00 F.I.C.A. 16,923 14,620 14,582 7,577 2,131 13,959 410-5506-535.22-04 BENEFIT GROUP-GENERAL 21,068 21,772 18,731 10,926 1,561 19,293 410-5506-535.22-05 401 GENL DEF CONTR MATCH 1,340 259 0 303 84 566 410-5506-535.22-08 UNFUNDED LIABILITY-GEPP 48,071 35,867 34,142 14,226 0 35,167 410-5506-535.23-01 HEALTH 38,859 35,324 23,283 17,518 4,384 25,611 410-5506-535.23-02 LIFE 410 379 409 219 64 409 410-5506-535.24-00 WORKERS' COMPENSATION 5,470 5,372 5,611 1,806 505 5,780 410-5506-535.26-00 OTH POSTEMPLOY BENE(OPEB) 953 3,132-0 0 0 0 410-5506-535.31-00 PROFESSIONAL SERVICES 24,751 4,231 32,500 0 0 65,500 LEVEL TEXT TEXT AMT DEPT EMPLOYEE PHYSICAL/DRUG SCREENS 500 MISC. ENGINEERING 45,000 SEWER SYSTEM CAPACITY ANALYSIS 20,000 65,500 PREPARED 06/29/20, 13:46:39 BUDGET PREPARATION WORKSHEET PAGE 4 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST 410-5506-535.34-00 OTHER CONTRACTUAL SERVICE 225,770 176,184 171,500 49,574 13,282 208,500 LEVEL TEXT TEXT AMT DEPT SEWER CLEANING & TELEVISE, SEWER JETTING 12,000 LANDSCAPE MAINTENANCE TREE TRIMMING/REMOVAL 2,500 FENCE & GATE REPAIR 5,000 GENERATOR REPAIR AND ANNUAL MAINTENANCE 15,000 LIFT STATION PUMPS, MOTORS, VALVES AND PIPING 30,000 ELECTRICAL AND CONTROL TROUBLESHOOTING/REPAIR 20,000 WET WELL CLEANING-BUCCANEER MASTER LIFT STATION 5,000 ASPHAT REPAIR 10,000 CONCRETE/WETWELL/MANHOLE RING REPAIR 18,000 MANHOLE REPAIRS 16,000 POINT REPAIRS TO SEWER MAINS/LATERALS 75,000 208,500 410-5506-535.40-00 TRAVEL AND PER DIEM 1,915 1,768 2,000 811 1,068 2,000 LEVEL TEXT TEXT AMT DEPT MILEAGE FOR CALLOUTS FOR SEWER COMPLAINTS/ALARMS 2,000 2,000 410-5506-535.41-00 COMMUNICATIONS 3,203 3,871 4,100 2,159 752 2,500 LEVEL TEXT TEXT AMT DEPT 1 RADIO @$55/MO 700 LAND LINE 900 LAPTOP/TABLET 900 2,500 410-5506-535.42-00 TRANSP.,POSTAGE,MESSENGER 17 75 45 28 0 50 410-5506-535.43-00 UTILITIES 52,423 50,048 55,000 30,214 3,147 55,000 410-5506-535.43-01 CITY PROVIDED 9,461 9,710 12,000 6,340 1,697 12,000 410-5506-535.44-00 RENTALS & LEASES 289 10,627 500 168 61 500 LEVEL TEXT TEXT AMT DEPT RENTALS OF UNIFORMS, PUMPS & EQUIPMENT 500 500 410-5506-535.46-00 REPAIR & MAINTENANCE 7,089 25,910 40,500 24,805 4,041 476,000 PREPARED 06/29/20, 13:46:39 BUDGET PREPARATION WORKSHEET PAGE 5 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST LEVEL TEXT TEXT AMT DEPT SEWER/LS REPAIRS AND REPAIRS TO SEWER MAINT EQUIP 10,000 TRIHEDRAL SOFTWARE MAINTENANCE FOR LIFT STATIONS 1,000 REPAIR & MAINTENANCE TO 33 LIFT STATIONS 10,000 SELVA MARINA LS PUMP REHAB 20,000 REPLACE DEP LS INFLUENT LINES (3) 300,000 MONTREAL LS -RELOCATE CHECK VALVES 5,000 LS CHECK VALVES (AS REQUIRED) 10,000 LS UPGRADES FOR REDUNDANCY (AS REQUIRED) 20,000 UPGRADE LS WATER SERVICES (ALL) 100,000 476,000 410-5506-535.46-01 FIRST VEHICLES/EQUIPMENT 17,986 34,449 17,380 11,618 1,830 15,000 410-5506-535.47-00 PRINTING & PUBLISHING 23 177 800 0 0 800 LEVEL TEXT TEXT AMT DEPT ADVERTISEMENTS AND BUSINESS CARDS 410-5506-535.49-00 OTHER CURRENT CHARGES 500 0 0 0 0 0 410-5506-535.52-00 OPERATING SUPPLIES 29,831 35,625 44,000 17,979 4,120 44,000 LEVEL TEXT TEXT AMT DEPT LUBRICANTS FOR LIFT STATIONS 500 LP GAS FOR LIFT STATIONS 15,000 MISC PARTS FOR LIFT STATIONS 15,000 WEED KILLER ODOR CONTROL DEGREASERS SAFETY 4,500 ENZYMES FOR GREASE REDUCTION 5,000 LIFT STATION BEAUTIFICATION 4,000 44,000 410-5506-535.52-01 GASOLINE 681 884 2,750 815 115 1,000 LEVEL TEXT TEXT AMT DEPT UTILITY TRUCTS 1,000 1,000 410-5506-535.52-02 DIESEL 1,663 3,024 3,000 2,176 477 3,000 LEVEL TEXT TEXT AMT DEPT LIFT STATION GENSETS 3,000 3,000 PREPARED 06/29/20, 13:46:39 BUDGET PREPARATION WORKSHEET PAGE 6 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST 410-5506-535.54-00 BOOK,SUBSCRIP,MEMBERSHIPS 125 100 750 0 0 750 LEVEL TEXT TEXT AMT DEPT PROFESSIONAL MEMBERSHIPS AND REFERENCE BOOKS 750 750 410-5506-535.55-00 TRAINING 291 75 2,000 127 0 2,000 LEVEL TEXT TEXT AMT DEPT OPERATOR TRAINING 2,000 2,000 410-5506-535.63-00 INFRASTRUCTURE 348,486 400,249 191,000 67,693 0 776,000 LEVEL TEXT TEXT AMT DEPT REPLACE SUCTION LINES AT 4 LIFT STATIONS 52,000 REPLACE TWO WETWELL TOPS WITH OPEN HATCHES 24,000 WETWELL AND SUCTION PIPES REPAIR 100,000 PUCKET CREED FM CORSSING @OAK HARBOR BAPTIST 100,000 SELVA MARINA FM EXTENSION 150,000 SEPTIC-TO-SEWER -BEGONIA TO W. PLAZA 350,000 776,000 410-5506-535.64-00 MACHINERY & EQUIPMENT 167,272 122,304 58,529 120 120-100,000 LEVEL TEXT TEXT AMT DEPT BUCCANEER LS ODOR CONTROL 60,000 SELVA MARINA LS ODOR CONTROL 40,000 100,000 410-5506-535.64-02 COMPUTER EQUIPMENT 0 0 1,200 416 0 1,700 LEVEL TEXT TEXT AMT DEPT COMPUTER FOR LS TECH 1,700 1,700 * 1,256,087 1,191,671 993,757 370,775 68,107 2,059,548 410-5506-584.71-18 VAC CON CAP LEASE 18 0 31,530 31,531 31,530 0 34,081 410-5506-584.72-18 VAC CON CAP LEASE 18 3,391 5,307 5,308 5,307 0 2,757 * 3,391 36,837 36,839 36,837 0 36,838 PREPARED 06/29/20, 13:46:39 BUDGET PREPARATION WORKSHEET PAGE 7 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST -------------------------------------------------------------------------** COLLECTION/TRANSMISSION 1,259,478 1,228,508 1,030,596 407,612 68,107 2,096,386 PREPARED 06/29/20, 13:46:39 BUDGET PREPARATION WORKSHEET PAGE 8 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST TREATMENT 410-5508-535.12-00 SALARIES 528,047 471,995 670,303 271,542 81,578 582,050 LEVEL TEXT TEXT AMT DEPT CITY ENGINEER 102,336 + 3% X 25% 26,352 PLANTS OPERATIONS MANAGER/INTERIM PUBLIC UTILITIES DIRECTOR 87,401.60 + 3% 90,024 LIFT STATION TECHNICIAN 41,308.80 + 3% 42,548 WASTEWATER/WATER OPERATOR IV 45,780.80 + 3% 47,154 WASTEWATER/WATER OPERATOR I 55,328 +3% 56,988 HEAVY EQUIPMENT OPERATOR 44,720 + 3% 46,062 CHIEF PLANT OPERATOR WASTEWATER 70,865.60 + 3% 72,992 WASTEWATER OPERATOR I 57,324.80 + 3% 59,045 WASTEWATER OPERATOR IV 70,033.60 + 3% 72,135 WASTEWATER/WATER OPERATOR II 66,747.20 + 3% 68,750 582,050 410-5508-535.14-00 OVERTIME 16,242 23,213 23,000 14,984 5,913 18,000 410-5508-535.15-00 SPECIAL PAY 40,820 24,372 18,055 9,905 3,474 23,393 LEVEL TEXT TEXT AMT DEPT CITY ENGINEER 121.20 X 26 3,152 INTERIM PUBLIC UTILITIES DIRECTOR 403.39 X 26 10,488 LIFT STATION TECHNICIAN 125.02 X 26 3,251 CALL-OUT 6,502 23,393 410-5508-535.16-00 COMPENSATED ANNUAL LEAVE 23,107-23,107-0 0 0 0 410-5508-535.21-00 F.I.C.A. 42,525 37,723 48,080 21,423 6,560 47,694 410-5508-535.22-04 BENEFIT GROUP-GENERAL 53,219 55,339 47,606 27,770 3,967 49,034 410-5508-535.22-05 401 GENL DEF CONTR MATCH 1,340 2,388 1,500 1,501 617 4,014 410-5508-535.22-08 UNFUNDED LIABILITY-GEPP 235,114 255,775 243,474 101,448 0 250,778 410-5508-535.23-01 HEALTH 90,181 88,164 101,295 54,063 15,985 11,425 410-5508-535.23-02 LIFE 865 884 1,120 547 169 1,120 410-5508-535.24-00 WORKERS' COMPENSATION 22,732 29,540 47,045 12,982 4,652 48,456 410-5508-535.31-00 PROFESSIONAL SERVICES 9,257 20,121 77,000 26,490 8,649 127,000 PREPARED 06/29/20, 13:46:39 BUDGET PREPARATION WORKSHEET PAGE 9 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST LEVEL TEXT TEXT AMT DEPT MEDICAL, PUMONARY FUNCTION TEST PER RIST MGMT 1,000 ENGINEERING, LEGAL RMP 1,000 ENGINEERING -INFLUENT MASTER WETWELL STUDY/DESIGN 100,000 ENGINEERING FOR TANKS, AND PLANT STUDY 25,000 127,000 410-5508-535.34-00 OTHER CONTRACTUAL SERVICE 130,235 184,617 114,000 69,919 11,785 229,000 LEVEL TEXT TEXT AMT DEPT GENSET MATINENANCE 2 GENSETS 20,000 ELECTRICAL 25,000 PUMPS, MOTORS AND BLOWERS 45,000 PIPING, VALVES, FITTING, AND OTHER POINT REPAIRS 20,000 SCADA SYSTEM TROUBLESHOOTING 15,000 HVAC REPAIR (5) 7,000 TANK (6), STRUCTURS, BUILDINGS, (7) GATES, FENCES WETWELLS, AND ELECTRONIC DOOR MAINTENANCE 2,000 LANDSCAPE MAINTENANCE AND PEST CONTROL 7,000 TREE TRIMMING NOT INCLUDED IN CONTRACT 4,000 LABORATORY TESTING FOR WATEWATER, STORMWATER AND REFUSE SYSTEM 30,000 CHLORINE AND SULFUR DIOXIDE CHEMICAL FEED SYSTEM 5,000 HOISTS INSPECTIONS AND REPAIRS FOR CL2 AND SO4 1,000 LABORATORY EQUIPMENT ANNUAL CERTIFICATE 3,000 HACH CHLORINE MAINTENANCE AGREEMENTS 3,000 DIESEL FUEL TANK INSPECTIONS AND CLEANING 3,000 WELDING/FABRICATION/REPAIRS 4,000 SLUDGE TIPPING FEES 32,000 REUSE HYDO TANK INSPECTIONS 3,000 229,000 410-5508-535.40-00 TRAVEL AND PER DIEM 285 74 500 47 29 500 LEVEL TEXT TEXT AMT DEPT MILEAGE FOR CALL OUTS PER UNION CONTRACT 500 500 410-5508-535.41-00 COMMUNICATIONS 5,236 4,148 5,560 2,228 598 3,320 LEVEL TEXT TEXT AMT DEPT 4 PHONE LINES (1 FAX LINE AND ONE SCADA CALLOUT) 1,200 RADIOS 2 @$55/MO 1,320 2 CELL PHONES 800 PREPARED 06/29/20, 13:46:39 BUDGET PREPARATION WORKSHEET PAGE 10 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST 3,320 410-5508-535.42-00 TRANSP.,POSTAGE,MESSENGER 181 196 1,500 114 0 500 LEVEL TEXT TEXT AMT DEPT SHIPPING OF SAMPLES BIOASSAYS, LAB EQUIPNMENT ETC 500 500 410-5508-535.43-00 UTILITIES 158,501 158,450 192,000 90,501 8,705 192,000 LEVEL TEXT TEXT AMT DEPT JEA COST FOR WASTEWATER PLANT 180,000 JEA COST FOR RECLAIMED WATER FACILITY 12,000 192,000 410-5508-535.43-01 CITY PROVIDED 25,493 25,716 31,000 15,226 4,352 20,000 LEVEL TEXT TEXT AMT DEPT CITY PROVIDED UTILITIS FOR WATER AND GARBAGE PICKUP (9 DUMPSTERS) 20,000 20,000 410-5508-535.44-00 RENTALS & LEASES 1,305 906 1,750 521 151 1,000 LEVEL TEXT TEXT AMT DEPT UNIFORMS AND OTHER EQUIPMENT 1,000 1,000 410-5508-535.46-00 REPAIR & MAINTENANCE 37,163 71,073 52,300 34,516 235 199,300 LEVEL TEXT TEXT AMT DEPT REPAIRS OF EQUIPMENT PUMPS, MOTORS, LAB EQUIPMENT GENERATORS AND OTHER EQUIPEMENT 35,000 SOFTWARE MAINTENANCE FOR TRIHEDRAL 3,500 SOFTWARE MAINTENANCE FOR OP10 WASTEWATER PROGRAM 2,000 WETWELL CLEANING FOR MASTER WETWELL 10,800 REBUILD 2 BLOWERS 45,000 CENTRIFUGE R&R 25,000 REPLACE DOORS 5,000 CENTRIFUGE EXHAUST FAN 8,000 REUSE SYSTEM R&R 25,000 GEAR DRIVE FOR AERATION TANK MIXER 40,000 199,300 PREPARED 06/29/20, 13:46:39 BUDGET PREPARATION WORKSHEET PAGE 11 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST 410-5508-535.46-01 FIRST VEHICLES/EQUIPMENT 12,817 13,831 10,000 8,712 1,204 11,000 LEVEL TEXT TEXT AMT DEPT FIRST VEHICLE REPAIR & MAINTENANCE 11,000 11,000 410-5508-535.47-00 PRINTING & PUBLISHING 386 746 1,200 0 0 500 LEVEL TEXT TEXT AMT DEPT ADVERTISEMENT FOR BIDS/DEP PERMITS 400 BUSINESS CARDS, CITY FORMS, STATIONERY, ETC. 100 500 410-5508-535.49-00 OTHER CURRENT CHARGES 6,350 11,250 8,600 6,250 0 7,600 LEVEL TEXT TEXT AMT DEPT DIESEL STORAGE TANKS STATE REGISTRATION 200 RISK MGMT FEES 800 FDEP REGULATORY FEE FOR WWTP 6,500 FIRE DEPT INSPECTION 100 7,600 410-5508-535.51-00 OFFICE SUPPLIES 1,203 477 1,500 0 161 1,000 410-5508-535.52-00 OPERATING SUPPLIES 139,599 116,178 157,000 105,442 17,373 160,000 LEVEL TEXT TEXT AMT DEPT CHLORINE 15,000 SULFUR DIOXIDE PRICE DOUBLE FROM LAST CONTRACT 35,000 POLYMER 30,000 LAB SAFETY, CLEANING AND HURRICANE SUPPLIES 10,000 PUMP PARTS, SPARE PARTS, HOSES, HARDWARE, TOOLS 5,000 HTH AND LIME 7,000 LUBRICANTS FOR PLANT EQUIPMENT 3,000 REPLACEMENT SENSORS FOR ALARMS 3,000 PAINT FOR PLANT AND EQUIPMENT 2,000 SODIUM HYPOCHLORITE 30,000 FERRIC SULFATE FOR PHOSPHORUS REMOVAL 20,000 160,000 410-5508-535.52-01 GASOLINE 6,184 4,029 5,000 1,762 297 3,500 LEVEL TEXT TEXT AMT PREPARED 06/29/20, 13:46:39 BUDGET PREPARATION WORKSHEET PAGE 12 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST DEPT GAS FOR 3 VEHICLES 3,500 3,500 410-5508-535.52-02 DIESEL 11,236 14,221 12,500 5,992 1,123 10,000 LEVEL TEXT TEXT AMT DEPT DIESEL FOR TWO SLUDGE TRUCKS AND EMERGENCY GENERATORS (2) 10,000 10,000 410-5508-535.54-00 BOOK,SUBSCRIP,MEMBERSHIPS 967 1,654 3,000 822 100 2,000 LEVEL TEXT TEXT AMT DEPT NORTHEAST FLORIDA SAFETY COUNCIL WATER ENVIRONMENT FEDERATION MISC PUBLICATIONS FOR WASTEWATER TREATMENT FWEA UTILITY WATER ISAC (HOMELAND SECURITY) RURAL WATER MEMBERSHIP 2,000 2,000 410-5508-535.55-00 TRAINING 4,446 2,235 6,500 187 0 6,500 LEVEL TEXT TEXT AMT DEPT COURSE FOR CEU FOR OPERATORS; FLORIDA RURAL WATER ASSOC ANNUAL CONF; TREEO CENTER GAINESVILLE; FWPCA SHORT SCHOOLS; RISK MGMT TRAINING 6,500 6,500 410-5508-535.63-00 INFRASTRUCTURE 366,008 21,362 775,000 212,241 12,500 600,000 LEVEL TEXT TEXT AMT DEPT INFLUENT WETWELL REPLACEMENT/EXPANSION 250,000 UPSIZE HEADWORKS LINE TO AERATION BASIN 350,000 600,000 410-5508-535.64-00 MACHINERY & EQUIPMENT 21,845 40,961 27,500 6,495 0 36,000 LEVEL TEXT TEXT AMT DEPT CL-17 CHLORINE ANALYZER 10,000 SPARE CHLORINE INDUCTOR PUMP 9,000 HYPOCHLORITE TANK 5,000 RO SLUDGE CONTAINER (2) 12,000 PREPARED 06/29/20, 13:46:39 BUDGET PREPARATION WORKSHEET PAGE 13 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST 36,000 410-5508-535.64-01 MOTOR VEHICLES 0 18,570 0 0 0 0 410-5508-535.64-02 COMPUTER EQUIPMENT 0 0 1,200 0 0 1,700 LEVEL TEXT TEXT AMT DEPT WIRELESS LAPTOP 1,700 1,700 * 1,946,675 1,677,101 2,686,088 1,103,630 190,177 2,648,384 ---------------------------------------------- ---------------------------** TREATMENT 1,946,675 1,677,101 2,686,088 1,103,630 190,177 2,648,384 -------------------------------------------------------------------------*** SEWER FUND 5,023,938 4,800,952 6,327,432 3,239,360 551,052 7,266,175 5,023,938 4,800,952 6,327,432 3,239,360 551,052 7,266,175 City Attorney.pdfBWPRINT/3/BWDEPTREQ_/259876/ATLBMAB/192.88.55.23/IAEST4/1200629/134402/3974/0308 PREPARED 06/29/20, 13:44:02 BUDGET PREPARATION WORKSHEET PAGE 1 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST GENERAL FUND LEGAL SERVICES 001-1004-514.31-00 PROFESSIONAL SERVICES 200,611 145,980 150,000 99,606 27,185 150,000 001-1004-514.31-02 CITY ATTORNEY RETAINER 1,000-0 0 0 0 0 001-1004-514.31-03 LAND ISSUE 0 19,975 0 0 0 0 * 199,611 165,955 150,000 99,606 27,185 150,000 -------------------------------------------------------------------------** LEGAL SERVICES 199,611 165,955 150,000 99,606 27,185 150,000 ---------------------------------------------- ---------------------------*** GENERAL FUND 199,611 165,955 150,000 99,606 27,185 150,000 199,611 165,955 150,000 99,606 27,185 150,000 City Clerk.pdfBWPRINT/3/BWDEPTREQ_/259885/ATLBMAB/192.88.55.23/IAEST4/1200629/134505/379C/0318 PREPARED 06/29/20, 13:45:05 BUDGET PREPARATION WORKSHEET PAGE 1 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST GENERAL FUND CITY CLERK 001-1007-512.12-00 SALARIES 133,928 156,636 166,850 83,224 25,696 172,036 LEVEL TEXT TEXT AMT DEPT RECORDS CLERK 38480 X 3% ROUNDED 39,635 DEPUTY CITY CLERK 43680 X 3% 44,991 CITY CLERK 84864 X 3% 87,410 172,036 001-1007-512.14-00 OVERTIME 2,632 743 4,526 1,390 347 4,000 001-1007-512.15-00 SPECIAL PAY 2,586 1,027 2,664 0 0 0 001-1007-512.21-00 F.I.C.A. 10,398 11,511 13,315 6,145 1,923 13,467 001-1007-512.22-04 BENEFIT GROUP-GENERAL 10,889 12,742 10,963 6,395 914 11,292 001-1007-512.22-05 401 GENL DEF CONTR MATCH 1,093 0 2,165 532 379 2,230 001-1007-512.22-08 UNFUNDED LIABILITY-GEPP 46,561 46,565 44,326 18,469 0 44,326 001-1007-512.23-01 HEALTH 32,736 42,790 46,475 19,603 5,122 51,123 001-1007-512.23-02 LIFE 236 309 373 171 59 411 001-1007-512.24-00 WORKERS' COMPENSATION 207 281 292 83 26 301 001-1007-512.25-00 REEMPLOYMENT COMPENSATION 1,027 0 0 0 0 0 001-1007-512.31-00 PROFESSIONAL SERVICES 148 0 105 105 0 0 001-1007-512.34-00 OTHER CONTRACTUAL SERVS. 19,133 5,497 19,865 18,819 664 19,865 LEVEL TEXT TEXT AMT DEPT SHREDDING -MONTHLY CONTRACT (12*35) 420 SHREDDING -EXTRA BINS AND FUEL COSTS 250 SHREDDING -PURGE (APPROX. 11 BINS @$25 EACH) 275 CONTRACT EMPLOYEE -PART-TIME (1040 @$18) 18,720 MISCELLANEOUS CONTRACTUAL SERVICES 200 19,865 001-1007-512.40-00 TRAVEL AND PER DIEM 18 29 100 0 0 100 LEVEL TEXT TEXT AMT PREPARED 06/29/20, 13:45:05 BUDGET PREPARATION WORKSHEET PAGE 2 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST DEPT TRAVEL -CLERK OF COURTS, TAX COLLECTOR, ETC. 100 100 001-1007-512.41-00 COMMUNICATIONS 210 211 300 348 122 300 LEVEL TEXT TEXT AMT DEPT LOCAL PHONE SERVICE AND LONG DISTANCE SERVICE 300 300 001-1007-512.42-00 TRANSP.,POSTAGE,MESSENGER 36 31 250 129 15 150 LEVEL TEXT TEXT AMT DEPT SHIPPING/HANDLING/DELIVERY CHARGES 100 MISCELLANEOUS POSTAGE -NON-METERED 50 150 001-1007-512.46-00 REPAIRS & MAINTENANCE 6,375 17,499 11,858 38 0 12,608 LEVEL TEXT TEXT AMT DEPT MAINTENANCE/REPAIRS -SOUND SYSTEM, AUDIO/VIDEO 200 AGENDA MANAGEMENT SOFTWARE MAINTENANCE -ICOMPASS 6,750 RECORDS REQUEST PROGRAM -JUST FOIA -ANNUAL FEE 3,465 LASERFICHE INTERGRATION WITH JUSTFOIA -ANNUAL FEE 693 BOARD MANAGER -ICOMPASS -ANNUAL FEE 1,500 12,608 001-1007-512.47-00 PRINTING & PUBLISHING 18,007 18,418 22,042 11,696 1,550 22,042 LEVEL TEXT TEXT AMT DEPT LEGAL ADVERTISING -NOTICES/ORDINANCES 1,500 LAYOUT /EDITING OF NEWSLETTER -PRIDE ENTERPRISES 6,672 CODE SUPPLEMENTS W/FOLIO UPDATE (2) MUNICODE 7,000 CODE TO INTERNET (WEB HOSTING)-MUNICIPAL CODE 700 ORDINANCES ON WEB (ORDBANK)-MUNICIPAL CODE CORP. 525 ADMINISTRATIVE SUPPORT FEE-MUNICIPAL CODE CORP. 350 MULTIPLE CODE SEARCH (MUNIPRO) MUNICIPAL CODE 495 MISCELLANEOUS PRINTING LETTERHEADS,CARDS, 300 ELECTION AND REFERENDUM ADVERTISING -NOV 2020 2,000 ELECTION AND REFERENDUM BALLOT PRINTING-(IF SECOND 2,500 PAGE IS NEEDED) 22,042 001-1007-512.49-00 OTHER CURRENT CHARGES 86 187 400 369 0 500 PREPARED 06/29/20, 13:45:05 BUDGET PREPARATION WORKSHEET PAGE 3 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST LEVEL TEXT TEXT AMT DEPT RECORD DOCUMENTS(NOT SEWER)-ORDERS,LIENS, RELEASES 400 UNANTICIPATED NEEDS 100 500 001-1007-512.51-00 OFFICE SUPPLIES 1,432 861 1,095 0 0 1,300 LEVEL TEXT TEXT AMT DEPT CARTRIDGES -3 PRINTERS, ONE WITH FAX 700 MISCELLENEOUS OFFICE SUPPLIES 600 1,300 001-1007-512.52-00 OPERATING SUPPLIES 1,109 1,948 4,950 2,278 116 5,020 LEVEL TEXT TEXT AMT DEPT PRESENTATION PLAQUES AWARDS,RESOLUTIONS,PROCL 300 RECORDS STORAGE BINS AND SUPPLIES 200 EMPLOYEE PICNIC -FOOD, SUPPLIES, PRIZES 3,500 MISCELLANEOUS OPERATING SUPPLIES, NOT LISTED 900 NOTARY STAMP 120 5,020 001-1007-512.54-00 BOOK,SUBSCRIP,MEMBERSHIPS 270 170 835 295 0 835 LEVEL TEXT TEXT AMT DEPT BEACHES LEADER SUBSCRIPTION 35 FACC MEMBERSHIP-DONNA + LORI(AUG THRU JULY) 150 IIMC MEMBERSHIP-DONNA + LORI(OCT THRU SEPT) 340 FRMA MEMBERSHIP-INSTITUT IONAL MEMBERSHIP 160 MANUALS-SUNSHINE, ROBERT'S RULES, ETC. 100 CMC APPLICATION FEE-IIMC -INITIAL DEPOSIT 50 835 001-1007-512.55-00 TRAINING 1,043 471 4,794 1,899 125 4,794 LEVEL TEXT TEXT AMT DEPT FACC 2020 FALL ACADEMY-MILEAGE & MEALS 248 FACC 2021 FALL ACADEMY -REGISTRATION & HOTEL 1,145 FACC 2021 SUMMER ACADEMY-MILEAGE,MEALS,REG, HOTEL 1,455 MISCELLANEOUS TRAINING (RECORDS, CODE ENF., ETC.) 1,946 4,794 * 290,160 317,926 358,543 171,988 37,058 366,700 PREPARED 06/29/20, 13:45:05 BUDGET PREPARATION WORKSHEET PAGE 4 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST -------------------------------------------------------------------------** CITY CLERK 290,160 317,926 358,543 171,988 37,058 366,700 -------------------------------------------------------------------------*** GENERAL FUND 290,160 317,926 358,543 171,988 37,058 366,700 290,160 317,926 358,543 171,988 37,058 366,700 City Manager.pdfBWPRINT/3/BWDEPTREQ_/259869/ATLBMAB/192.88.55.23/IAEST4/1200629/134331/3984/0328 PREPARED 06/29/20, 13:43:31 BUDGET PREPARATION WORKSHEET PAGE 1 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST GENERAL FUND CITY MANAGER 001-1002-512.12-00 SALARIES 294,065 304,422 309,935 163,409 45,443 304,243 LEVEL TEXT TEXT AMT DEPT CITY MANAGER 125,008 + 3% ROUNDED UP 128,759 DEPUTY CITY MANAGER 113,547 + 3% 116,954 EXECUTIVE ASSISTANT 56,825.60 + 3% 58,530 304,243 001-1002-512.14-00 OVERTIME 0 0 0 246 0 250 001-1002-512.15-00 SPECIAL PAY 6,220 18,368 6,000 10,005 1,000 6,000 LEVEL TEXT TEXT AMT DEPT $500 X 12 6,000 6,000 001-1002-512.21-00 F.I.C.A. 23,618 23,992 24,235 13,553 3,680 24,890 001-1002-512.22-01 ICMA 401 16,499 16,411 25,409 8,008 2,223 26,171 001-1002-512.22-02 ICMA 457 9,938 10,325 9,702 6,263 1,747 9,994 001-1002-512.22-04 BENEFIT GROUP-GENERAL 7,402 5,666 4,870 2,841 406 5,016 001-1002-512.22-08 UNFUNDED LIABILITY-GEPP 15,312 21,578 20,540 8,558 0 20,540 001-1002-512.23-01 HEALTH 26,319 26,149 27,612 9,499 2,633 18,076 001-1002-512.23-02 LIFE 342 370 275 231 66 436 001-1002-512.24-00 WORKERS' COMPENSATION 1,995 2,537 1,442 1,041 288 1,485 001-1002-512.31-00 PROFESSIONAL SERVICES 26 0 1,000 0 0 1,000 001-1002-512.40-00 TRAVEL AND PER DIEM 0 0 1,000 34 0 1,000 001-1002-512.41-00 COMMUNICATIONS 1,651 2,223 1,000 772 338 1,728 LEVEL TEXT TEXT AMT DEPT RADIO AIR TIME 360 VERIZON WIRELESS (2 CELL PHONES) 1,104 JAX/ARLINGTON LOCAL CHARGES (COJ) 264 1,728 PREPARED 06/29/20, 13:43:31 BUDGET PREPARATION WORKSHEET PAGE 2 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST 001-1002-512.44-00 RENTALS & LEASES 0 0 0 217 0 220 001-1002-512.47-00 PRINTING & PUBLISHING 23 0 0 0 0 0 001-1002-512.49-00 OTHER CURRENT CHARGES 0 219 0 54 0 100 LEVEL TEXT TEXT AMT DEPT MISCELLANEOUS FLOWER DELIVERIES 100 100 001-1002-512.51-00 OFFICE SUPPLIES 6 17 50 0 0 50 001-1002-512.52-00 OPERATING SUPPLIES 992 2,436 1,600 2,249 0 2,000 LEVEL TEXT TEXT AMT DEPT COMPUTER/PRINTER SUPPLIES 1,500 LOGO SHIRTS 500 2,000 001-1002-512.54-00 BOOK,SUBSCRIP,MEMBERSHIPS 3,474 2,324 4,300 5,187 0 4,100 LEVEL TEXT TEXT AMT DEPT FCCMA MEMBERSHIP 375 NOTARY RENEWAL 112 NEFLC DINNER MEETINGS 10 X 25 250 AWRA FL MEMBERSHIP (SWANN) 25 AMERICAN PLANNING ASSOCIATION SUBSCRIPTION 95 AMERICAN PLANNING ASSOCIATION MEMBERSHIP 692 BEACHES LEADER SUBSCRIPTION 60 JACKSONVILLE CHAMBER MEMBERSHIP 500 NEFLC MEMBERSHIP 100 FLORIDA LEAGUE OF CITIES MEMBERSHIP 1,770 ALLOWANCE FOR INCREASES 121 4,100 001-1002-512.55-00 TRAINING 1,190 1,114 2,400 2,603 139 2,800 LEVEL TEXT TEXT AMT DEPT FMCA CONFERENCE 495 FCCMA CONFERENCE 495 HOTELS AND PER DIEM 1,000 MISCELLANEOUS SEMINARS 810 2,800 PREPARED 06/29/20, 13:43:31 BUDGET PREPARATION WORKSHEET PAGE 3 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST 001-1002-512.64-02 COMPUTER EQUIPMENT 0 0 853 848 0 0 * 409,072 438,151 442,223 235,618 57,963 430,099 -------------------------------------------------------------------------** CITY MANAGER 409,072 438,151 442,223 235,618 57,963 430,099 ----------------------- --------------------------------------------------*** GENERAL FUND 409,072 438,151 442,223 235,618 57,963 430,099 409,072 438,151 442,223 235,618 57,963 430,099 Code Enforcement.pdfBWPRINT/3/BWDEPTREQ_/259882/ATLBMAB/192.88.55.23/IAEST4/1200629/134450/3688/031C PREPARED 06/29/20, 13:44:50 BUDGET PREPARATION WORKSHEET PAGE 1 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST GENERAL FUND CODE ENFORCEMENT 001-1006-524.12-00 SALARIES 17,841 42,875 48,770 24,838 6,922 46,341 LEVEL TEXT TEXT AMT DEPT CODE ENFORCEMENT OFFICER 44990.4 X 3% ROUNDED 46,341 46,341 001-1006-524.14-00 OVERTIME 0 224 500 0 0 500 001-1006-524.15-00 SPECIAL PAY 0 291 0 1,257 346 2,250 LEVEL TEXT TEXT AMT DEPT 86.52 X 26 PAY PERIODS (ROUNDED) 2,250 2,250 001-1006-524.21-00 F.I.C.A. 1,330 3,193 3,770 1,883 518 3,756 001-1006-524.22-05 401 GENL DEF CONTR MATCH 0 640 3,441 783 218 3,545 001-1006-524.22-08 UNFUNDED LIABILITY-GEPP 9,050 12,752 12,139 5,058 0 12,139 001-1006-524.23-01 HEALTH 2,461 5,532 7,936 4,337 1,242 8,730 001-1006-524.23-02 LIFE 38 101 132 69 20 132 001-1006-524.24-00 WORKERS' COMPENSATION 277 824 869 352 98 896 001-1006-524.31-00 PROFESSIONAL SERVICES 0 105 0 0 0 0 001-1006-524.34-00 CONTRACTUAL SERVICES 43 0 24,000 1,053 0 24,000 001-1006-524.41-00 COMMUNICATIONS 1,038 921 700 500 162 1,032 LEVEL TEXT TEXT AMT DEPT VERIZON WIRELESS 86 X 12 1,032 1,032 001-1006-524.46-00 REPAIR & MAINTENANCE 0 8 0 0 0 0 001-1006-524.47-00 PRINTING & PUBLISHING 91 0 0 0 0 0 001-1006-524.51-00 OFFICE SUPPLIES 54 0 100 0 3 100 001-1006-524.52-00 OPERATING SUPPLIES 2,233 1,306 750 24 176 750 PREPARED 06/29/20, 13:44:50 BUDGET PREPARATION WORKSHEET PAGE 2 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST 001-1006-524.52-01 GASOLINE 198 206 250 190 23 250 001-1006-524.54-00 BOOK,SUBSCRIP,MEMBERSHIPS 55 0 75 70 0 75 001-1006-524.55-00 TRAINING 0 1,854 3,000 0 0 3,000 * 34,709 70,832 106,432 40,414 9,728 107,496 ----------------------------------------------------------- --------------** CODE ENFORCEMENT 34,709 70,832 106,432 40,414 9,728 107,496 -------------------------------------------------------------------------*** GENERAL FUND 34,709 70,832 106,432 40,414 9,728 107,496 34,709 70,832 106,432 40,414 9,728 107,496 Commission.pdfBWPRINT/3/BWDEPTREQ_/259847/ATLBMAB/192.88.55.23/IAEST4/1200629/134149/38E8/0324 PREPARED 06/29/20, 13:41:49 BUDGET PREPARATION WORKSHEET PAGE 1 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST GENERAL FUND COMMISSION 001-1001-511.12-00 SALARIES 33,831 34,556 35,349 18,619 5,855 36,183 LEVEL TEXT TEXT AMT DEPT MAYOR 10,228.32 + 3% (ROUNDED) 10,535 COMMISSIONERS 6,225.24 + 3% X 4 ROUNDED 25,648 36,183 001-1001-511.21-00 F.I.C.A 2,588 2,644 2,705 1,424 448 2,768 001-1001-511.24-00 WORKERS' COMPENSATION 66 77 172 25 8 178 001-1001-511.40-00 TRAVEL AND PER DIEM 0 0 4,000 0 0 0 001-1001-511.47-00 PRINTING & PUBLISHING 1,982 23 500 0 0 500 001-1001-511.52-00 OPERATING SUPPLIES 0 25 150 75 25-150 001-1001-511.54-00 BOOK,SUBSCRIP,MEMBERSHIPS 250 475 450 354 0 450 001-1001-511.55-00 TRAINING 4,749 2,408 6,350 1,218 0 6,000 LEVEL TEXT TEXT AMT DEPT INSTITUTE FOR ELECTED OFFICIALS 282.50 X 5 1,413 ANNUAL FLC CONFERENCE REGISTRATION 600 HOTELS 3,168 PER DIEM/PARKING/MILEAGE 819 6,000 001-1001-511.81-00 AIDS TO GOVERNMENT AGENCS 0 0 6,200 6,000 0 6,000 * 43,466 40,208 55,876 27,715 6,286 52,229 -------------------------------------------------------------------------** COMMISSION 43,466 40,208 55,876 27,715 6,286 52,229 -------------------------------------------------------------------------*** GENERAL FUND 43,466 40,208 55,876 27,715 6,286 52,229 43,466 40,208 55,876 27,715 6,286 52,229 Finance.pdfBWPRINT/3/BWDEPTREQ_/259874/ATLBMAB/192.88.55.23/IAEST4/1200629/134345/1318/0310 PREPARED 06/29/20, 13:43:45 BUDGET PREPARATION WORKSHEET PAGE 1 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST GENERAL FUND FINANCE 001-1003-513.12-00 SALARIES 475,039 566,426 624,662 337,381 97,990 658,103 LEVEL TEXT TEXT AMT DEPT UTILITY BILLING SUPERVISOR 56825.60 +3% 58,530 CUSTOMER SERVICE REP + 3% X 2 60,051 UTILITY BILLING SPECIALIST 36046.40 + 3% 37,128 CUSTOMER SERVICE SUPERVISOR 58073.60 + 3% 59,816 PROCUREMENT MANAGER 59259.20 + 3% 61,037 DIRECTOR OF FINANCE 111,238.40 +3% 114,576 METER READER 89,668.80 +3% 92,359 ACCOUNTANT 54080 + 3% 55,702 DEPUTY FINANCE DIRECTOR 79747.20 + 3% 82,140 FINANCE ASSOCIATE 35692.80 + 3% 36,764 658,103 001-1003-513.14-00 OVERTIME 15,316 13,650 10,000 7,372 1,282 10,000 001-1003-513.15-00 SPECIAL PAY 363 8,361 0 0 191 0 001-1003-513.21-00 F.I.C.A. 35,904 43,049 48,099 25,512 7,346 51,245 001-1003-513.22-04 BENEFIT GROUP-GENERAL 24,686 31,708 27,276 15,911 2,273 28,094 001-1003-513.22-05 401 GENL DEF CONTR MATCH 7,189 7,095 8,000 5,452 1,913 8,000 001-1003-513.22-08 UNFUNDED LIABILITY-GEPP 127,852 123,529 117,588 48,995 0 117,588 001-1003-513.23-01 HEALTH 91,567 89,922 93,775 56,825 17,407 103,153 001-1003-513.23-02 LIFE 872 1,160 1,052 764 230 1,157 001-1003-513.24-00 WORKERS' COMPENSATION 1,940 5,824 2,984 2,237 683 3,074 001-1003-513.31-00 PROFESSIONAL SERVICES 154 240 0 210 0 0 001-1003-513.32-00 ACCOUNTING & AUDITING 53,000 29,899 49,500 1,240-30,000 54,450 001-1003-513.34-00 OTHER CONTRACTUAL SERVS. 19,939 13,025 29,200 17,152 8,218 30,000 001-1003-513.40-00 TRAVEL AND PER DIEM 142 0 500 0 0 1,000 001-1003-513.41-00 COMMUNICATIONS 1,309 1,394 3,500 1,705 583 2,280 LEVEL TEXT TEXT AMT PREPARED 06/29/20, 13:43:45 BUDGET PREPARATION WORKSHEET PAGE 2 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST DEPT VERIZON WIRELESS 95 X 12 1,140 JAX/ARLINGTON LOCAL CHARGES 95 X 12 1,140 2,280 001-1003-513.42-00 TRANSP.,POSTAGE,MESSENGER 39,546 47,574 44,975 36,679 7,421 49,400 LEVEL TEXT TEXT AMT DEPT POSTAGE FOR UTILITY BILLS 4100 AVG X 12 49,200 POSTAGE PERMIT 200 49,400 001-1003-513.44-00 RENTALS & LEASES 0 0 500 196 91 180 LEVEL TEXT TEXT AMT DEPT METER READER UNIFORM RENTAL $15 X12 180 180 001-1003-513.46-00 REPAIR & MAINTENANCE 0 0 1,000 0 42 1,000 LEVEL TEXT TEXT AMT DEPT MISCELLANEOUS SUPPLIES FOR METER READERS 1,000 1,000 001-1003-513.47-00 PRINTING & PUBLISHING 19,176 19,467 20,000 17,366 2,510 20,000 LEVEL TEXT TEXT AMT DEPT UTILITY BILL PRINTING 20,000 20,000 001-1003-513.51-00 OFFICE SUPPLIES 2,286 2,906 2,500 1,103 752 2,500 001-1003-513.52-00 OPERATING SUPPLIES 9,324 7,743 7,000 5,958 426 7,000 LEVEL TEXT TEXT AMT DEPT COMPUTER ACCESSORIES AND SUPPLIES 5,000 OFFICE AND OTHER SUPPLIES 2,000 7,000 001-1003-513.54-00 BOOK,SUBSCRIP,MEMBERSHIPS 250 634 3,000 549 0 1,830 LEVEL TEXT TEXT AMT DEPT FGFOA MEMBERSHIP $50X3 150 PREPARED 06/29/20, 13:43:45 BUDGET PREPARATION WORKSHEET PAGE 3 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST GFOA MEMBERSHIP (2) 340 FIRST COAST CHAPTER FGFOA $20 X 2 40 BEACHES LEADER SUBSCRIPTION 35 NATIONAL PROCUREMENT ASSOCIATION 190 NORTH FLORIDA PROCUREMENT ASSOCIATION 25 GAAFR SUBSCRIPTION 50 FINANCE PUBLICATIONS (BLUE BOOK & MISC) 500 PROCUREMENT PUBLICATIONS 500 1,830 001-1003-513.55-00 TRAINING 2,320 6,675 5,000 4,004 0 9,625 LEVEL TEXT TEXT AMT DEPT FGFOA SCHOOL OF GOVERNMENT FINANCE 300 X 3 900 FGFOA ANNUAL CONFERENCE 485 X 3 1,455 HOTELS FOR ABOVE 845 X 6 5,070 PER DIEM 1,000 MISCELLANEOUS TRAINING 1,200 9,625 001-1003-513.64-02 COMPUTER EQUIPMENT 0 0 3,190 3,179 0 0 * 928,174 1,020,281 1,103,301 587,310 179,358 1,159,679 -------------------------------------------------------------------------** FINANCE 928,174 1,020,281 1,103,301 587,310 179,358 1,159,679 ------------------------------------------ -------------------------------*** GENERAL FUND 928,174 1,020,281 1,103,301 587,310 179,358 1,159,679 928,174 1,020,281 1,103,301 587,310 179,358 1,159,679 General Government.pdfBWPRINT/3/BWDEPTREQ_/259889/ATLBMAB/192.88.55.23/IAEST4/1200629/134524/3D40/0324 PREPARED 06/29/20, 13:45:24 BUDGET PREPARATION WORKSHEET PAGE 1 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST GENERAL FUND GENERAL GOVERNMENT 001-1009-519.12-00 SALARIES 12,841 13,905 9,889 8,838 2,465 23,857 LEVEL TEXT TEXT AMT DEPT OPERATIONS SUPERVISOR 47361.60 + 3% X 20% ROUNDED 9,757 RECEPTIONIST 29,577.60 + 3% X 20% 6,130 BUILDING PERMIT TECHNICIAN + 3% X 20% 7,970 23,857 001-1009-519.14-00 OVERTIME 301 50 0 0 17 0 001-1009-519.15-00 SPECIAL PAY 554 270 0 0 0 0 001-1009-519.21-00 F.I.C.A. 1,008 1,059 757 658 184 1,826 001-1009-519.22-04 BENEFIT GROUP-GENERAL 0 0 721 421 60 742 001-1009-519.22-05 401 GENL DEF CONTR MATCH 431 551 1,939 335 93 1,945 001-1009-519.22-08 UNFUNDED LIABILITY-GEPP 2,457 2,574 2,450 1,021 0 2,524 001-1009-519.23-01 HEALTH 2,767 2,672 2,669 2,019 569 2,936 001-1009-519.23-02 LIFE 30 35 23 25 7 26 001-1009-519.24-00 WORKERS' COMPENSATION 20 25 16 9 2 17 001-1009-519.31-00 PROFESSIONAL SERVICES 19,013 85,724 70,000 54,000 10,500 70,000 LEVEL TEXT TEXT AMT DEPT STATE LOBBYIST SERVICES 45,500 SPECIAL MAGISTRATE SERVICES 24,500 70,000 001-1009-519.34-00 OTHER CONTRACTUAL SERVICE 83,062 81,146 49,250 43,088 3,695 50,000 LEVEL TEXT TEXT AMT DEPT GRANT WRITING SERVICES 40,800 PEST CONTROL 1,200 OTHER MISCELLANEOUS SERVICES 8,000 50,000 001-1009-519.41-00 COMMUNICATIONS 177 564 685 296 43 424 PREPARED 06/29/20, 13:45:24 BUDGET PREPARATION WORKSHEET PAGE 2 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST LEVEL TEXT TEXT AMT DEPT COMCAST 18.48 X 12 222 JAX/ARLINGTON LOCAL CHARGES 16.78 X 12 202 424 001-1009-519.42-00 TRANSP.POSTAGE,MESSENGER 8,299 5,498 12,000 7,945 2,055 10,000 001-1009-519.43-00 UTILITIES 17,933 18,653 18,000 9,171 1,031 18,000 001-1009-519.43-01 CITY PROVIDED 6,292 6,197 6,000 4,969 1,447 6,000 001-1009-519.44-00 RENTALS & LEASES 2,120 3,404 3,834 3,832 0 3,833 LEVEL TEXT TEXT AMT DEPT POSTAGE MACHINE LEASE 319.36X12 3,833 3,833 001-1009-519.45-00 INSURANCE 174,243 189,819 172,915 145,763 0 172,915 001-1009-519.46-00 REPAIR & MAINTENANCE 12,449 8,041 10,916 9,088 779 13,000 LEVEL TEXT TEXT AMT DEPT SOUTH END COPIER COPY CHARGES 5,600 NORTH END COPIER COPY CHARGES 2,300 MISCELLANEOUS BUILDING REPAIRS 5,100 13,000 001-1009-519.47-00 PRINTING & PUBLISHING 733 9,176 750 359 537 750 001-1009-519.49-00 OTHER CURRENT CHARGES 5,993 1,295 500 0 0 1,300 LEVEL TEXT TEXT AMT DEPT ANNUAL BOARD & COMMITTEE MEMBER RECEPTION 1,300 1,300 001-1009-519.49-01 CULTURAL ARTS BOARD 0 0 0 0 0 2,000 001-1009-519.51-00 OFFICE SUPPLIES 2,116 2,403 3,000 1,282 372 3,000 001-1009-519.52-00 OPERATING SUPPLIES 8,549 14,402 9,500 6,710 2,334 10,000 LEVEL TEXT TEXT AMT DEPT COFFEE SERVICE PREPARED 06/29/20, 13:45:24 BUDGET PREPARATION WORKSHEET PAGE 3 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST EMPLOYEE LUNCHEONS MISCELLANEOUS SUPPLIES 001-1009-519.54-00 BOOK,SUBSCRIP,MEMBERSHIPS 0 1,500 1,100 1,000 0 1,100 001-1009-519.64-00 MACHINERY & EQUIPMENT 0 1,274 140,110 0 0 0 * 361,388 450,237 517,024 300,829 26,190 396,195 -------------------------------- -----------------------------------------** GENERAL GOVERNMENT 361,388 450,237 517,024 300,829 26,190 396,195 -------------------------------------------------------------------------*** GENERAL FUND 361,388 450,237 517,024 300,829 26,190 396,195 361,388 450,237 517,024 300,829 26,190 396,195 HR.pdfBWPRINT/3/BWDEPTREQ_/259892/ATLBMAB/192.88.55.23/IAEST4/1200629/134544/0FB8/0308 PREPARED 06/29/20, 13:45:44 BUDGET PREPARATION WORKSHEET PAGE 1 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST GENERAL FUND HUMAN RESOURCES 001-1010-513.12-00 SALARIES 144,799 148,902 152,775 84,281 23,459 157,060 LEVEL TEXT TEXT AMT DEPT HUMAN RESOURCE DIRECTOR 95659.20 + 3% 98,529 HUMAN RESOURCE ASSISTANT 56825.60 + 3% 58,531 157,060 001-1010-513.15-00 SPECIAL PAY 2,855 3,057 1,000 1,674 487 3,167 LEVEL TEXT TEXT AMT DEPT 121.78 X 26 PAY PERIODS 3,167 3,167 001-1010-513.21-00 F.I.C.A. 10,658 11,064 11,764 6,166 1,709 11,975 001-1010-513.22-04 BENEFIT GROUP-GENERAL 7,436 5,807 4,999 2,916 417 5,149 001-1010-513.22-05 401 GENL DEF CONTR MATCH 5,425 5,588 5,475 3,169 883 5,640 001-1010-513.22-08 UNFUNDED LIABILITY-GEPP 34,864 34,009 32,373 13,489 0 32,373 001-1010-513.23-01 HEALTH 12,267 24,114 30,333 16,882 4,728 33,367 001-1010-513.23-02 LIFE 228 249 276 154 44 304 001-1010-513.24-00 WORKERS' COMPENSATION 221 270 264 86 24 272 001-1010-513.34-00 OTHER CONTRACTUAL SERVS. 4,170 4,191 5,000 2,933 50 5,000 001-1010-513.41-00 COMMUNICATIONS 448 441 400 412 80 400 001-1010-513.42-00 TRANSP.,POSTAGE,MESSENG ER 0 0 100 0 10 100 001-1010-513.51-00 OFFICE SUPPLIES 1,253 981 1,300 709 261 1,300 001-1010-513.52-00 OPERATING SUPPLIES 1,676 1,647 1,500 1,679 0 1,500 001-1010-513.54-00 BOOK,SUBSCRIP,MEMBERSHIPS 509 933 590 156 33 590 001-1010-513.55-00 TRAINING 1,534 847 2,000 0 0 2,000 * 228,343 242,100 250,149 134,706 32,185 260,197 ------------------------------------------------------------------------ -** HUMAN RESOURCES 228,343 242,100 250,149 134,706 32,185 260,197 PREPARED 06/29/20, 13:45:44 BUDGET PREPARATION WORKSHEET PAGE 2 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST -------------------------------------------------------------------------*** GENERAL FUND 228,343 242,100 250,149 134,706 32,185 260,197 228,343 242,100 250,149 134,706 32,185 260,197 IT.pdfBWPRINT/3/BWDEPTREQ_/259819/ATLBMAB/192.88.55.23/IAEST4/1200629/134025/1A38/0310 PREPARED 06/29/20, 13:40:25 BUDGET PREPARATION WORKSHEET PAGE 1 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST GENERAL FUND INFO TECHNOLOGY 001-1011-516.12-00 SALARIES 198,062 166,599 140,885 77,774 21,674 145,105 LEVEL TEXT TEXT AMT DEPT SENIOR SYSTEMS ENGINEER X 2 140,878.40 + 3% 145,105 145,105 001-1011-516.14-00 OVERTIME 11,580 10,563 8,000 10,090 2,452 11,000 001-1011-516.15-00 SPECIAL PAY 903 21,242 800 0 0 800 001-1011-516.21-00 F.I.C.A. 15,926 15,011 11,451 6,641 1,821 12,004 001-1011-516.22-04 BENEFIT GROUP-GENERAL 19,983 20,902 17,980 10,488 1,498 18,520 001-1011-516.22-08 UNFUNDED LIABILITY-GEPP 21,940 14,458 13,763 5,735 0 14,176 001-1011-516.23-01 HEALTH 21,974 18,527 14,742 8,937 2,571 16,216 001-1011-516.23-02 LIFE 341 319 350 154 44 385 001-1011-516.24-00 WORKERS' COMPENSATION 314 352 382 86 24 394 001-1011-516.34-00 OTHER CONTRACTUAL SERVS. 23,059 13,336 31,710 727 365 31,727 LEVEL TEXT TEXT AMT DEPT WEB SITE CHANGES 15,000 PHONE SYSTEM CONSULTING 3,000 FIREWALL PROGRAMMING 4,000 ROUTER SWITCH PROGRAMMING 6,727 DATABASE PROGRAMMING 3,000 31,727 001-1011-516.40-00 TRAVEL AND PER DIEM 265 237 600 271 0 571 001-1011-516.41-00 COMMUNICATIONS 63,873 64,221 75,500 54,187 10,180 79,454 LEVEL TEXT TEXT AMT DEPT WINDSTREAM T1 5,400 COMCAST 100M 28,800 COMCAST PRI PD 4,500 COMCAST PRI COLOGIX 3,800 WINDSTREAM 10M CIRCUIT 12965495 6,378 COMCAST PD TO ADELE 2,038 PREPARED 06/29/20, 13:40:25 BUDGET PREPARATION WORKSHEET PAGE 2 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST WINDSTREAM 10M CIRCUIT 13490917 9,000 LANDLINES 2,500 CELL PHONES 2,000 ONETALK 2,500 DEDICATED CIRCUIT -CH TO COLOGIX 50M 8,000 COMCAST INTERNET SERVICE 50M 2,500 INTERNET -COLOGIX 10M 2,038 79,454 001-1011-516.42-00 TRANSP.,POSTAGE,MESSENGER 64 94 250 0 0 0 001-1011-516.44-00 RENTAL AND LEASES 17,522 18,046 22,000 15,454 3,086 22,579 LEVEL TEXT TEXT AMT DEPT COLOGIX COLO SITE (PRICE INCREASE) 22,579 22,579 001-1011-516.46-00 REPAIR & MAINTENANCE 242,491 257,355 332,390 209,401 55,126 319,489 LEVEL TEXT TEXT AMT DEPT DELL SERVER MAINTENANCE 14,000 BARRACUDE WEB FILTER MAINT 997 -SPAM FILTER MAINTENANCE 1,550 -EMAIL ARCHIVE SERVER MAINTENANCE 4,676 -BACKUP SERVERS (2) MAINTENANCE 8,407 CIVIC PLUS-WEBSITE HOSTING 12,346 SYMNATEC VIRUS LICENSE 4,185 LASERFISCHE ANNUAL LICENSE 9,725 BELARC-SERVICE AND DESKTOP INVENTORY LICENSE 1,114 AMAG BADGET SECURITY LICENSE 2,700 SWAGIT-VIDEO HOSTING 63,690 SUPERION HTE, TRAKIT LICENSE/HOSTING (12*$11,100) 139,214 VMWARE LICESNES-VIRTEKS 1,544 VMWARE SUPPORT-VIRTEKS 2,826 SMARSH LICENSE 5,263 VERTEKS PHONE SYSTEM MAINTENANCE 1,938 BROWNRICE VIDEO SERVER 300 BOMGAR REMOTE SERVICE (BEYONE TRUST) 2,266 ARCHIVESOCIAL SOCAL MEDIA BACKUP 4,784 SOLARWINDS-LOG AND EVENT MANAGER 1,023 -NETWORK PERFORMANCE MANAGER 1,464 -NETFLOW TRAFFIC ANALYZER 971 -ENGINEER'S TOOLSET 451 -HELP DESK APP 396 -APPLICATION AND SERVER MONITOR 1,279 -DAMEWARE REMOTE AGENT 213 PREPARED 06/29/20, 13:40:25 BUDGET PREPARATION WORKSHEET PAGE 3 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST NETMOTION LICENSE 871 CONVERGINT: READERS/DOORS/ET 13,895 SOUND SYSTEM/DATA CABLE INSTALLS/REPAIRS 751 PDQ SOFTWARE DEPLOY 1,000 MALWAREBYTES DESKTOP VIRUS SOFTWARE 7,738 KNOWB4 3,029 TEAMVIEWER REMOTE ACCESS SOFTWARE 1,000 SITEIMPROVE WEBSITE COMPLIANCE SOFTWARE 2,100 ALARM MAINTENANCE -AP SYSTEMS 1,783 319,489 001-1011-516.46-01 FIRST VEHICLES/EQUIPMENT 0 0 400 0 0 0 001-1011-516.47-00 PRINTING & PUBLISHING 0 0 100 90 0 0 001-1011-516.51-00 OFFICE SUPPLIES 59 312 289 0 0 0 001-1011-516.52-00 OPERATING SUPPLIES 55,670 26,862 44,500 4,076 968 65,843 LEVEL TEXT TEXT AMT DEPT REPLACEMENT PHONES 1,000 REPLACEMENT MONITORS/CABLES 1,686 LAPTOPS 23,179 REPLACEMENT DESKTOPS 20,000 REPLACEMENT WIRELESS KEYBOARDS/MICE 1,491 VIDEO ADAPTORS 473 SOFTWARE LICENSES (ACROBAT,PHOTOSHOP,OFFICE) 5,000 DOG PARK BADGES 5,000 REPLACEMENT UPS'S 2,807 REPLACEMENT SCANNERS 5,207 65,843 001-1011-516.52-01 GASOLINE 247 0 500 0 0 500 001-1011-516.54-00 BOOK,SUBSCRIP,MEMBERSHIPS 269 260 1,000 200 0 200 001-1011-516.55-00 TRAINING 4,684 3,006 5,000 1,928 0 6,957 LEVEL TEXT TEXT AMT DEPT ONLINE COURSE SUBSCRIPTION 1,928 FLGISA CONFERENCE 2,000 END USER SECURITY AWARENESS TRAINING 3,029 6,957 001-1011-516.64-02 COMPUTER EQUIPMENT 71,694 28,522 60,000 10,870 0 60,822 PREPARED 06/29/20, 13:40:25 BUDGET PREPARATION WORKSHEET PAGE 4 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST LEVEL TEXT TEXT AMT DEPT VIRTUAL SERVER REPLACEMENT 35,000 REPLACE END OF LIFE NETWORK SWITCHES 21,000 REPLACEMENT KVM -CITY HALL AND PD 4,822 60,822 * 770,920 680,224 782,592 417,109 99,809 806,742 ------------------------------------------------------------------ -------** INFO TECHNOLOGY 770,920 680,224 782,592 417,109 99,809 806,742 -------------------------------------------------------------------------*** GENERAL FUND 770,920 680,224 782,592 417,109 99,809 806,742 770,920 680,224 782,592 417,109 99,809 806,742 Planning.pdfBWPRINT/3/BWDEPTREQ_/259878/ATLBMAB/192.88.55.23/IAEST4/1200629/134422/38E8/0324 PREPARED 06/29/20, 13:44:22 BUDGET PREPARATION WORKSHEET PAGE 1 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST GENERAL FUND PLANNING & ZONING 001-1005-515.12-00 SALARIES 158,635 212,741 249,035 97,400 26,192 230,180 LEVEL TEXT TEXT AMT DEPT ADMINISTRATIVE ASSISTANT 37502.40 X 3% ROUNDED 38,628 PLANNING DIRECTOR 89668.8 X 3% 92,359 PRINCIPAL PLANNER 53872 X 3% 55,488 PLANNER 43,705 230,180 001-1005-515.14-00 OVERTIME 1,564 1,731 900 0 0 500 001-1005-515.15-00 SPECIAL PAY 6,222 6,065 2,500 1,490 414 2,697 LEVEL TEXT TEXT AMT DEPT 103.60 X 26 ROUNDED 2,697 2,697 001-1005-515.21-00 F.I.C.A. 12,532 16,566 19,312 7,421 1,965 17,855 001-1005-515.22-04 BENEFIT GROUP-GENERAL 0 0 3,808 2,221 317 3,923 001-1005-515.22-05 401 GENL DEF CONTR MATCH 5,718 6,104 5,676 4,939 1,394 5,846 001-1005-515.22-08 UNFUNDED LIABILITY-GEPP 8,879 12,512 11,910 4,963 0 11,910 001-1005-515.23-01 HEALTH 22,536 26,133 15,873 12,173 3,515 17,460 001-1005-515.23-02 LIFE 301 353 300 163 46 300 001-1005-515.24-00 WORKERS' COMPENSATION 2,493 14,867 1,700 1,162 309 1,751 001-1005-515.31-00 PROFESSIONAL SERVICES 16,643 133,590 0 0 0 0 001-1005-515.34-00 OTHER CONTRACTUAL SERVICE 26,247 3,808 30,000 1,463 0 30,000 001-1005-515.41-00 COMMUNICATIONS 186 543 800 604 263 1,800 LEVEL TEXT TEXT AMT DEPT VERIZON WIRELESS 150 X 12 1,800 1,800 001-1005-515.46-00 REPAIR & MAINTENANCE 0 0 7,650 0 0 7,650 PREPARED 06/29/20, 13:44:22 BUDGET PREPARATION WORKSHEET PAGE 2 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST 001-1005-515.47-00 PRINTING & PUBLISHING 8,216 5,500 15,000 4,761 492 15,000 001-1005-515.51-00 OFFICE SUPPLIES 363 216 350 27 19 350 001-1005-515.52-00 OPERATING SUPPLIES 710 998 2,000 1,292 46 2,000 001-1005-515.52-01 GASOLINE 176 252 250 60 0 250 001-1005-515.54-00 BOOK,SUBSCRIP,MEMBERSHIPS 391 804 1,200 496 0 1,200 001-1005-515.55-00 TRAINING 2,808 2,635 6,500 299 0 6,500 * 274,620 445,418 374,764 140,934 34,972 357,172 -------------------- -----------------------------------------------------** PLANNING & ZONING 274,620 445,418 374,764 140,934 34,972 357,172 -------------------------------------------------------------------------*** GENERAL FUND 274,620 445,418 374,764 140,934 34,972 357,172 274,620 445,418 374,764 140,934 34,972 357,172 PW-Admin-Rds and Sts-Equip Maint.pdfBWPRINT/3/BWDEPTREQ_/259982/ATLBMAB/192.88.55.23/IAEST4/1200629/135607/27EC/0324 PREPARED 06/29/20, 13:56:07 BUDGET PREPARATION WORKSHEET PAGE 1 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST GENERAL FUND PUBLIC WKS ADMINISTRATION 001-5001-541.12-00 SALARIES 206,389 230,650 275,968 134,892 37,869 290,761 LEVEL TEXT TEXT AMT DEPT PUBLIC WORKS DIRECTOR 91,740.40 +3% X 20% 18,909 CITY ENGINEER 102,336 +3% X 25% 26,352 DISPATCHER 44,096 +3% 45,419 ADMINISTRATIVE COORDINATOR 42,473.60 + 3% 43,748 CLERICAL ASSISTANT PT 29,640 +3% 30,530 CONTRACTS,NPEDS & ADMIN COORD 70,033.60 +3% 72,135 PUBLIC WORKS INSPECTOR 52,104 + 3% 53,668 290,761 001-5001-541.14-00 OVERTIME 530 1,962 500 188 0 500 001-5001-541.15-00 SPECIAL PAY 1,568 3,844 4,500 2,250 485 3,152 LEVEL TEXT TEXT AMT DEPT SWANN 121.20 PER PAY PERIOD 3,152 3,152 001-5001-541.21-00 F.I.C.A. 15,599 17,656 21,495 10,203 2,838 23,166 001-5001-541.22-04 BENEFIT GROUP-GENERAL 14,710 20,150 17,330 10,109 1,444 17,850 001-5001-541.22-05 401 GENL DEF CONTR MATCH 5,049 4,854 13,298 2,963 1,029 13,697 001-5001-541.22-08 UNFUNDED LIABILITY-GEPP 60,641 71,415 67,981 28,325 0 67,981 001-5001-541.23-01 HEALTH 30,409 32,613 64,718 20,545 5,788 71,190 001-5001-541.23-02 LIFE 402 472 525 305 88 525 001-5001-541.24-00 WORKERS' COMPENSATION 1,637-2,259 4,331 960 275 4,461 001-5001-541.25-00 REEMPLOYMENT COMPENSATION 1,527 0 0 0 0 0 001-5001-541.31-00 PROFESSIONAL SERVICES 6,353 8,647 20,000 5,584 1,778 105,000 LEVEL TEXT TEXT AMT DEPT MISC. PROFESSIONAL SERVICES TO INCLUDE GENERAL ENGINEERING CONSULTANTS AND SURVEYING 20,000 ENGINEERING DESIGN OF NEW PUBLIC WORKS BUILDING 55,000 16TH STREET BEACH WALKOVER ENGINEERINIG 30,000 PREPARED 06/29/20, 13:56:07 BUDGET PREPARATION WORKSHEET PAGE 2 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST 105,000 001-5001-541.34-00 OTHER CONTRACTUAL SERVS. 425 3,341 5,100 2,783 22 5,100 LEVEL TEXT TEXT AMT DEPT PEST CONTROL/TERMITE BOND ONLY 300 EXTERMINATOR 900 SECURITY SYSTEM MONITORING FEE ($75.00/MONTH) 900 STATE MANDATED LOCATE SERVICES 3,000 5,100 001-5001-541.40-00 TRAVEL AND PER DIEM 211 244 700 26 0 1,000 LEVEL TEXT TEXT AMT DEPT PRIVATE VEHICLE MILEAGE REIMBURSEMENT 1,000 1,000 001-5001-541.41-00 COMMUNICATIONS 9,639 10,072 11,280 6,269 1,351 11,780 LEVEL TEXT TEXT AMT DEPT LOCAL AND LONG DISTANCE PHONE SERVICE 3,000 CELL PHONES (4) PW ADMIN. 2,500 ANSWERING SERVICE 2,200 MONTHLY RADIO FEES $60/MONTH X 12 X 5 POSITIONS 3,600 MONTHLY AIR CARD FEE $40/MONTH X 12 480 11,780 001-5001-541.42-00 TRANSP.,POSTAGE,MESSENGER 5 0 100 7 0 100 LEVEL TEXT TEXT AMT DEPT MISC. FED EX AND COURIER 100 100 001-5001-541.46-00 REPAIR & MAINTENANCE 1,175 2,005 6,700 3,637 74 2,700 LEVEL TEXT TEXT AMT DEPT MISC. CLEANING AND PAINTING 700 YEARLY MAINTENANCE FOR SCANNER/COPIER 1,500 ICE MACHINE MAINTENANCE AND REPAIR 500 2,700 001-5001-541.47-00 PRINTING & PUBLISHING 557 285 1,000 178 0 1,000 PREPARED 06/29/20, 13:56:07 BUDGET PREPARATION WORKSHEET PAGE 3 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST LEVEL TEXT TEXT AMT DEPT BUSINESS CARDS, PRINTING SERVICES 300 NEWSPAPER ADVERTISEMENTS 700 1,000 001-5001-541.51-00 OFFICE SUPPLIES 2,704 2,899 3,000 2,320 45 4,000 LEVEL TEXT TEXT AMT DEPT OFFICE SUPPLIES 2,000 TONER 2,000 4,000 001-5001-541.52-00 OPERATING SUPPLIES 7,699 7,976 7,500 4,958 1,004 8,500 LEVEL TEXT TEXT AMT DEPT KITCHEN AND OFFICE SUPPLIES 2,500 FIRST AID AND SAFETY ITEMS 1,000 MISC. OPERATING SUPPLIES 5,000 8,500 001-5001-541.52-01 GASOLINE 924 807 1,500 293 60 1,000 LEVEL TEXT TEXT AMT DEPT GASOLINE 1,000 1,000 001-5001-541.54-00 BOOK,SUBSCRIP,MEMBERSHIPS 692 790 2,500 775 0 2,500 LEVEL TEXT TEXT AMT DEPT APWA, FLORIDA STORMWATER ASSOCIATION AND OTHER MEMBERSHIPS AND MATERIALS AS NEEDED 2,500 2,500 001-5001-541.55-00 TRAINING 0 396 2,000 187 0 2,000 LEVEL TEXT TEXT AMT DEPT TRAINING 2,000 2,000 001-5001-541.64-02 COMPUTER EQUIPMENT 0 4,439 11,000 2,384 0 10,000 LEVEL TEXT TEXT AMT PREPARED 06/29/20, 13:56:07 BUDGET PREPARATION WORKSHEET PAGE 4 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST DEPT LAPTOPS AND OTHER MISC. REMOTE LOCATION EQUIPMENT 5,000 LARGE FORMAT SCANNER 5,000 10,000 * 365,571 427,776 543,026 240,141 54,150 647,963 -------------------------------------------------------------------------** PUBLIC WKS ADMINISTRATION 365,571 427,776 543,026 240,141 54,150 647,963 PREPARED 06/29/20, 13:56:07 BUDGET PREPARATION WORKSHEET PAGE 5 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST ROAD & STREET DIVISION 001-5002-541.12-00 SALARIES 201,025 234,781 316,990 146,872 39,347 263,613 LEVEL TEXT TEXT AMT DEPT PUBLIC WORKS DIRECTOR 97,790.40 + 3% X 40% 37,818 BUILDING/SIGN MAINTENANCE 40,518.40 +3% 41,734 BEACH RANGER 37128 + 3% X 50% 19,121 GENERAL MAINTENACE WORKER II 48,505.60 + 3% X 75% 37,471 GENERAL MAINTENANCE WORKER (2) 59155.20 + 3% X 50% 30,647 GENERAL MAINTENAANCE WORKER (3) 93740.80 +3% X 75% 74,733 STREETS/STORMWATER /BEACHES SUPERVISOR 42,889.60 + 3% X 50% 22,089 263,613 001-5002-541.14-00 OVERTIME 712 8,293 1,000 4,365 855 5,000 001-5002-541.15-00 SPECIAL PAY 4,227 4,062 1,500 4,515 0 1,500 001-5002-541.21-00 F.I.C.A. 14,612 17,954 24,441 11,329 2,888 20,664 001-5002-541.22-04 BENEFIT GROUP-GENERAL 5,197 15,372 13,219 7,711 1,102 13,616 001-5002-541.22-05 401 GENL DEF CONTR MATCH 6,087 7,150 0 4,555 1,095 5,000 001-5002-541.22-08 UNFUNDED LIABILITY-GEPP 66,785 72,749 69,250 28,854 0 69,250 001-5002-541.23-01 HEALTH 59,427 56,482 72,316 37,749 10,492 79,548 001-5002-541.23-02 LIFE 426 546 620 384 106 620 001-5002-541.24-00 WORKERS' COMPENSATION 14,020 23,597 17,998 7,876 1,905 18,538 001-5002-541.31-00 PROFESSIONAL SERVICES 401 3,397 25,500 16,913 153 50,500 LEVEL TEXT TEXT AMT DEPT SUBSTANCE ABUSE TESTING FOR CDL DRIVERS 500 MISC. PROFESSIONAL ENGINEERING 30,000 DESIGN FOR SEMINOLE RD. (ATLANTIC BLVD. TO DAVID ST.) 20,000 50,500 001-5002-541.34-00 OTHER CONTRACTUAL SERVS. 142,176 213,034 131,040 82,170 5,460 477,040 LEVEL TEXT TEXT AMT DEPT LAWN MAINTENANCE FOR ATLANTIC BLVD. MEDIANS 23,000 PREPARED 06/29/20, 13:56:07 BUDGET PREPARATION WORKSHEET PAGE 6 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST LAWN MAINTENANCE FOR MAYPORT POND AT HESS STATION 640 LAWN MAINTENANCE FOR MAYPORT RD. MEDIANS 4,600 LAWN MAINTENANCE FOR HOPKINS CREEK POND 1,500 PEST CONTROL PW BUILDING 300 IRRIGATION SYSTEM REPAIRS FOR ATLANTIC & MAYPORT 5,500 PALM TREE TRIMMING ATLANTIC & MAYPORT MEDIANS 3,200 ROW HERBICIDE APPLICATION 3,200 PW FACILITY SECURITY/CAMERA SYSTEM 6,000 ASPHALT REPAIRS 12,000 CONCRETE REPAIRS 25,000 SOIL & DENSITY TESTING FOR STREET RESURFACING 1,100 TREE CUTTING/ARBORIST CONSULTATIONS 20,000 INSTALL AND TAKE DOWN XMAS DECORATIONS ON ATLANTIC BLVD. & MAYPORT RD. 6,000 REPLACEMENT OF PLANTS/FLOWERS IN MEDIANS ON ATLANTIC BLVD. & MAYPORT RD. 15,000 CITY MAINTAINED STREET LIGHTS 5,000 MILLING & PAVING 325,000 BEACH ACCESS AND PRESERVE WALKWAY REPAIRS 20,000 477,040 001-5002-541.34-02 TOWN CENTER MAINTENANCE 48,755 29,318 73,250 23,126 1,070 153,250 LEVEL TEXT TEXT AMT DEPT LANDSCAPE MAINTENANCE 16,000 PALM TREE TRIMMING INCLUDES DATE PALMS 1X YEAR 12,000 REPLACEMENT OF DAMAGED PLANTS 3,200 REPLACEMENT OF DAMAGED TREES 2,400 BRICK REPLACEMENT/CONCRETE REPAIRS 2,500 STRIPING & PAVEMENT MARKING 1,600 CITY OF NEPTUNE BEACH WATER 4,500 REPLACE 3 TRASH CANS 4,200 IRRIGATION REPAIRS 2,750 ELECTRIC 600 COAB UTILITIES 3,500 BENCH REPLACEMENTS (4) 10,000 15 NEW LIGHTS AND POLES FOR TOWN CENTER 90,000 153,250 001-5002-541.34-03 MAYPORT FLYOVER MAINT 18,623 18,904 30,350 18,136 1,225 30,350 LEVEL TEXT TEXT AMT DEPT LAWN MAINTENANCE NEPTUNE BEACH SIDE 5,050 LAWN MAINTENANCE ATLANTIC BEACH SIDE 8,200 LAWN MAINTENANCE AROUND POND ON MAYPORT RD. BETWEEN W. 4TH & W. 5TH STREET 6,350 PREPARED 06/29/20, 13:56:07 BUDGET PREPARATION WORKSHEET PAGE 7 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST PALM TREE TRIMMING AROUND POND 800 PALM TREE TRIMMING ATLANTIC BEACH SIDE 900 PALM TREE TRIMMING NEPTUNE BEAH SIDE 1,450 IRRIGATION REPAIRS 3,200 REPLACE DAMAGED TREES 2,200 REPLACE DAMAGED PLANTS 2,200 30,350 001-5002-541.40-00 TRAVEL AND PER DIEM 643 175 0 0 0 0 001-5002-541.41-00 COMMUNICATIONS 961 1,844 2,600 2,920 979 2,600 LEVEL TEXT TEXT AMT DEPT 4 CELL PHONES FOR THE DIVISION SHARED W/STORMWATER 1,200 MONTHLY RADIO FEES 2 X 12 MONTHS 1,400 2,600 001-5002-541.42-00 TRANSP.,POSTAGE,MESSENGER 14 56 0 0 0 0 001-5002-541.43-00 UTILITIES 113,129 110,014 125,000 64,130 8,176 125,000 LEVEL TEXT TEXT AMT DEPT ELECTRIC FOR STREET LIGHTS, TRAFFIC SIGNALS & PW BUILDING 125,000 125,000 001-5002-541.43-01 CITY PROVIDED 28,208 26,911 30,000 14,338 3,964 30,000 LEVEL TEXT TEXT AMT DEPT INCLUDES PW ADMIN AND CITY FACILITY GARBAGE COSTS 30,000 30,000 001-5002-541.44-00 RENTALS & LEASES 2,898 7,061 12,500 3,341 347 14,500 LEVEL TEXT TEXT AMT DEPT UNIFORM RENTALS 2,200 UNIFORM PREP CHARGES FOR NEW HIRES (3 EMPLOYEES) 300 LIFT RENTAL 2,000 HEAVY EQUIPMENT RENTAL 10,000 14,500 001-5002-541.46-00 REPAIR & MAINTENANCE 475 78 1,500 1,511 0 0 001-5002-541.47-00 PRINTING & PUBLISHING 3,189 347 1,500 0 0 1,500 PREPARED 06/29/20, 13:56:07 BUDGET PREPARATION WORKSHEET PAGE 8 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST LEVEL TEXT TEXT AMT DEPT NEWSPAPER ADVERTISING FOR EMPLOYEES 750 NEWSPAPER ADVERTISING FOR BIDS 750 1,500 001-5002-541.51-00 OFFICE SUPPLIES 0 0 250 90 0 250 LEVEL TEXT TEXT AMT DEPT OFFICE SUPPLIES 250 250 001-5002-541.52-00 OPERATING SUPPLIES 86,161 108,278 79,400 56,028 12,537 88,200 LEVEL TEXT TEXT AMT DEPT STOP BAR MATERIALS 7,500 SIGNS & STAMPING 15,000 SEED & SOD 8,000 BARRICADES, CONES & LIGHTS 4,000 MISC. HARDWARE ITEMS & ELECTRICAL SUPPLIES 5,000 BOOTS, GLOVES & RAIN GEAR 4,000 PAINT FOR STRIPING PARKING LINES 1,700 REPLACE 1 STOCK EDGER 500 REPLACE 1 BACKPACK BLOWER 500 REPLACEMENT MOWERS 20,000 STREET SIGN POLES AND PANEL REPLACEMENTS 22,000 88,200 001-5002-541.52-01 GASOLINE 7,307 8,312 6,000 4,545 578 6,000 LEVEL TEXT TEXT AMT DEPT GASOLINE FOR VEHICLES & EQUIPMENT 6,000 6,000 001-5002-541.52-02 DIESEL 1,833 3,354 2,000 1,929 178 2,000 LEVEL TEXT TEXT AMT DEPT DIESEL FUEL FOR VEHICLES & EQUIPMENT 2,000 2,000 001-5002-541.53-00 ROAD & MATERIAL SUPPLIES 4,971 900 4,000 1,038 0 8,000 LEVEL TEXT TEXT AMT PREPARED 06/29/20, 13:56:07 BUDGET PREPARATION WORKSHEET PAGE 9 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST DEPT LIMEROCK, COLD PATCH AND CRUSH CRETE 8,000 8,000 001-5002-541.54-00 BOOK,SUBSCRIP,MEMBERSHIPS 0 80-1,500 0 0 1,500 LEVEL TEXT TEXT AMT DEPT SAFETY MANUALS FOR TRAINING, SAFETY VIDEOS & ITEMS 1,500 1,500 001-5002-541.55-00 TRAINING 0 1,533 2,000 450 0 2,000 LEVEL TEXT TEXT AMT DEPT TRAINING 2,000 2,000 001-5002-541.63-00 INFRASTRUCTURE 54,900 95,870 15,000 12,064 0 160,000 LEVEL TEXT TEXT AMT DEPT CONSTRUCTION FOR 8' SEMINOLE RD. BIKEPATH (ATLANTIC BLVD. TO DAVID ST.) 110,000 RIGHT-OF-WAY PARKING PADS WITH TURF-BLOCK PAVERS 50,000 160,000 001-5002-541.64-00 MACHINERY & EQUIPMENT 7,200 21,377 66,140 0 0 80,000 LEVEL TEXT TEXT AMT DEPT Z BOOM LIFT (GENIE Z-45 W/ARTICULATING BOOM) FOR TREE TRIMMING, LIGHTS AND HURRICANE SHUTTERS 80,000 80,000 001-5002-541.64-01 MOTOR VEHICLES 0 23,738 70,000 69,877 0 215,500 LEVEL TEXT TEXT AMT DEPT 2 NEW REPLACEMENT TRUCKS ($27K EACH) 54,000 SMALLER GRAPPLE TRUCK (2020 KENWORTH T370) 137,000 UTV FOR BEACH RANGER 24,500 215,500 * 894,362 1,115,407 1,196,864 626,816 92,457 1,925,539 001-5002-562.34-01 MOSQUITO CONTROL 225 3,025 6,000 700 0 0 * 225 3,025 6,000 700 0 0 ------------------------------------------------------------------- ------ PREPARED 06/29/20, 13:56:07 BUDGET PREPARATION WORKSHEET PAGE 10 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST ** ROAD & STREET DIVISION 894,587 1,118,432 1,202,864 627,516 92,457 1,925,539 PREPARED 06/29/20, 13:56:07 BUDGET PREPARATION WORKSHEET PAGE 11 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST EQUIPMENT MAINTENANCE 001-5004-549.34-01 1ST VEHICLE-CONTRACT SVCS 229,420 234,453 250,500 198,940 31,704 278,500 LEVEL TEXT TEXT AMT DEPT CONTRACT PRICE FOR 19/20 + 3% INCREASE FOR FLEET MAINTENANCE = $270,548 + %8,115 = $278,663 278,500 278,500 001-5004-549.34-02 1ST VEHIC-NON CONTRACT SV 28,851 28,387 45,000 19,331 5,669 25,000 LEVEL TEXT TEXT AMT DEPT NON-CONTRACT WORK INCLUDES WORK FOR REPAIRS OF VEHICLE ACCIDENTS, RUST, INSTALLATION OF SAFETY LITES, TIRES, HYDRAULICS, LIFT STATIONS, ET. 25,000 25,000 001-5004-549.41-00 COMMUNICATIONS 274 240 1,390 372 135 1,390 LEVEL TEXT TEXT AMT DEPT TELEPHONE 650 CELL PHONES 500 2 COJ RADIOS ACTIVATED FOR 2 MONTHS (STORM SEASON) 240 1,390 001-5004-549.52-00 OPERATING SUPPLIES 1,828 0 1,600 0 212 1,600 LEVEL TEXT TEXT AMT DEPT MISC. SUPPLIES FOR GARAGE 600 HAND TOOL REPLACEMENTS AND UPGRADES 1,000 1,600 001-5004-549.52-01 GASOLINE 758 908 600 473 44 600 LEVEL TEXT TEXT AMT DEPT GAS FOR SHOP TRUCK 600 600 * 261,131 263,988 299,090 219,116 37,764 307,090 -------------------------------------------------------------------------** EQUIPMENT MAINTENANCE 261,131 263,988 299,090 219,116 37,764 307,090 ---------------------- ---------------------------------------------------*** GENERAL FUND 1,521,289 1,810,196 2,044,980 1,086,773 184,371 2,880,592 1,521,289 1,810,196 2,044,980 1,086,773 184,371 2,880,592 PREPARED 06/29/20, 13:56:07 BUDGET PREPARATION WORKSHEET PAGE 12 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST PW-Beautification.pdfBWPRINT/3/BWDEPTREQ_/259988/ATLBMAB/192.88.55.23/IAEST4/1200629/135655/3C18/0328 PREPARED 06/29/20, 13:56:55 BUDGET PREPARATION WORKSHEET PAGE 1 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST GENERAL FUND BEAUTIFICATION 001-6025-541.12-00 SALARIES 7,468 18,456 0 18,017 5,021 33,615 LEVEL TEXT TEXT AMT DEPT LANDSCAPE AND BEAUTIFICATION TECH 32,635.20 +3% 33,615 33,615 001-6025-541.14-00 OVERTIME 0 388 0 71 94 100 001-6025-541.15-00 SPECIAL PAY 0 845 0 0 0 0 001-6025-541.21-00 F.I.C.A. 530 1,495 2,074 1,265 336 2,610 001-6025-541.22-08 UNFUNDED LIABILITY-GEPP 0 0 13,691 0 0 0 001-6025-541.23-01 HEALTH 2,005 2,502 0 6,624 2,390 10,929 001-6025-541.23-02 LIFE 19 42 0 51 15 77 001-6025-541.24-00 WORKERS' COMPENSATION 518 1,892 192 985 277 1,477 001-6025-541.31-00 PROFESSIONAL SERVICES 0 105 2,000 0 0 2,000 LEVEL TEXT TEXT AMT DEPT ARBORIST/LANDSCAPE ARCHITECT 2,000 2,000 001-6025-541.34-00 OTHER CONTRACTUAL SERVS. 10,281 421 10,000 5,844 0 11,000 LEVEL TEXT TEXT AMT DEPT GENERAL LANDSCAPING & BEAUTIFICATION -ANNUALS 7,000 ADOPTION MATCHING FUNDS 1,000 XMAS LIGHT INSTALLATION AT CITY HALL & ADELE GRAGE 3,000 11,000 001-6025-541.41-00 COMMUNICATIONS 1 4 600 2 1 600 LEVEL TEXT TEXT AMT DEPT ONE SMART PHONE 600 600 001-6025-541.52-00 OPERATING SUPPLIES 7,087 28,443 20,000 11,977 3,881 20,000 PREPARED 06/29/20, 13:56:55 BUDGET PREPARATION WORKSHEET PAGE 2 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST LEVEL TEXT TEXT AMT DEPT MULCH, PINE STRAW, FERTILIZER, ANT BAIT, WEED POISON, SOD 10,000 ANNUALS, SHRUBS, PERENIALS, GROUND COVER 10,000 20,000 001-6025-541.52-01 GASOLINE 0 0 750 0 0 750 LEVEL TEXT TEXT AMT DEPT GASOLINE 750 750 001-6025-541.52-03 STREET-END ADOPT/MATCH PR 0 1,335 2,000 0 0 2,000 LEVEL TEXT TEXT AMT DEPT ADOPTION MATCHING FUNDS 2,000 2,000 * 27,909 55,928 51,307 44,836 12,015 85,158 ------------------------------------------- ------------------------------** BEAUTIFICATION 27,909 55,928 51,307 44,836 12,015 85,158 -------------------------------------------------------------------------*** GENERAL FUND 27,909 55,928 51,307 44,836 12,015 85,158 27,909 55,928 51,307 44,836 12,015 85,158 PW-Bldg Maintenance.pdfBWPRINT/3/BWDEPTREQ_/259971/ATLBMAB/192.88.55.23/IAEST4/1200629/135454/2EB4/0308 PREPARED 06/29/20, 13:54:54 BUDGET PREPARATION WORKSHEET PAGE 1 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST GENERAL FUND BUILDING MAINTENANCE 001-1012-519.12-00 SALARIES 87,692 90,874 105,325 53,522 11,305 66,235 LEVEL TEXT TEXT AMT DEPT PAINTER II 45,947.20 + 3% (ROUNDED) 47,326 PUBLIC WORKS DIRECTOR 91,740.40 + 3% X 20% 18,909 66,235 001-1012-519.14-00 OVERTIME 0 1,560 200 26 0 200 001-1012-519.15-00 SPECIAL PAY 182 607 0 206 0 0 001-1012-519.21-00 F.I.C.A. 6,425 6,802 8,073 3,926 813 5,083 001-1012-519.22-04 BENEFIT GROUP-GENERAL 5,898 11,733 10,095 5,889 841 10,398 001-1012-519.22-05 401 GENL DEF CONTR MATCH 1,547 1,624 2,000 921 254 2,060 001-1012-519.22-08 UNFUNDED LIABILITY-GEPP 18,566 19,564 18,623 7,760 0 19,182 001-1012-519.23-01 HEALTH 14,908 15,094 8,208 10,217 2,014 13,610 001-1012-519.23-02 LIFE 180 199 160 130 27 165 001-1012-519.24-00 WORKERS' COMPENSATION 3,665 4,971 3,647 1,731 396 3,757 001-1012-519.31-00 PROFESSIONAL SERVICES 0 105 0 0 0 0 001-1012-519.34-00 OTHER CONTRACTUAL SERVICE 57,216 85,811 62,000 51,705 10,290 219,500 LEVEL TEXT TEXT AMT DEPT JANITORIAL, HVAC REPAIRS, ETC. 62,000 NEW AC UNIT AT CITY HALL (NORTH END) 7,500 TWO NEW AC UNITS AT ADELE GRAGE 15,000 NEW FLOORING AT PW DOWNSTAIRS OFFICES (3) 6,000 NEW FLOORING AT ADELE GRAGE (KITCHEN, COMMUNITY ROOM, THEATRE BATHROOM) 8,000 NEW FLOORING AT JORDAN CC (KITCHEN, COMMUNITY ROOM, COMPUTER ROOM, CUBICLES) 8,000 NEW FLOORING AT GAIL BAKER CC (KITCHEN, HALLWAY, COMMUNITY ROOM, COMPUTER ROOM) 8,000 PUBLIC WORKS BUILDING ROOF REPAIR 20,000 STANDARD ROOF REPAIRS 17,000 PUBLIC WORKS MOLD MITIGATION 18,000 SANITIZE PUBLIC BUILDINGS 2X PER YEAR: PREPARED 06/29/20, 13:54:54 BUDGET PREPARATION WORKSHEET PAGE 2 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST CITY HALL 10,000 JORDAN PARK COMMUNITY CENTER 5,000 GAIL BAKER COMMUNITY CENTER 5,000 PUBLIC SAFETY BUILDING 8,000 ADELE GRAGE CULTURAL CENTER 7,000 PUBLIC UTILITIES 7,000 PUBLIC WORKS 8,000 219,500 001-1012-519.41-00 COMMUNICATIONS 21 60 600 42 5 600 LEVEL TEXT TEXT AMT DEPT PHONE FOR BLDG. MAINTENANCE TECHNICIAN 600 600 001-1012-519.44-00 RENTALS & LEASES 0 0 300 0 0 300 LEVEL TEXT TEXT AMT DEPT MISC. RENTALS 300 300 001-1012-519.45-00 INSURANCE 10,000 0 0 0 0 0 001-1012-519.46-00 REPAIR & MAINTENANCE 700 2,748 5,000 4,454 0 5,000 LEVEL TEXT TEXT AMT DEPT MISC. REPAIR & MAINTENANCE 5,000 5,000 001-1012-519.52-00 OPERATING SUPPLIES 5,856 6,200 6,000 2,958 481 7,500 LEVEL TEXT TEXT AMT DEPT PAINT SUPPLIES, HARDWARE, TOOLS, ETC. 4,800 JANITORIAL SUPPLIES 1,200 HAND SANITIZERS, DISINFECTANT PRODUCTS 1,500 7,500 001-1012-519.52-01 GASOLINE 537 685 600 283 29 600 LEVEL TEXT TEXT AMT DEPT GASOLINE 600 600 PREPARED 06/29/20, 13:54:54 BUDGET PREPARATION WORKSHEET PAGE 3 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST 001-1012-519.52-02 DIESEL 0 0 25 0 0 25 LEVEL TEXT TEXT AMT DEPT DIESEL 25 25 001-1012-519.55-00 TRAINING 0 0 1,000 0 0 1,000 LEVEL TEXT TEXT AMT DEPT TRAINING/CERTIFICATIONS 1,000 1,000 001-1012-519.64-01 MOTOR VEHICLES 0 24,580 0 0 0 0 * 213,393 273,217 231,856 143,770 26,455 355,215 -------------------------------------------------------------------------** BUILDING MAINTENANCE 213,393 273,217 231,856 143,770 26,455 355,215 -------------------------------------------------------------------------*** GENERAL FUND 213,393 273,217 231,856 143,770 26,455 355,215 213,393 273,217 231,856 143,770 26,455 355,215 PW-Parks Maintenance.pdfBWPRINT/3/BWDEPTREQ_/259984/ATLBMAB/192.88.55.23/IAEST4/1200629/135623/3E4C/030C PREPARED 06/29/20, 13:56:23 BUDGET PREPARATION WORKSHEET PAGE 1 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST GENERAL FUND MAINTENANCE 001-6020-572.12-00 SALARY 229,277 255,511 277,754 134,595 32,799 247,600 LEVEL TEXT TEXT AMT DEPT PARK RANGER (5) 156,540 + 3% 161,238 PARK RANGER II 39,249.60 + 3% 40,428 PARKS & BUILDING MAINT SUPERVISOR 44,595.20 + 3% 45,934 247,600 001-6020-572.14-00 OVERTIME 4,871 8,762 6,000 1,844 0 6,000 001-6020-572.15-00 SPECIAL PAY 2,184 4,451 0 0 113 0 001-6020-572.21-00 F.I.C.A. 17,465 19,833 21,708 10,030 2,371 19,324 001-6020-572.22-04 BENEFIT GROUP-GENERAL 24,794 23,698 23,368 13,631 1,947 24,070 001-6020-572.22-05 401 GENL DEF CONTR MATCH 138 0 0 749 265 1,235 001-6020-572.22-08 UNFUNDED LIABILITY-GEPP 36,935 32,631 31,062 12,943 0 31,062 001-6020-572.23-01 HEALTH 50,622 49,977 56,327 32,760 9,415 61,960 001-6020-572.23-02 LIFE 532 638 598 387 101 600 001-6020-572.24-00 WORKERS' COMPENSATION 8,131 12,386 8,056 3,411 810 8,298 001-6020-572.25-00 REEMPLOYMENT COMPENSATION 0 165 0 0 0 0 001-6020-572.31-00 PROFESSIONAL SERVICES 489 6,874 1,430 210 0 45,000 LEVEL TEXT TEXT AMT DEPT CONSULTANTS GENERAL (ARBORIST, ENGINEER, DESIGN) 5,000 DUTTON ISLAND BRIDGE REPLACEMENT ENGINEERING 40,000 45,000 001-6020-572.34-00 OTHER CONTRACTUAL SERVS. 177,668 205,881 284,800 228,203 43,603 398,800 LEVEL TEXT TEXT AMT DEPT BEACH CLEANING (ANNUAL CONTRACT) 32,200 PARKS LAWN MAINTENANCE (ANNUAL CONTRACT) 72,600 PALM TREE TRIMMING (ANNUAL CONTRACT) 11,000 PEST CONTROL (ANNUAL CONTRACT) 2,000 BUILDING MONITORING 1,000 PREPARED 06/29/20, 13:56:23 BUDGET PREPARATION WORKSHEET PAGE 2 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST GENERAL CONCRETE 6,000 GENERAL PLUMBING 5,000 AC & HEAT REPAIR 10,000 TREE SERVICES 10,000 GENERAL IRRIGATION 6,000 GENERAL FENCE 8,000 GENERAL DOORS & WINDOWS 4,000 SIGNS 5,000 INVASIVE PLANT CONTROL 2,500 GENERAL LANDSCAPE & BEAUTIFICATION 7,000 MISCELLANEOUS SERVICES 5,000 GENERAL ELECTRIC REPAIRS 7,500 REPAIRS AND IMPROVEMENTS AT DOG PARKS 11,500 SKATE PARK REPAIRS 2,500 BASEBALL LIGHT REPAIRS 6,000 BASKETBALL GOALS & RIMS 5,000 NEW CANOPY AT TIDEVIEW PRESERVE 3,000 PAVILION AT TIDEVIEW PRESERVE 15,000 EXISTING PAVILION POLE REPAIRS 5,000 PAVILION AT HOWELL PARK 18,000 LED LIGHTING AT ROSE PARK SOCCER FIELD 30,000 SOLAR LED POLE LIGHTS AT AQUATIC DOG PARK 22,000 LED LIGHTS AT DONNER TENNIS COURTS 25,000 LED LIGHTS AT DONNER PARK -BASEBALL FIELD 25,000 DUTTON ISLAND ROAD REGRADING (BI-MONTHLY) 30,000 RUSSELL PARK BASEBALL FIELD UPKEEP SPRAY/FERTILIZE 6,000 398,800 001-6020-572.40-00 TRAVEL AND PER DIEM 72 0 500 86 0 500 LEVEL TEXT TEXT AMT DEPT TRAVEL AND PER DIEM 500 500 001-6020-572.41-00 COMMUNICATIONS 2,086 2,121 3,500 1,792 499 3,500 LEVEL TEXT TEXT AMT DEPT PHONES FOR PARKS DIVISION 1,600 TIDEVIEWS INTERNET FOR SECURITY CAMERA 1,200 MONTHLY RADIO FEES 1 X 12 MONTHS 700 3,500 001-6020-572.42-00 FREIGHT,POSTAGE,EXPR MAIL 0 18 50 84 0 50 LEVEL TEXT TEXT AMT PREPARED 06/29/20, 13:56:23 BUDGET PREPARATION WORKSHEET PAGE 3 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST DEPT FREIGHT, POSTAGE, EXPRESS MAIL 50 50 001-6020-572.43-00 UTILITIES 16,665 17,303 16,500 9,370 741 16,500 LEVEL TEXT TEXT AMT DEPT UTILITIES 16,500 16,500 001-6020-572.43-01 CITY PROVIDED 44,016 48,606 42,000 23,775 7,215 42,000 LEVEL TEXT TEXT AMT DEPT UTILITIES CITY PROVIDED 42,000 42,000 001-6020-572.44-00 RENTALS AND LEASES 1,105 4,523 2,500 1,045 258 6,500 LEVEL TEXT TEXT AMT DEPT EQUIPMENT AND TOOL RENTAL, LIFT RENTAL 5,000 UNIFORM RENTAL 1,500 6,500 001-6020-572.46-00 REPAIR & MAINTENANCE 464 17,650 25,000 11,370 0 17,000 LEVEL TEXT TEXT AMT DEPT PARKS MISCELLANEOUS 7,500 RACQUETBALL COURT REPAIR 3,500 WATER FOUNTAIN REPLACEMENT 2,000 POND FOUNTAIN REPLACEMENT 4,000 17,000 001-6020-572.47-00 PRINTING AND PUBLISHING 1,725 117 500 59 0 1,000 LEVEL TEXT TEXT AMT DEPT BIDS, MAPS AND EMPLOYMENT ADS 1,000 1,000 001-6020-572.51-00 OFFICE SUPPLIES 0 0 200 90 0 200 LEVEL TEXT TEXT AMT DEPT OFFICE SUPPLIES 200 200 PREPARED 06/29/20, 13:56:23 BUDGET PREPARATION WORKSHEET PAGE 4 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST 001-6020-572.52-00 OPERATING SUPPLIES 64,236 173,442 87,600 39,428 10,458 101,600 LEVEL TEXT TEXT AMT DEPT CLEANING SUPPLIES FOR PARKS 6,500 LIGHT BULBS, HARDWARE, ETC. 5,000 GENERAL LANDSCAPE & BEAUTIFICATION 6,000 PAINT FOR PAINTING SUPPLIES 5,000 HURRICANE SUPPLIES 1,500 SAFETY, SHIRTS, BOOTS, HATS, ETC. 4,000 LIMEROCK, SAND, COQUINA, TOPSOIL 7,000 PUBLIC AMENITIES (GRILLS, PICNIC TABLES, ETC.) 10,000 RAKES, SHOVELS, HAND TOOLS, OIL, BLADES 2,000 REPLACEMENT BLOWERS, WEEDEATERS, EDGERS, ETC. 1,600 TENNIS COURT WINDSCREENS 3,000 ADOPTION MATCHING FUNDS 2,000 FIBAR MULCH TO IMPROVE PLAYGROUND SAFETY 10,000 WOOD PROTECTANT FOR MARSH BOARDWALKS 5,000 SODDIING/REPAIRS 6,000 SOD AQUATIC DOG PARK (2X PER YEAR) 20,000 SOD ROSE DOG PARK 3,000 SOD JORDAN PARK 2,000 NEW BLEACHER AT RUSSELL PARK BASKETBALL COURT 2,000 101,600 001-6020-572.52-01 GASOLINE 9,126 9,784 10,000 7,000 889 10,000 LEVEL TEXT TEXT AMT DEPT GAS FOR VEHICLES & EQUIPMENT 10,000 10,000 001-6020-572.52-02 DIESEL 0 19 500 0 0 500 LEVEL TEXT TEXT AMT DEPT DIESEL FOR EQUIPMENT 500 500 001-6020-572.54-00 BOOK,SUBSCRIP,MEMBERSHIPS 10 0 200 0 0 200 LEVEL TEXT TEXT AMT DEPT BOOK, SUBSCRIPTIONS, MEMBERSHIPS 200 200 001-6020-572.55-00 TRAINING 1,106 1,417 1,000 931 391-4,000 PREPARED 06/29/20, 13:56:23 BUDGET PREPARATION WORKSHEET PAGE 5 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST LEVEL TEXT TEXT AMT DEPT TRAINING 4,000 4,000 001-6020-572.63-00 INFRASTRUCTURE 0 0 0 0 0 294,000 LEVEL TEXT TEXT AMT DEPT RESURFACE BASKETBALL COURT AT VETERANS PARK 22,000 RACQUETBALL COURT REMODEL W/STORAGE 150,000 REMODEL PORCH RESTROOM AT GAIL BAKER COMM. CTR. 12,000 HOWELL PARK BRIDGES 30,000 HOWELL PARK BOARDWALK REPLACEMENT 50,000 NEW ELECTRONIC MARQUEE SIGN AT CITY HALL 30,000 294,000 001-6020-572.64-00 MACHINERY & EQUIPMENT 7,050 3,700 0 0 0 25,000 LEVEL TEXT TEXT AMT DEPT WOOD CHIPPER 25,000 25,000 001-6020-572.64-01 MOTOR VEHICLES 25,466 0 26,570 26,568 0 54,000 LEVEL TEXT TEXT AMT DEPT 2 NEW TRUCKS TO REPLACE #59 & #P3 ($27K EACH) 54,000 54,000 * 726,233 899,507 927,723 560,361 111,093 1,420,499 -------------------------------------------------------------------------** MAINTENANCE 726,233 899,507 927,723 560,361 111,093 1,420,499 -------------------------------------------------------------------------*** GENERAL FUND 726,233 899,507 927,723 560,361 111,093 1,420,499 726,233 899,507 927,723 560,361 111,093 1,420,499 PW-Solid Waste.pdfBWPRINT/3/BWDEPTREQ_/259991/ATLBMAB/192.88.55.23/IAEST4/1200629/135706/11C8/0320 PREPARED 06/29/20, 13:57:06 BUDGET PREPARATION WORKSHEET PAGE 1 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST SANITATION FUND SANITATION 420-4201-534.12-00 SALARIES 16,042 16,522 16,590 9,819 3,178 21,277 LEVEL TEXT TEXT AMT DEPT HEAVY EQUIPMENT OPERATOR II (2) 72,404.80+3% X10% 7,458 HEAVY EQUIPMENT OPERATOR 44,720 + 3% X 30% 13,819 21,277 420-4201-534.14-00 OVERTIME 166 284 0 73 23 200 420-4201-534.15-00 SPECIAL PAY 789 566 0 263 100 624 420-4201-534.21-00 F.I.C.A. 1,193 1,219 1,271 714 233 1,707 420-4201-534.22-04 BENEFIT GROUP-GENERAL 1,722 1,516 1,309 764 109 1,349 420-4201-534.22-05 401 GENL DEF CONTR MATCH 208 212 0 149 78 215 420-4201-534.22-08 UNFUNDED LIABILITY-GEPP 29,315 45,896 38,053 15,855 0 41,859 420-4201-534.23-01 HEALTH 5,134 5,062 6,470 3,091 981 6,600 420-4201-534.23-02 LIFE 37 41 44 27 9 45 420-4201-534.24-00 WORKERS' COMPENSATION 670 880 768 307 111 0 420-4201-534.31-00 PROFESSIONAL SERVICES 95 39 0 0 0 0 420-4201-534.34-00 OTHER CONTRACTUAL SERVICE 3,380 15,872 4,800 2,783 283 20,000 LEVEL TEXT TEXT AMT DEPT TIPPAGE FEES FOR COMMERCIAL DEBRIS HAULED BY CITY 20,000 20,000 420-4201-534.34-01 PICK-UP AND HAUL CONTRACT 1,419,975 1,460,218 1,425,000 1,425,000 0 1,525,000 LEVEL TEXT TEXT AMT DEPT ESTIMATED ANNUAL FEE FOR COLLECTION OF GARGAGE, YARD WASTE AND RECYCLING 1,500,000 CONTINGENCY 25,000 1,525,000 420-4201-534.45-00 INSURANCE 2,241 2,390 2,000 1,685 0 2,000 PREPARED 06/29/20, 13:57:06 BUDGET PREPARATION WORKSHEET PAGE 2 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST LEVEL TEXT TEXT AMT DEPT INSURANCE 2,000 2,000 420-4201-534.46-01 FLEET MAINTENANCE 5,798 5,697 6,300 3,230 441 6,300 LEVEL TEXT TEXT AMT DEPT FLEET MAINTENANCE 6,300 6,300 420-4201-534.56-01 CITY MANAGER 35,425 35,425 35,425 17,712 0 0 420-4201-534.56-02 FINANCE AND ADMIN 90,904 90,904 90,904 45,452 0 0 420-4201-534.56-03 PUBLIC WORKS ADMIN 22,108 22,108 22,108 11,054 0 0 420-4201-534.56-05 HUMAN RESOURCES 793 793 793 396 0 0 420-4201-534.56-06 INFORMATION TECHNOLOGY 3,046 3,046 3,046 1,523 0 0 * 1,639,041 1,708,690 1,654,881 1,539,897 5,546 1,627,176 -------------------------------------------------------------------------** SANITATION 1,639,041 1,708,690 1,654,881 1,539,897 5,546 1,627,176 -------------------------------------------------------------------------*** SANITATION FUND 1,639,041 1,708,690 1,654,881 1,539,897 5,546 1,627,176 1,639,041 1,708,690 1,654,881 1,539,897 5,546 1,627,176 PW-Stormwater.pdfBWPRINT/3/BWDEPTREQ_/259994/ATLBMAB/192.88.55.23/IAEST4/1200629/135724/1DAC/0320 PREPARED 06/29/20, 13:57:24 BUDGET PREPARATION WORKSHEET PAGE 1 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST STORM WATER DRAINAGE FUND 470-0000-538.12-00 SALARIES 140,052 194,672 212,026 119,348 34,560 154,338 LEVEL TEXT TEXT AMT DEPT PUBLIC WORKS DIRECTOR 91,790.40 + 3% X 20% 18,909 CITY ENGINEER 102,336 + 3% X 25% 26,352 GENERAL MAINTENANCE WORKER II 48,505.60 + 3% X 25% 12,491 GENERAL MAINTENANCE WORKER(3)96,740.80+ 3% X 25% 24,911 GENERAL MAINTENACE WORKER (2) 59,155.20 +3% X 50% 30,465 BEACH RANGER 37,128 + 3% X 50% 19,121 STREETS/STORMWATER BEACHES SUPERVISOR 42,889.60 + 3% X 50% 22,089 154,338 470-0000-538.14-00 OVERTIME 1,563 6,943 5,000 3,079 657 5,000 470-0000-538.15-00 SPECIAL PAY 9,178 7,462 2,600 5,345 1,385 9,004 LEVEL TEXT TEXT AMT DEPT LEONARD, ANTHONY 225.04 X 26 5,852 SWANN, STEVE 121.22 X 26 3,152 9,004 470-0000-538.16-00 COMPENSATED ANNUAL LEAVE 3,795 3,795 0 0 0 0 470-0000-538.21-00 F.I.C.A. 10,904 15,313 14,947 9,343 2,666 12,879 470-0000-538.22-04 BENEFIT GROUP -GENERAL 0 0 5,702 3,326 475 5,874 470-0000-538.22-05 401 GENL DEF CONTR MATCH 5,464 5,196 0 3,751 1,538 0 470-0000-538.22-08 UNFUNDED LIABILITY-GEPP 41,077 64,603 52,859 22,025 0 52,859 470-0000-538.23-01 HEALTH 32,455 36,313 44,236 25,920 8,051 48,660 470-0000-538.23-02 LIFE 282 431 0 298 88 500 470-0000-538.24-00 WORKER'S COMPENSATION 9,076 16,048 12,360 5,636 1,642 12,731 470-0000-538.26-00 OTH POSTEMPLOY BENE(OPEB) 239 1,601 0 0 0 0 470-0000-538.31-00 PROFESSIONAL SERVICES 31,054 111,747 41,950 14,705 575 41,950 LEVEL TEXT TEXT AMT PREPARED 06/29/20, 13:57:24 BUDGET PREPARATION WORKSHEET PAGE 2 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST DEPT FLU SHOTS 200 NPDES MONITORING 10,000 SURVEYING TO SUPPORT CITY FORCES PROJECTS 6,000 CDL DRUG TESTING 750 NPDES REPORTING SUPPORT 25,000 41,950 470-0000-538.34-00 OTHER CONTRACTUAL SERVICE 134,970 207,304 187,610 82,995 975 187,610 LEVEL TEXT TEXT AMT DEPT ASPHALT REPAIRS 10,000 REPLACE ORANGEBURG PIPE 10,000 POINT REPAIRS 75,000 CONCRETE REPAIRS 10,000 STREET SWEEPING REQUIRED BY NPDES 35,610 DITCH SPRAYING, MAINTENANCE 22,000 CONVEYANCE SYSTEM CLEANING AND TV INSPECTIONS 25,000 187,610 470-0000-538.41-00 COMMUNICATIONS 1,890 1,602 2,000 607 146 2,000 LEVEL TEXT TEXT AMT DEPT MAINTAINING 3 CELL PHONES (SHARED WITH STREETS) 600 MONTHLY RADIO CHARGES -2 F/T 12 MONTHS $56 1,400 2,000 470-0000-538.44-00 RENTALS & LEASES 986 0 2,450 0 0 39,288 LEVEL TEXT TEXT AMT DEPT UNIFORM RENTAL 450 LIFT RENTAL 2,000 VAC-CON LEASE 36,838 39,288 470-0000-538.45-00 INSURANCE 24,982 16,904 16,183 13,643 0 0 470-0000-538.46-00 REPAIR & MAINTENANCE 15 0 0 0 0 0 470-0000-538.46-01 FIRST VEHICLES/EQUIPMENT 3,565 0 3,689 0 0 0 470-0000-538.47-00 PRINTING & PUBLISHING 595 363 1,500 143 0 1,500 LEVEL TEXT TEXT AMT DEPT NEWSPAPER AND EMPLOYMENT ADS 500 PREPARED 06/29/20, 13:57:24 BUDGET PREPARATION WORKSHEET PAGE 3 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST PRINTING FOR NOTICE OF VIOLATIONS 250 PRINTING EROSION CONTROL INSPECTION FORMS 750 1,500 470-0000-538.49-00 OTHER CURRENT CHARGES 570 570 600 570 0 600 LEVEL TEXT TEXT AMT DEPT STORMWATER SUREILLANCE FEE (STATE) 600 600 470-0000-538.49-10 BAD DEBT EXPENSE 7,289 0 0 0 0 0 470-0000-538.51-00 OFFICE SUPPLIES 0 0 300 15 0 300 LEVEL TEXT TEXT AMT DEPT OFFICE SUPPLIES 300 300 470-0000-538.52-00 OPERATING SUPPLIES 37,565 44,404 48,500 11,358 242 66,500 LEVEL TEXT TEXT AMT DEPT HARDWARE, RUBBER PRODUCTS, PAINT, MOWER BLADES ETC 3,000 BARRICADES, CONES & LIGHTS 3,500 SWMP MINOR PROJECTS (CITY FORCES) CIP 25,000 GRATES & MANHOLE COVERS 5,000 CEMENT BAGS 4,000 EROSION CONTROL FABRIC 2,000 HURRICANE SUPPLIES 2,000 FIELD TESTING KITS (E COLI BACTERIA) 4,000 VAC-CON CAMERA SYSTEM 18,000 66,500 470-0000-538.52-01 GASOLINE 5,978 6,801 5,000 3,719 473 5,000 LEVEL TEXT TEXT AMT DEPT GASOLINE FOR VEHICLES & EQUIPMENT 5,000 5,000 470-0000-538.52-02 DIESEL 1,500 2,744 2,500 1,578 146 2,500 LEVEL TEXT TEXT AMT DEPT DIESEL FOR VEHICLES & EQUIPMENT 2,500 2,500 PREPARED 06/29/20, 13:57:24 BUDGET PREPARATION WORKSHEET PAGE 4 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST 470-0000-538.53-00 ROAD MATERIALS 281 0 3,000 0 0 3,000 LEVEL TEXT TEXT AMT DEPT 57 STONE, CRUSH CRETE & COLD PATCH 3,000 3,000 470-0000-538.54-00 BOOK,SUBSCRIP,MEMBERSHIPS 500 565 500 500 0 500 LEVEL TEXT TEXT AMT DEPT FLORIDA STORMWATER ASSOCIATION MEMBERSHIP DUES 500 500 470-0000-538.55-00 TRAINING 940 5,922 5,400 2,047 0 5,400 LEVEL TEXT TEXT AMT DEPT STORMWATER TRAINING 3,000 FSA ANNUAL CONFERENCE 2,400 5,400 470-0000-538.56-01 CITY MANAGER 16,750 16,750 16,750 8,375 0 16,750 470-0000-538.56-02 FINANCE AND ADMIN 44,576 44,576 44,576 22,288 0 44,576 470-0000-538.56-03 PUBLIC WORKS ADMIN 66,323 66,323 66,323 33,162 0 66,323 470-0000-538.56-05 HUMAN RESOURCES 7,252 7,252 7,252 3,626 0 7,252 470-0000-538.56-06 INFORMATION TECHNOLOGY 27,844 27,844 27,844 13,922 0 27,844 470-0000-538.59-03 IMPR OTHER THAN BLD-PURCH 479,223 0 0 0 0 0 470-0000-538.59-05 MACHINERY & EQUIPMENT 43,393 0 0 0 0 0 470-0000-538.59-06 MOTOR VEHICLES 4,337 0 0 0 0 0 470-0000-538.59-11 LAND IMPROVEMENTS 107,310 0 0 0 0 0 470-0000-538.61-02 EASEMENTS 0 0 5,000 0 0 5,000 LEVEL TEXT TEXT AMT DEPT LAND -EASEMENTS 5,000 5,000 PREPARED 06/29/20, 13:57:24 BUDGET PREPARATION WORKSHEET PAGE 5 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST 470-0000-538.63-00 INFRASTRUCTURE 419,911 197,281 2,850,000 626,086 0 0 470-0000-538.64-00 MACHINERY & EQUIPMENT 234,749 92,468 0 0 0 77,500 LEVEL TEXT TEXT AMT DEPT MINI SKID STEER (DINGO) FOR MULTIPLE USES: BEACH ACCESSES, DITCH LINES, PARKS 40,000 MULCHER ATTACHMENT FOR TRACK CAT SKID STEER 37,500 77,500 470-0000-538.71-04 TD BANK-URB SERIES 2014 154,050 157,950 161,200 161,200 0 164,450 * 2,112,483 1,361,747 3,849,857 1,198,610 53,619 1,067,688 -------------------------------------------------------------------------** STORM WATER DRAINAGE FUND 2,112,483 1,361,747 3,849,857 1,198,610 53,619 1,067,688 ---------------------- ---------------------------------------------------*** STORM WATER DRAINAGE FUND 2,112,483 1,361,747 3,849,857 1,198,610 53,619 1,067,688 2,112,483 1,361,747 3,849,857 1,198,610 53,619 1,067,688 Recreation.pdfBWPRINT/3/BWDEPTREQ_/260134/ATLBMAB/192.88.55.23/IAEST4/1200629/141533/34E8/0308 PREPARED 06/29/20, 14:15:33 BUDGET PREPARATION WORKSHEET PAGE 1 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST GENERAL FUND REC PROGRAMS/SPECL EVENTS 001-6010-572.12-00 SALARY 182,336 205,506 211,225 121,613 33,709 235,531 LEVEL TEXT TEXT AMT DEPT RECREATION ASSOCIATE 36,420.80 + 3% 37,513 DIR OF CULTURAL ARTS & RECREATION 88,670.40 + 3% 91,331 RECREATION CENTER MANAGER (2) 85,092.80 + 3% 87,646 RECREATION COORDINATOR (PT 25 HRS/WK) 18,486 + 3% 19,041 235,531 001-6010-572.14-00 OVERTIME 5,419 5,206 7,000 4,896 0 7,000 001-6010-572.15-00 SPECIAL PAY 3,395 2,550 2,400 1,272 400 0 001-6010-572.21-00 F.I.C.A. 14,063 15,761 16,878 9,321 2,471 18,554 001-6010-572.22-04 BENEFIT GROUP-GENERAL 15,596 9,459 8,141 4,749 678 8,385 001-6010-572.22-05 401 GENL DEF CONTR MATCH 679 0 1,244 309 169 1,283 001-6010-572.22-08 UNFUNDED LIABILITY-GEPP 31,675 25,445 24,221 10,092 0 24,948 001-6010-572.23-01 HEALTH 22,147 21,453 20,410 18,374 5,897 22,451 001-6010-572.23-02 LIFE 260 261 317 190 55 358 001-6010-572.24-00 WORKERS' COMPENSATION 5,001 27,333 6,077 2,386 650 6,260 001-6010-572.31-00 PROFESSIONAL SERVICES 105 315 0 0 0 0 001-6010-572.34-00 OTHER CONTRACTUAL SERVS. 21,186 32,379 20,200 11,329 6 24,000 001-6010-572.40-00 TRAVEL AND PER DIEM 149 189 300 289 0 400 001-6010-572.41-00 COMMUNICATIONS 7,714 6,638 10,000 5,193 1,085 11,000 001-6010-572.42-00 FREIGHT,POSTAGE,EXPR MAIL 28 0 150 0 0 150 001-6010-572.43-00 UTILITIES 9,766 9,368 9,000 5,702 310 10,000 001-6010-572.43-01 CITY PROVIDED 7,940 5,696 7,500 4,519 960 8,500 001-6010-572.44-00 RENTALS AND LEASES 3,492 5,776 9,000 5,083 0 9,000 001-6010-572.46-00 REPAIR & MAINTENANCE 10,265 5,332 4,650 921 8 3,500 PREPARED 06/29/20, 14:15:33 BUDGET PREPARATION WORKSHEET PAGE 2 PROGRAM GM601L FOR FISCAL YEAR 2021 ACCOUNTING PERIOD 08/2020 TWO 2019/2020 2019/2020 2020/2021 YEAR'S AGO LAST YEARS ADJUSTED YTD SPENT AND DEPARTMENT ACCOUNT NUMBER ACCOUNT DESCRIPTION ACTUALS ACTUALS BUDGET ENCUMBERED UNPOSTED REQUEST 001-6010-572.47-00 PRINTING AND PUBLISHING 64 0 0 0 0 0 001-6010-572.49-01 CULTURAL ARTS 32,504 33,426 37,700 10,118 0 37,700 001-6010-572.51-00 OFFICE SUPPLIES 300 707 1,000 268 0 1,000 001-6010-572.52-00 OPERATING SUPPLIES 17,072 24,656 27,800 11,313 1,496 30,000 001-6010-572.52-01 GASOLINE 1,368 1,370 1,500 734 0 1,500 001-6010-572.54-00 BOOK,SUBSCRIP,MEMBERSHIPS 32 355 320 0 0 320 001-6010-572.55-00 TRAINING 1,104 1,094 3,000 0 0 3,000 001-6010-572.61-00 LAND 1,350,000 0 0 0 0 0 001-6010-572.62-00 BUILDING 42,409 2,589 0 0 0 0 001-6010-572.81-01 CULTURAL ARTS /SCHOOLS 5,820 5,820 6,000 5,335 485 6,000 001-6010-572.82-00 AIDS TO PRIVATE ORGANIZAT 37,015 36,891 48,300 47,706 0 48,300 * 1,828,904 485,575 484,333 281,712 48,379 519,140 -------------------------------------------------------------------------** REC PROGRAMS/SPECL EVENTS 1,828,904 485,575 484,333 281,712 48,379 519,140 -------------------------------------------------------------------------*** GENERAL FUND 1,828,904 485,575 484,333 281,712 48,379 519,140 1,828,904 485,575 484,333 281,712 48,379 519,140