Skip to content
Search Canton

Canton, Massachusetts · Saved source text

FY18 Enterprise Fund Requests

Budgets & Finance · Fiscal year 2018 · Record a018b7b94f5945bacd

Open original municipal record ↗Open interactive reader

Saved text from 16 source pages. Transcription and OCR may contain errors; verify figures and wording against the original. Retrieved 2026-10-15.

Source page 1

ENTERPRISE FUNDS'OPERATING BUDGETS FOR FISCAL 2018

                                      FISCAL         FISCAL         FISCAL            FISCAL        ~      FY 18                $
                                       2014           2015           2016              2017         ~    Requested          INCREASE/           INCREASE/
           DESCRIPTION               ACTUALS        ACTUALS        ACTUALS           BUDGET         ~,     Budget          (DECREASE)          (DECREASE)

SALARIES &WAGES                         821,945        804,343          859,516         911,854              948,271   I        36,417               4.1%
MWRAASSESSMENT                   ~    1,426,900      1,004,356        1,299,628       1,680,349            1,680,349                 0               0.0%
CHARGES FROM GENERAL FUND               756,170        620,022          978,960         510,539              514,825             4,286               0.4%
DEBT SERVICE                          2,090,328      2,381,070        2,380,554       2,305,670            2,358,680            53,010               2.2%
CASH CAPITAL                            170,814        609,338          721,510               0                    0                 0               0.0%
OTHER EXPENSES                        1,030,361      1,059,959        1,085,499         987,760              987,760                 0     ~         0.0%

TOTAL WATER OPERATING EXPENSES        6,296,518      6,479,088        7,325,667       6,396,172            6,489,885            93,713               1.3%


SALARIES &WAGES                  ~      389,682        318,729          320,836         427,412              459,130            31,718               7.4%
MWRAASSESSMENT                   I    3,485,020 '    3,584,952        3,979,956       4,178,270 ~          4,178,270 ~               0               0.0%
CHARGES FROM GENERAL FUND               394,399        376,369          384,876         356,442              358,865 ,           2,423 '             0.6%
DEBT SERVICE                            937,830      1,053,075        1,122,909       1,186,517            1,126,032           (60,485)             -5.4%
CASH CAPITAL                                  0         45,900                0               0                    0                 0               0.0%
OTHER EXPENSES                          401,397        306,436          465,226         347,999              347,999                 0               0.0%

TOTAL SEWER OPERATING EXPENSES        5,608,329 '    5,685,461        6,273,803       6,496,640 '          6,470,296           (26,344)             -0.4%


SALARIES &WAGES                         131,111        123,233               9,641       29,324                8,300           (21,024)            -20.6%
CHARGES FROM GENERAL FUND                82,015         90,729                   0            0                    0                 0               0.0%
DEBT SERVICE                              9,160          8,980               8,780        6,540                6,360             (180)              -2.1%
CASH CAPITAL                                  0              0                   0            0                    0                 0               0.0%
OTHER EXPENSES                          155,891        150,503              11,796       77,580               13,550           (64,030)            -83.4%

TOTAL RINK OPERATING EXPENSES           378,177 j      373,444              30,217      113,444               28,210           (85,234)            -45.5%




      ATM DATA.xlsx                                           enterprises                                                            1/10/2017

Source page 2

ENTERPRISE FUNDS
    BUDGET REQUESTS - FY18

The following FY18 Budget Worksheets
(Department Requests) were provided to the
 Finance Committee on January 13, 2017.

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 3

TOWN OF CANTON
                                                                                 ACTUAL YTD                                 FY 201S       COMNfENT/REASON FOR
     BUDGET REPORT FOR FY 2018               FY 14       FY 15        FY 16
                                                                                ~pENSE THRU    ORIGINAL         ~ 2018       DEPT          INCREASE /DECREASE
                                            ACTUAL      ACPUAL      ACTU~                       BUDGET       DEPARTMENTAL   ~Q~ST
    DEPARTMENTAL WORKSHEETS                 EXPENSE     EXPENSE     EXPENSE
                                                                                   9/30/2016
                                                                                                 FY 17        BASE BUDGET


      700       METRO SKATING RINK
57000-51]00-    DEPARTMENT HEAD SALARY         8,332        8,332       8,364             32         8,300       8,300          8,300 / All decreases are based
57000-511 I1-   RINK ASSISTANTS               39,861       32,868           0              0        18,000      18,000              0 ~ on the expectation that
57000-51123-    LABORERS SALARY               58,175       59,598           0              0             0           0              0      the rink will not be
57000-51150-    ADNjIN, SECRETARY SALARY       4,]87        4,294           0              0         3,024       3,024              0 ~ operating in FY18;
57000-51162-    POLICE DETAIL SALARIES         9,310        9,487           0              0             0           0              0        minimal budget
57000-51300-    OVERTIME SALARY                7,980        6,174           0              0             0           0              0    established to maintain
57000-51400-    LONGEVITY                      1,500        1,820        480               0             0           0              0       current expenses
57000-51470-    NIGHT DIFFERENTIAL               737          660           0              0             0           0              0    (fencing, storage, debt
57000-51530-    GOOD ATTEN - AFSCME            1,030            0         797              0             0           0              0   services) and unexpected
57000-51920-    STIPENDS                           0            0           0          1,920             0           0              0   expenses that may occur.

                     SUBTOTAL SALARIES      $131,111     $123,233      $9,641        $1,952       $29,324       $29,324         8,300
57000-52000-    PURCHASE OF SERVICES            1,495      15,598       6,419             0              0           0              0
57000-52101-    ELECTRICITY                   66,288       53,273           0             0         32,500      32,500              0 c~
57000-52103-    HEATING FUEL -GAS             22,948       10,320           0             0         10,000      10,000              0
57000-52105-    BLDG.MAINT. &SUPPLIES         21,529       23,152       5,131         1,131          9,000       9,000          9,000
57000-52401-    ICE REStJRFACER REP/MAINT       1,533       9,919           0             0          2,250       2,250          2,250
57000-52404-    REPAIRS/MAINT. MACHINERY      13,118        8,281         100             0          6,750       6,750              0✓
57000-52420-    BUILDING MAINT&SUPPLIES           512         348           0             0              0           0              0
57000-52707-    LEASE OF BUILDING              3,820        3,307           0             0          1,875       1,875          1,875
57000-53400-    TELEPHONE/COMMiINICATIONS         142         151         147            37            125         125            125
57000-5340D-    ADVERTISING                       188         475           0             0            250         250              0
57000-53550-    SKATE SHOP EXPENSES            2,599        2,727           0             0          1,500       1,500            300
57000-54200-    OFFICE SUPPLIES                  658        1,481           0             0            300         300              0~
57000-54801-    GASOLINE &OIL                       0           0           0             0            250         250              0
57000-57105-    IN-STATE TRAVEL                     0           0           0             0            125         125              0
57000-57501-    OFFICIALS                     1 1,004      11,463           0             0          6,125       6,125              0 ~/'
57000-5750?-    gM'1'                          2,880        2,890           0             0          1,530       1,530              0    /
57000-58502-    COMPRESSORS METRO RINK         7,827        7,118           0             0          5,000       5,000              0 ✓
57000-59610-    TRANSFER TO GENERAL FUND      82,015       90,729           0             0              0           0              0
57002-59138-    p~C PD - 05/09 DEBT            8,000        8,000       8,000            0          6,000        6,000         6,000 ~/
57002-59178-    INT PD - 05/09 DEBT            1,160          980         780            0            540          540           360 V
                   SUBTOTAL EXPENSES        $247,716     X250,212     $20,576        X1,168       $84,120       $84,120        19,910

Source page 4

TOWN OF CANTON
                                                                                                    ACTUAL YTD                                              ~'2018
 BUDGET REPORT FOR FY 2018                      F'~' 1;             Fv ~s             ~ 16         EXPENSE THRU           ORIGINAL              FY 2018
                                                                                                                                                                      COMMENT/REASON FOR
                                               ACTunL             ACTUAL                                                                                     DEPT      INCREASE/DECREASE
                                                                                     ACTUAL                                                 DEPARTMENTAL
DEPARTMENTAL WORKSHEETS                        EXPENSE
                                                                                                      9/30/2016            BUDGET
                                                                                                                                                           REQUEST
                                                                  EXPENSE            EaPENSE                                FY 17            BASE BUDGET
        SUBTOTAL METRO SKATING RINK            $378,327             $373,444            $30,217          X3,120               $113,444         X113,444      28,210
TOTAL    630    PARKS &RECREATION              $378,827                                 $30,217          $3,120               $113,444         $113,444      28,210




                                                                                                                           ept Head Signature /Date




                         W:\Munis\MCR Library\Budget reports\New Fiscal Year budget worksheet -Dept Req-enterprise by sal-exp.rpt

