The URL can be used to link to this page

Home My WebLink About2018-04-03 - Board of Directors Meeting Agenda Packet AGENDA YORBA LINDA WATER DISTRICT BOARD OF DIRECTORS WORKSHOP MEETING Tuesday, April 3, 2018, 4:30 PM 1717 E Miraloma Ave, Placentia CA 92870 1. CALL TO ORDER 1.1. TELECONFERENCE SITE 6951 Gulf of Mexico Dr, Longboat Key FL 34228 One of the Directors will be participating via teleconference at the above listed location. In accordance with the Ralph M. Brown Act, members of the public may attend and participate in the meeting at both sites. 2. PLEDGE OF ALLEGIANCE 3. ROLL CALL Al Nederhood, President Brooke Jones, Vice President Andrew J. Hall, Director Phil Hawkins, Director J. Wayne Miller, Director 4. PUBLIC COMMENTS Any individual wishing to address the Board is requested to identify themselves and state the matter on which they wish to comment. If the matter is on the agenda, the Board will recognize the individual for their comment when the item is considered. No action will be taken on matters not listed on the agenda. Comments are limited to matters of public interest and matters within the jurisdiction of the Water District. Comments are limited to three minutes. 5. DISCUSSION ITEMS This portion of the agenda is for matters that cannot reasonably be expected to be concluded by action of the Board of Directors at the meeting, such as technical presentations, drafts of proposed policies, or similar items for which staff is seeking the advice and counsel of the Board of Directors. Time permitting, it is generally in the District’s interest to discuss these more complex matters at one meeting and consider formal action at another meeting. This portion of the agenda may also include items for information only. 5.1. Proposed Capital Improvement Plan and Capital Outlay, Volumetric Water Revenue, Variable Expenses, and Supplies and Services for Fiscal Year 2019 Draft Budget 5.2. OpenGov Proposal for Budgeting, Operational Performance, and Citizen Engagement Software 6. ADJOURNMENT 6.1. The next Regular Board of Directors Meeting will be held Tuesday, April 10, 2018. Closed Session will begin at 5:30 p.m. and regular business at 6:30 p.m. Items Distributed to the Board Less Than 72 Hours Prior to the Meeting Pursuant to Government Code section 54957.5, non-exempt public records that relate to open session agenda items and are distributed to a majority of the Board less than seventy-two (72) hours prior to the meeting will be available for public inspection in the lobby of the District’s business office located at 1717 E. Miraloma Avenue, Placentia, CA 92870, during regular business hours. When practical, these public records will also be made available on the District’s internet website accessible at http://www.ylwd.com/. Accommodations for the Disabled Any person may make a request for a disability-related modification or accommodation needed for that person to be able to participate in the public meeting by telephoning the Executive Secretary at 714-701-3020, or writing to Yorba Linda Water District, P.O. Box 309, Yorba Linda, CA 92885-0309. Requests must specify the nature of the disability and the type of accommodation requested. A telephone number or other contact information should be included so the District staff may discuss appropriate arrangements. Persons requesting a disability-related accommodation should make the request with adequate time before the meeting for the District to provide the requested accommodation. ITEM NO. 5.1 AGENDA REPORT Meeting Date: April 3, 2018 Subject:Proposed Capital Improvement Plan and Capital Outlay, Volumetric Water Revenue, Variable Expenses, and Supplies and Services for Fiscal Year 2019 Draft Budget ATTACHMENTS: Name:Description:Type: FY19_Budget_-_Workshop_1.pdf Backup Material Backup Material FY19 Budget Workshop #1 April 3, 2018 Presented by: Marc Marcantonio, General Manager Delia Lugo, Finance Manager Bryan Hong, Interim Engineering Manager Kelly McCann, Senior Accountant Kaden Young, Management Analyst Overview DRAFT budgets for: –Variable Costs –Volumetric Revenue –Supplies and Services –Capital Improvement Projects 2 3 Monthly System Production Volume: Trending Average 0 500 1000 1500 2000 2500 3000 JUL AUG SEPT OCT NOV DEC JAN FEB MAR APR MAY JUNVolume, AFMonthly System Production Volume FY12 4 Monthly System Production Volume: Trending Average 0 500 1000 1500 2000 2500 3000 JUL AUG SEPT OCT NOV DEC JAN FEB MAR APR MAY JUNVolume, AFMonthly System Production Volume FY12 FY13 5 Monthly System Production Volume: Trending Average 0 500 1000 1500 2000 2500 3000 JUL AUG SEPT OCT NOV DEC JAN FEB MAR APR MAY JUNVolume, AFMonthly System Production Volume FY12 FY13 FY14 6 Monthly System Production Volume: Trending Average 0 500 1000 1500 2000 2500 3000 JUL AUG SEPT OCT NOV DEC JAN FEB MAR APR MAY JUNVolume, AFMonthly System Production Volume FY12 FY13 FY14 FY17 7 Monthly System Production Volume: Trending Average 0 500 1000 1500 2000 2500 3000 JUL AUG SEPT OCT NOV DEC JAN FEB MAR APR MAY JUNVolume, AFMonthly System Production Volume FY12 FY13 FY14 FY17 AVG 8 Monthly Production Volume: FY19 Budget Projection 2,045.9 2,036.9 1,906.0 1,706.2 1,351.8 894.0 1,141.1 1,055.7 1,268.3 1,460.9 1,600.8 1,704.3 2,129.7 2,109.0 1,910.8 1,933.4 1,559.9 1,620.5 1,303.0 1,354.5 1,029.5 1,629.2 1,785.2 1,900.7 2,266.0 2,301.1 2,127.6 1,844.7 1,456.0 1,157.9 1,170.4 1,055.9 1,371.8 1,617.6 1,989.7 2,114.0 - 500.0 1,000.0 1,500.0 2,000.0 2,500.0 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18Volume, AFSYSTEM -Production Volume FY18 Budget Actual Projected FY19 Budget Budget: 18,172 AF Actual/Projection: 20,265 AF FY19 Budget:20,473 AF 9 FY19 Monthly System Production 1586 1611 1489 1291 1019 811 819 739 960 1132 1393 1480 680 690 638 553 437 347 351 317 412 485 597 634 2262 2298 2127 1844 1453 1157 1189 1069 1367 1609 1987 2110 0 500 1000 1500 2000 2500 3000 JUL AUG SEPT OCT NOV DEC JAN FEB MAR APR MAY JUNVolume, AFGroundwater vs Import Water Groundwater Import Water AVG 10 FY19 Variable Costs ENERGY Costs; $1,023,629 ; 7% Groundwater Replenishment; $6,764,140 ; 44% Purchased Water; $6,331,754 ; 41% Annexation Fee; $456,771 ; 3% Connection Charge; $297,750 ; 2% Capacity Charge; $106,470 ; 1% Readiness-to-Serve; $406,448 ; 2% 11 FY19 vs FY18 $- $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 $7,000,000 FY18 FY19 FY18 FY19 FY18 FY19 FY18 FY19 FY18 FY19 FY18 FY19 FY18 FY19 ENERGY Costs Groundwater Replenishment Purchased Water Annexation Fee Connection Charge Capacity Charge/ Readiness-to-Serve In-Lieu Purchased Water $1,017,196 $1,023,629 $5,579,979 $6,764,140 $6,122,533 $6,331,754 $369,257 $456,771 $296,358 $297,750 $536,644 $512,918 $1,525,358 $- Variable Costs: FY18 vs FY19 12 13 Retail Consumption Volume: FY17 vs FY18 0 200000 400000 600000 800000 1000000 1200000 FY17 FY18 FY17 FY18 FY17 FY18 FY17 FY18 FY17 FY18 FY17 FY18 FY17 FY18 FY17 FY18 FY17 FY18 FY17 FY18 FY17 FY18 FY17 FY18 JUL AUG SEP OCT NOV DEC JAN FEB MAR APR MAY JUNVOLUME, CCFRetail Consumption Volume FY17 vs FY18 (Mar.2018 -Jun.2018 are projections) Residential Commercial Irrigation 14 Retail Consumption Volume: FY18 vs FY19 0 500 1000 1500 2000 2500 FY18 FY19 FY18 FY19 FY18 FY19 FY18 FY19 FY18 FY19 FY18 FY19 FY18 FY19 FY18 FY19 FY18 FY19 FY18 FY19 FY18 FY19 FY18 FY19 JUL AUG SEP OCT NOV DEC JAN FEB MAR APR MAY JUNVOLUME, CCFRetail Consumption Volume FY18 vs FY19 Residential Commercial Irrigation 15 Total Volumetric Revenue: FY17 vs FY18 FY17 $19,011,046 FY18 $22,418,635 $- $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 $3,000,000 $- $5,000,000 $10,000,000 $15,000,000 $20,000,000 $25,000,000 JUL AUG SEPT OCT NOV DEC JAN FEB MAR APR MAY JUN Volumetric Revenue FY17 vs FY18 (Mar.2018 -Jun.2018 are projections) FY17 Monthly FY18 Monthly FY17 Cumulative FY18 Cumulative 16 Total Volumetric Revenue: FY17 vs FY18 FY18 $22,418,635 FY19 $21,900,868 $- $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 $3,000,000 $- $5,000,000 $10,000,000 $15,000,000 $20,000,000 $25,000,000 JUL AUG SEPT OCT NOV DEC JAN FEB MAR APR MAY JUN Volumetric Revenue FY18 vs FY19 FY18 Monthly FY19 Monthly FY18 Cumulative FY19 Cumulative 17 Supplies & Services 18 Supplies & Services –10 Year Trend $3,576,147 $3,686,333 $3,811,125 $4,222,398 $3,849,183 $3,806,900 $4,355,033 $4,502,004 $4,417,954 $5,193,657 $- $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 FY10 Actual FY11 Actual FY12 Actual FY13 Actual FY14 Actual FY15 Actual FY16 Actual FY17 Actual FY18 Forecast FY19 Proposed 19 FY17 Actuals FY18 Budget FYE18 Forecast FY19 Budget Variance FY19 to FY18 (Budget to Budget) Percent Change Variance FY19 Budget to FY18 Projections Percent Change Supplies & Services Communications 166,199$ 201,575$ 180,099$ 171,597$ (29,978)$ -15%(8,502)$ -5% Contractual Services 440,313$ 547,890$ 468,247$ 538,732$ (9,158)$ -2%70,485$ 15% Data Processing 271,760$ 250,400$ 260,400$ 281,450$ 31,050$ 12%21,050$ 8% Dues & Memberships 92,429$ 86,545$ 85,976$ 88,230$ 1,685$ 2%2,254$ 3% Fees & Permits 265,033$ 282,115$ 276,999$ 277,003$ (5,112)$ -2%4$ 0% Board Election Expenses 129,971$ -$ -$ 75,000$ 75,000$ 75,000$ Insurance 256,672$ 283,340$ 279,233$ 303,190$ 19,850$ 7%23,957$ 9% Materials 880,454$ 849,000$ 779,331$ 893,400$ 44,400$ 5%114,069$ 15% District Activities & Events 10,945$ 24,200$ 21,945$ 44,825$ 20,625$ 85%22,880$ 104% Maintenance 539,926$ 509,900$ 573,747$ 604,600$ 94,700$ 19%30,853$ 5% Non-Capital Equipment 173,707$ 124,825$ 114,314$ 166,350$ 41,525$ 33%52,036$ 46% Office Expense 39,159$ 42,625$ 44,732$ 47,900$ 5,275$ 12%3,168$ 7% Professional Services 613,289$ 692,525$ 659,849$ 896,800$ 204,275$ 29%236,951$ 36% Professional Development 45,159$ 66,510$ 41,051$ 89,140$ 22,630$ 34%48,089$ 117% Travel & Conferences 46,821$ 115,245$ 65,181$ 152,640$ 37,395$ 32%87,459$ 134% Uncollectible Accounts 9,041$ 18,500$ 1,000$ 3,000$ (15,500)$ -84%2,000$ 200% Utilities 160,002$ 170,700$ 204,588$ 184,400$ 13,700$ 8%(20,188)$ -10% Vehicle Expenses 361,126$ 356,000$ 361,262$ 375,400$ 19,400$ 5%14,138$ 4% Supplies & Services Sub-Total 4,502,004$ 4,621,895$ 4,417,954$ 5,193,657$ 571,762$ 12.4%775,703$ 17.6% 20 Supplies & Services by Department $- $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 BOD Admin Comm Eng Fin HR IT Ops FY18 Budget FY18 Projection FY19 Proposed Budget 21 Budget Variances •Communications: ($29,978) •Data Processing: $31,050 •BOD Elections: $75,000 •Materials: $44,400 •District Activities: $20,625 •Maintenance: $94,700 •Non-Capital Equipment: $41,525 22 Budget Variances •Professional Services: $204,275 •Professional Development: $22,630 •Travel & Conferences: $37,395 •Uncollectible Accounts: ($15,500) 23 Capital Improvement Program 24 Elements of the District’s CIP 1. Construction Projects Increase Capacity, Capability, and Reliability –Began with 2005 Water Master Plan to Maximize Groundwater Use –Current projects: •Fairmont Booster Pump Station Upgrade •Well 22 25 Elements of the District’s CIP 2. R&R Projects Replace and refurbish existing Capital Facilities –How are projects identified for R&R? •Asset Management Plan (AMP) •Staff observations and identification of failing facilities 26 27 YLWD Assets 28 Asset Replacement Cost 29 Development of 10-Year CIP Condition Assessment Remaining Life Assessment Risk Assessment 10-Year CIP ++ 30 Projects = $53,451,000 30 10-Year CIP Map: Water 31 10-Year CIP Map: Sewer 32 5-Year CIP Budget 33 Elements of the District’s CIP 3. District Vehicles & Capital Outlay Items with value of $5,000 or more. –Scheduled Vehicle Replacements •8 vehicles for FY19 –Other Capital Equipment 34 Vehicle Equipment & Capital Outlay 35 Questions/Discussion 36 ITEM NO. 5.2 AGENDA REPORT Meeting Date: April 3, 2018 Subject:OpenGov Proposal for Budgeting, Operational Performance, and Citizen Engagement Software ATTACHMENTS: Name:Description:Type: OpenGOV_Proposal.pdf OpenGOV Proposal Backup Material OpenGov & Yorba Linda Water District, CA Paul Felton (650) 265-0997 pfelton@opengov.com OpenGov, Inc., 955 Charter Street, Redwood City, CA 94063 Yorba Linda Water District, CA - OpenGov Business Plan Page 2 YORBA LINDA WATER DISTRICT, CA Delia Lugo, Kelly McCann, Saira Hernandez November 4, 2017 I appreciate the time you took to look at the OpenGov platform, while sharing some of your processes and challenges you currently experience at the Yorba Linda Water District, with respect to budgeting, reporting and analysis, and district stakeholder engagement. Please review this initial proposal and descriptions of the OpenGov platform. In summary, the District is in the process of updating their strategic plan, to ensure strict adherence to their mission of providing safe and reliable service to each and every district stakeholder. Additionally, they must build trust and engagement, with tools that bring efficiency and accountability to the District. To communicate accurate financial and performance data, both internally, to the elected board members, and to the public, YLWD is looking to enhance their current systems and replace many Microsoft Excel-driven processes by adopting solutions from OpenGov, which are described in this proposal. Included here: 1. High level descriptions of each OpenGov solution/module (pages 3-6) 2. An ROI summary, backed by feedback and data from OpenGov’s early Budgeting, and Reporting and Analysis customers (pages 6-7) 3. Initial Pricing (page 8) We look forward to continued conversations to ensure that there is a great fit and commitment to building new efficiencies and best practices for the Yorba Linda Water District. Thank You, Paul Felton Account Executive Yorba Linda Water District, CA - OpenGov Business Plan Page 3 THE OPENGOV SMART GOVERNMENT PLATFORM Today, with over 1600 government partnerships, which include many special districts governments, OpenGov has expanded its offerings to include a full, end to end suite that includes a budget building module, operational reporting and performance management, and a public engagement, publication, and transparency layer. OpenGov Budget Builder: Build collaborative budgets and engage and empower all departments to build their budget/s and can work to customize and organize the district’s chart of accounts as needed where the data comes from MS Great Plains. As a capital project-heavy organization, the YLWD can rely on Budget Builder to collaborate and communicate more effectively around many projects and the overall operating budget. The YLWD can easily export and share working and final versions of the budget with their board and department heads for further analysis and collaboration in the OpenGov Reporting and Analysis module. Yorba Linda Water District, CA - OpenGov Business Plan Page 4 OpenGov Reporting and Analysis: Monitor revenue and spending, analyze performance, and explore data across your entire organization. With intuitive and powerful reporting capabilities, anyone in your organization can make better, faster decisions. Visualize capital projects, economic activity, or other district-specific data points. Show spending in the context to all stakeholders to convey areas of investment and need. OpenGov Performance Measures: Build personalized dashboards that combine performance data, financial results, and key performance indicators in one place. Connect spending to performance for better resource management, and track spending vs. budget to see the big picture. Take action when thresholds are crossed and celebrate success when goals are reached. Establish goals for departments, programs, or initiatives, then track relevant KPIs to keep stakeholders updated on spending, performance, and progress. Yorba Linda Water District, CA - OpenGov Business Plan Page 5 OpenGov Stories: Increase citizen engagement by easily creating beautiful and user- friendly web pages. Add compelling narrative to data to show how capital projects, tax measures, rate adjustments, and more affect the community. Align stakeholders by clearly stating priorities, goals, and strategy. Display scenarios side by side to communicate tradeoffs. Help everyone understands the relevant facts and latest information in a user- friendly format.   Yorba Linda Water District, CA - OpenGov Business Plan Page 6 OpenGov Budget Book by Wdesk: OpenGov partnered with Workiva, the leading private sector, cloud-based software provider of collaborative document publishing tools. With Wdesk, AISD can create an online workspace to build their budget documents, CAFR, or financial reports from start to finish in a faster, easier to use, cloud-based platform. Maintain a single source of budget truth with one, not multiple versions of a spreadsheet or document to collaborate and build best practices for document, form, or presentation publication. The OpenGov ROI Improved spending power • Better operational and performance intelligence for everyone who needs it (staff, department heads, elected officials, etc.) • Better budget decisions and process • Better understanding of current year and month budgets and actuals • Better insights from other governments around the world • Better financing terms Internal efficiency • Save time responding to Public Records and internal requests • Reduce staff interruptions • Streamline budget and comparisons processes • Improve internal and external collaboration • Automate data presentation & analysis Yorba Linda Water District, CA - OpenGov Business Plan Page 7 Better citizen engagement and transparency • Engaging, interactive public reports, with narrative and context • Ability to tell your whole story Customers have told us they have achieved: • 50% reduction in staff hours required to create the budget • Finishing their budget a full month earlier than in prior years • Freed up 1%-1.5% or more of their budgets for re-allocation • 180 hours per year reduction in time spent producing internal reports • Cut inbound information requests by 20% • Tens of thousands of dollars saved in time and consulting fees to compute comparisons and benchmarks • Millions of dollars saved due to better financing terms (bond ratings) • 90% reduction in cost of maintaining external transparency sites • 3x increase in online citizen engagement The OpenGov Advantage • Easy to use and understand, even for non-technical users • Minimal training required • Internal data analysis and public transparency • Web-based solution available anytime, anywhere (PC, tablet, smartphone). • Visualize both financial and performance data • Specialized for complex, multi-fund financial data • Compatible with all financial systems • Rapid deployment (launch within weeks) Deployment OpenGov has offered to build a Proof of Concept platform for YLWD. Should the district partner with OpenGov, the district will have a dedicated Customer Success Manager and Analyst to ensure quick time to value, and who will work to train any staff with each software module, and assist with building any types of reports that YLWD deems necessary to align and report on financial priorities and performance. Should they desire, and appropriate scoping determines connect-ability to MS Great Plains, OpenGov can integrate with the district’s financial software to offer scheduled, or live data exports from YLWD, directly to the OpenGov platform. We appreciate the opportunity to earn your business. Respectfully, Paul Felton Account Executive / Special District Partnerships 415 999-1724 C / 650 265-0997 / pfelton@opengov.com Yorba Linda Water District, CA - OpenGov Business Plan Page 8 Package Report Type Price (per yr.) OpenGov Reporting and Analysis • Unlimited public annual and monthly financial reports (e.g. revenues and expenses, balance sheet, budget milestones) • Unlimited users and reports to create and share across the organization. • OpenGov Open Checkbook™: Unlimited public financial and non-financial grid reports (e.g. transactions, check register, non-financial, capital project mapping, FTE reports, etc.) • Includes Maps / and Non-Financial data reports • Standard report features such as Chart of Accounts filters, search, annotations, saved views, and supporting documents • Access to the OpenGov Network of government partners. • 24/7 web-based accessibility with a 99.9% uptime guarantee $10,896 OpenGov Performance Measures • Build personalized dashboards that combine performance data, financial results, key performance indicators, and community outcomes in one place. • Connect spending to performance for better resource management, and track spending vs. budget to see the big picture. Take action when thresholds are crossed and celebrate success when goals are reached $6,240 OpenGov Budget Builder™ • Create proposals, engage across departments, save time, and collaborate as you build your district’s budget. Export to the OpenGov Reporting and Analysis reporting platform, or back into your financial software system. $12,900 OpenGov Budget Book™ by Wdesk • Create, edit, and publish your budget book, CAFR, or other important documents without the headache of conflicting versions, tedious manual updates, or recreating graphs, charts, or tables. Easily import data from OpenGov Budget Builder™ and tie the data to the document $12,400 Data Integration • Integrate the district finance system with live or SQL database connection for seamless data transfer between the district and OpenGov $3,000 Deployment Fees • One-time setup fee to build and deploy the OpenGov platform • One-time setup fee to build and deploy the Wdesk platform $6,500 $3,500 Support/ Maintenance • Hosting • Maintenance • Training • Existing feature updates • Dedicated support staff (Customer Success Analyst & Manager) • Data Customization $0 BACKUP MATERIALS DISTRIBUTED LESS THAN 72 HOURS PRIOR TO THE MEETING MATERIALS SUBMITTED BY: Kaden Young MEETING DATE: April 3, 2018 REVISED ITEM NO. 5.1. IFY 19 Budget Workshop # I April 3, 2018 Presented by: �r-- Marc Marcantonio, General Manager Delia Lugo, Finance Manager Bryan Hong, Interim Engineering Manager Kelly McCann, Senior Accountant Kaden Young, Management Analyst Yorba Linda Dater District 4 MATERIALS SUBMITTED BY: Kaden Young MEETING DATE: April 3, 2018 REVISED ITEM NO. 5.1. Schedule o • April 3: Workshop # 1 - Variable Costs - Volumetric Revenue - Supplies & Services - Capital Improvement Projects • April 26: Workshop #2 - Salaries & Related Expenses - Authorized Positions Discussion - Revising Purchasing Policy - Other Operating Revenues - Other Non-Operating Revenues - Schedule of Fees (Customer Service/Engineering) 2 MATERIALS SUBMITTED BY: Kaden Young MEETING DATE: April 3, 2018 REVISED ITEM NO. 5.1. Schedule o (cont.) • May 17: Workshop #3 - Budget Revisions as Requested - Update of Reserve Policy - Update of PARS Agreement - Update of Debt Management Policy - Updated Financial Model • May 30: Workshop #4 - Budget Revisions as Requested - All other updates 3 MATERIALS SUBMITTED BY: Kaden Young MEETING DATE: April 3, 2018 REVISED ITEM NO. 5.1. Schedule o (cont.) • June 5: Initial Draft of FYI 9 Operating Budget Document - Resolution - Authorizing Budgeted Positions for FYI 9 • June 26: Presentation of FYI Operating Budget Document - Resolution - Adoption of FY 19 Operating Budget 4 MATERIALS SUBMITTED BY: Kaden • • AprilMEETING DATE: 1 NO. Overview Proposed budgets for: Variable Costs .1 - Volumetric Revenue - Supplies and Services 4 Capital I • •vement Projects - �. r•,.?',}-• '.?t..� �.Vii;'r n' ,�:::�:J'- n„Y.iLr'r' •Y:�,x�;�y'.i�. y. ;�'r.:i t�.-.�' .Iky :.l'� ..;i,.�.��:��:y,.'•,y o112,10 � L'Mn MATERIALS SUBMITTED BY: Kaden Young MEETING DATE: April 3, 2018 REVISED ITEM NO. 5.1. dependinuoutout Sys importorouction i �s changes _ DistriclIs ke readinesso-serve 111i I It L E COSH expensogroundwate' r9% volume increuses8Ssessment I ffillproportion MATERIALS SUBMITTED BY: Kaden Young MEETING DATE: April 3, 2018 REVISED ITEM NO. 5.1. Variable Cost : Assumptions • Rate Changes: — MWDOC: 3.470 ($1 ,015 to $1 ,050 [+$35] per AF) — OCWD: 6.0% ($445 to $41 .z i*,bzij per AF) — SCE: 6.070 (varies by account type) • Production Volume Amount of water being pumped or imported from MWDOC - Increase of 12.6% from FYI 8 Budget to FYI 9 Budget - Increase of 1 .0% from FY 18 Projected to FYI 9 Budget ❖ FY18: 56% Groundwater; 44% Import (including in-lieu) ❖ FYI 9: 70% Groundwater; 30% Import 7 MATERIALS SUBMITTED BY: Kaden Young MEETING DATE: April 3, 2018 REVISED ITEM NO. 5.1. Monthly System Production Volume : 1 0-Year Trend Water Production Rainfall 3000 30 EMERGENCY DROUGHT PERIOD 2500 25 2000 20 LL Q 41 L 41 N C OC O M 1500 15 1000 10 500 5 0 0 OW OW OW Ooi Oji Ooi 00 Oji O� ,y0 ,y0 ,y0 ,y0 ,y0 ,y0 ,y'y titi titi titi titi titi titi titi titi yti 'y'l' 'y'l' 'y`� ,y'�i ,�'ii y`� ,y'� ,y'�i ,y0 ,y0 ,y0tiP ,y0 ,y0tih 'yh ,yh ,yh ,yh 'yh ti0 ti0 ti� ti0 ti0 ti� ti^ til til til til til 'YW 'yW tiW 8 MATERIALS SUBMITTED BY: Kaden Young MEETING DATE: April 3, 2018 REVISED ITEM NO. 5.1. MonthlyS stem Production volume : TrendingAveragey Monthly System Production Volume 3000 2500 2000 LL Q cu E 1500 o > 1000 500 0 JUL AUG SEPT OCT NOV DEC JAN FEB MAR APR MAY JUN �FY12 9 MATERIALS SUBMITTED BY: Kaden Young MEETING DATE: April 3, 2018 REVISED ITEM NO. 5.1. MonthlyS stem Production volume : TrendingAveragey Monthly System Production Volume 3000 2500 2000 a v F- 1500 0 1000 500 0 JUL AUG SEPT OCT NOV DEC JAN FEB MAR APR MAY JUN -FY12 -FY13 10 MATERIALS SUBMITTED BY: Kaden Young MEETING DATE: April 3, 2018 REVISED ITEM NO. 5.1. MonthlyS stem Production volume : TrendingAveragey Monthly System Production Volume 3000 2500 2000 LL Q v E 1500 0 2 000 1000 500 0 JUL AUG SEPT OCT NOV DEC JAN FEB MAR APR MAY JUN -FY12 -FY13 -FY14 11 MATERIALS SUBMITTED BY: Kaden Young MEETING DATE: April 3, 2018 REVISED ITEM NO. 5.1. MonthlyS stem Production volume : TrendingAveragey Monthly System Production Volume 3000 2500 2000 LL Q cu E 1500 0 1000 500 0 JUL AUG SEPT OCT NOV DEC JAN FEB MAR APR MAY JUN -FY12 -FY13 -FY14 FY17 12 MATERIALS SUBMITTED BY: Kaden Young MEETING DATE: April 3, 2018 REVISED ITEM NO. 5.1. MonthlyS stem Production volume : TrendingAveragey Monthly System Production Volume 3000 2500 • 2000 • ♦ ♦ ♦ ♦ , � LL Q E 1500 , � ♦ ♦ ♦ 1 4w ♦ ♦ i # • • • • _ 0 10 100 to 1000 500 0 JUL AUG SEPT OCT NOV DEC JAN FEB MAR APR MAY JUN FY12 FY13 FY14 FY17 AVG 13 MATERIALS SUBMITTED BY: Kaden Young MEETING DATE: April 3, 2018 REVISED ITEM NO. 5.1. Monthly Production Volume : FYI 9 Budget Projection SYSTEM - Production Volume 2,500.0 2,266.0 2,301.1 I 2,129.7 2,109.0 2,127.6 2,114.0 t 1,910.8 1,933.4 1,989.7 2,000.0 1,903.9 2,045.9 2,036.9 1,844.7 1,788.2 1,706.2 1,559.9 1,620.5 1,631.9 1,617.6 1,704.3 1,500.0 1,600.8 1,456.0 1,354.5 1,371.8 Q 1,303 .0 1,460.9 ai 1,351.8 1,1 0.4 1,157.9 1,268.3 0 1,055.9 1,000.0 1,141.1 1,054.5 1,055.7 894.0 Budget: 18,172 AF 500.0 Actual/Projection:20,265 AF FY19 Budget:20,473 AF Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 —4P--FY18 Budget —41--Actual —4P--Projected tFY19 Budget 14 MATERIALS SUBMITTED BY: Kaden Young MEETING DATE: April 3, 2018 REVISED ITEM NO. 5.1. FYI 9 Monthly System Production Groundwater vs Import Water 3000 2500 2262 2298 2127 2110 i 1987 2000 Me MI ♦ ♦ 1844 00 1 1609 Q + 1453 E 1500 1367 to go 0 ♦ ♦ 1157 1189 ♦ - 1069 jo 10 1000 500 0 JUL AUG SEPT OCT NOV DEC JAN FEB MAR APR MAY JUN Groundwater Import Water AVG 15 MATERIALS SUBMITTED BY: Kaden Young MEETING DATE: April 3, 2018 • FYI 9 Variable Costs Import Water(MWDOC); $6,331,885 ;39% Annexation Fee(OCWD); $456,771; 3% Connection Charge(MWDOC); $297,750;2% Capacity Charge(MWDOC); '2111 Readiness-to-Serve(MWDOC); $406,448;2% 16 ENERGY Costs; $1,740,205; 11% Groundwater(OCWD); $6,764,279;42% MATERIALS SUBMITTED BY: Kaden Young MEETING DATE: April 3, 2018 REVISED ITEM NO. 5.1. Variable Costs : FYI 1 to FY 19 Annexation Fee ■MWDOC Fees $10,000,000 $9,000,000 V o oo ooooo c m $8,000,000 tD 'n m $7,000,000 oo ir � N � O O D M W M Moo VT $6,000,000 W c) L} M � lN1-f m a m ^ Lr v o 0 0 1� N O 1� r O $5,000,000 ° `^ N 01 00 O 00 0 O v1 $4,000,000 O1 `n +h m oo c-i $3,000,000 "* $2,000,000 N O N O Ol N N 01 O O tLl N V R t0 Ln M V lLl 00 O O N to cn I� C u1 M 00 O O M n M to $1,000,000 11cl to !i to to rn ci N to 00 to to to n Lr n N I� rl M Ln O Cn Ln r, O cn 011 O N N M n M M N r-1 rl N n rl N n t0 Ln M M ci M M N Cn I C71 M t0 O Ll1 tD C71 01 O O - M N N N M M M LA 1!1 <D n 00 00 V R M t0 %D L► 'LA in iA iA i? iA i/} Vf iA Vf i/1- V). Vf V1 in i/! In FY11 FY12 FY13 FY14 FY15 FY16 FY17 FY18 FY19 FY11 FY12 FY13 FY14 FY15 FY16 FY17 FY18 FY19 Groundwater(OCWD) Import Water(MWDOC) 7 MATERIALS SUBMITTED BY: Kaden Young MEETING DATE: April 3, 2018 REVISED ITEM NO. 5.1. Variable Costs : Energy & CUP/ In - Lieu Fees $1,800,000 $1,722,525 $1,740,205 $1,600,000 $1,525,358 $1,482,334 $1,399,994 _ $1,400,000 $1,320,943 $1,241,474 $1, $1,200,000 $1,157,895 $1,000,000 $966,181 $822,011 $787,444 $800,000 $681,471 $605,535 $600,000 $400,000 $200,000 $- FY11 FY12 FY13 FY14 FY15 FY16 FY17 FY18 FY19 FY11 FY12 FY13 FY14 FY15 FY16 FY17 FY18 FY19 CUP/In-Lieu Purchased Water ENERGYCosts 18 l� �oO�O MATERIALS SUBMITTED BY: Kaden Young MEETING DATE: April 3, 2018 REVISED ITEM NO. 5.1. Retail Consumption Volume : FY18 vs FY19 Retail Consumption Volume FY18 vs FY19 2500 2000 — 11 1500 —— — po U - i LU J - 1000 _ f f 500 0 FY18 FY19 FY18 FY19 FY18 FY19 FY18 FY19 FY18 FY19 FY18 FY19 FY18 FY19 FY18 FY19 FY18 FY19 FY18 FY19 FY18 FY19 FY18 FY19 JUL AUG SEP OCT NOV DEC JAN FEB MAR APR MAY JUN ❑Residential ❑Commercial ❑Irrigation KA — — MATERIALS SUBMITTED BY: Kaden Young MEETING DATE: April 3, 2018 REVISED ITEM NO. 5.1. Total Volumetric Revenue : FYI 8 vs FYI 9 Volumetric Revenue FY18 vs FY19 $25,000,000 $3,000,000 FY18 $22,418,635 $20,000,000 FY19 $2,500,000 $21,900,868 M $2,000,000 $15,000,000 ■ $1,500,000 $10,000,000 $1,000,000 i $5,000,000 00 $500,000 JUL AUG SEPT OCT NOV DEC JAN FEB MAR APR MAY JUN FY18 Monthly FY19 Monthly FY18 Cumulative FY19 Cumulative MATERIALS SUBMITTED BY: Kaden Young MEETING DATE: April 3, 2018 REVISED ITEM NO. 5.1. Volumetric Revenue : FY1 1 to FYI 9 $30,000,000 $25,000,000 $20,000,000 $15,000,000 $10,000,000 $5,000,000 FY11 FY12 FY13 FY14 FY15 FY16 FY17 FY18 FY19 22 MATERIALS SUBMITTED BY: Kaden Young MEETING DATE: April 3, 2018 REVISED ITEM NO. 5.1. Potential As projected: $25,000,000 25000 - 20,473 AF — $21 ,900,868 revenue $20,000,000 20000 variable costs M N • 15% decrease in production $15,000,000 a 15000 - 17,402 AF Ln LnLn LL N c - $18,615,738 revenue — $12,398,949 variable costs $10,000,000 10000 • 25% decrease in production - 15,354 AF $5,000,000 5000 - $16,425,651 revenue - $11 ,089,360 variable costs $ PROJECTED 15% 25% O AF O Revenue O Costs Linear(AF) Linear(Revenue) - Linear(Costs) 23 MATERIALS SUBMITTED BY: Kaden • • AprilMEETING DATE: 1 NO. i � • M 1 / Cow& ` r *t&w Da6Du&td 64mll f r r Iti r 1 1 i MATERIALS SUBMITTED BY: Kaden Young MEETING DATE: April 3, 2018 REVISED ITEM NO. 5.1. Supplies ervices - 10 Year Trend $6,000,000 $5,000,000 $4,000,000 $3,000,000 �o m $2,000,000 $1,000,000 FY10 Actual FY11 Actual FY12 Actual FY13 Actual FY14 Actual FY15 Actual FY16 Actual FY17 Actual FY18 Forecast FY19 Proposed 25 MATERIALS SUBMITTED BY: Kaden Y.)uriy MEETING DATE: April 3, 2018 REVISED Variance ITEM NO. 5.1. FY19 to Variance FY19 FY17 Actuals FY18 Budget X18 FY19 Budget FY18 Percent Budget to Percent Forecast Change FY18 Change (Budget to Projections Budget) Supplies & Services Communications $ 166,199 $ 201 ,575 $ 180,099 $ 171 ,597 $ (29,978) -15% $ (8,502) -5% Contractual Services $ 440,313 $ 547,890 $ 468,247 $ 538,732 $ (9,158) -2% $ 70,485 15% Data Processing $ 271 ,760 $ 250,400 $ 260,400 $ 281 ,450 $ 31 ,050 12% $ 21 ,050 8% Dues & Memberships $ 92,429 $ 86,545 $ 85,976 $ 88,230 $ 1 ,685 2% $ 2,254 3% Fees & Permits $ 265,033 $ 282,115 $ 276,999 $ 277,003 $ (5,112) -2% $ 4 0% Board Election Expenses $ 129,971 $ - $ - $ 75,000 $ 75,000 $ 75,000 Insurance $ 256,672 $ 283,340 $ 279,233 $ 303,190 $ 19,850 7% $ 23,957 9% Materials $ 880,454 $ 849,000 $ 779,331 $ 893,400 $ 44,400 5% $ 114,069 15% District Activities & Events $ 10,945 $ 24,200 $ 21 ,945 $ 44,825 $ 20,625 85% $ 22,880 104% Maintenance $ 539,926 $ 509,900 $ 573,747 $ 604,600 $ 94,700 19% $ 30,853 5% Non-Capital Equipment $ 173,707 $ 124,825 $ 114,314 $ 166,350 $ 41 ,525 33% $ 52,036 46% Office Expense $ 39,159 $ 42,625 $ 44,732 $ 47,900 $ 5,275 12% $ 3,168 7% Professional Services $ 613,289 $ 692,525 $ 659,849 $ 896,800 $ 204,275 29% $ 236,951 36% Professional Development $ 45,159 $ 66,510 $ 41 ,051 $ 89,140 $ 22,630 34% $ 48,089 117% Travel & Conferences $ 46,821 $ 115,245 $ 65,181 $ 152,640 $ 37,395 32% $ 87,459 134% Uncollectible Accounts $ 9,041 $ 18,500 $ 1 ,000 $ 3,000 $ (15,500) -84% $ 2,000 200% Utilities $ 160,002 $ 170,700 $ 204,588 $ 184,400 $ 13,700 8% $ (20,188) -10% Vehicle Expenses $ 361 ,126 $ 356,000 $ 361 ,262 $ 375,400 $ 19,400 5% $ 14,138 4% Supplies & Services Sub-Total $ 4,502,004 $ 4,621 ,895 $4,417,954 $ 5,193,657 $ 571,762 12.4% $ 775,703 17.6% MATERIALS SUBMITTED BY: Kaden Young MEETING DATE: April 3, 2018 REVISED ITEM NO. 5.1. Supplies ervices by Department 00 m 0 N m Ln $2,500,000 N ni O N N N , N N $2,000,000 $1,500,000 $1,000,000 0 0 Ln C) m w M ,n 00 0 o Ln io m o 0000 o1-1 00N ,n m rn v � m ri Ln Ln LO -1 N V1� N O u1 Itt O V Lam} LI Ql l0 N $500,000 � I'll.` o o M m 00 0 -Zi Ln m -1 rn 00 o rn BOD Admin Comm Eng Fin HR IT Ops FY18 Budget FY18 Projection FY19 Proposed Budget 27 MATERIALS SUBMITTED BY: Kaden Young MEETING DATE: April 3, 2018 REVISED ITEM NO. 5.1. Budget • Communications: ($29,978) • Data Processing : $31 ,050 • BOD Elections: $75,000 • Materials: $44,400 • District Activities: $20,625 • Maintenance : $94,700 • Non-Capital Equipment: $41 ,525 28 MATERIALS SUBMITTED BY: Kaden Young MEETING DATE: April 3, 2018 REVISED ITEM NO. 5.1. Budget (cont. ) • Professional Services: $204,275 • Professional Development- $22,630 • Travel & Conferences : $37,395 • Uncollectible Accounts: ($ 15,500) 29 MATERIALS SUBMITTED BY: Kaden Young MEETING DATE: April 3, 2018 REVISED ITEM NO. 5.1. Capital 30 MATERIALS SUBMITTED BY: Kaden Young MEETING DATE: April 3, 2018 REVISED ITEM NO. 5.1. Elements of thDistrict ' s CIP 1 . Construction Projects Increase Capacity, Capability, and Reliability \ - Began with 2005 Water Master Plan to ' Maximize Groundwater Use _,:: - Current projects: • Fairmont Booster Pump Station Upgrade ° • Well 22 - e8e'::::s:itii .............. :n 31 MATERIALS SUBMITTED BY: Kaden Young MEETING DATE: April 3, 2018 REVISED ITEM NO. 5.1. Elements o District ' s CIP (cont. ) 2. R&R Projects Replace and refurbish existing Capital Facilities How are projects identified for R&R? • Asset Management Plan (AMP) • Staff observations and identification of failing facilities 32 MATERIALS SUBMITTED BY: Kaden Young MEETING DATE: April 3, 2018 REVISED ITEM NO. 5.1. 2 0 1 8 a"d n6"pneat0)e0A _ - � - . UPDATE 33 MATERIALS SUBMITTED BY: Kaden Young MEETING DATE: April 3, 2018 • YLWD Assets �LYorbaLinda WWater District Water Wastewate 5uppart System System Systems 34 Dist�rihution Facilities and Callectian Facilities and Facilities and Pipelines Equipment Pipelines Equipment Equipment MATERIALS SUBMITTED BY: Kaden Young MEETING DATE: April 3, 2018 REVISED ITEM NO. 5.1. Asset Wastewater $352,849,000 Support $30,829,000 Water $689,923,000 Total Estimated Replacement Cast = $1 .07 billion MATERIALS SUBMITTED BY: Kaden Young MEETING DATE: April 3, 2018 REVISED ITEM NO. 5.1. Developmentof I 0CIP Condition + Remaining Life Risk Assessment Assessment Assessment F Year CIP 30 Projects = $53,451 ,000 36 MATERIALS SUBMITTED BY: Kaden Young MEETING DATE: April 3, 2018 REVISED ITEM NO. 5.1. 1 0-Year CIP Map : Water i�� 90 er r--- Bjjtin,hury Rq le Q lv� Yorbd un,*-Blvd # !�' .9 -6 � Ave L4 Z I [q 91 Sates Legend Water Mains a Tank Railroad —0-5 Year Replacements or Repairs I Water Boundary miles 5-10 Year Replacements or Repairs Highway —1958-1999 DIP Replacements Principal Arterial 37 Major Arterial Yorba Linda Water District MATERIALS SUBMITTED BY: Kaden Young MEETING DATE: April 3, 2018 REVISED ITEM NO. 5.1. 0-Year ap : Sewer �t �t3 _ ha LindA BirdLl L' f Nla Palma Ave `a Gao'1oT' � 73 a Legend Gravity Sewers 5-10 West mForce Main —0-5 East KE Lift Station —0-5 Central Sewer System Boundary Miles —0-5 West ❑ 0.325 0.65 5-10 East 38 5-10 Central Yorba Linda Water District MATERIALS SUBMITTED BY: Kaden Young MEETING DATE: April 3, 2018 REVISED ITEM NO. 5.1. 5 -Year u e 5 Year CIP Budget For Recommended Revised 5 Year Projected CIP Budget CIP Budget CIP Budget CIP Budget CIP Budget FY19& Budget CIP Budget for ExpensesThru FY19 FY20 FY21 FY22 FY23 Change Adjustments FY19 FYE June 2018 orders Water Caoitai-Debt Financed Fairmont BPS Upgrade $ 6,000,000 $ 6,000,000 $ 6,000,000 subtotal = $ 6,000,000 $ 6,000,000 $ 6,009,090 Water Capital Proiects Fairmont BPS Upgrade $ 2,159,471 $ 231,791 $ 2,391,262 $ 1,778,143 $ 613,119 S&W Well Project (Well No.22) $ 2,500,000 $ 2,500,000 $ 809,344 $ 320,000 $ 1,075,800 subtotal = $ 4,659,471 $ 231,791 $ 4,891,262 5 2,587,487 $ 933,119 $ 1,075,800 Rehabilitation&Restoration Proiects L airmont Reservoir R&R $ 259,000 $ 250,000 $ 250,000 PRS Rehabilitation Phase 2 $ 726,000 $ 726,000 $ 73,256 $ 579,585 Ekeview Booster Piping $ 1540000 $ 21,000 $ 175,000 $ 175,000 Tract#15199 Waterline Replacement $ 900,000 $ 900,000 $ 260,900 $ 640,000 [Field Headquarters Refurbishment Project $ 350,000 $ 350,000 $ 350,000 Mickel Waterline(formerly known as Replace Old CIP) $ 738,585 $ (438,585) $ 300,000 $ - $ 300,000 Camino Verde Waterline $ 438,585 $ 438,585 _ $ 438,585 Imperial Hwy Waterline $ 2,025,000 $ 2,025,000 $ - $ 25,000 $ 1,000,000 $ 10000,000 LDuctile Iron Pipe (DIP)Replacement $ 1,525,000 $ 1,525,000 $ - $ 25,000 $ 500,000 $ 500,000 $ 500,000 Ridgeway and Grandview Waterline $ 400,000 $ 400,000 $ - $ 400,000 ewer R&R(Relining) $ 200,000 $ 500,000 $ 700,000 $ 100,000 $ 100,000 $ 250,000 $ 250,000 Eisenhower Waterline $ 1,125,000 $ 1,125,000 $ - $ 25,000 $ 1,100,900 Timber Ridge BPS Rehabilitation $ 900,000 $ 750,000 $ 1,650,000 $ - $ 150,000 $ 1,500,000 Apple Creek and Del Rey PRS Rehabilitation $ 450,000 $ 450,000 $ - $ 450,000 New River Waterline $ 1,620,000 $ 1,620,000 $ - $ 20,000 $ 1,600,000 Hidden Hills BPS Rehabilitation $ 500,000 $ 500,000 $ 500,000 Rose Drive Waterline $ 1,020,900 $ 1,020,000 $ - $ 29,000 $ 1,000,000 Reservoir R&R $ 200,000 $ 200,000 $ - $ 200,000 Dominguez Hills and Cornell PRS Rehabilitation $ 450,000 $ 450,000 5 - $ 450,000 Santiago BPS Rehabilitation $ 1.000,009 $ 1,000,000 $ - S 1,000,000 Springview BPS Rehabilitation $ 500,000 $ 500,900 5 - $ 500,000 39 Subtotal = $ 3,618,SS5 $ 12,686,000 $ 16,304,585 $ 433,256 $ 3,274,170 5 2,375,000 $ 4,120,000 $ 3,070,000 S 2,950,000 MATERIALS SUBMITTED BY: Kaden Young MEETING DATE: April 3, 2018 REVISED ITEM NO. 5.1. Elements o District ' s CIP ( cont. ) 3. District Vehicles & Capital Outlay Items with value of $5,000 or more. - Scheduled Vehicle Replacements • 8 vehicles for FYI - Other Capital Equipment 40 MATERIALS SUBMITTED BY: Kaden Young MEETING DATE: April 3, 2018 REVISED ITEM NO. 5.1. Vehicle uimen a sl Outla Department/Item Amount IT V-Sphere Hosts (servers-Ready-Nod) $ 50,000 Board of Directors Server Replacement-GP/CMMS Host $ 21,500 Board Room Improvements $ 100,000 Server-NAS(high visibility) $ 18,000 Total Vehicle Equipment&Capital Outlay-BOD $ 100,000 Replace Personal Computers, Laptops, and Tablets $ 26,000 '"OIP Phone Redundancy(Phase 2-Install) $ 6,000 Administration Firewall Replacement(Administration) $ 17,000 District Pool Vehicle � $ 45..000 Network Infrastructure Security Upgrade $ 20,000 Total Vehicle Equipment&Capital Outlay-Admin. $ 45,000 Security Suite Enterprise-Malware Software $ 11,000 Engineering Security System-Camera(s) Yard $ 29,000 Hidden Hills Res. Landscape Mitigation Land Purchase $ 120,000 CMMS Laptops $ 15,000 Total Vehicle Equipment&Capital Outlay-Eng. $ 120,000 Total Vehicle Equipment&Capital Outlay-IT $ 213,500 Finance Operations Meter Reading Equipment $ 26,000 Water Operations&Maint. � Total Vehicle Equipment&Capital Outlay-Finance $ 26,000 Dump Truck $ 105,000Pickup Truck $ 35,000 Human Resources Pickup Truck $ 35,000 Safety Lighting $ 10,000 Skid Steer Loader/Sweeper $ 70,000 Total Vehicle Equipment&Capital Outlay-HR $ 10,000 Sewer Operations&Maintenance Camera Truck $ 300,000 Water Production Pickup Truck $ 35,000 Pickup Truck $ 35,000 Total Vehicle Equipment&Capital Outlay-Oper. $ 615,000 TOTAL VEHICLE EQUIPMENT&CAPITAL OUTLAY $ 1,129,500 Reconciliation by Fund Water Fund $ 829,500 Sewer Fund $ 300,000 TOTAL $ 1,129,500 41 MATERIALS SUBMITTED BY: Kaden Young MEETING DATE: April 3, 2018 REVISED ITEM NO. 5.1. Questions / Discussion 42 TOTAL BOD ADM ENG FIN HR IT OPS (of Componets) Communications Postage - Customer Billings/General $95,872 $95,872 General Business $625 $2,500 $3,125 Social Media/Video Productions $17,200 $17,200 Customer Newsletter $400 $400 Promotional Items $25,000 $25,000 MWDOC Choice Program- WUE $30,000 $30,000 Subtotal $0 $72,200 $400 $96,497 $2,500 $0 $0 $171,597 Contractual Services Copier Lease $19,000 $19,000 Warranties & Service Contracts/Data Hosting $500 $65,400 $65,900 District Cell Phones/Aircards $47,000 $47,000 District Uniforms $15,000 $15,000 Service Contracts- Janitor, Landscape, etc.$141,500 $141,500 General Business $1,125 $1,125 Printing of Bills $65,619 $65,619 Customer Service-Related $1,500 $14,153 $15,653 Hidden Hills Resv Environmental Mitigation $50,000 $50,000 Water Quality Testing $80,000 $80,000 Employee & Safety-Related $29,935 $29,935 Conservation Rebates $5,000 $5,000 Customer Usage Analytics $0 Subtotal $500 $6,500 $130,000 $80,897 $29,935 $131,400 $156,500 $535,732 Data Processing Software Purchases $12,200 $12,200 Software License Renewals $223,800 $35,000 $258,800 Hardware License Renewals $10,450 $10,450 Subtotal $0 $0 $0 $0 $0 $246,450 $35,000 $281,450 Dues & Memberships Departmental Dues & Memberships $60 $3,100 $9,200 $690 $7,570 $80 $250 $20,950 District-Related $67,280 $67,280 Subtotal $60 $70,380 $9,200 $690 $7,570 $80 $250 $88,230 Major Components of the FY19 Supplies & Services Proposed Budget, by Department ITEM NO. 5.1. MATERIALS SUBMITTED BY: Delia Lugo MEETING DATE: April 3, 2018 TOTAL BOD ADM ENG FIN HR IT OPS (of Componets) Fees & Permits Department of Health Services $66,400 $66,400 Bank-Related Fees $159,615 $159,615 Dig Alert $3,000 $3,000 Sewer-Related Fees $2,588 $2,588 Water Ops Fees $24,600 $24,600 AQMD/EPA Fees $20,800 $20,800 Subtotal $0 $0 $69,400 $159,615 $0 $0 $47,988 $277,003 Board Election Expenses None $75,000 $0 $0 $0 $0 $0 $0 $75,000 Subtotal $75,000 $0 $0 $0 $0 $0 $0 $75,000 Insurance Tort Claims $5,000 $5,000 Performance $1,090 $600 $1,690 Liability Insurance $250,500 $250,500 Property Insurance $46,000 $46,000 Subtotal $0 $1,090 $0 $600 $301,500 $0 $0 $303,190 Materials Water Meter Registers $23,000 $23,000 First Aid-Related $2,100 $2,100 Hardware Supplies $8,500 $8,500 Protective Equipment $15,000 $15,000 Water Ops Parts/Materials $645,500 $645,500 Sewer Ops Parts/Materials $35,500 $35,500 Water Quality Test Materials $3,000 $3,000 Water Production Parts/Materials $102,000 $102,000 SCADA Parts/Materials $11,600 $11,600 Mechanics Parts/Materials $10,700 $10,700 Facilities Parts/Materials $36,500 $36,500 Subtotal $0 $0 $3,000 $23,000 $2,100 $8,500 $856,800 $893,400 ITEM NO. 5.1. MATERIALS SUBMITTED BY: Delia Lugo MEETING DATE: April 3, 2018 TOTAL BOD ADM ENG FIN HR IT OPS (of Componets) District Activities & Events General Meeting Expenses $10,625 $1,000 $1,100 $5,700 $800 $3,000 $22,225 BOD Business Meeting Expenses $4,200 $4,200 District-wide Meetings/Events $18,400 $18,400 Subtotal $4,200 $10,625 $1,000 $1,100 $24,100 $800 $3,000 $44,825 Maintenance Water Ops Maintenance- Outside Vendors $278,000 $278,000 Sewer Ops Maintenance- Outside Vendors $168,000 $168,000 Water Quality $3,250 $3,250 General Business $300 $300 Water Production Maintenance- Outside Vendors $67,000 $67,000 SCADA Maintenance- Outside Vendors $39,500 $39,500 Facilities Maintenance- Outside Vendors $37,700 $37,700 GIS Printer Repair $1,500 $1,500 IT General Cabling/Printing/Phone Repair $12,350 $12,350 Subtotal $0 $0 $3,250 $300 $0 $13,850 $590,200 $607,600 Non-Capital Equipment Regulatory Required Safety Equipment $0 $10,000 $10,000 General Office $3,700 $2,000 $1,800 $15,250 $22,750 General Tools & Equipment- Water $500 $12,000 $12,500 General Tools & Equipment- Sewer $30,000 $30,000 Production/SCADA-Related $21,000 $21,000 Inspection Tools $600 $600 Faciities Tools & Equipment $6,000 $6,000 Mechanics Tools $8,000 $8,000 Desktop Computers $3,700 $3,700 Notebooks/Tablets $5,000 $8,500 $13,500 Computer Network Equipment $11,300 $11,300 Printers/Monitors/Scanners $4,500 $4,500 Admin Building IT Switch Replacements $18,000 $18,000 Various IT Equipment $500 $500 General Ergonomic Equipment $4,000 $4,000 Subtotal $5,000 $3,700 $600 $2,500 $5,800 $61,750 $87,000 $166,350 ITEM NO. 5.1. MATERIALS SUBMITTED BY: Delia Lugo MEETING DATE: April 3, 2018 TOTAL BOD ADM ENG FIN HR IT OPS (of Componets) Office Expense General Office Expense $1,000 $2,800 $2,900 $7,750 $1,650 $1,100 $11,300 $28,500 District-wide Printer Ink $13,000 $3,500 $16,500 District-wide Office Supplies/Paper $2,900 $2,900 Subtotal $1,000 $2,800 $2,900 $10,650 $1,650 $14,100 $14,800 $47,900 Professional Services General Consulting/Support $0 $11,800 $6,500 $9,000 $27,300 SCADA Software Consulting $30,000 $30,000 CMMS/GIS Consulting $30,000 $30,000 Legal Services $39,000 $120,000 $159,000 Legal Services- Water / IRWD vs. OCWD $120,000 $120,000 Legal Services - Sewer Related $10,000 $10,000 Employee Relations $92,000 $92,000 Financial Auditors $24,000 $24,000 Financial-Related Services $24,500 $24,500 Water Loss Consultant $20,000 $20,000 Bench-Scale Testing for Removal of PFCs $75,000 $75,000 Pilot-Scale Testing-Removal of Arsenic,$90,000 $90,000 Magnesium, and Iron Geotechnical Consultant $20,000 $20,000 Hazard Mitigation/Water Master Plan Update $50,000 $50,000 Cathodic Protection/Water Consulting $125,000 $125,000 Legislative Consulting $0 Subtotal $39,000 $250,000 $380,000 $60,300 $98,500 $39,000 $30,000 $896,800 Professional Development Professional Development/Training $4,400 $3,600 $4,020 $11,470 $41,850 $7,000 $16,800 $89,140 Subtotal $4,400 $3,600 $4,020 $11,470 $41,850 $7,000 $16,800 $89,140 Travel & Conferences Travel & Conferences $47,350 $38,990 $5,200 $4,850 $16,350 $17,200 $22,700 $152,640 Subtotal $47,350 $38,990 $5,200 $4,850 $16,350 $17,200 $22,700 $152,640 Uncollectible Accounts Uncollectible Accounts $3,000 $3,000 Subtotal $0 $0 $0 $3,000 $0 $0 $0 $3,000 ITEM NO. 5.1. MATERIALS SUBMITTED BY: Delia Lugo MEETING DATE: April 3, 2018 TOTAL BOD ADM ENG FIN HR IT OPS (of Componets) Utilities SCADA Communication Lines $26,000 $26,000 District Phone Lines $7,000 $7,000 District Internet Lines $30,700 $30,700 Co-location Lines $20,000 $20,000 Electrictity- District Headquarters site $100,700 $100,700 Subtotal $0 $0 $0 $0 $0 $83,700 $100,700 $184,400 Vehicle Expenses Vehicle Expenses- Engineering $9,800 $9,800 Vehicle Expenses- Finance/Meter Readers $14,900 $14,900 Vehicle Expenses- Water Ops $148,700 $148,700 Vehicle Expenses- Sewer Ops $49,100 $49,100 Vehicle Expenses- Production $22,000 $22,000 Vehicle Expenses- Mechanics $10,000 $10,000 Vehicle Expenses- Facility Maint.$1,900 $1,900 Stationary Engine-Related $115,000 $115,000 Haz-Mat Disposal $4,000 $4,000 Subtotal $0 $0 $0 $0 $0 $0 $375,400 $375,400 S&S Sub-Total, Components Only $176,510 $459,885 $608,970 $455,469 $531,855 $623,830 $2,337,138 $5,193,657 S&S Sub-Total, full S&S Budget $176,510 $459,885 $608,970 $455,469 $531,855 $623,830 $2,337,138 $5,193,657 5,193,657$ -$ 3.40%8.85%11.73%8.77%10.24%12.01%45.00%100.00% ITEM NO. 5.1. MATERIALS SUBMITTED BY: Delia Lugo MEETING DATE: April 3, 2018