Loading...
2023-02-15 Item 08D FY 22-23 Mid-Year Budget StatusMEETING DATE: February 15, 2023 PREPARED BY: Kelly Sanderson, Finance Manager DEPT. DIRECTOR: Teresa S. McBroome DEPARTMENT: Finance CITY MANAGER: Pamela Antil SUBJECT: Fiscal Year 2022-23 Mid-Year Operating 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 2022-23 Mid-Year Operating Budget Status Report; and 2. Adopt Resolution No. 2023-13 titled “A Resolution of the City Council of the City of Encinitas Amending the Fiscal Year 2022-23 Budget” (Attachment 1). 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. The action involves an organizational or administrative activity of government that will not result in the direct or indirect physical change in the environment. This item is not related to the Climate Action Plan. 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 purpose of this report is to provide an update on the current fiscal year (FY) operating budget and submit recommendations for additional budget amendments. After six months of activity, FY 2022-23 revenues are expected to exceed estimates by year- end, and budgeted expenditures are anticipated to be less than budgeted. 2023-02-15 Item #08D Page 1 of 31 The proposed midyear budget adjustments for all funds will: Increase estimated revenue by $1.7 million; Increase budgeted expenditures by $3.4 million; and Increase budgeted interfund transfers for a $0.1 million favorable impact to operating funds and a $0.03 million reduction in capital funds. The proposed budget adjustments for the General Fund will: Increase estimated revenue by $1.1 million; Increase budgeted expenditures by $1.9 million; and Adjust interfund transfers for a net $0.37 million favorable impact to fund balance, primarily due to a reduction in the operating transfer to the Self Insurance Fund. The Budgetary Fund Balance Summary (Attachment 2) includes the audited General Fund balance as of July 1, 2022. Appropriations approved by the City Council are deducted from the unassigned fund balance to project the budgetary fund balance available for appropriation. If City Council approves the proposed midyear adjustments, the unassigned General Fund balance available for Council appropriation is projected at $2.5 million. BACKGROUND: The City of Encinitas fiscal year starts July 1 and ends June 30. On June 15, 2022, the City Council adopted Resolution 2022-66, approving the FY 2022-23 Operating Budget and the Capital Improvement Program with appropriations. A budget appropriation provides legal authorization from the governing body to expend public funds for a specific purpose. The budget also contains financial, operational, and capital plans developed and approved for implementation as part of the budget process. Budget projections are used to estimate available fund balance because actual balances are not finalized until financial audit is completed each fall. On January 25, 2023, the City Council received the Report on the Financial Results for FY 2021-22. The General Fund ending fund balance totaled $29,328,060 as of June 30, 2022. After deducting fund balances classified as non-spendable, restricted, and committed to budget stabilization and contingency reserves, $10,452,438 in unassigned fund balance was available for City Council appropriation at the beginning of FY 2022-23. (For additional details, see the Annual Comprehensive Financial Report for Year Ended June 30, 2022, Note 11 – Fund Balance and Net Position Classifications). Throughout the year, the Budgetary Fund Balance Summary is updated to monitor the unassigned General Fund balance that can be appropriated. Amendments to the budget may be brought to the City Council for consideration throughout the fiscal year. Offcycle amendments are proposed when agenda items require an additional appropriation related to awarding a contract or purchase. Quarterly amendments are generally submitted along with updated revenue and expenditure forecasts. This helps ensure that adequate funding sources are identified prior to recommending additional appropriations. Regular budget monitoring is a best practice that helps organizations enforce accountability related to spending. Quarterly Budget Status Reports comparing budget to actuals, as well as past results, are used to evaluate overall financial performance. This process helps identify trends that could impact future operations and demonstrates transparency by sharing findings. While the Finance Department reviews all funds, status reports focus on the General Fund —which is the City’s largest and most discretionary source of funding for operations, debt service and capital improvements, via both direct expenditures and transfers to other City funds. 2023-02-15 Item #08D Page 2 of 31 ANALYSIS: General Fund revenues are expected to exceed estimates by year-end, and budgeted expenditures are anticipated to be less than budgeted. The General Fund Summary of Revenue, Expenditures, and Transfers (Attachment 3 – Schedule C #F4) shows budget versus actual activity through December 31, 2022. General Fund revenues are $37.2 million, or 40 percent of estimated revenue. Historical trends show actual revenues for the prior three years ranging between 38 and 39 percent of budget at midyear. The slight increase is primarily due to increases in transient occupancy tax along with higher than anticipated building inspection and plan check activity related to several large Housing Element sites. General Fund expenditures are $32.2 million, or 38 percent of budgeted appropriations. Historical trends show actual expenditures for the prior three years ranging between 41% and 46% of budget at midyear. The slight decrease is primarily due to timing of Sheriff’s contract invoices and vacancy-related personnel savings. General Fund Revenue Midyear revenue results reflect known seasonality and timing issues observed by the City in prior years. Additional context for specific categories is provided below. Property Tax. Midyear actuals total $20.7 million, or 36 percent of estimated revenue. Timing of receipts reflects prior year trends where most tax revenue is received in the third and fourth quarters of the fiscal year following the December and April property tax payment deadlines. Also, two payments distributing taxes in lieu of vehicle license fees typically occur in January and May. Due to the timing of tax assessments and payments, midyear revenue reflects statewide and regional trends of homes selling at increased assessed values in calendar year 2021 where there were both increases in the number of sales and unprecedented increases in sale prices 2023-02-15 Item #08D Page 3 of 31 due in part to low lending rates and driven by pent up demand after the year of lockdown in 2020 due to the COVID pandemic. Calendar year 2022 interest rate hikes and slower home sales would impact FY 2023-24 property tax receipts, not the current fiscal year. Sales Tax. Midyear actuals total $6.3 million, or 39 percent of estimated revenue. Historically, revenue is generally higher in the second half of the fiscal year due to relatively larger receipts from sales during the holiday season. While inflation is a general concern, post-pandemic spending on restaurants, travel, and lodging has remained strong due to pent up demand. It should be noted that sales tax revenue is expected to flatten in future years. As online sales replace brick-and-mortar purchases, a greater portion of sales tax is allocated to the County pool instead of the city where the item was purchased. General consumer goods sales are expected to continue to soften as customers slowly adjust to inflation cost increases related to food and gas prices. A cannabis business tax measure was passed by voters in November 2022. Revenue has not yet been budgeted or received in FY 2022-23, as the retail program is still being established. Transient Occupancy Tax. Midyear actuals total $2.4 million or 71 percent of estimated revenue. This is largely due to the rebound in tourism after pandemic restrictions were lifted. Increased enforcement on short term vacation rentals resulted in more permitted sites, along with one-time payments of delinquent taxes and related penalties. Other Revenue. Other non-tax revenue categories total $6.7 million, or 40 percent of the estimated total revenue. This reflects known seasonality and timing issues, such as: Licenses and permits increases reflect enhanced enforcement of unpermitted short-term rentals. Most franchise fee revenue is received in the second half of the fiscal year. Intergovernmental revenue from the Cooperative Agreement for Fire Management Services with the Cities of Del Mar and Solana Beach is typically received in the second half of the fiscal year. Charges for services can vary based on changes in activity or fee amounts. Development Services variances are typically related to fee increases or surges in development activity. FY 2022-23 increases are related to building inspections and plan checks completed on several large Housing Element Sites. Outdoor recreation program registrations increase between Memorial Day and Labor Day. Fines and penalties revenue reflects increased parking penalties related to citywide enforcement. This is a result of Ordinance 2022-05 passed in April of 2022 which allows the City to utilize a private enforcement company in addition to the Sheriff and City staff. Because most of the City’s revenue is received in the second half of the year, adjustments are typically made during the Third Quarter Budget Status Report. One exception is pass-through revenue that carries a variable cost based on actual activity—like the portion of building fees paid to Esgil. Net $0 revenue and expenditure budget adjustments can be needed earlier in the year to pay contracted vendors for revenue-generating services performed. 2023-02-15 Item #08D Page 4 of 31 General Fund Expenditures Midyear expenditure results reflect known seasonality and timing issues observed by the City in prior years. Additional context for specific categories is provided below. Personnel. Midyear actuals total $23.2 million or 53 percent of budgeted expenditures. The percentage of personnel expenditures is typically slightly higher in the first and second quarters than other quarters due to retiree health and Other Post-Employment Benefits payments that are made entirely as a one-time payment in the first quarter, in addition to a lump sum payment made to CalPERS to reduce the City’s unfunded pension liability. Additionally, firefighter overtime is usually higher in the fall and winter due to strike team deployments to wildfires throughout California (which is reimbursable). Contracts & Services. Midyear actuals total $8.3 million or 22 percent of budgeted expenditures. This is largely due to the timing of the Sheriff’s department invoicing. For example, FY 2022-23 midyear actuals only reflect three months of law enforcement services because the Sheriff’s department issues more invoices in the second half of the fiscal year than in the first half. Expenditures for parking citations appear artificially low because staff processed a net $0 administrative adjustment—needed to pay vendors pass-through costs for the related services for the remainder of the year. Recreation program revenue and related payments to instructors both increased as demand for in-person instruction returns to pre-pandemic levels. Global and regional increases in energy costs have impacted the budget for many divisions, especially Public Works. Materials & Supplies. Midyear actuals total $0.5 million or 33 percent of budgeted expenditures. Citywide expenditures on materials and supplies are typically lower during the first six months of the fiscal year. Fuel budgets, prepared in the spring, assumed costs around $4 per gallon, and did not anticipate the $5 to $6 prices paid in the summer and fall of 2022. General Fund Transfers Transfers involve moving budgeted appropriations between funds, including the capital project funds. Midyear actuals total $32.8 million or 92 percent of budget. This is primarily attributable to transfers out to the Capital Improvement Project funds that are recorded in the same period 2023-02-15 Item #08D Page 5 of 31 as the July budget appropriation. FY 2022-23 included a one-time $20 million for the I-Bank loan for the Leucadia Streetscape project. Staff is proposing a $0.3 million reduction in the operating transfer to the Self Insurance Fund (601) because analysis shows the existing fund balance can support projected expenditures and a smaller subsidy is needed in FY 2022-23. A $0.18 million transfer-in to the Wastewater Support Fund (611) and $0.33 million transfer-in to the Fleet Maintenance Fund (621) are needed to correct negative balances resulting from an accounting change to the way Internal Service Funds’ share of pension (unfunded accrued liability) and Other Post-Employment Benefits expenses are recorded. Proposed Budget Amendments (Attachment 1 – Exhibit A) Detailed explanations for proposed budget amendments are included in the Budget Resolution. The table below summarizes the net impact of proposed budget amendments to fund balance. Capital Funds 401 and 402 are closing completed projects and returning unspent budget to the funding source. A summary of Capital and Work Project activity through September 30, 2022 is provided in Attachment 4. Staff is also requesting ratification for two net $0 administrative adjustments that increase revenue and expenditures in equal amounts. Administrative adjustments typically need to be 2023-02-15 Item #08D Page 6 of 31 entered prior to the budget status report so staff can remit variable costs related to increased activity. In this case, parking citation revenue and related pass-through payments exceeded 50 percent of the budget only a few months into the year. ATTACHMENTS: 1. Resolution No. 2023-13 titled “A Resolution of the City Council of the City of Encinitas Amending the Fiscal Year 2022-23 Budget” 2. General Fund Budgetary Fund Balance Summary 3. General Fund Summary of Revenue, Expenditures, and Transfers (Schedule C #F4) as of December 31, 2022 4. Capital Fund Activity as of September 30, 2022 2023-02-15 Item #08D Page 7 of 31 ATTACHMENT 1 RESOLUTION NO. 2023-13 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF ENCINITAS AMENDING THE FISCAL YEAR 2022-23 ADOPTED BUDGET WHEREAS, on June 15, 2022, the City Council of the City of Encinitas adopted Resolution Number 2022-66 adopting the budget for Fiscal Year 2022-23; WHEREAS, changes in anticipated revenues and/or expenditures of the City of Encinitas necessitates amendments to the appropriations for Fiscal Year 2022-23; WHEREAS, budgeted expenditures do not exceed anticipated revenue and available fund balance; WHEREAS, the City Council has reviewed the proposed Fiscal Year 2022-23 budget amendments; and NOW, THEREFORE, BE IT RESOLVED by the City Council of the City of Encinitas that the budget amendments for Fiscal Year 2022-23 as contained in Exhibit A to this resolution are hereby adopted. PASSED, APPROVED AND ADOPTED, this 15th day of February 2023, by the City Council of the City of Encinitas, State of California. _________________________________ Tony Kranz, Mayor ATTEST: ________________________________ Kathy Hollywood, City Clerk APPROVED AS TO FORM: _____________________________ Tarquin Preziosi, City Attorney 2023-02-15 Item #08D Page 8 of 31 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 15th day of February 2023 by the following vote: AYES: NOES: ABSENT: ABSTAIN: ____________________________ Kathy Hollywood, City Clerk 2023-02-15 Item #08D Page 9 of 31 Resolution 2023‐13 Exhibit A Proposed Midyear Budget Amendments Increase Line Description (Alpha Sort)Additional Description Project Org Object Decrease Amount 1 CC23A Cardiff Force Main  Relocation Additional capital project funding.  Cardiff Force Main Relocation  Project related to construction  encountering an abandoned  sewer line and ground water. CC23A‐5 51296662 540 I 57,104 2 51190999 498.2 I 57,104 3 51200000 398.2 I 57,104 4 CP14A Olympus Park Close project and return available  budget to Fund 229. CP14A‐2 40195229 530 D 9,436 5 40190999 498.2 I 9,436 6 22900000 398.2 I 9,436 7 Close project and return available  budget to Fund 235. CP14A‐2 40195235 999 D 4,849 8 40190999 498.2 I 4,849 9 23500000 398.2 I 4,849 10 CP22A Beacon's Beach Parking Lot  transfer from WC17A CP22A design and construction  scope increase related to conduit  and meter for future EV charging  stations. WC17A‐ 40295101 590 D 50,000 11 CP22A‐1 40195101 590 I 50,000 12 40290999 498.2 I 50,000 13 10100000 398.2 I 50,000 14 10190999 498.2 I 50,000 15 40100000 398.2 I 50,000 16 CX16F Emergency Repair H101  Monitoring Close project and return available  budget to funding source. CX16F‐1 40195101 590 D 20,357 17 10100000 398.2 I 20,357 18 40190999 498.2 I 20,357 19 EKG Defibrillator Software,  Training, and Reserve Unit EKG Monitor/Defibrillator  software, training system, and  reserve AutoPulse ‐ Upgrade  existing cardiac monitors to  provide more advanced  prehospital EKG system that  meets new County EMS  requirement for data retention.  Purchase a reserve  cadiopulmonary resuscitation  device to be used when a front  line unit is out of service. 23062511 432.2 I 38,900 20 476 I 29,000 21 Electricity and Natural Gas Rate  Increases Project 9 to 15% increase in CY  2023. 10171640 441.1 I 42,000 22 10171641 441.1 I 33,000 23 10171642 441.1 I 15,000 24 10171643 441.1 I 44,000 2023-02-15 Item #08D Page 10 of 31 Resolution 2023‐13 Exhibit A Proposed Midyear Budget Amendments Increase Line Description (Alpha Sort)Additional Description Project Org Object Decrease Amount 25 Electricity Rate Increases 15% projected increase in CY  2023. 29571630 441.1 I 160,000 26 29771630 441.1 I 8,000 27 Encinitas Habitat Steward EHSP During FY23 budget workshops,  Council directed staff to double  Parks and Recreation's total EHSP  budget from $50K to $100K.  Council member comments on  6/15/2022 and the City  Manager's budget transmittal  reflect this intent. 10180810 432.2 I 40,000 28 10180820 432.2 I 10,000 29 Fire Strike Team Cost Recovery Deployed to 7 different fires  throughout State Jun‐Oct 2022,  which was more deployments  than anticipated. 10162511 394 I 260,156 30 62400000 394 I 31,696 31 Fire Strike Team Expenses Deployed to 7 different fires  throughout State Jun‐Oct 2022,  which was more deployments  than anticipated. 10162511 412.1 I 144,879 32 422.1 I 4,137 33 423.1 I 19,978 34 424.1 I 2,282 35 455 I 4,162 36 466 I 664 37 Fuel Cost and Usage Increases Budget assumed $4 per gallon,  but costs are higher. Increased  usage of pool vehicles as in‐ person training and meetings  resume. 10171600 466 I 1,500 38 10171630 466 I 6,000 39 10171640 466 I 2,000 40 61171663 466 I 7,000 41 Grant Decrease FY23 CDBG to  Match HUD Award Actual FY23 grant award from  HUD was less than projected.  Need to adjust to match actual to  facilitate grant tracking and  reporting. 22200000 331.1 D 12,675 42 398.1 D 2,000 43 22251470 494.1 D 1,902 44 22290999 498.2 D 8,237 45 Nature Collective Monitoring  Ocean Cove Outfall Monitoring contract with the  Nature Collective with CEQA/CDP. 21220314 431.1 I 69,800 2023-02-15 Item #08D Page 11 of 31 Resolution 2023‐13 Exhibit A Proposed Midyear Budget Amendments Increase Line Description (Alpha Sort)Additional Description Project Org Object Decrease Amount 46 Net $0 Inspection plan check  Housing Element sites Building Inspection & Plan Check  activity is higher than anticipated.  Staff is beginning to see  inspections and plan checks  completed on several large  Housing Element sites including:  Encinitas Blvd. Apartments, Fox  Point Farms, and Clark Avenue  Apartments. Staff anticipates  seeing other Housing Element  sites complete their inspection  and plan check process before the  fiscal year is over. 10151440 343.1 I 750,000 47 432.1 I 750,000 48 Personnel Adjustments Dev  Services Adjustments related to FY23  staffing changes. 10151410 411.1 I 92,000 49 456.1 I 1,700 50 468.5 I 6,300 51 Personnel Adjustments  Engineering Adjustments related to FY23  staffing changes. 10152700 411.1 I 100,000 52 Rec Supervisor Move to Arts from  Community Senior Center Six months of personnel budget  from vacant Rec Supervisor ‐  Transfer from Recreation  Programs, Community Center &  Senior Center Programs to  Cultural Arts to support an  escalation in operational needs in  the Cultural Arts Division. 10180840 411.1 D 2,942 53 10180856 411.1 D 17,028 54 10180861 411.1 D 36,743 55 10180881 411.1 I 56,712 56 Risk Workers Comp & Legal  Adjustments Midyear adjustments.60120340 431.1 I 280,000 57 431.22 I 15,000 58 486.4 I 205,000 59 486.6 I 90,000 60 SB1383 Local Support Grant Received more SB1383 Local  Support Grant Funding than  anticipated. Additional funds will  be used to purchase  recycling/trash containers. Staff  confirmed that purchase is grant  eligible. 21471622 468.4 I 6,095 61 335.1 I 6,095 2023-02-15 Item #08D Page 12 of 31 Resolution 2023‐13 Exhibit A Proposed Midyear Budget Amendments Increase Line Description (Alpha Sort)Additional Description Project Org Object Decrease Amount 62 Section 8 vouchers 5 new In September 2022 HUD issued  PIH Notice 2022‐29 informing  Encinitas Housing Authority that  $69,948 in funding for five new  incremental vouchers was being  obligated. The purpose is to issue  five new vouchers to families who  qualify for housing assistance  through the program.  Disbursements in the amount of  $5,829 per month started in  October and will continue for a  year: 9 months in FY23 and 3  months in FY24. 55200000 331.1 I 52,461 63 55251480 494.2 I 52,461 64 SEJPA Sewer Treatment  Adjustment City budget was approved before  SEJPA's was finalized.  51171661 435.2 I 66,583 65 Streetlight Maintenance FY22  Services FY22 billing delay related to  materials. CTE invoiced in Oct for  work initiated in Feb‐June 2022 to  close out contract. Amount that  should have been billed in FY22  was $7100. 29571630 432.2 I 7,100 66 Striping Contract Adjustment Adjustment needed to match  contract. 10171630 432.2 I 69,340 67 Transfer Adjust General Fund  Operating Transfer to Risk  Management Fund 601 Review of transfers shows the  budgeted transfer can be  reduced. Fund balance is  adequate to accommodate  midyear requests. 60100000 398.1 D 295,639 68 10190901 458.2 I 295,639 69 10190999 498.1 D 295,639 70 Transfer Correct 6/30/22  Negative Balance in Fund 611  WW FY22 audit found that at June 30,  2022 Wastewater Support  internal service fund had a  negative balance of $334,590. The  adjustment is funded by 65.2%  CSD and 34.8%  ESD funds.  Negative balance resulted from  an accounting change to the way  Internal Service Funds’ share of  pension (unfunded accrued  liability) and Other Post‐ Employment Benefits (OPEB)  expenses are recorded. 61100000 391 I 334,590 71 51171661 458.2 I 218,153 72 52171661 458.2 I 116,437 2023-02-15 Item #08D Page 13 of 31 Resolution 2023‐13 Exhibit A Proposed Midyear Budget Amendments Increase Line Description (Alpha Sort)Additional Description Project Org Object Decrease Amount 73 Transfer Correct 6/30/22  Negative Balance in Fund 621 VM FY22 audit found that at June 30,  2022 Vehicle Maintenance  internal service fund had a  negative balance of $180,249. The  adjustment  is funded by a pro‐ rata calculation of the FY23  budget: 72% 101 General Fund,  7% 511 CSD, 1% ESD, 20% SDWD.  Negative balance resulted from  an accounting change to the way  Internal Service Funds’ share of  pension (unfunded accrued  liability) and Other Post‐ Employment Benefits (OPEB)  expenses are recorded. 62100000 391 I 180,249 74 10190901 458.1 I 129,779 75 51171661 458.2 I 12,618 76 52171661 458.2 I 1,802 77 WC10B Finance Studies Not needed. Studies are a  recurring expense paid from  department operating budget. WC10B‐ 40195101 592 D 46,215 78 10100000 398.2 I 46,215 79 40190999 498.2 I 46,215 80 WC17A CivicSpark Intern Overlap Outgoing intern remained on  board to train new intern. Dept is  requesting a transfer from CAP  Project to Operating because we  don't expense staffing against  Work Projects. WC17A‐ 40295101 580 D 4,495 81 40290999 498.2 I 4,495 82 10100000 398.2 D 4,495 83 10120314 411.3 I 4,172 84 421.4 I 156 85 422.1 I 60 86 423.1 I 73 87 424.1 I 33 88 WC18A 800 MHZ Radio Upgrades Close project and return available  budget to funding source. WC18A‐ 40295101 590 D 1,593 89 WC18A‐ 40295223 590 D 419 90 WC18A‐ 40295230 590 D 175 91 40290999 498.2 I 2,187 92 10100000 398.2 I 1,593 93 22300000 398.2 I 175 94 398.2 I 419 95 WC20C Vulcan Ave Traffic  Calming Close project and return available  budget to funding source. WC20C‐ 40295101 590 D 0 96 40290999 498.2 I 0 97 10100000 398.2 I 0 2023-02-15 Item #08D Page 14 of 31 Resolution 2023‐13 Exhibit A Proposed Midyear Budget Amendments for Ratification Increase Line Description (Alpha Sort)Additional Description Project Org Object Decrease Amount 1 Net $0 Ratify Parking Citation  Revenue and Expense Increased parking enforcement  efforts throughout the city have  caused increased citation  issuance and associated expense  and revenues. Adjustment is  needed to continue to process  payment to the County of SD for  citation assessment fees, Data  Ticket for citation processing,  and for the printing of citations  for the remainder of the year.  ‐ Revenue projected for the  whole year was $100K, already at  $142K through November.  ‐ As of December 8, 2022, this  adjustment should carry us  through FYE23. (blank)10151450 351.4 I 100,000 2 432.1 I 30,000 3 435.1 I 52,000 4 454 I 3,000 5 459 I 15,000 6 Net $0 Ratify CDBG CV3 FY22  Carryforward Revenue and  Expense CDBG CV3 AWARD AMOUNT  BALANCE BEING CARRIED  FORWARD FROM FY22: Left over $182,499.95 for  McAlister Plus left over $13,997.87 for CV3  Admin (from the original award  of $25,000 in FY22)  = Total carry forward balance of  $196,497.82 COV19‐22200000 331.3 I 196,498 7 22251470 494.2 I 182,500 8 COV19‐C 22251470 411.1 I 13,998 2023-02-15 Item #08D Page 15 of 31 Budgetary Fund Balance Summary Updated 2/5/23 Available Fund Balance General Fund ACFR Actual Beginning Fund Balance, 7/1/2022 29,328,060$     Less Committed Budget Stabilization/Contingency Reserve 1,846,609          Committed Operating Reserve 16,558,431        Restricted FSA Forfeitures 182,172             Nonspendable Reserve 288,410             Unassigned Fund Balance, 7/1/2022 10,452,438        City Council Action Date Title Resolution Fund 101 2022‐06‐15 Adoption of FY 2022‐23 Operating & CIP Budget 2022‐066 (5,261,683) 2022‐06‐22 CS23A Carlsbad MOU Reimbursement 2022‐069 0 2022‐06‐29 Encina Wastewater Authority FY23 Operating & Capital Budgets 2022‐085 2022‐08‐10 Fleet Purchases 2022‐088 2022‐08‐24 CD23A N Coast Hwy 101 Drainage Improvements ‐ Design 2022‐077 (356,171) CS22A Pavement Rehabilitation Overlay and Slurry Seal Project 2022‐056 CS23A OMWD Cost Collaboration Manchester Avenue 2022‐046 0 WF22A Station 3 Security Gate Grant 2022‐034 2022‐09‐14 Continuing Appropriations from FY 2021‐22 2022‐075 (849,855) 2022‐10‐12 CP22B El Portal Public Art Mosaic transfer from CP22B El Portal 2022‐098 2022‐10‐19 Citywide Landscape Services Agreement 2022‐074 (8,500) CS02G Award HSIP Traffic Signal Improvement Project Contract 2022‐104 2022‐10‐26 CS20G Construction budget transfer from CS18E 2022‐105 2022‐11‐09 CS22C S 101 Cycletrack Construction and CM&I 2022‐110 (502,006) 2022‐12‐14 VM 237 Fire Ops Utility Vehicle Replacement Cost Increase 2022‐122 2022‐12‐21 WB16C USACE Project Construction and CM&I 2022‐123 2023‐01‐18 State Specified Grants AB179  ‐ CA Dept Parks Rec OGALS 2023‐008 2023‐01‐25 Unfunded Liability Payment 2023‐005 (500,000) 2023‐02‐15 Midyear Budget Amendments 2023‐013 (440,400) Total Impact (7,918,615) Projected Unassigned Fund Balance, 6/30/2023 2,533,823 Note: The above list catalogs all budget resolutions approved this fiscal year. Some rows appear blank or $0 because they impact other funds. 2023-02-15 Item #08D Page 16 of 31 General Fund Summary of Revenue, Expenditures, and Transfers Schedule C #F4, updated 2/4/23 For 6 months ending December 31, 2022 Original Revised Jul_Dec Jul_Dec Budget Budget Actuals Over (Under)% FY 2022‐23 FY 2022‐23 FY 2022‐23 Rev Budget Used REVENUES BY SOURCE TAX REVENUE 1 PROPERTY TAX 58,110,000     58,110,000     20,706,553   (37,403,447)        36% 2DOCUMENTARY TRANSFER TAX 600,000           600,000           267,658         (332,342)              45% 3SALES TAX 16,190,000     16,190,000     6,328,534     (9,861,466)          39% 4 TRANSIENT OCCUPANCY TAX 3,420,056       3,420,056        2,444,458     (975,598)              71% 5FRANCHISE FEES 2,891,977       2,891,977        688,039         (2,203,938)          24% 6 PENALTIES & INT‐DELINQ TAXES 2,040               2,040               33,489           31,449                 1642% 7TAX REVENUE TOTAL 81,214,073     81,214,073     30,468,731   (50,745,342)        38% OTHER REVENUE 8LICENSES AND PERMITS 236,000           236,000           208,148         (27,852)                88% 9 INTERGOVERNMENTAL REVENUE 713,726           903,834           171,588         (732,246)              19% 10 CHARGES FOR SERVICES 8,249,850       8,249,850        5,193,218     (3,056,632)          63% 11 FINES AND PENALTIES 210,253           310,253           298,508         (11,745)                96% 12 USE OF MONEY AND PROPERTY 1,094,777       1,094,777        502,526         (592,251)              46% 13 OTHER REVENUE 611,793           611,793           343,585         (268,208)              56% 14 OTHER REVENUE TOTAL 11,116,399     11,406,507     6,717,574     (4,688,933)          59% 15 REVENUE TOTAL 92,330,472     92,620,580     37,186,305   (55,434,275)        40% EXPENDITURES BY FUNCTION GENERAL GOVERNMENT 16 CITY COUNCIL‐ADMINISTRATION 521,443           585,499           209,884         (375,615)              36% 17 CITY COUNCIL‐CITY ATTORNEY 985,000           985,000           198,164         (786,836)              20% 18 CITY MANAGER‐ADMINISTRATION 1,399,355       1,443,009        439,572         (1,003,437)          30% 19 CITY MANAGER‐ECONOMIC DEV 123,500           123,500           43,750           (79,750)                35% 20 CITY MANAGER‐ENVIRON (DS Re‐Org) 251,358           262,034           93,253           (168,781)              36% 21 CITY MANAGER‐HUMAN RESOURCES 1,116,400       1,173,518        466,297         (707,221)              40% 22 CITY MANAGER‐IT OPERATIONS 3,594,012       3,647,392        1,486,356     (2,161,036)          41% 23 CITY CLERK‐ADMINISTRATION 515,876           537,228           217,233         (319,995)              40% 24 CITY CLERK‐ELECTIONS 203,500           203,500           80,931           (122,570)              40% 25 FINANCE‐ADMINISTRATION 2,693,365       2,800,125        1,125,593     (1,674,532)          40% GENERAL GOVERNMENT TOTAL 11,403,809     11,760,805     4,361,032     (7,399,773)          37% 2023-02-15 Item #08D Page 17 of 31 General Fund Summary of Revenue, Expenditures, and Transfers Schedule C #F4, updated 2/4/23 For 6 months ending December 31, 2022 Original Revised Jul_Dec Jul_Dec Budget Budget Actuals Over (Under)% FY 2022‐23 FY 2022‐23 FY 2022‐23 Rev Budget Used DEVELOPMENT SERVICES 26 DEV SVC‐DIRECTOR 375,782           397,134           168,573         (228,561)              42% 27 DEV SVC‐PLAN‐ADMIN SVCS 514,762           523,623           236,465         (287,158)              45% 28 DEV SVC‐PLAN‐LAND DEVELOPMENT 3,887,877       3,951,933        1,638,843     (2,313,090)          41% 29 DEV SVC‐PLAN‐REGULATORY PERMIT 169,609           708,759           586,590         (122,169)              83% 30 DEV SVC‐PLAN‐APPLICANT DEPOSIT 3,000               3,000               ‐                 (3,000)                  0% 31 DEV SVC‐PLAN‐ADV PLANNING‐HSG 1,197,911       1,248,319        442,603         (805,716)              35% 32 DEV SVC‐PLAN‐BUILDING & CODE 2,564,714       2,564,714        1,326,393     (1,238,321)          52% 33 DEV SVC‐PLAN‐PARKING CITATION 98,500             198,500           56,814           (141,686)              29% DEVELOPMENT SERVICES TOTAL 8,812,155       9,595,982        4,456,282     (5,139,700)          46% ENGINEERING 34 ENG‐CITY ENGINEER 1,744,529       1,787,233        544,763         (1,242,470)          30% 35 ENG‐TRAFFIC ENGINEERNG 1,041,299       1,051,975        321,072         (730,903)              31% 36 ENG‐INSPECTIONS (DS Re‐Org)1,360,823       1,360,823        453,271         (907,552)              33% 37 ENGINEERING TOTAL 4,146,651       4,200,031        1,319,106     (2,880,925)          31% PUBLIC SAFETY 38 PUBLIC SAFETY‐LAW ENFORCEMENT 17,681,754     17,681,754     342,732         (17,339,022)        2% 39 PUBLIC SAFETY‐FIRE ADMIN 639,832           655,846           370,991         (284,855)              57% 40 PUBLIC SAFETY‐FIRE OPERATIONS 15,831,256     15,923,830     9,311,630     (6,612,200)          58% 41 PUBLIC SAFETY‐LOSS PREVENTION 721,845           732,521           275,847         (456,674)              38% 42 PUBLIC SAFETY‐DISASTER PREP 193,362           198,700           139,431         (59,269)                70% 43 PUBLIC SAFETY‐MARINE SAFETY 1,662,401       1,673,077        844,700         (828,377)              50% 44 PUBLIC SAFETY‐JR LIFEGUARDS 325,880           325,880           157,493         (168,387)              48% 45 PUBLIC SAFETY TOTAL 37,056,330     37,191,608     11,442,824   (25,748,784)        31% PUBLIC WORKS 46 PUBLIC WORKS‐ADMINISTRATION 588,880           617,172           240,173         (376,999)              39% 47 PUBLIC WORKS‐ENVIRONMENTAL 1,500               1,500               ‐                 (1,500)                  0% 48 PUBLIC WORKS‐STREETS 3,434,365       3,443,439        1,370,711     (2,072,728)          40% 49 PUBLIC WORKS‐FAC MAINT CVC CTR 489,872           489,872           211,012         (278,860)              43% 50 PUBLIC WORKS‐FAC MAINT FIRE ST 343,640           343,640           127,966         (215,674)              37% 51 PUBLIC WORKS‐FAC MAINT PW YRD 222,862           222,862           89,983           (132,879)              40% 52 PUBLIC WORKS‐FAC MAINT LIBRARY 406,429           406,429           155,766         (250,663)              38% 53 PUBLIC WORKS‐FAC MAINT CTR PK 420,162           420,162           155,632         (264,530)              37% 2023-02-15 Item #08D Page 18 of 31 General Fund Summary of Revenue, Expenditures, and Transfers Schedule C #F4, updated 2/4/23 For 6 months ending December 31, 2022 Original Revised Jul_Dec Jul_Dec Budget Budget Actuals Over (Under)% FY 2022‐23 FY 2022‐23 FY 2022‐23 Rev Budget Used 54 PUBLIC WORKS‐STORMWATER MAINT 694,165           694,699           298,386         (396,313)              43% 55 PUBLIC WORKS‐STORMWATER FLOOD 100,295           100,829           28,818           (72,011)                29% 56 PUBLIC WORKS‐STORMWATER PROG 815,364           826,040           323,978         (502,062)              39% 57 PUBLIC WORKS TOTAL 7,517,534       7,566,644        3,002,426     (4,564,218)          40% PARKS RECREATION & CULTURAL ARTS 58 PARKS REC‐ADMINISTRATION 1,412,777       1,469,360        584,861         (884,499)              40% 59 PARKS REC‐PARK MAINTENANCE 3,129,753       3,140,429        1,163,861     (1,976,568)          37% 60 PARKS REC‐BEACH MAINTENANCE 744,147           744,147           226,855         (517,292)              30% 61 PARKS REC‐SURF PERMITS 30,000             30,000             22,526           (7,474)                  75% 62 PARKS REC‐TRAIL MAINTENANCE 405,204           405,204           108,321         (296,883)              27% 63 PARKS REC‐RECREATION PROGRAMS 497,556           515,705           205,610         (310,095)              40% 64 PARKS REC‐COMMUNITY CENTER 929,655           951,007           394,653         (556,354)              41% 65 COMMUNITY CENTER PROGRAMS 282,468           282,468           97,127           (185,341)              34% 66 COMM CTR FACILITY RENTALS 104,214           104,214           60,088           (44,126)                58% 67 SENIOR CENTER PROGRAMS 249,491           249,491           58,265           (191,226)              23% 68 REC FACILITY PROGRAMS & EVENTS 594,018           594,018           376,503         (217,515)              63% 69 REC FACILITY RENTALS 78,827             78,827             33,207           (45,620)                42% 70 PARKS REC‐CULTURAL ARTS 350,434           369,117           143,207         (225,910)              39% 71 PARKS REC & CULTURAL ARTS TOTAL 8,808,544       8,933,987        3,475,083     (5,458,904)          39% NON‐DEPARTMENTAL 72 NON‐DEPT‐CENTRAL PURCHASES 95,298             95,298             23,523           (71,775)                25% 73 NON‐DEPT‐SHARED EXPENSES 4,951,831       4,198,851        4,081,534     (117,317)              97% 74 NON‐DEPARTMENTAL TOTAL 5,047,129       4,294,149        4,105,057     (189,092)              96% 75 EXPENDITURES TOTAL 82,792,152     83,543,206     32,161,809   (51,381,397)        38% 76 EXCESS REV OVER EXP TOTAL 9,538,320       9,077,374        5,024,497     (4,052,877)          55% TRANSFERS TRANSFERS IN/SOURCES 77 TRANSFERS IN‐OPERATING 1,176,166       1,176,166        588,083         (588,083)              50% 78 TRANSFERS IN‐CAPITAL 2,258,038       2,258,038        750,000         (1,508,038)          33% 79 TRANSFERS IN‐OTHER ‐                   ‐                    ‐                 ‐                        #DIV/0! 80 TRANSFERS IN‐DEBT SERVICE ‐                   ‐                    ‐                 ‐                        #DIV/0! 81 TRANSERS IN TOTAL 3,434,204       3,434,204        1,338,083     (2,096,121)          39% 2023-02-15 Item #08D Page 19 of 31 General Fund Summary of Revenue, Expenditures, and Transfers Schedule C #F4, updated 2/4/23 For 6 months ending December 31, 2022 Original Revised Jul_Dec Jul_Dec Budget Budget Actuals Over (Under)% FY 2022‐23 FY 2022‐23 FY 2022‐23 Rev Budget Used #DIV/0! TRANSFERS OUT #DIV/0! 82 TRANSFERS OUT ‐ OPERATING 5,966,133       5,966,133        3,699,226     (2,266,907)          62% 83 TRANSFERS OUT ‐ CAPITAL 6,938,304       27,902,515     27,902,515   ‐                        100% 84 TRANSFERS OUT ‐ OTHER ‐                   ‐                    ‐                 ‐                        #DIV/0! 85 TRANSFERS OUT ‐ DEBT SERVICE 5,329,770       5,437,585        2,620,722     (2,816,863)          48% 86 TRANSERS OUT TOTAL 18,234,207     39,306,233     34,222,463   (5,083,769)          87% #DIV/0! 87 NET TRANSFERS (14,800,003)    (35,872,029)    (32,884,380)  2,987,648            92% 88 NET INCR (DECR) TO FUND BALANCE (5,261,683)      (26,794,655)    (27,859,884)  (1,065,229)           Adj for 1x $20M I‐Bank Loan received in Fund 301 20,000,000     20,000,000   89 ADJUSTED INCR (DECR) TO FUND BAL (5,261,683)      (6,794,655)      (7,859,884)    (1,065,229)           Alternate Analysis Original Revised YTD $ Over Budget Budget Actuals (Under)% EXPENDITURES BY TYPE FY 2022‐23 FY 2022‐23 FY 2022‐23 Budget Used 90 PERSONNEL 42,780,750     43,332,543     23,152,569   (20,179,974)        53% 91 CONTRACTS & SERVICES 37,867,047     38,040,613     8,274,122     (29,766,491)        22% 92 MATERIALS & SUPPLIES 1,553,042       1,578,737        521,023         (1,057,714)          33% 93 INTERNAL COST ALLOC 428,187           428,187           214,094         (214,094)              50% 94 CAPITAL OUTLAY 36,100             36,100             ‐                 (36,100)                0% 95 DEBT/FINANCE 127,026           127,026           ‐                 (127,026)              0% 96 TOTAL EXPENDITURES 82,792,152     83,543,206     32,161,809   (51,381,397)        38% 2023-02-15 Item #08D Page 20 of 31 FISCAL YEAR 2022‐23 401 FUND CAPITAL PROJECTS (As of September 30, 2022)Project Number Funding Source Project Description Previous Appropriation  Current FY Funding  Off‐Cycle Funding Fiscal YTD Expenses Net Transfers  CIP Adjustments Previous CostsProject Cost to Date Project Budget Remaining Balance to Date CD05E 101Storm Drain Repair2,817,662           250,000              36,529                 ‐                       2,215,078           2,251,607           3,067,662           816,054              CD05E 101Storm Drain Repair Revenue13,549                 ‐                        ‐                        ‐                       13,549                13,549                13,549                ‐                       CD05E239Storm Drain Repair554,790              ‐                       ‐                       ‐                       537,844              537,844              554,790              16,946                CD05E Total3,386,001           250,000              ‐                       36,529                ‐                       ‐                       2,766,471           2,803,000           3,636,001           833,000              CD07C229Manchester Ave @ MiraCosta Drainage Improvements56,902                ‐                       ‐                       ‐                       ‐                       ‐                       56,902                56,902                CD07C Total56,902                ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       56,902                56,902                CD17B2395 Yr Habitat‐Biological & Monitoring174,474              ‐                       ‐                       ‐                       131,064              131,064              174,474              43,410                CD17B Total174,474              ‐                       ‐                       ‐                       ‐                       ‐                       131,064              131,064              174,474              43,410                CD19A203Watershed LID Retrofit20,135                ‐                       ‐                       ‐                       20,135                20,135                20,135                ‐                       CD19A Total20,135                ‐                       ‐                       ‐                       ‐                       ‐                       20,135                20,135                20,135                ‐                       CD22A101La Costa Stormwater Basin Rehab‐                       600,000              ‐                       ‐                       ‐                       ‐                       600,000              600,000              CD22A Total‐                       600,000              ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       600,000              600,000              CD23A101N Hwy 101 Drainage Improvements‐                       ‐                       356,171              ‐                       ‐                       ‐                       ‐                       356,171              356,171              CD23A Total‐                       ‐                       356,171              ‐                       ‐                       ‐                       ‐                       ‐                       356,171              356,171              CP00F101Recreational Trails Development2,510,182           ‐                       13,012                ‐                       1,391,863           1,404,875           2,510,182           1,105,307           CP00F223Recreational Trails Development18,766                ‐                       ‐                       ‐                       18,766                18,766                18,766                ‐                       CP00F229Recreational Trails Development39,685                ‐                       ‐                       ‐                       14,733                14,733                39,685                24,952                CP00F236Recreational Trails Development105,315              ‐                       ‐                       ‐                       10,980                10,980                105,315              94,335                CP00F Total2,673,948           ‐                       ‐                       13,012                ‐                       ‐                       1,436,342           1,449,353           2,673,948           1,224,594           CP04G101Park Improvement Projects1,065,412           224,589              1,050                   ‐                       691,014              692,064              1,290,001           741,480              CP04G101Park Improvement Projects1,379,623           ‐                       ‐                       ‐                       1,236,080           1,236,080           1,379,623           ‐                       CP04G229Park Improvement Projects60,000                ‐                       ‐                       ‐                       60,000                60,000                60,000                ‐                       CP04G232Park Improvement Projects221,000              ‐                       ‐                       ‐                       221,000              221,000              221,000              ‐                       CP04G Total2,726,035           224,589              ‐                       1,050                   ‐                       ‐                       2,208,094           2,209,144           2,950,624           741,480              CP05A101Habitat/Open Space Acquisition‐                       ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       CP05A231Habitat/Open Space Acquisition‐                       ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       CP05A232Habitat/Open Space Acquisition10,844                ‐                       ‐                       ‐                       6,932                   6,932                   10,844                3,913                   CP05A235Habitat/Open Space Acquisition121,280              ‐                       ‐                       ‐                       ‐                       ‐                       121,280              121,280              CP05A Total132,124              ‐                       ‐                       ‐                       ‐                       ‐                       6,932                   6,932                   132,124              125,193              CP14A101Olympus Park‐                       ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       CP14A229Olympus Park15,000                ‐                       ‐                       ‐                       5,564                   5,564                   15,000                9,436                   CP14A231Olympus Park1,749,192           ‐                       ‐                       ‐                       1,749,192           1,749,192           1,749,192           (0)                         CP14A232Olympus Park3,659,416           ‐                       ‐                       ‐                       3,659,416           3,659,416           3,659,416           (0)                         CP14A235Olympus Park216,250              ‐                       4,506                   ‐                       206,895              211,401              216,250              4,849                   CP14A Total5,639,858           ‐                       ‐                       4,506                   ‐                       ‐                       5,621,067           5,625,572           5,639,858           14,286                CP14B101Beacon's Beach Access 762,980              ‐                       ‐                       ‐                       556,518              556,518              762,980              206,462              CP14B Total762,980              ‐                       ‐                       ‐                       ‐                       ‐                       556,518              556,518              762,980              206,462              CP16A203Cardiff Beach Living Shoreline Project (Dune Restoration)3,359,257           ‐                       ‐                       ‐                       3,233,129           3,233,129           3,359,257           126,128              CP16A203Cardiff Beach Living Shoreline Project (Dune Restoration)283,074              ‐                       ‐                       ‐                       283,074              283,074              283,074              ‐                       CP16A212Cardiff Beach Living Shoreline Project (Dune Restoration)31,895                ‐                       ‐                       ‐                       31,895                31,895                31,895                ‐                       CP16A Total3,674,226           ‐                       ‐                       ‐                       ‐                       ‐                       3,548,099           3,548,099           3,674,226           126,128              CP22A101Beacon's Beach ParkingLot150,000              400,000              29,294                ‐                       38,862                68,157                550,000              481,843              CP22A203Beacon's Beach ParkingLot‐                       ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       CP22A Total150,000              400,000              ‐                       29,294                ‐                       ‐                       38,862                68,157                550,000              481,843              2023-02-15Item #08DPage 21 of 31 FISCAL YEAR 2022‐23 401 FUND CAPITAL PROJECTS (As of September 30, 2022)Project Number Funding Source Project Description Previous Appropriation  Current FY Funding  Off‐Cycle Funding Fiscal YTD Expenses Net Transfers  CIP Adjustments Previous CostsProject Cost to Date Project Budget Remaining Balance to Date CP22B101El Portal Art 129,800              ‐                       ‐                       ‐                       ‐                       ‐                       129,800              129,800              CP22B Total129,800              ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       129,800              129,800              CP22C101Beacon's Coastal Bluff Restoration142,020              ‐                       7                           ‐                       66,192                66,200                142,020              75,820                CP22C203Beacon's Coastal Bluff Restoration‐                       ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       CP22C212Beacon's Coastal Bluff Restoration8,100                   ‐                       ‐                       ‐                       ‐                       ‐                       8,100                   8,100                   CP22C223Beacon's Coastal Bluff Restoration31,000                ‐                       ‐                       ‐                       ‐                       ‐                       31,000                31,000                CP22C Total181,120              ‐                       ‐                       7                           ‐                       ‐                       66,192                66,200                181,120              114,920              CP23A101Beach Staircase Access Refurbishment‐                       392,400              ‐                       ‐                       ‐                       ‐                       392,400              392,400              CP23A Total‐                       392,400              ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       392,400              392,400              CS01E101Safe Rte 2 Schools Program (City)756,428              200,000              ‐                       ‐                       261,816              261,816              956,428              694,612              CS01E211Safe Rte 2 Schools Program (City)1,169,129           ‐                       ‐                       ‐                       1,169,129           1,169,129           1,169,129           ‐                       CS01E222Safe Rte 2 Schools Program (City)‐                       ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       CS01E Total1,925,557           200,000              ‐                       ‐                       ‐                       ‐                       1,430,945           1,430,945           2,125,557           694,612              CS02F101Traffic Safety and Calming490,000              75,000                ‐                       ‐                       409,920              409,920              565,000              155,080              CS02F211Traffic Safety and Calming126,165              ‐                       ‐                       ‐                       126,165              126,165              126,165              ‐                       CS02F233Traffic Safety and Calming85,404                ‐                       ‐                       ‐                       85,404                85,404                85,404                0                           CS02F Total701,569              75,000                ‐                       ‐                       ‐                       ‐                       621,489              621,489              776,569              155,080              CS02G101Traffic Signal Modifications25,686                ‐                       ‐                       ‐                       25,686                25,686                25,686                ‐                       CS02G211Traffic Signal Modifications434,688              ‐                       ‐                       ‐                       434,688              434,688              434,688              ‐                       CS02G223Traffic Signal Modifications581,300              ‐                       ‐                       ‐                       93,773                93,773                581,300              487,527              CS02G229Traffic Signal Modifications14,314                ‐                       ‐                       ‐                       ‐                       ‐                       14,314                14,314                CS02G233Traffic Signal Modifications225,000              50,000                960                      ‐                       121,538              122,498              275,000              152,502              CS02G234Traffic Signal Modifications40,000                ‐                       ‐                       ‐                       18,025                18,025                40,000                21,975                CS02G Total1,320,988           50,000                ‐                       960                      ‐                       ‐                       693,709              694,669              1,370,988           676,319              CS04D101No. Coast Hwy 101 Streetscape8,736,624           ‐                       20,000,000        159,825              (20,000,000)       7,627,801           7,787,626           8,736,624           948,998              CS04D203No. Coast Hwy 101 Streetscape179,865              ‐                       ‐                       ‐                       115,648              115,648              179,865              64,217                CS04D211No. Coast Hwy 101 Streetscape7,479,996           ‐                       21,747                ‐                       7,382,441           7,404,188           7,479,996           75,807                CS04D234No. Coast Hwy 101 Streetscape376,000              ‐                       ‐                       ‐                       376,000              376,000              376,000              0                           CS04D Total16,772,485        ‐                       20,000,000        181,572              (20,000,000)       ‐                       15,501,890        15,683,462        16,772,485        1,089,023           CS11C101La Costa Avenue Improvements187,500              ‐                       ‐                       ‐                       114,673              114,673              187,500              72,827                CS11C233La Costa Avenue Improvements987,500              (200,000)             ‐                       ‐                       79,317                79,317                787,500              708,183              CS11C234La Costa Avenue Improvements300,000              200,000              ‐                       ‐                       ‐                       ‐                       500,000              500,000              CS11C Total1,475,000           ‐                       ‐                       ‐                       ‐                       ‐                       193,990              193,990              1,475,000           1,281,010           CS12E233Enc Comm. Park Mitigation/Santa Fe @ Scripps38,000                ‐                       ‐                       ‐                       ‐                       ‐                       38,000                38,000                CS12E Total38,000                ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       38,000                38,000                CS13C233ECP Offsite Improvements750,000              ‐                       ‐                       ‐                       563,876              563,876              750,000              186,124              CS13C Total750,000              ‐                       ‐                       ‐                       ‐                       ‐                       563,876              563,876              750,000              186,124              CS16C101ADA Curb Ramp Project (Transition Plan Compliance)221,074              50,000                ‐                       ‐                       102,555              102,555              271,074              168,519              CS16C222ADA Curb Ramp Project (Transition Plan Compliance)40,000                ‐                       ‐                       ‐                       40,000                40,000                40,000                ‐                       CS16C Total261,074              50,000                ‐                       ‐                       ‐                       ‐                       142,555              142,555              311,074              168,519              CS16E101Montgomery Ave At‐Grade Pedestrian Rail Crossing1,946,865           ‐                       ‐                       ‐                       1,942,899           1,942,899           1,946,865           3,966                   CS16E Total1,946,865           ‐                       ‐                       ‐                       ‐                       ‐                       1,942,899           1,942,899           1,946,865           3,966                   CS16F101El Portal Ped/Bike Underpass Project7,495,456           ‐                       14,164                ‐                       7,408,565           7,422,730           7,495,456           72,726                CS16F203El Portal Ped/Bike Underpass Project‐                       ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       CS16F223El Portal Ped/Bike Underpass Project889,000              ‐                       275                      ‐                       838,947              839,222              889,000              49,778                CS16F234El Portal Ped/Bike Underpass Project1,200,000           ‐                       ‐                       ‐                       1,192,630           1,192,630           1,200,000           7,370                   2023-02-15Item #08DPage 22 of 31 FISCAL YEAR 2022‐23 401 FUND CAPITAL PROJECTS (As of September 30, 2022)Project Number Funding Source Project Description Previous Appropriation  Current FY Funding  Off‐Cycle Funding Fiscal YTD Expenses Net Transfers  CIP Adjustments Previous CostsProject Cost to Date Project Budget Remaining Balance to Date CS16F Total9,584,456            ‐                        ‐                       14,439                 ‐                        ‐                       9,440,142           9,454,581           9,584,456           129,875              CS19B 101Morning Sun Drive Sidewalk2,497,615            ‐                        ‐                        ‐                       2,497,615           2,497,615           2,497,615           0                           CS19B Total2,497,615            ‐                        ‐                        ‐                        ‐                        ‐                       2,497,615           2,497,615           2,497,615           0                           CS19E 101Santa Fe Dr Corridor Improvements301,292              300,000               ‐                        ‐                       311,954              311,954              601,292              289,338              CS19E 203Santa Fe Dr Corridor Improvements996,000               ‐                        ‐                        ‐                       211,794              211,794              996,000              784,206              CS19E222Santa Fe Dr Corridor Improvements235,181              228,360              ‐                       ‐                       ‐                       ‐                       463,541              463,541              CS19E223Santa Fe Dr Corridor Improvements692,640              ‐                       ‐                       ‐                       99,000                99,000                692,640              593,640              CS19E233Santa Fe Dr Corridor Improvements2,188,210           350,000              207,436              ‐                       454,267              661,703              2,538,210           1,876,507           CS19E Total4,413,323           878,360              ‐                       207,436              ‐                       ‐                       1,077,015           1,284,451           5,291,683           4,007,232           CS19F101N HWY 101 NCTD TEMP PARKING IMPROVEMENTS382,000              ‐                       ‐                       ‐                       376,674              376,674              382,000              5,326                   CS19F Total382,000              ‐                       ‐                       ‐                       ‐                       ‐                       376,674              376,674              382,000              5,326                   CS21A101FY2020‐21 Annual Street Overlay14,384                ‐                       ‐                       ‐                       14,384                14,384                14,384                (0)                         CS21A201FY2020‐21  Annual Street Overlay ‐ HUTA‐                       ‐                       ‐                       (147,185)             9,918                   9,918                   (147,185)             ‐                       CS21A201FY2020‐21 Annual Street Overlay ‐ RMRA SB11,849,183           ‐                       ‐                       (467,395)             1,224,685           1,224,685           1,381,788           ‐                       CS21A211FY2020‐21 Annual Street Overlay1,380,051           ‐                       ‐                       (9,395)                 1,273,042           1,273,042           1,370,655           97,613                CS21A Total3,243,618           ‐                       ‐                       ‐                       (623,975)             ‐                       2,522,029           2,522,029           2,619,643           97,613                CS21B101N. Vulcan Ave. Temp Parking Phase II400,000              ‐                       ‐                       ‐                       398,900              398,900              400,000              1,100                   CS21B239N. Vulcan Ave. Temp Parking Phase II230,128              ‐                       ‐                       ‐                       108,887              108,887              230,128              121,241              CS21B Total630,128              ‐                       ‐                       ‐                       ‐                       ‐                       507,788              507,788              630,128              122,340              CS22A101FY2021‐22 Annual Street Overlay24,484                ‐                       ‐                       ‐                       5,397                   5,397                   24,484                19,087                CS22A201FY2021‐22 Annual Street Overlay ‐ HUTA559,981              ‐                       ‐                       147,185              ‐                       ‐                       707,166              758,389              CS22A201FY2021‐22 Annual Street Overlay ‐ RMRA SB11,290,161           ‐                       ‐                       467,395              872,863              872,863              1,757,556           833,470              CS22A211FY2021‐22 Annual Street Overlay1,650,548           ‐                       5,304                   9,395                   1,051,322           1,056,626           1,659,943           603,317              CS22A Total3,525,174           ‐                       ‐                       5,304                   623,975              ‐                       1,929,582           1,934,886           4,149,149           2,214,263           CS22B203Citywide Leading Pedestrian Intervals1,234,500           ‐                       ‐                       ‐                       ‐                       ‐                       1,234,500           1,234,500           CS22B Total1,234,500           ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       1,234,500           1,234,500           CS22C101HWY 101 Seperated Bike Lanes72,210                300,000              ‐                       ‐                       26,615                26,615                372,210              345,595              CS22C203HWY 101 Seperated Bike Lanes649,890              ‐                       ‐                       ‐                       ‐                       ‐                       649,890              649,890              CS22C Total722,100              300,000              ‐                       ‐                       ‐                       ‐                       26,615                26,615                1,022,100           995,485              CS22D101Highway 101 Walkway to Solana Beach132,770              ‐                       3,856                   ‐                       15,427                19,282                132,770              113,488              CS22D203Highway 101 Walkway to Solana Beach708,930              ‐                       2,525                   ‐                       86,484                89,008                708,930              619,922              CS22D Total841,700              ‐                       ‐                       6,380                   ‐                       ‐                       101,910              108,290              841,700              733,410              CS22E101San Elijo Bridge Pavement Failure Repair475,000              ‐                       ‐                       ‐                       17,116                17,116                475,000              457,884              CS22E Total475,000              ‐                       ‐                       ‐                       ‐                       ‐                       17,116                17,116                475,000              457,884              CS22F101Leucadia Streetscape Seg B&C Mobil483,408              1,200,000           283,993              ‐                       21,166                305,159              1,683,408           1,378,249           CS22F211Leucadia Streetscape Seg B&C Mobil224,452              ‐                       113,810              ‐                       ‐                       113,810              224,452              110,642              CS22F Total707,860              1,200,000           ‐                       397,803              ‐                       ‐                       21,166                418,969              1,907,860           1,488,891           CS23A101FY2022‐23 Annual Street Overlay84,138                250,000              106,034              ‐                       ‐                       ‐                       ‐                       440,172              440,172              CS23A201FY2022‐23Annual Street Overlay ‐ HUTA‐                       ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       CS23A201FY2022‐23 Annual Street Overlay ‐ RMRA SB1‐                       1,834,898           ‐                       ‐                       ‐                       ‐                       1,834,898           1,834,898           CS23A211FY2022‐23 Annual Street Overlay‐                       1,846,000           ‐                       ‐                       ‐                       ‐                       1,846,000           1,846,000           CS23A Total84,138                3,930,898           106,034              ‐                       ‐                       ‐                       ‐                       ‐                       4,121,070           4,121,070           CS23B101Citywide Rail Corridor Quiet Zone‐                       750,000              ‐                       ‐                       ‐                       ‐                       750,000              750,000              CS23B Total‐                       750,000              ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       750,000              750,000              CS23C101Rancho Santa Fe Rd. Improvements100,000              ‐                       ‐                       ‐                       ‐                       100,000              100,000              CS23C Total‐                       100,000              ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       100,000              100,000              2023-02-15Item #08DPage 23 of 31 FISCAL YEAR 2022‐23 401 FUND CAPITAL PROJECTS (As of September 30, 2022)Project Number Funding Source Project Description Previous Appropriation  Current FY Funding  Off‐Cycle Funding Fiscal YTD Expenses Net Transfers  CIP Adjustments Previous CostsProject Cost to Date Project Budget Remaining Balance to Date CS23D101Leu Streetscape Seg C West Side6,340                   20,000,000        ‐                       6,340                   20,000,000        19,993,660        CS23D Total‐                       ‐                       ‐                       6,340                   20,000,000        ‐                       ‐                       6,340                   20,000,000        19,993,660        CX16F101Emergency Repair ‐ Hwy 101 Monitoring81,526                ‐                       ‐                       ‐                       61,169                61,169                81,526                20,357                CX16F223Emergency Repair ‐ Hwy 101 Monitoring30,986                ‐                       ‐                       ‐                       30,986                30,986                30,986                ‐                       CX16F Total112,512              ‐                       ‐                       ‐                       ‐                       ‐                       92,155                92,155                112,512              20,357                WB06A101ACOE Shoreline Protection Study127,052              ‐                       ‐                       ‐                       127,052              127,052              127,052              ‐                       WB06A203ACOE Shoreline Protection Study652,000              5,000                   ‐                       ‐                       605,804              605,804              657,000              51,196                WB06A212ACOE Shoreline Protection Study279,948              ‐                       ‐                       ‐                       177,163              177,163              279,948              102,785              WB06A212ACOE Shoreline Protection Study366,951              ‐                       ‐                       ‐                       271,184              271,184              366,951              95,767                WB06A Total1,425,951           5,000                   ‐                       ‐                       ‐                       ‐                       1,181,202           1,181,202           1,430,951           249,749              WB08C212SCOUP‐Sand Compatiblity Opportunistic Use Program1,255,962           100,000              3,705                   ‐                       880,339              884,044              1,355,962           471,918              WB08C Total1,255,962           100,000              ‐                       3,705                   ‐                       ‐                       880,339              884,044              1,355,962           471,918              WB11A101TMDL Compliance Program852,001              ‐                       2,108                   ‐                       784,783              786,890              852,001              65,111                WB11A Total852,001              ‐                       ‐                       2,108                   ‐                       ‐                       784,783              786,890              852,001              65,111                WB16A212Beach Habitat Study261,900              40,000                10,780                ‐                       151,137              161,917              301,900              139,983              WB16A Total261,900              40,000                ‐                       10,780                ‐                       ‐                       151,137              161,917              301,900              139,983              WB16B101Enhancement of Native Habitats in San Elijo Lagoon Ecological Reserve Project210,563              ‐                       ‐                       ‐                       210,563              210,563              210,563              0                           WB16B Total210,563              ‐                       ‐                       ‐                       ‐                       ‐                       210,563              210,563              210,563              0                           WB16C203Coastal Storm Damage Reduction Project860,000              160,000              ‐                       ‐                       480,676              480,676              1,020,000           539,324              WB16C212Coastal Storm Damage Reduction Project270,000              20,000                4,307                   ‐                       25,083                29,390                290,000              260,610              WB16C Total1,130,000           180,000              ‐                       4,307                   ‐                       ‐                       505,759              510,066              1,310,000           799,934              WC01A101GIS Basemap Updates and Enhancements799,600              40,000                8                           ‐                       732,975              732,982              839,600              106,618              WC01A Total799,600              40,000                ‐                       8                           ‐                       ‐                       732,975              732,982              839,600              106,618              WC08K101Open Space Mgmt Plan41,568                 ‐                        ‐                        ‐                       40,992                40,992                41,568                576                      WC08K 203Open Space Mgmt Plan23,432                 ‐                        ‐                        ‐                       23,432                23,432                23,432                 ‐                       WC08K 223Open Space Mgmt Plan9,499                    ‐                        ‐                        ‐                        ‐                        ‐                       9,499                   9,499                   WC08K Total74,499                 ‐                        ‐                        ‐                        ‐                        ‐                       64,424                64,424                74,499                10,076                WC09D 101Citywide Flood and Channel Maintenance Permitting Program267,331               ‐                       9,338                    ‐                       205,909              215,246              267,331              52,085                WC09D Total267,331              ‐                       ‐                       9,338                   ‐                       ‐                       205,909              215,246              267,331              52,085                WC10B101Fees and Other Studies199,060              ‐                       ‐                       ‐                       152,845              152,845              199,060              46,215                WC10B Total199,060              ‐                       ‐                       ‐                       ‐                       ‐                       152,845              152,845              199,060              46,215                WC11A101Encinitas Habitat Stewardship Program (Early Multi‐Habitat Conserv Plan Implementation)217,941              ‐                       ‐                       ‐                       211,142              211,142              217,941              6,799                   WC11A Total217,941              ‐                       ‐                       ‐                       ‐                       ‐                       211,142              211,142              217,941              6,799                   WC12C213Governmental/Educational Access Project‐Equipment Update2,810,870           155,000              24,986                ‐                       1,410,787           1,435,774           2,965,870           1,530,096           WC12C Total2,810,870           155,000              ‐                       24,986                ‐                       ‐                       1,410,787           1,435,774           2,965,870           1,530,096           WC13B203Safe Funding222,446              ‐                       ‐                       ‐                       190,726              190,726              222,446              31,720                WC13B Total222,446              ‐                       ‐                       ‐                       ‐                       ‐                       190,726              190,726              222,446              31,720                WC14B101Housing Element Update2,309,231           500,000              ‐                       ‐                       2,178,775           2,178,775           2,809,231           630,455              2023-02-15Item #08DPage 24 of 31 FISCAL YEAR 2022‐23 401 FUND CAPITAL PROJECTS (As of September 30, 2022)Project Number Funding Source Project Description Previous Appropriation  Current FY Funding  Off‐Cycle Funding Fiscal YTD Expenses Net Transfers  CIP Adjustments Previous CostsProject Cost to Date Project Budget Remaining Balance to Date WC14B Total2,309,231           500,000               ‐                        ‐                        ‐                        ‐                       2,178,775           2,178,775           2,809,231           630,455              WC15A 101Rail Corridor Vision442,927               ‐                        ‐                        ‐                       358,067              358,067              442,927              84,860                WC15A 203Rail Corridor Vision175,000               ‐                        ‐                        ‐                       174,825              174,825              175,000              175                      WC15A Total617,927               ‐                        ‐                        ‐                        ‐                        ‐                       532,892              532,892              617,927              85,035                WC15E 101Update Inclusionary Ordinance179,290               ‐                        ‐                        ‐                       179,290              179,290              179,290               ‐                       WC15E Total179,290               ‐                        ‐                        ‐                        ‐                       ‐                       179,290              179,290              179,290              ‐                       WC16A101Tyler Enterprise (formerly Enterprise Workflow Management (EnerGov))499,130              60,000                5,846                   ‐                       366,333              372,179              559,130              186,951              WC16A101Tyler Enterprise SDWD (formerly Enterprise Workflow Management (EnerGov))34,089                ‐                       ‐                       ‐                       34,089                34,089                34,089                ‐                       WC16A101Tyler Enterprise CSD (formerly Enterprise Workflow Management (EnerGov))34,089                ‐                       ‐                       ‐                       34,089                34,089                34,089                ‐                       WC16A101Tyler Enterprise ESD (formerly Enterprise Workflow Management (EnerGov))17,045                ‐                       ‐                       ‐                       17,045                17,045                17,045                ‐                       WC16A213Tyler Enterprise (formerly Enterprise Workflow Management (EnerGov))88                         ‐                       ‐                       ‐                       88                         88                         88                         ‐                       WC16A Total584,441              60,000                ‐                       5,846                   ‐                       ‐                       451,644              457,490              644,441              186,951              WC16D101Circulation Element of GP650,000              ‐                       24,464                ‐                       293,568              318,032              650,000              331,968              WC16D233Circulation Element of GP‐                       ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       WC16D Total650,000              ‐                       ‐                       24,464                ‐                       ‐                       293,568              318,032              650,000              331,968              WC19A101El Camino Real Streetscape Study250,000              ‐                       ‐                       ‐                       ‐                       ‐                       250,000              250,000              WC19A Total250,000              ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       250,000              250,000              WC19B101Artisitic Elements ‐ I5 Undercrossing192,567              ‐                       ‐                       ‐                       113,643              113,643              192,567              78,924                WC19B Total192,567              ‐                       ‐                       ‐                       ‐                       ‐                       113,643              113,643              192,567              78,924                WC20D203Housing Update Implementation (SB2 Grant)310,000              ‐                       1,820                   ‐                       283,683              285,503              310,000              24,498                WC20D Total310,000              ‐                       ‐                       1,820                   ‐                       ‐                       283,683              285,503              310,000              24,498                WC21A101Modal Alternatives Program50,000                ‐                       2,523                   ‐                       26,386                28,909                50,000                21,091                WC21A203Modal Alternatives Program200,000              ‐                       16,825                ‐                       115,021              131,846              200,000              68,154                WC21A Total250,000              ‐                       ‐                       19,348                ‐                       ‐                       141,407              160,754              250,000              89,246                WC21B101El Camino Real Corridor Specific Plan315,000              ‐                       11,170                ‐                       120,795              131,965              315,000              183,035              WC21B203El Camino Real Corridor Specific Plan300,000              ‐                       11,170                ‐                       103,996              115,166              300,000              184,834              WC21B Total615,000              ‐                       ‐                       22,340                ‐                       ‐                       224,791              247,131              615,000              367,869              WC22A101Rail Safety at Grade Crossings294,446              ‐                       ‐                       ‐                       10,123                10,123                294,446              284,323              WC22A Total294,446              ‐                       ‐                       ‐                       ‐                       ‐                       10,123                10,123                294,446              284,323              WC22B101Municipal Code Clean Up100,000              ‐                       ‐                       ‐                       ‐                       ‐                       100,000              100,000              WC22B Total100,000              ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       100,000              100,000              WC22C101Sixth Cycle Housing Element Implementation75,000                50,000                8,520                   ‐                       41,480                50,000                125,000              75,000                WC22C203Sixth Cycle Housing Element Implementation310,000              ‐                       58,425                ‐                       17,864                76,289                310,000              233,711              WC22C Total385,000              50,000                ‐                       66,945                ‐                       ‐                       59,344                126,289              435,000              308,711              WC23A101New Sports Courts Study for ECP‐                       30,000                ‐                       ‐                       ‐                       ‐                       30,000                30,000                WC23A Total‐                       30,000                ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       30,000                30,000                WD02A203Cottonwood Creek Runoff Plan41,575                ‐                       ‐                       ‐                       41,575                41,575                41,575                0                           WD02A Total41,575                ‐                       ‐                       ‐                       ‐                       ‐                       41,575                41,575                41,575                0                           WD19E101Leucadia Watershed Master Plan583,000              ‐                       ‐                       ‐                       465,580              465,580              583,000              117,420              WD19E Total583,000              ‐                       ‐                       ‐                       ‐                       ‐                       465,580              465,580              583,000              117,420              WF10A101Green Building Incentive Program40,000                ‐                       ‐                       ‐                       30,200                30,200                40,000                9,800                   2023-02-15Item #08DPage 25 of 31 FISCAL YEAR 2022‐23 401 FUND CAPITAL PROJECTS (As of September 30, 2022)Project Number Funding Source Project Description Previous Appropriation  Current FY Funding  Off‐Cycle Funding Fiscal YTD Expenses Net Transfers  CIP Adjustments Previous CostsProject Cost to Date Project Budget Remaining Balance to Date WF10A223Green Building Incentive Program4,000                   ‐                       ‐                       ‐                       4,000                   4,000                   4,000                   ‐                       WF10A Total44,000                ‐                       ‐                       ‐                       ‐                       ‐                       34,200                34,200                44,000                9,800                   WF15A101Pacific View Consultant Services (Pacific View Architect)100,000              ‐                       ‐                       ‐                       70,538                70,538                100,000              29,462                WF15A Total100,000              ‐                       ‐                       ‐                       ‐                       ‐                       70,538                70,538                100,000              29,462                WF21B101Olivenhain Evacuation Plan48,995                ‐                       ‐                       ‐                       48,995                48,995                48,995                ‐                       WF21B Total48,995                 ‐                        ‐                        ‐                        ‐                        ‐                       48,995                48,995                48,995                 ‐                       Grand Total90,636,860        10,561,247        20,462,205        1,100,625            ‐                        ‐                       67,913,572        69,014,198        121,660,312      52,646,111        2023-02-15Item #08DPage 26 of 31 FISCAL YEAR 2022‐23 402 FUND CAPITAL PROJECTS (As of September 30, 2022)Project Number Funding SourceProject DescriptionPrevious AppropriationCurrent FY FundingOff‐Cycle FundingFiscal YTD Expenses Net Transfers  CIP Adjustments Previous CostsProject Cost to Date Project BudgetRemaining Balance to DateCS17B101 Birmingham Drive ‐ Complete Streets972,413              ‐                       ‐                       694,974              694,974              972,413              277,439              CS17B233 Birmingham Drive ‐ Complete Streets300,000              ‐                       ‐                       300,000              300,000              300,000              ‐                       CS17B Total1,272,413           ‐                       ‐                       ‐                       ‐                       ‐                       994,974              994,974              1,272,413           277,439              CS17E 101 Hwy 101 Pedestrian Crossing104,508              ‐                       ‐                       37,772                37,772                104,508              66,736                CS17E223 Hwy 101 Pedestrian Crossing316,000              58,279                ‐                       133,012              191,292              316,000              124,709              CS17E Total420,508              ‐                       ‐                       58,279                ‐                       ‐                       170,785              229,064              420,508              191,444              CS17G295 Street Light & Traffic Signal Replacements400,000              50,000                15,556                ‐                       381,181              396,738              450,000              53,262                CS17G297 Street Light & Traffic Signal Replacements80,000                29,384                ‐                       32,660                62,044                80,000                17,956                CS17G Total480,000              50,000                ‐                       44,941                ‐                       ‐                       413,841              458,782              530,000              71,218                CS17H223 Streetlight Conversion Project718,000              ‐                       ‐                       47,053                47,053                718,000              670,947              CS17H295 Streetlight Conversion Project38,250                ‐                       ‐                       2,986                   2,986                   38,250                35,264                CS17H297 Streetlight Conversion Project4,250                   ‐                       ‐                       ‐                       ‐                       4,250                   4,250                   CS17H Total760,500              ‐                       ‐                       ‐                       ‐                       ‐                       50,039                50,039                760,500              710,461              CS18B101 Leucadia Blvd Roundabout at Hygeia1,325,000           (2,617)                 (750,000)             196,499              193,882              575,000              381,118              CS18B201 Leucadia Blvd Roundabout at Hygeia1,000,000           ‐                       ‐                       390,431              390,431              1,000,000           609,569              CS18B233 Leucadia Blvd Roundabout at Hygeia1,046,234           ‐                       ‐                       ‐                       ‐                       1,046,234           1,046,234           CS18B Total3,371,234           ‐                       ‐                       (2,617)                 (750,000)             ‐                       586,930              584,313              2,621,234           2,036,921           CS18D101 Installation of Innovative Bike Lane Treatment160,000              25,000                ‐                       ‐                       133,411              133,411              185,000              51,589                CS18D Total160,000              25,000                ‐                       ‐                       ‐                       ‐                       133,411              133,411              185,000              51,589                CS18E101 General Mobility Improvements1,088,802           600,000              ‐                       ‐                       755,487              755,487              1,688,802           933,315              CS18E222 General Mobility Improvements10,000                ‐                       ‐                       10,000                10,000                10,000                ‐                       CS18E233 General Mobility Improvements85,000                ‐                       ‐                       80,498                80,498                85,000                4,502                   CS18E Total1,183,802           600,000              ‐                       ‐                       ‐                       ‐                       845,984              845,984              1,783,802           937,818              CS20B101 El Camino Mobility Striping Improvements506,690              ‐                       ‐                       506,690              506,690              506,690              ‐                       CS20B Total506,690              ‐                       ‐                       ‐                       ‐                       ‐                       506,690              506,690              506,690              ‐                       CS20C101 Balour Corridor Improvements36,208                ‐                       ‐                       36,208                36,208                36,208                (0)                         CS20C233 Balour Corridor Improvements‐                       ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       CS20C Total36,208                ‐                       ‐                       ‐                       ‐                       ‐                       36,208                36,208                36,208                (0)                         CS20D101 Mackinnon ADA Sidewalk Project302,000              ‐                       ‐                       197,188              197,188              302,000              105,415              CS20D222 Mackinnon ADA Sidewalk Project248,000              791                      ‐                       246,522              247,313              248,000              84                         CS20D Total550,000              ‐                       ‐                       791                      ‐                       ‐                       443,710              444,501              550,000              105,499              CS20G101 El Camino Real ‐ Z Crossing20,000                ‐                       ‐                       16,925                16,925                20,000                3,075                   CS20G223 El Camino Real ‐ Z Crossing517,600              ‐                       ‐                       ‐                       ‐                       517,600              517,600              CS20G Total537,600              ‐                       ‐                       ‐                       ‐                       ‐                       16,925                16,925                537,600              520,675              CS20H223 N. Coast Hwy 101‐Pedestrian Beacon490,100              149,317              ‐                       117,129              266,446              490,100              223,654              CS20H Total490,100              ‐                       ‐                       149,317              ‐                       ‐                       117,129              266,446              490,100              223,654              WC17A101 Climate Action Plan ‐ Mitigation Measures483,860              201,500              2,636                   ‐                       342,241              344,877              685,360              340,483              WC17A101 Climate Action Plan ‐ Grant Go By Bike3,000                   ‐                       ‐                       3,000                   3,000                   3,000                   ‐                       WC17A Total486,860              201,500              ‐                       2,636                   ‐                       ‐                       345,241              347,877              688,360              340,483              WC17C101 Leo Mullen Sports Park Lighting (ERSP)0                           ‐                       ‐                       ‐                       ‐                       0                           ‐                       WC17C Total0                           ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       0                           ‐                       WC18A101 800 MHZ Radio Upgrades250,944              ‐                       ‐                       249,351              249,351              250,944              1,593                   WC18A223 800 MHZ Radio Upgrades (FY16 SHSP Grant)186,712              ‐                       ‐                       186,293              186,293              186,712              419                      WC18A230 800 MHZ Radio Upgrades137,700              ‐                       ‐                       135,434              135,434              137,700              2,266                   WC18A Total575,356              ‐                       ‐                       ‐                       ‐                       ‐                       571,078              571,078              575,356              4,278                   WC18C253 Affordable Housing Acquisition1,200,476           ‐                       ‐                       ‐                       ‐                       1,200,476           1,200,476           WC18C Total1,200,476           ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       1,200,476           1,200,476           2023-02-15Item #08DPage 27 of 31 FISCAL YEAR 2022‐23 402 FUND CAPITAL PROJECTS (As of September 30, 2022)Project Number Funding SourceProject DescriptionPrevious AppropriationCurrent FY FundingOff‐Cycle FundingFiscal YTD Expenses Net Transfers  CIP Adjustments Previous CostsProject Cost to Date Project BudgetRemaining Balance to DateWC18D561 Pacific Pines Maintenance Schedule99,282                52,964                6,858                   ‐                       78,143                85,002                152,246              67,244                WC18D Total99,282                52,964                ‐                       6,858                   ‐                       ‐                       78,143                85,002                152,246              67,244                WC18E101 Tech Infrastructure Replacement2,037,195           339,815              22,108                ‐                       1,858,178           1,880,286           2,377,010           496,723              WC18E213 Tech Infrastructure Replacement43,877                17,885                ‐                       ‐                       12,210                12,210                61,762                49,552                WC18E Total2,081,072           357,700              ‐                       22,108                ‐                       ‐                       1,870,388           1,892,497           2,438,772           546,275              WC18F101ADA/Section 504 Update of Self Evaluation & Transition Plan75,000                 ‐                        ‐                        ‐                        ‐                       75,000                75,000                WC18F Total75,000                ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       75,000                75,000                WC20A101 Broadband Master Planning‐                       ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       WC20A Total‐                       ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       WC20B101 Electric Vehicle Charging Station50,000                ‐                       ‐                       ‐                       ‐                       50,000                50,000                WC20B Total50,000                ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       50,000                50,000                WC20C101 Vulcan Ave. Traffic Calming100,000              ‐                       ‐                       96,171                96,171                100,000              3,829                   WC20C Total100,000              ‐                       ‐                       ‐                       ‐                       ‐                       96,171                96,171                100,000              3,829                   WC20E101 Local Roadway Safety Plan8,000                   ‐                       ‐                       7,762                   7,762                   8,000                   238                      WC20E203 Local Roadway Safety Plan72,000                ‐                       ‐                       69,855                69,855                72,000                2,145                   WC20E Total80,000                ‐                       ‐                       ‐                       ‐                       ‐                       77,616                77,616                80,000                2,384                   WC22D101 OUTDOOR DINING STUDIES75,000                20,374                ‐                       ‐                       20,374                75,000                54,626                WC22D Total75,000                ‐                       ‐                       20,374                ‐                       ‐                       ‐                       20,374                75,000                54,626                WF22A223 Thermal Camera and Station 3 Gate37,546                ‐                       ‐                       ‐                       ‐                       37,546                37,546                WF22A Total‐                       ‐                       37,546                ‐                       ‐                       ‐                       ‐                       ‐                       37,546                37,546                Grand Total14,592,101        1,287,164           37,546                302,688              (750,000)             ‐                       7,355,265           7,657,952           15,166,811        7,508,859           2023-02-15Item #08DPage 28 of 31 FISCAL YEAR 2022‐23 403 FUND FACILITY CAPITAL PROJECTS (As of September 30, 2022)Project Number Funding Source Project DescriptionPrevious AppropriationCurrent FY FundingOff‐Cycle FundingFiscal YTD Expenses Net Transfers CIP Adjustments Previous CostsProject Cost to Date Project BudgetRemaining Balance to DateCF16A 101 Civic Center Improvements 1,140,437 100,000 0 600 0 835,795 836,395 1,240,437 404,042CF16B 101 Fire Stations Improvements 611,577 25,000 45,000 0 0 319,546 319,546 681,577 362,031CF16D 101 PW Facility Improvements 815,851 50,000 0 0 578,969 578,969 865,851 286,882CF16E 101 ADA Facilities Compliance 100,000 0 0 0 0 0 100,000 100,000CF16F 101 Library Improvements 521,000 50,000 0 0 258,292 258,292 571,000 312,708CF18A 101 ADA Parking Lot Upgrades 735,000 0 0 0 291,171 291,171 735,000 443,829CF18B 101 Community Center Improvements 651,533 100,000 0 0 139,822 139,822 751,533 611,711CF20A 101 Lifeguard Facility Improvements 210,000 75,000 13,003 0 125,935 138,938 285,000 146,062CF20D 101 Pacific View Improvements 620,716 6,475,850 1,095 0 280,791 281,886 7,096,566 6,814,680CF22A 101 City Hall Improvements Phase 21,183,640000663,131 663,131 1,183,640 520,509CF23A101 Park Facilities Improvements0 75,0000000 75,000 75,000Grand Total6,589,754 6,950,850 45,000 14,69800 3,493,453 3,508,150 13,585,604 10,077,4542023-02-15Item #08DPage 29 of 31 FISCAL YEAR 2022‐23 512 CSD CAPITAL PROJECTS (As of September 30, 2022)Project Number Funding Source Project DescriptionPrevious AppropriationCurrent FY FundingOff‐Cycle FundingFiscal YTD Expenses Net Transfers CIP Adjustments Previous CostsProject Cost to Date Project BudgetRemaining Balance to DateCC04E 512 CSD Collection System Rehab 4,116,691 300,000 0 0 2,098,733 2,251,004 4,416,691 2,165,687CC04J 512 Olivenhain Trunk Improvements13,016,982 700,000372,93505,814,778 7,469,812 13,716,982 5,874,234CC16B512 Sewer Master Plan Update133,23400107,894 110,648 133,234 22,586CC20B512 CARDIFF Pump Station/SEJPA Force Main420,00000420,000 420,000 420,0000CC22A512 SEJPA Plant Improvements789,8660 (259,658)0 530,208 530,2080CC23A512 SEJPA Plant Improvements550,00013,378 259,65800 13,378 809,658 796,280Grand Total18,476,773 1,550,0000 386,31300 8,441,405 10,795,050 20,026,773 8,858,7872023-02-15Item #08DPage 30 of 31 FISCAL YEAR 2022‐23 FIND 522 ESD CAPITAL PROJECTS (As of September 30, 2022)Project Number Funding SourceProject DescriptionPrevious AppropriationCurrent FY FundingOff‐Cycle FundingFiscal YTD Expenses Net Transfers CIP Adjustments Previous CostsProject Cost to Date Project BudgetRemaining Balance to DateCE04A522 Batiquitos 2004 Pump Station Improvements3,075,757 125,000002,795,783 2,795,783 3,200,757 404,974CE04A522 Batiquitos 2004 Pump Station Improvements163001631631630CE04H522 Collection System Rehabilitation7,637,685 500,0001,05001,837,507 1,838,557 8,137,685 6,299,129CE16A522 Master Plan Update133,23400110,648 110,648 133,234 22,586CE17C522 Poinsettia Gravity Sewer Line242,786000242,786 242,786 242,7860CE17C522 Poinsettia Gravity Sewer Line3,6270003,627 3,627 3,6270CE21B522 Encina Plant Improvement2,624,826001,082,782 1,082,782 2,624,8260CE22B522 Encina Plant Improvement000 (848,053)693,991 693,991 (848,053)0CE22D522 Moonlight Beach Pump Station Rehabilitation375,000 1,125,00000375,000 375,000 1,500,000 1,125,000CE23B522 Encina Plant Improvement450,488 750,000 538,798700,6550 538,798 1,901,143 1,362,345Grand Total14,093,077 2,200,488 750,000 539,848 (147,398)0 7,142,287 7,682,135 16,896,167 9,214,0332023-02-15Item #08DPage 31 of 31