Source page 5

TOWN OF CANTON
      BUDGET REPORT FOR FY 2018                                 FY 14         FY 15           FY IG        ACTUAL Yi'D          ORIGINAL           rY 2018         FY 2018      COMMENT/REASON FOR
                                                              ACTUAL         ACTUAL         ACTUAL        EXPENSE THRU           BUDGET        DEPARTMENTAL         DEPT         INCREASE /DECREASE
     DEPARTMENTAL WORKSHEETS                                  EXPENSE        EXPENSE        EXPENSE          9/30/2016            FX 17         BASE BUDGET       REQUEST


     G00        SEWER ENTERPRISE


56000-51000-        PERSONAL SERVICES                                  0           0              0                  0             19,407            19,406        i9 ,`fob
56000-51120-        SUPERVISOR SALARY                            31,793       40,353         39,260              9,057            101,184           118,518        ~►~rsy 6i$
56000-51122-        SEPTAGE SALARY                               42,818       48,18]         52,767             12,488             53,432            53,227     -~ ~'~
56000-51123-        LABORERS SALARY                             176,018      120,537        114,795             16,063            116,009           121,618      t~-+, 6L8
56000-51135-        JUNIOR ENGINEER SALARY                       35,638       36,648         37,895              9,517             37,457            38,060        3i o6r'
56000-51142-        ACCOUNTING CLERK                                   0       9,528         21,950              4,805             22,926            22,838
56000-51143-        OFFICEADMINISTRATORSAL.                      64,887       55,798         41,041              8,100             28,314            30,495        ~,`~'4~
56000-51 ]62-       POLICE DETAIL SALARIES                         3,035           0          3,224                  0              4,000             4,000         'F~ ~~D
56000-51300-        OVERTIME SALARY                              23,717        1,684          4,248              2,105             26,500            26,500        d~F Soa
56000-S14o0-        LONGEVITY                                     7,150        6,000          2,800                  0              2,600             3,400         ~ ~~
56000-51450-        WORKING OUT OF GRADE                           3,360           0          2,856                884                  0                 0           ~ ~
56000-51530-        GOOD ATTEN - AFSCME                            ],266           0              0                  0              2,000             2,000 ~      ~i ~Q
56000-51950-        CONTRACT PROVISION                                 0           0              0                  0             13,583            19,0684         tQ~ ~5
           SUBTOTAL      SALARIES                            $389,682       $318,729      $320,836             $63,020         $427,412           $459,130

56000-52000-        PURCHASE OF SERVICES                         26,596       16,221         42,939                                                          b,00~o
                                                                                                                 5,000              6,000           ' 6,000
