Loading...
CC SR 20220517 04 - FY 2022-23 Preliminary Budget v14 CITY COUNCIL MEETING DATE: 05/17/2022 AGENDA REPORT AGENDA HEADING: Regular Business AGENDA TITLE: Consideration and possible action to review the Fiscal Year 2021-22 year-end estimates, the FY 2022-23 Preliminary Budget, and estimated fund balances for all funds, excluding Improvement Authorities. RECOMMENDED COUNCIL ACTION: (1) Review the FY 2021-22 year-end estimates and approve Budget Adjustments in the General Fund by reducing the budget in the amount of $1,738,900 in Personnel and $661,000 in Non-Personnel and increasing Transfers-Out by $754,800 based on the third quarter year-end estimates; (2) Review the Preliminary FY 2022-23 Budget for the General Fund and affirm the changes since the Budget Workshop and the funding priorities for the projected surplus: • Increase the General Fund Revenues by $1.2 million. • Increase the General Fund Personnel costs by $189,300 for establishing the City of Rancho Palos Verdes Internship Program, Recruitment Incentive Program, funding for temporary Staff Assistant I for the Human Resources Division and restoring the Administrative Analyst I for the City Clerk Division. • Increase General Fund Non-Personnel costs by $570,000 for the Street Landscape and Tree Maintenance Program and the cost for the design/plan for the Arterial Walls and Fences Aesthetic Improvements Program. • Increase General Fund Transfers-Out by $458,700 for the additional transfers to Capital Infrastructure Program (CIP) Fund to reflect the projected increase in Transient Occupancy Taxes (TOT). • Increase General Fund Transfers-Out to the CIP Fund for the remaining projected surplus of approximately $1.6 million; and (3) Review and approve the Preliminary FY 2022-23 Budget consisting of the Capital Infrastructure Program (CIP) Fund, Special Revenue Funds, and Internal Service Funds, and excluding the Improvement Authorities and affirm the revised list for the FY 2022-23 Capital Improvement Program. FISCAL IMPACT: The FY 2022-23 Preliminary Citywide Budget includes total revenues of $50.6 million and total expenditures of $54.4 million for all funds, before transfers. The total FY 2022-23 Preliminary Budget for General Fund revenues are $35.7 million, and expenditures are $30.5 million, excluding transfers. 1 Amount Budgeted: N/A Additional Appropriation: N/A Account Number(s): None ORIGINATED BY: Christopher Browning, Senior Administrative Analyst Vina Ramos, Deputy Director of Finance REVIEWED BY: Trang Nguyen, Director of Finance APPROVED BY: Ara Mihranian, AICP, City Manager ATTACHED SUPPORTING DOCUMENTS: A. FY 2021-22 Proposed Budget Adjustments for Savings and Unused Budget (page A-1) B. FY 2022-23 Preliminary Budget Summary (page B-1) C. FY 2022-23 CIP Status and Five-year CIP (page C-1) D. March 23, 2022, General Fund Budget Workshop staff report E. April 13, 2022, Capital Improvement Program Workshop staff report BACKGROUND: On March 23, 2022, the City Council held its annual General Fund Budget Workshop, where Staff presented FY 2021-22 year-end estimates and the list of assumptions used to develop the FY 2022-23 Proposed Budget for the General Fund. Staff also informed the City Council that an updated year-end report would be prepared at the conclusion of the third quarter and presented as part of the FY 2022-23 Preliminary Budget staff report in May. Additionally, on April 13, 2022, the City Council held the Capital Improvement Program (CIP) Workshop to receive a status report on the current FY 2021-22 CIP, and at the same meeting, Staff presented the FY 2022-23 Proposed Five-Year CIP. At the end of both workshops, Staff received direction needed to prepare the FY 2022-23 Preliminary Budget. Based on the direction from City Council at these workshops, the information presented tonight for the City Council highlights the changes from the FY 2022-23 Proposed Budget to FY 2022-23 Preliminary Budget. The comprehensive staff report for the proposed budget will be presented at the June 7 public hearing meeting. As illustrated on the following page, if the changes presented this evening are accepted, the City Council will conduct a public hearing on June 7 to consider adopting the budget on June 21. 2 DISCUSSION: 1. FY 2021-22 General Fund Year-End Estimate Changes At the March 23, 2022 Budget Workshop, Staff presented the estimated FY 2021-22 General Fund year-end revenues and expenditures. Staff reported that the estimated General Fund ending fund balance would be approximately $28.6 million, including transfers-out. After applying the City Council’s 50% Reserve Policy, the General Fund’s estimated Excess Unrestricted Fund Balance would be roughly $15.4 million. Over the past few weeks, Staff reviewed the most current information available on revenues and expenditures. Based on this re-assessment, Staff is projecting the Unrestricted Excess Reserve to end the year at approximately $15.2 million, a decrease of $222,200 or 1% from the mid-year staff report. Table 1 summarizes the comparison of the mid-year and third quarter year-end estimates. The “FY 2021-22 YE Changes” column represents the difference between the mid-year and the third quarter year-end estimates. Table 1 –General Fund Balance – Year-end Estimates General Fund FY 2021-22 Revised Budget FY 2021-22 Year-End Estimates (Mid-Year) FY 2021-22 Year-End Estimates (3rd Qtr) Beginning Fund Balance - 7/1/2021 25,798,773 25,798,773 25,798,773 Add: Revenues 30,075,700 32,946,100 34,778,700 1,832,600 6% Add: Transfers-In 350,000 350,000 350,000 - 0% Total Revenues 30,425,700 33,296,100 35,128,700 1,832,600 6% Less: Expenditures - Operating (28,680,921) (26,281,138) (26,281,138) - 0% Less: Expenditures - Land (1,300,000) - (1,300,000) 1,300,000 N/A Less: Transfers to CIP (2,553,000) (3,528,300) (4,283,100) 754,800 21% Less: Transfers to Pension (640,000) (640,000) (640,000) - 0% Less: Other Transfers-Out (85,000) (85,000) (85,000) - 0% Total Expenditures (33,258,921) (30,534,438) (32,589,238) 2,054,800 7% Estimated Ending Fund Balance - 6/30/2022 22,965,552 28,560,435 28,338,235 (222,200) -1% 50% Reserve Policy 13,709,200 13,140,569 13,140,569 - 0% Unrestricted Excess/(Deficit) Reserve - 06/30/22 9,256,352 15,419,866 15,197,666 (222,200) -1% FY 2021-22 YE Changes 3 Below is the detailed explanation of the FY 2021-22 General Fund Year-End Estimates at the end of the third quarter, ended on March 31, 2022. FY 2021-22 Revenues Year-End Estimate Changes During the third quarter financial review, Staff reviewed all revenue data reported to the City since mid-year, with the period ending December, and prepared new year-end projections. Based on new trends, Staff estimates an increase in revenue from $33.3 million to $35.1 million, including transfers, a $1.8 million or 6% increase. This increase is attributed to the continuing recovery of several of the City’s revenue sources as the effects of the economic slowdown caused by the pandemic wane. A summary of the changes to the year-end estimates for the General Fund revenues is outlined below. Property Tax Staff is making a minor adjustment to property tax revenue reducing year-end estimates by $318,100 or 2% from $16.1 million to $15.7 million . This adjustment is to reflect projections for the portion of property tax revenue received in place of Vehicle License Fees (VLF). In addition to the regular apportionment of property taxes, cities and counties receive property tax revenues in lieu of VLF. This is due to the fact that in 2004, the Legislature permanently reduced the VLF rate from 2% to 0.65% and subsequently compensated cities and counties for their revenue loss with a like amount of property taxes, dollar-for-dollar. VLF is received from most vehicle owners. Owners are required to pay a vehicle license fee instead of the fee being included in their property tax. This fee can be deducted from their income tax and is based on the purchase price or value of the vehicle. The VLF decreases during each of the vehicle’s first 11 renewal years, or until the vehicle is transferred, whichever happens first. Staff will continue to monitor this revenue source throughout the remainder of this fiscal year. Property Tax FY 21-22 Budget: $14,960,300 FY 21-22 YE at Midyear: $16,062,200 FY 21-22 YE at Third Quarter: $15,744,100 Net Change to Year-End: -$318,100 or -2% Transient Occupancy Tax (TOT) Since the temporary closure of Terranea Resort and all amenities from March 19 to June 12, 2020, and several months of stay-at-home orders that were put in place across the state, TOT revenue has been challenging to project. However, TOT revenue has seen steady growth over the past year. Through March 2022, TOT revenue has reached just over $3.7 million. Based on the most current information received from Terranea and economic trends, Staff projects an additional $1.9 million in TOT revenue for the remaining three months of FY 2021-22. Combined with a projected $96,000 in miscellaneous TOT revenue for April through June, TOT revenue is expected to reach $5.8 million, a $794,800 or 16% increase to original projections. Staff will continue to monitor revenue and report any significant deviations from these projections. 4 Transient Occupancy Tax FY 21-22 Budget: $3,978,400 FY 21-22 YE at Midyear: $4,955,300 FY 21-22 YE at Third Quarter: $5,750,100 Net Change to Year-End: +$794,800 or +16% Sales Tax Revenue in this category experienced a strong and consistent recovery this fiscal year which has led Staff to update year-end estimates, increasing projections $147,200 or 6.2% from $2.4 million to $2.5 million. The City’s 1% Bradley-Burns cash revenue increased by 47.3% during the fourth quarter compared to the same period in 2020. The majority of the fourth quarter growth was focused on the restaurants and hotels segment as Terranea continues to trend upward on the path to full recovery. Although the resort increased over 330% during the quarter, local tax receipts are still about 27% below pre- pandemic levels, suggesting longer recovery than most segments. Other than Terranea, golf clubs/courses lifted the leisure/entertainment category and all restaurant segments had strong performances. Marshalls reported its strongest sales quarter in its history which boosted general consumer goods along with higher taxable sales from the mortuary and memorial park. Sales Tax FY 21-22 Budget: $2,163,400 FY 21-22 YE at Midyear: $2,363,400 FY 21-22 YE at Third Quarter: $2,510,600 Net Change to Year-End: +$147,200 or +6.2% Permits and Fees This revenue source is comprised of roughly 1 4 permit and fee types, such as Building and Safety permits, plan check permits, planning and zoning permits, and animal licenses. Due to the variety of items, revenue can vary from year to year. The Community Development Department, which brings in roughly 93% of all license and permit revenue, projects that this revenue source will see an increase of $681,200 or 26.4% over the FY 2021-22 year-end estimate of $2.6 million, bringing total revenue to $3.3 million. This increase in revenue is led by $400,000 projected increases to Building and Safety Permits, $105,000 in Plan Check Permits, $85,000 in Geology Permits, and $60,000 in Planning and Zoning Permits. To date, the average total number of permits and other building activities has outperformed the previous fiscal year, lifting activity levels upward to pre-pandemic levels. Implementation of the new fee structure in July 2021 has also supported the growth. 5 Permits and Fees FY 21-22 Budget: $2,083,100 FY 21-22 YE at Midyear: $2,582,700 FY 21-22 YE at Third Quarter: $3,263,770 Net Change to Year-End: +$681,200 or +26.4% Utility Users Tax (UUT) Revenue from UUT is dependent on a number of outside factors including weather conditions, consumption of utilities, natural gas prices, and rate increases. UUT revenue is projected to surpass Staff’s original estimates of $2 mill ion by $292,100 or 14.4% reaching $2.3 million at year-end. Staff will continue to monitor this revenue source and report any significant deviations from these projections. Utility Users Tax FY 21-22 Budget: $1,915,000 FY 21-22 YE at Midyear: $2,025,000 FY 21-22 YE at Third Quarter: $2,317,100 Net Change to Year-End: +$292,100 or +14.4% Other Taxes and Miscellaneous Revenues This revenue category consists of over 30 unique revenue sources including business license tax, golf tax, interest earnings, rental/lease, and parking lot fees. Staff is adjusting the year-end estimate to $3 million, up $235,400 or 8.4% from the original estimate of $2.8 million. This increase is largely attributed to continued recovery in revenue from Recreation Programs/Events and Facilities Rentals/Leases. The increase in Miscellaneous Revenues includes one-time revenues such as rent damage charges and traffic accident reimbursements. Staff will continue to monitor all components of the category for any significant changes. Other Taxes and Miscellaneous Revenues FY 21-22 Budget: $2,825,500 FY 21-22 YE at Midyear: $2,807,500 FY 21-22 YE at Third Quarter: $3,042,900 Net Change to Year-End: +$235,400 or +8.4% Table 2 on the next page summarizes the Year-End Estimates and Third Quarter Year- End Estimates for FY 2021-22 revenue. 6 Table 2 –General Fund Year-End Estimates – Revenues FY 2020-21 Expenditures Year-End Estimate Changes Since the March 23 Budget Workshop, Staff identified two changes to report on expenditures for a total increase of almost $2.1 million. On April 13, the City Council approved an additional appropriation of $1.3 million for the Purchase and Sale Agreement and Joint Escrow Instructions to purchase and manage certain real properties commonly known as the Lower Filiorum and Plumtree properties. The amount was approved to be funded from the General Fund’s Unrestricted Excess Reserves. Any other new operating expenditures approved by the City Council since March were approved to be funded through savings and underspent budget line items from non-personnel and personnel. In addition to the $1.3 million change, Staff projects the Transfers-Out to increase by $754,800 or 18% over mid-year estimates to account for the estimated increase in revenue from TOT from Terranea Resort. The amount is an increase of the General Fund transfer to the CIP Fund. After applying the above changes, Staff projects the year-end expenditures increasing from $30.5 million to $32.6 million or 7% over mid-year estimates, including transfers-out and as presented below. With the exception of these two changes, the other details of the expenditure year-end assumptions and savings were previously presented to the City Council at the Budget Workshop on March 23 (Attachment E). Non-Personnel: FY 21-22 Revised Budget: $17,950,721 FY 21-22 YE at Midyear: $15,989,838 FY 21-22 YE at Third Quarter: $17,289,838 Net Change to Year-End: $1,300,000 or 8% FY 2021-22 Revenue Actuals Current Budget Year-End Estimates @ Mid-Year Year-End Estimates @ 3rd Qtr Property Tax 15,081,503 14,960,300 16,062,200 15,744,100 (318,100) -2.0% Transient Occupancy Tax 3,115,435 3,978,400 4,955,300 5,750,100 794,800 16.0% Sales Tax 1,919,332 2,163,400 2,363,400 2,510,600 147,200 6.2% Permits & Fees 2,007,453 2,083,100 2,582,700 3,263,900 681,200 26.4% Franchise Tax 2,203,130 2,150,000 2,150,000 2,150,000 0 0.0% Utility Users Tax 2,245,826 1,915,000 2,025,000 2,317,100 292,100 14.4% Other Taxes & Misc. Revenues 3,540,141 2,825,500 2,807,500 3,042,900 235,400 8.4% Subtotal $30,112,821 $30,075,700 $32,946,100 $34,778,700 $1,832,600 5.6% Transfers In 130,000 350,000 350,000 350,000 0 0.0% Total Revenues $30,242,821 $30,425,700 $33,296,100 $35,128,700 $1,832,600 5.5% FY 2020-21 FY 2021-22 Year-End Estimates Mid-Year vs 3rd Qtr 7 Personnel Costs FY 21-22 Revised Budget: $12,030,200 FY 21-22 YE at Midyear: $10,291,300 FY 21-22 YE at Third Quarter: $10,291,300 Net Change to Year-End: $0 Transfers-Out: FY 21-22 Revised Budget: $3,278,000 FY 21-22 YE at Midyear: $4,253,300 FY 21-22 YE at Third Quarter: $5,008,100 Net Change to Year-End: $754,800 or 18% Table 3 below is a summary of the Midyear Year-End Estimates and Third Quarter Year- End Estimates for FY 2021-22 General Fund Expenditures. Table 3 –General Fund Year-End Estimates – Expenditures As part of the annual process, Staff recommends adjusting the FY 202 1-22 Revised Budget to align with the third quarter year-end estimates for personnel, non-personnel, and transfers-out. This process would release the identified savings and unused budget back to the fund balance. As such, Staff seeks City Council acceptance of the General Fund’s budget adjustments below with a net reduction of $1,645,100. Additional budget account details are also presented in Attachment A. • Personnel – reduce FY 2021-22 Revised Budget by $1,738,900. • Non-Personnel - reduce FY 2021-22 Revised Budget by $661,000. • Transfers-Out – increase FY 2021-22 Revised Budget by $754,800. FY 2020-21 FY 2021-22 Expenditure Type Actuals Revised Budget Year-End Estimastes (@ Mid-Year) Year-End Estimastes (@ 3rd Qtr) FY 2021-22 Year-End Estimates Mid-Year vs. 3rd Qtr Salaries 7,316,601$ 8,652,400$ 7,284,500$ 7,284,500$ 0 0% Benefits 2,655,670 3,377,800 3,006,800 3,006,800 0 0% Legal Services 884,672 940,000 933,100 933,100 0 0% Sheriff Contract 6,970,901 7,150,200 7,150,200 7,150,200 0 0% Supplies 452,592 605,586 611,586 611,586 0 0% Professional/Technical 2,212,629 3,357,671 2,870,589 2,870,589 0 0% Repairs and Maintenance 2,648,882 2,698,174 2,676,259 2,676,259 0 0% Training/Conference 151,514 346,405 268,119 268,119 0 0% Misc. Expense 1,148,479 1,552,685 1,479,985 1,479,985 0 0% Capital - Land 0 1,300,000 0 1,300,000 1,300,000 N/A Subtotal 24,441,940 29,980,921 26,281,138 27,581,138 1,300,000 5% Transfers Out 1,750,819 3,278,000 4,253,300 5,008,100 754,800 18% Total Expenditures 26,192,759$ 33,258,921$ 30,534,438$ 32,589,238$ 2,054,800$ 7% 8 Any substantial changes to year-end estimates will be reported in the FY 2021-22 unaudited actuals presented for the City Council’s review in December. Subsequently, Staff will present an audited final report of the Annual Comprehensive Financial Report (ACFR) in January 2023. 2. FY 2022-23 General Fund Preliminary Budget Changes Overview At the March 23 Budget Workshop, the City Council approved the presented budget assumptions for expenditures and revenues to develop the FY 2022-23 Preliminary Budget for the General Fund. Based on the assumptions, Staff projected almost $34.9 million of revenues, including transfers, which is an increase of approximately $4.4 million or 14.5% over FY 2021-22 budget and $1.6 million or 4.7% over FY 2021-22 year-end estimates. The City Council also approved the proposed expenditure budget of $34.5 million, including transfers out, which is an increase of $2.5 million or 7.9% over the FY 2021-22 revised budget. Of this amount, $889,500 is a transfer out to the CIP Fund and $400,000 is a transfer out to the Pension Fund. In accordance with City Council Policy No. 41 and Pension Guidelines, the amount must be funded from the prior year’s surplus. As such, the proposed operating budget was reported at $33.2 million, resulting an operating surplus of approximately $1.6 million. That same evening, Staff presented options to the City Council to fund other possible priorities utilizing a portion of the estimated surplus of $1.6 million. Subsequently, the City Council approved including the following funding in the FY 2022-23 Preliminary Budget: • $134,700 for Personnel - summarized in the budget changes section • The City Council may prioritize the remaining surplus for City Council Goals, operating, and additional Transfers-Out to the CIP Fund. Since the Budget Workshop, Staff received additional information resulting in an increase in revenue projections. In addition, in light of the estimated surplus, the Finance Department collaborated with the department heads to discuss funding opportunities to improve the City’s operations. Finally, due to the increase in revenue projections for the TOT, the estimated Transfers-Out from the General Fund to the CIP Fund would also increase. Hence, the following breakdown summarizes changes to the FY 2022-23 Preliminary Budget: • Increase $1.2 million in Revenues • Increase $570,000 for Non-Personnel • Increase $54,600 for Personnel • Increase $458,700 for Transfers-Out Overall, if the above proposed changes are approved by the City Council tonight, Staff estimates that the FY 2022-23 Operating Revenues are approximately $35.7 million 9 (before transfers-in) and Operating Expenditures of $30.5 million, before transfers-out and excluding one-time expenditures. Despite the proposed budget increase in expenditures, the additions are offset by the increase in revenues. As illustrated in Table 4, Staff estimates a surplus of over $5.2 million, before transfers-out and one-time expenditures. After applying the transfers and one-time expenditures, the General Fund is estimated to have a surplus of almost $1.6 million on June 30, 2023. The surplus of $1.6 million remains the same from the Budget Workshop as the increase in expenditures were offset by the increase in revenues. Table 4: General Fund Revenues and Expenditures Summary A detailed explanation of the changes for the FY 2022-23 Proposed General Fund Budget to the Preliminary General Fund Budget is provided below. FY 2022-23 Revenues Preliminary Budget Changes Since the Budget Workshop, Staff has received additional information and updated the revenue projections for FY 2022-23. Overall, revenue, excluding transfers, is projected to reach $35.7 million, an increase of $1.2 million over previously provided projections of $34.6 million. Three categories that experienced material changes are outlined below. Transient Occupancy Tax (TOT) At the Budget Workshop, the figures provided to the City Council were prepared based upon the best information available. Staff projected that TOT revenue would reach $5.3 million during FY 2022-23. Since this meeting, TOT revenue has shown continued recovery and growth. However, much is still unknown as to how demand for leisure travel will be impacted during FY 2022-23 as the country remains in an elevated inflation environment and the cost of travel rises to meet pent up demand. For these reasons Staff is increasing the year-end estimate by $478,400 or 9.1% to $5.8 million to match FY 2021 - 22 year-end estimate. There is not enough evidence at this point in time to infer the amount of growth to be expected next fiscal year, but economic trends do not signal that revenue would fall from FY 2021-22 year-end expectations. Staff will continue to monitor this revenue source and consult with Terranea throughout the remainder of this fiscal year and next fiscal year. General Fund Recurring One-Time Total Operating Revenues 35,654,700 72,300 35,727,000 Less: Operating Expenditures 29,602,100 911,300 30,513,400 Structural Surplus/(Deficit)6,052,600 (839,000) 5,213,600 Transfers-In - 300,000 300,000 Less: Transfers-Out 3,870,200 65,000 3,935,200 Surplus/(Deficit)2,182,400$ (604,000)$ 1,578,400$ 10 Transient Occupancy Tax FY 21-22 Year-End Estimate: $5,750,100 FY 22-23 Proposed Budget: $5,271,700 FY 22-23 Preliminary Budget: $5,750,100 Net Change: +$478,400 or +9.1% Permits and Fees Revenue projections have been adjusted to reflect updates from the Community Development Department (CDD). Staff is projecting revenue to reach $3.1 million, up $360,500 or 13.3% from the original estimate of $2.7 million. The projected increase is led by $210,000 projected increases to Building Safety Permits, $58,000 to Plan Check Permits, and $73,000 to Geology Permits. This change is consistent with the increase in activities and the year-end estimates. On May 3, 2022, the City Council approved the FY 2022-23 Master Schedule of Fees. The City Council approved Staff’s recommendations not to increase the fees by the March 2022 Urban Consumer Price Index (CPI-U) of 8.5% and approved adding five new fees for CDD. At this time, Staff does not expect the added fees will have a material impact to this revenue source. Staff will continue to work with CDD Staff to monitor this category and adjust if needed. Permits and Fees FY 21-22 Year-End Estimate: $3,263,900 FY 22-23 Proposed Budget: $2,717,100 FY 22-23 Preliminary Budget: $3,077,600 Net Change: +$360,500 or +13.3% Utility Users Tax Revenue projections have been adjusted to reflect FY 2021-22 growth and economic trends. Staff estimates that revenue will reach $2.2 million, up $276,200 or 14.3% from the original estimate of $1.9 million. This update was made to reflect the upward trend in UUT revenue experienced each fiscal year since FY 2019-20 growing from $1.9 million to an estimated $2.3 million. This increase can be attributed to increased consumption due to a larger portion of the population working from home during the pandemic and utility providers increasing rates. It’s important to note that the City has not increased its 3% UUT rate, however, as utility providers increase their rates the revenue generated by the City’s 3% UUT tax also increases. This revenue source will continue to be monitored throughout the year to observe whether the trend of increasing revenues will continue into next fiscal year or descend to levels typically seen in prior fiscal years. Utility Users Tax FY 21-22 Year-End Estimate: $2,317,100 FY 22-23 Proposed Budget: $1,925,000 FY 22-23 Preliminary Budget: $2,201,200 Net Change: +$276,200 or +14.3% 11 Table 5 below is a summary of the FY 22-23 Preliminary Budget in terms of revenue and Chart 1 is a percentage revenue allocation of each category. Table 5 –General Fund Preliminary Budget – Revenues Chart 1 –Preliminary Budget - Revenue Allocation Based on the information presented above, Staff seeks City Council affirmation increasing the FY 2022-23 Preliminary Budget Revenues by approximately $1.2 million. FY 2022-23 Revenue Year-End Estimates @ 3rd Qtr Budget Workshop Updated Budget @ 3rd Qtr Property Tax 15,744,100 16,550,800 16,406,800 (144,000) -0.9% Transient Occupancy Tax 5,750,100 5,271,700 5,750,100 478,400 9.1% Sales Tax 2,510,600 2,583,700 2,687,200 103,500 4.0% Permits & Fees 3,263,900 2,717,100 3,077,600 360,500 13.3% Franchise Tax 2,150,000 2,150,000 2,150,000 0 0.0% Utility Users Tax 2,317,100 1,925,000 2,201,200 276,200 14.3% Other Taxes & Misc. Revenues 3,042,900 3,352,400 3,454,100 101,700 3.0% Subtotal $34,778,700 $34,550,700 $35,727,000 $1,176,300 3.4% Transfers In 350,000 300,000 300,000 0 0.0% Total Revenues $35,128,700 $34,850,700 $36,027,000 $1,176,300 3.4% FY 2022-23 Budget Workshop vs Preliminary Budget FY 2021-22 12 FY 2022-23 General Fund Expenditures Changes Since the Budget Workshop, the following section summarizes additional information on the requested increase of $1.2 million from the FY 2022-23 Proposed General Fund Budget to the FY 2022-23 Preliminary General Fund Budget. Personnel Costs Personnel costs account for the salaries and benefits for City employees, including full - time, part-time, and stipend for the City Council and Planning Commissioners. At the March 23 Budget Workshop, Staff reported that the estimated budget FY 202 2-23 for salaries is approximately $9.1 million and $3.3 million in benefits, totaling approximately $12.4 million. Since the Budget Workshop, the total proposed increase is $189,300 or 2% over the proposed budget, as follows: • $60,000 for establishing a Recruitment Incentive Program. This new program would assist in the recruitment and appointment of qualified individuals into hard-to-recruit positions, in accordance with the guidelines approved by the City Council. • $36,300 for Human Resources for a temporary part-time Staff Assistant I. This temporary position will assist with the technical day-to-day functions of Human Resources including processing of department mail and responding to emails and phone calls; scheduling and coordinating logistics of trainings; maintaining employee personnel files; assisting in onboarding of new employees and transitioning to their new position; overseeing employee events and annual employee recognition; and assisting with initial contact regarding leave administration and benefit administration. • $38,400 for Administrative Analyst I. This amount is the net increase from continuing to underfill the Administrative Analyst II while providing a career ladder for the Administrative Staff in the City Clerk’s office. • $54,600 for establishing an internship program supporting the City Council Goal of Citizen Involvement and Public Outreach. The City of Rancho Palos Verdes Internship Program is a structured academic opportunity that allows students to apply academic skills and knowledge in the workplace. Experiential education based on learning objectives helps students prepare to meet career responsibilities after graduation. The program's goals are to allow students to apply, evaluate, test, and integrate academic knowledge and theoretical concepts in a work setting. The program will offer students the opportunity to gain valuable work experience in their desired career field and learn the ins and outs of local government. Interns will work hands-on within City departments to complete projects, survey reports, assessments, etc. Every internship is unique, and assignments will vary depending on which internship matches their 13 field. The program will be extended to high school students and/or college students who are enrolled in or are a recent graduate of an academic program. As previously reported at the Budget Workshop, the City is conducting a comprehensive classification and compensation study and organizational review for all full-time and part- time employees. This study has not been completed and therefore any potential financial impact is not included in the Preliminary Budget. Additionally, the City is in the process of the collective bargaining process with the Rancho Palos Verdes Employees Association (RPVEA). Thus, at this time, Staff is estimating personnel costs for FY 2022-23 using the same terms from the MOU that is currently in place. Staff will continue to provide an update of the results from the study and the bargaining process once the information and financial impact becomes available. In summary, the revised Personnel category is as follows: Personnel Costs FY 21-22 Year-End Estimate: $10,291,300 FY 22-23 Proposed Budget: $12,429,900 FY 22-23 Preliminary Budget: $12,619,200 Net Change: +$189,300 or +2% Non-Personnel Costs The non-personnel category includes the Los Angeles County Sheriff contract, legal services, professional and technical services, repairs and maintenance, supplies, training and conferences, and miscellaneous/other expenses. At the March 23 Budget Workshop, Staff reported that the FY 2022-23 proposed budget is approximately $17.3 million. Since the Budget Workshop, the total proposed increase is $570,000 or 3% over proposed budget and is as follows: • $450,000 (Public Works) – Street Landscape and Tree Maintenance Program. The Public Works Department has been receiving requests for higher levels of service for landscape and tree maintenance. This includes more frequent and comprehensive landscaping of arterial street medians and parkways, increased tree trimming throughout the City, more view restoration work, and requests for planting of new trees and general beautification in various locations. • $10,000 (Community Development) – Design/Plan for arterial fences. The budget for the Arterial Walls and Fences Aesthetic Improvements Program in the CIP has been adjusted to reflect developing a master plan utilizing City Staff. The master plan being developed will be part of CDD’s regular operations and consideration for CIP funding will occur as part of the CIP process after the master plan is complete. • $50,000 (Recreation and Parks) –Supplemental funding to enhance all existing events such as Concerts, Movies, Holiday, July 4th, Whale of a Day, etc. Each event/program will have the opportunity to be enhanced for the public’s benefit. 14 • $45,000 (Recreation and Parks) – Installation of a staff trailer at Forrestal Reserve Parking area which includes connections for utilities, and rentals of a trailer a nd portable restrooms. Staff will have presence at this lot for the full shift rather than having to go elsewhere for breaks and/or restrooms. • $15,000 (Recreation and Parks) - New uniforms for all part time staff including work shirts, jackets, and head gear. Incorporates input from full and part time staff and promotes Staff to look professional and consistent for easy recognition by the public. Inclusive of the changes above, the revised Non-Personnel category for FY 2022-23 Preliminary Budget is as follows: Non-Personnel Costs FY 21-22 Year-End Estimate: $17,289,838 FY 22-23 Proposed Budget: $17,324,200 FY 22-23 Preliminary Budget: $17,894,200 Net Change: +$570,000 or +3% As described above, Staff seeks City Council affirmation on the budget increases in Personnel for $189,300 and Non-Personnel for $570,000. Transfers Out Transfers out are considered a part of General Fund expenditures which include transfers to the CIP Fund, Employee Pension Service Plan Fund, and other funds such as the City’s Improvement Authority for Portuguese Bend and Sub -region One. At the March 23 Budget Workshop, Staff reported that the estimated FY 2022-23 General Fund transfers to the CIP Fund would be approximately $3.4 million. This amount is based on the estimated TOT revenues from Terranea Resort of approximately $5.1 million less the cumulative annual increases in the public safety contract of almost $1.7 million. Based on the most current TOT revenue information, Transfers-Out is estimated to increase by $458,700 or 9%. The breakdown below reflects the revised amount for the FY 2022-23 Preliminary Budget: Transfers-Out FY 21-22 Year-End Estimate: $5,008,100 FY 22-23 Proposed Budget: $4,766,000 FY 22-23 Preliminary Budget: $5,224,700 Net Change: +$458,700 or +9% Staff seeks City Council affirmation on the budget increase of $458,700 in Transfers-Out to the CIP Fund. 15 In summary, after applying the proposed changes described above, t he following Table 6 and Chart 2 summarize the FY 2022-23 Preliminary General Fund Expenditures by category and by department. Table 6: Preliminary General Fund Expenditures – By Category Chart 2: FY 2022-23 Preliminary General Fund Expenditures – Allocations by Department FY 2022-23 Department FY 2021-22 Year-end Estimates Proposed Budget Preliminary Buget Proposed vs. Preliminary Budget Changes City Administration 2,895,236$ 3,523,800$ 3,653,100$ 129,300$ 4% City Council 97,500 110,700 110,700 0 0% Community Dev.3,195,700 4,122,300 4,132,300 10,000 0% Eoc 194,000 0 0 0 0% Finance 1,345,300 1,491,500 1,491,500 0 0% Legal Services 934,100 950,000 950,000 0 0% Non-Dept.3,311,200 2,213,100 2,273,100 60,000 3% Public Safety 7,504,130 7,627,700 7,627,700 0 0% Public Works 4,925,872 6,021,200 6,471,200 450,000 7% Rec & Parks 3,178,100 3,663,800 3,773,800 110,000 3% Subtotal 27,581,138 29,724,100 30,483,400 759,300 3% Transfers Out CIP - TOT 4,283,100 3,411,500 3,870,200 458,700 13% Transfers Out CIP & Other 85,000 954,500 954,500 0 0% Transfers Out - Pension 640,000 400,000 400,000 0 0% Grand Total 32,589,238$ 34,490,100$ 35,708,100$ 1,218,000$ 4% 16 FY 2022-23 Estimated Fund Balance Based on the adjusted revenue projections and the identified additions to the expenditures, the estimated General Fund balance on June 30, 2023, would be approximately $29.9 million. Compared to the estimate of $30.2 million presented at the March 23 Budget Workshop, the fund balance is projected to be reduced by $298,400 or 1%. Additionally, based on the increase in proposed operating expenditures, the City Council Reserve Policy of 50% would increase by $396,900, resulting in a total of $695,300 million or a 5% reduction in Unrestricted Excess Reserve since the Budget Workshop. Overall, as previously mentioned, the proposed increases in expenditures of $1.2 million are offset by the increase in revenues of $1.2 million, hence, resulting the General Fund surplus to remain at approximately $1.6 million since the Budget Workshop. FY 2022-23 is then projected to end the year again with a healthy Unrestricted Excess Reserve of almost $13.4 million, as summarized in Table 7 below. Table 7: General Fund Estimated Fund Balance FY 2022-23 One-Time and Recurring Revenues and Expenditures As reported at the March 23 Budget Workshop, after capturing the regulatory increases and new ongoing programs, the FY 2022 -23 Proposed Budget positively exceeds the requirement pursuant to City Council Policy No. 45, Balanced Operating Budget. The City has a structurally balanced operating budget with a surplus of almost $5.7 million (operating revenues minus operating expenditures). After including all operating expenditures, one-time expenditures, and transfers, the General Fund was estimated to end strong and anticipated to have a surplus of almost $1.6 million. General Fund FY 2021-22 Year-End Estimates FY 2022-23 Proposed Budget FY 2022-23 Preliminary Budget Beginning Fund Balance - 7/1/2022 25,798,773 28,560,435 28,338,235 (222,200) -1% Add: Revenues 34,778,700 34,550,700 35,727,000 1,176,300 3% Add: Transfers-In 350,000 300,000 300,000 - 0% Total Revenues 35,128,700 34,850,700 36,027,000 1,176,300 3% Less: Expenditures (26,281,138) (29,719,600) (30,513,400) 793,800 3% Less: Expenditures - Land (1,300,000) - - - 0% Less: Transfers to CIP (TOT) (4,283,100) (3,411,500)(3,870,200) 458,700 13% Less: Transfers to Pension (640,000) - - - 0% Less: Other Transfers-Out (85,000) (65,000) (65,000) - 0% Total Expenditures (32,589,238) (33,196,100) (34,448,600) 1,252,500 4% Estimated Ending Fund Balance - 6/30/2023 28,338,235 30,215,035 29,916,635 (298,400) -1.0% Less: Transfers to CIP (Other)- (889,500) (889,500)- 0% Less: Transfers to Pension - (400,000) (400,000)- 0% 50% Reserve Policy 13,140,569 14,859,800 15,256,700 396,900 3% Estimated Unrestricted Excess/(Deficit) Reserve - 06/30/23 15,197,666 14,065,735 13,370,435 (695,300) -5% FY 2022-23 Changes 17 As summarized in Table 8 below, after combining all the proposed changes detailed in this report, the revised operating surplus remains strong at $5.2 million and after including all expenditures, the surplus is almost $1.6 million Based on the City Council direction from the Budget Workshop, Staff seeks City Council affirmation to allocate the $1.6 million as an additional transfer to the CIP Fund which would bolster funding for future City capital projects. Table 8 – General Fund Recurring vs. One-time Revenues and Expenditures 3. Capital Improvement Program Funds In addition to the General Fund Budget Workshop, on April 1 3, 2022, the City Council conducted a workshop focusing on the capital program. Staff provided the City Council information on the different categories of capital projects including Completed Projects, Revenue Type Recurring One-time Total Property Tax 16,406,800$ $ - 16,406,800$ Transient Occupancy Tax 5,750,100 - 5,750,100 Sales Tax 2,687,200 - 2,687,200 Franchise taxes 3,077,600 - 3,077,600 Utility Users Tax 2,150,000 - 2,150,000 Permits & Fees 2,201,200 - 2,201,200 Other Taxes & Misc. Revenues 3,381,800 72,300 3,454,100 TOTAL REVENUES $ 35,654,700 $ 72,300 $35,727,000 Expenditure by Program Recurring One-time Total City Council 110,700$ $ - 110,700$ City Administration 3,436,800 216,300 3,653,100 City Attorney 950,000 - 950,000 Public Safety 7,627,700 - 7,627,700 Finance 1,491,500 - 1,491,500 Community Development 3,812,300 350,000 4,162,300 Public Works 6,276,200 195,000 6,471,200 Recreation & Parks 3,773,800 - 3,773,800 Non-department 2,123,100 150,000 2,273,100 TOTAL EXPENDITURES $ 29,602,100 $ 911,300 $30,513,400 STRUCTURAL SURPLUS/(DEFICITS)6,052,600 (839,000) 5,213,600 Transfers in - 300,000 300,000 Transfers out 3,870,200 65,000 3,935,200 SURPLUS/(DEFICIT)2,182,400$ (604,000)$ 1,578,400$ FUND 101 - GENERAL FUND FY 2022-23 RECURRING VS. ONE-TIME REVENUES AND EXPENDITURES 18 Ongoing Programs/Projects, New Projects, and a Wants/Needs List of projects. The City Council approved the proposed projects for FY 2022-23 with the following changes: • Restoration and Installation of “Bubbles” Statue (84LY2) – renamed and moved to Needs/Wants List. • Palos Verdes Drive South Intersection Improvements (8828) – budget adjusted to move work proposed in FY 2022-23 to FY 2024-25 and FY 2025-26, and adjusted budget to reflect escalation and impacts of revised schedule. • Arterial Walls and Fences Aesthetic Improvements Program – Citywide (8811) – adjusted budget to reflect developing a master plan using in-house City Staff. The master plan being developed will be part of CDD’s regular operations and consideration for CIP funding will occur as part of the CIP process after the master plan is complete. • Palos Verdes Drive East (at Bronco Drive) Widening and Path Improvements (8839) – split into two projects. • Palos Verdes Drive East Traffic Improvements (8854) added to FY 2022-23. • Path Improvements (8839) remains on the Needs/Wants List, and “Expenses/Commitments to Date” has been updated. • Western Avenue Traffic Congestion Improvements (8809) – renamed to Western Avenue Traffic Flow Improvements. • Retaining Wall Repairs at 3001 Crest Road (8853) – project added to CIP in FY 2022-23. The funding for the capital improvement program is comprised of the CIP Fund and Special Revenue Funds. The CIP Fund’s main source of revenue comes from the TOT Transfers-Out from the General Fund. The other funding sources for the capital improvement program are from the City’s Special Revenues. For FY 2022-23 approved projects, the proposed funds are from the Gas Tax, American Rescue Plan Act (ARPA), Proposition C, Measure R, Measure M, Quimby, and Grants. Staff ensures that the Special Revenue Funds are utilized for any qualified project before CIP Fund reserves are appropriated. Based on the direction that Staff received from the April 13 Budget Workshop, the FY 2022-23 Preliminary Budget for the capital improvement program decreased by approximately $1.1 million, from $19.4 million to almost $18.3 million. Table 9 on the next page is a summary list of the approved projects for FY 2022-23 and Table 10 summarizes the funding allocations. Additional information on the approved projects for FY 2022-23 funding is also captured in Attachments C, and E. 19 Table 9: Preliminary Budget – Capital Improvement Program Project Code Project Description Amount 8202 Abalone Cove Sanitary Sewer System Rehabilitation Program 3,300,000$ 8302 Palos Verdes Drive South Landslide Area Resurfacing Program 930,000 8304 Portuguese Bend Landslide Remediation 535,000 8423 Palos Verdes Nature Preserve Gate for the Rattlesnake Trail 210,000 8424 Park Monument Signs 350,000 8503 New Civic Center Complex 340,000 8508 Restroom Improvements at the Point Vicente Interpretive Center 350,000 8509 Facilities Asset Management Program 250,000 8701 Storm Drain Asset Management Program 450,000 8708 Altamira Canyon Improvements (Erosion)450,000 8715 Stormwater Drainage Improvements 1,195,000 8004 Traffic Signs Replacement Program 215,000 8801 Sidewalk Repair and Replacement Program 460,000 8808 Pavement Management Program – Arterial Roadway Rehabilitation 1,520,000 8809 Western Avenue Traffic Flow Improvements 385,000 8810 CDBG Americans with Disabilities Act - Infrastructure Improvements 150,000 8816 Pavement Management Program – Residential Roadway Rehabilitation - Area 1 4,145,000 8840 Western Avenue Beautification (long term)140,000 8843 Arterial Roadway Rehabilitation - Silver Spur Road (North of Hawthorne Boulevard)1,815,000 8846 Traffic Calming Program - Citywide 535,000 8847 Guardrail Improvements along Palos Verdes Drive East 105,000 8851 Arterial Roadway Beautification Program 100,000 8852 City Entrance Roadway Monument Signs 200,000 8853 Retaining Wall at 3001 Crest Road 100,000 8854 Palos Verdes Drive East Traffic Improvements 50,000 TOTAL 18,280,000$ 20 Table 10: Preliminary Budget – Budget Allocations FY 2022-23 Estimated Fund Balance – Capital Improvement Program (CIP) Funds Overall, at the end of FY 2021-22, the CIP funds are estimated to receive $13.4 million in revenues and $8 million in capital loan for a total of $21.4 million. There are $3.3 million of estimated capital project expenditures and $1.9 million of maintenance expenditures. After applying the City Council Reserve Policy, the estimated Excess Reserve for all funds in the capital improvement program is $40.5 million. The major increase in the fund balance is from the $8 million loan from Bank of the West for the Ladera Community Park Project. Table 11 below summarizes the FY 2021-22 estimated revenues, expenditures, fund balance, and excess reserves. Table 11 –Estimated Fund Balance - Capital Improvement Program Funds Fund Fund Name FY 2022-23 Preliminary Budget 202 Gas Tax 1,700,000$ 215 Proposition C 900,000 220 Measure R 1,400,000 221 Measure M 385,000 310 CDBG 150,000 330 CIP 9,283,000 331 Federal Grants 105,000 333 ARPA 4,247,000 340 Bicycle & Ped (TDA)110,000 TOTAL Subtotal 18,280,000$ CIP Fund ARPA Gas Tax Measure R Other Special Revenues TOTAL Beginning Fund Balance - 7/1/21 26,391,050 - 614,761 1,381,260 881,252 29,268,323 Add: Revenues 200,000 4,982,400 1,950,600 534,300 1,445,980 9,113,280 Add: Other Financing Source - BOW 8,000,000 8,000,000 Add: Transfers In 4,283,100 - - - - 4,283,100 Total Revenues and Other Financing Sources 12,483,100 4,982,400 1,950,600 534,300 1,445,980 21,396,380 Less: Capital Project (1,691,000) (672,600) (121,500) (93,700) (704,400) (3,283,200) Less: Operating Expenses - - (1,053,000) - (875,000) (1,928,000) Less: Transfers Out - - - - - - Total Expenditures (1,691,000) (672,600) (1,174,500) (93,700) (1,579,400) (5,211,200) Estimated Ending Fund Balance - 6/30/22 37,183,150 4,309,800 1,390,861 1,821,860 747,832 45,453,503 Less: City Council Reserve Policy (5,000,000) - - - - (5,000,000) Estimated Excess Reserve - 06/30/22 32,183,150 4,309,800 1,390,861 1,821,860 747,832 40,453,503 *Other Special Revenues - Proposition C, Measure M, CDBG, Federal Grant, Bicycle and Ped (TDA) 21 Furthermore, as summarized in Table 12, based on the FY 2021-22 year-end estimates and the FY 2022-23 approved projects, the FY 2022-23 CIP Preliminary Budget includes $15.8 million of revenues and expenditures of $39.4 million. Of this amount, approximately $18.3 million are for new projects, $19.5 million are for ongoing projects that are estimated to be carried over from FY 2021-22 to FY 2022-23, and approximately $1.7 million are for annual maintenance. After applying the estimated ongoing projects to be carried over, the CIP Fund is estimated to end the year with an Excess Reserve of $14 million, ARPA at $1.1 million, Gas Tax at $372,600, Measure R at $643,700, and $694,600 for Other Special Funds. Table 12 –Estimated Fund Balance - Capital Improvement Program Funds Special Revenues The City’s Special Revenues are taxes and other revenues set aside for a specific or restricted purpose. The City’s major special revenue funds are the Gas Tax, Proposition A, ARPA, Proposition C, Measure R, Measure M and Quimby. In addition to funding the CIP projects, the Special Revenues are also designated for operating expenditures such as street maintenance, public facility upgrades and maintenance, public right-of-way maintenance, park upgrades, park maintenance, and transit related expenses. Table 13 on the next page is a summary of the estimated FY 2022-23 fund balances for the Other Special Revenue Funds. These fund balance amounts are based on expenditures expected next year. ` CIP Fund ARPA Gas Tax Measure R Other Special Revenues TOTAL Beginning Fund Balance - 7/1/22 37,183,150 4,309,800 1,390,861 1,821,860 747,832 45,453,503 Add: Revenues 200,000 4,759,700 2,160,700 640,400 3,327,100 11,087,900 Add: Transfers In 4,759,700 - - - - 4,759,700 Total Revenues 4,959,700 4,759,700 2,160,700 640,400 3,327,100 15,847,600 Less: Capital Projects (9,283,000) (4,247,000) (1,700,000) (1,400,000) (1,650,000) (18,280,000) Less: Estimated Cont. Appropriation and PO Carryover (13,854,200) (3,684,200) (498,800) (418,600) (1,049,300) (19,505,100) Less: Operating Expenses - - (980,100) - (681,000) (1,661,100) Less: Transfers Out - - - - - - Total Expenditures (23,137,200) (7,931,200) (3,178,900) (1,818,600) (3,380,300) (39,446,200) Estimated Ending Fund Balance - 6/30/23 19,005,650 1,138,300 372,661 643,660 694,632 21,854,903 Less: City Council Reserve Policy (5,000,000) - - - - (5,000,000) Estimated Excess Reserve - 06/30/23 14,005,650 1,138,300 372,661 643,660 694,632 16,854,903 *Other Special Revenues - Proposition C, Measure M, CDBG, Federal Grant, Bicycle and Ped (TDA) 22 Table 13 – FY 2022-23 Estimated Fund Balance – Special Revenue Funds Internal Service Funds The City uses an Internal Service Fund (ISF) as an accounting mechanism to accumulate and allocate costs internally among the City’s various functions. The City uses of Equipment Replacement Fund (ERF) to account for its fleet of vehicles, computer systems, furniture and equipment, and Employee Pension Service Fund (EPSF) to account for employee pension service costs, as described below. The funding and uses for the ISF is typically from the General Fund and restricted by the City Council. Equipment Replacement Fund The Equipment Replacement Fund (ERF) is an internal service fund that is used to accumulate funding to replace City equipment, furniture, and vehicles at the end of the designated life cycle. The equipment replacement charges are General Fund expenditures for all departments and the same amounts are then recorded as revenues in the ERF. Based on the recently modified City Council Policy No. 41 Reserve Policies, the City will maintain a minimum reserve of 75% but no more than 100% of the estimated replacement cost for equipment assets that are due to be replaced in the City’s next fiscal year. Staff estimates that the ERF will continue to have excess reserves by the end of FY 2022-23. Therefore, Staff recommends annual charges of $283,800 to meet the minimum reserve of 75% instead of 100% of estimated replacement costs. The same amount is recorded as revenues in ERF plus estimated interest earnings of $30,000. For expenditures, the estimated amount is approximately $602,700 or 22% of the replacement value. As with Special Revenue Funds Estimated Beginning Fund Balance - 7/1/2022 $ 17,025,667 Add: Revenues 14,386,700 Add: Transfers-In from General Fund 50,000 Total Revenues 14,436,700 Less: Expenditures (13,653,200) Less: Transfers-Out (300,000) Total Expenditures (13,953,200) Estimated Ending Fund Balance - 6/30/2023 17,509,167 Restricted by City Council Policy (938,900) Estimated Excess/(Deficit) Reserve - 06/30/23 16,570,267$ 23 previous years, before replacing any fully funded equipment/vehicles, Staff will continue to assess the status and extend the life of the asset when possible. As a result, the projected fund balance on June 30, 2023, is $2.1 million and after applying the $2 million City Council policy reserves, the ERF is estimated to end the year with an excess reserve of approximately $79,200 as illustrated in Table 14. Employee Pension Service Fund On February 2, 2021, the City Council approved the CalPERS Pension Plan Guidelines which provides a financial plan to address the City’s outstanding pension liability and CalPERS’ continuous change in valuation methodology. Based on City Council’s discretion, the goal is to transfer funds to the Employee Pension Service Fund of at least 10%, but no more than 25%, of the annual General Fund surplus (revenues minus expenditures, including transfers). As a result, the accumulated funds in the Employee Pension Service Fund would then relieve the General Fund of payment more than $900,000 of the City’s Unfunded Accrued Liability (UAL). Since the inception of the pension guidelines, the Employee Pension Service Fund is estimated to end FY 2021-22 with a fund balance of $640,000. Based on the audited year-end results of FY 2020-21, the City’s surplus was over $4 million. Therefore, during the March 23 Budget Workshop, the City Council approved Staff’s recommendation of transferring $400,000 or 12% of the surplus from the General Fund to Employee Pension Service Fund in FY 2022-23. Furthermore, in accordance with the City’s Pension Guidelines the Employee Pension Service Fund may relieve the General Fund of UAL payment in excess of $900,000. At the March 23 Budget Workshop, the City Council also approved Staff’s recommendation relieving the General fund of $242,000 in the employee benefit category. In summary, Table 13 on the next page includes the estimated FY 2022-23 fund balance for Internal Service Funds. 24 Table 13 – FY 2022-23 Estimated Fund Balance – Internal Service Funds Based on the information presented above, Staff seeks City Council affirmation for the FY 2022-23 Preliminary Budget for the CIP Funds based on the revised CIP list, Special Revenue Funds, and Internal Service Funds. ADDITIONAL INFORMATION: American Rescue Plan Act (ARPA) Update On April 13, 2022, the City Council held the CIP Workshop to receive a status report on the current FY 2021-22 CIP and the FY 2022-23 Proposed Five-Year CIP. At this meeting, the Public Works Department also proposed revising the spending plan to maximize the probability of spending all ARPA funds by December 31, 2026 (the revised spending plan is listed in detail in Attachment F). Staff will bring a separate staff report in August or September to amend the ARPA spending plan for City Council consideration. In April, Staff submitted the first compliance report required by the U.S. Department of the Treasury. Table 14 below is a summary of the status expenditure report for the nine ARPA projects with obligated funds and expenditures. Equipment Replacement Fund Employee Pension Service Fund TOTAL Estimated Beginning Fund Balance - 7/1/2022 $ 2,381,672 $ 640,000 $ 3,021,672 Add: Revenues 313,800 - 313,800 Add: Transfers-In from General Fund - 400,000 400,000 Total Revenues 313,800 400,000 713,800 Less: Expenditures (602,700) (242,000)(844,700) Less: Transfers-Out - - - Total Expenditures (602,700) (242,000) (844,700) Estimated Ending Fund Balance - 6/30/2023 2,092,772 798,000 2,890,772 Restricted by City Council Policy (2,013,600) - (2,013,600) Estimated Excess/(Deficit) Reserve - 06/30/23 79,172$ 798,000$ 877,172$ 25 Table 14 – ARPA Status Report Review of Utility Users Tax (UUT) The UUT is a source of revenue for the City that continues to be a necessary revenue for the City’s operating needs. On March 23, during the Budget Workshop, the City Council approved continuing the 3% rate for UUT. There are no changes since the Budget Workshop, therefore, the FY 2022-23 Preliminary Budget for General Fund includes approximately $2.2 million or 6% of the total General Fund revenues. Review of the Golf Tax Rancho Palos Verdes Municipal Code Section 3.40.140 requires a legislative review of golf tax every four years, to be completed prior to the adoption of the budget prepared for the corresponding next fiscal year. The golf tax ordinance directs the City Council to determine, based on the needs of the City, if any modification to the tax rate is necessary or if the tax should be repealed. During the May 21, 2019, Budget Workshop for FY 2019- 20, the City Council approved the golf tax without any modifications. Accordingly, the ne xt review will be in 2023 during the FY 2023-24 budget process. CONCLUSION: Since the Budget Workshop, Staff estimates the General Fund will continue to end FY 2022-2023 with a surplus of almost $1.6 million. This is a combination of an increase of $1.2 million in revenues (from $34.9 million to $36 million), $1.2 million in expenditures (from $33.2 million to $34.4 million) and $396,900 due to the City Council reserve policy. After applying the additional transfers from the prior year’s reserves, the General Fund is Project Name ARPA Approved Funding Total Obligations and Expenditures 03/31/2022 Balance Project Status Ladera Linda Community Center and Park Project $3,953,000 $3,953,000 $0 Project in-progress Restroom Improvements at Point Vicente Interpretive Center $385,000 $4,000 $381,000 Project in-progress Storm Water Drainage Improvement - PVDS at Peppertree $1,035,000 $0 $1,035,000 Scheduled for FY 2022-23 Park Monument Signage $350,000 $0 $350,000 Scheduled for FY 2022-23 Hesse Park Technology Upgrades $270,000 $69,555 $200,445 Project in-progress Information Technology Infrastructure Upgrades $250,000 $8,125 $241,875 Project in-progress Replenishment of the City's Emergency Supplies $100,000 $0 $100,000 Project in-progress Development of a Peninsula-wide Evacuation Plan $100,000 $0 $100,000 Project in-progress Wildfire Monitoring Cameras $125,000 $0 $125,000 Project in-progress TOTAL $6,568,000 $4,034,680 $2,533,320 Investment in Capital Infrastructure (Improvements and Repairs) Investment in Technology Infrastructure Investment in Protection of Life and Property 26 projected to end FY 2022-23 with a healthy Unrestricted Excess Reserve of almost $13.4 million. The CIP Fund is estimated to end FY 2022-23 with an Unrestricted Excess Reserve of $14 million, net of the $5 million City Council Reserve Policy. This amount also includes the estimated $19.5 million of ongoing projects to be carried over from FY 2021 -22. Staff will request for City Council’s approval to carry over the projects during the FY 2021 -22 unaudited actuals presented for the City Council’s review in December. The Special Revenues Funds and Internal Service Funds are also estimated to end FY 2022-23 with stable fund balances. The Special Revenue Funds are estimated at approximately $16.6 million and Internal Service Funds are estimated to have an Unrestricted Excess Reserve of almost $877,200. Staff seeks City Council acceptance of the Preliminary FY 2022-23 Budget consisting of the General Fund, CIP, and Special Revenues, excluding the Improvement Authorities. Any direction from the City Council based on the figures presented in this report will be incorporated in the draft budget that Staff will present at a duly noticed public hearing to be held by the City Council on June 7, 2022. ALTERNATIVES: In addition to the Staff recommendation, the following alternative action s are available for the City Council’s consideration: 1. Provide Staff with further direction for consideration at the budget public hearing on June 7, 2022. 2. Discuss and take other action related to this item. 27 Proposed Budget Adjustments FY 2021-22 Savings and Unused Budget Account Type Department Fund Account Object Code Justification FY 2021-22 Proposed Budget Adjustments Personnel Salaries and Benefits City Administration, Community Development, Public Works, Recreation and Parks, Finance General Fund 4101 - 4105 4201 - 4207 Savings/unused budget from City-wide vacancies, deferred recruitments.(1,738,900)$ Total - Personnel (1,738,900)$ Non-Personnel Professional/Technical City Administration, Community Development, Public Works, Recreation and Parks, Legal General Fund 5101, 5119 Savings/unused budget from contracting and consulting services.(493,982) Repairs & Maintenance Public Works, Community Development, Recreation & Parks General Fund 5201 Savings/unused budget from contracts and delayed projects.(22,032) Training/Conference City Administration, Community Development, Public Works, Recreation and Parks General Fund 4601, 6001, 6002 City-wide savings/unused budget from trainings and conferences.(78,286) Supplies and Other Misc. Expenses City Administration, Community Development, Public Works, Recreation and Parks General Fund 4310-4901, 6201 City-wide savings/unused budget from supplies and small equipment.(66,700) Total - Non-Personnel (661,000)$ Transfers-Out Transfers Transfers to CIP General Fund CIP 101-400-0000-9330 330-300-0000-9101 Additional transfers based on year-end estimates for TOT. 754,800 Total - Tranfers-Out 754,800$ Total Proposed Budget Adjustments - General Fund (1,645,100)$ A-1 STATEMENT OF REVENUES - ALL FUNDS FY 2022-23 Fund Description Actuals FY 2018-19 Actuals FY 2019-20 Actuals FY 2020-21 Estimated Year-End FY 2021-22 Budget Workshop FY 2022-23 Preliminary Budget FY 2022-23 General Fund 32,092,448 29,540,207 30,281,020 35,128,700 34,850,700 36,027,000 Administrative Overhead 169,356 149,507 99,507 100,000 155,700 155,700 Animal Licenses 31,365 26,734 28,803 28,800 28,900 27,400 Building & Safety Admin Fees (521) 559 (53) 1,000 - 1,000 Building & Safety Permits 1,152,758 954,408 1,050,030 1,800,000 1,500,000 1,710,000 Building & Safety SMIP 1,367 977 (362) 2,900 300 2,800 Business License Penalty 12,501 20,505 6,184 14,400 13,000 13,000 Business License Taxes 945,792 896,166 675,299 689,000 680,000 680,000 CASP Fees 7,604 5,635 5,360 4,500 4,500 4,500 Code Enforcement Citations 12,674 15,338 46,053 45,800 138,000 138,000 Donations 14,355 9,465 2,875 36,700 54,500 39,500 False Alarm 18,200 11,250 7,400 4,800 4,800 4,800 Federal Grants - - 515,258 - - - Film Permits 2,930 20,081 2,671 37,000 30,000 28,500 Franchise Taxes 2,149,743 2,146,037 2,203,130 2,150,000 2,150,000 2,150,000 Geology Permits 128,272 124,614 152,099 235,000 150,000 223,300 Golf Taxes 429,049 394,765 632,886 600,000 540,000 540,000 Interest Earnings 366,409 358,232 186,670 160,000 192,000 192,000 Miscellaneous Revenue 455,840 186,264 145,048 250,200 157,600 251,000 Parking Lot Fees 215,341 237,209 417,037 220,000 230,000 260,000 Parking Permit Decals 988 590 594 600 600 600 Parking Permits-Oversized Veh.440 628 375 200 300 200 Plan Check Permits 393,433 335,342 307,328 530,000 445,000 503,500 Planning & Zoning Permits 401,764 330,124 362,786 485,000 445,000 460,800 Planning Investigation Fees 20,000 - - - - - Planning Misc. Permits 7,769 7,848 8,622 8,000 8,000 7,600 Preserve Park Citation - - 200 100 - - Program/Event Fees 91,012 51,137 17,900 123,700 219,900 139,900 Property Tax 8,236,989 8,576,363 9,072,028 9,471,100 10,008,800 10,008,800 Property Taxes - In Lieu of VLF 4,920,186 5,150,914 5,384,633 5,533,300 5,992,000 5,848,000 Property Taxes - RPTTF RDA 50,255 55,594 54,130 54,000 50,000 50,000 Property Transfer Tax 359,706 401,021 570,712 685,700 500,000 500,000 PVIC Sales Taxable 137,551 92,494 12,840 99,500 120,000 120,000 RDA Administrative Fees - - 40,000 - 24,000 - RDA Loan Repayment 139,938 114,494 239,062 154,400 283,800 283,800 Rental/Leases 518,728 388,006 324,180 472,200 416,800 514,100 ROW - Dumpster Permits 4,606 3,626 3,038 2,200 3,000 2,400 ROW - Misc Permits 74,329 106,186 76,205 123,000 95,000 99,800 Sales Of Signs/Services 1,400 1,200 - - - - Sales Taxes 2,575,202 2,079,675 1,829,019 2,426,900 2,500,000 2,603,500 Sales Taxes (PSAF)85,979 83,667 90,313 83,700 83,700 83,700 State Grants 1,359 - - - - - Tow Fees 6,225 5,976 5,229 5,800 5,800 5,800 Traffic Tickets 91,460 95,301 199,353 61,800 112,000 112,000 Transfer - Measure A Maint 90,000 100,000 150,000 50,000 50,000 Transfer - Public Safety 130,000 175,000 130,000 200,000 250,000 250,000 Transfer - Water Quality 72,384 - - - - - Transient Occ. Taxes - Misc 250,345 144,747 145,816 220,000 200,300 220,000 Transient Occ. Taxes-Terranea 5,395,152 3,765,052 2,969,619 5,530,100 5,071,400 5,530,100 Utility Users Taxes - Elec.876,304 874,220 1,042,287 990,000 875,000 940,500 Utility Users Taxes - Gas 334,373 354,920 378,656 427,100 350,000 405,700 Utility Users Taxes - Water 706,430 683,230 824,882 900,000 700,000 855,000 View Restroration Permits 5,106 5,106 15,318 10,200 11,000 9,700 Gas Tax 1,812,817 1,823,295 1,765,073 1,950,600 2,160,700 Interest Earnings 7,466 21,853 5,548 5,400 5,400 Miscellaneous Revenue 145,779 145,679 77,200 - - State Gas Tax - SB1 837,064 737,134 773,632 862,500 949,200 State Grants 822,508 918,629 908,693 1,082,700 1,206,100 B-1 STATEMENT OF REVENUES - ALL FUNDS FY 2022-23 Fund Description Actuals FY 2018-19 Actuals FY 2019-20 Actuals FY 2020-21 Estimated Year-End FY 2021-22 Budget Workshop FY 2022-23 Preliminary Budget FY 2022-23 1972 Act Landscape/Light 541 501 240 200 200 Interest Earnings 541 501 240 200 200 El Prado Lighting District 7,982 8,079 7,883 200 200 Interest Earnings 600 597 312 200 200 Property Tax 7,382 7,482 7,571 - - 1911 Act Street Lighting 731,985 958,138 782,857 806,000 808,000 Interest Earnings 37,878 24,346 12,912 13,000 13,000 Miscellaneous Revenue 208,102 - - - Property Tax 694,107 725,690 769,945 793,000 795,000 Beautification 10,000 Interest Earnings 10,000 - - - - Waste Reduction 263,666 268,665 250,989 189,600 194,600 Interest Earnings 8,680 7,564 3,606 4,600 4,600 State Grants 66,844 66,469 60,152 - - Waste Reduction Fees 188,142 194,632 187,231 185,000 190,000 Air Quality Management 56,827 55,749 55,700 55,500 55,500 Interest Earnings 1,413 1,915 1,208 1,500 1,500 Local Grants 55,414 53,834 54,492 54,000 54,000 Proposition C 729,861 701,418 744,465 705,200 846,800 Interest Earnings 15,733 14,727 8,185 6,200 6,200 Local Grants 714,128 686,691 710,280 699,000 840,600 Miscellaneous Revenue - - 26,000 - - Proposition A 1,499,830 874,799 869,939 853,200 1,023,900 Interest Earnings 38,887 46,964 13,627 10,500 10,500 Local Grants 860,943 827,835 856,312 842,700 1,013,400 Transfer - State Grants 600,000 - - - - Public Safety Grants 150,863 158,079 157,786 158,800 151,200 Interest Earnings 2,116 2,131 1,059 1,200 1,200 State Grants 148,747 155,948 156,727 157,600 150,000 Measure R 569,889 533,060 544,634 534,300 640,400 Interest Earnings 34,139 18,778 11,186 10,000 10,000 Local Grants 535,750 514,282 533,448 524,300 630,400 Measure M 604,922 580,618 606,661 596,000 1,316,300 Interest Earnings 1,365 1,877 2,244 1,800 1,800 Local Grants 603,557 578,741 604,417 594,200 1,314,500 Habitat Restoration 44,753 43,525 30,892 12,400 12,400 Interest Earnings 44,753 40,025 30,892 - - Miscellaneous Revenue - 3,500 - - - State Grants - - - 12,400 12,400 Subregion One Maintenance 14,969 48,442 16,298 44,000 64,000 Interest Earnings 14,969 13,442 6,298 14,000 14,000 Transfer - General Fund - 35,000 10,000 30,000 50,000 Measure A Maintenance 88,282 94,466 153 190,200 90,200 Interest Earnings 1,648 503 153 200 200 Local Grants 86,634 93,963 190,000 90,000 Abalone Cove Sewer District 57,079 970,055 54,025 52,000 52,000 Interest Earnings 6,407 7,676 2,045 2,000 2,000 Transfer - Infrastructure - 910,000 - - - Property Tax 50,672 52,379 51,980 50,000 50,000 Ginsburg Cultural Art Bld 1,800 1,800 Interest Earnings 1,800 1,800 - - - Donor Restricted Contribution 75,613 23,560 23,195 49,300 43,300 Donations 59,523 9,900 16,700 24,300 18,300 Interest Earnings 16,090 13,660 6,495 25,000 25,000 CDBG 178,591 226,364 115,063 144,800 60,000 Federal Grants 178,591 226,364 115,063 144,800 60,000 B-2 STATEMENT OF REVENUES - ALL FUNDS FY 2022-23 Fund Description Actuals FY 2018-19 Actuals FY 2019-20 Actuals FY 2020-21 Estimated Year-End FY 2021-22 Budget Workshop FY 2022-23 Preliminary Budget FY 2022-23 Capital Improvement Fund 7,306,458 3,078,825 1,935,958 2,753,000 4,959,700 Federal Grants 5,007 - - - - Interest Earnings 508,963 471,473 214,382 200,000 200,000 Miscellaneous Revenue - - 757 - - Transfer - Federal Grants 2,490,636 196,600 - - - Transfer - General Fund 4,301,852 2,410,752 1,720,819 2,553,000 4,759,700 Federal Grants 143,442 2,000 1,104,000 Federal Grants 141,442 - - - 1,104,000 Interest Earnings 2,000 2,000 - - - State Grants 1,709,965 1,826,179 44,850 100 100 Interest Earnings - - - 100 100 State Grants 1,709,965 1,826,179 44,850 - - Federal Grants-ARPA 4,987,400 4,952,600 Federal Grants - - - 4,967,400 4,932,600 Interest Earnings - - - 20,000 20,000 Quimby Park Development 135,272 23,090 33,513 10,000 10,000 Developer Fees 102,000 - 23,652 - - Interest Earnings 33,272 23,090 9,861 10,000 10,000 Low-Moderate Income Housing 124,340 118,261 148,010 31,600 31,600 Interest Earnings 2,956 3,237 1,845 1,600 1,600 Property Taxes - RPTTF RDA 34,984 28,624 59,765 30,000 30,000 RDA Loan Repayment 86,400 86,400 86,400 - - Affordable Housing Projects 15,961 17,290 19,584 4,300 4,300 Interest Earnings 15,961 14,846 7,143 4,300 4,300 Miscellaneous Revenue - 2,444 12,441 - - Environmental Excise Tax 48,419 122,132 6,177 19,400 22,400 Developer Fees 39,020 114,694 3,902 17,000 20,000 Interest Earnings 9,399 7,438 2,275 2,400 2,400 Bicycle/Pedestrian Access 511 28,000 110,000 Local Grants - - 511 28,000 110,000 Measure W 679,381 683,800 682,000 Interest Earnings - - - 2,000 2,000 Local Grants - - 679,381 681,800 680,000 Water Quality/Flood Protection 200,000 State Grants 200,000 - - - - Equipment Replacement 351,159 131,736 114,965 330,400 303,800 Equipment Replacement Charges 300,900 84,600 93,600 310,400 283,800 Interest Earnings 50,259 46,686 21,365 20,000 20,000 Miscellaneous Revenue - 450 - - - Employee Pension Service Fund 640,600 400,600 Interest Earnings - - - 600 600 Transfer - General Fund - - - 640,000 400,000 Grand Total 49,027,734 42,230,333 39,289,822 50,959,600 56,127,800 B-3 STATEMENT OF EXPENDITURES - ALL FUNDS FY 2022-23 General Fund Actuals FY 2018-19 Actuals FY 2019-20 Actuals FY 2020-21 Estimated Year-End FY 2021-22 Budget Workshop FY 2022-23 Preliminary Budget FY 2022-23 Transfers Out 4,346,852 2,550,752 1,750,819 5,008,100 4,766,000 5,224,700 Transfers Out 4,346,852 2,550,752 1,750,819 5,008,100 4,766,000 5,224,700 City Council 96,252 89,739 84,681 97,500 110,700 110,700 City Council 96,252 89,739 84,681 97,500 110,700 110,700 Legal Services 1,171,414 1,133,168 886,407 934,100 950,000 950,000 Legal Services - City Admin 1,171,414 1,133,168 886,407 934,100 950,000 950,000 Public Safety 7,118,805 7,335,482 7,233,951 7,504,130 7,627,700 7,627,700 Sheriff's Contract 6,335,382 6,683,678 6,970,901 7,150,200 7,254,000 7,254,000 Special Programs 783,423 651,804 263,050 353,930 373,700 373,700 City Administration 2,914,410 3,081,690 2,721,361 2,895,236 3,523,800 3,653,100 City Clerk Administration 448,394 424,365 392,362 399,100 473,100 511,500 City Clerk Election 1,338 298,089 9,566 - 154,300 154,300 City Manager 791,758 645,233 628,592 683,500 768,400 823,000 Community Outreach 62,246 63,415 82,978 69,800 73,400 73,400 Emergency Preparedness 103,418 24,563 16,829 97,761 210,800 210,800 Human Resources 302,544 364,038 309,885 344,215 437,000 473,300 Information Technology - Data 928,885 975,570 979,005 971,760 1,055,700 1,055,700 Information Technology - Voice 96,277 103,792 117,369 120,500 131,000 131,000 RPVtv 179,550 182,625 184,775 208,600 220,100 220,100 EOC - 404,281 322,056 194,000 - - Emergency Operation Center - 404,281 322,056 194,000 - - Finance 1,502,164 1,634,788 1,458,001 1,345,300 1,491,500 1,491,500 Finance Administration 1,502,164 1,634,788 1,458,001 1,345,300 1,491,500 1,491,500 Public Works 5,191,137 5,714,008 4,646,168 4,925,872 6,021,200 6,471,200 Building Maintenance 453,630 448,644 477,391 504,975 528,250 528,250 Fuel Modification - 1,041,109 415,389 540,000 650,400 650,400 Parks Maintenance 585,192 726,663 618,404 759,432 847,200 847,200 Public Works Administration 2,155,312 2,092,585 1,934,346 2,071,800 2,939,700 2,939,700 Sewer Maintenance 22,550 42,278 22,830 28,000 35,000 35,000 Storm Water Quality 535,920 479,833 472,168 36,190 1,000 1,000 Street Landscape Maintenance 573,850 147,382 232,493 188,000 213,000 663,000 Traffic Safety 418,941 276,284 120,558 324,375 364,500 364,500 Trails & Open Space Maint 404,280 421,325 306,370 417,600 379,150 379,150 Vehicles Maintenance 41,462 37,905 46,219 55,500 63,000 63,000 Community Development 3,039,196 2,857,235 2,623,915 3,195,700 4,122,300 4,132,300 Animal Control 82,061 102,083 94,282 166,000 295,000 295,000 Building & Safety 826,227 678,640 598,490 651,200 866,800 866,800 Code Enforcement 184,457 222,319 208,263 263,000 272,400 272,400 Community Development Admin 670,902 584,244 528,887 678,500 813,600 823,600 Geology 107,253 111,100 144,068 150,000 150,000 150,000 Nccp 11,445 - 47,284 - - - Planning 835,016 774,259 616,938 918,200 1,334,100 1,334,100 View Restoration 321,835 384,590 385,703 368,800 390,400 390,400 Recreation and Parks 2,687,330 2,533,171 2,650,848 3,178,100 3,663,800 3,773,800 Abalone Cove Shoreline Park 135,175 129,636 137,950 119,300 213,100 213,100 City Run Sports & Activities 3,065 3,165 400 - 11,500 11,500 Contract Classes 41,695 33,717 1,890 46,000 65,000 65,000 Eastview Park 7,354 52,684 65,572 71,800 84,400 84,400 Fred Hesse Jr. Park 187,973 180,952 174,918 150,000 213,600 213,600 Ladera Linda Community Center 86,409 67,534 74,828 131,800 58,700 58,700 Open Space Management 235,721 198,816 179,058 179,300 193,300 238,300 Other Recreational Facilities 64,465 10,251 2,569 1,800 - - Parking Enforcement - - - 108,500 108,300 108,300 Point Vicente Inter. Center 513,420 457,537 427,698 459,700 470,500 470,500 Preserve Park Rangers - 145,827 272,887 343,700 389,300 389,300 Reach 69,328 20,789 43,008 70,900 72,000 72,000 Recreation & Parks Holding - - 686 - - - Recreation Administration 1,026,906 964,028 990,768 1,051,900 1,261,300 1,276,300 Robert E. Ryan Park 92,391 81,168 109,586 94,600 120,200 120,200 Special Events & Programs 194,344 160,550 141,020 322,300 369,300 419,300 Support Services 29,084 21,195 23,310 21,500 28,300 28,300 Volunteer Program - 5,322 4,700 5,000 5,000 5,000 Non-Department 1,133,906 1,204,534 1,814,562 3,311,200 2,213,100 2,273,100 Non-Departmental 1,133,906 1,204,534 1,814,562 3,311,200 2,213,100 2,273,100 Total - General Fund 29,201,466 28,538,848 26,192,769 32,589,238 34,490,100 35,708,100 B-4 STATEMENT OF EXPENDITURES - ALL FUNDS FY 2022-23 Other Funds: Special Revenues and Internal Service Funds Actuals FY 2018-19 Actuals FY 2019-20 Actuals FY 2020-21 Estimated Year-End FY 2021-22 Budget Workshop FY 2022-23 Preliminary Budget FY 2022-23 Gas Tax 830,551 1,085,396 2,599,346 1,101,500 1,700,000 2,680,100 Fuel Modification - 24,750 - - - - Landslide 48,867 - 15,438 - - - Street Improvements - - - - - - Street Landscape Maintenance 508,460 634,391 735,320 615,000 - 715,100 Street Pavement Maintenance 256,454 128,232 197,753 265,000 - 265,000 Traffic Management 16,770 12,506 23,903 100,000 - - Right-of-Way Improvements - 285,517 1,626,932 121,500 1,700,000 1,700,000 El Prado Lighting District 594 - - - - 500 Operating - - - - - - Repair & Maintenance Services 594 - - - - 500 1911 Act Street Lighting 1,393,544 970,976 828,970 541,200 - 476,100 Administration 425,203 347,597 315,110 316,100 - 321,100 Capital - - - - - - Parks Improvement - - - - - - Repair & Maintenance Services 106,026 114,129 145,450 209,000 - 155,000 Street Lights Maintenance 147,888 - - - - - Right-of-Way Improvements 714,427 509,250 368,410 16,100 - - Beautification 378,754 - - - - - Capital - - - - - - Right-of-Way Improvements 378,754 - - - - - Waste Reduction 212,991 223,785 224,461 357,600 - 254,300 Administration 150,968 131,200 155,410 187,100 - 142,800 Repair & Maintenance Services 62,023 92,585 69,051 170,500 - 111,500 Air Quality Management 50,000 - 55,839 57,000 - 140,000 Repair & Maintenance Services - - 55,839 57,000 - 140,000 Transit Programs 50,000 - - - - - Proposition A 749,753 1,236,694 1,338,029 793,000 - 777,200 Administration 705,645 777,958 874,187 793,000 - 777,200 Street Improvements - - - - - - Right-of-Way Improvements 44,108 458,736 463,842 - - - Proposition C 639,011 698,806 759,078 696,800 700,000 900,000 Administration - - - - - - Repair & Maintenance Services - - - - - - Street Maintenance 572,312 674,953 649,820 436,700 700,000 900,000 Right-of-Way Improvements 66,699 23,853 109,258 260,100 - - Public Safety Grants 130,000 175,000 130,000 160,000 - 250,000 Transfers 130,000 175,000 130,000 160,000 - 250,000 Measure R 2,254,152 72,167 427,417 93,700 1,400,000 1,400,000 Capital - - - - - - Street Improvements - 3,892 157,593 29,200 - - Traffic Management - -- - - - Right-of-Way Improvements 2,254,152 68,275 269,824 64,500 1,400,000 1,400,000 Measure M 565,972 525,317 414,190 739,000 - 1,066,000 Repair & Maintenance Services 565,972 525,317 414,190 739,000 - 681,000 Right-of-Way Improvements - - - - - 385,000 Habitat Restoration 149,499 152,745 153,618 393,700 - 222,000 Administration 129,803 133,045 139,248 353,100 - 180,000 Repair & Maintenance Services 19,696 19,700 14,370 40,600 - 42,000 Subregion One Maintenance 43,831 42,530 42,116 41,600 - 43,600 Repair & Maintenance Services 43,831 42,530 42,116 41,600 - 43,600 Measure A Maintenance 90,000 100,000 - 150,000 - 50,000 Transfers 90,000 100,000 - 150,000 - 50,000 Abalone Cove Sewer District 49,926 138,010 94,903 142,800 - 208,800 Administration 16,358 42,380 34,678 38,800 - 108,800 Capital - - - - - - Repair & Maintenance Services 33,568 95,630 60,225 104,000 - 100,000 Sewer Maintenance - - - - - - Ginsburg Cultural Art Bld 86,344 1,045 - - - - Administration 86,344 1,045 - - - - Donor Restricted Contribution 168,942 16,770 26,608 13,500 - 14,600 Administration 23,744 9,106 20,989 5,500 - 6,600 Parks Improvement 7,659 - - - - - Repair & Maintenance Services 7,515 7,664 5,619 8,000 8,000 B-5 STATEMENT OF EXPENDITURES - ALL FUNDS FY 2022-23 Other Funds: Special Revenues and Internal Service Funds Actuals FY 2018-19 Actuals FY 2019-20 Actuals FY 2020-21 Estimated Year-End FY 2021-22 Budget Workshop FY 2022-23 Preliminary Budget FY 2022-23 Unassigned 130,024 - - - - - CDBG 193,587 211,806 29,908 143,600 150,000 150,000 Administration - - 3,008 - - - Capital - - - - - - Right-of-Way Improvements 193,587 211,806 26,900 143,600 150,000 150,000 Capital Infrastructure Program 3,291,424 4,652,909 889,717 1,691,000 11,118,000 9,283,000 ADA Improvements 77,000 33,950 30,000 - - - Administration - - 14,274 - - - Altamira Canyon - - 81,151 155,100 - - Building Improvements - - - - 590,000 590,000 Capital - - - - - - Catch Basin - 14,992 - - - - Civic Center 58,649 2,798 3,301 86,300 - - Coastal Bluff 216,621 - 293,304 - - - Facilities Asset Management - - - 82,800 - - Landslide Improvements - - - - 535,000 565,000 Landslide Maintenance 179,114 304,026 - 72,200 - - Parks Improvement 46,239 71,924 32,985 - - - Pavement Program 84,687 35,213 - - - - Repair & Maintenance Services - - - - - - Sewer Improvements - - - - 1,060,000 1,060,000 Sewer Maintenance 6,714 34,639 6,652 - 3,300,000 3,300,000 Storm Drain 239,940 334,890 27,111 8,300 - - Street Improvements 37,132 283,423 21,646 - - - Street Maintenance 151,985 6,985 19,435 7,100 - - Trail Improvements - - 50,349 12,100 - - Transfers - - - - - - Ladera Linda Community Park - - - 1,220,400 - - Right-of-Way Improvements 2,193,343 3,530,069 309,509 46,700 4,643,000 3,343,000 Open Space Improvements - - - - 775,000 210,000 Traffic Signs - - - - 215,000 215,000 State Grants 708,061 277,373 49,207 116,400 - 210,000 Administration - - - 100,000 - 210,000 Capital - - - - - - Parks Improvement 144,320 - - - - - Storm Drain 244,265 120,832 11,621 16,400 - - Transfers 300,000 - - - - - Right-of-Way Improvements 19,476 156,541 37,586 - - - Federal Grants 1,087,318 98,314 - - 105,000 105,000 Administration - 14 - - - - Transfers 1,087,318 98,300 - - - - Right-of-Way Improvements - - - - 105,000 105,000 Federal Grants - ARPA - - - 672,600 4,247,000 4,247,000 ADA Improvements - - - 42,800 - - Building Improvements - - - - 350,000 350,000 Emergency Preparedness - - - - - - Parks Improvement - - - 12,000 - - Technology Improvements - - - - - - Ladera Linda Community Park - - - 617,800 - - Right-of-Way Improvements - - - - 2,512,000 2,512,000 Parks Improvements - - - - 350,000 350,000 Sewer & Storm Drain Improvements - - - - 1,035,000 1,035,000 Quimby Park Development 145,474 545,813 130,863 389,500 - - Capital - - - - - - Parks Improvement - - - - - - Trail Improvements 3,470 364,464 - - - - Ladera Linda Community Park 142,004 181,349 130,863 389,500 - - Environmental Excise Tax - 286,881 143,635 138,000 - 64,000 Street Landscape Maintenance - 286,881 143,635 138,000 - 64,000 Bicycle/Pedestrian Access - -511 - - 110,000 Street Improvements - - - - - - Street Maintenance - - 511 - - - Right-of-Way Improvements - - - - - 110,000 Measure W - - 187,954 512,635 - 596,000 B-6 STATEMENT OF EXPENDITURES - ALL FUNDS FY 2022-23 Other Funds: Special Revenues and Internal Service Funds Actuals FY 2018-19 Actuals FY 2019-20 Actuals FY 2020-21 Estimated Year-End FY 2021-22 Budget Workshop FY 2022-23 Preliminary Budget FY 2022-23 Repair & Maintenance Services - - 187,954 454,635 - 535,000 Unassigned - - - 58,000 - 61,000 Water Quality/Flood Protection 811,110 - - - - - Administration 811,110 - - - - - Storm Drain - - - - - - Equipment Replacement 452,376 360,246 198,644 354,000 - 602,700 Capital 89,152 24,110 11,724 130,000 - 388,300 Operating 363,224 336,136 186,920 224,000 - 214,400 Employee Pension Fund - - - - - 242,000 Operating - - - - - 242,000 Total - Other Funds 14,483,214 11,872,583 8,725,014 9,299,135 19,420,000 24,092,900 Total - All Funds 43,684,680 40,411,431 34,917,783 41,888,373 53,910,100 59,801,000 B-7 Project CodeProject NameFundExpenses/Commitments to date FY 22-23 FY 23-24 FY 24-25 FY 25-26 FY 26-27 8200 Series Abalone Cove Santitary Sewer System Maintenance225 (Ab Cove sewer maint.)48,005$ -$ -$ -$ -$ -$ 330 (CIP)-$ 3,300,000$ 930,000$ -$ -$ -$ 333 (ARPA Federal Grant)-$ -$ -$ -$ -$ -$ 8300 Series Landslide Improvements8301Palos Verdes Drive South Realignment - East End330 (CIP)111,425$ -$ -$ 75,000$ 1,845,000$ -$ 215 (Prop. C)N/A - ongoing program900,000$ -$ -$ -$ -$ 330 (CIP)N/A - ongoing program30,000$ 975,000$ 1,000,000$ 1,040,000$ 1,060,000$ 220 (Meas. R)292,300$ -$ -$ -$ -$ -$ 330 (CIP)804,387$ 535,000$ 6,180,000$ 2,135,000$ -$ -$ 8400 Series Parks, Open Space & Recreation Facilities8404Fence Replacement Program330 (CIP)-$ -$ 250,000$ -$ -$ -$ 330 (CIP)13,111,229$ -$ -$ -$ -$ -$ 333 (ARPA Federal Grant)3,953,000$ -$ -$ -$ -$ -$ 334 (Quimby park development)1,705,855$ -$ -$ -$ -$ -$ 8420Palos Verdes Nature Preserve Signs Program330 (CIP)248,405$ -$ -$ -$ -$ -$ 8423Palos Verdes Nature Preserve Gate for the Rattlesnake Trail330 (CIP)-$ 210,000$ -$ -$ -$ -$ 330 (CIP)-$ -$ -$ -$ -$ -$ 333 (ARPA Federal Grant)-$ 350,000$ -$ -$ -$ -$ 330 (CIP)-$ -$ 350,000$ -$ -$ -$ 333 (ARPA Federal Grant)-$ -$ -$ -$ -$ -$ 8500 Series Building Improvements8503 New Civic Center Complex330 (CIP)316,034$ 340,000$ 450,000$ -$ -$ -$ 330 (CIP)-$ -$ -$ -$ -$ -$ 333 (ARPA Federal Grant)35,000$ 350,000$ -$ -$ -$ -$ 8509 Facilities Asset Management Program330 (CIP)107,311$ 250,000$ TBDTBDTBDTBD330 (CIP)-$ -$ -$ TBD-$ -$ 333 (ARPA Federal Grant)-$ -$ 90,000$ 260,000$ -$ -$ 8700 Series Sewer & Storm Drain Improvements8701 Storm Drain Asset Management Program & Master Plan Update330 (CIP)115,000$ 450,000$ TBDTBDTBDTBD8708 Altamira Canyon Improvements (Erosion)330 (CIP)365,727$ 450,000$ TBDTBDTBDTBD330 (CIP)236,243$ 160,000$ -$ -$ -$ -$ 333 (ARPA Federal Grant)-$ 1,035,000$ -$ -$ -$ -$ 87New2 Lift Station Improvements at Lower Point Vicente330 (CIP)-$ -$ 40,000$ 290,000$ -$ -$ 84Pot1 Park Monument SignsPark Playground Improvements85Pot184Pot2Restroom Improvements and New Office Space at Eastview ParkPalos Verdes Drive South Landslide Area Resurfacing Program8302City of Rancho Palos VerdesPublic Works DepartmentProposed Five Year CIP Budget for Fiscal Years 2022-23, 2023-24, 2024-25, 2025-26 and 2026-278405 Ladera Linda Community Park Project8715Stormwater Drainage Improvements- Palos Verdes Drive South at Peppertree DriveRestroom Improvements at Point Vicente Interpretive Center85088202 Abalone Cove Sanitary Sewer Rehabilitation Program8304 Portuguese Bend Landslide RemediationC-1 Project CodeProject NameFundExpenses/Commitments to date FY 22-23 FY 23-24 FY 24-25 FY 25-26 FY 26-27 City of Rancho Palos VerdesPublic Works DepartmentProposed Five Year CIP Budget for Fiscal Years 2022-23, 2023-24, 2024-25, 2025-26 and 2026-278800 Series Right-of-Way Improvements8004 Traffic Signs Replacement Program330 (CIP)N/A - ongoing program215,000$ 225,000$ 110,000$ 130,000$ 155,000$ 330 (CIP) N/A - ongoing program350,000$ -$ 500,000$ -$ 520,000$ 340 (Bicycle & Ped access) N/A - ongoing program110,000$ -$ -$ -$ -$ 202 (Gas Tax - SB1) 170,000$ -$ -$ -$ -$ -$ 330 (CIP) -$ 1,020,000$ -$ -$ -$ -$ 333 (ARPA Federal Grant)-$ 500,000$ -$ -$ -$ -$ 215 (Prop. C)200,000$ -$ -$ -$ -$ -$ 220 (Meas. R)150,000$ -$ -$ -$ -$ -$ 221 (Meas. M - Grant)-$ 385,000$ 505,000$ 3,110,000$ -$ -$ 310 (CDBG) N/A - ongoing program150,000$ 150,000$ 150,000$ 150,000$ 150,000$ 330 (CIP) N/A - ongoing program-$ -$ -$ -$ -$ 202 (Gas Tax) N/A - ongoing program-$ -$ -$ 735,000$ -$ 220 (Meas. R) N/A - ongoing program-$ -$ -$ 530,000$ -$ 330 (CIP)N/A - ongoing program-$ -$ -$ 1,805,000$ 100,000$ 202 (Gas Tax)-$ 500,000$ -$ -$ -$ -$ 202 (Gas Tax - SB1)-$ 1,200,000$ -$ -$ -$ -$ 220 (Meas. R)38,500$ 1,400,000$ -$ -$ -$ -$ 330 (CIP)-$ 1,045,000$ 100,000$ -$ -$ -$ 202 (Gas Tax)N/A - ongoing program-$ -$ 925,000$ -$ -$ 220 (Meas. R)N/A - ongoing program-$ -$ 520,000$ -$ -$ 330 (CIP)N/A - ongoing program-$ -$ 1,270,000$ 100,000$ -$ 202 (Gas Tax)N/A - ongoing program-$ 530,000$ -$ -$ -$ 220 (Meas. R)N/A - ongoing program-$ 525,000$ -$ -$ -$ 330 (CIP)N/A - ongoing program-$ 1,405,000$ 100,000$ -$ -$ 215 (Prop. C)70,394$ -$ -$ -$ -$ -$ 330 (CIP)8,200$ -$ -$ 100,000$ 1,075,000$ -$ 202 (Gas Tax)N/A - ongoing program-$ -$ -$ -$ 700,000$ 220 (Meas. R)N/A - ongoing program-$ -$ -$ -$ 530,000$ 330 (CIP)N/A - ongoing program-$ -$ -$ -$ 1,420,000$ 8837Traffic Signal at intersection of Palos Verdes Drive South and Palos Verdes Drive East330 (CIP)361,618$ -$ -$ -$ -$ -$ 330 (CIP)-$ -$ 2,100,000$ -$ -$ -$ 333 (ARPA Federal Grant)-$ 140,000$ 460,000$ -$ -$ -$ 202 (Gas Tax)-$ -$ -$ -$ -$ -$ 333 (ARPA Federal Grant)45,000$ 1,672,000$ -$ -$ -$ -$ 330 (CIP)54,749$ 143,000$ -$ -$ -$ -$ 202 (Gas Tax)198,718$ -$ -$ -$ -$ -$ 330 (CIP)-$ -$ -$ 160,000$ -$ -$ 8845 Traffic Calming - PV Nature Preserve Parking Solutions330 (CIP)75,000$ TBD-$ -$ -$ -$ Palos Verdes Drive South Intersection ImprovementsPavement Management Program- Residential Roadway Rehabilitation - Area 6Pavement Management Program - Triennial Update8815Pavement Management Program- Residential Roadway Rehabilitation - Area 58816Pavement Management Program- Residential Roadway Rehabilitation - Area 1Community Development Block Grant Americans with Disabilities Act Infrastructure Improvements88108843Pavement Management Program- Arterial Roadway Rehabilitation(Silver Spur Road - North of Hawthorne Boulevard)88368840 Western Avenue Beautification88288826Pavement Management Program- Residential Roadway Rehabilitation - Area 28819Pavement Management Program- Residential Roadway Rehabilitation - Area 988448801 Sidewalk Repair and Replacement Program8808Pavement Management Program- Arterial Roadway Rehabilitation(Crenshaw Boulevard)8809 Western Avenue Traffic Flow ImprovementsC-2 Project CodeProject NameFundExpenses/Commitments to date FY 22-23 FY 23-24 FY 24-25 FY 25-26 FY 26-27 City of Rancho Palos VerdesPublic Works DepartmentProposed Five Year CIP Budget for Fiscal Years 2022-23, 2023-24, 2024-25, 2025-26 and 2026-27220 (Meas. R)-$ -$ -$ -$ -$ -$ 330 (CIP)-$ 535,000$ 430,000$ 450,000$ 460,000$ 465,000$ 330 (CIP)-$ -$ -$ -$ -$ -$ 331 (Federal Grants)-$ 105,000$ 894,900$ -$ -$ -$ 202 (Gas Tax) 140,000$ -$ -$ -$ -$ -$ 220 (Meas. R) 315,000$ -$ -$ -$ -$ -$ 330 (CIP) -$ -$ -$ -$ -$ -$ 88LY1Pavement Management Program- Arterial Roadway Rehabilitation(Palos Verdes Drive South)330 (CIP) -$ -$ 35,000$ 585,000$ -$ -$ 220 (Meas. R) -$ -$ -$ -$ -$ -$ 330 (CIP) -$ -$ -$ 70,000$ 545,000$ -$ 88LY4Pavement Management Program- Arterial Roadway Rehabilitation(Palos Verdes Drive East)330 (CIP)-$ -$ -$ -$ 210,000$ 4,825,000$ 88New4 Arterial Roadway Beautification Program330 (CIP)-$ 100,000$ -$ -$ -$ -$ 330 (CIP)-$ -$ -$ -$ -$ -$ 333 (ARPA Federal Grant)-$ 200,000$ -$ -$ -$ -$ 88New6 Retaining Wall Repairs at 3001 Crest Road330 (CIP)-$ 100,000$ -$ -$ -$ -$ 88New7Palos Verdes Drive East Traffic Improvements(from Bronco Drive to Headland Drive)330 (CIP)-$ 50,000$ TBDTBDTBDTBD23,277,100$ 18,280,000$ 16,624,900$ 11,810,000$ 8,625,000$ 9,925,000$ Funding Summary FY 22-23 FY 23-24 FY 24-25 FY 25-26 FY 26-27 202 (Gas Tax)338,718$ 500,000$ 530,000$ 925,000$ 735,000$ 700,000$ 202 (Gas Tax - SB1)170,000$ 1,200,000$ -$ -$ -$ -$ 211 (1911 Act)-$ -$ -$ -$ -$ -$ 215 (Prop. C)270,394$ 900,000$ -$ -$ -$ -$ 220 (Meas. R)795,800$ 1,400,000$ 525,000$ 520,000$ 530,000$ 530,000$ 221 (Meas. M)-$ -$ -$ -$ -$ -$ 221 (Meas. M - Grant)-$ 385,000$ 505,000$ 3,110,000$ -$ -$ 310 (CDBG)-$ 150,000$ 150,000$ 150,000$ 150,000$ 150,000$ 330 (CIP)15,915,328$ 9,283,000$ 13,470,000$ 6,845,000$ 7,210,000$ 8,545,000$ 331 (Federal Grants)-$ 105,000$ 894,900$ -$ -$ -$ 333 (ARPA Federal Grant)4,033,000$ 4,247,000$ 550,000$ 260,000$ -$ -$ 334 (Quimby park development)1,705,855$ -$ -$ -$ -$ -$ 340 (Bicycle & Ped access)-$ 110,000$ -$ -$ -$ -$ 23,229,095$ 18,280,000$ 16,624,900$ 11,810,000$ 8,625,000$ 9,925,000$ Guardrail Improvements along Palos Verdes Drive East8846 Traffic Calming - Citywide88LY2Pavement Management Program- Arterial Roadway Rehabilitation(Indian Peak Road)8847884888New5 City Entrance Roadway Monument SignsPavement Management Program- Arterial Roadway Rehabilitation(Silver Spur Road - South of Hawthorne Boulevard)C-3 Project CodeProject NameFundExpenses/Commitments to date FY 22-23 FY 23-24 FY 24-25 FY 25-26 FY 26-27 City of Rancho Palos VerdesPublic Works DepartmentProposed Five Year CIP Budget for Fiscal Years 2022-23, 2023-24, 2024-25, 2025-26 and 2026-27Wants/Needs List (Projects not recommended for funding in Fiscal Years 2022-23 through 2026-27)8200 Series Abalone Cove Santitary Sewer System Maintenance8300 Series Landslide Improvements8400 Series Parks, Open Space & Recreation Facilities8411Lower Point Vicente Parking Lot Lighting Improvements211 (1911 Act) -$ 8418Hesse Park Parking Lot & Lighting Improvements330 (CIP) -$ 8419Hesse Park Athletic Field Improvements330 (CIP) -$ 8421Lower Point Vicente Park Improvements330 (CIP) -$ 84LY1Lower Hesse Park Improvements330 (CIP) -$ 84LY2Point Vicente Interpretive Center "Bubbles" Statue Marquee Sign330 (CIP) -$ 8500 Series Building Improvements85LY2Replacement of the Civic Center Storm Room330 (CIP) -$ 8700 Series Sewer & Storm Drain Improvements8711 Bayend Drive Catch Basin Inlets and Storm Drain Lateral 330 (CIP)-$ 8713 Upper Point Vicente Stormwater Runoff Control Project (Helipad) 330 (CIP)-$ 8714Crest Road to Crestridge Canyon Stormwater Drainage Improvements330 (CIP)-$ 8718Stormwater Drainage Improvements- 6415 Corsini Place330 (CIP) 60,000.00$ 87New1Stormwater Drainage Improvements- Hawthorne Boulevard at Hawkhurst Drive330 (CIP) -$ 8800 Series Right-of-Way Improvements8811Arterial Walls and Fences Aesthetic Improvements Program - Citywide330 (CIP) -$ -$ -$ -$ -$ -$ 202 (Gas Tax) -$ 220 (Meas. R) -$ 330 (CIP) -$ 202 (Gas Tax) -$ 220 (Meas. R) -$ 330 (CIP) -$ 202 (Gas Tax) -$ 220 (Meas. R) -$ 330 (CIP) -$ 8839Palos Verdes Drive East Path Improvements (from Bronco Drive to Sunnyside Ridge Road)330 (CIP) 99,942.00$ 8849 Walking Path Improvements Program 330 (CIP) -$ 88LY3 Palos Verdes Drive West Pedestrian Crossing330 (CIP) -$ 88LY6 Ganado Drive Parkway Area Aesthetic Improvements330 (CIP) -$ 8834Pavement Management Program- Residential Roadway Rehabiitation - Areas 3 & 48817Pavement Management Program- Residential Roadway Rehabilitation - Area 78818Pavement Management Program- Residential Roadway Rehabilitation - Area 8Estimated cost of $260,000 (accounting for inflation through Fiscal Year 2027-28)Estimated cost of $3,925,000 (accounting for inflation through Fiscal Year 2027-28)Estimated cost of $225,000 (accounting for inflation through Fiscal Year 2027-28)Estimated cost of $1,830,000 (accounting for inflation through Fiscal Year 2027-28)Estimated cost of $515,000 (accounting for inflation through Fiscal Year 2027-28)Estimated cost TBDEstimated cost of $3,535,000 (accounting for inflation through Fiscal Year 2027-28)Estimated cost of $3,030,000 (accounting for inflation through Fiscal Year 2027-28)Estimated cost of $5,195,000 (accounting for inflation through Fiscal Year 2027-28)Estimated cost of $1,750,000 (accounting for inflation through Fiscal Year 2027-28)Estimated cost of $80,000 (accounting for inflation through Fiscal Year 2027-28)N/A due to scope of work not clearly defined yetEstimated cost of $1,985,000 (accounting for inflation through Fiscal Year 2027-28)Estimated cost of $715,000 (accounting for inflation through Fiscal Year 2027-28)Estimated cost of $360,000 (accounting for inflation through Fiscal Year 2027-28)Estimated cost of $200,000 (accounting for inflation through Fiscal Year 2027-28)Estimated cost of $335,000 (accounting for inflation through Fiscal Year 2027-28)Estimated cost of $1,365,000 (accounting for inflation through Fiscal Year 2027-28)Estimated cost of $1,785,000 (accounting for inflation through Fiscal Year 2027-28)C-4