Loading...
HomeMy WebLinkAboutAgenda Packet - EVWD Board of Directors - 02/28/2018REG ULA R BO A RD MEET IN G February 28, 2018 - 5:30 PM 31111 Greenspot Road, Highland, C A 92346 AGE N D A "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". C A LL TO O RD ER PLED G E O F A LLEG IA N C E RO LL C A LL O F BO A RD MEMBERS P U B L I C C OMME N T S Any person wishing to speak to the Board of Directors is asked to complete a Speaker Card and submit it to the D istrict C lerk 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 C alifornia Brown Act, the Board of Directors is prohibited from discussing or taking action on any item not listed on the posted agenda. T he matter will automatically be referred to staff for an appropriate response or action and may appear on the agenda at a future meeting. AGE N D A - T his 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 2.AP P RO VAL O F C ON SE N T C AL E N D AR All matters listed under the C onsent C alendar are considered by the Board of Directors to be routine and will be enacted in one motion. T here 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.Financial Statements for J anuary 2018 b.J anuary 2018 Disbursements: Accounts payable disbursements for the period include check numbers 251531 through 251742, bank drafts, and A C H Payments in the amount of $2,667,176.32 and $357,323.41 for payroll. D I SC U SSI ON AN D P O SSI B L E AC T I O N I T E MS 3.Revision to Framework Agreement with San Bernardino Valley Municipal Water District 4.C onsider Approval of FY 2017-18 Mid-Year Budget Revisions RE P O RT S 5.Board of Directors' Reports 6.General Manager/C EO Report 7.Legal Counsel Report 8.Board of Directors' Comments AD J O U RN P LEAS E NO T E: Materials related to an item on this agenda s ubmitted to the Board after dis tribution of the agenda packet are availab le fo r pub lic ins p ectio n in the District's o ffic e lo cated at 31111 G reens p o t R d., Highland , during normal bus ines s ho urs. Also, s uc h d o cuments are available on the District's website at www.eastvalley.org subject to staff's ability to pos t the doc uments before the meeting. P urs uant to G overnment C o d e S ec tio n 54954.2(a), any reques t for a d is ab ility-related modific ation or ac commodation, inc luding auxiliary aid s o r s ervic es , that is s o ught in order to p artic ip ate in the above- agendized p ublic meeting s ho uld be d irected to the District C lerk at (909) 885-4900 at leas t 72 ho urs prior to said meeting. B O AR D AGE N D A S TAF F R E P ORT Agenda Item #2.a. Meeting Date: F eb ruary 28, 2018 C ons ent Item To: G o verning Board Memb ers F rom: G eneral Manager/C EO Subject: F inanc ial S tatements fo r January 2018 R E C O MME N D AT IO N: S taff rec ommend s that the Bo ard o f Direc to rs ac cept and file the attac hed financ ial statements as o f, and for the period end ed , January 31, 2018. B AC KGR O UN D / AN ALYS IS : Includ ed herewith fo r the Board’s review is a s ummary o f Eas t Valley Water District’s financ ial results , as of January 31, 2018. AG E N C Y G O ALS AN D OB J E C T IVE S : G o al and O bjec tives I I - Maintain a C ommitment to S us tainab ility, Transparenc y, and Ac c o untability a) P rac tice Trans parent and Ac countab le F is cal Management R E VIE W B Y O T HE R S : R ecommended b y: Jo hn Mura G eneral Manager/C EO R espec tfully sub mitted: Brian Tomp kins C hief F inancial O ffic er F IS C AL IMPAC T T here is no fis cal impac t as s o c iated with this agend a item. R ecommended b y: Jo hn Mura G eneral Manager/C EO R espec tfully sub mitted: Brian Tomp kins C hief F inancial ATTACH M E N TS: Description Type J anuary 2 018 Financ ial Statement M onthly Review Backup Material J anuary 2 018 Financ ial Statements Backup Material FINANCIAL STATEMENTS MONTHLY REVIEW JANUARY 31, 2018   page | 1 The following is a highlight summary of the District’s financial results as of January 31, 2018. Please note all values presented are in millions. Statement of Net Position Total assets at January 31, 2018 are $190.17 million. CLASSIFICATION WATER WASTEWATER DISTRICT TOTAL Cash and Investments $ 17.70 $ 5.26 $ 22.96 Utility Plant, Net 109.63 19.79 129.42 Other Assets 26.33 11.46 37.79 Current Liabilities 5.08 0.27 5.35 Long Term Liabilities 53.55 6.96 60.51 Beginning Net Position 87.55 28.42 115.97 Change in Equity 7.48 0.87 8.35 Total Net Position $ 95.03 $ 29.29 $ 124.32 Below is a summary of the District’s net position as of January 31, 2018. FINANCIAL STATEMENTS MONTHLY REVIEW JANUARY 31, 2018   page | 2 Cash and Investments are $22.96 million for the month of January, an increase of $0.28 million from the prior month. $0 $5 $10 $15 $20 $25 Mi l l i o n s CASH & INVESTMENTS Restricted Unrestricted Comparing current assets to current liabilities, the District has a current ratio at January 31, 2018 of 4.1 to 1, with 2 to 1 being an indication of sound financial condition. FINANCIAL STATEMENTS MONTHLY REVIEW JANUARY 31, 2018   page | 3 Statement of Revenues & Expenses Operating results are presented in three ways in the attached financial statements for the period ending January 31, 2018. 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. Total Revenues & Expenses through January 31, 2018 are summarized below (in millions): WATER WASTEWATER DISTRICT TOTAL Revenue $ 16.90 $ 7.91 $ 24.81 Expense 9.42 7.05 16.47 Water Sales for the month ending January 31, 2018 were $1.37 million or $525K over staff projections for the month and $1.04 million over projections year-to-date. $- $0.5 $1.0 $1.5 $2.0 $2.5 M i l l i o n s Water Sales by Tier Tier 1 Tier 2 Tier 3 FY 2017-18 Projection FINANCIAL STATEMENTS MONTHLY REVIEW JANUARY 31, 2018   page | 4 Water Sales by Customer Class The table below shows the District’s water sales for the month of January 2018 by customer class. All customer classes exceed projections for the month, but Residential and Irrigation represent 77% or $402K of the total change. CUSTOMER CLASS ACTUAL PROJECTION $ CHANGE % CHANGE Residential 761,445$ 474,000$ 287,445$ 61% Multi-Family 314,364 234,000 80,364 34% Commercial 121,725 79,000 42,725 54% Irrigation 176,181 61,000 115,181 189% Total $ 1,373,715 $ 848,000 $ 525,715 62% The following table displays customer class by tier for the month of January 2018. Customer classes noted in bold text represent the top five largest variances over staff projections. CUSTOMER CLASS TIER ACTUAL PROJECTION $ CHANGE % CHANGE Residential Tier 1 348,333$ 291,000$ 57,333$ 20% Residential Tier 2 182,542 59,000 123,542 209% Residential Tier 3 230,570 124,000 106,570 86% Multi-Family Tier 1 147,848 130,000 17,848 14% Multi-Family Tier 2 48,191 24,000 24,191 101% Multi-Family Tier 3 118,325 80,000 38,325 48% Commercial Tier 1 61,775 61,000 775 1% Commercial Tier 2 7,705 7,000 705 10% Commercial Tier 3 52,245 11,000 41,245 375% Irrigation Tier 2 64,661 37,000 27,661 75% Irrigation Tier 3 111,520 24,000 87,520 365% Total $ 1,373,715 $ 848,000 $ 525,715 62% FINANCIAL STATEMENTS MONTHLY REVIEW JANUARY 31, 2018   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 experienced a significant increase over last year, as customers consumed 137.45 million gallons of water (84K HCF) more than January of 2017. $- $0.5 $1.0 $1.5 $2.0 $2.5 1/31/2017 1/31/2018 M i l l i o n s Comparative Monthly Water Revenue (Water Sales & Meter Charge) Meter Tier 1 Tier 2 Tier 3 Total - $1,566,095 Total - $2,120,905 FINANCIAL STATEMENTS MONTHLY REVIEW JANUARY 31, 2018   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 2016-17 and FY 2017-18. FINANCIAL STATEMENTS MONTHLY REVIEW JANUARY 31, 2018   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 2016-17 and FY 2017-18. The largest increases are in Treatment and T & D. Treatment increased $0.33 million compared to last year due to the new Wastewater Treatment rate increases imposed by the City of San Bernardino effective July 1, 2017. T & D increased 34% compared to last year primarily due to a contract for spraying an insecticide for roach control for the District’s manholes from Palm East between the north and south limits of the District, and the other increases were a combination of salary and benefits. All noted increases were anticipated and adopted in the FY 2017-18 Operating Budget. WATER WASTEWATER DISTRICT TOTAL Assets: Current Assets: 01 Cash and Cash Equivalents 9,399,965.58$ 2,591,357.51$ 11,991,323.09$ 02 Investments 3,443,012.71 1,895,786.56 5,338,799.27 03 Accounts Receivable, Net 3,638,194.40 257,451.65 3,895,646.05 04 ‐Interest Receivable 5,951.06 3,377.19 9,328.25 14*05 Other Receivables 419,263.09 - 419,263.09 06 Due from other Governments 115,675.21 - 115,675.21 08 Inventory 279,089.71 6,721.16 285,810.87 09 Prepaid Expenses 208,309.45 18,662.53 226,971.98 17,509,461.21 4,773,356.60 22,282,817.81 Non-Current Assets: 10 Restricted Cash and Cash Equivalents 4,854,650.84 776,145.40 5,630,796.24 11 Capital Assets not being Depreciated 19,147,637.89 10,503,228.97 29,650,866.86 13 Capital Assets, Net 109,628,904.92 19,792,652.93 129,421,557.85 133,631,193.65 31,072,027.30 164,703,220.95 Total Assets:151,140,654.86 35,845,383.90 186,986,038.76 Deferred Outflow Of Resources 24*Deferred Charge on Refunding 138,481.81 - 138,481.81 25 Deferred Outflows - Pensions 2,374,775.29 669,809.71 3,044,585.00 153,653,911.96 36,515,193.61 190,169,105.57 Current Liabilities: 22 Accounts Payable and Accrued Expenses 743,571.68 29,959.97 773,531.65 23 Accrued Payroll and Benefits 2,245.90 - 2,245.90 15 Customer Service Deposits 1,615,860.05 - 1,615,860.05 16 Construction Advances and Retentions 106,000.00 3,500.00 109,500.00 17 Accrued Interest Payable 414,532.39 54,931.25 469,463.64 18 Current Portion of Compensated Absences 262,722.88 60,915.12 323,638.00 19 Current Portion of Long-Term Debt 1,930,404.52 117,958.00 2,048,362.52 5,075,337.42 267,264.34 5,342,601.76 Non-Current Liabilities: 20 Compensated Absences, less current portion (4,278.64) (21,067.87) (25,346.51) 28 Net Pension Liability 7,819,274.72 2,205,437.28 10,024,712.00 21 Long Term Debt, Less Current Portion 45,328,862.18 4,635,698.29 49,964,560.47 27 Other Liabilities 812.95 24,472.02 25,284.97 Deferred Inflows Of Resources 26 Deferred Inflows - Pensions 405,103.37 114,260.63 519,364.00 53,549,774.58 6,958,800.35 60,508,574.93 58,625,112.00 7,226,064.69 65,851,176.69 31 Equity 87,545,567.50 28,423,318.87 115,968,886.37 87,545,567.50 28,423,318.87 115,968,886.37 Tot Total Revenue 16,900,207.93 7,912,085.93 24,812,293.86 Tot Total Expense 9,416,975.47 7,046,275.88 16,463,251.35 7,483,232.46 865,810.05 8,349,042.51 95,028,799.96 29,289,128.92 124,317,928.88 153,653,911.96$ 36,515,193.61$ 190,169,105.57$ 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: Unaudited As of January 31, 2018 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: Page 1 of 8 AMENDED AMENDED AMENDED REMAINING MTD YTD BUDGET MTD YTD BUDGET TOTAL BUDGET BUDGET Revenue 41 Water Sales 1,373,715.08$ 10,928,621.32$ 14,500,000.00$ -$ -$ -$ 14,500,000.00$ 3,571,378.68$ 42 Meter Charges 746,789.72 5,218,504.91 8,845,000.00 - - - 8,845,000.00 3,626,495.09 43 Penalties 56,630.77 365,665.43 445,500.00 4,048.02 26,469.62 40,000.00 485,500.00 93,364.95 44 Wastewater System Charges - - - 386,415.06 2,738,607.46 4,545,000.00 4,545,000.00 1,806,392.54 45 Wastewater Treatment Charges - - - 734,260.80 5,113,296.31 7,900,000.00 7,900,000.00 2,786,703.69 46 Other Operating Revenue 68,022.08 236,668.49 131,500.00 25.00 5,025.00 70,000.00 201,500.00 (40,193.49) 47 Non Operating Revenue 57,003.13 150,747.78 125,000.00 8,522.57 28,687.54 22,000.00 147,000.00 (32,435.32) 48 Gain or Loss on Disposition - - - - - - - - 56 Benefits - - - - - - - - 68 Depreciation - - - - - - - - Revenue Total: 2,302,160.78 16,900,207.93 24,047,000.00 1,133,271.45 7,912,085.93 12,577,000.00 36,624,000.00 11,811,706.14 - - - - - Expense by Category 51 Labor 330,885.24 2,434,334.47 4,768,500.00 99,892.82 701,748.59 1,403,500.00 6,172,000.00 3,035,916.94 56 Benefits 119,755.51 1,413,990.38 2,218,000.00 34,180.56 401,836.17 658,000.00 2,876,000.00 1,060,173.45 63 Contract Services 276,060.11 1,777,945.02 3,513,100.00 772,291.53 5,525,133.24 8,864,900.00 12,378,000.00 5,074,921.74 65 Professional Development 13,758.84 103,580.13 270,300.00 4,698.58 40,794.16 103,700.00 374,000.00 229,625.71 53 Overtime 28,479.57 167,106.13 269,600.00 7,143.89 39,803.46 19,400.00 289,000.00 82,090.41 62 Materials and Supplies 128,309.84 545,213.29 1,120,200.00 6,330.80 66,945.20 121,800.00 1,242,000.00 629,841.51 64 Utilities 263,207.16 1,287,637.25 2,353,800.00 12,058.94 72,137.82 182,200.00 2,536,000.00 1,176,224.93 52 Temporary Labor - 1,814.40 10,500.00 - 777.60 4,500.00 15,000.00 12,408.00 67 Other 8,524.29 200,047.47 260,000.00 3,629.48 83,957.14 111,000.00 371,000.00 86,995.39 54 Standby 3,460.00 19,166.59 38,000.00 960.00 3,280.00 2,000.00 40,000.00 17,553.41 61 Water Supply 601,981.52 602,628.67 801,000.00 - - - 801,000.00 198,371.33 71 -Debt Service - 841,179.67 4,002,000.00 - 109,862.50 313,000.00 4,315,000.00 3,363,957.83 81 -Capital Improvement 75,192.61 136,189.92 3,525,000.00 114,565.11 735,717.05 1,140,000.00 4,665,000.00 3,793,093.03 82 -Capital Outlay 9,231.82 127,020.55 480,000.00 3,956.50 37,999.20 131,000.00 611,000.00 445,980.25 83 -Accounting Income Add back - (240,878.47) - (118,521.61) (773,716.25) - - 1,014,594.72 Expense Total: 1,858,846.51 9,416,975.47 23,630,000.00 941,186.60 7,046,275.88 13,055,000.00 36,685,000.00 20,221,748.65 Total Surplus (Deficit): 443,314.27$ 7,483,232.46$ -$ 192,084.85$ 865,810.05$ -$ -$ -$ Unaudited Revenue and Expense Budget-to-Actual by Category Month Ended January 31, 2018 WATER WASTEWATER DISTRICT WIDE Page 2 of 8 AMENDED AMENDED AMENDED REMAINING MTD YTD BUDGET MTD YTD BUDGET TOTAL BUDGET BUDGET Revenue 41 Water Sales 1,373,715.08$ 10,928,621.32$ 14,500,000.00$ -$ -$ -$ 14,500,000.00$ 3,571,378.68$ 42 Meter Charges 746,789.72 5,218,504.91 8,845,000.00 - - - 8,845,000.00 3,626,495.09 43 Penalties 56,630.77 365,665.43 445,500.00 4,048.02 26,469.62 40,000.00 485,500.00 93,364.95 44 Wastewater System Charges - - - 386,415.06 2,738,607.46 4,545,000.00 4,545,000.00 1,806,392.54 45 Wastewater Treatment Charges - - - 734,260.80 5,113,296.31 7,900,000.00 7,900,000.00 2,786,703.69 46 Other Operating Revenue 68,022.08 236,668.49 131,500.00 25.00 5,025.00 70,000.00 201,500.00 (40,193.49) 47 Non Operating Revenue 57,003.13 150,747.78 125,000.00 8,522.57 28,687.54 22,000.00 147,000.00 (32,435.32) Revenue Total: 2,302,160.78 16,900,207.93 24,047,000.00 1,133,271.45 7,912,085.93 12,577,000.00 36,624,000.00 11,811,706.14 Progra 1000 - Board of Directors 5,582.82 52,978.82 160,300.00 2,511.86 22,112.28 68,700.00 229,000.00 153,908.90 Progra 2000 - General Administration 56,676.88 575,009.63 840,700.00 22,646.99 235,050.71 360,300.00 1,201,000.00 390,939.66 Progra 2100 - Human Resources 27,596.05 371,865.68 591,500.00 11,826.81 158,877.57 253,500.00 845,000.00 314,256.75 Progra 2200 - Public Affairs 28,786.52 180,868.88 414,000.00 27,117.35 178,116.70 414,000.00 828,000.00 469,014.42 Progra 2300 - Conservation 31,139.90 179,593.66 575,000.00 - - - 575,000.00 395,406.34 Progra 3000 - Finance 53,486.56 440,820.20 827,700.00 22,843.75 188,214.42 354,300.00 1,182,000.00 552,965.38 Progra 3200 - Information Technology 31,253.84 326,583.37 674,100.00 13,394.31 139,963.40 288,900.00 963,000.00 496,453.23 Progra 3300 - Customer Service 107,789.84 720,267.39 1,332,600.00 28,178.08 238,444.54 416,400.00 1,749,000.00 790,288.07 Progra 3400 - Meter Service 24,547.09 209,585.74 397,000.00 - - - 397,000.00 187,414.26 Progra 4000 - Engineering 61,802.62 454,216.93 1,068,900.00 20,863.72 178,736.96 458,100.00 1,527,000.00 894,046.11 Progra 5000 - Water Production 877,693.81 2,430,033.65 4,072,000.00 - - - 4,072,000.00 1,641,966.35 Progra 5100 - Water Treatment 100,540.90 508,748.82 990,000.00 - - - 990,000.00 481,251.18 Progra 5200 - Water Quality 30,819.50 208,210.95 410,000.00 - - - 410,000.00 201,789.05 Progra 6000 - Field Maintenance Administration 26,544.46 157,661.56 198,000.00 2,772.60 21,616.15 22,000.00 220,000.00 40,722.29 Progra 6100 - Water Maintenance 214,644.35 1,114,824.99 2,021,000.00 - - - 2,021,000.00 906,175.01 Progra 6200 - Wastewater Maintenance - - - 770,385.09 5,437,216.45 8,593,000.00 8,593,000.00 3,155,783.55 Progra 7000 - Facilities Maintenance 61,159.33 364,412.16 585,800.00 12,203.12 85,264.39 190,200.00 776,000.00 326,323.45 Progra 7100 - Fleet Maintenance 34,056.97 257,781.37 464,400.00 6,442.92 52,799.81 51,600.00 516,000.00 205,418.82 Progra 8000 - Capital 84,424.43 863,511.67 8,007,000.00 - 109,862.50 1,584,000.00 9,591,000.00 7,603,031.11 Total Surplus (Deficit):443,614.91$ 7,483,232.46$ -$ 192,084.85$ 865,810.05$ -$ -$ -$ Revenue and Expense Budget-to-Actual by Program Month Ended January 31, 2018 Unaudited WATER WASTEWATER DISTRICT WIDE Page 3 of 8 AMENDED AMENDED AMENDED REMAINING MTD YTD BUDGET MTD YTD BUDGET TOTAL BUDGET BUDGET Revenue 41 Water Sales 1,373,715.08$ 10,928,621.32$ 14,500,000.00$ -$ -$ -$ 14,500,000.00$ 3,571,378.68$ 42 Meter Charges 746,789.72 5,218,504.91 8,845,000.00 - - - 8,845,000.00 3,626,495.09 43 Penalties 56,630.77 365,665.43 445,500.00 4,048.02 26,469.62 40,000.00 485,500.00 93,364.95 44 Wastewater System Charges - - - 386,415.06 2,738,607.46 4,545,000.00 4,545,000.00 1,806,392.54 45 Wastewater Treatment Charges - - - 734,260.80 5,113,296.31 7,900,000.00 7,900,000.00 2,786,703.69 46 Other Operating Revenue 68,022.08 236,668.49 131,500.00 25.00 5,025.00 70,000.00 201,500.00 (40,193.49) 47 Non Operating Revenue 57,003.13 150,747.78 125,000.00 8,522.57 28,687.54 22,000.00 147,000.00 (32,435.32) 48 Gain or Loss on Disposition - - - - - - - - 56 Benefits - - - - - - - - 68 Depreciation - - - - - - - Revenue Total: 2,302,160.78 16,900,207.93 24,047,000.00 1,133,271.45 7,912,085.93 12,577,000.00 36,624,000.00 11,811,706.14 Program: 1000 - Board of Directors - - - 51 Labor 3,920.00$ 33,687.50$ 73,500.00$ 1,680.00$ 14,437.50$ 31,500.00$ 105,000.00$ 56,875.00$ 56 Benefits 1,568.75 12,709.88 39,900.00 672.33 5,447.11 17,100.00 57,000.00 38,843.01 62 Materials and Supplies 300.64 300.64 700.00 128.85 128.85 300.00 1,000.00 570.51 63 Contract Services - 238.80 7,700.00 - 102.35 3,300.00 11,000.00 10,658.85 65 Professional Development 94.07 6,042.00 38,500.00 30.68 1,996.47 16,500.00 55,000.00 46,961.53 Program: 1000 - Board of Directors Total: 5,883.46 52,978.82 160,300.00 2,511.86 22,112.28 68,700.00 229,000.00 153,908.90 Program: 2000 - General Administration - - - 51 Labor 22,814.65 167,161.84 340,200.00 9,729.19 71,565.80 145,800.00 486,000.00 247,272.36 53 Overtime 89.05 979.57 - 38.17 419.83 - - (1,399.40) 56 Benefits 10,197.77 106,377.12 171,500.00 2,775.89 33,700.24 73,500.00 245,000.00 104,922.64 62 Materials and Supplies 666.95 1,296.56 5,600.00 285.83 555.69 2,400.00 8,000.00 6,147.75 63 Contract Services 16,224.74 248,948.50 242,900.00 6,953.46 107,275.10 104,100.00 347,000.00 (9,223.60) 64 Utilities 86.82 1,183.41 2,100.00 37.21 507.19 900.00 3,000.00 1,309.40 65 Professional Development 6,596.90 49,062.63 78,400.00 2,827.24 21,026.86 33,600.00 112,000.00 41,910.51 Program: 2000 - General Administration Total: 56,676.88 575,009.63 840,700.00 22,646.99 235,050.71 360,300.00 1,201,000.00 390,939.66 Program: 2100 - Human Resources - - - - 51 Labor 10,801.28 78,493.75 147,700.00 4,629.12 33,640.23 63,300.00 211,000.00 98,866.02 52 Temporary Labor - 1,814.40 8,400.00 - 777.60 3,600.00 12,000.00 9,408.00 53 Overtime - 781.42 2,100.00 - 334.89 900.00 3,000.00 1,883.69 56 Benefits 4,655.31 46,307.34 70,000.00 1,995.07 19,352.60 30,000.00 100,000.00 34,340.06 62 Materials and Supplies 170.97 1,091.73 14,000.00 73.27 467.88 6,000.00 20,000.00 18,440.39 63 Contract Services 1,679.89 30,944.93 62,300.00 719.95 13,262.13 26,700.00 89,000.00 44,792.94 64 Utilities 26.61 246.79 700.00 11.40 105.73 300.00 1,000.00 647.48 65 Professional Development 1,793.23 16,275.64 27,300.00 768.52 6,975.27 11,700.00 39,000.00 15,749.09 67 Other 8,468.76 195,909.68 259,000.00 3,629.48 83,961.24 111,000.00 370,000.00 90,129.08 Program: 2100 - Human Resources Total: 27,596.05 371,865.68 591,500.00 11,826.81 158,877.57 253,500.00 845,000.00 314,256.75 Month Ended January 31, 2018 Unaudited Program Expense Detail Budget-to-Actual WATER WASTEWATER DISTRICT WIDE Page 4 of 8 AMENDED AMENDED AMENDED REMAINING MTD YTD BUDGET MTD YTD BUDGET TOTAL BUDGET BUDGET Month Ended January 31, 2018 Unaudited Program Expense Detail Budget-to-Actual WATER WASTEWATER DISTRICT WIDE Program: 2200 - Public Affairs - - - - 51 Labor 12,672.36 82,668.22 173,500.00 12,672.37 81,784.29 173,500.00 347,000.00 182,547.49 52 Temporary Labor - - - - - - - - 53 Overtime - 1,575.76 3,500.00 - 1,575.68 3,500.00 7,000.00 3,848.56 56 Benefits 2,898.95 39,980.33 64,500.00 2,898.24 39,503.25 64,500.00 129,000.00 49,516.42 62 Materials and Supplies 568.37 6,019.79 38,500.00 568.37 6,762.19 38,500.00 77,000.00 64,218.02 63 Contract Services 9,408.30 42,625.01 103,000.00 7,739.85 40,716.55 103,000.00 206,000.00 122,658.44 64 Utilities 2,944.86 3,384.77 17,500.00 2,944.86 3,384.73 17,500.00 35,000.00 28,230.50 65 Professional Development 293.68 4,615.00 13,500.00 293.66 4,390.01 13,500.00 27,000.00 17,994.99 Program: 2200 - Public Affairs Total: 28,786.52 180,868.88 414,000.00 27,117.35 178,116.70 414,000.00 828,000.00 469,014.42 Program: 2300 - Conservation - - - - 51 Labor 9,032.16 54,301.89 98,000.00 - - - 98,000.00 43,698.11 52 Temporary Labor - - - - - - - - 53 Overtime - - 8,000.00 - - - 8,000.00 8,000.00 56 Benefits 2,323.18 26,487.79 32,000.00 - - - 32,000.00 5,512.21 62 Materials and Supplies 8,174.99 82,673.50 223,000.00 - - - 223,000.00 140,326.50 63 Contract Services 11,537.15 13,684.43 187,000.00 - - - 187,000.00 173,315.57 64 Utilities 72.42 435.05 21,000.00 - - - 21,000.00 20,564.95 65 Professional Development - 2,011.00 6,000.00 - - - 6,000.00 3,989.00 Program: 2300 - Conservation Total: 31,139.90 179,593.66 575,000.00 - - - 575,000.00 395,406.34 Program: 3000 - Finance - - - - 51 Labor 34,469.59 240,632.31 474,600.00 14,717.09 102,947.25 203,400.00 678,000.00 334,420.44 52 Temporary Labor - - - - - - - - 53 Overtime 72.50 1,898.07 7,000.00 31.07 813.43 3,000.00 10,000.00 7,288.50 56 Benefits 10,523.03 124,042.86 200,900.00 4,495.42 53,060.63 86,100.00 287,000.00 109,896.51 62 Materials and Supplies - 2,478.69 7,700.00 - 1,062.31 3,300.00 11,000.00 7,459.00 63 Contract Services 7,720.09 64,089.81 116,200.00 3,308.58 27,327.60 49,800.00 166,000.00 74,582.59 64 Utilities 108.98 927.52 2,800.00 46.71 397.50 1,200.00 4,000.00 2,674.98 65 Professional Development 571.37 6,079.94 17,500.00 244.88 2,605.70 7,500.00 25,000.00 16,314.36 67 Other 21.00 671.00 1,000.00 - - - 1,000.00 329.00 Program: 3000 - Finance Total: 53,486.56 440,820.20 827,700.00 22,843.75 188,214.42 354,300.00 1,182,000.00 552,965.38 Program: 3200 - Information Technology - - - - 51 Labor 16,056.32 116,218.72 219,100.00 6,881.28 49,808.07 93,900.00 313,000.00 146,973.21 52 Temporary Labor - - - - - - - - 53 Overtime - - - - - - - - 56 Benefits 4,981.07 56,733.66 90,300.00 2,134.57 24,313.45 38,700.00 129,000.00 47,952.89 62 Materials and Supplies 4,114.69 36,001.68 25,200.00 1,763.43 15,429.28 10,800.00 36,000.00 (15,430.96) 63 Contract Services 5,741.09 111,085.79 323,400.00 2,460.46 47,608.23 138,600.00 462,000.00 303,305.98 64 Utilities 225.57 1,338.59 4,200.00 96.67 573.67 1,800.00 6,000.00 4,087.74 65 Professional Development 135.10 5,204.93 11,900.00 57.90 2,230.70 5,100.00 17,000.00 9,564.37 Program: 3200 - Information Technology Total: 31,253.84 326,583.37 674,100.00 13,394.31 139,963.40 288,900.00 963,000.00 496,453.23 Page 5 of 8 AMENDED AMENDED AMENDED REMAINING MTD YTD BUDGET MTD YTD BUDGET TOTAL BUDGET BUDGET Month Ended January 31, 2018 Unaudited Program Expense Detail Budget-to-Actual WATER WASTEWATER DISTRICT WIDE Program: 3300 - Customer Service - - - - 51 Labor 22,995.85 174,553.17 330,400.00 9,855.37 82,007.67 141,600.00 472,000.00 215,439.16 52 Temporary Labor - - 2,100.00 - - 900.00 3,000.00 3,000.00 53 Overtime 359.92 2,287.66 3,500.00 154.23 988.30 1,500.00 5,000.00 1,724.04 56 Benefits 10,311.89 118,343.42 169,400.00 4,419.09 54,566.79 72,600.00 242,000.00 69,089.79 62 Materials and Supplies 124.38 2,262.29 8,400.00 53.31 969.56 3,600.00 12,000.00 8,768.15 63 Contract Services 62,601.45 368,422.81 696,400.00 8,888.39 78,195.87 144,600.00 841,000.00 394,381.32 64 Utilities 11,217.96 50,398.10 109,900.00 4,807.69 21,599.17 47,100.00 157,000.00 85,002.73 65 Professional Development 143.86 533.15 12,500.00 - 121.28 4,500.00 17,000.00 16,345.57 67 Other 34.53 3,466.79 - - (4.10) - - (3,462.69) Program: 3300 - Customer Service Total: 107,789.84 720,267.39 1,332,600.00 28,178.08 238,444.54 416,400.00 1,749,000.00 790,288.07 Program: 3400 - Meter Service - - - - 51 Labor 16,427.57 118,705.25 228,000.00 - - - 228,000.00 109,294.75 53 Overtime 338.52 3,431.53 20,000.00 - - - 20,000.00 16,568.47 56 Benefits 7,090.03 82,186.12 135,000.00 - - - 135,000.00 52,813.88 62 Materials and Supplies 284.66 1,040.02 4,000.00 - - - 4,000.00 2,959.98 63 Contract Services 318.96 3,789.75 8,000.00 - - - 8,000.00 4,210.25 64 Utilities 87.35 433.07 2,000.00 - - - 2,000.00 1,566.93 65 Professional Development - - - - - - - - Program: 3400 - Meter Service Total: 24,547.09 209,585.74 397,000.00 - - - 397,000.00 187,414.26 Program: 4000 - Engineering - - - - 51 Labor 35,156.25 249,055.04 498,400.00 15,066.95 97,356.24 213,600.00 712,000.00 365,588.72 52 Temporary Labor - - - - - - - - 53 Overtime - 566.98 1,400.00 - 242.96 600.00 2,000.00 1,190.06 56 Benefits 10,105.62 147,268.39 245,000.00 4,330.73 63,113.96 105,000.00 350,000.00 139,617.65 62 Materials and Supplies 190.96 2,064.24 16,800.00 81.85 216.22 7,200.00 24,000.00 21,719.54 63 Contract Services 9,055.91 17,480.57 200,200.00 1,065.39 4,183.92 85,800.00 286,000.00 264,335.51 64 Utilities 7,118.88 34,859.47 86,100.00 243.80 12,956.82 36,900.00 123,000.00 75,183.71 65 Professional Development 175.00 2,922.24 21,000.00 75.00 666.84 9,000.00 30,000.00 26,410.92 Program: 4000 - Engineering Surplus Total: 61,802.62 454,216.93 1,068,900.00 20,863.72 178,736.96 458,100.00 1,527,000.00 894,046.11 Program: 5000 - Water Production - - - - 51 Labor 39,106.50 326,432.73 670,000.00 - - - 670,000.00 343,567.27 53 Overtime 4,543.19 30,947.92 36,000.00 - - - 36,000.00 5,052.08 54 Standby 1,320.00 8,380.00 20,000.00 - - - 20,000.00 11,620.00 56 Benefits 13,870.39 179,595.64 270,000.00 - - - 270,000.00 90,404.36 61 Water Supply 601,981.52 602,628.67 801,000.00 - - - 801,000.00 198,371.33 62 Materials and Supplies 12,112.06 120,495.47 279,000.00 - - - 279,000.00 158,504.53 63 Contract Services 12,517.52 192,754.78 367,000.00 - - - 367,000.00 174,245.22 64 Utilities 191,862.63 964,615.73 1,614,000.00 - - - 1,614,000.00 649,384.27 65 Professional Development 380.00 4,182.71 15,000.00 - - - 15,000.00 10,817.29 Program: 5000 - Water Production Total: 877,693.81 2,430,033.65 4,072,000.00 - - - 4,072,000.00 1,641,966.35 Page 6 of 8 AMENDED AMENDED AMENDED REMAINING MTD YTD BUDGET MTD YTD BUDGET TOTAL BUDGET BUDGET Month Ended January 31, 2018 Unaudited Program Expense Detail Budget-to-Actual WATER WASTEWATER DISTRICT WIDE Program: 5100 - Water Treatment - - - - 51 Labor 16,854.44 122,823.36 237,000.00 - - - 237,000.00 114,176.64 53 Overtime 5,039.95 11,703.41 10,000.00 - - - 10,000.00 (1,703.41) 56 Benefits 5,500.83 63,009.16 92,000.00 - - - 92,000.00 28,990.84 62 Materials and Supplies 25,468.09 71,749.68 165,000.00 - - - 165,000.00 93,250.32 63 Contract Services 24,560.08 164,975.56 286,000.00 - - - 286,000.00 121,024.44 64 Utilities 23,117.51 74,487.65 200,000.00 - - - 200,000.00 125,512.35 Program: 5100 - Water Treatment Total: 100,540.90 508,748.82 990,000.00 - - - 990,000.00 481,251.18 Program: 5200 - Water Quality - - - - 51 Labor 12,761.25 92,392.33 176,000.00 - - - 176,000.00 83,607.67 53 Overtime 849.69 6,015.33 10,000.00 - - - 10,000.00 3,984.67 56 Benefits 3,765.01 47,826.67 76,000.00 - - - 76,000.00 28,173.33 62 Materials and Supplies 2,060.28 7,981.95 18,000.00 - - - 18,000.00 10,018.05 63 Contract Services 11,383.27 53,042.20 120,000.00 - - - 120,000.00 66,957.80 64 Utilities - 844.55 2,000.00 - - - 2,000.00 1,155.45 65 Professional Development - 107.92 8,000.00 - - - 8,000.00 7,892.08 Program: 5200 - Water Quality Total: 30,819.50 208,210.95 410,000.00 - - - 410,000.00 201,789.05 Program: 6000 - Field Maintenance Administration - - - - 51 Labor 12,091.24 70,433.66 102,600.00 811.08 10,373.98 11,400.00 114,000.00 33,192.36 52 Temporary Labor - - - - - - - - 53 Overtime 4,453.31 12,319.37 - 205.29 1,383.83 - - (13,703.20) 54 Standby 2,140.00 10,786.59 18,000.00 960.00 3,280.00 2,000.00 20,000.00 5,933.41 56 Benefits 4,266.48 34,632.72 40,500.00 478.56 5,142.20 4,500.00 45,000.00 5,225.08 62 Materials and Supplies - 16,363.91 2,700.00 - 8.75 300.00 3,000.00 (13,372.66) 63 Contract Services - - - - - - - - 64 Utilities 1,573.00 8,191.54 18,900.00 174.77 910.16 2,100.00 21,000.00 11,898.30 65 Professional Development 2,020.43 4,933.77 15,300.00 142.90 517.23 1,700.00 17,000.00 11,549.00 Program: 6000 - Field Maintenance Administration Total: 26,544.46 157,661.56 198,000.00 2,772.60 21,616.15 22,000.00 220,000.00 40,722.29 Program: 6100 - Water Maintenance - - - - 51 Labor 49,982.33 388,601.30 784,000.00 - - - 784,000.00 395,398.70 53 Overtime 12,733.44 87,809.29 150,000.00 - - - 150,000.00 62,190.71 56 Benefits 21,663.06 258,183.49 417,000.00 - - - 417,000.00 158,816.51 62 Materials and Supplies 66,405.31 144,940.22 221,000.00 - - - 221,000.00 76,059.78 63 Contract Services 53,099.43 201,236.17 449,000.00 - - - 449,000.00 247,763.83 64 Utilities 10,760.78 34,054.52 - - - - - (34,054.52) Program: 6100 - Water Maintenance Total: 214,644.35 1,114,824.99 2,021,000.00 - - - 2,021,000.00 906,175.01 Program: 6200 - Wastewater Maintenance - - - - 51 Labor - - - 20,522.00 137,535.84 280,000.00 280,000.00 142,464.16 53 Overtime - - - 6,715.13 32,309.52 3,000.00 3,000.00 (29,309.52) 56 Benefits - - - 8,711.77 90,715.72 144,000.00 144,000.00 53,284.28 62 Materials and Supplies - - - 18.09 20,855.22 35,000.00 35,000.00 14,144.78 Wastewater Treatment - - - 734,260.80 5,113,296.31 7,610,000.00 7,610,000.00 2,496,703.69 63 Contract Services - - - 157.30 42,503.84 521,000.00 521,000.00 478,496.16 Program: 6200 - Wastewater Maintenance Total:- - - 770,385.09 5,437,216.45 8,593,000.00 8,593,000.00 3,155,783.55 Page 7 of 8 AMENDED AMENDED AMENDED REMAINING MTD YTD BUDGET MTD YTD BUDGET TOTAL BUDGET BUDGET Month Ended January 31, 2018 Unaudited Program Expense Detail Budget-to-Actual WATER WASTEWATER DISTRICT WIDE Program: 7000 - Facilities Maintenance - - - - 51 Labor 4,974.20 40,061.98 67,900.00 2,131.80 11,612.85 29,100.00 97,000.00 45,325.17 53 Overtime - 6,808.10 17,500.00 - 1,985.12 7,500.00 25,000.00 16,206.78 56 Benefits 1,885.39 22,146.20 30,800.00 808.06 7,321.83 13,200.00 44,000.00 14,531.97 62 Materials and Supplies 3,671.08 18,330.33 33,900.00 618.55 6,330.56 8,100.00 42,000.00 17,339.11 63 Contract Services 43,727.18 215,519.16 276,500.00 5,653.02 31,858.42 70,500.00 347,000.00 99,622.42 64 Utilities 6,901.48 61,546.39 159,200.00 2,906.69 26,070.61 61,800.00 221,000.00 133,383.00 65 Professional Development - - - 85.00 85.00 - - (85.00) Program: 7000 - Facilities Maintenance Total: 61,159.33 364,412.16 585,800.00 12,203.12 85,264.39 190,200.00 776,000.00 326,323.45 - - - - Program: 7100 - Fleet Maintenance - - - - 51 Labor 10,769.25 78,111.42 147,600.00 1,196.57 8,678.87 16,400.00 164,000.00 77,209.71 53 Overtime - 763.14 2,700.00 - 84.79 300.00 3,000.00 2,152.07 56 Benefits 4,148.75 47,378.17 71,100.00 460.83 5,263.50 7,900.00 79,000.00 26,358.33 62 Materials and Supplies 3,996.41 30,122.59 56,700.00 2,739.25 14,158.69 6,300.00 63,000.00 18,718.72 63 Contract Services 6,485.05 49,106.75 67,500.00 1,084.33 18,802.92 7,500.00 75,000.00 7,090.33 64 Utilities 7,102.31 50,690.10 113,400.00 789.14 5,632.24 12,600.00 126,000.00 69,677.66 65 Professional Development 1,555.20 1,609.20 5,400.00 172.80 178.80 600.00 6,000.00 4,212.00 Program: 7100 - Fleet Maintenance Total: 34,056.97 257,781.37 464,400.00 6,442.92 52,799.81 51,600.00 516,000.00 205,418.82 - - - Program: 8000 - Capital - - - 71 -Debt Service - 841,179.67 4,002,000.00 - 109,862.50 313,000.00 4,315,000.00 3,363,957.83 81 -Capital Improvement 75,192.61 136,189.92 3,525,000.00 114,565.11 735,717.05 1,140,000.00 4,665,000.00 3,793,093.03 82 -Capital Outlay 9,231.82 127,020.55 480,000.00 3,956.50 37,999.20 131,000.00 611,000.00 445,980.25 83 -Accounting Income Add back (84,424.43) (240,878.47) - (118,521.61) (773,716.25) - - 1,014,594.72 Program: 8000 - Capital Total: - 863,511.67 8,007,000.00 - 109,862.50 1,584,000.00 9,591,000.00 8,617,625.83 Total Surplus (Deficit): 527,738.70$ 7,483,232.46$ -$ 192,084.85$ 865,810.05$ -$ -$ -$ Page 8 of 8 B O AR D AGE N D A S TAF F R E P ORT Agenda Item #2.b . Meeting Date: F eb ruary 28, 2018 C ons ent Item To: G o verning Board Memb ers F rom: G eneral Manager/C EO Subject: January 2018 Dis bursements : Acc o unts p ayab le dis bursements fo r the period includ e c heck numbers 251531 through 251742, b ank drafts, and AC H P ayments in the amo unt of $2,667,176.32 and $357,323.41 fo r p ayroll. R E C O MME N D AT IO N: S taff rec ommend s that the Bo ard o f Direc to rs review and approve the Distric t’s expens e d is b ursements for the period January 1, 2018 thro ugh January 31, 2018 in the amount of $3,024,499.73. B AC KGR O UN D / AN ALYS IS : In the continued effo rt to b e fis cally trans p arent, the p ayment register fo r s upplies , materials , services , and p ayroll for January 2018 is attached fo r review and ap proval. T his p ro cess provides the Bo ard and the p ublic an o p p o rtunity to review the exp enses of the Dis tric t. Acc o unts P ayable is p ro cess ed weekly, while p ayroll is p ro ces s ed bi-weekly. Info rmation to justify eac h expenditure is available thro ugh the F inanc e Department. Acc o unts payab le dis b ursements for the perio d includ e check numb ers 251531 through 251742, b ank d rafts, and AC H P ayments in the amount o f $2,667,176.32 and $357,323.41 fo r payroll. S ignific ant expens es greater than o r equal to $50,000 are further exp lained below: R ecommended b y: Jo hn Mura G eneral Manager/C EO R espec tfully sub mitted: Brian Tomp kins C hief F inancial O ffic er AG E N C Y G O ALS AN D OB J E C T IVE S : G o al and O bjec tives I I - Maintain a C ommitment to S us tainab ility, Transparenc y, and Ac c o untability a) P rac tice Trans parent and Ac countab le F is cal Management R E VIE W B Y O T HE R S : T his agenda item has been reviewed by the F inanc e Dep artment. F IS C AL IMPAC T S ufficient funds have b een b udgeted in the adopted F Y 2017-18 Bud get. ATTACH M E N TS: Description Type J anuary 2 018 P ayment Register Backup Material PAYMENT REGISTER JANUARY 1, 2018 - JANUARY 31, 2018 PAYMENT DATE NUMBER VENDOR NAME AMOUNT 1/3/2018 251531 SANIYYAH NASIR 11.39 1/3/2018 251532 RICHARD ANHAEUSER 56.49 1/3/2018 251533 KENNETH BATEMAN 100.00 1/3/2018 251534 MARIA CONTRERAS 650.00 1/3/2018 251535 NOEMI RODRIGUEZ 11.13 1/3/2018 251536 Conservice REO Utilities 202.69 1/3/2018 251537 DDD REALITY INV 2,500.00 1/3/2018 251538 Conservice REO Utilities 120.19 1/4/2018 251539 ALSO ENERGY INC. 6,570.00 1/4/2018 251540 ANTHESIS (FORMERLY POMONA VALLEY WORKSHOP) 2,107.38 1/4/2018 251541 AT&T 768.26 1/4/2018 251542 BURRTEC WASTE (GROUP) INDUSTRIES, INC. 238.36 1/4/2018 251543 CALGON CARBON CORPORATION 269.38 1/4/2018 251544 CALOLYMPIC SAFETY 106.07 1/4/2018 251545 CHEM-TECH INTERNATIONAL INC 1,633.04 1/4/2018 251546 CINTAS CORPORATION (UNIFORMS) 2,060.53 1/4/2018 251548 CITY OF HIGHLAND 4,590.00 1/4/2018 251549 COAST FITNESS REPAIR SHOP 250.00 1/4/2018 251550 CSR AIR CONDITIONING & HEATING 1,979.55 1/4/2018 251551 DANIELS TIRE SERVICE, INC 2,231.66 1/4/2018 251552 DENTAL HEALTH SERVICES 303.80 1/4/2018 251553 DIB'S SAFE & LOCK SERVICE 198.72 1/4/2018 251554 DINO PERUGINO, COMMERCIAL TRANSPORTATION SERVICES 390.00 1/4/2018 251555 DIRECTV 242.97 1/4/2018 251556 DLT SOLUTIONS, LLC 3,551.30 1/4/2018 251557 DONEGAN TREE SERVICE 200.00 1/4/2018 251558 EYE MED VISION CARE 1,247.64 1/4/2018 251559 FRONTIER COMMUNICATIONS 480.87 1/4/2018 251560 GARY YOUNG 480.29 1/4/2018 251561 HATFIELD BUICK 215.69 1/4/2018 251562 HENRY SOWLE 480.29 1/4/2018 251563 IEPMA-HR 25.00 1/4/2018 251564 INLAND WATER WORKS SUPPLY CO 284.04 1/4/2018 251565 K & L HARDWARE 72.76 1/4/2018 251566 KONICA MINOLTA 721.31 1/4/2018 251567 METROPOLITAN LIFE INS CO 150.87 1/4/2018 251568 MICHAEL REARDON 527.17 1/4/2018 251569 MITCHELL1 1,728.00 1/4/2018 251570 NAPA AUTO PARTS 129.29 1/4/2018 251571 PHOENIX LIFE INSURANCE COMPANY 66.74 1/4/2018 251572 RMC WATER AND ENVIRONMENT 43,168.51 1/4/2018 251573 SCN, SECURITY COMMUNICATION NETWORK, INC 105.00 1/4/2018 251574 SO CAL GAS 376.35 1/4/2018 251575 STAPLES BUSINESS ADVANTAGE 832.77 PAYMENT REGISTER JANUARY 1, 2018 - JANUARY 31, 2018 Page 1 of 8 PAYMENT DATE NUMBER VENDOR NAME AMOUNT 1/4/2018 251576 SUPERIO EPOXY 5,840.00 1/4/2018 251577 SWRCB 52,243.15 1/4/2018 251578 VALLEY OFFICE EQUIPMENT 3.55 1/10/2018 251579 ALEJANDRA OCHOA 61.09 1/10/2018 251580 JOHN CLAIRMONT 88.74 1/10/2018 251581 STEVEN QIN 89.19 1/10/2018 251582 JUAN FLORES 45.06 1/10/2018 251583 SANCON ENGINEERING 1,800.00 1/10/2018 251584 STEPHANIE TRAN 38.70 1/10/2018 251585 JAMES WINDISH 73.89 1/10/2018 251586 RAMZI GHAZALEH 57.01 1/10/2018 251587 MAGDA REY SANCHEZ 535.02 1/11/2018 251588 APPLIED BEST PRACTICES, LLC 1,500.00 1/11/2018 251589 ASBCSD 74.00 1/11/2018 251590 BRADEN HEYWOOD DBA GENESIS INDUSTRIAL SUPPLY 539.03 1/11/2018 251591 BURRTEC WASTE (GROUP) INDUSTRIES, INC. 738.50 1/11/2018 251592 CHEM-TECH INTERNATIONAL INC 1,337.12 1/11/2018 251593 CINTAS CORPORATION (UNIFORMS) 1,804.92 1/11/2018 251595 CITY OF SAN BERNARDINO, PUBLIC WORKS DEPT 1,682.94 1/11/2018 251596 COLONIAL LIFE, PREMIUM 792.10 1/11/2018 251597 CULLIGAN OF ONTARIO 52.00 1/11/2018 251598 EILEEN BATEMAN 178.51 1/11/2018 251599 EVERSOFT, INC 409.24 1/11/2018 251600 EXPERIAN 560.16 1/11/2018 251601 FIRST CHOICE SERVICES 349.46 1/11/2018 251602 FRONTIER COMMUNICATIONS 105.54 1/11/2018 251603 HACH COMPANY 921.02 1/11/2018 251604 HATFIELD BUICK 149.45 1/11/2018 251605 HOPKINS TECHNICAL PRODUCTS INC 3,914.52 1/11/2018 251606 INFO-TECH RESEARCH GROUP, INC 5,743.07 1/11/2018 251607 INLAND WATER WORKS SUPPLY CO 1,436.56 1/11/2018 251608 K & L HARDWARE 166.86 1/11/2018 251609 KELLY ASSOCIATES MANAGEMENT GROUP LLC 940.00 1/11/2018 251610 SAN BERNARDINO MUNICIPAL WATER DEPARTMENT 17,054.81 1/11/2018 251611 SHIELA BOYD 15.67 1/11/2018 251612 SOUTHERN CALIF OCCUPATIONAL HEALTH SERVICES 340.00 1/11/2018 251613 SOUTHERN CALIFORNIA EDISON COMPANY 27.80 1/11/2018 251614 STAPLES BUSINESS ADVANTAGE 441.78 1/11/2018 251615 VALERO MARKETING & SUPPLY COMP 7,395.30 1/17/2018 251616 AMAZON.COM, LLC 1,783.31 1/17/2018 251617 BRADEN HEYWOOD DBA GENESIS INDUSTRIAL SUPPLY 289.97 1/17/2018 251618 CITY OF SAN BERNARDINO MUNICIPAL WATER DEPT(TRUNK CHARGES) 4,426.18 1/17/2018 251619 FAIRVIEW FORD SALES,INC 233.45 1/17/2018 251620 FRONTIER COMMUNICATIONS 905.61 1/17/2018 251621 HUB CONSTRUCTION SPECIALTIES 291.60 1/17/2018 251622 INLAND DESERT SECURITY & COMMUNICATIONS, INC 617.70 1/17/2018 251623 K & L HARDWARE 22.36 1/17/2018 251624 KONICA MINOLTA 495.57 1/17/2018 251625 PATRICIA A. JOHNSON 83.00 1/17/2018 251626 PETTY CASH 938.25 1/17/2018 251627 RONALD C. BRAATZ, LIFTOFF, LLC 418.00 1/17/2018 251628 SAN BERNARDINO MUNICIPAL WATER DEPARTMENT 682,588.78 PAYMENT REGISTER JANUARY 1, 2018 - JANUARY 31, 2018 Page 2 of 8 PAYMENT DATE NUMBER VENDOR NAME AMOUNT 1/17/2018 251629 SANCON ENGINEERING, INC. 60,638.50 1/17/2018 251630 SOUTHERN CALIFORNIA EDISON COMPANY 144,186.37 1/18/2018 251631 ALLIED PACIFIC PROPERTY 150.00 1/18/2018 251632 INNOVATIVE MARKETING TECHNIQUES 100.90 1/18/2018 251633 ANTHONY JACKSON 100.00 1/18/2018 251634 BASELINE TRUST 92.32 1/18/2018 251635 ROBERT LEOTAUD 15.21 1/18/2018 251636 JONATHAN BAHARVAR 130.49 1/18/2018 251637 JOSHUA MONTOYA 439.13 1/18/2018 251638 MORGAN PICKS TWO, LLC 52.84 1/18/2018 251639 CHE-CHENG CHENG 42.77 1/18/2018 251640 NEJAT MIRHAROONI 39.86 1/18/2018 251641 SONIA SALGADO 141.08 1/18/2018 251642 CHI ZHANG 104.09 1/18/2018 251643 MICHELLE MORENO 47.31 1/18/2018 251644 THUAN H NGUYEN 68.52 1/18/2018 251645 MOHAMMAD TWEINI 150.00 1/24/2018 251646 CLAASIC, LLC 131.41 1/24/2018 251647 DP BASELINE INVESTMENTS 219.88 1/24/2018 251648 PATRICIA MURRAY 107.92 1/24/2018 251649 JUSTIN WAN 460.06 1/24/2018 251650 JUSTIN WAN 412.25 1/24/2018 251651 INLAND MAPLE PARTNERS, LLC 92.55 1/24/2018 251652 ARIANA CESANA 75.33 1/24/2018 251653 BILL & SHARON WHITE 12.06 1/24/2018 251654 AM-PM MANAGEMENT INC 128.15 1/24/2018 251655 SUSAN CLARK 470.00 1/24/2018 251656 Celina Hernandez 100.00 1/24/2018 251657 SHI Z WANG 116.40 1/24/2018 251658 Brad Barnes 74.99 1/24/2018 251659 Dan Perkins 200.00 1/24/2018 251660 ERIC BREWER 150.00 1/24/2018 251661 Mike Sellas 200.00 1/24/2018 251662 Reginald Sellas 200.00 1/24/2018 251663 Robert Patterson 300.00 1/25/2018 251664 TRACTOR SUPPLY CO. 1,976.82 1/25/2018 251665 ANTHESIS (FORMERLY POMONA VALLEY WORKSHOP) 1,914.75 1/25/2018 251666 AT&T 49.56 1/25/2018 251667 BRADEN HEYWOOD DBA GENESIS INDUSTRIAL SUPPLY 583.40 1/25/2018 251668 BURGESS MOVING & STORAGE 1,500.30 1/25/2018 251669 CINTAS CORPORATION (UNIFORMS) 815.41 1/25/2018 251671 CITY OF SAN BERNARDINO, PUBLIC WORKS DEPT 4,487.84 1/25/2018 251672 COUNTY OF SAN BERNARDINO, DEPT OF PUBLIC WORKS 1,350.00 1/25/2018 251673 DANIELS TIRE SERVICE, INC 1,179.64 1/25/2018 251674 FAIRVIEW FORD SALES,INC 73.02 1/25/2018 251675 FEDERAL EXPRESS CORPORATION 177.11 1/25/2018 251676 FLEET MANAGEMENT DEPARTMENT 442.21 1/25/2018 251677 FRONTIER COMMUNICATIONS 426.95 1/25/2018 251678 HACH COMPANY 674.47 1/25/2018 251679 HUB CONSTRUCTION SPECIALTIES 320.31 1/25/2018 251680 INLAND WATER WORKS SUPPLY CO 915.35 1/25/2018 251681 METROPOLITAN LIFE INS CO 150.87 1/25/2018 251682 MILESTONE TROPHIES & AWARDS 93.31 PAYMENT REGISTER JANUARY 1, 2018 - JANUARY 31, 2018 Page 3 of 8 PAYMENT DATE NUMBER VENDOR NAME AMOUNT 1/25/2018 251683 NAPA AUTO PARTS 280.51 1/25/2018 251684 PATTON'S SALES CORP 10.63 1/25/2018 251685 PETTY CASH 445.94 1/25/2018 251686 PHOENIX LIFE INSURANCE COMPANY 66.74 1/25/2018 251687 SAN BDNO CO FIRE PROTECTION 5,200.00 1/25/2018 251689 SAN BERNARDINO VALLEY WATER CONSERVATION DISTRICT 102,052.32 1/25/2018 251690 SO CAL GAS 15.29 1/25/2018 251691 SOUTH COAST A Q M D 505.74 1/25/2018 251692 SOUTHERN CALIFORNIA EDISON COMPANY 21,274.07 1/25/2018 251693 STRADLING YOCCA CARSON & RAUTH, A PROFESSIONAL 9,184.50 1/25/2018 251694 TYLER TECHNOLGIES 440.00 1/25/2018 251695 U.S. BANCORP SERVICE CENTER 19,890.86 1/25/2018 251700 UNITED PARCEL SERVICE, INC. 26.38 1/25/2018 251701 VCES CORONA 191.49 1/30/2018 251702 Fabrizio Pauri 96.49 1/31/2018 251703 MICHAEL ABBOTT 49.44 1/31/2018 251704 DIONICIO HERNANDEZ 1.52 1/31/2018 251705 WATER STREET LAND LLC 113.59 1/31/2018 251706 WATER STREET LAND LLC 86.46 1/31/2018 251707 WATER STREET LAND LLC 113.45 1/31/2018 251708 WATER STREET LAND LLC 93.79 1/31/2018 251709 EAST VALLEY WATER DISTRICT 177.23 1/31/2018 251710 ROSEMARIE & JOSE MATEO 100.00 1/31/2018 251711 ADP SCREENING 86.39 1/31/2018 251712 AMERICAN WATER WORKS ASSOCIATION 4,022.00 1/31/2018 251713 AT&T 769.03 1/31/2018 251714 CHEM-TECH INTERNATIONAL INC 23,856.72 1/31/2018 251715 CINTAS CORPORATION (UNIFORMS) 636.29 1/31/2018 251716 CITY OF HIGHLAND 300.00 1/31/2018 251717 CLA-VAL CO 2,935.10 1/31/2018 251718 COLONIAL LIFE, PREMIUM 792.10 1/31/2018 251719 DENTAL HEALTH SERVICES 303.80 1/31/2018 251720 DIRECTV 250.97 1/31/2018 251721 EVERSOFT, INC 207.69 1/31/2018 251722 FRONTIER COMMUNICATIONS 54.70 1/31/2018 251723 HACH COMPANY 8,247.00 1/31/2018 251724 HATFIELD BUICK 520.27 1/31/2018 251725 HIGHLAND COMMUNITY NEWS 1,065.75 1/31/2018 251726 HUB CONSTRUCTION SPECIALTIES 949.26 1/31/2018 251727 IDEA HALL 8,486.85 1/31/2018 251728 INLAND WATER WORKS SUPPLY CO 3,051.00 1/31/2018 251729 K & L HARDWARE 83.36 1/31/2018 251730 LIEBERT CASSIDY WHITMORE LCW 35.00 1/31/2018 251731 MORTON SALT, INC. 2,739.84 1/31/2018 251732 NAPA AUTO PARTS 246.73 1/31/2018 251733 ROSEMOUNT ANALYTICAL, INC 3,400.00 1/31/2018 251734 SERGIO D. FIERRO 1,500.00 1/31/2018 251735 SO CAL GAS 466.15 1/31/2018 251736 SOUTHERN CALIF OCCUPATIONAL HEALTH SERVICES 275.00 1/31/2018 251737 STAPLES BUSINESS ADVANTAGE 95.52 1/31/2018 251738 THE PRESS ENTERPRISE 202.14 1/31/2018 251739 THE QUINTANA CRUZ COMPANY, LLC 4,000.00 1/31/2018 251740 VALLEY OFFICE EQUIPMENT 50.00 PAYMENT REGISTER JANUARY 1, 2018 - JANUARY 31, 2018 Page 4 of 8 PAYMENT DATE NUMBER VENDOR NAME AMOUNT 1/31/2018 251741 WEST VALLEY WATER DISTRICT 2,500.00 1/31/2018 251742 US POSTAL SERVICE 5,673.85 BANK DRAFTS 1/2/2018 DFT0002488 CALPERS/ MEDICAL 88,569.19 1/3/2018 DFT0002490 MERCHANT BANKCD 304.71 1/5/2018 DFT0002491 PayNearMe, Inc. 91.54 1/10/2018 DFT0002497 STATE DISBURSEMENT UNIT 2,442.47 1/10/2018 DFT0002502 CALPERS/ DEFERRED COMPENSATION 68,481.27 1/10/2018 DFT0002503 CALPERS/ RETIREMENT 18,323.72 1/10/2018 DFT0002504 CALPERS/ RETIREMENT 60.45 1/10/2018 DFT0002505 CALPERS/ RETIREMENT 153.05 1/10/2018 DFT0002506 CALPERS/ RETIREMENT 12,047.91 1/10/2018 DFT0002507 CALPERS/ RETIREMENT 3,651.37 1/10/2018 DFT0002508 CALPERS/ RETIREMENT 230.02 1/10/2018 DFT0002509 CALPERS/ RETIREMENT 824.38 1/10/2018 DFT0002510 CALPERS/ RETIREMENT 3,721.61 1/10/2018 DFT0002516 FORTE, ACH DIRECT INC, ACH FEES 5,805.13 1/10/2018 DFT0002518 TRANSFIRST DISCOUNT 11,743.51 1/12/2018 DFT0002496 State Payroll Tax 10,298.17 1/12/2018 DFT0002498 Social Security 181.04 1/12/2018 DFT0002499 Medicare 7,648.84 1/12/2018 DFT0002500 Federal Payroll Tax 31,139.10 1/12/2018 DFT0002501 CA SDI Tax 2,909.97 1/12/2018 DFT0002540 CBB 15.00 1/16/2018 DFT0002517 PayNearMe, Inc. 370.14 1/17/2018 DFT0002539 VERIFONE INC 22.00 1/19/2018 DFT0002512 CA SDI Tax 185.48 1/19/2018 DFT0002513 Federal Payroll Tax 3,196.20 1/19/2018 DFT0002514 Medicare 597.68 1/19/2018 DFT0002515 State Payroll Tax 1,457.08 1/23/2018 DFT0002535 CBB 2,425.25 1/23/2018 DFT0002537 STATE BOARD OF EQUALIZATION 1,154.00 1/23/2018 DFT0002538 VERIFONE INC 44.00 1/24/2018 DFT0002521 STATE DISBURSEMENT UNIT 2,442.47 1/24/2018 DFT0002526 CALPERS/ DEFERRED COMPENSATION 16,006.81 1/24/2018 DFT0002527 CALPERS/ RETIREMENT 3,651.37 1/24/2018 DFT0002528 CALPERS/ RETIREMENT 18,236.76 1/24/2018 DFT0002529 CALPERS/ RETIREMENT 230.02 1/24/2018 DFT0002530 CALPERS/ RETIREMENT 60.45 1/24/2018 DFT0002531 CALPERS/ RETIREMENT 153.05 1/24/2018 DFT0002532 CALPERS/ RETIREMENT 11,986.82 1/24/2018 DFT0002533 CALPERS/ RETIREMENT 3,721.61 1/24/2018 DFT0002534 CALPERS/ RETIREMENT 824.38 1/24/2018 DFT0002536 PayNearMe, Inc. 300.49 1/26/2018 DFT0002520 State Payroll Tax 9,532.88 1/26/2018 DFT0002522 Social Security 856.30 1/26/2018 DFT0002523 Medicare 6,624.86 1/26/2018 DFT0002524 Federal Payroll Tax 29,567.90 1/26/2018 DFT0002525 CA SDI Tax 2,334.74 1/31/2018 DFT0002541 PayNearMe, Inc. 199.00 ACH PAYMENTS PAYMENT REGISTER JANUARY 1, 2018 - JANUARY 31, 2018 Page 5 of 8 PAYMENT DATE NUMBER VENDOR NAME AMOUNT 1/4/2018 10003615 ADCOMP SYSTEMS 319.29 1/4/2018 10003616 ADDICTION MEDICINE CONSULTANTS 2,200.00 1/4/2018 10003617 ADVANCED TELEMETRY SYSTEMS INTERNATIONAL, INC. 9,606.31 1/4/2018 10003618 AIRGAS, USA LLC 455.74 1/4/2018 10003619 BARRY'S SECURITY SERVICES, INC 1,509.50 1/4/2018 10003620 DAN DIETZ 444.15 1/4/2018 10003621 DANGELO CO INC 2,083.60 1/4/2018 10003622 DAVID HERNANDEZ 422.05 1/4/2018 10003623 DIAMOND FENCE COMPANY 830.00 1/4/2018 10003624 FLEET SERVICES /COLTON TRUCK 87.11 1/4/2018 10003625 GARY STURDIVAN 612.35 1/4/2018 10003626 GORDON GRANT 529.37 1/4/2018 10003627 HAAKER EQUIPMENT COMPANY 678.57 1/4/2018 10003628 I.C.W.A. 320.00 1/4/2018 10003629 JEREMY SUBRIAR 100.00 1/4/2018 10003630 LAND ENGINEERING CONSULTANTS 8,372.00 1/4/2018 10003631 LANDS END INC 189.84 1/4/2018 10003632 LEGEND PUMP AND WELL 4,700.59 1/4/2018 10003633 LESLIE'S POOL SUPPLIES, INC. 67.69 1/4/2018 10003634 LINCOLN NATIONAL LIFE INS CO. 2,090.43 1/4/2018 10003635 MICHAEL HENDERSON 597.23 1/4/2018 10003636 MIKE J. ROQUET CONSTRUCTION INC 19,550.00 1/4/2018 10003637 MUSICK, PEELER & GARRETT LLP 2,121.70 1/4/2018 10003638 OFFICIAL PAYMENTS CORP. 37.15 1/4/2018 10003639 PARRON HALL CORPORATION 13,188.32 1/4/2018 10003640 PLUS 1 PERFORMANCE 89.99 1/4/2018 10003641 PRINCIPAL FINANCIAL GROUP 8,686.16 1/4/2018 10003642 REBECCA KASTEN 700.00 1/4/2018 10003643 RYAN HERCO FLOW SOLUTIONS 73.97 1/4/2018 10003644 SAN BERNARDINO VALLEY MUNICIPAL WATER DISTRICT 499,929.20 1/4/2018 10003645 SCHUBERT ENTERPRISES INC 220.00 1/4/2018 10003646 THOMAS P ORTON 465.35 1/4/2018 10003647 TROY ALARM, INC. 192.00 1/4/2018 10003648 VERIZON WIRELESS 4,720.00 1/4/2018 10003650 VISTA PAINTS 218.83 1/4/2018 10003651 VULCAN MATERIALS COMPANY 543.92 1/11/2018 10003652 ADP, LLC 282.30 1/11/2018 10003653 ADS LLC 16,000.00 1/11/2018 10003654 AIRGAS, USA LLC 179.73 1/11/2018 10003655 BARRY'S SECURITY SERVICES, INC 3,123.50 1/11/2018 10003656 CLEARFLY COMMUNATIONS 1,345.10 1/11/2018 10003657 CLIFF'S PEST CONTROL 323.00 1/11/2018 10003658 CLINICAL LAB OF S B 4,905.25 1/11/2018 10003659 CORELOGIC SOLUTIONS INC. 315.00 1/11/2018 10003660 DAMON RUSSELL 8.33 1/11/2018 10003661 DANIEL DAVIS 162.36 1/11/2018 10003662 Destiny Lambeth 125.00 1/11/2018 10003663 EVWD EMPLOYEES EVENTS ASSOC 329.50 1/11/2018 10003664 FILARSKY & WATT LLP 310.00 1/11/2018 10003665 FSA Only/East Valley Water District 1,765.30 1/11/2018 10003666 INFOSEND, INC 37,133.72 1/11/2018 10003667 LEGEND PUMP AND WELL 1,280.00 1/11/2018 10003668 MANAGED HEALTH NETWORK 235.20 PAYMENT REGISTER JANUARY 1, 2018 - JANUARY 31, 2018 Page 6 of 8 PAYMENT DATE NUMBER VENDOR NAME AMOUNT 1/11/2018 10003669 NATIONAL CONSTRUCTION RENTALS 158.49 1/11/2018 10003670 P.A.D. PALM AUTO DETAIL 915.00 1/11/2018 10003671 PLUMBERS DEPOT INC. 1,423.05 1/11/2018 10003672 PLUS 1 PERFORMANCE 199.12 1/11/2018 10003673 POWERSTRIDE BATTERY CO. 216.53 1/11/2018 10003674 SAFETY COMPLIANCE COMPANY 200.00 1/11/2018 10003675 TROY ALARM, INC. 264.00 1/11/2018 10003676 UNDERGROUND SERVICE ALERT 178.30 1/11/2018 10003677 VULCAN MATERIALS COMPANY 571.59 1/17/2018 10003678 ARMORCAST PRODUCTS COMPANY 29,722.95 1/17/2018 10003679 ASHOK K. DHINGRA, AKD CONSULTING 14,413.20 1/17/2018 10003680 CINTAS CORPORATION (FIRST AID) 166.40 1/17/2018 10003681 CLINICAL LAB OF S B 5,935.75 1/17/2018 10003682 EVERBRIDGE, INC. 12,000.00 1/17/2018 10003683 FERGUSON ENTERPRISES, INC. 602.62 1/17/2018 10003684 INLAND KENWORTH (US) INC. 12.60 1/17/2018 10003685 JOHN WITHERS ASSOCIATES 6,000.00 1/17/2018 10003686 KAMBRELL CAMPER 149.00 1/17/2018 10003687 LEGEND PUMP AND WELL 857.60 1/17/2018 10003688 NETWORK FLEET, INC 124.75 1/17/2018 10003689 PACIFIC COAST TOOL & SUPPLY 375.34 1/17/2018 10003690 VOLOGY, INC. 2,542.91 1/17/2018 10003691 WSP USA INC. 211.00 1/25/2018 10003692 ADP, LLC 278.80 1/25/2018 10003693 ANTHONY'S IRRIGATION 6,950.00 1/25/2018 10003694 BARRY'S SECURITY SERVICES, INC 3,334.78 1/25/2018 10003695 BOOT BARN, INC 183.59 1/25/2018 10003696 CINTAS CORPORATION (FIRST AID) 316.16 1/25/2018 10003697 ELEPHANT FIRE EXTINSUISHER 1,543.10 1/25/2018 10003698 EVWD EMPLOYEES EVENTS ASSOC 364.50 1/25/2018 10003699 EXCEL LANDSCAPE, ICN 12,736.22 1/25/2018 10003700 FERGUSON ENTERPRISES, INC. 6,282.20 1/25/2018 10003701 FSA Only/East Valley Water District 1,629.30 1/25/2018 10003702 I.C.W.A. 450.00 1/25/2018 10003703 ICMA RETIREMENT CORPORATION 250.00 1/25/2018 10003704 IMG/INLAND MEDIA GROUP, STEVE SWITZER 160.00 1/25/2018 10003705 JC LAW FIRM 13,575.00 1/25/2018 10003706 JOSE MILLAN 2,600.00 1/25/2018 10003707 LANDS END INC 609.08 1/25/2018 10003708 LEGEND PUMP AND WELL 14,588.68 1/25/2018 10003709 MCMASTER-CARR 106.04 1/25/2018 10003710 MUSICK, PEELER & GARRETT LLP 2,123.90 1/25/2018 10003711 NEOPOST USA INC 366.79 1/25/2018 10003712 OFFICIAL PAYMENTS CORP. 34.95 1/25/2018 10003713 PLUS 1 PERFORMANCE 417.43 1/25/2018 10003714 PSA PRINTING & MAILING SERVICES, INC 275.10 1/25/2018 10003715 RAYMOND ROYBAL 105.00 1/25/2018 10003716 SAFETY COMPLIANCE COMPANY 200.00 1/25/2018 10003717 USA BLUE BOOK 168.60 1/25/2018 10003718 VULCAN MATERIALS COMPANY 2,498.48 1/25/2018 10003719 WATEREUSE ASSOCIATION 2,996.00 1/25/2018 10003720 WESTERN WEATHER GROUP INC 249.00 1/25/2018 10003721 WORTHINGTON PARTNERS, LLC 10,000.00 PAYMENT REGISTER JANUARY 1, 2018 - JANUARY 31, 2018 Page 7 of 8 PAYMENT DATE NUMBER VENDOR NAME AMOUNT 1/31/2018 10003722 ADS LLC 3,200.00 1/31/2018 10003723 AIRGAS, USA LLC 53.86 1/31/2018 10003724 APPLIED MAINTENANCE SUPPLIES & SOLUTIONS LLC 954.13 1/31/2018 10003725 BARRY'S SECURITY SERVICES, INC 1,641.95 1/31/2018 10003726 BOOT BARN, INC 173.86 1/31/2018 10003727 DIAMOND FENCE COMPANY 1,400.00 1/31/2018 10003728 EXCEL LANDSCAPE, ICN 12,489.97 1/31/2018 10003729 FERGUSON ENTERPRISES, INC. 5,573.93 1/31/2018 10003730 HAAKER EQUIPMENT COMPANY 622.32 1/31/2018 10003731 INDUSTRIAL RUBBER & SUPPLY 196.02 1/31/2018 10003732 INFOSEND, INC 25,665.12 1/31/2018 10003733 JOSE MILLAN 240.00 1/31/2018 10003734 LAND ENGINEERING CONSULTANTS 6,472.00 1/31/2018 10003735 LINCOLN NATIONAL LIFE INS CO. 2,125.88 1/31/2018 10003736 MANAGED HEALTH NETWORK 235.20 1/31/2018 10003737 MICAH GEORGE 25.64 1/31/2018 10003738 MIKE J. ROQUET CONSTRUCTION INC 30,890.60 1/31/2018 10003739 MILLER SPATIAL SERVICES, LLC 3,250.00 1/31/2018 10003740 MINUTEMAN PRESS OF RANCHO CUCAMONGA 5,116.82 1/31/2018 10003741 PLUS 1 PERFORMANCE 19.05 1/31/2018 10003742 POWERSTRIDE BATTERY CO. 303.21 1/31/2018 10003743 PRINCIPAL FINANCIAL GROUP 8,856.79 1/31/2018 10003744 SAFETY COMPLIANCE COMPANY 400.00 1/31/2018 10003745 SCHUBERT ENTERPRISES INC 220.00 1/31/2018 10003746 SDRMA, SPECIAL DISTRICT RISK MGMT 3,475.94 1/31/2018 10003747 VULCAN MATERIALS COMPANY 685.27 1/31/2018 10003748 WAXIE SANITARY SUPPLY 280.27 TOTAL 2,667,176.32$ PAYMENT REGISTER JANUARY 1, 2018 - JANUARY 31, 2018 Page 8 of 8 B O AR D AGE N D A S TAF F R E P ORT Agenda Item #3. Meeting Date: F eb ruary 28, 2018 Dis c ussion Item To: G o verning Board Memb ers F rom: G eneral Manager/C EO Subject: R evis io n to F ramework Agreement with S an Bernard ino Valley Munic ip al Water Distric t R E C O MME N D AT IO N: S taff recommend s that the Board of Direc tors (Bo ard ) app ro ve the F irs t Amended Agreement (Agreement) fo r the C o ns truc tio n and O peratio n o f G round water R eplenishment F ac ilities with S an Bernardino Valley Municipal Water Dis tric t (Valley Dis tric t) to fac ilitate 1) us e of tax-exemp t bond p ro ceeds for funding of the S terling Natural R esourc e C enter (S NR C ), and 2) termination o f the Agreement upo n ac tivation o f Eas t Valley Water District’s (EVW D) was tewater treatment authority. B AC KGR O UN D / AN ALYS IS : In O cto b er 2015, EVW D s igned the Agreement with Valley Dis trict. T his Agreement estab lis hed the roles and res p o ns ibilities of eac h Dis tric t in a c o llab o rative effort to d es ign, build, and operate the water treatment / recycling fac ility no w known as the S terling Natural R es o urc e C enter (S NR C ). S ectio n 3 of the Agreement dis cus s es O p eratio n o f the Was tewater Treatment P lant, and the language o f this s ectio n needs to be c hanged in order to reflec t changing c ircums tanc es and c omments by the Department of Water R es o urc es ’ (DW R ) atto rney as a res ult o f his review of EVW D’s funding applic atio n. F irs t, s ectio n 3.a. estab lis hes the initial term o f the operations agreement at 10 years, with p ro vis ion fo r 5-year extens ions, and als o with the p rovis io n that if L A F C O ac tivates EVW D’s treatment authority, EVW D c o uld take over o p eratio n o f the plant with a one year written notice. However, with the likeliho o d that E VW D’s treatment autho rity will be ac tivated p rio r to c ons tructio n, there is no need for Valley District to be involved in the o p eratio n of the p lant. T herefo re, s taff is recommending that provis io ns o f the agreement be c hanged to state that the Agreement will be terminated , effective o n the d ate o f ac tivation of EVW D’s wastewater treatment authority. S econd , s ectio n 3.b . has b ecome a point o f c o nc ern fo r the DW R b o nd counsel. T his s ectio n s tates “Valley Dis tric t shall o p erate the was tewater treatment p lant, or cause it to be operated by a subcontractor, in a good and wo rkmanlike fashio n.”. As worded, this language regarding a s ubcontrac tor leaves o p en the p o s s ibility that the plant will b e op erated b y a bus ines s enterprise, whic h in turn raises the ques tion of whether the plant is being b uilt fo r munic ip al o r c o mmercial use. T he DW R ’s b o nd c ounsel has d etermined that, unles s the language of s ectio n 3.b . is revis ed , the S NR C project would be d is q ualified fro m us ing state tax-exempt bond proc eed s . Acc o rd ingly, DW R s taff has as ked EVW D and Valley Dis tric t to revis e the Agreement and eliminate the c laus e allo wing operatio n o f the plant b y a s ubc o ntrac tor. R ecommended b y: Jo hn Mura G eneral Manager/C EO R espec tfully sub mitted: Brian Tomp kins C hief F inancial O ffic er allo wing operatio n o f the plant b y a s ubc o ntrac tor. R evis ions to the sec tions d is c ussed above are s hown on page 5 of the attac hed c o p y of the Agreement. S taff recommends that the Bo ard ap prove thes e revisions in order to facilitate the us e o f s tate tax-exempt b o nd p ro ceeds for funding of the S NR C , and facilitate termination o f the entire agreement o nc e the Dis tric t’s wastewater treatment authority has been ac tivated by LAF C O . If ap p ro ved , thes e revisions will b e c o ns idered for ap p roval by Valley Dis tric t’s Bo ard at their firs t meeting in Marc h. AG E N C Y G O ALS AN D OB J E C T IVE S : G o al and O bjec tives I I - Maintain a C ommitment to S us tainab ility, Transparenc y, and Ac c o untability a) P rac tice Trans parent and Ac countab le F is cal Management R E VIE W B Y O T HE R S : T his agenda item has been reviewed by Legal C o uns el. F IS C AL IMPAC T T here is no fis cal impac t as s o c iated with this agend a item. ATTACH M E N TS: Description Type Schedule A - Framework Agreeme nt Backup Material Execution Copy Agreement for Groundwater Replenishment EVWD/Valley District September 2015 Page 1 of 13 1417151.6 First Amended Agreement for the Construction and Operation of Groundwater 1 Replenishment Facilities 2 By and Between 3 East Valley Water District and San Bernardino Valley Municipal Water District 4 5 This First Amended Agreement (Agreement) for the Construction and Operation of 6 Groundwater Replenishment Facilities is entered into and effective this 6th1st day of 7 MarchSeptember, 20185 by and between East Valley Water District (“EVWD”) and San 8 Bernardino Valley Municipal Water District (“Valley District”). EVWD and Valley District are 9 each sometimes referred to herein as a “Party” and are collectively referred to as the “Parties.” 10 Additional signatories to this Agreement may include the City of San Bernardino Municipal 11 Water Department. This Agreement shall become effective upon execution by Valley District 12 and EVWD, regardless of whether the City of San Bernardino Municipal Water Department or 13 any other additional signatory has executed this Agreement. 14 15 Recitals 16 17 A. The Sustainable Groundwater Management Act of 2014 requires public agencies to 18 develop plans to ensure the sustainable long-term use of California’s groundwater resources. 19 20 B. In 2009, the State Water Resources Control Board adopted a Recycled Water Policy that 21 encourages public agencies to develop groundwater recharge projects using recycled water. 22 23 C. The Parties believe that through their cooperative work, they can treat and discharge 24 wastewater in a manner that will maximize the benefits to the Santa Ana River and to the region. 25 The Parties further believe that such wastewater discharge can be treated to levels that allow the 26 use of such recycled water for groundwater replenishment or other permissible uses within the 27 San Bernardino Basin Area, or other adjacent groundwater basins, for the benefit of the Parties 28 and their ratepayers. Achieving such groundwater objectives requires the construction of a new 29 wastewater treatment plant. 30 31 D. Using recycled water to replenish the San Bernardino Basin Area, which is the 32 groundwater basin serving the needs of EVWD and which includes most of the area within 33 Valley District, improves water supply reliability for EVWD and other retail water agencies 34 within Valley District’s service area and also provides a drought buffer for those agencies in the 35 event of a lengthy drought. 36 37 E. The Parties, together with a number of other water agencies, are working together to 38 develop a collaborative regional plan to increase the use of recycled water for groundwater 39 replenishment and other purposes. The Parties intend that this project be an integral part of that 40 regional plan. This Agreement is intended to implement the more general understandings of the 41 Parties and others as reflected in that regional plan. 42 Execution Copy Agreement for Groundwater Replenishment EVWD/Valley District September 2015 Page 2 of 13 1417151.6 43 F. Replenishing the San Bernardino Basin Area or other groundwater basins with recycled 44 water is consistent with article X, section 2 of the California Constitution, which requires that the 45 water resources of California be used to the fullest extent of which they are capable and is also 46 consistent with Water Code section 13576(k), which authorizes and encourages the use of 47 recycled water for groundwater replenishment. Groundwater replenishment is also within the 48 authority of both Parties. 49 50 G. The Parties wish to memorialize their agreements relating to constructing and operating a 51 wastewater treatment plant (the “Project”) that will enable them to replenish the groundwater 52 resources that serve their respective ratepayers. 53 54 Agreements 55 56 1. Governance – Joint Management. 57 a. The Parties agree that they will work together in good faith to complete the 58 construction of the Project no later than June 30, 2018_. 59 b. The Parties will then promptly enter into an agreement for the operation of the 60 Project with a term of at least ten years that will enable the Parties to replenish the 61 San Bernardino Basin Area with at least 6,000 acre-feet of recycled water. 62 c. In accomplishing these objectives, the Project will be managed by a Management 63 Committee composed of the General Manager of EVWD and the General 64 Manager of Valley District, or their designees. All decisions shall be made on a 65 unanimous basis. 66 d. Both Parties hereby authorize their respective General Managers or designees to 67 develop any administrative and operating rules and procedures that may be 68 needed to implement the terms of this Agreement and that do not require a change 69 in the terms of the Agreement without subsequent action by the Parties’ governing 70 boards. 71 2. Construction of Wastewater Treatment Plant. The Parties agree that Valley District shall 72 serve as the lead agency for the construction and operation of the Project, as follows: 73 a. Assignment of Consulting Agreements and Permits by EVWD to Valley District. 74 Within thirty days of the effective date of this Agreement, EVWD shall assign all 75 existing consulting or other agreements other than legal, as well as any permits, 76 easements or other approvals, relating to the construction of the Project or its 77 subsequent operation to Valley District. 78 Execution Copy Agreement for Groundwater Replenishment EVWD/Valley District September 2015 Page 3 of 13 1417151.6 (1) In the event that Valley District determines, in its sole discretion, that it 79 needs to retain additional consultants in order to fulfill its obligations 80 under the terms of this Agreement, Valley District may retain such 81 consultants without the prior consent of EVWD. Valley District shall, 82 however, provide a copy of such newly retained consultant’s budget, 83 scope of work and retainer agreement to EVWD within thirty days of such 84 consultant’s retention. 85 (2) The Parties understand and agree that, throughout the construction and 86 operation of the Project, each Party will continue to be represented by its 87 own regular legal counsel. The Parties will, within thirty days of the 88 execution of this Agreement, enter into a joint defense/common interest 89 doctrine agreement that will enable them to proceed with the Project in the 90 most expeditious manner possible. 91 b. Design-Build and Project Permitting. Valley District shall design, permit and 92 construct the Project by means of one or more design/build contracts, as 93 authorized by Public Contracts Code sections 22160 et seq. Specifically: 94 (1) Design Proposal. Valley District shall work with one or more firms to 95 develop a design/build proposal for review and approval by EVWD no 96 later than _April 30, 2016. 97 (a) The wastewater treatment plant shall be built on APNs 0279-211-98 33-0000, 0279-211-25-0000, 0279-211-26-0000 and 0279-211-01-99 0000, which are owned by EVWD. To the extent that additional 100 easements are needed by Valley District or entities acting under 101 Valley District’s direction in order to complete the Project, EVWD 102 agrees to issue such easements over its own property or to be 103 responsible for obtaining such easements from neighboring 104 landowners. 105 (b) EVWD shall review the design/build proposal and approve it (with 106 or without changes) within thirty days of submission. If EVWD 107 fails to approve the proposal in a timely manner, Valley District 108 may, in its sole discretion, deem this Agreement to have been 109 terminated. 110 (2) Permitting. Valley District shall be responsible for obtaining all local, 111 state or federal permits that may be necessary for the construction or 112 operation of the Project in a timely manner. 113 Execution Copy Agreement for Groundwater Replenishment EVWD/Valley District September 2015 Page 4 of 13 1417151.6 (a) Such permits shall include, but are not limited to, NPDES permits, 114 other permits necessary to use recycled water to replenish the San 115 Bernardino Basin Area, and the permits needed to allow for the 116 continued discharge of treated wastewater either to the Santa Ana 117 River or other appropriate discharge points. 118 (b) Valley District shall also be the lead agency for the preparation of 119 one or more environmental document(s) that may be required 120 under the terms of the National Environmental Policy Act and/or 121 the California Environmental Quality Act that are sufficient to 122 support the issuance of the necessary permits for the Project. 123 (3) Construction. Valley District shall cause the Project to be constructed in a 124 timely manner. The Parties anticipate that the Project shall be completed 125 by _June 30, 2018. Valley District shall provide monthly updates to 126 EVWD on changes to the plans, specifications, and schedules. Valley 127 District shall not be liable for any delays or additional costs in 128 constructing the Project, save for the gross negligence, intentional acts and 129 willful misconduct of Valley District and its employees, agents and 130 contractors. 131 (4) Award of Contract. Valley District shall obtain the concurrence of EVWD 132 prior to awarding any contract for the construction of the Project. EVWD 133 agrees not to unreasonably delay its approval of any proposed contract. 134 (5) Costs. The Parties agree that the construction of the Project will occur at 135 no cost to Valley District. Valley District shall be entitled to recover all of 136 its costs (including, but not limited to, materials costs; consultants, experts 137 and attorneys’ fees; and direct expenditures) from EVWD for the 138 construction of the Project, save for costs directly caused by the gross 139 negligence, intentional acts and willful misconduct of Valley District and 140 its employees, agents and contractors. 141 (6) Mark-Up of Costs. EVWD shall pay all costs incurred by Valley District 142 in connection with the Project without any mark-up, including that EVWD 143 shall pay Valley District’s reasonable staff time for work related to the 144 Project. 145 (7) Payments Obligatory. EVWD shall make all payments required by this 146 Agreement as they become due, notwithstanding any individual default by 147 its customers or users, any dispute over charges, or otherwise. 148 Execution Copy Agreement for Groundwater Replenishment EVWD/Valley District September 2015 Page 5 of 13 1417151.6 c. Financing. EVWD agrees that it will finance the full costs of all work associated 149 with or required by the Project and may make any arrangements that it deems 150 appropriate for such financing without the consent of Valley District. EVWD 151 shall keep Valley District reasonably informed as to the status of such financing. 152 Valley District will cooperate, and may assist in other ways at its discretion, with 153 EVWD’s efforts to secure financing for the Project to the extent that cooperation 154 is reasonable and necessary. 155 3. Operation of Wastewater Treatment Plant for Groundwater Replenishment. The Parties 156 shall enter into the operations agreement for the wastewater treatment plant and for 157 groundwater replenishment referred to in paragraph 1 above no later than thirty days 158 after the completion of the construction of the wastewater treatment plant. Such 159 operations agreement shall include the following terms: 160 a. Term 161 (1) The operations agreement shall be for an initial term of ten years, with 162 subsequent terms of five years each. Either Party may terminate the 163 operations agreement with at least one year’s written notice prior to the 164 completion of either the initial term or a subsequent term, but if no such 165 termination notice is received in a timely manner, the operations 166 agreement shall automatically renew for another five year period. 167 (2) Notwithstanding the previous subparagraph, if the San Bernardino County 168 Local Agency Formation Commission activates EVWD’s authority to 169 provide wastewater treatment services to its ratepayers (Activation), this 170 Agreement shall be deemed terminated in its entirety, effective on the date 171 of Activation and neither Party to this Agreement shall have any further 172 obligation hereunder except for those obligations which have accrued as of 173 the date of Activation. EVWD may succeed to Valley District’s 174 obligations to operate the wastewater treatment plant by providing Valley 175 District with one year’s written notice of such succession. 176 b. Operation of the Wastewater Treatment Plant. Valley District shall operate the 177 wastewater treatment plant, or cause it to be operated by a subcontractor, in a 178 good and workmanlike fashion, in full compliance with all applicable local, state 179 and federal laws and regulations. 180 (1) EVWD shall arrange, at its sole cost, for the collection and conveyance of 181 wastewater generated within EVWD’s service area to the wastewater 182 treatment plant. 183 Execution Copy Agreement for Groundwater Replenishment EVWD/Valley District September 2015 Page 6 of 13 1417151.6 (2) EVWD shall pay all costs incurred by Valley District for the operation of 184 the wastewater treatment plant (including staff time). Valley District shall 185 invoice EVWD quarterly in arrears and EVWD shall pay Valley District 186 within thirty days of the date of each invoice. 187 c. Public Education. EVWD may construct facilities ancillary to the Project for the 188 purpose of public education and programming on topics including water 189 conservation and replenishment; Valley District will not object to the construction 190 and operation of such public education facilities and the conduct of such 191 programs, provided that such facilities and programs are conducted in such a way 192 so as not to interfere with the ongoing operations of the wastewater treatment 193 plant. 194 4. Groundwater Replenishment with Recycled Water. The Parties agree that any recycled 195 water produced by the wastewater treatment plant shall be the sole property of EVWD. 196 5. Facility Ownership. EVWD shall own, in fee simple, all Project facilities provided that 197 until EVWD completes payment of all construction costs to Valley District, Valley 198 District shall be deemed to have a security interest in those facilities in an amount equal 199 to the unpaid debt. In the event of a default in required payment by EVWD, the Parties 200 agree that Valley District shall have the right to obtain a judgment in the amount of any 201 default by EVWD and shall further have the right to cause EVWD to increase its water 202 charges or to levy an assessment to pay the amount of the default. 203 6. Indemnification 204 a. Indemnification by Valley District. Valley District shall indemnify, defend and 205 hold harmless EVWD, its directors, officers, attorneys, employees and agents 206 from and against all damages, liabilities, claims, actions, demands, costs and 207 expenses (including, but not limited to, costs of investigations, lawsuits and any 208 other proceedings whether in law or in equity, settlement costs, attorneys’ fees 209 and costs), and penalties or violations of any kind, which arise out of, result from, 210 or are related to Valley District’s performance of its obligations under this 211 Agreement. 212 b. Indemnification by EVWD. EVWD shall indemnify, defend and hold harmless 213 Valley District, its directors, officers, attorneys, employees and agents from and 214 against all damages, liabilities, claims, actions, demands, costs and expenses 215 (including, but not limited to, costs of investigations, lawsuits and any other 216 proceedings whether in law or in equity, settlement costs, attorneys’ fees and 217 costs), and penalties or violations of any kind, which arise out of, result from, or 218 are related to the performance of EVWD’s obligations under this Agreement. 219 Execution Copy Agreement for Groundwater Replenishment EVWD/Valley District September 2015 Page 7 of 13 1417151.6 c. Indemnification Procedures. Any Party that is an indemnified party (the 220 "Indemnified Party") that has a claim for indemnification against the other Party 221 (the "Indemnifying Party") under this Agreement, shall promptly notify the 222 Indemnifying Party in writing, provided, however, that no delay on the part of the 223 Indemnified Party in notifying the Indemnifying Party shall relieve the 224 Indemnifying Party from any obligation unless (and then solely to the extent) the 225 Indemnifying Party is prejudiced. Further, the Indemnified Party shall promptly 226 notify the Indemnifying Party of the existence of any claim, demand, or other 227 matter to which the indemnification obligations would apply, and shall give the 228 Indemnifying Party a reasonable opportunity to defend the same at its own 229 expense and with counsel of its own selection, provided that the Indemnified 230 Party shall at all times also have the right to fully participate in the disputed 231 matter at its own expense. If the Indemnifying Party, within a reasonable time 232 after notice from the Indemnified Party, fails to defend a claim, demand or other 233 matter to which the indemnification obligations would apply, the Indemnified 234 Party shall have the right, but not the obligation, to undertake the defense of, and 235 to compromise or settle (exercising reasonable business judgment), the claim or 236 other matter, on behalf, or for the account, and at the risk, of the Indemnifying 237 Party. If the claim is one that cannot by its nature be defended solely by the 238 Indemnifying Party, then the Indemnified Party shall make available all 239 information and assistance to the Indemnifying Party that the Indemnifying Party 240 may reasonably request. 241 7. Administration of Agreement 242 a. Books and Records. Each Party shall have access to and the right to examine any 243 of the other Party’s pertinent books, documents, papers or other records 244 (including, without limitation, records contained on electronic media) relating to 245 the performance of that Party’s obligations pursuant to this Agreement or the 246 Project. 247 (1) Retention of Records; Preservation of Privilege. Each Party shall retain 248 all such books, documents, papers or other records to facilitate such 249 review in accordance with that Party’s record retention policy. Access to 250 each Party’s books and records shall be during normal business hours 251 only. Nothing in this paragraph shall be construed to operate as a waiver 252 of any applicable privileges. 253 (2) Outside Auditors. Any Party may, at any time and at its sole cost, hire an 254 auditor to examine the accounting for work performed pursuant to this 255 Agreement. The Parties may also agree to retain an independent auditor to 256 review the accounting for work performed pursuant to this Agreement. 257 The costs of such an auditor will be shared equally between the Parties. 258 Execution Copy Agreement for Groundwater Replenishment EVWD/Valley District September 2015 Page 8 of 13 1417151.6 b. Disputes. The Parties recognize that there may be disputes regarding the 259 obligations of the Parties or the interpretation of this Agreement. The Parties 260 agree that they may attempt to resolve disputes as follows: 261 (1) Statement Describing Alleged Violation or Interruption of Agreement. A 262 Party alleging a violation or interruption of this Agreement (the 263 “Initiating Party”) shall provide a written statement describing all facts 264 that it believes constitute a violation or interruption of this Agreement to 265 the Party alleged to have violated or interrupted the terms of this 266 Agreement (the “Responding Party”). 267 (2) Response to Statement of Alleged Violation or Interruption. The 268 Responding Party shall have sixty days from the date of the written 269 statement to prepare a written response to the allegation of a violation or 270 interruption of this Agreement and serve that response on the Initiating 271 Party or to cure the alleged violation or interruption to the reasonable 272 satisfaction of the Initiating Party. The Initiating Party and the 273 Responding Party shall then meet within thirty days of the date of the 274 response to attempt to resolve the dispute amicably. 275 (3) Mediation of Dispute. If the Initiating Party and the Responding Party 276 cannot resolve the dispute within ninety days of the date of the written 277 response, they shall engage a mediator, experienced in water-related 278 disputes, to attempt to resolve the dispute. Each Party shall ensure that it 279 is represented at the mediation by a member of its Board of Directors. 280 These representatives of the Initiating Party and the Responding Party may 281 consult with staff and/or technical consultants during the mediation and 282 such staff and/or technical consultants may be present during the 283 mediation. The costs of the mediator shall be divided equally between the 284 Initiating Party and the Responding Party. 285 (4) Prior to Claims Under California Tort Claims Act. The Parties agree that 286 the procedure described in this paragraph 7.b represents an effort to 287 resolve disputes without the need for a formal claim under the California 288 Tort Claims Act or other applicable law. The period of time for the 289 presentation of a claim by one Party against another shall be tolled for the 290 period from the date on which the Initiating Party files a written statement 291 until the date upon which the mediator renders a decision. 292 (5) Reservation of Rights. Nothing in this paragraph 7.b shall require a Party 293 to comply with a decision of the mediator and, after the completion of the 294 mediation process described above, each Party shall retain and may 295 exercise at any time all legal and equitable rights and remedies it may 296 Execution Copy Agreement for Groundwater Replenishment EVWD/Valley District September 2015 Page 9 of 13 1417151.6 have to enforce the terms of this Agreement; provided, that prior to 297 commencing litigation, a Party shall provide at least five calendar days’ 298 written notice of its intent to sue to the other Party. 299 8. General Provisions. 300 a. Authority. Each signatory of this Agreement represents that s/he is authorized to 301 execute this Agreement on behalf of the Party for which s/he signs. Each Party 302 represents that it has legal authority to enter into this Agreement, to perform all 303 obligations under this Agreement and that any and all appropriate Board action 304 necessary for approval of this Agreement has been taken. . 305 b. Amendment. This Agreement may be amended or modified only by a written 306 instrument executed by each of the Parties to this Agreement. 307 c. Jurisdiction and Venue. This Agreement shall be governed by and construed in 308 accordance with the laws of the State of California, except for its conflicts of law 309 rules. Any suit, action, or proceeding brought under the scope of this Agreement 310 shall be brought and maintained to the extent allowed by law in the County of San 311 Bernardino, California. 312 d. Headings. The paragraph headings used in this Agreement are intended for 313 convenience only and shall not be used in interpreting this Agreement or in 314 determining any of the rights or obligations of the Parties to this Agreement. 315 e. Construction and Interpretation. This Agreement has been arrived at through 316 negotiations and each Party has had a full and fair opportunity to revise the terms 317 of this Agreement. As a result, the normal rule of construction that any 318 ambiguities are to be resolved against the drafting Party shall not apply in the 319 construction or interpretation of this Agreement. 320 f. Entire Agreement. This Agreement constitutes the entire agreement of the Parties 321 with respect to the subject matter of this Agreement and, save as expressly 322 provided in this Agreement, supersedes any prior oral or written agreement, 323 understanding, or representation relating to the subject matter of this Agreement. 324 g. Partial Invalidity. If, after the date of execution of this Agreement, any provision 325 of this Agreement is held to be illegal, invalid, or unenforceable under present or 326 future laws effective during the term of this Agreement, such provision shall be 327 fully severable. However, in lieu thereof, there shall be added a provision as 328 similar in terms to such illegal, invalid or unenforceable provision as may be 329 possible and be legal, valid and enforceable. 330 Execution Copy Agreement for Groundwater Replenishment EVWD/Valley District September 2015 Page 10 of 13 1417151.6 h. Successors and Assigns. This Agreement shall be binding on and inure to the 331 benefit of the successors and assigns of the respective Parties to this Agreement. 332 No Party may assign its interests in or obligations under this Agreement without 333 the written consent of the other Parties, which consent shall not be unreasonably 334 withheld or delayed. 335 i. Waivers. Waiver of any breach or default hereunder shall not constitute a 336 continuing waiver or a waiver of any subsequent breach either of the same or of 337 another provision of this Agreement and forbearance to enforce one or more of 338 the rights or remedies provided in this Agreement shall not be deemed to be a 339 waiver of that right or remedy. 340 j. Attorneys’ Fees and Costs. The prevailing Party in any litigation or other action 341 to enforce or interpret this Agreement shall be entitled to reasonable attorneys’ 342 fees, expert witnesses’ fees, costs of suit, and other and necessary disbursements 343 in addition to any other relief deemed appropriate by a court of competent 344 jurisdiction. 345 k. Necessary Actions. Each Party agrees to execute and deliver additional 346 documents and instruments and to take any additional actions as may be 347 reasonably required to carry out the purposes of this Agreement. 348 l. Compliance with Law. In performing their respective obligations under this 349 Agreement, the Parties shall comply with and conform to all applicable laws, 350 rules, regulations and ordinances. 351 m. Third Party Beneficiaries. This Agreement shall not create any right or interest in 352 any non-Party or in any member of the public as a third party beneficiary. 353 n. Counterparts. This Agreement may be executed in one or more counterparts, 354 each of which shall be deemed to be an original, but all of which together shall 355 constitute but one and the same instrument. 356 o. Notices. All notices, requests, demands or other communications required or 357 permitted under this Agreement shall be in writing unless provided otherwise in 358 this Agreement and shall be deemed to have been duly given and received on: (i) 359 the date of service if served personally or served by facsimile transmission on the 360 Party to whom notice is to be given at the address(es) provided below, (ii) on the 361 first day after mailing, if mailed by Federal Express, U.S. Express Mail, or other 362 similar overnight courier service, postage prepaid, and addressed as provided 363 below, or (iii) on the third day after mailing if mailed to the Party to whom notice 364 is to be given by first class mail, registered or certified, postage prepaid, 365 addressed as follows: 366 Execution Copy Agreement for Groundwater Replenishment EVWD/Valley District September 2015 Page 11 of 13 1417151.6 367 Execution Copy Agreement for Groundwater Replenishment EVWD/Valley District September 2015 Page 12 of 13 1417151.6 Notice to San Bernardino Valley Municipal Water District 368 369 Douglas Headrick, General Manager 370 SAN BERNARDINO VALLEY MUNICIPAL WATER DISTRICT 371 380 East Vanderbilt Way, San Bernardino, CA 92408 372 Phone: (909) 820-3701 373 Email: douglash@sbvmwd.com 374 David R.E. Aladjem 375 DOWNEY BRAND LLP 376 621 Capitol Mall, Sacramento, CA 95814 377 Phone: (916) 520-5361 378 Email: daladjem@downeybrand.com 379 Notice to East Valley Water District 380 John Mura, General Manager/CEO 381 EAST VALLEY WATER DISTRICT 382 31111 Greenspot Rd., Highland, CA 92346 383 Phone: 909-889-9501 384 Email: john@eastvalley.org 385 Jean Cihigoyenetche 386 CIHIGOYENETCHE GROSSBERG & CLOUSE 387 8038 Haven Avenue, Suite E, Rancho Cucamonga, CA 91730 388 Phone: (909) 483-1850 389 Email: jean@cgclaw.com 390 391 SAN BERNARDINO VALLEY MUNICIPAL WATER DISTRICT 392 393 394 By: ________________________ Dated: _________ 395 Mark Bulot 396 President, Board of Directors 397 398 399 By: ________________________ Dated: _________ 400 Gil Navarro, Secretary 401 402 Execution Copy Agreement for Groundwater Replenishment EVWD/Valley District September 2015 Page 13 of 13 1417151.6 APPROVED AS TO FORM 403 404 By: ________________________ Dated: _________ 405 David R.E. Aladjem, Esq. 406 Downey Brand, LLP 407 Counsel for San Bernardino Valley Municipal Water District 408 409 410 EAST VALLEY WATER DISTRICT 411 412 By: ________________________ Dated: _________ 413 James Morales, Jr. 414 Chairman of the Board 415 416 417 By: ________________________ Dated: _________ 418 John Mura, General Manager/CEO 419 420 APPROVED AS TO FORM 421 422 By: ________________________ Dated: _________ 423 Jean Cihigoyenetche 424 Cihigoyenetche Grossberg & Clouse 425 Counsel for East Valley Water District 426 B O AR D AGE N D A S TAF F R E P ORT Agenda Item #4. Meeting Date: F eb ruary 28, 2018 Dis c ussion Item To: G o verning Board Memb ers F rom: G eneral Manager/C EO Subject: C ons id er Approval o f F Y 2017-18 Mid -Year Bud get R evisions R E C O MME N D AT IO N: S taff rec o mmend s that the Board o f Direc to rs review and ap p ro ve amend ments to the F Y 2017-18 O perating and C apital Bud gets . B AC KGR O UN D / AN ALYS IS : T he 2017-18 Mid -Year Budget R eview is presented fo r the Board of Directo rs ’ review and consideratio n. T his analys is and proc es s p ro vides the Bo ard the opportunity to review the status o f the operating and c ap ital b udgets as o f Dec ember 31st, and to c o ns ider rec o mmend ed adjus tments . At the 1st Q uarter bud get review held in No vember, it was dis closed that water s ales were s lightly b elo w p ro jectio n, and that a large c ap ital p ro jec t related to water treatment would not be needed. As a res ult, s everal ad justments were mad e to the C apital Improvement P rogram, and a temp o rary C ontingenc y R es erve of $500,000 was es tablis hed fo r needs aris ing later in the fis cal year. At mid -year, water s ales have inc reas ed significantly, to the p o int where s taff is rec o mmend ing an adjus tment to the annual s ales projec tion and the water s ales b udget. S taff has als o been monitoring pro gram and c ap ital expend itures thro ugh Dec ember, and are reques ting bud get ad jus tments to provid e res o urc es fo r unexpec ted expens es , or to take ad vantage of opportunities that will enhanc e the value o f s ervic es provided to o ur ratep ayers T he requested bud get ad justments, and jus tificatio ns therefore, are desc rib ed belo w. Revenues Water s ales were $519,000 over p ro jectio n through December, at $9,554,906. T his variance is due to unusually warm weather in the November and Dec emb er mo nths whic h resulted in many R es idential and Irrigatio n cus tomers having s ignific ant us age in Tier 3. T he chart b elo w pres ents cus to mer water us age by Tier for the s ix months end ed Dec emb er 31st. Tier1 and 2 T he chart b elo w pres ents cus to mer water us age by Tier for the s ix months end ed Dec emb er 31st. Tier1 and 2 s ales were 1.8% and 0.6%, res p ectively, below p ro jectio n, whic h ind icates that s ome c us tomers did stay within their water bud gets . However, Tier 3 s ales were mo re than $600,000, or 32%, over projec tio n. T he warm weather has c o ntinued into January and F ebruary res ulting in high water s ales fo r thos e months as well. Based on the variance through Decemb er, and knowing that sales have c o ntinued to exceed projec tio n in the c urrent q uarter, s taff is rec ommend ing a $500,000 inc rease to b udgeted water s ales as a mid-year b udget ad justment. Meter C harge revenue was $45,000 over p ro jec tion at $4,471,000 through December, repres enting 50.5% o f the annual b udget. T he o verage is the result o f higher than antic ip ated use o f construc tion meters , b ut is no t s ignificant eno ugh fo r s taff to rec o mmend an adjus tment to bud geted meter c harge revenue. Investment Inc ome, P enalties, and O ther C harges are at 74% o f bud get through Dec ember 31s t, b ut staff is no t recommending a bud get ad jus tment to thes e revenue items at mid-year. Expenditures T hro ugh December, total exp enditures were at $17,060,928, whic h is 47% of $36,207,000 b udgeted expend itures fo r the year. Expenditures are belo w 50% at mid -year b ec ause o f two major cost c ategories, water s upply c osts and c apital exp enditures : Water sup p ly costs are at les s than 5% of bud get at mid -year b ecaus e Valley Dis trict is not d ue p ayment fo r purc hased water in January, and No rth F ork assessments are paid in May, after the No rth F ork Water C o mpany annual sharehold er meeting. C apital exp end itures are at 19% o f b udget at mid-year bec aus e three large projec ts representing more than $3 millio n are s till in the planning s tages and will not be und er cons truc tion until at leas t April. W hile the above items do not req uire bud get adjus tments , staff is req ues ting adjus tments fo r the fo llowing items s o that pro grams will have ad eq uate res o urc es to fulfill program go als and o b jec tives . P ers o nnel Expens es – the fo llowing s taffing c hanges and bud get inc reas es are reques ted in o rd er to sup p o rt the inc reas ed roles and res p o ns ib ilities plac ed on certain staff members in imp lementing the Dis tric t’s strategic initiatives : P romote Adminis tration and F inanc e Dep artment Ad minis trative As s is tants to S enio r Ad minis trative As sistants . R ec las s ify P ublic Affairs Manager to Directo r of S trategic S ervices. C o nvert a p art-time P ublic Affairs R epresentative to a full-time C reative S ervic es R ep res entative. Eliminate an Engineering Technic ian positio n (vacant since Novemb er) and add an As s o ciate Engineer p o sitio n. Inc reas e O vertime needed for weekend monitoring at P lant 134 and for was tewater mainline c leaning. T he b udget imp act of these c hanges would be approximately $65,000 for the remainder o f 2017-18, and wo uld b e funded by re-purposed temporary res erves set as ide from the firs t q uarter review. S taff is als o reques ting that a o ne-time expend iture of $500,000 be us ed to pay d own long-term o b ligatio ns related to p o s t-emplo yment benefits . Inc reas ed water s ales , as p rojec ted, would b e used to fund this expend iture. C o ntrac t S ervic es – Vario us departments are reques ting an inc rease to their c ontrac t services bud gets to o verc o me unanticipated overlooked servic es need ed at the time the original b udget was b eing p rep ared . T hey inc lude: Ad minis tratio n is requesting an additio nal $100,000 fo r legal s ervic es as litigation (that was dec id ed in the District’s favo r) has us ed most of the P ro gram’s legal bud get fo r 2017-18. Human R esources is reques ting $25,000 to have a c o nsultant c o ntinue working o n organizational s tructure inc lud ing the S terling Natural R esourc e C enter. C us tomer S ervice req ues ts an additio nal $15,000 to cover the unantic ip ated c o s t o f rep o s itioning cub icles to allow better vis ib ility of the cus tomer c o unter. Meter S ervic es needs an additio nal $3,000 to p ro vid e a full s et of unifo rms fo r a new emp lo yee. Water Treatment/F acilities Maintenanc e have reques ted $80,000 fo r s ecurity services at P lant 134 due to the “ac tive” homeless p o p ulation in C ity C reek near the plant. F leet Maintenanc e - $30,000 for generato r maintenance and c ar was h. T he $255,000 in C ontract S ervic es increas es outlined above would be funded b y tempo rary res erves identified d uring the firs t q uarter b udget review. Capital Expenditures S taff has evaluated the C apital Budget and the info rmation that has b ecome availab le s inc e the C I P d is cus s io ns d uring the firs t q uarter review, and is reques ting that the following ad justments b e approved at mid -year: Taylor Road Main E xtensions / S ervice Relocations – T his new pro ject wo uld add s hort main extens io ns to an exis ting main in Taylor R o ad to mitigate a s ituation where multip le properties are s erved by four s hared s ervic e lines . T he shared lines c ross private property b o undaries, a po int whic h makes ad d res s ing leaks in the s ervic e line very c hallenging for all parties . District crews can install the main extens io ns and ins tall new servic e lines to eac h o f 12 properties in les s than 40 ho urs . Total projec t c o s t inc lud ing paving will b e app ro ximately $125,000. Automated Metering Infrastructure (AMI) – T he original 2017-18 b udget d id not inc lude fund ing fo r p has e 2 of the AMI p ro ject, ho wever, the Board ap p ro ved re-purposing $500,000 at the 1st Q uarter bud get review to keep the AMI p ro jec t mo ving fo rward . S taff has been wo rking with F ergus o n Waterwo rks to id entify the meter ro utes fo r p has e 2 that wo uld provide the greatest value to District ratepayers. C o mp letion o f nine ro utes will auto mate all meters west o f S terling Avenue, and remove routes fro m s o me o f the larges t cycles s till being read manually – an ad d itio nal $55,000 is needed for materials and installation to acc o mp lish this with P has e 2. Acc o rd ingly, staff is reques ting a $55,000 increase to the AMI b udget. S ummary T he table belo w presents a s ummary o f actual expend itures year-to-date, the ad o p ted bud get, and propos ed amendments to the b udget. P ro p o s ed amendments to expend itures total $1,000,000 to be fund ed by the $500,000 c o ntingency reserve s et as ide fro m the 1st Q uarter b udget review and $500,000 from increas ed water s ales . D escription Actual YT D Adopted Budget P roposed Amendments Amended B udget Revenue S ales $ 11,907,099 $ 19,045,000 $ 500,000 $ 19,545,000 O ther R evenue 9,468,056 17,579,000 -17,579,000 Total R evenue $ 21,375,155 $ 36,624,000 $ 500,000 $ 37,124,000 Expenditures Labor & Benefits $ 4,559,409 $9,392,000 $ 565,000 $ 9,957,000 Water S up p ly 647 801,000 -801,000 Elec tric ity 1,084,509 1,700,000 -1,700,000 Treatment S ervic es 4,399,360 7,900,000 -7,900,000 Materials 651,509 1,042,000 -1,042,000 C ontrac t S ervices 2,008,493 4,678,000 255,000 4,931,000 O ther O perating Exp.402,848 1,581,000 -1,581,000 Debt S ervic e 3,142,504 4,315,000 -4,315,000 C apital Expend itures 811,649 4,298,000 180,000 4,475,500 Temp o rary C ontingenc y R es erves -500,000 (500,000)- Total Expenditures $ 17,060,928 $ 36,207,000 $ 500,000 $ 36,707,000 R ecommended b y: Jo hn Mura G eneral Manager/C EO R espec tfully sub mitted: Brian Tomp kins C hief F inancial O ffic er A d etailed sc hedule of propos ed adjus tments to C apital Expend itures is attac hed . S taff is recommend ing that the Board ap prove amendments to the 2017-18 O perating and C ap ital Exp enditure bud gets as presented above and in the attachments . AG E N C Y G O ALS AN D OB J E C T IVE S : G o al and O bjec tives I I - Maintain a C ommitment to S us tainab ility, Transparenc y, and Ac c o untability a) P rac tice Trans parent and Ac countab le F is cal Management R E VIE W B Y O T HE R S : T his agenda item has been reviewed by the Ad minis tratio n and F inanc e departments and the F inanc e and Human R esources C ommittee. F IS C AL IMPAC T If approved, staff ’s recommended mid -year adjus tments to the o p erating and c ap ital b udgets ’ amend ments to taling $1 millio n will be fund ed $500,000 by increased water s ales , and $500,000 with the temporary C ontingenc y R es erves set up in the first quarter. ATTACH M E N TS: Description Type Board P resentation P resentation Budget Reports Backup Material Salary Table Backup Material Capital Expenditures Backup Material FY 2017-18 MID-YEAR REVIEW February 28, 2018 OPERATING BUDGET REVIEW FISCAL YEAR 2017-18 WATER FUND SUMMARY 3 Revenue Budget YTD Actual YTD %Projected Water Sales 14,500,000$ 9,554,906$ 66%15,000,000$ Meter Charges 8,845,000 4,471,715 51%8,845,000 Other Charges / Revenue 702,000 569,748 81%702,000 Total Revenue 24,047,000$ 14,596,369$ 61%24,547,000$ Expenses Budget YTD Actual YTD %Projected Labor & Benefits 7,304,600$ 3,554,048$ 49%7,287,100$ Other Operating Expenses 8,218,400 3,554,095 43%8,431,400 Capital Expenditures 4,105,000 156,454 4%4,205,000 Debt Service 4,002,000 2,937,641 73%4,502,000 Transfer To Reserves 417,000 - 0%417,000 Total Expenses 24,047,000$ 10,202,238$ 42%24,842,500$ Net -$ 4,394,131$ -$ 4 WATER SALES ANALYSIS Tier 1 $0 Tier 2 $150,000 Tier 3 $350,000 Projected Revenue Increase in Sales 5 Residential SFR $125,000 Multi-Family $75,000 Commercial $150,000 Irrigation $150,000 Projected Revenue Increase in Sales WATER SALES ANALYSIS WASTEWATER FUND SUMMARY 6 Revenue Budget YTD Actual YTD %Projected Collection System Charges 4,545,000$ 2,352,192$ 52%4,545,000$ Treatment Charges 7,900,000 4,379,006 55%7,900,000 Other Charges / Revenue 132,000 47,587 36%132,000 Total Revenue 12,577,000$ 6,778,785$ 54%12,577,000$ Expenses Budget YTD Actual YTD %Projected Labor & Benefits 2,087,400$ 1,005,361$ 48%2,087,400$ Other Operating Expenses 9,383,600 4,993,272 53%9,383,600 Capital Expenditures 793,000 655,195 83%693,000 Debt Service 313,000 204,863 65%313,000 Transfer from Reserves (478,000) - 0%(478,000) Total Expenses 12,099,000$ 6,858,690$ 57%11,999,000$ Net 478,000$ (79,905)$ 578,000$ PROGRAM SUMMARIES 8 GENERAL ADMINISTRATION GOAL % COMPLETE Provide Administrative Support to the Governing Board 50 Reduce Expenditures on Document Storage and Improve Records Management 70 Promote Environmental Stewardship 70 Ensure Programs Remain in Compliance with Public Record Requirements 60 65% BUDGET FY 2017-18 YTD PROJECTED FY 2017-18 % CHANGE $1,201,000 $730,736 $1,306,000 8.74% 9 HUMAN RESOURCES GOAL % COMPLETE Promote a Positive Organizational Culture 75 Enhance the District’s Wellness Initiatives 85 Develop a Workforce Readiness Program 60 Implement a District Volunteer Program 45 70% BUDGET FY 2017-18 YTD PROJECTED FY 2017-18 % CHANGE $845,000 $492,537 $870,000 2.96% 10 PUBLIC AFFAIRS GOAL % COMPLETE Implement Outreach Efforts that Support the Brand and Develop Community Presence 50 Cultivate Customer Relationships and Strengthen the District’s Presence in the Community 58 Maintain the District’s Emergency Preparedness Standards 48 55% BUDGET FY 2017-18 YTD PROJECTED FY 2017-18 % CHANGE $828,000 $317,072 $868,000 4.83% 11 CONSERVATION GOAL % COMPLETE Maintain Compliance with SWRCB Conservation Standards 67 Continue Water Conservation Outreach with the Community 61 Evaluate and Measure Success of Rebate Programs 52 60% BUDGET FY 2017-18 YTD PROJECTED FY 2017-18 % CHANGE $575,000 $186,295 $575,000 0.00% 12 FINANCE GOAL % COMPLETE Engage Stakeholders in Planning for Use of Public Funds 90 Enhance Financial Reporting to Internal / External Stakeholders 13 Maintain Strong Financial Position and Credit Rating 38 Integrate Systems to Enhance Financial Planning 75 55% BUDGET FY 2017-18 YTD PROJECTED FY 2017-18 % CHANGE $1,182,000 $553,016 $1,187,000 0.42% 13 INFORMATION TECHNOLOGY GOAL % COMPLETE Improve Cybersecurity 63 Increase Utilization of Existing Technology 70 Secure, Reliable Technology Infrastructure 33 60% BUDGET FY 2017-18 YTD PROJECTED FY 2017-18 % CHANGE $963,000 $431,817 $963,000 0.00% 14 CUSTOMER SERVICE GOAL % COMPLETE Strive for World Class Public Service 50 Improve Departmental Processes 50 Promote Customer Use of Most Cost Effective Processes 67 60% BUDGET FY 2017-18 YTD PROJECTED FY 2017-18 % CHANGE $1,749,000 $828,840 $1,764,000 0.86% 15 METER SERVICES GOAL % COMPLETE Become Proficient in New AMI Meter Reading Equipment and Processes 58 Collect Information on Existing Meters to Facilitate Future Phases of AMI Implementation 88 Provide Highly Professional and Timely Response to Customer Service Requests 50 70% BUDGET FY 2017-18 YTD PROJECTED FY 2017-18 % CHANGE $397,000 $186,986 $400,000 0.76% 16 ENGINEERING GOAL % COMPLETE Provide Leadership in the Development and Implementation of the District’s CIP 21 Partner with Other Agencies to Benefit District and Region 44 Implement Modernization Programs and/or Software to Track Customer Service Efficiency 43 40% BUDGET FY 2017-18 YTD PROJECTED FY 2017-18 % CHANGE $1,527,000 $655,178 $1,527,000 0.00% 17 WATER PRODUCTION GOAL % COMPLETE Ensure System Reliability Through Routine System Inspections and Testing 55 Continue to Evaluate SCADA Network and Implement Improvements 88 Partner with Southern California Edison to Take Advantage of Equipment Rehabilitation Incentives 70 75% BUDGET FY 2017-18 YTD PROJECTED FY 2017-18 % CHANGE $4,072,000 $1,597,872 $4,072,000 0.00% 18 WATER TREATMENT GOAL % COMPLETE Identify Plant 134 Process Improvements to Enhance Water Quality 76 Evaluate Use of Hydro-Generation Technology at Plant 134 37 Develop Standard Operating Procedures for Hydro-Generation Plant 38 55% BUDGET FY 2017-18 YTD PROJECTED FY 2017-18 % CHANGE $890,000 $381,262 $1,038,000 16.63% 19 WATER QUALITY GOAL % COMPLETE Provide Safe and Reliable Water to Customers •Complete State Required Sampling •Collect Source Water Quality Data •Pilot Studies of Advanced Treatment Processes 54 Convert Flush-Outs to Control Water Discharge 40 Evaluate Effectiveness of New Backflow Program 50 50% BUDGET FY 2017-18 YTD PROJECTED FY 2017-18 % CHANGE $410,000 $177,514 $415,000 1.22% 20 WATER MAINTENANCE GOAL % COMPLETE Evaluate Preventative Maintenance Programs for Effectiveness 38 Partner with Other Local Agencies to Enhance Service to the Community 80 Encourage Continued Education to Support Advancement Opportunities 75 65% BUDGET FY 2017-18 YTD PROJECTED FY 2017-18 % CHANGE $2,241,000 $1,198,301 $2,211,000 -1.34% 21 WASTEWATER MAINTENANCE GOAL % COMPLETE Utilize Granite Net Software to Document Wastewater Collection System Maintenance 50 Begin Evaluation of Fats, Oil, and Grease (FOG) Entering the Wastewater Collection System 31 Continue to Improve Wastewater Collection System Maintenance Program 45 45% BUDGET FY 2017-18 YTD PROJECTED FY 2017-18 % CHANGE $8,593,000 $4,644,809 $8,625,000 0.37% 22 FACILITIES MAINTENANCE GOAL % COMPLETE Explore Alternative Energy Solutions for District Facilities 75 Continue Facilities Improvement Planning 65 Develop Comprehensive Facilities Preventative Maintenance Program 8 50% BUDGET FY 2017-18 YTD PROJECTED FY 2017-18 % CHANGE $776,000 $386,183 $816,000 5.15% 23 FLEET MAINTENANCE GOAL % COMPLETE Ensure Readiness Equipment and Staff for Emergency Responses 50 Develop Cost Recovery Program for Vehicle Replacement 40 Identify and Utilize Most Cost Effective Maintenance Methods 75 55% BUDGET FY 2017-18 YTD PROJECTED FY 2017-18 % CHANGE $516,000 $271,351 $548,000 6.20% 24 GOVERNING BOARD GOAL % COMPLETE Provide Organization Direction and Set Expectations 70 Increase Community Involvement 50 Address Project Related Agenda Items Including SNRC 50 Continue Efforts to Enhance District Identity as a Regional Leader 50 55% BUDGET FY 2017-18 YTD PROJECTED FY 2017-18 % CHANGE $229,000 $67,005 $229,000 0.00% CAPITAL BUDGET CAPITAL OUTLAY CAPITAL OUTLAY 26 Multi-Year Rate Study Water/Wastewater Operating Revenue -$ -$ -$ Water Master Plan Update Water Operating Revenue 200,000 - 200,000 Wastewater Master Plan Update Wastewater Operating Revenue 135,000 - 135,000 Emergency Generator Water Operating Revenue 95,000 - 95,000 Furniture and Equipment Water/Wastewater Operating Revenue 41,000 - 41,000 Computer Hardware/Software Water/Wastewater Operating Revenue 70,000 - 70,000 Service Trucks Water Operating Revenue 145,000 - 145,000 Total 686,000$ -$ 686,000$ Project Funding Source Adjusted Budget Proposed Mid-Year Adjustment Projected Budget CAPITAL BUDGET CAPITAL IMPROVEMENT PROJECTS CIP –PROPOSED ADJUSTMENTS 28 AMI Meter Retrofit Program Water Operating Revenue 500,000$ 55,000$ 555,000$ Transmission Main - Plant 134 to Upper Zone Water Operating Revenue 2,085,000 - 2,085,000 Plant 134 THM Treatment / Sludge Removal Water Operating Revenue 650,000 - 650,000 Facility Rehabiliations Water Operating Revenue 225,000 - 225,000 Pumalo Casa/Taylor Road Pipeline Water Operating Revenue - 125,000 125,000 Wastewater Main Rehabilitation - 4th St Wastewater Operating Revenue 100,000 - 100,000 Total Proposed Mid-Year Adjustments 3,560,000 180,000 3,740,000 Project Funding Source Adjusted Budget Proposed Mid-Year Adjustment Projected Budget CIP –NO PROPOSED ADJUSTMENTS 29 Habitat Conservation Plan -$ -$ -$ Canal Zone Storage Reservoir Reserves, Developer Fees 630,000 - 630,000 Transmission Main - Plant 134 to Canal Zone - - - Plant 140 - Tank Recoating - - - Plant 9 - Forebay Repair Water Operating Revenue 350,000 - 350,000 Plant 59 - Tank Recoating Water Operating Revenue 250,000 - 250,000 Facilities Relocations Water Operating Revenue 100,000 - 100,000 Wastewater Main Replacement - Orange St Reserves 75,000 - 75,000 Wastewater Main Rehabilitation - Paloma Rd Phase II Wastewater Operating Revenue 105,000 - 105,000 Wastewater Main Replacement - Ferndale Ave Wastewater Operating Revenue 210,000 - 210,000 City Creek Manhole Reloaction Wastewater Operating Revenue 150,000 - 150,000 Sterling Natural Resource Center (SNRC) Water/Wastewater Operating Revenue, Reserves 675,000 - 675,000 3,560,000 180,000 3,740,000 Total 6,105,000$ 180,000$ 6,285,000$ Subtotal Proposed Mid-Year Adjustments Project Funding Source Adjusted Budget Projected Budget Proposed Mid-Year Adjustment STAFFING CHANGES 31 PROPOSED STAFFING CHANGES Department Current Position Proposed Position Administration Administrative Assistant Senior Administrative Assistant Public Affairs Public Affairs- Conservation Manager Director of Strategic Services Public Affairs Graphic Designer Creative Services Representative Finance Administrative Assistant Senior Administrative Assistant Engineering Engineering Technician II Associate Engineer *Proposed Adjustments are Reflected in Department Summaries ACCOMPLISHMENTS 33 ACCOMPLISHMENTS •AMI Project Phase I •Paloma and 4th Street Sewer Rehabilitation •North Fork Water Company Appraisal Report •CA Municipal Treasurer’s Association Investment Policy Certification •Popular Annual Financial Report •3rd Leadership Academy Class Graduation 34 AWARDS •Press Enterprise Top Workplace •GFOA Distinguished Budget •GFOA Comprehensive Annual Financial Reporting FY 2017-18 Budget FY 2017-18 Percent Budget YTD Activity Adjustment Projected Change Revenue 4100 - Water Sales 14,500,000.00 9,554,906.24 500,000.00 15,000,000.00 4200 - Meter Charges 8,845,000.00 4,471,715.19 - 8,845,000.00 4301 - Penalties 485,500.00 331,456.26 - 485,500.00 4400 - Wastewater Collection 4,545,000.00 2,352,192.40 - 4,545,000.00 4500 - Wastewater Treatment 7,900,000.00 4,379,006.44 - 7,900,000.00 4600 - Other Operating Charges 201,500.00 171,968.50 - 201,500.00 4700 - Investment Income 97,000.00 70,765.95 - 97,000.00 4703 - Energy Incentive Rebates - - - - 4704 - Miscellaneous Revenue 50,000.00 43,143.67 - 50,000.00 36,624,000.00 21,375,154.65 500,000.00 37,124,000.00 1.37% Program: 1000 - Board of Directors d of 51 - Labor 105,000.00 42,525.00 - 105,000.00 d of 52 - Temporary Labor - - - - d of 53 - Overtime - - - - d of 54 - Standby - - - - d of 56 - Benefits 57,000.00 16,224.85 - 57,000.00 d of 61 - Water Supply - - - - d of 62 - Materials and Supplies 1,000.00 - - 1,000.00 d of 63 - Contract Services 11,000.00 341.15 - 11,000.00 d of 64 - Utilities - - - - d of 65 - Professional Development 55,000.00 7,913.72 - 55,000.00 d of 67 - Other - - - - d of Total 229,000.00 67,004.72 - 229,000.00 0.00% Program: 2000 - General Administration ral A51 - Labor 486,000.00 206,183.80 5,000.00 491,000.00 ral A52 - Temporary Labor - - - - ral A53 - Overtime - 1,272.18 - - ral A54 - Standby - - - - ral A56 - Benefits 245,000.00 127,103.70 - 245,000.00 ral A61 - Water Supply - - - - ral A62 - Materials and Supplies 8,000.00 899.47 - 8,000.00 ral A63 - Contract Services 347,000.00 333,045.40 100,000.00 447,000.00 ral A64 - Utilities 3,000.00 1,566.57 - 3,000.00 ral A65 - Professional Development 112,000.00 60,665.35 - 112,000.00 ral A67 - Other - - - - ral A Total 1,201,000.00 730,736.47 105,000.00 1,306,000.00 8.74% Program: 2100 - Human Resources an R51 - Labor 211,000.00 96,703.58 - 211,000.00 an R52 - Temporary Labor 12,000.00 2,592.00 - 12,000.00 an R53 - Overtime 3,000.00 1,116.31 - 3,000.00 an R54 - Standby - - - - an R56 - Benefits 100,000.00 59,009.56 - 100,000.00 an R61 - Water Supply - - - - an R62 - Materials and Supplies 20,000.00 2,532.29 - 20,000.00 an R63 - Contract Services 89,000.00 41,807.22 25,000.00 114,000.00 an R64 - Utilities 1,000.00 314.51 - 1,000.00 an R65 - Professional Development 39,000.00 20,689.16 - 39,000.00 an R67 - Other 370,000.00 267,772.68 - 370,000.00 an R Total 845,000.00 492,537.31 25,000.00 870,000.00 2.96% DISTRICT WIDE FY 2017-18 MID-YEAR BUDGET REVIEW JULY 1, 2017 - DECEMBER 31, 2017 Page 1 of 15 FY 2017-18 Budget FY 2017-18 Percent Budget YTD Activity Adjustment Projected Change DISTRICT WIDE FY 2017-18 MID-YEAR BUDGET REVIEW JULY 1, 2017 - DECEMBER 31, 2017 Program: 2200 - Public Affairs c Aff51 - Labor 347,000.00 139,107.78 31,000.00 378,000.00 c Aff52 - Temporary Labor - - - - c Aff53 - Overtime 7,000.00 3,151.44 - 7,000.00 c Aff54 - Standby - - - - c Aff56 - Benefits 129,000.00 73,686.39 9,000.00 138,000.00 c Aff61 - Water Supply - - - - c Aff62 - Materials and Supplies 77,000.00 11,645.24 - 77,000.00 c Aff63 - Contract Services 206,000.00 80,183.84 - 206,000.00 c Aff64 - Utilities 35,000.00 879.78 - 35,000.00 c Aff65 - Professional Development 27,000.00 8,417.67 - 27,000.00 c Aff67 - Other - - - - c Aff Total 828,000.00 317,072.14 40,000.00 868,000.00 4.83% Program: 2300 - Conservation erva51 - Labor 98,000.00 45,269.73 - 98,000.00 erva52 - Temporary Labor - - - - erva53 - Overtime 8,000.00 - - 8,000.00 erva54 - Standby - - - - erva56 - Benefits 32,000.00 24,164.61 - 32,000.00 erva61 - Water Supply - - - - erva62 - Materials and Supplies 223,000.00 107,839.51 - 223,000.00 erva63 - Contract Services 187,000.00 6,647.28 - 187,000.00 erva64 - Utilities 21,000.00 362.63 - 21,000.00 erva65 - Professional Development 6,000.00 2,011.00 - 6,000.00 erva67 - Other - - - - erva Total 575,000.00 186,294.76 - 575,000.00 0.00% Program: 3000 - Finance ce 51 - Labor 678,000.00 294,392.88 5,000.00 683,000.00 ce 52 - Temporary Labor - - - - ce 53 - Overtime 10,000.00 2,607.93 - 10,000.00 ce 54 - Standby - - - - ce 56 - Benefits 287,000.00 162,085.04 - 287,000.00 ce 61 - Water Supply - - - - ce 62 - Materials and Supplies 11,000.00 3,541.00 - 11,000.00 ce 63 - Contract Services 166,000.00 80,700.79 - 166,000.00 ce 64 - Utilities 4,000.00 1,169.33 - 4,000.00 ce 65 - Professional Development 25,000.00 7,869.39 - 25,000.00 ce 67 - Other 1,000.00 650.00 - 1,000.00 ce Total 1,182,000.00 553,016.36 5,000.00 1,187,000.00 0.42% Program: 3200 - Information Technology matio51 - Labor 313,000.00 143,089.19 - 313,000.00 matio52 - Temporary Labor - - - - matio53 - Overtime - - - - matio54 - Standby - - - - matio56 - Benefits 129,000.00 73,931.47 - 129,000.00 matio61 - Water Supply - - - - matio62 - Materials and Supplies 36,000.00 45,552.84 - 36,000.00 matio63 - Contract Services 462,000.00 160,410.91 - 462,000.00 matio64 - Utilities 6,000.00 1,590.02 - 6,000.00 matio65 - Professional Development 17,000.00 7,242.63 - 17,000.00 matio67 - Other - - - - matio Total 963,000.00 431,817.06 - 963,000.00 0.00% Page 2 of 15 FY 2017-18 Budget FY 2017-18 Percent Budget YTD Activity Adjustment Projected Change DISTRICT WIDE FY 2017-18 MID-YEAR BUDGET REVIEW JULY 1, 2017 - DECEMBER 31, 2017 Program: 3300 - Customer Service me 51 - Labor 472,000.00 223,709.62 - 472,000.00 me 52 - Temporary Labor 3,000.00 - - 3,000.00 me 53 - Overtime 5,000.00 2,761.81 - 5,000.00 me 54 - Standby - - - - me 56 - Benefits 242,000.00 158,179.23 - 242,000.00 me 61 - Water Supply - - - - me 62 - Materials and Supplies 12,000.00 3,054.16 - 12,000.00 me 63 - Contract Services 841,000.00 381,224.65 15,000.00 856,000.00 me 64 - Utilities 157,000.00 55,971.62 - 157,000.00 me 65 - Professional Development 17,000.00 510.57 - 17,000.00 me 67 - Other - 3,428.16 - - me Total 1,749,000.00 828,839.82 15,000.00 1,764,000.00 0.86% Program: 3400 - Meter Service Se 51 - Labor 228,000.00 102,277.68 - 228,000.00 Se 52 - Temporary Labor - - - - Se 53 - Overtime 20,000.00 3,093.01 - 20,000.00 Se 54 - Standby - - - - Se 56 - Benefits 135,000.00 75,096.09 - 135,000.00 Se 61 - Water Supply - - - - Se 62 - Materials and Supplies 4,000.00 755.36 - 4,000.00 Se 63 - Contract Services 8,000.00 5,418.54 3,000.00 11,000.00 Se 64 - Utilities 2,000.00 345.72 - 2,000.00 Se 65 - Professional Development - - - - Se 67 - Other - - - - Se Total 397,000.00 186,986.40 3,000.00 400,000.00 0.76% Program: 4000 - Engineering eer 51 - Labor 712,000.00 296,188.08 - 712,000.00 eer 52 - Temporary Labor - - - - eer 53 - Overtime 2,000.00 809.94 - 2,000.00 eer 54 - Standby - - - - eer 56 - Benefits 350,000.00 195,946.00 - 350,000.00 eer 61 - Water Supply - - - - eer 62 - Materials and Supplies 24,000.00 2,007.65 - 24,000.00 eer 63 - Contract Services 286,000.00 116,433.37 - 286,000.00 eer 64 - Utilities 123,000.00 40,453.61 - 123,000.00 eer 65 - Professional Development 30,000.00 3,339.08 - 30,000.00 eer 67 - Other - - - - eer Total 1,527,000.00 655,177.73 - 1,527,000.00 0.00% Program: 5000 - Water Production r Pr 51 - Labor 670,000.00 287,326.23 - 670,000.00 r Pr 52 - Temporary Labor - - - - r Pr 53 - Overtime 36,000.00 26,404.73 - 36,000.00 r Pr 54 - Standby 20,000.00 7,060.00 - 20,000.00 r Pr 56 - Benefits 270,000.00 165,725.25 - 270,000.00 r Pr 61 - Water Supply 801,000.00 647.15 - 801,000.00 r Pr 62 - Materials and Supplies 279,000.00 106,504.21 - 279,000.00 r Pr 63 - Contract Services 367,000.00 227,648.35 - 367,000.00 r Pr 64 - Utilities 1,614,000.00 772,753.10 - 1,614,000.00 r Pr 65 - Professional Development 15,000.00 3,802.71 - 15,000.00 r Pr 67 - Other - - - - r Pr Total 4,072,000.00 1,597,871.73 - 4,072,000.00 0.00% Page 3 of 15 FY 2017-18 Budget FY 2017-18 Percent Budget YTD Activity Adjustment Projected Change DISTRICT WIDE FY 2017-18 MID-YEAR BUDGET REVIEW JULY 1, 2017 - DECEMBER 31, 2017 Program: 5100 - Water Treatment r Tre51 - Labor 237,000.00 105,968.92 - 237,000.00 r Tre52 - Temporary Labor - - - - r Tre53 - Overtime 10,000.00 6,663.46 8,000.00 18,000.00 r Tre54 - Standby - - - - r Tre56 - Benefits 92,000.00 57,508.33 - 92,000.00 r Tre61 - Water Supply - - - - r Tre62 - Materials and Supplies 165,000.00 46,281.59 - 165,000.00 r Tre63 - Contract Services 186,000.00 113,469.97 140,000.00 326,000.00 r Tre64 - Utilities 200,000.00 51,370.14 - 200,000.00 r Tre65 - Professional Development - - - - r Tre67 - Other - - - - r Tre Total 890,000.00 381,262.41 148,000.00 1,038,000.00 16.63% Program: 5200 - Water Quality r Qu51 - Labor 176,000.00 79,631.08 - 176,000.00 r Qu52 - Temporary Labor - - - - r Qu53 - Overtime 10,000.00 5,165.64 5,000.00 15,000.00 r Qu54 - Standby - - - - r Qu56 - Benefits 76,000.00 44,061.66 - 76,000.00 r Qu61 - Water Supply - - - - r Qu62 - Materials and Supplies 18,000.00 5,921.67 - 18,000.00 r Qu63 - Contract Services 120,000.00 41,781.97 - 120,000.00 r Qu64 - Utilities 2,000.00 844.55 - 2,000.00 r Qu65 - Professional Development 8,000.00 107.92 - 8,000.00 r Qu67 - Other - - - - r Qu Total 410,000.00 177,514.49 5,000.00 415,000.00 1.22% Program: 6000 - Field Maintenance Administration Mai 51 - Labor 114,000.00 67,905.32 - 114,000.00 Mai 52 - Temporary Labor - - - - Mai 53 - Overtime - 9,044.60 15,000.00 15,000.00 Mai 54 - Standby 20,000.00 10,966.59 - 20,000.00 Mai 56 - Benefits 45,000.00 35,029.88 - 45,000.00 Mai 61 - Water Supply - - - - Mai 62 - Materials and Supplies 3,000.00 16,372.66 - 3,000.00 Mai 63 - Contract Services - - - - Mai 64 - Utilities 21,000.00 7,353.93 - 21,000.00 Mai 65 - Professional Development 17,000.00 8,368.31 - 17,000.00 Mai 67 - Other - - - - Mai Total 220,000.00 155,041.29 15,000.00 235,000.00 6.82% Program: 6100 - Water Maintenance r Ma51 - Labor 784,000.00 338,618.97 - 784,000.00 r Ma52 - Temporary Labor - - - - r Ma53 - Overtime 150,000.00 75,075.85 (45,000.00) 105,000.00 r Ma54 - Standby - - - - r Ma56 - Benefits 417,000.00 236,520.43 - 417,000.00 r Ma61 - Water Supply - - - - r Ma62 - Materials and Supplies 221,000.00 219,847.82 - 221,000.00 r Ma63 - Contract Services 449,000.00 149,903.03 - 449,000.00 r Ma64 - Utilities - 23,293.74 - - r Ma65 - Professional Development - - - - r Ma67 - Other - - - - r Ma Total 2,021,000.00 1,043,259.84 (45,000.00) 1,976,000.00 -2.23% Page 4 of 15 FY 2017-18 Budget FY 2017-18 Percent Budget YTD Activity Adjustment Projected Change DISTRICT WIDE FY 2017-18 MID-YEAR BUDGET REVIEW JULY 1, 2017 - DECEMBER 31, 2017 Program: 6200 - Wastewater Maintenance ewa 51 - Labor 280,000.00 117,013.84 - 280,000.00 ewa 52 - Temporary Labor - - - - ewa 53 - Overtime 3,000.00 25,594.39 32,000.00 35,000.00 ewa 54 - Standby - - - - ewa 56 - Benefits 144,000.00 82,003.95 - 144,000.00 ewa 61 - Water Supply - - - - ewa 62 - Materials and Supplies 35,000.00 20,837.13 - 35,000.00 ewa 63 - Contract Services 8,131,000.00 4,399,359.70 - 8,131,000.00 ewa 64 - Utilities - - - - ewa 65 - Professional Development - - - - ewa 67 - Other - - - - ewa Total 8,593,000.00 4,644,809.01 32,000.00 8,625,000.00 0.37% Program: 7000 - Facilities Maintenance ties 51 - Labor 97,000.00 44,568.83 - 97,000.00 ties 52 - Temporary Labor - - - - ties 53 - Overtime 25,000.00 8,793.22 - 25,000.00 ties 54 - Standby - - - - ties 56 - Benefits 44,000.00 26,774.58 - 44,000.00 ties 61 - Water Supply - - - - ties 62 - Materials and Supplies 42,000.00 20,371.26 - 42,000.00 ties 63 - Contract Services 347,000.00 207,866.10 40,000.00 387,000.00 ties 64 - Utilities 221,000.00 77,808.83 - 221,000.00 ties 65 - Professional Development - - - - ties 67 - Other - - - - ties Total 776,000.00 386,182.82 40,000.00 816,000.00 5.15% Program: 7100 - Fleet Maintenance Mai 51 - Labor 164,000.00 74,824.47 - 164,000.00 Mai 52 - Temporary Labor - - - - Mai 53 - Overtime 3,000.00 847.93 - 3,000.00 Mai 54 - Standby - - - - Mai 56 - Benefits 79,000.00 48,032.09 - 79,000.00 Mai 61 - Water Supply - - - - Mai 62 - Materials and Supplies 63,000.00 37,545.62 - 63,000.00 Mai 63 - Contract Services 75,000.00 61,610.13 32,000.00 107,000.00 Mai 64 - Utilities 126,000.00 48,430.89 - 126,000.00 Mai 65 - Professional Development 6,000.00 60.00 - 6,000.00 Mai 67 - Other - - - - Mai Total 516,000.00 271,351.13 32,000.00 548,000.00 6.20% Total Operating Expenses 26,994,000.00 13,106,775.49 420,000.00 27,414,000.00 Other Expenses al 71 - Debt Service 4,315,000.00 3,142,504.00 500,000.00 4,815,000.00 al 81 - Capital Improvement 4,287,000.00 659,817.25 (420,000.00) 3,867,000.00 al 82 - Capital Outlay 611,000.00 151,831.43 - 611,000.00 al 88 - Transfer from Reserves 417,000.00 - - 417,000.00 al Total 9,630,000.00 3,954,152.68 80,000.00 9,710,000.00 0.83% Net - 4,314,226.48 - - Page 5 of 15 FY 2017-18 Budget FY 2017-18 Percent Budget YTD Activity Adjustment Projected Change Revenue 4100 - Water Sales 14,500,000.00 9,554,906.24 500,000.00 15,000,000.00 4200 - Meter Charges 8,845,000.00 4,471,715.19 - 8,845,000.00 4301 - Penalties 445,500.00 309,034.66 - 445,500.00 4400 - Wastewater Collection - - 4500 - Wastewater Treatment - - 4600 - Other Operating Charges 131,500.00 166,968.50 - 131,500.00 4700 - Investment Income 75,000.00 50,600.98 - 75,000.00 4703 - Energy Incentive Rebates - - - - 4704 - Miscellaneous Revenue 50,000.00 43,143.67 - 50,000.00 24,047,000.00 14,596,369.24 500,000.00 24,547,000.00 2.08% Program: 1000 - Board of Directors min 51 - Labor 73,500.00 29,767.50 - 73,500.00 min 52 - Temporary Labor - - - - min 53 - Overtime - - - - min 54 - Standby - - - - min 56 - Benefits 39,900.00 11,357.39 - 39,900.00 min 61 - Water Supply - - - - min 62 - Materials and Supplies 700.00 - - 700.00 min 63 - Contract Services 7,700.00 238.80 - 7,700.00 min 64 - Utilities - - - - min 65 - Professional Development 38,500.00 5,947.93 - 38,500.00 min 67 - Other - - - - min Total 160,300.00 47,311.62 - 160,300.00 0.00% Program: 2000 - General Administration min 51 - Labor 340,200.00 144,347.19 3,500.00 343,700.00 min 52 - Temporary Labor - - - - min 53 - Overtime - 890.52 - - min 54 - Standby - - - - min 56 - Benefits 171,500.00 96,179.35 - 171,500.00 min 61 - Water Supply - - - - min 62 - Materials and Supplies 5,600.00 629.61 - 5,600.00 min 63 - Contract Services 242,900.00 232,723.76 70,000.00 312,900.00 min 64 - Utilities 2,100.00 1,096.59 - 2,100.00 min 65 - Professional Development 78,400.00 42,465.73 - 78,400.00 min 67 - Other - - - - min Total 840,700.00 518,332.75 73,500.00 914,200.00 8.74% Program: 2100 - Human Resources min 51 - Labor 147,700.00 67,692.47 - 147,700.00 min 52 - Temporary Labor 8,400.00 1,814.40 - 8,400.00 min 53 - Overtime 2,100.00 781.42 - 2,100.00 min 54 - Standby - - - - min 56 - Benefits 70,000.00 41,652.03 - 70,000.00 min 61 - Water Supply - - - - min 62 - Materials and Supplies 14,000.00 1,772.60 - 14,000.00 min 63 - Contract Services 62,300.00 29,265.04 17,500.00 79,800.00 min 64 - Utilities 700.00 220.18 - 700.00 min 65 - Professional Development 27,300.00 14,482.41 - 27,300.00 min 67 - Other 259,000.00 187,440.92 - 259,000.00 min Total 591,500.00 345,121.47 17,500.00 609,000.00 2.96% WATER FUND FY 2017-18 MID-YEAR BUDGET REVIEW JULY 1, 2017 - DECEMBER 31, 2017 Page 6 of 15 FY 2017-18 Budget FY 2017-18 Percent Budget YTD Activity Adjustment Projected Change WATER FUND FY 2017-18 MID-YEAR BUDGET REVIEW JULY 1, 2017 - DECEMBER 31, 2017 Program: 2200 - Public Affairs min 51 - Labor 173,500.00 69,995.86 15,500.00 189,000.00 min 52 - Temporary Labor - - - - min 53 - Overtime 3,500.00 1,575.76 - 3,500.00 min 54 - Standby - - - - min 56 - Benefits 64,500.00 37,081.38 4,500.00 69,000.00 min 61 - Water Supply - - - - min 62 - Materials and Supplies 38,500.00 5,451.42 - 38,500.00 min 63 - Contract Services 103,000.00 40,211.93 - 103,000.00 min 64 - Utilities 17,500.00 439.91 - 17,500.00 min 65 - Professional Development 13,500.00 4,321.32 - 13,500.00 min 67 - Other - - - - min Total 414,000.00 159,077.58 20,000.00 434,000.00 4.83% Program: 2300 - Conservation min 51 - Labor 98,000.00 45,269.73 - 98,000.00 min 52 - Temporary Labor - - - - min 53 - Overtime 8,000.00 - - 8,000.00 min 54 - Standby - - - - min 56 - Benefits 32,000.00 24,164.61 - 32,000.00 min 61 - Water Supply - - - - min 62 - Materials and Supplies 223,000.00 107,839.51 - 223,000.00 min 63 - Contract Services 187,000.00 6,647.28 - 187,000.00 min 64 - Utilities 21,000.00 362.63 - 21,000.00 min 65 - Professional Development 6,000.00 2,011.00 - 6,000.00 min 67 - Other - - - - min Total 575,000.00 186,294.76 - 575,000.00 0.00% Program: 3000 - Finance min 51 - Labor 474,600.00 206,162.72 3,500.00 478,100.00 min 52 - Temporary Labor - - - - min 53 - Overtime 7,000.00 1,825.57 - 7,000.00 min 54 - Standby - - - - min 56 - Benefits 200,900.00 113,519.83 - 200,900.00 min 61 - Water Supply - - - - min 62 - Materials and Supplies 7,700.00 2,478.69 - 7,700.00 min 63 - Contract Services 116,200.00 56,588.23 - 116,200.00 min 64 - Utilities 2,800.00 818.54 - 2,800.00 min 65 - Professional Development 17,500.00 5,508.57 - 17,500.00 min 67 - Other 1,000.00 650.00 - 1,000.00 min Total 827,700.00 387,552.15 3,500.00 831,200.00 0.42% Program: 3200 - Information Technology min 51 - Labor 219,100.00 100,162.40 - 219,100.00 min 52 - Temporary Labor - - - - min 53 - Overtime - - - - min 54 - Standby - - - - min 56 - Benefits 90,300.00 51,752.59 - 90,300.00 min 61 - Water Supply - - - - min 62 - Materials and Supplies 25,200.00 31,886.99 - 25,200.00 min 63 - Contract Services 323,400.00 112,287.62 - 323,400.00 min 64 - Utilities 4,200.00 1,113.02 - 4,200.00 min 65 - Professional Development 11,900.00 5,069.83 - 11,900.00 min 67 - Other - - - - min Total 674,100.00 302,272.45 - 674,100.00 0.00% Page 7 of 15 FY 2017-18 Budget FY 2017-18 Percent Budget YTD Activity Adjustment Projected Change WATER FUND FY 2017-18 MID-YEAR BUDGET REVIEW JULY 1, 2017 - DECEMBER 31, 2017 Program: 3300 - Customer Service stom51 - Labor 330,400.00 151,557.32 - 330,400.00 stom52 - Temporary Labor 2,100.00 - - 2,100.00 stom53 - Overtime 3,500.00 1,927.74 - 3,500.00 stom54 - Standby - - - - stom56 - Benefits 169,400.00 108,031.53 - 169,400.00 stom61 - Water Supply - - - - stom62 - Materials and Supplies 8,400.00 2,137.91 - 8,400.00 stom63 - Contract Services 696,400.00 308,869.27 10,500.00 706,900.00 stom64 - Utilities 109,900.00 39,180.14 - 109,900.00 stom65 - Professional Development 12,500.00 389.29 - 12,500.00 stom67 - Other - 3,432.26 - - stom Total 1,332,600.00 615,525.46 10,500.00 1,343,100.00 0.79% Program: 3400 - Meter Service stom51 - Labor 228,000.00 102,277.68 - 228,000.00 stom52 - Temporary Labor - - - - stom53 - Overtime 20,000.00 3,093.01 - 20,000.00 stom54 - Standby - - - - stom56 - Benefits 135,000.00 75,096.09 - 135,000.00 stom61 - Water Supply - - - - stom62 - Materials and Supplies 4,000.00 755.36 - 4,000.00 stom63 - Contract Services 8,000.00 5,418.54 3,000.00 11,000.00 stom64 - Utilities 2,000.00 345.72 - 2,000.00 stom65 - Professional Development - - - - min 67 - Other - - - - min Total 397,000.00 186,986.40 3,000.00 400,000.00 0.76% Program: 4000 - Engineering min 51 - Labor 498,400.00 213,898.79 - 498,400.00 min 52 - Temporary Labor - - - - min 53 - Overtime 1,400.00 566.98 - 1,400.00 min 54 - Standby - - - - min 56 - Benefits 245,000.00 137,162.77 - 245,000.00 min 61 - Water Supply - - - - min 62 - Materials and Supplies 16,800.00 1,873.28 - 16,800.00 min 63 - Contract Services 200,200.00 104,654.75 - 200,200.00 min 64 - Utilities 86,100.00 27,740.59 - 86,100.00 min 65 - Professional Development 21,000.00 2,747.24 - 21,000.00 min 67 - Other - - - - min Total 1,068,900.00 488,644.40 - 1,068,900.00 0.00% Program: 5000 - Water Production min 51 - Labor 670,000.00 287,326.23 - 670,000.00 min 52 - Temporary Labor - - - - min 53 - Overtime 36,000.00 26,404.73 - 36,000.00 min 54 - Standby 20,000.00 7,060.00 - 20,000.00 min 56 - Benefits 270,000.00 165,725.25 - 270,000.00 min 61 - Water Supply 801,000.00 647.15 - 801,000.00 min 62 - Materials and Supplies 279,000.00 106,504.21 - 279,000.00 min 63 - Contract Services 367,000.00 227,648.35 - 367,000.00 min 64 - Utilities 1,614,000.00 772,753.10 - 1,614,000.00 min 65 - Professional Development 15,000.00 3,802.71 - 15,000.00 min 67 - Other - - - - min Total 4,072,000.00 1,597,871.73 - 4,072,000.00 0.00% Page 8 of 15 FY 2017-18 Budget FY 2017-18 Percent Budget YTD Activity Adjustment Projected Change WATER FUND FY 2017-18 MID-YEAR BUDGET REVIEW JULY 1, 2017 - DECEMBER 31, 2017 Program: 5100 - Water Treatment 51 - Labor 237,000.00 105,968.92 - 237,000.00 52 - Temporary Labor - - - - 53 - Overtime 10,000.00 6,663.46 8,000.00 18,000.00 54 - Standby - - - - 56 - Benefits 92,000.00 57,508.33 - 92,000.00 61 - Water Supply - - - - 62 - Materials and Supplies 165,000.00 46,281.59 - 165,000.00 63 - Contract Services 186,000.00 113,469.97 140,000.00 326,000.00 64 - Utilities 200,000.00 51,370.14 - 200,000.00 65 - Professional Development - - - - 67 - Other - - - - Total 890,000.00 381,262.41 148,000.00 1,038,000.00 16.63% Program: 5200 - Water Quality 51 - Labor 176,000.00 79,631.08 - 176,000.00 52 - Temporary Labor - - - - 53 - Overtime 10,000.00 5,165.64 5,000.00 15,000.00 54 - Standby - - - - 56 - Benefits 76,000.00 44,061.66 - 76,000.00 61 - Water Supply - - - - 62 - Materials and Supplies 18,000.00 5,921.67 - 18,000.00 63 - Contract Services 120,000.00 41,781.97 - 120,000.00 64 - Utilities 2,000.00 844.55 - 2,000.00 65 - Professional Development 8,000.00 107.92 - 8,000.00 67 - Other - - - - Total 410,000.00 177,514.49 5,000.00 415,000.00 1.22% Program: 6000 - Field Maintenance Administration min 51 - Labor 102,600.00 58,342.42 - 102,600.00 min 52 - Temporary Labor - - - - min 53 - Overtime - 7,866.06 15,000.00 15,000.00 min 54 - Standby 18,000.00 8,646.59 - 18,000.00 min 56 - Benefits 40,500.00 30,366.24 - 40,500.00 min 61 - Water Supply - - - - min 62 - Materials and Supplies 2,700.00 16,363.91 - 2,700.00 min 63 - Contract Services - - - - min 64 - Utilities 18,900.00 6,618.54 - 18,900.00 min 65 - Professional Development 15,300.00 7,993.98 - 15,300.00 min 67 - Other - - - - min Total 198,000.00 136,197.74 15,000.00 213,000.00 7.58% Program: 6100 - Water Maintenance D 51 - Labor 784,000.00 338,618.97 - 784,000.00 D 52 - Temporary Labor - - - - D 53 - Overtime 150,000.00 75,075.85 (45,000.00) 105,000.00 D 54 - Standby - - - - D 56 - Benefits 417,000.00 236,520.43 - 417,000.00 D 61 - Water Supply - - - - D 62 - Materials and Supplies 221,000.00 219,847.82 - 221,000.00 D 63 - Contract Services 449,000.00 149,903.03 - 449,000.00 D 64 - Utilities - 23,293.74 - - D 65 - Professional Development - - - - D 67 - Other - - - - D Total 2,021,000.00 1,043,259.84 (45,000.00) 1,976,000.00 -2.23% Page 9 of 15 FY 2017-18 Budget FY 2017-18 Percent Budget YTD Activity Adjustment Projected Change WATER FUND FY 2017-18 MID-YEAR BUDGET REVIEW JULY 1, 2017 - DECEMBER 31, 2017 Program: 6200 - Wastewater Maintenance D 51 - Labor - - - - D 52 - Temporary Labor - - - - D 53 - Overtime - - - - D 54 - Standby - - - - D 56 - Benefits - - - - D 61 - Water Supply - - - - D 62 - Materials and Supplies - - - - D 63 - Contract Services - - - - D 64 - Utilities - - - - D 65 - Professional Development - - - - D 67 - Other - - - - D Total - - - - 0.00% Program: 7000 - Facilities Maintenance min 51 - Labor 67,900.00 35,087.78 - 67,900.00 min 52 - Temporary Labor - - - - min 53 - Overtime 17,500.00 6,808.10 - 17,500.00 min 54 - Standby - - - - min 56 - Benefits 30,800.00 20,260.81 - 30,800.00 min 61 - Water Supply - - - - min 62 - Materials and Supplies 33,900.00 14,659.25 - 33,900.00 min 63 - Contract Services 276,500.00 178,700.06 40,000.00 316,500.00 min 64 - Utilities 159,200.00 54,644.91 - 159,200.00 min 65 - Professional Development - - - - min 67 - Other - - - - min Total 585,800.00 310,160.91 40,000.00 625,800.00 6.83% Program: 7100 - Fleet Maintenance min 51 - Labor 147,600.00 67,342.17 - 147,600.00 min 52 - Temporary Labor - - - - min 53 - Overtime 2,700.00 763.14 - 2,700.00 min 54 - Standby - - - - min 56 - Benefits 71,100.00 43,229.42 - 71,100.00 min 61 - Water Supply - - - - min 62 - Materials and Supplies 56,700.00 26,126.18 - 56,700.00 min 63 - Contract Services 67,500.00 43,653.89 29,000.00 96,500.00 min 64 - Utilities 113,400.00 43,587.79 - 113,400.00 min 65 - Professional Development 5,400.00 54.00 - 5,400.00 min 67 - Other - - - - min Total 464,400.00 224,756.59 29,000.00 493,400.00 6.24% Total Operating Expenses 15,523,000.00 7,108,142.75 320,000.00 15,843,000.00 Other Expenses 71 - Debt Service 4,002,000.00 2,937,641.00 500,000.00 4,502,000.00 81 - Capital Improvement 3,625,000.00 38,665.31 (320,000.00) 3,305,000.00 82 - Capital Outlay 480,000.00 117,788.73 480,000.00 88 - Transfer to Reserves 417,000.00 - 417,000.00 Total 8,524,000.00 3,094,095.04 180,000.00 8,704,000.00 2.11% Net - 4,394,131.45 - - Page 10 of 15 ` FY 2017-18 Budget FY 2017-18 Percent Budget YTD Activity Adjustment Projected Change Revenue 4100 - Water Sales - 4200 - Meter Charges - 4301 - Penalties 40,000.00 22,421.60 - 40,000.00 4400 - Wastewater Collection 4,545,000.00 2,352,192.40 4,545,000.00 4500 - Wastewater Treatment 7,900,000.00 4,379,006.44 7,900,000.00 4600 - Other Operating Charges 70,000.00 5,000.00 - 70,000.00 4700 - Investment Income 22,000.00 20,164.97 22,000.00 4703 - Energy Incentive Rebates - - - 4704 - Miscellaneous Revenue - - - 12,577,000.00 6,778,785.41 - 12,577,000.00 0.00% Program: 1000 - Board of Directors 51 - Labor 31,500.00 12,757.50 - 31,500.00 52 - Temporary Labor - - - - 53 - Overtime - - - - 54 - Standby - - - - 56 - Benefits 17,100.00 4,867.46 - 17,100.00 61 - Water Supply - - - - 62 - Materials and Supplies 300.00 - - 300.00 63 - Contract Services 3,300.00 102.35 - 3,300.00 64 - Utilities - - - - 65 - Professional Development 16,500.00 1,965.79 - 16,500.00 67 - Other - - - - Total 68,700.00 19,693.10 - 68,700.00 0.00% Program: 2000 - General Administration 51 - Labor 145,800.00 61,836.61 1,500.00 147,300.00 52 - Temporary Labor - - - - 53 - Overtime - 381.66 - - 54 - Standby - - - - 56 - Benefits 73,500.00 30,924.35 - 73,500.00 61 - Water Supply - - - - 62 - Materials and Supplies 2,400.00 269.86 - 2,400.00 63 - Contract Services 104,100.00 100,321.64 30,000.00 134,100.00 64 - Utilities 900.00 469.98 - 900.00 65 - Professional Development 33,600.00 18,199.62 - 33,600.00 67 - Other - - - - Total 360,300.00 212,403.72 31,500.00 391,800.00 8.74% Program: 2100 - Human Resources 51 - Labor 63,300.00 29,011.11 - 63,300.00 52 - Temporary Labor 3,600.00 777.60 - 3,600.00 53 - Overtime 900.00 334.89 - 900.00 54 - Standby - - - - 56 - Benefits 30,000.00 17,357.53 - 30,000.00 61 - Water Supply - - - - 62 - Materials and Supplies 6,000.00 759.69 - 6,000.00 63 - Contract Services 26,700.00 12,542.18 7,500.00 34,200.00 64 - Utilities 300.00 94.33 - 300.00 65 - Professional Development 11,700.00 6,206.75 - 11,700.00 67 - Other 111,000.00 80,331.76 - 111,000.00 Total 253,500.00 147,415.84 7,500.00 261,000.00 2.96% WASTEWATER FUND FY 2017-18 MID-YEAR BUDGET REVIEW JULY 1, 2017 - DECEMBER 31, 2017 Page 11 of 15 ` FY 2017-18 Budget FY 2017-18 Percent Budget YTD Activity Adjustment Projected Change WASTEWATER FUND FY 2017-18 MID-YEAR BUDGET REVIEW JULY 1, 2017 - DECEMBER 31, 2017 Program: 2200 - Public Affairs 51 - Labor 173,500.00 69,111.92 15,500.00 189,000.00 52 - Temporary Labor - - - - 53 - Overtime 3,500.00 1,575.68 - 3,500.00 54 - Standby - - - - 56 - Benefits 64,500.00 36,605.01 4,500.00 69,000.00 61 - Water Supply - - - - 62 - Materials and Supplies 38,500.00 6,193.82 - 38,500.00 63 - Contract Services 103,000.00 39,971.91 - 103,000.00 64 - Utilities 17,500.00 439.87 - 17,500.00 65 - Professional Development 13,500.00 4,096.35 - 13,500.00 67 - Other - - - - Total 414,000.00 157,994.56 20,000.00 434,000.00 4.83% Program: 2300 - Conservation 51 - Labor - - - - 52 - Temporary Labor - - - - 53 - Overtime - - - - 54 - Standby - - - - 56 - Benefits - - - - 61 - Water Supply - - - - 62 - Materials and Supplies - - - - 63 - Contract Services - - - - 64 - Utilities - - - - 65 - Professional Development - - - - 67 - Other - - - - Total - - - - 0.00% Program: 3000 - Finance 51 - Labor 203,400.00 88,230.16 1,500.00 204,900.00 52 - Temporary Labor - - - - 53 - Overtime 3,000.00 782.36 - 3,000.00 54 - Standby - - - - 56 - Benefits 86,100.00 48,565.21 - 86,100.00 61 - Water Supply - - - - 62 - Materials and Supplies 3,300.00 1,062.31 - 3,300.00 63 - Contract Services 49,800.00 24,112.56 - 49,800.00 64 - Utilities 1,200.00 350.79 - 1,200.00 65 - Professional Development 7,500.00 2,360.82 - 7,500.00 67 - Other - - - - Total 354,300.00 165,464.21 1,500.00 355,800.00 0.42% Program: 3200 - Information Technology 51 - Labor 93,900.00 42,926.79 - 93,900.00 52 - Temporary Labor - - - - 53 - Overtime - - - - 54 - Standby - - - - 56 - Benefits 38,700.00 22,178.88 - 38,700.00 61 - Water Supply - - - - 62 - Materials and Supplies 10,800.00 13,665.85 - 10,800.00 63 - Contract Services 138,600.00 48,123.29 - 138,600.00 64 - Utilities 1,800.00 477.00 - 1,800.00 65 - Professional Development 5,100.00 2,172.80 - 5,100.00 67 - Other - - - - Total 288,900.00 129,544.61 - 288,900.00 0.00% Page 12 of 15 ` FY 2017-18 Budget FY 2017-18 Percent Budget YTD Activity Adjustment Projected Change WASTEWATER FUND FY 2017-18 MID-YEAR BUDGET REVIEW JULY 1, 2017 - DECEMBER 31, 2017 Program: 3300 - Customer Service 51 - Labor 141,600.00 72,152.30 - 141,600.00 52 - Temporary Labor 900.00 - - 900.00 53 - Overtime 1,500.00 834.07 - 1,500.00 54 - Standby - - - - 56 - Benefits 72,600.00 50,147.70 - 72,600.00 61 - Water Supply - - - - 62 - Materials and Supplies 3,600.00 916.25 - 3,600.00 63 - Contract Services 144,600.00 72,355.38 4,500.00 149,100.00 64 - Utilities 47,100.00 16,791.48 - 47,100.00 65 - Professional Development 4,500.00 121.28 - 4,500.00 67 - Other - (4.10) - - Total 416,400.00 213,314.36 4,500.00 420,900.00 1.08% Program: 3400 - Meter Service 51 - Labor - - - - 52 - Temporary Labor - - - - 53 - Overtime - - - - 54 - Standby - - - - 56 - Benefits - - - - 61 - Water Supply - - - - 62 - Materials and Supplies - - - - 63 - Contract Services - - - - 64 - Utilities - - - - 65 - Professional Development - - - - 67 - Other - - - - Total - - - - 0.00% Program: 4000 - Engineering 51 - Labor 213,600.00 82,289.29 - 213,600.00 52 - Temporary Labor - - - - 53 - Overtime 600.00 242.96 - 600.00 54 - Standby - - - - 56 - Benefits 105,000.00 58,783.23 - 105,000.00 61 - Water Supply - - - - 62 - Materials and Supplies 7,200.00 134.37 - 7,200.00 63 - Contract Services 85,800.00 11,778.62 - 85,800.00 64 - Utilities 36,900.00 12,713.02 - 36,900.00 65 - Professional Development 9,000.00 591.84 - 9,000.00 67 - Other - - - - Total 458,100.00 166,533.33 - 458,100.00 0.00% Program: 5000 - Water Production 51 - Labor - - - - 52 - Temporary Labor - - - - 53 - Overtime - - - - 54 - Standby - - - - 56 - Benefits - - - - 61 - Water Supply - - - - 62 - Materials and Supplies - - - - 63 - Contract Services - - - - 64 - Utilities - - - - 65 - Professional Development - - - - 67 - Other - - - - Total - - - - 0.00% Page 13 of 15 ` FY 2017-18 Budget FY 2017-18 Percent Budget YTD Activity Adjustment Projected Change WASTEWATER FUND FY 2017-18 MID-YEAR BUDGET REVIEW JULY 1, 2017 - DECEMBER 31, 2017 Program: 5100 - Water Treatment 51 - Labor - - - - 52 - Temporary Labor - - - - 53 - Overtime - - - - 54 - Standby - - - - 56 - Benefits - - - - 61 - Water Supply - - - - 62 - Materials and Supplies - - - - 63 - Contract Services - - - - 64 - Utilities - - - - 65 - Professional Development - - - - 67 - Other - - - - Total - - - - 0.00% Program: 5200 - Water Quality 51 - Labor - - - - 52 - Temporary Labor - - - - 53 - Overtime - - - - 54 - Standby - - - - 56 - Benefits - - - - 61 - Water Supply - - - - 62 - Materials and Supplies - - - - 63 - Contract Services - - - - 64 - Utilities - - - - 65 - Professional Development - - - - 67 - Other - - - - Total - - - - 0.00% Program: 6000 - Field Maintenance Administration ation51 - Labor 11,400.00 9,562.90 - 11,400.00 ation52 - Temporary Labor - - - - ation53 - Overtime - 1,178.54 - - ation54 - Standby 2,000.00 2,320.00 - 2,000.00 ation56 - Benefits 4,500.00 4,663.64 - 4,500.00 ation61 - Water Supply - - - - ation62 - Materials and Supplies 300.00 8.75 - 300.00 ation63 - Contract Services - - - - ation64 - Utilities 2,100.00 735.39 - 2,100.00 ation65 - Professional Development 1,700.00 374.33 - 1,700.00 ation67 - Other - - - - ation Total 22,000.00 18,843.55 - 22,000.00 0.00% Program: 6100 - Water Maintenance 51 - Labor - - - - 52 - Temporary Labor - - - - 53 - Overtime - - - - 54 - Standby - - - - 56 - Benefits - - - - 61 - Water Supply - - - - 62 - Materials and Supplies - - - - 63 - Contract Services - - - - 64 - Utilities - - - - 65 - Professional Development - - - - 67 - Other - - - - Total - - - - 0.00% Page 14 of 15 ` FY 2017-18 Budget FY 2017-18 Percent Budget YTD Activity Adjustment Projected Change WASTEWATER FUND FY 2017-18 MID-YEAR BUDGET REVIEW JULY 1, 2017 - DECEMBER 31, 2017 Program: 6200 - Wastewater Maintenance 51 - Labor 280,000.00 117,013.84 - 280,000.00 52 - Temporary Labor - - - - 53 - Overtime 3,000.00 25,594.39 32,000.00 35,000.00 54 - Standby - - - - 56 - Benefits 144,000.00 82,003.95 - 144,000.00 61 - Water Supply - - - - 62 - Materials and Supplies 35,000.00 20,837.13 - 35,000.00 63 - Contract Services 8,131,000.00 4,399,359.70 - 8,131,000.00 64 - Utilities - - - - 65 - Professional Development - - - - 67 - Other - - - - Total 8,593,000.00 4,644,809.01 32,000.00 8,625,000.00 0.37% Program: 7000 - Facilities Maintenance 51 - Labor 29,100.00 9,481.05 - 29,100.00 52 - Temporary Labor - - - - 53 - Overtime 7,500.00 1,985.12 - 7,500.00 54 - Standby - - - - 56 - Benefits 13,200.00 6,513.77 - 13,200.00 61 - Water Supply - - - - 62 - Materials and Supplies 8,100.00 5,712.01 - 8,100.00 63 - Contract Services 70,500.00 29,166.04 - 70,500.00 64 - Utilities 61,800.00 23,163.92 - 61,800.00 65 - Professional Development - - - - 67 - Other - - - - Total 190,200.00 76,021.91 - 190,200.00 0.00% Program: 7100 - Fleet Maintenance 51 - Labor 16,400.00 7,482.30 - 16,400.00 52 - Temporary Labor - - - - 53 - Overtime 300.00 84.79 - 300.00 54 - Standby - - - - 56 - Benefits 7,900.00 4,802.67 - 7,900.00 61 - Water Supply - - - - 62 - Materials and Supplies 6,300.00 11,419.44 - 6,300.00 63 - Contract Services 7,500.00 17,956.24 3,000.00 10,500.00 64 - Utilities 12,600.00 4,843.10 - 12,600.00 65 - Professional Development 600.00 6.00 - 600.00 67 - Other - - - - Total 51,600.00 46,594.54 3,000.00 54,600.00 5.81% Total Operating Expenses 11,471,000.00 5,998,632.74 100,000.00 11,571,000.00 Other Expenses 71 - Debt Service 313,000.00 204,863.00 - 313,000.00 81 - Capital Improvement 662,000.00 621,151.94 (100,000.00) 562,000.00 82 - Capital Outlay 131,000.00 34,042.70 - 131,000.00 88 - Transfer to Reserves - - - - Total 1,106,000.00 860,057.64 (100,000.00) 1,006,000.00 -9.04% Net - (79,904.97) - - Page 15 of 15 Class Title Tier Range A B C D E A B C D E A B C D E Accountant G 31 35.75 36.65 37.56 38.50 39.47 6,197 6,353 6,510 6,673 6,841 74,360 76,232 78,125 80,080 82,098 Accounting Technician H 19 26.60 27.25 27.92 28.61 29.36 4,611 4,723 4,839 4,959 5,089 55,328 56,680 58,074 59,509 61,069 Administrative Assistant H 22 28.61 29.36 30.08 30.84 31.60 4,959 5,089 5,214 5,346 5,477 59,509 61,069 62,566 64,147 65,728 Associate Engineer P 40 44.65 45.76 46.92 48.09 49.29 7,739 7,932 8,133 8,336 8,544 92,872 95,181 97,594 100,027 102,523 Business Services Manager M 46 51.80 53.08 54.41 55.76 57.17 8,979 9,201 9,431 9,665 9,909 107,744 110,406 113,173 115,981 118,914 Chief Financial Officer E 66 84.85 86.97 89.15 91.38 93.66 14,707 15,075 15,453 15,839 16,234 176,488 180,898 185,432 190,070 194,813 Community Relations Intern PT Y 12.00 2,080 24,960 Community Relations Officer P 40 44.65 45.76 46.92 48.09 49.29 7,739 7,932 8,133 8,336 8,544 92,872 95,181 97,594 100,027 102,523 Conservation Coordinator G 35 39.47 40.46 41.47 42.50 43.57 6,841 7,013 7,188 7,367 7,552 82,098 84,157 86,258 88,400 90,626 Construction Project Coordinator M 36 40.46 41.47 42.50 43.57 44.65 7,013 7,188 7,367 7,552 7,739 84,157 86,258 88,400 90,626 92,872 *Construction Project Coordinator M Y 58.60 10,157 121,888 Creative Services Representative H 19 26.60 27.25 27.92 28.61 29.36 4,611 4,723 4,839 4,959 5,089 55,328 56,680 58,074 59,509 61,069 Customer Service Representative I H 11 21.83 22.37 22.93 23.50 24.09 3,784 3,877 3,975 4,073 4,176 45,406 46,530 47,694 48,880 50,107 Customer Service Representative II H 16 24.69 25.30 25.93 26.59 27.25 4,280 4,385 4,495 4,609 4,723 51,355 52,624 53,934 55,307 56,680 Customer Service Representative III H 19 26.60 27.25 27.92 28.61 29.36 4,611 4,723 4,839 4,959 5,089 55,328 56,680 58,074 59,509 61,069 Customer Service Supervisor P 39 43.57 44.65 45.76 46.92 48.09 7,552 7,739 7,932 8,133 8,336 90,626 92,872 95,181 97,594 100,027 Director of Engineering & Operations A 66 84.85 86.97 89.15 91.38 93.66 14,707 15,075 15,453 15,839 16,234 176,488 180,898 185,432 190,070 194,813 Director of Strategic Services E 57 67.94 69.65 71.39 73.17 75.00 11,776 12,073 12,374 12,683 13,000 141,315 144,872 148,491 152,194 156,000 District Clerk S 41 45.76 46.92 48.09 49.29 50.51 7,932 8,133 8,336 8,544 8,755 95,181 97,594 100,027 102,523 105,061 *District Clerk S Y 56.63 9,816 117,790 Engineering Technician II H 26 31.60 32.39 33.21 34.04 34.88 5,477 5,614 5,756 5,900 6,046 65,728 67,371 69,077 70,803 72,550 Environmental Coordinator P 40 44.65 45.76 46.92 48.09 49.29 7,739 7,932 8,133 8,336 8,544 92,872 95,181 97,594 100,027 102,523 A = At-Will PT = Part-Time * = E = Executive Management (Exempt) P = Professional/Supervisory (Exempt) S = Senior Management (Exempt) G = General/Confidential (Non-Exempt) M = Management (Exempt) H = Hourly-EVWDEP Represented (Non-Exempt) Y-Rate (Due to results of 2014 Compensation Analysis, base salary is set above the maximum for the range assigned) Hourly Salary Range Monthly Salary Range Annual Salary Range Steps Steps Steps SALARY SCHEDULE Effective March 5, 2018 Page 1 of 3 Class Title Tier Range A B C D E A B C D E A B C D E Equipment Mechanic II H 25 30.83 31.60 32.39 33.21 34.04 5,344 5,477 5,614 5,756 5,900 64,126 65,728 67,371 69,077 70,803 Equipment Mechanic III H 27 32.39 33.21 34.04 34.88 35.75 5,614 5,756 5,900 6,046 6,197 67,371 69,077 70,803 72,550 74,360 Facilities Maintenance Coordinator H 34 38.50 39.47 40.46 41.47 42.50 6,673 6,841 7,013 7,188 7,367 80,080 82,098 84,157 86,258 88,400 Field Service Representative H 22 28.61 29.36 30.08 30.84 31.60 4,959 5,089 5,214 5,346 5,477 59,509 61,069 62,566 64,147 65,728 Field Service Supervisor G 39 43.57 44.65 45.76 46.92 48.09 7,552 7,739 7,932 8,133 8,336 90,626 92,872 95,181 97,594 100,027 Field Service Worker I H 17 25.30 25.93 26.59 27.25 27.92 4,385 4,495 4,609 4,723 4,839 52,624 53,934 55,307 56,680 58,074 Field Service Worker II H 22 28.61 29.36 30.08 30.84 31.60 4,959 5,089 5,214 5,346 5,477 59,509 61,069 62,566 64,147 65,728 *Field Service Worker II H Y 32.24 5,588 67,059 Field Service Worker III H 25 30.83 31.60 32.39 33.21 34.04 5,344 5,477 5,614 5,756 5,900 64,126 65,728 67,371 69,077 70,803 General Manager/CEO A 128.80 HR, Risk & Safety Manager S 49 55.76 57.17 58.59 60.05 61.56 9,665 9,909 10,156 10,409 10,670 115,981 118,914 121,867 124,904 128,045 Information Systems Technician G 26 31.60 32.39 33.21 34.04 34.88 5,477 5,614 5,756 5,900 6,046 65,728 67,371 69,077 70,803 72,550 Information Technology Manager S 49 55.76 57.17 58.59 60.05 61.56 9,665 9,909 10,156 10,409 10,670 115,981 118,914 121,867 124,904 128,045 Meter Reader I H 14 23.50 24.09 24.69 25.30 25.93 4,073 4,176 4,280 4,385 4,495 48,880 50,107 51,355 52,624 53,934 Meter Reader II H 18 25.93 26.59 27.25 27.92 28.61 4,495 4,609 4,723 4,839 4,959 53,934 55,307 56,680 58,074 59,509 Network Administrator P 38 42.50 43.57 44.65 45.76 46.92 7,367 7,552 7,739 7,932 8,133 88,400 90,626 92,872 95,181 97,594 Operations Manager S 51 58.59 60.05 61.56 63.09 64.67 10,156 10,409 10,670 10,936 11,209 121,867 124,904 128,045 131,227 134,514 Public Affairs Events Coordinator PT Y 14.00 2,427 29,120 Public Affairs Specialist G 36 40.46 41.47 42.50 43.57 44.65 7,013 7,188 7,367 7,552 7,739 84,157 86,258 88,400 90,626 92,872 Receptionist H 8 20.27 20.78 21.30 21.83 22.37 3,513 3,602 3,692 3,784 3,877 42,162 43,222 44,304 45,406 46,530 *Receptionist H Y 24.57 4,259 51,106 A = At-Will PT = Part-Time * = E = Executive Management (Exempt) P = Professional/Supervisory (Exempt) S = Senior Management (Exempt) G = General/Confidential (Non-Exempt) M = Management (Exempt) H = Hourly-EVWDEP Represented (Non-Exempt) Y-Rate (Due to results of 2014 Compensation Analysis, base salary is set above the maximum for the range assigned) 22,325 267,903 Hourly Salary Range Monthly Salary Range Annual Salary Range Steps Steps Steps SALARY SCHEDULE Effective March 5, 2018 Page 2 of 3 Class Title Tier Range A B C D E A B C D E A B C D E Senior Accounting Technician H 23 29.36 30.08 30.84 31.60 32.39 5,089 5,214 5,346 5,477 5,614 61,069 62,566 64,147 65,728 67,371 Senior Administrative Assistant G 26 31.60 32.39 33.21 34.04 34.88 5,477 5,614 5,756 5,900 6,046 65,728 67,371 69,077 70,803 72,550 Senior Customer Service Representative H 22 28.61 29.36 30.08 30.84 31.60 4,959 5,089 5,214 5,346 5,477 59,509 61,069 62,566 64,147 65,728 Senior Engineer M 46 51.80 53.08 54.41 55.76 57.17 8,979 9,201 9,431 9,665 9,909 107,744 110,406 113,173 115,981 118,914 Senior Engineering Technician H 30 34.88 35.75 36.65 37.57 38.50 6,046 6,197 6,353 6,512 6,673 72,550 74,360 76,232 78,146 80,080 Senior Equipment Mechanic H 29 34.04 34.88 35.75 36.65 37.57 5,900 6,046 6,197 6,353 6,512 70,803 72,550 74,360 76,232 78,146 Senior Field Service Worker H 27 32.39 33.21 34.04 34.88 35.75 5,614 5,756 5,900 6,046 6,197 67,371 69,077 70,803 72,550 74,360 Senior Treatment Plant Operator H 36 40.46 41.47 42.50 43.57 44.65 7,013 7,188 7,367 7,552 7,739 84,157 86,258 88,400 90,626 92,872 Senior Water Production Operator H 32 36.65 37.57 38.50 39.47 40.46 6,353 6,512 6,673 6,841 7,013 76,232 78,146 80,080 82,098 84,157 Storekeeper-Buyer H 21 27.92 28.61 29.36 30.08 30.84 4,839 4,959 5,089 5,214 5,346 58,074 59,509 61,069 62,566 64,147 Water Production Operator I H 22 28.61 29.36 30.08 30.84 31.60 4,959 5,089 5,214 5,346 5,477 59,509 61,069 62,566 64,147 65,728 Water Production Operator II H 26 31.60 32.39 33.21 34.04 34.88 5,477 5,614 5,756 5,900 6,046 65,728 67,371 69,077 70,803 72,550 Water Production Operator III H 30 34.88 35.75 36.65 37.57 38.50 6,046 6,197 6,353 6,512 6,673 72,550 74,360 76,232 78,146 80,080 Water Production Supervisor G 41 45.76 46.92 48.09 49.29 50.51 7,932 8,133 8,336 8,544 8,755 95,181 97,594 100,027 102,523 105,061 Water Quality Coordinator H 34 38.50 39.47 40.46 41.47 42.50 6,673 6,841 7,013 7,188 7,367 80,080 82,098 84,157 86,258 88,400 Water Quality Technician H 23 29.36 30.08 30.84 31.60 32.39 5,089 5,214 5,346 5,477 5,614 61,069 62,566 64,147 65,728 67,371 A = At-Will PT = Part-Time * = E = Executive Management (Exempt)P = Professional/Supervisory (Exempt) S = Senior Management (Exempt)G = General/Confidential (Non-Exempt) M = Management (Exempt)H = Hourly-EVWDEP Represented (Non-Exempt) Steps Steps Steps Y-Rate (Due to results of 2014 Compensation Analysis, base salary is set above the maximum for the range assigned) Hourly Salary Range Monthly Salary Range Annual Salary Range SALARY SCHEDULE Effective March 5, 2018 Page 3 of 3 TOTAL WATER SEWER AMENDED OPERATING OPERATING GRANTS/LOANS DEVELOPER ADJ PROJECT PROJECT BUDGET REVENUE REVENUE OTHER FUND RESERVES FEES TOTAL CAPITAL OUTLAY Office Desk 5,000$ -$ -$ -$ -$ -$ 5,000$ Multi Year Rate Study - - - - - - - Tier 2 Data Storage 11,000 - - - - - 11,000 Virtual Desktop Infrastructure (VDI) Expansion 12,000 - - - - - 12,000 Virtual Desktop Infrastructure (VDI) Redundancy 47,000 - - - - - 47,000 X2 Aurora Filing Cabinet 16,000 - - - - - 16,000 Water Master Plan Update 200,000 - - - - - 200,000 Wastewater Master Plan Update 135,000 - - - - - 135,000 CCTV Camera 20,000 - - - - - 20,000 Emergency Generator 95,000 - - - - - 95,000 Trucks (3)145,000 - - - - - 145,000 TOTAL CAPITAL OUTLAY 742,000 - - - - - 686,000 CAPITAL IMPROVEMENT PROGRAM GENERAL CIP Habitat Conservation Plan - - - - - - - AMI Meter Retrofit Program 500,000 55,000 - - - - 555,000 General Subtotal 500,000 55,000 - - - - 555,000 WATER CIP Canal Zone Storage Reservoir 630,000 - - - - - 630,000 Transmission Main - Plant 134 to Upper Zone 2,085,000 - - - - - 2,085,000 Main Extension - Taylor Road - 125,000 - - - - 125,000 Plant 134 THM Treatment/Sludge Removal 650,000 - - - - - 650,000 Plant 140 - Tank Recoating - - - - - - - Plant 9 - Forebay Repair 350,000 - - - - - 350,000 Plant 59 - Tank Recoating 250,000 - - - - - 250,000 Facilities Relocations 100,000 - - - - - 100,000 Facilities Rehabilitation 225,000 - - - - - 225,000 Water Subtotal 4,290,000 125,000 - - - - 4,415,000 WASTEWATER CIP Sewer Main Replacement - Orange Street 75,000 - - - - - 75,000 Sewer Main Rehabilitation - 4th Street 100,000 - - - - - 100,000 Sewer Main Rehabilitation - Paloma Rd Phase II 105,000 - - - - - 105,000 Sewer Main Replacement - Ferndale Ave 210,000 - - - - - 210,000 City Creek Manhole Relocation 150,000 - - - - - 150,000 Sterling Natural Resource Center (SNRC) 675,000 - - - - - 675,000 Wastewater Subtotal 1,315,000 - - - - - 1,315,000 TOTAL CAPITAL IMPROVEMENT PROGRAM 6,105,000$ 180,000$ -$ -$ -$ -$ 6,285,000$ EAST VALLEY WATER DISTRICT CAPITAL EXPENSES FY 2017-18 PROPOSED ADJUSTMENT