56000-52102-        HEATING FUEL -OIL                             1,923        2,015          1,790                335                  0                 0      ~
56000-52104-        LIGHTS R: POWER                               9,090        7,876           8,119             1,058             13,000           13,000   l3,ppe
56000-52105-        BLDG.MAINT. &SUPPLIES                             0            0              21                 0                  0                 0      ~
56000-52301-        WATER/SEWER PURCH MILTON/STOUG              266,491      223,927        2]4,388             45,898            250,000          250,000  ~~• ~~
56000-52410-        REPAIR/MAINT MOTOR VEHIC                        439            0               0                 0                  0                 0      ~
56000-52419-        REPAIR/MAINT PUMPING STA                      5,043       16,747          7,843                  0              9,000             9,000   4~~~`
56000-52425-        REPAIR/MAINTEQUIPMENT                         6,486        7,995          7,480                  0                                        1~~00
                                                                                                                                    1,200             1,200
56000-52427-        REPAIR/MAINT SEWERS                               0        1,496          2,816              7,323                                        ~~~oa
                                                                                                                                    7,500             7,500
56000-52704-        iJNIFORM RENTAL                               1,386        1,782          1,719                290              4,500             4,500   ~, ~~
56000-5310R-        PHYSICAL FITNESS PROGRAM                          0            0               0                 0                150               150     tso
56000-53128-        PHYSICAL FITNESS PROGRAM                          0            0               0                 0                200               200    ~~
56000-53400-        TELEPHONE/COMMUNICATIONS                          0            0               0                 0              1,000             1,000   tt~~
56000-53406-        COMMiJNICATIONS -OTHER                          373          377             380                63                500               500     5~
56000-53408-        POSTAGE                                          26            0               0                 0                  0                 0     ~
56000-54000-        SUPPLIES                                        450          356             809               212                                        Soo
                                                                                                                                      500               500
56000-54011-        TOOLS &HARDWARE                              60,115        6,773          9,103              1,232                                      3G~ s~~r9
                                                                                                                                   36,449           36,449
56000-54033-        WORK SHOES                                      405          295             112                 0                500               500   Sow
56000-54041-        FOUL V✓EATHER GEAR                                0            0               0                 0                300               300    3~
56000-54200-        OFFICE SUPPLIES                               1,594        2,402          2,607                172                  0                 0    ~
56000-54801-        GASOLINE &OIL                                 7,992        3,325          2,135                237              8,500            8,500~~~

Date: 11/8!2016                     w~~Munis\MCR Library\Budget reports\New Fiscal Year budget worksheet -Dept Req-enterprise by sai-exp.rpt
                                                                                                                                                                                   Page: 1

Source page 6

TOWN OF CANTON
     BUDGET REPORT FOR FY 2018                              FY 14          FY IS           FY 16        ACTUAL YTD           ORIGINAL           ~1 2018         FY 2018        COMMENT/REASON FOR
                                                           ACTUAL         ACTUAL         ACTUAL        EXPENSE TABU           BUDGET        DEPARTMENTAL         DEPT           INCREASE!DECREASE
    DEPARTMENTAL WORKSHEETS                                EXPENSE        EXPENSE        EXPENSE          9/30/2016            gy 1~         BASE BUDGET       REQUEST

56000-54806-      DIESEL FUEL                                  5,942        3,247           1,224                ]49              7,000
56000-54901-      MEALS                                                                                                                            7,000        ~~~
                                                                  20            0              40                  0                100                          toe
56000-55301-      MATERIALS &SUPPLIES                                                                                                                100
                                                                 463            0               0                  0                500
56000-55306-      BITUMINOUS MATERIALS                                                                                                               500         S
                                                                 104          358               0                  0                  0
56000-5530B-      CASTINGS                                                                                                                             0
                                                               1,478            0               0                  0                  0
56000-5580E-      WORK SHOES                                                                                                                           0           ~
                                                                 202          150               0                  0                  0
56000-57802-      HEAVY EQUIPMENT LICENSES                                                                                                             0          6
                                                                 165            0             150                 90                100
56000-57821-      SEPTAGE SITE                                                                                                                       ]00         ~~
                                                                   0            0               0                  0              1,000            1,000
56000-58937-      MWRA CHARGES                                                                                                                                   ~~ ~~
                                                           3,485,020    3,584,952       3,979,956          1,241,149          4,]78,270
56000-59610-      TRANSFER TO GENERAL FiJND                                                                                                    4,178,270       y,?~ Tam_
                                                             394,399      376,369         384,876             89,111            356,442          356,442               d~i~'            ~
         SUBTOTAL     EXPENSES                          $4,276,202     $4,256,663     $4,668,506         $1,392,316        $4,882,711        $4,882,711
         SUBTOTAL SEWER ENTERPRISE                      $4,665,884     $4,575,392      $4,989,342        $1,455,336        $5,310,123        $5,341,841        S3~ ~           ~3~~F~ `f
                                                                                                                                              Dept Head Signature /Date




                                                                 `                   ~   'A 1 P,~
                                                                                          v`~ ,~/~ ~
                                                                                                     ~y^`




Date: 11/8/2016                  W~~Munis\MCR Library\Budget reports\New Fiscal Year budget worksheet -Dept Req-enterprise by sal-exp.rpt
                                                                                                                                                                                 p~g~. Z

Source page 7

SALARY PROJECT                   '- FY18



                                                                                                                                                                                                    FY17 Pay      FY18    FY18    FY18                        FY18
 Emp #            Lart Name          First Name                                                                                                                      FY37 Hrs Per    FY37 Pay     Annual Salary   Next    Next
                                                               Job Class Desc              Location Desc                                                                                                                         Houriy    FY38 Annual      Estimated
                                                                                                           Group/BU   Org   Object   Status   Pay Grade   Pay Step      Year        Hourly Rate
    ~ar~i                         VAEfl#Ef        GISANALYST                                                                                                                                        260 days      Grade   Step    Rate    Salary 260 days   Longevity
                                                                                   ENGINEERING -SEWER        AF4   56000 51000       Ff          17          3          624              31.10          19,406     17      3      31.10
                              1            G                                                                                                                                                                                                     19,406             0
                                                                                                                56000 Count
 1479                                                                                                                    51000 Total                                                                   19,406
            MORTON                DENNIS          WATER/SEWER SUPERVISOR                                                                                                                                                                         19,406            0
                                                                                   SEWER                    AF4    56000 51120       Ff         18          6
 Vacant     VACANCY               VACANCY                                                                                                                               1040             37.12         38,605      18      6      37.12          38,605
                                                  SEWER FOREMAN                    SEWER                    AF4                                                                                                                                                  200
                                                                                                                   56000 51120       FT         17          6           2080             38.42
                              Z                                                                                                                                                                        79,914      17      6      38.42          79,914            0
                                                                                                                56000 Count
                                                                                                                         51120 Total                                                                  118,518
 683        DEBAGGIS              JAMES           SKILLED LABORER/TRUCK DRIVER                                                                                                                                                                 118,518           Z00
                                                                                   SEWER                     AF    56000 51122       FT         10          6
                              1                                                                                                                                         2080             25.59         53,227      10      6      25.59         53,227         1,000
                                                                                                                56000 Count
                                                                                                                         51122 Total                                                                   53,227
 889        LENHART               CHARLES         UTILITIES MAINTENANCETECHNICI                                                                                                                                                                 53,227         1,000
                                                                                   SEWER                     AF    56000 51123       Ff         14
 Vacant     VACANCY                                                                                                                                         6          2080              32.29         67,163      14      6      32.29
                                  VACANCY         HEAVY EQUIPMENTOPER-4%           HIGHWAYMAINT-SEWER                                                                                                                                           67,163          800
                                                                                                            AF4    56000 51123       Ff         12          6          2080              26.18
                              2                                                                                                                                                                        54,454      12      6      26.18         54,454             0
                                                                                                                56000 Count
                                                                                                                         51123 Total                                                                  121,618
 1241       LEVREAULT             PHILIP          STAFF ENGINEER                                                                                                                                                                               121,618           800
                                                                                   ENGINEERING -SEWER       P64    56000 51135       FT         15A         6          1092              34.17         37,314     15A     6       34.85         38,060
                              1                                                                                                                                                                                                                                  600
                                                                                                                56000 Count
                                                                                                                         51135 Total                                                                   37,314
 1469       JERRIER               MICHAEL         WATER &SEWER ACCT COORDINATOR                                                                                                                                                                 38,060           600
                                                                                   SEWER                    AF4    56000 51142       FT          9          6          1040              21.96         22,838      9      6       21.96         22,838
                              1                                                                                                                                                                                                                                  200
                                                                                                                56000 Count
                                                                                                                         51142 Total                                                                   22,838
 1359       CAWLEY                PATRICIA        WATER/SEW ER OFFICEADM~NSTRATO                                                                                                                                                                22,838           200
                                                                                   SEWER                    AF4    56000 51143       Ff         166         1          1040              27.11         28,194     166     3       2932          30,495
                              1                                                                                                                                                                                                                                  600
                                                                                                                56000 Count
                                                                                                                         51143 Total                                                                   28,194                                   30,495           600
                                                                                                                56000 Total                                                                           401,116                                  404,163         3,400




                                                                                                                                                                                                                          ~'~-17


Payroll Projections FYl8.xlsx MUNIS download for FY18
11/14/2016 12:38 PM
                                                                                                                                                                                                                                                              33 OF 35

Source page 8

Se w~/L


          TOWN OF CANTON
      BUDGET REPORT FOR FY 2018                              FY 14          FY 15         FY 16        ACTUAL YTD           ORIGINAL            FY 2018           FY 2018      COMMENT/REASON FOR
                                                           ACTUAL         ACTUAL        ACTUAL        ~ENSETHRU                             DEPARTMENTAL
     DEPARTMENTAL WORKSHEETS                               EXPENSE        EXPENSE       EXPENSE          9/30/2016
                                                                                                                             g~GET                                 DEPT         INCREASE/DECREASE
                                                                                                                              py l~          BASE BUDGET         REQUEST
Spa -5zj/~                       --       ~~'
56002-59101-      PRINC PD-OS/11 DEBT
                                                                                                                                                               ,tiS' Dot) ~/
                                                              75,000       74,000        74,000                  0
56002-59106-      PRIM PD-3/15 DEBT                                                                                              73,000           73,000
                                                                   0             0       82,750                  0
56002-59107-      INT PD-03/15 DEBT                                                                                              82,000           82,000
                                                                   0             0        15,698             6,608               13,215
56002-59109-      PRINCIPAL PAID TO MWRA                                                                                                          13,215
                                                                   0      113,300       113,300            113,300
56002-59126-      PRINCIPAL PAID TO MWPAT                                                                                      113,300          113,300
                                                             160,130      163,365       166,665            170,032
56002-59127-      PRINC PD-01106 DEBT                                                                                          170,032          170,032
                                                              53,000             0             0                 0
56002-59128-      PRINC PD-01/08 DEBT                                                                                                 0                0
                                                               5,000         5,000         5,000                 0
56002-59130-      PRINCIPAL PAYDOWNS                                                                                              5,000            5,000
                                                                   0             0             0                 0
56002-59131-      PRINC PD-3/12 DEBT                                                                                            75,000           75,000
                                                             100,000      100,000       100,000                  0
56002-59]32-      PRINC PD-03/13 DEBT                                                                                          100,000          100,000
                                                              20,000        19,000       17,000                  0
56002-59133-      PRINC PD-11/13 DEBT                                                                                            17,000           17,000
                                                                   0      267,300       266,600                  0             257,600
56002-59135-      PRIM PD-03/14 DEBT                                                                                                            257,600
                                                                   0       48,300        48,200                  0              48,200
56002-59138-      PRINC PD - 05/09 DEBT                                                                                                          48,200
                                                              26,000       26,000        26,000                  0              26,000
56002-59141-      PRINC PD-03/04 DEBT                                                                                                            26,000
                                                            250,315              0             0                 0
56002-59145-      INT PD-03/16 DEBT                                                                                                   0                0
                                                                   0             0             0             4,005                    0
56002-59150-      INTEREST PD OS/11                                                                                                                    0
                                                              18,390       16,890        13,930                  0               11,710
56002-59160-      INTEREST PD TO MWPAT                                                                                                            11,710
                                                              69,552       68,651        65,103             31,656              61,484
56002-59175-      INT PD-01/06 DEBT                                                                                                              61,484
                                                              25,780             0             0                 0
56002-59776-      INT PD-01/08 DEBT                                                                                                   0                0
                                                               2,425         2,250         2,506                 0                1,900
56002-59178-      INT PD - 05/09 DEBT                                                                                                              1,900
                                                               4,325         3,740         3,090                 0                2,310
56002-59181-      INT PD - 3/12 DEBT                                                                                                               2,310
                                                              56,000       54,000        51,000             24,000              48,000
56002-59182-      INT PD - 03/13 DEBT                                                                                                            48,000
                                                               4,950         4,350         3,780             1,635                3,270
56002-59183-      INTPD-11/13 DEBT                                                                                                                 3,270
                                                              25,739       59,159        48,932              6,963              40,551
56002-59185-      INT PD-03/14 DEBT                                                                                                              40,551
                                                                   0       21,770        19,355              8,473              16,945
56002-59191-      INT PD-03/04 DEBT                                                                                                              16,945
                                                              37,474             0             0                 0                    0
56002-59250-      INTEREST TEMPORARY LOANS                                                                                                             0
                                                               3,750         6,000            0                  0              20,000           20,000
         SUBTOTAL     EXPENSES                           $937,830      $1,053,075    $1,122,909          $366,671         $1,186,517         $1,186,517
         SUBTOTAL SEWER PRINC/INT PAYMENTS               $937,830      51,053,075     $1,122,909         $366,671         $1,186,517         $1,186,517         / ~ ~~O0'
                                                                                                                                                                        3'
                                                                                                                                                                         1

                                                                                                                                                                  ~ ,?~~~~1
                                                                                                                                              Dept        Signature /Date




Datc: 11/8/2016                  W:\Munis\MCR Library\Budget reports\New Fiscal Year budget worksheet -Dept Req-enterp
                                                                                                                      rise by sal-exp.rpt
                                                                                                                                                                                 Page: 3

Source page 9

DEBT SERVICE PAYMENTS FROM FY 77 THRU FY 35
        Date of                                                                         7/1/2016        Debt Service       Type of
 No.     Issue  Type                      Description                                   Debt O/S       Org      Object     Payment        2017              2018
 43     5/1/2011 S GOB Sewer REFUNDING (Self-Supporting)                                   343,000    56002     59101      Principal     73,000.00         71,000.00
                                                                                                             59101 Total                 73,000.00         71,000.00
 137 3/15/2015     S    Engineering Services -Sewer                                        113,000    56002     59106      Principal     39,000.00         37,000.00
 141 3/15/2015     5    Water Meters -Sewer                                                221,000    56002     59106      Principal     30,000.00         29,000.00
 142 3/15/2015     S    Water Meters -Sewer                                                115,000    56002     59106      Principal     13,000.00         13,000.00
                                                                                                             59106 Total                 82,000.00         79,000.00
137 3/15/2015      5    Engineering Services -Sewer                                                   56002     59107      Interest        3,390.00          2,220.00
141 3/15/2015      5    Water Meters -Sewer                                                           56002     59107      Interest        6,495.00          5,595.00
142 3/15/2015      S    Water Meters -Sewer                                                           56002     59107      Interest        3,330.00          2,940.00
                                                                                                             59107 Total                 13,215.00         10,755.00
 75    8/19/2013   S    MWRA Sewer I & I -interest free                                   339,900     56002     59109      Principal   113,300.00        113,300.00
 75    8/19/2013   S    MWRA Sewer I & I -interest free                                               56002     59109      Interest             -                 -
                                                                                                             59109 Total               113,300.00        113,300.00
 30     7/8/2010   S    WPTSewer CWS-07-38 (Self-Supporting)                             2,944,725    56002     59126      Principal   170,032.00        173,467.00
                                                                                                             59126 Total               170,032.00        173,467.00
 59    3/27/2012   S   GOB Sewer (Self-Supporting)                                       1,600,000    56002     59131      Principal   100,000.00        100,000.00
                                                                                                             59131 Total               100,000.00        100,000.00
 66    3/15/2013   S   GOB Departmental Equipment-Sewer (Self-Supporting)                  94,000     56002     59132      Principal     17,000.00         17,000.00
                                                                                                             59132 Total                 17,000.00         17,000.00
 77 11/13/2013     S   Sewer Refunding                                                     92,100    56002      59133      Principal     24,800.00         23,500.00
 78 11/13/2013     S   Sewer Refunding                                                     12,680    56002     59133       Principal       4,130.00          3,800.00
 79 11/13/2013     S   Sewer Refunding                                                    139,720    56002     59133       Principal     36,270.00        35,700.00
80 11/13/2013      S   Sewer Refunding                                                    178,700    56002     59133       Principal    48,700.00         47,100.00
81 11/13/2013      S   Sewer Refunding                                                    345,500    56002     59133       Principal    92,200.00         87,400.00
93 11/13/2013      S   Estey Way Sewer (Refunding)                                         94,000    56002     59133       Principal     10,900.00        10,800.00
94 11/13/2013      S   Wardwell5ewer (Refunding)                                           88,200    56002     59133       Principal     10,900.00        10,800.00
106 11/13/2013     S   Sewer I & I (Self-Supporting)-(Refunding)                          250,500    56002     59133       Principal    29,700.00         29,400.00
                                                                                                            59133 Total                257,600.00        248,500.00
110 3/15/2014      S   Sewer (Self -Supporting)                                           240,000    56002     59135       Principal    30,000.00         30,000.00
125 3/15/2014      S   Sewer(Refunding)                                                   120,500    56002     59135       Principal    18,200.00         18,100.00
                                                                                                            59135 Total                 48,200.00         48,100.00
 12    SJ15/2009   S   GOB Departmental Equipment-Sewer (Self-Supporting)                  77,000    56002     59138       Principal    26,000.00         26,000.00
                                                                                                            59138 Total                 26,000.00         26,000.00
149 3/17/2016      S   Sewer                                                              311,000    56002     59144       Principal    37,000.00         34,000.00
150 3/17/2016      S   Sewer                                                              250,000    56002     59144       Principal    26,000.00         26,000.00
163 3/17/2016      S   GOB Sewer (Self-Supporting)(Refunding)                              50,000    56002     59144       Principal      6,000.00          5,000.00
                                                                                                            59144 Total                 69,000.00         65,000.00
149 3/17/2016      S   Sewer                                                                         56002     59145       Interest       5,148.78          5,480.00
150 3/17/2016      5   Sewer                                                                         56002     59145       Interest       4,138.89          4,480.00
163 3/17/2016      5   GOB Sewer (Self-Supporting)(Refunding)                                        56002     59145       Interest         827.78            880.00
                                                                                                            59145 Total                 10,115.45         10,840.00
43      5/1/2011   S   GOB Sewer REFUNDING (Self-Supporting)                                         56002     59150       Interest     11,710.00           9,520.00
                                                                                                            59150 Total                 11,710.00           9,520.00
30      7/8/2010   S   WPT Sewer CWS-07-38 (Self-Supporting)(includes admin fees)                    56002     59160       Interest     61,483.74         57,791.13
                                                                                                            59160 Total                 61,483.74         57,791.13
12     5/15/2009   S   GOB Departmental Equipment -Sewer (Self-Supporting)                           56002     59178       Interest       2,310.00          1,530.00
                                                                                                            59178 Total                   2,310.00          1,530.00
59     3/27/2012   S   606 Sewer (Self-Supporting)                                                   56002     59181       Interest     48,000.00         46,000.00
                                                                                                            59181 Total                 48,000.00         46,000.00
66     3/15/2013   S   GOB Departmental Equipment-Sewer (Self-Supporting)                            56002     59182       Interest       3,270.00          2,760.00
                                                                                                            59182 Total                   3,270.00          2,760.00
 77 11/13/2013     S   Sewer Refunding                                                               56002     59183       Interest       3,188.00          2,222.00
 78 11/13/2013     S   Sewer Refunding                                                               56002     59183       Interest         424.60            266.00
 79 11/13/2013     S   Sewer Refunding                                                               56002     59183       Interest       4,863.40          3,424.00
 80 11/13/2013     S   Sewer Refunding                                                               56002     59183       Interest       6,174.00          4,258.00
 81 11/13/2013     S   Sewer Refunding                                                               56002     59183       Interest     11,976.00           8,384.00
 93 11/13/2013     S   Estey Way Sewer (Refunding)                                                   56002     59183       Interest       3,028.00          2,701.00
94 11/13/2013      S   Wardwell Sewer (Refunding)                                                    56002     59183       Interest       2,834.00          2,507.00
106 11/13/2013     S   Sewer I & I (Self-Supporting)-(Refunding)                                     56002     59183       Interest       8,063.00          7,172.00
                                                                                                            59183 Total                 40,551.00         30,934.00
110 3/15/2014      S   Sewer(Self-Supporting)                                                        56002     59185       Interest     11,250.00          9,750.00
125 3/15/2014      S   Sewer (Refunding)                                                             56002     59185       Interest       5,695.00          4,785.00
                                                                                                            59185 Total                 16,945.00         14,535.00


                                                                                                                                                       ~~~~-
                                                                                                                                                      ~


           AUTHDEBT.xlsx                                                            1                                                        8/29/2016

Source page 10

TOWN OF CANTON
     BUDGET REPORT FOR FY 2018                                 FY 14          FY 15          FY 16        ACTUAL YTD           ORIGINAL           FY 2018       FY 2018       COMMENT/REASON FOR
                                                              ACTUAL        ACTUAL         ACTUAL        EXPENSETHRU            BUDGET        DEPARTMENTAL       DEP'C         INCREASE/DECREASE
    DEPARTMENTAL WORKSHEETS                                   EXPENSE       EXPENSE        EXPENSE          9/30/2016            py I~         BASE BUDGET     REQUEST


    640        WATER ENTERPRISE


56100-51000-       PERSONAL SERVICES                                 0             0             0                   0             19,656          19,406
56100-51120-       SUPERVISOR SALARY                                                                                                                           i9•yO'~
                                                               129,044      144,283        112,798              27,806            118,974
56100-51123-       LABORERS SALARY                                                                                                                118,518    T~1
                                                               484,015      471,347        482,258             112,171            525,905
56100-51]35-       JLTNIORENGINEERSALARY                                                                                                          527,688    ~         -'   ~ ~       °   ~   ~
                                                                23,195       23,351         23,530               5,069             24,971
56100-51142-       ACCOLTN"LING CLERK                                                                                                              25,373    ~~2                  ~
                                                                42,682       37,103         24,772               5,912             22,926
56100-51143-       OFFICE ADMINISTRATOR SAL.                                                                                                       22,838
                                                                     0       14,942         41,157               5,129             28,313
56100-51162-       POLICE DETAIL SALARIES                                                                                                          30,495    ~'~q~
                                                                16,861       11,534         17,852               3,569              6,500
56100-5]210-       SUMMER HELP SALARY                                                                                                               6,500    ~,  rsom
                                                                 4,038        3,1 ]0         9,069               5,518              6,000           6,000
56100-51300-       OVERTIME SALARY                                                                                                                             G~ ~~
                                                               103,452       84,478        119,446              26,945            111,000         111,000     IL( ~D
56100-5]400-       LONGEVITY                                     7,200        7,633          9,000               1,500             11,900           8,150      fc /So
56100-51530-       GOOD ATTEN - AFSCME                           5,958        3,812          5,360                   0              2,000           2,000     ~ ~~~
56100-51916-       SALARY CONTINGENCIES                              0             0             0                   0              2,329           2,329
56100-51920-       STIPENDS                                      5,500        2,750         14,274               1,416              5,500           5,500        S ~
56100-51950-       CONTRACT PROVISION                                0             0             0                   0             25,880          40,987       ~.~~
                                                                                                                                                                  9

          SUBTOTAL      SALARIES                            $821,945       $804,343      $859,516            $195,035          X911,854         $926,7              / ~v,~~'

56100-52000-      PURCHASE OF SERVICES                          43,857      141,646         80,986              7,942             46,000           46,000      ~~~°~
56100-52000-WELLS PURCHASE OF SERVICES                               0            0              0             19,812                  0                0          ~
56100-52102-      HEATING FUEL -OIL                             21,731       13,930         11,940              1,441              6,000            6,000       b~oo~
56100-52104-      LIGHTS &POWER                                224,392      249,053        270,341             69,672            231,500          231,500     d31,Soo
56100-52105-      BLDG.MAINT. &SUPPLIES                          3,091        2,291          2,604                600              5,000            5,000        3,o~~
56100-52301-      WATER/SEWERPURCHMILTON/STOUG                  63,592       37,161         46,149                122             30,000           30,000    ~6 ooa
56100-52x10-      REPAIR/NIAINTMOTORVEHIC                       13,095        5,054          2,412                  0              3,000            3,000       ~„ooa
56100-52420-      BUILDINGMAINT&SUPPLIES                         5,379          484          1,578                  0              1,500            1,500       ~-~o~
56100-52422-      REPAIR/MAINT -WELLS                           39,699       18,111         27,062                213             32,000           32,000      ~~ ~~
56100-52425-      REPAIR/MAINTEQUIPMENT                         40,944       40,679         79,517             30,682             25,000           25,000      'I.~ooO
56100-52703-      RENTAL OF EQUIPMENT                              871        1,485          1,200                                                               ~~ooa
                                                                                                                    0              1,000            1,000
56100-52704-      iJNIFORM RENTAL                                2,463        2,861          3,098                528              4,000            4,000      ~~~~
56100-531os-      PRINTING &BINDING                                 73            0              0                  0              1,500            1,500       ►Soo
56100-5310T-      PROF.SERV. WATER TESTING                      20,680       29,424         32,136              4,526             20,000           20,000    ~~a
56100-5310U-      PROF.SERV. MEDICAL EXt1MS                         90          583              0                  0                100              100        !00
56100-531]0-      PHYSICAL FIT-AFSCME                                0            0              0                  0                250              250       ~•~
56100-53400-      TELEPHONE/COMMiJNICATIONS                     22,266       21,476         21,945              5,641             22,000           22,000    ~~•~~
56100-53406-      COMMLLJNICATIONS -OTHER                        2,489        1,654          1,530                216                  0                0         ~
56100-53408-      POSTAGE                                       10,584       12,955         20,603              6,110             12,000           12,000      fJ~~000

Date: 11/8/2016                    W:~Munis\MCR Library\Budget reports\New Fiscal Year budget worksheet -Dept Req-enterprise by sal-exp.rpt
                                                                                                                                                                                  Page: 5

Source page 11

TOWN OF CANTON
     BUDGET REPORT FOR FY 2018                                FY 14         FY 15          FY 16        ACTUAL YTD           ORIGINAL           FY 2018          FY 2018       COMMENT/REASON FOR
                                                            ACTUAL         ACTUAL        ACTUAL        EXPENSE TfIRU          BUDGET        DEPARTMENTAL          DEPT          INCREASE /DECREASE
    DEPARTMENTAL WORKSHEETS                                 EXPENSE        EXPENSE       EaPENSE          9!30/2016            py~~          BASE BUDGET        REQUEST

56100-5340D-      ADVERTISING                                       0             0            100                 0                 600              600
56100-53411-      WELL MONITORING SYSTEM(SCADA)                                                                                                               6OO
                                                                1,900        2,167               0             2,300               7,500
56100-54011-      TOOLS&HARDWARE                                                                                                                    7,500     ~S~
                                                              13,902        23,886         31,357             ]3,877             ]8,000
56100-54200-      OFFICE SUPPLIES                                                                                                                  18,000    ra~
                                                               5,365         4,579          6,945              1,705               4,500
56100-54801-      GASOLINE &OIL                                                                                                                     4,500      ~f SpO
                                                              14,761         8,487          6,453              1,213              14,000
56100-54806-      DIESEL FUEL                                                                                                                      14,000     ~`f,~~
                                                              29,933        25,971         ]4,249              3,925             24,000
