The URL can be used to link to this page

CC SR 20160405 F - Employee Compensation AUP Report 2015RANCHO PALOS VERDES CITY COUNCIL AGENDA REPORT AGENDA DESCRIPTION: MEETING DATE: 04/05/2016 AGENDA HEADING: Consent Calendar Consideration and possible action to receive and file the Independent Accountants' Report on Agreed -Upon Procedures Performed with Respect to City Employee Compensation for the Calendar Year ended 2015. RECOMMENDED COUNCIL ACTION: (1) Receive and file documents related to the 2015 City Employee Compensation and Benefit Analysis Report. FISCAL IMPACT: None Amount Budgeted: N/A Additional Appropriation: N/A Account Number(s): N/A ORIGINATED BY: Vina Ramos, Accounting Supervisor REVIEWED BY: Trang Nguyen, Deputy Director of Finance Deborah Cullen, Director of Finance b�r_— APPROVED BY: Doug Willmore, City Managerl/ ATTACHED SUPPORTING DOCUMENTS: A. Independent Accountants' Report on Agreed -Upon Procedures Performed with Respect to City Employee Compensation, for the Calendar Year ended December 31, 2015 (page A-1) B. 2015 City Employee Compensation and Benefit Analysis Report (page B-1) BACKGROUND AND DISCUSSION: City Staff completed the Employee Compensation and Benefit Analysis for calendar year ended December 31, 2015 ("Analysis"). The Analysis includes the total compensation for all City employees who worked at the City during the calendar year. The total compensation captures all forms of pay and City -paid benefits, including wages, allowances, overtime, declined health insurance, bonuses, severance, vacation buy out, pension contribution, health insurance, ancillary insurance, and retirement health savings. In addition, the Analysis includes an accounting of all leave time earned during 2015. On March 11, 2016, the City's independent financial statement auditor, Vavrinek, Trine, Day & Co., LLP (VTD) completed the Agreed -Upon Procedures (AUPs) of the Analysis report. VTD's procedures include tracing applicable gross pay from the City's payroll 1 system and W-2 filings, sampling 20 employees and tracing amounts in the report to supporting documentation. After the performed procedures, City employee earnings were reconciled to the W-2 filings and no exceptions noted. For the benefits section, VTD noted one instance related to the over -payment of $682 to the City's health insurance vendor, Blue Shield, for which the City will receive a full credit in April 2016. The over -payment was related to the City's option for Blue Shield's early renewal policy, implemented on December 1, 2015, instead of January 1, 2016. After City Council approval, the City Employee Compensation and Benefit Analysis Report for 2015 will be published in the City's Transparency website (http://www.rpvca.gov/35/Transparency). ALTERNATIVES: In addition to the Staff recommendation, the following alternative actions are available for the City Council's consideration: Discuss and take other action related to this item. 2 CITY OF RANCHO PALOS VERDES Independent Accountants' Report on Agreed -Upon Procedures Performed with Respect to City Employee Compensation For the Calendar year ended December 31, 2015 A-1 ur,r.4.1 Vavrinek, Trine, Day & Co., LLP Certified Public Accountants INDEPENDENT ACCOUNTANTS' REPORT ON APPLYING AGREED-UPON PROCEDURES PERFORMED WITH RESPECT TO CITY EMPLOYEE COMPENSATION The Honorable City Council of the City of Rancho Palos Verdes Rancho Palos Verdes, California We have performed the procedures enumerated below, which were agreed to by the City of Rancho Palos Verdes, California (City) solely to assist you with respect to your evaluation of selected provisions of City employee compensation for the calendar year ended December 31, 2015. The City's management is responsible for the execution of the provisions related to the employment of City personnel. This agreed-upon procedures engagement was conducted in accordance with attestation standards established by the American Institute of Certified Public Accountants. The sufficiency of these procedures is solely the responsibility of the City. Consequently, we make no representation regarding the sufficiency of the procedures described below, either for the purpose for which this report has been requested, or for any other purpose. The procedures performed and the results of those procedures were as follows: Trace applicable information on the City employee compensation worksheet prepared by the City to applicable W-2 filings. Result: We traced the gross pay information on the worksheet prepared by the City to the ADP Master Control report. We obtained a reconciliation of the gross pay information on the worksheet to the W-2 filing. We traced reconciling items to the ADP Master Control report. We traced the reconciled amount to the W-2 filing. No exceptions were noted. 2. Select a sample of twenty (20) employees from the following: a. Five (5) management personnel — selected haphazardly b. Five (5) part-time personnel including one (1) City Council member — selected haphazardly c. Ten (10) full-time non -management personnel -selected haphazardly For the selected sample, trace the following to City personnel records, contracts (if applicable), policies, and other supporting documentation: d. Payroll i. Annual salary ii. Overtime iii. Auto allowance iv. Bonus v. Vacation buyout vi. Health insurance in -lieu 10681 Foothill Blvd., Suite 300 Rancho Cucamonga, CA 91730 Tel: 909.466.4410 www.vtdcpa.com Fax: 909.466.4431 ^-2 e. City paid benefit costs i. Pension benefits ii. Insurance — including but not limited to medical, vision, and dental. These amounts are reflected on the schedule on a pay period basis but are invoiced on a monthly basis and include rate changes during the year. Therefore the procedure for these amounts will be to reconcile the amounts for the schedule to the monthly invoice paid. iii. Medicare iv. Retirement health savings account contribution v. Deferred compensation f. Benefits — Earned hours only i. Wellness ii. Administrative leave iii. Sick leave iv. Holidays v. Vacation vi. Compensatory time Result: We selected a sample of 20 City employees including five management personnel, five part-time personnel including one City Council member, and ten full-time non -management personnel. We traced applicable provisions as listed above to City personnel records, contracts, policies, and other supporting documentation. For City paid benefit costs related to insurance, we reconciled amounts reported on the schedule to the monthly invoice paid. For City paid insurance, we noted one instance in which one management employee was paid $319 for the month of December 2015 in a cash -in -lieu payment for opting out of the City's medical coverage; however, the City paid for the employee's medical insurance premium for the month of December 2015 through the City's medical insurance provider resulting in an overpayment of $682 in medical insurance premium. City management is working with the City's medical insurance provider to obtain a refund for these overpaid amounts which the medical insurance provider asserted will be received as part of the April 2016 invoice. No other exceptions were noted. We were not engaged to, and did not conduct an audit, the objective of which would be the expression of an opinion on the provisions of City employee compensation, related internal control, compliance with government code, or elements, accounts or items specified above. Accordingly, we do not express such an opinion. Had we performed additional procedures, other matters might have come to our attention that would have been reported to you. This report is intended solely for the information and use of the City Council and management of the City and is not intended to be, and should not be, used by anyone other than those specified parties. ', Idxxd ,16 c9 Rancho Cucamonga, California March 21, 2016 2 A-3 CITY OF RANCHO PALOS VERDES EMPLOYEE COMPENSATION AND BENEFIT ANALYSIS CALENDAR YEAR 2015 Emp No. Title FT or PT Emp Full Year? Annual or Hrly Wage Rate ACTUAL CITY PAID Salary or Wages* Over Time Auto Allow Longvty Pay Decl Health Insur Bonus/ Severance Leave Subtotal Buy Gross Out Income 141 Account Clerk FT Y 57,116 57,116 218 57,334 4410 Accountant FT Y 88,422 88,422 982 - 89,404 10048 Accounting Supervisor FT N 110,058 16,102 - - 319 - 16,421 6400 Acting City Manager FT N 182,034 140,110 - 4,500 - 17,142 161,752 085 Administrative Analyst II FT Y 79,875 79,875 305 - - 80,180 3440 Administrative Analyst II FT N 82,730 60,699 - - 60,699 128 Administrative Assistant FT Y 59,173 56,465 3,663 60,128 153 Administrative Intern PT Y 15.00 16,748 - 16,748 152 Administrative Intern PT N 15.00 2,411 - - 2,411 138 Administrative Intern PT N 25.00 37,100 2,478 2,000 41,578 103 Administrative Staff Assistant FT Y 59,173 59,255 - - 59,255 5350 Administrative Staff Assistant FT Y 59,263 59,263 - 59,263 127 Assistant Engineer FT Y 76,421 76,421 425 76,845 10044 Assistant Engineer FT N 76,421 33,730 - 33,730 159 Assistant Planner FT Y 64,385 64,385 1,174 65,558 2040 Associate Engineer FT N 100,523 37,232 278 37,510 10017 Associate Engineer FT N 109,039 78,296 568 - 78,864 142 1 Associate Engineer FT N 1 109,039 44,423 - 3,600 48,023 10049 Associate Planner FT N 84,115 9,346 - - 9,346 8750 Associate Planner FT Y 94,553 87,987 944 88,930 10013 Associate Planner FT Y 81,000 81,150 - 81,150 065 Building Inspector I FT Y 76,682 75,465 - 75,465 140 Building Inspector I FT Y 64,800 64,800 1,316 66,116 1362 Building Official FT Y 126,969 126,969 - - 126,969 5400 City Clerk FT Y 115,728 115,728 5,519 121,247 105 City Council Member PT Y 4,985 4,985 - 4,985 090 City Council Member PT Y 4,985 4,985 - 4,985 107 City Council Member PT Y 4,985 4,985 3,663 8,648 10050 City Council Member PT N 4,985 369 319 688 106 City Council Member PT N 4,616 4,616 - 4,616 94 City Council Member PT Y 4,985 4,985 - 4,985 10015 City Manager FT N 215,000 177,788 - 7,000 184,788 6352 Code Enforcement Officer FT Y 71,494 71,494 2,420 - - 73,914 6480 Code Enforcement Officer FT N 69,155 55,112 84 1,409 56,604 8450 Deputy City Clerk FT Y 74,144 74,144 4,750 - - - 78,894 10047 Deputy City Manager FT N 166,154 33,846 - 375 319 34,540 5300 Deputy Director of Community Dev FT y 127,601 127,600 - - - 127,600 2025 Deputy Director of Finance FT Y 139,072 141,518 675 12,877 155,070 3825 Deputy Public Works Director FT Y 128,909 128,909 - - 128,909 7100 Director of Community Development FT Y 182,034 182,034 1,800 183,834 10040 Director of Finance FT N 176,538 95,288 975 - 96,263 5200 Director of Finance FT N 182,034 23,934 150 25,209 49,293 139 Director of Public Works FT Y 171,346 171,346 1,800 - 173,146 130 Director of Recreation & Parks FT y 145,385 145,385 1,800 147,185 1075 Executive Staff Assistant FT Y 78,494 78,494 - 78,494 10037 GIS Coordinator PT N 37.00 25,928 25,928 10043 Human Resources Analyst FT N 77,885 21,490 21,490 123 1 Human Resources Manager FT I Y 1 119,423 119,423 119,423 151 Information Technology Manager FT N 109,038 109,038 109,038 As CITY OF RANCHO PALOS VERDES EMPLOYEE COMPENSATION AND BENEFIT ANALYSIS CALENDAR YEAR 2015 Emp No. FT Emp or Full Is Title PT Year? Annual or Hrly Wage Rate ACTUAL CITY PAID Salary or Wages* Over Time Auto Longvty Allow Pay Decl Leave Subtotal Health Bonus/ Buy Gross Insur Severance Out Income 041 IT Intern PT N 15.00 3,180 - 3,180 154 Lead Worker FT Y 57,115 57,115 8,091 - 65,207 10014 Maintenance Superintendent FT Y 96,577 96,577 3,085 99,662 157 Maintenance Worker FT Y 51,923 43,500 2,073 3,663 49,236 2755 Maintenance Worker II FT Y 52,059 52,059 5,730 - 57,789 3625 Permit Technician CD FT Y 60,484 60,484 441 60,925 158 Permit Technician CD FT Y 54,519 54,519 312 - 54,832 4800 Permit Technician PW FT Y 64,778 64,778 - 900 65,678 144 Planning Commissioner PT N 1,682 1,682 - 1,682 112 Planning Commissioner PT Y 1,682 1,682 1,682 145 Planning Commissioner PT Y 1,682 1,682 1,682 110 Planning Commissioner PT Y 1,682 1,682 1,682 109 Planning Commissioner PT Y 1,682 1,682 - 1,682 10012 Planning Technician FT Y 57,115 56,877 635 57,512 134 Recreation Leader PT N 10.07 - - - 148 Recreation Leader PT N 10.07 4,715 - 4,715 133 Recreation Leader PT Y 10.07 15,231 174 15,405 146 Recreation Leader PT Y 17.00 19,306 - 19,306 042 Recreation Leader PT N 10.07 2,694 106 2,799 1445 Recreation Leader PT N 10.47 1,034 - - 1,034 10029 Recreation Leader PT N 10.07 7,379 155 7,534 10045 Recreation Leader PT N 10.07 2,130 10018 Recreation Leader PT Y 10.07 14,770 196 14,966 2890 Recreation Leader PT N 11.27 5,985 - 5,985 3810 Recreation Leader PT Y 11.13 4,739 4,739 108 Recreation Leader PT N 10.07 6,047 - 6,047 158 Recreation Leader FT N 10.07 7,848 155 - 8,003 163 Recreation Leader PT N 10.07 3,245 - 3,245 10031 Recreation Leader PT N 10.07 9,340 68 9,408 162 Recreation Leader PT Y 10.07 2,641 - - 2,641 161 Recreation Leader PT Y 10.07 14,551 208 14,759 102 Recreation Leader PT Y 10.07 1,168 - 1,168 161 Recreation Leader PT N 10.07 4,305 4,305 9130 Recreation Leader PT Y 10.49 5,400 5,400 10030 Recreation Leader PT N 10.07 259 259 325 Recreation Leader II PT N 17.00 13,457 13,457 1320 Recreation Leader II PT Y 14.85 1,296 1,296 5475 Recreation Leader II PT Y 11.44 452 452 2020 Recreation Leader II PT Y 11.85 7,987 7,987 2825 Recreation Leader II PT Y 13.89 17,734 17,734 80 Recreation Leader II PT Y 11.44 827 827 104 Recreation Leader II PT Y 11.44 11,394 86 11,480 3800 Recreation Leader II PT Y 14.65 10,094 10,094 4325 Recreation Leader II PT N 12.23 8,735 8,735 108 Recreation Leader II PT Y 11.44 13,270 13,270 5060 Recreation Leader II PT Y 13.25 12,382 12,382 116 Recreation Leader II PT N 11.44 1,642 1,642 152 Recreation Leader II PT Y 11.44 3,635 3,635 8095 Recreation Leader 11 PT Y 11.82 16,731 16,731 701111111111111 CITY OF RANCHO PALOS VERDES EMPLOYEE COMPENSATION AND BENEFIT ANALYSIS CALENDAR YEAR 2015 Emp No. FT Emp or Full Title PT Year? Annual or Hrly Wage Rate ACTUAL CITY PAID Salary or Wages* Over Time Auto Longvty Allow Pay Decl Leave Subtotal Health Bonus/ Buy Gross Insur Severance Out Income 1985 Recreation Program Supervisor II FT Y 84,910 84,477 1,504 85,981 10034 Recreation Program Supervisor II FT Y 84,910 84,910 - 900 85,810 143 Recreation Services Manager FT Y 92,423 92,423 92,423 700 Recreation Specialist PT Y 20.41 28,166 - - 28,166 10021 Recreation Specialist PT N 15.72 14,982 106 15,089 10036 1 Recreation Specialist PT N 1 15.72 8,198 118 8,316 5150 Recreation Specialist PT N 18.91 7,602 - 7,602 62 Recreation Specialist PT Y 17.00 24,927 30 24,957 64 Recreation Specialist PT Y 18.06 26,314 163 26,477 152 Recreation Specialist PT N 15.72 11,200 183 11,383 9265 Recreation Specialist PT Y 17.00 19,802 217 20,018 9320 Recreation Specialist PT Y 18.06 14,428 - 14,428 147 Recreation Specialist PT Y 17.00 21,353 134 21,487 10038 Recreation Specialist PT N 17.00 4,492 - 4,492 10025 Recreation Specialist PT N 17.00 15,568 15,568 67 Recreation Specialist PT Y 17.00 24,780 - 24,780 9770 Senior Accounting Technician FT Y 72,648 72,648 2,712 75,359 084 Senior Administrative Analyst FT Y 94,576 94,576 3,382 - 97,959 2700 Senior Administrative Analyst FT Y 94,553 94,553 2,315 500 97,368 129 Senior Administrative Analyst FT Y 96,577 96,577 1,710 - 98,287 155 Senior Administrative Analyst FT Y 91,385 91,131 571 91,702 6800 Senior Administrative Analyst FT Y 1 102,427 102,427 5,957 - 108,384 9350 Senior Administrative Analyst FT Y 102,037 102,037 35 3,663 105,736 5494 Senior Engineer FT Y 114,392 114,132 16,760 - 130,892 2040 Senior Engineer FT Y 129,682 129,364 - - 129,364 5490 Senior Engineer FT N 123,506 5,604 - - 1,337 6,940 77 Senior Engineer FT Y 115,748 115,465 3,690 3,663 - 122,817 135 Senior Planner FT Y 105,893 105,893 882 - - 106,775 4010 Senior Planner FT Y 101,171 91,155 5,024 974 97,153 5325 Senior Planner FT Y 95,429 85,888 8,853 - 919 - 95,660 7700 Senior Planner FT N 105,888 55,101 882 - 13,714 69,697 046 Staff Assistant PT N 20.00 6,220 - - 6,220 4300 Staff Assistant I / Part Time PT Y 19.27 28,703 210 28,912 4700 Staff Assistant I / Part Time PT Y 19.36 20,706 - 20,706 9250 Staff Assistant II / Full Time FT Y 54,340 54,340 - 54,340 117 Staff Assistant II / Full Time FT Y 59,173 56,143 140 Television Producer PT Y 25.75 11,562 - - 6,646,226 6,142,829 93,034 19,075 1,800 *Salary or Wages are based on 27 pay periods in Calendar Year 2015 56,283 8035 11,562 19,272 *Includes new medical rates effective 12/1/15 9W CITY OF RANCHO PALOS VERDES EMPLOYEE COMPENSATION AND BENEFIT ANALYSIS CALENDAR YEAR 2015 Emp No. Title ACTUAL CITY CONTRIBUTIONS Pension Medical Vis/Den Insurance* FICA Medicare & So c Sec Life Insur AD&D Insur Long Term Disab Depen- dent Life Retiree Health Subtotal Save Benefits 141 Account Clerk 5,208 8,565 759 193 61 275 16.20 1,499 16,576 4410 Accountant 13,533 11,899 1,184 298 94 426 16.20 1,499 28,948 10048 Accounting Supervisor 2,161 137 219 31 1 44 1.35 111 2,705 6400 Acting City Manager 19,432 9,654 2,170 406 114 584 10.80 1,109 33,480 085 Administrative Analyst II 12,225 18,935 990 268 85 385 - 1,499 34,386 3440 lAdministrative Analyst II 9,848 10,462 778 278 65 398 - 1,499 23,327 128 Administrative Assistant 4,482 1,405 817 182 51 119 14.85 1,499 8,569 153 Administrative Intern 766 - 769 - - - - 1,535 152 Administrative Intern - 184 184 138 Administrative Intern 2,318 - 569 - - - 2,887 103 Administrative Staff Assistant 9,066 18,935 725 198 63 285 - 1,499 30,771 5350 Administrative Staff Assistant 9,070 11,585 742 200 63 285 16.20 1,499 23,460 127 Assistant Engineer 6,007 8,232 1,036 258 81 368 - 1,499 17,480 10044 Assistant Engineer 2,021 1,420 1,331 64 8 92 - 4,937 159 Assistant Planner 5,061 11,268 884 218 68 310 - - 17,809 2040 Associate Engineer 3,948 4,157 447 113 317 - 5.40 445 9,432 10017 Associate Engineer 7,484 13,496 1,019 275 58 394 12.15 1,499 24,237 142 Associate Engineer 3,556 6,521 647 52 15 175 5.40 221 11,192 10049 Associate Planner 1,166 1,117 120 23 1 - - 111 2,539 8750 Associate Planner 13,440 18,849 1,117 318 94 455 16.20 1,499 35,788 10013 Associate Planner 7,400 14,880 993 271 86 - 16.20 - 23,646 065 Building Inspector 1 11,545 11,739 1,007 258 80 369 - 1,499 26,497 140 Building Inspector 1 5,094 18,935 832 218 69 312 - 1,499 26,958 1362 Building Official 19,433 21,793 1,580 426 135 611 16.20 1,499 45,493 5400 City Clerk 17,712 11,739 1,619 388 123 557 16.20 1,499 33,653 105 City Council Member - 11,739 382 87 - - - - 12,208 090 City Council Member 21,793 14 87 - 21,894 107 City Council Member 1,620 604 87 - 2,311 10050 City Council Member - 53 7 - 60 106 City Council Member 21,793 15 80 - 21,887 94 City Council Member - 21,793 14 87 - - - - 21,894 10015 1 City Manager 16,722 17,787 2,397 508 143 896 13.50 1,166 39,632 6352 Code Enforcement Officer 10,942 11,739 961 240 76 344 16.20 1,499 25,817 6480 Code Enforcement Officer 7,884 9,986 751 175 41 250 - 1,165 20,251 8450 Deputy City Clerk 11,348 21,793 938 249 79 357 16.20 1,499 36,278 10047 Deputy City Manager 4,541 1,256 462 93 6 133 2.70 167 6,661 5300 Deputy Director of Community Dev 19,529 11,739 1,675 428 136 614 - 1,499 35,620 2025 Deputy Director of Finance 21,285 21,793 1,950 466 150 670 16.20 1,499 47,830 3825 Deputy Public Works Director 19,729 19,326 1,544 433 137 621 - 1,499 43,289 7100 1 Director of Community Development 27,860 11,739 2,429 609 186 876 16.20 1,499 45,214 10040 Director of Finance 9,212 6,098 1,482 296 86 850 8.10 835 18,866 5200 Director of Finance 3,758 3,871 680 51 14 73 1.35 56 8,504 139 Director of Public Works 10,007 20,789 2,270 574 182 825 16.20 1,499 36,162 130 Director of Recreation & Parks 13,260 13,480 1,887 489 155 700 16.20 1,499 31,485 1075 Executive Staff Assistant 12,014 11,739 1,048 264 83 378 1,499 27,025 10037 GIS Coordinator - 1,983 - - - - - 1,983 10043 Human Resources Analyst 2,797 3,078 938 66 5 94 4.05 389 7,371 123 Human Resources Manager 10,892 12,334 1,552 402 127 575 - 1,499 27,380 151 Information Technology Manager 9,945 21,793 1,359 365 116 525 16.20 1,499 35,618 CITY OF RANCHO PALOS VERDES EMPLOYEE COMPENSATION AND BENEFIT ANALYSIS CALENDAR YEAR 2015 Emp No. in Title ACTUAL CITY CONTRIBUTIONS Medical FICA Long Depen- Retiree Vis/Den Medicare Life AD&D Term dent Health Pension Insurance* & Soc Sec Insur Insur Disab Life Save Subtotal Benefits 041 IT Intern - 4,490 - 21,793 243 785 - 191 - 61 275 - - 1,499 243 29,093 154 Lead Worker 10014 Maintenance Superintendent 7,592 13,260 1,355 324 103 465 16.20 1,499 24,613 157 Maintenance Worker 3,436 394 366 176 46 - 16.20 - 4,434 2755 Maintenance Worker II 7,968 18,241 709 176 55 251 16.20 1,499 28,914 3625 1 Permit Technician CD 9,257 11,699 796 204 64 291 - 1,499 23,810 158 Permit Technician CD 4,286 11,308 739 184 58 263 1,499 18,336 4800 Permit Technician PW 10,050 11,739 393 218 69 312 1,499 24,279 144 Planning Commissioner - - 129 - - - 129 112 Planning Commissioner 129 129 145 Planning Commissioner - 129 129 110 1 Planning Commissioner 129 129 109 Planning Commissioner - 129 - - - 129 10012 Planning Technician 4,475 7,760 777 191 60 275 1,499 15,038 134 Recreation Leader - - - - - 148 Recreation Leader 361 361 133 Recreation Leader 858 548 1,406 146 Recreation Leader 1,158 569 1,727 042 Recreation Leader - 214 214 1445 Recreation Leader 162 14 176 10029 Recreation Leader 576 576 10045 Recreation Leader 163 - 163 10018 Recreation Leader 541 541 2890 Recreation Leader 917 80 997 3810 Recreation Leader 589 63 652 108 Recreation Leader 2,044 463 2,506 158 Recreation Leader 612 5 617 163 Recreation Leader 248 248 10031 Recreation Leader 720 720 162 Recreation Leader 202 - - 202 161 Recreation Leader 1,120 201 - 1,320 102 Recreation Leader 186 16 - 202 161 Recreation Leader 329 - 329 9130 Recreation Leader 808 72 - 880 10030 Recreation Leader 20 - 20 325 Recreation Leader II 1,925 180 - 2,104 1320 Recreation Leader II 189 17 - 206 5475 Recreation Leader II 71 6 - 77 2020 Recreation Leader II 1,209 107 - 1,315 2825 Recreation Leader II 2,720 237 - 2,957 80 Recreation Leader II 143 11 - 154 104 Recreation Leader II 1,789 153 - 1,942 3800 Recreation Leader II 1,574 135 - 1,709 4325 Recreation Leader II 1,185 117 - 1,302 108 Recreation Leader II 2,044 177 - 2,221 5060 Recreation Leader II 1,859 165 - 2,024 116 Recreation Leader II 103 22 125 152 Recreation Leader II 227 49 277 8095 Recreation Leader 11 2,540 223 2,763 CITY OF RANCHO PALOS VERDES EMPLOYEE COMPENSATION AND BENEFIT ANALYSIS CALENDAR YEAR 2015 Emp No. Title ACTUAL CITY CONTRIBUTIONS Medical FICA Long Depen- Retiree Vis/Den Medicare Life AD&D Term dent Health Pension Insurance* & Soc Sec Insur Insur Disab Life Save Subtotal Benefits 1985 Recreation Program Supervisor II 12,928 13,132 11,936 11,739 1,062 510 285 285 90 90 409 409 16.20 - 1,499 1,499 28,224 27,664 10034 Recreation Program Supervisor II 143 Recreation Services Manager 8,429 13,955 1,145 311 98 445 16.20 1,499 25,899 700 Recreation Specialist 4,294 - 376 - - - - 4,670 10021 Recreation Specialist 1,154 1,154 10036 1 Recreation Specialist 636 636 5150 Recreation Specialist 1,194 101 1,295 62 Recreation Specialist 3,873 333 4,206 64 Recreation Specialist 4,048 353 4,402 152 Recreation Specialist 871 871 9265 Recreation Specialist 3,336 267 3,603 9320 Recreation Specialist 2,217 192 2,410 147 Recreation Specialist 1,429 601 2,030 10038 Recreation Specialist 344 - 344 10025 Recreation Specialist - 1,191 - 1,191 67 Recreation Specialist 3,812 331 - - - 4,142 9770 Senior Accounting Technician 11,119 14,880 906 244 77 350 16.20 1,499 29,090 084 Senior Administrative Analyst 14,475 18,535 1,215 318 101 455 16.20 1,499 36,614 2700 Senior Administrative Analyst 14,471 18,935 1,233 318 101 455 - 1,499 37,013 129 Senior Administrative Analyst 8,808 8,232 1,324 325 103 465 16.20 1,499 20,772 155 Senior Administrative Analyst 8,314 11,739 1,226 308 97 440 - 1,499 23,623 6800 Senior Administrative Analyst 15,677 21,793 1,342 345 109 493 16.20 1,499 41,273 9350 Senior Administrative Analyst 15,617 695 1,402 343 108 491 16.20 1,499 20,171 5494 Senior Engineer 17,467 8,232 1,744 385 121 551 16.20 1,499 30,015 2040 Senior Engineer 19,798 18,935 1,658 435 138 624 16.20 1,499 43,103 5490 1 Senior Engineer 880 - 96 - 6 - - 982 77 Senior Engineer 17,671 866 1,636 388 123 557 16.20 1,499 22,756 135 Senior Planner 16,207 13,955 1,323 355 113 510 - 1,499 33,961 4010 Senior Planner 13,952 21,714 1,191 339 97 487 16.20 1,499 39,295 5325 Senior Planner 13,142 11,739 1,270 320 91 459 - 1,499 28,521 7700 Senior Planner 8,651 7,620 936 148 23 212 6.75 779 18,375 046 Staff Assistant - 476 - - - - 476 4300 Staff Assistant I / Part Time 4,332 386 4,718 4700 Staff Assistant I / Part Time 3,113 - 276 - - - - 3,389 9250 Staff Assistant II / Full Time 8,317 18,911 669 183 58 262 16.20 1,499 29,914 117 Staff Assistant II / Full Time 8,593 11,268 744 198 60 285 - 1,499 22,646 8035 Television Producer - 884 884 i w o CITY OF RANCHO PALOS VERDES EMPLOYEE COMPENSATION AND BENEFIT ANALYSIS CALENDAR YEAR 2015 Emp No. Title Total 2015 ACTUAL City Exp 2015 Hours Earned Well- ness Admin Leave Leave Sick Vacation Holiday Cmp Hrs in lieu Paid OT 141 Account Clerk 73,910 4.5 96 80 129 120 133 18 106 4410 Accountant 118,352 4.5 96 10048 Accounting Supervisor 19,126 - 41 8 7 39 - 6400 Acting City Manager 195,233 4.5 62 64 107 93 085 Administrative Analyst II 114,566 - 96 96 129 45 3440 lAdministrative Analyst II 84,026 - 96 120 124 128 Administrative Assistant 68,697 4.5 88 73 71 98 153 Administrative Intern 18,283 - - - - 152 Administrative Intern 2,596 138 Administrative Intern 44,465 103 Administrative Staff Assistant 90,026 4.5 96 80 132 70 5350 Administrative Staff Assistant 82,723 - 96 120 129 127 Assistant Engineer 94,325 96 96 129 40 10044 Assistant Engineer 38,666 72 60 30 159 Assistant Planner 83,367 13.5 96 80 133 27 2040 Associate Engineer 46,942 - 32 27 45 10017 Associate Engineer 103,100 4.5 72 60 57 142 Associate Engineer 59,215 - 32 27 72 10049 Associate Planner 11,885 - 8 7 45 8750 Associate Planner 124,719 4.5 96 120 76 89 10013 Associate Planner 104,796 - 96 80 133 065 Building Inspector 1 101,962 - 96 106 129 3 140 Building Inspector 93,074 4.5 96 80 128 1362 Building Official 172,462 4.5 62 96 120 133 5400 City Clerk 154,900 22.5 62 96 160 133 105 City Council Member 17,193 - - - - 090 City Council Member 26,879 - - 107 City Council Member 10,959 - - 10050 City Council Member 748 - - 106 City Council Member 26,503 - - 94 City Council Member 26,879 - - - - 10015 1 City Manager 224,421 9.0 80 160 75 6352 Code Enforcement Officer 99,732 - - 96 160 133 68 6480 Code Enforcement Officer 76,855 - 72 90 93 8450 Deputy City Clerk 115,171 - 96 136 129 35 10047 Deputy City Manager 41,201 45 16 13 45 5300 Deputy Director of Community Dev 163,220 62 96 130 111 2025 Deputy Director of Finance 202,900 62 96 120 129 3825 Deputy Public Works Director 172,198 12.0 62 96 120 118 7100 Director of Community Development 229,048 22.5 62 96 160 139 10040 Director of Finance 115,130 9.0 62 48 40 48 5200 Director of Finance 57,797 - 35 8 12 67 139 Director of Public Works 209,308 4.5 62 96 80 138 130 Director of Recreation & Parks 178,669 4.5 62 96 80 130 1075 Executive Staff Assistant 105,519 9.0 96 120 133 10037 GIS Coordinator 27,911 - 12 - - 10043 Human Resources Analyst 28,861 - 52 24 20 45 123 Human Resources Manager 146,803 13.5 62 96 80 124 151 Information Technology Manager 144,656 13.5 62 96 80 120 CITY OF RANCHO PALOS VERDES EMPLOYEE COMPENSATION AND BENEFIT ANALYSIS CALENDAR YEAR 2015 Emp No. Title Total 2015 ACTUAL City Exp 2015 Hours Earned Well- ness Leave Admin Leave Sick Vacation Cmp Hrs in lieu Holiday Paid OT 041 IT Intern 3,423 - - 154 Lead Worker 94,300 4.5 96 80 132 10 10014 Maintenance Superintendent 124,275 22.5 96 80 138 12 157 Maintenance Worker 53,671 96 80 129 6 2755 Maintenance Worker II 86,703 4.5 96 120 142 9 3625 Permit Technician CD 84,735 - 96 120 142 9 158 Permit Technician CD 73,168 96 80 138 4800 Permit Technician PW 89,957 96 160 142 10 144 Planning Commissioner 1,811 - - 112 Planning Commissioner 1,811 145 Planning Commissioner 1,811 - 110 Planning Commissioner 1,811 109 Planning Commissioner 1,811 - 10012 Planning Technician 72,550 9.0 96 80 129 35 134 Recreation Leader - - 148 Recreation Leader 5,076 133 Recreation Leader 16,811 146 Recreation Leader 21,033 042 Recreation Leader 3,014 1445 Recreation Leader 1,210 10029 Recreation Leader 8,110 10045 Recreation Leader 2,293 10018 Recreation Leader 15,507 2890 Recreation Leader 6,982 3810 Recreation Leader 5,390 108 Recreation Leader 8,553 158 Recreation Leader 8,620 163 Recreation Leader 3,493 10031 Recreation Leader 10,128 162 Recreation Leader 2,843 - - 161 Recreation Leader 16,079 102 Recreation Leader 1,370 161 Recreation Leader 4,634 9130 Recreation Leader 6,279 10030 Recreation Leader 279 325 Recreation Leader 11 15,561 1320 Recreation Leader 11 1,502 5475 Recreation Leader 11 529 2020 Recreation Leader II 9,302 2825 Recreation Leader 11 20,691 80 Recreation Leader II 981 104 Recreation Leader 11 13,422 3800 Recreation Leader II 11,803 4325 Recreation Leader 11 10,036 108 Recreation Leader 11 15,491 5060 Recreation Leader 11 14,406 116 Recreation Leader II 1,767 152 Recreation Leader 11 3,912 8095 Recreation Leader 11 19,495 7011rel L • CITY OF RANCHO PALOS VERDES EMPLOYEE COMPENSATION AND BENEFIT ANALYSIS CALENDAR YEAR 2015 Emp No. Title Total 2015 ACTUAL City Exp 2015 Hours Earned Well- ness Leave Admin Leave Sick Vacation Cmp Hrs in lieu Holiday Paid OT 1985 Recreation Program Supervisor II 114,205 96 120 133 10034 Recreation Program Supervisor II 113,473 96 160 129 143 Recreation Services Manager 118,323 96 80 133 700 Recreation Specialist 32,836 - 10021 Recreation Specialist 16,243 10036 Recreation Specialist 8,952 - 5150 Recreation Specialist 8,897 62 Recreation Specialist 29,162 64 Recreation Specialist 30,878 11 152 Recreation Specialist 12,253 9265 Recreation Specialist 23,622 9320 1 Recreation Specialist 16,838 147 Recreation Specialist 23,517 10038 Recreation Specialist 4,836 10025 Recreation Specialist 16,759 19 67 Recreation Specialist 28,922 9770 Senior Accounting Technician 104,449 4.5 96 136 129 26 084 Senior Administrative Analyst 134,573 - 96 100 128 4 2700 Senior Administrative Analyst 134,381 18.0 96 150 129 46 129 Senior Administrative Analyst 119,059 4.5 96 80 142 155 Senior Administrative Analyst 115,325 - 96 80 141 71 6800 Senior Administrative Analyst 149,658 96 148 116 12 9350 Senior Administrative Analyst 125,907 96 160 133 38 5494 Senior Engineer 160,906 22.5 96 120 129 10 2040 Senior Engineer 172,467 13.5 96 120 142 5490 Senior Engineer 7,922 - - 9 - 77 Senior Engineer 145,573 18.0 96 96 142 3 135 Senior Planner 140,736 4.5 96 120 133 44 4010 Senior Planner 136,448 4.5 96 120 129 101 5325 Senior Planner 124,181 4.5 96 120 133 130 7700 Senior Planner 88,072 - 40 53 71 - 046 Staff Assistant 6,696 4300 Staff Assistant I / Part Time 33,630 4700 Staff Assistant I / Part Time 24,095 9250 Staff Assistant 11 / Full Time 84,254 4.5 96 142 129 117 Staff Assistant II / Full Time 78,929 - 96 96 133 64 8035 Television Producer Totals 12,446 7010"s