Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2023 Budget
City of Fairhope Fairhope, Alabama Budget for Fiscal Year October 1, 2022 – September 30, 2023 City of Fairhope, Alabama Fiscal Year 2023 Budget Table of Contents Page Budget Resolution 1 General Fund 2 General Government 5 Elected Officials 7 Planning 8 Building 9 Judicial 10 Police 11 Information Technology 17 Human Resources 18 Revenue 19 Meter 20 Fire 21 Economic & Community Development 23 Civic Center 24 Museum/Welcome Center 25 Adult Recreation (Nix Center) 26 Community Events 27 Charitable Contributions 29 Appropriations 30 Recreation 32 Marina 33 Streets 34 Fleet Maintenance 35 Golf / Golf Grounds 36 Non-Departmental Facilities 38 Other Expenditures 39 Gas Tax Fund 44 Rebuild Alabama Fund 45 Capital Projects Fund 46 Impact Fees Fund 48 Municipal Capital Improvement Fund 51 Debt / Cash 52 Utilities Cash Flow 58 Gas Fund 64 Electric Fund 69 Water / Wastewater Fund 74 Sanitation Fund 84 Capital Equipment/Improvements 88 Personnel 98 Page 1 of 109 General Fund 9/26/2022 Object Description FY 2019 Annual FY 2020 Annual FY 2021 Annual FY2022 Aug YTD FY2022 Annual Budget FY2023 Annual Budget REVENUES 40030 Real Estate Taxes 5,270,773 5,638,083 6,015,270 6,434,923 6,620,000 7,489,524 40040 Automobile Taxes 676,790 716,378 852,736 771,861 700,000 903,900 Total Property Taxes 5,947,563 6,354,462 6,868,005 7,206,784 7,320,000 8,393,424 40160 City Sales Tax 9,231,019 9,320,427 8,636,716 8,101,639 8,930,000 9,154,919 40162 SSUT INCOME 38,683 609,723 829,206 1,137,351 820,000 878,959 40163 City Sales Tax-PJ - - 921,703 845,526 800,000 977,005 40164 Seller Use Tax - - 1,038,979 1,013,950 1,230,000 1,101,318 40165 Seller Use Tax-PJ - - 183,991 170,226 180,000 195,030 40166 Consumer Use Tax - - 90,615 102,890 117,000 96,052 40167 Consumer Use Tax-PJ - - 26,689 15,386 20,000 28,290 40170 Beer Tax 291,050 304,467 315,595 254,586 280,000 315,000 40175 Beer Tax-Police Jurisdiction 27,722 31,474 36,146 30,182 28,000 36,000 40180 Wine Tax 57,145 60,040 68,137 50,215 55,000 68,000 40185 Wine Tax-Police Jurisdiction 443 467 496 431 470 500 40190 Liquor Tax 135,266 125,886 167,488 153,484 135,000 167,000 40195 Liquor Tax-Police Jurisdiction 35,372 29,765 34,845 33,804 30,000 35,000 40210 Dog Tax 54 59 70 16 60 - 40220 Cigarette Tax 82,064 69,120 62,319 49,853 60,000 60,449 40225 Cigarette Tax-Police Jurisdict 39,942 47,276 49,261 38,899 43,300 47,783 40230 Lodging Tax 459,010 350,129 515,112 542,788 430,000 546,019 40235 Lodging Tax-Police Jurisdictio 657,232 561,408 851,612 861,999 570,000 902,709 Total Local Taxes 11,055,002 11,510,241 13,828,981 13,403,224 13,728,830 14,610,033 40310 Business Lic-Inside City 2,345,235 2,472,359 2,347,337 2,514,050 2,320,000 2,480,000 40315 Business Lic-Police Jurisdicti 91,818 118,051 113,952 142,919 113,000 145,000 40325 Registration Fees-Solicit - 3,400 - - - - 40330 Parade/Misc Permit Fees 23,359 16,901 13,398 26,182 16,000 22,000 40350 Building Permits 1,031,961 858,901 986,901 1,279,786 900,000 900,000 40360 Inspection Fees 464,707 274,859 286,161 524,400 276,000 276,000 40370 Misc Bldg Dept Fees/Fines 33,273 25,954 25,674 127,398 20,000 20,000 40375 Planning-Misc Revenue - - - 148 - 500 40376 Subdivision - Outside City - - - 74,800 - 100,000 40377 Subdivision - Inside City - - - 157,350 - 135,000 40379 Board of Adjustment - - - 3,080 - - 40380 Rezoning Applications 19,128 7,210 13,780 16,002 10,000 10,000 40385 State of AL Commercial Fee 48,107 18,843 20,366 67,706 20,000 50,000 40390 Insurance Co. Franchises 279,989 286,333 274,356 337,833 277,000 277,000 40400 Cable TV Franchise 281,446 251,267 294,962 244,858 265,000 265,000 40410 Franchise Fees-City Prop 5,652 - 4,434 5,187 - 1,000 40415 Utility Franchise Fees - - 187,804 199,716 187,804 188,948 41240 Subdivision Fees 166,325 249,975 321,875 - 200,000 - Total Licenses and Permits 4,790,999 4,584,053 4,891,000 5,721,413 4,604,804 4,870,448 40540 Fines Forfeitures & Fees 237,812 199,228 194,677 186,652 200,000 200,000 40541 Court-Corrections Fund Revenue 35,339 31,056 35,467 30,407 30,000 30,000 Total Court Revenue 273,151 230,283 230,144 217,060 230,000 230,000 40590 Annual AL Liq Tax Allocation 302 3,675 14,207 23,286 5,000 5,000 40600 Liquor Tax-Monthly Revenue 59,518 76,589 77,226 74,406 70,000 70,000 40610 Fin Inst Excise Tax 238,196 222,910 648,419 375,955 150,000 230,000 40620 Motor Veh Lic & Reg Fees 5,430 5,109 5,817 5,780 5,000 5,000 40630 Oil Prod Privilege Tax 5,041 2,022 5,628 5,608 4,000 5,000 41695 Severance Tax - Gas & Oil 11,277 10,562 7,422 7,611 11,000 11,000 Total State of Alabama 319,765 320,867 758,720 492,647 245,000 326,000 40650 State Grants - - 24,603 - - - 40780 Grant - Police Dept 2,500 289,265 302,455 289,686 300,000 300,000 40815 Mosquito Control Revenue 24,960 24,960 24,960 24,960 24,960 24,960 40835 Federal Grants 47,899 131,267 273,569 1,733 - - 40840 Fema-Grant Revenues - 620,777 8,302,930 - - - 49740 Community Grants - - 101,600 - - - 45520 Airport Grant Revenue - 743,081 719,100 56,992 100,000 100,000 Total Grants 75,359 1,809,350 9,749,217 373,371 424,960 424,960 Page 2 of 109 General Fund 9/26/2022 Object Description FY 2019 Annual FY 2020 Annual FY 2021 Annual FY2022 Aug YTD FY2022 Annual Budget FY2023 Annual Budget 40950 Interest-Bank Deposits 95,876 220,640 170,981 180,107 147,000 170,000 40970 Lease-Municipal Pier 23,857 21,929 1,635 - 2,000 2,000 40980 Rent - Farm - 9,975 9,975 9,975 9,975 9,975 41020 Rent - Faulkner 45,409 1 1 1 1 1 41040 Rent - USA 3,857 1,900 6,648 25,000 6,000 25,000 41060 Rent - Civic Center 58,397 46,956 22,303 40,290 30,000 40,000 41080 Rent - Park/Sidewalk Areas 17,186 (1,639) 9,093 16,513 2,000 12,000 41070 Rent - Nix Center 28,867 13,203 29,047 26,784 13,000 30,000 Total Interest and Rents 273,450 312,965 249,681 298,670 209,976 288,976 41250 Utility Collections Fees 221,000 256,000 251,000 1,202,153 1,202,154 1,216,851 41260 Admin Services - Utilities 2,284,000 2,555,000 2,615,000 2,511,000 2,511,000 2,733,078 Total Charge for Services 2,505,000 2,811,000 2,866,000 3,713,153 3,713,154 3,949,929 41310 Memberships 27,125 10,925 16,325 20,600 12,000 20,000 41315 Donations - 300 - 1,835 - - 41320 Dance Revenue 7,105 2,827 1,931 4,438 3,000 3,000 41325 Instruction 451 1,019 54 561 500 500 41335 Misc Rev - Special Services 1,808 1,250 1,019 1,121 1,000 1,000 41336 Community/Specl Projct Grants - 20,000 196,000 42,500 40,000 40,000 Total Adult Recreation 36,489 36,321 215,329 71,055 56,500 64,500 41745 Rec Dept Memb/Pass 307,816 161,098 262,875 348,775 210,000 300,000 41910 Rec Dept Pool Memberships 66,493 27,223 65,478 28,605 52,000 30,000 41920 Rec Dept Summer Program 17,010 7,445 3,120 - 5,000 5,000 41940 Rec Dept Miscellaneous 18,723 7,552 14,154 22,028 9,000 9,000 41945 Recreation Field Rental - 600 12,338 56,523 8,000 30,000 41950 Tennis Revenue 550 - - - - - 41955 Tennis Memberships 23,495 18,325 25,580 21,648 20,000 20,000 41960 Miscellaneous Tennis Revenue 16,157 13,613 16,527 10,646 14,000 14,000 41965 Tennis Shop Sales 6,118 3,555 6,010 8,221 3,500 8,500 Total Rec Dept Revenue 456,362 239,411 406,081 496,446 321,500 416,500 41022 Pumpout Service 175 490 410 255 300 300 41025 Fairhope Docks Slip Rentals 167,064 208,960 199,613 141,371 175,000 175,000 41045 Marina Fuel Income 269,522 436,561 456,427 550,916 350,000 533,700 41055 Docks - Ship Store Sales 1,311 1,735 1,993 2,717 1,800 2,500 Total Marina Revenue 438,072 647,747 658,443 695,258 527,100 711,500 44510 Memberships 192,922 193,558 235,474 179,974 210,000 210,000 44520 Green Fees 189,173 182,758 221,700 201,558 185,000 210,000 44530 Cart Rentals 375,194 371,744 461,825 406,803 400,000 440,000 44540 Pro Shop Sales 97,297 77,386 109,068 101,497 100,000 100,000 44545 Pro Shop Sales - Custom Order 18,003 6,124 4,331 19,603 12,500 22,500 44550 Driving Range 51,308 46,725 71,736 65,099 60,000 70,000 44560 Beverage Sales 67,681 67,567 93,582 82,736 80,000 95,000 44570 Food Sales 62,340 50,236 68,568 75,180 60,000 84,000 44590 Patio Rentals and Events - 350 - - 1,000 500 49020 Handicap Fees 6,733 4,852 6,607 5,970 6,000 6,000 Total Golf Revenue 1,060,650 1,001,299 1,272,891 1,138,419 1,114,500 1,238,000 41230 Dog Pound Fees 1,676 871 2,126 950 1,000 1,000 41610 Beach Revenue 15,430 13,875 13,115 8,340 13,000 10,000 41705 Sale of Fixed Assets 51,676 259,338 130,501 56,084 100,000 - 41755 Brick memorials 2,587 1,535 1,156 1,300 1,500 - 49015 Insurance Dividend - 20,014 20,630 21,833 - 20,000 49030 Insurance Claim 14,436 23,630 1,167,703 109,086 298,500 - 49035 Rebate Income 12,755 11,167 7,432 11,610 7,500 10,000 49040 Miscellaneous Income 16,155 7,627 52,970 13,253 7,500 7,500 49080 Community Dev Revenue 13,730 7,755 1,785 35,720 - - 49090 Inmate Phone Revenue 5,683 3,409 3,168 1,662 3,000 2,000 49998 Budget Rollover - - - - 324,545 1,036,786 49999 Inventory Revenue - - (0) (2,266) - - Total Other Revenue 134,129 349,221 1,400,586 257,572 756,545 1,087,286 49820 Natural gas fund 96,000 - - 102,016 102,016 185,030 Page 3 of 109 General Fund 9/26/2022 Object Description FY 2019 Annual FY 2020 Annual FY 2021 Annual FY2022 Aug YTD FY2022 Annual Budget FY2023 Annual Budget 49830 Electric fund 168,000 - - 537,655 537,655 499,803 49840 Water & Wastewater fund 246,000 - - 551,190 551,190 290,324 49895 Transfers from Impact Fee Fund 116,393 1,371,973 417,157 175,908 149,900 224,893 49896 Transfers In-Muni Cap Impr Fun - 249,195 - - - - 49899 Utility Transfers for ECD 1,128,000 629,000 1,454,000 - - - Total Transfers 1,754,393 2,250,167 1,871,157 1,366,769 1,340,761 1,200,050 TOTAL REVENUES 29,120,382 32,457,387 45,266,235 35,451,839 34,593,630 37,811,605.75 EXPENSES *General Government 3,754,344 8,824,658 2,748,379 2,117,034 2,346,352 2,673,207 *Elected Officials - - 264,037 254,812 284,871 291,238 *Planning 635,359 911,695 885,517 665,751 1,051,906 1,210,810 *Building Dept 877,745 821,009 951,561 953,032 1,027,564 1,261,456 *Judicial 308,349 294,927 306,640 280,716 287,537 305,946 *Police Dept 6,180,245 6,721,487 6,836,958 6,464,203 7,759,967 8,529,725 *Information Technology - 667 598,833 766,931 1,134,009 1,476,782 *Human Resources - - - 323,419 387,994 514,906 *Revenue - - 393,261 509,484 605,300 664,798 *Meter - - - 578,754 676,154 755,287 *Fire Department 873,892 591,253 1,194,836 829,274 1,129,180 1,152,536 *Economic & Community Dev 1,064,481 745,345 626,733 529,904 634,470 694,306 *Recreation Dept 2,323,644 2,444,085 2,770,104 2,329,020 2,746,871 2,977,122 *Civic Center 277,202 306,452 299,845 203,654 420,720 782,562 *Museum/Welcome Center 165,819 156,440 206,495 207,269 220,986 200,801 *Adult Recreation/Special Service 475,272 382,530 465,942 458,886 821,053 682,150 *Marina/Harbor 640,110 575,752 567,169 1,134,846 793,915 947,829 *Streets Department 3,868,745 3,664,516 4,843,007 4,511,368 5,064,538 5,988,776 [*,/4999Fleet Maintenance 610,138 640,802 652,483 708,466 875,494 810,925 *Golf Clubhouse/Grounds 1,533,840 1,566,000 1,621,215 1,469,851 2,075,483 2,376,766 *Non-Departmental Facilities - - 352,478 359,777 492,574 548,817 *Staff Agencies & Appropriation 1,231,077 1,271,081 1,340,671 1,308,500 1,431,600 1,451,740 *Debt Service 2,380,296 (1,355,999) 300,000 325,466 300,000 300,000 *Other Expeditures/Transfers 1,143,500 1,767,525 1,807,798 982,084 2,025,092 1,213,120 *Gen Emergency Disasters - 770,175 9,518,913 7,293 - - Total Expenses 28,344,058 31,100,401 39,552,874 28,279,791 34,593,630 37,811,606 Excess Rev Over Expenses 776,324 1,356,986 5,713,360 7,172,047 - - Page 4 of 109 General Government Administration 9/26/2022 Object Description FY 2019 Annual FY 2020 Annual FY 2021 Annual FY2022 Aug YTD FY2022 Annual Budget FY2023 Annual Budget 50040 Salaries - - 1,221,654 944,864 1,054,871 1,174,625 50045 Overtime - - 8,399 4,977 4,972 5,000 50060 Salary-Mayor 32,547 32,400 0 - - - 50070 Salaries-Council 49,200 49,200 - - - - 50080 Salaries-Administrative 1,383,027 1,603,757 0 - - - 50081 Overtime-Gen Admin 47,309 57,839 (0) - - - 50110 Salary/Fee-City Attorney 36,000 36,000 36,000 33,000 36,000 36,000 50130 Salaries-Janitors 26,021 35,423 - - - - 50160 Salaries-Beach Labor 4,298 - - - - - 50161 Overtime-Beach 705 - - - - - 50180 Salaries-Revenue Dept 227,630 240,264 (0) - - - 50181 Overtime-Revenue 1,372 3,007 - - - - 50190 Employee Payroll Taxes 119,308 148,789 93,137 70,293 81,078 91,343 50200 Employee Retirement Exp 131,975 140,518 99,182 77,954 85,548 98,427 50210 Employee Medical Insurance 228,156 460,330 299,928 177,644 198,227 199,857 50215 Required Contrib-OPEB 84,268 50,282 18,869 12,850 14,018 28,037 50220 Casualty/Workers Comp Ins 128,260 157,273 - - - - 50221 Workers Comp Insurance - - 5,585 3,450 2,855 3,433 50222 Casualty/Property Insurance - - 111,555 101,685 94,180 107,300 50230 Training/School/Travel 33,191 12,471 14,916 5,769 20,650 20,850 50270 Audit & Accounting 62,946 60,458 55,584 39,424 60,000 70,000 50280 Legal Fees 236,476 170,617 137,698 82,177 175,000 150,000 50290 Professional Services 61,923 78,742 100,211 129,256 64,000 151,200 50300 Computer Expense 105,419 101,812 115,167 48,777 12,025 63,633 50320 Office Supplies 28,293 15,725 8,942 9,584 20,900 13,000 50325 Printers/Copiers/OE and supp - 14,712 20,749 16,092 19,731 29,000 50330 Postage 7,703 6,921 6,275 5,300 7,500 7,500 50340 General Supplies 49,921 31,764 31,771 25,347 35,000 35,000 50360 General Maintenance 32,775 25,826 15,557 11,573 51,600 40,000 50374 Library Utilities - 31,239 - - - - 50375 Library Bldg Maint/Equipment 80,287 37,569 - - - - 50377 Parking Garage Maintenance 9,591 4,235 - - - - 50380 Communications 39,252 39,933 22,627 10,205 14,300 17,892 50384 Boys and Girls Club utilities - 1,211 - - - - 50385 Boys and Girls Club Maint/Equ 12,357 2,534 - - - - 50390 Dues-Memberships-Subscrip 19,302 18,388 17,126 20,771 12,696 22,566 50395 Employment Screening - - 397 705 1,000 500 50400 Miscellaneous - - 1,367 - - - 50410 Cash Over or Short 3 (187) 202 (50) - - 50430 Gasoline & Oil 1,717 1,487 5,225 4,603 1,500 500 50440 Equip & Vehicle Repair 4,119 1,827 2,493 429 4,000 1,000 50460 Uniforms 1,962 252 1,526 744 600 800 50462 Safety Wear and PPE - - - - 1,000 500 50470 Purchases Vehicles & Equipment 173,564 163,656 - 32,682 14,500 8,000 50475 Capital Improvements - - - - - 20,000 50482 Land/Right of Way Acquisitions 180 4,671,162 - - - - 50510 Interest Expense - - 17,967 67 - - 50580 Bank Fees 1,394 12,828 35,065 23,688 15,000 25,000 50585 Printing - - - 225 1,000 1,000 51000 Recording Fees Paid 178 116 302 163 200 200 51025 Colony Rent 12,298 9,715 36,394 23,265 36,400 25,000 51030 Publications Newspapers 19,271 17,750 15,137 27,113 16,800 20,000 51045 Election Expense 26,002 10,748 1,666 299 2,500 1,000 51050 COF Book & Sidewalk Brick 2,220 1,070 1,605 1,235 2,000 2,000 51085 County Prisoner Expense 1,991 - - - - - 51130 Haven Maintenance 7,884 12,133 - - - - 51135 Haven Utilities - 11,171 - - - - 51150 Fishermans Whart Maintenance 1,000 1,000 - - - - 51165 City Hall Maintenance 12,543 1,053 11,533 20,958 14,700 33,045 51170 Beach Repairs and Maint 42,844 43,805 - - - - 52040 Grant Expenditures - 20,000 20,000 - - - 52080 Sales Tax Collection Fees 153,614 165,807 167,444 142,549 160,000 160,000 52510 Utilities for City Use 12,051 10,027 8,771 7,367 10,000 10,000 Page 5 of 109 General Government Administration 9/26/2022 Object Description FY 2019 Annual FY 2020 Annual FY 2021 Annual FY2022 Aug YTD FY2022 Annual Budget FY2023 Annual Budget Total General Gov Administration 3,754,344 8,824,658 2,768,025 2,117,034 2,346,352 2,673,207 Page 6 of 109 Elected Officals 9/26/2022 Object Description FY 2019 Annual FY 2020 Annual FY 2021 Annual FY2022 Aug YTD FY2022 Annual Budget FY2023 Annual Budget 50040 Salaries - - 152,914 129,045 149,200 149,200 50190 Employee Payroll Taxes - - 11,324 9,772 11,414 11,414 50200 Employee Retirement Exp - - 7,373 7,244 7,902 7,902 50210 Employee Medical Insurance - - 55,172 77,111 85,312 85,312 50221 Workers Comp Insurance - - 79 175 118 173 50222 Casualty/Property Insurance - - 2,733 4,069 3,825 4,272 50230 Training/School/Travel - - 15,093 21,549 20,000 20,000 50290 Professional Services - - 1,400 - - - 50300 Computer Expense - - 6,555 - - 1,815 50320 Office Supplies - - 2,025 - - 500 50325 Printers/Copiers/OE and supp - - 159 189 - 500 50340 General Supplies - - 5,438 666 - 750 50360 General Maintenance - - 262 - - - 50380 Communications - - 924 1,164 - 2,300 50390 Dues-Memberships-Subscrip - - 2,586 3,830 7,100 7,100 Total Elected Officals - - 264,037 254,812 284,871 291,238 Page 7 of 109 Planning Department 9/26/2022 Object Description FY 2019 Annual FY 2020 Annual FY 2021 Annual FY2022 Aug YTD FY2022 Annual Budget FY2023 Annual Budget REVENUES 40375 Planning-Misc Revenue - - - 148 - 500 40376 Subdivision - Outside City - - - 74,800 - 100,000 40377 Subdivision - Inside City - - - 157,350 - 135,000 40379 Board of Adjustment - - - 3,080 - - 40380 Rezoning Applications 19,128 7,210 13,780 16,002 10,000 10,000 41240 Subdivision Fees 166,325 249,975 321,875 - 200,000 - TOTAL REVENUES 185,453 257,185 335,655 16,002 210,000 10,000 EXPENSES 50040 Salaries 418,319 504,594 479,937 360,410 587,113 632,163 50045 Overtime 5,990 2,163 3,871 938 1,390 1,500 50190 Employee Payroll Taxes 31,791 37,541 35,818 26,229 45,021 52,751 50200 Employee Retirement Exp 34,947 37,836 39,161 28,929 45,782 53,844 50210 Employee Medical Insurance 46,214 84,631 76,971 65,602 102,227 103,880 50215 Required Contrib-OPEB - 5,821 5,821 13,028 5,821 19,840 50220 Casualty/Workers Comp Ins 7,282 17,438 - - - - 50221 Workers Comp Insurance - - 5,437 3,709 3,206 3,695 50222 Casualty/Property Insurance - - 10,569 12,671 10,000 13,304 50230 Training/School/Travel 5,048 1,786 580 15,988 10,000 15,000 50280 Legal Fees - 141,700 108,108 61,599 75,000 85,000 50290 Professional Services 35,236 14,728 19,532 15,710 95,000 110,000 50300 Computer Expense 19,879 13,885 79,711 38,567 16,744 35,716 50320 Office Supplies 4,415 1,988 1,079 2,725 3,524 5,000 50325 Printers/Copiers/OE and supp - 728 3,527 2,179 2,378 7,978 50340 General Supplies 12,050 2,031 2,224 747 7,000 7,000 50360 General Maintenance 1,341 3,011 - 1,734 2,000 2,000 50380 Communications 2,743 4,155 6,358 4,901 13,900 6,700 50390 Dues-Memberships-Subscrip 2,806 445 - 445 14,700 5,440 50395 Employment Screening - - 40 191 500 - 50430 Gasoline & Oil 1,897 992 4,026 1,543 1,600 5,033 50440 Equip & Vehicle Repair 1,524 964 529 5 1,000 - 50462 Safety Wear and PPE - - - - - 1,500 50470 Purchases Vehicles & Equipment - 23,854 - - - 31,466 50520 Equipment Rental - - (0) - - - 51030 Publications Newspapers 3,876 11,405 7,924 7,903 8,000 12,000 Total Planning 635,359 911,695 891,223 665,751 1,051,906 1,210,810 Excess Rev Over Expense (449,906) (654,510) (555,568) (649,749) (841,906) (1,200,810) Page 8 of 109 Building Department 9/26/2022 Object Description FY 2019 Annual FY 2020 Annual FY 2021 Annual FY2022 Aug YTD FY2022 Annual Budget FY2023 Annual Budget REVENUES 40350 Building Permits 1,031,961 858,901 986,901 1,279,786 900,000 900,000 40360 Inspection Fees 464,707 274,859 286,161 524,400 276,000 276,000 40370 Misc Bldg Dept Fees/Fines 33,273 25,954 25,674 127,398 20,000 20,000 40385 State of AL Commercial Fee 48,107 18,843 20,366 67,706 20,000 50,000 TOTAL REVENUES 1,578,047 1,178,557 1,319,101 1,999,289 1,216,000 1,246,000 EXPENSES 50040 Salaries 447,136 502,750 493,559 486,160 564,051 633,163 50045 Overtime 1,352 8,250 5,271 5,222 12,158 10,000 50190 Employee Payroll Taxes 33,442 38,200 37,484 36,755 44,080 53,106 50200 Employee Retirement Exp 37,514 39,432 41,760 41,094 46,456 57,293 50210 Employee Medical Insurance 172,420 123,849 98,887 89,902 96,839 107,308 50220 Casualty/Workers Comp Ins 16,652 23,159 - - - - 50221 Workers Comp Insurance - - 7,997 7,293 6,800 7,281 50222 Casualty/Property Insurance - - 12,150 14,622 12,575 15,353 50230 Training/School/Travel 10,999 4,633 5,719 10,834 16,000 21,000 50290 Professional Services 3,080 88 79,088 25,705 45,000 50,000 50295 Building Fees 48,106 17,196 6,827 78,050 45,000 50,000 50300 Computer Expense 11,901 8,668 78,527 44,442 25,452 47,378 50320 Office Supplies 4,654 3,757 1,351 4,528 10,150 8,200 50325 Printers/Copiers/OE and supp - 1,057 4,001 2,669 4,284 6,600 50330 Postage - - - - 250 350 50340 General Supplies 18,572 8,148 8,002 2,726 6,000 4,500 50360 General Maintenance 366 344 238 8,320 - - 50380 Communications 5,033 6,773 12,006 11,677 7,800 14,800 50390 Dues-Memberships-Subscrip 1,305 580 1,137 860 5,120 4,715 50395 Employment Screening - - 76 136 300 - 50430 Gasoline & Oil 8,725 5,999 5,822 10,433 8,000 10,000 50440 Equip & Vehicle Repair 3,971 2,784 4,185 2,927 3,500 3,500 50460 Uniforms 1,524 1,755 1,875 2,421 1,500 3,000 50462 Safety Wear and PPE - - - 247 1,500 2,500 50470 Purchases Vehicles & Equipment 26,300 - - 28,373 24,000 95,659 50475 Capital Improvements - - - - - 15,000 50560 Credit Card Processing Fees 24,107 23,096 42,292 35,292 40,000 40,000 50585 Printing 586 492 37 303 750 750 Total Building Department 877,745 821,009 948,290 950,989 1,027,564 1,261,456 Excess Rev Over Expenses 700,302 357,547 370,811 1,048,301 188,436 (15,456) Page 9 of 109 Judicial 9/26/2022 Object Description FY 2019 Annual FY 2020 Annual FY 2021 Annual FY2022 Aug YTD FY2022 Annual Budget FY2023 Annual Budget 50040 Salaries 154,954 163,887 167,583 149,219 170,823 173,583 50045 Overtime 11,046 26,937 32,493 28,985 10,509 10,000 50190 Employee Payroll Taxes 12,158 13,880 14,490 13,008 13,872 15,792 50200 Employee Retirement Exp 12,035 13,144 14,926 13,644 14,439 15,610 50210 Employee Medical Insurance (1,197) 45,194 44,657 39,869 43,438 43,438 50220 Casualty/Workers Comp Ins 824 4,690 - - - - 50221 Workers Comp Insurance - - 1,000 281 248 280 50222 Casualty/Property Insurance - - 2,414 2,731 2,359 2,868 50230 Training/School/Travel 10,438 401 1,571 979 2,425 2,425 50290 Professional Services 5,380 6,368 1,474 1,991 2,500 2,500 50300 Computer Expense 8,414 16,196 22,428 26,441 16,401 27,427 50320 Office Supplies 7,202 1,449 978 778 3,000 1,500 50325 Printers/Copiers/OE and supp - 835 1,425 1,106 1,588 1,588 50330 Postage - - - 52 - - 50340 General Supplies 4,565 503 900 83 1,500 500 50360 General Maintenance - - - - 1,500 4,500 50380 Communications 140 970 1,829 973 2,360 3,160 50390 Dues-Memberships-Subscrip 9,360 475 500 575 575 575 50395 Employment Screening - - - - - 200 50470 Purchases Vehicles & Equipment 72,883 - - - - - 50560 Credit Card Processing Fees 147 - - - - - Total Judicial 308,349 294,927 308,669 280,716 287,537 305,946 Page 10 of 109 Police Department 9/26/2022 Object Description FY 2019 Annual FY 2020 Annual FY 2021 Annual FY2022 Aug YTD FY2022 Annual Budget FY2023 Annual Budget 3,198,838 3,640,250 3,791,964 3,448,977 4,263,301 4,731,724 35,615 19,741 18,408 35,506 35,000 - 147,326 153,290 146,343 138,581 140,162 170,000 267,722 284,978 297,254 270,743 336,865 381,125 297,417 293,430 325,718 304,117 348,738 407,686 695,622 814,924 832,646 736,482 859,094 964,745 127,989 54,183 53,698 44,748 53,698 53,698 291,673 298,327 - (32) - - - - 90,549 109,019 93,000 108,559 - - 220,364 240,754 231,172 252,792 34,372 38,862 48,214 40,954 49,150 47,000 10,043 15,095 58,883 18,675 35,000 35,000 94,724 117,203 137,071 107,325 101,984 148,285 - - - - - 10,000 13,109 5,314 1,723 5,475 8,500 7,500 - 5,246 7,770 5,494 7,806 9,400 245 226 175 361 300 300 147,301 21,478 39,452 28,320 50,360 55,300 - 60,059 25,422 33,848 42,131 134,420 32,703 8,137 9,915 4,853 17,720 15,720 112,980 113,320 127,145 126,303 160,800 173,000 4,356 6,896 5,454 5,879 9,150 9,565 - - 3,294 2,617 5,450 5,800 102,262 77,313 105,544 129,989 93,500 132,000 - - - 20,963 20,610 - 46,362 61,099 68,704 68,268 34,700 49,000 20,574 16,659 15,250 12,736 27,850 34,750 - 6,201 12,872 4,160 5,850 4,305 261,243 319,661 93,408 348,790 405,128 397,801 - 37,000 29,328 26,319 65,000 35,000 - -- 1,852 6,500 8,000 16,680 16,680 11,610 15,480 16,680 16,680 115,609 81,682 71,691 43,411 128,868 108,368 2,664 - (742) 3,161 - - 25,980 77,821 165,284 13,292 29,900 22,203 76,837 76,414 76,104 66,786 76,000 - 50040 Salaries 50041 Overtime-Special Events 50045 Overtime 50190 Employee Payroll Taxes 50200 Employee Retirement Exp 50210 Employee Medical Insurance 50215 Required Contrib-OPEB 50220 Casualty/Workers Comp Ins 50221 Workers Comp Insurance 50222 Casualty/Property Insurance 50230 Training/School/Travel 50290 Professional Services 50300 Computer Expense 50315 Camera Expense 50320 Office Supplies 50325 Printers/Copiers/OE and supp 50330 Postage 50340 General Supplies 50355 Line of Duty Equip & Supplies 50360 General Maintenance 50380 Communications 50390 Dues-Memberships-Subscrip 50395 Employment Screening 50430 Gasoline & Oil 50435 Small Equipment 50440 Equip & Vehicle Repair 50460 Uniforms 50462 Safety Wear and PPE 50470 Purchases Vehicles & Equipment 50475 Capital Improvements 50535 Community Outreach 51215 NCIC Data System 51220 Jail Expense 51235 DEA Funds Purchases 51255 Corrections Capital Imprvments 52510 Utilities for City Use Total Police Department 6,180,245 6,721,487 6,890,514 6,464,203 7,759,967 8,529,725 Page 11 of 109 Page 12 of 109 Page 13 of 109 Page 14 of 109 Page 15 of 109 Page 16 of 109 Information Technology 9/26/2022 Object Description FY 2019 Annual FY 2020 Annual FY 2021 Annual FY2022 Aug YTD FY2022 Annual Budget FY2023 Annual Budget - - 356,622 277,850 293,372 389,323 - - 35,290 25,949 14,846 15,000 - - 29,406 22,981 23,579 33,106 - - 33,333 25,741 24,413 34,683 - - 46,557 42,892 44,774 55,041 - - 383 553 570 554 - - 7,549 10,626 10,564 11,157 - - 1,337 878 4,047 6,900 - - 2,000 - 8,500 5,000 - - 73,788 251,486 526,677 565,431 - - - - - 14,832 - 575 193 559 - 1,700 - -10 - 2,000 2,000 - -44 228 - 200 - -1,840 1,446 1,000 2,000 - -303 5,437 5,000 5,000 - 81 9,554 14,425 69,870 58,660 - -574 325 2,148 2,400 - -- 103 300 300 - -- 1,284 1,050 2,000 - 10 3,030 786 1,000 500 - -519 234 300 500 - -- 70,368 71,000 270,495 - -- 12,780 29,000 - 50040 Salaries 50045 Overtime 50190 Employee Payroll Taxes 50200 Employee Retirement Exp 50210 Employee Medical Insurance 50221 Workers Comp Insurance 50222 Casualty/Property Insurance 50230 Training/School/Travel 50290 Professional Services 50300 Computer Expense 50315 Camera Expense 50320 Office Supplies 50325 Printers/Copiers/OE and supp 50330 Postage 50340 General Supplies 50360 General Maintenance 50380 Communications 50390 Dues-Memberships-Subscrip 50395 Employment Screening 50430 Gasoline & Oil 50440 Equip & Vehicle Repair 50460 Uniforms 50470 Purchases Vehicles & Equipment 50475 Capital Improvements 51030 Publications Newspapers - -268 - - - Total Information Technology - 667 602,600 766,931 1,134,009 1,476,782 Page 17 of 109 Human Resources 9/26/2022 Object Description FY 2019 Annual FY 2020 Annual FY 2021 Annual FY2022 Aug YTD FY2022 Annual Budget FY2023 Annual Budget 50040 Salaries - - - 222,608 286,151 306,060 50045 Overtime - - - 15,615 3,446 5,000 50190 Employee Payroll Taxes - - - 17,297 22,154 24,181 50200 Employee Retirement Exp - - - 17,202 21,958 23,884 50210 Employee Medical Insurance - - - 27,176 34,624 55,045 50221 Workers Comp Insurance - - - 616 200 600 50222 Casualty/Property Insurance - - - 2,226 2,400 2,337 50230 Training/School/Travel - - - 2,042 5,400 13,000 50280 Legal Fees - - - 5,767 - 15,000 50300 Computer Expense - - - 4,294 4,878 16,200 50320 Office Supplies - - - 1,490 - 3,000 50325 Printers/Copiers/OE and supp - - - 1,191 - 6,500 50340 General Supplies - - - 2,389 2,000 5,000 50380 Communications - - - 2,101 3,200 3,200 50390 Dues-Memberships-Subscrip - - - 275 500 1,900 50395 Employment Screening - - - 83 - 500 50430 Gasoline & Oil - - - 246 - 5,000 50435 Small Equipment - - - - 1,085 3,000 50440 Equip & Vehicle Repair - - - 29 - 5,000 50460 Uniforms - - - 355 - - - - - - - 500 50462 Safety Wear and PPE 50475 Capital Improvements - - - - - 20,000 Total Human Resources - - - 323,002 387,994 514,906 Page 18 of 109 Revenue Department 9/26/2022 Object Description FY 2019 Annual FY 2020 Annual FY 2021 Annual FY2022 Aug YTD FY2022 Annual Budget FY2023 Annual Budget 50040 Salaries - - 274,842 329,216 387,219 426,917 50045 Overtime - - 1,588 929 1,086 1,100 50190 Employee Payroll Taxes - - 21,021 24,315 29,705 33,141 50200 Employee Retirement Exp - - 18,608 21,915 24,988 28,938 50210 Employee Medical Insurance - - 44,112 73,247 83,850 90,513 50215 Required Contrib-OPEB - - 15,147 21,384 25,661 21,295 50221 Workers Comp Insurance - - 200 430 300 426 50222 Casualty/Property Insurance - - 3,927 7,225 4,868 7,586 50230 Training/School/Travel - - 2,310 2,210 4,750 10,500 50300 Computer Expense - - 9,612 22,348 25,535 12,943 50320 Office Supplies - - - 368 500 1,000 50325 Printers/Copiers/OE and supp - - 2,125 1,450 2,688 6,588 50330 Postage - - - - - 7,000 50340 General Supplies - - 1,056 1,243 1,250 1,250 50360 General Maintenance - - - 4 500 5,000 50380 Communications - - 3,821 1,933 11,000 8,000 50390 Dues-Memberships-Subscrip - - 25 25 100 100 50395 Employment Screening - - 475 366 - 500 50430 Gasoline & Oil - - - 614 600 1,000 50440 Equip & Vehicle Repair - - 25 37 500 500 50460 Uniforms - - 826 225 200 500 Total Revenue Department - - 399,720 509,484 605,300 664,798 Page 19 of 109 Meter Department 9/26/2022 Object Description FY 2019 Annual FY 2020 Annual FY 2021 Annual FY2022 Aug YTD FY2022 Annual Budget FY2023 Annual Budget 50040 Salaries - - - 381,180 444,610 466,726 50045 Overtime - - - 2,939 4,575 7,500 50190 Employee Payroll Taxes - - - 27,807 34,363 37,162 50200 Employee Retirement Exp - - - 29,714 36,235 39,628 50210 Employee Medical Insurance - - - 78,355 86,496 76,021 50221 Workers Comp Insurance - - - 6,778 5,225 6,679 50222 Casualty/Property Insurance - - - 8,730 11,000 9,166 50230 Training/School/Travel - - - 2,554 1,000 3,000 50300 Computer Expense - - - 3,840 5,730 10,636 50320 Office Supplies - - - 77 500 500 50340 General Supplies - - - 270 1,000 1,000 50360 General Maintenance - - - 132 - 500 50380 Communications - - - 1,122 7,600 7,600 50395 Employment Screening - - - 55 500 500 50430 Gasoline & Oil - - - 18,946 5,000 22,000 50435 Small Equipment - - - - 500 500 50440 Equip & Vehicle Repair - - - 13,974 2,500 2,500 50460 Uniforms - - - 899 2,000 2,000 50462 Safety Wear and PPE - - - 1,382 320 2,000 50470 Purchases Vehicles & Equipment - - - - 27,000 59,669 Total Meter Department - - - 578,754 676,154 755,287 Page 20 of 109 Fire Department 9/26/2022 Object Description FY 2019 Annual FY 2020 Annual FY 2021 Annual FY2022 Aug YTD FY2022 Annual Budget FY2023 Annual Budget 50040 Salaries 143,589 154,047 168,714 165,184 199,781 217,189 50045 Overtime 715 3,954 139 631 514 1,000 50090 Fire Call Payments 62,590 107,118 124,812 88,608 136,000 136,000 50190 Employee Payroll Taxes 11,001 11,816 12,407 12,251 15,323 16,964 50200 Employee Retirement Exp 12,883 12,158 13,997 13,763 16,050 17,947 50210 Employee Medical Insurance 84,848 40,118 44,475 41,646 46,008 56,538 50220 Casualty/Workers Comp Ins 54,821 44,372 - - - - 50221 Workers Comp Insurance - - 4,355 5,726 4,723 5,708 50222 Casualty/Property Insurance - - 40,604 43,062 43,008 45,215 50230 Training/School/Travel 997 540 - - 7,000 9,000 50290 Professional Services 278 671 (69) - 700 - 50300 Computer Expense 3,142 2,812 3,324 2,466 2,140 4,980 50325 Printers/Copiers/OE and supp - - 7 - 250 300 50330 Postage - - 20 - - - 50340 General Supplies 75,887 38,870 9,245 65,444 36,950 40,650 50360 General Maintenance 71,927 16,475 12,895 27,676 23,200 26,200 50380 Communications 2,138 4,012 17,078 15,023 12,600 21,900 50390 Dues-Memberships-Subscrip 8,810 9,000 - - - 9,000 50395 Employment Screening - - 76 361 200 2,200 50430 Gasoline & Oil 11,496 9,881 10,110 21,359 15,000 20,000 50435 Small Equipment - - - 480 14,586 5,500 50440 Equip & Vehicle Repair 87,879 81,320 104,076 113,896 127,510 158,100 50460 Uniforms 578 1,465 948 1,584 1,500 1,500 50462 Safety Wear and PPE 560 140 8,737 630 19,725 24,860 50470 Purchases Vehicles & Equipment 221,247 8,855 562,376 118,204 260,113 145,309 50475 Capital Improvements - - 17,283 47,826 98,800 136,500 50520 Equipment Rental - - - 4,485 - 7,476 52510 Utilities for City Use 18,508 43,631 41,651 38,969 47,500 42,500 Total Fire Department 873,892 591,253 1,197,258 829,274 1,129,180 1,152,536 Page 21 of 109 P.O. Box 626 Fairhope, AL 36533 rr� • if"0:;;;.,. FIRE�RTMENT 5 YEAR CAPITAL PURCHASE PLAN AS OF JUNE 2022 (251)990--0143www.fairhopevfd.org The aging fleet of our Fire Department is our #1 concern and priority. Below are the items that are of importance to get replaced within the next 5 years: Ladder 1: Estimated replacement cost is $1.5 million This ladder truck is a 1999 model. We have spent approximately $65,000 in repairs on this truck in the past 2 years. ARFF 932: Estimated replacement cost is $1 million for an airport truck or $500,000 for a 2000 gallon pump and roll tanker. This ARFF is a 1997 Model. The future plans of the airport would determine which apparatuswe would need to purchase. Engine 4: Estimated replacement cost is $725,000. This engine is a 2001 model. Engine 3: Estimated replacement cost is $725,000 This engine is a 1999 model. In addition to the above, we also need to replace the cascade system at Stations 1 and 4. The estimated cost to replace these is $85,000 each.' *Please note that the estimated cost for each of these items does not take in to considerationthe future unknown inflation rates. Page 22 of 109 Economic & Community Development 9/26/2022 Object Description FY 2019 Annual FY 2020 Annual FY 2021 Annual FY2022 Aug YTD FY2022 Annual Budget FY2023 Annual Budget 50040 Salaries 139,149 140,260 109,754 77,624 115,952 138,590 50045 Overtime - 3,602 - 333 - 1,000 50190 Employee Payroll Taxes 10,400 10,466 7,649 5,437 8,870 10,885 50200 Employee Retirement Exp 9,327 7,901 8,340 5,714 8,289 10,318 50210 Employee Medical Insurance 38,337 28,768 25,112 16,382 21,002 21,524 50220 Casualty/Workers Comp Ins 1,856 6,676 - - - - 50221 Workers Comp Insurance - - 2,310 859 1,900 899 50222 Casualty/Property Insurance - - 3,181 3,154 2,779 3,312 50230 Training/School/Travel 4,791 2,355 535 2,460 2,500 5,000 50290 Professional Services - 188 177 - - 5,000 50300 Computer Expense 1,535 2,144 6,520 4,338 3,013 5,537 50320 Office Supplies 1,080 1,379 2,113 855 2,000 2,000 50325 Printers/Copiers/OE and supp - - 11 51 300 300 50330 Postage 382 38 198 123 700 750 50340 General Supplies - (0) 1,630 150 - 500 50360 General Maintenance - - - - - 1,500 50380 Communications 877 1,003 37,896 1,376 1,380 2,190 50390 Dues-Memberships-Subscrip 1,437 239 239 1,618 1,475 3,000 50430 Gasoline & Oil 224 103 81 351 200 500 50440 Equip & Vehicle Repair 136 5 - - 500 500 50470 Purchases Vehicles & Equipment - 7,397 2,185 - 12,000 - 50490 Community Events 210,162 311,490 151,715 187,320 202,310 229,400 50491 Charitable Contributions 570,000 174,016 236,648 196,750 197,500 200,500 50570 Adv & Promotion 41,178 37,152 27,240 10,165 31,800 31,100 50575 Tourism 33,610 10,162 4,276 14,842 20,000 20,000 Total Economic & Community Dev 1,064,481 745,345 627,810 529,904 634,470 694,306 Page 23 of 109 Civic Center 9/26/2022 Object Description FY 2019 Annual FY 2020 Annual FY 2021 Annual FY2022 Aug YTD FY2022 Annual Budget FY2023 Annual Budget 50040 Salaries 114,627 130,400 139,570 100,628 145,394 157,553 50045 Overtime 1,723 3,577 691 1,438 1,126 1,500 50190 Employee Payroll Taxes 8,485 9,769 10,418 7,822 11,209 12,283 50200 Employee Retirement Exp 10,312 10,005 11,437 8,713 11,716 12,574 50210 Employee Medical Insurance 57,321 27,958 32,103 27,204 32,002 37,048 50220 Casualty/Workers Comp Ins 2,029 4,508 - - - - 50221 Workers Comp Insurance - - 3,075 3,760 3,300 3,748 50222 Casualty/Property Insurance - - 3,209 3,263 3,284 3,427 50230 Training/School/Travel - 52 70 - - - 50290 Professional Services 565 180 152 - 300 - 50300 Computer Expense 2,964 4,048 6,335 3,505 2,820 7,391 50320 Office Supplies 301 868 219 75 1,000 1,000 50325 Printers/Copiers/OE and supp - 463 406 481 507 600 50330 Postage - - - - 100 - 50340 General Supplies 30,644 13,206 2,181 5,089 4,200 6,000 50360 General Maintenance 17,961 23,884 10,939 20,520 15,000 25,000 50380 Communications - 474 1,334 748 5,141 3,100 50395 Employment Screening - - - - 200 - 50430 Gasoline & Oil 118 53 31 - 300 500 50440 Equip & Vehicle Repair 1,806 512 1,088 1,113 1,500 1,000 50460 Uniforms - - - - 700 700 50462 Safety Wear and PPE - 1,065 360 - 500 500 50475 Capital Improvements - 52,192 55,539 - 152,420 508,638 52510 Utilities for City Use 28,345 23,239 23,380 19,294 28,000 - Total Civic Center 277,202 306,452 302,536 203,654 420,720 782,562 Page 24 of 109 Museum/Welcome Center 9/26/2022 Object Description FY 2019 Annual FY 2020 Annual FY 2021 Annual FY2022 Aug YTD FY2022 Annual Budget FY2023 Annual Budget 50040 Salaries 84,679 81,418 102,596 85,285 105,452 108,842 50045 Overtime 1,632 650 23 315 15 500 50190 Employee Payroll Taxes 6,485 6,157 10,208 9,709 8,068 8,347 50200 Employee Retirement Exp 6,832 5,154 6,586 5,438 6,534 6,827 50210 Employee Medical Insurance 7,479 9,763 11,692 8,950 11,682 6,114 50220 Casualty/Workers Comp Ins 7,585 9,502 - - - - 50221 Workers Comp Insurance - - 1,779 2,326 1,800 2,309 50222 Casualty/Property Insurance - - 8,018 8,895 8,358 9,340 50230 Training/School/Travel 86 52 35 - 500 500 50290 Professional Services 5,140 156 152 - 300 - 50300 Computer Expense 3,317 5,706 7,026 6,007 1,951 5,222 50325 Printers/Copiers/OE and supp - 823 2,627 1,894 2,396 4,700 50340 General Supplies 9,811 5,254 10,269 5,858 12,500 12,500 50360 General Maintenance 8,774 21,642 13,077 32,645 19,000 25,900 50380 Communications - 704 2,162 1,197 3,900 3,900 50390 Dues-Memberships-Subscrip - - 230 - 330 300 50395 Employment Screening - - - 76 200 - 50440 Equip & Vehicle Repair - - 2,994 - - - 50462 Safety Wear and PPE - - - - - 500 50470 Purchases Vehicles & Equipment 9,749 - - - - - 50475 Capital Improvements - - 19,626 28,826 28,000 5,000 52510 Utilities for City Use 14,251 9,460 9,279 9,848 10,000 - Total Museum/Welcome Center 165,819 156,440 208,379 207,269 220,986 200,801 Page 25 of 109 Adult Recreation 9/26/2022 Object Description FY 2019 Annual FY 2020 Annual FY 2021 Annual FY2022 Aug YTD FY2022 Annual Budget FY2023 Annual Budget 50040 Salaries 162,819 146,233 121,242 160,781 208,219 223,216 50045 Overtime 1,310 329 272 1,578 2,117 2,000 50190 Employee Payroll Taxes 12,493 11,101 12,800 13,279 16,091 22,483 50200 Employee Retirement Exp 9,138 8,961 8,870 11,638 15,165 18,251 50210 Employee Medical Insurance 48,535 23,273 9,838 13,184 18,571 17,674 50220 Casualty/Workers Comp Ins 20,697 18,346 - - - - 50221 Workers Comp Insurance - - 3,403 3,898 3,200 3,876 50222 Casualty/Property Insurance - - 12,444 14,838 12,565 15,579 50230 Training/School/Travel - 52 280 - 300 500 50290 Professional Services 400 277 152 950 500 25,000 50300 Computer Expense 2,411 5,992 10,884 3,428 4,387 7,921 50320 Office Supplies - - 4,753 4,033 5,000 5,000 50325 Printers/Copiers/OE and supp - 338 1,617 1,502 2,589 2,000 50340 General Supplies 13,330 7,757 9,385 10,656 12,000 14,000 50360 Nix Center Maintenance 24,778 21,162 30,767 18,397 25,000 30,000 50380 Communications - 1,052 2,913 2,184 3,500 3,500 50390 Dues-Memberships-Subscrip - - 486 1,496 500 500 50395 Employment Screening - - 156 504 400 - 50430 Gasoline & Oil 344 124 1,753 1,074 400 2,000 50440 Equip & Vehicle Repair 223 37 1,217 1,888 500 - 50462 Safety Wear and PPE - - - - - 150 50470 Purchases Vehicles & Equipment 45,557 4,038 - - - - 50475 Capital Improvements - - 119,742 81,208 354,250 273,000 50560 Credit Card Processing Fees 868 763 1,215 957 800 - 51155 Welcome Center Maintenance - - - 35 - - 51355 Kitchen Supplies 2,425 1,528 2,447 2,154 2,500 2,500 51360 Special Programs 3,611 1,105 2,200 1,566 3,500 2,000 51365 Dance Expense 8,420 3,700 2,132 4,425 6,000 6,000 51375 Office Expense 11,241 3,795 - - - - 51385 Shuttle Bus Expense 2,402 975 229 - 1,000 5,000 52510 Utilities for City Use 104,272 121,592 108,648 103,238 122,000 - Total Adult Recreation 475,272 382,530 469,844 458,886 821,053 682,150 Page 26 of 109 Community Events Organization Object Amount Description Justification 001240 50490 1,500.00$ Arbor Day Tent Rental$600 Plaques$300 Poster and Framing $300 Banners/Print Materials/Prizes$100 Tree Labels$100 001240 50490 1,000.00$ Fairhope Junior City Council General Supplies 001240 50490 10,500.00$ Christmas Parade Christmas Candy Throws $3,000 Misc Christmas Throws for Mayor $1,000 Food for Volunteers $400 Portables $600 Towable Lights $800 Signage $100 DecoraƟons Welcome Center $500 Christmas Volunteer GiŌs $3,000 Note Cards for Volunteers $300 Float DecoraƟons $500 001240 50490 1,200.00$ Community Cleanup Misc Supplies and Volunteer Food 001240 50490 4,000.00$ Community Shredding Shredder Truck for Earth Day2000 Shredder Truck for America Recycles Day 2000 001240 50490 7,000.00$ Earth Day Anti Litter Stage and Tent Rental $1500 Posters, Flyers, Pole Banner Update $200 Tshirts $4,000 Portables $700 Poster Framing $100 Other supplies $300 001240 50490 6,500.00$ Outdoor Farmers Market Spring & Fall Market Entertainment Activities $5500 Posters $100 Banner $500 Umbrellas $300 Total $1,400 001240 50490 13,000.00$ Holiday Decorations Holiday DecoraƟons Christmas DecoraƟons $10,000 Downtown Trick or Treat $1500 Easter Bunny $1000 Christmas Tree for PD/ city buildings $500 001240 50490 48,500.00$ 4th of July Portables $2,500 Fireworks $40,000 Tent Rentals $500 Backup Stage $3,000 Sound reinforcement $1,200 Decorations $1000 001240 50490 4,500.00$ Mardi Gras Portables $2000 Light Rental $1000 Welcome Center Decorations $1000 Beads/Moonpies $500 001240 50490 1,000.00$ Mayors Prayer Breakfast 001240 50490 2,000.00$ Glow in the Park Outdoor movie screen and audio $800 Glow supplies $750 Decorations $500 001240 50490 31,500.00$ New Years Eve Celebration Portables $500 Fireworks $10,000 Stage $4000 Children's DJ $500 Kids Entertainment/Childrens supplies $2,000 Main Stage Entertainment $10,000 Hydraulic Crane $2000 Generator $500 001240 50490 5,000.00$ State of the City Design and printed materials, food, giveaways, and video Misc Contract WriƟng/ Booklet Design Update Misc Supplies Food Page 27 of 109 Community Events Organization Object Amount Description Justification 001240 50490 83,000.00$ Tree Lighting Includes $70k - this is for actual LED lights ProducƟon Services (Stage, Snow Machines, LighƟng, Audio) $11,000 Entertainment $1,000 Signage, NO PARKING $500 Food $500 Mrs. Claus House Supplies $1200 Portables $200 001240 50490 1,200.00$ Veterans Day Plaque/ Car Magnet $200 Food for RecepƟon $750 Wreath for Memorial Fountain $150 Supplies for RecepƟon/Parade $100 Sounds and Lights for Sunset Prayer Service $400 001240 50490 4,000.00$ Volunteer Week Fish Fry Food, Supplies, Plaque $4000 001240 50490 4,000.00$ Sunset Concerts Leonard Houston 229,400.00$ Page 28 of 109 Charitable Contributions Organization Object FY 2022 FY 2023 Description Letter Submitted Justification 001240 50491 $3,000.00 $3,000.00 Baldwin Pops Concert Fee No request was submitted. This amount is in addition to in-kind services. Original request $2k, increased to $3k per Mayor 001240 50491 $20,000.00 $20,000.00 Downtown Fairhope Business Association Letter Submitted 2022 001240 50491 $20,000.00 $20,000.00 Eastern Shore Art Center 2021 requested $24k which was cut to $20k Letter Submitted 2022 001240 50491 $21,000.00 $20,000.00 Eastern Shore Chamber of Commerce Letter submitted 2022 001240 50491 $2,000.00 $2,000.00 Eastern Shore Optimist Club/Dogwood Trail Pageant & Scholarship Program In-kind services for use of the Civic Center 001240 50491 $10,000.00 $10,000.00 Ecumenical Ministries Letter Submitted 2022 001240 50491 $6,000.00 $6,000.00 Fairhope Film Festival 2021: Letter submitted for $10k, City Council cut to $6k 2022 Letter Submitted 001240 50491 $10,000.00 $10,000.00 Pirate Booster Club 2021: Requested $11k; Mayor cut to $10k 001240 50491 $1,000.00 $0.00 United Way of Baldwin County Cut per Mayor 001240 50491 $15,000.00 $15,000.00 Mobile Bay NEP Letter Submitted 2022 001240 50491 $57,000.00 $57,000.00 Rotary Youth $50,000 - Rotary Youth appropriation $2,000 - not-to-exceed amount for supplies (cleaning, sanitizing, etc) Mayor added an additional $5k 001240 50491 $20,000.00 $20,000.00 Baldwin County Economic Development Alliance Letter Submitted 2022 001240 50491 $2,500.00 $2,500.00 Misc Golf (FEEF)In-kind Services at Quail Creek 001240 50491 $5,000.00 $5,000.00 Walking School Bus 2022 requested $30k and Mayor reduced to $5K 2022 Letter submitted 001240 50491 $5,000.00 $5,000.00 Baldwin County Child Advocacy Center / CARE House, Inc 2021 $5,000 Letter Submitted 2022 001240 50491 $0.00 $0.00 Neighborhood Bridges Letter Submitted 2022 *NEW REQUEST* Cut per Mayor 001240 50491 $0.00 $0.00 Exceptional Foundation Gulf Coast Letter Submitted 2022 *NEW REQUEST* Cut per Mayor 001240 50491 $0.00 $5,000.00 Safe Harbor, LLC Trap, Spay, Neuter in Fairhope Letter Submitted 2022 *NEW REQUEST* Total: $197,500.00 $200,500.00 Page 29 of 109 Appropriation 9/26/2022 Object Description FY 2019 Annual FY 2020 Annual FY 2021 Annual FY2022 Aug YTD FY2022 Annual Budget FY2023 Annual Budget 51820 Public Library-Approp. 818,477 859,401 816,431 787,417 859,000 875,000 51870 The Haven 65,000 65,000 82,500 137,500 150,000 150,000 51880 Airport Appropriation - - 15,000 - - - 51890 Airport Appropriation-Debt Svc 320,000 320,000 320,000 293,333 320,000 320,000 51895 Baldwin County Board of Educat - - 75,000 63,800 75,000 75,000 51900 Baldwin Co. Transit Hub 27,600 26,680 31,740 26,450 27,600 31,740 Total Appropriation 1,231,077 1,271,081 1,340,671 1,308,500 1,431,600 1,451,740 Page 30 of 109 Appropriations Organization Object Account Description 2023 Budget 2022 Budget 2021 Budget 2020 Budget 001800 51820 Public Library Appropiation 875,000$ 859,000$ 816,431$ 859,401$ 001800 51870 The Haven 150,000$ 150,000$ 82,500$ 65,000$ 001800 51880 Airport Appropriation -$ -$ -$ -$ 001800 51890 Airport Appropriation-Debt Svc 320,000$ 320,000$ 320,000$ 320,000$ 001800 51895 Baldwin County Board of Education 75,000$ 75,000$ 75,000$ -$ 001800 51900 Baldwin County Transit Hub 31,740$ 27,600$ 27,600$ 27,600$ Total Appropriations: 1,451,740$ 1,431,600$ 1,321,531$ 1,272,001$ Page 31 of 109 Recreation Department 9/26/2022 Object Description FY 2019 Annual FY 2020 Annual FY 2021 Annual FY2022 Aug YTD FY2022 Annual Budget FY2023 Annual Budget 50040 Salaries 1,081,879 1,096,284 1,054,705 947,755 1,419,367 1,638,096 50045 Overtime 17,376 24,680 25,511 31,529 20,201 25,000 50190 Employee Payroll Taxes 82,220 83,796 84,518 74,123 110,127 128,983 50200 Employee Retirement Exp 59,000 56,644 64,613 58,978 65,054 79,659 50210 Employee Medical Insurance 97,240 220,321 214,276 190,561 208,961 240,418 50215 Required Contrib-OPEB - 5,821 5,821 4,851 5,821 5,821 50220 Casualty/Workers Comp Ins 88,234 87,163 - - - - 50221 Workers Comp Insurance - - 25,479 28,080 25,200 28,004 50222 Casualty/Property Insurance - - 70,687 72,167 75,680 75,775 50230 Training/School/Travel 2,781 1,018 331 1,632 2,500 2,000 50290 Professional Services 9,609 29,210 304 - 5,000 15,000 50300 Computer Expense 11,081 17,540 12,241 13,944 20,609 28,832 50320 Office Supplies - - - 280 - 500 50325 Printers/Copiers/OE and supp - 2,454 1,646 1,753 2,201 2,201 50330 Postage - - 30 84 - - 50340 General Supplies 197,571 175,496 191,488 172,127 145,000 175,000 50360 General Maintenance 102,911 99,505 107,468 102,367 95,000 110,000 50380 Communications 1,547 3,906 7,006 6,766 7,600 9,500 50390 Dues-Memberships-Subscrip 100 300 110 1,095 300 1,000 50395 Employment Screening - - 2,235 1,566 3,500 2,000 50430 Gasoline & Oil 15,215 9,423 13,073 16,362 14,000 16,350 50440 Equip & Vehicle Repair 25,471 10,686 25,403 11,293 20,000 20,000 50460 Uniforms 2,715 2,375 5,161 4,676 2,750 2,750 50462 Safety Wear and PPE - - 140 - 1,000 1,000 50470 Purchases Vehicles & Equipment 161,221 48,458 35,478 65,346 42,000 87,732 50475 Capital Improvements - 118,853 459,982 184,164 186,340 221,000 50485 Tennis Expense 14,472 22,404 16,576 16,478 10,000 15,000 50520 Equipment Rental - 4,104 11,785 10,010 5,000 10,000 50525 Cost-Tennis Shop Sales 4,435 2,919 3,526 6,990 3,000 3,500 50560 Credit Card Processing Fees 5,944 4,598 7,177 7,536 5,660 7,000 51315 Pool Supplies - 2,652 17,208 25,338 15,000 25,000 52510 Utilities for City Use 340,163 313,473 337,077 264,167 230,000 - 55825 Spec Rec Projects 2,460 - - - - - Total Recreation Dept 2,323,644 2,444,085 2,801,053 2,322,019 2,746,871 2,977,122 Page 32 of 109 Marina/Harbor 9/26/2022 Object Description FY 2019 Annual FY 2020 Annual FY 2021 Annual FY2022 Aug YTD FY2022 Annual Budget FY2023 Annual Budget 50040 Salaries 96,657 113,245 122,691 113,029 128,069 135,373 50045 Overtime 1,371 3,406 1,989 2,557 1,002 1,000 50190 Employee Payroll Taxes 7,393 8,635 9,109 8,341 9,874 10,633 50200 Employee Retirement Exp 5,546 6,969 9,210 9,250 9,987 10,907 50210 Employee Medical Insurance 4,663 26,691 26,859 25,166 27,465 27,465 50220 Casualty/Workers Comp Ins 2,520 6,930 0 0 0 0 50221 Workers Comp Insurance 0 0 2,516 3,086 2,650 3,073 50222 Casualty/Property Insurance 0 0 9,197 7,935 4,601 9,874 50230 Training/School/Travel 0 26 0 0 0 0 50290 Professional Services 5,919 10,463 76 0 8,000 0 50300 Computer Expense 1,494 1,079 6,541 3,208 6,928 10,744 50320 Office Supplies 538 362 316 0 400 400 50325 Printers/Copiers/OE and supp 0 104 302 273 320 320 50330 Postage 0 0 0 44 0 0 50340 General Supplies 10,747 14,999 2,990 11,052 19,689 15,000 50360 General Maintenance 299,925 12,096 16,246 59,323 20,000 20,000 50380 Communications 1,687 858 1,254 1,909 3,280 6,640 50395 Employment Screening 0 0 0 0 300 0 50415 Cost - Ship Store Sales 2,148 1,033 539 351 2,000 500 50425 Diesel 54,317 37,361 26,146 72,678 23,200 70,800 50430 Gasoline & Oil 114,548 194,138 296,299 392,718 239,000 353,700 50440 Equip & Vehicle Repair 1,542 5,362 3,091 42 3,000 3,000 50460 Uniforms 260 188 337 161 400 400 50470 Purchases Vehicles & Equipment 0 54,835 0 22,178 28,750 0 50475 Capital Improvements 0 44,038 0 374,822 223,000 240,000 50560 Credit Card Processing Fees 10,485 15,538 20,004 16,904 15,000 15,000 52510 Utilities for City Use 18,350 17,397 13,746 9,817 17,000 13,000 Total Marina/Harbor 640,110 575,752 569,456 1,134,846 793,915 947,829 Page 33 of 109 Street Department 9/26/2022 Object Description FY 2019 Annual FY 2020 Annual FY 2021 Annual FY2022 Aug YTD FY2022 Annual Budget FY2023 Annual Budget 50040 Salaries 1,709,420 1,941,868 2,040,502 1,712,930 2,109,857 2,501,317 50045 Overtime 57,956 144,592 142,486 136,029 142,583 120,000 50190 Employee Payroll Taxes 131,312 155,339 165,072 137,141 172,312 207,063 50200 Employee Retirement Exp 145,018 157,717 169,850 146,661 168,944 213,064 50210 Employee Medical Insurance 454,244 466,369 461,346 375,539 440,773 536,757 50215 Required Contrib-OPEB 56,212 32,799 66,587 58,410 84,110 70,092 50220 Casualty/Workers Comp Ins 126,793 121,608 - - - - 50221 Workers Comp Insurance - - 75,103 104,479 91,000 104,115 50222 Casualty/Property Insurance - - 84,910 92,351 92,050 98,016 50230 Training/School/Travel 4,716 5,178 5,425 8,320 10,000 12,000 50290 Professional Services 40,785 39,656 25,971 16,749 25,000 15,000 50300 Computer Expense 11,646 7,606 9,833 8,543 9,626 8,518 50325 Printers/Copiers/OE and supp - 553 1,049 1,130 2,026 1,500 50330 Postage 37 - 11 172 - - 50340 General Supplies 114,393 91,735 111,539 130,803 100,000 110,000 50360 General Maintenance 45,816 32,581 53,413 33,450 72,250 50,000 50380 Communications 8,039 12,760 22,650 20,364 35,864 43,500 50390 Dues-Memberships-Subscrip - 328 720 840 1,200 1,200 50395 Employment Screening - - 2,056 2,117 2,700 3,000 50430 Gasoline & Oil 88,827 60,791 84,481 99,027 72,900 105,600 50435 Small Equipment - - 65 316 8,200 7,000 50440 Equip & Vehicle Repair 160,465 130,709 178,523 178,706 125,000 160,000 50460 Uniforms 15,755 5,186 7,733 14,532 10,000 10,000 50462 Safety Wear and PPE 280 4,481 6,143 509 10,520 9,880 50470 Purchases Vehicles & Equipment 470,101 50,989 173,807 297,737 411,924 750,904 50475 Capital Improvements - 38,163 122,862 240,507 13,000 110,000 50520 Equipment Rental 2,202 5,519 13,891 11,197 8,000 10,000 50955 Transfers-Debt Svc Fund - 175,697 175,697 71,887 175,698 - 51170 Beach Repairs and Maint - - 71,781 13,448 58,000 55,000 51400 Flowers 81,142 109,937 106,565 122,802 125,000 131,250 51410 St Material & Landscaping 310,931 300,088 325,054 319,424 306,000 325,000 51420 Sidewalks 10,776 15,549 14,564 23,101 65,000 75,000 52510 Utilities for City Use 143,356 143,831 155,074 132,148 115,000 144,000 Total Street Department 4,190,222 4,251,628 4,874,764 4,511,368 5,064,538 5,988,776 Page 34 of 109 Fleet Maintenance 9/26/2022 Object Description FY 2019 Annual FY 2020 Annual FY 2021 Annual FY2022 Aug YTD FY2022 Annual Budget FY2023 Annual Budget 50040 Salaries 326,822 363,124 380,787 355,053 440,672 456,481 50045 Overtime 2,983 12,789 10,478 10,573 8,646 9,000 50190 Employee Payroll Taxes 24,496 27,761 28,912 27,235 34,373 36,238 50200 Employee Retirement Exp 25,908 27,070 31,566 29,517 35,868 37,410 50210 Employee Medical Insurance 46,988 82,905 88,352 86,364 108,027 97,923 50215 Required Contrib-OPEB 28,574 14,018 14,018 11,682 14,018 14,018 50220 Casualty/Workers Comp Ins 8,861 13,625 - - - - 50221 Workers Comp Insurance - - 10,098 12,985 11,000 12,974 50222 Casualty/Property Insurance - - 8,444 9,579 8,939 10,058 50230 Training/School/Travel - 26 330 - 3,000 9,500 50290 Professional Services 170 180 76 - - - 50300 Computer Expense 3,079 4,392 3,025 1,810 2,231 3,593 50325 Printers/Copiers/OE and supp - 410 917 593 1,200 800 50340 General Supplies 84,216 52,324 53,568 48,664 55,000 60,000 50360 General Maintenance 8,615 9,636 4,561 13,122 9,700 10,000 50380 Communications 390 1,197 2,211 1,449 4,000 4,600 50395 Employment Screening - - 154 75 200 400 50430 Gasoline & Oil 5,048 11,584 6,708 7,292 7,500 8,400 50440 Equip & Vehicle Repair 11,064 6,679 6,561 13,783 8,500 11,500 50460 Uniforms 2,637 1,968 1,369 1,813 2,660 4,450 50462 Safety Wear and PPE - 420 888 400 960 4,080 50470 Purchases Vehicles & Equipment 30,288 4,799 - - 114,000 - 50475 Capital Improvements - - - 69,787 - 8,000 52510 Utilities for City Use - 5,894 5,920 6,692 5,000 7,500 Total Fleet Maintenance 610,138 640,802 658,942 708,466 875,494 806,925 Page 35 of 109 Golf Department 9/26/2022 Object Description FY 2019 Annual FY 2020 Annual FY 2021 Annual FY2022 Aug YTD FY2022 Annual Budget FY2023 Annual Budget REVENUES 44510 Memberships 192,922 193,558 235,474 179,974 210,000 210,000 44520 Green Fees 189,173 182,758 221,700 201,558 185,000 210,000 44530 Cart Rentals 375,194 371,744 461,825 406,803 400,000 440,000 44540 Pro Shop Sales 97,297 77,386 109,068 101,497 100,000 100,000 44545 Pro Shop Sales - Custom Order 18,003 6,124 4,331 19,603 12,500 22,500 44550 Driving Range 51,308 46,725 71,736 65,099 60,000 70,000 44560 Beverage Sales 67,681 67,567 93,582 82,736 80,000 95,000 44570 Food Sales 62,340 50,236 68,568 75,180 60,000 84,000 44590 Patio Rentals and Events - 350 - - 1,000 500 49020 Handicap Fees 6,733 4,852 6,607 5,970 6,000 6,000 Total Revenues 1,060,650 1,001,299 1,272,891 1,138,419 1,114,500 1,238,000 EXPENSES [50040,5Salaries 319,541 320,107 330,834 296,945 449,396 489,514 50045 Overtime 7,651 8,180 10,333 10,144 6,900 8,000 50190 Employee Payroll Taxes 24,895 25,050 27,798 23,353 34,907 38,606 50200 Employee Retirement Exp 14,909 12,855 11,785 9,001 20,724 25,100 50210 Employee Medical Insurance 120,228 51,983 37,235 36,736 45,298 55,989 50215 Required Contrib-OPEB 28,574 33,858 18,652 9,702 45,480 6,791 50220 Casualty/Workers Comp Ins 15,397 21,564 - - - - 50221 Workers Comp Insurance - - 5,492 5,065 4,400 5,045 50222 Casualty/Property Insurance - - 13,927 15,921 16,000 16,717 50230 Training/School/Travel - 212 235 140 1,200 2,000 50290 Professional Services 1,958 447 152 - 1,575 17,600 50300 Computer Expense 3,764 12,701 6,644 6,691 5,608 11,817 50325 Printers/Copiers/OE and supp - 2,407 4,014 2,909 6,838 9,000 50330 Postage 99 - 44 22 300 300 50340 General Supplies 0 (0) 14,438 10,747 19,958 12,500 50350 Supplies-Clubhouse 20,318 7,026 2,198 4,755 9,000 - 50360 General Maintenance 15,273 12,499 7,871 6,803 12,000 10,000 50380 Communications 4,774 1,825 2,606 1,995 6,400 15,764 50390 Dues-Memberships-Subscrip 3,515 455 2,152 779 4,025 5,650 50395 Employment Screening - - 676 449 1,500 1,500 50430 Gasoline & Oil - - - - 2,808 2,800 50435 Small Equipment - - - 3,044 1,138 7,100 50440 Equip & Vehicle Repair 1,824 18 1,000 978 4,250 8,000 50460 Uniforms 1,898 1,664 348 1,120 1,352 2,500 50462 Safety Wear and PPE - - - - 150 1,800 50470 Purchases Vehicles & Equipment 7,082 - - 280 - 47,591 50475 Capital Improvements - 37,700 - - 98,750 18,000 50523 Equipment Rental Lease - 27,988 55,221 50,697 55,135 55,200 50560 Credit Card Processing Fees 16,285 16,830 23,801 20,078 17,000 15,600 50570 Adv & Promotion 8,454 5,574 5,900 125 6,850 8,500 52510 Utilities for City Use 32,945 30,752 26,537 27,439 32,000 35,000 54510 Purchases-Beer, Wine 29,969 32,336 44,239 36,798 40,000 65,000 54530 Purchases-Food 40,951 38,624 40,798 47,589 45,000 84,000 54535 Supplies-Grill 17,008 19,431 26,287 16,890 21,000 21,000 54540 Cost-Pro Shop Sales 57,280 51,701 86,182 65,568 81,280 100,000 54545 Pro Shop-Custom Orders 19,757 2,107 12,926 23,327 12,500 22,500 814,348 775,891 820,323 736,089 1,110,722 1,226,485 Grounds [50040,5Salaries 316,180 354,503 366,966 287,648 381,638 444,313 50045 Overtime 1,638 6,596 3,007 2,625 5,895 4,000 50190 Employee Payroll Taxes 23,446 26,628 27,353 26,547 29,646 34,892 50200 Employee Retirement Exp 24,891 25,741 29,610 22,905 29,902 34,629 50210 Employee Medical Insurance 120,296 111,965 109,963 95,481 107,714 112,439 50215 Required Contrib-OPEB 13,944 - - - - - 50220 Casualty/Workers Comp Ins 21,229 22,365 - - - - Page 36 of 109 Golf Department 9/26/2022 Object Description FY 2019 Annual FY 2020 Annual FY 2021 Annual FY2022 Aug YTD FY2022 Annual Budget FY2023 Annual Budget 50221 Workers Comp Insurance - - 5,722 5,456 4,800 5,438 50222 Casualty/Property Insurance - - 15,214 15,659 16,132 16,335 50230 Training/School/Travel 300 131 480 140 - 3,000 50290 Professional Services 11,635 459 38 - - - 50300 Computer Expense - 1,616 2,564 7,483 - 5,454 50325 Printers/Copiers/OE and supp - - 3 - - - 50340 General Supplies 80,048 73,907 69,774 53,041 75,000 95,000 50360 General Maintenance 12,760 4,601 7,688 22,225 17,500 12,500 50380 Communications 425 891 975 548 1,000 17,010 50395 Employment Screening - - - 151 1,000 1,000 50430 Gasoline & Oil 13,834 10,385 11,583 18,547 15,000 18,000 50440 Equip & Vehicle Repair 27,043 27,821 24,493 26,129 30,000 42,500 50460 Uniforms 1,889 1,836 2,487 2,693 2,000 3,000 50462 Safety Wear and PPE - - 820 - 1,260 1,700 50470 Purchases Vehicles & Equipment 28,020 25,644 16,200 102,560 198,000 146,271 50475 Capital Improvements - - 21,080 12,989 - 148,300 50523 Equipment Rental Lease - 69,819 78,191 - 23,273 - 52510 Utilities for City Use 21,914 25,200 25,924 20,630 25,000 - 719,492 790,108 820,134 723,457 964,761 1,145,781 Total Golf Dept Expenses 1,533,840 1,566,000 1,640,457 1,459,546 2,075,483 2,372,266 Excess Revenue of Expenses (473,190) (564,700) (367,567) (321,128) (960,983) (1,134,266) Page 37 of 109 Non-Departmental Facilities 9/26/2022 Object Description FY 2019 Annual FY 2020 Annual FY 2021 Annual FY2022 Aug YTD FY2022 Annual Budget FY2023 Annual Budget 50270 Audit & Accounting - - 927 - - - 50373 Library capital purchases - - 8,644 84,392 79,482 250,000 50374 Library Utilities - - 175,086 177,507 210,000 210,000 50375 Library Bldg Maint/Equipment - - 53,278 22,675 110,000 15,925 50376 Library Communications - - 20,398 5,886 8,492 8,492 50377 Parking Garage Maintenance - - 15,760 9,034 12,500 12,500 50383 Boys & Girls Club captl purch - - - 12,980 8,000 - 50384 Boys and Girls Club utilities - - 14,757 12,228 11,000 16,000 50385 Boys and Girls Club Maint/Equ - - 5,021 6,429 4,000 6,500 50386 USA-Summit Bldg Capital Purch - - 27,650 9,348 5,100 - 51130 Haven Maintenance - - 6,635 8,808 25,000 10,000 51135 Haven Utilities - - 9,331 8,845 14,000 12,000 51136 Haven Communications - - 1,167 1,195 - 2,400 51140 K-1 Center Maintenance - - 1,225 255 5,000 5,000 Total Non-Departmental Facilities - - 339,878 359,582 492,574 548,817 Page 38 of 109 Other Expenditures 9/26/2022 Object Description FY 2019 Annual FY 2020 Annual FY 2021 Annual FY2022 Aug YTD FY2022 Annual Budget FY2023 Annual Budget 50910 Transfers to Sanitation Fund - - - 305,092 305,092 738,120 50965 Transfers-Cap Proj Fund 1,143,500 118,337 1,088,698 620,000 1,620,000 375,000 52096 Transfers Out-Muni Cap Impr Fd - 906,107 - - - - 55520 Airport Grant Expense - 743,081 719,100 56,992 100,000 100,000 Total Other Expenditures 1,143,500 1,767,525 1,807,798 676,992 1,720,000 1,213,120 Page 39 of 109 Page 40 of 109 Page 41 of 109 Page 42 of 109 Page 43 of 109 State Gas Tax Fund 9/26/2022 Object Description FY 2019 Annual FY 2020 Annual FY 2021 Annual FY2022 Aug YTD FY2022 Annual Budget FY2023 Annual Budget REVENUES 45010 2% Petroleum Inspect Fee 7,394 6,982 7,140 7,934 7,000 7,000 45020 7 cent Gas Excise Tax 46,405 43,625 44,724 49,568 43,000 45,000 45030 4 cent Gas Excise Tax 26,944 25,281 25,920 28,741 25,000 26,000 45040 5% Gas Excise Tax 15,376 14,520 15,022 16,756 15,000 15,000 TOTAL REVENUES 96,118 90,408 92,806 102,998 90,000 93,000 EXPENSES 55010 Street Matl/Construction 77,561 1,799 - - - - 55020 Trans/cap proj - road const - 81,227 132,500 - 90,000 93,000 TOTAL EXPENSES 77,561 83,026 132,500 - 90,000 93,000 Excess Rev Over Expense 18,557 7,382 (39,694) 102,998 - - Page 44 of 109 Rebuild Alabama Fund 9/26/2022 Object Description FY 2019 Annual FY 2020 Annual FY 2021 Annual FY2022 Aug YTD FY2022 Annual Budget FY2023 Annual Budget REVENUES 45050 Gas Tax Revenue-Rebuild AL - 64,457 102,334 99,977 85,000 100,000 45055 Diesel Tax Revenue-Rebuild AL - 19,818 34,291 35,370 28,600 30,000 49010 Interest Earned - - 31 456 - - TOTAL REVENUES - 84,275 136,657 135,803 113,600 130,000 EXPENSES 50580 Fees, Bank, Etc. - 45 - - - - 55020 Trans/cap proj - road const - - 75,000 - 113,600 130,000 TOTAL EXPENSES - 45 75,000 - 113,600 130,000 Excess Rev Over Expenses - 84,230 61,657 135,803 - - Page 45 of 109 Capital Projects Fund 9/26/2022 Object Description FY 2019 Annual FY 2020 Annual FY 2021 Annual FY2022 Aug YTD FY2022 Annual Budget FY2023 Annual Budget REVENUE 40835 Federal Grants 57,853 24,240 5,094 - 1,470,500 2,968,529 41336 Community/Specl Projct Grants - - 20,000 - 650,000 650,000 41880 NRCS GRANT INCOME - - 27,129 616,351 523,310 - 45635 Grant income-ALDOT 235,835 484,171 59,591 - 551,040 496,780 46005 Hurricane Nate Reimbursement 153,691 90,644 14,985 - - - 49010 Interest Earned 5,349 9,701 284 1,020 500 2,000 49810 Transfers from Gen Fund 1,143,500 118,337 1,088,698 620,000 1,620,000 375,000 49890 Transfers from Gas tax fund - 81,227 132,500 - - 93,000 49892 Transfers In-Gas Fund - - 36,125 - 181,131 - 49894 Transfers In-Rebuild AL Fund - - 75,000 - 126,786 130,000 49895 Transfers from Impact Fee Fund 250,000 325,000 1,176,263 617,700 1,863,285 1,792,087 49896 Transfers In-Muni Cap Impr Fun - - 304,080 437,206 437,208 - 49998 Budget Rollover - - - - 685,170 2,233,225 TOTAL REVENUES 1,846,228 1,133,320 2,939,750 2,292,276 8,108,930 8,740,621 EXPENSES 52115 NRCS-EWP-Quail Creek - - 17,579 411,171 399,703 - 52120 NRCS-EWP-Fairwood Drive - - 10,000 - - - 52125 NRCS-EWP-North Summit Drive - - 23,200 789,413 470,000 - 55600 Library Project - - - - - - 55775 Rock Creek Stabilization Proj 646,579 - 41,300 - - - 55838 ATRIPResFhopAve181toBancroft - 38,351 - - - - 55853 Drainage Improvements 118,974 181,699 0 119,297 50,000 320,000 55856 City wide street resurf/misc 243,975 407,225 511,908 124,743 507,917 623,000 55858 TAP-Rock Creek Trail 35,484 14,689 - - - - 55859 BRATS Hub Transit Shelter 57,250 30,300 6,368 - 1,152,950 1,687,711 55862 Pool Building Facade 3,998 - - - - - 55867 Fly Creek Marina Seawall - 343,863 - - - - 55869 Clubhouse Repairs 57,202 - - - - - 55870 Library Repairs 986,365 - - - - - 55871 CR 13 Sedge to Manley Sidewalk 178,831 469,257 1,924 - - - 55872 Restrooms North Beach 101,002 17,130 - - - - 55877 US98 & CR13 Sidewalks 155,135 238,344 - 3,025 - - 55878 MPO Gayfer Greeno Turnlanes - 17,332 74,489 - 688,801 620,975 55881 Roundabout at 104 and Section - - - - 95,000 137,714 55882 Boys and Girls Club playground - - 51,515 82,822 103,285 - 55883 ADA Platforms and Ramps-Stadiu 4,665 21,457 215,415 1,340 - - 55884 K-1 Center 2,511,785 51,600 (0) - - 325,000 55885 Electrical at Main Pier 175,647 102,893 - - - - 55886 Pickleball Courts - - - - - 125,000 55887 ADA Compliance Project - - - 21,701 74,066 800,000 55888 Safe Room - - - - 650,000 650,000 55889 Clock Corner Improvements - - - - 75,000 56,000 55890 Triangle Nature Park - - - - - 1,086,047 55900 Transp and Ped Infrastructure 29,397 176,289 - - - - 55910 AL Trans Rehab Twin Bch at 98 - 102,610 269,319 - - - 55915 Church St Drainage Improvement - - 857,117 552,042 437,208 - 55916 Oak St Drainage Improvements - - 232,953 5,835 - - 55930 Volanta Park Baseball Project - - 60,912 609,251 1,210,000 655,000 55935 Volanta Park Restrooms - - - - 80,000 267,087 55940 Founders Competition Track - - - 39,275 1,000,000 1,200,000 55950 Founders Park Restrooms - - - - 115,000 187,087 56005 Hurricane Nate - 700 - - - - TOTAL EXPENSES 5,306,289 2,213,742 2,373,999 2,759,917 7,108,930 8,740,621 Excess Rev Over Expenses (3,460,062) (1,080,422) 565,751 (467,640) 1,000,000 - Page 46 of 109 Capital Projects Fund Organization Object Name Year Line Quantity Amount Description 103 55853 Drainage Improvements 2023 10 1 250,000.00$ North Ingleside - Drainage repair & improvements - major road crossing - engineering approved and completed in FY2022 103 55853 Drainage Improvements 2023 20 1 50,000.00$ Pecan Avenue Drainage Design - Modeling and Engineering Design 103 55853 Drainage Improvements 2023 30 1 20,000.00$ Misc drainage 103 55856 City wide street resur/misc 2023 10 1 423,000.00$ $200K Impact Fees $130K Rebuild Alabama $93K Motor Fuel (Gas Fund) 009 103 55856 City wide street resur/misc 2023 20 1 200,000.00$ FY2022 Resurface Rollover 103 55859 BRATS Hub Transit Shelter 2023 10 1 1,687,711.00$ BRATS Hub Construction cost 103 55878 MPO Gayfer Greeno Turnlanes 2023 10 1 549,737.00$ Turnlanes Construction Cost 103 55878 MPO Gayfer Greeno Turnlanes 2023 20 1 71,238.00$ CEI for Gayfer project MPO Grant 80% 103 55881 Roundabout at 104 and Section 2023 10 1 137,714.00$ Engineering design/planning MPO STP Funds $110,171.00 City Matching $27,542.75 103 55884 K-1 Center 2023 10 1 175,000.00$ K1 Center renovations - Design/Plans Per RJ - $175,000.00 Grant does NOT cover plans 103 55884 K-1 Center 2023 20 1 150,000.00$ K1 Asbestos repairs 103 55886 Pickleball Courts 2023 10 1 125,000.00$ Pickelball Courts at Quail Creek renovations 103 55887 ADA Compliance Project 2023 10 1 750,000.00$ Southland Place Subdivision sidewalks Estimated project $1.5M. Completed over 2 years 103 55887 ADA Compliance Project 2023 20 1 50,000.00$ Engineering Services for ADA Compliance at Southland Place Subdivision 103 55888 Safe Room 2023 10 1 650,000.00$ Safe Room projects (2 year project) Estimated $1,300,000.00 with grant match of $325,000.00. Split project over 2 years. 103 55889 Clock Corner Improvements 2023 10 1 56,000.00$ Clock Corner (Fairhope Avenue/Section Street) Improvements Rollover FY2022 103 55890 North Triangle Nature Park 2023 10 1 999,989.00$ Estimated North Triangle Nature Park - GOMESA Funding Engineering Design and Construction Inspection $107,142 Construction and CEI $892,847 103 55890 North Triangle Nature Park 2023 20 1 86,058.00$ Engineering - Not reimbursed by GOMESA 103 55930 Volanta Park Baseball Project 2023 10 1 90,000.00$ Install light estimated 103 55930 Volanta Park Baseball Project 2023 20 1 240,000.00$ Estimate to complete fields FY2023 103 55930 Volanta Park Baseball Project 2023 40 1 325,000.00$ New additional paved parking and improvements and roadways in Volanta Park. Impact fees will be uses for the additional parking. $200K 103 55935 Volanta Park Restrooms 2023 10 1 80,000.00$ Restroom Facility at Volanta / Peanut Field Rollover FY2022 103 55935 Volanta Park Restrooms 2023 20 1 187,087.00$ New restrooms for Volanta Park 103 55940 Founders Competition Track 2023 10 1 1,200,000.00$ Track Estimated Cost BCBE - $250K Single Tax - $400K 103 55950 Founders Park Restrooms 2023 10 1 187,087.00$ New restroom building at Founders Park Rollover FY2022 $115,000.00 8,740,621.00$ Page 47 of 109 Impact Fee Fund 9/26/2022 Object Description FY 2019 Annual FY 2020 Annual FY 2021 Annual FY2022 Aug YTD FY2022 Annual Budget FY2023 Annual Budget REVENUES 40030 Cash Acct-Police 180,995 124,469 148,090 136,538 120,000 120,000 40040 Cash Acct-Fire 199,144 148,964 173,498 160,962 160,000 150,000 40050 Cash Acct-Transportation 259,365 207,127 246,459 200,722 200,000 175,000 40060 Cash Acct-Recreation 642,594 492,085 559,990 517,046 500,000 450,000 40950 Interest Income 23,419 34,330 2,763 5,419 3,000 2,000 49998 Budget Rollover - - - - 1,030,185 1,097,480 TOTAL REVENUES 1,305,517 1,006,975 1,130,800 1,020,687 2,013,185 1,994,480 EXPENSES 50580 Bank Fees 42 0 - - - - 50961 Transfer to General-Police 100,000 58,797 - - - 224,893 50962 Transfer to General-Fire 8,294 8,855 417,157 175,908 149,900 - 50963 Transfer to General-Transporta 8,099 - - - - - 50964 Transfer to General-Recreation - 1,304,320 - - - - 50967 Transfers-Cap Proj-Transportat 250,000 300,000 900,763 10,415 200,000 400,000 50968 Transfers-Cap Proj-Recreation - 25,000 275,500 607,285 1,663,285 1,392,087 TOTAL EXPENSES 366,435 1,696,973 1,593,420 793,608 2,013,185 2,016,980 Excess Rev Over Expense 939,082 (689,998) (462,620) 227,079 - (22,500) POLICE FIRE TRANS- PORTATION PARKS / RECREATION TOTAL New Track 550,000 Completion of baseball fields 240,000 Install lights 90,000 Parking lot for baseball fields 200,000 New restrooms at Volanta 187,087 New pickleball court 125,000 FY2023 Resurfacing Project - 200,000 Drainage 200,000 3 New Police vehicles with equipme 195,408 - Scout Speed Trailer 6,985 License Plate Readers 22,500 224,893 - 400,000 1,392,087 2,016,980 FY2023 Budget Impact Fees Projects Page 48 of 109 Page 49 of 109 Page 50 of 109 Municipal Capital Improvements Fund 9/26/2022 Object Description FY 2019 Annual FY 2020 Annual FY 2021 Annual FY2022 Aug YTD FY2022 Annual Budget FY2023 Annual Budget REVENUES 40640 Alabama Trust Fund Receipts - 149,856 157,662 207,102 150,000 200,000 40950 Interest-Bank Deposits - 9,575 728 1,152 - - 49010 Interest Earned - - - 6 500 500 49810 Transfers from Gen Fund - 906,107 - - - - 49998 Budget Rollover - - - - 286,708 - TOTAL REVENUES - 1,065,537 158,390 208,260 437,208 200,500 EXPENSES 50920 Transfers to General Fund - 249,195 - - - - 50986 Transfers to Cap Projects Fund - - 304,080 437,206 437,208 - TOTAL EXPENSES - 249,195 304,080 437,206 437,208 - Excess Revenue Over Expenses - 816,343 (145,689) (228,946) - 200,500 Page 51 of 109 General Fund Lease Gas Fund Electric Fund Water & Wastewater Fund FY2022 350,156.17 43,826.86 43,826.86 1,746,106.27 FY2023 83,626.18 43,781.74 43,781.74 1,744,308.52 FY2024 - 43,730.50 43,730.50 1,742,267.00 FY2025 43,791.87 43,791.87 1,744,712.25 FY2026 43,726.87 43,726.87 1,742,122.27 FY2027 12,784.59 12,784.59 509,350.82 FY2028 12,748.83 12,748.83 507,926.33 FY2029 12,711.55 12,711.55 506,440.90 FY2030 12,791.47 12,791.47 509,625.06 FY2031 - 12,868.33 12,868.33 512,687.33 433,782.35 282,762.62 282,762.62 11,265,546.76 URW 2020 Debt Payment by Year - 200,000.00 400,000.00 600,000.00 800,000.00 1,000,000.00 1,200,000.00 1,400,000.00 1,600,000.00 1,800,000.00 2,000,000.00 FY2023 FY2024 FY2025 FY2026 FY2027 FY2028 FY2029 FY2030 FY2031 DEBT PAYMENTS BY YEAR FY2023-FY2031 General Fund Lease Gas Fund Electric Fund Water & Wastewater Fund Page 52 of 109 Regions Trust/BBVA Compass 2.3900%2.3900%95.2200% Date Principal Interest Total Pymt Balance Principal Interest Balance Principal Interest Balance Principal Interest Balance Total Pymt 09/30/20 11,565,000.00 276,403.50 276,403.50 11,012,193.00 12/01/20 265,000.00 25,083.20 290,083.20 11,300,000.00 6,333.50 599.49 270,070.00 6,333.50 599.49 270,070.00 252,333.00 23,884.22 10,759,860.00 290,083.20 06/01/21 - 72,320.00 72,320.00 11,300,000.00 - 1,728.45 270,070.00 - 1,728.45 270,070.00 - 68,863.10 10,759,860.00 72,320.00 12/01/21 1,700,000.00 72,320.00 1,772,320.00 9,600,000.00 40,630.00 1,728.45 229,440.00 40,630.00 1,728.45 229,440.00 1,618,740.00 68,863.10 9,141,120.00 1,772,320.00 06/01/22 - 61,440.00 61,440.00 9,600,000.00 - 1,468.42 229,440.00 - 1,468.42 229,440.00 - 58,503.17 9,141,120.00 61,440.00 12/01/22 1,720,000.00 61,440.00 1,781,440.00 7,880,000.00 41,108.00 1,468.42 188,332.00 41,108.00 1,468.42 188,332.00 1,637,784.00 58,503.17 7,503,336.00 1,781,440.00 06/01/23 - 50,432.00 50,432.00 7,880,000.00 - 1,205.32 188,332.00 - 1,205.32 188,332.00 - 48,021.35 7,503,336.00 50,432.00 12/01/23 1,740,000.00 50,432.00 1,790,432.00 6,140,000.00 41,586.00 1,205.32 146,746.00 41,586.00 1,205.32 146,746.00 1,656,828.00 48,021.35 5,846,508.00 1,790,432.00 06/01/24 - 39,296.00 39,296.00 6,140,000.00 - 939.17 146,746.00 - 939.17 146,746.00 - 37,417.65 5,846,508.00 39,296.00 12/01/24 1,765,000.00 39,296.00 1,804,296.00 4,375,000.00 42,183.50 939.17 104,562.50 42,183.50 939.17 104,562.50 1,680,633.00 37,417.65 4,165,875.00 1,804,296.00 06/01/25 - 28,000.00 28,000.00 4,375,000.00 - 669.20 104,562.50 - 669.20 104,562.50 - 26,661.60 4,165,875.00 28,000.00 12/01/25 1,785,000.00 28,000.00 1,813,000.00 2,590,000.00 42,661.50 669.20 61,901.00 42,661.50 669.20 61,901.00 1,699,677.00 26,661.60 2,466,198.00 1,813,000.00 06/01/26 - 16,576.00 16,576.00 2,590,000.00 - 396.17 61,901.00 - 396.17 61,901.00 - 15,783.67 2,466,198.00 16,576.00 12/01/26 505,000.00 16,576.00 521,576.00 2,085,000.00 12,069.50 396.17 49,831.50 12,069.50 396.17 49,831.50 480,861.00 15,783.67 1,985,337.00 521,576.00 06/01/27 - 13,344.00 13,344.00 2,085,000.00 - 318.92 49,831.50 - 318.92 49,831.50 - 12,706.16 1,985,337.00 13,344.00 12/01/27 510,000.00 13,344.00 523,344.00 1,575,000.00 12,189.00 318.92 37,642.50 12,189.00 318.92 37,642.50 485,622.00 12,706.16 1,499,715.00 523,344.00 06/01/28 - 10,080.00 10,080.00 1,575,000.00 - 240.91 37,642.50 - 240.91 37,642.50 - 9,598.18 1,499,715.00 10,080.00 12/01/28 515,000.00 10,080.00 525,080.00 1,060,000.00 12,308.50 240.91 25,334.00 12,308.50 240.91 25,334.00 490,383.00 9,598.18 1,009,332.00 525,080.00 06/01/29 - 6,784.00 6,784.00 1,060,000.00 - 162.14 25,334.00 - 162.14 25,334.00 - 6,459.72 1,009,332.00 6,784.00 12/01/29 525,000.00 6,784.00 531,784.00 535,000.00 12,547.50 162.14 12,786.50 12,547.50 162.14 12,786.50 499,905.00 6,459.72 509,427.00 531,784.00 06/01/30 - 3,424.00 3,424.00 535,000.00 - 81.83 12,786.50 - 81.83 12,786.50 - 3,260.33 509,427.00 3,424.00 12/01/30 535,000.00 3,424.00 538,424.00 - 12,786.50 81.83 - 12,786.50 81.83 - 509,427.00 3,260.33 - 538,424.00 11,565,000.00 628,475.20 12,193,475.20 276,403.50 15,020.56 2,253,292.00 276,403.50 15,020.56 11,012,193.00 598,434.09 12,193,475.20 W&S Utility Revenue Warrants - Series 2020 G/L Code 26770 Advance Refunding of URW 2011 $11,565,000 Utilities Capital Projects Overall Totals Gas Electric Page 53 of 109 Debt Service 9/26/2022 Object Description FY 2019 Annual FY 2020 Annual FY 2021 Annual FY2022 Aug YTD FY2022 Annual Budget FY2023 Annual Budget 50465 Lease Purchase 52,439 - - 25,466 - - 50955 Transfers-Debt Svc Fund 3,318,786 - - - - - 50998 Capital Lease Proceeds (990,929) (155,999) - - - - 52070 Loan-BCBE - (1,500,000) - 300,000 300,000 300,000 52075 BCBE-Principal - 300,000 300,000 - - - Total Debt Service 2,380,296 (1,355,999) 300,000 325,466 300,000 300,000 Page 54 of 109 Interim Balance Bank Working Name of Account G/L # Account Form Fund Account Type 8/31/2021 Authorized Use PNC General Fund Operating 001-10045 Checking 1-General Available 17,242,958.00 Operating Account PNC Payroll Account 001-10050 Checking 1-General Restricted 6,450.21 Payroll PNC City Accounts Payable 001-10055 Checking 1-General Restricted 106,315.41 Accounts Payable - weekly disbursements Smart Bank General Reserves 001-10061 Checking 1-General Restricted 469,427.25 General Reserves - available for use Smart Bank General - Sales Tax Reserves 001-10080 Checking 1-General Reserves 7,000,000.00 "Rainy Day Fund" - Access by vote of the City Council Community Sales Tax Debt Prepayment 001-10085 Checking 1-General Debt Serv 699,594.46 GF debt prepayment / repayment only PNC DEA Fund - Local 001-10220 Checking 1-General Restricted 26,022.17 Restricted for Drug Enforcement only - Chief approval PNC DEA Fund - US Dept of Treasury 001-10221 Checking 1-General Restricted 5,534.08 Restricted for Drug Enforcement only - Chief approval PNC DEA Fund - US DOJ 001-10222 Checking 1-General Restricted 244.22 Restricted for Drug Enforcement only - Chief approval PNC Corrections Fund 001-10255 Checking 1-General Restricted 253,039.76 Operations of Jail and Court - Chief/Judge Approval Truist Pooled Cash account 001-10525 Pooled 1-General Available 181,341.95 Pooled Cash operating funds 25,990,927.51 General Fund Totals PNC Natural Gas Operating Acct.002-10045 Checking 2-Gas Available 7,816,814.50 Operating Account Smart Bank Gas Reserves 002-10062 Checking 2-Gas Restricted 3,491,927.59 Gas Reserves - available for use Truist Pooled Cash account 002-10525 Pooled 2-Gas Available 203,685.06 Pooled Cash operating funds Smart Bank Gas Customer Deposit Reserve 002-11420 Checking 2-Gas Restricted 719,865.88 Gas Customer Deposits Reserves Regions URW 2020 Reserve 002-15400 Trust 2-Gas Debt Serv 43,896.16 Bond Fund Regions URW 2020Prin/Int Sinking 002-15405 Trust 2-Gas Debt Serv - Bond Fund Regions Escrow Trust to Def URW 2020 002-15415 Trust 2-Gas Debt Serv - Bond Fund 12,276,189.19 Gas Fund Totals PNC Electric Operating 003-10045 Checking 3-Electric Available 954,935.14 Electric Operating account Smart Bank Electric Reserves 003-10063 Checking 3-Electric Restricted 4,830,609.33 Electric Reserves - available for use PNC Emergency Relief Fund 003-10520 Checking 3-Electric Restricted 23,805.42 Citizen Utility Relief - Ecumenical Ministries Truist Pooled Cash account 003-10525 Pooled 3-Electric Available 815,648.15 Pooled Cash operating funds Smart Bank Electric Customer Deposit Reserve 003-11430 Checking 3-Electric Restricted 1,129,372.86 Electric Customer Deposits Reserves Regions URW 2020 Reserve 003-15400 Trust 3-Electric Debt Serv 43,896.27 Bond Fund Regions URW 2020Prin/Int Sinking 003-15405 Trust 3-Electric Debt Serv - Bond Fund Regions Escrow Trust to Def URW 2020 003-15415 Trust 3-Electric Debt Serv - Bond Fund 7,798,267.17 Electric Fund Totals PNC Water & Sewer Operating Fund 004-10045 Checking 4-Water Available 4,606,697.40 Water Operating Account Smart Bank Water & Sewer Reserve 004-10064 Checking 4-Water Restricted 950,764.15 Water Reserves-monthly deposit Truist Pooled Cash account 004-10525 Pooled 4-Water Available 298,117.36 Pooled Cash operating funds Smart Bank Water Tap Reserves 004-10650 Checking 4-Water Capital/Restricted 3,209,356.28 Capital Improvements to Water System Smart Bank Sewer Tap Reserves 004-10660 Checking 4-Water Capital/Restricted 1,392,199.62 Capital Improvements to Sewer System CITY OF FAIRHOPE City Bank Accounts & Types 8/31/2022 Page 55 of 109 Interim Balance Bank Working Name of Account G/L # Account Form Fund Account Type 8/31/2021 Authorized Use CITY OF FAIRHOPE City Bank Accounts & Types 8/31/2022 Smart Bank Water Customer Deposit Reserve 004-11440 Checking 4-Water Restricted 451,917.43 Water Customer Deposits Reserves Regions Revenue Warrant Series 1996 004-15020 Trust 4-Water Debt Serv 50,713.17 Trust Account-held under Indenture Agmt. Regions URW 2020 Reserve 004-15400 Trust 4-Water Debt Serv 1,748,868.80 Bond Fund Regions URW 2020Prin/Int Sinking 004-15405 Trust 4-Water Debt Serv - Bond Fund Regions Escrow Trust to Def URW 2020 004-15415 Trust 4-Water Debt Serv - Bond Fund 12,708,634.21 Water/Sewer Fund Totals PNC Sanitation Operating Fund 005-10045 Checking 5-Sanitation Available 226,197.21 Sanitation Operating Account Truist Pooled Cash account 500-10525 Checking 5-Sanitation Available 55,035.98 Pooled Cash operating funds Smart Bank Sanitation Operating Fund 005-11410 Checking 5-Sanitation Available 26,226.05 Sanitation Customer Deposits Reserves 307,459.24 Truist 7% Gas Tax Fund 009-11010 Checking 9-Gas Tax Restricted 193,675.16 Road Construction - under State ordinance Truist 4% and 5% Gas Tax Fund 009-11015 Checking 9-Gas Tax Restricted 95,454.62 Road Construction - under State ordinance 289,129.78 Gas Tax Fund Totals PNC Prepaid Cash-Medical Ins 101-10150 Checking 101-Health Restricted 1,262,375.84 Health Claims - BCBS Weekly deduction PNC Rebuild AL Gas Tax Fund 102-10045 Checking 102-Rebuild AL Restricted 281,688.77 Road Construction - under State ordinance PNC Capital Projects Op Acct 103-10045 Checking 8-Cap Proj Capital 1,931,950.63 Capital Projects funding PNC Capital Projects Infrastructure Impr 103-10087 Checking 8-Cap Proj Capital - Capital Projects funding 1,931,950.63 Capital Projects Fund Totals PNC Impact Fee Fund - Police 105-10045 Checking 7-Impact Capital/Restricted 599,456.11 Capital-Police with Council approval PNC Impact Fee Fund - Fire 105-10050 Checking 7-Impact Capital/Restricted 847,412.79 Capital-Fire with Council approval PNC Impact Fee Fund - Transportation 105-10055 Checking 7-Impact Capital/Restricted 277,943.90 Capital-Transportation with Council approval PNC Impact Fee Fund - Rec / Parks 105-10060 Checking 7-Impact Capital/Restricted 1,075,914.98 Capital-Parks with Council approval 2,800,727.78 Impact Fee Fund Totals PNC Municipal Capital Imprvmt Fund 106-10235 Checking 106-MCIF Restricted 441,706.78 Capital Improvements-City Wide with Council Approval PNC Federal Grant 110-10045 Checking 110-Fed Grant Restricted 224,701.64 Restore Grant PNC American Rescue Fund 111-10045 Checking 1-American Resc Restricked 1,644,426.82 COVID-19 Page 56 of 109 Interim Balance Bank Working Name of Account G/L # Account Form Fund Account Type 8/31/2021 Authorized Use CITY OF FAIRHOPE City Bank Accounts & Types 8/31/2022 PNC Municipal Court Fund 114-10045 Checking 114-Muni Court Restricted 96,477.13 Court payments - 68,054,662.49 Page 57 of 109 Fairhope Public Utilities r-" Current Active Meters Electric: 6,999 Gas: 12,715 Water: 21,120 2021 • Electric: 6,955 • Gas: 12,187 • Water: 20,602 2020 • Electric: 6,974 • Gas: 11,802 • Water: 20,112 2019 • Electric: 6,913 • Gas: 11,381 • Water: 19,446 Total number of water meters changed out in 2022: 165 Key Account Holders: Thomas Hospital • Wal-Mart • Grand Hotel • Winn Dixie • Piggly Wiggly Library • Disposal Plant • Fairhope Elementary School • Fairhope High School Fairhope Middle School Page 58 of 109 Gas Electric Water & Sewer Total Fund Fund Fund Utilities Utility Revenue Income 9,251,483 25,118,224 16,655,800 51,025,507 Utility Operating Expenses*7,874,395 22,046,499 11,880,831 41,801,725 Net Operating Income/(Loss)1,377,088 3,071,725 4,774,969 9,223,782 *This excludes vehicles and equipment/SCADA/Capital Improvements and General Fund transfers. Reported in cash flow requirements below using full accrual accounting. Other Uses Current debt service 43,782 43,782 1,637,784 1,725,348 Vehicles/Equipment 577,241 1,037,437 972,124 2,586,802 Sys Upgrades/Cap Proj 1,973,200 3,736,430 23,646,780 29,356,410 Reserve requirements per ordinance - 960,000 875,000 1,835,000 Line of Credit/Short Term Loan - - (15,000,000) (15,000,000) General Fund Transfer 2% of Utility Revenue 185,030 499,803 290,324 975,157 Other Uses 2,779,253 6,277,452 12,422,012 20,503,560 Add Back Depreciation Expense 550,000 850,000 1,535,000 2,935,000 Excess (Deficit) Cash (852,165) (2,355,727) (6,112,043) (8,344,778) CASH Cash-Operating 6,595,747 1,816,222 6,461,350 14,873,318 Cash-Reserve 3,405,891 3,874,112 830,789 8,110,792 Cash-Reserve Water-Tap - - 2,930,981 2,930,981 Cash-Reserve Sewer-Tap - - 1,286,934 1,286,934 10,001,638 5,690,334 11,510,054 27,202,026 City of Fairhope Utilities Summary FY 2023 Utilities Cash Flow Requirements Page 59 of 109 ADMIN/COLLECTION COSTS ANALYSISFOR USE IN PREPARATION OF 2023 BUDGET ADMINISTRATIVE FEE COMPUTATION - 50026 RETAINED 2023 IN GEN DEPT BUDGET DIVISION FUND REALLOCATED ADMIN SALARIES & OT 1,364,825.09 4 341,206.27 1,023,618.82 HR SALARIES & OT 311,059.66 4 77,764.92 233,294.75 IT SALARIES & OT 404,323.18 4 101,080.80 303,242.39 MECHANICS SALARIES & OT 465,481.07 4 116,370.27 349,110.80 JANITORIAL COST 29,547.00 4 7,386.75 22,160.25 PLANNING SALARIES & OT 633,663.08 15% TO UTIL 538,613.62 95,049.46 BUILDING SALARIES & OT 643,163.08 15% TO UTIL 546,688.62 96,474.46 FACILITIES MAINTENANCE 278,719.20 4 69,679.80 209,039.40 PAYROLL TAXES-IN COMMON SAL*.0765 289,948.36 4 72,487.09 217,461.27 RETIREMENT 222,607.32 4 55,651.83 166,955.49 Planning 53,844.44 15% TO UTIL 45,767.77 8,076.67 Building 57,293.07 15% TO UTIL 48,699.11 8,593.96 PERCENT OF IN COMMON COSTS RETAINED IN GEN FUND:42.52%2,021,396.84 2,733,077.71 4,754,474.55 FY 2022 FY 2023 ROUNDED 2,733,078 DIFFERENCE: 837,000 GAS 911,026 33.3333%74,026 837,000 ELEC 911,026 33.3333%74,026 544,050 WATER 592,167 33.3333%48,117 292,950 SEWER 318,859 COMBINED 25,909 2,511,000 2,733,078 222,078 COLLECTION FEES COMPUTATION - 50025 REVENUE: SALARIES 425,016.81 PAYROLL TAXES 33,141.43 RETIREMENT 28,938.44 MEDICAL EXPENSE 89,112.00 576,208.68 CUSTOMER COUNT FY 2022 FY 2023 GAS FUND 12,715 ROUNDED 576,209 DIFFERENCE: ELEC 6,999 103,860 GAS 110,734 19%6,874 WATER-64.62% OF WATER/SEWER COMBINED 21,120 58,365 ELEC 60,954 11%2,589 SEWER-35.38% OF W/S COMBINED 12,165 168,132 WATER 183,933 32%15,801 GARBAGE 13,164 102,006 SEWER 105,944 18%3,938 66,163 432,363 461,564 29,201 *GARBAGE IS 20% OF CUSTOMERS BILLED, BUT IT DOES NOT REQUIRE METER READING OR CUT-OFF/ON.114,644 20% 576,209 METER: METER DEPARTMENT TOTAL EXPENSES 755,286.97 FY 2022 FY 2023 ROUNDED 755,287 DIFFERENCE: CUSTOMER COUNT 162,421 GAS 181,201 24%18,780 GAS FUND 12,715 91,275 ELEC 99,743 13%8,468 ELEC 6,999 262,934 WATER 300,980 40%38,046 WATER-63.45% OF WATER/SEWER COMBINED 21,120 159,523 SEWER 173,363 23%13,840 SEWER-36.555% OF W/S COMBINED 12,165 676,153 755,287 79,134 52,999 GENERAL FUND REVENUE ACCTS:TOTAL COLLECTION COST:001-41250 GAS 291,935 001-41260 33,285 Water/Sewer Total Customer Count ELECTRIC 160,696 63.45%Water %WATER 484,913 36.55%Sewer %SEWER 279,307 Page 60 of 109 Page 61 of 109 Page 62 of 109 Page 63 of 109 Projected Projected FY 2023 FY 2024 FY 2025 Budget Budget Budget Total Revenue 9,251,483 9,343,048 9,435,528 Total Operating Expense 7,874,395 8,000,195 8,102,623 Revenue Minus Operating Expenses 1,377,088 1,342,853 1,332,905 Other Uses Reserve for Capital Equipment/Improvements 577,241 500,000 500,000 Reserve for System Upgrades 1,973,200 1,370,000 605,000 Warrant & Lease Payments 43,782 41,108 41,586 General Fund Transfer 185,030 190,581 194,393 Total Other Uses 2,779,253 2,101,689 1,340,979 Excess/(Deficit) for the Year (1,402,165) (758,836) (8,074) Add back Depreciation Expense 550,000 565,600 571,256 Net Excess/(Deficit)(852,165) (193,236) 563,182 CASH 8/31/2022 Cash-Operating 8,019,281 Cash-Reserve 3,491,928 11,511,208 Targeted Reserve Fund 20% of Annual Revenue 1,850,297 1,868,610 1,887,106 City of Fairhope Gas Department Page 64 of 109 GAS DEPARTMENT FUND 9/26/2022 Object Description FY 2019 Annual FY 2020 Annual FY 2021 Annual FY2022 Aug YTD FY2022 Annual Budget FY2023 Annual Budget REVENUES 40835 Federal Grants - 1,241 6,094 - - - 40840 Fema-Grant Revenues - 18,287 (4,924) - - - 40900 Transfers In Captl Purchases 49,360 - - - - - 41705 Sale of Fixed Assets - 2,312 212 22,977 - - 42010 Sale of Natural Gas 6,164,202 5,839,877 6,851,260 7,418,498 6,187,113 7,236,483 42030 Sale of Natural Gas-Joint Line 1,604,590 1,588,266 1,825,800 1,873,380 1,601,772 1,900,000 45635 Grant income-ALDOT 162,251 9,450 2,542 - - - 49010 Interest Earned 39,238 181,535 92,211 93,168 95,000 90,000 49030 Insurance Claim - 4,399 65,999 68,683 - - 49035 Rebate Income 5,776 5,237 5,201 5,877 5,000 5,000 49040 Miscellaneous Revenue - 477 2,560 - - - 49060 Connection Fees - - 2,700 24,704 - 20,000 49080 Community Dev Revenue 342 48 84 832 - - 49998 Budget Rollover - - - - 1,762,114 1,358,383 49999 Inventory revenue - - - 499 - - TOTAL REVENUES 8,025,759 7,651,129 8,849,739 9,508,618 9,650,999 10,609,866 EXPENSES 50020 Purchased Power-Natural Gas 2,104,356 1,545,490 2,216,197 3,170,920 1,813,967 2,749,684 50025 Collection Costs/Revenue Dept 51,000 59,000 59,000 266,281 266,281 291,935 50026 Administrative Costs 761,000 852,000 872,000 837,000 837,000 911,026 50040 Salaries-Oper&Maint 813,357 952,718 1,094,870 903,011 1,143,832 1,229,769 50045 Overtime 81,368 84,712 85,641 85,661 77,543 78,000 50190 Employee Payroll Taxes 78,993 88,066 90,025 73,082 93,435 108,622 50200 Employee Retirement Exp 61,653 92,560 98,130 80,227 93,627 114,275 50210 Employee Medical Insurance 146,723 302,715 291,812 218,446 246,424 299,365 50215 Required Contrib-OPEB 63,313 210,715 25,681 24,532 33,858 42,055 50220 Casualty/Workers Comp Ins 60,359 76,728 - - - - 50221 Workers Comp Insurance - - 22,498 21,167 20,200 21,168 50222 Casualty/Property Insurance - - 60,341 66,938 62,003 70,285 50230 Training/School/Travel 27,323 23,681 22,787 30,497 42,400 54,700 50250 Trustee Fees 354 365 - 99 350 350 50270 Audit & Accounting 15,854 14,502 9,759 26,212 15,000 17,000 50280 Legal Fees 5,889 6,506 3,893 4,300 6,000 6,000 50290 Professional Services 137,880 81,956 45,626 61,209 304,000 289,000 50300 Computer Expense 56,967 89,031 37,366 11,647 15,541 17,379 50320 Office Supplies 4,119 1,512 1,308 1,902 4,000 3,400 50325 Printers/Copiers/OE and supp - 5,613 6,506 4,629 6,200 11,150 50330 Postage 42,631 39,848 39,793 49,340 36,000 45,000 50340 Operating Supplies 112,248 142,551 193,165 144,171 150,000 180,000 50360 Maintenance-Buildings 23,407 16,608 15,274 20,191 22,000 22,000 50365 Maintenance-Plant 103,021 61,070 119,632 120,075 340,500 198,000 50380 Communications 36,941 37,858 30,327 24,022 19,600 28,492 50390 Dues-Memberships-Subscrip 29,201 34,362 33,420 29,447 53,900 49,450 50395 Employment Screening - - 1,216 1,232 1,200 1,200 50420 Bad Debts 3,052 10,089 8,886 10,956 5,000 10,000 50430 Gasoline & Oil 39,579 27,939 40,709 51,157 38,000 55,000 50435 Small Equipment - - - 38,154 50,000 43,780 50440 Maintenance-Vehicles&Equip 64,195 56,858 35,185 40,633 62,000 52,000 50460 Uniforms 5,456 22,210 1,014 1,452 2,000 4,000 50462 Safety Wear and PPE - 3,852 16,106 4,580 13,397 12,755 50470 Purchases Vehicles & Equipment - - - 130,332 399,000 532,241 50473 Warehouse Improvement Purchase - - - 34,985 180,000 45,000 50474 Warehouse Building Purchases - - - 861 - - 50490 Community Dev Projects - - - (306) - - 50495 Amortization Expense 2,257 2,257 - - 2,257 - 50500 Depreciation 516,325 510,799 475,895 436,238 550,000 550,000 50501 Depreciation Adjustment 46,073 - - - - - 50510 Interest Expense 11,037 10,134 8,050 2,779 3,200 2,674 50520 Rental-other 13,888 7,892 11,493 2,634 14,000 12,000 50530 Bond Issue Expense - 857 - - - - 50540 Electricity 2,879 3,067 3,282 3,491 3,000 4,000 50560 Credit Card Processing Fees 56,877 60,726 66,949 95,672 56,000 80,000 50580 Bank Fees 4,516 12,885 11,322 10,806 13,000 13,000 Page 65 of 109 GAS DEPARTMENT FUND 9/26/2022 Object Description FY 2019 Annual FY 2020 Annual FY 2021 Annual FY2022 Aug YTD FY2022 Annual Budget FY2023 Annual Budget 50900 Transfers Out Captl Purchases 88,373 115,214 - - - - 50902 Transfers Out Captl Purchases Gas - - 24,130 61,116 - 53,282 50920 Transfers to General Fund 96,000 - - 102,016 102,016 185,030 50925 Transfers for Comm Dev 72,000 108,000 241,334 - - - 50965 Transfers-Cap Proj Fund - - 36,125 - 91,131 - 51030 Publications Newspapers - 66 - - 100 100 52010 Dist of Joint Revenue 133,459 70,322 77,240 71,042 70,000 70,000 52020 Daphne 3% Rev Tax Exp 4,836 4,542 5,335 5,218 5,200 5,200 52025 Spanish Fort Franchise Tax 20,638 20,192 22,192 17,854 20,000 20,000 52030 APSC Inspection Fee 7,045 7,268 15,214 - 7,300 7,300 52510 Utilities for City Use 38,390 34,665 33,232 31,894 40,000 40,000 59000 Inventory Budget - - - 31 - - 59100 SCADA Capital Purch Budget - - - - 19,667 - 59500 Capital Sys Improve Budget - - - 133,428 2,291,000 1,973,200 59893 Transfers Out-Electric Fund - 1,000,000 - - - - 50340 General Supplies-COVID - 1,241 - - - - 56015 Hurricane Sally - 3,767 1,692 - - - TOTAL EXPENSES 6,044,829 6,915,011 6,611,652 7,563,261 9,742,130 10,609,866 EXCESS REVENUE OVER EXPENSE 1,980,931 736,119 2,238,087 1,945,357 (91,131) - Page 66 of 109 Actual Actual Actual Actual Budget Draft Budget Estimated Projected Projected Projected Projected ProjectedCategoryFY 2019 FY 2020 FY 2021 YTD 8/2022 FY 2022 FY 2023 Growth Rate FY 2024 FY 2025 FY 2026 FY 2027 FY 2028Sales and Services 7,768,793 7,428,143 8,677,060 8,137,633 7,788,885 9,136,483 1.0%9,227,848 9,320,126 9,413,328 9,507,461 9,602,535Other charges, sales and receipts 162,592 16,685 74,097 69,778 0 20,000 1.0%20,200 20,402 20,606 20,812 21,020Interest income 45,015 186,773 97,412 89,904 100,000 95,000 95,000 95,000 95,000 95,000 95,000 Total Revenue 7,976,400$ 7,631,602$ 8,848,569$ 8,297,316$ 7,888,885$ 9,251,483$ N/A 9,343,048 9,435,528 9,528,934 9,623,273 9,718,556 Operations Expenses Compensation & Benefits 1,245,407 1,731,486 1,708,657 1,567,317 1,708,919 1,893,254 4.0%1,968,984 2,047,743 2,129,653 2,214,839 2,303,433Energy Purchases 2,104,356 1,545,490 2,216,197 1,892,858 1,813,967 2,749,684 2.0%2,804,678 2,860,771 2,917,987 2,976,346 3,035,873Supplies, Repairs & Maintenace 306,990 285,453 371,071 345,451 634,700 510,330 2.0%520,537 530,947 541,566 552,398 563,446Services Provided by Others 159,623 102,964 59,277 47,963 325,000 312,000 1.0%315,120 318,271 321,454 324,668 327,915Utilties & Communication 78,210 75,590 66,841 59,332 62,600 72,492 1.0%73,217 73,949 74,688 75,435 76,190Travel/Training 27,323 23,681 22,787 20,790 42,400 54,700 1.0%55,247 55,799 56,357 56,921 57,490Other Operating Expenditures 342,345 407,906 362,469 315,698 337,991 393,019 1.0%396,949 400,918 404,927 408,977 413,066Interest expense 11,037 10,134 8,050 3,744 3,200 2,674 Schedule 2,145 1,608 1,065 715 560Depreciation Expenses 516,325 510,799 475,895 467,878 550,000 550,000 1.0%555,500 561,055 566,666 572,332 578,056 Bad Debt/Amortization 5,309 12,346 8,886 12,717 7,257 10,000 1.0%10,100 10,201 10,303 10,406 10,510Distribution of Joint Revenue 133,459 70,322 77,240 64,625 70,000 70,000 1.0%70,700 73,528 76,469 79,528 82,709 Total Oper. Expenses 4,930,384$ 4,776,172$ 5,377,370$ 4,798,373$ 5,556,035$ 6,618,152$ N/A 6,773,175 6,851,063 7,014,364 7,182,632 7,356,028 Revenue Minus Op Exp 3,046,016$ 2,855,429$ 3,471,199$ 3,498,944$ 2,332,850$ 2,633,331$ N/A 2,569,873 2,584,465 2,514,570 2,440,641 2,362,527 Other Sources/Uses Other Sources Borrowed Funds Variable 0 0 0 0 0Other Sources Total Other Sources -$ -$ -$ -$ -$ -$ N/A 0 0 0 0 0 Other Uses Administrative Cost Paid To Gen Fund 761,000 852,000 872,000 872,000 837,000 911,026 2.0%929,247 947,831 966,788 986,124 1,005,846Collection cost/Revenue Dept 51,000 59,000 59,000 59,000 266,281 291,935 2.0%297,774 303,729 309,804 316,000 322,320Transfer to General Fund 168,000 108,000 241,334 241,334 102,016 185,030 3.0%190,581 194,393 198,280 202,246 206,291Transfers In/Out Capital Purchases 39,013 115,214 24,130 24,130 0 53,282 0 0 0 0 0Warrant & Lease Payments 0 0 0 0 0 43,782 Per Schedule 41,108 41,586 42,184 42,662 12,070Reserve for Capital Equipment/Improvements 0 0 0 0 598,667 577,241 Variable 500,000 500,000 500,000 500,000 500,000Reserve for System Upgrades 0 0 0 0 2,291,000 1,973,200 1,370,000 605,000 700,000 630,000 650,000Transfer to Electric 0 1,000,000 0 0 0 0 N/A 0 0 0 0 0Total Other Uses 1,019,013$ 2,134,214$ 1,196,464$ 1,196,464$ 4,094,964$ 4,035,496$ 0.0%3,328,709 2,592,539 2,717,056 2,677,031 2,696,527 Net Other Sources/Uses (1,019,013)(2,134,214)(1,196,464)(1,196,464)(4,094,964)(4,035,496)N/A (3,328,709)(2,592,539)(2,717,056)(2,677,031)(2,696,527) Excess/(Deficit) for Year 2,027,003$ 721,215$ 2,274,735$ 2,302,479$ (1,762,114)$ (1,402,165)$ N/A (758,836)(8,074)(202,486)(236,390)(333,999) Add back Depreciation Exp 516,325$ 510,799$ 475,895$ 467,878$ 550,000$ 550,000$ 565,600$ 571,256$ 576,969$ 582,738$ 588,566$ Net Excess/(Deficit) $ 2,543,328 1,232,015$ 2,750,630$ 2,770,357$ (1,212,114)$ (852,165)$ (193,236)563,182 374,483 346,348 254,566 Assets Cash Balances As of 9/30/19 As of 9/30/20 As of 9/30/21 As of 8/31/2022 Cash - Operating 4,826,127$ 5,312,163$ 6,404,725$ 7,816,815$ Cash - Pooled Depository 143,358$ 183,161$ 101,264$ 203,685$ Cash - Gas Reserves Centennial 3,245,262$ 3,328,848$ 3,412,870$ 3,491,928$ Cash - Super Fund Savings -$ -$ -$ -$ Cash - Reserve Fund Vision (0)$ -$ -$ -$ Cash - Utility Reserve Fund -$ -$ -$ -$ Cash - Second Utility Reserve -$ -$ -$ -$ Cash - Gas Customer Deposit Reserve 608,302$ 637,248$ 719,866$ 719,866$ Restricted*Restricted* Total Cash 8,823,049$ 9,461,420$ 10,638,724$ 12,232,293$ Targeted Reserved Fund Balance $ 1,586,277 $ 1,488,966 $ 1,488,966 $ 1,641,482 $ 1,850,297 $ 1,868,610 $ 1,887,106 $ 1,905,787 $ 1,924,655 $ 1,943,711 Notes: 10/04/2022Recommended Targeted Reserve Fund 20% of annual revenue City of Fairhope Gas Department Page 67 of 109 Fairhope Utilities GAS Department Capital Outlay Plan Fiscal Year Project Description Estimated cost 2023 Replace Crossings >Replace Highway 33 creek crossing; 2-inch high-pressure steel $43,000 >Replace Rock creek (Main Street) crossing; two 4-inch high-pressure gas lines (one on the east side of Main Street and one on the west side of Main Street)$98,000 >Coleman Lane creek crossing $78,000 Engineering costs >Engineering for creek crossing $43,200 >Engineering for replacing the 6-inch high-pressure gas main under Interstate 10 $130,000 >Engineering for leak-prone pipes $1,000,000 Gas Main Installation Install 2 miles of two-inch PE low-pressure gas main on Mary Ann Beach Road to serve as a backed for County Road 1 $198,000 Regulator and Metering Station Upgrade Upgrade the Grand Hotel's regulator and metering station $150,000 TOTAL FY23 $1,605,200 2024 Gas Main Replacement, Installation >Replace 6-inch high-pressure gas main under Interstate 10 $960,000 >Replace 6-inch high-pressure gas main under US 31 at the intersection of Alabama 181 and along Alabama 181 for approximately 250 feet $80,000 Replace Crossings Replace the creek crossing at Fly Creek (Main Street); two 4-inch high-pressure gas lines (one is on the east side of Main Street, one is on the west side of Main Street) $120,000 Gate Station Upgrade the Gate Station $150,000 Regulator Stations Upgrade four District Regulator Stations $60,000 TOTAL FY24 $1,370,000 2025 Gas Main Replacement Replace 4-inch high-pressure gas main at the sewer plant (bridge)$165,000 Regulator Station >New District Regulator Station at Alabama 104 and U.S. 98 and replace high-pressure steel gas main at U.S. 98 and Alabama 104 north to Parker Road with 4-inch PE $380,000 >Upgrade four District Regulator Stations $60,000 2026 Gas Main >Tie-in high-pressure gas mains at U.S. 98 and County Road 32; this will require a gas main extension on County Road 32 for approximately 1 mile of 2-inch high-pressure steel $385,000 >Lower 6-inch high-pressure gas main on U.S. 31 ROW Vales $65,000 Steel Replacement Replace 1.5 miles of high-pressure steel on County Road 1 with 2-inch PE low-pressure $25,000 TOTAL FY26 $700,000 2027 Steel Replacement Replace 1.5 miles of high-pressure steel on County Road 1 with 2-inch PE low-pressure $250,000 Gas Main Replace 6-inch high-pressure gas main from Alabama 181 to County Road 13 on Fairhope Avenue $380,000 TOTAL FY27 $630,000 Page 1 of 1 Page 68 of 109 Projected Projected FY 2023 FY 2024 FY 2025 Budget Budget Budget Total Revenue 25,011,660 23,144,877 23,375,375 Total Operating Expense 19,689,935 20,229,147 20,513,857 Revenue Minus Operating Expenses 5,321,725 2,915,730 2,861,518 Other Uses Reserve for Capital Equipment/Improvements 1,037,437 500,000 500,000 Reserve for System Upgrades 5,986,430 1,398,000 2,160,000 Warrant & Lease Payments 43,782 41,108 41,586 Reserve requirements per ordinance 960,000 960,000 960,000 General Fund Transfer 499,803 509,799 519,995 Total Other Uses 8,527,452 3,408,907 4,181,581 Excess/(Deficit) for the Year (3,205,727) (493,177) (1,320,063) Add back Depreciation Expense 850,000 858,500 867,085 Net Excess/(Deficit)(2,355,727) 365,323 (452,978) CASH 8/31/2022 Cash-Operating 1,767,594 Cash-Reserve 4,830,609 6,598,203 Targeted Reserve Fund 20% of Annual Revenue 4,582,332 4,628,975 4,675,075 City of Fairhope Electric Department Page 69 of 109 ELECTRIC DEPARTMENT FUND 9/26/2022 Object Description FY 2019 Annual FY 2020 Annual FY 2021 Annual FY2022 Aug YTD FY2022 Annual Budget FY2023 Annual Budget REVENUES 40835 Federal Grants - 17,194 713 - - - 40840 Fema-Grant Revenues - 719,940 121,318 - - - 40900 Transfers In Captl Purchases 73,824 113,694 - - - - 40902 Transfers In Captl Purchases Gas - - 8,666 - - 53,282 40904 Transfers In Captl Purchases W/S - - 29,713 - - 53,282 41705 Sale of Fixed Assets 300 3,102 3,575 - - - 42510 Sale of Electric Energy 20,544,997 20,089,648 19,852,581 17,779,930 22,404,541 22,500,000 42520 Revenue Late Charges 160,835 115,455 161,142 108,704 136,894 135,000 42530 Pole Rental-Telephone Co 26,960 26,960 34,480 - 29,656 29,656 42540 Pole Rental-Cable T.V. 40,980 40,980 40,980 - 45,078 45,078 42550 Pole Rent-Riviera 426 - 426 - 426 426 42560 Temp Service Charges 1,950 1,550 850 3,950 1,500 1,500 45620 Rate Stabilization Funds - - 1,636,546 - 2,100,000 2,100,000 45625 Grants-Smart Grid Initiative - 1,314,759 - - - - 45635 Grant income-ALDOT 21,993 - - - - - 49010 Interest Earned 22,269 127,938 98,559 105,762 88,000 90,000 49030 Insurance Claim - - 66,001 - - - 49035 Rebate Income 5,776 5,637 5,986 5,877 5,000 5,000 49040 Miscellaneous Revenue 17,521 45,349 100,527 30,430 39,917 30,000 49055 AMEA Income-Training - - 10,000 - 10,000 25,000 49060 Connection Fees 105,917 40,841 43,315 42,965 78,919 50,000 49080 Community Dev Revenue 352 49 87 (857) - - 49080 Community Dev Revenue 352 49 87 (857) - - 49892 Transfers In-Gas Fund - 1,000,000 - - - - 49995 UB Clearing (4) (0) - - - - 49998 Budget rollover - - - - (45,289) 3,161,945 49999 Inventory revenue - - - 327 - - TOTAL REVENUES 21,024,446 23,663,147 22,215,550 18,076,230 24,894,641 28,280,169 EXPENSES 50020 Purchased Power-Elect 12,330,272 11,330,913 12,488,709 8,875,680 12,712,854 13,500,000 50025 Collection Costs/Revenue Dept 33,000 37,000 35,000 149,640 149,640 160,696 50026 Administrative Costs 761,000 852,000 872,000 837,000 837,000 911,026 50040 Salaries-Oper&Maint 908,561 1,205,865 1,317,982 1,153,171 1,486,033 1,780,126 50045 Overtime 127,266 152,741 105,669 111,283 137,241 115,000 50190 Employee Payroll Taxes 92,809 103,584 103,313 94,465 124,180 154,512 50200 Employee Retirement Exp 56,497 107,865 113,709 109,601 125,618 164,973 50210 Insurance, Employees Group 277,292 283,412 293,242 253,060 315,917 348,038 50215 Required Contrib-OPEB 77,668 230,448 28,037 23,364 28,037 28,037 50220 Casualty/Workers Comp Ins 201,459 170,550 - - - - 50221 Workers Comp Insurance - - 53,066 70,884 63,200 70,694 50222 Casualty/Property Insurance - - 135,503 154,372 136,072 162,091 50230 Training/School/Travel 42,872 25,279 33,620 60,750 85,925 100,000 50250 Trustee Fees 835 858 - 99 850 500 50270 Audit & Accounting 23,304 23,297 12,476 26,212 23,000 17,000 50280 Legal Fees - - 856 - - - 50290 Professional Services 194,272 45,112 48,583 124,174 78,000 118,000 50300 Computer Expense 58,958 90,092 44,543 17,148 28,789 45,562 50320 Office Supplies 1,727 873 478 1,217 1,600 1,600 50325 Printers/Copiers/OE and supp - 5,067 5,917 4,369 6,346 11,236 50530 Bond Issue Expense - 857 - - - - 50330 Postage 37,653 39,473 39,572 49,269 40,000 50,000 50340 Operating Supplies 103,679 74,828 160,997 81,049 125,000 256,517 50360 Maintenance-Buildings 20,078 15,915 26,701 18,979 27,000 95,000 50365 Maintenance-Plant 351,272 80,179 189,970 141,776 460,000 250,000 50380 Communications 38,054 38,241 33,207 21,923 23,600 20,692 50390 Dues-Memberships-Subscrip 4,974 4,909 5,367 9,310 10,000 15,000 50395 Employment Screening - - 1,060 1,151 1,500 1,500 50400 Miscellaneous - - 378 - - - 50410 Cash Over or Short 553 (165) 210 1,052 - - 50420 Bad Debts 125,851 67,894 42,693 66,194 150,000 150,000 50430 Gasoline & Oil 33,806 98,800 37,099 42,463 60,000 60,000 50435 Small Equipment - - - - - 12,000 50440 Maintenance-Vehicles&Equip 56,438 66,098 47,391 78,952 82,162 106,000 Page 70 of 109 ELECTRIC DEPARTMENT FUND 9/26/2022 Object Description FY 2019 Annual FY 2020 Annual FY 2021 Annual FY2022 Aug YTD FY2022 Annual Budget FY2023 Annual Budget 50460 Uniforms 11,795 1,480 531 1,073 1,000 1,500 50462 Safety Wear and PPE 476 13,110 20,408 15,690 37,967 63,200 50490 Community Dev Projects - - - (306) - - 50470 Purchases Vehicles & Equipment - - - 415,286 529,627 532,590 50473 Warehouse Improvement Purchase - - - 466,570 243,600 199,847 50475 Capital Improvements - - - 8,480 - 205,000 50501 Depreciation Adjustment 9,430 - - - - - 50545 Hurricane Assistance 505 - - - - - 50474 Warehouse Building Purchases - - - 394 - - 50495 Amortization Expense 8,040 8,040 - - 8,040 - 50500 Depreciation 820,232 851,630 979,888 898,267 850,000 850,000 50510 Interest Expense 28,703 11,681 8,796 2,779 3,200 3,200 50560 Credit Card Processing Fees 56,877 60,726 65,754 93,963 55,000 80,000 50580 Bank Fees 4,516 12,895 13,064 12,468 15,000 15,000 50900 Transfers Out Captl Purchases 85,766 58,367 15,464 172 - - 50920 Transfers to General Fund 168,000 - - 537,655 537,655 499,803 50925 Transfers for Comm Dev 334,000 254,000 604,085 - - - 51025 Colony Rent - 338 338 778 500 800 51030 Publications Newspapers 2,976 1,118 885 - 1,500 1,000 52510 Utilities for City Use 285,921 229,612 65,271 61,143 76,000 76,000 56015 Hurricane Sally - 762,268 232,814 - - - 56025 Hurricane Zeta - - 10,390 - - - 50340 General Supplies - 6,918 - - - - 59100 SCADA Capital Purch Budget - - - 51,578 86,667 100,000 59110 AMI Capital - - - - - 2,250,000 59500 Capital Sys Improve Budget - - - 830,004 4,259,900 3,736,430 59998 Reserve Requirements per Ordin - - - - 960,000 960,000 TOTAL EXPENSES 17,777,386 17,424,168 18,295,034 15,974,601 24,985,219 28,280,169 EXCESS REVENUE OVER EXPENSE 3,247,061 6,238,978 3,920,517 2,101,629 (90,578) - Page 71 of 109 Actual Actual Actual Actual Budget Budget Estimated Projected Projected Projected Projected Projected Category FY 2019 FY 2020 FY 2021 YTD 8/31/2022 FY 2022 FY 2023 Growth Rate FY 2024 FY 2025 FY 2026 FY 2027 FY 2028 Sales and Services 20,544,997 20,089,648 19,852,581 17,779,930 22,404,541 22,500,000 1.0%22,725,000 22,952,250 23,181,773 23,413,590 23,647,726Other charges, sales and receipts 361,013 279,924 467,368 193,109 347,389 321,660 1.0%324,877 328,125 331,407 334,721 338,068Interest income 22,269 127,938 98,559 105,762 88,000 90,000 95,000 95,000 95,000 95,000 95,000Grants21,993 2,051,893 122,031 0 0 0Rate Stablization Funds 0 0 1,636,546 0 2,100,000 2,100,000 Total Revenue 20,950,271$ 22,549,403$ 22,177,085$ 18,078,801$ 24,939,930$ 25,011,660$ N/A 23,144,877 23,375,375 23,608,179 23,843,311 24,080,794 Operations Expenses Compensation & Benefits 1,540,093 2,083,915 2,015,017 1,815,829 2,280,226 2,661,380 4.0%2,767,835 2,878,548 2,993,690 3,113,438 3,237,975Energy Purchases 12,330,272 11,330,913 12,488,709 8,875,680 12,712,854 13,500,000 2.0%13,770,000 14,045,400 14,326,308 14,612,834 14,905,091Supplies, Repairs & Maintenace 533,193 244,811 425,538 321,972 695,762 721,117 2.0%735,539 750,250 765,255 780,560 796,171Services Provided by Others 217,576 73,477 67,830 154,755 107,346 146,236 1.0%147,698 149,175 150,667 152,174 153,696Utilties & Communication 323,975 267,852 98,478 83,067 99,600 96,692 1.0%97,659 98,635 99,622 100,618 101,624Travel/Training 42,872 25,279 33,620 60,750 85,925 100,000 1.0%101,000 102,010 103,030 104,060 105,101Other Operating Expenditures 415,383 494,184 364,333 398,835 388,178 496,153 1.0%501,114 506,125 511,187 516,299 521,462Interest expense 28,703 11,681 8,796 2,779 3,200 3,200 Per Sch 2,145 1,608 1,065 715 560Depreciation Expenses 820,232 851,630 979,888 898,267 850,000 850,000 1.0%858,500 867,085 875,756 884,513 893,359Bad Debt/Amortization 133,891 75,933 42,693 66,194 158,040 150,000 1.0%154,500 156,045 157,605 159,182 160,773 Total Oper. Expenses 16,386,190$ 15,459,676$ 16,524,903$ 12,678,127$ 17,381,131$ 18,724,777$ N/A 19,135,990 19,398,838 19,826,580 20,265,211 20,715,038 Revenue Minus Op Exp 4,564,081$ 7,089,727$ 5,652,182$ 5,400,674$ 7,558,799$ 6,286,883$ N/A 4,008,886 3,976,537 3,781,599 3,578,100 3,365,756 Other Sources/UsesOther SourcesBorrowed Funds Variable 0 0 0 0 0Other Sources Total Other Sources -$ -$ -$ -$ -$ -$ N/A 0 0 0 0 0 Other UsesAdministrative Cost Paid To Gen Fund 761,000 852,000 872,000 837,000 837,000 911,026 2.0%929,247 947,831 966,788 986,124 1,005,846Collection cost/Revenue Dept 33,000 37,000 35,000 149,640 149,640 160,696 2.0%163,910 167,188 170,532 173,943 177,421Transfer to General Fund 502,000 254,000 604,085 537,655 537,655 499,803 2.0%509,799 519,995 530,395 541,003 551,823Transfers In/Out Capital Purchases 11,942 (55,328)(22,914)172 0 (106,564)0 0 0 0 0Warrant & Lease Payments 0 0 0 0 0 43,782 Per Schedule 41,108 41,586 42,586 42,662 12,070Reserve for Capital Equipment/Improvements 0 0 0 0 859,894 1,037,437 Variable 500,000 500,000 500,000 500,000 500,000Reserve for System Upgrades 0 0 0 0 4,259,900 5,986,430 Variable 1,398,000 2,160,000 1,680,000 1,740,000 1,700,000 Reserve requirements per ordinance 960,000 Variable 960,000 960,000 960,000 960,000 960,000Transfer to Electric 0 0 0 0 0 0 N/A 0 0 0 0 0 Total Other Uses 1,307,942$ 1,087,672$ 1,488,171$ 1,524,467$ 6,644,089$ 9,492,610$ 0.0%4,502,064 5,296,601 4,850,301 4,943,731 4,907,160 Net Other Sources/Uses (1,307,942)(1,087,672)(1,488,171)(1,524,467)(6,644,089)(9,492,610)N/A (4,502,064)(5,296,601)(4,850,301)(4,943,731)(4,907,160) Excess/(Deficit) for Year 3,256,139$ 6,002,055$ 4,164,011$ 3,876,207$ 914,711$ (3,205,727)$ N/A (493,177)(1,320,063)(1,068,702)(1,365,631)(1,541,404) Add back Depreciation Exp 820,232$ 851,630$ 979,888$ 898,267$ 850,000$ 850,000$ 858,500$ 867,085$ 875,756$ 884,513$ 893,359$ Net Excess/(Deficit) $ 4,076,370 6,853,685$ 5,143,900$ 4,774,474$ 1,764,711$ (2,355,727)$ 365,323 (452,978)(192,946)(481,118)(648,046) Cash Balances As of 9/30/19 As of 9/30/20 As of 9/30/21 As of 8/31/2022 Cash - Operating 2,138,403$ 3,213,271$ 1,484,907$ 954,935$ Cash - Pooled Depository 1,360,941$ 1,384,970$ 341,323$ 815,648$ Cash - Electric Reserves Centennial 1,924,393$ 2,852,459$ 3,882,586$ 4,830,609$ Cash - Super Fund Savings -$ -$ -$ -$ Cash - Reserve Fund Vision -$ -$ -$ -$ Cash - Utility Reserve Fund -$ -$ -$ -$ Cash - Second Utility Reserve 0$ -$ -$ -$ Cash - Emergency Relief Checking 25,166$ 23,653$ 23,765$ 23,805$ Restricted*Restricted*Cash - Customer Deposit Reserve 1,094,411$ 1,124,266$ 1,129,373$ 1,129,373$ Restricted*Restricted* Total Cash 6,543,313$ 8,598,618$ 6,861,954$ 7,754,371$ Targeted Reserved Fund Balance $ 4,186,521 $ 4,181,202 $ 4,073,914 $ 4,073,914 $ 3,594,608 $ 4,550,386 4,550,386 4,609,975 4,656,075 4,702,636 4,749,662 Notes: 10/04/2022 City of Fairhope Electric Department Recommended Targeted Reserve Fund 20% of annual revenue Page 72 of 109 Fairhope Utilities ELECTRIC Department 5-Year Plan Fiscal Year Project/Personnel Description Estimated Cost Estimated engineering & contingency (20%) 2023 Transmission System Upgrades Install a new #397 ACSR Line along Morphy, from Ingleside to Greeno, north up Greeno to Dyer. Total length will be approximately 1.4 miles. Cost includes installation of 3 new GOS's in the 44 KV system $1,750,00 $350,000 Upgrade Existing 44 KV poles along Dyer Road from Greeno to Bishop $200,000 $40,000 Underground distribution Underground on Magnolia from Church Street to Bancroft $750,000 TOTAL $3,090,000 2024 Distribution System Upgrades Upgrade Existing #2/0 and #4/0 ACSR conductors along Summit Street and White Avenue, south from Morphy, and over to Liberty Street, approximately 0.4 miles, to #397 ACSR $280,000 $56,000 Upgrade existing #1/0 ACSR conductors along South Mobile Street, from White Avenue down to Pier Avenue, approximately 0.5 miles, to #4/0 ACSR $325,000 $65,000 Install new 12 KV GOS's at 8 locations $160,000 $32,000 Install new 12 KV reclosers at 8 locations $400,000 $80,000 TOTAL $1,398,000 2025 Distribution System Upgrades Upgrade approximately 3.5 miles of existing old copper conductors to #1/0 ACSR (21 locaitons)$1,800,000 $360,000 TOTAL $2,160,000 2026 Distribution System Upgrades Upgrade existing #4/0 ACSR conductors along Nichols from Ingleside to Greeno, approximately 0.4 miles, to #397 ACSR $280,000 $56,000 Upgrade approximately 1.6 miles of existing copper conductors to #397 ACSR (2 locations)$1,120,000 $224,000 TOTAL $1,680,000 2027 Distribution System Upgrades Upgrade existing #4/0 ACSR conductors along Bancroft from Equality Avenue up to Bayou Street, approximately 0.4 miles, to #397 ACSR $280,000 $56,000 Upgrade approximately 1.8 miles of existing copper conductors to #4/0 ACSR (3 locations)$1,170,000 $234,000 TOTAL $1,740,000 Page 1 of 1 Page 73 of 109 Projected Projected FY 2023 FY 2024 FY 2025 Budget Budget Budget Total Revenue 16,655,800 15,283,508 15,509,923 Total Operating Expense 11,880,831 12,057,621 12,272,626 Revenue Minus Operating Expenses 4,774,969 3,225,887 3,237,297 Other Sources Borrowed Funds (line of credit)15,000,000 - - Other Uses Reserve for Capital Equipment/Improvements 972,124 1,000,000 1,000,000 Reserve for System Upgrades 23,646,780 19,165,000 8,280,000 Warrant & Lease Payments 1,637,784 1,656,828 1,680,633 Reserve requirements per ordinance 875,000 875,000 875,000 General Fund Transfer 290,324 296,130 302,053 Total Other Uses 27,422,012 22,992,958 12,137,686 Excess/(Deficit) for the Year (7,647,043) (19,767,072) (8,900,389) Add back Depreciation Expense 1,535,000 1,631,050 1,664,128 Net Excess/(Deficit)(6,112,043) (18,136,022) (7,236,261) CASH 8/31/2022 Cash-Operating 4,902,083 Cash-Water Reserve 950,764 Cash-Reserve Water-Tap/SDC 3,449,156 Cash-Reserve Sewer-Tap 1,657,700 10,959,703 Targeted Reserve Fund 20% of Annual Revenue 2,996,160 3,056,702 3,101,985 City of Fairhope Water & Wastewater Department Page 74 of 109 Actual Actual Actual Actual Budget Budget Estimated Projected Projected Projected Projected ProjectedCategoryFY 2019 FY 2020 FY 2021 YTD 7/31/2022 FY 2022 FY 2023 Growth Rate FY 2024 FY 2025 FY 2026 FY 2027 FY 2028Sales and Services 10,791,350 12,127,989 12,703,925 12,992,708 12,770,396 13,700,000 1.0%13,911,000 14,125,590 14,343,836 14,565,803 14,791,561Other charges, sales and receipts 1,836,087 1,585,924 2,029,808 1,280,764 1,625,800 1,170,800 1.0%1,182,508 1,194,333 1,206,276 1,218,339 1,230,523Interest income 75,290 209,460 116,664 126,477 120,000 110,000 190,000 190,000 190,000 190,000 190,000Grants68,784 248,093 (32,335)0 1,562,500 1,675,000Budget Rollover 0 0 0 0 5,779,509 6,009,259 Total Revenue 12,771,511$ 14,171,467$ 14,818,062$ 14,399,949$ 16,078,696$ 16,655,800$ N/A 15,283,508 15,509,923 15,740,112 15,974,142 16,212,084 Operations ExpensesCompensation & Benefits 2,136,937 2,555,837 2,805,489 2,602,795 3,000,445 3,585,929 3.0%3,711,742 3,842,060 3,977,046 4,116,870 4,261,709Energy Purchases 561,000 591,229 592,438 478,949 585,000 585,000 2.0%596,700 613,377 630,530 633,077 635,675Supplies, Repairs & Maintenace 1,492,859 1,099,296 1,577,503 1,449,361 1,908,500 2,149,100 2.0%2,192,082 2,247,376 2,304,120 2,362,352 2,422,114Services Provided by Others 664,358 709,609 797,465 648,149 953,500 1,026,650 1.0%1,036,917 1,063,768 1,091,382 1,119,782 1,148,990Utilties & Communication 333,644 298,945 300,048 266,499 265,128 271,720 1.0%274,437 279,284 284,243 289,317 294,508Travel/Training 19,840 21,047 21,540 28,068 49,575 48,200 1.0%48,682 49,627 50,595 51,586 52,603Other Operating Expenditures 495,354 566,377 545,708 628,326 511,470 764,180 1.0%771,821 787,408 803,386 819,767 836,563 Interest expense 401,350 380,662 334,304 110,709 127,366 106,525 Per Sch 85,439 64,079 42,445 28,490 22,304Depreciation Expenses 1,549,906 1,481,001 1,611,230 1,669,580 1,535,000 1,535,000 1.0%1,550,350 1,582,721 1,615,921 1,649,974 1,684,905Bad Debt/Amortization (10,615)56,367 (50,949)24,777 87,050 80,000 0.0%80,700 81,407 82,121 82,842 83,571 Total Oper. Expenses 7,644,633$ 7,760,369$ 8,534,775$ 7,907,214$ 9,023,034$ 10,152,303$ N/A 10,348,870 10,529,700 10,799,668 11,071,215 11,359,371 Revenue Minus Op Exp 5,126,878$ 6,411,098$ 6,283,287$ 6,492,735$ 7,055,662$ 6,503,497$ N/A 4,934,638 4,980,223 4,940,444 4,902,927 4,852,713 Other Sources/UsesOther SourcesBorrowed Funds -$ -$ -$ -$ 10,000,000$ 15,000,000$ Variable 0 0 0 0 0Other Sources Total Other Sources -$ -$ -$ 10,000,000$ 15,000,000$ N/A 0 0 0 0 0 Other UsesAdministrative Cost Paid To Gen Fund 762,000 851,000 871,000 837,000 837,000 911,026 2.0%929,247 947,831 966,788 986,124 1,005,846Collection cost/Revenue Dept 137,000 160,000 157,000 692,595 692,595 764,220 2.0%779,504 795,094 810,996 827,216 843,761Transfer to General Fund 968,000 267,000 608,581 551,190 551,190 290,324 2.0%296,130 302,053 308,094 314,256 320,541Transfers In/Out Capital Purchases 89,895 115,214 45,177 0 0 53,282 0 0 0 0 0Warrant & Lease Payments 0 0 0 0 527,354 1,637,784 Per Schedule 1,656,828 1,680,633 1,699,677 480,861 485,622Reserve for Capital Equipment/Improvements 0 0 0 714,743 1,563,086 972,124 Variable 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000Reserve for System Upgrades 0 0 0 4,246,207 18,523,800 23,646,780 19,165,000 8,280,000 3,000,000 4,000,000 4,000,000Reserve requirements per ordinance 0 0 0 0 440,550 875,000 875,000 875,000 875,000 875,000 875,000Total Other Uses 1,956,895$ 1,393,214$ 1,681,758$ 7,041,735$ 22,695,025$ 29,150,540$ 0.0%24,701,709 13,880,612 8,660,556 8,483,457 8,530,770 Net Other Sources/Uses (1,956,895)(1,393,214)(1,681,758)(7,041,735)(12,695,025)(14,150,540)N/A (24,701,709)(13,880,612)(8,660,556)(8,483,457)(8,530,770) Excess/(Deficit) for Year 3,169,983$ 5,017,884$ 4,601,529$ (549,001)$ (5,639,363)$ (7,647,043)$ N/A (19,767,072)(8,900,389)(3,720,111)(3,580,530)(3,678,057) Add back Depreciation Exp 1,549,906$ 1,481,001$ 1,611,230$ 1,669,580$ 1,535,000$ 1,535,000$ 1,631,050$ 1,664,128$ 1,698,042$ 1,732,816$ 1,768,476$ Net Excess/(Deficit)4,719,890$ 6,498,885$ 6,212,759$ 1,120,579$ (4,104,363)$ (6,112,043)$ (18,136,022)(7,236,261)(2,022,070)(1,847,714)(1,909,581) Cash Balances As of 9/30/19 As of 9/30/20 As of 9/30/2021 As of 8/31/2022Cash - Operating 5,802,475$ 5,363,615$ 6,251,995$ 4,606,697$ Cash - Pooled Depository 274,822$ 334,665$ 183,028$ 298,117$ Cash - Water Reserve 641,770$ 733,755$ 840,182$ 950,764$ Restricted*Cash - SDC Water Reserve -$ -$ -$ 239,800$ Restricted*Cash - SDC Wastewater Reserve -$ -$ -$ 265,500$ Restricted*Cash - Superfund-Wtr Tap Res 2,084,610$ 2,471,808$ 2,930,981$ 3,209,356$ Restricted* Cash - Savings-Sewer Tap Fee 844,749$ 1,048,404$ 1,286,934$ 1,392,200$ Restricted*Cash - WS Customer Deposit Res 413,404$ 433,027$ 451,917$ 451,917$ Restricted* Total Cash 10,061,830$ 10,385,275$ 11,945,038$ 11,414,352$ Targeted Reserved Fund Balance $ 2,525,487 $ 2,525,487 $ 2,742,783 $ 2,854,694 $ 2,974,160 $ 3,018,702 $ 3,063,985 $ 3,110,022 $ 3,156,828 $ 3,204,417 Notes: 10/04/2022 City of Fairhope Water & Wastewater Department Recommended Targeted Reserve Fund 20% of annual revenue Page 75 of 109 WATER DEPARTMENT 9/26/2022 Object Description FY 2019 Annual FY 2020 Annual FY 2021 Annual FY2022 Aug YTD FY2022 Annual Budget FY2023 Annual Budget REVENUES 40840 Fema-Grant Revenues - 16,317 (1,549) - - - 40900 Transfers In Captl Purchases 14,765 - - - - - 41705 Sale of Fixed Assets 16,011 32,064 46 1,907 - - 42520 Revenue Late Charges 53,542 38,435 53,640 36,197 55,000 40,000 43010 Water Sales 6,433,116 7,290,522 7,185,445 6,873,357 7,300,000 7,400,000 43030 Tel Companies Antenna Rent 174,899 182,552 171,870 192,928 175,000 200,000 45635 Grant income-ALDOT 34,392 4,328 1,252 - - - 49010 Interest Earned 46,772 200,166 84,363 88,721 100,000 90,000 49035 Rebate Income 3,755 4,877 3,891 3,820 4,000 4,000 49040 Miscellaneous Revenue 43,689 27,924 14,608 60,797 15,000 50,000 49045 Loan Proceeds - - - - 5,000,000 7,500,000 49060 Connection Fees 1,211,092 831,639 1,034,752 689,660 1,000,000 500,000 49080 Community Dev Revenue 342 48 84 832 - - 49998 Budget Rollover - - - - 1,016,669 5,652,896 TOTAL REVENUES 8,032,375 8,628,873 8,548,404 7,948,218 14,665,669 21,436,896 EXPENSES 50020 Purchased Power-Elect 98,966 121,069 124,502 78,933 120,000 120,000 50025 Collection Costs/Revenue Dept 87,000 101,000 98,000 431,066 431,066 484,913 50026 Administrative Costs 495,000 553,000 566,000 544,050 544,050 592,167 50040 Salaries-Oper&Maint 685,101 785,305 889,381 797,946 952,023 1,184,099 50045 Overtime 63,719 99,288 120,251 154,583 111,124 120,000 50190 Employee Payroll Taxes 57,534 67,471 73,467 72,643 81,331 102,860 50200 Employee Retirement Exp 30,403 69,520 77,674 78,879 82,415 106,139 50210 Employee Medical Insurance 124,810 217,486 205,217 181,616 221,851 252,413 50215 Required Contrib-OPEB (16,602) 46,367 28,037 23,364 28,037 28,037 50220 Casualty/Workers Comp Ins 115,600 124,045 0 - - - 50221 Workers Comp Insurance - - 23,646 30,183 25,200 30,043 50222 Casualty/Property Insurance - - 96,720 116,731 94,849 122,568 50230 Training/School/Travel 8,007 14,482 11,727 14,295 28,000 25,530 50250 Trustee Fees 6,067 6,201 - 3,928 6,000 6,000 50270 Audit & Accounting 10,662 11,223 10,093 25,488 11,000 10,000 50280 Legal Fees - - - - 3,000 3,000 50290 Professional Services 29,401 33,015 30,290 17,050 102,000 197,700 50300 Computer Expense 35,761 61,125 26,481 8,075 8,429 21,301 50320 Office Supplies 1,524 1,825 766 4,619 2,500 8,000 50325 Printers/Copiers/OE and supp - 3,282 3,684 2,689 3,484 9,200 50330 Postage 25,688 25,260 25,579 32,001 26,000 30,000 50340 Operating Supplies 40,899 46,171 64,371 44,536 30,000 15,000 50360 Maintenance-Buildings 17,432 8,951 58,314 35,343 40,000 50,000 50364 Maintenance-Fountains - - 69 2,995 12,000 12,000 50365 Maintenance-Plant 609,895 312,469 360,797 206,357 125,000 175,000 50366 Maintenance-Distribution Sys - - 38,278 146,619 285,000 300,000 50380 Communications 24,672 23,674 23,507 16,338 13,100 17,610 50390 Dues-Memberships-Subscrip 4,334 4,381 4,576 5,176 8,300 10,000 50395 Employment Screening - - 1,286 856 1,500 1,500 50420 Bad Debts 68,852 40,094 32,184 16,105 70,000 70,000 50430 Gasoline & Oil 40,561 29,205 37,885 55,917 40,000 60,000 50435 Small Equipment - - - 36,979 40,000 40,000 50440 Maintenance-Vehicles&Equip 48,177 43,063 94,615 71,365 51,300 51,300 50460 Uniforms 3,341 6,277 2,659 5,788 12,000 15,000 50462 Safety Wear and PPE - 4,578 8,606 2,699 13,758 13,800 50470 Purchases Vehicles & Equipment - - - 189,785 305,384 240,540 50473 Warehouse Improvement Purchase - - - 119,353 157,500 70,000 50490 Community Dev Projects - - - (199) - - 50495 Amortization Expense 7,041 7,041 - - 7,050 - 50500 Depreciation 697,166 876,979 933,967 751,311 700,000 700,000 50501 Depreciation Adjustment 6,918 - - - - - 50510 Interest Expense 140,472 133,232 58,010 38,748 44,578 37,284 50520 Rental-other 14,158 7,892 2,277 17,630 15,000 30,000 50530 Bond Issue Expense - 34,160 - - - - 50560 Credit Card Processing Fees 36,969 39,471 40,648 51,873 34,000 40,000 50580 Bank Fees 2,936 8,376 8,676 8,312 10,000 10,000 50900 Transfers Out Captl Purchases 104,500 74,889 - - - - Page 76 of 109 WATER DEPARTMENT 9/26/2022 Object Description FY 2019 Annual FY 2020 Annual FY 2021 Annual FY2022 Aug YTD FY2022 Annual Budget FY2023 Annual Budget 50904 Transfers Out Captl Purchases W/S - - 26,466 - - 37,269 50920 Transfers to General Fund 246,000 - - 551,190 551,190 290,324 50925 Transfers for Comm Dev 722,000 267,000 608,581 - - - 51025 Colony Rent - 270 287 282 300 300 51030 Publications Newspapers 538 - - - - 5,000 52510 Utilities for City Use 167,782 151,914 147,530 156,519 150,000 150,000 53010 Chemicals & Testing 205,302 146,356 170,806 45,068 75,000 75,000 53011 Chemicals - Water Treament - - - 245,798 175,000 300,000 59100 SCADA Capital Purch Budget - - - 14,756 20,000 15,000 59500 System Improve-Distribution Sys - - - 1,483,581 4,930,000 9,800,000 59501 System Impr-Water Plan/Wells - - - 792,205 3,425,800 4,851,000 59998 Reserve Requirements per Ordin - - - - 440,550 500,000 TOTAL EXPENSES 5,068,585 4,607,404 5,135,910 7,731,423 14,665,669 21,436,896 EXCESS REVENUE OVER EXPENSES 2,963,789 4,021,468 3,412,494 216,795 - - Page 77 of 109 Actual Actual Actual Actual Budget Budget Estimated Projected Projected Projected Projected ProjectedCategoryFY 2019 FY 2020 FY 2021 YTD 8/31/2022 FY 2022 FY 2023 Growth Rate FY 2024 FY 2025 FY 2026 FY 2027 FY 2028 Sales and Services 6,433,116 7,290,522 7,180,389 6,873,357 7,300,000 7,400,000 2.0%7,548,000 7,698,960 7,852,939 8,009,998 8,170,198Other charges, sales and receipts 1,503,330 1,117,539 1,278,893 986,140 1,249,000 794,000 1.0%801,940 809,959 818,059 826,240 834,502 Interest income 46,772 199,554 84,363 88,721 100,000 90,000 95,000 95,000 95,000 95,000 95,000Grants34,392 23,526 4,926 0 0 0Budget Rollover 0 0 0 0 1,016,669 5,652,896 Total Revenue 8,017,610$ 8,631,142$ 8,548,570$ 7,948,218$ 9,665,669$ 8,284,000$ N/A 8,444,940 8,603,919 8,765,998 8,931,238 9,099,700 Operations ExpensesCompensation & Benefits 1,029,046 1,233,858 1,403,256 1,339,214 1,501,981 1,823,591 4.0%1,896,534 1,972,396 2,051,292 2,133,343 2,218,677Energy Purchases 98,966 121,069 124,502 78,933 120,000 120,000 2.0%122,400 124,848 127,345 129,892 132,490Supplies, Repairs & Maintenace 923,230 558,834 788,790 839,680 835,800 1,026,300 2.0%1,046,826 1,067,763 1,089,118 1,110,900 1,133,118Services Provided by Others 40,063 44,237 40,382 42,538 116,000 210,700 1.0%212,807 214,935 217,084 219,255 221,448Utilties & Communication 192,454 175,587 171,037 172,857 163,100 167,610 1.0%169,286 170,979 172,688 174,415 176,159Travel/Training 8,007 14,482 11,727 14,295 28,000 25,530 1.0%25,785 26,043 26,304 26,567 26,832Other Operating Expenditures 285,951 321,832 259,365 311,956 273,620 374,669 1.0%378,415 382,200 386,022 389,882 393,781Interest expense 140,472 133,232 81,894 38,748 44,578 37,284 Per Sch 29,904 22,428 14,856 9,971 7,807 Depreciation Expenses 697,166 666,450 723,838 751,311 700,000 700,000 1.0%707,000 714,070 721,211 728,423 735,707Bad Debt/Amortization (19,365)40,094 (68,029)16,105 77,050 70,000 1.0%70,700 71,407 72,121 72,842 73,571 Total Oper. Expenses 3,395,991$ 3,309,676$ 3,536,763$ 3,605,637$ 3,860,129$ 4,555,683$ N/A 4,659,658 4,695,660 4,805,919 4,922,648 5,046,019 Revenue Minus Op Exp 4,621,618$ 5,321,466$ 5,011,807$ 4,342,581$ 5,805,540$ 3,728,317$ N/A 3,785,282 3,908,259 3,960,079 4,008,589 4,053,681 Other Sources/Uses Borrowed Funds 0 0 0 0 5,000,000 7,500,000 Variable 0 0 0 0 0Other Sources Total Other Sources -$ -$ -$ -$ 5,000,000$ 7,500,000$ N/A 0 0 0 0 0 Other Uses Administrative Cost Paid To Gen Fund 495,000 553,000 566,000 544,050 544,050 592,167 2.0%604,010 616,091 628,412 640,981 653,800Collection cost/Revenue Dept 87,000 101,000 98,000 431,066 431,066 484,913 2.0%494,611 504,503 514,594 524,885 535,383Transfer to General Fund 968,000 267,000 608,581 551,190 551,190 290,324 2.0%296,130 302,053 308,094 314,256 320,541 Transfers In/Out Capital Purchases 89,895 74,889 26,466 0 0 37,269 0 0 0 0 0Warrant & Lease Payments 0 0 0 0 0 573,224 Per Schedule 579,890 588,222 594,887 168,301 169,968Reserve for Capital Equipment/Improvements 0 0 0 323,694 482,884 325,540 Variable 500,000 500,000 500,000 500,000 500,000 Reserve for System Upgrades 0 0 0 2,275,786 8,355,800 14,651,000 Variable 13,000,000 4,780,000 8,975,000 3,000,000 3,000,000Reserve requirements per ordinance 0 440,550 500,000 500,000 500,000 500,000 500,000 500,000Total Other Uses 1,639,895$ 995,889$ 1,299,047$ 4,125,786$ 10,805,540$ 17,454,437$ 0.0%15,974,642 7,790,869 12,020,987 5,648,423 5,679,692 Net Other Sources/Uses (1,639,895)(995,889)(1,299,047)(4,125,786)(5,805,540)(9,954,437)N/A (15,974,642)(7,790,869)(12,020,987)(5,648,423)(5,679,692) Excess/(Deficit) for Year 2,981,723$ 4,325,577$ 3,712,760$ 216,795$ -$ (6,226,121)$ N/A (12,189,359)(3,882,610)(8,060,908)(1,639,834)(1,626,011) Add back Depreciation Exp 697,166$ 666,450$ 723,838$ 751,311$ 700,000$ 700,000$ 777,700$ 785,477$ 793,332$ 801,265$ 809,278$ Net Excess/(Deficit) $ 3,678,889 4,992,028$ 4,436,597$ 968,106$ 700,000$ (5,526,121)$ (11,411,659)(3,097,133)(7,267,576)(838,569)(816,733) Cash Balances As of 9/30/19 As of 9/30/20 As of 9/30/21 As of 8/31/2022Cash - Operating 5,802,475$ 5,363,615$ 6,251,995$ 4,606,697$ Cash - Pooled Depository 274,822$ 334,665$ 183,028$ 298,117$ Cash - Water Reserves Centennial 641,770$ 733,755$ 840,182$ 950,764$ Restricted*Cash - Superfnd-Water Tap Reserve 2,084,610$ 2,471,808$ 2,930,981$ 3,209,356$ Restricted* Cash - SDC Water Reserve -$ -$ -$ 239,800$ Restricted*Cash - Customer Deposit Reserve 413,404$ 433,027$ 451,917$ 451,917$ Restricted* Total Cash 9,217,081$ 9,336,871$ 10,658,104$ 9,756,653$ Targeted Reserved Fund Balance $ 1,587,289 $ 1,681,612 $ 1,681,612 $ 1,571,899 $ 1,571,899 1,709,800 1,669,988 1,701,784 1,734,200 1,767,248 Notes: 10/04/2022 City of Fairhope Water Department Recommended Targeted Reserve Fund 20% of annual revenue Page 78 of 109 WASTEWATER DEPARTMENT 9/26/2022 Object Description FY 2019 Annual FY 2020 Annual FY 2021 Annual FY2022 Aug YTD FY2022 Annual Budget FY2023 Annual Budget REVENUE 49060 Connection Fees 329,048 466,422 681,787 253,873 375,000 375,000 45635 Grant income-ALDOT 34,392 327 - - - - 41705 Sale of Fixed Assets 160 130 9,715 37,650 - - 49030 Insurance Claim - - 57,319 244 - - 40835 Federal Grants - 2,983 2,213 - 1,000,000 1,000,000 49035 Rebate Income 2,022 1,833 2,095 2,057 1,800 1,800 40840 Fema-Grant Revenues - 221,257 (39,473) - 562,500 675,000 49040 Miscellaneous Revenue 1,527 - - 800 - - 43020 Revenue Wastewater Charges 4,358,235 4,837,467 5,523,536 6,119,351 5,470,396 6,300,000 49010 Interest Earned 28,518 9,906 32,301 37,756 20,000 20,000 49045 Loan Proceeds - - - - 5,000,000 7,500,000 49998 Budget Rollover - - - - 4,762,841 356,363 TOTAL REVENUES 4,753,902 5,540,325 6,269,492 6,451,731 17,192,537 16,228,163 EXPENSES 50020 Purchased Power-Elect 462,034 470,160 467,936 400,016 465,000 465,000 50025 Collection Costs/Revenue Dept 50,000 59,000 59,000 261,529 261,529 279,307 50026 Administrative Costs 267,000 298,000 305,000 292,950 292,950 318,859 50040 Salaries-Oper&Maint 731,528 808,621 897,740 824,518 954,854 1,148,382 50045 Overtime 87,165 125,165 105,686 74,525 114,567 110,000 50190 Employee Payroll Taxes 60,689 70,052 72,119 66,554 81,811 94,531 50200 Employee Retirement Exp 63,259 71,664 77,041 72,742 80,232 100,057 50210 Employee Medical Insurance 122,534 209,528 207,152 188,498 223,162 270,761 50215 Required Contrib-OPEB 42,715 36,950 19,840 9,702 19,840 11,642 59999 Gain/Loss on Fixed Assets 304 - 24,618 - - - 53020 Hwy 9/Baldwin County Swr - - 13 - - - 50220 Casualty/Workers Comp Ins 114,573 124,991 0 - - - 50221 Workers Comp Insurance - - 22,656 27,043 24,000 26,964 50222 Casualty/Property Insurance - - 141,662 130,882 143,850 136,966 50230 Training/School/Travel 11,832 6,565 9,813 13,772 21,575 22,670 50250 Trustee Fees - - - - 1,000 1,000 50270 Audit & Accounting 5,741 6,192 5,664 13,724 8,500 10,000 50280 Legal Fees - 54,583 154,858 58,507 25,000 60,000 50290 Professional Services 79,229 53,797 22,810 74,380 204,000 145,950 50300 Computer Expense 20,483 32,699 18,119 6,801 5,770 8,659 50320 Office Supplies 1,227 1,192 914 866 2,000 2,000 50325 Printers/Copiers/OE and supp - 2,376 3,348 2,363 3,171 4,726 50330 Postage 14,561 15,099 14,002 17,385 13,750 13,750 50340 Operating Supplies 24,195 23,696 85,616 20,492 30,000 20,000 50360 Maintenance-Buildings 19,886 39,200 29,267 28,456 75,000 75,000 50365 Maintenance-Plant/Lift Station 198,797 148,171 306,903 156,833 195,000 250,000 50366 Maintenance-Collection - - - 73,482 100,000 200,000 50367 Maintenance-WWTP - - 800 56,074 200,000 200,000 50380 Communications 48,244 41,993 36,739 21,873 17,028 19,110 50390 Dues-Memberships-Subscrip 2,733 3,079 2,828 3,439 6,700 6,800 50395 Employment Screening - - 393 694 1,000 1,000 50405 Sludge Removal 539,325 550,800 573,750 459,000 600,000 600,000 50420 Bad Debts 8,750 16,272 17,079 8,672 10,000 10,000 50430 Gasoline & Oil 24,926 20,009 46,846 72,033 5,000 75,000 50435 Small Equipment - - - 23,373 40,000 40,000 50440 Maintenance-Vehicles&Equip 31,150 41,481 41,169 34,793 50,700 50,800 50460 Uniforms 6,721 2,813 3,144 5,276 10,000 10,000 50462 Safety Wear and PPE - 10,804 5,041 5,108 14,408 13,400 50470 Purchases Vehicles & Equipment - - (0) 353,806 731,607 451,584 50473 Warehouse Improvement Purchase - - - 7,248 142,500 115,000 50500 Depreciation 852,740 814,551 887,392 918,269 835,000 835,000 50510 Interest Expense 260,877 247,430 252,410 71,961 82,788 69,241 50520 Rental-other 217 6,211 22,339 28,059 5,000 75,000 50560 Credit Card Processing Fees 19,906 21,253 23,910 40,382 20,000 35,000 50580 Bank Fees 1,581 4,510 3,919 3,740 4,500 4,500 51025 Colony Rent - 200 209 209 200 210 51030 Publications Newspapers 3,702 500 582 - 3,500 3,500 50490 Community Dev Projects - - - (107) - - 50900 Transfers Out Captl Purchases - 40,325 - - - - Page 79 of 109 WASTEWATER DEPARTMENT 9/26/2022 Object Description FY 2019 Annual FY 2020 Annual FY 2021 Annual FY2022 Aug YTD FY2022 Annual Budget FY2023 Annual Budget 50904 Transfers Out Captl Purchases W/S - - 18,711 - - 16,013 52510 Utilities for City Use 92,946 81,364 92,272 71,769 85,000 85,000 53010 Chemicals & Testing 294,373 286,722 324,044 171,282 125,000 145,000 53011 Chemicals - Wastewater Treatment - - - 4,000 30,000 15,000 53012 Chemicals - Odor Control - - - 40,032 225,000 125,000 59100 SCADA Capital Purch Budget - - - 30,101 206,095 80,000 59500 System Improve-Collection Syst - - - 1,673,131 8,260,000 6,508,680 59501 System Impr-Lift Stations - - - 297,291 1,750,000 1,997,600 59502 System Improvement-WWTP - - - - 158,000 489,500 59998 Reserve Requirements per Ordin - - - - 226,950 375,000 59999 Gain/Loss on Fixed Assets 304 - 24,618 - - - 56015 Hurricane Sally - 231,816 22,204 - - - 56025 Hurricane Zeta - - 9,332 - - - TOTAL EXPENSES 4,566,250 5,079,834 5,461,510 7,217,526 17,192,537 16,228,163 Excess Rev Over Expense 187,652 460,490 807,983 (765,796) - - Page 80 of 109 Actual Actual Actual Actual Budget Budget Estimated Projected Projected Projected Projected ProjectedCategoryFY 2019 FY 2020 FY 2021 YTD 8/31/2022 FY 2022 FY 2023 Growth Rate FY 2024 FY 2025 FY 2026 FY 2027 FY 2028Sales and Services 4,358,235 4,837,467 5,523,536 6,119,351 5,470,396 6,300,000 1.0%6,363,000 6,426,630 6,490,896 6,555,805 6,621,363Other charges, sales and receipts 332,757 468,385 750,915 294,624 376,800 376,800 1.0%380,568 384,374 388,217 392,100 396,021Interest income 28,518 9,906 32,301 37,756 20,000 20,000 95,000 95,000 95,000 95,000 95,000Grants34,392 224,567 (37,261)0 1,562,500 1,675,000Budget Rollover 0 0 0 0 4,762,841 356,363 Total Revenue 4,753,902$ 5,540,325$ 6,269,492$ 6,451,731$ 7,429,696$ 8,371,800$ N/A 6,838,568 6,906,004 6,974,114 7,042,905 7,112,384 Operations ExpensesCompensation & Benefits 1,107,890 1,321,979 1,402,233 1,263,581 1,498,465 1,762,338 3.0%1,815,208 1,869,664 1,925,754 1,983,527 2,043,032Energy Purchases 462,034 470,160 467,936 400,016 465,000 465,000 2.0%474,300 488,529 503,185 503,185 503,185Supplies, Repairs & Maintenace 569,629 540,462 788,713 609,682 1,072,700 1,122,800 2.0%1,145,256 1,179,614 1,215,002 1,251,452 1,288,996Services Provided by Others 624,295 665,372 757,082 605,611 837,500 815,950 1.0%824,110 848,833 874,298 900,527 927,543Utilties & Communication 141,190 123,358 129,011 93,642 102,028 104,110 1.0%105,151 108,306 111,555 114,902 118,349Travel/Training 11,832 6,565 9,813 13,772 21,575 22,670 1.0%22,897 23,584 24,291 25,020 25,770Other Operating Expenditures 209,403 244,545 286,344 316,370 237,850 389,511 1.0%393,406 405,208 417,365 429,885 442,782Interest expense 260,877 247,430 252,410 71,961 82,788 69,241 Per Sch 55,535 41,652 27,589 18,518 14,498Depreciation Expenses 852,740 814,551 887,392 918,269 835,000 835,000 1.0%843,350 868,651 894,710 921,551 949,198Bad Debt/Amortization 8,750 16,272 17,079 8,672 10,000 10,000 0.0%10,000 10,000 10,000 10,000 10,000 Total Oper. Expenses 4,248,642$ 4,450,693$ 4,998,013$ 4,301,577$ 5,162,905$ 5,596,620$ N/A 5,689,213 5,834,039 5,993,749 6,148,567 6,313,352 Revenue Minus Op Exp 505,260$ 1,089,631$ 1,271,480$ 2,150,154$ 2,266,791$ 2,775,180$ N/A 1,149,355 1,071,964 980,365 894,338 799,032 Other Sources/UsesBorrowed Funds 0 0 0 0 5,000,000 7,500,000 Variable 0 0 0 0 0Other Sources Total Other Sources -$ -$ -$ -$ 5,000,000$ 7,500,000$ N/A 0 0 0 0 0 Other Uses Administrative Cost Paid To Gen Fund 267,000 298,000 305,000 292,950 292,950 318,859 2.0%325,236 331,741 338,376 345,143 352,046Collection cost/Revenue Dept 50,000 59,000 59,000 261,529 261,529 279,307 2.0%284,893 290,591 296,403 302,331 308,377Transfer to General Fund 0 0 0 0 0 0 0 0 0 0 0Transfers In/Out Capital Purchases 0 40,325 18,711 0 0 16,013 0 0 0 0 0Warrant & Lease Payments 0 0 0 0 527,354 1,064,560 Per Schedule 1,076,938 1,092,411 1,104,790 312,560 315,654Reserve for Capital Equipment/Improvements 0 0 0 391,049 1,080,202 646,584 Variable 500,000 500,000 500,000 500,000 500,000Reserve for System Upgrades 0 0 0 1,970,421 10,168,000 8,995,780 6,165,000 3,500,000 2,000,000 1,000,000 1,000,000Reserve requirements per ordinance 0 375,000 375,000 375,000 375,000 375,000 375,000 Total Other Uses 317,000$ 397,325$ 382,711$ 2,915,949$ 12,330,035$ 11,696,103$ 0.0%8,727,068 6,089,743 4,614,569 2,835,034 2,851,078 Net Other Sources/Uses (317,000)(397,325)(382,711)(2,915,949)(7,330,035)(4,196,103)N/A (8,727,068)(6,089,743)(4,614,569)(2,835,034)(2,851,078) Excess/(Deficit) for Year 188,260$ 692,306$ 888,769$ (765,796)$ (5,063,245)$ (1,420,922)$ N/A (7,577,712)(5,017,779)(3,634,204)(1,940,696)(2,052,046) Add back Depreciation Exp 861,490$ 830,823$ 904,472$ 926,941$ 845,000$ 845,000$ 853,350$ 878,651$ 904,710$ 931,551$ 959,198$ Net Excess/(Deficit) $ 1,049,750 1,523,129$ 1,793,241$ 161,145$ (4,218,245)$ (575,922)$ (6,724,362)(4,139,128)(2,729,494)(1,009,145)(1,092,848) Cash Balances As of 9/30/19 As of 9/30/20 As of 9/30/21 As of 8/31/2022 Cash - Operating 5,802,475$ 5,363,615$ 6,251,995$ 4,606,697$ Cash - Pooled Depository 274,822$ 334,665$ 183,028$ 298,117$ Cash - SDC Wastewater Reserve 413,404$ 433,027$ 451,917$ 265,500$ Restricted*Cash - Wastewater Tap Reserve 844,749$ 1,048,404$ 1,286,934$ 1,392,200$ Restricted*Cash - Customer Deposit Reserve 413,404$ 433,027$ 451,917$ 451,917$ Restricted* Total Cash 7,748,854$ 7,612,739$ 8,625,791$ 7,014,432$ Targeted Reserved Fund Balance $ 938,198 $ 1,061,170 $ 1,061,170 $ 1,282,795 $ 1,282,795 1,169,439 1,348,714 1,362,201 1,375,823 1,389,581 Notes: 10/04/2022 City of Fairhope Wastewater Department Recommended Targeted Reserve Fund 20% of annual revenue Page 81 of 109 Fairhope Utilities WATER Department Capital Outlay Plan Fiscal Year Project Description Estimated cost External funding 2023 Treatment Plant 3 Upgrade (FY22 carryover)Complete Treatment Plant 2 Phase I project (multi-year project bid award)$7,589,893 Water Transmission Main Complete water transmission main from Treatment Plant 3 to Treatment Plant 2 $3,500,000 $3,500,000 (ARPA) Treatment Plant Updates (reoccuring) Update pumps and controls at Treatment Plant 1, Treatment Plant 2, Treatment Plant 4, Treatment Plant 5 and Treatment Plan 6 $300,000 Water Main Extension (estimated 1,900+ feet total)>Extend water main from Treatment Plant 3 on County Road 33 to County Road 32 $885,000 >Extend water main on County Road 24 from County Road 3 to US 98 (1,900 feet)$350,000 Storage Tank Maintenance Tank maintenance and painting of Treatment Plant 3 Storage Tank (300,000)$415,000 Traffic Circle Relocation County Road 13 and County Road 44 traffic circle relocation $50,000 2024 Water Main Extension (estimated 21,900+ feet total) >Water main extension from intersection of County Road 33 and County Road 32 to Alabama 181 (11,000) feet $2,500,000 >Water main extension from Treatment Plant 1 to Treatment Plant 2 (upsize for growth as needed)$4,000,000 >Water main extension from Harvest Green East on Alabama 181 to St. Michael's Way to tie into existing 12-inch water main (4,200 feet)$850,000 >Water main extension on Monk Road from County Road 3 to U.S. 98 (4,000 feet)$600,000 >Water main extension on County Road 13 from Bishop Road to County Road 24 (2,700 feet)$350,000 Storage Tank Maintenance Storage tank maintenance and painting (location TBD)$500,000 Well Field 3 Expand Well Field 3 by adding a new well (multi-year) Well 3-12 $1,000,000 2025 Water Main Extension (estimated 28,000+ feet total)>Water main extension on County Road 32 from Alabama 181 to US 98 (10,500 feet)$2,000,000 >Water main extension on County Road 13 from Precision Place to Oldenburg Drive (3,500 feet)$430,000 >Water main extension on County Road 24 from County Road 13 to US 98 (5,000 feet)$600,000 >Water main extension on County Road 13 from County Road 24 to County Road 3 (6,700 feet)$1,000,000 >Water main extension on County Road 13 from County Road 3 to US 98 (1,300 feet)$150,000 >Water main tie-in at County Road 3 and County Road 13 (1,000 feet)$100,000 Water Distribution Upgrades Replace galvanized pipe, AC pipe and problem areas as they arise $500,000 Fiscal Year Project Description Estimated cost External funding 2026 Water Main Replacement Replace water main on US 98 (Greeno Road) from Fairhope High School to McGowin Drive (13,600 feet)$2,500,000 Water Main Extension (estimated 22,030+ feet total) >Water main extension on US 98 (Greeno Road) from McGowin Drive to Scenic 98 and US 98 (14,520 feet)$2,225,000 >Water main extension on US 98 (Alabama Coastal Connection) from Alabama 181 to County Road 9; includes boring Fish River near bridge.$3,000,000 >Water main extension on County Road 9 from US 98 to Mannich Lane (5,280 feet) $500,000 >Water main extension on County Road 17 from US 98 to Mannich Lane (2,500 feet)$250,000 Water Distribution Upgrades Replace galvanized pipe, AC pipe, and problem areas as they arive $500,000 Page 1 of 1 Page 82 of 109 Fairhope Utilities WASTE WATER Department Capital Outlay Plan Fiscal Year Project Description Estimated cost External funding 2022 Sewer Force Main Project from 2018 Second phase of the 2018 Sewer Force Main Project on Fairhope Avenue from Ingleside to Bishop Road. This phase includes 4,200 feet of 16-inch HDPE force main directionally bored. This includes upgrade of the Doghouse Lift Station and 1,000 feet of 12-inch force main from the station to Fairhope Avenue $1,600,000 Lift Station Rehab Rehab Valley Lift Station with ARPA funds. Bid has been approved. This is a multi-year project $0 $247,000 (100% funded) 2023 Sewer Force Main >Sewer Force Main from Alabama 181 west on Alabama 104 to County Road 13 south to Fairhope Avenue to connect to new 16-inch force main. Includes 12-inch HDPE on Fairhope Avenue from County Road 13 to just east of Thompson Hall Road totaling 21,000 feet combination directional bore and open cut.$5,250,000 >Sewer Force Main 12-inch HDPE directionally bored from new Twin Beech Lift Station to old station. Total footage is 2,400 feet.$480,000 >Sewer Force Main from North Section Lift Station along North Section to intersection of Bayou and Section for a total of 2,800 feet of 12-inch HDPE directionally bored.$560,000 >Sewer force main from old South Section Lift Station to Fels where Church Street Project ends for a total of 4,000 feet of 12-inch HDPE.$800,000 >Sewer Force Main from new Twin Beech Lift Station to South Section Street and Twin Beech for a total of 3,500 feet of 12-inch HDPE directionally bored.$700,000 Lift Station Rehab $1,000,000 Wastewater Treatment Plan Head Works Upgrade This is a multi-year ARPA grant through ADEM's SRF Program $2,645,250 (50% project total)$2,645,250 (50% project total) 2024 CIPP and Manhole Rehab $1,000,000 Sewer Force Main Upgrade Upgrade sewer force main from Twin Beech Road to Morphy Avenue (7,000 feet)$1,000,000 Lift Station Rehabs $1,000,000 Wastewater Treatment Plant Headworks Carryover from FY2023 $1,000,000 2025 CIPP and Manhole Rehab $1,000,000 Lift Station Rehabs $1,000,000 Sewer Force Main Replacement $1,500,000 Page 1 of 1 Page 83 of 109 Sanitation Fund 9/26/2022 Object Description FY 2019 Annual FY 2020 Annual FY 2021 Annual FY2022 Aug YTD FY2022 Annual Budget FY2023 Annual Budget REVENUES 41220 Sanitation Collection 1,897,473 2,063,109 2,431,519 2,534,997 2,755,000 2,800,000 41640 Sale - Recycle Paper 18,242 - - - - - 41660 Sale - Trash Cans 390 1,690 780 195 1,000 1,000 41665 Sale - Rcycl Plastic & Misc 683 9,030 7,760 965 2,000 1,000 41705 Sale of Fixed Assets 51,676 259,338 130,501 71,839 100,000 10,000 44075 Lease Revenue - - - - 847,615 923,288 49010 Lease Revenue - - - 337 - 500 49810 Transfers from Gen Fund - - - 305,092 305,092 738,120 TOTAL REVENUES 1,968,464 2,333,167 2,570,560 2,913,424 4,010,707 4,473,908 EXPENSES 50025 Collection Costs/Revenue Dept - - - 93,637 93,637 114,644 50040 Salaries 889,876 969,677 946,172 857,143 1,012,778 1,172,228 50045 Overtime 79,855 82,706 74,310 90,491 67,546 70,000 50190 Employee Payroll Taxes 71,186 77,892 75,518 70,071 82,645 94,531 50200 Employee Retirement Exp 77,430 77,546 83,686 79,914 87,954 100,056 50210 Employee Medical Insurance 192,322 286,441 272,480 234,372 262,922 275,081 50215 Required Contrib-OPEB 32,359 36,768 39,679 33,066 38,500 39,679 50220 Casualty/Workers Comp Ins 78,057 75,761 - - - - 50221 Workers Comp Insurance - - 45,422 63,623 56,100 63,420 50222 Casualty/Property Insurance - - 105,083 76,687 120,000 80,521 50230 Training/School/Travel 1,061 13 - 1,814 4,000 10,000 50290 Professional Services 940 726 38 - 2,500 3,000 50300 Computer Expense 1,195 2,129 2,608 658 1,643 3,695 50325 Printers/Copiers/OE and supp - 524 358 326 258 300 50340 Operating Supplies 25,438 21,300 14,669 16,658 18,520 18,500 50360 General Maintenance 412 1,417 738 8,171 5,000 13,000 50380 Communications 873 2,245 5,039 4,630 10,000 8,500 50390 Dues-Memberships-Subscrip - - - - 800 600 50395 Employment Screening - - 1,026 908 2,000 2,500 50420 Bad Debts 19,681 8,091 6,963 2,314 10,000 10,000 50430 Gasoline & Oil 111,825 91,729 122,602 182,318 115,000 190,000 50440 Equip & Vehicle Repair 191,162 174,483 224,821 219,480 250,000 254,000 50460 Uniforms 11,040 280 4,461 7,055 5,000 6,000 50462 Safety Wear and PPE - 2,720 3,020 - 3,500 6,120 50470 Purchases Vehicles & Equipment 890,539 182,468 - 684,161 812,615 923,288 50475 Capital Improvements - - - 5,744 40,000 209,250 50955 Transfers-Debt Svc Fund - 194,643 333,170 333,170 333,189 333,189 51460 Landfill Charges 328,906 365,949 369,739 302,632 375,600 379,200 51465 Landfill Maintenance 28,585 25,204 17,491 23,842 15,000 38,070 51470 Purchases-Recy Bins/Gbge Cans 64,440 33,294 59,374 78,025 80,000 50,035 52510 Utilities for City Use 3,774 3,356 3,255 3,025 4,000 4,500 TOTAL EXPENSES 3,100,955 2,717,360 2,811,720 3,380,298 3,817,070 4,473,908 Excess Rev Over Expense (1,132,492) (384,193) (241,160) (466,873) 193,637 - Page 84 of 109 Page 85 of 109 Replacement Year Operational Year Surplus Unit #Description Date Acquired Service Life (YRS) Replacement Budget Year 2023 2025 2027 2028 Unit Replaced 01015 FREIGHTLINER 114SD - Auto Loader 2015 7 2023 N/A 01158 FREIGHTLINER M2106 - Rear Loader 2015 7 2023 N/A 01159 FREIGHTLINER SD114 - Auto Loader 2016 7 2024 N/A 01509 FREIGHTLINER 114 SD - Auto Loader 2017 7 2025 N/A 03469 WESTERN STAR 4700SB - Auto Loader 2019 7 2027 N/A 03476 FREIGHTLINER 114SD - Auto Loader 2019 7 2027 N/A Replacement 31 CY Automatic Side Loader Garbage 2023 7 2031 $288,000.00 01015 Replacement 16CY Rear Loader - Backdoor Garbage 2023 7 2031 $196,000.00 01158 Replacement 31 CY Automatic Side Loader Garbage*2023 7 2031 $288,000.00 01159 Replacement Auto-Loader Garbage Truck 2024 7 2032 01509 Replacement Auto-Loader Garbage Truck 2025 7 2033 $316,800.00 01509 NEW Auto-Loader Garbage Truck 2026 7 2034 NEW Replacement Auto-Loader Garbage Truck 2027 7 2035 $383,328.00 03469 Replacement Auto-Loader Garbage Truck 2027 7 2035 $383,328.00 03476 $772,000.00 $316,800.00 $766,656.00 $0.00 Unit #Description Date Acquired Servic e Life (YRS) Replacement Budget Year 2023 2025 2027 2028 Unit Replaced 01251 2016 FREIGHTLINER M2106 2016 10 2026 03428 2019 FREIGHTLINER M2106 2018 10 2028 03321 2018 FREIGHTLINER M2106 2018 10 2028 03753 2020 Freightliner M2106 2020 10 2030 03750 FREIGHTLINER BRUSH HAWG 2022 10 2032 Replacement 18CY Knuckle Boom Loader Truck 2026 10 2036 01251 Replacement 18CY Knuckle Boom Loader Truck 2028 10 2038 $192,500.00 03321 Replacement 18CY Knuckle Boom Loader Truck 2028 10 2038 $192,500.00 03428 $0.00 $0.00 $0.00 $385,000.00 Unit #Description Date Acquired Servic e Life (YRS) Replacement Budget Year 2023 2025 2027 2028 Unit Replaced 03322 FREIGHTLINER M2 106 Rear Loader 2018 9 2027 N/A 03323 FREIGHTLINER M2 106 Rear Loader 2018 9 2027 N/A 03537 Freightliner M2-106 Rear Loader 2020 9 2029 N/A NEW 20CY Rear Loader - Recycle 2023 9 2032 $210,000.00 New Replacement 20CY Rear Loader - Recycle 2027 9 2036 $225,000.00 03322 Replacement 20CY Rear Loader - Recycle 2027 9 2036 $225,000.00 03323 $210,000.00 $0.00 $450,000.00 $0.00Budget Year Projected Impact:$0.00 $0.00 Budget Year Projected Impact:$0.00 $175,000.00 RECYCLE: 2024 2026 $175,000.00 *This unit has been order and captured in FY23 Budget due to long lead delivery time TRASH: 2024 2026 Budget Year Projected Impact:$0.00 $348,480.00 $0.00 $348,480.00 * Fairhope Public Works - Sanitation 5-Year Capital Equipment Needs LEGEND GARBAGE: 2024 2026 Page 86 of 109 Unit #Description Date Acquired Servic e Life Replacement Budget Year 2023 2025 2027 2028 Unit Replaced 03225 2013 FORD VAN 15 PASSENGER 3/4T 2013 12 2025 03314 2018 FREIGHTLINER 122SD - Tractor 2018 10 2028 03376 2019 FULL FRAME DUMP TRAILER 2019 7 2026 03452 2018 CATERPILLAR WHEEL LOADER 918M 2018 12 2030 03450 2015 JOHN DEERE GATOR TX 2015 10 2025 03541 Ford F250 2020 12 2032 NEW CAT D-5 High Drive Bulldozer 2022 15 2037 Replacement 15 Passenger Van 2025 12 2037 $42,000.00 03225 Replacement Walking Floor Garbage Trailer 2026 7 2033 03376 Replacement Tractor - 18 Wheeler - Transfer Truck 2028 10 2038 $210,000.00 03314 $0.00 $42,000.00 $0.00 $210,000.00 2023 2025 2027 2028 $982,000.00 $358,800.00 $1,216,656.00 $595,000.00 2024 2026 Total Sanitation Projected Annual Capital Equipment Expense - 2023 - 2028 $0.00 $678,480.00 $155,000.00 Budget Year Projected Impact:$0.00 $155,000.00 LANDFILL/TRANSFER: 2024 2026 Page 87 of 109 Vehicles / Equipment Department Organization Object Year Line Quantity Amount Description General Admin 001100 50470 2023 10 1 8,000.00$ Camera Replacements for Council Chambers. The ones that we have are about 8 years old and are starting to have issues. Planning 001120 50470 2023 10 1 31,466.00$ 2023 F150 2WD Crew Cab for Building Inspector Building 001130 50470 2023 10 2 60,732.00$ Two 2022 Ford Explorer (Asst Building Official, Fire Safety Inspector). Vehicles requested are 4WD because of the pricing provided for available Explorers the 2022 4WD Explorers were less costly than the 2023 2WD models Building 001130 50470 2023 20 1 34,927.00$ 2023 F150 2WD Crew Cab for Building Inspector Police 001150 50470 2023 10 1 6,984.50$ Scout Speed Trailer Police 001150 50470 2023 20 6 390,816.00$ 6 New Patrol Tahoes - $50,915.00 6 Radars - $1,291.00 6 In-Car Cameras - $6.330.00 6 -Mobile Radios - $3,800.00 6 - Cradle Points - $1,200.00 PER MAYOR 6 IT 001160 50470 2023 10 1 133,658.60$ New Servers - We need to rotate servers due to support. Last one purchased was 2018 IT 001160 50470 2023 20 1 16,972.85$ Laserfische - Public Forms IT 001160 50470 2023 30 1 19,864.00$ Laserfische - Public Access IT 001160 50470 2023 40 1 80,000.00$ New Website IT 001160 50470 2023 50 1 20,000.00$ 311 add on for New website Meter 001190 50470 2023 20 1 33,643.00$ FORD F150 4X2 TRUCK of Equivalent Meter 001190 50470 2023 30 1 26,026.00$ Ford Ranger 4x2 Supercab ROLLOVER FY22 Fire 001200 50470 2023 20 1 90,000.00$ Carried over from 2022 - F350 and equipment We were unable to find one during the 2022 budget year. 90,000 based on a 20% increase Fire 001200 50470 2023 30 1 9,309.25$ Lighting for new truck. Carry over parts are backordered Requisition 5335 Fire 001200 50470 2023 40 1 46,000.00$ Generator Carried over from 2022 46,000 Original budgeted amount was 61,941 but all we need to carry over is 46,000. We came in way under budget. Recreation 001250 50470 2023 10 1 35,000.00$ Ford F150 or Equivalent pickup truck for Parks Custodian. Replace V#01105 Recreation 001250 50470 2023 20 1 34,332.00$ 1/2 ton crew cab pickup for Rec Director. Recreation 001250 50470 2023 30 1 8,000.00$ New fitness equipment items for the fitness room at the Rec Center. Recreation 001250 50470 2023 40 1 10,400.00$ Floor scrubbing machine for the Basketball gym floors at the Rec Center. Page 88 of 109 Vehicles / Equipment Department Organization Object Year Line Quantity Amount Description Public Works 001350 50470 2023 20 1 30,000.00$ Hort -Stump grinder attachment for Skid Steer Public Works 001350 50470 2023 50 1 275,000.00$ Streets #1 - New Elgin Pelican Three Wheeled Sweeper Public Works 001350 50470 2023 80 1 40,000.00$ Streets #3 - F250 utility Van or Equivalent (For Odis The Plumber ) Public Works 001350 50470 2023 100 1 221,404.00$ Streets #2 - Mower Max Boom Mower Public Works 001350 50470 2023 120 1 27,000.00$ Rollover Item 2022 - JD Out Front Mowers - approved, issued P.O. and Ordered Public Works 001350 50470 2023 130 1 30,000.00$ Hort - New JD Out Front Mower - for ROW and Public Land Mowing and Maintenance Public Works 001350 50470 2023 140 400 70,000.00$ Public Safety/Emergency Management - Barricades to replace cable wire system - unit cost includes trailer(s) Public Works 001350 50470 2023 150 1 35,000.00$ 5 Yard Concrete Truck ROLLOVER Public Works 001350 50470 2023 160 1 22,500.00$ New dump body to retrofit existing International Chassis that was transferred from Water Department Golf 001500 50470 2023 10 1 15,000.00$ Driving Range Hauler cart, most used piece of equipment in the entire fleet! New Purchase $15,000.00 Golf 001500 50470 2023 50 1 32,591.00$ Perry Weather Outdoor Warning System for Lighting, heat, severe watches & warnings. Web and Mobile access; Text Alerts 24/7; meteorologist support 24/7; Daily email forecast' GPS Tracking; Web Widget Golf Grounds 001550 50470 2023 10 1 62,000.00$ Skid Steer replacement for Bobcat. Bobcat is worn out and can be sold on gov deals. Revamping the existing unit, would be too costly. Golf Grounds 001550 50470 2023 30 1 5,700.00$ Two post hydraulic lift allows mechanic to work on equipment. Estimated cost, includes installation. Golf Grounds 001550 50470 2023 40 1 6,000.00$ Tire changing machine Golf Grounds 001550 50470 2023 50 1 42,571.00$ ROLL OVER FROM 2022 Dual Master 3000iR Reel Grinder by Bernhard. Has been ordered in the 2022 budget, Sales Representatives announced it may not be delivered until the fall possibly November 2022. Golf Grounds 001550 50470 2023 60 1 24,000.00$ Sand Machine Golf Grounds 001550 50470 2023 70 1 6,000.00$ 12" Sod Cutter Gas 002 50470 2023 10 2 90,000.00$ 150 or 1500 Pickup Truck or Equivalent Gas 002 50470 2023 30 1 21,000.00$ Backhoe Trailer Gas 002 50470 2023 40 1 30,000.00$ Air Compressor - Pull Behind Gas 002 50470 2023 50 2 24,000.00$ Tilt Trailer Gas 002 50470 2023 60 1 130,000.00$ Plow Combo Gas 002 50470 2023 70 1 72,000.00$ Mini Ex 303.5 Gas 002 50470 2023 80 1 25,000.00$ Side-by-Side Gas 002 50470 2023 90 1 35,000.00$ 5 Yard Concrete Truck ROLLOVER Gas 002 50470 2023 100 1 33,241.00$ 2500 4x4 Pickup Rollover PO Issued 12/21 Gas 002 50470 2023 110 1 72,000.00$ 450 Welding Truck Rollover Page 89 of 109 Vehicles / Equipment Department Organization Object Year Line Quantity Amount Description Electric 003 50470 2023 20 1 41,737.00$ Ford F150 Supercrew 4x4 or Equivalent. $40,237 Truck, $1500 Tool Box, Bed Liner, Strobe Lights. Electric 003 50470 2023 30 1 282,627.00$ Aerial bucket truck for linecrew. Electric 003 50470 2023 50 1 25,000.00$ Trailer for electrical department Electric 003 50470 2023 60 1 35,000.00$ 5 yard concrete truck ROLLOVER Electric 003 50470 2023 70 1 14,228.00$ Line locater device with gps Electric 003 50470 2023 80 1 96,000.00$ Skid Steer Kubota 97 Electric 003 50470 2023 90 1 37,998.00$ Ford F150 Supercrew 4x2. $36,498 Truck, $1,500 Tool Box, Bed Liner, Strobe Lights. Water 004010 50470 2023 10 1 8,500.00$ Small fusion Machine Water 004010 50470 2023 20 1 35,000.00$ Pickup for Water Department Supervisor Water 004010 50470 2023 30 1 58,000.00$ 15,000 GVWR Truck with Utility body Water 004010 50470 2023 40 1 55,000.00$ 11,000 GVWR Truck With Utility Body This truck replaces truck #3281 Water 004010 50470 2023 50 1 12,000.00$ Tilt Deck Trailer for Mini Ex Water 004010 50470 2023 60 1 10,000.00$ GPR Locator (Ground Penetrating Radar) Split between water and sewer. Water 004010 50470 2023 70 1 20,000.00$ Forklift for Pecan Building East Split between water and sewer Water 004010 50470 2023 80 1 35,000.00$ 5 Yard Concrete Truck ROLLOVER Water 004010 50470 2023 90 1 7,040.00$ Gas welder for truck Quote off buyers group plus 10% increase Waste Water 004020 50470 2023 10 1 8,000.00$ Heavy Duty Brush Cutter for shared compact track loader (Public Works) Split between Water and Sewer $16,000 total cost CARRY OVER FROM FY22 Waste Water 004020 50470 2023 20 1 10,000.00$ GPR Locator (Ground Penetrating Radar) Split between water and sewer Waste Water 004020 50470 2023 30 1 56,584.00$ 19,500 GVWR Truck Cab and Chassis Replacing truck#3427 (2006 Ford F550) Waste Water 004020 50470 2023 40 1 35,000.00$ Utility Body with Crane For new lift station truck Waste Water 004020 50470 2023 50 1 60,000.00$ Minimum 3.5 Metric Ton Mini Excavator Replace Cat 302 Mini Ex Page 90 of 109 Vehicles / Equipment Department Organization Object Year Line Quantity Amount Description Waste Water 004020 50470 2023 60 1 12,000.00$ Tilt Deck Trailer for Mini Ex 16,000 GVWR Waste Water 004020 50470 2023 70 1 85,000.00$ Track Fusion Machine 4"-12" HDPE Waste Water 004020 50470 2023 80 1 150,000.00$ Portable Generators 60 KW minimum Waste Water 004020 50470 2023 90 1 20,000.00$ Forklift for Pecan Building East Split between water and sewer Waste Water 004020 50470 2023 100 50 15,000.00$ Drill Rods for Boring machine Split between all utilities. Sanitation 005030 50470 2023 10 1 282,810.00$ 2022 Rollover Item - 31 Cubic Yard Automatic Side Loader Garbage Trucks - Sanitation 005030 50470 2023 20 1 179,000.00$ 1 Back Door Service Truck 16 Cubic Yards to replace unit 1508; Unit 1508 to be held as back up unit in 2023- Sanitation 005030 50470 2023 30 1 174,000.00$ 1 20 Cubic Yard Packer Truck for Recycle and back door use on Sanitation routes- Sanitation 005030 50470 2023 40 1 287,478.00$ 31 Cubic Yard Automatic Side Loader Garbage Trucks - Page 91 of 109 Capital Improvements Department Organization Object Year Line Quantity Amount Description General Admin 001100 50475 2023 10 1 20,000.00$ Warehouse receiving area/climate storage improvements. Building 001130 50475 2023 10 1 15,000.00$ renovation of building dept- renovate former records storage areas Police 001150 50475 2023 10 140 35,000.00$ Ceiling Tiles Police 001150 51255 2023 10 1 7,500.00$ Storage Building Police 001150 51255 2023 20 1 8,203.00$ A/C Unit-Jail Police 001150 51255 2023 30 1 6,500.00$ A/C Installation HR 001170 50475 2023 10 1 20,000.00$ Office Improvements. Fire 001200 50475 2023 10 1 60,000.00$ The bay doors at Station No. 3 have been needing replaced for multiple years. The original bid was at 40,000 It has now risen to approximately 98,000 Fire 001200 50475 2023 20 1 15,000.00$ Paint the exterior of the metal on the backside of station 1 Fire 001200 50475 2023 30 1 17,500.00$ Asphalt in front of classroom and add drain on Thompson hall RD Fire 001200 50475 2023 40 1 27,000.00$ Carried over from 2022 - carried over, we are having trouble getting the specs for a quote. were hoping it's under 50K so it can be designated as a public works project. Fire 001200 50475 2023 50 1 17,000.00$ Station 3, Sub contract bay floor stripping and repainting. It is the last station needing completed. Recreation 001250 50475 2023 30 1 135,000.00$ LED lighting retrofit of High School Baseball field Recreation 001250 50475 2023 50 1 70,000.00$ Spray foam insulation in Back gym of the Rec center. Recreation 001250 50475 2023 80 1 8,000.00$ Replace A/C unit in the Football press box at Majors Field. Recreation 001250 50475 2023 90 1 8,000.00$ Installation of A/C unit in the Indoor Batting Cage at Volanta Park Civic Center 001260 50475 2023 10 1 300,000.00$ Roof Repairs Civic Center 001260 50475 2023 70 1 43,638.00$ Design, Letting and A&E Fees for Phase I & II of the Civic Center/City Hall Roof Restoration Project Civic Center 001260 50475 2023 80 1 40,000.00$ ROLLOVER Fire alarm system upgrade - City Hall/Civic Center (MLS) Civic Center 001260 50475 2023 90 1 50,000.00$ ROLLOVER Municipal Complex Painting & Drywall Repairs Civic Center 001260 50475 2023 100 1 75,000.00$ Resurfacing parking lot Museum/Welcome 001270 50475 2023 10 1 5,000.00$ ADA Bancroft Door Install Adult Rec 001300 50475 2023 10 1 39,000.00$ Nix Center Ballroom Audio System - Waiting on estimate Adult Rec 001300 50475 2023 20 1 25,000.00$ Hurricane Window Coverings Adult Rec 001300 50475 2023 30 1 60,000.00$ Nix Center Parking lot paving ROLLOVER Page 92 of 109 Capital Improvements Department Organization Object Year Line Quantity Amount Description Adult Rec 001300 50475 2023 40 1 60,000.00$ Nix Center Bathroom Renovation Men's and Women's Adult Rec 001300 50475 2023 50 1 59,000.00$ ROLLOVER Commercial Glass Replacement Adult Rec 001300 50475 2023 60 1 30,000.00$ ROLLOVER Carpet Replacement Marina 001340 50475 2023 10 1 215,000.00$ Installation of electrical services to slips at Fairhope Docks. Marina 001340 50475 2023 20 1 25,000.00$ Electrical service panel installation to provide power to the slips. Public Works 001350 50475 2023 20 1 110,000.00$ Blueberry Lane improvements Mechanics 001460 50475 2023 10 1 8,000.00$ Gravel Parking/Storage/Staging west end of the shop complex Golf 001500 50475 2023 10 1 18,000.00$ Men's and Ladies Bathrooms, walls, toilets, mirrors, light fixtures, need new equipment. New Sinks, Painting and Flooring. Golf Grounds 001550 50475 2023 10 1 24,500.00$ 17,500 feet of sod for renovated tee boxes, and additional grasses for bare areas on course.- Golf Grounds 001550 50475 2023 20 1 5,000.00$ New sand for Bunkers Golf Grounds 001550 50475 2023 30 1 118,800.00$ XGD Greens Drainage Library 001750 50373 2023 10 1 250,000.00$ Library 2nd floor renovations Gas 002 50473 2023 10 1 45,000.00$ Addition to the Gas Departments Break room and Equipment Room. $30,000 Rollover from 2022 Electric 003 50473 2023 10 1 6,732.00$ New Awning for Pecan Building Electric 003 50473 2023 20 1 15,864.87$ Pecan Building Security - Cameras and Door Access Electric 003 50473 2023 30 1 30,000.00$ Transfer Switch and Panel for Pecan Bldg Electric 003 50473 2023 40 1 10,000.00$ Fence for securing new AMI meters in Pecan building prior to deployment Electric 003 50473 2023 50 1 137,250.00$ Phase II Pecan Building Rollover $45,750 - Gas $45,750 - Electric $45,750 - Water/Sewer See Revenue Transfer 40902 and 40904 Electric 003 50475 2023 10 1 155,000.00$ Building for electrical departments bucket trucks. $75k ROLLOVER Electric 003 50475 2023 20 1 35,000.00$ Restore power to Fairhope Pier Page 93 of 109 Capital Improvements Department Organization Object Year Line Quantity Amount Description Electric 003 50475 2023 30 1 15,000.00$ Upgrades to Electrical department restroom and installing shower for on call employees for storms and over night calls. Water 004010 50473 2023 10 1 45,000.00$ Improvements to Pecan Building East. Water and Sewer building. Water 004010 50473 2023 20 1 25,000.00$ Replace roof panels and side panels due to age and corrosion. This will include gutters, screws, metal siding, flashing, and labor. Split between water and sewer. Total budget is $50,000 Waste Water 004020 50473 2023 10 1 25,000.00$ Replace roof panels and side panels due to age and corrosion. This will include gutters, screws, metal siding, flashing, and labor. Split between water and sewer. Total budget is $50,000 Waste Water 004020 50473 2023 20 1 90,000.00$ Metal Building 40 x 40 Maintenance Building at WWTP. Metal Building 40x40 with 2 bay doors insulated Including materials to finish building interior. CARRY OVER FROM FY22 Sanitation 005030 50475 2023 20 1 185,000.00$ Transfer Station: 1. Rebuilding concrete floor of station: $140,000.00 2. Repair of supporting steel beams on floor edge: $45,000.00 3. Sewer Pump and wiring Panel in transfer station drainage system : $20,000.00 Sanitation 005030 50475 2023 30 1,000 24,250.00$ 1000 L.F. of New Landfill Fencing Page 94 of 109 Utility System Improvements Department Organization Object Year Line Quantity Amount Description Gas 002 59500 2023 10 1 78,000.00$ Rollover Coleman Lane Creek Crossing Gas 002 59500 2023 20 5 15,000.00$ pressure monitoring devices that provide up to the minute pressure readings at our regulator stations. Gas 002 59500 2023 30 2 196,000.00$ Rollover Rock Creek Creek Crossing Gas 002 59500 2023 40 1 43,000.00$ Creek Crossings Hwy 33 Gas 002 59500 2023 50 1 198,000.00$ Mary Ann Beach Rd Main Ext. Install 2 Miles of 2" Low Pressure PE Gas Main Along Mary Ann Beach Road to County Road 1 Gas 002 59500 2023 60 20 70,000.00$ Cathodic Protection Monitoring Devices Gas 002 59500 2023 70 1 43,200.00$ Engineering for 3 creek crossings Gas 002 59500 2023 80 1 130,000.00$ Engineering for Replacing 6" High Pressure Gas main under I10 along US Highway 98 Gas 002 59500 2023 90 1 1,000,000.00$ Rollover Engineering for Cast Iron Replacement Gas 002 59500 2023 120 1 200,000.00$ On-Call Contractor Electric 003 59100 2023 10 1 100,000.00$ Electrical Departments remote control system over all substations and smart reclosers. Electric 003 59110 2023 60 50 50,000.00$ Estimated quantity and estimated cost for electrician to change out bad electric meter cans during AMI deployment. Electric 003 59110 2023 70 1 2,200,000.00$ Automated Metering Infrastructure ROLLOVER FY22 Electric 003 59500 2023 10 1 1,750,000.00$ 44 KV Loop Electric 003 59500 2023 20 1 200,000.00$ Dyer Road 44KV pole replacement Electric 003 59500 2023 30 1 850,000.00$ Underground Service on Magnolia from Church to Bancroft. Electric 003 59500 2023 40 1 16,430.00$ 300kVA Phase Pad Mount Transformer Electric 003 59500 2023 50 1 260,000.00$ Estimated engineering & contingency for 44KV system Electric 003 59500 2023 60 1 40,000.00$ Estimate engineering & contingency for upgrade existing 44KV along Dyer Rd from Greeno to Bishop Electric 003 59500 2023 70 1 620,000.00$ ROLL OVER 2022 Substation Upgrades Water 004010 59100 2023 10 1 15,000.00$ Adding pressure monitors with Scada monitoring capability Water 004010 59500 2023 10 1 7,000,000.00$ Upgrade water main from CR 32 back to Fairhope Ave Engineering has started in 2021 budget year Engineering for design is complete. Going out for bid in FY22 work most likely will not start till FY23 with completion in early FY24 Budget has increased Water 004010 59500 2023 20 1 500,000.00$ Water distribution system main replacement and upgrades Water 004010 59500 2023 30 1 415,000.00$ Repair and Paint Water Tank at WTP 3 Water 004010 59500 2023 40 1 50,000.00$ CR 13 and CR 44 Roundabout Relocation Water 004010 59500 2023 50 1 350,000.00$ On Call Contractor for Water On call contractor to assist with emergency repairs, line extensions, deep repairs (Over 12 Ft) etc. Page 95 of 109 Utility System Improvements Department Organization Object Year Line Quantity Amount Description Water 004010 59500 2023 60 1 100,000.00$ Insertion Valves and Taps Teams Insertion Valves. Valves installed while line is under pressure. Taps that are larger than we or capable to make (3"and greater) Water 004010 59500 2023 70 1 885,000.00$ Adding the 12" Water Main is required for the added pumping capacity to the south end of system. This will increase capacity on and south of CR 32 Water 004010 59500 2023 80 1 500,000.00$ New Meters Water 004010 59501 2023 10 1 3,500,000.00$ Upgrading Water Treatment Plant 3. . Plant will be capable of treating up to 6.0 MGD after upgrade and the 24" Water main to the north is installed and the !6' Water main to the south connecting to proposed 12" on CR 32. Preliminary Engineering started in FY21, Design engineering completed in FY22. Well bid and awarded in FY22 Being drilled currently. Should award bid in July 22. for WTP. Work will start in FY23. Should complete work early FY24 Water 004010 59501 2023 20 1 300,000.00$ Water Plant and Well upgrades and repairs. Water plant and well upgrades and replacement. This includes, but not limited to, Pumps, motors, chemical feed equipment, generator replacement, transfer switch, testing meters and gauges, aerators, chemical tanks, building repairs. and emergency well replacement or repairs Water 004010 59501 2023 30 1 190,000.00$ Refurbish wells #6 and # 10. This budget includes engineering and bid assistance. Water 004010 59501 2023 40 1 861,000.00$ Develop Well 11 at Well Feld 3 Bid accepted and awarded. Waste Water 004020 59100 2023 10 1 60,000.00$ Lift Station Scada upgrade to Mission Carryover from FY22 Waste Water 004020 59100 2023 20 1 20,000.00$ SCADA upgrade finish at WWTP Waste Water 004020 59500 2023 10 1 70,000.00$ CR 13 and CR 44 Roundabout Relocation Waste Water 004020 59500 2023 20 1 350,000.00$ On Call Contractor for Sewer Waste Water 004020 59500 2023 30 1 4,688,680.00$ Force Main From Bishop on Fairhope AVE. to the New Publix Lift Station CARRY OVER FROM FY22 Waste Water 004020 59500 2023 60 1 625,000.00$ Force Main from CR13 to Klump Development and South on Thompson Hall Rd to Lift Station. Waste Water 004020 59500 2023 90 1 125,000.00$ Veterans/104 Traffic Circle relocation Waste Water 004020 59500 2023 100 1 650,000.00$ Phase II Sewer Force main from Ingleside on Fairhope Ave to Bishop Rd. Rollover FY2022 Waste Water 004020 59501 2023 10 1 1,000,000.00$ Lift Station Upgrades CARRY OVER FROM FY22 Waste Water 004020 59501 2023 20 1 750,000.00$ Generators for lift stations (Matching funds) Carry Over from FY22 Waste Water 004020 59501 2023 30 1 247,600.00$ Rehab Valley lift station (ARPA Funds) FY2022 Rollover Waste Water 004020 59502 2023 10 1 107,500.00$ WWTP RASS Pumps and Recycle Pump Replacement Page 96 of 109 Utility System Improvements Department Organization Object Year Line Quantity Amount Description Waste Water 004020 59502 2023 20 1 35,000.00$ Blower Building Repair interior walls and install prefab metal roof Waste Water 004020 59502 2023 30 1 75,000.00$ Replace Blower Replace turbo blower with positive displacement blower. Waste Water 004020 59502 2023 40 1 35,000.00$ Clarifier Rehab Replace pivot arm bearings, piping, sweeps, etc. Waste Water 004020 59502 2023 50 1 20,000.00$ "Fuzzy" Filter rehab Carry over FY22 Waste Water 004020 59502 2023 60 1 17,000.00$ Digester Rehab Includes pipes, pumps, diffusers, etc Waste Water 004020 59502 2023 70 1 35,000.00$ "Orbitol" rehab Rehab of mixers bearings, motors, and drives Waste Water 004020 59502 2023 80 1 80,000.00$ "Head Works" repairs Waste Water 004020 59502 2023 90 1 35,000.00$ VLR (Vertical Loop Reactor) Repair Rehab of mixers, drives, and motors Waste Water 004020 59502 2023 100 1 50,000.00$ Replacement of misc. equipment not listed in individual budget item. This budget item should cover any unknown replacement such as, but not limited to, A/C unit, refrigerator, incubator, lab equipment, burners, and other equipment needed in the day to day operation of the WWTP Page 97 of 109 Page 98 of 109 Page 99 of 109 New/Defund Postions Position Location Personnel Status Pay Grade Hourly Rate Annual Salary Notes NEW POSITION: Accounts Payable Supervisor Treasury FTE Reclass 10 33.08$ 68,806.40$ Customer Service Representative III Treasury/Revenue FTE Reclass 8 19.77$ 41,121.00$ Total New:109,927.40$ Total Defund:97,073.60$ Total Budget Impact:12,853.80$ Software Support Engineer Computer Information Systems FTE New Position 11 32.79$ 68,203.20$ Total New:68,203.20$ Total Defund:-$ Total Budget Impact:32.79$ 68,203.20$ ROW Construction Inspector Supervisor Building Department FTE New Position 9 30.61$ 63,648.00$ Permit Technician/CRS Coordinator Building Department FTE Reclass 6 24.25$ 50,440.00$ Total New:114,088.00$ Total Defund:48,048.00$ Total Budget Impact:66,040.00$ GIS Technician Planning Department FTE New Position 10 23.12$ 48,089.60$ Total New:48,089.60$ Total Defund:-$ Total Budget Impact:48,089.60$ Beach Patrol - Non-Sworn Police Department FTE New Position 8 18.00$ 37,440.00$ Police Officer Police Department FTE New Position 8 24.00$ 52,416.00$ Police Officer Police Department FTE New Position 8 24.00$ 52,416.00$ Police Officer Police Department FTE New Position 8 24.00$ 52,416.00$ Corporal - Investigation Police Department FTE Reclass 9 31.83$ 69,516.72$ Corporal - Patrol Police Department FTE Promotion 9 28.00$ 61,152.00$ Dispatcher Police Department FTE New Position 7 18.50$ 40,404.00$ Police Intern Police Department Seasonal New Position 4 15.00$ 7,200.00$ Community Outreach and Communications Specialist Police Department FTE New Position 7 20.00$ 41,600.00$ Corrections Officer Police Department FTE New Position 7 18.50$ 40,404.00$ Total New:454,964.72$ Total Defund:228,647.64$ Total Budget Impact:226,317.08$ Lifeguard Supervisor Parks and Recreation Department FTE Reclass 7 20.84$ 43,347.20$ Administrative Assistant Parks and Recreation Department FTE Reclass 7 16.06$ 33,415.20$ Equipment Operator I Parks and Recreation Department Seasonal New Position 3 15.00$ 15,600.00$ Mower Total New:92,362.40$ Total Defund:19,690.84$ Total Budget Impact:36.90$ 72,671.56$ Graphic Design Intern Economic & Community Development Seasonal New Position 3 15.00$ 15,600.00$ Page 100 of 109 New/Defund Postions Position Location Personnel Status Pay Grade Hourly Rate Annual Salary Notes Driver Economic & Community Development PTE New Position 4 15,423.20$ Driver Economic & Community Development PTE New Position 4 15,423.20$ Emergency Management Coordinator Economic & Community Development FTE New Position 9 26.44$ 55,000.00$ Total New:101,446.40$ Total Defund:-$ Total Budget Impact:-$ 85,846.40$ ROW Construction Inspector Public Works Department FTE New Position 9 26.14$ 54,371.20$ Gardener III Public Works Department FTE New Position 24.46$ 50,877.00$ Gardener I Public Works Department FTE New Position 4 15.57$ 32,389.00$ Equipment Operator III Public Works Department FTE New Position 8 21.84$ 45,428.00$ Equipment Operator III Public Works Department FTE New Position 8 21.84$ 45,428.00$ Painter Assistant Public Works Department FTE New Position 5 17.44$ 36,276.00$ Equipment Operator I Public Works Department Seasonal New Position 3 15.00$ 15,600.00$ Mower Total New:280,369.20$ Total Defund:-$ Total Budget Impact:280,369.20$ Sanitation Hopper Public Works Department FTE New Position 5 15.50$ 32,325.00$ Sanitation Hopper Public Works Department FTE New Position 5 15.50$ 32,325.00$ Total New:64,650.00$ Total Defund:-$ Total Budget Impact:64,650.00$ Equipment Operator IV Gas Department FTE New Position 9 26.14$ 54,371.20$ Gas Construction Supervisor Gas Department FTE New Position 11 32.79$ 68,203.20$ Operations and Compliance Supervisor Gas Department FTE Reclass 10 29.28$ 60,902.40$ Total New:183,476.80$ Total Defund:86,902.40$ Total Budget Impact:88.21$ 96,574.40$ Wastewater Treatment Plant Laboratory Technician Water Department FTE New Position 7 25.60$ 53,248.00$ Wastewater Collection Operator Water Department FTE New Position 7 20.84$ 43,347.20$ Wastewater Collection Operator Water Department FTE New Position 7 20.84$ 43,347.20$ Water Service Technician Water Department FTE New Position 6 18.61$ 38,708.80$ Water Service Technician Water Department FTE New Position 6 18.61$ 38,708.80$ Water Service Technician II Crew Leader Water Department FTE New Position 7 20.84$ 43,347.20$ ROW Construction Inspector (Utility Construction Inspector)Water Department/Utilities FTE New Position 10 29.28$ 60,902.40$ Line Locator Water Department FTE New Position 6 18.61$ 38,708.80$ Administrative Assistant Water Department FTE New Position 7 20.84$ 43,347.20$ Utility Intern Water Department Seasonal New Position 3 15.00$ 15,600.00$ Total New:419,265.60$ Total Defund:-$ Page 101 of 109 New/Defund Postions Position Location Personnel Status Pay Grade Hourly Rate Annual Salary Notes Total Budget Impact:419,265.60$ CFM Electrician Electric Department FTE New Position 10 23.00$ 47,840.00$ Total New:47,840.00$ Total Defund:-$ Total Budget Impact:47,840.00$ Golf Gounds Maintance Worker Golf Gounds FTE New Position 5 16.61$ 34,548.80$ Total New:34,548.80$ Total Defund:-$ Total Budget Impact:34,548.80$ Overall Total Budget Impact:1,458,619.64$ Total 36 new FTE:1,642,868.92$ Total 7 new PTE/Seasonal:122,286.40$ Page 102 of 109 New/Defund Postions Position Location Personnel Status Pay Grade Hourly Rate Annual Salary Notes DEFUND: Corporal - Patrol Police Department FTE 9 69,516.72$ Police Officer Police Department FTE 8 56,784.00$ Dispatcher Police Department PTE 7 18,366.92$ Dispatcher Police Department PTE 7 16,677.44$ Dispatcher Police Department PTE 7 17,270.24$ Corrections Officer Police Department PTE 7 16,677.44$ Corrections Officer Police Department PTE 7 16,677.44$ Corrections Officer Police Department PTE 7 16,677.44$ Total for PD:228,647.64$ Lifeguard Parks and Recreation Department PTE 10.00$ 4,940.00$ Administrative Assistant Parks and Recreation Department PTE 4 14.93$ 14,750.84$ Total for Parks and Rec:19,690.84$ Gas Service Line Technician Trainee Gas Department FTE 4 18.10$ 37,648.00$ Compliance & Safety Coordinator Gas Department FTE 10 23.68$ 49,254.40$ Total for Gas:86,902.40$ Permit Technician Building Department FTE 6 23.10$ 48,048.00$ Total for Building:48,048.00$ Treasurer's Assistant Treasury/Revenue FTE 9 30.77$ 64,001.60$ Customer Service Representative I Treasury/Revenue FTE 5 15.90$ 33,072.00$ Total for Treasury/Revenue: $ 97,073.60 Total Defund:480,362.48$ Total Defund 7 FTE:301,540.72$ Total Defund PTE/Seasonal:122,037.76$ Total Defund Positions:7 FTE's/8 PTE's Total New FTE's:36 Total New PTE/Seasonal:7 Total Reclass/Promotion:4 Page 103 of 109 City of Fairhope Compensation Study - Pay Grades GRADE JOB TITLE MINIMUM MIDPOINT MAXIMUM HOURLY MIN HOURLY MID HOURLY MAX Grade 1 16,926.00$ 23,063.04$ 31,405.92$ 8.14$ 11.09$ 15.10$ [No jobs currently in this grade] Grade 2 18,957.12$ 25,814.88$ 35,184.24$ 9.11$ 12.41$ 16.92$ [No jobs currently in this grade] Grade 3 21,228.48$ 28,916.16$ 39,399.36$ 10.21$ 13.90$ 18.94$ Fitness Floor Attendant Front Desk Attendant Golf Cart Attendant Graphic Design Intern Lifeguard Snack Bar Attendant Starter/Marshall Utility Intern Grade 4 23,783.76$ 32,388.72$ 44,138.64$ 11.43$ 15.57$ 21.22$ Beach Booth Attendant Custodian Driver Equipment Operator I Gardener I Gate Attendant Golf Shop Attendant Lifeguard II Marina Worker Nursery Attendant Police Intern Tennis Attendant Water Operator Trainee Wastewater Operator Trainee Grade 5 26,622.96$ 36,276.24$ 49,423.92$ 12.80$ 17.44$ 23.76$ Customer Service Rep I Golf Grounds Maintenance Worker Meter Reader I Painter Assistant Revenue Courier Sanitation Hopper Snack Bar Crew Leader Page 104 of 109 City of Fairhope Compensation Study - Pay Grades GRADE JOB TITLE MINIMUM MIDPOINT MAXIMUM HOURLY MIN HOURLY MID HOURLY MAX Grade 6 29,833.44$ 40,644.24$ 55,364.40$ 14.34$ 19.54$ 26.62$ Accounts Payable Specialist Beach Patrol Officer Carpenter II Customer Service Rep II Directional Drill Operator Engineering Technician Equipment Operator II Front Desk Coordinator Gas Inspector Groundman Line Locator Mechanic/Clerk Meter Reader II Museum Assistant Painter Permit Technician Permit Technician/CRS Coordinator Police Records ClerkTennis Center Assistant Volunteer Outreach Coordinator Warehouse Supply Clerk Water Service Technician Grade 7 33,415.20$ 45,514.56$ 62,003.76$ 16.07$ 21.88$ 29.81$ Administrative Assistant Animal Control Officer Assistant Marina Manager Code Enforcement Officer Community Outreach and Comm Specialist Corrections Officer Dispatcher Electrician Facilities Maintenance Technician Field Audit Technician Fire/Safety Inspector Fire Station Maintenance Tech Gardener II Gas Installation Crew Leader Page 105 of 109 City of Fairhope Compensation Study - Pay Grades GRADE JOB TITLE MINIMUM MIDPOINT MAXIMUM HOURLY MIN HOURLY MID HOURLY MAX Gas Measurement Technician Gas Service Line Technician Golf Course Mechanic IT Communications Specialist Lifeguard Supervisor Lineman Apprentice Magistrate Mechanic Parks Maintenance Worker Purchasing Clerk Rental Facilities Assistant I Revenue Technician Senior Services Coordinator Water Operator II Water Service Tech II Crew Leader Wastewater Collection Operator Wastewater Operator II Wastewater Treatment Plant Lab Tech Welder/Fabricator Grade 8 37,411.92$ 50,974.56$ 69,451.20$ 17.99$ 24.51$ 33.39$ Assistant Wastewater Plant Operator Collection System Foreman Customer Service Rep III Equipment Operator III First Assistant Pro/Golf Shop Manager Golf Grounds Crew Leader Human Resources Coordinator Human Resources Coordinator/Police IT Technician Lead Electrician Parks Maintenance Crew Leader Planning Technician Police Officer Purchasing Agent Rental Facilities Assistant II Underground Foreman Wastewater Operator IV Grade 9 41,910.96$ 57,089.76$ 77,772.24$ 20.15$ 27.45$ 37.39$ Page 106 of 109 City of Fairhope Compensation Study - Pay Grades GRADE JOB TITLE MINIMUM MIDPOINT MAXIMUM HOURLY MIN HOURLY MID HOURLY MAX Accounting Assistant Assistant City Clerk Assistant WWTP Manager Building Inspector Carpenter III Chief Electrical Inspector Chief Water Operator Community Outreach/Events Coord Dispatch Supervisor Emergency Management Coordinator Equipment Operator IV Facilities Maintenance Tech Crew Leader Gardener III Help Desk Manager Lead Facilities Maintenance Technician Marina Manager Payroll Administrator Planning Clerk Police Corporal Police InvestigatorPolice Officer – K9 Pool Manager ROW Construction Inspector Safety Coordinator Sanitation Crew Leader Station Control Tech/Digital Forensic Substation Meter Technician Utility Billing Supervisor Grade 10 46,934.16$ 63,947.52$ 87,097.92$ 22.56$ 30.74$ 41.87$ Accounts Payable Supervisor CFM Electrician Chief Corrections Officer Community Outreach Coordinator Court Clerk Fire Station Maintenance Coordinator Gas Operations and Compliance Supervisor GIS Technician Lineman Mayor’s Executive Assistant Page 107 of 109 City of Fairhope Compensation Study - Pay Grades GRADE JOB TITLE MINIMUM MIDPOINT MAXIMUM HOURLY MIN HOURLY MID HOURLY MAX Police Sergeant ROW Construction Inspector Supervisor Scada Technician Staff Accountant Tennis Professional Tree Trim Crew Leader Warehouse And Purchasing Supervisor WWTP Manager Grade 11 52,568.88$ 71,613.36$ 97,559.28$ 25.27$ 34.43$ 46.90$ AMI Coordinator City Planner Gas Maintenance Supervisor Golf Grounds Manager IT Systems Administrator Licensed Electrician Museum Manager Recreation Center Manager Rental Facilities Manager Senior Services ManagerSoftware Support Engineer Grade 12 58,880.64$ 80,218.32$ 109,265.52$ 28.31$ 38.57$ 52.53$ Line Foreman Police Lieutenant Grade 13 65,934.96$ 89,827.92$ 122,391.36$ 31.70$ 43.19$ 58.84$ Assistant Building Official Purchasing Manager Revenue Manager Senior Accountant Grade 14 73,862.88$ 100,616.88$ 137,067.84$ 35.51$ 48.37$ 65.90$ Assistant Electric Superintendent Assistant Gas Superintendent Assistant Wastewater Superintendent Assistant Water Superintendent Development Services Manager Director of Golf Operations Horticulture Supervisor Page 108 of 109 City of Fairhope Compensation Study - Pay Grades GRADE JOB TITLE MINIMUM MIDPOINT MAXIMUM HOURLY MIN HOURLY MID HOURLY MAX Mechanic Maintenance Supervisor Police Captain Sanitation Supervisor Special Projects & Grants Manager Streets & Facilities Supervisor Grade 15 82,729.92$ 112,694.40$ 153,513.36$ 39.77$ 54.18$ 73.80$ Assistant Public Works Director Building Official Director of Community Affairs Director of Human Resources Director of Information Technology Director of Parks & Recreation Grade 16 92,645.28$ 126,213.36$ 171,946.32$ 44.54$ 60.68$ 82.67$ Chief of Police City Clerk City Treasurer Director of Planning Director of Public WorksElectric Superintendent Gas Superintendent Water and Wastewater Superintendent Page 109 of 109