56100-54901-      MEALS                                                                                                                           24,000      ~~~
                                                                 980            800          1,200                 0                 500
56100-55303-      TRENCH MATERIALS                                                                                                                    500       50~
                                                                  115         1,810         7,621                891               8,000                       gr poo
56100-55304-      CHEMICALS                                                                                                                         8,000
                                                             250,178       190,177        193,225             16,218            270,000                      1-'~o aoo
56100-55305-      METERS &PARTS                                                                                                                  270,000
                                                              70,864        26,197          7,386              4,343             40,000                        ~fo oo~
56100-55306-      BITUMINOUS MATERIALS                                                                                                            40,000
                                                              13,642        11,307         15,514              3,548             15,000
56]00-55308-      PIPES &FITTINGS                                                                                                                 15,000        ~t ~~
                                                              16,893        27,569         17,655             12,316             17,000
56100-55309-      HYDRANT'S &VALUES                                                                                                               17,000    ~         a
                                                               2,892        31,653         41,348             19,108             18,000
56100-558oC-      DATA PROCESSING SUPPLIES                                                                                                        18,000    ~~.o~
                                                                    0           198           220                  0               1,000            1,000
56100-5580E-      WORK SHOES                                                                                                                                     ~ - ~o
                                                               1,477          1,406          1,441               150               1,200
