Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Section XII - Enterprise Funds - Wannacomet Water
FY2018 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 resourcesComplete and bring on‐line the replacement wells for the Wyer’s Valley Water SupplyDl10YCilIPlDevelop a 10 Year Capital Improvement PlanComplete Phase II of the Fire Hydrant Modernization ProgramSecure an in‐house certified procurement officerComplete 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 pipingCompleted 10 year Capital Improvement PlanSucceeded 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(WaterManagementActConduct an evaluation of current rate structure and alternative rate structures (Water Management Act requirement)Initiate and complete Final Phase of Fire Hydrant ProgramDevelop and implement consolidated budget and financial reporting for the consolidated Wannacomet Water CompanypyComplete the New Administration Building•Significant Changes Year‐to‐Year (FY2017 to FY2018)Increase in operations staffing –1 additional UtilitymanWaterratesremainatcurrentlevelforFY2018Water rates remain at current level for FY2018•Key IssuesImpact of conditions of the final provisions of the Water Management Act PermitRegulatory requirements caused by revisions of the Major Drinking Water RulesChitti tfthGlMChange 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