2022 Preliminary Budget General Fund Revenues Acct No. 301 30110 30120 Real Estate Tax Real Estate - Current Real Estate Prior Total- Real Estate Local Enabling Tax Real Estate Transfer Earned Income - Current Total- Local Enabling' Tax Amusement/Admissions Tax Amusement/Golf Course Total-Amusement Tax Local Services Tax Local Services Tax Total-Local Services Tax Licenses & Permits Transient Retailers Cable TVI Franchise Total-Licenses & Permits Non-Business License/Permit Driveway Permits Total Non Business Lic/Permit 1,050,000.00 10,000.00 1,060,000.00 135,000.00 660,000.00 795,000.00 10,000.00 10,000.00 45,000.00 45,000.00 100.00 104,000.00 104,100.00 100.00 100.00 310 31010 31021 31060 31061 31080 31081 320 32161 32180 322 32230 331 33111 33112 Fines Vehicle Code -Violations Violations of Ordinances Total-Fines Interest Earnings Interest Total-Interest 6,000.00 3,000.00 9,000.00 400.00 400.00 341 34100 2022 Preliminary Budget General Fund Revenues 350 35010 Intergovernmenta Revenues ARP Funds Total- - Intergov. Revenues State Shared Revenues Property Taxes (PUC) Alcoholic Beverages Taxes Foreign Fire Insurance State Payments in Lieu of Tax Total-S State Shared Revenues Local Government Units County Liquid Fuel Grant Lebanon County Drug Task Force Total-Local Gov't Units General Government Subdivision Fees Reimbursement Municipal Auth Total- - General Government Public Safety West Cornwall Police Services Mt Gretna Police Services O/T or Special Event Poliçe Checkpoint Reimbursement Accident Reports Reimbursement- Brett- - DEA Total - Public Safety Miscellaneous Revenues Miscellaneous Revenues Insurance Dividend Total. Misc. Revenues Contributions & Donations Contributions & Donations Total-C Contributions 229,016.24 229,016.24 2,300.00 1,000.00 26,000.00 800.00 30,100.00 4,112.00 5,000.00 9,112.00 15,000.00 21,000.00 36,000.00 180,023.00 39,891.00 4,000.00 500.00 1,000.00 5,000.00 230,414.00 5,000.00 5,000.00 10,000.00 93,000.00 93,000.00 355 35501 35508 35513 35600 357 35703 35902 361 36133 36180 362 36201 36202 36203 36210 36211 36247 380 38000 38010 387 38700 2022 Preliminary Budget General Fund Revenues 279 27944 Unreserved Fund Balance Cash Reserves Total-Unres. Fund Balance Total-R Revenues 108,441.90 108,441.90 2,769,284.14 2022 Preliminary Budget General Fund Expenditures Acct No. 400 40014 40018 400_20 40032 40034 40035 40036 40037 400_373 400390 40040 General Government Salary of Manager Salary Admin. Asst. Supplies Communication Expense Advertising & Printing Insurance Public Utility Maintenance & Repairs Buildings Bank Charges Computer Equipment Total- General Government Executive Salary of Mayor Total- - Executive Financial Administration Audit Total- Financial Admin. Tax Collection Supplies Keystone Fees Total. - Tax Collection Law Salary- Solicitor Total. - Law Engineer Salary Engineer Engineering - MS4 Storm Sewer Total - Engineer Public Safety Salary- Chief Salary - Sergeant Patrolman 66,000.00 34,811.92 10,000.00 5,000.00 2,500.00 62,540.00 5,000.00 15,000.00 45,000.00 1,000.00 1,000.00 247,851.92 180.00 180.00 10,700.00 10,700.00 2,900.00 10,200.00 13,100.00 16,500.00 16,500.00 45,000.00 20,000.00 65,000.00 110,000.00 87,980.71 458,000.00 401 40111 402 40231 403 40320 40340 404 40413 408 4081 13 4081 14 410 4101 120 410 123 410 130 2022 Preliminary Budget General Fund Expenditures 410 140 410210 410212 410213 410231 410238 4102 240 410241 410260 410261 410316 410321 410327 410329 410361 410362 410366 410367 410374 410375 410376 410377 410440 410452 Secretary Supplies - Office Forms Office Small Office Equipment Vehicle Fuel Uniform Supplies Other Operating Supplies Ammunition Supplies Minor Equipment Purchase Major Equipment Purchase Training/Education Telephone Radio Equipment Maintenance Radio Dispatch Comm. Fee Electricity UGI Gas Water & Sewer Refuse Removal Repairs/Maint. Equipment Vehicle Maintenance Vences/resAignmen: Other' Vehicle Expense Laundry IT/RMS Services Total-F Public Safety Fire Fire Company Contributions Foreign Fire Insurance Workmens Comp Cancer Personal TrainingEquipment Machinery and Equipment Total-Fire Ambulance Contribution Total-Ambulance 38,480.00 500.00 250.00 2,000.00 15,000.00 2,000.00 600.00 1,000.00 5,000.00 47,000.00 500.00 4,000.00 1,000.00 2,900.00 3,500.00 3,000.00 750.00 2,000.00 600.00 5,000.00 1,000.00 1,500.00 500.00 10,000.00 804,060.71 19,000.00 26,000.00 12,000.00 12,000.00 29,537.11 98,537.11 20,560.00 20,560.00 411 41150 41151 41152 41154 41174 412 41254 430 43012 43018 43020 43023 Public' Works Highway Salary Foreman Salaries & Wages Supplies Fuel, Light & Water 73,694.40 162,000.00 15,000.00 15,000.00 2022 Preliminary Budget General Fund Expenditures 43032 43037 43072 Communications Maintenance & Repairs Improvements Other than Land Total Public Works Street Signs & Markings Supplies Total-S Street Signs Street Lighting Street Lighting Total-L Lighting Storm Sewers Supplies Total- - Storm Sewers Highways & Bridges Supples/Construction Snitz Creek- Realignment Total- Hwys & Bridges Recreation Supplies Total- Recreation Libraries Contributions Total-Libraries Misc Expenditures & Expenses Miscellaneous Total - Miscellaneous Pension Contributions Pension Contributions Total. - Pension Contrib. 2,500.00 15,000.00 33,000.00 316,194.40 433 43320 15,000.00 15,000.00 40,000.00 40,000.00 5,000.00 5,000.00 100,000.00 50,000.00 150,000.00 8,000.00 8,000.00 3,000.00 3,000.00 10,000.00 10,000.00 160,000.00 160,000.00 434 43436 436 43620 438 43820 438211 452 45220 456 45650 471 48000 483 48300 2022 Preliminary Budget General Fund Expenditures 485 48500 UIC Fund Contributions Unemp. Comp. Fund Total - U/C Fund FICA Contributions FICA Medicare Total-FICAMedicare Hospital & Med Insurance Hospital & Med Insurance Total Insurance Interfund Operating Tran Tran. To Capital Reserve Transfer to Equipment Fnd. E.I.T. Loan Payoff Transfer to HRA Total- Interfund Tran. Total- Expenditures 6,000.00 6,000.00 80,000.00 80,000.00 321,000.00 321,000.00 100,000.00 60,000.00 194,000.00 25,000.00 379,000.00 2,769,684.14 487 48700 48701 488 48800 492 49230 49243 49244 49245 2022 Preliminary Budget Motor License Fund Current Cash Balance 37,719.51 Acct No. 34100 35502 38000 Revenues Interest Liquid Fuels Miscellaneous Total Revenues Total-F Revenues & Cash Expenditures Equipment Purchase Snow & Ice Removal Highway Construction Total Expenditures 50.00 171,485.67 1,377.00 172,912.67 210,632.18 27,518.64 30,000.00 150,000.00 207,518.64 43074 43200 43900 2022 Preliminary Budget Capital Reserve Fund CASH BALANCE Revenues Interest Deposit TF General Fund Total-F Revenues 209,319.14 Acct No. 34100 100.00 200,000.00 100,000.00 300,100.00 509,419.14 Total Revenues & Cash on Hand 2022 Preliminary Budget Recreation Fund Cash Balance Revenues Subdivision Recreation Fee Total - Revenues Total- - Cash on Hand Expenditures Rails to Trails Donation Total- - Expenditures Balance - End of Period 107,402.96 15,000.00 15,000.00 122,402.96 5,000.00 5,000.00 117,402.96 Acct. No. 36156 48000 2022 Preliminary Budget Highway Equipment Fund CASH BALANCE Revenues TF General Fund Total-F Revenues Total- Cash on Hand Expenditures Truck Payment Total-E Expenditures Balance End of Period 101,027.98 60,000.00 60,000.00 161,027.98 53,336.60 53,336.60 107,691.38 Acct No. 39200 430261 WATER FUND 2022 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 TREATMENTIDIST. 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 0 0 674,221 14,514 1,325 2,700 0 249,927 942,687 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 45,105 6,972 3,800 5,030 350 4,877 5,000 10,000 33,062 7,136 9,693 212,520 343,545 77,702 2,225 5,150 22,000 1,500 5,675 410,000 240 2,000 22,000 50,650 599,142 942,687 942,687 448.100 448.200 448.260 448.270 448.280 448.310 448.315 448.320 448.330 448.360 448.370 UTILITIES Water Capital Projects Fund Budget (2022) Acct No. Classification CASH BALANCE Dedicated Investments Sinkhole Fund Vehicle Fund Meter Replacement Fund Misc. Valves, Hydrants, Etc Main Replacement Long Term Capital Reserves R-O-W Clearing Cash Balance less Dedicated Request 1,730,200.00 15,000.00 10,000.00 90,000.00 45,000.00 650,000.00 150,000.00 5,000.00 965,000.00 765,200.00 1,000.00 122,500.00 87,320.00 2,700.00 213,520.00 1,943,720.00 41,363.00 0.00 50,000.00 3,000.00 55,000.00 688.80 30,000.00 25,000.00 210,000.00 30,000.00 2,000.00 447,051.80 1,496,668.20 531,668.20 Receipts Interest TF Tapping Fees TF Fees Collected Transfer from Revenues Total - Receipts Total - Cash on Hand Expenditures USC -1 Tank Contract Misc. Valves, Hydrants, Etc Replace Hydrants Replace Large Meters Meter Replacement Mower Pump Station MCC Panels Chlorine Consulting Chlorination System Garage/Shed Rulers Total - Expenditures Balance End of Period Balance - Less Dedicated (year 3 of3) (year 3 of5) (year 4 of5 5) SEWER FUND 2022 BUDGET REVENUES 340.010 INTEREST 361.300 PLAN REVIEW FEES 364.000 HAULER REGISTRATION 364.010 OLDS RESIDENTIAL FEES 364.100 SEWER RENTS 364.120 SEWER PERMIT FEES 364.310 W.CORN.TRANS CHG 380.000 MISCELLANEOUS 390.000 CAPITAL FEES COLLECTED 392.000 TAPPING FEES COLLECTED 0 0 850 4,320 749,606 875 4,000 0 87,640 73,500 920,791 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 492.000 TRANSFERS TO CAPITAL 429.100 EMPLOYEE FEES - BOROUGH 429.200 MATERIAL & SUPPLIES 429.260 EQUIPMENT 429.270 METERS 45,105 6,972 3,800 880 350 5,017 0 7,500 10,000 33,062 7,136 9,693 0 174,390 303,905 77,702 1,650 2,950 7,500 7,500 225 2,000 625 11,678 1,000 475,000 29,056 616,886 920,791 920,791 0 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 11/2/2021 Sewer Capital Projects Fund Budget (2022) Acct No. Classification Reguest 1,776,200.00 15,000.00 10,000.00 90,000.00 600,000.00 20,000.00 30,000.00 150,000.00 5,000.00 920,000.00 1,026,200.00 1,000.00 73,500.00 87,640.00 13,250.00 175,390.00 1,951,590.00 37,500.00 3,000.00 30,000.00 100,000.00 55,000.00 688.80 0.00 226,188.80 1,725,401.20 805,401.20 CASH BALANCE Dedicated Investments Sinkhole Fund Vehicle Fund Meter Replacement Fund N. Cornwall (Dairy Road) Update. Act 537 Plan Main ReparyReplacemens Long Term Capital Reserves R-O-W/Clearing Cash Balance less Dedicated Receipts Interest TF Tapping Fees TF Fees Collected Transfer from Revenues Total - Receipts Total - Cash on Hand Expenditures I&ISewer Mains & Repairs Replace Large Meters Garage/Shed N. Cornwall Sewer Project Meter Replacement Mower Miscellaneous Total-E Expenditures Balance - End of Period Balance - Less Dedicated (year 3 of3) (year 3 of5) (year 4 of5) Cornwall Boro Page 1 10/25/2021