HomeMy WebLinkAbout2018-02-01 - Board of Directors Meeting Agenda Packet (B)
AGENDA
YORBA LINDA WATER DISTRICT
BOARD OF DIRECTORS WORKSHOP MEETING
Thursday, February 1, 2018, 4:30 PM
1717 E Miraloma Ave, Placentia CA 92870
1. CALL TO ORDER
2. PLEDGE OF ALLEGIANCE
3. ROLL CALL
Al Nederhood, President
Brooke Jones, Vice President
Andrew J. Hall, Director
Phil Hawkins, Director
J. Wayne Miller, Director
4. PUBLIC COMMENTS
Any individual wishing to address the Board is requested to identify themselves and state the matter on which
they wish to comment. If the matter is on the agenda, the Board will recognize the individual for their comment
when the item is considered. No action will be taken on matters not listed on the agenda. Comments are limited
to matters of public interest and matters within the jurisdiction of the Water District. Comments are limited to three
minutes.
5. DISCUSSION ITEMS
This portion of the agenda is for matters that cannot reasonably be expected to be concluded by action of the
Board of Directors at the meeting, such as technical presentations, drafts of proposed policies, or similar items for
which staff is seeking the advice and counsel of the Board of Directors. Time permitting, it is generally in the
District’s interest to discuss these more complex matters at one meeting and consider formal action at another
meeting. This portion of the agenda may also include items for information only.
5.1. Mid-Year Review of Budget for Fiscal Year 2018 (Materials to be provided at the
meeting.)
6. ADJOURNMENT
6.1. The next Regular Board of Directors Meeting will be held Tuesday, February 13, 2018.
Closed Session will begin at 5:30 p.m. and regular business at 6:30 p.m.
Items Distributed to the Board Less Than 72 Hours Prior to the Meeting
Pursuant to Government Code section 54957.5, non-exempt public records that relate to open session agenda items
and are distributed to a majority of the Board less than seventy-two (72) hours prior to the meeting will be available for
public inspection in the lobby of the District’s business office located at 1717 E. Miraloma Avenue, Placentia, CA 92870,
during regular business hours. When practical, these public records will also be made available on the District’s internet
website accessible at http://www.ylwd.com/.
Accommodations for the Disabled
Any person may make a request for a disability-related modification or accommodation needed for that person to be
able to participate in the public meeting by telephoning the Executive Secretary at 714-701-3020, or writing to Yorba
Linda Water District, P.O. Box 309, Yorba Linda, CA 92885-0309. Requests must specify the nature of the disability and
the type of accommodation requested. A telephone number or other contact information should be included so the
District staff may discuss appropriate arrangements. Persons requesting a disability-related accommodation should
make the request with adequate time before the meeting for the District to provide the requested accommodation.
BACKUP MATERIALS DISTRIBUTED LESS THAN 72 HOURS PRIOR TO THE MEETING
FY18 BUDGET
MID-YEAR REVIEW
February 1, 2018
ITEM NO. 5.1.
MATERIALS SUBMITTED BY: Kelly McCann and Kaden Young
MEETING DATE: February 1, 2018
Overview
Summary of FYE18 Projections
Volumetric Revenue
Water Purchase and Delivery Costs
Salary and Related Expenses
Supplies and Services
Status of CIP
2
SUMMARY OF FYE18 PROJECTIONS
FYE17 Actual FY18 Budget FYE18
Projection
FYE18 Water
Projection
FYE18
Sewer
Projection
Revenue (Operating):
Water Revenue (Residential)14,076,334$ 14,278,688$ 16,639,668$ 16,639,668$ -$
Water Revenue (Commercial & Fire Det.)1,802,132$ 2,071,031$ 1,827,491$ 1,827,491$ -$
Water Revenue (Landscape/Irrigation)3,327,132$ 3,079,054$ 4,482,104$ 4,482,104$ -$
Service Charges 10,120,967$ 10,106,238$ 10,086,954$ 10,086,954$ -$
Sewer Charge Revenue 1,884,094$ 2,032,245$ 2,046,549$ -$ 2,046,549$
Sewer Parcel Assessments 215,853$ 223,000$ 228,037$ -$ 228,037$
Other Operating Revenue 1,033,607$ 866,161$ 811,731$ 730,260$ 81,471$
Total Non-Operating Revenue 2,710,151$ 2,644,521$ 2,629,684$ 2,587,405$ 42,279$
Total Revenue 35,170,270$ 35,300,938$ 38,752,217$ 36,353,882$ 2,398,336$
Expenses (Operating):
Variable Water Costs 12,710,857$ 13,968,855$ 15,008,499$ 15,008,499$ -$
Salary Related Expenses 8,913,639$ 9,643,124$ 9,556,385$ 8,528,578$ 1,027,807$
Supplies & Services 4,504,054$ 4,621,895$ 4,429,207$ 3,957,933$ 471,273$
Total Non-Operating Expenses 1,956,493$ 1,505,016$ 1,363,336$ 1,359,495$ 3,841$
Total Expenses 28,085,043$ 29,738,890$ 30,357,426$ 28,854,505$ 1,502,921$
Net Income (Loss) Before Cap. Contri. &
Special Items 7,085,227$ 5,562,048$ 8,394,791$ 7,499,376$ 895,415$
Special Items -$ -$ 2,205,943$ 2,205,943$ -$
Extra-Ordinary Item -$ -$ -$ -$ -$
Capital Contributions 2,665,462$ -$ 3,497,605$ 1,892,023$ 1,605,582$
Net Income (Loss) Before Depreciation 9,750,689$ 5,562,048$ 9,686,454$ 7,185,457$ 2,500,996$
Depreciation 7,147,368$ 7,182,000$ 7,423,631$ 6,062,652$ 1,360,978$
Income (Loss)2,603,321$ (1,619,952)$ 2,262,823$ 1,122,805$ 1,140,018$
Debt Covenant Ratio 307%
Yorba Linda Water District
Projection of FYE18 Results
Water & Sewer Enterprise
4
5
$32,091,004
$30,139,233
$33,050,080 $32,734,108 $32,893,763
$36,353,882
$26,616,578
$24,901,671
$23,296,906
$26,664,572
$28,251,899 $28,854,505
$-
$5,000,000
$10,000,000
$15,000,000
$20,000,000
$25,000,000
$30,000,000
$35,000,000
$40,000,000
FYE14 Actual FYE15 Actual FYE16 Actual FYE17 Actual FY18 Budget FYE18 Projection
Water & Sewer Revenues/Expenses
(excludes Depreciation, Special Items, and Contributed Capital )
Total Revenue Total Expenses
VOLUMETRIC REVENUE
Comparison of Water Use FY18 and FY17
July-December FY18
4,537,177 units total
July-December FY17
4,089,487 units total
7
Residential Commercial Irrigation
21
69
151
24
73
161
AVERAGE UNITS
PER
METER TYPE
FY17 FY18
Retail Consumption Volume: FY17 vs FY18
0
200000
400000
600000
800000
1000000
1200000
FY17 FY18 FY17 FY18 FY17 FY18 FY17 FY18 FY17 FY18 FY17 FY18 FY17 FY18 FY17 FY18 FY17 FY18 FY17 FY18 FY17 FY18 FY17 FY18
JUL AUG SEP OCT NOV DEC JAN FEB MAR APR MAY JUNVOLUME, CCFRetail Consumption Volume
FY17 vs FY18
(Jan.2018 -Jun.2018 are projections)
Residential Commercial Irrigation 8
Total Volumetric Revenue: FY17 vs FY18
FY17
$19,011,046
FY18
$22,582,252
$-
$500,000
$1,000,000
$1,500,000
$2,000,000
$2,500,000
$3,000,000
$-
$5,000,000
$10,000,000
$15,000,000
$20,000,000
$25,000,000
JUL AUG SEPT OCT NOV DEC JAN FEB MAR APR MAY JUN
Volumetric Revenue
FY17 vs FY18
(Jan.2018 -Jun.2018 are projections)
FY17 Monthly FY18 Monthly FY17 Cumulative FY18 Cumulative 9
WATER PURCHASE
AND DELIVERY COSTS
Monthly Production Volume: Budget vs. Actual/Projection
2,045.9 2,036.9
1,906.0
1,706.2
1,351.8
894.0
1,141.1
1,055.7
1,268.3
1,460.9
1,600.8 1,704.3
2,129.7 2,109.0
1,910.8 1,933.4
1,559.9 1,620.5
1,288.9
1,195.7
1,436.5
1,654.7
1,813.2
1,930.5
-
500.0
1,000.0
1,500.0
2,000.0
2,500.0
Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18Volume, AFSYSTEM -Production Volume
FY18 Budget Actual Projected
Budget: 18,172 AF
Actual/Projection: 20,583 AF
726.5 AF
81.3%
11
Historic Production Data: 10 Years
12
00
500
1000
1500
2000
2500
3000
Jul-08Sep-08Nov-08Jan-09Mar-09May-09Jul-09Sep-09Nov-09Jan-10Mar-10May-10Jul-10Sep-10Nov-10Jan-11Mar-11May-11Jul-11Sep-11Nov-11Jan-12Mar-12May-12Jul-12Sep-12Nov-12Jan-13Mar-13May-13Jul-13Sep-13Nov-13Jan-14Mar-14May-14Jul-14Sep-14Nov-14Jan-15Mar-15May-15Jul-15Sep-15Nov-15Jan-16Mar-16May-16Jul-16Sep-16Nov-16Jan-17Mar-17May-17Jul-17Sep-17Nov-17Jan-18Mar-18May-18Water Production
Historic Production Data: 10 Years
13
0
10
20
30
40
50
60
70
80
90
0
500
1000
1500
2000
2500
3000
Jul-08Sep-08Nov-08Jan-09Mar-09May-09Jul-09Sep-09Nov-09Jan-10Mar-10May-10Jul-10Sep-10Nov-10Jan-11Mar-11May-11Jul-11Sep-11Nov-11Jan-12Mar-12May-12Jul-12Sep-12Nov-12Jan-13Mar-13May-13Jul-13Sep-13Nov-13Jan-14Mar-14May-14Jul-14Sep-14Nov-14Jan-15Mar-15May-15Jul-15Sep-15Nov-15Jan-16Mar-16May-16Jul-16Sep-16Nov-16Jan-17Mar-17May-17Jul-17Sep-17Nov-17Jan-18Mar-18May-18Water Production Temperature
Historic Production Data: 10 Years
14
00
500
1000
1500
2000
2500
3000
Jul-08Sep-08Nov-08Jan-09Mar-09May-09Jul-09Sep-09Nov-09Jan-10Mar-10May-10Jul-10Sep-10Nov-10Jan-11Mar-11May-11Jul-11Sep-11Nov-11Jan-12Mar-12May-12Jul-12Sep-12Nov-12Jan-13Mar-13May-13Jul-13Sep-13Nov-13Jan-14Mar-14May-14Jul-14Sep-14Nov-14Jan-15Mar-15May-15Jul-15Sep-15Nov-15Jan-16Mar-16May-16Jul-16Sep-16Nov-16Jan-17Mar-17May-17Jul-17Sep-17Nov-17Jan-18Mar-18May-18Water Production
FY18 Budget's 3YR
Historic Production Data: 10 Years
15
0
5
10
15
20
25
30
0
500
1000
1500
2000
2500
3000
Jul-08Sep-08Nov-08Jan-09Mar-09May-09Jul-09Sep-09Nov-09Jan-10Mar-10May-10Jul-10Sep-10Nov-10Jan-11Mar-11May-11Jul-11Sep-11Nov-11Jan-12Mar-12May-12Jul-12Sep-12Nov-12Jan-13Mar-13May-13Jul-13Sep-13Nov-13Jan-14Mar-14May-14Jul-14Sep-14Nov-14Jan-15Mar-15May-15Jul-15Sep-15Nov-15Jan-16Mar-16May-16Jul-16Sep-16Nov-16Jan-17Mar-17May-17Jul-17Sep-17Nov-17Jan-18Mar-18May-18Water Production Rainfall
3YR Average
Production Trends –Fiscal Cycles
6 Month Adjusted Projection
16
0.0
500.0
1000.0
1500.0
2000.0
2500.0
July August September October November December January February March April May June
Production Trends
FY12
Production Trends –Fiscal Cycles
6 Month Adjusted Projection
17
0.0
500.0
1000.0
1500.0
2000.0
2500.0
3000.0
July August September October November December January February March April May June
Production Trends
FY12 FY13
Production Trends –Fiscal Cycles
6 Month Adjusted Projection
18
0.0
500.0
1000.0
1500.0
2000.0
2500.0
3000.0
July August September October November December January February March April May June
Production Trends
FY12 FY13 FY14
Production Trends –Fiscal Cycles
6 Month Adjusted Projection
19
0
500
1000
1500
2000
2500
3000
1 2 3 4 5 6 7 8 9 10 11 12
Production Trends
3YR AVG.
Production Trends –Fiscal Cycles
6 Month Adjusted Projection
20
0
500
1000
1500
2000
2500
3000
July August September October November December January February March April May June
Production Trends
FY18 3YR AVG.
Production Trends –Cumulative Cycles
21
0.0
5000.0
10000.0
15000.0
20000.0
25000.0
July August September October November December January February March April May June
Production Trends
FY12
Production Trends –Cumulative Cycles
22
0.0
5000.0
10000.0
15000.0
20000.0
25000.0
July August September October November December January February March April May June
Production Trends
FY12 FY13
Production Trends –Cumulative Cycles
23
0.0
5000.0
10000.0
15000.0
20000.0
25000.0
July August September October November December January February March April May June
Production Trends
FY12 FY13 FY14
Production Trends –Cumulative Cycles
24
21337
0
5000
10000
15000
20000
25000
1 2 3 4 5 6 7 8 9 10 11 12
Production Trends
3YR AVG.
Production Trends –Cumulative Cycles
25
20583
21337
0
5000
10000
15000
20000
25000
July August September October November December January February March April May June
Production Trends
FY18 3YR AVG.
Production Data & Analysis
Monthly Projections and Daily Actuals
GW IMPORT OC-36 CONSUMPTION TEMP ETo Rain -Brea
MG AF MG AF AF MG AF F (in.)(in.)
1-Jan 6.792 20.840 9.528 29.240 0.000 17.199 52.780 70.0 0.00
2-Jan 6.780 20.810 8.795 26.990 0.800 16.474 50.560 80.0 0.00
3-Jan 6.980 21.420 9.809 30.100 0.300 15.535 47.670 75.0 0.00
4-Jan 7.010 21.510 7.818 23.990 0.700 15.850 48.640 76.0 0.00
5-Jan 6.798 20.860 7.196 22.080 0.700 17.147 52.620 74.0 0.00
6-Jan 6.791 20.840 8.170 25.070 0.000 13.854 42.520 71.0 0.00
7-Jan 6.768 20.770 8.335 25.580 0.000 12.678 38.910 74.0 0.00
8-Jan 7.174 22.020 6.896 21.160 0.200 13.299 40.810RAIN 68.0 0.47
9-Jan 3.162 9.700 6.389 19.610 0.000 9.657 29.640RAIN 61.0 1.26
10-Jan 3.894 11.950 3.837 11.780 0.000 9.244 28.370 64.0 0.00
11-Jan 4.207 12.910 5.425 16.650 0.000 8.853 27.170 72.0 0.00
12-Jan 1.160 3.560 8.114 24.900 0.000 9.733 29.870 75.0 0.00
13-Jan 6.344 19.470 7.710 23.660 0.200 10.039 30.810 83.0 0.00
14-Jan 6.837 20.980 5.805 17.810 0.200 9.996 30.680 84.0 0.00
15-Jan 5.047 15.490 6.205 19.040 0.500 13.481 41.370 75.0 0.00
16-Jan 5.523 16.950 7.242 22.230 0.600 12.658 38.840 71.0 0.00
17-Jan 6.653 20.420 7.521 23.080 0.000 13.351 40.970 77.0 0.08 0.00
18-Jan 2.514 7.710 5.392 16.550 0.900 13.408 41.150 78.0 0.09 0.00
19-Jan 8.472 26.000 2.891 8.870 0.500 13.897 42.650 66.0 0.02 0.00
20-Jan 12.393 38.030 0.000 0.000 0.000 11.514 35.330 63.0 0.09 0.00
21-Jan 9.318 28.600 1.490 4.570 0.200 11.380 34.920 65.0 0.08 0.00
22-Jan 8.607 26.410 4.465 13.700 0.700 15.777 48.420 71.0 0.09 0.00
23-Jan 11.944 36.650 6.287 19.290 0.600 14.834 45.530 78.0 0.10 0.00
24-Jan 13.524 41.500 5.638 17.300 0.600 15.094 46.320 76.0 0.10 0.00
25-Jan 2.281 7.000 4.948 15.180 0.600 14.604 44.820 62.0 0.05 0.00
26-Jan 12.704 38.990 4.444 13.640 0.000 15.356 47.130 70.0 0.08 0.00
27-Jan 12.906 39.610 4.591 14.090 0.700 13.984 42.910 76.0 0.10 0.00
28-Jan 10.136 31.100 4.586 14.070 1.100 13.616 41.790 84.0 0.12 0.00
29-Jan 6.745 20.700 4.597 14.110 1.100 17.855 54.790 86.0 0.16 0.00
30-Jan 14.219 43.640 4.603 14.120 1.200 17.194 52.770 81.0 0.11 0.00
31-Jan
TOTAL 223.683 686.440 178.727 548.460 12.400 407.561 1250.760
PROJECTION 231.139 709.321 184.685 566.742 12.813 421.146 1292.452
MONTH
IN-LIEU
GW
(AF)
ACTUAL
GW
(AF)
ADJUSTED
IMPORT
(AF)
TOTAL
DEMAND
(AF)
MONTHLY
GW
(%)
YTD
GW
(%)
BUDGET
(Demand Est.)
(AF)
DELTA
(%)
Jul-17 24.3 1,466.5 638.9 2,129.7 70.0%70.0%2,045.9 4.1%
Aug -17 630.8 845.5 632.7 2,109.0 70.0%70.0%2,036.9 3.5%
Sep-17 547.1 790.4 573.3 1,910.8 70.0%70.0%1,906.0 0.3%
Oct-17 549.2 804.1 580.1 1,933.4 70.0%70.0%1,706.2 13.3%
Nov-17 421.1 670.8 468.0 1,559.9 70.0%70.0%1,351.8 15.4%
Dec-17 449.8 684.5 486.2 1,620.5 70.0%70.0%894.0 81.3%
Jan-18 192.9 709.3 386.7 1,288.9 70.0%70.0%1,141.1 13.0%
Feb-18 837.0 358.7 1,195.7 70.0%70.0%1,055.7 13.3%
Mar-18 1,005.6 431.0 1,436.5 70.0%70.0%1,268.3 13.3%
Apr -18 1,158.3 496.4 1,654.7 70.0%70.0%1,460.9 13.3%
May-18 1,269.2 543.9 1,813.2 70.0%70.0%1,600.8 13.3%
Jun-18 1,351.3 579.1 1,930.5 70.0%70.0%1,704.3 13.3%
FYTD 2,815.2 11,592.5 6,175.0 20,582.8 70.0%70.0%18,171.8 13.3%
26
Monthly Production vs Temperature
27
0.0
10.0
20.0
30.0
40.0
50.0
60.0
70.0
80.0
90.0
100.0
0.000
5.000
10.000
15.000
20.000
25.000
Temperature, degrees FahrenheitVolume, AFTemperature
Groundwater Import Water Consumption Temperature
Monthly Production vs Rainfall & Evapotranspiration
28
0
0.5
1
1.5
2
2.5
0.000
5.000
10.000
15.000
20.000
25.000
inchesVolume, AFRainfall and ETo
Groundwater Import Water Consumption ETo Rainfall
FYE18 Monthly Water Purchase and Delivery Costs
$-
$200,000
$400,000
$600,000
$800,000
$1,000,000
$1,200,000
$1,400,000
$1,600,000
$1,800,000
Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18
CAPACITY/READINESS CONNECTION CHARGE ANNEXATION GW RA PURCHASED WATER IN-LIEU ENERGY 29
FYE18 Total Water Purchase and Delivery Costs
30
Groundwater
$553,983
4%
Import Water
$295,797
2%
In-Lieu Water
$135,500
1%
Groundwater Replenishment
$5,158,679
34%
Annexation Fee
$369,257
2%
Purchased Water
$6,146,016
41%
Connection Charge
$297,524
2%Capacity/Readiness Charge
$536,955
4%
In-Lieu Purchased Water
$1,514,789
10%
Energy
$985,280
7%
Groundwater Import Water In-Lieu Water Groundwater Replenishment Annexation Fee
Purchased Water Connection Charge Capacity/Readiness Charge In-Lieu Purchased Water
SALARIES AND RELATED
FY18 FYE18 FYE18 FYE18 Comparison
Budget Consolidated Water Sewer as a % of
Projection Projection Projection Consolidated
to FY18 Budget
Total Wages
Regular Salaries $6,529,234 $6,282,511 $5,578,550 703961
Overtime & Comp Time 211,343 238,560 227,384 11,176
Standby Day Pay 32,100 31,110 31,110 -
Mandatory Benefits
CalPERS/SS/Medicare 805,270 $828,395 696,585 131,809
Unfunded Accrued Liability 319,813 $319,813 319813 -
PARS - Prefunding of Unfunded Liabilities
PARS Contribution to PERS - $247,599 $230,267 $17,332
PARS Contribution to OPEB
Fringe Benefits 1,364,680 $1,211,116 $1,057,357 $153,758
Retiree Benefits
Retiree Benefits 145,244 $138,800 129,084 9,716
OPEB Annual Required Contribution 229,480 $257,706 257706 -
Unemployment Insurance 5,961 $776 $722 $54
Total Salary and Related Expenses $ 9,643,124 $ 9,556,386 $ 8,528,578 $ 1,027,807 99%
Without Pars Contribution 97%
Yorba Linda Water District
Projection of Salary and Related Expenses
Water & Sewer Enterprise
32
SUPPLIES AND SERVICES
FYE17
Actuals FY18 Budget FYE18
Projection
$ Variance
FYE18
Projection to
FYE17
Actuals
Supplies & Services:
Communications 166,199$ 201,575$ 187,606$ 21,407$
Contractual Services 440,322$ 547,890$ 426,798$ (13,524)$
Data Processing 271,759$ 250,400$ 303,021$ 31,262$
Dues & Memberships 92,428$ 86,545$ 81,060$ (11,368)$
Fees & Permits 265,031$ 282,115$ 259,195$ (5,836)$
Board Election 129,971$ -$ -$ (129,971)$
Insurance 256,672$ 283,340$ 279,234$ 22,562$
Materials 880,458$ 849,000$ 780,018$ (100,440)$
District Activities, Emp Recognition 10,945$ 24,200$ 20,894$ 9,949$
Maintenance 539,926$ 509,901$ 574,499$ 34,573$
Non-Capital Equipment 173,703$ 124,825$ 116,622$ (57,081)$
Office Expense 39,171$ 42,625$ 45,420$ 6,249$
Professional Services 614,288$ 690,525$ 680,923$ 66,635$
Training 44,158$ 68,510$ 40,691$ (3,467)$
Travel & Conferences 48,852$ 115,245$ 65,759$ 16,907$
Uncollectible Accounts 9,042$ 18,500$ 1,492$ (7,550)$
Utilities 160,003$ 170,700$ 204,588$ 44,585$
Vehicle Equipment 361,126$ 356,000$ 361,387$ 261$
Supplies & Services Sub-Total 4,504,054$ 4,621,895$ 4,429,207$ (74,847)$
Projection of Supplies & Services
Water & Sewer Enterprise
34
STATUS OF CIP
FYE18 Projection of Capital Improvement Projects
$6,305,167
80%
$1,098,871
14%
$474,348
6% Water Capital
Rehabilitation & Restoration
Vehicle & Capital Equipment
36
FYE18 Projection Debt Financed versus Pay-GO
$4,765,695
60.5%
Debt Financed
$3,112,691
39.5%
Pay-Go
37
Fairmont Booster Pump Station
Fairmont Booster Pump Station
U.S. Bank Held Restricted 2017A Acquisition Fund
38
$214,764
$214,764
$190,833
$1,350,833
$2,206,364
$3,076,273
$3,848,581
$4,287,676
$4,592,279
$4,732,930
$5,069,887
$5,481,688
$6,000,000
$23,931
$1,160,000
$855,531
$869,909
$772,308
$439,095
$304,603
$140,651
$336,957
$411,801
$518,312
$- $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 $7,000,000
Remaining Balance
Interest Earned
February - June 2018 Payments
January 2018 Payment
December 2017 Payment
November 2017 Payment
October 2017 Payment
September 2017 Payment
August 2017 Payment
July 2017 Payment
June 2017 Payment
May 2017 Payment
As of May 11, 2017
DEBIT/CREDIT REMAINING FUNDS
Project #Project Name
FY18 Budgeted
CIP
Expenditures
FYE18 Projection
FYE18
Projection
versus Budget
Debt Financed - U.S. Bank Held 2017A Restricted Acquisition Fund
2010-11B Fairmont BPS Upgrade (FBS)3,663,369$ 4,765,695$ 1,102,326$
Pay-Go
Water Capital Funds Available for Use (1/2-0010-2700-00)
2009-22 #21 S & W Well Project (Well No. 21)-$ -$ -$
2009-22 #22 S & W Well Project (Well No. 22)1,018,116$ 867,538$ (150,578)$
2010-02 Lakeview Grade Separation 150,000$ 250,000$ 100,000$
2014-23 Richfield Road Pipeline -$ 345,448$ 345,448$
2017-01 Well #15 Refurbishment [Maintenance Reserve]-$ 76,486$ 76,486$
Water Capital Subtotal = 1,168,116$ 1,539,472 371,356$
Rehabilitation & Restoration - Water & Sewer
2014-11 PRS Rehabilitation Phase 2 574,639$ 221,050$ (353,589)$
2017-35 Richfield Chlorination System 250,000$ 180,000$ (70,000)$
2017-33 Chlorination System at Camino de Bryant Reservoir 25,000$ 30,620$ 5,620$
2017-34 Chlorination System at Hidden Hills Reservoir 25,000$ 30,000$ 5,000$
2017-31 Susana, Bryant & John Bixby Pipelines (Tract #15199)50,000$ 410,000$ 360,000$
Replace old Cast Iron Pipelines (1920s to 1940s)50,000$ -$ (50,000)$
PRS Rehabilitation Phase 3 -$ 3,718$ 3,718$
2017-13 Well #1 Rehabilitation -$ 48,324$ 48,324$
2015-10S 2016 Sewer Re-Line Project 100,000$ 175,159$ 75,159$
Rehabilitation & Restoration Subtotal (Water & Sewer) = 1,074,639$ 1,098,871 24,232$
39
Project #Project Name
FY18 Budgeted
CIP
Expenditures
FYE18 Projection
FYE18
Projection
versus Budget
Vehicle and Capital Equipment Replacement
2016-15 VOIP Phone Upgrade (Phase 1)25,000$ 29,383$ 4,383$
VOIP Phone Redundancy (Phase 2)18,000$ 22,000$ 4,000$
Welding Fume Extractor -$ 5,490$ 5,490$
Hidden Hills Reservoir Landscape Mitigation Land Purch 120,000$ 120,000$ -$
PLC Upgrade Replacement Plan (SCADA)60,000$ 30,000$ (30,000)$
Light-duty Pick-up Truck (Water Production)32,000$ 28,782$ (3,218)$
1/2 Ton Pick-up Truck with Extended Cab (Mechanics)35,000$ 28,584$ (6,416)$
Light-duty Pick-up Truck (Mechanics)32,000$ 29,895$ (2,105)$
3/4 Ton Pick-up (Operations)35,000$ 31,863$ (3,137)$
Handheld meter reading device 6,500$ 10,000$ 3,500$
Counsel Server for Data Center (KVM 32 Port)12,000$ 12,000$ -$
Server Replacement O - 9X15KN1, N - HQ4SKH2 7,600$ 7,508$ (92)$
Server Replacement FHQ1XK2 - DVR 9,300$ 9,252$ (48)$
VMWare Host - PowerEdge Servers 38,100$ 39,661$ 1,561$
VMWare Site Recovery Manager (SRM)6,500$ 6,500$ -$
10 - Replacement Dell Optiplex PC(s)20,000$ 20,000$ -$
4 - Replacement Dell Notebooks 6,000$ 6,000$ -$
CMMS Notebooks & Equip.30,000$ 19,438$ (10,562)$
Dell Notebooks & Switches -$ 17,991$ 17,991$
Vehicle & Capital Equipment Subtotal = 493,000$ 474,348$ (18,652)$
Pay-Go Total = 2,735,755$ 3,112,691$ 376,936$
Total CIP, R&R, & Capital Outlay = 6,399,124 7,878,386 1,479,262
40
Questions?
41