Loading...
HomeMy WebLinkAbout4/19/2017 - STAFF REPORTS - 5.A. �ppLM Sm W Y N a • "�aro•.�•r ' CITY COUNCIL STAFF REPORT cg41F 5L DATE: APRIL 19, 2017 NEW BUSINESS SUBJECT: PRELIMINARY OVERVIEW OF THE FISCAL YEAR 2017-18 BUDGET FROM: David H. Ready, City Manager BY: Department of Finance and Treasury SUMMARY Staff is presenting a preliminary Fiscal Year 2017-18 Budget to the City Council for its initial review. Included are estimates for revenues and expenditures of a basic"carry over' budget, with the exception of included personnel-related mandated cost adjustments (e.g. PERS retirement, health care, etc.), personnel position reclassifications and projected increases in supplies, materials and contracts. Additionally, several new positions are being recommended to enhance service in specific departments which, if approved, will result in a deficit. Included in this budget presentation is information for the General Fund as well as budgets for various Enterprise Funds, Internal Service Funds, and other funds, with the exception of the Airport Fund, which will be presented at the City Council Meeting of May 17th following a recommendation from the Airport Commission. At the request of the Council Budget/Finance Subcommittee (Mayor Moon / Councilmember Kors) a special "budget town hall" meeting is planned for Tuesday, May 9th at 6:00 P.M. This will be a joint City Council and Measure J Commission Study Session to receive public input on the budget and receive the Measure J Commission's capital expenditure recommendations. Budget discussions will also be placed on agendas at the City Council Meetings of May 3rd and 17th, with adoption of the new budget anticipated at the Budget Public Hearing scheduled for June 7, 2017. RECOMMENDATION: 1. Direct the City Council Finance and Budget Subcommittee and City Staff as appropriate. STAFF ANALYSIS: For the current fiscal year ending June 30, 2017, the Finance Director is projecting a General Fund surplus of approximately $833,000 and a projected reserve cash balance of $19,380,000, which results in a General Fund reserve equivalency of 21.1%. _fE,V, NO. City Council Staff Report April 19. 2017— Page 2 Fiscal Year 2017-18 Budget Preliminary Overview FY 2017-18 Overview This preview of the Fiscal Year 2017-18 budget is presented to City Council as a preliminary overview. The information being presented represents the best estimates of the Finance Department for revenues and expenditures based upon a "carry-over" budget, including personnel-related cost adjustments (e.g. CalPERS retirement, health care, etc.), several position modifications and projected increases in supplies, utilities, materials and contracts. Various position reclassifications have also been included for a net savings of $22,000 (see Preliminary Budget, pages 7 and 8). The resulting budget is essentially balanced with a small surplus of$474,000. Using this carryover budget projection as a starting point, several new positions are being recommended to improve service delivery in several departments. These include the addition of three Jail Transportation Officers, which will allow Police Patrol Officers to spend more time responding to calls for service without traveling to Banning or Indio when booking a suspect into the County Jail. Also, two additional Police Service Officers are being requested to allow for expanded police records services available to the public until 7:00 PM, including adding services on Friday and Saturday. A Deputy Fire Chief, to replace an eliminated administrative position lost during the 2009-10 layoffs, and a Street Maintenance Worker to enhance pot-hole repairs and graffiti removal, are also being requested. Approval of the new Paralegal position will not add to the City's expenditures, as an equal amount will be deducted from the current contract attorney budget as this work will now be performed internally. The following list represents these new requested positions: FTE Salary / Benefits Police - Jail Transportation Officers 3.00 $233,744 Police Services Officers 2.00 148,800 City Attorney - Paralegal " 1.00 109,585 Facilities - Street Maintenance Worker 1.00 74,324 Deputy Fire Chief 1.00 254,917 8.00 $821,370 Offset by a reduction of legal expense budget in City Attorney Department. Additionally, several departments requested new personnel positions to enhance service delivery (see Preliminary Budget, page 10), that have not been included in the Preliminary Budget. Specifically, in the areas of Police and Fire, anticipation of the new downtown Tribe Casino construction and completion of the City redevelopment project will ultimately require additional personnel resources. The City Council Subcommittee on the Vision Agua Caliente Master Plan (Mayor Moon/Councilmember Mills) have had an initial meeting with members of the Tribal Council to convey the City's request for safety service support. 02 City Council Staff Report April 19, 2017 —Page 3 Fiscal Year 2017-18 Budget Preliminary Overview Total General Fund Revenue is projected at$109,191,435, which is a 2.9% increase from the previous fiscal year. Increases are anticipated in each of the top four categories: TOT/ hotel tax by $1,640,000 (net of incentive payments), property taxes by $840,000, and sales taxes by $335,000. Total General Fund Expenses and Transfers is projected at $109,538,880, which is a 3.3% increase from the previous fiscal year (including the eight new recommended positions). In the area of employee compensation, budget line items have been adjusted for contractual obligations related to salaries and benefits. For example, FY 2017-18 is the fourth and final year of negotiated salary agreements which City Council approved in FY 2014-15 with all represented and non-represented employee groups. After employee salaries, pension costs are the next largest expense category for the City. Employer rates for all public agencies are determined annually for the upcoming fiscal year by the State's CalPERS Board. Below is a summary of rate increases: Employer PERS Rate Increases FY 14-15 FY 15-16 FY 16-17 FY 17-18 Police & Fire (Safety) +4.555% +2.846% +4.728% +3.214% Non-Safety (Miscellaneous) +2.574% +2.262% +1.628% +1.182% Also, beginning in FY 2018-19, PERS costs will begin increasing more significantly as new investment earnings assumptions, known as 'the discount rate' (or PERS anticipated 20-year average rate of return on investments) are being implemented system wide, resulting in several years of much higher required employer contributions. The following illustrates CalPERS projections which indicate annual required contributions will almost double over a seven-year period: PERS Costs in Millions 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% 03 City Council Staff Report April 19, 2017 — Page 4 Fiscal Year 2017-18 Budget Preliminary Overview Other contractually-driven cost increases which are included in the budget relate to capped heath care cost increases, retiree health care costs, and workers compensation. As part of the carryover budget, an additional $457,000 in costs include three positions approved by the City Council mid-year during FY 2016-17 (Fund Development Director; Code Enforcement Officer; and a Police Officer). Other areas of recommended budget increases include the following: Utility rate increases for water and electricity anticipated at an additional $400,000; $240,000 for hotel incentive payments (net of increased TOT increment); $146,000 for fleet and facilities costs; $38,000 for debt service costs; and $20,000 for the animal shelter agreement contractual COLA. The following specific Departments also have increases in their non-personnel line items: IT— Hardware, Software and Overtime $89,280 Police — Equipment and Background Checks 41,825 City Clerk — Contractual Services 26,000 Library— Hardware, Software, training 20,000 Parks — Pool Supplies 19,000 Various Miscellaneous 14,407 $210,512 With regard to liability and property insurance, we currently spend approximately $1.1 million on annual premiums. New cost estimates won't be available until May, and staff will update the City Council after a review of insurance proposals is completed. Airporf The Airport budget will be presented to City Council on May 17th to coincide with an Airport Commission recommendation at their May meeting. One of the specific issues staff is working on with the Airport Commission, in light of recent terrorist-related incidents at airports, is increased security. The Police Officers' Association has recommended, and the Police Chief agrees, adding four Police Officer positions to the Airport — allowing for two officers per shift— will improve overall security. The cost of these four positions would be approximately $740,000 for the Airport Fund. Options are being researched and discussed to present the Commission and City Council related revenue increases to accommodate this extra security expense. Capital Improvements In the current draft budget proposal, a placeholder of$2,600,000 is in the Measure J Fund budget for additional capital project allocations (see Preliminary Budget, page 27). Staff has presented a list of unfunded capital projects for the Measure J Commission to 04 City Council Staff Report April 19, 2017— Page 5 Fiscal Year 2017-18 Budget Preliminary Overview consider, which they will discuss at their meeting on April 20th. Additionally, a list of citywide "Unfunded Capital Requests"will be presented to the City Council for review and consideration during the budget process. This discussion will be coordinated with the Measure J Commission — specifically, during the Joint City Council and Measure J Commission Budget Study Session Meeting scheduled for Tuesday, May 9th at 6:00 P.M. at the Convention Center. Sponsorships/Grants A revised and simplified application process is being finalized for organizations seeking to request City grants and sponsorships. The applications will be available in late-April and due in late-May. In the current FY 2016-17 budget, $767,500 was appropriated for these requests — and an additional $197,500 was approved by the City Council as "in- kind" contributions of departmental services, such as waiving City use of facility fees and staff overtime. Staff has included this same amount as a placeholder, however, Council may want to consider reducing this budget amount to assist with the funding of additional Police and Fire service costs as noted above. Next Steps This Staff Report represents only the introduction of the FY 2017-18 Preliminary Budget. Discussions related to the entire budget will also be agendized at the following meetings for public input and City Council direction to staff: May 3 General budget discussions May 9 Joint Budget Study Session with the Measure J Commission May 17 Airport budget and general budget discussions June 7 Budget Public Hearing June 21 Deadline for budget approval As noted above, the Budget Public Hearing on June 7th is required by City Charter, hence, City Council may approve the FY 2017-18 Budget after the Hearing or continue the approval to June 21st. David H. Ready, E GeoffreyKiehl City Manager Director of Finance and Treasurer Attachments: Preliminary Budget All Funds FY 2017-18 05 PRELIMINARY BUDGET FY 2017- 18 E pA�Ms O p?� y c U N Q[IFOAN\ DRAI " City Council Meeting - April 19, 2017 os City of Palm Springs Table of Contents Carryover/ 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 / 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 4/13/2017: 1:09 PM 07 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 4/13/2017: 1:09 PM 08 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,860 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 Pagel 09 BUDGET OVERVIEW RECOMMENDED BUDGET PRELIMINARY FY 2017-18 Operating Surplus (Deficit) 473,925 Recommendations: Personnel Additions (821,370) Reserve Drawdown (347,445) Estimated Reserve After Recommended Additions 19,032,363 Reserve as a % 19.80% City of Palm Springs FY 2017-18 Page 2 IQ 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% z1% 4�c ■Property Taxes 3% ■Sales& Use Taxes ■Transient Occupancy Tax(TOT) 11% lYo ■Measure 1 Sales Tax ■Utility Users Tax ■Franchise Fees ■Motor Vehicle In Lieu Tax ■All Other Sources 12% 27% MAJOR OPERATING FUND REVENUES ADOPTED ADOPTED ADOPTED % CATEGORY 2015-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 it 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 9% 15% 3% 7% ■Administration 9% ■Growth Management ■Quality of Life ■Public Safety ■Public Works&Engineering 11% •Marketing&Tourism im Contractual Obligations" 46% MAJOR OPERATING FUND APPROPRIATIONS BY CATEGORY ADOPTED ADOPTED ADOPTED % CATEGORY 2015-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 $ 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 12 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 Charges Service TOTAL No. 1 001 1010 City Council 696,817 384,800 191,250 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,561 13,650 2,381 0 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,D00,000 10 11 1231 Public Affairs/PSCTV 400,713 256,772 147,100 3,474 0 0 407,346 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 544,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,577 3,088,268 15 16 1402 Homeless Program 465,000 0 465.000 0 0 0 465,000 16 17 2101 GPSCVB Convention/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 InfI Film Festival) 350,000 0 350,000 0 0 0 350,000 23 24 2180 Convention Center 7,560,370 0 2,437.500 200,650 5,092,220 0 7,730,370 24 25 2197 Plaza Theater 26,000 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,050,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 568,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,538,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 1250640 41 42 3400 Dispatch Center 1,291,770 1,072,705 49,250 35,567 0 0 1:157:522 42 43 General Fund Continue 43 GENERALFUND bat 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 Personnel Materials,Supp Special Debt Capital FY 17-111 Line No. No. No. Fund/Department Name TOTAL Costs &Services Charges Service TOTAL No. 44 3520 Fire Administration 14,445,103 13,477,726 599,124 1,065,416 0 29,000 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 1652,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,688 51 GENERALFUND t� p. 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 Technoloav 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 0011120 Senior Systems/Network Admin -Cert (1.00) (133,698) (193,407) Reclass 001 1120 Information Technology Supervisor 1.00 140,393 202,084 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 portion onl 001 1160 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 001 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 15 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 James O Jessie DHUC Increase FTE from .50 to 1.00 001 2590 Recreation Program Assistant 0.50 21,793 28,242 Total- Increase/(Decrease) 0.50 21,793 28,242 TOTAL Position Modification/Reorganization -General Fund 1.50 (22,124) (22,178) City of Palm Springs FY 2017 18 Page 8 �. FY 2017-2018, List q2 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 001 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 lFac) 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,805 821,369 *Offset by a reduction of legal expense budget in City Attorney Department. City of Palm Springs FY 2017-18 Page 9 17 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 18 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 113 Plaza Theater 52 113 2199 Plaza Theater 0 0 0 0 0 0 0 52 53 TOTAL PLAZA THEATER 0 0 0 0 0 0 0 53 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,415 $383,839 $4,286,982 74 SPECIAL REVENUE FUNDS CONTINUE City of Palm Springs FY 2017-18 Page 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 Sustainability 75 138 1270 Sustainability 383,028 48,528 14,150 32,493 0 4,250 99,421 75 76 TOTAL SUSTAINABILITY 383,028 48,528 14,150 32,493 0 4,250 99,421 76 Fund 140 CFD Public Safety Si 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 Fund 141 Land/LighUPark Maint Dist 80 141 4609 Land/Light/Park Maint Dist 356,941 0 356,941 0 0 0 356,941 80 81 LAND/LIGHT/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&Recreation 1,538,400 0 0 0 0 1,538,400 1,538,400 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 0 0 0 0 100,000 100,000 91 92 TOTAL SPECIAL PROJECTS 200,000 100,000 0 0 0 100,000 200,D00 92 Fund 170 Special Grants 93 170 3212 Police AS 109 175,000 168,376 6,624 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. Fund/Department Name TOTAL Costs &Services Charges Service TOTAL No. Fund 139 Master Lease 96 139 7851 Master Lease 1,493,700 0 4,000 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,605,383 0 14,537 0 9,590,846 0 9,605,383 104 Fund 328 105 328 7879 A.D. 2015-1 105 10B 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,503 0 63,537 0 11,766,966 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,503 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 N M 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. Fund/Department Name TOTAL Costs &Services Charges 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 1Q000 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 136,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 4500 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 0 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 86,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 N N 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. Fund/Department Name TOTAL Costs &Services Charges Service TOTAL No. Fund 420 Wastewater Treatment Plant 156 420 6800 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 MainUOperations 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 15,759,075 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,000 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 540 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 5904 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 541 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 17-18 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,000 177 178 5806 Sunrise Plaza Cogen 855,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,650,880 $ 3,663,133 $37,429,675 $ 1,218,236 $ 1,844,306 $ 725,604 $ 44,870,854 182 L83 TOTAL FY 17-18 BUDGET $ 181,981,713 $65,135,533 $71,491,631 $ 9,259,768 $ 19,994,174 $ 20,682,124 $ 186,463,130 183 INTERNAL SERVICE FUNDS CONTINUE, GRAND TOTAL N .A. 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 Oraanization Event/Contribution l Support Reauest 16.17 Request In-Kind Cash Total Si nificant Economic Drivers: 1. CVSPIN Inc. Tour De Palm Springs $50,0001 $25,0001 $25 000 2. Palm Springs Pride City fees and services for the week;Parade 1 $85,0001 $85,0001 $85 000 3.IPalm Springs International Film Festival I Film Festival 1 $400,0001 $50,0001 $350,0001 $400 000 4. Palm Springs Modernism Week I Modernism Week 1 $75,0001 $6,0001 $35,0001 nnn 5.ACT for MS Act for MS Christmas Tree Lane at Hard Rock Hotel $5,000 $0 6.Aqua Caliente Bard of Cahuilla Indians 4th Annual Richard M.Milanovich Legacy Hike $5 000 $5 000 $5 000 7.A ua Caliente Band of Cahuilla Indians 7th Annual ACBCI Charity Celebrity Golf Tournament $6 000 $o 8.Aqua Caliente Cultural Museum Dinner in the Canyons $5.000 $0 9.Aua Caliente Cultural Museum Native FilmFesl $1000 $1000 $1,000 10.AIDS Assistance Program Under the Stars No request $0 11.American Foundation for Suicide Prevention Out of Darkness Community Walk $5000 $0 12.American Red Cross Home Fire Preparedness $10,000 $0 13.American Lung Association LUNG Force Desert Cities Luncheon $5,000 $0 14. Black History Month Committee Black History Parade&Town Fair $20 000 $3 500 $16,500 $20 ODD 15, Boys and Girls Club Annual Contribution $20000 $10,000 $10000 16.Coachella Valley Housing Coalition KaB00M-Park&'Coyote Run $10,000 $10,000 $10,000 17.Coachella Valley Rescue Mission Emergency Food&Annex Sheher Program $25 000 $0 18.Coachella Valley Volunteers In Medicine Wine Lovers Auction $3,000 $0 19,Coyote Stactmorks Theatre Season Nor uest $0 20. Desert AIDS Steve Chase Awards $5,000 $0 21. Desert AIDS AIDS Walk $5,000 $2,500 $2 50D 22. Desert AIDS Dinino Out for Life $5,000 $2,500 $2,500 23. Desert Biennial dba Desert X 1 Desert X;Exhibition of Art $50 000 $0 24. Desert Hot Springs Community Task Force Coachella Valley Senior Water Volleyball Assn $15 000 $0 25. Desert Winds Freedom Band California Gold!2016 $25 000 $0 26, Desert Arc Desert Arc Italian Festival $5 000 $0 27. Di iCOM Film Festival DiffiCOM Film Festival(Waive Convention Center fees $25 000 $5 000 $5,000 28. Equality California Institute(EQCAQ Support for local work of E CAI $10,000 $5,000 $5 000 29. F.I.N.D.Food Bank Mobile Pa Program $10,000 $0 30. Friends of the Desert Mountains Trail maintenance;invasive&graffiti removal $10,000 $0 31, Friends of the Palm Springs Animal Shelter Low/No cost vaccine,microchips and taq, clinic $5,000 $0 32. Gid Scouts of San Gorgonio Council Career Exploration Fair $5 000 $0 33. Habitat for Humanity of CV A Brush with Kindness $10000 $0 34.John F.Kennedy Memorial Foundation 0 helia Project $15 000 $0 35. LGBT Center of the Desert Furniture for new center $35 000 $25 000 $25,000 36. Mizell Senior Center Annual Contribution $100 000 $80 000 $80,000 37. Neuro Vitality Center Exercise Therapy Equipment $50000 $0 38,Operation Destination Homebound,Inc. Free transportation to Military from 29 Palms $10,000 $0 39. Palm Canyon Theatre Palm Canyon Theatre 2016-17 Season $5,000 $0 40. Palm S rin s Air Museum 2016.17 Commemorative Program&Events $30 000 $0 41. Palm Springs Art Museum Free Thurs;Fri nights&PSAM;Gallery seating $100 000 $0 42. Palm Springs Center for the Performing Arts Palm Springs Orchestra $50 D00 $0 43. Palm Springs Chamber of Commerce ConsultingAgreement;Presidenfs Circle $28 000 $S 000 $8,000 44, Palm Springs Cultural Center A.Lyons Film Nair Fest.;Farmers'Mkt:Cinema;Am.Doc.(Waive Pavilion fees $43,5001 $7 000 $15 000 $22.000 45. Palm Springs Frontrunners&Walkers Palm Springs Pride 5K Pride Run&Walk IN KIND ONLY Unspecified 1 $2,500 46. Palm Springs Gay Men's Chorus Concert Season 2016.2017 $5,000 $0 N 1J1 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 Support Reauest 16-17 Request In-Kind Cash Total 47. Palm Springs High School Homecoming Parade,Graduation $7 500 $2,500 $2,500 48. Palm Springs Historical Society Palm Springs History Faire $2,500 $0 49. Palm Springs International Song Festival&Contest Song contest&Festival $50,000 $0 50. Palm Springs International Jazz Festival PS International Jazz Festival $20 000 $0 51. Palm Springs Marathon Runners 71h Annual Run for Ike 5K ON KIND ONLY) $2 964 $2 500 $2,500 52. Palm Springs Marathon Runners PS Inter.Film Festival Red Carpet Run 5K&10K ON KIND ONLY) $3,500 $2,500 $2,500 53. Palm Springs Marathon Runners 51h Annual Santa Paws 5K IN KIND ONLY $2 900 $2,500 $2,500 54. Palm Springs Marathon Runners Veterans Day Heroes 5K IN KIND ONLY) Unspecified $2,500 $2 600 55. Palm Springs Modem Committee Oreservation Awards Dinner $2,500 $D 56. Palm Springs Opera Guild 191h Annual Opera in the Park $8 000 $7 500 $7 600 57. Palm Springs Women's Jan and Blues Assn PS Women's Jan Festival-Oct 14-16 $25 000 $D 58. Palm Springs Youth League Opening Day Fair(Spring Fes $2,500 $0 59. Palm Springs,City of Recreation Department Holiday Concert;Concert Series;Movies $35 000 $0 60. Shelter from the Storm Taxi Voucher Program Fund Palm Springs residents only) $5 000 $2,500 $2 50D 61.Trans ender Community Coalition H.O.P.E.;Equality March;Day of Remembrance' $66 980 $1 000 $1 500 $2,500 62. United Way of the Desert Tram Road Challenge $15,000 $0 63. Vacation Rental Managers of Palm Springs Rebate 112 TOT pd on VR cleaning fees $100 000 $0 64. Volunteer Palm S ins P.S.CARES Public Safe $5 000 $0 65. Well in the Desert Annual Contribution add restriction for park use $24 000 $24 000 $24,000 66.Well in the Desert Chdsbnas Dinner $5 0D0 $3,500 $3 500 66. RAP Foundation l Senior Inspiration Awards Senior Inspiration Awards' $3000 $3000 $3,000 $1,772.844 $197,500 E607,500 E805,000 Other City Events: 67.1 NIA Jul 4th Celebration $30,000 $30,OOD $30,000 68. NIA Festival of Lights $30,000 $30,000 $30,000 69. NIA Veteran's Day Parade $15,000 1 1 $15,000 1 $15000 70. NIA Ma or's Race&Wellness Festival 1 $50,000 1 1 $0 1 $0 Total Other City Events $125,000 1 1 $75,000 $75,000 Subcommittee Request: 71. Ro 's Resource Cenler Da Pro ram $75,000 funded out of General Fund reserve $0 1 $0 $0 72. Reserve for Ci Costs That May Need Funds $0 1 1 $30,000 1 $30 000 Total Subcommittee Recommended Funding $1,897,844 $197,500 $712.500 $910,000 (1)Desert X directed to seek funding from PS Resons Funding in Adopted Budget: 2016-2017 Cash 2 PS Arls Museum funded b $50,000 in Public Arts Fund General Fund $767,500 Total City Council Funding Approved on July 13,2016 ' $712,500 Balance Available $55,000 Note: Adjusted on 11/8/2016,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 1 11912 01 6 Senior Inspiration Awards for$3,000 in cash. N City of Palm Springs 2017-18 18 FUND 125 - RECYCLING FY 16-17 FY 16-17 FY 17-18 Budget Projected Preliminary Est. Beginning Cash Balance Available $862,499 $923,713 $769,930 Revenue -125 Recycling Surcharge 134,500 134,500 134,500 Interest Income and Other Revenues 4,000 4,000 4,000 Total Revenue $138,500 $138,500 $138,500 Appropriations - 1280 Personnel Costs 134,493 134,493 48,566 Materials, Supplies R 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,366 Est. Ending Cash Balance Available $708,492 $769,930 $702,074 City of Palm Springs FY 2017-18 Page 19 27 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 -2660 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 28 FUND 138 - SUSTAINABILITY FY 16-17 FY 16-17 FY 17-18 Budget Proilected Preliminary Est. Beginning Cash Balance Available $120,462 $161,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,635 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,569 $383,028 $99,421 Interfund Transfer to Co-Gen Fund $143,200 143,200 147,600 Est. Ending Cash Balance Available $5,693 $9,527 $136,506 City of Palm Springs FY 2017-18 Page 21 '�Q 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,396 $80,395 Revenue-149 Air Quality Management Fees 57,600 57,600 57,600 Interest Income 0 0 0 Total Revenue $57,600 $67,600 $57,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 30 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 $191,000 $191,000 $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,006 $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 3 1 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,250,000 $10,250,000 $10,250,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,546 688,075 Capital 4,000,000 4,952,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 3'7 Fund 430 - Golf Course FY 2016-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,395,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,167 Equipment Lease 128,084 71,100 71,100 Capital Improvements 0 0 0 Total Expenditures $4,458,506 $4,464,582 $4,588,186 Operations Surplus!(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,630 $1,135,000 $1,132,000 Estimated Ending Cash Balance Available 0 0 0 33 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 Preliminary 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 Appropriations-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,753 Estimated Ending Cash Balance Available $2,795,863 $1,976,913 $1,354,133 34 City of Palm Springs FY 2017-18 Page 26 CAPITAL IMPROVEMENT PLAN (CIP) MEASURE J FUNDS FY 2016-17 FY 17-18 FY 18-19 Budgeted Preliminary Preliminary Projected Beginning Balance $ 241,102 $ 249,245 $ 0 Revenue $ 12,900,000 $ 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/Wifi 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 / 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 3 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 10Q000 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 3 R 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,000 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,000 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,995 11,272,538 6,769.993 2,450,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 D 0 5,956,795 5,956,795 155 AIRPORT ENTERPRISE FUNDS ii City of Palm 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/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!DEMUTH Install A/C 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 3 R New Unfunded Capital Project Requests City of Palm Springs New Project Requests Staff Recommended Title 2017-18 2017-18 1 Fire Station No.4 $ 1,700,000 $ 1,700,000 2 Bollards a Bollards-Phase 1 (La Plaza) 300,000 300,000 b Bollards-Phase 2(AndmaslTahquitz(Both Sides)lBaristo/Arenas) 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 5 Emergency Alerting System(All Fire Stations) 1,250,000 6 Demuth ADA Access-Phase 2 1,750,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 Citywide IT Hardware 300,000 Sub-Total Funding Request $ 16,820,000 $ 2,200,000 Active Projects - Needing Additional Funds 14 Police Department Remodel $ 500,000 $ 500,000 15 HVAC Replacements(City Facilities) 100,000 16 Palm Canyon Electrical Upgrades 400,000 17 CMANCVAG Bicycle Lane Installation 75,000 Sub-Total Funding Request $ 1,076,000 $ 600,000 Total Funding Request $ 17,895,000 $ 2,700,000 34 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 $ 7,500 $ 7,500 $ - 2 Swim Center Deck&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-Graffiti Removal 53,900 60,000 6,100 7 Downtown Trash Receptacles(Replace 150) 90,000 100,000 10,000 8 Downtown Newsracks-Replace and Match 50,000 60,000 10,000 9 Fire-Mobil Data Transmitters for software,fire hydrants/buildings 28,000 28,000 0 10 One Ladder Truck i Two Fire Engines leases(total$2.5 million) 150,000 160,000 0 11 Library Chair Replacement for Adult Reading Room 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 Website Design Improvements 6,000 6,000 0 15 Main Library Paint and Repairs 250,000 360,000 100,000 16 Library Renovation(Parking Lot ONLY) 409,000 1,000,000 691,000 17 Library Furniture(total project=$500K) 60,000 50,000 0 18 IT-Time Card Entry Online 50,000 60,000 0 19 Report Writing Software for HR and Finance 20,000 20,000 0 20 Hot!Cold Water Lines(City Hall) 3,500,000 3,500,000 0 21 Hot!Cold Water Lines(Airport) 31500,000 3,500,000 0 22 Demuth Park ADA Compliance&Retrofits-Design 644,100 300,000 (344,100) 23 City Hall Landscape Renovation(incl DWA$50K turf rebate) 1,000,000 11000,000 0 24 Shade Structures at Parks with Playgrounds(Structure/Park) 40,000 50,000 10,000 26 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 805000 0 29 Fire Training Tower 50,000 50,000 0 30 Cornelia White House(Structural Retofit) 600,000 500,000 (100,000) Requested Fiscal Year Decrease i 2016-17 2017.18 Increase TOTAL UNFUNDED DEPARTMENT REQUESTS $ 12,440,302 $ 12,773,302 $ 333,000 Remaining Unfunded Capital Requests 1 Streets Resurfacing($1 million to$5 million I year) 2 Downtown Temporary Restrooms($150,000 to$250,000) 3 Library($5 million to$15 million) 4 Downtown Park($4 million to$8 million) 5 Plaza Theater($1 million to$5 million) 6 Soccer Park($8 million) 7 Demuth Park Softball Field Reconfiguration($3 million) City of Palm Springs FY 2017-18 Page 32 40