Loading...
HomeMy WebLinkAboutAgenda Packet - Finance & Human Resources Committee - 02/27/2018F IN A N C E A N D HUMA N RES O URC ES C O MMIT T EE February 27, 2018 - 3:30 PM 31111 Greenspot Road, Highland C A 92346 AGE N D A C A LL TO O RD ER PLED G E O F A LLEG IA N C E PUBLIC C O MMEN T S N E W B U SI N E SS 1.Review the FY 2017-18 Mid-Year Budget Revisions AD J O U RN P LEAS E NO T E: P urs uant to G overnment C ode S ec tion 54954.2(a), any reques t for a dis ability-related modification or ac commodation, including auxiliary aids or services, that is s ought in order to partic ipate in the above- agendized public meeting should be direc ted to the District C lerk at (909) 885-4900 at least 72 hours prior to said meeting. S TAF F R E P ORT Agenda Item #1. Meeting Date: F eb ruary 27, 2018 To: F I N ANC E AND HUMAN R ES O UR C ES C O MMI T T E E F rom: G eneral Manager/C EO Subject: R eview the F Y 2017-18 Mid-Year Budget R evis io ns R E C O MME N D AT IO N: S taff recommends that the F inance and Human R es o urc es C o mmittee (C ommittee) review amend ments to the F Y 2017-18 O p erating and C apital Bud gets . B AC KGR O UN D / AN ALYS IS : T he 2017-18 Mid -Year Budget R eview is p res ented for the C o mmittees ’ review and c onsideratio n. T his analys is and p roc es s pro vides the C o mmittee the o p p o rtunity to review the s tatus o f the operating and c ap ital b ud gets as o f Dec ember 31st, and to c o ns ider rec o mmend ed adjus tments . At the 1st Q uarter bud get review held in No vember, it was dis closed that water s ales were s lightly b elo w p ro jectio n, and that a large c ap ital p ro jec t related to water treatment would not be needed. As a res ult, s everal ad justments were mad e to the C apital Improvement P rogram, and a temp o rary C ontingenc y R es erve of $500,000 was es tablis hed fo r needs aris ing later in the fis cal year. At mid -year, water s ales have inc reas ed significantly, to the p o int where s taff is rec o mmend ing an adjus tment to the annual s ales projec tion and the water s ales b udget. S taff has als o been monitoring pro gram and c ap ital expend itures thro ugh Dec ember, and are reques ting bud get ad jus tments to provid e res o urc es fo r unexpec ted expens es , or to take ad vantage of opportunities that will enhanc e the value o f s ervic es provided to o ur ratep ayers T he requested bud get ad justments, and jus tificatio ns therefore, are desc rib ed belo w. Revenues Water s ales were $519,000 over p ro jectio n through December, at $9,554,906. T his variance is due to unusually warm weather in the November and Dec emb er mo nths whic h resulted in many R es idential and Irrigatio n cus tomers having s ignific ant us age in Tier 3. T he chart b elo w pres ents cus to mer water us age by Tier for the s ix months end ed Dec emb er 31st. Tier1 and 2 s ales were 1.8% and 0.6%, res p ectively, below p ro jectio n, whic h ind icates that s ome c us tomers did stay within their water bud gets . However, Tier 3 s ales were mo re than $600,000, or 32%, over projec tio n. T he warm weather has c o ntinued into January and F ebruary res ulting in high water s ales fo r thos e months as well. Based on the variance through Decemb er, and knowing that sales have c o ntinued to exceed projec tio n in the c urrent q uarter, s taff is rec ommend ing a $500,000 inc rease to b udgeted water s ales as a mid-year b udget ad justment. Meter C harge revenue was $45,000 over p ro jec tion at $4,471,000 through December, repres enting 50.5% o f the annual b udget. T he o verage is the result o f higher than antic ip ated use o f construc tion meters , b ut is no t s ignificant eno ugh fo r s taff to rec o mmend an adjus tment to bud geted meter c harge revenue. Investment Inc ome, P enalties, and O ther C harges are at 74% o f bud get through Dec ember 31s t, b ut staff is no t recommending a bud get ad jus tment to thes e revenue items at mid-year. Expenditures T hro ugh December, total exp enditures were at $17,060,928, whic h is 47% of $36,207,000 b udgeted expend itures fo r the year. Expenditures are belo w 50% at mid -year b ec ause o f two major cost c ategories, water s upply c osts and c apital exp enditures : Water sup p ly costs are at les s than 5% of bud get at mid -year b ecaus e Valley Dis trict is not d ue p ayment fo r purc hased water in January, and No rth F ork assessments are paid in May, after the No rth F ork Water C o mpany annual sharehold er meeting. C apital exp end itures are at 19% o f b udget at mid-year bec aus e three large projec ts representing more than $3 millio n are s till in the planning s tages and will not be und er cons truc tion until at leas t April. W hile the above items do not req uire bud get adjus tments , staff is req ues ting adjus tments fo r the fo llowing items s o that pro grams will have ad eq uate res o urc es to fulfill program go als and o b jec tives . P ers o nnel Expens es – the fo llowing s taffing c hanges and bud get inc reas es are reques ted in o rd er to sup p o rt the inc reas ed roles and res p o ns ib ilities plac ed on certain staff members in imp lementing the Dis tric t’s strategic initiatives : P romote Adminis tration and F inanc e Dep artment Ad minis trative As s is tants to S enio r Ad minis trative As sistants . R ec las s ify P ublic Affairs Manager to Directo r of S trategic S ervices. C o nvert a p art-time P ublic Affairs R epresentative to a full-time C reative S ervic es R ep res entative. Eliminate an Engineering Technic ian positio n (vacant since Novemb er) and add an As s o ciate Engineer p o sitio n. Inc reas e O vertime needed for weekend monitoring at P lant 134 and for was tewater mainline c leaning. T he b udget imp act of these c hanges would be approximately $65,000 for the remainder o f 2017-18, and wo uld b e funded by re-purposed temporary res erves set as ide from the firs t q uarter review. S taff is als o reques ting that a o ne-time expend iture of $500,000 be us ed to pay d own long-term o b ligatio ns related to p o s t-emplo yment benefits . Inc reas ed water s ales , as p rojec ted, would b e used to fund this expend iture. C o ntrac t S ervic es – Vario us departments are reques ting an inc rease to their c ontrac t services bud gets to o verc o me unanticipated overlooked servic es need ed at the time the original b udget was b eing p rep ared . T hey inc lude: Ad minis tratio n is requesting an additio nal $100,000 fo r legal s ervic es as litigation (that was dec id ed in the District’s favo r) has us ed most of the P ro gram’s legal bud get fo r 2017-18. Human R esources is reques ting $25,000 to have a c o nsultant c o ntinue working o n organizational s tructure inc lud ing the S terling Natural R esourc e C enter. C us tomer S ervice req ues ts an additio nal $15,000 to cover the unantic ip ated c o s t o f rep o s itioning cub icles to allow better vis ib ility of the cus tomer c o unter. Meter S ervic es needs an additio nal $3,000 to p ro vid e a full s et of unifo rms fo r a new emp lo yee. Water Treatment/F acilities Maintenanc e have reques ted $80,000 fo r s ecurity services at P lant 134 due to the “ac tive” homeless p o p ulation in C ity C reek near the plant. F leet Maintenanc e - $30,000 for generato r maintenance and c ar was h. T he $255,000 in C ontract S ervic es increas es outlined above would be funded b y tempo rary res erves identified d uring the firs t q uarter b udget review. Capital Expenditures S taff has evaluated the C apital Budget and the info rmation that has b ecome availab le s inc e the C I P d is cus s io ns d uring the firs t q uarter review, and is reques ting that the following ad justments b e approved at mid -year: Taylor Road Main E xtensions / S ervice Relocations – T his new pro ject wo uld add s hort main extens io ns to an exis ting main in Taylor R o ad to mitigate a s ituation where multip le properties are s erved by four s hared s ervic e lines . T he shared lines c ross private property b o undaries, a po int whic h makes ad d res s ing leaks in the s ervic e line very c hallenging for all parties . District crews can install the main extens io ns and ins tall new servic e lines to eac h o f 12 properties in les s than 40 ho urs . Total projec t c o s t inc lud ing paving will b e app ro ximately $125,000. Automated Metering Infrastructure (AMI) – T he original 2017-18 b udget d id not inc lude fund ing fo r p has e 2 of the AMI p ro ject, ho wever, the Board ap p ro ved re-purposing $500,000 at the 1st Q uarter bud get review to keep the AMI p ro jec t mo ving fo rward . S taff has been wo rking with F ergus o n Waterwo rks to id entify the meter ro utes fo r p has e 2 that wo uld provide the greatest value to District ratepayers. C o mp letion o f nine ro utes will auto mate all meters west o f S terling Avenue, and remove routes fro m s o me o f the larges t cycles s till being read manually – an ad d itio nal $55,000 is needed for materials and installation to acc o mp lish this with P has e 2. Acc o rd ingly, staff is reques ting a $55,000 increase to the AMI b udget. S ummary T he table belo w presents a s ummary o f actual expend itures year-to-date, the ad o p ted bud get, and propos ed amendments to the b udget. P ro p o s ed amendments to expend itures total $1,000,000 to be fund ed by the $500,000 c o ntingency reserve s et as ide fro m the 1st Q uarter b udget review and $500,000 from increas ed water s ales . D escription Actual YT D Adopted Budget P roposed Amendments Amended B udget Revenue S ales $ 11,907,099 $ 19,045,000 $ 500,000 $ 19,545,000 O ther R evenue 9,468,056 17,579,000 -17,579,000 Total R evenue $ 21,375,155 $ 36,624,000 $ 500,000 $ 37,124,000 Expenditures Labor & Benefits $ 4,559,409 $9,392,000 $ 565,000 $ 9,957,000 Water S up p ly 647 801,000 -801,000 Elec tric ity 1,084,509 1,700,000 -1,700,000 Treatment S ervic es 4,399,360 7,900,000 -7,900,000 Materials 651,509 1,042,000 -1,042,000 C ontrac t S ervices 2,008,493 4,678,000 255,000 4,931,000 O ther O perating Exp.402,848 1,581,000 -1,581,000 Debt S ervic e 3,142,504 4,315,000 -4,315,000 C apital Expend itures 811,649 4,298,000 180,000 4,475,500 Temp o rary C ontingenc y R es erves -500,000 (500,000)- Total Expenditures $ 17,060,928 $ 36,207,000 $ 500,000 $ 36,707,000 R ecommended b y: Jo hn Mura G eneral Manager/C EO R espec tfully sub mitted: Brian Tomp kins C hief F inancial O ffic er A d etailed sc hedule of propos ed adjus tments to C apital Expend itures is attac hed . AG E N C Y G O ALS AN D OB J E C T IVE S : R E VIE W B Y O T HE R S : T his agenda item has been reviewed by the Ad minis tratio n and F inanc e departments. F IS C AL IMPAC T If approved, staff ’s recommended mid -year adjus tments to the o p erating and c ap ital b udgets ’ amend ments to taling $1 millio n will be fund ed $500,000 by increased water s ales , and $500,000 with the temporary C ontingenc y R es erves set up in the first quarter. ATTACH M E N TS: Description Type Board P resentation P resentation Budget Reports Backup Material Salary Table Backup Material Capital Expenditures Backup Material FY 2017-18 MID-YEAR REVIEW February 28, 2018 OPERATING BUDGET REVIEW FISCAL YEAR 2017-18 WATER FUND SUMMARY 3 Revenue Budget YTD Actual YTD %Projected Water Sales 14,500,000$ 9,554,906$ 66%15,000,000$ Meter Charges 8,845,000 4,471,715 51%8,845,000 Other Charges / Revenue 702,000 569,748 81%702,000 Total Revenue 24,047,000$ 14,596,369$ 61%24,547,000$ Expenses Budget YTD Actual YTD %Projected Labor & Benefits 7,304,600$ 3,554,048$ 49%7,287,100$ Other Operating Expenses 8,218,400 3,554,095 43%8,431,400 Capital Expenditures 4,105,000 156,454 4%4,205,000 Debt Service 4,002,000 2,937,641 73%4,502,000 Transfer To Reserves 417,000 - 0%417,000 Total Expenses 24,047,000$ 10,202,238$ 42%24,842,500$ Net -$ 4,394,131$ -$ 4 WATER SALES ANALYSIS Tier 1 $0 Tier 2 $150,000 Tier 3 $350,000 Projected Revenue Increase in Sales 5 Residential SFR $125,000 Multi-Family $75,000 Commercial $150,000 Irrigation $150,000 Projected Revenue Increase in Sales WATER SALES ANALYSIS WASTEWATER FUND SUMMARY 6 Revenue Budget YTD Actual YTD %Projected Collection System Charges 4,545,000$ 2,352,192$ 52%4,545,000$ Treatment Charges 7,900,000 4,379,006 55%7,900,000 Other Charges / Revenue 132,000 47,587 36%132,000 Total Revenue 12,577,000$ 6,778,785$ 54%12,577,000$ Expenses Budget YTD Actual YTD %Projected Labor & Benefits 2,087,400$ 1,005,361$ 48%2,087,400$ Other Operating Expenses 9,383,600 4,993,272 53%9,383,600 Capital Expenditures 793,000 655,195 83%693,000 Debt Service 313,000 204,863 65%313,000 Transfer from Reserves (478,000) - 0%(478,000) Total Expenses 12,099,000$ 6,858,690$ 57%11,999,000$ Net 478,000$ (79,905)$ 578,000$ PROGRAM SUMMARIES 8 GENERAL ADMINISTRATION GOAL % COMPLETE Provide Administrative Support to the Governing Board 50 Reduce Expenditures on Document Storage and Improve Records Management 70 Promote Environmental Stewardship 70 Ensure Programs Remain in Compliance with Public Record Requirements 60 65% BUDGET FY 2017-18 YTD PROJECTED FY 2017-18 % CHANGE $1,201,000 $730,736 $1,306,000 8.74% 9 HUMAN RESOURCES GOAL % COMPLETE Promote a Positive Organizational Culture 75 Enhance the District’s Wellness Initiatives 85 Develop a Workforce Readiness Program 60 Implement a District Volunteer Program 45 70% BUDGET FY 2017-18 YTD PROJECTED FY 2017-18 % CHANGE $845,000 $492,537 $870,000 2.96% 10 PUBLIC AFFAIRS GOAL % COMPLETE Implement Outreach Efforts that Support the Brand and Develop Community Presence 50 Cultivate Customer Relationships and Strengthen the District’s Presence in the Community 58 Maintain the District’s Emergency Preparedness Standards 48 55% BUDGET FY 2017-18 YTD PROJECTED FY 2017-18 % CHANGE $828,000 $317,072 $868,000 4.83% 11 CONSERVATION GOAL % COMPLETE Maintain Compliance with SWRCB Conservation Standards 67 Continue Water Conservation Outreach with the Community 61 Evaluate and Measure Success of Rebate Programs 52 60% BUDGET FY 2017-18 YTD PROJECTED FY 2017-18 % CHANGE $575,000 $186,295 $575,000 0.00% 12 FINANCE GOAL % COMPLETE Engage Stakeholders in Planning for Use of Public Funds 90 Enhance Financial Reporting to Internal / External Stakeholders 13 Maintain Strong Financial Position and Credit Rating 38 Integrate Systems to Enhance Financial Planning 75 55% BUDGET FY 2017-18 YTD PROJECTED FY 2017-18 % CHANGE $1,182,000 $553,016 $1,187,000 0.42% 13 INFORMATION TECHNOLOGY GOAL % COMPLETE Improve Cybersecurity 63 Increase Utilization of Existing Technology 70 Secure, Reliable Technology Infrastructure 33 60% BUDGET FY 2017-18 YTD PROJECTED FY 2017-18 % CHANGE $963,000 $431,817 $963,000 0.00% 14 CUSTOMER SERVICE GOAL % COMPLETE Strive for World Class Public Service 50 Improve Departmental Processes 50 Promote Customer Use of Most Cost Effective Processes 67 60% BUDGET FY 2017-18 YTD PROJECTED FY 2017-18 % CHANGE $1,749,000 $828,840 $1,764,000 0.86% 15 METER SERVICES GOAL % COMPLETE Become Proficient in New AMI Meter Reading Equipment and Processes 58 Collect Information on Existing Meters to Facilitate Future Phases of AMI Implementation 88 Provide Highly Professional and Timely Response to Customer Service Requests 50 70% BUDGET FY 2017-18 YTD PROJECTED FY 2017-18 % CHANGE $397,000 $186,986 $400,000 0.76% 16 ENGINEERING GOAL % COMPLETE Provide Leadership in the Development and Implementation of the District’s CIP 21 Partner with Other Agencies to Benefit District and Region 44 Implement Modernization Programs and/or Software to Track Customer Service Efficiency 43 40% BUDGET FY 2017-18 YTD PROJECTED FY 2017-18 % CHANGE $1,527,000 $655,178 $1,527,000 0.00% 17 WATER PRODUCTION GOAL % COMPLETE Ensure System Reliability Through Routine System Inspections and Testing 55 Continue to Evaluate SCADA Network and Implement Improvements 88 Partner with Southern California Edison to Take Advantage of Equipment Rehabilitation Incentives 70 75% BUDGET FY 2017-18 YTD PROJECTED FY 2017-18 % CHANGE $4,072,000 $1,597,872 $4,072,000 0.00% 18 WATER TREATMENT GOAL % COMPLETE Identify Plant 134 Process Improvements to Enhance Water Quality 76 Evaluate Use of Hydro-Generation Technology at Plant 134 37 Develop Standard Operating Procedures for Hydro-Generation Plant 38 55% BUDGET FY 2017-18 YTD PROJECTED FY 2017-18 % CHANGE $890,000 $381,262 $1,038,000 16.63% 19 WATER QUALITY GOAL % COMPLETE Provide Safe and Reliable Water to Customers •Complete State Required Sampling •Collect Source Water Quality Data •Pilot Studies of Advanced Treatment Processes 54 Convert Flush-Outs to Control Water Discharge 40 Evaluate Effectiveness of New Backflow Program 50 50% BUDGET FY 2017-18 YTD PROJECTED FY 2017-18 % CHANGE $410,000 $177,514 $415,000 1.22% 20 WATER MAINTENANCE GOAL % COMPLETE Evaluate Preventative Maintenance Programs for Effectiveness 38 Partner with Other Local Agencies to Enhance Service to the Community 80 Encourage Continued Education to Support Advancement Opportunities 75 65% BUDGET FY 2017-18 YTD PROJECTED FY 2017-18 % CHANGE $2,241,000 $1,198,301 $2,211,000 -1.34% 21 WASTEWATER MAINTENANCE GOAL % COMPLETE Utilize Granite Net Software to Document Wastewater Collection System Maintenance 50 Begin Evaluation of Fats, Oil, and Grease (FOG) Entering the Wastewater Collection System 31 Continue to Improve Wastewater Collection System Maintenance Program 45 45% BUDGET FY 2017-18 YTD PROJECTED FY 2017-18 % CHANGE $8,593,000 $4,644,809 $8,625,000 0.37% 22 FACILITIES MAINTENANCE GOAL % COMPLETE Explore Alternative Energy Solutions for District Facilities 75 Continue Facilities Improvement Planning 65 Develop Comprehensive Facilities Preventative Maintenance Program 8 50% BUDGET FY 2017-18 YTD PROJECTED FY 2017-18 % CHANGE $776,000 $386,183 $816,000 5.15% 23 FLEET MAINTENANCE GOAL % COMPLETE Ensure Readiness Equipment and Staff for Emergency Responses 50 Develop Cost Recovery Program for Vehicle Replacement 40 Identify and Utilize Most Cost Effective Maintenance Methods 75 55% BUDGET FY 2017-18 YTD PROJECTED FY 2017-18 % CHANGE $516,000 $271,351 $548,000 6.20% 24 GOVERNING BOARD GOAL % COMPLETE Provide Organization Direction and Set Expectations 70 Increase Community Involvement 50 Address Project Related Agenda Items Including SNRC 50 Continue Efforts to Enhance District Identity as a Regional Leader 50 55% BUDGET FY 2017-18 YTD PROJECTED FY 2017-18 % CHANGE $229,000 $67,005 $229,000 0.00% CAPITAL BUDGET CAPITAL OUTLAY CAPITAL OUTLAY 26 Multi-Year Rate Study Water/Wastewater Operating Revenue -$ -$ -$ Water Master Plan Update Water Operating Revenue 200,000 - 200,000 Wastewater Master Plan Update Wastewater Operating Revenue 135,000 - 135,000 Emergency Generator Water Operating Revenue 95,000 - 95,000 Furniture and Equipment Water/Wastewater Operating Revenue 41,000 - 41,000 Computer Hardware/Software Water/Wastewater Operating Revenue 70,000 - 70,000 Service Trucks Water Operating Revenue 145,000 - 145,000 Total 686,000$ -$ 686,000$ Project Funding Source Adjusted Budget Proposed Mid-Year Adjustment Projected Budget CAPITAL BUDGET CAPITAL IMPROVEMENT PROJECTS CIP –PROPOSED ADJUSTMENTS 28 AMI Meter Retrofit Program Water Operating Revenue 500,000$ 55,000$ 555,000$ Transmission Main - Plant 134 to Upper Zone Water Operating Revenue 2,085,000 - 2,085,000 Plant 134 THM Treatment / Sludge Removal Water Operating Revenue 650,000 - 650,000 Facility Rehabiliations Water Operating Revenue 225,000 - 225,000 Pumalo Casa/Taylor Road Pipeline Water Operating Revenue - 125,000 125,000 Wastewater Main Rehabilitation - 4th St Wastewater Operating Revenue 100,000 - 100,000 Total Proposed Mid-Year Adjustments 3,560,000 180,000 3,740,000 Project Funding Source Adjusted Budget Proposed Mid-Year Adjustment Projected Budget CIP –NO PROPOSED ADJUSTMENTS 29 Habitat Conservation Plan -$ -$ -$ Canal Zone Storage Reservoir Reserves, Developer Fees 630,000 - 630,000 Transmission Main - Plant 134 to Canal Zone - - - Plant 140 - Tank Recoating - - - Plant 9 - Forebay Repair Water Operating Revenue 350,000 - 350,000 Plant 59 - Tank Recoating Water Operating Revenue 250,000 - 250,000 Facilities Relocations Water Operating Revenue 100,000 - 100,000 Wastewater Main Replacement - Orange St Reserves 75,000 - 75,000 Wastewater Main Rehabilitation - Paloma Rd Phase II Wastewater Operating Revenue 105,000 - 105,000 Wastewater Main Replacement - Ferndale Ave Wastewater Operating Revenue 210,000 - 210,000 City Creek Manhole Reloaction Wastewater Operating Revenue 150,000 - 150,000 Sterling Natural Resource Center (SNRC) Water/Wastewater Operating Revenue, Reserves 675,000 - 675,000 3,560,000 180,000 3,740,000 Total 6,105,000$ 180,000$ 6,285,000$ Subtotal Proposed Mid-Year Adjustments Project Funding Source Adjusted Budget Projected Budget Proposed Mid-Year Adjustment STAFFING CHANGES 31 PROPOSED STAFFING CHANGES Department Current Position Proposed Position Administration Administrative Assistant Senior Administrative Assistant Public Affairs Public Affairs- Conservation Manager Director of Strategic Services Public Affairs Graphic Designer Creative Services Representative Finance Administrative Assistant Senior Administrative Assistant Engineering Engineering Technician II Associate Engineer *Proposed Adjustments are Reflected in Department Summaries ACCOMPLISHMENTS 33 ACCOMPLISHMENTS •AMI Project Phase I •Paloma and 4th Street Sewer Rehabilitation •North Fork Water Company Appraisal Report •CA Municipal Treasurer’s Association Investment Policy Certification •Popular Annual Financial Report •3rd Leadership Academy Class Graduation 34 AWARDS •Press Enterprise Top Workplace •GFOA Distinguished Budget •GFOA Comprehensive Annual Financial Reporting FY 2017-18 Budget FY 2017-18 Percent Budget YTD Activity Adjustment Projected Change Revenue 4100 - Water Sales 14,500,000.00 9,554,906.24 500,000.00 15,000,000.00 4200 - Meter Charges 8,845,000.00 4,471,715.19 - 8,845,000.00 4301 - Penalties 485,500.00 331,456.26 - 485,500.00 4400 - Wastewater Collection 4,545,000.00 2,352,192.40 - 4,545,000.00 4500 - Wastewater Treatment 7,900,000.00 4,379,006.44 - 7,900,000.00 4600 - Other Operating Charges 201,500.00 171,968.50 - 201,500.00 4700 - Investment Income 97,000.00 70,765.95 - 97,000.00 4703 - Energy Incentive Rebates - - - - 4704 - Miscellaneous Revenue 50,000.00 43,143.67 - 50,000.00 36,624,000.00 21,375,154.65 500,000.00 37,124,000.00 1.37% Program: 1000 - Board of Directors d of 51 - Labor 105,000.00 42,525.00 - 105,000.00 d of 52 - Temporary Labor - - - - d of 53 - Overtime - - - - d of 54 - Standby - - - - d of 56 - Benefits 57,000.00 16,224.85 - 57,000.00 d of 61 - Water Supply - - - - d of 62 - Materials and Supplies 1,000.00 - - 1,000.00 d of 63 - Contract Services 11,000.00 341.15 - 11,000.00 d of 64 - Utilities - - - - d of 65 - Professional Development 55,000.00 7,913.72 - 55,000.00 d of 67 - Other - - - - d of Total 229,000.00 67,004.72 - 229,000.00 0.00% Program: 2000 - General Administration ral A51 - Labor 486,000.00 206,183.80 5,000.00 491,000.00 ral A52 - Temporary Labor - - - - ral A53 - Overtime - 1,272.18 - - ral A54 - Standby - - - - ral A56 - Benefits 245,000.00 127,103.70 - 245,000.00 ral A61 - Water Supply - - - - ral A62 - Materials and Supplies 8,000.00 899.47 - 8,000.00 ral A63 - Contract Services 347,000.00 333,045.40 100,000.00 447,000.00 ral A64 - Utilities 3,000.00 1,566.57 - 3,000.00 ral A65 - Professional Development 112,000.00 60,665.35 - 112,000.00 ral A67 - Other - - - - ral A Total 1,201,000.00 730,736.47 105,000.00 1,306,000.00 8.74% Program: 2100 - Human Resources an R51 - Labor 211,000.00 96,703.58 - 211,000.00 an R52 - Temporary Labor 12,000.00 2,592.00 - 12,000.00 an R53 - Overtime 3,000.00 1,116.31 - 3,000.00 an R54 - Standby - - - - an R56 - Benefits 100,000.00 59,009.56 - 100,000.00 an R61 - Water Supply - - - - an R62 - Materials and Supplies 20,000.00 2,532.29 - 20,000.00 an R63 - Contract Services 89,000.00 41,807.22 25,000.00 114,000.00 an R64 - Utilities 1,000.00 314.51 - 1,000.00 an R65 - Professional Development 39,000.00 20,689.16 - 39,000.00 an R67 - Other 370,000.00 267,772.68 - 370,000.00 an R Total 845,000.00 492,537.31 25,000.00 870,000.00 2.96% DISTRICT WIDE FY 2017-18 MID-YEAR BUDGET REVIEW JULY 1, 2017 - DECEMBER 31, 2017 Page 1 of 15 FY 2017-18 Budget FY 2017-18 Percent Budget YTD Activity Adjustment Projected Change DISTRICT WIDE FY 2017-18 MID-YEAR BUDGET REVIEW JULY 1, 2017 - DECEMBER 31, 2017 Program: 2200 - Public Affairs c Aff51 - Labor 347,000.00 139,107.78 31,000.00 378,000.00 c Aff52 - Temporary Labor - - - - c Aff53 - Overtime 7,000.00 3,151.44 - 7,000.00 c Aff54 - Standby - - - - c Aff56 - Benefits 129,000.00 73,686.39 9,000.00 138,000.00 c Aff61 - Water Supply - - - - c Aff62 - Materials and Supplies 77,000.00 11,645.24 - 77,000.00 c Aff63 - Contract Services 206,000.00 80,183.84 - 206,000.00 c Aff64 - Utilities 35,000.00 879.78 - 35,000.00 c Aff65 - Professional Development 27,000.00 8,417.67 - 27,000.00 c Aff67 - Other - - - - c Aff Total 828,000.00 317,072.14 40,000.00 868,000.00 4.83% Program: 2300 - Conservation erva51 - Labor 98,000.00 45,269.73 - 98,000.00 erva52 - Temporary Labor - - - - erva53 - Overtime 8,000.00 - - 8,000.00 erva54 - Standby - - - - erva56 - Benefits 32,000.00 24,164.61 - 32,000.00 erva61 - Water Supply - - - - erva62 - Materials and Supplies 223,000.00 107,839.51 - 223,000.00 erva63 - Contract Services 187,000.00 6,647.28 - 187,000.00 erva64 - Utilities 21,000.00 362.63 - 21,000.00 erva65 - Professional Development 6,000.00 2,011.00 - 6,000.00 erva67 - Other - - - - erva Total 575,000.00 186,294.76 - 575,000.00 0.00% Program: 3000 - Finance ce 51 - Labor 678,000.00 294,392.88 5,000.00 683,000.00 ce 52 - Temporary Labor - - - - ce 53 - Overtime 10,000.00 2,607.93 - 10,000.00 ce 54 - Standby - - - - ce 56 - Benefits 287,000.00 162,085.04 - 287,000.00 ce 61 - Water Supply - - - - ce 62 - Materials and Supplies 11,000.00 3,541.00 - 11,000.00 ce 63 - Contract Services 166,000.00 80,700.79 - 166,000.00 ce 64 - Utilities 4,000.00 1,169.33 - 4,000.00 ce 65 - Professional Development 25,000.00 7,869.39 - 25,000.00 ce 67 - Other 1,000.00 650.00 - 1,000.00 ce Total 1,182,000.00 553,016.36 5,000.00 1,187,000.00 0.42% Program: 3200 - Information Technology matio51 - Labor 313,000.00 143,089.19 - 313,000.00 matio52 - Temporary Labor - - - - matio53 - Overtime - - - - matio54 - Standby - - - - matio56 - Benefits 129,000.00 73,931.47 - 129,000.00 matio61 - Water Supply - - - - matio62 - Materials and Supplies 36,000.00 45,552.84 - 36,000.00 matio63 - Contract Services 462,000.00 160,410.91 - 462,000.00 matio64 - Utilities 6,000.00 1,590.02 - 6,000.00 matio65 - Professional Development 17,000.00 7,242.63 - 17,000.00 matio67 - Other - - - - matio Total 963,000.00 431,817.06 - 963,000.00 0.00% Page 2 of 15 FY 2017-18 Budget FY 2017-18 Percent Budget YTD Activity Adjustment Projected Change DISTRICT WIDE FY 2017-18 MID-YEAR BUDGET REVIEW JULY 1, 2017 - DECEMBER 31, 2017 Program: 3300 - Customer Service me 51 - Labor 472,000.00 223,709.62 - 472,000.00 me 52 - Temporary Labor 3,000.00 - - 3,000.00 me 53 - Overtime 5,000.00 2,761.81 - 5,000.00 me 54 - Standby - - - - me 56 - Benefits 242,000.00 158,179.23 - 242,000.00 me 61 - Water Supply - - - - me 62 - Materials and Supplies 12,000.00 3,054.16 - 12,000.00 me 63 - Contract Services 841,000.00 381,224.65 15,000.00 856,000.00 me 64 - Utilities 157,000.00 55,971.62 - 157,000.00 me 65 - Professional Development 17,000.00 510.57 - 17,000.00 me 67 - Other - 3,428.16 - - me Total 1,749,000.00 828,839.82 15,000.00 1,764,000.00 0.86% Program: 3400 - Meter Service Se 51 - Labor 228,000.00 102,277.68 - 228,000.00 Se 52 - Temporary Labor - - - - Se 53 - Overtime 20,000.00 3,093.01 - 20,000.00 Se 54 - Standby - - - - Se 56 - Benefits 135,000.00 75,096.09 - 135,000.00 Se 61 - Water Supply - - - - Se 62 - Materials and Supplies 4,000.00 755.36 - 4,000.00 Se 63 - Contract Services 8,000.00 5,418.54 3,000.00 11,000.00 Se 64 - Utilities 2,000.00 345.72 - 2,000.00 Se 65 - Professional Development - - - - Se 67 - Other - - - - Se Total 397,000.00 186,986.40 3,000.00 400,000.00 0.76% Program: 4000 - Engineering eer 51 - Labor 712,000.00 296,188.08 - 712,000.00 eer 52 - Temporary Labor - - - - eer 53 - Overtime 2,000.00 809.94 - 2,000.00 eer 54 - Standby - - - - eer 56 - Benefits 350,000.00 195,946.00 - 350,000.00 eer 61 - Water Supply - - - - eer 62 - Materials and Supplies 24,000.00 2,007.65 - 24,000.00 eer 63 - Contract Services 286,000.00 116,433.37 - 286,000.00 eer 64 - Utilities 123,000.00 40,453.61 - 123,000.00 eer 65 - Professional Development 30,000.00 3,339.08 - 30,000.00 eer 67 - Other - - - - eer Total 1,527,000.00 655,177.73 - 1,527,000.00 0.00% Program: 5000 - Water Production r Pr 51 - Labor 670,000.00 287,326.23 - 670,000.00 r Pr 52 - Temporary Labor - - - - r Pr 53 - Overtime 36,000.00 26,404.73 - 36,000.00 r Pr 54 - Standby 20,000.00 7,060.00 - 20,000.00 r Pr 56 - Benefits 270,000.00 165,725.25 - 270,000.00 r Pr 61 - Water Supply 801,000.00 647.15 - 801,000.00 r Pr 62 - Materials and Supplies 279,000.00 106,504.21 - 279,000.00 r Pr 63 - Contract Services 367,000.00 227,648.35 - 367,000.00 r Pr 64 - Utilities 1,614,000.00 772,753.10 - 1,614,000.00 r Pr 65 - Professional Development 15,000.00 3,802.71 - 15,000.00 r Pr 67 - Other - - - - r Pr Total 4,072,000.00 1,597,871.73 - 4,072,000.00 0.00% Page 3 of 15 FY 2017-18 Budget FY 2017-18 Percent Budget YTD Activity Adjustment Projected Change DISTRICT WIDE FY 2017-18 MID-YEAR BUDGET REVIEW JULY 1, 2017 - DECEMBER 31, 2017 Program: 5100 - Water Treatment r Tre51 - Labor 237,000.00 105,968.92 - 237,000.00 r Tre52 - Temporary Labor - - - - r Tre53 - Overtime 10,000.00 6,663.46 8,000.00 18,000.00 r Tre54 - Standby - - - - r Tre56 - Benefits 92,000.00 57,508.33 - 92,000.00 r Tre61 - Water Supply - - - - r Tre62 - Materials and Supplies 165,000.00 46,281.59 - 165,000.00 r Tre63 - Contract Services 186,000.00 113,469.97 140,000.00 326,000.00 r Tre64 - Utilities 200,000.00 51,370.14 - 200,000.00 r Tre65 - Professional Development - - - - r Tre67 - Other - - - - r Tre Total 890,000.00 381,262.41 148,000.00 1,038,000.00 16.63% Program: 5200 - Water Quality r Qu51 - Labor 176,000.00 79,631.08 - 176,000.00 r Qu52 - Temporary Labor - - - - r Qu53 - Overtime 10,000.00 5,165.64 5,000.00 15,000.00 r Qu54 - Standby - - - - r Qu56 - Benefits 76,000.00 44,061.66 - 76,000.00 r Qu61 - Water Supply - - - - r Qu62 - Materials and Supplies 18,000.00 5,921.67 - 18,000.00 r Qu63 - Contract Services 120,000.00 41,781.97 - 120,000.00 r Qu64 - Utilities 2,000.00 844.55 - 2,000.00 r Qu65 - Professional Development 8,000.00 107.92 - 8,000.00 r Qu67 - Other - - - - r Qu Total 410,000.00 177,514.49 5,000.00 415,000.00 1.22% Program: 6000 - Field Maintenance Administration Mai 51 - Labor 114,000.00 67,905.32 - 114,000.00 Mai 52 - Temporary Labor - - - - Mai 53 - Overtime - 9,044.60 15,000.00 15,000.00 Mai 54 - Standby 20,000.00 10,966.59 - 20,000.00 Mai 56 - Benefits 45,000.00 35,029.88 - 45,000.00 Mai 61 - Water Supply - - - - Mai 62 - Materials and Supplies 3,000.00 16,372.66 - 3,000.00 Mai 63 - Contract Services - - - - Mai 64 - Utilities 21,000.00 7,353.93 - 21,000.00 Mai 65 - Professional Development 17,000.00 8,368.31 - 17,000.00 Mai 67 - Other - - - - Mai Total 220,000.00 155,041.29 15,000.00 235,000.00 6.82% Program: 6100 - Water Maintenance r Ma51 - Labor 784,000.00 338,618.97 - 784,000.00 r Ma52 - Temporary Labor - - - - r Ma53 - Overtime 150,000.00 75,075.85 (45,000.00) 105,000.00 r Ma54 - Standby - - - - r Ma56 - Benefits 417,000.00 236,520.43 - 417,000.00 r Ma61 - Water Supply - - - - r Ma62 - Materials and Supplies 221,000.00 219,847.82 - 221,000.00 r Ma63 - Contract Services 449,000.00 149,903.03 - 449,000.00 r Ma64 - Utilities - 23,293.74 - - r Ma65 - Professional Development - - - - r Ma67 - Other - - - - r Ma Total 2,021,000.00 1,043,259.84 (45,000.00) 1,976,000.00 -2.23% Page 4 of 15 FY 2017-18 Budget FY 2017-18 Percent Budget YTD Activity Adjustment Projected Change DISTRICT WIDE FY 2017-18 MID-YEAR BUDGET REVIEW JULY 1, 2017 - DECEMBER 31, 2017 Program: 6200 - Wastewater Maintenance ewa 51 - Labor 280,000.00 117,013.84 - 280,000.00 ewa 52 - Temporary Labor - - - - ewa 53 - Overtime 3,000.00 25,594.39 32,000.00 35,000.00 ewa 54 - Standby - - - - ewa 56 - Benefits 144,000.00 82,003.95 - 144,000.00 ewa 61 - Water Supply - - - - ewa 62 - Materials and Supplies 35,000.00 20,837.13 - 35,000.00 ewa 63 - Contract Services 8,131,000.00 4,399,359.70 - 8,131,000.00 ewa 64 - Utilities - - - - ewa 65 - Professional Development - - - - ewa 67 - Other - - - - ewa Total 8,593,000.00 4,644,809.01 32,000.00 8,625,000.00 0.37% Program: 7000 - Facilities Maintenance ties 51 - Labor 97,000.00 44,568.83 - 97,000.00 ties 52 - Temporary Labor - - - - ties 53 - Overtime 25,000.00 8,793.22 - 25,000.00 ties 54 - Standby - - - - ties 56 - Benefits 44,000.00 26,774.58 - 44,000.00 ties 61 - Water Supply - - - - ties 62 - Materials and Supplies 42,000.00 20,371.26 - 42,000.00 ties 63 - Contract Services 347,000.00 207,866.10 40,000.00 387,000.00 ties 64 - Utilities 221,000.00 77,808.83 - 221,000.00 ties 65 - Professional Development - - - - ties 67 - Other - - - - ties Total 776,000.00 386,182.82 40,000.00 816,000.00 5.15% Program: 7100 - Fleet Maintenance Mai 51 - Labor 164,000.00 74,824.47 - 164,000.00 Mai 52 - Temporary Labor - - - - Mai 53 - Overtime 3,000.00 847.93 - 3,000.00 Mai 54 - Standby - - - - Mai 56 - Benefits 79,000.00 48,032.09 - 79,000.00 Mai 61 - Water Supply - - - - Mai 62 - Materials and Supplies 63,000.00 37,545.62 - 63,000.00 Mai 63 - Contract Services 75,000.00 61,610.13 32,000.00 107,000.00 Mai 64 - Utilities 126,000.00 48,430.89 - 126,000.00 Mai 65 - Professional Development 6,000.00 60.00 - 6,000.00 Mai 67 - Other - - - - Mai Total 516,000.00 271,351.13 32,000.00 548,000.00 6.20% Total Operating Expenses 26,994,000.00 13,106,775.49 420,000.00 27,414,000.00 Other Expenses al 71 - Debt Service 4,315,000.00 3,142,504.00 500,000.00 4,815,000.00 al 81 - Capital Improvement 4,287,000.00 659,817.25 (420,000.00) 3,867,000.00 al 82 - Capital Outlay 611,000.00 151,831.43 - 611,000.00 al 88 - Transfer from Reserves 417,000.00 - - 417,000.00 al Total 9,630,000.00 3,954,152.68 80,000.00 9,710,000.00 0.83% Net - 4,314,226.48 - - Page 5 of 15 FY 2017-18 Budget FY 2017-18 Percent Budget YTD Activity Adjustment Projected Change Revenue 4100 - Water Sales 14,500,000.00 9,554,906.24 500,000.00 15,000,000.00 4200 - Meter Charges 8,845,000.00 4,471,715.19 - 8,845,000.00 4301 - Penalties 445,500.00 309,034.66 - 445,500.00 4400 - Wastewater Collection - - 4500 - Wastewater Treatment - - 4600 - Other Operating Charges 131,500.00 166,968.50 - 131,500.00 4700 - Investment Income 75,000.00 50,600.98 - 75,000.00 4703 - Energy Incentive Rebates - - - - 4704 - Miscellaneous Revenue 50,000.00 43,143.67 - 50,000.00 24,047,000.00 14,596,369.24 500,000.00 24,547,000.00 2.08% Program: 1000 - Board of Directors min 51 - Labor 73,500.00 29,767.50 - 73,500.00 min 52 - Temporary Labor - - - - min 53 - Overtime - - - - min 54 - Standby - - - - min 56 - Benefits 39,900.00 11,357.39 - 39,900.00 min 61 - Water Supply - - - - min 62 - Materials and Supplies 700.00 - - 700.00 min 63 - Contract Services 7,700.00 238.80 - 7,700.00 min 64 - Utilities - - - - min 65 - Professional Development 38,500.00 5,947.93 - 38,500.00 min 67 - Other - - - - min Total 160,300.00 47,311.62 - 160,300.00 0.00% Program: 2000 - General Administration min 51 - Labor 340,200.00 144,347.19 3,500.00 343,700.00 min 52 - Temporary Labor - - - - min 53 - Overtime - 890.52 - - min 54 - Standby - - - - min 56 - Benefits 171,500.00 96,179.35 - 171,500.00 min 61 - Water Supply - - - - min 62 - Materials and Supplies 5,600.00 629.61 - 5,600.00 min 63 - Contract Services 242,900.00 232,723.76 70,000.00 312,900.00 min 64 - Utilities 2,100.00 1,096.59 - 2,100.00 min 65 - Professional Development 78,400.00 42,465.73 - 78,400.00 min 67 - Other - - - - min Total 840,700.00 518,332.75 73,500.00 914,200.00 8.74% Program: 2100 - Human Resources min 51 - Labor 147,700.00 67,692.47 - 147,700.00 min 52 - Temporary Labor 8,400.00 1,814.40 - 8,400.00 min 53 - Overtime 2,100.00 781.42 - 2,100.00 min 54 - Standby - - - - min 56 - Benefits 70,000.00 41,652.03 - 70,000.00 min 61 - Water Supply - - - - min 62 - Materials and Supplies 14,000.00 1,772.60 - 14,000.00 min 63 - Contract Services 62,300.00 29,265.04 17,500.00 79,800.00 min 64 - Utilities 700.00 220.18 - 700.00 min 65 - Professional Development 27,300.00 14,482.41 - 27,300.00 min 67 - Other 259,000.00 187,440.92 - 259,000.00 min Total 591,500.00 345,121.47 17,500.00 609,000.00 2.96% WATER FUND FY 2017-18 MID-YEAR BUDGET REVIEW JULY 1, 2017 - DECEMBER 31, 2017 Page 6 of 15 FY 2017-18 Budget FY 2017-18 Percent Budget YTD Activity Adjustment Projected Change WATER FUND FY 2017-18 MID-YEAR BUDGET REVIEW JULY 1, 2017 - DECEMBER 31, 2017 Program: 2200 - Public Affairs min 51 - Labor 173,500.00 69,995.86 15,500.00 189,000.00 min 52 - Temporary Labor - - - - min 53 - Overtime 3,500.00 1,575.76 - 3,500.00 min 54 - Standby - - - - min 56 - Benefits 64,500.00 37,081.38 4,500.00 69,000.00 min 61 - Water Supply - - - - min 62 - Materials and Supplies 38,500.00 5,451.42 - 38,500.00 min 63 - Contract Services 103,000.00 40,211.93 - 103,000.00 min 64 - Utilities 17,500.00 439.91 - 17,500.00 min 65 - Professional Development 13,500.00 4,321.32 - 13,500.00 min 67 - Other - - - - min Total 414,000.00 159,077.58 20,000.00 434,000.00 4.83% Program: 2300 - Conservation min 51 - Labor 98,000.00 45,269.73 - 98,000.00 min 52 - Temporary Labor - - - - min 53 - Overtime 8,000.00 - - 8,000.00 min 54 - Standby - - - - min 56 - Benefits 32,000.00 24,164.61 - 32,000.00 min 61 - Water Supply - - - - min 62 - Materials and Supplies 223,000.00 107,839.51 - 223,000.00 min 63 - Contract Services 187,000.00 6,647.28 - 187,000.00 min 64 - Utilities 21,000.00 362.63 - 21,000.00 min 65 - Professional Development 6,000.00 2,011.00 - 6,000.00 min 67 - Other - - - - min Total 575,000.00 186,294.76 - 575,000.00 0.00% Program: 3000 - Finance min 51 - Labor 474,600.00 206,162.72 3,500.00 478,100.00 min 52 - Temporary Labor - - - - min 53 - Overtime 7,000.00 1,825.57 - 7,000.00 min 54 - Standby - - - - min 56 - Benefits 200,900.00 113,519.83 - 200,900.00 min 61 - Water Supply - - - - min 62 - Materials and Supplies 7,700.00 2,478.69 - 7,700.00 min 63 - Contract Services 116,200.00 56,588.23 - 116,200.00 min 64 - Utilities 2,800.00 818.54 - 2,800.00 min 65 - Professional Development 17,500.00 5,508.57 - 17,500.00 min 67 - Other 1,000.00 650.00 - 1,000.00 min Total 827,700.00 387,552.15 3,500.00 831,200.00 0.42% Program: 3200 - Information Technology min 51 - Labor 219,100.00 100,162.40 - 219,100.00 min 52 - Temporary Labor - - - - min 53 - Overtime - - - - min 54 - Standby - - - - min 56 - Benefits 90,300.00 51,752.59 - 90,300.00 min 61 - Water Supply - - - - min 62 - Materials and Supplies 25,200.00 31,886.99 - 25,200.00 min 63 - Contract Services 323,400.00 112,287.62 - 323,400.00 min 64 - Utilities 4,200.00 1,113.02 - 4,200.00 min 65 - Professional Development 11,900.00 5,069.83 - 11,900.00 min 67 - Other - - - - min Total 674,100.00 302,272.45 - 674,100.00 0.00% Page 7 of 15 FY 2017-18 Budget FY 2017-18 Percent Budget YTD Activity Adjustment Projected Change WATER FUND FY 2017-18 MID-YEAR BUDGET REVIEW JULY 1, 2017 - DECEMBER 31, 2017 Program: 3300 - Customer Service stom51 - Labor 330,400.00 151,557.32 - 330,400.00 stom52 - Temporary Labor 2,100.00 - - 2,100.00 stom53 - Overtime 3,500.00 1,927.74 - 3,500.00 stom54 - Standby - - - - stom56 - Benefits 169,400.00 108,031.53 - 169,400.00 stom61 - Water Supply - - - - stom62 - Materials and Supplies 8,400.00 2,137.91 - 8,400.00 stom63 - Contract Services 696,400.00 308,869.27 10,500.00 706,900.00 stom64 - Utilities 109,900.00 39,180.14 - 109,900.00 stom65 - Professional Development 12,500.00 389.29 - 12,500.00 stom67 - Other - 3,432.26 - - stom Total 1,332,600.00 615,525.46 10,500.00 1,343,100.00 0.79% Program: 3400 - Meter Service stom51 - Labor 228,000.00 102,277.68 - 228,000.00 stom52 - Temporary Labor - - - - stom53 - Overtime 20,000.00 3,093.01 - 20,000.00 stom54 - Standby - - - - stom56 - Benefits 135,000.00 75,096.09 - 135,000.00 stom61 - Water Supply - - - - stom62 - Materials and Supplies 4,000.00 755.36 - 4,000.00 stom63 - Contract Services 8,000.00 5,418.54 3,000.00 11,000.00 stom64 - Utilities 2,000.00 345.72 - 2,000.00 stom65 - Professional Development - - - - min 67 - Other - - - - min Total 397,000.00 186,986.40 3,000.00 400,000.00 0.76% Program: 4000 - Engineering min 51 - Labor 498,400.00 213,898.79 - 498,400.00 min 52 - Temporary Labor - - - - min 53 - Overtime 1,400.00 566.98 - 1,400.00 min 54 - Standby - - - - min 56 - Benefits 245,000.00 137,162.77 - 245,000.00 min 61 - Water Supply - - - - min 62 - Materials and Supplies 16,800.00 1,873.28 - 16,800.00 min 63 - Contract Services 200,200.00 104,654.75 - 200,200.00 min 64 - Utilities 86,100.00 27,740.59 - 86,100.00 min 65 - Professional Development 21,000.00 2,747.24 - 21,000.00 min 67 - Other - - - - min Total 1,068,900.00 488,644.40 - 1,068,900.00 0.00% Program: 5000 - Water Production min 51 - Labor 670,000.00 287,326.23 - 670,000.00 min 52 - Temporary Labor - - - - min 53 - Overtime 36,000.00 26,404.73 - 36,000.00 min 54 - Standby 20,000.00 7,060.00 - 20,000.00 min 56 - Benefits 270,000.00 165,725.25 - 270,000.00 min 61 - Water Supply 801,000.00 647.15 - 801,000.00 min 62 - Materials and Supplies 279,000.00 106,504.21 - 279,000.00 min 63 - Contract Services 367,000.00 227,648.35 - 367,000.00 min 64 - Utilities 1,614,000.00 772,753.10 - 1,614,000.00 min 65 - Professional Development 15,000.00 3,802.71 - 15,000.00 min 67 - Other - - - - min Total 4,072,000.00 1,597,871.73 - 4,072,000.00 0.00% Page 8 of 15 FY 2017-18 Budget FY 2017-18 Percent Budget YTD Activity Adjustment Projected Change WATER FUND FY 2017-18 MID-YEAR BUDGET REVIEW JULY 1, 2017 - DECEMBER 31, 2017 Program: 5100 - Water Treatment 51 - Labor 237,000.00 105,968.92 - 237,000.00 52 - Temporary Labor - - - - 53 - Overtime 10,000.00 6,663.46 8,000.00 18,000.00 54 - Standby - - - - 56 - Benefits 92,000.00 57,508.33 - 92,000.00 61 - Water Supply - - - - 62 - Materials and Supplies 165,000.00 46,281.59 - 165,000.00 63 - Contract Services 186,000.00 113,469.97 140,000.00 326,000.00 64 - Utilities 200,000.00 51,370.14 - 200,000.00 65 - Professional Development - - - - 67 - Other - - - - Total 890,000.00 381,262.41 148,000.00 1,038,000.00 16.63% Program: 5200 - Water Quality 51 - Labor 176,000.00 79,631.08 - 176,000.00 52 - Temporary Labor - - - - 53 - Overtime 10,000.00 5,165.64 5,000.00 15,000.00 54 - Standby - - - - 56 - Benefits 76,000.00 44,061.66 - 76,000.00 61 - Water Supply - - - - 62 - Materials and Supplies 18,000.00 5,921.67 - 18,000.00 63 - Contract Services 120,000.00 41,781.97 - 120,000.00 64 - Utilities 2,000.00 844.55 - 2,000.00 65 - Professional Development 8,000.00 107.92 - 8,000.00 67 - Other - - - - Total 410,000.00 177,514.49 5,000.00 415,000.00 1.22% Program: 6000 - Field Maintenance Administration min 51 - Labor 102,600.00 58,342.42 - 102,600.00 min 52 - Temporary Labor - - - - min 53 - Overtime - 7,866.06 15,000.00 15,000.00 min 54 - Standby 18,000.00 8,646.59 - 18,000.00 min 56 - Benefits 40,500.00 30,366.24 - 40,500.00 min 61 - Water Supply - - - - min 62 - Materials and Supplies 2,700.00 16,363.91 - 2,700.00 min 63 - Contract Services - - - - min 64 - Utilities 18,900.00 6,618.54 - 18,900.00 min 65 - Professional Development 15,300.00 7,993.98 - 15,300.00 min 67 - Other - - - - min Total 198,000.00 136,197.74 15,000.00 213,000.00 7.58% Program: 6100 - Water Maintenance D 51 - Labor 784,000.00 338,618.97 - 784,000.00 D 52 - Temporary Labor - - - - D 53 - Overtime 150,000.00 75,075.85 (45,000.00) 105,000.00 D 54 - Standby - - - - D 56 - Benefits 417,000.00 236,520.43 - 417,000.00 D 61 - Water Supply - - - - D 62 - Materials and Supplies 221,000.00 219,847.82 - 221,000.00 D 63 - Contract Services 449,000.00 149,903.03 - 449,000.00 D 64 - Utilities - 23,293.74 - - D 65 - Professional Development - - - - D 67 - Other - - - - D Total 2,021,000.00 1,043,259.84 (45,000.00) 1,976,000.00 -2.23% Page 9 of 15 FY 2017-18 Budget FY 2017-18 Percent Budget YTD Activity Adjustment Projected Change WATER FUND FY 2017-18 MID-YEAR BUDGET REVIEW JULY 1, 2017 - DECEMBER 31, 2017 Program: 6200 - Wastewater Maintenance D 51 - Labor - - - - D 52 - Temporary Labor - - - - D 53 - Overtime - - - - D 54 - Standby - - - - D 56 - Benefits - - - - D 61 - Water Supply - - - - D 62 - Materials and Supplies - - - - D 63 - Contract Services - - - - D 64 - Utilities - - - - D 65 - Professional Development - - - - D 67 - Other - - - - D Total - - - - 0.00% Program: 7000 - Facilities Maintenance min 51 - Labor 67,900.00 35,087.78 - 67,900.00 min 52 - Temporary Labor - - - - min 53 - Overtime 17,500.00 6,808.10 - 17,500.00 min 54 - Standby - - - - min 56 - Benefits 30,800.00 20,260.81 - 30,800.00 min 61 - Water Supply - - - - min 62 - Materials and Supplies 33,900.00 14,659.25 - 33,900.00 min 63 - Contract Services 276,500.00 178,700.06 40,000.00 316,500.00 min 64 - Utilities 159,200.00 54,644.91 - 159,200.00 min 65 - Professional Development - - - - min 67 - Other - - - - min Total 585,800.00 310,160.91 40,000.00 625,800.00 6.83% Program: 7100 - Fleet Maintenance min 51 - Labor 147,600.00 67,342.17 - 147,600.00 min 52 - Temporary Labor - - - - min 53 - Overtime 2,700.00 763.14 - 2,700.00 min 54 - Standby - - - - min 56 - Benefits 71,100.00 43,229.42 - 71,100.00 min 61 - Water Supply - - - - min 62 - Materials and Supplies 56,700.00 26,126.18 - 56,700.00 min 63 - Contract Services 67,500.00 43,653.89 29,000.00 96,500.00 min 64 - Utilities 113,400.00 43,587.79 - 113,400.00 min 65 - Professional Development 5,400.00 54.00 - 5,400.00 min 67 - Other - - - - min Total 464,400.00 224,756.59 29,000.00 493,400.00 6.24% Total Operating Expenses 15,523,000.00 7,108,142.75 320,000.00 15,843,000.00 Other Expenses 71 - Debt Service 4,002,000.00 2,937,641.00 500,000.00 4,502,000.00 81 - Capital Improvement 3,625,000.00 38,665.31 (320,000.00) 3,305,000.00 82 - Capital Outlay 480,000.00 117,788.73 480,000.00 88 - Transfer to Reserves 417,000.00 - 417,000.00 Total 8,524,000.00 3,094,095.04 180,000.00 8,704,000.00 2.11% Net - 4,394,131.45 - - Page 10 of 15 ` FY 2017-18 Budget FY 2017-18 Percent Budget YTD Activity Adjustment Projected Change Revenue 4100 - Water Sales - 4200 - Meter Charges - 4301 - Penalties 40,000.00 22,421.60 - 40,000.00 4400 - Wastewater Collection 4,545,000.00 2,352,192.40 4,545,000.00 4500 - Wastewater Treatment 7,900,000.00 4,379,006.44 7,900,000.00 4600 - Other Operating Charges 70,000.00 5,000.00 - 70,000.00 4700 - Investment Income 22,000.00 20,164.97 22,000.00 4703 - Energy Incentive Rebates - - - 4704 - Miscellaneous Revenue - - - 12,577,000.00 6,778,785.41 - 12,577,000.00 0.00% Program: 1000 - Board of Directors 51 - Labor 31,500.00 12,757.50 - 31,500.00 52 - Temporary Labor - - - - 53 - Overtime - - - - 54 - Standby - - - - 56 - Benefits 17,100.00 4,867.46 - 17,100.00 61 - Water Supply - - - - 62 - Materials and Supplies 300.00 - - 300.00 63 - Contract Services 3,300.00 102.35 - 3,300.00 64 - Utilities - - - - 65 - Professional Development 16,500.00 1,965.79 - 16,500.00 67 - Other - - - - Total 68,700.00 19,693.10 - 68,700.00 0.00% Program: 2000 - General Administration 51 - Labor 145,800.00 61,836.61 1,500.00 147,300.00 52 - Temporary Labor - - - - 53 - Overtime - 381.66 - - 54 - Standby - - - - 56 - Benefits 73,500.00 30,924.35 - 73,500.00 61 - Water Supply - - - - 62 - Materials and Supplies 2,400.00 269.86 - 2,400.00 63 - Contract Services 104,100.00 100,321.64 30,000.00 134,100.00 64 - Utilities 900.00 469.98 - 900.00 65 - Professional Development 33,600.00 18,199.62 - 33,600.00 67 - Other - - - - Total 360,300.00 212,403.72 31,500.00 391,800.00 8.74% Program: 2100 - Human Resources 51 - Labor 63,300.00 29,011.11 - 63,300.00 52 - Temporary Labor 3,600.00 777.60 - 3,600.00 53 - Overtime 900.00 334.89 - 900.00 54 - Standby - - - - 56 - Benefits 30,000.00 17,357.53 - 30,000.00 61 - Water Supply - - - - 62 - Materials and Supplies 6,000.00 759.69 - 6,000.00 63 - Contract Services 26,700.00 12,542.18 7,500.00 34,200.00 64 - Utilities 300.00 94.33 - 300.00 65 - Professional Development 11,700.00 6,206.75 - 11,700.00 67 - Other 111,000.00 80,331.76 - 111,000.00 Total 253,500.00 147,415.84 7,500.00 261,000.00 2.96% WASTEWATER FUND FY 2017-18 MID-YEAR BUDGET REVIEW JULY 1, 2017 - DECEMBER 31, 2017 Page 11 of 15 ` FY 2017-18 Budget FY 2017-18 Percent Budget YTD Activity Adjustment Projected Change WASTEWATER FUND FY 2017-18 MID-YEAR BUDGET REVIEW JULY 1, 2017 - DECEMBER 31, 2017 Program: 2200 - Public Affairs 51 - Labor 173,500.00 69,111.92 15,500.00 189,000.00 52 - Temporary Labor - - - - 53 - Overtime 3,500.00 1,575.68 - 3,500.00 54 - Standby - - - - 56 - Benefits 64,500.00 36,605.01 4,500.00 69,000.00 61 - Water Supply - - - - 62 - Materials and Supplies 38,500.00 6,193.82 - 38,500.00 63 - Contract Services 103,000.00 39,971.91 - 103,000.00 64 - Utilities 17,500.00 439.87 - 17,500.00 65 - Professional Development 13,500.00 4,096.35 - 13,500.00 67 - Other - - - - Total 414,000.00 157,994.56 20,000.00 434,000.00 4.83% Program: 2300 - Conservation 51 - Labor - - - - 52 - Temporary Labor - - - - 53 - Overtime - - - - 54 - Standby - - - - 56 - Benefits - - - - 61 - Water Supply - - - - 62 - Materials and Supplies - - - - 63 - Contract Services - - - - 64 - Utilities - - - - 65 - Professional Development - - - - 67 - Other - - - - Total - - - - 0.00% Program: 3000 - Finance 51 - Labor 203,400.00 88,230.16 1,500.00 204,900.00 52 - Temporary Labor - - - - 53 - Overtime 3,000.00 782.36 - 3,000.00 54 - Standby - - - - 56 - Benefits 86,100.00 48,565.21 - 86,100.00 61 - Water Supply - - - - 62 - Materials and Supplies 3,300.00 1,062.31 - 3,300.00 63 - Contract Services 49,800.00 24,112.56 - 49,800.00 64 - Utilities 1,200.00 350.79 - 1,200.00 65 - Professional Development 7,500.00 2,360.82 - 7,500.00 67 - Other - - - - Total 354,300.00 165,464.21 1,500.00 355,800.00 0.42% Program: 3200 - Information Technology 51 - Labor 93,900.00 42,926.79 - 93,900.00 52 - Temporary Labor - - - - 53 - Overtime - - - - 54 - Standby - - - - 56 - Benefits 38,700.00 22,178.88 - 38,700.00 61 - Water Supply - - - - 62 - Materials and Supplies 10,800.00 13,665.85 - 10,800.00 63 - Contract Services 138,600.00 48,123.29 - 138,600.00 64 - Utilities 1,800.00 477.00 - 1,800.00 65 - Professional Development 5,100.00 2,172.80 - 5,100.00 67 - Other - - - - Total 288,900.00 129,544.61 - 288,900.00 0.00% Page 12 of 15 ` FY 2017-18 Budget FY 2017-18 Percent Budget YTD Activity Adjustment Projected Change WASTEWATER FUND FY 2017-18 MID-YEAR BUDGET REVIEW JULY 1, 2017 - DECEMBER 31, 2017 Program: 3300 - Customer Service 51 - Labor 141,600.00 72,152.30 - 141,600.00 52 - Temporary Labor 900.00 - - 900.00 53 - Overtime 1,500.00 834.07 - 1,500.00 54 - Standby - - - - 56 - Benefits 72,600.00 50,147.70 - 72,600.00 61 - Water Supply - - - - 62 - Materials and Supplies 3,600.00 916.25 - 3,600.00 63 - Contract Services 144,600.00 72,355.38 4,500.00 149,100.00 64 - Utilities 47,100.00 16,791.48 - 47,100.00 65 - Professional Development 4,500.00 121.28 - 4,500.00 67 - Other - (4.10) - - Total 416,400.00 213,314.36 4,500.00 420,900.00 1.08% Program: 3400 - Meter Service 51 - Labor - - - - 52 - Temporary Labor - - - - 53 - Overtime - - - - 54 - Standby - - - - 56 - Benefits - - - - 61 - Water Supply - - - - 62 - Materials and Supplies - - - - 63 - Contract Services - - - - 64 - Utilities - - - - 65 - Professional Development - - - - 67 - Other - - - - Total - - - - 0.00% Program: 4000 - Engineering 51 - Labor 213,600.00 82,289.29 - 213,600.00 52 - Temporary Labor - - - - 53 - Overtime 600.00 242.96 - 600.00 54 - Standby - - - - 56 - Benefits 105,000.00 58,783.23 - 105,000.00 61 - Water Supply - - - - 62 - Materials and Supplies 7,200.00 134.37 - 7,200.00 63 - Contract Services 85,800.00 11,778.62 - 85,800.00 64 - Utilities 36,900.00 12,713.02 - 36,900.00 65 - Professional Development 9,000.00 591.84 - 9,000.00 67 - Other - - - - Total 458,100.00 166,533.33 - 458,100.00 0.00% Program: 5000 - Water Production 51 - Labor - - - - 52 - Temporary Labor - - - - 53 - Overtime - - - - 54 - Standby - - - - 56 - Benefits - - - - 61 - Water Supply - - - - 62 - Materials and Supplies - - - - 63 - Contract Services - - - - 64 - Utilities - - - - 65 - Professional Development - - - - 67 - Other - - - - Total - - - - 0.00% Page 13 of 15 ` FY 2017-18 Budget FY 2017-18 Percent Budget YTD Activity Adjustment Projected Change WASTEWATER FUND FY 2017-18 MID-YEAR BUDGET REVIEW JULY 1, 2017 - DECEMBER 31, 2017 Program: 5100 - Water Treatment 51 - Labor - - - - 52 - Temporary Labor - - - - 53 - Overtime - - - - 54 - Standby - - - - 56 - Benefits - - - - 61 - Water Supply - - - - 62 - Materials and Supplies - - - - 63 - Contract Services - - - - 64 - Utilities - - - - 65 - Professional Development - - - - 67 - Other - - - - Total - - - - 0.00% Program: 5200 - Water Quality 51 - Labor - - - - 52 - Temporary Labor - - - - 53 - Overtime - - - - 54 - Standby - - - - 56 - Benefits - - - - 61 - Water Supply - - - - 62 - Materials and Supplies - - - - 63 - Contract Services - - - - 64 - Utilities - - - - 65 - Professional Development - - - - 67 - Other - - - - Total - - - - 0.00% Program: 6000 - Field Maintenance Administration ation51 - Labor 11,400.00 9,562.90 - 11,400.00 ation52 - Temporary Labor - - - - ation53 - Overtime - 1,178.54 - - ation54 - Standby 2,000.00 2,320.00 - 2,000.00 ation56 - Benefits 4,500.00 4,663.64 - 4,500.00 ation61 - Water Supply - - - - ation62 - Materials and Supplies 300.00 8.75 - 300.00 ation63 - Contract Services - - - - ation64 - Utilities 2,100.00 735.39 - 2,100.00 ation65 - Professional Development 1,700.00 374.33 - 1,700.00 ation67 - Other - - - - ation Total 22,000.00 18,843.55 - 22,000.00 0.00% Program: 6100 - Water Maintenance 51 - Labor - - - - 52 - Temporary Labor - - - - 53 - Overtime - - - - 54 - Standby - - - - 56 - Benefits - - - - 61 - Water Supply - - - - 62 - Materials and Supplies - - - - 63 - Contract Services - - - - 64 - Utilities - - - - 65 - Professional Development - - - - 67 - Other - - - - Total - - - - 0.00% Page 14 of 15 ` FY 2017-18 Budget FY 2017-18 Percent Budget YTD Activity Adjustment Projected Change WASTEWATER FUND FY 2017-18 MID-YEAR BUDGET REVIEW JULY 1, 2017 - DECEMBER 31, 2017 Program: 6200 - Wastewater Maintenance 51 - Labor 280,000.00 117,013.84 - 280,000.00 52 - Temporary Labor - - - - 53 - Overtime 3,000.00 25,594.39 32,000.00 35,000.00 54 - Standby - - - - 56 - Benefits 144,000.00 82,003.95 - 144,000.00 61 - Water Supply - - - - 62 - Materials and Supplies 35,000.00 20,837.13 - 35,000.00 63 - Contract Services 8,131,000.00 4,399,359.70 - 8,131,000.00 64 - Utilities - - - - 65 - Professional Development - - - - 67 - Other - - - - Total 8,593,000.00 4,644,809.01 32,000.00 8,625,000.00 0.37% Program: 7000 - Facilities Maintenance 51 - Labor 29,100.00 9,481.05 - 29,100.00 52 - Temporary Labor - - - - 53 - Overtime 7,500.00 1,985.12 - 7,500.00 54 - Standby - - - - 56 - Benefits 13,200.00 6,513.77 - 13,200.00 61 - Water Supply - - - - 62 - Materials and Supplies 8,100.00 5,712.01 - 8,100.00 63 - Contract Services 70,500.00 29,166.04 - 70,500.00 64 - Utilities 61,800.00 23,163.92 - 61,800.00 65 - Professional Development - - - - 67 - Other - - - - Total 190,200.00 76,021.91 - 190,200.00 0.00% Program: 7100 - Fleet Maintenance 51 - Labor 16,400.00 7,482.30 - 16,400.00 52 - Temporary Labor - - - - 53 - Overtime 300.00 84.79 - 300.00 54 - Standby - - - - 56 - Benefits 7,900.00 4,802.67 - 7,900.00 61 - Water Supply - - - - 62 - Materials and Supplies 6,300.00 11,419.44 - 6,300.00 63 - Contract Services 7,500.00 17,956.24 3,000.00 10,500.00 64 - Utilities 12,600.00 4,843.10 - 12,600.00 65 - Professional Development 600.00 6.00 - 600.00 67 - Other - - - - Total 51,600.00 46,594.54 3,000.00 54,600.00 5.81% Total Operating Expenses 11,471,000.00 5,998,632.74 100,000.00 11,571,000.00 Other Expenses 71 - Debt Service 313,000.00 204,863.00 - 313,000.00 81 - Capital Improvement 662,000.00 621,151.94 (100,000.00) 562,000.00 82 - Capital Outlay 131,000.00 34,042.70 - 131,000.00 88 - Transfer to Reserves - - - - Total 1,106,000.00 860,057.64 (100,000.00) 1,006,000.00 -9.04% Net - (79,904.97) - - Page 15 of 15 Class Title Tier Range A B C D E A B C D E A B C D E Accountant G 31 35.75 36.65 37.56 38.50 39.47 6,197 6,353 6,510 6,673 6,841 74,360 76,232 78,125 80,080 82,098 Accounting Technician H 19 26.60 27.25 27.92 28.61 29.36 4,611 4,723 4,839 4,959 5,089 55,328 56,680 58,074 59,509 61,069 Administrative Assistant H 22 28.61 29.36 30.08 30.84 31.60 4,959 5,089 5,214 5,346 5,477 59,509 61,069 62,566 64,147 65,728 Associate Engineer P 40 44.65 45.76 46.92 48.09 49.29 7,739 7,932 8,133 8,336 8,544 92,872 95,181 97,594 100,027 102,523 Business Services Manager M 46 51.80 53.08 54.41 55.76 57.17 8,979 9,201 9,431 9,665 9,909 107,744 110,406 113,173 115,981 118,914 Chief Financial Officer E 66 84.85 86.97 89.15 91.38 93.66 14,707 15,075 15,453 15,839 16,234 176,488 180,898 185,432 190,070 194,813 Community Relations Intern PT Y 12.00 2,080 24,960 Community Relations Officer P 40 44.65 45.76 46.92 48.09 49.29 7,739 7,932 8,133 8,336 8,544 92,872 95,181 97,594 100,027 102,523 Conservation Coordinator G 35 39.47 40.46 41.47 42.50 43.57 6,841 7,013 7,188 7,367 7,552 82,098 84,157 86,258 88,400 90,626 Construction Project Coordinator M 36 40.46 41.47 42.50 43.57 44.65 7,013 7,188 7,367 7,552 7,739 84,157 86,258 88,400 90,626 92,872 *Construction Project Coordinator M Y 58.60 10,157 121,888 Creative Services Representative H 19 26.60 27.25 27.92 28.61 29.36 4,611 4,723 4,839 4,959 5,089 55,328 56,680 58,074 59,509 61,069 Customer Service Representative I H 11 21.83 22.37 22.93 23.50 24.09 3,784 3,877 3,975 4,073 4,176 45,406 46,530 47,694 48,880 50,107 Customer Service Representative II H 16 24.69 25.30 25.93 26.59 27.25 4,280 4,385 4,495 4,609 4,723 51,355 52,624 53,934 55,307 56,680 Customer Service Representative III H 19 26.60 27.25 27.92 28.61 29.36 4,611 4,723 4,839 4,959 5,089 55,328 56,680 58,074 59,509 61,069 Customer Service Supervisor P 39 43.57 44.65 45.76 46.92 48.09 7,552 7,739 7,932 8,133 8,336 90,626 92,872 95,181 97,594 100,027 Director of Engineering & Operations A 66 84.85 86.97 89.15 91.38 93.66 14,707 15,075 15,453 15,839 16,234 176,488 180,898 185,432 190,070 194,813 Director of Strategic Services E 57 67.94 69.65 71.39 73.17 75.00 11,776 12,073 12,374 12,683 13,000 141,315 144,872 148,491 152,194 156,000 District Clerk S 41 45.76 46.92 48.09 49.29 50.51 7,932 8,133 8,336 8,544 8,755 95,181 97,594 100,027 102,523 105,061 *District Clerk S Y 56.63 9,816 117,790 Engineering Technician II H 26 31.60 32.39 33.21 34.04 34.88 5,477 5,614 5,756 5,900 6,046 65,728 67,371 69,077 70,803 72,550 Environmental Coordinator P 40 44.65 45.76 46.92 48.09 49.29 7,739 7,932 8,133 8,336 8,544 92,872 95,181 97,594 100,027 102,523 A = At-Will PT = Part-Time * = E = Executive Management (Exempt) P = Professional/Supervisory (Exempt) S = Senior Management (Exempt) G = General/Confidential (Non-Exempt) M = Management (Exempt) H = Hourly-EVWDEP Represented (Non-Exempt) Y-Rate (Due to results of 2014 Compensation Analysis, base salary is set above the maximum for the range assigned) Hourly Salary Range Monthly Salary Range Annual Salary Range Steps Steps Steps SALARY SCHEDULE Effective March 5, 2018 Page 1 of 3 Class Title Tier Range A B C D E A B C D E A B C D E Equipment Mechanic II H 25 30.83 31.60 32.39 33.21 34.04 5,344 5,477 5,614 5,756 5,900 64,126 65,728 67,371 69,077 70,803 Equipment Mechanic III H 27 32.39 33.21 34.04 34.88 35.75 5,614 5,756 5,900 6,046 6,197 67,371 69,077 70,803 72,550 74,360 Facilities Maintenance Coordinator H 34 38.50 39.47 40.46 41.47 42.50 6,673 6,841 7,013 7,188 7,367 80,080 82,098 84,157 86,258 88,400 Field Service Representative H 22 28.61 29.36 30.08 30.84 31.60 4,959 5,089 5,214 5,346 5,477 59,509 61,069 62,566 64,147 65,728 Field Service Supervisor G 39 43.57 44.65 45.76 46.92 48.09 7,552 7,739 7,932 8,133 8,336 90,626 92,872 95,181 97,594 100,027 Field Service Worker I H 17 25.30 25.93 26.59 27.25 27.92 4,385 4,495 4,609 4,723 4,839 52,624 53,934 55,307 56,680 58,074 Field Service Worker II H 22 28.61 29.36 30.08 30.84 31.60 4,959 5,089 5,214 5,346 5,477 59,509 61,069 62,566 64,147 65,728 *Field Service Worker II H Y 32.24 5,588 67,059 Field Service Worker III H 25 30.83 31.60 32.39 33.21 34.04 5,344 5,477 5,614 5,756 5,900 64,126 65,728 67,371 69,077 70,803 General Manager/CEO A 128.80 HR, Risk & Safety Manager S 49 55.76 57.17 58.59 60.05 61.56 9,665 9,909 10,156 10,409 10,670 115,981 118,914 121,867 124,904 128,045 Information Systems Technician G 26 31.60 32.39 33.21 34.04 34.88 5,477 5,614 5,756 5,900 6,046 65,728 67,371 69,077 70,803 72,550 Information Technology Manager S 49 55.76 57.17 58.59 60.05 61.56 9,665 9,909 10,156 10,409 10,670 115,981 118,914 121,867 124,904 128,045 Meter Reader I H 14 23.50 24.09 24.69 25.30 25.93 4,073 4,176 4,280 4,385 4,495 48,880 50,107 51,355 52,624 53,934 Meter Reader II H 18 25.93 26.59 27.25 27.92 28.61 4,495 4,609 4,723 4,839 4,959 53,934 55,307 56,680 58,074 59,509 Network Administrator P 38 42.50 43.57 44.65 45.76 46.92 7,367 7,552 7,739 7,932 8,133 88,400 90,626 92,872 95,181 97,594 Operations Manager S 51 58.59 60.05 61.56 63.09 64.67 10,156 10,409 10,670 10,936 11,209 121,867 124,904 128,045 131,227 134,514 Public Affairs Events Coordinator PT Y 14.00 2,427 29,120 Public Affairs Specialist G 36 40.46 41.47 42.50 43.57 44.65 7,013 7,188 7,367 7,552 7,739 84,157 86,258 88,400 90,626 92,872 Receptionist H 8 20.27 20.78 21.30 21.83 22.37 3,513 3,602 3,692 3,784 3,877 42,162 43,222 44,304 45,406 46,530 *Receptionist H Y 24.57 4,259 51,106 A = At-Will PT = Part-Time * = E = Executive Management (Exempt) P = Professional/Supervisory (Exempt) S = Senior Management (Exempt) G = General/Confidential (Non-Exempt) M = Management (Exempt) H = Hourly-EVWDEP Represented (Non-Exempt) Y-Rate (Due to results of 2014 Compensation Analysis, base salary is set above the maximum for the range assigned) 22,325 267,903 Hourly Salary Range Monthly Salary Range Annual Salary Range Steps Steps Steps SALARY SCHEDULE Effective March 5, 2018 Page 2 of 3 Class Title Tier Range A B C D E A B C D E A B C D E Senior Accounting Technician H 23 29.36 30.08 30.84 31.60 32.39 5,089 5,214 5,346 5,477 5,614 61,069 62,566 64,147 65,728 67,371 Senior Administrative Assistant G 26 31.60 32.39 33.21 34.04 34.88 5,477 5,614 5,756 5,900 6,046 65,728 67,371 69,077 70,803 72,550 Senior Customer Service Representative H 22 28.61 29.36 30.08 30.84 31.60 4,959 5,089 5,214 5,346 5,477 59,509 61,069 62,566 64,147 65,728 Senior Engineer M 46 51.80 53.08 54.41 55.76 57.17 8,979 9,201 9,431 9,665 9,909 107,744 110,406 113,173 115,981 118,914 Senior Engineering Technician H 30 34.88 35.75 36.65 37.57 38.50 6,046 6,197 6,353 6,512 6,673 72,550 74,360 76,232 78,146 80,080 Senior Equipment Mechanic H 29 34.04 34.88 35.75 36.65 37.57 5,900 6,046 6,197 6,353 6,512 70,803 72,550 74,360 76,232 78,146 Senior Field Service Worker H 27 32.39 33.21 34.04 34.88 35.75 5,614 5,756 5,900 6,046 6,197 67,371 69,077 70,803 72,550 74,360 Senior Treatment Plant Operator H 36 40.46 41.47 42.50 43.57 44.65 7,013 7,188 7,367 7,552 7,739 84,157 86,258 88,400 90,626 92,872 Senior Water Production Operator H 32 36.65 37.57 38.50 39.47 40.46 6,353 6,512 6,673 6,841 7,013 76,232 78,146 80,080 82,098 84,157 Storekeeper-Buyer H 21 27.92 28.61 29.36 30.08 30.84 4,839 4,959 5,089 5,214 5,346 58,074 59,509 61,069 62,566 64,147 Water Production Operator I H 22 28.61 29.36 30.08 30.84 31.60 4,959 5,089 5,214 5,346 5,477 59,509 61,069 62,566 64,147 65,728 Water Production Operator II H 26 31.60 32.39 33.21 34.04 34.88 5,477 5,614 5,756 5,900 6,046 65,728 67,371 69,077 70,803 72,550 Water Production Operator III H 30 34.88 35.75 36.65 37.57 38.50 6,046 6,197 6,353 6,512 6,673 72,550 74,360 76,232 78,146 80,080 Water Production Supervisor G 41 45.76 46.92 48.09 49.29 50.51 7,932 8,133 8,336 8,544 8,755 95,181 97,594 100,027 102,523 105,061 Water Quality Coordinator H 34 38.50 39.47 40.46 41.47 42.50 6,673 6,841 7,013 7,188 7,367 80,080 82,098 84,157 86,258 88,400 Water Quality Technician H 23 29.36 30.08 30.84 31.60 32.39 5,089 5,214 5,346 5,477 5,614 61,069 62,566 64,147 65,728 67,371 A = At-Will PT = Part-Time * = E = Executive Management (Exempt)P = Professional/Supervisory (Exempt) S = Senior Management (Exempt)G = General/Confidential (Non-Exempt) M = Management (Exempt)H = Hourly-EVWDEP Represented (Non-Exempt) Steps Steps Steps Y-Rate (Due to results of 2014 Compensation Analysis, base salary is set above the maximum for the range assigned) Hourly Salary Range Monthly Salary Range Annual Salary Range SALARY SCHEDULE Effective March 5, 2018 Page 3 of 3 TOTAL WATER SEWER AMENDED OPERATING OPERATING GRANTS/LOANS DEVELOPER ADJ PROJECT PROJECT BUDGET REVENUE REVENUE OTHER FUND RESERVES FEES TOTAL CAPITAL OUTLAY Office Desk 5,000$ -$ -$ -$ -$ -$ 5,000$ Multi Year Rate Study - - - - - - - Tier 2 Data Storage 11,000 - - - - - 11,000 Virtual Desktop Infrastructure (VDI) Expansion 12,000 - - - - - 12,000 Virtual Desktop Infrastructure (VDI) Redundancy 47,000 - - - - - 47,000 X2 Aurora Filing Cabinet 16,000 - - - - - 16,000 Water Master Plan Update 200,000 - - - - - 200,000 Wastewater Master Plan Update 135,000 - - - - - 135,000 CCTV Camera 20,000 - - - - - 20,000 Emergency Generator 95,000 - - - - - 95,000 Trucks (3)145,000 - - - - - 145,000 TOTAL CAPITAL OUTLAY 742,000 - - - - - 686,000 CAPITAL IMPROVEMENT PROGRAM GENERAL CIP Habitat Conservation Plan - - - - - - - AMI Meter Retrofit Program 500,000 55,000 - - - - 555,000 General Subtotal 500,000 55,000 - - - - 555,000 WATER CIP Canal Zone Storage Reservoir 630,000 - - - - - 630,000 Transmission Main - Plant 134 to Upper Zone 2,085,000 - - - - - 2,085,000 Main Extension - Taylor Road - 125,000 - - - - 125,000 Plant 134 THM Treatment/Sludge Removal 650,000 - - - - - 650,000 Plant 140 - Tank Recoating - - - - - - - Plant 9 - Forebay Repair 350,000 - - - - - 350,000 Plant 59 - Tank Recoating 250,000 - - - - - 250,000 Facilities Relocations 100,000 - - - - - 100,000 Facilities Rehabilitation 225,000 - - - - - 225,000 Water Subtotal 4,290,000 125,000 - - - - 4,415,000 WASTEWATER CIP Sewer Main Replacement - Orange Street 75,000 - - - - - 75,000 Sewer Main Rehabilitation - 4th Street 100,000 - - - - - 100,000 Sewer Main Rehabilitation - Paloma Rd Phase II 105,000 - - - - - 105,000 Sewer Main Replacement - Ferndale Ave 210,000 - - - - - 210,000 City Creek Manhole Relocation 150,000 - - - - - 150,000 Sterling Natural Resource Center (SNRC) 675,000 - - - - - 675,000 Wastewater Subtotal 1,315,000 - - - - - 1,315,000 TOTAL CAPITAL IMPROVEMENT PROGRAM 6,105,000$ 180,000$ -$ -$ -$ -$ 6,285,000$ EAST VALLEY WATER DISTRICT CAPITAL EXPENSES FY 2017-18 PROPOSED ADJUSTMENT