56100-SS8oP-      FOiJL WEATHER GEAR                                                                                                                1,200        ~~
                                                                    0             0            194                 0               1,500            1,500
56100-56000-      TAXES-TOWN OF STOUGHTON                                                                                                                       ~~ Sod
                                                               3,331         3,331          3,331                  0               5,500                           ~ o0
56100-57000-      OTHER CHARGES/EXPENDITURE                                                                                                         5,500
                                                              13,12]              0              0                 0                 525              525         Sa-S
56100-57105-      IN-STATE TRAVEL                                   0             0              3                 0                   0                0           ~
56100-5710C-      MEETINGS                                     2,574         6,780            355                  0               1,200            ],200       ~
56100-57300-      DUES &MEMBERSHIPS                            2,265         2,344          1,734                115                 750              750
56100-57800-      CONTINGENCIES                                2,415         3,938         28,677                  0             25,000           25,000     ~~'~
56100-57802-      HEAVY EQUIPMENT LICENSES                       449         1,621          1,854               405                  800              800        g~~
56100-57807-      WELL #9 OPERATING COSTS                           0             0              0                 0             10,000           10,000      ~~,~~
56100-57819-      PIPELINEASSISTANCEPROGRAM                         0             0              0                 0               5,335            5,335      S 3S
56100-57840-      US GEOLOGICAL SURVEY EXPENSE                16,880        16,700         20,875                  0             19,000           19,000         ~    ea
56100-58106-      REPLACEMENT EQUIPMENT                            0              0         3,000                  0                   0                0            ~
56100-58500-      EQUIPMENT PURCHASE                           1,575              0              0           34,921              30,000           30,000
56100-58936-      DEPASSESSMENT CHARGES                        7,547         6,812          7,025                  0              8,000             8,000       ~- o~      ~
56100-58937-      MWRACHARGES                              1,426,900     1,004,356      1,299,628           546,803           1,680,349        1,680,349      f 680
56100-59610-      TRANSFER TO GENERAL FiJND                 756,170       620,022        975,960            127,635            510,539          510,539      _~~`L~G~~          ._._    •"/
                                                                                                                                                                           ~     ~,`   ~!1
         SUBTOTAL     EXPENSES                          $3,176,423      $2,600,958    $3,293,451          $936,975         $3,178,648        $3   ,648      ~'~Z~~
         SUBTOTAL WATER ENTERPRISE                      $3,998,368      $3,405,301    $4,152,967         $1,132,010        $4,090,502        $4,105,432       ~! ~ ~L      ~ ~~t           ~~~~~


                                                                                                                                              Dept Head Signature /Date


