Canton, Massachusetts · Saved source text
FY15 Fixed Costs Requests
Saved text from 31 source pages. Transcription and OCR may contain errors; verify figures and wording against the original. Retrieved 2026-10-15.
Source page 1
FIXED COSTS
BUDGET REQUESTS – FY15
The following FY15 Budget Worksheets
(Department Requests) were provided to the
Finance Committee at its meeting on January
14, 2014.
These Budget Worksheets are a work in
progress and are in the process of being
reviewed and approved by the Board of
Selectmen and the Finance Committee.
These Budget Worksheets are subject to
change. Thank you.Source page 2
FIXED COSTS AND STATE AND COUNTY CHARGES
*
FY 2009 FY 2010 FY 2011 FY 2012 FY 2013 FY 2014 FY 2014 FY 2015
DEPT DESCRIPTION ACTUAL ACTUAL ACTUAL ACTUAL ACTUAL BUDGET ESTIMATE ESTIMATE
132 RESERVE FUND 0 0 0 0 0 500,000 500,000 500,000
422 STREET LIGHTS 169,999 157,535 126,667 125,028 115,634 150,000 150,000 140,000
423 SNOW & ICE 834,646 597,771 747,773 226,849 644,641 364,735 364,735 414,500
433 TRASH COLLECTION 1,257,475 1,371,275 1,379,872 1,371,307 1,453,522 1,448,992 1,448,992 1,552,000
INSIDE LEVY 2,294,451 2,619,296 2,708,102 2,804,501 3,052,193 2,928,319 2,950,666 2,647,024
OUTSIDE LEVY 3,707,534 3,395,196 3,314,926 3,183,417 3,103,803 3,019,145 3,020,776 2,916,271
TOTAL DEBT SERVICE 6,001,985 6,014,493 6,023,028 5,987,919 6,155,995 5,947,464 5,971,442 5,563,295
840 BLUE HILLS REGIONAL 1,253,270 1,321,631 1,460,438 1,337,865 1,173,074 1,059,042 1,059,042 1,059,042
841 NORFOLK COUNTY AGGIE 0 0 0 0 6,000 10,000 10,000 10,000
911 RETIREMENT EXPENSES 2,679,489 2,870,146 2,976,695 2,942,040 3,085,292 3,212,846 3,201,692 3,604,434
913 UNEMPLOYMENT 100,000 100,000 100,000 100,000 100,000 150,000 150,000 150,000
914 HEALTH INSURANCE 8,038,329 8,952,221 9,814,770 10,146,298 10,018,636 10,498,160 10,540,352 11,261,785
915 LIFE INSURANCE 55,999 55,575 58,666 57,233 57,696 60,000 60,000 60,000
TOTAL HEALTH & LIFE INSURANCE 8,094,328 9,007,796 9,873,436 10,203,531 10,076,332 10,558,160 10,600,352 11,321,785
946 TOWN INSURANCE 740,606 675,428 736,579 760,491 846,675 877,950 877,950 935,341
993 OPEB TRUST FUND 0 0 0 0 50,000 400,000 400,000 400,000
990 OTHER TRANSFERS 0 0 0 0 150,078 0 0 0
TOTAL FIXED COSTS 21,131,798 22,116,075 23,424,488 23,055,030 23,857,242 24,679,189 24,734,205 25,650,397
820 STATE ASSESSMENTS 745,934 753,332 665,115 683,717 763,657 752,873 751,246 770,027
830 NORFOLK COUNTY TAX 178,616 179,546 184,034 191,104 195,881 194,406 194,406 199,266
TOTAL STATE & COUNTY 924,550 932,878 849,149 874,821 959,538 947,279 945,652 969,293
ATMDATA.xlsx fixedcosts 1/17/2014Source page 3
FY 2015 FY 2015
TOWN OF CANTON FY 11 FY 12 FY 13 ORIGINAL
BASE DEPT.
COMMENT/REASON FOR
ACTUAL ACTUAL ACTUAL BUDGET ACTUAL YTD INCREASE / DECREASE
BUDGET REPORT FOR FY 2015 EXPENSE EXPENSE EXPENSE FY 14 EXPENSES THRU BUDGET REQUEST
DEPARTMENTAL WORKSHEETS 10/31/13
710 PRINCIPAL PAYMENTS
17102- 59101 PRINCIPAL PD-05/11 DEBT 0 321,500 307,500 256,000 0 256,000 267000
17102- 59102 PRINC PD 05/11 DEBT EXCLUSION 0 521,500 513,500 502,000 0 502,000
17102- 59121 PRINC PD-12/01 DEBT 95,000 0 0 0 0 0 /
17102- 59122 PRINC PD-12/01 DEBT EXCLUSIOr 490,000 0 0 0 0 0
17102- 59123 PRINC PD-03/04 DEBT 529,200 528,675 515,950 505,685 0 505,685 41-3 0 0 0 0 /
17102 - 59124 PRINC PD-03/04 DEBT EXCLUSIOP 1,679,680 1,674,545 1,669,320 1,666,560 0 1,666,560
,
i_ZOZ10.00 V
17102- 59127 PRINC PD-01/06 DEBT 531,000 528,000 524,000 524,000 0 524,000 0 /
17102- 59128 PRINC PD-01108 DEBT 179,000 174,000 169,000 169,000 0 169,000 /,'%) 6100n 7 /
17102 - 59130 PRINCIPAL PAYDOWNS 154,912 68,800 136,014 182,000 0 182,000 /e-000 t/(p/i0 L i
17102 - 59131 PRINC PD-3/12 DEBT 0 0 192,908 180,000 0 180,000 pT000 C)
17102 - 59137 PRINC PD - 05/10 DEBT 105,261 102,000 97,000 97,000 0 97,000 192_000 , V P' e'
17102- 59138 PRINC PD - 05/09 DEBT 262,000 255,000 253,000 251,000 0 251,000 2:/ / noi) r V ''-
17102- 59142 PRINC PD-03/08 DEBT 107,000 107,000 50,000 50,000 0 50,000 <Se-OM V
17102 - 59143 PRINC PD-03108 DEBT EXCLUSION 51,000 51,000 50,000 50,000 0 50,000 ‹^C) 60 1/
SUBTOTAL EXPENSES $ 4,184.053 $4,332,020 $4,478,192 $4,433,245 $O $4,433,245
TOTAL 710 PRINCIPAL PAYMENTS $ 4,184,053 54,332,020 $4,478,192 $4,433,245 $0 $4,433,245
=EWA
Department HeI signature / Date
ui 676
(Th - c-'112)D - 3 s-7 00o
1.4.-70.6
Date: 11/14/2013 Page: 100Source page 4
LONG TERM DEBT SERVICE AMOUNTS FY 15
Date of Debt Service Type of
Issue Type Description Org Object Payment 2015
5/1/2011 GOB Building Construction - Public Works 17102 59101 Principal 14,000.00
5/1/2011 GOB Building Remodeling - Police 17102 59101 Principal 26,000.00
5/1/2011 GOB Building Remodeling School 17102 59101 Principal 6,000.00
5/1/2011 GOB Building Remodeling - School 17102 59101 Principal 4,000,00
5/1/2011 GOB Building Remodeling - School 17102 59101 Principal 2,000.00
5/1/2011 GOB Energy Conservation - School 17102 59101 Principal 6,000,00
5/1/2011 GOB Departmental Equipment 17102 59101 Principal 0.00
5/1/2011 GOB Departmental Equipment 17102 59101 Principal 9,000.00
5/1/2011 GOB Departmental Equipment - Fire 17102 59101 Principal 19,000.00
5/1/2011 GOB Departmental Equipment - Public Works 17102 59101 Principal 9,000.00
5/1/2011 GOB Departmental Equipment - Public Works 17102 59101 Principal 17,000.00
5/1/2011 GOB Departmental Equipment - Public Works 17102 59101 Principal 17,000.00
5/1/2011 GOB Asbestos Removal 17102 59101 Principal 10,000.00
5/1/2011 GOB Building Remodeling REFUNDING 17102 59101 Principal 38,000.00
5/1/2011 GOB Building Remodeling - School REFUNDING 17102 59101 Principal 17,000.00
5/1/2011 GOB Building Remodeling - School REFUNDING 17102 59101 Principal 7,000.00
5/1/2011 GOB Building Remodeling - School 17102 59101 Principal 3,000.00
5/1/2011 GOB Building Remodeling - School REFUNDING 17102 59101 Principal 3,000.00
59101 Total 207,000,00
5/1/2011 E GOB School Project REFUNDING (Exempt) 17102 59102 Principal 493,000,00
59102 Total 493,000.00
3/15/2004 GOB Surface Drain 17102 59123 Principal 10,000,00
3/15/2004 GOB Land Acquisition 17102 59123 Principal 15,000.00
3/15/2004 GOB Building Remodeling ADA 17102 59123 Principal 45,000.00
3/15/2004 -GOB Building Remodeling - Police 17102 59123 Principal 290,000,00
3/15/2004 GOB Building Remodeling - School 17102 59123 Principal 10,000.00
3/15/2004 'GOB Building Remodeling - School 17102 59123 Principal 15,000,00
3/15/2004 GOB Building Remodeling - School 17102 59123 Principal 10,000.00
3/15/2004 GOB Building Remodeling - Town Hall 17102 59123 Principal 10,000.00
3/15/2004 GOB Energy Conservation - School 17102 59123 Principal 25,000.00
3/15/2004 GOB Departmental Equipment - Fire 17102 59123 Principal 0.00
3/15/2004 GOB Building Construction REFUNDING 17102 59123 Principal
3/15/2004 GOB Building Remodeling REFUNDING 17102 59123 Principal
3/15/2004 GOB Building Remodeling - School REFUNDING 17102 59123 Principal
3/15/2004 GOB Building Remodeling - School REFUNDING 17102 59123 Principal
59123 Total 430,000.00
3/15/2004 E GOB Building Construction - School (Exempt) 17102 59124 Principal 1,000,000.00
3/15/2004, E GOB Building Addition - Library (Exempt) 17102 59124 Principal 300,000.00
3/15/2004 E GOB Land Acquisition - Conservation REFUNDING (Exempt) 17102 59124 Principal
3/15/2004 E GOB Land Acquisition REFUNDING (Exempt) 17102 59124 Principal
3/15/2004 E GOB Building Remodeling - School REFUNDING (Exempt) 17102 59124 Principal
3/15/2004 E GOB Building Remodeling - School REFUNDING (Exempt) 17102 59124 Principal
59124 Total 1,300,000.00
1/15/2006 I GOB Surface Drain 17102 59127 Principal
1/15/2006 GOB Building Construction - Fire 17102 59127 Principal
1/15/2006 I GOB Building Remodeling - Fire 17102 59127 Principal
1/15/2006 I GOB Building Remodeling 17102 59127 Principal
1/15/2006 GOB Building Remodeling - School 17102 59127 Principal
1/15/2006 I GOB Building Remodeling - School 17102 59127 Principal
1/15/2006 I GOB Building Remodeling - School 17102 59127 Principal
1/15/2006 I GOB Building Remodeling - School 17102 59127 Principal
1/15/2006 GOB Building Remodeling - School 17102 59127 Principal
1/15/2006 GOB Building Remodeling - School 17102 59127 Principal
1/15/2006 GOB Departmental Equipment - Fire 17102 59127 Principal
AUTHDEBT.xlsx 1 11/22/2013Source page 5
LONG TERM DEBT SERVICE AMOUNTS FY 15
Date of Debt Service Type of
Issue Type Description Org Object Payment 2015
1/15/2006 GOB Departmental Equipment - Fire 17102 59127 Principal
1/15/2006 GOB Departmental Equipment - Fire 17102 59127 Principal
1/15/2006 GOB Departmental Equipment - Highway 17102 59127 Principal
1/15/2006 GOB Traffic Signal Installation 17102 59127 Principal
59127 Total 0.00
1/15/2008 I aGOB Surface Drain 17102 59128 Principal 8,000.00
1/15/2008 I GOB Building Remodeling - School 17102 59128 Principal 7,000.00
1/15/2008 I GOB Building Remodeling - School 17102 59128 Principal 6,000.00
1/15/2008 I GOB Building Remodeling - School 17102 59128 Principal 12,000.00
1/15/2008 I _GOB Building Remodeling - School 17102 59128 Principal 7,000.00
1/15/2008 I ,GOB Departmental Equipment 17102 59128 Principal 10,000.00
1/15/2008 GOB Departmental Equipment - Public Works 17102 59128 Principal 14,000.00
1/15/2008 GOB Departmental Equipment - Fire 17102 59128 Principal 44,000.00
1/15/2008 GOB Departmental Equipment 17102 59128 Principal 9,000.00
1/15/2008 GOB Departmental Equipment - Police 17102 59128 Principal 8,000.00
1/15/2008 GOB Dam Construction 17102 59128 Principal 6,000.00
1/15/2008 I GOB Dam Construction 17102 59128 Principal 33,000.00
1/15/2008 GOB Outdoor Recreational Facility 17102 59128 Principal 5,000.00
59128 Total 169,000.00
3/27/2012 GOB Surface Drain 17102 59131 Principal 26,000,00
3/27/2012 GOB Building Remodeling - School 17102 59131 Principal 11,000.00
3/27/2012 GOB Building Remodeling - School 17102 59131 Principal 8,000.00
3/27/2012 GOB Building Remodeling - School 17102 59131 Principal 7,000.00
3/27/2012 GOB Building Remodeling 17102 59131 Principal 3,000.00
3/27/2012 GOB Energy Conservation 17102 59131 Principal 58,000,00
3/27/2012 GOB Departmental Equipment - School 17102 59131 Principal 48,000.00
3/27/2012 GOB Departmental Equipment - School 17102 59131 Principal 19,000.00
59131 Total 180,000,00
3/15/2013 , GOB Building Construction - Public Works 17102 59132 Principal 15,000.00
3/15/2013 . GOB Building Remodeling - School 17102 59132 Principal 13,000.00
3/15/2013 GOB Dam Construction 17102 59132 Principal 18,000.00
3/15/2013 GOB Departmental Equipment 17102 59132 Principal 14,000.00
3/15/2013 GOB Architectural Services Building - Senior Citizen 17102 59132 Principal 45,000.00
3/15/2013 GOB Engineering Services 17102 59132 Principal 15,000.00
3/15/2013 GOB School Project 17102 59132 Principal 22,000.00
3/15/2013 GOB School Project 17102 59132 Principal 15,000.00
59132 Total 157,000.00
11/13/2013 Surface Drain (Refunding) 17102 59133 Principal 4,700.00
11/13/2013 Building Construction - Fire (Refunding) 17102 59133 Principal 91,000.00
11/13/2013 Building Construction - Fire (Refunding) 17102 59133 Principal 36,600.00
11/13/2013 Building Remodeling ADA - (Refunding) 17102 59133 Principal 84,800.00
11/13/2013 Building Remodeling - School - (Refunding) 17102 59133 Principal 15,200.00
11/13/2013 Hansen School Plumbing - (Refunding) 17102 59133 Principal 7,600,00
11/13/2013 Kennedy School Boiler - (Refunding) 17102 59133 Principal 15,100,00
11/13/2013 Building Remodeling - School - (Refunding) 17102 59133 Principal 17,900.00
11/13/2013 Building Remodeling - School - (Refunding) 17102 59133 Principal 29,700,00
11/13/2013 Building Remodeling - School - (Refunding) 17102 59133 Principal 44,200.00
11/13/2013 Ladder Truck - Fire (Refunding) 17102 59133 Principal 58,700,00
11/13/2013 Fire Tanker Truck - (Refunding) 17102 59133 Principal 28,400.00
11/13/2013 DPW Highway Truck - (Refunding) 17102 59133 Principal 15,900.00
11/13/2013 Traffic Signal Installation - (Refunding) 17102 59133 Principal 32,300.00
11/13/2013 Recreation Dept Garage (Refunding) 17102 59133 Principal 11,800,00
11/13/2013 Replace Windows (Refunding) 17102 59133 Principal 8,100.00
11/13/2013 I High School Windows (Refunding) 17102 59133 Principal 7,120,00
AUTHDEBT.xisx 2 11/22/2013Source page 6
LONG TERM DEBT SERVICE AMOUNTS FY 15
Date of Debt Service Type of
Issue Type Description Org Object Payment 2015
11/13/2013 I School Plumbing (Refunding) 17102 59133 Principal 7,120.00
59133 Total 516,240,00
11/13/2013 E Land Acquisition - Conservation (Refunding) 17102 59134 Principal 139,200,00
11/13/2013 E Land Acquisition - Town Hall (Refunding) 17102 59134 Principal 37,700.00
11/13/2013 E , School ADA (Refunding) 17102 59134 Principal 62,160.00
11/13/2013 E School Remodel (Refunding) 17102 59134 Principal 108,000.00
59134 Total 347,060.00
5/15/2010 A GOB Departmental Equipment - Ambulance 17102 59137 Principal 40,000.00
5/15/2010 I 'GOB Building Remodeling - School 17102 59137 Principal 16,000.00
5/15/2010 I GOB Building Remodeling - School 17102 59137 Principal 5,000.00
5/15/2010 I GOB Building Remodeling - School 17102 59137 Principal 6,000.00
5/15/2010 I , GOB Building Remodeling 17102 59137 Principal 4,000.00
5/15/2010 I GOB Building Remodeling - School 17102 59137 Principal 11,000,00
5/15/2010 I GOB Departmental Equipment - School 17102 59137 Principal 10,000.00
59137 Total 92,000.00
5/15/2009 A GOB Departmental Equipment - Ambulance 17102 59138 Principal 0.00
5/15/2009 I GOB Surface Drain 17102 59138 Principal 4,000.00
5/15/2009 I GOB Building Remodeling 17102 59138 1- Principal 45,000,00
5/15/2009 I GOB Building Remodeling - Police 17102 59138 Principal 9,000,00
5/15/2009 I ° GOB Building Remodeling - School 17102 59138 Principal 8,000,00
5/15/2009 I GOB Building Remodeling - School 17102 59138 Principal 60,000.00
5/15/2009 I GOB Building Remodeling - School 17102 59138 Principal 7,000.00
5/15/2009 I GOB Building Remodeling - School 17102 59138 Principal 2,000,00
5/15/2009 I ,GOB Building Remodeling - School 17102 59138 Principal 6,000.00
5/15/2009 I GOB Departmental Equipment - Public Works 17102 59138 Principal 15,000.00
5/15/2009 I GOB Departmental Equipment - Public Works 17102 59138 Principal 12,000.00
5/15/2009 I GOB Computer Hardware 17102 59138 Principal 43,000.00
59138 Total 211,000.00
3/15/2008 I GOB Building Remodeling REFUNDING 17102 1 59142 Principal 48,000,00
59142 Total 48,000.00
3/15/2008 E GOB Land Acquisition REFUNDING (Exempt) 17102 59143 Principal 49,000,00
59143 Total 49,000.00
AUTHDEBT.xlsx 3 11/22/2013Source page 7
FY 2015 FY 2015 COMMENT/REASON FOR
TOWN OF CANTON FY 11 FY 12 FY 13 ORIGINAL
ACTUAL YD BASE DEPT.
ACTUAL ACTUAL ACTUAL BUDGET INCREASE / DECREASE
BUDGET REPORT FOR FY 2015 EXPENSE EXPENSE EXPENSE FY 14 EXPENSES THRU BUDGET REQUEST
10/31/13
DEPARTMENTAL WORKSHEETS
751 LONG-TERM INTEREST PAYMENTS
17512 -59150 INTEREST PD LIT 05/2011 0 69,890 63,460 57,310 28,655 57,310
17512 - 59151 INT UT PD 5/11 DEBT EXCLUSION 0 142,850 132,420 122,150 61,075 122,150
17512- 59171 INT PD-12/01 DEBT 34,285 0 0 0 0 0
17512 - 59172 INT PD-12/01 DEBT EXCLUSION 247,683 0 0 0 0 0
17512 - 59173 INT PD-03/04 DEBT 242,371 226,406 209,836 191,782 92,266 191,782 V
17512 - 59174 INT PD-03104 DEBT EXCLUSION 835,571 784,315 731,140 672,762 309,631 672,762
17512- 59175 INT PD-01/06 DEBT 239,212 219,299 199,499 179,849 89,925 179,849
17512 - 59176 INT PD-01/08 DEBT 55,172 48,907 42.817 36,901 18,451
17512 - 59178 INT PD - 05/09 DEBT 101,495 93,635 88,535 83,475 0 83,475
17512 - 59179 INT PD - 05/10 DEBT 30,374 28,269 26,229 24,289 0 24,289
17512- 59180 INTEREST ON PAYDOWNS o o 0 79,513 0 79,513
17512- 59181 INT PD - 3/12 DEBT o o 80,592 0 39,756 0
17512 - 59182 INT PD - 03/13 DEBT 0 0 0 0 21,987
17512- 59192 INT PD-03/08 DEBT 16,755 13,010 9,265 7,515 0
17512- 59193 INT PD-03/08 DEBT EXCLUSION 10,993 9,208 7,423 5,673 0 5,673
SUBTOTAL EXPENSES $ 1,813,909 $1,635,787 $1,591,215 $1,461,219 $661,746 $1,461,219
TOTAL 751 LONG-TERM INTEREST PAYME $ 1,813,909 $1,635,787 $1,591,215 $1,461,219 $661,746 $1,461,219 vv/
Departm1t dead signature / Date
\\ _
3-"? Taf
Date: 11/14/2013 Page: 101Source page 8
LONG TERM DEBT SERVICE AMOUNTS FY 15
Date of Debt Service Type of
Issue Type Description Org Object Payment 2015
5/1/2011 GOB Building Construction - Public Works 17512 59150 Interest 6,772.50
5/1/2011 GOB Building Remodeling - Police 17512 59150 Interest 12,733.75
5/1/2011 GOB Building Remodeling - School 17512 59150 Interest 2,925.00
5/1/2011 GOB Building Remodeling - School 17512 59150 Interest 2,315.00
5/1/2011 GOB Building Remodeling - School 17512 59150 Interest 1,157.50
5/1/2011 GOB Energy Conservation - School 17512 59150 Interest 3,176.25
5/1/2011 GOB Departmental Equipment 17512 59150 Interest 0.00
5/1/2011 GOB Departmental Equipment 17512 59150 Interest 360.00
5/1/2011 GOB Departmental Equipment - Fire 17512 59150 Interest 760.00
5/1/2011 GOB Departmental Equipment - Public Works 17512 59150 Interest 360.00
5/1/2011 GOB Departmental Equipment - Public Works 17512 59150 Interest 3,960,00
5/1/2011 GOB Departmental Equipment - Public Works 17512 59150 Interest 3,820.00
5/1/2011 , GOB Asbestos Removal 17512 59150 , Interest 1,800.00
5/1/2011 GOB Building Remodeling REFUNDING 17512 59150 , Interest 7,210.00
5/1/2011 GOB Building Remodeling - School REFUNDING 17512 59150 Interest 2,740,00
5/1/2011 GOB Building Remodeling - School REFUNDING 17512 59150 Interest 1,020,00
5/1/2011 GOB Building Remodeling - School 17512 59150 Interest 540.00
5/1/2011 GOB Building Remodeling - School REFUNDING 17512 59150 Interest 540.00
59150 Total 52,190.00
5/1/2011 E GOB School Project REFUNDING (Exempt) 17512 59151 Interest 112,110.00
59151 Total 112,110.00
3/15/2004 I GOB Surface Drain 17512 59173 Interest 4,572.50
3/15/2004 I GOB Land Acquisition 17512 59173 Interest 6,858.75
3/15/2004 I GOB Building Remodeling ADA 17512 59173 Interest 15,927.50
3/15/2004 I GOB Building Remodeling - Police 17512 59173 Interest 118,352.50
3/15/2004 I GOB Building Remodeling - School 17512 59173 Interest 3,147.50
3/15/2004 I GOB Building Remodeling - School 17512 59173 Interest 4,585.00
3/15/2004 GOB Building Remodeling - School 17512 59173 Interest 3,622.50
3/15/2004 GOB Building Remodeling - Town Hall 17512 59173 Interest 3,147.50
3/15/2004 GOB Energy Conservation - School 17512 59173 Interest 7,868.75
3/15/2004 GOB Departmental Equipment - Fire 17512 59173 Interest 0.00
3/15/2004 GOB Building Construction REFUNDING 17512 59173 Interest
3/15/2004 GOB Building Remodeling REFUNDING 17512 59173 Interest
3/15/2004 GOB Building Remodeling - School REFUNDING 17512 59173 Interest
3/15/2004 GOB Building Remodeling - School REFUNDING 17512 , 59173 Interest
59173 Total 168,082,50
3/15/2004, GOB Building Construction - School (Exempt) 17512 59174 Interest 457,250.00
3/15/2004. GOB Building Addition - Library (Exempt) 17512 59174 Interest 116,512.50
3/15/2004. GOB Land Acquisition - Conservation REFUNDING (Exempt) 17512 59174 Interest
3/15/2004 GOB Land Acquisition REFUNDING (Exempt) 17512 59174 Interest
3/15/2004 GOB Building Remodeling - School REFUNDING (Exempt) 17512 59174 Interest
3/15/2004 GOB Building Remodeling - School REFUNDING (Exempt) 17512 59174 Interest
59174 Total 573,762.50
1/15/2006 I GOB Surface Drain 17512 59175 Interest
1/15/2006 I GOB Building Construction - Fire 17512 59175 Interest
1/15/2006 I GOB Building Remodeling - Fire 17512 59175 Interest
1/15/2006 I GOB Building Remodeling 17512 59175 Interest
1/15/2006 I GOB Building Remodeling - School 17512 59175 Interest
1/15/2006 I GOB Building Remodeling - School 17512 59175 Interest
1/15/2006 I GOB Building Remodeling - School 17512 59175 Interest
1/15/2006 I GOB Building Remodeling - School 17512 59175 Interest
1/15/2006 I GOB Building Remodeling - School 17512 59175 Interest
1/15/2006 I GOB Building Remodeling - School 17512 59175 Interest
1/15/2006 I GOB Departmental Equipment - Fire 17512 59175 Interest
AUTHDEBT.xlsx 1 11/22/2013Source page 9
LONG TERM DEBT SERVICE AMOUNTS FY 15
Date of Debt Service Type of
Issue Type Description Org Object Payment 2015
1/15/2006 I GOB Departmental Equipment - Fire 17512 59175 Interest
1/15/2006 I GOB Departmental Equipment - Fire 17512 59175 Interest
1/15/2006 I GOB Departmental Equipment - Highway 17512 59175 Interest
1/15/2006 I GOB Traffic Signal Installation 17512 59175 Interest
59175 Total 0.00
1/15/2008 I GOB Surface Drain 17512 59176 Interest 3,600.00
1/15/2008 I GOB Building Remodeling - School 17512 59176 Interest 2,840.50
1/15/2008 I GOB Building Remodeling - School 17512 59176 Interest 2,390.50
1/15/2008 I GOB Building Remodeling - School 17512 59176 Interest 5,090.50
1/15/2008 I GOB Building Remodeling - School 17512 59176 Interest 2,805.00
1/15/2008 I GOB Departmental Equipment 17512 59176 Interest 1,050.00
1/15/2008 I GOB Departmental Equipment - Public Works 17512 59176 Interest 1,470.00
1/15/2008 GOB Departmental Equipment - Fire 17512 59176 Interest 4,620.00
1/15/2008_ 1GOB Departmental Equipment 17512 59176 Interest 945.00
1/15/2008 GOB Departmental Equipment - Police 17512 59176 Interest 840,00
1/15/2008 GOB Dam Construction 17512 59176 Interest 420,00
1/15/2008 GOB Dam Construction 17512 59176 Interest 3,465.00
1/15/2008 GOB Outdoor Recreational Facility 17512 59176 Interest 1,450.00
59176 Total 30,986.50
5/15/2009 GOB Departmental Equipment - Ambulance 17512 59178 Interest 0.00
5/15/2009 GOB Surface Drain 17512 59178 Interest 1,765.00
5/15/2009 GOB Building Remodeling 17512 59178 Interest 20,602.50
5/15/2009 GOB Building Remodeling - Police 17512 59178 Interest 3,682.50
5/15/2009 GOB Building Remodeling - School 17512 59178 Interest 3,925.00
5/15/2009 GOB Building Remodeling - School 17512 59178 Interest 31,507,50
5/15/2009 GOB Building Remodeling - School 17512 59178 Interest 3,385,00
5/15/2009 GOB Building Remodeling - School 17512 59178 Interest 995,00
5/15/2009 GOB Building Remodeling - School 17512 59178 Interest 2,985.00
5/15/2009 GOB Departmental Equipment - Public Works 17512 59178 Interest 2,085,00
5/15/2009 GOB Departmental Equipment - Public Works 17512 59178 Interest 1,710,00
5/15/2009 GOB Computer Hardware 17512 59178 Interest 5,185,00
59178 Total 77,827.50
5/15/2010 GOB Departmental Equipment - Ambulance 17512 59179 Interest 1,200.00
5/15/2010 GOB Building Remodeling - School 17512 59179 Interest 7,617.00
5/15/2010 GOB Building Remodeling - School 17512 59179 Interest 1,926.50
5/15/2010 GOB Building Remodeling - School 17512 59179 Interest 2,382.00
5/15/2010 GOB Building Remodeling 17512 59179 Interest 2,142.00
5/15/2010 GOB Building Remodeling - School 17512 59179 Interest 5,695.00
5/15/2010 GOB Departmental Equipment - School 17512 59179 Interest 1,386.25
59179 Total 22,348.75
3/27/2012 GOB Surface Drain 17512 59181 Interest 13,340,00
3/27/2012 GOB Building Remodeling - School 17512 59181 Interest 2,530.00
3/27/2012 ,GOB Building Remodeling - School 17512 59181 Interest 1,760,00
3/27/2012 GOB Building Remodeling - School 17512 59181 Interest 2,340,00
3/27/2012 GOB Building Remodeling 17512 59181 Interest 820,00
3/27/2012 GOB Energy Conservation 17512 59181 Interest 21,340,00
3/27/2012 GOB Departmental Equipment - School 17512 59181 Interest 24,002.50
3/27/2012 GOB Departmental Equipment - School 17512 59181 Interest 9,780,00
59181 Total 75,912.50
3/15/2013 GOB Building Construction - Public Works 17512 59182 Interest 4,350,00
3/15/2013 ° GOB Building Remodeling - School 17512 59182 Interest 3,770.00
3/15/2013 GOB Dam Construction 17512 59182 Interest 5,020,00
3/15/2013 GOB Departmental Equipment 17512 59182 Interest 1,590.00
3/15/2013 GOB Architectural Services Building - Senior Citizen 17512 59182 Interest 13,050.00
AUTHDEBT.xlsx 2 11/22/2013Source page 10
LONG TERM DEBT SERVICE AMOUNTS FY 15
Date of Debt Service Type of
Issue Type Description Org Object Payment 2015
3/15/2013 I GOB Engineering Services 17512 59182 Interest 1,350,00
3/15/2013 I GOB School Project 17512 59182 Interest 6,120.00
3/15/2013 I GOB School Project 17512 59182 Interest 3,890,00
59182 Total 39,140,00
11/13/2013 I Surface Drain (Refunding) 17512 59183 Interest 1,839.22
11/13/2013, I Building Construction - Fire (Refunding)
, 17512 59183 Interest 30,817.72
11/13/2013 I Building Construction - Fire (Refunding) 17512 59183 Interest 14,314.01
11/13/2013 I Building Remodeling ADA - (Refunding) 17512 59183 Interest 32,312.31
11/13/2013 I Building Remodeling - School - (Refunding) 17512 59183 Interest 4,826.04
11/13/2013 I Hansen School Plumbing - (Refunding) 17512 59183 Interest 2,413.61
11/13/2013 I Kennedy School Boiler - (Refunding) 17512 59183 Interest 5,290,24
11/13/2013 I Building Remodeling - School - (Refunding) 17512 59183 Interest 6,770,76
11/13/2013 I Building Remodeling - School - (Refunding) 17512 59183 Interest 696.30
11/13/2013 I Building Remodeling-School - (Refunding) 17512 59183 Interest 16,969.09
11/13/2013 I Ladder Truck - Fire (Refunding) 17512 59183 Interest 2,754.72
11/13/2013 I Fire Tanker Truck - (Refunding) 17512 59183 Interest 1,308,20
11/13/2013 I DPW Highway Truck - (Refunding) 17512 59183 Interest 372,77
11/13/2013 I Traffic Signal Installation - (Refunding) 17512 59183 Interest 1,469.97
11/13/2013 I Recreation Dept Garage (Refunding) 17512 59183 Interest 2,102,00
11/13/2013 I Replace Windows (Refunding) 17512 59183 Interest 1,190.50
11/13/2013 I High School Windows (Refunding)
, 17512 59183 Interest 1,104.20
11/13/2013 I School Plumbing (Refunding) 17512 59183 Interest 1,104.20
59183 Total 127,655.86
11/13/2013 E Land Acquisition - Conservation (Refunding) 17512 59184 Interest 11,431.00
11/13/2013 E Land Acquisition - Town Hall (Refunding) 17512 59184 Interest 5,722.50
11/13/2013 E , School ADA (Refunding) 17512 59184 Interest 7,446,60
11/13/2013 E School Remodel (Refunding) 17512 59184 Interest 12,941.00
59184 Total 37,541.10
3/15/2008 I GOB Building Remodeling REFUNDING 17512 59192 Interest 5,640,00
59192 Total 5,640,00
3/15/2008 E GOB Land Acquisition REFUNDING (Exempt) 17512 59193 Interest 3,797,50
59193 Total 3,797,50
AUTHDEBT.xlsx 3 11/22/2013Source page 11
FY 2015 FY 2015
TOWN OF CANTON FY 11 FY 12 FY 13 ORIGINAL COMMENT/REASON FOR
ACTUAL ACTUAL ACTUAL BUDGET ACTUAL YTD BASE DEPT. INCREASE / DECREASE
BUDGET REPORT FOR FY 2015 EXPENSE EXPENSE EXPENSE FY 14 EXPENSES THRU BUDGET REQUEST
DEPARTMENTAL WORKSHEETS 10/31/13
752 SHORT-TERM INTEREST PAYMENTS
17522 - 59250 INTEREST TEMPORARY LOANS 22,807 18,278 17,288 53,000 0 53,000
17522- 59251 INTEREST ON SANS 1,665 0 0 0 0 0
17522- 59256 INTEREST ON TAX REFUNDS 594 1,834 69,301 0 0 0
SUBTOTAL EXPENSES 25.066 $20,111 $86,589 $53,000 $0 $53,000
TOTAL 752 SHORT-TERM INTEREST PAYNE $ 25,066 $20,111 $86,589 $53,000 $O $53,000
0(3
D partmen eàs signature / Date
Date: 11/14/2013 Page: 102Source page 12
DEBT SERVICE PROJECTIONS - DEBT IN PIPELINE
AUTHORIZED AUTHORIZED TERM BOND BAN BOND FY
DATE ART # PURPOSE UNISSUED (YRS) DATE RATE RATE INT PRIN 2015
,
4/29/1998 23 SEPTIC TITLE V 200,000 N/A N/A N/A N/A 0 0 0
4/24/2006 12-4 DEDHAM STREET DRAINAGE (balance) 50,0001 N/A N/A N/A N/A 0 0 0
4/30/2007 15-4 FIBER CABLE NETWORK (balance) 25,000 N/A N/A N/A N/A 0 0 0
4/30/2007 _74 15-6 ADA RENOVATIONS (balance) 50,0001- 51 N/A 1.50% N/A 0 0 0
4/30/2008 13-4 FIRE AIR COMPRESSOR (BAN paydown) 15,800 5 N/A 1.50%1 N/A t 0, 0- 0
4/30/2008 - 13-4 PONKAPOAG FIRE STATION ROOF REPAIRS (balance) 7,786- 5 N/A 1.50% N/A 0 0 0
4/30/2008 13-4 RECREATION TRUCK (BAN paydown) 10,000 5 N/A 1.50% N/A 0 0 0
4/30/2008 13-5 SCHOOL HVAC REPLACEMENTS (BAN paydown) 22,000 N/A N/A N/A N/A 0 0 0
4/27/2011 13-5 BOLIVAR & PINE STREET CULVERTS (balance) 81,000 N/A N/A N/A N/A 7 0 0 0
4/27/2011 25 HIGH SCHOOL ROOF REPAIR (balance) 81,527 N/A N/A N/A N/A -' 0 0
4/27/2011 26 RODMAN BUILDING ROOF REPAIR (balance) 209,314 N/A N/A N/A N/A 0 0 0
4/30/2012 13-4 DPW DUMP TRUCK (BAN) 175,000, 10 Mar-14 1.00% 3.00% 5 18 23
4/30/2012 13-8 SCHOOL HVAC REPLACEMENTS (BAN) 112,0001 10 Mar-15 1.25% 3.25% 1 0 1
4/30/2012 27 HANSEN SCHOOL WINDOWS (MSBA 40% GRANT) 342,000, 20, Mar-15 1.25% 3.25% 0 0 0
4/30/2012 , 28 GALVIN MIDDLE SCHOOL WINDOWS (MSBA 40% GRANT) 411,9501 20 Mar-15 1.25% 3.25% 0 0 0
1
5/13/2013 11-4 DPW CATCH BASIN TRUCK 191,000 10 Mar-15 1.25% 3.25% 4 2 0 2
5/13/2013 32 - HANSEN SCHOOL WINDOWS SUPPLEMENT 681,295- 20 Mar-15 1.25% 3.25% 0 0 0
5/13/2013 33 GALVIN MIDDLE SCHOOL WINDOWS SUPPLEMENT 919,322 20 Mar-15 1.25% 3.25%t 0 0 0
,
TOTAL INSIDE LEVY 3,584,994 9 18 27
5/13/2013 11-6 FIRE LADDER TRUCK 810,000 Mar-15 1.25% 3.25%7 10 10
4/27/2011 13-10 RODMAN BUILDING HEATING SYSTEM (balance) 280,000 N/A N/A N/A N/A 0 30 30
4/30/2008 13-8 WATER SYSTEM IMPROVEMENTS (BAN) 475,000- 10 Mar-14 1.00% 3.00% 14 48 62
4/26/2010 13-7 VALVE & HYDRANT REPLACEMENTS (balance) 290,000 10 N/A N/A N/A 0 0 0
4/26/2010 13-8 CAPITAL IMPROVEMENT PLAN ENGINEERING (balance) 30,000 5 N/A N/A N/A 0 30 30
4/30/2012 13-6 WATER SYSTEM MASTER PLAN IMPROVEMENTS (BAN $1.1m) 1,400,000 20 Mar-14 1.00% 3.00% 42 70 112
5/13/2013 11-9 METER REPLACEMENT 631,250 10 Mar-15 1.25% 3.25% 0 0 0
TOTAL WATER 2,826,250- 56 1 148 204
5/1/2000 15-12 'SEWER I & I 1,019,790 20 Mar-14 1.00% 3.00% 9 15 24
4/30/2007 15-9 GREENLODGE ST INTERCEPTOR (ARRA principal foregiveness) 497,305 N/A N/A N/A N/A 0 0 0
4/30/2007 15-9 GREENLODGE ST INTERCEPTOR (balance) 757,000 10 N/A N/A N/A 0 , 0 0
4/30/2008 13-9 SCADA UPGRADE & TRUCKS (balance) 145,000 10 Mar-15 1.25% 3.25% 0 0 0
5/13/2013 11-10 WATER RESOURCE MANAGEMENT PLAN 153,000 5 Mar-15 - 1.25% 3.25% 0 , 0' 0
5/13/2013 11-11 METER REPLACEMENT 378,750 10 Mar-15 1.25% 3.25% 0 0. 0
TOTAL SEWER 1 15
2,950,845 9 24
5/13/2013 11-12 RINK COMPRESSOR & GLYCOL TANK 245,000 15, Mar-151 1.25% 3.25% 0 0 0
- GRAND TOTALS-AUTHORIZED DEBT 10,697,089 84 210: 294
AUTHDEBT.xlsx PIPELINE 12/6/2013Source page 13
TOWN OF CANTON FY 11 FY 12 FY 13 ORIGINAL FY 2015
ACTUAL FY 2015
BUDGET REPORT FOR FY 2015 ACTUAL ACTUAL BUDGET ACTUAL YTD BASE COMMENT/REASON FOR
EXPENSE EXPENSE DEPT. INCREASE / DECREASE
EXPENSE FY 14 EXPENSES i Mal BUDGET
DEPARTMENTAL WORKSFIEETS 10/31/13
REQUEST
132 RESERVE FUND
11322 - 59600 RESERVE FUND TRANSFER OUT
0 0 500,000 0 500,000
SUBTOTAL EXPENSES $0 $O $500,000 $0 $500,000
TOTAL 132 RESERVE FUND 0 $0 $O $500,000 $0 $500,000
artment Head signature / Date
pc1 eVod liq iy
Date: 11/15/2013
Page: 4Source page 14
TOWN OF CANTON FY 11 FY 12 FY 13 ORIGINAL FY 2015 FY 2015
ACTUAL ACTUAL COMMENT/REASON FOR
BUDGET REPORT FOR FY 2015 EXPENSE EXPENSE
ACTUAL BUDGET ACTUAL YTD BASE DEPT. INCREASE / DECREASE
EXPENSE FY 14 EXPENSES THRU BUDGET REQUEST
DEPARTMENTAL WORKSHEETS 10/31/13
422 STREET LIGHTING
14222- 52101 ELECTRICITY 128,520
14222 - 52438 MAINTENANCE CONTRACT 0
86,480
30,648
92,695 120,000 18,582 j3sLGeer---- I
24,763 30,000 5,471 30,000 3Z:bcCa
14222- 57000 OTHER CHARGES/EXPENDITURE 772 3,633 0 0 0 0
$ 129,292
SUBTOTAL EXPENSES $120,760 $117,457 $150,000 $24,053 $150,000 , o,
TOTAL 422 STREET LIGHTING $ 129,292 $120,760 $117,457 $150,000 $24,053 $150,000
-7-
Department Head signature / D‘ate
Date: 11/14/2013
Page: 75Source page 15
FY2015 FY2015 COMMENT/REASON FOR
FY 11 FY 12 FY 13 ORIGINAL
TOWN OF CANTON ACTUAL BUDGET ACTUAL YTD BASE DEPT. INCREASE / DECREASE
ACTUAL ACTUAL BUDGET REQUEST
BUDGET REPORT FOR FY 2015 EXPENSE EXPENSE FY 14 EXPENSES THRU
EXPENSE
10/31/13
DEPARTMENTAL WORKSHEETS
423 SNOW & ICE REMOVAL
2,971 0 1,261 2,000 0 2,000
14231 -51162 POLICE DETAIL SALARIES
77,548 200,860 129,500 0 129,500 ire, 000 Soo co...<44- PAcit
14231 -51300 OVERTIME SALARY 203,228
$ 206,199 $77,548 $202,121 $131,500 $0 $131,500 / ca. 00 0
SUBTOTAL SALARIES & WAGES
14232 - 52000 PURCHASE OF SERVICES 211,824 21,631 122,550 78,392 70 78,392 00-0 v Co 6 Govcre.. o.dcii Cosi'
55,362 47,789 53,680 12,857 303 12,857
14232- 52425 REPAIR/MAINT EQUIPMENT
858 199 1,040 1,000 0 1,000
14232 - 52426 REPAIRS - STORM DAMAGE
0 1,499 345 47,553 0 47,553 _
14232- 52703 RENTAL OF EQUIPMENT
1,395 1,395 1,395 1,090 1,395 1,090 _
14232- 53806 WEATHER SERVICE CONTRACT
0 0 23,953 0 0 0 _
14232- 54801 GASOLINE FUEL
13,660 3,190 11,268 1,000 0 1,000
14232 - 54901 MEALS
231,598 100,476 215,409 91,343 0 91,343 1i ,,s- oe.c. A.B,CS7 cou c add/ 1n.le...e4
14232-5530C SALT, SAND & CHEMICALS
0 0 12,880 0 0 0 0
14232 - 58500 EQUIPMENT PURCHASE
$ 514,697 $176,178 $442,519 $233,235 $1,768 $233,235 ro
SUBTOTAL EXPENSES
$253,725 $644,641 $364,735 $1,768 $364,735 41 4, Soy:,
TOTAL 423 SNOW & ICE REMOVAL $ 720,897
- - 13
Department Head signature / Date
Page: 76
Date: 11/14/2013Source page 16
FY 2015 FY 2015 COMMENT/REASON FOR
TOWN OF CANTON FY 11 FY 12 FY 13 ORIGINAL
ACTUAL '(I'D BASE DEPT.
ACTUAL ACTUAL ACTUAL BUDGET INCREASE / DECREASE
BUDGET REPORT FOR FY 2015 EXPENSE EXPENSE EXPENSE FY 14 EXPENSES TRRU BUDGET REQUEST
10/31/13
DEPARTMENTAL WORKSHEETS
433 TRASH COLLECTION
14332 - 52000 PUR OF SERV-LANDFIL MONITOR 28,480 11,250 35,950 0 7,300 0 .Z 5-0 (.̀>
14332- 52901 TRASH REMOVAL COSTS 982,394 1,004,962 1,199,482 1,063,992 275,024 1,063,992 j
14332- 52902 RECYCLING COSTS 251,472 249,736 102,731 250,000 62,191 250,000
14332- 52903 COMPOSTING COSTS 28,575 75,421 48,145 \ 60,000 24,500 60,000
14332- 53136 HOUSEHOLD HAZARD WASTE 15,952 28,371 17,360 25,000 2,400 25,000
14332- 54000 SUPPLIES 0 0 5,616 0 0 0
..■
••■■
••
14332- 57815 MERCURY SURCHARGE 53,458 53,928 51,995 50,000 13,771 50,000
SUBTOTAL EXPENSES S 1360,331 $1,423,668 $1,461,279 $1,448,992 $385,185 $1,448,992
TOTAL 433 TRASH COLLECTION S 1,360,331 $1,423,668 $1,461,279 51,448,992 $385,185 $1,448,992
•
Department Head signature / Date
- coin
SD --7-5N ocp-
C-0C
I 1471, 00
ST? C/j
-- sf a 0 0 Page: 80
000
S-C-D 000
JSource page 17
Murgia, James R.
From: Friel, William T.
Sent: Monday, January 06, 2014 10:33 AM
To: Murgia, James R.
Subject: RE: Fy 15 Trash Budget
Bingo — I have as a plug number for fy 15, $1,553,000 which is the 2.5 on the contract for republic and an Est increase for
semass of 215k. This is the status quo est. and does not calculate the latest ongoing automated program cost est which
in Feb. BOS plans to decide on. This number is good for now. Bill
From: Murgia, James R.
Sent: Monday, January 06, 2014 10:13 AM
, To: Friel, William T.
Cc: Trotta, Michael
Subject: Fy 15 Trash Budget
Bill — Mike submitted the fy 15 trash budget on a level funded basis. While we all would love to see that, it's
probably not going to happen. I penciled in what I thought the fy 15 trash budget should be. I used Republic's
automated collection proposal of $1,165,000 & their $64.50/ton tipping fee for 6 months as the SEMASS contract
expires 12/31/14. Adding in landfill monitoring, yard waste & hazardous waste, I come up with $1,552,000, which is
about $100k more than our fy 14's trash budget. Let me know what you think. Thanks.
1Source page 18
FY 2015 FY 2015 COMMENT/REASON FOR
TOWN OF CANTON FY 11 FY 12 FY 13 ORIGINAL
ACTUAL YTD BASE DEPT. INCREASE / DECREASE
ACTUAL ACTUAL ACTUAL BUDGET
BUDGET REPORT FOR FY 2015 EXPENSE EXPENSE EXPENSE FY 14 EXPENSES THRU BUDGET REQUEST
10/31/13
DEPARTMENTAL WORKSHEETS
840 BLUE HILLS REGIONAL
18402- 56991 BLUE HILLS REGIONAL 1,460,438 1,337,865 1,173,074 1,059,042 353,014 1,059,042
SUBTOTAL EXPENSES $ 1,460,438 $1,337,865 $1,173,074 $1,059,042 $353,014 $1,059,042
TOTAL 840 BLUE HILLS REGIONAL $ 1,460,438 $1,337,865 $1,173,074 $1,059,042 $353,014 $1,059,042
ead signature / Date
Date: 11/14/2013 Page: 105Source page 19
FY2015 FY2015 COMMENT/REASON FOR
TOWN OF CANTON FY 11 FY 12 FY 13 ORIGINAL
ACTUAL BUDGET ACTUAL YTD BASE DEPT. INCREASE / DECREASE
ACTUAL ACTUAL
BUDGET REPORT FOR FY 2015 FY 14 EXPENSES THRU BUDGET REQUEST
EXPENSE EXPENSE EXPENSE
10/31/13
DEPARTMENTAL WORKSHEETS
841 NORFOLK COUNTY AGRICULTR HS
18412 - 56992 NORFOLK COUNTY AGRICULTUR/ 0 0 6,000 10,000 0 10,000
SUBTOTAL EXPENSES 0 $0 $6,000 $10,000 $0 $10,000
TOTAL 841 NORFOLK COUNTY AGRICULT1 $ 0 $0 $6,000 $10,000 $O $10,000
Department H signature / Date
Date: 11/14/2013 Page: 106Source page 20
FY 2015 FY 2015
TOWN OF CANTON FY 11 FY 12 FY 13 ORIGINAL
BASE DEPT.
COMMENT/REASON FOR
ACTUAL ACTUAL ACTUAL BUDGET ACTUAL YD INCREASE! DECREASE
BUDGET REPORT FOR FY 2015 EXPENSE EXPENSE EXPENSE FY 14 EXPENSES THRU BUDGET REQUEST
DEPARTMENTAL WORKSHEETS 10/31/13
911 RETIREMENT BENEFITS
19111 - 51770 NONCONTRIBUTORY PENSIONS 39,842 39,842 39,842 40,000 10,540 40,000
19111 -51780 NORFOLK COUNTY RETIREMENT 2,933,187 2,898,532 3,041,784 3,169,146 3,169,146 3,169,146
19111 -51790 DISABILITY PENSION 3,667 3,667 3,667 3,700 1,222 3,700
SUBTOTAL SALARIES & WAGES S 2,976,695 $2,942,040 $3,085,292 53,212,846 $3,180,908 $3,212,846
TOTAL 911 RETIREMENT BENEFITS $ 2,976,695 $2,942,040 $3,085,292 $3,212,846 $3,180,908 $3,212,846
/
t Head signature / Date
Date: 11/14/2013 Page: 108Source page 21
Norfolk County Retirement System
December 16, 2013
To: Board of Selectmen
Town of Canton
From: Norfolk County Retirement System
ph A. Connolly
irman/Treasurei
ephine E. Shea
ted Membei
Subj: Town of Canton
Fiscal Year 2015 Appropriation
Karen F. Jelloe
Ap pointed Menthei
Paul J. Connors
Appointed Menibe, The Norfolk County Retirement System has received several inquiries relative to the
Edwin S Little member unit appropriation amounts for Fiscal Year 2015. We have received the
Elected Member appropriation figures. The units have two payment options,
1) Paying the appropriation in two equal payments, one due on July 1, 2014 and
the second due on January 1, 2015,
2) Paying the appropriation in a single payment on July 1, 2014 at a reduced
rate, approximately 2% less than option 1.
The amounts of each are set forth below. Please note that your Fiscal Year 2015
appropriation includes prior Early Retirement Incentives (ERIs), where applicable.
Option 1: $3,641,491.00 payable in two equal payments of
$1,820,745.50, the first on July 1, 2014 and the second on
Jatwary 1, 2015.
Option 2: $ 3,570,734.00 due in full on July 1, 2014.
The actual appropriation bills will be sent out at a later date.
We hope the above information is helpful. If you have any questions, please contact
Patrick LePage at 781-821-0664. Thank you.
480 Neponsel Street, Building #15, Canton, MA 02021 e Tel: 781-821-0664 .800-247-9992 °Fax: 781 -821 -0981
www.notfollccomityretiremeni org info@norfolkeountyreiiremeni.org 5Source page 22
TOWN OF CANTON FY 11 FY 12 FY 13 ORIGINAL FY2015 FY 2015 COMMENT/REASON FOR
ACTUAL ACTUAL ACTUAL ACTUAL YD BASE DEPT.
BUDGET REPORT FOR FY 2015 EXPENSE EXPENSE EXPENSE
BUDGET
EXPENSES THRU BUDGET
TNCREASE / DECREASE
FY 14 REQUEST
DEPARTMENTAL WORKSHEETS 10/31/13
913 UNEMPLOYMENT COMPENSATION
19131 -51720 UNEMPLOYMENT COMPENSATIO 100,000 100,000 100,000 150,000 150,000 150,000
SUBTOTAL SALARIES & WAGES $ 100,000 $100,000 $100,000 $150,000 $150,000 $150,000
TOTAL 913 UNEMPLOYMENT CO1VIPENSAT $ 100,000 $100,000 $100,000 $150,000 $150,000 $150,000
/11
6/./(6/14 IL/44
epartment Head signature / Date
Date: 11/14/2013
Page: 109Source page 23
FY 2015 FY 2015 COMMENT/REASON FOR
TOWN OF CANTON FY 11 FY 12 FY 13 ORIGINAL
ACTUAL YTD BASE DEPT.
ACTUAL ACTUAL ACTUAL BUDGET INCREASE / DECREASE
BUDGET REPORT FOR FY 2015 EXPENSE EXPENSE EXPENSE FY 14 EXPENSES THRU BUDGET REQUEST
10/31/13
DEPARTMENTAL WORKSHEETS
915 EMPLOYER SHARE-LIFE INS
19151 -51751 LIFE INS-EMPLOYER SHARE 58,666 57,233 57,696 60,000 24,230 60,000 :)(0 000
SUBTOTAL SALARIES & WAGES $ 58,666 $57,233 $57,696 $60,000 $24,230 $60,000
TOTAL 915 EMPLOYER SHARE-LIFE INS $ 58,666 $57,233 $57,696 $60,000 $24,230 $60,000 00
epartmetH.d signature! Date
Date: 11/14/2013 Page: 111Source page 24
TOWN OF CANTON FY 11 FY 12 FY 13 ORIGINAL FY 2015 FY 2015 COMMENT/REASON FOR
ACTUAL ACTUAI. ACTUAL BUDGET ACTUAL YTD BASE DEPT. INCREASE/ DECREASE
BUDGET REPORT FOR FY 2015 EXPENSE EXPENSE EXPENSE FY 14 EXPENSES THR'U BUDGET REQUEST
DEPARTMENTAL WORKSHPETS 10/31/13 ,
tep:tieck`
-/-e2 c- .
946 TOWN INSURANCE
19462- 53814 INJURY IN LINE OF DUTY-POLICE 6-e r3) 8,093 10,895 6,137 32,754 129 32,754 add 6,
19462 - 53S15-INJURY IN LINE OF DUTY-FIRE--/Y-Q1 E18,711 10,908 22,536 10,918 9,378 10,918 ,
0 ..L.946.2.GQG-GW-14E9,.GH (S4...tei 4,500 0 0 0 0 0
19462- 57405 WORKERS COMP. INSURANCE 260,067 279,833 321,222 276,492 277,323 276,492 0czcirtf-(1;1,01(fe-S
.›.
,
19462- 57406 POLICE LIABILITY 12,247 7,952 7,178 16,377 11,262 16,377
19462- 57408 PUBLIC OFFICIALS LIABILT 20,168 19,909 30,300 18,561 27,864 18,561
19462- 57409 UMBRELLA LIABILITY 91,027 93,398 23,922 43,672 24,493 43,672
19462-5740A AUTO FLEET 2,584 365 88,418 103,721 123,990 103,721
19462-5740B PROPERTY PACKAGE 6(6/ 154,127 160,656 182,413 201,641 203,335 201,641
19462-5740C SCHOOL LEGAL LIABILITY e• V- 9,091 8,826 8,468 13,102 11,549 13,102
19462 t40F BOIL-ER-&-MACHINERYPp • 9,930 10,180 0 7,861 0 7,861 ei■
ov,zo fc1S C,
ei 19462-5740G GEN ERAL LIABILITY tOSS e'r el/ 38,819 50,644 1 , 51,063 ,- 38,213 ---- 36,546 38,213
194G2-5740H-INUEMNRGAT,ROKE/FIRE 8,146 10,940 3,875 13,102 2,381 .1.3.3402r 1,A0o<e ff-ncc_
19462- 57401 TOWN INS. POLICE/FIRE eilar''''e-^-1011 64,618 61,328 64,232 38,213 0 38,213 75,,Tc00
1-9462..."5-7471.0-EIVIREGYE-RzPRA614GES=61AB1NS 0
_
0 0 10,918 0 10,918
19462- 57411 POLLUTION LIABILITY INSURANC1 f 34,451 34,451 35,485 52,405 36,905 52,405
4-9462.-.644.12NGW.REMENAL+1A131L1TY 0 0 1,426 0 0 0 -
+94 462-oetkolamixtpto*HRE 0,2_1 eke , 0 206 0 0 0 0 o
SUBTOTAL EXP SES $ 736,579 $760,491 $846,675 $877,950 $765,155 $877,950
3'14 946 TOWN INSURANCE
OTA.L S 736,579 $760,491 8846,675 $877,950 $765,155 $877,950
e "Ce cUrd
f
•(4 fri b Department Head signature / Date
• (VI ovc, Cmp I oye r ,r 41re, "ICAO 41 hit c,
Foivdt Ail -/r> Pu h bc-%-_- --: tec.,
)
Date: 11/15/2013 113
• e e5
0 /
ktAbill
rtc/i) 4" dee
/
.,r
e 4.6 ?•et. 444
11 ailing 1} 2,ng6(1 da
4- 4; /e77:;" Page:
C /Jake akS
„1444C 9/ (V II Ach " LiA&
" ,,. it/vi LEc
0 n?
S'
-I , (4ta), a-6/ ?e31Source page 25
FY 2015 FY2015 COMMENT/REASON FOR
TOWN OF CANTON FY 11 FY 12 FY 13 ORIGINAL
ACTUAL YTD BASE DEPT. INCREASE / DECREASE
ACTUAL ACTUAL ACTUAL BUDGET
BUDGET REPORT FOR FY 2015 FY 14 EXPENSES THRU BUDGET REQUEST
EXPENSE EXPENSE EXPENSE
10/31/13
DEPARTMENTAL WORKSHEETS
993 OPEB TRANSFER
19932- 59615 TRANSFER TO OPEB 0 0 50,000 400,000 400,000 400,000 4C(0 0 on
SUBTOTAL EXPENSES 0 $0 $50,000 $400,000 $400,000 $400,000
TOTAL 993 OPEB TRANSFER $O $50,000 $400,000 $400,000 $400,000
ead signature / Date
Date: 11/14/2013 Page: 116Source page 26
FY 13 ORIGINAL FY 2015 FY 2015 COMMENT/REASON FOR
TOWN OF CANTON FY 11 FY 12
ACTUAL ACTUAL BUDGET ACTUAL YTD BASE DEPT. INCREASE / DECREASE
ACTUAL
BUDGET REPORT FOR FY 2015 EXPENSE EXPENSE EXPENSE FY 14 EXPENSES THRU BUDGET REQUEST
10/31/13
DEPARTMENTAL WORKSHEETS
820 CHERRY SHEET ASSESSMENTS
18202- 56304 CHARTER SCHOOLASSESSMEN7 82,975 79,828 141,218 121,404 0 121,404
18202- 56310 SPECIAL EDUCATION CH71B 15,349 19,084 26,279 27,336 8,936 27,336
18202 - 56320 SCHOOL CHOICE ASSESSMENT 0 10,000 10,000 10,000 4,418 10,000
18202- 56390 MOSQUITO CONTROL PROJECT 78,918 83,961 86,497 89,216 29,715 89,216
18202- 56400 AIR POLLUTION CONTR DIST 7,279 7,605 7,692 7,836 2,612 7,836
18202 - 56410 METRO AREA PLANNING CNCL 6,647 6,810 6,792 6,962 2,322 6,962
18202 - 56460 REG OF MV NON-RENEWAL 24,240 26,880 29,560 29,560 9,268 29,560
18202- 56610 MASS BAY TRANSIT AUTHORT 449,707 449,549 455,619 460,559 153,520 460,559
$ 665,115 $683,717 $763,657 $752,873 $210,791 $752,873
SUBTOTAL EXPENSES
TOTAL 820 CHERRY SHEET ASSESSMENTS $ 665,115 $683,717 $763,657 $752,873 $210,791 $752,873
-7-2 z
y Departme Head signature / Date
Date: 11/14/2013 Page: 103Source page 27
FY 2015 FY 2015 COMMENT/REASON FOR
TOWN OF CANTON FY 11 FY 12 FY 13 ORIGINAL
ACTUAL YTD BASE DEPT.
ACTUAL ACTUAL ACTUAL BUDGET INCREASE / DECREASE
BUDGET REPORT FOR FY 2015 EXPENSE EXPENSE EXPENSE FY 14 EXPENSES THRU BUDGET REQUEST
10/31/13
DEPARTMENTAL WORKSHEETS
830 COUNTY TAX-CHERRY SHEET
18302 - 56210 COUNTY TAX 184,034 191,104 195,881 194,406 97,203 194,406 I 0192-k-,
SUBTOTAL EXPENSES $ 184,034 $191,104 $195,881 $194,406 $97,203 $194,406
TOTAL 830 COUNTY TAX-CHERRY SHEET $ 184,034 $191,104 $195,881 $194,406 $97,203 $194,406
jJJ
U Department ad signature / Date
LA.."
Date: 11/14/2013 Page: 104Source page 28
FY 2015 FY 2015
TOWN OF CANTON FY 11 FY 12 FY 13 ORIGINAL
BASE DEPT.
COMMENT/REASON FOR
ACTUAL ACTUAL ACTUAL BUDGET ACTUAL YTD INCREASE / DECREASE
BUDGET REPORT FOR FY 2015 EXPENSE EXPENSE EXPENSE FY 14 EXPENSES THRU BUDGET REQUEST
DEPARTMENTAL WORKSHEETS 10/31/13
914 EMPLOYER SHARE-HEALTH INS
19141 - 51730 HEALTH INSURANCE OPT OUT 2,008 2,008 9,108 7,500 3,269 7,500
19141 - 51732 MEDEX EMPLOYER SHARE 1,379,762 1,359,357 1,332,761 1,455,763 498,824 1,455,763
19141 -51733 DENTAL HEALTH PLAN 466,639 443,897 459,897 467,567 167,769 467,567
19141 - 51735 HMO BLUE-EMPLOYER SHARE 5,497,883 5,979,038 5,814,514 6,034,109 2,110,752 6,034,109
19141 - 51737 PPO BCBS EMPLOYER SHARE 1,880,506 1,758,927 1,764,100 1,885,218 622,817 1,885,218
19141 - 51740 MEDICARE EMPLOYER SHARE 520,318 538,117 575,314 583,503 198,715 583,503 G2-z+ I 2-Q
19141 - 51741 MEDICARE PART B PENALTY 67,655 60,456 58,442 60,000 20,346 60,000 .CnO
19141 - 57000 OTHER CHARGES/EXPENDITURE 0 4,500 4,500 4,500 0 4,500 )^)'
SUBTOTAL SALARIES & WAGES $ 9,814,770 $10,146,298 $10,018,636 $10,498,160 $3,622,492 $10,498,160
TOTAL 914 EMPLOYER SHARE-HEALTH IN $ 9,814,770 $10,146,298 $10,018,636 $10,498,160 $3,622,492 $10,498,160
Date: 11/14/2013 Page: 110Source page 29
FY 2015 HEALTH INSURANCE EXPENSE ESTIMATE
PPO PLAN HMO BLUE HEALTH DELTA DENTAL DENTAL • PART B OTHER
MONTH INDIV FAMILY INDIV FAMILY MEDEX TOTALS INDIV FAMILY TOTALS MEDICARE PENALTY CHARGES TOTALS
LATEST COUNTS 70 57 ' 167 311 420 1,025 380 540 1 920 i
,
ESTIMATED INCREASE IN MEMBERSHIP * 0 0 0 0 30 30 ' 8 15 I
ESTIMATED MEMBERSHIP 70 57 167 311 450 ' 1,055 387 548 935
ESTIMATED MONTHLY SHARE - FY 14 715.05 1,696.28 521.33 ' 1,370.25 279.75 17.33 _ 58.91
ESTIMATED % INCREASE IN RATES 30.0% 30.0% 1.0% 1.0% 4.0% 0.0% 0.0% I
ESTIMATED MONTHLY SHARE - FY 15 929.57 2,205.16 1 526.54 1,383.95 290.94 17.33 58.91
ESTIMATED ANNUAL EXPENSE 780,835 1,508,328 1,055,183 5,164,911 1571,076 80,457 387,359 624,189 60,120 29,328 11261,785
1
ESTIMATED COMBINED EXPENSE ' 2,289,162 1 6,220,093 1,571,076 10,080,332 ,1 467,817 624,189 60,120 29,328 11,261,785
- from 15 retirees assumed married so 30 new Medex plans
INSINFO.xlsx fy 15 estimate 1/17/2014Source page 30
Murgia, James R.
From: Sue Shillue <SShillue@cookandcompany.com>
Sent: Friday, January 17, 2014 6:23 AM
To: Murgia, James R.
Subject: RE: Fy 15 Health Insurance Budget
Hi Jim - I have reviewed the plans based on their own costs, and have rated them accordingly. If you rated each plan
based strictly on it's own claims experience, I would recommend the following increases:
Blue Care Elect 30%
HMO Blue 1%
Medex 4%
Because the Blue Care Elect plan has a smaller population, it certainly is more unpredictable and could have wider swings
in the variance between costs and funding.
Please let me know if you have questions on this or want the rates worked another way. It's still early to set actual rates,
so if you want to use the 9% for your budgeting increase, and then we can finalize the actual rates per plan once we
have more experience, that is another option. Thanks. Sue
1Source page 31
HEALTH CLAIMS TRUST FUND
FY 2014
Description As of 12/31/13 FY 2013 FY 2012 FY 2011 FY 2010
HMO BLUE Employee Share 1,007,133.18 1,971,256.19 2,121,765.08 1,786,552.52 1,641,670.54
HMO BLUE Town Share 3,096,712.02 5,814,5 3.81 5,979 037.54 5,497,883.47 4,862,760.47
HMO BLUE Stop Loss Refunds 335,983.35 508,224.40 79,019.36 867 700.92 243,652 33
HMO BLUE Total Revenue •4,439,828.55 8,293,994,40 I8,179,821 98 8,152,136.91 6,748,083.34
PPO Employee Share 276 372.73 594,118.11 655,675,40 607,932.17 610,778.27
PPO Town Share 906,603.47 1,764,099.89 1,758,926.77 1,880,505.73 1,811 452.09
PPO Stop Loss Refunds 177,727.12 134,943.99 125,190.00 367,201.60 19,679.54
PPO Total Revenue 1,360,703.32 2,493,161.99 2,539,792.17 2,855,639.50 2,44 909.90
Medex Employee Share 201,845.45 453,162.93 500,610.88 414,545.11 434,737.34
Medex Town Share 733,638.55 1,332,761.07 1,359,356.71 1,379,762.26 1,297,557.60
Medex Total Revenue 935,484.00 1,785,924.00 1,859,967.59 1,794,307.37 1,732,294.94
Interest earned 23.49 4,520.42 6,185.19 7,084.72 10,628.00
Total Revenue 6,736,039.36 12,577,600.81 12,585,766.93 12,809,168.50 10,932,916.18
HMO Blue Claims Paid 3,833,642.17 8,761,463.25 7,280,070.19 7,570,448.58 7,425,424.79
HMO Blue Admin & Other Costs 462,294.37 797,719.90 802,458,17 976,059.58 620;831.26
HMO Blue Total Expenditures 4,295,936.54 9,559,183.15 8,082,528.36 8,546,508.16 8,046,1256.05
PPO Claims Paid 1,452,774.35 2,113,863.25 2,265,804.64 2,308,321.94 ' 2,021,209.25
PPO Admin & Other Costs 114,504.77 210,410.06 203,596.68 284,538.78 182,242.69
PPO Total Expenditures 1,567,279.12 2,324,273.31 2,469,401.32 2,592,860.72 2,203,451.94
Medex Claims Paid 859,435.38 .1,537,931.25 1,641,962,97 1,506,486.96 1,229,776.77
Medex Admin & Other Costs 60,334.56 115,727.82 96,664.82 171,192.42 97,450.26
Medex Total Expenditures 919,769.94 1,653,659.07 1,738,627.79 1,677,679.38 1,327,227.03
Miscellaneous Charges 7,575.00 10,100.00 9,646.39 12,900.00 8,416.75
IBNR Adjustments 0.00 208,928.00 140,000.00) (463,000.00 110,000.00
Total Expenditures 6,790,560.60 13,756,143.53 12,160,203.86 12,366,948.26 11 695,351 77
Surplus/(Deficit) (54,521.24) (1,178,542.72) 425,563.07 442,220.24 (762,435.59)
Claims Trust Fund Balance at Beginning of Year 2,523,126.17 3,701,668.89 2,282,104.14 1,006,085.58 1,763,521. 7
Working Deposits used to fund claims 0.00 0.00 994,00 .68 833,798.32 0.00
Claims Trust Fund Balance at End of Year 2,468,604.93 2,523,126.17 3,701,668.89 2,282,104.14 1,006,085.58
INSINFO.xlsx health claims trust fund 1/13/2014