Loading...
HomeMy WebLinkAboutItem 23 - Fiscal Year 2022-23 Mid-Year Budget Update Finance and Management Services www.santa-ana.org/finance Item # 23 City of Santa Ana 20 Civic Center Plaza, Santa Ana, CA 92701 Staff Report February 21, 2023 TOPIC: Fiscal Year 2022-23 Mid-Year Budget Update, Revive Santa Ana Spending Plan Update, Appropriation Requests, and Workforce changes AGENDA TITLE: Fiscal Year 2022-23 Mid-Year Budget Update, Revive Spending Plan Update, Appropriation Requests and Workforce Changes RECOMMENDED ACTION 1. Receive and file the FY 2022-23 Mid-Year budget update, including an update for the Revive Santa Ana Spending Plan. 2. Approve the recommended Appropriation Adjustments. (Requires five affirmative votes) 3. Adopt a Resolution - A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF SANTA ANA TO AMEND RESOLUTION NO. 2015-026 TO EFFECT CERTAIN CHANGES TO THE CITY’S BASIC CLASSIFICATION AND COMPENSATION PLAN. 4. Adopt a Resolution - A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF SANTA ANA TO AMEND THE CURRENT FISCAL YEAR 2022-2023 ANNUAL BUDGET TO ADD AND DELETE FULL-TIME POSITIONS IN THE LIBRARY DEPARTMENT, PARKS, RECREATION, AND COMMUNITY SERVICES DEPARTMENT, PLANNING AND BUILDING DEPARTMENT, AND PUBLIC WORKS DEPARTMENT. EXECUTIVE SUMMARY The Mid-Year budget update provides a snapshot of General Fund activity for the first six months of the fiscal year, new information with impact to revenue, recommended appropriation adjustments, an update of the Revive spending plan, and notable items for other funds of the City. The update also includes recommended workforce changes and a full-time position vacancy report as of December 31, 2022. Finally, the report includes an updated summary of all funds with estimated fund balances at June 30, 2023. Fiscal Year 2022-23 Mid-Year Budget Update, Revive Spending Plan Update, Appropriation Requests, and Workforce Changes February 21, 2023 Page 2 3 2 5 7 A summary of the General Fund budget follows. DISCUSSION This report focuses on the General Fund, as it is the primary operating fund of the City, and the Revive spending plan due to its significance to the community. Only notable items are included for other funds. No discussion is included for fund activity expected to approximate the budget for the current fiscal year. The FY 2022-23 budget document includes a Fund Summary for all funds of the City, including the estimated fund balance at July 1, 2022, the adopted budget, and the estimated fund balance at June 30, 2023. We now have actual fund balances at July 1, 2022 and we have updated budget amounts. Therefore, we have included an updated Fund Summary as Exhibit 5, which includes all recommendations in this report. General Fund Revenue A summary of General Fund revenue follows. The City receives most of its revenue up to 60 days after the corresponding period. For example, the City receives December Sales Tax in February. Therefore, we can expect to have received approximately 4 months (or 33%) of revenue by December 31. Except for the items discussed below, we do not expect any significant variances to General Fund revenue estimates at this time. FY22-23 Budget Updated with First Quarter Report on November 15, 2022 Proposed Mid-Year Adjustments Updated Estimate Beginning Balance at July 1, 2022 $113,509,544 $0 $113,509,544 Revenue Estimate $391,552,940 $7,383,500 $398,936,440 Appropriated Spending ($406,880,124)(17,443,760)($424,323,884) Pension Trust Set-Aside ($7,748,811)$0 ($7,748,811) Estimated Ending Balance at June 30,2023 $90,433,549 ($10,060,260)$80,373,289 Less: 18% Reserve 70,479,529 1,329,030 $71,808,559 Estimated Spendable Balance 19,954,020 (11,389,290)$8,564,730 Fiscal Year 2022-23 Mid-Year Budget Update, Revive Spending Plan Update, Appropriation Requests, and Workforce Changes February 21, 2023 Page 3 3 2 5 7 Utility Users Tax (UUT) The City’s UUT is 5.5% of utility charges. The price of natural gas substantially increased in December and January, which affects the City’s UUT revenue. For example, the SoCalGas website reports the core-procurement gas price for January 2023 was 344.892 cents per therm, compared to the January 2022 price of 83.569 cents per therm. We expect FY 2022-23 UUT revenue for natural gas to be approximately $1 million more than the budget amount of $3.2 million, and have adjusted our revenue estimate accordingly. Electricity for UUT has been steadily increasing over the last several years. Southern California Edison reports that the number of customer accounts has been increasing. After adopting the FY 2022-23 budget with a $13.1 million revenue estimate, we closed the FY 2021-22 books with final revenue of $13.7 million. At this time, we expect Electricity UUT to exceed the budget estimate of $13.1 million by $2 million. Cannabis Tax The new tax rates became effective January 1, 2023. The earliest we see January receipts is the end of February. Therefore, we have no data to analyze the impact of rate changes. We expect to provide an update of Cannabis Tax with the Third Quarter budget report. Business License Tax The majority of annual business license tax is collected in the spring each year. Therefore, at December 31, the City has only collected a small portion of revenue, and we do not yet have data to analyze the impact of the voter-approved Measure W. We Annual Estimate Received as of Percent Up dated with 1st Qtr 12/31/2022 Received Property Tax + In-Lieu of VLF + Residual 94,235,000 30,207,055 32% Sales Tax Measure X 88,102,000 28,981,618 33% Sales Tax Bradley-Burns 64,550,000 21,163,355 33% Utility Users Tax 24,400,000 12,637,575 52% Cannabis Tax 22,200,000 7,400,096 33% Business License Tax 15,000,000 1,556,677 10% Other Taxes 12,491,100 5,497,980 44% Charges for Service, Licenses & Permits 21,319,580 14,580,951 68% Jail Fa cility Revenue 16,521,360 4,874,742 30% Franchise Fees 10,960,100 2,568,820 23% All Other 21,773,800 13,687,876 63% Totals 391,552,940 143,156,745 37% Fiscal Year 2022-23 Mid-Year Budget Update, Revive Spending Plan Update, Appropriation Requests, and Workforce Changes February 21, 2023 Page 4 3 2 5 7 expect to provide an update of Business License Tax with the Third Quarter budget report. Building Plan Check Revenue The FY 2022-23 budget for Building Plan Checks was $2,022,100. As of December 31, we have already collected $3,598,910 of revenue, primarily due to the Main Place development, the Cabrillo multi-use residential building, and the Center Pointe multi-use residential building. Using the most conservative method of forecasting, we are comfortable increasing the revenue estimate by $2 million at this time. Planning & Building has a request to add four full-time positions to meet the increased demand. Investment Earnings The City received $128 million of federal funding from the American Rescue Plan Act (ARPA). Many of the City’s projects and programs funded with ARPA take time to execute (e.g. Main Library renovation), which means the City has been holding ARPA cash. Federal guidelines allow us to deposit interest earnings from ARPA cash into the City’s General Fund. In addition, the Federal Reserve has raised interest rates by 3.50% since the City Council’s budget hearing on June 7, 2022. Therefore, we have increased our interest earnings revenue estimate from $475,000 to $2,675,000, which is a $2.2 million increase. General Fund Expenditures A summary of General Fund expenditures follows (does not include carryovers from FY 2021-22). Fiscal Year 2022-23 Mid-Year Budget Update, Revive Spending Plan Update, Appropriation Requests, and Workforce Changes February 21, 2023 Page 5 3 2 5 7 Finance Staff Retirements Two long-term Finance employees (36 years and 39 years) filed for retirement in December 2022. During budget preparation, we did not know they would retire during FY 2022-23. The accrued leave-time cash-outs totaled $201,260. The Finance department budget cannot absorb the significant additional expenditure that was compliant with labor agreements, and we request a budget increase accordingly. Santa Ana Zoo- Giant River Otter/Primate Trails Staff requests $1.3 million for additional zoo improvements to utilize the contractor already onsite for the giant river otter habitat. The additional improvements will relocate three primate species from the north end of the zoo and remove the antiquated habitats for the upcoming primate forest project. Both improvements are part of the Master Plan. The requested funding will also address the lighting deficiency in the area. Waste Hauler Donation Republic Services provided a donation of $183,500 to the City to support community events and charitable programs. We request General Fund appropriations to allocate $25,000 to the Library, $48,500 to Parks, Recreation & Community Services, and $25,000 to the Non-Departmental section of the budget for the City Manager’s Office to administer; as well as a Public Works Administration Fund appropriation of $85,000. Annual Budget Spending as of Percent Updated with 1st Qtr 12/31/2022 Expended City Manager's Office 2,939,040 1,349,453 46% City Council 1,029,860 353,650 34% Clerk of the Council 1,935,720 607,884 31% City Attorney's Office 3,584,860 1,184,461 33% Human Resources 3,884,170 1,840,457 47% Finance & Mgmt Svcs 11,750,090 5,494,451 47% Library 6,720,310 2,982,690 44% Parks, Rec & Comm Svcs 13,574,280 6,344,787 47% Police Department 142,772,990 67,542,754 47% Fire Services 1 53,956,950 29,858,584 55% Planning & Building 19,545,470 7,099,250 36% Public Works 50,705,414 13,828,303 27% Community Development 7,944,600 3,291,505 41% Museum Funding 2 2,542,320 1,795,916 71% General Non-Dep 48,103,560 22,888,437 48% Inter-fund Transfers 35,890,490 15,300,834 43% Totals 406,880,124 181,763,418 45% 1 Fire Services spending includes a one-month advance. 2 Museum Funding includes one-time capital reimbursements. Fiscal Year 2022-23 Mid-Year Budget Update, Revive Spending Plan Update, Appropriation Requests, and Workforce Changes February 21, 2023 Page 6 3 2 5 7 Police Staffing Request The Police Department would like to remove one Forensic Specialist II position from the hiring freeze due to increased fingerprint processing and a backlog that adversely affects the quality of investigative results. There is no current year fiscal impact due to budgetary savings. The ongoing actual cost may be $140,000. Debt Service for 800 MHz Communication System During FY 2022-23 budget preparation, staff inadvertently omitted a $23,000 principal payment for the 800 MHz communication system used by multiple departments in the City. Staff requests an adjustment to correct the error. Museum Building Capital Repairs The FY 2022-23 budget includes funding to reimburse Bowers Museum for capital repairs to the City-owned building, as allowed by the City’s agreement with the museum. The final request from Bowers, based on documented support for the reimbursement, necessitates another $25,000 of funding. Staff recommends an appropriation adjustment accordingly. Annual Prayer Breakfast and Orange County Pride Parade & Festival Sponsorship The Mayor would like the City to host an annual Prayer Breakfast, likely in May. Staff requests a $20,000 appropriation in the Non-Departmental section of the budget for the City Manager’s Office to administer. The City received a donation request for the Orange County Pride Parade & Festival held in Santa Ana in June. Staff requests an appropriation of $30,000 to sponsor the event. Third & Broadway Development The Third & Broadway property development agreement with Caribou Industries obligates the City to fund up to $13 million for site preparation. The developer recently completed all contractual requirements to secure the $13 million funding from the City. Therefore, staff recommends appropriating this commitment. Housekeeping Adjustments for Labor Agreements The FY 2022-23 General Fund budget includes $5 million for labor negotiations, within the Non-Departmental section of the budget. On November 15, the City Council approved labor agreements for the Police Management Association and the Part-Time Service Employees International Union. On December 20, the City Council approved the last, best and final offer for the Police Officers Association. All three staff reports indicated that we would propose housekeeping adjustments at Midyear to move the existing General Fund allocation from Non-Departmental into the affected department Fiscal Year 2022-23 Mid-Year Budget Update, Revive Spending Plan Update, Appropriation Requests, and Workforce Changes February 21, 2023 Page 7 3 2 5 7 programs. There is no fiscal impact for these housekeeping adjustments totaling $1,855,046. Revive Spending Plan Update The Revive Spending Plan, to protect and revive the community as Santa Ana emerges from the impacts of the pandemic, is from $128 million of federal American Rescue Plan money. The funding must be obligated by December 2024 and fully spent by December 2026. The City has completed many of the projects, and has initiated many more. A presentation of Revive Spending Plan highlights and accomplishments will accompany this report. Classification & Compensation Plan and Workforce Changes and Vacancy Report Human Resources requests Classification & Compensation Plan changes across various departments (Exhibit 2), including the creation of six new classifications, deletion of one classification, updates to two existing job titles, and compensation changes to thirty-six existing classifications with an estimated ongoing annual fiscal impact of $140,000. Detailed information for the following proposed workforce changes are in Exhibit 3. Library requests changes to streamline staffing and improve administrative supervision. Specifically, Library recommends deleting one Library Technician and one Management Analyst, and adding one Graphics Designer I and one Senior Management Analyst with no current year fiscal impact due to budgetary savings. The future annual net impact may be $37,000. Parks, Recreation & Community Services Agency (PRCSA) requests the following workforce changes to improve supervision with no current year fiscal impact. •Delete one Recreation & Community Services Supervisor and add one Recreation Program Coordinator and one Recreation Leader (future annual impact may be $20,000); •Upgrade one Recreation Leader to a Recreation Program Coordinator (future annual impact may be $34,000); and •Upgrade one Accounting Assistant to a Management Aide (future annual impact of $26,000). PRCSA also requests to add the following positions with no current year fiscal impact due to budgetary savings. •One Recreation Program Coordinator to restructure the existing Senior Mobility Program from a part-time staffing program to a full-time staffing program using existing and future funding from the Orange County Transportation Authority (future annual impact may be $107,000); Fiscal Year 2022-23 Mid-Year Budget Update, Revive Spending Plan Update, Appropriation Requests, and Workforce Changes February 21, 2023 Page 8 3 2 5 7 •Two General Maintenance Workers to address needed deferred maintenance at the Zoo such as additional tasks related to the opening of the new River Otter Exhibit and assisting with the Zoo’s accreditation by the Association of Zoos & Aquariums (future annual impact may be $212,000); •One Management Analyst to assist the Zoo Manager with administrative duties and to research and manage grant opportunities for the Zoo (future annual impact may be $140,000); and •Two Recreation Leaders to achieve a consistent level of service through the consolidation and elimination of part-time positions. The Planning & Building Agency (PBA) recommends adding four full-time employees to improve permit counter service and meet the demands of increased plan check activity, while balancing the overall workload with contract services. This is the only request in this section that includes a current year budget increase. FY 2022-23 Budget Impact Ongoing Annual Impact Associate Plan Check Engineer $50,000 $150,000 Combination Building Inspector $36,000 $109,000 Permit Services Technician $34,000 $102,000 Assistant Plan Check Engineer $41,000 $122,000 Total PBA Requests $161,000 $483,000 The Public Works Agency (PWA) requests the following workforce changes with no current year fiscal impact due to budgetary savings. •Upgrade one Assistant Parks/Landscape Planner to a Public Works Projects Specialist. The future annual net impact may be $14,000. •Add one Projects Manager to the Water Enterprise. The future annual net impact may be $175,000. •Upgrade one Civil Engineer to a Senior Civil Engineer to promote supervision, retain talent, and execute project delivery improvements for capital improvement projects. Various restricted funding sources for CIP projects will bear the ongoing cost of the upgrade, which may be $24,000 annually. •Delete two Maintenance Worker II positions and reallocate the funding to contractual services for the Revive program. The following table summarizes the requested workforce changes. Department Quantity Position Fund Library -1 Library Technician General Fund Library -1 Management Analyst General Fund Library 1 Graphics Designer I General Fund Fiscal Year 2022-23 Mid-Year Budget Update, Revive Spending Plan Update, Appropriation Requests, and Workforce Changes February 21, 2023 Page 9 3 2 5 7 Library 1 Senior Management Analyst General Fund PRCSA -1 Recreation and Community Services Supervisor General Fund PRCSA 1 Recreation Program Coordinator General Fund PRCSA 1 Recreation Leader General Fund PRCSA -1 Accounting Assistant General Fund PRCSA 1 Management Aide General Fund PRCSA -1 Recreation Leader General Fund PRCSA 1 Recreation Program Coordinator General Fund PRCSA 1 Recreation Program Coordinator for SMP Senior Mobility PRCSA 2 General Maintenance Worker for the Zoo General Fund PRCSA 1 Management Analyst for the Zoo General Fund PRCSA 2 Recreation Leader to replace PT positions General Fund Planning & Building 1 Associate Plan Check Engineer General Fund Planning & Building 1 Combination Building Inspector General Fund Planning & Building 1 Permit Services Technician General Fund Planning & Building 1 Assistant Plan Check Engineer General Fund Public Works -1 Assistant Parks/Landscape Planner Civic Center Authority Public Works 1 Public Works Projects Specialist Civic Center Authority Public Works 1 Projects Manager Water Enterprise Public Works -1 Civil Engineer Capital Projects Public Works 1 Senior Civil Engineer Capital Projects Public Works -2 Maintenance Worker II Federal ARPA 10 Total Net Positions The Vacancy Report as of December 31, 2023 is in Exhibit 4. Other Funds Cannabis Public Benefit Fund The FY 2021-22 Cannabis Public Benefit Fund budget included $1,287,990 for the Newhope Library Renovation, and the FY 2022-23 budget included $1,110,730. Due to project scope enhancements, the Library requests an additional $1,150,000 of one-time money from this fund for the Newhope Library Renovation, including replacement of existing end-of-life HVAC systems and units, critical upgrades to electrical systems and cabling, and modern technology improvements in the new Media Lab and existing large meeting room that will help bridge the digital divide. The City expects to solicit construction bids in June for a target completion date of May 2024. After absorbing the potential revenue shortfall reported to City Council on October 4, 2022 due to Cannabis tax rate changes, the estimated fund balance is approximately $2.8 million, which is sufficient to cover the recommended $1,150,000 appropriation adjustment. Fiscal Year 2022-23 Mid-Year Budget Update, Revive Spending Plan Update, Appropriation Requests, and Workforce Changes February 21, 2023 Page 10 3 2 5 7 Gas Tax Fund The state imposes Gas Tax on a cents-per-gallon basis and allocates a portion to the city. Gas Tax is not a percentage of sales. Therefore, when gas prices escalate and drivers purchase fewer gallons of gas, the City’s Gas Tax revenue decreases. The most recent Gas Tax estimates from the League of California Cities Fiscal Policy Advisor indicate the City’s share will approximate $14.7 million. The FY 2022-23 budgeted revenue estimate was $17.2 million, based on previous League information, which supports decreasing the budget estimate by $2.5 million. To ensure the City’s right-of-way maintenance services are not impacted, staff recommends a $2.5 million General Fund appropriation to cover the shortfall. If approved, expenditures for the Fairview Bridge & Street Improvements, Traffic Signal Maintenance, Median Landscaping, and Roadway Maintenance expenditures will move to the General Fund. Increasing General Fund spending for right-of-way maintenance improves the City’s ability to comply with the Orange County Transportation Authority Maintenance of Effort for Measure M2 funding. Restricted Fund Adjustments The City receives updated information after the beginning of the fiscal year for various restricted funding sources. Examples include the Civic Center Authority adopting the budget after June, and update to federal monies available for various programs. Staff recommends a series of adjustments to resize restricted-money appropriations to available balances and authorizations. The details of these adjustments are included in Exhibit 1. FISCAL IMPACT The General Fund fiscal impact appears at the beginning of this report. Exhibit 1 includes the line-item changes to revenue estimates and recommended appropriation adjustments. Exhibit 5 includes the estimated June 30, 2023 fund balance for all funds, including the revenue impacts and recommendations covered in this report. EXHIBIT 1. Line Item Changes to Revenue Estimates and Recommended Adjustments 2. Resolution No. 2023-XXX, A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF SANTA ANA TO AMEND RESOLUTION NO. 2015-026 TO EFFECT CERTAIN CHANGES TO THE CITY’S BASIC CLASSIFICATION AND COMPENSATION PLAN 3. Resolution No. 2023-XXX, A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF SANTA ANA TO AMEND THE CURRENT FISCAL YEAR 2022-2023 ANNUAL BUDGET TO ADD AND DELETE FULL-TIME POSITIONS IN THE LIBRARY DEPARTMENT, PARKS, RECREATION, AND COMMUNITY SERVICES DEPARTMENT, PLANNING AND BUILDING DEPARTMENT, AND PUBLIC WORKS DEPARTMENT 4. Vacancy Report at December 31, 2022 Fiscal Year 2022-23 Mid-Year Budget Update, Revive Spending Plan Update, Appropriation Requests, and Workforce Changes February 21, 2023 Page 11 3 2 5 7 5. Updated FY 2022-23 Fund Balance Summary for All Funds Submitted By: Kathryn Downs, FMSA Executive Director Approved By: Kristine Ridge, City Manager Line Item Changes to Revenue Estimates and Recommended Adjustments Description Account Revenue Spending Utility Users Tax (UUT) - Natural Gas 01102002-50032 1,000,000$ Utility Users Tax (UUT) - Electricity 01102002-50031 2,000,000$ Building Plan Check 01116002-53600 2,000,000$ Investment Earnings 01102002-58000 2,200,000$ Finance Staff Retirements 01110130-61010 135,800$ Finance Staff Retirements 01110131-61010 65,460$ Waste Hauler Donation Revenue 01102002-57XXX 183,500$ Waste Hauler Donation - Non Departmental 01105015-62300 25,000$ Waste Hauler Donation - Parks, Rec & Comm Svcs 01113230-62300 48,500$ Waste Hauler Donation - Library 01111110-62300 25,000$ Waste Hauler Donation - Public Works 10117601-62300 85,000$ Planning & Building Staff Request 011165XX-6XXXX 161,000$ Debt Service for 800MHz Communication System 01116500-67200 23,000$ Museum Building Capital Repairs 01112030-69135 25,000$ Housekeeping Adjustments for Labor Negotiations 01105015-69011 (1,855,046)$ Housekeeping Adjustments for Labor Negotiations 011XXXX-61XXX 1,855,046$ Right-of-way maintenance to cover Gas Tax revenue reduction 01117XXX-6XXXX 2,500,000$ Santa Ana Zoo improvements for Giant River Otter/Primate Trails 01113220-66XXX 1,300,000$ Third & Broadway Development 01105015-69011 13,000,000$ Orange County Pride Parade & Festival - June 2023 01105015-62300 30,000$ Annual Prayer Breakfast - May 2023 01105015-62300 20,000$ General Fund Totals 7,383,500$ 17,443,760$ Cannabis Public Benefit Fund - Newhope Library 01211020-66200 1,150,000$ Gas Tax expenditure reduction 02917XXX-6XXXX (2,500,000)$ Other Restricted Fund Adjustments: Bristol Street Improvements - update funding source 02917660-66220 (4,000,000)$ Bristol Street Improvements - update funding source 05917663-66220 4,000,000$ Clean Air money available for 3 charging stations 03117101-66400 100,000$ Project fees for project monitoring 05317021-62340 150,000$ NPDES fees for settlement & Fairview/Sunflower storm drain 05717640-62300 420,000$ New street impact fee from refuse hauler - move account 05917660-66220 2,666,666$ New street impact fee from refuse hauler - move account 06917019-66220 (2,666,666)$ Re-appropriate Facilities Condition Assessment 07317100-62300 300,000$ Move & adjust Civic Center Authority budget to match adopted 07414400-6XXXX (603,446)$ Move & adjust Civic Center Authority budget to match adopted 07417655-6XXXX 537,970$ Move the accounting for CNG operations 07517100-63301 (40,000)$ Move the accounting for CNG operations 07617102-63301 40,000$ Reduce past-years set-aside training budget to remaining available 08809050-62300 (11,573)$ Federal money adjustment for WORK center 12318752-6XXXX 39,972$ Federal money adjustment for WORK center 12318753-6XXXX 515,309$ Federal money adjustment for WORK center 12318754-6XXXX 550,772$ Federal money adjustment for WORK center 12318756-6XXXX (93,972)$ Federal money adjustment for WORK center 12318763-6XXXX 116,317$ Federal money available for emergency services 12514407-6XXXX 2,047,580$ Federal money available for emergency services 12514491-61XXX 168,561$ Adjust public safety grant spending to amount available 12714406-61040 (6,789)$ Adjust public safety grant spending to amount available 12714409-61000 (19,016)$ Federal money available for restricted law enforcement 12814409-6XXXX 103,807$ Federal money available for restricted law enforcement 12814417-61040 20,039$ Federal money available for housing assistance 13618760-69158 17,610$ Appropriate remaining federal COVID money for housing 15718760-62300 428$ EXHIBIT 1 Line Item Changes to Revenue Estimates and Recommended Adjustments EXHIBIT 1 Description Account Revenue Spending Adjust planning grants spending to amounts available 15816500-6XXXX (172,170)$ Adjust federal traffic safety spending to the amount available 16514414-61040 (32,697)$ Asset seizure money available for spending 16614450-6XXXX 242,170$ Move developer fee spending for new Harbor Specific Plan 31113260-66220 (2,383,974)$ Move developer fee spending for new Harbor Specific Plan 31413260-66220 (528,039)$ Move developer fee spending for new Harbor Specific Plan 31513260-66220 2,912,013$ Inclusionary housing fees available for affordable housing svcs 41718820-62300 283,020$ Resolution 2023-XXX Page 1 of 6 RESOLUTION NO. 2023-XXX A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF SANTA ANA TO AMEND RESOLUTION NO. 2015-026 TO EFFECT CERTAIN CHANGES TO THE CITY’S BASIC CLASSIFICATION AND COMPENSATION PLAN BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF SANTA ANA AS FOLLOWS: Section 1. The City Council of the City of Santa Ana hereby finds, determines, and declares as follows: A.Section 1004 of the City Charter of the City of Santa Ana requires the City Manager to prepare, install, and maintain a position classification and pay plan subject to civil service rules and regulations and the approval of the City Council. B.It is the City’s practice to assign job titles that reflect the duties and responsibilities of the classification and are consistent with other classifications within the City’s organizational structure, as well as comparable job titles in the labor market, while maintaining internal pay equity relationships and attracting and retaining qualified candidates. C.On June 16, 2015, the City Council adopted Resolution No. 2015-026 amending and reestablishing the Basic Classification and Compensation Plan for all full-time and part-time classifications of officers and employees of the City of Santa Ana. D.The City Council has amended and reestablished the Basic Classification and Compensation Plan on numerous occasions since its adoption. E.On December 20, 2022, the City Council implemented the terms and conditions of the City’s last, best, and final offer made to the Santa Ana Police Officers Association (“SAPOA”) on September 8, 2022 that included a base salary increase of three (3) percent effective the pay period following City Council approval, or January 1, 2023. F.It is now desired to amend Resolution No. 2015-026, as amended, and its corresponding exhibits in order to effect these changes, as shown below. Section 2. The Santa Ana City Council amends Resolution No. 2015 -026, as amended, and its corresponding exhibits as follows: EXHIBIT 2 Resolution 2023-XXX Page 2 of 6 A. Updating the following Exhibit D monthly steps for SAPOA classifications per the implemented terms and conditions of the City’s last, best, and final offer dated September 8, 2022 that include d a base salary increase of three (3) percent effective January 1, 2023: JOB TITLE SRR A B C D E Animal Service Officer I 668 $5,597 $5,877 $6,172 $6,480 $6,804 Animal Service Officer II 698 $6,480 $6,804 $7,145 $7,501 $7,876 Background Investigator 683 $6,022 $6,324 $6,639 $6,971 $7,320 Communications Services Officer 663 $5,463 $5,736 $6,022 $6,324 $6,639 Correctional Officer 683 $6,022 $6,324 $6,639 $6,971 $7,320 Correctional Supervisor 732 $7,650 $8,033 $8,435 $8,857 $9,300 Crime Research Aide 694 $6,355 $6,672 $7,005 $7,355 $7,724 Crime Research Analyst 720 $7,215 $7,576 $7,955 $8,352 $8,770 Emergency Operations Coordinator 752 $8,435 $8,857 $9,300 $9,766 $10,254 Firearms Examiner 739 $7,916 $8,311 $8,727 $9,164 $9,622 Forensic Services Supervisor 770 $9,209 $9,670 $10,153 $10,661 $11,194 Forensic Specialist I 694 $6,355 $6,672 $7,005 $7,355 $7,724 Forensic Specialist II 713 $6,971 $7,320 $7,687 $8,072 $8,476 Parking Control Officer 633 $4,716 $4,954 $5,203 $5,463 $5,736 Police Athletic/Activities League Assistant Director 662 $5,436 $5,708 $5,993 $6,293 $6,607 Police Communications Supervisor 728 $7,501 $7,876 $8,270 $8,684 $9,119 Police Community Services Specialist 683 $6,022 $6,324 $6,639 $6,971 $7,320 Police Evidence and Supply Specialist 666 $5,543 $5,820 $6,112 $6,417 $6,738 Police Evidence and Supply Supervisor 686 $6,112 $6,417 $6,738 $7,075 $7,427 Police Investigative Specialist 683 $6,022 $6,324 $6,639 $6,971 $7,320 Police Officer 739 $7,916 $8,311 $8,727 $9,164 $9,622 Police Photo/Video Specialist 678 $5,877 $6,172 $6,480 $6,804 $7,145 Police Property and Evidence Supervisor 686 $6,112 $6,417 $6,738 $7,075 $7,427 Police Recruit 692 $6,293 $6,607 $6,937 $7,285 $7,650 Police Sergeant 782 $9,766 $10,254 $10,767 $11,305 $11,871 Police Service Officer 663 $5,463 $5,736 $6,022 $6,324 $6,639 Police Services Dispatcher 688 $6,172 $6,480 $6,804 $7,145 $7,501 Rangemaster 663 $5,463 $5,736 $6,022 $6,324 $6,639 Senior Parking Control Officer 653 $5,203 $5,463 $5,736 $6,022 $6,324 Traffic Services Specialist 683 $6,022 $6,324 $6,639 $6,971 $7,320 Resolution 2023-XXX Page 3 of 6 B. Adding the following classifications effective February 26, 2023, which is the start date of the first full pay period following City Council approval. JOB TITLE EXH SRR BASIS STEP RATE Data Analyst (UC) B 668 Monthly AA $6,538 A $6,863 B $7,209 C $7,568 D $7,948 E $8,346 Human Resources Communications Specialist (UC) B 663 Monthly AA $6,380 A $6,702 B $7,034 C $7,386 D $7,754 E $8,142 Senior Human Resources Communications Specialist (AM) E 722 Monthly A $8,509 B $8,935 C $9,380 D $9,850 E $10,345 Data Analyst (Part-Time) I - Hourly AA $37.72 A $39.59 B $41.59 C $43.66 D $45.85 E $48.15 Personnel Board Secretary (Part-Time) I - Hourly AA $29.00 A $30.45 B $31.97 C $33.57 D $35.25 E $37.01 Senior Human Resources Communications Specialist (Part-Time) I - Hourly A $49.09 B $51.55 C $54.12 D $56.83 E $59.68 Resolution 2023-XXX Page 4 of 6 C. Deleting the following classification effective February 26, 2023, which is the start date of the first full pay period following City Council approval. JOB TITLE EXH SRR BASIS STEP RATE Risk Management Technician I - Hourly A $31.62 B $33.23 C $34.88 D $36.63 E $38.46 D. Changing the compensation of the following classifications to the pay rates listed below effective February 26, 2023, which is the start date of the first full pay period following City Council approval. JOB TITLE EXH SRR BASIS STEP RATE Utilities Customer Service Supervisor F 677 Monthly AAA $5,678 AA $5,963 A $6,260 B $6,574 C $6,903 D $7,247 E $7,609 Administrative Intern I - Hourly A $18.15 B $19.06 Budget Intern I - Hourly A $19.97 B $20.96 Engineering Intern I - Hourly A $19.97 B $20.96 Management Intern I - Hourly A $21.96 B $23.06 Senior Administrative Intern I - Hourly A $19.97 B $20.96 Resolution 2023-XXX Page 5 of 6 E. Changing the job title of the following classifications effective February 26, 2023, which is the start date of the first full pay period following City Council approval. Change ‘Equity and Inclusion Coordinator (Exempt) (UC)’ to: JOB TITLE EXH SRR BASIS STEP RATE Equity and Inclusion Coordinator (Excepted) (UC) B 668 Monthly AA $6,538 A $6,863 B $7,209 C $7,568 D $7,948 E $8,346 Change ‘Planning Technician’ to: JOB TITLE EXH SRR BASIS STEP RATE Planning Technician (Part-Time) H - Hourly A $26.08 B $27.37 C $28.75 D $30.19 E $31.71 Section 3. Except as amended by this Resolution, all other provisions of Resolution No. 2015-026, as amended, and its corresponding exhibits shall remain in full force and effect. Section 4. This Resolution is to be operative from and after the date which it is adopted. ADOPTED this 21st day of February, 2023. ___________________________ Valerie Amezcua Mayor APPROVED AS TO FORM: Sonia R. Carvalho City Attorney By: __________________ Laura A. Rossini Chief Assistant City Attorney Resolution 2023-XXX Page 6 of 6 AYES: Councilmembers NOES: Councilmembers ABSTAIN: Councilmembers NOT PRESENT: Councilmembers CERTIFICATE OF ATTESTATION AND ORIGINALITY I, ____________________, Clerk of the Council, do hereby attest to and certify the attached Resolution No. 2023-___ to be the original Resolution adopted by the City Council of the City of Santa Ana on February 21, 2023. Date: ___________________ ____________________________ Clerk of the Council City of Santa Ana Resolution 2023-XXX Page 1 of 5 RESOLUTION NO. 2023-XXX A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF SANTA ANA TO AMEND THE CURRENT FISCAL YEAR 2022- 2023 ANNUAL BUDGET TO ADD AND DELETE FULL-TIME POSITIONS IN THE LIBRARY DEPARTMENT, PARKS, RECREATION, AND COMMUNITY SERVICES DEPARTMENT, PLANNING AND BUILDING DEPARTMENT, AND PUBLIC WORKS DEPARTMENT. BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF SANTA ANA AS FOLLOWS: Section 1: The City Council hereby finds, determines, and declares as follows: A.On June 21, 2022, the City Council passed and adopted Ordinance No. NS - 3021, establishing the City’s Budget for Fiscal Year 2022 -2023 and authorizing position allocations for Fiscal Year 2022 -2023. The Ordinance also sets forth the requirement that alterations in the allocation of authorized positions be reviewed and approved by the City Council. B.The Executive Director of the Library Department requests to amend the Fiscal Year 2022-2023 budget to add the following full-time positions: one (1) Graphics Designer I and one (1) Senior Management Analyst, and the deletion of the following full-time positions: one (1) Library Technician and one (1) Management Analyst. C.The Executive Director of the Parks, Recreation, and Community Services Department requests to amend the Fiscal Year 2022 -23 budget to add the following full-time positions: three (3) Recreation Program Coordinators, three (3) Recreation Leaders, two (2) General Maintenance Workers, one (1) Management Aide, and one (1) Management Analyst, and the deletion of the following full-time positions: one (1) Recreation Leader, one (1) Accounting Assistant, and one (1) Recreation and Community Services Supervisor. D.The Executive Director of the Planning and Building Department requests to amend the Fiscal Year 2022-23 budget to add the following full-time positions: one (1) Assistant Plan Check Engineer, one (1) Associate Plan Check Engineer, one (1) Permit Services Technician, and one (1) Comb ination Building Inspector. E.The Executive Director of the Public Works Department requests to amend the Fiscal Year 2022-23 budget to add the following full-time positions: one (1) Public Works Projects Specialist, one (1) Projects Manager, and one (1) Senior Civil Engineer, and the deletion of the following full-time positions: one (1) EXHIBIT 3 Resolution 2023-XXX Page 2 of 5 Assistant Parks/Landscape Planner, one (1) Civil Engineer, and two (2) Maintenance Worker II. F. It is now desired to amend the Fiscal Year 2022-2023 budget, as amended in order to effect this change, as shown below. Section 2: The City’s Annual budget for Fiscal Year 2022-2023, as amended, is hereby further amended to add and delete the following positions in the Library Department, at the monthly seven-step range as indicated: 7-Step Salary Rate Range Effective 2/21/2023 Classification Title Number of Positions Added SSR Monthly Salary Minimum-Maximum Graphics Designer I 1 642 $4,787 - $6,415 Library Technician -1 610 $4,091 - $5,488 Section 3: The City’s Annual budget for Fiscal Year 2022-2023, as amended, is hereby further amended to add and delete the following positions in the Library Department, at the monthly five-step range and monthly six-step range indicated: 5-Step Salary Rate Range Effective 2/21/2023 Classification Title Number of Positions Added SSR Monthly Salary Minimum-Maximum Senior Management Analyst 1 707 $7,908 - $9,610 6-Step Salary Rate Range Effective 2/21/2023 Classification Title Number of Positions Added SSR Monthly Salary Minimum-Maximum Management Analyst -1 668 $6,538 - $8,346 Section 4: The City’s Annual budget for Fiscal Year 2022-2023, as amended, is hereby further amended to add and delete the following positions in the Parks, Recreation, and Community Services Department, at the monthly seven-step range as indicated: 7-Step Salary Rate Range Effective 2/21/2023 Classification Title Number of Positions Added SSR Monthly Salary Minimum-Maximum Recreation Program Coordinator 3 640 $4,741 - $6,353 Recreation Leader 3 560 $3,205 - $4,296 Resolution 2023-XXX Page 3 of 5 General Maintenance Worker 2 639 $4,718 - $6,322 Recreation Leader -1 560 $3,205 - $4,296 Accounting Assistant -1 621 $4,317 - $5,790 Recreation and Community Services Supervisor -1 721 $7,039 - $9,434 Section 5: The City’s Annual budget for Fiscal Year 2022-2023, as amended, is hereby further amended to add the following positions in the Parks, Recreation, and Community Services Department, at the monthly six-step range as indicated: 6-Step Salary Rate Range Effective 2/21/2023 Classification Title Number of Positions Added SSR Monthly Salary Minimum-Maximum Management Aide 1 642 $5,759 - $7,351 Management Analyst 1 668 $6,538 - $8,346 Section 6: The City’s Annual budget for Fiscal Year 2022-2023, as amended, is hereby further amended to add the following positions in the Planning and Building Department, at the monthly seven-step range as indicated: 7-Step Salary Rate Range Effective 2/21/2023 Classification Title Number of Positions Added SSR Monthly Salary Minimum-Maximum Assistant Plan Check Engineer 1 754 $8,269 - $11,086 Associate Plan Check Engineer 1 769 $8,897 - $11,934 Permit Services Technician 1 671 $5,515 - $7,391 Combination Building Inspector 1 687 $5,963 - $7,989 Section 7: The City’s Annual budget for Fiscal Year 2022-2023, as amended, is hereby further amended to add and delete the following positions in the Public Works Department, at the monthly seven-step range as indicated: 7-Step Salary Rate Range Effective 2/21/2023 Classification Title Number of Positions Added SSR Monthly Salary Minimum-Maximum Projects Manager 1 741 $7,761 - $10,401 Resolution 2023-XXX Page 4 of 5 Public Works Projects Specialist 1 703 $6,446 - $8,641 Senior Civil Engineer 1 792 $9,955 - $13,342 Assistant Parks/Landscape Planner -1 682 $5,818 - $7,799 Civil Engineer -1 769 $8,897 - $11,934 Maintenance Worker II -2 620 $4,296 - $5,762 Section 8: All classification salary rate ranges are set forth in the City's "Salary Schedule" as periodically updated. Section 9: That except as amended by this resolution, all other provisions of the Annual Budget for the Fiscal Year 2022-2023, as amended, shall remain in full force and effect. Section 10: This Resolution is operative from and after the date upon which it is adopted. ADOPTED this 21st day of February 2023. ___________________________ Valerie Amezcua Mayor APPROVED AS TO FORM: Sonia R. Carvalho City Attorney By: __________________ Laura A. Rossini Chief Assistant City Attorney AYES: Councilmembers NOES: Councilmembers ABSTAIN: Councilmembers NOT PRESENT: Councilmembers Resolution 2023-XXX Page 5 of 5 CERTIFICATE OF ATTESTATION AND ORIGINALITY I, Clerk of the Council, do hereby attest to and certify the attached Resolution No. 2023- ___ to be the original Resolution adopted by the City Council of the City of Santa Ana on February 21, 2023 Date: ___________________ ____________________________ Clerk of the Council City of Santa Ana As of December 31, 2022 Department FY 22-23 Funded Positons GF Vacancies Non-GF Vacancies Total Vacancies Hiring Freeze Vacancies Total Funded Vacancies Vacancy Rate City Manager's Office 16 2 2 4 0 4 25% City Attorney's Office 17 6 0 6 0 6 35% Clerk of the Council 7 4 0 4 0 4 57% Community Development 62 0 5 5 0 5 8% Finance & Management Services 68 8 2 10 0 10 15% Information Technology 23 0 10 10 0 10 43% Human Resources 31 2 1 3 0 3 10% Planning & Building 95 15 3 18 0 18 19% Police Department 640 64 1 65 7 58 10% Parks, Recreation, & Community Services 53 3 2 5 0 5 9% Library 37 5 0 5 0 5 14% Public Works Agency 311 12 62 74 2 72 24% Total 1360 121 88 209 9 200 15% EXHIBIT 4 Fund Number Fund Name Beginning Balance FY 22-23 Revenues FY 22-23 Transfers In FY 22-23 Total Resources FY 22-23 Expenditures FY 22-23 Transfers Out FY 22-23 Total Uses Change in Fund Balance Estimated Ending Fund Balance GENERAL FUND 011 GENERAL FUND 144,163,846 399,486,440 - 399,486,440 (396,048,112) (51,488,070) (447,536,182) (48,049,742)96,114,100 General Fund Total 144,163,846 399,486,440 - 399,486,440 (396,048,112) (51,488,070) (447,536,182) (48,049,742) 96,114,100 SPECIAL REVENUE - GENERAL FUND 012 CANNABIS PUBLIC BENEFIT FUND 25,137,682 - 14,233,300 14,233,300 (34,253,291) - (34,253,291) (20,019,991)5,117,690 016 CASP CERTIFICATION & TRAINING 345,932 85,000 - 85,000 (85,000) - (85,000) - 345,930 021 CATV FUND 1,783,304 250,000 - 250,000 (250,000) - (250,000) - 1,783,300 022 PRCSA FEE & DONATION 1,012,093 - - - (975,735) - (975,735) (975,735)36,360 051 CAPITAL OUTLAY FUND 4,525,792 1,023,500 292,000 1,315,500 (5,200,189) - (5,200,189) (3,884,689)641,100 053 CITY SERVICES 1,723,211 3,621,520 - 3,621,520 (3,771,520) - (3,771,520) (150,000)1,573,210 100 SECTION 457 FIDUCIARY ADMIN 103,634 67,300 - 67,300 (93,000) - (93,000) (25,700)77,930 110 STRONG MOTION INSTRUMENTATION 101,699 16,000 - 16,000 (16,000) - (16,000) - 101,700 120 FIRE FACILITIES FUND 2,560,965 780,100 - 780,100 (2,728,100) - (2,728,100) (1,948,000)612,960 121 SPECIAL REPAIR/DEMOLITION 651,447 160,000 - 160,000 (160,000) - (160,000) - 651,450 Special Revenue - General Fund Total 37,945,758 6,003,420 14,525,300 20,528,720 (47,532,835) - (47,532,835) (27,004,115) 10,941,630 GRANT FUNDS 031 AIR QUALITY IMPR. (AB 2766)1,678,310 785,268 - 785,268 (2,100,734) (7,050) (2,107,784) (1,322,516)355,790 122 EMERGENCY & HEALTH GRANTS 4,296,361 12,849,751 - 12,849,751 (12,330,590) (810) (12,331,400) 518,351 4,814,710 123 WORKFORCE INVESTMENT ACT (412,321) 4,900,929 - 4,900,929 (4,427,618) (60,990) (4,488,608) 412,321 - 124 ORANGE COUNTY SSA GRANTS 1,201,336 3,733,474 - 3,733,474 (3,722,674) (10,800) (3,733,474) - 1,201,340 125 OES UASI (623,736) 9,781,134 - 9,781,134 (9,157,201) - (9,157,201) 623,933 200 127 D.O.J. GRANT FUND 16,005 434,782 - 434,782 (434,782) - (434,782) - 16,010 128 POLICE BLOCK GRANTS 1,299,220 898,993 - 898,993 (1,767,960) - (1,767,960) (868,967)430,250 130 HOME PROGRAM FEDERAL GRANT 2,366,375 8,038,907 - 8,038,907 (9,556,849) (9,610) (9,566,459) (1,527,552)838,820 135 COMMUNITY DEV BLOCK GRANT (1,417,933) 18,320,797 - 18,320,797 (16,769,572) (107,670) (16,877,242) 1,443,555 25,620 136 HOUSING AUTHORITY-VOUCHER HAP (171,857) 42,504,227 - 42,504,227 (42,332,370) - (42,332,370) 171,857 - 137 HOUSING AUTHORITY- MAINSTREAM - 2,427,940 - 2,427,940 (2,427,940) - (2,427,940) - - 138 HOUSING AUTHORITY- MS5 (36,509) 2,357,600 - 2,357,600 (2,357,600) - (2,357,600) - (36,510) 139 HOUSING AUTHORITY-NEW CONSTR 145,833 360,230 - 360,230 (360,000) (230) (360,230) - 145,830 140 HOUSING AUTHORITY-VOUCHER ADM 2,349,174 4,539,380 - 4,539,380 (4,452,386) (91,940) (4,544,326) (4,946)2,344,230 142 NSP FEDERAL GRANT 1,556,628 228,498 - 228,498 (1,644,000) - (1,644,000) (1,415,502)141,130 145 RENTAL REHABILITATION GRANT 396,231 - - - (38,653) - (38,653) (38,653)357,580 152 PUBLIC LIBRARY GRANT FUND 409 9,339,901 - 9,339,901 (9,339,901) - (9,339,901) - 410 157 HSG ADMIN CARES ACT COVID-19 428 - - - (428) - (428) (428)- 158 PLANNING GRANTS PROGRAM (218,831) 10,567,889 - 10,567,889 (10,199,699) - (10,199,699) 368,190 149,360 165 OFFICE OF SAFETY GRANT 147,874 916,406 - 916,406 (900,306) - (900,306) 16,100 163,970 169 RECREATION GRANTS FUND 545,223 300,640 - 300,640 (304,727) - (304,727) (4,087)541,140 179 ARPA EHV HAP 416,414 768,187 - 768,187 (1,184,601) - (1,184,601) (416,414)- 180 ARPA EHV ADMIN FEES 184,861 267,180 - 267,180 (296,281) - (296,281) (29,101)155,760 181 AMERICAN RESCUE PLAN ACT 115,979,208 99,531,883 - 99,531,883 (115,979,235) - (115,979,235) (16,447,352)99,531,860 182 HOME-ARP PROGRAM FEDERAL GRANT - 6,201,228 - 6,201,228 (6,201,228) - (6,201,228) - - 183 ARPA - CA FOR ALL YOUTH WDP - 4,497,520 - 4,497,520 (4,497,520) - (4,497,520) - - Grant Funds Total 129,698,705 244,552,744 - 244,552,744 (262,784,855) (289,100) (263,073,955) (18,521,211) 111,177,500 Estimated Spendable Fund Balance Summary Fiscal Year 2022-2023 Fund Number Fund Name Beginning Balance FY 22-23 Revenues FY 22-23 Transfers In FY 22-23 Total Resources FY 22-23 Expenditures FY 22-23 Transfers Out FY 22-23 Total Uses Change in Fund Balance Estimated Ending Fund Balance Estimated Spendable Fund Balance Summary Fiscal Year 2022-2023 OTHER RESTRICTED FUNDS 020 OTS-TRAFFIC OFFENDER PROGRAM 33,912 55,360 - 55,360 (55,360) - (55,360) - 33,910 023 INMATE WELFARE FUND 1,811,407 2,299,510 - 2,299,510 (2,299,510) - (2,299,510) - 1,811,410 024 POLICE ACTIVITIES & PROGRAMS (143,559) 565,320 - 565,320 (565,270) - (565,270) 50 (143,510) 026 CRIMINAL ACTIVITIES FUND 144,634 - - - (70,520) - (70,520) (70,520)74,110 029 SPECIAL GAS TAX 27,033,527 14,742,582 - 14,742,582 (7,722,442) (33,402,894) (41,125,336) (26,382,754)650,770 074 CIVIC CENTER MAINTENANCE (275,075) 3,929,669 1,179,400 5,109,069 (4,774,734) (13,200) (4,787,934) 321,135 46,060 133 HOUSING AUTHORITY-ISSUER FEE 2,741,131 70,000 - 70,000 (128,790) (1,300) (130,090) (60,090)2,681,040 166 US DOJ ASSET FORFEITURE FUND 972,304 - - - (1,000,670) - (1,000,670) (1,000,670)(28,370) 167 US TREASURY ASSET FORFEITURE 139,884 - - - (139,280) - (139,280) (139,280)600 177 EMERGENCY RENTAL ASSISTANCE PG 2,667,174 7,487,509 - 7,487,509 (8,133,226) (2,520) (8,135,746) (648,237)2,018,940 178 COVID-19 RESPONSE (137,782) 7,362,219 - 7,362,219 (3,997,089) - (3,997,089) 3,365,130 3,227,350 417 CDA INCLUSIONARY HOUSING FEE 14,841,591 71,120 - 71,120 (4,819,517) (9,900) (4,829,417) (4,758,297)10,083,290 607 HOUSING AUTHORITY LMIHF 4,887,424 770,280 - 770,280 (1,967,270) (12,040) (1,979,310) (1,209,030)3,678,390 655 2018 SERIES TAX ALLOC BOND - - 11,231,650 11,231,650 (11,231,650) - (11,231,650) - - 670 COSA RDA 484,393 - 130,000 130,000 (130,200) - (130,200) (200)484,190 671 COSA RDA OBLIGATION RETIREMENT 10,604,329 11,773,130 - 11,773,130 (411,480) (11,361,650) (11,773,130) - 10,604,330 Other Restricted Funds Total 65,805,292 49,126,699 12,541,050 61,667,749 (47,447,008) (44,803,504) (92,250,512) (30,582,763) 35,222,510 ENTERPRISE FUNDS 027 PARKING FUND 1,088,037 2,281,390 2,873,040 5,154,430 (5,154,430) - (5,154,430) - 1,088,040 056 SANITARY SEWER SERVICE 8,252,906 8,895,300 - 8,895,300 (9,073,415) (250,000) (9,323,415) (428,115)7,824,790 057 FED CLEAN WATER PROTECTION ENT 4,754,649 1,750,000 2,665,800 4,415,800 (7,068,190) (200,000) (7,268,190) (2,852,390)1,902,260 060 WATER REVENUE 45,840,958 73,576,450 - 73,576,450 (74,597,322) (41,452,622) (116,049,944) (42,473,494)3,367,460 066 ACQUISITION & CONSTRUCTION 809,695 8,250,000 40,171,822 48,421,822 (49,231,517) - (49,231,517) (809,695)- 067 REGIONAL TRANSP CENTER 378,256 759,870 1,081,870 1,841,740 (1,777,850) - (1,777,850) 63,890 442,150 068 SANITATION FUND 6,809,184 6,142,900 200,000 6,342,900 (9,338,336) - (9,338,336) (2,995,436)3,813,750 069 REFUSE COLLECTION SERVICE 7,197,102 19,388,856 - 19,388,856 (15,908,080) (3,676,666) (19,584,746) (195,890)7,001,210 Enterprise Funds Total 75,130,786 121,044,766 46,992,532 168,037,298 (172,149,140) (45,579,288) (217,728,428) (49,691,130) 25,439,660 INTERNAL SERVICE FUNDS 070 EQUIPMENT REPLACEMENT FUND 7,942,223 738,700 - 738,700 (2,980,560) - (2,980,560) (2,241,860)5,700,360 073 BUILDING MAINT FUND 2,358,794 5,623,060 - 5,623,060 (5,963,860) - (5,963,860) (340,800)2,017,990 075 FLEET MAINTENANCE/STORES 1,337,207 5,467,310 - 5,467,310 (5,786,720) - (5,786,720) (319,410)1,017,800 076 STORES & PROPERTY CONTROL (210,266) 1,804,100 - 1,804,100 (2,010,290) - (2,010,290) (206,190)(416,460) 080 LIABILITY AND PROPERTY INS FND 16,402,298 11,092,950 4,654,820 15,747,770 (17,960,012) - (17,960,012) (2,212,242)14,190,060 081 EMPLOYEE GROUP INSURANCE 52,314 26,803,910 2,534,580 29,338,490 (29,472,040) - (29,472,040) (133,550)(81,240) 082 WORKERS COMPENSATION FUND 16,700,041 10,101,550 - 10,101,550 (10,061,652) - (10,061,652) 39,898 16,739,940 085 CITY YARD OPERATION (55,328) 1,263,100 - 1,263,100 (1,324,190) - (1,324,190) (61,090)(116,420) 086 PUB WKS ENG/PROJ MGMT (268,310) 8,717,760 10,000 8,727,760 (8,543,170) (113,450) (8,656,620) 71,140 (197,170) 088 QUALITY SERVICE TRAINING 295,927 - - - (295,927) - (295,927) (295,927)- 101 PUB WKS-ADMIN & PLANNING 2,900,641 7,733,700 85,000 7,818,700 (10,591,430) (94,670) (10,686,100) (2,867,400)33,240 109 INFO SYS STRATEGIC PLAN 12,805,168 8,686,630 - 8,686,630 (17,504,990) - (17,504,990) (8,818,360)3,986,810 Internal Service Funds Total 60,260,709 88,032,770 7,284,400 95,317,170 (112,494,841) (208,120) (112,702,961) (17,385,791) 42,874,910 Fund Number Fund Name Beginning Balance FY 22-23 Revenues FY 22-23 Transfers In FY 22-23 Total Resources FY 22-23 Expenditures FY 22-23 Transfers Out FY 22-23 Total Uses Change in Fund Balance Estimated Ending Fund Balance Estimated Spendable Fund Balance Summary Fiscal Year 2022-2023 CAPITAL PROJECT FUNDS 032 MEASURE M-STREET CONSTRUCTION (8,296,468) 70,094,545 - 70,094,545 (52,117,896) - (52,117,896) 17,976,649 9,680,180 034 NEW TRANSPO SYS IMPR AREA E 1,496,062 - - - (1,291,236) - (1,291,236) (1,291,236)204,830 035 NEW TRANSPO SYS IMPR AREA F 1,878,239 - - - (1,733,154) - (1,733,154) (1,733,154)145,080 054 SANITARY SEWER CAPITAL 16,314,420 60,000 - 60,000 (16,373,531) - (16,373,531) (16,313,531)890 055 SEWER CONNECTION FEE 7,644,013 1,140,400 - 1,140,400 (8,770,613) - (8,770,613) (7,630,213)13,800 058 RESIDENTIAL STREET IMPROVEMENT 5,238,339 450,000 - 450,000 (300,000) - (300,000) 150,000 5,388,340 059 SELECT STREET CONSTRUCTION 20,333,430 6,289,660 36,030,710 42,320,370 (53,003,021) - (53,003,021) (10,682,651)9,650,780 147 FEDERAL AID SAFETY PROGRAM (508,190) 715,728 - 715,728 (1,664,540) - (1,664,540) (948,812)(1,457,000) 148 TRAFFIC SYSTEM MGMT GRANT (4,833,337) 36,439,014 - 36,439,014 (31,717,146) - (31,717,146) 4,721,868 (111,470) 161 PRCSA CAPITAL GRANTS (1,036,427) 11,502,451 - 11,502,451 (10,528,785) - (10,528,785) 973,666 (62,760) 162 ENERGY CONSERVATION PROGRAM 16,404 - - - (104,807) - (104,807) (104,807)(88,400) 164 PWA ENTERPRISE CAPITAL GRANTS (3,771,970) 16,147,492 - 16,147,492 (12,375,522) - (12,375,522) 3,771,970 - 223 LOCAL DRAINAGE AREA III 421,887 - - - (38,609) (125,000) (163,609) (163,609)258,280 224 LOCAL DRAINAGE AREA IV 419,915 - - - (401,396) - (401,396) (401,396)18,520 226 LOCAL DRAINAGE AREA VI 381,053 - - - (150,000) - (150,000) (150,000)231,050 301 REC/COMM SVS 6,067 126,805 - 126,805 (126,805) - (126,805) - 6,070 311 RESIDENTIAL DEVELOP DISTRICT 1 3,288,547 - - - (409,425) (2,383,974) (2,793,399) (2,793,399)495,150 312 RESIDENTIAL DEVELOP DISTRICT 2 5,412,408 - - - (3,159,914) - (3,159,914) (3,159,914)2,252,490 313 RESIDENTIAL DEVELOP DISTRICT 3 13,236,091 - - - (8,881,429) - (8,881,429) (8,881,429)4,354,660 314 RESIDENTIAL DEVELOP DISTRICT 4 652,881 - - - (91,042) (528,039) (619,081) (619,081)33,800 315 HARBOR SPECIFIC ACQUISITION & DEVELOPMENT - - 2,912,013 2,912,013 (2,912,013) - (2,912,013) - - 400 POLICE UUT LEASE REVENUE BONDS 11,612 - 4,622,100 4,622,100 (4,621,800) - (4,621,800) 300 11,910 404 COSA 2014 LEASE FINANCING 71,218 - 5,156,070 5,156,070 (5,156,070) - (5,156,070) - 71,220 418 CDA CAPITAL PROJECTS 1,336,719 - - - (1,336,719) - (1,336,719) (1,336,719)- 992 TRAN SYS IMP AUT AREA B 10,641,688 - - - (3,167,999) - (3,167,999) (3,167,999)7,473,690 Capital Project Funds Total 70,354,598 142,966,095 48,720,893 191,686,988 (220,433,472) (3,037,013) (223,470,485) (31,783,497) 38,571,110 DEBT SERVICE FUND 406 2021 PENSION OBLIGATION BONDS - - 15,340,770 15,340,770 (15,331,870) - (15,331,870) 8,900 8,900 Debt Service Fund Total - - 15,340,770 15,340,770 (15,331,870) - (15,331,870) 8,900 8,900 GRAND TOTAL - ALL FUNDS 583,359,695$ 1,051,212,934$ 145,404,945$ 1,196,617,879$ (1,274,222,132)$ (145,405,095)$ (1,419,627,228)$ (223,009,349)$ 360,350,320$