Loading...
HomeMy WebLinkAboutAgenda Packet - EVWD Board of Directors - 10/28/2015REGULAR BOARD MEETING Oc tober 28, 2015 - 5:30 PM 31111 Greens pot R o ad , Highland , CA 92346 AGENDA "In order to c o mp ly with legal requirements for p o s ting o f agend a, o nly thos e items filed with the Distric t Clerk b y 12:00 p.m. o n Wednes d ay p rio r to the fo llo wing Wednes d ay meeting no t req uiring departmental investigation, will b e c o nsidered b y the Bo ard of Direc tors". CALL TO ORDER P LEDGE O F ALLEGIANCE ROLL CALL OF BOARD MEMBERS PUBLIC COMMENTS Any p ers o n wis hing to s peak to the Bo ard o f Directo rs is as ked to c o mp lete a S p eaker Card and s ubmit it to the Dis tric t Clerk p rio r to the start of the meeting. Each s p eaker is limited to three (3) minutes , unles s waived b y the Chairman o f the Bo ard . Und er the State o f California Brown Act, the Board o f Directors is prohib ited from dis c us s ing o r taking ac tio n o n any item no t lis ted on the p o s ted agenda. The matter will automatically be referred to staff for an appropriate respons e or ac tion and may ap p ear o n the agenda at a future meeting. AGENDA - T his agenda c o ntains a b rief general d es crip tion o f each item to be c o nsidered. Except as otherwis e p ro vided by law, no actio n shall b e taken on any item no t appearing on the fo llo wing agend a unless the Board o f Directors makes a determinatio n that an emergency exis ts o r that a need to take immediate ac tio n o n the item c ame to the attention of the Dis tric t s ubsequent to the posting of the agend a. 1.Ap proval of Agenda 2.APPROVAL OF CONSENT CALENDAR All matters listed under the Consent Calendar are considered by the Bo ard of Directors to be ro utine and will be enacted in one mo tion. There will be no discussion o f these items prio r to the time the board co nsiders the motion unless me mbers of the board, the administrative staff, or the public request specific ite ms to be discusse d and/or removed from the Consent Calendar. a.Financ ial S tatements for September 2015 b.Inves tment Report for Quarter End ed S ep tember 30 2015 c .Septemb er 2015 Dis b ursements : Acc ounts p ayable d is b ursements fo r the p erio d inc lud e c hec k numbers 245526 through 245820, bank drafts , and ACH P ayments in the amount o f $4,377,129.59 and $317,799.32 for p ayroll. NEW BUSINESS 3.Cyber S ec urity Awarenes s Up d ate 4.Up date on Dis tric t effo rts to imp lement AWWA Benchmarking Perfo rmanc e Ind icato rs REPORTS 5.Board of Direc tors' Reports 6.General Manager/CEO Report • Drought Update 7.Legal C o uns el Rep o rt 8.Board of Direc tors' Comments CLOSED SESSION 9.CONFERENCE WIT H LEGAL COUNS EL-Exis ting Litigatio n [Go vernment Co de Section 54956.9(d )(1)] Name of Cas e: Eas t Valley Water Dis tric t v. San Bernardino Internatio nal Airpo rt Autho rity, et al., United S tates Dis tric t Court Central Dis trict of California C as e No. EDCV14- 00138-GAF(S Px) 10.CONFERENCE WITH LEGAL C OUNSEL - ANTICIPAT ED LITIGATION Initiation of litigation purs uant to Government Code Sec tio n 54956.9(d)(4) - One Potential Cas e ANNOUNCEMENT OF CLOSED SESSION ACTIONS 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 availab le for pub lic inspec tion in the Dis trict's offic e lo cated at 31111 Greens pot Rd ., Highland , d uring no rmal bus ines s ho urs. Als o , s uc h d o cuments are availab le on the Distric t's webs ite at www.eastvalley.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. BOARD AGENDA STAFF REPORT Agend a Item #2.a. Meeting Date: Octo b er 28, 2015 Cons ent Item T o: G o verning Board Memb ers From: G eneral Manager/CEO Subject: Financ ial S tatements for September 2015 RECOMMENDATION: Staff rec o mmend s that the Bo ard of Direc tors ac c ept and file the attac hed financ ial s tatements as of, and fo r the period end ed , Septemb er 30, 2015. BACKGROUND / ANALYSIS: Inc luded herewith fo r the Bo ard 's review is a s ummary o f Eas t Valley Water Dis trict's financ ial results, as of Septemb er 30, 2015. AGENCY IDEALS AND ENDEAVORS: Id eals and End eavor II - Maintain An Environment C o mmitted To Elevated P ublic S ervic e (E) - Practice Trans p arent & Acc o untable Fis c al Management FISCAL IMPACT: There is no fis c al imp act assoc iated with this agend a item. Res p ectfully s ubmitted: Rec o mmended b y: Jo hn Mura General Manager / C EO Brian To mp kins Chief F inancial Offic er ATTACHMENTS: Description Type September 201 5 Financial Statement Monthly Review Backup Material September 201 5 Financial Statements Backup Material FINANCIAL STATEMENTS MONTHLY REVIEW – SEPTEMBER 30, 2015 The following is a highlight summary of the District’s financial results as of September 30, 2015. Statement of Net Position Total assets at September 30, 2015 are $180.9 million excluding the $6.6 million Inter- fund Loan between the Water and Wastewater funds. Below is a summary of the District’s net position as of September 30, 2015. CLASSIFICATION WATER WASTEWATER TOTAL Cash and Cash Equivalents $ 10,163,767 $ 1,094,330 $ 11,258,096 Utility Plant, Net 107,075,173 19,360,872 126,436,044 Other Assets 34,857,103 14,949,337 49,806,440 Current Liabilities 4,935,478 388,008 5,323,486 Long Term Liabilities 53,811,363 5,102,677 58,914,041 Beginning Net Position 89,835,159 29,605,020 119,440,179 Change in Equity 3,514,043 309,180 3,823,222 Total Net Position $ 93,349,201 $ 29,914,200 $ 123,263,401 FINANCIAL STATEMENTS MONTHLY REVIEW – SEPTEMBER 30, 2015 Cash and Investments are $23.7 million, down $0.1 million from the prior month. Comparing current assets to current liabilities, the District has a current ratio at September 30, 2015 of 4.22 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 eleven months ending September 30, 2015. 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 Operating Revenues $ 6,300,896 $ 2,955,575 $ 9,256,471 Operating Expenses 2,786,853 2,646,395 5,433,248 0 5 10 15 20 25 30 Oct 31 Nov 30 Dec 31 Jan 31 Feb 28 Mar 31 Apr 30 May 31 Jun 30 Jul 31 Aug 31 Sep 30 Mi l l i o n $ CASH & INVESTMENTS Unrestricted Restricted FINANCIAL STATEMENTS MONTHLY REVIEW – SEPTEMBER 30, 2015 Water Sales for September were $1,270,413, $90,413 (8%) over projection. This variance is attributed to the customers’ consumption during the warmer part of the year. Water sales year to date are under budget ($16,602). Below are operational cost associated with the delivery of water to our customers, as of September 30, 2015 cost of delivering water is at 15% or $1,132,183. DELIVERING WATER BY COST CENTER COST CENTER TOTAL BUDGET YTD ACTIVITY REMAINING AMOUNT Source of Supply/Wells $ 3,528,000 $ 413,244 $ 3,114,756 Pumps & Boosters 1,025,000 143,293 881,707 Treatment 793,000 140,785 652,215 Transmission & Distribution 2,044,000 434,861 1,609,139 Total $ 7,390,000 $ 1,132,183 $ 6,257,817 Wastewater System Charge revenue are on target with the budget. Wastewater Treatment Revenue collected and passed-through to the City of San Bernardino as of September 30, 2015 is $ 1,817,814 or 26% of the total budget. Most programs are on pace with their overall budget with the exception of Human Resources and Public Affairs which have large onetime expenses that normally occur during the first half of the fiscal year. For Human Resources the District’s general liability insurance is prepaid for the fiscal year. Additionally, Public Affairs had a large expense for postage related to the drought mailers. Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun $0 $200,000 $400,000 $600,000 $800,000 $1,000,000 $1,200,000 $1,400,000 $1,600,000 WATER REVENUE Actual Projection Water WasteWater District Total Assets: Current Assets: 01 Cash and Cash Equivalents 10,163,766.70$ 1,094,329.66$ 11,258,096.36$ 02 Investments 2,703,155.81 2,225,805.81 4,928,961.62 03 Accounts Receivable, Net 3,469,710.69 387,057.65 3,856,768.34 04 ‐Interest Receivable - - - 05 Other Receivables 172,553.41 - 172,553.41 06 Due from other Governments 1,831,044.19 - 1,831,044.19 08 Inventory 334,328.39 6,721.16 341,049.55 09 Prepaid Expenses 63,368.70 7,400.35 70,769.05 18,737,927.89 3,721,314.63 22,459,242.52 Non-Current Assets: 10 Restricted Cash and Cash Equivalents 7,302,186.42 167,585.57 7,469,771.99 17 Loan to Water Fund - 6,600,000.00 6,600,000.00 11 Capital Assets not being Depreciated 18,806,402.13 5,554,766.82 24,361,168.95 13 Capital Assets, Net 107,075,172.50 19,360,871.77 126,436,044.27 133,183,761.05 31,683,224.16 164,866,985.21 Total Assets:151,921,688.94 35,404,538.79 187,326,227.73 Deferred Outflow Of Resources unding Deferred Charge on Refunding 174,353.17 - 174,353.17 152,096,042.11 35,404,538.79 187,500,580.90 Current Liabilities: 22 Accounts Payable and Accrued Expenses 604,515.05$ 29,893.35$ 634,408.40$ 23 Accrued Payroll and Benefits 28,851.62 - 28,851.62 15 Customer Service Deposits 1,776,469.89 - 1,776,469.89 16 Construction Advances and Retentions 106,000.00 108,000.00 214,000.00 17 Accrued Interest Payable 448,005.83 57,006.25 505,012.08 18 Current Portion of Compensated Absences 223,102.32 85,150.50 308,252.82 19 Current Portion of Long-Term Debt 1,748,533.01 107,958.00 1,856,491.01 4,935,477.72 388,008.10 5,323,485.82 Non-Current Liabilities: 24 Loan from Wastewater Fund 6,600,000.00 - 6,600,000.00 20 Compensated Absences, less current portion 280,292.64 120,501.91 400,794.55 21 Long Term Debt, Less Current Portion 46,930,920.83 4,961,613.31 51,892,534.14 27 Other Liabilities 149.79 20,562.12 20,711.91 53,811,363.26 5,102,677.34 58,914,040.60 58,746,840.98 5,490,685.44 64,237,526.42 31 Equity 89,835,158.60 29,605,020.16 119,440,178.76 89,835,158.60 29,605,020.16 119,440,178.76 Tot Total Revenue 6,300,895.75 2,955,575.02 9,256,470.77 Tot Total Expense 2,786,853.22 2,646,395.14 5,433,248.36 3,514,042.53 309,179.88 3,823,222.41 93,349,201.13 29,914,200.04 123,263,401.17 152,096,042.11$ 35,404,885.48$ 187,500,927.59$ Unaudited As of September 30, 2015 Combining Schedule of Net Position Total Equity and Current Surplus (Deficit): Total Assets and Deferred Outflow 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 Liability: Total Current Liabilities: Total Non-Current Liabilities: Total Liabilities: MTD YTD BUDGET MTD YTD BUDGET TOTAL BUDGET REMAINING BUDGET Revenue 41 Water Sales 1,270,413.74$ 3,898,397.18$ 11,950,000.00$ -$ -$ -$ 11,950,000.00$ 8,051,602.82$ 42 Meter Charges 679,200.27 2,037,179.40 8,175,000.00 - - - 8,175,000.00 6,137,820.60 43 Penalties 51,836.96 162,219.86 500,000.00 3,728.05 11,754.59 50,000.00 550,000.00 376,025.55 44 Wastewater System Charges - - - 373,217.45 1,127,986.05 4,600,000.00 4,600,000.00 3,472,013.95 45 Wastewater Treatment Charges - - - 583,599.65 1,817,814.12 7,250,000.00 7,250,000.00 5,432,185.88 46 Other Operating Revenue (1,887.54) 139,355.43 585,000.00 100.00 100.00 200,000.00 785,000.00 645,544.57 47 Non Operating Revenue 8,450.95 63,743.88 100,000.00 (1,240.99) (2,079.74) 10,000.00 110,000.00 48,335.86 48 Gain or Loss on Disposition - - - - - - - - Revenue Total: 2,008,014.38 6,300,895.75 21,310,000.00 959,404.16 2,955,575.02 12,110,000.00 33,420,000.00 24,163,529.23 - - - - - Expense by Category 51 Labor 323,354.55 893,326.18 4,312,350.00 112,171.75 311,900.95 1,332,650.00 5,645,000.00 4,439,772.87 56 Benefits 112,669.10 447,862.98 1,415,500.00 616,992.63 1,959,484.15 7,328,100.00 8,743,600.00 6,336,252.87 63 Contract Services 186,195.60 445,920.20 2,945,450.00 75,826.24 157,482.53 8,164,050.00 11,109,500.00 3,644,497.27 65 Professional Development 10,835.15 20,409.92 208,640.00 4,752.80 8,371.44 87,460.00 296,100.00 267,318.64 53 Overtime 21,932.36 51,729.63 247,300.00 5,848.41 10,786.80 28,200.00 275,500.00 212,983.57 62 Materials and Supplies 92,249.65 188,397.53 1,892,950.00 8,331.63 16,133.44 105,050.00 1,998,000.00 1,793,469.03 64 Utilities 219,802.56 479,295.22 3,408,950.00 17,846.41 40,667.91 199,550.00 3,608,500.00 3,088,536.87 52 Temporary Labor 4,964.69 13,385.39 46,900.00 702.72 1,158.59 10,100.00 57,000.00 42,456.02 67 Other 6,792.82 148,813.65 217,350.00 2,953.01 63,042.66 93,150.00 310,500.00 98,643.69 54 Standby 2,360.00 6,184.95 34,000.00 780.00 1,930.65 6,000.00 40,000.00 31,884.40 61 Water Supply - - 575,000.00 - - - 575,000.00 575,000.00 71 -Debt Service 43,912.22 43,912.22 3,605,000.00 - - 320,000.00 3,925,000.00 3,881,087.78 81 -Capital Improvement 13,573.54 47,615.35 1,767,360.00 12,500.00 75,436.02 4,595,000.00 6,362,360.00 6,239,308.63 82 -Capital Outlay - - 633,250.00 - - 66,750.00 700,000.00 700,000.00 83 -Accounting Income Add back - - - - - - - - Expense Total: 1,038,642.24 2,786,853.22 21,310,000.00 858,705.60 2,646,395.14 22,336,060.00 43,646,060.00 31,351,211.64 Total Surplus (Deficit): 969,372.14$ 3,514,042.53$ -$ 100,698.56$ 309,179.88$ -$ -$ -$ Unaudited Revenue and Expense Budget-to-Actual by Category Month Ended September 30, 2015 WATER WASTEWATER DISTRICT WIDE MTD YTD BUDGET MTD YTD BUDGET TOTAL BUDGET REMAINING BUDGET Revenue 41 Water Sales 1,270,413.74$ 3,898,397.18$ 11,950,000.00$ -$ -$ -$ 11,950,000.00$ 8,051,602.82$ 42 Meter Charges 679,200.27 2,037,179.40 8,175,000.00 - - - 8,175,000.00 6,137,820.60 43 Penalties 51,836.96 162,219.86 500,000.00 3,728.05 11,754.59 50,000.00 550,000.00 376,025.55 44 Wastewater System Charges - - - 373,217.45 1,127,986.05 4,600,000.00 4,600,000.00 3,472,013.95 45 Wastewater Treatment Charges - - - 583,599.65 1,817,814.12 7,250,000.00 7,250,000.00 5,432,185.88 46 Other Operating Revenue (1,887.54) 139,355.43 585,000.00 100.00 100.00 200,000.00 785,000.00 645,544.57 47 Non Operating Revenue 8,450.95 63,743.88 100,000.00 (1,240.99) (2,079.74) 10,000.00 110,000.00 48,335.86 48 Gain or Loss on Disposition - - - - - - - - Revenue Total: 2,008,014.38 6,300,895.75 21,310,000.00 959,404.16 2,955,575.02 12,110,000.00 33,420,000.00 24,163,529.23 Progra 1000 - Board of Directors 9,085.01 23,700.56 206,500.00 3,753.26 9,519.46 88,500.00 295,000.00 261,779.98 Progra 2000 - General Administration 55,157.84 126,653.26 918,400.00 22,209.71 49,550.99 393,600.00 1,312,000.00 1,135,795.75 Progra 2100 - Human Resources 26,170.80 208,320.80 487,900.00 11,215.88 89,279.94 209,100.00 697,000.00 399,399.26 Progra 2200 - Public Affairs 32,514.90 95,052.31 354,900.00 9,729.00 28,753.73 152,100.00 507,000.00 383,193.96 Progra 2300 - Conservation 70,424.05 134,322.25 1,511,000.00 - - - 1,511,000.00 1,376,677.75 Progra 3000 - Finance 200,482.64 443,140.38 3,716,610.00 25,630.91 74,806.21 297,690.00 4,014,300.00 3,496,353.41 Progra 3200 - Information Technology 38,530.02 94,022.94 371,580.00 32,105.37 74,431.02 244,400.00 615,980.00 447,526.04 Progra 3300 - Customer Service 96,719.98 240,594.05 1,314,050.00 41,557.86 113,314.95 405,770.00 1,719,820.00 1,365,911.00 Progra 3400 - Meter Service 13,449.51 41,858.49 176,750.00 12,938.37 40,324.84 176,750.00 353,500.00 271,316.67 Progra 4000 - Engineering 43,020.07 153,571.20 525,300.00 27,285.86 80,814.01 338,400.00 863,700.00 629,314.79 Progra 5000 - Water Production 238,182.93 567,500.63 4,791,000.00 742.39 1,074.51 6,800.00 4,797,800.00 4,229,224.86 Progra 5100 - Water Treatment 43,128.17 143,458.81 736,000.00 - - - 736,000.00 592,541.19 Progra 5200 - Water Quality 23,413.71 64,670.93 342,000.00 - - - 342,000.00 277,329.07 Progra 6000 - Field Maintenance Administration 14,559.85 42,221.18 248,850.00 14,020.94 41,034.56 106,650.00 355,500.00 272,244.26 Progra 6100 - Water Maintenance 132,567.59 388,444.22 1,672,000.00 - - - 1,672,000.00 1,283,555.78 Progra 6200 - Wastewater Maintenance - - - 615,846.91 1,889,596.77 7,709,000.00 7,709,000.00 5,819,403.23 Progra 7000 - Facilities Maintenance 56,235.84 122,869.70 582,900.00 16,185.75 43,596.07 205,100.00 788,000.00 621,534.23 Progra 7100 - Fleet Maintenance 28,361.67 73,568.44 370,650.00 12,983.39 34,862.06 158,850.00 529,500.00 421,069.50 Progra 8000 - Capital 57,485.76 91,527.57 6,005,610.00 12,500.00 75,436.02 4,981,750.00 10,987,360.00 10,820,396.41 Expense Total: 1,109,066.29 2,786,853.22 22,821,000.00 858,705.60 2,646,395.14 15,474,460.00 38,295,460.00 32,727,889.39 Total Surplus (Deficit):898,948.09$ 3,514,042.53$ -$ 100,698.56$ 309,179.88$ -$ -$ -$ Revenue and Expense Budget-to-Actual by Program Month Ended September 30, 2015 Unaudited WATER WASTEWATER DISTRICT WIDE MTD YTD BUDGET MTD YTD BUDGET TOTAL BUDGET REMAINING BUDGET Revenue 41 Water Sales 1,270,413.74 3,898,397.18$ 11,950,000.00$ - -$ - 11,950,000.00 8,051,602.82 42 Meter Charges 679,200.27 2,037,179.40 8,175,000.00 - - - 8,175,000.00 6,137,820.60 43 Penalties 51,836.96 162,219.86 500,000.00 3,728.05 11,754.59 50,000.00 550,000.00 376,025.55 44 Wastewater System Charges - - - 373,217.45 1,127,986.05 4,600,000.00 4,600,000.00 3,472,013.95 45 Wastewater Treatment Charges - - - 583,599.65 1,817,814.12 7,250,000.00 7,250,000.00 5,432,185.88 46 Other Operating Revenue (1,887.54) 139,355.43 585,000.00 100.00 100.00 200,000.00 785,000.00 645,544.57 47 Non Operating Revenue 8,450.95 63,743.88 100,000.00 (1,240.99) (2,079.74) 10,000.00 110,000.00 48,335.86 48 Gain or Loss on Disposition - - - - - - - - 56 Benefits 77.35 750.05 - 7.81 164.01 - - (914.06) 68 Depreciation - - - - - - - Revenue Total: 2,008,014.38 6,300,895.75 21,310,000.00 959,404.16 2,955,575.02 12,110,000.00 33,420,000.00 24,163,529.23 Program: 1000 - Board of Directors - - - 51 Labor 5,388.51$ 14,741.15$ 73,500.00$ 2,309.39$ 6,317.70$ 31,500.00$ 105,000.00$ 83,941.15$ 56 Benefits 2,046.50 6,798.79 28,000.00 753.87 2,417.15 12,000.00 40,000.00 30,784.06 63 Contract Services - - 70,000.00 - - 30,000.00 100,000.00 100,000.00 65 Professional Development 1,650.00 2,160.62 35,000.00 690.00 784.61 15,000.00 50,000.00 47,054.77 Program: 1000 - Board of Directors Total: 9,085.01 23,700.56 206,500.00 3,753.26 9,519.46 88,500.00 295,000.00 261,779.98 Program: 2000 - General Administration - - - 51 Labor 19,810.28 55,211.90 395,500.00 8,490.12 23,662.21 169,500.00 565,000.00 486,125.89 53 Overtime - - - - - - - - 56 Benefits 11,983.32 41,725.73 140,000.00 3,706.35 13,153.51 60,000.00 200,000.00 145,120.76 62 Materials and Supplies 94.18 326.58 4,900.00 40.36 139.96 2,100.00 7,000.00 6,533.46 63 Contract Services 20,393.65 24,797.21 282,100.00 8,740.14 10,627.39 120,900.00 403,000.00 367,575.40 64 Utilities 231.92 463.84 4,200.00 99.39 198.78 1,800.00 6,000.00 5,337.38 65 Professional Development 2,644.49 4,128.00 91,700.00 1,133.35 1,769.14 39,300.00 131,000.00 125,102.86 Program: 2000 - General Administration Total: 55,157.84 126,653.26 918,400.00 22,209.71 49,550.99 393,600.00 1,312,000.00 1,135,795.75 Program: 2100 - Human Resources - - - - 51 Labor 10,234.57 29,025.23 140,000.00 4,386.24 12,439.38 60,000.00 200,000.00 158,535.39 52 Temporary Labor 677.60 1,741.30 8,400.00 290.40 746.27 3,600.00 12,000.00 9,512.43 53 Overtime 97.97 444.07 2,100.00 41.99 190.32 900.00 3,000.00 2,365.61 56 Benefits 4,241.83 15,951.04 45,500.00 1,817.78 6,835.85 19,500.00 65,000.00 42,213.11 62 Materials and Supplies 24.11 518.04 3,500.00 10.33 222.01 1,500.00 5,000.00 4,259.95 63 Contract Services 2,338.74 10,272.03 53,900.00 1,002.31 4,402.29 23,100.00 77,000.00 62,325.68 64 Utilities 26.61 101.53 350.00 11.40 43.51 150.00 500.00 354.96 65 Professional Development 1,809.74 3,252.19 16,800.00 775.61 1,393.79 7,200.00 24,000.00 19,354.02 67 Other 6,719.63 147,015.37 217,350.00 2,879.82 63,006.52 93,150.00 310,500.00 100,478.11 Program: 2100 - Human Resources Total: 26,170.80 208,320.80 487,900.00 11,215.88 89,279.94 209,100.00 697,000.00 399,399.26 Program: 2200 - Public Affairs - - - - 51 Labor 18,609.93 52,345.80 154,000.00 4,998.37 14,095.66 66,000.00 220,000.00 153,558.54 52 Temporary Labor - - 10,500.00 - - 4,500.00 15,000.00 15,000.00 53 Overtime 285.64 853.27 4,900.00 22.90 166.66 2,100.00 7,000.00 5,980.07 56 Benefits 4,215.12 18,161.94 44,100.00 1,546.76 6,516.67 18,900.00 63,000.00 38,321.39 Month Ended September 30, 2015 Unaudited Program Expense Detail Budget-to-Actual WATER WASTEWATER DISTRICT WIDE MTD YTD BUDGET MTD YTD BUDGET TOTAL BUDGET REMAINING BUDGET Month Ended September 30, 2015 Unaudited Program Expense Detail Budget-to-Actual WATER WASTEWATER DISTRICT WIDE 62 Materials and Supplies 392.98 873.14 31,500.00 131.00 274.70 13,500.00 45,000.00 43,852.16 63 Contract Services 8,236.11 20,523.45 91,000.00 2,745.37 6,894.15 39,000.00 130,000.00 102,582.40 64 Utilities 275.30 430.27 10,500.00 117.99 184.40 4,500.00 15,000.00 14,385.33 65 Professional Development 499.82 1,864.44 8,400.00 166.61 621.49 3,600.00 12,000.00 9,514.07 Program: 2200 - Public Affairs Total: 32,514.90 95,052.31 354,900.00 9,729.00 28,753.73 152,100.00 507,000.00 383,193.96 Program: 2300 - Conservation - - - - 51 Labor 5,875.70 14,800.90 230,000.00 - - - 230,000.00 215,199.10 52 Temporary Labor - - 25,000.00 - - - 25,000.00 25,000.00 53 Overtime 5.25 5.25 8,000.00 - - - 8,000.00 7,994.75 56 Benefits 2,571.10 7,766.96 60,000.00 - - - 60,000.00 52,233.04 62 Materials and Supplies 56,466.01 78,481.18 1,037,000.00 - - - 1,037,000.00 958,518.82 63 Contract Services 5,505.99 25,024.48 130,000.00 - - - 130,000.00 104,975.52 64 Utilities - 8,243.48 15,000.00 - - - 15,000.00 6,756.52 65 Professional Development - - 6,000.00 - - - 6,000.00 6,000.00 Program: 2300 - Conservation Total: 70,424.05 134,322.25 1,511,000.00 - - - 1,511,000.00 1,376,677.75 Program: 3000 - Finance - - - - 51 Labor 37,925.51 105,542.99 448,000.00 16,253.80 45,219.71 192,000.00 640,000.00 489,237.30 52 Temporary Labor 962.09 962.09 - 412.32 412.32 - - (1,374.41) 53 Overtime 469.43 748.05 1,050.00 172.02 242.46 450.00 1,500.00 509.49 56 Benefits 12,978.50 52,077.23 143,500.00 5,557.89 22,197.07 61,500.00 205,000.00 130,725.70 62 Materials and Supplies 2,954.37 3,960.83 4,900.00 1,266.15 1,501.76 2,100.00 7,000.00 1,537.41 63 Contract Services 3,403.89 7,525.81 86,100.00 1,565.55 3,781.82 36,900.00 123,000.00 111,692.37 64 Utilities 98.10 197.28 1,750.00 42.05 84.55 750.00 2,500.00 2,218.17 65 Professional Development 842.65 3,188.57 9,310.00 361.13 1,366.52 3,990.00 13,300.00 8,744.91 67 Other - 293.03 - - - - - (293.03) Program: 3000 - Finance Total: 59,634.54 174,495.88 3,716,610.00 25,630.91 74,806.21 297,690.00 4,014,300.00 3,496,353.41 Program: 3200 - Information Technology - - - - 51 Labor 14,596.44 40,419.15 165,000.00 9,730.96 26,946.09 110,000.00 275,000.00 207,634.76 52 Temporary Labor - - - - - - - - 53 Overtime - - - - - - - - 56 Benefits 2,450.52 11,243.58 45,000.00 1,373.92 7,917.11 30,000.00 75,000.00 55,839.31 62 Materials and Supplies 508.21 870.18 19,800.00 508.20 870.18 13,200.00 33,000.00 31,259.64 63 Contract Services 20,097.61 40,063.17 135,000.00 20,097.61 38,118.17 90,000.00 225,000.00 146,818.66 64 Utilities 394.68 579.48 1,800.00 394.68 579.47 1,200.00 3,000.00 1,841.05 65 Professional Development 482.56 847.38 4,980.00 - - - 4,980.00 4,132.62 Program: 3200 - Information Technology Total: 38,530.02 94,022.94 371,580.00 32,105.37 74,431.02 244,400.00 615,980.00 447,526.04 Program: 3300 - Customer Service - - - - 51 Labor 24,492.94 68,525.36 325,500.00 13,423.28 35,927.70 139,500.00 465,000.00 360,546.94 52 Temporary Labor 3,325.00 10,682.00 - - - - - (10,682.00) 53 Overtime 281.89 796.35 3,500.00 107.32 255.48 1,500.00 5,000.00 3,948.17 56 Benefits 6,276.88 29,022.96 122,500.00 2,408.67 16,897.67 52,500.00 175,000.00 129,079.37 62 Materials and Supplies 436.68 920.44 6,300.00 436.67 920.43 2,700.00 9,000.00 7,159.13 63 Contract Services 56,465.22 117,673.94 734,800.00 19,257.97 46,962.39 154,200.00 889,000.00 724,363.67 64 Utilities 5,345.04 11,411.47 112,700.00 5,345.06 11,411.50 48,300.00 161,000.00 138,177.03 MTD YTD BUDGET MTD YTD BUDGET TOTAL BUDGET REMAINING BUDGET Month Ended September 30, 2015 Unaudited Program Expense Detail Budget-to-Actual WATER WASTEWATER DISTRICT WIDE 65 Professional Development 23.14 56.28 8,750.00 505.70 903.64 7,070.00 15,820.00 14,860.08 67 Other 73.19 1,505.25 - 73.19 36.14 - - (1,541.39) Program: 3300 - Customer Service Total: 96,719.98 240,594.05 1,314,050.00 41,557.86 113,314.95 405,770.00 1,719,820.00 1,365,911.00 Program: 3400 - Meter Service - - - - 51 Labor 8,502.74 24,551.85 112,500.00 8,502.58 24,551.54 112,500.00 225,000.00 175,896.61 53 Overtime 513.72 1,439.98 10,000.00 513.72 1,439.97 10,000.00 20,000.00 17,120.05 56 Benefits 4,096.77 15,331.54 42,500.00 3,585.83 13,798.32 42,500.00 85,000.00 55,870.14 62 Materials and Supplies 193.51 193.51 1,750.00 193.52 193.52 1,750.00 3,500.00 3,112.97 63 Contract Services 92.70 241.02 9,000.00 92.65 240.89 9,000.00 18,000.00 17,518.09 64 Utilities 50.07 100.59 1,000.00 50.07 100.60 1,000.00 2,000.00 1,798.81 65 Professional Development - - - - - - - - Program: 3400 - Meter Service Total: 13,449.51 41,858.49 176,750.00 12,938.37 40,324.84 176,750.00 353,500.00 271,316.67 Program: 4000 - Engineering - - - - 51 Labor 29,155.10 79,303.59 264,600.00 18,917.14 51,771.16 171,400.00 436,000.00 304,925.25 52 Temporary Labor - - 3,000.00 - - 2,000.00 5,000.00 5,000.00 53 Overtime - - 900.00 - - 600.00 1,500.00 1,500.00 56 Benefits 5,788.05 29,277.85 99,000.00 3,249.11 14,875.70 66,000.00 165,000.00 120,846.45 62 Materials and Supplies 295.82 431.27 7,200.00 295.81 431.27 4,800.00 12,000.00 11,137.46 63 Contract Services 3,406.42 35,505.03 110,700.00 4,320.90 11,760.48 73,800.00 184,500.00 137,234.49 64 Utilities 2,642.42 6,546.25 29,700.00 502.90 1,975.40 19,800.00 49,500.00 40,978.35 65 Professional Development 1,732.26 2,507.21 10,200.00 - - - 10,200.00 7,692.79 Program: 4000 - Engineering Surplus Total: 43,020.07 153,571.20 525,300.00 27,285.86 80,814.01 338,400.00 863,700.00 629,314.79 Program: 5000 - Water Production - - - - 51 Labor 45,992.32 121,600.55 618,000.00 - - - 618,000.00 496,399.45 53 Overtime 3,307.26 9,103.44 35,500.00 - - - 35,500.00 26,396.56 54 Standby 1,080.00 3,191.43 20,000.00 - - - 20,000.00 16,808.57 56 Benefits 17,126.37 57,765.35 190,000.00 - - - 190,000.00 132,234.65 61 Water Supply - - 575,000.00 - - - 575,000.00 575,000.00 62 Materials and Supplies 12,030.62 32,401.92 264,000.00 - - - 264,000.00 231,598.08 63 Contract Services 6,957.66 9,433.78 308,500.00 - - - 308,500.00 299,066.22 64 Utilities 150,916.23 332,056.69 2,773,000.00 - - - 2,773,000.00 2,440,943.31 65 Professional Development 772.47 1,947.47 7,000.00 742.39 1,074.51 6,800.00 13,800.00 10,778.02 Program: 5000 - Water Production Total: 238,182.93 567,500.63 4,791,000.00 742.39 1,074.51 6,800.00 4,797,800.00 4,229,224.86 Program: 5100 - Water Treatment - - - - 51 Labor 15,705.98 44,603.91 211,000.00 - - - 211,000.00 166,396.09 53 Overtime 618.84 2,632.18 10,000.00 - - - 10,000.00 7,367.82 56 Benefits 5,129.68 30,671.65 52,000.00 - - - 52,000.00 21,328.35 62 Materials and Supplies - 20,636.82 165,000.00 - - - 165,000.00 144,363.18 63 Contract Services 1,111.08 1,574.88 160,500.00 - - - 160,500.00 158,925.12 64 Utilities 20,562.59 43,339.37 137,500.00 - - - 137,500.00 94,160.63 Program: 5100 - Water Treatment Total: 43,128.17 143,458.81 736,000.00 - - - 736,000.00 592,541.19 Program: 5200 - Water Quality - - - - 51 Labor 11,356.70 32,396.23 160,000.00 - - - 160,000.00 127,603.77 53 Overtime - 30.68 3,000.00 - - - 3,000.00 2,969.32 MTD YTD BUDGET MTD YTD BUDGET TOTAL BUDGET REMAINING BUDGET Month Ended September 30, 2015 Unaudited Program Expense Detail Budget-to-Actual WATER WASTEWATER DISTRICT WIDE 56 Benefits 4,389.40 15,036.96 45,000.00 - - - 45,000.00 29,963.04 62 Materials and Supplies 839.01 3,349.39 19,500.00 - - - 19,500.00 16,150.61 63 Contract Services 6,813.45 13,716.27 112,000.00 - - - 112,000.00 98,283.73 64 Utilities 15.15 141.40 2,500.00 - - - 2,500.00 2,358.60 Program: 5200 - Water Quality Total: 23,413.71 64,670.93 342,000.00 - - - 342,000.00 277,329.07 Program: 6000 - Field Maintenance Administration - - - - 51 Labor 8,635.84 24,640.94 164,500.00 8,635.78 24,640.84 70,500.00 235,000.00 185,718.22 52 Temporary Labor - - - - - - - - 53 Overtime - - - - - - - - 54 Standby 1,280.00 2,993.52 14,000.00 780.00 1,930.65 6,000.00 20,000.00 15,075.83 56 Benefits 3,347.33 12,473.53 50,400.00 3,308.48 12,349.89 21,600.00 72,000.00 47,176.58 62 Materials and Supplies - 137.86 2,100.00 - 137.86 900.00 3,000.00 2,724.28 63 Contract Services - - - - - - - - 64 Utilities 918.66 1,517.57 10,500.00 918.67 1,517.58 4,500.00 15,000.00 11,964.85 65 Professional Development 378.02 457.76 7,350.00 378.01 457.74 3,150.00 10,500.00 9,584.50 Program: 6000 - Field Maintenance Administration 14,559.85 42,221.18 248,850.00 14,020.94 41,034.56 106,650.00 355,500.00 272,244.26 Program: 6100 - Water Maintenance - - - - 51 Labor 55,335.76 152,151.69 690,000.00 - - - 690,000.00 537,848.31 53 Overtime 15,124.72 33,025.16 150,000.00 - - - 150,000.00 116,974.84 56 Benefits 20,655.96 84,238.22 250,000.00 - - - 250,000.00 165,761.78 62 Materials and Supplies 12,182.36 29,315.36 250,000.00 - - - 250,000.00 220,684.64 63 Contract Services 12,080.19 65,113.87 282,000.00 - - - 282,000.00 216,886.13 64 Utilities 17,188.60 24,599.92 50,000.00 - - - 50,000.00 25,400.08 Program: 6100 - Water Maintenance Total: 132,567.59 388,444.22 1,672,000.00 - - - 1,672,000.00 1,283,555.78 Program: 6200 - Wastewater Maintenance - - - - 51 Labor - - - 11,043.48 30,702.76 135,000.00 135,000.00 104,297.24 53 Overtime - - - 4,343.86 7,081.40 3,000.00 3,000.00 (4,081.40) 56 Benefits - - - 3,585.47 15,258.48 55,000.00 55,000.00 39,741.52 62 Materials and Supplies - - - 3,000.80 4,155.71 35,000.00 35,000.00 30,844.29 Wastewater Treatment - - - 583,599.65 1,817,814.12 6,861,600.00 6,861,600.00 5,043,785.88 63 Contract Services - - - 10,273.65 14,584.30 619,400.00 619,400.00 604,815.70 Program: 6200 - Wastewater Maintenance Total:- - - 615,846.91 1,889,596.77 7,709,000.00 7,709,000.00 5,819,403.23 Program: 7000 - Facilities Maintenance - - - - 51 Labor 4,102.68 11,686.25 55,250.00 2,209.12 6,292.53 29,750.00 85,000.00 67,021.22 53 Overtime 1,096.22 2,496.07 16,250.00 590.28 1,344.03 8,750.00 25,000.00 21,159.90 56 Benefits 2,372.20 8,518.87 19,500.00 1,213.34 4,395.23 10,500.00 30,000.00 17,085.90 62 Materials and Supplies 1,433.16 3,058.73 29,300.00 379.70 1,090.88 7,700.00 37,000.00 32,850.39 63 Contract Services 34,768.26 65,643.23 327,350.00 5,146.47 13,658.20 83,650.00 411,000.00 331,698.57 64 Utilities 12,463.32 31,466.55 135,250.00 6,646.84 16,815.20 64,750.00 200,000.00 151,718.25 Program: 7000 - Facilities Maintenance Total: 56,235.84 122,869.70 582,900.00 16,185.75 43,596.07 205,100.00 788,000.00 621,534.23 Program: 7100 - Fleet Maintenance - - - - 51 Labor 7,633.55 21,778.69 105,000.00 3,271.49 9,333.67 45,000.00 150,000.00 118,887.64 53 Overtime 131.42 155.13 2,100.00 56.32 66.48 900.00 3,000.00 2,778.39 56 Benefits 2,999.57 11,800.78 38,500.00 1,285.51 5,057.38 16,500.00 55,000.00 38,141.84 MTD YTD BUDGET MTD YTD BUDGET TOTAL BUDGET REMAINING BUDGET Month Ended September 30, 2015 Unaudited Program Expense Detail Budget-to-Actual WATER WASTEWATER DISTRICT WIDE 62 Materials and Supplies 4,398.63 12,922.28 46,200.00 2,069.09 6,195.16 19,800.00 66,000.00 46,882.56 63 Contract Services 4,524.63 8,812.03 52,500.00 2,583.62 6,452.45 22,500.00 75,000.00 59,735.52 64 Utilities 8,673.87 18,099.53 123,200.00 3,717.36 7,756.92 52,800.00 176,000.00 150,143.55 65 Professional Development - - 3,150.00 - - 1,350.00 4,500.00 4,500.00 Program: 7100 - Fleet Maintenance Total: 28,361.67 73,568.44 370,650.00 12,983.39 34,862.06 158,850.00 529,500.00 421,069.50 Program: 8000 - Capital - - - 71 Debt Service 43,912.22 43,912.22 3,605,000.00 - - 320,000.00 3,925,000.00 3,881,087.78 81 Capital Improvement 13,573.54 47,615.35 1,767,360.00 12,500.00 75,436.02 4,595,000.00 6,362,360.00 6,239,308.63 82 Capital Outlay - - 633,250.00 - - 66,750.00 700,000.00 700,000.00 83 Accounting Income Add back - - - - - - - Program: 8000 - Capital Total: 57,485.76 91,527.57 6,005,610.00 12,500.00 75,436.02 4,981,750.00 10,987,360.00 10,820,396.41 Total Surplus (Deficit): 969,372.14$ 3,514,042.53$ -$ 100,698.56$ 309,179.88$ -$ -$ -$ BOARD AGENDA STAFF REPORT Agend a Item #2.b . Meeting Date: Octob er 28, 2015 Cons ent Item T o: Governing Bo ard Members From: General Manager/C EO Subject: Investment R eport for Quarter Ended Sep temb er 30 2015 RECOMMENDATION: Staff recommends that the Bo ard o f Direc to rs acc ep t and file the attached Inves tment Rep o rt fo r the quarter ended , September 30, 2015. BACKGROUND / ANALYSIS: California Go vernment Cod e §53646(b) req uires the Treas urer o r CFO o f a loc al agency to sub mit a quarterly rep o rt on the agenc y’s investments to the legislative bod y of the agenc y within 30 days of the end o f each quarter. Discussion The attached s c hedule shows all of the Dis tric t’s c as h and inves tments, res tric ted and unres tric ted, as of September 30, 2015. Attachment A shows the inves tment s ec urities purchas ed and retired during the quarter July to Sep temb er 2015. Inc reases and decreas es in highly liquid fund s , such as LAIF, are explained in the narrative belo w. Unrestricted Investments LAIF The b alance held in the Local Agenc y Inves tment Fund at the b eginning of the q uarter was $13,117,520. The Dis trict was able to make one transfer o f $1,105,000 into LAIF as s ummer revenue outp aced District spending during the first q uarter o f the 2015-16 fisc al year. In additio n, interest earned during las t quarter of $9,273 was p o s ted to the ac co unt in July, resulting in an ending balance of $14,231,793. LAIF earnings fo r the quarter ended Sep temb er 30th were $10,656.30, c alc ulated at an appo rtionment rate of 0.32%; up fro m 0.28% which had been in effec t fo r the p revio us quarter. The earnings were p osted to the Distric t’s acc o unt on Oc to b er 15, 2015. Citizen’s Business Bank (C BB) Wealth Management The to tal (boo k) value of the as s ets held with CBB increas ed $2,291 to $5,497,596 d uring the q uarter ended 9/30/15. The b alance in this acc ount is held bo th in a mo ney market ac count ($559,913) and in a p o rtfo lio of Treasury and federal agency s ecurities s hown on Attac hment A. Net interest p ayments rec eived on sec urities in the Dis trict’s portfolio were $4,942 and funds held in mo ney market ac co unts earned $219. Earnings were p artially o ffset b y a $793 amo rtizatio n charge agains t premiums paid on the ac quisition of c ertain b ond s , and inves tment manager fees paid during the quarter were $2,077. There were no District trans fers to o r from this inves tment acc o unt during the first quarter o f 2015. The following sc hed ule s ummarizes the activity for Unres tric ted Inves tments during the Quarter end ed S eptember 30, 2015: Restricted Investments Trust ac counts with Unio n Bank are used to s afeguard fund s whic h are res tric ted by bond c o venants . Thes e ac co unts c o ntain b ond proc eed s , whic h are res tric ted fo r use o n projects for which b ond s were issued, and installment payments fro m the Dis tric t, whic h are res tric ted in us e fo r p ayment o f s emi-annual bond payments. The b o nd covenants do no t req uire that the Dis tric t make monthly ins tallment payments to the Trustee, therefore, d ue to d ismal earnings (0.01%) by fund s held in Unio n Bank trus t acc ounts, the Dis tric t will acc umulate funds at an alternative institution such as LAIF, and make o ne d eposit with Union Bank immed iately p rior to b o nd p ayment dates . This alternative strategy will begin after the Oc to ber 1st b ond payment date. Unio n Bank – 2010 Revenue Bond Trus t Ac counts All b o nd p ro c eed s from the 2010 Revenue Bo nd issue have been s p ent and the related Water and Sewer Ac quisition trus t accounts clo s ed . The Dis tric t has b een making monthly ins tallment payments into the Revenue Acc o unt, which is ac c umulating fund s to make the annual princ ipal and interes t p ayments to bo ndhold ers o n Oc tober 1st, 2015. Unio n Bank – 2013 Revenue Bond Trus t Ac counts As o f September 30, 2015, the Dis trict had $401,420 o f uns pent bond proc eed s to p ay for pip eline p ro jec ts currently und er cons truc tio n. The Dis tric t makes monthly ins tallment payments into the 2013 Revenue Account to provide funds for p rinc ip al and interest payments to ho lders of the 2013 bo nds in April and Oc tober of 2015. Summary Sc hed ule o f Union Bank T rustee Acc o unts The following sc hed ule s ummarizes activity in the Union Bank acc o unts for the Quarter ended September 30, 2015: AGENCY IDEALS AND ENDEAVORS: Ideals and Endeavo r II - Maintain An Environment Co mmitted To Elevated P ub lic Servic e (E) - Prac tic e Trans p arent & Acc ountable F isc al Management FISCAL IMPACT: There is no fis cal impac t as s oc iated with this agenda item. Respec tfully s ub mitted: Rec o mmended by: Jo hn Mura General Manager / CEO Brian T omp kins Chief F inancial Officer ATTACHMENTS: Description Type Attachment A - CBB Investment Ac tivity Re port 9-30-15 Backup Material Investment Report 09-3 0-1 5 Backup Material EAST VALLEY WATER DISTRICT Investment Activity Quarter Ended September 30, 2015 Market Purch Units / Maturity Adjusted Cost Matured / Adjusted Cost Value Date Issuer CUSIP Yield Face Value Date 07/01/2015 Purchases Called 09/30/2015 09/30/2015 04/19/12 FHLB Series YP-2017 3133XNDB2 5.250% 28,210 06/15/17 32,761.26 1,596.02 31,165.24 29,914.26 10/11/12 Federal Farm Credit Bank 3133EA3K2 0.620% 300,000 10/11/16 300,000.00 300,000.00 300,018.00 11/01/12 Federal Home Loan Bank 3133813G8 0.640% 400,000 11/01/16 400,000.00 400,000.00 400,024.00 03/20/13 Federal Home Loan Bank 313382GR8 0.750% 300,000 03/20/17 299,730.00 299,730.00 300,021.00 09/16/13 Federal Home Loan Bank 313372Q80 2.580% 100,000 02/26/16 100,789.90 100,789.90 100,932.00 04/07/15 Federal Home Loan Bank 3133802Q9 1.650% 100,000 07/18/19 99,960.00 99,960.00 100,071.00 04/09/15 Federal Farm Credit Bank 3130A4PQ9 2.050% 100,000 04/09/20 99,935.00 99,935.00 100,019.00 03/20/15 Federal Home Loan Bank 3130A4EB4 2.050% 03/30/17 399,960.00 399,960.00 - 12/30/14 FHLB 3130A3MR2 2.000% 12/30/14 400,000.00 400,000.00 - 08/27/14 Tenn Valley Authority 880591EQ1 1.750% 172,000 10/15/18 172,806.92 172,806.92 175,357.44 02/20/15 Federal Home Loan Bank 3130A43J9 1.750% 100,000 02/20/15 99,940.00 99,940.00 100,018.00 03/03/14 US Treasury Note 912828SY7 0.625% 300,000 05/31/17 297,937.50 297,937.50 300,222.00 07/30/15 Freddie Mac 3134G7GS4 2.000% 100,000 04/30/20 100,000.00 100,000.00 100,144.00 07/30/15 Freddie Mac 3134G7GD7 1.500% 100,000 10/30/18 99,990.00 99,990.00 100,100.00 07/30/15 Freddie Mac 3134G7HA2 1.550% 200,000 01/30/19 200,000.00 200,000.00 200,212.00 09/21/15 Freddie Mac 3134G33G3 1.600% 400,000 01/09/20 - 399,880.00 399,880.00 400,124.00 02/27/12 Freddie Mac Series 3578 31398JVS9 4.500% 20,674 09/15/16 33,890.40 12,110.54 21,779.86 20,827.73 06/15/12 GNMA Series 2009-78 38376FUD2 5.000% 09/20/17 43,478.46 43,478.46 - 10/02/12 Freddie Mac 3134A4ZY3 5.750% 125,000 06/27/16 132,053.33 132,053.33 129,925.00 10/24/12 Federal Home Loan Bank 31338OZ26 0.625% 266,667 10/24/16 266,666.67 266,666.67 266,597.33 Activity (Book Value) Attachment A EAST VALLEY WATER DISTRICT Investment Activity Quarter Ended September 30, 2015 Market Purch Units / Maturity Adjusted Cost Matured / Adjusted Cost Value Date Issuer CUSIP Yield Face Value Date 07/01/2015 Purchases Called 09/30/2015 09/30/2015 Activity (Book Value) 11/23/12 US Treasury Note 912828MA5 2.750% 500,000 11/30/16 519,149.90 519,149.90 513,360.00 03/27/13 Federal Home Loan Bank 313382HT3 0.750% 200,000 03/27/17 199,994.00 199,994.00 200,014.00 08/13/13 Federal Farm Credit Bank 3133ECWV2 0.300% 200,000 12/07/16 199,660.00 199,660.00 201,082.00 12/02/13 US Treasury Note 912828UE8 0.750% 500,000 12/31/17 494,428.71 494,428.71 500,210.00 03/30/15 Federal Home Loan Bank 3130A4K84 2.100% 03/30/17 100,000.00 100,000.00 - 05/06/15 Freddie Mac 3134G6A37 1.740% 100,000 05/06/20 99,853.00 99,853.00 100,156.00 05/08/15 FHLB 3130A5CL1 1.800% 100,000 12/30/14 100,000.00 100,000.00 100,150.00 05/28/15 FHLB 3130A5CQ0 2.000% 05/28/20 200,000.00 200,000.00 - 06/25/15 FHLB 3130A5NA3 1.460% 100,000.00 100,000.00 - 09/30/15 Freddie Mac 3134G7UY5 2.000% 100,000 09/30/20 - 100,000.00 100,000.00 100,267.00 09/30/15 Tenn Valley Authority 880591EQ1 1.750% 100,000 10/15/18 - 101,963.00 101,963.00 101,952.00 4,912,551 5,592,985.05 601,843.00 1,257,145.02 4,937,683.03 4,941,717.76 Attachment A BOARD AGENDA STAFF REPORT Agenda Item #2.c . Meeting Date: Octo ber 28, 2015 Cons ent Item T o: Go verning Board Memb ers From: General Manager/CEO Subject: Sep tember 2015 Dis burs ements: Ac c ounts payable disb urs ements fo r the p erio d inc lude c hec k numb ers 245526 through 245820, bank drafts , and ACH Payments in the amo unt of $4,377,129.59 and $317,799.32 for payro ll. RECOMMENDATION: S taff reco mmend s that the Board o f Direc tors review and approve the Dis trict’s expens e dis burs ements for the perio d Sep temb er 1, 2015 through September 30, 2015 in the amount o f $4,694,928.91. BACKGROUND / ANALYSIS: In the co ntinued effo rt to b e fis c ally trans parent, the payment register for s upp lies, materials, s ervices, and payroll fo r S ep temb er 2015 is attac hed fo r review and ap p ro val. This pro c es s provides the Board and the pub lic an op portunity to review the exp ens es o f the Distric t. Ac c ounts Payab le is p ro c es sed weekly, while payro ll is process ed bi-weekly. Info rmation to jus tify eac h exp enditure is available thro ugh the Finance Dep artment. Ac co unts p ayable disb urs ements for the perio d inc lud e chec k numbers 245526 thro ugh 245820, bank drafts, and ACH Payments in the amount o f $4,377,129.59 and $317,799.32 fo r p ayroll. Significant expens es greater than or eq ual to $50,000 are further exp lained belo w: CHECK #VENDOR DESCRIPTION AMOUNT DFT0001184 CALPERS/ MEDICAL MEDICAL PREMIUM FOR SEPTEMBER 2015 $ 66,966.65 245532 CITY OF HIGHLAND 30" DISTRIBUTION PIPELINE FROM EVWD PLANT 151 TO PLANT 40 (CIP PROJECT)$ 501,820.60 245557 NEXUS IS, INC MATERIALS AND PROFESSIONAL SERVICES FOR THE SAN STORAGE AND VIRTUALIZATION PROJECT (CIP PROJECT) $ 82,922.57 10000554 US BANCORP, GOVERNMENT LEASING AND FINANCE, INC ENERGY CONSERVATION MEASURES CONTRACT PAYMENT $ 228,247.83 10000564 INFOSEND, INC POSTAGE, FEDEX, CUST/SHADOW BILLING FOR AUGUST 2015 $ 50,477.46 245713 SOUTHERN CALIFORNIA EDISON COMPANY ELECTRICITY FOR AUGUST 2015 $ 181,456.24 245713 EDISON COMPANY ELECTRICITY FOR AUGUST 2015 $ 181,456.24 10000581 LEGEND PUMP AND WELL MATERIALS FOR SUBMERSIBLE CONVERSION FOR WELL AND BOOSTER REHABILITATION OF PLANT 143 (CIP PROJECT) $ 95,946.20 10000583 MUFG UNION BANK N.A.AUGUST INSTALLMENT 2010 AND 2013 BONDS $ 277,842.95 DFT0001214 TRANSFER TO LAIF WIRE TRANSFER TO LAIF $1,105,000.00 245816 SAN BERNARDINO MUNICIPAL WATER DEPARTMENT SEWER TREATMENT FOR AUGUST 2015 $ 631,745.92 10000610 ENVIRONMENTAL SCIENCE ASSOCIATES/ESA ENVIRONMENTAL SVCS FOR CEQA ENVIRONMENT IMPACT REPORT FOR THE RECYCLED WATER FACILITY PROJECT (CIP PROJECT) $ 73,745.72 AGENCY IDEALS AND ENDEAVORS: Id eals and Endeavo r II - Maintain An Enviro nment Committed To Elevated Public S ervice (E) - P rac tic e T rans parent & Ac c ountab le Fiscal Management REVIEW BY OTHERS: This agend a item has b een reviewed by the F inanc e Department. FISCAL IMPACT: S uffic ient fund s have been bud geted in the ad op ted F Y 2015-16 Budget. Res pec tfully s ub mitted : Rec ommended by: Jo hn Mura General Manager / CEO Brian Tomp kins Chief Financ ial Officer ATTACHMENTS: Description Type Se ptember 2 0 1 5 Check Register Backup Material PAYMENT DATE NUMBER VENDOR NAME AMOUNT 09/03/2015 245526 ALTERNATIVE HOSE INC 44.81$ 09/03/2015 245527 BOLLINGER CONSULTING GROUP 375.00 09/03/2015 245528 BOOT BARN, INC 113.65 09/03/2015 245529 BRADEN HEYWOOD DBA GENESIS 1,395.28 09/03/2015 245530 CCH 359.77 09/03/2015 245531 CDW GOVERNMENT 159.29 09/03/2015 245532 CITY OF HIGHLAND 501,820.60 09/03/2015 245533 CITY OF RIVERSIDE 150.00 09/03/2015 245534 COLONIAL LIFE, PREMIUM 360.28 09/03/2015 245535 DELL SOFTWARE, INC 9,205.37 09/03/2015 245536 DIRECTV 227.97 09/03/2015 245537 ED KING 105.00 09/03/2015 245538 EVERSOFT, INC 186.86 09/03/2015 245539 EXCEL LANDSCAPE, ICN 9,860.00 09/03/2015 245540 EXPERIAN 157.52 09/03/2015 245541 FLEET SERVICES /COLTON TRUCK 39.54 09/03/2015 245542 GARY YOUNG 395.87 09/03/2015 245543 HATFIELD BUICK 46.30 09/03/2015 245544 HENRY SOWLE 363.41 09/03/2015 245545 HIGHLAND COMMUNITY NEWS 2,053.76 09/03/2015 245546 HUB CONSTRUCTION SPECIALTIES 724.28 09/03/2015 245547 I.C.W.A. 125.00 09/03/2015 245548 INLAND WATER WORKS SUPPLY CO 1,085.43 09/03/2015 245549 JAMES SMOTHERS, SMOTHERS APPRAISAL CO. 3,000.00 09/03/2015 245550 JONATHAN PEEL 125.00 09/03/2015 245551 K & L HARDWARE 15.11 09/03/2015 245552 KEN TAYLOR 97.19 09/03/2015 245553 LAWSON PRODUCTS,INC 399.93 09/03/2015 245554 MICHAEL REARDON 363.41 09/03/2015 245555 MIKE MALONEY 42.00 09/03/2015 245556 NAPA AUTO PARTS /BOSS MOSS 123.09 09/03/2015 245557 NEXUS IS, INC 82,922.57 09/03/2015 245558 PARRON HALL CORPORATION 2,268.42 09/03/2015 245559 PC CONNECTION 1,686.16 09/03/2015 245560 RON COATS 1,568.00 09/03/2015 245561 ROW TRAFFIC SAFETY, INC 78.84 SEPTEMBER 1, 2015 - SEPTEMBER 30, 2015 CHECK REGISTER CHECK REGISTER SEPTEMBER 1, 2015 - SEPTEMBER 30, 2015 Page 1 of 10 PAYMENT DATE NUMBER VENDOR NAME AMOUNT 09/03/2015 245562 SAN BDNO CO FIRE PROTECTION 2,952.00$ 09/03/2015 245563 STAPLES ADVANTAGE 1,463.95 09/03/2015 245564 VALLEY OFFICE EQUIPMENT 220.85 09/03/2015 245565 VERIZON CALIFORNIA 48.87 09/03/2015 245566 PAC INV LLC 62.02 09/03/2015 245567 LUCY JUNG 29.60 09/03/2015 245568 DAVID PRICE 41.23 09/03/2015 245569 ALMA C SANCHEZ 35.02 09/03/2015 245570 ZAMUEL ESTEVA 16.47 09/03/2015 245571 DRRI HOLDINGS INC. 34.26 09/03/2015 245572 HAI NGOC HA 17.17 09/03/2015 245573 R DEPENDABLE CONST INC 12.92 09/03/2015 245574 DAVID G SCHMIDT 42.11 09/03/2015 245575 CANDACE BROWN 15.45 09/03/2015 245576 LEE LUU 40.71 09/03/2015 245577 FATIMA VANEGAS 17.39 09/03/2015 245578 MAJ BRH BEHI 1.82 09/10/2015 245579 JOE COTUGNA 150.00 09/10/2015 245580 SAVY NGOY CHUNG 265.08 09/10/2015 245581 FELICITY MENDOZA 269.94 09/10/2015 245582 JIMMY RODRIGUEZ 200.00 09/10/2015 245583 KENNETH POSEY 100.00 09/10/2015 245584 LORIN WHITTAKER 200.00 09/10/2015 245585 MARIA ROMERO 98.00 09/10/2015 245586 MARIA VICTORIA ADLAWAN 160.00 09/10/2015 245587 MARK THOMPSON 69.00 09/10/2015 245588 RICHARD HALLER 100.00 09/10/2015 245589 ROSILLICIE BOGH 100.00 09/10/2015 245590 SAN BERNARDINO COUNTY PROBATION DEPT 100.00 09/10/2015 245591 VALERIE CUSSON 58.00 09/10/2015 245592 WAYNE AND CHERYL MCKEE 188.10 09/10/2015 245593 BRADEN HEYWOOD DBA GENESIS 621.60 09/10/2015 245594 BRINKS INCORPORATED 1,180.44 09/10/2015 245595 CAL DISPOSAL 257.80 09/10/2015 245596 CHEM-TECH INTERNATIONAL INC 2,859.47 09/10/2015 245597 CULLIGAN OF ONTARIO 50.00 09/10/2015 245598 EWING IRRIGATION PRODUCTS INC 324.79 09/10/2015 245599 EXCEL LANDSCAPE, ICN 3,445.00 09/10/2015 245600 FAIRVIEW FORD SALES,INC 23,226.59 09/10/2015 245601 FLEET METAL BOX CORP 669.38 09/10/2015 245602 FRANCHISE TAX BOARD 36.00 09/10/2015 245603 HATFIELD BUICK 743.79 09/10/2015 245604 HUB CONSTRUCTION SPECIALTIES 424.08 09/10/2015 245605 INLAND WATER WORKS SUPPLY CO 305.27 09/10/2015 245606 K & L HARDWARE 109.21 CHECK REGISTER SEPTEMBER 1, 2015 - SEPTEMBER 30, 2015 Page 2 of 10 PAYMENT DATE NUMBER VENDOR NAME AMOUNT 09/10/2015 245607 KONICA MINOLTA 70.54$ 09/10/2015 245608 LAND ENGINEERING CONSULTANTS 120.00 09/10/2015 245609 LAW PLUMBING CO 14,310.00 09/10/2015 245610 LEIDA THOMAS 99.00 09/10/2015 245611 LOUIE CHECK 30.00 09/10/2015 245612 NAPA AUTO PARTS /BOSS MOSS 90.98 09/10/2015 245613 PARSONS BRINCKERHOFF, INC 13,453.54 09/10/2015 245614 PATTON'S SALES CORP 26.85 09/10/2015 245615 POMONA VALLEY WORKSHOP 1,042.50 09/10/2015 245616 RONALD C. BRAATZ LIFTOFF, LLC 7,848.00 09/10/2015 245617 RUHNAU RUHNAU CLARK & ASSOCIATES 12,500.00 09/10/2015 245618 SAN BDNO PUBLIC EMPLOYEES ASSN 239.01 09/10/2015 245619 STAPLES ADVANTAGE 173.70 09/10/2015 245621 STAR AUTO PARTS 94.52 09/10/2015 245622 THE GAS COMPANY 39.43 09/10/2015 245623 VIRTUAL GRAFFITI, INC. 12,444.53 09/14/2015 2154 MS LINDA SPITZER 128.00 09/14/2015 2155 MICHAEL RALEY 4.00 09/17/2015 245624 SFR 2012-1 US WEST LLC 115.88 09/17/2015 245625 STATE FARM MUTUAL AUTOMOBILE INSURANCE 294.15 09/17/2015 245626 TICH NGUYEN 82.56 09/17/2015 245627 ROSE OLIVAS 96.59 09/17/2015 245628 JORGE RAMIREZ 24.98 09/17/2015 245629 BETTY CANFIELD 29.02 09/17/2015 245630 LUELLEN LOVEROCK 17.27 09/17/2015 245631 DENISE RHODES 40.88 09/17/2015 245632 NICHOLAS MOLINA 41.81 09/17/2015 245633 VASILE ZAHARIA 8.13 09/17/2015 245634 RICKY BENNETT 52.31 09/17/2015 245635 EAGLE VISTA EQUITIES, LLC 4.64 09/17/2015 245636 DCI/JH 51.01 09/17/2015 245637 KIM POE 36.28 09/17/2015 245638 VALERIE L THURMOND 15.81 09/17/2015 245639 DE LA PAZ REAL ESTATE ENT 71.93 09/17/2015 245640 LAN HE 47.57 09/17/2015 245641 ABELARDO SOLIS 2,500.00 09/17/2015 245642 ALDO RAMIREZ 100.00 09/17/2015 245643 BEN PHAM 176.00 09/17/2015 245644 BILL OR LYNDA SCHUBERT 2,500.00 09/17/2015 245645 BRIAN BROWN 100.00 09/17/2015 245646 CARL FELDMAN 200.00 09/17/2015 245647 CARL LAUMER 100.00 09/17/2015 245648 CAROL COOPER 200.00 09/17/2015 245649 CHARLES CHAPMAN 2,500.00 09/17/2015 245650 DAVID TANNEN 30.00 CHECK REGISTER SEPTEMBER 1, 2015 - SEPTEMBER 30, 2015 Page 3 of 10 PAYMENT DATE NUMBER VENDOR NAME AMOUNT 09/17/2015 245651 DONALD CLAY 2,500.00$ 09/17/2015 245652 DONNA LUCIA 200.00 09/17/2015 245653 ED OR KIM MARCHALL 100.00 09/17/2015 245654 ELFI THOMAS 200.00 09/17/2015 245655 ELWOOD HALL 200.00 09/17/2015 245656 FRED VOLLOR 2,500.00 09/17/2015 245657 GARY ROBERTS 200.00 09/17/2015 245658 GUSTAV SMITH 60.00 09/17/2015 245659 HUGO GOMNZALES 387.00 09/17/2015 245660 JEFFREY STRYCULA 200.00 09/17/2015 245661 JILL & MIKE EATON 250.00 09/17/2015 245662 JOE GONZALEZ 2,500.00 09/17/2015 245663 JOSE ANTONIO RAMOS 2,500.00 09/17/2015 245664 KAREN THAU 100.00 09/17/2015 245665 KIET LY 602.78 09/17/2015 245666 KIRK DUNN 2,500.00 09/17/2015 245667 LAWRENCE GATLIN 300.00 09/17/2015 245668 MAJUNU SERAN 286.00 09/17/2015 245669 MARION ALLRED 2,500.00 09/17/2015 245670 MARK BEHNE 100.00 09/17/2015 245671 MATHEW BENNIE 200.00 09/17/2015 245672 MICHAEL HOLSTEIN 600.00 09/17/2015 245673 MICHAEL MANN 2,500.00 09/17/2015 245674 MIKE CASTENADA 200.00 09/17/2015 245675 NICOLE HAMILTON 60.00 09/17/2015 245676 RAUL FERNANDEZ 88.00 09/17/2015 245677 RICHARD HAUG 89.98 09/17/2015 245678 ROBERT SHERWOOD 100.00 09/17/2015 245679 RYAN WHITESIDE 64.00 09/17/2015 245680 SAMUEL RIGGIO 30.00 09/17/2015 245681 STACI RICHARDS 200.00 09/17/2015 245682 THOMAS OR MICHELLE SWANTEK 2,600.00 09/17/2015 245683 TIMOTHY SQUIRES 2,500.00 09/17/2015 245684 WILLIAM FORD 2,500.00 09/17/2015 245685 WILLIAM MICHAELS 2,500.00 09/17/2015 245686 ALLIED STORAGE CONTAINERS, INC. 2,570.40 09/17/2015 245687 BELL ROOF CO., INC. 3,201.00 09/17/2015 245688 BOOT BARN, INC 178.60 09/17/2015 245689 C & R HOMES INSPECTIONS, LLC 295.00 09/17/2015 245690 CANNON CORPORATION 3,234.00 09/17/2015 245691 CITY OF SAN BERNARDINO, PUBLIC WORKS DEPT 2,766.24 09/17/2015 245692 COUNTY OF SAN BERNARDINO, DEPT OF PUBLIC WORKS 6,075.00 09/17/2015 245693 EXCEL LANDSCAPE, ICN 12,200.00 09/17/2015 245694 FAIRVIEW FORD SALES,INC 27,976.43 09/17/2015 245695 FERGUSON ENTERPRISES INC 7,165.16 CHECK REGISTER SEPTEMBER 1, 2015 - SEPTEMBER 30, 2015 Page 4 of 10 PAYMENT DATE NUMBER VENDOR NAME AMOUNT 09/17/2015 245696 FLEET METAL BOX CORP 104.70$ 09/17/2015 245697 GARY SCAVONE 167.40 09/17/2015 245698 GOULD ELECTRIC INC 549.86 09/17/2015 245699 HATFIELD BUICK 16.78 09/17/2015 245700 HIGHLAND COMMUNITY NEWS 1,057.69 09/17/2015 245701 HUB CONSTRUCTION SPECIALTIES 117.35 09/17/2015 245702 INLAND WATER WORKS SUPPLY CO 458.99 09/17/2015 245703 INTERMEDIA.NET INC. 1,962.40 09/17/2015 245704 K & L HARDWARE 50.78 09/17/2015 245705 KONICA MINOLTA 323.12 09/17/2015 245706 KONICA MINOLTA BUSINESS 405.06 09/17/2015 245707 LIFECOM 82.30 09/17/2015 245708 NAPA AUTO PARTS /BOSS MOSS 250.97 09/17/2015 245709 PARSONS BRINCKERHOFF, INC 7,773.35 09/17/2015 245710 PILAR ONATE 9,000.00 09/17/2015 245711 POMONA VALLEY WORKSHOP 2,095.00 09/17/2015 245712 SCN, SECURITY COMMUNICATION NETWORK, INC 105.00 09/17/2015 245713 SOUTHERN CALIFORNIA EDISON COMPANY 181,456.24 09/17/2015 245714 STAPLES ADVANTAGE 125.94 09/17/2015 245715 TELEPACIFIC COMMUNICATIONS 2,783.54 09/17/2015 245716 THE B.E.S.T. METER COMPANY, INC 2,325.03 09/17/2015 245717 THE GAS COMPANY 57.29 09/17/2015 245718 UNION BANK, CORPORATE TRUST DIVISION 2,720.00 09/17/2015 245719 UNITED PARCEL SERVICE 114.29 09/17/2015 245720 VERIZON WIRELESS 4,864.14 09/24/2015 245722 SPELLACY PROPERTY MANAGEMENT 25.23 09/24/2015 245723 LISA REGALADO 235.00 09/24/2015 245724 MONICA YANEZ 495.00 09/25/2015 245725 ADP SCREENING 26.13 09/25/2015 245726 AT&T 49.26 09/25/2015 245727 BOOT BARN, INC 250.00 09/25/2015 245728 BRAVO SIGNS & DESIGN, INC 346.32 09/25/2015 245729 BURGESS MOVING & STORAGE 865.63 09/25/2015 245730 CDW GOVERNMENT 349.91 09/25/2015 245731 CHEM-TECH INTERNATIONAL INC 7,472.82 09/25/2015 245732 CITY OF SAN BERNARDINO 238.36 09/25/2015 245733 COUNTY OF SAN BDNO FLEET 442.81 09/25/2015 245734 DENTAL HEALTH SERVICES 529.80 09/25/2015 245735 ECORP CONSULTING, INC 7,800.00 09/25/2015 245736 FAIRVIEW FORD SALES,INC 24,418.91 09/25/2015 245737 FEDERAL EXPRESS 24.62 09/25/2015 245738 FERGUSON ENTERPRISES INC 12,122.31 09/25/2015 245739 FRANCHISE TAX BOARD 36.00 09/25/2015 245740 FRANCHISE TAX BOARD 200.00 09/25/2015 245741 HATFIELD BUICK 17.33 CHECK REGISTER SEPTEMBER 1, 2015 - SEPTEMBER 30, 2015 Page 5 of 10 PAYMENT DATE NUMBER VENDOR NAME AMOUNT 09/25/2015 245742 HERMANOS TEST ONLY 100.00$ 09/25/2015 245743 INLAND WATER WORKS SUPPLY CO 324.75 09/25/2015 245744 K & L HARDWARE 10.79 09/25/2015 245745 KONICA MINOLTA 875.08 09/25/2015 245746 LAWSON PRODUCTS,INC 862.87 09/25/2015 245747 METROPOLITAN LIFE INS CO 162.12 09/25/2015 245748 NAPA AUTO PARTS /BOSS MOSS 245.82 09/25/2015 245749 PARSONS BRINCKERHOFF, INC 720.55 09/25/2015 245750 POMONA VALLEY WORKSHOP 840.00 09/25/2015 245751 PRINCIPAL FINANCIAL GROUP 6,177.47 09/25/2015 245752 REEMA'S DISCOUNT 500.00 09/25/2015 245753 RMC WATER AND ENVIRONMENT 39,780.28 09/25/2015 245754 SAFETY KLEEN CORP 179.46 09/25/2015 245755 SHRED-IT USA 137.70 09/25/2015 245756 STAPLES ADVANTAGE 1,216.84 09/25/2015 245758 STATE WATER RESOURCES CONTROL BOARD, DIVISION OF WAT 466.00 09/25/2015 245759 STATE WATER RESOURCES CONTROL BOARD, DIVISION OF WAT 466.00 09/25/2015 245760 STATE WATER RESOURCES CONTROL BOARD, DIVISION OF WAT 466.00 09/25/2015 245761 SUPER PENNY MARKET 500.00 09/25/2015 245762 THE COMPUTERIZED EMBROIDERY C 7.56 09/25/2015 245763 U.S. BANCORP SERVICE CENTER 22,512.84 09/25/2015 245769 VALERO MARKETING & SUPPLY COMP 11,848.67 09/25/2015 245770 VERIZON CALIFORNIA 743.05 09/30/2015 245772 BOB AND LISA MEYERING 100.00 09/30/2015 245773 CARL CLINE 388.10 09/30/2015 245774 EDWARD MARRAH 2,000.00 09/30/2015 245775 HECTOR GUERRA 150.00 09/30/2015 245776 IMMANUEL BAPTIST CHURCH 150.00 09/30/2015 245777 INGRID RUST 150.00 09/30/2015 245778 IVAN ASKEW 150.00 09/30/2015 245779 JO ANN LIMOGES 988.00 09/30/2015 245780 JOHN AGUIRRE 650.00 09/30/2015 245781 JUANITA ARANDA 1,152.00 09/30/2015 245782 LARRY CHAFIN 150.00 09/30/2015 245783 LAWRENCE OR VIRGINIA VILES 2,500.00 09/30/2015 245784 MARIA HAMILTON 200.00 09/30/2015 245785 MICHAEL HOLSTEIN 89.96 09/30/2015 245786 MICHAEL PHILO 1,232.00 09/30/2015 245787 MICHELLE LENHERT 150.00 09/30/2015 245788 PAMELA EISENHARDT 150.00 09/30/2015 245789 PYONG MANN 1,820.00 09/30/2015 245790 RICHARD HALLER 200.00 09/30/2015 245791 RODNEY REED 30.00 09/30/2015 245792 SHILOH SANDERS 150.00 09/30/2015 245793 TATIANA KARMANOVA 150.00 CHECK REGISTER SEPTEMBER 1, 2015 - SEPTEMBER 30, 2015 Page 6 of 10 PAYMENT DATE NUMBER VENDOR NAME AMOUNT 09/30/2015 245794 TINA FEDRON 300.00$ 09/30/2015 245795 WILLIAM KRUEGER 99.00 09/30/2015 245796 ACCOUNTEMPS 1,374.41 09/30/2015 245797 ADVANCED OFFICE, IMAGING PLUS 379.75 09/30/2015 245798 ARMORCAST 3,839.75 09/30/2015 245799 AT&T 532.36 09/30/2015 245800 CITY OF HIGHLAND 9,400.00 09/30/2015 245801 CITY OF SAN BERNARDINO 2,556.63 09/30/2015 245802 CITY OF SAN BERNARDINO, PUBLIC WORKS DEPT 1,713.60 09/30/2015 245803 COLONIAL LIFE, PREMIUM 360.28 09/30/2015 245804 DIB'S SAFE & LOCK SERVICE 19.00 09/30/2015 245805 EXCEL LANDSCAPE, ICN 213.09 09/30/2015 245806 EXPERIAN 153.20 09/30/2015 245807 FAIRVIEW FORD SALES,INC 338.82 09/30/2015 245808 K & L HARDWARE 30.27 09/30/2015 245809 LAWSON PRODUCTS,INC 230.57 09/30/2015 245810 NAPA AUTO PARTS /BOSS MOSS 46.43 09/30/2015 245811 PETTY CASH 639.58 09/30/2015 245813 POMONA VALLEY WORKSHOP 700.00 09/30/2015 245814 RMC WATER AND ENVIRONMENT 32,433.56 09/30/2015 245815 RONALD C. BRAATZ LIFTOFF, LLC 4,581.60 09/30/2015 245816 SAN BERNARDINO MUNICIPAL WATER DEPARTMENT 631,745.92 09/30/2015 245817 TYLER TECHNOLGIES 5,000.00 09/30/2015 245818 UNION BANK, CORPORATE TRUST DIVISION 105.00 09/30/2015 245819 VALLEY OFFICE EQUIPMENT 296.36 09/30/2015 245820 VERIZON CALIFORNIA 421.36 BANK DRAFTS 09/02/2015 DFT0001184 CALPERS/ MEDICAL 66,966.65$ 09/03/2015 DFT0001193 MERCHANT BANKCD 6,805.49 09/04/2015 DFT0001187 AMEX DISCOUNT 340.04 09/10/2015 DFT0001194 Social Security 375.58 09/10/2015 DFT0001198 TRANSFIRST DISCOUNT 8,517.48 09/11/2015 DFT0001188 CA SDI Tax 1,907.29 09/11/2015 DFT0001189 CALPERS/ DEFERRED COMPENSATION 11,931.94 09/11/2015 DFT0001190 CALPERS/ RETIREMENT 35,625.84 09/11/2015 DFT0001191 Federal Payroll Tax 28,204.84 09/11/2015 DFT0001192 Medicare 6,716.99 09/11/2015 DFT0001195 State Payroll Tax 9,575.81 09/11/2015 DFT0001196 STATE DISBURSEMENT UNIT 3,517.97 09/14/2015 DFT0001197 ACH DIRECT INC, ACH FEES 312.50 09/16/2015 DFT0001210 VERIFONE INC 22.00 09/21/2015 DFT0001214 TRANSFER TO LAIF 1,105,000.00 09/22/2015 DFT0001211 CBB 2,986.99 09/23/2015 DFT0001215 VERIFONE INC 44.00 CHECK REGISTER SEPTEMBER 1, 2015 - SEPTEMBER 30, 2015 Page 7 of 10 PAYMENT DATE NUMBER VENDOR NAME AMOUNT 09/25/2015 DFT0001202 CA SDI Tax 1,781.42$ 09/25/2015 DFT0001203 CALPERS/ DEFERRED COMPENSATION 11,333.87 09/25/2015 DFT0001205 Federal Payroll Tax 26,624.94 09/25/2015 DFT0001206 Medicare 6,311.43 09/25/2015 DFT0001207 Social Security 854.00 09/25/2015 DFT0001208 STATE DISBURSEMENT UNIT 3,248.97 09/25/2015 DFT0001209 State Payroll Tax 8,916.71 09/25/2015 DFT0001212 CALPERS, UAL PAYMENT 32,122.00 09/25/2015 DFT0001213 CALPERS/ RETIREMENT 35,167.54 ACH PAYMENTS 09/03/2015 10000526 #1 SON PLUMBING 1,550.00$ 09/03/2015 10000527 ADS, LLC 1,500.00 09/03/2015 10000528 ADVANCED TELEMETRY SYS INTL 2,660.00 09/03/2015 10000529 AECOM TECHNICAL SERVICES, INC 2,943.50 09/03/2015 10000530 ASHOK K. DHINGRA DBA 10,871.75 09/03/2015 10000531 CLEARFLY COMMUNATIONS 1,325.85 09/03/2015 10000532 CV STRATEGIES 22.00 09/03/2015 10000533 DAVID HERNANDEZ 609.61 09/03/2015 10000534 FRED STAFFORD 570.17 09/03/2015 10000535 G & K SERVICES, INC 477.11 09/03/2015 10000536 G M SAGER CONSTRUCTION CO, INC 3,879.40 09/03/2015 10000537 GARY STURDIVAN 570.17 09/03/2015 10000538 GONZALEZ, QUINTANA & HUNTER, LLC 8,000.00 09/03/2015 10000539 GORDON GRANT 650.00 09/03/2015 10000540 HAAKER EQUIPMENT COMPANY 883.28 09/03/2015 10000541 INDUSTRIAL RUBBER & SUPPLY 27.93 09/03/2015 10000542 JAMES BROWNING 650.00 09/03/2015 10000543 JANA FOX 491.19 09/03/2015 10000544 LESLIE'S POOL SUPPLIES, INC. 35.12 09/03/2015 10000545 MIKE HENDERSON 570.17 09/03/2015 10000546 PACIFIC COAST TOOL & SUPPLY 705.91 09/03/2015 10000547 PSA PRINTING & MAILING SERVICES, INC 434.58 09/03/2015 10000548 RBF CONSULTING, MICHAEL BAKER INTERNATIONAL CO 17,408.00 09/03/2015 10000549 REBECCA KASTEN 650.00 09/03/2015 10000550 SCHUBERT ENTERPRISES INC 450.00 09/03/2015 10000551 STEVEN FARRINGTON 650.00 09/03/2015 10000552 THOMAS P ORTON 358.79 09/03/2015 10000553 UNDERGROUND SERVICE ALERT 121.50 09/03/2015 10000554 US BANCORP, GOVERNMENT LEASING AND FINANCE, INC 228,247.83 09/03/2015 10000555 VISTA PAINTS 132.93 09/03/2015 10000556 VULCAN MATERIALS COMPANY 889.45 09/03/2015 10000557 WATERSMART SOFTWARE, INC 5,000.00 09/03/2015 10000558 WAXIE SANITARY SUPPLY 50.67 09/11/2015 10000559 ADVANCED TELEMETRY SYS INTL 760.00 CHECK REGISTER SEPTEMBER 1, 2015 - SEPTEMBER 30, 2015 Page 8 of 10 PAYMENT DATE NUMBER VENDOR NAME AMOUNT 09/11/2015 10000560 FARMER BROS. CO 262.67$ 09/11/2015 10000561 FSA Only/East Valley Water District 1,428.75 09/11/2015 10000563 G & K SERVICES, INC 507.11 09/11/2015 10000564 INFOSEND, INC 50,477.46 09/11/2015 10000565 SAN BERNARDINO COUNTY RECORDER 672.00 09/17/2015 10000566 AECOM TECHNICAL SERVICES, INC 2,865.00 09/17/2015 10000567 AIRGAS, USA LLC 463.82 09/17/2015 10000568 ARCADIS U.S., INC 5,883.41 09/17/2015 10000569 ASHOK K. DHINGRA DBA 9,828.75 09/17/2015 10000570 BENJAMIN PAK 4,800.00 09/17/2015 10000571 CIHIGOYENETCHE, GROSSBERG & CLOUSE 42,052.36 09/17/2015 10000573 CLIFF'S PEST CONTROL 401.00 09/17/2015 10000574 CLINICAL LAB OF S B 5,160.75 09/17/2015 10000575 CORELOGIC SOLUTIONS INC. 315.00 09/17/2015 10000576 ELEPHANT FIRE EXTINSUISHER 773.19 09/17/2015 10000577 G & K SERVICES, INC 499.11 09/17/2015 10000578 G M SAGER CONSTRUCTION CO, INC 3,899.40 09/17/2015 10000579 ICON ENTERPRISES, INC DBA CIVICPLUS 6,500.00 09/17/2015 10000580 LANDS END INC 242.13 09/17/2015 10000581 LEGEND PUMP AND WELL 95,946.20 09/17/2015 10000582 MILLER SPATIAL SERVICES, LLC 16,270.00 09/17/2015 10000583 MUFG UNION BANK N.A. 277,842.95 09/17/2015 10000584 MUFG UNION BANK, N.A. 48,733.97 09/17/2015 10000585 NETWORK FLEET, INC 99.80 09/17/2015 10000586 P.A.D. PALM AUTO DETAIL 990.00 09/17/2015 10000587 PLUS 1 PERFORMANCE 1,379.92 09/17/2015 10000588 PSA PRINTING & MAILING SERVICES, INC 159.78 09/17/2015 10000589 STUBBIES PROMOTIONS INC 134.34 09/17/2015 10000590 THE WINNER INDUSTRIAL SUPPLY INC 2,846.60 09/17/2015 10000591 VULCAN MATERIALS COMPANY 1,421.04 09/25/2015 10000592 ADCOMP SYSTEMS 7,663.00 09/25/2015 10000593 BENJAMIN PAK 5,120.00 09/25/2015 10000594 CV STRATEGIES 1,015.44 09/25/2015 10000595 FSA Only/East Valley Water District 1,428.75 09/25/2015 10000597 G & K SERVICES, INC 479.11 09/25/2015 10000598 HIGHLAND AREA CHAMBER 100.00 09/25/2015 10000599 LINCOLN NATIONAL LIFE INS CO. 1,178.00 09/25/2015 10000600 LINCOLN NATIONAL LIFE INS CO. 696.58 09/25/2015 10000601 MANAGED HEALTH NETWORK 235.20 09/25/2015 10000602 PITNEY BOWES 255.97 09/25/2015 10000603 PSA PRINTING & MAILING SERVICES, INC 500.03 09/25/2015 10000604 SPECIAL DISTRICT RISK MGMT 16,523.20 09/25/2015 10000606 TROY ALARM, INC. 133.00 09/25/2015 10000607 WAXIE SANITARY SUPPLY 557.20 09/30/2015 10000608 ASHOK K. DHINGRA DBA 8,722.50 CHECK REGISTER SEPTEMBER 1, 2015 - SEPTEMBER 30, 2015 Page 9 of 10 PAYMENT DATE NUMBER VENDOR NAME AMOUNT 09/30/2015 10000609 BUCHALTER NEMER 1,962.80$ 09/30/2015 10000610 ENVIRONMENTAL SCIENCE ASSOCIATES/ESA 73,745.72 09/30/2015 10000611 G & K SERVICES, INC 586.46 09/30/2015 10000612 JOHNSON POWER SYSTEMS 2,748.56 09/30/2015 10000613 JOSE MILLAN 2,000.00 09/30/2015 10000614 LEE & RO, INC. 8,306.96 09/30/2015 10000615 LEGEND PUMP AND WELL 356.00 09/30/2015 10000616 LESLIE'S POOL SUPPLIES, INC. 43.90 09/30/2015 10000617 MUSICK, PEELER & GARRETT LLP 27,326.92 09/30/2015 10000618 OFFICIAL PAYMENTS CORP. 27.65 09/30/2015 10000619 PARKHOUSE TIRE, INC 2,987.18 09/30/2015 10000620 RBF CONSULTING, MICHAEL BAKER INTERNATIONAL CO 9,076.00 09/30/2015 10000621 SCHUBERT ENTERPRISES INC 480.00 09/30/2015 10000622 VULCAN MATERIALS COMPANY 923.40 09/30/2015 10000623 WAGNER & BONSIGNORE 1,728.50 09/30/2015 10000624 WAXIE SANITARY SUPPLY 99.64 TOTAL 4,377,129.59$ CHECK REGISTER SEPTEMBER 1, 2015 - SEPTEMBER 30, 2015 Page 10 of 10 October 28, 2015 Cyber Security Awareness Update 2 NATIONAL CYBER SECURITY AWARENESS MONTH Stop. Think. Connect National Cyber Security Awareness Month •National Cyber Security Awareness Month –Every October •Sponsors –Department of Homeland Security –National Cyber Security Alliance –Multi-State Information Sharing and Analysis Center •Goals –Engage and educate the public and private sector –Raise awareness about cyber security –Increase resiliency of the nation in the event of a cyber incident 3 Common Terminology •Malware = malicious software –Virus, trojan, worm, spyware, ransomware –“zero day” = no known patch (fix) for the malware/attack •Security Incident –Event that compromises the confidentiality, integrity, or availability of an information asset •Data Breach –Incident that resulted in confirmed disclosure to an unauthorized party 4 5 DISTRICT CYBER SECURITY TRAINING You are the Target WHY HACKING EXISTS Type Motives Cyber Criminal (monetary) ID theft, credit card info, extortion (ransomware, DDoS), click-jacking, Point-of-Sales, ATM skimmers Hacktivists Political, ideological, religious, social reasons (Ashley Madison, WikiLeaks, Eric Snowden) Nation State National offense/defense, espionage, sabotage, intellectual property, counterintelligence Cyberwar/Cyber Terrorism Large-scale disruption/destruction of critical systems (Smart Grid, nuclear, water/wastewater, banking, military) 6 CYBER CRIME EXAMPLES 7 2015 DATA BREACH INVESTIGATION REPORT 8 * Verizon 2015 Data Breach Investigations Report ATTACKS ON SCADA SYSTEMS •Springfield, Illinois –Network breach allowed attackers remote access –Hackers controlled a water pump and burned it out •Attack lasted 2-3 months before an operator noticed a “glitch” –Stole credentials •Televent (maker of SCADA software) –Network breach allowed malware install –Customer files affected –Project information stolen (OASyS – remote admin tool) –Televent manages 60% if total hydrocarbon movements in North American and Latin American pipelines •Australian Wastewater Plant (Maroochy Water Services) –SCADA system attacked for 3 months with a laptop, proprietary radio, and homemade cable –140 sewage pumping stations compromised –Sewage spilled into waterways and canals 9 10 EVWD Security Activity Malware and Web Filter Statistics RECENT MALWARE ACTIVITY 11 RECENT MALWARE ACTIVITY 12 WEB FILTER 13 SUMMARY OF OTHER TOPICS –Email is our most common vector for malware •Social Engineering and Phishing Emails –Mobile Devices •Privacy, rogue apps, security practices –Tips and Resources •Managing Passwords •Securing Your Home Network 14 Questions BOARD AGENDA STAFF REPORT Agenda Item #4. Meeting Date: Octo b er 28, 2015 Disc ussion Item T o: G o verning Board Memb ers From: G eneral Manager/CEO Subject: Update on Dis tric t effo rts to implement AWWA Benchmarking P erfo rmanc e Ind icato rs RECOMMENDATION: Informatio n Only. BACKGROUND / ANALYSIS: One o f the General Manager ’s Go als and Ob jectives fo r the 2015 year is to develo p a program to ac hieve o fficial District distinc tio n fo r operatio nal efficiency, transparency, and effective governance. To that end, s taff has as s embled p erfo rmanc e measures us ed in the AWWA’s Utility Benchmarking Pro gram, and is as s es s ing how the d ata for c alc ulating those meas ures c an b e c o mp iled . Discussion The complexity and d ifficulty of calc ulating the different AWWA performanc e measures varies signific antly, fro m us ing year end b alanc es out of rep o rts alread y being p rep ared by staff, to c o llecting and s o rting tho usand s o f d ata inp uts o ver the c o urse of a year. Over the next fo ur months , staff will c omplete the as s es s ment of data c o llectio n, determine which p erfo rmanc e measures c an b e d eveloped fro m exis ting rep o rts and software applic ations , and which may require additional software and/o r staff training. Additional software needs will b e p res ented to the Bo ard at the mid-year bud get review. Some of the less c o mp lex AWWA p erfo rmanc e meas ures for Human R es o urc es , F inance, and Water Productio n have b een c alculated and were inc o rp o rated, alo ng with AWWA b enc hmarks , into the Dis tric t’s final b udget doc ument fo r 2015-16. A c o mp lete lis t of AWWA p erformanc e measures was als o includ ed as Append ix A to the b udget, and is attached to this agenda item. AGENCY IDEALS AND ENDEAVORS: Id eals and End eavor II - Maintain An Environment C o mmitted To Elevated P ublic S ervic e (E) – Practice Trans p arent and Acc o untable F is c al Management Id eals and End eavor IV - F ully Understand C hallenges T o Cultivate Effective S o lutio ns (A) – Support Ongo ing Bus iness Proc es s Imp ro vement FISCAL IMPACT: There is no fis c al imp act assoc iated with this agend a item. Res p ectfully s ubmitted: Rec o mmended b y: Jo hn Mura General Manager / C EO Brian To mp kins Chief F inancial Offic er ATTACHMENTS: Description Type Appendix A - AWWA Perfo rmance Indicators Backup Material EAST VALLEY WATER DISTRICT FISCAL YEAR 2015-2016 213 APPENDIX A AWWA REGION: 4 WESTERN AWWA POPULATION SERVED: 50K - 100K TOP QUARTILE MEDIAN BOTTOM QUARTILE COUNT TOP QUARTILE MEDIAN BOTTOM QUARTILE COUNT ORGANIZATIONAL DEVELOPMENT Organizational Best Practice Index 82 .7%69 .1%57 .3%31 76 .4%61 .8%58 .2%11 Strategic Planning 4 4 3 31 4 4 4 11 Long-Term Financial Planning 5 4 4 31 5 4 4 11 Risk Management Planning 4 3 3 31 3 3 3 11 Performance Measurement System 4 3 3 31 4 3 3 11 Optimized Asset Management Program 4 3 3 31 4 3 2 11 Customer Involvement Program 4 3 2 31 4 3 2 11 Governing Body Transparency and Accountability 5 4 3 31 5 4 4 11 Drought Response/Water Shortage Contingency Plan 5 4 4 27 4 3 3 11 Source Water Protection Plan 5 4 4 27 4 4 3 11 Succession Planning 4 3 2 31 4 3 2 11 Continuous Improvement Program 4 3 2 31 4 3 3 11 FTEs - Total 279 107 38 28 53 44 40 11 Training HR Per Employee- Combined 23 18 13 13 24 20 11 9 Emergency Response Readiness- Combined 2 .2 1 .8 1 .4 9 2 .3 1 .2 0 .9 8 Customer Accounts Per Employee- Combined 586 427 287 15 571 522 449 10 Employee Turnover Rates- Combined 6 .1%7 .1%9 .0%14 2 .8%6 .3%9 .4%9 Retirement Eligibility - Combined 11 .8%22 .1%27 .2%15 10 .5%14 .9%23 .4%10 BUSINESS OPERATIONS Debt Ratio - Combined 13%23%47%15 13%22%68%8 Return on Assets - Combined 2 .6%0 .7%0 .3%15 3 .0%1 .8%0 .6%8 Return on Assets - Water 3 .9%1 .4%0 .3%23 2 .4%1 .7%0 .6%6 Return on Assets - Wastewater 2 .6%1 .4%0 .3%16 3 .6%2 .5%1 .6%5 Cash Reserve Days - Combined 909 375 179 15 858 322 286 8 Cash Reserve Days - Water 656 293 196 22 1373 717 235 6 Cash Reserve Days - Wastewater 657 333 157 14 712 611 492 4 214 AWWA REGION: 4 WESTERN AWWA POPULATION SERVED: 50K - 100K TOP QUARTILE MEDIAN BOTTOM QUARTILE COUNT TOP QUARTILE MEDIAN BOTTOM QUARTILE COUNT Debt-Service Coverage Ratio (Net Operating Income/Total Debt Service)- Combined 3 .33 1 .45 0 .19 15 4 .98 2 .71 1 .16 8 Debt-Service Coverage Ratio (Net Operating Income/Total Debt Service)- Water 2 .9 1 .62 0 .81 21 4 .14 3 .42 2 .68 8 Debt-Service Coverage Ratio (Net Operating Income/Total debt service)- Wastewater 2 .63 1 .25 0 .81 13 2 .47 2 .04 1 .3 5 Operating Ratio (O&M Costs/Total Operating Revenue) - Combined 35%62%80%14 50%59%74%9 Operating Ratio (O&M Costs/Total Operating Revenue) - Water 43%69%88%25 36%57%80%9 Operating Ratio (O&M Costs/Total Operating Revenue) - Wastewater 43%64%71%17 48%62%68%7 System Inspection (%): Water Pipe Network 63%11%2%17 29%11%2%6 System Inspection (%): Wastewater Pipe Network 32%14%8%18 16%6%5%9 System Renewal/Replacement Rate (%): Water Supply 2 .6%1 .2%0 .8%17 4 .2%3 .8%1 .9%8 System Renewal/Replacement Rate (%): Water Treatment Facilities 4 .4%1 .8%0 .6%16 6 .7%1 .0%0 .8%6 System Renewal/Replacement Rate (%): Water Pump Stations 6 .0%2 .8%1 .1%15 4 .7%2 .2%0 .2%6 System Renewal/Replacement Rate (%): Water Transmission and Distribution Pipe Networks 4 .6%2 .0%1 .0%18 3 .2%2 .9%2 .0%8 System Renewal/Replacement Rate (%): Wastewater Collection 3 .9%2 .2%0 .5%13 2 .9%1 .8%0 .9%8 System Renewal/Replacement Rate (%): Wastewater Pump Stations 21 .4%1 .6%0 .5%7 4 .4%3 .7%2 .1%6 System Renewal/Replacement Rate (%): Wastewater Treatment 4 .2%1 .9%1 .1%13 5 .4%5 .4%4 .4%5 Triple Bottom-Line Index 75%53%16%30 65%50%40%11 CUSTOMER SERVICE Customer Compliants Per 1,000 Customers - Customer Service Complaints: Combined 0 .2 1 .4 2 .2 8 1 .5 2 .5 4 .2 4 APPENDIX A EAST VALLEY WATER DISTRICT FISCAL YEAR 2015-2016 215 AWWA REGION: 4 WESTERN AWWA POPULATION SERVED: 50K - 100K TOP QUARTILE MEDIAN BOTTOM QUARTILE COUNT TOP QUARTILE MEDIAN BOTTOM QUARTILE COUNT Customer Compliants per 1,000 Customers - Technical Service Complaints: Combined 0 .4 2 .2 3 .9 9 7 .5 29 .1 41 .9 6 Call-Center Indicators: Average total Call Time (MIN) - Combined 2 .8 3 .2 3 .8 7 1 .5 2 .1 2 .4 5 Call-Center Indicators: Average Wait Time (MIN) - Combined 0 .5 1 1 .8 7 0 .71 0 .93 2 4 Call-Center Indicators: Abandoned Call Ratio - Combined 3 .7%5 .5%10 .5%8 9 .1%14 .6%21 .6%3 Average Time to Address Water Planned Service Disruption (HR)0 1 .7 5 .4 21 0 2 5 .6 8 Average Time to Address Water Unplanned Service Disruption (HR)0 .1 3 .3 20 21 0 1 .5 17 .9 10 Average Time to Address Wastewater Planned Service Disruption (HR) 0 0 7 .2 6 0 0 0 6 Average Time to Address Wastewater Unplanned Service Disruption (HR) 1 .2 5 24 6 2 .5 4 .1 14 .4 7 System Average Disruption Frequency Index (Total Disruptions/ Total Accounts) for Water Systems 0 .06 0 .12 0 .45 21 0 .08 0 .24 0 .41 11 Planned Disruption Frequency Index for Water Systems 0 0 .04 0 .08 21 0 .03 0 .06 0 .22 11 Unplanned Disruption Frequency Index for Water Systems 0 .02 0 .08 0 .18 21 0 .03 0 .07 0 .15 11 System Average Disruption Frequency Index (Total Disruptions/ Total Accounts) for Wastewater Systems 0 0 0 .01 8 0 .02 0 .04 0 .14 8 Planned Disruption Frequency Index for Wastewater Systems 0 0 0 .08 8 0 0 0 8 Unplanned Disruption Frequency Index for Wastewater Systems 0 0 0 .01 8 0 .01 0 .02 0 .06 8 Residential Water Service Charges ($/month) - Bill Amount for Monthly Residential Service for Customer Using 7,500 Gal Per Month $29 .27 $35 .12 $45 .22 28 $20 .28 $25 .15 $44 .22 11 Residential Water Service Charges ($/month) - Average Residential Bill Amount for One Month Service $32 .47 $40 .11 $52 .97 28 $15 .29 $25 .71 $35 .67 11 APPENDIX A 216 AWWA REGION: 4 WESTERN AWWA POPULATION SERVED: 50K - 100K TOP QUARTILE MEDIAN BOTTOM QUARTILE COUNT TOP QUARTILE MEDIAN BOTTOM QUARTILE COUNT Residential Water Service Charges - Average Monthly Usage (gallons)6,674 8,535 10,000 28 4,844 6,000 7,685 11 Residential Wastewater Service Charges ($/month) - Bill Amount for Monthly Residential Service for Customer Using 7,500 Gal Per Month $21 .08 $35 .35 $48 .17 19 $28 .53 $36 .43 $51 .67 10 Residential Wastewater Service Charges ($/month) - Average Residential Bill Amount for One Month Service $18 .88 $32 .67 $42 .42 19 $21 .78 $30 .76 $41 .60 10 Residential Wastewater Service Charges - Average Monthly Flow 4,669 5,218 7,495 18 4,719 5,500 6,000 10 Customer Service Cost Per Account ($) - Combined $20 .71 $31 .68 $46 .01 14 $21 .40 $29 .63 $40 .56 7 Billing Accuracy (Per Bills Generated) - Combined (%)1 .9 5 .6 17 .5 11 2 .6 2 .8 5 .6 5 Total Per Capita Consumption (GPCD) - Water 104 .9 134 .6 182 .9 28 104 .1 120 .5 139 .9 11 Domestic Per Capita Consumption (GPCD)75 .1 89 .3 111 .1 28 60 .2 68 .8 82 .2 9 Service Affordability (%) - Water 0 .67%0 .79%1 .14%27 0 .41%0 .64%0 .80%9 Service Affordability (%)- Wastewater 0 .43%0 .61%0 .76%19 0 .58%0 .82%1 .11%8 Stakeholder Outreach Index (%)92%75%50%29 83%67%58%11 WATER OPERATIONS Drinking Water Compliance Rate (%)100%100%100%28 100%100%100%10 Operational Cost of Potable Water Services ($/Account)$386 $493 $847 27 $213 $393 $616 11 Operational Cost of Potable Water Services ($/MGD)$1,627 $2,355 $3,618 26 $1,225 $2,316 $3,660 9 Operational Cost of Potable Water Services ($/100 miles of pipe)$2,248,267 $3,167,789 $6,781,550 26 $1,418,495 $2,243,870 $3,848,200 11 Treatment O&M Cost of Potable Water Service ($/MG)$71 $392 $675 20 $397 .82 $692 .91 $1,068 .89 6 Distribution O&M Cost of Potable Water Service ($/100 Miles of Pipe)$605,941 $870,395 $1,197,198 20 $393,938 $491,988 $642,487 7 O&M % - Water Supply 10 .2%32 .0%58 .7%18 8 .9%15 .1%29 .3%6 O&M % - Water Treatment 5 .0%12 .7%31 .8%20 24 .3%31 .0%46 .0%7 APPENDIX A EAST VALLEY WATER DISTRICT FISCAL YEAR 2015-2016 217 AWWA REGION: 4 WESTERN AWWA POPULATION SERVED: 50K - 100K TOP QUARTILE MEDIAN BOTTOM QUARTILE COUNT TOP QUARTILE MEDIAN BOTTOM QUARTILE COUNT O&M% - Water Transmission and Distribution 14 .0%26 .6%41 .3%21 24 .3%26 .3%32 .8%7 Million Gallons Per Day (MGD) of Water Delivered Per Employee 0 .34 0 .24 0 .16 28 0 .3 0 .17 0 .14 11 Water Distribution System Integrity (Leaks/100 Miles of Pipe)4 8 17 21 2 4 20 11 Water Distribution System Integrity (Breaks/100 Miles of Pipe)2 7 16 23 3 7 17 11 Planned Maintenance Ratio (% of Total Maintenance) - Water 76%44%22%22 94%58%38%8 Corrective Maintenance to Water Production (HR/MG)0 .5 0 .9 2 .2 22 0 .5 1 .4 2 .9 8 Planned Maintenance to Water Production (HR/MG)2 0 .8 0 .5 22 4 .6 1 .9 1 .3 8 Corrective Maintenance to Water Distribtuion (HR/100 miles)706 1,360 2,090 22 303 1,293 1,936 8 Planned Maintenance to Water Distribtuion (HR/100 miles)2,506 972 374 22 3,847 2,083 1,345 8 Current Water Demand (%)37%61%76%22 25%38%68%10 Available Water Supply (Years)62 37 29 17 56 30 20 8 Energy Consumption Efficiency: Energy Consumption Efficiency for Water (kBtu/yr ./MG) 2,199 4,179 6,462 25 3,783 5,098 10,806 9 WASTEWATER OPERATIONS Regulatory Compliance - Wastewater (%)100%100%100%18 100%100%99 .79%8 Operational Cost of Wastewater Services ($/Account)$256 $315 $573 19 $165 $258 $390 9 Operational Cost of Wastewater Services ($/MGD)$1,776 $2,727 $3,673 18 $1,402 $2,788 $3,798 7 Operational Cost of Wastewater Services ($/100 Miles of pipe)$1,853,513 $2,739,671 $5,242,658 18 $1,668,372 $2,207,265 $2,672,145 9 Collection O&M Cost of Wastewater Service ($/100 miles of pipe)$448,687 $641,469 $2,606,202 14 $515,230 $690,349 $1,055,427 6 Treatment O&M Cost of Wastewater Service $777 $1,455 $1,976 15 $593 $701 $1,811 5 O&M % - Wastewater Collection $0 40 $0 14 20 .10%29 .40%47 .40%6 Sewer Overflows (Overflows/100 Miles of Pipe)0 .6 0 .8 2 14 1 .4 2 .4 12 .5 8 APPENDIX A 218 AWWA REGION: 4 WESTERN AWWA POPULATION SERVED: 50K - 100K TOP QUARTILE MEDIAN BOTTOM QUARTILE COUNT TOP QUARTILE MEDIAN BOTTOM QUARTILE COUNT Collection System Failures (Per 100 Miles of Pipe)1 1 .3 2 .8 12 1 .1 4 .2 23 .2 8 Planned Maintenance Ratio for Wastewater (Planned Maintenance as % of Total Maintenance) 84%62%41%16 87%75%54%8 Corrective Maintenance to Collection (HR/100 Miles)708 1,093 3,672 16 459 935 1,840 8 Planned Maintenance to Collection (HR/100 Miles)4,742 2,657 1,280 16 3,896 2,040 1,405 8 APPENDIX A DROUGHT OCTOBER 28, 2015 UPDATE ON OUR WAY TO 28% 2 Month Total System Reduction January 3% February -8% March 13% April 15% May 33% June 37% July 35% August 27% September 24% CUMULATIVE TOTAL TO DATE 31% Required Reductions to Achieve Cumulative 28% OCTOBER ‘15 26% NOVEMBER ‘15 28% DECEMBER ‘15 28% JANUARY ‘16 28% FEBRUARY ‘16 28% CONSERVATION DASHBOARD •Watering Violations 3 CONSERVATION DASHBOARD •Combined Violations, Consumption and Rebates 4 REBATE PROGRAM •Weather-Based Irrigation Controller –Direct Install Program 5 REBATE PROGRAM •Turf Removal – Funds Committed (Residential & Commercial) •Indoor Rebates •Outdoor Rebates 6 Applications Received Preapprovals Reserved Square Feet Reserved Rebate Dollars Rebates Issued To Date Dollars Remaining 213 197 371,471 $605,315 $137,582 $0 Toilets Showerheads Washers 2014-15 2015-16 2014-15 2015-16 2014-15 2015-16 $50,282.86 $8698.04 $1109.28 $697.96 $9950.00 $1650.00 Landscaping WBIC Sprinkler Nozzles 2014-15 2015-16 2014-15 2015-16 2014-15 2015-16 $7712.09 $7119.95 $4712.68 $81,188.72 $2380.34 $1410.22 2015-16 REBATE PROGRAM TOTALS •Turf Removal (Total Reserved Residential & Commercial) $605,315.00 •WBIC Direct Install (Anthony’s Irrigation) $75,000.00 •SB Schools WBIC (District Contribution) $38,539.75 •Redlands Schools WBIC (District Cost) $40,770.00 •Indoor Rebates (Toilet, Washer, Showerheads) $11,046.00 •Outdoor Rebates (Landscaping, WBIC, Sprinkler Nozzle) $89,718.89 •Rebates To Date $860,389.64 •Valley District Turf Removal Grant (Residential Only) $204,986.50 •TOTAL 2015-16 Rebate Program $655,403.14 7 RECONNECTING WITH THE COMMUNITY 8 •Direct Mail •Print Advertising •Social Media •Specific Targeting –High Users, Leak Detection OUTREACH EFFORTS 9 October 28, 2015 CalPERS Spotlight on Excellence Award Spotlight on Excellence Award •Given to One CalPERS Agency Each Year –3,100 Member Agencies •Recognizes Exemplary Organizations for Innovation and Excellence in Public Service 2 Award Recipients •Given to Agencies With: –A Proven Record of Building Community Success –Serve as a Model for other Agencies or Employees –Exhibit the Spirit of Public Service •Previous Winners Include: –City of Brea (2012) –Alpine Fire Protection District (2013) –City of Lakewood (2014) 3 Spotlight on Excellence Award 4 General Manager/CEO John Mura Accepts Award on Behalf of East Valley Water District with Rob Feckner, President of the CalPERS Board of Administration. Photo Credit: CalPERS Leadership | Partnership | Stewardship •Encouraging water efficiency while maintaining a fair and equitable structure by being the first water agency to receive a grant award from the Santa Ana Watershed Project Authority to assist with the implementation of a budget based rate billing program; •Expanding a surface water treatment plant; •Pledging a commitment to leadership, partnership and stewardship; and •Understanding the need to educate the community on the efforts involved in maintaining a reliable water system. 5 October 28, 2015CalPERSSpotlighton Excellence Award Spotlight on Excellence Award Given to One CalPERS Agency Each Year 3,100 Member Agencies Recognizes Exemplary Organizations for Innovation and Excellence in Public Service 2 Award Recipients Given to Agencies With: A Proven Record of Building Community Success Serve as a Model for other Agencies or Employees Exhibit the Spirit of Public Service Previous Winners Include: City of Brea (2012) Alpine Fire Protection District (2013) City of Lakewood (2014) 3 Spotlight on Excellence Award 4 General Manager/CEO John Mura Accepts Award on Behalf of East Valley Water District with Rob Feckner, President of the CalPERS Board of Administration. Photo Credit: CalPERS Leadership | Partnership | Stewardship Encouraging water efficiency while maintaining a fair and equitable structure by being the first water agency to receive a grant award from the Santa Ana Watershed Project Authority to assist with the implementation of a budget based rate billing program; Expanding a surface water treatment plant; Pledging a commitment to leadership, partnership and stewardship; and Understanding the need to educate the community on the efforts involved in maintaining a reliable water system. 5 October 28, 2015 Cyber Security Awareness Update 2 NATIONAL CYBER SECURITY AWARENESS MONTH Stop. Think. Connect National Cyber Security Awareness Month National Cyber Security Awareness Month Every October Sponsors Department of Homeland Security National Cyber Security Alliance Multi-State Information Sharing and Analysis Center Goals Engage and educate the public and private sector Raise awareness about cyber security Increase resiliency of the nation in the event of a cyber incident 3 Common Terminology Malware = malicious software Virus, trojan, worm, spyware, ransomware zero day” = no known patch (fix) for the malware/attack Security Incident Event that compromises the confidentiality, integrity, or availability of an information asset Data Breach Incident that resulted in confirmed disclosure to an unauthorized party 4 5 DISTRICT CYBER SECURITY TRAINING You are the Target WHY HACKING EXISTS Type Motives Cyber Criminal monetary) ID theft, credit card info, extortion (ransomware, DDoS), click-jacking, Point-of-Sales, ATM skimmers Hacktivists Political, ideological, religious, social reasons Ashley Madison, WikiLeaks, Eric Snowden) Nation State National offense/defense, espionage, sabotage, intellectual property, counterintelligence Cyberwar/Cyber Terrorism Large-scale disruption/destruction of critical systems Smart Grid, nuclear, water/wastewater, banking, military) 6 CYBER CRIME EXAMPLES 7 2015 DATA BREACH INVESTIGATION REPORT 8 * Verizon 2015 Data Breach Investigations Report ATTACKS ON SCADA SYSTEMS Springfield, Illinois Network breach allowed attackers remote access Hackers controlled a water pump and burned it out Attack lasted 2-3 months before an operator noticed a “glitch” Stole credentials Televent (maker of SCADA software) Network breach allowed malware install Customer files affected Project information stolen (OASyS – remote admin tool) Televent manages 60% if total hydrocarbon movements in North American and Latin American pipelines Australian Wastewater Plant (Maroochy Water Services) SCADA system attacked for 3 months with a laptop, proprietary radio, and homemade cable 140 sewage pumping stations compromised Sewage spilled into waterways and canals 9 10 EVWD Security Activity Malware and Web Filter Statistics RECENT MALWARE ACTIVITY 11 RECENT MALWARE ACTIVITY 12 WEB FILTER 13 SUMMARY OF OTHER TOPICS Email is our most common vector for malware Social Engineering and Phishing Emails Mobile Devices Privacy, rogue apps, security practices Tips and Resources Managing Passwords Securing Your Home Network 14 Questions DROUGHT OCTOBER 28, 2015 UPDATE ON OUR WAY TO 28% 2 Month Total System Reduction January 3% February -8% March 13% April 15% May 33% June 37% July 35% August 27% September 24% CUMULATIVE TOTAL TO DATE 31% Required Reductions to Achieve Cumulative 28% OCTOBER ‘15 26% NOVEMBER ‘15 28% DECEMBER ‘15 28% JANUARY ‘16 28% FEBRUARY ‘16 28% CONSERVATION DASHBOARD Watering Violations 3 CONSERVATION DASHBOARD Combined Violations, Consumption and Rebates 4 REBATE PROGRAM Weather-Based Irrigation Controller Direct Install Program 5 REBATE PROGRAM Turf Removal – Funds Committed (Residential & Commercial) Indoor Rebates Outdoor Rebates 6 Applications Received Preapprovals Reserved Square Feet Reserved Rebate Dollars Rebates Issued To Date Dollars Remaining 213 197 371,471 $605,315 $137,582 $0 Toilets Showerheads Washers 2014-15 2015-16 2014-15 2015-16 2014-15 2015-16 50,282.86 $8698.04 $1109.28 $697.96 $9950.00 $1650.00 Landscaping WBIC Sprinkler Nozzles 2014-15 2015-16 2014-15 2015-16 2014-15 2015-16 7712.09 $7119.95 $4712.68 $81,188.72 $2380.34 $1410.22 2015-16 REBATE PROGRAM TOTALS Turf Removal (Total Reserved Residential & Commercial) $605,315.00 WBIC Direct Install (Anthony’s Irrigation) $75,000.00 SB Schools WBIC (District Contribution) $38,539.75 Redlands Schools WBIC (District Cost) $40,770.00 Indoor Rebates (Toilet, Washer, Showerheads) $11,046.00 Outdoor Rebates (Landscaping, WBIC, Sprinkler Nozzle) $89,718.89 Rebates To Date $860,389.64 Valley District Turf Removal Grant (Residential Only) $204,986.50 TOTAL 2015-16 Rebate Program $655,403.14 7 RECONNECTING WITH THE COMMUNITY 8 Direct Mail Print Advertising Social Media Specific Targeting High Users, Leak Detection OUTREACH EFFORTS 9