Datc: 11/8/2016                  W:\Munis\MCR Library\Budget reports\New Fiscal Year budget worksheet -Dept Req-enterprise by sal-exp.rpt
                                                                                                                                                                                 Page: 6

Source page 12

SALARY PROJECT                   - FY18



                                                                                                                                                                                                       FY17 Pay     FY18    FY18     FV18                        FV18
 Emp #          Lan Name                                                                                                                                                FY17 Hrs Per    FY17 Pay     Annual5alary   Next    Next    Hourly
                                    First Name                !ob Class Desc                 Location Dest                                                                                                                                    FY38 Annual      Estimated
                                                                                                             Group/BU   Org    Object   Status   Pay Grade   Pay Step      Year        Hourly Rate     260 days
 ~Laraat WI@kNEM                                                                                                                                                                                                    Grade   Step     Rate    Salary 260 days   Longevity
                                                 GISANALYST                          ENGINEERING -WATER        AF4    56100 51000       Ff          17          3          624              31.10         19,406     17      3
     7          IL           1            C/'/                                                                                                                                                                                       31.10          19,406             0
                                                                                                                   56100 Count
                                                                                                                            51000 Total                                                                   19,406
 297      KIELY                  BRIAN           WATER FOREMAN                                                                                                                                                                                      19,406            0
                                                                                     WATER                      AF    56100 51120       FT          17          6          2080
 1479     MORTON                                                                                                                                                                            38.42         79,914     17      6       38.42          79,914        1,500
                                 DENNIS          WATER/SEWER SUPERVISOR              WATER                     AFS    56100 51120       FT          19          6          1040             37.12         38,605     18      6       37.12          38,605          200
                            z                                                                                      56100 Count
                                                                                                                            51120 Total                                                                  118,518
12       ARMANDO                 GARY            SKILLED LABORER/TRUCK DRIVER        WATER                                                                                                                                                        118,518         1,700
                                                                                                                AF    56100 51123       Fi         10          6           2080             25.59         53,227
36       BOGUE                   LAWRENCE                                                                                                                                                                            10      6       25.59         53,227         1,000
                                                 UTILITIES MAINTENANCETECHNICI       WATER                      AF    56100 51123       Fi         14          6           2080             32.29         67,163     14      6       32.29
381      MCCARRICK               STEVEN          SERVICE TECHNICIAN                                                                                                                                                                                67,163         1,500
                                                                                     WATER                      AF    56100 51123       FT         14          6           2080
1653     REDQUEST                                                                                                                                                                           32.29         67,163     14      6       32.29         67,163         1,750
                                 SCOTT           SPECIAL HEAW EQUIP OPERATOR         WATER                     AF4    56100 51123       Ff         13          3           2080             24.65         51,272     13      4       25.64
1474     RUANE                   RENEE           METER READER                                                                                                                                                                                      53,323             0
                                                                                     WATER                     AF4    56100 51123       FT          9          6           2080
697      SMITH                                                                                                                                                                              21.96         45,677     9       6       21.96         45,677           400
                                 JOSEPH          UTILITIES MAINTENANCETECHNICI       WATER                      AF    56100 51123       Ff         14          6           2080             32.29         67,163     14      6       32.29
1184     SYKES                   CHRISTOPHER     UTILITIES MAINTENANCETECHNICI                                                                                                                                                                     67,163         1,000
                                                                                     WATER                     AF4    56100 51123       Ff         14          6           2080
Vacant   VACANCY                                                                                                                                                                            29.39         61,131     14      6       2939          61,131          600
                                 VAE    !        hTCT£fFR`E~D~t '~         p   yy~    ATER                     AF4    56100 51123       Ff         9           6           2080             21.96         45,677
Vacan[   VACANCY                 VACANCY         U7ILITIESMAINTENANCETECHNICI                                                                                                                                                                                         0.~
                                                                                     WATER                     AF     56100 51123       Ff         14          6           2080
                            9
                                                                                                                                                                                            3219          67,163     14      6        32.29        67,163             0 ~~
                                                                                                                   56100 Count                                                                                                      ~~' " (~
                                                                                                                            51123 Total                                                                  525,637            ,,, ~
1241     LEVREAULT               PHILIP          STAFF ENGINEER                                                                                                                                                                                                   6,250
                                                                                     ENGINEERING- WATER        P84    56100 51135       FT         15A         6           728              34.17         24,876    15A      6       34.85          25,373            0
                            1                                                                                      56100 Count
                                                                                                                            51135 Total                                                                   24,876
 1469    JERRIER                 MICHAEL                                                                                                                                                                                                            25,373            0
                                                 WATER &SEWER ACCT COORDINATOR       WATER                     AF4    56100 51142       FT          9          6           1040             21.96         22,838     9       6       21.96          22,838          200
                            1                                                                                      56100 Count
                                                                                                                            51142 Total                                                                   22,838
1359     CAWLEY                  PATRICIA        WATER/SEWER OFFICEADMINSTRATO                                                                                                                                                                     22,838           200
                                                                                     WATER                     AF4    56100 51143       Ff         16B          1         1040              27.11         28,194    16B      3       29.32         30,495             0
                            1                                                                                      56100 Count
                                                                                                                            51143 Total                                                                   28,194                                   30,495             0
                                                                                                                   56300 Total                                                                           739,470                                                  8,150


                                                                                                     acid ?R.eafine/1~ foaeMatn                              t7-3          ,
                                                                                                                                                                           C 6~ l~`~




Payroll Projections FY18.xlsx MUNIS download for FY18
                                                                                                                                                                                                                                    -c- ~7
11/14/2016 12:38 PM
                                                                                                                                                                                                                                                                  34 OF 35

Source page 13

G~afer~-

      TOWN OF CANTON
  BUDGET REPORT FOR FY 2018                                   Fria           FY IS        FY 16          ACTUAL YTD          ORIGINAL            FY 2018           FY 2018                 COMMENT/REASON FOR
                                                            ACTUAL         ACTUAL        ACTUAL         EXPENSE THRU          BUDGET         DEPARTMENTAL           DEPT                    INCREASE/DECREASE
 DEPARTMENTAL WORKSHEETS                                    ExrEHSE        EXPENSE       EXPENSE           9/30/2016           py 1~          SASE BUDGET         REQUEST
