Canton, Massachusetts · Saved source text
FY14 Enterprise Fund Budget Requests
Saved text from 14 source pages. Transcription and OCR may contain errors; verify figures and wording against the original. Retrieved 2026-10-15.
Source page 1
TOWN OF CANTON FY 11
UM
• FY 12 ACTUAL YTD -- -
r -r
ORIGINAL --,
I
-
FY 2014
L FY 2014
COMMENT/REASON FOR
FY 10 - MN INCREASE/DECREASE
BUDGET REPORT FOR FY 2014 1-- ACTUAL
ACTUAL . ACTUAL • EXPENSE TEIRU _ BUDGET ', DEPARTMENTAL DEPT
EXPENSE EXPENSE 10/31/2012 FY 13 - BASE BUDGET REQUEST
DEPARTMENTAL WORKSHEETS EXPENSE
--,-- 7
.1 =I= ........
..
=....vfi...r.... .
600 I SEWER ENTERPRISE
1 1± _L A■ ._
IIIIII I Mill
56000 - 51120 SUPERVISOR SALARY • 73 325 102 905 'Ma 72,690 23,168 111,670 IT•ii 112,105 112,105
56000- 51122 SEPTAGE SALARY 49,039 50,378 III1 50,149 15,430 50,149 • 50,342 50,342
56000- 51123 LABORERS SALARY 65,702 65,279 ii 166,310 51,592 164,909 EN 170,260 170,260
56000- 51135' 'JUNIOR ENGINEER SALARY 33,448 1 33,527 IIIII 34,068 10,608 33,799 Ei 1 35,299 35,299
56000- 51142 ACCOUNTING CLERK 0 I 15,827 MI 0 M 0 19,901 111 II 20,781 20,781
56000- 51143 OFFICE ADMINISTRATOR SAL. 0 I 10,831 mu 55,274 • 17,331 29,853 NMI 31,761 31,761
56000- 51162 POLICE DETAIL SALARIES 0 1111111 2,568 1,596 111 0 4,000 111 1 4,000 4,000
56000- 51300 IOVERTIME SALARY 32.345 ME 35,184 29,765 111 8,045 26,500 MIMI 26,500 26,500
56000- 51400 I LONGEVITY U 6,7401 111 9,075 5,400 •• 1,000 4,750 MINI 5.940 5,940
56000- 51530 GOOD ATTENDANCE - AFSCME U 1
1,418 ENE 2.434 , 0 ii 1,217 2,000 MI. 2,000 111 2,000
56000- 519501 CONTRACT PROVISION
■ ■ 0 !!
.1■
1 0 • 11 0 0 0_•. 15,564 15,564
SUBTOTAL 5 361017 I $428 009 ril $415 52 UI $441,531 ii $474 552 474.552
'SALARIES MBE U Ell III IIIIII
1 MINN IIMEM M■
56000- 52000 -'PURCHASE OF SERVICES 11,313 2.888 IIII1 13,619 19,079 0 •U 0 0
56000- 52102 HEATING FUEL 860 1,438 • III 1,389 286 0 MIMI 0 0
56000- 52104 LIGHTS & POWER 9,747 7,546 • 9,162 1,682 18.000 mug 18,000 18,000
56000- 52301 WATER/SEWER PURCH MILTON/STO U 114,7371 209,809 • in 240,605 52,255 203,000 I I 203,000 203,000
56000- 52410 REPAIR/MAINT MOTOR VEHIC U 1961 0 =II 727 0 0 1•111 0 0
56000- 52419 REPAIR/MAINT PUMPING STA 7,055 5.366 EN 8,832 I 2,528 12,000 • I 12,000 12,000
56000- 52425 REPAIR/MAINT EQUIPMENT 9,916 6,160 IIII 5,989 1.129 1,200 II 1,200 1,200
56000- 52427 REPAIR/MAINT SEWERS 381 11,591 • IMI 1,074 0 7,500 7,500 7,500
56000- 52704 UNIFORM RENTAL • 984 830 •111 1,243 363 4,500 II II 4,500 4,500
56000- 5310R PHYSICAL FITNESS PROGRAM U 01 0 11111111 0 0 150 NMI 150 150
56000- 53128 PHYSICAL FITNESS PROGRAM U 0 0 II 0 0 200 1111111111 200 200
56000- 53400 TELEPHONE U 1181 5 INN 163 8 1,000 NMI 1,000 1,000
56000- 53406 1_COMMUNICATIONS - OTHER 229 391 MI 249 89 500 •.111 500 500
.__ 56000 - 53408 I POSTAGE 6 1 85 MIN 0 0 0 111111111 0 0
56000 - 54000 ISUPPLIES 747 492 IM 470 0 500 •111.1 500 SOO
56000 -, 54011 TOOLS & HARDWARE 22,128 ir 46,378 NM 42,717 7,387 6,000 II 6,000 6,000
56000 - 54033 WORK SHOES 417 450 IIM 415 60 500 II 500 500
' 56000- 54041 FOUL WEATHER GEAR 0 0 mil 0 0 300 II 300 300
_L56000 - 54200 ' OFFICE SUPPLIES 842 299 • 1111111 0 0 0 II 0 0
- 56000 -,--54801 GASOLINE & OIL 4, 22 5,028 1111 8,330 1,677 6,500 6,500 6,500
56000 - 54806 I DIESEL FUEL
1- • 3,747 4,598 m 6,984 1,997 1,000 EMI 1,000 1,000
56000- 54901 1MEALS 90 L, 20 0 0 00 MIMI 100 100
56000- 55301 1-MATERIALS & SUPPLIES o 192 111 131 0 500 OEM 500 500
56000- 55306 ' BITUMINOUS MATERIALS • 0 -' 0 111 0 0 1,000 Mil 1,000 1,000
56000 - 5530B 1 CASTINGS 0 0 11 0 0 5,000 5,000 t- 5,000
----I
56000- 5580E WORK SHOES 150 ' 291 III 0 I i
0 - 0 NMI 0- 0
56000- 57800 CONTINGENCIES 5,621 1 ' 149 NI 18,265 ' 428 35,449 35,449 , 35,449
56000 - 57802 HEAVY EQUIPMENT LICENSES 135 _L , 60 III 60 ' 0 100 100 100
,
56000- 57821 SEPTAGE SITE 11,602 15,250 21,850 ' 4,099_E 14_ 16,000 16,000 16,000
,- 56000- 58000 LA
CAP. OUTLAY-CONSTRUCTION
56000- 58702 SEWER-CLEANING & SEALING
4,332
0
0
0 I _I ,-
0
0
0
-1 ,[ d- 10,000 10.000 + 10,000
1I
0 2,000 2,000 2,000
-, i I-1 +
3,240,704 -T ,,_50,840 1,325,237 4 1 3,343,366 3.343,366 3,343,366
56000- 58937 MWRA CHARGES
56000- 59610 TRANSFER
, TO GENERAL FUND
3,256,556
346,085 360,181
1
373,811 129,427 ir 388,281 394,399 i 394,399
SUBTOTAL ' S 3,812,730 , $3,920,210 1 1 SA006,925
1 -t-
$1,547,730 $4,064,646 1 $4 070,764 4.070.764
. 1
, EXPENSES - IL 11 ,
SUBTOTAL SEWER ENTERPRISE $ 4,174,747 ' 54,348,219 -4- -'m 54,422,178 1 ' 51,676,120 -
_
$4,512,177 I ! r $4,545,316 4S45 316
, ■
1-
M. Trotta 1-8-13
-Source page 2
TOWN OF CANTON ACTUAL YTD FY 2014 FY 2014 COMMENT/REASON FOR
FY 10 FY 11 FY 12 ORIGINAL
BUDGET REPORT FOR FY 2014 ACTUAL ACTUAL ACTUAL EXPENSE THRU BUDGET DEPARTMENTAL DEPT INCREASE / DECREASE
EXPENSE EXPENSE 10/31/2012 FY 13 BASE BUDGET REQUEST
DEPARTMENTAL WORKSHEETS EXPENSE
56002- 59101 SEWER PRINC PD-05/11 DEBT 0 0 79,000 0 77,000 77,000 "7 -000
56002- 59109 PRINCIPAL PAID TO MWRA 40,040 40,040 0 0 0 0
56002- 59121 PRINC PD-12/01 DEBT 75,000 . 75,000 0 0 0. 0
56002- 59126 PRINCIPAL PAID TO MWPAT 0 0 153,851 156,959 156,959 156,959
56002 - 59127 PRINC PD-01/06 DEBT 55,000 55,000 54,000 0 53,000 53,000
56002- 59128 PRINC PD-01/08 DEBT 7,000 5,000 5,000 0 5,000 5,000
.„.,.. 56002- 59130 PRINCIPAL PAYDOWNS 65,000 50,000 50,000 0 150,000 150,000
r- 56002 - 59138 PRINC PD - 05/09 DEBT 28,000 28,000 27,000 0 27,000 27,000
56002- 59140 PRINC PAID - 12/99 DEBT 250,755 0 0 0 0 0
56002- 59141 PRINC PD-03/04 DEBT 20,000
r
267,520 258,645 0 252,055 252,055
56002- 59150 SEWER INTEREST PD 05/11 0 0 21,510 0 19,930 19,930 /R- 3
56002- 59160 INTEREST PD TO MWPAT 0 66,632 78,879 38,612 70,267 70,267 •-? t?
56002- 59171 INT PD-12/01 DEBT 41,100 38,100 0 0 0 0
56002- 59175 INT PD-01/06 DEBT 33,917 31,855 29,792 13,884 27,767 27,767
as-7 E 0
56002- 59176 INT PD-01/08 DEBT 3,195 2,950 2,775 1,300 2,600 2,600
56002- 59178 INT PD - 05/09 DEBT 7,085 6,245 5,405 0 4,865 4,865 e-re g 5'
56002- 59181 INT PD - 3/12 DEBT 0 0 0 27,067 0 0 SG-,00
56002- 59190 INT PAID - 12/99 DEBT 85,987 0 0 0 0 0
56002- 59191 INT PD-03/04 DEBT 11,246 86,620 78,120 4,711 69,556 69,556
0 (6z4- /
56002 - 59250 INTEREST TEMPORARY LOANS 2,680 2,244 1,492 0 60,000 60,000
SUBTOTAL EXPENSES S 726,006 $755,205 $845,468 $242,532 $975,999 $975,999
SUBTOTAL SEWER PRINC/INT PAYMENTS S 726,006 $755,205 $845,468 $242,532 $975,999 $975,999
i
st- d Signature/Date
:1;'(1
f.
Date: 12/6/2012 W:\Munis\MCR Library\Budget reports\New Fiscal Year budget worksheet -Dept Req 3 yr-enterprise by sal-exp.rpt Page: 3Source page 3
LONG TERM DEBT SERVICE AMOUNTS FY 13 THRU FY 21
Date of Inside or Debt Service Type of
Issue Type Outside Description Org Object Payment 2014
5/1/2011 S Inside GOB Sewer REFUNDING (Self-Supporting) 56002 59101 Principal 75,000.00
59101 Total 75,000.00
7/8/2010 S Outside WPT Sewer CWS-07-38 (Self-Supporting) 56002 59126 Principal 160,130.00
59126 Total 160,130.00
1/15/2006 S Inside GOB Sewer (Self-Supporting) 56002 59127 Principal 11,000.00
1/15/2006 S Inside GOB Sewer (Self-Supporting) 56002 59127 Principal 12,000.00
1/15/2006 , S Outside GOB Sewer (Self-Supporting) 56002 59127 Principal 30,000.00
59127 Total 53,000.00
1/15/2008 S Outside GOB Sewer (Self-Supporting) 56002 59128 Principal 5,000.00
59128 Total 5,000.00
3/27/2012 S Sewer GOB Sewer (Self-Supporting) 56002 59131 Principal 100,000.00
59131 Total 100,000.00
5/15/2009 S Inside GOB Departmental Equipment-Sewer (Self-Supporting) 56002 59138 Principal 26,000.00
59138 Total 26,000.00
3/15/2004 S Outside GOB Sewer (Self-Supporting) 56002 59141 Principal 20,000.00
3/15/2004 S Inside GOB Sewer REFUNDING (Self-Supporting) 56002 59141 Principal 27,035.00
3/15/2004 S Inside GOB Sewer REFUNDING (Self-Supporting) 56002 59141 Principal 4,325.00
3/15/2004 S Inside GOB Sewer REFUNDING (Self-Supporting) 56002 59141 Principal 42,170.00
3/15/2004 S Inside GOB Sewer REFUNDING (Self-Supporting) 56002 59141 Principal 50,820.00
3/15/2004 S Inside GOB Sewer REFUNDING (Self-Supporting) 56002 59141 Principal 105,965.00
59141 Total 250,315.00
5/1/2011 S Inside GOB Sewer REFUNDING (Self-Supporting) 56002 59150 Interest 18,390.00
59150 Total 18,390.00
7/8/2010 S Outside WPT Sewer CWS-07-38 (Self-Supporting) 56002 59160 Interest 72,128.63
59160 Total 72,128.63
1/15/2006 S Inside GOB Sewer (Self-Supporting) 56002 59175 Interest 5,541.25
1/15/2006 S Inside GOB Sewer (Self-Supporting) 56002 59175 Interest 5,378.50
1/15/2006 S Outside GOB Sewer (Self-Supporting) 56002 59175 Interest 14,859.75
59175 Total 25,779.50
1/15/2008 S Outside GOB Sewer (Self-Supporting) 56002 59176 Interest 2,425.00
59176 Total 2,425.00
5/15/2009 S Inside GOB Departmental Equipment-Sewer (Self-Supporting) 56002 59178 Interest 4,325.00
59178 Total 4,325.00
3/27/2012 S Sewer GOB Sewer (Self-Supporting) 56002 59181 Interest 56,000.00
59181 Total 56,000.00
3/15/2004 S Outside GOB Sewer (Self-Supporting) 56002 59191 Interest 8,721.25
3/15/2004 S Inside GOB Sewer REFUNDING (Self-Supporting) 56002 59191 Interest 6,204.49
3/15/2004 S Inside GOB Sewer REFUNDING (Self-Supporting) 56002 59191 Interest 913.53
3/15/2004 S Inside GOB Sewer REFUNDING (Self-Supporting) 56002 59191 Interest 9,524.67
3/15/2004 S Inside GOB Sewer REFUNDING (Self-Supporting) 56002 59191 Interest 12,225.89
3/15/2004 S Inside GOB Sewer REFUNDING (Self-Supporting) 56002 59191 Interest 23,174.91
59191 Total 60,764.74
Grand Total 909,257.87
AUTHDEBT.xlsx 1 11/28/2012Source page 4
DEBT SERVICE PROJECTIONS - DEBT IN PIPELINE
AUTHORIZED AUTHORIZED TERM BOND BAN BOND FY
DATE ART # PURPOSE UNISSUED (YRS) DATE RATE RATE INT PRIN 2014
5/1/2000 15-12 SEWER I & I / PUMPING STATION 1,586,290 20 Mar-14 1.50% 3.75% 5 0 5
4/24/2006 12-10 WATER RESOURCE MGMT PLAN 50,000 5 N/A 1.50% N/A 0 0
4/30/2007 15-9 GREEN LODGE 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 295,000 10 Mar-13 1.50% 3.50% 5 15 20
TOTAL SEWER 3,185,595 10 15 25
AUTHDEBT.xlsx PIPELINE 1/15/2013Source page 5
,
TOWN OF AI\oji 1 I FY 11 FY 12 ACTUAL YTD ORIGINAL 1-- FY 21114 FY 2014
r COMMENT/REASON FOR
FY 10 ___i INCREASE / DECREASE
BUDGET REPORT FOR FY 2014 --IF- ACTUAL
ACTUAL ACTUAL EXPENSE THRU BUDGET - DEPARTMENTAL DEPT
I - EXPENSE EXPENSE 10/31/2012 FY 13 BASE BUDGET REQUEST
DEPARTMENTAL WORKSHEETS ' EXPENSE
1____J_J 1 i
640 1WATER ENTERPRISE , 1
-1- "- -I ■
56100- 51120 SUPERVISOR SALARY 79,339 1.1.. 13,920 m th. MINN
70.651 22,387 ITI 36.374 IT 36.519 36,519
56100- 51123 LABORERS SALARY 505,921 500,134 1111 506,497 153,579 1 508,576 =11 515.334 515,334
56100- 51135 JUNIOR ENGINEER SALARY 21,758 23,269 22.619 7,072 22,533 mom 23,533 23,533
IN Ill 111
•
38,570 12,123 19,901 20,781 20,781
••I
56100- 51142 ACCOUNT COORDINATOR W/S U 46,716 22,753
56100- 51143 OFFICE ADMINISTRATOR W/S 61,7011=1 48,914 EN 217 0 29 853 mum 31 76 31,761
56100- 51162 POLICE DETAIL SALARIES 14,693 11111 17,555 MI 15,226 5,513 6,500 II 6,500 6,500
56100- 51210 SUMMER HELP SALARY
56100- 51300 'OVERTIME SALARY
0111
92,450 1 11 124359
MEE
0
•
740
167,980
3,022
46,670 111
6,000
111,000
•
•
6,000 •
111,000
6,000
111,000
56100- 51400 LONGEVITY 11,735 1UN 11.037 MA 10,100 1,900 III 1 3,350 8,610 8,610
56100- 51530 GOOD ATTENDANCE - AFSCME 1.632 1 4,506 UN 0 3,714 2,000 2,000 2,000
56100- 51950 CONTRACT PROVISION
...
0 0 1 U 0 o
.........
o I 24,418 24,418
SUBTOTAL $ 835,945 $766 447 111 $832 600 $255 980 i $156‘,08_7 MIMI $786,4_56 786.456 '
1
1
1 1 SALARIES
I
I
1
_J
Immo
NMI ,I. II■
111=
EMI
=NEM=
56100- 52102 HEATING FUEL
56100- 52104 LIGHTS & POWER
L 6,920 1 IM1
64,849 •
•li 9,025
105,440 • 111
15,931
162,800 t.
1,228
48,245
I 6,000 • 6.000
307,473 307,47'
6,000
157,473 (150,000) Balance Line Item
56100- 52105 BLDG.MAINT. & SUPPLIES 1-- 4,730 5,709 4.687 446 I 5,000 5,000 5,000
56100- 52301 WATER/SEWER PURCH MILTON/STOL 1 15,026 184,639 NMI 156,417 24,396 I 42,000 MIMI 42,000 42,000
56100- 52410 REPAIR/MAINT MOTOR VEHIC 14,063 1 15,905 21,867 2,335 3,000 1111 3,000 3,000
56100- 52420 BUILDING MAINT&SUPPLIES 1,338 •mm 947 U 9,566 1,341 • 1,500 • 1,500 1,500
56100- 52422 REPAIR/MAINT - WELLS 1,474 • imi 7,354 U 16,478 16,919 • 12000 12,000 12,000
56100- 52425 REPAIR/MAINT EQUIPMENT 5,563 13,449 22,204 10,719 25,000 iri 25,000 25,000
56100- 52427 REPAIR/MAINT SEWERS 0 0 0 0 1 4,872 I I 4,872 4,872
56100- 52703 RENTAL OF EQUIPMENT 0 2,662 UN 873 0 • 1,000 1 I 1,000 1,000
56100- 52704 UNIFORM RENTAL 2,327 2,299 2,523 728 I 4,000 111111 4,000 4,000
56100- 53108 PRINTING & BINDING 670 51 68 1 0 II 1,500 • II 1,500 1,500
56100- 5310T PROF.SERV. WATER TESTING 24,033 11,420 17,994 5,559 I 20,000 • 20,000 17,000 (3,000) Balance Line Item
56100- 5310U PROF.SERV. MEDICAL EXAMS 0 218 0 0 I 100 100 100
56100- 53110 PHYSICAL FITNESS AFSCME 150 0 0 0 250 250 250
4 -I -4--
56100- 53400 TELEPHONE 1 r, 25' 377 22,528 24,243 7,114 15,000 mil 15,000 15,000
56100- 53406 COMMUNICATIONS - OTHER 1,034 1,104 j 2.530 1.241 I o 0 0
56100- 53408 POSTAGE 11,466 15,827 12.226 5,027 I 2,000 MI 12,000 12,000
56100- 5340D ADVERTISING 0 1,464 486 0 1 600 I 600 600
56100- 53411 WELL MONITORING SYSTEM (SCADA) ' 10,500 15,908 f 17,019 1 0 1 7,500 1.1111 7,500 7,500
56100 - 54011 TOOLS & HARDWARE 1 T
, 9,940 8,533 29,066
1
1 7,836 1 I 200 1,200 1,200
56100- 54122 DIESEL FUEL , 1 0 0 0 0 I 1 4.000 14,000 14,000
56100- 54200 OFFICE SUPPLIES 3,221 5,694 6,327 1,549 4,500 4,500 4,500
56100- 54801 GASOLINE & OIL 11,901 16,376 21,965 5,322 9,000 9,000 9,000
56100 4 5 4806 DIESEL FUEL 14,973 18,928 1 19,976 6,198 0 0 0
56100- 54901 MEALS 2,120 2,420 T 2,600 0 500 500 SOO
-r
56100- 55303 TRENCH MATERIALS 1, ,479 16,543 1 1 ''-- 5,076 424 8,000 8,000 8,000
--r! !
56100- 55304 CHEMICALS , 16,642 , ,
1
97,081 4_ 45,593 20,395 20,395 460,000 439,605 Need for treatment
56100- 55305L METERS & PARTS 83,2934 84.463 , 1 79,102 20,949 80,000 80,000 40,000 (40,000) Balance Line Item
, 20,000 20,000 15,000 (5,000) Balance Line Item
56100- 55306 BITUMINOUS MATERIALS 5 476 , 1----f 13.638 17,335 4,690
t ' r-1 r r I
56100- 55308 PIPES & FITTINGS 28,291 , 15,058 j-.
16.004 4,050 30,000 30,000 7 17,000 (13,000) Balance Line Item
I
56100- 55309 HYDRANTS & VALVES 19,396 1 18,791 4,430 ' 169 _1 18,000 r 18,000 18,000
i 56100- 5580C DATA PROCESSING SUPPLIES 0 0 0 0 1,000 1,000 1,000
.4-- --,-
56100- 5580E WORK SHOES 1.314 ' 1,442 1,507 450 1,200 1,200 1,200
i 7
56100- 5580R- FOUL WEATHER GEAR 6327 1,701 1 516 01 -- 1,500 1,500 ' 1,500
-r-
56100- 56000 TAXES-TOWN OF STOUGHTON 1 33/1
,_ 3,331 3,331 5,500 -1 --I 5,500 5,500
1 6,067 1
t
833
1
_j 20,281 -11- 445 525 525 525
56100- 57000 _,OTHER CHARGES/EXPENDITURE 1-- , 1- r
56100- 5710C MEETINGS ' , 1,007 2,510 830 770 t - 1,200 1 ,-- 1,200 _I 1,200
° 1
56100 - 57300 DUES & MEMBERSHIPS 1,283 1,600 1 1,002 338 750 750 L jr j 750
-
56100 -1 57800 CONTINGENCIES 59,841 31,989 L 27,465 , 428 65,000 1 65,000 1 40,000 (25,000) Balance Line Item
1 1"
50100- 57802 HEAVY EQUIPMENT LICENSES 580 325 1 1,293 , 160 800 1- 800 800
4'
56100- 57807 WELL #9 OPERATING COSTS 01 0 0 0 10,000 , 10,000 , 10,000 -,
1 rr-
56100- 57819 PIPELINE ASSISTANCE PROGRAM 0' o 0 o -,-,
20,335 -)0,335 1 20,335 -1--
-,
56100- 57840 ' US GEOLOGICAL SURVEY EXPENSE , 17,060 17,060 17,060 4,265 19,000 1 19,000 1I r-
, 19,000
, ,
56100- 58418 SECURITY SYSTEM 1,707 0 0 0 , 0 01 0
-
56100 -' 58936 DEP ASSESSMENT CHARGES 7,799 7,568 6,960 0 8,000 , 8,000 8,000Source page 6
' 1
1
1
TOWN OF CANTON I FY11 FYI — ACTUAL YTD - ORIGINAL ,- FY 2014 FY 2014
COMMENT/REASON FOR
BUDGET REPORT FOR FY 2014
FY 10
ACTUAL 7
,H ACTUAL ,.__, EXPENSE THRU — BUDGET 'H.,
-- DEPARTMENTAL DEPT
INCREASE/DECREASE
ACTUAL EXPENSE i_.-
'-' EXPENSE 10/31/2012 FY 13 –I BASE BUDGET REQUEST
DEPARTMENTAL WORKSHEETS EXPENSE
omm m■ ,.■■ ........■
56100- 589371 MWRA CHARGES 2,329,408 2,250,339 2,234,586 855,396 II 2,141.574 2.141,574 2,141,574
56100- 58986 SANDBLAST & PAINT/TANKS 1,8001 0 . 0 0 i 1 5,000 5,000 5,000
56100 58987 CROSS CONNECTION PROGRAM 7.4741 813 En 0 0 I 25,000 25,000 25,000
56100 59601 TRANSFER TO SPECIAL REV FUND • 36,200 36,200 =III 36,200 36,200 • 36,200 36,200 36,200
56100- 59610 TRANSFER TO GENERAL FUND • 638,471 II 668,728 I 716,685 248,266 744,799 1 756,170 • 756,170
56 03 - 52000 VVTR CONSERV GRANT EXP 0 0 10,151 6,624 0 0 0
I SUBTOTAL =WM $3 673,451 M $3 906 973 $1 400 755 $3,761,773 .773,144 3.976.749
.....■
.....
•
MMII M=MI IM= ' •
1111111111111111111 EXPENSES
.
IMMO
11.1
MINN
..
mu
NM I= =MN MN
$ 4,462,483 I I $4,439,898 - S4,739,573 $1,656,735 $4,517,860
•
SUBTOTAL WATER ENTERPRISE $4,559,600 4,763,205
.1=1. ...... wi•■
•..=..... MN
1 1 1
In I I
M. Trotta 1-9-13
ISource page 7
TOWN OF CANTON ACTUAL YTD FY 2014 FY 2014 COMMENT/REASON FOR
FY 10 FY 11 FY 12 ORIGINAL
BUDGET REPORT FOR FY 2014 ACTUAL ACTUAL ACTUAL EXPENSE THRU BUDGET DEPARTMENTAL DEPT INCREASE / DECREASE
EXPENSE 10/31/2012 BASE BUDGET REQUEST
DEPARTMENTAL WORKSHEETS EXPENSE EXPENSE FY 13
56102- 59101 WATER PRINC P0-05/11 DEBT 0 0 270,000 0 269,000 269,000
56102- 59109 PRINCIPAL PAID TO MWRA 0 0 41,000 41,000 91,000 91,000
56102- 59127 PRINC PD-01/06 DEBT 54,000 54,000 53,000 0 53,000 53,000
56102- 59128 PRINC PD-01/08 DEBT 127,000 126,000 126,000 0 126,000 126,000 2.CDC.)C I
56102- 59130 PRINCIPAL PAYDOWNS 72,800 62,800 0 0 190,000 190,000
9 3 04-z Q
6102- 59137 PRINC PD - 05/10 DEBT 0 248,568 248,000 0 248,000
-çt )
248,000
56102- 59138 PRINC PD - 05/09 DEBT 302,333 298,000 228,000 0 162,000 162,000
q"..e) (Th
56102- 59140 PRINC PAID - 12/99 DEBT 35,495 0 0 0 0 0
56102- 59141 PRINC PD-03/04 DEBT 70,000 103,600 /
103,135 0 102,675 102,675
56102- 59142 PRINC PD-03/08 DEBT 54,000 52,000 52,000 0 50,000 50,000
<7)00 0 cj
56102- 59150 WATER INTEREST PD 05/11 0 0 175,529 0 170,129 170,129 64--7 4-C9 '
56102- 59175 INT PD-01/06 DEBT 34,638 32,613 30,588 14,300 28,600 28,600 / V/
56102- 59176 INT PD-01/08 DEBT 53,001 48,556 44,146 19,868 39,736 39,736
56102- 59178 INT PD - 05/09 DEBT 79,163 70,093 61,153 0 56,593 56,593
56102- 59179 INT PD - 05/10 DEBT 0 142,480 137,509 0 132,549 132,549 A-F-9 \
56102- 59181 INT PD - 3/12 DEBT 0 0 0 51,427 0 0
56102- 59190 INT PAID - 12/99 DEBT 12,174 0 0 0 0 0
56102- 59191 INT PD-03/04 DEBT 42,820 51,500 48,315 18,216 45,018 45,018
(42
56102- 59192 INT PD-03/08 DEBT 14,755 12,865 11,045 0 9,225 9,225
-7 44-7 ,
56102- 59250 INTEREST TEMPORARY LOANS 42,826 83,210 7,458 0 155,000 155,000
SUBTOTAL EXPENSES 995,004 $1,386,284 $1,636,877 $144,811 $1,928,525 $1,928,525
SUBTOTAL WATER PRINC/INT PAYMENTS 995,004 $1,386,284 $1,636,877 $144,811 4,928,525 $1,928,525 21 46:17 P.--
ead Signature / Date
cçc
*7:2, 1 i3Q.
Date: 12/6/2012 W:\Munis\MCR Library\Budget reports\New Fiscal Year budget worksheet -Dept Req 3 yr-enterprise by sal-exp.rpt Page: 7Source page 8
I ONG TFRM DFRT SFRVICF AMOUNTS FY 13 THRU FY 21
Date of Inside or Debt Service Type of
Issue Type Outside Description Org Object Payment 2014
5/1/2011 W Inside GOB Engineering Services - Water (Self-Supporting) 56102 59101 Principal 14,000.00
5/1/2011 W Outside GOB Water Treatment Facility (Self-Supporting) 56102 59101 Principal 250,000.00
5/1/2011 W Outside GOB Water Mains (Self-Supporting) 56102 59101 Principal 5,000.00
59101 Total 269,000.00
11/15/2010 W Outside WRA Water (Self-Supporting) 56102 59109 Principal 41,000.00
5/15/2012 - W Outside WRA Water (Self-Supporting) 56102 59109 Principal 50,000.00
59109 Total 91,000.00
1/15/2006 W Outside GOB Water Mains (Self-Supporting) 56102 59127 Principal 17,000.00
1/15/2006 W Outside GOB Water Mains (Self-Supporting) 56102 59127 Principal 36,000.00
59127 Total 53,000.00
1/15/2008 W Outside GOB Water Mains (Self-Supporting) 56102 59128 Principal 57,000.00
1/15/2008 W Outside GOB Water Departmental Equipment (Self-Supporting) 56102 59128 Principal 25,000.00
1/15/2008 W Outside GOB Water Departmental Equipment (Self-Supporting) 56102 59128 Principal 44,000.00
59128 Total 126,000.00
3/27/2012 W Water GOB Water Treatment Facility (Self-Supporting) 56102 59131 Principal 190,000.00
59131 Total 190,000.00
5/15/2010 W Inside GOB Departmental Equipment - Public Works (Self-Supporting) 56102 59137 Principal 27,000.00
5/15/2010 W Outside GOB Water (Self-Supporting) 56102 59137 Principal 16,000.00
5/15/2010 W Outside GOB Water Treatment Facility (Self-Supporting) 56102 59137 Principal 110,000.00
5/15/2010 W Outside GOB Water Mains (Self-Supporting) 56102 59137 Principal 55,000.00
5/15/2010 W Outside GOB Water Mains (Self-Supporting) 56102 59137 Principal 40,000.00
59137 Total 248,000.00
5/15/2009 Inside GOB Engineering Services - Water (Self-Supporting) 56102 59138 Principal 0.00
5/15/2009 Outside GOB Water Mains (Self-Supporting) 56102 59138 Principal 75,000.00
5/15/2009 Outside GOB Water Mains (Self-Supporting) 56102 59138 Principal 20,000.00
59138 Total 95,000.00
3/15/2004 Outside GOB Well (Self-Supporting) 56102 59141 Principal 30,000.00
3/15/2004 Outside GOB Well (Self-Supporting) 56102 59141 Principal 20,000.00
3/15/2004 Outside GOB Well (Self-Supporting) 56102 59141 Principal 20,000.00
3/15/2004 Outside GOB Water REFUNDING (Self-Supporting) 56102 59141 Principal 4,325.00
3/15/2004 Outside GOB Pumping Station REFUNDING (Self-Supporting) 56102 59141 Principal 18,380.00
3/15/2004 Outside GOB Well REFUNDING (Self-Supporting) 56102 59141 Principal 9,735.00
59141 Total 102,440.00
3/15/2008 W Outside GOB Water REFUNDING (Self-Supporting) 56102 59142 Principal 25,000.00
3/15/2008 W Outside GOB Well Field Development REFUNDING (Self-Supporting) 56102 59142 Principal 25,000.00
59142 Total 50,000.00
5/1/2011 W Inside GOB Engineering Services - Water (Self-Supporting) 56102 59150 Interest 1,230.00
AUTHDEBT.xlsx 1 11/28/2012Source page 9
I ONG TFRM DFBT SFRVICF AMOUNTS FY 13 THRU FY 21
Date of Inside or Debt Service Type of
Issue Type Outside Description Org Object Payment 2014
5/1/2011 W Outside GOB Water Treatment Facility (Self-Supporting) 56102 59150 Interest 160,312.50
5/1/2011 W Outside GOB Water Mains (Self-Supporting) 56102 59150 Interest 3,206.25
59150 Total 164,748.75
1/15/2006 W Outside GOB Water Mains (Self-Supporting) 56102 59175 Interest 8,563.75
1/15/2006 W 1 Outside GOB Water Mains (Self-Supporting) 56102 59175 Interest 18,049.00
59175 Total 26,612.75
1/15/2008 W Outside GOB Water Mains (Self-Supporting) 56102 59176 Interest 26,646.00
1/15/2008 W Outside GOB Water Departmental Equipment (Self-Supporting) 56102 59176 Interest 2,625.00
1/15/2008 W Outside GOB Water Departmental Equipment (Self-Supporting) 56102 59176 Interest 6,055.00
59176 Total 35,326.00
5/15/2009 VV Inside GOB Engineering Services - Water (Self-Supporting) 56102 59178 Interest 0.00
5/15/2009 VV Outside GOB Water Mains (Self-Supporting) 56102 59178 Interest 42,102.50
5/15/2009 VV Outside GOB Water Mains (Self-Supporting) 56102 59178 Interest 11,250.00
59178 Total 53,352.50
5/15/2010 W Inside GOB Departmental Equipment - Public Works (Self-Supporting) 56102 59179 Interest 5,182.50
5/15/2010 W Outside GOB Water (Self-Supporting) 56102 59179 Interest 8,528.75
5/15/2010 W Outside GOB Water Treatment Facility (Self-Supporting) 56102 59179 Interest 61,105.00
5/15/2010 W Outside GOB Water Mains (Self-Supporting) 56102 59179 Interest 30,552.50
5/15/2010 W Outside GOB Water Mains (Self-Supporting) 56102 59179 Interest 22,220.00
59179 Total 127,588.75
3/27/2012 W Water GOB Water Treatment Facility (Self-Supporting) 56102 59181 Interest 106,400.00
59181 Total 106,400.00
3/15/2004 Outside GOB Well (Self-Supporting) 56102 59191 Interest 14,292.50
3/15/2004 Outside GOB Well (Self-Supporting) 56102 59191 Interest 9,845.00
3/15/2004 Outside I GOB Well (Self-Supporting) 56102 59191 Interest 9,845.00
3/15/2004 Outside GOB Water REFUNDING (Self-Supporting) 56102 59191 Interest 992.73
3/15/2004 Outside GOB Pumping Station REFUNDING (Self-Supporting) 56102 59191 Interest 4,219.13
3/15/2004 Outside GOB Well REFUNDING (Self-Supporting) 56102 59191 Interest 2,233.73
59191 Total 41,428.10
3/15/2008 VV Outside GOB Water REFUNDING (Self-Supporting) 56102 59192 Interest 3,757.50
3/15/2008 VV Outside GOB Well Field Development REFUNDING (Self-Supporting) 56102 59192 Interest 3,717.50
59192 Total 7,475.00
11/15/2010 W Outside WRA Water (Self-Supporting) 56102 59201 Interest 0.00
5/15/2012 W Outside WRA Water (Self-Supporting) 56102 59201 Interest 0.00
59201 Total 0.00
Grand Total 1,787,371.85
AUTHDEBT.xlsx 2 11/28/2012Source page 10
DEBT SERVICE PROJECTIONS - DEBT IN PIPELINE
AUTHORIZED AUTHORIZED TERM BOND BAN BOND FY
DATE ART # PURPOSE UNISSUED (YRS) DATE RATE RATE INT PRIN 2014
4/30/2007 15-8 WATER SYSTEM IMP (PHASE 2 & 3) (balance) 115,000 10 Mar-13 1.50% 3.50% 4 12 16
4/30/2008 13-8 WATER SYSTEM IMPROVEMENTS (balance) 475,000 10 Mar-13 1.50% 3.50% 5 15 20
4/27/2009 13-8 ELM STREET WATER IMPROVEMENTS 3,000,000 20 Mar-13 1.50% 3.50% 105 150 255
4/26/2010 13-6 WELL #10 REPAIRS 187,000 10 Mar-13 1.50% 3.50% 7 19 25
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 3.50% 0 0 0
4/30/2012 13-6 WATER SYSTEM MASTER PLAN IMPROVEMENTS 1,400,000 20 Mar-14 1.50% 3.75% 21 0 21
4/30/2012 13-7 REHAB TOLMAN TANK 1,090,000 20 Mar-14 1.50% 3.75% 16 0 16
TOTAL WATER 6,587,000 158 195 353
AUTHDEBT.xlsx PIPELINE 1/15/2013Source page 11
TOWN OF CANTON
BUDGET REPORT FOR FY 2014 FY 10 FY 11 FY 12 ACTUAL YTD
DEPARTMENTAL WORKSHEETS ACTUAL ACTUAL ACTUAL EXPENSE THEW ORIGINAL
BUDGET
FY2014
DEPARTMENTAL
_ FY2014 COMMENT/REASON FOR
EXPENSE EXPENSE EXPENSE 10/31/2012
FY 13 BASE BUDGET
DEPT
REQUEST
/
INCREASE DECREASE
700 METRO SKATING RINK
57000 - 51000 PERSONAL SERVICES
164 0
57000 - 51100. DEPARTMENT HEAD SALARY 0 0 0
8,332 8,332 5,687 0
57000- 51111 RINK ASSISTANTS 2,554 8,330
50,711 45,324 47,681 8,330
57000- 51120 SUPERVISOR SALARY 4,078 45,000
36,428 37,684 45,000
57000- 51123 LABORERS SALARY 39,425 0 0
85,578 91,079 0
57000 - 51150 ADMIN. SECRETARY SALARY 91,912 28,977 94,062
5,549 5,765 96,204 r-)rh 0
57000- 51162 POLICE DETAIL SALARIES 5,763 1,861 6,048
7,878 6,671 6,048
57000- 51300 OVERTIME SALARY 8,080 0 6,000 s
57000- 51400 LONGEVITY 2,417 11,879 6,000
4,858 4,000 274
400 800 274 ZcS C.
57000 - 51470 NIGHT DIFFERENTIAL 800 600 1,200
960 878 1,000
57000 - 51530 GOOD ATTENDANCE - AFSCME 960 132
1,432 1,504 0 0
57000- 51950 CONTRACT PROVISION 0 1,611 I
0 0 0 0
0 0 0
SUBTOTAL SALARIES S 199,850 3,887
5209,917 $205,166 $43,813 $160,914
57000- 52101 ELECTRICITY $166,743
72,669 75,386
57000- 52103 HEATING FUEL-GAS 71,472 7,510
19,504 21,620 62,449 62,449
57000 - 52105 BLDG.MAINT. & SUPPLIES 18,447 1,524
22,096 20,896 25,000 25,000
57000 - 52401 ICE RESURFACER REP/MAINT 22,431 6,091 13,000
489 2,691 18,000
57000 - 52404 REPAIRS/MAINT. MACHINERY 4,096 2,668
13,047 11,478 4,500 4,500
57000 - 52420 BUILDING MAINT&SUPPLIES 13,033 3,702
57000- 52707 RINK LEASE 8,440 0 13,500 13,500
0 125 0
57000 - 53400 TELEPHONE 0 0 0
0 0
57000 - 5340D ADVERTISING 697 509 3,750 3,750
387 54
57000 - 53550 SKATE SHOP EXPENSES 600 198 136
1,500 1,500 _
2,336 75 500
57000 - 54200 OFFICE SUPPLIES 2,149 2,194 500
57000- 54801 GASOLINE & OIL 0 0
1,850 12,500 12,500 2 c.=> 4- F"•113 er_
456 25 t
57000- 57105 IN-STATE TRAVEL 0 0 600 600
0 0
57000- 57501 OFFICIALS 0 0 500 500
0 0
57000 - 57502 EMT 12,252 12,375 250 250
12,952 0
2,475 2,850 11,500 11,500
57000 - 58502 COMPRESSORS METRO RINK 2,475 0
1,971 0 2,000 2,000 V i
57000- 59610 TRANSFER TO GENERAL FUND 7,241 3,633
57002 - 59138 PRINC PD - 05/09 DEBT 69,614 72,616 76,472 26,748
3,941 3,941 c f Er
57002- 59178 INT PD - 05/09 DEBT 13,000 12,000 80,243 82,015
10,000 0
2,270 1,880 8,000 8,000 e'
SUBTOTAL 1,520 0
EXPENSES S 241,461 1,320 1,320 i LP C
$236,647 S243,313 $54,005 $250,053 $251,825
cos
Date: 12/6/2012
W:\MUflIS\MCR Library\Budget reports \New Fiscal Year budget worksheet -Dept Reg 3 yr-enterprise by sal-exp.rpt
Page: 9Source page 12
TOWN OF CANTON
BUDGET REPORT FOR FY 2014 FY 10 FY 11 FY 12 ACTUAL YTD
ORIGINAL FY 2014
ACTUAL ACTUAL ACTUAL EXPENSE TPIRU FY 2014 CONLMENT/REASON FOR
DEPARTMENTAL WORKSHEETS EXPENSE EXPENSE EXPENSE
BUDGET DEPARTMENTAL DEPT INCREASE / DECREASE
10/31/2012
FY 13 BASE BUDGET REQUEST
SUBTOTAL METRO SKATING RINK S 441,310 5446,564 $448,479 $97,818 $410,967
!Yr cc,p
5413,568 4-9-e7c
' -T; T '
Dept Head Sigiature / Date
07
Date: 12/6/2012
VV:\Munis\MCR Library\Budget reports\New Fiscal Year budget worksheet -Dept Req 3 yr-enterprise by sal-exp.rpt
Page: 10Source page 13
—
PAYROLi PROJECTIONS.. FY 2014
Employee Pay Location
Last Name First Name FY13 Hrs per
Job Class Description Description FY13 Hourly FY13 Annual
1059 O'BRIEN Org Object Status Group/BU FY14 Next FY14 Next FY14 Hourly
IMICHAEL MA1NTENANC Grade Step Year Rate FY14 Annual FY14
RINK & REC 57000 51123 Salary 260 days Grade Step
874 WALSH JAMES FT AF 10 6 Rate Salary 261 days
RECREATION 2,080 24.11 50,149 Longevity
RINK & REC 57000 51123 FT 10 6
AF4 10 5 24.11 50,342
2,080 21.12 43,930 600
51123 Total 10 2196 45,863 400
57000 Total 94,078
96,204 1,000
94,078 --
96,204 1,000
PAYROLL PROJECTIONS F-Y14.XLS
33 of 34Source page 14
Murgia, James R.
( rom: Maguire, Janet
Sent: Monday, January 14, 2013 5:23 PM
To: Murgia, James R.
Subject: Salaries - FY14 Operating Budget
Jim,
Per our discussion, I would like to make the following adjustments to the Salaries and Wages for my FY14 Budget
submission:
700 METRO SKATING RINK
57000-51123 Laborers Salary 56,117 (Mike O'Brien $29,365; James Walsh $26,752)
630 RECREATION & PLAYGROUND
New Line Item?? Laborers Salary 40,087 (O'Brien $20,977; Walsh $19,110)
Or
16301-51186 Rec Maint Worker 1 (),,<.) tt
Previously, both of these employees were charged entirely to the rink budget. The rink is only open 7 months of the
year. So, these employees spend 5 months of the year doing maintenance for Recreation and Playgrounds.
Please contact me if you have any questions.
Thanks,
Janet
Janet M. Maguire
Recreation Director
Town of Canton
92 Pleasant Street
781-821-5030 (p)
781-575-6587 (f)
imaguire@town.canton.ma.us
1