Loading...
Section XII. Enterprise Funds - Wannacomet WaterTown and County of Nantucket 16 Broad Street Nantucket, MA 02554 FY2017 BUDGET PROJECTION •ENTERPRISE FUNDS •WANNACOMET WATER FY 2017 Budget Wannacomet Enterprise Fund FY 2016 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: Increase the delivery reliability and water quality protection of the Wyer’s valley Water Supply Update System Maintenance Program to utilize new technology Design fire hydrant modernization program Upgrade Utility Billing and Customer Service software Develop consolidation plan for the Nantucket and Siasconset Water Commissions and enterprise funds •Initiatives and Accomplishments: Utility Billing and Customer service upgrade completed Fiber optic cable installed at 1 Milestone Road First of three phases of hydrant modernization program will be completed by June 1, 2016 Completed 10 year capital program addressing major components of Wannacomet’s assets Nantucket and Siasconset Water Commissions agree to consider consolidation plan Wannacomet Enterprise Fund FY 2017 Wannacomet Enterprise Fund Overview •Priorities: Implementation of revised maintenance program with focus on Distribution Bring the new Wyer’s Valley wells on line Undertake a comprehensive organizational review Complete Phase two of hydrant modernization program Begin construction of new Administration Building Reduction of unaccounted for water Complete and secure renewal of Water Management Act Permit •Significant Changes Year-to-Year (FY 2014 to FY 2015) Increased Debt Service Metered Water rate, Service Charge and Connection fees are increased Anticipated Retirement of the General Manager •Key Issues Regulatory Requirements Future water demand projections and Source Management Wannacomet Enterprise Fund FY2017 Budget Wannacomet Enterprise Fund SUMMARY FY2013 ACTUAL FY2014 ACTUAL FY2015 ACTUAL COMPOUND ANNUAL GROWTH RATE FY 2016 BUDGET FY 2017 WANNACOMET MANAGER RECOMMENDATION FY 2017 INCREASE OR (DECREASE) $ FY 2017 INCREASE OR (DECREASE) % Payroll-Salary $ 1,021,853 $ 1,039,002 $ 1,079,925 2.8% $ 1,094,150 $ 1,137,990 $ 43,840 4.0% Medicare P/R Tax Expenses $ 14,557 $ 14,773 $ 15,376 2.8% $ 15,500 $ 16,100 $ 600 3.9% Medical Insurance $ 152,982 $ 182,158 $ 184,636 9.9% $ 249,099 $ 280,450 $ 31,351 12.6% Barnstable County Retirement $ 191,183 $ 196,296 $ 204,649 3.5% $ 210,015 $ 219,466 $ 9,451 4.5% Utilities $ 146,373 $ 145,259 $ 160,802 4.8% $ 174,000 $ 198,400 $ 24,400 14.0% Repairs & Maintenance $ 177,359 $ 145,869 $ 188,096 3.0% $ 171,500 $ 309,500 $ 138,000 80.5% Professional Services $ 85,292 $ 118,300 $ 60,143 -16.0% $ 71,500 $ 67,500 $ (4,000) -5.6% Debt Service $ 2,383,250 $ 2,370,374 $ 2,310,123 -1.5% $ 2,692,018 $ 2,592,953 $ (99,065) -3.7% General Insurance $ 74,975 $ 76,902 $ 80,550 3.7% $ 83,685 $ 89,000 $ 5,315 6.4% Other Supplies $ 24,051 $ 19,978 $ 18,286 -12.8% $ 22,500 $ 21,500 $ (1,000) -4.4% Inventory $ 81,381 $ 82,978 $ 132,269 27.5% $ 110,000 $ 150,000 $ 40,000 36.4% Travel $ 27,767 $ 32,620 $ 42,994 24.4% $ 37,500 $ 47,500 $ 10,000 26.7% Water Analysis $ 30,340 $ 21,069 $ 16,749 -25.7% $ 21,000 $ 23,000 $ 2,000 9.5% Other $ 163,439 $ 251,135 $ 177,994 4.4% $ 271,641 $ 381,897 $ 110,256 40.6% TOTAL WANNACOMET $ 4,574,801 $ 4,696,713 $ 4,672,592 1.1% $ 5,224,108 $ 5,535,256 $ 311,148 5.96% Appendix Wannacomet Enterprise Fund Town & County of Nantucket Organization Chart – Wannacomet Enterprise Fund Robert L. Gardner General Manager Heidi Holdgate Business Manager Christopher R. Pykosz Operations Manager Linda Roberts Project Coordinator Andrea Mansfield Administrative Assistant Mark Willett Engineering Manager Jeffrey Johnsen Utility man Rob West Engineering Technician Vacant Position Utility man Robert Earle Utility man Kyle Roberts Utility man Noreen Slavitz Nantucket Water Commission Allen Reinhard Nantucket Water Commission Nelson K. Eldridge Nantucket Water Commission FY 2017 Budget Detail Wannacomet Enterprise Fund TOWN OF NANTUCKET WANNACOMET WATER - ENTERPRISE FUND Actual BUDGET PROJECTED BUDGET FY2015 FY2016 FY2017 REVENUE 5,066,439 5,224,108 5,535,256 EXPENSES 4,672,592 5,224,108 5,535,256 NET EARNINGS 393,847 - 0 Transfer from Retained Earnings - - - NET EARNINGS 393,847 - 0 NET SOURCES/USES: GF Free Cash Subsidy - - - FinCom GF Reserve Fund Transfer Ending FB 393,847 - 0 TOTAL Certified Retained Earnings as of July 1, 2015 2,046,305 Page 2 WANNACOMET WATER DEPT ACCOUNT ACCOUNT NAME FY2013 ACTUAL FY2014 ACTUAL FY2015 ACTUAL COMPOUND ANNUAL GROWTH RATE FY 2016 BUDGET FY 2017 WANNACOMET MANAGER RECOMMENDATION FY 2017 INCREASE OR (DECREASE) $ FY 2017 INCREASE OR (DECREASE) %63455 42110 WATER USE FEE (3,582,268)$ (3,964,934)$ (4,353,145)$ 10.2%(4,599,783)$ (4,823,406)$ 223,623$ 4.9% 63455 42111 WATER CONNECTION FEE (351,349)$ (521,946)$ (442,559)$ 12.2%(330,000)$ (375,000)$ 45,000$ 13.6%63455 42115 CROSS CONNECTION DEVICE TEST FEE -$ -$ -$ 0.0%(15,000)$ (55,000)$ 40,000$ 266.7%63455 42441 LATE PAYMENT SERVICE FEE (14,988)$ (60,155)$ (31,849)$ 45.8%(34,800)$ (34,800)$ -$ 0.0%63455 43606 RENTAL INCOME (18,700)$ (18,650)$ (18,600)$ -0.3%(18,650)$ (18,650)$ -$ 0.0% 63455 48201 INTEREST ON INVESTMENTS (13,933)$ (10,273)$ (4,686)$ -42.0%(10,275)$ (4,700)$ (5,575)$ -54.3%63455 48400 CONTRACT SERVICES - SEWER (103,177)$ (112,124)$ (115,198)$ 5.7%(105,000)$ (105,000)$ -$ 0.0%63455 48401 REVENUE - OUTSIDE BILLING (2,689)$ (4,800)$ (6,498)$ 55.5%(4,800)$ (4,800)$ -$ 0.0% 63455 48416 CONTRACT SERVICES - SIAS WATER (70,000)$ (52,500)$ (60,000)$ -7.4%(80,000)$ (88,000)$ 8,000$ 10.0%63455 48417 TRANSFER FEE (25,345)$ (29,632)$ (32,016)$ 12.4%(24,000)$ (24,000)$ -$ 0.0%63455 49102 PROCEEDS FROM BOND SALE -$ -$ -$ 0.0%-$ -$ -$ 0.0% 63455 49104 PREMIUM REVENUE ON DEBT (18,527)$ (1,777)$ (1,889)$ -68.1%(1,800)$ (1,900)$ 100$ 0.0%63455 49701 TRANSFER FROM GENERAL FUND -$ -$ -$ 0.0%-$ -$ -$ 0.0%63455 51100 SALARY - OUTSIDE BILLING 1,248$ 30,084$ 29,834$ 389.0%45,000$ 1,072,490$ 1,027,490$ 2283.3% 63455 51101 SALARY - ADMIN/GENERAL 244,574$ 241,823$ 261,307$ 3.4%256,724$ -$ (256,724)$ -100.0%63455 51102 SALARY - OPS/ENG 278,645$ 274,178$ 281,114$ 0.4%292,023$ -$ (292,023)$ -100.0%63455 51103 SALARY - PUMPING LABOR 26,858$ -$ -$ -100.0%-$ -$ -$ 0.0% 63455 51105 SALARY - SOURCE OF SUPPLY -$ -$ -$ 0.0%-$ -$ -$ 0.0%63455 51106 SALARY - DISTRIBUTION 203,559$ 217,674$ 215,459$ 2.9%282,490$ -$ (282,490)$ -100.0%63455 51107 SALARY - MISC METER LABOR 60,618$ 66,525$ 69,215$ 6.9%-$ -$ -$ 0.0% 63455 51108 SALARY - METER READ LABOR 2,540$ -$ -$ -100.0%-$ -$ -$ 0.0%63455 51117 SALARY - BILL & ACCT WATE 144,973$ 141,661$ 146,797$ 0.6%150,163$ -$ (150,163)$ -100.0%63455 51118 SALARY - BILL & ACCT SEWE 2,696$ -$ -$ -100.0%-$ -$ -$ 0.0% 63455 51119 SALARY-A & G SCONSET WATER -$ -$ -$ 0.0%-$ -$ -$ 0.0%63455 51200 SALARY, TEMPORARY -$ -$ -$ 0.0%2,500$ 2,500$ -$ 0.0%63455 51300 OVERTIME 1,276$ 9,911$ 14,385$ 235.8%3,000$ 3,000$ -$ 0.0% 63455 51700 LONGEVITY PAY 36,929$ 36,981$ 42,569$ 7.4%34,600$ 32,100$ (2,500)$ -7.2%63455 51701 INS PREM:MEDICAL BLUE CROSS 152,982$ 182,158$ 184,636$ 9.9%249,099$ 280,450$ 31,351$ 12.6%63455 51705 MEDICARE/MEDEX/RETIREES -$ -$ -$ 0.0%-$ -$ -$ 0.0%63455 51770 BARNSTABLE COUNTY RETIREMT FND 191,183$ 196,296$ 204,649$ 3.5%210,015$ 219,466$ 9,451$ 4.5% 63455 51960 COMPENSATION/UNEMPLOYMENT -$ 1,810$ 1,471$ 100.0%8,400$ 8,400$ -$ 0.0%63455 51961 MEDICARE P/R TAX 14,557$ 14,773$ 15,376$ 2.8%15,500$ 16,100$ 600$ 3.9%63455 51962 DEF COMP EMPLOYER CONTRIBUTION 16,547$ 16,951$ 17,773$ 3.6%18,250$ 18,500$ 250$ 1.4% 63455 51963 WORKMANS COMPENSATION 1,392$ 1,402$ -$ -100.0%1,000$ 1,000$ -$ 0.0%63455 52101 UTILITY:ELECTRICITY 26,006$ 8,787$ 9,758$ -38.7%14,000$ 12,000$ (2,000)$ -14.3%63455 52103 UTILITY:FUEL OIL 8,197$ 9,476$ 7,017$ -7.5%8,500$ 8,500$ -$ 0.0% 63455 52104 ELECTRICITY - PUMPING 86,553$ 99,621$ 119,791$ 17.6%125,000$ 145,000$ 20,000$ 16.0%63455 52107 UTILITY: LANDFILL 364$ 364$ -$ -100.0%400$ 400$ -$ 100.0%63455 52401 REP&MAINT:OFFICE EQUIP 34,078$ 45,079$ 48,397$ 19.2%70,000$ 75,000$ 5,000$ 7.1% 63455 52403 REP&MAINT:VEHICLE 8,501$ 5,068$ 11,795$ 17.8%7,000$ 5,000$ (2,000)$ -28.6%63455 52404 REP&MAINT:BUILDING 11,200$ 10,439$ 6,495$ -23.8%7,500$ 88,500$ 81,000$ 1080.0%63455 52405 REP&MAINT:EQUIPMENT 1,841$ 736$ 1,759$ -2.3%2,500$ 2,000$ (500)$ -20.0% 63455 52411 REP&MAINT:GROUNDS 27,046$ 31,967$ 46,697$ 31.4%35,000$ 35,000$ -$ 0.0%63455 52412 REP & MAINT - PUMPING EQP 42,117$ 6,599$ 5,599$ -63.5%8,000$ 8,000$ -$ 0.0%63455 52413 REP & MAINT - MAINS 21,455$ 8,375$ 11,458$ -26.9%10,000$ 10,000$ -$ 0.0% 63455 52414 REP & MAINT - HYDRANTS 1,270$ 143$ 6,805$ 131.5%10,000$ 5,000$ (5,000)$ -50.0%63455 52415 REPAIR & MAINT - SERVICES 6,297$ 5,817$ 47,944$ 175.9%10,000$ 10,000$ -$ 0.0%63455 52416 REP & MAINT - METER INSTA 2,919$ 6,243$ 208$ -73.3%5,000$ 5,000$ -$ 0.0% 63455 52417 REPAIR & MAINT PUMP STRUCTURE 13,258$ 41$ 261$ -86.0%2,500$ 2,500$ -$ 0.0%63455 52418 REPAIR & MAINT-STANDPIPE 421$ -$ -$ -100.0%500$ 60,000$ 59,500$ 11900.0% 63455 52419 MAINTENANCE TO METERS -$ 14,425$ 25$ 100.0%2,000$ 2,000$ -$ 0.0%63455 52423 REPAIR & MAINTENANCE SCADA 6,956$ 10,937$ 654$ -69.3%1,500$ 1,500$ -$ 0.0%63455 52703 RENT / LSE: POSTAGE METER 1,728$ 1,145$ 1,526$ -6.0%1,600$ 1,600$ -$ 100.0% 63455 52907 LANDFILL & WASTE WATR FEE -$ 379$ -$ 0.0%400$ 2,500$ 2,100$ 525.0%63455 52908 PROPERTY:EQUIP RENTAL -$ -$ -$ 0.0%-$ -$ -$ 0.0%63455 53100 PROFESSIONAL SERVICES 32,508$ 73,836$ 20,925$ -19.8%25,000$ 25,000$ -$ 0.0% 63455 53101 GENERAL:ACCOUNTNG & AUDIT 31,000$ 15,200$ 13,500$ -34.0%21,500$ 21,500$ -$ 0.0%63455 53102 GENERAL:LEGAL SERVICES 70$ 8,807$ 5,579$ 792.8%5,000$ 6,000$ 1,000$ 20.0% WANNACOMET WATER ENTERPRISE FUND OPERATIONS BUDGET FISCAL YEAR 20171/6/2016 Page 3 WANNACOMET WATER DEPT ACCOUNT ACCOUNT NAME FY2013 ACTUAL FY2014 ACTUAL FY2015 ACTUAL COMPOUND ANNUAL GROWTH RATE FY 2016 BUDGET FY 2017 WANNACOMET MANAGER RECOMMENDATION FY 2017 INCREASE OR (DECREASE) $ FY 2017 INCREASE OR (DECREASE) %63455 53103 GENERAL:ADVERTISING 1,815$ 3,506$ 3,685$ 42.5%3,500$ 5,000$ 1,500$ 42.9% 63455 53105 GENERAL: EXP. PUBLIC INFO 10,379$ 4,311$ 2,506$ -50.9%4,500$ 6,000$ 1,500$ 33.3%63455 53106 GENERAL:CUSTODIAL 8,400$ 7,950$ 9,573$ 6.8%9,900$ 10,500$ 600$ 6.1%63455 53107 PROF SVCS - WATER ANALYSI 30,340$ 21,069$ 16,749$ -25.7%21,000$ 23,000$ 2,000$ 9.5% 63455 53108 OUTSOURCE BILLING 21,714$ 20,458$ 20,139$ -3.7%20,000$ 15,000$ (5,000)$ -25.0%63455 53110 GENERAL:PRINTING 1,856$ 2,401$ 1,862$ 0.2%2,500$ 2,500$ -$ 0.0%63455 53401 COMM:TELEPHONE 7,151$ 7,668$ 8,315$ 7.8%7,700$ 12,000$ 4,300$ 55.8% 63455 53402 COMM:POSTAGE 25,052$ 27,595$ 30,159$ 9.7%30,000$ 30,000$ -$ 0.0%63455 53803 OTHER:LICENSES & TAXES 6,208$ 5,146$ 5,375$ -7.0%5,500$ 6,000$ 500$ 9.1%63455 53804 OTHER:FREIGHT 3,213$ 1,975$ 1,477$ -32.2%2,000$ 2,000$ -$ 0.0%63455 54101 ENERGY:GAS & DIESEL 18,102$ 18,964$ 15,922$ -6.2%18,000$ 18,000$ -$ 0.0% 63455 54201 OFFICE SUPPLIES 4,701$ 4,914$ 6,556$ 18.1%5,000$ 5,000$ -$ 0.0%63455 54301 TOOLS & EQUIPMENT 777$ 1,612$ 1,921$ 57.3%2,000$ 2,000$ -$ 0.0%63455 54302 MISC MATERIALS & SUPPLIES 4,460$ 5,128$ 2,299$ -28.2%3,500$ 2,500$ (1,000)$ -28.6% 63455 54303 INVENTORY 81,381$ 82,978$ 132,269$ 27.5%110,000$ 150,000$ 40,000$ 36.4%63455 54306 PUMP MATERIALS AND SUPPLIES -$ -$ -$ 0.0%-$ -$ -$ 0.0%63455 54308 ENGINEERING:SUPPLIES & MATERIA 14,108$ 8,325$ 7,510$ -27.0%12,000$ 12,000$ -$ 0.0% 63455 54501 CUSTODIAL:CLEANING SUPPLY 5$ -$ -$ -100.0%-$ -$ -$ 0.0%63455 54701 SAFETY:UNIFORMS 1,411$ 3,889$ 2,885$ 43.0%2,500$ 2,500$ -$ 0.0%63455 54702 SAFETY:MATERIALS 506$ -$ 31$ -75.2%-$ -$ -$ 0.0% 63455 55101 BOOKS/SUBSCRIPTIONS 794$ 1,128$ 748$ -2.9%1,200$ 1,200$ -$ 0.0%63455 57101 IN-STATE:MISC TRAVEL 23,304$ 24,379$ 27,229$ 8.1%25,000$ 35,000$ 10,000$ 40.0%63455 57102 IN-STATE:MILEAGE/CAR ALLW -$ 259$ 292$ 100.0%-$ -$ -$ 0.0% 63455 57103 IN-STATE:SEMINARS,PROF GA 1,550$ 2,170$ -$ -100.0%2,500$ 2,500$ -$ 0.0%63455 57201 OUT-STATE:GENERAL 2,914$ 5,812$ 15,473$ 130.4%10,000$ 10,000$ -$ 0.0%63455 57301 DUES:PROFESSNL ORGANIZATN 2,209$ 2,471$ 2,397$ 4.2%2,500$ 2,500$ -$ 0.0% 63455 57401 INS PREM:AUTO & LIABILITY 18,098$ 19,457$ 21,065$ 7.9%20,685$ 24,000$ 3,315$ 16.0%63455 57404 INS PREM:BLANKET INS,BLDG 56,876$ 57,445$ 58,019$ 1.0%63,000$ 65,000$ 2,000$ 3.2%63455 57406 INS PREM:CLAIM DEDUCTIBLE -$ -$ 1,466$ 100.0%-$ -$ -$ 100.0% 63455 57802 OTHER:SCHOOLS MISC -$ -$ -$ 0.0%-$ -$ -$ 0.0%63455 58501 ADD EQ:NEW EQUIP 1,500$ 810$ 10,901$ 169.6%20,000$ 80,000$ 60,000$ 300.0%63455 58502 ADD EQ:OFFICE FURNITURE 343$ -$ -$ -100.0%1,000$ 2,000$ 1,000$ 100.0% 63455 58701 REPLACEMENT EQ:GENERAL 10,137$ 1,580$ 3,891$ -38.0%3,000$ 3,000$ -$ 0.0%63455 58702 UNALLOCATED EXPENSES 667$ -$ -$ -100.0%88,941$ 126,097$ 37,156$ 100.0%63455 58904 CAP PROJ:PURCHASES -$ -$ -$ 0.0%-$ -$ -$ 0.0%63455 59101 DEBT SERV:PRINCIPAL 1,545,000$ 1,545,000$ 1,560,000$ 0.5%1,773,000$ 1,750,800$ (22,200)$ -1.3% 63455 59102 DEBT SERVICE INTEREST 838,250$ 825,374$ 750,123$ -5.4%919,018$ 842,153$ (76,865)$ -8.4%63455 59103 ISSUE EXPENSE -$ -$ -$ 0.0%-$ -$ -$ 0.0%63455 59250 INTEREST: GENERAL -$ 7,962$ 7,978$ 100.0%-$ 8,000$ 8,000$ 0.0% 63455 59501 OTHER FIN:GENERAL -$ -$ -$ 0.0%-$ -$ -$ 0.0%63455 59991 TRANSFER TO GENERAL FUND (INDIRECT 87,220$ 179,266$ 93,000$ 3.3%93,000$ 93,000$ -$ 0.0%WANNACOMET WATER ENTERPRISE FUND GRAND TOTALTOTAL REVENUE (4,200,976)$ (4,776,791)$ (5,066,439)$ 9.8%(5,224,108)$ (5,535,256)$ 311,148$ 6.0% TOTAL EXPENSE 4,574,801$ 4,696,713$ 4,672,592$ 1.1%5,224,108$ 5,535,256$ 311,148$ 6.0% VARIANCE 373,826$ (80,077)$ (393,847)$ -$ (0)$ 0$ 100.0% USE OF RETAINED EARNINGS*373,826$ -$ -$ -$ BUDGET BALANCE (0)$ (80,077)$ 0$ Certified Retained Earnings: Page 4 WANNACOMET WATER DEPT ACCOUNT ACCOUNT NAME FY2013 ACTUAL FY2014 ACTUAL FY2015 ACTUAL COMPOUND ANNUAL GROWTH RATE FY 2016 BUDGET FY 2017 WANNACOMET MANAGER RECOMMENDATION FY 2017 INCREASE OR (DECREASE) $ FY 2017 INCREASE OR (DECREASE) % SUMMARY FY2013 ACTUAL FY2014 ACTUAL FY2015 ACTUAL COMPOUND ANNUAL GROWTH RATE FY 2016 BUDGET FY 2017 WANNACOMET MANAGER RECOMMENDATION FY 2017 INCREASE OR (DECREASE) $ FY 2017 INCREASE OR (DECREASE) % Payroll-Salary 1,021,853$ 1,039,002$ 1,079,925$ 2.8%1,094,150$ 1,137,990$ 43,840$ 4.0%Medicare P/R Tax Expenses 14,557$ 14,773$ 15,376$ 2.8%15,500$ 16,100$ 600$ 3.9% Medical Insurance 152,982$ 182,158$ 184,636$ 9.9%249,099$ 280,450$ 31,351$ 12.6%Barnstable County Retirement 191,183$ 196,296$ 204,649$ 3.5%210,015$ 219,466$ 9,451$ 4.5%Utilities 146,373$ 145,259$ 160,802$ 4.8%174,000$ 198,400$ 24,400$ 14.0% Repairs & Maintenance 177,359$ 145,869$ 188,096$ 3.0%171,500$ 309,500$ 138,000$ 80.5%Professional Services 85,292$ 118,300$ 60,143$ -16.0%71,500$ 67,500$ (4,000)$ -5.6%Debt Service 2,383,250$ 2,370,374$ 2,310,123$ -1.5%2,692,018$ 2,592,953$ (99,065)$ -3.7% General Insurance 74,975$ 76,902$ 80,550$ 3.7%83,685$ 89,000$ 5,315$ 6.4%Other Supplies 24,051$ 19,978$ 18,286$ -12.8%22,500$ 21,500$ (1,000)$ -4.4%Inventory 81,381$ 82,978$ 132,269$ 27.5%110,000$ 150,000$ 40,000$ 36.4% Travel 27,767$ 32,620$ 42,994$ 24.4%37,500$ 47,500$ 10,000$ 26.7%Water Analysis 30,340$ 21,069$ 16,749$ -25.7%21,000$ 23,000$ 2,000$ 9.5%Other 163,439$ 251,135$ 177,994$ 4.4%271,641$ 381,897$ 110,256$ 40.6% TOTAL WANNACOMET 4,574,801$ 4,696,713$ 4,672,592$ 1.1%5,224,108$ 5,535,256$ 311,148$ 5.96% Town of Nantucket Confidential 1/6/2016 Page 5 Number of Positions in Department Full-time 10 Part-time 0 Seasonal 0 Temporary 0 Vacancies 1 New Positions Requested 0 TOTAL OF ALL POSITIONS 11 Name, Position Job Code Avg Hours Per Week Class & Step as of 6/30/16(e.g., B -Step 3) Yearly Salary as of 6/30/16 53 Week Adjustment FY17 IncreaseDate Prorated FY 2017Salary Longevity Pay Education Pay Certification Pay Holiday Pay Other Total by Employee GARDNER, R. - MANAGER WW01 40.00 N/A 149,752 150,155 07/01/16 152,795 0 0 0 0 18,500 171,295 PYKOSZ, C. - OPERATIONS MGR WW23 40.00 N/A 112,964 113,268 07/01/16 116,700 5,600 0 0 0 0 122,300 HOLDGATE, H. - BUSINESS MGR WW24 40.00 N/A 109,200 109,494 07/01/16 116,677 5,500 0 0 0 0 122,177 ROBERTS, L. - CUSTOMER SVC SUPV WW15 40.00 N/A 74,922 75,124 07/01/16 81,119 3,700 0 0 0 0 84,819 MANSFIELD, A. - ADMIN ASST.WW24 40.00 N/A 75,982 76,187 07/01/16 80,779 2,300 0 0 0 0 83,079 WILLETT, M. - ENGINEER WW35 40.00 N/A 105,082 105,365 07/01/16 108,500 4,200 0 0 0 0 112,700 WEST, R. - ENGINEER WW35 40.00 N/A 78,603 78,815 07/01/16 81,200 2,400 0 0 0 0 83,600 EARLE, R. - UTILITYMAN WW60 40.00 UT 1 70,720 70,910 07/01/16 73,000 2,800 0 0 0 0 75,800 JOHNSEN, J. - UTILITYMAN WW60 40.00 UT 1 70,720 70,910 07/01/16 73,000 3,500 0 0 0 0 76,500 ROBERTS, K. - UTILITYMAN WW50 40.00 UT 1 70,720 70,910 07/01/16 73,000 2,100 0 0 0 0 75,100 Vacancy - Utilityman WW50 40.00 UT 1 70,720 0 0 0 0 70,720 1,027,490 32,100 0 0 0 18,500 1,078,090 Total Prorated Salary (enter on Munis 51100)1,027,49025,00020,0002,5003,000 32,100 1,110,090 16,1008,4001,00018,500280,450219,4661,654,006 Total Compensation/Unemployment (enter on MUNIS 51960) FY 2017 Personnel Spreadsheet Wannacomet Water Enterprise Fund ORG: 63455 Total On-Call PayTotal MeritTotal Salary TemporaryOvertime (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 Original TOTAL TOTAL TOTAL ************************** Issue Principal PRINCIPAL INTEREST P & I Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments Purpose Date Amount 6/30/2015 6/30/2015 6/30/2015 FY2016 FY2017 FY2018 FY2019 FY2020 FY2021 FY2022 FY2023 FY2024 FY2025 FY2026 FY2027 FY2028 WANNACOMET WATER ENTERPRISE TOTAL DEBT 22,569,974 22,345,740 20,072,649 17,901,229 15,776,077 13,791,916 11,820,297 10,058,573 8,362,754 6,701,320 5,083,479 3,709,013 2,654,325 WATER 1 10/1/2004 500,000 0 0 0 WATER 2 10/1/2004 500,000 0 0 0 LAND ACQUISITION 10/1/2004 3,000,000 0 0 0 WATER 1 11/15/2005 3,000,000 150,000 3,750 153,750 153,750 WATER 2 11/15/2005 750,000 90,000 2,250 92,250 92,250 WATER 3 11/15/2005 500,000 25,000 625 25,625 25,625 GARAGE & MAINTENANCE FACILITY 11/15/2005 900,000 45,000 1,125 46,125 46,125 REHAB GARAGE & MAINTENANCE FACILITY 2/15/2008 750,000 470,000 121,513 591,513 58,125 56,875 55,575 54,175 52,725 51,125 49,525 47,925 46,325 44,675 37,975 36,488 SOURCE WELL & PUMP 2/15/2008 1,300,000 845,000 241,334 1,086,334 97,906 95,875 93,783 91,488 89,131 86,531 83,931 81,331 78,731 76,050 73,288 70,525 67,763 WATER STORAGE TANK (ORIG)2/15/2008 5,000,000 3,250,000 928,125 4,178,125 376,563 368,750 360,625 351,875 342,813 332,813 322,813 312,813 302,813 292,500 281,875 271,250 260,625 WATER MAINS 2/15/2008 1,250,000 795,000 223,756 1,018,756 95,869 93,838 91,725 84,450 82,275 79,875 77,475 75,075 72,675 70,200 67,650 65,100 62,550 WATER SYSTEM DISTRIBUTION 2/15/2008 1,000,000 650,000 185,626 835,626 75,313 73,750 72,125 70,375 68,563 66,563 64,563 62,563 60,563 58,500 56,375 54,250 52,125 WATER MAINS 2 2/15/2008 100,000 65,000 18,562 83,562 7,531 7,375 7,213 7,038 6,856 6,656 6,456 6,256 6,056 5,850 5,638 5,425 5,213 WATER STORAGE TANK (SUPP)3/15/2009 2,815,000 2,140,000 744,819 2,884,819 207,951 209,351 210,601 206,051 204,551 204,151 203,551 202,751 206,751 204,951 207,856 205,200 207,325 SYSTEMS IMPROVEMENT / METER BATTERIES 2/15/2010 1,800,000 1,100,000 262,225 1,362,225 182,375 176,775 166,175 160,775 70,375 68,875 66,875 65,375 63,375 61,750 59,750 57,750 56,000 CURRENT REFUNDING 05/2001 6/7/2012 460,000 300,000 42,250 342,250 62,750 60,750 58,250 55,750 53,500 51,250 MADKET MAIN 1 6/7/2012 1,200,000 1,020,000 326,100 1,346,100 100,500 98,100 95,100 92,100 89,400 86,700 83,700 80,700 77,700 74,700 72,300 70,500 68,700 MADAKET MAIN 2 6/7/2012 800,000 680,000 217,400 897,400 67,000 65,400 63,400 61,400 59,600 57,800 55,800 53,800 51,800 49,800 48,200 47,000 45,800 WASHING POND TANK REHAB 6/7/2012 850,000 565,000 78,900 643,900 118,975 115,175 110,425 105,675 101,400 92,250 ADMINISTRATION BUILDING 6/7/2012 1,200,000 1,020,000 326,100 1,346,100 100,500 98,100 95,100 92,100 89,400 86,700 83,700 80,700 77,700 74,700 72,300 70,500 68,700 METER UPGRADES 6/7/2012 400,000 280,000 46,800 326,800 52,200 50,600 48,600 46,600 44,800 43,000 41,000 ADV REF 10/01/2004 (LAND)3/5/2013 1,492,000 1,492,000 224,285 1,716,285 196,010 192,110 185,623 178,240 174,888 166,870 163,765 159,355 152,250 147,175 ADV REF 10/01/2004 (WATER 2)3/5/2013 249,000 249,000 37,298 286,298 32,675 32,025 31,440 29,870 29,308 28,620 26,760 26,040 25,200 24,360 ADV REF 10/01/2004 (WATER 1)3/5/2013 249,000 249,000 37,298 286,298 32,675 32,025 31,440 29,870 29,308 28,620 26,760 26,040 25,200 24,360 ADV REF 11/15/2005 WATER 1 2/5/2015 1,754,800 1,754,800 298,819 2,053,619 42,090 205,738 184,860 196,810 183,710 220,310 195,866 205,535 209,835 208,910 199,955 ADV REF 11/15/2005 WATER 3 2/5/2015 294,800 294,800 49,978 344,778 7,080 32,048 31,750 31,250 35,700 35,100 34,350 38,375 37,325 31,350 30,450 ADV REF 11/2005 GARAGE AND MAINT 2/5/2015 532,200 532,200 89,238 621,438 12,716 63,162 57,010 61,060 60,060 64,010 62,635 60,985 59,335 62,610 57,855 DISTRIBUTION 10/22/2015 785,000 0 0 0 72,342 60,450 59,250 58,050 57,050 56,250 55,250 54,050 52,850 51,650 50,500 49,400 DISTRIBUTION 10/22/2015 776,000 0 0 0 72,928 60,150 58,950 57,750 56,750 55,950 54,950 53,750 52,550 51,350 50,200 49,100 TOTAL WANNACOMET DEBT 18,061,800 4,508,174 22,569,974 2,244,553 2,273,092 2,171,419 2,125,152 1,984,161 1,971,619 1,761,725 1,695,819 1,661,434 1,617,841 1,374,466 1,054,688 993,300 ************************ Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments FY2029 FY2030 FY2031 FY2032 FY2033 FY2034 FY2035 FY2036 FY2037 FY2038 FY2039 FY2040 1,661,025 1,128,650 809,250 549,250 301,875 219,450 144,200 71,050 0 0 0 0 203,775 54,000 52,000 66,863 64,988 63,038 61,013 44,575 43,325 42,025 40,675 66,863 64,988 63,038 61,013 48,300 47,200 46,100 44,950 43,750 37,625 36,575 35,525 0 0 0 0 48,000 46,900 45,800 39,725 38,675 37,625 36,575 35,525 0 0 0 0 532,375 319,400 260,000 247,375 82,425 75,250 73,150 71,050 0 0 0 0