The URL can be used to link to this page

Home My WebLink AboutAgenda Packet - EVWD Board of Directors - 03/22/2017REGULAR BOARD MEETING Closed Session Begins at 4:30 PM March 22, 2017 - 5:30 PM 31111 Greenspot Road, Highland, CA 92346 AGENDA "In order to comply with legal requirements for posting of agenda, only those items filed with the District Clerk by 12:00 p.m. on Wednesday prior to the following Wednesday meeting not requiring departmental investigation, will be considered by the Board of Directors". CALL TO ORDER ROLL CALL OF BOARD MEMBERS PUBLIC COMMENTS Any person wishing to speak to the Board of Directors is asked to complete a Speaker Card and submit it to the District Clerk prior to the start of the meeting. Each speaker is limited to three (3) minutes, unless waived by the Chairman of the Board. Under the State of California Brown Act, the Board of Directors is prohibited from discussing or taking action on any item not listed on the posted agenda. The matter will automatically be referred to staff for an appropriate response or action and may appear on the agenda at a future meeting. AGENDA - This agenda contains a brief general description of each item to be considered. Except as otherwise provided by law, no action shall be taken on any item not appearing on the following agenda unless the Board of Directors makes a determination that an emergency exists or that a need to take immediate action on the item came to the attention of the District subsequent to the posting of the agenda. 1.Approval of Agenda RECESS INTO CLOSED SESSION CLOSED SESSION 2.CONFERENCE WITH LEGAL COUNSEL - EXISTING LITIGATION [Government Code Section 54956.9(d) (1)] Name of Case: Socal Environmental Justice Alliance v. San Bernardino Valley Municipal Water District, et al., San Diego Superior Court Case No. 37-2016-00032816-CU-TT-CTL 3.CONFERENCE WITH LEGAL COUNSEL - EXISTING LITIGATION [Government Code Section 54956.9(d) (1)] Name of Case: City of San Bernardino v. East Valley Water District, et al., San Diego Superior Court Case No. 37-2016-00038119-CU-WM-CTL 4.CONFERENCE WITH LEGAL COUNSEL - EXISTING LITIGATION [Government Code Section 54956.9(d)(1)] Name of Case: Carl F. Kovach v. East Valley Water District, CASE No. CIVDS 1603176 5.CONFERENCE WITH LEGAL COUNSEL – ANTICIPATED LITIGATION Initiation of litigation pursuant to Government Code Section 54956.9(c) One (1) Potential Case 5:30 PM RECONVENE MEETING PLEDGE OF ALLEGIANCE ROLL CALL OF BOARD MEMBERS ANNOUNCEMENT OF CLOSED SESSION ACTIONS ITEMS PUBLIC COMMENTS 6.APPROVAL OF CONSENT CALENDAR All matters listed under the Consent Calendar are considered by the Board of Directors to be routine and will be enacted in one motion. There will be no discussion of these items prior to the time the board considers the motion unless members of the board, the administrative staff, or the public request specific items to be discussed and/or removed from the Consent Calendar. a.February 8, 2017 regular meeting minutes b.March 8, 2017 regular meeting minutes c.February 2017 Disbursements: Accounts payable disbursements for the period include check numbers 249531 through 249702, bank drafts, and ACH Payments in the amount of $2,025,806.44 and $299,791.87 for payroll. d.Financial Statements for February 2017 DISCUSSION AND POSSIBLE ACTION ITEMS 7.Disposition of Surplus Property 8.Business Intelligence Contract Award REPORTS 9.Board of Directors' Reports 10.General Manager/CEO Report 11.Legal Counsel Report 12.Board of Directors' Comments ADJOURN P LEASE NOT E: Materials related to an item on this agenda s ub mitted to the Board after dis trib utio n of the agenda pac ket are available for p ublic inspec tio n in the Dis tric t's offic e loc ated at 31111 G reens pot Rd., Highland , during no rmal bus iness ho urs. Als o, s uc h d o c uments are availab le o n the District's web s ite at www.eas tvalley.o rg sub ject to s taff's ab ility to post the d o cuments b efo re the meeting. P ursuant to Go vernment Co d e S ectio n 54954.2(a), any reques t fo r a dis ability-related modific ation or ac commod ation, inc luding auxiliary aids or s ervic es , that is s ought in order to participate in the abo ve- agendized p ublic meeting sho uld b e direc ted to the Dis tric t Clerk at (909) 885-4900 at leas t 72 hours prior to said meeting. 1 Minutes 2/08/2017 smg Subject to Approval EAST VALLEY WATER DISTRICT February 8, 2017 REGULAR BOARD MEETING MINUTES The Chairman of the Board called the meeting to order at 4:30 p.m. PRESENT: Directors: Carrillo, Coats, Morales, Shelton, Smith ABSENT: None STAFF: Brian Tompkins, Chief Financial Officer; Steven Nix, Director of Engineering & Operations; Justine Hendricksen, District Clerk; Shayla Gerber, Administrative Assistant LEGAL COUNSEL: Jean Cihigoyenetche GUEST(s): Members of the public PUBLIC COMMENTS Chairman Coats declared the public participation section of the meeting open at 4:30 p.m. There being no written or verbal comments, the public participation section was closed. APPROVAL OF AGENDA M/S/C (Carrillo-Shelton) that the February 8, 2017 agenda be approved as submitted. CLOSED SESSION The Board entered into Closed Session at 4:31 p.m. as provided in the Ralph M. Brown Act Government Code Sections 54956.9(d)(1) to discuss the item(s) listed on the agenda. THE BOARD RECONVENED THE MEETING AT 5:30 P.M. Mr. Fred Yauger led the flag salute. 2 Minutes 2/08/2017 smg ROLL CALL PRESENT: Directors: Carrillo, Coats, Morales, Shelton, Smith ABSENT: None ANNOUNCEMENT OF CLOSED SESSION ACTIONS With respect to Item #2 and #3: The Board of Directors, by unanimous vote (5-0), authorized legal counsel to: 1. Proceed with a writ to the court of appeals challenging the decision of the trial court and denying or overruling the demur previously filed to the complaint. 2. Authorize the filing of cross complaint for declaratory relief against the City of San Bernardino. With respect to Item #4: M/S/C (Smith-Shelton) that the Board of Directors provide indemnity for punitive damages to the individually named defendants in that action including Coleman, Morales, Coats and Levesque; and the Board of Directors at the same time made the following factual findings: 1. The potential judgement is based on an act of the individual defendant as Board Members acting within the course and scope of their scope of duties as elected officials of the District; 2. At the time of the act giving rise to the liability in the complaint that the officials acted, failed to act, in good faith, without actual malice and in the apparent best interests of the public entity; and 3. Shall a payment of the claim or judgement arise; it would be in the best interests of the public entity. Legal Counsel stated that the findings are required under Government Code Section 825; and Directors Coats and Morales recused themselves from the discussion and vote, as they are beneficiaries of the vote having been named as individual defendants in the actions. Roll call vote: Director Morales - Recused Vice Chairman Carrillo - Yes Director Shelton - Yes Director Smith – Yes Chairman Coats - Recused 3 Minutes 2/08/2017 smg PUBLIC COMMENTS Chairman Coats declared the public participation section of the meeting open at 5 :34 p.m. There being no written or verbal comments, the public participation section was closed. DIRECTORS’ FEES AND EXPENSES FOR JANUARY 2017 M/S/C (Smith-Carrillo) that the Board approve the Directors’ fees and expenses for January 2017 as submitted. PAYNEARME PROJECT UPDATE The Business Services Manager provided the Board with an update on the PayNearMe program; he reviewed statistics since the implementation of the program, customer outreach efforts, and additional payment options available to customers other than the new PayNearMe program. He informed the Board that customers who use third party vendors to pay their bill are typically charged a fee by the vendor and the District does not receive the payment as quickly as other options that are provided by the District; he stated that input errors are more likely to occur with third party payment vendors. The Chief Financial Officer added that the District does not authorize any third party payment options. Chairman Coats commended staff for thinking outside the box and providing cost saving measures to ratepayers by offering additional payment options. Information only. AUTOMATED METERING INFRASTRUCTURE UPDATE The Director of Engineering and Operations presented an update regarding the Automated Metering Infrastructure (AMI) project. He stated that the District is three months into the project and reviewed the progress to date; he displayed Phase-1 meter replacement locations; showed an example of a typical data installation of data collectors, presented a visual example of a typical meter installation; and displayed public outreach efforts. He stated it may take four additional phases to complete the project and that it is expected to be completed on time as originally anticipated. The Director of Engineering and Operations discussed AMI radio-wave technology; he stated that originally there were no provisions for opting out of the program, but that customers may request a hold of meter installation; after the first 7,100 are installed, staff will revisit an opt-out provision; that to date two customers have opted out of the new AMI meter installation. 4 Minutes 2/08/2017 smg Information only. BOARD OF DIRECTORS’ REPORTS Director Morales reported on the following: on February 1st he attended the Association of California Water Agencies (ACWA) Region 9 planning meeting where they discussed future events; on February 3rd East Valley Association of Realtors where he provided them with an update regarding the District and the Sterling Natural Resource Center; and on February 7th he attended a follow-up ACWA Region 9 Board meeting where they elected a new board member. Director Smith reported on the following: on February 2nd he attended the Water Conservation Committee meeting where he received a drought update and he presented the information to the Board; and on February 8th he attended the San Bernardino Valley Water Conservation District Board meeting. Director Shelton reported on the following: on January 30th she attended Board Communication training at the District and on February 2nd she attended the Water Conservation Committee meeting where the discussed rebates and public outreach efforts to encourage water conservation. Vice Chairman Carrillo reported on the following: on February 1st he attended a meeting with the Chairman and the Chief Financial Officer to discuss the Mid-Year Budget review; and on February 2nd he met with the General Manager/CEO and the Chairman to review the agenda. Chairman Coats reported on the following: on February 7th he attended the San Bernardino Valley Municipal Water District (SBVMWD) Board meeting. Information only. GENERAL MANAGER/CEO REPORT No reports at this time. LEGAL COUNSEL REPORT No reports at this time. BOARD OF DIRECTORS’ COMMENTS Director Morales expressed his condolences to the family of Mr. Bud Wright, North Fork Shareholder, in his passing. Chairman Coats adjourned the meeting with the following statement: “Help insure your water future by supporting the Sterling Natural Resource Center”. 5 Minutes 2/08/2017 smg Information only. ADJOURN The meeting adjourned at 6:04 p.m. ___________________________ Ronald L. Coats, Board President __________________________ John Mura, Secretary 1 Minutes 3/08/2017 smg Subject to Approval EAST VALLEY WATER DISTRICT March 8, 2017 REGULAR BOARD MEETING MINUTES The Chairman of the Board called the meeting to order at 4:00 p.m. PRESENT: Directors: Carrillo, Coats, Morales, Shelton, Smith ABSENT: None STAFF: Brian Tompkins, Chief Financial Officer; Steven Nix, Director of Engineering & Operations; Justine Hendricksen, District Clerk; Shayla Gerber, Administrative Assistant LEGAL COUNSEL: Jean Cihigoyenetche GUEST(s): Members of the public PUBLIC COMMENTS Chairman Coats declared the public participation section of the meeting open at 4:00 p.m. There being no written or verbal comments, the public participation section was closed. APPROVAL OF AGENDA M/S/C (Carrillo-Shelton) that the March 8, 2017 agenda be approved as submitted. CLOSED SESSION The Board entered into Closed Session at 4:01 p.m. as provided in the Ralph M. Brown Act Government Code Sections 54956.9(d)(1) and 54957 to discuss the item(s) listed on the agenda. THE BOARD RECONVENED THE MEETING AT 5:30 P.M. Mr. Tom Shalhoub led the flag salute. 2 Minutes 3/08/2017 smg ROLL CALL PRESENT: Directors: Carrillo, Coats, Morales, Shelton, Smith ABSENT: None ANNOUNCEMENT OF CLOSED SESSION ACTIONS With respect to Item #2: No reportable action taken. With respect to Item #3: No reportable action taken. With respect to Item #4: No reportable action taken. With respect to Item #5: No reportable action taken. PRESENTATIONS AND CEREMONIAL ITEMS The General Manager/CEO presented Resolution 2017.04 to the family of Lois Hendricksen-Heflin for her 30 years of dedicated service. Information only. PUBLIC COMMENTS Chairman Coats declared the public participation section of the meeting open at 5 :36 p.m. Dr. June Hayes introduced herself to the Board as the newest board member on the San Bernardino Valley Municipal Water District Board. There being no further written or verbal comments, the public participation section was closed at 5:39 p.m. APPROVE THE JANUARY 25, 2017 REGULAR BOARD MEETING MINUTES M/S/C (Smith-Carrillo) that the Board approve the January 25, 2017 regular board meeting minutes as submitted. APPROVE THE FEBRUARY 22, 2017 REGULAR BOARD MEETING MINUTES M/S/C (Smith-Carrillo) that the Board approve the February 22, 2017 regular board meeting minutes as submitted. 3 Minutes 3/08/2017 smg DIRECTORS’ FEES AND EXPENSES FOR FEBRUARY 2017 M/S/C (Smith-Carrillo) that the Board approve the Directors’ fees and expenses for February 2017 as submitted. FY 2016-17 MID-YEAR BUDGET REVISIONS M/S/C (Smith-Carrillo) that the Board approve the amendments to the FY 2016- 17 Operating and Capital Budget as submitted. REVIEW AND APPROVE DEBT MANAGEMENT POLICY The Chief Financial Officer discussed the reasons staff is requesting that the Board adopt the updated Debt Management Policy; that there have been recent changes that need to be incorporated into the policy and that this is part of the finance department’s yearly goals; he stated the language in the updated policy is more clear to understand than the previous version and meets all requirements for certification guidelines. M/S/C (Morales-Shelton) that the Board approve the Debt Management Policy as submitted. RESOLUTION 2017.05 CHANGING THE BOARD OF DIRECTORS ELECTION CYCLE The General Manager/CEO provided information regarding changing the election cycle from odd-years to even-years; that recently passed Senate Bill 415 could force the District to change election cycles to even-years; he stated that the Clerk of the Board notified the District that at least half of the Special Districts in San Bernardino County with current odd-year elections have petitioned to change to even-year elections and the effect would place the District in a smaller pool of Special Districts with odd-year elections and potentially greatly increase election costs; that the deadline for requesting changes in accordance with existing law is March 10, 2017. M/S/C (Shelton-Smith) that the Board adopt Resolution 2017.05 approving a change in the regular election for the Board of Directors from November of odd- numbered years to the statewide general election in November of even-numbered years. GENERAL MANAGER/CEO COMPENSATION Legal Counsel announced that the General Manager/CEO’s performance evaluation was discussed in closed session and the matter before the Board is to make a determination with respect to the performance award of his contract; remaining aspects of the General Manager/CEO’s contract remain unchanged. M/S/C (Morales-Carrillo) that the Board approve the General Manager/CEO’s 10% pay for performance award in the amount of $26,265. 4 Minutes 3/08/2017 smg BOARD OF DIRECTORS’ REPORTS Director Smith reported on the following: on February 28th he attended the Highland Chamber of Commerce meeting, and the Finance & Policy Committee meeting where they reviewed the Debt Management Policy; on March 1st he attended the San Bernardino Valley Water Conservation District Board meeting where they discussed elections; and on March 7th he attended the City of San Bernardino Municipal Water Department’s board meeting where they discussed the EIR for the Clean Water Factory project. Director Shelton reported on the following: on February 27th she attended the Association of San Bernardino County Special Districts (ASBCSD) meeting where a speaker from ESRI discussed geographic information systems (GIS). Director Morales reported on the following: on March 1st he attended the Association of California Water Agencies (ACWA) Region 9 meeting where they discussed educational planning; on March 2nd he met with Legal Counsel; on March 3rd he attended the Legislative & Public Affairs Committee meeting; and on March 7th he attended a legislative meeting in Sacramento. Vice Chairman Carrillo reported on the following: on February 24th he attended the 2X2 Recycled Water Ad-Hoc Committee meeting at San Bernardino Valley Municipal Water District; on March 3rd he attended the Legislative & Public Affairs Committee meeting; and on March 7th he attended the legislative meeting in Sacramento. Chairman Coats reported on the following: on February 24th he attended the 2X2 Recycled Water Ad-Hoc Committee meeting at San Bernardino Valley Municipal Water District; on February 27th he attended the Association of San Bernardino County Special Districts (ASBCSD); and on March 7th he attended the San Bernardino Valley Municipal Water District (SBVMWD) Board meeting where they discussed District business. Information only. GENERAL MANAGER/CEO REPORT The General Manager/CEO attended the legislative symposium in Sacramento and commended Vice Chairman Carrillo and Chairman Coats on representing the District in a positive manner; he congratulated the Chief Financial Officer and finance staff for being awarded the Certificate of Achievement for Excellence in Financial Reporting and Distinguished Budget from the Government Finance Officers Association for the Comprehensive Annual Financial Report (CAFR); and he stated that the Employee Events Association will be hosting a “Subs for Shoes” employee lunch on March 8th in an effort to raise funds for shoes for Hunt Elementary School students. The General Manager/CEO informed the Board that he will be out of the office beginning March 8th and returning on March 15th and Mr. Tompkins will be assuming his duties and responsibilities in his absence. 5 Minutes 3/08/2017 smg The General Manager/CEO informed the Board of upcoming events: • March 11th @ 9:00 a.m. – Conservation “Fix a Leak” Workshop held at the District • March 14th @ 6:00 p.m. – Community Advisory Committee meeting • March 25th – Highland Citrus Harvest Festival Information only. LEGAL COUNSEL REPORT No reports at this time. BOARD OF DIRECTORS’ COMMENTS Director Morales stated that he is looking forward to the District’s poster contest “Beyond the Faucet”; and stated that the General Manager/CEO is an asset to the community and his dedication to the people that live in the community; and thanked him for his service. Chairman Coats echoed Director Morales’ comments and adjourned the meeting with the following statement: “Help insure your water future by supporting the Sterling Natural Resource Center”. Information only. ADJOURN The meeting adjourned at 6:17 p.m. ___________________________ Ronald L. Coats, Board President __________________________ John Mura, Secretary BOARD AGENDA STAFF REPORT Agenda Item #6.c. Meeting Date: March 22, 2017 Cons ent Item To: Go verning Board Members From: General Manager/CEO Subject: F eb ruary 2017 Dis burs ements: Ac counts payable disburs ements for the period inc lud e check numbers 249531 through 249702, bank drafts, and ACH P ayments in the amount of $2,025,806.44 and $299,791.87 fo r payroll. RECOMMENDATION: S taff rec ommend s that the Board o f Directors review and appro ve the Dis trict’s exp ense d isbursements fo r the period February 1, 2017 through February 28, 2017 in the amo unt o f $2,325,598.31. BACKGROUND / ANALYSIS: In the c o ntinued effort to b e fis cally trans p arent, the p ayment regis ter for s upplies, materials , services , and p ayro ll fo r F eb ruary 2017 is attac hed fo r review and ap pro val. This pro cess p rovides the Board and the p ublic an o p p o rtunity to review the exp ens es of the Distric t. Ac c ounts Payab le is p roc es s ed weekly, while payroll is pro cessed b i-weekly. Informatio n to justify each expend iture is availab le through the Financ e Dep artment. Ac counts payable d isbursements fo r the p erio d include c heck numbers 249531 thro ugh 249702, bank d rafts, and ACH Payments in the amount of $2,025,806.44 and $299,791.87 for p ayro ll. Signific ant expens es greater than o r equal to $50,000 are further explained belo w: Recommend ed b y: John Mura General Manager/CEO Respec tfully sub mitted : Brian Tomp kins Chief Financ ial Officer AGENCY IDEALS AND ENDEAVORS: Id eals and End eavor II - Maintain An Environment Co mmitted To Elevated Public Service (E) - Prac tic e trans p arent & acc o untab le fisc al management FISCAL IMPACT : Sufficient funds have been budgeted in the adopted FY 2016-17 Budget. ATTACHMENTS: Description Type February 2017 P ayment Register Bac kup Material Recommended by: Jo hn Mura General Manager/CEO Res p ec tfully s ub mitted : Brian To mpkins Chief Financial Offic er BOARD AGENDA STAFF REPORT Agend a Item #6.d. Meeting Date: Marc h 22, 2017 Co nsent Item To: Governing Bo ard Memb ers From: General Manager/CEO Subject: F inanc ial S tatements for Feb ruary 2017 RECOMMENDATION: Staff recommends that the Board of Direc tors ac cept and file the attached financial s tatements as of, and for the p eriod end ed , Feb ruary 28, 2017. BACKGROUND / ANALYSIS: Includ ed herewith for the Bo ard ’s review is a summary of East Valley Water Distric t’s financ ial results , as o f Feb ruary 28, 2017. AGENCY IDEALS AND ENDEAVORS: Ideals and Endeavor II - Maintain An Enviro nment Committed To Elevated P ublic Servic e (E) - Practice transparent & acc o untab le fis cal management FISCAL IMPACT : T here is no fis c al imp ac t as s o c iated with this agenda item. ATTACHMENTS: Description Type February 2017 Financial Statement Mo nthly Backup Material February 2017 Financial Statements Backup Material FINANCIAL STATEMENTS MONTHLY REVIEW FEBRUARY 28, 2017 page | 1 The following is a highlight summary of the District’s financial results as of February 28, 2017. Statement of Net Position Total assets at February 28, 2017 are $182.1 million. CLASSIFICATION WATER WASTEWATER DISTRICT TOTAL Cash and Investments $ 14,976,725 $ 3,835,455 $ 18,812,180 Utility Plant, Net 109,267,569 20,174,489 129,442,058 Other Assets 21,400,872 12,481,882 33,882,753 Current Liabilities 5,039,767 381,943 5,421,710 Long Term Liabilities 50,500,536 6,887,189 57,387,724 Beginning Net Position 83,494,528 27,982,873 111,477,402 Change in Equity 6,610,334 1,239,821 7,850,155 Total Net Position $ 90,104,863 $ 29,222,694 $ 119,327,557 Below is a summary of the District’s net position as of February 28, 2017. 5% 45% 2% 17% 31% WATER 5% 45% 1% 9% 40% WASTEWATER Current Assets Non-Current Assets Current Liabilities Non-Current Liabilities Net Position FINANCIAL STATEMENTS MONTHLY REVIEW FEBRUARY 28, 2017 page | 2 Cash and Investments are $18.4 million for the month of February, an increase of $0.4 million from the prior month. $0 $5,000,000 $10,000,000 $15,000,000 $20,000,000 $25,000,000 CASH & INVESTMENTS Restricted Unrestricted Comparing current assets to current liabilities, the District has a current ratio at February 28, 2017 of 3.19 to 1, with 2 to 1 being an indication of sound financial condition. Statement of Revenues & Expenses Operating results are presented in three ways in the attached financial statements for the period ending February 28, 2017. First is a one-page summary with monthly and year-to- date totals for revenue and expenses, presented by Expense Category. Second is a one- page summary with monthly and year-to-date totals for revenues and Expense by Program. Third is a Budget to Actual presentation of program expense detail. WATER WASTEWATER DISTRICT TOTAL Revenue $ 16,890,730 $ 8,649,867 $ 25,540,597 Expense 10,280,396 7,410,046 17,690,442 FINANCIAL STATEMENTS MONTHLY REVIEW FEBRUARY 28, 2017 page | 3 Water Sales for the month ending February 28, 2017 were $604,052, ($107,948) or (15%) under staff’s projections for the month. The billing periods during the month of February experienced an average temperature of 53 degrees, additionally the average Evapotranspiration Rates (ETo) for the period was 0.89 inches which was 1.88 inches less, compared to this time last year. Water sales year-to-date are over projections by $608,321. The National Oceanic and Atmospheric Administration (NOAA) stated that California has received more rain in the October to February time period since record keeping began 122 years ago. There was a total of 2.07 inches of rainfall during the month of February. $- $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 Water Sale by Tier Tier 1 Tier 2 Tier 3 FY 2016-17 Projection FINANCIAL STATEMENTS MONTHLY REVIEW FEBRUARY 28, 2017 page | 4 The charts below provide a visual of the external factors that influences the District’s Water Budget Based Rates. 50% 55% 60% 65% 70% 75% 80% 85% 90% Average Air Temperature by Month FY2015‐16 Avg Temp, Highland CA FY2016‐17 Avg Temp, Highland CA ‐ 1.00 2.00 3.00 4.00 5.00 6.00 7.00 8.00 9.00 10.00 Evapotranspiration Rate (ETo) by Month FY2015‐16 ETo FY2016‐17 ETo FINANCIAL STATEMENTS MONTHLY REVIEW FEBRUARY 28, 2017 page | 5 The chart below is a comparative illustration of current Water Revenue compared to last year’s Water Revenue. As noted in the graph Water Sales and Meter Charges increase over last year by 49,000 (7%). $- $200,000 $400,000 $600,000 $800,000 $1,000,000 $1,200,000 $1,400,000 $1,600,000 2/28/2016 2/28/2017 Comparative Monthly Water Revenue (Water Sales & Meter Charge) Meter Tier 1 Tier 2 Tier 3 FINANCIAL STATEMENTS MONTHLY REVIEW FEBRUARY 28, 2017 page | 6 Water Fund Activities by Cost Center The graph below provides a year-to-date comparison of the Water Fund operating cost centers for FY 2015-16 and FY 2016-17. The variance in Source of Supply is due to the District’s annual payment to San Bernardino Valley Municipal Water District for water. The purchase was adopted with the FY2016-17 Operating Budget. FINANCIAL STATEMENTS MONTHLY REVIEW FEBRUARY 28, 2017 page | 7 Wastewater Fund Activities by Cost Center The graph below provides a year-to-date comparison of the Wastewater Fund operating cost centers for FY 2015-16 and FY 2016-17. The largest increase is in Treatment which increased $518K compared to last year due to the new Wastewater Treatment rate increases imposed by the City of San Bernardino effective July 1, 2016. WATER WASTEWATER DISTRICT TOTAL Assets: Current Assets: 01 Cash and Cash Equivalents 6,620,274.75$ 1,281,744.26$ 7,902,019.01$ 02 Investments 3,516,284.13 1,871,310.08 5,387,594.21 03 Accounts Receivable, Net 3,004,564.14 246,815.66 3,251,379.80 04 ‐Interest Receivable 5,951.06 3,377.19 9,328.25 14*05 Other Receivables 374,970.29 - 374,970.29 06 Due from other Governments 16,144.57 - 16,144.57 08 Inventory 268,765.44 6,721.16 275,486.60 09 Prepaid Expenses 77,117.54 20,754.28 97,871.82 13,884,071.92 3,430,722.63 17,314,794.55 Non-Current Assets: 10 Restricted Cash and Cash Equivalents 4,840,165.76 682,400.65 5,522,566.41 11 Capital Assets not being Depreciated 16,521,944.71 11,929,212.93 28,451,157.64 13 Capital Assets, Net 109,267,568.85 20,174,488.96 129,442,057.81 130,629,679.32 32,786,102.54 163,415,781.86 Total Assets:144,513,751.24 36,216,825.17 180,730,576.41 Deferred Outflow Of Resources 24*Deferred Charge on Refunding 156,417.49 - 156,417.49 25 Deferred Outflows - Pensions 974,996.65 275,000.35 1,249,997.00 145,645,165.38 36,491,825.52 182,136,990.90 Current Liabilities: 22 Accounts Payable and Accrued Expenses 615,935.96 29,959.97 645,895.93 23 Accrued Payroll and Benefits 318,439.94 85,834.82 404,274.76 15 Customer Service Deposits 1,635,697.35 - 1,635,697.35 16 Construction Advances and Retentions 106,000.00 3,500.00 109,500.00 17 Accrued Interest Payable 430,093.03 55,881.25 485,974.28 18 Current Portion of Compensated Absences 258,472.59 93,808.69 352,281.28 19 Current Portion of Long-Term Debt 1,675,128.45 112,958.00 1,788,086.45 5,039,767.32 381,942.73 5,421,710.05 Non-Current Liabilities: 20 Compensated Absences, less current portion 195,383.58 29,881.34 225,264.92 28 Net Pension Liability 6,183,974.30 1,744,198.70 7,928,173.00 21 Long Term Debt, Less Current Portion 43,455,535.63 4,753,655.80 48,209,191.43 27 Other Liabilities 7,261.71 173,755.00 181,016.71 Deferred Inflows Of Resources 26 Deferred Inflows - Pensions 658,380.29 185,697.71 844,078.00 50,500,535.51 6,887,188.55 57,387,724.06 55,540,302.83 7,269,131.28 62,809,434.11 31 Equity 83,494,528.37 27,982,873.18 111,477,401.55 83,494,528.37 27,982,873.18 111,477,401.55 Tot Total Revenue 16,890,730.10 8,649,866.83 25,540,596.93 Tot Total Expense 10,280,395.92 7,410,045.77 17,690,441.69 6,610,334.18 1,239,821.06 7,850,155.24 90,104,862.55 29,222,694.24 119,327,556.79 145,645,165.38$ 36,491,825.52$ 182,136,990.90$ Unaudited As of February 28, 2017 Combining Schedule of Net Position Total Equity and Current Surplus (Deficit): Total Assets and Deferred Outflows of Resources: Total Current Assets: Total Non-Current Assets: Total Liabilities, Equity and Current Surplus (Deficit): Total Total Beginning Equity: Equity: Revenues Over/Under Expenses Total Current Liabilities: Total Non-Current and Deferred Inflows of Resources: Total Liabilities and Deferred Inflows of Resources: Page 1 of 8 ADOPTED AMENDED ADOPTED REMAINING MTD YTD BUDGET MTD YTD BUDGET TOTAL BUDGET BUDGET Revenue 41 Water Sales 604,051.87$ 9,896,321.31$ 13,500,000.00$ -$ -$ -$ 13,500,000.00$ 3,603,678.69$ 42 Meter Charges 741,604.23 5,922,881.52 8,960,000.00 - - - 8,960,000.00 3,037,118.48 43 Penalties 43,322.72 393,762.06 635,000.00 3,633.53 28,937.00 50,000.00 685,000.00 262,300.94 44 Wastewater System Charges - - - 362,433.05 3,157,872.59 4,460,000.00 4,460,000.00 1,302,127.41 45 Wastewater Treatment Charges - - - 613,021.10 5,391,908.06 7,610,000.00 7,610,000.00 2,218,091.94 46 Other Operating Revenue 102,111.72 575,509.42 170,000.00 2,525.00 56,413.96 190,000.00 360,000.00 (271,923.38) 47 Non Operating Revenue 6,384.56 79,923.79 120,000.00 - 14,735.22 22,000.00 142,000.00 47,340.99 48 Gain or Loss on Disposition - 22,332.00 - - - - - (22,332.00) 56 Benefits 49.37 242.42 - 21.16 51.47 - - (293.89) 68 Depreciation - - - - - - - Revenue Total: 1,497,475.10 16,890,730.10 23,385,000.00 981,612.68 8,649,866.83 12,332,000.00 35,717,000.00 10,176,403.07 - - - - - Expense by Category 51 Labor 327,930.21 2,995,679.69 4,520,900.00 68,626.50 841,666.73 1,325,100.00 5,846,000.00 2,008,653.58 56 Benefits 154,162.59 1,321,303.31 1,876,400.00 32,550.01 310,573.32 567,600.00 2,444,000.00 812,123.37 63 Contract Services 220,164.11 1,612,427.01 3,361,844.00 709,640.80 5,823,491.49 8,592,633.00 11,954,477.00 4,518,558.50 65 Professional Development 21,005.16 139,346.60 266,900.00 8,592.52 49,541.58 102,100.00 369,000.00 180,111.82 53 Overtime 18,213.10 209,574.49 258,700.00 644.06 9,231.08 17,300.00 276,000.00 57,194.43 62 Materials and Supplies 195,924.69 803,175.01 1,463,912.00 9,656.29 89,797.79 154,400.00 1,618,312.00 725,339.20 64 Utilities 122,454.55 1,211,868.92 2,364,575.00 8,212.22 79,719.55 175,300.00 2,539,875.00 1,248,286.53 52 Temporary Labor 2,667.41 34,151.95 20,300.00 1,143.19 12,800.56 8,700.00 29,000.00 (17,952.51) 67 Other 6,847.58 186,578.21 208,900.00 2,761.23 79,499.26 89,100.00 298,000.00 31,922.53 54 Standby 2,288.00 24,164.75 33,000.00 112.00 1,961.91 2,000.00 35,000.00 8,873.34 61 Water Supply - 864,310.37 1,245,000.00 - - - 1,245,000.00 380,689.63 71 -Debt Service 37,154.80 877,815.61 4,007,000.00 - 111,762.50 317,000.00 4,324,000.00 3,334,421.89 81 -Capital Improvement - - 1,070,000.00 - - 210,000.00 1,280,000.00 1,280,000.00 82 -Capital Outlay - - 266,269.00 - - 77,567.00 343,836.00 343,836.00 83 -Accounting Income Add back - - - - - - - - Expense Total: 1,108,812.20 10,280,395.92 20,963,700.00 841,938.82 7,410,045.77 11,638,800.00 32,602,500.00 14,912,058.31 Total Surplus (Deficit): 388,662.90$ 6,610,334.18$ -$ 139,673.86$ 1,239,821.06$ -$ -$ -$ Unaudited Revenue and Expense Budget-to-Actual by Category Month Ended February 28, 2017 WATER WASTEWATER DISTRICT WIDE Page 2 of 8 ADOPTED AMENDED ADOPTED REMAINING MTD YTD BUDGET MTD YTD BUDGET TOTAL BUDGET BUDGET Revenue 41 Water Sales 604,051.87$ 9,896,321.31$ 13,500,000.00$ -$ -$ -$ 13,500,000.00$ 3,603,678.69$ 42 Meter Charges 741,604.23 5,922,881.52 8,960,000.00 - - - 8,960,000.00 3,037,118.48 43 Penalties 43,322.72 393,762.06 635,000.00 3,633.53 28,937.00 50,000.00 685,000.00 262,300.94 44 Wastewater System Charges - - - 362,433.05 3,157,872.59 4,460,000.00 4,460,000.00 1,302,127.41 45 Wastewater Treatment Charges - - - 613,021.10 5,391,908.06 7,610,000.00 7,610,000.00 2,218,091.94 46 Other Operating Revenue 102,111.72 575,509.42 170,000.00 2,525.00 56,413.96 190,000.00 360,000.00 (271,923.38) 47 Non Operating Revenue 6,384.56 79,923.79 120,000.00 - 14,735.22 22,000.00 142,000.00 47,340.99 Revenue Total: 1,497,475.10 16,890,730.10 23,385,000.00 981,612.68 8,649,866.83 12,332,000.00 35,717,000.00 10,176,403.07 Progra 1000 - Board of Directors 7,101.65 63,577.52 148,400.00 3,018.64 25,629.85 63,600.00 212,000.00 122,792.63 Progra 2000 - General Administration 78,958.98 575,785.24 940,924.00 32,198.87 234,705.49 404,700.00 1,345,624.00 535,133.27 Progra 2100 - Human Resources 26,525.54 384,399.97 512,812.00 11,366.80 162,689.73 220,500.00 733,312.00 186,222.30 Progra 2200 - Public Affairs 19,488.63 203,430.27 506,570.00 15,575.67 195,404.13 508,900.00 1,015,470.00 616,635.60 Progra 2300 - Conservation 119,049.11 420,681.23 1,020,156.00 - - - 1,020,156.00 599,474.77 Progra 3000 - Finance 49,525.43 567,448.04 758,356.00 20,421.39 245,019.74 324,582.00 1,082,938.00 270,470.22 Progra 3200 - Information Technology 47,393.46 316,074.53 540,112.00 20,626.88 140,927.43 232,200.00 772,312.00 315,310.04 Progra 3300 - Customer Service 90,023.88 744,806.29 1,317,395.00 27,185.80 244,956.72 401,895.00 1,719,290.00 729,526.99 Progra 3400 - Meter Service 23,351.25 218,341.02 348,000.00 149.90 6,980.27 - 348,000.00 122,678.71 Progra 4000 - Engineering 38,903.93 526,799.56 842,656.00 20,693.56 217,922.98 371,281.00 1,213,937.00 469,214.46 Progra 5000 - Water Production 201,794.10 2,601,196.65 4,402,875.00 - - - 4,402,875.00 1,801,678.35 Progra 5100 - Water Treatment 56,804.01 471,850.78 827,000.00 - - - 827,000.00 355,149.22 Progra 5200 - Water Quality 35,406.91 242,435.86 407,000.00 - - - 407,000.00 164,564.14 Progra 6000 - Field Maintenance Administration 12,828.35 113,783.80 194,400.00 1,920.07 23,515.89 21,600.00 216,000.00 78,700.31 Progra 6100 - Water Maintenance 181,648.00 1,272,392.79 1,759,000.00 - (21.00) - 1,759,000.00 486,628.21 Progra 6200 - Wastewater Maintenance - - - 674,522.58 5,671,884.72 8,231,875.00 8,231,875.00 2,559,990.28 Progra 7000 - Facilities Maintenance 46,250.26 398,392.98 604,275.00 9,847.24 89,618.80 198,600.00 802,875.00 314,863.22 Progra 7100 - Fleet Maintenance 36,603.91 281,183.78 490,500.00 4,411.42 39,048.52 54,500.00 545,000.00 224,767.70 Progra 8000 - Capital 37,154.80 877,815.61 5,343,269.00 - 111,762.50 604,567.00 5,947,836.00 4,958,257.89 Total Surplus (Deficit):388,662.90$ 6,610,334.18$ -$ 139,673.86$ 1,239,821.06$ -$ -$ -$ Revenue and Expense Budget-to-Actual by Program Month Ended February 28, 2017 Unaudited WATER WASTEWATER DISTRICT WIDE Page 3 of 8 ADOPTED AMENDED ADOPTED REMAINING MTD YTD BUDGET MTD YTD BUDGET TOTAL BUDGET BUDGET Revenue 41 Water Sales 604,051.87$ 9,896,321.31$ 13,500,000.00$ -$ -$ -$ 13,500,000.00$ 3,603,678.69$ 42 Meter Charges 741,604.23 5,922,881.52 8,960,000.00 - - - 8,960,000.00 3,037,118.48 43 Penalties 43,322.72 393,762.06 635,000.00 3,633.53 28,937.00 50,000.00 685,000.00 262,300.94 44 Wastewater System Charges - - - 362,433.05 3,157,872.59 4,460,000.00 4,460,000.00 1,302,127.41 45 Wastewater Treatment Charges - - - 613,021.10 5,391,908.06 7,610,000.00 7,610,000.00 2,218,091.94 46 Other Operating Revenue 102,111.72 575,509.42 170,000.00 2,525.00 56,413.96 190,000.00 360,000.00 (271,923.38) 47 Non Operating Revenue 6,384.56 79,923.79 120,000.00 - 14,735.22 22,000.00 142,000.00 47,340.99 48 Gain or Loss on Disposition - 22,332.00 - - - - - (22,332.00) 56 Benefits 49.37 242.42 - 21.16 51.47 - - (293.89) 68 Depreciation - - - - - - - Revenue Total: 1,497,475.10 16,890,730.10 23,385,000.00 981,612.68 8,649,866.83 12,332,000.00 35,717,000.00 10,176,403.07 Program: 1000 - Board of Directors - - - 51 Labor 4,532.50$ 43,832.37$ 73,500.00$ 1,942.50$ 18,785.35$ 31,500.00$ 105,000.00$ 42,382.28$ 56 Benefits 2,309.61 8,886.80 28,700.00 1,002.61 3,541.39 12,300.00 41,000.00 28,571.81 63 Contract Services - 1,057.00 7,700.00 - 453.00 3,300.00 11,000.00 9,490.00 65 Professional Development 259.54 9,801.35 38,500.00 73.53 2,850.11 16,500.00 55,000.00 42,348.54 Program: 1000 - Board of Directors Total: 7,101.65 63,577.52 148,400.00 3,018.64 25,629.85 63,600.00 212,000.00 122,792.63 Program: 2000 - General Administration - - - 51 Labor 22,341.98 232,472.91 455,700.00 9,575.17 99,423.49 195,300.00 651,000.00 319,103.60 53 Overtime 99.65 986.97 - 42.70 422.95 - - (1,409.92) 56 Benefits 13,403.95 117,221.30 186,200.00 4,103.83 37,183.01 79,800.00 266,000.00 111,595.69 62 Materials and Supplies 306.38 1,735.43 7,000.00 131.31 803.76 3,000.00 10,000.00 7,460.81 63 Contract Services 28,994.36 152,962.21 206,624.00 12,426.16 66,698.09 90,000.00 296,624.00 76,963.70 64 Utilities 86.82 1,191.90 3,500.00 37.21 510.84 1,500.00 5,000.00 3,297.26 65 Professional Development 13,725.84 69,214.52 81,900.00 5,882.49 29,663.35 35,100.00 117,000.00 18,122.13 Program: 2000 - General Administration Total: 78,958.98 575,785.24 940,924.00 32,198.87 234,705.49 404,700.00 1,345,624.00 535,133.27 Program: 2100 - Human Resources - - - - 51 Labor 10,570.56 94,725.38 140,700.00 4,530.24 40,596.57 60,300.00 201,000.00 65,678.05 52 Temporary Labor 470.40 5,443.65 8,400.00 201.60 2,332.99 3,600.00 12,000.00 4,223.36 53 Overtime - 935.93 2,100.00 - 401.12 900.00 3,000.00 1,662.95 56 Benefits 4,870.54 47,094.80 58,800.00 2,086.10 18,879.11 25,200.00 84,000.00 18,026.09 62 Materials and Supplies - 262.58 4,900.00 - 112.54 2,100.00 7,000.00 6,624.88 63 Contract Services 3,478.81 33,118.75 65,512.00 1,490.92 14,193.83 28,800.00 94,312.00 46,999.42 64 Utilities 26.61 197.53 700.00 11.40 84.62 300.00 1,000.00 717.85 65 Professional Development 665.72 17,099.73 23,800.00 285.31 6,579.69 10,200.00 34,000.00 10,320.58 67 Other 6,442.90 185,521.62 207,900.00 2,761.23 79,509.26 89,100.00 297,000.00 31,969.12 Program: 2100 - Human Resources Total: 26,525.54 384,399.97 512,812.00 11,366.80 162,689.73 220,500.00 733,312.00 186,222.30 Program: 2200 - Public Affairs - - - - 51 Labor 10,685.70 101,404.98 148,000.00 9,228.08 81,680.47 148,000.00 296,000.00 112,914.55 52 Temporary Labor - 478.80 - - 205.20 - - (684.00) 53 Overtime 240.11 2,252.73 3,500.00 240.10 1,896.41 3,500.00 7,000.00 2,850.86 Month Ended February 28, 2017 Unaudited Program Expense Detail Budget-to-Actual WATER WASTEWATER DISTRICT WIDE Page 4 of 8 ADOPTED AMENDED ADOPTED REMAINING MTD YTD BUDGET MTD YTD BUDGET TOTAL BUDGET BUDGET Month Ended February 28, 2017 Unaudited Program Expense Detail Budget-to-Actual WATER WASTEWATER DISTRICT WIDE 56 Benefits 3,673.41 36,867.62 53,000.00 2,633.04 23,313.55 53,000.00 106,000.00 45,818.83 62 Materials and Supplies 1,574.44 18,213.85 82,500.00 1,574.45 41,549.44 82,500.00 165,000.00 105,236.71 63 Contract Services 2,598.63 32,236.46 198,070.00 1,183.64 34,709.88 200,400.00 398,470.00 331,523.66 64 Utilities 73.90 8,970.61 11,500.00 73.91 9,038.37 11,500.00 23,000.00 4,991.02 65 Professional Development 642.44 3,005.22 10,000.00 642.45 3,010.81 10,000.00 20,000.00 13,983.97 Program: 2200 - Public Affairs Total: 19,488.63 203,430.27 506,570.00 15,575.67 195,404.13 508,900.00 1,015,470.00 616,635.60 Program: 2300 - Conservation - - - - 51 Labor 12,266.08 124,219.25 102,000.00 - - - 102,000.00 (22,219.25) 52 Temporary Labor - 4,284.00 - - - - - (4,284.00) 53 Overtime - 1,692.39 8,000.00 - - - 8,000.00 6,307.61 56 Benefits 2,630.23 24,886.45 31,000.00 - - - 31,000.00 6,113.55 62 Materials and Supplies 102,132.98 237,918.30 524,000.00 - - - 524,000.00 286,081.70 63 Contract Services 1,947.40 24,512.86 302,156.00 - - - 302,156.00 277,643.14 64 Utilities 72.42 628.13 41,000.00 - - - 41,000.00 40,371.87 65 Professional Development - 2,539.85 12,000.00 - - - 12,000.00 9,460.15 Program: 2300 - Conservation Total: 119,049.11 420,681.23 1,020,156.00 - - - 1,020,156.00 599,474.77 Program: 3000 - Finance - - - - 51 Labor 30,250.25 281,283.32 448,000.00 12,923.96 120,336.55 192,000.00 640,000.00 238,380.13 52 Temporary Labor - 13,939.00 9,800.00 - 5,973.85 4,200.00 14,000.00 (5,912.85) 53 Overtime 709.57 4,423.33 2,100.00 304.08 1,557.42 900.00 3,000.00 (2,980.75) 56 Benefits 14,524.09 128,282.85 178,500.00 5,461.29 53,755.41 76,500.00 255,000.00 72,961.74 62 Materials and Supplies 183.61 3,082.26 4,200.00 78.68 1,320.94 1,800.00 6,000.00 1,596.80 63 Contract Services 3,585.08 129,958.20 95,156.00 1,536.45 59,614.17 40,782.00 135,938.00 (53,634.37) 64 Utilities 115.80 1,106.53 2,800.00 49.63 474.22 1,200.00 4,000.00 2,419.25 65 Professional Development 157.03 4,636.70 16,800.00 67.30 1,987.18 7,200.00 24,000.00 17,376.12 67 Other - 735.85 1,000.00 - - - 1,000.00 264.15 Program: 3000 - Finance Total: 49,525.43 567,448.04 758,356.00 20,421.39 245,019.74 324,582.00 1,082,938.00 270,470.22 Program: 3200 - Information Technology - - - - 51 Labor 12,304.07 130,438.94 203,000.00 5,588.63 60,622.69 87,000.00 290,000.00 98,938.37 52 Temporary Labor - - - - - - - - 53 Overtime - - - - - - - - 56 Benefits 4,722.82 39,786.67 72,800.00 2,024.00 20,384.13 31,200.00 104,000.00 43,829.20 62 Materials and Supplies 876.35 25,041.46 19,312.00 375.58 8,191.03 9,000.00 28,312.00 (4,920.49) 63 Contract Services 25,424.08 109,298.15 225,400.00 10,896.04 46,797.01 96,600.00 322,000.00 165,904.84 64 Utilities 318.49 1,874.13 3,500.00 136.49 803.20 1,500.00 5,000.00 2,322.67 65 Professional Development 3,747.65 9,635.18 16,100.00 1,606.14 4,129.37 6,900.00 23,000.00 9,235.45 Program: 3200 - Information Technology Total: 47,393.46 316,074.53 540,112.00 20,626.88 140,927.43 232,200.00 772,312.00 315,310.04 Program: 3300 - Customer Service - - - - 51 Labor 21,565.70 193,573.25 338,100.00 9,594.72 87,987.05 144,900.00 483,000.00 201,439.70 52 Temporary Labor 2,143.11 9,436.70 2,100.00 918.49 4,044.32 900.00 3,000.00 (10,481.02) 53 Overtime 78.94 1,434.48 3,500.00 33.82 614.78 1,500.00 5,000.00 2,950.74 56 Benefits 12,293.22 99,555.57 163,800.00 5,281.16 50,875.39 70,200.00 234,000.00 83,569.04 Page 5 of 8 ADOPTED AMENDED ADOPTED REMAINING MTD YTD BUDGET MTD YTD BUDGET TOTAL BUDGET BUDGET Month Ended February 28, 2017 Unaudited Program Expense Detail Budget-to-Actual WATER WASTEWATER DISTRICT WIDE 62 Materials and Supplies 130.05 1,851.75 9,200.00 55.75 793.63 1,800.00 11,000.00 8,354.62 63 Contract Services 45,720.80 397,656.53 680,695.00 8,014.43 83,637.90 131,595.00 812,290.00 330,995.57 64 Utilities 7,670.68 39,463.56 107,100.00 3,287.43 16,912.96 45,900.00 153,000.00 96,623.48 65 Professional Development 16.70 1,513.71 12,900.00 - 100.69 5,100.00 18,000.00 16,385.60 67 Other 404.68 320.74 - - (10.00) - - (310.74) Program: 3300 - Customer Service Total: 90,023.88 744,806.29 1,317,395.00 27,185.80 244,956.72 401,895.00 1,719,290.00 729,526.99 Program: 3400 - Meter Service - - - - 51 Labor 15,335.86 146,221.71 210,000.00 - - - 210,000.00 63,778.29 53 Overtime 79.33 4,673.76 20,000.00 - - - 20,000.00 15,326.24 56 Benefits 7,481.96 59,323.90 104,000.00 149.90 6,980.27 - 104,000.00 37,695.83 62 Materials and Supplies 246.24 430.09 4,000.00 - - - 4,000.00 3,569.91 63 Contract Services 131.49 7,158.05 8,000.00 - - - 8,000.00 841.95 64 Utilities 76.37 533.51 2,000.00 - - - 2,000.00 1,466.49 65 Professional Development - - - - - - - - Program: 3400 - Meter Service Total: 23,351.25 218,341.02 348,000.00 149.90 6,980.27 - 348,000.00 122,678.71 Program: 4000 - Engineering - - - - 51 Labor 15,155.12 245,976.21 377,200.00 12,452.10 129,019.86 171,800.00 549,000.00 174,003.93 52 Temporary Labor 53.90 569.80 - 23.10 244.20 - - (814.00) 53 Overtime 54.51 1,470.36 1,400.00 23.36 630.14 600.00 2,000.00 (100.50) 56 Benefits 14,909.00 124,219.97 190,400.00 6,623.15 53,917.26 81,600.00 272,000.00 93,862.77 62 Materials and Supplies 14.99 2,802.15 16,100.00 - 133.74 6,900.00 23,000.00 20,064.11 63 Contract Services 3,167.50 85,381.54 152,556.00 1,357.50 21,033.00 65,381.00 217,937.00 111,522.46 64 Utilities 5,487.71 62,883.34 86,100.00 214.35 12,714.72 36,900.00 123,000.00 47,401.94 65 Professional Development 61.20 3,496.19 18,900.00 - 230.06 8,100.00 27,000.00 23,273.75 Program: 4000 - Engineering Surplus Total: 38,903.93 526,799.56 842,656.00 20,693.56 217,922.98 371,281.00 1,213,937.00 469,214.46 Program: 5000 - Water Production - - - - 51 Labor 47,257.96 425,035.84 626,000.00 - - - 626,000.00 200,964.16 53 Overtime 2,605.68 34,130.12 36,000.00 - - - 36,000.00 1,869.88 54 Standby 1,120.00 10,009.52 15,000.00 - - - 15,000.00 4,990.48 56 Benefits 18,480.85 178,800.15 239,000.00 - - - 239,000.00 60,199.85 61 Water Supply - 864,310.37 1,245,000.00 - - - 1,245,000.00 380,689.63 62 Materials and Supplies 17,307.99 98,099.43 279,000.00 - - - 279,000.00 180,900.57 63 Contract Services 30,507.98 92,821.61 341,000.00 - - - 341,000.00 248,178.39 64 Utilities 83,876.09 890,118.62 1,612,875.00 - - - 1,612,875.00 722,756.38 65 Professional Development 637.55 7,870.99 9,000.00 - - - 9,000.00 1,129.01 Program: 5000 - Water Production Total: 201,794.10 2,601,196.65 4,402,875.00 - - - 4,402,875.00 1,801,678.35 Program: 5100 - Water Treatment - - - - 51 Labor 16,408.46 147,163.14 217,000.00 - - - 217,000.00 69,836.86 53 Overtime 1,804.50 9,871.72 10,000.00 - - - 10,000.00 128.28 56 Benefits 6,468.15 61,370.11 69,000.00 - - - 69,000.00 7,629.89 62 Materials and Supplies 19,569.90 128,906.73 165,000.00 - - - 165,000.00 36,093.27 63 Contract Services 8,014.68 61,800.78 166,000.00 - - - 166,000.00 104,199.22 64 Utilities 4,538.32 62,738.30 200,000.00 - - - 200,000.00 137,261.70 Page 6 of 8 ADOPTED AMENDED ADOPTED REMAINING MTD YTD BUDGET MTD YTD BUDGET TOTAL BUDGET BUDGET Month Ended February 28, 2017 Unaudited Program Expense Detail Budget-to-Actual WATER WASTEWATER DISTRICT WIDE Program: 5100 - Water Treatment Total: 56,804.01 471,850.78 827,000.00 - - - 827,000.00 355,149.22 Program: 5200 - Water Quality - - - - 51 Labor 12,254.62 109,547.33 162,000.00 - - - 162,000.00 52,452.67 53 Overtime 759.81 4,767.06 4,000.00 - - - 4,000.00 (767.06) 56 Benefits 4,311.92 42,124.51 60,000.00 - - - 60,000.00 17,875.49 62 Materials and Supplies 2,020.22 5,613.52 18,000.00 - - - 18,000.00 12,386.48 63 Contract Services 14,933.27 78,960.64 161,000.00 - - - 161,000.00 82,039.36 64 Utilities 1,127.07 1,422.80 2,000.00 - - - 2,000.00 577.20 65 Professional Development - - - - - - - - Program: 5200 - Water Quality Total: 35,406.91 242,435.86 407,000.00 - - - 407,000.00 164,564.14 Program: 6000 - Field Maintenance Administration - - - - 51 Labor 6,925.06 61,093.49 94,500.00 956.22 11,889.60 10,500.00 105,000.00 32,016.91 52 Temporary Labor - - - - - - - - 53 Overtime - - - - - - - - 54 Standby 1,168.00 14,155.23 18,000.00 112.00 1,961.91 2,000.00 20,000.00 3,882.86 56 Benefits 2,605.54 20,690.14 37,800.00 701.19 7,943.90 4,200.00 42,000.00 13,365.96 62 Materials and Supplies - 828.57 2,700.00 - 9.81 300.00 3,000.00 2,161.62 63 Contract Services - - - - - - - - 64 Utilities 1,038.26 8,038.41 18,900.00 115.36 893.15 2,100.00 21,000.00 12,068.44 65 Professional Development 1,091.49 8,977.96 22,500.00 35.30 817.52 2,500.00 25,000.00 15,204.52 Program: 6000 - Field Maintenance Administration Total 12,828.35 113,783.80 194,400.00 1,920.07 23,515.89 21,600.00 216,000.00 78,700.31 Program: 6100 - Water Maintenance - - - - 51 Labor 73,561.47 509,640.21 727,000.00 - (156.00) - 727,000.00 217,515.79 53 Overtime 11,781.00 130,232.45 150,000.00 - - - 150,000.00 19,767.55 56 Benefits 33,819.81 270,361.53 316,000.00 - - - 316,000.00 45,638.47 62 Materials and Supplies 45,992.30 211,033.63 232,000.00 - - - 232,000.00 20,966.37 63 Contract Services 13,968.02 148,599.57 334,000.00 - - - 334,000.00 185,400.43 64 Utilities 2,525.40 2,525.40 - - 135.00 - - (2,660.40) Program: 6100 - Water Maintenance Total: 181,648.00 1,272,392.79 1,759,000.00 - (21.00) - 1,759,000.00 486,628.21 Program: 6200 - Wastewater Maintenance - - - - 51 Labor - - - - 170,743.48 242,000.00 242,000.00 71,256.52 53 Overtime - - - - 1,592.72 3,000.00 3,000.00 1,407.28 56 Benefits - - - 1,171.35 19,183.64 115,000.00 115,000.00 95,816.36 62 Materials and Supplies - - - 6,130.63 23,109.81 32,000.00 32,000.00 8,890.19 Wastewater Treatment - - - 613,021.10 5,391,908.06 6,861,600.00 6,861,600.00 1,469,691.94 63 Contract Services - - - 54,199.50 65,347.01 978,275.00 978,275.00 912,927.99 Program: 6200 - Wastewater Maintenance Total:- - - 674,522.58 5,671,884.72 8,231,875.00 8,231,875.00 2,559,990.28 Page 7 of 8 ADOPTED AMENDED ADOPTED REMAINING MTD YTD BUDGET MTD YTD BUDGET TOTAL BUDGET BUDGET Month Ended February 28, 2017 Unaudited Program Expense Detail Budget-to-Actual WATER WASTEWATER DISTRICT WIDE Program: 7000 - Facilities Maintenance - - - - 51 Labor 6,058.42 54,402.53 62,300.00 673.06 7,797.77 26,700.00 89,000.00 26,799.70 53 Overtime - 13,097.43 17,500.00 - 2,375.28 7,500.00 25,000.00 9,527.29 56 Benefits 3,539.82 27,799.25 25,900.00 866.62 8,307.10 11,100.00 37,000.00 893.65 62 Materials and Supplies 1,959.99 19,551.07 33,900.00 840.00 6,564.05 8,100.00 42,000.00 15,884.88 63 Contract Services 26,426.08 207,168.22 305,475.00 3,976.08 32,400.07 83,400.00 388,875.00 149,306.71 64 Utilities 8,265.95 76,374.48 159,200.00 3,491.48 32,174.53 61,800.00 221,000.00 112,450.99 65 Professional Development - - - - - - - - Program: 7000 - Facilities Maintenance Total: 46,250.26 398,392.98 604,275.00 9,847.24 89,618.80 198,600.00 802,875.00 314,863.22 Program: 7100 - Fleet Maintenance - - - - 51 Labor 10,456.40 94,648.83 135,900.00 1,161.82 12,939.85 15,100.00 151,000.00 43,411.32 53 Overtime - 541.69 2,700.00 - 141.38 300.00 3,000.00 2,316.93 56 Benefits 4,117.67 33,095.76 59,400.00 445.77 5,908.04 6,600.00 66,000.00 26,996.20 62 Materials and Supplies 3,609.25 47,804.19 62,100.00 469.89 7,209.04 6,900.00 69,000.00 13,986.77 63 Contract Services 11,265.93 49,736.44 112,500.00 1,538.98 6,699.47 12,500.00 125,000.00 68,564.09 64 Utilities 7,154.66 53,801.67 113,400.00 794.96 5,977.94 12,600.00 126,000.00 66,220.39 65 Professional Development - 1,555.20 4,500.00 - 172.80 500.00 5,000.00 3,272.00 Program: 7100 - Fleet Maintenance Total: 36,603.91 281,183.78 490,500.00 4,411.42 39,048.52 54,500.00 545,000.00 224,767.70 Program: 8000 - Capital - - - 71 -Debt Service 37,154.80 877,815.61 4,007,000.00 - 111,762.50 317,000.00 4,324,000.00 3,334,421.89 81 -Capital Improvement - - 1,070,000.00 - - 210,000.00 1,280,000.00 1,280,000.00 82 -Capital Outlay - - 266,269.00 - - 77,567.00 343,836.00 343,836.00 83 -Accounting Income Add back - - - - - - - - Program: 8000 - Capital Total: 37,154.80 877,815.61 5,343,269.00 - 111,762.50 604,567.00 5,947,836.00 4,958,257.89 Total Surplus (Deficit): 388,662.90$ 6,610,334.18$ -$ 139,673.86$ 1,239,821.06$ -$ -$ -$ Page 8 of 8 BOARD AGENDA STAFF REPORT Agenda Item #7. Meeting Date: Marc h 22, 2017 Discuss ion Item To: Go verning Bo ard Members From: General Manager/CEO Subject: Disp os itio n of S urplus Pro perty RECOMMENDATION: S taff is rec ommending that the Board of Direc to rs authorize the disp os itio n of s urplus p rop erty. BACKGROUND / ANALYSIS: During mid -year b udget review, Dis trict s taff co nducted an evaluation o f the vehicles in servic e and found that unit number 145 has exceeded its us eful life. It is a 2002 Chevrolet Suburb an with 135,000 miles that is us ed as a p oo l vehicle, and has b een identified for surp lus due to the age and mileage. This vehic le has also b een identified for ineffic ient fuel co ns umptio n. Staff recommends that we replac e the Sub urban with a s maller mo re fuel-efficient vehic le that better fits the Dis tric t’s needs. S taff reco mmend s that the 2002 Chevro let Suburb an be c las sified as s urplus and d onated to a nonprofit c haritable organizatio n in our co mmunity. DISCUSS ION: The following vehic le has been identified for s urp lus : No .Vehic le Details Miles R eas on fo r Surplus 145 2002 Chevro let Sub urban VIN: 3GNK16T82G307935 135,000 Vehicle is no t fuel efficient and no longer fits the needs of the Dis trict. Reco mmend ed by: Jo hn Mura General Manager/C EO Res pec tfully sub mitted : Patrick K. Milroy Op erations Manager AGENCY IDEALS AND ENDEAVORS: Ideals and Endeavor IV - Fully Und erstand C hallenges To Cultivate Effective Solutions (E) - Cond uc t p os t implementation evaluations and make improvements as neces s ary REVIEW BY OTHERS: This agenda item has b een reviewed by Operations, Engineering, Ad minis tration, and P ublic Affairs staff. FISCAL IMPACT : F unds have b een budgeted for replacement o f this vehic le in F is c al Year 2016-17. BOARD AGENDA STAFF REPORT Agend a Item #8. Meeting Date: Marc h 22, 2017 Co nsent Item To: Governing Bo ard Memb ers From: General Manager/CEO Subject: Bus ines s Intelligenc e C o ntrac t Award RECOMMENDATION: Based o n the Req ues t fo r P ro posal (RFP ) s electio n proc ess d es c rib ed belo w, s taff rec ommends that the Board o f Direc to rs award the contract for the Data Wareho using and Busines s Intelligenc e Design and Implementatio n to Orion Sys tems Integrato rs fo r a no t-to -exceed p ric e of $144,000. BACKGROUND / ANALYSIS: One of the District’s goals fo r the c urrent fisc al year is to harnes s the millions of d ata rec o rd s generated by staff while p erforming their daily duties , and organizing tho s e records to build meaningful reports fo r us e by the Bo ard and management – thes e res ulting repo rts are kno wn as Busines s Intelligenc e. T he Information Tec hnology Manager has laid the ground work fo r p roducing Busines s Intelligence reports b y 1) c o nduc ting interviews with management to determine their reporting need s , 2) c reating an invento ry of d ata and d etermining where it res id es o n the Distric t’s netwo rk, and 3) building report temp lates . After comp leting thes e tas ks, the next s tep is to hire a cons ultant to b uild a centralized Data Warehous e and to Des ign and Imp lement an automated Bus iness Intelligence rep o rting pro cess . T he RFP s from q ualified firms were c irculated on Feb ruary 2nd. Five firms sub mitted propos als , whic h were then evaluated by a five-p ers o n c o mmittee b ased o n the fo llowing criteria: R espons ivenes s to the RFP Approac h to the projec t Ability to meet pro ject timelines Qualific atio ns o f cons ultant d evelo p ment team, and C ost Once the p ro p o sals were evaluated and sc o red, the to p three firms were invited to the Dis tric t on March 1st fo r an opportunity to pres ent their propos als and ans wer q ues tions for the five-p ers on c o mmittee. Upon completion o f thes e interviews, the c o mmittee unanimo us ly voted to rec o mmend award o f the Data Warehous ing and Bus ines s Intelligence Des ign and Imp lementation c ontrac t to Orion Sys tems Integrato rs. Recommended by: Jo hn Mura General Manager/CEO Res p ec tfully s ub mitted : Brian To mpkins Chief Financial Offic er A s ummary o f the propo s als received fo r the Bus ines s Intelligenc e c o ntrac t fo llows : Firm Name HQ Location Cost Proposal Affirma Bellevue, WA $ 296,320 JBS , Inc.Chadds Fo rd , PA $ 460,962 Orio n Systems Integrators Monmo uth Junc tion, NJ $ 144,000 Plus C ons ulting Scotts dale, AZ $ 142,740 Wic res oft No rth Americ a Bellevue, WA $ 75,375 AGENCY IDEALS AND ENDEAVORS: Ideals and Endeavor I - Enc o urage Innovative Investments To Pro mo te Sustainab le Benefits (D) - Ded icate effo rt toward s ys tem maintenance and modernization Ideals and Endeavor IV - Fully Unders tand Challenges To Cultivate Effective So lutio ns (A) - Support ongo ing b usiness p ro c es s imp ro vement (B) - Encourage performanc e b as ed res ults thro ugh staff emp o werment (D) - Emb race an enviro nment of ac tive learning and knowledge s haring REVIEW BY OTHERS: T his agend a item has b een reviewed b y the Ad minis tratio n, Finance, and Information and Tec hnology Dep artments . FISCAL IMPACT : T he fis c al imp ac t o f this project is $144,000.