Loading...
HomeMy WebLinkAboutSection VI - SEF FY20 Budget FY2020 BUDGET PROJECTION • ENTERPRISE FUNDS: SEWER FY2020 Budget Sewer Enterprise Fund FY2020 Sewer Enterprise Fund Review Wastewater Management Mission ➢To protect public health and the environment for our communities by providing high-quality wastewater-treatment services in an effective, efficient, and responsive manner ➢The Sewer Department operates and maintains Nantucket’s wastewater conveyance and treatment systems, which consists of 2 Wastewater Treatment Facilities,16 pump stations, and over 70 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. ➢16” Sewer Force Main Failure 01-04-2018 repairs were completed and line is in standby use. Goals ➢Continue to meet state mandated discharge limits for treated effluent ➢Continue to serve residents and Patrons with A professional and efficient administration ➢Complete season 2 for the Shimmo/Plus sewer expansion projects. Completion date estimated in early 2019 ➢Complete Surfside WWTF upgrade project ➢Complete Phase 2 of CMOM program Began 01-07-2019 Initiatives and Accomplishments ➢Standalone Sewer Department since November 2016 ➢Sea St pumping station upgrade construction has been completed with punch list items being finished. ➢Extensive Capital plan itemized and presented to Capital Program Committee ➢A full time staff engineer has been added to the department.SEWER ENTERPRISE FUND FY2020 Sewer Enterprise Fund Overview Priority ➢Develop a fiscally attainable budget plan (rate study underway) ➢Identify and prioritize critical infrastructure additions, repairs and replacements (CMOM program) ➢Continue with the design and future bidding phases based on year 1 Data. Significant Changes Year-to-Year ➢Additional staff, including Engineer, to address critical needs going forward ➢Additional flows from expansion into Shimmo/PLUS areas ➢Acquisition of specialized CCTV equipment to assist enterprise fund ➢Extensive specialized training has been ongoing over the past year and a half Key Issues ➢Design and program repairs for long-standing maintenance issues (CMOM) ➢Equitable financing plan for the proposed CWMP-20 year Capital Plan will be the biggest issue for the Sewer Enterprise Fund ➢Independent CWMP of ‘Sconset to be undertaken ➢Sewer Master Plan kick off meeting January 2019 ➢Partial Implementation of Plus parcels for sewer access completed. ➢All Mainline work has been completed in the Shimmo/NH/Plus parcels ➢Paving in all areas of the Shimmo project to be completed in the spring of 2019 SEWER ENTERPRISE FUND FY2020 Budget Sewer Enterprise Fund SEWER ENTERPRISE FUND 3-YEAR ACTUAL FY2020 BUDGET $ INC/(DEC) FY20 / FY19 BUDGET % INC/(DEC) FY20 / FY19 BUDGET SUMMARY Payroll-Salary 828,415$ 925,752$ 1,137,069$ 860,396$ 17% 1,443,710$ 1,443,710$ -$ 0% Contractual Obligations ----na 24,999 24,999 -0% Medicare P/R Tax Expense 12,018 13,425 16,488 12,472 17% 21,140 21,140 -0% Medical Insurance 213,727 224,246 281,870 213,027 15% 517,886 517,886 -0% Barnstable County Retirement 139,004 149,671 152,079 137,827 5% 200,875 200,875 -0% Utilities 568,046 530,760 559,167 558,597 (1%) 639,300 644,300 5,000 1% Repairs & Maintenance 111,359 117,895 292,144 134,540 62% 271,000 386,000 115,000 42% Professional Services 261,057 321,235 301,476 250,278 7% 560,000 760,000 200,000 36% Sludge Disposal Costs 222,869 224,371 237,639 223,302 3% 255,000 255,000 -0% Sewer Supplies and Chemicals 113,674 107,300 187,246 113,420 28% 223,520 223,520 -0% General Insurance 126,496 84,977 114,694 111,564 (5%) 173,598 173,598 -0% Other Supplies 6,334 14,821 20,122 8,120 78% 6,100 18,600 12,500 205% Travel 14,038 8,260 46,219 12,145 81% 38,300 43,300 5,000 13% Debt Service 3,386,683 3,426,542 3,394,229 3,323,102 0% 3,531,977 3,531,977 -0% Indirect Costs 82,000 --52,667 (100%) ---na Other 830,754 1,383,425 230,021 823,770 (47%) 162,930 312,930 150,000 92% TOTAL SEWER 6,916,474$ 7,532,682$ 6,970,464$ 6,781,162$ 0% 8,070,335$ 8,557,835$ 487,500$ 6% COMPOUND ANNUAL GROWTH RATE FY2019 BUDGET FY2018 ACTUAL SIMPLE AVERAGE FY2017 ACTUAL FY2016 ACTUAL Appendix Sewer Enterprise Fund Town & County of Nantucket Organization Chart –Sewer Enterprise Fund SEWER DIRECTOR MA Grade 7C MCPPO Laboratory Operations Lab Manager MA Grade 4M/6C SIASCONSET FACILITY Lead Operator MA Grade 6C/7C VACANT FUNDED SURFSIDE FACILITY ASSISTANT CHIEF MA Grade 6C/7C Full OPERATOR MAINTENANCE TECH VACANT FUNDED VACANT FUNDED MAINTENANCE DIVISION Operator Technician Operator Technician Operator Technician COLLECTIONS SYSTEMS WORKING FOREMAN MA GRADE 6C COLLECTIONS OPERATOR COLLECTIONS OPERATOR COLLECTIONS OPERATOR OFFICE MANAGER Assoc. MCPPO OFFICE ADMINISTRATOR ENGINEER COMPLIANCE OFFICER CHIEF OPERATOR MA GRADE 7C SEWER ENTERPRISE FUND FY2020 Budget Detail SEWER ENTERPRISE FUND FY2020 Sewer Enterprise Fund Exceptions Positions Operational Expenses (1) 1.Rep&Maint: $120,000 2.Rental/Leases: $25,000 3.OSHA Training/Safety: $210,000 4.Replacement Vehicle: $45,000 5.New Pump Station: $50,000 (1)Non-controllable expenses such as general insurance, medical insurance, pension costs and utilities are excluded. SEWER ENTERPRISE FUND Capital 1.Current Force Main Assessment & Inspections: $2,000,000 2.CMOM: $2,000,000 3.Perimeter Fencing: $550,000 4.Surfside WWTF Phase 2 Upgrades: $6,500,000 5.National Grid L8 Feeder Project Area Sewer Replacement: $6,500,000 6.Jetties Beach-Bathing Beach Road Sewers: $285,000 7.Replace Loader: $150,000 9. Replace Sewer Rodding Truck: $206,000 10. Sconset Design and Construction New Collections: $350,000 11. New Sewer Force Main Design & Planning: $2,500,000 12. Pump Station Upgrades: $295,000 13. New Excavation Equipment: $165,000 SEWER ENTERPRISE FUND OPERATIONS BUDGET FY2020 BUDGET PROJECTION 3-YEAR ACTUAL DEPT ACCOUNT ACCOUNT NAME FY2020 BUDGET WASTE WATER TREATMENT 66440 41710 P&I (1,121)$ (1,423)$ (926)$ (1,157) (9%) (1,300)$ (1,300)$ -$ 0% 66440 42460 SEWER FEE INCOME (6,219,320) (6,082,823) (6,072,221) (6,124,788) (1%) (6,460,000)$ (6,460,000)$ -$ 0% 66440 42461 SEWER PERMITS (282,465) (323,100) (301,399) (302,321) 3% (280,020)$ (280,020)$ -$ 0% 66440 42462 SEWER LIENS COLLECTED (16,170) (13,652) (18,691) (16,171) 8% (13,500)$ (13,500)$ -$ 0% 66440 42463 SEWER PRIVILEGE FEE (466,726) (751,297) (882,795) (700,273) 38% (445,000)$ (445,000)$ -$ 0% 66440 42464 SEWER PRIVELEGE INT FEE (36,857) (31,783) (33,590) (34,077) (5%) (27,500)$ (27,500)$ -$ 0% 66440 43275 SEPTIC DISPOSAL FEES (183,012) (197,719) (180,152) (186,961) (1%) (160,500)$ (160,500)$ -$ 0% 66440 48201 INTEREST ON INVESTMENTS - - - - na -$ -$ -$ na 66440 48205 INTEREST REV SEWER PRIV FEE - (353) (427) (260) na -$ -$ -$ na 66440 49000 REFUNDS - - - - na -$ -$ -$ na 66440 51100 SALARY, PERMANENT 587,019 674,133 928,715 729,955 26% 952,200$ 952,200$ -$ 0% 66440 51300 OVERTIME 60,574 83,893 108,435 84,301 34% 90,000$ 90,000$ -$ 0% 66440 51700 LONGEVITY PAY 7,291 8,355 11,115 8,920 23% 5,200$ 5,200$ -$ 0% 66440 51701 INS PREM: MEDICAL BLUE CROSS 175,361 193,524 270,854 213,247 24% 369,266$ 369,266$ -$ 0% 66440 51770 BARNSTABLE COUNTY RETIREMT FND 139,004 149,671 152,079 146,918 5% 200,875$ 200,875$ -$ 0% 66440 51900 CONTRACTUAL OBLIGATIONS - - - - na 24,999$ 24,999$ -$ 0% 66440 51960 COMPENSATION/UNEMPLOYMENT - - - - na -$ -$ -$ na 66440 51961 MEDICARE P/R TAX 9,502 11,114 15,200 11,939 26% 15,332$ 15,332$ -$ 0% 66440 51963 WORKMENS COMP 2,272 1,976 2,124 na -$ -$ -$ na 66440 51999 FINCOM TRANSFER SALARIES - - - - na -$ -$ -$ na 66440 52101 UTILITY: ELECTRICITY 400,683 346,452 341,168 362,767 (8%) 420,000$ 420,000$ -$ 0% 66440 52103 UTILITY: FUEL OIL 39,268 57,057 75,738 57,354 39% 65,000$ 65,000$ -$ 0% 66440 52107 UTILITY: LANDFILL - - 196 65 na -$ -$ -$ na 66440 52401 REP&MAINT: OFFICE EQUIP - - - - na 15,000$ 5,000$ (10,000)$ (67%) 66440 52403 REP&MAINT VEHICLE 363 16,133 92,271 36,256 1,495% 20,000$ 20,000$ -$ 0% 66440 52404 REP&MAINT: BUILDING 7,341 19,288 45,329 23,986 148% 25,000$ 50,000$ 25,000$ 100% 66440 52405 REP&MAINT: EQUIPMENT 80,424 52,251 102,640 78,438 13% 100,000$ 100,000$ -$ 0% 66440 52407 REP&MAINT: SEWER - - - - na 10,000$ 10,000$ -$ 0% 66440 52700 RENTALS/LEASES - - - - na -$ 25,000$ 25,000$ na 66440 52901 SLUDGE DISPOSAL COSTS 222,869 224,371 237,639 228,293 3% 255,000$ 255,000$ -$ 0% 66440 53100 PROFESSIONAL SERVICES 185,317 242,072 171,933 199,774 (4%) 300,000$ 300,000$ -$ 0% 66440 53103 GENERAL: ADVERTISING 482 326 115 308 (51%) 1,000$ 1,000$ -$ 0% 66440 53115 LAB TESTING 13,546 8,739 13,090 11,792 (2%) 10,000$ 15,000$ 5,000$ 50% 66440 53154 PRIVILEGE RECORDING FEE - - - - na -$ -$ -$ na $ INC/(DEC) FY20 / FY19 BUDGET % INC/(DEC) FY20 / FY19 BUDGET SIMPLE AVERAGE FY2017 ACTUAL FY2016 ACTUAL FY2019 BUDGET COMPOUND ANNUAL GROWTH RATE FY2018 ACTUAL SEWER ENTERPRISE FUND OPERATIONS BUDGET FY2020 BUDGET PROJECTION 3-YEAR ACTUAL DEPT ACCOUNT ACCOUNT NAME FY2020 BUDGET $ INC/(DEC) FY20 / FY19 BUDGET % INC/(DEC) FY20 / FY19 BUDGET SIMPLE AVERAGE FY2017 ACTUAL FY2016 ACTUAL FY2019 BUDGET COMPOUND ANNUAL GROWTH RATE FY2018 ACTUAL 66440 53401 COMM: TELEPHONE 13,155 14,031 18,606 15,264 19% 18,000$ 20,500$ 2,500$ 14% 66440 53402 COMM: POSTAGE 2,293 2,385 3,587 2,755 25% -$ 5,000$ 5,000$ na 66440 53803 OTHER LICENSES & TAXES 60 555 935 517 295% 1,900$ 1,900$ -$ 0% 66440 53804 OTHER: FREIGHT - 724 2,578 1,101 na 7,500$ 7,500$ -$ 0% 66440 54101 ENERGY GAS DIESEL 3,818 17,846 10,832 na 10,000$ 12,500$ 2,500$ 25% 66440 54201 OFFICE SUPPLIES - 9,307 6,004 5,104 na 1,100$ 11,100$ 10,000$ 909% 66440 54303 BLDG&EXPENDABLE SUP/EQ 3,182 5,017 12,478 6,892 98% 3,000$ 3,000$ -$ 0% 66440 54701 SAFETY: UNIFORMS 1,356 2,065 9,387 4,270 163% 10,000$ 12,500$ 2,500$ 25% 66440 54702 SAFETY: PROTECTIVE CLOTHING 1,737 3,032 2,592 2,454 22% 10,000$ 12,500$ 2,500$ 25% 66440 55001 MEDICAL SERVICES 81 497 1,640 740 349% 1,000$ 3,500$ 2,500$ 250% 66440 55101 BOOKS/SUBSCRIPTIONS - - - - na 200$ 2,700$ 2,500$ 1,250% 66440 55302 SEWER SUPPLIES, PIPES - 11,535 42,066 17,867 na 103,500$ 103,500$ -$ 0% 66440 55306 CHEMICALS 105,271 90,783 113,441 103,165 4% 115,000$ 115,000$ -$ 0% 66440 57101 IN-STATE MISC TRAVEL 10,564 6,672 22,362 13,199 45% 19,000$ 21,500$ 2,500$ 13% 66440 57111 TRAINING-OSHA-PROFFESSIONAL DEVELOP - -$ 100,000$ 100,000$ na 66440 57112 NEW REPLACEMENT SEWER VEHICLE - -$ 45,000$ 45,000$ na 66440 57102 IN-STATE:MILEAGE/CAR ALLW 2,089 277 21 796 (90%) 300$ 2,800$ 2,500$ 833% 66440 57103 IN-STATE SEMINARS, PROF GA 1,084 1,311 23,837 8,744 369% 19,000$ 19,000$ -$ 0% 66440 57401 INS PREM: AUTO & LIABILITY - 4,129 6,728 3,619 na 5,000$ 5,000$ -$ 0% 66440 57404 INS PREM: BLANKET INS, BLDG 87,439 80,848 107,966 92,084 11% 120,736$ 120,736$ -$ 0% 66440 57406 INS PREM: CLAIM DEDUCTIBLE - - - - na -$ -$ -$ na 66440 57502 INS: WORKMANS' COMP - - - - na -$ -$ -$ na 66440 57999 MWPAT ADMIN FEE 58,847 55,690 52,621 55,719 (5%) 60,000$ 60,000$ -$ 0% 66440 57899 CONTINGENCY / UNALLOCATED EXP - - - - na 12,930$ 12,930$ -$ 0% 66440 58501 ADD EQ:NEW EQUIP- PUMP STATION 271 1,614 120,706 40,864 2,012% 5,000$ 55,000$ 50,000$ 1,000% 66440 59101 DEBT SERVICE: PRINCIPAL 573,600 573,200 413,200 520,000 (15%) 557,696$ 557,696$ -$ 0% 66440 59102 DEBT SERVICE INTEREST 185,699 148,871 210,276 181,615 6% 211,795$ 211,795$ -$ 0% 66440 59103 BOND ISSUE EXPENSE - - - - na 18,000$ 18,000$ -$ 0% 66440 59108 DEBT SERVICE SHORT TERM INTEREST - 78,611 141,733 73,448 na 50,000$ 50,000$ -$ 0% 66440 59113 WATER POLLUTION ABATMT PRN 1,804,609 1,845,448 1,889,985 1,846,681 2% 1,905,579$ 1,905,579$ -$ 0% 66440 59114 WATER POLL ABATEMENT INT 822,775 780,412 739,035 780,741 (5%) 772,907$ 772,907$ -$ 0% 66440 59250 INTEREST: GENERAL - - - - na 16,000$ 16,000$ -$ 0% 66440 59501 OTHER FIN: GENERAL - - - - na -$ -$ -$ na 66440 59991 TRANSFER TO GF- INDIRECT COSTS 82,000 - - 27,333 (100%) -$ -$ -$ na 66440 59993 TRANS TO CAPITAL PROJECT FUND 740,217 1,289,700 - 676,639 (100%) -$ -$ -$ na TOTAL REVENUE (7,205,670)$ (7,402,150)$ (7,490,202)$ (7,366,007)$ 2% (7,387,820.00)$ (7,387,820)$ -$ 0% SEWER ENTERPRISE FUND OPERATIONS BUDGET FY2020 BUDGET PROJECTION 3-YEAR ACTUAL DEPT ACCOUNT ACCOUNT NAME FY2020 BUDGET $ INC/(DEC) FY20 / FY19 BUDGET % INC/(DEC) FY20 / FY19 BUDGET SIMPLE AVERAGE FY2017 ACTUAL FY2016 ACTUAL FY2019 BUDGET COMPOUND ANNUAL GROWTH RATE FY2018 ACTUAL TOTAL EXPENSE 6,425,372$ 7,100,185$ 6,528,122$ 6,684,560$ 1% 6,934,015.00$ 7,209,015$ 275,000$ 4% SEWER COLLECT & DISPOSAL 66445 49102 BOND PROCEEDS - - - - na -$ -$ -$ na 66445 51100 SALARY, PERMANENT 72,483 65,063 - 68,857 (100%) 284,500$ 284,500$ -$ 0% 66445 51300 OVERTIME 16,930 7,338 - 16,575 (100%) 15,000$ 15,000$ -$ 0% 66445 51700 LONGEVITY 3,448 5,411 - 4,151 (100%) 2,600$ 2,600$ -$ 0% 66445 51701 INS:MED BLUE CROSS 28,223 19,685 - 24,429 (100%) 134,737$ 134,737$ -$ 0% 66445 51961 MEDICARE P/R TAX 1,347 1,128 - 1,299 (100%) 4,343$ 4,343$ -$ 0% 66445 51999 FINCOM TRANSFER SALARIES - - - - na -$ -$ -$ na 66445 52101 UTILITY:ELECTRICTY 48,899 51,985 65,246 50,088 16% 55,000$ 55,000$ -$ 0% 66445 52103 UTILITY:FUEL - - - - na 700$ 700$ -$ 0% 66445 52105 UTILITY:WATER 3,829 3,827 3,056 3,637 (11%) 3,800$ 3,800$ -$ 0% 66445 52404 REP&MAINT:BUILDING - 1,463 - 821 na 10,000$ 35,000$ 25,000$ 250% 66445 52405 REP&MAINT:EQUIPMENT 5,268 18,699 33,571 10,659 152% 10,000$ 35,000$ 25,000$ 250% 66445 52407 REP&MAINT:SEWERS 2,450 4,032 5,773 2,950 54% 15,000$ 15,000$ -$ 0% 66445 53100 PROFESSIONAL SERVICES 73,975 79,890 129,544 77,955 32% 200,000$ 200,000$ -$ 0% 66445 53401 COMM:TELEPHONE - - - - na -$ 2,500$ 2,500$ na 66445 53402 COMM:POSTAGE 10,000 10,500 - 12,558 (100%) 18,000$ 18,000$ -$ 0% 66445 53803 OTHER: LICENSE - - - - na -$ -$ -$ na 66445 54201 OFFICE SUPPLIES 3,071 - - 1,024 (100%) -$ -$ -$ na 66445 54701 SAFETY:UNIFORMS - - - - na -$ 10,000$ 10,000$ na 66445 54702 SAFETY:PROTECTIVE CLOTHING - - - - na 10,000$ 10,000$ -$ 0% 66445 55302 INVENTORY SUPPLIES - - 11,570 173 na 520$ 520$ -$ 0% 66445 57101 IN-STATE:MISC TRAVEL 302 - - 101 (100%) -$ -$ -$ na SEWER ENTERPRISE FUND OPERATIONS BUDGET FY2020 BUDGET PROJECTION 3-YEAR ACTUAL DEPT ACCOUNT ACCOUNT NAME FY2020 BUDGET $ INC/(DEC) FY20 / FY19 BUDGET % INC/(DEC) FY20 / FY19 BUDGET SIMPLE AVERAGE FY2017 ACTUAL FY2016 ACTUAL FY2019 BUDGET COMPOUND ANNUAL GROWTH RATE FY2018 ACTUAL 66445 57502 INS: WORKMANS COMP - - - 36 na 2,500$ 2,500$ -$ 0% 66445 57404 INS PREM:BLANKET INS, BLDG 11,437 - - 7,731 (100%) 14,482$ 14,482$ -$ 0% 66445 57111 TRAINING-OSHA-PROFFESSIONAL DEVELOP - - 50,000$ 50,000$ na 66445 59991 TRANSFER TO GENERAL FUND - - - - na -$ -$ -$ na TOTAL REVENUE -$ -$ -$ -$ na -$ -$ -na TOTAL EXPENSE 281,660$ 269,021$ 248,760$ 283,043$ (6%) 781,182$ 893,682$ 112,500 14% SCONSET WATER TREATMENT 66446 51100 SALARY, PERMANENT 76,151 76,652 80,844 75,426 3% 76,600$ 76,600$ -$ 0% 66446 51300 OVERTIME 2,334 2,634 7,961 2,606 85% 6,610$ 6,610$ -$ 0% 66446 51700 LONGEVITY PAY 2,186 2,273 - 2,235 (100%) 6,000$ 6,000$ -$ 0% 66446 51701 INS:MED BLUE CROSS 10,143 11,037 11,016 10,056 4% 13,883$ 13,883$ -$ 0% 66446 51961 MEDICARE P/R TAX 1,170 1,183 1,288 1,164 5% 1,465$ 1,465$ -$ 0% 66446 52101 UTILITY:ELECTRICITY 60,715 54,280 51,541 55,578 (8%) 55,000$ 55,000$ -$ 0% 66446 52103 UTILITY:FUEL - - - 4,794 na 18,000$ 18,000$ -$ 0% 66446 52105 UTILITY:WATER 1,496 1,353 1,755 1,377 8% 1,800$ 1,800$ -$ 0% 66446 52403 REP&MAINT VEHICLE - - - - na 6,000$ 31,000$ 25,000$ 417% 66446 52404 REP&MAINT:BUILDING - 1,024 11,932 2,330 na 10,000$ 35,000$ 25,000$ 250% 66446 52405 REP&MAINT:EQUIPMENT 15,514 5,004 628 11,204 (80%) 50,000$ 50,000$ -$ 0% 66446 53100 PROFESSIONAL SERVICES 1,765 (727) - 950 (100%) 60,000$ 60,000$ -$ 0% 66446 53115 LAB TESTING 1,946 2,005 4,588 1,840 54% 1,200$ 1,200$ -$ 0% 66446 53401 COMM:COMCAST INTERNET - 1,776 1,861 592 na 2,000$ 2,000$ -$ 0% 66446 53402 COMM: POSTAGE - - - - na 200$ 200$ -$ 0% 66446 53804 OTHER:FREIGHT - - - - na -$ -$ -$ na 66446 54201 OFFICE SUPPLIES - - - - na 1,000$ 1,000$ -$ 0% 66446 54701 SAFETY: UNIFORMS - - - - na 5,000$ 5,000$ -$ 0% 66446 55302 INVENTORY SUPPLIES - 247 5,713 441 na 2,000$ 2,000$ -$ 0% 66446 55306 CHEMICALS 8,403 4,735 14,455 4,878 31% 2,500$ 2,500$ -$ 0% 66446 57101 IN STATE: MISC TRAVEL - - - 261 na -$ -$ -$ na 66446 57111 TRAINING-OSHA-PROFFESSIONAL DEVELOP - - 50,000$ 50,000$ na 66446 57404 INS PREM: BLANKET INS, BLDG 27,620 - - 18,238 (100%) 33,380$ 33,380$ -$ 0% 66446 57502 INS: WORKMAN'S COMP - - - - na 2,500$ 2,500$ -$ 0% TOTAL EXPENSE 209,442$ 163,475$ 193,582$ 193,972$ (4%) 355,138$ 455,138$ 100,000$ 28% SEWER ENTERPRISE FUND OPERATIONS BUDGET FY2020 BUDGET PROJECTION 3-YEAR ACTUAL DEPT ACCOUNT ACCOUNT NAME FY2020 BUDGET $ INC/(DEC) FY20 / FY19 BUDGET % INC/(DEC) FY20 / FY19 BUDGET SIMPLE AVERAGE FY2017 ACTUAL FY2016 ACTUAL FY2019 BUDGET COMPOUND ANNUAL GROWTH RATE FY2018 ACTUAL SEWER ENTERPRISE GRAND TOTAL TOTAL REVENUE (7,205,670)$ (7,402,150)$ (7,490,202)$ (7,129,145)$ 2% (7,387,820)$ (7,387,820)$ -$ - TOTAL EXPENSE 6,916,474$ 7,532,682$ 6,970,464$ 6,781,162$ 0% 8,070,335$ 8,557,835$ 487,500$ 6% VARIANCE (Excess) / Deficit (289,197)$ 130,531$ (519,738)$ (347,983)$ 34% 682,515$ 1,170,015$ 487,500$ 71% SOURCE: RETAINED EARNINGS*289,197$ (130,531)$ 519,738$ 347,983$ 34% (682,515)$ (1,170,015)$ (487,500)$ (71%) REMAINING VARIANCE -$ -$ -$ -$ na -$ -$ -$ - FY 2019 Personnel Spreadsheet Sewer Enterprise Fund Number of Positions in Department ORG: 66440 ORG: 66445 ORG: 66446 Full-time 12 3 1 Part-time 0 0 0 Seasonal 0 0 0 Temporary 0 0 0 Vacancies 1 0 0 New Positions Requested 2 2 0 TOTAL OF ALL POSITIONS 15 5 1 Name Position Avg Hours Per Week Job Code Class & Step as of 6/30/18 (e.g., B -Step 3) Yearly Salary as of 6/30/18 FY2019 Anniversary Date FY2020 Projected Salary Longevity Pay Education Pay Certification Pay Holiday Pay Other Total by Employee ORG: 66440 GRAY, D.SEWER DIRECTOR 40.00 PW77 NON-UNION 117,600 11/07/19 119,500 0 0 0 0 0 119,500 MANNING, K CHIEF WWTP 40.00 PW47 NON-UNION 96,000 110,700 0 0 0 0 0 110,700 VACANT - FUNDED ASST. CHIEF WWTP 40.00 PW44 M6 STEP 1 62,600 03/01/19 66,200 0 0 0 0 0 66,200 VACANT - FUNDED GENERAL FOREMAN SEWER PLANT 40.00 PW31 M6 STEP 7 79,700 07/11/19 81,300 3,300 0 0 0 0 84,600 ALLEN, P.OPERATOR WWTP 40.00 PW43 M5 STEP 3 68,500 07/11/19 69,900 0 0 0 0 0 69,900 LEVEILLE, W.SEWER LAB TECH 40.00 PW42 M4 STEP 7 74,700 07/11/19 76,300 3,100 0 0 0 0 79,400 MOONEY, S.OPERATOR WWTP 40.00 PW43 M5 STEP 7 77,100 07/11/19 78,600 0 0 0 0 0 78,600 DIAS,K (PROMOTION)MAINT TECH SEWER 40.00 PW41 M4 STEP 1 62,700 07/11/19 63,900 0 0 0 0 0 63,900 RICHARDS,D OPERATOR WWTP 40.00 PW56 M3 STEP 1 59,600 07/11/19 60,800 0 0 0 0 0 60,800 JOHNSON, C.WWTP OPERATOR 40.00 PW56 M3 STEP 1 59,600 09/17/19 60,500 0 0 0 0 0 60,500 WORTH,TODD OPERATOR WWTP 40.00 M3 STEP 1 09/09/19 58,000 WORTH,ERIK OPERATOR WWTP 40.00 M3 STEP 1 10/09/19 58,000 KEBBATI, L.OFFICE MANAGER 40.00 PW20 S3PO STEP 1 67,000 08/01/19 69,700 0 0 0 0 0 69,700 HERRMANN,CHRISTINE OFFICE ADMIN 40.00 S1 STEP 1 56,000 REQUESTED - VACANT ENGINEER / COMPLIANCE 40.00 NON-UNION 100,000 ORG: 66445 GORDON, T.SEWER COLLECTIONS 40.00 PW56 M3 STEP 1 59,600 07/11/19 60,800 0 0 0 0 0 60,800 SMITH, K.SEWER COLLECTIONS 40.00 PW56 M3 STEP 2 55,500 07/11/19 62,600 0 0 0 0 0 62,600 DWYER,M SEWER COLLECTIONS 40.00 PW56 M3 STEP 1 55,500 08/17/19 60,600 0 0 0 0 0 60,600 ORG: 66446 INGLIS, R.PLANT MANAGER 40.00 PW10 M6 STEP 7 79,700 07/11/19 81,300 4,100 0 0 0 0 85,400 org:66440 org: 66445 org:66446 1,129,400 184,000 81,300 0 0 0 6,400 0 4,100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 90,000 15,000 20,610 1,225,800 199,000 106,010 15,332 4,343 1,465 369,266 134,737 13,883 1,610,398 338,080 121,358 ORG: 66440; 66445; 66446 Total 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 Subtotal Medicare (enter on Munis 51961) Insurance:Medical BSBC (enter Munis 51701)