City Council

DANVILLE MUNICIPAL AUTHORITY - JOINT WATER AND SEWER MEETING AGENDA JULY 16, 2024 PLEASE TURN ALL CELL PHONES OFF - THANK YOU! Public Comments Approve minutes from June 18, 2024, meeting. WATER: 1. Review Water Superintendent's report - Page 1. 2. Review financial report; Reimburse Borough $163,309.83 for June 1, 2024, through June 30, 2024, pages 2-9 of the packet. 3. Review report from the Danville Borough manager-page 10 of the packet. SEWER: 1. Review financial report: Reimburse Borough $265,723.59 for June 1, 2024, through June 30, 2024-pages 11-17 of packet 2. Review sewer superintendent's report page 18 of the packet. 3. Review report from the Danville Borough Manager -page 10 of packet. Water & Sewer • Final submission for Act 537 to DEP on 3.19.24 -can take up to 4 months. a. Deficiencies need addressed by 7 .12.24 -no extension needed -2 weeks for DEP to review Adjournment  WATER DEPARTMENT REPORTJUNE 2024 PLANT FLOW • Total: 34,210,224 gal. • Average: 1,140,341 gal. • Maximum: June 13'' 1,584,159 gal. • Minimum: June S'' 823,524 gal. Water Breaks 6.4.24- Lower Mulberry St. and Ferry St.: replaced a broken ¾" service line 6.17.24- Lower Mulberry St. and Ferry St.: replaced a broken 6" valve and an 8" valve 6.27.24- Ferry St. and East Mahoning St.: Replaced a broken 6" valve OTHER • Water samples for June were all within limits. 7/9/2024 Water Page 1 of 3 3:25 PM Income Statement Actual to Budget 6/1/2024 to 6/30/2024 Jun 2024 2024 Jun 2024 Account Number Budget Actual YTDActual Balance Revenue Interest Earnings 341.100 Interest Earnings 800.00 257.91 1,336.18 536.18 Total Interest Earnings $800.00 $257.91 $1,336.18 536.18 Sanitation 364.108 State Pension 97,332.00 (97,332.00) 364.171 Administrative Fees 1,000.00 402.50 36,227.75 35,227.75 364.360 Sale of Bulk Water & Services 128,691.00 4,854.60 135,474.68 6,783.68 Total Sanitation $227,023,00 $5,257.10 $171,702.43 (55,320.57) Water System 378.110 Metered Sales 1,386,000.00 59,091.58 789,491.48 (596,508.52) 378.112 GMC· 5088 310,000.00 0.00 101,807.03 (208,192.97) 378.114 DSH • 5124 100,000.00 16,531.00 40,711.50 (59,288.50) 378.116 Suez 205,333.00 22,443.17 131,092.83 (74,240.17) 378.120 Valley Township a.a□ 11,714.75 11,714.75 Total Water System $2,001,333.00 $98,065.75 $1,074,817.59 (926,515.41) � Other Charges for Services 380.100 Miscellaneous Revenue 1,000.00 766.00 2,542.75 1,542.75 TotalOtherChargesforServices $1,000.00 $766.00 $2,542.75 1,542,75 Revenue $2,230,156.00 $104,346.76 $1,250,398.95 (979,757,05) Gross Profit $2,230,156.00 $104,346.76 $1,250;398.95 (979,757.05) Expenses Public Works - Other Services 448.000 Water System 448.120 Salaries & Wages 353,039.00 26,842.24 180,026.54 173,012.46 448.200 Materials & Supplies 30,000.00 6,720.94 11,518.01 18,481.99 448.222 Chemicals 150,000.00 4,000.03 80,311.70 69,688.30 448.225 laboratory Testing 13,000.00 318.75 4,551.50 8,448.50 448.231 Fuel 18,000.00 0.00 8,332.16 9,667.84 448.255 Maintenance 90,000.00 2,200.66 55,084.57 . 34,915.43 448.361 Electricity 75,000.00 4,565.09 29,955.47 45,044.53 448.429 Miscellaneous 5,000.00 214.50 692.00 4,308.00 Total Water System $734,039.00 $44,862,21 $370,471.95 363,567.05 7/9/2024 Wat.er Page 2of 3 3:25 PM Income Statement Actual to Budget 6/1/2024 to 6/30/2024 Jun 2024 2024 Jun 2024 Account Number Budget Actual YTDActual Balance 449.000 Water Transport 44�.120 Salaries & Wages 314,897.00 19,232.36 126,068.54 188,828.46 449.200 Mabarials & Supplies 175,000.00 14,505.61 135,485.42 39,514.58 449.251 Vechide Expense 18,000.00 869.17 7,479.26 10,520.74 449.255 Maintenance 20,000.00 20,000.00 449.429 Miscellaneous 1,500.00 1,500.00 449.607 Fulton Loan Payment 262,641.00 131,434.19 131,206.81 Total Water Transport $792,038.00 $34,607.14 $400,467.41 391,570.59 493.000 Water Administration 493.120 Salaries & Wages 65,079.00 4,595.52 30,153.46 34,925.54 493.160 Pension 115,961.00 115,961.00 493.161 FICA ( Social SecUrity) 56,076.00 3,862.37 25,660.04 30,415.96 493.200 Materials & Supplies 8,000.00 53.26 5,355.97 2,644.03 493.310 Professional Services 40,000.00 '.:!,257.88 25,417.34 14,582.66 493.321 Telephone Monthly Charges 10,000.00 702.67 4,963.99 5,036.01 493.350 Insurance &. Benefits 498,046.00 72,368.78 290,21'.:!.31 207,833.69 493.429 Miscellaneous 8,000.00 7,868.78 131.22 Total Water Administration � $801,162.00 $83,840.48 $389,631.89 411,530.11 494.000 Water Non--Recurring Charges 494.301 Captlal Replacement 200,000.00 200,000.00 494.302 Lagoon aeaning 10,000.00 10,000.00 o.oo 494.303 Street Patching 50,000.00 3,087.57 46,912.43 494.304 Interconnection 100,000.00 100,000.00 494.305 Equipment 40,000.00 40,000.00 494.306 Upgrades 20,000.00 20,000.00 Total Water Non-Reaming Charges $420,000.00 $13,087.57 406,912.43 Total Public Works .. Other Services $2,747;239.00 $163,309.83 $1,173,658.82 1,573,580.18 EXpenses $2,747,239.00 $163,309.83 $1,173,658.82 1,573,580.18 Income (Loss) From Operations ($517,083.00) ($58,963.07) $76,740.13 593,823.13 7/9/2024 Water Page 3 of 3 3:25 PM Income Statement Actual to Budget 6/1/2024 to 6/30/2024 Jun 2024 2024 Jun 2024 Account Number Bud.9.et Actual YTDActual Balance Net Income (Loss) ($517,083.00) ($58,963.07) $76,740.13 5!13,823.13 Report Options Period: 6/1/2024 to 6/30/2024 Display Level: Level 3 Accounts Display Account categories: Yes Display Subtotals: Level l Reporting Method: Accrual Fund: Water Include Accounts: With Non-zero Total Activity Budget: 2024 Water Budget Variance Source: Current Year YID Actual Revenue Variance Reporting: Other Amount -This Amount Expense Variance Reporting: This Amount - Other Amount � 7/9/2024 Sewer, Water .Page4of 7 3:26PM Expense Journal 6/1/2024 to 6/30/2024 Transaction Check Ac::count Date Number Invoice# Name / Desalptlon Notation Number Account _Amount Water 6 /4/2024 EFr-00102 7001967368 EMC INSURANCE Auto Ins 5/15/24-5/15/25 493.350 Insurance & Benefits 3,111.00 6/4/2024 EFr-00102 7001967368 Property Ins 5/15/24-5/15/25 493.350 Insurance & Benefits 35,076.00 $38,187.00 6/5/2024 003515 62024 AMERICAN UNITED UFE INSURANCE June2024 493.350 Insurance & Benefits 86.43 $86.43 6/5/2024 003522 49885. ITC GLOBAL NETWORKS, LLC 5/1-5/31/24 493.321 Telephone Monthly Charges 19.55 6/5/2024 003522 49781. 5/1-5/31/24 493.321 Telephone Monthly Charges 91.46 $111.01 6/5/2024 003523 447208 JGF FUNDING 7/1-7/31/24 copier lease 493.200 Materials & Supplies 53.26 $53.26 6/5/2024 003528 4509710 PENTELEDATA 5/24-6/24/24 493.321 Telephone Monthly Charges 41.98 6/5/2024 003528 4506394 5/24-6/24 /24 493.321 Telephone Monthly Charges 125.95 $167.93 6/5/2024 003536 06042024 WITMER, BRIAN Health Deductible 493.350 Insurance & Benefits 1,000.00 $1,000.00 6/11/2024 003541 835553 CLEMENS MACHINE DANVILLE OIi filter cap wrench 449.251 Vechlcle Expense 13.49 6/11/2024 003541 836905 ABS mat 448.200 Materials & Supplies 31.99 $45,48 � 6/11/2024 003542 200065256 COLES HARDWARE Switch metal toggle 449.200 Materials & Supplies 6.17 6/11/2024 003542 200065317 Blue painters tape 448.200 Materials & SUpplies 7.12 6/11/2024 003542 200064266 Great stuff gap crack 449.200 ,Materials & Supplies 9.98 6/11/2024 003542 150128487 Utility tub 449.200 Materials & Supplies 9.99 6/11/2024 003542 200063267 Gorilla tape 449.200 Materials & Supplies 11.38 6/11/2024 003542 150123231 55 gal drum liners 449.200 Materials & supplies 13.29 6/11/2024 003542 4783495 Mech gloves 449.200 Materials & Supplies 14.24 6 /11/2024 003542 200065308 Roller covers & threaded 448.200 Materials & Supplies 18.53 6/11/2024 003542 4821246 Hose nozzle, respirator disp 448.200 Materials & supplies 25.14 6/11/2024 003542 4883935 Pressure gauge & brass 449.200 Materials & SUpplles 28.56 6/11/2024 003542 4883306 Hose kink, connectors, 449.200 Materials & Supplies 79.71 6/11/2024 003542 200063472 Grass seed 449.200 Materials & Su pplies 94.99 $319,10 .6/13/2024 003543 624 AFSCME HEALTH & WELFARE RJND June 2024 493.350 Insurance & Benefits 213.16 $213,16 6/13/2024 003545 45608 B & W DISPOSAL 6/1-6/30/24 448.429 Miscellaneous 64.50 $64,50 7/9/2024 Sewer, Water Page5of7 3:26 PM Expense Journal 6/1/2024 to 6/30/2024 Transaction Oleck Account Date Number Invoice# Name/ Descri�on Notation Number Account Amount 6/13/2024 003556 36642 GANNETT FLEMING, INC Act 537 Plan 493.310 Professional Services 305.95 $305.95 6/13/2024 003559 14048559 HACH COMPANY Bench service 448.255 Maintenance 356.45 6/13/2024 003559 14049913 Lab turb with RAD 448.200 Matertals &. SUpplles 5,806.42 $6,162.87 6/13/2024 003560 48700 HAWK MTN LABS, INC Lagoon Water 5/1/24, 2nd Q 448.225 Laboratory Testing 318.75 $318,75 6/13/2024 003561 4476040 HBDELBERG MATERIALS NORTHEAST 3.14 ton 449.200 Materials &. Supplies 65.16 6/13/2024 003561 4480130 23.23 ton 2A Subbase 449.200 Materials &. Supplies 493.64 6/13/2024 003561 4479303 113.08 ton 2A Subbase 449.200 Materials &. Supplies 2,402.97 $2,961.77 6/13/2024 003563 343998 HUNTER&. LOMISON, INC, Oil &. fuel filters&. rotella 448.255 Maintenance 1,078.76 $1,078.76 6/13/2024 003564 16794657 IMPERIAL DADE Cleaning supplies 448.200 Materials&. Supplies 746.66 $746,66 6/13/2024 003565 2024-9178 IOLA WMBER CO., INC COid patch 449.200 Materials&. SUpplles 957.72 $957.72 6/13/2024 003566 3819178 l/B WATER SERVICE, INC. Curbboxes 449.200 Materials&. Supplies 201.60 � 6/13/2024 003566 3815418 4 in saddles 449.200 Materials &. Supplies 213.00 6/13/2024 003566 3820623 Saddles 449.200 Materials &. Supplies 213.00 6/13/2024 003566 3820625 Marking paint 449.200 Materials &. Supplies 225.60 6/13/2024 003566 3816925 3/4 in meters, couplings, 449.200 Materials & Supplies 244.63 6/13/2024 003566 3816323 curb box sections 449.200 Materials&. Supplies 337.00 6/13/2024 003566 3816322 curb box sections 449.200 Materials &. Supplies 444.00 6/13/2024 003566 3814594 6 in repair couplings 449.200, Materials &. Supplies 468.80 6/13/2024 003566 3814207 Lug repair clamps 449.200 Materials & Supplies 511.45 6/13/2024 003566 3816324 1.Sinmeter 449.200 Materials &. Supplies 820.00 6/13/2024 003566 3816321 1.5 in meter 449.200 Materials &. Supplies 1,625.00 6/13/2024 003566 3814204 6 in meter wheels, flanged 449.200 Materials &. Supplies 3,872.60 $9,176.68 6/13/2024 003568 183050 LBGHOW OIL COMPANY Generator fl II 449.200 Materials &. SUpplles 332.29 $332.29 6/13/2024 003569 06052024 MARKS, MCLAUGHLIN, DENNEHY &. June 2024 493.310 Professional Services 637.50 $637.50 6/13/2024 003570 0050967 MARTINS ELECTRICAL SERVICE LLC '3Ph Intgral Mtr 448.255 Maintenance 765.45 $765.45 7/9/2024 Sewer, Water Page6 of 7 3:26 PM Expense Journal 6/1/2024 to 6/30/2024 Transaction Check Aecaunt Date Number Invoice# Name / Description Notation Number Account Amount 6/13/2024 003571 69848 MAUSDALE SERVICE CENTER Safety inspection 449.251 Vechide Expense 41.83 $41,83 6/13/2024 003572 18567 NOl!:THEASTERN AUTOMATED camera system netowrk reset 493.321 Telephone Monthly Charges 48.33 $48.33 6/13/2024 003573 31336 NORTHPOINT AUTO & EQUIPMENT, LLC Snapper pins - TAX EXEMPT 449.200 Mal:erials & Supplies 21.00 $21,00 6/13/2024 003575 72024 PMHIC July 2024 493.350 Insurance & Benefits 31,830.67 $31,830.67 6/13/2024 003576 1278143209 R&L CARRIERS 1 CMPDS Ind Prue Wtr 449.200 Materials & Supplies 787.84 $787.84 6/13/2024 003578 RIVERSIDE TECHNOLOGIES INC. 493.310 Professional Services 1,314.43 $1,314.43 6/14/2024 EFT-00104 05282024 SERVICE ELECTRIC CABLEVISION 6/7-7/6/24 internet 493.321 Telephone Monthly Charges 64.90 $64,90 6/17/2024 EFT-00098 UGI UTIUTIES, INC. 448.231 Fuel 0.00 $0,00 � 6/18/2024 003585 06132024 Al.BRIGHT, LESTER Health Deductible 493.350 Insurance & Benefits 1,000.00 $1,000.00 6/20/2024 EFT-00110 CARDMEMBER SERVICES 493.200 Materials & Supplies o.oo 6/20/2024 EFT-00110 449.200 Materials & Supplies 0.00 6/20/2024 EFT-00110 448.225 Laboratory Testing 0.00 6/20/2024 EFT-00110 448.200 Materials & Supplies 0.00 6/20/2024 EFT-00110 Q52024 Water 448.200 Materials & Supplies 85.08 6/20/2024 EFT-00110 052024 Randy Rakar training 448.429 Miscellaneous 150.00 $235,08 6/20/2024 EFT- 00113 52142860 UNIVAR USA INC Chlorine 448.= Chemicals 4,000.03 $4,000.03 6/21/2024 EFT- 00099 UGI UTIUTIES, INC. 448.231 Fuel 0.00 $0,00 7/9/2024 Sewer, Water Page 7 of7 3:26 PM Expense Journal 6/1/2024 to-6/30/2024 Transaction Check Account Date Number Invoice# Name / Description N-tlon Number Account Amount 6/26/2024 EFT-00103 97421320 WEX May2024 449.251 Vechide Expense 813.85 $813,85 6/2.8/2024 EFT-00112 9966251331 VERIZON WIRELESS Celluar 5/11-6/10/24 493.321 Telephone Monthly Charges 120.03 $120.03 Water Totals $103,970.26 Report Options Transaction Date: 6/1/2024 to 6/30/2024 Level of Detail: Summary Fund: Water, Sewer Display Notatlon (Additional Description): No Entry Screen: Payments Account: Excludes Due to General Fund, Due to General Fund �  Water 12 Month Recap Revenue Expense Net Income/Loss Jul-23 $195,633.28 $193,243.12 $2,390.16 Aug-23 $301,265.59 $164,688.56 $136,577.03 Sep-23 $213,977.93 $435,209.02 -$221,231.09 Oct-23 $222,504.80 $140,505.84 $81,998.96 Nov-23 $292,636.46 $260,577.93 $32,058.53 Sep-84 $87,204.12 $120,706.95 . -$33,502.83 Jan-24 $177,052.33 $180,628.33 -$3,576.00 Feb-24 $336,475.69 $219,875.18 $116,600.51 Mar-24 $74,720.17 $122,104.34 -$47,384.17 Apr-24 $163,233.16 $176,797.30 -$13,564.14 May-24 $391,428.28 $310,173.84 $81,254.44 Jun-24 $104,346.76 $163,309.83 -$58,963.07 Total $2;560,478.57 $2,487,820.24 $72,658.33 Average $213,373.21 $207,318.35 $6,054.86  Report from the Danville Borough Municipal Authority Meeting Tuesday, July 16, 2024 Water • Sidler Hill Engineering Review - 66 customers o Booster Pump • Initial Construction Cost - $500,000/66 customers = $7,575.76 per customer • Operations and Maintenance - $12,000/66 customers = $181.82 annually per customer o Wells - 3 • $15-$30K • Additional Requested Information • 14 Iron Ore Lane - any issues with well (quality and pressure) • discoloration if the hose runs to fill pool, gallons per minute is not super high but no issues running multiple things at once • Engineering will new wells cause issues for existing wells and/or will this work for the proposed customers - hire a hydrogeologist for that kind of assessment $SOK • Pressure Study - allied meters, data will be provided at the meeting Sewer • Fats, Oil & Grease (FOG) o Taco Bell has a grease interceptor o Current ordinance only addresses industrial users o Submit a request to Council for an amendment to ordinance Water & Sewer • Final submission for Act 537 to DEP on 3.19.24-can take up to 4 months o Deficiencies need addressed by 7.12.24 - no extension needed -2 weeks for DEP review 7/9/2024 Sewer Page 1 of 3 3:24 PM Income Statement Actual to Budget 6/1/2024 to 6/30/2024 Jun2024 2024 Jun 2024 Account Number Budget Actual YTDActual Balance Revenue Interest Earnings 341.100 Interest Earnings 148,750.00 9,522.74 50,475.47 (98,274.53) Total Interest Earnings $148,750.00 $9,522.74 $5D,475A7 (98,274.53) Sanitation 364.101 Metered 1,438,370.00 46,075.73 593,831.87 (844,538.13) 364.102 unmetered 125,802.00 (125,802.00) 364.103 Veolia-0559 1,000,000.00 99,887.67 427,322.90 (572,677.10) 364.104 GMC-1786 574,687.00 0.00 287,343.54 (287,343.46) 364.105 DSH -1490 260,000.00 0.00 104,844.26 (155,155.74) 364.106 Riverside -6500 200,000.00 0.00 73,597.94 (126,402.06) - 364.107 Cooper - 6158 70,000.00 0.00 19,839.53 (50,160.47) 364.108 State Pension 77,523.00 (77,523.00) 364.109 Valley-6157 o.oo 18,557.96 18,557.96 364.171 Administrative Fees 1,000.00 302.50 24,200.79 23,200.79 364.360 Sale of Bulk Wat.er & Services 62,056.00 893.47 18,061.39 (43,994.61) 364.361 Riverside O & M 34,200.00 o.oo 13,175.00 (21,025.00) .364.362 Valley Sampling 0.00 380.00 380.00 364.365 Solid Waste 15,000.00 3,344.00 15,244.00 244:00 Total Sanitation $3,858,638.00 $150,503.37 $1,596,399,18 (2,262,238.82) Revenue $4,007,388.00 $160,026.11 $1,646,874.65 (2,360,513.35) Gross Profit $4,007,388.00 $160,026.11 $1,646,874.65 (2,360,513.35) Expenses Sanitation Collections 426.000 Sanitation 426.100 Salaries - Collection System 73,037.00 9,884.40 47,546.60 25,490.40 426.200 Material & Supplies 16,400.00 197.38 16,202.62 426.251 Vehide Parts 500.00 500.00 426.300 capital Improvments - Infrast. 5,000.00 5,000.00 426.301 Capital Improvements - General 98,970.00 871.50 37,301.47 61,668.53 426.302 Meter Project 28,500.00 4,937.23 24,826.29 3,673.71 426.361 Electricity Collections 4,200.00 2,430.42 8,230.28 (4,030.28) 426.370 Repairs, Maintenance Services 3,300.00 3,300.00 426.450 Contracted Services 60,000.00 60,000.00 7/9/2Il24 Sewer Page 2 of3 3:24 PM Income Statement Actual to Budget 6/1/2024 to 6/30/2024 Jun 2024 2024 Jun 2024 Aa,ount Number Budget Actual YTDActual Balance 426.560 Salaries - Collection System 9,563.00 625.40 4,187.38 5,375.62 426.606 Valley Loan • collection 1,961,030.00 1,961,030.00 426.607 Penn Vest Loan Payment 595,307.00 39,749.64 317,997.12 2n,309.88 426.700 Riverside Pump Station 1,700.00 145.10 1,011.70 688.30 Total Sanitation $2,1157,507,00 $58,643.69 $441,298,22 2,416,208.78 428.000 Valley Township 428.700 Pump Station Materials 51,700.00 431.30 51,268.70 Total valley Township $51,700.00 $431.30 51,268.70 Total Sanitation Collections $2,909,207.oo $58,643.69 $441,729.52 2,467,477.48 Public Works - Sanitation 429.000 Wastewater 429.120 Salaries - Treatment Plant 460,717.00 24,734.06 165,099.87 295,617.13 429.222 Chemicals 180,000.00 39,600.93 98,261.78 81,138.22 429.225 Laboratory Supplies SOD.OD 500.00 429.230 Heating Fuel 60,000.00 3,786.74 41,340.15 18,659.85 429.238 Clothing & Uniforms 100.00 470.00 (370.00) 429.251 Vehide Expense 20,000.00 1,250.73 18,788.95 1,211.05 � 429.300 Maintenance Supplies 6,000.00 947.81 5,052.19 429.317 Lab SelVices 35,000.00 2,876.60 17,295.52 17,704.48 429.361 Eledricity 130,000.00 9,734.37 58,093.48 71,906.52 429.365 Solid Waste 55,_695.00 144.50 2,361.05 53,333.95 429.366 Water 10,000.00 6,084.66 3,915.34 429.370 Equipment Repairs & Maint. 120,000.00 714.85 117,499.74 2,500.26 429.450 ContractedSelVices 60,000.00 2,095.00 53,326.65 6,673.35 429.600 Capital Construction - General 54,534.00 373.59 16,142.53 38,391.47 Total Wastewater $1,192,546.00 $85,311.37 $595,712.19 596,833.81 Total Public Works - sanitation $1,192,546.00 $85,311.37 $595,712,19 596,833.81 Wastewater Debt 429.607 Penn Vest Loan Payment - Plant 1,084,896.00 67,403.00 539,224._00 545,672.00 Total Wastewater Debt $1,084,896.00 $67,403.00 $539,224.00 545,672.00 Health Insurance Benefit 487.000 Sewer Administration 487.120 Salaries &. Wages 58,576.00 4,595.52 30,153.46 28,422.54 487.152 Vision & Dental 2,271.00 189.21 1,135.23 1,135.77 487.156 Health Insurance 238,297.00 17,907.88 125,071.09 113,225.91 7/9/2024 Sewer Page 3 of 3 3:24PM Income Statement Actual to Budget 6/1/2024 to 6/30/2024 Jun 2024 2024 Jun 2024 Account Number Budget Actual YTDActual Balance 487.158 Life Insurance 801.00 65.91 395.45 405.55 487.160 Pension 92,361.00 92,361.00 487.161 FICA (Social Security) 46,045.00 3,041.48 20,050.85 25,994.15 487.200 Supplies 10,000.00 1,452.79 4,881.55 5,118.45 487.310 Professional Services 637.50 (637.50) 487.311 Accounting & Auditing 9,375.00 8,875.00 500.00 487.312 Legal Consulting 15,000.00 637.50 9,198.75 5,801.25 487.313 Engineering 10,000.00 30S.96 4,424.23 5,575.77 487.321 Telephone Monthly Charges 5,000.00 271.86 1,617.24 3,382.76 487.331 TraveJ expense 2,500.00 96.21 920.51 1,579.49 487.341 Advertising, Printing & Postag 2,500.00 258.21 1,673.22 826.78 487.352 Liability (Casulaty) 19,928.00 19,822.00 106.00 487.354 Workefs Compensation Ins. 69,179.00 69,179.00 487.355 Vehicle Insurance 5,016.00 2,759.00 5,016.00 0.00 487.356 Fire Insurance 18,476.00 22,784.00 24,862.50 (6,386.50) 487.420 Dues, subscriptions & Membersh 800.00 523.59 276.41 487.430 DEP Annual Fees 1,750.00 3,750.00 (2,000.00) 487.451 contracted services 1,000.00 1,000.00 Total Sewer Administration $608,875.00 $ 54,36 5.53 $263,008.17 345,866.83 � Total Health Insurance Benefit $608,875.00 $54,365.53 $263,008.17 345,866.83 Expenses $5,795,524,00 $265,723.59 $1,839,673.88 3,955,850.12 Income (Loss) From Operations ($1,788,136.00) ($105,697.48) ($192,799.23) 1,595,336.77 Net Income (Loss) ($1,788,136.00) ($105,697,48) ($192,799.23) 1,595,336.77 Report Options Period: 6/1/2024 to 6/30/2024 Display Level: Level 3 Aocounts Display Account categories: Yes Display Subtotals: Level 1 Reporting Method: Accrual .fund: Sewer Include Aocounts: With Non-zero Total Activity Budget: 2024 sewer Budget Variance Source: Current Year YTD Actual Revenue Variance Reporting: Other Amount� This Amount Expense Variance Reporting: lhis Amount - Other Amount 7/9/2024 Sewer, Water Page 1 of 7 3:26PM Expense Journal 6/1/2024 to 6/30/2024 Transaction Check Account Date Number Invoice# Name / Description Notation Number Account Amount Sewer 6/4/2024 EFr-00102 7001967368 EMC INSURANCE Auto Ins 5/15/24-5/15/25 487.355 Vehicle Insurance 2,759.00 6/4/2024 EFr-00102 7001967368 Property Ins 5/15/24-5/15/25 487.356 Fire Insurance 22,784.00 $25,543.00 6/5/2024 003515 62024 AMERICAN UNITED LIFE INSURANCE June 2024 487.158 Life Insurance 65.91 $65.91 6/5/2024 003519 5·550638 GRAYMONT (PA) INC High calcium quicklime 429.222 Chemicals 5,659.58 $5,659.58 6/5/2024 003521 125051 INFRAMARK, LLC WWTP pump station comms 429.450 Contracted Services 1,030.00 $1,030.00 6/5/2024 003522 49885 ITC GLOBAL NElWORKS, LLC 5/1-5/31/24 487.321 Telephone Monthly Charges 19.55 $19,55 6/5/2024 003523 447208 JGFFUNDING 7/1-7/31/24 copier lease 487.200 Supplies 53.27 $53.27 6/5/2024 003528 4509710 PENTELEDATA 5/24-6/24/24 487.321 Telephone Monthly Charges 41.98 $41.98 6/5/2024 003532 12480769 SUSQUEHANNA ARE PROTECTION co. Bump gas & semi-annual 429.450 Contracted Services 170.00 � $170.00 "-.. 6/5/2024 003534 52084115 UNIVAR USA INC Sod Hypo Liquichlor 429.222 Chemicals 3,729.98 6/5/2024 003534 52138165 Almn Sulfate 429.222 Chemicals 9,053.17 6/5/2024 003534 52078950 Mag Hydrox flomag 429.222 Chemicals 20,022.20 $32,805.35 6/11/2024 003540 2449E3525 PACE ANALYTICAL SERVICES, LLC Lab sampling 426.700 Riverside Pump Station 145.10 6/11/2024 003540 2449E0586 Lab sampling 429.317 Lab .Services 233.80 6/11/2024 003540 2449E1124 Lab sampling 429.317 Lab Services 233.80 6/11/2024 003540 2449E1259 Lab sampling 429.317 Lab Services 233,80 6/11/2024 003540 2449E1692 Lab sampling 429.317 Lab Services 233.80 6/11/2024 003540 2449E1903 Lab sampling 429.317 Lab Services 233,80 6/11/2024 003540 2449E2999 Lab sampling 429.317 Lab Services 233.80 6/11/2024 003540 2449E3527 Lab sampling 429.317 Lab Services 233.80 6/11/2024 003540 2449E3624 Lab sampling 429.317 Lab Services 233.80 6/11/2024 003540 2449F0603 Lab sampling 429.317 Lab Services 233.80 6/11/2024 003540 2449E3622 Lab sampling 429.317 Lab Services 290.20 6/11/2024 003540 2449E3157 Lab sampling 429.317 Lab services 482.20 $3,021.70 6/11/2024 003541 836912 CLEMENS MACHINE DANVILLE 20W50Qtoil 429.251 Vehlde Expense 9.87 $9.87 7/9/2024 Sewer, Water Page2of 7 3:26 PM Expense Journal 6/1/2024 to 6/30/2024 Transaction Check Account Daile Number Invoice# Name / Descrie!;ion Notation Number Account Amount 6/11/2024 · 003542 150122262 . COLES HARDWARE Lawn mower fuel fitler 429.370 Equipment Repairs & Maint. 6.99 6/11/2024 003542 200068380 Gallon storagebags & starting 429.370 Equipment Repairs & Maint. 15.46 6/11/2024 003542 150125093 Leather gloves, quart freezer 429.370 Equipment Repairs & Maint. 24.20 6/ll/2024 003542 150'23631 Sch40 pipe 429.370 Equipment Repairs & Malnt. 37.99 $84.64 6/13/2024 003543 624 AFSCME HEALlli & WELFARE FUND June 2024 487.152 Vision & Dental 189.21 • $189.21 6/13/2024 003545 45608 B & W DISPOSAL 6/1-6/30/24 429.365 SOiid Waste 144.50 $144,50 6/13/2024 003547 W94059 BEST LINE EQUIPMENT Repair rear window of Bobcat 429.251 Vehide El<pense 601.86 $601.86 6/13/2024 003554 00274262.0 ENVIROMENTAL SYSTEMS RESEARCH ArcGIS Subscription 9/1/24- 429.450 Contracted services 770.00 $770.00 6/13/2024 003556 36642 · GANNETT FLEMING, INC Act 537 Plan 487.313 Engineering 305.96 6/13/2024 003556 36647 PennVEST 429.600 Capital Construction - General 373.59 6/13/2024 003556 36647 PennVEST 426.301 Capital Improvements - 373.59 6/13/2024 003556 36643 Fisher Court PS & FM 426.301 capital Improvements - 497.91 $1,551.05 6/13/2024 003557 81326 GELCO SUPPLY INC. RootX 401b case 429.222 Chemicals 1,136.00 $1,136.00 � 6/13/2024 003558 074153 GREGG'S SMALL ENGINE REPAIR 3 blades 429.370 Equipment Repairs & Malnt. 71.97 $71.97 6/13/2024 003562 509460 HILLY RIDGE SALES & SERVICE, INC Tire, tube & disposal fee 429.370 Equipment Repairs & Maint. 54.70 $54.70 6/13/2024 003566 3816925 L/B WATER SERVICE, INC. 3/4 in meters, couplings, 426.302 Meter Project 244.63 6/13/2024 003566 3816324 l.5 In meter 426.302 Meter Project 820.00 6/13/2024 003566 3814204 6 in meter wheels, flanged 426.302 Meter Project 3,872.60 $4,937.23 6/13/2024 003569 06052024 MARKS, MCLAUGHLIN, DENNEHY & June 2024 487.312 Legal Consulting 637.50 $637.50 6/13/2024 003572 18567 NORTHEASTERN AUTOMATED camera system netowrk reset 487.321 Telephone Monthly Charges 48.34 $48.34 6/13/2024 003574 33589 PA STATE ASSOOATION OF BOROUGHS Drug & Alcohol Random Test - 487.331 Travel expense 96,21 $96.21 6/13/2024 003575 72024 PMHIC July 2024 487.156 Health Insurance 17,524.75 $17,524.75 6/13/2024 003578 RIVERSIDE TECHNOLOGIES INC. 487.200 Supplies 1,314.43 $1,314.43 7/9/2024 Sewer, Water Page3 of7 3:26PM Expense Journal 6/1/2024 to 6/30/2024 Transaction Check Account Date Number Invoice# Name/ Description Notation Number Account Amount 6/17/2024 EFT- 00098 4097-0524 UGI UTILITlES, INC. 4/30-5/30/24 429.230 Heating Fuel 1,818.20 $1,818.20 6/18/2024 003589 84520776 PENTELEDATA 6/10-7/9/24 Internet 487.321 Telephone Monthly Olarges 70.95 $70,95 6/18/2024 EFT-00108 H5'14269793 NRG BUSINESS MARKETING 4/30-5/330/24 429.230 Heating Fuel 1,968.54 $1,968.54 6/20/2024 EFT-00110 CARDMEMBER SERVICES 487.331 Travel expense 0.00 6/20/2024 EFT-00110 487.200 Supplies 0.00 6/20/2024 EFT-00110 429.450 Contracted services 0.00 6/20/2024 EFT-00110 429.370 Equipment Repairs & Mafnt. 0.00 6/20/2024 EFT- 00110 052024 Water 487.200 Supplies 85.09 $85.09 6/21/2024 EFT- 00099 UGI UTILITlES, INC. 429.230 Heating Fuel 0.00 $0,00 6/26/2024 003600 41288 ECO AIR MECHANICAL SERVICES, LLC Safety switch refastened 429.450 Contracted Services 125.00 $125,00 6/26/2024 003601 06262024 GRAHAM, JANE M. Health Deductible 487.156 Health Insurance 357.37 $357,37 6/26/2024 003602 28758256 MCMASTER-CARR SUPPLY CO Valvues w/ level handles 429.370 Equipment Repairs & Maint. 503.54 � $503.54 -......;;::: 6/26/2024 EFT-00103 97421320 WEX May2024 429.251 Vehicle Expense 639.00 $639.00 6/28/2024 EFT-00112 9966251331 VERIZON WIRELESS Celluar 5/11-6/10/24 487.321 Telephone Monthly Charges 82.51 $82.51 6/28/2024 EFT- 00119 4058-624 SERVICE ELECTRIC TELEPHONE SECV 6/15-7/14/24 487.321 Telephone Monthly Charges 43.94 $43.94 Sewer Totals $103,276.74  Sewer . 12 Month Recap Revenue Expense Net Income/Loss Jul-23 $443,598.56 $367,621.07 $75,977.49 Aug-23 $368,570.31 $388,313.22 -$19,742.91 Sep-23 $228,400.01 $363,428.31 -$135,028.30 Oct-23 $514,355.55 $219,510.93 $294,844.62 Nov-23 $405,780.12 $131,391.07 $274,389.05 Dec-23 $59,801.56 $99,203.43 -$39,401.87 Jan-24 $379,018.81 $494,898.47 -$115,879.66. Feb-24 $214,274.40 $455,291.45 -$241,017.05 Mar-24 $203,671.04 $168,701.23 $34,969.81 Apr-24 $253,225.21 $347,597.26 -$94,372.05 May-24 $435,629.60 $307,289.61 $128,339.99 Jun-24 $160,026.11 $265,723.59 -$105,697.48 Total $3,666,351.28 $3,608,969.64 $57,381.64 Average $305,529.27 $300,747.47 $4,781.80 JULY 2024 SEWER AUTHORITY REPORT PLANT: • Digester blocked with rags at overflow flooded internally. Zero violations. June 22 and July 5 • Switching to digester feed only while plant is staffed until upgrade • Drained Bio #1 and cleaned • Internal mixed liquor pumps rebuilt • Heat exchangers open(;!d and cleaned • Lift and clean pumps in digester recirculation system • Clean Primary clarifiers • WET T Testing and annual NPDES permit testing schooled this month COLLECTIONS: • Reprogramming of VTMA generator and pumps has begun with integrator • 2 months of flow data has been generated for VTMA pumpstations • De-greasers added at the restaurant area main lines in the Borough • Weekly jetting • Unblock borough hall ballroom • Unblock jail line • Fuses blown at VTMA pumpstations during thunderstorms July 1 /<;?