Canton, Massachusetts · Saved source text
FY23 Municipal Budget - Dept Requests - Jan 2022 zip file
Saved text from 202 source pages. Transcription and OCR may contain errors; verify figures and wording against the original. Retrieved 2026-10-15.
Tab 31 - Water Enterprise and Debt Service and Chargebacks.pdf · Source page 3
TOWN OF CANTON BUDGET REPORT FOR FY 2023 DEPARTMENTAL WORKSHEETS SUBTOTAL WATER ENTERPRISE Date: 12/1/2021 FY19 FY20 FY21 ORIGINAL ACTUAL YTD FY 2023 FY 2023 COMMENT/REASON FOR ACTUAL ACTUAL ACTUAL BUDGET EXPENSE THRU DEPARTMENTAL DEPT INCREASE / DECREASE, EXPENSE EXPENSE EXPENSE FY22 11/30/2021 BASE BUDGET REQUEST $4,754,141 $4,916,217 $4,534,480 $5,150,875 $1,997,945 $5,294,282 S, 346 7 744 We. Helter ta -adle-A/ W:\Munis\MCR Library\Budget reports\2020\New Fiscal Year budget worksheet -Dept Req-enterprise by sal-exp.rpt Dept Head Signature / Date Page: 7
Tab 31 - Water Enterprise and Debt Service and Chargebacks.pdf · Source page 4
ENTERPRISE FUNDS INDIRECT COSTS FOR FY 23 FY 22 FY 23 FY 23 FY 23 BUDGET Water Allocation| % of Budget] [Sewer Allocation] % of Budget| [Rink Allocation] % of Budget Basis for allocating indirect costs 1 |HEALTH INSURANCE $13,143,953 $ 479,606 1.4% $ 103,563 0.8% $ 1,760 0.0% FY 22 accumulator report & budgeted salaries PENSION (Norfolk County) $ 6,463,772 $ 209,611 3.2% $ 118,586 1.8% $ 6,179 0.0% FY 22 Pensionable Wages X 24.2% SHARED EMPLOYEES 3 Executive $510,826 $ 27,124 5.3% $ 415,822 3.1% $ 2,260 0.4% Dept EE’s / 226 Town Employees 4 Accountant $ 273,787 $ 12,681 46% $ 13,343 4.9% $ 605 0.2% Prior Year Total Expenditures / Total Town Exp. 5 Finance Director $ 229,115 $ 10,612 4.6% $ 11,166 4.9% $ 507 0.2% Prior Year Total Expenditures / Total Town Exp. 6 Collector/Treasurer $ 229,119 $ 11,956 5.2% $ 11,360 5.0% $ 263 0.1% Prior Year Total Revenues / Total Town Revs. 7 Human Resources $ 191,594 $ 10,173 5.3% $ 5,934 3.1% $ 848 0.4% Dept EE's / 226 Town Employees 8 Legal Services $ 299,440 $ 15,899 5.3% $ 9,275 3.1% $ 1,325 0.4% Dept EE's / 226 Town Employees 9 Information Technology $628,302 $ 4,368 0.7% $ 2,184 0.3% $ 874 0.1% MUNIS Support Costs. 10: Dept of Public Works $ 3,211,826 $ 92,831 2.9% $ 62,693 2.0% $ - 100.0% From DPW Superintendent TOTAL SHARED EMPLOYEES $ 5,574,009 $ 185,644 3.3% $ 131,777 2.4% $ 6,681 0.1% OTHER 1 11 Workers' Comp Insurance $ 410,500 $ 28,491 6.9% $ 11,846 2.9% $ 4,105 1.0% From NorthStar 12 Building & Contents Insurance $ 225,264 $ 27,132 12.0% $ - 100.0% $ 9,307 4.1% From NorthStar (statement of values) 13 Vehicle Insurance $ 172,012 $ 11,280 6.6% $ 3,760 2.2% $ 940 0.5% $940 per vehicle 14 Retirement Buyback $ 80,000 $ 2,594 3.2% $ 1,468 1.8% $ = 0.0% Pension %'s 15 Unemployment Compensation $ 100,000 $ 1,606 1.6% $ 913 0.9% $ 199 0.2% Total Dept Salaries / Total Town Salaries 16 OPEB $ 5,055,914 $ 96,489 1.9% g 57,582 1.1% $ : 100.0% Actuarial Study Updated June 2021 TOTAL OTHER 1 $ 6,043,690 $ 167,593 2.8% $ 75,569 1.3% $ 14,551 0.2% TOTAL $31,225,424 $ 742,455 2.4% $ 429,495 1.4% $ 28,171 0.1% $ 353,237 $ 207,346 $ 27,232 Enterprise Chargebacks for FY '23.xlsx DOR version 12/27/2021
Tab 31 - Water Enterprise and Debt Service and Chargebacks.pdf · Source page 5
"PAYROLL PROJECTIONS - FY 2023
Payroll Projections FY23.xIsx
11/30/2021
New FY2S
FY22 Pay hourly rate with} FY23 Annual
Employee Job Class Hours | Hourly FY22 Pay FY23Next | FY23Next | step and/or Salary (261 FY23
Number Last Name First Name Cote Job Class Code Desc Location Code Desc Group/Bu Ore Object Status | Pay Grade |PayStep| Per Year Rate Annual Salary Grade Step COLA days) Longevi
1824 QUINEAN: KELSEY 4118 {GIS COORDINATOR, WATER Pc 56100 51000 FT. GIs. oO 624 32.00 19,972 GIs oO 32.97 20,652 a
51000 Total 19,973) 20,652 o
297 KIELY. BRIAN 4503 | WATER FOREMAN WATER, AF 56100 51120 tas F-40 20 2080 45.01! 93,621 F-40 20 45.01 93,981, 1,750)
1474 RUANE RENEE 4550 __ {WTR TREATMNT PLNT FOREMAN. WATER AF 56100 51120 FT F-40 44 2080, 4181 86,965 F-40 15 42.43 88,594 800
1184 ISYKES [CHRISTOPHER 4501 __|WATER/SEWER SUPERVISOR WATER AF 56100 51120 FT E-40 14 1040 48.78 50,731 E40 is 49.50 51,678 1,100)
51120 Total 231,317 234,253 3,650
42 JARMANDO- GARY. 4506 __|SKILLED LABORER/TRUCK DRIVER WATER AF 56100 541223 FT 340 16 2080 31.58) 65,686 3-40 16 31.58 65,939 4,500)
1434 BOGUE CONOR 4554 (UTILITIES MAINTENANCE TECHNICI WATER AF 56100 54123 FT 140 4 2080. 28.82! 59,946 40 6 61,095 650)
2034 DURE RONALD 4508 }|METER READER WATER AF 56100 $4123 FT K-40 4 2080 24,04) 50,003 |: K40. 5 50,905 oO
ae LENHART peHAREES 4402 | UTILITIES MAINTENANCE TECHNICi WATER, AR 56100 51123 FT. 140 22 2080 37,83, 78,686 [22 | —bdo= 2 Cel wiyl 094
384 |MICCARRICK STEVEN A504 _|WTR TREATMNT PLANT OPERATOR WATER AF 56100. 51123 FT 1-40 22 2080 37.83) 78,686[5. | 140 22 78,989 4,750}
1867 MICHAELS, KEVIN 4504 |WTR TREATMNT PLANT OPERATOR WATER. AF $6300 $1123 FT 1-40 4 2080 28.82 59,946 [52 1-40 5 61,074, 650)
1279 IMITCHERONEY, MICHAEL 4554 | UTILITIES MAINTENANCE TECHNICI WATER AF 56100 51123 FT 1-40 4 2080 28,82) 1-40 EY $1,074 650)
1653 REDQUEST SCOTT A208 |SPECIAL HEAVY EQUIP OPERATOR [WATER AF 56100 $1123 FT 1-40. 4 2080 33.44 1-40 15 70,888 650)
697 SMITH JOSEPH 4554 | UTILITIES MAINTENANCE TECHNICI WATER AF 56100 51123, FT 1-40 22 2080 37.83 1-40 22 78,989 1,500)
51123 Total K COTS B60]
1917 GITTINGS JOSHUA 4116 [STAFF ENGINEER, WATER PB 56100 51135, FT 135, 7 728 30.15) 1:35, 9 22,377 1350
51135 Total 22,377 0
1469 JERRIER, MICHAEL 4507 _|WATER & SEWER ACCT COORDINATOR WATER, AF 56100 51142 1-40 5 1040 29.25) 1-40 7 30,15, 31,477 800)
51142 Total 34477 800)
1359 CAWLEY PATRICIA A502 __|WATER/SEWER OFFICE ADMINSTRATO WATER, AFS 56100 51143 168 6 1040 38.67; 168 6 38.67 40,371 a
51143 Total 40,371 i)
[56100 Total “SSTUT2| 94a,900)
16 56100 Count
857 ) 43
BOI Lenhart Charles - moved to Sewer.
Iho de Af
Page 1 of 1Tab 31 - Water Enterprise and Debt Service and Chargebacks.pdf · Source page 6
TOWN OF CANTON 56102-59101- 56102-59103- 56102-59105-A2107 56102-59106- 56102-59107 56102-59109- 56102-59130- 56102-5913 1+ 56102-59132- 56102-59133- 56102-59135- 56102-59144 $6102-59145- 56102-59146- 56102-59148- $6102-59150- 36102-59152- 56102-59]79- 56102-59181- 56102-59182+ 56102-59183- $6102-59185- 56102-59187- 56102-59188~ 56102-59189» 56102-59194- 56102-59195- $6102-S9201- 56102-59250- 56102-594 10- 56102-59411+ BUDGET REPORT FOR FY 2023 weave ontomas, gaat, TE eat DEPARTMENTA. L WORKSHEETS EXPENSE EXPENSE EXPENSE FY22 11/30/2021 BASE BUDGET REQUEST PRINC PD-05/11 DEBT 255,000 0 o 67,769 0 67,769 i) PRIN PD 05/19 DEBT oO 238,100 222,000 226,000 0 226,000 229,000 MWRA PRINC 8/2020 DEBT oO 0 o 0 260,000 ti) 260,000 PRIN PD-3/15 DEBT 69,000 68,000 68,000 68,000 0 68,000 68,000 INT PD-03/15 DEBT 12,230 10,160 8,120 6,080 3,040 6,080 4,040 PRINCIPAL PAID TO MWRA 200,000 200,000 200,000 159,000 109,000 159,000 109,000 PRIN PAYDOWNS/NEW DEBT SERVICE 0 0 0 380,600 0 380,600 858,380 6 new issues: PRINC PD-3/12 DEBT 190,000 190,000 190,000 190,000 oO 190,000 0 ~ Water Main replace Ehv/Greenlodge/Dedham PRINC PD-03/13 DEBT 177,000 177,000 177,000 177,000 oO 177,000 0 - Granular Activated Carbon Fitering System PRINC PD-11/13 DEBT 77,400 74,800 49,700 47,900 oO 47,900 51,300 - Storage Tank Maintenance PRIN PD-03/14 DEBT 202,300 197,400 197,700 198,000 oO 198,000 192,800 - Water Main replace, 7 streets PRIN PD-03/16 DEBT 57,000 54,000 $4,000 54,000 i) $4,000 51,000 -Water Design Randolph/South St's INT PD-03/16 DEBT 8,420 7,286 6,200 5,120 2,560 $120 4,040 - Front End Loader PRIN PD-03/17 DEBT 135,000 135,000 135,000 135,000 0 135,000 135,000 PRIN PD-04/17 DEBT 97,000 98,000 95,000 95,000 0 95,000 99,000 INTEREST PD 05/11 132,260 0 u G 0 o 0O INT PD 05/20 DEBT G 0 284,034 207,000 33,884 207,000 264,419 INT PD - 05/10 DEBT 0 0 0 96,480 0 96,480 0 INT PD - 3/12 DEBT 81,700 74,100 70,300 64,600 o 64,600 oO INT PD - 03/13 DEBT 72,529 67,219 60,139 53,059 oO $3,059 0 INT PD-11/13 DEBT 12,947 10,399 8404 $5,919 2,960 $,919 4,482 INT PD-03/14 DEBT 68,603 58,488 48,618 38,733 19,366 38,733 28,833 INT PD-03/17 DEBT 74,850 70,800 66,750 62,700 0 62,700 58,650 INT PD-04/17 DEBT 27,505 25,565 23,605 19,805 9,903 19,805 16,005 PRIN PD 03/18 DEBT 202,000 225,000 200,000 202,000 0 202,000 200,000 INT PD 03/18 DEBT 121,730 94,240 82,990 76,990 38,495 76,990 66,890 INT PD 05/19 DEBT 0 120,245 109,340 98,240 49,120 98,240 86,940 SURPLUS BOND PROCEEDS -35,555 0 0 Cy) 0 Q 0 INTEREST TEMPORARY LOANS 0 22,500 0 0 0 0 oO PRIN PD-05/21 DEBT 0 399,000 INT PD-0$/21 DEBT i) 0 0 Oo 76,922 0 142,520 SUBTOTAL. EXPENSES $2,238,918 $2,198,295 $2,356,899 $2,734,995 $605,250 $2,734,995 3,329,298 SUBTOTAL WATER PRINC/INT PAYMENTS $2,238,918 $2,198,295 $2,356,899 $2,734,995 $605,250 $2,734,995 3,329,298 Willan R Scala, Ml o1fo3/2022 Dept Head Signature / Date
Tab 31 - Water Enterprise and Debt Service and Chargebacks.pdf · Source page 7
WATER ENTERPRISE FUND DEBT SERVICE PAYMENTS for FY 23
| Date of _ ee Debt Service Type of
Issue Type Description Org Object Payment —-2023
5/20/2021 Ww GOB Water Treatment Facility (Self-Supporting) REFUNDING 56102 59410 Principal 167,000.00
— _ 59410 Total 167,000.00
5/20/2021 Ww GOB Water Mains (Self-Supporting) REFUNDING 7 56102 _ 59410 Principal 11,000.00
5/20/2021 Ww GOB Water Mains (Self-Supporting) (Elm Street) REFUNDING 56102 59410 Principal 20,000.00
5/20/2021 W Jater Mains (Self-Supp (Elm Street) REFUNDING 5610259410 _——~Principal__~—=——_109,000.00 |
5/20/2021 w DING 56102 59410 Principal -~—=—-17,000.00
_ 59410 Total 157,000.00
8/19/2013 w MWRA Tolman Water Tank - interest free 56102 59109 Principal 109,000.00
8/19/2013 Ww ‘MWRA Tolman Water Tank - interest free 7 66102 59109 Interest a
J Zz 59109 Total 109,000.00
11/13/2013 w Water Mains (Self-Supporting) - (Refunding) 56102 59133 Principal 15,800.00
11/13/2013 w Water Mains (Self-Supporting) - (Refunding) _ 56102, 59133 “Principal 35,500.00 |
| ; _ ; 59133 Total 51,300.00
3/15/2014 w Water Mains (Self-Supporting) (56102 | 59135 Principal 90,000.00
_3/15/2014 = W — Well(Self-Supporting) ; ~ 5610259135 —~Principal_~—=45,000.00
3/15/2014. = W Well (Self - Supporting) (Refunding) _ 56102 | 59135 22,000.00
| 3/15/2014 = W Well(Self-Supporting) (Refunding) = 56102 | 59135 __ Principal 17,900.00
3/15/2014. W Well (Self- Supporting) (Refunding) _ 86102-59135 Principal 17,900.00
____ 59135 Total 192,800.00
3/15/2015 w Water Meters a oO 56102 59106 Principal 55,000.00
3/15/2015 w Water Meters - 56102-59106 “Principal _ 13,000.00
«59106 Total 68,000.00
3/17/2016 w 56102 59144 Principal 51,000.00
a - 59144 Total 51,000.00
3/16/2017 w Water Mains (Mechanic Street) — 56102 59146 Principal 135,000.00
| _ ee — ; 59146 Total 135,000.00
4/5/2017 w GOB Water Mains (Self-Supporting) = 56102 59148 Principal 79,000.00
4/5/2017 w GOB Water Mains (Self-Supporting) 56102 59148 Principal 20,000.00
59148 Total 99,000.00
| 3/15/2018 w GOB Water (Self-Supporting) (System Improvements) - 56102 59189 Principal 14,000.00
| 3/15/2018 w GOB Water Mains (Self-Supporting) 56102 59189 Principal ~ 51,000.00
3/15/2018 Ww GOB Water Mains (Self- Supporting) - i 66102 591 89 Principal 37,000.00
3/15/2018 W _ GOB Water Treatment Facility (Self-Supporting) _ | 56102-59189 Principal 98,000.00
a 59189 Total 200,000.00
~ 5/1/2019 w GOB Water Mains (Self-Supporting) 56102 59103 Principal 4,000.00
5/1/2019 Ww GOB Water Treatment Facility (Self-Supporting) 56102 59103 Principal 225,000.00 |
- — 89103 Total 229,000.00
5/20/2020 Ww Water line at Sullivan Treatment Facility SS a _ 56102 59110 ~—_—~Principal 56,000.00
| 5/20/2020. w Water System DesignSS 56102 59110 Principal 151,000.00
59110 Total 207,000.00
8/24/2020 «W 59105 Principal 260,000.00
| 59105 Total 260,000.00
5/20/2021 W Elm,Greenlodge,DedhamSt.WaterMains == s—ss«S6102 59410 Principal 75,000.00
Oo _ 59410 Total 75,000.00
5/20/2021 W GOB Water Treatment Facility (Self-Supporting) REFUNDING 56102-59411 Interest 62,420.00
| — - 59411 Total 62,420.00
5/20/2021 W GOB Water Mains (Self-Supporting) REFUNDING _ 56102 59411__Interest 440.00
| 5/20/2021 W _ GOB Water Mains (Self-Supporting) (Elm Street) REFUNDING 56102 59411 Interest 8,660.00 |
5/20/2021 W GOB Water Mains (Self-Supporting) (Elm Street) REFUNDING 56102 | 59411 _Interest 44,070.00
5/20/2021 Ww GOB Well #10 (Self-Supporting) REFUNDING = 56102-59411 Interest 680.00
— 59411 Total 53,850.00
11/13/2013 W If-Supporting) - (Refunding) | 56102_| 59183 | Interest | 1,413.00
11/13/2013 Ww Water Mains (Self If-Supporting) -(Refunding) a : | 56102 59183 —sInterest ~=——SC«S;« 089.0
oo - 59183 Total 4,482.00
3/15/2014 Ww Water Mains (Self-Supporting) ee 59185 _Interest 21,125.00
3/15/2014 Ww Well (Self - Supporting) 59185 _Interest 3,375.00
"3/15/2014 Ww Well (Self - Supporting) (Refunding) _ 59185 ___ Interest _ 1,647.50
3/15/2014 w Well (Self-Supporting) (Refunding) 59185 | Interest 1,342.50
~ 3/15/2014 Ww Well (Self - Supporting) (Refunding) 69185 Interest 1,342.50
in 59185 Total 28,832.50
~ 3/15/2015 Ww Water Meters - 7 - 56102 | 59107 Interest 3,000.00
FY 22 thru FY 45 12/23/2021
AUTHDEBT 12-21-21.xlsxTab 31 - Water Enterprise and Debt Service and Chargebacks.pdf · Source page 8
WATER ENTERPRISE FUND DEBT SERVICE PAYMENTS for FY 23 AUTHDEBT 12-21-21.xIsx Dateof _ Debt Service Type of Issue Type Description oo Org Object ; Payment 2023, 3/15/2015 Ww WaterMeters ss 56102 59107 Interest 1,040.00 ; 59107 Total 4,040.00 3/17/2016 WwW GOB Water Mains (Self-Supporting) (Refunding) 7 56102-59145 Interest 4,040.00 ; : i 59145 Total 4,040.00 3/16/2017 == W_ _ Water Mains (Mechanic Street) _ 56102 | 59187 Interest 58,650.00 —_ oo 59187 Total 58,650.00 4/5/2017 Ww GOB Water Mains (Self-Supporting) 56102 | 59188 Interest 12,590.00 4/5/2017 Ww GOB Water Mains (Self-Supporting) _ 7 - 56102 | 59188 "Interest 3,415.00 | - 7 oe oe 59188 Total 16,005.00 3/15/2018 Ww GOB Water (Self-Supporting) (System Improvements) _ 56102 Interest 4,590.00 3/15/2018 w GOB Water Mains (Self-Supporting) 56102 “Interest — 16,760.00 ~ 3/15/2018 w ‘GOB Water Mains (Self-Supporting) 56102. Interest 12,220.00 3/15/2018 = W GOB Water Treatment Facility (Self-Supporting) -—-—Ss-|-—«dS6102. 59194 _Interest ~ 33,320.00 | - 59194 Total 66,890.00 5/1/2019 Ww GOB Water Mains (Self-Supporting) _ 56102 59195 Interest 1,770.00 ~ 5/1/2019 w GOB Water Treatment Facility (Self-Supporting) _ _ 56102 59195 _Interest 85,170.00 —ml _ _ - | 59195 Total 86,940.00 ! 5/20/2020 w Water line at Sullivan Treatment Facility SS 56102 | 59152 Interest 34,868.76 5/20/2020. W WaterSystemDesignSS _ 56102-59152. -—SsInterest. «= |S 22,550.00 a CO 7 59152 Total 57,418.76 5/20/2021 W Elm, Greenlodge, Dedham St. Water Mains _ 56102-59411 Interest 26,250.00 59411 Total 26,250.00 FY 22 thru FY 45 12/23/2021
Tab 31 - Water Enterprise and Debt Service and Chargebacks.pdf · Source page 9
DEBT SERVICE PROJECTIONS - DEBT IN PIPELINE AUTHORIZED Project AUTHORIZED TERM BOND | BAN BOND FY DATE _ART# Code PURPOSE UNISSUED |(YRS) DATE RATE RATE _ INT PRIN 2023 6/22/2020 12-7 | B2102 MEMORIAL FIELD HOMESIDE BLEACHERS 1,000,000 10 May-22 2.50% 4.00% 40,000 100,000 | 140,000 6/22/2020 12-8 B2103 CHS ROOFTOP UNIT #8 180,000 5 May-22 2.50% 4.00% 7,200 36,000 43,200 6/22/2020 21-2. A2113. PLEASANT/SHERMAN/ANGELA INTERSECTION IMPRVMTS 500,000 20 May-22, 2.50% 4.00% 20,000 25,000 45,000 5/22/2021 11-8 B2203 CHS ROOFTOP UNIT #4 180,000 5 May-22 2.50% 4.00% 7,200 36,000 43,200 5/22/2021 11-9 B2204 HANSEN SCHOOL VENTILATORS 250,000 5 May-22 2.50% 4.00% 10,000 50,000 60,000 5/22/2021 11-10 B2205 GALVIN SCHOOL VENTILATORS 166,000 5 May-22 2.50% 4.00% 6,640 33,200 39,840 5/22/2021 11-5 B2202 MEMORIAL HALL - EXTERIOR 1,116,000 20 May-22 2.50% 4.00% 44,640 55,800 100,440 5/22/2021 11-6 2206 FIRE STATION 2- AIR FILLING STATION 76,000 5 May-22 2.50% 4.00% 3,040 15,200 18,240 5/22/2021 11-7 A2207 POLICE RECORD MANAGEMENT SYSTEM 102,415 5 NIA NIA. NIA 0 TOTAL INSIDE LEVY 3,570,415 May-22 2.50% 4.00% 138,720 351,200 489,920 12/14/2021 | 2 ST GERARD'S PROPERTY 3,305,000' 20 May-22 2.50% 4.00% 132,200 165,250 297,450 TOTAL OUTSIDE LEVY 3,305,000 132,200 165,250 297,450 6/22/2020 12-9 A2107 WATER MAIN REPLACE ELM/GREENLODGE/DEDHAM ST's 500,000 20 May-22 2.50% 4.00% 20,000 25,000 45,000 6/22/2020 12-10 A2108 GRANULAR ACTIVATED CARBON WATER FILTERING SYSTEM 2,412,000 20 May-22 2.50% 4.00% 96,480 120,600 217,080 5/22/2021 11-11 A2208 WATER ASSET MGMT PROGRAM - STORAGE TANKS 2,925,000 15 May-22 2.50% 4.00% 117,000 195,000 312,000 5/22/2021 11-12 A2209 WATER MAIN REPLACEMENTS - 7 STREETS 2,500,000 20 May-22 2.50% 4.00% 100,000 125,000 225,000 5/22/2021 11-13 A2210 WATER DESIGN - RANDOLPH/SOUTH ST'S 270,000 20 May-22 2.50% 4.00% 10,800 13,500 24,300 5/22/2021 11-14 A2211 WATER - FRONT END LOADER 250,000 10 May-22 2.50% 4.00% 10,000 25,000 35,000 TOTAL WATER ENTERPRISE 8,857,000 354,280 504,100 858,380 GRAND TOTALS AUTHORIZED and UNISSUED DEBT 15,732,415 625,200 1,020,550 1,645,750 AUTHDEBT 12-21-21.xisx PIPELINE 12/27/2021
Tab 31 - Water Enterprise and Debt Service and Chargebacks.pdf · Source page 10
TOWN OF CANTON
ACTUAL YTD FY 2023 FY 2023 COMMENT/REASON FOR
BUDGET REPORT FOR FY 2023 FY 19 FY 20 FY 21 ORIGINAL
EXPENSE THRU DEPARTMENTAL DEPT INCREASE / DECREASE
ACTUAL ACTUAL ACTUAL BUDGET
DEPARTMENTAL WORKSHEETS EXPENSE EXPENSE EXPENSE FY 22
11/30/2021 BASE BUDGET REQUEST
56102-59101- PRINC PD-05/11 DEBT 255,000 0 0 67,769 0 67,769 0
56102-59103- PRIN PD 05/19 DEBT 0 218,100 222,000 226,000 0 226,000 229,000
56102-59105-A2107 MWRA PRINC 8/2020 DEBT 0 0 0 0 260,000 0 260,000
56102-59106- PRIN PD-3/15 DEBT 69,000 68,000 68,000 68,000 0 68,000 68,000
56102-59107- INT PD-03/15 DEBT 12,230 10,160 8,120 6,080 3,040 6,080 4,040
56102-59109- PRINCIPAL PAID TO MWRA 200,000 200,000 200,000 159,000 109,000 159,000 109,000
56102-59130- PRIN PAYDOWNS/NEW DEBT SERVICE 0 0 0 380,600 0 380,600 858,380 6 new issues:
56102-59131- PRINC PD-3/12 DEBT 190,000 190,000 190,000 190,000 0 190,000 0 - Water Main replace Elm/Greenlodge/Dedham
56102-59132- PRINC PD-03/13 DEBT 177,000 177,000 177,000 177,000 0 177,000 0 - Granular Activated Carbon Filtering System
56102-59133- PRINC PD-11/13 DEBT 77,400 74,800 49,700 47,900 0 47,900 51,300 - Storage Tank Maintenance
56102-59135- PRIN PD-03/14 DEBT 202,300 197,400 197,700 198,000 0 198,000 192,800 - Water Main replace, 7 streets
56102-59144- PRIN PD-03/16 DEBT 57,000 54,000 54,000 54,000 0 54,000 51,000 -Water Design Randolph/South St's
56102-59145- INT PD-03/16 DEBT 8,420 7,280 6,200 5,120 2,560 5,120 4,040 - Front End Loader
56102-59146- PRIN PD-03/17 DEBT 135,000 135,000 135,000 135,000 0 135,000 135,000
56102-59148- PRIN PD-04/17 DEBT 97,000 98,000 95,000 95,000 0 95,000 99,000
56102-59150- INTEREST PD 05/11 132,260 0 0 0 0 0 0
56102-59152- INT PD 05/20 DEBT 0 0 284,034 207,000 33,884 207,000 264,419
56102-59179- INT PD - 05/10 DEBT 0 0 0 96,480 0 96,480 0
56102-59181- INT PD - 3/12 DEBT 81,700 74,100 70,300 64,600 0 64,600 0
56102-59182- INT PD - 03/13 DEBT 72,529 67,219 60,139 53,059 0 53,059 0
56102-59183- INT PD-11/13 DEBT 12,947 10,399 8,404 5,919 2,960 5,919 4,482
56102-59185- INT PD-03/14 DEBT 68,603 58,488 48,618 38,733 19,366 38,733 28,833
56102-59187- INT PD-03/17 DEBT 74,850 70,800 66,750 62,700 0 62,700 58,650
56102-59188- INT PD-04/17 DEBT 27,505 25,565 23,605 19,805 9,903 19,805 16,005
56102-59189- PRIN PD 03/18 DEBT 202,000 225,000 200,000 202,000 0 202,000 200,000
56102-59194- INT PD 03/18 DEBT 121,730 94,240 82,990 76,990 38,495 76,990 66,890
56102-59195- INT PD 05/19 DEBT 0 120,245 109,340 98,240 49,120 98,240 86,940
56102-59201- SURPLUS BOND PROCEEDS -35,555 0 0 0 0 0 0
56102-59250- INTEREST TEMPORARY LOANS 0 22,500 0 0 0 0 0
56102-59410- PRIN PD-05/21 DEBT 0 399,000
56102-59411- INT PD-05/21 DEBT 0 0 0 0 76,922 0 142,520
SUBTOTAL
EXPENSES $2,238,918 $2,198,295 $2,356,899 $2,734,995 $605,250 $2,734,995 3,329,298
SUBTOTAL WATER PRINC/INT PAYMENTS $2,238,918 $2,198,295 $2,356,899 $2,734,995 $605,250 $2,734,995 3,329,298
William R Scollins, III 01/03/2022
Dept Head Signature / DateTab 31 - Water Enterprise and Debt Service and Chargebacks.pdf · Source page 11
TOWN OF CANTON
ACTUAL YTD FY 2023 FY 2023 COMMENT/REASON FOR
BUDGET REPORT FOR FY 2023 FY 19 FY 20 FY 21 ORIGINAL EXPENSE THRU DEPARTMENTAL DEPT INCREASE / DECREASE
ACTUAL ACTUAL ACTUAL BUDGET
DEPARTMENTAL WORKSHEETS EXPENSE EXPENSE EXPENSE FY 22
11/30/2021 BASE BUDGET REQUEST
56002-59101- PRINC PD-05/11 DEBT 71,000 0 0 0 0 0 0
56002-59103- PRIN PD 05/19 DEBT 0 64,600 59,000 0 0 0 0
56002-59106- PRIN PD-3/15 DEBT 77,000 40,000 40,000 40,000 0 40,000 40,000
56002-59107- INT PD-03/15 DEBT 8,385 6,075 4,875 3,675 1,838 3,675 2,475
56002-59109- PRINCIPAL PAID TO MWRA 113,300 0 0 6,815 0 6,815 6,815
56002-59126- PRINCIPAL PAID TO MWPAT 176,971 180,546 184,194 187,915 0 187,915 191,711
56002-59131- PRINC PD-3/12 DEBT 100,000 100,000 100,000 100,000 0 100,000 0
56002-59132- PRINC PD-03/13 DEBT 15,000 15,000 15,000 15,000 0 15,000 0
56002-59133- PRINC PD-11/13 DEBT 239,400 224,000 47,200 46,700 0 46,700 46,300
56002-59135- PRIN PD-03/14 DEBT 48,100 43,200 43,200 43,300 0 43,300 43,200
56002-59144- PRIN PD-03/16 DEBT 60,000 61,000 60,000 62,000 0 62,000 60,000
56002-59145- INT PD-03/16 DEBT 9,540 8,340 7,120 5,920 2,960 5,920 4,680
56002-59148- PRIN PD-04/17 DEBT 25,000 0 0 0 0 0 0
56002-59150- INTEREST PD 05/11 7,079 0 0 0 0 0 0
56002-59160- INTEREST PD TO MWPAT 54,024 50,181 46,260 42,260 210,055 42,260 38,179
56002-59181- INT PD - 3/12 DEBT 43,000 39,000 37,000 34,000 0 34,000 0
56002-59182- INT PD - 03/13 DEBT 2,250 1,800 1,200 600 0 600 0
56002-59183- INT PD-11/13 DEBT 21,676 12,859 7,901 5,541 2,771 5,541 4,140
56002-59185- INT PD-03/14 DEBT 12,130 9,725 7,565 5,405 2,703 5,405 3,240
56002-59188- INT PD-04/17 DEBT 500 0 0 0 0 0 0
56002-59195- INT PD 05/19 DEBT 0 6,180 2,950 0 0 0 0
56002-59201- SURPLUS BOND PROCEEDS -54,235 0 0 0 0 0 0
56002-59410- PRIN PD-05/21 DEBT 0 86,000
56002-59411- INT PD-05/21 DEBT 0 0 0 0 17,952 0 32,850
SUBTOTAL
EXPENSES $1,030,120 $862,506 $663,465 $599,131 $238,277 $599,131 559,590
SUBTOTAL SEWER PRINC / INT PAYMENTS $1,030,120 $862,506 $663,465 $599,131 $238,277 $599,131 559,590
William R Scollins, III 01/03/2022
Dept Head Signature / DateTab 31 - Water Enterprise and Debt Service and Chargebacks.pdf · Source page 12
ENTERPRISE FUNDS INDIRECT COSTS FOR FY 23
FY 22 FY 23 FY 23 FY 23
# BUDGET Water Allocation % of Budget Sewer Allocation % of Budget Rink Allocation % of Budget Basis for allocating indirect costs
1 HEALTH INSURANCE $ 13,143,953 $ 179,606 1.4% $ 103,563 0.8% $ 1,760 0.0% FY 22 accumulator report & budgeted salaries
2 PENSION (Norfolk County) $ 6,463,772 $ 209,611 3.2% $ 118,586 1.8% $ 5,179 0.0% FY 22 Pensionable Wages X 24.2%
SHARED EMPLOYEES
3 Executive $ 510,826 $ 27,124 5.3% $ 15,822 3.1% $ 2,260 0.4% Dept EE's / 226 Town Employees
4 Accountant $ 273,787 $ 12,681 4.6% $ 13,343 4.9% $ 605 0.2% Prior Year Total Expenditures / Total Town Exp.
5 Finance Director $ 229,115 $ 10,612 4.6% $ 11,166 4.9% $ 507 0.2% Prior Year Total Expenditures / Total Town Exp.
6 Collector/Treasurer $ 229,119 $ 11,956 5.2% $ 11,360 5.0% $ 263 0.1% Prior Year Total Revenues / Total Town Revs.
7 Human Resources $ 191,594 $ 10,173 5.3% $ 5,934 3.1% $ 848 0.4% Dept EE's / 226 Town Employees
8 Legal Services $ 299,440 $ 15,899 5.3% $ 9,275 3.1% $ 1,325 0.4% Dept EE's / 226 Town Employees
9 Information Technology $ 628,302 $ 4,368 0.7% $ 2,184 0.3% $ 874 0.1% MUNIS Support Costs
10 Dept of Public Works $ 3,211,826 $ 92,831 2.9% $ 62,693 2.0% $ - 100.0% From DPW Superintendent
TOTAL SHARED EMPLOYEES $ 5,574,009 $ 185,644 3.3% $ 131,777 2.4% $ 6,681 0.1%
OTHER 1
11 Workers' Comp Insurance $ 410,500 $ 28,491 6.9% $ 11,846 2.9% $ 4,105 1.0% From NorthStar
12 Building & Contents Insurance $ 225,264 $ 27,132 12.0% $ - 100.0% $ 9,307 4.1% From NorthStar (statement of values)
13 Vehicle Insurance $ 172,012 $ 11,280 6.6% $ 3,760 2.2% $ 940 0.5% $940 per vehicle
14 Retirement Buyback $ 80,000 $ 2,594 3.2% $ 1,468 1.8% $ - 0.0% Pension %'s
15 Unemployment Compensation $ 100,000 $ 1,606 1.6% $ 913 0.9% $ 199 0.2% Total Dept Salaries / Total Town Salaries
16 OPEB $ 5,055,914 $ 96,489 1.9% $ 57,582 1.1% $ - 100.0% Actuarial Study Updated June 2021
TOTAL OTHER 1 $ 6,043,690 $ 167,593 2.8% $ 75,569 1.3% $ 14,551 0.2%
TOTAL $ 31,225,424 $ 742,455 2.4% $ 429,495 1.4% $ 28,171 0.1%
$ 353,237 $ 207,346 $ 21,232
Enterprise Chargebacks for FY '23.xlsx DOR version 12/27/2021Tab 4 - 171 - Conservation Commission.pdf · Source page 1
TOWN OF CANTON BUDGET REPORT FOR FY 2023 DEPARTMENTAL WORKSHEETS 171 CONSERVATION COMMISSION 11711 - 51100 W711 - 51100 W711 - 51151 11711-S1151 11711 - 51159 11711 - 51300 11711 - 51400 11712 - 52420 11712 - 53400 11712 - 53406 11712 - 53408 11712 -5340D 11712 - 53803 11712 - 54001 11712 - 54006 11712 - 57000 11712 - 57105 11712 -5710C 11712 - $7300 11712 - 57404 11712 - 58500 Date: 12/1/2021 DEPARTMENT HEAD SALARY DEPARTMENT HEAD SALARY DEPT. SECRETARY Iil SAL. DEPT. SECRETARY Ill SAL. CLERICAL SALARY OVERTIME SALARY LONGEVITY SUBTOTAL SALARIES & WAGES BUILDING MAINT&SUPPLIES TELEPHONE/COMMUNICATIONS COMMUNICATIONS - OTHER POSTAGE ADVERTISING CONSERVATION CONSULTANT SUPPLIES COPIER SUPPLIES OTHER CHARGES/EXPENDITURE IN-STATE TRAVEL MEETINGS DUES & MEMBERSHIPS OTHER EMPLOYEE BENEFITS EQUIPMENT PURCHASE SUBTOTAL EXPENSES FY19 ACTUAL EXPENSE 47,1ST 41,015 1,658 326 600 $ 90.756 3,976 193 634 527 940 13,362 3,129 177 335 592 709 689 6,715 $ 31,976 FY 20 ry24 ORIGINAL FY 2023 FY 2023 COMMENT/REASON FOR ACTUAL ACTUAL BUDGET ACTUAL YTD BASE DEPT. INCREASE / DECREASE EXPENSE EXPENSE FY 22 EXPENSES THRU BUDGET REQUEST 11/30/21 72,224 69,146 83,636 35,195 88,560 0 3,526 0 0 0 31,774 32,091 45,063 18,954 47,264 0 1,110 0 0 0 4,620 14,249 15,889 5,874 16,678 0 0 0 0 0 800 0 0 0 0) $109,418 $120,122 $144,588 $60,024 $152,502 10,931 143 8,000 2,491 8,000 219 235 300 80 300 519 498 600 166 600 4 627 655 300 151 300 G50 EY rec i 320 35 300 75 300 aan 1,338 8,558 0 350 0 1,876 3,015 1,500 1,615 1,500 694 188 200 54 200 1,386 805 0 962 0 1,160 460 1,500 247 1,500 1,784 853 2,500 342 2,500 1,089 1,015 1,300 886 1,300 377 250 600 0 oo _1/00 Paenk Gmhace 1,902 0 0 0 0 , $24,222 $16,709 $17,100 $7,420 $17,100 Page: 20
Tab 4 - 171 - Conservation Commission.pdf · Source page 2
TOWN OF CANTON BUDGET REPORT FOR FY 2023 DEPARTMENTAL WORKSHEETS TOTAL 171 CONSERVATION COMMISSION Date: 12/1/2021 ry 19 FY 20 FY 21 ORIGINAL FY 2023 FY 2023 COMMENT/REASON FOR ACTUAL ACTUAL ACTUAL BUDGET ACTUAL YTD BASE DEPT. INCREASE / DECREASE EXPENSE EXPENSE EXPENSE FY 22 EXPENSES THRU BUDGET REQUEST 11/30/21 $122,732 $133,640 $136,832 $161,688 $67,444 $169,602 OS os Brey. Malone Departmen(H¥ad signature / Date Page: 21
Tab 4 - 171 - Conservation Commission.pdf · Source page 3
PAYROLL PROJECTIONS - FY 2023 New FY2s FY22 Pay hourly rate with] FY23 Annual Employee Job Class Hours | Hourly | FY22 Pay Fy23Next | FY23Next | step and/or | Salary (261 FY23 Number Last Name First Name Code Job Class Code Dese Location Code Dese_|_Group/BU Ore Object Status | Pay Grade |PayStep| PerVear| Rate _| Annual Salary Grade Step COLA. days) Longevity 1869 JAMIESON MILANI MARY. 1710 | CONSERVATION AGENT. [CONSERVATION PC 114713, 51100 FT MRM 1 2080, 41.17 MRM. a 42.41 88,560 Oo} 51100 Total 88,560) Oo} 1972 ISONGIN CASEY. 1712__|SENIOR CLERK |CONSERVATION, PB 41711 54151 Fr K-35, 8 1820 25.48; K-35 $s 25.87 47,264 Oo} 51151 Total 47,264 oO} 1924 JO'CONNELL-MCCARTHY ROBIN. 1715 __ | BOARD SECRETARY. CONSERVATION PBN 41711 51159 PT 15, 2 730 20.98 | 15 3 21.30 16,678 Oo} $1159 Total 16,678 Oo} [14711 Total 452,503 Oo} 11711 Count Payroll Projections FY23.xIsx 11/30/2021 Page lof 1
Tab 5 - 541 - Elder and Human Services - revised worksheet.pdf · Source page 1
TOWN OF CANTON BUDGET REPORT FOR FY 2023 DEPARTMENTAL WORKSHEETS 541 COUNCIL ON AGING 15411 - 51000 15411 - 51100 15411 - 51134 1541] - 51145 15411 - 51159 15411 - 51159 15411 - 51400 15412 - 52101 15412 - 52103 15412 ~ 52400 15412 - 52420 15412 - 53108 15412 - 53131 15412 - 53400 15412 - 53406 15412 - 53408 15412 - 53500 15412 - 54200 15412 - 54801 15412 - 55103 15412 - 57000 15412 - $7105 15412 - 57107 15412 - 57300 Date: 12/9/2021 PERSONAL SERVICES DIRECTOR OF COUNCIL ON AG BUS DRIVERS SALARIES OUTREACH WORKER SALARY CLERICAL SALARY CLERICAL SALARY LONGEVITY SUBTOTAL SALARIES & WAGES ELECTRICITY HEATING FUEL - GAS BUS REPAIRS & MAINTENANC BUILDING MAINT&SUPPLIES PRINTING & BINDING PROF.SERV.MEDICAL EXAMS TELEPHONE/COMMUNICATIONS COMMUNICATIONS - OTHER POSTAGE PROGRAMS/SOCIAL PROGRAM OFFICE SUPPLIES GASOLINE & OIL SUBSCRIPTIONS OTHER CHARGES/EXPENDITURE IN-STATE TRAVEL EMPLOYEE TRAINING EXPENSES DUES & MEMBERSHIPS SUBTOTAL EXPENSES Fy 19 FY 20 FY 21 ORIGINAL FY 2023 FY 2023 COMMENT/REASON FOR ACTUAL ACTUAL ACTUAL BUDGET ACTUAL YTD BASE DEPT. INCREASE / DECREASE EXPENSE EXPENSE EXPENSE FY 22 EXPENSES THRU BUDGET REQUEST 11/30/21 35,765 31,452 40,780 40,794 15,295 48,288 104,834 108,710 110,155 108,492 49.779 113,987 71,239 68,055 68,947 92,859 30,884 92,859 56,326 59,404 74,855 98,946 42,843 105,394 an 37,993 39,847 43,028 38,993 19,971 47,557 ma Sone 0 0 343 0 0 0 Perec ec defo 2,150 4,100 1,350 3,700 2,550 3,450 $ 308,307 $311,568 $339,460 $383,784 $170,322 S4H1535 LE Yn OSH 15,660 20,565 23,230 20,000 13,656 20,000 4727 4,663 5,129 10,000 2,433 10,000 A711 6,665 1,617 1,600 1,046 1,600 11,476 28,449 29,008 28,300 25,428 28,300 1,023 185 270 820 863 820 99 234 275 0 201 0 948 1,006 1,052 2,100 351 2,100 1,617 2,097 2,607 1,500 1,063 1,500 2,225 2,891 4,450 2,620 150 2,620 22,095 9,106 14.711 7,305 1,877 7305 19, 50/7 eed -100 4191 5,503 2,000 1,001 2,000 : 9,637 5,014 4,756 10,295 2,634 10,295 0 0 0 0 150 0 0 0 178 0 0 0 0 0 0 450 0 450 65 0 0 0 0 0 1,201 105 0 0 0 0 $ 75,383 $85,171 $92,786 $86,990 $50,853 Page: 95
Tab 5 - 541 - Elder and Human Services - revised worksheet.pdf · Source page 2
TOWN OF CANTON BUDGET REPORT FOR FY 2023 DEPARTMENTAL WORKSHEETS TOTAL 541 COUNCIL ON AGING Date: 12/9/2021 FY19 FY 20 FY21 ORIGINAL FY 2023 FY 2023 COMMENT/REASON FOR ACTUAL ACTUAL ACTUAL BUDGET ACTUAL YTD BASE DEPT. INCREASE / DECREASE EXPENSE EXPENSE EXPENSE F¥ 22 EXPENSES THRU BUDGET REQUEST 11/30/21 i 7 $ 383,690 $396,739 $432,245 $470,774 $221,175 $498,525 8 2, Z fy ai a : poy é Zz [itu ~ LALA AS ipa 62 Valor Department Head signature / Daté fA Page: 96
Tab 5 - 541 - Elder and Human Services - revised worksheet.pdf · Source page 3
FY 20 FY 2023 FY 2023 COMMENT/REASON FOR
TOWN OF CANTON FY 19
ACTUAL
FY 21 ORIGINAL
ACTUAL YTD BASE DEPT. INCREASE / DECREASE
ACTUAL ACTUAL BUDGET
BUDGET REPORT FOR FY 2023 EXPENSE EXPENSE EXPENSE FY 22 EXPENSES THRU BUDGET REQUEST
11/30/21
DEPARTMENTAL WORKSHEETS
541 COUNCIL ON AGING
15411 - 51000 PERSONAL SERVICES 35,765 31,452 40,780 40,794 15,295 48,288
15411 - 51100 DIRECTOR OF COUNCIL ON AG 104,834 108,710 110,155 108,492 49,779 113,987
15411 - 51134 BUS DRIVERS SALARIES 71,239 68,055 68,947 92,859 39,884 92,859
15411 - 51145 OUTREACH WORKER SALARY 56,326 59,404 74,855 98,946 42,843 105,394
15411 - 51159 CLERICAL SALARY 37,993 39,847 43,028 38,993 19,971 47,557
15411 - 51159 CLERICAL SALARY 0 0 343 0 0 0
15411 - 51400 LONGEVITY 2,150 4,100 1,350 3,700 2,550 3,450
SUBTOTAL SALARIES & WAGES $ 308,307 $311,568 $339,460 $383,784 $170,322 $411,535
15412 - 52101 ELECTRICITY 15,660 20,565 23,230 20,000 13,656 20,000
15412 - 52103 HEATING FUEL - GAS 4,727 4,663 5,129 10,000 2,433 10,000
15412 - 52400 BUS REPAIRS & MAINTENANC 4,711 6,665 1,617 1,600 1,046 1,600
15412 - 52420 BUILDING MAINT&SUPPLIES 11,476 28,449 29,008 28,300 25,428 28,300
15412 - 53108 PRINTING & BINDING 1,023 185 270 820 863 820
15412 - 53131 PROF.SERV.MEDICAL EXAMS 99 234 275 0 201 0
15412 - 53400 TELEPHONE/COMMUNICATIONS 948 1,006 1,052 2,100 351 2,100
15412 - 53406 COMMUNICATIONS - OTHER 1,617 2,097 2,607 1,500 1,063 1,500
15412 - 53408 POSTAGE 2,225 2,891 4,450 2,620 150 2,620
15412 - 53500 PROGRAMS/SOCIAL PROGRAM 22,095 9,106 14,711 7,305 1,877 7,305
15412 - 54200 OFFICE SUPPLIES -100 4,191 5,503 2,000 1,001 2,000
15412 - 54801 GASOLINE & OIL 9,637 5,014 4,756 10,295 2,634 10,295
15412 - 55103 SUBSCRIPTIONS 0 0 0 0 150 0
15412 - 57000 OTHER CHARGES/EXPENDITURE 0 0 178 0 0 0
15412 - 57105 IN-STATE TRAVEL 0 0 0 450 0 450
15412 - 57107 EMPLOYEE TRAINING EXPENSES 65 0 0 0 0 0
15412 - 57300 DUES & MEMBERSHIPS 1,201 105 0 0 0 0
SUBTOTAL EXPENSES $ 75,383 $85,171 $92,786 $86,990 $50,853 $86,990
Date: 12/9/2021 Page: 95Tab 5 - 541 - Elder and Human Services - revised worksheet.pdf · Source page 4
FY 20 FY 2023 FY 2023 COMMENT/REASON FOR
TOWN OF CANTON FY 19
ACTUAL
FY 21 ORIGINAL
ACTUAL YTD BASE DEPT. INCREASE / DECREASE
ACTUAL ACTUAL BUDGET
BUDGET REPORT FOR FY 2023 EXPENSE EXPENSE EXPENSE FY 22 EXPENSES THRU BUDGET REQUEST
11/30/21
DEPARTMENTAL WORKSHEETS
TOTAL 541 COUNCIL ON AGING $ 383,690 $396,739 $432,245 $470,774 $221,175 $498,525
Department Head signature / Date
Date: 12/9/2021 Page: 96Tab 5 - 541 - Elder and Human Services - revised worksheet.pdf · Source page 5
PAYROLL PROJECTIONS - FY 2023
New FY23
FY22 Pay hourly rate with
Employee Job Class Hours Per Hourly FY22 Pay FY23 Next FY23 Next step and/or FY23 Annual FY23
Number Last Name First Name Code Job Class Code Desc Location Code Desc Group/BU Org Object Status Pay Grade Pay Step Year Rate Annual Salary Grade Step COLA Salary (261 days) Longevity
2042 RINNING NICOLE 5415 PROGRAM CORDINATOR COUNCIL AGING PB 15411 51000 FT J-35 3 1820 26.03 47,375 J-35 4 26.43 48,288 0
51000 Total 47,375 48,288 0
588 TYNAN DIANE 5410 DIRECTOR OF COUNCIL ON AGING COUNCIL AGING AE 15411 51100 FT E-40 20 2080 53.26 110,781 E-40 20 54.59 113,987 2,000
51100 Total 110,781 113,987 2,000
1669 GENATOSSIO STEPHEN 5418 BUS DRIVER - COUNCIL ON AGING COUNCIL AGING PB 15411 51134 FT K-35 5 1820 24.38 44,372 K-35 6 24.75 45,218 650
51134 Total 44,372 45,218 650
1985 DIMARIA VICTORIA 5419 PT OUTREACH WORKER COUNCIL AGING PBN 15411 51145 PT H-02 2 1014 30.31 30,735 H-02 2 30.31 30,853 0
1504 TOBIN ROBIN 5411 OUTREACH WORKER COUNCIL AGING PB 15411 51145 FT H-40 12 2080 35.16 73,133 H-40 13 35.70 74,542 800
51145 Total 103,867 105,394 800
1973 BARRERA ELIZABETH 5414 CLERK/RECEPTIONIST COUNCIL AGING PB 15411 51159 FT J-35 2 1820 25.65 46,683 J-35 3 26.03 47,557 0
51159 Total 46,683 47,557 0
15411 Total 353,077 360,444 3,450
6 15411 Count
Payroll Projections FY23.xlsx
12/9/2021 Page 1 of 1Tab 6 - 129, 151, 195, 244 - Executive Area.pdf · Source page 1
TOWN OF CANTON
BUDGET REPORT FOR FY 2023
DEPARTMENTAL WORKSHEETS
129
EXECUTIVE OFFICE
11291 - $1100 DEPARTMENT HEAD SALARY
11291-5110] SELECTMEN SALARY
41291-51124 SELECTMEN CELL PHONE
11291-51140 SENIOR ACCT. CLERK I!
11291-51146 SECRETARY SALARY
11291-51150 ADMIN, SECRETARY SALARY
11291 - 51300 OVERTIME SALARY
11291 - 31400 LONGEVITY
SUBTOTAL SALARIES & WAGES
11292-52436 ADVERTISING
11292 - $3101 PROF, SERVICES - AUDIT
11292 - $3108 PRINTING & BINDING
11292-5310R PHYSICAL FITNESS PROGRAM
11292-53116 PROF.SERV.REGIONAL ADMIN.
11292 - $3400 TELEPHONE/COMMUNICATIONS
11292-53408 POSTAGE
11292-53800 ADVERTISING
11292 - $4006 COPIER SUPPLIES
11292 - $4200 OFFICE SUPPLIES
11292-57000 OTHER CHARGES&EXPENDITUR
11292- $7105 IN-STATE TRAVEL
11292 - S707. EMPLOYEE TRAINING EXPENSES
11292 - $7
11292 - §
IN-STATE TRAVEL
MEETINGS
11293 $7300 DUES & MEMBERSHIPS
11292 - $7301 DUES&SUB.MASS MUNIC.ASSO
11292-57800 CONTINGENCIES
11292 - 57817 CONTINGENCIES
Dates (2/1/2021
FYI9 Fy20 v2 ORIGINAL PY 2023 FY 2023 COMMENT/REASON FOR
ACTUAL ACTUAL ACTUAL BUDGET ACTUAL YTD BASE DEPT. INCREASE / DECREASE
EXPENSE EXPENSE EXPENSE FY 22 EXPENSES: THRU BUDGET REQUEST
182,070 200,423 210,058 215,827 88,481 221,223
6.617 7,200 7,200 7,200 3,000 7,200
4,000 5,000 $,900 5,000 0 5,000
48,339 50,126 50,796 50,974 21,526 $2,508
45,195 51,673 $9,339 60,583 25,431 63,324
72,323 69,733 71,746 73,062 30,851 716,387
3,197 sil 4,313 4,065 4A2 4,065
2,000 1,750 1,750 1,750 800 2,550 alee) 4en- A599
3 363,742 $392,715 $407,201 $418,461 $170,532 $432,257 ABUMST quay “FOR
1,480 1,861 1,081 4 3,850 480 3,850
42,000 42,000 Caa300") "42,900 0 42,000 __ “T4660
820 604 “Se 700 460 700
$50 809 600 950 0 950
4,100 4,100 4,100 4,100 4,100 4,100
1,679 1,683 2,048 4,000 955 4,000-
win 642 266 1,450 163 1,450
WAT 1,105 0 0 0 0
582 185 438 750 282 750
1,221 2,390 1,910 2,500 559 2,500,
354 0 0 8 0 0
468 1,326 0 3,700 0 3,700
2,519 1,620 354 8,000 ny 8,000
283 37 0 0 0 0
2,165 1,757 297 A STS 978 4,575. yoo 45°
433 364 1,768 ———1,400 14004360 1,400 {-G-0-. eer an
6,055 6171 477, 3,060 S1E-Y8UT —5,060°
11,460 3,750 18,507" 9,390 6,880" 9,390
3,569 363 0 0 ° 6
Page: 1Tab 6 - 129, 151, 195, 244 - Executive Area.pdf · Source page 2
TOWN OF CANTON FY 1D ¥¥20 FY21 ORIGINAL FY 2023 RY 2023 COMMENT/REASON FOR
ACTUAL ACTUAL YTD BASE DEPT.
BUDGET REPORT FOR FY 2023 ae pn thdond AGrEaL, BUDGET {oman sheer neni INCREASE / DECREASE
DEPARTMENTAL WORKSHEETS 180/21
SUBTOTAL EXPENSES $ 81,657 $70,724 $82,156 $92,365 $21,447 $92,365 Agr g
TOTAL 129 EXECUTIVE OFFICE S$ 445,398 $463,439 $489,357 $510,826 $191,980 $524,622 | CL OALL |
br
Department Head signature / Date
Date: 12/1/2021 Page: 2Tab 6 - 129, 151, 195, 244 - Executive Area.pdf · Source page 3
PAYROLL PROJECTIONS - FY 2023
New FY23
FY22 Pay hourly rate with
Employee Job Class Hours Per Hourly FY22 Pay FY23 Next FY23 Next step and/or FY23 Annual FY23
Number Last Name First Name Code Job Class Code Desc Location Code Desc Group/BU Org Object Status Pay Grade Pay Step Year Rate Annual Salary Grade Step COLA Salary (261 days) Longevity
1763 ASPINWALL CHARLES 1291 TOWN ADMINISTRATOR EXEC. SECRETARY PC 11291 51100 FT CA 1 2080 103.37 215,000 CA 1 105.95 221,223 0
51100 Total 215,000 221,223 0
111 CONNOLLY JOHN 1290 SELECTMAN EXEC. SECRETARY EL 11291 51101 PB BS 1 52 116.67 1,400 BS 1 116.67 1,400 0
1781 CONNOLLY CHRISTOPHER 1290 SELECTMAN EXEC. SECRETARY EL 11291 51101 PB BS 1 52 116.67 1,400 BS 1 116.67 1,400 0
1956 LOPEZ ALICIA 1290 SELECTMAN EXEC. SECRETARY EL 11291 51101 PB BS 1 52 116.67 1,400 BS 1 116.67 1,400 0
1880 LOUGHRAN MICHAEL 1290 SELECTMAN EXEC. SECRETARY EL 11291 51101 PB BS 2 52 133.33 1,600 BS 2 133.33 1,600 0
1782 THEODORE THOMAS 1290 SELECTMAN EXEC. SECRETARY EL 11291 51101 PB BS 1 52 116.67 1,400 BS 1 116.67 1,400 0
51101 Total 7,200 7,200 0
1392 LEVITSKY JUDITH 1294 SECRETARY EXEC. SECRETARY PB 11291 51140 FT K-35 19 1820 28.74 52,307 K-35 19 28.74 52,508 950
51140 Total 52,307 52,508 950
1857 BOGUE LAURIE 1293 ADMINISTRATIVE SECRETARY EXEC. SECRETARY PB 11291 51146 FT H-35 10 1820 34.15 62,153 H-35 11 34.66 63,324 0
51146 Total 62,153 63,324 0
1234 KEMALIAN JENNIFER 1292 EXECUTIVE ASSISTANT EXEC. SECRETARY PB 11291 51150 FT F-35 13 1820 41.19 74,966 F-35 14 41.81 76,387 800
51150 Total 74,966 76,387 800
11291 Total 411,626 420,641 1,750
9 11291 Count
Payroll Projections FY23.xlsx
1/6/2022 12:15 PM Page 1 of 1Tab 6 - 129, 151, 195, 244 - Executive Area.pdf · Source page 4
TOWN OF CANTON BUDGET REPORT FOR FY 2023 DEPARTMENTAL WORKSHEETS 151. TOWN COUNSEL SUBTOTAL SALARIES & WAGES 11512 - 53118 PROF SERV-LABOR RELATIONS 11512 - 53803 CONSULTING SERVICES - RETAIN 11512-53802 LEGAL SERVC. CONSULTANT 11512-55100 BOOKS & PERIODICALS SUBTOTAL EXPENSES SUBTOTAL SEGREGATED (CURRE TOTAL 151 TOWN COUNSEL Date: 12/1/2021 FY 19 FY 20 FY21 ORIGINAL FY 2023 FY 2023 COMMENT/REASON FOR ACTUAL ACTUAL ACTUAL BUDGET ACTUAL YTD BASE DEPT. INCREASE / DECREASE EXPENSE EXPENSE EXPENSE FY22 EXPENSES THRU BUDGET REQUEST 12/30/21 § 9 $30 $0 $0 $0 $0 28,215 12,796 9,550 15,000 4,449 15,000 a 62,500 62,500 70,600 62,500 26,042 62,500 a 255,978 115,774 125,541 215,540 59,639 215,540 if 3,974 6,418 6,334 6,400 3,270 6,400 a $ 350,667 $257,488 $212,025 $299,440 $93,399 $299,440 244,440 $ 0 $0 $0 380 $0 $0 $ 350,667 $257,488 $212,025 $299,440 $93,399 $299,440 | 2 Aa H4e | la Department Head signature / Date Page: 12
Tab 6 - 129, 151, 195, 244 - Executive Area.pdf · Source page 5
TOWN OF CANTON By19 FY20 FY¥21 ORIGINAL ACTUAL RY aes vas COMMENT/REASON FOR ACTUAL AL XTD - INCREASE / DECREAS! BUDGET REPORT FOR FY 2023 EXPENSE EXPENSE MPENSE ere EXPENSES THRU «© BUDGET REQUEST PASE DEPARTMENTAL WORKSHEETS a 1130/04 198 TOWN REPORTS 11952-53409 PRINTDISTR-TOWN REPORT 2,709 2,500 2,935 3,000 0 300 ©_ 2150 S*|e SUBTOTAL EXPENSES $ 2,709 $2,500 $2,935 $3,000 $0 $3,000 TOTAL 195 TOWN REPORTS a 2709 $2,500 $2,935 $3,000 30 Bo [3is0 | Date: 12/3/2021 Department Head signature / Date Page: 33
Tab 6 - 129, 151, 195, 244 - Executive Area.pdf · Source page 6
TOWN OF CANTON BUDGET REPORT FOR FY 2023 DEPARTMENTAL WORKSHEETS 154 HUMAN RESOURCES DEPT 11541-51109 HUMAN RESOURCE ADMIN SALAF 11541-51159 CLERICAL SALARY 11541-51159 CLERICAL SALARY 11541 - 51300 OVERTIME SALARY SUBTOTAL SALARIES & WAGES 11542 - 52000 PURCHASE OF SERVICES 11542 - 53400 TELEPHONE/COMMUNICATIONS 11542 - 53406 COMMUNICATIONS - OTHER 11542 - 53408 POSTAGE 11542 - 54200 OFFICE SUPPLIES 11542-57105 IN-STATE TRAVEL 11542 - 57107 EMPLOYEE TRAINING EXPENSES 11542 - $7120 MEETINGS 11542-57300 DUES & MEMBERSHIPS 11542 - 57404. OTHER EMPLOYEE BENEFITS SUBTOTAL EXPENSES TOTAL 154 HUMAN RESOURCES DEPT add VeuL Pree. evn Ve amplyment DhySicals FY19 FY20 FY21 ORIGINAL FY 2023 FY 2023 COMMENT/REASON FOR ACTUAL ACTUAL ACTUAL BUDGET ACTUAL YTD BASE DEPT. INCREASE / DECREASE EXPENSE EXPENSE EXPENSE FY22 EXPENSES THRU BUDGET REQUEST 11/30/21 98,296 106,602 107,494 107,882 45,112 113,355 63,755 66,201 68,489 70,230 29,376 73,427 0 917 530 0 277 0 0 0 16 0 49 0 S$ 162.050 $173,720 $176,589 $178,112 $74,814 $186,782 2,800 0 0 750 0 750 341 376 498 450 224 450 435 552 1,103 432 166 432 435 422 238 1,000 42 1,000 637 1,234 1,682 1,000 166 1,000 312 36 0 500 0 500 2,337 1,763 1,995 5,000 562 5,000 80 225 145 1,000 15 1,000 1,188 983 1,103 1,700 644 1,700 0 1,822 1,000 1,650 0 1,650 S$ 8565 $7,413 $7,764 $13,482 $1,878 s13482 cd XBSOOOD $ 170,615 $181,133 $184,353 $191,594 $76,693 $200,264, Date: 12/1/2021 ~Yse - enrpky ment — wot Qaorledy leohrs - ¥ ~ Clening Horse. Caueries Qseo = i Abt pr Department Head signature / Date e attodh pects Sd Page: 14
Tab 6 - 129, 151, 195, 244 - Executive Area.pdf · Source page 7
PAYROLL PROJECTIONS - FY 2023
sec Hews
¥v22 Pay a hourty rare with} | FY23 Annual
Employee Job Cass Hours | Moutly FY22 Pay fi] F¥23Next | FY23 Next | stepand/or ‘Salary (263 a
Number LastName First Name. code, Joh Class Code Desc Locath le Group/au Org Object, Status | Pay Grade Pay Step! Per Year Rate. Annual Salary [eit Grade Step. COLA days), Longevity.
1498 [MIDDLETON JODY 1540 __| HUMAN RESOURCE DIRECTOR [HUMAN RESOURCE PC. 4154) 51109 fT Je 1__[ 2080 $2.70{ 409,638] JK 1 $4.29 113.355 9
52109 Total 109,618 Hi 413.355) 9
i739 [HARTLING MEREDITH 1541_|HR SPECIALIST IRUMAN RESOURCE PB US41 $1159 #1 G35 35 [4820 39.89 72,0538] G95 is 40.19 73,427 650
51159 Total 72,054}! 73,427 650)
11544 Total 186,782! 659)
2 11561 Count
Payroll Projections FY23.xIsx
14/30/2021
Page LoftTab 6 - 129, 151, 195, 244 - Executive Area.pdf · Source page 8
1 of Transportation Carrier Safety Administration CLEARINGHOUSE j What is the FMCSA Commercial Driver’s License Drug and Alcohol Clearinghouse? The Clearinghouse is a secure online database that gives employers, FMCSA, State Driver Licensing Agencies, and State law enforcement personnel real-time information about CDL driver drug and alcohol program violations, thereby enhancing safety on our Nation’s roadways. An act of Congress directed the Secretary of Transportation to establish the Clearinghouse. ¥|] Record (¥} Consent “| Query | Safety The Clearinghouse contains information about drivers with commercial driver's licenses (CDL drivers) who are covered by FMCSA's drug and alcohol program. This also includes drivers with commercial learner’s permits (CLPs). For more information on drivers affected by the Clearinghouse, see other side. ara When must | use the Clearinghouse? VY) 2020 JANUARY 6, 2020: Authorized users are required to complete the actions described in the Clearinghouse final rule. Employers are required to conduct both electronic queries and traditional manual inquiries with previous employers to meet the three-year timeframe, required by FMCSA’s drug and alcohol use testing program, for checking CDL driver violation histories. Drivers may also view their own records for information recorded on or after January 6, 2020. ELLE JANUARY 6, 2023: Once three years of violation data JAN are stored in the Clearinghouse, employers are no 2023 longer required to also request information from the driver’s previous FMCSA-regulated employers under 391.23(e); an employer's query of the Clearinghouse will satisfy that requirement. How does the Clearinghouse improve highway safety? Makes it easier for employers to meet their pre- employment investigation and reporting obligations. [J Makes it more difficult for drivers to conceal their drug and alcohol program violations from current or prospective employers. 1 Provides roadside inspectors and other enforcement personnel with the means to ensure that drivers receive required evaluation and treatment before performing safety-sensitive functions, such as driving a commercial motor vehicle (CMV). & Makes it easier for FMCSA to determine employer compliance with testing, investigation, and reporting requirements.
Tab 6 - 129, 151, 195, 244 - Executive Area.pdf · Source page 9
FY 2021 2020 2019 2018 2017 TOTAL AVERAGE 2022 YTD VENDOR PAYMENT HISTORY CARECENTRAL ADVANTAGEDRUG TOTAL 1,537 2,740 4,277 1,674 2,605 4,279 3,049 2,155 5,204 1,855 1,610 3,465 na 1,655 1,655 8,115 10,765 18,880 2,029 2,153 4,182 1,170 1,625 2,795
Tab 6 - 129, 151, 195, 244 - Executive Area.pdf · Source page 10
Middleton, Jody From: brett@advantagedrugtesting.com Sent: Monday, December 27, 2021 1:23 PM To: Middleton, Jody Ce: Hartling, Meredith; Adrian Hohenberger; randoms department Subject: Re: Clearinghouse Quote, Contract & To-Doss CAUTION: This email originated from outside your organization. Exercise caution when opening attachments or clicking links, especially from unknown senders. Hi Jody, For the 2023 Budget plan on 1 Query per driver so approximately 50 x 1.25 = 62.50, plus the annual fee covering that year of $200. For 2022, we will be running them in July/August, which | think means it will fall into your 2023 budget(?). Adrian is connecting with Meredith as we speak, to update the roster, and confirm all the limited query consent forms have been signed. Regards, Brett Urquhart Advantage Drug Testing 978-475-1312 On Dec 27, 2021, at 12:45 PM, Middleton, Jody <jmiddleton@town.canton.ma.us> wrote: Hi Brett, | am in the process of doing my budget for FY23 and looked to see if | needed to purchase more queries for the annual report run on all of our drivers. Do you know when you will be running them and is there anything else you need from us? | can supply you with an updated DOT listing. Thank you, Jody me fyR. HMiddleton Town of Canton - HR Director 801 Washington Street, Second Floor Canton, MA 02021 (p) 781-821-2936 (F) 781-575-6602 jmiddleton@town.canton.ma.us From: brett@advantagedrugtesting.com <brett@advantagedrugtesting.com> Sent: Tuesday, April 27, 2021 1:57 PM To: Middleton, Jody <jmiddleton@town.canton.ma.us>; Hartling, Meredith <mhartling@town.canton.ma.us> Ce: Adrian Hohenberger <adrian@advantagedrugtesting.com>; randoms department
Tab 6 - 129, 151, 195, 244 - Executive Area.pdf · Source page 11
TOWN OF CANTON BUDGET REPORT FOR FY 2023 DEPARTMENTAL WORKSHEETS 244. SEALER OF WEIGHTS & MEAS SUBTOTAL SALARIES & WAGES 12442 - 52000 PURCHASE OF SERVICES SUBTOTAL EXPENSES TOTAL 244 SEALER OF WEIGHTS & MEAS Date: 12/1/2021 ryig FY20 FY21 ORIGINAL FY 2023 FY 2023 COMMENT/REASON FOR ACTUAL ACTUAL ACTUAL BUDGET ACTUAL YTD BASE DEPT. INCREASE / DECREASE EXPENSE EXPENSE. EXPENSE FY 22 EXPENSES THRU BUDGET REQUEST 11/30/21 $ 0 $0 30 $0 $0 $0 7,500 7,500 7,500 7,500 0 7,500 v $ 7.500 $7,500 $7,500 $7,500 $0 $7,500 $ 7,500 $7,500 $7,500 $7,500 $o $7,500 | S00 | b Department Head signature / Date Page: 49
Tab 6 - 154 - Human Resources.pdf · Source page 1
TOWN OF CANTON FY19 FY 20 FY21 ORIGINAL FY 2023 FY 2023 COMMENT/REASON FOR CTUAL ACTUAL ACTUAL BUDGET ACTUAL YTD BASE DEPT. INCREASE / DECREASE BUDGET REPORT FOR FY 2023 SC DENSE EXPENSE EXPENSE FY22 EXPENSES THRU BUDGET REQUEST DEPARTMENTAL WORKSHEETS ey AUS /21. 154 HUMAN RESOURCES DEPT 11541-51109 HUMAN RESOURCE ADMIN SALAF 98,296 106,602 107,494 107,882 45,112 113,355 11541-51159 CLERICAL SALARY 63,755 66,201 68,489 70,230 29,376 73,427 11541-51159 CLERICAL SALARY 0 917 530 0 277 0 11541 - 51300 OVERTIME SALARY 0 0 16 0 49 0 SUBTOTAL SALARIES & WAGES $ 162,050 $173,720 $176,589 $178,112 $74,814 $186,782 11542 - 52000 PURCHASE OF SERVICES 2,800 0 0 750 0 750 11542 - 53400 TELEPHONE/COMMUNICATIONS 341 376 498 450 224 450 11542 - 53406 COMMUNICATIONS - OTHER 435 552 1,103 432 166 432 11542 - 53408 POSTAGE 435 422 238 1,000 42 1,000 11542 - 54200 OFFICE SUPPLIES 637 1,234 1,682 1,000 166 1,000 11542 - 57105 IN-STATE TRAVEL 312 36 0 500 0 500 11542 - 57107 EMPLOYEE TRAINING EXPENSES 2,337 1,763 1,995 5,000 562 5,000 11542-57120 MEETINGS 80 225 145 1,000 75 1,000 11542 - 57300 DUES & MEMBERSHIPS 1,188 983 1,103 1,700 644 1,700 11542 - 57404 OTHER EMPLOYEE BENEFITS 0 1,822 1,000 1,650 0 1,650 SUBTOTAL EXPENSES S$ 8565 $7,413 $7,764 $13,482 $1,878 $13,482 c.cld XAGOOD TOTAL 154 HUMAN RESOURCES DEPT $170,615 $181,133 $184,353 $191,594 $76,693 $200,264, Bez id lem y/ Li Le Oe Crdd Deo fine \ i + “Ye amplyrunt DhySicals = I Q<eo- ooh ~K Og Feckng = ANDi SOO i oP Date: 12/1/2021 ~Ypse - enrphy ment be Page: 14 — Det Qarledy leaks — Cleans Howse. Covenieo
Tab 6 - 154 - Human Resources.pdf · Source page 2
PAYROLL PROJECTIONS - FY 2023
‘New FY2S
FY22 Pay ‘hourly rate with; FY23 Annual
Employee Job Class Hours | Hourly Fy23Next | stepandfor | Salary {261 F238
Number LastName First Name Code Job Class Code Desc Location Code Desc Growp/BU Org Object Status | Pay Grade | Pay Step! Per Year Rate Step COLA days) Longevity
[2458 [MIDDLETON oDy 1540 |HUMAN RESOURCE DIRECTOR HUMAN RESOURCE PC 11541 51109 fT JKM. 1 2080 $2.70 i $4.29 113,355 9
$1109 Total 113,355 Q
1789 [HARTLING MEREDITH 1541 [HR SPECIALIST HUMAN RESOURCE PB 11544 51159 fT G35 15_| 1820 39.59 16 40.19 73,427 650
51159 Total 73,427 650
11541 Total 186,782 650
11541 Count
Payroll Projections FY23.xisx
Page Lof i
11/30/2021Tab 6 - 154 - Human Resources.pdf · Source page 3
(A) U.S. Department of Transportation ‘@ Federal Motor Carrier Safety Administration Coe oe — We Mi Record m| Boy i Consent : | Query he || w Safety What is the FMCSA Commercial Driver’s The Clearinghouse contains License Drug and Alcohol Clearinghouse? Information about drivers with The Clearinghouse is a secure online database that commercial driver's licenses (CDL : 7 : r drivers) who are covered by FMCSA’s gives employers, FMCSA, State Driver Licensing Agencies, drug and alcohol program. This also and State law enforcement personnel real-time includes drivers with commercial information about CDL driver drug and alcohol program learner’s permits (CLPs). violations, thereby enhancing safety on our Nation's For more’information ondiivers roadways. An act of Congress directed the Secretary of affected by the Clearinghouse, Transportation to establish the Clearinghouse. see other side. om When must I use the Clearinghouse? @ How does the Clearinghouse 3020 JANUARY 6, 2020: Authorized users are required improve highway safety? to complete the actions described in the M Makes it easier for employers to meet their pre- Clearinghouse final rule. Employers are required employment investigation and reporting obligations. to conduct both electronic queries and traditional manual inquiries with previous employers to meet @ Makes it more difficult for drivers to conceal their the three-year timeframe, required by FMCSA’s drug and alcohol program violations from current or drug and alcohol use testing program, for checking prospective employers. CDL driver violation histories. Drivers may also view their own records for information recorded on or M Provides roadside inspectors and other enforcement after January 6, 2020. personnel with the means to ensure that drivers receive required evaluation and treatment before ELMS JANUARY 6, 2023: Once three years of violation data performing safety-sensitive functions, such as driving JAN are stored in the Clearinghouse, employers are no a commercial motor vehicle (CMV). 2023 longer required to also request information from the driver’s previous FMCSA-regulated employers [J Makes it easier for FMCSA to determine under 391.23(e); an employer's query of the employer compliance with testing, investigation, Clearinghouse will satisfy that requirement. and reporting requirements.
Tab 6 - 154 - Human Resources.pdf · Source page 4
FY 2021 2020 2019 2018 2017 TOTAL AVERAGE 2022 YTD VENDOR PAYMENT HISTORY CARE CENTRAL ADVANTAGE DRUG TOTAL 1,537 2,740 4,277 1,674 2,605 4,279 3,049 2,155 5,204 1,855 1,610 3,465 na 1,655 1,655 8,115 10,765 18,880 2,029 2,153 4,182 1,170 1,625 2,795
Tab 6 - 154 - Human Resources.pdf · Source page 5
Middleton, Jody From: brett@advantagedrugtesting.com Sent: Monday, December 27, 2021 1:23 PM To: Middleton, Jody Cc: Hartling, Meredith; Adrian Hohenberger; randoms department Subject: Re: Clearinghouse Quote, Contract & To-Doss CAUTION: This email originated from outside your organization. Exercise caution when opening attachments or clicking links, especially from unknown senders. Hi Jody, For the 2023 Budget plan on 1 Query per driver so approximately 50 x 1.25 = 62.50, plus the annual fee covering that year of $200. For 2022, we will be running them in July/August, which | think means it will fall into your 2023 budget(?). Adrian is connecting with Meredith as we speak, to update the roster, and confirm all the limited query consent forms have been signed. Regards, Brett Urquhart Advantage Drug Testing 978-475-1312 On Dec 27, 2021, at 12:45 PM, Middleton, Jody <jmiddleton@town.canton.ma.us> wrote: Hi Brett, | am in the process of doing my budget for FY23 and looked to see if | needed to purchase more queries for the annual report run on all of our drivers. Do you know when you will be running them and is there anything else you need from us? | can supply you with an updated DOT listing. Thank you, Jody fly. Middleton Town of Canton - HR Director 801 Washington Street, Second Floor Canton, MA 02021 (p) 781-821-2936 (F) 781-575-6602 jmiddleton@town.canton.ma.us From: brett @advantagedrugtesting.com <brett@advantagedrugtesting.com> Sent: Tuesday, April 27, 2021 1:57 PM To: Middleton, Jody <jmiddleton@town.canton.ma.us>; Hartling, Meredith <mhartling@town.canton.ma.us> Cc: Adrian Hohenberger <adrian@advantagedrugtesting.com>; randoms department
Tab 6 - 179 - Planning Dept.pdf · Source page 1
TOWN OF CANTON FY 19 FY 20 FY21 ORIGINAL, ACTUAL YTD Ry 2s EY207¥ COMMENT/REASON FOR BUDGET REPORT FOR FY 2023 eee Brake see oar Pctebeh sam miocer mEQUEST INCREASE / DECREASE DEPARTMENTAL WORKSHEETS 179 PLANNING DEPARTMENT 11791 - 51100 DEPARTMENT HEAD SALARY 72,624 80,108 72,658 $1,071 32,113 85,183 107,660 Promotion to Community Development Director, 40 hours a week 11791 - 51100 DEPARTMENT HEAD SALARY 0 0 5,428 0 1,177 0 11791- TBD ASSISTANT STAFF SALARY 0 0 0 0 0 0 80,000 Request for Assistant Town Planner or Economic Development Coordinator SUBTOT SALARIES & WAGES S$ 72,624 $80,108 $78,086 $81,071 $33,290 $85,183 11792 - 53400 TELEPHONE/COMMUNICATIONS 332 303 422 350 197 350 11792- 54200 OFFICE SUPPLIES 901 873 258 1,000 415 1,000 11792 - 57000 OTHER CHARGES&EXPENDITUR 1,025 463 390 900 5 900 11792- 57102 IN-STATE TRAVEL PLUM/GAS 0 81 0 0 0 0 11792- 57107 EMPLOYEE TRAINING EXPENSES 1,466 456 1,665 1,300 ns 1,300 11792- 57120 MEETINGS 0 255 53 550 24 550 11792- $7300 DUES & MEMBERSHIPS 5,165 5,574 5,688 5,655 5,631 5,655 11792- 57404 OTHER EMPLOYEE BENEFITS 0 308 310 550 310 550 SUBTOT EXPENSES $s 8,889 $8,312 $8,787 $10,305 $6,807 $10,305 TOTAL 179 PLANNING DEPARTMENT s 81,513 $88,420 $86,873 $91,376 $40,096 $95,488 Date: 12/7/2021 Page 25
Tab 6 - 179 - Planning Dept.pdf · Source page 2
Dear Charlie,
I am writing to you today because I have identified a need for at
TO:
least 1 additional full-time permanent staff member in the
Planning Department.
The population of Canton increased by 2,809 persons, or 13.0%,
from 2010 to 2020. Comparatively, Massaschusetts increased by
7.4%. This rate is faster than any of the population projections
from the Master Plan. We have also grown at a faster rate than any
MR. CHARLES ASPINWALL of the surrounding towns. At the same time, we have fewer
planning staff than most surrounding Towns and other Towns with
Town Administrator
similar populations.
TOWN OF CANTON Hiring additional staff to the Planning Department will help the
801 Washington Street Town more thoroughly evaluate development applications,
Canton, MA 02021 improve personal attention to small business economic
development, and increase our ability to apply for and manage
grants.
DATE
Monday
I understand that you need to consider how to pay the salary and
December 6, 2021
benefits of an additional full-time permanent staff member. I have
proposed ARPA funding and CCPC funding towards 2-year
positions in economic development and housing that can ease this
transition, if needed. However, ideally this would be at least one
full-time non grant funded position.
I have chosen not to apply for some grants or projects because of
my Department's lack of capacity. I want to continue to offer a high
quality of service to Canton and build the best Planning
Department in the region. Thank you, and I look forward to
continuing this conversation with you.
Sincerely,
Laura Smead, AICP
Town PlannerTab 6 - 179 - Planning Dept.pdf · Source page 3
LAURA SMEAD
PLANNING PROFESSIONAL
PERSONAL PROFILE
I am an AICP credentialed planning professional with
extensive experience in both research and applied municipal
CONTACT planning, as well as higher-education work in research,
project management, data analysis, fundraising, and
801 Washington Street
Canton MA 02021 administration.
EDUCATIONAL HISTORY
lsmead@town.canton.ma.us
Tufts University
https://www.town.canton.ma.us/
Masters in Urban & Environmental Policy & Planning
334/Planning
Sep 2011 - Dec 2013
https://www.linkedin.com/in/
laurasmead
California State University Fullerton
Masters in Psychology
Sep 2007 - May 2009
SKILLS SUMMARY
University of Minnesota Duluth
Project Management
Bachelors of Applied Science in Psychology
Sep 2002 - Dec 2006
Urban Planning
PLANNING EXPERIENCE
Grant Writing
Town Planner
GIS Town of Canton | Jul 2016 - present
Led the Master Plan update, and 16 other strategic plans
Adobe InDesign
(open space, climate change, economic development,
land use).
Communication
Successfully applied for and managed over $3.8 million
worth of grants.
Staffed 10 committees of more than 60 volunteers.
ACHIEVEMENTS Prepare planning studies and reports, statistical data,
ArcGIS maps, and zoning changes.
EDRA Great Places Award (2018) Provide professional review for new development, site
plans, and subdivisions.
Led many community and stakeholder meetings on
American Institute of Certified
Planners credential (2017) planning studies or zoning proposals.
Presented at national and regional planning conferences
Co-authored "Creating Healthy (American Planning Association, Southern New England
Neighborhoods: Evidence-
Planning Association, etc).
based Planning and Design
Strategies (2017)Tab 6 - 179 - Planning Dept.pdf · Source page 4
PLANNING EXPERIENCE (CONTINUED)
Research Associate
Harvard University Graduate School of Design - Feb 2014 - Jun 2016
Involved with extensive research and writing for the Health and Places Initiative and Waste to
Energy Design Lab, resulting in numerous online research summaries and tools, and three book
publications. This required extensive use of InDesign software.
Co-authored the book (2017) Creating Healthy Neighborhoods: Evidence-based Planning and Design
Strategies, which won the 2018 EDRA Great Places award.
Involved with many aspects of two other publications, (2017) Architecture and Waste: A (Re)Planned
Obsolescence and (2016) Lifestyled Health and Places, including authoring chapters.
Sustainability Planning Intern
Cambridge Community Development Department - Jun 2013 - Jan 2014
Research, GIS analysis and visualization, and writing reports relating to sustainability indicator
metrics, climate change vulnerabilities, flood adaptation, and green roof effectiveness.
Conducted solar feasibility analysis for municipal buildings in Cambridge.
Junior Planner
Larry Koff & Associates, Brookline, MA - Sep 2013 - Oct 2013
Consulted on a third party review of the fiscal and economic impacts of the proposed Milford, MA
casino on surrounding communities, through research, writing, and ArcGIS mapping.
Parking Projects Manager
City of Somerville Traffic and Parking Department - Feb 2013 - Jun 2013
Reviewed and managed several new parking initiatives such as online permits, new parking meter
technologies, implemented a new pavement marking management program, and analyzed demand
based parking programs.
Wrote RFP for citywide smart parking meters (now implemented).
Redesigned several flyers and brochures and managed the website.
Sustainability Planning Intern
Boston Cyclists Union - May 2012 - Aug 2012
Wrote and redesigned program evaluation questionnaire.
Designed and created several posters and educational brochures using Adobe InDesign and
Photoshop.
Volunteered as a bicycle advocate on bike-to-work days.Tab 6 - 179 - Planning Dept.pdf · Source page 5
OTHER EXPERIENCE Senior Data Analyst Northeastern University - Oct 2010 - Aug 2011 Conducted extensive and significant data collection, statistical analysis, and reporting regarding the university’s graduate programs to university, state, and federal departments. Designed and implemented online and paper surveys to applicants and potential students who attended informational sessions and open houses. I also organized a graduate student research expo with over 200 participants. Research Assistant London School of Economics, United Kingdom - Oct 2009 - Jul 2010 Conducted a statistical analysis of European Union refugee asylum data. Published a co-authored paper in the Journal of European Union Politics (2012). Department Administrator London School of Economics, United Kingdom - March 2009 - July 2010 Responsible for all undergraduate related administration and departmental communication and marketing strategies in the Department of Philosophy, Logic, and Scientific Method. This included managing and updating the department website. Development Analyst University of California Irvine - Jan 2007 - Aug 2009 Provided administrative, research, and project support for the department. Implemented strategies to identify prospective and current principal gifts and foundation donors. Wrote and designed $900,000 fundraising proposals and conducted national benchmarking. VOLUNTEER EXPERIENCE Master Plan Implementation Committee Town of Sharon - May 2021 - present The Master Plan Implementation Committee coordinates and advises the implementation of the comprehensive master plan for the Town. Sharon Gallery Design Review Committee Town of Sharon - April 2020 - Sept 2020 Review site plan, aesthetics, and landscaping etc. for the Sharon Gallery development. Master Plan Steering Committee Town of Sharon - April 2016 - Sept 2019 The Master Plan Steering Committee directed the preparation of the first comprehensive master plan for the Town.
Tab 6 - 179 - Planning Dept.pdf · Source page 6
Planning Department Staffing Benchmarking
Economic
2020 Planning Town Office Staff Development Housing Conservation
Town Population Director Planner Administrator Planner Staff Coordinator Administrator/Agent Other Total Staff
Yarmouth 25,023 1 1 1 1 1 1 6
Wilmington 23,349 1 2 1 4
Acton 24,021 1 1 1 1 4
Canton 24,370 1 1
Stoneham 24,004 1 1
Hingham 24,284 Vacant? 1 1 1 3
Westford 24,643 1 1 1 2 5
Easton 25,058 1 1 2 1 5
Walpole 25,324 1 1 2
Dedham 25,283 1 1 1 1 4
Middleborough 24,245 1 1 1 3
Marshfield 25,825 1 1 2
Sharon 18,575 0.5 0.5 1
Stoughton 28,939 1 1 2
Randolph 34,984 1 0.5 2
Milton 28,630 1 1 1 3
Westwood 16,974 1 1 1 1 1 5
Norwood 31,611 1 1 1 1 4
Medfield 13,097 1 1 2
Needham 32,091 1 1 1 1 4