2023 Preliminary Budget General Fund Revenues 301 - Real Estate' Tax 301.10 Real Estate Current - 301.20. Real Estate Prior- Total - Real Estate- 1,100,000 10.000 1,110,000 310-Local Enabling Tax 310.10 Real Estate Transfer- 150,000 930,000 310.210 Earned Income - Current- = 780,000 Total -1 Enabling Tax- 310.60. - AmuementAdmissions Tax 310.61 - Amusemen/SoirCoure - 12,000 Total - Amusement Tax- 12,000 310.80-Local Services Tax 310.81-Local Services Tax - 45.000 Total -1 Local Services Tax- - 45,000 320-Licenses & Permits 321.61 - Transient Retailers- - 321.80 - Cable TV Franchise- 50 110.000 Total-Licenses & Permits - 110,050 322-Non-Business License/Permit 322.30-Driveway Permits - Total-Driveway Permits- - 100 100 2023 Preliminary Budget General Fund Revenues 331-Fines 331.11- - Vehicle Code Violations- 6,000 331.12-Violations of Ordinance- 4.000 Total 1-Fines 10,000 341-Interest Earnings 341.00 -Interest Total - Interest 5.000 5,000 355-State Shared Revenues 355.01 - Property Taxes (PUC)-2,000 355.08 - Alcoholic Beverages Taxes-1 1,000 355.13-Foreign Fire Insurance- -3 33,000 355.44-C Other State Payments - 10,000 356.00 - State Payments in Lieu of' Tax - 800 Total - State Shared Revenues-4 46,800 357-Local Government Units 357.03-( County Liquid Fuel Grant-4,112 359.02-Lebanon County DTF-5.000 Total-Local Govemnment Units-9 9,112 361-C General Government 361.33-Z Zoning and Subdivision Fees-25,000 361.80-Remburement from Water and Sewer-1 16.000 Total - General Government t-41,000 2023 Preliminary Budget General Fund Revenues 362-Public Safety 362.01 - West Cornwall Police Services-1 194,424 362.02- -Mt. Gretna Police Services-43,082 362.03- - OT or Special Event Police-4 4,000 362.10-( Checkpoint Reimbursement - 1,500 362.11 - Accident Reports - 1,000 36247-Reimburemen, Hoplins-DEA-.000 Total - Public Safety - 249,006 380- -Miscellaneous Revenue 380.00 Miscellaneous Revenue- - 5,000 380.10- - Insurance Dividend-7,000 Total - Miscellaneous Revenue- - 12,000 387- Contributions and Donations 387,00-Contributions and Donations - 93.000 Total - Contributions and Donations - 93,000 279-Unreserved Fund Balance 279.44-C Cash Reserves - 431.994.05 Total- Unreserved Fund Balance-431,994.05 Total-Revenues-3,105,062.05 2023 Preliminary Budget General Fund Expenditures 400-General Government 400.14- Salary of Manager 75,900 400.18-S Salary of Admin. Asst.-21,500 400.20 - Supplies -1 12,000 40032-Commun-cation Expense - 5,000 400.34 - Advertising & Printing -2,500 400.35- - Insurance- - 75,000 400.36-Public Utility - 5,000 40037-Maintenance & Repairs - 20,000 400.373 - Buildings- - 70,000 400.390 - Bank Charges-850 400.40 - Computer Equipment - 5.000 Total - General Government-: 292,750 401-Executive 401.11 Salary of] Mayor - 180 Total - Executive - 180 402-F Financial Administration 402.31-Audit-1 11,100 Total - Financial Administmation-1l,00 2023 Preliminary Budget General Fund Expenditures 403-7 Tax Collection 403.20 - Supplies -2 2,000 403.40 = Keystone Fees - 11.000 Total - Tax Collection- - 13,000 404-Law 404.31 - Other Professional Services -25,000 Total-Law-25,000 408-E Engineer 408.14-1 Enghnering-MS-1000 408.31 - Other Professional Services- 55.000 Total - Engineer - 65,000 410-Public Safety 410.120- Salary - Chief-113,300 410.123 - Salary - Sergeant - 91,499.94 410.130 - Patrol Officers - 562,400 410.140- Secretary -4 41,175 410.210 - Supplies- Office-500 410.212-1 Forms- - Office-250 410.213 - Small Office Equipment - 2,000 410.231 - Vehicle Fuel-25,000 410.238 - Uniform Supplies-2 2,000 410.240 - Other Operating Supplies - 500 410.241 - Ammunition Supplies-1,000 2023 Preliminary Budget General Fund Expenditures 410.260- -N Minor Equipment Purchase- - 10,000 410.261 - Major Equipment Purchase - 55,000 410.316-Training and Education-1 1,000 410.320-Communications-500 410.321 - Telephone 4,000 410.327 - Radio Equipment Maintenance-1,000 410.329 - Radio Dispatch Comm. Fee-3,000 410.361 - Electricity - 3,500 410362-UdIGHs-3000 410.366 - Water & Sewer-950 410.367 - Refuse Removal-2,000 410.374- - Repars/Maintenance Equipment -1 1,300 410.375- - Vehicle Maintenance - 6,500 410376-VahideTirsAligmmem-1,000 410.377-1 Other Vehicle Expense -1 1,500 410.440-Laundry - 500 410.452-IT/RMS Services-1 10,000 Total-Public Safety 7- 944,374.94 411-Fire 411.50- Fire Company Contributions-: 25,000 411.51-1 Foreign Fire Insurance-33,000 411.52- Workmen's Compensation - 13,500 411.54-1 Training & Equipment - 12,000 411.74-N Machinery & Equipment - 29.537.11 Total-Fire-113,097.11 2023 Preliminary Budget General Fund Expenditures 412- Ambulance 412.54-C Contribution -23.020 Total - Ambulance- - 23,020 422-Health and Human Services 422.31 -A Animal Control-1 1.500 Total - Health and Human Services-1,500 430-Public Works - Highway 430.12-Salary - Foreman- 83,600 430.18-Salaries & Wages-221,000 430.20 = Supplies - 20,000 430.23 - Fuel, Light & Water-25,000 430.32-C Commumnicaions-2500 43037-Maintenance & Repairs - 15,000 430,72-Improvements Other than Land - 30.000 Total - Public Works - Highway - 397,100 433-S Street Signs & Markings 433.20 - Supplies - - 25,000 Total - Street Signs & Markings-25,000 434- Street Lighting 434.36-S Street Lighting -5 40,000 Total - Street Lighting-4 40,000 2023 Preliminary Budget General Fund Expenditures 436-Storm Sewers 49620-Supplies-2000 Total-S Storm Sewers-7,000 438 - Highways & Bridges 438.20- Supplies & Construction- - 150.000 Total -H Highways & Bridges-150,000 452-Recreation 452.20- Supplies - 6,000 Total -] Recreation- 6,000 456-Libraries 45650-Contributions - 4.000 Total-Libmaies-4000 471-Miseelaneous Expenditures and Expenses 480.00-M Miscellaneous - 10,000 Total -Miscellaneous Expenditures and Expenses-1 10,000 483-Pension Contributions 483.00- - Pension Contributions- - 150,000 Total - Pension Contributions - 150,000 2023 Preliminary Budget General Fund Expenditures 485-U/C: Fund Contributions 485.00-Unemployment Compensation Fund - 7,000 Total - U/C Fund Contributions-7,00 487-FICA Contributions 487.00-FICA-80.000 Total - FICA Contributions-8 80,000 488-Hospital & Medical Insurance 488.00-1 Hospital & Medical Insurance-353.500 Total -) Hospital & Medical Insurance-353,500 492-Interfund Operating Transfer 492.30- Transfer to Capital Reserve. - 100,000 492.43 - Transfer tol Equipment Fund-6 60,000 492.44-1 EIT Loan Payoff-194,000 492.45 - Transfer to HRA-25,000 492.47 - Transfer to Recreation-7 7.500 Total - Interfund Operation Transfer-3 386,500 Total Expenditures S- 3,105,062.05 2023 Preliminary Budget Motor License Current Balance-19,436.32 Revenues 341.00-Interest-700 355.02-Liquid Fuels-1 184,032.13 0Q-Miselamo-137 Total-F Revenues-1 186,109.13 Expenditures 430.74-1 Equipment Purchase- - 27,518.64 432.00- - Snow & Ice Removal -2 20,000 439.00-Highway Construction- - 100.000 Total - Epemdnurs-147/31844 2023 Preliminary Budget Capital Reserve Current Balance-764,156.64 106.100-D Deposit-75,731.28 341.00. - Interest - 5,000 Revenues 392.00 - Transfer from General Fund - 100.000 Total-Revenues-180,731.28 Expenditures 492.01 - Transfer to General Fund - 300.000 Total - Expenditures- -300,000 2023 Preliminary Budget Recreation Current Balance-95,214.35 Revenues 341.00-Interest-500 361.56-F Recreation Fee - 20,000 392.01 -Transfer from General Fund-7.500 Total-F Revenues- - 28,000 Expenditures 480.00-N Master Plan - 59.612.50 Total - Ependitures-59.61250 2023 Preliminary Budget Highway Equipment Current Balanee-107,868.64 Revenues 392.00 - Transfer from General Fund - 60,000 Total -H Revenues-60,000 Expenditures 430.261 - Truck Payments - 73.336.60 Total - Bxpenditures-73,36.60 WATER FUND 2023 BUDGET REVENUES INTEREST PLAN REVIEW FEES WATER RENTS METERS PERMIT APPLICATION OTHER WATER REVENUES MISCELLANEOUS CAPITAL TRANSFER TOTAL WATER REVENUES ADMINISTRATION PROFESSIONAL SERVICE CHARGES SALARIES & WAGES SECRETARIAL FEES - BOROUGH MATERIALS & SUPPLIES GENERAL EXPENSE COMMUNICATION EXPENSE MAINTENANCE & REPAIRS SOLICITOR ENGINEERING EXPENSE HOSPITAL & MEDICAL INSURANCE PENSION FICA TRANSFERS TOTAL ADMINISTRATION WATER IREATMENT/DIST: EMPLOYEE FEES - BOROUGH MATERIAL & SUPPLIES EQUIPMENT METERS TRAINING WATER PURIFICATION CITY WATER PURCHASE COMMUNICATION EXPENSE VEHICLE OPERATING EXPENSE MAINTENANCE & REPAIRS TOTAL-WATER COST TOTAL REVENUE TOTAL EXPENSE YEAR END SURPLUS 340.010 361.300 378.100 378.120 378.130 378.900 380.000 395.000 500 0 814,521 14,514 875 2,700 0 211,500 1,044,610 400.310 401.000 401.100 401.200 401.300 401.320 401.370 404.000 408.000 487.000 487.100 488.150 492.000 0 47,133 20,628 3,700 4,880 270 5,917 15,000 20,000 52,672 8,520 12,388 214,200 405,308 104,927 1,825 2,400 22,000 1,000 5,375 425,000 525 5,000 20,000 51,250 639,302 1,044,610 1,044,610 448.100 448.200 448.260 448.270 448.280 448.310 448.315 448.320 448.330 448.360 448.370 UTILITIES 0 Water Capital Projects Fund Budget (2023) Acct No. Classification CASH BALANCE Dedicated Investments Sinkhole Fund Vehicle Fund Meter Replacement Fund Misc. Valves, Hydrants, Etc Main Replacement Long Term Capital Reserves Open Pit Project R-0-WClearing Request 1,950,469.70 15,000.00 12,250.00 90,000.00 45,000.00 650,000.00 400,000.00 50,000.00 5,000.00 1,267,250.00 683,219.70 22,000.00 122,500.00 89,000.00 100,000.00 2,700.00 336,200.00 2,286,669.70 41,698.48 0.00 10,000.00 1,500.00 55,000.00 688.80 0.00 15,000.00 210,000.00 0.00 150,000.00 3,100.00 30,000.00 20,000.00 15,000.00 2,000.00 553,987.28 1,732,682.42 465,432.42 Cash Balance less Dedicated Receipts Interest TF Tapping Fees TF Fees Collected Transfer from Revenues Transfer from Revenues Total - Receipts Total - Cash on Hand Expenditures USC-Tank Contract Misc. Valves, Hydrants, Etc Replace Hydrants Replace Large Meters Meter Replacement Mower Pump Station MCC Panels Chlorine Consulting Chlorination System Corrosion Control Scada System Upgrade Hydrant Markers - Fire Dept Garage/Shed Vehicle Open Pit Engineer Review Rulers Total - Expenditures Balance - End of Period Balance - Less Dedicated (year 3 of3) (year 3 of5) (year 4 of5) SEWER FUND 2023 BUDGET REVENUES 340.010 INTEREST 361.300 PLAN REVIEW FEES 364.100 SEWER RENTS 364.120 SEWER PERMIT FEES 364,310 W.CORN.TRANS CHG 380.000 MISCELLANEOUS 392.500 CAPITAL FEES COLLECTED 392.000 TAPPING FEES COLLECTED 300 0 819,958 875 3,500 0 88,080 171,500 1,084,213 TOTAL SEWER REVENUE EXPENDITURES ADMINISTRATION 401.000 SALARIES & WAGES 401.100 SECRETARIAL FEES - BOROUGH 401.200 MATERIALS & SUPPLIES 401.300 GENERAL EXPENSE 401.320 COMMUNICATIONS 401.370 MAINTENANCE & REPAIRS 402.000 AUDIT 404.000 SOLICITOR 408.000 ENGINEERING EXPENSE 487.000 HOSPITAL & MEDICAL 487.100 PENSION 488.150 FICA 488.151 UNEMPLOYMENT 493.000 TRANSFERS TO CAPITAL 429.100 EMPLOYEE FEES - BOROUGH 429.200 MATERIAL & SUPPLIES 429.260 EQUIPMENT 429.270 METERS 47,133 20,628 3,700 880 260 5,737 0 15,000 7,500 52,672 8,520 12,388 0 259,580 433,998 104,972 1,450 2,475 5,000 6,000 525 5,000 500 10,150 1,000 493,500 19,643 650,215 1,084,213 1,084,213 TOTAL. ADMINISTRATION 429.310 DAIRY RD. PUMPSTATION COSTS-NC 429.320 COMMUNICATION EXPENSE 429.330 VEHICLE OPERATING EXPENSE 429.370 MAINTENANCE & REPAIRS 429.610 CITY OF LEBANON-USAGE CHARGE 429.620 N.CORNWALL-TRANS.CHARGE 429.360 UTILITIES 429.460 TRAINING TOTAL SEWER COLLECTION TOTAL REVENUES TOTAL EXPENDITURES YEAR END SURPLUS/DEFICIT 0 14/2/9009 Sewer Capital Projects Fund Budget (2023) Acct No. Classification Request 1,943,636.71 15,000.00 12,250.00 90,000.00 600,000.00 50,000.00 400,000.00 5,000.00 1,172,250.00 771,386.71 33,000.00 171,500.00 88,080.00 100,000.00 392,580.00 2,336,216.71 20,000.00 37,500.00 1,500.00 30,000.00 100,000.00 55,000.00 5,000.00 20,000.00 688.80 8,000.00 277,688.80 2,058,527.91 886,277.91 CASH BALANCE Dedicated Investments Sinkhole Fund Vehicle Fund Meter Replacement Fund N. Cornwall (Dairy Road) Main epars/epecements Long Term Capital Reserves R-O-W Clearing Cash Balance less Dedicated Receipts Interest TF Tapping Fees TF Fees Collected Transfer from Revenues Total-F Receipts Total-C Cash on Hand Expenditures 1& Sewer Mains & Repairs Replace Large Meters Garage/Shed N. Cornwall Sewer Project Meter Replacement R-O-W Clearing Vehicle Mower Kville Flow Meter Total - Expenditures Balance - End of Period Balance - Less Dedicated (year 3 of3) (year 3of5) (year 4 of5) 44/31 nnon