~1~~~`~~~.~"
                                                                                                                                                                            ~ ~•_
56102-59101-       PRINC PD-OS/11 DEBT                        269,000      269,000        268,000                  0            255,000          255,000
56102-59]06-       PRIM PD-3/IS DEBT                                0            0         71,250                                                                  o?:~~J
                                                                                                                   0             70,000           70,000
56102-59107-       INT PD-03/15 DEBT                                0            0         18,538                                                                          ;~~
                                                                                                               8,200             16,400           16,400
56102-59109-       PKINCIPAL PAID TO MWRA                      91,000      200,000                                                                                     ., -, j -~
                                                                                          200,000            109,000            200,000          200,000
56102-59127-       PRINC PD-01/06 DEBT                         53,000            0              0                  0                  0                0
56102-59128-       PRINC PD-01/08 DEBT                        126,000      126,000        126,000                  0             97,000           97,000
56102-59130-       PRINCIPAL PAYDOWNS                               0       30,000              0                  0                  0                0
56102-5913]-       PRINC PD-3/12 DEBT                         190,000      190,000        190,000                  0                                          !?~, ~ ~:~
                                                                                                                                190,000          190,000
56102-59132-       PRINC PD-03/13 DEBT                        180,800      179,000        178,000                  0                                              o^ ;d'?~
                                                                                                                                179,000          179,000
56102-59133-       PRINC PD-11/13 DEBT                              0       84,400         81,800                  0                                                "~ ~:~~
                                                                                                                                 80,700           80,700
56102-59135-       PRIN PD-03/14 DEBT                               0      203,100        202,700                  0            202,700          202,700
56102-59137-       PRINC PD - OS/]0 DEBT                      248,000      248,000        248,000                  0                                              '
                                                                                                                                                                  -~       Q ~ ~l
                                                                                                                                247,000          247,000
56102-59138-       PRINC PD - 05/09 DEBT                       95,000       95,000         95,000                  0             95,000                           v"~:     ~~~~
                                                                                                                                                  95,000
56102-59141-       PRINC PD-03/04 DEBT                        102,440            0              0                  0                  0                0
56102-59142-       PRINC PD-03/08 DEBT                         50,000       48,000         48,000                  0             47,000                                      >-?~
                                                                                                                                                  47,000
56102-59145-       INT PD-03/16 DEBT                                0            0              0              3,835                  0                0               _- •_ a -a
56102-59150-       INTEREST PD OS/I 1                         164,749      159,369        148,609                  0            140,569          140,569
56102-59175-       INT PD-01/06 DEBT                           26,613            0              0                  0                  0                0
56102-59176-       INT PD-01/08 DEBT                           35,326       30,916         32,013                  0             22,096                                      b
                                                                                                                                                  22,096
56102-59176-       INT PD - 05/09 DEBT                         53,353       51,215         48,840                  0             45,990           45,990
56102-59179-       INT PD - OS/10 DEBT                        127,589      122,629        115,189                  0            107,749          107,749
56102-59181-       INT PD - 3/12 DEBT                         106,400      102,600         96,900             45,600             91,200                                 <FO
                                                                                                                                                                         '
                                                                                                                                                  91,200
56102-59182-       INT PD - 03/13 DEBT                         99,373       93,949         88,579             41,619             83,238                           -r ~, 8'69
                                                                                                                                                  83,238
56102-59183-       INTPD-11/13 DEBT                             3,670       25,195         20,344              7,252             18,29]           18,291
56102-59185-       INT PD-03/14 DEBT                                0      109,148         98,993             44,429             88,857                           -~ ~ ~ ~3
                                                                                                                                                  88,857
56102-59191-       INT PD-03/04 DEBT                           40,854            0              0                  0                  0                0
56102-59192-       INT PD-03/08 DEBT                            7,475        5,600          3,800                  0              1,880            ],880
56102-59250-       INTEREST TEMPORARY LOANS                    19,688        7,950              0                  0             26,000                                     Q~l
                                                                                                                                                  26,000
         SUBTOTAL      EXPENSES                          $2,090,328     $2,381,070    $2,380,554           $259,935        $2,305,670         $2,305,670
         SUBTOTAL WATER PRINC/INT PAYMENTS
                                                                                                                                                              ~3s`~ G ~~                  v
                                                         $2,090,328     $2,381,070     $2,380,554           X259,935        $2,305,670        $2,305,670           ~

                                                                                                                                                                                    1
                                                                                                                                                                                        ~~~,b
                                                                                                                                                 ept Head Siena    e /Date




 Date- 11/8/2016                  W~~Munis\MCR Library\Budget reports\New Fiscal Year budget worksheet -Dept Req-enterprise by sal-exp.rpt
                                                                                                                                                                                                Page: 7

Source page 14

DEBT SERVICE PROJECTIONS -DEBT IN PIPELINE


AUTHORIZED      Project                                                                    AUTHORIZED TERM      BOND     BAN     BOND                         FY
   DATE    ART# Code                                     PURPOSE                            UNISSUED   YRS      DATE     RATE    RATE     INT       PRIN     2018

 4/29/1998    23           SEPTIC TITLE V                                                      200,000    N/A    N/A     N/A     NIA         0          0       0
 4!30/2007   15-6          ADA RENOVATIONS (balance)                                            50,000    N/A    N/A     1.00%   N!A         0          0       0
 511312013    32     A1476 HANSEN SCHOOL WINDOWS (balance)                                     481,295    N/A    N/A     N/A     N/A         0          0       0
 5/13/2013    33     A1477 GALVIN MIDDLE SCHOOL WINDOWS (balance)                              749,322    N/A    N/A     N/A     N/A         0          0       0
 5/18/2015   12-4          DPW GARAGE SECURITY SYSTEM                                           60,000     5     N!A     1.00%   N/A         0          0       0
 5/18/2015   12-4          OLD SHEPARD STREET DAM REPAIR                                        75,000     5     N/A     1.00%   N/A         0          0       0
  5/9/2016   12-4    A1708 REPLACE FIRE ENGINE                                                 700,000    10    Mar-17   2.00%   3.50%      25         70      95
  5/9/2016   12-5    A1709 SCHOOL TURF FIELD &TRACK                                            610,000    10    Mar-17   2.00%   3.50%      21         61      82
  5/9/2016   12-5    A1710 SCHOOL PHONE SYSTEM                                                 258,388     5    Mar-17   2.00%   3.50%       9         52      61
                                                    TOTAL INSIDE LEVY                         3,184,005                                      55        183    238


 5/9/2016    12-4    A1711 REPLACE FIRE AMBULANCE                                              284,000    5     Mar-17   2.00%    3.50%     10         57      67

                                                    TOTAL AMBULANCE                            284,000                                       70        57      67


 5/18/2015    35     A1644 HANSEN SCHOOL ADDITION                                            4,100,000    20    Mar-17   2.00%    3.50%    144       205      349

                                                   TOTAL OUTSIDE LEVY                        4,100,000                                      144        205    349

 5/11/2015    6           LAND PURCHASE (subject to land being cleaned up by developer)       1,740,000   10    Mar-19   2.00%    4.00%      0          0       0

                                            TOTAL COMMUNITY PRESERVATION                      1,740,000                                         0       0       0

 5/1112015    4           DISTRICT IMPROVEMENTS (Plymouth Rubber site)                       8,597,000    20    Mar-20   2.50%   4.00%       0          0      0
 5!9/2016     42          DISTRICT IMPROVEMENTS (Eversource Property)                          250,000    10    Mar-19   2.00%   4.00%       0          0      0

                                           TOTAL DISTRICT IMPROVEMENT FUND                   8,847,000                                          0       0       0

 5/18/2015   12-7    A1631 WATER MAINS -MECHANIC STREET                                      2,630,000    20    Mar-17   2.00%    3.50%     92       132      224
                                                      TOTAL WATER                            2.,630,000                                      92        132    224

  5/1/2000   15-12      SEWER I &                                                              719,790    20    N/A      N/A     N/A         0          0      0
 4/30/2008   13-9 A1356 SCADA UPGRADE &TRUCKS (balance)                                        145,000    10    N/A      N/A     N/A         0          0      0
                                                      TOTAL SEWER                              864,790                                          0       0       0


 5/13!2013   11-12        RINK COMPRESSOR &GLYCOL TANK                                         245,000    15    N/A      N/A     N/A            0       0       0
                                      GRAND TOTALS-AUTHORIZEDIUNISSUED DEBT




         AUTHDEBT.xlsx                                                          PIPELINE                                                  11/28/2016

Source page 15

DEBT SERVICE PAYMENTS FROM FY 77 THRU FY 35
       Date of                                                                          7/1/2016        Debt Service        Type of
No.     Issue  Type                        Description                                  Debt O/5       Org      Object     Payment       2017              2018
41     5/1/2011 W GOB Water Treatment Facility (Self-Supporting)                          3,750,000   56102     59101      Principal   250,000.00        250,000.00
42     5/1/2011 W GOB Water Mains (Self-Supporting)                                          75,000   56102     59101      Principal      5,000.00          5,000.00
                                                                                                            59101 Total                255,000.00        255,OD0.00
139 3/15/2015     W   Water Meters                                                         443,000    56102     59106      Principal    57,000.00         56,000.00
140 3/15/2015     W   Water Meters                                                         117,000    56102     59106      Principal    13,000.00         13,000.00
                                                                                                             59106 Total                70,000.00         69,000.00
139 3/15/2015     W   Water Meters                                                                    56102     59107      Interest     13,020.00         11,310.00
140 3/15/2015     W   Water Meters                                                                    56102     59107      Interest       3,380.00          2,990.00
                                                                                                             59107 Total                16,400.00         14,300.00
31 11/15/2010     W   WRA Water (Self-Supporting)                                          205,000    56102     59109      Principal    41,000.00         41,000.00
31 11/15/2010     W   WRA Water (Self-Supporting)                                                     56102     59109      Interest            -                 -
60   5/7/2012     W   WRA Water (Self-Supporting)                                          300,000    56102     59109      Principal    50,000.00         50,000.00
60   5/7/2012     W   WRA Water (Self-Supporting)                                                     56102     59109      Interest            -                 -
76 8/19/2013      W   MWRA Tolman Water Tank -interest free                                872,000    56102     59109      Principal   109,000.00        109,000.00
76 8/19/2013      W   MWRA Tolman Water Tank -interest free                                           56102     59109      Interest            -                 -
                                                                                                            59109 Total                200,000.00        200,000.00
58    3/27/2012   W   GOB Water Treatment Facility (Self-Supporting)                     3,040,000    56102     59131      Principal   190,000.00        190,000.00
                                                                                                            59131 Total                190,000.00        190,000.00
