Loading...
Section XII - Enterprise Funds - Wannacomet WaterFY2018 BUDGET PROJECTION •ENTERPRISE FUNDS •WANNACOMET WATER Town and County of Nantucket 16 Broad Street Nantucket, MA 02554 1 FY2018BudgetFY2018 BudgetWannacomet Enterprise Fund 2 FY2017Wannacomet Enterprise Fund Review•Mission: Wannacomet Water Company shall strive to provide high quality drinking water, provide the highest level of customer and water related support services achievable and educate and inform the public of the need to protect Nantucket's water resources and accomplish this mission by using prudent utility practices and responsible fiscal management.Gl•Goals:Renew the 21 year Water Management Act Permit with realistic objectives for managing our drinking water resourcesComplete and bring on‐line the replacement wells for the Wyer’s Valley Water SupplyDl10YCilIPlDevelop a 10 Year Capital Improvement PlanComplete Phase II of the Fire Hydrant Modernization ProgramSecure an in‐house certified procurement officerComplete the consolidation of the Siasconset Water Department and the Wannacomet Water Co.•Initiatives and Accomplishments:Installation of the new wells at Wyer’s Valley and related controls and pipingCompleted 10 year Capital Improvement PlanSucceeded in getting MassDEP to consider the uniqueness of Nantucket’s aquifer and economic conditions when finalizing the Water Management Act Permit (meeting will be held in January of 2017)WANNACOMET WATER ENTERPRISE3 FY2018Wannacomet Enterprise Fund Overview •Priorities:Priorities:Complete a Water Audit of the system addressing administration, operations and water supply components (Water Management Act requirement)Conduct a system‐wide leak survey (Water Management Act requirement)Conductanevaluationofcurrentratestructureandalternativeratestructures(WaterManagementActConduct an evaluation of current rate structure and alternative rate structures (Water Management Act requirement)Initiate and complete Final Phase of Fire Hydrant ProgramDevelop and implement consolidated budget and financial reporting for the consolidated Wannacomet Water CompanypyComplete the New Administration Building•Significant Changes Year‐to‐Year (FY2017 to FY2018)Increase in operations staffing –1 additional UtilitymanWaterratesremainatcurrentlevelforFY2018Water rates remain at current level for FY2018•Key IssuesImpact of conditions of the final provisions of the Water Management Act PermitRegulatory requirements caused by revisions of the Major Drinking Water RulesChitti tfthGlMChange in management upon retirement of the General ManagerWANNACOMET WATER ENTERPRISE4 FY2018 BudgetWannacomet Enterprise FundSUMMARY3-YEAR ACTUALFY2014 ACTUAL FY2015 ACTUAL FY2016 ACTUAL FY2017 ACTUALYTD SIMPLEAVERAGE COMPOUND ANNUAL GROWTH RATE FY2017 BUDGET FY2018 BUDGET $ INC/(DEC) FY18/FY17 % INC/(DEC) FY18/FY17 Pa roll Salar1 208 101$ 1 079 925$ 1 034 744$ 536 864$ 1 107 590$ (75%) 1 137 990$ 1 241 091$ 103 101$ 91% Payroll-Salary1,208,101$ 1,079,925$ 1,034,744$ 536,864$ 1,107,590$ (7.5%) 1,137,990$ 1,241,091$ 103,101$ 9.1% Medicare P/R Tax Expenses 1,810 15,376 14,741 7,662 10,643 185.4% 16,100 17,900 1,800 11.2% Medical Insurance 36,981 184,636 210,317 109,380 143,978 138.5% 280,450 304,288 23,838 8.5% Barnstable County Retirement 182,158 204,649 210,008 208,499 198,939 7.4% 219,466 238,121 18,655 8.5% Utilities 46,413 160,802 185,099 105,268 130,772 99.7% 198,400 199,900 1,500 0.8% Repairs & Maintenance 234,917 188,096 227,845 89,680 216,953 (1.5%) 309,500 367,000 57,500 18.6% Professional Services 82,164 60,143 60,522 29,040 67,610 (14.2%) 67,500 187,500 120,000 177.8% Debt Service810 2,310,123 2,247,187 1,192,959 1,519,373 5,167.3% 2,592,953 2,316,010 (276,943) (10.7%) General Insurance7,982 80,550 82,816 - 57,116 222.1% 89,000 89,000 - - Other Supplies113,959 18,286 20,508 10,719 50,918 (57.6%) 21,500 29,500 8,000 37.2% Inventory1,612 132,269 251,952 67,518 128,611 1,150.2% 150,000 200,000 50,000 33.3% Travel29,396 42,994 29,239 27,104 33,876 (0.3%) 47,500 50,000 2,500 5.3% Water Analysis4,311 16,749 21,993 4,829 14,351 125.9% 23,000 23,000 - - Other1 731 720 227 963 237 991 53 535 732 558 (629%) 381 897 540 780 158 883 41 6% Other1,731,720 227,963 237,991 53,535 732,558 (62.9%) 381,897 540,780 158,883 41.6% TOTAL WANNACOMET 3,682,335$ 4,722,561$ 4,834,962$ 2,443,057$ 4,413,286$ 14.6% 5,535,256$ 5,804,090$ 268,834$ 4.9% WANNACOMET WATER ENTERPRISE5 AppendixAppendixWannacomet Enterprise Fund6 Town & County of Nantucket Town & County of Nantucket Organization Chart Organization Chart –– Wannacomet Enterprise FundWannacomet Enterprise FundNoreen SlavitzNantucket Water CommissionAllen ReinhardNantucket Water CommissionNelson K. EldridgeNantucket Water CommissionRobert L. GardnerGeneral ManagerChristopher R. PykoszOperations ManagerHeidi HoldgateBusiness ManagerMark WillettEngineering ManagerRob WestEngineering TechnicianDenese AllenAssBusinessManagerMeter TechnicianRequested (7/1/17)Jeffrey JohnsenUtility manRobert EarleUtility manAss. Business ManagerLinda RobertsProject CoordinatorKyle RobertsUtility manAndrea MansfieldAdmin. AssistantVACANTUtility manWANNACOMET WATER ENTERPRISE7 FY2018BudgetDetailFY2018 Budget DetailWANNACOMET WATER ENTERPRISE8 FY2018Wannacomet Fund Exceptions PositionsOperational Expenses (1)1. Meter Technician: $70,200 1. Repair & Maintenance (mains): $22,0002. Repair & Maintenance (services): $26,0003. Repair & Maintenance (pump structure): $62,500Capital Items4. Professional Services: $120,0001. Hydrant replacement: $175,000 5. Inventory: $50,0002. Water main replacement: $2,420,6356. Unallocated Expenses: $154,583(1) Non‐controllable expenses such as general insurance, medical insurance, pension costs and utilities are excluded.WANNACOMET WATER ENTERPRISE9 TOWN OF NANTUCKETWANNACOMET WATER - ENTERPRISE FUNDACTUALBUDGETPROJECTED BUDGETFY2016FY2017FY2018Revenue5,764,646 5,535,256 5,804,090 Expenses4,834,962 5,535,256 5,804,090 Net Earnings929,684 - - Transfer from Retained Earnings- - - Net Earnings after R/E Transfer929,684 - - Ending FB929,684 - - TOTALCertified Retained Earnings as of July 1, 2016 2,639,663 10 WANNACOMET WATER ENTERPRISE FUNDOPERATIONS BUDGETFY2018 BUDGET PROJECTION3-YEAR ACTUALDEPT ACCOUNT ACCOUNT NAME FY2014 ACTUAL FY2015 ACTUAL FY2016 ACTUAL FY2017 ACTUAL YTD SIMPLEAVERAGE COMPOUND ANNUAL GROWTH RATE FY2017 BUDGET FY2018 BUDGET $ INC/(DEC) FY18/FY17 % INC/(DEC) FY18/FY17 63455 42110 WATER USE FEE (3,964,934)$ (4,353,145)$ (4,789,250)$ (3,545,529)$ (4,369,110)$ 9.9% (4,823,406)$ (4,914,340)$ (90,934)$ 1.9% 63455 42111 WATER CONNECTION FEE (521,946) (442,559) (628,051) (277,874) (530,852) 9.7% (375,000) (575,000) (200,000) 53.3% 63455 42115 CROSS CONNECTION DEVICE TEST FEE- - (10,600) (13,800) (3,533) na(55,000) (30,900) 24,100 (43.8%) 63455 42441 LATE PAYMENT SERVICE FEE(60,155) (31,849) (38,453) (26,175) (43,486) (20.0%) (34,800) (34,800) - - 63455 43606 RENTAL INCOME (18,650) (18,600) (18,600) (6,300) (18,617) (0.1%) (18,650) (18,650) - - 63455 48201 INTEREST ON INVESTMENTS (10,273) (4,686) (7,354) (8,437) (7,438) (15.4%) (4,700) (4,700) - - 63455 48400 CONTRACT SERVICES - SEWER (112,124) (115,198) (128,688) (28,376) (118,670) 7.1% (105,000) (105,000) - - 63455 48401 REVENUE - OUTSIDE BILLING (4,800) (6,498) (4,200) (1,050) (5,166) (6.5%) (4,800) (4,800) - - 63455 48416 CONTRACT SERVICES - SIAS WATER (52,500) (60,000) (65,000) (20,000) (59,167) 11.3% (88,000) (88,000) - - 63455 48417 TRANSFER FEE (29,632) (32,016) (26,645) (15,129) (29,431) (5.2%) (24,000) (26,000) (2,000) 8.3% 63455 49102 PROCEEDS FROM BOND SALE- - - - - na- - - na63455 49104 PREMIUM REVENUE ON DEBT (0) (1,889) (47,805) - (16,565) 39,818.6% (1,900) (1,900) - - 63455 49701 TRANSFER FROM GENERAL FUND- - - - - na- - - na63455 51100 SALARY - OUTSIDE BILLING (1,777) 29,834 27,320 36,806 18,459 na1,072,490 1,180,420 107,930 10.1% 63455 51101 SALARY - ADMIN/GENERAL 30,084 261,307 270,007 124,975 187,133 199.6% - - - na63455 51102 SALARY - OPS/ENG 241,823 281,114 288,995 138,199 270,644 9.3% - - - na63455 51103 SALARY - PUMPING LABOR - - - - - na- - - na63455 51105 SALARY - SOURCE OF SUPPLY - - - - - na- - - na63455 51106 SALARY - DISTRIBUTION 274,178 215,459 154,966 73,550 214,868 (24.8%) - - - na63455 51107 SALARY - MISC METER LABOR 217,674 69,215 74,501 36,205 120,464 (41.5%) - - - na63455 51108 SALARY - METER READ LABOR - - - - - na- - - na63455 51117 SALARY - BILL & ACCT WATE 66,525 146,797 151,189 74,179 121,504 50.8% - - - na63455 51118 SALARY - BILL & ACCT SEWE - - - - - na- - - na63455 51119 SALARY-A & G SCONSET WATER - - - - - na- - - na63455 51200 SALARY, TEMPORARY 141,661 - - - 47,220 (100.0%) 2,500 2,500 - - 63455 51300 OVERTIME - 14,385 11,072 4,090 8,486 na3,000 3,000 - - ,,,,,,63455 51700 LONGEVITY PAY 9,911 42,569 38,595 40,403 30,358 97.3% 32,100 33,400 1,300 4.0% 63455 51701 INS PREM:MEDICAL BLUE CROSS 36,981 184,636 210,317 109,380 143,978 138.5% 280,450 304,288 23,838 8.5% 63455 51705 MEDICARE/MEDEX/RETIREES - - - - - na- - - na63455 51770 BARNSTABLE COUNTY RETIREMT FND 182,158 204,649 210,008 208,499 198,939 7.4% 219,466 238,121 18,655 8.5% 63455 51960 COMPENSATION/UNEMPLOYMENT 196,296 1,471 - - 65,922 (100.0%) 8,400 2,271 (6,129) (73.0%) 63455 51961 MEDICARE P/R TAX 1,810 15,376 14,741 7,662 10,643 185.4% 16,100 17,900 1,800 11.2% 63455 51962 DEF COMP EMPLOYER CONTRIBUTION 14,773 17,773 18,099 8,456 16,882 10.7% 18,500 18,500 - - 63455 51963 WORKMANS COMPENSATION 16,951 - - - 5,650 (100.0%) 1,000 1,000 - - 63455 52101 UTILITY:ELECTRICITY 1,402 9,758 9,464 5,245 6,875 159.8% 12,000 12,000 - - 63455 52103 UTILITY:FUEL OIL - 7,017 3,868 1,792 3,628 na8,500 8,000 (500) (5.9%) 63455 52104 ELECTRICITY - PUMPING 8,787 119,791 149,642 91,469 92,740 312.7% 145,000 150,000 5,000 3.4% 63455 52107 UTILITY: LANDFILL9,476 - 383 - 3,286 (79.9%) 400 400 - - 63455 52401 REP&MAINT:OFFICE EQUIP 99,621 48,397 44,181 35,079 64,066 (33.4%) 75,000 75,000 - - 63455 52403 REP&MAINT:VEHICLE 364 11,795 4,833 2,426 5,664 264.4% 5,000 5,000 - - 63455 52404 REP&MAINT:BUILDING 45,079 6,495 15,557 3,746 22,377 (41.3%) 88,500 58,500 (30,000) (33.9%) 63455 52405 REP&MAINT:EQUIPMENT 5,068 1,759 518 269 2,448 (68.0%) 2,000 1,500 (500) (25.0%) 63455 52411 REP&MAINT:GROUNDS 10,439 46,697 25,571 8,664 27,569 56.5% 35,000 30,000 (5,000) (14.3%) 63455 52412 REP & MAINT - PUMPING EQP 736 5,599 7,051 2,422 4,462 209.4% 8,000 8,000 - - 63455 52413 REP & MAINT - MAINS 31,967 11,458 6,404 384 16,610 (55.2%) 10,000 32,000 22,000 220.0% 63455 52414 REP & MAINT - HYDRANTS 6,599 6,805 66 1,494 4,490 (90.0%) 5,000 5,000 - - 63455 52415 REPAIR & MAINT - SERVICES 8,375 47,944 123,341 35,140 59,886 283.8% 10,000 36,000 26,000 260.0% 63455 52416 REP & MAINT - METER INSTA 143 208 155 - 168 4.2% 5,000 3,000 (2,000) (40.0%) 63455 52417 REPAIR & MAINT PUMP STRUCTURE 5,817 261 169 56 2,082 (82.9%) 2,500 65,000 62,500 2,500.0% 63455 52418 REPAIR & MAINT-STANDPIPE 6,243 - - - 2,081 (100.0%) 60,000 45,000 (15,000) (25.0%) 63455 52419 MAINTENANCE TO METERS 41 25 - - 22 (100.0%) 2,000 2,000 - - 63455 52423 REPAIR & MAINTENANCE SCADA 14,425 654 - - 5,026 (100.0%) 1,500 1,000 (500) (33.3%) 63455 52703 RENT / LSE: POSTAGE METER10,937 1,526 1,526 763 4,663 (62.6%) 1,600 1,600 - - 63455 52907 LANDFILL & WASTE WATR FEE 1,145 - 2,300 192 1,148 41.8% 2,500 2,500 - - 63455 52908 PROPERTY:EQUIP RENTAL - - - - - na- - - na63455 53100 PROFESSIONAL SERVICES 379 20,925 30,938 14,603 17,414 803.8% 25,000 145,000 120,000 480.0% 63455 53101 GENERAL:ACCOUNTNG & AUDIT - 13,500 11,000 7,500 8,167 na21,500 21,500 - - 11 WANNACOMET WATER ENTERPRISE FUNDOPERATIONS BUDGETFY2018 BUDGET PROJECTION3-YEAR ACTUALDEPT ACCOUNT ACCOUNT NAME FY2014 ACTUAL FY2015 ACTUAL FY2016 ACTUAL FY2017 ACTUAL YTD SIMPLEAVERAGE COMPOUND ANNUAL GROWTH RATE FY2017 BUDGET FY2018 BUDGET $ INC/(DEC) FY18/FY17 % INC/(DEC) FY18/FY17 63455 53102 GENERAL:LEGAL SERVICES 73,836 5,579 4,500 1,227 27,972 (75.3%) 6,000 6,000 - - 63455 53103 GENERAL:ADVERTISING 15,200 3,685 5,698 3,286 8,194 (38.8%) 5,000 5,000 - - 63455 53105 GENERAL: EXP. PUBLIC INFO 8,807 2,506 3,234 4,280 4,849 (39.4%) 6,000 10,000 4,000 66.7% 63455 53106 GENERAL:CUSTODIAL 3,506 9,573 9,164 2,646 7,414 61.7% 10,500 10,500 - - 63455 53107 PROF SVCS - WATER ANALYSI 4,311 16,749 21,993 4,829 14,351 125.9% 23,000 23,000 - - 63455 53108 OUTSOURCE BILLING 7,950 20,139 14,084 5,711 14,058 33.1% 15,000 15,000 - - 63455 53110 GENERAL:PRINTING 21,069 1,862 2,594 113 8,508 (64.9%) 2,500 2,500 - - 63455 53401 COMM:TELEPHONE 20,458 8,315 8,939 3,590 12,570 (33.9%) 12,000 12,000 - - 63455 53402 COMM:POSTAGE 2,401 30,159 26,650 13,640 19,737 233.1% 30,000 30,000 - - 63455 53803 OTHER:LICENSES & TAXES 7,668 5,375 5,472 5,158 6,172 (15.5%) 6,000 6,000 - - 63455 53804 OTHER:FREIGHT 27,595 1,477 1,241 1,016 10,104 (78.8%) 2,000 2,000 - - 63455 54101 ENERGY:GAS & DIESEL 5,146 15,922 10,504 2,980 10,524 42.9% 18,000 15,000 (3,000) (16.7%) 63455 54201 OFFICE SUPPLIES 1,975 6,556 5,594 3,726 4,708 68.3% 5,000 5,000 - - 63455 54301 TOOLS & EQUIPMENT 18,964 1,921 5,318 1,375 8,735 (47.0%) 2,000 2,000 - - 63455 54302 MISC MATERIALS & SUPPLIES 4,914 2,299 2,245 1,472 3,153 (32.4%) 2,500 2,500 - - 63455 54303 INVENTORY 1,612 132,269 251,952 67,518 128,611 1,150.2% 150,000 200,000 50,000 33.3% 63455 54306 PUMP MATERIALS AND SUPPLIES 5,128 - 473 1,367 1,867 (69.6%) - - - na63455 54308 ENGINEERING:SUPPLIES & MATERIA 82,978 7,510 6,877 2,779 32,455 (71.2%) 12,000 20,000 8,000 66.7% 63455 54501 CUSTODIAL:CLEANING SUPPLY - - - - - na- - - na63455 54701 SAFETY:UNIFORMS - 2,885 2,220 1,188 1,702 na2,500 2,800 300 12.0% 63455 54702 SAFETY:MATERIALS - - - - - na- - - na63455 55101 BOOKS/SUBSCRIPTIONS 8,325 748 683 298 3,252 (71.4%) 1,200 1,200 - - 63455 57101 IN-STATE:MISC TRAVEL 3,889 27,229 21,391 24,601 17,503 134.5% 35,000 35,000 - - 63455 57102 IN-STATE:MILEAGE/CAR ALLW - 292 351 83 214 na- - - na63455 57103 IN-STATE:SEMINARS,PROF GA 1,128 - 1,910 875 1,013 30.1% 2,500 5,000 2,500 100.0% 63455 57201 OUT-STATE:GENERAL 24,379 15,473 5,587 1,545 15,146 (52.1%) 10,000 10,000 - - ,,,,,(),,63455 57301 DUES:PROFESSNL ORGANIZATN 259 2,397 3,495 2,109 2,050 267.5% 2,500 2,500 - - 63455 57401 INS PREM:AUTO & LIABILITY 2,170 21,065 20,685 - 14,640 208.7% 24,000 24,000 - - 63455 57404 INS PREM:BLANKET INS,BLDG 5,812 58,019 62,131 - 41,988 227.0% 65,000 65,000 - - 63455 57406 INS PREM:CLAIM DEDUCTIBLE - 1,466 - - 489 na- - - na63455 57802 OTHER:SCHOOLS MISC - - - - - na- - - na63455 58501ADD EQ:NEW EQUIP 2,471 10,901 4,039 1,431 5,804 27.9% 80,000 80,000 - - 63455 58502ADD EQ:OFFICE FURNITURE 19,457 - 351 1,125 6,603 (86.6%) 2,000 2,000 - - 63455 58701 REPLACEMENT EQ:GENERAL 57,445 3,891 - 1,482 20,445 (100.0%) 3,000 3,000 - - 63455 58702 UNALLOCATED EXPENSES - - 78,624 15,000 26,208 na126,097 280,680 154,583 122.6% 63455 58904 CAP PROJ:PURCHASES - - - - - na- - - na63455 59101 DEBT SERV:PRINCIPAL 810 1,560,000 1,598,000 875,800 1,052,937 4,341.8% 1,750,800 1,675,000 (75,800) (4.3%) 63455 59102 DEBT SERVICE INTEREST - 750,123 649,187 317,159 466,436 na842,153 641,010 (201,143) (23.9%) 63455 59103 ISSUE EXPENSE- - - - - na- - - na63455 59250 INTEREST: GENERAL1,580 7,978 - - 3,186 (100.0%) 8,000 8,000 - - 63455 59501 OTHER FIN:GENERAL - - - - - na- - - na63455 59991 TRANSFER TO GF (INDIRECT COSTS)1,545,000 143,000 93,000 - 593,667 (75.5%) 93,000 93,000 - - WANNACOMET WATER ENTERPRISE FUND GRAND TOTALTOTAL REVENUE(4,775,014)$ (5,066,439)$ (5,764,646)$ (3,942,670)$ (5,202,033)$ 9.9% (5,535,256)$ (5,804,090)$ (268,834)$ 4.9% TOTAL EXPENSE3,682,335$ 4,722,561$ 4,834,962$ 2,443,057$ 4,413,286$ 14.6% 5,535,256$ 5,804,090$ 268,834$ 4.9% VARIANCE(1,092,679)$ (343,878)$ (929,684)$ (1,499,613)$ (788,747)$ (7.8%) -$ -$ -$ naUSE OF RETAINED EARNINGS*BUDGET BALANCE12 FY2018 Personnel SpreadsheetNumber of Positions in DepartmentFull-time11Part-time0Seasonal0Temporary0Vacancies (unfunded)1New Positions Requested1TOTAL OF ALL POSITIONS13Name, PositionJob CodeAvg Hours Per WeekClass & Step as of 6/30/17(e.g., B -Step 3)Yearly Salaryas of 6/30/1753 Week AdjustmentFY2018 IncreaseDateProratedFY2018SalaryLongevityPayEducationPayCertificationPayHolidayPayOtherTotal byEmployeeGARDNER, R. - MANAGERWW0140.00 N/A152,351 152,761 07/01/16 156,600000 0 18,500 175,100PYKOSZ, C. - OPERATIONS MGRWW2340.00 N/A116,353 116,666 07/01/16 119,600 5,80000 0 0 125,400HOLDGATE, H. - BUSINESS MGRWW2440.00 N/A116,353 116,666 07/01/16 119,600 5,80000 0 0 125,400ROBERTS, L. - CUSTOMER SVC SUPV WW1540.00 N/A80,961 81,179 07/01/16 83,200 4,00000 0 0 87,200ALLEN, D. - ASST. BUSINESS MGRWW2440.00 N/A81,120 81,338 07/01/16 83,400000 0 0 83,400MANSFIELD, A. - ADMIN ASST.WW0740.00 N/A80,962 81,180 07/01/16 83,200 2,40000 0 0 85,600WILLETT, M. - ENGINEERWW3540.00 N/A108,234 108,525 07/01/16 111,200 4,30000 0 0 115,500WEST, R. - ENGINEERWW3540.00 N/A80,954 81,172 07/01/16 83,200 2,40000 0 0 85,600EARLE, R. - UTILITYMANWW6040.00 UT 172,842 73,038 07/01/16 74,900 2,90000 0 0 77,800JOHNSEN, J. - UTILITYMANWW6040.00 UT 172,842 73,038 07/01/16 74,900 3,60000 0 0 78,500ROBERTS, K. - UTILITYMANWW5040.00 UT 172,842 73,038 07/01/16 74,900 2,20000 0 0 77,100UTILITYMAN - UNFUNDED40.00 UT 100 000METER TECH - REQUESTING FUNDING40.00 NON-UNION70,720000 0 0 70,720TOTAL1,064,700 33,40000 0 18,500 1,116,600Total Prorated Salary (enter on Munis 51100)1,135,42025,00020,0002,5003,00033,4001,219,32017,7002,2711,00018,500304,288238,1211,801,200Total Compensation/Unemployment (enter on MUNIS 51960)Wannacomet Water Enterprise FundORG: 63455Total On-Call PayTotal MeritTotal Salary TemporaryOvertime (enter on Munis 51300)Total Longevity (enter on Munis 51700)Salary SubtotalMedicare (enter on Munis 51961)Total Worker's Compensation (enter on MUNIS 51963)Total Deferred Compensation (enter on Munis 51962)Total Insurance Premium: Medical Blue Cross (enter on Munis 51701)Total Barnstable County Retirement (enter on MUNIS 51770)Total Personnel Services 13 **************************Issue Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments PaymentsPurposeDate FY2017 FY2018 FY2019 FY2020 FY2021 FY2022 FY2023 FY2024 FY2025 FY2026 FY2027 FY2028 FY2029WANNACOMET WATER ENTERPRISEREHAB GARAGE & MAINTENANCE FACILITY2/15/2008 42,700           41,400           ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 SOURCE WELL & PUMP2/15/2008 69,388           67,275           ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 WATER STORAGE TANK (ORIG)2/15/2008 266,875        258,750        ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 WATER MAINS2/15/2008 69,388           67,275           ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 WATER SYSTEM DISTRIBUTION2/15/2008 53,375           51,750           ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 WATER MAINS 22/15/2008 5,338             5,175             ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 WATER STORAGE TANK (SUPP)3/15/2009 139,800        141,050        136,500        ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 SYSTEMS IMPROVEMENT / METER BATTERIES2/15/2010 176,775        166,175        160,775        70,375           68,875           66,875           65,375           63,375           61,750           59,750           57,750           56,000           54,000           CURRENT REFUNDING 05/20016/7/2012 60,750           58,250           55,750           53,500           51,250           ‐                 MADKET MAIN 16/7/2012 98,100           95,100           92,100           89,400           86,700           83,700           80,700           77,700           74,700           72,300           70,500           68,700           66,863           MADAKET MAIN 26/7/2012 65,400           63,400           61,400           59,600           57,800           55,800           53,800           51,800           49,800           48,200           47,000           45,800           44,575           WASHING POND TANK REHAB6/7/2012 115,175        110,425        105,675        101,400        92,250           ‐                 ADMINISTRATION BUILDING6/7/2012 98,100           95,100           92,100           89,400           86,700           83,700           80,700           77,700           74,700           72,300           70,500           68,700           66,863           METER UPGRADES6/7/2012 50,600           48,600           46,600           44,800           43,000           41,000           ADV REF 10/01/2004 (LAND)3/5/2013 192,110        185,623        178,240        174,888        166,870        163,765        159,355        152,250        147,175        ADV REF 10/01/2004 (WATER 2)3/5/2013 32,025           31,440           29,870           29,308           28,620           26,760           26,040           25,200           24,360           ADV REF 10/01/2004 (WATER 1)3/5/2013 32,025           31,440           29,870           29,308           28,620           26,760           26,040           25,200           24,360           ADV REF 11/15/2005 WATER 12/5/2015 205,738        184,860        196,810        183,710        220,310        195,860        205,535        209,835        208,910        199,955        ‐                 ‐                 ‐                 ADV REF 11/15/2005 WATER 32/5/2015 32,048           31,750           31,250           35,700           35,100           34,350           38,375           37,325           31,350           30,450           ‐                 ‐                 ADV REF 11/2005 GARAGE AND MAINT2/5/2015 63,162           57,010           61,060           60,060           64,010           62,635           60,985           59,335           62,610           57,855           ‐                 ‐                 ‐                 776 WATER DISTRIBUTION10/22/2015 72,928           60,150           58,950           57,750           56,750           55,950           54,950           53,750           52,550           51,350           50,200           49,100           48,000           785 WATER DISTRIBUTION10/22/2015 72,342           60,450           59,250           58,050           57,050           56,250           55,250           54,050           52,850           51,650           50,500           49,400           48,300           Refi WWCO Admin 08 750K July'168/3/2016 11,287           13,024           50,264           48,744           47,224           44,724           43,244           41,764           40,284           33,904           32,232           ‐                 ‐                 Refi WWCO Well 08 1.3M July '168/3/2016 20,185           23,290           84,050           81,570           79,090           76,610           74,130           70,670           68,230           65,790           62,370           59,085           ‐                 Refi WWCO Tank 08 5M July '168/3/2016 77,561           89,493           322,733        313,213        302,713        293,233        282,773        273,333        262,913        252,533        241,213        230,937        ‐                 Refi WWCO Main 08 1.25M July'168/3/2016 18,622           21,487           77,347           75,067           72,787           70,507           68,227           65,947           62,687           60,447           58,207           54,894           ‐                 Refi WWCO DistImp 08 1M Jul'16 8/3/2016 15,522           17,910           64,950           63,030           61,110           58,210           56,330           54,450           52,570           50,690           47,830           45,955            ‐                 Refi WWCO Mains2 08 100K Jul'168/3/2016 1,577             1,820             6,720             6,520             6,320             6,120             5,920             5,720             5,520             5,320             4,140             3,030             ‐                 Refi WWCO Tank 09 2.815M Jul'168/3/2016 53,074           56,556           56,556           186,896        186,476        185,856        185,036        188,916        186,516        189,836        186,876        189,318        185,840        WYERS VALLEY WELLS NOV '1611/9/2016‐                 179,983        148,800        146,100        143,400        140,250        135,750        131,250        126,750        122,250        117,750        109,225        106,675        TOTAL WANNACOMET DEBT2,211,968     2,316,011   2,207,620   2,058,388   2,043,025   1,828,915   1,758,515     1,719,570   1,670,585   1,424,580   1,097,068   1,030,143   621,115      14 PurposeWANNACOMET WATER ENTERPRISEREHAB GARAGE & MAINTENANCE FACILITYSOURCE WELL & PUMPWATER STORAGE TANK (ORIG)WATER MAINSWATER SYSTEM DISTRIBUTIONWATER MAINS 2WATER STORAGE TANK (SUPP)SYSTEMS IMPROVEMENT / METER BATTERIESCURRENT REFUNDING 05/2001MADKET MAIN 1MADAKET MAIN 2WASHING POND TANK REHABADMINISTRATION BUILDINGMETER UPGRADESADV REF 10/01/2004 (LAND)ADV REF 10/01/2004 (WATER 2)ADV REF 10/01/2004 (WATER 1)ADV REF 11/15/2005 WATER 1ADV REF 11/15/2005 WATER 3ADV REF 11/2005 GARAGE AND MAINT776 WATER DISTRIBUTION785 WATER DISTRIBUTIONRefi WWCO Admin 08 750K July'16Refi WWCO Well 08 1.3M July '16Refi WWCO Tank 08 5M July '16Refi WWCO Main 08 1.25M July'16Refi WWCO DistImp 08 1M Jul'16 Refi WWCO Mains2 08 100K Jul'16Refi WWCO Tank 09 2.815M Jul'16WYERS VALLEY WELLS NOV '16TOTAL WANNACOMET DEBT**********************Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments PaymentsFY2030 FY2031 FY2032 FY2033 FY2034 FY2035 FY2036 FY2037 FY2038 FY2039 FY204052,000           64,988           63,038           61,013           43,325           42,025           40,675           64,988           63,038           61,013           46,900           45,800           39,725           38,675           37,625           36,575           35,525           47,200           46,100           44,950           43,750           37,625           36,575           35,525           ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 ‐                 104,125        101,575        99,025           96,475           93,925           91,375           88,825           86,275           ‐                 ‐                 ‐                 423,525        361,575        346,400      178,900      169,175      164,525      159,875      86,275          ‐               ‐               ‐               15