Canton, Massachusetts · Saved source text
FY20 Municipal Budget - Dept Requests - Jan 2019 pdf file
Saved text from 171 source pages. Transcription and OCR may contain errors; verify figures and wording against the original. Retrieved 2026-10-15.
Source page 161
PAYROLL PROJECTIONS - FY 2020
New FY30
hourly rate
with stop iY20
FY19 Mrs Per FY39 Pay Hourly F39 Pay FY2D Neat FY20 Nert and/or FY20 Annul Ertimated
Employee Iast Name first Name lob q~ss Job pass Desc Lootion Dezc Group/BU OrC ~6jeR Sbtus Pay Gnde Gay Step Vear Rita Mnual Salary Gnde Step COU1 Salary 262 days LoneaviH
1824 QUINLAN KELSEY 4118 GIS COORDINATOR ENGINEERING/SEWER PC 56000 51000 Fi GIS 0 624 30.01 18,727 GIS 0 30.76 19,343 0
1 56000 Count
51000 Total 18,727 19,343 0
36 BOGUE LAWRENCE 4401 SEWER FOREMAN SEWER AF 56000 51120 Fi F-40 12 2080 37.50 78,000 F40 13 38.06 79,774 1,750
1184 SYKES CHRISTOPHER 4501 WATER/SEWER SUPERVISOR SEWER AF 56000 51120 Ff E-40 11 1040 43.11 44,834 E~0 12 43.75 45,850 800
Z 56000 Count
51120 Total 122,834 125,624 2,550
1826 GALLAGHER JAMES 4204 HEAVY EQUIPMENT OPERATOR SEWER AF 56000 51122 FT 1-00 1 2080 23.35 48,568 J-40 2 23.70 49,675 0
1271 LOUGHRAN BRIAN 4204 HEAVY EQUIPMENT OPERATOR SEWER AF 56000 51122 Ff 1-40 16 2080 29.18 60,694 J-40 16 29.18 61,161 600
Z 56000 Count
51122 Total 109,262 110,836 600
889 LENHART CHARLES 4402 UTILITIES MAINTENANCE TECHNICI SEWER AF 56000 51123 FT I-40 22 2080 34.96 72,717 I-40 22 34.96 73,276 1,000
1 56000 Count
51123 Total 72,717 73,276 1,000
1848 MUNDEN GAMZE 4116 STAFF ENGINEER ENGINEERING PB 56000 51135 FT H 11 1248 31.40 39,187 H 12 3331 41,894 0
1 56000 Count
51135 Total 39,187 41,894 0
14691ERRIER MICHAEL 4507 WATER&SEWER ACCT COORDINATOR SEWER AF 56000 51142 FT K-40 10 1040 24.27 25,241 K-41 12 25.00 26,200 0
1 56000 Count
53142 Total 25,241 26,200 0
1359 CAWLEY PATRICIA 4502 WATER/SEWER OFFICE ADMINSTRATO SEWER AF4 56000 51143 FT 168 3 1040 31.76 33,030 168 4 33.03 34,616 600
1 56000 Count
51143 Total 33,030 34,616 600
9 56000 Count
56000 Total 420,999 431,789 4,750
~a'~ ~D ~
Payroll Projections FY20..xlsu Munis download for FY20
11/28/2018 12:10 PM 33 of 35Source page 162
TOWN OF CANTON COMMENT/REASON FOR
FY 16 FY 17 FY IS ACTUr1L YTD pglG~+pI, FY 2020 FY 2020
BUDGET REPORT FOR FY 2020 ACTUAL ACTUAL ACTUAL EXPENSE THRU BUDGET DEPARTMENTAL DEPT INCREASE/DECREASE
DEPARTMENTAL WORKSHEETS EXPENSE E7CPENSE EaPENSE 9/30/2018 FY 19 $ASE BUDGET REQUEST
56002-59101- PRINC PD-OS/11 DEBT 74,000 73,000 71,000 0 71,000 71,000
56002-59106- PRIN PD-3/15 DEBT 82,750 82,000 79,000 0 77,000 77,000 d
,~~
~~
5600?-59107- INT PD-03/15 DEBT 15,698 13,215 10,755 4,193 8,385 8,385 7
5600?-59109- PRINCIPAL PAID TO MWRA 113,300 113,300 113,300 113,300 113,300 113,300
56002-59126- PRINCIPAL PAID TO MWPAT 166,665 170,032 173,467 176,971 176,971 176,971 8"0 S
56002-591?8- PRINC PD-01/08 DEBT 5,000 0 0 0 0 0
56002-59]31- PRINC PD-3/12 DEBT ]00,000 100,000 100,000 0 100,000 100,000 /Od,6~4
56002-59132- PRINC PD-03/13 DEBT 17,000 17,000 ]7,000 0 15,000 15,000 O OD
56002-59133- PRINC PD-11/13 DEBT 266,600 257,600 248,500 0 239,400 239,400 as o00
56002-59135- PRIN PD-03/14 DEBT 48,200 48,200 48,100 0 48,100 48,100
5600?-59138- PRINC PD - 05/09 DEBT 26,000 26,000 0 0 0 0
56002-59]44- PRIN PD-03/16 DEBT 0 69,000 65.,000 0 60,000 60,000 .~ l.Oall
56002-59145- INT PD-03/16 DEBT 0 10,115 10,840 4,770 9,540 9,540
56002-59148- PRIN PD-04/17 DEBT 0 0 27,000
-T~'
0 25,000 25,000
56002-59150- INTEREST PD OS/11 13,930 11,710 9,520 0 6,680 6,680
56002-59160- INTEREST PD TO MWPAT 65,103 61,484 57,791 27,963 54,024 54,024
5600?-59176- INT PD-01/08 DEBT 2,506 0 0 0 0 0
56002-59178- INT PD - 05/09 DEBT 3,090 2,310 0 0 0 0
5600?-59181- INT PD - 3/12 DEBT 51,000 48,000 46,000 62,350 43,000 43,000 d0
56002-59182- INT PD - 03/13 DEBT 3,780 3,270 2,760 1,125 2,250 2,250 d
56002-59183- INT PD-11/13 DEBT 48,932 40,551 30,934 5,425 21,676 21,676
56002-59185- INT PD-03/14 DEBT 19,355 16,945 14,535 6,065. 12,130 12,130 r
5600?-59188- INT PD-04/17 DEBT 0 0 1,156 0 500 500
SUBTOTAL EXPENSES $1,122,909 $1,163,732 $1,126.,658 $402,162 i
$1,083,956 $1,083,956
~j~~~ i
SUBTOTAL SEWER PRINC/INT PAYMENTS $1,122,909 X1,163,732 $1,126,658 $402,162 X1,083,956 1,08 S6
pt Head Sign tore /Date
~~ ~~
Date: 11/28/2018 W~~Munis\MCR Library\Budget reports\New Fiscal Year budget worksheet -Dept Req-enterprise by sal-exp.rpt Pagc: 3Source page 163
DEBT SERVICE PAYMENTS FROM FY 19 THRU FY 37
Date of Debt Service Type of
Issue Type Description Org Object Payment 2020
5/1/2011 S GOB Sewer REFUNDING (Self-Supporting)(Algonquin Sewers) 56002 59101 Principal 68,000.00
59101 Total 68,000.00
3/15/2015 S Engineering Services -Sewer 56002 59106 Principal -
3/15/2015 S Water Meters -Sewer 56002 59106 Principal 27,000.00
3/15/2015 S Water Meters -Sewer 56002 59106 Principal 13,000.00
59106 Total 40,000.00
3/15/2015 S Engineering Services -Sewer 56002 59107 Interest -
3/15/2015 S Water Meters -Sewer 56002 59107 Interest 3,915.00
3/15/2015 S Water Meters -Sewer 56002 59107 Interest 2,160.00
59107 Total 6,075.00
8/19/2013 S MWRA Sewer I & I -interest free 56002 59109 Principal -
8/19/2013 S MWRA Sewer I & I -interest free 56002 59109 Interest -
59109 Total -
7/8/2010 S WPT Sewer CWS-07-38 (Self-Supporting) 56002 59126 Principal 180,546.00
59126 Total 180,546.00
3/27/2012 S GOB Sewer (Self-Supporting)(Greenlodge Interceptor) 56002 59131 Principal 100,000.00
59131 Total 100,000.00
3/15/2013 S GOB Departmental Equipment -Sewer (Self-Supporting) 56002 59132 Principal 15,000.00
59132 Total 15,000.00
11/13/2013 S Sewer Refunding I & I 56002 59133 Principal 21,600.00
11/13/2013 S Sewer Refunding I & I 56002 59133 Principal 2,450.00
11/13/2013 S Sewer Refunding I & I 56002 59133 Principal 32,550.00
11/13/2013 S Sewer Refunding I & I 56002 59133 Principal 38,400.00
11/13/2013 S Sewer Refunding System Extension 56002 59133 Principal 81,200.00
11/13/2013 S Estey Way Sewer (Refunding) 56002 59133 Principal 10,500.00
11/13/2013 S Wardwell Sewer (Refunding) 56002 59133 Principal 9,600.00
11/13/2013 S Sewer I & I (Self-Supporting) - (Refunding)(Trayer Rd. Pumping) 56002 59133 Principal 27,700.00
59133 Total 224,000.00
3/15/2014 S Sewer I & I 56002 59135 Principal 30,000.00
3/15/2014 S Sewer (Refunding)(Greenlodge Interceptor) 56002 59135 Principal 13,200.00
59135 Total 43,200.00
3/17/2016 S Sewer (Water Resources Management Plan) 56002 59144 Principal 31,000.00
3/17/2016 S Sewer (Estey Way) 56002 59144 Principal 25,000.00
3/17/2016 S GOB Sewer (Greenlodge Interceptor) 56002 59144 Principal 5,000.00
59144 Total 61,000.00
3/17/2016 S Sewer (Water Resources Management Plan) 56002 59145 Interest 4,180.00
3/17/2016 S Sewer(Estey Way) 56002 59145 Interest 3,480.00
3/17/2016 S GOB Sewer (Greenlodge Interceptor) 56002 59145 Interest 680.00
59145 Total 8,340.00
4/5/2017 S GOB Departmental Equipment -Sewer (Self-Supporting) 56002 59148 Principal
59148 Total -
5/1/2011 S GOB Sewer REFUNDING (Self-Supporting)(Algonquin Sewers) 56002 59150 Interest 3,840.00
59150 Total 3,840.00
7/8/2010 S WPT Sewer CWS-07-38 (Self-Supporting)(includes admin fees) 56002 59160 Interest 50,180.61
59160 Total 50,180.61
3/27/2012 S GOB Sewer (Self-Supporting)(Greenlodge Interceptor) 56002 59181 Interest 39,000.00
59181 Total 39,000.00
3/15/2013 S GOB Departmental Equipment -Sewer (Self-Supporting) 56002 59182 Interest 1,800.00
59182 Total 1,800.00
11/13/2013 S Sewer Refunding I & I 56002 59183 Interest 432.00
11/13/2013 S Sewer Refunding I & I 56002 59183 Interest 49.00
11/13/2013 S Sewer Refunding I & I 56002 59183 Interest 651.00
11/13/2013 S Sewer Refunding I & I 56002 59183 Interest 768.00
11/13/2013 S Sewer Refunding System Extension 56002 59183 Interest 1,624.00
11/13/2013 S Estey Way Sewer (Refunding) 56002 59183 Interest 2,056.00
11/13/2013 S Wardwell Sewer (Refunding) 56002 59183 Interest 1,862.00
11/13/2013 S Sewer I & I (Self-Supporting) - (Refunding)(Trayer Rd. Pumping) 56002 59183 Interest 5,417.00
59183 Total 12,859.00
3/15/2014 S Sewer I & I 56002 59185 Interest 6,750.00
3/15/2014 S Sewer (Refunding)(Greenlodge Interceptor) 56002 59185 Interest 2,975.00
59185 Total 9,725.00
4/5/2017 S GOB Departmental Equipment -Sewer (Self-Supporting) 56002 59188 Interest
59188 Total -
AUTHDEBT.xlsx fy 19 thru fy 37 11/28/2018Source page 164
TOWN OF CANTON COMMENT/REASON FOR
FY 16 FY 17 FY 18 ORIGINAL
BUDGET REPORT FOR FY 2020 ACTUAL ACTUAL ACTUAL EaPEnSE THRU BUDGET DEPARTMENTAL DEPT INCREASE /DECREASE
9/30/2018 BASE BUDGET REQUEST
DEPARTMENTAL WORKSHEETS EXPENSE EXPENSE EXPENSE FY 19
640 WATER ENTERPRISE
56100-51000- PERSONAL SERVICES 0 8,861 13,629 4,322 18,360 19,343
56100-51120- SUPERVISOR SALARY 112,798 106,952 104,138 22,366 129,375 212,796
56100-51123- LABORERS SALARY 482,258 453,551 449,325 93,732 551,156 478,170
56100-51135- JUNIOR ENGINEER SALARY 23,530 21,771 ]3,529 5,426 25,371 27,929
56100-5114?- ACCOUNTING CLERK 24,772 24,772 25,614 6,553 25,608 26,200
56100-51143- OFFICEADMINISTRATORSAL. 41,157 25,109 28,704 5,780 32,394 34,616
56100-51162- POLICE DETAIL SALARIES 17,852 11,634 19,189 13,049 6,500 6,500
56100-51210- SUMMER HELP SALARY 9,069 6,418 4,901 2,319 6,000 6,000
56100-51300- OVERTIME SALARY 119,446 114,350 210,557 36,588 111,000 111,000
56100-51400- LONGEVITY 9,000 9,000 7,750 1,500 9,550 8,050
56100-51530- GOOD ATTEN - AFSCME 5,360 80 2 2,517 2,000 2,000
56100-51916- SALARY CONTINGENCIES 0 0 0 0 2,329 2,329
56100-519?0- STIPENDS 14,274 8,649 7,558 2,750 5,500 5,500
56100-51950- CONTRACT PROVISION 0 0 0 0 875 15,787
SUBTOTAL SALARIES $859,516 $791,148 ~884,89~ $196,902 $926,018 $956,220
~ G~000 CC R.. ~~02'~
56100-52000- PURCHASE OF SERVICES 80,986 125,959 166,485 39,423 46,000 46,000 ~~~ 0°D ~-~oo~ ~'~--~o'~-~S
56100-52000-WELLS PURCHASE OF SERVICES 0 33,677 21,905 0 0 0
56100-52102- HEATING FUEL -OIL 11,940 11,834 15,817 1,436 6,000 6,000 ~L
~ ~o~000 n~ee.d
56100-52104- LIGHTS &POWER 270,341 232,964 215,785 65,927 231,500 231,500
56100-52105- BLDG.MAINT. &SUPPLIES 2,604 5,527 1,162 139 5,000 5,000
56100-52301- WATER/SEWER PURCH MILTON/STOUG 46,149 6,112 485 155 30,000 30,000
56100-52410- REPAIR/MAINT MOTOR VEHIC 2,412 0 835 0 3,000 3,000
56100-52419- REPAIR/MAINT PUMPING STA 0 9 925 0 0 0
56100-52420- BUILDING MAINTR,SUPPLIES 1,578 3,460 9,984 2,700 1,500 1,500
56100-52422- REPAIR/MAINT -WELLS 27,062 33,852 45,206 3,115 32,000 32,000
56100-52425- REPAIRlMAINTEQUIPMENT 79,517 114,361 174,505 33,853 25,000 25,000 ~OS.oc~p ,go~000 47rP /~a,,,,~t
56100-52703- RENT'AL OF EQUIPMENT 1,200 0 0 0 1,000 1,000
56100-52704- iJNIFORM RENTAL 3,098 3,356 3,034 994 4,000 4,000
56100-53108- PRINTING &BINDING 0 0 470 0 1,500 1,500 ►Jate.,~.
56100-531oT- PROF.SERV.WATERTESTING 32,136 22,529 46,501 7,776 20,000 20,000 S
~ ~Sooa add TGSt~nq
56100-5310U- PROF.SERV. MEDICAL EXAMS 0 0 524 99 100 100
56100-53110- PHYSICAL FIT-AFSCME 0 0 0 0 250 25Q
56100-53400- TELEPHONE/COMMUNICATIONS 21,945 20,992 12,805 962 22,000 22,000
56100-53406- COMMUNICATIONS -OTHER 1,530 2,176 2,665 618 0 0
Date: 11/28/2018 W:~MunislMCR Library\Budget reports\New Fiscal Year budget worksheet -Dept Req-enterprise by sal-exp.rpt Page: 5Source page 165
TOWN OF CANTON FY 2020 FY 2020
FY 16 FY 17 FY 18 ACTUAL YTD ORIGINAL
BUDGET REPORT FOR FY 2020 DEPARTMENTAL DEPT CNCREAE
,DECREASE
ACTUAL ACTUAL ACTUAL EXPENSE THRU BUDGET
9/30/2018 BASE BUDGET REQUEST
DEPARTMENTAL WORKSHEETS EXPENSE EXPENSE EXPENSE FY 19
56100-53408- POSTAGE 20,603 13,955 7,998 1,012 12,000 12,000
56100-5340D- ADVERTISING 100 443 2,727 680 600 600
56100-53411- WELL MONITORING SYSTEM(SCADA) 0 2,300 1,912 0 7,500 7,500
56100-54011- TOOLS &HARDWARE 31,357 48,889 76,670 4,651 18,000 18,000
56100-54200- OFFICE SUPPLIES 6,945 5,252 6,142 387 4,500 4,500
56100-54801- GASOLINE &OIL 6,453 6,017 9,453 2,222 14,000 14,000
56100-54806- DIESEL FUEL 14,249 17,581 I &,403 3,378 24,000 24,000
56100-54901- MEALS 1,200 1,020 3,780 0 500 500
56100-55303- TRENCH MATERIALS 7,621 9,415 7,290 897 8,000 8,000
56100-55304- CHEMICALS 193,225 132,551 155,153 38,835 270,000 270,000
56100-55305- METERS &PARTS 7,386 18,333 22,584 2,160 40,000 40,000
56100-55306- BITUMINOUS MATERIALS 15,514 15,230 14,127 10,770 15,000 15,000
56100-55308- PIPES &FITTINGS 17,655 33,071 22,543 31,664 17,000 17,000
56100-55309- HYDRANTS &VALUES 41,348 51,372 45,306 1,382 18,000 18,000 ~p
~ ~f~~ uY~ r~~~e--
56100-5580C- DATA PROCESSING SUPPLIES 220 50 4,837 3,500 1,000 1,000
56100-SS80E- WORK SHOES 1,441 ],480 1,024 1,400 1,200 1,200
56100-558oP- FOUL WEATHER GEAR 194 565 283 0 1,500 1,500
56100-56000- TAXES-TOV✓N OF STOUGHTON 3,331 3,331 3,331 0 5,500 5,500
56100-57000- OTHER CHARGES/EXPENDITURE 0 210 0 0 525 525
56100-57105- IN-STATE TRAVEL 3 0 0 0 0 0
56100-5710C- MEETINGS 355 1,093 6,537 8 1,200 1,200
56100-57300- DUES &MEMBERSHIPS 1,734 1,025 2,703 297 750 750 z'~7So ~ ~ op?~ ctda~ br~rvih
56100-57800- CONTINGENCIES 28,677 0 0 0 25,000 25,000
56100-5780?- HEAVY EQUIPMENT LICENSES 1,854 3,637 5,523 517 800 800 `E~B'oD ~ ~f,000 L•c L~.o Gk.ar~o~
56100-57807- WELL #9 OPERATING COSTS 0 0 0 0 10,000 10,000
56100-57819- PIPELINE ASSISTANCE PROGRAM 0 0 0 0 5,335 5,335
56100-57840- US GEOLOGICAL SURVEY EXPENSE 20,875 ]6,700 12,525 4,175 19,000 19,000
56100-58106- REPLACEMENT EQUIPMENT 3,000 0 0 0 0 0
56100-58500- EQiTIPMENT PURCHASE 0 37,979 1,065 0 30,000 30,000
56100-58936- DEPASSESSMENT CHARGES 7,025 7,821 8,743 0 8,000 8,000 ~-
~ S ,~Sov cdd ~~P toZ-('
56100-58937- MWRA CHARGES 1,299,628 1,731,331 2,551,203 562,258 1,887,795 1,887,795
56100-58985- LEAK DETECTION SURVEY 0 0 23,185 0 0 0
56100-59607-A1636 TRANSFER TO CAPITAL PROJECTS 0 400,000 0 0 0 0
56100-59610- TRANSFER TO GENERAL FUND 978,960 5]0,539 514,825 146,211 584,844 536,298
SUBTOTAL EXPENSES $3,293,451 X3,687,996 $4,248,964 $973,599 $3,460,399 $3,411,853 ~~ ~G~~3~3 ~ S~ 5~~
Date: 11/28/2018 W ~Munis\MCR Library\Budget reports\New Fiscal Year budget worksheet -Dept Req-enterprise by sal-exp.rpt Page: 6Source page 166
TOWN OF CANTON FY 2020 FY 2020 COMMENT/REASON FOR
FY 16 FY 17 FY 18 ACTUAL YTD ORIGINAL
BUDGET REPORT FOR FY 2020 ACTUAL ACTUAL ACTUAL EXPENSE THRU BUDGET DEPARTMENTAL DEPT INCREASE/DECREASE
9/30/2018 BASE BUDGET REQUEST
DEPARTMENTAL WORKSHEETS EXPENSE EXPENSE EXPENSE FY 19
SUBTOTAL WATER ENTERPRISE $4,152,967 $4,479,143 $5,133,859 $1,170,501 $4,386,417 $4,368,073 ~~ S~• S- ~ s?,3 '~
Dept Head Signature /Date
Datc: 11/28/2018 W ~Munis\MCR Library\Budget reports\New Fiscal Year budget worksheet -Dept Req-enterprise by sal-exp.rpt pale: ~Source page 167
PAYROLL PROlEC710N5 - FY 2020
New FY20
hourly me
with step FY2o
FY19 Hn PoI fV19 Pay Hourly F19 Pay FY30 NaM FY20 Ne# and/of FYIO Annual Btimated
Employee last Name Fint Name lob pass lob loss Deit loeatlon Oesc Group/BU OIL Object Sbtus Pay Gnde Pay Step Year Rite Mnual Salary Grade Step COLA Al~ry 262days Longevity
1824 QUINLAN KELSEY 4118 GIS COORDINATOR ENGINEERING/WATER PC 56100 51000 Ff GIS 0 624 30.01 18,727 GIS 0 30.76 19,343 0
1 56100 Count
51000 Total 18,727 19,343 0
297 KIELY BRIAN 4503 WATER FOREMAN WATER AF 56100 51120 Ff F-40 20 2080 41.59 86,507 F-40 20 41.59 87,173 1,500
1474 RUANE RENEE 4550 WTR TREATMNT PLNT FOREMAN WATER AF 56100 51120 Ff F-4D 11 2080 36.94 76,835 F-40 13 38.06 79,774 400
1184 SVKES CHRISTOPHER 4501 WATER/SEWER SUPERVISOR WATER AF 56100 51120 Ff E-40 11 1040 43.11 44,834 E-40 12 43.75 45,850 0
3 56100 Count
51120 Total 208,177 212,796 1,900
12 ARMANDO GARY 4506 SKILLED LABORER/TRUCK DRIVER WATER AF 56100 51123 FT J-40 14 2080 28.33 SS,926 1-40 15 28.75 60,260 1,500
1434 BOGUE CONOR 4554 UTILITIES MAINTENANCE TECHNICI WATER AF 56100 51123 Ff I-60 1 2080 25.47 52,978 I-40 2 25.86 54,203 0
1560 MCCANN GINA 4508 METER READER WATER AF 56100 51123 Ff K-40 2 2080 21.54 44,803 K-40 3 21.87 45,840 0
381 MCCARRICK STEVEN 4504 WTR TREATMNT PLANT OPERATOR WATER AF 56100 51123 Ff I-40 22 2080 34.96 72,717 I-40 22 34.96 73,276 1,750
1867 MICHAELS KEVIN 4504 WTR TREATMNT PLANT OPERATOR WATER AF 56100 51123 Ff I-40 1 2080 25.47 SZ,978 I-40 2 25.86 54,203 0
1279 MITCHERONEY MICHAEL 4554 UTILITIES MAINTENANCE TECHNICI WATER AF 56100 51123 FT I~0 1 2080 25.47 52,978 I-40 2 25.86 54,203 400
1653 REDQUEST SC07T 4208 SPECIAL HEAW EQUIP OPERATOR WATER AF4 56100 51123 FT 13 5 2080 28.86 60,029 13 6 30.01 62,910 400
697 SMITH IOSEPH 4554 UTILITIES MAINTENANCE TECHNICI WATER AF 56100 51123 Ff I-40 22 2080 34.96 72,717 I-40 ZZ 34.96 73,276 1,500
8 56100 Count
53123 Total 468,125 478,170 5,550
1848 MUNDEN GAMZE 4116 STAFF ENGINEER ENGINEERING PB 56100 51135 FT H 11 832 31.40 26,125 H 12 3331 27,929 0
1 56100 Count
51135 Total 26,125 27,929 0
1469 JERRIER MICHAEL 4507 WATER&SEWER ACCT COORDINATOR WATER AF 56100 51142 Ff K-40 10 1040 24.27 25,241 K-40 12 25.00 26,200 600
1 56100 Count
51142 Total 25,241 26,200 600
1359 CAWLEY PATRICIA 4502 WATER/SEWER OFFICE ADMINSTRATO WATER AF4 56100 51143 FT 16B 3 1040 31.76 33,030 168 4 33.03 34;616 0
~ 1 561U0 Count i
51143 Total 33,030 34,616 0
15 56100 Count
56100 Total 779,425 799,054 ~ 8,050
Payroll Projections FY20..xlsx Munis download for FY20
11/28/2018 12:10 PM 34 of 35Source page 168
~~ ~zs oaf
~~ %cam - 5~ l~i~ ~---- ~~ ~--~~~.- ~~~
TOWN OF CANTON FY 2020 FY 2020 COMMENT/REASON FOR
FY ]6 FY 17 FY 18 ORIGINAL
BUDGET REPORT FOR FY 2020 E7CPENE THRU DEPARTMENTAL DEPT INCREASE/DECREASE
ACTUAL ACTUAL ACTUAL BUDGET
EXPENSE 9/30/2018 FY 19 BASE BUDGET REQUEST
DEPARTMENTAL WORKSHEETS EXPENSE E7CPENSE
56102-59101- PRINC PD-OS/11 DEBT 268,000 255,000 255,000 0 255,000 255,000 ZSS~ ~~
56102-59106- PRIM PD-3/15 DEBT 71,250 70,000 69,000 0 69,000 69,000 ~ ~~
56102-59107- INT PD-03/15 DEBT 18,538 16,400 14,300 6,115 12,230 12,230 --~~~~
56102-59]09- PRINCIPAL PAID TO MWRA 200,000 200,000 200,000 109,000 200,000 200,000 ~
56102-59128- PRINC PD-01/08 DEBT ]26,000 0 0 0 0 0 -'
56102-59131- PRINC PD-3/12 DEBT 190,000 190,000 190,000 0 190,000 190,000 ~ ~0 ,O0 D
5610?-59132- PRINC PD-03/13 DEBT 178,000 179,000 178,000 0 177,000 177,000 ~ ~~' ~
56102-59133- PRINC PD-11/13 DEBT 81,800 80,700 79,400 0 77,400 77,400 '~~
5610?-59135- PRIN PD-03/14 DEBT 202,700 202,700 202,400 0 202,300 202,300 ~ g 7f~1
5610?-59137- PRINC PD - OS/10 DEBT 248,000 247,000 247,000 0 247,000 247,000 ~~
56102-59138- PRINC PD - 05/09 DEBT 95,000 95,000 0 0 0 0
56102-59142- PRINC PD-03/08 DEBT 48,000 47,000 0 0 0 0
56102-59144- PRIN PD-03/16 DEBT 0 105,000 59,000 0 57,000 57,000 ~
56102-59145- INT PD-03/16 DEBT 0 9,685 9,600 4,210 8,420 8,420 Z~
56102-59146- PRIN PD-03/17 DEBT 0 0 135,000 0 135,000 135,000 ~ ~s O0~
56102-59148- PRIM PD-04/17 DEBT 0 0 90,000 0 97,000 97,000~~
5610?-59150- INTEREST PD OS/11 148,609 140,569 132,919 0 122,719 122,719 ~
56102-59176- INT PD-01/08 DEBT 32,013 0 0 0 0 0
56102-59178- INT PD - 05/09 DEBT 48,840 45,990 0 0 0 0
56102-59179- INT PD - OS/10 DEBT 115,189 107,749 100,339 0 92,929 92,929
56102-59181- INT PD - 3/12 DEBT 96,900 91,200 87,40Q 0 81,700 81,700 ~
56102-59182- INT PD - 03/13 DEBT 88,579 83,239 77,869 36,264 72,529 72,529
5610?-59183- INT PD-11/13 DEBT 20,344 18,291 15,590 5,704 12,947 12,947
56102-59185- INT PD-03/14 DEBT 98,993 88,858 78,723 34,301 68,603 68,603 ~~
56102-59187- INT PD-03/17 DEBT 0 0 98,406 0 74,850 74,850 ~
5610?-59188- INT PD-04/17 DEBT 0 0 32,275 0 27,505 27,505 Z g ~
56]02-59192- INT PD-03/08 DEBT 3,800 1,880 0 0 0 0
56102-59250- INTEREST TEMPORARY LOANS 0 26,000 0 0 0 0 6 ~O
SUBTOTAL EXPENSES $2,380,554 $2,301,260 $2,352,219 $195,594 $2,281,132 $2,281,132
SUBTOTAL WATER PRINC/INT PAYMENTS $2,380,554 $2,301,260 X2,352,219 $195,594 $2,281,132 $2,281,132 ~j ~J ~ !~ V ~
GG~ ~/ ~9 /
N ept Head Sl~gnature /Date
Date: 11/28/2018 w ~Munis\MCR Library\Budget reports\New Fiscal Year budget worksheet -Dept Req-enterprise by sal-exp.rpt pate: gSource page 169
DEBT SERVICE PAYMENTS FROM FY 19 THRU FY 37
Date of Debt Service Type of
Issue Type Description Org Object Payment 2020
5/1/2011 W GOB Water Treatment Facility (Self-Supporting) 56102 59101 Principal 250,000.00
5/1/2011 W GOB Water Mains (Self-Supporting) 56102 59101 Principal 5,000.00
59101 Total 255,000.00
3/15/2015 W Water Meters 56102 59106 Principal 55,000.00
3/15/2015 W Water Meters 56102 59106 Principal 13,000.00
59106 Total 68,000.00
3/15/2015 W Water Meters 56102 59107 Interest 7,950.00
3/15/2015 W Water Meters 56102 59107 Interest 2,210.00
59107 Total 10,160.00
11/15/2010 W WRA Water (Self-Supporting) 56102 59109 Principal 41,000.00
11/15/2010 W WRA Water (Self-Supporting) 56102 59109 Interest -
5/7/2012 W WRA Water (Self-Supporting) 56102 59109 Principal 50,000.00
5/7/2012 W WRA Water (Self-Supporting) 56102 59109 Interest -
8/19/2013 W MWRA Tolman WaterTank-interestfree 56102 59109 Principal 109,000.00
8/19/2013 W MWRA Tolman Water Tank -interest free 56102 59109 Interest -
59109 Total 200,000.00
3/27/2012 W GOB Water Treatment Facility (Self-Supporting) 56102 59131 Principal 190,000.00
59131 Total 190,000.00
3/15/2013 W G08 Water Mains (Self-Supporting) 56102 59132 Principal 11,000.00
3/15/2013 W GOB Water Mains (Self-Supporting)(Elm Street) 56102 59132 Principal 24,000.00
3/15/2013 W GOB Water Mains (Self-Supporting)(EIm Street) 56102 59132 Principal 124,000.00
3/15/2013 W GOB Well q10(Self-Supporting) 56102 59132 Principal 18,000:00
59132 Total 177,000.00
11/13/2013 W Water(Refunding) 56102 59133 Principal 3,400.00
11/13/2013 W Pumping Station (Refunding) 56102 59133 Principal 14,400.00
11/13/2013 W WeIlRehab(Refunding) 56102 59133 Principal 7,100.00
11/13/2013 W Water Mains (Self-Supporting) -(Refunding) 56102 59133 Principal 16,300.00
11/13/2013 W Water Mains (Self-Supporting) -(Refunding) 56102 59133 Principal 33,600.00
59133 Total 74,800.00
3/15/2014 W Water Mains (Self-Supporting) 56102 59135 Principal 90,000.00
3/15/2014 W Well (Self -Supporting) 56102 59135 Principal 45,000.00
3/15/2014 W Well (Self -Supporting)(Refunding) 56102 59135 Principal 26,800.00
3/15/2014 W Well(Self-Supporting)(Refunding) 56102 59135 Principal 17,800.00
3/15/2014 W Well(Self-Supporting)(Refunding) 56102 59135 Principal 17,800.00
59135 Total 197,400.00
3/17/2016 W GOB Water Mains (Self-Supporting)(Refunding) 56102 59144 Principal 54,000.00
59144 Total 54,000.00
3/17/2016 W GOB Water Mains (Self-Supporting)(Refunding) 56102 59145 Interest 7,280.00
59145 Total 7,280.00
3/16/2017 W Water Mains (Mechanic Street) 56102 59146 Principal 135,000.00
59146 Total 135,000.00
4/5/2017 W GOB Water Mains (Self-Supporting) 56102 59148 Principal 78,000.00
4/5/2017 W G08 Water Mains (Self-Supporting) 56102 59148 Principal 20,000.00
59148 Total 98,000.00
5/1/2011 W GOB Water Treatment Facility (Self-Supporting) 56102 59150 Interest 110,312.50
5/1/2011 W GOB Water Mains (Self-Supporting) 56102 59150 Interest 2,206.25
59150 Total 112,518.75
3)27/2012 W GOB Water Treatment Facility (Self-Supporting) 56102 59181 Interest 74,100.00
59181 Total 74,100.00
3/15/2013 W GOB Water Mains (Self-Supporting) 56102 59182 Interest 1,540.00
3/15/2013 W GOB Water Mains (Self-Supporting)(Elm Street) 56102 59182 Interest 10,361.25
3/15/2013 W GOB Water Mains (Self-Supporting)(Elm Street) 56102 59182 Interest 52,797.50
3/15/2013 W GOB Well #10(Self-Supporting) 56102 59182 Interest 2,520.00
59182 Total 67,218.75
11/13/2013 W Water (Refunding) 56102 59183 Interest 68.00
11/13/2013 W Pumping Station (Refunding) 56102 59783 Interest 288.00
11/13/2013 W WeIlRehab(Refunding) 56102 59183 Interest 142.00
11/13/2013 W Water Mains (Self-Supporting) -(Refunding) 56102 59183 Interest 3,179.00
11/13/2013 W Water Mains (Self-Supporting) - (Refunding) 56102 59183 Interest 6,722.00
59183 Total 10,399.00
3/15/2014 W Water Mains (Self-Supporting) 56102 59185 Interest 34,625.00
3/15/2014 W Well(Self-Supporting) 56102 59185 Interest 10,125.00
3/15/2014 W Well(Self-Supporting)(Refunding) 56102 59185 Interest 5,682.50
3/15/2014 W Well(Self-Supporting)(Refunding) 56102 59185 Interest 4,027.50
3/15/2014 W Well(Self-Supporting)(Refunding) 56102 59185 Interest 4,027.50
59185 Total 58,487.50
3/16/2017 W Water Mains(Mechanic Street) 56102 59187 Interest 70,800.00
59187 Total 70,800.00
4/5/2017 W GOB Water Mains (Self-Supporting) 56102 59188 Interest 20,150.00
4/5/2017 W GOB Water Mains (Self-Supporting) 56102 59188 Interest 5,415.00
59188 Total 25,565.00
3/15/2018 W GOB Departmental Equipment- Public Works (Self-Supporting) 56102 59189 Principal 25,412.00
3/15/2018 W GOB Water (Self-Supporting)(System Improvements) 56102 59189 Principal 14,000.00
3/15/2018 W GOB Water Treatment Facility (Self-Supporting) 56102 59189 Principal 100,588.00
3)15/2018 W GOB Water Mains (Self-Supporting) 56102 59189 Principal 49,000.00
3/15/2018 W GOB Water Mains (Self-Supporting) 56102 59189 Principal 36,000.00
59189 Total 225,000.00
3/15/2018 W GOB Departmental Equipment- Public Works (Self-Supporting) 56102 59194 Interest 1,270.60
3/15/2018 W GOB Water (Self-Supporting)(System Improvements) 56102 59194 Interest 6,410.00
3/15/2018 W GOB Water Treatment Facility (Self-Supporting) 56102 59194 Interest 46,419.40
3/15/2018 W GOB Water Mains (Self-Supporting) 56102 59194 Interest 23,210.00
3/15/2018 W GOB Water Mains (Self-Supporting) 56102 59194 Interest 16,930.00
59194 Total 94,240.00
AUTHDEBT.xlsx fy 19 thru fy 37 i vzaizoi aSource page 170
DEBT SERVICE PROJECTIONS -DEBT IN PIPELINE
AUTHORIZED Project AUTHORIZED TERM BOND BAN BOND PRINC FY
DATE ART # Code PURPOSE UNISSUED (YRS) DATE RATE RATE PD YTD INT PRIN 2020
4/29/1998 23 SEPTIC TITLE V 200,000 N/A N/A N/A N/A 0 0 0 0
5/8/2017 12-5 FIRE ENGINE E-1 (BALANCE) 61,000 N/A N/A N/A N/A 0 0 0 0
5/8/2017 12-5 SELF CONTAINED BREATHING APPARATUS 26,000 N/A N/A N/A N/A 0 0 0 0
5/8/2017 12-5 DPW STREET SWEEPER 18,000 N/A N/A N/A N/A 0 0 0 0
5/8/2017 30 HANSEN SCHOOL ROOF(MSBA SHARE) 996,000 N/A N/A N/A N/A 0 0 0 0
5/8/2017 12-10 A1724 RESERVOIR POND DAM REPAIRS 950,000 20 Apr-19 2.50% 4.00% 0 38 48 86
5/14/2018 12-5 A1724 RESERVOIR POND DAM REPAIRS(SUPPLEMENT) 300,000 20 Apr-19 2.50% 4.00% 0 12 15 27
5/14/2018 12-6 A1827 OLD SHEPARD ST DAM REPAIRS 700,000 20 Apr-19 2.50% 4.00% 0 28 35 63
5/14/2018 12-6 A1828 COA BUSES 121,000 5 Apr-19 2.50% 4.00% 0 5 24 29
5/14/2018 12-7 81910 JFK MODULAR CLASSROOMS 2,000,000 10 Apr-20 2.50% 4.00% 0 50 0 50
5/14/2018 12-8 A1911 WIFI BACKBONE 150,000 5 Apr-19 2.50% 4.00% 0 6 30 36
5/14/2018 12-8 81912 HIGH SCHOOL ROOF TOP UNIT 123,000 10 Apr-19 2.50% 4.00% 0 5 12 17
5/14/2018 26 COLT COLTS CROSSING STREET WORK 70,000 10 Apr-19 2.50% 4.00% 0 3 7 10
5/14/2018 27-30 KNOB KNOB HILL ESTATES STREET WORK 80,000 10 Apr-19 2.50% 4.00% 0 3 8 11
5/14/2018 35-36 WASH WASHINGTON COMMONS STREET WORK 60,000 10 Apr-19 2.50% 4.00% 0 2 6 8
TOTAL INSIDE LEVY 5,855,000 0 152 185 337
TOTAL AMBULANCE 0 0 0 01
TOTAL OUTSIDE LEVY 0 0 0 0 0
5/11/2015 6 LAND PURCHASE 1,740,000 10 Apr-19 2.50% 4.00% 0 70 174 244
5/14/2018 19-3 LAND PURCHASE (SUPPLEMENT) 325,500 10 Apr-19 2.50% 4.00% 0 13 33 46
TOTAL COMMUNITY PRESERVATION 2,065,500 0 83 207 289
5/11/2015 4 DISTRICT IMPROVEMENTS (Plymouth Rubber site) 8,597,000 20 Apr-21 2.50% 4.00% 0 0 0 0
5/9/2016 42 DISTRICT IMPROVEMENTS (Eversource Property) 250,000 10 Apr-20 2.50% 4.00% 0 0 0 0
TOTAL DISTRICT IMPROVEMENT FUND #370 8,847,000 0 0 0 0
5/14/2018 12-10 A1914 WATER LINE AT SULLIVAN TREATMENT FACILITY 2,440,000 20 Apr-20 2.50% 4.00% 0 61 0 61
TOTAL WATER 2,440,000 0 61 0 61
5/1/2000 15-12 SEWER I & I (balance) 719,790 20 N/A N/A N/A 0 0 0 0
4/30/2008 13-9 A1356 SCADA UPGRADE (balance) 145,000 10 N/A N/A N/A 0 0 0 0
TOTAL SEWER 864,790 0 0 0 0
GRAND TOTALS-AUTHORIZED/UNISSUED DEBT 2 0 296 392 687
AUTHDEBT.xlsx PIPELINE 11/28/2018Source page 171
TOWN OF CANTON FY 16 FY 17 FY 18 ORIGI!~AL FY 2020 F1'2020 COMMENT/REASON FOR
^~Tvv, acTuu, ACTUAL BUDGET ACTUALYTD BASE DEPT. INCREASE/DECREASE
BUDGET REPORT FOR FY 2020 EXPENSE EXPENSE EXPENSE EXPENSESTHRU BUDGET REQUEST
FY 19
DEPARTMENTAL WORKSHEETS 9/30/18
172 COMMUNITY PRESERVATION ACT
32460 - 51000 PERSONAL SERVICES 7,473 9,350 14,676 30,000 0 30,000
32460 - 52000 PURCHASE OF SERVICES 4,056 0 100 0 0 0
32460 - 53400 TELEPHONE/COMMUNICATIONS 73 74 65 0 13 0
32460 - 53408 POSTAGE 0 0 0 0 0 0
32460 - 54000 SUPPLIES 0 147 0 0 0 0
32460 - 57000 OTHER CHARGES/EXPENDITURE 2,790 1,750 0 0 0 0
SUBTOTAL SEGMENT FILLER ~ 14,393 $11,321 ~14,8~1 S30,000 $18 S3U,000
TOTAL 172 COMMUNITYPRESERVATIONA S 14,393 $11,321 $14,841 $30,000 X18
Datc: 1(/29/2018 Page: 1
./