Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Section Vlll - Enterprise Funds - Wannacomet Water
Town 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 resourcesComplete and bring on‐line the replacement wells for the Wyer’s Valley Water SupplyDevelop 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. (at state level January 2018)•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 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 ProgramDevelop and implement consolidated budget and financial reporting for the consolidated Wannacomet Water CompanyComplete the New Administration Building •Significant Changes Year‐to‐Year (FY2018 to FY2019)Increase in operations staffing –2 additional UtilitymanWater rates remain at current level for FY2019•Key IssuesImpact of conditions of the final provisions of the Water Management Act PermitRegulatory 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