Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Section XII - Enterprise Funds - Sewer
FY2018 BUDGET PROJECTION •ENTERPRISE FUNDS •SEWER Town and County of Nantucket 16 Broad Street Nantucket, MA 02554 FY2018BudgetFY2018 BudgetSewer Enterprise Fund 1 FY2018Sewer Enterprise Fund ReviewWaste Management Mission To protect public health and the environment for our communities by providing high‐quality wastewater‐treatmentservicesinaneffectiveefficientandresponsivemannerwastewater‐treatment services in an effective, efficient, and responsive mannerThe Sewer Department operates and maintains Nantucket’s wastewater conveyance and treatment systems, which consists of 2 Wastewater Treatment Facilities,13 pump stations, and over 60 miles of sewer mains. The Wastewater personnel physically inspect and verify proper operation of each pump station and treatment facility 365 days per year. Other responsibilities include bi‐annual cleaning of the sewer main pipelines using a high‐pressure water cleaning truck and a mechanical rodding truck (some lines are on an increased frequency cleaning schedule), that have root and large grease problems caused by the improper disposal of Fats Oils and Grease. GoalsContinue to meet state mandated discharge limits for treated effluentCreate a professional sewer department Operation and Administration to efficiently serve the residents and guestsComplete the Sea St pumping station upgrade construction to start early 2017Complete design phase and bid the Shimmo/Plus sewer expansion projects Mid 2017 Bid fall 2017 ConstructionRedesign and rebid the Surfside WWTF upgrade project spring 2017gpgpjpgImplement the Comprehensive Wastewater Management Plan (CWMP)Initiatives and AccomplishmentsNewly Created Sewer Department and Sewer Director appointedExtensiveCapitalplanitemizedandpresentedtofinancialCommitteesExtensive Capital plan itemized and presented to financial CommitteesNew department operating in a proactive operating format SEWER ENTERPRISE FUND2 FY2018Sewer Enterprise Fund Overview •Priority:Develop a fiscally attainable budget plan to identify and prioritize critical infrastructure additions, repairs and replacements that are needed to protect the , p ppresidents of Nantucket.•Significant Changes Year‐to‐YearNid d tSDttCtdlt2016NDi titdNew independent Sewer Department Created late 2016. New Director appointed•Key IssuesAn equitable Financing plan for the proposed CWMP‐20 year Capital Plan will be the biggest qg pppy pggissue for the Sewer Enterprise Fund.Design and program repairs for long‐standing maintenance issues.SEWER ENTERPRISE FUND3 FY2018 BudgetSewer Enterprise Fund3-YEAR ACTUAL FY2018 BUDGET $ INC/(DEC) FY18 / FY17 BUDGET % INC/(DEC) FY18 / FY17 BUDGET SUMMARYPayroll-Salary779,824$ 827,022$ 828,415$ 394,670$ 811,754$ 3% 977,370$ 1,150,510$ 173,140$ 18%Cttl Obliti COMPOUND ANNUAL GROWTH RATE FY2015 ACTUAL FY2017 BUDGET SIMPLE AVERAGE FY2017 ACTUALYTD FY2016 ACTUAL FY2014 ACTUAL Contractual Obligations---- - na--- naMedicare P/R Tax Expense11,155 11,973 12,018 5,724 11,7164% 14,20017,589 3,389 24%Medical Insurance169,696 201,108 213,727 104,807 194,84412% 245,278276,127 30,849 13%Barnstable County Retirement141,587 124,806 139,004 149,671 135,132(1%) 130,422145,259 14,837 11%Utilities451,632 576,985 568,046 244,390 532,22112% 612,300639,300 27,0004%Repairs & Maintenance103,140 174,364 111,359 43,745 129,6214% 170,500232,500 62,000 36%Professional Services98,586168,542261,057108,284176,06263% 190,900310,000119,10062%Professional Services98,586168,542261,057108,284176,06263% 190,900310,000119,10062%Sludge Disposal Costs201,468 222,667 222,869 111,543 215,668 5% 230,000230,000 - 0%Sewer Supplies and Chemicals113,032 119,286 113,674 48,009 115,3300% 123,520223,520 100,000 81%General Insurance120,750 123,219 126,496 - 123,4882% 141,510153,270 11,7608%Other Supplies12,503 3,203 6,334 1,356 7,347(29%) 3,6006,100 2,500 69%Travel14,851 14,136 14,038 2,194 14,342(3%) 13,30013,300 -0%Debt Service3,155,500 3,156,080 3,386,683 2,498,405 3,232,7544% 3,821,8963,625,548 (196,348) (5%)Idi C192 316600082 000116 2(3 %) 82 00082 0000%Indirect Costs192,31676,00082,000-116,772(35%) 82,00082,000-0%Other 164,700 94,938 830,754 36,448 363,464 125% 114,180161,430 47,250 41%TOTAL SEWER5,730,741$ 5,894,330$ 6,916,474$ 3,749,246$ 6,180,515$ 10% 6,870,976$ 7,266,452$ 395,476$ 6%SEWER ENTERPRISE FUND4 AppendixAppendixSewer Enterprise Fund5 Town & County of Nantucket Town & County of Nantucket OrganizationChartOrganizationChart––SewerEnterpriseFundSewerEnterpriseFundOrganization Chart Organization Chart Sewer Enterprise Fund Sewer Enterprise Fund SEWER DIRECTORMA Grade 7CAssoc. MCPPOChief OperatorMA Grade 6C/7C FullAdministration MCPPO CertSEWERENGINEERINGFUTUREPROFFESSIONALLaboratoryOperationsLab ManagerSIASCONSETFACILITYLead OperatorSURFSIDEFACILITYASSISTANT CHIEFMAINTENANCEDIVISIONChief MechanicCOLLECTIONSSYSTEMSCollections OperatorENGINEERUNFUNDEDMA Grade 4M/6CLab Tech. (Future with Lab Upgrades)pMA Grade 6C/7C OperatorAs neededMinMAGradeMA Grade 6C/7C FullWORKING FOREMAN (1)MA Grade 6C FullOperatorMA Grade 6C/7COperatorTechnicianMAGrade6CMA Grade 6C NEWEA Coll Grade 3Collections OperatorMA Grade 6CUpgrades)Min MA Grade 4MOperator Technician Vacant 1‐20‐17MA Grade 6CSeasonalMA Grade 6COperator TechnicianMa Grade 6C NEWEA Coll Grade 3Vacant retiredMin Staffing requirements is Nine(9) Operators. Current staffing with recent promotions, retirement, and 1 operator leaving is Six (6)Seasonal Internship (1)SEWER ENTERPRISE FUND6 FY2018 Budget DetailSEWER ENTERPRISE FUND7 FY2018dSewer Enterprise Fund Exceptions PitiOtilE(1)PositionsOperationalExpenses (1)1. Administrative Assistant Position: $61,300 1. Repairs & Maintenance (building): $12,5002. Add’l Overtime: $15,000 2. Repairs & Maintenance (office equip): $15,0003TwoSewerCollectionsPositions:$110 8003Repairs&Maintenance(sewer):$10 0003.Two Sewer Collections Positions: $110,8003.Repairs & Maintenance (sewer): $10,0004. Professional Services (WWT): $100,0005. Inventory (spare parts): $100,0006. Water Pollution Abatement: $47,7137. Professional Services (sewer collections): $9,5008. Professional Services (Sconset): $9,600 db $9. Upgradeto Wastewater Lab: $30,000. (1)Non‐controllable expenses such as general insurance, medical insurance, pension costs and utilities are excluded.SEWER ENTERPRISE FUND8 FY2018d(’d)Sewer Enterprise Fund Exceptions (cont’d) CapitalItemsCapital Items1. Pump Station Upgrades: $100,0002. Force Main Assessment & Inspections: $500,0003. CMOM: $1,750,0004. Generator Replacement: $54,7005. Tanker Truck Replacement: $250,0006. Sconset Collections System Evaluation: $693,0007. Town Water Main to Plant and Housing: $250,0008. Flora Street Manholes: $100,0009. Farmer St. Manhole & Main Replacement: $100,000bl $10. Fiber Lines to Plant: $75,000SEWER ENTERPRISE FUND9 TOWN OF NANTUCKETSEWER - ENTERPRISE FUNDACTUALBUDGETPROJECTED BUDGETFY2016FY2017FY2018Revenue7,205,670 6,804,820 6,804,820 Expenses6,916,474 6,870,976 7,266,452 Net Earnings289,197 (66,156) (461,632) Transfer from Retained Earnings317,229 66,156 461,632 Net Earnings after R/E Transfer606,426 - - Net Sources & UsesAdd Back: Transfer to Capital Project Fund740,217 Ending FB 1,346,643 - - TOTALCertified Retained Earnings as of July 1, 2016 4,753,867 10 SEWER ENTERPRISE FUNDOPERATIONS BUDGETFY2018 BUDGET PROJECTION3-YEAR ACTUALDEPT ACCOUNT ACCOUNT NAME FY2018 BUDGET WASTE WATER TREATMENT66440 41710 P&I (393)$ (3,256)$ (1,121)$ (457)$ (1,590)$ 69% (3,300)$ (3,300)$ -$ 0%66440 42460 SEWER FEE INCOME(5,753,902) (5,957,651) (6,219,320) (3,704,442) (5,976,958) 4% (5,960,000)(5,960,000)-$ 0%66440 42461 DPW SEWER PERMITS(193,750) (230,018) (282,465) (122,080) (235,411) 21% (230,020)(230,020)-$ 0%66440 42462 SEWER LIENS COLLECTED(3,676) (13,454) (16,170) - (11,100) 110% (13,500)(13,500)-$ 0%66440 42463 SEWER PRIVILEGE FEE(306,579) (393,608) (466,726) (131,608) (388,971) 23% (395,000)(395,000)-$ 0%66440 42464 SEWER PRIVELEGE INT FEE(38,508) (37,454) (36,857) (1,590) (37,606) (2%) (37,500)(37,500)-$ 0%66440 43275 SEPTIC DISPOSAL FEES(173,304) (165,399) (183,012) (92,971) (173,905) 3% (165,500)(165,500)-$ 0%66440 48201 INTEREST ON INVESTMENTS(6,151) - - - (2,050) (100%) ---$ na66440 48205 INTEREST REV SEWER PRIV FEE- - - (203) - na---$ na66440 49000 REFUNDS - 21,228 - - 7,076 na---$ na66440 51100 SALARY, PERMANENT497,582 552,164 587,019 267,299 545,588 9% 705,300769,200 63,900$ 9%66440 51300 OVERTIME 73,827 89,684 60,574 39,298 74,695 (9%) 75,00090,000 15,000$ 20%66440 51700 LONGEVITY PAY7,246 7,236 7,291 8,355 7,258 0% 10,2607,500 (2,760)$ (27%)66440 51701 INS PREM: MEDICAL BLUE CROSS152,874 166,738 175,361 86,458 164,991 7% 206,378233,920 27,542$ 13%66440 51770 BARNSTABLE COUNTY RETIREMT FND141,587 124,806 139,004 149,671 135,132 (1%) 130,422145,259 14,837$ 11%66440 51900 CONTRACTUAL OBLIGATIONS- - - - - na---$ na66440 51960 COMPENSATION/UNEMPLOYMENT10,467 1,180 - - 3,882 (100%) ---$ na66440 51961 MEDICARE P/R TAX8,390 9,412 9,502 4,568 9,101 6% 11,50013,189 1,689$ 15%66440 51999 FINCOM TRANSFER SALARIES - - - - - na---$ na66440 52101 UTILITY: ELECTRICITY269,765 387,047 400,683 177,233 352,498 22% 400,000420,000 20,000$ 5%66440 52103 UTILITY: FUEL OIL65,751 54,527 39,268 5,385 53,182 (23%) 60,00065,000 5,000$ 8%66440 52107 UTILITY: LANDFILL - - - - - na---$ na66440 52401 REP&MAINT: OFFICE EQUIP- - - - - na-15,000 15,000$ na66440 52403 REP&MAINT VEHICLE100 21,880 363 - 7,447 91% ---$ na66440 52404 REP&MAINT: BUILDING10,370 12,226 7,341 9,013 9,979 (16%) 12,50025,000 12,500$ 100%66440 52405 REP&MAINT: EQUIPMENT52,765 104,922 80,424 20,646 79,370 23% 85,000100,000 15,000$ 18%66440 52407 REP&MAINT: SEWER- 4,898 - - 1,633 na-10,000 10,000$ na66440 52700 RENTALS/LEASES- - - - - na---$ na66440 52901 SLUDGE DISPOSAL COSTS201,468 222,667 222,869 111,543 215,668 5% 230,000230,000-$ 0%66440 53100 PROFESSIONAL SERVICES7,856 86,729 185,317 83,887 93,301 386% 100,000200,000 100,000$ 100%66440 53103 GENERAL: ADVERTISING383 - 482 - 288 12% -1,000 1,000$ na66440 53115 LAB TESTING 4,317 9,776 13,546 4,441 9,213 77% 10,00010,000-$ 0%66440 53154 PRIVILEGE RECORDING FEE- - - - - na---$ na66440 53401 COMM: TELEPHONE16,274 15,374 13,155 5,918 14,934 (10%) 18,00018,000-$ 0%66440 53402 COMM: POSTAGE1,185 - 2,293 736 1,159 39% ---$ na66440 53803 OTHER LICENSES & TAXES315 817 60 - 397 (56%) 9001,900 1,000$ 111%66440 53804 OTHER: FREIGHT191 6,987 - - 2,393 (100%) 7,5007,500-$ 0%66440 54201 OFFICE SUPPLIES747 1,089 - 855 612 (100%) 1,1001,100-$ 0%66440 54303 BLDG&EXPENDABLE SUP/EQ6,868 2,114 3,182 501 4,055 (32%) 2,5003,000 500$ 20%66440 54701 SAFETY: UNIFORMS1,388 4,157 1,356 1,421 2,300 (1%) 3,0005,000 2,000$ 67%66440 54702 SAFETY: PROTECTIVE CLOTHING1,914 - 1,737 461 1,217 (5%) -5,000 5,000$ na66440 55001 MEDICAL SUPPLIES160 - 81 - 80 (29%) -1,000 1,000$ na66440 55101 BOOKS/SUBSCRIPTIONS- 159 - - 53 na200200-$ 0%66440 55302 SEWER SUPPLIES, PIPES3,427 1,417 - 5,198 1,615 (100%) 3,5003,500-$ 0%66440 55306 CHEMICALS 101,635 114,776 105,271 41,315 107,227 2% 115,000115,000-$ 0%66440 57101 IN-STATE MISC TRAVEL9,033 9,192 10,564 1,243 9,597 8% 9,0009,000-$ 0% FY2015 ACTUAL COMPOUND ANNUAL GROWTH RATE FY2016 ACTUAL $ INC/(DEC) FY18 / FY17 BUDGET % INC/(DEC) FY18 / FY17 BUDGET FY2014 ACTUAL SIMPLE AVERAGE FY2017 ACTUALYTD FY2017 BUDGET 11 SEWER ENTERPRISE FUNDOPERATIONS BUDGETFY2018 BUDGET PROJECTION3-YEAR ACTUALDEPT ACCOUNT ACCOUNT NAME FY2018 BUDGET FY2015 ACTUAL COMPOUND ANNUAL GROWTH RATE FY2016 ACTUAL $ INC/(DEC) FY18 / FY17 BUDGET % INC/(DEC) FY18 / FY17 BUDGET FY2014 ACTUAL SIMPLE AVERAGE FY2017 ACTUALYTD FY2017 BUDGET 66440 57102 IN-STATE:MILEAGE/CAR ALLW 79 265 2,089 277 811 416% 300300-$ 0%66440 57103 IN-STATE SEMINARS, PROF GA5,394 3,894 1,084 674 3,457 (55%) 4,0004,000-$ 0%66440 57404 INS PREM: BLANKET INS, BLDG82,637 84,371 87,439 - 84,816 3% 98,000109,760 11,760$ 12%66440 57406 INS PREM: CLAIM DEDUCTIBLE- - - - - na---$ na66440 57502 INS: WORKMANS' COMP- - - - - na---$ na66440 57999 MWPAT ADMIN FEE53,939 53,830 58,847 28,526 55,539 4% 60,00060,000-$ 0%66440 57899 CONTINGENCY / UNALLOCATED EXP- - - - - na12,93012,930 (0)$ (0%)66440 58501ADD EQ:NEW EQUIP- PUMP STATION - 470 271 298 247 na-5,000 5,000$ na66440 52xxx SPARE PARTS INVENTORY NEW LINE (LIBBY)- - - - - -100,000 100,000$ na66440 59101 DEBT SERVICE: PRINCIPAL588,200 580,900 573,600 405,000 580,900 (1%) 779,818624,308 (155,510)$ (20%)66440 59102 DEBT SERVICE INTEREST217,683 199,263 185,699 75,626 200,882 (8%) 258,266227,719 (30,547)$ (12%)66440 59103 BOND ISSUE EXPENSE2,375 17,500 - - 6,625 (100%) 18,00018,000-$ 0%66440 59108 DEBT SERVICE SHORT TERM INTEREST- - - 17,696 - na50,00050,000-$ 0%66440 59113 WATER POLLUTION ABATMT PRN 1,550,334 1,586,078 1,804,609 1,638,830 1,647,007 8% 1,815,2171,862,930 47,713$ 3%66440 59114 WATER POLL ABATEMENT INT792,098 756,479 822,775 361,254 790,451 2% 884,595826,590 (58,005)$ (7%)66440 59250 INTEREST: GENERAL4,811 15,859 - - 6,890 (100%) 16,00016,000-$ 0%66440 59501 OTHER FIN: GENERAL- - - - - na---$ na66440 59991 TRANSFER TO GF- INDIRECT COSTS192,316 76,000 82,000 - 116,772 (35%) 82,00082,000-$ 0%66440 59993 TRANS TO CAPITAL PROJECT FUND90,000 - 740,217 - 276,739 187% -30,000 30,000$ naTOTAL REVENUE (6,476,263)$ (6,779,613)$ (7,205,670)$ (4,053,351)$ (6,820,516)$ 5%(6,804,820)$ (6,804,820)$ -$ 0%TOTAL EXPENSE 5,227,749$ 5,386,883$ 6,425,372$ 3,553,626$ 5,680,001$ 11%6,276,186$ 6,534,806$ 258,620$ 4%SEWER COLLECT & DISPOSAL66445 49102 BOND PROCEEDS- - - - - na-$ -$ -$ na66445 51100 SALARY, PERMANENT99,732 69,027 72,483 34,237 80,414 (15%) 68,600179,400 110,800$ 162%66445 51300 OVERTIME 18,101 25,458 16,930 6,035 20,163 (3%) 15,00015,000-$ 0%66445 51700 LONGEVITY7,074 3,593 3,448 3,585 4,705 (30%) 3,4003,400-$ 0%66445 51701 INS:MED BLUE CROSS10,047 25,381 28,223 13,607 21,217 68% 28,70031,140 2,440$ 9%66445 51961 MEDICARE P/R TAX1,811 1,422 1,347 636 1,527 (14%) 1,3002,900 1,600$ 123%66445 51999 FINCOM TRANSFER SALARIES - - - - - na---$ na66445 52101 UTILITY:ELECTRICTY37,372 49,379 48,899 24,199 45,217 14% 55,00055,000-$ 0%66445 52103 UTILITY:FUEL 472 - - - 157 (100%) 700700-$ 0%66445 52105 UTILITY:WATER3,697 3,255 3,829 1,825 3,594 2% 3,8003,800-$ 0%66445 52404 REP&MAINT:BUILDING746 1,000 - - 582 (100%) 1,5001,500-$ 0%66445 52405 REP&MAINT:EQUIPMENT10,952 8,010 5,268 10,348 8,077 (31%) 8,00010,000 2,000$ 25%66445 52407 REP&MAINT:SEWERS9,019 2,367 2,450 3,738 4,612 (48%) 3,5005,000 1,500$ 43%66445 53100 PROFESSIONAL SERVICES90,343 80,000 73,975 24,390 81,439 (10%) 90,500100,000 9,500$ 10%66445 53401 COMM:TELEPHONE- - - - - na---$ na66445 53402 COMM:POSTAGE 9,191 17,175 10,000 - 12,122 4% 18,00018,000-$ 0%66445 53803 OTHER: LICENSE110 - - - 37 (100%) ---$ na66445 54201 OFFICE SUPPLIES4,728 - 3,071 - 2,600 (19%) ---$ na66445 54701 SAFETY:UNIFORMS196 - - - 65 (100%) ---$ na66445 54702 SAFETY:PROTECTIVE CLOTHING- - - - - na-3,000 3,000$ na66445 55302 DPW:SEWER762 520 - - 427 (100%) 520520-$ 0%66445 57101 IN-STATE:MISC TRAVEL345 - 302 - 216 (7%) ---$ na12 SEWER ENTERPRISE FUNDOPERATIONS BUDGETFY2018 BUDGET PROJECTION3-YEAR ACTUALDEPT ACCOUNT ACCOUNT NAME FY2018 BUDGET FY2015 ACTUAL COMPOUND ANNUAL GROWTH RATE FY2016 ACTUAL $ INC/(DEC) FY18 / FY17 BUDGET % INC/(DEC) FY18 / FY17 BUDGET FY2014 ACTUAL SIMPLE AVERAGE FY2017 ACTUALYTD FY2017 BUDGET 66445 57502 INS: WORKMANS COMP- 108 - - 36 na---$ na66445 57404 INS PREM:BLANKET INS, BLDG11,318 11,755 11,437 - 11,503 1% 13,16513,165 0$ 0%66445 59991 TRANSFER TO GENERAL FUND - - - - - na---$ naTOTAL REVENUE -$ -$ -$ -$ -$ na-$ -naTOTAL EXPENSE 316,016$ 298,449$ 281,660$ 122,600$ 298,708$ (6%) 311,685$ 442,525$ 130,840 42% SCONSET WATER TREATMENT66446 49902 BOND ANTICIPATION NOTES- - - - - na-$ -$ -$ na66446 51100 SALARY, PERMANENT64,327 73,473 76,151 32,964 71,317 9% 76,90076,600 (300)$ (0%)66446 51300 OVERTIME - 2,852 2,334 623 1,728 na20,6105,610 (15,000)$ (73%)66446 51700 LONGEVITY PAY1,468 2,248 2,186 2,273 1,967 22% 2,3003,800 1,500$ 65%66446 51701 INS:MED BLUE CROSS6,776 8,989 10,143 4,742 8,636 22% 10,20011,067 867$ 9%66446 51961 MEDICARE P/R TAX954 1,139 1,170 520 1,088 11% 1,4001,500 100$ 7%66446 52101 UTILITY:ELECTRICITY40,089 51,739 60,715 28,173 50,848 23% 55,00055,000-$ 0%66446 52103 UTILITY:FUEL 16,439 14,381 - - 10,273 (100%) 18,00018,000-$ 0%66446 52105 UTILITY:WATER1,773 1,283 1,496 768 1,517 (8%) 1,8001,800-$ 0%66446 52403 REP&MAINT VEHICLE- - - - - na-6,000 6,000$ na66446 52404 REP&MAINT:BUILDING9,370 5,967 - - 5,112 (100%) 10,00010,000-$ 0%66446 52405 REP&MAINT:EQUIPMENT9,819 13,095 15,514 - 12,809 26% 50,00050,000-$ 0%66446 53100 PROFESSIONAL SERVICES387 1,813 1,765 7 1,322 113% 40010,000 9,600$ 2,400%66446 53115 LAB TESTING 1,203 1,569 1,946 565 1,573 27% 1,2001,200-$ 0%66446 53401 COMM:COMCAST INTERNET- - - 889 - na-2,000 2,000$ na66446 53402 COMM: POSTAGE117 - - - 39 (100%) 200200-$ 0%66446 53804 OTHER:FREIGHT- - - - - na---$ na66446 54201 OFFICE SUPPLIES- - - - - na-1,000 1,000$ na66446 54701 SAFETY: UNIFORMS250 - - - 83 (100%) 250500 250$ 100%66446 55302 DPW:SEWER2,005 1,077 - - 1,027 (100%) 2,0002,000-$ 0%66446 55306 CHEMICALS 5,203 1,495 8,403 1,495 5,034 27% 2,5002,500-$ 0%66446 57101 IN STATE: MISC TRAVEL- 784 - - 261 na---$ na66446 57404 INS PREM: BLANKET INS, BLDG26,795 27,093 27,620 - 27,169 2% 30,34530,345 (0)$ (0%)66446 57502 INS: WORKMAN'S COMP- - - - - na---$ naTOTAL REVENUE -$ -$ -$ -$ -$ -$ -$ -$ naTOTAL EXPENSE 186,976$ 208,998$ 209,442$ 73,020$ 201,805$ 6% 283,105$ 289,122$ 6,017$ 2% SEWER ENTERPRISE GRAND TOTALTOTAL REVENUE(6,476,263)$ (6,779,613)$ (7,205,670)$ (4,053,351)$ (6,820,516)$ 5% (6,804,820)$ (6,804,820)$ -$ - TOTAL EXPENSE5,730,741$ 5,894,330$ 6,916,474$ 3,749,246$ 6,180,515$ 10% 6,870,976$ 7,266,452$ 395,476$ 6% VARIANCE (Excess) / Deficit(745,522)$ (885,283)$ (289,197)$ (304,105)$ (640,001)$ (38%) 66,156$ 461,632$ 395,476$ 598% SOURCE: RETAINED EARNINGS*-$ 885,283$ 289,197$ 304,105$ 640,001$ na(66,156)$ (461,632)$ (395,476)$ REMAINING VARIANCE(745,522)$ -$ -$ -$ -$ -$ -$ -$ 13 FY 2018 Personnel Spreadsheet Sewer Enterprise FundNumber of Positions in DepartmentORG: 66440ORG: 66445ORG: 66446Full-time911Part-time000Seasonal000Temporary000Vacancies100New Positions Requested020TOTAL OF ALL POSITIONS 10 3 1Name PositionAvg Hours Per WeekJob CodeClass & Step as of 6/30/17(e.g., B -Step 3)Yearly Salaryas of 6/30/17FY18 Anniversary DateFY2018 ProjectedSalaryLongevityPayEducationPayCertificationPayHolidayPayOtherTotal byEmployeeORG: 66440GRAY,DSEWER DIRECTOR40.00NON-UNION 115,00011/01/17116,50000000116,500VACANT - FUNDEDCHIEF WWTP40.00 PW47 NON-UNION 97,20012/18/1798,2000000098,200MANNING, K.GENERAL FOREMAN SEWER PLANT 40.00 PW31 M6 STEP 776,60005/18/1876,6002,300000078,900ALLEN, P.OPERATOR WWTP40.00 PW43 M4 STEP 260,30008/03/1761,9000000061,900LEVEILLE, W.SEWER LAB TECH40.00 PW42 M4 STEP 771,90012/23/1771,9002,200000074,100GARY, A.ASSISTANT CHIEF40.00 PW44 M5 STEP 774,10007/05/1774,1003,000000077,100MOONEY, S.OPERATOR WWTP40.00 PW43 M4 STEP 771,90012/20/1771,9000000071,900HARDY, J.SR EQUIPMENT OP SEWER40.00 PW51 M3 STEP 768,40010/18/1768,4000000068,400FRAZIER, P.MAINT TECH SEWER40.00 PW41 M3 STEP 764,50001/19/1868,4000000068,400TBDADMIN ASSIST.40.00 PW20 S2PO STEP 161,30006/30/1861,3000000061,300ORG: 66445VACANT - FUNDED*SEWER COLLECTIONS40.00 PW26 M3 STEP 768,40012/07/1768,4003,400000071,800VACANT - REQUESTED SEWER COLLECTIONSM3 STEP 155,50006/30/1855,50055,500VACANT - REQUESTED SEWER COLLECTIONSM3 STEP 155,50006/30/1855,50055,500ORG: 66446INGLIS, R.PLANT MANAGER40.00 PW10 M6 STEP 776,60005/11/1876,6003,800000080,400* Employee recently retired and vacancy will be filled shortly.org:66440 org: 66445org:66446769,200179,40076,60000 07,500 3,400 3,80000000000000000075,00015,00020,610851,700197,800101,01012,3002,900 1,500223,92031,14011,0671,087,920231,840113,577ORG: 66440; 66445; 66446Total Prorated Salary (enter on Munis 51100)Total Seasonal Salary (enter on Munis 51xxx)Total Longevity (enter on Munis 51700)Total Personnel Services Total Education (enter on Munis 516xx)Total Cerfification Pay (enter on Munis 51551)Total Holiday Pay (enter on Munis 518xx)Total Other Pay (enter on Munis line where appropriate)Shift Differential (enter on Munis 513xx)Overtime (enter on Munis 514xx)Salary SubtotalMedicare (enter on Munis 51961)Insurance:Medical BSBC (enter Munis 51701)14 PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPALIssue PaymentsPaymentsPayments Payments Payments Payments Payments Payments PaymentsPurposeDateFY2017FY2018FY2019FY2020FY2021FY2022FY2023FY2024FY2025SEWER ENTERPRISE42,122,929 39,527,894 37,040,655 34,591,380 32,081,129 29,516,672 27,046,641 24,521,773 22,084,104 MWPAT 98‐1438/25/200460,000 60,000 60,000 65,000 65,000 ‐‐‐MWPAT 98‐1448/25/200415,000 15,000 15,000 15,000 15,000 ‐‐‐MWPAT 98‐1458/25/200415,000 15,000 15,000 15,000 15,000 ‐‐‐MWPAT CW 02 50A11/23/2004324,363 332,434 344,413 354,859 367,377 367,389 370,341 ‐MWPAT CW 02 50 10/26/2006196,378 205,512 210,079 219,213 223,780 237,480 255,748 511,496 520,630 MWPAT CW 01 4012/14/2006100,000 105,000 105,000 110,000 115,000 115,000 120,000 120,000 SEWER CONSTRUCTION2/15/200815,000 15,000 SEWER CONSTRUCTION2/15/200845,000 45,000 SEWER 22/15/200870,000 70,000 66%% WWTF2/15/200813,200 13,200 MWPAT CW 04 2012/9/2008167,594 170,979 174,433 177,957 181,552 185,220 188,962 192,779 196,674 66% MWPAT CW052112/15/2009755,034 773,484 792,384 811,746 831,580 851,900 872,716 894,041 915,887 MWPAT CW 07 177/8/2010181,848 185,522 189,270 193,093 196,994 200,974 205,034 209,176 213,402 SEWER CURRENT REFUNDING 05/20016/7/201240,000 40,000 40,000 40,000 40,000 ‐‐‐SEWER ADVANCED REFUNDING 12/01/20036/7/201260,000 55,000 55,000 55,000 55,000 50,000 50,000 45,000 SEWER IMPROVEMENTS6/7/2012100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 WASTEWATER MANAGEMENT6/7/2012150,000 ‐‐‐‐‐‐‐SEWER EQUIPMENT6/6/201355,000 55,000 ‐‐‐‐‐‐SEWER EQUIPMENT6/5/201425,000 20,000 CW 12 09 PERM FINANCING1/7/2015206,618 211,108 215,696 220,384 225,174 230,068 235,068 240,177 245,397 Refi WWTF Sewer 08 398K Jul'168/3/201613,000 13,000 13,000 13,000 13,000 12,000 12,000 Refi Sewer2 08 1.435M Jul'168/3/201667,000 67,000 67,000 66,000 66,000 66,000 66,000 Refi Sewer1 08 870K Jul'168/3/201643,000 43,000 43,000 43,000 38,000 38,000 38,000 Refi Sewer Const 08 250K Jul'168/3/201610,000 10,000 10,000 10,000 10,000 9,000 9,000 TOTAL SEWER FUND2,595,035 2,487,238 2,449,275 2,510,251 2,564,457 2,470,031 2,524,868 2,437,669 2,316,989 Sewer Debt 624,308.00 MWPAT Debt 1,862,930.44 15 IssuePurpose DateSEWER ENTERPRISEMWPAT 98‐1438/25/2004MWPAT 98‐1448/25/2004MWPAT 98‐1458/25/2004MWPAT CW 02 50A11/23/2004MWPAT CW 02 50 10/26/2006MWPAT CW 01 4012/14/2006SEWER CONSTRUCTION2/15/2008SEWER CONSTRUCTION2/15/2008SEWER 22/15/200866%% WWTF2/15/2008MWPAT CW 04 2012/9/200866% MWPAT CW052112/15/2009MWPAT CW 07 177/8/2010SEWER CURRENT REFUNDING 05/20016/7/2012SEWER ADVANCED REFUNDING 12/01/20036/7/2012SEWER IMPROVEMENTS6/7/2012WASTEWATER MANAGEMENT6/7/2012SEWER EQUIPMENT6/6/2013SEWER EQUIPMENT6/5/2014CW 12 09 PERM FINANCING1/7/2015Refi WWTF Sewer 08 398K Jul'168/3/2016Refi Sewer2 08 1.435M Jul'168/3/2016Refi Sewer1 08 870K Jul'168/3/2016Refi Sewer Const 08 250K Jul'168/3/2016 TOTAL SEWER FUNDPRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPALPayments Payments Payments Payments Payments Payments Payments Payments PaymentsFY2026FY2027FY2028FY2029FY2030FY2031FY2032FY2033FY203419,767,114 17,936,759 16,069,574 14,378,300 12,770,948 11,128,466 9,450,029 7,980,267 6,577,806 200,647 204,701 938,266 961,193 984,679 1,008,740 1,033,388 1,058,639 1,084,507 1,111,007 1,138,154 217,713 222,111 226,598 231,176 235,846 240,611 100,000 100,000 100,000 100,000 100,000 100,000 100,000 250,730 256,180 261,747 267,436 273,248 279,187 285,255 291,454 297,789 12,000 12,000 11,200 65,000 65,000 63,500 37,000 37,000 35,450 9,000 9,000 8,100 1,830,356 1,867,184 1,691,274 1,607,352 1,642,482 1,678,437 1,469,762 1,402,461 1,435,943 16 IssuePurpose DateSEWER ENTERPRISEMWPAT 98‐1438/25/2004MWPAT 98‐1448/25/2004MWPAT 98‐1458/25/2004MWPAT CW 02 50A11/23/2004MWPAT CW 02 50 10/26/2006MWPAT CW 01 4012/14/2006SEWER CONSTRUCTION2/15/2008SEWER CONSTRUCTION2/15/2008SEWER 22/15/200866%% WWTF2/15/2008MWPAT CW 04 2012/9/200866% MWPAT CW052112/15/2009MWPAT CW 07 177/8/2010SEWER CURRENT REFUNDING 05/20016/7/2012SEWER ADVANCED REFUNDING 12/01/20036/7/2012SEWER IMPROVEMENTS6/7/2012WASTEWATER MANAGEMENT6/7/2012SEWER EQUIPMENT6/6/2013SEWER EQUIPMENT6/5/2014CW 12 09 PERM FINANCING1/7/2015Refi WWTF Sewer 08 398K Jul'168/3/2016Refi Sewer2 08 1.435M Jul'168/3/2016Refi Sewer1 08 870K Jul'168/3/2016Refi Sewer Const 08 250K Jul'168/3/2016 TOTAL SEWER FUNDPRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPALPayments Payments Payments Payments Payments PaymentsFY2035FY2036FY2037 FY2038 FY2039 FY20405,141,863 3,671,637 2,477,182 1,253,541 0 0 1,165,965 1,194,455 1,223,641 1,253,541 304,261 1,470,226 1,194,455 1,223,641 1,253,541 ‐ ‐ 17 INTEREST INTEREST INTEREST INTEREST INTEREST INTEREST INTEREST INTEREST INTEREST INTEREST INTERESTIssue Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments PaymentsPurpose Date FY2017 FY2018 FY2019 FY2020 FY2021 FY2022 FY2023 FY2024 FY2025 FY2026 FY2027SEWER ENTERPRISETOTAL DEBTMWPAT 98‐1438/25/200414,100 10,791 7,794 4,911 1,706 MWPAT 98‐1448/25/20043,396 2,568 1,823 1,133 394 MWPAT 98‐1458/25/20043,396 2,568 1,823 1,133 394 MWPAT CW 02 50A11/23/200494,553 83,944 77,274 49,115 37,369 27,703 9,258 MWPAT CW 02 50 10/26/2006115,324 104,735 94,219 83,509 72,626 61,084 48,435 21,995 MWPAT CW 01 4012/14/200639,867 33,533 27,626 22,803 17,321 11,923 5,928 SEWER CONSTRUCTION 250K2/15/20081,013 525 SEWER CONSTRUCTION 870K2/15/20083,038 1,575 SEWER 2 1.43M2/15/20084,725 2,450 66%% WWTF2/15/2008891 462 MWPAT CW 04 2012/9/200839,154 35,768 32,314 28,790 25,195 21,527 17,786 13,968 10,074 6,100 2,047 66% MWPAT CW052112/15/2009513,637 495,188 476,288 456,926 437,091 416,772 395,955 374,631 352,785 330,405 307,479 MWPAT CW 07 177/8/201061,169 57,495 53,747 49,924 46,023 42,043 37,983 33,841 29,615 25,304 20,906 SEWER CURRENT REFUNDING 05/20016/7/20128,600 6,600 4,600 2,800 1,000 SEWER ADVANCED REFUNDING 12/01/20036/7/201219,200 16,325 13,575 11,100 8,625 6,000 3,500 1,125 SEWER IMPROVEMENTS6/7/201263,500 58,500 53,500 49,000 44,500 39,500 34,500 29,500 24,500 20,500 17,500 WASTEWATER MANAGEMENT6/7/20123,750 SEWER EQUIPMENT 275k6/6/20131,650 550 SEWER EQUIPMENT 97K6/5/2014900 400 CW 12 09 PERM FINANCING1/7/201595,940 91,807 87,585 83,271 78,863 74,360 69,759 65,057 60,254 55,346 50,331 Refi WWTF Sewer 08 398K Jul'168/3/20164,111 4,744 4,484 3,964 3,444 2,924 2,404 1,904 1,424 944 464 Refi Sewer2 08 1.435M Jul'168/3/201621,727 25,070 23,730 21,050 18,370 15,710 13,070 10,430 7,790 5,170 2,570 Refi Sewer1 08 870K Jul'168/3/201613,094 15,109 14,249 12,529 10,809 9,089 7,469 5,949 4,429 2,929 1,449 Refi Sewer Const 08 250K Jul'168/3/20163,122 3,602 3,402 3,002 2,602 2,202 1,802 1,422 1,062 702 342 TOTAL SEWER FUND1,129,855 1,054,310 978,032 884,961 806,333 730,836 647,848 559,822 491,932 447,400 403,088 Sewer Debt 227,719 MWPAT Debt 826,590 18 IssuePurpose DateSEWER ENTERPRISETOTAL DEBTMWPAT 98‐1438/25/2004MWPAT 98‐1448/25/2004MWPAT 98‐1458/25/2004MWPAT CW 02 50A11/23/2004MWPAT CW 02 50 10/26/2006MWPAT CW 01 4012/14/2006SEWER CONSTRUCTION 250K2/15/2008SEWER CONSTRUCTION 870K2/15/2008SEWER 2 1.43M2/15/200866%% WWTF2/15/2008MWPAT CW 04 2012/9/200866% MWPAT CW052112/15/2009MWPAT CW 07 177/8/2010SEWER CURRENT REFUNDING 05/20016/7/2012SEWER ADVANCED REFUNDING 12/01/20036/7/2012SEWER IMPROVEMENTS6/7/2012WASTEWATER MANAGEMENT6/7/2012SEWER EQUIPMENT 275k6/6/2013SEWER EQUIPMENT 97K6/5/2014CW 12 09 PERM FINANCING1/7/2015Refi WWTF Sewer 08 398K Jul'168/3/2016Refi Sewer2 08 1.435M Jul'168/3/2016Refi Sewer1 08 870K Jul'168/3/2016Refi Sewer Const 08 250K Jul'168/3/2016 TOTAL SEWER FUNDINTEREST INTEREST INTEREST INTEREST INTEREST INTEREST INTEREST INTEREST INTEREST INTEREST INTEREST INTEREST INTERESTPayments Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments PaymentsFY2028 FY2029 FY2030 FY2031 FY2032 FY2033 FY2034 FY2035 FY2036 FY2037 FY2038 FY2039 FY2040283,992 259,931 235,283 210,032 184,164 157,665 130,517 102,707 74,216 45,030 15,130 16,419 11,841 7,171 2,406 14,500 11,438 8,313 5,063 1,688 45,208 39,973 34,624 29,159 23,575 17,870 12,041 6,085 112 635 355 81 361,301 323,182 285,390 246,660 209,427 175,535 142,558 108,792 74,216 45,030 15,130 ‐ ‐ 19