Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Item 3D - Staff Correspondence
City of Palm Springs Department of Finance and Treasury MEMORANDUM TO: Justin Clifton, City Manager FROM: Nancy Pauley, Director of Finance & Treasury DATE: June 14, 2022 RE: Proposed Budget –Fiscal Year 2022-2023 During the recent City Council Study Session meetings on April 25, 2022, May 4, 2022, and June 8, 2022, Staff presented the preliminary Fiscal Year 2022-23 General Fund, Measure J Fund, and Airport Fund budgets and review of the preliminary Five-Year Capital Improvements Plan. On June 30th, City Council will hold a public hearing to adopt the FY 2022-23 Budget. Any direction provided by the Council at the June 16 City Council meeting will be incorporated into the final proposed budget. The final budget must be adopted June 30th before the new fiscal year begins on July 1, 2022. Attached for your preliminary review is the Fiscal Year FY 2022-23 Comprehensive Budget which includes Special Revenue Funds, Capital Project Funds, Debt Service Funds, Enterprise Funds and Internal Service Funds, which will be presented along with the General Fund Budget at the public hearing on June 30, 2022. 06-16-2022 Additional Material Item 3D - 1 June 30, 2022 06-16-2022 Additional Material Item 3D - 2 City of Palm Springs Proposed Budget Fiscal Year 2022 -2023 City of Palm Springs FY 2022-23 Budget Table of Contents -General Fund - Fund Balance Summary for FY 2022-23 2 -General Fund - Revenues for FY 2022-23 3 -General Fund - Expenditures for FY 2022-23 8 -All Funds - Fund Balance Summary 12 -All Funds - Revenues for FY 2022-23 15 -All Funds - Expenditures for FY 2022-23 29 -All Funds - Summary of Budgeted Interfund Transfers for FY 2022-23 36 1 06-16-2022 Additional Material Item 3D - 3 FY 2021-22 FY 2021-22 FY 2022-23 FY 2020-21 Revised Estimated Proposed Actual Budget Actual Budget Beginning Projected Fund Balance - Unrestricted 22,137,767$ 52,448,534$ 52,448,534$ 74,461,976$ Operating Revenues 132,424,420 148,055,303 153,701,092 155,703,056 Transfers In 11,550,000 - - 1,000,000 Add: Grant Revenue 15,536,553 31,556,525 Total Revenues 143,974,420 148,055,303 169,237,645 188,259,581 Expenditures (101,544,453) (132,525,352) (118,456,179) (163,903,451) Approved Additional Appropriations FY22 (15,853,900) Transfers Out (12,119,200) (10,529,365) (15,095,765) (26,863,798) Operating Expenditures (113,663,653)(158,908,617)(133,551,944)(190,767,249) Less: Grant Expense (13,672,259) (28,772,525) Total Expenditures (113,663,653) (158,908,617) (147,224,203) (219,539,774) Surplus / (Deficit)30,310,767 (10,853,314) 22,013,442 (31,280,193) Required Minimum Fund Balance 30,028,269 Assigned Fund Balance for City Projects $52,448,534 $41,595,220 $74,461,976 13,153,514 Total Fund Balance Before CalPERS $52,448,534 $41,595,220 $74,461,976 43,181,783 CalPERS Reserve Set-Aside 22,250,000$ 28,250,000$ 28,250,000$ 34,250,000$ CalPERS Set-Aside/Fund Balance 74,698,534$ 69,845,220$ 102,711,976$ 77,431,783$ Required Minimum Fund Balance Total 15.74% Fund Balance Total 46.14%26.18%55.76%22.64% Fund Balance CalPERS Reserve Total 19.58%17.78%21.15%17.95% Fund Balance % Total 65.72%43.95%76.91%40.59% City of Palm SpringsGeneral Fund Working Fund Balance SummaryFiscal Year 2022-2023 6/14/20224:27 PM206-16-2022 Additional Material Item 3D - 4 City of Palm Springs FY 2022-23 Budget General Fund Revenues FY 2022-23 3 06-16-2022 Additional Material Item 3D - 5 City of Palm Springs FY 2022-2023 Budget FY2019-20 FY2020-21 FY2021-22 FY2021-22 FY2022-23 Account Description Actuals Actuals Revised Budget Estimated Actuals Proposed Budget Transient Occupancy Tax 25,817,660 35,092,830 34,857,400 45,556,081 48,390,703 Property Taxes 25,482,084 27,342,181 28,709,000 28,662,500 29,235,750 Sales and Use Taxes 20,923,634 25,232,110 24,480,500 30,114,800 30,717,096 Utility Users Tax 7,025,604 8,284,837 8,197,200 12,500,000 11,500,000 Motor Vehicle in Lieu tax 5,418,600 5,703,803 5,889,500 5,889,500 6,007,290 Franchise Fees 3,424,711 3,277,733 3,283,600 3,283,600 3,283,600 Cannabis Tax 2,838,208 4,770,184 4,700,000 5,020,000 4,794,000 All Other Sources 23,604,028 22,710,242 38,247,716 38,211,164 53,331,142 General Fund Subtotal:114,534,530 132,413,920 148,364,916 169,237,645 187,259,581 Transfers from other Funds 9,407,209 11,943,084 - - 1,000,000 Total:123,941,739 144,357,004 148,364,916 169,237,645 188,259,581 General Fund Revenue Summary TOT 27% Property Taxes 17% Sales and Use 18% Utility 7% Motor Vehicle 3% Franchise Fees 2% Cannabis 3% All Other Sources 23% FY2021-22 ESTIMATED ACTUALS TOT 26% Property Taxes 16% Sales and Use 16% Utility 6% Motor Vehicle 3% Franchise Fees 2% Cannabis 3% All Other Sources 28% FY2022-23 PROPOSED BUDGET 4 06-16-2022 Additional Material Item 3D - 6 _/ City of Palm Springs FY 2022-2023 Budget Account Account Description FY 2019-20 FY 2020-21 FY 2021-22 FY 2021-22 FY 2021-22 FY 2022-23 ACTUALS ACTUALS YTD ACTUALS REV BUDGET EST ACTUALS PROPOSED BUDGET Taxes 31005 Current Year Taxes Secured (24,483,261) (26,219,899) (27,403,930) (27,420,500) (27,420,500) (27,968,910) 31010 Current Year Taxes Unsecured (998,823) (1,122,282) (393,146) (1,242,000) (1,242,000) (1,266,840) 31015 Prior Year Taxes Unsecured - - - (46,500) - - 31020 In Lieu Prop Tax - Mvil (5,418,600) (5,703,803) (3,098,571) (5,889,500) (5,889,500) (6,007,290) 31025 Net Ab 1 X 26 (3,913,999) (2,993,099) (1,303,900) (3,255,000) (3,255,000) (3,255,000) 31035 Cra Pass Thru City Of PS (343,728) (801,494) (454,571) (558,000) (730,961) (730,961) 31045 Sales and Use Taxes (13,583,864) (25,232,110) (23,462,834) (24,480,500) (30,114,800) (30,717,096) 31055 Cannabis Tax (10,177,978) (4,770,184) (3,606,861) (4,700,000) (4,700,000) (4,794,000) 31056 Cannabis Tax - Meas E - - (294,943) - (320,000) (320,000) 31065 M Cannabis Audit Recovery (125,531) (30,711) (16,746) (27,000) (16,700) (9,000) 31070 Parking Tax (145,962) (27,204) - (46,800) (30,000) (30,000) 31075 Franchises (3,424,711) (3,277,733) (3,580,995) (3,283,600) (3,283,600) (3,283,600) 31080 Peg Fees (244,548) - - - - - 31085 Transient Occupancy Tax (25,491,319) (35,011,254) (46,612,262) (34,843,000) (45,556,081) (48,377,203) 31090 Transient Occupancy Permit (1,550) (25) - (900) - - 31100 Tot Audit Recovery (324,791) (81,551) (479,882) (13,500) (238,000) (13,500) 31105 Documentary Transfer Tax (720,839) (1,329,406) (1,140,629) (865,400) (1,018,621) (1,038,993) 31110 New Development Tax (213,129) (384,500) (478,477) (267,000) (400,000) (400,000) 31115 Utility Users Tax (7,025,604) (8,284,837) (12,795,895) (8,197,200) (12,500,000) (11,500,000) Subtotal - Taxes (96,638,237) (115,270,093) (125,123,642) (115,136,400) (136,715,763) (139,712,393) Licenses and Permits 32000 Business License (1,021,892) (973,416) (905,454) (1,120,000) (980,000) (1,000,000) 32005 Building Permits (1,939,180) (2,795,112) (2,698,349) (1,939,180) (2,689,828) (2,470,583) 32010 Sewer Permits Ins Fee (8,626) (12,509) (9,499) (7,000) 7,300 7,446 32015 Construction Permits (331,721) (339,152) (287,558) (264,000) (340,000) (346,800) 32020 Permit Issuance (136,448) (182,199) (264,716) (130,000) (182,199) (185,843) 32025 Sign Permits (27,673) (40,515) (27,701) (22,000) (27,000) (27,540) 32030 Transportation Permit (10,662) (11,442) (9,390) (8,000) (10,000) (10,200) 32035 Pool Drain Permits (1,623) (1,099) (1,325) (2,000) (2,000) (2,040) 32040 Code Compliance Inspections (27,795) (22,094) (18,079) (21,000) (21,000) (21,420) 32045 Renewals/Misc Permits (25,621) (7,640) (11,942) (70,000) (10,211) (10,415) 32055 Zoning Fees (278,173) (308,685) (466,139) (300,000) (449,105) (458,088) 32060 Subdivision Fees (99,592) (108,956) (79,905) (115,000) (115,000) (117,300) 32065 Vacation Rental Permit (1,881,304) (1,901,294) (2,037,903) (2,005,000) (1,890,000) (1,900,000) 32070 Vacant Building Registration (4,701) - (2,019) (10,000) (4,700) (4,794) 32075 Sb1473 Building Stand Admin (2,595) (3,366) (5,399) - - - 32085 Rent Control Registration (38,940) (38,220) (37,620) (42,000) (42,000) (42,000) 32095 Cannabis Permit Fee (137,014) (123,169) (244,917) (428,063) (160,000) (163,200) 32125 State District Access Fee 1186 (23,510) (22,488) (21,164) - - - 32135 Admin Fee - Engineering - - (51,109) - (43,000) (43,860) 32140 Covenant - Engineering - - (30,000) - (15,000) (15,300) Subtotal - Licenses and Permits (5,997,070) (6,891,355) (7,210,187) (6,483,243) (6,973,743) (6,811,937) Intergovernmental 33000 Grants (343,381) (845,571) (11,406,382) (11,570,194) (11,512,486) (26,146,125) 33005 State Homeowners Tax Rel (119,523) (236,240) (118,062) (250,000) (250,000) (250,000) 33015 Peace Off Training Funds (174,649) (23,541) (14,457) (30,000) (30,000) (30,000) 33510 Mutual Aid Overtime (42,143) (497,516) (137,441) - (137,441) - 38015 Federal Grants - (1,386,344) (4,024,067) (5,595,000) (4,024,067) (5,410,400) Subtotal - Intergovernmental (679,695) (2,989,212) (15,700,409) (17,445,194) (15,953,994) (31,836,525) REVENUE SUMMAY - GENERAL FUND 5 06-16-2022 Additional Material Item 3D - 7 City of Palm Springs FY 2022-2023 Budget Account Account Description FY 2019-20 FY 2020-21 FY 2021-22 FY 2021-22 FY 2021-22 FY 2022-23 ACTUALS ACTUALS YTD ACTUALS REV BUDGET EST ACTUALS PROPOSED BUDGET REVENUE SUMMAY - GENERAL FUND Charges for Services 33525 Local Dev Mitigation Fee 7,774 24,010 (3,330) (1,200) (1,200) (1,200) 33645 St Highway Maintenance - (1,800) - - - - 34000 Concessions (3,974) (576) (834) (3,974) (3,974) (3,974) 34015 Assess Dist Info Gen Fund (7,500) - -(7,500) (7,500) (7,500) 34025 Smoke Detector Inspection (42,949) - -- - - 34030 Other Charges Current Services (57,006) (32,668) (40,711) (57,006) (57,006) (62,158) 34035 Insurance (8,025) - (3,828) - (3,228) (3,451) 34040 Towing Fees - - (85,825) - (70,000) (76,327) 34050 Multi Unit Fire Insp Fee (179,126) (147,877) (219,425) (179,126) (179,126) (191,486) 34060 Shooting Range (2,458) (1,749) (4,671) (2,458) (3,000) (3,207) 34065 Fingerprint Fees (3,031) 156 52 (3,031) - (3,240) 34075 Police Contract Ot - - (89,262) - (50,000) (53,450) 34080 Fire Inspection Fee (81,106) (13,131) (193) (81,106) (81,106) (86,702) 34085 Fire Plan Check Fee (146,277) (115,343) (142,330) (146,277) (146,277) (156,370) 34090 Fire Commercial Insp Fee (43,340) (36,059) (29,303) (43,340) (43,340) (46,330) 34091 Fire Cert Program (1,991) - (1,550) - (1,100) (1,176) 34095 Fire Fees Misc (2,650) (1,645) (5,082) (2,650) (2,650) (2,833) 34100 Dui Program (1,551) (36,378) (33,999) (1,551) (31,000) (33,139) 34110 Building Plan Check Fees (560,365) (671,617) (687,731) (828,052) (592,000) (632,848) 34115 Engineering Plan Check Fees (262,077) (372,255) (136,349) (262,077) (262,077) (280,160) 34120 Miscellaneous Filing Fee (401,137) (535,749) (274,986) (401,137) (401,137) (428,815) 34125 Misc Engineering Fees (36,810) (29,236) (8,084) (36,810) (36,810) (39,350) 34135 Inhouse Fast Plan Check Fees - - - - - - 34140 Real Property Fees (30,218) (26,963) (22,256) (30,218) (30,218) (32,303) 34145 Gen Plan Maintenance Surcharge (64,503) (84,742) (118,927) (64,503) (84,742) (90,589) 34150 Planning Admin Services - - (6,568) - (10,000) (10,690) 34165 Administrative Service Charges (2,134,057) (2,168,092) (1,697,891) (2,100,000) (2,163,000) (2,312,247) 34181 Parklet Fees - - (83,152) - (75,000) (48,105) 34190 Nuisance Abatement (18,750) (32,213) - (18,750) (18,750) (20,044) 34195 Nuisance Abatement Admin (5,221) (1,919) - (5,221) (5,221) (5,581) 34206 PS USD Officer (146,802) - (87,674) (146,802) (146,802) (156,931) 34207 Rent A Cell (45,986) (45,986) (38,364) (45,986) (45,986) (49,159) 34320 Issuance Fee (1,785) - (18,932) - (10,136) (10,835) 34325 Tlc/Psvu Site Fees (1,295) - -(3,080) (3,080) (3,293) 34330 Friends Of The Library - (3,674) (27,423) (24,216) (18,200) - 34335 Library Fees (8,676) (939) (5,772) (5,000) (5,000) (5,345) 34350 Camp (105,067) (60,372) (52,301) (105,067) (50,550) (54,038) 34355 Instructional Dance (676) - - - - - 34360 Fitness (74,262) 326 (314) (74,938) (2,000) (2,138) 34365 Youth Programs (83,614) (475) (52,416) (83,614) (83,614) (89,383) 34370 Facilites Rent (200,545) (101,830) (161,850) (200,545) (200,545) (214,383) 34376 Special Activities (943,514) (941,547) (263,235) (946,514) (300,000) (320,700) 34380 Location Permits (15,660) (23,925) (26,629) (15,660) (16,000) (17,104) 34390 Instructional Classes (7,346) (1,027) (47,839) (7,346) (35,000) (37,415) 34395 Membership (7,785) (8,002) (14,232) (7,785) (10,700) (11,438) 34400 Baseball Stadium Rent (111,789) (144,228) (150,330) (111,789) (113,000) (120,797) 34420 Microfilming Fees (31,975) (32,031) (40,493) (31,975) (32,031) (35,268) 34425 Rancho Park Ii Landscape (9,348) (9,348) (9,348) (9,348) (9,348) (9,993) 34430 Daily Admissions (42,964) (51,800) (56,439) (42,964) (42,964) (45,929) 34435 Group Lessons (432) (337) (634) (432) (634) (3,207) 34445 Pool Rental Group (49,033) (7,215) (16,204) (49,033) (20,000) (21,380) 34450 Pool Passes (40,673) (102,321) (85,577) (40,673) (75,000) (80,175) 34460 Tournaments (657) - - (657) - - 34465 Banner Hanging (6,555) (1,642) (9,711) - (9,711) (7,500) 34470 TRACT (29,754) (8,405) (15,171) - (5,861) (5,861) 34475 Henry Frank Parking (3,012) (192) (3,264) - (2,304) - 34480 Villagefest (346,116) (2,233) (169,591) (25,000) (100,000) (150,000) Subtotal - Charges for Services (6,401,665) (5,833,046) (5,049,976) (6,254,411) (5,697,928) (6,085,547) 6 06-16-2022 Additional Material Item 3D - 8 City of Palm Springs FY 2022-2023 Budget Account Account Description FY 2019-20 FY 2020-21 FY 2021-22 FY 2021-22 FY 2021-22 FY 2022-23 ACTUALS ACTUALS YTD ACTUALS REV BUDGET EST ACTUALS PROPOSED BUDGET REVENUE SUMMAY - GENERAL FUND Fines & Penalties 35000 False Alarm Fee (314,774) (128,223) (134,864) (140,000) (140,000) (140,000) 35001 Alarm Permits - (153,999) (95,618) (170,518) (170,518) (170,518) 35005 Vehicle Code Fines (82,819) (105,631) (56,252) (82,819) (82,819) (82,819) 35010 Criminal Code Fines (13,928) (24,154) (34,170) (13,928) (35,490) (35,490) 35015 Parking Violations (115,428) (23,076) (96,300) (5,075) (98,219) (98,200) 35025 Library Fines and Fees (7,128) (371) (6,009) (7,128) (7,100) (7,100) 35035 Administrative Citations (202,798) (228,805) (156,293) (202,798) (202,798) (202,798) 35040 Parking Violation Admin (1,823) (160) 95 - 95 - Subtotal - Charges for Services (738,699) (664,419) (579,411) (622,266) (736,849) (736,925) Use of Money 36000 Interest Income (650,476) 246,860 (539,211) (500,000) (500,000) (500,000) 36010 Unrealized Gain Or Loss (834,855) 1,169,988 (475,882) - - - 34371 Building/Facilities Rent (181,930) (121,176) (200,960) (182,582) (200,000) (213,800) 34385 Village Green Rental (25,676) (23,586) (24,233) (24,970) (24,970) (26,693) Subtotal - Use of Money (1,692,938) 1,272,086 (1,240,286) (707,552) (724,970) (740,493) Miscellaneous Revenue 34485 Walk of Stars (181,700) (45,000) (82,300) - - - 34486 Plaza Theater Donations - (150,269) (15,825) - - - 37000 Penalty/Interest Deliq Taxes (141,565) (205) - (141,565) - - 37005 Waste Disposal Clearing (25,309) (117,434) 74,536 (25,309) (126,127) (126,127) 37010 Audit Recovery (1,243) (2,711) (635) (1,243) (1,243) (1,243) 37015 Contrib Non-Govt Sources (380,394) (301,387) (5,039) (728) (5,126) - 37025 Legal Fee Reimbursement (275) - (22,000) (275) (22,000) (275) 37035 Smip (1,064) (1,163) (6,515) (364) - - 37040 Smip Ii - (306) (4,045) - -- 37045 Miscellaneous Revenue (351,289) (111,139) (66,259) (700) (36,175) - 37050 Cashier Over 19 43 85 - - - 37060 Damage Recovery (20,321) (26,330) (1,834) - (1,834) - 37095 Settlement Revenue (39,428) (36,795) (53,671) - (19,911) - 37510 Restricted Donations - (23,638) (375,236) (337,550) (360,510) - 37515 Rent - Master Lease (1,209,167) (1,207,065) (1,207,064) (1,208,116) (1,207,064) (1,208,116) 37525 Reimbursement (29,390) (2,377) (37,759) - (6,343) - 38220 Electrical Reimbursement (1,937) - - - -- 31120 Low/Mod Housing Residual (6) - - - -- Subtotal - Miscellaneous Revenue (2,383,068) (2,025,775) (1,803,561) (1,715,850) (1,786,332) (1,335,761) Sale of Real Property 37520 Sale Real Or Personal Property (3,157) (12,106) (648,170) - (648,066) - Subtotal - Sale of Real Property (3,157) (12,106) (648,170) - (648,066) - Subtotal General Fund (114,534,530) (132,413,920) (157,355,642) (148,364,916) (169,237,645) (187,259,581) 39999 Budget Transfer In (9,407,209) (11,943,084) - - - (1,000,000) (123,941,739) (144,357,004) (157,355,642) (148,364,916) (169,237,645) (188,259,581) 7 06-16-2022 Additional Material Item 3D - 9 City of Palm Springs FY 2022-23 Budget General Fund Expenses FY 2022-23 8 06-16-2022 Additional Material Item 3D - 10 City of Palm Springs FY 2022-2023 Budget FY2019-20 FY2020-21 FY2021-22 FY2021-22 FY2022-23 Percent Account Description Actuals Actuals Revised Budget Estimated Actuals Proposed Budget Change General Government 41,171,900 36,265,793 71,763,751 59,492,101 100,035,513 68.1% Police 34,483,096 33,120,972 38,954,156 35,447,966 46,474,713 31.1% Fire 18,657,514 19,148,030 21,675,958 22,190,215 26,831,430 20.9% Parks and Recreation 8,316,842 6,902,278 10,363,026 8,998,157 13,334,320 48.2% PERS Future Cost Reserve - - 6,000,000 6,000,000 6,000,000 0.0% General Fund Subtotal:102,629,353 95,437,073 148,756,890 132,128,438 192,675,976 45.8% Transfers 24,074,841 18,622,268 10,095,765 15,095,765 26,723,220 77.0% Total:126,704,194 114,059,341 158,852,655 147,224,203 219,399,196 49.0% General Fund Expenditure Summary General Govt 41% Police 24% Fire 15% Transfers … Parks and Recreation 6% PERS Future Cost Reserve 4% FY2021-22 ESTIMAED ACTUALS General Govt 46% Police 21% Fire 12% Transfers 12% Parks and Recreation 6% PERS Future Cost Reserve 3% FY2022-23 PROPOSED BUDGET 9 06-16-2022 Additional Material Item 3D - 11 Dept #Department Description FY 2019-20 FY 2020-21 FY 2021-22 FY 2021-22 FY 2021-22 FY 2022-23 ACTUALS ACTUALS YTD ACTUALS REV BUDGET EST ACTUALS PROPOSED BUDGET General Government 1000 City Council 572,989 611,097 628,488 1,128,063 816,517 1,349,659 1005 City Manager/Admin 1,686,890 1,669,191 1,219,278 1,541,474 1,340,510 1,945,973 1010 City Attorney 998,298 793,567 1,157,509 1,677,000 1,742,136 1,947,000 1015 City Clerk 1,244,737 1,112,753 1,108,746 1,419,164 1,177,603 1,558,506 1020 Document Management 308,233 276,989 257,293 350,338 287,215 359,338 1025 Information Tech/PSCTV 3,019,424 2,721,096 3,285,356 4,796,119 3,515,183 5,666,640 1030 Human Resources 507,003 504,898 665,061 717,957 721,809 884,814 1035 Finance 5,475,816 3,834,153 5,202,999 7,474,175 7,135,014 8,488,650 1040 Procurement 603,256 383,639 510,107 648,476 580,808 721,735 1045 Office of Special Programs 999,767 1,006,013 1,525,226 2,811,618 2,210,137 4,211,474 1050 Public Affairs 369,639 322,798 439,894 487,178 430,762 916,629 1055 Appropriation for Contingency - 1060 Non Departmental - 151,555 295,676 566,103 277,331 (3,190,000) 2000 Engineering 2,896,186 2,628,098 2,904,045 3,846,427 2,981,312 4,428,604 2005 Building & Code Enforcement 2,781,480 2,731,238 2,380,342 3,463,909 2,767,337 3,691,966 2010 Planning Services 2,256,590 2,220,909 2,087,137 2,759,936 2,253,596 3,409,596 2300 Community and Economic Development 2,014,881 1,870,968 1,451,554 8,246,045 4,182,092 15,808,122 2305 Homeless Program 456,245 237,493 2,658,657 10,546,506 10,445,469 26,180,000 2310 Rent Control 70,910 82,669 83,884 97,606 102,271 114,155 2315 Neighborhood Development 188,507 179,658 198,182 230,119 216,161 251,738 2500 GPSCVB 456,164 548,582 542,256 595,000 587,444 1,115,000 2505 Visitor Information Center 4,343 - - 197,000 - 255,809 2510 Tourism 2,042,641 1,636,474 2,014,000 2,014,000 2,211,410 2,405,443 2515 Special Events and Contributions 542,777 12,150 490,500 500,000 500,000 500,000 2520 Special Contributions 34,483 - - - - - 2525 Film Fest Sponsorship 350,000 - 350,000 350,000 350,000 350,000 2530 Special Contributions - PS Resorts 204,954 - 200,365 225,000 225,000 225,000 2535 Chamber of Commerce 86,382 32,267 92,277 180,352 70,000 - 2540 Convention Center 2,594,682 2,760,638 2,867,500 3,179,229 3,172,612 2,936,859 2545 Plaza Theater 29,891 203,716 159,645 301,150 196,154 2,166,337 3055 Special Development Tracts 55,093 44,124 141,513 1,679,747 105,000 - 4000 Library 2,464,050 2,225,816 2,428,489 2,895,049 2,775,660 3,249,404 4005 Library - Welwood 64,703 20,965 142,364 169,325 131,729 190,702 4472 Parking Structure Maintenance - 97,840 55,586 153,054 83,331 169,145 6515 Street Maintenance 1,691,775 1,387,755 1,645,189 2,184,696 1,711,770 2,687,169 6520 Downtown Experience Maintenance 1,444,728 1,283,783 1,327,291 1,564,856 1,508,538 2,039,250 6525 Street Cleaning - 20,270 26,400 26,400 16,807 26,400 6530 Street Lighting 888,813 928,453 819,246 1,042,029 996,790 1,276,104 6535 Railroad Station 17,362 26,407 22,464 56,960 24,904 56,590 6545 Parking Structure/Control 314,233 56,081 - - - - 8000 Master Lease 1,433,980 1,641,692 1,641,692 1,641,692 1,641,692 1,641,700 Subtotal - General Government 41,171,900 36,265,793 43,026,211 71,763,751 59,492,101 100,035,513 Police 5000 Police Administration 30,076,000 28,845,693 27,404,806 33,629,614 30,793,704 40,083,050 5005 Jail Operations 365,384 261,359 248,599 386,337 279,023 438,741 5010 Animal Control 442,428 329,455 311,220 466,782 351,007 562,506 5015 Animal Shelter 1,139,827 989,707 1,095,325 1,069,902 1,159,110 1,157,402 5020 Code Compliance 969,347 1,119,307 1,058,244 1,747,328 1,108,489 2,058,262 5025 Dispatch Center 1,490,109 1,575,452 1,531,675 1,654,192 1,756,634 2,174,752 Subtotal - Police 34,483,096 33,120,972 31,649,868 38,954,156 35,447,966 46,474,713 Fire 6000 Fire Administration 18,523,495 19,103,529 19,260,780 21,551,708 22,043,109 26,663,885 6005 Emergency Management 134,019 44,501 111,333 124,250 147,106 167,545 Subtotal - Fire 18,657,514 19,148,030 19,372,113 21,675,958 22,190,215 26,831,430 EXPENDITURE SUMMARY - GENERAL FUND 10 06-16-2022 Additional Material Item 3D - 12 Dept #Department Description FY 2019-20 FY 2020-21 FY 2021-22 FY 2021-22 FY 2021-22 FY 2022-23 ACTUALS ACTUALS YTD ACTUALS REV BUDGET EST ACTUALS PROPOSED BUDGET EXPENDITURE SUMMARY - GENERAL FUND Parks and Recreation 6540 Park Maintenance 3,726,800 3,005,831 3,752,973 4,584,373 4,054,548 5,819,428 4500 Recreation 2,076,406 1,716,622 2,024,399 2,475,212 2,269,284 3,605,188 4505 Tennis and Pickleball 2,797 94,578 60,913 150,000 84,021 162,610 4510 Skate Park 174,708 87,600 107,575 114,366 118,933 166,366 4515 Swim Center 765,624 732,325 701,865 1,041,706 825,224 1,166,459 4520 Demuth Community Center 349,894 303,167 358,090 515,671 395,847 672,281 4525 James O Jessie DHUC 733,359 733,400 685,155 972,218 802,138 1,059,884 4530 Village Fest 487,254 228,754 445,534 509,479 448,163 682,104 Subtotal - Parks and Recreation 8,316,842 6,902,278 8,136,504 10,363,026 8,998,157 13,334,320 1070 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 102,629,353 95,437,073 102,184,697 148,756,890 132,128,438 192,675,976 Transfers 1116 Budget Transfer - Out 24,074,841 18,622,268 7,571,824 10,095,765 15,095,765 26,723,220 Total General Fund 126,704,194 114,059,341 109,756,521 158,852,655 147,224,203 219,399,196 11 06-16-2022 Additional Material Item 3D - 13 City of Palm Springs FY 2022-23 Budget All Funds - Fund Balances Summary FY 2022-23 12 06-16-2022 Additional Material Item 3D - 14 City of Palm Springs FY 2022-2023 Budget Fund Balance Schedule - FY 2021-22 REV TRAN EXP TRAN Fund Description 7/1/2021 Beginning Fund Balance FY 2021-22 Estimated Revenue FY 2021-22 Estimated Transfer-In FY 2021-22 Estimated Expenses FY 2021-22 Estimated Transfer-Out 6/30/2022 Estimated Ending Fund Balance Fu 100 General Fund - Unassigned and Contingencies 52,448,534 169,237,645 132,128,438 15,095,765 74,461,976 119 Small Hotel TBID Fund 8,370 700,000 - 700,000 - 8,370 120 Forfeited Assets Fund 261,752 3,200 - 8,206 - 256,746 121 Safety Augmentation Fund 2,086,023 1,015,200 - 971,304 - 2,129,919 123 Special Development Fund 2,008,612 - - 2,008,612 124 CSA 152 Fund 243,060 459,100 - 459,100 - 243,060 125 Recycling Fund 919,242 140,500 - 574,468 - 485,274 132 Parking Capital Programs Fund 544,647 14,985 - - 559,632 133 Special Gas Tax Improvements Fund 1,502,505 1,248,278 - 1,958,637 - 792,146 134 Measure A Improvements Fund 1,572,673 7,741,993 1,447,761 619,500 7,247,405 135 Drainage Fund 1,528,820 516,625 - 852,169 - 1,193,276 136 Emergency Response Fund 289,308 1,020,000 - 1,042,373 - 266,935 137 Community Development Block Grant (4,551) 1,197,733 - 1,193,182 0 138 Sustainability Fund 1,036,799 384,500 - 451,580 - 969,719 140 CFD Public Safety #1 Fund 776,198 1,007,000 - 851,478 931,720 141 Land/Light/Park Maintenance Dist 750,994 235,880 712,571 274,303 142 SB1 RMRA Road Maintenance Rehab 964,307 952,471 - 1,423,134 - 493,644 143 CFD Canyon View 16,845 - - - - 16,845 149 Air Quality Management Fund 150,180 62,000 - 50,000 - 162,180 150 Public Arts Fund 561,394 603,000 - 567,621 596,773 151 Library Endowment Fund 1,865,935 26,000 - 70,000 - 1,821,935 152 Quimby Act Fund 2,523,430 1,100,000 - 2,766,087 - 857,343 160 Special Projects Fund 3,141,400 100,000 - 3,095,000 - 146,400 260 Measure J Capital Projects Fund 21,142,569 19,001,400 - 20,058,581 1,402,832 18,682,556 261 Capital Projects Fund 11,648,618 23,218,706 2,000,000 28,813,077 - 8,054,247 301 Debt Service Fund 3,991,894 - 8,994,097 10,280,604 - 2,705,387 328 AD 2015 - 1 Fund 1,591,551 562,500 - 562,525 - 1,591,526 4xx Airport Fund (405-416)86,536,124 33,880,500 - 76,955,586 - 43,461,038 420 Wastewater Treatment Plant (WWTP)79,711,553 11,805,000 - 20,147,719 - 55,463,334 430 Golf Course Fund 2,358,412 4,800,000 1,124,000 5,544,868 - 2,737,544 510 Fleet Services Fund 5,373,305 5,100,000 - 8,105,273 - 2,368,032 520 Facility Maintenance Fund (4,158,978) 4,900,000 5,000,000 5,381,734 - 359,288 530 Employee Retirement Benefits Fund 5,229,114 22,411,781 - 22,411,781 - 5,229,114 540 Risk Management Fund 10,948,973 16,526,800 - 20,403,512 - 7,072,261 541 Retiree Health Insurance Fund 2,500,593 3,980,682 - 3,980,682 - 2,500,593 550 Energy Fund 2,201,549 1,930,000 - 2,162,896 - 1,968,653 870 Merged #1 Cap Successor 546,211 262,000 - 250,000 - 558,211 874 Housing Successor Agency Fund 11,255,858 52,300 - 3,940,110 - 7,368,048 879 Successor Agency Debt Service (28,426,949) 5,639,262 - 2,808,550 - (25,596,237) Total All Funds 287,646,190 341,837,041 17,118,097 383,130,607 17,118,097 230,447,124 13 06-16-2022 Additional Material Item 3D - 15 City of Palm Springs FY 2022-2023 Budget Proposed Fund Balance Schedule - FY 2022-23 REV TRAN EXP TRAN Fund Description 7/1/2022 Beginning Fund Balance FY 2022-23 Proposed Budgeted Revenue FY 2022-23 Propoosed Transfer-In FY 2022-23 Proposed Budgeted Expenses FY 2022-23 Proposed Transfer-Out 6/30/2023 Ending Fund Balance Fu100 General Fund - Unassigned and Contingencies 74,461,976 187,259,581 1,000,000 192,675,976 26,863,798 43,181,783 119 Small Hotel TBID Fund 8,370 700,000 - 700,000 - 8,370 120 Forfeited Assets Fund 256,746 - - 239,315 - 17,431 121 Safety Augmentation Fund 2,129,919 1,125,078 - 1,271,088 - 1,983,909 123 Special Development Fund 2,008,612 - - 2,008,612 124 CSA 152 Fund 243,060 459,100 - 335,668 - 366,492 125 Recycling Fund 485,274 223,457 - 693,398 - 15,333 132 Parking Capital Programs Fund 559,632 - - - 559,632 133 Special Gas Tax Improvements Fund 792,146 1,394,633 - 1,798,278 - 388,501 134 Measure A Improvements Fund 7,247,405 6,983,736 9,773,916 - 4,457,225 135 Drainage Fund 1,193,276 301,050 - 846,615 - 647,710 136 Emergency Response Fund 266,935 1,020,000 - 1,043,627 - 243,308 137 Community Development Block Grant 0 1,289,197 - 1,289,197 0 138 Sustainability Fund 969,719 384,500 140,578 584,189 - 910,608 140 CFD Public Safety #1 Fund 931,720 1,007,000 - 911,262 1,027,457 141 Land/Light/Park Maintenance Dist 274,303 235,880 509,983 200 142 SB1 RMRA Road Maintenance Rehab 493,644 1,088,536 - 1,088,536 - 493,644 143 CFD Canyon View 16,845 - - 16,700 - 145 149 Air Quality Management Fund 162,180 62,000 - 101,929 - 122,251 150 Public Arts Fund 596,773 181,000 - 401,334 376,439 151 Library Endowment Fund 1,821,935 - - 1,801,860 - 20,075 152 Quimby Act Fund 857,343 650,000 - 150,000 - 1,357,343 160 Special Projects Fund 146,400 100,000 - 100,000 - 146,400 260 Measure J Capital Projects Fund 18,682,556 20,352,400 - 27,695,885 5,138,500 6,200,571 261 Capital Projects Fund 8,054,247 31,466,614 6,500,000 44,701,592 - 1,319,269 301 Debt Service Fund 2,705,387 - 9,819,450 11,479,011 - 1,045,826 328 AD 2015 - 1 Fund 1,591,526 565,628 - 565,628 - 1,591,526 4xx Airport Fund (405-416)43,461,038 67,439,398 - 50,439,956 - 60,460,480 420 Wastewater Treatment Plant (WWTP)55,463,334 12,007,000 - 22,106,184 - 45,364,150 430 Golf Course Fund 2,737,544 4,585,578 400,000 5,564,231 - 2,158,891 510 Fleet Services Fund 2,368,032 8,367,600 5,824,770 9,194,326 - 7,366,076 520 Facility Maintenance Fund 359,288 6,400,000 6,817,500 6,383,874 - 7,192,914 530 Employee Retirement Benefits Fund 5,229,114 25,892,700 - 25,894,000 - 5,227,814 540 Risk Management Fund 7,072,261 20,854,074 - 20,258,455 - 7,667,880 541 Retiree Health Insurance Fund 2,500,593 3,980,682 - 3,980,682 - 2,500,593 550 Energy Fund 1,968,653 1,930,000 - 2,358,442 - 1,540,211 570 Equipment Replacement Fund - - 1,500,000 - - 1,500,000 870 Merged #1 Cap Successor 558,211 265,000 - 381,833 - 441,379 874 Housing Successor Agency Fund 7,368,048 - - 2,501,565 - 4,866,483 879 Successor Agency Debt Service (25,596,237) 5,639,262 - 2,446,600 - (22,403,575) Total All Funds 230,447,124 414,210,684 32,002,298 452,285,135 32,002,298 192,372,672 14 06-16-2022 Additional Material Item 3D - 16 City of Palm Springs FY 2022-23 Budget All Funds - Revenues FY 2022-23 15 06-16-2022 Additional Material Item 3D - 17 City of Palm Springs FY 2022-2023 Budget Account Account Description FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 ACTUALS ACTUALS REVISED BUDGET PROPOSED BUDGET Taxes 31005 Current Year Taxes Secured (24,483,261) (26,219,899) (27,420,500) (27,968,910) 31010 Current Year Taxes Unsecured (998,823) (1,122,282) (1,242,000) (1,266,840) 31015 Prior Year Taxes Unsecured - - (46,500) - 31020 In Lieu Prop Tax - Mvil (5,418,600) (5,703,803) (5,889,500) (6,007,290) 31025 Net Ab 1 X 26 (3,913,999) (2,993,099) (3,255,000) (3,255,000) 31035 Cra Pass Thru City Of PS (343,728) (801,494) (558,000) (730,961) 31045 Sales and Use Taxes (13,583,864) (25,232,110) (24,480,500) (30,717,096) 31055 Cannabis Tax (10,177,978) (4,770,184) (4,700,000) (4,794,000) 31056 Cannabis Tax - Meas E - - - (320,000) 31065 M Cannabis Audit Recovery (125,531) (30,711) (27,000) (9,000) 31070 Parking Tax (145,962) (27,204) (46,800) (30,000) 31075 Franchises (3,424,711) (3,277,733) (3,283,600) (3,283,600) 31080 Peg Fees (244,548) - - - 31085 Transient Occupancy Tax (25,491,319) (35,011,254) (34,843,000) (48,377,203) 31090 Transient Occupancy Permit (1,550) (25) (900) - 31100 Tot Audit Recovery (324,791) (81,551) (13,500) (13,500) 31105 Documentary Transfer Tax (720,839) (1,329,406) (865,400) (1,038,993) 31110 New Development Tax (213,129) (384,500) (267,000) (400,000) 31115 Utility Users Tax (7,025,604) (8,284,837) (8,197,200) (11,500,000) Subtotal - Taxes (96,638,237) (115,270,093) (115,136,400) (139,712,393) Licenses and Permits 32000 Business License (1,021,892) (973,416) (1,120,000) (1,000,000) 32005 Building Permits (1,939,180) (2,795,112) (1,939,180) (2,470,583) 32010 Sewer Permits Ins Fee (8,626) (12,509) (7,000) 7,446 32015 Construction Permits (331,721) (339,152) (264,000) (346,800) 32020 Permit Issuance (136,448) (182,199) (130,000) (185,843) 32025 Sign Permits (27,673) (40,515) (22,000) (27,540) 32030 Transportation Permit (10,662) (11,442) (8,000) (10,200) 32035 Pool Drain Permits (1,623) (1,099) (2,000) (2,040) 32040 Code Compliance Inspections (27,795) (22,094) (21,000) (21,420) 32045 Renewals/Misc Permits (25,621) (7,640) (70,000) (10,415) 32055 Zoning Fees (278,173) (308,685) (300,000) (458,088) 32060 Subdivision Fees (99,592) (108,956) (115,000) (117,300) 32065 Vacation Rental Permit (1,881,304) (1,901,294) (2,005,000) (1,900,000) 32070 Vacant Building Registration (4,701) - (10,000) (4,794) 32075 Sb1473 Building Stand Admin (2,595) (3,366) - - 32085 Rent Control Registration (38,940) (38,220) (42,000) (42,000) 32095 Cannabis Permit Fee (137,014) (123,169) (428,063) (163,200) 32125 State District Access Fee 1186 (23,510) (22,488) - - 32135 Admin Fee - Engineering - - - (43,860) 32140 Covenant - Engineering - - - (15,300) Subtotal - Licenses and Permits (5,997,070) (6,891,355) (6,483,243) (6,811,937) Revenue Summary - All Funds 16 06-16-2022 Additional Material Item 3D - 18 City of Palm Springs FY 2022-2023 Budget Account Account Description FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 ACTUALS ACTUALS REVISED BUDGET PROPOSED BUDGET Revenue Summary - All Funds Intergovernmental 33000 Grants (343,381) (845,571) (11,570,194) (26,146,125) 33005 State Homeowners Tax Rel (119,523) (236,240) (250,000) (250,000) 33010 State Motor In Lieu Tax - - - - 33015 Peace Off Training Funds (174,649) (23,541) (30,000) (30,000) 33510 Mutual Aid Overtime (42,143) (497,516) - - 38015 Federal Grants - (1,386,344) (5,595,000) (5,410,400) Subtotal - Intergovernmental (679,695) (2,989,212) (17,445,194) (31,836,525) Charges for Services 33525 Local Dev Mitigation Fee 7,774 24,010 (1,200) (1,200) 33645 St Highway Maintenance - (1,800) - - 34000 Concessions (3,974) (576) (3,974) (3,974) 34015 Assess Dist Info Gen Fund (7,500) - (7,500) (7,500) 34025 Smoke Detector Inspection (42,949) - -- 34030 Other Charges Current Services (57,006) (32,668) (57,006) (62,158) 34035 Insurance (8,025) - - (3,451) 34040 Towing Fees - - - (76,327) 34050 Multi Unit Fire Insp Fee (179,126) (147,877) (179,126) (191,486) 34060 Shooting Range (2,458) (1,749) (2,458) (3,207) 34065 Fingerprint Fees (3,031) 156 (3,031) (3,240) 34075 Police Contract Ot - - - (53,450) 34080 Fire Inspection Fee (81,106) (13,131) (81,106) (86,702) 34085 Fire Plan Check Fee (146,277) (115,343) (146,277) (156,370) 34090 Fire Commercial Insp Fee (43,340) (36,059) (43,340) (46,330) 34091 Fire Cert Program (1,991) - - (1,176) 34095 Fire Fees Misc (2,650) (1,645) (2,650) (2,833) 34100 Dui Program (1,551) (36,378) (1,551) (33,139) 34110 Building Plan Check Fees (560,365) (671,617) (828,052) (632,848) 34115 Engineering Plan Check Fees (262,077) (372,255) (262,077) (280,160) 34120 Miscellaneous Filing Fee (401,137) (535,749) (401,137) (428,815) 34125 Misc Engineering Fees (36,810) (29,236) (36,810) (39,350) 34135 Inhouse Fast Plan Check Fees - - - - 34140 Real Property Fees (30,218) (26,963) (30,218) (32,303) 34145 Gen Plan Maintenance Surcharge (64,503) (84,742) (64,503) (90,589) 34150 Planning Admin Services - - - (10,690) 34165 Administrative Service Charges (2,134,057) (2,168,092) (2,100,000) (2,312,247) 34181 Parklet Fees - - - (48,105) 34190 Nuisance Abatement (18,750) (32,213) (18,750) (20,044) 34195 Nuisance Abatement Admin (5,221) (1,919) (5,221) (5,581) 34206 PS USD Officer (146,802) - (146,802) (156,931) 34207 Rent A Cell (45,986) (45,986) (45,986) (49,159) 34320 Issuance Fee (1,785) - - (10,835) 34325 Tlc/Psvu Site Fees (1,295) - (3,080) (3,293) 34330 Friends Of The Library - (3,674) (24,216) - 34335 Library Fees (8,676) (939) (5,000) (5,345) 34350 Camp (105,067) (60,372) (105,067) (54,038) 34355 Instructional Dance (676) - - - 34360 Fitness (74,262) 326 (74,938) (2,138) 17 06-16-2022 Additional Material Item 3D - 19 City of Palm Springs FY 2022-2023 Budget Account Account Description FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 ACTUALS ACTUALS REVISED BUDGET PROPOSED BUDGET Revenue Summary - All Funds 34365 Youth Programs (83,614) (475) (83,614) (89,383) 34370 Facilites Rent (200,545) (101,830) (200,545) (214,383) 34376 Special Activities (943,514) (941,547) (946,514) (320,700) 34380 Location Permits (15,660) (23,925) (15,660) (17,104) 34390 Instructional Classes (7,346) (1,027) (7,346) (37,415) 34395 Membership (7,785) (8,002) (7,785) (11,438) 34400 Baseball Stadium Rent (111,789) (144,228) (111,789) (120,797) 34420 Microfilming Fees (31,975) (32,031) (31,975) (35,268) 34425 Rancho Park Ii Landscape (9,348) (9,348) (9,348) (9,993) 34430 Daily Admissions (42,964) (51,800) (42,964) (45,929) 34435 Group Lessons (432) (337) (432) (3,207) 34440 Private Lessons - -- - 34445 Pool Rental Group (49,033) (7,215) (49,033) (21,380) 34450 Pool Passes (40,673) (102,321) (40,673) (80,175) 34455 Coin Lockers - - - - 34460 Tournaments (657) - (657) - 34465 Banner Hanging (6,555) (1,642) - (7,500) 34470 TRACT (29,754) (8,405) - (5,861) 34475 Henry Frank Parking (3,012) (192) - - 34480 Villagefest (346,116) (2,233) (25,000) (150,000) Subtotal - Charges for Services (6,401,665) (5,833,046) (6,254,411) (6,085,547) Fines & Penalties 35000 False Alarm Fee (314,774) (128,223) (140,000) (140,000) 35001 Alarm Permits - (153,999) (170,518) (170,518) 35005 Vehicle Code Fines (82,819) (105,631) (82,819) (82,819) 35010 Criminal Code Fines (13,928) (24,154) (13,928) (35,490) 35015 Parking Violations (115,428) (23,076) (5,075) (98,200) 35020 Late Charges - - - - 35025 Library Fines and Fees (7,128) (371) (7,128) (7,100) 35035 Administrative Citations (202,798) (228,805) (202,798) (202,798) 35040 Parking Violation Admin (1,823) (160) - - Subtotal - Charges for Services (738,699) (664,419) (622,266) (736,925) Use of Money 36000 Interest Income (650,476) 246,860 (500,000) (500,000) 36010 Unrealized Gain Or Loss (834,855) 1,169,988 - - 34371 Building/Facilities Rent (181,930) (121,176) (182,582) (213,800) 34385 Village Green Rental (25,676) (23,586) (24,970) (26,693) Subtotal - Use of Money (1,692,938) 1,272,086 (707,552) (740,493) Miscellaneous Revenue 34485 Walk of Stars (181,700) (45,000) - - 18 06-16-2022 Additional Material Item 3D - 20 City of Palm Springs FY 2022-2023 Budget Account Account Description FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 ACTUALS ACTUALS REVISED BUDGET PROPOSED BUDGET Revenue Summary - All Funds 34486 Plaza Theater Donations - (150,269) - - 37000 Penalty/Interest Deliq Taxes (141,565) (205) (141,565) - 37005 Waste Disposal Clearing (25,309) (117,434) (25,309) (126,127) 37010 Audit Recovery (1,243) (2,711) (1,243) (1,243) 37015 Contrib Non-Govt Sources (380,394) (301,387) (728) - 37025 Legal Fee Reimbursement (275) - (275) (275) 37035 Smip (1,064) (1,163) (364) - 37040 Smip Ii - (306) - - 37045 Miscellaneous Revenue (351,289) (111,139) (700) - 37050 Cashier Over 19 43 - - 37060 Damage Recovery (20,321) (26,330) - - 37095 Settlement Revenue (39,428) (36,795) - - 37500 Contributions-Non Govt - - - - 37510 Restricted Donations - (23,638) (337,550) - 37515 Rent - Master Lease (1,209,167) (1,207,065) (1,208,116) (1,208,116) 37525 Reimbursement (29,390) (2,377) - - 38220 Electrical Reimbursement (1,937) - - - 31120 Low/Mod Housing Residual (6) - - - 31125 All Other RDA Residual - - - - Subtotal - Miscellaneous Revenue (2,383,068) (2,025,775) (1,715,850) (1,335,761) Sale of Real Property 37520 Sale Real Or Personal Property (3,157) (12,106) - - Subtotal - Sale of Real Property (3,157) (12,106) - - Subtotal General Fund (114,534,530) (132,413,920) (148,364,916) (187,259,581) 39999 Budget Transfer In (9,407,209) (11,943,084) - (1,000,000) Total General Fund (123,941,739) (144,357,004) (148,364,916) (188,259,581) 31170 Tbid (358,332) (515,727) (440,287) (700,000) 31171 TBID Vacation Rental - - (1,050,000) - 36000 Interest Income (142) (473) - - TOTAL 119 Small Hotel TBID Fund (358,475) (516,200) (1,490,287) (700,000) 35050 Forfeited Assets-Federal (18,720) - - - 35060 Forfeited Assets-Riv Cnty (35,388) - - - 36000 Interest Income (3,934) (2,467) - - 36010 Unrealized Gain Or Loss - 778 - - 37045 Miscellaneous Revenue - - - - TOTAL 120 Forfeited Assets (58,042) (1,689) - - 19 06-16-2022 Additional Material Item 3D - 21 City of Palm Springs FY 2022-2023 Budget Account Account Description FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 ACTUALS ACTUALS REVISED BUDGET PROPOSED BUDGET Revenue Summary - All Funds 31045 Sales and Use Taxes (1,087,260) (1,186,920) (972,368) (1,125,078) 35030 Ambulance Compliance Fees (49,156) (46,592) - - 36000 Interest Income (29,735) (17,708) - - 36010 Unrealized Gain Or Loss - 5,573 - - 37500 Contributions-Non Govt - (50,000) - - TOTAL 121 Safety Augmentation Fu (1,166,150) (1,295,646) (972,368) (1,125,078) 33610 Csa 152 Assessment (425,132) (299,880) (459,100) (459,100) 36000 Interest Income (568) (1,629) - - TOTAL 124 CSA 152 Fund (425,700) (301,509) (459,100) (459,100) 33000 Grants (19,034) (11,956) - (80,457) 33640 Community Cleanup Credit - - - (17,500) 34210 Recycling Surcharge (121,069) (128,694) (125,500) (125,500) 36000 Interest Income (21,042) (9,449) - - 36010 Unrealized Gain Or Loss - 4,326 - - 39999 Budget Transfer In - - - - TOTAL 125 Recycling Fund (161,146) (145,772) (125,500) (223,457) 34175 In Lieu Parking Fees (7,200) - - - 36000 Interest Income (9,350) (5,084) - - 36010 Unrealized Gain Or Loss - 1,620 - - TOTAL 132 Parking In-Lieu CIP (16,551) (3,464) - - 33530 State Gas Tax 2107 Funds (317,371) (332,253) (356,980) (420,916) 33535 State Gas Tax 2107.5 Fnds (6,000) (6,000) (6,000) (6,000) 33540 State Gas Tax 2106 Funds (153,674) (153,898) (174,277) (189,286) 33545 State Gas Tax 2105 Funds (250,362) (245,509) (280,518) (308,102) 33560 State Gas Tax 2103 Funds (347,776) (330,592) (430,503) (470,329) 36000 Interest Income (15,522) (14,017) - - 36010 Unrealized Gain Or Loss - 4,513 - - 37525 Reimbursement (3,825) - - - TOTAL 133 Special Gas Tax Improv (1,094,530) (1,077,757) (1,248,278) (1,394,633) 31045 Sales and Use Taxes (2,301,944) (3,101,321) (2,532,138) (3,151,000) 33000 Grants - 516,000 - - 33003 Regional Funds CVAG (790,813) (1,514,264) (7,077,413) (3,424,333) 33500 Transport Unif Mitigation Fee 22,146 - - - 36000 Interest Income (44,761) (16,734) - - 36005 Interest Income-Fiscal Agent (13,141) (0) - - 36010 Unrealized Gain Or Loss - 7,115 - - 37015 Contrib Non-Govt Sources - (247,051) - (408,403) 37045 Miscellaneous Revenue - (64) - - 39999 Budget Transfer In (1,039,158) - - - 20 06-16-2022 Additional Material Item 3D - 22 City of Palm Springs FY 2022-2023 Budget Account Account Description FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 ACTUALS ACTUALS REVISED BUDGET PROPOSED BUDGET Revenue Summary - All Funds TOTAL 134 Measure A Improvements (4,167,671) (4,356,319) (9,609,551) (6,983,736) 32100 Central Zone (144,795) (196,769) (33,540) (33,540) 32105 Southeast Zone (4,731) (9,964) (137,848) (137,848) 32110 North Zone (38,228) (84,643) (129,662) (129,662) 32115 South Zone (3,662) (12,338) - - 32120 East Zone (13,863) (31,481) - - 36000 Interest Income (23,262) (13,547) - - 36010 Unrealized Gain Or Loss - 4,247 - - TOTAL 135 Drainage Fund (228,541) (344,497) (301,050) (301,050) 36000 Interest Income (2,537) (1,589) - - 36010 Unrealized Gain Or Loss - 764 - - 37105 911 Emergency Response Fee (1,025,897) (1,272,953) (1,020,000) (1,020,000) 39999 Budget Transfer In - - - - TOTAL 136 Emergency Response Fun (1,028,434) (1,273,778) (1,020,000) (1,020,000) 33000 Grants (290,997) (1,071,012) (1,028,580) (1,289,197) 34375 Land Rental (412) (450) - - 39999 Budget Transfer In - (1,000) - - TOTAL 137 Community Develop Block Grant (291,409) (1,072,461) (1,028,580) (1,289,197) 33000 Grants (19,280) - - - 34215 Diversion Facility Fee (370,174) (380,005) (384,500) (384,500) 36000 Interest Income (12,099) (8,297) - - 36010 Unrealized Gain Or Loss - 2,568 - - 37015 Contrib Non-Govt Sources (900) (810) - - TOTAL 138 Sustainability Fund (402,452) (386,544) (384,500) (384,500) 33620 Cfd 2005-1 (837,017) (944,365) (963,150) (963,150) 33630 Cfd 2007-1 (40,083) (44,292) (43,850) (43,850) 36000 Interest Income (20,622) (1,833) - - 36010 Unrealized Gain Or Loss - 593 - - 39999 Budget Transfer In - - - - TOTAL 140 CFD Public Safety #1 Fund (897,722) (989,897) (1,007,000) (1,007,000) 31130 Parkway Maint District 9 (17,066) (16,951) (17,410) (17,410) 31135 Parkway Lighting Mnt 7 (23,978) (14,583) (14,500) (14,500) 31140 Parkway Maint Dist 10 (88,058) (572) (143,800) (143,800) 31145 Lighting Maint District 3 (4,165) (12,296) (4,300) (4,300) 31150 Parkway Maint District 6A (5,137) (5,054) (5,200) (5,200) 31155 Parkway Maint District 6C (12,266) (12,266) (12,400) (12,400) 31160 Pmd 10 Zone 2 (76,198) (1,184) - - 21 06-16-2022 Additional Material Item 3D - 23 City of Palm Springs FY 2022-2023 Budget Account Account Description FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 ACTUALS ACTUALS REVISED BUDGET PROPOSED BUDGET Revenue Summary - All Funds 31165 Lighting Maint District 12 (16,339) (8,179) (16,550) (16,550) 34230 Parkway Maint District 8 (21,956) (20,555) (21,720) (21,720) 36000 Interest Income (13,121) (7,577) - - 36010 Unrealized Gain Or Loss - 2,406 - - TOTAL 141 Land/Light/Park Maintenance (278,284) (96,811) (235,880) (235,880) 33585 Loan Repayment (54,787) - - - 33590 Traffic Signal Rehab (775,930) (872,833) (952,471) (1,088,536) 36000 Interest Income (9,971) (3,948) - - 36010 Unrealized Gain Or Loss - 1,064 - - TOTAL 142 SB1 RMRA Road Maint Rehab (840,688) (875,717) (952,471) (1,088,536) 33635 CFD 2019-1 - - - - 36000 Interest Income (677) (217) - - 36010 Unrealized Gain Or Loss - 72 - - TOTAL 143 CFD Canyon View (677) (145) - - 33575 Air Quality Mngmnt Fees (61,444) (46,182) (62,000) (62,000) 36000 Interest Income (2,404) (1,383) - - 36010 Unrealized Gain Or Loss - 423 - - TOTAL 149 Air Quality Management Fund (63,848) (47,142) (62,000) (62,000) 34200 Public Arts Fee (293,063) (373,028) (180,000) (180,000) 36000 Interest Income (8,095) (5,502) (1,000) (1,000) 36010 Unrealized Gain Or Loss - 1,712 - - 37015 Contrib Non-Govt Sources (2,799) - - - TOTAL 150 Public Arts Fund (303,957) (376,818) (181,000) (181,000) 34330 Friends Of The Library (6,024) - - - 36000 Interest Income (34,059) (17,440) - - 36010 Unrealized Gain Or Loss - 5,592 - - 37015 Contrib Non-Govt Sources (125) (1,766) (75) - 37505 Unrestricted Donations (16) (17) (25,000) - TOTAL 151 Library Endowment Fund (40,223) (13,631) (25,075) - 34415 Quimby Act Fees (577,622) (1,033,767) (580,000) (580,000) 36000 Interest Income (81,573) (35,802) (70,000) (70,000) 36010 Unrealized Gain Or Loss - 12,225 - - TOTAL 152 Quimby Act Fund (659,195) (1,057,343) (650,000) (650,000) 33000 Grants (12,450) - - - 34040 Towing Fees (118,630) (77,004) - - 22 06-16-2022 Additional Material Item 3D - 24 City of Palm Springs FY 2022-2023 Budget Account Account Description FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 ACTUALS ACTUALS REVISED BUDGET PROPOSED BUDGET Revenue Summary - All Funds 34075 Police Contract Ot (144,100) (114,021) (100,000) (100,000) 34100 Dui Program (32,091) (10) - - 34376 Special Activities (730) - - - 36000 Interest Income (50,519) (29,007) - - 36010 Unrealized Gain Or Loss - 9,151 - - 37015 Contrib Non-Govt Sources (198,866) (18,598) - - TOTAL 160 Special Projects (557,387) (229,490) (100,000) (100,000) 31050 Measure J Sales Tax (14,829,517) (17,770,795) (17,800,000) (20,352,400) 36000 Interest Income (428,552) (193,211) - - 36010 Unrealized Gain Or Loss - 53,922 - - 37015 Contrib Non-Govt Sources - - - - 37525 Reimbursement (1,665) - - - 39999 Budget Transfer In - - - - 37045 Miscellaneous Revenue - - - - TOTAL 260 Measure J Capital Projects (15,259,734) (17,910,084) (17,800,000) (20,352,400) 32130 Technology Fee (445,671) (653,994) (100,000) (100,000) 33000 Grants (2,116,081) (2,130,301) (14,020,708) (28,568,214) 33003 Regional Funds CVAG - (10,701) - - 33522 Open Space - - - - 33590 Traffic Signal Rehab (3,559) (229,170) (1,399,200) (1,399,200) 33595 City Facilities (1,200) - - (1,399,200) 33596 AQMD Solar Pv (214,638) - - - 33597 Hsip Cycle 7 (93,323) (317,514) (2,000,000) - 33598 Hsip Cycle 8 (160,967) (154,397) (5,698,798) - 33599 Fy17 Shsp (6,752) - - - 33600 Indian Reservation Road - - - - 33601 Prop 1 Grt Reimbursement - - - - 36000 Interest Income (285,225) (123,649) - - 36010 Unrealized Gain Or Loss - 41,836 - - 36050 Bogert Bridge Assessment - (15,876) - - 37015 Contrib Non-Govt Sources (345,736) (5,063) - - 37045 Miscellaneous Revenue - (3,102) - - 39999 Budget Transfer In (6,257,329) (2,612,300) (2,000,000) (6,500,000) 37045 Miscellaneous Revenue (36,520,000) - - - TOTAL 261 Capital Projects Fund (46,450,481) (6,214,231) (25,218,706) (37,966,614) 36000 Interest Income (1,907) (8,582) - - 36005 Interest Income-Fiscal Agent (50,779) (1,179) - - 37099 Proceeds From 2021 LRB A - (33,495,000) - - 39302 PERS / Pr Tax - (799,028) - - 39999 Budget Transfer In (12,972,520) (12,011,328) (8,994,097) (9,819,450) TOTAL 301 Debt Service Fund (13,025,206) (46,315,115) (8,994,097) (9,819,450) 23 06-16-2022 Additional Material Item 3D - 25 City of Palm Springs FY 2022-2023 Budget Account Account Description FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 ACTUALS ACTUALS REVISED BUDGET PROPOSED BUDGET Revenue Summary - All Funds 36000 Interest Income (144) - - - TOTAL 311 A.D. 143 Debt Service (144) - - - 36000 Interest Income (1,598) - - - TOTAL 312 A.D. 143 Reserve (1,598) - - - 36000 Interest Income (35) - - - TOTAL 313 A.D. 146 Debt Service (35) - - - 36000 Interest Income (539) - - - TOTAL 314 A.D. 146 Reserve (539) - - - 36000 Interest Income (24) - - - TOTAL 322 A.D. 159 Debt Service (24) - - - 33615 Assessment District - - - - 36000 Interest Income (3) - - - TOTAL 324 A.D. 157/158 Refi (3) - - - 33615 Assessment District (563,352) (566,383) (562,600) (565,628) 36000 Interest Income (1,533) (1,589) - - 36005 Interest Income-Fiscal Agent (3,721) (17) - - TOTAL 328 A.D. 2015-1 (568,606) (567,988) (562,600) (565,628) 36000 Interest Income (408,980) (228,958) - (320,000) 36010 Unrealized Gain Or Loss - 72,125 - - 38125 Customer Facility Charge (1,873,450) (1,234,510) (1,750,000) (7,145,000) TOTAL 405 Airport Customer Facility Fund (2,282,430) (1,391,343) (1,750,000) (7,465,000) 36000 Interest Income (28,568) (17,641) - (50,000) 36005 Interest Income-Fiscal Agent (316,858) (6,962) - - 36010 Unrealized Gain Or Loss - 5,420 - - 38010 Resident Discount Cards - -- - 38080 Passenger Facility Chg - (2,636,590) (4,275,000) (6,817,000) 38125 Off-Airport Rental Car (4,104,645) - - - 39999 Budget Transfer In - (2,712,880) - - TOTAL 410 Airport Passenger Charges (4,450,071) (5,368,652) (4,275,000) (6,867,000) 34050 Multi Unit Fire Insp Fee - - (35,000) - 34490 LIMO/EXEC/Chart - (25,224) - - 24 06-16-2022 Additional Material Item 3D - 26 City of Palm Springs FY 2022-2023 Budget Account Account Description FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 ACTUALS ACTUALS REVISED BUDGET PROPOSED BUDGET Revenue Summary - All Funds 36000 Interest Income (224,849) (105,754) (180,000) (100,000) 36010 Unrealized Gain Or Loss - 32,417 - - 37100 Cares Act Funds (1,626,857) (3,451,322) - (5,989,698) 37110 CRRSAA-Airport - - - (1,100,000) 37115 CRRSAA-Concession - - - (4,800,000) 38000 Parking Violation (23,363) (10,345) (20,000) (12,000) 38005 Parking Violation Admin (10) (4) - - 38010 Misc Revenue - Airport (40,548) (146,906) (128,000) (139,000) 38020 Scheduled Landing Fees (2,069,780) (2,107,977) (2,130,000) (3,340,000) 38030 Landing Fee Surcharge (1,186,601) (844,474) (1,071,000) (1,783,000) 38035 Airfield Concessions (241,824) (301,059) (310,000) (310,000) 38065 Property Rental-Non Avtn (448,310) (447,740) (520,000) (450,000) 38070 Hangar Rental - - - (30,000) 38075 Land Rental - 341 (1,235,590) (1,317,324) (1,605,000) (1,223,000) 38085 Leased Parking (3,267,861) (2,680,743) (3,326,000) (4,704,000) 38090 Airport Use Permits (73,946) (40,973) (120,000) (75,000) 38095 Employee Parking Permits (15,200) (14,120) (25,000) (20,000) 38100 Term Air Comm Rentals (1,934,754) (1,971,523) (2,197,000) (2,094,000) 38105 Term Non-Air Comm Rentals (1,457,435) (946,725) (1,000,000) (1,741,300) 38110 Ready Return Lot (1,020,706) (421,601) (750,000) (300,000) 38115 Advertising (400,539) (233,048) (256,000) (400,000) 38120 On-Airport Rental Car (6,480,246) (5,263,544) (5,837,000) (8,899,000) 38125 Off-Airport Rental Car (32,599) (42,029) (35,000) (39,000) 38130 Airport Access Fees (54,715) (57,989) (70,000) (45,000) 38135 Commercial Airport Fee (610,046) (679,029) (730,000) (853,000) 38140 Terminal Concessions (9,858) (10,219) (10,000) (97,200) 38145 Taxi Access Fees (667,602) (335,469) (631,000) (667,000) 38150 Term Usage Hold Room Fee (869,250) (921,012) (892,000) (1,034,000) 38155 Ground Transportation Ctr - - - - 38160 Vasi Power Reimb (2,160) (2,160) (3,000) (2,200) 38165 Customs Fees (259,145) (228,456) (240,000) (349,000) 38175 Security Gate Passes-Id (41,804) (31,178) (45,000) (47,000) 38180 Waste Disposal Fees (1,548) 129 (2,000) - 38185 Ps Air Museum Admissions (4,116) 9 - - 38190 Ps Air Museum Sales (1,806) (270) - - 38195 Ps Air Museum Food & Bev (8) 9 - - 38200 Admin In Lieu Of Catering (3,971) 9 - - 38205 Airport Security Act 2001 (116,800) (144,800) (120,000) (264,000) 38220 Electrical Reimbursement (128,830) (66,103) (125,000) (130,000) 38225 Tenant Reimbursement (31,646) - (40,000) - 38230 Faa Chrc Fingerprint (43,023) (25,721) (47,000) (32,000) 39405 Insurance Recoveries - - - - TOTAL 415 Airport Fund (24,627,346) (22,842,267) (22,500,000) (41,069,398) 36000 Interest Income (150,431) (85,089) - - 36010 Unrealized Gain Or Loss - 25,311 - - 38015 Federal Grants (4,161,269) (5,316,337) (5,355,500) (7,406,922) 39999 Budget Transfer In (8,330,903) (12,147,780) - (4,631,078) 25 06-16-2022 Additional Material Item 3D - 27 City of Palm Springs FY 2022-2023 Budget Account Account Description FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 ACTUALS ACTUALS REVISED BUDGET PROPOSED BUDGET Revenue Summary - All Funds TOTAL 416 Airport Capital Projects Fund (12,642,603) (17,523,895) (5,355,500) (12,038,000) 36000 Interest Income (697,595) (430,904) (150,000) (150,000) 36010 Unrealized Gain Or Loss - 131,487 - - 38700 Sewer Service Charges (10,397,824) (10,772,717) (10,600,000) (10,600,000) 38705 Sewer Connection Fee (608,185) (1,019,845) (800,000) (800,000) 38710 Sewer Street Maint Chg (6,537) (31,867) (5,000) (7,000) 38715 Septage Hauler (469,647) (534,220) (250,000) (450,000) 38730 Miscellaneous (113,733) - - - TOTAL 420 Wastewater Treatment Plant (12,293,521) (12,658,066) (11,805,000) (12,007,000) 34035 Insurance (653,981) - - - 36000 Interest Income (9,022) (32,936) - - 36005 Interest Income-Fiscal Agent (112) (2) - - 38900 Tahquitz Green Fees & Crt (3,543,292) (3,550,384) (4,188,681) (4,570,578) 38910 Resident Discount Cards (8,755) (368) (15,000) (15,000) 39999 Budget Transfer In (1,814,000) (2,588,900) (1,124,000) (400,000) TOTAL 430 Golf Course Fund (6,029,162) (6,172,589) (5,327,681) (4,985,578) 33001 Intergovermental - - - - 36000 Interest Income (77,257) (38,844) - - 36010 Unrealized Gain Or Loss - 11,953 - - 37060 Damage Recovery - - - - 37520 Sale Real Or Personal Property (11,367) (145,803) - - 39020 City Vehicle Replace Rent (3,424,100) (3,562,000) (4,200,000) (8,367,600) 39030 Miscellaneous Mvr - (2,000) - - 39405 Insurance Recoveries - (12,059) - - 39620 Contributed Capital (36,140) - - - 39999 Budget Transfer In (435,000) - - (5,824,770) TOTAL 510 Fleet Services Fund (3,983,864) (3,748,753) (4,200,000) (14,192,370) 36000 Interest Income (65,450) (32,761) - - 36010 Unrealized Gain Or Loss - 10,243 - - 37015 Contrib Non-Govt Sources - (291) - - 37045 Miscellaneous Revenue - (164) - - 37060 Damage Recovery - (11,446) - - 38215 Customer Facility Charge (4,037,200) (4,080,800) (4,900,000) (6,400,000) 39999 Budget Transfer In (120,900) (104,400) (5,000,000) (6,817,500) TOTAL 520 Facility Maintenance Fund (4,223,550) (4,219,618) (9,900,000) (13,217,500) 36000 Interest Income (10,350) 289,104 - - 36010 Unrealized Gain Or Loss - - - - 37045 Miscellaneous Revenue - - - - 39302 PERS / Pr Tax (23,888,154) (23,228,027) (22,411,781) (25,892,700) 26 06-16-2022 Additional Material Item 3D - 28 City of Palm Springs FY 2022-2023 Budget Account Account Description FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 ACTUALS ACTUALS REVISED BUDGET PROPOSED BUDGET Revenue Summary - All Funds TOTAL 530 Employee Retirement Benefits (23,898,504) (22,938,923) (22,411,781) (25,892,700) 33000 Grants - (518,629) - - 33605 Fed Emer Relief Funds (46,534) - - - 34035 Insurance - - - - 36000 Interest Income (198,146) (150,183) - - 36010 Unrealized Gain Or Loss - 47,344 - - 37095 Settlement Revenue - - - - 37100 Cares Act Funds - (108,862) - - 37525 Reimbursement - (117,844) - - 39400 Interfund Serv Charge Fringes (8,338,845) (8,603,424) (9,915,600) (10,120,737) 39401 Risk Insurance (3,420,800) (3,528,400) (2,194,700) (5,854,337) 39402 Workers Comp Ins Rev (4,553,927) (4,896,593) (3,737,500) (4,200,000) 39405 Insurance Recoveries (5,000) (25,400) - - 39410 Cobra (8,608) (17,752) (25,000) (25,000) 39415 Special Events Liab Ins (7,786) (930) (4,000) (4,000) 39420 Pr Deductions Insurance (491,753) (501,413) (565,000) (565,000) 39425 Pr Deductions Supp Life - - (3,000) (3,000) 39430 Pr Deductions Std Ins (84,567) (79,762) (82,000) (82,000) 39455 Airport Lightning 2018 Recov - - - - 39999 Budget Transfer In (8,064,877) (6,000,000) - - TOTAL 540 Risk Management Fund (25,220,843) (24,501,847) (16,526,800) (20,854,074) 36000 Interest Income (28,417) (18,580) - - 36010 Unrealized Gain Or Loss - 5,422 - - 37045 Miscellaneous Revenue - - - - 39435 Retirees Contributions (144,327) (138,648) (160,000) (160,000) 39436 OPEB Retiree Health (3,355,700) (3,516,000) (3,820,682) (3,820,682) TOTAL 541 Retiree Health Insurance Fund (3,528,444) (3,667,806) (3,980,682) (3,980,682) 36000 Interest Income (65,613) (37,246) - - 36010 Unrealized Gain Or Loss - 11,689 - - 37045 Miscellaneous Revenue - (3,964) - - 39505 Muni Cold Water (1,684,108) (1,550,810) (1,700,000) (1,700,000) 39510 Muni Cold Water Cogen (46,930) (47,844) - - 39520 Muni Electric Sales - - - - 39525 Sunrise / Cold Water (279,098) (242,915) (230,000) (230,000) 39530 Sunrise Cold Water Cogen (12,086) (11,831) - - 39999 Budget Transfer In - (1,174,190) - - TOTAL 550 Energy Fund (2,087,835) (3,057,111) (1,930,000) (1,930,000) 39999 Budget Transfer In - - - (1,500,000) TOTAL 570 Equipment Replacement - - - (1,500,000) 31040 Rpttf (8,000) (7,500) (15,000) (15,000) 27 06-16-2022 Additional Material Item 3D - 29 City of Palm Springs FY 2022-2023 Budget Account Account Description FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 ACTUALS ACTUALS REVISED BUDGET PROPOSED BUDGET Revenue Summary - All Funds 31041 Admin 3% (125,000) - (250,000) (250,000) 34371 Building/Facilities Rent - - - - 36000 Interest Income (1,966) (774) - - 36010 Unrealized Gain Or Loss - 328 - - 37520 Sale Real Or Personal Property - - - - 39999 Budget Transfer In - (103,668) - - TOTAL 870 Merged #1 Cap Successor (134,966) (111,614) (265,000) (265,000) 36000 Interest Income (92,977) (48,105) - - 36010 Unrealized Gain Or Loss - 16,377 - - 37045 Miscellaneous Revenue - (500) - - 37095 Settlement Revenue - - - - 37520 Sale Real Or Personal Property - - - - 39999 Budget Transfer In (96,636) - - - TOTAL 874 Housing Successor (189,613) (32,228) - - 31040 Rpttf (3,018,196) (2,849,756) (5,639,262) (5,639,262) 36000 Interest Income (2,506) (4,795) - - 36005 Interest Income-Fiscal Agent (10,832) (72) - - 36010 Unrealized Gain Or Loss - - - - 36030 Gain From Loan Forgiveness (1,139,871) - - - 39605 Bond Premium (173,682) (173,682) - - 39999 Budget Transfer In - - - - TOTAL 879 Successor Agency Debt (4,345,087) (3,028,305) (5,639,262) (5,639,262) 28 06-16-2022 Additional Material Item 3D - 30 City of Palm Springs FY 2022-23 Budget All Funds - Expenditures FY 2022-23 29 06-16-2022 Additional Material Item 3D - 31 City of Palm Springs FY 2022-2023 Budget Dept #Department Description FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 ACTUALS ACTUALS REVISED BUDGET PROPOSED BUDGET General Government 1000 City Council 572,989 611,097 1,128,063 1,349,659 1005 City Manager/Admin 1,686,890 1,669,191 1,541,474 1,945,973 1010 City Attorney 998,298 793,567 1,677,000 1,947,000 1015 City Clerk 1,244,737 1,112,753 1,419,164 1,558,506 1020 Document Management 308,233 276,989 350,338 359,338 1025 Information Tech/PSCTV 3,019,424 2,721,096 4,796,119 5,666,640 1030 Human Resources 507,003 504,898 717,957 884,814 1035 Finance 5,475,816 3,834,153 7,474,175 8,488,650 1040 Procurement 603,256 383,639 648,476 721,735 1045 Office of Special Programs 999,767 1,006,013 2,811,618 4,211,474 1050 Public Affairs 369,639 322,798 487,178 916,629 1055 Appropriation for Contingency 1060 Non Departmental - 151,555 566,103 (3,190,000) 2000 Engineering 2,896,186 2,628,098 3,846,427 4,428,604 2005 Building & Code Enforcement 2,781,480 2,731,238 3,463,909 3,691,966 2010 Planning Services 2,256,590 2,220,909 2,759,936 3,409,596 2300 Community and Economic Development 2,014,881 1,870,968 8,246,045 15,808,122 2305 Homeless Program 456,245 237,493 10,546,506 26,180,000 2310 Rent Control 70,910 82,669 97,606 114,155 2315 Neighborhood Development 188,507 179,658 230,119 251,738 2500 GPSCVB 456,164 548,582 595,000 1,115,000 2505 Visitor Information Center 4,343 - 197,000 255,809 2510 Tourism 2,042,641 1,636,474 2,014,000 2,405,443 2515 Special Events and Contributions 542,777 12,150 500,000 500,000 2520 Special Contributions 34,483 - - - 2525 Film Fest Sponsorship 350,000 - 350,000 350,000 2530 Special Contributions - PS Resorts 204,954 - 225,000 225,000 2535 Chamber of Commerce 86,382 32,267 180,352 - 2540 Convention Center 2,594,682 2,760,638 3,179,229 2,936,859 2545 Plaza Theater 29,891 203,716 301,150 2,166,337 3055 Special Development Tracts 55,093 44,124 1,679,747 - 4000 Library 2,464,050 2,225,816 2,895,049 3,249,404 4005 Library - Welwood 64,703 20,965 169,325 190,702 4472 Parking Structure Maintenance - 97,840 153,054 169,145 6515 Street Maintenance 1,691,775 1,387,755 2,184,696 2,687,169 6520 Downtown Experience Maintenance 1,444,728 1,283,783 1,564,856 2,039,250 6525 Street Cleaning - 20,270 26,400 26,400 6530 Street Lighting 888,813 928,453 1,042,029 1,276,104 6535 Railroad Station 17,362 26,407 56,960 56,590 6545 Parking Structure/Control 314,233 56,081 - - 8000 Master Lease 1,433,980 1,641,692 1,641,692 1,641,700 Subtotal - General Government 41,171,900 36,265,793 71,763,751 100,035,513 Police 5000 Police Administration 30,076,000 28,845,693 33,629,614 40,083,050 5005 Jail Operations 365,384 261,359 386,337 438,741 5010 Animal Control 442,428 329,455 466,782 562,506 5015 Animal Shelter 1,139,827 989,707 1,069,902 1,157,402 5020 Code Compliance 969,347 1,119,307 1,747,328 2,058,262 5025 Dispatch Center 1,490,109 1,575,452 1,654,192 2,174,752 Subtotal - Police 34,483,096 33,120,972 38,954,156 46,474,713 Expenditure Summary - All Funds 30 06-16-2022 Additional Material Item 3D - 32 Dept #Department Description FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 ACTUALS ACTUALS REVISED BUDGET PROPOSED BUDGET Expenditure Summary - All Funds Fire 6000 Fire Administration 18,523,495 19,103,529 21,551,708 26,663,885 6005 Emergency Management 134,019 44,501 124,250 167,545 Subtotal - Fire 18,657,514 19,148,030 21,675,958 26,831,430 Parks and Recreation 6540 Park Maintenance 3,726,800 3,005,831 4,584,373 5,819,428 4500 Recreation 2,076,406 1,716,622 2,475,212 3,605,188 4505 Tennis and Pickleball 2,797 94,578 150,000 162,610 4510 Skate Park 174,708 87,600 114,366 166,366 4515 Swim Center 765,624 732,325 1,041,706 1,166,459 4520 Demuth Community Center 349,894 303,167 515,671 672,281 4525 James O Jessie DHUC 733,359 733,400 972,218 1,059,884 4530 Village Fest 487,254 228,754 509,479 682,104 Subtotal - Parks and Recreation 8,316,842 6,902,278 10,363,026 13,334,320 1070 PERS Futre Cost Reserve - - 6,000,000 6,000,000 Subtotal - PERS - - 6,000,000 6,000,000 Subtotal - General Fund 102,629,353 95,437,073 148,756,890 192,675,976 Transfers 1116 Budget Transfer - Out 24,074,841 18,622,268 10,095,765 26,723,220 Total General Fund 126,704,194 114,059,341 158,852,655 219,399,196 TB Small Hotel TBID 361,006 514,182 1,490,287 700,000 TOTAL 119 TB Small Hotel TBID 361,006 514,182 1,490,287 700,000 FA Fortified Assets 2,977 - 245,022 239,315 TOTAL 120 FA Fortified Assets 2,977 - 245,022 239,315 SA PD Safety Augmentat 398,745 429,259 444,381 493,557 SA Safety Augmentation 385,578 645,796 526,923 777,531 TOTAL 121 Safety Augmentation Fu 784,323 1,075,055 971,304 1,271,088 CSA 152 Street Cleanin 424,906 311,652 459,100 335,668 TOTAL 124 CSA 152 Street Cleanin 424,906 311,652 459,100 335,668 RF Recycling 404,761 315,001 624,468 693,398 TOTAL 125 Recycling Fund 404,761 315,001 624,468 693,398 Parking In-Lieu CIP 200 - - - TOTAL 132 Parking In-Lieu CIP 200 - - - 31 06-16-2022 Additional Material Item 3D - 33 Dept #Department Description FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 ACTUALS ACTUALS REVISED BUDGET PROPOSED BUDGET Expenditure Summary - All Funds Special Gas Tax Improv 485,571 743,862 1,958,637 1,798,278 TOTAL 133 Special Gas Tax Improv 485,571 743,862 1,958,637 1,798,278 Measure A Improvements 2,772,220 1,095,300 619,500 - Measure A Improvements 6,420 34,825 391,588 16,739 MAI Regional Measure A 4,410,423 1,504,065 7,077,413 3,832,736 MAI Local Measure A 743,166 2,011,993 4,478,760 5,924,441 Budget Transfer Out TOTAL 134 Measure A Improvements 7,932,229 4,646,183 12,567,261 9,773,916 DF North Zone Drainage 168,321 81,521 251,363 330,000 DF Central Zone Draina 4,863 18,610 333,440 250,000 DF South Zone Drainage 47,531 58,376 230,750 230,000 DF East Zone Drainage - - 10,000 10,000 DF Southeast Zone Drai 5,431 - 25,160 25,160 DF Eagle Canyon Draina - - 1,455 1,455 TOTAL 135 Drainage Fund 226,146 158,506 852,169 846,615 ERF Emergency Response 1,035,596 1,040,530 1,042,373 1,043,627 TOTAL 136 ERF Emergency Response 1,035,596 1,040,530 1,042,373 1,043,627 CDBG Grants 324,259 1,039,612 1,193,182 1,289,197 TOTAL 137 CDBG Grants 324,259 1,039,612 1,193,182 1,289,197 Sustainability Fund - - - - SF Sustainability 1,054,489 197,885 754,309 584,189 TOTAL 138 Sustainability Fund 1,054,489 197,885 754,309 584,189 CFD Public Safety #1 F 1,200,000 - - - CFDPS Police 312,002 317,927 538,588 588,353 CFDPS Fire 287,666 290,268 312,890 322,909 TOTAL 140 CFD Public Safety #1 F 1,799,668 608,195 851,478 911,262 LLPM Land/Lite/Park Ma 191,681 172,117 1,204,555 509,983 TOTAL 141 LLPM Land/Lite/Park Ma 191,681 172,117 1,204,555 509,983 SB1 RMRA Road Maint Re 1,623,523 65,153 1,423,134 1,088,536 TOTAL 142 SB1 RMRA Road Maint Re 1,623,523 65,153 1,423,134 1,088,536 CFD Canyon View 5,056 13,046 16,700 16,700 TOTAL 143 CFD Canyon View 5,056 13,046 16,700 16,700 Air Quality Management 41,219 51,694 50,000 101,929 TOTAL 149 Air Quality Management 41,219 51,694 50,000 101,929 Public Arts Fund 240,200 314,869 567,621 401,334 TOTAL 150 Public Arts Fund 240,200 314,869 567,621 401,334 32 06-16-2022 Additional Material Item 3D - 34 Dept #Department Description FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 ACTUALS ACTUALS REVISED BUDGET PROPOSED BUDGET Expenditure Summary - All Funds Library Endowment Fund 102,653 176,671 1,791,860 1,801,860 TOTAL 151 Library Endowment Fund 102,653 176,671 1,791,860 1,801,860 Quimby Act Fund 1,251,719 2,304,119 2,766,087 150,000 TOTAL 152 Quimby Act Fund 1,251,719 2,304,119 2,766,087 150,000 SP Engineering 966 - - - SP Legal Fees 24,557 2,584 - - Special Projects 1,500 - 2,995,000 100,000 SP Professional Review 5,447 9,800 - - SP Community Donation 73,947 49 - - SP Recreation 609 - - - SP PD Administrative 202,801 87,670 100,000 - SP FD Administrative 15,219 98 - - TOTAL 160 Special Projects 325,046 100,201 3,095,000 100,000 Measure J Capital Proj - - - - MJ Finance - - - 699,735 MJ Budget Transfer Out 8,343,940 10,550,000 1,402,832 5,138,500 MJ Measure J Capital P 3,259,126 6,906,789 14,296,659 26,396,150 MJ Measure J Downtown 845,962 543,779 1,490,828 400,000 MJ Measure J Streets 1,937,755 1,707 8,998,293 - MJ Community Project H 1,341,899 755,514 3,147,801 - MJ Measure J Airport P 55,000 - 1,095,000 200,000 TOTAL 260 Measure J Capital Proj 15,783,681 18,757,788 30,431,413 32,834,385 CP Appropriation for C - - - - CP Budget Transfer Out 2,356,070 4,200,000 - - CP City Facility Impro 2,690,564 1,209,011 6,700,679 1,351,162 CP Fire Improvements 36,515 290,843 364,486 364,486 CP Street Improvements 2,270,884 3,307,830 21,408,076 36,353,844 CP Land Acquisition 36,520,000 - - - CP Park Improvements 36,482 - 207,737 3,000,000 CP Administrative 154,864 60,190 132,100 3,632,100 CP Street Maintenance 3,041,955 - - - TOTAL 261 Capital Projects Fund 47,107,333 9,067,874 28,813,077 44,701,592 Debt Service Fund 1,171,649 - - - DSF Budget Transfer Ou 1,039,158 - - - DSF Cal Energy Loan 89,342 - - - DSF Convention Center 4,690,994 4,692,669 4,690,819 4,667,900 DSF Police Building & 135,418 135,283 135,552 135,200 DSF Parking Structure 602,750 647,650 652,825 662,150 DSF Measure J Debt Ser 3,185,963 37,467,516 1,402,832 3,138,500 DSF Chevron/Opterra - 1,174,191 1,180,376 1,215,346 DSF Local Measure A De 1,099,950 1,095,250 619,500 - DSF Pension Obligation - 1,537,386 1,598,700 1,659,915 TOTAL 301 Debt Service Fund 10,843,575 46,749,945 10,280,604 11,479,011 A.D. 143 Debt Service 17,063 - - - TOTAL 311 A.D. 143 Debt Service 17,063 - - - A.D. 146 Debt Service 3,914 - - - 33 06-16-2022 Additional Material Item 3D - 35 Dept #Department Description FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 ACTUALS ACTUALS REVISED BUDGET PROPOSED BUDGET Expenditure Summary - All Funds TOTAL 313 A.D. 146 Debt Service 3,914 - - - A.D. 159 Debt Service 2,887 - - - TOTAL 322 A.D. 159 Debt Service 2,887 - - - A.D. 2015-1 - - - - A.D. 2015-1 559,338 549,849 562,525 565,628 TOTAL 328 A.D. 2015-1 559,338 549,849 562,525 565,628 Airport Customer Facil 99,841 99,841 150,000 2,000,000 TOTAL 405 Airport Customer Facil 99,841 99,841 150,000 2,000,000 Airport Passenger Char 9,330 - - - APC Series 2008 Debt S 319,651 - - - APC Series 2019 Debt S 1,278,787 756,289 3,023,000 2,521,000 APC PFC Funds 5,233,800 12,163,646 - - TOTAL 410 Airport Passenger Char 6,841,567 12,919,936 3,023,000 2,521,000 Airport Fund - - - - AF Budget Transfer Out 3,447,947 - - 5,381,078 AF Administration 4,693,872 3,986,813 5,412,490 6,296,049 AF Security 2,776,294 2,825,144 3,023,764 3,138,357 AF Airside Operations 1,844,219 1,660,134 977,500 1,054,902 AF Rescue - Fire 3,497,785 3,815,758 3,619,226 4,237,176 AF Landside Operations 1,320,747 1,131,673 1,548,400 1,516,675 AF Grounds Maintenance 539,687 405,867 721,600 662,081 AF Terminal Building O 6,902,349 6,579,342 6,680,630 7,032,956 AF Control Center Ops 3,737,818 3,422,265 4,132,397 4,285,199 AF Customs 203,876 250,562 212,900 276,484 AF Capital Projects - - - - TOTAL 415 Airport Fund 28,964,593 24,077,558 26,328,906 33,880,956 Airport Capital Projec - 50,907 - - ACPF Airport Capital P 2,657,499 6,434,547 6,124,660 3,868,000 ACPF Grants - 399,486 23,043,102 8,170,000 ACPF PFC Funds - - 18,285,918 - TOTAL 416 Airport Capital Projec 2,657,499 6,884,940 47,453,680 12,038,000 WWTP Wastewater 8,801,886 8,940,635 43,147,719 22,106,184 TOTAL 420 Wastewater Treatment P 8,801,886 8,940,635 43,147,719 22,106,184 GCF Operations & Maint 5,188,033 4,786,834 5,544,868 5,564,231 TOTAL 430 Golf Course Fund 5,188,033 4,786,834 5,544,868 5,564,231 FL Fleet 4,240,818 4,109,745 8,100,273 9,194,326 TOTAL 510 Fleet Services Fund 4,240,818 4,109,745 8,100,273 9,194,326 FM Facilities Maintena 4,704,885 4,195,366 5,381,734 6,383,874 TOTAL 520 Facility Maintenance F 4,704,885 4,195,366 5,381,734 6,383,874 34 06-16-2022 Additional Material Item 3D - 36 Dept #Department Description FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 ACTUALS ACTUALS REVISED BUDGET PROPOSED BUDGET Expenditure Summary - All Funds Employee Retirement Be 22,037,804 23,378,993 22,411,781 25,894,000 TOTAL 530 Employee Retirement Be 22,037,804 23,378,993 22,411,781 25,894,000 RM Employee Benefits 9,292,164 8,968,465 10,090,427 10,120,737 RM Workers Compensatio 2,354,402 5,095,065 4,132,415 4,529,481 RM Liability Insurance 3,625,964 6,582,093 4,442,745 4,254,337 RM Property Insurance 914,337 1,187,260 1,484,025 1,100,000 RM Emergency Disaster 361,454 375,294 - - RM Unemployment 23,314 132,240 253,900 253,900 RM Emergency Managemen 189,989 418,075 - - TOTAL 540 Risk Management Fund 16,761,623 22,758,491 20,403,512 20,258,455 Retiree Health Insuran 3,059,780 3,308,320 3,980,682 3,980,682 TOTAL 541 Retiree Health Insuran 3,059,780 3,308,320 3,980,682 3,980,682 EF Energy Administrati 529,059 705,549 155,100 157,100 EF Sunrise Plaza COGEN 638,404 484,157 420,096 431,142 EF Municipal Complex C 1,585,926 1,500,156 1,587,700 1,770,200 EF Energy Development - 66 - - TOTAL 550 Energy Fund 2,753,389 2,689,929 2,162,896 2,358,442 Merged #1 Cap Successo 235,629 265,771 250,000 381,833 TOTAL 870 Energy Fund 235,629 265,771 250,000 381,833 Housing Successor (68) - - - Housing Successor 313,193 145,251 3,940,110 2,501,565 TOTAL 874 Housing Successor 313,125 145,251 3,940,110 2,501,565 Successor Agency Debt - - - - Successor Agency Debt - - - - Successor Agency Debt 1,327,604 1,424,019 2,808,550 2,446,600 TOTAL 879 Successor Agency Debt 1,327,604 1,424,019 2,808,550 2,446,600 327,603,225 323,018,954 457,952,531 484,146,855 35 06-16-2022 Additional Material Item 3D - 37 City of Palm Springs FY 2022-23 Budget Interfund Transfers FY 2022-23 36 06-16-2022 Additional Material Item 3D - 38 City of Palm Springs FY 2022-23 Budget FY22-23 FY22-23 Budget Budget TRANSFERS TRANSFERS IN OUT GENERAL FUND (100) To Debt Service Fund (301) Police Building and Others -135,500 Parking Structure -662,150 Opterra -1,215,400 Convention Center -4,667,900 To Sustainability Fund (138)-140,578 To Facilities Maintenance Fund (510)-6,817,500 To Fleet Vehicle Fund (520)-5,824,770 To Equip Replacment (570)-1,500,000 To Capital Projects Fund (261)-5,500,000 To Golf Course Fund (430)-400,000 From Measure J (260)1,000,000 - Sub Total General Fund 1,000,000 26,863,798 MEASURE A FUND (134) To Debt Service Fund (301)- - SUSTAINABILITY FUND (138) From General Fund (100)140,578 - MEASURE J CAPITAL (260) To Debt Service Fund (301)-3,138,500 To General Fund (001)-1,000,000 To Capital Fund (261)-1,000,000 CAPITAL PROJECTS FUND (261) From General Fund (100)5,500,000 - From Measure J Capital Fund (260)1,000,000 - DEBT SERVICE FUND (301) From General Fund (100)6,680,950 - From Measure J Capital Fund (260)3,138,500 - GOLF COURSE FUND (430) From General Fund (001)400,000 - MOTOR VEHICLE FUND (510) From General Fund (001)5,824,770 - FACILITIES MAINTENANCE FUND (520) From General Fund (001)6,817,500 - EQUIPMENT REPLACEMENT FUND (570) From General Fund (100)1,500,000 - 32,002,298$ 32,002,298$ 37 06-16-2022 Additional Material Item 3D - 39