Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
5/9/2017 - STAFF REPORTS - 1.A.
Commissioner Recommendation Summary list Commissioner Majority Recommendations Total Votes 1 Fire Station #4 6 1,700,000 13 Police Department Remodel 6 500,000 2a Bollards - Phase 1 (La Plaza) 6 300,000 12 NPC Crosswalks 6 200,000 2,700,000 Other Commissioner Recommendations Citywide IT Hardware 2 300,000 9a Plaza Theater Design 2 500,000 15 PC Electrical Upgrade 2 400,000 4 City Facilities Upgrades 2 250,000 16 Bicycle Lanes 1 75,000 14 HVAC Replacement (City Facilities) 1 100,000 5 &6 Belardo Parking Structure Repairs and Maintenance 1 90,000 is Main Library Paint and Repairs 1 350,000 7 Downtown Trash Receptacle replacements 1 100,000 10 Server A/C Units 1 70,000 3 JCJ DHUC Gym floor replacement 1 89,061 26 Dowtown Holiday Lighting 1 100,000 8 Downtown News racks - replace and match 1 60,000 23 City Hall Landscape Renovation 1 100,000 9 Fire- Mobil Data Transmitters for software fire 000 hydrants/buildings 1 28 , 2b Bollards Downtown Phase 2 1 1,500,000 Total Votes 44 Item S.A. Commissioner Recommendations List - Page 1 of 1 April 20, 2017 PRELIMINARY BUDGET FY 2017- 18 O F VALM S p4� y V N b�Wro �f CQl1FO0.N�P. A ft ..; City Council Meeting - April 19, 2017 City of Palm Springs Table of Contents Carryover I Recommended Budget Summary Operating Fund Page 1-2 Revenue Operating Fund Page 3 Appropriation Operating Fund Page 4 General Fund Page 5-6 Incorporated Position Modifications Page 7-8 Recommended Additional Positions Page 9 Requested Positions for Consideration Page 10 Special Revenues Page 11-12 Master Lease, Debt, Assessments, Capital Page 13 Capital Continued Page 14 Enterprise Continued & Internal Service Funds Page 15 Internal Services Continued Page 16 Special Events from 2016-17 Page 17-18 Fund 125 - Recycling Summary Page 19 Fund 127 - Villagefest Summary Page 20 Fund 138 - Sustainability Summary Page 21 Fund 149 - Air Quality Management District (AQMD) Page 22 Fund 150 - Public Arts Summary Page 23 Fund 420 - Waste Water Treatment Plant Page 24 Fund 430 - Golf Course Page 25 Fund 510 - Fleet I Motor Vehicle Reserve Page 26 Fund 260 - Measure J Fund Page 27 Funds 261, 133, 134, 135 - Capital Improvement Summary Page 28 City of Palm Springs 4113/2017: 1:09 PM BUDGET CALENDAR April 19, 2017 All Funds Preliminary Budget May 3, 2017 Continued Budget Discussion May 9, 2017 Town Hall Meeting / Study Session May 17, 2017 Budget Study Session June 7, 2017 Public Hearing &Adoption of Budget FY 17-18 June 21, 2017 Adoption of Budget (if needed) City of Palm Springs 411 312 01 7: 1:09 PM BUDGET OVERVIEW CARRYOVER BUDGET PRELIMINARY FY 2017-18 BUDGET SUMMARY FUNDS AVAILABLE Revenue Property Tax 22,550,000 TOT 29,660,000 Sales Tax 12,375,517 Measure J Sales Tax 13,400,000 Utility Users Tax 7,200,000 Franchise Fees 3,200,000 Motor Vehicle License Fees 4,200,000 Administrative Service Charges 2,126,798 Business License 950,000 Building Permits 1,300,000 All Other 11,341,620 Total Revenue 108,303,935 Transfers In From: Gas Tax (133) 600,000 Airport General Operations (415) 287,500 Total Transfer In 887,500 Total Operating Funds Available 109,191,435 FUNDS REQUIRED Appropriations 92,235,218 Transfer Out To: Debt Service- Police Building 152,542 Chevron/Opterra 1,094,850 Parking Structure 569,900 Total Transfers for Debt 1,817,292 Public Safety- CFD(140) 80,000 Parking Fund - Operations (131) 40,000 Emergency Response Fund (136) 10,000 Capital Projects (260) 0 Capital Projects- Measure J (261) 13,400,000 Golf Course (430) 1,135,000 Total Transfer Out 16,482,292 Total Operating Funds Required 108,717,510 Operating Surplus (Deficit) 473,925 Estimated Reserve Before Recommended Additions 19,853,733 Reserve as a % 20.83% City of Palm Springs FY 2017-18 Page 1 BUDGET OVERVIEW RECOMMENDED BUDGET PRELIMINARY FY 2017-18 Operating Surplus (Deficit) 473,925 Recommendations' Personnel Additions (821,370) Reserve Drawdown (347,445) Estimated Reserve Aker Recommended Additions 19,032,363 Reserve as a % 19.80/o City of Palm Springs FY 2017-18 Page 2 BUDGET OVERVIEW OPERATING FUNDS REVENUES FY 2017-18 MAJOR OPERATING FUND REVENUES The following graph and schedule identify the major sources of revenue for the 2017-18 adopted operating budget. 2017-18 Revenues as a Percent of Total 15% 21% 4% ■Property Taxes 3112% ■Sales&Use Taxes ■Transient Occupancy Tax(TOT) 11% ■Measure J Sales Tax 7% ■Utility Users Tax ■Franchise Fees ■Motor Vehicle In Lieu Tax ■All Other Sources 27% MAJOR OPERATING FUND REVENUES ADOPTED ADOPTED ADOPTED % CATEGORY 2016-16 2016-17 2017-18 CHANGE Property Taxes 18,716,328 20,892,100 22,550,000 7.9% Sales & Use Taxes 12,172,889 12,040,686 12,375,517 2.8% Transient Occupancy Tax (TOT) 26,000,000 26,200,000 29,660,000 13.2% Measure J Sales Tax 13,300,000 13,100,000 13.400,000 2.3% Utility Users Tax 7,250,000 7,500,000 7,200,000 -4.0% Franchise Fees 3,000,000 3,100,000 3,200,000 3.2% Motor Vehicle In Lieu Tax 3,481,240 4,219,000 4,200,000 -0.5% All Other Sources 12,706,639 14,696,139 15,718,418 7.0% TOTALS $ 96,627,096 $ 101,747,925 $ 108,303,935 6.4% City of Palm Springs FY 2017-18 Page 3 BUDGET OVERVIEW OPERATING FUND APPROPRIATIONS FY 2017-18 OPERATING FUND APPROPRIATIONS The following graph and schedule identify the major appropriations for the FY 2017-18 adopted operating budget. 2017-18 Appropriations as a Percent of Total 3% 7% ■Administration 9% ■Growth Management ■Quality of Life ■Public Safety ■Public Works&Engineering 11% ■Marketing&Tourism ■Contractual Obligations— 46". �. MAJOR OPERATING FUND APPROPRIATIONS BY CATEGORY ADOPTED ADOPTED ADOPTED % CATEGORY 2016-16 2016-17 2017-18 CHANGE Administration 10,881,351 12,026,080 14,228,358 18.3% Growth Management 5,905,555 6,529,848 7,961,915 21.9% Quality of Life 8,644,641 9,613,414 10,332,315 7.5% Public Safety 38,339,690 41,133,721 42,743,594 3.9% Public Works & Engineering 6.410,861 6,708,601 6,707,536 0.0% Marketing & Tourism 2,436,500 2,436,500 2,436,500 0.0% Contractual Obligations** 8,511,825 8,446,370 8,646,370 2.4% TOTALS S 81,130,423 $ 86,894,534 $ 93,056.588 7.1% ** Debt Service included in Convention Center (2180) City of Palm Springs FY 2017-18 Page 4 CITY OF PALM SPRINGS FY 17-18 PRELIMINARY BUDGET DETAIL Line Fund Dept FY 16-17 Personnel Materials,Supp Special Debt Capital FY 17.18 Line No. No. No. Fund/Department Name TOTAL Costs &Services Cha es Service TOTAL No. 1 001 1010 City Council 696,817 384,800 191250 90.277 0 0 666,327 1 2 1100 Administration 1,074,458 1.347,773 26,700 96,595 0 0 1,471.068 2 3 1114 Neighborhood Involvement 193,759 145,581 13,650 2,381 D 0 161,612 3 4 1120 Information Technology 1,652,732 1,002,218 522,000 164,168 0 0 1,688,386 4 5 1150 City Clerk 1,261,487 720,370 342.270 56,566 0 0 1,119,206 5 6 1155 Vacation Rental 612,025 1,159.367 418,633 42.000 0 80.000 1,700,000 6 7 1160 Human Resources 498,268 311,296 155,850 41,864 0 0 509,010 7 8 1180 Rent Control 75,906 32,571 6,460 31,630 0 0 70,661 8 9 1200 City Attorney 805,434 362,263 474,681 234 0 0 837,178 9 10 1220 Unallocated Compensation 1,000,000 1,000,000 0 0 0 0 1,000,000 10 11 1231 Public Affairs/PSCTV 400,713 256,772 147,100 3,474 0 0 407346 11 12 1261 Document Management 277,975 0 223,520 54,455 0 0 277:975 12 13 1300 Finance Administration 2,932.366 2,273,085 450,704 201,740 0 0 2,925,529 13 14 1330 Procurement 5".140 455,351 60,500 41,089 0 0 556,940 14 15 1440 Community&Economic Development 1.228,283 571,767 2,036,045 125,879 0 354,57-7 3,OW8 268 15 16 1402 Homeless Program 465,000 0 465,000 0 0 0 465,0D0 16 17 2101 GPSCVB Convention I Visitor Center 510,000 0 540,000 0 0 0 540,000 17 18 2116 Visitor Info Center 5,000 0 5.000 0 0 0 5.000 18 19 2117 Tourism 2,014,000 0 2,014,000 0 0 0 2,014,000 19 20 9001 Increased Energy Costs 0 0 400,000 0 0 0 400,000 20 20 9001 Internal Service Overhead(to be allocated 0 0 437,120 0 0 0 437,120 20 21 2118 Special Events 323,500 0 323,500 0 0 0 323.500 21 22 2119 Special Contributions 94,000 0 94,000 0 0 0 94,000 22 23 2120 Event Sponsorship(PS Intl Film Festival) 350,000 0 350,000 0 0 0 350,000 23 24 2180 Convention Center 7,560,370 0 2,437,500 20D,650 5,092,220 0 7,730,370 24 25 2197 Plaza Theater 26,OD0 0 26,000 0 0 0 26,000 25 26 4151 Planning 1,793,614 1,469,320 249,300 114,310 0 0 1,832,930 26 27 4161 Building&Safety 3,042,951 2,400,238 465,740 174,739 0 0 3,040,717 27 28 4171 Engineering 2,986,685 1,778,165 847.095 242,295 0 1,000 2,868,555 28 29 2451 Parks Maintenance 3,536,562 645,243 2,634,130 312,409 0 0 3,591,782 29 30 2510 Recreation Administration 1,490,199 1,D50,812 259,644 216,432 0 0 1,526,888 30 31 2511 Tennis Center 22,502 0 22,502 0 0 0 22,502 31 32 2512 Palm Springs Skate Park 160,000 0 160,000 0 0 0 160,000 32 33 2515 Swim Center 665,898 583,024 78,059 60,704 0 0 721,787 33 34 2516 Demuth Community Center 258,648 144,266 109,700 6,711 0 0 260,677 34 35 2590 James O.Jessie Desert Highland Unity 700.383 %8,728 98,300 51,212 0 0 718,240 35 36 2710 Library 2,452,722 1,772,029 616,370 150,540 0 0 2,536,939 36 37 2711 Library-Welwood 326,500 0 326,500 0 0 0 326,500 37 38 3010 Police Administration&Enforcement 23,266,217 20,569,899 1,224,721 2,330,474 0 0 24,125,094 38 39 3011 Jail Operations 347,726 232,866 205.000 14,316 0 0 452,182 39 40 3304 Animal Control 396,645 379,988 20,691 27,957 0 0 428.636 40 41 3305 Animal Shelter 1,230,506 0 1,217,703 32,937 0 0 1,250,640 41 42 3400 Dispatch Center 1,291770 1,072705 49,250 35,567 0 0 1,157,522 42 43 General Fund Continue 43 GENERALFUND City of Palm Springs FY 2017-18 Page 5 CITY OF PALM SPRINGS _ FY 17-18 PRELIMINARY BUDGET DETAIL Line Fund Dept. FY 16-17 Pneomtel Matstialsr Supp Special Debt Capital FY 17-18 Line No. No. No. FundlDe artmentName TOTAL costs &Services Charoe Service TOTAL No. 44 3520 Fire Administration 14,445,103 13,477,726 599,124 1,065.416 0 29000 15.171.266 44 45 3522 Emergency Management 155,754 22,926 135.328 0 0 0 158,254 45 46 4201 Street Maintenance 1,548.154 1,057,626 313,700 281,488 0 0 1,652,814 46 47 4210 Downtown Experience Maintenance 1,352,557 1,105,676 244.346 14.940 0 0 1.364,962 47 48 4240 Street Cleaning 26,400 0 26,400 0 0 0 26,400 48 49 4301 Street Lighting 704,017 0 105,000 599,017 0 0 704,017 49 50 4471 Railroad Station 90.788 0 80.300 488. 0 10.000 90,788 50 51 TOTAL GENERAL FUND 86,894,534 58,364,451 22,250,386 6,884,954 5,092,220 474,577 93,056,588 51 GENERALFUND City of Palm Springs FY 2017-18 Page 6 FY 2017-2018, List#1 CITY OF PALM SPRINGS Incorporated Position Modifications FY 2017-18 PERSONNEL Salary& Requesting Department Fund Dept Title FTE Salary Benefits GENERAL FUND Information Technology Addition 001 1120 Help Desk Technician (IT) 1.00 51,800 87,727 Addition 001 1120 IT Technician 1.00 61,592 100,417 Addition 001 1120 IT Technician 1.00 61,592 100,417 Delete 001 1120 Senior PC/Network Administrator-Cert (1.00) (133,698) (199,795) Reclass 001 1120 Information Technology Supervisor 1.00 140,393 208,472 Delete 001 1120 Senior Systems/Network Admin-Cent (1,00) (133,698) (193,407) Reclass 001 1120 Information Technology Supervisor 1.00 140,393 202,094 Delete 001 1120 Information Technology Manager-Cert (1.00) (143,796) (213,010) Delete 001 1120 Communication Coordinator (1.00) (82,828) (117,950) Total-Increase/(Decrease) 1.00 (38,250) (25,047) Planning Delete 001 4151 Development Services Representative 1.00 53,311 79,811 Reclass 001 4151 Permit Center Technician 1.00 57,442 85,165 Total-Increase/(Decrease) 0.00 4,132 5,354 Human Resources Promotion-General Fund portion onl 001 1160 Human Resource Specialist I, BL 0.50 32,947 55,059 Promotion-General Fund Portiononl 0011160 Senior Human Resource Specialist, BL 0.50 35,178 57,950 Total- Increase/(Decrease) (Position sits in Funds 001 and 520) 0.00 2,231 2,891 Swim Center Delete 001 2516 Lifeguard 1.00 31,579 61,523 Addition G01 2516 Lifeguard, Lead 1.00 43,587 77,084 Total-Increase/(Decrease) 0.00 12,007 15,560 Finance Delete 001 1300 Revenue Recovery Specialist&Parking Enf 1.00 66,292 106,508 Addition 001 1300 Account Clerk II 1.00 41,457 75,000 Total-Increase/(Decrease) 0.00 (24,835) (31,508) Recreation Delete 001 2510 Account Clerk (0.80) (41,270) (74,549) Reclass 001 2510 Program Coordinator 0.80 44,425 78,637 Delete 001 2510 Recreation Program Assistant (0.75) (32,690) (62,387) Increase FTE from .75 to 1.00 001 2510 Recreation Program Assistant 0.25 10,897 14,121 Increase FTE from .75 to 1.00 001 2510 Recreation Program Assistant 0.25 10,897 14,121 Total-Increase/(Decrease) (0.25) (7,742) (30,057) Demuth Increase FTE from .75 to 1.00 001 2516 Recreation Program Asst 0.25 8,541 12,386 Total -Increase/(Decrease) 0.25 8,541 12,386 City of Palm Springs FY 2017-18 Page 7 FY 2017-2018, List q1 CITY OF PALM SPRINGS Incorporated Position Modifications FY 2017-18 PERSONNEL Salary& Requesting Department Fund Dept Title FTE Salary Benefits James 0 Jessie DHUC Increase FTE from .50 to 1.00 001 2590 Recreation Program Assistant O.SO 21,793 28,242 Total - Increase/ (Decrease) O.So 21,793 28,242 TOTAL Position Modification/ Reorganization -General Fund 1.50 (22,1241 (22,178) City of Palm Springs FY 2017-18 Page 8 FY 2017-2018,List#2 CITY OF PALM SPRINGS Recommended Additional Positions FY 2017-18 PERSONNEL Salary& Requesting Department Fund Dept Title FTE Salary Benefits GENERAL FUND Police-Jail Operations Addition Dot 3011 Jail Transportation Officer 1.00 40,465 77,915 Addition 001 3011 Jail Transportation Officer 1.00 40,465 77,915 Addition 001 3011 Jail Transportation Officer 1.00 40,465 77,915 Total-increase/(Decrease) 3.00 121,396 233,744 Police-Administration Addition 001 3010 Police Services Officer 1.00 40,465 74,400 Addition 001 3010 Police Services Officer 1.00 40,465 74,400 Total-Increase/(Decrease) 2.00 80,931 148,800 City Attorney" Addition 001 1200 Paralegal 1.00 68,666 109,585 Total-Increase/(Decrease) 1.00 68,666 109,585 Street Maintenance lFacl Addition 001 4201 Street Maintenance Worker 1,00 41,457 74,324 Total-Increase/(Decrease) 1.00 41,457 74,324 Fire Addition 001 3520 Deputy Fire Chief of Operations 1.00 153,355 254,917 Total-Increase/(Decrease) 1.00 153,355 254,917 TOTAL City Manager Approved Positions-General Fund 8.00 465,905 822,369 *Offset by a reduction of legal expense budget in City Attorney Department. City of Palm Springs FY 2017-18 Page 9 FY 2017-18, List#3 CITY OF PALM SPRINGS Requested Positions for Consideration FY 2017-18 PERSONNEL Salary& Requesting Department Fund Dept Title FTE Salary Benefits GENERAL FUND Police-Administration Addition 001 3010 Secretary 1.00 39,474 71,754 Total-Increase/(Decrease) 1.00 39,474 71,754 Police-Downtown Addition 001 3010 Police Officer 1.00 86,508 184,920 Addition 001 3010 Police Officer 1.00 86,508 184,920 Addition 001 3010 Police Officer 1.00 86,508 184,920 Addition 001 3010 Police Officer 1.00 86,508 184,920 Total -increase/(Decrease) 4.00 346,032 739,679 Police- Traffic Addition 001 3010 Police Officer-Motor 1.00 68,296 131,782 Addition 001 3010 Police Officer-Motor 1,00 68,296 131,782 Addition 001 3010 Community Services Officer 1.00 46,953 82,807 Total-Increase/(Decrease) 3.00 183,545 346,371 Library Addition 001 2710 Librarian 1.00 59,229 96,755 Total-Increase/(Decrease) 1.00 59,229 96,755 Fire Addition 001 3520 Fire Battalion Chief 1.00 132,616 234,324 Addition 001 3520 Fire Prevention Captain 1.00 103,114 185,170 Addition 001 3520 Fire Fighter-Paramedic 6,00 506,209 828,084 Addition 001 3520 Fire Records Technician 1.00 46,953 82,807 Addition 001 3520 Public Information Officer 1.00 82,387 127,366 Total-increase/(Decrease) 10.00 871,280 1,457,751 TOTAL General Fund Requests 19.00 1,499,560 2,712,310 City of Palm Springs FY 2017-18 Page 10 CITY OF PALM SPRINGS FY 17-18 PRELIMINARY BUDGET DETAIL I Materials, Line Fund Dept. FY 16-17 Personnel Supplies Special Debt Capital FY 17-18 Line No. No. No. FundfDe artment Name TOTAL Costs &Services Charges Service TOTAL No. Fund 113 Plaza Theater 52 113 2199 Plaza Theater 0 0 C 0 0 0 0 52 0 53 53 TOTAL PLAZA THEATER 0 0 0 0 0 0 Fund 120 Forfeited Assets 54 120 3012 Forfeited Assets-Police 2.000 0 2,000 0 0 0 2,000 54 55 TOTAL FORFEITED ASSETS 2,000 0 2,000 0 0 0 2.000 55 Fund 121 Safety Augmentation 56 121 3013 Safety Augmentation-Police 474,018 385.185 0 48,307 0 0 433,492 56 57 3523 Safety Augmentation Fire 457.407 446,916 0 48,308 0 0 495.224 57 58 TOTAL SAFETY AUGMENTATION 931,425 832,101 0 96,615 0 0 928.716 58 Fund 124 CSA 152 59 124 4242 CSA 152- Street Cleaning 656.312 58,269 386,200 10,456 0 0 454,925 59 60 TOTAL CSA 152 656,312 58.269 386,200 10,456 0 0 454,925 60 Fund 125 Recycling 61 125 1280 Recycling 292.283 48,566 61,650 22,271 0 73,869 206,356 61 62 TOTAL RECYCLING 292,283 48,566 61,650 22,271 0 73,869 206,356 62 Fund 127 Villagefest 63 127 2550 Villagefest 504.600 346,234 71,256 88,064 0 0 505,554 63 64 TOTAL VILLAGEFEST 504,600 346,234 71,256 88,064 0 0 505,554 64 Fund 131 Parking 65 131 4461 Parking Control 241.459 11,860 189,700 39,899 0 0 241,459 65 66 4464 Structure Maintenance 142.164 0 90,000 52,164 0 0 142,164 66 67 TOTAL PARKING CONTROL 383,623 11,860 279,700 92.063 0 0 383,623 67 Fund 132 Parking Capital Programs 68 132 4462 Parking Projects&Programs 2.000 0 1,819 181 0 0 2.000 68 69 TOTAL PARKING CAP. PROGRAMS 2,000 0 1,819 181 0 0 2,000 69 Fund 136 911 Emergency Response 70 136 1291 911 Emergency Response 1.416,346 672,931 395,000 0 348,415 0 1,416,346 70 71 TOTAL 911 EMERGENCY RESP. 1,416.346 672,931 395,000 0 348,415 0 1,416,346 71 Fund 137 Community Dev.Block Grant 72 137 4819 CD Block Grant 387,462 34,431 35.724 7,337 0 309,970 387,462 72 73 TOTAL COMMUNITY DEV 387.462 34,431 35,724 7,337 0 309,970 387,462 73 74 SUBTOTAL $4,576,051 $2,004,392 $1.233,349 $316,987 $348,416 $383,839 $4,286,982 74 SPECIAL REVENUE FUNDS CONTINUE City of Palm Springs FY 2017.18 ?aye 11 CITY OF PALM SPRINGS FY 17-18 PRELIMINARY BUDGET DETAIL Materials, Line Fund Dept. FY 16-17 Personnel Supplies Special Debt Capital FY 17-18 Line No. No. No. Fund/Department Name TOTAL Costs &Services Charges Service TOTAL No. Fund 138 Sustainabllity 75 138 1270 Sustainability 383.028 48.528 14,150 32,493 0 4.250 99421 75 76 TOTAL SUSTAINABILITY 383,028 48,528 14,150 32,493 0 4,250 99,421 76 Fund 140 CFD Public Safety 91 77 140 3026 CFD Public Safety Police 450,071 342,982 12,000 61,522 0 0 416.504 77 78 140 3526 CFD Public Safety Fire 273,632 241,254 10.000 29,713 0 0 280.967 78 '. 79 TOTAL CFD PUBLIC SAFETY 723,703 584,236 22,000 91,235 0 0 697,471 79 j Fund 141 Land/Light/Park Maint Dist 80 141 4609 Land/Light/Park Maint Dist 356,941 0 356,941 0 0 0 356,941 80 '.. 81 LANDILIGHT/PART/MAINT DIST 356,941 0 356,941 0 0 0 356,941 81 Fund 149 Air Quality Management 82 149 4609 Air Quality Management 57,600 0 57,600 0 0 0 57,600 82 83 TOTAL AIR QUALITY 57,600 0 57,600 0 0 0 57,600 83 Fund 150 Public Arts 84 150 4408 Art Acquisitions 348,280 73,575 170,001 15,621 0 91,000 350,197 84 85 TOTAL PUBLIC ARTS 348,280 73,575 170,001 15,621 0 91.000 350,197 85 Fund 151 Library Endowment 86 151 2752 Library Trust 8,600 0 100 0 0 8,500 8.600 86 87 TOTAL LIBRARY 8,600 0 100 0 0 8.500 8,600 87 Fund 152 Quimby Act Fees 88 152 2460 Quimby Park 8 Recreation 1.538,400 0 0 0 0 1.538,400 1,538400 88 89 TOTAL QUIMBY ACT FEES 1,538,400 0 0 0 0 1,538,400 1.538,400 89 Fund 160 Special Projects 90 4509 Police Special Projects 100,000 100,000 0 0 0 0 100,000 90 91 4523 Comm Donation Recreation 100,000 D 0 0 0 100,000 100,000 91 92 TOTAL SPECIAL PROJECTS 200,000 100,000 0 0 0 100,000 200.000 92 i Fund 170 Special Grants 93 170 3212 Police AB 109 175,000 168,376 61624 0 0 0 175,000 93 94 TOTAL SPECIAL GRANTS 175,000 168,376 6,624 0 0 0 175,000 94 95 TOTAL SPECIAL REVENUES $8,367,603 $2,979,107 $1,860,765 $456,336 $348,415 $2,125,989 $7,770,612 95 SPECIAL REVENUE FUNDS City of Palm Springs FY 2017-18 Page 12 CITY OF PALM SPRINGS FY 17-18 PRELIMINARY BUDGET DETAIL Materials, Line Fund Dept. FY 16-17 Personnel Supplies Special Debt Capital FY 17-18 Line No. No. No. FundIDepartment Name TOTAL Costs &Services Charges Service TOTAL No. Fund 139 Master Lease 96 139 7851 Master Lease 1,493,700 0 4'00S 0 1,489,700 0 1.493.700 96 97 TOTAL MASTER LEASE 1.493,700 0 4,000 0 1,489,700 0 1,493,700 97 Fund 301 Debt Service 98 301 7850 Cal Energy Loan 0 0 0 0 0 0 0 98 99 7852 Convention Center Debt 4,692,220 0 0 0 4,692,220 0 4,692,220 99 100 7868 Police Building&Other 152,883 0 700 0 152,183 0 152,883 100 101 7872 Parking Structure Debt 503,975 0 5,000 0 498,975 0 503,975 101 102 7878 Measure J Debt Service 3,200,000 0 8,837 0 3,191.163 0 3,200.000 102 103 7880 Chevron/Opterra 1,056.305 0 0 0 1.056,305 0 1,056,305 103 104 TOTAL DEBT SERVICE 9,606,383 0 14537 0 9,590,846 0 9,605,383 104 Fund 328 105 328 7879 A.D. 2016-1 105 106 A.D. 2015-1 731.420 0 45 000 0 686,420 0 731,420 106 107 TOTAL 2015-1 731,420 0 45.000 0 686,420 0 731,420 107 108 TOTAL DEBT SERVICE 11,830,603 0 63,537 0 111755,969 0 11,830,503 108 DEBT SERVICE-MASTER LEASE,DEBT&ASSESSMENTS Fund 133 Special Gas Tax Fund 109 133 4298 Improvements(2106 Funds) 605,441 0 1,750 0 0 495,503 497,253 109 110 TOTAL Special Gas Tax 605,441 0 1,750 0 0 495,603 497,253 110 Fund 134 Measure A Improvements 111 134 4495 Bond Construction Measure A 1,098.700 0 0 0 0 1,098,700 1,098,700 111 112 4497 Regional Measure A 0 0 0 0 0 0 0 112 113 4498 Local Measure A 955,300 0 0 0 0 907,300 907.300 113 114 TOTAL MEASURE A 2.054,000 0 0 0 0 2,006,000 2,006,000 114 DEBT SERVICE-MASTER LEASE,DEBT&ASSESSMENT FUNDS-SPECIAL GAS TAX,MEASURE A IMPROVEMENTS CAPITAL-SPECIAL GAS TAX,MEASURE A IMPROVEMENTS City of Palm Springs FY 2017-18 Page 13 CITY OF PALM SPRINGS FY 17-18 PRELIMINARY BUDGET DETAIL Materials, Line Fund Dept. FY 16.17 Personnel Supplies Special Debt Capital FY 17-18 Line No. No. No. FundfDepartment Name TOTAL Costs &Services Char es Service TOTAL No. Fund 135 Drainage Fund 115 135 4370 North Zone Drainage 100,000 0 0 0 0 100,000 100.000 115 116 4371 Central Zone Drainage 20,000 0 0 0 0 20,000 20,000 116 117 4372 South Zone Drainage 5,000 0 0 0 0 5,000 5,000 117 118 4373 East Zone Drainage 10,000 0 0 0 0 10,000 10,000 118 119 4374 Southeast Zone Drainage 1.500 0 0 0 0 1.500 1,500 119 120 4375 Eagle Canyon Drainage 0 0 0 0 0 0 0 120 121 TOTAL DRAINAGE 136,500 0 0 0 0 136,500 138,500 121 Fund 260 Measure J Capital Fund 122 260 1396 Downtown Maint./Other Exp. 425.000 0 450.000 0 0 0 450,000 122 123 4493 Measure J Streets 3,000,000 0 0 0 0 3,000,000 3,000,000 123 124 4494 Comm Proj Hot Spots 911,725 0 0 0 0 1,202,125 1,202,125 124 125 46M Capital Projects 5,563.275 0 0 0 0 5,797,120 5,797,120 125 126 TOTAL MEASURE J CAPITAL 9,900,000 0 450,000 0 0 9,999,245 10,449,245 126 Fund 261 Capital Projects Fund 127 261 1395 City Facility Improvements 1,086,500 0 0 0 0 86,500 86,500 127 128 3200 Police Improvements 0 0 0 0 0 0 0 128 129 3201 Police Grants 0 0 0 0 0 0 0 129 130 3600 Fire Improvements 700,000 0 0 0 0 0 0 130 131 4491 Street Improvements 0 0 D 0 0 0 0 131 132 2493 Park Improvements 0 0 0 0 0 0 0 132 133 TOTAL CAPITAL 1,786,500 0 0 0 0 86,500 88,500 133 134 TOTAL CAPITAL PROJECTS 14,482.441 0 451,750 0 0 12,723,748 13,175,498 134 CAPITAL CAPITAL FUNDS CONTINUE-DRAINAGE,MEASURE J,CAPITAL PROJECTS FUNDS City of Palm Springs FY 2017-18 Page 14 CITY OF PALM SPRINGS FY 17-18 PRELIMINARY BUDGET DETAIL Materials, Line Fund Dept. FY 16-17 Personnel Supplies Special Debt Capital FY 17-18 Line No. No. No. FundlDepartment Name TOTAL Costs 8 Services Charges Service TOTAL No. Fund 420 Wastewater Treatment Plant 156 420 68DO Wastewater Program 10,250,000 148,842 4,955.200 688,075 0 4,461.206 10,253,323 156 157 TOTAL WASTEWATER TREATMENT PLANT 10,250,000 148,842 4,955,200 688,075 0 4,461,206 10,253,323 157 Fund 430 Golf Course 158 430 7021 Resort Course Maint/Operations 4,563,485 0 4,480,218 12,167 0 71.100 4,563,485 158 159 7056 Resort Course Debt Service 942.267 0 0 0 942,267 0 942,267 159 160 TOTAL GOLF COURSE 5,505,752 0 4,480,218 12.167 942,267 71,100 5,505,752 160 161 TOTAL ENTERPRISE FUNDS 15,755,752 148,842 9,435,418 700,242 942,267 4,532,306 16,759,076 161 Fund 510 Fleet Operations 162 510 5470 Fleet Operations 2,952,247 961,350 1,756,227 135,790 0 60.000 2,913,367 162 163 5475 Fleet Reserves 790,386 0 49..660 0 240.726 500,0D0 790,386 163 164 TOTAL FLEET FUND 3.742,633 961,350 1,805,887 135,790 240,726 560,000 3,703,753 164 Fund 520 Facilities Maintenance 165 520 5641 Facilities Maintenance 4,751,962 1,963,084 2,801.973 171,725 0 0 4,936,782 165 166 TOTAL FACILITIES MNTNCE 4,751,962 1,963.084 2,801,973 171,725 0 0 4,936,782 166 Fund 530 Employee Retirement Benefits 167 530 5701 Employee Retirement Benefits 16.366.830 6.000 15,015.740 0 1,345,090 0 16,366,830 167 168 TOTAL EMPLOYEE RETIREMENT 16,366.830 6,000 15,015,740 0 1,345,090 0 16.366,830 168 Fund 640 Risk Management 169 540 5902 Employee Benefits 8,756,341 261,781 8,492,936 12,610 0 0 8.767,327 169 170 5903 Workers Compensation 3,568,923 460.918 3,121,156 27,522 0 0 3,609,596 170 171 59D4 Liability Insurance 1,169,796 0 1,145,581 46,427 0 0 1,192,008 171 172 5905 Property Insurance 687,921 0 687,924 0 0 0 687,924 172 173 5919 Unemployment 103,200 0 103,360 0 0 0 103,360 173 174 TOTAL RISK MANAGEMENT 14,286,181 722,699 13,550.957 86,559 0 0 14.360,215 174 Fund 641 Retiree Health Insurance 175 541 5912 Retiree Health Insurance 2,759,118 0 2.759.118 0 0 0 2,759,118 175 176 TOTAL EMPLOYEE RETIREMENT 2,759,118 0 2,759,118 0 0 0 2,759,118 176 ENTERPRISE FUNDS INTERNAL SERVICE FUNDS City of Palm Springs FY 2017-18 Page 15 CITY OF PALM SPRINGS FY 17A 8 PRELIMINARY BUDGET DETAIL Materials, Fund. Dept. FY 16-17 Personnel Supplies Special Debt Capital FY 17-18 No. No. No. Fund/Department Name TOTAL Costs &Services Charges Service TOTAL No. Fund 550 Energy 177 550 5805 Energy Administration 4,000 0 3,000 0 1,000 0 4,D00 177 178 5806 Sunrise Plaza Cogen B55,318 0 385,000 384,475 85,843 0 855,318 178 179 5807 Municipal Complex Cogen 1,719,334 0 1,108,000 439,687 171,647 0 1,719,334 179 180 5812 Energy Development 165,504 0 0 0 0 165.504 165,504 180 181 TOTAL ENERGY FUND 2,744,156 0 1,496,000 824,162 258,490 165,504 2,744,156 181 182 TOTAL INTERNAL SERVICE FUNDS $ 44,660,880 $ 3,653,133 $37,429,676 $ 1,218,236 S 1,844,306 S 725,504 $ 44,870,854 182 183 TOTAL FY 17-18 BUDGET $ 181,981,713 $ 66,135,633 $71,491,531 $ 9,259,768 $ 19,994,174 $20.582,124 $ 186,463,130 183 INTERNAL SERVICE FUNDS CONTINUE, GRAND TOTAL City of Palm Springs FY 2017-18 Page 16 Special Events, Contributions, Sponsorships, and Support Requests -City Council Approval Fiscal Year 2016.2017 City of Palm Springs Council Approval Council Approval Council Approval Ornanlzatlon Event 7 Contribution 7 Su000rt Reauest W17 Reauest In-Kind Cash Total Ilan cant Economic Drivars: 1.CVSPIN Inc, Tom De Palm Springs $50000l $25,0001 $25 000 2.1palmSpnngs Pride City fees and services for the week;Parade $85.13001 $85,0001 $85000 3.1Palm Sorgs International Film Festival I Film Festival 1 $400.0001 $50,0001 $350,0001 $400 000 4.1 Palm SpFings Modernism Week I Modernism Week 1 $75,0001 $6,0001 $35 000 $41 000 5.ACT for MS Act for MS Christmas Tree Lane at Hard Rock Hotel $5 000 s0 6.Aqua Cal left aad of Cahuilla kldians 4dl Annual Richard M.Milaravich Legacy Hike $5000 ItUD0 $5 000 7.Aoua Calleme Band of Cahuilla Indians 7m Annual ACBCI Chwity Celebrity Golf Tournament $5000 s0 8.Ago Caliente Cultural Museum Dkma in the Canjons. $5000 $0 9.Aqua Caimrft Cultuml Museum Native FllmFesl $1,000 $1000 $1,000 10.AIDS Assistance PMMm Under the Stars No request SO 11.American Foundation for Suicide Prevention Oun of DwImms Community Walk $5000 $0 12.American Red Cross Home Fire Preparedness $10 000 s0 13,Amoco Lung Association LUNG Force Desert Cities Luncheon $5,000 $0 14. Black HIstwV Month Committee Black Hlstwy Parade&Town Fair $20 000 $3.500 $16.500 $20 0DO 15. 8mrs and Girls Club Annual Contribution S2D 000 $10 000 $10 000 16.Coachella Valley HousinclCoalition Ka80OM-Park QP CatoleRun $10,000 $10.000 $10000 17.Coachella Valley Rescue lAssion Emergency Food&Annex shelter ProWarn $25000 $0 18.Coachella Valley Volunteers In Medicine Wine Levees Auction $3,000 $0 19.CDYOte SWQeWOrkS Theatre Season No Mquesl Si 20.Owen AIDS Steve Chase Awards $5 000 $0 21. Omen AIDS AIDS Walk $5 000 S2,500 S2 500 22.Oasen AIDS Dining Out fen Life $5000 $2500 $2500 23.Owen Biennial dba Desert X Desert K;Exhibition of An $80 000 s0 24.Oman Hob Springs Community Task Face Coachella Valley Senior Water Volleyball Assn $15000 $0 25, Desert YAWS Freedom Band California Gold!2016 $25000 s0 26.Omen Arc Desen Arc Italian Festival $5 000 SO 27. DiO OM Film Festival D" OM Film Festival Naive Convention Center lees $25000 $5000 $5000 28.EqualitV California Institute(EQCAQ Support for local work of EQCAI $10000 $5000 $5000 29.F.I.N.D.Food Banc Mobile Pavalwy am $10000 SD 30.Friends of the Omen Mountains Trall maintenance;invasive&graffili removal $10 000 so 31.Friends of the Palms ins Animal shelter LowlNo cost vaccine,microchips and taq, clink $5000 s0 32.Gid Scan of San Gorgonio Council Career ExDlorafion Fah $5000 $D 33.Habitat far Htimanity of CV A Brush with Kindness $10000 $0 34.Mm F.Kennedy Memorial Foundation Ophelia Project $15 000 $0 35,LGBT Center of the Desert Furniture for new center $35000 $25000 $25000 36,Mizell Senior Center Annual Contribution $100 000 $80 000 $80 00D 37.Naso Vdalily Calet Exercise TherapyEui $50000 $0 38.Operitim Destination Homebound,Inc. Free bransportalm m Military from 29 Palms $10 000 $0 39,Palm Canyon Theare Palm Canyon Theatre 2016.17 Season $5 000 $0 40.Palm ins Air Museum 2016.17 Commemorative ProWam&Events $30 000 $0 41.Palm Springs An Museum Free Thus Fri mulas aP PSAW Gallery seating $100 000 $0 42.Palm I Center for the Pedonnt Am Palms ri Orchestra $50 D00 $0 43.Palm Chamber of Commerce ConsultingeemeM President's Circle 526 000 $8 000 $8,000 44.Palm CdtoraI Center A.Lyon Film You Fest.;Farmers'NM;Cinema;Am.Doc.(Waive Pavilion fees $43,5001 S7 D00 $15 000 $22.000 45.Palm Sprintfs Frumrumners&Walkers Palm Sprims Pride 5K Pride Run&Walk ONKIND OWL Uns cifed 1 $2,500 $2.500 46.Palm Springs G Men's Chorus Concert Season 2016-2017 1 $5 000 $0 City of Palm Springs FY 2017-18 17 Special Events, Contributions, Sponsorships, and Support Requests -City Council Approval Fiscal Year 2016-2017 City of Palm Springs Council Approval Council Approval Council Approval Organization Event I Contribution I Su000rt Reaueat 16-17 Remest In-Kind Cash Total 47.Palm Stakes,High Sdml Homecoming Parade;Graduation $7 500 $2,500 $2 500 48. Palm SOnes Historical Society Palm Springs Hism Faire $2,5D0 $0 49. Palm Springs Intereational Song Festival&Contest SON contest&Festival S50 000 $0 50. Palm Springs International Jazz Fesoval PS ertemMiveal)m Fesavd $20 000 s0 5i. Palm Springs Marathon Runners 7th Annual Run for Ike SK 014 KIND ONLY) $2 964 $2 500 $2 5DO 52. Palm Springs Marathon Runners PS ever.Film Festival Red Carpet Run 5K&101K ON KIND ONLY) $3 500 $2 500 $2,500 53. Palm Springs Marathon Runners Mh Annual Santa Paws SN IN KIND ONLY) $2 900 $2 500 $2 500 54, Palm Springs Marathon Runners Veterans DayHeroes 5K ON KNID ONLY) Uns ecilied S2,500 $2 600 55. Palm Springs Modem Comae Oreservation Awards Dinner $2500 $0 56. Palm Springs Opus Guild 19th Annual Owns in the Park $8.DOO $7 500 $7 500 57. Pam Springs Warren's Jan and Blues Assn PS Women'Jan Festival-Oct 14-16 $250130 $0 58, Palm Springs Youth LeMue Opening Day Fair F $2 500 s0 59, Palm Springs,City of Rmeatim Deparlawnt Holiday Conceit Concert Series;Movies $35 ODO $0 60. Shelter from the Storm Taxi Voucher Program Fund Palm Spritnts residents only) $5 000 $2 500 S2 5D0 61.TransganderConnintinityCoulition H.O.P.E.;Equal" March;Day of Remeinbranee $66980 $1000 $1500 S2,500 62. United WaV of the Desert Tram Road Challentip $15 000 $0 63. Vacation Rental Managers of Pakn Springs Rebate 112 TOT on VR cleaning fees $100 000 $0 64.Volunteer Palm Springs P.S.CARES(Public Sal $5000 $0 65.Well in the Desert Annual Contribution add restrictive for park use $24 000 s24 022 $24.000 66.Well it the Desert Christmas Dinner $5 ODO $3 5001 $3 500 66. RAP Foundation l Seniarin iration Awards Seniorm iratim Awards $3000 $300D $3000 $1,772.844 5197,b00 s607,5D0 s805,000 Other City Events: . Julb Clebration $30.000 $30,OOD $67.NA 3D,0000 68IA revival of Lights $30,000 $30,000 $30,000 69, Vdaan's Da Parade $15.000 $15,000 $150 70.WA M 's Rae&Wellness Festival $50,000 SO $0 Total Other City Events $125,0001 $75,000 1 $75,000 Subcommittee Request:71. s Resource Cmtei 0 ram 7 OW funded out d General FIIIM reserve $0 $0 $0 72.Reserve fmC Costs Thal May Need Funds I I $D 1 $30000 1 $30 D00 Total Subcommittee Recommended Funding $1,897,844 1 $197,500 $712.500 $91DODO (1j 0esen Xdireded Wseek Nntling from PS ResMs Funding in Adopted Budget: 2016-2017 Cash 2 PS Ares Museum lunoed b $50,000In Public Ams Fund General Fund $767,501) Total City Council Funding Approved on July 13,2016 ' $712,500 Balance Available $56.000 • Nole: Adjusted on 111812016,changed Transgender Community Coalition grant approval from$5,000 as in-kind to$1.000 as in-kind and$1,500 in cash, Added on I11WO16 Senior Inspiration Awards for$3,000 in cash. City of Palm Springs 2017-18 18 FUND 125 - RECYCLING FY 16.17 FY 16-17 FY 17-18 Budqet Projected Preliminary Est. Beginning Cash Balance Available $862,499 $923,713 $769,930 Revenue -125 Recycling Surcharge 134,500 134,500 134 50 Interest Income and Other Revenues 4,000 4,000 4 000 Total Revenue $138,600 $138,500 $138,500 Appropriations - 1280 Personnel Costs 134,493 134.493 48,566 Materials, Supplies 8 Services 61,650 61.650 61,650 Special Charges - Insurance,Admin. Service 22,495 22,271 22,271 Program Expenses-Capital 73,869 73,869 73,869 Unallocated Programs Expense 0 0 0 Total Appropriations $292,507 $292,283 $206,358 Est. Ending Cash Balance Available $708,492 $769,930 $702,074 City of Palm Springs FY 2017-18 Page 19 FUND 127 - VILLAGEFEST FY 16-17 FY 16-17 FY 17-18 Budget Projected Preliminary Est. Beginning Cash Balance Available $99,036 $128,550 $116,950 Revenue - 127 Palm Springs Villagefest Permits 504.600 493,000 493,000 Other Revenues 0 0 0 Total Revenue $504,600 $493,000 $493,000 Appropriations -2560 Personnel Costs 345,280 345.280 346,234 Materials, Supplies& Services 71,256 71,256 71,256 Special Charges- Ins.,Admin. Sry 82,333 88,064 88.064 Total Appropriations $498,869 $504,600 $505,554 Est. Ending Cash Balance Available $104,767 $116,950 $104,396 City of Palm Springs FY 2017-18 Page 20 FUND 138 - SUSTAINABILITY FY 16-17 FY 16-17 FY 17-18 Budget Projected Preliminary Est. Beginning Cash Balance Available $120,462 5161,755 $9,527 Revenue Diversion Facility Fee 411,000 370,000 370,000 Interest Income and Other Revenues 4,000 4,000 4,000 Total Revenue $415,000 $374,000 $374,000 Appropriations Personnel Costs 134,636 134,635 48,528 Materials, Supplies& Services 69,150 69,150 14,150 Special Charges- Insurance,Admin. Service 32,493 32,493 32,493 Program Expenses 150,291 146,750 4.250 Mayor's Wellness Program 0 0 0 Total Appropriations $386,669 $383,028 $99,421 Interfund Transfer to Co-Gen Fund $143,200 143,200 147,600 Est. Ending Cash Balance Available $5,693 $9,627 $136,506 City of Palm Springs FY 2017-18 Page 21 FUND - 149 - AIR QUALITY MGMT DISTRICT (AQMD) FY 16-17 FY 16-17 FY 17-18 Budget Projected Preliminary Est. Beginning Cash Balance Available $80,395 $80,395 580,395 Revenue - 149 Air Qual ty Management Fees 57,600 57,600 57.600 Interest Irccrne 0 0 0 Total Revenue $57,600 $57,600 $67,600 Appropriations -4609 Contractual Services 34,000 34,000 34.000 Special Programs 23,600 23.600 23.600 Total Appropriations $57,600 $57,600 $57,600 Est. Ending Cash Balance Available $80,395 $80,395 $80,395 City of Palm Springs FY 2017-18 Page 22 FUND 150 - PUBLIC ARTS FY 16-17 FY 16-17 FY 17-18 Budget Projected Preliminary Estimated Beginning Cash Balance Available $158,005 360.418 203.138 Revenue Public Arts Fee 190.000 190 000 190.000 Other Income 1 000 1,000 1,000 Total Revenue $1911000 $1911000 $191,000 Appropriations Personnel Costs 71,658 71,658 73,575 Artwork Maintenance, Materials, Supplies &Services 74,750 74,750 74,750 Unallocated (Fund Balance) 136,251 136,251 136.251 Special Charges- Insurance,Admin. Service 16,346 15,621 15,621 PS Art Museum 50,000 50,000 50,000 Total Appropriations $349,005 $348,280 $350,197 Surplus/(Deficit) ($158,005) ($157,280) ($159,197) Estimated Ending Cash Balance Available $0 $203,138 $43,941 City of Palm Springs FY 2017-18 Page 23 Fund 420 - Waste Water Treatment Plant FY 2015-16 FY 2016-17 FY 2017-18 Adopted Adopted Preliminary Revenue Service Charges $9.600,000 $9,600,000 $9.600,000 Connection Fees 600,000 600,000 600,000 Other Revenue 50,000 50,000 50,000 Total Revenue $10,260.000 $10,260,000 $10,260,000 Expenditures Admin Personnel Costs 135,442 145,519 148,842 Supplies 28,200 28,200 28,200 Electricity 325,000 325,000 325,000 Gas and Oil(Heat) 0 0 25,000 Gasoline 27,000 27,000 27,000 Contract Operations 5,000,000 3,480,000 3,750,000 Contract Legal 50,000 50,000 50,000 Other Contract Services 400,000 516,942 750,000 Special Charges 724,111 724,646 688,075 Capital 4,000,000 4,962,793 4.461,206 Total Expenditures $10,689,753 $10,250,000 $10,253,323 Estimated Ending Cash Balance Available $5,600,000 $0 $5,596,677 City of Palm Springs FY 2017-18 Page 24 Fund 430 - Golf Course FY 2015-16 FY 2016-17 FY 2017-18 Actuals Projected Preliminary Golf Courses Operations - Managed by Century Golf Revenue Golf Revenues $4,258,421 $4.266.848 $4,395,000 Total Revenue $4,258,421 $4,266,848 $4,396,000 Expenditures Materials, Supplies & Services 4,090.488 4,156.315 4,279,919 Management Fee 225,000 225,000 225,000 Special Charges, Legal &Auditing 14,934 12,167 12,157 Equipment Lease 128084 71,100 71,100 Capital Improvements 0 0 0 Total Expenditures $4,458,506 $4,464,582 $4,588,186 Operations Surplus I (Deficit) ($200,085) ($197,734) ($193,186) Golf Courses Non-Operating Bond Debt Service Expenses (939,748) (937,266) (938,814) Interfund Transfer In -General Fund $1,097,530 $1,135,000 $1,132,000 Estimated Ending Cash Balance Available 0 0 0 City of Palm Springs FY 2017-18 Page 25 Fund 510 - Fleet / Motor Vehicle Replacement FY 2016-17 FY 2016-17 FY 2017-18 Budget Projected Prefirninary Estimated Beginning Cash Balance Available $2,142,878 $2,795,863 $1,976,913 Revenue Charges to Other Funds 3,241,129 3,067,973 3,068,973 Charges for Services& Interest Income 154.489 257,800 12,000 Interfund Transfer In 1,000,000 65,000 0 Total Revenue $4,395,618 $3,390,773 $3,080,973 Aoorouriations -Operations Personnel Costs 1.000,230 750,000 961,350 Materials, Supplies& Services 2,046,613 1,215,000 1,805,887 Special Charges- Insurance, Admin Service 135,790 135.790 135,790 Debt Service 0 240,726 240,726 Capital 560,000 1,868,207 560,000 Total Appropriations $3,742,633 $4,209,723 $3,703,763 Estimated Ending Cash Balance Available $2,795,863 $1,976,913 $1,354,133 City of Pa Springs FY 2017-18 Page 26 CAPITAL IMPROVEMENT PLAN (CIP) MEASURE J FUNDS FY 2016-17 FY 17-18 FY 18-19 Budqeted Preliminary Preliminary Protected Beginning Balance $ 241,102 $ 249.245 $ 0 Revenue $ 12,900,000 S 13,400,000 $ 13,700,000 Bond Payments 3,200,000 3,200,000 3,200,000 Downtown Property Maintenance& Other Expenses 475,000 500,000 525,000 Multi-Year Projects: Community Projects 911,725 1,202,125 1.000,000 Street Repairs 3,000.000 3,000,000 3,000,000 "Buzz" Program— 847,962 847,962 847,962 Uptown Parking Structure (Andaz Agreement) 0 0 2,000,000 Police Department Remodel 1,250,000 1,250,000 0 Downtown Project-Additional Parking & Improvements 1,500,000 1,000,000 1,000,000 Trash Service -Trails 7.200 7,200 7,200 Total Multi-Year Projects 7,516,887 7,307,287 7,855,162 Projects Approved 14115 for 15116 as Single Year Projects: Evaluation of all City Facilities $350,000 Roof Replacements(City Hall/ Leisure Ctr/Demuth) 275,000 Swim Center Replaster 250,000 HVAC Chiller, Cooling Towers Maintenace/Wift Cntl 210,000 IT-Server Backup, Firewalls& Network Security 100,000 Chino Cone Trail 238,000 Dog Park Renovation (City Hall portion only) 345,000 Additional project recommendations from Measure J "" 2,641,958 Projects Approved 15116 for 16117 as Single Year Projects 1,768,000 Adjustments to Prior Year Projects (68,030) 0 0 Unscheduled Capital Projects 1 Reserves $ 249,245 $ 0 $ 2,119,838 " Related to PS Resorts Agreement Note: The Measure J Commission will be meeting on April 20, 2017 to make recommendations to the City Council on May 3, 2017 on additional project spending for FY 2017-2018, They will also They will also make recommendations for Community Projects theme(s)for FY 2017.2018 through FY 2020-2021. City of Palm Springs FY 2017-18 Page 27 CAPITAL IMPROVEMENT PLAN (CIP) PROGRAM DETAIL The 2017-18 City Capital Budget, including transfers out, totals $3.347,941 and may include such projects as city facilities, parks, streets overlays, traffic and drainage. Fund 261 Fund 133 Fund 134 Fund 135 Total NAME OF PROJECTS & REVENUE SOURCES Funded by Gas Measure Drainage CIP Gen Fund Tax Local A All Plan Auditing (Required) 1,750 ADA Ramp Repair 50,000 Prop 42 Replacement 109,938 Slurry Seal Program 400,000 200,000 Unscheduled Capital Programs 43,753 6,878 Measure A Bond Repayment 1,098,700 Mid-Valley Parkway(Reimbursement) 10.422 Annual Asphalt Overlay/Reconstruct 500,000 N. Indian Canyon Dr. Widening (18th to 19th Ave.) 40,000 Vista Chino at Via Miraleste Traffic Signal 25,000 N. Palm Canyon Dr. at Via Escuela Traffic Signal 25,000 N. Palm Canyon Dr. Pedestrian Crosswalks 100,000 Drainage Program - North Zone 100,000 Drainage Program - Central Zone 20,000 Drainage Program - South Zone 5,000 Drainage Program - East Zone 10,000 Drainage Program - Southeast Zone 1.500 TOTAL CAPITAL PROJECTS 0 605,441 2,006,000 136,500 2,747,941 Transfers Out: To General Fund for Street Maintenance 600.000 600,000 TOTAL CAPITAL PROJECTS INCLUDING PROJ. COVERED BY TRANSFERS OUT 0 1,205,441 2,006,000 136,500 3,347,941 City of Palm. Springs FY 2017-18 Page 28 CITY OF PALM SPRINGS FY 17-18 PRELIMINARY BUDGET DETAIL Materials, Line Fund Dept. FY 16-17 Personnel Supplies Special Debt Capital FY 17-18 Line No. No. No. Fund/Department Name TOTAL Costs &Services Charges Service TOTAL No. Fund 405 Airport Customer Facility 135 405 6003 Airport Customer Facility 2,500.000 0 0 0 0 2.500.000 2,500,000 135 136 TOTAL Airport Customer Facility 2,500,000 0 0 0 0 2.500.000 2,500,000 136 Fund 410 Airport PFC(PASSENGER FACILITY CHARGE) 137 410 6001 PFC Administration 1.970,647 0 6,000 4,647 1,960,OD0 0 1,970,647 137 138 6277 Series 2006 Debt Service 1.195,278 0 10,278 0 1,185,000 0 1.195.278 138 139 6278 Series 2008 Debt Service 817,000 0 12,000 0 805,000 0 817,000 139 140 TOTAL Airport PFC 3,982,925 0 28,278 4,647 3,950,OD0 0 3.982,925 140 Fund 415 Airport 141 415 6002 Airport Administration 3,606,432 1,394,004 449,111 1.784.074 5,276 30,050 3,662,515 141 142 142 143 6022 Airport Security 1,497,409 1.249.182 263,590 48,374 0 0 1,561,146 143 144 6050 Airside Operations 813,006 0 703,926 166,030 0 0 869,956 144 145 6075 Airport Rescue-Fire 2,984,622 2.304,143 629,013 103,677 0 6,631 3,043,464 145 146 6100 Landside Operations 1.503,617 0 1,437.460 26,307 0 0 1,463,767 146 147 6175 Grounds Maintenance 506,530 0 399,200 99,530 0 0 498,730 147 148 6200 Terminal Bldg Operations 5.267,705 3.001,913 2,320,798 144,592 0 57,200 5,524,503 148 149 6225 Control Center 3,598,893 3.323,296 350.235 75.852 0 0 3,749,383 149 150 6250 Customs 215,781 0 216.660 1,831 0 0 218,491 150 151 TOTAL AIRPORT FUND 19,993,9% 11,272.538 6,769.993 2,460.267 5,276 93,881 20,591,955 151 Fund 416 Airport Capital Projects 152 416 6401 Airport Development 421,795 0 0 0 0 421,795 421,795 152 153 6501 Special Capital Projects 1,395,000 0 0 0 0 1,395,000 1,395,000 153 154 6601 Federal Grants 4,140,000 0 0 0 0 4,140,000 4,140,000 154 155 TOTAL AIRPORT CAPITAL PROJECTS 5.956.795 0 0 O 0 5,956,795 5,956,795 155 AIRPORT ENTERPRISE FUNDS City of Paim Springs FY 2017-18 Page 29 FY 2017-2018 CITY OF PALM SPRINGS DRAFT Department Head Unfunded Capital Requests Requested Dept Department Name Account Name 2017.18 GENERALFUND 1150 INFORMATION TECH Citywide Information Technology Upgrades 300,000 2710 LIBRARY Library Renovation -Architect 500,000 5641 FACILITIES Replace Palm Springs Stadium Scoreboard 60,000 3520 FIRE Toughbook- Laptops 71,192 3520 FIRE Station Alerting System 194,000 3520 FIRE Office Space Unknown 3010 POLICE CAD System (Cyrun) 1,500,000 3010 POLICE Motor Vehicles 1,400,000 2510 RECREATION I SWIM CENTER Light Tower 7,500 2510 RECREATION Resurface Outdoor Basketball Court 7,500 2510 RECREATION Palm Springs Pickleball Courts 100,000 2510 RECREATION Replace Gymnasium Floor 106,873 2510 RECREATION I DEMUTH Install AIC Unit(s) 600,000 2510 RECREATION Palm Springs Stadium Turf Conversation 1,300,000 TOTAL 6,147,065 OTHER FUNDS 5641 MAINT& FACILITIES Chiller&Cooling Tower(EOC) 74,000 5641 MAINT & FACILITIES Chiller&Cooling Tower(Palm Springs Pavilion) 78,000 5641 MAINT& FACILITIES HVAC& Dehumidifier Equipment(IT Server Room) 65,000 TOTAL 217,000 City of Palm Springs FY 2017-18 Page 30 New Unfunded Capital Project Requests City of Palm Springs New Project Requests Staff Recommended Title 2017-18 2017-10 1 Fire Station No.4 6 1,700,00D 6 1,700,000 2 Bollards a Bollarde-Phase 1(La Pleas) 300,000 3001000 b Bollards-Phase 2(AndreasiTshquitz(Both Sidas)MaristolAmnao) 1,500,000 3 Keyless Entry a Keyless Entry-Phase 1 300,000 b Keyless Entry-Phase 2 600.000 4 City Facility Upgrades/Annually 250,000 6 Emergency Alerting System(All Fire Stations) 1,250,000 6 Demuth ADA Access-Phase 2 11760,000 7 Emergency Operating Center-Chiller and Cooling Tower Replacements 200,000 9 Plaza Theater a Phase 1-Design 500,000 b Phase 2-Construction 5,000,000 10 Server AC Unit 70,000 11 Indian Canyon 2-Way Conversion 3,000,000 12 North Palm Canyon Crosswalks 200,000 200,000 13 Cltywide IT Hardware 300,000 Sub-Total Funding Request 6 16,820,000 6 2,200,000 Active Projects - Needing Additional Funds 14 Police Department Remodel 3 600,000 S 500,000 15 HVAC Replacements(City Facilities) 100,000 16 Palm Canyon Electrical Upgrades 40D,000 17 CMAQlCVAG Bicycle Lane Installation 76,000 Sub-Total Funding Request 6 1 076,000 6 500,000 Total Funding Request 6 17,896,000 6 2,700,000 City of Palm Springs FY 2017-18 Page 31 Remaining Unfunded Capital Requests City of Palm Springs Requested Fiscal Year Decrease! Title 2016.17 2017-18 Increase 1 Basketball Courts Baristo Park $ 71600 6 7,500 5 - 2 Swim Center Deck S Pool Lights 6,741 6,741 0 3 James 0 Jessie DHUC-Gym Floor Replacement 89,061 89,061 0 4 Irrigation Repair Parts 2,000 2,000 0 6 Balardo Parking Structure-Paint and Plumbing 30,000 30.000 0 6 Belardo Parking Structure-GratfN Removal 53,900 60,000 6,100 7 Downtown Trash Receptacles(Replace 150) 90,000 100,0(0 10,000 8 Downtown Newsracks-Replace and Match $0,000 60,000 10,000 9 Fire-Mobil Data Transmitters for software,fire hydrants)buiklings 28,000 28,000 0 10 One Ladder Truck 1 Two Fire Engines lasses(total$2.5 million) 160,000 150,000 0 11 Library Chair Replacement for Adult Reading Rowe 10,000 10,000 0 12 Library Microfilm Machine Replacement 15,000 15,000 0 13 Library Veridian("Accessing the Past")Annual Maintenance 10.000 10,000 0 14 Library Internet and Walnuts Design Improvements 6,000 61000 0 15 Main Library Paint and Repairs 250,000 350,000 100,000 16 Library Renovation(Parking Lot ONLY) 4D9,000 1,000,000 691,000 17 Library Furniture(total project=S500KI 601000 50,000 0 18 IT-Time Cab Entry Online 60,000 $0,000 0 19 Report Writing Software for HR and Finance 20,000 20,000 0 20 Hot f Cold Water Lines(City Hall) 3,500,000 3.600,000 0 21 Hot l Cold Water Lines(Airport) 3,500,000 3,500,000 0 22 Demuth Park ADA Compliance&Retrofits-Design 644,100 300,000 (34g100) 23 City Hall LantlSCaps Renovation(mcl DWA$50K turf rebate) 1,000,000 11000.000 0 24 Shade Structures at Parka with Playgrounds I tructurelPark) 40,000 60,000 101000 25 Animal Shelter Repairs 100,000 150,000 60,000 26 Downtown Holiday Lighting 100,000 100,000 0 27 Vehicle Replacement 1,500,000 1,600.000 0 28 Swim Center Pool Cover 80,000 80.000 0 29 Fire Training Tower 60,000 50,000 0 30 Cornelia White House(Structural Retoflt) 600,000 500,000 1100,000) Requested Fiscal Year Decrease 2016.17 2017.18 Increase TOTAL UNFUNDED DEPARTMENT REQUESTS $ 12,a40,302 $ 12,773,302 $ 333,000 Remaining Unfunded Capital Requests 1 Streets Resurfacing(61 million to 95 m0lion 1 year) 2 Downtown Temporary Restrooms(9150,000 to$250,000) 3 Library j$5 million to$15 million) 4 Downtown Park($4 million to$8 million) 6 Plaza Theater($1 million to$5 million) 6 Soccer Park(98 million) 7 Demuth Park Softball Field Reconfiguration($3 million) City of Palm Springs FY 2017-18 Page 32 Cost Centers City of Palm Springs Revenue Expense Difference Golf Courses and Driving Range $4,395,000 $5,451,000 ($1,056,000) Library- Main (1) 2,240,000 2,738,939 (498,939) Welwood Library 0 326,500 (326,500) Animal Shelter/Animal Control (2) 174,187 1,679,276 (1,505,089) Recreation Programs (Sunrise): For Kids Only (FKO) 60,000 106,623 (46,623) Tiny Tots 25,000 67,384 (42,384) Summer Camp 80,000 136,215 (56,215) Softball Field Prep 32,000 75,000 (43,000) Other Recreation Costs and Administration 38,900 969,836 (930,936) Recreation Programs (JOJ): Child Literacy Program 0 51,429 (51,429) Youth Connection 0 5,371 (5,371) Summer Camp 0 27,000 (27,000) After School Tutoring 0 21,166 (21,166) Camp 0 30,330 (30,330) All Other JOJ Costs and Programs 10,000 582,944 (572,944) Demuth 100,000 260,677 (160,677) Skate Park 0 160,000 (160,000) Swim Center 131,476 721,787 (590,311) Convention Center 2,546,338 8,312,484 (5,766,146) Tourism /Visitor Center 51,000 2,070,000 (2,019,000) Convention and Visitor Bureau (CVB) 0 540,000 (540,000) The Buzz 100,000 975,462 (875,462) Neighborhoods 0 161,612 (161,612) Economic Development 0 745,690 (745,690) iHUB & Foreign Trade Zone 0 201,500 (201,500) Downtown Restroom Program 0 49,300 (49,300) Chamber of Commerce 0 20,000 (20.000) CVEP 0 100,000 (100,000) Plaza Theater 0 26,000 (26,000) Crossing Guards 0 50,634 (50,634) Railroad Station 16,000 90,788 (74,788) Homeless (3) 0 1,175,675 (1,175,675) PSCTV/ Public Information 0 407,326 (407,326) Sponsorship/ Events/Contributions 0 767,500 (767,500) Police 0 25,734,798 (25,734,798) Fire 372,000 15,329,520 (14,957,520) Cost of paramedic upgrade from firefighter included in Fire 1,340,000 (1,340,000) (1) The property taxes that the City receives for operating our own library is approximately $2,200,000 for 2017-2018. (2) The Friends of the Animal Shelter received$174,159 in adoption, clinic and other fees in 2016. The City of Indio has a contract with the County for Animal Control services at an annual cost of$925,000 to provide licensing,adoption,vaccination,sheltering, and spay and neutering services. They no longer have an animal shelter in Indio and direct their residents to the County's facility in Thousand Palms--which is not a no-kill shelter. (3) Homeless budget: General Fund portion=$1,048,038; CDBG 17-18 request=$127,675. Cost Centers(05-09-2017) 5/9/2017;3:45 PM Measure J Commission Recommended Capital Projects for FY 2017=2018 Fire Station #4 $197009000 Police Department Remodel 5009000 Bollards - Phase 1 (La Plaza) 3007000 North Palm Canyon Crosswalks 2009000 Total $25700,000 Prior Budgeted Amounts for: Fire Station #4 $1 ,3005000 Police Department Remodel $299505000 5/9/2017 Joint City Council / M-J Commission 1 Ot VA r Mr,, Department of Human Resources Coachella Valley FTE Survey - May 2017 C411FORN\V* Agency Population Total FTE Fire (Sworn) Fire (Non-sworn) Police (Sworn) Police (Non-sworn) PALM SPRINGS 45402 447.5 62 5 95 41 CATHEDRAL CITY 54261* 178.7* 35* 3* 50* 30.2* COACHELLA 45407* 68* 11 Contracted* 1 Contracted* 33 Contracted* 0 Contracted* DESERT HOT SPRINGS 28164 66 Contracted Contracted 27 8 INDIAN WELLS 5165 28 Contracted Contracted 8 Contracted 5 Contracted INDIO 89000 219 Contracted Contracted 64 34 LA QUINTA 39977* 78* 26 Contracted* 1 Contracted* 57 Contracted* 6 Contracted* PALM DESERT 51053** 115** 45 Contracted** 5 Contracted** 81 Contracted** 19 Contracted** RANCHO MIRAGE 18070* 77* 22 Contracted' 0 Contracted* 22 Contracted** 1 Contracted** Notes: Data collected from corresponding Cities HR Departments and Websites 2016 Data "2015 Data PRIVILEGED AND CONFIDENTIAL COMMUNICATIONS NOT PUBLIC RECORDS-May 2017 These documents are exempt from public disclosure pursuant to Government Code Sections 54957.6 and 6254 Preliminary Budget April 19 , 2017 City of Palm Springs 4/19/2017 City of Palm Springs 2017-2018 Budget 1 Budget Overview General Fund ($ 109 . 5 M ) — General Purpose All Other Funds ($ 132 . 2 M ) — Restricted Enterprise Funds (Airport, Wastewater, Golf) Internal Service Funds (Motor Vehicles, Facilities, Employee Retirement & Health , Energy, Risk Management) Debt Service, Special Revenues, Capital and Measure J Successor to Redevelopment / Housing 4/19/2017 City of Palm Springs 2017-2018 Budget 2 Budget Overview General Fund ($ 109 . 5 M ) — General Purpose All Other Funds ($ 132 . 2 M ) — Restricted Enterprise Funds (Airport, Wastewater, Golf) Internal Service Funds (Motor Vehicles , Facilities , Employee Retirement & Health , Energy, Risk Management) Debt Service , Special Revenues , Capital and Measure J Successor to Redevelopment / Housing 4/19/2017 City of Palm Springs 2017-2018 Budget 2 2017=2018 Preliminary Budget Adopted Projected Preliminary 2016-2017 2016-2017 2017-2018 Revenues $102,635,425 $106,102,742 $109,191 ,435 Expenditures (104,836,956) (105,2689912) (108,717,510) Surplus / (Deficit) ($29201 ,531) $833,830 $473,925 16-17 Unrestricted Beginning Balance $16,538,226 $18,545,978 Projected Unrestricted Ending Balance $14,336,695 $19,379,808 $1%8539733 Reserve as a % 15.68% 21.10% 20.83% • Personnel Additions ($821 ,370) Adjusted Surplus / (Deficit) ($347,445) Adjusted Unrestricted Ending Balance $14,336,695 $19,379,808 $19,032,363 Reserve as a % 15.68% 21.10% 19.80% 4/19/2017 City of Palm Springs 2017-2018 Budget 3 Reserves for Economic Uncertainties Goal : Maintain 10% to 20% cash reserve Fiscal Year Cash Reserve Reserve % FY 17-18 $191032,363 19.80% FY 16-17 $19337%808 21 .10% ** FY 15-16 $18,545,978 20.01 % FY 14-15 $14,985,652 18.08% FY 13-14 $13,1993370 16.31 % FY 12-13 $12,803,298 18.19% FY 11 -12 $13,041 ,689 19.11 % FY 10-11 $11 ,7799373 18.87% FY 09-10 $7,417,274 10.04% FY 08-09 $7,2175966 9.11 % FY 07-08 $11 ,4995714 15.66% FY 06-07 $11 ,121 ,250 15.87% * FY 17-18 reflects Preliminary Budget ** FY 16-17 based upon current projections 4/19/2017 City of Palm Springs 2017-2018 Budget 4 Reserves for Economic Uncertainties Goal : Maintain 10% to 20% cash reserve Fiscal Year Cash Reserve Reserve % FY 17-18 $19,032,363 19.80% FY 16-17 $1 %3799808 21 .10% ** FY 15-16 $189545,978 20.01 % FY 14-15 $14,9859652 18.08% FY 13-14 $13,199,370 16.31 % FY 12-13 $121803,298 18.19% FY 11 -12 $13,0419689 19.11 % FY 10-11 $1197799373 18.87% FY 09-10 $79417,274 10.04% FY 08-09 $7,2179966 9.11 % FY 07-08 $11 ,4999714 15.66% FY 06-07 $1191219250 15.87% * FY 17-18 reflects Preliminary Budget " FY 16-17 based upon current projections 4/19/2017 City of Palm Springs 2017-2018 Budget 4 Major Revenue Categories $0.9 ■ TOT $3 2 $15.7 ■ Sales Tax $4.2 •7 M-J Sales Tax ■ Property Taxes Utility Users Tax $12.4 Motor Vehicle Tax Franchise Fees ti .6 $13.4 All Other Revenue Interfund Transfers In (in Millions) 4/19/2017 City of Palm Springs 2017-2018 Budget 5 Revenue Increases for FY 17=18 Revenue Increases: • TOT / Hotel Tax $11640,000 • Sales Tax (excludes Measure J ) 3349831 • Property Taxes 8405000 4/19/2017 City of Palm Springs 2017-2018 Budget 6 Revenue Increases for FY 17=18 Revenue Increases: • TOT / Hotel Tax $136405000 • Sales Tax (excludes Measure J) 334,831 • Property Taxes 8409000 4/19/2017 City of Palm Springs 2017-2018 Budget 6 Major Expenditure Activities $3.1 ■ Administration ■ Growth Management $13.4 Quality of Life $8.6 ■ Public Safety $2.4 3 Public Works & Engineering . .7 Marketing & Tourism Contractual Obligations Measure J Projects Interfund Transfers Out (in Millions) 4/19/2017 City of Palm Springs 2017-2018 Budget 7 Employee Related Expense Increases for FY 17=18 Employee Related Expense Increases: • Salary Increase for COLA ($8409099) • Recommended Position Additions (8219370) • CalPERS Rate Increases (Safety +4.728%, Misc +1.628%) (8219168) • Employee Health Benefits (2553776) • Retiree Health Benefits (197,929) • Workers' Comp (+5% est) (150,000) 4/19/2017 City of Palm Springs 2017-2018 Budget 8 Employee Related Expense Increases for FY 17=18 Employee Related Expense Increases: • Salary Increase for COLA ($8405099) • Recommended Position Additions (8215370) • CalPERS Rate Increases (Safety +4.728%, Misc +1.628%) (8213168) • Employee Health Benefits (2555776) • Retiree Health Benefits (197,929) • Workers' Comp (+5% est) (1505000) 4/19/2017 City of Palm Springs 2017-2018 Budget 8 Non =Employee Related Expense Increases for FY 17 =18 Other Significant Expense Increases: • Animal Shelter Contract COLA ($209134) • Hotel Incentive Plan (2405000) • Electricity and Water Rate Increases (4005000) • Facilities & Fleet (w/o vehicle repl't) (1465170) • Interfund Transfers to Other Funds (Debt Service) (385045) • Council Changes Approved Mid-Year (4577086) • Departmental Increases (2109512) 4/19/2017 City of Palm Springs 2017-2018 Budget 9 Priority Personnel Positions Increases for FY 17=18 FTE Salary / Benefits Police - Jail Transportation Officers * 3.00 $2335744 Police Services Officers 2.00 1485800 City Attorney - Paralegal ** 1 .00 1095585 Facilities - Street Maintenance Worker 1 .00 745324 Deputy Fire Chief 1 .00 2545917 8.00 $8215370 " Offset by a reduction of temporary employees budget in Jail Operations Department. Offset by a reduction of legal expense budget in City Attorney Department. 4/19/2017 City of Palm Springs 2017-2018 Budget 10 Priority Personnel Positions Increases for FY 17=18 FTE Salary / Benefits Police - Jail Transportation Officers * 3.00 $233,744 Police Services Officers 2.00 148,800 City Attorney - Paralegal ** 1 .00 10%585 Facilities - Street Maintenance Worker 1 .00 74,324 Deputy Fire Chief 1 .00 2545917 8.00 $8219370 * Offset by a reduction of temporary employees budget in Jail Operations Department. ** Offset by a reduction of legal expense budget in City Attorney Department. 4/19/2017 City of Palm Springs 2017-2018 Budget 10 Looking Ahead : Future CaIPERS & OPEB Costs 16-17 17-18 18-19 19-20 20-21 21 -22 22-23 Total PERS Costs BEFORE Change Discount Rate @ 7.5% $13.2 $14.4 $16.2 $18.2 $19.5 $20.8 $21 .9 Total PERS Costs AFTER Change $13.2 $14.4 $16.7 $19.2 $21 .9 $24.1 $26.0 New Discount Rate 7.375% 7.25% 7.0% 7.0% 7.0% Retiree Health Insurance (OPEB) $2.6 $2.8 $3.0 $3.2 $3.4 $3.5 $3.7 Most Recent Actuarial 1 Financial Reports: Unfunded PERS Liability $132.5 Unfunded OPEB Liability $38.1 (Note: All costs in Millions) 4/19/2017 City of Palm Springs 2017-2018 Budget 11