Loading...
HomeMy WebLinkAboutSection V - WWCO FY20 Budget FY2020 BUDGET PROJECTION • ENTERPRISE FUNDS: WANNACOMET WATER FY2020 Budget Wannacomet Enterprise Fund FY2020 Wannacomet 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: ➢Finalize the 20 year Water Management Act Permit with realistic objectives for managing our drinking water resources ➢Start new source well site investigation (New Supply Well) ➢Develop a modified 10 Year Capital Improvement Plan together with Sewer and Storm Water ➢Continue to work with other Departments to complete combined projects •Initiatives and Accomplishments: ➢Completed new office building construction ➢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 WANNACOMET WATER ENTERPRISE FY2020 Wannacomet Enterprise Fund Overview •Priorities: ➢Conduct a peak water demand build out study based upon the Water Management Act Permit ➢Develop and implement a groundwater investigation plan to look at new locations for a new supply well ➢Continue capital improvements to the Distribution System •Significant Changes Year-to-Year (FY2019 to FY2020) ➢Increase in staffing –1 Administrative Assistant ➢Water rates remain at current level for FY2020 ➢Service connection fee increase •Key Issues ➢Impact of conditions of the final provisions of the Water Management Act Permit ➢Demand on system from development and expansion ➢Capital improvements to meet the demand on the system ➢Resources to fund the capital improvements WANNACOMET WATER ENTERPRISE FY2020 Budget Wannacomet Enterprise Fund WANNACOMET WATER ENTERPRISE SUMMARY 3-YEAR ACTUAL FY2016 ACTUAL FY2017 ACTUAL FY2018 ACTUAL FY2019 ACTUAL YTD SIMPLE AVERAGE COMPOUND ANNUAL GROWTH RATE FY2019 BUDGET FY2020 BUDGET $ INC/(DEC) FY20/FY19 % INC/(DEC) FY20/FY19 Payroll-Salary 1,034,744$ 1,164,382$ 1,138,007$ 232,293$ 1,112,378$ 4.9% 1,251,558$ 1,329,193$ 77,635$ 6.2% Medicare P/R Tax Expenses 14,741 16,620 16,018 3,368 15,793$ 4.2% 17,900 17,900 - - Medical Insurance 210,317 245,197 242,727 51,338 232,747$ 7.4% 337,000 302,000 (35,000) (10.4%) Barnstable County Retirement 210,008 208,499 228,928 237,952 215,812$ 4.4% 237,953 258,180 20,227 8.5% Utilities 185,099 163,619 163,691 41,389 170,803$ (6.0%) 199,900 197,400 (2,500) (1.3%) Repairs & Maintenance 227,845 172,012 167,549 51,270 189,135$ (14.2%) 261,700 233,500 (28,200) (10.8%) Professional Services 60,522 73,790 80,203 10,770 71,505$ 15.1% 204,500 299,500 95,000 46.5% Debt Service 2,247,187 2,245,433 2,383,774 392,003 2,292,131$ 3.0% 2,348,620 2,416,267 67,647 2.9% General Insurance 82,816 46,000 54,907 - 61,241$ (18.6%) 111,500 120,900 9,400 8.4% Other Supplies 20,508 22,570 15,158 5,156 19,412$ (14.0%) 27,000 32,000 5,000 18.5% Inventory 251,952 224,151 223,323 50,042 233,142$ (5.9%) 200,000 360,000 160,000 80.0% Travel 29,239 45,838 36,608 1,485 37,228$ 11.9% 60,000 30,000 (30,000) (50.0%) Water Analysis 21,993 13,386 20,685 2,620 18,688$ (3.0%) 23,000 26,000 3,000 13.0% Other 237,991 201,184 221,117 9,558 220,097$ (3.6%) 488,047 549,157 61,110 12.5% TOTAL WANNACOMET 4,834,962$ 4,842,682$ 4,992,693$ 1,089,244$ 4,890,112$ 1.6% 5,768,678$ 6,171,997$ 403,319$ 7.0% Appendix Wannacomet Enterprise Fund Town & County of Nantucket Organization Chart –Wannacomet Enterprise Fund Mark J. Willett Director Christopher R. Pykosz Operations Manager Rob West Field Services Manager Jeffrey Johnsen Utility man Kyle Roberts Utility man Johnathan Vollans Utility man Heidi Holdgate Business Manager Noreen Slavitz Nantucket Water Commission Allen Reinhard Nantucket Water Commission Nelson K. Eldridge Nantucket Water Commission Linda Roberts Project Coordinator Andrea Mansfield Administrative Assistant Caroline Ferguson Customer Service Assistant WANNACOMET WATER ENTERPRISE Morgan Perry Utility man Denese Allen Assistant Business Manager Robert Earle Meter Technician FY2020 Budget Detail WANNACOMET WATER ENTERPRISE FY2020 Wannacomet Fund Exceptions Positions Operational Expenses (1) 1. Asset Management Program: $95,000 2.Water Meter Replacement: $160,000 3.New Equipment: $15,000 4.Repair & Maint Svcs: $70,000 Capital Items 1.New Source Investigation: $1,500,000 (1) Non-controllable expenses such as general insurance, medical insurance, pension costs and utilities are excluded. WANNACOMET WATER ENTERPRISE TOWN OF NANTUCKET WANNACOMET WATER - ENTERPRISE FUND ACTUAL BUDGET PROJECTED BUDGET FY2018 FY2019 FY2020 Revenue 6,250,469 5,708,310 5,947,000 Expenses 4,992,693 5,768,678 6,171,997 Net Earnings 1,257,776 (60,368) (225,000) Transfer from Retained Earnings - - 225,000 Net Earnings after R/E Transfer 1,257,776 (60,368) - Ending FB 1,257,776 (60,368) - TOTAL Certified Retained Earnings as of July 1, 2018 3,000,376 WANNACOMET WATER ENTERPRISE FUND OPERATIONS BUDGET FY2020 BUDGET PROJECTION 3-YEAR ACTUAL DEPT ACCOUNT ACCOUNT NAME FY2016 ACTUAL FY2017 ACTUAL FY2018 ACTUAL FY2019 ACTUAL YTD SIMPLE AVERAGE COMPOUND ANNUAL GROWTH RATE FY2019 BUDGET FY2020 BUDGET $ INC/(DEC) FY20/FY19 % INC/(DEC) FY20/FY19 63455 42110 WATER USE FEE (4,789,250)$ (5,279,434)$ (5,190,258)$ (1,414,131)$ (5,086,314)$ 4.1% (4,845,000) (5,122,600)$ (277,600)$ 5.7% 63455 42111 WATER CONNECTION FEE (628,051) (646,040) (678,560) (131,898)$ (650,883)$ 3.9% (500,000) (450,000) 50,000 (10.0%) 63455 42115 CROSS CONNECTION DEVICE TEST FEE (10,600) (13,800) (31,650) (6,435)$ (18,683)$ 72.8% (30,000) (37,500) (7,500) 25.0% 63455 42441 LATE PAYMENT SERVICE FEE (38,453) (43,592) (35,872) (5,771)$ (39,306)$ (3.4%) (34,800) (34,800) - - 63455 43606 RENTAL INCOME (18,600) (6,600) (48,600) (8,050)$ (24,600)$ 61.6% (48,600) (48,600) - - 63455 48201 INTEREST ON INVESTMENTS (7,354) (21,717) (28,390) -$ (19,154)$ 96.5% (21,510) (30,000) (8,490) 39.5% 63455 48400 CONTRACT SERVICES - SEWER (128,688) (143,264) (142,968) (818)$ (138,307)$ 5.4% (105,000) (110,000) (5,000) 4.8% 63455 48401 REVENUE - OUTSIDE BILLING (4,200) (3,385) (3,446) (1,221)$ (3,677)$ (9.4%) (3,500) (3,500) - - 63455 48416 CONTRACT SERVICES - SIAS WATER (65,000) (100,179) (60,000) (20,000)$ (75,060)$ (3.9%) (88,000) (80,000) 8,000 (9.1%) 63455 48417 TRANSFER FEE (26,645) (27,739) (30,725) (4,200)$ (28,370)$ 7.4% (30,000) (30,000) - - 63455 49102 PROCEEDS FROM BOND SALE - - - -$ -$ na - - - na 63455 49104 PREMIUM REVENUE ON DEBT (47,805) (180,428) - -$ (76,078)$ (100.0%) (1,900) - 1,900 (100.0%) 63455 49701 TRANSFER FROM GENERAL FUND - - - -$ -$ na - - - na TOTAL REVENUE (5,764,646) (6,466,177) (6,250,469) (1,592,524) (6,160,431) 4.1% (5,708,310) (5,947,000) (238,690) 4.2% 63455 51100 SALARY - OUTSIDE BILLING 27,320 94,444 114,096 22,258$ 78,620$ 104.4% 1,179,587 1,249,587 70,000 5.9% 63455 51200 SALARY, TEMPORARY - - 123 1,164$ 41$ na 8,000 5,000 (3,000) (37.5%) 63455 51300 OVERTIME 11,072 13,098 15,565 10,114$ 13,245$ 18.6% 3,000 10,000 7,000 233.3% 63455 51700 LONGEVITY PAY 38,595 40,403 35,352 -$ 38,117$ (4.3%) 38,700 40,835 2,135 5.5% 63455 51701 INS PREM:MEDICAL BLUE CROSS 210,317 245,197 242,727 51,338$ 232,747$ 7.4% 337,000 302,000 (35,000) (10.4%) 63455 51705 MEDICARE/MEDEX/RETIREES - - - -$ -$ na - - - na 63455 51770 BARNSTABLE COUNTY RETIREMT FND 210,008 208,499 228,928 237,952$ 215,812$ 4.4% 237,953 258,180 20,227 8.5% 63455 51960 COMPENSATION/UNEMPLOYMENT - - - -$ -$ na 2,271 2,271 - - 63455 51961 MEDICARE P/R TAX 14,741 16,620 16,018 3,368$ 15,793$ 4.2% 17,900 17,900 - - 63455 51962 DEF COMP EMPLOYER CONTRIBUTION 18,099 15,379 31,240 -$ 21,573$ 31.4% 19,000 19,500 500 2.6% 63455 51963 WORKMANS COMPENSATION - 2,759 2,085 -$ 1,615$ na 1,000 2,000 1,000 100.0% SUBTOTAL SALARY EXPENSE 1,469,810 1,634,699 1,625,680 524,952 1,576,730 5.2% 1,844,411 1,907,273 62,862 3.4% 63455 52101 UTILITY:ELECTRICITY 9,464 8,989 11,363 1,795$ 9,939$ 9.6% 12,000 15,000 3,000 25.0% 63455 52103 UTILITY:FUEL OIL 3,868 8,000 2,827 491$ 4,898$ (14.5%) 8,000 2,500 (5,500) (68.8%) 63455 52104 ELECTRICITY - PUMPING 149,642 128,587 130,294 35,637$ 136,174$ (6.7%) 150,000 150,000 - - 63455 52107 UTILITY: LANDFILL 383 - 391 -$ 258$ 1.0% 400 400 - - 63455 52401 REP&MAINT:OFFICE EQUIP 44,181 58,325 33,826 9,057$ 45,444$ (12.5%) 82,500 60,000 (22,500) (27.3%) 63455 52403 REP&MAINT:VEHICLE 4,833 5,566 8,351 238$ 6,250$ 31.4% 5,000 5,000 - - 63455 52404 REP&MAINT:BUILDING 15,557 15,922 21,754 5,059$ 17,744$ 18.3% 20,000 25,000 5,000 25.0% 63455 52405 REP&MAINT:EQUIPMENT 518 2,791 3,097 394$ 2,135$ 144.5% 4,500 3,500 (1,000) (22.2%) 63455 52411 REP&MAINT:GROUNDS 25,571 25,980 9,478 4,328$ 20,343$ (39.1%) 35,000 30,000 (5,000) (14.3%) 63455 52412 REP & MAINT - PUMPING EQP 7,051 6,159 6,673 16$ 6,628$ (2.7%) 7,200 - (7,200) (100.0%) 63455 52413 REP & MAINT - MAINS 6,404 3,678 12,745 14,947$ 7,609$ 41.1% 30,000 - (30,000) (100.0%) 63455 52414 REP & MAINT - HYDRANTS 66 1,498 180 -$ 581$ 65.6% 15,000 - (15,000) (100.0%) 63455 52415 REPAIR & MAINT - SERVICES 123,341 49,151 58,919 17,231$ 77,137$ (30.9%) 40,000 110,000 70,000 175.0% 63455 52416 REP & MAINT - METER INSTA 155 2,886 2,805 -$ 1,949$ 325.6% 3,000 - (3,000) (100.0%) WANNACOMET WATER ENTERPRISE FUND OPERATIONS BUDGET FY2020 BUDGET PROJECTION 3-YEAR ACTUAL DEPT ACCOUNT ACCOUNT NAME FY2016 ACTUAL FY2017 ACTUAL FY2018 ACTUAL FY2019 ACTUAL YTD SIMPLE AVERAGE COMPOUND ANNUAL GROWTH RATE FY2019 BUDGET FY2020 BUDGET $ INC/(DEC) FY20/FY19 % INC/(DEC) FY20/FY19 63455 52417 REPAIR & MAINT PUMP STRUCTURE 169 56 - -$ 75$ (100.0%) 5,000 - (5,000) (100.0%) 63455 52418 REPAIR & MAINT-STANDPIPE - - - -$ -$ na 5,000 - (5,000) (100.0%) 63455 52419 MAINTENANCE TO METERS - - - -$ -$ na 2,000 - (2,000) (100.0%) 63455 52423 REPAIR & MAINTENANCE SCADA - - 9,720 -$ 3,240$ na 7,500 - (7,500) (100.0%) 63455 52703 RENT / LSE: POSTAGE METER 1,526 1,526 1,542 387$ 1,531$ 0.5% 1,600 1,600 - - 63455 52907 LANDFILL & WASTE WATR FEE 2,300 307 376 -$ 994$ (59.6%) 2,500 2,500 - - 63455 52908 PROPERTY:EQUIP RENTAL - - - -$ -$ na - - - na 63455 53100 PROFESSIONAL SERVICES 30,938 44,032 46,197 8,469$ 40,389$ 22.2% 155,000 250,000 95,000 61.3% 63455 53101 GENERAL:ACCOUNTNG & AUDIT 11,000 12,800 18,000 -$ 13,933$ 27.9% 24,500 24,500 - - 63455 53102 GENERAL:LEGAL SERVICES 4,500 4,342 882 -$ 3,241$ (55.7%) 10,000 10,000 - - 63455 53103 GENERAL:ADVERTISING 5,698 6,140 3,442 595$ 5,094$ (22.3%) 7,500 7,500 - - 63455 53105 GENERAL: EXP. PUBLIC INFO 3,234 4,320 2,490 2,439$ 3,348$ (12.3%) 10,000 5,000 (5,000) (50.0%) 63455 53106 GENERAL:CUSTODIAL 9,164 9,280 8,125 -$ 8,856$ (5.8%) 12,000 12,000 - - 63455 53107 PROF SVCS - WATER ANALYSI 21,993 13,386 20,685 2,620$ 18,688$ (3.0%) 23,000 26,000 3,000 13.0% 63455 53108 OUTSOURCE BILLING 14,084 12,617 15,125 2,301$ 13,942$ 3.6% 15,000 15,000 - - 63455 53110 GENERAL:PRINTING 2,594 1,551 1,248 -$ 1,797$ (30.7%) 2,500 2,500 - - 63455 53401 COMM:TELEPHONE 8,939 7,974 7,457 1,686$ 8,123$ (8.7%) 12,000 12,000 - - 63455 53402 COMM:POSTAGE 26,650 27,828 27,676 4,096$ 27,385$ 1.9% 30,000 30,000 - - 63455 53803 OTHER:LICENSES & TAXES 5,472 5,258 6,337 -$ 5,689$ 7.6% 6,000 6,000 - - 63455 53804 OTHER:FREIGHT 1,241 3,000 2,215 683$ 2,152$ 33.6% 2,000 2,000 - - 63455 54101 ENERGY:GAS & DIESEL 10,504 9,761 10,982 1,780$ 10,416$ 2.3% 15,000 15,000 - - 63455 54201 OFFICE SUPPLIES 5,594 6,773 3,878 694$ 5,415$ (16.7%) 7,500 7,500 - - 63455 54301 TOOLS & EQUIPMENT 5,318 4,406 3,730 1,885$ 4,485$ (16.3%) 6,000 6,000 - - 63455 54302 MISC MATERIALS & SUPPLIES 2,245 1,729 2,291 49$ 2,088$ 1.0% 3,500 3,500 - - 63455 54303 INVENTORY 251,952 224,151 223,323 50,042$ 233,142$ (5.9%) 200,000 360,000 160,000 80.0% 63455 54306 PUMP MATERIALS AND SUPPLIES 473 1,367 - -$ 613$ (100.0%) - - - na 63455 54308 ENGINEERING:SUPPLIES & MATERIA 6,877 8,295 5,259 2,527$ 6,810$ (12.6%) 10,000 15,000 5,000 50.0% 63455 54501 CUSTODIAL:CLEANING SUPPLY - - - -$ -$ na - - - na 63455 54701 SAFETY:UNIFORMS 2,220 2,474 4,503 1,059$ 3,066$ 42.4% 3,500 6,500 3,000 85.7% 63455 54702 SAFETY:MATERIALS - - - -$ -$ na - - - na 63455 55101 BOOKS/SUBSCRIPTIONS 683 803 883 299$ 790$ 13.7% 2,500 1,000 (1,500) (60.0%) 63455 57101 IN-STATE:MISC TRAVEL 21,391 42,712 33,815 1,485$ 32,639$ 25.7% 45,000 20,000 (25,000) (55.6%) 63455 57102 IN-STATE:MILEAGE/CAR ALLW 351 83 72 -$ 169$ (54.7%) - - - na 63455 57103 IN-STATE:SEMINARS,PROF GA 1,910 965 2,721 -$ 1,865$ 19.3% 10,000 5,000 (5,000) (50.0%) 63455 57201 OUT-STATE:GENERAL 5,587 2,078 - -$ 2,555$ (100.0%) 5,000 5,000 - - 63455 57301 DUES:PROFESSNL ORGANIZATN 3,495 3,679 2,929 -$ 3,367$ (8.5%) 2,500 5,000 2,500 100.0% 63455 57401 INS PREM:AUTO & LIABILITY 20,685 7,157 6,728 -$ 11,523$ (43.0%) 24,000 26,400 2,400 10.0% 63455 57404 INS PREM:BLANKET INS,BLDG 62,131 38,111 46,006 -$ 48,750$ (13.9%) 85,000 93,500 8,500 10.0% 63455 57406 INS PREM:CLAIM DEDUCTIBLE - 732 2,173 -$ 968$ na 2,500 1,000 (1,500) (60.0%) 63455 57802 OTHER:SCHOOLS MISC - - - -$ -$ na - - - na 63455 58501 ADD EQ:NEW EQUIP 4,039 7,056 43,602 -$ 18,232$ 228.5% 55,000 70,000 15,000 27.3% 63455 58502 ADD EQ:OFFICE FURNITURE 351 1,125 - -$ 492$ (100.0%) 12,500 5,000 (7,500) (60.0%) 63455 58701 REPLACEMENT EQ:GENERAL - 1,482 - -$ 494$ na 3,000 1,500 (1,500) (50.0%) 63455 58702 WATER COMMISSION RESERVE FUND 78,624 32,663 23,125 -$ 44,804$ (45.8%) 236,447 300,557 64,110 27.1% 63455 58904 CAP PROJ:PURCHASES - - - -$ -$ na - - - na 63455 59101 DEBT SERV:PRINCIPAL 1,598,000 1,615,800 1,703,235 311,000$ 1,639,012$ 3.2% 1,739,090 1,731,000 (8,090) (0.5%) 63455 59102 DEBT SERVICE INTEREST 649,187 629,633 680,539 81,003$ 653,119$ 2.4% 609,530 685,267 75,737 12.4% WANNACOMET WATER ENTERPRISE FUND OPERATIONS BUDGET FY2020 BUDGET PROJECTION 3-YEAR ACTUAL DEPT ACCOUNT ACCOUNT NAME FY2016 ACTUAL FY2017 ACTUAL FY2018 ACTUAL FY2019 ACTUAL YTD SIMPLE AVERAGE COMPOUND ANNUAL GROWTH RATE FY2019 BUDGET FY2020 BUDGET $ INC/(DEC) FY20/FY19 % INC/(DEC) FY20/FY19 63455 59103 ISSUE EXPENSE - - - -$ -$ na - - - na 63455 59250 INTEREST: GENERAL - - - -$ -$ na 8,000 - (8,000) (100.0%) 63455 59501 OTHER FIN:GENERAL - - - -$ -$ na - - - na 63455 59502 INDIRECT COSTS - 93,000 93,000 -$ 62,000$ na 93,000 93,000 - - 63455 59991 TRANSFER TO GF (INDIRECT COSTS)93,000 - - -$ 31,000$ (100.0%) - - - na SUBTOTAL OPERATIONS EXPENSES 3,365,153 3,207,983 3,367,013 564,292 3,313,383 0.0% 3,924,267 4,264,724 340,457 8.7% WANNACOMET WATER ENTERPRISE FUND GRAND TOTAL TOTAL REVENUE (5,764,646)$ (6,466,177)$ (6,250,469)$ (1,592,524)$ (6,160,431)$ 4.1% (5,708,310)$ (5,947,000)$ (238,690)$ 4.2% TOTAL EXPENSE 4,834,962$ 4,842,682$ 4,992,693$ 1,089,244$ 4,890,112$ 1.6% 5,768,678$ 6,171,997$ 403,319$ 7.0% VARIANCE (929,684)$ (1,623,495)$ (1,257,776)$ (503,280)$ (1,270,318)$ 16.3% 60,368$ 224,997$ 164,629$ 272.7% USE OF RETAINED EARNINGS* BUDGET BALANCE FY2019 Personnel Spreadsheet Number of Positions in Department Full-time 13 Part-time 0 Seasonal 0 Temporary 0 Vacancies 0 New Positions Requested 0 TOTAL OF ALL POSITIONS 13 Name, Position Job Code Avg Hours Per Week Class & Step as of 6/30/18 (e.g., B -Step 3) Yearly Salary as of 6/30/18 53 Week Adjustment FY2020 Increase Date Prorated FY2020 Salary Longevity Pay Education Pay Certification Pay Holiday Pay Other Total by Employee WILLETT, M. - DIRECTOR WW01 40.00 N/A 134,415 134,777 07/01/19 159,048 7,952 0 0 0 19,500 186,500 PYKOSZ, C. - OPERATIONS MGR WW23 40.00 N/A 122,221 122,550 07/01/19 125,655 6,300 0 0 0 0 131,955 HOLDGATE, H. - DEPUTY DIRECTOR WW24 40.00 N/A 122,221 122,550 07/01/19 125,655 6,300 0 0 0 0 131,955 ROBERTS, L. - CUSTOMER SVC SUPV WW15 40.00 N/A 85,046 85,275 07/01/19 87,412 4,375 0 0 0 0 91,787 ALLEN, D. - ASST. BUSINESS MGR WW24 40.00 N/A 85,216 85,446 07/01/19 87,412 0 0 0 0 0 87,412 MANSFIELD, A. - ADMIN ASST.WW07 40.00 N/A 85,051 85,280 07/01/19 87,412 3,500 0 0 0 0 90,912 VOLLANS, J. - UTILITYMAN WW35 40.00 UT 1 63,794 63,965 07/01/19 73,465 0 0 0 0 73,465 WEST, R. - ENGINEER WW35 40.00 N/A 85,051 85,280 07/01/19 93,600 2,808 0 0 0 0 96,408 EARLE, R. - UTILITYMAN WW60 40.00 UT 1 67,389 67,571 07/01/19 67,390 3,200 0 0 0 0 70,590 JOHNSEN, J. - UTILITYMAN WW60 40.00 UT 1 79,539 79,753 07/13/19 79,540 4,000 0 0 0 0 83,540 ROBERTS, K. - UTILITYMAN WW50 40.00 UT 1 67,389 67,571 07/01/19 67,390 2,400 0 0 0 0 69,790 PERRY, M. - UTILITYMAN WW50 40.00 UT 1 63,794 63,965 07/01/19 79,540 0 0 0 0 79,540 FERGUSON, C. - CUSTOMER SVC REP WW25 40.00 N/A 52,000 52,140 07/01/19 53,300 0 0 0 0 53,300 1,247,154 Total Prorated Salary (enter on Munis 51100)1,186,819 25,000 20,000 5,000 10,000 40,835 1,287,654 17,900 2,271 2,000 19,500 302,000 285,180 1,916,505 Total Compensation/Unemployment (enter on MUNIS 51960) Wannacomet Water Enterprise Fund ORG: 63455 Total On-Call Pay Total Merit Pay Total Salary Temporary Overtime (enter on Munis 51300) Total Longevity (enter on Munis 51700) Salary Subtotal Medicare (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 PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL Issue Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments Purpose Date FY2017 FY2018 FY2019 FY2020 FY2021 FY2022 FY2023 FY2024 FY2025 FY2026 WANNACOMET WATER ENTERPRISE TOTAL DEBT 19,462,200.00 17,846,400.00 16,171,400.00 14,433,400.00 12,702,400.00 10,907,400.00 9,264,400.00 7,632,400.00 5,983,400.00 4,317,400.00 REHAB GARAGE & MAINTENANCE FACILITY 2/15/2008 40,000.00 40,000.00 SOURCE WELL & PUMP 2/15/2008 65,000.00 65,000.00 WATER STORAGE TANK (ORIG)2/15/2008 250,000.00 250,000.00 WATER MAINS 2/15/2008 65,000.00 65,000.00 WATER SYSTEM DISTRIBUTION 2/15/2008 50,000.00 50,000.00 WATER MAINS 2 2/15/2008 5,000.00 5,000.00 WATER STORAGE TANK (SUPP)3/15/2009 125,000.00 130,000.00 130,000.00 SYSTEMS IMPROVEMENT / METER BATTERIES 2/15/2010 140,000.00 135,000.00 135,000.00 50,000.00 50,000.00 50,000.00 50,000.00 50,000.00 50,000.00 50,000.00 WWCO CURRENT REFUNDING 05/2001 6/7/2012 50,000.00 50,000.00 50,000.00 50,000.00 50,000.00 --- MADKET MAIN 1 6/7/2012 60,000.00 60,000.00 60,000.00 60,000.00 60,000.00 60,000.00 60,000.00 60,000.00 60,000.00 60,000.00 MADAKET MAIN 2 6/7/2012 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 WASHING POND TANK REHAB 6/7/2012 95,000.00 95,000.00 95,000.00 95,000.00 90,000.00 --- ADMINISTRATION BUILDING 6/7/2012 60,000.00 60,000.00 60,000.00 60,000.00 60,000.00 60,000.00 60,000.00 60,000.00 60,000.00 60,000.00 METER UPGRADES 6/7/2012 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 -- ADV REF 10/01/2004 (LAND)3/5/2013 156,000.00 153,000.00 149,000.00 149,000.00 145,000.00 147,000.00 147,000.00 145,000.00 145,000.00 ADV REF 10/01/2004 (WATER 2)3/5/2013 26,000.00 26,000.00 25,000.00 25,000.00 25,000.00 24,000.00 24,000.00 24,000.00 24,000.00 ADV REF 10/01/2004 (WATER 1)3/5/2013 26,000.00 26,000.00 25,000.00 25,000.00 25,000.00 24,000.00 24,000.00 24,000.00 24,000.00 ADV REF 11/15/2005 WATER 1 2/5/2015 162,800.00 145,000.00 160,000.00 150,000.00 190,000.00 170,000.00 185,000.00 195,000.00 200,000.00 197,000.00 ADV REF 11/15/2005 WATER 3 2/5/2015 24,800.00 25,000.00 25,000.00 30,000.00 30,000.00 30,000.00 35,000.00 35,000.00 30,000.00 30,000.00 ADV REF 11/2005 GARAGE AND MAINT 2/5/2015 50,200.00 45,000.00 50,000.00 50,000.00 55,000.00 55,000.00 55,000.00 55,000.00 60,000.00 57,000.00 776 WATER DISTRIBUTION 10/22/2015 41,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 785 WATER DISTRIBUTION 10/22/2015 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 Refi WWCO Admin 08 750K July'16 8/3/2016 38,000.00 38,000.00 38,000.00 37,000.00 37,000.00 37,000.00 37,000.00 32,000.00 Refi WWCO Well 08 1.3M July '16 8/3/2016 62,000.00 62,000.00 62,000.00 62,000.00 62,000.00 61,000.00 61,000.00 61,000.00 Refi WWCO Tank 08 5M July '16 8/3/2016 238,000.00 238,000.00 237,000.00 237,000.00 236,000.00 236,000.00 235,000.00 234,000.00 Refi WWCO Main 08 1.25M July'16 8/3/2016 57,000.00 57,000.00 57,000.00 57,000.00 57,000.00 57,000.00 56,000.00 56,000.00 Refi WWCO DistImp 08 1M Jul'16 8/3/2016 48,000.00 48,000.00 48,000.00 47,000.00 47,000.00 47,000.00 47,000.00 47,000.00 Refi WWCO Mains2 08 100K Jul'16 8/3/2016 5,000.00 5,000.00 5,000.00 5,000.00 5,000.00 5,000.00 5,000.00 5,000.00 Refi WWCO Tank 09 2.815M Jul'16 8/3/2016 4,000.00 133,000.00 138,000.00 143,000.00 148,000.00 158,000.00 162,000.00 172,000.00 WYERS VALLEY WELLS NOV '16 11/9/2016 90,000.00 90,000.00 90,000.00 90,000.00 90,000.00 90,000.00 90,000.00 90,000.00 90,000.00 WATER MAINS 11/29/2017 76,000.00 75,000.00 75,000.00 75,000.00 75,000.00 70,000.00 70,000.00 70,000.00 WWCO ADMIN BLDG NOV'18 81,000.00 105,000.00 110,000.00 115,000.00 120,000.00 130,000.00 135,000.00 TOTAL WANNACOMET DEBT 1,615,800.00 1,675,000.00 1,738,000.00 1,731,000.00 1,795,000.00 1,643,000.00 1,632,000.00 1,649,000.00 1,666,000.00 1,476,000.00 INTEREST INTEREST INTEREST INTEREST INTEREST INTEREST INTEREST INTEREST INTEREST INTEREST Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments WANNACOMET WATER ENTERPRISE FY2017 FY2018 FY2019 FY2020 FY2021 FY2022 FY2023 FY2024 FY2025 FY2026 REHAB GARAGE & MAINTENANCE FACILITY 2/15/2008 2,700.00 1,400.00 SOURCE WELL & PUMP 2/15/2008 4,387.50 2,275.00 WATER STORAGE TANK (ORIG)2/15/2008 16,875.00 8,750.00 WATER MAINS 2/15/2008 4,387.50 2,275.00 WATER SYSTEM DISTRIBUTION 2/15/2008 3,375.00 1,750.00 WATER MAINS 2 2/15/2008 337.50 175.00 WATER STORAGE TANK (SUPP)3/15/2009 14,800.00 11,050.00 6,500.00 SYSTEMS IMPROVEMENT / METER BATTERIES 2/15/2010 36,775.00 31,175.00 25,775.00 20,375.00 18,875.00 16,875.00 15,375.00 13,375.00 11,750.00 9,750.00 CURRENT REFUNDING 05/2001 6/7/2012 10,750.00 8,250.00 5,750.00 3,500.00 1,250.00 MADKET MAIN 1 6/7/2012 38,100.00 35,100.00 32,100.00 29,400.00 26,700.00 23,700.00 20,700.00 17,700.00 14,700.00 12,300.00 MADAKET MAIN 2 6/7/2012 25,400.00 23,400.00 21,400.00 19,600.00 17,800.00 15,800.00 13,800.00 11,800.00 9,800.00 8,200.00 WASHING POND (NEW ST.) TANK REHAB 6/7/2012 20,175.00 15,425.00 10,675.00 6,400.00 2,250.00 ADMINISTRATION BUILDING 6/7/2012 38,100.00 35,100.00 32,100.00 29,400.00 26,700.00 23,700.00 20,700.00 17,700.00 14,700.00 12,300.00 METER UPGRADES 6/7/2012 10,600.00 8,600.00 6,600.00 4,800.00 3,000.00 1,000.00 ADV REF 10/01/2004 (LAND)3/5/2013 36,110.00 32,622.50 29,240.00 25,887.50 21,870.00 16,765.00 12,355.00 7,250.00 2,175.00 ADV REF 10/01/2004 (WATER 2)3/5/2013 6,025.00 5,440.00 4,870.00 4,307.50 3,620.00 2,760.00 2,040.00 1,200.00 360.00 ADV REF 10/01/2004 (WATER 1)3/5/2013 6,025.00 5,440.00 4,870.00 4,307.50 3,620.00 2,760.00 2,040.00 1,200.00 360.00 ADV REF 11/15/2005 WATER 1 2/5/2015 42,938.00 39,860.00 36,810.00 33,710.00 30,310.00 25,860.00 20,535.00 14,835.00 8,910.00 2,955.00 ADV REF 11/15/2005 WATER 3 2/5/2015 7,248.00 6,750.00 6,250.00 5,700.00 5,100.00 4,350.00 3,375.00 2,325.00 1,350.00 450.00 ADV REF 11/2005 GARAGE AND MAINT 2/5/2015 12,962.00 12,010.00 11,060.00 10,060.00 9,010.00 7,635.00 5,985.00 4,335.00 2,610.00 855.00 776 WATER DISTRIBUTION 10/22/2015 31,927.61 20,150.00 18,950.00 17,750.00 16,750.00 15,950.00 14,950.00 13,750.00 12,550.00 11,350.00 785 WATER DISTRIBUTION 10/22/2015 32,342.36 20,450.00 19,250.00 18,050.00 17,050.00 16,250.00 15,250.00 14,050.00 12,850.00 11,650.00 Refi WWCO Admin 08 750K July'16 8/3/2016 11,287.47 13,024.00 12,264.00 10,744.00 9,224.00 7,724.00 6,244.00 4,764.00 3,284.00 1,904.00 Refi WWCO Well 08 1.3M July '16 8/3/2016 20,184.67 23,290.00 22,050.00 19,570.00 17,090.00 14,610.00 12,130.00 9,670.00 7,230.00 4,790.00 Refi WWCO Tank 08 5M July '16 8/3/2016 77,560.60 89,493.00 84,733.00 75,213.00 65,713.00 56,233.00 46,773.00 37,333.00 27,913.00 18,533.00 Refi WWCO Main 08 1.25M July'16 8/3/2016 18,622.07 21,487.00 20,347.00 18,067.00 15,787.00 13,507.00 11,227.00 8,947.00 6,687.00 4,447.00 Refi WWCO DistImp 08 1M Jul'16 8/3/2016 15,522.00 17,910.00 16,950.00 15,030.00 13,110.00 11,210.00 9,330.00 7,450.00 5,570.00 3,690.00 Refi WWCO Mains2 08 100K Jul'16 8/3/2016 1,577.33 1,820.00 1,720.00 1,520.00 1,320.00 1,120.00 920.00 720.00 520.00 320.00 Refi WWCO Tank 09 2.815M Jul'16 8/3/2016 49,073.87 56,556.00 56,556.00 53,896.00 48,476.00 42,856.00 37,036.00 30,916.00 24,516.00 17,836.00 WYERS VALLEY WELLS NOV '16 11/9/2016 89,983.33 58,800.00 56,100.00 53,400.00 50,250.00 45,750.00 41,250.00 36,750.00 32,250.00 WATER MAINS 11/29/2017 63,905.83 52,675.00 48,925.00 45,175.00 41,425.00 37,800.00 34,300.00 30,800.00 WWCO ADMIN BLDG NOV'18 149,204.17 122,950.00 117,575.00 113,100.00 108,375.00 102,125.00 95,500.00 TOTAL WANNACOMET DEBT 596,168.48 641,010.83 609,525.83 685,266.67 599,900.00 533,665.00 471,040.00 406,745.00 341,010.00 279,880.00