Loading...
HomeMy WebLinkAboutSection Vlll - Enterprise Funds - Wannacomet WaterTown and County of Nantucket 16 Broad Street Nantucket, MA 02554 FY2019 BUDGET PROJECTION ENTERPRISE FUNDS – WANNACOMET WATER FY2019 BudgetWannacomet Enterprise Fund 1 FY2018Wannacomet 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.•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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. (at state level January 2018)•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 spring of 2018)WANNACOMET WATER ENTERPRISE2 FY2019Wannacomet Enterprise Fund Overview •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)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 CompanyComplete the New Administration Building •Significant Changes Year‐to‐Year (FY2018 to FY2019)Increase in operations staffing –2 additional UtilitymanWater rates remain at current level for FY2019•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 RulesWANNACOMET WATER ENTERPRISE3 FY2019 BudgetWannacomet Enterprise FundWANNACOMET WATER ENTERPRISESUMMARY3-YEAR ACTUAL FY2015 ACTUAL FY2016 ACTUAL FY2017 ACTUAL FY2018 ACTUAL YTD SIMPLEAVERAGE COMPOUND ANNUAL GROWTH RATE FY2018 BUDGET FY2019 BUDGET $ INC/(DEC) FY19/FY18 % INC/(DEC) FY19/FY18 Payroll-Salary 1,079,925$ 1,034,744$ 1,164,382$ 530,353$ 1,093,017$ 3.8% 1,241,091$ 1,251,558$ 10,467$ 0.8% Medicare P/R Tax Expenses 15,376 14,741 16,620 7,690 15,579 4.0% 17,900 17,900 - - Medical Insurance184,636 210,317 245,197 122,903 213,383 15.2% 304,288 337,000 32,712 10.8% Barnstable County Retirement 204,649 210,008 208,499 228,928 207,719 0.9% 238,121 237,953 (168) (0.1%) Utilities160,802 185,099 163,619 100,148 169,840 0.9% 199,900 199,900 - - Repairs & Maintenance188,096 227,845 172,012 99,105 195,984 (4.4%) 367,000 261,700 (105,300) (28.7%) Professional Services60,143 60,522 73,790 42,783 64,818 10.8% 187,500 204,500 17,000 9.1% Debt Service2,310,123 2,247,187 2,245,433 1,317,318 2,267,581 (1.4%) 2,316,010 2,348,620 32,610 1.4% General Insurance80,550 82,816 46,000 2,173 69,789 (24.4%) 89,000 110,000 21,000 23.6% Other Supplies18,286 20,508 22,570 6,578 20,455 11.1% 29,500 27,000 (2,500) (8.5%) Inventory132,269 251,952 224,151 106,587 202,791 30.2% 200,000 200,000 - - Travel42,994 29,239 45,838 20,937 39,357 3.3% 50,000 60,000 10,000 20.0% Water Analysis16,749 21,993 13,386 6,632 17,376 (10.6%) 23,000 23,000 - - Other227,963 237,991 108,184 91,995 191,379 (31.1%) 540,780 429,179 (111,601) (20.6%) TOTAL WANNACOMET 4,722,561$ 4,834,962$ 4,749,682$ 2,684,130$ 4,769,068$ 0.3% 5,804,090$ 5,708,310$ (95,780)$ (1.7%) 4 AppendixWannacomet Enterprise Fund5 Town & County of Nantucket Organization Chart – Wannacomet Enterprise FundMark J. WillettDirectorChristopher R. PykoszOperations ManagerRob WestSenior EngineerJeffrey JohnsenUtility manKyle RobertsUtilitymanRobert EarleUtility manMorgan PerryUtility manHeidi HoldgateBusiness ManagerNoreen SlavitzNantucket Water CommissionAllen ReinhardNantucket Water CommissionNelson K. EldridgeNantucket Water CommissionDenese AllenAss. Business ManagerLinda RobertsProject CoordinatorAndrea MansfieldAdmin. AssistantWANNACOMET WATER ENTERPRISEJonathan Vollans, IIUtility man6 FY2019 Budget DetailWANNACOMET WATER ENTERPRISE7 FY2019Wannacomet Fund Exceptions PositionsOperational Expenses (1)1. Salary, Temporary: $5,500 1. Repairs & Maintenance (Office Equipment): $7,5002. Repairs & Maintenance (Grounds): $5,0003. Repairs & Maintenance (Hydrants): $10,0004. Repairs & Maintenance (SCADA): $6,5005. Professional Services: $10,0006. In‐State Travel: $10,0007. In‐State Prof Dev: $5,0008. Add’l Equipment –Office Furniture: $10,5009. Total Debt Service (P&I): $32,610 Capital Items1. Water Main Replacements: $3,533,2302. Water Tank Maintenance: $658,000(1) Non‐controllable expenses such as general insurance, medical insurance, pension costs and utilities are excluded.WANNACOMET WATER ENTERPRISE8 TOWN OF NANTUCKETWANNACOMET WATER - ENTERPRISE FUNDACTUALBUDGETPROJECTED BUDGETFY2017FY2018FY2019Revenue6,466,177 5,804,090 5,708,310 Expenses4,749,682 5,804,090 5,708,310 Net Earnings1,716,495 - - Transfer from Retained Earnings- - - Net Earnings after R/E Transfer1,716,495 - - Ending FB1,716,495 - - TOTALCertified Retained Earnings as of July 1, 2017 2,394,326 9 WANNACOMET WATER ENTERPRISE FUNDOPERATIONS BUDGETFY2019 BUDGET PROJECTION3-YEAR ACTUALDEPT ACCOUNT ACCOUNT NAME FY2015 ACTUAL FY2016 ACTUAL FY2017 ACTUAL FY2018 ACTUAL YTD SIMPLEAVERAGE COMPOUND ANNUAL GROWTH RATE FY2018 BUDGET FY2019 BUDGET $ INC/(DEC) FY19/FY18 % INC/(DEC) FY19/FY18 63455 42110 WATER USE FEE (4,353,145)$ (4,789,250)$ (5,279,434)$ (3,449,493)$ (4,807,276)$ 10.1% (4,914,340) (4,845,000)$ 69,340$ (1.4%) 63455 42111 WATER CONNECTION FEE (442,559) (628,051) (646,040) (290,064) (572,216) 20.8% (575,000) (500,000) 75,000 (13.0%) 63455 42115 CROSS CONNECTION DEVICE TEST FEE- (10,600) (13,800) (12,750) (8,133) na(30,900) (30,000) 900 (2.9%) 63455 42441 LATE PAYMENT SERVICE FEE(31,849) (38,453) (43,592) (24,359) (37,965) 17.0% (34,800) (34,800) - - 63455 43606 RENTAL INCOME (18,600) (18,600) (6,600) (28,300) (14,600) (40.4%) (18,650) (48,600) (29,950) 160.6% 63455 48201 INTEREST ON INVESTMENTS (4,686) (7,354) (21,717) (10,618) (11,252) 115.3% (4,700) (21,510) (16,810) 357.7% 63455 48400 CONTRACT SERVICES - SEWER (115,198) (128,688) (143,264) (42,360) (129,050) 11.5% (105,000) (105,000) - - 63455 48401 REVENUE - OUTSIDE BILLING (6,498) (4,200) (3,385) (900) (4,694) (27.8%) (4,800) (3,500) 1,300 (27.1%) 63455 48416 CONTRACT SERVICES - SIAS WATER (60,000) (65,000) (100,179) (20,000) (75,060) 29.2% (88,000) (88,000) - - 63455 48417 TRANSFER FEE (32,016) (26,645) (27,739) (17,425) (28,800) (6.9%) (26,000) (30,000) (4,000) 15.4% 63455 49102 PROCEEDS FROM BOND SALE- - - - - na- - - na63455 49104 PREMIUM REVENUE ON DEBT (1,889) (47,805) (180,428) - (76,707) 877.4% (1,900) (1,900) - - 63455 49701 TRANSFER FROM GENERAL FUND- - - - - na- - - naTOTAL REVENUE (5,066,439) (5,764,646) (6,466,177) (3,896,269) (5,765,754) 13.0% (5,804,090) (5,708,310) 95,780 (1.7%) 63455 51100 SALARY - OUTSIDE BILLING 29,834 27,320 94,444 59,522 50,533 77.9% 1,180,420 1,179,587 (833) (0.1%) 63455 51101 SALARY - ADMIN/GENERAL 261,307 270,007 322,897 130,590 284,737 11.2% - - - na63455 51102 SALARY - OPS/ENG 281,114 288,995 281,032 96,727 283,714 (0.0%) - - - na63455 51103 SALARY - PUMPING LABOR - - - - - na- - - na63455 51105 SALARY - SOURCE OF SUPPLY - - - - - na- - - na63455 51106 SALARY - DISTRIBUTION 215,459 154,966 161,621 84,660 177,349 (13.4%) - - - na63455 51107 SALARY - MISC METER LABOR 69,215 74,501 73,121 38,429 72,279 2.8% - - - na63455 51108 SALARY - METER READ LABOR - - - - - na- - - na63455 51117 SALARY - BILL & ACCT WATE 146,797 151,189 159,628 81,609 152,538 4.3% - - - na63455 51118 SALARY - BILL & ACCT SEWE - - - - - na- - - na63455 51119 SALARY-A & G SCONSET WATER - - - - - na- - - na63455 51200 SALARY, TEMPORARY - - - - - na2,500 8,000 5,500 220.0% 63455 51300 OVERTIME 14,385 11,072 13,098 3,463 12,852 (4.6%) 3,000 3,000 - - 63455 51700 LONGEVITY PAY 42,569 38,595 40,403 35,352 40,523 (2.6%) 33,400 38,700 5,300 15.9% 63455 51701 INS PREM:MEDICAL BLUE CROSS 184,636 210,317 245,197 122,903 213,383 15.2% 304,288 337,000 32,712 10.8% 63455 51705 MEDICARE/MEDEX/RETIREES - - - - - na- - - na63455 51770 BARNSTABLE COUNTY RETIREMT FND 204,649 210,008 208,499 228,928 207,719 0.9% 238,121 237,953 (168) (0.1%) 63455 51960 COMPENSATION/UNEMPLOYMENT 1,471 - - - 490 (100.0%) 2,271 2,271 - - 63455 51961 MEDICARE P/R TAX 15,376 14,741 16,620 7,690 15,579 4.0% 17,900 17,900 - - 63455 51962 DEF COMP EMPLOYER CONTRIBUTION 17,773 18,099 15,379 - 17,084 (7.0%) 18,500 19,000 500 2.7% 63455 51963 WORKMANS COMPENSATION - - 2,759 - 920 na1,000 1,000 - - SUBTOTAL SALARY EXPENSE1,484,586 1,469,810 1,634,699 889,874 1,529,698 4.9% 1,801,400 1,844,411 43,011 2.4% 63455 52101 UTILITY:ELECTRICITY 9,758 9,464 8,989 3,615 9,404 (4.0%) 12,000 12,000 - - 63455 52103 UTILITY:FUEL OIL 7,017 3,868 8,000 585 6,295 6.8% 8,000 8,000 - - 63455 52104 ELECTRICITY - PUMPING 119,791 149,642 128,587 87,867 132,673 3.6% 150,000 150,000 - - 63455 52107 UTILITY: LANDFILL- 383 - - 128 na400 400 - - 63455 52401 REP&MAINT:OFFICE EQUIP 48,397 44,181 58,325 24,665 50,301 9.8% 75,000 82,500 7,500 10.0% 63455 52403 REP&MAINT:VEHICLE 11,795 4,833 5,566 5,471 7,398 (31.3%) 5,000 5,000 - - 63455 52404 REP&MAINT:BUILDING 6,495 15,557 15,922 18,265 12,658 56.6% 58,500 20,000 (38,500) (65.8%) 63455 52405 REP&MAINT:EQUIPMENT 1,759 518 2,791 2,431 1,689 26.0% 1,500 4,500 3,000 200.0% 63455 52411 REP&MAINT:GROUNDS 46,697 25,571 25,980 4,650 32,749 (25.4%) 30,000 35,000 5,000 16.7% 63455 52412 REP & MAINT - PUMPING EQP 5,599 7,051 6,159 1,611 6,270 4.9% 8,000 7,200 (800) (10.0%) 63455 52413 REP & MAINT - MAINS 11,458 6,404 3,678 12,741 7,180 (43.3%) 32,000 30,000 (2,000) (6.3%) 63455 52414 REP & MAINT - HYDRANTS 6,805 66 1,498 180 2,790 (53.1%) 5,000 15,000 10,000 200.0% 63455 52415 REPAIR & MAINT - SERVICES 47,944 123,341 49,151 16,590 73,479 1.3% 36,000 40,000 4,000 11.1% 63455 52416 REP & MAINT - METER INSTA 208 155 2,886 2,781 1,083 272.9% 3,000 3,000 - - 10 WANNACOMET WATER ENTERPRISE FUNDOPERATIONS BUDGETFY2019 BUDGET PROJECTION3-YEAR ACTUALDEPT ACCOUNT ACCOUNT NAME FY2015 ACTUAL FY2016 ACTUAL FY2017 ACTUAL FY2018 ACTUAL YTD SIMPLEAVERAGE COMPOUND ANNUAL GROWTH RATE FY2018 BUDGET FY2019 BUDGET $ INC/(DEC) FY19/FY18 % INC/(DEC) FY19/FY18 63455 52417 REPAIR & MAINT PUMP STRUCTURE 261 169 56 - 162 (53.7%) 65,000 5,000 (60,000) (92.3%) 63455 52418 REPAIR & MAINT-STANDPIPE - - - - - na45,000 5,000 (40,000) (88.9%) 63455 52419 MAINTENANCE TO METERS 25 - - - 8 (100.0%) 2,000 2,000 - - 63455 52423 REPAIR & MAINTENANCE SCADA 654 - - 9,720 218 (100.0%) 1,000 7,500 6,500 650.0% 63455 52703 RENT / LSE: POSTAGE METER1,526 1,526 1,526 768 1,526 - 1,600 1,600 - - 63455 52907 LANDFILL & WASTE WATR FEE - 2,300 307 - 869 na2,500 2,500 - - 63455 52908 PROPERTY:EQUIP RENTAL - - - - - na- - - na63455 53100 PROFESSIONAL SERVICES 20,925 30,938 44,032 22,177 31,965 45.1% 145,000 155,000 10,000 6.9% 63455 53101 GENERAL:ACCOUNTNG & AUDIT 13,500 11,000 12,800 12,000 12,433 (2.6%) 21,500 24,500 3,000 14.0% 63455 53102 GENERAL:LEGAL SERVICES 5,579 4,500 4,342 438 4,807 (11.8%) 6,000 10,000 4,000 66.7% 63455 53103 GENERAL:ADVERTISING 3,685 5,698 6,140 3,356 5,175 29.1% 5,000 7,500 2,500 50.0% 63455 53105 GENERAL: EXP. PUBLIC INFO 2,506 3,234 4,320 2,450 3,353 31.3% 10,000 10,000 - - 63455 53106 GENERAL:CUSTODIAL 9,573 9,164 9,280 4,050 9,339 (1.5%) 10,500 12,000 1,500 14.3% 63455 53107 PROF SVCS - WATER ANALYSI 16,749 21,993 13,386 6,632 17,376 (10.6%) 23,000 23,000 - - 63455 53108 OUTSOURCE BILLING 20,139 14,084 12,617 8,168 15,613 (20.8%) 15,000 15,000 - - 63455 53110 GENERAL:PRINTING 1,862 2,594 1,551 175 2,002 (8.7%) 2,500 2,500 - - 63455 53401 COMM:TELEPHONE 8,315 8,939 7,974 4,111 8,409 (2.1%) 12,000 12,000 - - 63455 53402 COMM:POSTAGE 30,159 26,650 27,828 13,184 28,212 (3.9%) 30,000 30,000 - - 63455 53803 OTHER:LICENSES & TAXES 5,375 5,472 5,258 5,979 5,368 (1.1%) 6,000 6,000 - - 63455 53804 OTHER:FREIGHT 1,477 1,241 3,000 1,580 1,906 42.5% 2,000 2,000 - - 63455 54101 ENERGY:GAS & DIESEL 15,922 10,504 9,761 3,970 12,062 (21.7%) 15,000 15,000 - - 63455 54201 OFFICE SUPPLIES 6,556 5,594 6,773 1,508 6,308 1.6% 5,000 7,500 2,500 50.0% 63455 54301 TOOLS & EQUIPMENT 1,921 5,318 4,406 617 3,882 51.4% 2,000 6,000 4,000 200.0% 63455 54302 MISC MATERIALS & SUPPLIES 2,299 2,245 1,729 860 2,091 (13.3%) 2,500 3,500 1,000 40.0% 63455 54303 INVENTORY 132,269 251,952 224,151 106,587 202,791 30.2% 200,000 200,000 - - 63455 54306 PUMP MATERIALS AND SUPPLIES - 473 1,367 - 613 na- - - na63455 54308 ENGINEERING:SUPPLIES & MATERIA 7,510 6,877 8,295 3,593 7,561 5.1% 20,000 10,000 (10,000) (50.0%) 63455 54501 CUSTODIAL:CLEANING SUPPLY - - - - - na- - - na63455 54701 SAFETY:UNIFORMS 2,885 2,220 2,474 1,802 2,527 (7.4%) 2,800 3,500 700 25.0% 63455 54702 SAFETY:MATERIALS - - - - - na- - - na63455 55101 BOOKS/SUBSCRIPTIONS 748 683 803 340 744 3.6% 1,200 2,500 1,300 108.3% 63455 57101 IN-STATE:MISC TRAVEL 27,229 21,391 42,712 19,240 30,444 25.2% 35,000 45,000 10,000 28.6% 63455 57102 IN-STATE:MILEAGE/CAR ALLW 292 351 83 72 242 (46.6%) - - - na63455 57103 IN-STATE:SEMINARS,PROF GA - 1,910 965 1,625 958 na5,000 10,000 5,000 100.0% 63455 57201 OUT-STATE:GENERAL 15,473 5,587 2,078 - 7,713 (63.4%) 10,000 5,000 (5,000) (50.0%) 63455 57301 DUES:PROFESSNL ORGANIZATN 2,397 3,495 3,679 1,428 3,190 23.9% 2,500 2,500 - - 63455 57401 INS PREM:AUTO & LIABILITY 21,065 20,685 7,157 - 16,302 (41.7%) 24,000 24,000 - - 63455 57404 INS PREM:BLANKET INS,BLDG 58,019 62,131 38,111 - 52,754 (19.0%) 65,000 85,000 20,000 30.8% 63455 57406 INS PREM:CLAIM DEDUCTIBLE 1,466 - 732 2,173 733 (29.3%) - 1,000 1,000 na63455 57802 OTHER:SCHOOLS MISC - - - - - na- - - na63455 58501ADD EQ:NEW EQUIP 10,901 4,039 7,056 40,633 7,332 (19.5%) 80,000 55,000 (25,000) (31.3%) 63455 58502ADD EQ:OFFICE FURNITURE - 351 1,125 - 492 na2,000 12,500 10,500 525.0% 63455 58701 REPLACEMENT EQ:GENERAL 3,891 - 1,482 - 1,791 (38.3%) 3,000 3,000 - - 63455 58702 UNALLOCATED EXPENSES - 78,624 32,663 16,250 37,096 na280,680 177,579 (103,101) (36.7%) 63455 58904 CAP PROJ:PURCHASES - - - - - na- - - na63455 59101 DEBT SERV:PRINCIPAL 1,560,000 1,598,000 1,615,800 963,235 1,591,267 1.8% 1,675,000 1,739,090 64,090 3.8% 63455 59102 DEBT SERVICE INTEREST 750,123 649,187 629,633 354,083 676,314 (8.4%) 641,010 609,530 (31,480) (4.9%) 11 WANNACOMET WATER ENTERPRISE FUNDOPERATIONS BUDGETFY2019 BUDGET PROJECTION3-YEAR ACTUALDEPT ACCOUNT ACCOUNT NAME FY2015 ACTUAL FY2016 ACTUAL FY2017 ACTUAL FY2018 ACTUAL YTD SIMPLEAVERAGE COMPOUND ANNUAL GROWTH RATE FY2018 BUDGET FY2019 BUDGET $ INC/(DEC) FY19/FY18 % INC/(DEC) FY19/FY18 63455 59103 ISSUE EXPENSE- - - - - na- - - na63455 59250 INTEREST: GENERAL 7,978 - - - 2,659 (100.0%) 8,000 8,000 - - 63455 59501 OTHER FIN:GENERAL - - - - - na- - - na63455 59991 TRANSFER TO GF (INDIRECT COSTS) 143,000 93,000 - - 78,667 (100.0%) 93,000 93,000 - - SUBTOTAL OPERATIONS EXPENSES3,237,974 3,365,153 3,114,983 1,794,256 3,239,370 (1.9%) 4,002,690 3,863,899 (138,791) (3.5%) WANNACOMET WATER ENTERPRISE FUND GRAND TOTALTOTAL REVENUE (5,066,439)$ (5,764,646)$ (6,466,177)$ (3,896,269)$ (5,765,754)$ 13.0% (5,804,090)$ (5,708,310)$ 95,780$ (1.7%) TOTAL EXPENSE4,722,561$ 4,834,962$ 4,749,682$ 2,684,130$ 4,769,068$ 0.3% 5,804,090$ 5,708,310$ (95,780)$ (1.7%) VARIANCE(343,878)$ (929,684)$ (1,716,495)$ (1,212,139)$ (996,686)$ 123.4% -$ -$ -$ na12 FY2019 Personnel SpreadsheetNumber of Positions in DepartmentFull-time 12Part-time 0Seasonal 0Temporary 0Vacancies 0New Positions Requested 0TOTAL OF ALL POSITIONS 12Name, Position Job CodeAvg Hours Per WeekClass & Step as of 6/30/18(e.g., B -Step 3)Yearly Salaryas of 6/30/1853 Week AdjustmentFY2019 IncreaseDateProratedFY2019SalaryLongevityPayEducationPayCertificationPayHolidayPayOtherTotal byEmployeeWILLETT, M. - DIRECTOR WW01 40.00 N/A 130,500 130,851 09/11/18 154,415 6,200 0 0 0 19,000 179,615PYKOSZ, C. - OPERATIONS MGR WW23 40.00 N/A 119,246 119,567 07/01/18 122,590 6,200 0 0 0 0 128,790HOLDGATE, H. - DEPUTY DIRECTOR WW24 40.00 N/A 119,246 119,567 07/01/18 122,590 6,200 0 0 0 0 128,790ROBERTS, L. - CUSTOMER SVC SUPV WW15 40.00 N/A 80,961 81,179 07/01/18 85,280 4,300 0 0 0 0 89,580ALLEN, D. - ASST. BUSINESS MGR WW24 40.00 N/A 81,120 81,338 07/01/18 85,280 0 0 0 0 0 85,280MANSFIELD, A. - ADMIN ASST. WW07 40.00 N/A 80,962 81,180 07/01/18 85,280 3,500 0 0 0 0 88,780VOLLANS, J. - UTILITYMAN WW35 40.00 UT 1 52,000 52,140 01/15/19 73,466 0 0 0 0 73,466WEST, R. - ENGINEER WW35 40.00 N/A 80,954 81,172 07/01/18 93,600 2,700 0 0 0 0 96,300EARLE, R. - UTILITYMAN WW60 40.00 UT 1 72,842 73,038 07/01/18 79,540 3,200 0 0 0 0 82,740JOHNSEN, J. - UTILITYMAN WW60 40.00 UT 1 72,842 73,038 07/01/18 79,540 4,000 0 0 0 0 83,540ROBERTS, K. - UTILITYMAN WW50 40.00 UT 1 72,842 73,038 07/01/18 79,540 2,400 0 0 0 0 81,940PERRY, M. - UTILITYMAN WW50 40.00 UT 1 70,720 70,910 01/15/19 73,466 0 0 0 0 73,46638,700 19,000 1,192,287Total Prorated Salary (enter on Munis 51100)1,134,58725,00020,0008,0003,00038,7001,229,28717,9002,2711,00019,000337,000237,9531,844,411Total 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 Total Compensation/Unemployment (enter on MUNIS 51960)Wannacomet Water Enterprise FundORG: 63455Total On-Call PayTotal Merit PayTotal Salary TemporaryOvertime (enter on Munis 51300)Total Longevity (enter on Munis 51700)Salary SubtotalMedicare (enter on Munis 51961)13 WANNACOMET WATER ENTERPRISEWaterfall Schedule ‐ FY2019 BudgetIssue Payments Payments Payments Payments Payments Payments Payments Payments Payments PaymentsPurpose Date FY2017 FY2018 FY2019 FY2020 FY2021 FY2022 FY2023 FY2024 FY2025 FY2026WWCO ‐ PRINCIPAL PAYMENTS TOTAL DEBT 20,888,200   19,272,400   17,597,400   15,859,400   14,209,400     12,519,400   10,986,400   9,469,400   7,940,400   6,404,400   REHAB GARAGE & MAINTENANCE FACILITY 2/15/200840,000           40,000           SOURCE WELL & PUMP 2/15/200865,000           65,000           WATER STORAGE TANK (ORIG)2/15/2008250,000         250,000         WATER MAINS2/15/200865,000           65,000           WATER SYSTEM DISTRIBUTION2/15/200850,000           50,000           WATER MAINS 22/15/20085,000             5,000             WATER STORAGE TANK (SUPP) 3/15/2009125,000         130,000         130,000         SYSTEMS IMPROVEMENT / METER BATTERIES 2/15/2010140,000         135,000         135,000         50,000           50,000             50,000           50,000           50,000         50,000         50,000          WWCO CURRENT REFUNDING 05/2001 6/7/201250,000           50,000           50,000           50,000           50,000             ‐‐‐MADKET MAIN 1 6/7/201260,000           60,000           60,000           60,000           60,000             60,000           60,000           60,000         60,000         60,000          MADAKET MAIN 2 6/7/201240,000           40,000           40,000           40,000           40,000             40,000           40,000           40,000         40,000         40,000          WASHING POND TANK REHAB6/7/201295,000           95,000           95,000           95,000           90,000             ‐‐‐ADMINISTRATION BUILDING6/7/201260,000           60,000           60,000           60,000           60,000             60,000           60,000           60,000         60,000         60,000          METER UPGRADES6/7/201240,000           40,000           40,000           40,000           40,000             40,000           ‐‐ADV REF 10/01/2004 (LAND)3/5/2013156,000         153,000         149,000         149,000         145,000           147,000         147,000         145,000      145,000      ADV REF 10/01/2004 (WATER 2)3/5/201326,000           26,000           25,000           25,000           25,000             24,000           24,000           24,000         24,000         ADV REF 10/01/2004 (WATER 1)3/5/201326,000           26,000           25,000           25,000           25,000             24,000           24,000           24,000         24,000         ADV REF 11/15/2005 WATER 12/5/2015162,800         145,000         160,000         150,000         190,000           170,000         185,000         195,000      200,000      197,000      ADV REF 11/15/2005 WATER 32/5/201524,800           25,000           25,000           30,000           30,000             30,000           35,000           35,000         30,000         30,000          ADV REF 11/2005 GARAGE AND MAINT 2/5/201550,200           45,000           50,000           50,000           55,000             55,000           55,000           55,000         60,000         57,000          776 WATER DISTRIBUTION10/22/201541,000           40,000           40,000           40,000           40,000             40,000           40,000           40,000         40,000         40,000          785 WATER DISTRIBUTION10/22/201540,000           40,000           40,000           40,000           40,000             40,000           40,000           40,000         40,000         40,000          Refi WWCO Admin 08 750K July'168/3/201638,000           38,000           38,000             37,000           37,000           37,000         37,000         32,000          Refi WWCO Well 08 1.3M July '168/3/201662,000           62,000           62,000             62,000           62,000           61,000         61,000         61,000          Refi WWCO Tank 08 5M July '168/3/2016238,000         238,000         237,000           237,000         236,000         236,000      235,000      234,000      Refi WWCO Main 08 1.25M July'168/3/201657,000           57,000           57,000             57,000           57,000           57,000         56,000         56,000          Refi WWCO DistImp 08 1M Jul'16 8/3/201648,000           48,000           48,000             47,000           47,000           47,000         47,000         47,000          Refi WWCO Mains2 08 100K Jul'16 8/3/20165,000             5,000             5,000              5,000             5,000             5,000           5,000           5,000            Refi WWCO Tank 09 2.815M Jul'16 8/3/20164,000             133,000         138,000           143,000         148,000         158,000      162,000      172,000      WYERS VALLEY WELLS NOV '1611/9/201690,000           90,000           90,000           90,000             90,000           90,000           90,000         90,000         90,000          WATER MAINS11/29/201776,000           75,000           75,000             75,000           75,000           70,000         70,000         70,000          TOTAL WANNACOMET DEBT (Principal)1,615,800     1,675,000     1,738,000     1,650,000     1,690,000       1,533,000     1,517,000     1,529,000   1,536,000   1,341,000   14 WANNACOMET WATER ENTERPRISEWaterfall Schedule ‐ FY2019 BudgetIssue Payments Payments Payments Payments Payments Payments Payments Payments Payments PaymentsPurpose Date FY2017 FY2018 FY2019 FY2020 FY2021 FY2022 FY2023 FY2024 FY2025 FY2026WWCO ‐ INTEREST PAYMENTSREHAB GARAGE & MAINTENANCE FACILITY 2/15/20082,700             1,400             SOURCE WELL & PUMP 2/15/20084,388             2,275             WATER STORAGE TANK (ORIG)2/15/200816,875           8,750             WATER MAINS2/15/20084,388             2,275             WATER SYSTEM DISTRIBUTION2/15/20083,375             1,750             WATER MAINS 22/15/2008338                 175                 WATER STORAGE TANK (SUPP)3/15/200914,800           11,050           6,500             SYSTEMS IMPROVEMENT / METER BATTERIES 2/15/201036,775           31,175           25,775           20,375           18,875             16,875           15,375           13,375         11,750         9,750            CURRENT REFUNDING 05/20016/7/201210,750           8,250             5,750             3,500             1,250              MADKET MAIN 16/7/201238,100           35,100           32,100           29,400           26,700             23,700           20,700           17,700         14,700         12,300          MADAKET MAIN 26/7/201225,400           23,400           21,400           19,600           17,800             15,800           13,800           11,800         9,800           8,200            WASHING POND (NEW ST.) TANK REHAB6/7/201220,175           15,425           10,675           6,400             2,250              ADMINISTRATION BUILDING6/7/201238,100           35,100           32,100           29,400           26,700             23,700           20,700           17,700         14,700         12,300          METER UPGRADES6/7/201210,600           8,600             6,600             4,800             3,000              1,000             ADV REF 10/01/2004 (LAND)3/5/201336,110           32,623           29,240           25,888           21,870             16,765           12,355           7,250           2,175           ADV REF 10/01/2004 (WATER 2)3/5/20136,025             5,440             4,870             4,308             3,620              2,760             2,040             1,200           360              ADV REF 10/01/2004 (WATER 1)3/5/20136,025             5,440             4,870             4,308             3,620              2,760             2,040             1,200           360              ADV REF 11/15/2005 WATER 12/5/201542,938           39,860           36,810           33,710           30,310             25,860           20,535           14,835         8,910           2,955            ADV REF 11/15/2005 WATER 32/5/20157,248             6,750             6,250             5,700             5,100              4,350             3,375             2,325           1,350           450               ADV REF 11/2005 GARAGE AND MAINT2/5/201512,962           12,010           11,060           10,060           9,010              7,635             5,985             4,335           2,610           855               776 WATER DISTRIBUTION10/22/201531,928           20,150           18,950           17,750           16,750             15,950           14,950           13,750         12,550         11,350          785 WATER DISTRIBUTION10/22/201532,342           20,450           19,250           18,050           17,050             16,250           15,250           14,050         12,850         11,650          Refi WWCO Admin 08 750K July'168/3/201611,287           13,024           12,264           10,744           9,224              7,724             6,244             4,764           3,284           1,904            Refi WWCO Well 08 1.3M July '168/3/201620,185           23,290           22,050           19,570           17,090             14,610           12,130           9,670           7,230           4,790            Refi WWCO Tank 08 5M July '168/3/201677,561           89,493           84,733           75,213           65,713             56,233           46,773           37,333         27,913         18,533          Refi WWCO Main 08 1.25M July'168/3/201618,622           21,487           20,347           18,067           15,787             13,507           11,227           8,947           6,687           4,447            Refi WWCO DistImp 08 1M Jul'16 8/3/201615,522           17,910           16,950           15,030           13,110             11,210           9,330             7,450           5,570           3,690            Refi WWCO Mains2 08 100K Jul'168/3/20161,577             1,820             1,720             1,520             1,320              1,120             920                 720              520              320               Refi WWCO Tank 09 2.815M Jul'168/3/201649,074           56,556           56,556           53,896           48,476             42,856           37,036           30,916         24,516         17,836          WYERS VALLEY WELLS NOV '1611/9/201689,983           58,800           56,100           53,400             50,250           45,750           41,250         36,750         32,250          WATER MAINS11/29/201763,906           52,675           48,925             45,175           41,425           37,800         34,300         30,800          TOTAL WANNACOMET DEBT (Interest)596,168         641,011         609,526         536,063         476,950           416,090         357,940         298,370      238,885      184,380      TOTAL WANNACOMET DEBT (P&I)2,211,968     2,316,011     2,347,526     2,186,063     2,166,950       1,949,090     1,874,940     1,827,370   1,774,885   1,525,380   15 WANNACOMET WATER ENTERPRISEWaterfall Schedule ‐ FY2019 BudgetIssuePurpose DateWWCO ‐ PRINCIPAL PAYMENTS TOTAL DEBTREHAB GARAGE & MAINTENANCE FACILITY 2/15/2008SOURCE WELL & PUMP 2/15/2008WATER STORAGE TANK (ORIG) 2/15/2008WATER MAINS2/15/2008WATER SYSTEM DISTRIBUTION2/15/2008WATER MAINS 22/15/2008WATER STORAGE TANK (SUPP)3/15/2009SYSTEMS IMPROVEMENT / METER BATTERIES 2/15/2010WWCO CURRENT REFUNDING 05/20016/7/2012MADKET MAIN 16/7/2012MADAKET MAIN 26/7/2012WASHING POND TANK REHAB6/7/2012ADMINISTRATION BUILDING6/7/2012METER UPGRADES6/7/2012ADV REF 10/01/2004 (LAND)3/5/2013ADV REF 10/01/2004 (WATER 2)3/5/2013ADV REF 10/01/2004 (WATER 1)3/5/2013ADV REF 11/15/2005 WATER 12/5/2015ADV REF 11/15/2005 WATER 32/5/2015ADV REF 11/2005 GARAGE AND MAINT2/5/2015776 WATER DISTRIBUTION10/22/2015785 WATER DISTRIBUTION10/22/2015Refi WWCO Admin 08 750K July'168/3/2016Refi WWCO Well 08 1.3M July '168/3/2016Refi WWCO Tank 08 5M July '168/3/2016Refi WWCO Main 08 1.25M July'168/3/2016Refi WWCO DistImp 08 1M Jul'16 8/3/2016Refi WWCO Mains2 08 100K Jul'168/3/2016Refi WWCO Tank 09 2.815M Jul'168/3/2016WYERS VALLEY WELLS NOV '1611/9/2016WATER MAINS11/29/2017TOTAL WANNACOMET DEBT (Principal)Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments PaymentsFY2027 FY2028 FY2029 FY2030 FY2031 FY2032 FY2033 FY2034 FY2035 FY2036 FY20375,063,400   4,007,800   2,989,000   2,360,000   1,915,000   1,520,000   1,130,000   900,000    675,000    450,000    225,000    50,000         50,000         50,000         50,000         60,000         60,000         60,000         60,000         60,000          60,000         40,000         40,000         40,000         40,000         40,000          40,000         60,000         60,000         60,000         60,000         60,000          60,000         40,000         40,000         40,000         40,000         40,000          35,000         35,000         35,000      35,000      35,000      40,000         40,000         40,000         40,000         40,000          40,000         40,000         35,000      35,000      35,000      31,600         60,000         58,500         232,000      228,650      56,000         54,350         46,000         45,500         4,000           3,000           176,000      183,800      184,000      90,000         85,000         85,000         85,000         85,000          85,000         85,000         85,000      85,000      85,000      85,000       70,000         70,000         70,000         70,000         70,000          70,000         70,000         70,000      70,000      70,000      70,000       1,055,600   1,018,800   629,000      445,000      395,000       390,000      230,000      225,000    225,000    225,000    155,000    16 WANNACOMET WATER ENTERPRISEWaterfall Schedule ‐ FY2019 BudgetIssuePurpose DateWWCO ‐ INTEREST PAYMENTSREHAB GARAGE & MAINTENANCE FACILITY 2/15/2008SOURCE WELL & PUMP 2/15/2008WATER STORAGE TANK (ORIG)2/15/2008WATER MAINS2/15/2008WATER SYSTEM DISTRIBUTION2/15/2008WATER MAINS 22/15/2008WATER STORAGE TANK (SUPP)3/15/2009SYSTEMS IMPROVEMENT / METER BATTERIES 2/15/2010CURRENT REFUNDING 05/20016/7/2012MADKET MAIN 16/7/2012MADAKET MAIN 26/7/2012WASHING POND (NEW ST.) TANK REHAB6/7/2012ADMINISTRATION BUILDING6/7/2012METER UPGRADES6/7/2012ADV REF 10/01/2004 (LAND)3/5/2013ADV REF 10/01/2004 (WATER 2) 3/5/2013ADV REF 10/01/2004 (WATER 1)3/5/2013ADV REF 11/15/2005 WATER 12/5/2015ADV REF 11/15/2005 WATER 32/5/2015ADV REF 11/2005 GARAGE AND MAINT2/5/2015776 WATER DISTRIBUTION10/22/2015785 WATER DISTRIBUTION10/22/2015Refi WWCO Admin 08 750K July'168/3/2016Refi WWCO Well 08 1.3M July '168/3/2016Refi WWCO Tank 08 5M July '168/3/2016Refi WWCO Main 08 1.25M July'168/3/2016Refi WWCO DistImp 08 1M Jul'16 8/3/2016Refi WWCO Mains2 08 100K Jul'168/3/2016Refi WWCO Tank 09 2.815M Jul'168/3/2016WYERS VALLEY WELLS NOV '1611/9/2016WATER MAINS11/29/2017TOTAL WANNACOMET DEBT (Interest)TOTAL WANNACOMET DEBT (P&I)Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments PaymentsFY2027 FY2028 FY2029 FY2030 FY2031 FY2032 FY2033 FY2034 FY2035 FY2036 FY20377,750           6,000           4,000           2,000           10,500         8,700           6,863           4,988           3,038            1,013           7,000           5,800           4,575           3,325           2,025            675              10,500         8,700           6,863           4,988           3,038            1,013           10,200         9,100           8,000           6,900           5,800            4,725           3,675           2,625         1,575         525            10,500         9,400           8,300           7,200           6,100            4,950           3,750           2,625         1,575         525            632              2,370           585              9,213           2,287           2,207           544              1,830           455              140              30                10,876         5,518           1,840           27,750         24,225         21,675         19,125         16,575          14,025         11,475         8,925         6,375         3,825         1,275          27,300         23,800         20,650         17,850         15,575          13,650         11,550         9,450         7,350         5,250         3,150          138,768      105,143      82,765        66,375        52,150         40,050        30,450        23,625      16,875      10,125      4,425         1,194,368   1,123,943   711,765      511,375      447,150       430,050      260,450      248,625    241,875    235,125    159,425    17 WANNACOMET WATER ENTERPRISEWaterfall Schedule ‐ FY2019 BudgetIssuePurpose DateWWCO ‐ PRINCIPAL PAYMENTS TOTAL DEBTREHAB GARAGE & MAINTENANCE FACILITY 2/15/2008SOURCE WELL & PUMP 2/15/2008WATER STORAGE TANK (ORIG) 2/15/2008WATER MAINS2/15/2008WATER SYSTEM DISTRIBUTION2/15/2008WATER MAINS 22/15/2008WATER STORAGE TANK (SUPP)3/15/2009SYSTEMS IMPROVEMENT / METER BATTERIES 2/15/2010WWCO CURRENT REFUNDING 05/20016/7/2012MADKET MAIN 16/7/2012MADAKET MAIN 26/7/2012WASHING POND TANK REHAB6/7/2012ADMINISTRATION BUILDING6/7/2012METER UPGRADES6/7/2012ADV REF 10/01/2004 (LAND)3/5/2013ADV REF 10/01/2004 (WATER 2)3/5/2013ADV REF 10/01/2004 (WATER 1)3/5/2013ADV REF 11/15/2005 WATER 12/5/2015ADV REF 11/15/2005 WATER 32/5/2015ADV REF 11/2005 GARAGE AND MAINT2/5/2015776 WATER DISTRIBUTION10/22/2015785 WATER DISTRIBUTION10/22/2015Refi WWCO Admin 08 750K July'168/3/2016Refi WWCO Well 08 1.3M July '168/3/2016Refi WWCO Tank 08 5M July '168/3/2016Refi WWCO Main 08 1.25M July'168/3/2016Refi WWCO DistImp 08 1M Jul'16 8/3/2016Refi WWCO Mains2 08 100K Jul'168/3/2016Refi WWCO Tank 09 2.815M Jul'168/3/2016WYERS VALLEY WELLS NOV '1611/9/2016WATER MAINS11/29/2017TOTAL WANNACOMET DEBT (Principal)PaymentsFY203870,000      70,000      70,000      18 WANNACOMET WATER ENTERPRISEWaterfall Schedule ‐ FY2019 BudgetIssuePurpose DateWWCO ‐ INTEREST PAYMENTSREHAB GARAGE & MAINTENANCE FACILITY 2/15/2008SOURCE WELL & PUMP 2/15/2008WATER STORAGE TANK (ORIG)2/15/2008WATER MAINS2/15/2008WATER SYSTEM DISTRIBUTION2/15/2008WATER MAINS 22/15/2008WATER STORAGE TANK (SUPP)3/15/2009SYSTEMS IMPROVEMENT / METER BATTERIES 2/15/2010CURRENT REFUNDING 05/20016/7/2012MADKET MAIN 16/7/2012MADAKET MAIN 26/7/2012WASHING POND (NEW ST.) TANK REHAB6/7/2012ADMINISTRATION BUILDING6/7/2012METER UPGRADES6/7/2012ADV REF 10/01/2004 (LAND)3/5/2013ADV REF 10/01/2004 (WATER 2) 3/5/2013ADV REF 10/01/2004 (WATER 1)3/5/2013ADV REF 11/15/2005 WATER 12/5/2015ADV REF 11/15/2005 WATER 32/5/2015ADV REF 11/2005 GARAGE AND MAINT2/5/2015776 WATER DISTRIBUTION10/22/2015785 WATER DISTRIBUTION10/22/2015Refi WWCO Admin 08 750K July'168/3/2016Refi WWCO Well 08 1.3M July '168/3/2016Refi WWCO Tank 08 5M July '168/3/2016Refi WWCO Main 08 1.25M July'168/3/2016Refi WWCO DistImp 08 1M Jul'16 8/3/2016Refi WWCO Mains2 08 100K Jul'168/3/2016Refi WWCO Tank 09 2.815M Jul'168/3/2016WYERS VALLEY WELLS NOV '1611/9/2016WATER MAINS11/29/2017TOTAL WANNACOMET DEBT (Interest)TOTAL WANNACOMET DEBT (P&I)PaymentsFY20381,050         ‐             70,000      19