Loading...
2022-06-22 Item 08Y FY 21-22 Third Quarter Budget Status ReportMEETING DATE: June 22, 2022 PREPARED BY: Tom Gallup, Assistant Director of Finance Kelly Sanderson, Finance Manager DEPT. DIRECTOR: Teresa S. McBroome DEPARTMENT: Finance CITY MANAGER: Pamela Antil SUBJECT: Fiscal Year 2021-22 Third Quarter Budget Status Report and Proposed Budget Amendments RECOMMENDED ACTION: Staff recommends that City Council takes the following actions: 1. Receive and file the Fiscal Year 2021-22 Third Quarter Budget Status Report; and 2. Adopt Resolution No. 2022-81 titled “A Resolution of the City Council of the City of Encinitas Amending the Fiscal Year 2021-22 Budget” (Attachment 1). STRATEGIC PLAN: This item falls within the Financially Sound Decision-Making operating principle of the Strategic Plan by achieving long-term fiscal sustainability. FISCAL CONSIDERATIONS: The Finance Department has completed the third quarter review of FY 2021-22, which includes recommendations for operating budget appropriations and budget transfers for City Council consideration. Proposed third quarter budget amendments for all funds will: Increase estimated revenues by $60,890 primarily due to increased gas tax revenue. Increase budgeted expenditures by $2.8 million in the General Fund, Debt Service Fund, Encinitas Lighting and Landscape District Fund and Self Insurance Fund. The impact of all proposed General Fund amendments will: Increase the expenditure budget by $1 million for direct COVID costs ($1.0 million is allocated to General Fund expenditures and $100,000 is a transfer out to the Self Insurance Fund). 2022-06-22 Item #08Y Page 1 of 41  Increase capital transfers out from the General Fund by $6.5 million to the Facility Improvements Fund for Pacific View Improvements (CF20D). Council appropriated $0.5 million for design and construction support on April 20, 2022. The remaining $6.5 million capital budget appropriation is included in the FY 2022-23 capital budget approved June 15, 2022. Attachment 2 provides detailed descriptions of these proposed operating budget and transfer amendments. A summary of Council actions and available fund balance is included as Attachment 3. BACKGROUND: On June 23, 2021, the City Council adopted Resolution 2021-70, approving the FY 2021-22 Operating Budget and the Capital Improvement Program (CIP) with appropriations. On December 15, 2021, the City Council received the Report on the Financial Results for Fiscal Year 2020-21. The FY 2021-22 ending fund balance in the General Fund totaled $27,163,284. After deducting $909,819 of fund balance that is non spendable, restricted, or assigned for other purposes, the unassigned fund balance is $26,253,465. Per City Council policy, $15,297,366 from the unassigned fund balance is reserved for contingencies (20 percent of FY 2021-22 adopted operating expenditures) and $1,700,925 is reserved for budget stabilization (two percent of FY 2021-22 projected revenues). The remaining unassigned fund balance of $9,255,174 was available for City Council appropriation at the beginning of FY 2021-22. Adoption of the FY 2021-22 operating budget reduced fund balance by approximately $1.5 million to $7,754,020 to fund priority capital projects. On February 23, 2022, the City Council adopted mid-year operating budget amendments that increased the available balance in the General Fund by $1,231,590. All approved amendments since February 23, 2022, have resulted in an overall fiscal year-to- date increase in fund balance in the General Fund of $8.4 million, primarily from ARPA funding. These previously approved budget amendments are listed in Attachment 3. At the Budget Workshop held April 13, 2022, Council directed staff to program $1.1 million in the General Fund and Self Insurance Fund for direct COVID costs and $7 million to the Pacific View Improvements project. ANALYSIS: The purpose of this report is to provide a quarterly update on the current fiscal year operating budget and provide recommendations for additional budget amendments and budget transfers. After nine months of FY 2021-22, actual revenues are expected to exceed estimates by year- end, while budgeted expenditures are anticipated to be less than budget. Schedule C (Attachment 4) presents a summary of budget versus actuals for General Fund operating revenues, expenditures and transfers. 2022-06-22 Item #08Y Page 2 of 41 General Fund Revenues Table 1 below provides General Fund revenue totals by adopted budget, amended budget, year-to-date (YTD) actual and third quarter revised projections. Table 1 General Fund revenues totaled $59.9 million, which is approximately 55 percent of current fiscal year estimates. Receipts from the second installment of property taxes due in April and the second distribution of taxes in lieu of vehicle license fees (estimated at $4.3 million) are not received and recorded until the fourth quarter of the fiscal year. Revenue from this source is expected to exceed the original projection at year-end, as delinquencies have been lower than anticipated. Revenue from sales tax remains strong as sales of fuel, general consumer goods and autos have exceeded expectations and sales activity in the restaurant and hotel category remains high. Receipts from Transient Occupancy Tax (TOT) collected from hotels and short-term vacation rentals are strong this fiscal year following the opening of the new Alila Marea hotel and the recovery of the hospitality industry following the lifting of pandemic related restrictions. Like property and sales tax, a significant portion of revenue from franchise fees is received in the fourth quarter. The category is at 63% of the fiscal year projection. Fines issued for vehicles and parking citations are typically higher in the fourth quarter as vehicle activity increases in commercial areas of the city during the spring and early summer months. Proceeds from the I-Bank loan were budgeted in the Other Revenue category. The remaining revenue categories are meeting or exceeding budget projections. Staff is not proposing any General Fund budget amendments to revenues. Description Adopted Budget 2021-22 Amended Budget 2021-22 Third Quarter YTD Actual 2021-22 Percent Realized 2021-22 Proposed Budget Amendments Budget with Proposed Amendments 2021-22 Property Tax 54,246,604$ 54,246,604$ 33,735,499$ 62.2%54,246,604$ Documentary Transfer Tax 600,000 600,000 633,186 105.5%600,000 Sales Tax 14,385,055 16,105,055 10,275,208 63.8%16,105,055 Transient Occupancy Tax 3,271,895 3,271,895 2,919,156 89.2%3,271,895 Franchise Fees 2,329,049 2,329,049 1,472,348 63.2%2,329,049 Licenses, Fees and Permits 236,000 236,000 216,948 91.9%236,000 Intergovernmental Revenue 703,346 703,346 519,091 73.8%703,346 Charges for Services 7,198,118 9,074,379 7,777,533 85.7%9,074,379 Fines and Penalties 435,253 435,253 237,821 54.6%435,253 Use of Money and Property 984,154 984,154 841,700 85.5%984,154 Other Revenue 656,793 21,080,393 929,323 4.4%21,080,393 Revenue Total 85,046,267$ 109,066,128$ 59,557,813$ 54.6%-$ 109,066,128$ General Fund Revenue Summary (March 31, 2022) Note: Some column totals may not sum due to rounding. 2022-06-22 Item #08Y Page 3 of 41 General Fund revenues are up by 17.4 percent, or approximately $8.8 million from the FY 2020- 21 third quarter total of approximately $50.7 million, as shown in Table 2 below. Table 2 The largest dollar variances through the first nine months of FY 2021-22 were in the Property Tax, Sales Tax, TOT and Charges for Services categories. Revenues from sales tax and TOT increased considerably from the prior fiscal year as COVID-19 related restrictions were relaxed and consumer spending and hotel bookings increased, along with the opening of the Alila Marea hotel. Similarly, revenues from recreation fees increased as programs that were cancelled in the prior fiscal year resumed this past summer and fall. Additionally, revenues collected from development related fees increased due to the adoption of a new fee schedule in October and an increase in activity. General Fund Expenditures Third quarter General Fund expenditures total approximately $50.8 million or 64.8 percent of the budget, as shown in Table 3 below. Table 3 At third quarter, expenditures in the personnel category are projected to be within budget at fiscal year-end. The materials and supplies category is under budget mostly due to lower than anticipated expenditures during the first nine months, as a number of significant purchases are made in the fourth quarter, including: Description Third Quarter YTD Actual 2020-21 Third Quarter YTD Actual 2021-22 $ Variance % Variance Property Tax 31,838,692$ 33,735,499$ 1,896,806$ 6.0% Documentary Transfer Tax 686,367 633,186 (53,181)-7.7% Sales Tax 8,757,771 10,275,208 1,517,438 17.3% Transient Occupancy Tax 1,266,930 2,919,156 1,652,226 130.4% Franchise Fees 1,164,848 1,472,348 307,500 26.4% Licenses, Fees and Permits 203,153 216,948 13,795 6.8% Intergovernmental Revenue 450,555 519,091 68,536 15.2% Charges for Services 4,405,625 7,777,533 3,371,908 76.5% Fines and Penalties 162,919 237,821 74,902 46.0% Use of Money and Property 809,545 841,700 32,155 4.0% Other Revenue 980,614 929,323 (51,291)-5.2% Revenue Total 50,727,019$ 59,557,813$ 8,830,794$ 17.4% General Fund Revenue Summary (March 31, 2022) Note: Some column totals may not sum due to rounding. Description Adopted Budget 2021-22 Amended Budget 2021-22 Third Quarter YTD Actual 2021-22 Percent Realized 2021-22 Proposed Budget Amendments Budget with Proposed Amendments 2021-22 Personnel 38,839,924$ 39,688,924$ 29,937,948$ 75.4%39,688,924$ Materials & Supplies 1,460,141 1,487,026 840,873 56.5%1,487,026 Contracts & Services 35,584,640 36,556,075 19,640,963 53.7%36,556,075 Internal Cost Allocation 411,718 411,718 308,788 75.0%411,718 Capital Outlay 63,380 63,380 25,163 39.7%63,380 Debt/Finance 127,026 127,026 2,768 2.2%127,026 Other - - - - 1,000,000 1,000,000 Expenditure Total 76,486,829$ 78,334,149$ 50,756,502$ 64.8%1,000,000$ 79,334,149$ Note: Some column totals may not sum due to rounding. General Fund Expenditure Summary by Category (March 31, 2022) 2022-06-22 Item #08Y Page 4 of 41  Firefighting equipment, uniforms and personal protective equipment.  Marine safety equipment purchases in anticipation of the start of the summer season, including lifeguard uniforms.  Street maintenance and repair supplies made when weather conditions are better for repairs.  Park maintenance supplies. The City anticipates savings at year-end for the following:  Postage, due to fewer public notices this fiscal year and greater use of electronic correspondence.  Community Center furniture and repair and maintenance supplies.  Information Technology (IT) hardware and software purchases $94,356 budget amendment related to San Elijo JPA managed services expenditures was approved on May 25, 2022, freeing up funds in the contract and services category Year-to-date actuals through the third quarter in the contracts and services category are under the revised budget for the current fiscal year mostly due to the following reasons:  Approximately $455,000 in administrative fees assessed by the County of San Diego for property tax collection that are scheduled to be paid in the fourth quarter of the fiscal year.  Lower than anticipated expenditures for urban forestry maintenance services, park maintenance and water utilities, and street maintenance which all tend to be higher in the fourth quarter.  Lower than anticipated expenditures for planning consulting, plan review and engineering inspection services.  Reduced costs for IT software licenses. At the Budget Workshop held April 13, 2022, Council directed staff to program $1.1 million from for direct COVID costs. Staff is proposing amendments totaling $1.0 million for General Fund expenditures along with a $100,000 transfer out to the Self Insurance Fund (601) for expenditures related to the City’s response to the pandemic. General Fund expenditures (excluding transfers) through the first nine months of FY 2021-22 are approximately $3.6 million higher than the same period in FY 2020-21, as shown in Table 4 below: Table 4 Expenditures in the personnel category are $1.3 million higher than last fiscal year and reflected budgeted increases in the City’s annual payment to CalPERS for its unfunded pension liability; Description Third Quarter YTD Actual 2020-21 Third Quarter YTD Actual 2021-22 $ Variance % Variance Personnel 28,626,545$ 29,937,948$ 1,311,403$ 4.6% Materials & Supplies 593,060 840,873 247,813 41.8% Contracts & Services 17,512,562 19,640,963 2,128,401 12.2% Internal Cost Allocation 308,788 308,788 - 0.0% Capital Outlay 156,838 25,163 (131,676) 0.0% Debt/Finance - 2,768 2,768 0.0% Expenditure Total 47,197,793$ 50,756,502$ 3,558,708$ 7.5% General Fund YTD Expenditures - Variance by Category (Through March 31, 2022) Note: Some column totals may not sum due to rounding. 2022-06-22 Item #08Y Page 5 of 41 approved salary increases identified in the executed Memorandum of Understanding (MOUs) with the Service Employees International Union (SEIU) and in a separate resolution for unrepresented employees; additional positions approved with the FY 2021-22 budget; and expenditures for Other Post-Employment Benefits (OPEB). Although year-to-date personnel expenditures are higher than last fiscal year, this category is expected to be under budget for the current fiscal year. Expenditures for materials and supplies are slightly higher as recreation programs resumed after being cancelled in the prior fiscal year due to the COVID-19 pandemic. The Contracts and Services category is $2.1 million higher through the first nine months of the fiscal year than during the same period last fiscal year. The variance is the result of budgeted contract increases for law enforcement services, information technology, recreation programs (which were cancelled the prior fiscal year), park and street maintenance, legal services, engineering inspections and planning services. General Fund Transfers Transfers involve moving budgeted appropriations between funds, including the capital project funds. Total actual transfer amounts through March 31, 2022, are shown in Table 5 below: Table 5 Staff is proposing increasing capital transfers out from the General Fund by $6.5 million to the Facility Improvements Fund 403 for improvements to the Pacific View site and increasing operating transfers out to the Self Insurance Fund (601) for direct COVID expenses. Capital Improvement Program (CIP) and Work Projects Financial Status Update (Attachment 5) There were 122 active projects, with project-to-date expenditures totaling $105.3 million as of March 31, 2022. Financial information for each project is provided in Attachment 5. The status of priority projects can be found on the City’s website at: https://encinitasca.gov/Government/City-Projects. The following completed projects can be closed:  Leucadia Flooding Issues (dry well) project (CD17A), $7,859 to CS22F (CS04D sub- project)  Morning Sun Drive Sidewalk Improvement project (CS19B), $110,692 to CS04D  South Coast Highway 101 Safety and Mobility project (CS20E), $618 to General Fund  Stormwater Capture and Reuse Study (WD17A), $44,446 to CS22F (CS04D sub- project)  Vulcan and San Elijo Avenue ATP Study (WC17B), $89,721 to CS04D Staff is recommending that $253,336 in unspent funds be transferred from completed projects to the North Coast Highway 101 Leucadia Streetscape project (CS04D). Description Adopted Budget 2020-21 Amended Budget 2020-21 Third Quarter YTD Actual 2020-21 Percent Realized 2020-21 Proposed Budget Amendments Revised Projections 2020-21 Transfers In 22,925,117$ 3,182,786$ 1,103,874$ 34.7%142,645$ 3,325,431$ Transfers Out (32,985,709) (34,068,318) (11,990,991) 35.2%6,610,017 (27,458,301) Transfers Total (10,060,592)$ (30,885,532)$ (10,887,117)$ 35.2%6,752,662$ (24,132,870)$ General Fund Transfers Summary (March 31, 2022) 2022-06-22 Item #08Y Page 6 of 41 Detailed explanations for each proposed budget amendment (arranged by Fund, Account and Project) are included in Attachment 2. Proposed Budget Amendments (Attachment 2) Detailed explanations for each proposed budget amendment are included in Attachment 2. Staff is requesting that Council ratify the following administrative budget adjustments made for Building Inspection Services and Recreation Programs during the fiscal year that resulted in a net zero fiscal impact. Table 6 below provides a summary of all the proposed operating budget amendments by fund, with additional detail provided in Attachment 2: Table 6 Proposed Amendments to Transfers between Funds (Attachment 2) In addition to the operating budget appropriations, staff is proposing budget transfer amendments summarized below in Table 8 and detailed in Attachment 2: Table 7 ENVIRONMENTAL CONSIDERATIONS: The action being considered by the City Council is exempt from the California Environmental Quality Act (CEQA) because it is not a “project” under Section 15378(b)(5) of CEQA Guidelines. Description Revenue Increase (Decrease) Expenditure Increase (Decrease) Fund Balance Increase (Decrease) General Fund (101)-$ 1,000,000$ (1,000,000)$ Gas Tax Fund (201)51,223 - 51,223 Community Development Block Grant Fund (222)9,667 9,667 - Encinitas Lighting and Landscape District (295)- 87,000 (87,000) Encinitas Ranch Lighting and Landscape District Fund (297)- 6,100 (6,100) Debt Service Funds (301/302)- 850,231 - Capital Improvement Funds (401/402/403)- 47,808 (47,808) Self Insurance Fund (601)- 750,000 (750,000) Operating Budget Amendment Total 60,890$ 2,750,806$ (1,839,685)$ Note: Some column totals may not sum due to rounding. Third Quarter Operating Budget Amendment Summary - All Funds Fund Transfer In Increase (Decrease) Transfer Out Increase (Decrease) General Fund (101)142,645$ 6,610,017$ Gas Tax Fund (201)- 51,223 Coastal Zone Management Fund (212)- 526 Restricted Donations & Contributions Fund (229)(12,407) 5,067 Debt Service Funds (301/302)850,231 - Capital Improvements Fund (401)185,916 - Capital Improvements Fund (402)5,067 142,645 Facilities Maintenance Fund (403)6,475,850 - Self Insurance Fund (601)- - Fund Transfer Amendments Total 7,647,302$ 6,809,478$ Note: Some column totals may not sum due to rounding. Third Quarter Fund Transfer Amendments - All Funds 2022-06-22 Item #08Y Page 7 of 41 The action involves an organizational or administrative activity of government that will not result in the direct or indirect physical change in the environment. ATTACHMENTS: 1. Resolution No. 2022-81 titled “A Resolution of the City Council of the City of Encinitas Amending the Fiscal Year 2021-22 Budget” 2. FY 2021-22 Proposed Budget Amendments and Transfers 3. FY 2021-22 Summary of Budgetary Fund Balance 4. Schedule C: Detail of General Fund Revenues, Expenditures and Transfers 5. FY 2021-22 YTD Capital Improvement Program Financial Report 2022-06-22 Item #08Y Page 8 of 41 RESOLUTION NO. 2022-81 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF ENCINITAS AMENDING THE FISCAL YEAR 2021-22 BUDGET WHEREAS, on June 23, 2021, the City Council of the City of Encinitas adopted Resolution Number 2021-70 adopting the budget for Fiscal Year 2021-22; and WHEREAS, changes in anticipated revenues and/or expenditures of the City of Encinitas necessitates amendments to the appropriations for Fiscal Year 2021-22; and WHEREAS, budgeted expenditures do not exceed anticipated revenue and available fund balance; and WHEREAS, the City Council has reviewed the proposed Fiscal Year 2021-22 budget amendments. NOW, THEREFORE, BE IT RESOLVED by the City Council of the City of Encinitas that the budget amendments for Fiscal Year 2021-22 as contained in Exhibit A to this resolution are hereby adopted. PASSED, APPROVED AND ADOPTED this 22nd day of June, 2022 by the City Council of the City of Encinitas, State of California. ____________________________ Catherine S. Blakespear, Mayor ATTEST: ______________________________ Kathy Hollywood, City Clerk APPROVED AS TO FORM: _____________________________ Tarquin Preziosi, City Attorney 2022-06-22 Item #08Y Page 9 of 41 CERTIFICATION: I, Kathy Hollywood, City Clerk of the City of Encinitas, California, do hereby certify under penalty of perjury that the foregoing Resolution was duly adopted at a regular meeting of the City Council on the 22nd day of June, 2022 by the following vote: AYES: NOES: ABSENT: ABSTAIN: _____________________________ Kathy Hollywood, City Clerk 2022-06-22 Item #08Y Page 10 of 41 FY 21-22 Proposed CIP Budget and Fund Transfer Amendments ATTACHMENT 1 RESOLUTION NO. 2022 -81 - EXHIBIT A LINE PROJECT NUMBER ORG OBJECT ACCT TYPE REVENUE (R)/ EXPENDITURE (E) COMMENT INCREASE (I)/ DECREASE (D) AMOUNT ADD'L DESC 7 CD20A 40295101 590 E CP20D:CD20A 402101 close tr I 0 8 CP20A 40295101 590 E CP20D:CD20A 402101 close tr D 0 10 CP20A 40295101 590 E CP20A close Park Pedestals D 529 Notice of Completion recorded 8/25/2021. Project closure submitted 9/2/2021. 11 10190999 498.2 E CF20D 101:403 capital transfer I 6,475,850 12 40300000 398.2 R CF20D 101:403 capital transfer I 6,475,850 14 22200000 331.1 R FY21 Fair Housing carryover I 9,667 Carryforward amount from FY21 that needs to be spent in FY22 for Fair Housing Services provided by contract with Legal Aid Society. 15 22251470 494.1 E FY21 Fair Housing carryover I 9,667 Carryforward amount from FY21 that needs to be spent in FY22 for Fair Housing Services provided by contract with Legal Aid Society. 16 29571630 441.1 E Electricity rate increases I 87,000 17 29771630 441.1 E Electricity rate increases I 6,100 18 COV22 10190901 493 E //COV22 reimb 101 obj?I 1,000,000 Placeholder for budget to track Covid-related reclassifications. 19 COV22 60120340 462 E //COV22 reimb 601 obj?I 100,000 This will need a cash transfer if allocating funds to Risk. 20 CP21A 40295229 540 E CP21A Contract 72 I 5,067 Senior Center Courtyard adjustment to pay invoice received after project completion; matches unexpended amount on Contract 72. 21 22990999 498.2 E CP21A PSCDO 229:402 transfer I 5,067 Adjustment to pay invoice received after project completion; matches unexpended amount on Contract 72. 22 40200000 398.2 R CP21A PSCDO 229:402 transfer I 5,067 Adjustment to pay invoice received after project completion; matches unexpended amount on Contract 72. 23 60120340 486.1 E Claims - Liability I 400,000 24 60120340 486.4 E Claims - Workers Comp I 150,000 25 60120340 431.21 E Legal Contracts I 100,000 26 30100000 398.4 R IBank Loan transfer from 101 I 850,231 Transfer-out of General Fund was included in FY22 original budget. Needs related transfer-in to debt service fund. 27 30191966 488.2 E IBank Loan cost of issuance I 300,000 Loan expected to close in FY22. Assumes loan origination fee $200K, estimates $100K for other costs like preliminary title and appraisal. 28 20100000 332.3 R CS22A SB1 revised revenue est I 51,223 29 20190999 498.2 E CS22A 201:401 SB1 revised rev I 51,223 30 40100000 398.2 R CS22A 201:401 SB1 revised rev I 51,223 31 CS19B 40195101 590 E CS19B:CS04D 401101 close tr D 110,692 Project was completed in February 2021. Balance will be transferred to Leucadia Streetscape Project. 32 CS04D 40195101 590 E CS19B:CS04D 401101 close tr I 110,692 Transfers General Fund budget from closed CS19B Morning Sun Drive Sidewalk to CS04D Leucadia Streetscape. 33 CS20E 40295101 590 E CS20E 402101 close return D 618 South Coast Highway 101 Safety and Mobility project was completed in September 2020. Returning available budget to General Fund. 34 40290999 498.2 E CS20E 402101 close return I 618 South Coast Highway 101 Safety and Mobility project was completed in September 2020. Returning available budget to General Fund. 35 10100000 398.2 R CS20E 402101 close return I 618 South Coast Highway 101 Safety and Mobility project was completed in September 2020. Returning available budget to General Fund. 36 WC17B 40295101 592 E WC17B:CS04D 402101 close tr D 70,000 Close project WC17B Vulcan and San Elijo ATP Study, then transfer available budget to CS04D Leucadia Streetscape. After this study was funded, striping occurred on portions of Vulcan/San Elijo to improve safety and mobility. If a study is needed at a later date, funding will be requested at that time. 37 WC17B 40295101 592 E WC17B:CS04D 402101 close tr D 19,721 Close project 402 WC17B Vulcan and San Elijo ATP Study, then transfer available budget to 401 CS04D Leucadia Streetscape. 2022-06-22 Item #08Y Page 11 of 41 FY 21-22 Proposed CIP Budget and Fund Transfer Amendments ATTACHMENT 1 RESOLUTION NO. 2022 -81 - EXHIBIT A 38 40290999 498.2 E WC17B:CS04D 402101 close tr I 89,721 Close project 402 WC17B Vulcan and San Elijo ATP Study, then transfer available budget to 401 CS04D Leucadia Streetscape. 39 10100000 398.2 R WC17B:CS04D 402101 close tr I 89,721 40 CS04D 40195101 590 E CS04D 101 tr from 402 WC17B I 89,721 Transfer available General Fund budget to 401 Leucadia Streetscape after closing 402 WC17B Vulcan and San Elijo ATP Study. 41 10190999 498.2 E CS04D 101 tr from 402 WC17B I 89,721 42 40100000 398.2 R CS04D 101 tr from 402 WC17B I 89,721 43 CP16A 40195212 590 E CP16A 212:401 drainage study I 526 Dune Restoration project (CP16A) increase needed to close out drainage study and concept design services funded by Coastal Zone Management Fund. 44 21290999 498.2 E CP16A 212:401 drainage study I 526 Dune Restoration project (CP16A) increase needed to close out drainage study and concept design services funded by Coastal Zone Management Fund. 45 40100000 398.2 R CP16A 212:401 drainage study I 526 Dune Restoration project (CP16A) increase needed to close out drainage study and concept design services funded by Coastal Zone Management Fund. 46 22990099 398.2 R Correct transfer from capital D 12,407 Administrative adjustment to correct budgeted transfer that was copied over from the prior fiscal year for funding from closed projects returned to the funding source. No transfer is needed this fiscal year. 47 CS22A 40195201 540 E CS22A 201:401 SB1 revised rev I 51,223 48 WD17A 40295101 590 E WD17A:CS22F 402101 close tr D 44,446 Close Stormwater Capture and Reuse Study in Fund 402, and transfer budget to CS22F B&C Restripe in Fund 401. Study was completed in FY 2017-18. It was originally anticipated that the balance would be used for a stormwater project if a grant became available. 49 40290999 498.2 E WD17A:CS22F 402101 close tr I 44,446 Close Stormwater Capture and Reuse Study in Fund 402, and transfer budget to CS22F B&C Restripe in Fund 401. Study was completed in FY 2017-18. It was originally anticipated that the balance would be used for a stormwater project if a grant became available. 50 10100000 398.2 R WD17A:CS22F 402101 close tr I 44,446 Close Stormwater Capture and Reuse Study in Fund 402, and transfer budget to CS22F B&C Restripe in Fund 401. Study was completed in FY 2017-18. It was originally anticipated that the balance would be used for a stormwater project if a grant became available. 51 CS22F 40195101 590 E CS22F 101 tr budget from WD17A I 44,445 Transfer budget to CS22F B&C Restripe in Fund 401 after closing WD17A Stormwater Capture and Reuse Study in Fund 402. 52 10190999 498.2 E CS22F 101 tr budget from WD17A I 44,446 Transfer budget to CS22F B&C Restripe in Fund 401 after closing WD17A Stormwater Capture and Reuse Study in Fund 402. 53 40100000 398.2 R CS22F 101 tr budget from WD17A I 44,446 54 CD17A 40295101 590 E CD17A:CS22F 402101 close tr D 7,860 Close 402 CD17A Leucadia Flooding and transfer funding to 401 CS22F Leucadia B&C Restripe Project. 5 dry wells were install in FY17 and 10 installed in FY19. Additional funds were used for the design of the Jason Street Storm Drain, which will be a new project if it moves forward. 55 40290999 498.2 E CD17A:CS22F 402101 close tr I 7,860 Close 402 CD17A Leucadia Flooding and transfer funding to 401 CS22F Leucadia B&C Restripe Project. 5 dry wells were install in FY17 and 10 installed in FY19. Additional funds were used for the design of the Jason Street Storm Drain, which will be a new project if it moves forward. 2022-06-22 Item #08Y Page 12 of 41 FY 21-22 Proposed CIP Budget and Fund Transfer Amendments ATTACHMENT 1 RESOLUTION NO. 2022 -81 - EXHIBIT A 56 10100000 398.2 R CD17A:CS22F 402101 close tr I 7,860 Close 402 CD17A Leucadia Flooding and transfer funding to 401 CS22F Leucadia B&C Restripe Project. 5 dry wells were install in FY17 and 10 installed in FY19. Additional funds were used for the design of the Jason Street Storm Drain, which will be a new project if it moves forward. 2022-06-22 Item #08Y Page 13 of 41 CITY OF ENCINITAS BUDGET AMENDMENTS JOURNAL ENTRY PROOF Report generated: 06/16/2022 17:30 User: Tgallup Program ID: bgamdent Page 1 LN ORG OBJECT PROJ ORG DESCRIPTION ACCOUNT DESCRIPTION PREV BUDGET AMENDED ACCOUNT LINE DESCRIPTION EFF DATE BUDGET CHANGE BUDGET ERR YEAR-PER JOURNAL EFF-DATE REF 1 REF 2 SRC JNL-DESC ENTITY AMEND 2022 12 120005 06/22/2022 120005 RESO22-081 BUA Q3 ADJ 1 3 7 40295101 590 CIP-GENERAL FUND CONTINGENCY 5,748,189.03 .06 5,748,189.09 402-95-101-590 -CIP-CP1-000-00000- CP20D:CD20A 402101 close tr 06/22/2022 8 40295101 590 CIP-GENERAL FUND CONTINGENCY 5,748,189.03 -.06 5,748,188.97 402-95-101-590 -CIP-CP1-000-00000- CP20D:CD20A 402101 close tr 06/22/2022 10 40295101 590 CIP-GENERAL FUND CONTINGENCY 5,748,189.03 -529.16 5,747,659.87 402-95-101-590 -CIP-CP1-000-00000- CP20A close and return 06/22/2022 11 10190999 498.2 OTHER FINANCING SOURCES (USES)TRANSFERS OUT - CAPITAL 25,276,221.00 6,475,850.00 31,752,071.00 101-90-999-498.2 -GG -GN1-000-00000- CF20D 101:403 capital transfer 06/22/2022 12 40300000 398.2 FACILITY CAPITAL MAINTENANCE TRANSFERS IN-CAPITAL -524,150.00 -6,475,850.00 -7,000,000.00 403-00-000-398.2 -CIP-CP1-000-00000- CF20D 101:403 capital transfer 06/22/2022 14 22200000 331.1 C.D.B.G GRANT FEDERAL OPERATING GRANTS -426,265.00 -9,667.00 -435,932.00 222-00-000-331.1 -000-SR2-000-00000- FY21 Fair Housing carryover 06/22/2022 15 22251470 494.1 DEV SVC-PLAN-CDBG PROGRAMS CONTRIBUTIONS - GENERAL 53,024.00 9,667.00 62,691.00 222-51-470-494.1 -DS -SR2-000-00000 FY21 Fair Housing carryover 06/22/2022 16 29571630 441.1 ELLD-STREETS UTILITIES-GAS AND ELECTRIC 388,300.00 87,000.00 475,300.00 295-71-630-441.1 -PW -SR4-000-00000- Electricity rate increases 06/22/2022 17 29771630 441.1 ENC RNCH LLD-STREETS UTILITIES-GAS AND ELECTRIC 11,300.00 6,100.00 17,400.00 297-71-630-441.1 -PW -SR4-000-00000- Electricity rate increases 06/22/2022 18 10190901 493 NON DEPT-SHARED EXPENSES ADJUSTMENTS .00 1,000,000.00 1,000,000.00 101-90-901-493 -GG -GN1-000-00000 COV22 direct COVID costs 06/22/2022 19 60120340 462 CITY MANAGER-RISK MANAGEMENT FIELD SUPPLIES .00 100,000.00 100,000.00 601-20-340-462 -GG -IS1-000-00000- COV22 direct COVID costs 06/22/2022 20 40295229 540 CIP-RESERVED DONATIONS/CONTRIBCONSTRUCTION -99,540.80 5,066.87 -94,473.93 402-95-229-540 -CIP-CP1-000-00000- CP21A Contract 72 06/22/2022 21 22990999 498.2 OTHER FINANCING SOURCES (USES)TRANSFERS OUT - CAPITAL .00 5,066.87 5,066.87 229-90-999-498.2 -ND -SR2-000-00000- CP21A PSCDO 229:402 transfer 06/22/2022 22 40200000 398.2 CAPITAL IMPROVEMENT PROJECTS TRANSFERS IN-CAPITAL -1,444,264.00 -5,066.87 -1,449,330.87 402-00-000-398.2 -CIP-CP1-000-00000- CP21A PSCDO 229:402 transfer 06/22/2022 23 60120340 486.1 CITY MANAGER-RISK MANAGEMENT CLAIMS EXP- LIABILITY 275,000.00 400,000.00 675,000.00 601-20-340-486.1 -GG -IS1-000-00000- Claims - Liability 06/22/2022 2022-06-22 Item #08Y Page 14 of 41 CITY OF ENCINITAS BUDGET AMENDMENTS JOURNAL ENTRY PROOF Report generated: 06/16/2022 17:30 User: Tgallup Program ID: bgamdent Page 2 LN ORG OBJECT PROJ ORG DESCRIPTION ACCOUNT DESCRIPTION PREV BUDGET AMENDED ACCOUNT LINE DESCRIPTION EFF DATE BUDGET CHANGE BUDGET YEAR-PER JOURNAL EFF-DATE REF 1 REF 2 SRC JNL-DESC ENTITY AMEND 2022 12 120005 06/22/2022 120005 RESO22-081 BUA Q3 ADJ 1 3 24 60120340 486.4 CITY MANAGER-RISK MANAGEMENT CLAIMS EXP - WORKERS COMP 650,000.00 150,000.00 800,000.00 601-20-340-486.4 -GG -IS1-000-00000- Claims - Workers Comp 06/22/2022 25 60120340 431.21 CITY MANAGER-RISK MANAGEMENT LEGAL CONTRACTS-CITY 375,000.00 100,000.00 475,000.00 601-20-340-431.21-GG -IS1-000-00000- Legal Contracts 06/22/2022 26 30100000 398.4 DEBT SERVICE FUND TRANSFERS IN-DEBT SERVICE -183,556.00 -850,231.00 -1,033,787.00 301-00-000-398.4 -000-DS1-000-00000- IBank Loan transfer from 101 06/22/2022 27 30191966 488.2 IBANK LOAN COST OF ISSUANCE .00 300,000.00 300,000.00 301-91-966-488.2 -ND -DS1-000-00000- IBank Loan cost of issuance 06/22/2022 28 20100000 332.3 STATE GASOLINE TAXES STATE RMRA FUNDS .00 -51,223.00 -51,223.00 201-00-000-332.3 -ND -SR1-000-00000 CS22A SB1 revised revenue est 06/22/2022 29 20190999 498.2 OTHER FINANCING SOURCES (USES)TRANSFERS OUT - CAPITAL 1,798,919.00 51,223.00 1,850,142.00 201-90-999-498.2 -ND -SR1-000-00000 CS22A 201:401 SB1 revised rev 06/22/2022 30 40100000 398.2 CAPITAL IMPROVEMENTS TRANSFERS IN-CAPITAL -177,933,569.72 -51,223.00-177,984,792.72 401-00-000-398.2 -000-CP1-000-00000- CS22A 201:401 SB1 revised rev 06/22/2022 31 40195101 590 GENERAL FUND CONTINGENCY 40,257,654.44 -110,691.90 40,146,962.54 401-95-101-590 -CIP-CP1-000-00000- CS19B:CS04D 401101 close tr 06/22/2022 32 40195101 590 GENERAL FUND CONTINGENCY 40,257,654.44 110,691.90 40,368,346.34 401-95-101-590 -CIP-CP1-000-00000- CS19B:CS04D 401101 close tr 06/22/2022 33 40295101 590 CIP-GENERAL FUND CONTINGENCY 5,748,189.03 -618.00 5,747,571.03 402-95-101-590 -CIP-CP1-000-00000- CS20E 402101 close return 06/22/2022 34 40290999 498.2 OTHER FINANCING SOURCES (USES)TRANSFERS OUT - CAPITAL 335,000.00 618.00 335,618.00 402-90-999-498.2 -ND -CP1-000-00000 CS20E 402101 close return 06/22/2022 35 10100000 398.2 GENERAL FUND TRANSFERS IN-CAPITAL -2,027,867.00 -618.00 -2,028,485.00 101-00-000-398.2 -000-GN1-000-00000- CS20E 402101 close return 06/22/2022 36 40295101 592 CIP-GENERAL FUND CONSULTANT STUDIES 87,525.23 -70,000.00 17,525.23 402-95-101-592 -CIP-CP1-000-00000- WC17B:CS04D 402101 close tr 06/22/2022 37 40295101 592 CIP-GENERAL FUND CONSULTANT STUDIES 87,525.23 -19,721.10 67,804.13 402-95-101-592 -CIP-CP1-000-00000- WC17B:CS04D 402101 close tr 06/22/2022 38 40290999 498.2 OTHER FINANCING SOURCES (USES)TRANSFERS OUT - CAPITAL 335,000.00 89,721.10 424,721.10 402-90-999-498.2 -ND -CP1-000-00000 WC17B:CS04D 402101 close tr 06/22/2022 2022-06-22 Item #08Y Page 15 of 41 CITY OF ENCINITAS BUDGET AMENDMENTS JOURNAL ENTRY PROOF Report generated: 06/16/2022 17:30 User: Tgallup Program ID: bgamdent Page 3 LN ORG OBJECT PROJ ORG DESCRIPTION ACCOUNT DESCRIPTION PREV BUDGET AMENDED ACCOUNT LINE DESCRIPTION EFF DATE BUDGET CHANGE BUDGET YEAR-PER JOURNAL EFF-DATE REF 1 REF 2 SRC JNL-DESC ENTITY AMEND 2022 12 120005 06/22/2022 120005 RESO22-081 BUA Q3 ADJ 1 3 39 10100000 398.2 GENERAL FUND TRANSFERS IN-CAPITAL -2,027,867.00 -89,721.10 -2,117,588.10 101-00-000-398.2 -000-GN1-000-00000- WC17B:CS04D 402101 close tr 06/22/2022 40 40195101 590 GENERAL FUND CONTINGENCY 40,257,654.44 89,721.10 40,347,375.54 401-95-101-590 -CIP-CP1-000-00000- CS04D 101 tr from 402 WC17B 06/22/2022 41 10190999 498.2 OTHER FINANCING SOURCES (USES)TRANSFERS OUT - CAPITAL 25,276,221.00 89,721.10 25,365,942.10 101-90-999-498.2 -GG -GN1-000-00000- CS04D 101 tr from 402 WC17B 06/22/2022 42 40100000 398.2 CAPITAL IMPROVEMENTS TRANSFERS IN-CAPITAL -177,933,569.72 -89,721.10-178,023,290.82 401-00-000-398.2 -000-CP1-000-00000- CS04D 101 tr from 402 WC17B 06/22/2022 43 40195212 590 COASTAL ZONE MANAGEMENT CONTINGENCY 1,578,462.20 526.43 1,578,988.63 401-95-212-590 -CIP-CP1-000-00000- CP16A 212:401 drainage study 06/22/2022 44 21290999 498.2 OTHER FINANCING SOURCES (USES)TRANSFERS OUT - CAPITAL 160,000.00 526.43 160,526.43 212-90-999-498.2 -ND -SR1-000-00000 CP16A 212:401 drainage study 06/22/2022 45 40100000 398.2 CAPITAL IMPROVEMENTS TRANSFERS IN-CAPITAL -177,933,569.72 -526.43-177,934,096.15 401-00-000-398.2 -000-CP1-000-00000- CP16A 212:401 drainage study 06/22/2022 46 22990099 398.2 CS02G TRANSFERS IN TRANSFERS IN-CAPITAL -12,407.00 12,407.00 .00 229-90-099-398.2 -ND -SR2-000-00000- Correct transfer from capital 06/22/2022 47 40195201 540 STATE GAS TAXES CONSTRUCTION 2,035,077.00 51,223.00 2,086,300.00 401-95-201-540 -CIP-CP1-000-00000- CS22A 201:401 SB1 revised rev 06/22/2022 48 40295101 590 CIP-GENERAL FUND CONTINGENCY 5,748,189.03 -44,445.75 5,703,743.28 402-95-101-590 -CIP-CP1-000-00000- WD17A:CS22F 402101 close tr 06/22/2022 49 40290999 498.2 OTHER FINANCING SOURCES (USES)TRANSFERS OUT - CAPITAL 335,000.00 44,445.75 379,445.75 402-90-999-498.2 -ND -CP1-000-00000 WD17A:CS22F 402101 close tr 06/22/2022 50 10100000 398.2 GENERAL FUND TRANSFERS IN-CAPITAL -2,027,867.00 -44,445.75 -2,072,312.75 101-00-000-398.2 -000-GN1-000-00000- WD17A:CS22F 402101 close tr 06/22/2022 51 40195101 590 GENERAL FUND CONTINGENCY 40,257,654.44 44,445.75 40,302,100.19 401-95-101-590 -CIP-CP1-000-00000- CS22F 101 tr budget from WD17A 06/22/2022 52 10190999 498.2 OTHER FINANCING SOURCES (USES)TRANSFERS OUT - CAPITAL 25,276,221.00 44,445.75 25,320,666.75 101-90-999-498.2 -GG -GN1-000-00000- CS22F 101 tr budget from WD17A 06/22/2022 53 40100000 398.2 CAPITAL IMPROVEMENTS TRANSFERS IN-CAPITAL -177,933,569.72 -44,445.75-177,978,015.47 401-00-000-398.2 -000-CP1-000-00000- CS22F 101 tr budget from WD17A 06/22/2022 2022-06-22 Item #08Y Page 16 of 41 CITY OF ENCINITAS BUDGET AMENDMENTS JOURNAL ENTRY PROOF Report generated: 06/16/2022 17:30 User: Tgallup Program ID: bgamdent Page 4 LN ORG OBJECT PROJ ORG DESCRIPTION ACCOUNT DESCRIPTION PREV BUDGET AMENDED ACCOUNT LINE DESCRIPTION EFF DATE BUDGET CHANGE BUDGET YEAR-PER JOURNAL EFF-DATE REF 1 REF 2 SRC JNL-DESC ENTITY AMEND 2022 12 120005 06/22/2022 120005 RESO22-081 BUA Q3 ADJ 1 3 54 40295101 590 CIP-GENERAL FUND CONTINGENCY 5,748,189.03 -7,859.81 5,740,329.22 402-95-101-590 -CIP-CP1-000-00000- CD17A:CS22F 402101 close tr 06/22/2022 55 40290999 498.2 OTHER FINANCING SOURCES (USES)TRANSFERS OUT - CAPITAL 335,000.00 7,859.81 342,859.81 402-90-999-498.2 -ND -CP1-000-00000 CD17A:CS22F 402101 close tr 06/22/2022 56 10100000 398.2 GENERAL FUND TRANSFERS IN-CAPITAL -2,027,867.00 -7,859.81 -2,035,726.81 101-00-000-398.2 -000-GN1-000-00000- CD17A:CS22F 402101 close tr 06/22/2022 57 40195101 590 GENERAL FUND CONTINGENCY 40,257,654.44 7,859.81 40,265,514.25 401-95-101-590 -CIP-CP1-000-00000- CS22F 101 tr from CD17A 06/22/2022 58 10190999 498.2 OTHER FINANCING SOURCES (USES)TRANSFERS OUT - CAPITAL 25,276,221.00 7,859.81 25,284,080.81 101-90-999-498.2 -GG -GN1-000-00000- CS22F 101 tr from CD17A 06/22/2022 59 40100000 398.2 CAPITAL IMPROVEMENTS TRANSFERS IN-CAPITAL -177,933,569.72 -7,859.81-177,941,429.53 401-00-000-398.2 -000-CP1-000-00000- CS22F 101 tr from CD17A 06/22/2022 60 10190999 498.1 OTHER FINANCING SOURCES (USES)TRANSFERS OUT - OPERATING 4,744,409.00 100,000.00 4,844,409.00 101-90-999-498.1 -GG -GN1-000-00000- COV22 101:601 operating tr 06/22/2022 61 60190999 398.1 OTHER FINANCING SOURCES (USES)TRANSFERS IN-OPERATING -2,547,793.00 -100,000.00 -2,647,793.00 601-90-999-398.1 -ND -IS1-000-00000 COV22 101:601 operating tr 06/22/2022 62 40290999 498.2 OTHER FINANCING SOURCES (USES)TRANSFERS OUT - CAPITAL 335,000.00 529.16 335,529.16 402-90-999-498.2 -ND -CP1-000-00000 CP20A 402:101 close return 06/22/2022 63 10100000 398.2 GENERAL FUND TRANSFERS IN-CAPITAL -2,027,867.00 -529.16 -2,028,396.16 101-00-000-398.2 -000-GN1-000-00000- CP20A 402:101 close return 06/22/2022 ** JOURNAL TOTAL 1,309,722.14 Z 2022-06-22 Item #08Y Page 17 of 41 CITY OF ENCINITAS BUDGET AMENDMENT JOURNAL ENTRY PROOF Report generated: 06/16/2022 17:30 User: Tgallup Program ID: bgamdent Page 5 CLERK: Tgallup YEAR PER JNL SRC ACCOUNT ACCOUNT DESC T OB DEBIT CREDIT EFF DATE JNL DESC REF 1 REF 2 REF 3 LINE DESC 2022 12 120005 BUA 40295101-590 CONTINGENCY 5 .06 06/22/2022 Q3 ADJ 120005 RESO22-081 T CP20D:CD20A 402101 close tr BUA 40295101-590 CONTINGENCY 5 .06 06/22/2022 Q3 ADJ 120005 RESO22-081 T CP20D:CD20A 402101 close tr BUA 40295101-590 CONTINGENCY 5 529.16 06/22/2022 Q3 ADJ 120005 RESO22-081 T CP20A close and return Park Pedestals Notice of Completion recorded 8/25/2021. Project closure submitted 9/2/2021. BUA 10190999-498.2 TRANSFERS OUT - CAPITAL 5 6,475,850.00 06/22/2022 Q3 ADJ 120005 RESO22-081 T CF20D 101:403 capital transfer BUA 40300000-398.2 TRANSFERS IN-CAPITAL 5 6,475,850.00 06/22/2022 Q3 ADJ 120005 RESO22-081 T CF20D 101:403 capital transfer BUA 22200000-331.1 FEDERAL OPERATING GRANTS 5 9,667.00 06/22/2022 Q3 ADJ 120005 RESO22-081 T FY21 Fair Housing carryover Carryforward amount from FY21 that needs to be spent in FY22 for Fair Housing Services provided by contract with Legal Aid Society. BUA 22251470-494.1 CONTRIBUTIONS - GENERAL 5 9,667.00 06/22/2022 Q3 ADJ 120005 RESO22-081 T FY21 Fair Housing carryover Carryforward amount from FY21 that needs to be spent in FY22 for Fair Housing Services provided by contract with Legal Aid Society. BUA 29571630-441.1 UTILITIES-GAS AND ELECTRIC 5 87,000.00 06/22/2022 Q3 ADJ 120005 RESO22-081 T Electricity rate increases BUA 29771630-441.1 UTILITIES-GAS AND ELECTRIC 5 6,100.00 06/22/2022 Q3 ADJ 120005 RESO22-081 T Electricity rate increases BUA 10190901-493 ADJUSTMENTS 5 1,000,000.00 06/22/2022 Q3 ADJ 120005 RESO22-081 T COV22 direct COVID costs At the Budget Workshop held April 13, 2022, Council directed staff to program $1.1 million from the General Fund for direct COVID costs. Staff is proposing amendments totaling $1.0 million for General Fund expenditures along with a $100,000 transfer out to the Self Insurance Fund (601) for expenditures related to the City’s response to the pandemic. BUA 60120340-462 FIELD SUPPLIES 5 100,000.00 06/22/2022 Q3 ADJ 120005 RESO22-081 T COV22 direct COVID costs At the Budget Workshop held April 13, 2022, Council directed staff to program $1.1 million from the General Fund for direct COVID costs. Staff is proposing amendments totaling $1.0 million for General Fund expenditures along with a $100,000 transfer out to the Self Insurance Fund (601) for expenditures related to the City’s response to the pandemic. BUA 40295229-540 CONSTRUCTION 5 5,066.87 06/22/2022 Q3 ADJ 120005 RESO22-081 T CP21A Contract 72 Senior Center Courtyard adjustment to pay invoice received after project completion; matches unexpended amount on Contract 72. BUA 22990999-498.2 TRANSFERS OUT - CAPITAL 5 5,066.87 06/22/2022 Q3 ADJ 120005 RESO22-081 T CP21A PSCDO 229:402 transfer Adjustment to pay invoice received after project completion; matches unexpended amount on Contract 72. BUA 40200000-398.2 TRANSFERS IN-CAPITAL 5 5,066.87 2022-06-22 Item #08Y Page 18 of 41 CITY OF ENCINITAS BUDGET AMENDMENT JOURNAL ENTRY PROOF Report generated: 06/16/2022 17:30 User: Tgallup Program ID: bgamdent Page 6 YEAR PER JNL SRC ACCOUNT ACCOUNT DESC T OB DEBIT CREDIT EFF DATE JNL DESC REF 1 REF 2 REF 3 LINE DESC 06/22/2022 Q3 ADJ 120005 RESO22-081 T CP21A PSCDO 229:402 transfer Adjustment to pay invoice received after project completion; matches unexpended amount on Contract 72. BUA 60120340-486.1 CLAIMS EXP- LIABILITY 5 400,000.00 06/22/2022 Q3 ADJ 120005 RESO22-081 T Claims - Liability BUA 60120340-486.4 CLAIMS EXP - WORKERS COMP 5 150,000.00 06/22/2022 Q3 ADJ 120005 RESO22-081 T Claims - Workers Comp BUA 60120340-431.21 LEGAL CONTRACTS-CITY 5 100,000.00 06/22/2022 Q3 ADJ 120005 RESO22-081 T Legal Contracts BUA 30100000-398.4 TRANSFERS IN-DEBT SERVICE 5 850,231.00 06/22/2022 Q3 ADJ 120005 RESO22-081 T IBank Loan transfer from 101 Transfer-out of General Fund was included in FY22 original budget. Needs related transfer-in to debt service fund. BUA 30191966-488.2 COST OF ISSUANCE 5 300,000.00 06/22/2022 Q3 ADJ 120005 RESO22-081 T IBank Loan cost of issuance Loan expected to close in FY22. Assumes loan origination fee $200K, estimates $100K for other costs like preliminary title and appraisal. BUA 20100000-332.3 STATE RMRA FUNDS 5 51,223.00 06/22/2022 Q3 ADJ 120005 RESO22-081 T CS22A SB1 revised revenue est BUA 20190999-498.2 TRANSFERS OUT - CAPITAL 5 51,223.00 06/22/2022 Q3 ADJ 120005 RESO22-081 T CS22A 201:401 SB1 revised rev BUA 40100000-398.2 TRANSFERS IN-CAPITAL 5 51,223.00 06/22/2022 Q3 ADJ 120005 RESO22-081 T CS22A 201:401 SB1 revised rev BUA 40195101-590 CONTINGENCY 5 110,691.90 06/22/2022 Q3 ADJ 120005 RESO22-081 T CS19B:CS04D 401101 close tr Project was completed in February 2021. Balance will be transferred to Leucadia Streetscape Project. BUA 40195101-590 CONTINGENCY 5 110,691.90 06/22/2022 Q3 ADJ 120005 RESO22-081 T CS19B:CS04D 401101 close tr Transfers General Fund budget from closed CS19B Morning Sun Drive Sidewalk to CS04D Leucadia Streetscape. BUA 40295101-590 CONTINGENCY 5 618.00 06/22/2022 Q3 ADJ 120005 RESO22-081 T CS20E 402101 close return South Coast Highway 101 Safety and Mobility project was completed in September 2020. Returning available budget to General Fund. BUA 40290999-498.2 TRANSFERS OUT - CAPITAL 5 618.00 06/22/2022 Q3 ADJ 120005 RESO22-081 T CS20E 402101 close return South Coast Highway 101 Safety and Mobility project was completed in September 2020. Returning available budget to General Fund. BUA 10100000-398.2 TRANSFERS IN-CAPITAL 5 618.00 06/22/2022 Q3 ADJ 120005 RESO22-081 T CS20E 402101 close return South Coast Highway 101 Safety and Mobility project was completed in September 2020. Returning available budget to General Fund. BUA 40295101-592 CONSULTANT STUDIES 5 70,000.00 06/22/2022 Q3 ADJ 120005 RESO22-081 T WC17B:CS04D 402101 close tr Close project WC17B Vulcan and San Elijo ATP Study, then transfer available budget to CS04D Leucadia Streetscape. After this study was funded, striping occurred on portions of Vulcan/San Elijo to improve safety and mobility. If a study is needed at a later date, funding will be requested at that time. 2022-06-22 Item #08Y Page 19 of 41 CITY OF ENCINITAS BUDGET AMENDMENT JOURNAL ENTRY PROOF Report generated: 06/16/2022 17:30 User: Tgallup Program ID: bgamdent Page 7 YEAR PER JNL SRC ACCOUNT ACCOUNT DESC T OB DEBIT CREDIT EFF DATE JNL DESC REF 1 REF 2 REF 3 LINE DESC BUA 40295101-592 CONSULTANT STUDIES 5 19,721.10 06/22/2022 Q3 ADJ 120005 RESO22-081 T WC17B:CS04D 402101 close tr Close project 402 WC17B Vulcan and San Elijo ATP Study, then transfer available budget to 401 CS04D Leucadia Streetscape. BUA 40290999-498.2 TRANSFERS OUT - CAPITAL 5 89,721.10 06/22/2022 Q3 ADJ 120005 RESO22-081 T WC17B:CS04D 402101 close tr Close project 402 WC17B Vulcan and San Elijo ATP Study, then transfer available budget to 401 CS04D Leucadia Streetscape. BUA 10100000-398.2 TRANSFERS IN-CAPITAL 5 89,721.10 06/22/2022 Q3 ADJ 120005 RESO22-081 T WC17B:CS04D 402101 close tr BUA 40195101-590 CONTINGENCY 5 89,721.10 06/22/2022 Q3 ADJ 120005 RESO22-081 T CS04D 101 tr from 402 WC17B Transfer available General Fund budget to 401 Leucadia Streetscape after closing 402 WC17B Vulcan and San Elijo ATP Study. BUA 10190999-498.2 TRANSFERS OUT - CAPITAL 5 89,721.10 06/22/2022 Q3 ADJ 120005 RESO22-081 T CS04D 101 tr from 402 WC17B BUA 40100000-398.2 TRANSFERS IN-CAPITAL 5 89,721.10 06/22/2022 Q3 ADJ 120005 RESO22-081 T CS04D 101 tr from 402 WC17B BUA 40195212-590 CONTINGENCY 5 526.43 06/22/2022 Q3 ADJ 120005 RESO22-081 T CP16A 212:401 drainage study Dune Restoration project (CP16A) increase needed to close out drainage study and concept design services funded by Coastal Zone Management Fund. BUA 21290999-498.2 TRANSFERS OUT - CAPITAL 5 526.43 06/22/2022 Q3 ADJ 120005 RESO22-081 T CP16A 212:401 drainage study Dune Restoration project (CP16A) increase needed to close out drainage study and concept design services funded by Coastal Zone Management Fund. BUA 40100000-398.2 TRANSFERS IN-CAPITAL 5 526.43 06/22/2022 Q3 ADJ 120005 RESO22-081 T CP16A 212:401 drainage study Dune Restoration project (CP16A) increase needed to close out drainage study and concept design services funded by Coastal Zone Management Fund. BUA 22990099-398.2-CS02G TRANSFERS IN-CAPITAL 5 12,407.00 06/22/2022 Q3 ADJ 120005 RESO22-081 T Correct transfer from capital Administrative adjustment to correct budgeted transfer that was copied over from the prior fiscal year for funding from closed projects returned to the funding source. No transfer is needed this fiscal year. BUA 40195201-540 CONSTRUCTION 5 51,223.00 06/22/2022 Q3 ADJ 120005 RESO22-081 T CS22A 201:401 SB1 revised rev BUA 40295101-590 CONTINGENCY 5 44,445.75 06/22/2022 Q3 ADJ 120005 RESO22-081 T WD17A:CS22F 402101 close tr Close Stormwater Capture and Reuse Study in Fund 402, and transfer budget to CS22F B&C Restripe in Fund 401. Study was completed in FY 2017-18. It was originally anticipated that the balance would be used for a stormwater project if a grant became available. BUA 40290999-498.2 TRANSFERS OUT - CAPITAL 5 44,445.75 06/22/2022 Q3 ADJ 120005 RESO22-081 T WD17A:CS22F 402101 close tr Close Stormwater Capture and Reuse Study in Fund 402, and transfer budget to CS22F B&C Restripe in Fund 401. Study was completed in FY 2017-18. It was originally anticipated that the balance would be used for a stormwater project if a grant became available. BUA 10100000-398.2 TRANSFERS IN-CAPITAL 5 44,445.75 06/22/2022 Q3 ADJ 120005 RESO22-081 T WD17A:CS22F 402101 close tr 2022-06-22 Item #08Y Page 20 of 41 CITY OF ENCINITAS BUDGET AMENDMENT JOURNAL ENTRY PROOF Report generated: 06/16/2022 17:30 User: Tgallup Program ID: bgamdent Page 8 YEAR PER JNL SRC ACCOUNT ACCOUNT DESC T OB DEBIT CREDIT EFF DATE JNL DESC REF 1 REF 2 REF 3 LINE DESC Close Stormwater Capture and Reuse Study in Fund 402, and transfer budget to CS22F B&C Restripe in Fund 401. Study was completed in FY 2017-18. It was originally anticipated that the balance would be used for a stormwater project if a grant became available. BUA 40195101-590 CONTINGENCY 5 44,445.75 06/22/2022 Q3 ADJ 120005 RESO22-081 T CS22F 101 tr budget from WD17A Transfer budget to CS22F B&C Restripe in Fund 401 after closing WD17A Stormwater Capture and Reuse Study in Fund 402. BUA 10190999-498.2 TRANSFERS OUT - CAPITAL 5 44,445.75 06/22/2022 Q3 ADJ 120005 RESO22-081 T CS22F 101 tr budget from WD17A Transfer budget to CS22F B&C Restripe in Fund 401 after closing WD17A Stormwater Capture and Reuse Study in Fund 402. BUA 40100000-398.2 TRANSFERS IN-CAPITAL 5 44,445.75 06/22/2022 Q3 ADJ 120005 RESO22-081 T CS22F 101 tr budget from WD17A BUA 40295101-590 CONTINGENCY 5 7,859.81 06/22/2022 Q3 ADJ 120005 RESO22-081 T CD17A:CS22F 402101 close tr Close 402 CD17A Leucadia Flooding and transfer funding to 401 CS22F Leucadia B&C Restripe Project. 5 dry wells were install in FY17 and 10 installed in FY19. Additional funds were used for the design of the Jason Street Storm Drain, which will be a new project if it moves forward. BUA 40290999-498.2 TRANSFERS OUT - CAPITAL 5 7,859.81 06/22/2022 Q3 ADJ 120005 RESO22-081 T CD17A:CS22F 402101 close tr Close 402 CD17A Leucadia Flooding and transfer funding to 401 CS22F Leucadia B&C Restripe Project. 5 dry wells were install in FY17 and 10 installed in FY19. Additional funds were used for the design of the Jason Street Storm Drain, which will be a new project if it moves forward. BUA 10100000-398.2 TRANSFERS IN-CAPITAL 5 7,859.81 06/22/2022 Q3 ADJ 120005 RESO22-081 T CD17A:CS22F 402101 close tr Close 402 CD17A Leucadia Flooding and transfer funding to 401 CS22F Leucadia B&C Restripe Project. 5 dry wells were install in FY17 and 10 installed in FY19. Additional funds were used for the design of the Jason Street Storm Drain, which will be a new project if it moves forward. BUA 40195101-590 CONTINGENCY 5 7,859.81 06/22/2022 Q3 ADJ 120005 RESO22-081 T CS22F 101 tr from CD17A BUA 10190999-498.2 TRANSFERS OUT - CAPITAL 5 7,859.81 06/22/2022 Q3 ADJ 120005 RESO22-081 T CS22F 101 tr from CD17A BUA 40100000-398.2 TRANSFERS IN-CAPITAL 5 7,859.81 06/22/2022 Q3 ADJ 120005 RESO22-081 T CS22F 101 tr from CD17A BUA 10190999-498.1 TRANSFERS OUT - OPERATING 5 100,000.00 06/22/2022 Q3 ADJ 120005 RESO22-081 T COV22 101:601 operating tr BUA 60190999-398.1 TRANSFERS IN-OPERATING 5 100,000.00 06/22/2022 Q3 ADJ 120005 RESO22-081 T COV22 101:601 operating tr BUA 40290999-498.2 TRANSFERS OUT - CAPITAL 5 529.16 06/22/2022 Q3 ADJ 120005 RESO22-081 T CP20A 402:101 close return BUA 10100000-398.2 TRANSFERS IN-CAPITAL 5 529.16 06/22/2022 Q3 ADJ 120005 RESO22-081 T CP20A 402:101 close return .00 .00 2022-06-22 Item #08Y Page 21 of 41 CITY OF ENCINITAS BUDGET AMENDMENT JOURNAL ENTRY PROOF Report generated: 06/16/2022 17:30 User: Tgallup Program ID: bgamdent Page 9 YEAR PER JNL SRC ACCOUNT ACCOUNT DESC T OB DEBIT CREDIT EFF DATE JNL DESC REF 1 REF 2 REF 3 LINE DESC BUA 10100000-290 APPROPRIATIONS 7,717,876.66 06/22/2022 Q3 ADJ 120005 RESO22-081 Close 402 CD17A Leucadia Flooding and transfer funding to 401 CS22F Leucadia B&C Restripe Project. 5 dry wells were install in FY17 and 10 installed in FY19. Additional funds were used for the design of the Jason Street Storm Drain, which will be a new project if it moves forward. BUA 20100000-290 APPROPRIATIONS 51,223.00 06/22/2022 Q3 ADJ 120005 RESO22-081 BUA 21200000-290 APPROPRIATIONS 526.43 06/22/2022 Q3 ADJ 120005 RESO22-081 BUA 22200000-290 APPROPRIATIONS 9,667.00 06/22/2022 Q3 ADJ 120005 RESO22-081 BUA 22900000-290 APPROPRIATIONS 5,066.87 06/22/2022 Q3 ADJ 120005 RESO22-081 BUA 29500000-290 APPROPRIATIONS 87,000.00 06/22/2022 Q3 ADJ 120005 RESO22-081 BUA 29700000-290 APPROPRIATIONS 6,100.00 06/22/2022 Q3 ADJ 120005 RESO22-081 BUA 30100000-290 APPROPRIATIONS 300,000.00 06/22/2022 Q3 ADJ 120005 RESO22-081 BUA 40100000-290 APPROPRIATIONS 193,776.09 06/22/2022 Q3 ADJ 120005 RESO22-081 BUA 40200000-290 APPROPRIATIONS 5,066.87 06/22/2022 Q3 ADJ 120005 RESO22-081 BUA 60100000-290 APPROPRIATIONS 750,000.00 06/22/2022 Q3 ADJ 120005 RESO22-081 BUA 10100000-291 ESTIMATED REVENUES 143,173.82 06/22/2022 Q3 ADJ 120005 RESO22-081 BUA 20100000-291 ESTIMATED REVENUES 51,223.00 06/22/2022 Q3 ADJ 120005 RESO22-081 BUA 22200000-291 ESTIMATED REVENUES 9,667.00 06/22/2022 Q3 ADJ 120005 RESO22-081 BUA 22900000-291 ESTIMATED REVENUES 12,407.00 06/22/2022 Q3 ADJ 120005 RESO22-081 BUA 30100000-291 ESTIMATED REVENUES 850,231.00 06/22/2022 Q3 ADJ 120005 RESO22-081 BUA 40100000-291 ESTIMATED REVENUES 193,776.09 06/22/2022 Q3 ADJ 120005 RESO22-081 BUA 40200000-291 ESTIMATED REVENUES 5,066.87 06/22/2022 Q3 ADJ 120005 RESO22-081 BUA 40300000-291 ESTIMATED REVENUES 6,475,850.00 06/22/2022 Q3 ADJ 120005 RESO22-081 BUA 60100000-291 ESTIMATED REVENUES 100,000.00 06/22/2022 Q3 ADJ 120005 RESO22-081 BUA 10100000-292 BUDGETARY FUND BAL-UNRESERVED 7,574,702.84 06/22/2022 Q3 ADJ 120005 RESO22-081 BUA 21200000-292 BUDGETARY FUND BAL-UNRESERVED 526.43 06/22/2022 Q3 ADJ 120005 RESO22-081 BUA 22900000-292 BUDGETARY FUND BAL-UNRESERVED 17,473.87 2022-06-22 Item #08Y Page 22 of 41 CITY OF ENCINITAS BUDGET AMENDMENT JOURNAL ENTRY PROOF Report generated: 06/16/2022 17:30 User: Tgallup Program ID: bgamdent Page 10 YEAR PER JNL SRC ACCOUNT ACCOUNT DESC T OB DEBIT CREDIT EFF DATE JNL DESC REF 1 REF 2 REF 3 LINE DESC 06/22/2022 Q3 ADJ 120005 RESO22-081 BUA 29500000-292 BUDGETARY FUND BAL-UNRESERVED 87,000.00 06/22/2022 Q3 ADJ 120005 RESO22-081 BUA 29700000-292 BUDGETARY FUND BAL-UNRESERVED 6,100.00 06/22/2022 Q3 ADJ 120005 RESO22-081 BUA 30100000-292 BUDGETARY FUND BAL-UNRESERVED 550,231.00 06/22/2022 Q3 ADJ 120005 RESO22-081 BUA 60100000-292 BUDGETARY FUND BAL-UNRESERVED 650,000.00 06/22/2022 Q3 ADJ 120005 RESO22-081 BUA 40300000-292 BUDGETARY FUND BAL-UNRESERVED 6,475,850.00 06/22/2022 Q3 ADJ 120005 RESO22-081 SYSTEM GENERATED ENTRIES TOTAL 16,164,790.92 16,164,790.92 JOURNAL 2022/12/120005 TOTAL 16,164,790.92 16,164,790.92 2022-06-22 Item #08Y Page 23 of 41 CITY OF ENCINITAS BUDGET AMENDMENT JOURNAL ENTRY PROOF Report generated: 06/16/2022 17:30 User: Tgallup Program ID: bgamdent Page 11 FUND YEAR PER JNL EFF DATE DEBIT CREDIT ACCOUNT ACCOUNT DESCRIPTION 101 GENERAL FUND 2022 12 120005 06/22/2022 10100000-290 APPROPRIATIONS 7,717,876.66 10100000-291 ESTIMATED REVENUES 143,173.82 10100000-292 BUDGETARY FUND BAL-UNRESERVED 7,574,702.84 FUND TOTAL 7,717,876.66 7,717,876.66 201 STATE GASOLINE TAXES 2022 12 120005 06/22/2022 20100000-290 APPROPRIATIONS 51,223.00 20100000-291 ESTIMATED REVENUES 51,223.00 FUND TOTAL 51,223.00 51,223.00 212 COASTAL ZONE MANAGEMENT 2022 12 120005 06/22/2022 21200000-290 APPROPRIATIONS 526.43 21200000-292 BUDGETARY FUND BAL-UNRESERVED 526.43 FUND TOTAL 526.43 526.43 222 CDBG GRANT 2022 12 120005 06/22/2022 22200000-290 APPROPRIATIONS 9,667.00 22200000-291 ESTIMATED REVENUES 9,667.00 FUND TOTAL 9,667.00 9,667.00 229 RESTRICTED DONATIONS & CONTRIB 2022 12 120005 06/22/2022 22900000-290 APPROPRIATIONS 5,066.87 22900000-291 ESTIMATED REVENUES 12,407.00 22900000-292 BUDGETARY FUND BAL-UNRESERVED 17,473.87 FUND TOTAL 17,473.87 17,473.87 295 ENCINITAS LLD 2022 12 120005 06/22/2022 29500000-290 APPROPRIATIONS 87,000.00 29500000-292 BUDGETARY FUND BAL-UNRESERVED 87,000.00 FUND TOTAL 87,000.00 87,000.00 297 ENC RANCH LLD 2022 12 120005 06/22/2022 29700000-290 APPROPRIATIONS 6,100.00 29700000-292 BUDGETARY FUND BAL-UNRESERVED 6,100.00 FUND TOTAL 6,100.00 6,100.00 301 DEBT SERVICE FUND 2022 12 120005 06/22/2022 30100000-290 APPROPRIATIONS 300,000.00 30100000-291 ESTIMATED REVENUES 850,231.00 30100000-292 BUDGETARY FUND BAL-UNRESERVED 550,231.00 2022-06-22 Item #08Y Page 24 of 41 CITY OF ENCINITAS BUDGET AMENDMENT JOURNAL ENTRY PROOF Report generated: 06/16/2022 17:30 User: Tgallup Program ID: bgamdent Page 12 FUND YEAR PER JNL EFF DATE DEBIT CREDIT ACCOUNT ACCOUNT DESCRIPTION FUND TOTAL 850,231.00 850,231.00 401 CAPITAL IMPROVEMENTS-EXISTING 2022 12 120005 06/22/2022 40100000-290 APPROPRIATIONS 193,776.09 40100000-291 ESTIMATED REVENUES 193,776.09 FUND TOTAL 193,776.09 193,776.09 402 CAPITAL IMPROVEMENTS-NEW 2022 12 120005 06/22/2022 40200000-290 APPROPRIATIONS 5,066.87 40200000-291 ESTIMATED REVENUES 5,066.87 FUND TOTAL 5,066.87 5,066.87 403 FACILITIES CAPITAL MAINTENANCE 2022 12 120005 06/22/2022 40300000-291 ESTIMATED REVENUES 6,475,850.00 40300000-292 BUDGETARY FUND BAL-UNRESERVED 6,475,850.00 FUND TOTAL 6,475,850.00 6,475,850.00 601 SELF INSURANCE 2022 12 120005 06/22/2022 60100000-290 APPROPRIATIONS 750,000.00 60100000-291 ESTIMATED REVENUES 100,000.00 60100000-292 BUDGETARY FUND BAL-UNRESERVED 650,000.00 FUND TOTAL 750,000.00 750,000.00 2022-06-22 Item #08Y Page 25 of 41 CITY OF ENCINITAS BUDGET AMENDMENT JOURNAL ENTRY PROOF Report generated: 06/16/2022 17:30 User: Tgallup Program ID: bgamdent Page 13 CLERK: Tgallup PA JOURNAL EFF DATE GL YEAR/PER/JNL SOURCE PROJECT STRING REF1 REF2 REF3 REF4 T AMOUNT 120150 06/22/2022 2022/12/120005 BUA CD20A-402101 -BUDGET - 120005 RESO22-081 T Q3 ADJ 5 .06 BUA CP20A-402101 -BUDGET - 120005 RESO22-081 T Q3 ADJ 5 -.06 BUA CP20A-402101 -BUDGET - 120005 RESO22-081 T Q3 ADJ 5 -529.16 BUA COV22-GEN -BUDGET - 120005 RESO22-081 T Q3 ADJ 5 1,000,000.00 BUA COV22-RISK -BUDGET - 120005 RESO22-081 T Q3 ADJ 5 100,000.00 BUA CP21A-402229 -CONST - 120005 RESO22-081 T Q3 ADJ 5 5,066.87 BUA CS19B-101 -BUDGET -FY2019 120005 RESO22-081 T Q3 ADJ 5 -110,691.90 BUA CS04D-101 -BUDGET -FY2017 120005 RESO22-081 T Q3 ADJ 5 110,691.90 BUA CS20E-402101 -BUDGET - 120005 RESO22-081 T Q3 ADJ 5 -618.00 BUA WC17B-402101 -BUDGET -FY2017 120005 RESO22-081 T Q3 ADJ 5 -70,000.00 BUA WC17B-402101 -STUDYWP - 120005 RESO22-081 T Q3 ADJ 5 -19,721.10 BUA CS04D-101 -BUDGET -FY2017 120005 RESO22-081 T Q3 ADJ 5 89,721.10 BUA CP16A-212 -BUDGET - 120005 RESO22-081 T Q3 ADJ 5 526.43 BUA CS22A-201 -SB1 -CONST 120005 RESO22-081 T Q3 ADJ 5 51,223.00 BUA WD17A-402101 -BUDGET -FY2017 120005 RESO22-081 T Q3 ADJ 5 -44,445.75 BUA CS22F-101 -BUDGET - 120005 RESO22-081 T Q3 ADJ 5 44,445.75 BUA CD17A-402101 -BUDGET -FY2017 120005 RESO22-081 T Q3 ADJ 5 -7,859.81 BUA CS22F-101 -BUDGET - 120005 RESO22-081 T Q3 ADJ 5 7,859.81 Project Totals CD17A Total: -7,859.81 CD20A Total: .06 COV22 Total: 1,100,000.00 CP16A Total: 526.43 CP20A Total: -529.22 CP21A Total: 5,066.87 CS04D Total: 200,413.00 CS19B Total: -110,691.90 CS20E Total: -618.00 CS22A Total: 51,223.00 CS22F Total: 52,305.56 WC17B Total: -89,721.10 WD17A Total: -44,445.75 1,155,669.14 ** END OF REPORT - Generated by Tom Gallup ** 2022-06-22 Item #08Y Page 26 of 41 City of Encinitas Summary of Budgetary Fund Balance ATTACHMENT 3 FY 2021-22 Council Action Reconciled through May 25, 2022 Council Meeting Meeting Date Resolution Increase (Decrease) to Fund Balance Available Fund Balance Actual Beginning Fund Balance, 7/1/21 27,163,284 Less: Contingency Reserve (15,297,366) Budget Stabilization Reserve (1,700,925) Nonspendable Reserve (737,114) Restricted FSA Forfeitures (172,705) Encumbrance Carryovers FY21 - Available Beginning Fund Balance, 7/1/21 9,255,174 FY 2021-22 Original Budgets Adopted 06/23/21 2021-070 (1,501,154) 7,754,020 - FY 2021-22 Budget Amendments by Council: 1. CS04D N. Coast Highway 101 Streetscape Project 09/22/21 2021-088 (150,000) 7,604,020 2. Additional Discretionary Payment to CalPERS to reduce UAL 12/15/21 2021-106 (500,000) 7,104,020 3. Temporary Lifeguard Seasonal Salaries 12/15/21 2021-126 (40,000) 7,064,020 4. Ratify Transfer from WC08D Civic Center Improvements to CD20A Cottonwood Creek Basin Maintenance 02/09/22 2022-020 - 8,295,610 5. Mid-Year Budget Amendments 02/23/22 2022-012 1,231,590 8,295,610 6. Cannabis Business Registration Fee and Application Review 03/16/22 2022-029 881,011 9,176,621 7. WC22D Outdoor Dining Studies 03/16/22 2022-030 (75,000) 9,101,621 8. WC22C HAP Grant (Fund 203 to 401)03/23/22 2022-033 - 9,101,621 9. ARPA Funds Applied to Sheriff's Contract 04/20/22 2022-041 8,142,344 17,243,965 10. CF20D Pacific View - Design Services 04/27/22 2022-044 (524,150) 16,719,815 11. CIP and Work Project Amendments 05/11/22 2022-035 2,541 16,722,356 12. IT Managed Services for SEJPA 05/25/22 2022-053 (89,303) 16,633,053 13.Proposed Third Quarter Budget Amendments 06/15/22 2022-081 (5,277,033) 11,356,020 Description General Fund (101) Prepared by: Finance Printed 6/16/2022 Attachment 3 - Fund Balance Summary \ 2021-222022-06-22 Item #08Y Page 27 of 41 ATTACHMENT 4 FY 2021-22 Adopted Budget 6/23/21 FY 2021-22 Budget Amendment FY 2021-22 Amended Budget FY 2021-22 Actual Amounts FY 2021-22 Budget $ Variance Over/(Under) YTD FY 2021-22 Budget % YTD REVENUE TAX REVENUE 1 PROPERTY TAXES $ 54,246,604 $ - $ 54,246,604 $ 33,735,499 $ (20,511,105)62.2% 2 DOCUMENTARY TRANSFER TAXES 600,000 - 600,000 633,186 33,186 105.5% 3 SALES TAXES 14,385,055 1,720,000 16,105,055 10,275,208 (5,829,847)63.8% 4 TRANSIENT OCCUPANCY TAX 3,271,895 - 3,271,895 2,919,156 (352,739)89.2% 5 FRANCHISE FEES 2,329,049 - 2,329,049 1,472,348 (856,701)63.2% 6 TAX REVENUE TOTAL 74,832,603 1,720,000 76,552,603 49,035,397 (27,517,206) 64.1% OTHER REVENUE 7 LICENSES AND PERMITS 236,000 - 236,000 216,948 (19,052)91.9% 8 INTERGOVERNMENTAL REVENUE 703,346 - 703,346 519,091 (184,255)73.8% 9 CHARGES FOR SERVICES 7,198,118 1,876,261 9,074,379 7,777,533 (1,296,845)85.7% 10 FINES AND PENALTIES 435,253 - 435,253 237,821 (197,432)54.6% 11 USE OF MONEY 984,154 - 984,154 841,700 (142,454)85.5% 12 OTHER REVENUE 656,793 20,423,600 21,080,393 929,323 (20,151,070)4.4% 13 OTHER REVENUE TOTAL 10,213,664 22,299,861 32,513,525 10,522,416 (21,991,108) 14 REVENUE TOTAL 85,046,267 24,019,861 109,066,128 59,557,813 (49,508,315) EXPENDITURES GENERAL GOVERNMENT 15 CITY COUNCIL - ADMINISTRATION 509,514 - 509,514 335,357 (174,157) 16 CITY COUNCIL - CITY ATTORNEY 985,500 - 985,500 603,039 (382,461) 17 CITY MANAGER - ADMINISTRATION 1,378,714 (68,900) 1,309,814 788,948 (520,866) 18 CITY MANAGER - ECONOMIC DEV 123,500 - 123,500 71,117 (52,383) 19 CITY MANAGER - ENVIRONMENTAL SVC 193,061 - 193,061 135,529 (57,532) 20 CITY MANAGER - HUMAN RESOURCES 954,309 - 954,309 694,002 (260,307)72.7% 21 CITY MANAGER- INFORMATION TECHNOLOGY 3,426,277 - 3,426,277 2,411,790 (1,014,487) 22 CITY CLERK - ADMINISTRATION 470,313 - 470,313 323,998 (146,315)68.9% 23 CITY CLERK - ELECTIONS 2,500 - 2,500 1,569 (931)62.8% 24 FINANCE - ADMINISTRATION 2,304,090 - 2,304,090 1,526,071 (778,019)66.2% 25 GENERAL GOVERNMENT TOTAL 10,347,778 (68,900) 10,278,878 6,891,420 (3,387,458) DEVELOPMENT SERVICES 26 DEV SVC-DIRECTOR 411,048 - 411,048 311,483 (99,565)75.8% 27 DEV SVC-PLAN-ADMIN SVCS 486,075 - 486,075 336,461 (149,614)69.2% 28 DEV SVC-PLAN-LAND DEVELOPMENT 2,972,127 198,000 3,170,127 1,942,808 (1,227,319)61.3% 29 DEV SVC-PLAN-REGULATORY PERMIT 157,755 539,150 696,905 110,408 (586,498)15.8% 30 DEV SVC-PLAN-APPLICANT DEPOSIT 3,000 - 3,000 115 (2,885)3.8% 31 DEV SVC-PLAN-ADV PLANNING-HSG 1,057,441 11,000 1,068,441 589,519 (478,922)55.2% 32 DEV SVC-PLAN-BUILDING & CODE 2,367,814 - 2,367,814 1,923,117 (444,697)81.2% 33 DEV SVC-PLAN-PARKING CITATION 98,500 - 98,500 43,261 (55,239)43.9% 34 DVC SVC-ENG-CITY ENGINEER 1,340,627 - 1,340,627 722,268 (618,359)53.9% 35 DEV SVC-ENG-TRAFFIC ENGINEERNG 679,122 40,500 719,622 450,230 (269,392)62.6% 36 DEV SVC-ENG-INSPECTIONS 1,337,461 - 1,337,461 780,681 (556,780)58.4% 37 DEVELOPMENT SERVICES TOTAL 10,910,970 788,650 11,699,620 7,210,351 (4,489,269) 61.6% 70.4% 67.0% Schedule C: General Fund Revenue, Expenditures and Transfers Detail 70.2% 32.4% 54.6% 65.8% 61.2% 60.2% 57.6% 2022-06-22 Item #08Y Page 28 of 41 ATTACHMENT 4 FY 2021-22 Adopted Budget 6/23/21 FY 2021-22 Budget Amendment FY 2021-22 Amended Budget FY 2021-22 Actual Amounts FY 2021-22 Budget $ Variance Over/(Under) YTD FY 2021-22 Budget % YTD Schedule C: General Fund Revenue, Expenditures and Transfers Detail PUBLIC SAFETY 38 PUBLIC SAFETY-LAW ENFORCEMENT 17,550,322 - 17,550,322 8,607,800 (8,942,522)49.0% 39 PUBLIC SAFETY - FIRE ADMIN 612,965 - 612,965 463,126 (149,839)75.6% 40 PUBLIC SAFETY-FIRE OPERATIONS 14,589,304 385,400 14,974,704 11,989,044 (2,985,660)80.1% 41 PUBLIC SAFETY-LOSS PREVENTION 690,569 21,500 712,069 491,352 (220,717)69.0% 42 PUBLIC SAFETY - DISASTER PREP 190,332 - 190,332 161,935 (28,397)85.1% 43 PUBLIC SAFETY - MARINE SAFETY 1,532,532 40,000 1,572,532 999,617 (572,915)63.6% 44 PUBLIC SAFETY - JR LIFEGUARDS 305,302 - 305,302 197,207 (108,095)64.6% 45 PUBLIC SAFETY TOTAL 35,471,326 446,900 35,918,226 22,910,083 (13,008,143) PUBLIC WORKS 46 PUBLIC WORKS - ADMINISTRATION 424,632 - 424,632 155,294 (269,338)36.6% 47 PUBLIC WORKS-ENVIRONMENTAL 1,500 - 1,500 148 (1,352) 48 PUBLIC WORKS - STREET MAINT 3,393,013 19,000 3,412,013 2,014,397 (1,397,616)59.0% 49 PUBLIC WORKS-FAC MAINT CVC CTR 507,298 - 507,298 296,647 (210,651)58.5% 50 PUBLIC WORKS-FAC MAINT FIRE ST 337,443 - 337,443 183,922 (153,521)54.5% 51 PUBLIC WORKS-FAC MAINT PW YRD 236,279 - 236,279 128,740 (107,539)54.5% 52 PUBLIC WORKS-FAC MAINT LIBRARY 367,046 - 367,046 217,143 (149,903)59.2% 53 PUBLIC WORKS-COMM CTR & PARKS 429,794 429,794 251,584 (178,210)58.5% 54 PUBLIC WORKS-STORM WATER MAINT 709,587 31,670 741,257 528,863 (212,394)71.3% 55 PUBLIC WORKS-STORM WATER FLOOD 99,072 - 99,072 66,791 (32,281)67.4% 56 PUBLIC WORKS-STORMWATER PROG 777,854 - 777,854 502,887 (274,967)64.7% 57 PUBLIC WORKS TOTAL 7,283,518 50,670 7,334,188 4,346,416 (2,987,772) PARKS, RECREATION & CULTURAL ARTS 58 PARKS REC - ADMINISTRATION 1,264,450 - 1,264,450 851,392 (413,058)67.3% 59 PARKS REC - PARK MAINTENANCE 3,015,612 (50,000) 2,965,612 1,529,144 (1,436,468)51.6% 60 PARKS REC - BEACH MAINTENANCE 767,075 (5,000) 762,075 379,379 (382,696)49.8% 61 PARKS REC - TRAIL MAINTENANCE 342,159 - 342,159 127,141 (215,018)37.2% 62 PARKS REC-RECREATION PROGRAMS 458,747 - 458,747 301,113 (157,634)65.6% 63 PARKS REC - COMM CENTER OPER 883,400 - 883,400 471,621 (411,779)53.4% 64 PARKS REC - COMM CENTER PROGRAMS 224,881 (10,000) 214,881 64,834 (150,047)30.2% 65 PARKS REC - COMM CENTER RENTALS 32,007 - 32,007 63,671 31,664 198.9% 66 PARKS REC - SENIOR CENTER 192,087 - 192,087 85,242 (106,845)44.4% 67 PARKS REC - REC FACILITY PROGRAMS 468,058 195,000 663,058 455,916 (207,142)68.8% 68 PARKS REC - CULTURAL ARTS 321,395 - 321,395 174,116 (147,279)54.2% 69 PARKS, REC & CULTURAL ARTS TOTAL 7,969,871 130,000 8,099,871 4,503,569 (3,596,302) NON-DEPARTMENTAL 70 NON DEPT-CENTRAL PURCHASES 95,298 - 95,298 48,043 (47,255) 71 NON DEPT-SHARED EXPENSES 4,408,068 500,000 4,908,068 4,846,621 (61,447) 72 NON-DEPARTMENTAL TOTAL 4,503,366 500,000 5,003,366 4,894,663 (108,703) 73 EXPENDITURES TOTAL 76,486,829 1,847,320 78,334,149 50,756,502 (27,577,647) 74 EXCESS OF REVENUE OVER EXPENDITURES 8,559,438 22,172,541 30,731,979 8,801,312 (21,930,667) TRANSFERS 75 TRANSFERS IN 22,925,117 (19,742,331)3,182,786 1,103,874 (2,078,912)34.7% 76 TRANSFERS OUT (32,985,709) (1,082,609)(34,068,318) (11,990,991) 22,077,327 35.2% 77 TRANSFER TOTAL (10,060,592) (20,824,940) (30,885,532) (10,887,116) 19,998,415 78 NET INCREASE (DECREASE) TO FUND BALANCE $ (1,501,154) $ 1,347,601 $ (153,553) $ (2,085,804) $ (1,932,251) 35.2% 1358.4% 59.3% 28.6% 55.6% 50.4% 98.7% 97.8% 64.8% 9.9% 63.8% 2022-06-22 Item #08Y Page 29 of 41 ATTACHMENT 5 FISCAL YEAR 2021-22 FUND 401 CAPITAL PROJECTS (As of March 31, 2022) (A)(C)(D)(G)(H)(I)(J)(M)(O)(P)(R) Project Number Funding Source Project Description Previous Appropriation Current FY Funding Off-Cycle Funding Fiscal YTD Expenses Net Transfers CIP Adjustments Previous Costs Project Cost to Date Project Budget Remaining Balance as of 3/31/22 CD05E 101 GENERAL FUND Storm Drain Repair 2,567,662 250,000 74,023 - 2,086,127 2,160,150 2,817,662 657,512 CD05E 101 GENERAL FUND Storm Drain Repair Revenue 13,549 - - 13,549 13,549 13,549 (0) CD05E 239 FLOOD CONTROL FUND Storm Drain Repair 554,790 - - 537,844 537,844 554,790 16,946 CD05E Total 3,136,001 250,000 - 74,023 - - 2,637,521 2,711,543 3,386,001 674,458 CD07C 229 RESTRICTED FUND Manchester Ave @ Mira Costa Drainage Improvements 56,902 - - - - 56,902 56,902 CD07C Total 56,902 - - - - - - - 56,902 56,902 CD17B 239 FLOOD CONTROL FUND 5 Yr Habitat-Biological & Monitoring 174,474 13,324 - 117,373 130,697 174,474 43,778 CD17B Total 174,474 - - 13,324 - - 117,373 130,697 174,474 43,778 CD19A 203 STATE CAPITAL GRANT FUND Watershed LID Retrofit 20,135 - - 20,135 20,135 20,135 - CD19A Total 20,135 - - - - - 20,135 20,135 20,135 - CP00F 101 GENERAL FUND Recreational Trails Development 1,905,182 605,000 63,599 - 719,675 783,274 2,510,182 1,726,908 CP00F 223 FEDERAL CAPITAL GRANT FUND Recreational Trails Development 18,766 - - 18,766 18,766 18,766 - CP00F 229 RESTRICTED FUND (401) Recreational Trails Development 15,150 24,535 - - 14,733 14,733 39,685 24,952 CP00F 236 RECREATIONAL TRAILS FUND Recreational Trails Development 75,315 30,000 - - 10,980 10,980 105,315 94,335 CP00F Total 2,014,413 605,000 54,535 63,599 - - 764,154 827,753 2,673,948 1,846,195 CP04G 101 GENERAL FUND Park Improvement Projects 847,364 218,048 - - 690,189 690,189 1,065,412 375,223 CP04G 101 GENERAL FUND (401)Park Improvement Projects 1,379,623 - - 1,236,080 1,236,080 1,379,623 143,543 CP04G 229 RESTRICTED FUND Park Improvement Projects 60,000 - - 60,000 60,000 60,000 - CP04G 232 PARK ACQUISITION Park Improvement Projects 221,000 - - 221,000 221,000 221,000 - CP04G Total 2,507,987 218,048 - - - - 2,207,269 2,207,269 2,726,035 518,766 CP05A 101 GENERAL FUND Habitat/Open Space Acquisition - - - - - - - CP05A 231 PARK DEVELOPMENT FEES FUND Habitat/Open Space Acquisition - - - - - - - CP05A 232 PARK ACQUISITION Habitat/Open Space Acquisition 10,844 - - 6,932 6,932 10,844 3,913 CP05A 235 OPEN SPACE IMPACT FEES Habitat/Open Space Acquisition 121,280 - - - - 121,280 121,280 CP05A Total 132,124 - - - - - 6,932 6,932 132,124 125,193 CP14A 101 GENERAL FUND Olympus Park - - - - - - - CP14A 229 RESTRICTED FUND Olympus Park 15,000 511 - 1,037 1,548 15,000 13,452 CP14A 231 PARK DEVELOPMENT FEES FUND Olympus Park 1,749,192 116,435 - 1,632,757 1,749,192 1,749,192 - CP14A 232 PARK ACQUISITION Olympus Park 3,659,416 5,643 - 3,653,333 3,658,977 3,659,416 439 CP14A 235 OPEN SPACE IMPACT FEES Olympus Park 216,250 118,111 - 88,784 206,895 216,250 9,355 CP14A Total 5,639,858 - - 240,701 - - 5,375,911 5,616,612 5,639,858 23,246 CP14B 101 GENERAL FUND Beacon's Beach Access 850,000 - (87,020) 556,518 556,518 762,980 206,462 CP14B Total 850,000 - - - (87,020) - 556,518 556,518 762,980 206,462 CP16A 203 STATE CAPITAL GRANT FUND Cardiff Beach Living Shoreline Project (Dune Restoration)3,359,257 - - 3,233,129 3,233,129 3,359,257 126,128 CP16A 203 STATE CAPITAL GRANT FUND Cardiff Beach Living Shoreline Project (Dune Restoration)283,074 - - 283,074 283,074 283,074 - CP16A 212 COASTAL ZONE MANAGEMENT FUND Cardiff Beach Living Shoreline Project (Dune Restoration)31,369 13,713 - 18,182 31,895 31,369 (526) CP16A Total 3,673,700 - - 13,713 - - 3,534,385 3,548,099 3,673,700 125,601 CP22A 101 GENERAL FUND Beacon's Beach Parking Lot - 150,000 19,342 - - 19,342 150,000 130,658 CP22A 203 STATE CAPITAL GRANT FUND Beacon's Beach Parking Lot - - - - - - - - CP22A Total - 150,000 - 19,342 - - - 19,342 150,000 130,658 1 of 62022-06-22 Item #08Y Page 30 of 41 ATTACHMENT 5 FISCAL YEAR 2021-22 FUND 401 CAPITAL PROJECTS (As of March 31, 2022) (A)(C)(D)(G)(H)(I)(J)(M)(O)(P)(R) Project Number Funding Source Project Description Previous Appropriation Current FY Funding Off-Cycle Funding Fiscal YTD Expenses Net Transfers CIP Adjustments Previous Costs Project Cost to Date Project Budget Remaining Balance as of 3/31/22 CP22B 101 GENERAL FUND El Portal Art - 129,800 - - - - 129,800 129,800 CP22B Total - 129,800 - - - - - - 129,800 129,800 CP22C 101 GENERAL FUND Beacon's Coastal Bluff Restoration - 55,000 51,792 87,020 - 51,792 142,020 90,228 CP22C 203 STATE CAPITAL GRANT FUND Beacon's Coastal Bluff Restoration - 31,000 - - - - 31,000 31,000 CP22C 212 COASTAL ZONE MANAGEMENT FUND Beacon's Coastal Bluff Restoration - - 8,100 - - 8,100 8,100 CP22C Total - - 86,000 51,792 95,120 - - 51,792 181,120 129,328 CS01E 101 GENERAL FUND Safe Rte 2 Schools Program (City)556,428 200,000 4,670 - 237,146 241,816 756,428 514,612 CS01E 211 TRANSNET FUND Safe Rte 2 Schools Program (City)1,169,129 - - 1,169,129 1,169,129 1,169,129 1 CS01E 222 CDBG FUND Safe Rte 2 Schools Program (City)- - - - - - - CS01E Total 1,725,557 200,000 - 4,670 - - 1,406,275 1,410,945 1,925,557 514,612 CS02F 101 GENERAL FUND Traffic Safety and Calming 390,000 100,000 48,164 - 346,145 394,309 490,000 95,691 CS02F 211 TRANSNET FUND Traffic Safety and Calming 126,165 - - 126,165 126,165 126,165 0 CS02F 233 TRAFFIC MIT FUND Traffic Safety and Calming 150,000 (64,596) - - 85,404 85,404 85,404 0 CS02F Total 666,165 35,404 - 48,164 - - 557,713 605,877 701,569 95,692 CS02G 101 GENERAL FUND (401)Traffic Signal Modifications 25,686 - - 25,686 25,686 25,686 - CS02G 211 TRANSNET FUND Traffic Signal Modifications 434,688 - - 434,688 434,688 434,688 0 CS02G 223 FEDERAL CAPITAL GRANT FUND Traffic Signal Modifications 581,300 - - 93,773 93,773 581,300 487,527 CS02G 229 RESTRICTED FUND (229)Traffic Signal Modifications 14,314 - - - - 14,314 14,314 CS02G 233 TRAFFIC MIT FUND Traffic Signal Modifications 175,000 50,000 - - 121,538 121,538 225,000 103,462 CS02G 234 RTCIP FEES Traffic Signal Modifications 40,000 13,930 - - 13,930 40,000 26,070 CS02G Total 1,270,988 50,000 - 13,930 - - 675,684 689,614 1,320,988 631,374 CS04D 101 GENERAL FUND No. Coast Hwy 101 Streetscape 8,286,211 150,000 4,199,310 - 1,794,126 5,993,435 8,436,211 2,442,776 CS04D 203 STATE CAPITAL GRANT FUND No. Coast Hwy 101 Streetscape 179,865 84,752 - 3,780 88,532 179,865 91,333 CS04D 211 TRANSNET FUND No. Coast Hwy 101 Streetscape 7,379,996 495,631 - 6,689,541 7,185,172 7,379,996 194,824 CS04D 234 RTCIP FEES No. Coast Hwy 101 Streetscape 376,000 - - 376,000 376,000 376,000 - CS04D Total 16,222,072 - 150,000 4,779,693 - - 8,863,446 13,643,139 16,372,072 2,728,933 CS11C 101 GENERAL FUND La Costa Avenue Improvements 187,500 18,800 - 95,873 114,673 187,500 72,827 CS11C 233 TRAFFIC MIT FUND La Costa Avenue Improvements 1,287,500 (300,000) - - 79,317 79,317 987,500 908,183 CS11C 234 RTCIP FEES La Costa Avenue Improvements - 300,000 - - - - 300,000 300,000 CS11C Total 1,475,000 - - 18,800 - - 175,190 193,990 1,475,000 1,281,010 CS12E 233 TRAFFIC MIT FUND Enc Comm. Park Mitigation/Santa Fe @ Scripps 38,000 - - - - 38,000 38,000 CS12E Total 38,000 - - - - - - - 38,000 38,000 CS13C 233 TRAFFIC MIT FUND ECP Offsite Improvements 750,000 - - 563,876 563,876 750,000 186,124 CS13C Total 750,000 - - - - - 563,876 563,876 750,000 186,124 CS16C 101 GENERAL FUND ADA Curb Ramp Project (Transition Plan Compliance)171,074 50,000 7,002 - 57,553 64,555 221,074 156,519 CS16C 222 CDBG FUND ADA Curb Ramp Project (Transition Plan Compliance)40,000 - - 40,000 40,000 40,000 - CS16C Total 211,074 50,000 - 7,002 - - 97,553 104,555 261,074 156,519 CS16E 101 GENERAL FUND Montgomery Ave At-Grade Pedestrian Rail Crossing 1,946,865 81,325 - 1,781,412 1,862,737 1,946,865 84,128 CS16E Total 1,946,865 - - 81,325 - - 1,781,412 1,862,737 1,946,865 84,128 CS16F 101 GENERAL FUND El Portal Ped/Bike Underpass Project 7,495,456 963,980 - 6,443,650 7,407,630 7,495,456 87,826 2 of 62022-06-22 Item #08Y Page 31 of 41 ATTACHMENT 5 FISCAL YEAR 2021-22 FUND 401 CAPITAL PROJECTS (As of March 31, 2022) (A)(C)(D)(G)(H)(I)(J)(M)(O)(P)(R) Project Number Funding Source Project Description Previous Appropriation Current FY Funding Off-Cycle Funding Fiscal YTD Expenses Net Transfers CIP Adjustments Previous Costs Project Cost to Date Project Budget Remaining Balance as of 3/31/22 CS16F 203 STATE CAPITAL GRANT FUND El Portal Ped/Bike Underpass Project - - - - - - - CS16F 223 FEDERAL CAPITAL GRANT FUND El Portal Ped/Bike Underpass Project 889,000 356 - 836,097 836,453 889,000 52,547 CS16F 234 RTCIP FEES El Portal Ped/Bike Underpass Project 1,200,000 - - 1,192,630 1,192,630 1,200,000 7,370 CS16F Total 9,584,456 - - 964,336 - - 8,472,377 9,436,713 9,584,456 147,743 CS18G 101 GENERAL FUND B Street Sidewalk Project 538,099 - - 537,736 537,736 538,099 363 CS18G 211 TRANSNET FUND B Street Sidewalk Project 275,000 - - 253,185 253,185 275,000 21,816 CS18G Total 813,099 - - - - - 790,921 790,921 813,099 22,179 CS19B 101 GENERAL FUND Morning Sun Drive Sidewalk 2,608,307 40 - 2,497,575 2,497,615 2,608,307 110,692 CS19B Total 2,608,307 - - 40 - - 2,497,575 2,497,615 2,608,307 110,692 CS19E 101 GENERAL FUND Santa Fe Dr Corridor Improvements 287,500 74,373 - 129,865 204,237 287,500 83,263 CS19E 203 STATE CAPITAL GRANT FUND Santa Fe Dr Corridor Improvements 996,000 131,772 - 69,240 201,012 996,000 794,988 CS19E 222 CDBG FUND Santa Fe Dr Corridor Improvements 235,181 - - - 235,181 235,181 CS19E 223 FEDERAL CAPITAL GRANT FUND Santa Fe Dr Corridor Improvements 692,640 - - 99,000 99,000 692,640 593,640 CS19E 233 TRAFFIC MIT FUND Santa Fe Dr Corridor Improvements 1,142,031 746,179 65,011 - 284,728 349,739 1,888,210 1,538,471 CS19E Total 3,118,171 981,360 - 271,155 - - 582,833 853,989 4,099,531 3,245,542 CS19F 101 GENERAL FUND N HWY 101 NCTD TEMP PARKING IMPROVEMENTS 382,000 - - 376,674 376,674 382,000 5,326 CS19F Total 382,000 - - - - - 376,674 376,674 382,000 5,326 CS20A 201 HUTA (GAS TAX) FUND FY2019-20 Annual Street Overlay - HUTA - 47,051 - - 47,051 - (47,051) CS20A 201 HUTA (GAS TAX) FUND FY2019-20 Annual Street Overlay - RMRA SB1 1,261,000 - - 1,213,949 1,213,949 1,261,000 47,051 CS20A 211 TRANSNET FUND FY2019-20 Annual Street Overlay 1,739,000 43,956 - 1,693,748 1,737,705 1,739,000 1,295 CS20A Total 3,000,000 - - 91,008 - - 2,907,697 2,998,705 3,000,000 1,295 CS21A 101 GENERAL FUND FY2020-21 Annual Street Overlay 14,384 - - 14,384 14,384 14,384 - CS21A 201 HUTA (GAS TAX) FUND FY2020-21 Annual Street Overlay - HUTA - 9,918 - - 9,918 - (9,918) CS21A 201 HUTA (GAS TAX) FUND FY2020-21 Annual Street Overlay - RMRA SB1 1,849,183 1,002,254 - 222,431 1,224,685 1,849,183 624,498 CS21A 211 TRANSNET FUND FY2020-21 Annual Street Overlay 1,380,051 1,062,563 - 210,479 1,273,042 1,380,051 107,009 CS21A Total 3,243,618 - - 2,074,735 - - 447,294 2,522,029 3,243,618 721,588 CS21B 101 GENERAL FUND N. Vulcan Ave. Temp Parking Phase II 400,000 75,187 - 323,713 398,900 400,000 1,100 CS21B 239 FLOOD CONTROL FUND N. Vulcan Ave. Temp Parking Phase II 230,128 9,735 - 202,132 211,868 230,128 18,260 CS21B Total 630,128 - - 84,922 - - 525,845 610,768 630,128 19,360 CS22A 101 GENERAL FUND FY2021-22 Annual Street Overlay 480,000 - - - - 480,000 480,000 CS22A 201 HUTA (GAS TAX) FUND FY2021-22 Annual Street Overlay - HUTA - 559,981 - - - - 559,981 559,981 CS22A 201 HUTA (GAS TAX) FUND FY2021-22 Annual Street Overlay - RMRA SB1 - 1,238,938 776,704 - - 776,704 1,238,938 462,234 CS22A 211 TRANSNET FUND FY2021-22 Annual Street Overlay - 1,775,000 938,697 - - 938,697 1,775,000 836,303 CS22A Total 480,000 3,573,919 - 1,715,401 - - - 1,715,401 4,053,919 2,338,518 CS22B 203 STATE CAPITAL GRANT FUND Citywide Leading Pedestrian Intervals - 1,234,500 - - - - 1,234,500 1,234,500 3 of 62022-06-22 Item #08Y Page 32 of 41 ATTACHMENT 5 FISCAL YEAR 2021-22 FUND 401 CAPITAL PROJECTS (As of March 31, 2022) (A)(C)(D)(G)(H)(I)(J)(M)(O)(P)(R) Project Number Funding Source Project Description Previous Appropriation Current FY Funding Off-Cycle Funding Fiscal YTD Expenses Net Transfers CIP Adjustments Previous Costs Project Cost to Date Project Budget Remaining Balance as of 3/31/22 CS22B Total - 1,234,500 - - - - - - 1,234,500 1,234,500 CS22C 101 GENERAL FUND HWY 101 Seperated Bike Lanes 72,210 17,125 - - 17,125 72,210 55,085 CS22C 203 STATE CAPITAL GRANT FUND HWY 101 Seperated Bike Lanes 649,890 - - - - 649,890 649,890 CS22C Total - 722,100 - 17,125 - - - 17,125 722,100 704,975 CS22D 101 GENERAL FUND Highway 101 Walkway to Solana Beach 132,770 8,751 - - 8,751 132,770 124,019 CS22D 203 STATE CAPITAL GRANT FUND Highway 101 Walkway to Solana Beach 708,930 36,304 - - 36,304 708,930 672,626 CS22D Total - 841,700 - 45,055 - - - 45,055 841,700 796,645 CS22E 101 GENERAL FUND San Elijo Bridge Pavement Failure Repair 475,000 15,861 - - 15,861 475,000 459,139 CS22E Total - 475,000 - 15,861 - - - 15,861 475,000 459,139 CX16F 101 GENERAL FUND Emergency Repair - Hwy 101 Monitoring 81,526 - - 61,169 61,169 81,526 20,357 CX16F 223 FEDERAL CAPITAL GRANT FUND Emergency Repair - Hwy 101 Monitoring 30,986 - - 30,986 30,986 30,986 - CX16F Total 112,512 - - - - - 92,155 92,155 112,512 20,357 WB06A 101 GENERAL FUND ACOE Shoreline Protection Study 127,052 - - 127,052 127,052 127,052 - WB06A 203 STATE CAPITAL GRANT FUND ACOE Shoreline Protection Study 647,000 5,000 - - 605,804 605,804 652,000 46,196 WB06A 212 COASTAL ZONE MANAGEMENT FUND ACOE Shoreline Protection Study 279,948 - - 177,163 177,163 279,948 102,785 WB06A 212 COASTAL ZONE MANAGEMENT FUND ACOE Shoreline Protection Study 366,951 - - 271,184 271,184 366,951 95,767 WB06A Total 1,420,951 5,000 - - - - 1,181,202 1,181,202 1,425,951 244,749 WB08C 212 COASTAL ZONE MANAGEMENT FUND SCOUP-Sand Compatiblity Opportunistic Use Program 1,155,962 100,000 48,342 - 765,420 813,762 1,255,962 442,200 WB08C Total 1,155,962 100,000 - 48,342 - - 765,420 813,762 1,255,962 442,200 WB11A 101 GENERAL FUND TMDL Compliance Program 852,001 69,843 - 708,410 778,253 852,001 73,748 WB11A Total 852,001 - - 69,843 - - 708,410 778,253 852,001 73,748 WB16A 212 COASTAL ZONE MANAGEMENT FUND Beach Habitat Study 230,000 40,000 28,778 (8,100) 98,405 127,183 261,900 134,717 WB16A Total 230,000 40,000 - 28,778 (8,100) - 98,405 127,183 261,900 134,717 WB16B 101 GENERAL FUND Enhancement of Native Habitats in San Elijo Lagoon Ecological Reserve Project 210,563 - - 210,563 210,563 210,563 0 WB16B Total 210,563 - - - - - 210,563 210,563 210,563 0 WB16C 203 STATE CAPITAL GRANT FUND Coastal Storm Damage Reduction Project 700,000 160,000 20,725 - 450,000 470,725 860,000 389,275 WB16C 212 COASTAL ZONE MANAGEMENT FUND Coastal Storm Damage Reduction Project 250,000 20,000 - - 12,500 12,500 270,000 257,500 WB16C Total 950,000 180,000 - 20,725 - - 462,500 483,225 1,130,000 646,775 WC01A 101 GENERAL FUND GIS Basemap Updates and Enhancements 799,600 5,032 - 700,568 705,600 799,600 94,000 WC01A Total 799,600 - - 5,032 - - 700,568 705,600 799,600 94,000 WC08K 101 GENERAL FUND Open Space Mgmt Plan 41,568 - - 40,992 40,992 41,568 576 WC08K 203 STATE CAPITAL GRANT FUND Open Space Mgmt Plan 23,432 - - 23,432 23,432 23,432 - WC08K 223 FEDERAL CAPITAL GRANT FUND Open Space Mgmt Plan 9,499 - - - - 9,499 9,499 WC08K Total 74,499 - - - - - 64,424 64,424 74,499 10,075 4 of 62022-06-22 Item #08Y Page 33 of 41 ATTACHMENT 5 FISCAL YEAR 2021-22 FUND 401 CAPITAL PROJECTS (As of March 31, 2022) (A)(C)(D)(G)(H)(I)(J)(M)(O)(P)(R) Project Number Funding Source Project Description Previous Appropriation Current FY Funding Off-Cycle Funding Fiscal YTD Expenses Net Transfers CIP Adjustments Previous Costs Project Cost to Date Project Budget Remaining Balance as of 3/31/22 WC09D 101 GENERAL FUND Citywide Flood and Channel Maintenance Permitting Program 425,000 24,680 (157,669) 177,174 201,854 267,331 65,478 WC09D Total 425,000 - - 24,680 (157,669) - 177,174 201,854 267,331 65,478 WC10B 101 GENERAL FUND Fees and Other Studies 199,060 - - 152,845 152,845 199,060 46,215 WC10B Total 199,060 - - - - - 152,845 152,845 199,060 46,215 WC11A 101 GENERAL FUND Encinitas Habitat Stewardship Program (Early Multi-Habitat Conserv Plan Implementation )217,941 37,750 - 146,429 184,178 217,941 33,763 WC11A Total 217,941 - - 37,750 - - 146,429 184,178 217,941 33,763 WC12C 213 GOVERNMENTAL/EDUCATIONAL ACCESS FUND Governmental/Educational Access Project-Equipment Update 2,650,870 160,000 62,015 - 1,233,468 1,295,484 2,810,870 1,515,387 WC12C Total 2,650,870 160,000 - 62,015 - - 1,233,468 1,295,484 2,810,870 1,515,387 WC13B 203 STATE CAPITAL GRANT FUND Safe Funding 222,446 - - 190,726 190,726 222,446 31,720 WC13B Total 222,446 - - - - - 190,726 190,726 222,446 31,720 WC14B 101 GENERAL FUND Housing Element Update 2,334,231 29,344 - 2,149,432 2,178,775 2,334,231 155,455 WC14B Total 2,334,231 - - 29,344 - - 2,149,432 2,178,775 2,334,231 155,455 WC15A 101 GENERAL FUND Rail Corridor Vision 442,927 - - 358,067 358,067 442,927 84,860 WC15A 203 STATE CAPITAL GRANT FUND Rail Corridor Vision 175,000 - - 174,825 174,825 175,000 175 WC15A Total 617,927 - - - - - 532,892 532,892 617,927 85,035 WC15E 101 GENERAL FUND Update Inclusionary Ordinance 179,290 - - 179,290 179,290 179,290 - WC15E Total 179,290 - - - - - 179,290 179,290 179,290 - WC16A 101 GENERAL FUND Tyler Enterprise (formerly Enterprise Workflow Management (EnerGov))475,730 23,400 16,928 - 349,405 366,333 499,130 132,796 WC16A 101 GENERAL FUND Tyler Enterprise SDWD (formerly Enterprise Workflow Management (EnerGov))34,089 - - 34,089 34,089 34,089 0 WC16A 101 GENERAL FUND Tyler Enterprise CSD (formerly Enterprise Workflow Management (EnerGov))34,089 - - 34,089 34,089 34,089 (0) WC16A 101 GENERAL FUND Tyler Enterprise ESD (formerly Enterprise Workflow Management (EnerGov))17,045 - - 17,045 17,045 17,045 - WC16A 213 GOVERNMENTAL/EDUCATIONAL ACCESS FUND Tyler Enterprise (formerly Enterprise Workflow Management (EnerGov))88 - - 88 88 88 - WC16A Total 561,041 23,400 - 16,928 - - 434,716 451,644 584,441 132,796 WC16D 101 GENERAL FUND Circulation Element of GP 600,000 50,000 60,040 - 50,367 110,407 650,000 539,593 WC16D 233 TRAFFIC MIT FUND Circulation Element of GP - - - - - - - WC16D Total 600,000 50,000 - 60,040 - - 50,367 110,407 650,000 539,593 WC19A 101 GENERAL FUND El Camino Real Streetscape Study 250,000 - - - - 250,000 250,000 WC19A Total 250,000 - - - - - - - 250,000 250,000 WC19B 101 GENERAL FUND Artisitic Elements - I5 Undercrossing 192,567 35,000 - 71,143 106,143 192,567 86,424 WC19B Total 192,567 - - 35,000 - - 71,143 106,143 192,567 86,424 WC19D 101 GENERAL FUND Rail Corridor "Cross Connect" Implementation Plan 60,000 - - 57,822 57,822 60,000 2,178 5 of 62022-06-22 Item #08Y Page 34 of 41 ATTACHMENT 5 FISCAL YEAR 2021-22 FUND 401 CAPITAL PROJECTS (As of March 31, 2022) (A)(C)(D)(G)(H)(I)(J)(M)(O)(P)(R) Project Number Funding Source Project Description Previous Appropriation Current FY Funding Off-Cycle Funding Fiscal YTD Expenses Net Transfers CIP Adjustments Previous Costs Project Cost to Date Project Budget Remaining Balance as of 3/31/22 WC19D 203 STATE CAPITAL GRANT FUND Rail Corridor "Cross Connect" Implementation Plan 210,000 - - 210,000 210,000 210,000 - WC19D Total 270,000 - - - - - 267,822 267,822 270,000 2,178 WC20D 203 STATE CAPITAL GRANT FUND Housing Update Implementation (SB2 Grant)310,000 104,593 - 151,401 255,994 310,000 54,006 WC20D Total 310,000 - - 104,593 - - 151,401 255,994 310,000 54,006 WC21A 101 GENERAL FUND Modal Alternatives Program 50,000 19,043 - 738 19,781 50,000 30,219 WC21A 203 STATE CAPITAL GRANT FUND Modal Alternatives Program 200,000 70,952 - - 70,952 200,000 129,048 WC21A Total 250,000 - - 89,996 - - 738 90,733 250,000 159,267 WC21B 101 GENERAL FUND El Camino Real Corridor Specific Plan 315,000 82,043 - 16,150 98,193 315,000 216,807 WC21B 203 STATE CAPITAL GRANT FUND El Camino Real Corridor Specific Plan 300,000 81,397 - - 81,397 300,000 218,603 WC21B Total 615,000 - - 163,439 - - 16,150 179,589 615,000 435,411 WC22A 101 GENERAL FUND Rail Safety at Grade Crossings - 250,000 6,623 - - 6,623 250,000 243,377 WC22A Total - 250,000 - 6,623 - - - 6,623 250,000 243,377 WC22B 101 GENERAL FUND Municipal Code Clean Up - 100,000 - - - - 100,000 100,000 WC22B Total - 100,000 - - - - - - 100,000 100,000 WC22C 101 GENERAL FUND Sixth Cycle Housing Element Implementation 50,000 - - - - 50,000 50,000 WC22C Total - 50,000 - - - - - - 50,000 50,000 WD02A 203 STATE CAPITAL GRANT FUND Cottonwood Creek Runoff Plan 41,575 1,006 - 40,569 41,575 41,575 (0) WD02A Total 41,575 - - 1,006 - - 40,569 41,575 41,575 (0) WD16A 239 FLOOD CONTROL FUND South Leucadia Storm Drain Project 357,239 - - 355,785 355,785 357,239 1,454 WD16A Total 357,239 - - - - - 355,785 355,785 357,239 1,454 WD19E 101 GENERAL FUND Leucadia Watershed Master Plan 583,000 8,000 - 457,580 465,580 583,000 117,420 WD19E Total 583,000 - - 8,000 - - 457,580 465,580 583,000 117,420 WF10A 101 GENERAL FUND Green Building Incentive Program 40,000 - - 26,200 26,200 40,000 13,800 WF10A 223 FEDERAL CAPITAL GRANT FUND Green Building Incentive Program 4,000 - - 4,000 4,000 4,000 - WF10A Total 44,000 - - - - - 30,200 30,200 44,000 13,800 WF15A 101 GENERAL FUND Pacific View Consultant Services (Pacific View Architect)100,000 - - 70,538 70,538 100,000 29,462 WF15A Total 100,000 - - - - - 70,538 70,538 100,000 29,462 WF20A 203 STATE CAPITAL GRANT FUND Emergency Generators Fire St 1 & 3 - - - - - - - WF20A Total - - - - - - - - - - WF21B 101 GENERAL FUND Olivenhain Evacuation Plan 47,332 48,995 - - 48,995 47,332 (1,663) WF21B Total 47,332 - - 48,995 - - - 48,995 47,332 (1,663) - - Grand Total 83,245,700 10,475,231 290,535 11,570,844 (157,669) - 56,935,474 68,506,318 93,853,797 25,347,479 6 of 62022-06-22 Item #08Y Page 35 of 41 ATTACHMENT 5 FISCAL YEAR 2021-22 FUND 402 CAPITAL PROJECTS (As of March 31, 2022) Project Number Funding Source Project Description Previous Appropriation Current FY Funding Off-Cycle Funding Fiscal YTD Expenses Net Transfers CIP Adjustments Previous Costs Project Cost to Date Project Budget Remaining Balance as of 3/31/22 CD17A 101 GENERAL FUND Leucadia Flooding Issues 487,963 - - 480,103 480,103 487,963 7,860 CD17A Total 487,963 - - - - - 480,103 480,103 487,963 7,860 CD20A 101 GENERAL FUND Cottonwood Creek Basin Maintenance 200,000 291,250 157,669 66,419 357,669 357,669 (0) CD20A Total 200,000 - - 291,250 157,669 - 66,419 357,669 357,669 (0) CP20A 101 GENERAL FUND Public Arts Pedestals 33,750 - - 33,221 33,221 33,750 529 CP20A Total 33,750 - - - - - 33,221 33,221 33,750 529 CS17B 101 GENERAL FUND Birmingham Drive - Complete Streets 785,413 63,150 187,000 617,062 680,212 972,413 292,201 CS17B 233 TRAFFIC MIT FUND Birmingham Drive - Complete Streets 300,000 - - 300,000 300,000 300,000 - CS17B Total 1,085,413 - - 63,150 187,000 - 917,062 980,212 1,272,413 292,201 CS17E 101 GENERAL FUND Hwy 101 Pedestrian Crossing 104,508 29,258 - 7,000 36,258 104,508 68,250 CS17E 223 FEDERAL CAPITAL GRANT FUND Hwy 101 Pedestrian Crossing 316,000 132,762 - 250 133,012 316,000 182,988 CS17E Total 420,508 - - 162,021 - - 7,250 169,271 420,508 251,237 CS17G 295 ELLD FUND Street Light & Traffic Signal Replacements 350,000 50,000 32,584 - 301,795 334,380 400,000 65,620 CS17G 297 ZONE H FUND Street Light & Traffic Signal Replacements 80,000 10,406 - 22,253 32,660 80,000 47,340 CS17G Total 430,000 50,000 - 42,991 - - 324,049 367,039 480,000 112,961 CS17H 223 FEDERAL CAPITAL GRANT FUND Streetlight Conversion Project 718,000 - - 47,053 47,053 718,000 670,947 CS17H 295 ELLD FUND Streetlight Conversion Project 38,250 - - - - 38,250 38,250 CS17H 297 ZONE H FUND Streetlight Conversion Project 4,250 - - - - 4,250 4,250 CS17H Total 760,500 - - - - - 47,053 47,053 760,500 713,447 CS18B 101 GENERAL FUND Leucadia Blvd Roundabout at Hygeia 1,325,000 1,600 - 147,829 149,429 1,325,000 1,175,571 CS18B 201 GAS TAX (HUTA) FUND Leucadia Blvd Roundabout at Hygeia 1,000,000 - - 390,431 390,431 1,000,000 609,569 CS18B 233 TRAFFIC MIT FUND Leucadia Blvd Roundabout at Hygeia 1,046,234 - - - - 1,046,234 1,046,234 CS18B Total 3,371,234 - - 1,600 - - 538,260 539,860 3,371,234 2,831,374 CS18D 101 GENERAL FUND Installation of Innovative Bike Lane Treatment (ROW Re-Utilization) 175,000 25,000 108 (40,000) 130,303 130,411 160,000 29,589 CS18D Total 175,000 25,000 - 108 (40,000) - 130,303 130,411 160,000 29,589 Page 1 of 32022-06-22 Item #08Y Page 36 of 41 ATTACHMENT 5 FISCAL YEAR 2021-22 FUND 402 CAPITAL PROJECTS (As of March 31, 2022) Project Number Funding Source Project Description Previous Appropriation Current FY Funding Off-Cycle Funding Fiscal YTD Expenses Net Transfers CIP Adjustments Previous Costs Project Cost to Date Project Budget Remaining Balance as of 3/31/22 CS18E 101 GENERAL FUND General Mobility Improvements 1,055,802 300,000 64,188 (247,000) 641,706 705,894 1,108,802 402,908 CS18E 222 CDBG FUND General Mobility Improvements 10,000 - - 10,000 10,000 10,000 - CS18E 233 TRAFFIC MIT FUND General Mobility Improvements 85,000 - - 80,498 80,498 85,000 4,502 CS18E Total 1,150,802 300,000 - 64,188 (247,000) - 732,204 796,391 1,203,802 407,411 CS20B 101 GENERAL FUND El Camino Mobility Striping Improvements 526,722 - - 506,690 506,690 526,722 20,032 CS20B Total 526,722 - - - - - 506,690 506,690 526,722 20,032 CS20C 101 GENERAL FUND Balour Corridor Improvements 50,000 - - 36,208 36,208 50,000 13,792 CS20C 233 TRAFFIC MIT FUND Balour Corridor Improvements 300,000 - - - - 300,000 300,000 CS20C Total 350,000 - - - - - 36,208 36,208 350,000 313,792 CS20D 101 GENERAL FUND Mackinnon ADA Sidewalk Project 302,000 189,341 - 1,876 191,217 302,000 110,783 CS20D 222 CDBG FUND Mackinnon ADA Sidewalk Project 248,000 186,545 - 61,372 247,916 248,000 84 CS20D Total 550,000 - - 375,885 - - 63,248 439,133 550,000 110,867 CS20E 101 GENERAL FUND S. Coast HWY 101 Safety & Mobility 931,292 - - 930,674 930,674 931,292 618 CS20E 201 GAS TAX (HUTA) FUND S. Coast HWY 101 Safety & Mobility 29,332 - - 29,332 29,332 29,332 - CS20E Total 960,624 - - - - - 960,006 960,006 960,624 618 CS20G 223 FEDERAL CAPITAL GRANT FUND El Camino Real - Z Crossing 517,600 - - - - 517,600 517,600 CS20G Total 517,600 - - - - - - - 517,600 517,600 CS20H 223 FEDERAL CAPITAL GRANT FUND N. Coast Hwy 101-Pedestrian Beacon 490,100 38,456 - 250 38,706 490,100 451,394 CS20H Total 490,100 - - 38,456 - - 250 38,706 490,100 451,394 WC17A 101 GENERAL FUND Climate Action Plan - Mitigation Measures 347,360 136,500 58,786 - 256,701 315,487 483,860 168,373 WC17A 101 GENERAL FUND Climate Action Plan - Grant Go By Bike 3,000 - - 3,000 3,000 3,000 - WC17A Total 350,360 136,500 - 58,786 - - 259,701 318,487 486,860 168,373 WC17B 101 GENERAL FUND Vulcan & San Elijo Active Transp Improv Study 100,000 - - 10,279 10,279 100,000 89,721 WC17B Total 100,000 - - - - - 10,279 10,279 100,000 89,721 WC18A 101 GENERAL FUND 800 MHZ Radio Upgrades 166,270 84,674 84,617 - 164,734 249,351 250,944 1,593 Page 2 of 32022-06-22 Item #08Y Page 37 of 41 ATTACHMENT 5 FISCAL YEAR 2021-22 FUND 402 CAPITAL PROJECTS (As of March 31, 2022) Project Number Funding Source Project Description Previous Appropriation Current FY Funding Off-Cycle Funding Fiscal YTD Expenses Net Transfers CIP Adjustments Previous Costs Project Cost to Date Project Budget Remaining Balance as of 3/31/22 WC18A 223 FEDERAL CAPITAL GRANT FUND 800 MHZ Radio Upgrades ( FY16 SHSP Grant) 146,830 39,882 39,939 - 146,354 186,293 186,712 419 WC18A 230 CSA-17 800 MHZ Radio Upgrades 121,000 16,700 14,003 - 120,826 134,829 137,700 2,871 WC18A Total 434,100 141,256 - 138,559 - - 431,914 570,473 575,356 4,883 WC18C 253 AFFORDABLE HOUSING ACQUISITION FUND Affordable Housing Acquisition 1,435,476 - (235,000) - - 1,200,476 1,200,476 WC18C Total 1,435,476 - - - (235,000) - - - 1,200,476 1,200,476 WC18D 561 PACIFIC PINES FUND Pacific Pines Maintenance Schedule 84,110 15,172 30,469 - 41,975 72,445 99,282 26,837 WC18D Total 84,110 15,172 - 30,469 - - 41,975 72,445 99,282 26,837 WC18E 101 GENERAL FUND Tech Infrastructure Replacement 1,525,195 512,000 440,361 - 1,244,751 1,685,112 2,037,195 352,083 WC18E 213 GOVT EDUC ACCESS FUND Tech Infrastructure Replacement 12,210 31,667 - - 12,210 12,210 43,877 31,667 WC18E Total 1,537,405 543,667 - 440,361 - - 1,256,962 1,697,322 2,081,072 383,750 WC18F 101 GENERAL FUND ADA/Section 504 Update of Self Evaluation & Transition Plan 75,000 - - - - 75,000 75,000 WC18F Total 75,000 - - - - - - - 75,000 75,000 WC20A 101 GENERAL FUND Broadband Master Planning - - - - - - - WC20A Total - - - - - - - - - - WC20B 101 GENERAL FUND Electric Vehicle Charging Station 50,000 - - - - 50,000 50,000 WC20B Total 50,000 - - - - - - - 50,000 50,000 WC20C 101 GENERAL FUND Vulcan Ave. Traffic Calming 100,000 1,783 - - 1,783 100,000 98,217 WC20C Total 100,000 - - 1,783 - - - 1,783 100,000 98,217 WC20E 101 GENERAL FUND Local Roadway Safety Plan 8,000 3,144 - 4,618 7,762 8,000 238 WC20E 203 STATE CAPITAL GRANT FUND Local Roadway Safety Plan 72,000 28,293 - 41,562 69,855 72,000 2,145 WC20E Total 80,000 - - 31,436 - - 46,180 77,616 80,000 2,384 WD17A 101 GENERAL FUND Stormwater Capture and Reuse Study 100,000 - - 55,554 55,554 100,000 44,446 WD17A Total 100,000 - - - - - 55,554 55,554 100,000 44,446 Grand Total 15,856,667 1,211,595 - 1,741,042 (177,331) - 6,944,891 8,685,934 16,890,931 8,204,997 Page 3 of 32022-06-22 Item #08Y Page 38 of 41 ATTACHMENT 5 FISCAL YEAR 2021-22 FUND 403 FACILITY CAPITAL PROJECTS (As of March 31, 2022) Project Number Funding Source Project Description Prev. Appropriation Current FY Funding Off-Cycle Funding Fiscal YTD Expenses Net Transfers CIP Adjustments Previous Costs Project Cost to Date Project Budget Remaining Balance as of 3/31/22 CF16A 101 GENERAL FUND Civic Center Improvements 2,024,077 300,000 (1,183,640)40,662 - 789,732 830,395 1,140,437 1,140,437 CF16B 101 GENERAL FUND Fire Stations Improvements 581,577 30,000 4,832 - 314,714 319,546 611,577 611,577 CF16D 101 GENERAL FUND PW Facility Improvements 765,851 50,000 - - 578,969 578,969 815,851 815,851 CF16E 101 GENERAL FUND ADA Facilities Compliance 100,000 - - - - 100,000 100,000 CF16F 101 GENERAL FUND Library Improvements 371,000 150,000 8,250 - 250,042 258,292 521,000 521,000 CF18A 101 GENERAL FUND ADA Parking Lot Upgrades 435,000 300,000 - - 291,171 291,171 735,000 735,000 CF18B 101 GENERAL FUND Community Center Improvements 551,533 100,000 15,024 - 124,799 139,822 651,533 651,533 CF20A 101 GENERAL FUND Lifeguard Facility Improvements 185,000 25,000 8,163 - 53,280 61,442 210,000 210,000 CF20D 101 GENERAL FUND Pacific View Improvements 96,566 38,897 - 56,594 95,491 96,566 96,566 CF22A 101 GENERAL FUND City Hall Improvements Phase 2 1,183,640 151,190 151,190 1,183,640 Grand Total 5,110,604 955,000 - 267,017 - - 2,459,300 2,726,318 4,881,964 6,065,604 1 of 12022-06-22 Item #08Y Page 39 of 41 ATTACHMENT 5 FISCAL YEAR 2021-22 FUND 512 CSD CAPITAL PROJECTS (As of March 31, 2022) Project Number Funding Source Project Description Prev. Appropriation Current FY Funding Off-Cycle Funding Fiscal YTD Expenses Transfers Out Transfers In CIP Adjustments Previous Costs Project Cost to Date Project Budget Remaining Balance as of 3/31/22 CC04E 512 CSD Collection System Rehab 3,816,691 300,000 88,354 2,098,733 2,187,087 4,116,691 1,929,604 CC04J 512 Olivenhain Trunk Improvements 12,316,982 700,000 1,302,940 5,814,778 7,117,718 13,016,982 5,899,264 CC16B 512 Sewer Master Plan Update 133,234 - 107,894 107,894 133,234 25,340 CC20A 512 SEJPA Plant Improvements 419,391 - 419,391 419,391 419,391 - CC20B 512 Cardiff Pump Station/SEJPA Force Main 420,000 - 420,000 420,000 420,000 - CC21A 512 SEJPA Plant Improvements - - (259,658) - - (259,658) (259,658) CC22A 512 SEJPA Plant Improvements 757,650 530,208 259,658 497,992 1,028,200 1,017,308 (10,892) Grand Total 17,863,948 1,000,000 - 1,921,502 (259,658) 259,658 - 9,358,788 11,280,290 18,863,948 7,583,658 1 of 12022-06-22 Item #08Y Page 40 of 41 ATTACHMENT 5 FISCAL YEAR 2021-22 FUND 522 ESD CAPITAL PROJECTS (As of March 31, 2022) Project Number Funding Source Project Description Prev. Appropriation Current FY Funding Off-Cycle Funding Fiscal YTD Expenses Transfers Out Transfers In CIP Adjustments Previous Costs Project Cost to Date Project Budget Remaining Balance as of 3/31/22 CE04A 522 Batiquitos 2004 Pump Station Improvements 2,910,457 90,000 38,000 2,468 - 2,791,499 2,793,967 3,038,457 244,490 CE04A 522 Batiquitos 2004 Pump Station Improvements 163 - 163 163 163 - CE04A Total 2,910,620 90,000 38,000 2,468 - - - 2,791,662 2,794,130 3,038,620 244,490 CE04H 522 Collection System Rehabilitation 7,137,685 500,000 49,628 - 1,714,449 1,764,076 7,637,685 5,873,608 CE04H Total 7,137,685 500,000 - 49,628 - - - 1,714,449 1,764,076 7,637,685 5,873,608 CE16A 522 Master Plan Update 133,234 - 107,894 107,894 133,234 25,340 CE16A Total 133,234 - - - - - - 107,894 107,894 133,234 25,340 CE17C 522 Poinsettia Gravity Sewer Line 242,786 - - 242,786 242,786 242,786 - CE17C 522 Poinsettia Gravity Sewer Line 3,627 - - 3,627 3,627 3,627 - CE17C Total 246,413 - - - - - - 246,413 246,413 246,413 - CE21B 522 Encina Plant Improvement 1,748,950 875,876 - (1,542,044) - 1,082,782 1,082,782 1,082,782 - CE21B Total 1,748,950 875,876 - - (1,542,044) - - 1,082,782 1,082,782 1,082,782 - CE22B 522 Encina Plant Improvement - - 475,594 1,542,044 - 475,594 1,542,044 1,066,450 CE22B Total - - - 475,594 - 1,542,044 - - 475,594 1,542,044 1,066,450 CE22D 522 Moonlight Beach Pump Station Rehabilitation - 375,000 375,000 - - 375,000 375,000 - CE22D Total - 375,000 - 375,000 - - - - 375,000 375,000 - Grand Total 12,176,901 1,840,876 38,000 902,690 (1,542,044) 1,542,044 - 5,943,199 6,845,889 14,055,777 7,209,888 1 of 12022-06-22 Item #08Y Page 41 of 41