Loading...
HomeMy WebLinkAbout3A OCR CITY COUNCIL STAFF REPORT DATE: JUNE 5, 2023 BUSINESS & LEGISLATIVE SUBJECT: GENERAL FUND, CAPITAL, AND AIRPORT DRAFT BUDGET FOR FISCAL YEARS 2023-24 AND 2024-25 FROM: Scott C. Stiles, City Manager BY: Department of Finance and Treasury Department of Engineering Department of Aviation SUMMARY: This item represents an update to the fiscal year 2023-24 and fiscal year 2024-25 General Fund Budget, Capital Plan Update, and Palm Springs International Airport Budget on all changes made after the Council Study Session on May 8, 2023. RECOMMENDATION: Provide direction to staff on any changes to the draft fiscal year 2023-24 and draft fiscal year 2024-25 budgets. STAFF ANALYSIS: In Table 1 on the following page, a forecast of the current fiscal year General Fund revenue and expenditures is provided, along with a preliminary overview of General Fund budgeted revenue and expenditures for fiscal year 2023-24 and fiscal year 2024-25. This presentation to Council builds upon the comprehensive budget that was submitted to Council at the May 8, 2023 Study Session (Attachment 2) and contains the budgetary highlights for the General Fund, Capital, and Palm Springs International Airport and remain materially unchanged. Staff will again review these highlights at the City Council meeting. Following each table below, budget updates are outlined to provide additional detail on the changes. Item 3A - Page 1 City Council Staff Report June 5, 2023 -- Page 2 FY 2023-24 & FY 2024-25 Draft Budget GENERAL FUND TABLE 1 Updates to the General Fund Budget after Council Presentation May 8, 2023 The following is a listing of the updates to the budget after May 8, 2023, with explanations. Revenue Fiscal Year 2023-24 (FY24) Total revenue was reduced by $50,000 from the last budget draft presented due to the following: • $50,000 – Public, Education, Government (PEG) Fee revenue was reduced. This revenue is now being recorded in the Capital Fund. FY2022-23 FY2023-24 FY2024-25 Forecast Draft Budget Draft Budget Total Revenue 186,208,721$ 199,528,555$ 191,880,247$ Transient Occupancy Tax 49,919,475 48,921,085 51,122,534 Property Taxes 30,407,637 31,015,768 31,636,084 Sales and Use Taxes 33,912,338 33,811,056 35,061,718 Utility Users Tax 17,835,699 20,801,918 24,056,277 Motor Vehicle in Lieu tax 6,435,921 6,564,639 6,695,932 Franchise Fees 4,584,399 4,676,087 4,769,609 Cannabis Tax 3,606,427 3,426,106 3,254,801 All Other Sources 28,558,244 29,180,503 29,518,814 Grant Revenue 9,936,066 21,131,392 5,764,478 Transfers From Other Funds 1,012,516 - - Total Expense 177,713,131$ 215,883,283$ 184,852,439$ General Government 52,781,254 62,658,128 64,341,227 Police 42,017,426 43,373,985 44,723,596 Fire 24,836,102 27,973,687 29,463,009 Parks and Recreation 10,846,125 15,170,072 15,782,444 PERS Future Cost Reserve 6,000,000 6,000,000 6,000,000 Transfers 27,331,298 19,731,879 18,777,686 Set Aside Items 3,964,860 19,844,140 - Grant Expense 9,936,066 21,131,392 5,764,478 Surplus/(Deficit)8,495,591$ (16,354,728)$ 7,027,807$ Item 3A - Page 2 City Council Staff Report June 5, 2023 -- Page 3 FY 2023-24 & FY 2024-25 Draft Budget Revenue Fiscal Year 2024-25 (FY25) Total revenue increased by $3.95 million from the prior budget update due to the following: • $4 million – Added grant revenue that will be used to fund the Navigation Center’s operational expenses. • $50,000 – Public, Education, Government (PEG) Fee revenue was reduced. This revenue is now being recorded in the Capital Fund Expenditures Fiscal Year 2023-24 Total expenses decreased by $470,000 from the prior budget update due to the following: • $250,000 – The Building Department increased expense for an incentive program to reduce fees to customers who meet affordable housing and multifamily housing criteria. • $200,000 – Expense was added to the Street Department budget for on-call street maintenance. The bulk of this service has been budgeted in and will be funded by Measure A; however, to ensure the program is fully funded, the General Fund will absorb some of this expense. This initiative will allow for re-striping lanes, repainting legends on streets and parking lots citywide, as well as concrete repairs and construction to include ADA curb ramps, gutters, and sidewalks. • $76,000 – The Parks and Recreation Program Assistant role for the Demuth Community Center is planned to start in fiscal year 2023-24 as opposed to starting in fiscal year 2024-25. • Decrease of $996,000 – These items were various reductions done to accounts upon further analysis and largely consist of the following: o PEG expense reduction of $663,000; this spending now occurs in the Capital Fund o GPSCVB reduction in estimated quarterly payments of $265,000 Expenditures Fiscal Year 2024-25 Total expenses increased by $744,000 from the prior budget update due to the following: • $4 million – Navigation Center operational expense grant expenses increased to match grant revenue (mentioned above). Item 3A - Page 3 City Council Staff Report June 5, 2023 -- Page 4 FY 2023-24 & FY 2024-25 Draft Budget • $250,000 – Same as for FY24, this is the second year of the Building Department incentive program to reduce fees to customers who meet affordable housing and multifamily housing criteria. • $200,000 – Same as for FY24, this is the second year of on-call street maintenance funded by the General Fund (mentioned above). • Decrease $3.7 million – These items were various reductions done to accounts upon further analysis and largely consist of the following: o $2.5 million grant funding not expected o PEG expense reduction, $685,000 o GPSCVB reductions mentioned above, $278,000 o Software license reduction of $245,000 (items were double budgeted) The deficit for FY24 was $16,774,992 in the prior budget presentation. In this draft, the deficit for FY24 is now $16,354,728. All of the prior approved set-asides remaining from the FY23 budget are anticipated to be spent in FY24; that total is $19,844,140. If this item was removed, the City would be showing a surplus of approximately $3.5 million. The surplus for FY25 was $3,821,419 in the prior budget presentation. In this draft, the surplus for FY25 is now $7,027,807. Item 3A - Page 4 City Council Staff Report June 5, 2023 -- Page 5 FY 2023-24 & FY 2024-25 Draft Budget CAPITAL BUDGET TABLE 2 Updates to the Capital Budget after Council Presentation May 8, 2023 The following is a detail listing of the updates made to the Capital Budget after May 8, 2023, with explanations: Fiscal Year 2023-24 Total revenue increased by $500,000 from the prior budget update due to the following: • $500,000 – Grant revenue increased for Sunrise Park Recycled Water Connection agreement with DWA. This project will advance the City’s objectives to become more sustainable by transitioning the park from potable water to a recycled water supply. Total expenses increased by $4 million from the prior budget update due to the following: • $2 million – New project for Sunrise Park Recycled Water Connection agreement with DWA; $1.5 million (City portion) and $500,000 (grant portion) for total expenditures of $2 million. See explanation of project above. Fund Beg Fund Balance Revenue Transfer In Expenditures Transfer Out Ending Fund Balance Use of Funds Gas Tax 2,453,548 1,394,633 - 1,000,176 - 2,848,005 Streets Measure A 8,491,377 7,878,780 - 9,681,254 - 6,688,903 Streets Drainage 2,349,965 525,000 - 617,260 - 2,257,705 Drainage RMRA 2,132,861 1,113,536 - 1,097,504 - 2,148,893 Transportation Quimby 3,799,942 635,000 - 837,555 - 3,597,387 Parks and Rec Measure J 35,964,245 22,770,046 - 26,162,557 3,133,700 29,438,034 General Capital Fund 24,250,634 38,024,600 2,000,000 48,462,868 - 15,812,366 Various Total 79,442,572 72,341,595 2,000,000 87,859,174 3,133,700 62,791,293 Fund Beg Fund Balance Revenue Transfer In Expenditures Transfer Out Ending Fund Balance Use of Funds Gas Tax 2,848,005 1,225,000 - 1,225,000 - 2,848,005 Streets Measure A 6,688,903 6,208,526 - 5,715,920 - 7,181,509 Streets Drainage 2,257,705 520,000 - - - 2,777,705 Drainage RMRA 2,148,893 1,151,193 - - - 3,300,086 Transportation Quimby 3,597,387 652,401 - - - 4,249,788 Parks and Rec Measure J 29,438,034 23,655,226 - 21,618,552 3,133,200 28,341,508 General Capital Fund 15,812,366 21,902,904 2,000,000 22,035,324 - 17,679,946 Various Total 62,791,293 55,315,250 2,000,000 50,594,796 3,133,200 66,378,547 **NOTE THAT ANY CAPITAL FOR THE AIRPORT OR WASTEWATER PLANT WILL GET FUNDED OUT OF THEIR OWN FUND Fiscal Year 2023-24 Captal Budget Fiscal Year 2024-25 Captal Budget Item 3A - Page 5 City Council Staff Report June 5, 2023 -- Page 6 FY 2023-24 & FY 2024-25 Draft Budget • $1.1 million – Project to enhance the street slurry preservation and restoration initiative using the SB1 Road Maintenance Rehabilitation Act Fund. The SB1 funds will greatly benefit the City’s initiative of maintaining the roadway infrastructure and is in line with Senate Bill 1, The Road Repair and Accountability Act of 2017. • $673,873 – New project to contribute to Western Coachella Valley Flood and Blow Sand Improvement Project with CVAG for the design and engineering of Indian Canyon Drive road and bridge improvements from Sunrise Parkway to Palm Station Road. • Adjustments to other capital project expenditures totaling $286,000 consist of the following: o Downtown Measure J expenses, $246,000 o IT software reserve for emerging needs, $40,000 Fiscal Year 2024-25 There was no change in revenue from the prior budget update. Total expenses increased by $1.4 million from the prior budget update due to the following: • $1 million – Increase in funding, for general use, to the Library renovation project by the measure J Commission. • Increases to other capital project expenditures totaling $440,000 consist of the following: o Downtown Measure J expenses, $400,000 o IT software reserve for emerging needs, $40,000 Item 3A - Page 6 City Council Staff Report June 5, 2023 -- Page 7 FY 2023-24 & FY 2024-25 Draft Budget PALM SPRINGS INTERNATIONAL AIRPORT Airport Operations Fund Revenues and Expenditures TABLE 3 Customer Facility Charge (CFC) Revenues and Expenditures TABLE 4 FY2022-23 FY2023-24 FY2024-25 Forecast Draft Budget Draft Budget Total Revenue 53,623,663$ 62,688,919$ 69,312,200$ Airline Revenue 9,665,025 21,000,019 27,413,506 Non-Airline Revenue 27,256,648 35,423,694 41,898,694 Grant Revenue 16,701,990 6,265,206 - Total Expense 33,894,665$ 48,774,966$ 60,405,427$ Administration 5,212,996 7,989,477 8,847,224 Information Technology 420,000 784,616 682,047 Law Enforcement 3,053,885 3,147,313 3,229,436 Aviation Security - 1,695,917 1,813,039 Airside Operations 1,309,963 5,287,385 5,454,221 Rescue-Fire 3,681,436 4,880,731 5,041,960 Landside Operations 1,699,475 2,178,178 2,759,661 Ground Maintenance 664,899 686,823 639,147 Terminal Building Operations 7,788,259 8,189,673 10,605,447 Passenger Boarding Bridges 13,759 120,000 120,000 Baggage Handling System 299,493 897,000 900,000 Control Center Operations 3,330,431 4,159,042 4,101,807 Customs 284,240 336,296 303,996 Planning and Projects - 688,881 669,444 PERS Future Cost Reserve 750,000 750,000 750,000 Transfer Out 5,385,828 6,983,634 14,488,000 Surplus/(Deficit)19,728,998$ 13,913,953$ 8,906,773$ FY2022-23 FY2023-24 FY2024-25 Forecast Draft Budget Draft Budget Total Revenue 7,850,000$ 9,181,327$ 9,406,451$ Customer Facility Charges 7,850,000 9,181,327 9,406,451 Total Expense -$ 10,600,000$ 3,000,000$ Rental Car Improvement - 10,600,000 500,000 Transfer Out - - 2,500,000 Surplus/(Deficit)7,850,000$ (1,418,673)$ 6,406,451$ Item 3A - Page 7 City Council Staff Report June 5, 2023 -- Page 8 FY 2023-24 & FY 2024-25 Draft Budget Passenger Facility Charge (PFC) Revenues and Expenditures TABLE 5 Airport Capital Projects Fund TABLE 6 Update to the Airport Budget after Council Presentation May 8, 2023 The following is a detail listing of the update made to the Palm Springs International Airport Budget after May 8, 2023: • Interest income revenue estimated in the four airport funds added in this draft budget increased revenue totaling $660,000 in fiscal year 2023-24 and $698,000 in fiscal year 2024-25. These items had originally been omitted in the prior budget presented. FY2022-23 FY2023-24 FY2024-25 Forecast Draft Budget Draft Budget Total Revenue 5,781,000$ 6,450,776$ 6,603,496$ Passenger Facility Charges 5,781,000 6,450,776 6,603,496 Total Expense 2,521,000$ 9,001,977$ 27,507,761$ Loan Principal & Interest 2,521,000 2,561,977 2,507,761 Transfer Out - 6,440,000 25,000,000 Surplus/(Deficit)3,260,000$ (2,551,201)$ (20,904,265)$ FY2022-23 FY2023-24 FY2024-25 Forecast Draft Budget Draft Budget Total Revenue 14,873,484$ 42,821,840$ 96,150,000$ Grant Revenue 9,487,656 29,398,206 56,662,000 Transfer In 5,385,828 13,423,634 39,488,000 Total Expense 19,416,415$ 42,746,000$ 96,150,000$ Capital Projects 19,416,415 42,746,000 96,150,000 Surplus/(Deficit)(4,542,930)$ 75,840$ -$ Item 3A - Page 8 City Council Staff Report June 5, 2023 -- Page 9 FY 2023-24 & FY 2024-25 Draft Budget ALIGNMENT WITH STRATEGIC PLANNING: This item aligns with the City Council identified major theme/principle of Forward-Thinking Governance. FISCAL IMPACT: Provide direction to Staff on any changes to the Preliminary fiscal year 2023-24 and fiscal year 2024-25 budgets. REVIEWED BY: Budget Manager: Andrew Neri Acting Director of Finance: Kristopher J. Mooney City Engineer: Joel Montalvo Airport Administration Manager: Victoria A. Carpenter Executive Director of Aviation: Harry Barrett Jr. City Manager: Scott Stiles ATTACHMENTS: 1. Budget in Brief (Updated) 2. Staff Report Budget Study Session FY2023-25 5.08.2023 Final 3. Capital Schedule (Updated) 4. Airport Budget (Updated) Item 3A - Page 9 ATTACHMENT 1 Item 3A - Page 10 June 30, 2022 CITY OF PALM SPRINGS DRAFT BUDGET FISCAL YEAR 2023 - 2024 & 2024 - 2025 Item 3A - Page 14 City of Palm Springs Budget for Fiscal Years 2023-24 and 2024-25 Table of Contents -General Fund - Fund Balance Summary for FY 2023-24 & FY 2024-25 2 -General Fund - Revenues for FY 2023-24 & FY 2024-25 4 -General Fund - Expenditures for FY 2023-24 & FY 2024-25 10 -All Funds - Fund Balance Schedules for FY 2022-23, FY 2023-24 & FY 2024-25 14 -All Funds - Revenues for FY 2023-24 & FY 2024-25 18 -All Funds - Expenditures for FY 2023-24 & FY 2024-25 31 -All Funds - Summary of Budgeted Interfund Transfers for FY 2023-24 38 -All Funds - Summary of Budgeted Interfund Transfers for FY 2024-25 39 -Additional Supporting Data for FY 2023-24 & FY 2024-25 41 Item 3A - Page 15 FY 2022-23 FY 2022-23 FY 2023-24 FY 2024-25 FY 2021-22 Revised Estimated Draft Draft Actual Budget Actual Budget Budget Beginning Fund Balance - Unrestricted 81,804,817$ 103,941,580$ 103,941,580$ 112,437,171$ 96,082,442$ Operating Revenues 173,263,534 155,985,228 175,260,139 178,397,162 186,115,768 Add: Grant Revenue 12,102,934 32,134,208 9,936,066 21,131,392 5,764,478 Transfers In - 1,012,516 1,012,516 - - Total Revenues 185,366,468 189,131,952 186,208,721 199,528,555 191,880,247 Operating Expenditures (123,720,434) (156,190,738) (136,480,907) (155,175,872) (160,310,276) Transfers Out (10,095,765) (27,331,298) (27,331,298) (19,731,879) (18,777,686) Operating Surplus / (Deficit)39,447,335 (27,536,808) 11,447,934 3,489,412 7,027,807 Set Asides (23,809,000) (3,964,860) (19,844,140) - Operating Exp. Incl. Set Aside & Transf. (133,816,199) (207,331,036) (167,777,065) (194,751,891) (179,087,961) Less: Grant Expense (1,163,506) (27,216,631) (9,936,066) (21,131,392) (5,764,478) Total Expenditures (134,979,705) (234,547,667) (177,713,131) (215,883,283) (184,852,439) Surplus / (Deficit)50,386,763 (45,415,715) 8,495,591 (16,354,728) 7,027,807 Proposed Minimum Fund Balance 27,155,778 28,054,298 Remaining Unassigned Fund Balance 103,941,580 58,525,865 112,437,171 68,926,664 75,055,951 Total Fund Balance Before CalPERS 103,941,580 58,525,865 112,437,171 96,082,442 103,110,249 CalPERS Reserve Set-Aside 28,250,000 34,250,000 34,250,000 40,250,000 46,250,000 CalPERS Set-Aside/Fund Balance 132,191,580$ 92,775,865$ 146,687,171$ 136,332,442$ 149,360,249$ Required Minimum Fund Balance Total 17.50%17.50% Fund Balance Total 77.67%28.23%67.02%61.92%64.32% Fund Balance CalPERS Reserve Total 21.11%16.52%20.41%25.94%28.85% Fund Balance % Total 98.79%44.75%87.43%87.86%93.17% City of Palm Springs General Fund Working Fund Balance Summary Fiscal Year 2023-2024 & 2024-2025 -2-Item 3A - Page 16 City of Palm Springs Budget for Fiscal Years 2023-24 and 2024-25 General Fund Revenues FY 2023-24 & FY 2024-25 -3-Item 3A - Page 17 City of Palm Springs Budget for Fiscal Years 2023-24 and 2024-25 General Fund Revenue Summary FY2018-19 FY2019-20 FY2020-21 FY2021-22 FY2022-23 FY2022-23 FY2023-24 FY2024-25 Account Description Actuals Actuals Actuals Actuals Revised Budget Est. Actuals Draft Budget Draft Budget Transient Occupancy Tax 36,475,057$ 25,817,660$ 35,092,830$ 53,900,745$ 48,377,203$ 49,919,475$ 48,921,085$ 51,122,534$ Property Taxes 24,550,692 25,482,084 27,342,181 28,831,512 29,235,750 30,407,637 31,015,768 31,636,084 Sales and Use Taxes 23,390,908 20,923,634 25,232,110 31,818,760 30,717,096 33,912,338 33,811,056 35,061,718 Utility Users Tax 7,081,134 7,025,604 8,284,837 15,627,960 11,500,000 17,835,699 20,801,918 24,056,277 Motor Vehicle in Lieu tax 5,084,458 5,418,600 5,703,803 6,141,974 6,007,290 6,435,921 6,564,639 6,695,932 Franchise Fees 3,723,066 3,424,711 3,277,733 4,138,935 3,283,600 4,584,399 4,676,087 4,769,609 Cannabis Tax 2,332,870 2,838,208 4,770,184 4,535,370 5,114,000 3,606,427 3,426,106 3,254,801 All Other Sources 39,470,907 23,604,028 22,710,242 28,268,279 21,750,289 28,558,244 29,180,503 29,518,814 General Fund Subtotal:142,109,092 114,534,530 132,413,920 173,263,534 155,985,228 175,260,139 178,397,162 186,115,768 Grant Revenue*12,102,934 32,134,208 9,936,066 21,131,392 5,764,478 Transfers From Other Funds 1,645,346 9,407,209 11,943,084 - 1,012,516 1,012,516 - - Total Revenue:143,754,438$ 123,941,739$ 144,357,004$ 185,366,468$ 189,131,952$ 186,208,721$ 199,528,555$ 191,880,247$ *FY19-21 grants not broken out 3.8%7.3%5.4%1.4%5.5%2.0%2.0% TOT 26% Property Taxes 16% Sales and Use 18% Utility 11% Motor Vehicle 3% Franchise Fees 2% Cannabis 2% All Other Sources 15% Grants 7% Revenues by Type - FY24 & FY25 - 10,000 20,000 30,000 40,000 50,000 60,000 FY2018-19 FY2019-20 FY2020-21 FY2021-22 FY2022-23 FY2023-24 FY2024-25ThousandsRevenue Category Trend FY19-FY25 Property Taxes Sales and Use Taxes Utility Users Tax Motor Vehicle in Lieu tax Franchise Fees Cannabis Tax All Other Sources Transient Occupancy Tax 6% 4% 7% -5% 23% 5%4%6% *CAGR % *CompoundAnnual Growth Rate -4-Item 3A - Page 18 City of Palm Springs Budget for Fiscal Years 2023-24 and 2024-25 REVENUE SUMMARY - GENERAL FUND Account Description FY 2018-19 FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 FY 2022-23 FY 2023-24 FY 2024-25 ACTUALS ACTUALS ACTUALS ACTUALS REVISED ESTIMATED DRAFT DRAFT BUDGET ACTUALS BUDGET BUDGET Taxes Current Year Taxes Secured 23,492,867$ 24,483,261$ 26,219,899$ 28,438,345$ 27,968,910$ 30,407,616$ 31,015,768$ 31,636,084$ Current Year Taxes Unsecured 1,064,191 998,823 1,122,282 393,167 1,266,840 21 - - Prior Year Taxes Unsecured (6,366) - - - - - - - In Lieu Prop Tax - Mvil 5,084,458 5,418,600 5,703,803 6,141,974 6,007,290 6,435,921 6,564,639 6,695,932 Net Ab 1 X 26 3,072,503 3,913,999 2,993,099 3,366,802 3,255,000 2,874,749 4,114,314 4,120,601 Cra Pass Thru City Of PS 600,543 343,728 801,494 947,441 730,961 2,052,107 1,168,377 1,169,844 Sales and Use Taxes 15,471,310 13,583,864 25,232,110 31,818,760 30,717,096 33,912,338 33,811,056 35,061,718 Measure J Sales Tax 16,043,737 - - - - - - - Cannabis Tax 10,252,468 10,177,978 4,770,184 4,215,353 4,794,000 3,332,021 3,165,420 3,007,149 Cannabis Tax - Meas E - - - 320,016 320,000 274,407 260,686 247,652 M Cannabis Audit Recovery 88,000 125,531 30,711 16,746 9,000 29,412 30,001 30,601 Parking Tax - 145,962 27,204 48,640 30,000 55,271 56,376 57,504 Franchises 3,723,066 3,424,711 3,277,733 4,138,935 3,283,600 4,584,399 4,676,087 4,769,609 Peg Fees 253,390 244,548 - - - - - - Transient Occupancy Tax 36,453,872 25,491,319 35,011,254 53,900,745 48,377,203 49,919,475 48,921,085 51,122,534 Transient Occupancy Permit 7,685 1,550 25 - - - - - Tot Audit Recovery 13,500 324,791 81,551 425,349 13,500 470,568 479,979 489,579 Documentary Transfer Tax 863,865 720,839 1,329,406 1,421,338 1,038,993 1,319,394 1,345,782 1,372,698 New Development Tax 244,628 213,129 384,500 510,319 400,000 314,814 321,110 327,532 Utility Users Tax 7,081,134 7,025,604 8,284,837 15,627,960 11,500,000 17,835,699 20,801,918 24,056,277 Subtotal - Taxes 123,804,851$ 96,638,237$ 115,270,093$ 151,731,890$ 139,712,393$ 153,818,210$ 156,732,599$ 164,165,312$ Licenses and Permits Business License 1,045,953$ 1,021,892$ 973,416$ 949,225$ 1,000,000$ 1,032,925$ 1,053,583$ 1,074,655$ Building Permits 1,445,097 1,939,180 2,795,112 2,897,393 2,470,583 2,573,414 2,689,218 2,769,894 Sewer Permits Ins Fee 7,495 8,626 12,509 10,143 7,446 5,964 6,233 6,419 Construction Permits 260,354 331,721 339,152 302,279 346,800 229,978 240,327 247,536 Permit Issuance 134,655 136,448 182,199 284,466 185,843 286,852 299,760 308,753 Sign Permits 24,220 27,673 40,515 28,237 27,540 18,020 18,831 19,396 Transportation Permit 8,418 10,662 11,442 10,482 10,200 8,787 9,182 9,458 Pool Drain Permits 2,446 1,623 1,099 1,462 2,040 1,488 1,555 1,602 Code Compliance Inspections 20,258 27,795 22,094 19,096 21,420 17,337 18,117 18,661 Renewals/Misc Permits 41,479 25,621 7,640 12,781 10,415 17,848 18,652 19,211 Zoning Fees 321,090 278,173 308,685 548,456 458,088 491,114 513,214 528,610 Subdivision Fees 124,596 99,592 108,956 88,133 117,300 117,785 123,085 126,778 Vacation Rental Permit 1,910,633 1,881,304 1,901,294 2,545,499 1,900,000 2,852,303 2,567,072 2,567,072 Vacant Building Registration 20,580 4,701 - 2,019 4,794 81 82 84 Sb1473 Building Stand Admin 1,263 2,595 3,366 1,500 - (1,431) 540 551 Rent Control Registration 40,470 38,940 38,220 37,620 42,000 37,200 37,944 38,703 Cannabis Permit Fee 280,124 137,014 123,169 258,001 163,200 323,478 307,304 313,450 State District Access Fee 1186 23,850 23,510 22,488 21,681 - 22,121 22,564 23,015 Admin Fee - Engineering - - - 80,230 43,860 137,255 143,432 147,735 Covenant - Engineering - - - 31,396 15,300 38,930 39,708 40,502 Subtotal - Licenses and Permits 5,712,983$ 5,997,070$ 6,891,355$ 8,130,099$ 6,826,829$ 8,211,448$ 8,110,403$ 8,262,086$ Intergovernmental Grants 295,602$ 343,381$ 845,571$ 2,668,456$ 26,723,808$ 9,936,066$ 21,131,392$ 5,764,478$ State Homeowners Tax Rel.246,244 119,523 236,240 118,062 250,000 - - - -5-Item 3A - Page 19 City of Palm Springs Budget for Fiscal Years 2023-24 and 2024-25 REVENUE SUMMARY - GENERAL FUND Account Description FY 2018-19 FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 FY 2022-23 FY 2023-24 FY 2024-25 ACTUALS ACTUALS ACTUALS ACTUALS REVISED ESTIMATED DRAFT DRAFT State Motor In Lieu Tax 22,899 - - - - - - - Peace Off Training Funds 53,129 174,649 23,541 20,090 30,000 72,324 73,770 75,246 Mutual Aid Overtime 138,877 42,143 497,516 137,441 (88,322) 158,492 161,662 164,895 Federal Grants - - 1,386,344 9,434,478 5,410,400 - - - Subtotal - Intergovernmental 756,752$ 679,695$ 2,989,212$ 12,378,527$ 32,325,887$ 10,166,882$ 21,366,825$ 6,004,619$ Charges for Services Local Dev Mitigation Fee 11,384$ (7,774)$ (24,010)$ 3,358$ 1,200$ (703)$ 1,283$ 1,309$ St Highway Maintenance - - 1,800 - - - - - Concessions 9,955 3,974 576 927 3,974 27,399 27,947 28,505 Assess Dist Info Gen Fund 4,102 7,500 - - 7,500 - - - Smoke Detector Inspection 270,924 42,949 - - - - - - Other Charges Current Services 13,179 57,006 32,668 44,785 62,158 47,849 48,806 49,782 Insurance 9,000 8,025 - 4,153 3,451 2,350 2,397 2,445 Towing Fees - - - 102,745 76,327 97,139 101,510 103,540 Multi Unit Fire Insp Fee 177,577 179,126 147,877 263,167 191,486 270,734 282,917 288,576 Shooting Range 1,936 2,458 1,749 5,546 3,207 3,809 3,885 3,963 Fingerprint Fees 1,912 3,031 (156) (52) 3,240 1 - - Police Contract Ot - - - 141,607 170,529 244,088 248,969 253,949 Fire Inspection Fee 74,442 81,106 13,131 193 86,702 (197) 794 810 Fire Plan Check Fee 178,662 146,277 115,343 148,979 156,370 136,904 143,064 145,926 Fire Commercial Insp Fee - 43,340 36,059 30,775 46,330 27,249 28,475 29,045 Fire Cert Program - 1,991 - 1,550 1,176 511 534 545 Fire Fees Misc 3,358 2,650 1,645 5,629 2,328 4,325 4,520 4,610 Dui Program - 1,551 36,378 38,824 33,139 21,926 22,365 22,812 Building Plan Check Fees 592,614 560,365 671,617 743,379 632,848 676,910 707,371 721,519 Engineering Plan Check Fees 298,892 262,077 372,255 185,879 280,160 228,273 238,545 243,316 Miscellaneous Filing Fee 292,620 401,137 535,749 296,028 428,815 235,595 246,197 251,121 Misc Engineering Fees 51,360 36,810 29,236 8,084 39,350 4,188 4,272 4,357 Inhouse Fast Plan Check Fees 2,500 - - - - - - - Real Property Fees 15,222 30,218 26,963 22,256 32,303 16,351 16,678 17,012 Gen Plan Maintenance Surcharge 57,023 64,503 84,742 126,190 90,589 139,737 142,532 145,383 Planning Admin Services - - - 6,568 10,690 - 1,000 1,020 Administrative Service Charges 2,229,505 2,134,057 2,168,092 2,282,952 2,312,247 2,361,513 2,488,511 2,402,558 Parklet Fees - - - 83,152 48,105 97,850 99,807 101,803 Nuisance Abatement 29,266 18,750 32,213 - 20,044 7,665 7,818 7,974 Nuisance Abatement Admin (3,544) 5,221 1,919 - 5,581 404 412 420 PS USD Officer 152,764 146,802 - 87,674 156,931 185,465 189,175 192,958 Rent A Cell 49,818 45,986 45,986 46,028 49,159 48,627 49,599 50,591 Issuance Fee - 1,785 - 20,254 10,835 21,698 22,675 23,128 Tlc/Psvu Site Fees 1,542 1,295 - - 3,293 3,212 3,276 3,342 Friends Of The Library - - 3,674 28,987 13,927 26,969 27,508 28,059 Library Fees 10,570 8,676 939 6,084 5,345 6,910 7,048 7,189 Camp 52,716 105,067 60,372 93,148 54,038 114,188 116,472 118,801 Instructional Dance - 676 - - - - - - Fitness 104,644 74,262 (326) 314 2,138 10 10 10 Youth Programs 93,476 83,614 475 53,173 89,383 28,359 28,926 29,504 Facilites Rent 234,459 200,545 101,830 143,510 214,383 156,861 159,998 163,198 Special Activities 956,320 943,514 941,547 996,870 320,700 660,229 673,433 686,902 -6-Item 3A - Page 20 City of Palm Springs Budget for Fiscal Years 2023-24 and 2024-25 REVENUE SUMMARY - GENERAL FUND Account Description FY 2018-19 FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 FY 2022-23 FY 2023-24 FY 2024-25 ACTUALS ACTUALS ACTUALS ACTUALS REVISED ESTIMATED DRAFT DRAFT Location Permits 25,938 15,660 23,925 27,202 17,104 10,527 11,001 11,221 Instructional Classes 3,656 7,346 1,027 50,709 37,415 42,980 43,840 44,716 Membership 20,722 7,785 8,002 16,277 11,438 10,378 10,586 10,797 Baseball Stadium Rent 119,029 111,789 144,228 151,329 120,797 133,822 136,498 139,228 Microfilming Fees 35,551 31,975 32,031 43,794 35,268 40,544 42,369 43,216 Rancho Park Ii Landscape 9,348 9,348 9,348 9,348 9,993 - - - Desert Dorado Landscape - - - - - 9,348 9,534 9,725 Daily Admissions 52,285 42,964 51,800 58,991 45,929 38,760 39,535 40,326 Group Lessons 3,339 432 337 1,323 3,207 2,373 2,420 2,469 Private Lessons 316 - - - - - - - Pool Rental Group 18,287 49,033 7,215 19,987 21,380 29,195 29,779 30,375 Pool Passes 47,312 40,673 102,321 92,227 80,175 52,128 53,170 54,234 Coin Lockers 1,317 - - - - - - - Tournaments - 657 - - - - - - Banner Hanging 11,302 6,555 1,642 9,711 7,500 3,036 3,097 3,159 TRACT 27,898 29,754 8,405 - 5,861 8,370 13,537 13,808 Henry Frank Parking 3,420 3,012 192 3,264 - 4,269 4,354 4,441 Villagefest 457,452 346,116 2,233 182,235 150,000 162,647 165,900 169,218 Subtotal - Charges for Services 6,815,368$ 6,401,665$ 5,833,046$ 6,689,111$ 6,216,048$ 6,452,773$ 6,714,351$ 6,712,915$ 261,578 Fines & Penalties False Alarm Fee 334,394$ 314,774$ 128,223$ 164,456$ 140,000$ 157,538$ 160,689$ 163,903$ Alarm Permits - - 153,999 (0) 170,518 130,607 133,219 135,883 Vehicle Code Fines 107,055 82,819 105,631 75,860 82,819 72,799 74,255 75,740 Criminal Code Fines 31,397 13,928 24,154 34,889 35,490 2,837 2,893 2,951 Parking Violations 138,428 115,428 23,076 112,016 98,200 112,216 114,460 116,750 Late Charges 446 - - - - - - - Library Fines and Fees 10,375 7,128 371 6,175 7,100 6,629 6,762 6,897 Administrative Citations 474,762 202,798 228,805 196,863 202,798 230,992 235,612 240,324 Parking Violation Admin 1,992 1,823 160 (95) - - - - Subtotal - Fines & Penalties 1,098,849$ 738,699$ 664,419$ 590,165$ 736,925$ 713,617$ 727,890$ 742,447$ Use of Money and Property Interest Income 853,388$ 650,476$ (246,860)$ (184,916)$ 500,000$ 3,553,912$ 3,552,748$ 3,623,803$ Unrealized Gain Or Loss 563,545 834,855 (1,169,988) (1,859,181) - - - - Building/Facilities Rent 144,003 181,930 121,176 200,960 213,800 250,085 255,086 260,188 Village Green Rental 31,442 25,676 23,586 24,233 26,693 26,066 26,588 27,119 Sale Real Or Personal Property 49,339 3,157 12,106 1,303,600 - 7,489 7,638 7,791 Subtotal - Use of Money 1,641,718$ 1,696,095$ (1,259,980)$ (515,304)$ 740,493$ 3,837,552$ 3,842,061$ 3,918,902$ Miscellaneous Revenue Walk of Stars 70,000$ 181,700$ 45,000$ 99,300$ -$ 190,658$ 194,471$ 198,360$ Plaza Theater Donations - - 150,269 15,825 - - - - Penalty/Interest Deliq Taxes 170,426 141,565 205 - - - - - Waste Disposal Clearing 22,631 25,309 117,434 (73,026) 126,127 22,541 22,992 23,452 Audit Recovery 1,997 1,243 2,711 685 1,243 7,529 7,680 7,833 Contrib Non-Govt Sources 295,053 380,394 301,387 5,745,039 100 8,859 9,036 9,217 Legal Fee Reimbursement 50,000 275 - 22,000 275 86,309 88,036 89,796 -7-Item 3A - Page 21 City of Palm Springs Budget for Fiscal Years 2023-24 and 2024-25 REVENUE SUMMARY - GENERAL FUND Account Description FY 2018-19 FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 FY 2022-23 FY 2023-24 FY 2024-25 ACTUALS ACTUALS ACTUALS ACTUALS REVISED ESTIMATED DRAFT DRAFT Smip 2,040 1,064 1,163 1,721 - 1,647 1,680 1,714 Smip Ii - - 306 788 - 3,058 3,119 3,182 Miscellaneous Revenue 418,781 351,289 111,139 71,643 - 112,689 114,943 117,242 Cashier Over (92) (19) (43) (112) - 60 62 63 Damage Recovery 47,028 20,321 26,330 1,834 - - - - Settlement Revenue 10,000 39,428 36,795 53,671 - 10,000 10,200 10,404 Contributions-Non Govt 93,426 - - - - - - - Restricted Donations - - 23,638 375,466 225,000 291,315 297,142 303,085 Rent - Master Lease 979,308 1,209,167 1,207,065 (1,570) 1,208,116 1,208,116 1,232,278 1,256,924 Reimbursement - 29,390 2,377 37,436 - 35,650 36,363 37,090 Electrical Reimbursement 3,223 1,937 - - - - - - Low/Mod Housing Residual - 6 - - - - - - All Other RDA Residual 114,750 - - - - - - - Cannabis Odor Recovery - - - 11,283 - 17,291 16,426 15,605 Subtotal - Miscellaneous Revenue 2,278,571$ 2,383,068$ 2,025,775$ 6,361,981$ 1,560,861$ 1,995,723$ 2,034,427$ 2,073,966$ Subtotal General Fund 142,109,092$ 114,534,530$ 132,413,920$ 185,366,468$ 188,119,436$ 185,196,205$ 199,528,555$ 191,880,247$ Budget Transfer In 1,645,346 9,407,209 11,943,084 - 1,012,516 1,012,516 - - Total Revenues 143,754,438$ 123,941,739$ 144,357,004$ 185,366,468$ 189,131,952$ 186,208,721$ 199,528,555$ 191,880,247$ -8-Item 3A - Page 22 City of Palm Springs Budget for Fiscal Years 2023-24 and 2024-25 General Fund Expenses FY 2023-24 & FY 2024-25 -9-Item 3A - Page 23 City of Palm Springs Budget for Fiscal Years 2023-24 and 2024-25 General Fund Expenditure Summary FY2018-19 FY2019-20 FY2020-21 FY2021-22 FY2022-23 FY2022-23 FY2023-24 FY2024-25 Account Description Actuals Actuals Actuals Actuals Revised Budget Estimated Actuals Draft Budget Draft Budget General Government 41,972,143$ 41,171,900$ 36,265,793$ 53,084,325$ 66,894,798$ 52,781,254$ 62,658,128$ 64,341,227$ Police 30,422,443 34,483,096 33,120,972 38,060,515 42,701,941 42,017,426 43,373,985 44,723,596 Fire 16,919,802 18,657,514 19,148,030 23,469,519 27,031,279 24,836,102 27,973,687 29,463,009 Parks and Recreation 8,105,265 8,316,842 6,902,278 9,106,075 13,562,720 10,846,125 15,170,072 15,782,444 PERS Future Cost Reserve - - - - 6,000,000 6,000,000 6,000,000 6,000,000 General Fund Subtotal:97,419,653 102,629,353 95,437,073 123,720,434 156,190,738 136,480,907 155,175,872 160,310,276 Transfers - 24,074,841 18,622,268 10,095,765 27,331,298 27,331,298 19,731,879 18,777,686 Set Aside Items 23,809,000 3,964,860 19,844,140 - Grant Expense*1,163,506 27,216,631 9,936,066 21,131,392 5,764,478 Total Expenditure:97,419,653$ 126,704,194$ 114,059,341$ 134,979,705$ 234,547,667$ 177,713,131$ 215,883,283$ 184,852,439$ *FY19-21 grants not broken out City Administration 11% City Executive Management 3% Community & Economic Development 3% Development Services 7% Events & Tourism 5% Fire 16% Leases 1% Library 2% Parks and Recreation 8% PERS Future Cost Reserve 3% Police 25% Public Affairs 1% Public Works 4%Council Set Asides 5% Homelessness 6% Spending by Major Department - Total FY24 & FY25 Salaries & Benefits 52% Materials & Supplies 1% Contractual Services 18% Repairs & Maintenance 8% Utilities 1% Insurance 3% Grants 7% All Other 10% Expenses by Category - Total FY24 & FY25 -10-Item 3A - Page 24 City of Palm Springs Budget for Fiscal Years 2023-24 and 2024-25 EXPENDITURE SUMMARY - GENERAL FUND Department Description FY 2018-19 FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 FY 2022-23 FY 2023-24 FY 2024-25 ACTUALS ACTUALS ACTUALS ACTUALS REVISED ESTIMATED DRAFT DRAFT BUDGET ACTUALS BUDGET BUDGET General Government City Council 641,135$ 572,989$ 611,097$ 688,200$ 1,649,659$ 1,236,411$ 1,705,108$ 1,729,657$ City Manager/Admin 1,483,037 1,686,890 1,669,191 1,360,076 2,030,973 1,642,427 1,840,706 1,929,263 City Attorney 3,324,737 998,298 793,567 1,432,208 1,947,000 1,686,120 1,947,315 2,005,741 City Clerk 1,238,491 1,244,737 1,112,753 1,144,532 1,554,206 1,089,370 1,722,753 1,815,559 Document Management 259,866 308,233 276,989 256,913 359,338 320,311 397,122 406,375 Information Tech/PSCTV 2,208,256 3,019,424 2,721,096 3,581,131 5,945,690 5,250,982 7,040,958 6,859,450 Human Resources 454,193 507,003 504,898 741,553 1,054,814 967,004 1,065,544 1,144,534 Finance 3,055,611 5,475,816 3,834,153 7,247,519 8,395,857 6,609,238 7,827,251 8,134,356 Procurement 523,170 603,256 383,639 580,086 721,735 672,686 844,987 908,571 Office of Special Programs 1,024,753 999,767 1,006,013 1,862,387 4,232,336 3,665,382 4,046,536 2,348,690 Code Compliance 626,650 969,347 1,119,307 1,163,880 2,503,362 1,538,747 2,441,269 2,530,858 Public Affairs 289,708 369,639 322,798 367,942 916,629 364,383 971,675 993,207 Appropriation for Contingency - - - - - Non Departmental - - 151,555 409,422 20,619,000 4,459,095 12,554,730 (4,647,000) Engineering 2,642,969 2,896,186 2,628,098 4,878,911 4,535,199 3,547,268 4,808,445 4,772,540 Building & Code Enforcement 2,794,819 2,781,480 2,731,238 2,896,224 4,147,847 3,425,889 4,275,675 4,427,389 Planning Services 1,774,568 2,256,590 2,220,909 2,308,957 3,409,596 2,549,185 3,180,149 3,013,349 Community and Economic Development 4,599,557 2,014,881 1,870,968 1,457,329 5,808,122 2,045,917 3,903,136 4,029,648 Homeless Program 522,838 456,245 237,493 6,232,241 24,680,000 7,703,556 20,709,202 4,000,000 Rent Control 42,173 70,910 82,669 101,419 114,155 119,462 126,329 132,897 Neighborhood Development 172,167 188,507 179,658 221,911 251,738 226,465 228,993 237,369 GPSCVB 619,749 456,164 548,582 945,942 1,115,000 1,033,561 850,000 870,000 Visitor Information Center 5,418 4,343 - - 255,809 191,857 273,607 273,607 Tourism 2,086,504 2,042,641 1,636,474 2,014,000 2,405,443 2,102,829 2,403,670 2,403,670 Special Events and Contributions 255,167 542,777 12,150 495,550 1,000,000 736,014 1,000,000 1,030,001 Special Contributions 232,500 34,483 - - - - - - Film Fest Sponsorship 350,000 350,000 - 350,000 350,000 350,000 350,000 360,501 Special Contributions - PS Resorts 120,846 204,954 - 200,691 225,000 240,524 225,000 231,751 Chamber of Commerce 16,607 86,382 32,267 71,348 208,304 75,199 107,200 163,920 Convention Center 2,639,874 2,594,682 2,760,638 3,304,256 2,936,859 2,485,759 2,941,685 3,033,197 Plaza Theater 34,233 29,891 203,716 190,533 2,166,337 606,009 1,167,776 1,173,187 Special Development Tracts 500 55,093 44,124 - - 826 - - Library 2,400,193 2,464,050 2,225,816 2,705,428 3,258,033 2,777,564 3,285,750 3,447,782 Library - Welwood 235,870 64,703 20,965 149,293 189,737 41,214 194,525 197,989 Parking Structure Maintenance - - 97,840 72,850 169,145 88,199 175,622 184,360 Street Maintenance 1,654,978 1,691,775 1,387,755 1,809,946 2,687,169 2,267,169 2,770,456 3,390,716 Downtown Experience Maintenance 1,356,653 1,444,728 1,283,783 1,474,857 2,039,250 1,359,661 1,908,942 1,998,975 Street Cleaning - - 20,270 19,500 26,400 - 26,400 27,193 Street Lighting 860,660 888,813 928,453 1,112,928 1,276,104 1,625,214 1,591,833 1,667,830 Railroad Station 22,747 17,362 26,407 22,437 56,590 10,251 55,321 57,843 Parking Structure/Control 310,712 314,233 56,081 - - - - - Master Lease 1,716,883 1,433,980 1,641,692 375,433 1,641,700 1,231,002 1,641,700 1,690,952 Subtotal - General Government 42,598,793$ 42,141,248$ 37,385,100$ 54,247,831$ 116,884,137$ 66,342,747$ 102,607,370$ 68,975,927$ Police Police Administration 26,454,610$ 30,076,000$ 28,845,693$ 34,476,801$ 39,304,584$ 37,740,021$ 39,785,473$ 40,971,462$ Jail Operations 326,565 365,384 261,359 285,761 438,741 251,205 426,046 438,533 Animal Control 444,468 442,428 329,455 375,661 562,506 525,001 496,590 518,821 Animal Shelter 1,253,874 1,139,827 989,707 1,102,768 1,157,402 1,163,463 1,157,402 1,192,128 Dispatch Center 1,316,276 1,490,109 1,575,452 1,819,524 2,174,752 2,576,920 2,473,280 2,669,099 Subtotal - Police 29,795,793$ 33,513,749$ 32,001,665$ 38,060,515$ 43,637,985$ 42,256,611$ 44,338,791$ 45,790,044$ Fire Fire Administration 16,814,003$ 18,523,495$ 19,103,529$ 23,354,240$ 26,935,704$ 24,836,114$ 27,854,939$ 29,333,122$ Emergency Management 105,799 134,019 44,501 115,279 157,059 61,472 180,232 193,217 Subtotal - Fire 16,919,802$ 18,657,514$ 19,148,030$ 23,469,519$ 27,092,764$ 24,897,586$ 28,035,172$ 29,526,339$ Parks and Recreation Park Maintenance 3,729,095$ 3,726,800$ 3,005,831$ 4,137,293$ 5,819,428$ 5,164,102$ 6,166,876$ 6,260,869$ Recreation 1,840,799 2,076,406 1,716,622 2,284,650 3,806,138 2,897,548 4,382,444 4,756,272 -11-Item 3A - Page 25 City of Palm Springs Budget for Fiscal Years 2023-24 and 2024-25 EXPENDITURE SUMMARY - GENERAL FUND Department Description FY 2018-19 FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 FY 2022-23 FY 2023-24 FY 2024-25 ACTUALS ACTUALS ACTUALS ACTUALS REVISED ESTIMATED DRAFT DRAFT BUDGET ACTUALS BUDGET BUDGET Tennis and Pickleball 6,995 2,797 94,578 60,913 162,610 24,939 161,928 163,708 Skate Park 175,232 174,708 87,600 110,766 166,366 147,075 184,200 197,925 Swim Center 764,742 765,624 732,325 822,786 1,205,223 915,174 1,312,865 1,368,721 Demuth Community Center 307,455 349,894 303,167 392,188 699,731 298,119 800,622 829,374 James O Jessie DHUC 769,062 733,359 733,400 803,087 1,059,884 691,246 1,265,308 1,273,953 Village Fest 511,885 487,254 228,754 494,392 682,104 746,687 895,830 931,622 Subtotal - Parks and Recreation 8,105,265$ 8,316,842$ 6,902,278$ 9,106,075$ 13,601,484$ 10,884,889$ 15,170,072$ 15,782,444$ PERS Futre Cost Reserve -$ -$ -$ -$ 6,000,000$ 6,000,000$ 6,000,000$ 6,000,000$ Subtotal - PERS -$ -$ -$ -$ 6,000,000$ 6,000,000$ 6,000,000$ 6,000,000$ Subtotal - General Fund 97,419,653$ 102,629,353$ 95,437,073$ 124,883,940$ 207,216,369$ 150,381,833$ 196,151,405$ 166,074,754$ Transfers Budget Transfer - Out -$ 24,074,841$ 18,622,268$ 10,095,765$ 27,331,298$ 27,331,298$ 19,731,879$ 18,777,686$ Total Expenses 97,419,653$ 126,704,194$ 114,059,341$ 134,979,705$ 234,547,667$ 177,713,131$ 215,883,283$ 184,852,439$ -12-Item 3A - Page 26 City of Palm Springs Budget for Fiscal Years 2023-24 and 2024-25 All Funds - Fund Balances Schedules FY 2022-23 FY 2023-24 FY 2024-25 -13-Item 3A - Page 27 City of Palm Springs Budget for Fiscal Years 2023-24 and 2024-25 Adopted Fund Balance Schedule - FY 2022-23 REV TRAN EXP TRAN Fund 7/1/2022 Beginning Fund Balance FY 2022-23 Estimated Revenue FY 2022-23 Estimated Transfer-In FY 2022-23 Estimated Expenses FY 2022-23 Estimated Transfer-Out 6/30/2023 Estimated Ending Fund Balance General Fund - Unassigned and Contingencies 101,952,531$ 185,196,205$ 1,012,516$ 150,381,833$ 27,331,298$ 110,448,122$ Small Hotel TBID Fund 29,135 700,000 - 700,000 - 29,135 Forfeited Assets Fund 250,955 - - 10,000 - 240,955 Safety Augmentation Fund 2,426,007 1,125,078 - 1,271,088 - 2,279,997 Special Development Fund 2,054,623 - - - - 2,054,623 CSA 152 Fund 216,661 459,100 - 335,668 - 340,093 Recycling Fund 695,818 223,457 - 713,619 - 205,656 Parking Capital Programs Fund 547,345 - - - - 547,345 Special Gas Tax Improvements Fund 2,058,915 1,394,633 - 1,000,000 - 2,453,548 Measure A Improvements Fund 7,991,377 3,000,000 - 2,500,000 - 8,491,377 Drainage Fund 2,049,965 500,000 - 200,000 - 2,349,965 Emergency Response Fund 138,716 1,020,000 - 1,043,627 - 115,089 Community Development Block Grant - 285,000 - 285,000 - - Sustainability Fund 1,090,045 384,500 140,578 680,353 - 934,770 CFD Public Safety #1 Fund 1,219,755 1,027,302 - 931,564 - 1,315,493 Land/Light/Park Maintenance Dist 711,573 235,880 - 167,625 - 779,828 SB1 RMRA Road Maintenance Rehab 1,855,683 877,178 - 600,000 - 2,132,861 CFD Canyon View 16,565 - - 16,565 - - Air Quality Management Fund 142,461 62,000 - 101,929 - 102,532 Public Arts Fund 1,113,204 546,389 - 214,609 - 1,444,984 Library Endowment Fund 1,773,195 - - 20,000 - 1,753,195 Quimby Act Fund 3,249,942 650,000 - 100,000 - 3,799,942 Special Projects Fund 2,910,189 100,000 - 100,000 - 2,910,189 Measure J Capital Projects Fund 32,744,801 17,804,531 - 9,446,587 5,138,500 35,964,245 Capital Projects Fund 14,191,740 11,115,087 6,500,000 7,548,427 7,766 24,250,634 Debt Service Fund 5,693,138 - 9,819,450 11,479,011 - 4,033,577 AD 2015 - 1 Fund 1,607,811 565,628 - 567,628 - 1,605,811 Airport Fund (405-416)111,578,148 62,622,050 4,631,078 39,423,462 5,385,828 134,021,986 Wastewater Treatment Plant (WWTP)81,523,627 10,423,972 - 12,256,352 - 79,691,247 Golf Course Fund 3,402,677 4,585,578 400,000 5,630,928 - 2,757,327 Fleet Services Fund 5,270,975 8,367,600 5,824,770 6,212,506 - 13,250,839 Facility Maintenance Fund 4,228,717 6,400,000 6,817,500 9,209,516 - 8,236,701 Employee Retirement Benefits Fund 6,365,410 25,892,700 - 24,630,631 - 7,627,479 Risk Management Fund 11,440,539 20,854,074 - 17,718,546 - 14,576,067 Retiree Health Insurance Fund 3,195,474 3,980,682 - 4,105,059 - 3,071,097 Energy Fund 1,737,042 2,358,956 467,500 2,682,724 - 1,880,774 Equipment Replacement Fund - - 1,500,000 1,000,000 - 500,000 Merged #1 Cap Successor 590,165 250,000 - 200,000 - 640,165 Housing Successor Agency Fund 11,205,011 - - 3,282,659 - 7,922,352 Successor Agency Debt Service (26,506,580) 5,639,262 - 2,446,600 - (23,313,918) Total All Funds 402,763,355$ 378,646,841$ 37,113,392$ 319,214,115$ 37,863,392$ 461,446,082$ -14-Item 3A - Page 28 City of Palm Springs Budget for Fiscal Years 2023-24 and 2024-25 Fund Balance Schedule - FY 2023-24 REV TRAN EXP TRAN Fund 7/1/2023 Beginning Fund Balance FY 2023-24 Draft Budgeted Revenue FY 2023-24 Draft Transfer- In FY 2023-24 Draft Budgeted Expenses FY 2023-24 Draft Transfer- Out 6/30/2024 Estimated Ending Fund Balance General Fund - Unassigned and Contingencies 110,448,122$ 199,528,555$ -$ 196,151,405$ 19,731,879$ 94,093,393$ Small Hotel TBID Fund 29,135 769,046 - 769,046 - 29,135 Forfeited Assets Fund 240,955 3,000 - 169,046 - 74,909 Safety Augmentation Fund 2,279,997 1,421,140 - 1,098,616 - 2,602,521 Special Development Fund 2,054,623 11,137 - - - 2,065,760 CSA 152 Fund 340,093 470,400 - 311,548 - 498,945 Recycling Fund 205,656 247,176 152,411 399,587 - 205,657 Parking Capital Programs Fund 547,345 8,500 - - - 555,845 Special Gas Tax Improvements Fund 2,453,548 1,394,633 - 1,000,176 - 2,848,005 Measure A Improvements Fund 8,491,377 7,878,780 - 9,681,254 - 6,688,903 Drainage Fund 2,349,965 525,000 - 617,260 - 2,257,705 Emergency Response Fund 115,089 1,022,618 - 1,022,618 - 115,089 Community Development Block Grant - 413,506 114,954 528,460 - - Sustainability Fund 934,770 371,576 354,431 726,007 - 934,770 CFD Public Safety #1 Fund 1,315,493 1,030,000 - 673,713 - 1,671,780 Land/Light/Park Maintenance Dist 779,828 199,000 - 509,983 - 468,845 SB1 RMRA Road Maintenance Rehab 2,132,861 1,113,536 - 1,097,504 - 2,148,893 CFD Canyon View - 135 - - - 135 Air Quality Management Fund 102,532 60,718 - 61,929 - 101,320 Public Arts Fund 1,444,984 484,463 - 1,416,137 - 513,310 Library Endowment Fund 1,753,195 37,000 - 1,716,195 - 74,000 Quimby Act Fund 3,799,942 635,000 - 837,555 - 3,597,387 Special Projects Fund 2,910,189 348,228 - 100,000 - 3,158,417 Measure J Capital Projects Fund 35,964,245 22,770,046 - 26,162,557 3,133,700 29,438,035 Capital Projects Fund 24,250,634 38,024,600 2,000,000 48,462,868 - 15,812,366 Debt Service Fund 4,033,577 - 9,904,081 11,601,362 - 2,336,296 AD 2015 - 1 Fund 1,605,811 565,628 - 565,028 - 1,606,411 Airport Fund (405-416)134,021,986 107,719,228 13,423,634 96,949,309 13,423,634 144,791,905 Wastewater Treatment Plant (WWTP)79,691,247 12,187,000 - 21,518,635 - 70,359,612 Golf Course Fund 2,757,327 5,355,415 979,451 6,334,866 - 2,757,327 Fleet Services Fund 13,250,839 5,787,839 5,303,750 16,151,315 - 8,191,113 Facility Maintenance Fund 8,236,701 8,370,620 4,056,500 18,982,721 - 1,681,100 Employee Retirement Benefits Fund 7,627,479 30,245,455 - 30,245,455 - 7,627,479 Risk Management Fund 14,576,067 24,303,827 - 24,111,104 - 14,768,790 Retiree Health Insurance Fund 3,071,097 3,985,490 - 3,985,490 - 3,071,097 Energy Fund 1,880,774 3,745,806 - 3,745,806 - 1,880,774 Equipment Replacement Fund 500,000 500,000 - 1,000,000 - - Merged #1 Cap Successor 640,165 265,000 - 355,449 - 549,717 Housing Successor Agency Fund 7,922,352 - - 387,867 - 7,534,485 Successor Agency Debt Service (23,313,918) 2,397,792 - 2,400,300 - (23,316,426) Total All Funds 461,446,082$ 484,196,893$ 36,289,213$ 531,848,170$ 36,289,213$ 413,794,805$ -15-Item 3A - Page 29 City of Palm Springs Budget for Fiscal Years 2023-24 and 2024-25 Fund Balance Schedule - FY 2024-25 REV TRAN EXP TRAN Fund 7/1/2024 Beginning Fund Balance FY 2024-25 Draft Budgeted Revenue FY 2024-25 Draft Transfer-In FY 2024-25 Draft Budgeted Expenses FY 2024-25 Draft Transfer-Out 6/30/2025 Estimated Ending Fund Balance General Fund - Unassigned and Contingencies 94,093,393$ 191,880,247$ -$ 166,074,754$ 18,777,686$ 101,121,200$ Small Hotel TBID Fund 29,135 807,498 - 807,498 - 29,135 Forfeited Assets Fund 74,909 1,000 - - - 75,909 Safety Augmentation Fund 2,602,521 1,472,940 - 1,155,961 - 2,919,500 Special Development Fund 2,065,760 15,000 - - - 2,080,760 CSA 152 Fund 498,945 300,000 - 324,069 - 474,876 Recycling Fund 205,657 247,176 161,153 408,329 - 205,657 Parking Capital Programs Fund 555,845 8,800 - - - 564,645 Special Gas Tax Improvements Fund 2,848,005 1,225,000 - 1,225,000 - 2,848,005 Measure A Improvements Fund 6,688,903 6,208,526 - 5,715,920 - 7,181,509 Drainage Fund 2,257,705 520,000 - - - 2,777,705 Emergency Response Fund 115,089 1,022,618 - 900,954 - 236,753 Community Development Block Grant - 413,506 112,882 526,388 - (0) Sustainability Fund 934,770 371,576 364,845 736,421 - 934,770 CFD Public Safety #1 Fund 1,671,780 1,030,000 - 693,395 - 2,008,384 Land/Light/Park Maintenance Dist 468,845 199,000 - 500,000 - 167,845 SB1 RMRA Road Maintenance Rehab 2,148,893 1,151,193 - - - 3,300,086 CFD Canyon View 135 200 - - - 335 Air Quality Management Fund 101,320 60,718 - 63,788 - 98,250 Public Arts Fund 513,310 509,211 - 281,041 - 741,480 Library Endowment Fund 74,000 43,000 - - - 117,000 Quimby Act Fund 3,597,387 652,401 - - - 4,249,788 Special Projects Fund 3,158,417 353,492 - 103,001 - 3,408,908 Measure J Capital Projects Fund 29,438,035 23,655,226 - 21,618,552 3,133,200 28,341,509 Capital Projects Fund 15,812,366 21,902,904 2,000,000 22,035,324 - 17,679,946 Debt Service Fund 2,336,296 - 9,939,037 11,726,443 - 548,890 AD 2015 - 1 Fund 1,606,411 582,598 - 562,831 - 1,626,178 Airport Fund (405-416)144,791,905 142,049,147 41,988,000 144,325,188 41,988,000 142,515,863 Wastewater Treatment Plant (WWTP)70,359,612 12,505,212 - 16,118,925 - 66,745,899 Golf Course Fund 2,757,327 5,516,077 979,219 6,495,296 - 2,757,327 Fleet Services Fund 8,191,113 5,984,833 4,302,250 11,097,933 - 7,380,263 Facility Maintenance Fund 1,681,100 8,872,635 4,051,500 13,872,635 - 732,600 Employee Retirement Benefits Fund 7,627,479 31,657,003 - 31,657,003 - 7,627,479 Risk Management Fund 14,768,790 26,241,578 - 26,043,070 - 14,967,298 Retiree Health Insurance Fund 3,071,097 3,986,553 - 3,986,553 - 3,071,097 Energy Fund 1,880,774 4,289,998 - 4,289,998 - 1,880,774 Equipment Replacement Fund - 500,000 - 500,000 - - Merged #1 Cap Successor 549,717 265,000 - 367,154 - 447,563 Housing Successor Agency Fund 7,534,485 - - 305,106 - 7,229,380 Successor Agency Debt Service (23,316,426) 2,397,792 - 2,376,600 - (23,295,234) Total All Funds 413,794,805$ 498,899,658$ 63,898,886$ 496,895,129$ 63,898,886$ 415,799,333$ -16-Item 3A - Page 30 City of Palm Springs Budget for Fiscal Years 2023-24 and 2024-25 All Funds - Revenues FY 2023-24 & FY 2024-25 -17-Item 3A - Page 31 City of Palm Springs Budget for Fiscal Years 2023-24 and 2024-25 Revenue Summary - All Funds Account Description FY 2018-19 FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 FY 2023-24 FY 2024-25 ACTUALS ACTUALS ACTUALS ACTUALS REVISED DRAFT DRAFT BUDGET BUDGET BUDGET Taxes Current Year Taxes Secured 23,492,867$ 24,483,261$ 26,219,899$ 28,438,345$ 27,968,910$ 31,015,768$ 31,636,084$ Current Year Taxes Unsecured 1,064,191 998,823 1,122,282 393,167 1,266,840 - - Prior Year Taxes Unsecured (6,366) - - - - - - In Lieu Prop Tax - Mvil 5,084,458 5,418,600 5,703,803 6,141,974 6,007,290 6,564,639 6,695,932 Net Ab 1 X 26 3,072,503 3,913,999 2,993,099 3,366,802 3,255,000 4,114,314 4,120,601 Cra Pass Thru City Of PS 600,543 343,728 801,494 947,441 730,961 1,168,377 1,169,844 Sales and Use Taxes 15,471,310 13,583,864 25,232,110 31,818,760 30,717,096 33,811,056 35,061,718 Measure J Sales Tax 16,043,737 (0) - - - - - Cannabis Tax 10,252,468 10,177,978 4,770,184 4,215,353 4,794,000 3,165,420 3,007,149 Cannabis Tax - Meas E - - - 320,016 320,000 260,686 247,652 M Cannabis Audit Recovery 88,000 125,531 30,711 16,746 9,000 30,001 30,601 Parking Tax - 145,962 27,204 48,640 30,000 56,376 57,504 Franchises 3,723,066 3,424,711 3,277,733 4,138,935 3,283,600 4,676,087 4,769,609 Peg Fees 253,390 244,548 - - - - - Transient Occupancy Tax 36,453,872 25,491,319 35,011,254 53,900,745 48,377,203 48,921,085 51,122,534 Transient Occupancy Permit 7,685 1,550 25 - - - - Tot Audit Recovery 13,500 324,791 81,551 425,349 13,500 479,979 489,579 Documentary Transfer Tax 863,865 720,839 1,329,406 1,421,338 1,038,993 1,345,782 1,372,698 New Development Tax 244,628 213,129 384,500 510,319 400,000 321,110 327,532 Utility Users Tax 7,081,134 7,025,604 8,284,837 15,627,960 11,500,000 20,801,918 24,056,277 Subtotal - Taxes 123,804,851$ 96,638,237$ 115,270,093$ 151,731,890$ 139,712,393$ 156,732,599$ 164,165,312$ Licenses and Permits Business License 1,045,953$ 1,021,892$ 973,416$ 949,225$ 1,000,000$ 1,053,583$ 1,074,655$ Building Permits 1,445,097 1,939,180 2,795,112 2,897,393 2,470,583 2,689,218 2,769,894 Sewer Permits Ins Fee 7,495 8,626 12,509 10,143 7,446 6,233 6,419 Construction Permits 260,354 331,721 339,152 302,279 346,800 240,327 247,536 Permit Issuance 134,655 136,448 182,199 284,466 185,843 299,760 308,753 Sign Permits 24,220 27,673 40,515 28,237 27,540 18,831 19,396 Transportation Permit 8,418 10,662 11,442 10,482 10,200 9,182 9,458 Pool Drain Permits 2,446 1,623 1,099 1,462 2,040 1,555 1,602 Code Compliance Inspections 20,258 27,795 22,094 19,096 21,420 18,117 18,661 Renewals/Misc Permits 41,479 25,621 7,640 12,781 10,415 18,652 19,211 Zoning Fees 321,090 278,173 308,685 548,456 458,088 513,214 528,610 Subdivision Fees 124,596 99,592 108,956 88,133 117,300 123,085 126,778 Vacation Rental Permit 1,910,633 1,881,304 1,901,294 2,545,499 1,900,000 2,567,072 2,567,072 Vacant Building Registration 20,580 4,701 - 2,019 4,794 82 84 Sb1473 Building Stand Admin 1,263 2,595 3,366 1,500 - 540 551 Rent Control Registration 40,470 38,940 38,220 37,620 42,000 37,944 38,703 Cannabis Permit Fee 280,124 137,014 123,169 258,001 163,200 307,304 313,450 State District Access Fee 1186 23,850 23,510 22,488 21,681 - 22,564 23,015 Admin Fee - Engineering - - - 80,230 43,860 143,432 147,735 Covenant - Engineering - - - 31,396 15,300 39,708 40,502 Subtotal - Licenses and Permits 5,712,983$ 5,997,070$ 6,891,355$ 8,130,099$ 6,826,829$ 8,110,403$ 8,262,086$ Intergovernmental Grants 295,602$ 343,381$ 845,571$ 2,668,456$ 26,723,808$ 21,131,392$ 5,764,478$ State Homeowners Tax Rel.246,244 119,523 236,240 118,062 250,000 - - -18-Item 3A - Page 32 City of Palm Springs Budget for Fiscal Years 2023-24 and 2024-25 Revenue Summary - All Funds Account Description FY 2018-19 FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 FY 2023-24 FY 2024-25 ACTUALS ACTUALS ACTUALS ACTUALS REVISED DRAFT DRAFT BUDGET BUDGET BUDGET State Motor In Lieu Tax 22,899 - - - - - - Peace Off Training Funds 53,129 174,649 23,541 20,090 30,000 73,770 75,246 Mutual Aid Overtime 138,877 42,143 497,516 137,441 (88,322) 161,662 164,895 Federal Grants - - 1,386,344 9,434,478 5,410,400 - - Subtotal - Intergovernmental 756,752$ 679,695$ 2,989,212$ 12,378,527$ 32,325,887$ 21,366,825$ 6,004,619$ Charges for Services Local Dev Mitigation Fee 11,384$ (7,774)$ (24,010)$ 3,358$ 1,200$ 1,283$ 1,309$ St Highway Maintenance - - 1,800 - - - - Concessions 9,955 3,974 576 927 3,974 27,947 28,505 Assess Dist Info Gen Fund 4,102 7,500 - - 7,500 - - Smoke Detector Inspection 270,924 42,949 - - - - - Other Charges Current Services 13,179 57,006 32,668 44,785 62,158 48,806 49,782 Insurance 9,000 8,025 - 4,153 3,451 2,397 2,445 Towing Fees - - - 102,745 76,327 101,510 103,540 Multi Unit Fire Insp Fee 177,577 179,126 147,877 263,167 191,486 282,917 288,576 Shooting Range 1,936 2,458 1,749 5,546 3,207 3,885 3,963 Fingerprint Fees 1,912 3,031 (156) (52) 3,240 - - Police Contract Ot - - - 141,607 170,529 248,969 253,949 Fire Inspection Fee 74,442 81,106 13,131 193 86,702 794 810 Fire Plan Check Fee 178,662 146,277 115,343 148,979 156,370 143,064 145,926 Fire Commercial Insp Fee - 43,340 36,059 30,775 46,330 28,475 29,045 Fire Cert Program - 1,991 - 1,550 1,176 534 545 Fire Fees Misc 3,358 2,650 1,645 5,629 2,328 4,520 4,610 Dui Program - 1,551 36,378 38,824 33,139 22,365 22,812 Building Plan Check Fees 592,614 560,365 671,617 743,379 632,848 707,371 721,519 Engineering Plan Check Fees 298,892 262,077 372,255 185,879 280,160 238,545 243,316 Miscellaneous Filing Fee 292,620 401,137 535,749 296,028 428,815 246,197 251,121 Misc Engineering Fees 51,360 36,810 29,236 8,084 39,350 4,272 4,357 Inhouse Fast Plan Check Fees 2,500 - - - - - - Real Property Fees 15,222 30,218 26,963 22,256 32,303 16,678 17,012 Gen Plan Maintenance Surcharge 57,023 64,503 84,742 126,190 90,589 142,532 145,383 Planning Admin Services - - - 6,568 10,690 1,000 1,020 Administrative Service Charges 2,229,505 2,134,057 2,168,092 2,282,952 2,312,247 2,488,511 2,402,558 Parklet Fees - - - 83,152 48,105 99,807 101,803 Nuisance Abatement 29,266 18,750 32,213 - 20,044 7,818 7,974 Nuisance Abatement Admin (3,544) 5,221 1,919 - 5,581 412 420 PS USD Officer 152,764 146,802 - 87,674 156,931 189,175 192,958 Rent A Cell 49,818 45,986 45,986 46,028 49,159 49,599 50,591 Issuance Fee - 1,785 - 20,254 10,835 22,675 23,128 Tlc/Psvu Site Fees 1,542 1,295 - - 3,293 3,276 3,342 Friends Of The Library - - 3,674 28,987 13,927 27,508 28,059 Library Fees 10,570 8,676 939 6,084 5,345 7,048 7,189 Camp 52,716 105,067 60,372 93,148 54,038 116,472 118,801 Instructional Dance - 676 - - - - - Fitness 104,644 74,262 (326) 314 2,138 10 10 Youth Programs 93,476 83,614 475 53,173 89,383 28,926 29,504 Facilites Rent 234,459 200,545 101,830 143,510 214,383 159,998 163,198 Special Activities 956,320 943,514 941,547 996,870 320,700 673,433 686,902 Location Permits 25,938 15,660 23,925 27,202 17,104 11,001 11,221 Instructional Classes 3,656 7,346 1,027 50,709 37,415 43,840 44,716 Membership 20,722 7,785 8,002 16,277 11,438 10,586 10,797 -19-Item 3A - Page 33 City of Palm Springs Budget for Fiscal Years 2023-24 and 2024-25 Revenue Summary - All Funds Account Description FY 2018-19 FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 FY 2023-24 FY 2024-25 ACTUALS ACTUALS ACTUALS ACTUALS REVISED DRAFT DRAFT BUDGET BUDGET BUDGET Baseball Stadium Rent 119,029 111,789 144,228 151,329 120,797 136,498 139,228 Microfilming Fees 35,551 31,975 32,031 43,794 35,268 42,369 43,216 Rancho Park Ii Landscape 9,348 9,348 9,348 9,348 9,993 - - Desert Dorado Landscape - - - - - 9,534 9,725 Daily Admissions 52,285 42,964 51,800 58,991 45,929 39,535 40,326 Group Lessons 3,339 432 337 1,323 3,207 2,420 2,469 Private Lessons 316 - - - - - - Pool Rental Group 18,287 49,033 7,215 19,987 21,380 29,779 30,375 Pool Passes 47,312 40,673 102,321 92,227 80,175 53,170 54,234 Coin Lockers 1,317 - - - - - - Tournaments - 657 - - - - - Banner Hanging 11,302 6,555 1,642 9,711 7,500 3,097 3,159 TRACT 27,898 29,754 8,405 - 5,861 13,537 13,808 Henry Frank Parking 3,420 3,012 192 3,264 - 4,354 4,441 Villagefest 457,452 346,116 2,233 182,235 150,000 165,900 169,218 Subtotal - Charges for Services 6,815,368$ 6,401,665$ 5,833,046$ 6,689,111$ 6,216,048$ 6,714,351$ 6,712,915$ Fines & Penalties False Alarm Fee 334,394$ 314,774$ 128,223$ 164,456$ 140,000$ 160,689$ 163,903$ Alarm Permits - - 153,999 (0) 170,518 133,219 135,883 Vehicle Code Fines 107,055 82,819 105,631 75,860 82,819 74,255 75,740 Criminal Code Fines 31,397 13,928 24,154 34,889 35,490 2,893 2,951 Parking Violations 138,428 115,428 23,076 112,016 98,200 114,460 116,750 Late Charges 446 - - - - - - Library Fines and Fees 10,375 7,128 371 6,175 7,100 6,762 6,897 Administrative Citations 474,762 202,798 228,805 196,863 202,798 235,612 240,324 Parking Violation Admin 1,992 1,823 160 (95) - - - Subtotal - Charges for Services 1,098,849$ 738,699$ 664,419$ 590,165$ 736,925$ 727,890$ 742,447$ Use of Money Interest Income 853,388$ 650,476$ (246,860)$ (184,916)$ 500,000$ 3,552,748$ 3,623,803$ Unrealized Gain Or Loss 563,545 834,855 (1,169,988) (1,859,181) - - - Building/Facilities Rent 144,003 181,930 121,176 200,960 213,800 255,086 260,188 Village Green Rental 31,442 25,676 23,586 24,233 26,693 26,588 27,119 Subtotal - Use of Money 1,592,378$ 1,692,938$ (1,272,086)$ (1,818,904)$ 740,493$ 3,834,422$ 3,911,111$ Miscellaneous Revenue Walk of Stars 70,000$ 181,700$ 45,000$ 99,300$ -$ 194,471$ 198,360$ Plaza Theater Donations - - 150,269 15,825 - - - Penalty/Interest Deliq Taxes 170,426 141,565 205 - - - - Waste Disposal Clearing 22,631 25,309 117,434 (73,026) 126,127 22,992 23,452 Audit Recovery 1,997 1,243 2,711 685 1,243 7,680 7,833 Contrib Non-Govt Sources 295,053 380,394 301,387 5,039 100 9,036 9,217 Legal Fee Reimbursement 50,000 275 - 22,000 275 88,036 89,796 Smip 2,040 1,064 1,163 1,721 - 1,680 1,714 Smip Ii - - 306 788 - 3,119 3,182 Miscellaneous Revenue 418,781 351,289 111,139 71,643 - 114,943 117,242 Cashier Over (92) (19) (43) (112) - 62 63 -20-Item 3A - Page 34 City of Palm Springs Budget for Fiscal Years 2023-24 and 2024-25 Revenue Summary - All Funds Account Description FY 2018-19 FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 FY 2023-24 FY 2024-25 ACTUALS ACTUALS ACTUALS ACTUALS REVISED DRAFT DRAFT BUDGET BUDGET BUDGET Damage Recovery 47,028 20,321 26,330 1,834 - - - Settlement Revenue 10,000 39,428 36,795 53,671 - 10,200 10,404 Contributions-Non Govt 93,426 - - 5,740,000 - - - Restricted Donations - - 23,638 375,466 225,000 297,142 303,085 Rent - Master Lease 979,308 1,209,167 1,207,065 (1,570) 1,208,116 1,232,278 1,256,924 Reimbursement - 29,390 2,377 37,436 - 36,363 37,090 Electrical Reimbursement 3,223 1,937 - - - - - Low/Mod Housing Residual - 6 - - - - - All Other RDA Residual 114,750 - - - - - - Cannabis Odor Recovery - - - 11,283 - 16,426 15,605 Subtotal - Miscellaneous Revenue 2,278,571$ 2,383,068$ 2,025,775$ 6,361,981$ 1,560,861$ 2,034,427$ 2,073,966$ Sale of Real Property Sale Real Or Personal Property 49,339$ 3,157$ 12,106$ 1,303,600$ -$ 7,638$ 7,791$ Subtotal - Sale of Real Property 49,339$ 3,157$ 12,106$ 1,303,600$ -$ 7,638$ 7,791$ Subtotal General Fund 142,109,092$ 114,534,530$ 132,413,920$ 185,366,468$ 188,119,436$ 199,528,555$ 191,880,247$ Budget Transfer In 1,645,346$ 9,407,209$ 11,943,084$ -$ 1,012,516$ -$ -$ Total General Fund 143,754,438$ 123,941,739$ 144,357,004$ 185,366,468$ 189,131,952$ 199,528,555$ 191,880,247$ Tbid 521,003$ 358,332$ 515,727$ 774,641$ 700,000$ 769,046$ 807,498$ TBID Vacation Rental - - - - - - - Interest Income 0 142 473 604 - - - Total Small Hotel TBID Fund 521,003$ 358,475$ 516,200$ 775,245$ 700,000$ 769,046$ 807,498$ Forfeited Assets-Federal -$ 18,720$ -$ -$ -$ -$ -$ Forfeited Assets-Riv Cnty - 35,388 - 1,738 - - - Interest Income 4,783 3,934 2,467 1,125 - 3,000 1,000 Unrealized Gain Or Loss - - (778) (1,788,849) - - - Miscellaneous Revenue 7,814 - - - - - - Total Forfeited Assets 12,596$ 58,042$ 1,689$ (1,785,986)$ -$ 3,000$ 1,000$ Sales and Use Taxes 1,160,987$ 1,087,260$ 1,186,920$ 1,420,388$ 1,125,078$ 1,400,000$ 1,451,800$ Ambulance Compliance Fees 59,972 49,156 46,592 - - - - Interest Income 23,499 29,735 17,708 10,111 - 21,140 21,140 Unrealized Gain Or Loss - - (5,573) (152,516) - - - Contributions-Non Govt - - 50,000 - - - - Total Safety Augmentation Fund 1,244,458$ 1,166,150$ 1,295,646$ 1,277,983$ 1,125,078$ 1,421,140$ 1,472,940$ TRACT - - - 15,171 - 11,137 15,000 Cashier Over - - - - - - - Budget Transfer In - - - 2,056,144 - - - Total Special Development Fund -$ -$ -$ 2,071,315$ -$ 11,137$ 15,000$ -21-Item 3A - Page 35 City of Palm Springs Budget for Fiscal Years 2023-24 and 2024-25 Revenue Summary - All Funds Account Description FY 2018-19 FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 FY 2023-24 FY 2024-25 ACTUALS ACTUALS ACTUALS ACTUALS REVISED DRAFT DRAFT BUDGET BUDGET BUDGET Csa 152 Assessment 1,443,471$ 425,132$ 299,880$ 249,623$ 459,100$ 470,400$ 300,000$ Interest Income - 568 1,629 924 - - - Total CSA 152 Fund 1,443,471$ 425,700$ 301,509$ 250,548$ 459,100$ 470,400$ 300,000$ Grants 24,003$ 19,034$ 11,956$ 91,242$ 80,457$ 29,247$ 29,247$ Community Cleanup Credit - - - 33,101 17,500 6,620 6,620 Recycling Surcharge 122,830 121,069 128,694 118,933 125,500 198,464 198,464 Interest Income 24,979 21,042 9,449 2,985 - 12,845 12,845 Unrealized Gain Or Loss - - (4,326) (44,321) - - - Budget Transfer In 500,000 - - - - 152,411 161,153 Total Recycling Fund 671,812$ 161,146$ 145,772$ 201,938$ 223,457$ 399,587$ 408,329$ In Lieu Parking Fees 2,401$ 7,200$ -$ 12,005$ -$ -$ -$ Interest Income 10,691 9,350 5,084 2,428 - 8,500 8,800 Unrealized Gain Or Loss - - (1,620) (38,443) - - - Total Parking In-Lieu CIP 13,092$ 16,551$ 3,464$ (24,010)$ -$ 8,500$ 8,800$ State Gas Tax 2107 Funds 352,636$ 317,371$ 332,253$ 311,046$ 420,916$ 420,916$ 400,000$ State Gas Tax 2107.5 Fnds 12,000 6,000 6,000 6,000 6,000 6,000 6,000 State Gas Tax 2106 Funds 181,703 153,674 153,898 166,152 189,286 189,286 189,000 State Gas Tax 2105 Funds 279,613 250,362 245,509 260,829 308,102 308,102 250,000 State Gas Tax 2103 Funds 177,376 347,776 330,592 366,142 470,329 470,329 380,000 Interest Income 14,369 15,522 14,017 8,826 - - - Unrealized Gain Or Loss - - (4,513) (129,835) - - - Reimbursement - 3,825 - - - - - Total Special Gas Tax Improvments 1,017,696$ 1,094,530$ 1,077,757$ 989,161$ 1,394,633$ 1,394,633$ 1,225,000$ Sales and Use Taxes 2,308,021$ 2,301,944$ 3,101,321$ 3,184,660$ 3,151,000$ 2,700,000$ 2,781,000$ Grants - - (516,000) 1,132,771 - - - Regional Funds CVAG 1,865,088 790,813 1,514,264 3,746,475 3,424,333 5,028,780 3,277,526 Transport Unif Mitigation Fee 22,146 (22,146) - - - - - Interest Income 92,058 44,761 16,734 28,198 - - - Interest Income-Fiscal Agent 21,540 13,141 0 - - - - Unrealized Gain Or Loss 51,043 - (7,115) (383,366) - - - Contrib Non-Govt Sources 140,266 - 247,051 189,307 408,403 150,000 150,000 Miscellaneous Revenue 338,904 - 64 4,543 - - - Budget Transfer In - 1,039,158 - - - - - Total Measure A Improvements 4,839,066$ 4,167,671$ 4,356,319$ 7,902,589$ 6,983,736$ 7,878,780$ 6,208,526$ Central Zone 88,544$ 144,795$ 196,769$ 262,644$ 33,540$ 85,000$ 85,000$ Southeast Zone - 4,731 9,964 8,498 137,848 10,000 10,000 North Zone 60,687 38,228 84,643 275,921 129,662 350,000 350,000 South Zone 3,278 3,662 12,338 50,890 - 40,000 40,000 East Zone 36,066 13,863 31,481 28,084 - 20,000 20,000 Interest Income 28,371 23,262 13,547 8,826 - 20,000 15,000 Unrealized Gain Or Loss 16,210 - (4,247) (131,845) - - - Total Drainage Fund 233,157$ 228,541$ 344,497$ 503,019$ 301,050$ 525,000$ 520,000$ -22-Item 3A - Page 36 City of Palm Springs Budget for Fiscal Years 2023-24 and 2024-25 Revenue Summary - All Funds Account Description FY 2018-19 FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 FY 2023-24 FY 2024-25 ACTUALS ACTUALS ACTUALS ACTUALS REVISED DRAFT DRAFT BUDGET BUDGET BUDGET Interest Income 4,738$ 2,537$ 1,589$ 1,990$ -$ 2,618$ 2,618$ Unrealized Gain Or Loss - - (764) (19,820) - - - 911 Emergency Response Fee 1,000,170 1,025,897 1,272,953 898,994 1,020,000 1,020,000 1,020,000 Budget Transfer In 10,000 - - - - - - Total Emergency Response Fund 1,014,909$ 1,028,434$ 1,273,778$ 881,164$ 1,020,000$ 1,022,618$ 1,022,618$ Grants 625,711$ 290,997$ 1,071,012$ 745,187$ 1,289,197$ 413,506$ 413,506$ Land Rental 490 412 450 562 - - - Budget Transfer In - - 1,000 - - 114,954 112,882 Total Community Develop Block Grant 626,201$ 291,409$ 1,072,461$ 745,749$ 1,289,197$ 528,460$ 526,388$ Grants -$ 19,280$ -$ -$ -$ 24,427$ 24,427$ Diversion Facility Fee 361,393 370,174 380,005 377,940 384,500 338,133 338,133 Interest Income 9,304 12,099 8,297 4,982 - 9,016 9,016 Unrealized Gain Or Loss - - (2,568) (72,934) - - - Contrib Non-Govt Sources 1,405 900 810 810 - - - Budget Transfer In - 140,578 354,431 364,845 Total Sustainability Fund 372,102$ 402,452$ 386,544$ 310,798$ 525,078$ 726,007$ 736,421$ Cfd 2005-1 784,829$ 837,017$ 944,365$ 1,036,116$ 983,452$ 970,000$ 970,000$ Cfd 2007-1 39,987 40,083 44,292 40,993 43,850 45,000 45,000 Interest Income 19,526 20,622 1,833 4,486 - 15,000 15,000 Unrealized Gain Or Loss - - (593) (59,368) - - - Budget Transfer In 100,000 - - - - - - Total CFD Public Safety #1 Fund 944,342$ 897,722$ 989,897$ 1,022,226$ 1,027,302$ 1,030,000$ 1,030,000$ Parkway Maint District 9 17,749$ 17,066$ 16,951$ 11,913$ 17,410$ 14,000$ 14,000$ Parkway Lighting Mnt 7 21,796 23,978 14,583 17,964 14,500 16,000 16,000 Parkway Maint Dist 10 70,730 88,058 572 79,774 143,800 80,000 80,000 Lighting Maint District 3 4,102 4,165 12,296 4,282 4,300 4,000 4,000 Parkway Maint District 6A 5,218 5,137 5,054 5,058 5,200 5,000 5,000 Parkway Maint District 6C 12,264 12,266 12,266 11,858 12,400 12,000 12,000 Pmd 10 Zone 2 53,303 76,198 1,184 30,025 - 28,000 28,000 Lighting Maint District 12 9,989 16,339 8,179 17,054 16,550 12,000 12,000 Parkway Maint District 8 21,230 21,956 20,555 23,257 21,720 21,000 21,000 Interest Income 13,948 13,121 7,577 3,154 - 7,000 7,000 Unrealized Gain Or Loss - - (2,406) (51,537) - - - Total Land/Light/Park Maintenance 230,329$ 278,284$ 96,811$ 152,803$ 235,880$ 199,000$ 199,000$ Loan Repayment 53,798$ 54,787$ -$ -$ -$ -$ -$ Traffic Signal Rehab 975,261 775,930 872,833 945,231 1,088,536 1,088,536 1,121,193 Interest Income 9,676 9,971 3,948 7,742 - 25,000 30,000 Unrealized Gain Or Loss - - (1,064) (102,074) - - - Total SB1 RMRA Road Maint Rehab 1,038,736$ 840,688$ 875,717$ 850,899$ 1,088,536$ 1,113,536$ 1,151,193$ CFD 2019-1 34,040$ -$ -$ -$ -$ -$ -$ Interest Income 85 677 217 55 - 135 200 Unrealized Gain Or Loss - - (72) (1,147) - - - -23-Item 3A - Page 37 City of Palm Springs Budget for Fiscal Years 2023-24 and 2024-25 Revenue Summary - All Funds Account Description FY 2018-19 FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 FY 2023-24 FY 2024-25 ACTUALS ACTUALS ACTUALS ACTUALS REVISED DRAFT DRAFT BUDGET BUDGET BUDGET Total CFD Canyon View 34,125$ 677$ 145$ (1,092)$ -$ 135$ 200$ Air Quality Mngmnt Fees 61,877$ 61,444$ 46,182$ 61,206$ 62,000$ 59,008$ 59,008$ Interest Income 2,568 2,404 1,383 722 - 1,710 1,710 Unrealized Gain Or Loss - - (423) (11,270) - - - Total Air Quality Management Fund 64,446$ 63,848$ 47,142$ 50,657$ 62,000$ 60,718$ 60,718$ Public Arts Fee 227,464$ 293,063$ 373,028$ 647,304$ 180,000$ 476,752$ 501,500$ Interest Income 8,184 8,095 5,502 4,287 1,000 7,711 7,711 Unrealized Gain Or Loss - - (1,712) (63,115) - - - Contrib Non-Govt Sources - 2,799 - - - - - Total Public Arts Fund 235,647$ 303,957$ 376,818$ 588,477$ 181,000$ 484,463$ 509,211$ Friends Of The Library 100$ 6,024$ -$ -$ -$ 10,000$ 15,000$ Interest Income 41,676 34,059 17,440 7,751 - 27,000 28,000 Unrealized Gain Or Loss 21,154 - (5,592) (125,179) - - - Contrib Non-Govt Sources 28,635 125 1,766 26,160 - - - Unrestricted Donations 6 16 17 85 - - - Total Library Endowment Fund 91,570$ 40,223$ 13,631$ (91,183)$ -$ 37,000$ 43,000$ Quimby Act Fees 807,973$ 577,622$ 1,033,767$ 1,256,791$ 580,000$ 580,000$ 597,401$ Interest Income 81,663 81,573 35,802 13,165 70,000 55,000 55,000 Unrealized Gain Or Loss 37,339 - (12,225) (227,082) - - - Total Quimby Act Fund 926,976$ 659,195$ 1,057,343$ 1,042,874$ 650,000$ 635,000$ 652,401$ Grants -$ 12,450$ -$ -$ -$ 2,490$ 2,490$ Towing Fees 93,568 118,630 77,004 - - 57,841 57,841 Police Contract Ot 411,570 144,100 114,021 73,375 100,000 148,613 148,613 Dui Program 2,559 32,091 10 - - 6,932 6,932 Special Activities - 730 - - - (37,536) (37,536) Interest Income 56,646 50,519 29,007 12,876 - 35,152 35,152 Unrealized Gain Or Loss 28,209 - (9,151) (207,464) - - - Contrib Non-Govt Sources 456,213 198,866 18,598 - - 134,736 140,000 Total Special Projects 1,048,766$ 557,387$ 229,490$ (121,213)$ 100,000$ 348,228$ 353,492$ Measure J Sales Tax -$ 14,829,517$ 17,770,795$ 22,202,207$ 20,352,400$ 22,520,046$ 23,405,226$ Interest Income 408,427 428,552 193,211 110,511 - 250,000 250,000 Unrealized Gain Or Loss 169,861 - (53,922) (1,776,489) - - - Contrib Non-Govt Sources 256,300 - - - - - - Reimbursement - 1,665 - - - - - Budget Transfer In 16,043,737 - - - - - - Miscellaneous Revenue - - - - - - - Total Measure J Capital Projects 16,878,326$ 15,259,734$ 17,910,084$ 20,536,230$ 20,352,400$ 22,770,046$ 23,655,226$ Technology Fee 392,753$ 445,671$ 653,994$ 827,546$ 100,000$ 100,000$ 100,000$ Grants 2,458,770 2,116,081 2,130,301 1,953,138 28,568,214 30,234,860 20,972,330 Regional Funds CVAG - - 10,701 - - - - -24-Item 3A - Page 38 City of Palm Springs Budget for Fiscal Years 2023-24 and 2024-25 Revenue Summary - All Funds Account Description FY 2018-19 FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 FY 2023-24 FY 2024-25 ACTUALS ACTUALS ACTUALS ACTUALS REVISED DRAFT DRAFT BUDGET BUDGET BUDGET Open Space - - - 500,000 - - - Traffic Signal Rehab 148,911 3,559 229,170 31,765 1,399,200 1,399,200 - City Facilities - 1,200 - - 1,399,200 1,399,200 - AQMD Solar Pv 306,862 214,638 - - - - - Hsip Cycle 7 164,894 93,323 317,514 685,017 - 928,175 - Hsip Cycle 8 163,840 160,967 154,397 52,993 - 3,524,165 391,574 Fy17 Shsp - 6,752 - - - - - Indian Reservation Road 358,210 - - - - - - Prop 1 Grt Reimbursement 803,611 - - - - - - Interest Income 213,752 285,225 123,649 50,926 - 215,000 215,000 Unrealized Gain Or Loss 81,001 - (41,836) (874,702) - - - Bogert Bridge Assessment - - 15,876 - - - - Contrib Non-Govt Sources 2,824,977 345,736 5,063 230,069 - 224,000 224,000 Miscellaneous Revenue 48,753 - 3,102 - - - - Budget Transfer In 8,375,000 6,257,329 2,612,300 2,000,000 6,500,000 2,000,000 2,000,000 Miscellaneous Revenue - 36,520,000 - - - - - Total Capital Projects Fund 16,341,333$ 46,450,481$ 6,214,231$ 5,456,752$ 37,966,614$ 40,024,600$ 23,902,904$ Interest Income -$ 1,907$ 8,582$ 8,093$ -$ -$ -$ Interest Income-Fiscal Agent 75,408 50,779 1,179 522 - - - Proceeds From 2021 LRB A - - 33,495,000 - - - - PERS / Pr Tax - - 799,028 - - - - Budget Transfer In 14,355,851 12,972,520 12,011,328 8,994,097 9,819,450 9,904,081 9,939,037 Total Debt Service Fund 14,431,259$ 13,025,206$ 46,315,115$ 9,002,712$ 9,819,450$ 9,904,081$ 9,939,037$ Interest Income -$ 144$ -$ -$ -$ -$ -$ Total A.D. 143 Debt Service -$ 144$ -$ -$ -$ -$ -$ Interest Income -$ 1,598$ -$ -$ -$ -$ -$ Total A.D. 143 Reserve -$ 1,598$ -$ -$ -$ -$ -$ Interest Income -$ 35$ -$ -$ -$ -$ -$ Total A.D. 146 Debt Service -$ 35$ -$ -$ -$ -$ -$ Interest Income -$ 539$ -$ -$ -$ -$ -$ Total A.D. 146 Reserve -$ 539$ -$ -$ -$ -$ -$ Interest Income -$ 24$ -$ -$ -$ -$ -$ Total A.D. 159 Debt Service -$ 24$ -$ -$ -$ -$ -$ Assessment District (897)$ -$ -$ -$ -$ -$ -$ Interest Income - 3 - - - - - Total A.D. 157/158 Refi (897)$ 3$ -$ -$ -$ -$ -$ Assessment District 563,845$ 563,352$ 566,383$ 568,516$ 565,628$ 565,628$ 582,598$ Interest Income - 1,533 1,589 1,807 - - - -25-Item 3A - Page 39 City of Palm Springs Budget for Fiscal Years 2023-24 and 2024-25 Revenue Summary - All Funds Account Description FY 2018-19 FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 FY 2023-24 FY 2024-25 ACTUALS ACTUALS ACTUALS ACTUALS REVISED DRAFT DRAFT BUDGET BUDGET BUDGET Interest Income-Fiscal Agent 4,938 3,721 17 83 - - - Total A.D. 2015-1 568,783$ 568,606$ 567,988$ 570,406$ 565,628$ 565,628$ 582,598$ Interest Income 426,868$ 408,980$ 228,958$ 119,061$ 320,000$ 375,000$ 395,000$ Unrealized Gain Or Loss 201,888 - (72,125) (1,869,079) - - - Customer Facility Charge 2,548,800 1,873,450 1,234,510 4,215,294 7,145,000 8,806,327 9,011,451 Total Airport Customer Facility Fund 3,177,556$ 2,282,430$ 1,391,343$ 2,465,277$ 7,465,000$ 9,181,327$ 9,406,451$ Interest Income 70,840$ 28,568$ 17,641$ 11,148$ 50,000$ 25,000$ 28,000$ Interest Income-Fiscal Agent 61,204 316,858 6,962 7,320 - - - Unrealized Gain Or Loss 25,375 - (5,420) (152,076) - - - Resident Discount Cards 9,978 - - - - - - Passenger Facility Chg - - 2,636,590 5,480,477 6,817,000 6,425,776 6,575,496 Off-Airport Rental Car 5,139,862 4,104,645 - - - - - Budget Transfer In - - 2,712,880 - - - - Total Airport Passenger Charges 5,307,259$ 4,450,071$ 5,368,652$ 5,346,869$ 6,867,000$ 6,450,776$ 6,603,496$ Multi Unit Fire Insp Fee -$ -$ -$ -$ -$ -$ -$ LIMO/EXEC/Chart - - 25,224 - - - - Interest Income 193,743 224,849 105,754 82,565 100,000 200,000 210,000 Unrealized Gain Or Loss 115,676 - (32,417) (1,237,938) - - - Cares Act Funds - 1,626,857 3,451,322 - 5,989,698 - - CRRSAA-Airport - - - - 1,100,000 4,783,916 - CRRSAA-Concession - - - - 4,800,000 - - ARPA - Airport - - - - 6,020,652 1,481,290 - Parking Violation 11,802 23,363 10,345 4,128 12,000 6,000 6,500 Parking Violation Admin 25 10 4 44 - - - Misc Revenue - Airport 43,324 40,548 146,906 264,823 139,000 69,750 60,680 Scheduled Landing Fees 2,496,566 2,069,780 2,107,977 3,388,547 3,340,000 5,910,134 6,660,726 Landing Fee Surcharge 1,505,978 1,186,601 844,474 2,082,190 1,783,000 - - Airfield Concessions 273,745 241,824 301,059 431,684 310,000 406,000 446,000 Property Rental-Non Avtn 417,062 448,310 447,740 449,188 450,000 457,315 458,415 Hangar Rental 274 - - - 30,000 32,400 34,800 Land Rental - 341 1,099,506 1,235,590 1,317,324 1,358,823 1,223,000 1,247,329 1,409,974 Leased Parking 3,814,830 3,267,861 2,680,743 5,349,941 4,704,000 6,697,064 6,797,520 Airport Use Permits 86,666 73,946 40,973 74,308 75,000 53,263 62,371 Employee Parking Permits 16,430 15,200 14,120 25,599 20,000 26,000 28,000 Term Air Comm Rentals 1,761,652 1,934,754 1,971,523 2,180,132 2,094,000 9,467,216 14,090,552 Term Non-Air Comm Rentals 1,758,053 1,457,435 946,725 1,694,156 1,741,300 9,998,816 15,437,857 Ready Return Lot 228,302 1,020,706 421,601 (198,450) 300,000 371,809 399,030 Advertising 452,593 400,539 233,048 462,691 400,000 315,951 440,000 On-Airport Rental Car 7,386,153 6,480,246 5,263,544 11,330,331 8,899,000 11,944,780 12,303,124 Off-Airport Rental Car 36,034 32,599 42,029 49,419 39,000 511,430 546,123 Airport Access Fees 80,047 54,715 57,989 51,289 45,000 60,000 70,000 Commercial Airport Fee 839,781 610,046 679,029 1,014,938 853,000 1,099,000 1,189,000 Terminal Concessions 28,480 9,858 10,219 22,934 97,200 18,600 24,725 Taxi Access Fees 655,349 667,602 335,469 1,098,328 667,000 1,195,000 1,277,000 Term Usage Hold Room Fee 952,502 869,250 921,012 1,374,922 1,034,000 3,470,605 4,512,015 Ground Transportation Ctr 207 - - - - - - Vasi Power Reimbursement 2,160 2,160 2,160 2,160 2,200 2,000 2,200 Customs Fees 329,925 259,145 228,456 449,179 349,000 336,296 303,598 -26-Item 3A - Page 40 City of Palm Springs Budget for Fiscal Years 2023-24 and 2024-25 Revenue Summary - All Funds Account Description FY 2018-19 FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 FY 2023-24 FY 2024-25 ACTUALS ACTUALS ACTUALS ACTUALS REVISED DRAFT DRAFT BUDGET BUDGET BUDGET Security Gate Passes-Id 29,367 41,804 31,178 72,245 47,000 58,050 58,985 Waste Disposal Fees 1,548 1,548 (129) - - - - Ps Air Museum Admissions 19,262 4,116 (9) - - - - Ps Air Museum Sales 8,398 1,806 270 (279) - - - Ps Air Museum Food & Bev - 8 (9) - - - - Admin In Lieu Of Catering 9,889 3,971 (9) - - - - Airport Security Act 2001 106,880 116,800 144,800 120,240 264,000 120,000 120,000 Loading Bridge Fee - - - - - 1,255,064 1,208,363 Electrical Reimbursement 155,865 128,830 66,103 125,770 130,000 129,700 141,776 Tenant Reimbursement 51,425 31,646 - - - - - Faa Chrc Fingerprint 27,557 43,023 25,721 38,235 32,000 45,000 48,000 Baggage Handling System Fees - - - - - 897,000 941,850 Citation Fees - - - - - 12,500 13,375 Staff Escort/Filming Permits - - - - - 9,640 9,640 Insurance Recoveries - - - 41,758 - - - Total Airport Fund 24,997,054$ 24,627,346$ 22,842,267$ 32,203,899$ 47,090,050$ 62,688,919$ 69,312,200$ Interest Income 183,685$ 150,431$ 85,089$ 14,873$ -$ 60,000$ 65,000$ Unrealized Gain Or Loss 84,827 - (25,311) (363,039) - - - Federal Grants 1,057,339 4,161,269 5,316,337 7,072,362 7,406,922 29,338,206 56,662,000 Budget Transfer In 2,500,000 8,330,903 12,147,780 8,229,415 4,631,078 13,423,634 41,988,000 Total Airport Capital Projects Fund 3,825,851$ 12,642,603$ 17,523,895$ 14,953,611$ 12,038,000$ 42,821,840$ 98,715,000$ Interest Income 623,897$ 697,595$ 430,904$ 230,211$ 150,000$ 580,000$ 580,000$ Unrealized Gain Or Loss 247,566 - (131,487) (3,517,279) - - - Sewer Service Charges 10,642,255 10,397,824 10,772,717 10,880,592 10,600,000 10,600,000 10,918,001 Sewer Connection Fee 947,157 608,185 1,019,845 573,704 800,000 400,000 400,000 Sewer Street Maint Chg 6,499 6,537 31,867 40,471 7,000 7,000 7,211 Septage Hauler 227,864 469,647 534,220 738,897 450,000 600,000 600,000 Miscellaneous 542,743 113,733 - - - - - Total Wastewater Treatment Plant 13,237,983$ 12,293,521$ 12,658,066$ 8,946,596$ 12,007,000$ 12,187,000$ 12,505,212$ Insurance 861,813$ 653,981$ -$ -$ -$ -$ -$ Interest Income - 9,022 32,936 22,242 - - - Interest Income-Fiscal Agent 1,279 112 2 2 - - - Tahquitz Green Fees & Crt 4,286,852 3,543,292 3,550,384 5,258,832 4,570,578 5,340,415 5,500,627 Resident Discount Cards 7,970 8,755 368 12,920 15,000 15,000 15,450 Budget Transfer In 4,011,210 1,814,000 2,588,900 1,124,000 400,000 979,451 979,219 Total Golf Course Fund 9,169,123$ 6,029,162$ 6,172,589$ 6,417,996$ 4,985,578$ 6,334,866$ 6,495,296$ Intergovermental -$ -$ -$ 60,000$ -$ -$ -$ Interest Income 90,449 77,257 38,844 12,196 - - - Unrealized Gain Or Loss 48,630 - (11,953) (224,598) - - - Damage Recovery - - - 82,961 - - - Sale Real Or Personal Property 215,895 11,367 145,803 92,984 - - - City Vehicle Replace Rent 3,242,898 3,424,100 3,562,000 4,135,044 8,367,600 5,787,839 5,984,833 Miscellaneous Mvr - - 2,000 - - - - Insurance Recoveries 7,871 - 12,059 - - - - Lease Proceeds - - - 931,589 - - - Contributed Capital - 36,140 - - - - - -27-Item 3A - Page 41 City of Palm Springs Budget for Fiscal Years 2023-24 and 2024-25 Revenue Summary - All Funds Account Description FY 2018-19 FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 FY 2023-24 FY 2024-25 ACTUALS ACTUALS ACTUALS ACTUALS REVISED DRAFT DRAFT BUDGET BUDGET BUDGET Budget Transfer In 1,500,000 435,000 - - 5,824,770 5,303,750 4,302,250 Total Fleet Services Fund 5,105,743$ 3,983,864$ 3,748,753$ 5,090,176$ 14,192,370$ 11,091,589$ 10,287,083$ Interest Income 94,429$ 65,450$ 32,761$ 16,508$ -$ -$ -$ Unrealized Gain Or Loss 39,950 - (10,243) (350,247) - - - Contrib Non-Govt Sources - - 291 497 - - - Miscellaneous Revenue - - 164 - - - - Damage Recovery - - 11,446 - - - - Customer Facility Charge 4,882,573 4,037,200 4,080,800 4,939,445 6,400,000 8,370,620 8,872,635 Budget Transfer In 125,000 120,900 104,400 5,000,000 6,817,500 4,056,500 4,051,500 Total Facility Maintenance Fund 5,141,951$ 4,223,550$ 4,219,618$ 9,606,203$ 13,217,500$ 12,427,120$ 12,924,135$ Interest Income -$ 10,350$ (289,104)$ 6,850$ -$ -$ -$ Unrealized Gain Or Loss 15,909 - - - - - - Miscellaneous Revenue 21,043 - - - - - - PERS / Pr Tax 20,682,925 23,888,154 23,228,027 25,618,896 25,892,700 30,245,455 31,657,003 Total Employee Retirement Benefits 20,719,877$ 23,898,504$ 22,938,923$ 25,625,745$ 25,892,700$ 30,245,455$ 31,657,003$ Grants -$ -$ 518,629$ -$ -$ -$ -$ Fed Emer Relief Funds - 46,534 - - - - - Insurance - - - 150 - - - Interest Income 181,120 198,146 150,183 96,731 - - - Unrealized Gain Or Loss 95,221 - (47,344) (1,470,642) - - - Settlement Revenue - - - 30,405 - - - Cares Act Funds - - 108,862 - - - - Reimbursement - - 117,844 - - - - Interfund Serv Charge Fringes 8,645,862 8,338,845 8,603,424 8,731,442 10,120,737 13,160,745 14,118,346 Risk Insurance 2,156,532 3,420,800 3,528,400 5,915,807 5,854,337 5,530,513 6,355,979 Workers Comp Ins Rev 3,752,305 4,553,927 4,896,593 4,027,061 4,200,000 4,933,569 5,067,878 Insurance Recoveries 50,702 5,000 25,400 78,020 - - - Cobra 8,190 8,608 17,752 20,474 25,000 25,000 25,751 Special Events Liab Ins 5,075 7,786 930 3,817 4,000 4,000 4,121 Pr Deductions Insurance 458,924 491,753 501,413 484,122 565,000 565,000 581,951 Pr Deductions Supp Life - - - - 3,000 3,000 3,091 Pr Deductions Std Ins 80,497 84,567 79,762 37,782 82,000 82,000 84,461 Airport Lightning 2018 Recov 132,928 - - - - - - Budget Transfer In 3,145,000 8,064,877 6,000,000 - - - - Total Risk Management Fund 18,712,355$ 25,220,843$ 24,501,847$ 17,955,169$ 20,854,074$ 24,303,827$ 26,241,578$ Interest Income 43,042$ 28,417$ 18,580$ 11,697$ -$ -$ -$ Unrealized Gain Or Loss 14,237 - (5,422) (186,989) - - - Miscellaneous Revenue 5,876 - - - - - - Retirees Contributions 133,705 144,327 138,648 162,716 160,000 160,000 164,801 OPEB Retiree Health 3,006,793 3,355,700 3,516,000 3,914,314 3,820,682 3,825,490 3,821,752 Total Retiree Health Insurance Fund 3,203,653$ 3,528,444$ 3,667,806$ 3,901,738$ 3,980,682$ 3,985,490$ 3,986,553$ Interest Income 71,194$ 65,613$ 37,246$ 19,030$ -$ 44,527$ 44,527$ Unrealized Gain Or Loss 36,948 - (11,689) (288,216) - - - Miscellaneous Revenue - - 3,964 - - - 1,774,839 -28-Item 3A - Page 42 City of Palm Springs Budget for Fiscal Years 2023-24 and 2024-25 Revenue Summary - All Funds Account Description FY 2018-19 FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 FY 2023-24 FY 2024-25 ACTUALS ACTUALS ACTUALS ACTUALS REVISED DRAFT DRAFT BUDGET BUDGET BUDGET Muni Cold Water 1,601,825 1,684,108 1,550,810 1,813,113 1,700,000 3,277,255 2,046,608 Muni Cold Water Cogen 69,052 46,930 47,844 57,579 - 88,251 88,251 Muni Electric Sales 142,299 - - - - - - Sunrise / Cold Water 283,491 279,098 242,915 253,006 230,000 318,984 318,984 Sunrise Cold Water Cogen 13,699 12,086 11,831 13,391 - 16,789 16,789 Budget Transfer In 1,283,830 - 1,174,190 - 467,500 - - Total Energy Fund 3,502,338$ 2,087,835$ 3,057,111$ 1,867,902$ 2,397,500$ 3,745,806$ 4,289,998$ Budget Transfer In -$ -$ -$ -$ 1,500,000$ -$ -$ IT Replacement Charge - - - - - 500,000 500,000 Total Equipment Replacement -$ -$ -$ -$ 1,500,000$ 500,000$ 500,000$ Rpttf 14,500$ 8,000$ 7,500$ 261,100$ 15,000$ 15,000$ 15,000$ Admin 3% 125,000 125,000 - - 250,000 250,000 250,000 Building/Facilities Rent 5,500 - - - - - - Interest Income 5,341 1,966 774 (181) - - - Unrealized Gain Or Loss - - (328) 1,175 - - - Sale Real Or Personal Property (148,281) - - - - - - Budget Transfer In - - 103,668 - - - - Total Merged #1 Cap Successor 2,060$ 134,966$ 111,614$ 262,094$ 265,000$ 265,000$ 265,000$ Interest Income 87,786$ 92,977$ 48,105$ 46,151$ -$ -$ -$ Unrealized Gain Or Loss 26,917 - (16,377) (200,911) - - - Miscellaneous Revenue 10,979 - 500 25,676 - - - Settlement Revenue 15,000 - - - - - - Sale Real Or Personal Property 15,000 - - - - - - Budget Transfer In 402,357 96,636 - - - - - Total Housing Successor 558,039$ 189,613$ 32,228$ (129,084)$ -$ -$ -$ Rpttf 3,893,142$ 3,018,196$ 2,849,756$ 2,478,144$ 5,639,262$ 2,397,792$ 2,397,792$ Interest Income - 2,506 4,795 4,837 - - - Interest Income-Fiscal Agent 10,009 10,832 72 39 - - - Unrealized Gain Or Loss 53,634 - - - - - - Gain From Loan Forgiveness - 1,139,871 - - - - - Bond Premium 176,962 173,682 173,682 173,682 - - - Budget Transfer In 1,115,000 - - - - - - Total Successor Agency Debt 5,248,747$ 4,345,087$ 3,028,305$ 2,656,702$ 5,639,262$ 2,397,792$ 2,397,792$ -29-Item 3A - Page 43 City of Palm Springs Budget for Fiscal Years 2023-24 and 2024-25 All Funds - Expenditures FY 2023-24 & FY 2024-25 -30-Item 3A - Page 44 City of Palm Springs Budget for Fiscal Years 2023-24 and 2024-25 Expenditure Summary - All Funds Department Description FY 2018-19 FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 FY 2023-24 FY 2024-25 ACTUALS ACTUALS ACTUALS ACTUALS REVISED DRAFT DRAFT BUDGET BUDGET BUDGET General Government City Council 641,135$ 572,989$ 611,097$ 688,200$ 1,649,659$ 1,705,108$ 1,729,657$ City Manager/Admin 1,483,037 1,686,890 1,669,191 1,360,076 2,030,973 1,840,706 1,929,263 City Attorney 3,324,737 998,298 793,567 1,432,208 1,947,000 1,947,315 2,005,741 City Clerk 1,238,491 1,244,737 1,112,753 1,144,532 1,554,206 1,722,753 1,815,559 Document Management 259,866 308,233 276,989 256,913 359,338 397,122 406,375 Information Tech/PSCTV 2,208,256 3,019,424 2,721,096 3,581,131 5,945,690 7,040,958 6,859,450 Human Resources 454,193 507,003 504,898 741,553 1,054,814 1,065,544 1,144,534 Finance 3,055,611 5,475,816 3,834,153 7,247,519 8,395,857 7,827,251 8,134,356 Procurement 523,170 603,256 383,639 580,086 721,735 844,987 908,571 Office of Special Programs 1,024,753 999,767 1,006,013 1,862,387 4,232,336 4,046,536 2,348,690 Code Compliance 626,650 969,347 1,119,307 1,163,880 2,503,362 2,441,269 2,530,858 Public Affairs 289,708 369,639 322,798 367,942 916,629 971,675 993,207 Appropriation for Contingency - - - - Non Departmental - - 151,555 409,422 20,619,000 12,554,730 (4,647,000) Engineering 2,642,969 2,896,186 2,628,098 4,878,911 4,535,199 4,808,445 4,772,540 Building & Code Enforcement 2,794,819 2,781,480 2,731,238 2,896,224 4,147,847 4,275,675 4,427,389 Planning Services 1,774,568 2,256,590 2,220,909 2,308,957 3,409,596 3,180,149 3,013,349 Community and Economic Development 4,599,557 2,014,881 1,870,968 1,457,329 5,808,122 3,903,136 4,029,648 Homeless Program 522,838 456,245 237,493 6,232,241 24,680,000 20,709,202 4,000,000 Rent Control 42,173 70,910 82,669 101,419 114,155 126,329 132,897 Neighborhood Development 172,167 188,507 179,658 221,911 251,738 228,993 237,369 GPSCVB 619,749 456,164 548,582 945,942 1,115,000 850,000 870,000 Visitor Information Center 5,418 4,343 - - 255,809 273,607 273,607 Tourism 2,086,504 2,042,641 1,636,474 2,014,000 2,405,443 2,403,670 2,403,670 Special Events and Contributions 255,167 542,777 12,150 495,550 1,000,000 1,000,000 1,030,001 Special Contributions 232,500 34,483 - - - - - Film Fest Sponsorship 350,000 350,000 - 350,000 350,000 350,000 360,501 Special Contributions - PS Resorts 120,846 204,954 - 200,691 225,000 225,000 231,751 Chamber of Commerce 16,607 86,382 32,267 71,348 208,304 107,200 163,920 Convention Center 2,639,874 2,594,682 2,760,638 3,304,256 2,936,859 2,941,685 3,033,197 Plaza Theater 34,233 29,891 203,716 190,533 2,166,337 1,167,776 1,173,187 Special Development Tracts 500 55,093 44,124 - - - - Library 2,400,193 2,464,050 2,225,816 2,705,428 3,258,033 3,285,750 3,447,782 Library - Welwood 235,870 64,703 20,965 149,293 189,737 194,525 197,989 Parking Structure Maintenance - - 97,840 72,850 169,145 175,622 184,360 Street Maintenance 1,654,978 1,691,775 1,387,755 1,809,946 2,687,169 2,770,456 3,390,716 Downtown Experience Maintenance 1,356,653 1,444,728 1,283,783 1,474,857 2,039,250 1,908,942 1,998,975 Street Cleaning - - 20,270 19,500 26,400 26,400 27,193 Street Lighting 860,660 888,813 928,453 1,112,928 1,276,104 1,591,833 1,667,830 Railroad Station 22,747 17,362 26,407 22,437 56,590 55,321 57,843 Parking Structure/Control 310,712 314,233 56,081 - - - - Master Lease 1,716,883 1,433,980 1,641,692 375,433 1,641,700 1,641,700 1,690,952 Subtotal - General Government 42,598,793$ 42,141,248$ 37,385,100$ 54,247,831$ 116,884,137$ 102,607,370$ 68,975,927$ Police Police Administration 26,454,610$ 30,076,000$ 28,845,693$ 34,476,801$ 39,304,584$ 39,785,473$ 40,971,462$ Jail Operations 326,565 365,384 261,359 285,761 438,741 426,046 438,533 Animal Control 444,468 442,428 329,455 375,661 562,506 496,590 518,821 Animal Shelter 1,253,874 1,139,827 989,707 1,102,768 1,157,402 1,157,402 1,192,128 Dispatch Center 1,316,276 1,490,109 1,575,452 1,819,524 2,174,752 2,473,280 2,669,099 Subtotal - Police 29,795,793$ 33,513,749$ 32,001,665$ 38,060,515$ 43,637,985$ 44,338,791$ 45,790,044$ Fire -31-Item 3A - Page 45 Expenditure Summary - All Funds Department Description FY 2018-19 FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 FY 2023-24 FY 2024-25 ACTUALS ACTUALS ACTUALS ACTUALS REVISED DRAFT DRAFT BUDGET BUDGET BUDGET Fire Administration 16,814,003$ 18,523,495$ 19,103,529$ 23,354,240$ 26,935,704$ 27,854,939$ 29,333,122$ Emergency Management 105,799 134,019 44,501 115,279 157,059 180,232 193,217 Subtotal - Fire 16,919,802$ 18,657,514$ 19,148,030$ 23,469,519$ 27,092,764$ 28,035,172$ 29,526,339$ Parks and Recreation Park Maintenance 3,729,095$ 3,726,800$ 3,005,831$ 4,137,293$ 5,819,428$ 6,166,876$ 6,260,869$ Recreation 1,840,799 2,076,406 1,716,622 2,284,650 3,806,138 4,382,444 4,756,272 Tennis and Pickleball 6,995 2,797 94,578 60,913 162,610 161,928 163,708 Skate Park 175,232 174,708 87,600 110,766 166,366 184,200 197,925 Swim Center 764,742 765,624 732,325 822,786 1,205,223 1,312,865 1,368,721 Demuth Community Center 307,455 349,894 303,167 392,188 699,731 800,622 829,374 James O Jessie DHUC 769,062 733,359 733,400 803,087 1,059,884 1,265,308 1,273,953 Village Fest 511,885 487,254 228,754 494,392 682,104 895,830 931,622 Subtotal - Parks and Recreation 8,105,265$ 8,316,842$ 6,902,278$ 9,106,075$ 13,601,484$ 15,170,072$ 15,782,444$ PERS Futre Cost Reserve -$ -$ -$ -$ 6,000,000$ 6,000,000$ 6,000,000$ Subtotal - PERS -$ -$ -$ -$ 6,000,000$ 6,000,000$ 6,000,000$ Subtotal - General Fund 97,419,653$ 102,629,353$ 95,437,073$ 124,883,940$ 207,216,369$ 196,151,405$ 166,074,754$ Transfers Budget Transfer - Out -$ 24,074,841$ 18,622,268$ 10,095,765$ 27,331,298$ 19,731,879$ 18,777,686$ Total General Fund 97,419,653 126,704,194 114,059,341 134,979,705 234,547,667 215,883,283 184,852,439 TB Small Hotel TBID 516,998$ 361,006$ 514,182$ 754,481$ 700,000$ 769,046$ 807,498$ Total TB Small Hotel TBID 516,998$ 361,006$ 514,182$ 754,481$ 700,000$ 769,046$ 807,498$ FA Fortified Assets 37,568$ 2,977$ -$ 8,207$ 239,315$ 169,046$ -$ Total FA Fortified Assets 37,568$ 2,977$ -$ 8,207$ 239,315$ 169,046$ -$ SA PD Safety Augmentation 309,838$ 398,745$ 429,259$ 473,328$ 493,557$ 533,282$ 556,866$ SA Safety Augmentation 292,695 385,578 645,796 570,065 777,531 565,334 599,095 Total Safety Augmentation Fund 602,533$ 784,323$ 1,075,055$ 1,043,392$ 1,271,088$ 1,098,616$ 1,155,961$ CSA 152 Street Cleaning 530,319$ 424,906$ 311,652$ 276,948$ 335,668$ 311,548$ 324,069$ Total CSA 152 Street Cleaning 530,319$ 424,906$ 311,652$ 276,948$ 335,668$ 311,548$ 324,069$ RF Recycling 225,062$ 404,761$ 315,001$ 457,792$ 713,619$ 399,587$ 408,329$ Total Recycling Fund 225,062$ 404,761$ 315,001$ 457,792$ 713,619$ 399,587$ 408,329$ Parking In-Lieu CIP 186$ 200$ -$ -$ -$ -$ -$ Total Parking In-Lieu CIP 186$ 200$ -$ -$ -$ -$ -$ Special Gas Tax Improvements 1,234,007$ 485,571$ 743,862$ 522,315$ 3,204,541$ 1,000,176$ 1,225,000$ -32-Item 3A - Page 46 Expenditure Summary - All Funds Department Description FY 2018-19 FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 FY 2023-24 FY 2024-25 ACTUALS ACTUALS ACTUALS ACTUALS REVISED DRAFT DRAFT BUDGET BUDGET BUDGET Total Special Gas Tax Improvements 1,234,007$ 485,571$ 743,862$ 522,315$ 3,204,541$ 1,000,176$ 1,225,000$ Measure A Improvements -$ 2,772,220$ 1,095,300$ -$ -$ Measure A Improvements 1,500 6,420 34,825 81,593 27,809 869,811 500,000 MAI Regional Measure A 1,323,752 4,410,423 1,504,065 581,321 4,122,000 5,028,780 3,277,526 MAI Local Measure A 3,763,235 743,166 2,011,993 451,370 18,098,718 3,782,663 1,938,394 Budget Transfer Out 619,500 - - - Total Measure A Improvements 5,088,486$ 7,932,229$ 4,646,183$ 1,114,284$ 22,248,527$ 9,681,254$ 5,715,920$ DF North Zone Drainage 163,375$ 168,321$ 81,521$ 48,599$ 532,764$ 276,224$ -$ DF Central Zone Drainage 8,236 4,863 18,610 5,802 577,638 136,538 - DF South Zone Drainage - 47,531 58,376 18,201 442,550 204,498 - DF East Zone Drainage - - - - 20,000 - - DF Southeast Zone Drainage 223,068 5,431 - - 50,321 - - DF Eagle Canyon Drainage - - - - 2,910 - - Total Drainage Fund 394,679$ 226,146$ 158,506$ 72,602$ 1,626,182$ 617,260$ -$ ERF Emergency Response 1,414,556$ 1,035,596$ 1,040,530$ 1,045,479$ 1,043,627$ 1,022,618$ 900,954$ Total ERF Emergency Response 1,414,556$ 1,035,596$ 1,040,530$ 1,045,479$ 1,043,627$ 1,022,618$ 900,954$ CDBG Grants 466,517$ 324,259$ 1,039,612$ 745,749$ 1,497,187$ 528,460$ 526,388$ Total CDBG Grants 466,517$ 324,259$ 1,039,612$ 745,749$ 1,497,187$ 528,460$ 526,388$ Sustainability Fund 652,100$ -$ -$ -$ -$ SF Sustainability 110,636 1,054,489 197,885 307,888 680,353 726,007 736,421 Total Sustainability Fund 762,736$ 1,054,489$ 197,885$ 307,888$ 680,353$ 726,007$ 736,421$ CFD Public Safety #1 -$ 1,200,000$ -$ -$ -$ -$ -$ CFDPS Police 278,524 312,002 317,927 314,253 598,504 369,815 376,736 CFDPS Fire 239,617 287,666 290,268 304,389 333,060 303,898 316,660 Total CFD Public Safety #1 Fund 518,141$ 1,799,668$ 608,195$ 618,642$ 931,564$ 673,713$ 693,395$ LLPM Land/Lite/Park Maintenance 158,005$ 191,681$ 172,117$ 228,187$ 509,983$ 509,983$ 500,000$ Total LLPM Land/Lite/Park Maintenance 158,005$ 191,681$ 172,117$ 228,187$ 509,983$ 509,983$ 500,000$ SB1 RMRA Road Maint Rehabilitation 64,010$ 1,623,523$ 65,153$ 28,281$ 2,247,117$ 1,097,504$ -$ Total SB1 RMRA Road Maint Rehab 64,010$ 1,623,523$ 65,153$ 28,281$ 2,247,117$ 1,097,504$ -$ CFD Canyon View -$ 5,056$ 13,046$ -$ 16,700$ -$ -$ Total CFD Canyon View -$ 5,056$ 13,046$ -$ 16,700$ -$ -$ Air Quality Management 63,725$ 41,219$ 51,694$ 66,172$ 101,929$ 61,929$ 63,788$ Total Air Quality Management 63,725$ 41,219$ 51,694$ 66,172$ 101,929$ 61,929$ 63,788$ Public Arts Fund 211,851$ 240,200$ 314,869$ 79,885$ 687,334$ 1,416,137$ 281,041$ Total Public Arts Fund 211,851$ 240,200$ 314,869$ 79,885$ 687,334$ 1,416,137$ 281,041$ Library Endowment Fund 84,768$ 102,653$ 176,671$ 88,738$ 1,801,860$ 1,716,195$ -$ Total Library Endowment Fund 84,768$ 102,653$ 176,671$ 88,738$ 1,801,860$ 1,716,195$ -$ -33-Item 3A - Page 47 Expenditure Summary - All Funds Department Description FY 2018-19 FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 FY 2023-24 FY 2024-25 ACTUALS ACTUALS ACTUALS ACTUALS REVISED DRAFT DRAFT BUDGET BUDGET BUDGET Quimby Act Fund 89,342$ 1,251,719$ 2,304,119$ 475,902$ 832,403$ 837,555$ -$ Total Quimby Act Fund 89,342$ 1,251,719$ 2,304,119$ 475,902$ 832,403$ 837,555$ -$ SP Engineering (30,830)$ 966$ -$ -$ -$ -$ -$ SP Legal Fees 83,235 24,557 2,584 - - - - SP Office of Special Projects 69,484 1,500 - - - - - SP Professional Review 49,610 5,447 9,800 - - - - SP Community Donation 300,084 73,947 49 - - - - SP Recreation 3,355 609 - - - - - SP PD Administrative 404,541 202,801 87,670 254,408 100,000 100,000 103,001 SP FD Administrative 63,464 15,219 98 - - - - Total Special Projects 942,942$ 325,046$ 100,201$ 254,408$ 100,000$ 100,000$ 103,001$ Measure J Capital Projects 3,183,763$ -$ -$ -$ -$ -$ -$ MJ Finance - - - - - - 90,000 MJ Budget Transfer Out - 8,343,940 10,550,000 1,402,832 - 3,133,700 3,133,200 MJ Measure J Capital Projects 4,091,265 3,259,126 6,906,789 2,169,464 31,930,077 25,309,545 20,925,450 MJ Measure J Downtown 280,872 845,962 543,779 599,308 404,420 650,000 400,000 MJ Measure J Streets 3,134,058 1,937,755 1,707 5,983,348 - - - MJ Community Project Hot Spots 87,590 1,341,899 755,514 13,275 3,011 3,011 3,102 MJ Measure J Airport Projects - 55,000 - - 200,000 200,000 200,000 Total Measure J Capital Projects 10,777,548$ 15,783,681$ 18,757,788$ 10,168,226$ 32,537,508$ 29,296,257$ 24,751,752$ CP Appropriation for Contingency 103,203$ -$ -$ -$ -$ -$ -$ CP Budget Transfer Out - 2,356,070 4,200,000 - 7,766 - - CP City Facility Improvements 2,774,974 2,690,564 1,209,011 1,207,812 3,342,515 2,482,204 562,994 CP Fire Improvements 310,361 36,515 290,843 191,790 543,855 - - CP Street Improvements 2,790,385 2,270,884 3,307,830 2,098,081 42,261,779 43,980,664 21,472,330 CP Land Acquisition - 36,520,000 - - - - - CP Park Improvements 175 36,482 - 2,223 3,500,000 2,000,000 - CP Administrative 102,916 154,864 60,190 24,748 3,632,100 - - CP Street Maintenance 1,529,604 3,041,955 - - - - - Total Capital Projects Fund 7,611,617$ 47,107,333$ 9,067,874$ 3,524,655$ 53,288,015$ 48,462,868$ 22,035,324$ Debt Service Fund 1,131,730$ 1,171,649$ -$ -$ -$ DSF Budget Transfer Out - 1,039,158 - - - - - DSF Cal Energy Loan - 89,342 - - - - - DSF Convention Center 4,691,094 4,690,994 4,692,669 59,589,144 4,667,900 4,667,900 4,667,893 DSF Police Building & Other 135,395 135,418 135,283 135,552 135,200 135,066 134,997 DSF Parking Structure 591,850 602,750 647,650 656,650 662,150 720,750 711,916 DSF Measure J Debt Service 3,185,963 3,185,963 37,467,516 1,375,833 3,138,500 3,131,109 3,124,859 DSF Chevron/Opterra - - 1,174,191 431,058 1,215,346 1,257,431 1,301,387 DSF Local Measure A Debt Service - 1,099,950 1,095,250 619,500 - - - DSF Pension Obligation Bond - - 1,537,386 1,594,895 1,659,915 1,689,107 1,785,392 Total Debt Service Fund 8,604,301$ 10,843,575$ 46,749,945$ 64,402,633$ 11,479,011$ 11,601,362$ 11,726,443$ A.D. 143 Debt Service -$ 17,063$ -$ -$ -$ -$ -$ Total A.D. 143 Debt Service -$ 17,063$ -$ -$ -$ -$ -$ A.D. 146 Debt Service -$ 3,914$ -$ -$ -$ -$ -$ Total A.D. 146 Debt Service -$ 3,914$ -$ -$ -$ -$ -$ A.D. 159 Debt Service -$ 2,887$ -$ -$ -$ -$ -$ -34-Item 3A - Page 48 Expenditure Summary - All Funds Department Description FY 2018-19 FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 FY 2023-24 FY 2024-25 ACTUALS ACTUALS ACTUALS ACTUALS REVISED DRAFT DRAFT BUDGET BUDGET BUDGET Total A.D. 159 Debt Service -$ 2,887$ -$ -$ -$ -$ -$ A.D. 2015-1 5,136$ -$ -$ -$ -$ -$ -$ A.D. 2015-1 561,467 559,338 549,849 554,147 567,628 565,028 562,831 Total A.D. 2015-1 566,603$ 559,338$ 549,849$ 554,147$ 567,628$ 565,028$ 562,831$ -$ -$ -$ -$ -$ -$ 2,500,000$ Airport Customer Facility Fund 99,841 99,841 99,841 100,956 3,123,265 10,600,000 500,000 Total Airport Customer Facility Fund 99,841$ 99,841$ 99,841$ 100,956$ 3,123,265$ 10,600,000$ 3,000,000$ Airport Passenger Charges Fund 250,122$ 9,330$ -$ -$ -$ -$ -$ APC Series 2008 Debt Service 335,044 319,651 - - - - - APC Series 2019 Debt Service - 1,278,787 756,289 682,498 2,521,000 9,001,977 27,507,761 APC PFC Funds 151,707 5,233,800 12,163,646 8,243,678 - - - Total Airport Passenger Charges Fund 736,872$ 6,841,567$ 12,919,936$ 8,926,176$ 2,521,000$ 9,001,977$ 27,507,761$ Airport Fund 2,787,500$ -$ -$ -$ -$ -$ -$ AF Budget Transfer Out - 3,447,947 - - 5,385,828 6,983,634 14,488,000 AF Administration 7,546,757 4,693,872 3,986,813 (29,497) 6,573,372 7,989,477 8,847,224 AF Airport IT - - - - 210,000 784,616 682,047 AF Law Enforcement 2,348,146 2,776,294 2,825,144 2,704,992 3,138,357 3,147,313 3,229,436 AF Security - - - - - 1,695,917 1,813,039 AF Airside Operations 846,403 1,844,219 1,660,134 1,469,874 1,068,180 5,287,385 5,454,221 AF Rescue - Fire 3,419,063 3,497,785 3,815,758 3,443,024 4,227,107 4,880,731 5,041,960 AF Landside Operations 1,342,763 1,320,747 1,131,673 1,489,331 1,538,049 2,178,178 2,759,661 AF Grounds Maintenance 583,933 539,687 405,867 598,965 662,081 686,823 639,147 AF Terminal Building Ops 5,539,830 6,902,349 6,579,342 7,069,586 7,060,112 8,189,673 10,605,447 AF Passenger Boarding Bridges - - - - 999 120,000 120,000 AF Baggage Handling System - - - - 722,979 897,000 900,000 AF Control Center Ops 3,499,068 3,737,818 3,422,265 3,448,554 4,229,679 4,159,042 4,101,807 AF Customs 215,092 203,876 250,562 333,013 276,528 336,296 303,996 AF Planning and Projects - - - 1,521 - 688,881 669,444 Total Airport Fund 28,128,554$ 28,964,593$ 24,077,558$ 20,529,363$ 35,093,271$ 48,024,966$ 59,655,427$ Airport Capital Projects -$ -$ 50,907$ -$ -$ -$ -$ ACPF Airport Capital Projects 3,244,359 2,657,499 6,434,547 (1,658,565) 4,902,975 13,407,794 39,488,000 ACPF Grants 114,349 - 399,486 1,072,383 10,235,503 29,338,206 56,662,000 ACPF PFC Funds 48,797 - - 4,344,823 1,982,840 - - Total Airport Capital Projects Fund 3,407,505$ 2,657,499$ 6,884,940$ 3,758,641$ 17,121,319$ 42,746,000$ 96,150,000$ WWTP Wastewater 9,601,345$ 8,801,886$ 8,940,635$ 10,403,200$ 27,239,524$ 21,518,635$ 16,118,925$ Total Wastewater Treatment Plant 9,601,345$ 8,801,886$ 8,940,635$ 10,403,200$ 27,239,524$ 21,518,635$ 16,118,925$ GCF Operations & Maint 4,948,156$ 5,188,033$ 4,786,834$ 5,373,751$ 5,630,928$ 6,334,866$ 6,495,296$ Total Golf Course Fund 4,948,156$ 5,188,033$ 4,786,834$ 5,373,751$ 5,630,928$ 6,334,866$ 6,495,296$ FL Fleet 3,955,838$ 4,240,818$ 4,109,745$ 6,316,555$ 12,546,115$ 16,151,315$ 11,097,933$ Total Fleet Services Fund 3,955,838$ 4,240,818$ 4,109,745$ 6,316,555$ 12,546,115$ 16,151,315$ 11,097,933$ FM Facilities Maintenance 4,398,370$ 4,704,885$ 4,195,366$ 1,458,836$ 13,877,643$ 18,982,721$ 13,872,635$ Total Facility Maintenance Fund 4,398,370$ 4,704,885$ 4,195,366$ 1,458,836$ 13,877,643$ 18,982,721$ 13,872,635$ -35-Item 3A - Page 49 Expenditure Summary - All Funds Department Description FY 2018-19 FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 FY 2023-24 FY 2024-25 ACTUALS ACTUALS ACTUALS ACTUALS REVISED DRAFT DRAFT BUDGET BUDGET BUDGET Employee Retirement Benefits 19,474,230$ 22,037,804$ 23,378,993$ 24,489,450$ 25,894,000$ 30,245,455$ 31,657,003$ Total Employee Retirement Benefits 19,474,230$ 22,037,804$ 23,378,993$ 24,489,450$ 25,894,000$ 30,245,455$ 31,657,003$ RM Employee Benefits 8,977,838$ 9,292,164$ 8,968,465$ 9,307,594$ 10,669,188$ 13,160,745$ 14,118,346$ RM Workers Compensation 4,389,789 2,354,402 5,095,065 5,585,437 4,545,070 4,933,569 5,067,878 RM Liability Insurance 3,092,132 3,625,964 6,582,093 2,664,374 4,254,337 4,212,480 4,675,345 RM Property Insurance 521,216 914,337 1,187,260 896,335 1,100,000 1,318,033 1,680,634 RM Emergency Disaster - 361,454 375,294 - - - - RM Unemployment 27,407 23,314 132,240 21,855 486,277 486,277 500,867 RM Emergency Management - 189,989 418,075 - - - - Total Risk Management Fund 17,008,383$ 16,761,623$ 22,758,491$ 18,475,596$ 21,054,872$ 24,111,104$ 26,043,070$ Retiree Health Insurance 5,855,576$ 3,059,780$ 3,308,320$ 3,335,131$ 4,105,059$ 3,985,490$ 3,986,553$ Total Retiree Health Insurance 5,855,576$ 3,059,780$ 3,308,320$ 3,335,131$ 4,105,059$ 3,985,490$ 3,986,553$ EF Energy Administration 525,993$ 529,059$ 705,549$ 684,579$ 198,155$ 793,096$ 910,506$ EF Sunrise Plaza COGEN 983,138 638,404 484,157 319,594 431,142 519,011 529,426 EF Municipal Complex 1,851,318 1,585,926 1,500,156 1,458,342 2,237,700 2,183,699 2,600,065 EF Energy Development (93,583) - 66 69,831 - 250,000 250,000 Total Energy Fund 3,266,866$ 2,753,389$ 2,689,929$ 2,532,345$ 2,866,997$ 3,745,806$ 4,289,998$ Hardware Replacement -$ -$ -$ -$ 1,000,000$ 1,000,000$ 500,000$ Total Equipment Replacement Fund 3,266,866$ -$ -$ -$ 1,000,000$ 1,000,000$ 500,000$ MCS Merged Community & Econ Devel 786,716$ 235,629$ 265,771$ 218,145$ 381,833$ 355,449$ 367,154$ Total Energy Fund 786,716$ 235,629$ 265,771$ 218,145$ 381,833$ 355,449$ 367,154$ Housing Successor (34,148)$ (68)$ -$ -$ -$ -$ -$ Housing Successor 243,345 313,193 145,251 403,922 3,282,659 387,867 305,106 Total Housing Successor 209,197$ 313,125$ 145,251$ 403,922$ 3,282,659$ 387,867$ 305,106$ Successor Agency Debt 1,115,000$ -$ -$ -$ -$ -$ -$ Successor Agency Debt 1,546,611 - - - - Successor Agency Debt 559,821 1,327,604 1,424,019 1,336,834 2,446,600 2,400,300 2,376,600 Total Successor Agency Debt 3,221,432$ 1,327,604$ 1,424,019$ 1,336,834$ 2,446,600$ 2,400,300$ 2,376,600$ -36-Item 3A - Page 50 City of Palm Springs Budget for Fiscal Years 2023-24 and 2024-25 Interfund Transfers FY 2023-24 & FY 2024-25 -37-Item 3A - Page 51 City of Palm Springs Budget for Fiscal Years 2023-24 and 2024-25 FY2023-24 FY2023-24 Budget Budget TRANSFERS TRANSFERS IN OUT GENERAL FUND (100) To Debt Service Fund (301) Police Building and Others - 134,800 Parking Structure - 715,250 Opterra - 1,257,431 Convention Center - 4,662,900 To Recycling Fund (125)- 152,411 To Community Development Block Grant Fund (137)- 114,954 To Sustainability Fund (138)- 354,431 To Fleet Vehicle Fund (510)- 5,303,750 To Facilities Maintenance Fund (520)- 4,056,500 To Capital Projects Fund (261)- 2,000,000 To Golf Course Fund (430)- 979,451 Sub Total General Fund - 19,731,878 RECYCLING FUND (125) From General Fund (100)152,411 - COMMUNITY DEVELOPMENT BLOCK GRANT FUND (137) From General Fund (100)114,954 SUSTAINABILITY FUND (138) From General Fund (100)354,431 - MEASURE J CAPITAL (260) To Debt Service Fund (301)- 3,133,700 CAPITAL PROJECTS FUND (261) From General Fund (100)2,000,000 - DEBT SERVICE FUND (301) From General Fund (100)6,770,381 - From Measure J Capital Fund (260)3,133,700 - AIRPORT PASSENGER CHARGES FUND (410) To Airport Special Projects Fund (416)6,440,000 AIRPORT GENERAL OPERATIONS FUND (415) To Airport Special Projects Fund (416)6,983,634 AIRPORT SPECIAL PROJECTS FUND (416) From Airport Passenger Charges Fund (410)6,440,000 From Airport General Operations Fund (415)6,983,634 GOLF COURSE FUND (430) From General Fund (100)979,451 - MOTOR VEHICLE FUND (510) From General Fund (100)5,303,750 - FACILITIES MAINTENANCE FUND (520) From General Fund (100)4,056,500 - TOTAL 36,289,212$ 36,289,212$ 38 Item 3A - Page 52 City of Palm Springs Budget for Fiscal Years 2023-24 and 2024-25 FY2024-25 FY2024-25 Budget Budget TRANSFERS TRANSFERS IN OUT GENERAL FUND (100) To Debt Service Fund (301) Police Building and Others - 134,700 Parking Structure - 706,250 Opterra - 1,301,387 Convention Center - 4,663,500 To Recycling Fund (125)- 161,153 To Community Development Block Grant Fund (137)112,882 To Sustainability Fund (138)- 364,844 To Fleet Vehicle Fund (510)- 4,302,250 To Facilities Maintenance Fund (520)- 4,051,500 To Capital Projects Fund (261)- 2,000,000 To Golf Course Fund (430)- 979,219 Sub Total General Fund - 18,777,686 RECYCLING FUND (125) From General Fund (100)161,153 - COMMUNITY DEVELOPMENT BLOCK GRANT FUND (137) From General Fund (100)112,882 SUSTAINABILITY FUND (138) From General Fund (100)364,844 - MEASURE J CAPITAL (260) To Debt Service Fund (301)- 3,133,200 CAPITAL PROJECTS FUND (261) From General Fund (100)2,000,000 - DEBT SERVICE FUND (301) From General Fund (100)6,805,837 - From Measure J Capital Fund (260)3,133,200 - AIRPORT CUSTOMER FACILITY FUND (405) To Airport Special Projects Fund (416)2,500,000 AIRPORT PASSENGER CHARGES FUND (410) To Airport Special Projects Fund (416)25,000,000 AIRPORT GENERAL OPERATIONS FUND (415) To Airport Special Projects Fund (416)14,488,000 AIRPORT SPECIAL PROJECTS FUND (416) From Customer Facility Fund (405)2,500,000 From Airport Passenger Charges Fund (410)25,000,000 From Airport General Operations Fund (415)14,488,000 GOLF COURSE FUND (430) From General Fund (100)979,219 - MOTOR VEHICLE FUND (510) From General Fund (100)4,302,250 - FACILITIES MAINTENANCE FUND (520) From General Fund (100)4,051,500 - TOTAL 63,898,886$ 63,898,886$ -39-Item 3A - Page 53 City of Palm Springs Budget for Fiscal Years 2023-24 and 2024-25 Additional Supporting Data FY 2023-24 & FY 2024-25 -40-Item 3A - Page 54 City of Palm Springs Budget for Fiscal Years 2023-24 and 2024-25 Additional Information and Metrics Airport 18% City Council 1% Community & Economic Development 1% Development Services 7% Executive Management 1% Fire 14% Fleet 1% General Government 15%Library 2% Maintenance & Facilities 3% Parks & Recreation 8% Police 25% Public Works 4% Full-Time Equivalent by Area - FY24 Airport 22% City Council 1% Community & Economic Development 1% Development Services 6% Executive Management 1%Fire 13% Fleet 1% General Government 14% Library 3% Maintenance & Facilities 3% Parks & Recreation 8% Police 23% Public Works 4% Full-Time Equivalent by Area - FY25 $- $10,000 $20,000 $30,000 $40,000 $50,000 $60,000 $70,000 FY2018-19 FY2019-20 FY2020-21 FY2021-22 FY2022-23 FY2023-24 FY2024-25ThousandsExpense Category Trend FY19-FY25 General Government Police Fire Parks and Recreation PERS Future Cost Reserve 8% 7% 10% 12% *CAGR % *CompoundAnnual Growth Rate Indian Canyon/Union Pacific RR Bridge 6% Ramon Bridge Widening 21% Vista Chino Bridge 4% South Palm Canyon Bridge 6% East Palm Canyon Bridge 5%Main Library Remodel 4% Wastewater Treatment 9% Local Road Safety Plan 3% Relocate Fire Station 1 8% Annual Pavement Rehabilitation 10% Misc Projects 24% FY24/FY25 Capital Projects Engineering 0% Measure J Capital Projects 29% Measure A Capital Projects 1% Improvements 2106 Fund 2% Regional Measuer A 6% Local Measure A 3%Drainage 0% City Facility Improvements 1% Street Improvements 44% Wastewater 14% Fire Improvements 0% FY24/FY25 Capital Projects -41-Item 3A - Page 55 City of Palm Springs Budget for Fiscal Years 2023-24 and 2024-25 Additional Information and Metrics Continued Airport Funds Capital Funds Debt Service Fund Enterprise Funds (excl. Airport) General Fund Internal Service Funds Library Public Arts Special Revenue Funds Special Revenue Funds (Emergency Services) Sustainability Special Revenue - Capital Funds $(50) $- $50 $100 $150 $200 $250 MillionsFunds By Average Fund Balance & Average Projected Revenues - FY24 & FY25 Average Budgeted Revenues FY24 & FY25 Airport Funds Capital Funds Debt Service Fund Enterprise Funds (excl. Airport) General Fund Internal Service Funds Library Public Arts Special Revenue Funds Special Revenue Funds (Emergency Services) Sustainability Special Revenue -Capital Funds $(50) $- $50 $100 $150 $200 $250 MillionsFunds By Average Fund Balance & Average Budgeted Expenditures in FY24 & FY25 Average Budgeted Expenditures FY24 & FY25Globe size indicates size of fund types Globe size indicates size of fund types -42-Item 3A - Page 56 ATTACHMENT 2 Item 3A - Page 11 CITY COUNCIL STAFF REPORT DATE: MAY 8, 2023 STUDY SESSION SUBJECT: GENERAL FUND, CAPITAL, AND AIRPORT DRAFT BUDGET FOR FISCAL YEARS 2023-24 AND 2024-25 FROM: Scott C. Stiles, City Manager BY: Department of Finance and Treasury Department of Engineering Department of Aviation SUMMARY: This item represents a review of the estimated fiscal year 2022-23 General Fund revenues and expenditures and a preliminary overview of the fiscal year 2023-24 and fiscal year 2024-25 General Fund Budget, Capital Plan Update, and Palm Springs International Airport Budget. RECOMMENDATION: Provide direction to staff on any changes to the draft fiscal year 2023-24 and draft fiscal year 2024-25 budgets. STAFF ANALYSIS: In Table 1 on the following page, a forecast of the current fiscal year General Fund revenue and expenditures is provided, along with a preliminary overview of General Fund budgeted revenue and expenditures for FY 2023-24 and FY 2024-25. Following Table 1, each fiscal year’s revenue and expense highlights are outlined to provide additional detail. Item 3A - Page 57 City Council Staff Report May 8, 2023 -- Page 2 Study Session FY 2023-24 & FY 2024-25 Draft Budget GENERAL FUND TABLE 1 General Fund Revenue Highlights for Fiscal Year 2022-23 The General Fund is expected to end fiscal year 2022-23 with total revenue at $186.4 million, a 1% increase, or $1.1 million, over fiscal year 2021-22. This increase is largely due to the following:  Property Tax growth of 5.5%, or 1.5 million  Sales and Use Tax growth of 6.6%, or $2 million  Utility Users Tax growth of 14%, or $2.2 million  Transient Occupancy Tax (TOT) is expected to be down from fiscal year 2021-22 approximately $3.5 million, or 6.5%. FY 22 was the strongest year in history with revenue at $53.9 million. Recent trends in TOT indicate the City will meet the FY23 forecast of around $50 million which would be the second highest year historically. FY2022-23 FY2023-24 FY2024-25 Forecast Draft Budget Draft Budget Total Revenue 186,446,205$ 199,578,555$ 187,930,247$ Transient Occupancy Tax 49,919,475 48,921,085 51,122,534 Property Taxes 30,407,637 31,015,768 31,636,084 Sales and Use Taxes 33,912,338 33,811,056 35,061,718 Utility Users Tax 17,835,699 20,801,918 24,056,277 Motor Vehicle in Lieu tax 6,435,921 6,564,639 6,695,932 Franchise Fees 4,584,399 4,676,087 4,769,609 Cannabis Tax 3,606,427 3,426,106 3,254,801 All Other Sources 28,558,244 29,230,503 29,568,814 Grant Revenue 9,936,066 21,131,392 1,764,478 Transfers From Other Funds 1,250,000 - - Total Expense 177,713,131$ 216,353,547$ 184,108,827$ General Government 52,781,254 63,186,418 67,582,115 Police 42,017,426 43,380,779 44,723,596 Fire 24,836,102 27,992,314 29,478,509 Parks and Recreation 10,846,125 15,086,625 15,782,444 PERS Future Cost Reserve 6,000,000 6,000,000 6,000,000 Transfers 27,331,298 19,731,879 18,777,686 Set Aside Items 3,964,860 19,844,140 - Grant Expense 9,936,066 21,131,392 1,764,478 Surplus/(Deficit)8,733,074$ (16,774,992)$ 3,821,419$ Item 3A - Page 58 --------------------------------------------------------------- City Council Staff Report May 8, 2023 -- Page 3 Study Session FY 2023-24 & FY 2024-25 Draft Budget General Fund Expense Highlights for Fiscal Year 2022-23 The General Fund is expected to end the fiscal year with total expenditures of $177.7 million, approximately $42 million over fiscal year 2021-22. The increase is largely due to the following:  An increase of $17.2 million in transfers to other funds. The largest increases were to the Fleet Vehicle Fund ($6 million) and the Facilities Maintenance Fund ($7 million). The increases were to provide extra funding for purchases and projects that had been postponed due to the COVID-19 pandemic.  The Council approved approximately $24 million in “set-asides” in the fiscal year 2022-23 budget. $4 million is expected to be spent in this fiscal year with the remaining funds to be distributed in fiscal years 2023-24 and 2024-25.  Grant expense is expected to be approximately $10 million in fiscal year 2022-23, an increase over fiscal year 2021-22 of approximately $8.7 million. The funds are being used for expenses related to homelessness. General Fund Budgetary Highlights Fiscal Years 2023-24 & FY 2024-25 Revenue The City’s method of projecting revenues is a combination of observing historical trend of the City’s revenue data and tracking at a monthly level the current fiscal year. In addition to this, the City works with financial consultants who gather business data on a great number of businesses Citywide and regionally. They issue City-specific forecasts which we incorporate into the revenue projections. Below are budgetary revenue highlights for FY 2023-24 and FY 2024-25:  Transient Occupancy Taxes (TOT) is projected to remain strong in FY 2023-24 at $48.9 million and $51.1 million in FY 2024-25. The hospitality industry in Palm Springs remains very robust particularly among the hotel category which is 69.4% of revenues.  Property Taxes have seen secular growth of 2% year-over-year. The City is planning on this trend to continue in FY 2023-24 and FY 2024-25.  Sales and Use Taxes have seen historical fluctuations in recent years due to the pandemic-induced recession. The City is planning for a pause in Sales and Use Tax growth in FY 2023-24 and continued growth in FY 2024-25 of 3.7%.  Utility Users Tax (UUT) has seen rapid year-over-year growth in recent years. The City is expecting for this growth to remain elevated which has come primarily from the electric sector. The growth rate for Utility Users Tax is forecasted to be 16.6% in FY 2023-24 and 15.6% in FY 2024-25 in our consultant analysts’ forecast. Item 3A - Page 59 City Council Staff Report May 8, 2023 -- Page 4 Study Session FY 2023-24 & FY 2024-25 Draft Budget Expenditures The Finance and Treasury team works to understand the business of each department and their needs where it relates to financial planning and analysis. The team also meets with the Budget Committee comprised of the Assistant and Deputy City Managers, Finance Director, Budget Manager, and is headed by the City Manager. This committee collaboratively works to address the needs of each department to remain highly effective in their areas for the greatest impact on the lives of every resident of the City. The Finance team also works to understand how the expenditures unfold throughout the course of the current fiscal year and how that will impact the future needs of the department in the coming fiscal years. Expenditure budgetary highlights are detailed below:  Full-Time Equivalent (FTE) positions for non-public safety City staff in FY 2023-24 is planned to grow by 8, or approximately $1.1 million dollars annually. For FY 2024-25, Full-Time Equivalent positions is expected to grow by 11, or approximately $1.3 million annually.  The Police Department is planning to add 2 dispatchers in FY2023-24 and 2 dispatchers in FY2024-25 or $243,000 and $249,000 annually respectively. In addition, the Department will be implementing a new Computer Aided Dispatch/Records Management System over the next 2 years at a cost of $2.75 million funded by the Measure J Fund.  The Fire Department plans to add 3 Firefighter/EMT’s in FY2023-24 for a cost of $551,000 annually.  The creation of a Chief Economic Development Officer position at the Deputy Director level to drive new development opportunities and support business initiatives.  In the City’s Capital Plan (shown below within the Measure J Fund), there is approximately $7 million budgeted to aid in the renovation of the Library. The Library received a grant in FY 2022-23 for approximately $6.5 million and, in total, the City has $13.5 million for Library renovation that will be completed over the next two fiscal years. The Measure J Commission will have further discussions to potentially fund additional Phase 1 improvements.  The City remains committed to improving the lives of its residents through its affordable housing initiative. Previously, the City Council approved to set aside $10 million for Affordable Housing. On April 27, 2023, the City Council approved additional funding in the amount of $3 million for the Aloe Palm Canyon project, leaving a balance of approximately $7 million in the set-aside funds which the City has plans to disburse in the fiscal year 2023-24 and fiscal year 2024-25 budgets. Item 3A - Page 60 City Council Staff Report May 8, 2023 -- Page 5 Study Session FY 2023-24 & FY 2024-25 Draft Budget  Along with the affordable housing initiative, providing resources to the vulnerable homeless population that calls Palm Springs home has been a top priority of the City. The City intends to construct a permanent Navigation Center to temporarily house some of the City’s unhoused population. The City will be funding the construction and some of the operations with grant funds from the State. Prior to the completion of the permanent Navigation Center, the City continues to pursue additional opportunities for temporary and emergency shelter needs.  In addition to the Navigation Center, the City is budgeting the remaining set aside funds of $900,000 ($4 million originally approved by Council in FY 23) to address further needs related to the homeless population such as cool & warm centers and encampment cleanup.  The City has been proactively working to engage residents on becoming more sustainable and reducing the carbon footprint of the City in an impactful way. After the success of the City’s first turf conversion program, the City will build on this success by deepening the program with help from Desert Water Authority. The program will feature $400,000 for dwellings, $500,000 for Homeowner Associations, and $250,000 for low-income property owners.  To meet upcoming CARB requirements, the City will begin transitioning its fleet replacements to EV-only. The City is planning a multi-year project targeted at electrical upgrades and the installation of 25 charging stations with a cost of $470,000 for the infrastructure (realized in FY 2023-24) and approximately $30,000 in ongoing expenses. This is in conjunction with the plan of using $450,000 of the climate set-aside funding on electric system design and upgrade work in support of this initiative.  Keeping the City’s main thoroughfares open and in safe working order is top of mind for the City. Throughout 2022, main roads have closed 38 times for an average of 76 days in total, with an estimated annual servicing cost of $81,000. The City is planning for the purchase of an industrial grade motor grader to reduce the time taken to clear away the roads with a cost of $500,000 and annual servicing costs of $47,000.  For Fiscal Year 2024-25, the City is planning to create a rapid response street repair team to address troubled spots throughout the City for increased readiness and safer road conditions through the ability to hot-patch street areas for longer lasting repairs. Part of this is to acquire two industrial vehicles: hot patching and arrowboard trucks for a cost of $275,000. CAPITAL BUDGET AND PROJECT UPDATE Many different revenue sources support the City’s Capital Projects. The City receives an allocation of Gas taxes from the State that supports many transportation projects such as Item 3A - Page 61 City Council Staff Report May 8, 2023 -- Page 6 Study Session FY 2023-24 & FY 2024-25 Draft Budget street and traffic signal improvements. Additionally, the City has imposed two local sales taxes, Measure A at ½% and Measure J at 1% taxes. The Measure A tax is restricted also to street improvements, but Measure J can be used for any general use. It should be noted that while Measure J funds can be used for anything, it has been the City’s practice to use these funds for various Capital needs, including those needs in public safety. The City also will charge impact fees on new developments within the City. These fees are restricted for Drainage construction and Parks and Recreation. The City also receives funding from the California Department of Transportation and Coachella Valley Association of Governments to assist in large local and regional transportation projects. Due to the many distinct types of sources, the City’s Capital Revenue can fluctuate significantly from year to year. This is usually due to the types of projects under construction and the amount of reimbursable revenue that is received. In fiscal year 2023- 24, the City expects to receive $71.8 million in Capital funding, but in fiscal year 2024-25, the revenue drops $55.3 million. The Capital plan includes budgeted expenditures in fiscal year 2023-24 of $83.8 million and in fiscal year 2024-25 of $49.2 million. The expenditures are related to various Capital projects that are managed by the City Engineer and the Engineering Department. Additional information on some of those projects is provided below, following Table 2. Table 2 below represents the FY 2023-24 and FY 2024-25 budgeted revenue and expenditures for all of the funds that support the City’s Capital Projects. TABLE 2 Fund Beg Fund Balance Revenue Transfer In Expenditures Transfer Out Ending Fund Balance Use of Funds Gas Tax 2,453,548 1,394,633 - 1,000,176 - 2,848,005 Streets Measure A 8,491,377 7,878,780 - 9,007,381 - 7,362,776 Streets Drainage 2,349,965 525,000 - 617,260 - 2,257,705 Drainage RMRA 2,132,861 1,113,536 - - - 3,246,397 Transportation Quimby 3,799,942 635,000 - 837,555 - 3,597,387 Parks and Rec Measure J 35,964,245 22,770,046 - 25,916,976 3,133,700 29,683,615 General Capital Fund 24,250,634 37,524,600 2,000,000 46,422,868 - 17,352,366 Various Total 79,442,572 71,841,595 2,000,000 83,802,216 3,133,700 66,348,251 Fund Beg Fund Balance Revenue Transfer In Expenditures Transfer Out Ending Fund Balance Use of Funds Gas Tax 2,848,005 1,225,000 - 1,225,000 - 2,848,005 Streets Measure A 7,362,776 6,208,526 - 5,715,920 - 7,855,382 Streets Drainage 2,257,705 520,000 - - - 2,777,705 Drainage RMRA 3,246,397 1,151,193 - - - 4,397,590 Transportation Quimby 3,597,387 652,401 - - - 4,249,788 Parks and Rec Measure J 29,683,615 23,655,226 - 20,218,552 3,133,200 29,987,089 General Capital Fund 17,352,366 21,902,904 2,000,000 21,995,324 - 19,259,946 Various Total 66,348,251 55,315,250 2,000,000 49,154,796 3,133,200 71,375,505 **NOTE THAT ANY CAPITAL FOR THE AIRPORT OR WASTEWATER PLANT WILL GET FUNDED OUT OF THEIR OWN FUND Fiscal Year 2023-24 Captal Budget Fiscal Year 2024-25 Captal Budget Item 3A - Page 62 City Council Staff Report May 8, 2023 -- Page 7 Study Session FY 2023-24 & FY 2024-25 Draft Budget Five-Year Capital Improvement Program California Government Code Section 65403 and the Administration Element of the City’s General Plan requires that the City Council review and adopt a Capital Improvement Program (CIP). Staff developed the comprehensive Five-Year CIP by evaluating proposed capital projects to determine the estimated cost, funding source, and for prioritization within the next 5 years. The objectives of the Five-Year CIP are:  Promote sound financial planning in the implementation of capital projects.  Identify and forecast funding needs and sources to maximize federal, state, regional, and local funding sources.  Implement projects that meet the community and City Council goals.  Complete capital improvements in a timely and systematic manner. The Five-Year CIP will be reviewed annually, during which time the City's needs may be re-prioritized and the City's financial status may be re-evaluated. Cost for capital projects over the last few years have increased. It has been evident that estimates for projects have not kept up with current increased costs. As such, a determination was made to increase the estimated budget requests for most projects by thirty percent (30%). The thirty percent increase may not be sufficient for all projects and Staff will have to adjust with City Council approval at the time of project award. Measure “J” Recommended Projects In 2011, Palm Springs voters approved Measure J, a dedicated local revenue measure in the form of a one percent (1%) local sales tax increase to maintain local community services and economically revitalize Downtown Palm Springs and generate a revenue stream for local capital projects. Measure J was effective on April 1, 2012, and sunsets on March 31, 2037. At the April 20, 2023, Measure “J” Commission meeting, Staff presented a draft of the current projects funded by Measure “J” within the Five-Year CIP. Staff indicated to the Commission that they did not intend to add any additional projects and wanted to fund only those projects already contained within last year's Five-Year CIP. Parks Set-Aside The City Council set aside $3 million for parks projects in the FY 22-23 budget. On April 27, 2023, the City Council approved a cooperative purchase agreement in the amount of $1.3 million for the purchase and installation of playground equipment and shade structures at Demuth and Victoria Parks. The following is a breakdown of the plan to use the remaining $1.7 million. Item 3A - Page 63 City Council Staff Report May 8, 2023 -- Page 8 Study Session FY 2023-24 & FY 2024-25 Draft Budget  $750,000 – Swim Center Locker Rooms/ ADA Ramp/Fence Installation. Supplemental funding towards the existing Measure J funded project.  $100,000 – Interactive Water Play Design Consultant.  $850,000 – Playground Equipment and Shade Structure Installation for Ruth Hardy and Baristo Parks. Current Projects in FY 2021-22 Staff is actively working on or assisting with initiation of over 70 Capital Projects. Over the five years of the CIP the estimated value of the projects is over $370,000,000. All of the projects were presented in last year’s 5-Year CIP with the exception the Rim Road evaluation project to be re-introduced this year. The following is the list of projects completed in FY 2022-23 and of projects that are currently under construction or in design: Completed Projects in FY 2022-23  15-32 HSIP Cycle 7-17 Traffic Signal Upgrades (minor items pending)  16-19 Flashing Beacon and Dynamic Message Sign (Part of HSIP 8)  17-07 North Palm Canyon Traffic Signal Project (minor items pending)  19-14 Demuth Community Center Air Conditioning Project  19-19 City Yard Roof Replacement  19-34 Airport Passenger Boarding Bridgers  20-27 Pavilion Center Acoustic Upgrades  20-30 Demuth and Desert Highlands Park Restrooms  21-02 2022 Slurry City Project  21-22 Desert Highland Ball Park Improvements  21-32 Swim Center Shade Structures  $6.9 Million Annual Pavement Rehabilitation Project  22-23 Traffic Calming Projects  Community Initiated - Measure J Funded – Visitor Center Uplighting Projects in Construction FY 2022-23 thru FY 2023-24  01-11 – Indian Canyon Bridge over UPRR ($44 million)  16-18 – HSIP Cycle 8 – 14 Traffic Signal Upgrades  18-04 – Plaza Theater Renovation  18-18 – Bogert Trail Lift Station  18-20 – Skylight Railing Project  19-15 – Storm Drain Line 20  19-28 – Recreational Field Lighting Upgrades  19-36 – Traffic Management Center and Signal Timing Optimization Item 3A - Page 64 City Council Staff Report May 8, 2023 -- Page 9 Study Session FY 2023-24 & FY 2024-25 Draft Budget  20-19 – Desert Highland (Rosa Parks/Indian) Traffic Signal  20-33 – San Rafael at Avenida Caballeros Traffic Signal  21-12 – Pedestrian Traffic Signal (HAWK) at Racquet Club  21-17 – Arnico Tract Sewer  22-05 – Navigation Center  Annual Paving Project ($9 million)  Annual Slurry Project ($2 million)  WWTP Digester Number 2 and Gas Flare ($16 million)  WWTP 11- Sludge Drying Bed Rehabilitation Projects in Design FY 2022-23 thru FY 2023-24  Five (5) Federally Funded Bridge Projects including Vista Chino Bridge  16-08 – Library Retrofit and Renovation Project  18-05 – HSIP Cycle 9 - 9 Traffic Signal Upgrades  19-24 – Demuth Park ADA Access  20-03 – Palm Canyon/Indian Canyon Roundabout  21-16 – Demuth Dog Parks  Pedestrian Master Plan – 1 to 5 of the 37 Projects  Annual Traffic Calming  Swim Center Upgrades  Rim Road Widening Studies  22-24 Pickleball Courts PALM SPRINGS INTERNATIONAL AIRPORT The Palm Springs International Airport is both owned and operated by the City, setting it apart from regional airports owned by distinct government entities. The City bears full responsibility for managing all expenses and revenues related to the Airport, which operates as a self-sustaining enterprise. The funds associated with the Airport's operations and maintenance are separated into four distinct categories comprising of the Airport Operations Fund, the Customer Facility Charge, Passenger Facility Charge, and Airport Capital Projects. Airport Operations Fund In Table 3 on the following page, a forecast of the current fiscal year Airport Fund revenue and expenditures is provided, along with a preliminary overview of Airport Fund budgeted revenue and expenditures for FY 2023-24 and FY 2024-25. Following Table 3, each fiscal year’s revenue and expense highlights are outlined to provide additional detail. Item 3A - Page 65 City Council Staff Report May 8, 2023 -- Page 10 Study Session FY 2023-24 & FY 2024-25 Draft Budget TABLE 3 Airport Operations Fund Revenues It is estimated that the Airport Operations Fund revenues for FY 2022-23 will surpass the Revised Budget by approximately $6.5 million. This significant increase in revenue can be attributed to a rise in airline operations and passenger traffic. Approximately $16.7 million is non-operating revenues from the COVID-19 relief funds, while $27.5 million is non-airline revenues and the remaining $9.6 million is from airline revenues. The resulting incremental revenue increases are highlighted below.  Airport Rental Car Fees are expected to increase by $3.4 million, an increase of 38%.  Public Parking Fees are expected to increase by $1.4 million, an increase of 30%.  Airline Fees are expected to increase by $1.4 million, an increase of 17%. FY2022-23 FY2023-24 FY2024-25 Forecast Draft Budget Draft Budget Total Revenue 53,623,663$ 62,488,919$ 69,102,200$ Airline Revenue 9,665,025 21,000,019 27,413,506 Non-Airline Revenue 27,256,648 35,223,694 41,688,694 Grant Revenue 16,701,990 6,265,206 - Total Expense 33,894,665$ 48,781,691$ 60,405,427$ Administration 5,212,996 7,990,385 8,847,224 Information Technology 420,000 784,777 682,047 Law Enforcement 3,053,885 3,147,659 3,229,436 Aviation Security - 1,696,241 1,813,039 Airside Operations 1,309,963 5,288,984 5,454,221 Rescue-Fire 3,681,436 4,881,146 5,041,960 Landside Operations 1,699,475 2,178,178 2,759,661 Ground Maintenance 664,899 686,823 639,147 Terminal Building Operations 7,788,259 8,191,023 10,605,447 Passenger Boarding Bridges 13,759 120,000 120,000 Baggage Handling System 299,493 897,000 900,000 Control Center Operations 3,330,431 4,160,405 4,101,807 Customs 284,240 336,296 303,996 Planning and Projects - 689,140 669,444 PERS Future Cost Reserve 750,000 750,000 750,000 Transfer Out 5,385,828 6,983,634 14,488,000 Surplus/(Deficit)19,728,998$ 13,707,229$ 8,696,773$ Item 3A - Page 66 City Council Staff Report May 8, 2023 -- Page 11 Study Session FY 2023-24 & FY 2024-25 Draft Budget Airport Operations Fund Expenditures It is estimated that the Airport Operations Fund expenditures in FY 2022-23 are projected to decrease from FY 2022-23 Revised Budget by approximately $1.2 million due to a reduction in personnel expenses due to vacancies. Airport Operations Unassigned Fund Balance The Airport Operations Fund ended FY 2021-22 with a Total Fund Balance of $16.1 million; FY 2022-23 is expected to have a $19.7 million surplus and a Total Fund Balance of $36.5 million. The Unassigned Fund Balance for FY 2022-23 is projected at $32.8 million, and the CalPERS Reserve Set-Aside is projected to have an ending balance of $3.75 million. Other Airport Funds Aside from the Airport General Operations Fund (Fund 415), the Airport operates three other funds, namely the Customer Facility Charge (CFC) Fund (Fund 405), the Passenger Facility Charge (PFC) Fund (Fund 410), and the Capital Projects Fund (Fund 416). Both Fund 405 and 410 are categorized as restricted funds, with Fund 405 collecting a customer facility fee on rental cars for the purpose of funding a future $150.0 million capital project that aims to design and construct a new consolidated rental car facility. On January 27, 2022, City Council adopted a resolution authorizing the conversion of the collection fee for the $10.00 per transaction CFC to a $9.00 per day CFC (maximum 5- day limit). The new collection rate started on March 1, 2022. Meanwhile, Fund 410 collects the passenger facility charge of $4.50, net $4.39 to the Airport after a deduction of $0.11 for the airline. The funds are constrained to Federal Administration Agency (FAA) approved Airport projects. To finance the construction of the Airport Terminal Improvements, the City Council authorized the issuance of Airport Revenue Bonds amounting to approximately $22.2 million in 2019, which were partially used to fund the Airport Ticket Wing Expansion project. Interest on the bonds is payable semiannually on June 1 and December 1 of each year until maturity or earlier redemption. The principal is paid annually. Fund 416 is the Airport’s Capital Projects Fund, receiving around $4.1 million annually in Airport Capital Improvement Program and approximately $5.1 million annually in Bipartisan Infrastructure Law grants financed by the FAA. Fund 416 also receives a transfer from the Airport Fund 415 to support local non-FAA funded capital projects. Item 3A - Page 67 City Council Staff Report May 8, 2023 -- Page 12 Study Session FY 2023-24 & FY 2024-25 Draft Budget Proposed Airport Budget for Fiscal Years 2023-24 & 2024-25 Airport Fund Revenues and Expenditures Total Operating revenues for FY 2023-24 are budgeted at $62.4 million, an increase of $15.4 million (33%) over the FY 2022-23 Revised Budget. The revenue reflects three sources: 1) Airline revenue of $21.0 million, 2) Non ‐Airline revenue of $35.2 million, and 3) Non-operating grant revenue of $6.2 million. Airline revenue is derived primarily from landing fees, BHS fees, joint use fees, loading bridge fees, per use fees, and terminal rentals. Non‐Airline revenue comprises public parking and ground transportation fees, terminal and other concessions, rental car fees, ground rents, and other operating revenues. Non-operating revenue consist of COVID-19 relief funds. FY 2024-25 Operating revenues are budgeted at $69.1 million, an increase of $6.6 million (11%), of which $27.4 million represents Airline revenue, and $41.8 million is from Non ‐Airline revenue.  FY 2023-24 Airline revenue includes an increase of $16.7 million (203%) compared to the FY 2023 Budget. This result is driven primarily from the new Airline Use and Lease Agreement where the Airport switched from a residual rate- based methodology to a hybrid methodology.  FY 2023-24 Non‐Airline revenue projects a net increase of $4.9 million (10%) from the FY 2022-23 Revised Budget. The increases are primarily driven by 1) increases of $3.0 million in rental car revenue reflecting an increase in transactions per deplanement (arrivals); 2) $8.1 million in concessions revenue reflecting revenue budget based on gross sales with the new revenue share for the retail and food and beverage concessions; and 3) an increase of $2.0 million in parking revenue due to higher transactions and rates.  FY 2024-25 Airline revenue is budgeted to increase by $26.2 million (5%) compared to FY 2023-24. This increase is primarily higher operating and maintenance expenses, new positions, and the Capital Projects contribution.  FY 2024-25 Non‐Airline revenue is budgeted to increase by $12.0 million (11%) compared to FY 2023-24. The increase is driven by an increase in enplanements (departures) reflecting increases of $5.4 million in concessions revenue, and $400,000 in rental car revenue. Total Operating expenditures for FY 2023-24 are budgeted at $48.0 million, which address the Airport’s overall strategies, initiatives, and mandated obligations, and reflect an increase of $13.6 million (40%) in the FY 2023-24 operating expense budget from the Item 3A - Page 68 City Council Staff Report May 8, 2023 -- Page 13 Study Session FY 2023-24 & FY 2024-25 Draft Budget FY 2022-23 Revised Budget. In addition, FY 2024-25 operating expenses are projected to increase by $4.1 million (10%) over the FY 2023-24 Budget. The FY 2023-24 Operating expenditures increase of $13.6 million (40%) is driven by several factors. First, salaries and wages, including overtime and benefits, are projected to increase by $3.5 million (25%) over the FY 2022-23 Revised Budget, reflecting 22 new positions and increases due to wage and salary increases required under union contract agreements.  In FY 2023-24, contractual services are budgeted to have a net increase of $4.9 million (115%) from the FY 2022-23 Budget, reflecting an increase in airfield, terminal, and landside services.  FY 2023-24 utility costs increased by $600,000 (36%), and safety and security costs increased by $1.7 million (4.6%).  FY 2023-24 other department costs are projected to increase by $67,000 (2%), reflecting IT replacement, administrative services, facilities maintenance services, vehicle maintenance, and safety admin overhead.  FY 2023-24 marketing and advertising costs increased by $552,000 (27%). FY 2024-25 Operating Expenditures are budgeted to increase by $4.1 million (10%); this increase reflects the hiring of 27 new positions, and wage and salary increases required under union contract agreements. In addition, the non‐personnel expenses increase is primarily driven by contractual services and materials and supplies costs. Additionally, there is no COVID federal relief in FY 2024-25 compared to the $6.2 million that was in the FY 2023-24 budget. Customer Facility Charge (CFC) Revenues and Expenditures The CFC Revenues budget for FY 2023-24 is $8.8 million, as shown in Table 4 on the following page. This represents a $1.0 million (13%) increase from the FY 2022-23 Estimated Actual. In FY 2024-25, CFC Revenues are projected at $9.0 million, an increase of $200,000 (2%) over the FY 2023-24 budget.  Revenues increased due to higher enplanements (departures) The CFC Expenditures budget for FY 2023-24 is $10.6 million primarily due to the acquisition of property and the temporary relocation of the car rental counters for the baggage claim expansion. In FY 2024-25, CFC Expenditures are projected at $3.0 million, due to the planning and design of the future consolidated rental car facility. There is a Item 3A - Page 69 City Council Staff Report May 8, 2023 -- Page 14 Study Session FY 2023-24 & FY 2024-25 Draft Budget transfer out of $2.5 million to Airport Capital projects to fund the car rental counter relocation. TABLE 4 Passenger Facility Charge (PFC) Revenues and Expenditures As shown in Table 5 below, PFC Revenues budget for FY 2023-24 is $6.4 million, an increase of $600,000 (11%) from the Estimated Actual. In FY 2024-25, PFC Revenues are projected at $6.5 million and increase of (2%).  Revenues increased due to higher enplanements (departures) The PFC Expenditures budget for FY 2023-24 is $2.5 million for the 2019 Passenger Facility bond debt service and a transfer of $6.4 million to fund 416 for the airports Capital Projects; the south checked baggage inspection system building expansion. In FY 2024- 25, PFC Expenditures are $2.5 million in debt service and a $25.0 million to fund 416 for the airports Capital Projects. The transfer from fund 416 is to help fund the expansion project. The airport intends to submit a PFC application #3 to the Federal Aviation Administration to impose and use approximately $31 million of PFC funds to complete the terminal expansion project. TABLE 5 FY2022-23 FY2023-24 FY2024-25 Forecast Draft Budget Draft Budget Total Revenue 7,850,000$ 8,806,327$ 9,011,451$ Customer Facility Charges 7,850,000 8,806,327 9,011,451 Total Expense -$ 10,600,000$ 3,000,000$ Rental Car Improvement - 10,600,000 500,000 Transfer Out - - 2,500,000 Surplus/(Deficit)7,850,000$ (1,793,673)$ 6,011,451$ FY2022-23 FY2023-24 FY2024-25 Forecast Draft Budget Draft Budget Total Revenue 5,781,000$ 6,425,776$ 6,575,496$ Passenger Facility Charges 5,781,000 6,425,776 6,575,496 Total Expense 2,521,000$ 9,001,977$ 27,507,761$ Loan Principal & Interest 2,521,000 2,561,977 2,507,761 Transfer Out - 6,440,000 25,000,000 Surplus/(Deficit)3,260,000$ (2,576,201)$ (20,932,265)$ Item 3A - Page 70 City Council Staff Report May 8, 2023 -- Page 15 Study Session FY 2023-24 & FY 2024-25 Draft Budget Airport Capital Projects Fund The Airport Capital Projects fund is for the Airports various capital projects (see Table 6 below). The Airport maintains a five-year Capital Program that is intended to address critical improvements. The Capital Program includes capital improvement projects that address federal security requirements, airfield safety, environmental remediation, terminal upgrades, and development. The Airport has 16 projects anticipated for FY 2023- 24 totaling $42.7 million and 17 projects for FY 2024-25 totaling $96.1 million. The Airport anticipates receiving $29.3 million from the FAA through the Airport Improvement Program (AIP), Bipartisan Infrastructure Law or other federal grants to fund capital projects. TABLE 6 In-Progress Projects for FY 2022-23 1. Taxiway Rehabilitation Design 2. Taxiway Hot Spot Study 3. Wildlife Hazard Assessment 4. Airport Common Use & Carpet Renovation 5. Gate 16 Taxiway Repair 6. Two Trash Compactors 7. Airport Master Plan Proposed Projects for FY 2023-24 1. Telehandler/Forklift 2. Parking Revenue System 3. Verbiage Message Signage - Digital 4. Property Acquisition 5. Lot A, Economy Lot Parking, Employee Lot (W of El Cielo) - (Design) 6. Electric Charging Station Infrastructure - Chargers acquisition 7. Solid Separator 8. Procure Landside Vehicles 9. Paint Striping Truck 10. Wi-Fi Consultant (Design) FY2022-23 FY2023-24 FY2024-25 Forecast Draft Budget Draft Budget Total Revenue 12,792,750$ 42,761,840$ 96,150,000$ Grant Revenue 7,406,922 29,338,206 56,662,000 Transfer In 5,385,828 13,423,634 39,488,000 Total Expense 17,121,319$ 42,746,000$ 96,150,000$ Capital Projects 17,121,319 42,746,000 96,150,000 Surplus/(Deficit)(4,328,569)$ 15,840$ -$ Item 3A - Page 71 City Council Staff Report May 8, 2023 -- Page 16 Study Session FY 2023-24 & FY 2024-25 Draft Budget 11. Wi-Fi Installation (Construct) 12. Restroom Capacity & ADA Renovations (Construct) 13. South Checked Baggage Inspection System (CBIS) Building Facility Expansion - (Design) 14. Baggage Claim (Design) 15. Shade Area - Phase 1 16. Carpet Replacement - Main terminal lobby and security check point Proposed Projects for FY 2024-25 1. Consolidated Rental Car Facility (Design) 2. Procure two Zero Emissions Buses 3. Economy Lot (Construct) - Phase 1 4. Lot A (Construct) 5. Airfield W & A1 - (Construct - Phase 1) 6. Federal Inspection Station - (Design) & New Terminal Expansion 7. Remain Over Night (RON) Parking Spaces 8. Procure ARFF Truck - Fire Dept 9. Airfield 31L/13R Rehabilitation & Airfield Connector - (Design) 10. Arrivals Bag Claim Renovation/Expansion - (Construct) 11. Outbound BHS Inline System Replacement - (Construct) 12. BHS - Terminal Building Expansion (Construct) 13. Economy Lot (Construct) - Phase 2 14. HVAC Infrastructure Replacement 15. Conveyance Replacement 16. Main Terminal Façade Restoration (Design) 17. Automated Exit Lanes ALIGNMENT WITH STRATEGIC PLANNING: This item aligns with City Council priority of Good Governance. FISCAL IMPACT: Provide direction to Staff on any changes to the Preliminary FY 2023-24 and FY 2024- 25 budgets. REVIEWED BY: Budget Manager: Andrew Neri Acting Director of Finance: Kristopher J. Mooney City Engineer: Joel Montalvo Airport Administration Manager: Victoria A. Carpenter Executive Director of Aviation: Harry Barrett Jr., A.A.E. City Manager: Scott Stiles Item 3A - Page 72 City Council Staff Report May 8, 2023 -- Page 17 Study Session FY 2023-24 & FY 2024-25 Draft Budget ATTACHMENTS: 1. Budget in Brief 2. Capital Schedule 3. Airport Budget Item 3A - Page 73 ATTACHMENT 3 Item 3A - Page 12 CAPITAL PROJECTS SCHEDULE Project # Fund STRING NAME TOTAL BUDGET Carryforward + FY23 Budget REMAINING BALANCE (NET OF ENC.) 2024 DETAIL AMOUNT 2025 DETAIL AMOUNT 2026 DETAIL AMOUNT 2027 DETAIL AMOUNT 2028 DETAIL AMOUNT TOTAL UNENC. FUNDING 01-11 261 INDIAN UPRR CONSTRUCTION 35,023,422.92$ 30,252,990.92$ 3,674,505.18$ 2,385,216.00$ 2,385,216.00$ -$ -$ 8,444,937.18$ 01-11 261 INDIAN UPRR RIGHT-OF-WAY 31,366 31,366 5,956 - - - - 5,956 01-11 134 INDIAN UPRR - CONSTRUCTION 3,576,353 3,362,413 3,131,555 213,940 - - - 3,345,495 01-11 134 INDIAN CANYON I-10 SEWER 8,069 8,069 7,428 - - - - 7,428 01-11 134 INDIAN UPRR - RIGHT-OF-WAY (638) (638) (5,439) - - - - (5,439) 01-11 134 INDIAN UPRR CONSTRUCTION 7,145,080 6,503,260 372,446 641,820 - - - 1,014,266 01-11 134 INDIAN UPRR-RIGHT-OF-WAY 25,520 25,520 11,127 - - - - 11,127 01-11 420 SEWER EXTENSION - INDIAN UPRR 12,993,311 9,993,311 1,907,970 3,000,000 - - - 4,907,970 06-18 261 SOUTH PALM CANYON BRIDGE 6,582,010 5,063,084 4,974,680 1,518,925 - - - 6,493,606 06-18 133 SOUTH PALM CANYON BRIDGE 325,762 250,586 250,078 75,176 - - - 325,253 06-18 134 SOUTH PALM CANYON BRIDGE 868,642 668,186 667,804 200,456 - - - 868,260 08-25 261 RAMON BRIDGE-CAT CITY 2,008 2,008 156 - - - - 156 08-25 261 RAMON BRIDGE-CON 38,466,241 130,595 93,909 12,778,549 12,778,549 12,778,549 - 38,429,556 08-25 261 RAMON RD BRIDGE-CAT CITY 19,192 19,192 19,192 - - - - 19,192 08-25 261 RAMON BRIDGE-ROW 174,257 174,257 86,561 - - - - 86,561 08-25 134 RAMON BRIDGE WIDENING-LOC CON 1,258,230 100,000 95,842 386,077 386,077 386,077 - 1,254,072 08-25 134 RAMON BRIDGE WIDENING-LOC ROW 126,663 126,663 123,254 - - - - 123,254 08-25 134 RAMON BRIDGE WIDENING-REG CON 8,686,724 - (3,565) 2,895,575 2,895,575 2,895,575 - 8,683,159 08-25 134 RAMON BRIDGE WIDENING-REG ROW 236,676 236,676 220,916 - - - - 220,916 10-10 261 VISTA CHINO BRIDGE-CAT CITY 21,211 21,211 21,211 - - - - 21,211 10-10 261 VISTA CHINO BRIDGE CAT CITY 27,572 27,572 27,572 - - - - 27,572 10-10 261 VISTA CHINO BRIDGE WW WASH 82,191,875 6,666,933 6,665,028 3,930,732 3,930,732 33,831,739 33,831,739 82,189,970 10-10 261 VISTA CHINO BRIDGE WW WASH 2,515,969 2,515,969 468,276 - - - - 468,276 10-10 261 VISTA CHINO BRIDGE WW WASH 749,227 749,227 671,016 - - 671,016 10-10 134 VISTA CHINO BRIDGE-LOCAL 2,278,954 - - 127,317 127,317 1,012,160 1,012,160 2,278,954 10-10 134 VISTA CHINO BRIDGE-LOCAL 2,637 2,637 96 - - 96 10-10 134 VISTA CHINO BRIDGE WW WASH 437,045 437,045 370,659 - - - - 370,659 10-10 134 VISTA CHINO BRIDGE-REGIONAL 7,621,341 282,549 282,364 381,951 381,951 3,287,445 3,287,445 7,621,156 10-10 134 VISTA CHINO BRIDGE-REGIONAL 27,020 27,020 19,427 - - 19,427 10-10 134 VISTA CHINO BRIDGE WW WASH 413,269 413,269 214,294 - - - - 214,294 12-02 261 S PALM CYN TAHQUITZ CREEK 12,671,759 7,989,363 7,914,803 4,682,396 - - - 12,597,199 12-02 134 S PALM CYN TAHQUITZ CREEK 354,028 202,365 200,238 151,663 - - - 351,902 12-02 134 S PALM CYN TAHQUITZ CREEK 116,664 116,664 116,082 - - - - 116,082 12-02 134 S PALM CYN TAHQUITZ CREEK 1,060,080 605,089 596,989 454,991 - - - 1,051,980 12-04 261 EPC PALM CYN WASH BRIDGE 8,375,455 1,640,446 1,530,428 6,735,009 - - - 8,265,437 12-04 134 EPC PALM CYN WASH BRIDGE 306,503 88,355 79,527 218,148 - - - 297,675 12-04 134 EPC PALM CYN WASH BRIDGE 41,723 41,723 38,606 - - - - 38,606 12-04 134 EPC PALM CYN WASH BRIDGE 797,955 143,512 107,940 654,443 - - - 762,383 16-08 261 MAIN LIBRARY REMODEL 7,060,050 4,138,650 4,138,650 2,921,400 - - - 7,060,050 16-08 260 MAIN LIBRARY REMODEL 8,060,050 4,138,650 4,138,339 2,921,400 1,000,000 - - 8,059,739 16-18 261 HSIP CYCLE 8 TRAFFIC SIGNALS 2,744,934 2,744,934 2,718,454 - - - - 2,718,454 16-18 261 HSIP CYCLE 8 TRAFFIC SIGNALS 64,271 64,271 (9,122) - - - - (9,122) 16-18 142 HSIP CYCLE 8 TRAFFIC SIGNALS 1,206,407 1,206,407 1,206,407 - - - - 1,206,407 18-04 100 PLAZA THEATER IMPROVEMENTS 1,000,000 1,000,000 84,935 - - - - 84,935 18-04 261 PLAZA THEATER IMPROVEMENTS 4,524 4,524 4,524 - - - - 4,524 18-05 261 CYCLE 9 TRAFFIC SIGNAL IMPRV 1,652,941 1,420,705 1,394,562 232,236 - - - 1,626,798 18-06 260 VICTORIA RTHHRDY RESTROOMS 1,586,000 1,220,000 1,220,000 366,000 1,586,000 18-09 260 FIRE TRAINING FACILITY 1,495,000 1,150,000 1,150,000 345,000 1,495,000 18-10 260 DOWNTOWN SFTY BOLLARD PH2 1,441,375 - - 0 650,000 791,375 - 1,441,375 18-14 134 GENE AUTRY WIND WALL 30,895 30,895 15,434 15,434 18-14 134 GENE AUTRY WIND WALL 2,626,000 2,020,000 2,004,445 606,000 2,610,445 18-17 261 POLICE DEPT IMPOUND BLDG 754,000 - - 754,000 - - - 754,000 18-17 260 Police Impound Meas J 754,000 - - 754,000 - - - 754,000 18-20 261 SKYLIGHT RAILINGS 854,656 854,656 787,470 - - - - 787,470 19-15 261 STORM DRAIN LINE 20 10,528,000 7,520,000 7,520,000 3,008,000 - - - 10,528,000 19-15 135 STORM DRAIN LINE 20 966,784 690,560 657,084 276,224 - - - 933,308 Item 3A - Page 77 CAPITAL PROJECTS SCHEDULE Project # Fund STRING NAME TOTAL BUDGET Carryforward + FY23 Budget REMAINING BALANCE (NET OF ENC.) 2024 DETAIL AMOUNT 2025 DETAIL AMOUNT 2026 DETAIL AMOUNT 2027 DETAIL AMOUNT 2028 DETAIL AMOUNT TOTAL UNENC. FUNDING 19-15 135 STORM DRAIN LINE 20 477,884 341,346 332,810 136,538 - - - 469,348 19-15 135 STORM DRAIN LINE 20 715,744 511,246 489,757 204,498 - - - 694,255 19-18 260 JC FREY BLDG REHAB 1,131,000 - - 1,131,000 - - - 1,131,000 19-23 260 KEYLESS ENTRY PHASE 2 812,723 203,348 203,348 609,375 - - - 812,723 19-23 261 KEYLESS ENTRY PHASE 2 42,649 42,649 42,649 - - - - 42,649 19-24 260 DEMUTH PARK ADA ACCESS PHASE 2 1,900,000 600,000 595,714 1,300,000 - - - 1,895,714 19-25 260 LIFE SAFETY FIRE SPRKLR ALARM 2,200,000 900,000 900,000 0 1,300,000 - - 2,200,000 19-26 260 EMERGENCY GENERATORS CITYFAC 1,977,500 1,200,000 1,200,000 777,500 - - - 1,977,500 19-27 260 HVAC CITY WATER TREATMENT PRGM 789,750 607,500 607,500 182,250 - - - 789,750 19-28 260 RECREATIONAL LED LIGHTING UPGR 4,748,870 4,748,870 4,692,578 - - - - 4,692,578 20-03 261 PALM CYN INDIAN ROUNDABOUT 1,240,000 200,000 200,000 260,000 260,000 520,000 - 1,240,000 20-03 260 PALM CYN INDIAN ROUNDABOUT 2,185,096 625,096 454,677 520,000 520,000 520,000 - 2,014,677 20-04 260 SUNRISE PLAZA HVAC IMPROVEMENT 1,955,450 400,000 400,000 650,000 905,450 - - 1,955,450 20-04 261 SUNRISE PLAZA HVAC IMPROVEMENT 100,000 100,000 100,000 100,000 20-06 261 CITY HALL PD ELECTRICAL UPGRADES 266,500 205,000 205,000 61,500 266,500 20-06 261 CITY HALL PD ELECTRICAL UPGRADES 617,318 475,000 474,395 142,318 616,713 20-07 261 SUNRISE PLAZA DOMESTIC WATER S 329,875 - - 329,875 - - - 329,875 20-08 261 FLEET OPS HVAC ELECTRICAL IMPR 946,750 300,000 300,000 646,750 - - - 946,750 20-10 261 SUNRISE PLAZA DOOR WINDOW REPL 981,395 300,000 300,000 681,395 - - - 981,395 20-21 261 LOCAL ROAD SAFETY PLAN 7,992,788 492,788 492,636 2,646,500 1,617,833 1,617,833 1,617,834 7,992,636 21-04 420 WWTP SITEWORK PAVEMENT REHAB 1,600,000 150,000 150,000 725,000 725,000 - - 1,600,000 21-05 420 WWTP SLUDGE DRYING BEDS 1,723,895 1,017,895 943,432 706,000 - - - 1,649,432 21-06 420 WWTP DEMO ABANDONED HEADWORKS 3,685,500 1,842,750 1,842,750 1,842,750 - - - 3,685,500 21-08 420 WWTP BIOSOLIDS DEWATERING FACI 27,313,583 6,999,725 4,029,867 7,000,000 7,000,000 6,313,858 - 24,343,725 21-10 134 TRAFFIC CENTER COMM UPGRADE 650,000 500,000 491,216 150,000 641,216 21-16 260 DEMUTH DOG PARK 202,000 202,000 202,000 202,000 21-16 261 DEMUTH DOG PARK-CAP 1,300,306 - - 1,300,306 - - - 1,300,306 21-16 152 QUIMBY DEMUTH DOG PARK IMPRV 1,710,825 1,448,270 1,445,498 262,555 - - - 1,708,053 21-17 420 ARNICO TRACT SEWER PHASE 4 75,374 75,374 6,633 6,633 21-17 260 ARNICO TRACT SEWER PHASE 4 784,950 784,950 784,950 - - - - 784,950 22-19 260 RELOCATE FIRE STATION 1 23,200,000 1,600,000 1,600,000 3,600,000 9,000,000 9,000,000 - 23,200,000 22-20 260 COMMUNITY INITIATED PROJECTS 7,050,000 3,000,000 2,569,584 1,000,000 1,050,000 1,000,000 1,000,000 6,619,584 22-21 261 PEDESTRIAN STREETS MASTER PLAN 2,500,000 500,000 499,374 500,000 500,000 500,000 500,000 2,499,374 22-21 134 PEDESTRIAN STREETS MASTER PLAN 2,500,000 500,000 500,000 500,000 500,000 500,000 500,000 2,500,000 22-21 260 PEDESTRIAN STREETS MASTER PLAN 2,500,000 500,000 500,000 500,000 500,000 500,000 500,000 2,500,000 22-24 152 PICKLEBALL COURTS 150,276 150,000 150,000 276 - - - 150,276 22-24 260 PICKLEBALL COURTS 725,000 150,000 150,000 575,000 - - - 725,000 22-25 137 DEMUTH AND BARISTO SHADE STRUCTURES 281,960 281,960 281,960 281,960 22-26 260 SAN RAFAEL DRIVE TURF CONVERSION 150,000 150,000 150,000 150,000 22-36 261 IMPROVEMENTS TO LOT G DOWNTOWN 300,000 300,000 289,810 - - - - 289,810 22-37 261 SOCCER FIELDS AT DEMUTH PARK 200,000 200,000 200,000 - - - - 200,000 22-38 261 PALM TREE UP LIGHTING 90,000 90,000 90,000 - - - - 90,000 22-39 261 SHADE AT BUS STOPS 300,000 300,000 300,000 - - - - 300,000 XX-XX 261 SUNRISE RECYCLED WATER 1,500,000 - - 1,500,000 - - - 1,500,000 XX-XX 261 SUNRISE RECYCLED WATER 500,000 - - 500,000 500,000 23-XX.0 261 RIM ROAD DESIGN 400,000 - - 400,000 400,000 XX-XX-X 134 ONGOING STREET MAINTENANCE 2,000,000 - - 500,000 500,000 500,000 500,000 2,000,000 23-XX.1 134 WESTERN CV FLOOD AND BLOWSAND IMPROVEMENT673,873 - - 673,873 673,873 PAVING 260 ANNUAL PAVEMENT REHABILITATION 36,000,000 9,000,000 1,856,054 9,000,000 6,000,000 6,000,000 6,000,000 28,856,054 SIGNINVTRY 133 BIANNUAL SIGN INVENTORY 600,000 300,000 300,000 - 300,000 - - 600,000 SLURRY 133 ANNUAL SLURRY SEAL 3,375,000 675,000 675,000 675,000 675,000 675,000 675,000 3,375,000 SLURRY 134 ANNUAL SLURRY SEAL 3,375,000 675,000 675,000 675,000 675,000 675,000 675,000 3,375,000 SLURRY 142 ANNUAL SLURRY SEAL 1,097,504 - - 1,097,504 - - - 1,097,504 TRAFCALM 133 ANNUAL TRAFFIC CALMING 1,250,000 250,000 143,409 250,000 250,000 250,000 250,000 1,143,409 TRAFCALM 134 ANNUAL TRAFFIC CALMING 1,250,000 250,000 239,035 250,000 250,000 250,000 250,000 1,239,035 151,270,431$ 95,046,753$ 98,079,406$ 57,063,699$ 83,804,610$ 50,599,178$ -$ 384,593,646$ Item 3A - Page 78 I ! ATTACHMENT 4 Item 3A - Page 13 City of Palm Springs - Palm Springs International Airport FY 2023-24 & FY 2024-25 Budget Fund 405 - Customer Facility Charge Beginning Fund Balance 26,768,209$ 30,426,667$ 30,426,667$ 38,276,667$ 36,857,994$ Revenues 3,759,413 7,465,000 7,850,000 9,181,327 9,406,451 Expenditures (100,956) (3,123,265) - (10,600,000) (3,000,000) Surplus/(Deficit)3,658,457 4,341,735 7,850,000 (1,418,673) 6,406,451 Ending Fund Balance 30,426,667$ 34,768,402$ 38,276,667$ 36,857,994$ 43,264,445$ Fund 410 - Passenger Facility Charge Beginning Fund Balance (7,483,354)$ (7,483,354)$ (7,483,354)$ (4,223,354)$ (6,774,555)$ Revenues 5,451,866 5,451,866 5,781,000 6,450,776 6,603,496 Expenditures (8,926,176) (2,823,845) (2,521,000) (2,561,977) (2,507,761) Other - Tranfer to 416 - - - (6,440,000) (25,000,000) Surplus/(Deficit)(3,474,309) 2,628,021 3,260,000 (2,551,201) (20,904,265) Ending Fund Balance (10,957,662)$ (4,855,333)$ (4,223,354)$ (6,774,555)$ (27,678,820)$ Fund 415 - Airport Fund Beginning Fund Balance 3,567,861$ 16,103,859$ 16,103,859$ 35,832,858$ 42,786,472$ Operating Revenues Revenues 33,050,802 29,179,700 36,921,673 56,423,713 69,312,200 Non-Operating Revenues CARES Act Grant - 5,989,698 5,989,698 - - CRRSA - Airport Grant - 1,100,000 - 4,783,916 - CRRSA - Concessions Grant - 4,800,000 280,390 - - American Rescue Plan Act - Airport Grant - 6,020,652 9,310,342 1,481,290 - American Rescue Plan Act - Concessions - - 1,121,560 - - Operating Expenses Expenditures (20,514,803) (29,007,991) (27,758,837) (37,516,522) (41,949,447) Additional & Proposed Staffing - - - (3,531,535) (3,217,980) CalPERS Reserve Set-Aside - - (750,000) (750,000) (750,000) Other - Transfer to 416 - (5,385,828) (5,385,828) (6,983,634) (14,488,000) Surplus/(Deficit)12,535,999 12,696,231 19,728,998 13,907,229 8,906,773 Ending Fund Balance 16,103,859$ 28,800,090$ 35,832,858$ 42,786,472$ 47,239,858$ Fund 416 - Capital Projects Beginning Fund Balance 63,683,406$ 63,683,406$ 59,140,476$ 54,597,545$ 54,673,385$ Federal Grants 6,983,095 9,487,656 9,487,656 29,398,206 56,662,000 Other - Transfer from 410 8,229,415 - - 6,440,000 25,000,000 Other - Transfer from 415 - 5,385,828 5,385,828 6,983,634 14,488,000 Expenditures (2,890,634) (19,416,415) (19,416,415) (42,746,000) (96,150,000) Surplus/(Deficit)12,321,877 (4,542,930) (4,542,930) 75,840 - Ending Fund Balance 16,103,859$ 59,140,476$ 54,597,545$ 54,673,385$ 54,673,385$ All Airport Funds Summary FY 2024-25 Draft Budget FY 2022-23 Revised Budget FY 2022-23 Estimated Actual FY 2023-24 Draft Budget FY 2021-22 Actual 1 5/23/2023Item 3A - Page 79 City of Palm Springs - Palm Springs International Airport FY 2023-24 & FY 2024-25 Budget Category FY 2020-21 Actual FY 2021-22 Actual FY 2022-23 Revised Budget FY 2022-23 Estimated Actual FY 2023-24 Draft Budget FY 2024-25 Draft Budget Est 2022-23 Actual vs Budget 2023- 24 % Change Budget 2023-24 vs 2024-25 % Change Airline Revenues Scheduled Landing Fees 2,107,977 3,388,547 3,340,000 3,713,722 5,910,134 6,660,726 11.2%12.7% Landing Fee Surcharge 844,474 2,082,190 1,783,000 2,293,811 - - 28.6% Terminal Usage Hold Room Fee 921,012 1,374,922 1,034,000 1,483,246 3,470,605 4,512,015 43.4%30.0% Terminal Air Comm Rentals 1,971,523 2,180,132 2,094,000 2,174,246 9,467,216 14,090,552 3.8%48.8% Loading Bridge Fees - - - 1,255,064 1,208,363 -3.7% Non-Airline Revenues On-Airport Rental Car 5,263,544 11,330,331 8,899,000 12,304,500 11,944,780 12,303,124 38.3%3.0% Land Rental 1,317,324 1,358,823 1,223,000 1,397,783 1,247,329 1,409,974 14.3%13.0% Leased Parking 2,680,743 5,349,941 4,704,000 6,093,906 6,697,064 6,797,520 29.5%1.5% Term Non-Air Comm Rental 1,971,523 1,694,156 2,097,959 2,333,334 9,998,816 15,437,857 11.2%54.4% All Other General Revenue 4,291,759 14,760,844 5,127,126 5,335,705 5,740,219 Non-Operating Revenues - - CARES Act Funds 3,451,322 - 5,989,698 5,989,698 - - 0.0% CRRSAA - Airport - - 1,100,000 - 4,783,916 - -100.0%-100.0% CRRSAA - Concessions - - 280,390 280,390 - - 0.0% ARPA - Airport - - - 9,310,342 1,481,290 - -100.0% ARPA - Concessions - - - 1,121,560 - - TOTAL 20,529,441 33,050,802 47,305,891 53,623,663 61,591,919 68,160,350 14.9%10.7% Airport Operations Fund Revenues Scheduled Landing Fees 10%Terminal Usage Hold Room Fee 6% Terminal Air Comm Rentals 15%Loading Bridge Fees 2% On-Airport Rental Car 19% Land Rental 2% Leased Parking 11% Term Non-Air Comm Rental 16% All Other General Revenue 9% CRRSAA - Airport 8% ARPA -Airport 2% Fiscal Year 2023-24 Airport Revenue Fund 415 Scheduled Landing Fees 10%Terminal Usage Hold Room Fee 7% Terminal Air Comm Rentals 21% Loading Bridge Fees 2%Non-Airline Revenues 0%On-Airport Rental Car 18% Land Rental 2% Leased Parking 10% Term Non-Air Comm Rental 23% All Other General Revenue 8% Fiscal Year 2024-25 Airport Revenue Fund 415 2 5/23/2023Item 3A - Page 80 City of Palm Springs - Palm Springs International Airport FY 2023-24 & FY 2024-25 Budget Category FY 2020-21 Actual FY 2021-22 Actual FY 2022-23 Revised Budget FY 2022-23 Estimated Actual FY 2023-24 Draft Budget FY 2024-25 Draft Budget Est 2022-23 Actual vs Draft Budget 2023-24 % Change 2023-24 vs 2024-25 Budget % Change Administration 3,986,813 (29,497) 6,573,372 5,212,996 7,990,385 8,847,224 53.3%10.7% Information Technology - - 210,000 420,000 784,777 682,047 86.9%-13.1% Law Enforcement 2,825,144 2,704,992 3,138,357 3,053,885 3,147,659 3,229,436 3.1%2.6% Aviation Security - - - - 1,696,241 1,813,039 6.9% Airside Operations 1,660,134 1,469,874 1,068,180 1,309,963 5,288,984 5,454,221 303.8%3.1% Rescue-Fire 3,815,758 3,443,024 4,227,107 3,681,436 4,881,146 5,041,960 32.6%3.3% Landside Operations 1,131,673 1,489,331 1,538,049 1,699,475 2,178,178 2,759,661 28.2%26.7% Ground Maintenance 405,867 598,965 662,081 664,899 686,823 639,147 3.3%-6.9% Terminal Building Operations 6,579,342 7,069,586 7,060,112 7,788,259 8,191,023 10,605,447 5.2%29.5% Passenger Boarding Bridges - - 999 13,759 120,000 120,000 772.1%0.0% Baggage Handling System - - 722,979 299,493 897,000 900,000 199.5%0.3% Control Center Operations 3,422,265 3,448,554 4,229,679 3,330,431 4,160,405 4,101,807 24.9%-1.4% Customs 250,562 333,013 276,528 284,240 336,296 303,996 18.3%-9.6% Planning and Projects - - - - 689,140 669,444 Capital Projects - (13,039) - - - - TOTAL 24,077,558 20,514,803 29,707,443 27,758,837 41,048,057 45,167,427 48%10% Airport Operations Fund Expenditures Administration 19% Information Technology 2% Law Enforcement 8% Aviation Security 4% Airside Operations 13%Rescue-Fire 12% Landside Operations 5% Ground Maintenance 2% Terminal Building Operations 20% Baggage Handling System 2% Control Center Operations 10% Customs 1% Planning and Projects 2% Fiscal Year 2023-24 Airport Expenditures Fund 415 Administration 20% Information Technology 2% Law Enforcement 7% Aviation Security 4% Airside Operations 12% Rescue-Fire 11% Landside Operations 6% Ground Maintenance 1% Terminal Building Operations 23% Baggage Handling System 2% Planning and Projects 2% Fiscal Year 2024-25 Airport Expenditures Fund 415 3 5/23/2023Item 3A - Page 81 City of Palm Springs - Palm Springs International Airport FY 2023-24 & FY 2024-25 Budget Grant Type | Expiration Date Beginning Balance Estimated Use as of 6/30/23 FY 2023-24 Projected FY 2024-25 Projected Estimated Balance as of 6/30/23 Coronavirus Aid, Relief, and Economic Security Act (CARES) - Expires - May 10, 2024 11,067,877 11,067,877 - - - Coronavirus Response and Relief Supplemental Appropriations Act (CRRSA) - Airport Operations Expires - April 14, 2025 4,783,916 - 4,783,916 - - Coronavirus Response and Relief Supplemental Appropriations Act (CRRSA) - Concessions Expires - May 31, 2025 280,390 280,390 - - - American Rescue Plan Act (ARPA) - Airport Operations Expires - August 10, 2025 10,791,632 9,310,342 1,481,290 - - American Rescue Plan Act (ARPA) - Concession Expires - May 31, 2025 1,121,560 1,121,560 - - - Baggage Claim Expansion* Expires 2027 5,700,000 Bipartisan Infrastructure Law (BIL) * Expires - 2026 10,366,004 - - - 10,366,004 Total Grants 44,111,379 21,780,169 6,265,206 - 10,366,004 * Estimated amount FAA Grant Summary 4 5/23/2023Item 3A - Page 82 City of Palm Springs - Palm Springs International Airport FY 2023-24 & FY 2024-25 Budget No. of Projects Project Description Location Budget Funding Source Grant Share Airport Share PFC CFC 1 Telehandler/Forklift Project will improve safety by allowing workers to easily reach and maneuver heavy objects. Landside 150,000 Airport - 150,000 2 Parking Revene System Project will procure equipment, software and wayfinding to improve the public parking system. The existing system has reached its useful life. Landside 500,000 Airport - 500,000 3 Verbal Message Signage - Digital Project will procure equipment, installation and programming of landside digital signage to convey information to travelers. Landside 800,000 Airport - 800,000 4 Property Acquisition Project will procure 8.06 acres of property south of Kirk Douglas Way for future use.Landside 8,800,000 CFC - - 8,800,000 5 Lot A, Economy Lot Parking, Employee Lot (W of El Cielo) - (Design)Project will rehabilitate 82,720 square feet of raw land into an employee parking lot, west of El Cielo.Landside 2,400,000 Airport - 2,400,000 6 Electric Charging Station Infrastructure - Chargers acquisition Project will procure 80 electric chargers to be installed in public parking lot "D". Landside 300,000 Airport ACIP 271,980 28,020 7 Solid Separator Project will procure a solid separate for the maintenance shop to separate water and hazardous waste. Airside 100,000 Airport - 100,000 8 Procure Landside Vehicles Project will procure three vehicles to replace the useful life of two Operations vehicles and procure one new vehicle for Airport Administration. Airside 210,000 Airport VALE/ZEV Grant 190,386 19,614 9 Paint Striping Truck Project will procure a paint striping truck to paint all the pavement markings, such as runway centerlines, hold lines, and taxiway markings and to be within FAA regulations. Airside 1,000,000 Airport - 1,000,000 10 Wi-Fi Consultant (Design) Project will work with a Wi-Fi consultant to design and implement wireless networks, to ensure there is enough coverage to all areas of the airport, including terminal buildings, parking lots and aprons. Terminal 150,000 Airport - 150,000 Fiscal Year 2023-24 Airport Capital Projects 5 5/23/2023Item 3A - Page 83 City of Palm Springs - Palm Springs International Airport FY 2023-24 & FY 2024-25 Budget No. of Projects Project Description Location Budget Funding Source Grant Share Airport Share PFC CFC Fiscal Year 2023-24 Airport Capital Projects 11 Wi-Fi Installation (Construct)Project will construct and install based on design.Terminal 500,000 Airport - 500,000 12 Restroom Capacity & ADA Renovations (Construct)Project will rehabilitate ten restrooms and convert them into gender neutral bathrooms.Terminal 10,000,000 Airport BIL-ATP Grant 9,500,000 500,000 13 Outbound Baggage Handing System Terminal Expansion & Passenger Screening Faciltiy Expansion (Design) Project will expand existing terminal to incorporate the newly designed baggage handling system. Terminal 20,000,000 Airport ACIP 13,560,000 - 6,440,000 14 Arrivals Baggage Claim Expansion (Design & Costruct - CMAR) Project will procure a consultant to design the baggage claim to add additional capacity to the terminal. Terminal 6,000,000 Airport BIL-ATP Grant 5,700,000 300,000 15 Shade Area - Phase 1 Project will install shade structures in the sterile area outside of TSA checkpoint and at Nine Cities Craft by the Regional Jet Concourse. Terminal 236,000 Airport VGPS Grant 100,000 136,000 16 Carpet Replacement - Main terminal lobby and security check point Project will remove and replace 15,110 square feet of carpet in the main center terminal and security checkpoint. Terminal 400,000 Airport - 400,000 Subtotal Fiscal Year 2023-24 Projects 51,546,000 29,322,366 6,983,634 6,440,000 8,800,000 6 5/23/2023Item 3A - Page 84 City of Palm Springs - Palm Springs International Airport FY 2023-24 & FY 2024-25 Budget No. of Projects Projects Description Location Budget Funding Source Grant Share Airport Share CFC PFC 1 Consolidated Rental Car Facility (Design)Project will improve safety by allowing workers to easily reach and maneuver heavy objects. Landside 2,500,000 CFC - - 2,500,000 - 2 Procure two Zero Emissions Buses Project will procure Zero Emissions Vehicles (ZEV) to provide transportation between the terminals and the public parking. Landside 2,000,000 Airport VALE/ZEV Grant 1,813,200 186,800 - 3 Economy Lot (Construct) - Phase 1 Project will rehabilitate 434,786 square feet of pavement for an year round economy parking lot.Landside 3,000,000 Airport - 3,000,000 - 4 Lot A (Construct) Project will convert 46,782 square feet of public parking, into a commercial parking lot adjacent to the terminal. Landside 700,000 Airport - 700,000 - 5 Airfield W & A1 - (Construct - Phase 1)Project will construct based on the design that was completed in FY23 Airfield 6,500,000 Airport ACIP BIL-AIG Grant 5,892,900 607,100 - 6 Federal Inspection Station - (Design) & New Terminal Expansion Project will include the design and new terminal expansion, based on the study which was conducted in FY23/FY24 Airfield 19,000,000 Airport BIL - Entitlement Grant 17,225,400 1,774,600 - 7 Remain Over Night (RON) Parking Spaces Project will expand the existing remain over night parking spaces to help account for increased capacity. Airfield 4,000,000 Airport ACIP Grant 3,626,400 373,600 - 8 Procure ARFF Truck - Fire Dept Project will replace one PSP Aircraft Rescue & Fire Fighting Vehicle with a vehicle equipped with 3,000 gallons water, 420 gallon of AFFF and 500 lbs. of dry chemical. Airfield 1,500,000 Airport - 1,500,000 - 9 Airfield 31L/13R Rehabilitation & Airfield Connector - (Design) Project will complete the design of the airfield 31L/13R rehabiliatation and airfield connector pavements. Airfield 1,500,000 Airport ACIP Grant 1,359,900 140,100 - 10 Arrivals Bag Claim Renovation/Expansion - (Construct) Project will comlete the construction of the baggage claim renovation and or expansion based on the design completed in FY24. Terminal 12,000,000 Airport ACIP BIL-ATP Grant 10,879,200 1,120,800 - Fiscal Year 2024-25 Airport Capital Projects 7 5/23/2023Item 3A - Page 85 City of Palm Springs - Palm Springs International Airport FY 2023-24 & FY 2024-25 Budget No. of Projects Projects Description Location Budget Funding Source Grant Share Airport Share CFC PFC Fiscal Year 2024-25 Airport Capital Projects 11 Outbound BHS Inline System Replacement - (Construct) Project will procure additional equipment needed to expand the baggage handling system into a 100% automated inline system. Terminal 10,000,000 Airport OTA Grant 9,500,000 500,000 - 12 BHS - Terminal Building Expansion (Construct) Project will expand existing terminal building to include the newly designed baggage handling system. Terminal 25,000,000 PFC - - 25,000,000 13 Economy Lot (Construct) - Phase 2 Project will rehabilitate 434,786 square feet of pavement for a year round economy parking lot.Terminal 3,000,000 Airport 3,000,000 - 14 HVAC Infrastructure Replacement Project will replace existing HVAC system to include two boilers and three chillers with pumps. The current system is beyond its useful life. The new system will improve efficiency, reduce costs and provide a better environment for the Terminal 2,000,000 Airport BIL-ATP Grant 1,900,000 100,000 - 15 Conveyance Replacement Project will replace the existing three elevators, one in the main terminal, one passenger elevator and one cargo elevator in the Bono and two escalators which have reached their useful life. Terminal 4,700,000 Airport BIL-ATP Grant 4,465,000 235,000 - 16 Main Terminal Façade Restoration (Design)Project will restore the historic terminal façade. Terminal 500,000 Airport - 500,000 - 17 Automated Exit Lanes Project will remove the existing turnstile doors and replace with a more effient passenger exit.Terminal 750,000 Airport - 750,000 - Subtotal Fiscal Year 2024-25 Projects 98,650,000 56,662,000 14,488,000 2,500,000 25,000,000 8 5/23/2023Item 3A - Page 86