BOONSBORO KEEDYSVILLE WATER ADVISORY BOARD PROPOSED KEEDYSVILLE COST-SHARING TRUE-UP FOR FY24 Prepared by: Lisa Riner, Keedysville Town Administrator Prepared: December 10, 2024 TABLE OF CONTENTS Summary Documents: True-up Narrative FY24 True-Up Chart FY24. L Detail Support Documents: Boonsboro Water Fund Audited Financial Report FY24. 3 4 5 6 8 Boonsboro Water Fund Capital FY24 Water Usage Report FY24. Daily Operations Labor for Tank and Booster Station FY24 Boonsboro Billing & Customer Accounting for Keedysville FY24...... 7 Annual Recap FY11-F FY25. Boonsboro Keedysville Water Service Narrative of the Keedysville Cost-Sharing True-up for FY24 Keedysville's FY24 projected cost and actual cost were based on the following factors which are supported in the subsequent detail pages: Budget $397,845 $170,000 15.5% $13,693 Actual $402,872 $14,996 $155,004 13.8% $13,145 $8,373 Difference $5,027 -1.7% -$548 $824 Shared operating expense Shared capital Percent of water used Billing and customer accounting Daily operations of tank and booster station $7,549 The total amount due from Keedysville to Boonsboro for the year is $79,184 which is $31,392 less than what was projected. The most significant differences between the FY24 projected cost to Keedysville and the actual cost are 1) capital was less than projected and 2) no contingency expenditure was required. The final true-up result for FY24 is a payment from Boonsboro to Keedysville of $31,392. s & 9 Ny 00 f 6 1 Oc :ne a 4f 1 9A89RRR RAA8R88 2 BOONSBORO MAYOR, - AND COUNCIL STATEMENT OF. REVENUES AND. EXPENDITURES-BUDGET AND. ACTUAL- WATER UTILITY FUND (BUDGETARY BASIS) Yeare ended. June 30, 2024 ACTUAL OVER (UNDER) BUDGET 50,435 10,576 61,011 (390) (7,138,018) 11,652 (6,000) 14,730 1,000 (7,000) 39,389 (558) 8,535 (6,369) (320) (6,625) (294) 491 (3,935) (5,383) 2,547 (30) (17,226) 2,941 844 2,873 1,470 (2,011) (7,107,687) 7,168,698 379 (7,052,380) 14,189 183,746 (423) 56 33,983 (6,820,450) 348,248 43 ORIGINAL BUDGET 100,000 808,000 1,000 7,257,020 21,600 6,000 13,000 7,000 119,976 1,200 2,500 29,130 4,500 12,000 8,000 70,000 23,000 318,650 19,000 4,000 43,375 1,000 1,500 70,000 15,000 5,500 8,053,951 (7,245,951) 23,768 10,550 7,131,020 136,000 (1,549) (19,855) (33,983) 7,245,951 FINAL BUDGET 100,000 808,000 1,000 7,257,020 21,600 6,000 13,000 7,000 119,976 1,200 2,500 29,130 4,500 12,000 8,000 70,000 23,000 318,650 19,000 4,000 43,375 1,000 1,500 70,000 15,000 5,500 8,053,951 (7,245,951) 23,768 10,550 7,131,020 136,000 (1,549) (19,855) (33,983) 7,245,951 ACTUAL 110,576 869,011 610 119,002 33,252 27,730 1,000 159,365 642 11,035 22,761 4,180 5,375 7,706 70,491 19,065 313,267 21,547 3,970 26,149 3,941 2,344 72,873 16,470. 3,489 946,264 (77,253) 24,147 10,550 78,640 14,189 319,746 (1,972) (19,799) 425,501 348,248 $ OPERATING REVENUES Charges for services Charges for administration TOTAL OPERATING REVENUES OPERATING EXPENSES Advertising Capital outlay Chemicals Communications Connections Contingency fund Engineering services Health insurance Meetings Miscellaneous Payroll taxes Postage Professional services Propertyi insurance Repairs and maintenance Retirement Salaries Supplies Testing Tools and equipment Training and certification Uniforms Utilities Vehicles Worker's compensation TOTAL OPERATING EXPENSES OPERATING INCOME (LOSS) OTHER: INCOME (EXPENSE) Debt service fees Connection fees Grants Other inçome Interest income Interest expense Debts service (principal payments) Contingency TOTAL OTHER INCOME (EXPENSE) NETI INCOME (LOSS) 708,000 $ 708,000 $ 758,435 $ 3 0 0000 00 9 0000 VZAS SZAE Cost of Daily Operations Labor at Keedysville Tank and Booster Station Byagreement: between the Towns Keedysville is charged for 1/2 hour perc day of water operator time forroutine Inspectionanddaily operations oft thei water tank and booster stationi ink Keedysville. FY24 Actuals Retired 3/29/2024 Hired 3/18/2024 Regular Time Hourly rate Salary forf fiscal year FICA + Medicare @7.65% Health Ins (Annual) Life Ins (Annual) Short term disability (Annual) Unemployment @.021x$8500 Workers Compensation Pension Total wage and benefit Regular work hours/week Weeks employed Annual hours paid Less: Personal leave Total on job! hours Billing hourlyr rate Average rate for all 4 Overtime Rate Saturdayx1.5 FICA + Medicare @7.65% Pension 7% of ally wages Total direct cost per hour Average of 4 employees Overtime Rate Sunday, x2.0 FICA+N Medicare @7.65% Pension 7% of all wages Total direct cost per hour Average of 4 employees Dayo of they week Monday- Friday Saturday Sunday TOTAL Shumaker DeGrange Hill Morton Olthof $35.93 $21.05 $25.88 $19.85 $18.00 $74,734 $37,048 $53,830 $41,288 $11,520 0.0765 5,717 8,822 104 245 179 0.03 2,242 0.07 6,375 2,834 4,118 3,159 8,822 20,692 20,692 86 152 179 1,111 1,615 1,239 3,004 4,239 3,479 881 8,822 104 135 179 346 0 104 135 179 104 135 179 $98,418 $53,236 $84,912 $70,274 $21,986 $328,826 40 52 2,080 240 1,840 40 44 186 40 52 1,760 2,080 2,080 160 1,574 1,920 1,960 40 52 120 40 16 640 25 615 7,909 $41.58 $53.49 $33.82 $44.22 $35.85 $35.75 $53.90 $31.58 $38.82 $29.78 $27.00 $61.79 $36.20 $44.51 $34.14 $30.96 $71.86 $42.10 $51.76 $39.70 $36.00 $82.39 $48.27 $59.34 $45.52 $41.27 0.0765 0.07 4.12 3.77 2.42 2.21 2.97 2.72 2.28 2.08 2.07 1.89 $44.16 0.0765 0.07 5.50 5.03 3.22 2.95 3.96 3.62 3.04 2.78 2.75 2.52 Total $5,425.69 $1,148.13 $1,799.12 $8,372.95 $69.20] Days inYr Hrs per Day 261 52 52 365 0.5 0.5 0.5 $41.58 $44.16 $69.20 Prepared: Bstaff 12/10/24 Boonsboro Billing and Customer Accounting for Keedysville Accounts FY24 Contracted Services and Supplies Contracted Billing Service: HBP printing and mailing costs Total contracted services and supplies $4,493 Other $4,493 Administrative Asst/Water & Sewer Rate Amount 23.47 $48,818 0.0765 3,735 Annual wages FICA Health Insurance Life Insurance ShortTerm Disability Unemployment (first $8,500) Workers Compensation Pension Total wage and benefits Work hours LESS: Personal Leave Total onj jobl hours Billing rate perhour 2,080 18,165 86 180 0.021 179 0.01 488 0.07 3,417 $75,067 52 2080 -120 1,960 $38.30 85.0% $8,500 40 %1 time Administrative. Asst on water and sewer Total Water Only 1,440 1,440 1,352 409 3,201 1,849 Bwater accounts B sewer accounts K water accounts Total accounts 409 % K+B water accounts of total accounts % Kaccounts oft total water accounts Annual hourst for Keedysville 57.8% 22.1% 225.9 $8,652 $13,145 Total Billing and Customer Accounting