Loading...
HomeMy Public PortalAbout20150421 - Appropriations Committee - Meeting MinutesTown of Hopkinton Appropriation Committee Minutes of Meeting on Tuesday, April 21, 2015 Room 215, Town Hall, Hopkinton, Massachusetts In attendance: Mike Manning Pat Mahon Wayne Pacheco Pam Waxlax Shahidul Mannan Chris Howell Norman Khumalo The meeting was called to order by Mike at 6:33 PM. Pam moved and Pat seconded to open the Public Hearing at 6:34 PM. The motion passed by a vote of 5- 0. Chris walked us through the changes to the financial model (see Attachment 1, page 24.) • Grove St Water Tank and Elementary School - Reflects change to principal borrowing only, does not impact operating budget for FY16. • Water Employee full year - change from half year new hire to full year. Will be split 50/50 between water and sewer enterprise funds. They have estimated that the employee's time will be split evenly between the departments. • Lake Maspenock weed control - The $20k proposed for FY16 maintenance in the last update of the financial model has been removed since it is no longer needed until the plan is implemented. • P&R Enterprise Subsidy - This represents the additional amount Parks & Rec has requested for a subsidy from the general fund based on calculations from Jay Guefli_ Chris will review revenue projections and impact to Retained Earnings since the inception of the enterprise fund in FY12. Norman handed out the Parks & Rec Enterprise Fund analysis since inception in FY12 (see Attachment 2.) There was discussion of what to do with the enterprise fund if it does not move towards self sustaining. Original intent of this enterprise fund was to better track expenses and revenue specific to Parks & Rec. We asked for Jay to attend tomorrow's meeting to better explain this. • Enterprise indirect costs - Original amount was an estimate and the revised amount is based on recalculating the indirect costs to be allocated to the funds. The methodology has not changed in FY16 and is still based on DOR recommendations. Sewer increases about $40k, Water decreases about $23k, and P&R increases about $9k. • Appropriations from Free Cash - this is a revenue adjustment. Reflects net change to items 5, 6, & 7 at the top of this sheet that were not taken into account from the revenue side when the corresponding expense adjustments were made. Norman informed the committee that Free Cash has not yet been submitted to DOR for certification yet. The town's contact at DOR is not back in the office until Thursday. If Free Cash is not certified prior to ATM, it cannot be used as a funding source. Prediction by town is that Free Cash will come in higher than expected. There are a number of options of what we could use this increase for. At 7:32 PM, Pat moved and Wayne seconded to close the public hearing. The motion passed by a vote of 5-0. Shahidul excused himself at the close of the public hearing. At this point the committee started discussing articles and making recommendations. Chris noted that Article 2 now only has amounts related to Lake Maspenock Weed Control and Hydrant Rental. The hydrant rental is to make up for FY14 and FY15 undercharge based on corrected calculations. This article is currently funded by raise and appropriate. Chris noted Article 10 - Chapter 90 Funds now has an amount based on the Governor's budget of $662,271 (see Attachment 1, page 21.) This is down from FY15 by more than $300k but on par with FY12-14. Amount is based on state budget total which is $200 million in FY12,13,14&16 and was $300 million in FY15. Wayne moved and Pam seconded the Appropriation Committee recommend Article 3, FY2012 Budget Transfers, to transfer from the Water Enterprise Retained Earnings $80,000 to Department 450 Water Operating Budget. The motion passed by a vote of 4-0. See Attachment 3 for breakdown of the amounts related to this article. Wayne moved and Pat seconded the Appropriation Committee recommend Article 4 - Tercentennial Funds, to transfer $890.92 from the 300th Anniversary Celebration Committee FY2015 Operating Budget to the Celebrations Special Fund established by Town Meeting May 2014. The motion passed by a vote of 4-0. Wayne moved and Pat seconded the Appropriation Committee recommend Article 9, FY 2016 Revolving Funds as written in draft warrant articles and motions document (see Attachment 4.) The motion passed by a vote of 4-0. Wayne moved and Pam seconded the Appropriation Committee recommend Article 10, Chapter 90 Highway Funds, to appropriate $662,271 from the proceeds due the Town pursuant to Chapter 90 of the Massachusetts General Laws. The motion passed by a vote of 4-0. Wayne moved and Pat seconded the Appropriation Committee recommend Article 21 - Grove Street Water Facility - Engineering, to borrow from the Water Enterprise Fund $75,000. The motion passed by a vote of 4-0. Wayne moved and Pat seconded the Appropriation Committee recommend Article 27 - Roof Repairs - Hopkins and High Schools, borrow via Debt Exclusion $1,114,000. The motion failed by a vote of 1-3. Discussion prior to the vote noted the Gale Report noted Hopkins roof was good for another 2-3 years so we would have liked to see these repairs put forward separately, the work won't be started until next summer so the repairs can be brought forward at Special Town Meeting in the fall with the new school, more emphasis on timing of potential MSBA funding, and roofs should be taken care of now before they become a bigger issue, smaller cost now and get them done at once. Wayne moved and Pat seconded the Appropriation Committee recommend Article 28 - Resurfacing Basketball & Tennis Courts, to transfer from General Fund Free Cash $70,000. The motion passed by a vote of 4-0. Wayne moved and Pam seconded the Appropriation Committee take no action on Article 55 - Ashland - Hopkinton Fire and Emergency Services District. The motion passed by a vote of 4-0. Pat moved and Wayne seconded a motion to approve the minutes of our 4/15/2015 meeting. The motion passed by a vote of 4-0. At 9:05 PM Pam moved and Pat seconded a motion to adjourn. The motion passed unanimously, 4-0. TOWN OF HOPKINTON APPROPRIATIONS COMMITTEE FY2016 BUDGET MATERIALS April 21, 2015 Table of Contents Page Tax Levy Worksheet Financial Model 2 3 Operating Budget General Fund 4 Community Preservation Fund 10 Sewer Enterprise Fund 11 Water Enterprise Fund 12 Parks & Recreation Enterprise Fund 13 Capital Pay-as-you-go 15 Borrowing 16 Strategic Initiatives 17 Other Amounts to Be Raised 19 State Aid & Assessments 20 Chapter10 21 Local Revenues 22 Other Available Funds 23 Track Changes 24 4/21/2015 1 of 24 C:\Users\chowell\Desktop\Documents\FY16\Financial model\Financial Model FY16 v37 TOWN OF HOPKINTON TAX LEVY WORKSHEET LEVY LIMIT Prior Year Levy Limit Prio r Year Amended Growth FINAL FY2016 FY2016 FY2017 FY2018 FY2019 F Y2014 FY2015 BOS REC . UPDATE PROJ PROJ PROJ 47,401,640 49,843,333 51,588,956 51,588,956 54,138,680 56,892,147 59,714,451 Subtotal 47,401,640 49,843,333 51,588,956 51,588,956 2. 5% Increase 1,185,041 1,246,083 1,289,724 1,289,724 New Growth 1,256,652 1,749,540 1,350,000 1,260,000 New Growth Adjustment Override (Underride) (1,250,000) LEVY LIMIT 49,843,333 51,588,956 54,228,680 54,138,680 56,892,147 59,714,451 62,607,312 MA XIMUM ALLOWABLE LEVY Debt Exclusions 3,216,161 2,853,533 2,330,992 2,330,992 2,703,613 5,247,164 6,924,099 MAXIMUM ALLOWABLE LEVY 53,059,494 54,442,489 56,559,672 56,469,672 59,595,760 64,961,615 69,531,411 54,138,680 1,353,467 1,400,000 56,892,147 1,422,304 1,400,000 59,714,451 1,492,861 1,400,000 ACTUAL LEVY 50,839,007 54,152,686 56,403,067 56,436,094 59,408,779 64,027,220 67,857,846 EXCESS LEVY CA PACITY Tax Levy % Increase Tax Levy (net of new growth) Tax Impact (net of new growth) 2,220,487 289,803 156,604 33,577 186,980 934,395 1,673,565 4. 56% 6. 52% 4.16 % 4.22 % 5 .27% 7.77 % 5.98% 49,582,355 52,403,146 55,053,067 55,176,094 58,008,779 62,627,220 66,457,846 1. 98% 3. 08% 1 .66 % 1.89 % 2.79 % 5 .42% 3.80 % 2 of 24 4/21/2015 C:\Users\chowell\Desktop\Documents\FY16\Financial model\Financial Model FY16 v37 TOWN OF HOPKINTON FINANCIAL MODEL OPERATING BUDGET SUMMARY: GENERAL GOVERNMENT PUBLIC SAFETY EDUCATION-HOPKINTON PUBLIC SCHOOLS EDUCATION -REGIONAL TECH VOCH SCH OOL PUBLIC WORKS HEALTH AND HUMAN SERVICES CULTURE AND RECREATION DEBT SERVICE (Excludes CPFd/Enterprise Debt) DEBT SERVICE (Prior Year - BAN Paydowns) EM PLOYEE BENEFITS, INSURANCE & MISCELLANEOUS Strate gic Initiatives (Current projects' future costs) COMMUNITY PRESERVATION FUND SEWER ENTERPRISE FUND WATER ENTERPRISE FUND PARKS & RECREATION ENTERPRISE FUND OTHER AMOUNTS TO BE RAISED: Transfer to G eneral Stabilization Transfer to Capital Stabilizatio n Transfer to OPEB Trust Ge ne ral Fund Capital: Pay-as-you-go 460,253 460,253 411,118 397,954 379,264 368,577 Enterprise Fund Capital: Pay-as-you-go 972,399 742,099 742,099 716,849 800,000 800,000 800,000 Community Preservation Projects/Reservations 67,000 250,000 250,000 250,000 314,093 311,987 309,880 Snow & Ice Supplemental Budget 1,632,630 208,000 887,685 407,000 407,000 1,000,000 1,000,000 1,000,000 Misce llaneous Articles 750,000 750,000 854,565 750,000 750,000 750,000 714,600 1,306,144 Amounts Certified Tax Title Purpose s Unprovided Debt &Interest Charges 44,250 30,625 30,000 30,000 30,000 30,000 30,000 30,000 90,000 Cherry Shee t Offsets -Res Dir Exp 25,023 28,185 27,951 27,951 15,284 15,284 15,284 15,284 Severe Storm Deficit - Prior Year (Irene FY12; Sandy FY13) 41,755 State & County Charges (incl Tuitio n Assessments) 563,953 567,696 567,696 567,696 576,976 576,976 576,976 576,976 Allowance Abatements & Exemptions (O verlay) Supplemental Appropriations 451,125 460,441 450,000 450,000 500,000 450,000 450,000 450,000 232,408 O ther (Utilitie s interest) 253,811 TOTAL AMO UNT TO BE RAISED Total 3,884,147 3,805,898 4,465,684 3,984,999 4,061,792 4,634,307 4,613,510 4,600,717 71,469,986 74,487,818 77,573,353 76,696,531 76,541,473 80,285,462 85,243,542 89,418,154 LESS REVENUE/AVA ILABLE FUNDS: Local Revenue State Aid 3,135,258 3,208,514 3,705,550 3,705,550 3,588,550 3,598,325 3,608,318 3,618,535 MSBA Schoo l Construction Reimbursement 6,905,724 6,976,043 6,956,482 6,956,482 7,052,535 7,052,535 7,052,535 7,052,535 Free 1,487,086 1,487,086 1,487,086 1,487,086 1,487,086 1,487,086 1,487,086 1,487,086 Community Pre se rvation 962,934 2,174,999 1,502,352 1,502,352 1,427,967 1,100,000 1,100,000 1,100,000 Community Pre FundsonFdsDebt/Projecis/Reservations 2,156,389 515,300 1,187,225 706,540 706,540 1,299,540 1,299,540 1,299,540 Other Enterprise Re venue/Enterpriseble Funds 362,793 296,680 75,276 75,276 76,332 166,309 161,931 161,931 Enterprise Free Cash 5,620,794 5,676,510 5,860,177 5,860,177 5,766,368 6,172,887 6,506,912 6,840,681 TOTAL REVENUE/AVAILABLE FDS 20,630,979 20,335,132 20,774,148 20,293,463 20,105,379 20,876,682 21,216,323 21,560,308 VARIANCE/TAX LEVY (50,839,007) (54,152,686) (56,799,205) (56,403,067) (56,436,094) (59,408,779) (64,027,220) (67,857,846) FINAL FY2016 FY2016 FY2016 FY2017 FY2018 FY2019 FY2014 FY2015 TMGR REC. BOS REC. UPDATE PROJ PROJ PROJ 2,594,520 4,404,819 35,585,384 527,192 3,748,822 425,371 373,105 5,511,169 249,334 8,757,906 3,194,616 3,516,356 4,625,419 5,377,078 37,332,422 39,143,441 544,628 571,859 3,996,734 4,160,086 540,974 602,711 388,572 446,104 5,665,676 4,819,601 3,576,356 3,602,778 3,674,834 3,748,330 3,823,297 5,186,010 5,186,010 5,289,730 5.395,525 5,503,435 39,143,441 39,143,441 40,709,179 42,337,546 44,031,048 571,859 386,087 395,739 405,633 415,773 4,160,086 4,060,086 4,141,287 4,224,113 4,308,595 602,711 602,711 614,765 627,061 639,602 446,104 446,104 455,026 464,127 473,409 4,554,531 4,554,531 4,800,145 7,236,366 8,801,776 8,881,555 9,052,452 9,052,452 9,052,452 9,324,025 9,603,746 9,891,858 In Budgets In Budgets In Budgets 680,576 685,606 690,788 326,910 307,300 299,540 299,540 299,540 299,540 299,540 299,540 2,928,089 2,917,512 2,810,782 2,810,782 2,810,782 2,866,998 2,924,337 2,982,824 1,571,447 1,667,399 1,681,931 1,681,931 1,709,431 1,752,317 1,902,419 2,052,044 581,770 619,113 625,729 625,729 625,729 646,993 775,683 903,447 T otal 67,585,838 70,681,920 73,107,669 72,711,532 72,479,681 75,651,155 80,630,032 84,817,437 300,000 300,000 300,000 300,000 300 ,000 300,000 3 of 24 4/21/2015 C:\Users\cho well\Desktop\Do cuments\FY16\Financial model\Fin ancial Model FY16 v37 TOWN OF HOPKINTON OPERATING BUDGET IAPPROPRIATION APPROPRIATION TOWN MGR REC FISCAL 2014 FISCAL 2015 FISCAL 2016 GENERAL -00 -ND IMMENIMINNO MMINIMMIMP GENEt7AL GOVERNMENT 122 SELECTMEN Expenses TOTAL 122 -SELECT MEN 123 TOWN MANAGER Personal Services Expe nses TOTAL 123 -TO WN MANAGER 131 APPROPRIATION COMM ITTEE Expenses -Appro priation Committee 500 500 500 Reserv e Fund 500 500 0.00 % TOTAL 131 -APPROPRIATION COMM ITTEE 125,000 125,000 125,000 125,000 125,000 0.00 % 125,500 125,500 125,500 125,500 125,500 0 0.00% 2,000 2,000 2,000 2,000 2,000 2,000 BOS REC UPDATE FISCAL 2016 FISCAL 2016 2,000 2,000 2,000 2,000 $ Change % Change I 2015-2016 2015-2016 0.00% 0.00% 272,000 293,085 292,917 352,917 352,917 59,833 20.41% 16,400 15,400 15,400 15,400 15,400 288,400 308,485 0.00 % 308,317 368,317 368,317 59,833 19.40% 133 FINANCE DIRECTOR/ACCO UNTANT Personal Services Expenses 209,459 234,859 258,295 258,295 258,295 23,436 9.98% 36,941 32,300 32,300 32,300 TOTAL 133 -FINANCE DIRECTOR/ACCOUNTANT 246,399 32,300 0.00% 267,159 290,595 290,595 290,595 23,436 8.77% 141 ASSESSORS Perso nal Services 170,386 182,883 187,480 187,480 187,480 4,597 2.51% Expenses 8,304 Appraisal Serv ices 5,041 4,729 8,304 8,304 3,575 75.60% TOTAL 141 -ASSESSOR 8,700 8,700 8,300 8,300 8,300 (400) -4.60% 184,127 196,312 204,084 204,084 204,084 7,772 3 .96% 145 TREASURER/COLLECTOR Person al Services 140,098 194,192 283,432 Expenses 283,432 283,432 89,240 45 .95 % 46,651 64,680 82,480 82,480 82,480 17,800 27.52% TOTAL 145-TREASURER/COLLECTO R 186,749 258,872 365,912 365,912 365,912 107,040 41 .35% 151 LEGAL Legal Counsel TOTAL 151 -LEGAL 155 INFORMA TION TECHNO LOG Y Personal Services Expenses 108,536 141,792 172,683 172,683 172,683 30,891 21.79a TOTAL 155 -INFORMATION TECHNOLOGY 209,106 210,000 431,899 431,899 431,899 221,899 105.67% 317,642 351,792 604,582 604,582 604,582 252,790 71.86% 152 HUMAN RESOURCES Person al Services Compensation Reserv e 117,296 136,622 155,988 155,988 155,988 19,366 14.17% 90,000 225,000 245,000 245,000 245,000 20,000 8 .89% Expenses 52,600 TOTAL 152 -HUM AN RESOURCES 24,550 35,100 52,600 52,600 17,500 49.86 % 231,846 396,722 453,588 453,588 453,588 56,866 14 .33 % 150,000 150,000 150,000 180,000 150,000 180,000 180,000 180,000 180,000 180,000 30,000 20 .00% 30,000 20.00% 4 of 24 4/21/2015 C:\Users\chowell\Deskto p\Documents\FY16\Financial model\Financial Model FY16 v37 TOWN OF HOPKINTON OPERATING BUDGET 161 TOWN CLERK Personal Services Expe nses TOTAL 161 -TOWN CLERK 162 ELECTION & REGISTRATION Personal Servi ces Expenses TOTAL 162 -ELECTION & REGISTRATION 170 LAND USE Personal Services Expenses TOTAL 170 -LAND USE APPROPRIATION APPROPRIATION TOWN MGR REC BOS REC UPDATE S Change % Change FISCAL 2014 FISCAL 2015 FISC AL 2016 FISC AL 2016 FISCAL 2016 2015.2016 2015-2016 128,375 113,220 114,531 114,531 114,531 1,312 1 .16% 9,310 14,800 11,340 11,340 11,340 (3,460) -23.38% 137,685 128,020 125,871 125,871 125,871 (2,149) -1.68% 8,301 14,501 8,301 8,301 8,301 (6,200) -42.76% 19,100 19,200 19,200 19,200 19,200 0 .00 % 27,401 33,701 27,501 27,501 27 ,501 (6,200) -18 .40 % 411,785 430,438 433,600 433,600 433,600 3,162 0.73% 20,666 15,595 30,235 30,235 30,235 14,640 93 .88% 432,451 446,033 463,835 463,835 463,835 17,802 3.99% 177 GREEN COMMITTEE Expenses 300 300 300 300 300 0 TOTAL 177 -GREEN COMMITTEE 300 300 0 .00/o 300 300 300 0 .00% 179 O PEN SPACE COMMITTEE Expenses 950 950 3,000 3,000 3,000 2,050 215 .79% TOTA L 179 -OPEN SPACE COMMITTEE 950 950 3,000 3,000 3,000 2,050 215.79% 187 UPPER CHARLES RIVER TRAIL Expenses 300 43,000 54,000 54,000 54,000 11,000 25.58% TOTAL 187 -UPPER CHARLES RIV ER TRAIL 300 43,000 54,000 54,000 54,000 11,000 25 .58% 192 TOWN HALL Expenses 8,270 8,270 8,270 8,270 8,270 0 TOTAL 192 -TOWN HALL 8,270 8,270 8,270 0.00 /u 8,270 8,270 0.00 % 194 CABLE COMMITTEE Expenses TOTAL 194 -CABLE COM MITTEE 500 500 500 500 500 0 .00% 500 500 500 500 500 0.00 % 199 OTHER GENERAL GOVERNMENT Town Reports 3,500 3,500 3,500 3,500 3,500 0.00% A udit 23,000 25,000 25,000 25,000 25,000 0.00% Integrated Financial Management System 175,000 moved to IT M oved to IT (175,000) -100.00% Hydrant Rental 224,000 270,000 270,000 270,000 296,422 26,422 9 .79% Profe ssional Services and Training 3,500 3,500 moved to HR Mo ved to HR TO TAL 199 -OTHER GENERAL GOVERNMENT 254,000 477,000 298,500 298 ,500 324,922 (3,500) -100 .00 (152,078) -31.88 % MT ''.IlENE1' ALIIOVERNME'NT MOON T "• 1`8 3,1516,366 `. 3 `,I,Si'6;35r'. R 3 ", .408,162 1218% 5 of 24 4/21/2015 C:\Users\chowell\Desktop\Documents\FY16\Financial model\Financial M odel FY16 v37 TOWN OF HOPKINTON OPERATING BUDGET PUBLICSAFEVY .. 210 POLICE Personal Services Expenses Auxiliary Polic e Exp enses TOTAL 210 -POLICE 220 FIRE Perso nal Services Expenses TOTAL 220 -FIRE 235 PUBLIC SAFETY DISPATCH Personal Service s Expenses TOTAL 235 -PUBLIC SAFETY DISPATCH 244 SEALER OF WEIGHTS & MEASURES Personal Services Expenses TOTAL 244 -SEALER OF WEIGHTS & MEASURES 292 DOG OFFICER Personal Serv ices Ex penses Capital Items TOTAL 292 -DOG OFFICER 293 TRAFFIC CONTROL Traffic Lights TOTAL 293 -TRAFFIC CONTROL 294 TREE WARDEN Personal Serv ice s Ex pen se s TOTAL 294 -TREE WARDEN eat* 300 HOPKINTON PUBLIC SCHO OLS TOTAL 300-HO PKINTON PUBLIC SCHOO LS 800 REGIONAL TECH. VOCATIONAL SCHOOL TOTAL 800 -REGIONAL TECH. VOCATIONAL SCHOOL APPR OPRIATION APPROPRIATION T OWN MGR REC FISCAL 2014 FISCAL 2015 FISCAL 2016 B OS REC FISCAL 2016 UPDATE FISCAL 2016 $ Change % Change 2015-2016 2015-2016 2,120,648 158,508 3,000 2,282,156 1,899,456 139,449 2,038,905 3,036 953 3,989 21,881 5,356 27,237 19,300 19,300 14,354 18,878 33,232 35,585,384 35,585,384 527,192 527,192 v177 :7311,1 fZrie 2,221,430 170,644 3,000 2,395,074 2,003,423 141,520 2,144,943 3,036 953 3,989 21,881 7,000 28,881 19,300 19,300 14,354 18,878 33,232 37,332,422 37,332,422 544,628 544,628 2,149,310 181,087 3,000 2,333,396 2,249,953 154,351 2,404,304 553,335 9,850 563,185 3,036 1,000 4,036 2,094,310 181,087 3,000 2,278,396 2,113,886 154,351 2,268,237 553,335 9,850 563,185 3,036 1,000 4,036 22,561 22,561 7,000 7,000 29,561 29,561 M oved to P ublic Works M oved to Public Works M oved to Public Works r •,01 2,094,310 181,087 3,000 2,278,396 2,113,886 154,351 2,268,237 553,335 9,850 563,185 3,036 1,000 4,036 22,561 7,000 29,561 (127,120) 10,443 (116,677) 110,462 12,831 123,293 553,335 9,850 563,185 0 47 47 680 680 -5.72% 6 .12% 0.00 % -4.87 % 5.51 % 9 .07% 5 .75% 0 .02 % 4 .93% 1 .19% 3.11 % 0.00% 2 .35% (19,300) -100 .00 % (33,232) -100.00% 5,'f$80fO"`' $'6,591 "12,12% 39,143,441 39,143,441 39,143,441 39,143,441 571,859 571,859 5 571,859 571,859 39,143,441 1,811,019 39,143,441 1,811,019 4 .85 % 4 .85 % 386,087 (158,541) -29 .11% 386,087 (158,541) -29.11% 2,47 -4.364C 6of24 4/21/2015 C:\Users\chowell\Desktop\Documents\FY16\Financial model\Financial Model FY16 v37 TOWN OF HOPKINTON OPERATING BUDGET PUBLIC WORKS 410 ENGINEERING & FACILITIES Personal Services Expenses TOTAL 410 -ENGINEERING & FACILITIES 420 DEPARTMENT OF PUBLIC WORKS ADMINISTRATION Pe rsonal Services TOTAL 420 -DEPARTMENT OF PUBLIC WORKS APPROPRIATION APPROPRIATI ON TOWN MGR REC FISCAL 2014 FISCAL 2015 FISC AL 2016 BOS REC UPDATE $ Chang e % Cha nge FISCAL 2016 FISCAL 2016 2015-2016 2015-2016 163,747 171,843 176,356 176,356 176,356 4,513 2.63% 590,522 613,242 655,228 655,228 615,228 1,986 0.32 % 754,269 785,085 831,584 831,584 791,584 6,499 0.83% 373,440 379,130 383,742 383,742 373,440 379,130 383,742 383,742 383,742 383,742 4,612 4,612 1.22% 1.22% 422 HIGHWAY Pe rso nal Services 688,512 696,864 739,750 739,750 739,750 42,886 6.15% Expe nses 193,430 308,025 453,200 453,200 453,200 145,175 47.13% SUB -TOTAL 422-HWY SALARIES & EXPENSES 881,942 1,004,889 1,192,950 1,192,950 1,192,950 188,061 18.71% Road M aintenance 167,175 153,175 (153,175) -100 .00 % Sto rmwater System Improv ements 150,000 150,000 150,000 150,000 150,000 0.00% Pavement Managemen t Town Ha ll Pav ing 130,000 Lake Maspenock Weed Control 60,000 60,000 Sidewalk Maintenance 50,000 50,000 50,000 50,000 0 .00% TOTAL 422 -HIGHWAY 1,329,117 1,358,064 1,452,950 1,452,950 1,392,950 34,886 2.57 % 423 SNOW & ICE CONTROL Snow & Ice Control 200,000 350,000 350,000 350,000 350,000 0 .00 % TO TAL 423 -SNOW & ICE CO NTROL 200,000 350,000 350,000 350,000 350,000 0.00 % 424 STREET LIGHTS Street Lights 53,796 53,796 53,796 53,796 53,796 0.00 % TOTAL 424 -STREET LIGHTS 53,796 53,796 53,796 53,796 53,796 0 0.00 % 426 TRAFFIC CONTROL Traffic Lights TOTAL 426 -TRA FFIC CONTROL Mo ved fro m Public Safety 30,000 30,000 30,000 30,000 30,000 30,000 427 TREE WARDEN Perso nal Service s Moved from Public Safe ty 14,354 14,354 14,354 Expenses Mov ed from Public Safe ty 25,000 25,000 25,000 TOTAL 427 -TREE WARDEN 39,354 39,354 39,354 30,000 39,354 429 OTHER STO RM CONTROL Personal Services 8,000 8,000 8,000 8,000 Expenses 10,000 10,000 2,000 2,000 2,000 (8,000) -80.00 % TOTAL 429 -OTHER STORM CONTROL 10,000 10,000 10,000 10,000 10,000 0.00 7 of 24 4/21/2015 C:\Users\chowell\Desktop\Documents\FY16\Financial model\Financial Model FY16 v37 TOWN OF HOPKINTON OPERATING BUDGET 433 WASTE COLLECTION AND DISPOSAL Recy cling Salaries Rubbish C oll ection/Dispos al Rubbish Disposal Recycling Expense Recycling Collectio n/Disposal Ho usehold Hazardous Waste C ollection TOTAL 433 -WASTE COLLECTI ON AND DISPOS AL 491 CEMETERY CO MMISSION Personal Serv ices Expens es TOTAL 491 -CEMETERY COMMISSION TOTAL PUBLIC WORKS HEALTH & HUMAN SERVICES APPROPRIATION APPROPRIATION TOWN MGR REC BOS REC UPDATE $ Change % Change FISCAL 2014 FISCAL 2015 FISCAL 2016 FISCAL 2016 FISCAL 2016 2015-2016 2015-2016 8,000 8,000 8,000 8,000 8,000 0 .00% 425,000 439,280 439,280 439,280 439,280 - 0.00 % 373,000 380,460 328,460 328,460 328,460 (52,000) -13 .67% 10,000 10,000 10,000 10,000 10,000 0 .00% 200,000 206,720 206,720 206,720 206,720 0.00 % 12,000 12,000 12,000 12,000 12,000 0 .00% 1,028,000 1,056,460 1,004,460 1,004,460 1,004,460 (52,000) -4.92 % 200 200 200 200 200 0 .00% 4,000 4,000 4,000 4,000 0.00% 200 4,200 4,200 4,200 4,200 0.00% Y4822 60,086 111111111M160,086 4,060, _O_ e -83,351 1$9% 510 BOARD OF HEALTH Perso na l Services 83,215 Expen ses 19,126 Capital Items 188 TOTAL 510 -BOA RD OF HEALTH 102,529 112,244 130,554 130,554 130,554 18,310 16.31% 51,741 77,785 77,785 77,785 26,044 50.34 % 163,985 208,339 208,339 208,339 44,354 27.05% 541 SENIOR CENTER Person al Services 195,882 220,493 233,391 233,391 233,391 12,899 5 .85 % Expenses 24,227 29,355 32,499 32,499 32,499 3,144 10.71% TOTAL 541 -SENIOR CENTER 220,109 249,848 265,891 265,891 265,891 16,043 6 .42% 542 YO UTH SERVICES Pers on al Services 40,472 66,002 66,002 66,002 66,002 0.00% Expense s 6,000 6,000 6,001 6,001 6,001 1 0.01% TOTAL 542 -YOUTH SERVICES 46,472 72,002 72,002 72,002 72,002 1 0 0.00% 543 VETERANS SERVICES Veterans District Assessment Veterans Serv ice Benefits Veterans Supplies TOTAL 543 -VETERANS SERVICES TOTA L HSALTh & HUMAN SERVICES 21,939 21,939 23,229 23,229 23,229 1,290 5.88 % 34,321 32,000 32,000 32,000 32,000 - 0.00% 1,200 1,250 1,250 1,250 50 4.17% 56,260 55,139 56,479 56,479 56,479 1,340 2.43% 002,711 802 ,711 602,711 61,738 11 .41% 8 of 24 4/21/2015 C:\Users\chowell\Desktop\Documents\FY16\Financial model\Financial Model FY16 v37 TOWN OF H OPKINTON OPERATING BUDGET CULTURE & RECREATION 610 LIBRARY Personal Ser vices Expenses TOTAL 610 -LIBRARY 691 HISTORIC COMMISSION Historic Commissi on Expense TOTAL 691 -HISTORIC COMMISSION 692 CELEBRATIONS Memorial Day TOTAL 692 -CELEBRATIONS APPROPRIATION APPROPRIATION TOWN MGR REC BOS REC UPDATE $ Change % Change FISCAL 2014 FISC AL 2015 FISCAL 2016 FISCAL 2016 FISC AL 2016 2015-2016 2015-2016 693 300TH ANNIVERSARY COMMITTEE 300TH ANNIVERSARY TOTAL 693.300TH ANNIVERSARY CO MMITTEE 322,993 327,460 31,562 32,562 354,555 360,022 350,192 350,192 350,192 22,732 6.94% 32,362 32,362 32,362 (200) -0 .61% 382,554 382,554 382,554 22,532 6.26% 1,000 1,000 11,000 11,000 1,000 1,000 11,000 11,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 11,000 11,000 10,000 1000.00% 10,000 1000.00% 2,000 0.00% 2,000 0.00% 15,000 25,000 50,000 50,000 50,000 25,000 100.00% 15,000 25,000 50,000 50,000 50,000 25,000 100 .00% 695 HISTORIC DISTRICT COM MISSIO N Histo ric District Commissio n Expenses 550 550 550 550 TOTAL 695 -HISTORIC DISTRICT COMMISSION 550 550 550 550 550 550 0 .00% 0.00% TOTAL CULTURE & RECREAP{A .373,705 - - _ - - - � _. - .._ X72 446,104 446,104 446,104 57,532 14.81% DEB`S' akilld ' 700 DEBT AND INTEREST Retirement of Debt 4,530,492 4,249,731 3,890,978 3,890,978 3,890,978 (358,753) -8,44% Lo ng Term Intere st 959,119 787,945 908,623 643,553 Sho rt Term Interest 643,553 (144,392) -18 .33% 21,558 15,000 20,000 20,000 20,000 5,000 33 .33% Estimate for Authoriz ed/Uniss ued 613,000 TOTAL 700 -DEBT SERVICE 5,511,169 5,665,676 4,819,601 4,554,531 4,554,531 (613,000) -100.00 (1,111,145) -19.61% TO TAL DEBT SERVICE - -- - 6.. -. 11,189'885,876 4,81986'1 d�5d,531 4554,531 , (1,11,145) _ -19.61% EMPLOYEE BEN<=ITS & INSURANCE 910 EMPLOYEE BENEFITS, INSURANCE & MISCELLANEOUS Unemployment Ins urance 145,000 145,000 145,000 145,000 145,000 u Medicare Tax, Employe r Share 530,000 530,000 0 .00 /° 530,000 530,000 530,000 0.00% Life Insurance Premiums 3,000 10,000 10,000 10,000 10,000 - ° Health Insurance Premium 5,963,293 5,963,293 6,210,708 6,210,708 6,210,708 247,415 4.115% Middlesex Cou nty Asse ssment 1,705,613 1,812,062 1,728,744 1,728,744 1,728,744 (83,318) -4.60 % Drug and Alcoho l Testing 3,000 3,000 3,000 3,000 3,0000.00 % Blanket In surance Premiums 1 408,000 418,200 425,000 425,000 425,000 6,800 1.63% TOTAL E&LOYEE BENEFITS & INSURANCE �-.5 _'- '8,757,906 8,881,555 9,052,452 9,052,452 9,052,452 170,897 1.92°k reIT G"OMERAL FUND ,928,288 65,170,596 67,689,688 67,293,550 67,034,200 1,863,604 _T_ 2,88% 9 of 24 4/21/2015 C:\Users\cho well\Desktop\Documents\FY16\Financial model\Financial Model FY16 v37 TOWN OF H OPKINTON OPERATING BUDGET APPROPRIATION APPROPRIATI ON TOWN MGR REC FISCAL 2014 FISCAL 2015 FISCAL 2016 BOS REC FISCAL 2016 UPDATE $ Change % Change FISCAL 2016 2015-2016 2015-2016 193 CPA ADMINISTRATIVE EXPENSES Pers onal Services Expenses TOTAL CPA ADMINISTRATIVE EXPENSES 700 DEBT SERVICE Re tirement of Debt Lo ng Term Interest TOTAL CPA DEBT IMEMMUNtritrtadiVATioNTURD "`r 10,000 30,000 40,000 237,000 49,910 286,910 10,000 45,000 55,000 210,000 42,300 252,300 10,440 45,000 55,440 210,000 34,100 244,100 10,440 45,000 55,440 210,000 34,100 244,100 10,440 45,000 55,440 210,000 34,100 244,100 (8,200) 440 4.40% 0 .00 % 440 0 .80 % 0 .00 % (8,200) -19 .39% -3.25 % 10of24 4/21/2015 C:\Users\chowell\Desktop\Documents\FY16\Financial model\Financial Model FY16 v37 TOWN OF HOPKINTON OPERATING BUDGET S'EVNIVENTERPWRI CPUND DIRECT COSTS 440 SEWER OPERATING BUDGET Personal Services Expenses TOTAL SEWER OPERATING BUDGET APPROPRIATION APPROPRIATION TOWN MGR REC FISCAL 2014 FISCAL 2015 FISCAL 2016 BOS REC UPDATE FISCAL 2016 FISCAL 2016 $ Change % Ch ange 2015-2016 2015-2016 144,823 145,725 181,299 181,299 181,299 35,574 24 .41% 1,044,550 848,550 853,655 853,655 853,655 5,105 0 .60 % 1,189,373 994,275 1,034,954 1,034,954 1,034,954 40,679 4 .09 % 700 DEBT SERVICE Interest on Short Term Debt 10,000 (10,000) -100 .00% Interest on Lo ng Term Debt 416,573 469,095 317,922 317,922 317,922 (151,173) -32 .23% Sewer Maturing Prin cipal 1,314,143 1,373,142 1,449,906 1,449,906 1,449,906 76,764 5.59% Administrative Costs 8,000 8,000 8,000 8,000 8,000 0.00% Estimate for Authorized/Unissued 63,000 (63,000) -100.00% TOTAL SEWER DEBT SERVICE 1,738,716 1,923,237 1,775,828 1,775,828 1,775,828 (147,409) -7 .66 % SUBTOTAL SEWER ENTERPRISE FUND 2,928,089 2,917,512 2,810,782 2,810,782 2,810,782 (106,730) -3.66% INDIRECT COSTS Amounts to be raised an d appropriated in the General Fund operating b udget and all ocated to the Enterprise Fund f or funding: 250,451 250,451 260,076 260,076 300,021 49,570 19 .79% ie i7 3 Tf6s80 "'"T Aio)... 4.80% 11 of 24 4/21/2015 C:\Users\chowell\Deskto p\Documents\FY16\Financial model\Financial Model FY16 v37 TOWN OF HOPKINTON OPERATING BUDGET APPROPRIATION APPROPRIATION TOWN MGR REC FISCAL 2014 FISCAL 2015 FISCAL 2016 BOS REC UPDATE $ Change % Change FISCAL 2016 FISCAL 2016 2015-2016 2015.2016 WATEMIUMETUND - ,.. +?ti DIRECT COSTS 450 WATER OPERATING BUDGET Personal Services Expenses TOTAL450- WATER OPERATING BUDGET 303,865 307,924 350,808 350,808 378,308 70,384 22.86 % 623,500 623,500 649,150 649,150 649,150 25,650 4 .11 % 927,365 931,424 999,958 999,958 1,027,458 96,034 10.31 % 700 DEBT SERVICE Interest on Short Term Debt 10,000 (10,000) -100 .00 % Interest on Lo ng Term Debt 117,949 112,242 110,434 110,434 110,434 (1,808) -1.61% Water Maturing Principal 454,533 419,333 497,539 497,539 497,539 78,206 18 .65% Administrative Costs 1,600 2,000 2,000 2,000 2,000 0 .00% Ashland Obligation 70,000 72,000 72,000 72,000 72,000 0 .00% Estimate fo r Authorized/Unis sued 120,400 (120,400) -100 .00% TOTAL WATER DEBT SERVICE 644,082 735,975 681,973 681,973 681,973 (54,002) -7.34% SUBTOTAL WATER ENTERPRISE FUND 1,571,447 1,667,399 1,681,931 1,681,931 1,709,431 42,032 2 .52% INDIRECT COSTS Amounts to be raised and appro priated in the General Fund operati ng budget and allocated to the Enterprise Fund for funding: 314,415 314,415 324,040 324,040 301,771 (12,644) -4.02% TOTEWATEWIWIRIbt PIM `„ ' " ,,, ,, rTor771,8814162 ,, • , �� s ' 29,38r - 148% 12 of 24 4/21/2015 C:\Users\chowell\Desktop\Documents\FY16\Financial model\Financial Model FY16 v37 TOWN OF HOPKINTON OPERATING BUDGET APPROPRI ATION APPROPRIATION TOWN MGR REC B OS REC UPDATE $ Change % Change FISCAL 2014 FISCAL 2015 FISCAL 2016 FISCAL 2016 FISCAL 2016 2015-2016 2015-2016 DIRECT COSTS 630 PA RKS & RECREATION OPER ATING BUDGET Personal Services Expenses TO TAL 630 -PARKS & RECREATION 179,210 355,800 535,010 187,663 387,800 575,463 195,679 387,800 583,479 195,679 387,800 583,479 195,679 8,016 4 .27% 387,800 0 .00% 583,479 8,016 1.39% 700 DEBT SERVICE Intere st on Short Term Debt In terest on Long Term Debt 9,760 8,650 7,250 7,250 7,250 (1,400) -16.18% Parks & Recreation Maturing Principal 37,000 35,000 35,000 35,000 35,000 0.00 % TOTAL PARKS & RECREATION DEBT SERVICE 46,760 43,650 42,250 42,250 42,250 (1,400) -3.21 % SUBTOTAL PARKS & RECREATION ENTERPRISE FUND 581,770 619,113 625,729 625,729 625,729 6,616 1.07% INDIRECT COSTS Amounts to be raised and appropriated in the General Fu nd operating budget and allocated to the Enterprise Fund for funding: 27,620 27,620 27,620 27,620 36,657 9,037 32 .72% i1 , THE REA- fld l: R$NI? 90 "T 2 13 of 24 4/21/2015 C:\Users\chowell\Deskto p\Documents\FY16\Financial model\Financial Model FY16 v37 TOWN OF HOPKINTON OPERATING BUDGET APPROPRIATION SUMMARY APPROPRIATION APPROPRIATION TOWN MGR REC BOS REC UPDATE $ Change % Change FISCAL 2014 FISCAL 2015 FISCAL 2016 FISCAL 2016 FISCAL 2016 2015.2016 2015-2016 GENERAL FUND General Government 2,594,520 3,194,616 3,516,356 3,576,356 3,602,778 408,162 12.78% Public Safety 4,404,819 4,625,419 5,377,078 5,186,010 5,186,010 560,591 12.12 % Education - Hopkinton Public Scho ols 35,585,384 37,332,422 39,143,441 39,143,441 39,143,441 1,811,019 4 .85% Education -Regional Schools 527,192 544,628 571,859 571,859 386,087 (158,541) -29 .11% Public Works 3,748,822 3,996,734 4,160,086 4,160,086 4,060,086 63,351 1 .59% Health & Human Services 425 ,371 540,974 602,711 602,711 602,711 61,738 11.41% Culture & Recreation 373,105 388,572 446,104 446,104 446,104 57,532 14.81% Debt Service 5,511,169 5,665,676 4,819,601 4,554,531 4,554,531 (1,111,145) -19 .61% Employee Benefits & Insuranc e 8,757,906 8,881,555 9,052,452 9,052,452 9,052,452 170,897 1 .92 % GENERAL FUND 61,928 ,288 65,170,596 67,689,688 67,293,550 67,034,200 1,863,604 2 .86% COMMUNITY PRESERVATION FUND 326,910 307,300 299,540 299,540 299,540 (7,760) -2.53% SEWER ENTERPRISE FUND 2,928,089 2,917,512 2,810,782 2,810,782 2,810,782 (106,730) -3 .66% WATER ENTERPRISE FUND 1,571,447 1,667,399 1,681,931 1,681,931 1,709,431 42,032 2.52 % PARKS & RECREATION ENTERPRISE FUND 581,770 619,113 625,729 625,729 625,729 6,616 1.07 % TOTAL OPERATING BUDGET 67,336,504 70,681,920 73,107,669 72,711,532 72,479,681 1,797,761 2 .54 % 14 of 24 4/21/2015 C:\Users\chowell\Desktop\Documents\FY16\Financial model\Financial Model FY16 v37 Tow n of Hopkinton Capital Expenditures Proposed to be Pay-as-y ou-g o FINAL FY16 FY16 FY16 PROJ PROJ PROJ Pro ject Dept FISCAL 2015 REQUESTED BOS REC . UPDATE FISCAL 2017 FISC AL 2018 FISCAL 2019 GENERAL FUND 800,000.00 800,000.00 800,000.00 Portable Radios Polic e 49,500 .00 49,500.00 49,500.00 Cruiser Replacements Police 117,000.00 78,000 .00 78,000.00 Car 4 Replacement Fire 52,900.00 Cardiac Monitor Replacement Fire 28,099 .00 28,099 .00 28,099.00 Public Safety Dispatch Equipment Fire 81,500.00 81,500.00 16,250.00 HHS Basketball and Tennis Courts Resurfacing School 70,000.00 Police Station Parking Lot Expansion Engineering 75,000.00 75,000.00 75,000 .00 LED Streetlight Conversion Engineering 175,000.00 175,000.00 175,000.00 Elmwo od Farm Parking Area Engineering 40,000 .00 Sno w Dump Cleanup Public Works 140,000.00 140,000.00 140,000.00 Pickup Truck Replacement Public Works 58,000.00 Loa der Mo unted Snow Blower Public Works 115,000 .00 115,000 .00 115,000.00 SUBTOTAL 972,399.00 961,999 .00 742,099.00 716,849.00 800,000.00 800,000.00 800,000 .00 SEWER ENTERPRISE FUND Sewer System Capacity & Business Analysis Public Works 140,000 .00 140,000.00 140,000 .00 SUBTOTAL 140,000.00 140,000.00 140,000.00 WATER ENTERPRISE FUND Fruit St Aquifer Analysis Public Works 75,000.00 75,000 .00 75,000.00 Whitehall Wells Test Installation Public Works 35,000 .00 35,000.00 35,000.00 SUB TOTAL 110,000.00 110,000 .00 110,000.00 15 of 24 4/21/2015 C:\Users\chowell\Desktop\Documents\FY16\Financial model\Financial Model FY16 v37 Town of Hopkinto n Capital E xp enditures Proposed to Be Paid by Borrowing Dept GENERAL FUND Pu blic Works School Fire Town & School Pu blic Works Town & School Scho ol School Project DPW Facility ' HHS & Hopkins Roof Repairs' Rescue 1 Replacem ent Town -wide Security Upgrades 10 Wheel Dump Truck Joint Town/School Technology School Safety & Security HMS Fire Alarm System SUBTOTAL WATER ENTERPRISE FUND Public Works Cedar St Water Main Replacement Public Works Public Works Public Works Fruit St We ll Blendin g Facility Engineering Pickup Truck Grove St Water Tank Replacement Eng. SUBTOTAL PARKS & RECREATION ENTERPRISE FUND Parks & Rec Fruit St Auxiliary Facility SUBTOTAL School Elementary School* * Modeled as debt exclusion. Pri ncipal Borrowing 14,100,000 1,114,000 680,000 300,000 240,000 200,000 200,000 170,000 17,004,000 Projected Principal & Interest Payments FY2017 FY2018 PROJ PROJ FY2019 PROJ FY2020 PROJ FY2021 PROJ TOTAL 2017-2021 352,500 1,392,375 1,357,125 1,321,875 1,286,625 5,710,500 22,280 153,732 149,276 144,820 140,364 610,472 11,900 157,420 152,660 147,900 143,140 613,020 5,250 69,450 67,350 65,250 63,150 270,450 4,200 55,560 53,880 52,200 50,520 216,360 3,500 46,300 44,900 43,500 42,100 180,300 3,500 46,300 44,900 43,500 42,100 180,300 2,975 39,355 38,165 36,975 35,785 153,255 406,105 1,960,492 1,908,256 1,856,020 1,803,784 7,934,657 260,000 4,550 60,190 58,370 56,550 54,730 234,390 100,000 1,750 23,150 22,450 21,750 21,050 90,150 87,000 1,523 20,141 19,532 18,923 18,314 78,431 50,000 875 11,575 11,225 10,875 10,525 45,075 497,000 8,698 115,056 111,577 108,098 104,619 448,046 500,000 500,000 18,001,000 27,000,000 8,750 115,750 112,250 108,750 105,250 450,750 8,750 115,750 112,250 108,750 105,250 450,750 423,553 2,191,298 2,132,083 2,072,868 2,013,653 8,833,453 0 675,000 2,666,250 2,598,750 2,531,250 2,463,750 16of24 4/21/2015 C:\Users\chowell\Desktop\Documents\FY16\Financial model\Financial Model FY16 v37 Town of H opkinton Strategic Initiati ves De partment Town Manager Historical Commission Human Resources Human Resources Technology Techno logy Town Clerk Police IT Po lic e Dispatch Fire Fire Fire Fire Public Works Public Works Public Works Public Works Public Works Public Works Se nio r Cente r Se nio r Center Senio r Center Sen ior Center Senior Ce nte r Senior Center Senior Center Senior Center Library Library Parks & Recreation Historic commission Strategic Initiative Assistant Town Manag er - Add Position Ben efits' Grant Writer -Add P ositi on Ben efits' • Cultural Resources Master Plan Employee trainings Meetings P ending Disc ussion Network/Server Audit, Monitoring and S upp ort Dispatch software Administrative Assistant Position Benefits' Lieutenant position: Sal ary Benefits' Peripheral costs Cross Match ID So ftware Personnel Personnel FTE Position s Benefits' New FTE Equipment Overtime Personn el Training Project Inspector/Environ mental Compliance Manager Benefits' Cost avoidance projecte d Water/Sewer Operations Manager from Enterprise Benefits' from Enterprise (added to dir/Intl costs) Lake Maspenock Weed Control Traffic lights Cemetery tre e removal Road line painting Re ceptionist - Part time Kitchen Manager/Coo k Benefits* Increa se in hours for Volunte er Coo rdinator As sistant Directors increase in hours Volunteer Coordina tor Inc rease hours Va n Driver additional funding Programming/Healthy Co oking Conference s Information Services to Patron (Saturdays) Young Adult Librarian. Pa rt-time Personnel Expenses Building repairs • Bene fits not included In department requ ests. Pro jected at 35% base wage s, increasing 3% a nnually. FY2016 REQUEST 120,000.00 42,000.00 65,000 .00 22,750.00 10,000.00 14,000.00 400 .00 15,000.00 6,800 .00 40,000 .00 14,000.00 110,000.00 38,500 .00 10,000.00 10,000.00 37,584.00 120,121.72 42,042.60 12,831.00 15,945.97 19,752 .97 60,000 .00 21,000 .00 (70,000.00) 55,000.00 19,250.00 60.000 .00 10,700 .00 6,523.00 21,000.00 13,389.30 23,490.00 8,221.50 5,794.20 11,055.96 5,794.20 2,000.00 2,500.00 1,600.00 2,568.00 24,500.00 8,000.00 1,059,114. 42 Enterprise Funds General Fun d FY2016 TMGR REC. 10,000 .00 14,000.00 15,000.00 6,800.00 110,000.00 19,250.00 10,000.00 10,000.00 37, 584.00 120,121 .72 21,021.30 12,831.00 15,945 .97 19,752.97 55,000.00 19,250.00 60.000.00 10,700.00 6,523.00 11,055.96 2,000 .00 2 ,500 .00 2,568.00 12,500.00 604,403.92 (74,250.00) 530,153.92 FY2016 BOS REC. 60,000 .00 10,000 .00 14,000 .00 15,000.00 6,800.00 55, 000.00 19,250 .00 10,000.00 10,000 .00 37,584.00 12,831.00 19,752.97 55,000.00 19,250.00 60, 000.00 10,700 .00 6,523.00 11,055 .96 2,000.00 2,500.00 2,568.00 12,500.00 452,314.93 74,250.00 526,564.93 FY2016 UPDATE 60,000.00 10,000.00 14,000.00 FY2017 PROJ 120 ,000.00 43,260.00 FY2018 PR OJ 120,000.00 44,557.80 FY2019 PR OJ 120.000 .00 45,894.53 14,000.00 14,000.00 14,000.00 15, 000 .00 15, 000 .00 15, 000.00 15, 000.00 6,800 .00 6,800 .00 6,800.00 6,800.00 55,000 .00 110,000.00 110 ,000.00 110,000 .00 19,250.00 39,655.00 40,844.65 42,069.99 10,000 .00 10,000 .00 37,584 .00 12,831.00 19,752.97 55,000.00 19,250 .00 10,700.00 6,523.00 11,055 .96 2,000 .00 2,500.00 2,568.00 12,500.00 392,314.93 74,250.00 466,564.93 120,121.72 43,303.88 12,831.00 60,000.00 21,630.00 (70,000.00) 55,000.00 19,827.50 20,000.00 6,523.00 11,055 .96 2,000.00 2,500.00 120,121 .72 44,603.00 12,831.00 60,000 .00 22,278 .90 (70,000.00) 55,000.00 20,422 .33 20,000 .00 6,523.00 120,121.72 45,941.09 12,831.00 60,000.00 22,947 .27 (70,000.00) 55,000.00 21,034.99 20,000.00 6,523.00 11,055 .96 11,055.96 2,000.00 2,500 .00 2,500.00 2,000 .00 2,568.00 2,568.00 2 ,568.00 24,500.00 24,500.00 24 ,500 .00 680,576.06 74,827.50 755,403.56 685,606 .35 75,422.33 761,028 .68 690,787 .55 76,034 .99 766,822.55 17 of 24 4/21/2015 C:\Users\chowell\Desktop\Documents\FY16\Financial model\Financial Model FY16 v37 Town of H opkinton Strategic Initiatives FY2016 FY2016 FY2016 FY2016 FY2017 FY2018 FY2019 Department Strategic Initiative REQUEST TMGR REC. BOS REC. UPDATE PROJ PROJ PROJ School Department Payr oll: Pr op os ed Staff Additions 701,696 .00 701,696.00 701,696 .00 701,696 .00 C ost of Athletic C oaches 19,755.00 19,755 .00 19,755.00 19,755 .00 Savings from proposed staff reductions (314,020.00) (314,020.00) (314,020.00) (314,020.00) Di scretionary Payroll Cost Increase 407,431.00 407,431.00 407,431 .00 407,431 .00 Expenses: Technology 74,649 .00 74,649 .00 74,649.00 74,649.00 Central Office Curriculum (40,124 .00) (40,124.00) (40,124 .00) (40 ,124 .00) Pro fessional Dev elopme nt 19,424 .00 19,424.00 19,424.00 19,424.00 Athletics Building & Grounds (62,750 .00) (62,750 .00) (62,750.00) (62,750.00) Occupation Day Tuition SPED Regular Education (31,011.00) (31,011 .00) (31,011 .00) (31,011.00) Discretionary Expense Cost I ncrea se (39,812.00) (39,812.00) (39,812.00) (39,812.00) Total Discretionary Cos t Changes 367,619.00 367,619 .00 367,619.00 367,619.00 Total To wn & Schoo l Initiatives 1,426,733.42 897,772.92 819,933 .93 759,933 .93 680,576.06 685,606 .35 690,787 .55 18 of 24 4/21/2015 C:\Users\chowell\Desktop\Documents\FY16\Financial model\Financial Model FY16 v37 Town of Hopkinton Other Amounts to Be Raised FY 2015: Prior years hydrant rental owed to water enterprise Lake Maspenock Weed Control Unpaid bills of a prior year Cook and Company Pete's Tire Barn Stuart Dean Co. , Inc. Wex Bank Zee Medical FY2016: Allowance for abatements and exe mptions (Overlay) Amo unts certified for tax title purposes Snow & Ice supplemental budget 167,360 .00 60,000.00 1,620.00 396 .00 850.00 1,870 .80 310.80 232,407.60 500,000.00 30, 000.00 854, 565 .38 1,384,565 .38 19 of 24 4/21/2015 C:\Users\chowell\Desktop\Documents\FY16\Financial model\Financial Model FY16 v37 Town of Hopkinton State Aid and Assessments FY2014 FY2015 FY2016 FY2016 FY2017 FY2018 FY2019 STATE AID Actual Actual Level Gov. Pr ojected Projected Pr ojected Education Programs: Chapter 70 5,789,203 5,873,878 5,873,878 5,943,658 5,943,658 5,943,658 5,943,658 Charter Tuition Assessment Reimbursem ent 47,709 30,764 30,764 21,706 21,706 21,706 21,706 Edu cation Offset Items School Lunch 14,152 12,617 12,617 Sub -Total, All Education Programs 5,851,064 5,917,259 5,917,259 5,965,364 5,965,364 5,965,364 5,965,364 Gen era l Gov ernment Pro grams Unrestricted Ge neral G overnment Aid 680,140 680,143 680,143 724,166 724,166 724,166 724,166 Veterans Benefits 25,227 18,808 18,808 20,450 20,450 20,450 20,450 Exe mptions: Ve terans, Blind Persons , Surviving Spouses & Elde rly 28,881 27,958 27,958 30,291 30,291 30,291 30,291 State Owned Land 309,541 296,980 296,980 296,980 296,980 296,980 296,980 Gen eral Gov ernme nt Offset Ite m Public Libraries 10,871 15,334 15,334 15,284 15,284 15,284 15,284 Sub -To tal, All Gene ral Government 1,054,660 1,039,223 1,039,223 1,087,171 1,087,171 1,087,171 1,087,171 Total Estimated Re ceipts 6,905,724 6,956,482 6,956,482 7,052,535 7,052,535 7,052,535 7,052,535 FY2014 FY2015 FY2018 FY2016 FY2017 FY2018 FY2019 STATE ASSESSM ENTS Actual Ac tual Level Gov. Projected Pr ojected Projected Mosquito Control 69,982 70,946 70,946 68,273 68,273 68,273 68,273 Air Pollution 5,573 5,625 5,625 5,917 5,917 5,917 5,917 M etropo litan Area Planning Council 4,819 7,739 7,739 7,876 7,876 7,876 7,876 RMV Non Renewal 11,280 11,080 11,080 11,080 11,080 11,080 11,080 MBTA 88,267 90,372 90,372 93,303 93,303 93,303 93,303 Regional Transit 9,510 10,575 10,575 11,057 11,057 11,057 11,057 Special Education 8,269 School Choice Sending Tuition 87,662 103,882 103,882 69,483 69,483 69,483 69,483 Charter School Sending Tuition 278,591 267,477 267,477 309,987 309,987 309,987 309,987 Tota l 563,953 567,696 567,696 576,976 576,976 576,976 576,976 FY2016 FY2016 Level Gov. Variance - Aid - 96,053 Variance - Assmts (9,280) Variance - Ne t - 86,773 Ne t Total 6,388,786 6,475,559 20 of 24 4/21/2015 C:\Users\chowell\Desktop\Documents\FY16\Financial model\Financial Model FY16 v37 Town of Hopkinton Chapter90 xF? 2O 4 201,5 , a ..,_ 1 Hopkinton apportionment 457,043 476,711 639,604 639,459 649,108 993,407 662,271 State Total 150,000,000 155,000,000 200,000,000 200,000,000 200,000,000 300,000,000 200,000,000 21 of 24 4/21/2015 C:\Users\chowell\Desktop\Documents\FY16\Financial model\Financial Model FY16 v37 Town of Hopkinton Local Revenues Fiscal 2014 Fiscal 2014 Fiscal 2015 Fisc al 2016 Fiscal 2017 Fiscal 2018 Fiscal 2019 Fi scal 2020 Proj A ctual Proj Pr oj Pr oj Pr oj Proj Proj Motor Vehicle Excise 2,286,665.96 2,667,590.57 2,365,463.69 2,550,000.00 2,550,000 .00 2,550,000 .00 2,550,000.00 2,550,000 .00 Pen & Int on Taxes & Excises 91,400 .00 214,943.70 97,500.00 183,000.00 187,575.00 192,264 .38 197,070.98 201,997 .76 Payments in Lieu of Taxes 4,700.00 134,464.22 150,000.00 260,000.00 265,200 .00 270,504.00 275,914.08 281,432.36 Other Charges for Services 48,000 .00 Fees 131,600 .00 328,595.92 268,500 .00 268,500.00 268,500.00 268,500.00 268,500.00 268,500.00 O the r Departmental Revenue 23,350.00 11,812 .47 10,800 .00 10,800 .00 10,800.00 10,800 .00 10,800 .00 10,800.00 Licenses and Permits 297,000.00 111,790 .30 110,000.00 110,000.00 110,000 .00 110,000.00 110,000.00 110,000.00 Fines and Forfeits 123,000.00 6,460.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000 .00 7,000.00 Investment Income 40,000.00 27,666 .66 27,000 .00 27,000 .00 27,000.00 27,000.00 27,000 .00 27,000.00 Medicaid reimbursement - 19,049 .09 17,250.00 17,250 .00 17,250.00 17,250.00 17,250 .00 17,250.00 Misc. Recurring - 244,947 .67 155,000.00 155,000.00 155,000.00 155,000.00 155,000.00 155,000.00 Misc Non -recurring 89,542.00 17,010 .32 3,135,257 .96 3,784,330.92 3,208,513 .69 3,588,550.00 3,598,325 .00 3,608,318.38 3,618,535 .06 3,628,980 .12 22 of 24 4/21/2015 C:\Users\chowell\Desktop\Do cuments\FY16\Financial model\Financial Model FY16 v37 Town of Hopkinton Other Available Funds Appropriation Transfers Premiums on Bonds O ve rlay Surplus Title V (1) Title V (2) Title V (3) Title V (4) Perpetual Care to DPW for Cemeteries TBD Ambulance Receipts Reserved for Amb Debt Sealer Rece ipts Total Other Available Funds PROJ FISCAL 2015 82, 244 .14 36,695 .21 128,000.00 9,998 .00 9,243.00 10,000 .00 10,000.00 10,000.00 500.00 296,680.35 PROJ FISCAL 2016 26, 769.48 9,820.00 9,243 .00 10,000 .00 10,000 .00 10, 000 .00 500.00 76,332 .48 PROJ FISCAL 2017 21,225.25 100,000 .00 9,820 .00 9,243 .00 10, 000 .00 10, 000.00 10,000 .00 500 .00 170,788.25 PROJ FISC AL 2018 16,746 .22 100,000.00 9,820.00 9,243 .00 10,000.00 10,000 .00 10, 000.00 500 .00 166,309 .22 PROJ FISCAL 2019 12,368 .41 100,000.00 9,820.00 9,243 .00 10,000.00 10,000.00 10,000.00 500.00 161,931.41 23 of 24 4/21/2015 C:\Users\chowell\Deskto p\Documents\FY16\Financial model\Financial Model FY16 v37 Track Changes BOS Recommendations to Updated Model 4/15/15 FY2016 Budget & Levy I Tab 1 Budget 2 Budget 3 Budget 4 Budget 5 Capital Pay-as-you-go 6 Capital Pay-as-you-go 7 Summary 8 Summary 9 Summary 10 State Aid & Assessment 11 State Aid & Assessment 12 State Aid & Assessment 13 Local Revenue s 14 Local Revenues 15 Available Funds 4121/15 16 Capital Debt 17 Capital Debt 18 Strategic Initiatives 19 Budget 20 Summary 21 Budget 22 Summary m pacts Item Keefe Tech Lake Maspenock Weed Control Hydrant r ental Elmwo od Farm Parking Area Elmwood Farm Parking Area Dispatch equipment Transfer to OPEB Trust Overlay Snow & Ice Supplement s State Aid s State Assessments s Cherry Sheet Offsets Motor Vehicle Excise New Growth Bond Premiums Grove Street Water Tank - Princip al Elementary Scho ol - Principal Water employee full year Lake Maspenock Weed Control P&R Enterprise subsidy Enterprise indirect costs Appropriatio ns from Free Cash BOS Update Variance (571,859.40) (386,087 .00) 185,772 .40 (60,000 .00) 60,000 .00 (270,000 .00) (296,422.00) (26,422 .00) (40,000 .00) 40,000 .00 - (40,000.00) (40,000 .00) (81,500.00) (16,250.00) 65,250.00 (460,253 .00) (411,118 .00) 49,135.00 (450,000.00) (500,000.00) (50,000 .00) (750,000.00) (854,565 .38) (104,565.38) 6,956,482 .00 7,052,535 .00 96,053.00 (567,696 .00) (576,975.75) (9,279 .75) (27,951.00) (15,284 .00) 12,667 .00 2,667,000.00 2,550,000 .00 (117,000 .00) 1,350,000.00 1,260,000.00 (90,000.00) 25,712.96 26,769 .48 1,056 .52 Subtotal 72,666.79 (50,000) (75,000) (19,800,000) (27,000,000) (27,500) (55,000) (20,000) (120,000) (268,022) 611,736 638,449 1,502,352 1,427,967 Subt otal Total 20,000 .00 (148,022.00) 26, 713.21 (74,385.00) (175, 693.79) (103,027.00) 24 of 24 4/21/2015 C:\Users\chowell\Desktop\Documents\FY16\Financial model\Financial Model FY16 v37 T OWN OF H OPKINTON STATEMENT OF REVENUES AND EXPENDITURES P ARKS & RECRE ATION ENTERPRISE FUND FY2012 - FY2015 (t o -date) Fiscal Year 2015 Fiscal Year 2014 Fiscal Year 2013 Fiscal Year 2012 Budget Actual Budget Actual Budg et Act ual Budget Actual Revenues: User charges 388,999 447,610 389,184 308,420 477,324 333,000 323,076 Other revenue 11,000 460 11,480 17,087 63,260 Investment income - - 500 - 500 Expenditures: Salaries Expenses Capital Other Total Revenues 399,999 - 447,610 389,644 320,400 494,411 333,000 386,836 187,663 387,800 43,650 Total Expenditures 619,113 Excess (deficiency) of revenue s over (under) expenditures (219,114) 179,210 125,490 95,603 87,126 91,355 89,628 355,800 393,321 326,539 309,310 391,313 307,323 46,760 46,760 581,770 565,571 422,142 396,436 482,668 396,951 (134,160) (175,927) (101,742) 97,975 (149,668) (10,115) Other fin ancing sources: Operating transfers in 120,000 120,000 120,000 129,362 143,762 180,604 149,668 Operating transfers (out) (27,620) (27,620) (27,620) (27,620) (27,620) (30,936) (30,936) To ta l Other Financing Sources: 92,380 92,380 92,380 101,742 116,142 149,668 118,732 Excess (deficiency) of revenues and othe r financing sources over (under) expenditures and other financing uses (126,734) (41,780) (83,547) 214,117 108,617 Other budget items: Retained Earnings To ta l Other Budget Items 126,734 41,780 126,734 41,780 Net Budget 0 Net position, beginning of year 330,344 116,227 7,610 Net position, end of year $ $ 246,797 $ 330,344 $ 116,227 1 4ffc dire * 3 Pam Waxlax - From: Chris Howell [chowell@hopkintonma.gov] 3ent Thursday, April 16, 2015 9:36 AM To: Michael Manning; Pam Waxlax; Patrick Mahon; Shahidul Mannan; Wayne Pacheco; John Westerling Subject: Fwd: Water Enterprise Additional Appropriation for FY15 FYI, regarding article 3. Forwarded message From: John Westerling <1westerling(t hopkintonma.gov> Date: Fri, Apr 10, 2015 at 3:03 PM Subject: Water Enterprise Additional Appropriation for FY15 To: Chris Howell <chowell @hopkintonma. zov> Cc: Mark Abrahams <bettergov0aol.com>, Eric Carty <ericc� chopkintonma.gov> Chris: Please share the following information with the Appropriations Committee regarding the need for an additional appropriation for the Water Department's FY15 budget. The Water Enterprise Fund will need an additional $80,000 appropriation for its FY15 budget to cover its operating expenses through the end of the fiscal year. This is due to the fact that the Water Enterprise Fund was faced with funding the following unexpected expenditures this fiscal year: • $12,000 Water Connection Fee Study • $6,000 MUNIS billing transition support • $9,000 Peer review of water master plan • $27,000 Water Audit • $11,000 Lorrigan Road water main replacement • $13,000 Hydrant snow removal and frozen water pipes • $20,000 Legacy Farms new water meters • 86,000 Town Council services for MEWS and other projects Please contact me with any questions. Sincerely, John K. Westerling Director of Public Works Town of Hopkinton Department of Public Works 66 Fruit Street PO Box 209 Hopkinton, MA 01748 .mail: jwesterling@>hopkintonma.gov Phone: 508-497-9740 Fax: 508-497-976i i mfacivitoi, Vote Needed: Simple Majority ARTICLE9: FY 2016 Revolving Funds Sponsor: Town Manager To see if the Town will vote to authorize or re -authorize the use of revolving funds containing receipts from the fees charged to users of the services provided by the various Boards, Committees, Departments or Offices of the Town, pursuant to Chapter 44, Section 53E 1/2, of the Massachusetts General Laws. Pass any vote or take any act relative thereto. Required Recommendations: Board of Selectmen recommends Appropriation Committee recommends Motion (Appropriation Committee): We move that the Town vote, pursuant to Chapter 44, Section 53E % of the General Laws, to re -authorize existing revolving funds for the fiscal year beginning July 1, 2016, as set forth under the motion for Article 9 in the Warrant Articles and Motions Document Re -Authorized Funds: Fund Revenue Source Authority to Spend Fund Use of Fund Spending Limit Disposition of Year -End Fund Balance Building Department Permit fees Director of Municipal Inspections with approval of the Town Manager Expenses of operations of department, acquisition and maintenance of vehicles, and salaries of part-time building inspectors $270,000 Unencumbered balance shall be retained in such fund Part-time Wire Inspector Permit fees and inspection fees of Wire Inspector Director of Municipal Ins pections with approval of the Town Manager Expenses of operation of department and salaries of part-time wire inspectors $100,000 Unencumbered balance shall be retained in such fund Part-time Plumbing Inspector Permit fees and inspection fees of Plumbing Inspector Director of Municipal Inspections with approval of the Town Manager Expenses of operation of department and salaries of Part-time plumbing inspectors $100,000 Unencumbered balance shall be retained in such fund Hazardous Materials Fees and monies received from insurers and others relating to release or spills of hazardous materials fire Chief Purchase equipment and materials, training, contingency planning, site assessments, service at hazardous release incidents $5,000 Unencumbered balance reverts to general fund. Conservation Commission Filing and consultant fees referred to in Wetlands Protection Bylaw Conservation Commission To meet expenses and fees of consultants engaged by and other appropriate expenses of Conservation Commission $115,000 Unencumbered balance reverts to general fund Board of Selectmen Chairman Todd k Cestari Initial Warrant May 4, 2015 Page 9 Library Lost Materials/Fines Library Director Replacement of lost and damaged materials $9,000 Unencumbered balance reverts to general fund • Emergency Medical Services Emergency Medical Services user fees Fire Chief and Police Chief To operate, maintain service, acquire and upgrade vehicles, equipment and training for emergency medical services 5470,000 Unencumbered balance reverts to Ambulance Receipts Reserved for Appropriation Public Safety Permit fees and other collected sums pursuant to the administration and enforcement of the Town of Hopkinton by Law Ch. 150 — Peddling and Soliciting Police Chief To meet the expenses of the Police Department related to the administration and enforcement of the Town of Hopkinton Bylaw Chapter 150 - Peddling and Soliciting $5,000 Unencumbered balance reverts to i general fund . Planning Board Permit fees and consultant fees collected by the Planning Board relating to review of Site Plans, petitions, applications, permits and appeals Planning Board To meet expenses and fees of consultants engaged by and other appropriate expenses of the Planning Board $30,000 Unencumbered balance reverts to general fund Open Space Preservation Commission User fees, charges and donations collected by the Open Space Preservation Commission in the conduct of its programs and activities Open Space Preservation Commission To meet expenses of the publication, reprinting and sale of the trail guide and the maintenance of trails and signage. $10,000 Unencumbered balance reverts to general fund Youth Commission User fees, charges and donations received by the Youth Commission in the conduct of its programs and activities Youth Commission To meet expenses incurred in conducting programs and activities for the Town's young people. $4,000 Unencumbered balance reverts to general fund Zoning Board of Appeals Filing fees and consultant fees collected by the Zoning Board relating to review of appeals, petitions and applications Zoning Board of Appeals To meet expenses and fees of consultants engaged by and other appropriate expenses of the Zoning Board of Appeals $50,000 Unencumbered balance reverts to general fund Department of Public Works — Highway Division Road Opening, Driveway Opening, and Trench Permit fees Director of the Department of Public Works Expenses of operation of the Highway Division $8,000 Unencumbered balance reverts to general fund Department of Public Works — User fees collected at the Recycling Center Director of the Department of Public Works Expenses of operation of Recycling Center $15,000 Unencumbered balance reverts to general fund Board of Selectmen Chairman Todd A. Cestari Initial Warrant May 4, 2015 Page 10 Recycling Committee Department of Public Works Fees collected from Overflow Trash Bags Director of the Department of Public Works To purchase Overflow Trash Bags and to meet expenses of Waste Collection and Disposal $8,000 Unencumbered balance reverts to fund Cemete ry Commission User fees and charges collected for the use of the Comey Chapel Cemetery Commission Maintenance and operation of the Comey Chapel $3,500 general Unencumbered balance reverts to general fund School Department 1:1 to to P p Initiative Receipts collected from students and families for leasing computers School Committee Payments for leasing computers $470,000 Unencumbered balance shall be retained in such fund Fingerprinting Fund fingerprinting fees collected from prospective ice cream truck operators Police Chief Defray costs associated with $500 Unencumbered Unencumbered balance revertr[o general fund Femet Lot erY Fund Re -sale of lots -purchased by Cemetery Cemetery Commission Purchase of lots previously sold - -$10,000 Unencumbered balance shall be _ retained in such fund Vote Needed: Simple Majority ARTICLE 10: Chapter 90 Highway Funds Sponsor: Town Manager To see if the Town will vote to appropriate a sum or sums of money from the proceeds due to the Town pursuant to Chapter 90 of the Massachusetts General Lows, for the purposes of repair, construction, maintenance and preservation of the Town's roads and bridges and other related costs, which qualify under the State Aid Highway Guidelines adopted by the Massachusetts Department of Transportation; said sum to be spent under the direction of the Town Manager. Pass any vote or take any act relative thereto. Required Recommendations: Appropriation Committee recommends Capital Improvement Committee recommends Motion (Appropriation Committee): We move that the Town vote to appropriate $662,271 (SIX HUNDRED SIXTY-TWO THOUSAND, TWO HUNDRED SEVENTY-ONE DOLLARS) from the proceeds due to the Town pursuant to Chapter 90 of the Massachusetts General Laws for the fiscal year beginning July 1, 2015, for the purposes of repair, construction, maintenance, and preservation of the Town's roods and bridges and other related costs that qualify under the State Aid Highway Guidelines adopted by the Massachusetts Department of Transportation; said sum to be spent under the direction of the Town Manager. Vote Needed: Simple Majority Board of Selectmen Chairman Todd A. Cestari initial Warrant May 4, 2015 Page 11 Commented [CH5R4]: Need to check with Claire Wright 'Commented IER4l: This fund was created last year. I assumed that it would be reauthorized on the same terms.