Canton, Massachusetts · Saved source text
FY21 Municipal Budget - Dept Requests - Jan 2020 pdf file
Saved text from 193 source pages. Transcription and OCR may contain errors; verify figures and wording against the original. Retrieved 2026-10-15.
Source page 161
TOWN OF CANTON FY 17 FY IS FY 19 ORIGINAL FY 2021 FY 2021 COMD'IENT/REASON FOR
ACTUAL ACTUAL ACTUAL BUDGET ACTUAL YTD BASE DEPT. iNCREpgE/DECREASE
BUDGET REPORT FOR FY 2021 EXPENSE EXPENSE EXPENSE FY 20 EXPENSESTHRU BUDGET RGQUCST
DEPARTMENTAL WORKSHEETS 9/30/19
911 RETIREMENT BENEFITS
19111 - 51780 NORFOLK COUNTY RETIREMENT 4,393,622 4,796,247 5,245,794 5,635,051 5,635,051 5,635,051 ~U v 3 r ~ ~ JO
19111 - 51790 DISABILITY PENSION 3,667 3,667 3,667 3,700 917 3,700 ~ ~o O
SUBTOTAL SALARIES &WAGES $ 4,397289 $4,799,914 $5,249,461 $5,638,751 $5,635,968 $5,638,751
TOTAL 911 RETIREMENT BENEFITS $ 4,397,289 $4,799,914 $5,249,461 $5,638,751 $5,635,968 $5,638,751 D
', " a' ~ /~~ ~,
l
Department Head signature /Date
?~'1'
J"/'~~ ~ x.1._1 ~
~~~~^ ~J` ~
,s,/~~
G``~ r ~ ~
Date: ]0/16/20]9 Page: 118
i
U~Source page 162
Norfolic County Coratj'ibacto~y Retir'enzent System Page 42
breok by pay.xlsz}Output
C;~Users\Dnn SfiermanbneDrive - Shernun Actuariol Service, LLG1Reaovered DalalNarfolklVel I S~jNarColkl B_ cost
Breakouts -July Lump Sum Payment
Actives Fisca12021
Participants Payz-oll Appropriation
Avon Housing Auth, 1 $ 50,770 $ 13,558
Town of Avon I03 5,252,001 1,419,905
Town of Bellix~ghain 263 13,162,759 3,561,600
Bellingham Hous. Auth, 2 125,424 33,493
Town of Canton 390 22,020,861 6,031,916
Canton Housing Auth. 6 328,967 97,919
Cohasset Housing Auth, 1 61,506 18,510
Tovvn of Cohasset 179 9,b88,873 2,636,498
Charles Riv, Poll. Cont. 11 691,756 188,839
County of Norfolk 138 8,673,779 2,650,746
Retired Sheriffs 0 0 1,410,159
Town of Dover 101 5,699,731 ~ 1,522,061
Dover/Shearbor~ie Schl. 81 3,531,196 942,974
Foxboro Housing Auth. 6 297,205 86,172
Franklin Housing Auth. 6 348,841 98,327
To~svn ofFoxboro 363 19,038,711 5,185,943
Town of Franklin 457 22,986,553 6,174,365
Holbrook Housing Autl~ 2 ~ 135,187 A4,290
Town ofHolbroolc 131 8,405,958 2,291,969
Massachusetts Respiratory 0 - -
Ki~ig Phillip Reg School 72 3,012,508 804,463
Towzi of Medway 209 10,541,235 2;811,941Source page 163
~~~ p
~ oJN~y ReTiRFM~~
Norfolk County Retirement System
o ~
~ ~ ~ ~+
O m
Z ~
~T ^~
PPS„
December 27,2019
o~~-~-~~n~ D1
9eC~SNED JANU
~r~: ~~' 2019
To: Board of Selectmen
Town of Canton BOARD OF SELECTMEN
ca~ ~ ~ - ,~.: ~.~r~
James E. ~milty From: Norfolk County Retirement System
Chairman /measurer
Josephine E. Shea
Elected Member Subj: Town of Canton.
Karen F. Jelloe Fiscal Year 2021 Appropriation
Appointed Member
Paul J. Connors The Norfolk County Retirement System has received several inquiries relative to the
Appointed Member member unit appropriation amounts for Fiscal Year 2021. We have received the
Edwin S. Little appropriation figures. The units have two payment options,
Elected Member
1) Paying the appropriation in two equal payments, one due on July 1, 2020 and
the second due on January 1, 2021,
2) Paying the appropriation in a single payment on July 1, 2020 at a reduced
Kathleen Kiely-B~chetti, Esq.
rate, approximately 2%less than option 1.
The amounts of each are set forth below. Please note that your Fiscal Year 2021
appropriation includes prior Early Retirement Incentives (ERIs), where applicable.
Option 1: $6,144,464.00 payable in two equal payments of
$3,072,232.00, the first on July 1, 2020 and the second on
January 1, 2021.
Option 2: $ 6,031,916.00 due in full on July 1, 2020.
The actual appropriation bills will be sent out at a later date.
Please note if you have wired your payment in the past,
we have changed our Custodian Bank to:
People's United Bank /Bank of New York Mellon.
We willpf~ovic~e updated wire.instNuctions on the FY2021 bill.
We hope the above information is helpful. If you have any questions, please contact
Patrick LePage at 781-821-0664. Thank you.
480 Neponset Street, Building #15, Canton, MA 02021 •Tel: 781-821-0664 ~ 800-247-9992 ~ Fax: 781-821-0981
w ww.norfolkcountyretirement.org •Email: info~norfolkcountyretirement.org
e GcrnBy- 7SCSource page 164
FY l7 PY 18 rl']9 ORIGINAL rl'2021 FY 2021 CObI111~NT/REASON GOR
TOWN OF CANTON ACT[lAL YTD BASE DEPT.
~LTUAL wcrunc. ,~cruni, suncET INCREASE / DGCRF,ASE
BUDGET REPORT FOR FY 2021 EXPENSE E%1'ENSE CXPENSE GY 20 ~\PLNSHS TQRU UU~GGT REQIfLS'f
9!30/19
DEPARTMENTAL WORIfSHEET5
913 UNEMPLOYMENT COMPENSATION
19131 - 51720 UNEMPLOYMENT COMPENSATIO 100,000 100,000 100,000 I00,000 100,000 100,000
SUBTOTAL SALARIES Rc WAGES ~ 100,000 5100,000 $100,00D $100,000 X100,000 $100,000
TOTAL 913 iJN~MPLOYMENT COA~IP~NSAT ~ 100,000 $100,000 X100,000 X100,000 $100,000 $100,000
_~Tl
Department Head signature /Date
Dnte: 10/1612019 Pagc: ]19Source page 165
FISCAL 2021 DEPARTMENTAL OPERATING BUDGETS
PROJECTION: 2021 FY 2021 BASE BUDGET
2019 2020 2021 2021
ACCOUNTS FOR: ACTUAL ORIG BUD BASE BUDGET DEPT. REQ. COMMENT
19141 HEALTH INSURANCE SALARIES
19141 51730 HEALTH INSURANCE OPT OUT 44,387 49,000 49,000 49,000
19141 51732 MEDEX EMPLOYER SHARE 1,474,634 1,477,158 1,477,158 1,458,637
19141 51733 DENTAL HEALTH PLAN 480,025 472,598 472,598 480,218
19141 51735 H MO BLUE-EMPLOYER SHARE 6,990,974 6,928,877 6,928,877 7,300,558
19141 51737 PPO BCBS EMPLOYER SHARE 2,605,190 2,632,476 2,632,476 2,730,381
19141 51740 MEDICARE EMPLOYER SHARE 767,132 767,980 767,980 805,488
19141 51741 MEDICARE PART B PENALTY 43,866 50,000 50,000 50,000
19141 57000 OTHER CHARGES/EXPENDITURE 13,674 70,000 70,000 20,000
TOTAL HEALTH INSURANCE SALAR 12,419,882 12,44$,089 12,448,089 12,894,282
TOTAL EMPLOYER SHARE-HEALTH 12,419,882 12,448,089 12,448,089 12,894,282
~~ ti
1 ~ (!/ ~f
'~~-
Fy 21 budget worksheets.xlsx municipal 11/12/2019Source page 166
FISCAL 2021 HEALTH INSURANCE BUDGET
A B C D E F G H I J K L M N O
3)(4) (5)
PPO PLAN HMO BLUE HEALTH DELTA DENTAL DENTAL PART B OPT OUT OTHER
MONTH INDIV FAMILY INDIV FAMILY MEDEX TOTALS INDIV FAMILY TOTALS MEDICARE PENALTY STIPENDS CHARGES TOTALS
4 i
5 ESTIMATED MEMBERSHIP FY 21 (1) 59 73 174 299 475 1 080 415 557 972
7
MONTHLY COSTS - FY 20 100%) 1,207.50 2 864.50 813.54 2 138.30 334.57 23.10 78.54
ESTIMATED %INCREASE IN RATES (2) 8.0% 8.0% 4.0% 4.0% 2.0% 0.0% 0.0%
1 MONTHLY COSTS - FY 21 1,304.10 3,093.66 846.08 2,223.83 341.26 23.10 78.54
4 TOWN'S MONTHLY SHARE - FY 21 (75%) 978.08 2 320.25 634.56 1 667.87 255.95 17.33 58.91
ESTINWTED ANNUAL EXPENSE 688 565 2041 816 1 326,233 5 974 325 1,458,637 86 261 393 957 805 488 50 000 49 000 20 000 12 894,282
17
ESTIMATED COMBINED EXPENSE 2 730 381 7 300 558 1 458 637 11 489 576 480 218 805 488 50 000 49 000 20 000 12 894 282
19
(1 -based on fy 20 average counts
(2)-based on information ftom Town's insurance advisor
4
(3)-based on a 5% increase from fiscal 2019 actual Medicare.
(4)-based on current reimbursements of Part B penalties not expected to chan e.
i ~
5 -assumes 17 em to ees at S2 500 each & 2 at $3 250 will receive the o t out sti end.
INSINFO.xlsx fy 21 budget 11/12/2019Source page 167
Murgia, James R.
From: Sue Shillue <SShillue@cookandcompany.com>
Sent: Tuesday, November 05, 2019 3:47 PM
To: Murgia, James R.
Subject: RE: September cash flow reports
H i Jim - As you Know we only have claims through September at this point. Applying a 6.5%trend to projected claims for
FY'20(taking in to consideration the first three months of claims), I project the need for an 8%increase in working rates
for HMO/PPO, and only 2%for Medex. This does not take in to consideration using any of the trust fund surplus to
offset the rate increase. Also keep in mind that we have projected claims for FY'20 based on the actuarial decrements
provided by BC/BS for the benefit changes made on 7-1-19. I have also included a 1%increase in the BCBS administrative
fee, and a 25%increase in stop loss premiums (which hopefully is on the high side).
I'm happy to discuss my calculations with you and/or provide additional information. Please let me know what
q uestions you have. Sue
Susan H. Shillue, President
Cool< &Company Insurance Services, Inc.
P.O. Box 1068
M arshfield, MA 02050
Office 781-837-7300
Direct 781-837-7311
Cell 617-733-6236
Confidentiality Notice: This e-mail, including attachments, may include confidential and/or proprietary information, and
may be used only by the person to whom it is addressed. If the reader of this e-mail is not the intended recipient or his
or her authorized agent, any distribution or copying of this e-mail is prohibited. If you have received this e-mail in error,
please notify the sender by replying to this message and delete this e-mail immediately.
-----Original Message-----
From: Murgia, James R. [mailto:lmurgia@town.canton.ma.us]
Sent: Tuesday, November 5, 2019 1:37 PM
To: Sue Shillue
Subject: RE: September cash flow reports
[CAUTION: This email originated from outside of the IHC Group. Do not click links or open attachments unless you
recognize the sender and know the content is safe.]
Thanks Sue, no rush.
-----Original Message-----
From: Sue Shillue [mailto:SShillue@cookandcompany.com]
Sent: Tuesday, November 05, 2019 11:43 AM
To: Murgia, James R.Source page 168
HEALTH CLAIMS TRUST FUND
FY 2020 as of
Description 9/30/19 FY 2019 FY 2018 FY 2017 FY 2016 FY 2015
HMO BLUE Employee Share 499,393.59 2,328,954.66 2,431,104.47 2,183,074.06 2,074,517.91 2,181,241.72
HMO BLUE Town Share 1,815,322.59 6,990,973.93 7,055,182.18 6,809,492.27 6,560,392.41 6,590,253.32
HMO BLUE Stop Loss Refunds 308,663.40 3,128,106.43 224,916.91 726,841.64 584,286.57 207,846.53
HMO BLUE Total Revenue 2,623,379.58 12,448,035.02 9,711,203.56 9,719,407.97 9,219,196.89 8,979,341.57
PPO Employee Share 183,046.00 850,096.30 825,188.51 682,297.62 610,212.02 606,328.90
PPO Town Share 675,502.50 2,605,190.32 2,393,134.57 2.,152,768.21 1,906,318.72 1,817,524.36
PPO Stop Loss Refunds 107,223.33 127,492.38 140,286.68 34,460.47 41,859.18 156,020.44
PPO Total Revenue 965,771.83 3,582,779.00 3,358,609.76 2,869,526.30 2,558,389.92 2,579,873.70
Medex Employee Share 100,420.51 478,658.46 493,833.67 407,665.80 417,525.42 497,176.82
Medex Town Share 379,018.30 1,474,634.01 1,366,113.08 1,261,576.32 1,190,567.22 1,576,255.58
MedexTotal Revenue 479,438.81 1,953,292.47 1,859,946.75 1,669,242.12 1,608,092.64 2,073,432.40
Interest earned 0.00 49,677.25 46,514.63 41,927.70 34,183.89 33,582.43
Total Revenue 4,068,590.22 18,033,783.74 14,976,274.70 14,300,104.09 13,419,863.34 13,666,230.10
HMO Blue Claims Paid 2.,229,151.47 12,264,407.10 8,082,256.87 8,751,097.88 7,834,813.62 7,062,853.69
HMO Blue Admin &Other Costs 280,304.93 798,017.57 763,014.44 719,311.61 864,385.68 979,607.34
HMO Blue Total Expenditures 2,509,456.40 13,062,424.67 8,545,271.31 9,470,409.49 8,699,199.30 8,042,461.03
PPO Claims Paid 864,540.96 3,773,903.31 2,984,292.86 2,901,919.56 2,584,080.64 2,337,328.89
PPO Admin &Other Costs 78,950.27 228,478.62 212,031.02 187,854.38 212,881.14 229,678.86
PPO Total Expenditures 943,491.23 4,002,381.93 3,196,323.88 3,089,773.94 2,796,961.78 2,567,007.75
Medex Claims Paid 230,819.90 881,114.96 914,919.12 820,644.65 822,020.38 1,900,703:95
Medex PDP I nvoices Paid 130,558.01 910,564.28 899,860.33 807,500.89 680,193.72 0.00
Medex Admin &Other Costs 33,713.34 134,101.29 133,161.60 131,414.84 128,971.20 124,851.60
MedexTotalExpenditures 395,091.25 1,925,780.53 1,947,941.05 1,759,560.38 1,631,155.30 2,025,555.55
Miscellaneous Charges 0.00 0.00 0.00 29,218.05 0.00 0.00
IBNR Adjustments 0.00 0.00 0.00 153,482.00 244,965.00 (416;893.00)
Total Expenditures 3,848,038.88 18.,990,587.13 13,989,536.24 14,502,443.86 13,372,311.38 12,218,131.33
Surplus/(Deficit) 220,551.34 (956,803.39) _ 986,738.46 (202,339.77) 47,551.96 1,448,098.77
Claims Trust Fund Balance at Beginning of Year 3,595,443.48 4,552,246.87 3,565,508.41 3,767,848.18 3,720,296.22 2,272,197.45
Working Deposits used to fund claims 0.00 0.00 0.00 0.00 0.00 0.00
Claims Trust Fund Balance at End of Year 3,815,994.82 3,595,443.48 4,552,246.87 3,565,508.41 3,767,848.18 3,720,296.22
HMO BLUE SURPLUS/(DEFICIT) 113,923.18 (614,389.65) 865,932.25 248,998.48 519,997.59 936,880.54
PPO SURPLUS/(DEFICIT) 22,280.60 (419,602.93) 162,285.88 (220,247.64) (238,571.86) 12,865.95
MEDEX SURPLUS/(DEFICIT) 84,347.56 27,511.94 (87,994.30) (90,318.26) (23,092.66) 47,876.85
OTHER SURPLUS/(DEFICIT) 0.00 49,677.25 46,514.63 (140,772.35) (210,781.11) 450,475.43
TOTAL SURPLUS/(DEFICIT) 220,551.34 (956,803.39) 986,738.46 (202,339.77) 47,551.96 1,448,098.77
I NSINFO.xlsx health claims trust fund 11/12/2019Source page 169
TOWN OF CANTON FY 17 FY 18 FY 19 ORIGINAL FY 2021 FY 2021 COMMENT/REASON FOR
ACTUAL ACTUAL ACTUAL BUDGET ACTUAL YTD BASE DEPT. INCREASE /DECREASE
BUDGET REPORT FOR FY 2021 EXPENSE EXPENSE EXPENSE FY 20 EXPENSESTHRU BUDGET REQUEST
DEPARTMENTAL WORKSHEETS 9/30/19
915 EMPLOYER SHARE-LIFE INS
19151 - 51751 LIFE INS-EMPLOYER SHARE 59,640 59,994 60,202 62,250 19.688 62,250 ~~
SUBTOTAL SALARIES &WAGES $ 59.640 $59,994 $60,202 $62,250 519,688 $62,250
TOTAL 915 EMPLOYER SHARE-LIFE INS $ 59,640 $59,994 $60,202 $62,250 519,688 $62,250 Z
r~ ~z /
Department Hea signature /Date -
g".~ ~ ~~
~/~ jL ~ '~ `~ ~
Datc: 10/16/2019 Page: 121Source page 170
TOWN OF CANTON FY 17 FY 18 FY 19 ORIGINAL FY 2021 FY ZO?1 CObIMENT/REASON FOR
ACTUAL ACTUAL ACTUAL BUDGET ACTUAL YTD BASE DEPT. INCREASE/DECREASE
BUDGET REPORT FOR FY 2021 EXPENSE EXPENSE EXPENSE FY 20 EXPENSESTHRU B[JDGET REQUEST
DEPARTMENTAL WORKSHEETS 9/30/19
946 TOWN INSURANCE
19462 - 53S14 IOD-POLICE 19,780 3,309 2,378 22,500 (3,600) 22,500 ~
19462 - 53S15 IOD-FIRE 4,658 43,124 5,505 22,500 (186) 22,500 'r
19462 - 57000 OTHER CHARGES/EXPENDITURE 0 0 2,402 0 0 0~~
19462 - 57006 CYBER LIABILITY 0 0 0 12,518 18,062 12,518 1 ~r,`fZ3
19462 - 57403 FLOOD INSURANCE 0 0 0 29,279 30,366 29,279 3~ ~ d c~0
19462 - 57405 WORKERS COMP.INSURANCE 380,358 332,996 306,452 334,700 334,428 334,700 3f~'~ ~ z b'
19462 - 57406 POLICE LIABILITY 15,145 16,560 16,742 17,495 17,835 17,495 IBS./ 4 ~
19462 - 57408 PUBLIC OFFICIALS LIABILT 53,589 56,200 58,858 61,507 62,887 61,507 (,'1,35b
19462 - 57409 UMBRELLA LIABILITY 38,372 40,370 53,489 55,896 52,732 55,896 53,792
19462 -5740A AUTO FLEET 174,197 172,784 179,252 185,524 159,988 185,524 19"1 ~ OS'C
19462-5740B PROPERTY PACKAGE 178,887 178,765 182,439 194,675 195,156 194,675 ~ ~l~i~ d 4: D
19462-5740C SCHOOL LEGAL LIABILITY 20,744 21,781 24,430 25,529 25,167 25,529 2 ~5zy
19462 -5740G GENERAL LIABILITY LOSS 41,685 46,073 107,730 52,178 53,419 52,178 > `!. K~l
19462-5740H INDEMNIFICAT.POLICE/FIRE 5,214 8,196 8,948 7,875 1,677 7,875 ~~hC~~'
19462- 5740) TOWN INS. POLICE/FIRE CAT 65,489 94,903 92,241 88,978 92,962 88,978 ~~
19462 - 57410 EMPLOYER PRACTICES LIAB INS 0 0 0 8,652 8,652 8,652 ~~ Z s
19462 - 57411 POLLUTION LIABILITY INSURANCI 39,251 34,510 33,328 32,562 32,182 32,562 3z,4.2S
19462 - 574]2 SNOW REMOVAL LIABILITY 585 390 585 0 0 0 Q
19462 - 57800 CONTINGENCIES 20,344 26,852 62,870 60,000 240 60,000 V
SUBTOTAL EXPENSES $ 1.058.297 $1,076,813 $1,137,649 $1,212,368 $1,081,966 $1,212,368
TOTAL 946 TOWN INSURANCE $ 1,058,297 $1,076,813 $1,137,649 $1,212,368 $1,081,966 $1,212,368 1 , yGc ~ / L ~I
~
~'
Department Head signature /Date
Datr. 10/16/2019 Pa~c: 123Source page 171
FY 2021 FY 2021
TOWN OF CANTON G1' 17 F'Y I8 F7' 19 ORIGINAL
BASS DEPT.
C014111~1BPIT/REASON FOR
ACTU.IL ACTUAL ACTUAL BUDGET ACTUAL YTD (NCRLpSE / DECREASF,
BUDGET REPORT FOR FY 2021 CXPCNSE EXPENSE ESPENSE F1'ZO C`CI'ENSCS TABU BWGET REQUCST
DEPARTMENTAL WORKSHEETS
990 TRANSFERS
19902 - 59601 SPEC REV FND TRANSFER OUT 0 0 15,9]8 U 0
SUBTOTAL EXPENSES ~ ~ $0 515,918 SO ~0 SO
TOTAL 990 TRANSP~RS S 0 ~0 $15,918 SO ~0
~ / Department Head signature /Date
V
Datc: 10116/20]9 Pagc: 124
~/Source page 172
PLYMOUTH R1J~88ER DIF
~1) ~Z) ~ (3) ~4) ~5)
R/E Taxes School Town Net Tax Net Increased
FY Collected Costs Costs Revenues Tax Revenues
2017 82,793 275,000 235,000 (427,207)
2018 116,761 286,000 242,050 (411,289) 15,918
2019 214,429 297,440 249,312 (332,322) 94,885
2020 189,891 309,338 256,791 (376,238) 50,970
(1) -used parcels owned by Canton Development or Canton Holdings.
I ~_
(2)-school operating costs per agreement pages 9 & 10 increase 4% annually.
i
(3)-town operating costs per agreement page 11 increase 3%annually.
(4)-net tax revenues per agreement page 8, taxes collected less school &town operating costs.
-- —
(5) -net increased tax revenues per agreement page 8 are transferred to the DIF fund with fy 17 as base year.
Plymouth Rubber DIF estimates.xlsx summary 12/31/2019Source page 173
TOWN OF CANTON FY 17 FY I8 FY 19 ORIGINAL FY 2021 FY20Z1 COMMENT/REASON FOR
ACTUAL ACTUAL ACTUAL BUDGET ACTUAL YTD BASE DEPT. INCREASE/DECREASE
BUDGET REPORT FOR FY 2021 EXPENSE EXPENSE EXPENSE FY 20 EXPENSESTHRU BUDGET REQUEST
DEPARTMENTAL WORKSHEETS 9/30/19
993 OPEB TRANSFER
19932 - 59615 TRANSFER TO OPEB 770.000 1,000,000 800,000 1,030,000 1,030,000 1,030,000 v~~ '~.
SUBTOTAL EXPENSES $ 770.000 $1,000,000 $500,000 $1,030,000 $1,030,000 $1,030,000 ~
TOTAL 993 OPEB TRANSFER $ 770,000 $1,000,000 $800,000 $1,030,000 $1,030,000 $1,030,000 ~ ~~~Q ~
~, r
~/ / /~`
Department Head signature / Dat
Datc: 10/]6/2019 Page: 126
VSource page 174
FY 2021 FY 2021 COMNIENT/REASON FQR
TOWN OF CANTON FY 17 FY 18 FY 19 ORIGINAL
BASE DEPT.
`ACTUAL ACTUAL ACTUAL BUDGET ACTUAL YTD INCREASE /DECREASE
BUDGET REPORT FOR FY 2021 EXPENSE EXPENSE EXPENSE FY 20 EXPENSES TABU BUDGET REQUEST
DEPARTMENTAL WORKSHEETS 9130119
820 CHERRY SHEET ASSESSMENTS
1 8202 - 56304 CHARTER SCHOOL ASSESSMENT 115,328 149,872 234,777 249,953 63,372 249,953
1 5202 - 56310 SPECIAL EDUCATION CH71 B 35,670 0 62,203 35,571 8,895 35,571 {
18202 - 56320 SCHOOL CHOICE ASSESSMENT 18,683 25,149 53,097 60,004 11,885 60,004 ~ ,.
18202 - 56390 MOSQUITO CONTROL PROJECT 96,837 100,465 120,647 110,376 27,594 110,376
18202 - 56400 AIR POLLUTION CONTR DIST 8,202 8,417 8,651 8,772 2,193 8,772 ~
18202 - 56410 METRO AREA PLANNING CNCL 11,269 11,581 11,888 12,218 3,057 12,218
18202 - 56A60 REG OF MV NON-RENEWAL 22,380 22,380 22,380 22,380 5,595 22,380 ;fJ~A,.T✓}~
18202 - 56610 MASS BAY TRANSIT AUTHORT 480,581 488,430 502,823 516,814 129,204 516,814 ~ _~,~,~,,,. g ~-
SUBTOTAL EXPENSES $ 788.950 $806,294 $1,016,466 $1,016,088 $251,795 $1,016,088 b
TOTAL 820 CHERRY SHEET ASSESSMENTS $ 788,950 $806,294 $1,016,466 X1,016,088 $251,795 $1,016,088 ~ ~ ~ (~ ~~
\
-n .-, f P~ dr ~
: ~~ _
Department Head signature /Date
Date: 10/16/2019 Page: 113Source page 175
TOWN OF CANTON FY 17 ~is FY 19 ORIGINAL FY 2021 FY 2021 COMMENT/REASON FOR
ACTUAL ACTUAL ACTUAL BUDGET ACTUAL YTD BASE DEPT. m~Ep$E/DECREASE
BUDGET REPORT FOR FY 2021 EXPENSE EXPENSE ErPENSE FY 20 EXPENSESTHRU BUDGET REQUEST
DEPARTMENTAL WORKSHEETS 9/30/19
830 COUNTY TAX-CHERRY SHEET 2'~~10 ~n.~ ,~
18302 - 56210 COUNTY TAX 206,623 209,009 214,234 217,129 0 217.129 .r::= .~~ _ =^J~ /i---
SUBTOTAL EXPENSES $ 206,623 $209,009 $214,234 $217,129 $0 $217,129
TOTAL 830 COUNTY TAX-CHERRY SHEET $ 206,623 $209,009 $214,234 $217,129 $0 $217,129 aka ~'~
,
~
',/~~~^'
pepartment Head signature /Date
Date: 10/1 G/2019 Page: 114Source page 176
TOWN OF CANTON FY 2021 ~y 2021 COD4MENT/REASON FOR
FY 17 FY 18 FY 19 ACTUAL YTD ORIGINAL
BUDGET REPORT FOR FY 2021 ACTUAL ACTUAL ACTUAL EXPENSE THRU BUDGET
DEPARTMENTAL DEPT INCREASE /DECREASE
9/3012019 FY 20 BASE BUDGET REQLiEST
DEPARTMENTAL WORKSHEETS EXPENSE EXPENSE EXPENSE
600 SEWER ENTERPRISE
56000-51000- PERSONAL SERVICES 8,862 13,629 18,727 5,510 19,343 19,654
56000-51120- SUPERVISOR SALARY 28,192 21,908 101,884 39,061 125,624 133,452
56000-51122- SEPTAGE SALARY 55,560 94,719 108,885 21,886 110,836 123,447
56000-51123- LABORERS SALARY 71,314 71,077 72,950 21,498 73,276 76,683
56000-51135- JUNIOR ENGINEER SALARY 40,653 23,848 37,304 0 41,894 42,774
56000-51142- ACCOiJNTINGCLERK 23,336 24,93] 24,906 8,040 26,200 29,214
56000-51143- OFFICE ADMINISTRATOR SAL. 35,316 35,954 39,507 11,499 34,616 37,700
56000-51162- POLICE DETAIL SALARIES 2,620 1,614 1,174 564 4,000 4,000
56000-51300- OVERTIME SALARY 7,936 15,085 25,920 7,652 26,500 26,500
56000-51400- LONGEVITY 2,800 3,000 2,400 1,500 4,750 5,075
56000-51450- WORKING OUT OF GRADE 5,327 3,267 1,644 180 0 0
56000-51530- GOOD ATTEN - AFSCME 0 0 0 0 2,000 2,000
56000-51920- STIPENDS 0 0 0 900 0 0
56000-51950- CONTRACT PROVISION 0 0 0 0 11,655 0
SUBTOTAL SALARIES $281,915 $309,033 $435,301 $118,290 $480,694 $500,499
56000-52000- PURCHASE OF SERVICES 35,082 118,783 129,430 22,754 18,000 18,000
56000-52102- HEATING FUEL -OIL 5,484 7,180 8,146 294 10,000 10,000
56000-52104- LIGHTS &POWER $,828 11,068 14,030 1,682 13,000 13,000
56000-52105- BLDG.MAINT. &SUPPLIES 197 0 0 0 0 0
56000-52301- WATER/SEWER PURCH MILTON/3TOUG 223,732 235,068 171,063 0 250,000 250,000
56000-52410- REPAIR/MAINT MOTOR VEHIC 763 538 0 0 0 0
56000-52419- REPAIR/MAINT PUMPING STA 11,078 26,831 27,852 294 19,000 19,000
56000-52425- REPAIR/MAINT EQUIPMENT 12,842 25,877 10,840 6,330 15,000 15,000
56000-524?7- REPAIR/MAINT SEWERS 12,894 1,085 3,011 0 7,500 7,500
56000-52434- SOFTWARE MAINTENANCE 0 0 3,000 11,000 0 0 l.~ o00 :S~ oos ~~~a ~oR,~ 9~~ _
56000-52704- iINIFORM RENTAL 1,480 1,229 1,629 0 4,500 4,500
56000-5310R- PHYSICAL FITNESS PROGRAM 0 0 0 0 150 150
56000-53128- PHYSICAL FITNESS PROGRAM 0 0 0 0 200 200
56000-53400- TELEPHONE/COMMLINICATIONS 0 0 0 0 1,000 1,000
56000-53406- COMMUNICATIONS -OTHER 442 644 2,558 506 500 500
s60oo-53408- POSTAGE 98 10,219 10,422 489 0 0
56000-5340D- ADVERTISING 0 410 0 0 0 0
56000-54000- SUPPLIES 212 1,280 9,742 ?,167 500 500
56000-54411- TOOLS &HARDWARE 7,415 25,172 5,768 532 36,449 36,449
56000-54033- WORK SHOES 0 150 0 0 500 500
W~~Munis\MCR Library\Budget reports\New Fiscal Year budget worksheet -Dept Req-enterprise by sal-exp.rpt Page: 1
Date: 10/16/2019Source page 177
TOWN OF CANTON FY 2021 Fy zpZ~ COMMENT/REASON FOR
FY 17 FY 18 FY 19 ACTUAL YTD ORIGINAL
BUDGET REPORT FOR FY 2021 ACTUAL ACTUAL ACTUAL EXPENSE THRU BUDGET
DEPARTMENTAL DEPT INCREASE /DECREASE
9/30/2019 FY y~ BASE BUDGET RCQUEST
DEPARTMENTAL WORKSHEETS EXPENSE EXPENSE EXPENSE
56000-54041- FOUL WEATHER GEAR 0 0 378 0 300 300
56000-54200- OFFICE SUPPLIES 1,208 12,996 3,303 17 0 0
56000-54801- GASOLINE &OIL 2,111 2,282 2,243 415 8,500 8,500
56000-54806- DIESEL FUEL 1,347 2,665 4,156 597 7,000 7,000
56000-54901- MEALS 70 135 0 0 100 100
56000-55301- MATERIALS &SUPPLIES 0 7,225 470 4,205 500 500
56000-55306- BITUMINOUS MATERIALS 0 0 2,400 850 0 0
56000-5530B- CASTINGS 0 3,788 0 6,572 4,500 4,500
56000-5580E- WORK SHOES 0 0 600 1,000 0 0
56000-57802- HEAVY EQUIPMENT LICENSES 90 1,074 770 473 1,500 1,500
56000-57821- SEPTAGE SITE 0 740 0 0 1,000 1,000
54000-58500- EQUIPMENT PURCHASE 0 899 1,475 0 0 0
56000-58937- MWRA CHARGES 4,137,162 4,252,646 4,425,854 1,869,073 4,661,549 4,661,549
56000-59610- TRANSFER TO GENERAI.FUND 356.442 35&,865 326,670 82,364 329,454 378,855
SUBTOTAL EXPENSES X4,818,974 $5,108,850 X5,165,810 $2,011,612 ~~ ySS, /oS V
$5,390,702 $5,440,103
SUBTOTAL SEWER ENTERPRISE $5,100,889 $5,417,883 $5,601,111 $2,129,902 $5,871,396 $5,940,602 $, QSS, 60~-+
~. v~~ ii• i iQ
Dept Head Si~ature /Date
TOWN O'- .
FINANCE ~:,, ,;__,,. , :.: ~~-
Date: 10/16/2019 W ~Munis\MCR Library\Budget reports\New Fiscal Year budget worksheet -Dept Req-enterprise by sal-exp.rpt Page: 2Source page 178
PAYROLL PROJECTIONS-FV 2021
ew
hourlymewith FV21 Annual
Pay Pay Hours per FY20 Pay FY20 Pay Annual N21 Next FY21 Ne~ct step and/or Salary(261 FY21
Em to ee Last Name First Name lob Ciass lob Clazz Desc Location Desc Grau BU Or Ob'ect SUtus Grade Ste Year Hourl Rate Sala Grade Ste COIA da s Lon evi
1824 QUINLAN KELSEY 4118 GIS COORDINATOR SEWER PC 56000 51000 FT GIS 0 624 30.61 19,102 GIS 0 3138 19,654 0
SSOOO Total 19,102 19,654 0
36 806UE LAWRENCE 4401 SEWER FOREMAN SEWER AF 56000 51120 FT F-40 13 2080 39.01 81,141 F-40 14 40.59 84,752 1,750
1184 SYKES CHRISTOPHER 4501 WATER/SEWER SUPERVISOR SEWER AF 56000 51120 Ff E-40 12 1040 44.84 46,634 E-40 13 46.65 45,700 475
51120 Total 127,774 133,452 2,225
1271 LOUGHRAN BRIAN 4204 HEAVY EQUIPMENT OPERATOR SEWER AF 56000 51122 Ff J-40 16 2080 29.91 62,213 J-40 16 30.66 64,013 950
1910 ROUNDTREE 'TYLER 4204 HEAW EQUIPMENT OPERATOR SEWER AF 56000 51122 FT 1-40 10 2080 2736 56,909 1-40 11 28.46 59,433 0
51122 Total 119,122 123,447 950
889 LENHART CHARLES 4402 UTILITIES MAINTENANCE TECHNICI SEWER AF 56000 51123 Ff I-40 22 2080 35.83 74,526 I-40 22 36.73 76,683 1,100
51123 Total 74,526 76,683 1,100
TBD VACANCY VACANCY 4116 STAFF ENGINEER SEWER PB 56000 51135 Ff H-40 11 1248 32.83 40,972 H-40 12 34.14 42,774
51135 Total 40,972 42,774 0
1469 JERRIER MICHAEL 4507 WATER&SEWER ACCT COORDINATOR SEWER AF 56000 51142 Ff I-40 3 1040 26.89 27,966 I-40 4 27.98 29,214 400
511427otal 27,966 29,214 400
1359 CAWLEY PATRICIA 4502 WATER/SEWER OFFICE ADMINSTRATO SEWER AF4 56000 51143 FT 166 4 1040 33.87 35,225 16B 5 36.11 37,700 400
51143 Total 35,225 37,700 400
4 56000 Count
56000 Total 444,686 462,924 5,075
Payroll Projections FY21.xlsx Employee Inquiry
10/15/2019 31 0 33Source page 179
FISCAL 2021 DEPARTMENTAL OPERATING BUDGETS
PROJECTION: 2021 FY 2021 BASE BUDGET
2019 2020 2021 2021
ACCOUNTS FOR: ACTUAL ORIG BUD BASE BUDGET DEPT. REQ. COMMENT
56002 SEWER PRINC/INT PAYMENTS
56002 59101 SEWER PRINC PD-05/11 DEBT 71,000 68,000 68,000 -
56002 59103 ~ SEWER PRINC PD-05/19 DEBT - - - 59,000
56002 59106 PRIN PD-03/15 DEBT 77,000 40,000 40,000 40,000 i
56002 59107 INT PD - 03/15 DEBT 8,385 6,075 6,075 4,875
56002 59126 PRINCIPAL PAID TO MWPAT 176,971 180,546 180,546 184,194
56002 59131 PRINC PD-3/12 DEBT 100,000 100,000 '~ 100,000 100,000
56002 59132 PRINC PD-03/13 DEBT 15,000 15,000 15,000 15,000
56002 59133 PRINC PD-11/13 DEBT 239,400 224,000 224,000 47,200
56002 59135 PRIN PD-03/14 DEBT 48,100 43,200 43,200 43,200
56002 59144 PRIN PD-03/16 DEBT 60,000 61,000 61,000 60,000
56002 59145 INT PD-03/16 DEBT 9,540 8,340 8,340 7,120
56002 59150 SEWER INTEREST PD 05/11 7,079 3,840 3,840 -
56002 59160 INTEREST PD TO MWPAT 54,024 50,181 50,181 46,260
56002 59181 I INT PD - 3/12 DEBT 43,000 39,000 39,000 37,000
56002 59182 INT PD - 03/13 DEBT 2,250 1,800 1,800 1,200
56002 59183 INT PD-11/13 DEBT 21,676 12,859 12,859 7,901
56002 59185 INT PD-03/14 DEBT 12,130 9,725 9,725 7,565
56002 59195 i INT PD-05/19 DEBT - - - 2,950
TOTAL SEWER PRINC/INT PAYMEN 945,555 863,566 863,566 663,465
wt j ~ P ~ r
~
~ ~ ~
~ ~ ~~~ ~ I `
V
Fy 21 budget worksheets.xlsx enterprise funds 10/31/2019Source page 180
DEBT SERVICE PAYMENTS FROM FY 20 THRU FY 39
Date of Debt Service Type of
Issue Type Description Org Object Payment 2021
5/1/2019 S GOB Sewer REFUNDING (Self-Supporting)(Algonquin Sewers) 56002 59103 Principal 59,000.00
59103 Total 59,000.00 •'
3/15/2015 S Water Meters -Sewer 56002 59106 Principal 27,000.00
3/15/2015 S Water Meters -Sewer 56002 59106 Principal 13,000.00
59106 Total 40,000.00
3/15/2015 S Engineering Services -Sewer 56002 59107 Interest -
3/15/2015 S Water Meters -Sewer 56002 59107 Interest 3,105.00
3/15/2015 S Water Meters -Sewer 56002 59107 Interest 1,770.00
59107 Total 4,875.00 ,
7/8/2010 S WPT Sewer CWS-07-38 (Self-Supporting) 56002 59126 Principal 184,194.00
59126 Total 184,194.00.
3/27/2012 S GOB Sewer (Self-Supporting)(Greenlodge Interceptor) 56002 59131 Principal 100,000.00
59131 Total 100,000.00
3/15/2013 S GOB Departmental Equipment -Sewer (Self-Supporting) 56002 59132 Principal 15,000.00
59132 Total 15,000.00
11/13/2013 S Estey Way Sewer (Refunding) 56002 59133 Principal 10,400.00
11/13/2013 S Sewer I & I (Self-Supporting) - (Refunding)(Trayer Rd. Pumping) 56002 59133 Principal 27,400.00
11/13/2013 S Sewer Refunding 56002 59133 Principal -
11/13/2013 S Sewer Refunding 56002 59133 Principal -
11/13/2013 S Sewer Refunding 56002 59133 Principal -
11/13/Z013 S Sewer Refunding 56002 59133 Principal -
11/13/2013 S Sewer Refunding 56002 59133 Principal -
11/13/2013 S Wardwell Sewer (Refunding) 56002 59133 Principal 9,400.00
59133 Total 47,200.00
3/15/2014 S Sewer (Refunding)(Greenlodge Interceptor) 56002 59135 Principal 13,200.00
3/15/2014 S Sewer (Self -Supporting) 56002 59135 Principal 30,000.00
59135 Total 43,200.00
3/17/2016 S GOB Sewer (Self-Supporting)(Refunding) 56002 59144 Principal 5,000.00
3/17/2016 S Sewer (Estey Way) 56002 59144 Principal 24,000.00
3/17/2016 S Sewer (Water Resources Management Plan) 56002 59144 Principal 31,000.00
59144 Total 60,000.00.
3/17/2016 S GOB Sewer (Self-Supporting)(Refunding) 56002 59145 Interest 580.00
3/17/2016 S Sewer (Estey Way) 56002 59145 Interest 2,980.00
3/17/2016 S Sewer (Water Resources Management Plan) 56002 59145 Interest 3,560.00
59145 Total 7,120.00;
7/8/2010 S WPT Sewer CWS-07-38 (Self-Supporting)(includes admin fees) 56002 59160 Interest 46,259.66
59160 Total 46,259.66.
3/27/2012 S GOB Sewer (Self-Supporting)(Greenlodge Interceptor) 56002 59181 Interest 37,000.00
59181 Total 37,000.00
3/15/2013 S GOB Departmental Equipment -Sewer (Self-Supporting) 56002 59182 Interest 1,200.00
59182 Total 1,200.00,
11/13/2013 S Estey Way Sewer (Refunding) 56002 59183 Interest 1,741.00
11/13/2013 S Sewer I & I (Self-Supporting) - (Refunding)(Trager Rd. Pumping) 56002 59183 Interest 4,586.00
11/13/2013 S Sewer Refunding 56002 59183 Interest -
11/13/2013 S Sewer Refunding 56002 59183 Interest -
11/13/2013 S Sewer Refunding 56002 59183 Interest -
11/13/2013 S Sewer Refunding 56002 59183 Interest -
11/13/2013 S Sewer Refunding 56002 59183 Interest -
11/13/2013 S Wardwell5ewer (Refunding) 56002 59183 Interest 1,574.00
59183 Total 7,901.00
3/15/2014 S Sewer(Refunding)(Greenlodgelnterceptor) 56002 59185 Interest 2,315.00
3/15/2014 S Sewer (Self -Supporting) 56002 59185 Interest 5,250.00
59185 Total 7,565.00
5/1/2019 S GOB Sewer REFUNDING (Self-Supporting)(Algonquin Sewers) 56002 59195 Interest 2,950.00
59195 Total 2,950.00
AUTHDEBT.xlsx fy 19 thru fy 39 10/8/2019Source page 181
TOWN OF CANTON FY 2021
ACTUAL YTD FY 2021 COMMENT/REASON FOR
FY 17 FY 18 FY 19 ORIGINAL
BUDGET REPORT FOR FY 2021 ACTUAL ACTUAL ACTUAL EXPENSE THRU BUDGET
DEPARTMENTAL DEPT INCREASE /DECREASE
9/30/2019 gpSE BUDGET REQUEST
DEPARTMENTAL WORKSHEETS EXPENSE EXPENSE EXPENSE FY 20
640 WATER ENTERPRISE
56100-51000- PERSONAL SERVICES 8,861 13,629 18,727 5,510 19,343 19,654
56100-51120- SUPERVISOR SALARY 106,952 104,138 174,042 57,347 212,796 223,426
56100-51123- LABORERS SALARY 453,551 449,325 462,489 147,399 478,170 503,782
56100-51135- JiJNIOR ENGINEER SALARY 21,771 13,524 24,618 0 27,929 28,516
56100-51142- ACCOUNTING CLERK 24,772 25,614 26,423 8,094 26,200 29,214
56100-51]43- OFFICE ADMINISTRATOR SAL. 25,109 28,704 27,834 8,823 34,616 37,700
56100-5116?- POLICE DETAIL SALARIES 11,634 19,189 33,750 7,731 6,500 6,500
56100-51210- SUMMER HELP SALARY 6,418 4,901 2,319 4,350 6,000 6,000
56100-51300- OVERTIME SALARY 114,350 210,557 209,482 66,153 111,000 111,000
56100-51400- LONGEVITY 9,000 7,750 7,550 650 8,050 9,625
56100-51530- GOOD ATTEN - AFSCME 80 2 2,517 4,693 2,000 2,000
56100-51916- SALARY CONTINGENCIES 0 0 0 0 2,329 2,329
56100-51920- STIPENDS 8,649 7,558 20,800 8,750 26,000 26,000
56100-51950- CONTRACT PROVISION 0 0 0 0 15,787 0
SUBTOTAL SALARIES $791>>~8 $884,895 $1,010,552 $319,500 $976,720 $1,005,746 ~~/
56100-52000- PURCHASE OF SERVICES 125,959 166,485 330,442 27,969 66,000 66,000 g~ ~~~ ~~~ N«d
56100-52000-WELLS PURCHASE OF SERVICES 33,677 21,905 15,605 11,111 0 0
56100-52102- HEATING FUEL -OIL 11,834 15,817 13,371 1,546 16,000 16,000
56100-52104- LIGHTS&POWER 232,964 215,785 220,447 77,929 231,500 231,500
56100-52105- BLDG.MAINT. &SUPPLIES 5,527 1,162 8,588 0 5,000 5,000
56100-52301- WATER/SEWER PURCH MILTON/STOUG 6,112 485 354 62 30,000 30,000
56100-52410- REPAIR/MAINT MOTOR VEHIC 0 835 0 0 3,000 3,000
56100-52419- REPAIR/MAINT PUMPING STA 9 925 0 0 0 0
56100-52420- BUILDING MAINT&SUPPLIES 3,460 9,984 9,981 3,389 1,500 1,500
56100-52422- REPAIR/MAINT -WELLS 33,852 45,206 21,792 203 32,000 32,000
56100-52425- REPAIR/MAIN1'EQUIPMENT 114,361 174,505 142,914 41,537 105,000 105,000 Gz~oma 2.0000 ~tccd
56100-52434- SOFTWARE MAINTENANCE 0 0 3,000 11,495 0 0 `~•~m~ ~r~~~ ~'f~"'~R-~ V4.
56100-52703- RENTAL OF EQUIPMENT 0 0 0 0 1,000 1,000
56100-52704- iJNIFORM RENTAL 3,356 3,034 5,901 0 4,000 4,000
56100-53108- PRINTING &BINDING 0 470 0 0 1,500 1,500
56100-5310T- PROF.SERV. WATER TESTING 22,529 46,501 32,176 9,721 35,000 35,000 ~o~000 Se.o (~~ R,equ~~Pbt►~.~.'i'
56100-5310U- PROF.SERV. MEDICAL EXAMS 0 524 580 525 100 100
56100-53] 10- PHYSICAL FIT-AFSCME 0 0 0 0 250 250
56100-53400- TELEPHONE/COMMUNICATIONS 20,99? 12;805 6.077 1,667 22,000 22,000
Date: 10/16/2019 W ~Munis\MCR Library\Budget reports\New Fiscal Year budget worksheet -Dept Req-enterprise by sal-exp.rpt pale: ~Source page 182
TOWN OF CANTON
~ 17 FY 18 FY 19 ORIGINAL ~X021 FY 2021 COMMENT/REASON FOR
BUDGET REPORT FOR FY 2021 ACTUAL ACTUAL ENSE THRU DEPARTMENTAL DEPT WCREASE/DECREASE
ACTUAL BUDGET
9/30/2019 FY Z~ BASE BUDGET REQUEST
DEPARTMENTAL WORKSHEETS EXPENSE EXPENSE EXPENSE
56100-53406- COMMUNICATIONS -OTHER 2,176 2,665 3,359 808 0 0
56100-53408- POSTAGE 13,955 7,998 8,635 681 12,000 12,000
56100-5340D- ADVERTISING 443 2,727 1,685 400 600 600
56100-53411- WELL MONITORING SYSTEM(SCADA) 2,300 1,912 2,383 0 7,500 7,500
56100-54011- TOOLS &HARDWARE 48,889 76,670 28,336 9,202 18,000 18,000 ~l'O
f Odo a6~ m o~ ~~
56100-54200- OFFICE SUPPLIES 5,252 6,142 4,485 1,221 4,500 4,500
56100-54801- GASOLINE &OIL 6,0]7 9,453 8,313 1,632 14,000 14,000
56100-54806- DIESEL FUEL 17,581 18,403 21,171 4,397 24,000 24,000
56100-54901- MEALS 1,020 3,780 3,465 0 500 500
56100-55303- TRENCH MATERIALS 9,415 7,290 3,685 728 8,000 8,000
56100-55304- CHEMICALS 132,551 155,153 138,976 52,484 270,000 270,000
56100-55305- METERS &PARTS 18,333 22,584 30,193 17,295 40,000 40,000
56100-55306- BITUMINOUS MATERIALS 15,230 14,127 43,790 1,931 15,000 15,000
56100-55308- PIPES &FITTINGS 33,071 22,543 60,631 10,134 17,000 17,000
56100-55309- HYDRANTS &VALVES 51,372 45,306 26,080 2,475 40,000 40,000
56100-5580C- DATA PROCESSING SUPPLIES 50 4,837 6,640 0 1,000 1,000
56100-5580E- WORK SHOES 1,480 1,024 2,009 1,600 1,200 1,200
56100-558oP- FOiJL WEATHER GEAR 565 283 874 0 1,500 1,500
56100-56000- TAXES-TOWN OF STOUGHTON 3,331 3,331 3,331 0 5,500 5,500
56100-57000- OTHER CHARGES/EXPENDITURE 210 0 0 0 525 525
56100-5710C- MEETINGS 1,093 6,537 7,886 30 1,200 1,200
56100-57300- DUES &MEMBERSHIPS 1,025 2,703 3,035 277 2,750 2,750
56100-57800- CONTINGENCIES 0 0 0 0 25,000 25,000
56100-57802- HEAVY EQUIPMENT LICENSES 3,637 5,523 3,137 349 4,800 4,800
56100-57807- WELL #9 OPERATING COSTS 0 0 0 0 10,000 10,000
56100-57819- PIPELINE ASSISTANCE PROGRAM 0 0 0 0 5,335 5,335
56100-57840- US GEOLOGICAL SURVEY EXPENSE 16,700 12,525 20,875 0 19,000 19,000
56100-58500- EQUIPMENT PURCHASE 37,979 1,065 8,938 0 30,000 30,000
56100-58936- DEP ASSESSMENT CHARGES 7,821 8,743 9,209 0 9,500 9,500
56100-58937- MV✓RACHARGES 1,731,331 2,551,203 1,884,292 854,706 2,137,222 2,137,222 r~rof Y'e.+++
56100-58985- LEAK DETECTION SURVEY 0 23,185 12,100 595 0 0 3.~oc~ ~S~oeo ~Kcr~asc
56100-59607-A1636 TRANSFER TO CAPITAL PROJECTS 400,000 0 0 0 0 0
56100-59610- TRANSFER TO GENERAL FiJND 510,539 514,825 584,844 134,075 536,298 632,564
SUBTOTAL EXPENSES ~3,687,99G $4,248,964 $3,743,589 $1,282,173 ~~ bf'
Q O<f~.
S3,g]5,780 $3,912,046
Date: ]0/16/2019 W:\Munis\MCR Library\Budget reports\New Fiscal Year budget worksheet -Dept Req-enterprise by sal-exp.rpt
Page: 6Source page 183
TOWN OF CANTON FY 2021
FY 19 ACTUAL YTD FY 2021 COMMENT/REASON FOR
FY 17 FY 18 ORIGINAL
BUDGET REPORT FOR FY 2021 ACTUAL ACTUAL ACTUAL EXPENSE THRU BUDGET
DEPARTMENTAL DEPT INCREASE/DECREASE
9/30/2019 BASE BUDGET REQUEST
DEPARTMENTAL WORKSHEETS EXPENSE EXPENSE EXPENSE FY 20
SUBTOTAL WATER ENTERPRISE X4,479,143 55,133,859 $4,754,141 $1,601,673 54,792, 00 $4,917,792 S 03..~~ '7 Q 3..
Dept Head Signature /Date
RECEIVED
UtC 0 2 2019
TOWN OF CANTON
FINANCE DIRECTOR
Date: 10/16/2019 W:\Munis\MCR Library\Budget reports\New Fiscal Year budget worksheet -Dept Req-enterprise by sal-exp.rpt
Page: 7Source page 184
PAYROLL PROJECTIONS - FV 2021
ew
hourly rate with FY21 Annual
Pay Pay Hours per FV20 Pay FY20 Pay Mnual FY21 Next FY21 Next step and/or Salary(261 FY21
Em I ee Last Name First Name Job Oau lob Uau Dezc Loation Desc Grou BU Or Ob'ect Sdtus Grade Sh Year Hourl Rate Sala Grade Ste COLA da s Lan evi
1524 QUINLAN KELSEY 4118 GIS COORDINATOR WATER PC 56100 51000 FT GIS 0 624 30.61 19,102 GIS 0 3138 19,654 0
51000 TOWl 19,102 19,654 0
297 KIELY BRIAN 4503 WATER FOREMAN WATER AF 56100 51120 Ff F-40 20 2080 42.63 88,670 F-00 20 43.70 91,237 1,500
1474 RUANE RENEE 4550 WTR TREATMNT PLNT FOREMAN WATER AF 56100 51120 Ff F-40 12 2080 38.44 79,955 F-40 13 39.99 83,489 800
1184 SYKES CHRISTOPHER 4501 WATER/SEWER SUPERVISOR WATER AF 56100 51120 Ff E-40 12 1040 44.84 46,634 E-40 13 46.65 48,700 475
511207otal 215,259 223,426 2,775
12 ARMANDO GARY 4506 SKILLED LABORER/TRUCK DRIVER WATER AF 56100 51123 FT J~0 15 2080 29.47 61,298 1-40 16 30.66 64,013 1,500
1434 BOGUE CONOR 4554 UTILITIES MAINTENANCE TECHNICI WATER AF 56100 51123 fT I-40 2 2080 26.51 55,141 I-40 3 27.56 57,550 0
1860 MCCANN GINA 4508 METER READER WATER AF 56100 51123 Ff K-40 3 2080 22.42 46,634 K~0 4 23.34 48,132 0
381 MCCARRICK STEVEN 4504 WTR TREATMNT PLANT OPERATOR WATER AF 56100 51123 Ff I-40 22 2080 35.83 74,526 I-40 22 36.73 76,683 1,750
1867 MICHAELS KEVIN 4504 WTR TREATMNT PLANT OPERATOR WATER AF 56100 51123 Ff I-40 1 2080 26.11 54,309 I-40 2 27.17 56,737 0
1279 MITCHERONEY MICHAEL 4554 UTILITIES MAINTENANCE TECHNICI WATER AF 56100 51123 FT I-40 2 2080 26.51 55,141 I-40 3 27.56 57,550 650
1653 REDQUESf SCOTT 4208 SPECIAL HEAVY EQUIP OPERATOR WATER AF4 56100 51123 FT 13 5 2080 29.58 61,526 13 6 31.53 65,833 650
697 SMITH JOSEPH 4554 UTILITIES MAINTENANCE TECHNICI WATER AF 56100 51123 FT I.40 22 2080 35.83 74,526 I-40 22 36.73 76,683 1,500
51123 Total 483,101 503,782 6,050
TBD VACANCY VACANCY 4116 STAFF ENGINEER WATER PB 56100 51135 Ff H-40 11 832 32.83 27,315 H-40 12 34.14 25,516
511357otal 27,315 28,516 0
1469 JERRIER MICHAEL 4507 WATER&SEWER ACCT COORDINATOR WATER AF 56100 51142 Ff I-40 3 1040 26.89 27,966 I-40 4 27.98 29,214 400
51142 Total 27,966 29,214 400
1359 CAWLEY PATRICIA 4502 WATER/SEWER OFFICE ADMINSTRATO WATER AF4 56100 51143 FT 168 4 1040 33.87 35,225 16B 5 36.11 37,700 400
51143 Total 35,225 37,700 000
15 56100 Count
56100 Total 807,967 842,292 9,625
Payroll Projections F`(21.xlsz Employee Inquiry
10/15/2019 32 of 33Source page 185
FISCAL 2021 DEPARTMENTAL OPERATING BUDGETS
PROJECTION: 2021 FY 2021 BASE BUDGET
2019 2020 2021 2021
ACCOUNTS FOR: ACTUAL ORIG BUD ~ BASE BUDGET DEPT. REQ. COMMENT
56102 WATER PRINC/INT PAYMENTS
56102 59101 ~ WATER PRINC PD-05/11DEBT 255,000 ~ 255,000 255,000 -
56102 59103 WATER PRINC PD-05/11DEBT - - - 222,000
56102 59106 PRIN PD-3/15 DEBT 69,000 68,000 68,000 68,000
56102 59107 INT PD-03/15 DEBT 12,230 10,160 10,160 8,120
56102 59109 PRINCIPAL PAID TO MWRA ~ 200,000 200,000 200,000 200,000
56102 59130 PRINCIPAL PAYDOWNS - - - 216,000
56102 59131 PRINC PD-3/12 DEBT 190,000 190,000 190,000 ~ 190,000
56102. 59132 PRINC PD-03/13 DEBT 177,000 j 177,000 177,000 177,000
56102 59133 PRINC PD-11/13 DEBT ~ 77,400 74,800 74,800 49,700
56102 59135 PRIN PD-03/14 DEBT 202,300 197,400 197,400 197,700
56102 59144 PRIN PD-03/16 DEBT 57,000 54,000 54,000 54,000
56102 59145 INT PD-03/16 DEBT 8,420 7,280 7,280 6,200
56102 59146 PRIN PD-03/17 DEBT 135,000 135,000 135,000 135,000
56102' 59148 PRIN PD-04/17 DEBT 97,000 98,000 98,000 95,000 +
56102 59150 WATER INTEREST PD 05/11 132,260 112,519 112,519 -
56102' 59181 INT PD - 3/12 DEBT 81,700 74,100 74,100 70,300
56102. 59182 INT PD - 03/13 DEBT 72,529 67,219 67,219 60,139
56102 59183 INT PD-11/13 DEBT 12,947 10,399 10,399 8,404
56102 59185 INT PD-03/14 DEBT 68,603 58,488 58,488 48,618
56102 ~ 59187 INT PD-03/17 DEBT 74,850 70,800 70,800 66,750
561021 59188 INT PD-04/17 DEBT 27,505 25,565 25,565 23,605
56102 59189 PRIN PD 03/18 DEBT 202,000 225,000 225,000 200,000
56102 59194 INT PD 03/18 DEBT 121,730 94,240 94,240 82,990
56102 59195 WATER INTEREST PD 05/19 - - - 109,340
561021 59250 INTEREST TEMPORARY LOANS - 61,000 61,000 73,000
TOTAL I WATERPRINC/INTPAYMEN 2,274,473 2,265,970 2,265,970 2,361,866
r~ ~.. ~~ ~~~
~~
Fy 21 budget worksheets.xlsx enterprise funds 11/8/2019Source page 186
DEBT SERVICE PAYMENTS FROM FY 20 THRU FY 39
Bate of Debt Service Type of
Issue Type Description Org Object Payment 2021
5/1/2019 W GOB Water Mains (Self-Supporting) 56102 59103 Principal 4,000.00
5/1/2019 W GOB Water Treatment Facility (Self-Supporting) 56102 59103 Principal 218,000.00
59103 Total 222,000.00
3/15/2015 W Water Meters 56102 59106 Principal 55,000.00
3/15/2015 W Water Meters 56102 59106 Principal 13,000.00
59106 Total 68,000.00
3/15/2015 W Water Meters 56102 59107 Interest 6,300.00
3/15/2015 W Water Meters 56102 59107 Interest 1,820.00
59107 Total 8,120.00 y~
11/15/2010 W WRA Water (Self-Supporting) 56102 59109 Principal 41,000.00
11/15/2010 W WRA Water (Self-Supporting) 56102 59109 Interest -
5/7/2012 W WRA Water (Self-Supporting) 56102 59109 Principal 50,000.00
5/7/2012 W WRA Water (Self-Supporting) 56102 59109 Interest -
8/19/2013 W MWRA Tolman Water Tank -interest free 56102 59109 Principal 109,000.00
8/19/2013 W MWRA Tolman Water Tank - interest free 56102 59109 Interest -
59109 Total 200,000.00,~
3/27/2012 W GOB Water Treatment Facility (Self-Supporting) 56102 59131 Principal 190,000.00
59131 Total 190,000.00,
3/15/2013 W GOB Water Mains (Self-Supporting) 56102 59132 Principal 11,000.00
3/15/2013 W GOB Water Mains (Self-Supporting)(Elm Street) 56102 59132 Principal 24,000.00
3/15/2013 W GOB Water Mains (Self-Supporting)(Elm Street) 56102 59132 Principal 124,000.00
3/15/2013 W GOB Well #10 (Self-Supporting) 56102 59132 Principal 18,000.00 /
59132 Total 177,000.00
11/13/2013 W Pumping Station (Refunding) 56102 59133 Principal
11/13/2013 W Water (Refunding) 56102 59133 Principal
11/13/2013 W Water Mains (Self-Supporting) - (Refunding) 56102 59133 Principal 16,000.00
11/13/2013 W Water Mains (Self-Supporting) - (Refunding) 56102 59133 Principal 33,700.00
11/13/2013 W Well Rehab (Refunding) 56102 59133 Principal
59133 Total 49,700.00•/
3/15/2014 W Water Mains (Self-Supporting) 56102 59135 Principal 90,000.00
3/15/2014 W Well (Self -Supporting) 56102 59135 Principal 45,000.00
3/15/2014 W Well (Self -Supporting)(Refunding) 56102 59135 Principal 26,900.00
3/15/2014 W Well (Self -Supporting)(Refunding) 56102 59135 Principal 17,900.00
3/15/2014 W Well (Self -Supporting)(Refunding) 56102 59135 Principal 17,900.00
59135 Total 197,700.00
3/17/2016 W GOB Water Mains (Self-Supporting)(Refunding) 56102 59144 Principal 54,000.00
59144 Total 54,000.00 ~ ~
3/17/2016 W GOB Water Mains (Self-Supporting)(Refunding) 56102 59145 Interest 6,200.00
59145 Total 6,200.00
3/16/2017 W Water Mains (Mechanic Street) 56102 59146 Principal 135,000.00
59146 Total 135,000.00 ~
4/5/2017 W GOB Water Mains (Self-Supporting) 56102 59148 Principal 75,000.00
4/5/2017 W GOB Water Mains (Self-Supporting) 56102 59148 Principal 20,000.00
59148 Total 95,000.00-~
3/27/2012 W GOB Water Treatment Facility (Self-Supporting) 56102 59181 Interest 70,300.00
59181 Total 70,300.00
3/15/2013 W GOB Water Mains (Self-Supporting) 56102 59182 Interest 1,100.00
3/15/2013 W GOB Water Mains (Self-Supporting)(Elm Street) 56102 59182 Interest 9,401.25
3/15/2013 W GOB Water Mains (Self-Supporting)(Elm Street) 56102 59182 Interest 47,837.50
3/15/2013 W GOB Well #10 (Self-Supporting) 56102 59182 Interest 1,800.00 j
59182 Total 60,138.75 i
11/13/2013 W Pumping Station (Refunding) 56102 59183 Interest
11/13/2013 W Water (Refunding) 56102 59183 Interest
11/13/2013 W Water Mains (Self-Supporting) - (Refunding) 56102 59183 Interest 2,690.00
11/13/2013 W Water Mains (Self-Supporting) - (Refunding) 56102 59183 Interest 5,714.00
11/13/2013 W Well Rehab (Refunding) 56102 59183 Interest
59183 Total 8,404.00 ,~
3/15/2014 W Water Mains (Self-Supporting) 56102 59185 Interest 30,125.00
3/15/2014 W Well (Self -Supporting) 56102 59185 Interest 7,875.00
3/15/2014 W Well (Self -Supporting)(Refunding) 56102 59185 Interest 4,342.50
.x sx y t ruSource page 187
DEBT SERVICE PAYMENTS FROM FY 20 THRU FY 39
~_+ate of Debt Service Type of
Issue Type Description Org Object Payment 2021
3/15/2014 W Well (Self -Supporting)(Refunding) 56102 59185 Interest 3,137.50
3/15/2014 W Well (Self -Supporting)(Refunding) 56102 59185 Interest 3,137.50
59185 Total 48,617.50.~
3/16/2017 W Water Mains(Mechanic Street) 56102 59187 Interest 66,750.00
59187 Total 66,750.00-~
4/5/2017 W GOB Water Mains (Self-Supporting) 56102 59188 Interest 18,590.00
4/5/2017 W GOB Water Mains (Self-Supporting) 56102 59188 Interest 5,015.00
59188 Total 23,605.00,
3/15/2018 W GOB Departmental Equipment -Public Works (Self-Supporting) 56102 59189 Principal -
3/15/2018 W GOB Water (Self-Supporting)(System Improvements) 56102 59189 Principal 14,000.00
3/15/2018 W GOB Water Mains (Self-Supporting) 56102 59189 Principal 50,000.00
3/15/2018 W GOB Water Mains (Self-Supporting) 56102 59189 Principal 37,000.00
3/15/2018 W GOB Water Treatment Facility (Self-Supporting) 56102 59189 Principal 99,000.00
59189 Total 200,000.00
3/15/2018 W GOB Departmental Equipment -Public Works (Self-Supporting) 56102 59194 Interest -
3/15/2018 W GOB Water (Self-Supporting)(System Improvements) 56102 59194 Interest 5,710.00
3/15/2018 W GOB Water Mains (Self-Supporting) 56102 59194 Interest 20,760.00
3/15/2018 W GOB Water Mains (Self-Supporting) 56102 59194 Interest 15,130.00
3/15/2018 W GOB Water Treatment Facility (Self-Supporting) 56102 59194 Interest 41,390.00
59194 Total 82,990.00 ~
5/1/2019 W GOB Water Mains (Self-Supporting) 56102 59195 Interest 2,170.00
5/1/2019 W GOB Water Treatment Facility (Self-Supporting) 56102 59195 Interest 107,170.00
59195 Total 109,340.00-~
AUTHDEBT.xlsx fy 19 thru fy 39 10/8/2019Source page 188
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 2021
5/14/2018 12-7 B1910 JFK MODULAR CLASSROOMS 2,000,000 10 Apr-20 2.50% 4.00% 80 200 280
5/13/2019 12-6 B2004 PEQUITSIDE FARM PARKING 200,000 10 Apr-20 2.50% 4.00% 8 20 28
5/13/2019 12-6 A2007 FIRE ENGINE REFURBISHMENT 162,000 5 Apr-20 2.50% 4.00% 6 32 39
5/13/2019 12-6 A2007 DPW BOX TRUCK 189,000 10 Apr-20 2.50% 4.00% 8 19 26
5/13/2019 12-8 B2005 SCHOOL BLEACHERS 100,000 10 Apr-20 2.50% 4.00% 4 10 14
5/13/2019 12-8 A2009 WIFI BACKBONE 68,000 5 Apr-20 2.50% 4.00% 3 14 16
5/13/2019 12-8 B2006 HIGH SCHOOL ROOF TOP UNIT 122,000 10 Apr-20 2.50% 4.00% 5 12 17
TOTAL INSIDE LEVY 8,005,000 114 307 421
TOTAL AMBULANCE 0 0 0 0
5/13/2019 20 BPOOL BOLIVAR POOL PROJECT 5,900,000 20 Apr-21 2.50% 4.50% 148 0 148
TOTAL OUTSIDE LEVY 5,900,000 148 0 148
5/14/2018 12-10 A1914 WATER LINE AT SULLIVAN TREATMENT FACILITY 2,440,000 20 Apr-20 2.50% 4.00% 40 50 90
5/13/2019 12-7 A2008 WATER SYSTEM DESIGN COSTS 830,000 5 Apr-20 2.50% 4.00% 33 166 199
TOTAL WATER 3,270,000 73 216 289
12/12/2018 2 RINK REPAIRS 1,983,000 30 Apr-21 2.50% 4.50% 50 0 50
TOTAL RINK 1,983,000 50 0 50
GRAND TOTALS-AUTHORIZED/UNISSUED DEBT 29,086,290 334 523 907
AUTHDEBT.xlsx PIPELINE 11/13/2019Source page 189
~;;k ~~,60
ORG OBJECT ACCT DESCRIPTION 2015 ACTUAL 2021 BUDGET
Salaries
57000 51100 DEPARTMENT HEAD SALARY 8,332 8,300.00
57000 51111 RINK ASSISTANTS 32,868 50,000.00
57000 51300 OVERTIME SALARY 6,174 6,000.00
SALARIES 64,300.00
Expenses
57000 52000 PURCHASE OF SERVICES 15,598 1,000.00
57000 52101 ELECTRICITY 53,273 60,000.00
57000 52103 HEATING FUEL -GAS 10,320 12,000.00
57000 52105 BLDG.MAINT. &SUPPLIES 23,152 22,000.00
57000 52401 ICE RESURFACER REP/MAINT 9,919 2,500.00
57000 52404 REPAIRS/MAINT. MACHINERY 8,281 5,000.00 v
57000 52707 RINK LEASE 3,307 1,200.00 mob
57000 53400 TELEPHONE ~ 151 200.00
57000 53406 COMMUNICATIONS ~ 3,000.00
57000 5340D ADVERTISING 475
57000 53550 SKATE SHOP EXPENSES 2,727 2,500.00
57000 54200 OFFICE SUPPLIES 1,481 1,500.00
57000 57501 OFFICIALS 11,463
57000 57502 EMT 2,890
57000 58S02 COMPRESSORS METRO RINK 7,118 7,200.00
57000 59610 TRANSFER TO GENERAL FUND 90,729 l`
57002 59138 PRINC PAID - 05/09 DEBT 8,000
57002 59178 INT PAID - 05/09 DEBT 980
~ ~,~,,
n ~ :~_~n ~ ~~ > (~,~;
RINK OPERATING E~PENSES 297,238 118,100.00
TOTAL EXPENSES $182,400.00
c~~3~~~~~~~
RECEIVED
UtC 0 2 2019
TOWN OF CANTON
FINANCE DIRECTORSource page 190
TOWN OF CANTON FY 2021 COMMENT/REASON FOR
FY 17 FY 18 FY 19 ORIGINAL
BUDGET REPORT FOR FY 2021 EXPENE THRU DEPARTMENTAL FEPTl INCREASE/DECREASE
ACTUAL ACTUAL ACTUAL BUDGET
9/30/2019 gyZp gpSE BUDGET REQUEST
DEPARTMENTAL WORKSHEETS EXPENSE EXPENSE EXPENSE
700 METRO SKATING RINK
57000-51100- DEPARTMENT HEAD SALARY 32 0 0 0 4,000 4,000 ~3 ~ CoY~h'~V°-~
s~000-s11~1- RINK ASSISTANTS 0 0 0 0 6,000 6,000 Soi 00C ~C See a~f~cbe~
57000-5ll20- SUPERVISOR SALARY 0 0 1,331 0 0 0 ~
57000-51400- LONGEVITY 800 0 0 0 0 0
57000-51530- GOOD ATTEN - AFSCME 16 0 0 0 0 0 ~
57000-51920- STIPENDS 4,640 0 0 0 0 0 ~ ~''~
SUBTOTAL SALARIES $5+488 $0 $1,331 ~0 $10,000 $10,000 ~ (p'~-(~ ~~ /~~ ~ JT
~~
57000-52101- ELECTRICITY 0 0 0 137 60,000 60,000
57000-52]05- BLDG.MAINT. &SUPPLIES 4,524 4,740 4,070 240 0 0
57000-52401- ICE RESURFACER REPlMAINT 451 0 250 0 0 0 ~~~
57000-53400- TELEPHONE/COMMUNICATIONS 149 130 117 47 0 0 Z~~
57000-59610- TRANSFER TO GENERAL FiJND 0 0 0 0 0 5,460
57002-59138- PRINC PD - 05/09 DEBT 6,000 0 0 0 0 0 ~
57002-59148- PRIM PD-04/17 DEBT 0 7,000 6,000 0 0 0
57002-59178- INT PD - 05/09 DEBT 540 0 0 0 0 0 ~
57002-59188- INT PD-04/17 DEBT 0 289 120 0 0 0
SUBTOTAL EXPENSES $11,663 $12,159 $10,556 $424 ~ l 1$~ 1 CD ~' :..,
r
$60,000 $65,460 ,~-%
SUBTOTAL METRO SKATING RINK $17,151 $12,159 $11,887 542 570,000 $75,460 ~ ~ ~2~~ Cam' /`/
~~
Li~ -
De Head Sioat re /Date
RECEIVED
UtC 0 2 2019
TOWN OF CANTON
FINANCE DIRECTOR
Date: ]0/16/2019 W:\Munis\MCR Library\Budget reports\New Fiscal Year budget worksheet -Dept Req-enterprise by sal-exp.rpt Page: 10
~
iSource page 191
TOWN OF CANTON
FY 17 FY 19 ACTUAL YTD FY Z~Z~ FY 2021 COMMENT/REASON FOR
FY 18 ORIGINAL
BUDGET REPORT FOR FY 2021 ACTUAL ACTUAL ACTUAL EXPENSE THRU BUDGET
DEPARTMENTAL DEPT INCREASE/DECREASE
DEPARTMENTAL WORKSHEETS EXPENSE EXPENSE 9/30/2019 ~Z~ BASE BUDGET REQUEST
EXPENSE
TOTAL G30 PARKS &RECREATION $17,151 $12,159 $11,887 $424 $70,000 $75,460 `Q,'L~ RUC
D t Head Sign re /Date
Datc: 10/16/2019 W:\Munis\MCR Library\Budget reports\New Fiscal Year budget worksheet -Dept Req-enterprise by sal-exp.rpt p>;,
`~. , _Source page 192
r
FISCAL 2021 DEPARTMENTAL OPERATING BUDGETS ~~~i
PROJECTION: 2021 FY 2021 BASE BU DGET
- - -
- -
ACCOUNTS FOR:
1
--1- ~-
--- -
-
2019
ACTUAL
2020 -
— -
ORIG BUD i
- 2021
-
BASE BUDGET
2021
DEPT. REQ.
~ -
COMMENT
57002' 59130 PRINCIPAL PAYDOWNS - - - - ~ "„
57002 59250' INTEREST TEMPORARY LOANS - - - 50,000 ~ ~'
J __
TOTAL RINK PRINC/INT PAYMENTS - - - 50,000
r
!~ ~ ~~ `'`
~,, ~ )~ ~-
6
Fy 21 budget worksheets.xlsx enterprise funds 11/13/2019Source page 193
DEBT SERVICE PROJECTIONS - DEBT IN PIPELINE ~ ~~I,V
AUTHORIZED Project AUTHORIZED TERM BOND BAN BOND FY
DATE ART # Code PURPOSE UNISSUED (YRS) DATE RATE RATE INT PRIN 2021
5/14/2018 12-7 81910 JFK MODULAR CLASSROOMS 2,000,000 10 Apr-20 2.50% 4.00% 80 200 280
5/13/2019 12-6 82004 PEQUITSIDE FARM PARKING 200,000 10 Apr-20 2.50% 4.00% 8 20 28
5/13/2019 12-6 A2007 FIRE ENGINE REFURBISHMENT 162,000 5 Apr-20 2.50% 4.00% 6 32 39
5/13/2019 12-6 A2007 DPW BOX TRUCK 189,000 10 Apr-20 2.50% 4.00% 8 19 26
5/13/2019 12-8 B2005 SCHOOL BLEACHERS 100,000 10 Apr-20 2.50% 4.00% 4 10 14
5/13/2019 12-8 A2009 WIFI BACKBONE 68,000 5 Apr-20 2.50% 4.00% 3 14 16
5/13/2019 12-8 B2006 HIGH SCHOOL ROOF TOP UNIT 122,000 10 Apr-20 2.50% 4.00% 5 12 17
TOTAL INSIDE LEVY 8,005,000 114 307 421
TOTAL AMBULANCE 0 0 0 0
5/13/2019 20 BPOOL BOLIVAR POOL PROJECT 5,900,000 20 Apr-21 2.50% 4.50% 148 0 148
TOTAL OUTSIDE LEVY 5,900,000 148 0 148
5/14/2018 12-10 A1914 WATER LINE AT SULLIVAN TREATMENT FACILITY 2,440,000 20 Apr-20 2.50% 4.00% 40 50 90
5/13/2019 12-7 A2008 WATER SYSTEM DESIGN COSTS 830,000 5 Apr-20 2.50% 4.00% 33 166 199
TOTAL WATER 3.270.000 73 216 289
12/12/2018 2 RINK REPAIRS 1,983,000 30 Apr-21 2.50% 4.50% 50 0 50
TOTAL RINK 1,983,000 50 0 50
GRAND TOTALS-AUTHORIZED/UNISSUED DEBT 29,086,290 334 523 907
AUTHDEBT.xlsx PIPELINE 11/13/2019