===PAGE 1=== Draft FY24 updtd budget for SC meeting 022823.xlsx/fy24 DRAFT budgt w desc 022823 TOWN OF LUNENBURG - SEWER ENTERPRISE changes since 2/14/23 meeting potential topic discussions FY24 BUDGET -DRAFT 22,660.10 transfers in for direct expenses out SEWER ENTERPRISE Org Code/Acct. FY20 ACTUALS FY21 ACTUALS FY22 ACTUALS FY23 APPROVED BUDGET fy23 sub- categories FY23 ACTUAL BUDGET YTD FY23(received/ expended) 12/27/22 YTD fy23sub- categories FY24 DRAFT BUDGET fy24 DRAFT sub- categories INCR/DECR FY24 OVER FY23 BUDGET increase REVENUES Munis as of 12/27/22 (week 26 of 52 - 50%) 50% 1 User Charges (YTD is 50% based on Commitmts)60004 422000 864,269.00$ 999,816.95$ 1,022,477.05$ 1,101,600.00$ 1,101,600.00$ 549,330.93$ 1,130,000.00$ $28,400.00 2.87% 1aRATE INCREASE FOR DISCUSSION -$ -$ 0.00 1bDeduct meter fee 60004 422000 1,650.00$ 2,600.00$ 2,450.00$ 2,550.00$ 2,550.00$ 2,600.00$ 2,800.00$ $250.00 11.63% 2 Connection Fees 60004 432200 36,950.00$ 46,440.00$ 37,050.00$ 15,000.00$ 15,000.00$ 8,850.00$ 17,000.00$ $2,000.00 12.70% 3 Sewer Bank Fees - I/I 60004 433500 9,460.00$ 12,100.00$ 9,900.00$ 5,300.00$ 5,300.00$ 2,200.00$ 5,300.00$ $0.00 0.00% 4 Penalties & Interest 60004 417000 10,730.17$ 13,209.40$ 11,750.36$ 10,300.00$ 10,300.00$ 4,695.13$ 10,300.00$ $0.00 0.00% 5 Drain Layer Fees 60004 432000 600.00$ 1,400.00$ 1,500.00$ 600.00$ 600.00$ 200.00$ 600.00$ $0.00 0.00% 6 Grease Trap Annual Permit fees 60004 432100 8,100.00$ -$ -$ 3,650.00$ 3,650.00$ 3,700.00$ 2,850.00$ -$800.00 0.00% 6aGrease Trap permit fees-non-compliance60004 432100 2,075.00$ 250.00$ 150.00$ -$ -$ 50.00$ -$ $0.00 0.00% 7 Investment Income 60004 480100 21,602.44$ 6,771.78$ 6,181.06$ 5,000.00$ 5,000.00$ 3,443.96$ 6,000.00$ $1,000.00 25.00% 8 Highfield Capacity payments (11/19-pd off 7/20)60004 423000 2,850.64$ 68,097.59$ - - -$ -$ $0.00 0.00% 8aReserve Capacity Fees -new un-bettered connections60004 423000 4,525.40$ 4,319.70$ 1,645.60$ - - 411.40$ -$ $0.00 0.00% 8bReserve Capacity Fund transfer(cover JFHwy debt)FUND 8132 9,993.00$ 7,513.66$ 20,965.40$ 20,962.00 20,962.00 20,962.00$ 20,962.40$ $0.40 0.00% 9 Sewer Bank -Stabilization fund transfer FUND 8133 -$ -$ 9,900.00$ $9,900.00 0.00% 10Capital reserve fund transfer FUND 8138 20,000.00$ 20,000.00$ 20,000.00$ 20,000.00$ 20,000.00$ 35,000.00$ $15,000.00 75.00% 11ARPA FUNDING REQUESTS 11aPump Station upgrades 300,000.00$ 11bManhole repairs 200,000.00$ 11cMobile Generator 90,000.00$ 11prior year revenues 2,745.82 65,934.30$ $0.00 0.00% Total Revenues $975,551.47 $1,182,519.08 $1,200,003.77 $1,184,962.00 $1,184,962.00 $1,184,962.00 $616,443.42 $616,443.42 $1,830,712.40 $1,830,712.40 55,750.40 5.22% $1,240,712.40w/o ARPA ^^doesn’t include ARPA on track for maybe 1,045,110 FY23 1b) current participants(1/26/23)-54 (5 more than FY22) @ $50 annual charge for irrig meters (approx 54 meters @$50 each=2700) -allow for 2 more signing up(56 @2800) 5) Drain layer fees -level funded 6a) cannot budget for non-compliance 8b) Reserve Capacity transfer (HV funds) to pay JF Hwy debt service FY23(20,962.40)-(balance remaining in Res Cap Stab Fund $7001.11. 9) Sewer Bank I/I transfer from Stability Fund - $9900 from FY22 transfer at STM (if unused by EOY, transfer back at 2024 STM) 10) Capital reserve transfer from stab fund to cover unplanned capital expenses(>$5K)-expense line Purchase of Services-1b -if not used by EOY, transfer back into Stab Fund at STM 11) ARPA FUNDING - Submitted to Select Board October 2022 11a) Pump Station Upgrades -ARPA funds will be used upgrade the aged pump station controls, pumps, and standby generators. 11b) Manhole Repairs - ARPA funds will be used to make repairs to sewer manholes to prevent infiltration and inflow of outside water sources. This includes engineering to help produce a contract. PAYROLL Munis as of 12/27/22 (week 26 of 52 - 50%) 50% Business Manager -tbd 60001 511000 65,101.76 65,387.52 67463.28 67,464.00$ 68,925.00$ 33,274.08 57,712.32 $0.72 0.00% Business Manager-longevity - tbd 60002 514000 1,627.54 2,975.41 1686.58 2,024.00$ 2,068.00$ 2,067.75 1,442.81 $337.42 20.01% Business Manager Assistant (p/t)- tbd 60001 511000 0.00 8,513.28$ 27,456.00$ 28,479.00$ 13,430.34 26,307.84 $13,056.00 90.67% Sewer Commission - Clerk 12.5 hrs/mo 60001 511003 2,435.86 1,653.70 1837.42 2,972.00$ 2,529.00$ 752.82 3,123.00 $86.00 0.00% potential increases-Sal study, COLA increases - $ 2,085.00$ 4,429.30 $0.00 0.00% Total Payroll 69,165.16 70,016.63$ 79,500.56$ 102,001.00$ 102,001.00$ 102,001.00$ 49,524.99$ 49,524.99$ 93,015.27$ 93,015.27$ $13,480.14 15.60% Business Manager - assuming Step 2 of Gr 11(27.64)(PB) w potential sal increases/COLA Business Mgr longevity-tbh (if PB = longevity = 2.5% annual salary until FY25(reach 20 years- 3%) ) Assistant Bus Mgr- Part-time 24 hrs/week(1248/yr) - tb hired at estimated $20.28/hr (step 1 of gr 5) fy23. Then $20.90 (step 2 of gr 5) FY24 52 weeks w potential sal increases/COLA COLA reserve/Salary Study FY23 - assuming at least a 3.5% increase due to COLA/Salary Study 4) penalty fees(demand chgs & interest on quarterly bills)-level funded 6) DISCUSS PROPOSED FEE STRUCTURE- Grease trap permit fees -collected $5300 FY19, $7200 FY20; fees waived FY21, FY22; FY23 only non-compliant FSE's(budget $3650);FY24 assuming $150 Annual Permit Fee - 19 Establishments @$150=$2850 7) Investment income -at 3443 as of 12/31/22 - at approx same rate total $6886; assume market adjmt -set at $6000 8) n/a Reserve Fund - Highfield Capacity payments for allocation- paid in full July 2020(money transferred to Reserve Capacity fund STM 11/20) 8a) Reserve Capacity Fees to reserve funds from newly connecting parcels not previously bettered nor accounted for in original capacity #'s w/Leominster & Fitchburg, to offset increase costs at IMA negotiations. Removed from budget as monies not used in current year and moved to Stabilization at Special Town Meeting (starting 2019 STM once FY closed) and not considered a 'yearly' expense, unlike I/I expenses required by State statute. This income applied to future capacity costs by Stabilization transfer. 11c) Mobile Generator - ARPA funds will be used to purchase a mobile generator set. The generator will be capable of providing full electrical power to our 10 pump stations in the event of an electrical power failure and a failure of the existing generator at the pump station it is needed at. The generator will be mounted on a trailer that is towable by a truck. It will be stored at the DPW. 12) Prior Year revenues(unbudgeted) to track revenue recd for previous years bills include Tax Liens redeemed, Penalty interest tax, Fines/Fees (414200, 417800,471300) Minutes help - hired for 12.5hrs/mo(150/yr) 7/1/19 for $3123 for FY24 w potential sal increases/COLA 3) Sewer Bank fee -based on 4BR home x 6 new cnxns ($880 x6)=$5280(rounded to 5300) and since this is expected to be spent during FY24, it can be posted as Revenue-unlike Reserve Capacity fees which are transferred after EOY to Stab Fund CURRENT CUSTS= 927 ( 133-Fitch,794-leom as of 1/24/22) . For purpose of this DRAFT BUDGET and Sewer Usage (line 1) and Connections(line 2): we are assuming 13 new connects for remainder of FY23 -(7 recent conns not reflected in fy23 usage yet) 4 w/permits in place-conn fees recd-all Leom)-expect 2 more not yet permitted- total fy23 =13 Leom; 6 during FY24 (1-Fitch, 5-Leom) for total of 19 new or TOTAL 946 (@2% growth) TOTAL expected 946 customers by end of year FY24; (without 711 Mass Ave(8 townhomes/1325 Mass Ave-Commercial facilities/361 Mass Ave-LUFA farms/40B) 1) Sewer User Charges as of 1/12/23 -FY23 to date $549331 after 2 qtrs (Q3/Q4 historically 94% for Q3/4 but not for FY22); estimated fy23 income $1,098,662 w/2% increase in custs(19) = $1,120,635 rounded up to $1,200,000. ERROR? In estimate, we rounded 1.120M to 1.2M(98k) -would prefer to put user charges at $1,130,000 (28k increase) 1a) 10% Rate increase processed for FY21 budget(eff 7/1/20; 8% rate increase for FY23 of 8%(eff 7/1/22); Anticipating implementation of regular rate increase of 2-3% every other year after FY23. No increases yet published for L/F for FY24 2) conn fees(6) for FY23 (1 Fitchburg, 5 Leom(residential) -6 regular conns(assuming 4BR) @ 2800x6=16800-round to 17,000) https://lunenburgma.sharepoint.com/sites/DPWSewer/Shared Documents/BUDGET/1-FY24 BUDGET PREP/Draft FY24 updtd budget for SC meeting 022823.xlsx ===PAGE 2=== Draft FY24 updtd budget for SC meeting 022823.xlsx/fy24 DRAFT budgt w desc 022823 TOWN OF LUNENBURG - SEWER ENTERPRISE changes since 2/14/23 meeting potential topic discussions FY24 BUDGET -DRAFT 22,660.10 transfers in for direct expenses out SEWER ENTERPRISE Org Code/Acct. FY20 ACTUALS FY21 ACTUALS FY22 ACTUALS FY23 APPROVED BUDGET fy23 sub- categories FY23 ACTUAL BUDGET YTD FY23(received/ expended) 12/27/22 YTD fy23sub- categories FY24 DRAFT BUDGET fy24 DRAFT sub- categories INCR/DECR FY24 OVER FY23 BUDGET increase PURCHASE OF SERVICE as of 1/17/23 (week 29 of 52 - 56%) 56% 1 Infrastructure 60002 531006 92,152.03 67,999.10 29,128.05 64,100.00 64,100.00 19,658.39 99,100.00 $35,000.00 54.33% 1a - Pump station general repairs (incl. generators, wetwells)47,238.26 3,442.01 3,982.50 10,000.00 7,058.73 20,000.00 $10,000.00 100.00% 1b - UNPLANNED major repairs/replacement(>$5k)-funded by Cap Res Stab Fund 35,898.08 22,136.89 7,700.00 20,000.00 5,937.60 35,000.00 $15,000.00 75.00% 1c - Sewer lines-jetting, camera 5,395.50 5,380.00 6,360.00 5,000.00 3,250.00 15,000.00 $10,000.00 200.00% 1d - Manhole repairs 2,336.00 13,886.90 3,400.00 10,000.00 0.00 10,000.00 $0.00 0.00% 1e - Sewer stub installation 0.00 14,590.00 0.00 10,000.00 0.00 10,000.00 $0.00 0.00% 1f - Police details-manholes, flow meters, confined space 783.19 3,163.30 2,285.55 3,000.00 643.06 3,000.00 $0.00 0.00% 1g - Meter Pits/Flow meters 0.00 5,400.00 5,400.00 5,400.00 2,700.00 5,400.00 $0.00 0.00% 1h - Meter program licensing-moved to Outsourcing FY22 0.00 0.00 0.00 0.00 0.00 0.00 $0.00 0.00% 1i - Office asset expenses 0.00 0.00 0.00 400.00 69.00 400.00 $0.00 0.00% 1j - DPW asset expenses 0.00 0.00 0.00 300.00 0.00 300.00 $0.00 0.00% 2 I/I remediation 60002 531059 0.00 9,796.50 $0.00 10,000.00 10,000.00 10,000.00 0.00 0.00 10,000.00 10,000.00 $0.00 0.00% 3 Outsourcing - contracts for services 60002 531060 69,201.88 78,619.14 $89,839.04 97,014.00 97,014.00 43,043.18 141,100.00 $44,086.00 48.24% 3a - Pump Station contract Year 1 of 3 62,166.88 73,794.14 82,160.04 85,444.00 42,723.18 120,000.00 $34,556.00 40.83% 3b - Generator maintenance contract 6,180.00 4,825.00 6,825.00 4,970.00 0.00 7,000.00 $2,030.00 40.85% 3c - Administrative consulting services-NEW 0.00 0.00 0.00 0.00 0.00 12,000.00 $12,000.00 3d - Bill print/mail services 0.00 0.00 0.00 4,000.00 0.00 0.00 -$4,000.00 -500.00% 3e - Meter reading licensing 501.00 514.00 529.00 600.00 0.00 600.00 $0.00 3f - Pump station -grounds 855.00 0.00 0.00 1,000.00 0.00 500.00 -$500.00 -74.07% 3g - Stub locating services 325.00 1,000.00 320.00 1,000.00 $0.00 100.00% 4 Legal Counsel 60002 531005 10,570.30 6,410.56 5,614.79 5,000.00 5,000.00 5,000.00 2,074.88 2,074.88 5,000.00 5,000.00 $0.00 0.00% 5 Engineering Services 60002 531061 9,960.00 9,960.00 26,525.46 30,000.00 30,000.00 4,980.00 35,000.00 $0.00 0.00% 5a - General consulting services 0.00 16,565.46 20,000.00 0.00 30,000.00 $10,000.00 60.33% 5b - Flow metering annual contract 9,960.00 9,960.00 10,000.00 4,980.00 5,000.00 -$5,000.00 -50.00% Total Purchase of Service 181,884.21 172,785.30 151,107.34 206,114.00 206,114.00 206,114.00 69,756.45 69,756.45 290,200.00 290,200.00 163,172.00 82.66% 84,086.00 1b) UNPLANNED/unexpected major part/repairs costs greater than $5k, funded by Stabilization Fund transfer(see above)-FY24 increase to $35K-system getting older, pump station/generators 1f) Police details - depending on road activity -at least 5x a year(flow meter inspections), jetting. FY24 Level fund 1g) Meter Pits/Flow Meters - equipment repair/replace/upgrade per lease from Flow Assmt ($5400 for FY22,FY23). FY24 level fund while we await confirmation 1i) Office hardware (2 emps)- desk/filing needs, lighting, calculator, file cabs/boxes (off-site-Passios) 1j) various DPW Infrastructure upgrades -hardware,paint,roof repairs 2) I/I remediation - we have $9900 to spend from FY23 funds- level funded 3) Outsourcing - 3a) PUMP STATION COVERAGE - NEW CONTRACT-NEED TO GO OUT FOR BID (previously $82,160 Yrs 1 & 2, 85,443.44 for Year 3)- estimate $120,000K 3b) GENERATOR COVERAGE (FY21 $4825)-every other year fuel analysis 2K=6825 FY22 (not billed for FY22 fuel $2k yet), FY23 budget $4970; FY24 budget $5,000(generator maint, $2000 fuel (every other year) 3c) NEW Admin services - prior Business Manager available for consultation - $60/hr for 200 hours = $12K 3d) Billing Support-had previously discussed Outsourcing BILL PRINT/MAIL -NDS quote 9/21/18 print/mail services - 2240/yr + 1400(avg) 1st yr -setup = 3640 (2yrs later-estimate at $4000 )- ON HOLD 3e) Meter reading licensing - NDS (reading capabilities - yrly chg software (NDS)$501 FY20, $514 FY21, $529 Fy22,increase fy23 to $600;FY24 level fund and moved from Infrastructure 3f) Pump stations - grounds - raking, upkeep 3g) outsourcing stub location services -FY24 Level Fund 4) Legal counsel - $5000 budgeted historically. FY20 was $10,570.30, FY21 6410.56 - increase or level fund? (Leom IMA to be re-negotiated - expires 6/24/24(25yr agreement)) 5) Engineering Services - 5b) Flow Assessment annual contract on Flow Meter maint -remaining at same cost ($9960/yr for FY23 per FA 2/1/22) UTILITIES as of 1/17/23 (week 29 of 52 - 56%) 56% Postage 60002 534400 1,840.80 2,184.79 2,068.57 2,200.00 2,200.00 1,157.56 2,300.00 $100.00 4.55% Electricity (10 Stations) 60002 521011 31,542.71 32,788.17 34,076.40 35,000.00 35,000.00 14,449.67 35,000.00 $0.00 0.00% Water (3 Stations) 60002 523001 3,216.00 3,638.00 3,763.00 4,000.00 4,000.00 2,489.00 5,000.00 $1,000.00 25.00% Telephone/Internet (10 Stations) 60002 521014 3,533.32 3,581.03 3,698.57 4,000.00 4,000.00 2,048.22 4,000.00 $0.00 0.00% Diesel Fuel (10 stations) 60002 521012 139.46 0.00 0.00 400.00 400.00 0.00 400.00 $0.00 0.00% Total Utilities 40,272.29 42,191.99 43,606.54 45,600.00 45,600.00 45,600.00 20,144.45 20,144.45 46,700.00 46,700.00 1,100.00 2.35% 1) Postage at $1157.56 projects out to $2300 2) Electricity at 14,450 projects out to $28900; level fund at $35,000 3) Water - current costs are $4600 (3500 for year for meter readings, 900 water usage 200 backflow testing; assuming increase 4) Telephone increase year to year (fy20 3500, fy21 3600, fy22 3700; fy23 budget 4000-level fund FY24 6) Diesel for generators - level fund 1e) Sewer stub installation - when we get a request to connect and no stub can be located - if they've paid a betterment, we owe them a stub. FY24 Level fund 1h) Meter reading investments(orig for Irrig Meter potential costs), then NDS license-moved under Outsourcing 5a) Engineering Consulting services -put up to $30k -with projects will need engineering support (pump station upgrades, 40B consultation) 1d) Manhole repairs - anticipate 10 covers/year -approximately $10,000. FY24 Level fund 1) Infrastructure includes the following subcategories and and carries balance for emergency repairs/unplanned capital costs >$5K. 1a) Pump Station Electrical/Mechanical repairs (outside contract) - emergency repairs, safety checks/repair, Stations/lines, Generator repairs, clean & maintain Wet Wells; FY24 upped to $20K for Generator repairs 1c) Sewer lines -jetting-pressure clean main lines, camera'ing in response to issues;-Maintenance plan recommendation to jet lines over entire town over 5 years. FY24 increase to $15K to cover 1/8 of town lines https://lunenburgma.sharepoint.com/sites/DPWSewer/Shared Documents/BUDGET/1-FY24 BUDGET PREP/Draft FY24 updtd budget for SC meeting 022823.xlsx ===PAGE 3=== Draft FY24 updtd budget for SC meeting 022823.xlsx/fy24 DRAFT budgt w desc 022823 TOWN OF LUNENBURG - SEWER ENTERPRISE changes since 2/14/23 meeting potential topic discussions FY24 BUDGET -DRAFT 22,660.10 transfers in for direct expenses out SEWER ENTERPRISE Org Code/Acct. FY20 ACTUALS FY21 ACTUALS FY22 ACTUALS FY23 APPROVED BUDGET fy23 sub- categories FY23 ACTUAL BUDGET YTD FY23(received/ expended) 12/27/22 YTD fy23sub- categories FY24 DRAFT BUDGET fy24 DRAFT sub- categories INCR/DECR FY24 OVER FY23 BUDGET increase OTHER DEPARTMENTAL EXPENSES as of 1/17/23 (week 29 of 52 - 56%) 56% 1 Advertising 60002 534500 120.00 120.00 105.00 200.00 200.00 200.00 105.00 150.00 200.00 200.00 $0.00 0.00% 2 Supplies-Office 60002 540000 797.69 807.62 647.70 800.00 800.00 800.00 293.62 497.11 800.00 800.00 -$40.00 -4.76% 3 Supplies-Field 60002 541018 436.40 145.97 221.29 300.00 300.00 300.00 177.52 177.52 300.00 300.00 -$150.00 -33.33% 4 Professional meetings/Subscriptions/dues 60002 573000 55.00 55.00 60.00 100.00 100.00 100.00 0.00 0.00 100.00 100.00 $40.00 66.67% 5 CAPITAL PLAN 60002 583200 5a - Capital Expenditures-planned-non ARPA60002 583200 0.00 50,907.47 50,000.00 50,000.00 49,850.00 714.48 714.48 96,000.00 96,000.00 $46,150.00 70.43% 5b - ARPA FUNDED- Pump Station upgrades 300,000.00 300,000.00 $300,000.00 5c - ARPA FUNDED- Manhole repairs 200,000.00 200,000.00 $200,000.00 5d - ARPA FUNDED- Mobile Generator 90,000.00 90,000.00 $90,000.00 6 CAPITAL COSTS-LEOMINSTER- debt service 60002 583000 34,360.29 38,197.32 41,000.00 41,000.00 41,000.00 0.00 0.00 56,000.00 56,000.00 $15,000.00 39.27% 7 Capital costs-JFHwy improvement-loan portion Fitchburg 60002 583000 20,963.20 20,965.40 20,962.00 20,962.00 20,962.00 20,961.80 20,961.80 20,962.40 20,962.40 $0.40 0.00% 8 Leominster Usage 75% YTD 60002 521006 309,395.15 362,768.58 492,604.98 520,000.00 520,000.00 512,077.00 302,201.60 302,201.60 520,000.00 520,000.00 $7,923.00 1.61% 9 Fitchburg Usage 58% YTD ( 7 of 12) 60002 521006 158,084.41 188,679.30 204,020.06 220,000.00 220,000.00 220,000.00 120,389.14 143,022.54 220,000.00 220,000.00 $0.00 0.00% 10Leominster Connection Fees 60002 523004 9,300.00 13,500.00 11,250.00 3,750.00 3,750.00 3,750.00 2,250.00 2,250.00 3,750.00 3,750.00 $0.00 0.00% 11Fitchburg connection fees 60002 523004 4,000.00 6,000.00 2,000.00 2,000.00 2,000.00 2,000.00 0.00 0.00 2,000.00 2,000.00 $0.00 0.00% 12Registry of Deeds recording fees 60002 531007 105.00 0.00 105.00 105.00 105.00 105.00 0.00 0.00 105.00 105.00 $0.00 0.00% 13Mileage 60002 571000 199.86 155.59 230.54 250.00 250.00 400.00 167.07 167.07 400.00 400.00 $0.00 0.00% $0.00 14Indirect General Fund Exp. 105,976.15 $0.00 0.00% 15 General Fund Transfer 60002 575004 18,111.00 17,975.00 18,790.82 21,625.00 21,625.00 21,625.00 21,625.00 22,709.17 22,709.17 $1,084.17 5.77% 16 Fringe Benefits / Health Ins. 60002 570001 37,529.00 38,987.00 44,517.69 69,239.25 69,239.25 48,824.15 48,824.15 49,067.66 49,067.66 $243.51 0.43% 17 Director/Superintendent (.15)* 60001 511000 14,723.00 15,262.00 14,673.42 15,111.90 15,111.90 14,541.88 14,541.88 15,504.67 15,504.67 $392.77 2.68% Total Miscellaneous Expense 574,263.91 700,237.55 899,296.69 965,443.15 965,443.15 957,520.15 532,251.26 555,133.15 1,597,898.90 1,597,898.90 660,643.85 71.19% 1) Advertising - posting of hearings, bid posting, vacancies-level fund 70,643.85w/o ARPA 2) Office supplies -- paper, toner, envelopes,filing supplies--level fund 3) Field Supplies-by contractor (pest control, cleaning, paints) -level fund 4) Professional Meetings/Training/Subscriptions for training, meetings, newspaper-level fund 5) CAPITAL EXPENSE LINE - PLANNED Capital Improvements - added FY22 5a Capital expenditures - for planned Capital projects; FY22-$100K, FY23-$50K- FY24 $96,000(in case no ARPA funds recd-56K for Pump station upgrades, $40K for Manhole maintenance) 6) Debt service to Leominster (1st pmt FY21-$34,360.29) (Leominster's projections Jan 2022: FY22 actual 38197.32, FY23 expected $40,583,estimate FY24 $55038.12(addl debt coming due) ( estimated based on 2.5% of Leom flow)-FY24 fund at $56K 7) Capital costs for JFHwy improvement -Oct 2023 inv(FY24) will be $20,962.40 -year 5 of 20 (covered by Highfield Village $68K payment recd 7/20)-last year covered in full by HV pmt 10) Leom cxns - assuming 5 new conns in fy24 (5 res, @ 750ea =$3750 11) Fitchburg cxns -$2000 fee per connection; 1 anticipated 12) Registry of Deeds - recording expenses $105/document (LIENS, PRIVILEGE FEES, AGREEMENTS)-level fund 14) Estimated Indirect costs-per Town Accountant 1/10/23 17) DPW Payroll costs for DPW Director paid under Indirect costs (Salary study underway on SAP -built in 3.5% increase) ANNUAL TOWN MEETING TRANSFERS(see below): CAPITAL RESERVE TRANSFER (3% OF REVENUES started in FY18) chgd to 2% for FY24 OPEB funding new FY19-transferred 10% of Town's allotment in FY19; same? - put in for $1000 at this time? Total Line Item Expenses 985,231.47 1,173,511.13 1,319,158.15 1,311,235.15 671,677.15 694,559.04 2,027,814.17 2,027,814.17 242,839.77 Total Line Item Revenues 1,182,519.08$ 1,200,003.77$ 1,184,962.00 1,184,962.00 616,443.42 616,443.42 1,830,712.40 1,830,712.40(15,608.26) SURPLUS(DEFICIT) BEFORE BETTERMENT/DEBT SERVICE197,287.61 26,492.64 (134,196.15) (126,273.15) (55,233.73) (78,115.62) (197,101.77) (197,101.77) 15) Gen Fund transfer = percentage of costs borne by Town for Sewer personnel, facilities, services. , DPW costs, Administrative (Treasurer/Accountant offices, Liability Ins, Office space) - per Accountant- Liability Insurance is currently level funded in the target budget and could change once we know what the premium is for FY24 (built in 3.5% increase) 16) Fringe benefits for personnel (retirement,health ins) - per indirect cost sheet from Accountant; The current estimate for health insurance but could change once numbers firmed up for FY24 (built in 3.5% increase) Reserve Capacity Transfer from Stabilization Fund - SC planned(spring 22) to transfer 20% of current Stabilization fund balance (Balance 1/31/23=$27,963.51) for the next 5 years (to defray JFHwy costs) = @ $5593 plus addl 2007 =$8000 8) Leominster Usage-FY23 at $302,202(for 3 qtrs) projects to $402,936 for full year BUT it was a VERY dry year to date(FY22 as at $353,800K at this same time(proj'd to $471733 for year); last rate increase effective 3/1/21 (2.7% to 5.32ccf)-estimate another 3% increase, using FY22 as base($471733x3%= 485,885, plus 2% increase in customers $495,602; currently funded at $512,077 FY23 - increased to $520K FY24 9) Fitchburg usage - curr amt $120,389 projected = 206,381, dry year (rate increase each june since 2018(2018-8%,2019-8%, 2020-7%,2021-7%,2022-6%; per MM of Fitchburg 2/23/23-probable 4% increase ea yr over next 5 yrs(FY24-28); even w/dry year estimate $206,381, add in .5% growth and 4% rate increase -still less (215,709) than FY23 budgeted $220,000-level fund FY24 13) Mileage - Bus. Mgr/Asst. Bus Mgr-mileage to/from DPW to TH, PO, Passios (meter),Registry,misc accts (easement docs), meetings/workshops, that employees required to attend (no add'l pay) - current budget FY23 at $400-level fund https://lunenburgma.sharepoint.com/sites/DPWSewer/Shared Documents/BUDGET/1-FY24 BUDGET PREP/Draft FY24 updtd budget for SC meeting 022823.xlsx ===PAGE 4=== Draft FY24 updtd budget for SC meeting 022823.xlsx/fy24 DRAFT budgt w desc 022823 TOWN OF LUNENBURG - SEWER ENTERPRISE changes since 2/14/23 meeting potential topic discussions FY24 BUDGET -DRAFT 22,660.10 transfers in for direct expenses out SEWER ENTERPRISE Org Code/Acct. FY20 ACTUALS FY21 ACTUALS FY22 ACTUALS FY23 APPROVED BUDGET fy23 sub- categories FY23 ACTUAL BUDGET YTD FY23(received/ expended) 12/27/22 YTD fy23sub- categories FY24 DRAFT BUDGET fy24 DRAFT sub- categories INCR/DECR FY24 OVER FY23 BUDGET increase SEWER DEBT SERVICE 687,992.32$ 687,992.32 $ ANTICIPATED BETTERMENT REVENUES 430,042.00 485,026.06 $ TOWN'S PORTION 73,039.00 73,040.00 $ TOTAL ANTICIPATED BETTERMENT REVENUES 503,081.00 558,066.06 $ DEFICIT OF BETTERMENT REVENUE vs DEBT SERVICE -184,911.32 (129,926.26) $ LESS BUDGETED SURPLUS -134,196.15 (197,101.77) $ RETAINED EARNINGS TO BE APPROPRIATED -319,107.47 (327,028.03) $ TRANSFER TO CAP RESERVE(2% revenues)STABILIZATION FUND- (35,548.86)$ (36,614.25)$ 37,221.37$ TRANSFER TO OPEB TRUST $ (656.00) (1,000.00)$ TRANSFER TO STABILIZATION FUND- RESERVE CAPACITY(20% of Res Cap Stab Fund) (8,000.00)$ TOTAL RETAINED EARNINGS APPROPRIATION $ (355,312.33) $ (372,642.28) OPEB Trust Fund initiated for FY19 Budget transfer $656 ( derived from using formula= 10% of the $6559 annual cost of 10% as Town) (197,101.77)$ exp/revs (36,614.25)$ 2% Cap Res RETAINED EARNINGS BALANCE YEAR-END FY22 2,232,978.00 (1,000.00)$ OPEB (8,000.00)$ 20% Res Cap (242,716.02)$ current deficit RETAINED EARNINGS BALANCE YEAR-END FY14546,838.00 RETAINED EARNINGS BALANCE YEAR-END FY151,239,995.00 RETAINED EARNINGS BALANCE YEAR-END FY161,376,364.00 RETAINED EARNINGS BALANCE YEAR-END FY171,655,572.00 RETAINED EARNINGS BALANCE YEAR-END FY181,929,110.00 RETAINED EARNINGS BALANCE YEAR-END FY191,972,578.00 RETAINED EARNINGS BALANCE YEAR-END FY202,023,242.00 https://lunenburgma.sharepoint.com/sites/DPWSewer/Shared Documents/BUDGET/1-FY24 BUDGET PREP/Draft FY24 updtd budget for SC meeting 022823.xlsx