FINAL PUBLIC HEARING FISCAL YEAR 2023/24 BUDGET with CRA BUDGET IMMEDIATELY FOLLOWING

City of Parker 23-24 Budget - As proposed by council on 7/17/23 DEPT 310 TAXES GL Number Description 22-23 Amended YTD As Of 2023-24 DEPT. NOTES Budget 03/31/2023 REQUESTED --- Estimated Revenue --- 01.310.312400 LOCAL OPTION GAS TAX 90,363.00 48,924.05 94,560.00 Based on prior year Actual Receipts from State of FL. Tax is levied on per gallon basis. Received large payment in Sept of PY - not expected again in CY 01.310.313100 ELECTRIC FRANCHISE FEES 252,000.00 131,998.02 276,000.00 Gulf Power Average 23,000 per month 42% of monthly pymt allocated to Franchise Fees remaining 58% allocated to Electric Utility tax 01.310.313400 GAS FRANCHISE FEES 8,748.00 4,527.18 5,040.00 Teco, Ferrell, Peoples Avg $420 per month 01.310.314100 ELECTRIC UTILITY TAX 349,440.00 182,282.98 384,000.00 Gulf Power Avg 32,000 per month. 58% of monthly pymt allocated to Electric Utility tax remaining 42% allocated to Franchise Fees 01.310.314300 WATER UTILITY TAX 99,161.00 47,571.61 95,670.00 10% City of Parker Tax on Water. Based on 10% of Estimated Water revenue for 23/24 01.310.314400 GAS UTILITY TAX 10,225.00 2,592.11 9,984.00 Peoples, Ferrell Gas Avg 832 per month for 21/22 collected $9,978 in 21/22 01.310.314800 PROPANE UTILITY TAX 2,016.00 1,426.74 2,676.00 Tax Collected on Propane sales. Avg collected 223 per month for 21/22. Collected 1,814 in 22/23 01.310.315000 COMMUNICATIONS TAX 79,378.00 51,174.05 80,286.00 Based on actual receipts from State of FL. Collected 80,286 in FY 21/22, Averaging 8,500 for Oct 22-April 23 01.311.318000 AD VALOREM TAX 0.00 0.00 823,042.94 AD Valorem taxes 3% of Total Estimated Revenue: 891,331.00 470,496.74 1,771,258.94 879,927.94 DEPT 320 LICENSES & PERMITS 98.72% GL Number Description 22-23 Amended YTD As Of 2023-24 DEPT. NOTES Budget 03/31/2023 REQUESTED --- Estimated Revenue --- 01.320.321000 BUSINESS TAX FEES 16,000.00 (261.80) 15,595.00 Based on Prior Year renewals 01.320.321500 BUSINESS TAX PENALTIES 350.00 (122.76) 275.00 Based on PY penalties 01.320.329100 BUILDING PERMIT FEES 5,000.00 5,333.07 39,000.00 Based on PY Permit fees including ECPI. When PY budget was created, these fees were coded to a liability instead of income. 01.320.329110 VARIANCE APPLICATION FEES 900.00 150.00 300.00 $150 each. 4 in PY, 1 in CY 01.320.329200 GARBAGE PERMIT FEES 23,227.00 7,926.95 25,200.00 Avg 2100 per month in PY 01.320.329300 GOLF CART PERMIT FEE 250.00 25.00 100.00 Only collected $175 in PY Total Estimated Revenue: 45,727.00 13,050.46 80,470.00 34,743.00 75.98% City of Parker 23-24 Budget - As proposed by council on 7/17/23 DEPT 330 INTERGOVERNMENTAL REVENUE GL Number Description 22-23 Amended YTD As Of 2023-24 DEPT. NOTES Budget 03/31/2023 REQUESTED --- Estimated Revenue --- 01.330.335120 SRS - SALES TAX 191,815.00 111,892.35 191,815.47 THIS WILL CHANGE IN JULY - WILL UPDATED WHEN NOTIFIED OF NEW RATE. State of Florida pymt beginning July 2022 $20,008.29. allocated 79.89% to SRS Sales tax and 21.20% to SRS Motor Fuel Tax. 01.330.335122 SRS - MOTOR FUEL TAX 55,223.00 28,165.68 55,222.88 THIS WILL CHANGE IN JULY - WILL UPDATED WHEN NOTIFIED OF NEW RATE. State of Florida pymt beginning July 2022 $20,008.29. allocated 79.89% to SRS Sales tax and 21.20% to SRS Motor Fuel Tax - RESTRICTED TO ROAD USE ONLY 01.330.335140 MOBILE HOME LICENSES 200.00 180.50 200.00 Based on PY 01.330.335150 ALCOHOLIC BEVERAGE LICENSES 1,000.00 0.00 1,800.00 Based on PY 01.330.335180 HALF CENT SALES TAX 539,556.00 241,931.30 546,804.00 State of FL Avg 45,567 monthly for PY. 01.330.335181 LOCAL INFRASTRUCTURE HALF CENT TAX 530,064.00 239,144.77 473,820.00 State of FL Avg 39,485 monthly for PY. Use these funds for street paving in 23/24 (see street budget) 01.330.335600 MOTOR FUEL TAX REBATE 3,480.00 802.99 3,500.00 Based on PY Total Estimated Revenue: 1,321,338.00 622,117.59 1,273,162.35 (48,175.65) -3.65% DEPT 340 CHARGES FOR SERVICES GL Number Description 22-23 Amended YTD As Of 2023-24 DEPT. NOTES Budget 03/31/2023 REQUESTED --- Estimated Revenue --- 01.340.341100 CERTIFY, COPY, RESEARCH 7,000.00 3,505.31 5,820.00 Lien Searches based on Avg 485 per month in current year 01.340.341950 ELECTION FEES 0.00 0.00 - 01.340.342100 POLICE SERVICES 9,912.00 4,311.57 9,800.00 Based on PY Reimbursement from Bay County 01.340.342500 CODE ENFORCEMENT REVIEW 0.00 0.00 - 01.340.343400 TIPPING FEES 362,633.00 196,240.45 363,900.00 Garbage fees Avg 30,325 in PY 01.340.343410 PENALTIES 8,652.00 5,133.58 9,600.00 Avg 800 per month PY 01.340.343450 SPECIAL TIPPING FEES 0.00 0.00 - 01.340.349200 STATE CONTRACT ST. LIGHTING 21,100.00 0.00 22,600.00 Received annually in June from Dept of Transportation. Based on 2023 receipt Total Estimated Revenue: 409,297.00 209,190.91 411,720.00 2,423.00 0.59% City of Parker 23-24 Budget - As proposed by council on 7/17/23 DEPT 350 FINES & FORFEITS GL Number Description 22-23 Amended YTD As Of 2023-24 DEPT. NOTES Budget 03/31/2023 REQUESTED --- Estimated Revenue --- 01.350.351100 JUDGEMENTS & FINES 2,000.00 1,796.40 3,660.00 Police Judgements & Fines 01.350.354000 LOCAL ORDINANCE VIOLATIONS 25,000.00 6,144.04 25,000.00 Do we want to keep this the same? We received 41,260 thru 5/31. Collection is unknown - 29,739 received in May Total Estimated Revenue: 27,000.00 7,940.44 28,660.00 1,660.00 6.15% DEPT 360 GL Number Description 22-23 Amended YTD As Of 2023-24 DEPT. NOTES Budget 03/31/2023 REQUESTED --- Estimated Revenue --- 01.360.361000 INTEREST 2,062.00 356.17 1,900.00 Interest on Pooled Cash 01.360.362000 RENT 15,600.00 4,814.00 9,000.00 Currently avg $750 per month through May 01.360.362100 LEASE INCOME - CELL TOWER 21,780.00 12,705.00 23,232.00 $1,815 per month Oct-Jan upon renewal in Feb 2024 rate increases 110% of current rental rate= $1,996.50 Feb-Sept. 01.360.365000 SALE OF SURPLUS MATERIAL 500.00 0.00 - Zero in PY and CY. 01.360.366000 PARKS CONTRIBUTIONS 972.00 426.11 816.00 Currently avg $68 per month through May. Down from $81 per month in PY 01.360.366050 CITIZEN DONATIONS 0.00 0.00 - 01.360.369000 OTHER MISCELLANEOUS REVENUES-WATER 22,841.00 22,598.55 15,000.00 Insurance Claims, Workers Comp refunds from PY, Records Request, Rebates from Credit Card 01.360.369100 SCRAP METAL REVENUE 7,000.00 728.09 1,080.00 Avg $90 in current year. Down from Prior years Total Estimated Revenue: 70,755.00 41,627.92 51,028.00 (19,727.00) -27.88% TOTAL REVENUES 2,765,448.00 1,364,424.06 3,616,299.30 850,851.30 30.77% City of Parker 23-24 Budget - As proposed by council on 7/17/23 DEPT 519 GENERAL GOVERNMENT GL Number Description 22-23 Amended YTD As Of 2023-24 DEPT. NOTES Budget 03/31/2023 REQUESTED --- Appropriations --- 01.519.512000 REGULAR SALARIES 68,298.00 38,842.81 73,004.95 50% Clerk, Julie & 33.34% 2 Front Desk. 01.519.512100 REGULAR ON CALL PAY 0.00 0.00 - 01.519.514000 OVERTIME 1,031.00 0.00 1,137.62 01.519.515000 SPECIAL PAY 0.00 0.00 - 01.519.516000 Non Cash Compensation 400.00 400.00 400.00 $100 gift card per employee X 4 01.519.521000 FICA TAXES 5,304.00 2,869.59 5,671.91 01.519.522000 RETIREMENT CONTRIBUTIONS 8,257.00 4,626.16 10,061.15 01.519.523000 HEALTH INSURANCE 15,147.00 1,514.68 16,964.21 01.519.523025 VISION INSURANCE 0.00 0.00 - 01.519.523050 LIFE INSURANCE 102.00 56.11 102.01 01.519.523075 DENTAL INSURANCE 655.00 92.71 654.85 01.519.524000 WORKERS COMPENSATION 351.00 239.57 118.63 01.519.525000 UNEMPLOYMENT COMPENSATION 200.00 0.00 200.00 01.519.529000 MAYOR & COUNCIL STIPEND 13,200.00 6,600.00 13,200.00 50% of Council and Mayor's stipend 01.519.531000 PROFESSIONAL SERVICES 70.00 69.45 - 01.519.531100 PROFESSIONAL SERVICES - ENGINEERING 20,000.00 5,535.00 20,000.00 Anchor 01.519.531200 PROFESSIONAL SERVICES - LEGAL 56,250.00 29,841.77 56,250.00 Sloan Reflects hourly rate increase voted on 8/17/22 01.519.531210 OTHER LEGAL FEES 0.00 0.00 - 01.519.532100 ACCOUNTING & AUDITING 49,000.00 1,791.50 49,000.00 Carr Riggs and Ingram Audit 01.519.534100 OTHER CONTRACTUAL SERVICES 50,000.00 23,522.21 50,000.00 Aaron Rich, Flux Labs, Cintas, Suzanne 01.519.534110 FILING FEES 300.00 0.00 300.00 01.519.534300 LIBRARY CONTRACT 39,737.00 19,868.50 39,737.00 No Change - Updated for new contract dated 24 fiscal year 01.519.534360 BAD DEBTS 0.00 0.00 - 01.519.534400 ELECTIONS 0.00 0.05 - 01.519.534500 COUNTY TRANSIT SERVICES 8,972.00 8,972.00 8,972.00 Bay County Board of County Commissioners - Requested Contribution of $3,972 for Bay Area Transportation (demand respond system) and $5,000 request annual contribution for Bay Town Trolley. 01.519.540000 TRAVEL & PER DIEM 7,205.00 666.72 7,205.00 conferences 01.519.541000 COMMUNICATIONS 6,592.00 2,897.08 6,592.00 1 - 800Mhz phone annual pymt of 893 (1.79% of $50,000)Fiberoptic $300 per month, FLUX 50% of 180 per month, Verizon 27 per month 01.519.541100 POSTAGE & FREIGHT 5,460.00 2,545.50 5,915.00 50% of monthly utility billing and 25 books of stamps. Avg $455 per month 01.519.543000 UTILITIES 3,000.00 968.82 3,000.00 Water at City Hall 01.519.544000 RENTAL & LEASES 5,000.00 1,219.46 5,000.00 Reliable Copy / Airgas 01.519.545000 INSURANCE 33,770.00 14,682.75 77,282.69 Auto = 320, Community Building & Contents 38,289, General Liability 15,330, Public Officials E&O 16,157, Cyber Liability 5897,Crime 1,100 01.519.546100 R&M - BUILDINGS & GROUNDS 5,000.00 248.05 5,000.00 City Hall complex maintenance/PW split 01.519.546200 R&M - MACHINERY & EQUIPMENT 1,000.00 672.19 1,000.00 01.519.546300 R&M - VEHICLES 1,000.00 0.00 1,000.00 Auto Parts/PW split 01.519.547000 PRINTING & BINDING 750.00 253.39 750.00 reduces due to newsletter 01.519.548000 EVENTS/COMMUNITY OUTREACH 0.00 0.00 - 01.519.548500 EMPLOYEE EVENTS 1,500.00 Thanksgiving and Christmas lunches City of Parker 23-24 Budget - As proposed by council on 7/17/23 01.519.549000 OTHER CURRENT CHARGES 3,700.00 1,850.84 3,700.00 advertising/thank you sign/petty cash like items 01.519.551000 OFFICE SUPPLIES 3,000.00 1,718.64 3,000.00 01.519.551500 SMALL TOOLS 0.00 0.00 - 01.519.552000 OPERATING SUPPLIES 710.00 429.96 710.00 519 part from PW split 01.519.552100 FUEL & LUBRICANTS 250.00 118.70 250.00 PW split for autos 01.519.552200 UNIFORMS 0.00 0.00 - 01.519.554100 BOOKS, PUBLICATIONS 0.00 0.00 - 01.519.554200 MEMBERSHIPS 5,050.00 1,566.00 2,500.00 League of City's, Includes Emerald Coast 01.519.554300 SOFTWARE/HARDWARE 13,000.00 0.00 13,000.00 BS&A and Zoom 01.519.664000 MACHINERY & EQUIPMENT 190.00 0.00 190.00 01.519.771000 PRINCIPAL 620.00 266.86 620.00 Principal portion of annual Lease payment on Motorola 800MHZ radios $4500 01.519.772000 INTEREST 13,140.00 9,972.91 13,140.00 Interest portion of annual Lease payment on Motorola 800MHZ radios $140 and Interest paid to Trustmark for FEMA Line of Credit Est 13,000 Total Appropriations: 445,711.00 184,919.98 497,129.02 51,418.02 11.54% City of Parker 23-24 Budget - As proposed by council on 7/17/23 DEPT 521 POLICE DEPARTMENT GL Number Description 22-23 Amended YTD As Of 2023-24 DEPT. NOTES Budget 03/31/2023 REQUESTED --- Appropriations --- 01.521.512000 REGULAR SALARIES 471,189.00 208,932.71 497,650.94 10 FTE 01.521.513000 OTHER SALARIES 0.00 0.00 - 01.521.514000 OVERTIME 16,737.00 12,983.01 16,805.10 01.521.515000 SPECIAL PAY 6,810.00 1,620.00 3,240.00 $270 per month 01.521.516000 Non Cash Compensation 1,000.00 800.00 1,000.00 $100 gift card per employee X 10 01.521.521000 FICA TAXES 37,326.00 16,930.77 39,355.88 01.521.522000 RETIREMENT CONTRIBUTIONS 135,790.00 59,430.62 168,072.79 01.521.523000 HEALTH INSURANCE 90,872.00 9,276.68 101,777.09 01.521.523025 VISION INSURANCE 0.00 0.00 - 01.521.523050 LIFE INSURANCE 612.00 249.90 612.00 01.521.523075 DENTAL INSURANCE 3,596.00 413.07 3,595.92 01.521.524000 WORKERS COMPENSATION 15,966.00 7,685.88 16,794.34 01.521.525000 UNEMPLOYMENT COMPENSATION 0.00 0.00 - 01.521.531000 PROFESSIONAL SERVICES 417.00 416.67 - 01.521.534100 OTHER CONTRACTUAL SERVICES 1,000.00 1,049.76 1,000.00 New hire physicals & Drug Screens 01.521.540000 TRAVEL & PER DIEM 3,200.00 199.68 3,200.00 01.521.541000 COMMUNICATIONS 37,800.00 17,152.26 42,700.00 Pumps, Verizon, air cards, advanced technology & 23 - 800 MHz radios $20536, Unity Fiber 01.521.541100 POSTAGE & FREIGHT 400.00 0.00 400.00 Certified Mail and evidence shipment & Stamps 01.521.543000 UTILITIES 0.00 0.00 - 01.521.544000 RENTAL & LEASES 2,400.00 971.59 2,400.00 3550 ci copier 01.521.545000 INSURANCE 24,486.00 0.00 46,923.65 Auto insurance 5638, Building and Contents 27445, Law Enforcement Liability 13840 01.521.546100 R&M - BUILDINGS & GROUNDS 1,000.00 405.78 1,000.00 01.521.546200 R&M - MACHINERY & EQUIPMENT 2,500.00 1,141.16 2,500.00 01.521.546300 R&M - VEHICLES 17,546.00 9,278.87 17,550.00 01.521.547000 PRINTING & BINDING 0.00 0.00 - 01.521.548000 EVENTS/COMMUNITY OUTREACH 300.00 0.00 300.00 various events throughout the year 01.521.549000 OTHER CURRENT CHARGES 500.00 0.00 500.00 Vehicle registration , fire extinguisher inspections, misc 01.521.551000 OFFICE SUPPLIES 600.00 281.01 600.00 Paper, binder, dividers, etc 01.521.551500 SMALL TOOLS 700.00 319.69 700.00 Tuning forks, firearms parts 01.521.552000 OPERATING SUPPLIES 4,000.00 1,082.68 4,000.00 Drug test kits, ammo, gloves, containers, zip ties, evidence bags, printer ink, etc 01.521.552100 FUEL & LUBRICANTS 40,000.00 12,203.41 40,000.00 $4 per gallon 10,000 gallons for 10 vehicles 01.521.552200 UNIFORMS 4,537.50 0.00 4,540.00 Clean & replace uniforms, dress uniforms for court 01.521.554100 BOOKS, PUBLICATIONS 725.00 0.00 725.00 statue books, $72 each X 10 01.521.554200 MEMBERSHIPS 900.00 0.00 900.00 FPCA, IACP Net/Login, IACP & K9 01.521.554300 SOFTWARE/HARDWARE 500.00 0.00 500.00 Eset software (500) 01.521.554400 TRAINING 4,537.50 1,494.16 4,540.00 Various Conferences, training ammo, courses 01.521.662000 BUILDINGS 0.00 0.00 - 01.521.663000 IMPROVEMENTS OTHER THAN BUILDINGS 19,000.00 0.00 3,500.00 Printers for cars $350 each X 10 01.521.664000 MACHINERY & EQUIPMENT 320.00 319.54 320.00 Includes $60,000 for police car per 6/12/23 dept head meeting - update 7/10 meeting NO car 01.521.771000 PRINCIPAL 6,138.00 6,137.83 6,150.00 Principal portion of annual Lease payment on Motorola 800MHZ radios 01.521.772000 INTEREST 1,380.00 635.49 1,400.00 Interest portion of annual Lease payment on Motorola 800MHZ radios Total Appropriations: 954,785.00 371,412.22 1,035,252.70 80,467.70 8.43% City of Parker 23-24 Budget - As proposed by council on 7/17/23 DEPT 522 FIRE DEPARTMENT GL Number Description 22-23 Amended YTD As Of 2023-24 DEPT. NOTES Budget 03/31/2023 REQUESTED --- Appropriations --- 01.522.512000 REGULAR SALARIES 173,039.00 49,103.78 169,713.87 01.522.513000 OTHER SALARIES 0.00 0.00 - 01.522.514000 OVERTIME 25,000.00 23,868.99 25,269.36 01.522.515000 SPECIAL PAY 600.00 600.00 1,200.00 100 per month 01.522.516000 Non Cash Compensation 2,100.00 1,200.00 400.00 $100 per employee 01.522.521000 FICA TAXES 14,449.00 5,460.79 14,264.02 01.522.522000 RETIREMENT CONTRIBUTIONS 52,565.00 19,810.19 60,915.79 01.522.523000 HEALTH INSURANCE 36,349.00 2,461.16 40,710.84 01.522.523025 VISION INSURANCE 0.00 0.00 - 01.522.523050 LIFE INSURANCE 245.00 66.30 244.80 01.522.523075 DENTAL INSURANCE 1,572.00 109.59 1,571.52 01.522.524000 WORKERS COMPENSATION 9,633.00 5,830.66 9,509.35 01.522.525000 UNEMPLOYMENT COMPENSATION 200.00 0.00 200.00 01.522.531000 PROFESSIONAL SERVICES 167.00 166.67 167.00 01.522.531150 VOLUNTEER FIRE DEPARTMENT 28,770.00 14,385.00 28,770.00 01.522.531160 VOLUNTEER EMERGENCY COSTS 0.00 0.00 - 01.522.534100 OTHER CONTRACTUAL SERVICES 736.00 803.00 740.00 01.522.540000 TRAVEL & PER DIEM 0.00 0.00 - 01.522.541000 COMMUNICATIONS 19,703.00 10,798.50 19,703.00 Bay Cty 800Mhz 17 radios, 15,179, Nextiva 87 per month and WOW Avg $290 per month 01.522.541100 POSTAGE & FREIGHT 120.00 0.00 120.00 01.522.543000 UTILITIES 8,340.00 1,862.94 8,340.00 01.522.544000 RENTAL & LEASES 0.00 0.00 - 01.522.545000 INSURANCE 2,963.00 0.00 2,583.00 Auto insurance = 2583 01.522.546100 R&M - BUILDINGS & GROUNDS 0.00 0.00 - 01.522.546200 R&M - MACHINERY & EQUIPMENT 5,000.00 2,148.76 5,000.00 01.522.546300 R&M - VEHICLES 5,000.00 275.00 5,000.00 01.522.548000 EVENTS/COMMUNITY OUTREACH 300.00 210.41 300.00 01.522.549000 OTHER CURRENT CHARGES 0.00 0.00 - 01.522.551000 OFFICE SUPPLIES 1,000.00 109.85 1,000.00 01.522.551500 SMALL TOOLS 0.00 0.00 - 01.522.552000 OPERATING SUPPLIES 3,000.00 634.12 3,000.00 01.522.552100 FUEL & LUBRICANTS 6,000.00 1,973.29 6,000.00 01.522.552200 UNIFORMS 750.00 579.19 750.00 01.522.554200 MEMBERSHIPS 525.00 0.00 525.00 01.522.554300 SOFTWARE/HARDWARE 0.00 0.00 - 01.522.554400 TRAINING 7,000.00 0.00 7,000.00 01.522.664000 MACHINERY & EQUIPMENT 0.00 0.00 - 01.522.771000 PRINCIPAL 25,700.00 4,536.62 25,700.00 Principal portion of annual Lease payment on Motorola 800MHZ radios $4500 & Principal on fire truck loan 21,200 01.522.772000 INTEREST 2,900.00 469.71 2,900.00 Interest portion of annual Lease payment on Motorola 800MHZ radios & interest on fire truck loan $1850 Total Appropriations: 433,726.00 147,464.52 441,597.54 7,871.54 City of Parker 23-24 Budget - As proposed by council on 7/17/23 DEPT 523 CODE ENFORCEMENT GL Number Description 22-23 Amended YTD As Of 2023-24 DEPT. NOTES Budget 03/31/2023 REQUESTED --- Appropriations --- 01.523.512000 REGULAR SALARIES 53,663.00 23,682.27 48,754.33 100% Jennifer and 43.33% of Carleigh 01.523.514000 OVERTIME 76.00 0.00 487.54 01.523.515000 SPECIAL PAY 0.00 0.00 - 01.523.516000 Non Cash Compensation 200.00 200.00 100.00 $100 per person X 2 01.523.521000 FICA TAXES 4,146.00 1,806.45 3,767.00 01.523.522000 RETIREMENT CONTRIBUTIONS 6,455.00 2,820.50 6,682.12 01.523.523000 HEALTH INSURANCE 13,025.00 410.17 14,587.71 01.523.523025 VISION INSURANCE 0.00 0.00 - 01.523.523050 LIFE INSURANCE 88.00 31.45 87.72 01.523.523075 DENTAL INSURANCE 230.00 18.25 563.11 01.523.524000 WORKERS COMPENSATION 1,463.00 25.43 1,327.79 01.523.531000 PROFESSIONAL SERVICES 60.00 59.72 - 01.523.531200 PROFESSIONAL SERVICES - LEGAL 31,250.00 5,824.74 31,250.00 Kept same as last year 01.523.534100 OTHER CONTRACTUAL SERVICES 35,000.00 30,422.00 35,000.00 Same as last year - Demolition - 7 homes at cost of $5,000 each 01.523.534110 FILING FEES 1,000.00 850.00 1,000.00 01.523.534200 ANIMAL CONTROL 48,000.00 7,444.81 48,000.00 01.523.540000 TRAVEL & PER DIEM 0.00 0.00 - 01.523.541000 COMMUNICATIONS 1,643.00 578.24 893.00 1 - 800Mhz radio $893 01.523.541100 POSTAGE & FREIGHT 1,500.00 1,109.80 1,500.00 01.523.543000 UTILITIES 0.00 0.00 - 01.523.544000 RENTAL & LEASES 0.00 0.00 - 01.523.545000 INSURANCE 327.00 0.00 327.00 Auto coverage 327 01.523.546200 R&M - MACHINERY & EQUIPMENT 52.00 51.41 52.00 01.523.546300 R&M - VEHICLES 600.00 348.40 600.00 01.523.547000 PRINTING & BINDING 165.00 165.00 164.00 01.523.549000 OTHER CURRENT CHARGES 200.00 0.00 200.00 01.523.551000 OFFICE SUPPLIES 167.00 166.83 167.00 01.523.552000 OPERATING SUPPLIES 0.00 0.00 - 01.523.552100 FUEL & LUBRICANTS 1,500.00 518.82 1,500.00 01.523.552200 UNIFORMS 0.00 0.00 - 01.523.554100 BOOKS, PUBLICATIONS 0.00 0.00 - 01.523.554200 MEMBERSHIPS 100.00 40.00 100.00 01.523.554300 SOFTWARE/HARDWARE 4,500.00 0.00 - BS&A - no comcate needed 01.523.554400 TRAINING 1,100.00 0.00 1,100.00 Code Conference for 2 people 01.523.664000 MACHINERY & EQUIPMENT 1,900.00 0.00 - 01.523.771000 PRINCIPAL 267.00 266.86 267.00 01.523.772000 INTEREST 60.00 27.63 60.00 Total Appropriations: 208,737.00 76,868.78 198,537.33 (10,199.67) -4.89% City of Parker 23-24 Budget - As proposed by council on 7/17/23 DEPT 534 TRASH DEPARTMENT GL Number Description 22-23 Amended YTD As Of 2023-24 DEPT. NOTES Budget 03/31/2023 REQUESTED --- Appropriations --- 01.534.512000 REGULAR SALARIES 81,640.00 32,738.50 87,464.00 01.534.514000 OVERTIME 1,144.00 157.50 1,224.50 01.534.515000 SPECIAL PAY 0.00 0.00 - 01.534.516000 Non Cash Compensation 200.00 200.00 200.00 01.534.521000 FICA TAXES 6,333.00 2,394.79 6,784.67 01.534.522000 RETIREMENT CONTRIBUTIONS 9,859.00 3,917.78 12,035.03 01.534.523000 HEALTH INSURANCE 18,174.00 1,514.56 20,355.42 01.534.523025 VISION INSURANCE 0.00 0.00 - 01.534.523050 LIFE INSURANCE 122.00 40.80 122.40 01.534.523075 DENTAL INSURANCE 786.00 67.44 785.76 01.534.524000 WORKERS COMPENSATION 5,017.00 2,252.76 5,374.52 01.534.531000 PROFESSIONAL SERVICES 84.00 83.33 100.00 01.534.534100 OTHER CONTRACTUAL SERVICES 100.00 100.00 100.00 01.534.534200 DISPOSAL FEE 77,943.00 25,668.36 75,000.00 Steelfield and Demolition Disposal 01.534.540000 TRAVEL & PER DIEM 0.00 0.00 - 01.534.541000 COMMUNICATIONS 1,786.00 907.96 1,786.00 800 Mhz (Bay County) 2 radios 01.534.543000 UTILITIES 0.00 0.00 - 01.534.545000 INSURANCE 1,916.00 0.00 1,916.00 Trash truck insurance 1916 01.534.546200 R&M - MACHINERY & EQUIPMENT 8,000.00 5,420.16 8,000.00 Trash Truck Repairs 01.534.546300 R&M - VEHICLES 10,000.00 1,772.59 10,000.00 Filters, Wipers, Head/Tail Lights 01.534.549000 OTHER CURRENT CHARGES 275.00 0.00 275.00 01.534.551000 OFFICE SUPPLIES 0.00 0.00 - 01.534.551500 SMALL TOOLS 100.00 0.00 100.00 Rakes, Oil Dispenser Jug 01.534.552000 OPERATING SUPPLIES 500.00 163.94 750.00 Oil 01.534.552100 FUEL & LUBRICANTS 22,500.00 11,604.34 24,000.00 Fuel 01.534.552200 UNIFORMS 1,500.00 184.84 1,500.00 Unifirst-Uniforms 01.534.553000 ROAD MATERIALS & SUPPLIES 0.00 0.00 - 01.534.554400 TRAINING 0.00 0.00 - 01.534.663000 IMPROVEMENTS OTHER THAN BUILDINGS 0.00 0.00 - 01.534.664000 MACHINERY & EQUIPMENT 0.00 0.00 - 01.534.771000 PRINCIPAL 28,034.00 28,033.44 33,248.00 Principal portion of annual Lease payment on Motorola 800MHZ radios $460 & Principal on Trash NEW truck loan 32.787.45 payment due 6/1/24 01.534.772000 INTEREST 1,008.00 667.41 8,015.00 Interest portion of annual Lease payment on Motorola 800MHZ radios$110 & interest on trash truck 7904.19 payment due 6/1/24 Total Appropriations: 277,021.00 117,890.50 299,136.30 22,115.30 7.98% City of Parker 23-24 Budget - As proposed by council on 7/17/23 DEPT 541 STREET DEPARTMENT GL Number Description 22-23 Amended YTD As Of 2023-24 DEPT. NOTES Budget 03/31/2023 REQUESTED --- Appropriations --- 01.541.512000 REGULAR SALARIES 235,324.00 87,756.93 248,487.20 6 FTE (1/2 of Tony and Taylor) 01.541.513000 OTHER SALARIES 0.00 0.00 - 01.541.514000 OVERTIME 2,843.00 33.75 3,004.89 01.541.515000 SPECIAL PAY 0.00 0.00 - 01.541.516000 Non Cash Compensation 700.00 500.00 500.00 01.541.521000 FICA TAXES 18,220.00 6,728.41 19,239.14 01.541.522000 RETIREMENT CONTRIBUTIONS 28,366.00 10,455.70 34,127.48 01.541.523000 HEALTH INSURANCE 54,523.00 4,543.67 61,066.25 01.541.523025 VISION INSURANCE 0.00 0.00 - 01.541.523050 LIFE INSURANCE 367.00 122.40 367.20 01.541.523075 DENTAL INSURANCE 2,357.00 202.30 2,357.28 01.541.524000 WORKERS COMPENSATION 18,845.00 6,625.76 19,922.60 01.541.531000 PROFESSIONAL SERVICES 250.00 250.00 250.00 01.541.531100 PROFESSIONAL SERVICES - ENGINEERING 0.00 0.00 - 01.541.534100 OTHER CONTRACTUAL SERVICES 12,500.00 6,723.78 12,500.00 01.541.540000 TRAVEL & PER DIEM 0.00 0.00 - 01.541.541000 COMMUNICATIONS 5,300.00 2,174.33 4,050.00 800 Megahertz 4 radios (Bay County), Verizon 01.541.541100 POSTAGE & FREIGHT 100.00 0.00 100.00 01.541.543000 UTILITIES 0.00 0.00 - 01.541.543100 STREET LIGHTING 80,000.00 31,215.47 80,000.00 Florida Power & Lighting 01.541.545000 INSURANCE 606.00 0.00 606.00 Auto insurance 606 01.541.546100 R&M - BUILDINGS & GROUNDS 5,000.00 808.13 5,000.00 Air Compressor, Mowers 01.541.546200 R&M - MACHINERY & EQUIPMENT 8,000.00 1,167.21 8,000.00 Mowers, Weed eaters 01.541.546300 R&M - VEHICLES 6,000.00 1,796.54 6,000.00 Street Vehicle Repairs 01.541.547000 PRINTING & BINDING 250.00 0.00 250.00 01.541.549000 OTHER CURRENT CHARGES 300.00 0.00 300.00 01.541.551000 OFFICE SUPPLIES 100.00 0.00 100.00 01.541.551500 SMALL TOOLS 3,000.00 262.84 3,500.00 Trimmers 01.541.552000 OPERATING SUPPLIES 3,000.00 827.33 3,500.00 Hats, Grease, Screw Remover 01.541.552100 FUEL & LUBRICANTS 13,000.00 6,833.66 15,000.00 Fuel 01.541.552200 UNIFORMS 2,000.00 313.19 2,000.00 Unifirst-Uniforms 01.541.553000 ROAD MATERIALS & SUPPLIES 14,000.00 8,618.36 16,000.00 Signs, Sandbags, Weed Killer, asphalt repairs, concrete repairs 01.541.554200 MEMBERSHIPS 0.00 0.00 - 01.541.554400 TRAINING 500.00 37.50 500.00 CEU Certification, licenses 01.541.662000 BUILDINGS 0.00 0.00 - 01.541.663000.0.5CENT IMPROVEMENTS OTHER THAN BUILDINGS 530,064.00 40,853.51 544,320.00 70,500 Sidewalk/headwalls + 473,820 Infrastructure tax revenue 01.541.663000. IMPROVEMENTS OTHER THAN BUILDINGS 0.00 0.00 - 01.541.664000 MACHINERY & EQUIPMENT 0.00 0.00 - 01.541.771000 PRINCIPAL 1,068.00 1,067.44 1,068.00 Motorola 01.541.772000 INTEREST 180.00 110.52 180.00 Total Appropriations: 1,046,763.00 220,028.73 1,092,296.04 45,533.04 4.35% City of Parker 23-24 Budget - As proposed by council on 7/17/23 DEPT 549 FLEET DEPARTMENT GL Number Description 22-23 Amended YTD As Of 2023-24 DEPT. NOTES Budget 03/31/2023 REQUESTED --- Appropriations --- 01.549.512000 REGULAR SALARIES 22,360.00 11,164.00 23,478.00 01.549.514000 OVERTIME 313.00 0.00 328.69 01.549.515000 SPECIAL PAY 0.00 0.00 - 01.549.516000 Non Cash Compensation 100.00 100.00 100.00 01.549.521000 FICA TAXES 1,734.00 704.71 1,821.21 01.549.522000 RETIREMENT CONTRIBUTIONS 2,700.00 1,329.55 3,230.57 01.549.523000 HEALTH INSURANCE 4,544.00 567.96 5,088.85 01.549.523025 VISION INSURANCE 0.00 0.00 - 01.549.523050 LIFE INSURANCE 31.00 15.31 30.60 01.549.523075 DENTAL INSURANCE 196.00 25.26 196.44 01.549.524000 WORKERS COMPENSATION 576.00 530.06 604.69 01.549.531000 PROFESSIONAL SERVICES 21.00 20.83 - 01.549.534100 OTHER CONTRACTUAL SERVICES 0.00 0.00 - 01.549.540000 TRAVEL & PER DIEM 0.00 0.00 - 01.549.541000 COMMUNICATIONS 1,697.00 260.02 800.00 1/2 800mhz radio 01.549.541100 POSTAGE & FREIGHT 0.00 0.00 - 01.549.543000 UTILITIES 0.00 0.00 - 01.549.544000 RENTAL & LEASES 620.00 0.00 600.00 01.549.546100 R&M - BUILDINGS & GROUNDS 1,000.00 495.26 1,000.00 Fire Extinguishers, A/C Filters 01.549.546200 R&M - MACHINERY & EQUIPMENT 1,000.00 137.13 1,000.00 Battery Clamps, Tube Kit 01.549.546300 R&M - VEHICLES 1,000.00 305.11 1,000.00 Vehicle Repairs in the fleet, Tires 01.549.547000 PRINTING & BINDING 0.00 0.00 - 01.549.549000 OTHER CURRENT CHARGES 200.00 0.00 200.00 01.549.551000 OFFICE SUPPLIES 179.00 0.00 200.00 01.549.551500 SMALL TOOLS 2,500.00 604.72 5,000.00 01.549.552000 OPERATING SUPPLIES 4,000.00 1,074.44 4,500.00 Grease, Brake Cleaner, Blue Wave Drum, Tape 01.549.552000.CDBGDEO OPERATING SUPPLIES 0.00 0.00 - 01.549.552100 FUEL & LUBRICANTS 1,000.00 345.34 1,000.00 Fuel 01.549.552200 UNIFORMS 350.00 99.88 350.00 Unifirst- Uniforms 01.549.554300 SOFTWARE/HARDWARE 750.00 750.00 1,000.00 01.549.554400 TRAINING 0.00 0.00 - 01.549.663000 IMPROVEMENTS OTHER THAN BUILDINGS 0.00 0.00 - 01.549.664000 MACHINERY & EQUIPMENT 2,500.00 0.00 2,500.00 01.549.771000 PRINCIPAL 250.00 133.43 250.00 01.549.772000 INTEREST 60.00 13.77 60.00 Total Appropriations: 49,681.00 18,676.78 54,339.05 4,658.05 9.38% City of Parker 23-24 Budget - As proposed by council on 7/17/23 DEPT 572 PARKS DEPARTMENT GL Number Description 22-23 Amended YTD As Of 2023-24 DEPT. NOTES Budget 03/31/2023 REQUESTED --- Appropriations --- 01.572.512000 REGULAR SALARIES 34,980.00 17,774.21 72,592.00 Added 1 position 01.572.514000 OVERTIME 490.00 301.50 1,016.29 01.572.515000 SPECIAL PAY 0.00 0.00 - 01.572.516000 Non Cash Compensation 100.00 100.00 200.00 01.572.521000 FICA TAXES 2,713.00 1,390.43 5,631.03 01.572.522000 RETIREMENT CONTRIBUTIONS 4,224.00 2,152.82 9,988.64 01.572.523000 HEALTH INSURANCE 9,087.00 1,135.92 20,355.42 01.572.523025 VISION INSURANCE 0.00 0.00 - 01.572.523050 LIFE INSURANCE 61.00 30.60 122.40 01.572.523075 DENTAL INSURANCE 393.00 50.58 785.76 01.572.524000 WORKERS COMPENSATION 1,338.00 530.06 2,775.03 01.572.531000 PROFESSIONAL SERVICES 42.00 41.67 - 01.572.534100 OTHER CONTRACTUAL SERVICES 9,000.00 1,934.52 9,000.00 Trash at Earl Gilbert/ Porta Potties at Earl Gilbert 01.572.540000 TRAVEL & PER DIEM 0.00 0.00 - 01.572.541000 COMMUNICATIONS 1,363.00 768.39 1,363.00 1 - 800 Megahertz (Bay County) & Verizon 01.572.543000 UTILITIES 9,600.00 4,116.93 9,600.00 Florida Power & Lighting, Water 01.572.544000 RENTAL & LEASES 1,500.00 0.00 1,500.00 01.572.545000 INSURANCE 5,785.00 0.00 5,785.00 PITO property Insurance 01.572.546100 R&M - BUILDINGS & GROUNDS 20,000.00 13,230.66 20,000.00 Repairs to buildings and Mowers/ Weed eaters 01.572.546200 R&M - MACHINERY & EQUIPMENT 6,000.00 348.86 6,000.00 Filters/ Tires and equipment repairs 01.572.546300 R&M - VEHICLES 3,000.00 432.80 3,000.00 Park Vehicle Repairs 01.572.548000 EVENTS/COMMUNITY OUTREACH 1,500.00 0.00 1,500.00 01.572.548500 EVENTS-EMPLOYEE 500.00 1,377.17 - Moved this to gen government in PY mid year adjustment 01.572.549000 OTHER CURRENT CHARGES 300.00 0.00 300.00 01.572.551000 OFFICE SUPPLIES 0.00 0.00 - 01.572.551500 SMALL TOOLS 2,000.00 262.83 2,500.00 Rakes, Gas Auger etc. 01.572.552000 OPERATING SUPPLIES 3,000.00 1,200.43 3,500.00 Grease, Shirts etc. 01.572.552100 FUEL & LUBRICANTS 1,750.00 912.34 3,000.00 01.572.552200 UNIFORMS 600.00 141.40 600.00 01.572.554400 TRAINING 200.00 0.00 200.00 01.572.662000 BUILDINGS 0.00 0.00 - 01.572.663000 IMPROVEMENTS OTHER THAN BUILDINGS 2,071.00 0.00 2,071.00 01.572.664000 MACHINERY & EQUIPMENT 0.00 0.00 - 01.572.771000 PRINCIPAL 267.00 266.86 267.00 01.572.772000 INTEREST 60.00 27.63 60.00 01.572.995200 NWFWMD EXPENDUTURES 0.00 0.00 - Due to new FTE Total Appropriations: 121,924.00 48,528.61 183,712.57 61,788.57 50.68% TOTAL EXPENDITURES 3,538,348.00 1,185,790.12 3,802,000.56 City of Parker 23-24 Budget - As proposed by council on 7/17/23 Fund 01 - GENERAL FUND: TOTAL REVENUES 2,765,448.00 1,364,424.06 3,616,299.30 850,851.30 TOTAL EXPENDITURES 3,538,348.00 1,185,790.12 3,802,000.56 263,652.56 NET OF REVENUES & EXPENDITURES (772,900.00) 178,633.94 (185,701.26) 587,198.74 30.77% Fund 02 - COMMUNITY REDEVELOPMENT AGENCY 7.45% DEPT 360 -75.97% GL Number Description 03/31/2023 YTD As Of 2023-24 DEPT. NOTES Amended Budget 03/31/2023 REQUESTED --- Estimated Revenue --- 02.360.361000 INTEREST 0.00 6.56 10.00 Total Estimated Revenue: 0.00 6.56 10.00 DEPT 559 COMMUNITY REDEVELOPMENT GL Number Description 03/31/2023 YTD As Of 2023-24 DEPT. NOTES Amended Budget 03/31/2023 REQUESTED --- Appropriations --- 02.559.531000 PROFESSIONAL SERVICES 2,000.00 0.00 2,000.00 02.559.531100 PROFESSIONAL SERVICES - ENGINEERING 1,000.00 0.00 1,000.00 Total Appropriations: 3,000.00 0.00 3,000.00 Fund 02 - Community Redevelopment TOTAL REVENUES 0.00 0.00 10.00 TOTAL EXPENDITURES 3,000.00 0.00 3,000.00 NET OF REVENUES & EXPENDITURES (3,000.00) 0.00 (2,990.00) Fund 41 - UTILITY FUND DEPT 340 CHARGES FOR SERVICES GL Number Description 03/31/2023 YTD As Of 2023-24 DEPT. NOTES Amended Budget 03/31/2023 REQUESTED --- Estimated Revenue --- 41.340.343300 WATER REVENUE 991,610.00 472,751.02 956,700.00 Includes 0% annual increase. Currently averaging 79,725 per month thru July. Avg 66,811 per month in PY. Total collected in py 801,734. 41.340.343366 WATER TAPS 5,800.00 5,727.00 4,475.00 Estimating 5 at $895 each 41.340.343500 SEWER REVENUE 1,589,074.00 886,245.99 1,805,520.00 Currently averaging 150,460 per month thru July. Includes 0% increase 41.340.343610 ACCOUNT SET UP FEES-WATER 3,250.00 2,275.00 4,500.00 Avg $375 per month in CY 41.340.343611 ACCOUNT SET UP FEES-SEWER 3,250.00 2,275.00 4,500.00 Avg $375 per month in CY 41.340.343620 RECONNECT FEES-WATER 20,000.00 19,045.00 39,120.00 Avg $3260 per month in CY and PY 41.340.343670 SEWER TAPS 5,000.00 1,500.00 2,500.00 Estimating 5 at $500 each 41.340.343680 PENALTIES-WATER 19,553.00 12,275.72 23,616.00 Avg $5,750 per month thru May 35% to Water. Collected 22,656 in py 41.340.343681 PENALTIES-SEWER 36,313.00 23,580.52 45,384.00 Avg $5,750 per month thru May 65% to Sewer. Collected 41,861 in PY Total Estimated Revenue: 2,673,850.00 1,425,675.25 2,886,315.00 212,465.00 City of Parker 23-24 Budget - As proposed by council on 7/17/23 DEPT 350 FINES & FORFEITS GL Number Description 03/31/2023 YTD As Of 2023-24 DEPT. NOTES Amended Budget 03/31/2023 REQUESTED --- Estimated Revenue --- 41.350.355000 TAMPERING FEES-WATER 500.00 0.00 500.00 These are currently routed to reconnect fees - breaking out in beginning June 2022 41.350.356000 RETURN CHECK CHARGES-WATER 350.00 0.00 - Currently not charging - do we keep this 41.350.356001 RETURN CHECK CHARGES-SEWER 650.00 0.00 - Currently not charging - do we keep this Total Estimated Revenue: 1,500.00 0.00 500.00 (1,000.00) -66.67% DEPT 360 GL Number Description 03/31/2023 YTD As Of 2023-24 DEPT. NOTES Amended Budget 03/31/2023 REQUESTED --- Estimated Revenue --- 41.360.361000 INTEREST 0.00 573.45 1,116.00 Interest on Pooled Cash, Impact Fees 41.360.361001 INTEREST-SEWER 0.00 766.91 1,632.00 Interest on Pooled Cash, Impact Fees 41.360.363210 WATER IMPACT FEES 15,000.00 2,000.00 2,500.00 5 at $500 41.360.363230 SEWER IMPACT FEES 42,000.00 4,200.00 7,000.00 5 at $1400 41.360.331100 FEDERAL GRANTS 388,419.00 0.00 509,969.00 CDBGR Man hole lining Total Estimated Revenue: 445,419.00 7,540.36 522,217.00 76,798.00 17.24% TOTAL REVENUES 3,120,769.00 1,433,215.61 3,409,032.00 288,263.00 9.24% City of Parker 23-24 Budget - As proposed by council on 7/17/23 DEPT 533 WATER DEPARTMENT GL Number Description 22/23 Amended YTD As Of 2023-24 DEPT. NOTES Budget 03/31/2023 REQUESTED --- Appropriations --- 41.533.512000 REGULAR SALARIES 132,984.00 62,184.87 144,127.51 Includes 4500 of on call pay 41.533.512100 REGULAR ON CALL PAY 4,500.00 0.00 - now in salaries 41.533.514000 OVERTIME 1,773.00 648.50 1,888.03 41.533.515000 SPECIAL PAY 0.00 0.00 - 41.533.516000 Non Cash Compensation 400.00 140.00 245.00 41.533.521000 FICA TAXES 10,309.00 4,674.20 10,825.94 41.533.522000 RETIREMENT CONTRIBUTIONS 16,050.00 7,483.68 19,203.66 41.533.523000 HEALTH INSURANCE 30,305.00 3,081.45 33,941.64 41.533.523025 VISION INSURANCE 0.00 0.00 - 41.533.523050 LIFE INSURANCE 204.00 88.31 204.10 41.533.523075 DENTAL INSURANCE 1,310.00 146.17 1,310.22 41.533.523900 POST EMPLOYMENT RETIREE BENEFITS 0.00 0.00 - 41.533.524000 WORKERS COMPENSATION 2,528.00 1,192.64 2,653.77 41.533.529000 MAYOR & COUNCIL STIPEND 4,620.00 2,310.00 4,620.00 50% of Stipend is allocated 35% to Water Dept 41.533.531000 PROFESSIONAL SERVICES 139.00 138.95 - 41.533.531100 PROFESSIONAL SERVICES - ENGINEERING 10,000.00 0.00 10,000.00 41.533.531200 PROFESSIONAL SERVICES - LEGAL 6,250.00 1,410.58 6,250.00 Easements related to SRF 41.533.532100 ACCOUNTING & AUDITING 0.00 627.03 - 41.533.534100 OTHER CONTRACTUAL SERVICES 16,750.00 12,965.23 16,750.00 41.533.534110 FILING FEES 0.00 0.00 - 41.533.534310 COST OF WATER 218,414.00 98,529.60 238,492.38 Avg 19295 per month + 3% increase 41.533.540000 TRAVEL & PER DIEM 5,145.00 0.00 5,000.00 For conferences if needed 41.533.541000 COMMUNICATIONS 5,588.00 2,569.45 5,500.00 $2,072 for 2.28 - 800 Mhz radios and Fiberoptic $195 per month, Verizon $25 per month & Flux 35% of 180 41.533.541100 POSTAGE & FREIGHT 3,480.00 890.94 3,480.00 41.533.543000 UTILITIES 2,400.00 1,195.31 2,400.00 41.533.544000 RENTAL & LEASES 1,545.00 426.82 1,545.00 Copiers and Air Gas 41.533.545000 INSURANCE 9,181.00 5,138.96 15,451.56 35% of auto insurance 9997 = 3500, 35% of Building & Contents 11953 41.533.546100 R&M - BUILDINGS & GROUNDS 1,750.00 454.02 2,000.00 41.533.546200 R&M - MACHINERY & EQUIPMENT 5,000.00 2,166.27 5,000.00 41.533.546300 R&M - VEHICLES 5,000.00 1,965.29 5,000.00 41.533.546400 R&M - SYSTEM 34,000.00 20,910.36 35,000.00 41.533.547000 PRINTING & BINDING 1,057.00 0.00 1,150.00 41.533.548000 EVENTS/COMMUNITY OUTREACH 0.00 0.00 - 41.533.549000 OTHER CURRENT CHARGES 12.00 12.00 100.00 41.533.551000 OFFICE SUPPLIES 1,562.00 345.29 1,560.00 41.533.551500 SMALL TOOLS 2,000.00 258.34 2,000.00 41.533.552000 OPERATING SUPPLIES 3,500.00 834.63 3,500.00 41.533.552100 FUEL & LUBRICANTS 8,000.00 3,847.76 8,500.00 41.533.552200 UNIFORMS 1,400.00 209.99 1,400.00 41.533.553000 ROAD MATERIALS & SUPPLIES 4,000.00 154.95 6,000.00 41.533.554100 BOOKS, PUBLICATIONS 70.00 0.00 70.00 41.533.554200 MEMBERSHIPS 1,100.00 265.30 1,100.00 41.533.554300 SOFTWARE/HARDWARE 3,552.00 371.10 3,550.00 City of Parker 23-24 Budget - As proposed by council on 7/17/23 41.533.554400 TRAINING 1,575.00 313.13 1,575.00 41.533.559000 DEPRECIATION 0.00 0.00 - 41.533.662000 BUILDINGS 0.00 0.00 - 41.533.663000 IMPROVEMENTS OTHER THAN BUILDINGS 3,000.00 0.00 3,000.00 41.533.663100 WATER SYSTEM IMPROVEMENTS 156,398.00 50,146.88 100,000.00 41.533.664000 MACHINERY & EQUIPMENT 5,000.00 4,262.47 5,000.00 41.533.771000 PRINCIPAL 610.00 608.44 610.00 41.533.772000 INTEREST 130.00 63.00 130.00 41.533.780000 LOSS ON DISPOSITION OF ASSETS 0.00 0.00 - Total Appropriations: 722,591.00 293,031.91 710,133.78 (12,457.22) -1.72% City of Parker 23-24 Budget - As proposed by council on 7/17/23 DEPT 535 SEWER DEPARTMENT GL Number Description 22-23 Amended YTD As Of 2023-24 DEPT. NOTES Budget 03/31/2023 REQUESTED --- Appropriations --- 41.535.512000 REGULAR SALARIES 241,759.00 112,974.48 260,856.01 Includes 6,500 of on call pay 41.535.512100 REGULAR ON CALL PAY 6,500.00 0.00 - now in salaries 41.535.514000 OVERTIME 3,248.00 1,204.38 3,464.20 41.535.515000 SPECIAL PAY 0.00 0.00 - 41.535.516000 Non Cash Compensation 575.00 260.00 455.00 41.535.521000 FICA TAXES 18,743.00 8,489.96 19,723.24 41.535.522000 RETIREMENT CONTRIBUTIONS 29,180.00 13,598.64 34,986.20 41.535.523000 HEALTH INSURANCE 55,114.00 5,595.63 61,727.80 41.535.523025 VISION INSURANCE 0.00 0.00 - 41.535.523050 LIFE INSURANCE 371.00 160.72 371.18 41.535.523075 DENTAL INSURANCE 2,383.00 265.58 2,382.82 41.535.523900 POST EMPLOYMENT RETIREE BENEFITS 0.00 0.00 - 41.535.524000 WORKERS COMPENSATION 4,659.00 1,590.18 4,892.48 41.535.529000 MAYOR & COUNCIL STIPEND 8,580.00 4,290.00 8,580.00 50% of Stipend is allocated 65% to Sewer Dept 41.535.531000 PROFESSIONAL SERVICES 253.00 252.71 - 41.535.531100 PROFESSIONAL SERVICES - ENGINEERING 0.00 0.00 - 41.535.531200 PROFESSIONAL SERVICES - LEGAL 6,250.00 2,619.64 6,250.00 41.535.532100 ACCOUNTING & AUDITING 16,160.00 1,164.47 16,160.00 41.535.534100 OTHER CONTRACTUAL SERVICES 33,300.00 18,399.02 33,300.00 41.535.534110 FILING FEES 0.00 0.00 - 41.535.534330 COST OF SEWER 343,717.00 99,000.82 283,502.55 Paid to Bay County Commission, MPAWTF based on gallons used. 3.34 per gallon. CY cost estimated 262,973 + 8% increase. Cost of sewer has decreased due to repairs made to keep stormwater out of system. Billed for 1 Million gallons less sewer in March and April 2023 than in Mar & April 2022 41.535.540000 TRAVEL & PER DIEM 9,555.00 0.00 9,000.00 41.535.541000 COMMUNICATIONS 7,248.00 3,222.22 7,250.00 4.22 - 800 Mhz radios and phone service 41.535.541100 POSTAGE & FREIGHT 6,365.00 1,654.56 6,365.00 41.535.543000 UTILITIES 21,700.00 15,267.91 21,700.00 41.535.544000 RENTAL & LEASES 2,900.00 792.60 2,900.00 41.535.545000 INSURANCE 21,168.00 9,543.79 21,168.00 65% of auto insurance 9997. Lift Station 4118, Building and Contents 6329, PITO property 4223 41.535.546100 R&M - BUILDINGS & GROUNDS 3,250.00 843.15 3,250.00 41.535.546200 R&M - MACHINERY & EQUIPMENT 8,000.00 4,305.78 8,000.00 41.535.546300 R&M - VEHICLES 6,500.00 3,759.71 6,500.00 41.535.546400 R&M - SYSTEM 17,000.00 6,848.97 17,000.00 41.535.546500 LIFT STATION MAINTENANCE 90,000.00 48,287.15 90,000.00 $5,968 per month Paid to Bay County Commission, MPAWTF $71,616 plus repairs if needed 41.535.547000 PRINTING & BINDING 1,963.00 0.00 1,900.00 41.535.548000 EVENTS/COMMUNITY OUTREACH 0.00 0.00 - 41.535.549000 OTHER CURRENT CHARGES 1,000.00 870.13 1,000.00 41.535.551000 OFFICE SUPPLIES 2,823.00 641.23 3,000.00 41.535.551500 SMALL TOOLS 5,000.00 479.82 5,000.00 41.535.552000 OPERATING SUPPLIES 6,000.00 1,311.13 6,000.00 41.535.552100 FUEL & LUBRICANTS 15,000.00 7,145.69 16,000.00 41.535.552200 UNIFORMS 2,600.00 389.76 2,600.00 City of Parker 23-24 Budget - As proposed by council on 7/17/23 41.535.553000 ROAD MATERIALS & SUPPLIES 4,000.00 287.75 4,000.00 41.535.554100 BOOKS, PUBLICATIONS 130.00 0.00 130.00 41.535.554200 MEMBERSHIPS 568.00 492.70 600.00 41.535.554300 SOFTWARE/HARDWARE 6,599.00 689.18 6,600.00 BS&A Subscription, Monthly Diamond maps subscription 41.535.554400 TRAINING 2,925.00 24.37 2,500.00 41.535.559000 DEPRECIATION 0.00 0.00 - 41.535.662000 BUILDINGS 0.00 0.00 - 41.535.663000 IMPROVEMENTS OTHER THAN BUILDINGS 439,419.00 5,072.61 561,969.00 52,000 + remaining of CDBGR Grant for man hole linings $509,969 41.535.664000 MACHINERY & EQUIPMENT 4,000.00 3,273.15 4,000.00 41.535.665000 CONSTRUCTION IN PROGRESS 0.00 0.00 - 41.535.771000 PRINCIPAL 1,126.00 1,126.15 1,126.00 41.535.771100 DEBT SERVICE PRINCIPAL 1,030.00 0.00 1,030.00 41.535.772000 INTEREST 230.00 116.81 230.00 41.535.773100 AWT DEBT SERVICE 151,400.00 63,115.40 151,488.00 Monthly Joint Venture 12,624 41.535.773200 AWT RENEWAL & REPLACEMENT COMPONENT 34,983.00 14,576.25 34,983.00 Monthly Joint Venture 2,915.25 41.535.773300 AWT RATE RESERVE COMPONENT 22,710.00 9,467.31 22,721.52 Monthly Joint Venture 1,893.46 41.535.773400 BOND RESERVE REQUIREMENT 0.00 0.00 - 41.535.774500 LOSS FROM JOINT VENTURE 0.00 0.00 - Total Appropriations: 1,667,984.00 473,471.51 1,756,662.01 88,678.01 5.32% TOTAL EXPENDITURES 2,390,575.00 766,503.42 2,466,795.79 76,220.79 3.19% Fund 41 - UTILITY FUND: TOTAL REVENUES 3,120,769.00 1,433,215.61 3,409,032.00 288,263.00 TOTAL EXPENDITURES 2,390,575.00 766,503.42 2,466,795.79 76,220.79 NET OF REVENUES & EXPENDITURES 730,194.00 666,712.19 942,236.21 212,042.21 9.24% 3.19% ESTIMATED REVENUES - All FUNDS 7,025,341.30 29.04% APPROPRIATIONS - All FUNDS 6,271,796.35 NET OF REVENUES/APPROPRIATIONS - All FUNDS 753,544.95 Utility reserve carryover to 2024/2025 for capital improvement projects 753,544.95 NET OF REVENUES/APPROPRIATIONS - All FUNDS After transfer to utility reserve 0.00