BOONSBORO KEEDYSVILLE WATER ADVISORY BOARD PROPOSED KEEDYSVILLE COST-SHARING TRUE-UP FORFY23 Prepared by: Lisa Riner, Keedysville Town Administrator  Presented: August. 14, 2024  TABLE OF CONTENTS  Summary Documents: FY23 True-up Narrative True-Up Chart FY23.  Detail Support Documents: Boonsboro Water Fund Capital Water Usage Report FY23  Boonsboro Water. Fund Audited Financial Report FY23.  3 4 5 6 8  Daily Operations Labor for Tank and Booster Station FY23 Boonsboro Billing & Customer Accounting for Keedysville FY23.....7  Annual Recap FY11 - FY24.    Boonsboro Keedysville Water Service  Narrative of the Keedysville Cost-Sharing True-up for FY23  Keedysville's FY23 projected cost and actual cost were based on the following factors which are  supported ini the subsequent detail pages:  Budget $346,722 $198,000 16.0% $13,319  Actual $340,506 $95,674 -$102,326 14.7% $14,133 $8,116  Difference $6,216 -1.3% +$814 +$1,036  Shared operating expense Shared capital Percent of water used Billing and customer accounting  Daily operations of tank and booster station $7,080  The total amount due from Keedysville to Boonsboro for the year is $86,368 which is $22,232  less than what was projected.  The most significant differences between the FY23 projected cost to Keedysville and the actual cost are 1) capital was less than projected, although there were: several smaller capital expenditures not budgeted, and 2) no contingency expenditure was required. The final true-up result for FY23 is a payment from Boonsboro to Keedysville of $22,232.  1.    N3 Nf  df  Nf 0f  0  S5  3  3 1   9889888  2.  AAYAOPERER  a 4E  RAARRRR    BOONSBORO MAYOR AND COUNCIL  STATEMENT OF REVENUES AND EXPENDITURES- BUDGET AND ACTUAL-  WATER UTILITY FUND (BUDGETARYBASIS)  Year ended. June. 30,  2023 ACTUAL OVER(UNDER) BUDGET 21,492 57,483 78,975 (590) (4,716,058) 5,438 (7,000) 31,409 (1,020) 30,466 (4,340) 1,034 (7,585) (1,508) (25,075) (5,821) (19,863) 8,366 (5,114) (4,000) 10,886 230 (2,239) 18,646 (7,161) 7,140 (5,450) (4,699,209) 4,778,184 383 1,000 (4,775,439) (143,464) 81,401 (2,222) 1,853 193,670 (4,642,818) 135,366 45 3.  ORIGINAL BUDGET 72,000 722,000 1,000 5,005,432 18,000 7,000 98,400 1,200 26,850 3,000 11,000 8,000 70,000 20,430 303,000 16,000 6,000 4,000 1,000 3,000 60,000 20,000 8,532 5,691,844 (4,969,844) (4,969,844) 23,768 9,550 4,992,000 156,100 3,500 (21,404) (193,670) 4,969,844  FINAL BUDGET 72,000 722,000 1,000 5,005,432 18,000 7,000 98,400 1,200 26,850 3,000 11,000 8,000 70,000 20,430 303,000 16,000 6,000 4,000 1,000 3,000 60,000 20,000 8,532 5,691,844  ACTUAL 129,483 800,975 410 289,374 23,438 129,809 180 30,466 22,510 4,034 3,415 6,492 44,925 14,609 283,137 24,366 886 10,886 1,230 761 78,646 12,839 7,140 3,082 992,635 (191,660) 24,151 10,550 216,561 12,636 84,901 (2,222) (19,551) 327,026 135,366 $  OPERATING REVENUES Charges for services Charges for administration TOTAL OPERATING REVENUES OPERATING) EXPENSES Advertising Capital outlay Chemicals Engineering services Healthi insurance Meetings Miscellaneous Payroll taxes Postage Professional services Propertyi insurance Repairs and maintenance Retirement Salaries Supplies Telephone Testing Tools and equipment Training and certification Uniforms Utilities Vehicles Water/Sewer systems study andi monitoring Worker's compensation TOTAL OPERATING EXPENSES OPERATING INCOME (LOSS) OTHER INCOME (EXPENSE) Debt service fees Connection: fees Grants Otheri income Interesti income Interest expense Debts service (principal payments) Contingency TOTAL OTHER: INCOMEEXPENSE NETI INCOME (LOSS)  $ 650,000 $ 650,000 $ 671,492 $  23,768 9,550 4,992,000 156,100 3,500 (21,404) (193,670) 4,969,844    0 000000  EZOZAS  VZOZAS    5.    Cost of Daily Operations Labor at Keedysville Tank and Booster Station Byagreement between the Towns Keedysville is chargedi for 1/2 hour per day ofv water operator time forr routine inspection and daily operations oft the watert tank and boosters station in Keedysville,  FY23  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 onj job hours Billing hourly rate Average rate fora all4 4 Overtime Rate Saturday, x1.5 FICA + Medicare @7.65% Pension 7% of all wages Total direct cost per hour Average of 46 employees Overtime Rate Sunday, x2.0 FICA +I Medicare @7.65% Pension 7% of all wages Total direct cost per hour Average of4 46 employees Dayo of the week Monday- Friday Saturday Sunday TOTAL Prepared: Bstaff  Shumaker DeGrange $35.93 $74,734 $43,784 5,717 8,822 104 245 179 2,242 5,231 $97,275 40 52 2,080 240 1,840 $52.87 $53.90 4.12 3.77 $61.79 $71.86 5.50 5.03 $82.39 Daysi inyr Hrs per Day 261 52 52 365  Hill $25.88 $53,830 4,118 20,692 104 135 179 1,615 3,768 $84,441 40 52 2,080 160 1,920 $43.98 $38.82 2.97 2.72 $44.51 $51.76 3.96 3.62 $59.34 $38.07 $51.90 $69.20  Morton $19.85 $41,288 3,159 20,692 104 135 179 1,239 2,890 $69,685 40 52 2,080 120 1,960 $35.55 $29.78 2.28 2.08 $34.14 $39.70 3.04 2.78 $45.52  Olthof $18.00] $37,440 2,864 8,822 104 135 179 1,123 2,621 $53,288 40 52 2,080 120 1,960 $27.19 $27.00 2.07 1.89 $30.96 $36.00 2.75 2.52 $41.27 Total $4,967.68 $1,349.34 $1,799.12 $8,116.14  $21.05 3,349 8,822 86 152 179 1,314 3,065 $60,750 40 52 2,080 160 1,920 $31.64 $31.58 2.42 2.21 $36.20 $42.10 3.22 2.95 $48.27 0.5 0.5 0.5  0.0765  0.03 0.07  $365,438  9,600 $38.07  0.0765 0.07  $51.90  0.0765 0.07  $69.20  6.    Boonsboro Billing and Customer Accounting for Keedysville Accounts  FY23  Contracted Services and Supplies Contracted Billing Service: Other  HBP printing and mailing costs Total contracted services and supplies Administrative Asst/Water & Sewer  $5,096  $5,096  Rate Amount 23.47 $48,818 0.0765 3,735 20,693 86 180 1,025 488 3,417 $78,442 2080 -120 1,960 $40.02 85.0%  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 job hours Billing rate per hour  2,080  0.021 0.01 0.07 52  40  %1 time Administrative Asst on water and sewer  Total Water Only 1,460 1,460 1,340 410 3,210 1,870  Bwater accounts B sewer accounts Kwater: accounts Total accounts  410  % K+B water: accounts of total accounts % Kaccounts of1 total water accounts Annual hours for Keedysville  58.3% 21.9% 225.8  $9,038 $14,133  Total Billing and Customer Accounting  Prepared: B staff  7.    8.