The URL can be used to link to this page

Home My WebLink About2018 Classification and Compensation Volume II Total Compensation Study Kr June 15, 2018 Classification and Total Compensation Study Final Report 1 Volume II - Total Compensation Study City of Palm Desert KOFF & ASSOCIATES GEORG S. KRAMMER Chief Executive Officer 2835 Seventh Street Berkeley, CA 94710 www.KoffAssociates.com gkrammer@koffassociates.com Tel: 510.658.5633 Fax: 510.652.5633 RTotal Compensation Study - Final Report City of Palm Desert Table of Contents List of Tables 1 Appendices 1 Executive Summary 1 Background 1 Summary of Findings 1 Study Process 2 Benchmark Classifications 2 Comparator Agencies 3 Salary and Benefits Data 5 Data Collection 7 Matching Methodology 7 Data Spreadsheets 8 Market Compensation Findings 9 Base Salary 10 Total Compensation 11 Benefits 12 Internal Salary Relationships 12 Recommendations 14 Pay Philosophy 14 Proposed Salary Structure 14 Proposed Salary Range Placements 14 Options for Implementation 15 Using the Market Data as a Tool 16 Kg5, Total Compensation Study - Final Report City of Palm Desert LIST OF TABLES Table 1 . Benchmark Classification 2 Table 2. Comparator Agencies 4 Table 3. Market Compensation Results Summary 9 APPENDICES Appendix I: Results Summary Appendix II: Market Compensation Findings Appendix III: Proposed Salary Range Schedule Appendix IV: Salary Range Placement Recommendations Appendix V: Additional Benefits KEE Total Compensation Study - Final Report City of Palm Desert EXECUTIVE SUMMARY Background In March 2018, Koff & Associates (K&A) conducted a comprehensive Total Compensation Study for the City of Palm Desert (City). All compensation findings and recommendations are presented in this report. This compensation review process was precipitated by: y The concern of the City Council and management that employees should be recognized for the level and scope of work performed and that they are paid on a fair and competitive basis that allows the City to recruit and retain a high-quality staff; ✓ The desire to have a compensation plan that can meet the needs of the City; and y The desire to ensure that internal relationships of salaries are based upon objective, non- quantitative evaluation factors, resulting in equity across the City. The goals of the compensation study are to assist the City in developing a competitive pay and benefit plan, which is based upon market data, and to ensure that the plan is fiscally responsible and meets the needs of the City with regards to recruitment and retention of qualified staff. Summary of Findings This report summarizes the job analysis methodologies, analytical tools, and the total compensation (salary and benefits) survey findings of the total compensation study K&A conducted for the City. The results of the total compensation study show: • The City's base salaries, overall, in comparison to the market median are 18.6% above the market. • The City's base salaries, overall, in comparison to the market 70th percentile are 12.6% above the market. The City's total compensation, overall, in comparison to the market median is 14.3% above the market. sfr The City's total compensation, overall, in comparison to the market 70th percentile is 9.5%above the market. The City's benefits package puts the City in a more competitive position compared to the market and, therefore, we recommend that salary decisions should be based on total compensation versus base salary market results. However, the City has decided to make recommendations based on base salary market results. • K&A considers a classification falling within 5% of the median to be competitive. 1 Total Compensation Study - Final Report City of Palm Desert STUDY PROCESS Benchmark Classifications The study included 59 classifications, and of those 37 classifications were selected in order to collect salary and benefits data within the defined labor market. Classifications that we would expect to provide a sufficient sample for analysis were selected as "benchmarks" to use as the basis to build the compensation plan. Benchmark classifications are those classifications that are compared to the market, and these classifications are used as a means of anchoring the City's overall compensation plan to the market. Other classifications not surveyed will be included in the compensation plan and aligned to the benchmark classifications using internal equity principles. The benchmark classifications are listed in Table 1. Table 1. Benchmark Classification 1. Accountant 2. Accounting Technician 3. Associate Planner 4. Building Inspector II 5. City Clerk 6. City Engineer 7. Code Compliance Officer II 8. Code Compliance Supervisor 9. Deputy City Clerk 10. Deputy City Treasurer 11. Director of Administrative Services 12. Director of Building and Safety 13. Director of Community Development 14. Director of Economic Development 15. Director of Finance 16. Director of Public Works 17. Engineering Assistant 2 KEE Total Compensation Study - Final Report City of Palm Desert lassification Title 18. Executive Assistant 19. Facilities Manager 20. Information Systems Administrator 21. Information Systems Manager 22. Landscape Specialist 23. Landscape Supervisor 24. Maintenance Worker II 25. Management Specialist II 26. Office Specialist II 27. Plans Examiner 28. Project Manager 29. Public Works Inspector II 30. Risk Manager 31. Senior Engineer 32. Senior Management Analyst 33. Streets Maintenance Supervisor 34. Supervising Plans Examiner 35. Tourism and Marketing Manager 36. Traffic Signal Technician II 37. Transportation Engineer Comparator Agencies Another important step in conducting a market salary study is the determination of appropriate agencies for comparison. In developing the list of potential comparator agencies, K&A added comparator agencies based on the following factors: 1. Organizational type and structure — It is generally recommended that agencies of a similar size and providing similar services to that of the City be used as comparators. 3 Total Compensation Study - Final Report City of Palm Desert When it comes to technical classes, the size of an organization is not as critical, as these classes perform fairly similar work. The difference in size of an organization becomes more important when comparing classes at the management level. The scope of work and responsibility for management becomes much larger as an organization grows. Factors such as management of a large staff, consequence of error, the political nature of the job, and its visibility all grow with larger organizations. When it is difficult to find agencies that are similarly sized, it is important to get a good balance of smaller and larger agencies. 2. Similarity of population, staff, and operational budgets — These elements provide guidelines in relation to resources required (staff and funding) and available for the provision of services. 3. Scope of services provided — For the majority of classifications, it is important to select agencies providing similar services. Organizations providing the same services are ideal for comparators and most comparator agencies surveyed provide similar services to the City. 4. Labor market and geographic location — In the reality that is today's labor market, many agencies are in competition for the same pool of qualified employees. No longer do individuals necessarily live in the communities they serve. The geographic labor market area, where the City may be recruiting from or losing employees to, was taken into consideration when selecting comparator organizations. Furthermore, by selecting employers within a geographic proximity to the City, the resulting labor market data generally reflects the region's cost of living, housing costs, growth rate, and other demographic characteristics to the same extent as competing employers to the City. All factors mentioned should be considered in selecting the group of comparator agencies. the City agreed to a list of 13 agencies. Table 2. Comparator Agencies 1. City of Cathedral City 2. City of Coachella 3. City of Dana Point 4. City of Indian Wells 5. City of Indio 6. City of La Quinta 7. City of Palm Springs 8. City of Poway 4 KEE Total Compensation Study - Final Report City of Palm Desert 9. City of Rancho Mirage 10. City of Redlands 11. City of San Marcos 12. City of Temecula 13. City of Yucaipa* * The City selected City of Yucaipa as a comparator agency to include in the total compensation study. After multiple attempts to gather salary and benefits information,the City of Yucaipa did not provide the requested information and are thus excluded from the total compensation study. Salary and Benefits Data The last element requiring discussion prior to beginning a market survey is the specific benefit data that will be collected and analyzed. The following salary and benefits data was collected for each benchmark classification (the cost of these benefits to each agency was converted into dollar amounts and can be found in Appendix II [Benefit Detail] of this report; these amounts were added to base salaries for total compensation purposes). 1. Monthly Base salary The top of the salary range and/or control point. All figures are presented on a monthly basis. 2. Employee Retirement The retirement reflects the "Classic" retirement plan (i.e., the plan in place prior to the implementation of PEPRA effective January 1, 2013): ➢ PERS Formula: The service retirement formula for each agency's Classic plan. > Enhanced Formula Cost: The baseline PERS formula is 2%@62. There is typically a cost to the employer for offering a formula with a higher benefit than the baseline formula. For each enhanced formula, the cost to the employer is based on a percentage range calculated by PERS. The percentage value for each enhanced formula is: • 2%@60 = 1.5% • 2%@55 = 2.7% • 2.5%@55 = 4.9% • 2.7%@55 = 6.4% • 3%@60 = 7.4% > Employer Paid Member Contribution: The amount of the employee's contribution to PERS that is paid by the employer(Employer Paid Member Contribution). 5 KEE Total Compensation Study - Final Report City of Palm Desert > Employer Paid Member Contribution Reported as Special Compensation: The amount of the Employer Paid Member Contribution reported as special compensation. > Single Highest Year: The period for determining the average monthly pay rate when calculating retirement benefits. The base period is 36 highest paid consecutive months. When final compensation is based on a shorter period of time, such as 12 months' highest paid consecutive months, there is a cost to the employer. For each enhanced formula,the cost to the employer is based on a percentage range calculated by PERS. The percentage value for each formula is: • 2%@60 = 0.5% • 2%@55 = 0.5% • 2.5%@55 = 0.6% • 2.7%@55 = 0.6% • 3%@60 = 0.7% > Social Security: If an employer participates in Social Security, then the employer contribution of 6.2% of the base salary up to the federally-determined maximum contribution of$663.40 per month was reported. ➢ Deferred Compensation: Contributions provided to all employees of a classification with or without requiring the employee to make a contribution is reported. > Other: Any other retirement contributions made by the employer. 3. Insurances The employer paid premiums for an employee with family coverage was reported. The employer paid insurances included: ➢ Cafeteria/Flexible Benefit Plan ➢ Medical ➢ Dental ➢ Vision ➢ Life and Accidental Death and Dismemberment ("AD&D") Insurances ➢ Long-Term Disability Insurance ➢ Short-Term Disability Insurance ➢ Other 4. Leaves Other than sick leave, which is usage-based, the number of hours off for which the employer is obligated. All hours have been translated into direct salary costs. ➢ Vacation: The number of paid time off(or vacation) hours available to all employees who have completed five years of employment. 6 KEE Total Compensation Study - Final Report City of Palm Desert > Holidays: The number of holiday hours (including floating hours) available to employees. > Administrative: Administrative (or management) leave is normally the number of paid leave hours available to Fair Labor Standards Act ("FLSA") Exempt and/or management to reward for extraordinary effort (in lieu of overtime). This leave category may also include personal leave which may be available to augment vacation or other time off. 5. Auto Allowance This category includes either the provision of an auto allowance or the provision of an auto for personal use only. If a vehicle is provided to any classification for commuting and other personal use, the average monthly rate is estimated at $450. Mileage reimbursement is not included. 6. ()the This category includes any additional other benefits not captured above available to all in the class. All of the benefit elements are negotiated benefits provided to all employees in the classification. As such, they represent an ongoing cost for which an agency must budget. Other benefit costs, such as sick leave,tuition reimbursement,and reimbursable mileage are usage-based and cannot be quantified on an individual employee basis. Data Collection Data was collected during the months of March and April 2018, through comparator agency websites, conversations with human resources, accounting, and/or finance personnel, and careful review of agency documentation such as classification descriptions, salary schedules, memoranda of understanding, organization charts, and other documents. Matching Methodology K&A believes that the data collection step is the most critical for maintaining the overall credibility of any study and relied on the City's classification descriptions that were developed during the classification phase of this study, as they are the foundation for our comparison. When K&A researches and collects data from the comparator agencies to identify possible matches for each of the benchmark classifications, there is an assumption that comparable matches may not be made that are 100% equivalent to the classifications at the City. Therefore, K&A does not match based upon job titles, which can often be misleading, but rather analyzes class descriptions before a comparable match is determined. K&A's methodology is to analyze each class description and the whole position by evaluating factors such as: > Definition and typical job functions; 7 KEE Total Compensation Study - Final Report City of Palm Desert ➢ Distinguishing characteristics; ➢ Level within a class series (i.e., entry, experienced,journey, specialist, lead, etc.); ➢ Reporting relationship structure (for example, manages through lower-level staff); ➢ Education and experience requirements; ➢ Knowledge, abilities, and skills required to perform the work; ➢ The scope and complexity of the work; ➢ Independence of action/responsibility; ➢ The authority delegated to make decisions and take action; ➢ The responsibility for the work of others, program administration, and for budget dollars; ➢ Problem solving/ingenuity; ➢ Contacts with others (both inside and outside of the organization); ➢ Consequences of action and decisions; and ➢ Working conditions. In order for a match to be included, K&A requires that a classification's "likeness" be at approximately 70% of the matched classification. When an appropriate match is not identified for one classification, K&A often uses "hybrids" which can be functional or represent a span in scope of responsibility. A functional hybrid means that the job of one classification at the City is performed by two or more classifications at a comparator agency. A "hybrid" representing a span in scope means that the comparator agency has one class that is "bigger" in scope and responsibility and one class that is "smaller," where the City's class falls in the middle. If an appropriate match could not be found, then no match was reported as a non-comparable (N/C). Data Spreadsheets For each benchmark classification, there are three information pages: ➢ Top Monthly Base Salary Data ➢ Benefit Detail (Monthly Equivalent Values) ➢ Total Compensation Data The average (mean), median (midpoint), and 70th percentile of the comparator agencies are reported on the top monthly salary and total compensation data spreadsheets. The % above or below that the City is compared to the average, median, and 70th percentile is also reported. The mean is the sum of the comparator agencies' salaries/total compensation divided by the number of matches. The median is the midpoint of all data with 50% of data points below and 50% of data points above. The 70th percentile is the point of all data with 70% of data points below and 30% of data points above. 8 Kg5, Total Compensation Study - Final Report City of Palm Desert In order to calculate the mean, median, and 70' percentile, K&A requires that there be a minimum of four comparator agencies with matching classifications to the benchmark classification. The reason for requiring a minimum of four matches is so that no one classification has undue influence on the calculations. Sufficient data was collected from the comparator agencies for 32 of the 37 benchmark classifications. When using survey data to make salary range recommendations and adjustments, K&A recommends using the median, rather than the mean, because the median is not skewed by extremely high or low salary values. The City Council approved setting the range recommendations and adjustments to the 70" percentile since the City strives to be an industry leader. nnMRKET COMPENSATION FINDINGS The following table represents a summary of the market top monthly (base) salary and total compensation (base salary plus benefits [retirement, insurance, leaves, and allowances]) findings. For each benchmark classification, the number of matches (agencies with a comparable position) and percent above or below the top monthly salary market median and 70' percentile, and total compensation market median and 70' percentile is listed. The table is sorted by top monthly salary in descending order from the most positive (above market 70" percentile) to the most negative (below market 70' percentile). Table 3. Market Compensation Results Summary Top Monthly Total Monthly Matches (Base) Salary Compensation Market 70th Market 70th Median Percentile Median Percentile Facilities Manager 9 31.9% 30.2% 26.9% 24.2% Associate Planner 11 24.5% 23.9% 23.2% 19.6% Engineering Assistant 7 27.3% 23.7% 26.0% 22.5% Code Compliance Officer II 12 26.5% 23.2% 21.8% 20.8% Project Manager 5 22.1% 22.1% 21.3% 19.9% Accounting Technician 12 26.4% 21.9% 22.9% 18.3% Traffic Signal Technician II 5 22.3% 21.9% 16.1% 16.1% Public Works Inspector II 6 22.7% 21.7% 20.6% 15.2% Office Specialist II 11 23.2% 21.6% 17.5% 16.9% Landscape Specialist 5 23.1% 18.7% 22.9% 16.2% Landscape Supervisor 11 19.0% 16.8% 15.3% 11.6% Building Inspector II 11 17.6% 16.5% 14.8% 10.3% Senior Management Analyst 7 16.1% 15.8% 13.8% 13.0% Maintenance Worker II 11 23.4% 15.6% 17.4% 15.4% Supervising Plans Examiner 4 15.8% 13.7% 13.4% 8.6% Accountant 12 23.2% 13.2% 20.5% 10.4% 9 Kil Total Compensation Study - Final Report City of Palm Desert Classification # of Top Monthly Total Monthly Matches (Base) Salary Compensation Market 70th Market 70th Median Percentile Median Percentile Director of Building and Safety 7 22.0% 12.0% 19.3% 11.4% City Clerk 9 23.8% 11.5% 13.2% 8.1% Management Specialist II 11 14.7% 11.3% 9.8% 6.5% Streets Maintenance Supervisor 10 18.2% 9.5% 13.5% 5.4% Deputy City Clerk 9 12.2% 9.4% 6.4% 5.9% Code Compliance Supervisor 7 22.8% 8.6% 16.3% 6.7% Plans Examiner 4 10.9% 7.2% 11.8% 4.8% Executive Assistant 5 10.4% 5.5% 6.5% 6.3% City Engineer 10 3.7% -0.3% -1.1% -1.5% Transportation Engineer 6 6.8% 1.3% 4.2% 0.3% Senior Engineer 9 1.4% 1.2% 0.8% -1.2% Director of Public Works 9 5.0% 0.7% 4.3% -5.7% Information Systems Manager 8 8.7% 0.4% 3.2% -4.3% Director of Administrative Services 5 -0.4% -2.0% -6.4% -8.0% Information Systems Administrator 5 -2.8% -3.1% -1.0% -6.4% Director of Economic Development 7 10.9% -3.2% 3.1% -2.1% Deputy City Treasurer 1 ISD ISD ISD ISD Director of Community Development 1 ISD ISD ISD ISD Director of Finance 3 ISD ISD ISD ISD Risk Manager 1 ISD ISD ISD ISD Tourism and Marketing Manager 2 ISD ISD ISD ISD Base Salary Market Median Top monthly salary market results show that 30 classifications are paid above the market median: ➢ Three classifications are paid above the market median by 5% or less; ➢ Two classifications are paid above the market median by more than 5%and less than 10%; ➢ Five classifications are paid above the market median by more than 10% and less than 15%; ➢ Five classifications are paid above the market median by more than 15% and less than 20%; ➢ Fourteen classifications are paid above the market median by more than 20% and less than 30%; and ➢ One classification is paid above the market median by more than 30%. 10 KEE Total Compensation Study - Final Report City of Palm Desert Top monthly salary market results show that two classifications are paid below the market median by less than 5%. There are five classifications for which we did not find sufficient data. Generally,we consider a classification falling within 5%of the market to be competitive for salary survey purposes because of the differences in compensation policy and actual scope of work and position requirements. Market 7Oth Percentile Top monthly salary market results show that 28 classifications are paid above the market 70th percentile: ➢ Four classifications are paid above the market 70th percentile by 5% or less; ➢ Five classifications are paid above the market 70t" percentile by more than 5% and less than 10%; > Five classifications are paid above the market 70t" percentile by more than 10% and less than 15%; > Five classifications are paid above the market 70t" percentile by more than 15% and less than 20%; ➢ Eight classifications are paid above the market 70t" percentile by more than 20% and less than 30%; and ➢ One classification is paid above the market 70t" percentile by more than 30%. Top monthly salary market results show that four classifications are paid below the market 70tn percentile by less than 5%. Total Compensation Market Median Total compensation market results show that 29 classifications are paid above the market median: ➢ Five classifications are paid above the market median by 5%or less; ➢ Three classifications are paid above the market median by more than 5% and less than 10%; ➢ Six classifications are paid above the market median by more than 10%and less than 15%; ➢ Six classifications are paid above the market median by more than 15%and less than 20%; and ➢ Nine classifications are paid above the market median by more than 20% and less than 30%. 11 Klig Total Compensation Study - Final Report City of Palm Desert Total compensation market results show that three classifications are paid below the market median with one classification paid below the market median by less than 5%; and one classification paid below the market median by more than 5% and less than 10%. Market 70th Percent& Total compensation market results show that 25 classifications are paid above the market 70th percentile: ➢ Two classifications are paid above the market 70' percentile by 5% or less; ➢ Seven classifications are paid above the market 70' percentile by more than 5% and less than 10%; ➢ Five classifications are paid above the market 70" percentile by more than 10% and less than 15%; ➢ Eight classifications are paid above the market 70' percentile by more than 15% and less than 20%; and ➢ Three classifications are paid above the market 70th percentile by more than 20%and less than 30%. Total compensation market results show that seven classifications are paid below the market 70th percentile with four classifications are paid below the market 70' percentile by less than 5%; and three classifications are paid below the market 70th percentile by more than 5% and less than 10%. Overall, the differences between market base salaries and total compensation indicate that the City's benefits package puts the City at a less competitive advantage. Further analysis indicates that, on average, classifications are 12.3% above the market 70' percentile for base salaries, while that figure changes to 8.9% above the market median for total compensation, which is a 3.4% difference (i.e., the City "loses" a 3.4% competitive advantage when taking benefits into consideration). Benefits The market benefits data reveals the major contributing factors where the City loses a competitive is in leave benefits offered. The vacation leave reported is for an employee who has completed five years of service. The City offers less vacation hours as compared to seven of the twelve comparator agencies. Furthermore, the City offers less hours of holiday pay as compared to nine of the comparator agencies. INTERNAL SALARY RELATIONSHIPS Building from the salary levels established for identified benchmark classes, internal salary relationships were developed and consistently applied in order to develop specific salary recommendations for all non-benchmarked classifications. 12 KEE Total Compensation Study - Final Report City of Palm Desert In the future,the City may need to utilize internal alignment practices if the number of staff grows and additional classifications are added or classifications change. Internal alignment is the relationship between classifications within an organization based on duties performed, scope and level of responsibility, qualifications required to perform the work, and other factors (i.e., the same factors analyzed when comparing the City's classifications to the external labor market). These internal relationships form a compensation structure that supports the organizational strategy, workflow, and above all is equitable to employees In addition, the following are standard human resources practices that are commonly applied when making salary recommendations based upon internal relationships: ➢ A salary within 5% of the market average or median is considered to be competitive in the labor market for salary survey purposes because of the differences in compensation policy and actual scope of the position and its requirements. However, the City can adopt a closer standard. ➢ Certain internal percentages are often applied. Those that are the most common are: • The differential between a trainee and experienced (or journey) class in a series (I/II or Trainee/Experienced) is generally 10%to 15%; • A lead or advanced journey-level (III or Senior-level) class is generally placed 10% to 15% above the journey-level. • A full supervisory class is normally placed at least 10% to 25% above the highest level supervised, depending upon the breadth and scope of supervision. ➢ When a market or internal equity adjustment is granted to one class in a series, the other classes in the series are also adjusted accordingly to maintain internal equity. Internal equity between certain levels of classifications is a fundamental factor to be considered when making salary decisions. When conducting a market compensation survey, results can often show that certain classifications that are aligned with each other are not the same in the outside labor market. However, as an organization, careful consideration should be given to these alignments because they represent internal value of classifications within job families, as well as across the organization. For the purposes of this study, K&A utilized market data to develop the salary recommendations for all of the benchmarked classifications, and used internal equity principles to make the salary recommendations for 22 classifications that were not benchmarked and for the 5 benchmark classifications with insufficient market salary data. For these classifications, internal alignments with other classifications were considered, either in the same class series or those classifications that have similar scope of work, level of responsibility, and "worth" to the City. Where it is difficult to ascertain internal relationships due to unique qualifications and responsibilities, reliance can be placed on past internal relationships. It is important for the City management to carefully review these internal relationships and determine if they are still appropriate given the current market data. It is also important to analyze market data and internal relationships within class series as well as across the organization, and make adjustments to salary range placements, as necessary, based on the needs of the organization. 13 Klig Total Compensation Study - Final Report City of Palm Desert The City may want to make internal equity adjustments or alignments, as it implements the compensation strategy. This market survey is only a tool to be used by the City to determine market indexing and salary determination. RECOMMtNUAI IVNJ Pay Philosophy The City has many options regarding what type of compensation plan it wants to implement. This decision will be based on what the City's pay philosophy is, at which level it desires to pay its employees compared to the market, whether it is going to consider additional alternative compensation programs, and how great the competition is with other agencies over recruitment of a highly-qualified workforce. The City Council approved a pay philosophy to compensate employees compared to the 70' percentile. Proposed Salary Structure Currently, the City has a salary structure with ranges that are approximately 2.5% apart from one another. Each salary range has eight steps with 5% between Steps 1 to 6, 3.5% between Step 6 and 7, and 3.9% between Step 7 and 8. It is recommended that the City maintain a similar salary structure. Appendix III contains the current salary range structure. It is important to note that the salary range structure connects all salary ranges, and their steps, by formula,thereby allowing for COLAs to be applied to only one-dollar figure in the table/matrix, which then automatically updates the entire table. Due to the formula that connects each range to the next (with 2.5% differentials between each range), there is a compounding effect when drawing relationships that span several ranges. For example, with 2.5% differentials between ranges, four ranges should represent a 10% differential. However, because the compounding effect of 2.5%, on top of 2.5%, on top of 2.5%, and so on, the differential between Range 1 and Range 5 is not exactly 10%, but it is slightly greater. Proposed Salary Range Placements Appendix IV illustrates the proposed salary range placement for each classification based on the market data as well as the internal relationship analysis. The recommendations are based on base salary 70' percentile market results. Classifications are placed within the proposed salary range with a Step 8 salary closest to the top monthly market 70th percentile salary. K&A also modified the current internal alignment in certain instances where it seemed warranted based on market-supported groupings and/or compaction issues. For all classifications, this primary implementation procedure must be completed only at the initial time of implementation. In the future, if the City decides to implement annual across-the- board cost of living adjustment increases, only the salary schedule that was developed and included herein needs to be increased by the appropriate percentage, and each individual salary range will move up with this adjustment. This will ensure that the internal salary relationships are preserved and the salary schedule remains structured and easily administered. 14 Kit Total Compensation Study - Final Report City of Palm Desert Options for Implementation The following are options that the City Council may or may not decide to implement. While the City may be interested in bringing all salaries to the market 70th percentile, in some cases this goal may not be reached with a single adjustment. In this case, one option is to use a phased implementation approach. Normally, if the compensation implementation program must be carried over months or years, the classes that are farthest from the market 70th percentile should receive the greatest equity increase (separate from any cost of living increase). If a class falls within 5% of the market 70th percentile, it would be logical to make no equity adjustment in the first round of changes. However, if a class is more than 5% (or in this case, more than 20%) below the market 70th percentile, a higher percentage change may be initially warranted to reduce the disparity. Another option is to move employees into the salary range that is recommended for each class based on this market study and to the step within the new range that is closest to their current compensation. If employees' current salaries are significantly below market so that their current compensation falls below the bottom of the newly recommended range,then larger adjustments would be needed to move those employees at least to the bottom of the new salary range. The City may spend additional time to go through a process of deliberation and decision-making as to what compensation philosophy it should implement to attract, motivate, and retain a high- quality workforce. However, the City may want to consider adjusting those classifications' salaries that are currently below the market median as soon as possible, assuming that incumbents' performance meets the City's level of expectation. When classifications are over market, K&A typically recommends Y-rating employees whose current pay exceeds the maximum of the recommended range until the market numbers "catch up" with their current salary. To Y-rate an employee means to keep the employee's salary frozen and to provide no salary increases (including no cost of living adjustments) until the employee's current salary is within the recommended salary range. This will result in no immediate loss of income, but will delay any future increases until the incumbent's salary is within the salary range. Other options to "freezing" a classification's salary in place until the market catches up are: ➢ "Grandfathering" of salary ranges: This means that the salary range for the classification is adjusted down to what the market numbers are. However, current incumbents would continue being paid at the current rate of pay (which would put them outside of the new and adjusted salary range for the class) until they separate from employment with the City. Any new-hires would be paid within the newly established salary range. ➢ Single-incumbent classes: If a class only has one incumbent, an option would be to wait until the person separates from employment with the City and then adjust the salary range for the class according to the market. ➢ Recent hires: Some employees who have recently been hired may still be at one of the lower steps within their current salary range. So, even if the top of their current salary range is above market,the incumbents are currently still paid below the market maximum 15 Total Compensation Study - Final Report City of Palm Desert because they are not at the top of their current salary range. In this case, an immediate salary range adjustment could be made to bring the salary range within the market. This would bring the affected incumbents either to the top of the market range or very close to it, but they would not technically be Y-rated or lose any pay. Another option, of course, is to actually reduce salaries down to the market. However, from an employee relations perspective this may not be a viable option. USING THE MARKET DATA AS A TOOL K&A would like to reiterate that this report and the findings are meant to be a tool for the City to create and implement an equitable compensation plan. Compensation strategies are designed to attract and retain excellent staff; however, financial realities and the City's expectations may also come into play when determining appropriate compensation philosophies and strategies. The collected data presented herein represents a market survey that will give the City an instrument to make future compensation decisions. It has been a pleasure working with the City on this critical project. Please do not hesitate to contact us if we can provide any additional information or clarification regarding this report. Respectfully submitted by, Koff&Associates Georg S. Krammer Chief Executive Officer 16 Kg5, Total Compensation Study - Final Report City of Palm Desert Appendix I Results Summary Appendix I City of Palm Desert Results Summary May 2018 Top Monthly Salary Data Totaljagibly Compensation Data Classification #of Matches Top Monthly Average of %above or Median of %above or 70th Percentile %above or Total Monthly Average of %above or Median of %above or 70th Percentile %above or Salary Comparators below Comparators below of Comparators below Comp Comparators below , Comparators below of Comparators below Accountant 12 $9,248 $7,309 21.0% $7,103 23.2% $8,026 13.2% $12,738 $10,575 17.0% $10,131 20.5% $11,408 10.4% Accounting Technician 12 $7,224 $5,242 27.4% $5,314 26.4% $5,640 21.9% $10,248 $7,991 22.0% $7,905 22.9% $8,375 18.3% Associate Planner 11 $10,210 $7,606 25.5% _ $7,704 24.5% $7,767 23.9% $13,856 $10,850 21.7% $10,648 23.2% _ $11,146 19.6% Building Inspector II 11 $8,172 $6,745 17.5% $6,732 17.6% $6,826 16.5% $11,331 $9,770 13.8% $9,650 14.8% $10,161 10.3% _ City Clerk 9 $13,730 $11,033 19.6% $10,461 23.8% $12,146 11.5% $18,180 $15,580 14.3% $15,783 13.2% $16,705 8.1% City Engineer 11 $13,730 $13,079 4.7% $13,223 3.7% $13,770 -0.3% $18,180 $17,572 3.3% $18,376 -1.1% $18,453 -1.5% Code Compliance Officer II 12 $8,172 $6,046 26.0% _ $6,007 26.5% $6,274 23.2% $11,331 $8,945 21.1% $8,863 21.8% $8,977 20.8% _ Code Compliance Supervisor 7 $9,248 $7,792 15.7% $7,136 22.8% $8,449 8.6% $12,738 $10,972 13.9% $10,656 16.3% $11,887 6.7% Deputy City Clerk 9 $8,172 $7,051 13.7% $7,177 12.2% _ $7,400 9.4% $11,331 $10,182 10.1% $10,608 6.4% _ $10,664 5.9% _ Deputy City Treasurer 1 $10,210 ISD ISD ISD ISD _ ISD ISO $13,856 ISD ISD ISD ISD _ ISD ISO _ Director of Administrative Services 5 $13,730 $13,961 -1.7% $13,791 -0.4% $14,000 -2.0% $18,180 $19,075 -4.9% $19,350 -6.4% $19,642 -8.0% Director of Building and Safety 7 $14,073 $11,393 19.0% $10,978 22.0% $12,384 12.0% $18,582 $15,236 18.0% $14,993 19.3% $16,463 11.4% Director of Community Development 1 $14,780 ISD ISD ISD ISD ISD ISO $19,411 ISD ISD ISD ISD ISD ISO Director of Economic Development 7 $13,067 $12,117 7.3% $11,637 10.9% $13,483 -3.2% $17,403 $16,544 4.9% $16,866 3.1% $17,773 -2.1% Director of Finance 3 $15,923 ISD ISD ISD ISD ISD ISO $20,750 ISD ISD ISD ISD ISD ISO Director of Public Works 9 $15,923 $15,034 5.6% $15,133 5.0% $15,819 0.7% $20,750 $20,627 0.6% $19,862 4.3% $21,939 -5.7% Engineering Assistant 7 $9,722 $6,973 28.3% $7,070 27.3% $7,417 23.7% $13,102 $9,804 25.2% $9,694 26.0% $10,158 22.5% Executive Assistant 5 $7,224 $6,236 13.7% $6,472 10.4% $6,826 5.5% $10,248 $8,966 12.5% $9,580 6.5% $9,600 6.3% _ Facilities Manager 9 $10,993 $7,343 33.2% $7,492 31.9% $7,669 30.2% $14,761 $10,529 28.7% $10,785 26.9% $11,196 1 24.2% Information Systems Administrator 5 $7,404 $7,456 -0.7% $7,614 -2.8% $7,631 -3.1% $10,454 $10,625 -1.6% $10,562 -1.0% $11,119 -6.4% Information Systems Manager 8 $12,437 $11,468 7.8% $11,353 8.7% $12,392 0.4% $16,425 $15,947 2.9% $15,894 3.2% $17,127 -4.3% _ Landscape Specialist 5 $8,172 $6,417 21.5% $6,284 23.1% $6,645 18.7% $11,331 $9,297 18.0% $8,734 22.9% $9,497 16.2% Landscape Supervisor 11 $9,248 $7,484 19.1% $7,492 19.0% $7,692 16.8% $12,738 $10,656 16.3% $10,785 15.3% $11,258 11.6% Maintenance Worker II 11 $6,075 _ $4,783 21.3% $4,651 23.4% $5,129 15.6% $8,935 $7,427 16.9% $7,378 17.4% $7,561 15.4% _ Management Specialist II 11 $7,224 $6,224 13.8% $6,163 14.7% $6,405 11.3% $10,248 $9,070 11.5% $9,248 9.8% $9,587 6.5% Office Specialist II 11 $5,785 $4,480 22.6% $4,444 23.2% $4,533 21.6% $8,604 1 $6,963 19.1% $7,101 17.5% $7,147 16.9% Plans Examiner 4 $7,589 $6,906 9.0% $6,766 10.9% $7,041 7.2% $10,665 $9,668 9.4% $9,406 11.8% $10,154 4.8% Project Manager 5 $10,210 $7,774 23.9% $7,952 22.1% $7,957 22.1% $13,856 $10,852 21.7% $10,908 21.3% $11,098 19.9% Public Works Inspector II 6 $8,587 $6,593 23.2% $6,637 22.7% $6,721 21.7% $11,805 $9,439 20.0% $9,372 20.6% $10,015 15.2% Risk Manager 1 $10,726 _ ISD ISD ISD ISD ISD ISO $14,453 ISD ISD ISD ISD ISD ISO Senior Engineer 9 $10,726 $10,324 3.8% $10,571 1.4% $10,598 1.2% $14,422 $14,293 0.9% $14,301 0.8% $14,602 -1.2% Senior Management Analyst 7 $10,210 $8,367 18.0% $8,563 16.1% $8,599 15.8% $13,856 $11,836 14.6% $11,950 13.8% $12,056 13.0% Streets Maintenance Supervisor 10 $9,248 $7,500 18.9% $7,563 18.2% $8,371 9.5% $12,738 $10,931 14.2% $11,021 13.5% $12,053 5.4% Supervising Plans Examiner 4 $9,248 $7,898 14.6% $7,783 15.8% $7,980 13.7% $12,738 $11,050 13.3% $11,037 13.4% $11,640 8.6% Tourism and Marketing Manager 2 $10,726 ISD ISD ISD ISD ISD ISD $14,453 ISD ISD ISD ISD ISD ISD Traffic Signal Technician II 5 $8,172 _ $5,649 30.9% $6,351 22.3% $6,382 21.9% $11,331 $8,330 26.5% $9,503 16.1% $9,509 16.1% Transportation Engineer 6 $10,993 $10,127 7.9% $10,246 6.8% $10,852 1.3% $14,761 $13,886 5.9% $14,147 4.2% $14,718 0.3% AVERAGE: 16.6% AVERAGE: 16.7% AVERAGE: 12.2% AVERAGE: 13.5% AVERAGE: 13.1% AVERAGE: 8.9% MEDIAN: 18.5% MEDIAN: 18.6% MEDIAN: 12.6% MEDIAN: 14.2% MEDIAN: 14.3% MEDIAN: 9.5% Page 1 of 1 Kg5, Total Compensation Study - Final Report City of Palm Desert Appendix II Market Compensation Findings Appendix II City of Palm Desert Market Compensation-Sorted by Top Monthly Salary May 2018 Accountant Sala Comparator Agency Classification Title t ly Effective Increase 'ercen age 1 City of Indian Wells Senior Accountant $9,811 $5,347 $15,158 unknown unknown unknown City of Palm Desert Accountant $9,248 Mr1W8 unknown unknown unknow 3 City of Temecula Accountant II $8,404 $3,675 $12,079 7/1/2017 7/1/2019 unknown 4 City of Cathedral City Accountant II $8,260 $3,413 $11,673 1/14/2018 unknown unknown 5 City of Indio Accountant $8,169 $3,370 $11,539 4/13/2017 unknown unknown 6 City of Palm Springs Accountant $7,692 $3,410 $11,102 6/18/2017 unknown unknown 7 City of Dana Point Accountant $7,340 $2,752 $10,092 10/1/2017 unknown unknown 8 City of La Quinta Management Specialist $6,865 $2,487 $9,353 6/26/2017 unknown unknown 9 City of San Marcos Accountant $6,732 $3,437 $10,169 7/1/2017 unknown unknown 10 City of Rancho Mirage' Accountant $6,390 $3,120 $9,510 7/1/2017 7/1/2018 1.5% 11 City of Poway Accountant $6,134 $2,917 $9,050 7/1/2017 7/1/2018 2.00% 12 City of Coachella Accountant $6,018 $2,853 $8,872 7/1/2017 unknown unknown 13 City of Redlands Accountant S 5.900 S 2.404 $8.304 7/1/2016 unknown unknown mmary Results Top Monthly otal onthly Average of Comparators $7,309 $10,575 %City of Palm Desert Above/Below 21.0% 17.0% Median of Comparators $7,103 $10,131 %City of Palm Desert Above/Below 23.2% 20.5% 70th Percentile of Comparators $8,026 $11,408 %City of Palm Desert Above/Below 13.2% 10.4% Number of Matches 12 12 N/C-Non Comparator 1-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 Page la of 37 Appendix II City of Palm Desert Benefit Detail May 2018 City of Palm ity of Cathedral City o City of Rancho City of San City of Agency Desert City Coache Point Wells ity of Indio ity of La Quints Springs of Poway Mirage City of Redlands Marcos Temecula Benchmark/Comparator Senior Management Agency Match Accountant Accountant II Accountant Accountant Accountant Specialist Accountant Accountant Accountant Accountant Accountant Accountant II 9 Y Accountant (Accountant) Top Monthly $9,248 $8,260 $6,018 $7,340 $9,811 $8,169 $6,865 $7,692 $6,134 $6,390 $5,900 $6,732 $8,404 Salary — Classic 2%@55 2%@60 2%@60 2%@55 2.75%@55 2.7%@55 2%@60 2%@60 2%@60 2%@60 2%@55 2%@55 2%@60 Enhanced Formula • 250 $124 $90 $198 $628 $523 $103 $115 $92 $96 $159 $182 $126 Cost ER Paid Member $578 $588 Contrib C. Calc Classic EPMC E as Spec Comp $40 $41 re Single Highest Year $37 $59 $30 Social Security' $1,217 $506 $366 $417 Deferred IIIII $208 $245 $149 $108 $72 Compensation _ Other Ret. _ _ $-743 — - — — $-252 Cafeteria _ _ _ $1,911 $1,275 $83 $1,400 $1,668 $2,011 $516 $108 $1,200 Health $1,817 $1,734 $1,828 $1,817 $397 $1,949 u Dental $169 $141 $86 $203 m Vision _ $21 $36 _ _ $12 _ $40 m Life $36 $17 $13 $9 $12 $11 $16 $23 LTD _ $20 $13 $66 $52 $26 $88 $31 $58 $19 STD/SDI $8 $32 $31 $94 $14 Other Ins. $400 y Vacation'.' $667 $370 $847 $604 $471 $396 $799 _ $425 $369 $227 $388 $941 m Holidays $572 $347 $395 $491 $408 $264 $385 $283 $320 $298 $337 $388 Admin Leave — $340 1 $242 Auto -y� 413 $2.853 $2.752 $5.347 $3.370 $2.487 2.917 $3.120 $2.404 N/C-Non Comparator 1-City of Indian Wells:City pays employer portion of Social Security.City reimburses employees for employee portion of Social Security benefits. 2-City of Dana Point City offers comprehensive leave that includes vacation and sick leave combined. 3-City of Palm Springs:City offers annual leave that includes vacation and sick leave combined. Page 1 b of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Total Monthly Compensation May 2018 Accountant Top Month! nefits Total Salary Next Sala Next Comparator Agency assification Title Monthly Effective 'ercentage Salary ckage Increa Comp Date crease 1 City of Indian Wells Senior Accountant $9,811 $5,347 $15,158 unknown unknown unknown City of Plirt ErAccountant $9,248 unknow 3 City of Temecula Accountant II $8,404 $3,675 $12,079 7/1/2017 7/1/2019 unknown _ 4 City of Cathedral City Accountant II $8,260 $3,413 $11,673 1/14/2018 unknown unknown 5 City of Indio Accountant $8,169 $3,370 $11,539 4/13/2017 unknown unknown 6 City of Palm Springs Accountant $7,692 $3,410 $11,102 6/18/2017 unknown unknown 7 City of San Marcos Accountant $6,732 $3,437 $10,169 7/1/2017 unknown unknown 8 City of Dana Point Accountant $7,340 $2,752 $10,092 10/1/2017 unknown unknown 9 City of Rancho Mirage' Accountant $6,390 $3,120 $9,510 7/1/2017 7/1/2018 1.5% 10 City of La Quinta Management Specialist $6,865 $2,487 $9,353 6/26/2017 unknown unknown 11 City of Poway Accountant $6,134 $2,917 $9,050 7/1/2017 7/1/2018 2.00% 12 City of Coachella Accountant $6,018 $2,853 $8,872 7/1/2017 unknown unknown 13 City of Redlands Accountant 5 5.900 S 2.404 S 8.304 7/1/2016 unknown unknown 'Ur Summary Results Toonthly Total Monthly Average of Comparators $7,309 $10,575 %City of Palm Desert Above/Below 21.0% 17.0% Median of Comparators $7,103 $10,131 %City of Palm Desert Above/Below 23.2% 20.5% 70th Percentile of Comparators $8,026 $11,408 City of Palm Desert Above/Below 13.2% 10.4% Number of Matches 12 12 N/C-Non Comparator 1-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 Page 1 c of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Top Monthly Salary May 2018 Accountin•Technician Total Salary ' omparator Agency Classification Title la kage Monthly Effectiv ncrease -ercentage Comp Date Increase 1 City of Palm Desert Accounting Technician $7,224 $3,024 $10,248 unknown unknown unknown 2 City of Indian Wells Accounting Technician II $6,185 $4,149 $10,333 unknown unknown unknown 3 City of Temecula' [Accounting Technician I/Accounting Technician II] $5,804 $2,821 $8,626 7/1/2017 7/1/2019 unknown 4 City of Indio Accounting Technician II $5,762 $2,792 $8,554 4/13/2017 unknown unknown 5 City of San Marcos Accounting Technician $5,652 $3,216 $8,868 7/1/2017 unknown unknown 6 City of Dana Point Accounting Technician $5,611 $2,063 $7,674 10/1/2017 unknown unknown 7 City of La Quinta Management Assistant(Account Technician) $5,412 $2,326 $7,738 6/26/2017 unknown unknown 8 City of Coachella Accounting Technician II $5,216 $2,743 $7,959 7/1/2017 unknown unknown 9 City of Cathedral City Accounting Technician $5,044 $2,808 $7,852 7/2/2017 unknown unknown 10 City of Rancho Mirage' Accounting Technician II $5,007 $2,951 $7,957 _ 7/1/2017 7/1/2018 1.5% 11 City of Palm Springs Account Clerk II $4,651 $2,727 $7,378 6/18/2017 unknown unknown 12 City of Poway Accounting Technician II $4,404 $2,679 $7,084 7/1/2017 7/1/2018 0.02 13 City of Redlands Accounting Technician II $4,153 $1,714 $5,867 7/1/2016 unknown unknown mmary Results Top Monthly Total Monthly Average of Comparators $5,242 $7,991 %City of Palm Desert Above/Below 27.4% 22.0% Median of Comparators $5,314 $7,905 %City of Palm Desert Above/Below 26.4% 22.9% 70th Percentile of Comparators $5,640 $8,375 %City of Palm Desert Above/Below 21.9% 18.3% Number of Matches 12 12 N/C-Non Comparator 1-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 2-City of Temecula:Span of Responsibility Match:This hybrid match represents that the duties are bridged by a higher and lower level classification at the comparator agency. The salary displayed is an average of the matches. Page 2a of 37 Appendix II City of Palm Desert Benefit Detail May 2018 City of Palm ity of Cathedral City o ity of Rancho City of San City of Agency Desert City Coache Point Wells ity of Indio ity of La Quints Springs o •oway Mirage City of Redlands Marcos Temecula Management [Accounting Benchmark/Comparator Accounting Accounting Accounting Accounting Accounting Accounting Accounting Accounting Accounting Accounting Assistant Account Clerk II Technician I/ Agency Match Technician Technician Technician II Technician Technician II Technician II Technician II Technician II Technician II Technician (Account Accounting Top Monthly $7,224 $5,044 $5,216 $5,611 $6,185 $5,762 $5,412 $4,651 $4,404 $5,007 $4,153 $5,652 $5,804 Salary _ Classic 2%@55 2%@60 2%@60 2%@55 2.75%@55 2.7%@55 2%@60 2%@60 2%@60 2%@60 2%@55 2%@55 2%@60 Enhanced Formula $195 $76 $78 $152 $396 $369 $81 $70 $66 $75 $112 $153 $87 Cost ER Paid Member $406 Contrib C. Calc Classic EPMC E as Spec Comp $28 re Single Highest Year $28 $37 $21 Secial Security' $767 $357 $258 $350 DeferredIIIIIII $100 $155 $149 $108 Compensation Other Ret. _ _ _ - — — $-174 Cafeteria _ _ $1,911 $1,150 $83 $1,400 $1,668 $1,985 $503 $108 $1,200 Health $1,817 $1,734 $1,828 $1,817 $397 $1,949 u Dental $169 $141 $86 $203 m Vision $21 $36 $12 $40 m Life $11 $17 $13 $9 $11 $8 $16 $20 LTD _ $12 $12 $66 $37 $26 $53 $22 $58 $16 STD/SDI $7 $32 $31 $94 $12 Other Ins. $400 y Vacation'•' $349 $321 $432 $381 $332 $312 $376 _ $305 $289 $160 $326 $606 m Holidays _ $349 $301 $302 $309 $288 $208 $233 $203 $250 $264 $283 $268 Admin Leave — Auto 17122BEEL MM. 808 $2.743 $2.063 $4,149 $2,792 $2,326 $2,727 2.679 $2,951 $1,714 $3.216 $2.821 N/C-Non Comparator 1-City of Indian Wells:City pays employer portion of Social Security.City reimburses employees for employee portion of Social Security benefits. 2-City of Dana Point City offers comprehensive leave that includes vacation and sick leave combined. 3-City of Palm Springs:City offers annual leave that includes vacation and sick leave combined. Page 2b of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Total Monthly Compensation May 2018 Accountin•Technician Total Salary Next • ator Agency Classification Title Monthly Benefits Month! Effectiv xt Salary Percentag: alary Package crease Com Date lncreas 1 City of Indian Wells Accounting Technician II 6 185 S 4.149 S 10.333 unknown unknown unknown Ilbmurdirrechnifin $7, unknownknown 3 City of San Marcos Accounting Technician $5,652 $3,216 $8,868 7/1/2017 unknown unknown 4 City of Temecula' [Accounting Technician I/Accounting Technician II] $5,804 $2,821 $8,626 7/1/2017 7/1/2019 unknown 5 City of Indio Accounting Technician II $5,762 $2,792 $8,554 4/13/2017 unknown unknown 6 City of Coachella Accounting Technician II $5,216 $2,743 $7,959 7/1/2017 unknown unknown 7 City of Rancho Mirage' Accounting Technician II $5,007 $2,951 $7,957 7/1/2017 7/1/2018 1.5% 8 City of Cathedral City Accounting Technician $5,044 $2,808 $7,852 7/2/2017 unknown unknown 9 City of La Quinta Management Assistant(Account Technician) $5,412 $2,326 $7,738 6/26/2017 unknown unknown 10 City of Dana Point Accounting Technician $5,611 $2,063 $7,674 10/1/2017 unknown unknown 11 City of Palm Springs Account Clerk II $4,651 $2,727 $7,378 6/18/2017 unknown unknown 12 City of Poway Accounting Technician II $4,404 $2,679 $7,084 7/1/2017 7/1/2018 2% 13 City of Redlands Accounting Technician II $4,153 $1,714 $5,867 7/1/2016 unknown unknown Summary Results Top Monthly Total Monthly Average of Comparators $5,242 $7,991 %City of Palm Desert Above/Below 27.4% 22.0% Median of Comparators $5,314 $7,905 %City of Palm Desert Above/Below 26.4% 22.9% 70th Percentile of Comparators $5,640 $8,375 %City of Palm Desert Above/Below 21.9% 18.3% Number of Matches 12 12 N/C-Non Comparator 1-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 2-City of Temecula:Span of Responsibility Match:This hybrid match represents that the duties are bridged by a higher and lower level classification at the comparator agency. The salary displayed is an average of the matches. Page 2c of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Top Monthly Salary May 2018 Associate Planner Total Salary ' omparator Agency Classification Title Sala Package Monthly Effective Increase 'ercen age Comp Date i Increase 1 City of Palm Desert Associate Planner $10,211. ',646 $13,856 unknown i unknown unknown 2 City of Cathedral City Associate Planner $8,673 $3,478 $12,150 1/14/2018 unknown unknown 3 City of Indian Wells' Planner $8,318 $4,854 $13,171 unknown unknown unknown 4 City of Palm Springs Associate Planner $7,889 $3,446 $11,335 6/18/2017 unknown unknown 5 City of Rancho Mirage' Associate Planner $7,767 $3,379 $11,146 7/1/2017 7/1/2018 1.5% 6 City of La Quinta Management Analyst(Associate Planner) $7,737 $2,733 $10,470 6/26/2017 unknown unknown 7 City of Dana Point Associate Planner $7,704 $2,404 $10,108 10/1/2017 unknown unknown 8 City of Temecula' [Associate Planner I/Associate Planner II] $7,623 $3,204 $10,827 7/1/2017 7/1/2019 unknown 9 City of Coachella Associate Planner $7,159 $3,286 $10,445 7/1/2017 unknown unknown 10 City of San Marcos Associate Planner $7,136 $3,512 $10,648 7/1/2017 7/1/2018 unknown 11 City of Poway Associate Planner $7,033 $3,189 $10,222 7/1/2017 7/1/2018 2.00% 12 City of Redlands Associate Planner $6,630 $2,199 $8,829 7/1/2016 unknown unknown 13 City of Indio N/C mmary Results Top Monthly Total Monthly Average of Comparators $7,606 $10,850 %City of Palm Desert Above/Below 25.5% 21.7% Median of Comparators $7,704 $10,648 %City of Palm Desert Above/Below 24.5% 23.2% 70th Percentile of Comparators $7,767 $11,146 %City of Palm Desert Above/Below 23.9% 19.6% Number of Matches 11 11 N/C-Non Comparator 1-City of Indian Wells:No class description available. 2-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 3-City of Temecula:Span of Responsibility Match:This hybrid match represents that the duties are bridged by a higher and lower level classification at the comparator agency. The salary displayed is an average of the matches. Page 3a of 37 Appendix II City of Palm Desert Benefit Detail May 2018 Agency City of Palm ity of Cathedral City o ity of Indio ity of La Quinta ,of Poway City of Rancho City of Redlands Desert City Coache Point Springs Mirage Management [Associate Benchmark/Comparator Associate Associate Associate Associate Associate Associate Associate Associate Associate Agency Match Planner Planner Planner Planner Planner N/C Analyst Planner Planner Planner Planner Planner Planner I/ _ (Associate _Associate Top Monthly $10,210 $8,673 $7,159 $7,704 $8,318 $7,737 $7,889 $7,033 $7,767 $6,630 $7,136 $7,623 Salary _ Classic 2%@55 2%@60 2%@60 2%@55 2.75%@55 2%@60 2%@60 2%@60 2%@60 2%@55 2%@55 2%@60 Enhanced Formula . 276 $130 $107 $208 $532 $116 $118 $105 $117 $179 $193 $114 Cost ER Paid Member $607 $534 Contrib C. Calc Classic EPMC E as Spec Comp $43 $37 re Single Highest Year $39 $50 $33 Social Security' $1,031 $411 $442 Deferred IIIII $208 $208 $190 $108 Compensation Other Ret. _ _ $-781 - - - - $-229 Cafeteria _ _ _ $1,911 $1,150 $83 $1,668 $2,011 $503 $100 $1,200 Health $1,817 $1,734 $1,828 $1,817 $397 $1,949 u Dental $169 $141 $86 $203 m Vision _ $21 $36 _ _ $12 _ $40 m Life $37 $17 $13 $12 $13 $16 $25 LTD _ $21 $16 $66 $26 $91 $35 $58 $20 STD/SDI $10 $32 $31 $94 $15 Other Ins. $400 y Vacation'.' $700 $441 $593 $512 $446 $819 $487 $448 $255 $412 $795 re, Holidays _ $600 $413 $415 $416 $298 $394 $325 $388 $421 $357 $352 Admin Leave $275 $149 $108 $90 Auto r-MilMIE. ZWE 478 $3.286 $2,404 $4,854 $0 $2,733 $3,446 $3,189 $3,379 $2,199 $3,512 $3,204 N/C-Non Comparator 1-City of Indian Wells:City pays employer portion of Social Security.City reimburses employees for employee portion of Social Security benefits. 2-City of Dana Point City offers comprehensive leave that includes vacation and sick leave combined. 3-City of Palm Springs:City offers annual leave that includes vacation and sick leave combined. Page 3b of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Total Monthly Compensation May 2018 Associate Planner op Monthly Benefits Total Salary Next Salary Ne omparator Agency Classification Title Monthly Effective Percent..- Salary Package Increase City of Palm Desert Associate Planner 2 City of Indian Wells' Planner $8,318 $4,854 $13,171 unknown unknown l unknown 3 City of Cathedral City Associate Planner $8,673 $3,478 $12,150 1/14/2018 unknown unknown 4 City of Palm Springs Associate Planner $7,889 $3,446 $11,335 6/18/2017 unknown unknown 5 City of Rancho Mirage' Associate Planner $7,767 $3,379 $11,146 7/1/2017 7/1/2018 1.5% 6 City of Temecula' [Associate Planner I/Associate Planner II] $7,623 $3,204 $10,827 7/1/2017 7/1/2019 unknown 7 City of San Marcos Associate Planner $7,136 $3,512 $10,648 7/1/2017 7/1/2018 unknown 8 City of La Quinta Management Analyst(Associate Planner) $7,737 $2,733 $10,470 6/26/2017 unknown unknown 9 City of Coachella Associate Planner $7,159 $3,286 $10,445 7/1/2017 unknown unknown 10 City of Poway Associate Planner $7,033 $3,189 $10,222 7/1/2017 7/1/2018 2.00% 11 City of Dana Point Associate Planner $7,704 $2,404 $10,108 10/1/2017 unknown unknown 12 City of Redlands Associate Planner $6,630 $2,199 $8,829 T 7/1/2016 unknown unknown 13 City of Indio N/C Summary Results Top Mont Total Monthly Average of Comparators $7,606 $10,850 City of Palm Desert Above/Below 25.5% 21.7% Median of Comparators $7,704 $10,648 City of Palm Desert Above/Below 24.5% 23.2% 70th Percentile of Comparators $7,767 $11,146 City of Palm Desert Above/Below 23.9% 19.6% Number of Matches 11 11 N/C-Non Comparator 1-City of Indian Wells:No class description available. 2-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 3-City of Temecula:Span of Responsibility Match:This hybrid match represents that the duties are bridged by a higher and lower level classification at the comparator agency. The salary displayed is an average of the matches. Page 3c of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Top Monthly Salary May 2018 Building Inspector II Total Salary ' omparator Agency Classification Title ckage Monthly Effective Increase --rcenta•- Comp Date Incre- 1 City of Palm Desert Building Inspector ll ',159 $11,331 unknown unknown unkn• 2 City of Indio Building Inspector II $7,580 $3,229 $10,809 4/13/2017 unknown unknown 3 City of Indian Wells Building Inspector II $7,535 $4,595 $12,130 unknown unknown unknown 4 City of Temecula Building Inspector II $7,428 $3,163 $10,591 7/1/2017 7/1/2019 unknown 5 City of Dana Point Building Inspector $6,826 $2,261 $9,087 10/1/2017 unknown unknown 6 City of Coachella Building Inspector II $6,735 $2,952 $9,687 7/1/2017 unknown unknown 7 City of San Marcos Building Inspector $6,732 $3,429 $10,161 7/1/2017 7/1/2018 unknown _ 8 City of Cathedral City Building Inspector II $6,596 $3,054 $9,650 7/2/2017 unknown unknown _ 9 City of Palm Springs Building Inspector $6,570 $3,029 $9,599 6/18/2017 unknown unknown 10 City of Rancho Mirage' Building Inspector II $6,390 $3,120 $9,510 7/1/2017 7/1/2018 1.5% 11 City of Redlands Building Inspector II $6,002 $2,076 $8,078 7/1/2016 unknown unknown _ 12 City of La Quinta Code Administration Specialist(Building Inspector) $5,799 $2,369 $8,168 6/26/2017 unknown unknown 13 City of Poway N/C mmary Results Top Monthly Total Monthly Average of Comparators $6,745 $9,770 %City of Palm Desert Above/Below 17.5% 13.8% Median of Comparators $6,732 $9,650 %City of Palm Desert Above/Below 17.6% 14.8% 70th Percentile of Comparators $6,826 $10,161 %City of Palm Desert Above/Below 16.5% 10.3% Number of Matches 11 11 N/C-Non Comparator 1-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 Page 4a of 37 Appendix II City of Palm Desert Benefit Detail May 2018 Agency City of Palm ity of Cathedral City o ity of Indio Ity of La Quinta o •oway City of Rancho City of Redlands City of San City of Desert City Coache Point Wells Springs Mirage Marcos Temecula Benchmark/Comparator F Building Building Building Building Building Building Code Building Building Building Building Building Administration N/C Agency Match Inspector II Inspector II Inspector II Inspector Inspector II Inspector II Inspector Inspector II Inspector II Inspector Inspector II Specialist Top Monthly $8,172 $6,596 $6,735 $6,826 $7,535 $7,580 $5,799 $6,570 $6,390 $6,002 $6,732 $7,428 Salary Classic 2%@55 2%@60 2%@60 2%@55 2.75%@55 2.7%@55 2%@60 2%@60 2%@60 2%@55 2%@55 2%@60 Enhanced Formula $221 $99 $101 $184 $482 $485 $87 $99 $96 $162 $182 $111 Cost _ _ _ ER Paid Member $520 Contrib C. Calc Classic EPMC E as Spec Comp $36 re Single Highest Year $34 $45 $30 Social Security' $934 $470 $372 $417 DeferredIIIIIII $100 $188 $108 Compensation Other Ret. $-223 Cafeteria $1,911 $1,150 $83 $1,400 $1,668 $1,985 $503 $100 $1,200 Health $1,817 $1,734 $1,817 $397 $1,949 u Dental $169 $141 $203 m Vision $21 $36 $40 m Life $14 $17 $13 $9 $11 $16 $23 LTD _ $16 $15 $66 $49 $26 $76 $58 $19 STD/SDI $9 $32 $31 $94 $14 Other Ins. $400 y Vacation''' $457 $414 $525 $464 $437 $335 $531 $369 $231 $388 $775 agar Holidays _ $457 $389 $368 $377 $379 $223 $329 $320 $381 $337 $343 Admin Leave — Auto .. yTIM 054 $2.952 $2.261 $4.595 $3.229 $2. ' $3.029 $0 $3.120 $2.076 $3.429 $3.163 N/C-Non Comparator 1-City of Indian Wells:City pays employer portion of Social Security.City reimburses employees for employee portion of Social Security benefits. 2-City of Dana Point City offers comprehensive leave that includes vacation and sick leave combined. 3-City of Palm Springs:City offers annual leave that includes vacation and sick leave combined. Page 4b of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Total Monthly Compensation May 2018 Buildin. Inspector II •p Monthly Benefits Total Salary Next Salary Next omparator Agency Classification Title glary Package Monthly Effective Increase '-rcentag, Corn• Date reas- 1 City of Indian Wells Buildin!Inspector II 7 535 S 4.595 S 12,130 unknown unknown unknown Building Inspecto $8, 3 City of Indio Building Inspector II $7,580 $3,229 $10,809 4/13/2017 unknown unknown 4 City of Temecula Building Inspector II $7,428 $3,163 $10,591 7/1/2017 7/1/2019 unknown 5 City of San Marcos Building Inspector $6,732 $3,429 $10,161 7/1/2017 7/1/2018 unknown 6 City of Coachella Building Inspector II $6,735 $2,952 $9,687 7/1/2017 unknown unknown 7 City of Cathedral City Building Inspector II $6,596 $3,054 $9,650 7/2/2017 unknown unknown 8 City of Palm Springs Building Inspector $6,570 $3,029 $9,599 6/18/2017 unknown unknown 9 City of Rancho Mirage' Building Inspector II $6,390 $3,120 $9,510 7/1/2017 7/1/2018 1.5% 10 City of Dana Point Building Inspector $6,826 $2,261 $9,087 10/1/2017 unknown unknown 11 City of La Quinta Code Administration Specialist(Building Inspector) $5,799 $2,369 $8,168 6/26/2017 unknown unknown 12 City of Redlands Building Inspector II $6,002 $2,076 $8,078 7/1/2016 unknown unknown 13 City of Poway N/C Summary Results Top Monthly Total Monthly Average of Comparators $6,745 $9,770 City of Palm Desert Above/Below 17.5% 13.8% Median of Comparators $6,732 $9,650 City of Palm Desert Above/Below 17.6% 14.8% 70th Percentile of Comparators $6,826 $10,161 City of Palm Desert Above/Below 16.5% 10.3% Number of Matches 11 11 N/C-Non Comparator 1-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 Page 4c of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Top Monthly Salary May 2018 Cit Clerk Total Sal P Next Comparator Agency Classification TiMonthly ec Percentage ckage Corn Dat tease Increase 1 City of Palm Desert City Clerk $4,450 $18,181unknow 1nknown unknown 2 City of San Marcos Business Process Director-City Clerk $13,133 $5,497 $18,630 7/1/2017 unknown unknown 3 City of Temecula City Clerk $12,753 $5,272 $18,025 7/1/2017 7/1/2019 unknown 4 City of Palm Springs City Clerk $12,734 $4,324 $17,058 6/18/2017 unknown unknown 5 City of Dana Point City Clerk $11,264 $4,913 $16,177 10/1/2017 unknown unknown 6 City of Poway City Clerk $10,461 $3,912 $14,373 7/1/2017 7/1/2018 2.00% 7 City of La Quinta Manager(City Clerk) $10,158 $3,244 $13,403 6/26/2017 unknown unknown 8 City of Indian Wells City Clerk $10,134 $5,649 $15,783 unknown unknown unknown 9 City of Indio City Clerk Administrator $10,072 $3,827 $13,900 4/13/2017 unknown unknown 10 City of Rancho Mirage' City Clerk $8,583 _ $4,286 $12,869 7/1/2017 7/1/2018 1.5% 11 City of Cathedral City N/C 12 City of Coachella N/C _ 13 City of Redlands N/C mmary Results 11111111.1 Total Monthly Average of Comparators $11,033 $15,580 %City of Palm Desert Above/Below 19.6% 14.3% Median of Comparators $10,461 $15,783 %City of Palm Desert Above/Below 23.8% 13.2% 70th Percentile of Comparators $12,146 $16,705 %City of Palm Desert Above/Below 11.5% 8.1% Number of Matches 9 9 N/C-Non Comparator 1-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 Page 5a of 37 Appendix II City of Palm Desert Benefit Detail May 2018 Agency City of Palm ity of Cathedral City o ity of Indio ity of La Quints ,of Poway Cit • - • City of Desert City Coache Point Wells Springs Mirage Temecula Benchmark/Comparator City Clerk Manager(City Business Process Agency Match City Clerk N/C N/C City Clerk City Clerk Administrator Clerk) City Clerk City Clerk City Clerk N/C Director-City City Clerk Clerk Top Monthly $11,264 $10,134 $10,072 $10,158 $12,734 $10,461 $8,583 $13,133 $12,753 Salary _ Classic 2%@55 2.75%@55 2.7%@55 2%@60 2%@60 2%@60 2%@60 2%@55 2%@60 Enhanced Formula $304 $649 $645 $152 $191 $157 $129 $355 $191 Cost ER Paid Member $893 Contrib _ C. Calc Classic EPMC E as Spec Comp $62 re Single Highest Year $56 $61 Social Security' $1,257 $624 $663 Deferred $338 $253 $230 $108 Compensation Other Ret. $-383 Cafeteria $1,475 $83 $1,400 $1,668 $2,011 $108 $1,200 Health $1,734 $1,828 $1,817 $1,949 u Dental $141 $86 $203 m Vision $36 $12 $40 m Life $13 $9 $25 $19 $16 $46 • LTD $66 $64 $26 $138 $52 $58 $36 STD/SDI $32 $31 $94 $25 Other Ins. $400 y Vacation'.' $1,300 $624 $581 $586 $1,322 $724 $660 $758 $1,429 m Holidays _ $607 $507 $504 $391 $637 $483 $429 $657 $589 Admin Leave $433 $195 $391 $161 $231 $505 1 $491 Auto $400 $160 $500 $396 $400 [ .,. 522CE _IML $4.913 $5.649 $3.827 t 24 $3.912 $4.286 $0 N/C-Non Comparator 1-City of Indian Wells:City pays employer portion of Social Security.City reimburses employees for employee portion of Social Security benefits. 2-City of Dana Point City offers comprehensive leave that includes vacation and sick leave combined. 3-City of Palm Springs:City offers annual leave that includes vacation and sick leave combined. Page 5b of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Total Monthly Compensation May 2018 Cit Clerk Tot. alary Next Classification op Monthly Benefits onth ective Next Salary Percentage Salary Package Increase Increase 1 City of San Marcos Business Process Director-City Clerk S 13.133 5 5.497 5 18,630 7/1/2017 unknown unknown i WM 3 City of Temecula - City Clerk $12,753 $5,272 $18,025 7/1/2017 7/1/2019 unknown 4 City of Palm Springs City Clerk $12,734 $4,324 $17,058 6/18/2017 unknown unknown 5 City of Dana Point City Clerk $11,264 $4,913 $16,177 10/1/2017 unknown unknown 6 City of Indian Wells City Clerk $10,134 $5,649 $15,783 unknown unknown unknown 7 City of Poway City Clerk $10,461 $3,912 $14,373 7/1/2017 7/1/2018 2.00% 8 City of Indio City Clerk Administrator $10,072 $3,827 $13,900 4/13/2017 unknown unknown 9 City of La Quinta Manager(City Clerk) $10,158 $3,244 $13,403 6/26/2017 unknown unknown 10 City of Rancho Mirage' City Clerk $8,583 $4,286 $12,869 7/1/2017 7/1/2018 1.5% 11 City of Cathedral City N/C 12 City of Coachella N/C 13 City of Redlands N/C Summary Results Top Monthly Total Monthly Average of Comparators $11,033 $15,580 %City of Palm Desert Above/Below 19.6% 14.3% Median of Comparators $10,461 $15,783 %City of Palm Desert Above/Below 23.8% 13.2% 70th Percentile of Comparators $12,146 $16,705 %City of Palm Desert Above/Below 11.5% 8.1% Number of Matches 9 9 N/C-Non Comparator 1-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 Page 5c of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Top Monthly Salary May 2018 Cit En ineer Classification Title ,gip` 'ec ive 'ercentage Date Increase Increase 1 City of Palm Springs Director of Engineering Services-City Engineer $15,133 $4,729 $19,862 6/18/2017 unknown unknown 2 City of Temecula Engineering Manager $14,468 $4,691 $19,159 7/1/2017 7/1/2019 unknown 3 City of Cathedral City City Engineer $14,123 $4,330 $18,453 1/14/2018 unknown unknown 4 City of San Marcos Deputy City Engineer S 13.770 S 5.612 S 19.382 7/1/2017 unknown unknown ' .aiv_ae� .iiiiikki, $18,180 ,' .i . r 6 City of Dana Point City Engineer $13,406 $3,973 $17,379 10/1/2017 unknown unknown 7 City of Coachella City Engineer $13,223 $5,166 $18,389 1/25/2017 unknown unknown 8 City of Indio City Engineer $12,990 $5,385 $18,376 4/13/2017 unknown unknown 9 City of Poway City Engineer $12,438 $4,214 $16,652 7/1/2017 7/1/2018 2.00% 10 City of La Quintal [Director/Manager] $11,562 $3,454 _ $15,016 6/26/2017 unknown unknown 11 City of Rancho Mirage' City Engineer $11,476 $3,965 $15,440 7/1/2017 7/1/2018 1.5% 12 City of Redlands City Engineer $11,277 $3,905 $15,182 7/1/2016 unknown unknown 13 City of Indian Wells N/C mmary Results Top Monthly Total Monthly Average of Comparators $13,079 $17,572 %City of Palm Desert Above/Below 4.7% 3.3% Median of Comparators $13,223 $18,376 %City of Palm Desert Above/Below 3.7% -1.1% 70th Percentile of Comparators $13,770 $18,453 %City of Palm Desert Above/Below -0.3% -1.5% Number of Matches 11 11 N/C-Non Comparator 1-City of La Quinta:Span of Responsibility Match:This hybrid match represents that the duties are bridged by a higher and lower level classification at the comparator agency. The salary displayed is an average of the matches. 2-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 Page 6a of 37 Appendix II City of Palm Desert Benefit Detail May 2018 Agency City of Palm ity of Cathedral City o ity of Indio ity of La Quinta ,, ity of Rancho City of Redlands City of San City of Desert City Coache Point Springs Mirage Marcos Temecula Benchmark/Comparator Director of p [Director/ Deputy City Engineering Agency Match City Engineer City Engineer City Engineer City Engineer N/C City Engineer Engineering City Engineer City Engineer City Engineer 9 Y Manager] Engineer Manager Services-City Top Monthly $13,730 $14,123 $13,223 $13,406 $12,990 $11,562 $15,133 $12,438 $11,476 $11,277 $13,770 $14,468 Salary Classic 2%@55 2%@60 2%@60 2%@55 2.7%@55 2%@60 2%@60 2%@60 2%@60 2%@55 2%@55 2%@60 Enhanced Formula 371 $212 $198 $362 $831 $173 $227 $187 $172 $304 $372 $217 Cost ER Paid Member $989 $579 Contrib _ C. Calc Classic EPMC E as Spec Comp $69 $23 re Single Highest Year $67 $56 Social Security $663 $663 $663 Deferredel $208 $230 $108 $319 Compensation _ Other Ret. _ _ $-1,271 _ - - - $-434 Cafeteria $1,911 $1,275 $1,400 $1,668 $2,011 $516 $108 $1,200 Health $1,817 $1,828 $1,817 $397 $1,949 u Dental $169 $86 $203 m Vision $21 _ _ $12 _ $40 m Life $61 $43 $9 $25 $22 $16 $48 LTD _ $32 $30 $83 $26 $138 $62 $58 $38 STD/SDI $15 $31 $94 $25 Other Ins. $400 us Vacation'.' $1,141 $1,068 $1,547 $749 $667 $1,572 $861 $662 $434 $794 $1,621 d Holidays _ $978 $763 $722 $650 $445 $757 $574 $574 $520 $689 $668 Admin Leave $610 $500 $445 $191 $221 $694 $530 1 $417 Auto $433 $500 $160 $396 1:EMMIL I 330 $5.166 $3.973 $0 $5.385 $3.454 $4,729 $4.214 $3.965 $3.905 N/C-Non Comparator 1-City of Dana Point:City offers comprehensive leave that includes vacation and sick leave combined. 2-City of Palm Springs:City offers annual leave that includes vacation and sick leave combined. Page 6b of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Total Monthly Compensation May 2018 Cit En.ineer Top Month! Benefits Total Salary Next Salary Next Comparator Agency Classification Title Salary Package Monthly Effective ncrease Percentage Comp Date Increase 1 City of Palm Springs Director of Engineering Services-City Engineer $15,133 $4,729 $19,862 6/18/2017 unknown unknown 2 City of San Marcos Deputy City Engineer $13,770 $5,612 $19,382 7/1/2017 unknown unknown 3 City of Temecula Engineering Manager $14,468 $4,691 $19,159 7/1/2017 7/1/2019 unknown 4 City of Cathedral City City Engineer S 14.123 S 4.330 S 18.453 1/14/2018 unknown unknown 5 City of Coachella City Engineer $13,223 $5,166 $18,389 1/25/2017 unknown unknown 6 City of Indio City Engineer $12,990 $5,385 $18,376 4/13/2017 unknown unknown AMIltity of Palm Desert City Engineer $13,730 $4,451Min 18,181111Unknown unknown unknown 8 City of Dana Point City Engineer $13,406 $3,973 $17,379 10/1/2017 unknown unknown 9 City of Poway City Engineer $12,438 $4,214 $16,652 7/1/2017 7/1/2018 2.00% 10 City of Rancho Mirage' City Engineer $11,476 $3,965 $15,440 7/1/2017 7/1/2018 1.5% 11 City of Redlands City Engineer $11,277 $3,905 $15,182 7/1/2016 unknown unknown 12 City of La Quintal [Director/Manager] $11,562 $3,454 $15,016 6/26/2017 unknown unknown 13 City of Indian Wells N/C Summary Results Top Monthly Total Monthly Average of Comparators $13,079 $17,572 City of Palm Desert Above/Below 4.7% 3.3% Median of Comparators $13,223 $18,376 City of Palm Desert Above/Below 3.7% -1.1% 70th Percentile of Comparators $13,770 $18,453 City of Palm Desert Above/Below -0.3% -1.5% Number of Matches 11 11 N/C-Non Comparator 1-City of La Quinta:Span of Responsibility Match:This hybrid match represents that the duties are bridged by a higher and lower level classification at the comparator agency. The salary displayed is an average of the matches. 2-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 Page 6c of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Top Monthly Salary May 2018 Code Compliance Officer II Total Salary ' ompara or Agency Classification Title Monthly Effective •ercenta.: age mp Date Increase Incre.- 1 City of Palm Desert Code Compliance Officer II ,331 unknown unknown unkn• 2 City of Indian Wells Code Enforcement Officer $7,535 $4,595 $12,130 unknown unknown unknown 3 City of Indio Code Enforcement Officer II $6,527 $2,976 $9,503 4/13/2017 unknown unknown 4 City of Dana Point Code Enforcement Officer $6,375 $2,188 $8,563 10/1/2017 unknown unknown 5 City of San Marcos Code Compliance Officer $6,351 $3,351 $9,702 7/1/2017 7/1/2018 unknown 6 City of Temecula Code Enforcement Officer II $6,096 $2,882 $8,978 _ 7/1/2017 7/1/2019 unknown 7 City of Poway Code Compliance Officer $6,065 $2,907 $8,972 _ 7/1/2017 7/1/2018 2.00% 8 City of Palm Springs Code Compliance Officer $5,950 $2,932 $8,882 6/18/2017 unknown unknown 9 City of La Quinta Code Administration Specialist(Code Compliance Officer II) $5,799 $2,369 $8,168 _ 6/26/2017 unknown unknown 10 City of Rancho Mirage' Code Compliance Officer II $5,796 $3,047 $8,843 7/1/2017 7/1/2018 1.5% 11 City of Cathedral City Code Compliance Officer II $5,695 $2,911 $8,606 7/2/2017 unknown unknown 12 City of Coachella Code Enforcement Officer $5,489 $2,781 $8,269 7/1/2017 unknown unknown 13 City of Redlands Code Enforcement Officer $4,870 $1,854 $6,724 7/1/2016 unknown unknown mmary Results Top Monthly Total Monthly Average of Comparators $6,046 $8,945 City of Palm Desert Above/Below 26.0% 21.1% Median of Comparators $6,007 $8,863 City of Palm Desert Above/Below 26.5% 21.8% 70th Percentile of Comparators $6,274 $8,977 City of Palm Desert Above/Below 23.2% 20.8% Number of Matches 12 12 N/C-Non Comparator 1-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 Page 7a of 37 Appendix II City of Palm Desert Benefit Detail May 2018 Agency City of Palm ity of Cathedral City o ity of Indio ity of La Quinta City of Desert City Coache Point Wells Spring Temecula Benchmark/Comparator Code Code Code Code Code Code Code Code Code Code Code Code Agency Match Compliance Compliance Enforcement Enforcement Enforcement Enforcement Administration Compliance Compliance Compliance Enforcement Compliance Enforcement Officer II Officer II Officer Officer Officer Officer II Specialist(Code Officer Officer Officer II Officer Officer Officer II Top Monthly $8,172 $5,695 $5,489 $6,375 $7,535 $6,527 $5,799 $5,950 $6,065 $5,796 $4,870 $6,351 $6,096 Salary _ Classic 2%@55 2%@60 2%@60 2%@55 2.75%@55 2.7%@55 2%@60 2%@60 2%@60 2%@60 2%@55 2%@55 2%@60 Enhanced Formula $221 $85 $82 $172 $482 $418 $87 $89 $91 $87 $131 $171 $91 Cost ER Paid Member $427 Contrib C. Calc Classic EPMC E as Spec Comp $30 re Single Highest Year $32 $45 $24 Social Security' $934 $405 $302 $394 DeferredIIIIIII $100 $188 $149 $108 Compensation Other Ret. _ - - - - $-183 Cafeteria _ _ $1,911 $1,150 $83 $1,400 $1,668 $1,985 $503 $100 $1,200 Health $1,817 $1,734 $1,828 $1,817 $397 $1,949 u Dental $169 $141 $86 $203 m Vision $21 $36 $12 $40 m Life $12 $17 $13 $9 $11 $11 $16 $22 LTD _ $14 $12 $66 $42 $26 $68 $30 $58 $18 STD/SDI $7 $32 $31 $94 $14 Other Ins. $400 y Vacation''' $394 $338 $490 $464 $377 $335 $481 $420 $334 $187 $366 $636 agar Holidays _ $394 $317 $343 $377 $326 $223 $298 $280 $290 $309 $318 $281 Admin Leave - Auto 12=1. yTIM 911 $2.781 $2,188 $4,595 $2,976 $2. ' $2,932 $2,907 $3,047 $1,854 $3,351 $2,882 N/C-Non Comparator 1-City of Indian Wells:City pays employer portion of Social Security.City reimburses employees for employee portion of Social Security benefits. 2-City of Dana Point City offers comprehensive leave that includes vacation and sick leave combined. 3-City of Palm Springs:City offers annual leave that includes vacation and sick leave combined. Page 7b of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Total Monthly Compensation May 2018 Code Com.liance Officer II Top Monthly Benefits Total Salary Next Salary Ne • parator Agency Classification Title Monthly Effective •-rcenta. Salary Package Increase Corn. Date re 1 City of Indian Wells Code Enforcement Officer S 7.535 S 4.595 S 12.130 unknown unknown unknown 3 City of San Marcos _ Code Compliance Officer _ $6,351 $3,351 $9,702 7/1/2017 7/1/2018 unknown 4 City of Indio Code Enforcement Officer II $6,527 $2,976 $9,503 4/13/2017 unknown unknown 5 City of Temecula Code Enforcement Officer II $6,096 $2,882 $8,978 7/1/2017 7/1/2019 unknown 6 City of Poway Code Compliance Officer $6,065 $2,907 $8,972 7/1/2017 7/1/2018 2.00% 7 City of Palm Springs Code Compliance Officer $5,950 $2,932 $8,882 6/18/2017 unknown unknown 8 City of Rancho Mirage' Code Compliance Officer II $5,796 $3,047 $8,843 7/1/2017 7/1/2018 1.5% 9 City of Cathedral City Code Compliance Officer II $5,695 $2,911 $8,606 7/2/2017 unknown unknown 10 City of Dana Point Code Enforcement Officer $6,375 $2,188 $8,563 10/1/2017 unknown unknown 11 City of Coachella Code Enforcement Officer $5,489 $2,781 $8,269 7/1/2017 unknown unknown 12 City of La Quinta Code Administration Specialist(Code Compliance Officer II) $5,799 $2,369 $8,168 6/26/2017 unknown unknown 13 City of Redlands Code Enforcement Officer $4,870 $1,854 $6,724 7/1/2016 unknown unknown Summary Results Top Monthly Total Monthly Average of Comparators $6,046 $8,945 City of Palm Desert Above/Below 26.0% 21.1% Median of Comparators $6,007 $8,863 City of Palm Desert Above/Below 26.5% 21.8% 70th Percentile of Comparators $6,274 $8,977 City of Palm Desert Above/Below 23.2% 20.8% Number of Matches 12 12 N/C-Non Comparator 1-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 Page 7c of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Top Monthly Salary May 2018 Code Compliance Su ervisor ext -ercentage 1 City of Rancho Mirage' Code Compliance Manager $9,913 $3,553 $13,466 7/1/2017 7/1/2018 1.5% 2 City of Coachella Code Compliance Manager $9,568 $3,711 $13,278 7/1/2017 unknown unknown ' Desert Code Compliance Supervisor $9,248.$3.490Af$12.738 unknown unk • known 4 City of Indio Code Enforcement Supervisor $8,169 $3,370 $11,539 4/13/2017 unknown unknown 5 City of San Marcos Code Compliance Supervisor $7,136 $3,520 $10,656 7/1/2017 7/1/2018 unknown 6 City of La Quinta Code Administration Supervisor(Code Compliance Supervisor) $6,865 $2,487 _ $9,353 6/26/2017 unknown unknown 7 City of Poway Senior Code Compliance Officer $6,694 $3,138 $9,832 7/1/2017 7/1/2018 2.00% 8 City of Redlands Field Services Supervisor $6,201 I $2,477 $8,678 7/1/2016 unknown unknown 9 City of Cathedral City N/C _ 10 City of Palm Springs N/C _ _ 11 City of Temecula N/C 12 City of Indian Wells N/C 13 City of Dana Point N/C ummary Results Top Monthly 111MirTotal Monthly Average of Comparators $7,792 $10,972 %City of Palm Desert Above/Below 15.7% 13.9% Median of Comparators $7,136 $10,656 %City of Palm Desert Above/Below 22.8% 16.3% 70th Percentile of Comparators $8,449 $11,887 %City of Palm Desert Above/Below 8.6% 6.7% Number of Matches 7 7 N/C-Non Comparator 1-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013.Bachelor's degree required. Page 8a of 37 Appendix II City of Palm Desert Benefit Detail May 2018 City of Palm ity of Cathedral City o 1�City of San City of Agency ity of Indio ity of La Quinta y of Redlands Desert City Coache Spring Marcos Temecula Code Code Code Senior Code Code Code Benchmark/Comparator Field Services Agency Match Compliance N/C Compliance N/C N/C Enforcement Administration N/C Compliance Compliance Su ervisor Compliance N/C Supervisor Manager Supervisor Supervisor(Code Officer Manager P Supervisor Top Monthly $9,248 $9,568 $8,169 $6,865 $6,694 $9,913 $6,201 $7,136 Salary _ Classic o@55 2%@60 2.7%@55 2%@60 2%@60 2%@60 2%@55 2&@%5 Enhanced Formula $250 $144 $523 $103 $100 $149 $167 $193 Cost ER Paid Member Contrib C. Calc Classic EPMC d E as Spec Comp 2 re Single Highest Year $31 Social Security $506 $384 $442 Deferred $190 $108 $72 Compensation Other Ret. Cafeteria $1,400 $1,668 $516 $108 Health $1,817 $1,828 $1,817 $397 $1,949 u Dental $169 $86 $203 m Vision $21 $12 $40 m Life $17 $9 $12 $16 $25 LTD $21 $52 $26 $33 $58 $20 STD/SDI $13 $31 $94 $15 Other Ins. y Vacation $589 $471 $396 $463 $572 $238 $412 d Holidays _ $552 $408 $264 $309 $496 $313 $357 Admin Leave $368 $103 $358 Auto $3,711 $0 $0 $3,370 $2,487 $3,138 $3,553 $2,477 $3,520 $0 Page 8b of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Total Monthly Compensation May 2018 Code Com•liance Su•ervisor Total Salary Next _II p MonthlyBenefits Next Salary Agency Classification Title Salary ackage Monthly ffective Increase Percentage ji& Comp Date Increase 1 City of Rancho Mirage' Code Compliance Manager $9,913 $3,553 $13,466 7/1/2017 7/1/2018 1.5% 2 City of Coachella Code Compliance Manager $9,568 $3,711 $13,278 7/1/2017 unknown unknown 3 City of Palm Desert Code Compliance Supervisor $9,248 $3,490 $12,738 unknown unknown unknown 4 City of Indio Code Enforcement Supervisor $8,169 $3,370 $11,539 4/13/2017 unknown unknown 5 City of San Marcos Code Compliance Supervisor $7,136 $3,520 $10,656 7/1/2017 7/1/2018 unknown 6 City of Poway Senior Code Compliance Officer $6,694 $3,138 $9,832 7/1/2017 7/1/2018 2.00% 7 City of La Quinta Code Administration Supervisor(Code Compliance Supervisor) $6,865 $2,487 $9,353 6/26/2017 unknown unknown 8 City of Redlands Field Services Supervisor $6,201 $2,477 $8,678 7/1/2016 unknown unknown 9 City of Cathedral City N/C 10 City of Palm Springs N/C 11 City of Temecula N/C 12 City of Indian Wells N/C 13 City of Dana Point N/C Summary Results lop Monthly al onthly Average of Comparators $7,792 $10,972 %City of Palm Desert Above/Below 15.7% 13.9% Median of Comparators $7,136 $10,656 %City of Palm Desert Above/Below 22.8% 16.3% 70th Percentile of Comparators $8,449 $11,887 %City of Palm Desert Above/Below 8.6% 6.7% Number of Matches 7 7 N/C-Non Comparator 1-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013.Bachelor's degree required. Page 8c of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Top Monthly Salary May 2018 Deputy Cit Clerk Tota la omparator Agency lassification Title ka to Mont ecti g C Date 1 City of Temecula Deputy City Clerk $8,829 $3,780 $12,610 7/1/2017 7/1/2019 unknown I y o 'a m Desert Deputy City Clerk $8,172 $3,159 $11,331 unknown unknown unknown 3 City of Cathedral City Deputy City Clerk $7,492 $3,256 $10,748 1/14/2018 unknown unknown 4 City of Indio Deputy City Clerk $7,468 $3,202 $10,669 4/13/2017 unknown unknown 5 City of Coachella Deputy City Clerk $7,298 $3,311 $10,608 7/1/2017 unknown unknown 6 City of Dana Point Deputy City Clerk $7,177 $2,719 $9,896 10/1/2017 unknown unknown 7 City of San Marcos' Deputy City Clerk $7,136 $3,520 $10,656 7/1/2017 unknown unknown 8 City of La Quinta Management Specialist(Deputy City Clerk) $6,284 $2,423 $8,707 6/26/2017 unknown unknown 9 City of Poway Deputy City Clerk $5,917 $2,887 $8,804 7/1/2017 7/1/2018 0.02 10 City of Palm Springs Deputy City Clerk $5,863 $3,081 $8,944 6/18/2017 unknown unknown 11 City of Rancho Mirage N/C 12 City of Redlands N/C 13 City of Indian Wells N/C mmary Results Top Monthly Total Monthly Average of Comparators $7,051 $10,182 %City of Palm Desert Above/Below 13.7% 10.1% Median of Comparators $7,177 $10,608 %City of Palm Desert Above/Below 12.2% 6.4% 70th Percentile of Comparators $7,400 $10,664 %City of Palm Desert Above/Below 9.4% 5.9% Number of Matches 9 9 N/C-Non Comparator 1-City of San Marcos:No degree required,associate's degree desired. Page 9a of 37 Appendix II City of Palm Desert Benefit Detail May 2018 City of Palm ity of Cathedral City o City of Rancho City of San City of Agency ity of Indio ity of La Quints ,of Poway City of Redlands Desert City Coache Point Springs Mirage Marcos Temecula Benchmark/Comparator Deputy City Management Agency Match Clerk Deputy City Clerk Deputy City Clerk Deputy City Clerk N/C Deputy City Clerk Specialist Deputy City Clerk Deputy City Clerk N/C N/C Deputy City Clerk Deputy City Clerk (Deputy City Top Monthly $8,172 $7,492 $7,298 $7,177 $7,468 $6,284 $5,863 $5,917 $7,136 $8,829 Salary _ Classic 2%@55 2%@60 2%@60 2%@55 2.7%@55 2%@60 2%@60 2%@60 2%@55 2%@60 Enhanced Formula . 221 $112 $109 $194 $478 $94 $88 $89 $193 $132 Cost ER Paid Member $524 $618 Contrib C. Calc Classic EPMC E as Spec Comp $43 re Single Highest Year $36 Social Security $463 $442 Deferred el $208 $149 Compensation Other Ret. _ _ $-674 — — — $-265 Cafeteria $1,911 $1,275 $1,400 $1,668 $2,011 $108 $1,200 Health $1,817 $1,828 $1,949 u Dental $169 $86 m Vision $21 _ _ $12 _ m Life $32 $17 $9 $12 $11 $25 LTD _ $18 $16 $48 $26 $67 $30 $20 STD/SDI $10 $31 $15 Other Ins. $400 us Vacation'.' $605 $449 $828 $431 $363 _ $609 $410 $412 $989 agar Holidays — $519 $421 $386 $373 $242 $293 $273 $357 $408 Admin Leave _ $281 _ 1 $255 Auto =.. I FEL $3.311 $2,719 $0 $3,202 $2., $3,081 $2,887 I N/C-Non Comparator 1-City of Dana Point:City offers comprehensive leave that includes vacation and sick leave combined. 2-City of Palm Springs:City offers annual leave that includes vacation and sick leave combined. Page 9b of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Total Monthly Compensation May 2018 1 De•ut Cit Clerk Total Salary Next Top Monthly Benefits Next Salary Comparator Agency Classification Title Salary Package Monthly Effective Increase Percentage Com. I. - Increase 1 City of Temecula Deputy City Clerk $8,829 $3,780 $12,610 7/1/2017 7/1/2019 unknown City of Pa. Deputy City Clerk $8,172 unknown unknown unknown 3 City of Cathedral City Deputy City Clerk $7,492 $3,256 $10,748 1/14/2018 unknown unknown 4 City of Indio Deputy City Clerk $7,468 $3,202 $10,669 4/13/2017 unknown unknown 5 City of San Marcos' Deputy City Clerk $7,136 $3,520 $10,656 7/1/2017 unknown unknown 6 City of Coachella Deputy City Clerk $7,298 $3,311 $10,608 7/1/2017 unknown unknown 7 City of Dana Point Deputy City Clerk $7,177 $2,719 $9,896 10/1/2017 unknown unknown 8 City of Palm Springs Deputy City Clerk $5,863 $3,081 $8,944 6/18/2017 unknown unknown 9 City of Poway Deputy City Clerk $5,917 $2,887 $8,804 7/1/2017 7/1/2018 0.02 10 City of La Quinta Management Specialist(Deputy City Clerk) $6,284 $2,423 $8,707 6/26/2017 unknown unknown 11 City of Rancho Mirage N/C 12 City of Redlands N/C 13 City of Indian Wells N/C Summary Results Top Monthly Total Monthly Average of Comparators $7,051 $10,182 %City of Palm Desert Above/Below 13.7% 10.1% Median of Comparators $7,177 $10,608 %City of Palm Desert Above/Below 12.2% 6.4% 70th Percentile of Comparators $7,400 $10,664 %City of Palm Desert Above/Below 9.4% 5.9% Number of Matches 9 9 N/C-Non Comparator 1-City of San Marcos:No degree required,associate's degree desired. Page 9c of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Top Monthly Salary May 2018 De.ut Cit Treasurer Sala omparator Agency Classification Title ont ly Effective Increase -ercen age Comp Date Increase 1 City of Palm Desert Deputy City Treasurer 13,856 unknown unknown unknown 2 City of Palm Springs Deputy City Treasurer $7,889 $3,446 $11,335 6/18/2017 unknown unknown 3 City of La Quinta N/C 4 City of Poway N/C 5 City of Indian Wells N/C 6 City of Redlands N/C 7 City of Rancho Mirage N/C 8 City of Dana Point N/C 9 City of Cathedral City N/C 10 City of Temecula N/C 11 City of Coachella N/C 12 City of Indio N/C 13 City of San Marcos N/C mmary Results Mo Total Monthly Average of Comparators I5D ISD City of Palm Desert Above/Below I5D ISD Median of Comparators ISD ISD City of Palm Desert Above/Below I5D ISD 70th Percentile of Comparators ISD ISD City of Palm Desert Above/Below I5D ISD Number of Matches 1 1 N/C-Non Comparator Page 10a of 37 Appendix II City of Palm Desert Benefit Detail May 2018 Agency City of Palm ity of Cathedral City o ity of Indio ity of La Quinta Desert City Coache Springs Benchmark/Comparator Deputy City N/C N/C N/C N/C N/C N/C Deputy City N/C N/C N/C N/C N/C Agency Match Treasurer Treasurer Top Monthly I $7,889 Salary _ Classic 2%@60 Enhanced Formula $118 Cost ER Paid Member Contrib Calc Classic EPMC d E as Spec Comp re Single Highest Year Social Security _ Deferred Compensation Other Ret. Cafeteria $2,011 Health Dental m Vision N Life $12 LTD $91 STD/SDI Other Ins. ' Vacation' $819 Holidays _ $394 Admin Leave Auto I .. 717.1 $3,446 N/C-Non Comparator 1-City of Palm Springs:City offers annual leave that includes vacation and sick leave combined. Page 10b of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Total Monthly Compensation May 2018 De.ut Cit Treasurer Total Salary Next Top Month! nefits Next Salary Rank Comparator Agency Classification Title Salary ckage Monthly Effective Increase Percentage Comp Date Increase 1 City of Palm Desert Deputy City Treasurer $10,210 $3,646 $13,856 unknown unknown unknown 2 City of Palm Springs Deputy City Treasurer $7,889 $3,446 $11,335 6/18/2017 unknown unknown 3 City of La Quinta N/C ------ 4 City of Poway N/C ------ 5 City of Indian Wells N/C ------ 6 City of Redlands N/C ------ 7 City of Rancho Mirage N/C ------ 8 City of Dana Point N/C ------ 9 City of Cathedral City N/C ------ 10 City of Temecula N/C ------ 11 City of Coachella N/C ------ 12 City of Indio N/C ------ 13 City of San Marcos N/C ------ Average of Comparators ISD ISD City of Palm Desert Above/Below ISD ISD Median of Comparators ISD ISD City of Palm Desert Above/Below ISD ISO 70th Percentile of Comparators ISD ISO City of Palm Desert Above/Below ISD ISO Number of Matches 1 1 N/C-Non Comparator Page 10c of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Top Monthly Salary May 2018 Director of Administrative Services .alall.111111111- Next lassification Title ifyji. ective Percentage Increase gate -ase 1 City of Redlands Human Resources-Risk Management Director $15,517 $5,217 $20,734 7/1/2017 unknown unknown 2 City of San Marcos Human Resources-Risk Division Director $14,052 $5,662 $19,715 7/1/2017 unknown unknown 3 City of Indio Director of Human Resources&Risk Management $13,791 $5,559 $19,350 4/13/2017 unknown unknown 4 City of Palm Desert $13,730 _,__ ... ._. .. ._. . ._. 5 City of Palm Springs Director of Human Resources $13,710 $4, $18,198 6/18/2017 unknown unknown 6 City of Poway' Director of Human Resources&Risk Management _ $12,734 _ $4,645 _ $17,379 7/1/2017 7/1/2018 2.00% 7 City of Cathedral City N/C _ 8 City of La Quinta N/C 9 City of Temecula N/C 10 City of Rancho Mirage N/C 11 City of Coachella N/C 12 City of Indian Wells N/C 13 City of Dana Point' N/C ummary Results Wop Month Total hly Average of Comparators $13,961 $19,075 %City of Palm Desert Above/Below -1.7% -4.9% Median of Comparators $13,791 $19,350 %City of Palm Desert Above/Below -0.4% -6.4% 70th Percentile of Comparators $14,000 $19,642 %City of Palm Desert Above/Below -2.0% -8.0% Number of Matches 5 5 N/C-Non Comparator 1-City of Dana Point:Director of Administrative Services also serves as Assistant City Manager. 2-City of Poway:"Temporary Employee" Page 11 a of 37 Appendix II City of Palm Desert Benefit Detail May 2018 Agency City of Palm ity of Cathedral City o ity of Indio ity of La Quints .• •• - Desert City Coache Springs Mirage Benchmark/Comparator Director of Director of Director of Director of Human Human Agency Match Administrative N/C N/C N/C N/C Human N/C Human Human N/C Resources-Risk Resources-Risk N/C Services Resources&Risk Resources Resources&Risk Management Division Director Top Monthly $13,730 I $13,791 $13,710 $12,734 $15,517 $14,052 Salary Classic o@5- 2.7%@55 2%@60 2%@60 2%@55 2%@55 Enhanced Formula $371 $883 $206 $191 $419 $379 Cost ER Paid Member Contrib Calc Classic EPMC d E as Spec Comp 2 re Single Highest Year $78 Social Security $663 $663 $663 Deferred Compensation $280 $404 Other Ret. Cafeteria $1,400 $2,011 $13 $108 Health $1,828 $1,949 u Dental $86 m Vision $12 m Life $9 $25 $23 $49 LTD $88 $138 $64 $39 STD/SDI _ $25 Other Ins. y Vacation''' $796 $1,424 $882 $2,924 $811 agar Holidays _ $690 $686 $588 $716 $703 Admin Leave $530 $392 $540 Auto $500 $300 $396 12=1. IL $4,488 $4,645 .217 $5,662 $0 N/C-Non Comparator 1-City of Palm Springs:City offers annual leave that includes vacation and sick leave combined. 2-City of Redlands:City offers annual leave that includes vacation,sick,executive leave and floating holidays combined. Page 11 b of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Total Monthly Compensation May 2018 Director of Administrative Services Top Monthly Benefits Total Salary Next Salary Next 'ossification Ti Salary Package Monthly Affective Increase Percentage Comp Date Increase 1 City of Redlands Human Resources-Risk Management Director $15,517 $5,217 $20,734 7/1/2017 unknown unknown 2 City of San Marcos Human Resources-Risk Division Director $14,052 $5,662 $19,715 7/1/2017 unknown unknown 3 City of Indio Director of Human Resources&Risk Management $13,791 $5,559 $19,350 4/13/2017 unknown unknown 4 City of Palm Desert Director of Administrative Services Q•' ' Q.o.on 1.__... _L _... _L _..._ S City of Palm Springs Director of Human Resources $13,710 $4,488 $18,198 6/18/2017 unknown unknown 6 City of Poway' Director of Human Resources&Risk Management $12,734 $4,645 $17,379 7/1/2017 7/1/2018 2.00% 7 City of Cathedral City N/C 8 City of La Quinta N/C 9 City of Temecula N/C 10 City of Rancho Mirage N/C 11 City of Coachella N/C 12 City of Indian Wells N/C 13 City of Dana Point' N/C Summary Results illop Monthly Total Monthly Average of Comparators $13,961 $19,075 %City of Palm Desert Above/Below -1.7% -4.9% Median of Comparators $13,791 $19,350 %City of Palm Desert Above/Below -0.4% -6.4% 70th Percentile of Comparators $14,000 $19,642 %City of Palm Desert Above/Below -2.0% -8.0% Number of Matches 5 5 N/C-Non Comparator 1-City of Dana Point:Director of Administrative Services also serves as Assistant City Manager. 2-City of Poway:"Temporary Employee" Page 11c of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Top Monthly Salary May 2018 Director of Build in. and Safet Total Salary ompara or gency Classification Title Package Monthly Effective Increase •ercen age Comp Date Increase 1 City of Palm Desert Director of Building and Safety ,509 $18,582 unknown unknown unknown 2 City of Dana Point' Building Official $13,406 $3,973 $17,379 10/1/2017 unknown unknown 3 City of Temecula' Building Official $13,107 $4,836 $17,943 7/1/2017 7/1/2019 unknown 4 City of Cathedral City' Chief Building Official $12,203 $4,031 $16,234 _ 1/14/2018 unknown unknown 5 City of Palm Springs Director of Building&Safety $10,978 $4,015 $14,993 6/18/2017 unknown unknown 6 City of Redlands' Chief Building Official $10,471 $3,504 $13,975 7/1/2016 unknown unknown 7 City of Rancho Mirage° Building Official $9,913 $3,553 $13,466 7/1/2017 7/1/2018 1.5% 8 City of La Quinta Manager(Building Official) $9,675 $2,986 $12,661 6/26/2017 unknown unknown 9 City of Poway N/C _ 10 City of Indio N/C _ 11 City of Indian Wells N/C 12 City of San Marcos N/C 13 City of Coachella N/C mmary Results 111111111WI Total Monthly Average of Comparators $11,393 $15,236 %City of Palm Desert Above/Below 19.0% 18.0% Median of Comparators $10,978 $14,993 %City of Palm Desert Above/Below 22.0% 19.3% 70th Percentile of Comparators $12,384 $16,463 %City of Palm Desert Above/Below 12.0% 11.4% Number of Matches 7 7 N/C-Non Comparator 1-City of Cathedral City:Chief Building Official reports to Community Development Director who oversees Building,Engineering,Planning,Public Works,and Code Compliance. 2-City of Dana Point:Building Official reports to Director of Community Development who oversees planning,code enforcement,economic development,and building plan check and inspection administration. 3-City of Temecula:Building Official reports to Director of Community Development who oversees planning,building,and code enforcement. 4-City of Redlands:Chief Building Official reporst to Development Services Director who oversees planning,building and safety,and economic development. 5-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013. Building Official reports to Director of Development Services who oversees planning,building and safety,and code compliance and animal control. Page 12a of 37 Appendix II City of Palm Desert Benefit Detail May 2018 City of Palm ity of Cathedral City o City of Rancho City of San City of Agency Desert City Coache Point ity of Indio ity of La Quinta Springs o 'oway Mirage City of Redlands Marcos Temecula Director of Benchmark/Comparator Chief Building Manager Director of Chief Building Agency Match Building and Official N/C Building Official N/C N/C (Building Official) Building&Safety N/C Building Official Official N/C Building Official Safety Top Monthly $14,073 $12,203 $13,406 $9,675 $10,978 $9,913 $10,471 $13,107 Salary Classic 2%@55 2%@60 2%@55 2%@60 2%@60 2%@60 2%@55 2%@60 Enhanced Formula ..380 $183 $362 $145 $165 $149 $283 $197 Cost ER Paid Member $854 $917 Contrib C. Calc Classic EPMC E as Spec Comp $60 $64 re Single Highest Year $67 $52 Social Security $649 Deferredel $208 $108 $72 Compensation Other Ret. $-1,098 $-393 Cafeteria $1,911 $1,275 $1,668 $2,011 $516 $1,200 Health $1,817 $397 u Dental $203 m Vision _ _ _ $40 m Life $53 $25 $16 LTD _ $29 $26 $126 $58 STD/SDI $31 $94 Other Ins. $400 y Vacation''''' $986 $1,547 $558 $1,140 $572 $403 $1,468 to Holidays _ $845 $722 $372 $549 $496 $529 $605 Admin Leave $186 $604 i $378 Auto I ,,. 1 11W. $0 $2,986 $4,015 $0 $3,553 N/C-Non Comparator 1-City of Dana Point:City offers comprehensive leave that includes vacation and sick leave combined. 2-City of Palm Springs:City offers annual leave that includes vacation and sick leave combined. 3-City of Redlands:City offers annual leave that includes vacation,sick,executive leave and floating holidays combined. Page 12b of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Total Monthly Compensation May 2018 Director of Buildin. and Safet F lop Monthly Benefits Total Salary Next Salary N Agency Classification Title Monthly Effective Percent.. Salary Package Increase - City of Palm Desert Director of Building and Safety 2 City of Temecula' Building Official $13,107 $4,836 $17,943 7/1/2017 7/1/2019 unknown 3 City of Dana Pointe Building Official $13,406 $3,973 $17,379 10/1/2017 unknown unknown 4 City of Cathedral City' Chief Building Official $12,203 $4,031 $16,234 1/14/2018 unknown unknown 5 City of Palm Springs Director of Building&Safety $10,978 $4,015 $14,993 6/18/2017 unknown unknown 6 City of Redlands' Chief Building Official $10,471 $3,504 $13,975 7/1/2016 unknown unknown 7 City of Rancho Mirage4 Building Official $9,913 $3,553 $13,466 7/1/2017 7/1/2018 1.5% 8 City of La Quinta Manager(Building Official) $9,675 $2,986 $12,661 6/26/2017 unknown unknown 9 City of Poway N/C 10 City of Indio N/C 11 City of Indian Wells N/C 12 City of San Marcos N/C 13 City of Coachella N/C Summary Results Top Monthly Total Monthly Average of Comparators $11,393 $15,236 City of Palm Desert Above/Below 19.0% 18.0% Median of Comparators $10,978 $14,993 City of Palm Desert Above/Below 22.0% 19.3% 70th Percentile of Comparators $12,384 $16,463 City of Palm Desert Above/Below 12.0% 11.4% Number of Matches 7 7 N/C-Non Comparator 1-City of Cathedral City:Chief Building Official reports to Community Development Director who oversees Building,Engineering,Planning,Public Works,and Code Compliance. 2-City of Dana Point:Building Official reports to Director of Community Development who oversees planning,code enforcement,economic development,and building plan check and inspection administration. 3-City of Temecula:Building Official reports to Director of Community Development who oversees planning,building,and code enforcement. 4-City of Redlands:Chief Building Official reporst to Development Services Director who oversees planning,building and safety,and economic development. 5-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013. Building Official reports to Director of Development Services who oversees planning,building and safety,and code compliance and animal control. Page 12c of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Top Monthly Salary May 2018 Director of Community Develo.ment Sa mpara • gency Classification Title 'ont y Effective Increase ercen age Corn• Date Increase City of Palm Desert Director of Community $14,780 $4,631 $19,411 unknown unknown unknown 2 Ci$y_gf Palm Springs Director of Planning Services S 14,266 S 4.582 S 18.848 6/18/2017 unknown unknown 3 City of Cathedral City N/C 4 City of Coachella N/C 5 City of Dana Point N/C 6 City of Indian Wells N/C _ 7 City of Indio N/C 8 City of La Quinta N/C 9 City of Poway N/C 10 City of Rancho Mirage N/C 11 City of Redlands N/C 12 City of San Marcos N/C 13 City of Temecula N/C Average of Comparators ISD ISD City of Palm Desert Above/Below ISD ISD Median of Comparators ISD ISD City of Palm Desert Above/Below ISD ISD 70th Percentile of Comparators ISD ISD City of Palm Desert Above/Below ISD ISD Number of Matches 1 1 N/C-Non Comparator Page 13a of 37 Appendix II City of Palm Desert Benefit Detail May 2018 • Agency City of Palm ity of Cathedral City o ity of Indio ity of La Quints • Desert City Coache Springs Mir- dal Benchmark/Comparator Director of Director of Agency Match Community N/C N/C N/C N/C N/C N/C Planning Services N/C N/C N/C N/C N/C Development Top Monthly $14,780 I $14,266 Salary Classic 2%@55 2%@60 Enhanced Formula • 399 $214 Cost ER Paid Member Contrib Calc Classic EPMC d E as Spec Comp re Single Highest Year Social Security _ Deferred Compensation Other Ret. Cafeteria $2,011 Health u Dental m Vision In Life $25 LTD $138 STD/SDI Other Ins. Vacation''''' $1,481 to Holidays _ $713 Admin Leave Auto N/C-Non Comparator 1-City of Dana Point:City offers comprehensive leave that includes vacation and sick leave combined. 2-City of Palm Springs:City offers annual leave that includes vacation and sick leave combined. 3-City of Redlands:City offers annual leave that includes vacation,sick,executive leave and floating holidays combined. Page 13b of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Total Monthly Compensation May 2018 Director of Communit Develo•ment Total Salary Next Top Monthly Benefits Next Salary Classification Title Salary Package Month! ffective Increase Percentage Comp Date Increase City of Palm Desert Director of Community Development $14,780 $4,631 $19,411 unknown unknown unknown 2 City of Palm Sorines Director of Planning Services S 14.266 S 4.582 S 18.848 6/18/2017 unknown unknown 3 City of Cathedral City N/C 4 City of Coachella N/C _ 5 City of Dana Point N/C 6 City of Indian Wells N/C 7 City of Indio N/C _ 8 City of La Quinta N/C 9 City of Poway N/C 10 City of Rancho Mirage N/C 11 City of Redlands N/C 12 City of San Marcos N/C 13 City of Temecula N/C Summary Results Top Monthly To Mon, Average of Comparators ISD ISD City of Palm Desert Above/Below ISD ISD Median of Comparators ISD ISD City of Palm Desert Above/Below ISD ISD 70th Percentile of Comparators ISD ISD City of Palm Desert Above/Below ISD ISD Number of Matches 1 1 N/C-Non Comparator Page 13c of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Top Monthly Salary May 2018 Director of Economic Development laiiiiiiiiilli Classification Title110911 "ec nre •ercen age Date Increase crease 1 City of Cathedral City _ Director of Economic Development $16,354 $5,051 $21,405 1/14/2018 unknown unknown 2 City of Indio Director of Economic Development $13,791 $5,559 $19,350 4/13/2017 unknown unknown 3 City of Dana Point Economic Development Manager $13,406 $3,973 $17,379 10/1/2017 unknown unknown 4 City of Palm Desert Director of Economic Development $13,067 $4,336 $17,403 unknown unknown unknown 5 City of San Marcos Economic Development Manager $11,637 $5,229 $16,866 7/1/2017 unknown unknown 6 City of Redlands Economic Development Manager $10,216 $3,664 $13,880 7/1/2016 unknown unknown 7 City of Palm Springs Economic Development/Downtown Administrator $9,850 $3,800 _ $13,650 6/18/2017 unknown unknown 8 City of Coachella Economic Development Manager $9,568 $3,711 $13,279 7/1/2017 unknown unknown 9 City of Temecula N/C 10 City of La Quinta N/C 11 City of Rancho Mirage N/C 12 City of Indian Wells N/C _ 13 City of Poway N/C mmary Results W op Monthly Total lir Monthly Average of Comparators $12,117 $16,544 City of Palm Desert Above/Below 7.3% 4.9% Median of Comparators $11,637 $16,866 City of Palm Desert Above/Below 10.9% 3.1% 70th Percentile of Comparators $13,483 $17,773 City of Palm Desert Above/Below -3.2% -2.1% Number of Matches 7 7 N/C-Non Comparator Page 14a of 37 Appendix II City of Palm Desert Benefit Detail May 2018 City of Palm ity of Cathedral City o City of Rancho City of San City of Agency Desert City Coache Point ity of Indio ity of La Quinta Springs Mirage City of Redlands Marcos Temecula Economic Director of Director of Economic Economic Director of Economic Economic Benchmark/Comparator Development/Do Agency Match Economic Economic Development Development N/C Economic N/C wntown N/C N/C Development Development N/C Development Manager Manager Development Administrator Manager Manager Top Monthly ,067 $16,354 $9,568 $13,406 $13,791 $9,850 $10,216 $11,637 Salary Classic 2%@55 2%@60 2%@60 2%@55 2.7%@55 2%@60 2%@55 2%@55 Enhanced Formula $353 $245 $144 $362 $883 $148 $276 $314 Cost ER Paid Member Contrib $1,145 Calc Classic EPMC m E as Spec Comp $80 m re Single Highest Year $67 $51 Social Security $663 $633 $663 Deferred $208 $298 Compensation Other Ret. $-1,472 Cafeteria $1,911 $1,275 $1,400 $2,011 $516 $108 Health $1,817 $397 $1,949 u Dental $169 m Vision $21 m Life $71 $17 $9 $12 $40 • LTD $32 $21 $88 $113 $32 STD/SDI $13 $25 Other Ins. m Vacation''''' _ $1,698 $589 $1,547 $796 $1,023 $393 $671 to Holidays _ $1,132 $552 $722 $690 $493 $472 $582 ▪ Admin Leave $368 $530 $629 $448 Auto $500 $396 51 $3,711 $3,973 $0 $5,559 $0 $3.800 $0 $3.664 $5.229 $0 N/C-Non Comparator 1-City of Dana Point City offers comprehensive leave that includes vacation and sick leave combined. 2-City of Palm Springs:City offers annual leave that includes vacation and sick leave combined. 3-City of Redlands:City offers annual leave that includes vacation,sick,executive leave and Floating holidays combined. Page 14b of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Total Monthly Compensation May 2018 Director of Economic Develo.ment Top Month! Benefits Total Salary Next Salary Next Classification Title Salary Package Monthly Effective Increase Percentage Comp Date Increase 1 City of Cathedral City Director of Economic Development $16,354 $5,051 $21,405 1/14/2018 unknown unknown 2 City of Indio Director of Economic Development $13,791 $5,559 $19,350 4/13/2017 unknown unknown City of Palm Desert Director of Economic Development Mk. $13,067 $4,336 A $17,403 unknown unknown unknown 4 City of Dana Point Economic Development Manager S 13.406 $3.973 $17.379 10/1/2017 unknown unknown_ 5 City of San Marcos Economic Development Manager $11,637 $5,229 $16,866 7/1/2017 unknown unknown 6 City of Redlands Economic Development Manager $10,216 $3,664 $13,880 7/1/2016 unknown unknown 7 City of Palm Springs Economic Development/Downtown Administrator $9,850 $3,800 $13,650 6/18/2017 unknown unknown 8 City of Coachella Economic Development Manager $9,568 $3,711 $13,279 7/1/2017 unknown unknown 9 City of Temecula N/C 10 City of La Quinta N/C _ 11 City of Rancho Mirage N/C 12 City of Indian Wells N/C 13 City of Poway N/C Summary Results Top Monthly Vital ly Average of Comparators $12,117 $16,544 City of Palm Desert Above/Below 7.3% 4.9% Median of Comparators $11,637 $16,866 City of Palm Desert Above/Below 10.9% 3.1% 70th Percentile of Comparators $13,483 $17,773 City of Palm Desert Above/Below -3.2% -2.1% Number of Matches 7 7 N/C-Non Comparator Page 14c of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Top Monthly Salary May 2018 Director of Finance Total Sala ' omparator Agency Classification Title c Monthly Effective Increase ercentage Comp Date Increase City of Palm Desert Director of Finance 15,923 $4,827 $20,750 unknown unknown unknown 2 City of Temecula Director of Finance $15,580 S 5.997 S 21.577 7/1/2017 7/1/2019 unknown 3 City of Palm Springs Director of Finance&Treasurer $14,622 $4,642 $19,264 6/18/2017 unknown unknown 4 City of La Quinta Director(Finance) $12,965 $3,166 $16,131 6/26/2017 unknown unknown 5 City of Cathedral City N/C 6 City of Coachella N/C 7 City of Dana Point N/C 8 City of Indian Wells N/C 9 City of Indio N/C 10 City of Poway N/C 11 City of Rancho Mirage N/C 12 City of Redlands N/C 13 City of San Marcos N/C Average of Comparators ISD ISD City of Palm Desert Above/Below ISD ISD Median of Comparators ISD ISD City of Palm Desert Above/Below ISD ISD 70th Percentile of Comparators ISD ISD City of Palm Desert Above/Below ISD ISD Number of Matches 3 3 N/C-Non Comparator Page 15a of 37 Appendix II City of Palm Desert Benefit Detail May 2018 • Agency City of Palm ity of Cathedral City o ity of Indio ity of La Quints o •oway I y o Redlands City of San City of Desert City Coache Springs Mirage Marcos Temecula Director of Benchmark/Comparator Director of Director Director of Agency Match Finance N/C N/C N/C N/C N/C Finance& N/C N/C N/C N/C 9 Y (Finance) Finance Treasurer Top MonthlyI Salary $12,965 $14,622 $15,580 Classic 2%@60 2%@60 2%@60 Enhanced Formula $194 $219 $234 Cost ER Paid Member Contrib $1,091 c Calc Classic EPMC E as Spec Comp $76 re Single Highest Year Social Security Deferred Compensation Other Ret. $-467 Cafeteria $1,668 $2,011 $1,200 Health u Dental m Vision N Life $25 LTD $26 $138 STD/SDI _ $31 Other Ins. $400 It Vacation''' $748 $1,518 $1,745 agar Holidays _ $499 $731 $719 Admin Leave $599 Auto $400 =1. IL JW2.1 $0 $0 $3.166 $4.642 $0 $5.997 N/C-Non Comparator 1-City of Palm Springs:City offers annual leave that includes vacation and sick leave combined. 2-City of Redlands:City offers annual leave that includes vacation,sick,executive leave and Floating holidays combined. Page 15b of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Total Monthly Compensation May 2018 Director of Finance Top Monthly Benefits Total Salary Next Sala Next omparator Agency Classification Title Monthly Effective 'ercentage Salary Package Increa- Com. Date ncrease 1 City of Temecula Director of Finance $15,580 $5,997 $21,577 7/1/2017 7/1/2019 unknown City of Part Director of Finance 3 City of Palm Springs Director of Finance&Treasurer $14,622 $4,642 $19,264 6/18/2017 unknown unknown 4 City of La Quinta Director(Finance) $12,965 $3,166 $16,131 6/26/2017 unknown unknown 5 City of Cathedral City N/C 6 City of Coachella N/C 7 City of Dana Point N/C 8 City of Indian Wells N/C 9 City of Indio N/C 10 City of Poway N/C 11 City of Rancho Mirage N/C 12 City of Redlands N/C 13 City of San Marcos N/C Summary Results I o hly Average of Comparators ISD ISD City of Palm Desert Above/Below ISD ISD Median of Comparators ISD ISD City of Palm Desert Above/Below ISD ISD 70th Percentile of Comparators ISD ISD City of Palm Desert Above/Below ISD ISD Number of Matches 3 3 N/C-Non Comparator Page 15c of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Top Monthly Salary May 2018 Director of Public Works its Mon' • Package Co 1 City of Temecula Public Works Director $16,778 $6,304 $23,082 7/1/2017 7/1/2019 unknown 2 City of Indian Wells Public Works Director $16,606 $7,700 $24,305 unknown unknown unknown 3 City of Dana Point Director of Public Works-City Engineer $16,061 $6,257 $22,318 10/1/2017 unknown unknown 4 City of Palm Desert $15,923 $4,827 $20,750 unknown unknown unknown 5 City of San Marcos Director of Public Works $15,456 $5,914 $21,370 7/1/2017 unknown unknown 6 City of Palm Springs' [Director of Engineering Services-City Engineer/Director of $15,133 $4,729 $19,862 6/18/2017 unknown unknown Maintenance&Facilities] 7 City of Rancho Mirage' Director of Public Works $14,742 $4,929 $19,670 7/1/2017 7/1/2018 1.5% 8 City of Indio Director of Public Works $13,791 $5,559 $19,350 4/13/2017 unknown unknown 9 City of Coachella Public Works Director $13,776 $5,278 $19,054 1/25/2017 unknown unknown 10 City of La Quinta Director $12,965 $3,664 $16,629 6/26/2017 unknown unknown 11 City of Cathedral City' N/C 12 City of Redlands4 N/C 13 City of Poway N/C Summary esi ff Top Monthly Total Monthly Average of Comparators $15,034 $20,627 %City of Palm Desert Above/Below 5.6% 0.6% Median of Comparators $15,133 $19,862 %City of Palm Desert Above/Below 5.0% 4.3% 70th Percentile of Comparators $15,819 $21,939 %City of Palm Desert Above/Below 0.7% -5.7% Number of Matches 9 9 N/C-Non Comparator 1-City of Cathedral City:Community Development Director oversees Building,Engineering,Planning,Public Works,and Code Compliance. 2-City of Palm Springs:Functional Match:This hybrid match represents that the duties of the class are performed by more than one class at the comparator agency. The salary displayed is the higher of the matches. 3-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 4-City of Redlands:Functional Match:This hybrid match represents that the duties of the class are performed by more than one class at the comparator agency. The salary displayed is the higher of the matches. Page 16a of 37 Appendix II City of Palm Desert Benefit Detail May 2018 City of Palm ity of Cathedral City o ity of Rancho City of San City of Agency Desert City Coache. Wells ity of Indio ity of La Quinta Springs Mirage City of Redlands Marcos Temecula Director of Public [Director of Benchmark/Comparator Director of Public Works Public Works Director of Public Director of Public Director of Public Public Works N/C Works-City Director Engineering N/C N/C Agency Match Public Works Director Director Works Works Works Director Engineer Services-City Top Monthly Salary 1 $15,923 $13,776 $16,061 $16,606 $13,791 $12,965 $15,133 $14,742 $15,456 $16,778 Classic 2%@55 2%@60 2%@55 2.75%@55 2.7%@55 2%@60 2%@60 2%@60 2%@55 2%@60 Enhanced Formula ..430 $207 $434 $1,063 $883 $194 $227 $221 $417 $252 Cost ER Paid Member Contrib $1,174 C. Calc Classic EPMC E as Spec Comp $82 re Single Highest Year $80 $100 Social Security' $1,327 $663 $663 Deferred $482 $415 $108 Compensation Other Ret. $-503 Cafeteria $1,475 $83 $1,400 $1,668 $2,011 $108 $1,200 Health $1,817 $1,734 $1,817 $1,949 u Dental $169 $141 $203 m Vision $21 $36 $40 m Life $43 $13 $9 $25 $16 $54 LTD $31 $66 $88 $26 $138 $58 $43 STD/SDI $15 $32 $31 $94 $25 Other Ins. $400 y Vacation'.a'4 $1,113 $1,853 $1,022 $796 $748 $1,572 $1,134 $892 $1,879 agar Holidays _ $795 $865 $830 $690 $499 $757 $737 $773 $774 Admin Leave $636 $618 $639 $530 $499 $594 1 $645 Auto $433 $450 $200 $500 $500 $396 $400 .. SiTEE $5.278 $6.257 $7,700 $5,559 $3,664 $4,729 $0 $4,929 $0 N/C-Non Comparator 1-City of Indian Wells:City pays employer portion of Social Security.City reimburses employees for employee portion of Social Security benefits. 2-City of Dana Point City offers comprehensive leave that includes vacation and sick leave combined. 3-City of Palm Springs:City offers annual leave that includes vacation and sick leave combined. 4-City of Redlands:City offers annual leave that includes vacation,sick,executive leave and floating holidays combined. Page 16b of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Total Monthly Compensation May 2018 'Director of Public Works S : ator Agency Classification Title Top Monthly Benefits Monthlly Effective Next Sala Salary Package Comp Date Increas: — 1 City of Indian Wells Public Works Director $16,606 $7,700 $24,305 unknown unknown unknown 2 City of Temecula Public Works Director $16,778 $6,304 $23,082 7/1/2017 7/1/2019 unknown 3 City of Dana Point Director of Public Works-City Engineer $16,061 $6,257 $22,318 10/1/2017 unknown unknown 4 Cit of San Marcos Director of Public Works S 15 456 S 5.914 5 21.370 7/1/2017 unknown unknown City of Palm Desert Director of Public Works 6 City of Palm Springs2 [Director of Engineering Services-City Engineer/Director of $15,133 $4,729 $19,862 6/18/2017 unknown unknown Maintenance&Facilities] 7 City of Rancho Mirage' Director of Public Works $14,742 $4,929 $19,670 7/1/2017 7/1/2018 1.5% 8 City of Indio Director of Public Works $13,791 $5,559 $19,350 4/13/2017 unknown unknown 9 City of Coachella Public Works Director $13,776 $5,278 $19,054 1/25/2017 unknown unknown 10 City of La Quinta Director $12,965 $3,664 $16,629 6/26/2017 unknown unknown 11 City of Cathedral City' N/C 12 City of Redlands4 N/C 13 City of Poway N/C Summary Results Top Monthly Total Monthly Average of Comparators $15,034 $20,627 City of Palm Desert Above/Below 5.6% 0.6% Median of Comparators $15,133 $19,862 City of Palm Desert Above/Below 5.0% 4.3% 70th Percentile of Comparators $15,819 $21,939 City of Palm Desert Above/Below 0.7% -5.7% Number of Matches 9 9 N/C-Non Comparator 1-City of Cathedral City:Community Development Director oversees Building,Engineering,Planning,Public Works,and Code Compliance. 2-City of Palm Springs:Functional Match:This hybrid match represents that the duties of the class are performed by more than one class at the comparator agency. The salary displayed is the higher of the matches. 3-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 4-City of Redlands:Functional Match:This hybrid match represents that the duties of the class are performed by more than one class at the comparator agency. The salary displayed is the higher of the matches. Page 16c of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Top Monthly Salary May 2018 En•ineerin•Assistant Sala ' omparator Agency Classification Title al. ckage r ont ly Effective Increase 'ercen age • Comp Date Increase 1 City of Palm Desert Engineering Assistant $9,722 $3,380 $13,102 unknown unknown unknown 2 City of Indio3 Assistant Engineer $7,889 $3,303 $11,192 4/13/2017 unknown unknown 3 City of Palm Springs Engineering Assistant $7,692 $3,410 $11,102 6/18/2017 unknown unknown 4 City of Dana Point Engineering Technician Ill $7,348 $2,346 $9,694 10/1/2017 unknown unknown 5 City of Temecula' Assistant Engineer I $7,070 $2,852 $9,922 7/1/2017 7/1/2019 unknown 6 City of Rancho Mirage' Engineering Technician II $6,390 $3,120 $9,510 7/1/2017 7/1/2018 1.5% 7 City of Redlands4 Assistant Engineer $6,246 $2,088 $8,334 7/1/2016 unknown unknown 8 City of Poway Engineering Technician II $6,174 $2,702 $8,876 7/1/2017 7/1/2018 2.00% 9 City of Coachella N/C 10 City of Cathedral City N/C 11 City of La Quinta N/C 12 City of San Marcos N/C 13 City of Indian Wells N/C mmary Results IIW-Mo Total Monthly Average of Comparators $6,973 $9,804 %City of Palm Desert Above/Below 28.3% 25.2% Median of Comparators $7,070 $9,694 %City of Palm Desert Above/Below 27.3% 26.0% 70th Percentile of Comparators $7,417 $10,158 %City of Palm Desert Above/Below 23.7% 22.5% Number of Matches 7 7 N/C-Non Comparator 1-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 2-City of Temecula:Assistant Engineer I requires any combination of education,experience,and training to a Bachelor's degree and 1 year of experience. 3-City of Indio:Assistant Engineer requires an AA degree and 1 year of experience;EIT required within 18 months of appointment. 4-City of Redlands:Assistant Engineer requires a Bachelor's degreee and 1 year of experience. Page 17a of 37 Appendix II City of Palm Desert Benefit Detail May 2018 MI Agency City of Palm ity of Cathedral City o ity of Indio ity of La Quints o •oway ity of Rancho City of Redlands City of San City of Desert City Coache Point Springs Mirage Marcos Temecula Benchmark/Comparator Engineering Engineering Assistant Engineering Engineering Engineering Assistant Assistant Agency Match Assistant N/C N/C Technician III N/C Engineer N/C Assistant Technician II Technician II Engineer N/C Engineer I Top Monthly $7,348 $7,889 $7,692 $6,174 $6,390 $6,246 $7,070 Salary - Classic 2%@55 2.7%@55 2%@60 2%@60 2%@60 2%@55 2%@60 Enhanced Formula $198 $505 $115 $93 $96 $169 $106 Cost ER Paid Member $283 Contrib C. Calc Classic EPMC E as Spec Comp $11 re Single Highest Year $37 $31 Social Security $489 $387 Deferred $108 Compensation Other Ret. $-212 Cafeteria $1,150 $1,400 $2,011 $503 $1,200 Health $1,828 $1,817 $397 u Dental $86 $203 m Vision $12 $40 m Life $9 $12 $11 $16 LTD $50 $88 $31 $58 STD/SDI $94 Other Ins. $400 y Vacation' $565 $455 $799 $356 $369 $240 $738 agar Holidays _ $396 $394 $385 $285 $320 $360 $326 Admin Leave Auto .. gEME $0 $2,346 $0 $3,303 $0 $3,410 $2,702 $3,120 $2,088 $0 $2,852 N/C-Non Comparator 1-City of Palm Springs:City offers general leave that includes vacation and sick leave combined. Page 17b of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Total Monthly Compensation May 2018 En•ineerin•Assistant Total Salary Next Top Month! nefits Next Salary omparator Agency Classification Title Salary ckage Monthly Effective Increase Percentage Comp Date Increase City of Palm Desert Engineering Assistant $9,722 $3,380 $13,102 unknown unknown unknown 2 City of Indio' Assistant Engineer $7,889 $3,303 $11,192 4/13/2017 unknown unknown 3 City of Palm Springs Engineering Assistant $7,692 $3,410 $11,102 6/18/2017 unknown unknown 4 City of Temecula' Assistant Engineer I $7,070 $2,852 $9,922 7/1/2017 7/1/2019 unknown 5 City of Dana Point Engineering Technician III $7,348 $2,346 $9,694 10/1/2017 unknown unknown 6 City of Rancho Mirage' Engineering Technician II $6,390 $3,120 $9,510 7/1/2017 7/1/2018 1.5% 7 City of Poway Engineering Technician II $6,174 $2,702 $8,876 7/1/2017 7/1/2018 2.00% 8 City of Redlands4 Assistant Engineer $6,246 $2,088 $8,334 7/1/2016 unknown unknown 9 City of Coachella N/C 10 City of Cathedral City N/C 11 City of La Quinta N/C 12 City of San Marcos N/C 13 City of Indian Wells N/C Summary Results Top WIWI Total Monthly Average of Comparators $6,973 $9,804 City of Palm Desert Above/Below 28.3% 25.2% Median of Comparators $7,070 $9,694 City of Palm Desert Above/Below 27.3% 26.0% 70th Percentile of Comparators $7,417 $10,158 City of Palm Desert Above/Below 23.7% 22.5% Number of Matches 7 7 N/C-Non Comparator 1-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 2-City of Temecula:Assistant Engineer I requires any combination of education,experience,and training to a Bachelor's degree and 1 year of experience. 3-City of Indio:Assistant Engineer requires an AA degree and 1 year of experience;EIT required within 18 months of appointment. 4-City of Redlands:Assistant Engineer requires a Bachelor's degrees and 1 year of experience. Page 17c of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Top Monthly Salary May 2018 Executive Assistant .41/1=111.P Classification Title ont jar 1 City of Indio Executive Assistant to the City Manager $7,468 $3,202 $10,669 4/13/2017 unknown unknown City of Palm Desert Executive Assistant 1.1 $7,224 $3,024W 10,241111Unknowrillvn unknown 3 City of Dana Point Executive Assistant $6,914 $2,666 $9,580 10/1/2017 unknown unknown 4 City of Cathedral City Administrative Assistant to the City Manager&Council S 6.472 S 3.133 S 9.605 1/14/2018 unknown unknown 5 City of Poway Executive Assistant to the City Manager $5,917 $2,887 $8,804 7/1/2017 7/1/2018 0.02 6 City of Redlands Senior Administrative Assistant $4,409 $1,764 $6,173 7/1/2016 unknown unknown 7 City of Coachella N/C 8 City of Indian Wells N/C 9 City of Temecula N/C 10 City of Rancho Mirage' N/C 11 City of Palm Springs N/C 12 City of San Marcos N/C 13 City of La Quinta N/C Average of Comparators $6,236 $8,966 %City of Palm Desert Above/Below 13.7% 12.5% Median of Comparators $6,472 $9,580 %City of Palm Desert Above/Below 10.4% 6.5% 70th Percentile of Comparators $6,826 $9,600 %City of Palm Desert Above/Below 5.5% 6.3% Number of Matches 5 5 N/C-Non Comparator 1-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 Page 18a of 37 Appendix II City of Palm Desert Benefit Detail May 2018 Agency City of Palm ity of Cathedral City o ity of Indio ity of La Quints o •oway ity of Rancho City of Redlands City of San City of Desert City Coache Point Spring Mirage Marcos Temecula IIII Administrative Benchmark/Comparator Executi Assistant to the Executive Executive Executive Senior Agency Match Assists City Manager& N/C Assistant N/C Assistant to the N/C N/C Assistant to the N/C Administrative N/C N/C Council City Manager City Manager Assistant Top Monthly $7,224 $6,472 $6,914 $7,468 $5,917 $4,409 Salary Classic Is@55 2%@60 2%@55 2.7%@55 2%@60 2%@55 Enhanced Formula ..195 $97 $187 $478 $89 $119 Cost ER Paid Member $453 Contrib _ - c Calc Classic EPMC Cr Eas Spec Comp $32 re Single Highest Year $35 $22 Social Security $463 $273 Deferred $208 $149 Compensation Other Ret. $-582 Cafeteria $1,911 $1,275 $1,400 $503 Health $1,828 $397 u Dental _ $86 Vision $32� $12 H Life $20 $28 $9 $11 • LTD $64 $16 $48 $30 STD/SDI _ _ Other Ins. _ d Vacation' $417 $523 $798 $431 $410 $170 m Holidays $333 $448 $372 $373 $273 $280 3 Admin Leave Auto $0 $2.666 r r N/C-Non Comparator 1-City of Dana Point City offers comprehensive leave that includes vacation and sick leave combined. Page 18b of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Total Monthly Compensation May 2018 Executive Assistant op Monthly Benefits Total Salary Next Salary Next omparator Agency Classification Title Salary Package Monthly ffective Increase Percentage Comp Date Increase 1 City of Indio Executive Assistant to the City Manager $7,468 $3,202 $10,669 4/13/2017 unknown unknown City of Palm Desert Executive Assistant 7,224 $3,024 $10,2481111UnknowriWknowr7INEknown 3 City of Cathedral City Administrative Assistant to the City Manager&Council $6,472 $3,133 $9,605 1/14/2018 unknown unknown 4 City of Dana Point Executive Assistant S 6.914 S 2.666 S 9.580 10/1/2017 unknown unknown S City of Poway Executive Assistant to the City Manager $5,917 $2,887 $8,804 7/1/2017 7/1/2018 0.02 6 City of Redlands Senior Administrative Assistant $4,409 $1,764 $6,173 7/1/2016 unknown unknown 7 City of Coachella N/C 8 City of Indian Wells N/C 9 City of Temecula N/C 10 City of Rancho Mirage' N/C 11 City of Palm Springs N/C 12 City of San Marcos N/C 13 City of La Quinta N/C Summary Results Monthly Average of Comparators $6,236 $8,966 %City of Palm Desert Above/Below 13.7% 12.5% Median of Comparators $6,472 $9,580 %City of Palm Desert Above/Below 10.4% 6.5% 70th Percentile of Comparators $6,826 $9,600 %City of Palm Desert Above/Below 5.5% 6.3% Number of Matches 5 5 N/C-Non Comparator 1-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 Page 18c of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Top Monthly Salary May 2018 Facilities Manager or Total Salary ' omparator Agency Classification Title Sala kage Monthly Effectiv Increase -ercen age Comp Date Increase 1 City of Palm Desert Facilities Manager $10,993 $3,768 $14,761 unknown unknown unknown 2 City of Temecula Maintenance Supervisor $8,829 $3,780 $12,609 7/1/2017 7/1/2019 unknown 3 City of Coachella Parks,Recreation,and Facilities Superintendent $8,291 $3,485 $11,776 7/1/2017 unknown unknown 4 City of Palm Springs Maintenance Supervisor $7,692 $3,410 $11,102 6/18/2017 unknown unknown 5 City of San Marcos Facilities Maintenance Supervisor $7,635 $3,623 $11,258 7/1/2017 7/1/2018 unknown 6 City of Cathedral City Assistant Facilities Maintenance Supervisor $7,492 $3,293 $10,785 1/14/2018 unknown unknown 7 City of La Quinta Maintenance and Operations Superintendent(Buildings Superintendent) $6,865 $2,487 $9,353 6/26/2017 unknown unknown 8 City of Poway Facilities Maintenance and Special Districts Supervisor $6,695 $2,994 $9,688 7/1/2017 7/1/2018 2.00% 9 City of Rancho Mirage' Building-Landscape Maintenance Supervisor $6,390 $3,120 $9,510 7/1/2017 7/1/2018 1.5% 10 City of Redlands Field Services Supervisor $6,201 $2,477 $8,678 7/1/2016 unknown _ unknown 11 City of Indio N/C 12 City of Indian Wells N/C _ 13 City of Dana Point N/C ummary Results Top Monthly Total Monthly Average of Comparators $7,343 $10,529 %City of Palm Desert Above/Below 33.2% 28.7% Median of Comparators $7,492 $10,785 %City of Palm Desert Above/Below 31.9% 26.9% 70th Percentile of Comparators $7,669 $11,196 %City of Palm Desert Above/Below 30.2% 24.2% Number of Matches 9 9 N/C-Non Comparator 1-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 Page 19a of 37 Appendix II City of Palm Desert Benefit Detail May 2018 City of Palm ity of Cathedral City o y of Redlan City of San City of Agency ity of Indio ity of La Quinta Desert City Coache. Springs Marcos Temecula Assistant Parks, Maintenance Facilities Building- Facilities Benchmark/Comparator Facilities Maintenance Field Services Maintenance Facilities Recreation,and N/C N/C N/C and Operations Maintenance Landscape Maintenance Agency Match Manager Supervisor Supervisor Supervisor Maintenance Facilities Superintendent and Special Maintenance Supervisor Top Monthly $10,993 $7,492 $8,291 $6,865 $7,692 $6,695 $6,390 $6,201 $7,635 $8,829 Salary Classic 2%@55 2%@60 2%@60 2%@60 2%@60 2%@60 2%@60 2%@55 2&@%5 2%@60 Enhanced Formula , 297 $112 $124 $103 $115 $100 $96 $167 $206 $132 Cost ER Paid Member $524 $618 Contrib _ C. Calc Classic EPMC E as Spec Comp $37 $43 re Single Highest Year $31 Social Security $384 $473 Deferredel $208 $149 $108 $72 Compensation Other Ret. _ _ $-674 — — — — $-265 Cafeteria $1,911 $1,668 $2,011 $516 $108 $1,200 Health $1,817 $1,828 $1,817 $397 $1,949 u Dental $169 $86 $203 m Vision $21 _ _ $12 _ $40 m Life $32 $17 $12 $12 $16 $27 LTD _ $18 $19 $26 $88 $33 $58 $21 STD/SDI $11 $31 $94 $16 Other Ins. $400 y Vacation' $605 $510 $396 $799 _ $463 $369 $238 $440 $989 agar Holidays — $519 $478 $264 $385 $309 $320 $313 $382 $407 Admin Leave — $319 — $358 1 $255 Auto 12=1. I gl $3.485 $0 $0 $0 $2.487 . . ' .994 $3.120 $2,477 MEM N/C-Non Comparator 1-City of Palm Springs:City offers annual leave that includes vacation and sick leave combined. Page 19b of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Total Monthly Compensation May 2018 Facilities Mana•er T Total Salary Next Top Monthly Benefits xt Salary omparator Agency Classification Title Salary Package Monthly Effectiv Increase Percentage Comp Date Increase City of Palm Desert Facilities Manager $10,993 $3,768 $14,761 unknown unknown unknown 2 City of Temecula Maintenance Supervisor $8,829 $3,780 $12,609 7/1/2017 7/1/2019 unknown 3 City of Coachella Parks,Recreation,and Facilities Superintendent $8,291 $3,485 $11,776 7/1/2017 unknown unknown 4 City of San Marcos Facilities Maintenance Supervisor $7,635 $3,623 $11,258 7/1/2017 7/1/2018 unknown 5 City of Palm Springs Maintenance Supervisor $7,692 $3,410 $11,102 6/18/2017 unknown unknown 6 City of Cathedral City Assistant Facilities Maintenance Supervisor $7,492_ $3,293 $10,785 1/14/2018 unknown unknown 7 City of Poway Facilities Maintenance and Special Districts Supervisor $6,695 $2,994 $9,688 7/1/2017 7/1/2018 2.00% 8 City of Rancho Mirage' Building-Landscape Maintenance Supervisor $6,390 $3,120 $9,510 7/1/2017 7/1/2018 1.5% 9 City of La Quinta Maintenance and Operations Superintendent(Buildings Superintendent) $6,865 $2,487 $9,353 _ 6/26/2017 unknown unknown 10 City of Redlands Field Services Supervisor $6,201 $2,477 $8,678 7/1/2016 unknown unknown 11 City of Indio N/C 12 City of Indian Wells N/C 13 City of Dana Point N/C Summary Results Top Monthly Total Monthly Average of Comparators $7,343 $10,529 %City of Palm Desert Above/Below 33.2% 28.7% Median of Comparators $7,492 $10,785 %City of Palm Desert Above/Below 31.9% 26.9% 70th Percentile of Comparators $7,669 $11,196 %City of Palm Desert Above/Below 30.2% 24.2% Number of Matches 9 9 N/C-Non Comparator 1-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 Page 19c of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Top Monthly Salary May 2018 Information S stems Administrator 1 City of Indio Network Administrator S 8.088 S 3.351 S 11.439 4/13/2017 unknown unknown 2 City of San Marcos Network Analyst $7,635 $3,623 $11,258 7/1/2017 unknown unknown 3 City of Temecula Senior Information Technology Specialist $7,614 $2,948 $10,562 7/1/2017 7/1/2019 unknown 4 City of Redlands2 [Systems Administrator/Network Engineer I] $7,554 $2,802 $10,356 I 7/1/2016 unknown unknown ' uv�a��• I . . . - . .to $3,050 6 City of Rancho Mirage' Network&Support Specialist $6,390 $3,120 $9,510 7/1/2017 7/1/2018 1.5% 7 City of Palm Springs N/C 8 City of Poway N/C 9 City of Indian Wells N/C 10 City of Dana Point N/C 11 City of La Quinta N/C 12 City of Cathedral City N/C 13 City of Coachella N/C mmary Results 111111rop Mont Total ,thly Average of Comparators $7,456 $10,625 %City of Palm Desert Above/Below -0.7% -1.6% Median of Comparators $7,614 $10,562 %City of Palm Desert Above/Below -2.8% -1.0% 70th Percentile of Comparators $7,631 $11,119 %City of Palm Desert Above/Below -3.1% -6.4% Number of Matches 5 5 N/C-Non Comparator 1-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 2-City of Redlands:Span of Responsibility Match:This hybrid match represents that the duties are bridged by a higher and lower level classification at the comparator agency. The salary displayed is an average of the matches. Page 20a of 37 Appendix II City of Palm Desert Benefit Detail May 2018 City of Palm ity of Cathedral City o - City of San City of Agency ity of Indio ity of La Quinta o •oway Desert City Coache Spring Mirage Marcos Temecula [Systems Information Network& Benchmark/Comparator Network Administrator/ Senior IT Agency Match Systems N/C N/C N/C N/C Administrator N/C N/C N/C Support Network Network Analyst Specialist • Specialist Engineerl] Top Monthly $8,088 $6,390 $7,554 $7,635 $7,614 Salary Classic _ _ 2.7%@55 2%@60 2%@55 2%@55 2%@60 Enhanced Formula $518 $96 $204 $206 $114 Cost ER Paid Member $305 Contrib C. Calc Classic EPMC m mas Spec Comp $12 K Single Highest Year $38 Social Security _ _ _ $501 _ _ $468 $473 Deferred Compensation $108 $72 Other Ret. $-228 Cafeteria $1,400 $516 $108 $1,200 Health $1,817 $397 $1,949 u Dental $203 m Vision $40 m Life $9 $16 $27 LTD _ _ _ $52 . . $58 $21 STD/SDI $94 $16 Other Ins. $400 y Vacation _ $467 $369 $291 $440 $794 o Holidays — $404 $320 $381 $382 $351 Admin Leave $436 Auto $0 $3.351 $0 $0 $0 $3.120 $2.802 MITEMEECIMI Page 20b of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Total Monthly Compensation May 2018 Information S stems Administrator • Salary Next Classification Title Top Monthl. Benefit Effective Next Salary Perce tage Salary Packag= Increase Date Increase 1 City of Indio Network Administrator S 8.088 S 3.351 $11,439 4/13/2017 unknown unknown 2 City of San Marcos Network Analyst $7,635 $3,623 $11,258 7/1/2017 unknown unknown 3 City of Temecula Senior Information Technology Specialist $7,614 $2,948 $10,562 7/1/2017 7/1/2019 unknown 4 City of Palm Desert Information Systems Administrator I $7,404 $3,050 $10,454 unknown unknown unknown 5 City of Redlands2 [Systems Administrator/Network Engineer I] $7,554 $2,802 $10,356 7/1/2016 unknown unknown 6 City of Rancho Mirage' Network&Support Specialist $6,390 $3,120 $9,510 7/1/2017 7/1/2018 1.5% 7 City of Palm Springs N/C 8 City of Poway N/C 9 City of Indian Wells N/C 10 City of Dana Point N/C 11 City of La Quinta N/C 12 City of Cathedral City N/C 13 City of Coachella N/C Summary Results illkop Monthly MI Total Monthly Average of Comparators $7,456 $10,625 %City of Palm Desert Above/Below -0.7% -1.6% Median of Comparators $7,614 $10,562 %City of Palm Desert Above/Below -2.8% -1.0% 70th Percentile of Comparators $7,631 $11,119 City of Palm Desert Above/Below -3.1% -6.4% Number of Matches 5 5 N/C-Non Comparator 1-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 2-City of Redlands:Span of Responsibility Match:This hybrid match represents that the duties are bridged by a higher and lower level classification at the comparator agency. The salary displayed is an average Page 20c of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Top Monthly Salary May 2018 Information Systems Mana•er I otal Sala Next ' ompara or Agency Classification Title Monthly ffective Percentage -ckage +ate Increase -ase 1 City of Indian Wells Information Technology Manager $13,629 $6,508 $20,137 unknown unknown unknown 2 City of Indio Information Technology Manager $12,990 $4,386 $17,376 4/13/2017 unknown unknown 3 City of Temecula Assistant Director of Information Technology $12,476 $4,681 $17,157 7/1/2017 7/1/2019 unknown 4 City of Palm Desert $12,437 ,I 'r,. _ .... unknown 5 City of San Marcos Information Technology Manager $11,637 $5,229 $16,866 7/1/2017 unknown unknown 6 City of Cathedral City Information Technology Manager $11,069 _ $3,853 $14,922 1/14/2018 unknown unknown 7 City of Poway Information Technology Manager $10,461 _ $3,912 $14,373 7/1/2017 7/1/2018 2.00% 8 City of Rancho Mirage' Information Services Manager $9,913 $3,553 $13,466 7/1/2017 7/1/2018 1.5% 9 City of Coachella Information Technology Manager $9,568 _ $3,711 $13,278 7/1/2017 unknown unknown 10 City of La Quinta N/C _ 11 City of Palm Springs N/C 12 City of Redlands N/C 13 City of Dana Point N/C ummary Results Total Monthly Average of Comparators $11,468 $15,947 %City of Palm Desert Above/Below 7.8% 2.9% Median of Comparators $11,353 $15,894 %City of Palm Desert Above/Below 8.7% 3.2% 70th Percentile of Comparators $12,392 $17,127 %City of Palm Desert Above/Below 0.4% -4.3% Number of Matches 8 8 N/C-Non Comparator 1-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 Page 21a of 37 Appendix II City of Palm Desert Benefit Detail May 2018 Agency City of Palm ity of Cathedral City o ity of Indio ity of La Quinta ity of Desert City Coache. Springs Temecula Benchmark/Comparator Information Information Information Information Information Information Information Information Assistant Agency Match Systems Technology Technology N/C Technology Technology N/C N/C Technology Services N/C Technology Director of Manager Manager Manager Manager Manager Manager Manager Manager Information Top Monthly $12,437 $11,069 $9,568 $13,629 $12,990 $10,461 $9,913 $11,637 $12,476 Salary Classic 2%@55 2%@60 2%@60 2.75%@55 2.7%@55 2%@60 2%@60 2%@55 2%@60 Enhanced Formula ..336 $166 $144 $872 $831 $157 $149 $314 $187 Cost ER Paid Member $775 $873 Contrib C. Calc Classic EPMC E as Spec Comp $54 $61 re Single Highest Year $82 Social Security' $1,327 $663 $663 Deferred IIIII $208 $341 $230 $108 Compensation Other Ret. $-996 $-374 Cafeteria $1,911 $83 $1,400 $108 $1,200 Health $1,817 $1,734 $1,828 $1,817 $1,949 u Dental $169 $141 $86 $203 m Vision $21 $36 $12 $40 m Life $48 $17 $13 $9 $19 $16 $41 LTD _ $27 $21 $66 $83 $52 $58 $32 STD/SDI $13 $32 $94 $25 Other Ins. $400 y Vacation $894 $589 $839 $749 $724 $572 $671 $1,398 it Holidays _ $766 $552 $681 $650 $483 $496 $582 $576 Admin Leave $368 $262 $161 $448 1 $360 Auto $160 $396 .. TrM 853 $3.711 $0 $6.508 $4.386 STEM N/C-Non Comparator 1-City of Indian Wells:City pays employer portion of Social Security.City reimburses employees for employee portion of Social Security benefits. Page 21b of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Total Monthly Compensation May 2018 Information S stems Mana.er Total Salary Next Top Monthly BenefitsIlk Next Salary Comparator Agency Classification Title Monthly effective Percentage Salaryackage �D Increase _II Comp ate Increase — 1 City of Indian Wells Information Technology Manager $13,629 $6,508 $20,137 unknown unknown unknown 2 City of Indio Information Technology Manager $12,990 $4,386 $17,376 4/13/2017 unknown unknown 3 City of Temecula Assistant Director of Information Technology $12,476 _ $4,681 $17,157 7/1/2017 7/1/2019 unknown 4 Cit of San Marcos Information Technolot Mana.er 11 637 5 229 $16.866 7/1/2017 unknown unknown City of Palm Desert Information Systems Manager _ $12,437 3 988 6 City of Cathedral City Information Technology Manager $11,069 $3,853 $14,922 1/14/2018 unknown unknown 7 City of Poway Information Technology Manager $10,461 $3,912 $14,373 7/1/2017 7/1/2018 2.00% 8 City of Rancho Mirage' Information Services Manager $9,913 $3,553 $13,466 7/1/2017 7/1/2018 1.5% 9 City of Coachella Information Technology Manager $9,568 $3,711 $13,278 7/1/2017 unknown unknown 10 City of La Quinta N/C 11 City of Palm Springs N/C 12 City of Redlands N/C 13 City of Dana Point N/C Summary Results op Monthly W Total Monthly Average of Comparators $11,468 $15,947 %City of Palm Desert Above/Below 7.8% 2.9% Median of Comparators $11,353 $15,894 %City of Palm Desert Above/Below 8.7% 3.2% 70th Percentile of Comparators $12,392 $17,127 %City of Palm Desert Above/Below 0.4% -4.3% Number of Matches 8 8 N/C-Non Comparator 1-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 Page 21c of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Top Monthly Salary May 2018 Landscape Specialist la ' omparator Agency Classification Title t i y active Increase 'ercentage mp Date Increase 1 City of Palm Desert Landscape Specialist 111.1111,331 unknown unknown unknown 2 City of San Marcos Landscape Inspector II $7,136 $3,512 $10,648 7/1/2017 7/1/2018 unknown 3 City of Coachella Public Works-Landscape and Lighting Inspector $6,735 $2,952 $9,687 7/1/2017 unknown unknown 4 City of La Quinta Maintenance&Operations Coordinator(Parks Foreman) $6,284 $2,423 $8,707 6/26/2017 unknown unknown 5 City of Poway Contract Specialist-Inspector $6,024 $2,683 $8,707 7/1/2017 7/1/2018 2.00% 6 City of Indio Parks&Landscape Inspector $5,907 $2,827 $8,734 4/13/2017 unknown unknown 7 City of Cathedral City N/C 8 City of Temecula N/C 9 City of Palm Springs N/C 10 City of Rancho Mirage N/C 11 City of Redlands N/C 12 City of Indian Wells N/C 13 City of Dana Point N/C ummary Results Top Mo Tota! Monthly Average of Comparators $6,417 $9,297 City of Palm Desert Above/Below 21.5% 18.0% Median of Comparators $6,284 $8,734 City of Palm Desert Above/Below 23.1% 22.9% 70th Percentile of Comparators $6,645 $9,497 City of Palm Desert Above/Below 18.7% 16.2% Number of Matches 5 5 N/C-Non Comparator Page 22a of 37 Appendix II City of Palm Desert Benefit Detail May 2018 City of Palm ity of Cathedral City o City of San City of Agency ity of Indio ity of La Quinta Desert City Coache. Spring Marcos Temecula 411. Public Works- Parks& Maintenance& Contract Benchmark/Comparator Landscape Landscape N/C Landscape and N/C N/C Landscape Operations N/C Specialist- N/C N/C N/C Agency Match Specialist Inspector II Lighting Inspector Coordinator Inspector Top Monthly $8,172 $6,735 $5,907 $6,284 $6,024 $7,136 Salary _ Classic .@55 2%@60 2.7%@55 2%@60 2%@60 2%@55 Enhanced Formula $221 $101 $378 $94 $90 $193 Cost ER Paid Member Contrib C. Calc Classic EPMC d E as Spec Comp 2 re Single Highest Year Social Security $366 $442 Deferred Compensation Other Ret. Cafeteria $1,400 $1,668 $100 Health $1,817 $1,828 $1,949 u Dental $169 $86 m Vision $21 $12 m Life $17 $9 $11 $25 • LTD $15 $38 $26 $30 $20 STD/SDI $9 $31 $15 Other Ins. y Vacation $414 $341 $363 $348 $412 aaa Holidays _ $389 $295 $242 $278 $357 Admin Leave Auto 122E2=15 2.952 $0 $0 $2.827 $ WrErElr- _irlirlar Page 22b of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Total Monthly Compensation May 2018 Landsca.e S•ecial ist Top Monthly Benefits Total Salary Next Salary Next k Comparator Agency Classification Title Salary Package Monthly Effective Increase Percentage City of Palm Desert Landscape Specialist 2 City of San Marcos Landscape Inspector II $7,136 $3,512 $10,648 7/1/2017 7/1/2018 unknown 3 City of Coachella Public Works-Landscape and Lighting Inspector $6,735 $2,952 $9,687 7/1/2017 unknown unknown 4 City of Indio Parks&Landscape Inspector $5,907 $2,827 $8,734 unknown unknown unknown 5 City of La Quinta Maintenance&Operations Coordinator(Parks Foreman) $6,284 $2,423 $8,707 6/26/2017 unknown unknown 6 City of Poway Contract Specialist-Inspector $6,024 $2,683 $8,707 7/1/2017 7/1/2018 2.00% 7 City of Cathedral City N/C 8 City of Temecula N/C 9 City of Palm Springs N/C 10 City of Rancho Mirage N/C 11 City of Redlands N/C 12 City of Indian Wells N/C 13 City of Dana Point N/C Summary Results Top MORI Average of Comparators $6,417 $9,297 City of Palm Desert Above/Below 21.5% 18.0% Median of Comparators $6,284 $8,734 City of Palm Desert Above/Below 23.1% 22.9% 70th Percentile of Comparators $6,645 $9,497 City of Palm Desert Above/Below 18.7% 16.2% Number of Matches 5 5 N/C-Non Comparator Page 22c of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Top Monthly Salary May 2018 Landscape Su ervisor la kage 'ont yIs 'ective Increase CompIncrease 1 City of Dana Point Parks Manager $10,629 $3,414 $14,043 10/1/2017 unknown unknown 2 City of Temecula Maintenance Supervisor-Landscape $9,508 $3,948 $13,456 7/1/2017 7/1/2019 unknown - Desert I anrlccane Si n-rvicnr $9.248 $3.490 $12.738 unknown unknown unknown 4 City of Indio Park&Landscape Supervisor $8,587 $3,471 $12,058 4/13/2017 unknown unknown 5 City of Palm Springs Maintenance Supervisor $7,692 $3,410 $11,102 6/18/2017 unknown unknown 6 City of San Marcos Landscape Inspection Supervisor $7,635 $3,623 $11,258 7/1/2017 7/1/2018 unknown 7 City of Cathedral City Public Works Supervisor $7,492 $3,293 $10,785 1/14/2018 unknown unknown 8 City of Poway Parks Maintenance Supervisor $7,033 $3,040 $10,073 7/1/2017 7/1/2018 2.00% 9 City of La Quinta Maintenance and Operations Superintendent(Parks Superintendent) $6,865 $2,487 $9,353 6/26/2017 unknown unknown 10 City of Rancho Mirage' Building-Landscape Maintenance Supervisor $6,390 $3,120 $9,510 7/1/2017 7/1/2018 1.5% 11 City of Redlands Field Services Supervisor $6,201 $2,477 $8,678 7/1/2016 unknown unknown 12 City of Coachella Public Works Streets Maintenance Worker II $4,291 $2,615 $6,906 7/1/2017 unknown unknown 13 City of Indian Wells N/C mmary Results Top Monthly Total Monthly Average of Comparators $7,484 $10,656 %City of Palm Desert Above/Below 19.1% 16.3% Median of Comparators $7,492 $10,785 %City of Palm Desert Above/Below 19.0% 15.3% 70th Percentile of Comparators $7,692 $11,258 %City of Palm Desert Above/Below 16.8% 11.6% Number of Matches 11 11 N/C-Non Comparator 1-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 Page 23a of 37 Appendix II City of Palm Desert Benefit Detail May 2018 Agency City of Palm ity of Cathedral City o ity of Indio ity of La Quints Desert City Coache Point Springs Public Works Park& Maintenance Parks Building- Landscape Maintenance Benchmark/Comparator Landscape Public Works Maintenance Field Services Streets Parks Manager N/C Landscape and Operations Maintenance Landscape Inspection Supervisor- Agency Match Supervisor Supervisor Supervisor Supervisor Maintenance Supervisor Superintendent Supervisor Maintenance Supervisor Landscape Top Monthly $9,248 $7,492 $4,291 $10,629 $8,587 $6,865 $7,692 $7,033 $6,390 $6,201 $7,635 $9,508 Salary Classic 2%@55 2%@60 2%@60 2%@55 2.7%@55 2%@60 2%@60 2%@60 2%@60 2%@55 2&@%5 2%@60 Enhanced Formula ..250 $112 $64 $287 $550 $103 $115 $105 $96 $167 $206 $143 Cost ER Paid Member $524 $666 Contrib _ C. Calc Classic EPMC E as Spec Comp $37 $47 re Single Highest Year $53 $31 Social Security $532 $384 $473 Deferredel $208 $149 $108 $72 Compensation _ Other Ret. _ _ $-674 — - — _ $-285 Cafeteria $1,911 $1,275 $1,400 $1,668 $2,011 $516 $108 $1,200 Health $1,817 $1,828 $1,817 $397 $1,949 u Dental $169 $86 $203 m Vision $21 _ _ $12 _ $40 m Life $32 $17 $9 $12 $13 $16 $27 LTD _ $18 $10 $55 $26 $88 $35 $58 $21 STD/SDI $6 $31 $94 $16 Other Ins. $400 us Vacation''' $605 $264 $1,226 $495 $396 $799 _ $487 $369 $238 $440 $1,065 agar Holidays — $519 $248 $572 $429 $264 $385 $325 $320 $313 $382 $439 Admin Leave — — $358 1 $274 Auto I FM $2.615 $3,414 $0 $3,471 $2,487 . ' $3,040 $3,120 $2,477 N/C-Non Comparator 1-City of Dana Point:City offers comprehensive leave that includes vacation and sick leave combined. 2-City of Palm Springs:City offers annual leave that includes vacation and sick leave combined. Page 23b of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Total Monthly Compensation May 2018 Landscape Su•ervisor Top Monthly Benefits Total Sala ext Salary Next - -.rator Agency Classification Title Salary Package Monthly Effecti Increase Percentage Comp Date Increase 1 City of Dana Point Parks Manager $10,629 $3,414 $14,043 10/1/2017 unknown unknown 2 City of Temecula Maintenance Supervisor-Landscape $9,508 $3,948 $13,456 7/1/2017 7/1/2019 unknown 3 City of Palm Desert Landscape Supervisor $9,248 $3,490 $12,738 unknown unknown unknown 4 City of Indio Park&Landscape Supervisor $8,587 $3,471 $12,058 4/13/2017 unknown unknown 5 City of San Marcos Landscape Inspection Supervisor $7,635 $3,623 $11,258 7/1/2017 7/1/2018 unknown 6 City of Palm Springs Maintenance Supervisor $7,692 $3,410 $11,102 6/18/2017 unknown unknown 7 City of Cathedral City Public Works Supervisor $7,492 $3,293 $10,785 1/14/2018 unknown unknown 8 City of Poway Parks Maintenance Supervisor $7,033 $3,040 $10,073 7/1/2017 7/1/2018 2.00% 9 City of Rancho Mirage' Building-Landscape Maintenance Supervisor $6,390 $3,120 $9,510 7/1/2017 7/1/2018 1.5% 10 City of La Quinta Maintenance and Operations Superintendent(Parks Superintendent) $6,865 $2,487 $9,353 6/26/2017 unknown unknown 11 City of Redlands Field Services Supervisor $6,201 $2,477 $8,678 7/1/2016 unknown unknown 12 City of Coachella Public Works Streets Maintenance Worker II $4,291 $2,615 $6,906 7/1/2017 unknown unknown 13 City of Indian Wells N/C Summary Results Top Monthly Total Monthly Average of Comparators $7,484 $10,656 %City of Palm Desert Above/Below 19.1% 16.3% Median of Comparators $7,492 $10,785 %City of Palm Desert Above/Below 19.0% 15.3% 70th Percentile of Comparators $7,692 $11,258 %City of Palm Desert Above/Below 16.8% 11.6% Number of Matches 11 11 N/C-Non Comparator 1-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 Page 23c of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Top Monthly Salary May 2018 Maintenance Worker II Sala omparator Agency Classification Title Sal ckage on ly Effective Increase 'ercen age Comp Date Increase 1 City of Palm Desert Maintenance Worker II $6,075 $2,860 $8,935 unknown unknown unknown 2 City of San Marcos Street Maintenance Worker II $5,652 $3,208 $8,860 7/1/2017 7/1/2018 unknown 3 City of Indian Wells Public Works Maintenance Worker II $5,603 $3,956 $9,559 unknown unknown unknown 4 City of Dana Point Building-Facilities Maintenance Worker II $5,228 $2,001 $7,229 10/1/2017 unknown unknown 5 City of Temecula Maintenance Worker II $5,129 $2,679 $7,808 7/1/2017 7/1/2019 unknown 6 City of Indio Street Maintenance Worker II $4,961 $2,600 $7,561 4/13/2017 unknown unknown 7 City of Palm Springs Street-Traffic Maintenance Worker $4,651 $2,727 $7,378 6/18/2017 unknown unknown 8 City of Cathedral City' [Street Maintenance Worker II/Facilities Maintenance Worker II] $4,575 $2,734 $7,309 7/2/2017 unknown unknown 9 City of Rancho Mirage' Street Maintenance Worker I $4,541 $2,893 $7,435 7/1/2017 7/1/2018 1.5% 10 City of Poway Construction Maintenance Worker II $4,369 $2,475 $6,844 7/1/2017 7/1/2018 2.00% 11 City of La Quinta Maintenance&Operations Worker(Maintenance Worker II) $4,250 $2,197 $6,447 6/26/2017 unknown unknown 12 City of Redlands Maintenance Worker II $3,649 $1,615 $5,264 7/1/2016 unknown unknown 13 City of Coachella N/C mmary Results Top Monthly Total Monthly Average of Comparators $4,783 $7,427 %City of Palm Desert Above/Below 21.3% 16.9% Median of Comparators $4,651 $7,378 %City of Palm Desert Above/Below 23.4% 17.4% 70th Percentile of Comparators $5,129 $7,561 %City of Palm Desert Above/Below 15.6% 15.4% Number of Matches 11 11 N/C-Non Comparator 1-City of Cathedral City:Functional Match:This hybrid match represents that the duties of the class are performed by more than one class at the comparator agency. The salary displayed is the higher of the matches. 2-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 Page 24a of 37 Appendix II City of Palm Desert Benefit Detail May 2018 City of Palm ity of Cathedral City o City of San City of Agency ity of Indio ity of La Quinta Desert City Coache Spring Marcos Temecula [Street Building- Public Works Street Maintenance& Street-Traffic Construction Street Street Benchmark/Comparator Maintenance Maintenance Maintenance Maintenance N/C Facilities Maintenance Maintenance Operations Maintenance Maintenance Maintenance Maintenance Agency Match Worker II Worker II Worker II Worker II/ Maintenance Worker II Worker II Worker Worker Worker II Worker I Worker II Top Monthly $6,075 $4,575 $5,228 $5,603 $4,961 $4,250 $4,651 $4,369 $4,541 $3,649 $5,652 $5,129 Salary Classic 2%@55 2%@60 2%@55 2.75%@55 2.7%@55 2%@60 2%@60 2%@60 2%@60 2%@55 2%@55 2%@60 Enhanced Formula 164 $69 $141 $359 $318 $64 $70 $66 $68 $99 $153 $77 Cost ER Paid Member $359 Contrib _ C. Calc Classic EPMC E as Spec Comp $25 re Single Highest Year $26 $34 $18 Social Security' $695 $308 $226 $350 DeferredIIIIIII $100 $140 $108 Compensation Other Ret. C $-154 Cafeteria $1,911 $1,150 $83 $1,400 $1,668 $1,985 $503 $100 $1,200 Health $1,734 $1,828 $1,817 $397 $1,949 u Dental $141 $86 $203 m Vision $36 $12 $40 m Life $10 $13 $9 $11 $8 $16 $20 LTD _ $11 $66 $32 $26 $53 $22 $58 $16 STD/SDI $32 $31 $94 $12 Other Ins. $400 y Vacation'•' $317 $402 $345 $286 $245 $376 $252 $262 $140 $326 $535 agar Holidays _ $317 $282 $280 $248 $163 $233 $202 $227 $232 $283 $237 Admin Leave — Auto I ,,. E .Fill_5 $2.001 $3.956 $2,600 $2,197 $2,727 ' 2.475 $2,893 $1,615 $3,208 $2.679 N/C-Non Comparator 1-City of Indian Wells:City pays employer portion of Social Security.City reimburses employees for employee portion of Social Security benefits. 2-City of Dana Point City offers comprehensive leave that includes vacation and sick leave combined. 3-City of Palm Springs:City offers general leave that includes vacation and sick leave combined. Page 24b of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Total Monthly Compensation May 2018 Maintenance Worker II S omparator Agency assification Title Top Monthly Benefits Monthlly Effective Next Sala Salary Package ,m. Date Increa 1 City of Indian Wells Public Works Maintenance Worker II S 5.603 S 3.956 S 9.559 unknown unknown unknown Maintenance Wor'. 3 City of San Marcos Street Maintenance Worker II $5,652 $3,208 $8,860 7/1/2017 7/1/2018 unknown 4 City of Temecula Maintenance Worker II $5,129 $2,679 $7,808 7/1/2017 7/1/2019 unknown 5 City of Indio Street Maintenance Worker II $4,961 $2,600 $7,561 4/13/2017 unknown unknown 6 City of Rancho Mirage' Street Maintenance Worker I $4,541 $2,893 $7,435 7/1/2017 7/1/2018 1.5% 7 City of Palm Springs Street-Traffic Maintenance Worker $4,651 $2,727 $7,378 6/18/2017 unknown unknown 8 City of Cathedral City' [Street Maintenance Worker II/Facilities Maintenance Worker II] $4,575 $2,734 $7,309 7/2/2017 unknown unknown 9 City of Dana Point Building-Facilities Maintenance Worker II $5,228 $2,001 $7,229 10/1/2017 unknown unknown 10 City of Poway Construction Maintenance Worker II $4,369 $2,475 $6,844 7/1/2017 7/1/2018 2.00% 11 City of La Quinta Maintenance&Operations Worker(Maintenance Worker II) $4,250 $2,197 $6,447 6/26/2017 unknown unknown 12 City of Redlands Maintenance Worker II $3,649 $1,615 $5,264 7/1/2016 unknown unknown 13 City of Coachella N/C Summary Results lir Tornthly Total Monthly Average of Comparators $4,783 $7,427 City of Palm Desert Above/Below 21.3% 16.9% Median of Comparators $4,651 $7,378 City of Palm Desert Above/Below 23.4% 17.4% 70th Percentile of Comparators $5,129 $7,561 City of Palm Desert Above/Below 15.6% 15.4% Number of Matches 11 11 N/C-Non Comparator 1-City of Cathedral City:Functional Match:This hybrid match represents that the duties of the class are performed by more than one class at the comparator agency. The salary displayed is the higher of the matches. 2-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 Page 24c of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Top Monthly Salary May 2018 Mane•ement S.ecialist II Top Monthly Benefits Total Salary Next Next Salary ssificetion Tit!, Salary Package Monthly Effective Increase Percentage Comp Date Increase 1 City of Rancho Mirages [Human Resources Specialist/Planning Technician/Permit Technician] $7,397 $3,244 $10,641 7/1/2017 7/1/2018 1.5% 2 City of Indio° [Permit Technician II/Planning Technician Il/Senior Administrative Assistant] $7,284 $3,158 $10,441 4/13/2017 unknown unknown 3 City of Palm Desert Management Specialist II $7,224 $3,024 $10,248 unknown unknown unknown 4 City of San Marcos" [Housing Program Specialist/Human Resources/Risk Technician/Permit $6,732 $3,429 $10,161 7/1/2017 7/1/2018 unknown Technician/Planning Technician] 5 City of Temecula" [Community Services Development Technician II/Executive Assistant/ $6,405 $3,182 $9,587 7/1/2017 7/1/2019 unknown Human Resources Technician II/Management Assistant/Records Coordinator/Senior Business License Technician] 6 City of Palm Springs` [Housing Program Assistant/Human Resources Specialist/Permit Technician $6,318 $3,163 $9,481 6/18/2017 unknown unknown /Planning Administrative Coordinator/Planning Technician] 7 City of Cathedral City' [Building&Permit Specialist/Human Resources Specialist] $6,163 $3,085 $9,248 1/14/2018 unknown unknown 8 City of Poway' [Human Resources Technician II/Planning Technician/Records Technician/ $6,035 $2,903 $8,939 7/1/2017 7/1/2018 0.02 Senior Administrative Assistant] 9 City of La Quints' [Administrative Technician/Code Administration Technician/Management $5,848 $2,374 $8,222 6/26/2017 unknown unknown Assistant/Management Specialist] 10 City of Dana Point' [Permit Technician/City Clerk Specialist/Senior Administrative Assistant] $5,687 $2,076 $7,763 10/1/2017 unknown unknown 11 City of Coachella' [Business License Technician/Human Resources Technician/Planning $5,322 $2,757 $8,079 7/1/2017 unknown unknown Technician] 12 City of Redlands' [Counter Services Technician/Human Resources Technician/Permit $5,274 $1,933 $7,207 7/1/2016 unknown unknown Technician II/Project Assistant/Senior Administrative Technician] _ 13 City of Indian Wells N/C Summary Results Top Monthly Total Monthly Average of Comparators $6,224 $9,070 %City of Palm Desert Above/Below 13.8% 11.5% Median of Comparators $6,163 $9,248 %City of Palm Desert Above/Below 14.7% 9.8% 70th Percentile of Comparators $6,405 $9,587 %City of Palm Desert Above/Below 11.3% 6.5% Number of Matches 11 11 N/C-Non Comparator 1-City of Cathedral City:Functional Match:This hybrid match represents that the duties of the class are performed by more than one class at the comparator agency.The salary displayed is the higher of the matches. 2-City of Coachella:Functional Match:This hybrid match represents that the duties of the class are performed by more than one class at the comparator agency.The salary displayed is the higher of the matches. 3-City of Dana Point:Functional Match:This hybrid match represents that the duties of the class are performed by more than one class at the comparator agency.The salary displayed is the higher of the matches. 4-City of Indio:Functional Match:This hybrid match represents that the duties of the class are performed by more than one class at the comparator agency.The salary displayed is the higher of the matches. 5-City of La Quinta:Span of Responsibility Match:This hybrid match represents that the duties are bridged by a higher and lower level classification at the comparator agency.The salary displayed is an average of the matches. 6-City of Palm Springs:Functional Match:This hybrid match represents that the duties of the class are performed by more than one class at the comparator agency.The salary displayed is the higher of the matches. 7-City of Poway:Functional Match:This hybrid match represents that the duties of the class are performed by more than one class at the comparator agency.The salary displayed is the higher of the matches. 8-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013. 9-City of Redlands:Functional Match:This hybrid match represents that the duties of the class are performed by more than one class at the comparator agency.The salary displayed is the higher of the matches. 10-City of San Marcos:Functional Match:This hybrid match represents that the duties of the class are performed by more than one class at the comparator agency.The salary displayed is the higher of the matches. 11-City of Temecula:Functional Match:This hybrid match represents that the duties of the class are performed by more than one class at the comparator agency.The salary displayed is the higher of the matches.Comnwnity Page 25a of 37 Appendix II City of Palm Desert Benefit Detail May 2018 Agency City of Palm ity of Cathedral City o ity of Indio ity of La Quinta City of Desert City Coache. I Springs Temecula Benchmark/Comparator Management [Building& [Business License [Permit [Permit [Administrative [Housing [Human [Human [Counter [Housing [Community Agency Match Specialist II Permit Specialist Technician/ Technician/City N/C Technician II/ Technician/ Program Resources Resources Services Program Services /Human Human Clerk Specialist/ Planning Code Assistant/ Technician llj Specialist/ _ Technician/ Specialist/ Development Top Monthly $7,224 $6,163 $5,322 $5,687 $7,284 $5,848 $6,318 $6,035 $7,397 $5,274 $6,732 $6,405 Salary Classic 2%@55 2%@60 2%@60 2%@55 2.7%@55 2%@60 2%@60 2%@60 2%@60 2%@55 2%@55 2%@60 Enhanced Formula 195 $92 $80 $154 $466 $88 $95 $91 $111 $142 $182 $96 Cost ER Paid Member $431 $448 Contrib C. Calc Classic EPMC E as Spec Comp $30 $31 re Single Highest Year $28 $26 Social Security $452 $327 $417 Deferredel $208 $149 $108 Compensation Other Ret. _ _ $-555 — - — — r $-192 Cafeteria $1,911 $1,150 $1,400 $1,668 $2,011 $503 $100 $1,200 Health $1,817 $1,828 $1,817 $397 $1,949 u Dental $169 $86 $203 m Vision $21 _ _ $12 _ $40 m Life $27 $17 $9 $12 $11 $16 $23 • LTD _ $15 $12 $47 $26 $73 $30 $58 $19 STD/SDI $7 $31 $94 $14 Other Ins. $400 us Vacation'.' $498 $327 $437 $420 $337 $656 $418 $427 $203 $388 $717 d Holidays — $427 $307 $306 $364 $225 $316 $279 $370 $335 $337 $296 Admin Leave _ $185 Auto =.. I 085 $2,757 $2,076 $0 $3.158 $2,374 ' .903 $3,244 $1,933 $3,429 $3,182 N/C-Non Comparator 1-City of Dana Point:City offers comprehensive leave that includes vacation and sick leave combined. 2-City of Palm Springs:City offers annual leave that includes vacation and sick leave combined. Page 25b of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Total Monthly Compensation May 2018 Management Specialist II °p refits ota Salary Next Salary Next Classifc.. Month! Monthly Effective Percentage Salary ackage Comp Date Increase Increase 1 City of Rancho Mirages [Human Resources Specialist/Planning Technician/Permit Technician] $7,397 $3,244 $10,641 7/1/2017 7/1/2018 1.5% 2 City of Indio° [Permit Technician II/Planning Technician II/Senior Administrative Assistant] $7,284 $3,158 $10,441 4/13/2017 unknown unknown 3 City of Palm Desert Management Specialist Jam 4 City of San Marcos10 [Housing Program Specialist/Human Resources/Risk Technician/Permit $6,732 $3,429 $10,161 7/1/2017 7/1/2018 unknown Technician/Planning Technician] 5 City of Temecula" [Community Services Development Technician II/Executive Assistant/Human $6,405 $3,182 $9,587 7/1/2017 7/1/2019 unknown Resources Technician II/Management Assistant/Records Coordinator/Senior Business License Technician] 6 City of Palm Springs' [Housing Program Assistant/Human Resources Specialist/Permit Technician/ $6,318 $3,163 $9,481 6/18/2017 unknown unknown Planning Administrative Coordinator/Planning Technician] 7 City of Cathedral City' [Building&Permit Specialist/Human Resources Specialist] $6,163 $3,085 $9,248 1/14/2018 unknown unknown 8 City of Poway' [Human Resources Technician II/Planning Technician/Records Technician/ $6,035 $2,903 $8,939 7/1/2017 7/1/2018 0.02 Senior Administrative Assistant] 9 City of La Quintal [Administrative Technician/Code Administration Technician/Management $5,848 $2,374 $8,222 6/26/2017 unknown unknown Assistant/Management Specialist] 10 City of Coachella' [Business License Technician/Human Resources Technician/Planning $5,322 $2,757 $8,079 7/1/2017 unknown unknown Technician] 11 City of Dana Point' [Permit Technician/City Clerk Specialist/Senior Administrative Assistant] $5,687 $2,076 $7,763 10/1/2017 unknown unknown 12 City of Redlands' [Counter Services Technician/Human Resources Technician/Permit $5,274 $1,933 $7,207 7/1/2016 unknown unknown Technician II/Project Assistant/Senior Administrative Technician] 13 City of Indian Wells N/C Summary Results Top 161 Total Monthly Monthly Average of Comparators $6,224 $9,070 %City of Palm Desert Above/Below 13.8% 11.5% Median of Comparators $6,163 $9,248 %City of Palm Desert Above/Below 14.7% 9.8% 70th Percentile of Comparators $6,405 $9,587 %City of Palm Desert Above/Below 11.3% 6.5% Number of Matches 11 11 N/C-Non Comparator 1-City of Cathedral City:Functional Match:This hybrid match represents that the duties of the class are performed by more than one class at the comparator agency.The salary displayed is the higher of the matches. 2-City of Coachella:Functional Match:This hybrid match represents that the duties of the class are performed by more than one class at the comparator agency.The salary displayed is the higher of the matches. 3-City of Dana Point:Functional Match:This hybrid match represents that the duties of the class are performed by more than one class at the comparator agency.The salary displayed is the higher of the matches. 4-City of Indio:Functional Match:This hybrid match represents that the duties of the class are performed by more than one class at the comparator agency.The salary displayed is the higher of the matches. 5-City of La Quinta:Span of Responsibility Match:This hybrid match represents that the duties are bridged by a higher and lower level classification at the comparator agency.The salary displayed is an average of the matches. 6-City of Palm Springs:Functional Match:This hybrid match represents that the duties of the class are performed by more than one class at the comparator agency.The salary displayed is the higher of the matches. 7-City of Poway:Functional Match:This hybrid match represents that the duties of the class are performed by more than one class at the comparator agency.The salary displayed is the higher of the matches. 8-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013. 9-City of Redlands:Functional Match:This hybrid match represents that the duties of the class are performed by more than one class at the comparator agency.The salary displayed is the higher of the matches. 10-City of San Marcos:Functional Match:This hybrid match represents that the duties of the class are performed by more than one class at the comparator agency.The salary displayed is the higher of the matches. 11-City of Temecula:Functional Match:This hybrid match represents that the duties of the class are performed by more than one class at the comparator agency.The salary displayed is the higher of the matches.Community Page 25c of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Top Monthly Salary May 2018 Office S.ecialist II al ext ' omparator Agency Classification Title Salary Packag ont active Increase entage Comp Date crease 1 City of Palm Desert Office Specialist II $5,785 $2,819 = $8,604 unknown unknown unknown 2 City of Cathedral City Administrative Assistant II $5,292 $2,847 $8,139 7/2/2017 unknown unknown 3 City of Dana Point Administrative Assistant $5,118 $1,983 $7,101 10/1/2017 unknown unknown 4 City of San Marcos Office Specialist III $5,030 $3,089 $8,119 7/1/2017 unknown unknown 5 City of Temecula Senior Office Specialist $4,533 $2,554 $7,087 7/1/2017 7/1/2019 unknown 6 City of Coachella Department Assistant II $4,502 $2,645 $7,147 7/1/2017 unknown unknown 7 City of La Quintal [Administrative Assistant/Administrative Technician] $4,444 $2,218 $6,662 6/26/2017 unknown unknown 8 City of Palm Springs Secretary $4,425 $2,692 $7,117 6/18/2017 unknown unknown 9 City of Rancho Mirage' Office Assistant III $4,325 $2,867 $7,192 7/1/2017 7/1/2018 1.5% 10 City of Indio Office Assistant $3,964 $2,361 $6,324 4/13/2017 unknown unknown 11 City of Redlands Administrative Assistant II $3,874 $1,659 $5,533 7/1/2016 unknown unknown 12 City of Poway Administrative Assistant II $3,768 $2,400 $6,168 7/1/2017 7/1/2018 2.00% 13 City of Indian Wells N/C mmary Results Top Monthly Total Monthly Average of Comparators $4,480 $6,963 %City of Palm Desert Above/Below 22.6% 19.1% Median of Comparators $4,444 $7,101 %City of Palm Desert Above/Below 23.2% 17.5% 70th Percentile of Comparators $4,533 $7,147 %City of Palm Desert Above/Below 21.6% 16.9% Number of Matches 11 11 N/C-Non Comparator 1-City of La Quinta:Span of Responsibility Match:This hybrid match represents that the duties are bridged by a higher and lower level classification at the comparator agency. The salary displayed is an average of the matches. 2-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 Page 26a of 37 Appendix II City of Palm Desert Benefit Detail May 2018 City of Palm ity of Cathedral City o City of Rancho City of Redlands City of San City of Agency ity of Indio ity of La Quints of Poway Desert City Coache Point Springs Mirage Marcos Temecula Benchmark/Comparator • ice Administrative Department Administrative [Administrative Administrative Office Assistant Administrative Office Specialist Senior Office Agency Match Specialist II Assistant II Assistant II Assistant N/C Office Assistant Assistant/ Secretary Assistant II III Assistant II III Specialist Administrative Top Monthly $5,785 $5,292 $4,502 $5,118 $3,964 $4,444 $4,425 $3,768 $4,325 $3,874 $5,030 $4,533 Salary — Classic 2%@55 2%@60 2%@60 2%@55 2.7%@55 2%@60 2%@60 2%@60 2%@60 2%@55 2%@55 2%@60 Enhanced Formula $156 $79 $68 $138 $254 $67 $66 $57 $65 $105 $136 $68 Cost ER Paid Member $317 Contrib C. Calc Classic EPMC E as Spec Comp $22 re Single Highest Year $26 $19 Social Security $246 $240 $312 Deferred MI $100 $108 Compensation Other Ret. _ — _ — — — $-136 Cafeteria $1,911 $1,150 $1,400 $1,668 $1,985 $503 $108 $1,200 Health $1,817 $1,828 $1,817 $397 $1,949 u Dental $169 $86 $203 m Vision $21 $12 $40 m Life $11 $17 $9 $11 $7 $16 $18 LTD _ $13 $10 $25 $26 $51 $19 $58 $14 STD/SDI $6 $31 $94 $11 Other Ins. $400 at Vacation'.' $366 $277 $394 $229 $256 $357 $217 $250 $149 $290 $473 agar Holidays — $366 $260 $276 $198 $171 $221 $174 $216 $246 $252 $209 Admin Leave Auto 17122BIZE. I 847 $2.645 $1,983 $0 $2.361 $2,218 $2,692 $2,400 $2.867 $1,659 $3,089 $2.554 N/C-Non Comparator 1-City of Dana Point:City offers comprehensive leave that includes vacation and sick leave combined. 2-City of Palm Springs:City offers general leave that includes vacation and sick leave combined. Page 26b of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Total Monthly Compensation May 2018 Office S•ecialist II Total Salary=. Next Top Monthly Benefits Next Salary Comparator Agency Classification Title Salary Package Monthly Effective Increase Percentage Comp Date Increase City of Palm Desert Office Specialist II $5,785 $2,819 $8,604 unknown unknown unknown 2 City of Cathedral City Administrative Assistant II $5,292 $2,847 $8,139 7/2/2017 unknown unknown 3 City of San Marcos Office Specialist III $5,030 $3,089 $8,119 7/1/2017 unknown unknown 4 City of Rancho Mirage2 Office Assistant III $4,325 $2,867 $7,192 7/1/2017 7/1/2018 1.5% 5 City of Coachella Department Assistant II $4,502 $2,645 $7,147 7/1/2017 unknown unknown 6 City of Palm Springs Secretary $4,425 $2,692 $7,117 6/18/2017 unknown unknown 7 City of Dana Point Administrative Assistant $5,118 $1,983 $7,101 10/1/2017 unknown unknown 8 City of Temecula Senior Office Specialist $4,533 $2,554 $7,087 7/1/2017 7/1/2019 unknown 9 City of La Quintal [Administrative Assistant/Administrative Technician] $4,444 $2,218 $6,662 6/26/2017 unknown unknown 10 City of Indio Office Assistant $3,964 $2,361 $6,324 4/13/2017 unknown unknown 11 City of Poway Administrative Assistant II $3,768 $2,400 $6,168 7/1/2017 7/1/2018 2.00% 12 City of Redlands Administrative Assistant II $3,874 $1,659 $5,533 7/1/2016 unknown unknown 13 City of Indian Wells N/C Summary Results Top M, Total Monthly Average of Comparators $4,480 $6,963 City of Palm Desert Above/Below 22.6% 19.1% Median of Comparators $4,444 $7,101 City of Palm Desert Above/Below 23.2% 17.5% 70th Percentile of Comparators $4,533 $7,147 City of Palm Desert Above/Below 21.6% 16.9% Number of Matches 11 11 N/C-Non Comparator 1-City of La Quinta:Span of Responsibility Match:This hybrid match represents that the duties are bridged by a higher and lower level classification at the comparator agency. The salary displayed is an average of the matches. 2-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 Page 26c of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Top Monthly Salary May 2018 Plans Examiner Sala Classification Title Effective Increase ercentage 1116A116 1 City of Indio Plans Examiner $8,292 $3,400 $11,692 4/13/2017 I unknown I unknown ity of Palm Desert Plans Examiner $7,589 $3,076 $10,665 unknown unknown unknown 3 City of Palm Springs Plans Examiner $6,902 $3,081 $9,983 6/18/2017 unknown unknown 4 City of Redlands _ Plans Examiner _ $6,630 $2,199 $8,829 7/1/2016 unknown_ unknown _5 Cjy of La Quints Code Administration Specialist(Plans Examiner) _ $5.799 $2.369 , $8.168 6/26/2017 unknown_ unknown 6 City of Cathedral City N/C 7 City of Coachella N/C 8 City of Dana Point N/C 9 City of Indian Wells N/C 10 City of Poway N/C 11 City of Rancho Mirage N/C 12 City of San Marcos N/C 13 City of Temecula N/C mmary Results Top Mo otal onthly Average of Comparators $6,906 $9,668 %City of Palm Desert Above/Below 9.0% 9.4% Median of Comparators $6,766 $9,406 %City of Palm Desert Above/Below 10.9% 11.8% 70th Percentile of Comparators $7,041 $10,154 %City of Palm Desert Above/Below 7.2% 4.8% Number of Matches 4 4 N/C-Non Comparator Page 27a of 37 Appendix II City of Palm Desert Benefit Detail May 2018 • Agency City of Palm ity of Cathedral City o ity of Indio ity of La Quints o •oway ity of Rancho City of Redlands City of San City of Desert City Coache Springs Mirage Marcos Temecula Benchmark/Comparator Code Agency Match Plans Examiner N/C N/C N/C N/C Plans Examiner Administration Plans Examiner N/C N/C Plans Examiner N/C N/C Specialist(Plans Top Monthly I $8,292 $5,799 $6,902 $6,630 Salary _ Classic 2.7%@55 2%@60 2%@60 2%@55 Enhanced Formula $531 $87 $104 $179 Cost — _ ER Paid Member Contrib c Calc Classic EPMC d E as Spec Comp 2 re Single Highest Year $33 Social Security $514 $411 Deferred Compensation Other Ret. Cafeteria $1,400 $1,668 $1,985 $503 Health $397 u Dental m Vision Ie Life $9 $11 LTD $53 $26 $79 STD/SDI I $31 Other Ins. y Vacation' $478 $335 $557 $255 agar Holidays — $415 $223 $345 $421 Admin Leave Auto I:! AM $0 $0 $0 $3.400 $2. ' EIrrlin. WErg N/C-Non Comparator 1-City of Palm Springs:City offers general leave that includes vacation and sick leave combined. Page 27b of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Total Monthly Compensation May 2018 Plans Examiner Top Month! -nefits Total Salary Next Salary Next Comparator Agency assification Title Salary ckage Monthly Effective Increase Percentage • . Date Increase 1 City of Indio Plans Examiner $8,292 $3,400 $11,692 4/13/2017 unknown unknown City of Palm Desert ..s Examrda ' $ liFi unknown 3 City of Palm Springs Plans Examiner $6,902 $3,081 $9,983 6/18/2017 unknown unknown 4 City of Redlands Plans Examiner $6,630 $2,199 $8,829 7/1/2016 unknown unknown 5 City of La Quinta Code Administration Specialist(Plans Examiner) $5.799 S 2.369 S 8.168 6/26/2017 unknown unknown 6 City of Cathedral City N/C 7 City of Coachella N/C 8 City of Dana Point N/C 9 City of Indian Wells N/C 10 City of Poway N/C 11 City of Rancho Mirage N/C 12 City of San Marcos N/C 13 City of Temecula N/C Summary Results Top MolMil M Average of Comparators $6,906 $9,668 City of Palm Desert Above/Below 9.0% 9.4% Median of Comparators $6,766 $9,406 City of Palm Desert Above/Below 10.9% 11.8% 70th Percentile of Comparators $7,041 $10,154 City of Palm Desert Above/Below 7.2% 4.8% Number of Matches 4 4 N/C-Non Comparator Page 27c of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Top Monthly Salary May 2018 Project Mana•er otal Sala xt Comparator Agency Classification Title Salary ckage onthly Effective Increase ercentage Comp Date Increase 1 City of Palm Desert Project Manager $10,210 $3,646 $13,85t1—bnknown unknown unknown 2 City of La Quinta Code Administration Coordinator(Construction $8,124 $2,784 $10,908 6/26/2017 unknown unknown Manager/Inspection Supervisor) _ 3 City of Poway Special Projects Engineer $7,958 $3,331 $11,289 7/1/2017 7/1/2018 2.00% 4 City of Redlands Project Manager II $7,952 $2,898 $10,850 7/1/2016 unknown unknown 5 City of Rancho Mirage' Project Manager $7,767 $3,379 $11,146 7/1/2017 7/1/2018 1.5% _ 6 City of Coachella' Construction Project Coordinator $7,070 $2,998 $10,068 7/1/2017 unknown unknown 7 City of Temecula N/C 8 City of Cathedral City N/C _ 9 City of Indio N/C 10 City of San Marcos N/C 11 City of Palm Springs N/C 12 City of Indian Wells N/C 13 City of Dana Point N/C Summary -esu s Top Monthly Total Monthly Average of Comparators $7,774 $10,852 %City of Palm Desert Above/Below 23.9% 21.7% Median of Comparators $7,952 $10,908 %City of Palm Desert Above/Below 22.1% 21.3% 70th Percentile of Comparators $7,957 $11,098 %City of Palm Desert Above/Below 22.1% 19.9% Number of Matches 5 5 N/C-Non Comparator 1-City of Coachella:Requires an Associate's degree. 2-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 Page 28a of 37 Appendix II City of Palm Desert Benefit Detail May 2018 City of Palm ity of Cathedral City o ity of Rancho City of San City of Agency ity of Indio ity of La Quinta ,• •• -, City of Redlands Desert City Coache Springs Mirage Marcos Temecula Benchmark/Comparator Project ■ Construction Code Special Projects Project Manager Agency Match Manager N/C Project N/C N/C N/C Administration N/C Engineer Project Manager II N/C N/C Coordinator Coordinator Top Monthly $10,210 $7,070 $8,124 $7,958 $7,767 $7,952 Salary _ Classic ,455 2%@60 2%@60 2%@60 2%@60 2%@55 Enhanced Formula $276 $106 $122 $119 $117 $215 Cost _ ER Paid Member Contrib c Calc Classic EPMC d E as Spec Comp 2 re Single Highest Year $40 Social Security $493 Deferred $190 $108 $72 Compensation Other Ret. Cafeteria $1,668 $516 Health $1,817 $1,828 $1,817 $397 u Dental $169 $86 $203 m Vision $21 $12 $40 m Life $17 $14 $16 LTD $16 $26 $40 $58 STD/SDI $9 $31 $94 Other Ins. y Vacation $435 $469 $551 $448 $306 aaa Holidays _ $408 $312 $367 $388 $401 Admin Leave $156 $122 $90 $459 Auto 2.998 $0 $0 $0 $ FINE Page 28b of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Total Monthly Compensation May 2018 Project Mana•er Total Salary Next Top Monthly Benefits Next Salary Comparator Agency Classification TitleMIL Salary Package Monthly Effective Increase Percentage Comp Date Increase City of Palm Desert Project Manager —=itsliki1iim '"— """" wn unknown 2 City of Poway Special Projects Engineer $7,958 $3,331 $11,289 7/1/2017 7/1/2018 2.00% 3 City of Rancho Mirage' Project Manager $7,767 $3,379 $11,146 7/1/2017 7/1/2018 1.5% 4 City of La Quinta Code Administration Coordinator(Construction $8,124 $2,784 $10,908 6/26/2017 unknown unknown 5 City of Redlands Project Manager II $7,952 $2,898 $10,850 7/1/2016 unknown unknown 6 City of Coachella' Construction Project Coordinator $7,070 $2,998 $10,068 7/1/2017 unknown unknown 7 City of Temecula N/C 8 City of Cathedral City N/C 9 City of Indio N/C 10 City of San Marcos N/C 11 City of Palm Springs N/C 12 City of Indian Wells N/C 13 City of Dana Point N/C Summary Results TO/IMMII Total Month! Average of Comparators $7,774 $10,852 City of Palm Desert Above/Below 23.9% 21.7% Median of Comparators $7,952 $10,908 City of Palm Desert Above/Below 22.1% 21.3% 70th Percentile of Comparators $7,957 $11,098 City of Palm Desert Above/Below 22.1% 19.9% Number of Matches 5 5 N/C-Non Comparator 1-City of Coachella:Requires an Associate's degree. 2-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 Page 28c of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Top Monthly Salary May 2018 Public Works Inspector II F Total Salary ' omparator Agency Classification Title ala Package Monthly Effectiv Increase 'ercen a. Comp Date Increase 1 City of Palm Desert Public Works Inspector II $8,587 $3,218 $11,805 unknown unknown unknown 2 City of Indio Public Works Inspector II $7,580 $3,229 $10,809 4/13/2017 unknown unknown 3 City of San Marcos Public Works Inspector $6,732 $3,429 $10,161 7/1/2017 7/1/2018 unknown 4 City of Rancho Mirage' Public Works Inspector $6,710 $3,160 $9,869 _ 7/1/2017 7/1/2018 _ 1.5% 5 City of Redlands Construction Inspector II $6,564 $2,186 $8,750 7/1/2016 unknown unknown 6 City of Poway Engineering Inspector $6,174 $2,702 $8,876 7/1/2017 7/1/2018 2.00% 7 City of La Quinta Code Administration Specialist(Public Works Inspector) I $5,799 $2,369 $8,168 6/26/2017 unknown _ unknown 8 City of Cathedral City N/C 9 City of Palm Springs N/C _ 10 City of Temecula N/C 11 City of Coachella N/C 12 City of Indian Wells N/C 13 City of Dana Point N/C ummary Results Total Monthly Average of Comparators $6,593 $9,439 %City of Palm Desert Above/Below 23.2% 20.0% Median of Comparators $6,637 $9,372 %City of Palm Desert Above/Below 22.7% 20.6% 70th Percentile of Comparators $6,721 $10,015 %City of Palm Desert Above/Below 21.7% 15.2% Number of Matches 6 6 N/C-Non Comparator 1-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 Page 29a of 37 Appendix II City of Palm Desert Benefit Detail May 2018 City of Palm ity of Cathedral City o City of San City of Agency Desert City Coache ity of Indio ity of La Quints Springs of Poway Mirage C Marcos Temecula Benchmark/Comparator Public Works Public Works Code Engineering Public Works Construction Public Works Agency Match Inspector II N/C N/C N/C N/C Inspector II Administration N/C Inspector Inspector Inspector II Inspector N/C Specialist(Public _ Top Monthly Salary $8,587 I $7,580 $5,799 $6,174 $6,710 $6,564 $6,732 Classic 2%@55 2.7%@55 2%@60 2%@60 2%@60 2%@55 2%@55 Enhanced Formula • 232 $485 $87 $93 $101 $177 $182 Cost ER Paid Member Contrib _ C. Calc Classic EPMC d E as Spec Comp 2 re Single Highest Year $33 Social Security $470 $407 $417 Deferred $108 Compensation Other Ret. Cafeteria $1,400 $1,668 $503 $100 Health $1,828 $1,817 $397 $1,949 u Dental $86 $203 m Vision $12 $40 m Life $9 $11 $16 $23 LTD $49 $26 $31 $58 $19 STD/SDI I $31 $94 $14 Other Ins. y Vacation' $437 $335 $356 $387 $252 $388 agar Holidays — $379 $223 $285 $335 $417 $337 Admin Leave Auto I ,,. arME $0 $0 $0 $3.229 $2. ' .702 $3,160 $2,186 $3,429 $0 N/C-Non Comparator 1-City of Palm Springs:City offers general leave that includes vacation and sick leave combined. Page 29b of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Total Monthly Compensation May 2018 Public Works Ins•ector II Top Monthly Benefits Total Salary Next Salary Next • ator Agency Classification Title Salary Package Monthly Effective Increase Percentage Comp Date Increase City of Palm Desert Public Works Inspector II $8,587 $3,218 $11,805 unknown unknown unknown 2 City of Indio Public Works Inspector II $7,580 $3,229 $10,809 4/13/2017 unknown unknown 3 City of San Marcos Public Works Inspector $6,732 $3,429 $10,161 7/1/2017 7/1/2018 unknown 4 City of Rancho Mirage' Public Works Inspector $6,710 $3,160 $9,869 7/1/2017 7/1/2018 1.5% 5 City of Poway Engineering Inspector $6,174 $2,702 $8,876 7/1/2017 7/1/2018 2.00% 6 City of Redlands Construction Inspector II $6,564 $2,186 $8,750 7/1/2016 unknown unknown 7 City of La Quinta Code Administration Specialist(Public Works Inspector) $5,799 $2,369 $8,168 6/26/2017 unknown unknown 8 City of Cathedral City N/C 9 City of Palm Springs N/C 10 City of Temecula N/C 11 City of Coachella N/C 12 City of Indian Wells N/C 13 City of Dana Point N/C Summary Results Top Monthly Total Monthly Average of Comparators $6,593 $9,439 %City of Palm Desert Above/Below 23.2% 20.0% Median of Comparators $6,637 $9,372 %City of Palm Desert Above/Below 22.7% 20.6% 70th Percentile of Comparators $6,721 $10,015 %City of Palm Desert Above/Below 21.7% 15.2% Number of Matches 6 6 N/C-Non Comparator 1-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 Page 29c of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Top Monthly Salary May 2018 Risk Mana•er Sala Comparator Agency Classification Title kage ont ly Effective Increase -ercen age Comp Date Increase 1 City of Palm Desert Risk Manager 14,453 unknown unknown unknown 2 City of Temecula Risk Manager $10,618 $4,222 $14,840 7/1/2017 7/1/2019 unknown 3 City of Palm Springs N/C 4 City of Poway N/C 5 City of Indian Wells N/C 6 City of Redlands N/C 7 City of Rancho Mirage N/C 8 City of Dana Point N/C 9 City of La Quinta N/C 10 City of Cathedral City N/C 11 City of Coachella N/C 12 City of Indio N/C 13 City of San Marcos N/C mmary Results Mo Total Monthly Average of Comparators ISD ISD City of Palm Desert Above/Below ISD ISD Median of Comparators ISD ISD City of Palm Desert Above/Below ISD ISD 70th Percentile of Comparators ISD ISD City of Palm Desert Above/Below ISD ISD Number of Matches 1 1 N/C-Non Comparator Page 30a of 37 Appendix II City of Palm Desert Benefit Detail May 2018 • City of Palm ity of Cathedral City o City of San City of Agency Desert City Coache ity of Indio ity of La Quinta Springy - dlands Marcos Temecula Benchmark/Comparator Risk Manager N/C N/C N/C N/C N/C N/C N/C N/C N/C N/C N/C Risk Manager Agency Match 1Top Monthly I $10,618 Salary _ Classic 2%@60 Enhanced Formula $159 Cost • ER Paid Member $743 Contrib • Calc Classic EPMC Eas Spec Comp $52 re Single Highest Year Social Security Deferred Compensation Other Ret. $-319 Cafeteria $1,200 Health Dental s Vision m Life • LTD STD/SDI Other Ins. $400 y Vacation $1,189 Holidays $490 Admin Leave $306 Auto 122E2=15 MEM Page 30b of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Total Monthly Compensation May 2018 Risk Mana.er Top Month! -nefits Total Salary Next Sala Next k Comparator Agency assification Title Monthly Effective 'ercentage Salary ckage Increas Corn. Date crease 1 City of Temecula Risk Manager 5 10.618 5 4.222 $144840 7/1/2017 7/1/2019 unknown rt -r 3 City of Palm Springs N/C 4 City of Poway N/C 5 City of Indian Wells N/C 6 City of Redlands N/C 7 City of Rancho Mirage N/C 8 City of Dana Point N/C 9 City of La Quinta N/C 10 City of Cathedral City N/C 11 City of Coachella N/C 12 City of Indio N/C 13 City of San Marcos N/C Average of Comparators ISD ISD City of Palm Desert Above/Below ISD ISD Median of Comparators ISD ISD City of Palm Desert Above/Below ISD ISD 70th Percentile of Comparators ISD ISD City of Palm Desert Above/Below ISD ISD Number of Matches 1 1 N/C-Non Comparator Page 30c of 37 Appendix II City of Palm Desert Market Compensation -Sorted by Top Monthly Salary May 2018 Senior En•ineer Top Monthly Benefits Total Salary Next Salary Next Rank Comparator Agency Classification Title Monthly Effectivej Jim Percentage Sala �ckajimu Comp Date crease kncrease 1 City of Temecula3 Senior Civil Engineer $ 11,875 $4,532 $ 16,407 7/1/2017 7/1/2019 unknown 2 Cit of Dana Point Senior Civil Engineer 11 125 3 514 14 639 10 1 2017 unknown unknown Illy of Palm Desert - Senior Engineer In $ 10,726 $3,696 $ 14,422 unkniMn unknown 4 City of Palm Springs Civil Engineer, Senior $ 10,610 $ 3,937 $ 14,547 6/18/2017 unknown unknown 5 City of San Marcos Senior Engineer $ 10,579 $4,218 $ 14,797 7/1/2017 7/1/2018 unknown 6 City of Poway2 Senior Civil Engineer $ 10,571 $ 3,729 $ 14,301 7/1/2017 7/1/2018 2.00% 7 City of Rancho Mirage Senior Civil Engineer $9,913 $ 3,743 $ 13,656 7/1/2017 7/1/2018 1.5% 8 City of Indio Senior Engineer $9,630 $ 3,721 $ 13,352 4/13/2017 unknown unknown 9 City of Coachella1 Senior Civil Engineer $9,568 $ 3,711 $ 13,278 7/1/2017 unknown unknown 10 City of Redlands Senior Civil Engineer $9,042 $ 3,160 $ 13,656 7/1/2016 unknown unknown 11 City of Cathedral City N/C 12 City of La Quinta N/C 13 City of Indian Wells N/C MEI=. Top Monthly Average of Comparators $ 10,324 $ 14,293 %City of Palm Desert Above/Below 3.8% 0.9% Median of Comparators $ 10,571 $ 14,301 %City of Palm Desert Above/Below 1.4% 0.8% 70th Percentile of Comparators $ 10,598 $ 14,602 %City of Palm Desert Above/Below 1.2% -1.2% Number of Matches 9 9 N/C-Non Comparator 1 -City of Coachella: No Land Surveyor certification required. 2-City of Poway: Professional Land Surveyor registration desired. 3-City of Temecula: Land Surveyor certificate of registration desired. Page 31a of 37 Appendix II City of Palm Desert Benefit Detail May 2018 City of Palm ity of Cathedral City o City of Rancho City of San City of Agency Desert City Coache Point ity of Indio ity of La Quints Springs o •oway Mirage City of Redlands Marcos Temecula Benchmark/Comparator Senior Senior Civil Senior Civil Civil Engineer, Senior Civil Senior Civil Senior Civil Senior Civil N/C N/C Senior Engineer N/C Senior Engineer AgencyMatch Engineer Engineer Engineer Senior Engineer Engineer Engineer Engineer Top Monthly $10,726 $9,568 $11,125 $9,630 $10,610 $10,571 $9,913 $9,042 $10,579 $11,875 Salary - Classic o@55 2%@60 2%@55 2.7%@55 2%@60 2%@60 2%@60 2%@55 2%@55 2%@60 Enhanced Formula $290 $144 $300 $616 $159 $159 $149 $244 $286 $178 Cost ER Paid Member $831 Contrib _ C. Calc Classic EPMC E as Spec Comp $58 re Single Highest Year $56 $45 Social Security $597 $561 $656 Deferred $190 $108 $72 Compensation Other Ret. $-356 Cafeteria $1,275 $1,400 $2,011 $516 $100 $1,200 Health $1,817 $1,828 $1,817 $397 $1,949 u Dental $169 $86 $203 m Vision $21 $12 $40 m Life $17 $9 $12 $19 $16 $37 LTD $21 $62 $122 $53 $58 $29 STD/SDI $13 $94 $23 Other Ins. $400 y Vacation $589 $1,284 $556 $1,102 $732 $572 $348 $610 $1,330 aaa Holidays _ $552 $599 $482 $531 $488 $496 $456 $529 $548 Admin Leave $368 $163 $191 $522 I $343 Auto $3,711 $3,514 $0 $3,721 $0 $3,937 $3,729 $3,743 $3,160 $ Page 31b of 37 Appendix II City of Palm Desert Market Compensation -Sorted by Total Monthly Compensation May 2018 Senior En•ineer Top Monthly Benefits Total Salary Next Salary Next Rank Comparator Agency Classification Title Salary Package Monthly Effective Increase Percentage _ Comp Date Increase 1 City of Temecula3 Senior Civil Engineer $ 11,875 $4,532 $ 16,407 7/1/2017 7/1/2019 unknown 2 City of San Marcos Senior Engineer $ 10,579 $4,218 $ 14,797 7/1/2017 7/1/2018 unknown 3 City of Dana Point Senior Civil Engineer $ 11,125 $ 3,514 $ 14,639 10/1/2017 unknown unknown 4 City of Palm Springs Civil Engineer, Senior $ 10,610 $ 3,937 $ 14,547 6/18/2017 unknown unknown IIUMNno 6 City of Poway' Senior Civil Engineer $ 10,571 $ 3,729 $ 14,301 7/1/2017 7/1/2018 2.00% 7 City of Rancho Mirage Senior Civil Engineer $9,913 $ 3,743 $ 13,656 7/1/2017 7/1/2018 1.5% 8 City of Redlands Senior Civil Engineer $9,042 $ 3,160 $ 13,656 7/1/2016 unknown unknown 9 City of Indio Senior Engineer $9,630 $ 3,721 $ 13,352 4/13/2017 unknown unknown 10 City of Coachella' Senior Civil Engineer $9,568 $ 3,711 $ 13,278 7/1/2017 unknown unknown 11 City of Cathedral City N/C 12 City of La Quinta N/C 13 City of Indian Wells N/C ummary Results . • H • , i Total Monthly Average of Comparators $ 10,324 $ 14,293 %City of Palm Desert Above/Below 3.8% 0.9% Median of Comparators $ 10,571 $ 14,301 %City of Palm Desert Above/Below 1.4% 0.8% 70th Percentile of Comparators $ 10,598 $ 14,602 %City of Palm Desert Above/Below 1.2% -1.2% Number of Matches 9 9 N/C-Non Comparator 1 -City of Coachella: No Land Surveyor certification required. 2-City of Poway: Professional Land Surveyor registration desired. 3-City of Temecula: Land Surveyor certificate of registration desired. Page 31c of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Top Monthly Salary May 2018 Senior Management Anal st •tal Salary ' omp. . •r Agency Classification Title ala Packa 'onthly Effectiv Increase -ercen age Comp Date Increase 1 City of Palm Desert Senior Management Analyst $10,210 $3,646 $13,856 unknown unknown unknown 2 City of Temecula Senior Management Analyst $9,506 $3,947 $13,453 7/1/2017 7/1/2019 unknown 3 City of Dana Point Senior Management Analyst $8,656 $3,017 $11,673 10/1/2017 unknown unknown 4 City of Indio Senior Management Analyst $8,585 $3,470 $12,055 4/13/2017 unknown unknown 5 City of Rancho Mirage' Senior Management Analyst $8,563 $3,387 $11,950 7/1/2017 7/1/2018 1.5% 6 City of San Marcos Senior Management Analyst $8,170 $3,889 $12,059 7/1/2017 unknown unknown 7 City of Poway Senior Management Analyst $7,957 $3,330 $11,288 7/1/2017 7/1/2018 2.00% 8 City of Cathedral City Senior Administrative Analyst $7,135 $3,237 $10,372 1/14/2018 unknown unknown 9 City of Coachella N/C 10 City of La Quinta N/C 11 City of Palm Springs N/C 12 City of Redlands N/C 13 City of Indian Wells N/C mmary Results Top Monthly Total Monthly Average of Comparators $8,367 $11,836 %City of Palm Desert Above/Below 18.0% 14.6% Median of Comparators $8,563 $11,950 %City of Palm Desert Above/Below 16.1% 13.8% 70th Percentile of Comparators $8,599 $12,056 %City of Palm Desert Above/Below 15.8% 13.0% Number of Matches 7 7 N/C-Non Comparator 1-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 Page 32a of 37 Appendix II City of Palm Desert Benefit Detail May 2018 City of Palm ity of Cathedral City o City of Rancho City of San City of Agency Desert City Coache Point ity of Indio rty of La Quinta Springs ay Mirage City of Redlands Marcos Temecula Benchmark/Comparator Senior Senior Senior Senior Senior Senior Senior Senior Agency Match Management Administrative N/C Management N/C Management N/C N/C Management Management N/C Management Management Analyst Analyst Analyst Analyst Analyst Analyst Analyst Analyst Top Monthly $10,210 $7,135 $8,656 $8,585 $7,957 $8,563 $8,170 $9,506 Salary _ Classic o@55 2%@60 2%@55 2.7%@55 2%@60 2%@60 2%@55 2%@60 Enhanced Formula $276 $107 $234 $549 $119 $128 $221 $143 Cost ER Paid Member $499 $665 Contrib C. Calc Classic EPMC E as Spec Comp $35 $47 re Single Highest Year $43 Social Security $532 $507 Deferred 1110 $208 $190 $108 Compensation Other Ret. $-642 $-285 Cafeteria $1,911 $1,275 $1,400 $108 $1,200 Health $1,828 $1,817 $1,949 u Dental $86 $203 m Vision $12 $40 m Life $31 $9 $14 $16 $28 LTD _ $17 $55 $40 $58 $23 STD/SDI $94 $17 Other Ins. $400 y Vacation' $576 $999 $495 $551 $494 $471 $1,065 agar Holidays — $494 $466 $429 $367 $428 $408 $439 Admin Leave $122 $157 i $274 Auto �.. $0 $3.017 $0 $3.470 $3.330 $3.387 $0 $3. N/C-Non Comparator 1-City of Dana Point:City offers comprehensive leave that includes vacation and sick leave combined. Page 32b of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Total Monthly Compensation May 2018 Senior Management Anal st Top Monthly Benefits Total Salary Next Salary Next Agency Classification Title Salary Package Monthly Effective Increase Percentage Comp Date Increase City of Palm Desert Senior Management Analyst $10,210 $3,646 $13,856 unknown unknown unknown 2 City of Temecula Senior Management Analyst $9,506 $3,947 $13,453 7/1/2017 7/1/2019 unknown 3 City of San Marcos Senior Management Analyst $8,170 $3,889 $12,059 7/1/2017 unknown unknown 4 City of Indio Senior Management Analyst $8,585 $3,470 $12,055 4/13/2017 unknown unknown 5 City of Rancho Mirage' Senior Management Analyst $8,563 $3,387 $11,950 7/1/2017 7/1/2018 1.5% 6 City of Dana Point Senior Management Analyst $8,656 $3,017 $11,673 10/1/2017 unknown unknown 7 City of Poway Senior Management Analyst $7,957 $3,330 $11,288 7/1/2017 7/1/2018 2.00% 8 City of Cathedral City Senior Administrative Analyst $7,135 $3,237 $10,372 1/14/2018 unknown unknown 9 City of Coachella N/C 10 City of La Quinta N/C 11 City of Palm Springs N/C 12 City of Redlands N/C 13 City of Indian Wells N/C Summary Results Top Monthly Total Monthly Average of Comparators $8,367 $11,836 City of Palm Desert Above/Below 18.0% 14.6% Median of Comparators $8,563 $11,950 City of Palm Desert Above/Below 16.1% 13.8% 70th Percentile of Comparators $8,599 $12,056 City of Palm Desert Above/Below 15.8% 13.0% Number of Matches 7 7 N/C-Non Comparator 1-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 Page 32c of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Top Monthly Salary May 2018 Streets Maintenance Su•ervisor Total Salary ' om•. . . -.ency Classification Title a Package Monthly Effectiv= crease -ercentage Comp i Date Increase 1 City of Palm Desert Streets Maintenance Supervisor $9,248 $3,490 $12,738 i unknown unknown unknown 2 City of Temecula Maintenance Supervisor $8,829 $3,780 $12,609 7/1/2017 7/1/2019 unknown 3 City of Indio Street Maintenance Supervisor $8,587 $3,471 $12,057 4/13/2017 unknown unknown 4 City of Palm Springs Streets Maintenance Superintendent $8,496 $3,555 $12,051 6/18/2017 unknown unknown 5 City of Indian Wells Public Works Field Supervisor $8,318 $4,854 $13,171 unknown unknown unknown 6 City of San Marcos Street Maintenance Supervisor $7,635 $3,623 $11,258 7/1/2017 7/1/2018 unknown 7 City of Cathedral City Public Works Supervisor $7,492 $3,293 $10,785 1/14/2018 unknown unknown 8 City of Poway Construction Maintenance Supervisor $6,694 $2,994 $9,688 7/1/2017 7/1/2018 2.00% 9 City of Rancho Mirage' Street Maintenance Supervisor $6,390 $3,120 $9,510 7/1/2017 7/1/2018 1.5% 10 City of Coachella' Streets Supervisor $6,358 $3,145 $9,503 _ 7/1/2017 unknown unknown 11 City of Redlands Field Services Supervisor $6,201 $2,477 $8,678 7/1/2016 unknown unknown 12 City of La Quinta N/C 13 City of Dana Point N/C ummary Results - Monthly Total Monthly Average of Comparators $7,500 $10,931 %City of Palm Desert Above/Below 18.9% 14.2% Median of Comparators $7,563 $11,021 %City of Palm Desert Above/Below 18.2% 13.5% 70th Percentile of Comparators $8,371 $12,053 %City of Palm Desert Above/Below 9.5% 5.4% Number of Matches 10 10 N/C-Non Comparator 1-City of Coachella:No class description available. 2-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 Page 33a of 37 Appendix II City of Palm Desert Benefit Detail May 2018 City of Palm ity of Cathedral City o City of San City of Agency ity of Indio ity of La Quinta Desert City Coache Wells Springs Marcos Temecula Streets Street Streets Construction Street Street Benchmark/Comparator Public Works Streets Public Works Field Services Maintenance Agency Match Maintenance N/C Maintenance N/C Maintenance Maintenance Maintenance Maintenance 9 y Supervisor Supervisor Supervisor Supervisor Field Supervisor Supervisor Superintendent Supervisor Supervisor Supervisor Supervisor Top Monthly $9,248 $7,492 $6,358 $8,318 $8,587 $8,496 $6,694 $6,390 $6,201 $7,635 $8,829 Salary _ Classic o@55 2%@60 2%@60 2.75%@55 2.7%@55 2%@60 2%@60 2%@60 2%@55 2&@%5 2%@60 Enhanced Formula $250 $112 $95 $532 $550 $127 $100 $96 $167 $206 $132 Cost ER Paid Member $524 $618 Contrib _ _ C. Calc Classic EPMC E as Spec Comp $37 $43 re Single Highest Year $50 $31 Social Security' $1,031 $532 $384 $473 Deferred IIIII $208 $208 $149 $108 $72 Compensation _ Other Ret. _ _ $-674 — _ _ $-265 Cafeteria _ _ _ $1,911 $83 $1,400 _ $2,011 $516 $108 $1,200 Health $1,817 $1,734 $1,828 $1,817 $397 $1,949 u Dental $169 $141 $86 $203 m Vision $21 $36 $12 $40 m Life $32 $17 $13 $9 $12 $12 $16 $27 LTD _ $18 $14 $66 $55 $98 $33 $58 $21 STD/SDI $9 $32 $94 $16 Other Ins. $400 y Vacation' $605 $391 $512 $495 $882 $463 $369 $238 $440 $989 re, Holidays _ $519 $367 $416 $429 $425 $309 $320 $313 $382 $407 Admin Leave $245 $358 1 $255 Auto I EL $3,145 $0 $4.854 $3.471 'MIT.- .994 $3.120 $2.477 MEM N/C-Non Comparator 1-City of Indian Wells:City pays employer portion of Social Security.City reimburses employees for employee portion of Social Security benefits. 2-City of Palm Springs:City offers annual leave that includes vacation and sick leave combined. Page 33b of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Total Monthly Compensation May 2018 Streets Maintenance Su.ervisor op Mont Benefit Total Salary Next ,ext Salary cy Classification Tit- Sala Packa. Monthly Effective crease Percentage Com. Date Increase 1 City of Indian Wells Public Works Field Supervisor S 8.318 S 4.854 S 13.171 unknown unknown unknown IL s s i 3 City of Temecula Maintenance Supervisor $8,829 $3,780 $12,609 7/1/2017 7/1/2019 unknown 4 City of Indio Street Maintenance Supervisor $8,587 $3,471 $12,057 4/13/2017 unknown unknown 5 City of Palm Springs Streets Maintenance Superintendent $8,496 $3,555 $12,051 6/18/2017 unknown unknown 6 City of San Marcos Street Maintenance Supervisor $7,635 $3,623 $11,258 7/1/2017 7/1/2018 unknown 7 City of Cathedral City Public Works Supervisor $7,492 $3,293 $10,785 1/14/2018 unknown unknown 8 City of Poway Construction Maintenance Supervisor $6,694 $2,994 $9,688 7/1/2017 7/1/2018 2.00% 9 City of Rancho Mirage' Street Maintenance Supervisor $6,390 $3,120 $9,510 7/1/2017 7/1/2018 1.5% 10 City of Coachella' Streets Supervisor $6,358 $3,145 $9,503 7/1/2017 unknown unknown 11 City of Redlands Field Services Supervisor $6,201 $2,477 $8,678 7/1/2016 unknown unknown 12 City of La Quinta N/C 13 City of Dana Point N/C Summary Results Mr TopMonthly 'on y Average of Comparators $7,500 $10,931 %City of Palm Desert Above/Below 18.9% 14.2% Median of Comparators $7,563 $11,021 %City of Palm Desert Above/Below 18.2% 13.5% 70th Percentile of Comparators $8,371 $12,053 %City of Palm Desert Above/Below 9.5% 5.4% Number of Matches 10 10 N/C-Non Comparator 1-City of Coachella:No class description available. 2-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 Page 33c of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Top Monthly Salary May 2018 Su.ervisin. Plans Examiner ala Next ' ompara or Agency Classification Title Salary ackag n y ective Increase Percentage Comp Date .1crease 1 City of Palm Desert Supervising Plans Examiner $9,248 IMP$3,490 $12,738 unknown11..inknown 2 City of Indio Senior Plans Examiner $9,162 $3,609 $12,771 4/13/2017 unknown unknown 3 City of San Marcos Senior Plans Examiner $7,848 $3,666 $11,515 7/1/2017 7/1/2018 unknown 4 City of Redlands Senior Plans Examiner $7,718 $2,842 $10,560 7/1/2016 unknown unknown 5 City of La Quinta Code Administration Supervisor(Plans Examiner-Building Inspection $6,865 $2,487 $9,353 6/26/2017 unknown unknown Supervisor) 6 City of Rancho Mirage N/C 7 City of Poway N/C 8 City of Indian Wells N/C 9 City of Dana Point N/C 10 City of Palm Springs N/C 11 City of Cathedral City N/C 12 City of Temecula N/C 13 City of Coachella N/C Summary esu is Top Monthly Total Monthly Average of Comparators $7,898 $11,050 %City of Palm Desert Above/Below 14.6% 13.3% Median of Comparators $7,783 $11,037 %City of Palm Desert Above/Below 15.8% 13.4% 70th Percentile of Comparators $7,980 $11,640 %City of Palm Desert Above/Below 13.7% 8.6% Number of Matches 4 4 N/C-Non Comparator Page 34a of 37 Appendix II City of Palm Desert Benefit Detail May 2018 Agency City of Palm ity of Cathedral City o ity of Indio ity of La Quints o •oway City of Rancho City of Redlands City of San City of Desert City Coache Spring Mirage Marcos Temecula Benchmark/Comparator upervising Senior Plans Code Senior Plans Senior Plans Agency Match •lans Examiner N/C N/C N/C N/C Examiner Administration N/C N/C N/C Examiner Examiner N/C Supervisor(Plans Top Monthly $g 248 I $9,162 $6,865 $7,718 $7,848 Salary — Classic 2%@55 2.7%@55 2%@60 2%@55 2&@%5 Enhanced Formula • 250 $586 $103 $208 $212 Cost ER Paid Member Contrib C. Calc Classic EPMC d E as Spec Comp 2 re Single Highest Year $39 Social Security $568 $479 $487 Deferred Compensation $72 Other Ret. Cafeteria $1,400 $1,668 _ $516 $108 Health $397 $1,949 u Dental m Vision Life $9 $27 LTD $59 $26 $22 STD/SDI _ $31 $17 Other Ins. y Vacation $529 $396 $297 $453 aaa Holidays _ $458 $264 $390 $392 Admin Leave $445 Auto $0 $3.609 $2.487 $0 $2.842 $3.666 $0 Page 34b of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Total Monthly Compensation May 2018 Su.ervisin. Plans Examiner Total Salary Next p Monthly Benefits Next Salary Agency Classification Title Salary Package Monthly Effective Increase Percentage Comp Date Increase City of Palm Desert Supervising Plans Examiner • 2 City of Indio Senior Plans Examiner $9,162 $3,609 $12,771 4/13/2017 unknown unknown 3 City of San Marcos Senior Plans Examiner $7,848 $3,666 $11,515 7/1/2017 7/1/2018 unknown 4 City of Redlands Senior Plans Examiner $7,718 $2,842 $10,560 7/1/2016 unknown unknown 5 City of La Quinta Code Administration Supervisor(Plans Examiner-Building Inspection $6,865 $2,487 $9,353 6/26/2017 unknown unknown Supervisor) 6 City of Rancho Mirage N/C 7 City of Poway N/C 8 City of Indian Wells N/C 9 City of Dana Point N/C 10 City of Palm Springs N/C 11 City of Cathedral City N/C 12 City of Temecula N/C 13 City of Coachella N/C • Summary Results Top Monthly al onthly Average of Comparators $7,898 $11,050 %City of Palm Desert Above/Below 14.6% 13.3% Median of Comparators $7,783 $11,037 %City of Palm Desert Above/Below 15.8% 13.4% 70th Percentile of Comparators $7,980 $11,640 %City of Palm Desert Above/Below 13.7% 8.6% Number of Matches 4 4 N/C-Non Comparator Page 34c of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Top Monthly Salary May 2018 Tourism and Marketin. Mana.er -al. ext ompara or gency Classification Title active Increase entage Dat 1 City of Indian Wells' [Director of Marketing and Community Services/ $11,021 $6,132 $17,153 unknown unknown unknown Management Analyst] i of Palm Desed• ism and Marketing Manager $10,72;• $3,727 $14,453 unk 3 City of Cathedral City Communication-Events Manager $8,673 $3,478 $12,150 1/14/2018 unknown unknown 4 City of La Quinta N/C 5 City of Redlands N/C 6 City of Palm Springs N/C 7 City of Poway N/C 8 City of Rancho Mirage N/C 9 City of Dana Point N/C 10 City of Temecula N/C 11 City of Coachella N/C 12 City of Indio N/C 13 City of San Marcos N/C Summary Results Top Monthly Total Average of Comparators ISD ISD City of Palm Desert Above/Below ISO ISD Median of Comparators ISD ISD City of Palm Desert Above/Below ISO ISD 70th Percentile of Comparators ISD ISD City of Palm Desert Above/Below ISO ISD Number of Matches 2 2 N/C-Non Comparator 1-City of Indian Wells:Span of Responsibility Match:This hybrid match represents that the duties are bridged by a higher and lower level classification at the comparator agency. The salary displayed is an average of the matches. Page 35a of 37 Appendix II City of Palm Desert Benefit Detail May 2018 t City of Palm ity of Cathedral City o ity of In. y of Rancho City. Agency Desert City Coach= Wells ity of Indio - ^• - Spring- Mirage City of Redlands Marcos Tourism and [Dir of Mktg& Benchmark/Comparator Marketing Communication- N/C N/C Community N/C N/C N/C N/C N/C N/C N/C N/C Agency Match Events Manager Services/Mgmt Analyst] Top Monthly 0,72 $8,673 $11,021 Salary Classic 2%@55 2%@60 2.75%@S5 _ _ Enhanced Formula $290 $130 $705 Cost ER Paid Member $607 Contrib Calc Classic EPMC m E as Spec Comp $43 m re Single Highest Year $66 Social Security' $1,327 Deferred Compensation $208 $276 Other Ret. $-781 Cafeteria $1,911 $83 Health $1,734 u Dental $141 m Vision $36 8 Life $37 $13 LTD $21 $66 _ _ _ _ _ STD/SDI A $32 Other Ins. Js Vacation Ell $700 Admin Leave .r r ®-------- 'Auto I I I I I I I I I I I I I MEN. aki1261 ill MIXINI N/C-Non Comparator 1-City of Indian Wells:City pays employer portion of Social Security.City reimburses employees for employee portion of Social Security benefits. Page 35b of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Total Monthly Compensation May 2018 Tourism and Marketing Mana er Top Month' Benefits Total Sala Next Salary Next Classification Titl= Salary Package Monthly Effective Increase Percentage Comp Date Increase 1 City of Indian Wells' [Director of Marketing and Community Services/ $11,021 $6,132 $17,153 unknown unknown unknown Management Analyst] City of Palm Desert MI Tourism and Marketing Manager $10,726 $3,727 $14,453 unknown unknown unknown 3 City of Cathedral City Communication-Events Manager $8,673 $3,478 $12,150 1/14/2018 unknown unknown 4 City of La Quinta N/C 5 City of Redlands N/C 6 City of Palm Springs N/C 7 City of Poway N/C 8 City of Rancho Mirage N/C 9 City of Dana Point N/C 10 City of Temecula N/C 11 City of Coachella N/C 12 City of Indio N/C 13 City of San Marcos N/C Top Monthly o a Monthly Average of Comparators ISD ISD City of Palm Desert Above/Below ISD ISD Median of Comparators ISD ISD City of Palm Desert Above/Below ISD ISD 70th Percentile of Comparators ISD ISD City of Palm Desert Above/Below ISD ISD Number of Matches 2 2 N/C-Non Comparator 1-City of Indian Wells:Span of Responsibility Match:This hybrid match represents that the duties are bridged by a higher and lower level classification at the comparator agency. The salary displayed is an average of the matches. Page 35c of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Top Monthly Salary May 2018 Traffic Si.nal Technician II p- Total Salary ' ompara or Agency Classification Title Sala Package Monthly Effectiv ncrease •ercen a. Comp Date Increase 1 City of Palm Desert Traffic Signal Technician II $8,172 $3,159 $11,331 unknown unknown unknown 2 City of Indio Traffic Signal Technician II $6,527 $2,976 $9,503 4/13/2017 unknown unknown 3 City of Rancho Mirage' Traffic Signal Technician II $6,390 $3,120 $9,510 7/1/2017 7/1/2018 1.5% 4 City of San Marcos Traffic Signal-Lighting Technician $6,351 $3,351 $9,702 7/1/2017 7/1/2018 unknown 5 City of La Quinta Maintenance&Operations Technician(Traffic Signal Technician) $5,025 $2,283 $7,308 6/26/2017 unknown unknown 6 City of Redlands Traffic Signal Technician II $3,952 $1,674 $5,626 7/1/2016 unknown unknown 7 City of Poway N/C _ 8 City of Indian Wells N/C 9 City of Dana Point N/C 10 City of Palm Springs N/C 11 City of Cathedral City N/C 12 City of Temecula N/C 13 City of Coachella N/C mmary Results Top Monthly Total Monthly Average of Comparators $5,649 $8,330 %City of Palm Desert Above/Below 30.9% 26.5% Median of Comparators $6,351 $9,503 %City of Palm Desert Above/Below 22.3% 16.1% 70th Percentile of Comparators $6,382 $9,509 %City of Palm Desert Above/Below 21.9% 16.1% Number of Matches 5 5 N/C-Non Comparator 1-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 Page 36a of 37 Appendix II City of Palm Desert Benefit Detail May 2018 Agency City of Palm ity of Cathedral City o ity of Indio ity of La Quints o •oway Cit • - . Desert City Coache Spring Mirage Maintenance& Traffic Signal- Benchmark/Comparator ra'is Signal Traffic Signal Traffic Signal Traffic Signal Agency Match Technician II N/C N/C N/C N/C Technician II Operations N/C N/C Technician II Technician II Lighting N/C Technician Technician Top Monthly I $6,527 $5,025 $6,390 $3,952 $6,351 Salary _ Classic 2.7%@55 2%@60 2%@60 2%@55 2%@55 Enhanced Formula $418 $75 $96 $107 $171 Cost ER Paid Member Contrib C. Calc Classic EPMC d E as Spec Comp 2 re Single Highest Year $20 Social Security $405 $245 $394 Deferred $108 Compensation Other Ret. Cafeteria $1,400 $1,668 _ $503 $100 Health $1,817 $397 $1,949 u Dental $203 m Vision . $40 m Life $9 $16 $22 LTD $42 $26 $58 $18 STD/SDI _ $31 _ $94 $14 Other Ins. y Vacation $377 $290 $369 $152 $366 aaa Holidays _ $326 $193 $320 $251 $318 Admin Leave Auto $0 $2,976 $2,283 $0 $3,120 $1,674 $3.351 $0 Page 36b of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Total Monthly Compensation May 2018 Traffic Si.nal Technician II 11=111cop Monthly Benefits Total Salary Next Salary Next • ator Agency Classification Title Salary Package Monthly Effective Increase Percentage .... I. - City of Palm Desert Traffic Signal Technician II 2 City of San Marcos Traffic Signal-Lighting Technician $6,351 $3,351 $9,702 7/1/2017 7/1/2018 unknown 3 City of Rancho Mirage' Traffic Signal Technician II $6,390 $3,120 $9,510 7/1/2017 7/1/2018 1.5% 4 City of Indio Traffic Signal Technician II $6,527 $2,976 $9,503 4/13/2017 unknown unknown 5 City of La Quinta Maintenance&Operations Technician(Traffic Signal Technician) $5,025 $2,283 $7,308 6/26/2017 unknown unknown 6 City of Redlands Traffic Signal Technician II $3,952 $1,674 $5,626 7/1/2016 unknown unknown 7 City of Poway N/C 8 City of Indian Wells N/C 9 City of Dana Point N/C 10 City of Palm Springs N/C 11 City of Cathedral City N/C 12 City of Temecula N/C 13 City of Coachella N/C Summary Results Top Monthly o y Average of Comparators $5,649 $8,330 %City of Palm Desert Above/Below 30.9% 26.5% Median of Comparators $6,351 $9,503 %City of Palm Desert Above/Below 22.3% 16.1% 70th Percentile of Comparators $6,382 $9,509 %City of Palm Desert Above/Below 21.9% 16.1% Number of Matches 5 5 N/C-Non Comparator 1-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 Page 36c of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Top Monthly Salary May 2018 Transportation En.ineer -al., ext omparator Agency Classification Title ectiv- ercentage rease Increase 1 City of Temecula Senior Civil Engineer $11,875 $4,532 $16,407 7/1/2017 7/1/2019 unknown 2 City of Dana Point Senior Civil Engineer-Traffic $11,125 $3,514 $14,639 10/1/2017 unknown unknown Transportation Engineer 3 76: 14 761 unknown . ..... 4 City of San Marcos Senior Engineer $10,579 $4,218 $14,797 7/1/2017 7/1/2018 unknown 5 City of Rancho Mirage' Senior Civil Engineer $9,913 $3,743 $13,656 7/1/2017 7/1/2018 1.5% 6 City of Indio Senior Engineer $9,630 $3,721 $13,352 4/13/2017 unknown unknown 7 City of Redlands Civil Engineer $7,642 $2,824 $10,466 7/1/2016 unknown unknown 8 City of Coachella N/C 9 City of Cathedral City N/C 10 City of La Quinta N/C 11 City of Palm Springs N/C 12 City of Indian Wells N/C 13 City of Poway N/C mmary Results Top Monthly Average of Comparators $10,127 $13,886 %City of Palm Desert Above/Below 7.9% 5.9% Median of Comparators $10,246 $14,147 %City of Palm Desert Above/Below 6.8% 4.2% 70th Percentile of Comparators $10,852 $14,718 %City of Palm Desert Above/Below 1.3% 0.3% Number of Matches 6 6 N/C-Non Comparator 1-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 Page 37a of 37 Appendix II City of Palm Desert Benefit Detail May 2018 City of Palm ity of Cathedral City o City of Rancho City of San City of Agency Desert City Coache Point ity of Indio ity of La Quinta Spring ° °way Mirage City of Redlands Marcos Temecula Benchmark/Comparator ransportation Senior Civil Senior Civil Senior Civil Agency Match Engineer N/C N/C Engineer-Traffic N/C Senior Engineer N/C N/C N/C Engineer Civil Engineer Senior Engineer Engineer Top Monthly $10,993 $11,125 $9,630 $9,913 $7,642 $10,579 $11,875 Salary Classic 2%@55 2%@55 2.7%@55 2%@60 2%@55 2%@55 2%@60 Enhanced Formula • 297 $300 $616 $149 $206 $286 $178 Cost ER Paid Member $831 Contrib _ C. Calc Classic EPMC E as Spec Comp $58 re Single Highest Year $56 $38 Social Security $597 $474 $656 Deferred Compensation $108 $72 Other Ret. $-356 Cafeteria $1,275 $1,400 _ $516 $100 $1,200 Health $1,817 $397 $1,949 u Dental $203 m Vision _ $40 m Life $9 $16 $37 LTD $62 $58 $29 STD/SDI _ $94 $23 Other Ins. $400 y Vacation' $1,284 $556 $572 $294 $610 $1,330 agar Holidays _ $599 $482 $496 $386 $529 $548 Admin Leave $191 $441 1 $343 Auto 0 $3.514 $0 $3,721 $0 $3,743 $2,824 $ N/C-Non Comparator 1-City of Dana Point City offers comprehensive leave that includes vacation and sick leave combined. Page 37b of 37 Appendix II City of Palm Desert Market Compensation-Sorted by Total Monthly Compensation May 2018 Trans.ortation En.ineer Top Monthly Benefits Total Salar��ext Salary Next • parator Agency Classification Title Salary Packag Monthly ffective Increase Percentage Comp ate Increase 1 City of Temecula Senior Civil Engineer $11,875 $4,532 $16,407 7/1/2017 7/1/2019 unknown City of Palm—Mrt portation Engineer $10,993 ===. nown il nown 3 City of San Marcos Senior Engineer S 10.579 S 4.218 5 14.797 7/1/2017 7/1/2018 unknown 4 City of Dana Point Senior Civil Engineer-Traffic $11,125 $3,514 $14,639 10/1/2017 unknown unknown 5 City of Rancho Mirage' Senior Civil Engineer $9,913 $3,743 $13,656 7/1/2017 7/1/2018 1.5% 6 City of Indio Senior Engineer $9,630 $3,721 $13,352 4/13/2017 unknown unknown 7 City of Redlands Civil Engineer $7,642 $2,824 $10,466 7/1/2016 unknown unknown 8 City of Coachella N/C 9 City of Cathedral City N/C 10 City of La Quinta N/C 11 City of Palm Springs N/C 12 City of Indian Wells N/C 13 City of Poway N/C Summary Results Top Monthly tal onthly Average of Comparators $10,127 $13,886 City of Palm Desert Above/Below 7.9% 5.9% Median of Comparators $10,246 $14,147 City of Palm Desert Above/Below 6.8% 4.2% 70th Percentile of Comparators $10,852 $14,718 City of Palm Desert Above/Below 1.3% 0.3% Number of Matches 6 6 N/C-Non Comparator 1-City of Rancho Mirage:All salaries reflect employees hired between January 1,2012 and July 26,2013 Page 37c of 37 Kit Total Compensation Study - Final Report City of Palm Desert Appendix III Proposed Salary Range Schedule Appendix Ill City of Palm Desert Proposed Salary Plan May 2018 Classification I Salary Range II Step 1 I Step 2 I Step 3 I Step 4 I Step 5 I Step 6 I Step 7 I Step 8 1 Annual 25,981 27,280 28,644 30,077 31,580 33,159 34,320 35,658 Monthly 2,165 2,273 2,387 2,506 2,632 2,763 2,860 2,972 Hourly 12.49 13.12 13.77 14.46 15.18 15.94 16.50 17.14 2 Annual 26,631 27,962 29,360 30,828 32,370 33,988 35,178 36,550 Monthly 2,219 2,330 2,447 2,569 2,697 2,832 2,932 3,046 Hourly 12.80 13.44 14.12 14.82 15.56 16.34 16.91 17.57 3 Annual 27,297 28,661 30,094 31,599 33,179 34,838 36,057 37,464 Monthly 2,275 2,388 2,508 2,633 2,765 2,903 3,005 3,122 Hourly 13.12 13.78 14.47 15.19 15.95 16.75 17.34 18.01 4 Annual 27,979 29,378 30,847 32,389 34,009 35,709 36,959 38,400 Monthly 2,332 2,448 2,571 2,699 2,834 2,976 3,080 3,200 Hourly 13.45 14.12 14.83 15.57 16.35 17.17 17.77 18.46 5 Annual 28,678 30,112 31,618 33,199 34,859 36,602 37,883 39,360 Monthly 2,390 2,509 2,635 2,767 2,905 3,050 3,157 3,280 Hourly 13.79 14.48 15.20 15.96 16.76 17.60 18.21 18.92 6 Annual 29,395 30,865 32,408 34,029 35,730 37,517 38,830 40,344 Monthly 2,450 2,572 2,701 2,836 2,978 3,126 3,236 3,362 Hourly 14.13 14.84 15.58 16.36 17.18 18.04 18.67 19.40 7 Annual 30,130 31,637 33,219 34,880 36,624 38,455 39,801 41,353 Monthly 2,511 2,636 2,768 2,907 3,052 3,205 3,317 3,446 Hourly 14.49 15.21 15.97 16.77 17.61 18.49 19.13 19.88 8 Annual 30,884 32,428 34,049 35,752 37,539 39,416 40,796 42,387 Monthly 2,574 2,702 2,837 2,979 3,128 3,285 3,400 3,532 Hourly 14.85 15.59 16.37 17.19 18.05 18.95 19.61 20.38 9 Annual 31,656 33,238 34,900 36,645 38,478 40,402 41,816 43,446 Monthly 2,638 2,770 2,908 3,054 3,206 3,367 3,485 3,621 Hourly 15.22 15.98 16.78 17.62 18.50 19.42 20.10 20.89 10 Annual 32,447 34,069 35,773 37,562 39,440 41,412 42,861 44,533 Monthly 2,704 2,839 2,981 3,130 3,287 3,451 3,572 3,711 Hourly 15.60 16.38 17.20 18.06 18.96 19.91 20.61 21.41 11 Annual 33,258 34,921 36,667 38,501 40,426 42,447 43,933 45,646 Monthly 2,772 2,910 3,056 3,208 3,369 3,537 3,661 3,804 Hourly 15.99 16.79 17.63 18.51 19.44 20.41 21.12 21.95 12 Annual 34,090 35,794 37,584 39,463 41,436 43,508 45,031 46,787 Monthly 2,841 2,983 3,132 3,289 3,453 3,626 3,753 3,899 Hourly 16.39 17.21 18.07 18.97 19.92 20.92 21.65 22.49 13 Annual 34,942 36,689 38,523 40,450 42,472 44,596 46,157 47,957 Monthly 2,912 3,057 3,210 3,371 3,539 3,716 3,846 3,996 Hourly 16.80 17.64 18.52 19.45 20.42 21.44 22.19 23.06 Office Specialist I 14 Annual 35,815 37,606 39,487 41,461 43,534 45,711 47,310 49,156 Monthly 2,985 3,134 3,291 3,455 3,628 3,809 3,943 4,096 Hourly 17.22 18.08 18.98 19.93 20.93 21.98 22.75 23.63 15 Annual 36,711 38,546 40,474 42,497 44,622 46,853 48,493 50,384 Monthly 3,059 3,212 3,373 3,541 3,719 3,904 4,041 4,199 Hourly 17.65 18.53 19.46 20.43 21.45 22.53 23.31 24.22 16 Annual 37,629 39,510 41,486 43,560 45,738 48,025 49,706 51,644 Monthly 3,136 3,293 3,457 3,630 3,811 4,002 4,142 4,304 Hourly 18.09 19.00 19.94 20.94 21.99 23.09 23.90 24.83 17 Annual 38,569 40,498 42,523 44,649 46,881 49,225 50,948 52,935 Monthly 3,214 3,375 3,544 3,721 3,907 4,102 4,246 4,411 Hourly 18.54 19.47 20.44 21.47 22.54 23.67 24.49 25.45 Office Specialist II 18 Annual 39,534 41,510 43,586 45,765 48,053 50,456 52,222 54,259 Monthly 3,294 3,459 3,632 3,814 4,004 4,205 4,352 4,522 Hourly 19.01 19.96 20.95 22.00 23.10 24.26 25.11 26.09 Maintenance Worker I 19 Annual 40,522 42,548 44,675 46,909 49,255 51,717 53,527 55,615 Monthly 3,377 3,546 3,723 3,909 4,105 4,310 4,461 4,635 Hourly 19.48 20.46 21.48 22.55 23.68 24.86 25.73 26.74 Page 1 of 4 Appendix III City of Palm Desert Proposed Salary Plan May 2018 Classification I Salary Range II Step 1 I Step 2 I Step 3 I Step 4 I Step 5 I Step 6 I Step 7 I Step 8 20 Annual 41,535 43,612 45,792 48,082 50,486 53,010 54,866 57,005 Monthly 3,461 3,634 3,816 4,007 4,207 4,418 4,572 4,750 Hourly 19.97 20.97 22.02 23.12 24.27 25.49 26.38 27.41 21 Annual 42,573 44,702 46,937 49,284 51,748 54,336 56,237 58,431 Monthly 3,548 3,725 3,911 4,107 4,312 4,528 4,686 4,869 Hourly 20.47 21.49 22.57 23.69 24.88 26.12 27.04 28.09 22 Annual 43,638 45,820 48,111 50,516 53,042 55,694 57,643 59,891 Monthly 3,636 3,818 4,009 4,210 4,420 4,641 4,804 4,991 Hourly 20.98 22.03 23.13 24.29 25.50 26.78 27.71 28.79 Maintenance Worker II 23 Annual 44,729 46,965 49,313 51,779 54,368 57,086 59,084 61,389 Monthly 3,727 3,914 4,109 4,315 4,531 4,757 4,924 5,116 Hourly 21.50 22.58 23.71 24.89 26.14 27.45 28.41 29.51 24 Annual 45,847 48,139 50,546 53,073 55,727 58,513 60,561 62,923 Monthly 3,821 4,012 4,212 4,423 4,644 4,876 5,047 5,244 Hourly 22.04 23.14 24.30 25.52 26.79 28.13 29.12 30.25 25 Annual 46,993 49,343 51,810 54,400 57,120 59,976 62,075 64,496 Monthly 3,916 4,112 4,317 4,533 4,760 4,998 5,173 5,375 Hourly 22.59 23.72 24.91 26.15 27.46 28.83 29.84 31.01 26 Annual 48,168 50,576 53,105 55,760 58,548 61,476 63,627 66,109 Monthly 4,014 4,215 4,425 4,647 4,879 5,123 5,302 5,509 Hourly 23.16 24.32 25.53 26.81 28.15 29.56 30.59 31.78 Code Compliance Officer I 27 Annual 49,372 51,841 54,433 57,154 60,012 63,013 65,218 67,762 Maintenance Worker III Monthly 4,114 4,320 4,536 4,763 5,001 5,251 5,435 5,647 Hourly 23.74 24.92 26.17 27.48 28.85 30.29 31.35 32.58 Accounting Technician 28 Annual 50,606 53,137 55,793 58,583 61,512 64,588 66,848 69,456 Management Specialist I Monthly 4,217 4,428 4,649 4,882 5,126 5,382 5,571 5,788 Traffic Signal Technician I Hourly 24.33 25.55 26.82 28.16 29.57 31.05 32.14 33.39 29 Annual 51,871 54,465 57,188 60,048 63,050 66,203 68,520 71,192 Monthly 4,323 4,539 4,766 5,004 5,254 5,517 5,710 5,933 Hourly 24.94 26.19 27.49 28.87 30.31 31.83 32.94 34.23 Public Works Inspector I 30 Annual 53,168 55,827 58,618 61,549 64,626 67,858 70,233 72,972 Monthly 4,431 4,652 4,885 5,129 5,386 5,655 5,853 6,081 Hourly 25.56 26.84 28.18 29.59 31.07 32.62 33.77 35.08 Building Inspector I 31 Annual 54,497 57,222 60,083 63,088 66,242 69,554 71,989 74,796 Code Compliance Officer II Monthly 4,541 4,769 5,007 5,257 5,520 5,796 5,999 6,233 Senior Maintenance Worker Hourly 26.20 27.51 28.89 30.33 31.85 33.44 34.61 35.96 Accounting Specialist 32 Annual 55,860 58,653 61,586 64,665 67,898 71,293 73,788 76,666 Management Specialist II Monthly 4,655 4,888 5,132 5,389 5,658 5,941 6,149 6,389 Traffic Signal Technician II Hourly 26.86 28.20 29.61 31.09 32.64 34.28 35.48 36.86 33 Annual 57,256 60,119 63,125 66,281 69,596 73,075 75,633 78,583 Monthly 4,771 5,010 5,260 5,523 5,800 6,090 6,303 6,549 Hourly 27.53 28.90 30.35 31.87 33.46 35.13 36.36 37.78 Landscape Specialist 34 Annual 58,688 61,622 64,703 67,938 71,335 74,902 77,524 80,547 Public Works Inspector II Monthly 4,891 5,135 5,392 5,662 5,945 6,242 6,460 6,712 Hourly 28.22 29.63 31.11 32.66 34.30 36.01 37.27 38.72 Building Inspector II 35 Annual 60,155 63,163 66,321 69,637 73,119 76,775 79,462 82,561 Executive Assistant Monthly 5,013 5,264 5,527 5,803 6,093 6,398 6,622 6,880 Hourly 28.92 30.37 31.89 33.48 35.15 36.91 38.20 39.69 Assistant Planner 36 Annual 61,659 64,742 67,979 71,378 74,947 78,694 81,448 84,625 Plans Examiner Monthly 5,138 5,395 5,665 5,948 6,246 6,558 6,787 7,052 Hourly 29.64 31.13 32.68 34.32 36.03 37.83 39.16 40.69 37 Annual 63,200 66,360 69,678 73,162 76,820 80,661 83,485 86,741 Monthly 5,267 5,530 5,807 6,097 6,402 6,722 6,957 7,228 Hourly 30.38 31.90 33.50 35.17 36.93 38.78 40.14 41.70 Deputy City Clerk 38 Annual 64,780 68,019 71,420 74,991 78,741 82,678 85,572 88,909 Engineering Assistant Monthly 5,398 5,668 5,952 6,249 6,562 6,890 7,131 7,409 Horticulturist Hourly 31.14 32.70 34.34 36.05 37.86 39.75 41.14 42.74 Traffic Signal Specialist Page 2 of 4 Appendix III City of Palm Desert Proposed Salary Plan May 2018 Classification I Salary Range II Step I I Step 2 I Step 3 I Step 4 I Step 5 I Step 6 Step 7 I Step 8 39 Annual 66,400 69,720 73,206 76,866 80,709 84,745 87,711 91,132 Monthly 5,533 5,810 6,100 6,406 6,726 7,062 7,309 7,594 Hourly 31.92 33.52 35.20 36.95 38.80 40.74 42.17 43.81 Accountant 40 Annual 68,060 71,463 75,036 78,788 82,727 86,864 89,904 93,410 Associate Planner Monthly 5,672 5,955 6,253 6,566 6,894 7,239 7,492 7,784 GIS Administrator Hourly 32.72 34.36 36.08 37.88 39.77 41.76 43.22 44.91 Information Systems Administrator Management Analyst 41 Annual 69,761 73,249 76,912 80,758 84,795 89,035 92,151 95,745 Monthly 5,813 6,104 6,409 6,730 7,066 7,420 7,679 7,979 Hourly 33.54 35.22 36.98 38.83 40.77 42.81 44.30 46.03 42 Annual 71,505 75,081 78,835 82,776 86,915 91,261 94,455 98,139 Monthly 5,959 6,257 6,570 6,898 7,243 7,605 7,871 8,178 Hourly 34.38 36.10 37.90 39.80 41.79 43.88 45.41 47.18 43 Annual 73,293 76,958 80,806 84,846 89,088 93,543 96,817 100,592 Monthly 6,108 6,413 6,734 7,070 7,424 7,795 8,068 8,383 Hourly 35.24 37.00 38.85 40.79 42.83 44.97 46.55 48.36 Assistant Engineer 44 Annual 75,125 78,882 82,826 86,967 91,315 95,881 99,237 103,107 Deputy City Treasurer Monthly 6,260 6,573 6,902 7,247 7,610 7,990 8,270 8,592 Project Coordinator Hourly 36.12 37.92 39.82 41.81 43.90 46.10 47.71 49.57 Senior Financial Analyst Senior Management Analyst 45 Annual 77,004 80,854 84,896 89,141 93,598 98,278 101,718 105,685 Monthly 6,417 6,738 7,075 7,428 7,800 8,190 8,476 8,807 Hourly 37.02 38.87 40.82 42.86 45.00 47.25 48.90 50.81 Code Compliance Supervisor 46 Annual 78,929 82,875 87,019 91,370 95,938 100,735 104,261 108,327 Facilities Manager Monthly 6,577 6,906 7,252 7,614 7,995 8,395 8,688 9,027 Landscape Supervisor Hourly 37.95 39.84 41.84 43.93 46.12 48.43 50.13 52.08 Street Maintenance Supervisor Supervising Plans Examiner 47 Annual 80,902 84,947 89,194 93,654 98,337 103,253 106,867 111,035 Monthly 6,742 7,079 7,433 7,804 8,195 8,604 8,906 9,253 Hourly 38.90 40.84 42.88 45.03 47.28 49.64 51.38 53.38 Associate Engineer 48 Annual 82,924 87,071 91,424 95,995 100,795 105,835 109,539 113,811 Principal Planner Monthly 6,910 7,256 7,619 8,000 8,400 8,820 9,128 9,484 Project Manager Hourly 39.87 41.86 43.95 46.15 48.46 50.88 52.66 54.72 49 Annual 84,997 89,247 93,710 98,395 103,315 108,481 112,278 116,656 Monthly 7,083 7,437 7,809 8,200 8,610 9,040 9,356 9,721 Hourly 40.86 42.91 45.05 47.31 49.67 52.15 53.98 56.08 Risk Manager 50 Annual 87,122 91,479 96,052 100,855 105,898 111,193 115,084 119,573 Tourism and Marketing Manager Monthly 7,260 7,623 8,004 8,405 8,825 9,266 9,590 9,964 Hourly 41.89 43.98 46.18 48.49 50.91 53.46 55.33 57.49 51 Annual 89,300 93,765 98,454 103,376 108,545 113,973 117,962 122,562 Monthly 7,442 7,814 8,204 8,615 9,045 9,498 9,830 10,214 Hourly 42.93 45.08 47.33 49.70 52.19 54.79 56.71 58.92 Senior Engineer 52 Annual 91,533 96,110 100,915 105,961 111,259 116,822 120,911 125,626 Senior Engineer/City Surveyor Monthly 7,628 8,009 8,410 8,830 9,272 9,735 10,076 10,469 Transportation Engineer Hourly 44.01 46.21 48.52 50.94 53.49 56.16 58.13 60.40 53 Annual 93,821 98,512 103,438 108,610 114,040 119,742 123,933 128,767 Monthly 7,818 8,209 8,620 9,051 9,503 9,979 10,328 10,731 Hourly 45.11 47.36 49.73 52.22 54.83 57.57 59.58 61.91 54 Annual 96,167 100,975 106,024 111,325 116,891 122,736 127,032 131,986 Monthly 8,014 8,415 8,835 9,277 9,741 10,228 10,586 10,999 Hourly 46.23 48.55 50.97 53.52 56.20 59.01 61.07 63.45 55 Annual 98,571 103,500 108,675 114,108 119,814 125,804 130,208 135,286 Monthly 8,214 8,625 9,056 9,509 9,984 10,484 10,851 11,274 Hourly 47.39 49.76 52.25 54.86 57.60 60.48 62.60 65.04 56 Annual 101,035 106,087 111,391 116,961 122,809 128,949 133,463 138,668 Monthly 8,420 8,841 9,283 9,747 10,234 10,746 11,122 11,556 Hourly 48.57 51.00 53.55 56.23 59.04 61.99 64.16 66.67 Page 3 of 4 Appendix Ill City of Palm Desert Proposed Salary Plan May 2018 Classification I Salary Range II Step 1 I Step 2 I Step 3 I Step 4 I Step 5 I Step 6 I Step 7 I Step 8 57 Annual 103,561 108,739 114,176 119,885 125,879 132,173 136,799 142,134 Monthly 8,630 9,062 9,515 9,990 10,490 11,014 11,400 11,845 Hourly 49.79 52.28 54.89 57.64 60.52 63.54 65.77 68.33 58 Annual 106,150 111,458 117,031 122,882 129,026 135,478 140,219 145,688 Monthly 8,846 9,288 9,753 10,240 10,752 11,290 11,685 12,141 Hourly 51.03 53.59 56.26 59.08 62.03 65.13 67.41 70.04 Assistant Finance Director 59 Annual 108,804 114,244 119,956 125,954 132,252 138,864 143,725 149,330 Information Systems Manager Monthly 9,067 9,520 9,996 10,496 11,021 11,572 11,977 12,444 Hourly 52.31 54.93 57.67 60.55 63.58 66.76 69.10 71.79 60 Annual 111,524 117,100 122,955 129,103 135,558 142,336 147,318 153,063 Monthly 9,294 9,758 10,246 10,759 11,297 11,861 12,276 12,755 Hourly 53.62 56.30 59.11 62.07 65.17 68.43 70.83 73.59 61 Annual 114,312 120,028 126,029 132,331 138,947 145,894 151,001 156,890 Monthly 9,526 10,002 10,502 11,028 11,579 12,158 12,583 13,074 Hourly 54.96 57.71 60.59 63.62 66.80 70.14 72.60 75.43 City Clerk 62 Annual 117,170 123,028 129,180 135,639 142,421 149,542 154,776 160,812 City Engineer Monthly 9,764 10,252 10,765 11,303 11,868 12,462 12,898 13,401 Director of Building and Safety Hourly 56.33 59.15 62.11 65.21 68.47 71.90 74.41 77.31 Director of Economic Development 63 Annual 120,099 126,104 132,409 139,030 145,981 153,280 158,645 164,832 Monthly 10,008 10,509 11,034 11,586 12,165 12,773 13,220 13,736 Hourly 57.74 60.63 63.66 66.84 70.18 73.69 76.27 79.25 Director of Administrative Services 64 Annual 123,102 129,257 135,720 142,506 149,631 157,112 162,611 168,953 Director of Community Development Monthly 10,258 10,771 11,310 11,875 12,469 13,093 13,551 14,079 Hourly 59.18 62.14 65.25 68.51 71.94 75.53 78.18 81.23 65 Annual 126,179 132,488 139,113 146,068 153,372 161,040 166,677 173,177 Monthly 10,515 11,041 11,593 12,172 12,781 13,420 13,890 14,431 Hourly 60.66 63.70 66.88 70.23 73.74 77.42 80.13 83.26 66 Annual 129,334 135,800 142,590 149,720 157,206 165,066 170,844 177,506 Monthly 10,778 11,317 11,883 12,477 13,100 13,756 14,237 14,792 Hourly 62.18 65.29 68.55 71.98 75.58 79.36 82.14 85.34 67 Annual 132,567 139,195 146,155 153,463 161,136 169,193 175,115 181,944 Monthly 11,047 11,600 12,180 12,789 13,428 14,099 14,593 15,162 Hourly 63.73 66.92 70.27 73.78 77.47 81.34 84.19 87.47 68 Annual 135,881 142,675 149,809 157,299 165,164 173,423 179,492 186,493 Monthly 11,323 11,890 12,484 13,108 13,764 14,452 14,958 15,541 Hourly 65.33 68.59 72.02 75.62 79.41 83.38 86.29 89.66 Director of Finance/City Treasurer 69 Annual 139,278 146,242 153,554 161,232 169,294 177,758 183,980 191,155 Director of Public Works Monthly 11,607 12,187 12,796 13,436 14,108 14,813 15,332 15,930 Hourly 66.96 70.31 73.82 77.52 81.39 85.46 88.45 91.90 70 Annual 142,760 149,898 157,393 165,263 173,526 182,202 188,579 195,934 Monthly 11,897 12,492 13,116 13,772 14,460 15,184 15,715 16,328 Hourly 68.63 72.07 75.67 79.45 83.43 87.60 90.66 94.20 71 Annual 146,329 153,646 161,328 169,394 177,864 186,757 193,294 200,832 Monthly 12,194 12,804 13,444 14,116 14,822 15,563 16,108 16,736 Hourly 70.35 73.87 77.56 81.44 85.51 89.79 92.93 96.55 72 Annual 149,987 157,487 165,361 173,629 182,311 191,426 198,126 205,853 Monthly 12,499 13,124 13,780 14,469 15,193 15,952 16,511 17,154 Hourly 72.11 75.71 79.50 83.48 87.65 92.03 95.25 98.97 73 Annual 153,737 161,424 169,495 177,970 186,868 196,212 203,079 210,999 Monthly 12,811 13,452 14,125 14,831 15,572 16,351 16,923 17,583 Hourly 73.91 77.61 81.49 85.56 89.84 94.33 97.63 101.44 74 Annual 157,581 165,460 173,733 182,419 191,540 201,117 208,156 216,274 Monthly 13,132 13,788 14,478 15,202 15,962 16,760 17,346 18,023 Hourly 75.76 79.55 83.53 87.70 92.09 96.69 100.08 103.98 75 Annual 161,520 169,596 178,076 186,980 196,329 206,145 213,360 221,681 Monthly 13,460 14,133 14,840 15,582 16,361 17,179 17,780 18,473 Hourly 77.65 81.54 85.61 89.89 94.39 99.11 102.58 106.58 Page 4 of 4 Total Compensation Study - Final Report City of Palm Desert Appendix IV Salary Range Placement Recommendations Appendix IV City of Palm Desert Proposed Range Placement Recommendations May 2018 Current Classification Title Proposed Classification Title Current Salary Current Market Proposed Salary Proposed Percent Rationale Range Maximum Placement-Top Range Maximum Difference Monthly Salary Monthly Salary Monthly Salary 70th Percentile Clerical Assistant Office Specialist I 90 $4,083 N/A 14 $4,096 0.33% Internal alignment:10%below Office Specialist II. Customer Service Clerk Office Specialist II 87 $2,972 $4,533 18 $4,522 52.16% Market and range placement. Clerical Assistant Office Specialist II 90 $4,083 $4,533 18 $4,522 10.75% Market and range placement. Clerical Assistant Office Specialist II 90 $4,083 $4,533 18 $4,522 10.75% Market and range placement. Clerical Assistant Office Specialist II 90 $4,083 $4,533 18 $4,522 10.75% Market and range placement. Clerical Assistant Office Specialist II 90 $4,083 $4,533 18 $4,522 10.75% Market and range placement. Office Assistant I Office Specialist II 100 $5,244 $4,533 18 $4,522 -13.77% Market and range placement. Office Assistant II Office Specialist II 104 $5,785 $4,533 18 $4,522 -21.84% Market and range placement. Office Assistant II Office Specialist II 104 $5,785 $4,533 18 $4,522 -21.84% Market and range placement. Office Assistant II Office Specialist II 104 $5,785 $4,533 18 $4,522 -21.84% Market and range placement. Office Assistant II Office Specialist II 104 $5,785 $4,533 18 $4,522 -21.84% Market and range placement. Laborer Maintenance Worker I 87 $2,972 N/A 19 $4,635 55.97% Internal alignment:10%below Maintenance Worker II. Maintenance Worker I Maintenance Worker II 101 $5,376 $5,129 23 $5,116 -4.85% Market and range placement. Maintenance Worker I Maintenance Worker II 101 $5,376 $5,129 23 $5,116 -4.85% Market and range placement. Maintenance Worker I Maintenance Worker II 101 $5,376 $5,129 23 $5,116 -4.85% Market and range placement. Maintenance Worker I Maintenance Worker II 101 $5,376 $5,129 23 $5,116 -4.85% Market and range placement. Code Compliance Officer I Code Compliance Officer I 107 $6,230 N/A 27 $5,647 -9.37% Internal alignment:10%below Code Compliance Officer II. Code Compliance Officer I Code Compliance Officer I 107 $6,230 N/A 27 $5,647 -9.37% Internal alignment:10%below Code Compliance Officer II. Maintenance Worker II Maintenance Worker III 106 $6,075 N/A 27 $5,647 -7.05% Internal alignment:10%above Maintenance Worker II. Equipment Operator I Maintenance Worker III 109 $6,547 N/A 27 $5,647 -13.75% Internal alignment:10%above Maintenance Worker II. _Equipment Operator I Maintenance Worker III 109 $6,547 N/A 27 $5,647 -13.75% Internal alignment:10%above Maintenance Worker II. Equipment Operator I Maintenance Worker III 109 $6,547 N/A 27 $5,647 -13.75% Internal alignment:10%above Maintenance Worker II. Facilities Maintenance Technician Maintenance Worker III 114 $7,404 N/A 27 $5,647 -23.74% Internal alignment:10%above Maintenance Worker II. Accounting Technician Accounting Technician 118 $8,172 $5,640 28 $5,788 -29.17% Market and internal alignment:anchor to Management Specialist I. Accounting Technician Accounting Technician 118 $8,172 $5,640 28 $5,788 -29.17% Market and internal alignment:anchor to Management Specialist I. Clerical Assistant Management Specialist I 90 $4,083 N/A 28 $5,788 41.77% Internal alignment:10%below Management Specialist II. Senior Office Assistant Management Specialist I 107 $6,230 N/A 28 $5,788 -7.10% Internal alignment:10%below Management Specialist II. Senior Office Assistant Management Specialist I 107 $6,230 N/A 28 $5,788 -7.10% Internal alignment:10%below Management Specialist II. Traffic Signal Technician I Traffic Signal Technician I 111 $6,878 N/A 28 $5,788 -15.84% Internal alignment:10%below Traffic Signal Technician II. Public Works Inspector I Public Works Inspector I 118 $8,172 N/A 30 $6,081 -25.58% Internal alignment:10%below Public Works Inspector II. Building Inspector I Building Inspector I 107 $6,230 N/A 31 $6,233 0.04% Internal alignment:10%below Building Inspector II. Building Inspector Building Inspector I 114 $7,404 N/A 31 $6,233 -15.82% Internal alignment:10%below Building Inspector II. Code Compliance Officer I Code Compliance Officer II 114 $7,404 $6,274 31 $6,233 -15.82% Market and range placement. Code Compliance Officer II Code Compliance Officer II 118 $8,172 $6,274 31 $6,233 -23.72% Market and range placement. Senior Maintenance Worker Senior Maintenance Worker 111 $6,878 N/A 31 $6,233 -9.37% Internal alignment:10%above Maintenance Worker III. Senior Maintenance Worker Senior Maintenance Worker 111 $6,878 N/A 31 $6,233 -9.37% Internal alignment:10%above Maintenance Worker III. Accounting Technician Accounting Specialist 113 $7,224 N/A 32 $6,389 -11.56% Internal alignment:10%above Accounting Technician. Accounting Technician Accounting Specialist 118 $8,172 N/A 32 $6,389 -21.82% Internal alignment:10%above Accounting Technician. Accounting Technician Accounting Specialist 118 $8,172 N/A 32 $6,389 -21.82% Internal alignment:10%above Accounting Technician. Human Resources Specialist Management Specialist II 107 $6,230 $6,405 32 $6,389 2.54% Market and range placement. Permit Specialist I Management Specialist II 111 $6,878 $6,405 32 $6,389 -7.11% Market and range placement. Administrative Secretary Management Specialist II 113 $7,224 $6,405 32 $6,389 -11.56% Market and range placement. Administrative Secretary Management Specialist II 113 $7,224 $6,405 32 $6,389 -11.56% _Market and range placement. Administrative Secretary Management Specialist II 113 $7,224 $6,405 32 $6,389 -11.56% Market and range placement. Administrative Secretary Management Specialist II 113 $7,224 $6,405 32 $6,389 -11.56% Market and range placement. Administrative Secretary Management Specialist II 113 $7,224 $6,405 32 $6,389 -11.56% Market and range placement. Capital Improvement Projects Technician Management Specialist II 113 $7,224 $6,405 32 $6,389 -11.56% Market and range placement. Page 1 of 3 Appendix IV City of Palm Desert Proposed Range Placement Recommendations May 2018 Current Classification Title Proposed Classification Title Current Salary Current Market Proposed Salary Proposed Percent Rationale Range Maximum Placement-Top Range Maximum Difference Monthly Salary Monthly Salary Monthly Salary 70th Percentile Code Compliance Technician Management Specialist II 113 $7,224 $6,405 32 $6,389 -11.56% Market and range placement. Housing Programs Technician Management Specialist II 113 $7,224 $6,405 32 $6,389 -11.56% Market and range placement. Housing Programs Technician Management Specialist II 113 $7,224 $6,405 32 $6,389 -11.56% Market and range placement. _Public Art Technician Management Specialist II 113 $7,224 $6,405 32 $6,389 -11.56% Market and range placement. Records Technician Management Specialist II 113 $7,224 $6,405 32 $6,389 -11.56% Market and range placement. Economic Development Technician I Management Specialist II 114 $7,404 $6,405 32 $6,389 -13.72% Market and range placement. Tourism and Marketing Specialist Management Specialist II 114 $7,404 $6,405 32 $6,389 -13.72% Market and range placement. Traffic Signal Technician I Traffic Signal Technician II 111 $6,878 $6,382 32 $6,389 -7.11% Market and range placement. Traffic Signal Technician II Traffic Signal Technician II 118 $8,172 $6,382 32 $6,389 -21.82% Market and range placement. Landscape Inspector I Landscape Specialist 114 $7,404 $6,645 34 $6,712 -9.35% Market and range placement. Landscape Inspector II Landscape Specialist 118 $8,172 $6,645 34 $6,712 -17.86% Market and range placement. _Landscape Inspector II Landscape Specialist 118 $8,172 $6,645 34 $6,712 -17.86% Market and range placement. _Public Works Inspector II Public Works Inspector II 120 $8,587 $6,721 34 $6,712 -21.83% Market and range placement. Public Works Inspector II Public Works Inspector II 120 $8,587 $6,721 34 $6,712 -21.83% Market and range placement. _Public Works Inspector II Public Works Inspector II 120 $8,587 $6,721 34 $6,712 -21.83% Market and range placement. Building Inspector I Building Inspector II 111 $6,878 $6,826 35 $6,880 0.04% Market and range placement. Building Inspector II Building Inspector II 118 $8,172 $6,826 35 $6,880 -15.81% Market and range placement. Building Inspector II Building Inspector II 118 $8,172 $6,826 35 $6,880 -15.81% Market and range placement. Administrative Secretary Executive Assistant 113 $7,224 $6,826 35 $6,880 -4.76% Market and range placement. Assistant Planner Assistant Planner 118 $8,172 N/A 36 $7,052 -13.70% Internal alignment:10%below Associate Planner. Permit Specialist II Plans Examiner 115 $7,589 $7,041 36 $7,052 -7.08% Internal alignment:anchor to Building Inspector II and 20%below Supervising Plans Examiner. Deputy City Clerk Deputy City Clerk 118 $8,172 $7,400 38 $7,409 -9.33% Market and range placement. Assistant Engineer Engineering Assistant 125 $9,722 $7,417 38 $7,409 -23.79% Market and range placement. Landscape Specialist Horticulturist 121 $8,803 N/A 38 $7,409 -15.83% Internal alignment:10%above Landscape Specialist. Traffic Signal Specialist Traffic Signal Specialist 121 $8,803 N/A 38 $7,409 -15.83% Internal alignment:15%above Traffic Signal Technician II. Management Analyst II Accountant 123 $9,248 $8,026 40 $7,784 -15.83% Market and internal alignment:anchor to Management Analyst. Associate Planner Associate Planner 127 $10,210 $7,767 40 $7,784 -23.76% Market and range placement. Geographic Information System(GIS)Specialist GIS Administrator 114 $7,404 N/A 40 $7,784 5.13% Internal alignment:anchor to Information Systems Administrator. _Information Systems Technician Information Systems Administrator 114 $7,404 $7,631 40 $7,784 5.13% Market and internal alignment:anchor to Management Analyst. _Information Systems Technician Information Systems Administrator 114 $7,404 $7,631 40 $7,784 5.13% Market and internal alignment:anchor to Management Analyst. Management Analyst I Management Analyst 120 $8,587 N/A 40 $7,784 -9.35% Internal alignment:10%below Senior Management Analyst. _Management Analyst I Management Analyst 120 $8,587 N/A 40 $7,784 -9.35% Internal alignment:10%below Senior Management Analyst. Management Analyst II Management Analyst 123 $9,248 N/A 40 $7,784 -15.83% Internal alignment:10%below Senior Management Analyst. Assistant Engineer Assistant Engineer 125 $9,722 N/A 44 $8,592 -11.62% Internal alignment:10%below Associate Engineer. _Deputy City Treasurer Deputy City Treasurer 127 $10,210 ISD 44 $8,592 -15.85% Internal alignment:anchor to Senior Management Analyst. N/A Project Coordinator N/A N/A N/A 44 $8,592 N/A Internal alignment:10%below Project Manager. Senior Financial Analyst Senior Financial Analyst 127 $10,210 N/A 44 $8,592 -15.85% Internal alignment:anchor to Senior Management Analyst. Senior Management Analyst Senior Management Analyst 127 $10,210 $8,599 44 $8,592 -15.85% Market and range placement. Senior Management Analyst Senior Management Analyst 127 $10,210 $8,599 44 $8,592 -15.85% Market and range placement. Senior Management Analyst Senior Management Analyst 127 $10,210 $8,599 44 $8,592 -15.85% Market and range placement. Senior Management Analyst Senior Management Analyst 127 $10,210 $8,599 44 $8,592 -15.85% Market and range placement. Economic Development Manager Senior Management Analyst 134 $12,139 $8,599 44 $8,592 -29.22% Market and range placement. Code Compliance Supervisor Code Compliance Supervisor 123 $9,248 $8,449 46 $9,027 -2.39% Market and internal alignment:anchor to Landscape Supervisor,Facilities Supervisor,Streets Maintenance Supervisor,and Supervising Plans Examiner. Facilities Manager Facilities Manager 130 $10,993 $7,669 46 $9,027 -17.88% Market and internal alignment:anchor to Landscape Supervisor and Streets Maintenance Supervisor. Page 2 of 3 Appendix IV City of Palm Desert Proposed Range Placement Recommendations May 2018 Current Classification Title Proposed Classification Title Current Salary Current Market Proposed Salary Proposed Percent Rationale Range Maximum Placement-Top Range Maximum Difference Monthly Salary Monthly Salary Monthly Salary 70th Percentile Landscape Supervisor Landscape Supervisor 123 $9,248 $7,692 46 $9,027 -2.39% Market and internal alignment:20%above Horticulturist. Streets Maintenance Supervisor Streets Maintenance Supervisor 123 $9,248 $8,371 46 $9,027 -2.39% Market and internal alignment:anchor to Landscape Supervisor and Facilities Supervisor. Supervising Plans Examiner Supervising Plans Examiner 123 $9,248 $7,980 46 $9,027 -2.39% Market and internal alignment:anchor to Landscape Supervisor,Facilities Supervisor,Streets Maintenance Supervisor,and Code Compliance Supervisor. Associate Engineer Associate Engineer 127 $10,210 N/A 48 $9,484 -7.11% Internal alignment:10%below Senior Engineer. Principal Planner Principal Planner 131 $11,266 N/A 48 $9,484 -15.81% Internal alignment:20%above Associate Planner. Project Administrator Project Manager 127 $10,210 $7,957 48 $9,484 -7.11% Market and internal alignment:anchor to Associate Engineer. Risk Manager Risk Manager 129 $10,726 ISD 50 $9,964 -7.10% Internal alignment:15%above Senior Management Analyst. Tourism and Marketing Manager Tourism and Marketing Manager 129 $10,726 ISD 50 $9,964 -7.10% Internal alignment:anchor to Risk Manager. Senior Engineer Senior Engineer 129 $10,726 $10,598 52 $10,469 -2.40% Market and range placement. Senior Engineer/City Surveyor Senior Engineer/City Surveyor 130 $10,993 N/A 52 $10,469 -4.77% Internal alignment:anchor to Senior Engineer. Transportation Engineer Transportation Engineer 130 $10,993 $10,852 52 $10,469 -4.77% Market and internal alignment:anchor to Senior Engineer. Assistant Finance Director Assistant Finance Director 135 $12,438 N/A 59 $12,444 0.05% Internal alignment:anchor to Information Systems Manager. _Information Systems Manager Information Systems Manager 135 $12,438 $12,392 59 $12,444 0.05% Market and range placement. City Clerk City Clerk 139 $13,730 $12,146 62 $13,401 -2.40% Market and internal alignment:anchor to City Engineer. City Engineer City Engineer 139 $13,730 $13,770 62 $13,401 -2.40% Market and internal alignment:anchor to Director of Economic Development. Director of Building&Safety Director of Building&Safety 140 $14,073 $12,384 62 $13,401 -4.78% Market and internal alignment:anchor to Director of Economic Development. Director of Economic Development Director of Economic Development 137 $13,067 $13,483 62 $13,401 2.55% Market and range placement. Director of Administrative Services Director of Administrative Services 139 $13,730 $14,000 64 $14,079 2.54% Market and range placement. Director of Community Development Director of Community Development 142 $14,780 ISD 64 $14,079 -4.74% Internal alignment:anchor to Director of Administrative Services Director of Finance/City Treasurer Director of Finance/City Treasurer 145 $15,923 ISD 69 $15,930 0.04% Internal alignment:anchor to Director of Public Works/City Engineer. Director of Public Works Director of Public Works 145 $15,923 $15,819 69 $15,930 0.04% Market and range placement. Page 3 of 3 Total Compensation Study - Final Report City of Palm Desert Appendix V Additional Benefits Appendix V City of Palm Desert Additional Benefits May 2018 ity of Cathedral Cit Bargaining Unit Benefit AFSCME-General Unit $1,200 per fiscal year, not exceeding$6,000 lifetime total. Reimbursement is based on 80%of the cost of education, tuition,fees, and books. Non-Represented $4,000 per fiscal year, not exceeding$8,000 lifetime total. Reimbursement is based on 80%of the cost of education, tuition,fees, and books. Bargaining Unit Benefit All The city will reimburse employees 50% of tuition for continuing education in non-job related courses and 100% of tuition for classes in job related courses. Payment is predicated on an employee receiving 2.0 grade or better, and is based upon a fiscal year. The cost to the City for the education reimbursement shall not exceed $5,000 per employee per fiscal year. The City will also reimburse employees 100% of the cost of job-related preparatory classes, certifications, professional licensure prep classes, vehicle or equipment certification and/or Class A or B license fees, and renewal fees on such certification and/or licenses. • I/ • I • Point Bargaining Unit Benefit All Up to a fiscal year maximum of the cost of full-time, in-state course work at a California State University. ity of Indian Wells Bargaining Unit Benefit All City pays 100% of cost of tuition and 50% of books for qualified, pre-approved State University courses. i of Indio Bargaining Unit Benefit All City reimburses 80% of required tuition and fees for an annual maximum of$2,000. Bargaining Unit Benefit All Shall not exceed $3,000 during the fiscal year per employee (from a pool of$30,000 per fiscal year). - •ngs Bargaining Unit Benefit All $1,500 fiscal year Bargaining Unit Benefit All $1,500 each fiscal year Bargaining Unit Benefit All Maximum of$850 fiscal year ity of Redlands Bargaining Unit _ Benefit Teamsters-General Unit No more than $2,000 in a fiscal year. Redland's Association of Middle Management No more than $2,000 in a fiscal year. Employees Redland's Association of Management No more than $2,500 in a fiscal year. Employees Redland's Association of Department Directors Yes, no max mentioned in MOU. Bargaining Unit Benefit All $10,000 put into a pool for employees to use each year, unused money is rolled over to next year. Bargaining Unit Benefit All Up to $1,200 per fiscal year. Appendix V City of Palm Desert Additional Benefits May 2018 City of Cathedral City All The City Manager or a department head may recommend in writing to raise an employee's salary to a higher step prior to eligibility times in order to recognize meritorious service, advanced educational achievements, or other extraordinary attributes. Requires City Manager approval. • - • • •ells Bargaining Unit Benefit All None -' iivkelfel•Iir•1 411 Bargaining Unit Benefit All None Bargaining Unit Benefit All None Bargaining Unit Benefit All For non-required degrees: Associate's degree = 2.5% increase and Bachelor's degree= 5%. Bargaining Unit Benefit All None Bargaining Unit Benefit All 5%of base pay is provided for a Master's degree or professional certifications related to the job that require continuing education hours. Bargaining Unit Benefit All None ity of Rancho Mirage Bargaining Unit Benefit All None Pal moms.71/7, mr7: 11F- Bargaining Unit Benefit All None Bargaining Unit Benefit All None Bargaining Unit Benefit All None