69    3/15/2013   W   GOB Water Mains (Self-Supporting)                                     78,000    56102     59132      Principal    12,000.00         11,000.00
70    3/15/2013   W   GOB Water Mains (Self-Supporting)                                    417,000    56102     59132      Principal    24,000.00         24,000.00
71    3/15/2013   W   GOB Water Mains (Self-Supporting)                                  2,128,000    56102     59132      Principal   124,000.00        124,000.00
72    3/15/2013   W   GOB Well (Self-Supporting)                                           128,000    56102     59132      Principal    19,000.00         19,000.00
                                                                                                            59132 Total                179,000.00        178,000.00
90 11/13/2013     W   Water (Refunding)                                                     14,700    56102     59133      Principal      3,800.00          3,800.00
91 11/13/2013     W   Pumping Station (Refunding)                                           61,300    56102     59133      Principal    16,200.00         16,000.00
92 11/13/2013     W   Well Rehab (Refunding)                                                33,000    56102     59133      Principal     8,600.00           8,500.00
104 11/13/2013    W   Water Mains (Self-Supporting) -(Refunding)                           145,200    56102     59133      Principal    16,800.00         16,600.00
105 11/13/2013    W   Water Mains (Self-Supporting) -(Refunding)                           305,100    56102     59133      Principal    35,300.00         34,500.00
                                                                                                            59133 Total                 80,700.00         79,400.00
108   3/15/2014   W   Water Mains (Self-Supporting)                                      1,220,000    56102     59135      Principal    90,000.00         90,000.00
109   3/15/2014   W   Well (Self-Supporting)                                               375,000    56102     59135      Principal    50,000.00         50,000.00
122   3/15/2014   W   Well (Self-Supporting)(Refunding)                                    205,000    56102     59135      Principal    26,900.00         26,800.00
123   3/15/2014   W   Well (Self-Supporting)(Refunding)                                    143,000    56102     59135      Principal    17,900.00         17,800.00
124   3/15/2014   W   Well (Self-Supporting)(Refunding)                                    143,000    56102    59135       Principal    17,900.00         17,800.00
                                                                                                            59135 Total                202,700.00        202,400.00
25    5/15/2010   W   GOB Departmental Equipment - Pubiic Works (Self-Supporting)          104,000    56102    59137       Principal    26,000.00         26,000.00
26    5/15/2010   W   GOB Water (Self-Supporting)                                          214,000    56102    59137       Principal    16,000.00         16,000.00
27    5/15/2010   W   GOB Water Treatment Facility (Self-Supporting)                     1,540,000    56102    59137       Principal   110,000.00        110,000.00
28    5/15/2010   W   GOB Water Mains (Self-Supporting)                                    770,000    56102    59137       Principal    55,000.00         55,000.00
29    5/15/2010   W   GOB Water Mains (Self-Supporting)                                    560,000    56102    59137       Principal    40,000.00         40,000.00
                                                                                                            59137 Total                247,000.00        247,000.00
17    5/15/2009   W   GOB Water Mains (Self-Supporting)                                    973,000    56102    59138       Principal    75,000.00         75,000.00
18    5/15/2009   W   GOB Water Mains (Self-Supporting)                                    260,000    56102    59138       Principal    20,000.00         20,000.00
                                                                                                            59138 Total                 95,000.00         95,000.00
2     3/15/2008   W   GOB Water REFUNDING (Self-Supporting)                                 24,000    56102    59142       Principal    24,000.00                -
3     3/15/2008   W   GOB Well Fieid Development REFUNDING (Self-Supporting)                23,000    56102    59142       Principal    23,000.00                -
                                                                                                            59142 Total                 47,000.00                -
161 3/17/2016     W   GOB Water Mains (Self-Supporting)(Refunding)                         544,000    56102    59144       Principal    64,000.00         59,000.00
162 3/17/2016     W   GOB Water Departmental Equipment(Refunding)                           41,000    56102    59144       Principal    41,000.00    -
                                                                                                            59144Total                 105,000.00         59,000.00
161 3/17/2016     W   GOB Water Mains (Self-Supporting)(Refunding)                                    56102    59145       Interest      9,006.22          9,600.00
162 3/17/2016     W   GOB Water Departmental Equipment (Refunding)                                    56102    59145       Interest        678.78    -
                                                                                                            59145 Total                  9,685.00          9,600.00
41     5/1/2011   W   GOB Water Treatment Facility (Self-Supporting)                                  56102    59150       Interest    137,812.50        130,312.50
42     5/1/2011   W   GOB Water Mains (Self-Supporting)                                               56102    59150       Interest      2,756.25          2,606.25
                                                                                                            59150 Total                140,568.75        132,918.75
17    5/15/2009   W   GOB Water Mains (Self-Supporting)                                               56102    59178       Interest     36,290.00         34,040.00
18    5/15/2009   W   GOB Water Mains (Self-Supporting)                                               56102    59178       Interest      9,700.00          9,100.00
                                                                                                            59178 Total                 45,990.00         43,140.00
25    5/15/2010   W   GOB Departmental Equipment -Public Works (Self-Supporting)                      56102    59179       Interest      3,022.50          2,242.50
26    5/15/2010   W   GOB Water (Self-Supporting)                                                     56102    59179       Interest      7,248.75          6,768.75
27    5/15/2010   W   GOB Water Treatment Facility (Self-Supporting)                                  56102    59179       Interest     52,305.00         49,005.00
28    5/15/2010   W   GOB Water Mains (Self-Supporting)                                               56102    59179       Interest     26,152.50         24,502.50
29    5/15/2010   W   GOB Water Mains (Self-Supporting)                                               56102    59179       Interest     19,020.00         17,820.00
                                                                                                            59179 Total                107,748.75        100,338.75
58    3/27/2012   W   GOB Water Treatment Facility (Self-Supporting)                                  56102    59181       Interest     91,200.00         87,400.00
                                                                                                            59181 Total                 91,200.00         87,400.00
69    3/15/2013   W   GOB Water Mains (Self-Supporting)                                               56102    59182       Interest      2,560.00          2,200.00
70    3/15/2013   W   GOB Water Mains (Self-Supporting)                                               56102    59182       Interest     12,521.15         11,801.25
71    3/15/2013   W   GOB Water Mains (Self-Supporting)                                               56102    59182       Interest     63,957.50         60,237.50
72    3/15/2013   W   GOB Well (Self-Supporting)                                                      56102    59182       Interest      4,200.00          3,630.00

          AUTHDEBT.xlsx                                                             1                                                        8/29!2016

Source page 16

DEBT SERVICE PAYMENTS FROM FY 77 THRU FY 35
       Date of                                                                        7/1/2016     Debt Service       Type of
No.     Issue     Type                            Description                         Debt O/S    Org      Object     Payment    2017             2018
                                                                                                       59182 Total               83,238.65        77,868.75
90 11/13/2013      W     Water(Refunding)                                                        56102     59183      Interest      512.00           360.00
91 11/13/2013      W     Pumping Station (Refunding)                                             56102     59183      Interest    2,128.00         1,484.00
92 11/13/2013      W     Well Rehab (Refunding)                                                  56102     59183      Interest    1,148.00           806.00
104 11/13/2013     W     Water Mains Self-Supporting) - (Refunding)                              56102     59183      Interest    4,676.00         4,172.00
105 11/13/2013     W     Water Mains (Self-Supporting) - (Refunding)                             56102     59183      Interest    9,827.00         8,768.00
                                                                                                       59183 Total               18,291.00        15,590.00
108   3/15/2014    W     Water Mains (Self-Supporting)                                           56102     59185      Interest   48,125.00        43,625.00
109   3/15/2014    W     Well(Self-Supporting)                                                   56102     59185      Interest   17,625.00        15,125.00
122   3/15/2014    W     Well (Self-Supporting)(Refunding)                                       56102     59185      Interest    9,702.50         8,357.50
123   3/15/2014    W     Well (Self-Supporting)(Refunding)                                       56102     59185      Interest    6,702.50         5,807.50
124   3/15/2014    W     Well (Self-Supporting)(Refunding)                                       56102     59185      Interest    6,702.50         5,807.50
                                                                                                       59185 Total               88,857.50        78,722.50
2     3/15/2008    W     GOB Water REFUNDING (Self-Supporting)                                   56102     59192      Interest      960.00              -
3     3/15/2008    W     GOB Well Field Development REFUNDING (Self-Supporting)                  56102     59192      Interest      920.00              -
                                                                                                        59192 Totai               1,880.00              -




          A UTHDEBT.xlsx                                                          2                                                   8/29/2016