Loading...
HomeMy WebLinkAbout2015-11-19 - Board of Directors Meeting Agenda Packet Yorba Linda Hater District AGENDA YORBA LINDA WATER DISTRICT BOARD OF DIRECTORS WORKSHOP MEETING Thursday, November 19, 2015, 3:00 PM 1717 E Miraloma Ave, Placentia CA 92870 1. CALL TO ORDER 2. PLEDGE OF ALLEGIANCE 3. ROLL CALL Ric Collett, President Michael J. Beverage, Vice President Phil Hawkins Robert R. Kiley Gary T. Melton 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. Draft Unaudited Financial Statements for the Period Ending September 30, 2015 6. ADJOURNMENT 6.1. The next Regular Board of Directors Meeting will be held Wednesday, November 25, 2015 at 8:30 a.m. Items Distributed to the Board Less Than 72 Hours Prior to the Meeting Pursuant to Government Code section 54957.5, non-exempt public records that relate to open session agenda items and are distributed to a majority of the Board less than seventy-two (72) hours prior to the meeting will be available for public inspection in the lobby of the District's business office located at 1717 E. Miraloma Avenue, Placentia, CA 92870, during regular business hours. When practical, these public records will also be made available on the District's internet website accessible at http://www.ylwd.com/. Accommodations for the Disabled Any person may make a request for a disability-related modification or accommodation needed for that person to be able to participate in the public meeting by telephoning the Executive Secretary at 714-701-3020, or writing to Yorba Linda Water District, P.O. Box 309, Yorba Linda, CA 92885-0309. Requests must specify the nature of the disability and the type of accommodation requested. A telephone number or other contact information should be included so the District staff may discuss appropriate arrangements. Persons requesting a disability-related accommodation should make the request with adequate time before the meeting for the District to provide the requested accommodation. ITEM NO. 5.1 AGENDA REPORT Meeting Date: November 19, 2015 To: Board of Directors From: Marc Marcantonio, General Manager Presented By: Delia Lugo, Finance Manager Prepared By: Cindy Botts, Water Conservation Supervisor Subject: Draft Unaudited Financial Statements for the Period Ending September 30, 2015 DISCUSSION: Presented are the Draft Unaudited Financial Statements for the Period Ending September 30, 2015. Discussion on these statements will focus on the District's financial position for the 1st Quarter of Fiscal Year 2015/16 as a direct result of the SWRCB's mandate for a reduction in consumption. Target areas include: Water Sales, Variable Costs, current consumption levels, and Administrative Penalty Revenue. STRATEGIC PLAN: FR 1-F: Continue to Record and Report the Fairly Stated Financial Activities of the District in a Timely and Transparent Manner to the Board of Directors and Member Agencies ATTACHMENTS: rvame: Description: Type: Balance Sheet as of Sept 30 2015 no Ad Pen.xlsx Sept Consol Balance Sheet no Penalties Backup Material Balance Sheet as of Sept 30 2015 no Ad Pen Budget to Actual.xlsx Sept Budget to Actual No Penalty Backup Material FY 2016 1st Qtr Consolidated Balance Sheet.xlsx Sept Consol Balance Sheet Penaties Backup Material FY 2016 1st Qtr Consolidated Balance Sheet Budget to actual.xlsx Sept Consol Balance Budget to Actual Backup Material Penalties Presentation.pdf Backup Material Distributed Less Than 72 Backup Material Hours Prior to the Meeting CIP Budget.pdf Backup Material Distributed Less Than 72 Backup Material Hours Prior to the Meeting YORBA LINDA WATER DISTRICT UNAUDITED COMBINING SCHEDULE OF NET ASSETS(no Administrative Penalties)-DRAFT September 30, 2015 (With September 30, 2014 for comparison only) ASSETS September 2015 September 2014 CURRENT ASSETS: Cash and cash equivalents $ 25,377,282 $ 21,100,913 Investment 9,410,039 9,249,075 Accounts receivable-water and sewer services 3,081,028 3,825,724 Accounts receivable- property taxes - - Accrued interest receivable 37,560 18,488 Prepaid expenses&other deposits 422,326 503,326 Inventory 250,161 265,946 TOTAL CURRENT ASSETS 38,578,396 34,963,472 NONCURRENT ASSETS: Bond issuance costs 443,843 469,002 Other post-employment benefit(OPEB) asset 142,701 138,944 Deferred Pension Plans 587,176 - Notes Receivable 226,741 - Capital assets: Non-depreciable 3,629,137 7,211,423 Depreciable, net of accumulated depreciation 189,466,156 190,938,770 TOTAL NONCURRENT ASSETS 194,495,754 198,758,139 TOTAL ASSETS 233,074,150 233,721,611 LIABILITIES CURRENT LIABILITIES: Accounts payable 1,624,695 3,301,218 Accrued expenses 1,063,927 1,110,683 Accrued interest payable 848,029 865,480 Certificates of Participation-current portion 765,000 735,000 Accrued OPEB 2,227 3,790 Refunding Revenue Bond-current portion 280,000 275,000 Compensated absences 313,340 300,638 Customer and construction deposits 415,546 334,798 Deferred revenue 342,064 380,796 TOTAL CURRENT LIABILITIES 5,654,828 7,307,403 LONG-TERM LIABILITIES(LESS CURRENT PORTION): Deferred annexation revenue 14,969,349 13,364,806 Compensated absences 992,243 855,663 Net Pension Liability 5,092,626 - Deferred Pension Plan 1,810,965 - Refunding Revenue Bond 8,329,916 8,070,000 LOC 6,458,297 4,970,754 Certificate of Participation 30,493,028 31,872,068 TOTAL LONG TERM LIABILITIES(LESS CURRENT PORTION) 68,146,424 59,133,291 TOTAL LIABILITIES 73,801,252 66,440,694 NET ASSETS: $ 159,272,898 $ 167,280,917 YORBA LINDA WATER DISTRICT UNAUDITED DEBT SERVICE RATIO CALCULATION (no Administrative Penalties)- DRAFT For the period ended September 30, 2015 YTD Debt Actual Service FY 2015 Calculation Revenue(Operating): Water Sales $6,334,296 $6,334,296 Other Operating Revenue 241,588 241,588 Total Operating Revenue: 6,575,884 6,575,884 Revenue(Non-Operating): Interest 35,531 35,531 Property Tax 37,661 37,661 Other Non-Operating Revenue 159,685 44,932 Total Non-Operating Revenue: 232,877 118,124 Total Revenue 6,808,761 6,694,008 Expenses(Operating): Variable Water Costs(G.W., Import&Power) 3,053,358 3,053,358 Salary Related Expenses 2,064,432 2,064,432 Supplies&Services 934,419 934,419 Depreciation 1,555,011 - Total Operating Expenses 7,607,220 6,052,209 Expenses(Non-Operating): Interest on Long Term Debt 428,840 - Other Expense 1,788 1,788 Total Non-Operating Expenses: 430,628 1,788 Total Expenses 8,037,848 6,053,997 Net Income(Loss) Before Capital Contributions (1,229,087) 640,011 Capital Contributions $ 32,644 $ - Net Change in Assets $ (1,196,443) $ 640,011 DEBT SERVICE RATIO CALCULATION: Net Revenues $ 640,011 Debt Service $ 680,390 % 94% YORBA LINDA WATER DISTRICT UNAUDITED COMBINING SCHEDULE OF REVENUES, EXPENSES AND CHANGES IN NET ASSETS(no Administrative Penalties)- DRAFT For the period ended September 30, 2015 (With fiscal year ended September 2014 for comparison only) September 2015 September 2014 OPERATING REVENUES: Water sales $ 6,334,296 $ 8,622,077 Sewer revenues 385,554 408,388 Other operating revenues 263,606 257,003 TOTAL OPERATING REVENUES 6,983,456 9,287,468 OPERATING EXPENSES Variable water costs 3,053,358 4,693,449 Personnel services 2,285,546 1,969,673 Supplies and services 1,009,060 1,057,731 Depreciation and amortization 1,900,224 1,840,117 TOTAL OPERATING EXPENSES 8,248,188 9,560,970 OPERATING INCOME/(LOSS) (1,264,732) (273,502) NONOPERATING REVENUES(EXPENSES): Property taxes 37,661 49,121 Investment income 38,351 31,736 Interest expense (428,840) (434,464) Other nonoperating revenues 170,763 100,204 Other nonoperating expenses (1,788) (39,030) TOTAL NONOPERATING REVENUES/EXPENSES (183,853) (292,433) NET INCOME/(LOSS) BEFORE CAPITAL CONTRIBUTIONS&EXTRAORDINARY ITEM(S) (1,448,585) (565,935) EXTRAORDINARY ITEM(S) - CAPITAL CONTRIBUTIONS 98,818 69,983 CHANGES IN NET ASSETS (1,349,767) (495,952) NET ASSETS- BEGINNING OF YEAR 160,622,665 167,776,869 NET ASSETS- FOR PERIOD END SEPTEMBER 30, 2015 $ 159,272,898 $ 167,280,917 YORBA LINDA WATER DISTRICT SUMMARY FINANCIAL REPORT WATER&SEWER FUNDS(no Administrative Penalties)-DRAFT For the period ended September 30,2015 Annual YTD Sept YTD YTD YTD YTD Budget Budget Actual Actual Under(Over) %of %of YTD FY 2016 FY 2016 FY 2016 FY 2016 Budget Budget Budget Revenue(Operating): Water Revenue(Residential) $11,472,028 $3,817,891 $1,212,077 $3,667,584 $7,804,444 31.97% 96.06% Water Revenue(Commercial&Fire Det.) 1,385,979 $461,254 $179,605 $496,428 $889,551 35.82% 107.63% Water Revenue(Landscape/Irrigation) 2,782,183 $925,911 $317,890 $896,502 $1,885,681 32.22% 96.82% Water Revenue(Service Charge) 10,824,413 $1,282,143 $424,411 $1,273,782 $9,550,631 11.77% 99.35% Sewer Charge Revenue 1,584,348 $396,087 $122,005 $385,220 $1,199,128 24.31% 97.26% Locke Ranch Assessments 201,500 $6,045 $108 $333 $201,167 0.17% 5.51% Other Operating Revenue 681,401 $299,275 $71,605 $263,606 $417,796 38.69% 88.08% Total Operating Revenue: 28,931,852 7,188,605 2,327,701 6,983,454 21,948,398 24.14% Revenue(Non-Operating): Interest 93,000 23,250 15,852 38,352 54,648 41.24% Property Tax 1,395,000 41,850 35,144 37,661 1,357,339 2.70% Other Non-Operating Revenue 607,155 151,789 103,579 170,764 436,391 28.13% Total Non-Operating Revenue: 2,095,155 216,889 154,575 246,777 1,848,378 11.78% Total Revenue 31,027,007 7,405,494 2,482,276 7,230,231 23,796,776 23.30% Expenses(Operating): Variable Water Costs(G.W.,Import&Power) 12,080,410 4,020,360 903,666 3,053,358 9,027,052 25.28% 75.95% Salary Related Expenses 8,964,218 2,241,055 752,720 2,285,546 6,678,672 25.50% Supplies&Services 7,564,117 1,891,029 389,929 1,009,060 6,555,057 13.34% Total Operating Expenses 28,608,745 8,152,444 2,046,315 6,347,964 22,260,781 22.19% Expenses(Non-Operating): Interest on Long Term Debt 1,655,685 413,921 154,379 428,840 1,226,845 25.90% Other Expense 22,000 5,500 596 1,788 20,212 8.13% Total Non-Operating Expenses: 1,677,685 419,421 154,975 430,628 1,247,057 25.67% Total Expenses 30,286,430 8,571,865 2,201,290 6,778,592 23,507,838 22.38% Net Income(Loss)Before Capital Contributions 740,577 -1,166,371 280,986 451,639 288,938 60.98% Capital Contributions - 96,996 98,817 (98,817) 0% Net Income(Loss)Before Depreciation 740,577 (1,166,371) 377,982 550,456 190,121 74.33% Depreciation&Amortization 7,350,000 1,837,500 631,495 1,900,224 5,449,777 25.85% Total Net Income(Loss) (6,609,423) (3,003,871) (253,513) (1,349,767) (5,259,656) 20.42% Capital-Direct Labor - (14,979) (53,041) YORBA LINDA WATER DISTRICT SUMMARY FINANCIAL REPORT WATER FUND(no Administrative Penalties)-DRAFT For the period ended September 30,2015 Annual YTD Sept YTD YTD YTD YTD Budget Budget Actual Actual Under(Over) %of %of YTD FY 2016 FY 2016 FY 2016 FY 2016 Budget Budget Budget Revenue(Operating): Water Revenue(Residential) $11,472,028 $3,817,891 $1,212,077 $3,667,584 $7,804,444 31.97% 96.06% Water Revenue(Commercial&Fire Det.) $1,385,979 $461,254 $179,605 496,428 889,551 35.82% 107.63% Water Revenue(Landscape/Irrigation) $2,782,183 $925,911 $317,890 896,502 1,885,681 32.22% 96.82% Water Revenue(Service Charge) $10,824,413 $1,282,143 $424,411 1,273,782 9,550,631 11.77% 99.35% Other Operating Revenue $645,110 $290,202 $70,056 241,587 403,523 37.45% 83.25% Total Operating Revenue: 27,109,713 6,777,400 2,204,039 6,575,883 20,533,830 24.26% Revenue(Non-Operating): Interest 85,000 21,250 14,442 35,531 49,469 41.80% Property Tax 1,395,000 41,850 35,144 37,661 1,357,339 2.70% Other Non-Operating Revenue 595,230 148,808 97,535 159,686 435,544 26.83% Total Non-Operating Revenue: 2,075,230 211,908 147,121 232,878 1,842,352 11.22% Total Revenue 29,184,943 6,989,308 2,351,160 6,808,761 22,376,182 23.33% Expenses(Operating): Variable Water Costs(G.W.,Import&Power) 12,080,410 4,020,360 903,666 3,053,358 9,027,052 25.28% 75.95% Salary Related Expenses 8,118,352 2,029,588 685,725 2,064,432 6,053,920 25.98% Supplies&Services: Communications 280,232 70,058 16,675 55,403 224,830 19.77% Contractual Services 545,124 136,281 49,198 119,430 425,694 21.91% Data Processing 217,461 54,365 28,261 48,917 168,544 22.49% Dues&Memberships 106,773 26,693 930 45,174 61,599 42.31% Fees&Permits 2,718,822 679,706 27,911 41,257 2,677,565 1.52% Board Election - - - - - Insurance 275,596 68,899 19,289 58,223 217,373 21.13% Materials 690,479 172,620 59,883 179,435 511,044 25.99% District Activities,Emp Recognition 27,072 6,768 522 2,635 24,437 9.73% Maintenance 415,101 103,775 (22,682) 62,333 352,768 15.02% Non-Capital Equipment 138,338 34,585 2,523 15,021 123,317 10.86% Office Expense 39,851 9,963 4,957 12,383 27,468 31.07% Professional Services 544,350 136,088 120,268 163,017 381,333 29.95% Training 67,718 16,930 1,640 7,792 59,926 11.51% Travel&Conferences 88,406 22,102 1,920 11,315 77,091 12.80% Uncollectible Accounts 37,200 9,300 (331) (2,463) 39,663 -6.62% Utilities 83,700 20,925 4,420 26,904 56,796 32.14% Vehicle Equipment 300,328 75,082 43,570 87,645 212,683 29.18% Supplies&Services 6,576,551 1,644,138 358,954 934,421 5,642,130 14.21% Total Operating Expenses 26,775,313 7,694,086 1,948,345 6,052,211 20,723,102 22.60% Expenses(Non-Operating): Interest on Long Term Debt 1,655,685 413,921 154,379 428,839 1,226,846 25.90% Other Expense 22,000 5,500 596 1,788 20,212 8.13% Total Non-Operating Expenses: 1,677,685 419,421 154,975 430,627 1,247,058 25.67% Total Expenses 28,452,998 8,113,507 2,103,320 6,482,838 21,970,160 22.78% Net Income(Loss)Before Capital Contributions 731,945 -1,124,200 247,840 325,923 406,022 44.53% Capital Contributions - 32,644 32,644 (32,644) 0% Net Income(Loss)Before Depreciation 731,945 (1,124,200) 280,484 358,567 373,378 48.99% Depreciation&Amortization 6,003,400 1,500,850 518,337 1,555,011 4,448,389 25.90% Total Net Income(Loss) (5,271,455) (2,625,050) (237,853) (1,196,444) (4,075,011) 22.70% Capital-Direct Labor - (12,928) (44,814) YORBA LINDA WATER DISTRICT SUMMARY FINANCIAL REPORT SEWER FUND-DRAFT For the period ended September 30,2015 Annual YTD Sept YTD YTD YTD YTD Budget Budget Actual Actual Under(Over) %of %of YTD FY 2016 FY 2016 FY 2016 FY 2016 Budget Budget Budget Revenue(Operating): Sewer Charge Revenue $1,584,348 $396,087 $122,005 $385,220 $1,199,128 24.31% 97.26% Locke Ranch Assessments $201,500 $6,045 $108 334 201,167 0.17% 5.52% Other Operating Revenue $36,291 $9,073 $1,549 22,018 14,273 60.67% 242.68% Total Operating Revenue: 1,822,139 411,205 123,662 407,572 1,414,567 22.37% Revenue(Non-Operating): Interest 8,000 2,000 1,410 2,820 5,180 35.25% Other Non-Operating Revenue 11,925 2,981 6,044 11,078 847 92.90% Total Non-Operating Revenue: 19,925 4,981 7,454 13,898 6,027 69.75% Total Revenue 1,842,064 416,186 131,116 421,470 1,420,594 22.88% Expenses(Operating): Salary Related Expenses 845,865 211,466 66,995 221,114 624,751 27.11 Supplies&Services: Communications 21,293 5,323 1,255 4,170 17,123 19.58% Contractual Services 41,031 10,258 3,462 8,739 32,292 21.30% Data Processing 16,368 4,092 2,127 3,591 12,777 21.94% Dues&Memberships 8,337 2,084 234 3,564 4,773 42.75% Fees&Permits 207,843 51,961 560 1,289 206,554 0.62% Board Election - - - - - Insurance 20,744 5,186 1,452 4,382 16,362 21.12% Materials 105,472 26,368 3,969 5,056 100,416 4.79% District Activities,Emp Recognition 2,038 510 39 198 1,840 9.72% Maintenance 332,244 83,061 4,073 4,273 327,971 1.29% Non-Capital Equipment 29,413 7,353 2,434 7,057 22,356 23.99% Office Expense 3,000 750 368 712 2,288 23.73% Professional Services 100,360 25,090 4,586 12,310 88,050 12.27% Training 7,297 1,824 201 789 6,508 10.81% Travel&Conferences 10,074 2,519 111 863 9,211 8.57% Uncollectible Accounts 2,800 700 (31) (335) 3,135 -11.96% Utilities 7,150 1,788 399 2,220 4,931 31.04% Vehicle Equipment 72,105 18,026 5,736 15,762 56,343 21.86% Supplies&Services 987,569 246,892 30,975 74,640 912,930 7.56% Total Operating Expenses 1,833,434 458,359 97,970 295,754 1,537,681 16.13% Expenses(Non-Operating): Interest on Long Term Debt - - - - - 0.00% Other Expense 0.00% Total Non-Operating Expenses: 0.00% Total Expenses 1,833,434 458,359 97,970 295,754 1,537,681 16.13% Net Income(Loss)Before Capital Contributions 8,630 -42,173 33,146 125,716 -117,086 1456.73% Capital Contributions - - 64,353 66,174 (66,174) 0% Net Income(Loss)Before Depreciation 8,630 (42,173) 97,499 191,890 (183,260)2223.52% Depreciation&Amortization 1,346,600 336,650 113,158 345,213 1,001,387 25.64% Total Net Income(Loss) (1,337,970) (378,823) (15,659) (153,323) (1,184,647) 11.46% Capital-Direct Labor (2,051) (8,226) YORBA LINDA WATER DISTRICT UNAUDITED COMBINING SCHEDULE OF NET ASSETS (with Administrative Penalties) - DRAFT September 30, 2015 (With September 30, 2014 for comparison only) ASSETS September 2015 September 2014 CURRENT ASSETS: Cash and cash equivalents $ 25,377,282 $ 21,100,913 Investment 9,410,039 9,249,075 Accounts receivable-water and sewer services 3,694,473 3,825,724 Accounts receivable-property taxes - - Accrued interest receivable 37,560 18,488 Prepaid expenses&other deposits 422,326 503,326 Inventory 250,161 265,946 TOTAL CURRENT ASSETS 39,191,841 34,963,472 NONCURRENT ASSETS: Bond issuance costs 443,843 469,002 Other post-employment benefit(OPEB)asset 142,701 138,944 Deferred Pension Plans 587,176 - Notes Receivable 226,741 - Capital assets: Non-depreciable 3,629,137 7,211,423 Depreciable, net of accumulated depreciation 189,466,156 190,938,770 TOTAL NONCURRENT ASSETS 194,495,754 198,758,139 TOTAL ASSETS 233,687,595 233,721,611 LIABILITIES CURRENT LIABILITIES: Accounts payable 1,624,695 3,301,218 Accrued expenses 1,063,927 1,110,683 Accrued interest payable 848,029 865,480 Certificates of Participation-current portion 765,000 735,000 Accrued OPEB 2,227 3,790 Refunding Revenue Bond-current portion 280,000 275,000 Compensated absences 313,340 300,638 Customer and construction deposits 415,546 334,798 Deferred revenue 342,064 380,796 TOTAL CURRENT LIABILITIES 5,654,828 7,307,403 LONG-TERM LIABILITIES(LESS CURRENT PORTION): Deferred annexation revenue 14,969,349 13,364,806 Compensated absences 992,243 855,663 Net Pension Liability 5,092,626 - Deferred Pension Plan 1,810,965 - Refunding Revenue Bond 8,329,916 8,070,000 LOC 6,458,297 4,970,754 Certificate of Participation 30,493,028 31,872,068 TOTAL LONG TERM LIABILITIES(LESS CURRENT PORTION) 68,146,424 59,133,291 TOTAL LIABILITIES 73,801,252 66,440,694 NET ASSETS: $ 159,886,343 $ 167,280,917 YORBA LINDA WATER DISTRICT UNAUDITED DEBT SERVICE RATIO CALCULATION (with Administrative Penalties) - DRAFT For the period ended September 30, 2015 YTD Debt Actual Service FY 2015 Calculation Revenue(Operating): Water Sales $6,334,296 $6,334,296 Other Operating Revenue 855,033 855,033 Total Operating Revenue: 7,189,329 7,189,329 Revenue(Non-Operating): Interest 35,531 35,531 Property Tax 37,661 37,661 Other Non-Operating Revenue 159,685 44,932 Total Non-Operating Revenue: 232,877 118,124 Total Revenue 7,422,206 7,307,453 Expenses(Operating): Variable Water Costs(G.W., Import&Power) 3,053,358 3,053,358 Salary Related Expenses 2,064,432 2,064,432 Supplies&Services 934,419 934,419 Depreciation 1,555,011 - Total Operating Expenses 7,607,220 6,052,209 Expenses(Non-Operating): Interest on Long Term Debt 428,840 - Other Expense 1,788 1,788 Total Non-Operating Expenses: 430,628 1,788 Total Expenses 8,037,848 6,053,997 Net Income(Loss) Before Capital Contributions (615,642) 1,253,456 Capital Contributions $ 32,644 $ - Net Change in Assets $ (582,998) $ 1,253,456 DEBT SERVICE RATIO CALCULATION: Net Revenues $ 1,253,456 Debt Service $ 680,390 % 184% YORBA LINDA WATER DISTRICT UNAUDITED COMBINING SCHEDULE OF REVENUES, EXPENSES - DRAFT AND CHANGES IN NET ASSETS (with Administrative Penalties) For the period ended September 30, 2015 (With fiscal year ended September 2014 for comparison only) September 2015 September 2014 OPERATING REVENUES: Water sales $ 6,334,296 $ 8,622,077 Sewer revenues 385,554 408,388 Other operating revenues 877,051 257,003 TOTAL OPERATING REVENUES 7,596,901 9,287,468 OPERATING EXPENSES Variable water costs 3,053,358 4,693,449 Personnel services 2,285,546 1,969,673 Supplies and services 1,009,060 1,057,731 Depreciation and amortization 1,900,224 1,840,117 TOTAL OPERATING EXPENSES 8,248,188 9,560,970 OPERATING INCOME/(LOSS) (651,287) (273,502) NONOPERATING REVENUES(EXPENSES): Property taxes 37,661 49,121 Investment income 38,351 31,736 Interest expense (428,840) (434,464) Other nonoperating revenues 170,763 100,204 Other nonoperating expenses (1,788) (39,030) TOTAL NONOPERATING REVENUES/EXPENSES (183,853) (292,433) NET INCOME/(LOSS) BEFORE CAPITAL CONTRIBUTIONS&EXTRAORDINARY ITEM(S) (835,140) (565,935) EXTRAORDINARY ITEM(S) - CAPITAL CONTRIBUTIONS 98,818 69,983 CHANGES IN NET ASSETS (736,322) (495,952) NET ASSETS-BEGINNING OF YEAR 160,622,665 167,776,869 NET ASSETS-FOR PERIOD END SEPTEMBER 30, 2015 $ 159,886,343 $ 167,280,917 YORBA LINDA WATER DISTRICT SUMMARY FINANCIAL REPORT WATER&SEWER FUNDS(with Administrative Penalties)-DRAFT For the period ended September 30,2015 Annual YTD Sept YTD YTD YTD YTD Budget Budget Actual Actual Under(Over) %of %of YTD FY 2016 FY 2016 FY 2016 FY 2016 Budget Budget Budget Revenue(Operating): Water Revenue(Residential) $11,472,028 $3,817,891 $1,212,077 $3,667,584 $7,804,444 31.97% 96.06% Water Revenue(Commercial&Fire Det.) 1,385,979 $461,254 $179,605 $496,428 $889,551 35.82% 107.63% Water Revenue(Landscape/Irrigation) 2,782,183 $925,911 $317,890 $896,502 $1,885,681 32.22% 96.82% Water Revenue(Service Charge) 10,824,413 $1,282,143 $424,411 $1,273,782 $9,550,631 11.77% 99.35% Sewer Charge Revenue 1,584,348 $396,087 $122,005 $385,220 $1,199,128 24.31% 97.26% Locke Ranch Assessments 201,500 $6,045 $108 $333 $201,167 0.17% 5.51% Other Operating Revenue 3,592,969 $898,242 $109,390 $877,051 $2,715,919 24.41% 97.64% Total Operating Revenue: 31,843,420 7,787,572 2,365,486 7,596,899 24,246,521 23.86% Revenue(Non-Operating): Interest 93,000 23,250 15,852 38,352 54,648 41.24% Property Tax 1,395,000 41,850 35,144 37,661 1,357,339 2.70% Other Non-Operating Revenue 607,155 151,789 103,579 170,764 436,391 28.13% Total Non-Operating Revenue: 2,095,155 216,889 154,575 246,777 1,848,378 11.78% Total Revenue 33,938,575 8,004,461 2,520,061 7,843,676 26,094,899 23.11% Expenses(Operating): Variable Water Costs(G.W.,Import&Power) 12,080,410 4,020,360 903,666 3,053,358 9,027,052 25.28% 75.95% Salary Related Expenses 8,964,218 2,241,055 752,720 2,285,546 6,678,672 25.50% Supplies&Services 7,564,117 1,891,029 389,929 1,009,060 6,555,053 13.34% Total Operating Expenses 28,608,745 8,152,444 2,046,315 6,347,964 22,260,777 22.19% Expenses(Non-Operating): Interest on Long Term Debt 1,655,685 413,921 154,379 428,840 1,226,845 25.90% Other Expense 22,000 5,500 596 1,788 20,212 8.13% Total Non-Operating Expenses: 1,677,685 419,421 154,975 430,628 1,247,057 25.67% Total Expenses 30,286,430 8,571,865 2,201,290 6,778,592 23,507,834 22.38% Net Income(Loss)Before Capital Contributions 3,652,145 -567,404 318,771 1,065,084 2,587,065 29.16% Capital Contributions - - 96,996 98,817 (98,817) 0% Net Income(Loss)Before Depreciation 3,652,145 (567,404) 415,767 1,163,901 2,488,248 31.87% Depreciation&Amortization 7,350,000 1,837,500 631,495 1,900,224 5,449,777 25.85% Total Net Income(Loss) (3,697,855) (2,404,904) (215,728) (736,322) (2,961,533) 19.91% Capital-Direct Labor (14,979) (53,041) YORBA LINDA WATER DISTRICT SUMMARY FINANCIAL REPORT WATER FUND(with Administrative Penalties)-DRAFT For the period ended September 30,2015 Annual YTD Sept YTD YTD YTD YTD Budget Budget Actual Actual Under(Over) %of %of YTD FY 2016 FY 2016 FY 2016 FY 2016 Budget Budget Budget Revenue(Operating): Water Revenue(Residential) $11,472,028 $3,817,891 $1,212,077 $3,667,584 $7,804,444 31.97% 96.06% Water Revenue(Commercial&Fire Det.) $1,385,979 $461,254 $179,605 496,428 889,551 35.82% 107.63% Water Revenue(Landscape/Irrigation) $2,782,183 $925,911 $317,890 896,502 1,885,681 32.22% 96.82% Water Revenue(Service Charge) $10,824,413 $1,282,143 $424,411 1,273,782 9,550,631 11.77% 99.35% Other Operating Revenue $3,556,678 $889,170 $107,841 855,032 2,701,646 24.04% 96.16% Total Operating Revenue: 30,021,281 7,376,368 2,241,824 7,189,328 22,831,953 23.95% Revenue(Non-Operating): Interest 85,000 21,250 14,442 35,531 49,469 41.80% Property Tax 1,395,000 41,850 35,144 37,661 1,357,339 2.70% Other Non-Operating Revenue 595,230 148,808 97,535 159,686 435,544 26.83% Total Non-Operating Revenue: 2,075,230 211,908 147,121 232,878 1,842,352 11.22% Total Revenue 32,096,511 7,588,275 2,388,945 7,422,206 24,674,305 23.12% Expenses(Operating): Variable Water Costs(G.W.,Import&Power) 12,080,410 4,020,360 903,666 3,053,358 9,027,052 25.28% 75.95% Salary Related Expenses 8,118,352 2,029,588 685,725 2,064,432 6,053,920 25.98% Supplies&Services: Communications 280,232 70,058 16,675 55,403 224,830 19.77% Contractual Services 545,124 136,281 49,198 119,430 425,694 21.91% Data Processing 217,461 54,365 28,261 48,917 168,544 22.49% Dues&Memberships 106,773 26,693 930 45,174 61,599 42.31% Fees&Permits 2,718,822 679,706 27,911 41,257 2,677,565 1.52% Board Election - - - - - Insurance 275,596 68,899 19,289 58,223 217,373 21.13% Materials 690,479 172,620 59,883 179,435 511,044 25.99% District Activities,Emp Recognition 27,072 6,768 522 2,635 24,437 9.73% Maintenance 415,101 103,775 (22,682) 62,333 352,768 15.02% Non-Capital Equipment 138,338 34,585 2,523 15,021 123,317 10.86% Office Expense 39,851 9,963 4,957 12,383 27,468 31.07% Professional Services 544,350 136,088 120,268 163,017 381,333 29.95% Training 67,718 16,930 1,640 7,792 59,926 11.51% Travel&Conferences 88,406 22,102 1,920 11,315 77,091 12.80% Uncollectible Accounts 37,200 9,300 (331) (2,463) 39,663 -6.62% Utilities 83,700 20,925 4,420 26,904 56,796 32.14% Vehicle Equipment 300,328 75,082 43,570 87,645 212,683 29.18% Supplies&Services 6,576,551 1,644,138 358,954 934,421 5,642,130 14.21% Total Operating Expenses 26,775,313 7,694,086 1,948,345 6,052,211 20,723,102 22.60% Expenses(Non-Operating): Interest on Long Term Debt 1,655,685 413,921 154,379 428,839 1,226,846 25.90% Other Expense 22,000 5,500 596 1,788 20,212 8.13% Total Non-Operating Expenses: 1,677,685 419,421 154,975 430,627 1,247,058 25.67% Total Expenses 28,452,998 8,113,507 2,103,320 6,482,838 21,970,160 22.78% Net Income(Loss)Before Capital Contributions 3,643,513 -525,232 285,625 939,368 2,704,145 25.78% Capital Contributions - - 32,644 32,644 32,644 0% Net Income(Loss)Before Depreciation 3,643,513 (525,232) 318,269 972,012 2,736,789 26.68% Depreciation&Amortization 6,003,400 1,500,850 518,337 1,555,011 4,448,389 25.90% Total Net Income(Loss) (2,359,887) (2,026,082) (200,068) (582,999) (1,776,888) 24.70% Capital-Direct Labor (12,928) (44,814) YORBA LINDA WATER DISTRICT SUMMARY FINANCIAL REPORT SEWER FUND(with Administrative Penalties)-DRAFT For the period ended September 30,2015 Annual YTD Sept YTD YTD YTD YTD Budget Budget Actual Actual Under(Over) %of %of YTD FY 2016 FY 2016 FY 2016 FY 2016 Budget Budget Budget Revenue(Operating): Sewer Charge Revenue $1,584,348 $396,087 $122,005 $385,220 $1,199,128 24.31% 97.26% Locke Ranch Assessments $201,500 $6,045 $108 334 201,167 0.17% 5.52% Other Operating Revenue $36,291 $9,073 $1,549 22,018 14,273 60.67% 242.68% Total Operating Revenue: 1,822,139 411,205 123,662 407,572 1,414,567 22.37% Revenue(Non-Operating): Interest 8,000 2,000 1,410 2,820 5,180 35.25% Other Non-Operating Revenue 11,925 2,981 6,044 11,078 847 92.90% Total Non-Operating Revenue: 19,925 4,981 7,454 13,898 6,027 69.75% Total Revenue 1,842,064 416,186 131,116 421,470 1,420,594 22.88% Expenses(Operating): Salary Related Expenses 845,865 211,466 66,995 221,114 624,751 27.11% Supplies&Services: Communications 21,293 5,323 1,255 4,170 17,123 19.58% Contractual Services 41,031 10,258 3,462 8,739 32,292 21.30% Data Processing 16,368 4,092 2,127 3,591 12,777 21.94% Dues&Memberships 8,337 2,084 234 3,564 4,773 42.75% Fees&Permits 207,843 51,961 560 1,289 206,554 0.62% Board Election - - - - - Insurance 20,744 5,186 1,452 4,382 16,362 21.12% Materials 105,472 26,368 3,969 5,056 100,416 4.79% District Activities,Emp Recognition 2,038 510 39 198 1,840 9.72% Maintenance 332,244 83,061 4,073 4,273 327,971 1.29% Non-Capital Equipment 29,413 7,353 2,434 7,057 22,356 23.99% Office Expense 3,000 750 368 712 2,288 23.73% Professional Services 100,360 25,090 4,586 12,310 88,050 12.27% Training 7,297 1,824 201 789 6,508 10.81% Travel&Conferences 10,074 2,519 111 863 9,211 8.57% Uncollectible Accounts 2,800 700 (31) (335) 3,135 -11.96% Utilities 7,150 1,788 399 2,220 4,931 31.04% Vehicle Equipment 72,105 18,026 5,736 15,762 56,343 21.86% Supplies&Services 987,569 246,892 30,975 74,640 912,930 7.56% Total Operating Expenses 1,833,434 458,359 97,970 295,754 1,537,681 16.13% Expenses(Non-Operating): Interest on Long Term Debt - - - - - 0.00% Other Expense 0.00% Total Non-Operating Expenses: 0.00% Total Expenses 1,833,434 458,359 97,970 295,754 1,537,681 16.13% Net Income(Loss)Before Capital Contributions 8,630 -42,173 33,146 125,716 -117,086 1456.73% Capital Contributions - - 64,353 66,174 66,174 0% Net Income(Loss)Before Depreciation 8,630 (42,173) 97,499 191,890 (50,912) 2223.52% Depreciation&Amortization 1,346,600 336,650 113,158 345,213 1,001,387 25.64% Total Net Income(Loss) (1,337,970) (378,823) (15,659) (153,323) (1,184,647) 11.46% Capital-Direct Labor (2,051) (8,226) go Backup Material Distributed Less Than 72 Hours Prior to the Meeting Yorba Linda Water District Budget Workshop FY 2015/ 16 15t Quarter Presented By: Marc Marcantonio, General Manager Delia Lugo, Finance Manager Cindy Botts, Management Analyst Noven Backup Material Distributed Less Than 72 Hours Prior to the Meeting .s Key Budget Assumptions Total Volume of Water Purchased I M14- : - •�i ' • - MWDOC Allocation Allowance MWDOC Allocation Overage @ $1 ,500 AF CUP Blended Rate (w/Allocation Surcharge) 16,534 A F $349/A F $1 ,094/$1 ,314/A F 8,072/ A F $822/ A F 15,554 A F $354/A F $1 , 125/$1 ,319/A F 8,072/ A F $827/AF 300.00 -. Vlw" 250.00 200.00 150.00 100.00 50.00 24 15 15 J Backup Material Distributed Less Than 72 Hours Prior to the Meeting R-GPCD Comparison Aw Backup Material Distributed Less Than 72 Hours Prior to the Meeting Budgeted Operating Plan 2015 - 2016 A , - "-ftif With CUP and S e Mamays-w 36%o Reduction;- ; know- D 15% AllocaftoR ='y g Projection Annual Water Purchases 1 16,534.00 Percent GW CUP I mport Total Annual Month (A/F) (A/F) (A/F) (A/F) Demands Jul-15 1,237.69 134.28 574.09 1,946.05 12% Aug-15 1,217.71 137.85 559.07 1,914.64 12% Sep-15 1,054.11 132.71 493.04 1,679.85 10% Oct 15 878.52 133.19 405.25 1,416.96 9% Nov-15 671.61 133.20 314.54 1,119.35 7% Dec-15 563.88 130.90 312.15 1,006.92 6% Jan-16 480.24 132.57 265.14 877.96 5% Feb-16 459.44 131.03 249.46 839.93 5% Mar-16 557.39 131.39 306.57 995.35 6% Apr-16 747.01 133.22 364.79 1,245.01 8% May-16 1,030.89 131.74 484.16 1,646.79 10% Jun-16 1,168.01 133.78 543.41 1,845.19 11% FYTD 10.066.49 1.595.86 4.871.65 16.534.00 100% Backup Material Distributed Less Than 72 Hours Prior to the Meeting Actual Operating Plan 2015 - 2016 Operating Plan With CUP and State Mandate of 36% Reduction, Projection Annual Water Purchases 1 15,555.29 ' GW CUP I mport Total Percent Annual Month A/F A/F A/F A/F Demands Jul-15 1,009.87 - 475.12 1,484.99 10% Aug-15 1,109.73 - 525.73 1,635.47 11% Sep-15 988.06 - 465.63 1,453.68 9% Oct-15 803.59 216.76 383.07 1,403.42 9% Nov-15 570.87 234.50 313.98 1,119.35 7% Dec-15 493.39 231.59 281.94 1,006.92 6% Jan-16 399.47 232.66 245.83 877.96 6% Feb-16 373.77 230.98 235.18 839.93 5% Mar-16 482.74 233.91 278.70 995.35 6% Apr-16 681.45 214.96 348.60 1,245.01 8% May-16 1,185.69 - 461.10 1,646.79 11% Jun-16 1,328.54 - 516.65 1,845.19 12% 9,427.16 1,595.36 4,531.53 15,554.05 100% Black Text = Actuals, Red Text = Budget Backup Material Distributed Less Than 72 Hours Prior to the Meeting 20,000.0 - jjjjjjPllllllllllllllllllll 15,000.0 5,000.0 MI Ir. Historical Demand (Budgeted vs. Actual) 2 00 21,053.00 21,980.00 FYI 1/12 FYI 2/13 FYI 3/14 Total Demand Anticipated Demand 16,534. 0 G o- 10 Sri FYI 4/15 FYI 5/1 Budgeted Demand $1,200,000 $1,000,000 Bonn nnn $600,000 $400,000 $200,000 $600,000 $500,000 $400,000 $300,000 $200,000 $100,000 Backup Material Distributed Less Than 72 Hours Prior to the Meeting 19,288 AF Historical Power Costs Historical Electricity Charges (so rn California Edisom .64N of Aiiaheim� .J� 21,789 AF \ 22 - _- FY11/12 FY12/13 ■Actual Electricity$ Historical Gas Charges 22,646 AF 4F �* 19,786 AF r- (The Gas Company) 21,789 AF 19,288 AF 20,832 AF � N cl� NO CO O � N 64 N N s4 FY10/11 FYI 1/12 FYI 2/13 ■Actual Gas $ 22,646 AF 4F �* 19,786 AF r- Backup Material Distributed Less Than 72 Hours Prior to the Meeting Import Water Costs 4717"o -tom•---- _ , c __ - _ Approvdd _ — —.-Projected WiV_77 - Budgeted Demand (16,534 AF) Budgeted Demand (15,554 AF) Import Water Total Costs Water Purchases July-Dec 2015 $ 2,458,771.64 $ 21262,059.46 Water Purchases Jan-Jun 2016 $ 2,093,990.55 $ 1,973,414.38 CUP Water Purchases $ 1,317,292.72 $ 1,305,166.66 CUP Allocation Costs $ - $ - Readiness to Serve Charge $ 736,896.00 $ 736,896.00 Capacity Charge $ 270,691.80 $ 270,691.80 Retail Connection Charge $ 257,953.50 $ 257,953.50 TOTAL $ 71135,596.21 $ 61806,181 .80 $ (329,414.41) • Delay of CUP Until October 2015 • Budgeted at 36% Conservation, Achieved Summer Average of Backup Material Distributed Less Than 72 Hours Prior to the Meeting Groundwater Costs Approved - Projected Budgeted Demand (16,534 AF) Groundwater Total Costs Water Purchases July-Dec 2015 $ 1,810,770.55 Water Purchases Jan-Jun 2016 $ 1,430,639.06 OCWD Annexation Annual Fee $ 300,000.00 TOTAL $ 3,541 ,409.61 Budgeted Deman( (15,554 AF) $ 1,602,113.19 $ 1,433,433.69 $ 300,000.00 $ 3,335,546.87 $ (205,862.73 • Budgeted at 36% Conservation, Achieved Summer Average o It7 * Backup Material Distributed Less Than 72 Hours Prior to the Meeting Power & Pumping Costs VP 1st Quarter Power & Pumping Costs 1st Quarter Budgeted Budgeted 1st Quarter Actual $ 470,696.63 $ 1st Quarter Actual (FY14/15) 235,030.11 $ 557,028.00 TOTAL $ 47006.63 $ 235,030.11 $ 557,028.00 $ (235,666.52) $ 86,331.371 • Delay of CUP Until October 2015 • Lower Consumption Than Anticipated • Emphasis on Gas Pumps, Avoided Electric Summer Rates • Negotiated with S.C.E. on Rate Structure at Yorba Linda BPS • Negotiated with MWDOC/OCWD on Alteration of Operating Plan Backup Material Distributed Less Than 72 Hours Prior to the Meeting Budget Summary (Water & Sewer) Actual Budge Approved-Budget _ Re uised Budget 11�►� _ �-- _ (FY 4/15 �(W r573'6� Revenue Total Operating Revenue Total Non-Operating Revenue Total Revenue Expenses Variable Water Costs Salary-Related Expenses Supplies & Services Total Operating Expenses Total Non- Operating Expenses Total Expenses Income Before Depreciation & Capital Contributions Depreciation Capital Contributions Income (Loss) $29,683,400 $30,445,658 $31,047,550 $2,428,377 $2,095,155 $2,095,155 $32,111,777 $12,733,762 $7,778,763 $3,806,900 $32,540,813 $12,080,410 $8,964,218 $7,564,117 $33,142,705 $11,479,780 $8,964,218 $7,564,117 $24,319,425 $28,608,745 $28,008,115 $1,799,567 $1,677,685 $1,677,685 $26,118,992 $5,992,785 $7,432,586 $705,848 ($733,953) $30,286,430 $2,254,384 $7,350,000 $0 ($5,095,616) $29,685,800 $3,456,905 $6,003,400 $0 ($2,546,495) Backup Material Distributed Less Than 72 Hours Prior to the Meeting Budget Summary (Water Only) Actual Budget Approved Budget Revised Budget Debt Coverage Y 15/16) Ratio °7_ $10,783,706- ;�' $404783,70 ' . $2,615,252 $2,615,252 (FY 14/15) j1 6) Revenuetir.: � f Water Revenue (Residential j $15,461,640 1,472,028 1,513,712 $I38� Water Revenue_(Landscape/Irrigation) $4,058,308 $2,782,183 Service Charges Other Operating Revenue Total Operating Revenue Total Non-Operating Revenue Total Revenue Expenses Variable Water Costs Salary-Related Expenses Supplies &Services Total Operating Expenses Total Non- Operating Expenses Total Expenses Income Before Depreciation& Capital Contributions Depreciation Capital Contributions Income (Loss) $5,012,958 $9,426,652 $10,824,413 $10,824,413 MR $1,312,235 $3,556,678 $3,556,679 $3,556,679 $27,758,853 $28,623,519 $29,082,870 $29,082,870 $2,380,383 $2,075,230 $2,075,230 $1,615,230 $30,139,236 $30,698,749 $31,158,100 $30,698,100 $12,733,762 $12,080,410 $11,479,780 $11,479,780 $6,885,991 $8,118,352 $8,118,352 $8,118,352 $3,482,354 $6,576,551 $6,576,551 $6,576,551 $23,102,107 $26,775,313 $26,174,683 $26,174,683 $1,799,567 $1,677,685 $1,677,685 $22,000 $24,901,674 $28,452,998 $27,852,368 $26,196,683 $5,237,562 $2,245,751 $3,305,732 $0 $6,088,966 $6,003,400 $6,003,400 $0 $547,855 $0 $0 $0 ($303,549) ($3,757,649) ($2,697,668) $4,501,417 Debt Service Obligation $ 2,721,558 Debt Service Coverage 165.40% Backup Material Distributed Less Than 72 Hours Prior to the Meeting Budget Summary (Sewer Only) Sewer Parcel Assessments Other Operating Revenue Total Operating Revenue Total Non-Operating Revenue Total Revenue Expenses Variable Water Costs Salary-Related Expenses Supplies & Services Total Operating Expenses Total Non- Operating Expenses Total Expenses Actual BLWget kAppr o r et -Revised Budget ' -' Fr-1 5 ��' - FY 15- 1 - ►�,,. _ y-p. $1,842,064 $1,984,605 $0 $0 $1,582,061 1,58 $845,865 $845,865 $193,615 $148,871 $201,500 $36,291 $201,501 $36,291 $1,217,318 Income Before Depreciation & Capital Contributions Depreciation Capital Contributions Income (Loss) $1,924,547 $1,822,139 $1,964,680 $47,994 $19,925 $19,925 $1,972,541 $1,842,064 $1,984,605 $0 $0 $0 $892,772 $845,865 $845,865 $324,546 $987,566 $987,566 $1,217,318 $1,833,432 $1,833,432 $0 $0 $0 $1,217,318 $1,833,432 $1,833,432 $755,223 $8,633 $151,174 $1,343,620 $1,346,600 $1,346,600 $157,993 $0 $0 ($430,404) ($1,337,967) ($1,195,426) Backup Material Distributed Less Than 72 Hours Prior to the Meeting 5 Year CIP Projections See attachment Capital Reserve/Investment Acct Balance 9/30/2015 $19,007,947 WFB Letter of Credit Balance for Draws 9/30/2015 $541,703 Backup Material Distributed Less Than 72 Hours Prior to the Meeting Less Minimum Water Capital Reserve Requirement $1,820,000 Water Capital Funds Available for Use $17,729,650 Total CIP Budget as Approved FY 2015/16 CIP Budget and Expenses 4 Year CIP Budget For Expenditures for Approved Projects S&W Well Project(Well No.21) Total Project CY Additions to Total Project Total CIP $ 1,114,787 Approved CIP Expenditures FY 15/16 $ 364,400 FY 16/17 FY 17/18 FY 18/19 FY 19/20 4 Year Future Project Description Budget CIP as Approved Budget Expenditures 2,500,000 Budget for FY 7/1/15 Through (November- $ - Budgeted CIP Budgeted CIP Budgeted CIP Budgeted CIP Projected $ 2015/16 by Board Action 2015/16 Thru FYE June $ $ 2015/16 10/31/15 June)Forecast 1,000,000 Expenditures Expenditures Expenditures Expenditures Budgets 350,000 $ $ 5,599,996 Lakeview Grade Separation 2015 $ 662,444 $ $ 662,444 $ 402,859 $ 259,585 $ 3,459 $ 256,126 $ - S&W Well Project(Well No.21) 09-22 421 $ 2,306,789 $ $ 2,306,789 $ 1,114,787 $ 1,192,002 $ 11,185 $ 364,400 $ 816,417 $ - $ - $ $ 816,417 S&W Well Project(Well No.22) 09-22 422 $ 2,500,000 $ $ 2,500,000 $ 35,315 $ 217,325 $ - $ 45,000 $ 945,000 $ 155,000 $ 1,319,685 $ $ 2,419,685 Fairmont BPS Upgrade 10-11 $ 6,300,000 $ $ 6,300,000 $ 699,892 $ 1,000,000 $ 112 $ - $ 1,750,000 $ 3,499,996 $ 350,000 $ $ 5,599,996 Lakeview Grade Separation 10-02 $ 662,444 $ $ 662,444 $ 402,859 $ 259,585 $ 3,459 $ 256,126 $ - $ - $ - $ $ - Richfield Road Pipeline 14-23 $ 1,450,000 $ $ 1,450,000 $ 61,718 $ 1,278,282 $ 15,614 $ 330,300 $ 1,042,368 $ - $ - $ $ 1,042,368 $ 29,611 $ Subtotal $ 13,219,233 $ $ 13,219,233 $ 2,314,571 $ 3,947,194 $ 30,370 $ 995,826 $ 4,553,785 $ 3,654,996 $ 1,669,685 $ $ 9,878,466 Rehabilitation&Restoration Future Pipeline Project 14-12 $ 1,240,000 $ $ 1,240,000 $ 27,921 $ 753,951 $ 4,103 $ 180,000 $ 1,027,976 $ - $ $ $ 1,027,976 Timber Ridge BPS Rehabilitation - $ 250,000 $ $ 250,000 $ - $ 240,000 $ - $ - $ - $ 250,000 $ $ $ 250,000 Lakeview Booster Piping - $ 100,000 $ $ 100,000 $ - $ 100,000 $ $ $ - $ 76,900 $ 23,100 $ $ 100,000 PRS Rehabilitation Phase 2 14-11 $ 1,430,000 $ $ 1,430,000 $ 1,690 $ 183,310 $ $ $ 957,210 $ 471,100 $ - $ $ 1,428,310 Annual Routine Capital R&R $ 3,668,590 $ $ 3,668,590 $ - $ - $ 31,819 $ $ - $ 1,802,476 $ 1,834,295 $ $ 3,636,771 R&R Subtotal $ 6,688,590 $ $ 6,688,590 $ 29,611 $ 1,277,261 $ 35,922 $ 180,000 $ 1,985,186 $ 2,600,476 $ 1,857,395 $ $ 6,443,057 Vehicle&Capital Equipment Replacement $ 680,000 $ $ 680,000 $ - $ 680,000 $ 391,604 $ 288,396 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 800,000 Vehicle&Capital Equipment Replacement $ 392,000 $ $ 392,000 $ $ 392,000 $ - $ 392,000 $612,000 $165,000 $177,000 $180,000 $ 1,134,000 Vehicle&Capital Equipment Subtotal $ 1,072,000 $ $ 1,072,000 $ $ 1,072,000 $ 391,604 $ 680,396 $ 812,000 $ 365,000 $ 377,000 $ 380,000 $ 1,934,000 Repayment of LOC Principal to Wells Fargo Bank $ 7,000,000 Subtotal $ 20,979,823 $ - $ 20,979,823 $ 2,344,183 $ 6,296,455 $ 457,895 $ 1,856,222 $ 14,350,971 $ 6,620,472 $ 3,904,080 $ 380,000 $ 18,255,523 CIP Grand Totals $ 20,979,823 $ - $ 20,979,823 $ 2,344,183 $ 6,296,455 $ 457,895 $ 1,856,222 $ 14,350,971 $ 6,620,472 $ 3,904,080 $ 380,000 $ 18,255,523 Balance in Capital Reserve/Investment Fund $ 15,873,428 $ 1,522,457 ($5,098,015) ($9,002,095) ($9,382,095)