Loading...
18-0116_RANCHO MISSION VIEJO_E9_Agenda ReportTO : FROM: SUBMITTED BY: PREPARED BY: DATE : SUBJECT: City of San Juan Capistrano Agenda Report Honorable Mayor and Members of the City Council ~n Siegel, City Manager Ken Al-lmam, Chief Financial Officer ~ Michelle Bannigan, Assistant Finance Director ~ January 16, 2018 1/16/2018 E9 Consideration of the First Quarter Financial Report for the Period Ended September 30, 2017; Proposed Budget Adjustments and Appropriations; and Approval of Funding Assistance Agreement with Rancho Mission Viejo, LLC, Regarding the Ortega Highway Widening Project RECOMMENDATIONS: 1. Receive and file the Fiscal Year 2017-18 First Quarter Financial Report; 2. Approve the proposed adjustments to the City's operating and capital improvement program budgets, as presented in Attachment 5; and, 3. Increase the Rate Stabilization Reserve of the Water Operations Funds by $500,000, as provided by Section 5.5 of the 2017 Refunding Revenue Installment Agreement. 4. Authorize the City Manager to execute the Letter Agreement with Rancho Mission Viejo, LLC (Attachment 1 0); and, 5. Authorize reimbursement of $55,985.50 of project design costs to Rancho Mission Viejo, LLC, from the Capistrano Circulation Fee Program Fund, for the Ortega Highway Widening Project. EXECUTIVE SUMMARY : The first quarter financial report provides the City Council with an analysis of the financial activity of the City from the start of the fiscal year to the end of that quarter. Year to date activity of the General Fund through September 30, 2017, shows expenditures exceeding revenues by $3.2 million for that three month period. This is City Council Agenda Report January 16, 2018 Page 2 of 13 consistent with the performance of the General Fund for the first three months of the previous fiscal year. This shortfall of revenues over expenditures for the quarter is due to the fact that the General Fund only receives 7% of its annual revenues in the first three months of each fiscal year. As a point of comparison, for the first three months of the prior fiscal year (Fiscal Year 2016-17), General Fund expenditures exceeded revenues by $4.1 million. The improved performance of the General Fund for the first three months of Fiscal Year 2017-18 over the same period of the prior fiscal year is primarily due to the fact that only 18% of budgeted General Fund appropriations were, in fact, expended through September 30, 2017, compared to 22% of the appropriations expended through the same period of the prior fiscal year. A number of budget adjustments have been reflected in the accompanying projections to align General Fund revenues and expenditures with the most up to date information available to properly project financial results for the entirety of Fiscal Year 2017-18. Proposed revenue adjustments would reduce budgeted revenues of the General Fund by $8,488. The revenue associated with the license agreement with Verizon Wireless (for a wireless facility behind City Hall) requires an adjustment to lower revenues by $10,000 because the license agreement did not begin until December 2017. In addition, proposed appropriation adjustments would increase General Fund appropriations by $65,000, primarily due to personnel budget changes. The net impact of the proposed revenue and appropriation adjustments to the General Fund would be a reduction in available fund balance by $73,000. DISCUSSION/ANALYSIS : General Fund Revenues With 25% of the fiscal year complete, General Fund revenues (including transfers from other funds) are at $1.9 million, 7% of the amended budget. This represents $85,000 (5%) more than that for the same period of the prior fiscal year. Total General Fund revenues for the entire 2017-18 Fiscal Year are projected to be $27.7 million, slightly higher than actual Fiscal Year 2016-17 revenues of $27.4 million. City Council Agenda Report January 16, 2018 Page 3 of 13 General Fund Revenue Summ ary Actual Actual Through Budget Amended 11 l Through Percent Revised 121 September Update Budget September Realized Projections Description 2016 2017/18 2017/18 2017 2017/18 2017/18 Property Taxes $160,072 $10,123,000 $10,123,000 $ 167 ,744 2% $10,123,000 Sales Tax 8,308,000 8,308,000 548 ,867 7% 8,308,000 Other Taxes and Franchise Fees 406 ,519 2,734,000 2,734,000 137,288 5% 2,734,000 Revenue from Other Ag encies 77 ,921 738,000 738,000 7,244 1% 738 ,000 Licenses , Fees and Perm its 611 ,771 1,873,000 1,873,000 527,015 28% 1,873,000 Current Senlices 141 ,921 787 ,000 787,000 143 ,915 18% 787,000 Interest and Rents 92 ,543 468,000 468 ,000 118 ,103 25% 458 ,000 Fines and Forfeitures 175,078 967 ,000 967,000 118 ,656 12% 967,000 Other Revenue 4,038 76,000 78,520 4,747 6% 78,520 Transfers In 162,669 455,000 569,000 143 ,511 25% 570,512 REVENUE TOTAL $1,832,532 $26 ,529,000 $26,645,520 $1,917,090 7% $26,637,032 Continuing Appropriations 596,355 1,043,895 1,043 ,895 1,043,895 REVENUE AND OTHER SOURCES TOTAL $2,428,887 $26,529,000 $27,689,415 $2,960,985 $27,680,927 111 Includes carryover amounts from Fiscal Year 2016-17 and City Council approved adjustments through December 5, 2017 . 121 Thi s column reflects the impact of proposed first quarter adjustments . Information about significant revenues of the City's General Fund is as follows (accompanied by the percentage that each revenue classification bears in relation to total revenues of the General Fund, including transfers from other funds): Property Taxes (38% of General Fund revenues) -Property taxes are the single largest funding source for General Fund operations. The County collects property tax in April and December. No changes in property tax projections have been reflected in the first quarter financial report because staff doesn 't expect to receive updated cash flow estimates from the County until February 2018. Sales Tax (31 %) -Sales tax revenue distributed to the City in the first quarter of Fiscal Year 2017-18 reflects merchant sales activity that occurred in April through June of 2017. Sales tax revenue received in the first quarter of Fiscal Year 2017-18 was 2.7% less than that for the first quarter of Fiscal Year 2016-17. This is because in the first quarter of Fiscal Year 2016-17, the City received additional funds as a result of adjustments that were made by the California Board of Equalization in the distribution of sales taxes to Orange County cities. After adjusting for such adjustments, the amount of sales tax revenue actually earned by the City for merchant sales activity in April through June of 2017 was 2.3% higher than that for the same quarter of the previous year. Other Taxes and Franchise Fees (10%)-This category includes real property transfer taxes, business license taxes, transient occupancy taxes, and franchise fees. Business license taxes are at 2% of the City's Fiscal Year 2017-18 budget. The City receives the bulk of its business license revenue during the months of December and January. Real property transfer taxes through September 2017 are consistent with prior year amounts for the same quarter. As of September 30, 2016, the City had not collected any transient occupancy tax (TOT) revenue because such revenue for the quarter ended September 30, 2017 is not due to the City until October 31, 2017. Lastly, the City's franchise fee revenue collected through September 30, 2017 is lower than the amount collected in the City Council Agenda Report January 16, 2018 Page 4 of 13 same quarter of the previous year because the City's Fiscal Year 2016-17 revenue included cable TV franchise fees for Fiscal Year 2015-16 that were not collected until Fiscal Year 2016-17. Revenue from Other Agencies (3%) -This category includes federal, state, and local grant revenues, including revenues the City receives from the County for a waste disposal mitigation agreement. Revenue collected through September 2017 is as expected at approximately 1% of the amended budget. Licenses, Fees and Permits (7%)-This category consists largely of fees charged to process building permits and fees collected to finance engineering and planning division reviews of development projects. This category also accounts for revenue from City sponsored events, community services programs, and other fees. Revenue is on track at 28% of the amount in the amended budget that has been collected through September 2017. Residential development activity in the City is higher through the first quarter with 23 permits (a total permit valuation of $7.7 million) being issued for new housing from July to September 2017 as compared to 12 permits (a total permit valuation of $5.5 million) for the same period last year. Community service program revenues to date are better than expected with 35% of the budgeted revenue received through September 2017, an increase of 18% over the same period last year. Other licenses, fees, and permit revenues include neighborhood parking permits, commercial filming permit fees, photography permit fees, and National Pollutant Discharge Elimination System (NPDES) permit fees. Development Services staff recently updated the City 's development projections. City staff in the Planning and Engineering Divisions is reviewing this information to determine whether any adjustments need to be made to the City's Fiscal Year 2017-18 revenue budget. Staff will communicate any revised projections to the City Council in the City's second quarter financial report. Current Services (3%) -This category consists of revenue from other funds for their share of General Fund overhead costs. These charges are based on each fund's percentage of budgeted full-time salaries. Actual revenue through September 2017 is consistent with the amount received for the same period last fiscal year. Interest and Rents (2%) -This category accounts for revenue generated from the investment of City funds and the renting of City properties. Activity through September is as expected at 25% of the amended budget. The Fiscal Year 2017-18 budget assumed a full twelve months of revenue for the Verizon Wireless license agreement. However, the Verizon Wireless license agreement took effect in December 2017. As a result, staff has proposed a revenue reduction of $10,000 for Fiscal Year 2017-18. Fines and Forfeitures (4%)-These revenues are remitted to the City from the County and State for vehicle code and other vehicular violations, parking fines, and Proposition 172 (Yz cent sales tax) funds dedicated to public safety. As a result, these revenues lag slightly from the events that generate the revenue. Revenues as of September 30, 2017, are less than expected at only 12% of budget primarily due to reduced revenues for parking fines and vehicle code fines. Staff will continue to monitor this activity to determine whether the City's Fiscal Year 2017-18 budget requires adjustment. City Council Agenda Report January 16, 2018 Page 5 of 13 Other Revenue (less than 1 %) -These one-time revenues include miscellaneous receipts for sales of City property, damage to city property, community donations, and various other reimbursements. These revenues typically fluctuate from year to year. Transfers In (2%) -Transfers in represent amounts received from other funds of the City to reimburse the General Fund for costs paid by the General Fund that meet the eligibility requirements associated with other funds. For Fiscal Year 2017-18, such reimbursement primarily pertains to costs paid by the General Fund for public safety, senior nutrition transportation, street maintenance costs, and the summer trolley program. A minor adjustment is proposed to increase revenue by $1,512 to transfer the actual Fiscal Year 2016-17 revenue received from the State for the Citizens' Option for Public Safety (COPS) program to the General Fund for reimbursement of eligible public safety costs that had been incurred by the General Fund. General Fund Expenditures With 25% of the fiscal year complete, General Fund expenditures are at 18% of the amended budget. This is in line with expectations due to seasonal fluctuations in the timing of General Fund expenditures. Transfers to other funds are at 96% because the General Fund provides funding for the principal and interest payment associated with the 2011 Judgment Obligation Bonds that is due each August 1st. Staff is proposing adjustments to increase General Fund expenditures by $65,000 to address miscellaneous personnel-related adjustments. In addition, the City's business license budget requires an additional $9,000 to fund the cost of a hearing officer to administer the appeal of a business license application and to address additional costs associated with the revision of business license application and renewal forms as a result of the State legislature's approval of Assembly Bill 1379. General Fund Expenditure Summary Actual Actual Through Budget Amended 111 Through Percent Revised 121 September Update Budget September Realized ProJections Description 2016 2017/18 2017/18 2017 2017/18 2017/18 City Council $38,108 $164,895 $164,895 $40,582 25% $164,895 City Manager 330,568 1,481,720 1,504,720 303,088 20% 1,504,720 City Attorney 84,479 619,210 1,071,210 56,661 5% 1,071,210 City Clerk 132,767 592,600 592,600 127,714 22% 599,600 Finance 398,057 1,458,705 1,494,225 315,658 21% 1,557,225 Public Safety 2,349,145 10,664,785 10,681,663 1,713,208 16% 10,681,663 Community Services 514,746 2,155,505 2,155,215 479,395 22% 2 ,155,215 Development Services 653,628 2,530,695 2,575,695 559,544 22% 2,575,695 Public Works/Utilities 1,151,421 6,548,670 6,934,960 1,028,766 15% 6,929,960 Non-Departmental 0% Transfers Out 320,456 307,980 477,875 461,066 96% 477 ,875 EXPENDITURE TOTAL $5,973,375 $26,524,765 $27,653,058 $5,085,682 18% $27,718,058 1111ncludes carryover amounts from Fiscal Year 2016-17 and City Council approved adjustments through December 5, 2017. 121 This column reflects the impact of proposed first quarter adjustments. City Council Agenda Report January 16, 2018 Page 6 of 13 Fund Balance of the General Fund The spendable fund balance of the General Fund as of the end of Fiscal Year 2017-18 is projected to be $16.4 million, after taking into account $1.0 million of delayed spending from Fiscal Year 2016-17 that has been carried over and added to the expenditures projected for Fiscal Year 2017-18. A summary of the funding sources appropriated for General Fund financial activity in Fiscal Year 2017-18 is set forth below: General Fund Summary Actual Actual Through Budget Amended Through Percent Rev1sed September Update Budget September Realized Projections Description 2016 2017118 2017118 2017 2017118 2017118 Rewnues including interfund transfers Expenditures $ 1,832 ,532 $26 ,529 ,000 $26 ,645 ,520 $ 1,917 ,090 7% $26,637 ,032 5,973 ,375 26 ,524 ,765 27,653 ,058 5,085 ,682 18% 27,718,058 Rewnues owr (under) expend itures Ot her funding : (4 , 140 ,843) 4 ,235 (1 ,007 ,538) (3,168,592) (1 ,081 ,026) Carryowr of continuing appropriations 596,355 1,043 ,895 1,043 ,895 1,043 ,895 Municipal Offices Sign (9/5/17) 5,000 Evaluation of OCS D contract (9/5/17) 16 ,878 Acjachema Street Storm Drain repairs (11/7/17) Proposed appropriation of fund balance 60 ,000 73,488 Projected results after other funding $ (3,544 ,488) $ 4,235 $ 36,357 $ (2 , 124,697) $ 118,235 Spendable fund balance , July 1 Rewnues owr/(under) expenditures Adjust ment for prepaids $16 ,365 ,187 $14 ,816,173 $17,468,139 "$17,468 ,139 (4 , 140,843) 4,235 (1,007 ,538) (3, 168,592) 9,817 26 ,082 26 ,082 $17,468 ,139 (1 ,081 ,026) 26,082 Spendable fund balance , end of period $12 ,234 ,161 $14,820,408 $16 ,486 ,683 $14 ,325 ,629 $16 ,413 ,195 %of FY 2017-18 projected operating expenditures Water Enterprise Operating Funds (Funds 60 through 62 and Fund 66) For the first quarter of the 2017-18 Fiscal Year, the revenues of the Water Operations Funds were at 30% of the amended annual budget and total expenses were at 13% of the amended annual budget. More specifically, commodity sales revenue was higher than expected (34% of the amount budgeted for the entire year). The quantity of water delivered to customers was 2,398 acre feet. Groundwater Recovery Plant (GWRP) production through September 2017 was 449 acre feet, 50% lower than planned production for the first quarter. This reduced production is a result of the San Juan Basin Authority asking the City to reduce the amount of water that the City retrieves from the basin. As a result, the accompanying proposed budget adjustments reflect a reduction in the amount of water expected to be produced by the GWRP for Fiscal Year 2017-18 from 3,456 acre feet to 2,384 acre feet. A budget adjustment has also been proposed to increase imported water purchases from the Municipal Water District of Orange County (MWDOC) by 1 ,072 acre feet, resulting in an increase in the amount budgeted for imported water purchases to $1.2 million. The reduced GWRP production also reduces the Fiscal Year 2017-18 grant revenue estimate by $268,000 and electricity costs for the plant by $90,000. In addition, 60 % City Council Agenda Report January 16, 2018 Page 7 of 13 an adjustment is proposed for $210,000 to purchase Train B membranes for the GWRP. This purchase was planned and budgeted for in Fiscal Year 2016-17, however, the purchase was not completed during that fiscal year and will be addressed in Fiscal Year 2017-18. The excess of revenue over expense across all cost centers of the Water Operations Funds is projected to be $1.5 million for Fiscal Year 2017-18. After transfers of $789 ,705 to the Water Capital Project Funds and $500 ,000 to the Water Rate Stabilization Reserve , the negative fund balance of the Water Operations Funds is projected to be at $837,586 as of the end of Fiscal Year 2017-18. After taking into account the $3.6 million outstanding balance of the promissory note owed by the Water Fund to the Sewer Fund, the total operating deficit of the Water Operations Funds is projected to be $4.5 million. This deficit is expected to be reduced over the next two fiscal years as a result of the implementation of two additional 5% water rate increases and an increase in water sales as a result of the elimination of the water use penalties that were in effect during the state-wide drought. Water Operations Funds S ummary Actual Budget Amended 111 Through Percent Rev1sed i21 Update Budget September Realized ProjectiOns Description 2017/18 2017/18 2017 2017/18 2017/18 Available Fu n d Balance, July 1 $ (3,079,289) s (1 ,056 ,9 57) s (1,056,9 57) $ (1,056,957) Revenues Water Commodity Charges $ 14,498,000 $ 14,498,000 $ 4,977,178 34% $ 14,498,000 Cus tomer Services Charge s 4,994,000 4,994,000 1,265,592 25% 4,994,000 Adm i nis trative Citations (Drought Penalties) (570) 0% Other Water Service Revenues 458,900 458,900 225,786 49% 458,900 Property Taxes-General 1,062,560 1,062,560 28,934 3% 1,062,560 MWD Grant@ $250/af 869,250 869,250 27,550 3% 601,250 Other Revenue 11,000 11,000 6,035 55% 11,000 REVENUE TOTAL $ 21,893,710 $ 21,893,710 $ 6,530,505 30% $ 21,625,710 Expenses Source of Supply $ 6,311,884 $ 6,313,034 $ 1,358,545 22% $ 7,535,694 Maintenance & Operations 6,125,105 6,371,955 861,658 14% 6,338,295 General & Administrative 1 '138,725 1,158,725 219,200 19% 1,156,725 Legal 500,000 690,000 86,026 12% 690,000 Debt Service 4,395,920 4,395,920 1,250 0% 4,395,920 EXPENSE TOTAL $ 18,471,634 $ 18,929,634 $ 2 ,526,679 13% $ 20,116,634 Revenues Over/(Under) Expenses 3,422,076 2,964,076 4,003,826 1,509,076 Transfer to Capital Project Funds (477,500) (789,705) (123,030) 16% (789,705) Increase City's Rate Stabilization Re serve (500,000) Available Fund Balance $ (134,71 3 ) $ 1,11 7,414 '$ 2,8 2 3,8 39 s (8 37,586) lnterfund Loans to the Water Fund (3,639,858) (3,639,858) (3,639,858) (3,639,858)' Total Deficit $ (3,774,571) $ (2,522,444) s (816,019) $ (4,477,444) (1) Includes carry:>ver amounts from Fiscal Year 2016-17 and City Council approved adjustments through December 5, 2017. (Zl This column reflects the impact of proposed first quarter adjustments. Sewer Enterprise Operating Fund (Fund 70) Revenues in the Sewer Operations Fund are on track at 21% of the amended budget and expenses are lower than expected at 18% of the amended budget. For Fiscal Year 2017-18, $500,000 of the Sewer Operations Fund's available fund balance will be used City Council Agenda Report January 16, 2018 Page 8 of 13 to fund capital projects. The South Orange County Wastewater Authority (SOCWA) adopted its Fiscal Year 2017-18 Budget after the City's Fiscal Year 2017-18 Budget Update was approved in June. As a result, the proposed expenditure adjustments include a reduction of the City's share of SOCWA's operating and maintenance costs by $559,000 to agree with SOCWA's budget. In addition, staff is proposing an additional $3,000 reduction in expenses due to a reallocation of Utilities Department staff time to reflect actual uses of such staff during the first quarter. As a result, sewer system operations for Fiscal Year 2017-18 are expected to result in an ending available fund balance of $3.0 million (1 02% of the Sewer Fund's Fiscal Year 2017-18 operating expenses). As provided by the City's 2014 Water and Sewer Rate Study, the Sewer Enterprise Operations Fund's available fund balance is being used to mitigate sewer rate increases until Fiscal Year 2018-19. Sewer Operations Fund Summary Actual Budget Amended 111 Through Percent Rev1sed 121 Update Budget September Realized Projections Description 2017/18 2017/18 2017 2017/18 2017/18 Available Fund Balance, July 1 $ 3,279,632 $ 2,180,879 $ 2,180,879 $2,180,879 Revenues Sewer Service Charges $ 3,408,610 $ 3,408,610 $ 882,766 26% $3,408 ,610 ln~Aestment Interest 15,000 15,000 5,844 39% 15,000 Other Interest 50,500 50,500 3,578 7% 50,500 Loan Repayment from Water Operations Fund 715,000 715,000 0% 715,000 REVENUE TOTAL $ 4,189,110 $ 4,189,110 $ 892,188 21% $4,189,110 Expenses Maintenance & Operations $ 3,209,546 $ 3,219,546 $ 576,424 18% $2,657,546 General & Administrati~Ae 243,505 243,505 60,876 25% 243,505 EXPENSE TOTAL $ 3,453,051 $ 3,463,051 $ 637,300 18% $2,901,051 Re~Aenues O~Aer/(Under) Expenses -before capital 736,059 726,059 254,888 1,288,059 Transfer Out-Capital Replacement Fund (500 ,000) (500,000) (125,000) 25% (500,000) Revenues Over/(Under) Expenses-after capital 236,059 226,059 129,888 788,059 Available Fund Balance, End of Period $ 3,515,691 $ 2,406,938 $ 2,310,767 $2,968,938 Available fund balance as% of operating expenses, excluding capital outlay 102% 1111ncludes carr~ver amounts from Fiscal Year 2016-17 and City Council approved adjustments through December 5, 2017 . 121 This column reflects the impact of proposed first quarter adjustments. Capital Improvement Program The amended Capital Improvement Program budget includes $16.4 million of carry-over funding for uncompleted projects from prior years and $7.3 million of new funding reflected in the Fiscal Year 2017-18 Budget Update, for a total Fiscal Year 2017-18 amended budget of $23.7 million. As of September 30, 2017, capital project expenditures totaled $1.1 million (5% of the amended budget) and an additional $3.3 million (13% of the amended budget) is under contract (encumbered) for work currently underway, for a total amount spent or encumbered to date of $4.4 million (18% of the amended budget as of September 30, 2017). Proposed capital project budget adjustments reflected in the attached projections include: City Council Agenda Report January 16, 2018 Page 9 of 13 • Close the Fiscal Year 2016-17 Annual Sewer Replacement Program budget (CIP 17701) and transfer the funds to the Fiscal Year 2017-18 Annual Sewer Replacement Program's budget (CIP 18701 ); • Increase the budget for the Del Obispo Widening Project (CIP 16102) by $45,000 to reflect the additional work that will be reimbursed by San Diego Gas & Electric; and • Reallocate funding for the Well Equipment Replacement Program (CIP 17807) from the Non-potable Capital Improvement Fund to the Water Capital Replacement Fund to reflect a change as to which wells require replacement. After taking into account proposed third quarter adjustments and adjustments for completed projects, the ending fund balance of the Capital Improvement Project Funds is projected below: Capital Improvement Projects Revised Fund Budgets-FY 2017-2018 Operating Expenses & Ending Beginning Revised Transfers Capital Fund Revised Project from (to) Reserve Balance Revenues Funding Other Funds (Projected) Description 07/01/17 FY 2017118 FY 2017118 FY 2017118 06/30/18 General Fund* n/a n/a $ (169,895) n/a Systems Development Fund 964 ,211 662,000 (903,490) (5,000) 717,721 Park and Recreation Fund 1,535,290 91,000 (1 ,543,075) 83 ,215 Open Space Fund 1,409,000 10,000 (1 ,408,585) 10,415 Drainage Fund (317,558) 31 ,320 (42,555) (328,793) Agricultural Preservation Fees Fund 880,066 80,000 (848,830) 111,236 Gas Tax Fund 743,350 807,000 (1,206,350) (344 ,000) CCFP Fund 8,196,635 1 '125,000 (2,463, 71 0) (55,985) 6,801,940 Eastern Open Space Fund 92,300 (92,300) RMRA Fund 208,000 (208,000) Measure M Fund 704,777 641 ,000 (1,782,097) (436,320) AQMD Fund 142,580 (142,580) Successor Agency Non-Housing Bond Funds 1,963,336 (1,908,695) 54,641 Community Facilities District Bond Funds 1,760,006 (1 ,218,685) 541,321 Water Operations Funds n/a n/a (312,205) (312,205) Water CIP Funds 3,804,787 930,000 (2,846, 755) (22 ,000) 1,866,032 Non-Potable Water CIP Fund 99,309 40,000 (810,350) 499 ,500 (171,541) Facilities Operations 311,080 (311 ,080) Sewer Funds 4,275,699 1,955,500 (4,206,635) 500,000 2,524,564 Grant Funds (252,046) 1,601,846 (1,280,800) (69,000) TOTALS $ 25,766,862 $ 8,728,626 $ (23,706,672) $ 503,515 $ 11,462,226 *General Fund projects are funded by annual appropriations rather than by means of designated reserves . City Council Agenda Report January 16, 2018 Page 10 of 13 Increase in the Rate Stabilization Reserve of the Water Operations Funds On December 5, 2017 the City Council approved the issuance of refunding debt to refinance the Water Fund's 2009 Revenue Certificates of Participation. The debt agreement for this refinancing expanded the uses permitted for the Rate Stabilization Reserve of the Water Operations Funds. The revised agreement allows the City to add funds to this reserve in those years when revenues of the Water Operations Funds exceed the expenses of the Water Operations Funds. Any such money added to the reserve can be used to pay the operating expenses of the Water Operations Funds in any future year in which the Water Operations Funds might otherwise fail to meet the debt covenants of the City. The revised debt agreement explicitly states that any expenses paid with Rate Stabilization Reserve funds are not counted in determining compliance with the debt coverage covenants of the Water Operations Funds for that year. Accordingly, use of the reserve can reduce the risk that the City would otherwise violate its debt covenants in a future fiscal year. In view of the projected excess of $1.5 million of Water Operations Funds' revenues over expenses for Fiscal Year 2017-18, staff recommends that $500,000 be added to the Rate Stabilization Reserve. The added funds will increase the reserve balance from $1.3 million to $1.8 million. Such funds can be accessed at any time to pay for the expenses of the Water Operations Funds upon the approval of City Council. Funding Assistance Agreement with Rancho Mission Viejo LLC In January 2016, the City Council approved cancellation of the Ortega Highway Widening from East City Limits to Calle Entradero Project (CIP 141 07). This cancellation resulted in the City returning Measure M grant funds, including interest, to the Orange County Transportation Authority. Prior to project cancellation, Rancho Mission Viejo, LLC (RMV) had contributed $55,985.50 toward project design costs under a Funding Assistance Agreement (Attachment 9). RMV is requesting reimbursement from the City for these costs incurred by RMV prior to cancellation of the project. If such reimbursement is approved, the funds reimbursed to RMV would be remitted by RMV to the County as a credit against RMV's commitment to provide replacement funding toward future project design costs. Staff is seeking City Council approval to authorize the City Manager to execute the attached letter agreement (Attachment 1 0) and to remit reimbursement to RMV in the amount of $55,985.50. This payment will be made from the Capistrano Circulation Fee Program Fund. FISCAL IMPACT: As a result of analysis of the City's financial activity to date, staff is recommending that the City Council approve the list of proposed budget amendments identified in Attachment 5. Some of the more notable proposed adjustments include: • A $73,488 proposed appropriation from fund balance (reserves) of the General Fund primarily for certain uncontrollable expenditures (business license costs resulting from a change in State law and the costs of an appealed business license application) and personnel budget changes; City Council Agenda Report January 16, 2018 Page 11 of 13 • A proposed appropriation from fund balance (reserves) of the CDBG/Home Fund for $183,000 due to increased program activity in Fiscal Year 2017-18; • An increase of capital project funding in the Gas Tax Fund of $4,600 for the Capistrano Villas I, II, and Ill Pavement Rehabilitation Project (CIP 18101) as a result of lower than expected Fiscal Year 2016-17 Measure M Turnback revenues; • A decrease of $4,600 in capital project funding in the Measure M Fund due to lower than expected Fiscal Year 2016-17 Measure M sales tax revenue; • An increase in budgeted revenues in the amount of $303,000 for the Capistrano Circulation Fee Program Fund (CCFP) for actual developer contributions received that had not been anticipated in the original budget for this fund; • A proposed appropriation of $182,000 in the Eastern Open Space Operations Fund for costs associated with the Coastkeepers litigation, which is offset by $265,550 in reimbursement from the City's insurance carrier for Fiscal Years 2016-17 and 2017-18; • An appropriation to transfer $1 ,512 from the Local Law Enforcement Grants Fund to the General Fund based on additional revenues received for Fiscal Year 2016- 17; • An increase of revenues in the Park and Open Space Grants Fund of $109,785 to reflect reimbursement for costs incurred in the previous fiscal year; • An increase of revenues in the Streets and Highways Grants Fund of $104,113 to reflect reimbursement for costs incurred in the previous fiscal year; • An increase of revenues in the Other Grants Fund of $38,148 to reflect reimbursement for costs incurred in the previous fiscal year; • An increase of appropriations by $1,129,000 in the Water Operations Fund primarily due to increased imported water costs due to a reduction of GWRP plant production; • An increase in the Rate Stabilization Reserve of the Water Operations Funds by $500,000; • An increase of appropriations by $164,000 in the GWRP Operations Fund primarily due to the planned purchase of Train B membranes for the GWRP plant; • Increase capital project funding in the Water Capital Replacement Fund by $43,535 primarily due to a reallocation of funding for the Well Facility Equipment Replacement Program (CIP 17807); City Council Agenda Report January 16, 2018 Page 12 of 13 • Reduce appropriations in the Non-Potable Water Operations Fund by $106,000 primarily due to reduced imported recycled water costs resulting from increased production from the City's non-potable water wells; • Reduce appropriations in the Sewer Operations Fund primarily due to a reduction in the City's share of Fiscal Year 2017-18 operating and maintenance contributions to SOCWA; and • An increase of $2,000 in the budgeted expenditures of the Housing Authority Administration Fund to adjust for the actual amount of legal expenses paid through November. ENVIRONMENTAL IMPACT: Not applicable. PRIOR CITY COUNCIL REVIEW: • On June 21, 2016, the City Council approved the Fiscal Year 2016-17 and 2017- 18 Operating and Capital Improvement Budget. • On June 20, 2017, the City Council approved adjustments to the Fiscal Year 2017-18 Operating and Capital Improvement Budget. COMMISSION/COMMITTEE/BOARD REVIEW AND RECOMMENDATIONS : Not applicable . NOTIFICATION: Jeff Thompson, Rancho Mission Viejo, LLC ATTACHMENTS : Attachment 1 -Reserve Balances by Fund Attachment 2 -Revenue and Transfers In by Fund -Budget to Actual Attachment 3 -Operating Expenditures and Transfers Out by Fund and Activity-Budget to Actual Attachment 4-CIP Expenditure Summary by Project Category and Fund Source Attachment 5 -Proposed Budget Adjustments Attachment 6 -Revenue Adjustment Summary Attachment 7 -Expenditure Adjustment Summary Attachment 8 -Administrative Budget Transfers -July 1, 2017 through September 30, 2017 Attachment 9 -Funding Assistance Agreement with Rancho Mission Viejo, LLC City Council Agenda Report January 16, 2018 Page 13 of 13 Attachment 1 0 -Letter Agreement with Rancho Mission Viejo, LLC Regarding Reimbursement GENERAL FUNDS General Fund Unassigned $ Assigned-Continuing Appropriations 12l Reserve-Tuition Reimbursement Program Reserve -Cash Flow Reserve-Economic Uncertainty Reserve -Contingency Non-Spendable-Prepaids Non-Spendable-Loans to CRA Total General Fund Parking Maintenance Fund Assigned-Parking Maintenance Successor Agen9£ to the CRA[Housing Author~ Administration Fund Unassigned Assigned-Continuing Appropriations 12l Total SACRA/Housing Authority Administration Fund Farm Operations Fund Assigned-Farm Operations ~ Eastern Open Space Fund Assigned-Eastern Open Space Operations -1 Assigned-Continuing Appropriations (2) }> Non-Spendable-Prepaids () Total Eastern Open Space Fund I s:: ------s GENERAlFUNDS·TOTAl m z Special Revenue Funds -1 ...... C&D Forfeited Bonds Fund I Restricted-Recycling Programs $ "lJ Q) (.Q Road Maintenance and Rehabilitation Account (RMRAI (I) Restricted-Streets and Roads Capital Projects ...... 0 Sl!stems Development[Ord. 211 Fund -Q) Restricted-Streets and Roads Capital Projects Park and Recreation Fund Restricted-Parks and Recreation Capital Projects CllY OF SAN JUAN CAP ISTRANO FY 2017/18 RESERVE BALANCES BY FUND JULY 1, 2017 THROUGH JUNE 30, 2018 Actual Bqlnnr"c Opera IIIli B•lance Revenues Elcpen'dl llm•s 7/1/2.017 11) FY2018 FY 2Dl8 2,889,244 $ 26,066,S20 $ (26,340,101) $ 1,043,89S (874,000) 3S,OOO s.ooo,ooo 7,SOO ,OOO 1.000,000 26,082 (26,082) 16S,809 - 17,660,030 26,066,520 (27,240,183) 193,523 63,800 (139,055) 199,18S 281,960 (281,960) 1,000 (1,000) 200,185 281,960 (282,960) 389,958 115,300 (29,595) 325,114 490,550 (511,515) 121,700 (29,400) 3,000 (3,000) 449,814 490,550 (543,915) 18,893,510 $ 27,018,130 $ (28,235,708) $ 818,579 $ $ (14,280) $ 208,000 964,211 662,000 1,535,290 91,000 Projected CIP Trans fen; Transfen; End ing Cont. Elcpenclltures In out Bala11ce Res. FY 2.018 FY2D18 FY2018 Adlunm_ents _6/30/2018 " $ S70,S12 $ (307,980) $ $ 2,878,19S (169,89S) 3S,OOO s,ooo,ooo 7,500,000 1,000,000 16S,809 570,512 (477,875) -16,579,004 118,268 199,185 . 199,185 475,663 304,149 (92,300) (92,300) 304,149 (92,300) $ 5 70,512 $ (477,875) $ $ 17,676,269 $ $ $ $ 804,299 (208,000) (903,490) (5,000) 717,721 (1,543,075) 83,215 Drainage Fund Restricted-Storm Drain Capital Projects Agricultural Preservation Fund Restricted-Agricultural Preservation Projects Landscape Maintenance Fund Restricted-Landscape Maintenance CDBG/HOME Fund Restricted-Housing Rehabilitation for low and Moderate Income Housing Persons Gas Tax Fund Restricted-Street Rehabilitation and Maintenance CCFP Fund Developer Contributions for Specific Projects Restricted-Streets and Roads Capital Projects Total CCFP Fund S.O.N.G.S. Fund Restricted-Emergency Preparedness AQMDFund Restricted-Mobile Source Emissions Reduction Programs Measure M Fund ~ Restricted-Streets and Roads Capital Projects 1'1 ~ Housing In-Lieu Fee Fund )> Restricted-Affordable Housing () I Non-Spendable-LT Receivable s:: Total Housing In-Lieu Fund m Local Law Enforcement Grants Fund z ~ Restricted-Law Enforcement ..... Park and Open Space Grant Fund I -a Restricted-Capital Projects Q) Street and Highways Grant Fund co Cl> Restricted-Capital Projects 1\.) 0 Other Grants Fund -Restricted-Capital Projects ()) ---. SPECIAL REVENUE FUNDS· TOTAl s CITY OF SAN JUAN CAPISTRANO FY 2017/18 RESERVE BALANCES BY FUND JULY 1, 2017 THROUGH JUNE 30,2018 Actual Beglnnii'I-J Openutn1 B11lance Revenu,e t Ellp~n'dlture$ 7/1/2017 ttl FY2018 FY ,Z018 (317,5S8) 31,320 880,066 80,000 285,260 216,158 (1n,610I 549,263 168,695 (327,730) 743,350 807,000 458,000 303,000 8,196,635 1,125,000 (55,985) 8.654,635 1,428,000 (55,985) 208,665 (208,665) 409,522 48,000 704,777 641,000 4,337,231 670,000 950,000 5,287,231 670,000 1,512 100,000 (109,785) 571,no (104,113) 915,878 (38,148) 114,198 20,264,~2 $ 6.961,684 $ (784,270) $ Projected CIP Transf~!S Transfers Endlnc C1ont. Ellpendltures In Out Bnlancl! Res; FY 2018 FY 2018 FY'2018 Adju1tments 6/30/lOlB " (42,555) (328,793) (848,830) 111,236 323,808 390,228 (1,206,350) (344,000) 761,000 (2,463,710) 6,801,940 (2,463,710) 7,562,940 (142,580) (51,000) 263,942 (1,782,097) (436,320) 5,007,231 950,000 . 5,957,231 . (101,512) (461,985) (742,765) (69,000) (76,050) (10,421,487) s' $ (570,5121 $ s 15,449,507 Debt Service Fund De bt Se rvic e Ful'l!l ----· $ RMfr lctcd'Deb t Scrvke ------- Capital Improvement Funds General Proiect Fund Assigned-Capital Projects $ Oeen Seace Bond Projects Fund Restricted-Open Space Capital Projects Commun!!J! Facilities District Bonds Fund Restricted-Community Facilities Projects Successor Agen!;J! Non-Housing Bonds Fund Restricted -Downtown Projects CAP ITAL PROJECTs FU NDS· TOTAL ----- $ -· -GENERAL GOVERNMENTAL FUNDs-· TOTAl $ ENTERPRISE FUNDS Water Entererise Funds Water Oeeratlons Fund ~ Unrestricted Net Assets-Contingency $ ---l Unrestricted Net Assets-Cont. Appropriations 121 )> Unrestricted Net Assets-Drought Penalty Reserve () Unrestricted Net Assets-Rate Stabilization Reserve :I: :s: Unrestricted Net Assets-Loan Due to Sewer Funds m Unrestricted Net Assets-Pension & OPES Liabilities 1'1 z Investment in capital Assets ---l ...... Total Water Operations Fund I Water Debt Service Fund "U Unrestricted Net Assets-Available Q) (Q Unrestricted Net Assets-2014A Water Refunding Bonds CD (J,) Total Water Debt Service Fund 0 -m CITY OF SAN JUAN CAPISTRANO FY 2017/18 RESERVE BALANCES BY FUND JULY 1, 2017 THROUGH JUNE 30, 2018 Actual B~glnnl ng~ Operallng Balance Revenues E.xpend ltul\l!s 7/1/2017 111 FY20l8 FY2018 2.,701>,116 s 2,451,717 $ (2,588,715) $ . $ $ $ 1,409,000 10,000 1,760,006 1,963,336 5,1 32,342 $ 10,000 $ s 46_996,060 $ 36,44l,S:U 5 (31,608,693! $ 3,763,875 $ 12,290,900 $ (12,541,525) $ 476,490 (336,000) 874,366 (146,000) 1,296,425 (3,639,858) (6,431,821) 58,470,404 54,809,881 12,290,900 (13,023,525) 62,856 1,072,S60 (4,395,920) (17,97 5.910) (17,913,054) 1,072,560 (4,395,920) ProJected Cfp Transfers Tra nsfers End irtg Col'll . Expenditure~ In Out Balance Res. FY 2018 FY 2018 FY2018 #Ju:Stments 6/3~-"~ $ 307,980 $ $ . $ 2.877,098 (169,89S) $ 169,89S $ $ $ (1,408,585) 10,415 (1,218,685) 541,321 (1,908,695) 54,641 (4, 705J860) $ 169,895 $ s s 606,3n [15,219,647 ) $ 1,048,387 s (1,048,387! 5 $ 36,609,251 $ 488,270 $ (1,416,645) $ [500,000) $ 2,084,875 14% (140,490) 728,366 500,000 1,796,425 (3,639,858) (6,431,821) 58,470,404 (140,490) 488,270 (1 ,416,645) 53,008,391 3,323,360 62,856 (17 .975,910) 3,323,360 (17,913,054) GWRP Operations Fund Unrestricted Net Assets-Available Unrestricted Net Assets-Cont. Appropriations 121 Unrestricted Net Assets-Pension & OPEB Liabilities lSI Investment in Capital Assets Total GWRP Operations Fund Non-Potable Water Dl!erations Fund Unrestricted Net Assets-Available Unrestricted Net Assets-Pension & OPEB Liabilities lSI Total Non-Potable Water Operations Fund Water Cal!ital Rel!lacement Fund Unrestricted Net Assets-Available Water Cal!itallml!rovement Fund Unrestricted Net Assets-Available Non-Potable Water Capital Improvement Fund Unrestricted Net Assets-Available SJC Public Financing Authorit~ Unrestric ted Net Assets-Available Restricted Cash-2009 COPs Unrestricted Net Assets-2009 COPs ~ Total SJC Public Financing Authority . ----l WATER ENTERPRISE FUNDS· TOTAL )> -- 0 Sewer Enter11rise Funds I s: Sewer Enter11rise Dl!erations Fund m Unrestricted Net Assets-Contingency z -l Unrestricted Net Assets-Available ....>. Unrestricted Net Assets-Loan to Water Operations Fund Unrestricted Net Assets-Pension & OPEB Liabilities 151 IJ Investment in Capital Assets ru c.o Total Sewer Operations Fund CD ~ Sewer Ca,2ital Reelacement Fund 0 Unrestricted Net Assets-Available -(J) CITY OF SAN JUAN CAP ISTRANO FY 2017/18 RESERVE BALANCES BY FUND JULY 1, 2017 THROUGH JUNE 30, 2018 Actual Beclnnlnc Opera tine Balan~ Revenues Exp_endil.ure.s 7/1/1017111 FY201S FY 2018 (6,457,236) 7 ,231,000 (2,255,710) 171,715 (713,548) 1,533,361 (5,465,708) 7,231,000 (2,255, 710) 50,977 1,031,250 (441,479) (311,009) (260,032) 1,031,250 (441,479) 2,247,272 8,000 1,557,515 922,000 99,309 40,000 . (39,970) 795,445 (795,445) 804,469 (9.158,888) (8,394,389) 795,445 (795,445) CIP Elcpendltures FY2018 (171 ,715) (171,715) - (1,838,425) (1,008,330) (810,350) ~ 26,680,794 _$~,391 ,155 $_ (20,912,079) $ -(3 ,969,310) $ $ 2,180,879 $ 4,189,110 $ (2,901,051) $ $ 1,819,929 (372,379) 19,385.062 Z3,013,491 4,189,110 (Z,901,051) 1,719,506 Z3,000 (1,935,970) Projected Transfe~ Transfe~ Ending Cont. In Out Balance Res. FY 2018 FY2018 Adjustments 6/30/2018 " - (2,394,985) -(3,876,931) (713,548) 1,533,361 (1,394,985) (3,057,118) (477,500) 163,248 (311,009) (477,500) -(147,761) (22,000) 394,847 1,471,185 499,500 (171,541) -(39 ,970) 804,469 (9,158,888) (8,39 4,389) 4;311,13Q__$~ (4,3U,130J $ $ 25,190,560 $ (500,000) $ (1,518,412) $ 1,450,526 50" A> 1,518,412 1,518,412 . 1,819,929 (372,379) 19,385 ,062 (500,000) Z3,801,550 500,000 . 306,536 -------- Sewer Ca11itallm11rovement Fund Unrestricted Net Assets-Available Unrestricted Net Assets-Loan to Water Operations Fund Unrestricted Net Assets-Loans to CRA Total Sewer Capital Improvement Fund ----SEWER ENTERPRISE FUNDS· TOTAL $ SJC HOUSING AUTHORITY Housing Authorit~ Administration Fund Unrestricted Net Assets-Contingency Reserve $ Unrestricted Net Assets-Available Non-Spendable -Noncurrent Receivables Investment in Capital Assets Total Housing Authority Administration Fund Little Holl~wood Rental Housing Fund Unrestricted Net Assets-Contingency Reserve Unrestricted Net Assets-Available Total little Hollywood Rental Housing Fund Successor Agenc:t Housing Bonds Fund Restricted Net Assets-Affordable Housing Projects ~ SJC HOUSING AUTHORITY· TOTAL $ ------------~ -1 ENTERPRISE FUNDS ·TOTAL $ -1 ~ () I INTERNAL SERVICE FUNDS s:: Insurance and Benefits Fund m Unrestricted Net Assets-Available $ z -1 Facilities O~erations Fund ....... Unrestricted Net Assets-Available 1'1 "'U Unrestricted Net Assets-Cont. Appropriations 1'1 ru Unrestricted Net Assets-Pension & OPEB liabilities 151 c.o ([) Investment in Capital Assets (J'1 Total Facilities Operations Fund 0 INTERNAL SERVICE FUNDS-TOTAL ---.--- $ --(J) ---All FUNDS· TOTAL $ CITY OF SAN JUAN CAPISTRANO FY 2017/18 RESERVE BALANCES BY FUND JULY 1, 2017 THROUGH JUNE 30, 2018 Ac1u;tl Seglnnlnc Opera line B~t.nce Revenu<!s E ~rpt~~~ltunis 7/1/2017 111 FY 2018 FY 2018 2,556,193 1,932,500 1,819,929 958,514 . 5,334,636 1,932,500 30,067,633 $ 6).44,6l.O $ (2.901.051) $ 46,980 s 162,600 $ (64,425) $ 970,759 5,067,012 4,604,439 . 10,689,190 162,600 (64,425) 89,645 195,500 (191,280) 496,766 586,411 195,500 (191,280) 6,728,053 25,000 (1 ,000,000) 18,003,654 $ 383,100 $ (1 <25.5,705) $ 74,'1'52,081 $ 29,918,865 $ (25,068,835) $ 352,588 $ 6,834,965 $ (6,834,965) $ 2,411,260 1,919,425 (2 ,805,670) 327,080 (168,000) (625,823) 3,008,196 5,120,713 1,919,425 (2,973,670) 5,473,301 $ 8,754,390 $ (9,808,635) $ 127,221,442 $ 75,U4,786 $ (66,486,163) $ Projected CIP Transfers Transfers En dine Cont. Expendltur<!s '"' out Balance Res. FY 2018 FY 2018 FY 2018 _ Adjustments 6/30/2018 " (2,270,665) . 2,218 ,0 28 . 1,819,929 958,514 (2,270,665) . 4,996,471 (4,206,635) $ 500,000 $ (500,000) $ $ 29,104,557 $ $ s (112,942) $ 32,213 50% 112,942 1,083,701 5,067,012 4,604,439 10,787,365 1,775 95,640 SO% (1 ,775) 494,991 590,631 5,753,053 ----~---. $ s . $ $ 11,131,049 (B,175,945Lt_ 4,811.130 $ (4,811,130)_$ $ 7.1,~6,166 . $ $ $ $ 352,588 (152,000) 1,373,015 (159,080) (625,823) . 3,008,196 (311,080) . 3,755,388 --(311,080) $ $ -$ . $ 4,107,976 (23,706,612) $ 5,859.517 $ (5,859,517j $ . $ 112,143,393 ~ --i )> () I s:: m z --i -->. "U Ill cc (t) (j) 0 -(j) Notes: CITY OF SAN JUAN CAPISTRANO FY 2017/18 RESERVE BALANCES BY FUND JULY 1, 2017 THROUGH JUNE 30,2018 ActUal Beclnn11JC Operatlnc Balance Revenu.et ~hd11ures 7/l/2.017 111 FY 2018 FY 2018 111 Beginning fund balances are based on preliminary unaudited balances as of June 30, 2017. Projecte.d CIP Transf~rs Transfl!rs . Endlnc EJcpendlturet In Out Balanee FY·2018 FY 2018 FY2018 . Adj1J5t.me.nts 6/30/2.018 121 Amounts reported as "Continuing Appropriations" at July 1, 2017 include the carryovers from the Fiscal Year 2016-2017 Operating and Capital Improvement Program into the Fiscal Year 2017-2018 Amended Budget. 131 On December 5, 2017, the City Council appropriated additional funds for the Capistrano Villas I, II, and Ill Pavement Rehabilitation Project (CIP 18101), which resulted in a deficit in the Measure M Fund. This deficit is being funded from a short-term loan from the Capistrano Circulation Fee Program (CCFP) Fund. The Measure M Fund will repay the CCFP Fund with Fiscal Year 2018-19 Measure M Turnback revenues. 141 Available reserves for capital replacement. 151 The City is required by the Governmental Accounting Standards Board (GASB) to report the unfunded actuarial liability (UAAL) for its pension plans (GASB Statement No. 68) and other-post employment benefits (GASB Statement No. 75). The City's General Fund (and other governmental funds) do not reflect such an amount in this schedule because this accounting and reporting standard is only applicable to the City's Enterprise and Internal Service Funds. The City's governmental funds' (i.e. General Fund, capital Projects Funds, and Special Revenue Funds) portion of the City's total UUAL as of December 31, 2016 (date of actuarial valuation) was approximately $18.1 million for the City's pension plans and was approximately $2.1 million for the other post employment benefit plan as of July 1, 2016 (date of the actuarial valuation). Cont. Re~. " - ~ --i )> () I s: m z --i N "'U Q) co CD _.. 0 ....... (X) Bud set Update Description 2.017/lJ GENERAL FUNDS General Fund Property Tax $ 6,742,:100 In-Lieu Vehicle License Fees 3,381,:100 TOTAL 10,123,000 Sales Taxes Sales Tax 8,308,000 TOTAL 8,308,000 Other Taxes Real Property Transfer Tax 296,000 Business License Taxes 217,000 Transient Occupancy Tax-10% 894,000 Franchise Fees 1,327,000 TOTAL 2,734,000 Intergovernmental Landfill Mitigation Contribution 680,000 Vehicle License Fees (VLF) 14,000 Grants 44,000 TOTAL 738,000 Licenses, Fees and Permits Planning Permits 80,000 Engineering Permits 303,000 Building and Grading Permits 954,000 Other Fees and Permits 295,000 Community Service Program Fees 223,000 Neighborhood Parking Permits 11,000 Weed Abatement 7,000 TOTAL 1,873,000 Current Services Charges to Successor Agency 19,000 Charges to Other Funds 169,000 Charges to Utility Enterprise Funds 358,000 Developer Deposit Charges 115,000 CIP Administration Charges 126,000 TOTAL 787,000 (1) -Includes adjustments approved by City Council through December 5, 2017 CITY OF SAN JUAN CAPISTRANO FY 2017/18 REVENUE & TRANSFERS IN BY FUND JULY 1, 2017 THROUGH SEPTEMBER 30,2017 Amended Percent Bud set .VTD Attual Reali red 2.017/18(1) 2.017/18 2017/18 $ 6,742,000 $ 167,744 2% 3,381,000 -0% 10,123,000 167,744 2% 8,308,000 548,867 7% 8,308,000 548,867 7% 296,000 61,094 21% 217,000 13,642 6% 894,000 -0% 1,327,000 62,552 5% 2,734,000 137,288 5% 680,000 -0% 14,000 -0% 44,000 7,244 16% 738,000 7,244 1% 80,000 18,210 23% 303,000 84,296 28% 954,000 230,920 24% 295,000 111,048 38% 223,000 77,289 35% 11,000 5,252 48% 7,000 -0% 1,873,000 527,015 28% 19,000 3,445 18% 169,000 38,753 23% 358,000 73,317 20% 115,000 15,575 14% 126,000 12,825 10% 787,000 143,915 18% ~evlsed Proposed Prtor Year Increase or ProJedlon Increase rto Ac:tu.al Decrease 2017/18 (Decrease) 2.016/17 From P/Y $ 6,742,000 $ -$ 160,072 5% 3,381,000 --•• 10,123,000 -160,072 5% 8,308,000 --** 8,308,000 --** 296,000 -57,077 7% 217,000 -13,424 2% 894,000 --** 1,327,000 -336,018 -81% 2,734,000 -406,519 -66% 680,000 -66,420 -100% 14,000 --** 44,000 -11,501 -37% 738,000 -77,921 -91% 80,000 -18,393 -1% 303,000 -61,265 38% 954,000 -269,946 -14% 295,000 -192,778 -42% 223,000 -65,591 18% 11,000 -3,798 38% 7,000 -** 1,873,000 -611,771 -14% 19,000 2,209 56% 169,000 40,422 -4% 358,000 71.491 3% 115,000 -11,901 31% 126,000 -15,898 -19% 787,000 -141,921 1% ~ --i )> () I s: m z --i N -u Q.l (Q CD N 0 -CD Bud1et Update Deltrlptlon 2.017/18 Interest and Rentals Community Facility Rental 191,000 Park Rental 18,000 Athletic Field Rental 88,000 Commercial Property Rental 111,000 Investment Interest 60,000 TOTAL 468,000 Fines and Forfeitures Parking Fines 529,000 Vehicle Code Fines 160,000 Public Safety (sales tax) 273,000 Other Fines & Forfeitures 5,000 TOTAL 967,000 Other Revenue Escheated Deposits Other Reimbursements 30,000 Mandated Cost Reimbursement 30,000 Damage To City Property - Miscellaneous Revenue 16,000 TOTAL 76,000 Transfers In Gas Tax Fund 344,000 AQMD Fund 11,000 Local Law Enforcement Grants Fund 100,000 Systems Development Fund - Street and Highways Grants Fund TOTAL 455,000 Total General Fund 26,529,000 Other General Funds Parking Maintenance Fund Parking Meter Fees & Permits 63,800 Transfers In-General Fund - TOTAL 63,800 (1)-Includes adjustments apprcved by City Council thrcugh December 5 , 2017 CITY OF SAN JUAN CAPISTRANO FY 2017/18 REVENUE & TRANSFERS IN BY FUND JULY 1, 2017 THROUGH SEPTEMBER 30,2017 Amended Percent Bud set . 'rTD AetLla I Realized 2017/18(1) 2017/18 2017/-1& 191,000 35,827 19% 18,000 11,124 62% 88,000 14,887 17% 111,000 14,793 13% 60,000 41,472 69% 468,000 118,103 25% 529,000 72,635 14% 160,000 21,941 14% 273,000 23,776 9% 5,000 304 6% 967,000 118,656 12% 2,520 -0% 30,000 3,040 10% 30,000 0% -300 •• 16,000 1,407 9% 78,520 4,747 6% 344,000 86 ,000 25% 51,000 1,206 2% 100,000 56,305 56% 5,000 -0% 69,000 -0% 569,000 143,511 25% 26,645,520 1,917,090 7% 63,800 18,889 30% --0% 63,800 18,889 30% Revised Proposed Prlori'ear l!ltrease or Projection Increase YTOActual Decrease 2017/18 (Decrease) 2016/17 From P/Y 191,000 55,325 -35% 18,000 -9,250 20% 88,000 -18,386 -19% 101,000 (10,000) 13,143 13% 60,000 -(3 ,561) -1265% 458,000 (10,000) 92,543 28% 529,000 -102,917 -29% 160,000 -28,727 -24% 273,000 -43,199 -45% 5,000 -235 29% 967,000 -175,078 -32% 2,520 -•• 30,000 -2,154 41% 30,000 --•• -1,201 -75% 16,000 -683 106% 78,520 -4,038 18% 344,000 -117,250 -27% 51,000 -1,705 -29% 101,512 1,512 43,714 29% 5,000 --•• 69,000 --•• 570,512 1,512 162,669 -12% 26,637,032 (8,488) 1,832,532 5% 63,800 18,705 1% --19,176 -100% 63,800 -37,881 -50% ~ --l )> () I s:: m z --l N -u !l) <0 CD VJ 0 -a> llud11et Update Description 2017/111 SACRA[SJCHA Administration Fund Reimbursement from SACRA/SJCHA 281,960 Commercial Property Rental - Investment Interest - Miscellaneous Revenue - TOTAL 281,960 Farm Operations Fund Commercial Property Rental 113,300 Crop Revenue 2,000 Other Reimbursements - Total Farm Operations Fund 115,300 Eastern Open Space Fund Riding Park Rental 225,000 Other Commercial Property Rental - Insurance Reimbursement for Coastkeeper Litigation - Total Eastern Open Space Fund 225,000 GENERAL FUNDS-TOTAL $ 27 ,215,0 60 SPECIAL REVENUE FUNDS C&D Forfeited Bonds Fund Forfeited C&D Bonds $ . Road Maintenance and Rehabilitation Account !RMRAl SB-1 Funding . Systems Development Fund System Development Tax 639,000 Development Fees 20,000 Investment Interest 3,000 Total Systems Development Fund 662,000 Park and Recreation Fees Park/Recreation Fees 84,000 Investment Interest 7,000 Miscellaneous Revenue - Total Park and Recreation Fees 91,000 (1)-Includes adjustments approved by City Council through December 5, 2017 CITY OF SAN JUAN CAPISTRANO FY 2017/18 REVENUE & TRANSFERS IN BY FUND JULY 1, 2017 THROUGH SEPTEMBER 30,2017 Amended Percent Budget YTDActual Realized 2017/18(:1) 2017/18 2017/18 281,960 60,061 21% -26,000 •• -562 •• --0% 281,960 86,623 31 % 113,300 21,358 19% 2,000 -0% . 0% 115,300 21,358 19% 225,000 -0% --0% --0% 225,000 -0% $ 27,331,580 $ 2,043,960 7% $ $ . 0% 208,000 . 0% 639,000 91,039 14% 20,000 1,337 7% 3,000 2,838 95% 662,000 95,214 14% 84,000 -0% 7,000 4,264 61% --0% 91,000 4,264 5% Revised Proposed Prior Year Increase or Projection Increase YTD Actual Decrease 2.017/18 (Decrease) 2016/17 From P/Y 281,960 -26,478 127% --19,500 33% --100% --150 -100% 281,960 . 46,128 88 % 113,300 -21,000 2% 2,000 -6,250 -100% --11,600 -100% 115,300 -38,850 -45% 225,000 -. •• . 1,450 -100% 265,550 265,550 -•• 490,550 265,550 1,450 ·100% $ 27,588,642 $ 257,062 $ 1,956,841 4% $ -$ -$ 23,690 -100% 208,000 --** 639,000 -54,590 67% 20,000 -685 95% 3,000 . (225) -1361% 662,000 . 55,050 73% 84,000 -•• 7,000 -(441) -1067% --7,881 -100% 91,000 . 7,440 -43% ~ --i )> () I ~ m z --i N "U Ql (Q CD .j::>. 0 -co . Budget Update Deserlptlon 2017/18 Drainage Fund Drainage Fees 11,000 Grants - Total Drainage Fund 11,000 Agricultural Preservation Fund Agricultural Preservation Fees 80,000 Investment Interest . Total Agricultural Preservation Fund 80,000 Landsca11e Maintenance Fund Current Assessments 216,158 CDBG/HOME Fund Program Income 167,495 Investment Interest 1,200 Total CDBG/HOME Fund 168,695 Gas Tax Fund Gas Tax Revenue 762,000 SB-1 Funding 208,000 Loan Repayment from State 41,000 Investment Interest 4,000 Total Gas Tax Fund 1,015,000 CCFP Fund Circulation Fees 1,044,000 Investment Interest 36,000 Other Reimbursements . Developer Contributions . Total CCFP Fund 1,080,000 S.O .N.G.S . Fund St ate S.O.N.G.5 Re i mbursement 193,600 AQMD Fund State AQMD/AB2765 Fees 45,000 Investment Interest 3,000 Total AQMD Fund 48,000 (1)-Includes adjustments approved by City Council through December 5, 2017 CITY OF SAN JUAN CAPISTRANO FY 2017/18 REVENUE & TRANSFERS IN BY FUND JUlY 1, 2017 THROUGH SEPTEMBER 30, 2017 Amended ,ercent Blldget YTOActual Realized 2017/18 (l} 2017/111 2017/18 11,000 . 0% 20.320 . 0% 31,320 -0% 80,000 13,000 16% . 2,438 •• 80,000 15,438 19% 216,158 2,229 1% 167,495 40,000 24% 1,200 1,431 119% 168,695 41,431 25% 762,000 69,158 9% . 0% 41,000 -0% 4,000 1,723 43% 807,000 70,881 9% 1,044,000 177,773 17% 36,000 25,901 72% . . 0% --0% 1,080,000 203,674 19% 208,665 207,876 100% 45,000 . 0% 3,000 1,125 38% 48,000 1,125 2% Revl~ed Proposed Prior Year Increase or ProJection lntre8$e YTDActual Decrease 2017/18 (Decrease) 2016/17 From P/Y 11,000 --•• 20,320 . 5,877 -100% 31,320 -5,877 -100% 80,000 . 5,000 160% . . {2 54) -1060% 80,000 . 4,746 225% 216,158 . 270 726% 167,495 . 40,000 0% 1,200 . (129) -1209% 168,695 . 39,871 4% 762,000 . 135,779 -49% •• - 41,000 . •• 4,000 . (357) -583% 807,000 . 135,422 -48% 1,044,000 . 81,257 119% 36,000 . (2,344) -1205% 45,000 45,000 81,257 -100% 303 ,000 303,000 -•• 1,428,000 348,000 160,170 27% 208,665 . 220,637 -6% 45,000 . -•• 3,000 . (110) -1123% 48,000 . (110) -1123% ::; -I )> () I s:: m z -I N "'U ru c.o CD (J1 0 -()) lludget Update Description 2017/18 Measure M Fund Local Turn back 638,000 Investment Interest 3,000 Total Measure M Fund 641,000 Housing In-lieu Fee Fund Housing In-Lieu Fees 660,000 Investment Interest 10,000 Total Housing In-lieu Fund 670,000 law Enforcement Grants Fund State Grant (COPS) 100,000 Park and OJ;!en SJ;!ace Grant Fund Grants . Street and Highwal£S Grant Fund Grants 598,775 Other Grants Fund Grants . SPECIAL REVENUE FUNDS· TOTAL $ S,575,228 DEBT SERVICE FUND Property Tax levy $ 2,446,812 Investment Interest 4,905 Bond Proceeds Transfers In-Gen e ral Fund 307,980 Total Debt Service Fund $ 2,759,697 CAPITAL IMPROVEMENT PROJECT (CIP) FUNDS Capital Projects Fund Tran sfe rs In-Genera l Fund $ Open SJ;!ace Projects Fund Investment Interest 10,000 Communitl£ Facilities District Bonds Fund Investment Interest . Other reimbursements . Total Community Facilities District Bonds Fund . (1) -Includes adjustments approved by City Council through DecemberS, 2017 CITY OF SAN JUAN CAPISTRANO FY 2017/18 REVENUE & TRANSFERS IN BY FUND JULY 1, 2017 THROUGH SEPTEMBER 30,2017 Amended Percent Budset vtDActual Reallted 2017/~8 (1) 2017/18 2017/18 638,000 98,669 15% 3,000 1,987 66% 641,000 100,656 16% 660,000 390,801 59% 10,000 12,525 125% 670,000 403,326 60% 100,000 54,793 55% 461,985 . 0% 811,765 . 0% 76,050 . 0% $ 6,361,638 $ 1,200,907 19% $ 2,446,812 $ 41,716 2% 4,905 2,406 49% --0% 307,980 291,171 95% $ 2,759,697 $ 335,293 12% $ 169,895 $ 169,895 100% 10,000 3,897 39% . 4,898 ** . . 0% . 4,898 ** Revised Proposed Prior Year Increase or Projection Increase YTDActuil Decrease 2017/18 (Decrease) 2016/17 From P/Y 638,000 97,871 1% 3,000 . (191) -1140% 641,000 . 97,680 3% 660,000 . 285,461 37% 10,000 . (893) -1503% 670,000 . 284,568 42% 100,000 . 43,576 26% 571,770 109,785 189,173 -100% 915,878 104,113 28,160 ·100% 114,198 38,148 1,645 -100% $ 6,961,684 $ 600,046 $ 1,505,86S -20% $ 2,446,812 $ . $ 40,566 3% 4,905 . (188) -1380% •• . -- 307,980 -288,721 1% $ 2,759,697 $ . $ 329,099 2% $ 169,89S $ . $ 12,5S9 1253% 10,000 . (433) ·1000% -. (155) -3260% . -850,000 -100% . . 849,845 -99% ~ -; )> () I s:: m z -; N ""0 Q) (Q CD 0) 0 -CXl Budget Update Description 2011/18 Successor Agenc)l Non-Housing Bonds Fund Investment Interest - CAPITAL IMPROVEMENT PROJECT FUNDS-TOTAL $ 10,000 GOVERNMENTAL FUNDS-TOTAL $ 35,5S9,985 ENTERPRISE FUNDS Water Operations Fund CITY OF SAN JUAN CAPISTRANO FY 2017/18 REVENUE & TRANSFERS IN BY FUND JULY 1, 2017 THROUGH SEPTEMBER 30, 2017 Amended Percent Bud set YTDActual Realized 2Q17/18 (1) 2017/18 2017/18 -5,464 ** $ 179,895 $ 184,154 102% $ 36,632,810 $ 3,764,314 10% Water Commodity Charges $ 6,906,000 $ 6,906,000 $ 3,719,015 54% Customer Services Charges 4,928,000 4,928,000 1,250,822 25% Administrative Citations (Drought Penalties) --(570) 0% Other Water Service Revenues 456,900 456,900 225,786 49% Transfers ln-GWRP Operations Fund 488,270 488,270 122,068 25% Total Water Operations Fund 12,779,170 12,779,170 5,317,121 42% Water Debt Service Fund Property Taxes-General 1,062,560 1,062,560 28,934 3% Investment Interest 10,000 10,000 5,518 55% Transfers ln-H20 Operations Fund 1,416,645 1,416,645 354,161 25% Transfers ln-GWRP Operations Fund 1,906,715 1,906,715 476,679 25% Total Water Debt Service Fund 4,395,920 4,395,920 865,292 20% GWRP Operations Fund MWD Grant@ $250/af 864,000 864,000 27,550 3% Water Commodity Charges 6,635,000 6,635 ,000 899 ,611 14% Total GWRP Operations Fund 7,499,000 7,499,000 927,161 12% Water Capital Replacement Fund Investment Interest 8,000 8,000 4,497 56% Developer Contribution for CIP 11805 ---0% Total Water Capital Replacement Fund 8,000 8,000 4,497 56% Water Capital Improvement Fund Capital Improvement Charges 256,000 256,000 0% Capacity Charges 334,000 334,000 -0% Storage Fees 332,000 332,000 0% Investment Interest --4 ,325 •• Water Capital Improvement Fund 922,000 922,000 4,325 0% (1)-Includes adjustments approved by City Council through December 5, 2017 Revised Proposed Prior Year Increase or Projection Increase YTDActual Decrease 2017/18 (Decrease.) 2016/17 From P/Y --{517) -1157% $ 179,895 $ -$ 861,454 -79% $ 37 ,489,918 $ 857,108 $ 4,653,259 -19% $ 6,906,000 $ -$ 4,002,685 -7% 4,928,000 -1,175,544 6% - - •• - 456,900 -114,754 97% 488,270 -100% 12,779,170 -5,292,983 0% 1,062,560 -27,661 5% 10,000 -(522) -1157% 1,416,645 -361,999 -2% 1,906,715 -476,991 100% 4,395,920 -866,129 0% 596,000 (268,000) 49,425 -44% 6,635,000 380,265 137% 7,231,000 (268,000) 429,690 116% 8,000 (495) -1008% - -3,390 -100% 8,000 -2,895 55% 256,000 -4,556 -100% 334,000 -5,934 -100% 332,000 -5,874 -100% - - (710) -709% 922,000 -15,654 -72% ::; -I )> 0 I s: m z -I N "'U Ql (Q CD -.J 0 -CX> Budget Update Description 2017/18 Non-Potable Water Caf:!itallmf:!rovement Fund Water Capacity Charge 40,000 Investment Interest Transfers In-Water Capital Replacement Fund . Transfers In-Non-Potable Water Operations Fund 477,500 Total Non-Potable Water Capital Improvement Fund 517,500 Non-Potable Water Of:!erations Fund Water Commodity Charges 957,000 Customer Services Charges 66,000 MWD Grant 5,250 Investment Interest 1,000 Other Water Service Revenues 2,000 Total Non-Potable Water Operations Fund 1,031,250 SJC Public Financing Authoritll Lease Revenue-City of SJC Water Enterprise 795,445 WATER ENTERPRISE FUNDS· TOTAL $ 27,948,285 Sewer Enterf:!rise Of:!erations Fund Sewer Service Charges $ 3,408,610 Investment Interest 15,000 Other Interest 50,500 Loan Repayment from Water Operations Fund 715,000 Total Sewer Enterprise Operations Fund 4,189,110 Sewer Caf:!ital Ref:!lacement Fund Investment Interest 23,000 Transfers In-Sewer Operations Fund 500,000 Total Sewer Capital Replacement Fund 523,000 Sewer Caf:!itallmf:!rovement Fund Sewer Connection Fees 1,132,000 Investment Interest 35,000 Other Interest 50,500 Loan Repayment from Water Operations Fund 715,000 Total Sewer Capital Improvement Fund 1,932,500 SEWER ENTERPRISE FUNDS-TOTAL _$ 6,644,610 (1)-Includes adjustments approved by City Council through December 5, 2017 CITY OF SAN JUAN CAPISTRANO FY 2017/18 REVENUE & TRANSFERS IN BY FUND JULY 1, 2017 THROUGH SEPTEMBER 30,2017 Amended Percent Bud set YTOActual Reallted 2017/18 (1) 2017/18 2017/18 40,000 -0% . 491 ** --0% 477,500 119,375 25% 517,500 119,866 23% 957,000 358,552 37% 66,000 14,770 22% 5,250 . 0% 1,000 517 52% 2,000 . 0% 1,031,250 373,839 36% 795,445 2,967 0% $ 27,948,285 $ 7,615,068 27 % $ 3,408,610 $ 882,766 26% 15,000 5,844 39% 50,500 3,578 7% 715,000 -0% 4,189,110 892,188 21% 23,000 5,001 22% 500,000 125,000 25% 523,000 130,001 25% 1,132,000 359,777 32% 35,000 8,091 23% 50,500 3,988 8% 715,000 -0% 1,932,500 371,856 19% $ _§,644,610 $ 1,394,045 21% Revised Proposed Prl9r Year Increase or Projection Increase YTDActual Decrease 2017/18 (Decrease) 2016/17 From P/Y 40,000 . ** . . ** 22,000 22,000 -•• 477,500 160,250 -26% 539,500 22,000 160,250 -25% 957,000 . 368,860 -3% 66,000 14,837 0% 5,250 . •• . 1,000 . (19) -2821% 2,000 . . •• 1,031,250 . 383,678 -3% 795,445 . 2,079 43% $ 27,702,285 $ (246,000) $ 7,153,358 6% $ 3,408,610 $ -$ 897,345 -2% 15,000 -(456) -1382% 50,500 . 3,550 1% 715,000 . -•• 4,189,110 . 900,439 -1% 23,000 -(395) -1366% 500,000 -125,000 0% 523,000 . 124,605 4% 1,132,000 . 22,208 1520% 35,000 -(811) -1098% 50,500 -4,232 -6% 715,000 . .. 1,932,SOO . 2S,629 1351% $ 6,644,610 $ . $ 1,050,673 33% - ~ --i )> () I s: m z --i N ""tJ Q) (Q (I) CP 0 -CP budget Update Description 2017/111 SJC HOUSING AUTHORITY FUNDS Housing Authoritll Administration Fund Rental Income s 4,100 Investment Interest 3,500 Interest from Outstanding Loans Receivable 155,000 Miscellaneous Revenue - Total Housing Authority Administration Fund 162,600 Little HoiiJlwood Rental Housing Fund Rental Income 195,000 Miscellaneous Revenue 500 Total Little Hollywood Rental Housing Fund 195,500 Successor Agen£ll Housing Bonds Fund Investment Interest 25,000 SJC HOUSING AUTHORITY FUNDS-TOTAL $ 383,100 ENTERPRISE FUNDS-TOTAL $ 34,975,99S INTERNAL SERVICE FUNDS Insurance and Benefits Fund Health Insurance Charges $ 1,865,140 Worker's Compensation Charges 338,530 General Liability Charges 1,296,395 Other Benefit Charges 234,335 Bilingual Pay Charges 19,800 Retirement Charges 3,080,665 Miscellaneous Revenue - Total Insurance and Benefits Fund 6,834,965 Facilities Operations Fund Allocated Charges 1,902,425 Investment Interest 17,000 Total Facilities Operations Fund 1,919,425 INTERNAL SERVICES FUNDS-TOTAL $ 8,754,390 CITY OF SAN JUAN CAPISTRANO FY 2017/18 REVENUE & TRAN SFERS IN BY FUND JULY 1, 2017 THROUGH SEPTEMBER 30,2017 Amended Percent Budget 'tTDActual Realized 2017/18(1) 2017/18 2017/18 s 4,100 $ 1,023 25% 3,500 2,464 70% 155,000 36,768 24% --0% 162,600 40,255 25% 195,000 55,801 29% 500 -0% 195,500 55 ,801 29% 25,000 16,338 65% $ 383,100 $ 112,394 29 % $ 34,975,995 $ 9,121,507 26% $ 1,865,140 s 361,311 19% 338,630 67,602 20% 1,296,395 324,099 25% 234,335 41,607 18% 19,800 4,623 23% 3,080,665 573,653 19% --0% 6,834,965 1,372,895 20% 1,902,425 475,607 25% 17,000 7,800 46% 1,919,425 483,407 25% $ 8,754,390 $ 1,856,302 21 % TOTAL REVENUES & TRANSFERS IN $ 79,290,370 $ 80,363,195 $ 14,742,123 18% (1)-Includes adjustments approved by City Council through December 5, 2017 Revised Proposed Prior Year IncreaSe or Projection Increase YTDActual Decrease 2017/18 (Decrease) 2016/17 From P/Y s 4,100 $ -s 6,114 -83% 3,500 -901 173% 155,000 -36,953 -1% --1,000 -100% 162,600 -44,968 -10% 195,000 -50,904 10% 500 -•• - 195,500 -50,904 10% 25,000 -7,018 133% $ 383,100 -$ 102,890 9% $ 34,729,995 $ (246,000) $ 8,306,921 10% $ 1,865,140 $ -$ 353,099 2% 338 ,630 -54,594 24% 1,296,395 -913,498 -65% 234,335 -40,701 2% 19,800 -4,522 2% 3,080,665 -558,091 3% -139 -100% 6,834,965 -1,924,644 -29% 1,902,425 494,187 -4% 17,000 -{734) -1163% 1,919,425 -493,453 -2% $ 8,754,390 $ $ 2,418,097 -23 % $ 80,974,303 $ 611,108 $ 15,378,277 -4% ~ --i )> () I s: m z --i (....) "'U Ol (Q C'D -->. 0 -Q) Destrlptlon GENERAL FUNDS General Fund GENERAL GOVERNMENT Legislation: City Council Commissions & Committees City Manager: Administration Human Resources Economic Development City Attorney: General Services Litigation Settlement Payments City Clerk Finance: Administration Finance Business License Customer Service GENERAL GOVERNMENT-TOTAL PUBLIC SAFETY Law Enforcement-OCSD Contract Law Enforcement-Other Costs Public Safety Contract Services A.S.A.P. Volunteer Program Emergency Preparedness PUBLIC SAFETY-TOTAL COMMUNITY SERVICES Administration Facility Operations Special Events Class Programs Athletic Programs Youth Programs Early Childhood Development Senior Citizens Services CITY OF SAN JUAN CAPISTRANO FY 2017/18 OPERATING EXPENDITURES & TRANSFERS OUT BY FUND AND ACTIVITY JULY 1, 2017 THROUGH SEPTEMBER 30, 2017 Budget Amended Petcer1t Update BUdJet YTD Actual Reallted 2017/1$ 2DP/18(11 20l7/18 'J.017/1B $ 164,895 $ 164,895 $ 40,582 25% $ 1,070,270 1,070,270 224,181 21% 291,980 314,980 54,214 17% 119,470 119,470 24,693 21% 613,210 613,210 44,667 7% -452,000 11,994 3% 6,000 6,000 -0% 592,600 592,600 127,714 22% 622,300 620,830 144,405 23% 634,355 669,875 139,486 21% 124,085 124,085 11,600 9% 77,965 79,435 20,167 25% 4,317,130 4,827,650 843,703 17% 9,729,655 9,729,655 1,616,542 17% 362,435 379,313 86,078 23% 515,035 515,815 1,957 0% 23,545 22,7 65 2,990 13% 34,115 34,115 5,641 17% 10,664,785 10,681,663 1,713,208 16% 811,645 813,105 199,472 25% 227,730 226,140 38,805 17% 228,010 236,745 86,645 37% 152,540 152,540 26,322 17% 106,710 105,950 22,227 21% 110,480 110,480 6,329 6% --0% 140,245 132,545 18,408 14% (1) Includes adjustments approved by City Council action through December 5, 2017. Revised Proposed Prior Year Increase or ProJection Increase_ YTDActual Decrease 2017/18 (Decrease) 2016/17 From P/Y 164,895 $ $ 38,108 6% 1,070,270 -257,409 -13% 314,980 -54,903 -1% 119,470 -18,256 35% 613,210 84,479 -47% 452,000 --.. 6,000 -•• - 599,600 7,000 132,767 -4% 693,830 73 ,000 161,141 -10% 669,875 -190,748 -27% 117,085 (7,000) 21,613 -46% 76,435 (3,000) 24,555 -18% 4,897,650 70,000 983,979 -14% 9,729,655 -2,200,407 -27% 379,313 -85,818 0% 515,81S 38,373 -95% 22,765 -5,403 -4 5% 34,115 -19,144 -71% 10,681,663 -2,349,145 -27% 813,105 -211 ,683 -6% 226,140 -44,819 -13% 236,745 -85,595 1% 152,540 -8,672 204% 105,950 -21,529 3% 110,480 -6,040 5% --21,894 -100% 132,545 -21,496 -14% ~ ---i )> () I s:: m z ---i c.v "1J ru (Q CD N 0 -CXl Oe,s crlptlon Community Center Operations Gymnasium Operations COMMUNITY SERVICES-TOTAL DEVELOPMENT SERVICES Adm inistration Commissions Boards Committees Plann ing Services Permit Services : Building Permit Services Environmental Permit Services Building Inspection Services Code Enforcement DEVELOPMENT SERVICES-TOTAL PUBLIC WORKS/UTILITIES Administration Engineering: General Engin e ering Development Engineering Traffic Engineering Eng ineering Inspection Serv ices Maintenance and Support: Building/Facility Operations General Maintenance Special Event Support Weed Abatement Streets and Traffic: Street Maintenance Street Cleaning Street Lighting Traffic Control Storm and Winter Preparation Parks and Open Space : Parkways, Medians, & Landscaping Park Maintenance Open Space Ma intenance Trail Maintenance Sports Park Ma intenance CITY OF SAN JUAN CAPISTRANO FY 2017/18 OPERATING EXPENDITURES & TRANSFERS OUT BY FUND AND ACTIVITY JULY 1, 2017 THROUGH SEPTEMBER 30, 2017 Budget Am ended Pe.rcen t Update Budg et YTDActuel Riiallzed 2017/18 2017/1811) 2.017/-18 2017/18 273,995 273,995 55 ,722 20 % 104,150 103,715 25 ,465 25 % 2,1S5,505 2,155,215 479,395 22% 884,085 884,085 191,153 22% 1,800 1,800 -0% 598,275 612,275 150,108 2S % 346,175 377,17S 81,402 22% 17,860 17,860 3,138 18% 339 ,890 339,890 60 ,947 18% 342,610 342,610 72,796 21 % 2,530,695 2,575 ,695 559,544 22% 1,183,88S 1,183,885 247,685 21% 376,780 S12,780 1S6,S84 31% 3S8,910 392,610 S6 ,002 14% 342 ,91S 342,915 28 ,191 8% 47,140 47,140 13 ,023 28 % 5S,87S S5 ,875 934 2% 479,330 492,330 66 ,091 13 % 83,39S 8S ,98S 8,478 10% 1S4,130 1S4,130 7,829 S% 3S6,220 4S0,220 40,092 9% 158,62S 1S8,62S 25 ,S42 16% 173,780 173,780 42 ,561 24% 164,3SS 169,355 11,915 7% 76,670 76 ,670 1,572 2% 396,740 396,740 SS ,2.50 14% 843,670 843 ,670 148,521 18% 108,010 125 ,010 4,S62 4% 105,000 105,000 9,3SO 9% 460,81S 460,81S 64,409 14% (1) Includes adjustments approved by City Council action through December 5, 2017. Rev ised Proposed Prior Year ln ctease or ProJection Increase YT DActua l Decrease 2017/18 (Decrease) 20i6/17 From P/Y 273 ,995 -64 ,029 -13 % 103,715 -28,989 -12% 2,155,215 -514,746 -7% 884,085 -28 7,754 -34% 1,800 -•• 612,27S -14S,313 3% 377,175 84,304 -3 % 17,860 3,081 2% 339,890 -62 ,395 -2 % 342,610 -70,78 1 3% 2,575,695 653,628 -14% 1,183,88S -325,718 -24% S12,780 . 109,999 42 % 392,610 . 61,S63 -9 % 342,91S . 31,673 -11% 47,140 . 20,S16 -37 % SS,87S -10,787 -91 % 492,330 . 113,199 -42 % 85,98S . 12 ,460 -32 % 154,130 3,698 112% 4S0,220 -20,SS8 95 % 158,62S -25 ,S49 0% 173,780 ' 2.8 ,341 50 % - 169,355 -33,809 -65 % 76 ,670 -. •• 396,740 54,2.25 2% 843,670 1S7,884 -6 % 12.5,010 . 2,961 54% 10S,OOO . 37,82S -7S % 460,81S 71 ,189 -10% ::; -1 f) I :s:: m z -1 c..v "'U Q) co CD c..v 0 -(X) Dentlptlon Environmental: NPDES/Water Quality Trash/Recycling Storm Drain Maintenance General Services System Maintenance Emergencies & After Hours Response PUBLIC WORKS/UTILITIES-TOTAL TRANSFERS OUT To Parking Maintenance To Debt Service To Capital Projects To Facilities Operations TRANSFERS OUT· TOTAL GENERAL FUND -TOTAL Parking Maintenance Fund Finance-Parking Administration Public Works-Parking Maintenance Utilities-Field Customer Service Total Parking Maintenance Fund SACRALHousing Authori~ Administration Fund City Manager's Office City Clerk Finance Development Services-Housing Public Works-lower Rosan Ranch Property Maintenance Total SACRA/SJCHA Administration Fund Farm Operations Fund Farm Management/Operations Recycled Water-Well Maintenance Total Farm Operations Fund CITY OF SAN JUAN CAPISTRANO FY 2017/18 OPERATING EXPENDITURES & TRANSFERS OUT BY FUND AND ACTIVITY JULY 1, 2017 THROUGH SEPTEMBER 30, 2017 Blldgef Amended Perce.nt. Update Budg~t YTOA.ctual Realized 2017/18 2017/18 (1) 2017/18 2017/18 325,975 325,975 10,482 3% 26,320 51,320 6,794 13% 46,415 46,415 8,469 18% 219,500 279,500 13,687 5% 4,215 4,215 743 18% 6,S48,670 6,934,960 1,028,766 15% --. 0% 307,980 307,980 2.91,171 95% -169,895 169,895 100% . -. 0% 307,980 477,875 461,066 96% 26,524,765 27,653,058 5,085,682 18% 71,735 71,735 7,774 11% 55,665 55,665 5,479 10% 11,555 11,655 2,233 19% 139,055 139,055 15,486 11% 114,935 114,935 31,419 27% 9,410 9,410 1,564 17% 107,575 107,575 2.0,434 19% 50,040 51,040 6,642 13% . -1,2.67 •• 281,960 282,960 61,326 22% 27,710 27 ,710 217 1% 1,885 1,885 . 0% 29,595 29,595 217 1% (1) lndudes adjustments approved by City Council action through December 5, 2C17 . Revised Propo~e'd Prior Year Increase or Pro)ectfon Increase 't'TO Actual Decrease 2017/18 (Decrease) 2016/17 From P/Y 325,975 -8,685 21% 51,320 -3,597 89% 46,415 -8,560 -1% 274,500 (5,000) 7,870 74% 4,215 -755 -2.% 6,929,960 (S,OOO) 1,151,421 -11% . . 19,176 -100% 307,980 2.88,721 1% 169,895 12,559 1253% . . ** - 477,875 . 320,456 44% 27,718,058 65,000 5,973,375 -1 5% 71,735 . 7,596 2.% 55,665 . 5,904 -7% 11,655 . 1,577 42% 139,055 -15,077 3% 114,935 -13,864 12.7% 9,410 -1,722 -9% 107,575 6,363 22.1% 51,040 4,530 47% •• . . 282,960 . 26,479 132% 2.7,710 24,478 -99% 1,885 . 187 -100% 29,595 -24,665 -99% ~ ~ I s:: m z -i w ""'J Q) c.c CD .to. 0 -(X) CITY OF SAN JUAN CAPISTRANO FY 2017/18 OPERATING EXPENDITURES & TRANSFERS OUT BY FUND AND ACTIVITY JULY 1, 2017 THROUGH SEPTEMBER 30, 2017 Budget Amended Pertent Uj)date Budget YTD Actual Reall~d Description 2017/18 2017/18111 2017/18 2017/18 Eastern Open Space Fund City Manager's Office 85,940 94,940 15,947 17% Legal Costs: General Legal Services -5,000 1,486 30% Litigation . . 4,160 ** Settlement Payments 18,000 36,000 12,000 33% Parks and Open Space-Maintenance (Public Works) 209,450 224,850 25,629 11% Reata Park Improvements (Community Services) . 1,125 . 0% Total Eastern Open Space Fund 313,390 361,915 59,222 16% TOTAL GENERAL FUNDS $ 27,288,765 $ 28,466,583 $ 5,221,933 18% $ SPECIAL REVENUE FUNDS C&D Forfeited Bonds Fund Public Works/Utilities-Recycling Programs $ 14,280 $ 14,280 $ 476 3% $ Systems Development Fund Transfer Out-General Fund for Replacement of Municipal Offices sign on Paseo Adelanto/ . 5,000 . 0% Landscape Maintenance Fund Medians and Landscape Maintenance 177,610 177,610 26,294 15% CDBG/HOME Fund Housing Administration 143,730 144,730 104,094 72% Gas Tax Fund Transfer Out-General Fund for street maintenance 344,000 344,000 86,000 25% CCFP Fees Fund Reimbursement Agreement with Rancho Mission Viejo, LLC . . 0% S.O.N.G.S. Fund Emergency Preparedness 193,600 208,665 42,762 20% (1) Includes adjustments approved by City Council action through December 5, 2017. R~vlsed Proposed Prl9r Year Increase or Projection lncre.a.se YTDAetual Decrease · 2017/18 (Decrease) 2016/17 From P/Y 94,940 --** 5,000 - - .. 182,000 182,000 -** 36,000 -. ** 224,850 -22,834 12% 1,125 -** 543,915 182,000 22,834 159% 28,713,583 $ 247,000 $ 6,062,430 -14% 14,280 $ . $ . •• •• 5,000 -$ - 177,610 -19,637 34% 327,730 183,000 40,972 1S4% 344,000 -117,250 -27% 55,985 55,985 •• 208,665 -58,239 -27% ~ --i )> () I :s: m z --i (..V ""'0 Q) (Q CD CJ'1 0 -(X) CITY OF SAN JUAN CAPISTRANO FY 2017/18 OPERATING EXPENDITURES & TRANSFERS OUT BY FUND AND ACTIVITY JULY 1, 2017 THROUGH SEPTEMBER 30, 2017 Budge~ Aml!nded Percent Update 8Udll!t YTDActual Reallted Description 2017/111 2017/ill(~) 2017/18 2017/18 AgMD Fund Transfer Out-General Fund for Senior Mobility Transportation Grant Match 11,000 11,000 1,206 11% Transfer Out-General Fund for Summer Trolley Program -40000 -0% Total AQMD Fund 11,000 51 ,000 1,206 2% law Enforcement Grants Fund Transfer Out-General Fund for public safety 100,000 100,000 56,305 56% Street and Highwavs Grant Fund Transfer Out-General Fund (for Summer Trolley Program) -69,000 -0% SPECIAL REVENUE FUNDS-TOTAL $ 984,220 s 1,114,285 $ 317,137 194% $ DEBT SERVICE FUND 1998A Refunding General Obligation Bonds-Principal and Interest $ 502,250 $ 502,250 $ 502,250 100% $ 2009A General Obligation Bonds-Principal and Interest ---•• 2011 Judgment Obligation Bonds-Principal and Interest 305,480 305,480 289,091 95% 2017 Refunding General Obligation Bonds-Principal and Interest 1,747,485 1,747,485 1,261,448 72% Measure Y Annual Audit 20,000 20,000 0% Bond Administration Costs 13,500 13,500 2,080 15% Total Debt Service Fund $ 2,588,715 $ 2,588,715 $ 2,054,869 79% $ GENERAL GOVERNMENTAL FUNDS· TOTAL $ 30,861,700 $ 32,169,583 $ 7,593,939 24% $ ENTERPRISE FUNDS Water Operations Principal Repayment on loan from Sewer Funds $ 1,430,000 $ 1,430,000 $ -0% $ Interest on loan from Sewer Funds 101,000 101,000 7,156 7% General liability Insurance and User Fee Study 412,370 412,370 103,093 25% legal Costs: General legal Services 50,000 50,000 5,561 11% litigation 450,000 640,000 80,465 13% Customer Service 717,700 737,700 113,943 15% General Engineering 144,745 144,745 43,207 30% Development Engineering 95,415 95,415 21,881 23% Engineering-Inspection Services 143,020 143,020 35,539 25% General Services 1,478,116 1,654,116 380,351 23% (1) Includes adjustments approved by City Council action through December 5, 2017. Revised Proposed Prior Year Increase or Projection Increase YTDActua.l Decrease 2017/18 (Decrease) 2016/17 From P/Y 11,000 -1,705 -29% 40,000 -•• 51,000 -1,705 -29 % 101,512 1,512 43,714 29% 69,000 -•• 1,354,782 $ 240,497 $ 281,517 13% 502,250 $ -$ 488,875 3% -1,249,150 -100% 305,480 -286 ,741 1% 1,747,485 --•• 20,000 --•• 13,500 -2,880 -28% 2,588,715 $ -$ 2,027 ,646 1% 32,657,080 $ 487,497 $ 8,371,593 -9% 1,430,000 $ -$ -•• 101,000 -7,101 1% 412,370 -331,673 -69% 50,000 -8,483 -34% 640,000 -278,030 -71% 735,700 {2,000) 140,780 -19% 144,745 -53,469 -19% 95,415 -29 ,336 -25% 143,020 -31,002 15% 1,653,816 {300) 359,112 6% ~ __, )> () I s:: m z __, UJ ""0 ru (Q ('!) (j) 0 -(X) De!crlptlon Water Conservation Field Customer Service Strategic Planning Regulatory Compliance Import Water Supply Distribution & Pumping System Water Quality Cross & Backflow Connection System Maintenance Well Maintenance Reservoir Maintenance Preventative Maintenance Booster & Facilities Maintenance Emergency & After-Hours Response Transfers Out· Water Debt Service Fund Total Water Enterprise Operations Fund Water Debt Service Fund 2014A Water Refunding Bonds-Principal and Interest 2009 Certificates of Participation Lease Payment San Juan Basin Authority Lease Payment Bond Administration Costs Total Water Debt Service Fund GWRP Operations Fund General Liability and Property Insurance GWRP-General Services GWRP-Water Quality GWRP -Piant Operations GWRP-Well Maintenance GWRP-Reservoir Maintenance GWRP-Emergencies Response Transfers Out-Water Debt Service Fund Transfers Out-Water Operations Fund Total GWRP Operations Fund CITY OF SAN JUAN CAPISTRANO FY 2017/18 OPERATING EXPENDITURES & TRANSFERS OUT BY FUND AND ACTIVITY JULY 1, 2017 THROUGH SEPTEMBER 30, 2017 Budget 'Amended Pi!rcent Update Bullget YTD Actual Realized 2017/18 2017/18 (1) 2017/18 2017/a 209,395 209,395 15,279 7% 155,49S 155,495 32,828 21% 227,2S9 227,259 1,538 1% 51,955 51,955 7,420 14% 3,701,845 3,701,845 810,957 22% 258,585 258,585 72,170 28% 461,380 461,380 86,413 19% 41,135 41,135 14,320 35% 917,280 988,130 103,803 11% 61,725 62,875 16,974 27% 67,365 67,365 13,492 20% 54,970 54,970 4,675 9% 138,370 138,370 1,536 1% 67,400 67,400 12,075 18% 1,416,645 1,416,645 354,161 25% 12,853,170 13,311,170 2,338,837 18% 1,688,760 1,688,760 -0% 795,445 795,445 1,250 0% 1,904,215 1,904,215 -0% 7,500 7,500 -0% 4,395,920 4,395,920 1,250 0% 122,900 122,900 85,375 69% 100,192 100,192 37,792 38% 185,110 185,110 34,955 19% 1,226,495 1,226,495 224,265 18% 369,418 369,418 53,651 15% 3,345 3,345 975 29% 84,250 84,250 15,813 19% 1,906,715 1,906,715 476,679 25% 488,270 488,270 122,068 25% 4,486,695 4,486,695 1,051,573 23% (1) lndudes adjustments approved by City Council action through December 5, 2017 . Revised Proposed Prior Year Increase or Projection Increase YTDActual Decrease 2017/18 (Decrease) 2016/17 From P/Y 209,395 . 43,039 -64% 1S4,995 (500) 28,319 16% 227,2S9 . 4,319 -64% 69,955 18,000 5,017 48% 4,865,845 1,164,000 1,448,301 -44% 264,285 5,700 57,178 26% 447,080 (14,300) 54,125 60% 51,135 10,000 6,880 108% 938,130 (50,000) 84,228 23% 62,475 (400) 15 ,3 87 10% 66,765 (600) 7,860 72% 54,970 . 19,156 ·76% 137,770 (600) 4,593 -67% 67,400 -12,072 0% 1;416,645 . 36 1,999 -2% 14,440,170 1,129,000 3,391,459 ·31% 1,6 88,760 -. •• 795,445 -1,500 -17% 1,904,215 --•• 7,500 . -•• 4,395,920 . 1,500 ·17% 122,900 . 89,719 -5% 100,192 -19,907 90% 185,110 -25,809 35% 1,402,495 176,000 185,647 21% 357,418 (12,000) 32,446 65% 3,345 --•• 84,250 -15,090 5% 1,906,715 -476 ,991 0% 488,270 --** 4,650,695 164,000 845,609 24% ~ -I )> 0 I s:: m z -I w "'U Ql (Q CD -.J 0 -00 CITY OF SAN JUAN CAPISTRANO FY 2017/18 OPERATING EXPENDITURES & TRANSFERS OUT BY FUND AND ACTIVITY JULY 1, 2017 THROUGH SEPTEMBER 30, 2017 Budget Amended Percent Update Budget YT'DAttual Realized Description 2017/18 2017/18 (11 2017/18 2017/18 Water Ca11itallm!!rovement Fund Transfers Out-Non-Potable Water Capital Improvement Fund ---** Non-Potable Water O!!erations Fund General Liability Insurance 8,655 8,655 2,164 25% Finance-Customer Service 10,100 10,100 2,525 25% General Engineering 31,020 31,020 2,082 7% Development Engineering 22,280 22,280 6,112 27% Engineering-Inspection Services 1,785 1,785 -0% General Services 1,500 1,500 -0% Strategic Planning 49,745 49,745 8,631 17% Regulatory Compliance 1,995 1,995 1,698 85% Import Water Supply 316,595 316,595 44,373 14% Cross & Backflow Connection 3,000 3,000 -0% System Maintenance 28,160 28,160 419 1% Well Maintenance 72,644 72,644 19,923 27% Transfer Out-Non-Potable Water Capital Projects Fund 477,500 477,500 119,375 25% Total Non-Potable Water Operations Fund 1,024,979 1,024,979 207,302 20% SJC Public Financing Authority 795,445 795,445 -0% WATER OPERATIONS ENTERPRISE FUNDS-TOTAL $ 23,556,209 $ 24,014,209 $ 3,598,962 15% $ Sewer O!!erations General Liability Insurance $ 14,705 $ 14,705 $ 3,676 25% s Finance-Customer Service 228,800 228,800 57,200 25% General Engineering 28,440 28,440 4,517 16% Engineering Inspection Services 3,570 3,570 -0% NPDES/Water Quality 20,000 30,000 -0% General Services 118,135 118,135 22,103 19% Strategic Planning 1,000 1,000 -0% Regulatory Compliance 6,925 6,925 -0% Lift Stations 148,979 148,979 6,388 4% Plant 2,423,474 2,423,474 465,142 19% System Maintenance 446,383 446,383 75,148 17% Emergency & After Hours Response 12,640 12,640 3,126 25% Transfer Out-Capital Replacement Fund 500,000 500,000 125,000 25% SEWER OPERATIONS FUNDS-TOTAL $ 3,953,051 $ 3,963,051 $ 762,300 19% $ (1) Includes adjustments approved by City Council action through December 5, 2017 . Revised Proposed Prior Year Increase or Projection Increase YTDAttual Decrease 2017/18 (Decrease) 2016/17 From P/Y 22,000 22,000 -** 8,655 -9,988 -78% 10,100 -2,275 11% 31,020 -5,107 -59% 22,280 -4,723 29% 1,785 -256 -100% 1,500 --** 49,745 -11 ,095 -22% 1,995 -641 165% 200,595 {116,000) 58,040 -24% 3,000 - - n 26,500 (1,660) 4,009 -90% 84,304 11,660 30,732 -35% 477,500 -160,250 -26% 918,979 (106,000) 287,116 -28% 795,445 -** 25,223,209 $ 1,209,000 $ 4,525,684 -20% 14,705 $ -$ 11,677 -69% 228,800 -46,125 24% 28,440 -1,617 179% 3,570 -2,188 -100% 30,000 -** - 118,135 -28,546 -23% 1,000 -** - 6,925 -** - 145,979 {3,000) 7,077 -10% 1,864,474 {559,000) 603,414 -23% 446,383 -73,259 3% 12,640 -2,263 38% 500,000 -125,000 0% 3,401,051 $ (562,000) $ 901,166 -15% ~ _, )> () I :5: m z _, (J.) ""'0 !l) co CD CXl 0 -CXl Descrlp_tlon SJC HOUSING AUTHORITY FUNDS Housing Authority Administration Housing Administration Rental Subsidy Program Total Housing Authority Administration little Hollywood Rental Housing Little Hollywood Rental Housing Program Successor Agency Housing Bonds Fund Loan to Seasons Apartments approved by CC 11.1.16 SJC HOUSING AUTHORITY FUNDS-TOTAL ENTERPRISE FUNDS-TOTAL INTERNAL SERVICE FUNDS Insurance and Benefits Personnel Benefits and Insurance General liability and Property Insurance Total Insurance and Benefits Fund Facilities Operations Business Services Information Technology Facilities Maintenance Fleet Acquisition & Maintenance Total Facilities Operations INTERNAL SERVICE FUNDS-TOTAL TOTAL EXPENDITURES & TRANSFERS OUT CITY OF SAN JUAN CAPISTRANO FY 2017/18 OPERATING EXPENDITURES & TRANSFERS OUT BY FUND AND ACTIVITY JULY 1, 2017 THROUGH SEPTEMBER 30,2017 8ud11et Amended Percent update Budget 't'TD Actual Reallted 2017/18 2017/18 (1) 2017/18 2017/18 $ 49,765 $ 49,765 $ 3,713 7% $ 12,660 ll,660 3,165 25% 62,425 62,425 6,878 11% 184,875 191,280 38,579 20% -1,000,000 -** $ 247,300 $ 1,253,705 $ 45,457 4% $ $ 27,756,560 s 29,230,965 $ 4,406,719 15% $ $ 5,538,570 $ 5,538,570 $ 1,421,455 26% $ 1,296,395 1,296,395 1,2_46,774 96% 6,834,965 6,834,965 2,668,229 39% 38,700 38,700 6,211 16% 1,205,995 1,373,995 207,763 15% 976,565 976,565 135,034 14% 584,410 584 410 43,226 7% 2,805,670 2,973,670 392,234 13% $ 9,640,63S $ 9,808,635 $ 3,060,463 31% $ $ 68,258,895 $ 71,209,183 $15,061,121 21% $ (1) Includes adjustments approved by City Council action through December 5, 2017. Revised PrDj)OSed Prior Year Increase or Projection Increase VTD Actual Decrease 2017/18 (Decrease) 2016/17 From P/Y 51,765 $ 2,000 $ 3,613 3% 12,660 -13,165 -76% 64,425 2,000 16,778 -59% 191,280 -41,489 -7% 1,000,000 --** 1,2SS,705 $ 2,000 $ 58,267 -22% 2.9,8 79,965 $ 649,000 s 5,4 85,117 -20% 5,538,570 $ -$ 1,301,201 9% 1,296,395 1,278,231 -2% 6,834,965 -2,579,432 3% 38,700 -8,579 -28% 1,373,995 344,923 -40% 976,565 . 94,558 43% 584,410 29,331 47% 2,973,670 -477,391 -18% 9,808,635 $ -$ 3,056,82.3 0 % 72,345,680 $ 1,136,497 $ 16,913,533 -11% )> -I -I )> 0 I s:: m z -I ~ lJ w (Q (I) -->. 0 -~ CITY OF SAN JUAN CAPISTRANO FY 2017/18 CAPITAL IMPROVEMENT PROJECTS (CIP) JULY 1, 2017 THROUGH SEPTEMBER 30, 2017 Amended Project Budget Update Budget No. Description 2017/18 2017/1~ Transportation 07117 1-5 at San Juan Creek Road Underpass Improvements $ $ 887,140 11101 Citywide Sign Replacement Program 173,000 339,745 13103 Regional Traffic Signal Synchronization Program (Del Obispo Street) 8,315 14103 Camino Las Ram bias and 1-5 Northbound Traffic Signal Modification 291,890 14104 Ali paz Street Widening-Camino del Avion to Calle Rolando 27,505 14106 Verdugo Street Beautification Project 1,949,440 15103 Countdown Pedestrian Signals Projects 134,265 16101 Traffic Signal Cabinet Upgrades 226,000 242,420 16102 Del Obispo Widening-Via de La Paz 1,197,550 1,954,940 16104 Left Turn Lane at Del Taco 39,510 16109 Arterial Street Major Rehabilitation Program -Fiscal Year 2015/16 33,920 17105 Local Streets Pavement Rehabilitation-Fiscal Year 2016/17 354,630 17109 Arterial Street Major Rehabilitation Program-Fiscal Year 2016/17 271,475 18101 Capistrano Villas I, II, and Ill Pavement Rehabilitation 2,424,387 18105 Local Streets Pavement Rehabilitation -Fiscal Year 2017/18 996,000 - 18109 Arterial Street Major Rehabilitation Program -Fiscal Year 2017/18 140,000 - Total Transportation $ 2,732,550 $ 8,959,582 Parks and Open Space 07204 Citywide Trail Improvements $ $ 75,000 09203 Playground Upgrades 177,880 09209 Northwest Open Space Community Park 2,800,365 11203 Eastern Ope n Space Grounds Trails/Citywide Bikeway Gap Closure Project 479,990 11204 2C Ranch Trabuco/Oso Creek Riparian Habitat Restoration (OCTA) 32,115 14201 Cook Park Softball Fields #2 and #3 and Soccer Field #2 Improvements 88,750 16202 Cook Cordova Park Playground Equipment 78 ,940 16203 Malasp i na Trail 333,000 17201 Riding Park Fire Flow and Recycled Water Supply 941,130 17202 Eastern Open Space Trails A and A-1 212,410 18201 Cook La Novia Park Picnic Area Enhancements 175,000 175,000 18202 Arce Park Renovation 75 ,000 75 ,000 Total Parks and Open Space $ 250,000 $ 5,469,580 Buildings and Facilities 15301 Multi-Modal Parking Lot Pavement Overlay, Slurry, and Striping $ $ 19,400 15306 ADA Self Evaluation and Transition Plan 152,000 412,080 Total Bu ildings and Facilities $ 152,000 $ 431,480 <'1 1ncludes carryover amounts from Fiscal Year 2016/17 and City Council approved adjustments through December 5, 2017 . YTD Percent Proposed First Revised I Actual Realized Quarter Budget 2017/18 -201]/18 AdJ!!stments 2017/18 $ 0% $ $ 887,140 3,978 1% 339,745 0% -8,315 0% -291,890 -0% -27,505 0% 1,949,440 1,117 1% 134,265 144 0% -242,420 101,835 5% 45,000 1,999,940 0% 39,510 1,859 5% -33 ,920 117,563 33% 354,630 259,827 96% -271,475 0% -2,424,387 0% 0% $ 486,323 5% $ 45,000 $ 9,004,582 $ 0% $ $ 75,000 0% -177,880 16,709 1% 2,800,365 211 ,118 44% 479,990 36 0% 32,115 0% 88,750 260 0% 78,940 0% 333,000 17,997 2% 941,130 107 0% 212,410 -0% 175,000 -0% 75 ,000 $ 246,227 5% $ -$ 5,469,580 $ 689 4% -$ 19,400 620 0% 412,080 $ 1,309 0% $ -$ 431,480 >--l -l >-() I s: m z -l .t>. I 'lJ Ill (Q CD N 0 -.t>. Project No. Deurlptlon Drainage 12502 Camino Capistrano Off Ramp Cat~h Basins 14501 Los Rios Park Drainage Improvements 15502 Historic Town Center Drainage Improvements 15503 Calle Arroyo and Sundance Drive Drainage Improvements 15505 La Novia and La Ronda Drainage Improvements 16502 Interstate I-S/Ortega Hwy Storm Water Treatment Project CITY OF SAN JUAN CAPISTRANO FY 2017/18 CAPITAL IMPROVEMENT PROJECTS (CIP) JULY 1, 2017 THROUGH SEPTEMBER 30,2017 Amended Budget Update Budget 2017/18 2017/18 (ll $ $ 212,555 77,880 . 126,600 110,000 38,000 . 55,000 153,050 18501 San Juan Creek Road at Calle Caballero Drainage Improvements 55,000 Total Drai nage $ 203,000 $ 625,085 Water 07803 Terminal Reservoir No. 3 $ . $ 45,470 07811 760S Reservoir 79,390 08801 Joint Regional Water Supply System (JRWSS) Joint Transmission Line 20,000 1,005,860 08804 Pump Station Component Replacements 55,000 10803 San Juan Hills Waterline Replacements 1,915 11805 Water and Sewer Line Replacement at 1-5 Interchange 10,000 15801 Upper Ch iquita Reservoir Recirculation Pump and Upgrade Project 9,735.000 16801 La Pata Water Line Replacement 5,000 5,000 16804 Water Master Plan Study 100,000 17801 San Juan Hills Greens Cathodic Protection System 184,000 17802 760S Zone Pump Station Discharge Line Replacement 50 ,000 25,000 17803 Valve Insertion Program 100,000 200,000 17804 Capistrano Royale Fire Flow Pump 190,000 444,890 17805 Palletization and Space Consolidation 40,000 80,000 17806 Water Facility Control Systems 200,000 393 ,290 17807 Well Facility Equipment Replacement Program 23,450 17808 Eastern Irrigation Water System 312,205 18801 San Juan Basin Authority Hydrogeological Study 170,000 Total Water $ 605,000 $ 3,145,205 Non-Potable Water 16601 Recycled Water Service Conversions $ 150,000 $ 328,320 16602 Non-Potable Water Pipelines 75,700 17601 Trampas Canyon Recycled Water Reservoir 101,000 202,000 17602 Recycled Expansion-Grants Application 165,000 Total Non-Potable Water $ 251,000 $ 771,020 111 Includes carryover amounts from Fiscal Year 2016/17 and City Council appr~ved adjustments through December 5, 2017 , YTD Percent Proposed First Revised Actual Realized Quarter Budget 2017/18 2_017/18 Adjustments -2017/1!_ $ 0% $ . 212 ,555 0% 77 ,880 0% 126,600 0% 0% 0% 153,050 0% . 55,000 $ 0% $ $ 625,0 85 $ 0% $ $ 45,470 0% . 79,390 11,463 1% 1,005,860 0% . 55,000 0% (1,915) 2,315 23% -10,000 0% 9,735 0% 5,000 0% 100,000 0% 184,000 0% 25 ,000 0% 200,000 4,523 1% 444,890 0% 80,000 0% 393 ,290 (2,096) -9% 23,450 3,655 1% -· 312,205 0% 170,000 $ 19,860 1% $ (1,915) $ 3,143,290 $ 4,339 1% $ 328,320 0% 75,700 0% -202,000 0% 165,000 $ 4,339 1% $ $ 771,020 ~ -I )> 0 I s:: m z -I ~ -u ru co CD UJ 0 -~ Project No. Description Sewer CITY OF SAN JUAN CAPISTRANO FY 2017/18 CAPITAL IMPROVEMENT PROJECTS (CIP) JULY 1, 2017 THROUGH SEPTEMBER 30, 2017 Amended Budget Update Budget 2017/18 2017/18 Ill 07701 Sou t h Orange Cou nty Was t ewater Au t hority (SOCW A) PC#2 Rehab ilitation $ 1,294,000 $ 1,707,205 07703 New Hydraulic Capital Project #6 -200,000 08701 Grease Food Interceptor Program 147,500 14702 Las Ramb)as/Paseo Activo Slope Replacement 505,000 15703 South Orange County Wastewater Authority (SOCWA) PC#S Rehabi li tation 150,000 262 ,610 17701 Annual Sewer Replacement Program-Fiscal Year 2016/17 789,320 17702 Sewer Flow Metering & SCADA Monitoring Project 200,000 18701 Annual Sewer Replacement Program-Fiscal Year 2017/18 450,000 450,000 Total Sewer $ 1,894,000 $ 4,261,635 GRAND TOTAl $ 6,087,550 $ 23,663,587 Funding Source General Fund $ $ 169,895 Road Maintenance Rehabilitation Account (RMRA) (SB-1) 208,000 Systems Development Fund 376,000 903,490 Park/Recreation Fund 250,000 1,543,075 Drainage Fund -42 ,555 Agricultural Preservation Fees Fund 848,830 Gas Tax Fund 698,000 1,201,750 CCFP Fund 598,775 2,418,710 Eastern Open Space Fund 92,300 AQMD Fund 142,580 Measure M Turnback Fund 664,000 1,786,697 Parks, Recreation & Open Space Grant Fund 461,985 Streets & Highways Grant Fund 598,775 742,765 Other Grants Fund 76,050 Open Space Fund 1,408,585 Community Facilities District Bonds Fund 1,218,685 Successor Agency Non-Housing Bonds Fund 1,908,695 Water Operations Fund 140,490 GWRP Operations Fund 171,715 Water Capital Replacement 290,000 1,816,890 Water Capital Improvement Fund 295,000 1,008,330 Non-Potab le Water Capital Improvement Fund 271 ,000 833,800 Sewer Capital Replacement Fund 450,000 1,935,970 1'1 Includes carryover amounts from Fiscal Year 2016/17 and City Council approved adjustments through December 5, 2017 . YTD Percent Proposed First Revised Actual Realized Quarter Budget 2017/18 2017/18 Adjustments 2017/18 $ 339,495 20% $ -$ 1,707,205 0% 200,000 7,500 5% 147,500 0% 505,000 901 0% 262,610 0% (789,320) 0% 200,000 3,973 1% 789 ,320 1,239 ,320 $ 351,869 8% $ -$ 4,261,635 $ 1,109,927 5% $ 43,085 $ 23,706,672 $ 169,895 100% $ $ 169,895 0% 208,000 4,667 1% 903,490 2,100 0% 1,543,075 -0% 42 ,555 17,997 2% -848,830 138,057 11% 4,600 1,206,350 49,877 2% 45,000 2,463,710 0% 92,300 1,117 1% 142,580 71,442 4 % (4 ,600) 1,782 ,097 211,154 46% 461,985 51,958 7% 742,765 0% 76,050 14,975 1% 1,408,585 0% 1,218,685 0% 1,908,695 1,645 1% 140,490 2,010 1% 171,715 10,818 1% 21,535 1,838,425 4,523 0% 1,008,330 5,203 1% {23,450) 810,350 9,073 0% 1,935,970 ~ () :::r: s:: m z -I ~ ""'J ru (Q CD ~ 0 -~ Project No . Funding Source, Continued Sewer Capital Improvement Fund Facilities Operations Fund GRAND TOTAL Desc ri ption CITY OF SAN JUAN CAPISTRANO FY 2017/18 CAPITAL IMPROVEMENT PROJECTS (CIP) JULY 1, 2017 THROUGH SEPTEMBER 30, 2017 Budget Update $ 2017/18 1,444,000 15 2,000 6,087,550 $ Amended Budget 2017/18 til 2,270,665 311,08 0 23,663,587 $ <1l Includes carryover amounts from Fiscal Year 2016/17 and City Council approved adjustments through December 5, 2017, YTD Actual 2017/18 342,796 6 20 1,109,927 Percent Reall1ed 2017/18 15% 0% S% $ Proposed Fi rst Quarter AdJustment's Revised Budget 20 17/18 2,270,665 311,080 43,085 $ 23,706,672 City of San Juan Capistrano FY 2017/18 PROPOSED BUDGET ADJUSTMENTS Desaiption GENERAL FUND-01 Verizon cell tower lease revenue (initial license fee began in December 2017) Increase transfer from the Local Law Enforcement Grants Fund due to actual Fiscal Year 2016-17 revenue collected exceeding last year's budget Revise Finance Department's personnel budget to Fiscal Year 2017-18 Adopted Budget status (vacant Customer Service Representative position from Y-rated to Step 3; and reverting the Part-Time Office Assistant to Full-Time Administrative Coordinator) Additional funding associated with postage and printing costs for business license application and renewal forms due to new State law (Assembly Bill1379) approved in October 2017 Cost for hearing officer to mediate appeal of a business license application (not anticipated in the budget) Reallocation of Utilities Department staff charges based on reassigned duties Adjust personnel budget for City Clerk Administrative Specialist due to actual salary level (Step 5) is higher than the budget (Step 4) TOTALGEN£RA1FUND CDBG/HOME FUND Additional Home Loans expected to be issued during the current year Consultant services (New Turtle Island) and escrow fees associated with additional Home Loans expected to be issued City attorney services related to the City's Home Loan program TOTAL CDBG/HOME FUND GAS TAX FUND Reallocate a portion of the funding source for the Capistrano Villas I, II, and Ill Pavement Rehabilitation Project (CIP 18101) due to lower than expected Fiscal Year 2016-17 Measure M Turnback revenues TOTAL GAS TAX FUND CCFP FUND Developer contribution for San Juan Creek Road/I-S Underpass Improvements Project (CIP 7117) Reimbursement agreement with San Diego Gas & Electric approved by City Council on 10.17.17 for Del Obispo Street Widening Project (CIP 16102) Funding Assistance Agreement with Rancho Mission Viejo, LLC for the unfunded Ortega Highway Widening Capital Project (CIP 14107) TOTAl CCFP FUND EASTERN OPEN SPACE FUND Reimbursement from City's insurance carrier for Coastkeeper litigation and other vendor costs paid through June 2017 Revenue Expenditure Adjustment Adjustment (10,000) 1,512 54,000 6,000 3,000 (5,000) 7,000 {8,488) 65,000 160,000 21,000 2,000 -183,000 4,600 -4,600 303,000 45,000 45,000 55,985 348,000 100,985 83,550 ATTACHMENT 5-Page 1 of 4 City of San Juan Capistrano FY 2017/18 PROPOSED BUDGET ADJUSTMENTS Desaiption Additional funding for Coastkeeper litigation based on actual costs paid from July through November 2017 (offset by reimbursement from City's insurance carrier) TOTAL EASTERN OPEN SPACE FUND MEASURE M TURN BACK FUND Reallocate a portion of the funding source for the Capistrano Villas I, II, and Ill Pavement Rehabilitation Project (CIP 18101) due to lower than expected Fiscal Year 2016-17 Measure M Turnback revenues TOTAL MEASURE M TURNBACK FUND LOCAL LAW ENFORCEMENT GRANTS FUND Increase transfer to the City's General Fund due to actual Fiscal Year 2016-17 revenue collected exceeding last year's budget TOTAL LAW ENFORCEMENT GRANTS FUND PARK AND OPEN SPACE GRANTS FUND Outstanding reimbursement from OCTA for costs incurred in prior fiscal year for CIP No. 11203 Outstanding reimbursement from OCTA for costs incurred in prior fiscal year for CIP No. 11204 TOTAl PARKS AND OPEN SPACE GRANT FUND STREETS AND HIGHWAYS GRANTS FUND Outstanding reimbursement from OCTA for costs incurred in prior fiscal year for CIP No. 16102 Outstanding reimbursement from OCTA for costs incurred in prior fiscal year for Summer Trolley program TOTAl STREETS AND HIGHWAYS GRANTS FUND OTHER GRANTS FUND Outstanding reimbursement from OCTA for costs incurred in prior fiscal year for CIP No . 13103 TOTAl OTHER GRANTS fUND WATER OPERATIONS FUND Increase imported water costs due to decreasing annual GWRP production estimate from 3,456 acre feet to 2,384 acre feet Reallocation of Utilities Department staff charges based on reassigned duties Revise Finance Department's personnel budget to Fiscal Year 2017-18 Adopted Budget status (vacant Customer Service Representative position from Y-rated at Step 3) TOTAL WATER OPERATIONS FUND Revenue Expenditure Adj~stment Adjustment 182,000 182,000 265,550 182,000 (4,600) -{4,600) 1,512 . 1,512 73,130 36,655 109,785 . 77,263 26 ,850 104,113 . 38,148 38,148 - 1,164,000 (33,000) (2,000) -1,129,000 ATTACHMENT 5-Page 2 of 4 City of San Juan Capistrano FY 2011/18 PROPOSED BUDGET ADJUSTMENTS Description GWRP OPERATIONS FUND Reduction of MWDOC grant and chemicals budget due to decreasing annual GWRP production estimate from 3,456 acre feet to 2,384 acre feet Purchase of Train B membranes for GWRP plant that was originally budgeted, but not spent in Fiscal Year 2016-17 Reallocation of Utilities Department staff charges based on reassigned duties !TOTAL GWRP OPERATIONS FUND WATER CAPITAL REPLACEMENT FUND Change funding source for Well Facility Equipment Replacement Program because the wells involved in the current project do not include wells in the City's non-potable water distribution system. This adjustment includes reimbursing the Non-Potable Water Capital Improvement Fund for Fiscal Year 2016-17 costs that should have been funded from the Water Capital Replacement Fund. Return project savings to available fund balance for the completed San Juan Hills Waterline Replacement Project (CIP 10803) TOTAL WATER CAPITAL REPlACEMENT FUND NON -P OTABLE WATER CAPITAl IMPROVEMENT FUND Change funding source for Well Facility Equipment Replacement Program because the wells involved in the current project do not include wells in the City's non-potable water distribution system. This adjustment includes reimbursing the Non-Potable Water Capital Improvement Fund for Fiscal Year 2016-17 costs that should have been funded from the Water Capital Replacement Fund. TOTAL NON-POTABt£ WATER CAPITAL IMPROVEMENT FUND NON -POTAB LE WATER OPERATIONS FUND Reallocation of Utilities Department staff charges based on reassigned duties Impact of reducing imported recycled water purchases as a result of increased local non- potable water production Increased electricity costs due to increased local non-potable water production TOTAL NON-POTABLE WATER OPERATIONS FUND SEWER OPERATIONS FUND Revise City's share of operations and maintenance contributions to SOCWA based on SOCWA's Fiscal Year 2017-18 Budget (which was adopted after the City's Fiscal Year 2017-18 Mid-Term Update) Reallocation of Utilities Department staff charges based on reassigned duties !TOTAL SEWER OPERATIONS FUND Revenue Expenditure Adjusti'J'Ient Adjustment (268,000) (90,000) 210,000 44,000 (268,000) 164,000 45,450 (1,915) -43,535 22,000 (23,450) 22,000 (23,450) (3,000) (116,000) 13,000 . (106,000) (559,000) (3,000) -(562,000) ATTACHMENT 5-Page 3 of 4 City of San Juan Capistrano FY 2017/18 PROPOSED BUDGET ADJUSTMENTS Description HOUSING AUTHORITY ADMINISTRATION FUND Legal services based on actual costs incurred through November TOTAL HOUSING AUTHORITY A'DMINISTRATION FUND GRA'ND TOTAL -All FUNDS Revenue Expenditure Adjustment Adjustment 2,000 -2,000 $ 611,108 $ 1,179,582 ATTACHMENT 5-Page 4 of 4 CITY OF SAN JUAN CAPISTRANO FY 2017/18 REVENUE ADJUSTMENT SUMMARY JULY 1, 2017 THROUGH SEPTEMBER 30, 2017 Previously Approved Coundl Actlons Fund Ill Fund 1-GENERAL FUND $ 114,000 Fund 2-PARKING MAINTENANCE FUND - Fund 4-SACRA/HOUSING AUTHORITY ADMINISTRATION FUND - Fund 5-FORFEITED C&D BONDS FUND - Fund 6-ROAD MAINTENANCE AND REHABILITATION ACCOUNT (RMRA) 208,000 Fund 10-SYSTEMS DEVELOPMENT FUND - Fund 11-PARK/RECREATION DEVELOPER FEES FUND - Fund 12-DRAINAGE FUND - Fund 13-AG PRESERVATION FEES FUND - Fund 14-LANDSCAPE MAINTENANCE DISTRICTS FUND - Fund 15-FARM OPERATIONS FUND - Fund 16-CDBG/HOME FUND - Fund 17-GAS TAX FUND (208 ,000) Fund 18-CCFP FUND - Fund 19-EASTERN OPEN SPACE FUND - Fund 30-S.O.N.G.S. FUND 11,000 Fund 31-AQMD/AB2766 FUND - Fund 32-MEASURE M FUND - Fund 33-HOUSING IN-LIEU FEE FUND - Fund 34-LAW ENFORCEMENT GRANTS FUND - Fund 36-PARK REC AND OS PROJECT GRANTS FUND - Fund 37-HWY, STREET, AND ROAD PROJECT GRANTS FUND 69,000 Fund 38-OTHER GRANTS FUND - Fund 40-DEBT SERVICE FUND - Fund 50-CAPITAL PROJECTS FUND - Fund 51-OPEN SPACE ACQ/CONSTRUCTION FUND - Fund 52-COMMUNITY FACILITIES DISTRICT BONDS FUND - Fund 53-SUCCESSOR AGENCY NON-HOUSING BONDS FUND - Fund 60-WATER ENTERPRISE-OPERATIONS FUND - Fund 61-WATER ENTERPRISE-DEBT SERVICE FUND - Fund 62-WATER ENTERPRISE-GWRP FUND - Fund 63-WATER ENTERPRISE-REPLACEMENT FUND - Fund 64-WATER ENTERPRISE-CIP FUND - Fund 65-WATER ENTERPRISE-NON-POTABLE CIP FUND - Fund 66-WATER ENTERPRISE-NON-POTABLE OPERATIONS FUND - Fund 68-SJCPFA - Fund 70-SEWER ENTERPRISE OPERATIONS FUND - Fund 71-SEWER REPLACEMENT CIP FUND - Fund 72-SEWER IMPROVEMENT CIP FUND - Fund 80-INSURANCE/BENEFITS FUND - Fund 81-FACILITIES OPERATIONS FUND - Fund 21-SJCHA HOUSING ADMINISTRATION FUND - Fund 22-SJCHA UTILE HOLLYWOOD RENTAL HOUSING FUND - Fund 23-SJCHA SUCCESSOR AGENCY HOUSING BONDS FUND - Totals $ 194,000 (1)-Includes all adjustments approved through City Council action through December 5, 2017 . Flrst Quarter Proposed Flrst Total Quarter Adjustments by Adjustments Fund $ (8,488) $ 105,512 -- -- -- -208 ,000 -- - - -- -- -- -- -- -(208,000) 348,000 348,000 265,550 265,550 -11,000 -- -- -- -- 109,785 109,785 104,113 173,113 38,148 38,148 - - -- -- -- -- -- -- (268,000) (268,000) -- -- 22,000 22,000 -- -- -- -- - - - - -- -- -- -- $ 6U,l08 $ 805,108 ATTACHMENT 6 City of San Juan Capistrano FY 2017/18 EXPENDITURE ADJUSTMENT SUMMARY JULY 1, 2017 THROUGH SEPTEMBER 30, 2017 Previously Approved Council Actions Fund (1 1 Fund 1-GENERAL FUND $ 955,878 Fund 2-PARKING MAINTENANCE FUND - Fund 4-SACRA/SJCHA ADMINISTRATION FUND 1,000 Fund 5-FORFEITED C&D BONDS FUND - Fund 6-ROAD MAINTENANCE AND REHABILITATION ACCOUNT {RMRA) 208,000 Fund 10-SYSTEMS DEVELOPMENT FUND {610) Fund 11-PARK/RECREATION DEVELOPER FEES FUND - Fund 12-DRAINAGE FUND - Fund 13-AG PRESERVATION FEES FUND - Fund 14-LANDSCAPE MAINTENANCE DISTRICTS FUND - Fund 15-FARM OPERATIONS FUND - Fund 16-CDBG/HOME FUND 1,000 Fund 17-GAS TAX FUND {208,000) Fund 18-CCFP FUND 547,000 Fund 19-EASTERN OPEN SPACE FUND 48,525 Fund 30-S.O.N.G.S. FUND 11,000 Fund 31-AQMD/AB2766 FUND 40,000 Fund 32-MEASURE M FUND 436,277 Fund 33-HOUSING IN-LIEU FEE FUND - Fund 34-LAW ENFORCEMENT GRANTS FUND - Fund 36-PARK REC AND OS PROJECT GRANTS FUND - Fund 37-HWY, STREET, AND ROAD PROJECT GRANTS FUND 69,000 Fund 38-OTHER GRANTS FUND - Fund 40-DEBT SERVICE FUND - Fund 50-CAPITAL PROJECTS FUND - Fund 51-OPEN SPACE ACQ/CONSTRUCTION FUND - Fund 52-COMMUNITY FACILITIES DISTRICT BONDS FUND - Fund 53-SUCCESSOR AGENCY NON-HOUSING BONDS FUND - Fund 60-WATER ENTERPRISE-OPERATIONS FUND 458,000 Fund 61-WATER ENTERPRISE-DEBT SERVICE FUND - Fund 62-WATER ENTERPRISE-GWRP FUND - Fund 63-WATER ENTERPRISE-REPLACEMENT FUND - Fund 64-WATER ENTERPRISE-CIP FUND 150,000 Fund 65-WATER ENTERPRISE-NON-POTABLE CIP FUND - Fund 66-WATER ENTERPRISE-NON-POTABLE OPERATIONS FUND - Fund 68-SJCPFA - Fund 70-SEWER ENTERPRISE OPERATIONS FUND 10,000 Fund 71-SEWER REPLACEMENT CIP FUND - Fund 72-SEWER IMPROVEMENT CIP FUND - Fund 80-INSURANCE/BENEFITS FUND - Fund 81-FACILITIES OPERATIONS FUND 168,000 Fund 21-SJCHA HOUSING ADMINISTRATION FUND - Fund 22-SJCHA UTILE HOLLYWOOD RENTAL HOUSING FUND 6,405 Fund 23-SJCHA SUCCESSOR AGENCY HOUSING BONDS FUND 1,000,000 Totals $ 3,901,475 First Quarter Proposed Arst Total Q~arter Adjustments by Adjustments Fund $ 65,000 $ 1,020,878 - - -1,000 -- -208,000 -{610) -- -- -- -- -- 183,000 184,000 4 ,600 {203,400) 100,985 647,985 182,000 230,525 -11,000 -40,000 {4,600) 431,677 -- 1,512 1,512 -- -69,000 -- -- -- -- -- -- 1,129,000 1,587,000 -- 164,000 164,000 43,535 43,535 -150,000 {23,450) {23,450) {106,000) {106,000) -- {562,000) {552,000) -- -- -- -168,000 2,000 2,000 -6,405 -1,000,000 $ 1,179,582 $ 5,081,057 ATTACHMENT 7 City of San Juan Capistrano FY 2017/18 ADMINISTRATIVE BUDGET TRANSFERS 111 JULY 1, 2017 THROUGH SEPTEMBER 30, 2017 Description Fund First Quarter !Jullll, 2017 through Seetember ~0, 2017} Utilize Customer Service Supervisor position salary savings to fund temporary staffing Water Operations Fund services Additional funding for parking permits for neighborhood parking permit program General Fund Additional funding for MWDOC's actual Readiness to Serve Charge exceeding the City's Water Operations Fund budget Additional funding for crossing guard services contract General Fund Funding for well equipment rental for the water filtration system at the Northwest Open Water Operations Fund Space Well Utilize Community Services Department salary savings to fund temporary staffing services General Fund Additional funding for janitorial services contract (Golden Touch Cleaning) General Fund+ Facilities Operations Fund Additional funding for housing consulting services (MDM & Associates) Little Hollywood Rental Housing Fund To consolidate the City Clerk Department's budget for public hearings and legal notice General Fund publishing Reduce postage funding for Hometown Happenings to fund additional commissary costs General Fund incurred for the City's 4th of July event Additional funding needed for professional meetings General Fund Transfer overtime budget funds from the Community Services Department to the Utilities General Fund Department to fund staff overtime for 4th of July event Fiscal Year 2016-17 Capital Improvement Program (CIP) Budget Carryovers Multiple Funding bookshelves for CFO's office General Fund Funding annuaiiCMA dues for Assistant City Manager General Fund Increase Fiscal Year 2017-18 S.O.N.G.S . program budget (including reimbursement from S.O.N .G.S. Fund Southern California Edison) by annual CPI of 2.1% Additional funding for Northwest Open Space Well repairs Water Operations Fund Reduce postage funding for Hometown Happenings to fund additional costs incurred for General Fund printing costs for the Hometown Happenings newsletter and commissary supplies for the San Juan Summer Nites special event Additional funding needed for Annual Statement of Diversion project (Stetson Engineers) Water Operations Fund Funding for annual dues for California City Management Foundation General Fund Funding for new office chair for Public Works Senior Civil Engineer General Fund Transfer budget from "improvements" to "building repairs" Little Hollywood Rental Housing Fund TOTAL ADMINISTRATIVE BUDGET CHANGES APPROVED DURING QUARTER Net Change Amount to Budget $ 15,385 $ . 1,470 . 6,955 780 . 950 - 2,940 - 850 6,405 2,500 290 so - 2,520 2,520 16,448,370 16,448,370 450 - 1,285 - 4,065 4,065 200 - 1,300 - 360 - 400 - 325 - 16,000 - $ 16,513,850 $ 16,454,955 111 This schedule displays budget transfers between the operating accounts of a fund that are approved administratively. These budget transfers did not change the total amount appropriated by City Council for any fund. The CIP budget carryover amount represents the carryover of CIP funding appropriated by City Council for Fiscal Year 2016-17 that was unexpended as of the end of Fiscal Year 2016-17 . ATTACHMENT 8 FUNDING ASSISTANCE AGREEMENT This FUNDING ASSISTANCE AGREEMENT ("Agreement") is entered into as of this 15 day of c:c__r-, 2013 (the "Effective Date"), by and between the CITY OF SAN JUAN CAPISTRANO, a California municipal corporation ("City"), and RANCHO MISSION VIEJO, LLC, a Delaware limited liability company ("RMV"). City and RMV are collectively referred to herein as the "Parties" and individually as a "Party". RECITALS A RMV is the authorized agent and manager of the owners ("Owners") of certain real property located easterly of the boundaries of City. B. Owners obtained approvals in November 2004 from the Orange County Board of Supervisors to develop their property, including a General Plan Amendment and zoning approval for the Rancho Mission Viejo Planned Community (the "Ranch Plan"). The first phase of development (g., PlaiUling Area 1) of the Ranch Plan, which will provide approximately 1,236 residential dwelling units and some retail uses, is currently underway. C. In conjunction with the foregoing approvals, Owners entered into a development agreement with the County of Orange ("Development Agreement") whereby Owners committed to assist in the provision of certain transportation improvements, including but not limited to the widening of certain portions of State Route 74 ("Ortega Highway"), through implementation of the South County Roadway Improvement Program ('SCRIP"), adopted by the County of Orange in November 2004. D. That portion of the Ortega Highway widening project between the eastern boundary of City and 2,000 feet east of the intersection with Antonio Parkway/La Pata A venue (the "County Portion") has already been constructed. Caltrans is now administering the reconstruction of the interchange at Ortega Highway and Interstate 5. E. City now desires to complete the widening of Ortega Highway between Interstate 5 and the eastern boundary of City (the "City Portion") and is charged with managing the design of this widening pursuant to a funding application approval that the City has obtained from the Orange County Transportation Authority (OCTA). In furtherance of it responsibilities, City has or will contract with HDR to perform the actual design work because of HDR's experience and background. F. City has requested Owners to assist in providing additional funds in the amount of $450,000 to support City's design work and Owners are desirous of facilitating the contribution of these funds. Prior funding by owners in performance of work to facilitate design with the County and City between 2005 and 2007 was approximately $2,700,000. These amounts inclusive of time value of funding, exceeds Owners' obligation for this portion of the Ortega Highway widening under the Development Agreement (see Exhibit D, Item #21, also referred to as "SCRIP Obligation #21", which otherwise would not be required to be satisfied until issuance of the building permit for the 5,000th equivalent dwelling unit of the Ranch Plan). ATTACHMENT 9 - 1 of 13 1 G. The Development Agreement stipulates that RMV is entitled to certain credits against its funding obligations to the extent that funding is received from other sources including, without limitation, funding through CFDs or similar funding mechanisms (Development Agreement, Exhibit D, Section 1 .C). In addition, the SCRIP provides that developers are eligible to receive credits for (i) monies advanced before SCRIP payments are due, and (ii) for SCRIP improvements that they are required to construct under development agreements or project conditions of approval (SCRIP, Section V.l3). In return tor its assistance pursuant to this Agreement. RMV desires to receive the credits described above ("SCRIP Credits'') as allowed under the Development Agreement and SCRIP: H. In order to utilize certain of the desired funding sources, RMV will contract directly with HDR, which contract will be supplemental to the design contract between City and HDR. I. City and RMV (on behalf of Owners) desire to enter into this Agreement to memorialize the terms and conditions of City's and Owners' respective commitments for design ofthe City Portion, and to acknowledge the SCRlP credits to be provided Owners hereunder. AGREEMENT Based upon the foregoing Recitals, wholly incorporated herein by reference, and for good and valuable consideration, the receipt and sufficiency of which is hereby acknowledged by both parties, City and RMV hereby abrree as follows: 1. Design Contracts. (a) CHy Design ontract with HDR. City shall enter into a contract with HDR for the design of the City Portion (the "City Contract"). The City Contract shall be the primary contract for the City Portion design work. (b) RMV Supplemental De ign Contract with HDR. RMV also shall enter into a contract with HDR (the "RMV Contract"), which shall be supplemental to the City Contract. The Parties shall work cooperatively to identify which elements of the design work shall be pertom1ed pursuant to the City Contract and which elements shall be provided pursuant to the RMV Contract. The abrrced upon elements to be included in the RMV Contract shall be deemed ''Approved Reimbursement Services". (c) Commitments of the Parties; Funding Sources. City and RMV shall each be responsible for payments to HDR solely for the design services pcrfonned by HDR under their respective contracts. City acknowledges that RMV's contribution is to be funded by County of Orange Community Facilities District No. 2004-1 (the CFD"), and RMV shall be entitled to receive reimbursement for the funds it provides to HDR for Approved Reimbursement Services from the CFD. Reimbursement shall be in accordance with Section 2 below. ATTACHMENT 9 -2 of 13 2 -------~------ (d) Changes to Sc >pe of Design Work; financial Limits. The scope of design work to be covered by the RMV Contract shall be clearly identified in that contract. RMV's total commitment for payments under the RMV Contract, including any change. to that scope pursuant to an approved change order, shall in no event be greater than Four Hundred Fifty Thousand Dollar.· ($450,000.00). 2. Payment s to HDR. (a) Payments by l:tMV. RMV shall make payments directly to HDR for the Approved Reimbursement Services that HDR perfom1s pursuant to the RMV Contract, using the process described in subsection (d) below, Follmving hs payments to HDR, RMV shall request reimbursement from the CFD in the amount of said payments, in accordance with the process set forth in Section 3 below. (b) RMV lnt · rfacc with CFD. RMV shall take the lead in coordinating with the CFD with regard to reimbursement funds to be received by it from the CFD, as administered by the County of Orange. (c) City Administration of Other funds. City shall be solely responsible for any payments due to HDR under the City Contract, using any funds available to it, including funds from the Orange County Transportation Authority ("OCTA") and/or other available funds. (d) Payment Process. RMV's payments to HDR shall be in accordance with the following process, which shall be incorporated as part of the RMV Contract: (1) HDR will submit to RMV monthly invoices for services performed during the month preceding. Detailed supporting information will be provided by HDR within seven (7) working days of each invoice, which will contain an itemized breakdoVv11 of the Approved Reimbursement Services pertormed, copies of change orders, and other relevant documentation necessary to support the invoiced amounts. (2) RMV will pay to HDR the amount of each invoice it approves within forty ( 40) working days after receipt of all detailed supporting inf01mation/documentation. Payment will be made by check to HDR at the address set forth in the RMV Contract. (3) ln the event that RMV disputes any invoice, it will notify HDR in writing within fifteen (15) working days of receipt of all detailed supporting information/documentation. Upon receipt of a notice of dispute, HDR will have seven (7) working days to appeal RMV's detemlination. In the event of an appeal, RMV shall have fifteen (15) working days to review the appeal and issue a final detennination concerning the request for payment. If the appeal IS resolved in favor of HDR, RMV will immediately make any payment that is due. (e) RJP Cred it s. The Parties acknowledge that the funding assistance to be provided by Rl\.1V pursuant to this Agreement will satisfy 0Vvners' responsibility for SCRIP Obligation #21 (i.e., widening of Ortega Highway in the City Portion). Notwithstanding any other provision of the Development Agreement or SCRlP, neither RMV nor 0\.\-ners or any ATTACHMENT 9 -3 of 13 3 affiliated entities shall have any further funding obligation for the City Portion. The Parties further acknowledge that RMV's performance hereunder shall qualify Owners to receive the associated SCRIP Credits as allo\ved under the Development Agreement and SCRIP. The value of SCRIP Obligation #21, and the associated SCRIP Fee Credits, are set forth in the table attached hereto as Exhibit A. Upon completion of payment for services performed by HDR as described in Section I of this Agreement, City Engineer shall issue written acknowledgement to RMV for obtaining SCRIP Credit for this item. lbe Parties acknowledge that the City does not have the power to make the final decision regarding whether or not Owners shall receive the requested SCRIP Credit, as that decision shall be made by the County of Orange. 3. Reimbursements to RMV. Following tender of payment by RMV to HDR for the Approved Reimbursement Services perfonned under the RMV Contract, RMV may prepare and submit to the CFD a request for reimbursement. Each such request shall be in accordance with the established procedures (i&., those set forth under the JCFA and/or AFDA). 4. Property Acce and Coordination. RMV shall cooperate with the City for providing access to construction to occur within the City. This would include connecting to utilities and slope improvements that arc outside of Cal trans right of way. City shall cooperate in good faith to pursue and obtain available grant funding for implementation of the Project, including utilization of City NEXUS funds and OCTA, County, State, and/or federal funds . 5. Term of Agreement. This Agreement will commence on the Effective Date and shall continue in full force and effect until the receipt of all payments and reimbursements contemplated hereunder on or before July 1, 2015; provided, however, all indemnification prov1sions shall remain in effect until terminated or modified in v..Titing by mutual agreement of the Parties. 6. Indemnification. Neither RMV, nor Owners, nor any officer, member, director, employee or atTiliate thereof (collectively, the ''RMV lndemnitees") shall be responsible for any damage or liability occurring by reason of anything done or omitted to be done by City or its contractors under or in connection with any work, authority or jurisdiction delegated to or performed by City or its contractors under this Agreement. It is also understood and agreed that City shall fully indemnify, defend with counsel approved in writing by the RMV Indemnitees, and hold the RMV Indemnitees harmless from any liability imposed for injury, as defined in Government Code Section 810.8, including attorneys fees and costs, occurring by reason of anything done or omitted to be done by City or its contractors under or in connection with any work, authority or jurisdiction delegated to or perfonned by City or its contractors under this Agreement. 7. Notices. All notices, requests and demands hereunder must be in writing to be effective. All notices required to be given hereunder or by operation of law in connection with the performance or enforcement hereof shall be deemed given upon delivery if delivered personally (which includes noticed delivered by messenger or overnight courier) or, if delivered by mail, shall be deemed given three days after being deposited by certified mail in any duly authorized United States mail depository, postage prepaid. All such notices shall be addressed as follows, or to such other address or addresses as the Parties may from time to time specify in writing: ATTACHMENT 9 -4 of 13 4 ToRMV: To City: 8. Miscellaneous. Rancho Mission Viejo 2881 1 Ortega Highway San Juan Capistrano, California 92675 Attention: JeffThompson Telephone No.: (949) 240-3363 Fax No.: (949) 248-1763 City of San Juan Capistrano Public Works Department 32450 Paseo Adelanto San Juan Capistrano, California 92675 Attention: Keith VanDer Maaten, Public Works and Utilities Director Telephone No.: (949) 443-6363 fax No.: (949) 493-3955 (a) Entire Agreement. Waivers, and Amendm nts. This Agreement constitutes the entire understanding and agreement of the parties with respect to the subject matter set fotth herein and supersedes all previous negotiations, discussions. and agreements between the parties With respect to all or the subject matter hereof. All waivers of the provisions of this Agreement must be in writing and signed by the appropriate authorities ofthe party to be charged. A waiver of the breach of the covenants, conditions or obligations under this Agreement by any party shall not be construed as a waiver of any succeeding breach of the same or other covenants, conditions or obligations of this Agreement. Any amendment or modification to this Agreement must be in writing and executed by the appropriate authorities of City and RMV . (b) Successors and A5 igns. This Agreement shall be binding upon the parties and shall inure to all successors in interest of City and to all successors in interest and assigns of RMV. (c) Attomevs' Fees and osts. If either party to this Agreement commences an action against the other pa1ty to this Agreement arising out of or in connection with this Agreement, the prevailing party shall be entitled to recover reasonable attorneys' fees, expert fees, costs of investigation, and costs of suit from the losing party. (d) Interpretation; Governjng Law. This Agreement shall be construed according to its fair meaning and as if prepared by both of the parties hereto. This Agreement shall be construed in accordance with the internal laws of the State of California without regard to conflict of law principles. (e) Severability. If any term, provision, covenant, or condition of this Agreement is held by a court of competent jurisdiction to be invalid, void, or unenforceable, the remainder of this Agreement shall not be affected thereby to the extent such remaining provisions are not rendered impractical to perform taking into consideration the purposes of this Agreement. ATTACHMENT 9 -5 of 13 5 (e) Severabi lity. If any term, provision, covenant, or condition of this Agreement is held by a court of competent jurisdiction to be invalid, void, or unenforceable, the remainder of this Agreement shall not be affected thereby to the extent such remaining provisions are not rendered impractical to perform taking into consideration the purposes of this Agreement. (f) Limitation on RMV's and Owners Liability. In no event shall any member, partner, officer, director, shareholder, employee or agent of RMV or an Owner be personally liable for any default or breach of this Agreement, or for any amount that may become due to City, or for any obligation under the terms of this Agreement. (g) Non-Liability of Officials and Employees of the ity. No official or employee of City shall be personally liable to RMV or Owners in the event of any default or breach by City, or for any amount that will become due to RMV or Owners, or any obligation under the tem1s of this Agreement. (h) Nu Third-Party Beneficiaries. This Agreement is made only for the benefit of the parties hereto; it is not intended that any rights under this Agreement shall accrue to any third person. (i) l ndependent 'ontractor. It is expressly understood and agreed by the Parties that nothing herein shall be deemed to create an agency, joint venture, or partnership between the Parties hereto, or between the Parties and any engineer, contractor or other professional retained by City or RMV relative to the design work. (j) Authority to Execute. The persons executing this Agreement warrant and represent that they have the authority to execute this Agreement and represent that they have the authority to bind the parties for which they are signing to the perfom1ance of the obligations hereunder. (k) Execution in ounteroart. This Agreement may be executed in several counterparts, and all so executed shall constitute one agreement binding on both parties hereto, notwithstanding that both parties arc not signatories to the original or the same counterpart. (SIGNATURES ON NEXT PAGE) ATTACHMENT 9 -6 of 13 6 rN WITNESS WHEREOF, City and RMV have entered into this Agreement as of the date set forth above. APPROVED AS TO FORM: ~gten , City M:rneY "CITY" 7 ATTACHMENT 9 -7 of 13 ''RMV" RANCHO MISSION VIEJO, LLC, a Delaware limited liability company By: By : roming Senior Vice President, Planning & Entitlement ATTACHMENT 9 -8 of 13 8 -------- Exhibit A VALUE OF SCRIP OBLIGATION#21; ASSOCIATED SCRIP FEE CREDITS Exhibit D (applicable portions thereof) of Ranch Plan Development Agreement dated November 8, 2004, establishing RMV's Fair Share contribution obligations for the South County Roadway Improvement Program (SCRIP) [See attached Table] ATTACHMENT 9 -9 of 13 1 ! h 'II I il IG It It .I{ Q 1.11 li j-: ~ .l>'t ~ : jl ., d 11 I . ·-·· -·-·-·--- J I ATTACHMENT 9 -10 of 13 2 •·. ATTACHMENT 9 -11 of 13 3 rl ~· 't f ~ ~ ~ Jii~ I . .M = Jt.~~ll, L u ::l j·i~f ~ ~h~~~ ! -- s ---- ATTACHMENT 9 -12 of 13 ---- tK,.aa:~-=~u-,.....,. ~~ A !l,\CCG'POtW ['~ fA. tuM O:.:>.!WI:Lb::&.::.~.!ll ..n.r~~=a~~dl.llrW~ '-~~''-" ·~-·-"""""'-",... ,,~rr.ll~!':l<\'1 "-1.-:r.w~r'..Q ~(Cl"'A OI .(J f )..t~~{1-.0)l .ol"~+.-.!ii1P·II~\Iw Ra4-l'laaht,mfbt.~ ~m!:v-.d.!. r,op-.U.ta.B.I:wi!<>fi~~ ~u~·~n:..: ~~ .,...,.'b.~~D:=om~ -"""'0.1''*'-~"'--... ~ .... ~ ~......,. u~-o.o~ot.,.,~;=, ~ruw,.,._ .• ~ ;~tt~:,rm:~too~ I:C~o;:~;~~~~ ThtE!R..q:J!IOil~~~~od.c~~ ... ~r;{~.d I~ ~,~~6~0C.COWN!;;U~::~a..,.~c! ~ .... ~or~-.tt.:.~f"~, ... ~tt!Eru:.~;w~~ ... ~~-m""" o~u-.~... · · r .. _ ... o '!n<!l ,.;-~(!~lalq:t:=.~;;=~~~~1d!O t(;.;i:,_, .. ,._,.. !,.:dnd~~..:11:t.c.s'..ftr l::rt~lct • .... ..,~·~I)(Q:ac::,: . ~i :SDJ\!:c~«i~'"t)~ ~ (,..~~~-~tr.'1IEI.$;u:r..-J41l!!e~':ftt .-rtokft'*~~ ~~· ''""'"'') ~"""' "-!!I<:!W~ -.. - -~-~-,.. .......... ~ . ..._~ .. -=-~i..~ .... ~~~~":':'"'....-O)U)<r;• ~.Iz.~ofDJDW40W't<!W.S~~Lft>~~~ ~"".J:LW.~l;wt.~C[U:!.illlaud~~A.,"C.Cif¥.~(f 111','><a u •,......._,d~<l --~-«<T ~:a~-·~.-~~fCV\~.i;£o...~~Mx:XItot"e ~.T.l.*O.L~~e.:~~~fTI!I:IR~i.a..~•~ ~~;:.;;~~:.-= .. ~~~!U -&. n..<or<-.... ..,.o=.c..:.sofb.r:....!. No=--..l~·.,~'r ~-Gti"'.I;O("J:II6/~ nc.~~ ........ ~~ ~,~u-:1~ ~ ~ "C-A'¥ rt..,lli• A,;::~ nbtl ~~ ... \c:!~orb;w~ IL"t&:.«:~ ll ttM~UO'ATJaNSYSIR.I.IWl<U\'l:l\lh.'reS"CO!<Tll ''"TOllS. .ACI:}'OWI.~-:1 It C6Vl."'l~ ':'5 A>~.lcn.llo<ec..ub:..t O'MI-. s -<, •h:$b."<~i> ~t,_-~g ,(I!..Qln'-.d-.a.m!.:t i.l 'kl:"~~'llZ::.~~ baa~c • ~co.."='":Y"•ti.utr~-t~cl.u.-~~. "'~&I( ~'ll~~fllDD~I/~oo -~~INIT;~"'I! • -·fO~'fokSb...F'!"""'>l>~b.....,...,..... ~~~~»ner~ ~~~tu::pu!U;-np,._."'"'"T"'~Kl.~~~~cf ~f«il.- ~ili::.tJ:~c:<~e.~.c.&ob.tc:u ~tM.~r .. 9-.ut.:o\ :oJ&~f~J: ....,.,..-~·"" 4•· • ~,.b(;C<:{~~~(i...<,.~Fa:Ui(~ac<:,;~ kol-Mil:~rr...,~~~~'Lci::U~;~!"C;uJI r-... ~.~~-~ ........... ~·Q'Ill'l-"!'Y .. ...,..· ··«#ioodo=«<~~~~="""""~~­t)(~C«.ay(c..f.~ t..;rdio:'<f~!l~ ftf.' !k %'%~~1:li!D,1:.fdn!p ATTACHMENT 9 -13 of 13 November 17,2017 Benjamin Siegel City Manager City of San Juan Capistrano 32400 Paseo Adelanto San Juan Capistrano, CA 92675 RE: Funding Assistance Agreement (dated October 15, 2013)- Reimbursement of Funds Previously Paid I Allocation to County Agreement Dear Mr. Siegel: The following letter is intended to memorialize our recent discussions regarding the refund of contributions by RMV under the Funding Assistance Agreement dated October 15,2103 and entered into by and between the City of San Juan Capistrano ("City") and Ranc ho M1sswn Vi eJo, LLC ("RMV' . As you will recall, the Funding Assistance Agreement established a commitment on the part ofRMV to provide funding to support the City in its design efforts relative to the widening of that portion of Ortega Highway between Interstate 5 and the eastern boundary of the City of San Juan Capistrano (the "City Portion"). Consistent with the terms of the Funding Assistance Agreement, RMV retained the services ofHDR to perform specific design work in relation to the City Portion -which work was to complement the City's own proposed services contract with HDR relative to the City Portion. In reliance on the Funding Assistance Agreement, RMV paid a total of$55,985 .50 to HDR to augment the City's design efforts for the City Portion. However, as you are aware, the City decided not to move forward with HDR (or any other design professional) in relation to the City Portion. Thus, the purposes and benefits to be accomplished pursuant to the Funding Assistance Agreement -i.e., the development of integrated plans for the City Portion -were never achieved. As a consequence of the City's decision, RMV was compelled to evaluate other programs and partnerships concerning the widening of the City Portion . Presently, RMV is working with the County of Orange ("County") concerning a new plan for the City ATTACHMENT 10-Page 1 of 2 28811 ORTEGA HIGHWAY • P.O . BOX 9 • SAN JUAN CAPISTRANO, CA 92693 • (949) 240-3363 • FAX (949) 248-1763 Funding Assistance Agreem ent-Reimbursement Page2 Portion to provide similar funding to the County and their collaboration with Caltrans and OCT A. In relevant part, RMV will provide certain funds to the County to facilitate analysis and design work relative to the widening of the City Portion. Accordingly, RMV and the City have agreed to formally terminate their relationship under the Funding Assistance Agreement subject to the following conditions: • The City shall reimburse RMV for the sums previously expended by RMV in reliance upon the Funding Assistance Agreement (i.e., $55,985.50) (the "Reimbursement Amount"). The Reimbursement Amount will be paid to the County as a credit against RMV's funding commitments for the City Portion. The City shall tender the Reimbursement Amount to the County not later than February 15, 2018 • RMV shall not seek reimbursement to be paid directly from the City to RMV for any additional amounts under the Funding Assistance Agreement. • RMV has not sought, and will not seek, reimbursements for the Reimbursement Amount from any community facilities district. If the foregoing accurately reflects our conversations and agreement relative to the relmborscmem and terlllinatiou of tit· Funding Ass istance Ag•ecment , please execute md return to RMV the enclosed copy of this letter on or before January 31, 2018. Sincerely, Rancho Mis ··o n Viejo, LLC ~f . son Vice-President-Development Engineering AGREED TO AND ACCEPTED this __ day of ________ . 2018. City of San Juan Capistrano Benjamin Siegel City Manager Cc: Richard Broming, Dan Kelly, Elise Millington, Robin Martindale/PBMB ATTACHMENT 10-Page 2 of 2