:runsdshuv - sce.comfile/wpsce06v0… · strategy to increase cash compensation, which was below...

97
(U 338-E) 2021 General Rate Case A.19-08- Workpapers Total Compensation Study SCE-06 Volume 03, Part 02 August 2019

Upload: others

Post on 20-Oct-2019

5 views

Category:

Documents


1 download

TRANSCRIPT

Page 1: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

(U 338-E)

2021 General Rate Case A.19-08-

Workpapers

Total Compensation Study SCE-06 Volume 03, Part 02

August 2019

Page 2: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02 Witnesses: M. Bennett

Aon Consulting | Human Capital Solutions Proprietary and Confidential

Risk. Reinsurance. Human Resources.

2021 General Rate Case— Total Compensation Study Report—Draft Southern California Edison

August 2019

1

Page 3: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02 Witnesses: M. Bennett

2021 General Rate Case 1

Introduction In 2019, Southern California Edison (“SCE”) will be filing an application for its 2021 General Rate Case (“GRC”) with the California Public Utilities Commission (“CPUC”). As part of this application, SCE will include a Total Compensation Study (“the 2021 Study”) that will provide a competitive analysis of SCE’s total compensation including pay and benefits. Total Compensation Studies that were completed in 2015 and prior GRC submissions, were conducted jointly with SCE and Cal Advocates (formerly called the Office of Ratepayer Advocates (“ORA”)) of the CPUC. Cal Advocates declined to participate in the 2018 and the 2021 Studies.

SCE selected Aon to conduct the competitive analysis of total compensation. Aon followed the approved methodology used in the 2015 and 2018 Studies to value total compensation for the 2021 Study with the exception of valuing Paid-Time-Off (PTO) as a separate benefit component. Valuation of PTO was excluded because the impact on results in past Studies was immaterial and TCS Studies conducted by other state Utilities do not include this component. To be consistent with other Utilities, the GRC Study Team (“the Team”) made up of representatives from SCE and Aon, determined that the PTO valuation should not be included as a separate component.

Aon independently completed all valuation and analysis of market compensation, benefits, and total compensation to obtain competitive data. Aon then compared that data to SCE total compensation levels. Aon developed analyses, summaries, and reports covering this information and presented them to the Team for review. The methodology used in the 2021 Study is described in detail in this report and discussions about the methodology are referenced in the meeting notes and working papers. The Team felt it was important that the methodology remain as consistent as possible to the approach used in the 2015 and 2018 Studies to reflect input provided by the ORA related to preferences in methodology and to allow comparison of results between Studies.

The Team members included the following:

Pamela Arnold—SCE

Mark Bennett—SCE

Olga Noemi Buendia—SCE

Penny Carter-Lockert—SCE

George Grana—SCE

Chuck Chan—SCE

Stephen Lumel—SCE

Jennifer Roberts—SCE

Al Kopec—Aon, Project Consultant

Kathy Miller—Aon, Project Consultant

Chelsea G. Penaloza—Aon, Project Consultant

Alison A. Peterson—Aon, Study Project Manager

This report contains the 2021 Study results and a description of the 2021 Study methodology.

2

Page 4: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02 Witnesses: M. Bennett

2021 General Rate Case 2

Contents Study Results 3

Study Methodology 9

Appendix A: Benchmark Jobs 25

Appendix B: Comparator List 42

Appendix C: Detailed Results by Category 46

Appendix D: Competitive Analysis Summary 63

Appendix E: LTI Study Positions 67

Appendix F: Benefit Calculation Samples (SCE and Comparator Company) 72

Appendix G: Meeting Notes 79

Appendix H: Measurement of Error 80

Appendix I: Glossary of Terms 83

3

Page 5: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02 Witnesses: M. Bennett

2021 General Rate Case 3

Study Results

4

Page 6: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02 Witnesses: M. Bennett

2021 General Rate Case 4

Study Results The 2021 Study results—overall and by job category—are shown in Table 1:

Table 1: Competitive Summary (SCE versus Market)

SCE vs. Market

Job Category

SCE Population1

SCE Payroll Dollars

($000s)2Payroll

WeightingBase

PayTotal Cash

Comp3 LTI4 BenefitsTotal

Comp5

Physical/ Technical 3,628 $389,605.1 26.4% 15.1% 17.7% -5.6% 13.1%

Clerical 2,574 $184,417.7 12.5% -5.1% -7.2% -10.4% -7.9%

Professional/ Technical 4,421 $546,100.5 37.0% -9.4% -11.7% -100.0% -10.1% -12.8%

Manager/ Supervisor 1,816 $335,356.8 22.7% -0.3% 1.2% -93.4% -5.0% -5.1%

Executive 37 $19,089.7 1.3% -7.9% -16.6% -17.8% -19.8% -17.4%

Overall6 12,476 $1,474,569.9 100.0% -0.2% -0.4% -5.1% -8.0% -3.0%

This table presents SCE’s competitive status for each major element of total compensation (base pay, total cash compensation, long-term incentives (LTI), and benefits). Note that LTI grants are included only for those positions that were found to be eligible for LTI awards in the competitive analysis of pay practices.

The 2021 Study estimates that SCE total compensation levels are below market by 3.0 percent. Discussion of the 2021 Study results by SCE job category follows below.

Each element of total compensation was compared to a sample of the competitive market. Similar to the 2018 GRC Total Compensation Study, the 2021 Study results are intended to be a reasonable estimate of true competitive posture. Due to normal survey error, true market position could be above or below the estimate. Aon assumes the degree of accuracy to be within plus or minus 5 percent of the estimate.

The results of the 2018 Study were deemed to be valid for estimating the competitiveness of SCE’s total compensation levels. The 2021 Study retains the methodology used in the 2018 Study with the exception of valuing PTO as noted earlier. The TCS methodology was developed primarily at the request from ORA in the 2015 rate case, and the 2021 Study provides the same validity, transparency, and clarity as prior Studies. Transparency and clarity are achieved by providing significant detail in this report and in the meeting notes in describing the methodology and decisions made during Team meetings.

1 SCE’s population is as of December 31, 2018. 2 Payroll dollars include base pay as of December 31, 2018, and annual incentives (as defined on page 17), paid in 2018 for 2017 performance.

3 Total Cash Compensation reflects base pay plus actual short-term (annual) incentives for all categories, adjusted to December 31, 2018.

4 Total Compensation includes long-term incentives (LTI) for 17 Executive, 69 Manager/Supervisor, and 41 Professional/Technical jobs.

5 For Study purposes, total compensation is defined as total cash compensation, benefits, and actual LTI. 6 Results are weighted by SCE payroll dollars for all jobs; both benchmark and non-benchmark.

5

Page 7: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02 Witnesses: M. Bennett

2021 General Rate Case 5

Discussion of Competitive Posture Overall, SCE total compensation is below the competitive norm by 3.0 percent. This amount was derived by computing an overall average based on the results of each category, weighted by its payroll dollars. SCE was 1.9 percent below the competitive norm in the 2018 Study. The greatest contributing factor to the shift in market position is due to changes SCE made over the past three years in the design of total compensation programs, including shifting the mix of value delivered through cash compensation and benefits to achieve better alignment with market practice. More specifically, SCE initiated a total rewards strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce the value of benefits, which were above market norms in the 2018 Study. As a result of these changes:

SCE’s average base pay increased overall from 5.0 percent below market in the 2018 Study to 0.2 percent below in the 2021 Study. The increase to market was found across all employee groups except Clerical where base pay decreased from 4.5 percent below market to 5.1 percent below market. Physical/Technical base pay improved from 11.1 percent to 15.1 percent above market. Professional/Technical base pay improved from 13.2 percent below market to 9.4 percent below market. Manager/Supervisor base pay improved from 9.4 percent below market to 0.3 percent below market. Executive base pay improved from 10.3 percent below market to 7.9 percent below market.

Total Cash Compensation (TCC) improved from 2.5 percent below market in the 2018 Study to 0.4 percent below market in the 2021 Study driven primarily by the increase to base pay noted above and increases to target bonus opportunity implemented as part of the total rewards strategy to improve alignment of cash compensation to market.

Long-Term Incentives (LTI) improved modestly from 6.1 percent below market in the 2018 Study to -5.1 percent below market in the 2021 Study.

SCE’s benefits decreased from 4.3 percent above market in the 2018 Study to 8.0 percent below market in the 2021 Study. The most significant reduction was in the Executive category with a decline in position to market from 96.4 percent above market in the 2018 Study to 19.8 percent below market in the 2021 Study. The Executive benefit value decrease is due primarily to significant changes to the executive retirement plans including:

Replacing the Defined Benefit (DB) pension with a Defined Contribution (DC) retirement plan;

Replacing the final average pay Supplementation Executive Retirement Plan (SERP) with an Executive Retirement Account;

Eliminating the non-qualified match from the Executive Deferred Compensation Plan (EDCP);

Eliminating the Executive Survivor Benefit Plan; and

Replacing the retiree medical plan with employer provided credits for a retiree health care account.

Other employee groups also saw reductions in benefit values from the 2018 Study to the 2021 Study ranging from 0.5 percent above market to 5.0 percent below market for the Manager/Supervisor category to 2.6 percent above market to 10.4 percent below market for the Clerical category. Consistent with the Executive category, the primary drivers of the reduction in benefit values for other employee groups were:

Replacing the Defined Benefit (DB) pension with a Defined Contribution (DC) retirement plan; and

Replacing the retiree medical plan with employer provided credits for a retiree health care account.

6

Page 8: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02 Witnesses: M. Bennett

2021 General Rate Case 6

Competitive posture on total compensation varies by category as follows:

Physical/Technical SCE’s Physical/Technical jobs are above comparators by 13.1 percent on total compensation. The results were influenced by position to comparators above the market for several of SCE’s highly populated job classifications including: Lineman, Troubleman, Foreman Electrical Crew, and Operator, System. These benchmarks are 22.0 percent, 25.2 percent, 26.9 percent, and 19.4 percent above comparator pay levels, respectively. Position to comparators for this category was 15.0 percent above in the 2018 Study.

Clerical In the Clerical category, SCE is below comparator levels by 7.9 percent on total compensation. This result is due to a mix of position to comparators for several high incumbent jobs with some being above, approximately at, and below comparator pay levels. The four most highly populated jobs in this category are Analyst-Program/Project 2, Analyst-Business 2, Planning Specialist, and Construction Maintenance Accounting. These benchmarks are 14.3 percent below, 18.5 percent below, 19.3 percent below, and 38.3 percent above market respectively. Position to comparators for this category was 3.2 percent below in the 2018 Study.

Professional/Technical Overall, SCE’s total compensation for the Professional/Technical category was 12.8 percent below comparator group levels. The results were influenced by position to comparators below the market for several of SCE’s highly populated job classifications including: Analyst-Program/Project 3, Planning, Sr. Specialist, Engineer 3, and Analyst-Business 3. These benchmarks are 13.5 percent, 20.3 percent, 12.9 percent, and 11.6 percent below comparator pay levels respectively. Position to comparators for this category was 9.6 percent below in the 2018 Study.

Manager/Supervisor SCE’s total compensation for this category is 5.1 percent below comparator levels. In the 2018 Study, the Manager/Supervisor category was 7.6 percent below comparator levels. The Manager/Supervisor category has a higher percentage of low or single incumbent count jobs as compared to the Physical/Technical, Clerical, or Professional/Technical category. The most highly populated positions contributing to the below market result are the Sr. Attorney, Sr. Manager Project Management, Sr. Project Manager, and Sr. Manager Engineering at 12.7 percent, 9.2 percent, 12.4 percent, and 4.2 percent below comparator levels respectively.

Executive Total compensation for this category is 17.4 percent below comparators. In the 2018 Study, this category was 8.3 percent below comparator total compensation levels. The shift in position to comparators is difficult to isolate because there were a number of changes in the benchmark results for Executives from the 2018 Study. Twelve of the seventeen jobs included in the 2021 Study are either new or had a significant change in scope and accountabilities since the 2018 Study resulting in changes to benchmark matches. As a result, Study over Study comparisons are not useful.

7

Page 9: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02 Witnesses: M. Bennett

2021 General Rate Case 7

Survey Error In addition to normal survey error, several additional sources of possible error are mentioned in the Study Methodology section. Aon estimates each is minor relative to the overall Study results. Table 2 provides Aon’s estimates of the impact of each factor relative to SCE’s total compensation vs. comparator companies:

Table 2: Source of Specific Survey Error7

Source of Error Report Reference Section—Page

Estimated Possible Error as Percentage of Total

Compensation

Job matching inaccuracies Job Match Validation—p. 14 -0.2% to +0.2%

Assume all employees receive salaried benefits

Employee Benefits—p. 18 -0.1% to +0.1%

Benefit Aggregation Data Aggregation and Average Benefit Calculation—p. 22

-0.1% to +0.1%

Total -0.4% to +0.4% Total error can either increase or decrease SCE’s competitive posture. However, the maximum error is estimated by Aon to be no more than –0.4 percent to +0.4 percent of total compensation. This is in addition to normal survey error, noted on page 4, of plus or minus 5 percent from the overall calculated estimate of competitive posture.

Benchmark Jobs As noted above, this competitive Study was an analysis of total compensation for a statistically significant portion of the SCE organization. Because of the high number of SCE employees in benchmark jobs, Aon is confident the Study accurately estimates competitive posture for the entire company.

Table 3 below presents the amount of coverage the Study provides as a percentage of SCE population. It shows the number of total SCE employees and job titles in each employee category compared with the number of SCE jobs and incumbents that are Study benchmarks.

“Benchmark” jobs are those classification titles that are common across comparator organizations and are found in surveys of competitive data (generally these are “high population” jobs).

The process used to determine benchmark jobs is detailed in the next section. Table 3 shows that the Study covers 75.4 percent of the SCE workforce. Compared with similar studies Aon has conducted, this is high coverage and, in Aon’s opinion, a sound basis for determining the competitiveness of total compensation.

7Estimated by Aon.

8

Page 10: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02 Witnesses: M. Bennett

2021 General Rate Case 8

Table 3: Study Coverage of SCE Population

In Total In Study

Job Category SCE

Population # of

Jobs # of SCE

Incumbents % of SCE

Population # of Jobs % of SCE

Jobs

Physical/Technical 3,628 144 2,349 64.7% 28 19.4%

Clerical 2,574 107 2,201 85.5% 46 43.0%

Professional/Technical 4,421 418 3,663 82.9% 312 74.6%

Manager/Supervisor 1,816 276 1,179 64.9% 153 55.4%

Executive 37 37 17 45.9% 17 45.9%

Overall 12,476 982 9,409 75.4% 556 56.6%

Supporting Materials The appendices are key references in understanding Study results:

Appendix A presents the benchmark jobs in each category. It also presents jobs initially selected as benchmarks but not included in the Study due to a lack of data or appropriate survey match, as indicated.

Appendix B is the list of comparator companies used in the Study.

Appendix C presents the results for each benchmark job within each category. Subtotals are provided at the end of each category and are presented in Table 1 above.

Appendix D explains how the percentages in Table 1 above were derived. It shows average compensation dollars by category and pay element (Table D-2) and estimated total compensation dollars by category and pay element (Table D-3).

Appendix E lists the benchmark Study positions that include LTI values.

Appendix F contains examples of the benefit valuation for SCE and a sample comparator company. This section should be reviewed in conjunction with the methodology section, pages 17 to 21, describing the approach used to value benefits.

Appendix G is documentation summarizing each Team meeting.

Appendix H is a description of the methodology used to measure error in the Study results.

Appendix I is a glossary of terms used in this report.

9

Page 11: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02 Witnesses: M. Bennett

2021 General Rate Case 9

Study Methodology

10

Page 12: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02 Witnesses: M. Bennett

2021 General Rate Case 10

Study Methodology

Overview The principles behind the 2021 Study methodology were held constant to the 2018 Study. They include:

To collect and analyze data on a company-specific basis so that the levels of total compensation (for SCE and for each comparator company) were captured accurately; and

To express both cash and benefit elements of compensation on an equivalent basis for SCE and comparator companies as of a common point in time.

Aon obtained and valued pay and benefits information from comparator companies and SCE. Aon then calculated SCE’s competitive posture versus the comparator companies.

Job Categories SCE jobs were placed into one of five categories including Physical/Technical, Clerical, Professional/Technical, Manager/Supervisor, and Executive consistent with the methodology and approach used in the 2015 and 2018 Studies. Definitions for each job category are provided below. Study results include subtotals for each of these five categories. Nuclear jobs were excluded from the 2018 Study and again from this Study because total compensation for those jobs will be recovered as part of the decommissioning proceeding of the San Onofre Nuclear Generating Station (SONGS) rather than the GRC.

Physical/Technical. Usually, these are field jobs requiring physical activities that are repetitive in

nature. They are found more frequently in utility companies and are typically covered by a collective bargaining agreement (at SCE and at other comparator utilities). Physical jobs often have a formal apprenticeship program and typically do not require college study. Technical jobs are individual contributor jobs that may require some college study, but a college degree is not required. These jobs are subject to the Fair Labor Standards Act8 (“FLSA”) and are categorized as nonexempt.

Clerical. These jobs are nonexempt under the FLSA, typically include work in an office environment, and require activities that are generally routine and clerical in nature. These jobs may require some college study, but a college degree is not required. These jobs may be organized, but most are not—neither at SCE nor at most other comparator companies.

Professional/Technical. These jobs are individual contributor jobs that are typically exempt from the FLSA. Usually, these jobs require a college degree, and the nature of the work involves analytical thought and independent judgment.

Manager/Supervisor. These jobs are exempt from the FLSA; these jobs are primarily responsible for the direction and final product of the work of others.

Executive. This category contains the limited group of company top executives who are responsible for overall direction of the company.

8 The Fair Labor Standards Act (FLSA) of 1938 established overtime, record keeping, and a floor for minimum wage. It also determined the type of positions that are exempt from the overtime provisions. Federal law requires that “nonexempt” positions receive overtime pay for hours in excess of 40 worked in a week. Some states (e.g., California) require overtime pay for nonexempt positions for hours in excess of 8 worked in one day.

11

Page 13: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02 Witnesses: M. Bennett

2021 General Rate Case 11

Benchmark Job Selection and Job Matching In the 2021 Study, Aon attempted to assess competitive posture for enough jobs so that the Team could be confident there was adequate coverage of each category.

The benchmark job selection process included a review by the Team of all benchmark jobs covered in the 2018 Study with consideration of the number of incumbents by job and coverage by job category. The Team agreed to use the 2018 benchmark jobs as a starting point in identifying benchmarks for the 2021 Study. In the 2018 TCS and prior Studies, SCE utilized the generic job benchmarking methodology for benchmarking jobs. This methodology identified functional benchmark matches for jobs within the same level (e.g. all Managers) and then calculated the average of the market data from all functional benchmark matches to develop an overall average market value. That overall average market value was then applied to all jobs in the group. The generic approach was implemented approximately 20 years ago to support the company’s desire to facilitate cross-organization movement of talent. By having the same pay opportunity for all Managers, for example, pay would not be a barrier to moving employees into a variety of jobs at the same level. This allowed employees to expand their knowledge of SCE and more easily move laterally across jobs in various functions in the company.

As part of the total rewards strategy to better align the value and mix of total compensation with external market, SCE determined that while the generic job benchmarking methodology facilitated cross-organization development, it hampered the company’s ability to align pay opportunity to functionally specific market levels, and in some cases, hindered the company’s ability to hire and retain critical talent in high-demand areas of expertise. In the new approach, which was implemented starting in 2017 and is consistent with best practices, SCE continues to benchmark jobs to functional benchmarks but discontinued the practice of determining an average market value and applying that to all jobs by level. Instead the Company utilizes each unique functional benchmark match and related market data to determine the market value of each functional job. The result is a significant increase in the number of benchmark jobs from 31 percent in the 2018 Study to 57 percent in the 2021 Study. This change also improved the alignment between SCE’s pay and market values. As a result of the shift in benchmarking methodology, job coverage increased from 31 percent in the 2018 Study to 57 percent in the 2021 Study.

Aon met with SCE staff familiar with SCE jobs to identify survey matches. During the matching process, Aon and SCE performed the following activities:

Aon identified initial job matches based on a review of the 2018 Study benchmark jobs, SCE job descriptions, and compensation survey databases.

Aon confirmed matches with SCE staff, which in some cases included conducting additional discussions with individuals knowledgeable about a specific job and its actual job duties. Based on the discussions, Aon adjusted some job matches.

Aon made these matches to surveys where it deemed job duties to be 80 percent comparable to the survey job (Aon follows this 80 percent guideline as an industry standard).

When Aon completed the benchmarking process, the coverage of SCE incumbents ranged from 45.9 percent (Executive) to 85.5 percent (Clerical). Overall, there was 75.4 percent coverage of SCE employees by benchmark jobs. This provides a statistically significant level of employee coverage, sufficient for Aon to be confident of the validity of Study results.

Appendix A shows the specific benchmark titles, by category, included in the 2021 Study with the number of SCE incumbents.

12

Page 14: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02 Witnesses: M. Bennett

2021 General Rate Case 12

Labor Market and Comparator Companies For base salary, TCC and LTI, for non-executive positions, the Team selected comparator groups found in existing survey databases. Generally, the comparators included other comparably sized U.S. based utilities for roles specific to the utility industry, general industry organizations for roles that are not utility-specific, or a blend of utility and general industry companies for jobs that can be found in both markets.

For executives, the Team reviewed the 2018 comparator group to determine if each comparator company’s revenue aligned with the methodology guidelines of 0.5 to 2.0 times SCE’s revenue which was $12.65 billion in 2018. All but two companies fell within the range of $6.3 billion to $25.3 billion. NV Energy’s 2018 revenue was $3.0 billion, or about 50 percent below the lower end of the range, and Exelon’s 2018 revenue was $33.5 billion, or about 50 percent above the higher end of the range. The team weighed the pros and cons of removing both companies and replacing them with new companies with revenue that falls within the guidelines. The Team concluded that consistency in the comparator group was important for the reliability of the Study results, and that because both companies were similarly positioned above and below the range, there was a counterbalancing effect if both were retained.

The Team solicited participation from Los Angeles Department of Power and Water (LADWP), Sacramento Municipal Utility District (SMUD) and California Public Utility Commission (CPUC) for inclusion in the executive comparator group for compensation and the comparator groups for benefits for the 2021 Study. SMUD provided input for executive compensation and benefits, LADWP indicated willingness to provide input for the executive compensation group but was unable to submit data in time to meet the deadline required to complete the Study. LADWP did provide input for benefits. CPUC did not respond to requests for participation.

For each job category, it was determined to use the following labor markets:

Physical/Technical, Clerical, Professional/Technical, and Manager/Supervisor – For utility-specific jobs (e.g., Lineman, Troubleman, roles found in Operations, and roles found in

Transmission and Distribution): national energy utilities including those found in the western United States and California.

– For nonutility-specific jobs (e.g., roles found in Finance, Human Resources, and Information Technology): a national group of general industry companies or a blend of utility and general industry if the jobs are found broadly in both.

– The 2021 Study applies the same approach requested by ORA for the 2015 Study and retained in the 2018 Study to utilize national general industry data and apply a geographic differential to adjust for higher cost of labor in Southern California. A geographic differential of 11% (effective December 31, 2018) was obtained from the Economic Research Institute (ERI). This is the same data source used in the 2018 and 2015 Studies. For reference, the 2018 geographic differential was 12% (effective December 31, 2015).

Executive – For utility-specific jobs (e.g. VP Distribution, SVP Transmission & Distribution): national energy

utilities with revenues between $6.3 billion and $25.3 billion plus SMUD, NV Energy, and Exelon

– For nonutility-specific jobs (e.g., SVP & General Counsel, VP Tax): national general industry employers with revenues between $6.3 billion to $25.3 billion.

– Selecting specific companies for use for executive jobs in the Study allowed Aon to obtain total compensation amounts for each comparator by matching average cash compensation with average benefits for each Study job.

13

Page 15: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02 Witnesses: M. Bennett

2021 General Rate Case 13

Because the survey databases used in the Study to cover base salary, bonus, TCC, and LTI do not also include benefits, the Team agreed to use the comparator group used in the 2018 Study to value benefits. This comparator group is made up of utilities and general industry companies with a particular focus on including employers from Southern California. Aon calculated benefits values for each Study company based on information contained in its database of benefit specifications. Aon required both cash compensation and benefits data from comparators in order to determine a total compensation value. Therefore, participation in the Aon Benefits database was required for Study inclusion.

The comparator companies are shown in Appendix B. The company revenue shown reflects 2018 information, which is the effective date of compensation data used for comparator companies and SCE.

Survey and Data Sources and Job Match Validation Benefits data for all Study companies were drawn from the Aon Benefits database. Aon obtained cash compensation data from the best available survey sources. The primary sources, shown by survey provider and the survey used were as follows:

Aon: Radford Total Compensation Survey (RADFORD).

The Edward A. Powell Data Information Solutions Study (EAPDIS).

Mercer: Salary Information Retrieval System (SIRS).

Willis Towers Watson: Energy Services Survey: Executive, Middle Management & Professional Database

Willis Towers Watson: General Industry Survey: Executive, Middle Management & Professional Database

Survey and Data Sources The cash compensation survey and data sources used for each job category are shown in Table 4.

Table 4: Cash Compensation Survey and Data Sources

Job Category Energy Utility General Industry Physical/Technical LADWP compensation data

EAPDIS Willis Towers Watson Energy Services

Clerical EAPDIS (Construction/ Maintenance Acct and Planning, Specialist only)

Willis Towers Watson Energy Services

Mercer: SIRS Aon: Radford

Willis Towers Watson General IndustryProfessional/ Technical

Willis Towers Watson Energy Services Mercer: SIRS Aon: Radford

Willis Towers Watson General IndustryManager/ Supervisor

Willis Towers Watson Energy Services Mercer: SIRS Aon: Radford

Willis Towers Watson General IndustryExecutive Willis Towers Watson Energy Services

SMUD compensation data Willis Towers Watson General Industry

The survey data were provided to Aon in an aggregate (total) manner.

14

Page 16: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02 Witnesses: M. Bennett

2021 General Rate Case 14

Once Aon collected and analyzed compensation data, it noted the number of matches for each job:

If the job had insufficient company matches within the selected comparator subgroup (e.g., utilities had less than five matching companies), the combined group (e.g., utilities plus general industry) was used if appropriate. This approach was applied to Clerical, Professional/Technical, Manager/Supervisor, and Executive positions.

If both the comparator group and the combined group had fewer than five companies matching a job, then Aon excluded the job from the Study.9

Job Match Validation In the 2015 and prior Studies, Aon reviewed a list of benchmark jobs including incumbent counts with the Team. ORA selected approximately 30 jobs from this list for review in the job match validation process. Once ORA selected the list of jobs for validation, Aon compiled the SCE job descriptions and survey source job descriptions for use in validating matches.

9 This threshold complies with the antitrust survey guidelines established by the U. S. Department of Justice and Federal Trade Commission regarding surveys of salaries, wages, and benefits (Statement 6A from the September 1994 “Statements of Antitrust Enforcement Policies”).

15

Page 17: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02 Witnesses: M. Bennett

2021 General Rate Case 15

Elements of Total Compensation

Elements of Compensation—Included The following elements of compensation were included in this Study:

Cash Compensation

Base pay

Short-term (annual) incentives

Total cash compensation (base pay plus short-term incentives)

Noncash Compensation

Employee benefits10

– Defined benefit pension plans

– Defined contribution plans

• Deferred profit sharing

• Savings/thrift plans with company matches

• Savings/thrift plans without company matches

• Stock purchase plans

• Employee stock ownership plans

• 401(k) plans

– Death benefits

• Preretirement group life

• Postretirement group life

• Group survivor’s income

– Long-term disability

– Health care benefits

• Preretirement medical

• Postretirement medical

• Dental and vision coverage

Supplemental executive benefits (Executive category only)

– Medical/dental

– Nonqualified retirement plans

• Defined benefit restoration plans

• Supplemental executive retirement plans

• Defined contribution restoration plans

– Long-term disability

10 Note that not all benefits listed are provided by SCE or by each comparator company.

16

Page 18: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02 Witnesses: M. Bennett

2021 General Rate Case 16

– Nonqualified deferred compensation plans

– Executive death benefits

Long-term incentives

– Stock options and stock appreciation rights

– Deferred stock units

– Performance shares/units

– Restricted stock

– Phantom stock

Elements of Compensation—Excluded As in past Studies, pay elements other than base salary, annual incentives, long-term incentives, and benefits were excluded.

Shift differentials, spot awards, and overtime pay were excluded because this data is not available in surveys on a position-by-position basis, and wide variances exist in their utilization among comparators and SCE. None of these elements of compensation were included in total compensation amounts reported to survey databases used in this Study.

Also, Short-Term Disability was excluded from the Study. This benefit is usually paid by the employer as a salary continuation during the disability period and, therefore, is assumed to be part of an employee’s pay.

17

Page 19: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02 Witnesses: M. Bennett

2021 General Rate Case 17

Valuation of Total Compensation Elements

Base Pay Average base pay data were obtained from SCE and comparators for incumbents in each benchmark job. Hourly pay data were annualized as needed by multiplying by 2,080 hours.

Consistent with the 2015 Study in which ORA requested that SCE use the CPUC-approved labor escalation factor for purposes of adjusting the market data, this factor was used in the 2018 Study and the 2021 Study (3.19 percent for the 2021 GRC). Both Aon and SCE disagree with use of the labor escalation factor as it is not a relevant measure of the rate of change of pay in the general industry and utility industry. However, the Team agreed to utilize the CPUC labor escalation factor to maintain consistency in the methodology used in the 2015 and 2018 Studies.

To illustrate the application of the adjustment factor, general industry survey data that needed to be adjusted by 3 months was increased by 3/12 of the annual rate of 3.19 percent, or 0.80 percent.

SCE base salary information was effective December 31, 2018, so it was not adjusted.

Short -Term (Annual) Incentives (Bonus) Average annual cash incentive payments were collected, by position, from each survey source for comparators and for SCE. Similar to base pay, survey amounts were adjusted by the aging factor to December 31, 2018. SCE amounts, which were paid in March 2018, were also adjusted to the same date.

SCE and survey company incentives were actual amounts paid (not planned or “target” amounts) in 2018 (for 2017 performance) and may include cash profit sharing, gainsharing awards, or other lump-sum payments from ongoing incentive plans requested by each survey. As noted earlier, spot award payments were excluded.

For SCE, these amounts included the employee Short Term Incentive Plan and Executive Incentive Compensation Plan awards. This Study did not examine the operation of these programs; rather, it examined the magnitude of awards provided by SCE to its employees as reported to Aon.

Total Cash Compensation Base pay and short-term incentives, as reported by the comparators and SCE, were totaled for incumbents in each Study position to obtain total cash compensation.

Employee Benefits Benefit values have been computed by Aon’s application of its Benefit Index® methodology. All values are net of employee contributions. Aon uses this proprietary methodology to value each type of employee benefit. (Note that the specific formulae used cannot be shared with third parties, due to potential loss of Aon’s competitive advantage.)

In the 2015 Study, at the request of the ORA and with agreement from SCE, the Team developed benefit values using SCE’s demographic models and assumptions because this approach would best reflect SCE’s benefits values. This methodology change was retained and applied in the 2018 Study and the 2021 Study. SCE’s actual demographic profile is based on employee and retiree data, including age, gender, years of service, rate of opt-out from health care coverage, etc., as well as economic and other

18

Page 20: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02 Witnesses: M. Bennett

2021 General Rate Case 18

assumptions used in valuing SCE’s Retirement Plan and Postretirement Benefits Other than Pensions (PBOPs) such as projected salary increases, average retirement age, and rates of disability. Aon applied SCE’s demographic profile and assumptions to both SCE’s and the comparator companies’ benefit designs to isolate as best as possible the impact on benefit values resulting from differences in plan design.

For each job that was included in the Study (for all companies, including SCE), the average total cash compensation level of the incumbents in that position was used as the basis for benefit valuation.

Aon obtained a detailed description of each comparator company’s benefit program in effect, which it used to value benefits.

Benefits may differ by employee group. For Study purposes, Aon used the primary salaried employee benefit plans for employees hired in 2018. There were no material differences in benefits between employee groups for SCE but there were differences in benefits between employee groups for approximately 21 percent of the Study companies. In most of these cases, this difference was limited to the health care contribution for represented employees, who are primarily found in the Physical/Technical category. For simplicity and cost-effectiveness, the Team asked Aon to use salaried benefits for all Study jobs. This introduces a small amount of error in the Study. Aon estimates this decision overstates the competitors’ total compensation value by less than 0.1 percent of total compensation for most Study positions.

The assumptions used to value benefits using the SCE demographic profiles and assumptions are reflected in annual SCE Retirement Plan and postretirement benefit actuarial valuations and represent the signing actuaries’ best estimates of the future plan experience, taking into consideration past experience and reasonable future expectations. These actuarial valuations are used to determine pension and postretirement benefit expense under Accounting Standards Codification (ASC) Topic 715. Demographic actuarial assumptions, including rates of retirement and employment termination, postretirement health benefit claims and trend assumptions, are reviewed periodically based on actual plan experience and insurance premiums, as well as plan design features and national trends. All actuarial assumptions are reviewed each year for general consistency with emerging plan experience.

In general, the value of each benefit provided by SCE or a comparator company was determined in one of two ways:

Not every benefit is received by every employee in every year. Thus, for each individual in the standard population, the probability of an event, such as disability, is multiplied by the lump-sum value of all amounts to be paid arising from that event. This approach is used for all benefits for which value may be received in the current year; or

Certain benefits are commitments to provide a payment after active employment has ended. These are valued by establishing the benefit as a percentage of pay for the current year. This approach is used to calculate a discounted present value for a future promise.

These values are determined as (1) a percentage of cash compensation (for pay related benefits such as retirement) or (2) flat-dollar amounts (for programs such as medical coverage). Where compensation data are necessary to determine the value for a particular benefit at a given company, the appropriate actual cash compensation level is used.

Benefit values were calculated using each company’s plan features in place for employees hired during 2018.

19

Page 21: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02 Witnesses: M. Bennett

2021 General Rate Case 19

Specific comments on valuation methodology for benefit elements are provided below, and examples are provided in Appendix G:

Defined Benefit Pension: Values for each position in the Study were determined by performing a standard pension valuation of qualified and, if applicable, nonqualified plans on the population. (Qualified plans are those that comply with Internal Revenue Code requirements of funding, vesting, and broad employee participation. Employers make tax-deductible contributions to trusts to provide for the future benefits to their employees. Nonqualified plans are generally provided for select management and highly compensated employees and are not subject to the same funding, vesting, and participation requirements as qualified plans. Employers generally pay such benefits as they come due.) The most important factors considered include the benefit formula, definition of covered pay, early retirement subsidies, subsidized payment forms, and the existence of benefit restoration plans.

Ultimately, pension values represent a consistent annual employer contribution that would be required to provide the promised benefit at retirement.

Defined Contribution: Profit sharing, 401(k), matched savings, broad-based stock purchase, and employee stock ownership plans were included in this area. Employer contributions were adjusted only for eligibility and the possibility of forfeiture.

Group Life: The value of this benefit for each incumbent was determined as the amount of the benefit times the probability of that person dying in the next year, minus any employee contributions. The benefits included were noncontributory and contributory qualified plans, supplemental programs, accidental death and dismemberment coverage, and continuation of benefits on disability.

Survivor Income Annuity Benefits: These programs were valued the same way as group life benefits, except that the benefit amount is converted to the lump-sum value of the annuity stream of payments that would be paid. Benefits paid from a pension upon death of an active employee were included, as were annuities not paid from the pension plan.

Postretirement Death Benefits: Values for postretirement death benefits were determined through a pension valuation approach, except that the benefit being funded was not an annuity payable while the retiree is alive, but a lump sum payable at death. Annuities paid from a pension to the beneficiary upon the retiree’s death were included in the pension value rather than the postretirement death value.

Long Term Disability: This benefit captures the value to the employee of coverage for disability that is longer than six months. The value of the benefit to each incumbent equals the probability of disability times the annuity value of the benefits received, minus employee contributions (if any). Both qualified and nonqualified plans were included. In addition, pension benefits paid to disabled employees prior to normal retirement were included in this category of benefits.

Health Care: The value of preretirement medical, dental, vision, and hearing plans is based on expected claims determined using Aon’s proprietary pricing model combined with SCE’s demographics, considering age and gender in the health care utilization in each of SCE’s employee groups, adjusted for the net effect of employees waiving coverage. For example, executives are assumed to be older, and to have higher utilization of hospital and surgical claims but lower maternity claims than the younger typical salaried or hourly employee (who has lower hospital and surgical claims, but higher maternity claims). A value for each active employee medical plan option is obtained by multiplying the coinsurance percent by: (1) the probability of claims for various medical services, and (2) the typical size of the claims. The types of claims in the valuation of medical coverage include, but are not limited to, hospitalization, surgery, physician visits, lab, x-ray, and prescription drugs. Other out-of-pocket amounts (e.g., deductibles and copays) paid for by the employee are accounted for in developing the value.

20

Page 22: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02 Witnesses: M. Bennett

2021 General Rate Case 20

A purchasing efficiency adjustment was developed based on SCE’s actual costs and applied to each comparator company’s employee medical plan option. Employee contributions, if any, were subtracted from total values to determine the employer-paid value. Within each plan, the distribution of family size elections is based on the structure and patterns of SCE’s population. Overall plan values for each study company are aggregated using the plan enrollment distribution for that company. Definitions of the various delivery models are illustrated below in order of purchasing efficiency to the employer.

– Health Maintenance Organization (HMO): A “prepaid” medical group plan consisting of a defined panel of physicians and facilities. Patients must follow the HMO’s protocols in order to obtain coverage (the primary care physician must approve all care and provides referrals to specialists when necessary). Generally, no benefits are paid for care obtained outside the designated provider panel.

– Exclusive Provider Option (EPO): A medical group plan that mirrors the HMO concept but is self-funded by an employer. Claims are paid as they are incurred; medical care is not “prepaid.”

– Point-of---Service (POS): A medical group plan with two levels of benefits: in-network and out--of--network. Typically, in--network benefits mirror HMO benefits (patients must follow HMO--like protocols). Out--of---network benefits are available but are less comprehensive and typically are subject to higher deductibles and lower coverage levels. Some medical plans are “consumer-driven” plans which usually have larger deductibles but provide Healthcare Reimbursement Account (HRA) or Health Savings Account (HSA) dollars which mitigate the deductible’s impact.

– Preferred Provider Option (PPO): A medical group plan with two levels of benefits similar to a POS plan. The key difference is that the in-network benefits are not subject to HMO-like protocols. Patients can access specialists directly, referrals are not required, and medical utilization reviews are less stringent than in HMOs. Some medical plans are “consumer-driven” plans which usually have larger deductibles but provide (HRA) or (HSA) dollars which mitigate the deductible’s impact.

– Indemnity: A medical group plan without any provider networks or stringent utilization controls. A similar calculation is performed for dental and vision; however, a purchasing efficiency factor is not applied to vision. The types of claims included in the valuation of dental coverage are deductible, coinsurance percentages, annual maximum, and lifetime orthodontia. The additional value attributed to vision coverage, wellness credits, and opt out credits is relatively small. Hearing coverage is typically contributory or combined with medical coverage.

Retiree Medical: Postretirement medical benefit values were calculated in a manner similar to pensions and postretirement death benefits. SCE implemented retiree health care changes that affect all its employees hired on or after December 31, 2017. Aon determined that employees in benchmark jobs have approximately the same age and service as employees in non-benchmark jobs. Therefore, retiree medical values for SCE benchmarks are representative of the entire workforce.

Flexible Credits: Each company’s program is structured differently. Most often, however, flexible credits are granted by benefit type. For example, a company may give $3,000 toward the purchase of medical coverage, $500 toward the cost of dental coverage, enough flexible credits to purchase a 50 percent LTD plan, and enough credits to purchase two times pay life insurance. Credits were allocated back to the benefit types for which they were intended and were treated as offsets to employee contributions. Thus, using the flexible credits in the example above, if the overall medical price tag was $4,000, the $3,000 of flexible credits effectively reduced the employee

21

Page 23: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02 Witnesses: M. Bennett

2021 General Rate Case 21

contribution to $1,000. If the credits for a given benefit area exceeded the price tag for that benefit, the extra credits that result were allocated to other areas where such credits were not sufficient to pay the entire cost. If the flexible credits in total were more than sufficient to purchase all eligible benefits, the excess credits were allocated to health care spending accounts, defined contribution accounts, or cash, depending on the terms of the program.

22

Page 24: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02 Witnesses: M. Bennett

2021 General Rate Case 22

Data Aggregation and Average Benefit Calculation As noted earlier in this report, data from survey providers was provided in aggregated form. This means that Aon did not have access to the base salaries and short-term incentives paid by each company. Instead, Aon had only the total number of incumbents, average base salary, bonus, and total cash compensation (in aggregate) for each survey job.

Based on this information, Aon used the following process to calculate benefit values for each survey benchmark:

For each job, Aon used incumbent-weighted average (aggregated) base salary and bonus data.

Benefits for each comparator company and SCE were valued for each job category.

These values were averaged for utility, general industry, and the combined groups.

These averages were applied to appropriate total cash levels in each job category.

Aon summed the average base salary, bonus, long-term incentives (where eligible), and benefit values to determine an average total compensation figure for the job.

In past studies, Aon conducted test analyses using data provided in both aggregated and non-aggregated form to determine the significance of the differences between averaging benefits across each Study group and calculating benefits values separately for each company.

In the past analyses, Aon found the difference between the approaches was minor, and that the variance was sometimes positive and sometimes negative. Thus, over the group of survey benchmarks, variances offset each other, and the overall differences were negligible.

Aon believes that while error is possible, it would not affect Study results by more than +/- 0.1 percent of total compensation.

Long Term Incentives LTI compensation programs include such plans as:

Stock options;

Deferred stock units/performance units;

Stock appreciation rights;

Restricted stock; and

Phantom stock.

In determining which benchmark jobs were eligible for LTI awards and, therefore, should include LTI values in the 2021 Study, the Team examined eligibility data that reported the percentage of comparator companies that granted LTI for each benchmark job. Similar to the 2018 Study, the Team agreed to include LTI values for jobs that were eligible for LTI at 50% or more of the comparator companies. A total of 127 benchmark jobs met the criteria including 41 Professional/Technical positions, 69 Manager/Supervisor positions, and 17 Executive positions.

The Black-Scholes methodology was used to value LTI for the market and for SCE. The general principle behind the valuation method is to arrive at a figure that corresponds as closely as possible to the intrinsic (economic) value of the long-term incentive award on the date of grant.

23

Page 25: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02 Witnesses: M. Bennett

2021 General Rate Case 23

Stock Options: To recognize the potential value inherent in stock option grants, Aon used the Black Scholes option pricing approach, adjusted for a variety of elements unique to employee stock options. This model does not assume a particular growth in stock price, but rather values the right to buy stock at a fixed price for a certain period of time. The model takes into account several factors in assigning a value to the option. These factors include the following:

– Option price;

– Fair market value on the date of grant;

– Length of exercise period;

– Vesting restrictions on the exercise of options;

– Stock price volatility;

– Projected dividend stream;

– Reasonable discount factor; and

– Recipient turnover.

The character of a stock is largely defined by its dividend yield and price volatility. The pricing model recognizes these characteristics in the valuation of stock options. Simply expressed, an option on a stable security (high dividend yield, relatively little fluctuation in price) is worth less, as a percent of stock price, than an option on an active, growth-oriented stock, which may not pay dividends. An option holder benefits from a stock in which the majority of the investment returns lies in appreciation; the holder of most stock options derives no benefit from dividends on the stock until after exercise of the option occurs.

The design of a stock option plan can have a material impact on an option’s value. An option with a ten-year term, for instance, is worth more than a five-year option, primarily because the recipient has a longer time period over which to benefit from relative stock price volatility.

Other plan design features incorporated into the valuation include dividend equivalents (payment of dividends as if the recipient held the stock), extension of the exercise period beyond termination of employment, and the frequency of grants.

Among Study comparators, Aon has found that utility companies are more likely to pay dividends and their stock price tends to be less volatile than general industry companies. Therefore, the per stock option value (assuming the same exercise price and other design features) Aon ascribes for a utility company would typically be lower (historically 20-25% of stock price at grant) than it ascribes to a stock option of a general industry company (historically 30-40% of stock price at grant).

Deferred Stock Units/Performance Units: The data obtained from each company in the Study includes: actual grant size (in number of shares or units) for each position, target (expected) and maximum award opportunities, performance requirements necessary to earn target and maximum awards, and the related performance measurement period for each grant. The starting point for deferred stock/performance unit valuations generally equals the market price of the company’s stock on the date of award, reduced for the probability of goal attainment. In cases where a performance share plan does not provide for the payment or accrual of dividends, the value is reduced further. The calculated unit or share value then is multiplied by grant size to determine the final grant value. Both deferred stock units, performance shares and units are valued to reflect:

– Volatility of performance;

24

Page 26: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02 Witnesses: M. Bennett

2021 General Rate Case 24

– Maximum award levels;

– Length of performance period; and

– Recipient turnover.

If a deferred stock unit/performance share has the same design characteristics, Aon’s calculated value will be similar across industries.

Stock Appreciation Rights: Similar to stock options, stock appreciation rights (SARs) allow the recipient to obtain the gain from stock price appreciation but require no recipient payment. Generally, SARs are valued in the same manner as stock options.

Restricted Stock: The total value of each restricted stock grant is obtained by multiplying the number of shares granted by the value of the stock on the date of grant. This value is then reduced by an amount equal to the assumed turnover for the period of restriction. In cases where the plan does not provide for the payment or accrual of dividends on restricted shares, or where the recipient must make cash payment for such shares, the value is reduced further. If a restricted share has the same design characteristics, Aon’s calculated value will be similar across industries.

Phantom Stock: Phantom stock programs are valued in one of two ways. If the recipient obtains the full value of the phantom share or unit, then the valuation methodology is similar to that used for restricted stock. Alternatively, if the phantom stock award is based solely on the appreciation in the stock price, then the methodology is similar to that used for stock appreciation rights.

Project Workpapers Project workpapers are submitted along with SCE’s GRC filing. The project workpapers provide additional clarity regarding the Study process. The workpapers, combined with this Study report, provide a clear picture of how the Study was conducted, the decisions made by the Team, and the calculated results. The workpapers include:

A list of all SCE jobs (by job category) used to select Study benchmark jobs.

A list of survey job matches for each Study benchmark.

25

Page 27: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

2021 General Rate Case Index of Workpapers SCE-06, Vol. 03, Pt. 2

DOCUMENT PAGE(S) SCE Job List 3-17 Survey Job Matches 18-70

 

Page 28: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

2021 General Rate Case: Total Compensation Study WorkpapersSouthern California Edison

August 2019

1

Page 29: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

SCE Job ListSurvey Job Matches

116

Workpapers

2

Page 30: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

SCE Job List

# SCEEEs Comment

Study # and Job Title

Physical/Technical5Control Operator1

15Driver Hvy Transp244Electn Constrn3

158Form Electl Crew4

2Groundman5367Groundman6

1Handlr Mtrl7

66Handlr Mtrl81Handlr Sr Mtrl9

18Hydro Mechanical Maintenance Tech10

14Hydro Operator Mechanic1148Inspector, Electrical System12

666Journeyman Lineman1364Meter Technician 514

14Operator Control15

12Operator, Hydro Station System16132Operator, System17

111Opr Substation18

98Repr Fld Srvce 2198Splcr Subs Cable20

22SPLICER CABLE21

131Substation Electrician223Techn Chemical23

25Techn Comnctn24

40Technician2576Technician, Test26

54 Insufficient DataTechnician, Test Supervising27205Troubleman28

3Welder Cnstrn29

1Aon

3

Page 31: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

# SCEEEs Comment

Study # and Job Title

Clerical3Accounting Support Role30

108Analyst-Program/Project 131

1Business Analysis Role32

197Construction/Maintenance Acct339Construction/Material Coordinator 134

22Customer Solutions Representative 135

7Customer Specialist 136194Energy Advisor 137

58Energy Advisor 1 - L138

56Executive Assistant 1399Mailing & Logistic, Specialist 140

7Accounting Assistant 2417Administrative Aide 242

231Analyst-Business 243

300Analyst-Program/Project 24447Construction/Material Coordinator 245

42Customer Solutions Representative 246

2Customer Specialist 24770Energy Advisor 248

42Energy Advisor 2 - L149

6Energy Advisor 2 - L25031Executive Assistant 251

25Legal Administrative Assistant 25215Mailing & Logistic, Specialist 253

10Accounting Assistant 354

103Administrative Aide 35529Construction/Material Coordinator 356

14Energy Advisor 357

8Energy Advisor 3 - L15885Administrative Assistant59

1Associate Specialist60

1Associate Specialist611 Insufficient DataAssociate Specialist62

1Associate Specialist63

1 Insufficient DataAssociate Specialist641Associate Specialist65

1Associate Specialist662Associate Specialist67

2Associate Specialist68

67Design/Drafting, Assoc Spec6918GIS Tech Spec, Assoc Spec70

114Design/Drafting, Specialist71

33GIS Tech Spec, Spec72216Planning, Specialist73

1Specialist74

2Aon

4

Page 32: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

# SCEEEs Comment

Study # and Job Title

Clerical1Specialist752Specialist76

2Specialist77

3Aon

5

Page 33: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

# SCEEEs Comment

Study # and Job Title

Professional/Technical2Administrative Support Role78

179Analyst-Business 379

218Analyst-Program/Project 380

27Customer Solutions Representative 38116Land Services Agent 382

21Land Services Agent 483

6Accountant Associate843Associate Specialist85

1Associate Specialist86

2Associate Specialist871Associate Specialist88

7Financl Anlys, Assoc Spec8918Accountant90

7Claims Resolution, Spec91

69Engineer 1928Financl Anlys, Specialist93

4IS Security, Specialist94

5Modelg, Fcstg & Econ Anlys, Spec959Proprietary Telcom Sys, Specialist96

9Security, Specialist97

1Specialist981Specialist99

3Specialist1001Specialist101

2Specialist102

1Specialist1032Specialist104

2Specialist105

2Specialist1061Specialist107

2Specialist108

2Specialist1093Specialist110

2Specialist111

1Specialist1122Specialist113

1Specialist1142Specialist115

1Specialist116

2Specialist1171Specialist118

1Specialist119

1Specialist1201Specialist121

1Specialist122

4Aon

6

Page 34: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

# SCEEEs Comment

Study # and Job Title

Professional/Technical8Tech Training, Specialist123

12Tlnt Acquisition, Specialist124

11Accountant Senior125

20Acct Mgmt, Sr Specialist1264Aircraft Mgmt & Ops, Sr Specialist127

7App Dev, Sr Spec128

6Auditor Senior12942Bus Ops Anlys, Sr Specialist130

8Bus Process Imprvmt, Sr Specialist131

23Bus Sys Anlys, Sr Specialist1327Business Continuation, Sr Specialist133

13Contract Admin, Sr Specialist1349Elec Sys/Grid & Blk Pwr Trng, Sr Spec135

7Elec Trans &/Or Distr Prj Mgr, Sr Spec136

8Employee Relations, Sr Spec13790Engineer 2138

9Engy Del / Distrib, Sr Specialist139

5Engy Eff/Cnsv Cmrcl/Ind Dsn, Sr Spec14017Engy Effcncy / Cnsvrtion, Sr Specialist141

14Engy Mgmt Sys (EMS) Dev, Sr Spec142

7Engy Mktg & Trdg Fncl Anlys, Sr Spec1437Engy Trdg Ops / Support, Sr Specialist144

8Engy Trdg Schdlng, Sr Specialist14513Envir Science, Sr Specialist146

21Financl Anlys, Sr Specialist147

11GIS Tech Spec, Sr Spec1485Info Tchnlgy Prj Mgmt, Sr Specialist149

12IS Security, Sr Specialist150

5IT Dev, Sr Specialist1516IT Operations, Sr Specialist152

4Labor Reltns, Sr Specialist153

4Learning & Dev, Sr Specialist1544Mgmt Data Anlys, Sr Specialist155

16Modelg, Fcstg & Econ Anlys, Sr Spec156

212Planning, Sr Spec15710Power Systems Planner 2158

9Process Tech Spec, Sr Specialist15930Proprietary Telcom Sys, Sr Specialist160

10Q A Methods, Sr Specialist161

65Q Cntrl / Inspection, Sr Specialist1629Rates, Sr Specialist163

2Senior Specialist164

1Senior Specialist1652Senior Specialist166

3Senior Specialist167

5Aon

7

Page 35: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

# SCEEEs Comment

Study # and Job Title

Professional/Technical2Senior Specialist1682Senior Specialist169

1Senior Specialist170

2Senior Specialist1711Senior Specialist172

2Senior Specialist173

3Senior Specialist1742Senior Specialist175

1Senior Specialist176

1Senior Specialist1771Senior Specialist178

2Senior Specialist1792Senior Specialist180

1Senior Specialist181

2Senior Specialist1822Senior Specialist183

2Senior Specialist184

2Senior Specialist1851Senior Specialist186

2Senior Specialist187

2Senior Specialist1881Senior Specialist189

3Senior Specialist1901Senior Specialist191

3Senior Specialist192

3Senior Specialist1932Senior Specialist194

1Senior Specialist195

3Senior Specialist1962Senior Specialist197

1Senior Specialist198

2Senior Specialist1992Senior Specialist200

5Sup Chain Dev & Opt, Sr Specialist201

23Tech Purchasing, Sr Specialist20263Tech Spec, Sr Specialist203

20Tech Training, Sr Specialist20423Vgtatn Mgmt & For Gnrlst, Sr Spec205

10Acct Mgmt, Advisor206

9Acctg, Advisor2072Advisor208

3Advisor209

1Advisor2102Advisor211

3Advisor212

6Aon

8

Page 36: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

# SCEEEs Comment

Study # and Job Title

Professional/Technical1Advisor2132Advisor214

1Advisor215

1Advisor2161Advisor217

2Advisor218

3Advisor2193Advisor220

1Advisor221

1Advisor2221Advisor223

1Advisor2242Advisor225

1Advisor226

1Advisor2271Advisor228

3Advisor229

2Advisor2302Advisor231

1Advisor232

1Advisor2332Advisor234

1Advisor2353Advisor236

1Advisor237

1Advisor2381Advisor239

1Advisor240

1Advisor2413Advisor242

3Advisor243

3Advisor2442Advisor245

1Advisor246

2Advisor2471Advisor248

1Advisor2491Advisor250

2Advisor251

3Advisor2522Advisor253

7Audits Advisor254

95Bus Ops Anlys, Advisor2558Bus Process Imprvmt, Advisor256

4Bus Sys Anlys, Advisor257

7Aon

9

Page 37: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

# SCEEEs Comment

Study # and Job Title

Professional/Technical13Business Continuation, Advisor2588Business Controls, Advisor259

14Client Svc Del Mgmt, Advisor260

4Comp, Advisor26110Contract Admin, Advisor262

8Corp Comm, Advisor263

5Creative Dsgn Svcs, Advisor2646Elec Sys/Grid & Blk Pwr Trng, Advisor265

93Elec Trans & / Or Distrib Prj Mgr266

5 Insufficient DataEmerg Tech Acq & Implm Prj Mgr267192Engineer 3268

57Engy Effcncy / Cnsvrtion, Advisor2699Engy Mgmt Sys (EMS) Dev, Advisor270

5Engy Mktg & Trdg Financl Anlys, Advisor271

6Engy Trdg Ops / Support, Advisor27255Envir Science, Advisor273

22Financl Anlys, Advisor274

34Govt Reltns, Advisor27540Health & Sfty, Advisor276

46Info Tchnlgy Prj Mgr277

5Investigations, Advisor27834IS Security, Advisor279

14IT Arch (Systems Design), Advisor2805IT Dev, Advisor281

7IT Operations, Advisor282

30IT Outsrcing Mgmt, Advisor2834Lgl Support, Advisor284

22Major Cnstrn Prj Mgr285

12Materials Mgmt, Advisor2865Mktg Comm, Advisor287

4Mktg Prgm Mgmt, Advisor288

25Modelg, Fcstg & Econ Anlys, Advisor28968Planning, Advisor290

18Power Systems Planner 3291

11Prdctve Anlytcs/Data Science, Advisor29265Prj Mgr293

5Proj Cntrl Svcs Prj Mgr29425Proprietary Telcom Sys, Advisor295

14Q A Methods, Advisor296

17Q Cntrl / Inspection, Advisor2974Rates, Advisor298

12Real Estate & Fclties, Advisor299

36Reg Affairs & Compl, Advisor30012Reg Compl Tech Ruls & Stds, Advisor301

4Security, Advisor302

8Aon

10

Page 38: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

# SCEEEs Comment

Study # and Job Title

Professional/Technical4Social Media Mktg, Advisor3034Strgc Plng, Advisor304

6Sup Chain, Advisor305

8Tax, Advisor30640Tech Purchasing, Advisor307

28Tech Spec, Advisor308

4Trade Shws / Evnts, Advisor3095Web Cntnt Mgmt / Prdctn, Advisor310

9Workers Comp, Advisor311

46Bus Ops Anlys, Sr Advisor31210Bus Process Imprvmt, Sr Advisor313

10Business Continuation, Sr Advisor31419Client Svc Del Mgmt, Sr Advisor315

15Corp Comm, Sr Advisor316

10Envir Affairs & Compl, Sr Advisor31723Envir Science, Sr Advisor318

27Financl Anlys, Sr Advisor319

10Govt Reltns, Sr Advisor3208Health & Sfty, Sr Advisor321

15HR Gnrlst / Consult, Sr Advisor322

10Investigations, Sr Advisor3238IS Security, Sr Advisor324

15IT Arch (Systems Design), Sr Advisor3256IT Asset Mgmt, Sr Advisor326

7IT Dev, Sr Advisor327

5IT Operations, Sr Advisor32819IT Outsrcing Mgmt, Sr Advisor329

6IT Svc Del & Relation Mgmt, Sr Advisor330

4Learning & Dev, Sr Advisor33122Modelg, Fcstg & Econ Anlys, Sr Advisor332

8Org Dev, Sr Advisor333

6Q A Methods, Sr Advisor33413Rates, Sr Advisor335

42Reg Affairs & Compl, Sr Advisor336

12Reg Compl Tech Ruls & Stds, Sr Advisor33794Senior Engineer338

7Senior Power Systems Planner3392Senior Advisor340

1Senior Advisor341

1Senior Advisor3421Senior Advisor343

1Senior Advisor344

1Senior Advisor3451Senior Advisor346

1Senior Advisor347

9Aon

11

Page 39: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

# SCEEEs Comment

Study # and Job Title

Professional/Technical3Senior Advisor3481Senior Advisor349

2Senior Advisor350

1Senior Advisor3511Senior Advisor352

2Senior Advisor353

1Senior Advisor3541Senior Advisor355

2Senior Advisor356

2Senior Advisor3571Senior Advisor358

3Senior Advisor3591Senior Advisor360

2Senior Advisor361

3Senior Advisor3622Senior Advisor363

1Senior Advisor364

2Senior Advisor3652Senior Advisor366

3Senior Advisor367

1Senior Advisor3682Senior Advisor369

1Senior Advisor3702Senior Advisor371

3Senior Advisor372

2Senior Advisor3733Senior Advisor374

1Senior Advisor375

3Senior Advisor3763Senior Advisor377

3Senior Advisor378

2Senior Advisor3793Senior Advisor380

2Senior Advisor381

1Senior Advisor3821Senior Advisor383

17Strgc Plng, Sr Advisor3847Sup Chain, Sr Advisor385

5Tax, Sr Advisor386

20Tech Spec, Sr Advisor3874Tech Training, Sr Advisor388

8Consulting Engineer389

2Mgr390

10Aon

12

Page 40: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

# SCEEEs Comment

Study # and Job Title

Manager/Supervisor1Sup3913Sup392

1Sup393

1Sup3945Sup, Apparatus395

12Sup, Cnstrn396

12Sup, Engy Del / Distrib39778Sup, Field398

82Sup, General Foreman399

38Sup, Project General Sup4005Sup, Real Estate & Fclties401

5Sup, Substn Ops4027 Insufficient DataElec Trans & / Or Distrib Sr Prj Mgr403

4 Insufficient DataEmerg Tech Acq & Implm Sr Prj Mgr404

5Eng Sr Prj Mgr4057Fclties Cnstrn Sr Prj Mgr406

6Info Tchnlgy Sr Prj Mgr407

8Major Cnstrn Sr Prj Mgr4089 Insufficient DataProj Cntrl Svcs Sr Prj Mgr409

57Senior Attorney410

2 Insufficient DataSenior Advisor4112Senior Advisor412

43Sr Prj Mgr4133Mgr414

1Mgr415

3Mgr4161Mgr417

1Mgr418

2Mgr4192Mgr420

1Mgr421

1Mgr4222Mgr423

1Mgr424

1Mgr4251Mgr426

1Mgr4275Mgr, Acctg428

19Mgr, Bus Ops Anlys429

4Mgr, Contract Admin4307Mgr, Elect Trans Ops431

51Mgr, Eng432

27Mgr, Engy Del / Distrib43314Mgr, Engy Effcncy434

7Mgr, Health & Sfty435

11Aon

13

Page 41: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

# SCEEEs Comment

Study # and Job Title

Manager/Supervisor10Mgr, Hum Resources4364Mgr, IT Dev437

7Mgr, IT Ops438

5Mgr, Modeling, Fcstg & Econ Anlys43916Mgr, Op Mid440

15Mgr, Project Mgmt441

4Mgr, Q A / Process Imprvmt4428Mgr, Real Estate & Fclties443

6Mgr, Sfty & Training444

24Mgr, Tech Spec4457Mgr, Trnsprtn Svcs446

4Mgr, Vegetation Mgmt & Forestry4471Sr Mgr448

2Sr Mgr449

1Sr Mgr4501Sr Mgr451

1Sr Mgr452

1Sr Mgr4533Sr Mgr454

1Sr Mgr455

1Sr Mgr4563Sr Mgr457

1Sr Mgr4581Sr Mgr459

2Sr Mgr460

3Sr Mgr4618Sr Mgr, Account Mgmt462

6Sr Mgr, Acctg463

7Sr Mgr, Audit4645Sr Mgr, Bus Cont465

18Sr Mgr, Bus Ops Anlys466

4Sr Mgr, Communications46734Sr Mgr, Eng468

24Sr Mgr, Engy Del / Distrib469

11Sr Mgr, Engy Effcncy4704Sr Mgr, Engy Mktg & Trdg471

6Sr Mgr, Engy Trdg Ops47215Sr Mgr, Envir473

11Sr Mgr, Finance474

4Sr Mgr, Health & Sfty47515Sr Mgr, Hum Resources476

9Sr Mgr, IT Dev477

9Sr Mgr, IT Ops47810Sr Mgr, Modeling, Fcstg & Econ Anlys479

49Sr Mgr, Project Mgmt480

12Aon

14

Page 42: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

# SCEEEs Comment

Study # and Job Title

Manager/Supervisor5Sr Mgr, Q A / Process Imprvmt481

14Sr Mgr, Reg Affairs & Compl482

8Sr Mgr, Strategic Plng / Corp Dev483

10Sr Mgr, Supply Chain48412Sr Mgr, Tech Spec485

1Director486

1Director4872Director488

1Director489

1Director4901Director491

1Director4921Director493

1Director494

1Director4951Director496

1Director497

1Director4981Director499

1Director500

1Director5011Director502

1Director5031Director504

1Director505

1Director5061Director507

1Director508

1Director5091Director510

1Director511

12Director & Managing Attorney5121Managing Director513

1Managing Director514

1Managing Director5151Managing Director516

3Prin Mgr5171Prin Mgr518

1Prin Mgr519

3Prin Mgr5201Prin Mgr521

2Prin Mgr522

2Prin Mgr5233Prin Mgr524

1Prin Mgr525

13Aon

15

Page 43: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

# SCEEEs Comment

Study # and Job Title

Manager/Supervisor1Prin Mgr5263Prin Mgr527

2Prin Mgr528

2Prin Mgr5294Prin Mgr, Account Mgmt530

4Prin Mgr, Acctg531

7Prin Mgr, Bus Ops Anlys5324Prin Mgr, Elect Trans Ops533

12Prin Mgr, Eng534

17Prin Mgr, Engy Del / Distrib5354Prin Mgr, Engy Effcncy536

6Prin Mgr, Engy Mktg & Trdg53710Prin Mgr, Finance538

5Prin Mgr, Govt Relations539

5Prin Mgr, Health & Sfty54013Prin Mgr, Hum Resources541

5Prin Mgr, IT Dev542

5Prin Mgr, IT Ops5437Prin Mgr, Modeling, Fcstg & Econ Anlys544

23Prin Mgr, Project Mgmt545

18Prin Mgr, Reg Affairs & Compl5466Prin Mgr, Supply Chain547

14Aon

16

Page 44: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

# SCEEEs Comment

Study # and Job Title

Executive1VP5481VP549

1VP550

1VP5511VP552

1VP553

1VP5541VP555

1SVP & CFO, SCE556

1SVP & General Counsel5571SVP558

1SVP Transmission & Distribution5591SVP560

1Chief Executive Officer SCE561

1EVP5621EVP563

1President and CEO, EIX564

15Aon

17

Page 45: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Survey Job Matches

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Physical/TechnicalControl Operator1 5

EAPDIS 303 CONTROL OPERATOR 2,219

Driver Hvy Transp2 15EAPDIS 408 TRUCK DRIVER (HEAVY) 261

Electn Constrn3 44DWP 0995 - Step 1 Constr Eltl Mchc 214EAPDIS 305 ELECTRICIAN 1,745

Form Electl Crew4 158DWP 3873 - Step 5 Elec Distr Mech Supv 97EAPDIS 114 LEAD LINE MECHANIC (OVERHEAD/UNDERGROUND) 3,940

Groundman5 2DWP 0994 - Step 1 Construction Electrical Helper 68EAPDIS 115 LINE HELPER (GROUND MECHANIC) 1,327

Groundman6 367DWP 0994 - Step 1 Construction Electrical Helper 68EAPDIS 115 LINE HELPER (GROUND MECHANIC) 1,327

Handlr Mtrl7 1DWP 1835 - Step 5 Storekeeper 94EAPDIS 405 STOREKEEPER/HANDLER 1,543

Handlr Mtrl8 66DWP 1835 - Step 5 Storekeeper 94EAPDIS 405 STOREKEEPER/HANDLER 1,543

Handlr Sr Mtrl9 1DWP 1837 - Step 5 Senior Storekeeper 43EAPDIS 404 LEAD STOREKEEPER 405

Hydro Mechanical Maintenance Tech10 18EAPDIS 308 HYDRO O&M TECHNICIAN 160

Hydro Operator Mechanic11 14EAPDIS 308 HYDRO O&M TECHNICIAN 160

Inspector, Electrical System12 48EAPDIS 121 INSPECTOR, ELECTRICAL SYSTEM 380

Journeyman Lineman13 666DWP 3879 - Step 5 Electric Distribution Mechanic 465EAPDIS 116 LINE MECHANIC (OVERHEAD/UNDERGROUND) 10,831

Meter Technician 514 64DWP 7512 - Step 5 Electrical Tester 121EAPDIS 117 METER MECHANIC 972

Operator Control15 14EAPDIS 303 CONTROL OPERATOR 2,219

16Aon

18

Page 46: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Physical/TechnicalOperator, Hydro Station System16 12

EAPDIS 307 OPERATOR HYDRO 259

Operator, System17 132TW-MM-ENGY EDD010-T3 Electric Distribution Systems Operations - Senior (T3) 36

Opr Substation18 111EAPDIS 106 DISTRIBUTION DISPATCHER 1,301

Repr Fld Srvce 219 98EAPDIS 122 METER SERVICE REPRESENTATIVE 194

Splcr Subs Cable20 8EAPDIS 100 CABLE SPLICER 687

SPLICER CABLE21 22EAPDIS 100 CABLE SPLICER 687

Substation Electrician22 131DWP 3863 - Step 5 Electrician 3EAPDIS 118 SUBSTATION MECHANIC / TECHNICIAN 2,299

Techn Chemical23 3EAPDIS 301 CHEMICAL TECHNICIAN 389

Techn Comnctn24 25DWP 3802 - Step 5 Communications Cable Worker 19EAPDIS 400 COMMUNICATIONS TECHNICIAN 433

Technician25 40DWP 3711 - Step 5 Equipment Mechanic 53EAPDIS 406 MOTOR VEHICLE MECHANIC 1,435

Technician, Test26 76EAPDIS 312 RELAY MECHANIC/TECHNICIAN 588

Troubleman28 205DWP 3884 - Step 5 Line Patrol Mechanic No DataEAPDIS 119 TROUBLE SERVICE MECHANIC 2,778

Welder Cnstrn29 3DWP 3796 - Step 5 Welder 36EAPDIS 300 CERTIFIED WELDER 1,042

17Aon

19

Page 47: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

ClericalAccounting Support Role30 3

MHRC-SIRS C500-1 Accounting Support - Level 1 Support 447RADFORD 9101 Accounting Support 1 18TW-MM-GEN AFB060-U1 Accounts Payable/Receivable - Entry (U1) 569TW-MM-ENGY AFB060-U1 Accounts Payable/Receivable - Entry (U1) 13

Analyst-Program/Project 131 108MHRC-SIRS A480-1 Project Management - Level 1 Administrative 1,610RADFORD 6631 Project (Admin) Mgr 1 113TW-MM-GEN APM000-P1 Project/Program Management Generalist/Multidiscipline - Entry (P1) 2,877TW-MM-ENGY APM000-P1 Project/Program Management Generalist/Multidiscipline - Entry (P1) 37

Business Analysis Role32 1MHRC-SIRS A400-1 Administration - Generalist - Level 1 Administrative 1,210RADFORD 4681 Business Process Analyst 1 21TW-MM-GEN AEM070-P1 Business Operations Analysis - Entry (P1) 825TW-MM-ENGY AEM070-P1 Business Operations Analysis - Entry (P1) 200

Construction/Maintenance Acct33 197EAPDIS 411 INVOICE CONTROL CLERK 96MHRC-SIRS C500-4 Accounting Support - Level 4 Support 1,014RADFORD 9104 Accounting Support 4 82TW-MM-GEN AFB060-U4 Accounts Payable/Receivable - Lead/Advanced (U4) 118TW-MM-ENGY AFB060-U4 Accounts Payable/Receivable - Lead/Advanced (U4) 9

Construction/Material Coordinator 134 9MHRC-SIRS A375-1 Material Planning and Control - Level 1 Administrative 863MHRC-SIRS A427-1 Production Planning and Scheduling Control - Level 1

Administrative1,018

RADFORD 4401 Materials Planner 1 32TW-MM-GEN ASC015-P1 Materials Planning/Scheduling - Entry (P1) 858TW-MM-GEN ASC020-P1 Materials Management - Entry (P1) 293TW-MM-ENGY ASC015-P1 Materials Planning/Scheduling - Entry (P1) No DataTW-MM-ENGY ASC020-P1 Materials Management - Entry (P1) 8

Customer Solutions Representative 135 22MHRC-CON CSV.02.051.S20 Contact Center Customer Service: Technical - Experienced Para-

Professional (S2)3,092

MHRC-SIRS C527-2 Customer Service Representative - Level 2 Support 4,605TW-MM-GEN AMS020-U2 Customer Contact Center Generalist/Multidiscipline - Intermediate

(U2)25,293

TW-MM-ENGY AMS020-U2 Customer Contact Center Generalist/Multidiscipline - Intermediate (U2)

2,257

Customer Specialist 136 7MHRC-SIRS C527-1 Customer Service Representative - Level 1 Support 1,467TW-MM-GEN AMS010-U1 Customer Service - Entry (U1) 10,741TW-MM-ENGY AMS010-U1 Customer Service - Entry (U1) No Data

Energy Advisor 137 194TW-MM-GEN AMS020-P2 Customer Contact Center Generalist/Multidiscipline - Intermediate

(P2)1,059

TW-MM-ENGY AMS020-P2 Customer Contact Center Generalist/Multidiscipline - Intermediate (P2)

80

Energy Advisor 1 - L138 58TW-MM-GEN AMS020-P2 Customer Contact Center Generalist/Multidiscipline - Intermediate

(P2)1,059

TW-MM-ENGY AMS020-P2 Customer Contact Center Generalist/Multidiscipline - Intermediate (P2)

80

18Aon

20

Page 48: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

ClericalExecutive Assistant 139 56

RADFORD 6502 Executive Assistant 2 No DataTW-MM-GEN AAS042-U2 Secretarial/Executive Administrative Assistance - Intermediate (U2) 3,617TW-MM-ENGY AAS042-U2 Secretarial/Executive Administrative Assistance - Intermediate (U2) 351

Mailing & Logistic, Specialist 140 9MHRC-SIRS C620-1 Mail Clerk - Level 1 Support 165MHRC-SIRS M542-1 Driver - Light Vehicles - Level 1 Support No DataRADFORD 9601 Mail Clerk 1 16

Accounting Assistant 241 7MHRC-SIRS C500-2 Accounting Support - Level 2 Support 1,749RADFORD 9102 Accounting Support 2 128TW-MM-GEN AFB060-U2 Accounts Payable/Receivable - Intermediate (U2) 612TW-MM-ENGY AFB060-U2 Accounts Payable/Receivable - Intermediate (U2) 30

Administrative Aide 242 7MHRC-SIRS C584-2 Secretary - Level 2 Support 4,369MHRC-SIRS C590-2 Administrative Functional Support - Level 2 Support 6,697RADFORD 9902 Administrative Support 2 135TW-MM-GEN AAS041-U2 Secretarial/Administrative Assistance - Intermediate (U2) 15,932TW-MM-ENGY AAS041-U2 Secretarial/Administrative Assistance - Intermediate (U2) 933

Analyst-Business 243 231MHRC-SIRS A400-2 Administration - Generalist - Level 2 Administrative 4,110RADFORD 4682 Business Process Analyst 2 107TW-MM-GEN AEM070-P2 Business Operations Analysis - Intermediate (P2) 1,522TW-MM-ENGY AEM070-P2 Business Operations Analysis - Intermediate (P2) 649

Analyst-Program/Project 244 300MHRC-SIRS A480-2 Project Management - Level 2 Administrative 4,117RADFORD 6632 Project (Admin) Mgr 2 352TW-MM-GEN APM000-P2 Project/Program Management Generalist/Multidiscipline -

Intermediate (P2)7,731

TW-MM-ENGY APM000-P2 Project/Program Management Generalist/Multidiscipline - Intermediate (P2)

717

Construction/Material Coordinator 245 47MHRC-SIRS A375-2 Material Planning and Control - Level 2 Administrative 2,154MHRC-SIRS A427-2 Production Planning and Scheduling Control - Level 2

Administrative1,943

RADFORD 4402 Materials Planner 2 91TW-MM-GEN ASC015-P2 Materials Planning/Scheduling - Intermediate (P2) 2,174TW-MM-GEN ASC020-P2 Materials Management - Intermediate (P2) 847TW-MM-ENGY ASC015-P2 Materials Planning/Scheduling - Intermediate (P2) 40TW-MM-ENGY ASC020-P2 Materials Management - Intermediate (P2) 141

Customer Solutions Representative 246 42MHRC-CON CSV.02.051.S30 Contact Center Customer Service: Technical - Senior Para-

Professional (S3)4,547

MHRC-SIRS C527-3 Customer Service Representative - Level 3 Support 4,083TW-MM-GEN AMS020-U3 Customer Contact Center Generalist/Multidiscipline - Senior (U3) 7,972TW-MM-ENGY AMS020-U3 Customer Contact Center Generalist/Multidiscipline - Senior (U3) 1,631

Customer Specialist 247 2MHRC-SIRS C527-2 Customer Service Representative - Level 2 Support 4,605TW-MM-GEN AMS010-U2 Customer Service - Intermediate (U2) 16,880TW-MM-ENGY AMS010-U2 Customer Service - Intermediate (U2) 60

19Aon

21

Page 49: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

ClericalEnergy Advisor 248 70

TW-MM-GEN AMS020-P3 Customer Contact Center Generalist/Multidiscipline - Career (P3) 460TW-MM-ENGY AMS020-P3 Customer Contact Center Generalist/Multidiscipline - Career (P3) 17

Energy Advisor 2 - L149 42TW-MM-GEN AMS020-P3 Customer Contact Center Generalist/Multidiscipline - Career (P3) 460TW-MM-ENGY AMS020-P3 Customer Contact Center Generalist/Multidiscipline - Career (P3) 17

Energy Advisor 2 - L250 6TW-MM-GEN AMS020-P3 Customer Contact Center Generalist/Multidiscipline - Career (P3) 460TW-MM-ENGY AMS020-P3 Customer Contact Center Generalist/Multidiscipline - Career (P3) 17

Executive Assistant 251 31RADFORD 6503 Executive Assistant 3 451TW-MM-GEN AAS042-U3 Secretarial/Executive Administrative Assistance - Senior (U3) 5,176TW-MM-ENGY AAS042-U3 Secretarial/Executive Administrative Assistance - Senior (U3) 857

Legal Administrative Assistant 252 25HILDE-LAW LS1 Legal Secretary I 270MHRC-SIRS C587-4 Secretary - Legal - Level 4 Support 127TW-MM-GEN ALS040-U4 Legal Secretarial/Administrative Assistance - Lead/Advanced (U4) 248TW-MM-ENGY ALS040-U4 Legal Secretarial/Administrative Assistance - Lead/Advanced (U4) No Data

Mailing & Logistic, Specialist 253 15MHRC-SIRS C620-2 Mail Clerk - Level 2 Support 161MHRC-SIRS M542-2 Driver - Light Vehicles - Level 2 Support 4,437RADFORD 9602 Mail Clerk 2 58

Accounting Assistant 354 10MHRC-SIRS C500-3 Accounting Support - Level 3 Support 2,000RADFORD 9103 Accounting Support 3 172TW-MM-GEN AFB060-U3 Accounts Payable/Receivable - Senior (U3) 560TW-MM-ENGY AFB060-U3 Accounts Payable/Receivable - Senior (U3) 45

Administrative Aide 355 103DWP 1368 - Step 5 Senior Clerk Typist 456MHRC-SIRS C584-3 Secretary - Level 3 Support 7,073RADFORD 9913 Administrative Assistant 3 476TW-MM-GEN AAS041-U3 Secretarial/Administrative Assistance - Senior (U3) 16,561TW-MM-ENGY AAS041-U3 Secretarial/Administrative Assistance - Senior (U3) 2,257

Construction/Material Coordinator 356 29MHRC-SIRS A375-3 Material Planning and Control - Level 3 Administrative 2,485MHRC-SIRS A427-3 Production Planning and Scheduling Control - Level 3

Administrative2,105

RADFORD 4403 Materials Planner 3 99TW-MM-GEN ASC015-P3 Materials Planning/Scheduling - Career (P3) 1,502TW-MM-GEN ASC020-P3 Materials Management - Career (P3) 643TW-MM-ENGY ASC015-P3 Materials Planning/Scheduling - Career (P3) 55TW-MM-ENGY ASC020-P3 Materials Management - Career (P3) 93

Energy Advisor 357 14TW-MM-GEN AMS020-P4 Customer Contact Center Generalist/Multidiscipline - Specialist (P4) 17TW-MM-ENGY AMS020-P4 Customer Contact Center Generalist/Multidiscipline - Specialist (P4) No Data

Energy Advisor 3 - L158 8TW-MM-GEN AMS020-P4 Customer Contact Center Generalist/Multidiscipline - Specialist (P4) 17TW-MM-ENGY AMS020-P4 Customer Contact Center Generalist/Multidiscipline - Specialist (P4) No Data

20Aon

22

Page 50: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

ClericalAdministrative Assistant59 85

MHRC-SIRS C584-4 Secretary - Level 4 Support 4,932RADFORD 9914 Administrative Assistant 4 603TW-MM-GEN AAS041-U4 Secretarial/Administrative Assistance - Lead/Advanced (U4) 4,193TW-MM-ENGY AAS041-U4 Secretarial/Administrative Assistance - Lead/Advanced (U4) 90

Associate Specialist60 1MHRC-SIRS A400-1 Administration - Generalist - Level 1 Administrative 1,210TW-MM-GEN AAS000-P1 Administrative Services Generalist/Multidiscipline - Entry (P1) 2,391TW-MM-ENGY AAS000-P1 Administrative Services Generalist/Multidiscipline - Entry (P1) 36

Associate Specialist61 1MHRC-SIRS A400-1 Administration - Generalist - Level 1 Administrative 1,210RADFORD 4681 Business Process Analyst 1 21TW-MM-GEN AEM070-P1 Business Operations Analysis - Entry (P1) 825TW-MM-ENGY AEM070-P1 Business Operations Analysis - Entry (P1) 200

Associate Specialist63 1MHRC-SIRS T435-1 Quality Control, Analysis and Test Services - Level 1 Technical 1,599TW-MM-GEN AZT060-P1 Quality Control/Inspection Technical Specialty - Entry (P1) 346TW-MM-ENGY AZT060-P1 Quality Control/Inspection Technical Specialty - Entry (P1) No Data

Associate Specialist65 1MHRC-SIRS T049-1 Computer Systems Security - Level 1 Technical 314RADFORD 6581 Information Security Analyst 1 17TW-MM-GEN AIT070-P1 IS and Cyber Security - Entry (P1) 318TW-MM-ENGY AIT070-P1 IS and Cyber Security - Entry (P1) 48

Associate Specialist66 1MHRC-SIRS A301-1 Business Process Analysis - Level 1 Administrative 630RADFORD 6461 Business Systems Analyst 1 70TW-MM-GEN AID020-P1 Business Systems Analysis - Entry (P1) 1,833TW-MM-ENGY AID020-P1 Business Systems Analysis - Entry (P1) 111

Associate Specialist67 2MHRC-SIRS A376-1 Supply Chain Planning - Level 1 Administrative 528TW-MM-GEN ASC000-P1 Supply Chain and Logistics Generalist/Multidiscipline - Entry (P1) 1,007TW-MM-ENGY ASC000-P1 Supply Chain and Logistics Generalist/Multidiscipline - Entry (P1) 17

Associate Specialist68 2RADFORD 5821 Technical Support Engineer 1 41TW-MM-GEN AZT000-P1 Technical Specialty/Skilled Trade Generalist/Multidiscipline - Entry

(P1)290

TW-MM-ENGY AZT000-P1 Technical Specialty/Skilled Trade Generalist/Multidiscipline - Entry (P1)

141

Design/Drafting, Assoc Spec69 67MHRC-SIRS T226-1 Engineering - CAD/CAM - Level 1 Technical 79RADFORD 5111 CAD Engineer 1 146TW-MM-GEN AZT080-P1 CAD/CAE Drafting Technical Specialty - Entry (P1) 368TW-MM-ENGY AZT080-P1 CAD/CAE Drafting Technical Specialty - Entry (P1) 34

GIS Tech Spec, Assoc Spec70 18MHRC-SIRS T085-1 Engineering - Geo-Spatial - Level 1 Technical 133RADFORD 6351 Project (Construction) Mgr 1 No DataTW-MM-GEN AZT505-P1 Geographical Information Systems Technical Specialty - Entry (P1) No DataTW-MM-ENGY AZT505-P1 Geographical Information Systems Technical Specialty - Entry (P1) 75

21Aon

23

Page 51: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

ClericalDesign/Drafting, Specialist71 114

MHRC-SIRS T226-2 Engineering - CAD/CAM - Level 2 Technical 153RADFORD 5112 CAD Engineer 2 21TW-MM-GEN AZT080-P2 CAD/CAE Drafting Technical Specialty - Intermediate (P2) 580TW-MM-ENGY AZT080-P2 CAD/CAE Drafting Technical Specialty - Intermediate (P2) 137

GIS Tech Spec, Spec72 33MHRC-SIRS T085-2 Engineering - Geo-Spatial - Level 2 Technical 361RADFORD 6352 Project (Construction) Mgr 2 1,008TW-MM-GEN AZT505-P2 Geographical Information Systems Technical Specialty -

Intermediate (P2)No Data

TW-MM-ENGY AZT505-P2 Geographical Information Systems Technical Specialty - Intermediate (P2)

160

Planning, Specialist73 216EAPDIS 105 CUSTOMER SERVICE PLANNER/ESTIMATOR 1,294RADFORD 5822 Technical Support Engineer 2 84TW-MM-GEN AZT000-P2 Technical Specialty/Skilled Trade Generalist/Multidiscipline -

Intermediate (Professional)976

TW-MM-ENGY AZT000-P2 Technical Specialty/Skilled Trade Generalist/Multidiscipline - Intermediate (Professional)

350

Specialist74 1MHRC-SIRS T008-2 Occupational Safety and Health - Level 2 Technical 404RADFORD 6332 Environmental Health & Safety Engineer 2 41TW-MM-GEN AHS030-P2 Health and Safety - Intermediate (P2) 517TW-MM-ENGY AHS030-P2 Health and Safety - Intermediate (P2) 142

Specialist75 1MHRC-SIRS A424-2 Internet/Digital Web Marketing - Level 2 Administrative 98RADFORD 5492 Web Producer/Executive Producer 2 24TW-MM-GEN AMK120-P2 Digital Content Management - Intermediate (P2) 339TW-MM-ENGY AMK120-P2 Digital Content Management - Intermediate (P2) 5

Specialist76 2MHRC-SIRS A480-2 Project Management - Level 2 Administrative 4,117RADFORD 6632 Project (Admin) Mgr 2 352TW-MM-GEN APM000-P2 Project/Program Management Generalist/Multidiscipline -

Intermediate (P2)7,731

TW-MM-ENGY APM000-P2 Project/Program Management Generalist/Multidiscipline - Intermediate (P2)

717

Specialist77 2TW-MM-GEN EVM000-P2 Vegetation Management and Forestry Generalist/Multidiscipline -

Intermediate (P2)No Data

TW-MM-ENGY EVM000-P2 Vegetation Management and Forestry Generalist/Multidiscipline - Intermediate (P2)

104

22Aon

24

Page 52: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Professional/TechnicalAdministrative Support Role78 2

MHRC-SIRS A401-4 Secretary - Chief Executive Officer - Level 4 Administrative 163RADFORD 6504 Executive Assistant 4 28TW-MM-GEN AAS043-P4 Secretarial/Administrative Assistance to the Chief Executive

Officer - Specialist (P4)No Data

TW-MM-ENGY AAS043-P4 Secretarial/Administrative Assistance to the Chief Executive Officer - Specialist (P4)

No Data

Analyst-Business 379 179MHRC-SIRS A400-3 Administration - Generalist - Level 3 Administrative 3,976MHRC-SIRS A403-3 Business Planning - Level 3 Administrative 398RADFORD 4683 Business Process Analyst 3 202TW-MM-GEN AEM070-P3 Business Operations Analysis - Career (P3) 1,701TW-MM-ENGY AEM070-P3 Business Operations Analysis - Career (P3) 1,230

Analyst-Program/Project 380 218MHRC-SIRS A480-3 Project Management - Level 3 Administrative 7,797RADFORD 6633 Project (Admin) Mgr 3 674TW-MM-GEN APM000-P3 Project/Program Management Generalist/Multidiscipline - Career

(P3)11,920

TW-MM-ENGY APM000-P3 Project/Program Management Generalist/Multidiscipline - Career (P3)

1,158

TW-MM-ENGY APM530-P3 Electric Transmission and/or Distribution Project Management - Career (P3)

397

Customer Solutions Representative 381 27TW-MM-GEN AMS020-P3 Customer Contact Center Generalist/Multidiscipline - Career (P3) 460TW-MM-ENGY AMS020-P3 Customer Contact Center Generalist/Multidiscipline - Career (P3) 17

Land Services Agent 382 16TW-MM-GEN ARE040-P3 Land/Right-of-Way - Career (P3) 50TW-MM-ENGY ARE040-P3 Land/Right-of-Way - Career (P3) 316

Land Services Agent 483 21TW-MM-GEN ARE040-P4 Land/Right-of-Way - Specialist (P4) No DataTW-MM-ENGY ARE040-P4 Land/Right-of-Way - Specialist (P4) 104

Accountant Associate84 6MHRC-SIRS A100-1 Accounting - General - Level 1 Administrative 1,771RADFORD 6101 Accountant (General) 1 63TW-MM-GEN AFB000-P1 Accounting Generalist/Multidiscipline - Entry (P1) 923TW-MM-ENGY AFB000-P1 Accounting Generalist/Multidiscipline - Entry (P1) 104

Associate Specialist85 3TW-MM-ENGY EML010-P1 Energy Marketing and Trading Financial Analysis - Entry (P1) 9

Associate Specialist86 1MHRC-SIRS A285-1 Training/Learning Development - Level 1 Administrative 340RADFORD 6031 Organizational Development Specialist 1 68TW-MM-GEN AHR130-P1 Employee Development/Training Generalist/Multidiscipline - Entry

(P1)597

TW-MM-ENGY AHR130-P1 Employee Development/Training Generalist/Multidiscipline - Entry (P1)

41

Associate Specialist87 2MHRC-SIRS A281-1 Talent Acquisition - Level 1 Administrative 289RADFORD 6221 Staffing/Employment Representative 1 70TW-MM-GEN AHR140-P1 Recruitment Generalist/Multidiscipline - Entry (P1) 780TW-MM-ENGY AHR140-P1 Recruitment Generalist/Multidiscipline - Entry (P1) 47

23Aon

25

Page 53: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Professional/TechnicalAssociate Specialist88 1

MHRC-SIRS A490-1 Metric and Data Analysis - Level 1 Administrative 94TW-MM-GEN AEM000-P1 Data Science/Analytics and Business Intelligence

Generalist/Multidiscipline - Entry (P1)291

TW-MM-ENGY AEM000-P1 Data Science/Analytics and Business Intelligence Generalist/Multidiscipline - Entry (P1)

57

Financl Anlys, Assoc Spec89 7MHRC-SIRS A080-1 Financial Analysis - Level 1 Administrative 1,187RADFORD 6001 Financial Analyst 1 97TW-MM-GEN AFT010-P1 Financial Analysis - Entry (P1) 2,188TW-MM-ENGY AFT010-P1 Financial Analysis - Entry (P1) 127

Accountant90 18MHRC-SIRS A100-2 Accounting - General - Level 2 Administrative 4,118RADFORD 6102 Accountant (General) 2 163TW-MM-GEN AFB000-P2 Accounting Generalist/Multidiscipline - Intermediate (P2) 2,044TW-MM-ENGY AFB000-P2 Accounting Generalist/Multidiscipline - Intermediate (P2) 301

Claims Resolution, Spec91 7MHRC-SIRS A136-2 Worker's Compensation Claims Analysis - Level 2 Administrative 70TW-MM-GEN ALS030-P2 Claims Resolution - Intermediate (P2) 737TW-MM-ENGY ALS030-P2 Claims Resolution - Intermediate (P2) 109

Engineer 192 69MHRC-SIRS T412-2 Engineering Design - Level 2 Technical 2,302RADFORD 5122 Engineer 2 172TW-MM-GEN AZE000-P2 Engineering Generalist/Multidiscipline - Intermediate (P2) 6,131TW-MM-ENGY AZE000-P2 Engineering Generalist/Multidiscipline - Intermediate (P2) 2,649

Financl Anlys, Specialist93 8MHRC-SIRS A080-2 Financial Analysis - Level 2 Administrative 3,271RADFORD 6002 Financial Analyst 2 258TW-MM-GEN AFT010-P2 Financial Analysis - Intermediate (P2) 6,727TW-MM-ENGY AFT010-P2 Financial Analysis - Intermediate (P2) 312

IS Security, Specialist94 4MHRC-SIRS T049-2 Computer Systems Security - Level 2 Technical 878RADFORD 6582 Information Security Analyst 2 58TW-MM-GEN AIT070-P2 IS and Cyber Security - Intermediate (P2) 1,142TW-MM-ENGY AIT070-P2 IS and Cyber Security - Intermediate (P2) 211

Modelg, Fcstg & Econ Anlys, Spec95 5MHRC-SIRS A490-2 Metric and Data Analysis - Level 2 Administrative 283TW-MM-GEN AEM000-P2 Data Science/Analytics and Business Intelligence

Generalist/Multidiscipline - Intermediate (P2)1,013

TW-MM-ENGY AEM000-P2 Data Science/Analytics and Business Intelligence Generalist/Multidiscipline - Intermediate (P2)

153

Proprietary Telcom Sys, Specialist96 9TW-MM-ENGY EDD090-P2 Proprietary Telecommunications Systems - Intermediate (P2) 53

Security, Specialist97 9MHRC-SIRS A458-2 Security Investigator - Level 2 Administrative 162RADFORD 6712 Security Analyst 2 64TW-MM-GEN AAY000-P2 Security Generalist/Multidiscipline - Intermediate (P2) 837TW-MM-ENGY AAY000-P2 Security Generalist/Multidiscipline - Intermediate (P2) 100

24Aon

26

Page 54: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Professional/TechnicalSpecialist98 1

MHRC-SIRS A260-2 Communications - External - Level 2 Administrative 294RADFORD 5562 Marketing Communications Specialist 2 43TW-MM-GEN ACA000-P2 Corporate Affairs/Communications Generalist/Multidiscipline -

Intermediate (P2)284

TW-MM-ENGY ACA000-P2 Corporate Affairs/Communications Generalist/Multidiscipline - Intermediate (P2)

101

Specialist99 1TW-MM-ENGY EDE000-P2 Energy Efficiency/Conservation Generalist/Multidiscipline -

Intermediate (P2)170

Specialist100 3TW-MM-ENGY EML010-P2 Energy Marketing and Trading Financial Analysis - Intermediate

(P2)54

Specialist101 1TW-MM-ENGY EMT000-P2 Energy Trading Generalist/Multidiscipline - Intermediate (P2) 24

Specialist102 2TW-MM-ENGY AZE530-P2 Electric System/Grid Planning Engineering - Intermediate (P2) 136

Specialist103 1TW-MM-ENGY EMU020-P2 Energy Trading Contract Administration - Intermediate (P2) 25

Specialist104 2TW-MM-ENGY EMU000-P2 Energy Trading Operations/Support Generalist/Multidiscipline -

Intermediate (P2)9

Specialist105 2TW-MM-ENGY EMU025-P2 Energy Trading Scheduling Generalist/Multidiscipline - Intermediate

(P2)21

Specialist106 2MHRC-SIRS A275-2 Employee Benefits - Level 2 Administrative 348RADFORD 6252 Benefits Analyst 2 15TW-MM-GEN AHR060-P2 Benefits - Intermediate (P2) 639TW-MM-ENGY AHR060-P2 Benefits - Intermediate (P2) 80

Specialist107 1MHRC-SIRS A279-2 Employee Relations - Level 2 Administrative 79RADFORD 6212 Employee Relations/Shared Services Rep 2 25TW-MM-GEN AHR095-P2 Employee Relations - Intermediate (P2) 217TW-MM-ENGY AHR095-P2 Employee Relations - Intermediate (P2) 18

Specialist108 2MHRC-SIRS A299-2 Human Resources Business Partner - Level 2 Administrative 1,397RADFORD 6202 Human Resources Representative 2 50TW-MM-GEN AHR000-P2 HR Generalist/Consultant Generalist/Multidiscipline - Intermediate

(P2)4,596

TW-MM-ENGY AHR000-P2 HR Generalist/Consultant Generalist/Multidiscipline - Intermediate (P2)

188

Specialist109 2MHRC-SIRS A280-2 Labor Relations - Level 2 Administrative 47TW-MM-GEN AHR100-P2 Labor Relations - Intermediate (P2) 79TW-MM-ENGY AHR100-P2 Labor Relations - Intermediate (P2) 11

25Aon

27

Page 55: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Professional/TechnicalSpecialist110 3

MHRC-SIRS A285-2 Training/Learning Development - Level 2 Administrative 1,234RADFORD 6032 Organizational Development Specialist 2 7TW-MM-GEN AHR130-P2 Employee Development/Training Generalist/Multidiscipline -

Intermediate (P2)1,843

TW-MM-ENGY AHR130-P2 Employee Development/Training Generalist/Multidiscipline - Intermediate (P2)

94

Specialist111 2MHRC-SIRS A137-2 Equity Administration - Level 2 Administrative 15TW-MM-GEN AHR070-P2 Pension Plan Administration - Intermediate (P2) 29TW-MM-ENGY AHR070-P2 Pension Plan Administration - Intermediate (P2) 5

Specialist112 1RADFORD 6692 IT Vendor Relations Spec/Mgr 2 169TW-MM-GEN AIT110-P2 IT Outsourcing Management - Intermediate (P2) No DataTW-MM-ENGY AIT110-P2 IT Outsourcing Management - Intermediate (P2) No Data

Specialist113 2MHRC-SIRS T012-2 Software Development - Level 2 Technical 1,092RADFORD 5102 Software Development Engineer 2 2,161TW-MM-GEN AID010-P2 Application Development - Intermediate (P2) 7,055TW-MM-ENGY AID010-P2 Application Development - Intermediate (P2) 414

Specialist114 1MHRC-SIRS A301-2 Business Process Analysis - Level 2 Administrative 2,006RADFORD 6462 Business Systems Analyst 2 243TW-MM-GEN AID020-P2 Business Systems Analysis - Intermediate (P2) 6,001TW-MM-ENGY AID020-P2 Business Systems Analysis - Intermediate (P2) 489

Specialist115 2MHRC-SIRS T012-2 Software Development - Level 2 Technical 1,092RADFORD 5102 Software Development Engineer 2 2,161TW-MM-ENGY AID500-P2 Energy Management System Software Development - Intermediate

(P2)65

Specialist116 1TW-MM-GEN AEM020-P2 Management Data Analysis - Intermediate (P2) 237TW-MM-ENGY AEM020-P2 Management Data Analysis - Intermediate (P2) No Data

Specialist117 2MHRC-SIRS T071-2 Data Science and Modeling - Level 2 Technical 156TW-MM-GEN AEM050-P2 Predictive Analytics/Business Intelligence - Intermediate (P2) 268TW-MM-GEN AEM060-P2 Data Science - Intermediate (P2) 202TW-MM-ENGY AEM050-P2 Predictive Analytics/Business Intelligence - Intermediate (P2) No DataTW-MM-ENGY AEM060-P2 Data Science - Intermediate (P2) No Data

Specialist118 1MHRC-SIRS A235-2 Promotion/Advertising - Level 2 Administrative 247TW-MM-GEN AMK025-P2 Advertising - Intermediate (P2) 84TW-MM-ENGY AMK025-P2 Advertising - Intermediate (P2) No Data

Specialist119 1RADFORD 5562 Marketing Communications Specialist 2 43TW-MM-GEN AMK020-P2 Advertising/Marketing Communications - Intermediate (P2) 1,229TW-MM-ENGY AMK020-P2 Advertising/Marketing Communications - Intermediate (P2) 5

26Aon

28

Page 56: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Professional/TechnicalSpecialist120 1

TW-MM-GEN AMK090-P2 Marketing Program Management - Intermediate (P2) 62TW-MM-ENGY AMK090-P2 Marketing Program Management - Intermediate (P2) No Data

Specialist121 1TW-MM-GEN AMK113-P2 Online Community Management - Intermediate (P2) 17TW-MM-ENGY AMK113-P2 Online Community Management - Intermediate (P2) No Data

Specialist122 1TW-MM-GEN ASC090-P2 Technical Purchasing - Intermediate (P2) 308TW-MM-ENGY ASC090-P2 Technical Purchasing - Intermediate (P2) 12

Tech Training, Specialist123 8MHRC-SIRS A286-2 Training - Technical Product - Level 2 Administrative 987RADFORD 5892 Technical Course Developer 2 571TW-MM-GEN AHR134-P2 Technical Training - Intermediate (P2) 646TW-MM-ENGY AHR134-P2 Technical Training - Intermediate (P2) 279

Tlnt Acquisition, Specialist124 12MHRC-SIRS A281-2 Talent Acquisition - Level 2 Administrative 909RADFORD 6222 Staffing/Employment Representative 2 336TW-MM-GEN AHR140-P2 Recruitment Generalist/Multidiscipline - Intermediate (P2) 2,812TW-MM-ENGY AHR140-P2 Recruitment Generalist/Multidiscipline - Intermediate (P2) 140

Accountant Senior125 11MHRC-SIRS A100-3 Accounting - General - Level 3 Administrative 3,408RADFORD 6103 Accountant (General) 3 402TW-MM-GEN AFB000-P3 Accounting Generalist/Multidiscipline - Career (P3) 1,740TW-MM-ENGY AFB000-P3 Accounting Generalist/Multidiscipline - Career (P3) 549

Acct Mgmt, Sr Specialist126 20RADFORD 5693 Account Services Mgr 3 37TW-MM-GEN CAM000-S3 Account/Relationship Management Generalist/Multidiscipline -

Career (S3)5,613

TW-MM-ENGY CAM000-S3 Account/Relationship Management Generalist/Multidiscipline - Career (S3)

230

Aircraft Mgmt & Ops, Sr Specialist127 4MHRC-SIRS U040-3 Pilot - Level 3 Technical 2,511TW-MM-GEN AAT050-P3 Aviation - Pilots - Career (P3) 205TW-MM-ENGY AAT050-P3 Aviation - Pilots - Career (P3) 38

App Dev, Sr Spec128 7MHRC-SIRS T012-3 Software Development - Level 3 Technical 3,357RADFORD 5103 Software Development Engineer 3 4,909TW-MM-GEN AID010-P3 Application Development - Career (P3) 14,012TW-MM-ENGY AID010-P3 Application Development - Career (P3) 1,120

Auditor Senior129 6MHRC-SIRS A020-3 Auditing - Level 3 Administrative 600RADFORD 6173 Internal Auditor 3 75TW-MM-GEN AFU010-P3 General Audit - Career (P3) 1,587TW-MM-ENGY AFU010-P3 General Audit - Career (P3) 168

27Aon

29

Page 57: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Professional/TechnicalBus Ops Anlys, Sr Specialist130 42

MHRC-SIRS A400-3 Administration - Generalist - Level 3 Administrative 3,976RADFORD 4683 Business Process Analyst 3 202TW-MM-GEN AEM070-P3 Business Operations Analysis - Career (P3) 1,701TW-MM-ENGY AEM070-P3 Business Operations Analysis - Career (P3) 1,230

Bus Process Imprvmt, Sr Specialist131 8MHRC-SIRS A301-3 Business Process Analysis - Level 3 Administrative 3,217RADFORD 4683 Business Process Analyst 3 202TW-MM-GEN AQY020-P3 Business Process Improvement - Career (P3) 2,994TW-MM-ENGY AQY020-P3 Business Process Improvement - Career (P3) 354

Bus Sys Anlys, Sr Specialist132 23MHRC-SIRS A301-3 Business Process Analysis - Level 3 Administrative 3,217RADFORD 6463 Business Systems Analyst 3 592TW-MM-GEN AID020-P3 Business Systems Analysis - Career (P3) 9,925TW-MM-ENGY AID020-P3 Business Systems Analysis - Career (P3) 1,177

Business Continuation, Sr Specialist133 7MHRC-SIRS A459-3 Business Continuity - Level 3 Administrative 79TW-MM-GEN AAY010-P3 Business Continuation - Career (P3) 71TW-MM-ENGY AAY010-P3 Business Continuation - Career (P3) 42

Contract Admin, Sr Specialist134 13MHRC-SIRS A150-3 Contracts Administration - Level 3 Administrative 2,788TW-MM-GEN ALS020-P3 Contract Administration - Career (P3) 2,156TW-MM-ENGY ALS020-P3 Contract Administration - Career (P3) 453

Elec Sys/Grid & Blk Pwr Trng, Sr Spec135 9TW-MM-ENGY ETT000-P3 Electric System/Grid and Bulk Power Training

Generalist/Multidiscipline - Career (P3)58

Elec Trans &/Or Distr Prj Mgr, Sr Spec136 7TW-MM-ENGY APM530-P3 Electric Transmission and/or Distribution Project Management -

Career (P3)397

Employee Relations, Sr Spec137 8MHRC-SIRS A279-3 Employee Relations - Level 3 Administrative 319RADFORD 6213 Employee Relations/Shared Services Rep 3 34TW-MM-GEN AHR095-P3 Employee Relations - Career (P3) 499TW-MM-ENGY AHR095-P3 Employee Relations - Career (P3) 30

Engineer 2138 90MHRC-SIRS T412-3 Engineering Design - Level 3 Technical 4,651RADFORD 5123 Engineer 3 237TW-MM-GEN AZE000-P3 Engineering Generalist/Multidiscipline - Career (P3) 8,713TW-MM-ENGY AZE000-P3 Engineering Generalist/Multidiscipline - Career (P3) 4,680

Engy Del / Distrib, Sr Specialist139 9TW-MM-ENGY EDD000-P3 Energy Delivery/Distribution Generalist/Multidiscipline - Career (P3) 204

Engy Eff/Cnsv Cmrcl/Ind Dsn, Sr Spec140 5TW-MM-ENGY EDE010-P3 Energy Efficiency/Conservation - Commercial/Industrial Design -

Career (P3)9

Engy Effcncy / Cnsvrtion, Sr Specialist141 17TW-MM-ENGY EDE000-P3 Energy Efficiency/Conservation Generalist/Multidiscipline - Career

(P3)257

28Aon

30

Page 58: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Professional/TechnicalEngy Mgmt Sys (EMS) Dev, Sr Spec142 14

MHRC-SIRS T012-3 Software Development - Level 3 Technical 3,357RADFORD 5103 Software Development Engineer 3 4,909TW-MM-ENGY AID500-P3 Energy Management System Software Development - Career (P3) 126

Engy Mktg & Trdg Fncl Anlys, Sr Spec143 7TW-MM-ENGY EML010-P3 Energy Marketing and Trading Financial Analysis - Career (P3) 117

Engy Trdg Ops / Support, Sr Specialist144 7TW-MM-ENGY EMU000-P3 Energy Trading Operations/Support Generalist/Multidiscipline -

Career (P3)67

Engy Trdg Schdlng, Sr Specialist145 8TW-MM-ENGY EMU025-P3 Energy Trading Scheduling Generalist/Multidiscipline - Career (P3) 56

Envir Science, Sr Specialist146 13MHRC-SIRS A457-3 Regulatory Compliance - Environmental - Level 3 Administrative 188TW-MM-GEN AHS010-P3 Environmental Science - Career (P3) 235TW-MM-ENGY AHS010-P3 Environmental Science - Career (P3) 732

Financl Anlys, Sr Specialist147 21MHRC-SIRS A080-3 Financial Analysis - Level 3 Administrative 6,153RADFORD 6003 Financial Analyst 3 647TW-MM-GEN AFT010-P3 Financial Analysis - Career (P3) 9,993TW-MM-ENGY AFT010-P3 Financial Analysis - Career (P3) 638

GIS Tech Spec, Sr Spec148 11MHRC-SIRS T085-3 Engineering - Geo-Spatial - Level 3 Technical 187RADFORD 6353 Project (Construction) Mgr 3 597TW-MM-GEN AZT505-P3 Geographical Information Systems Technical Specialty - Career

(P3)No Data

TW-MM-ENGY AZT505-P3 Geographical Information Systems Technical Specialty - Career (P3)

130

Info Tchnlgy Prj Mgmt, Sr Specialist149 5MHRC-SIRS T350-3 Project Management - Information Technology - Level 3 Technical 2,516RADFORD 6623 Project (Information Systems) Mgr 3 142TW-MM-GEN APM010-P3 Information Technology Project Management - Career (P3) 4,505TW-MM-ENGY APM010-P3 Information Technology Project Management - Career (P3) 253

IS Security, Sr Specialist150 12MHRC-SIRS T049-3 Computer Systems Security - Level 3 Technical 1,587RADFORD 6583 Information Security Analyst 3 123TW-MM-GEN AIT070-P3 IS and Cyber Security - Career (P3) 2,239TW-MM-ENGY AIT070-P3 IS and Cyber Security - Career (P3) 305

IT Dev, Sr Specialist151 5RADFORD 6443 Systems Programmer 3 34TW-MM-GEN AID000-P3 IT Development Generalist/Multidiscipline - Career (P3) 6,780TW-MM-ENGY AID000-P3 IT Development Generalist/Multidiscipline - Career (P3) 264

IT Operations, Sr Specialist152 6MHRC-SIRS A405-3 Information Systems - Generic (Administrative) - Level 3

Administrative255

TW-MM-GEN AIT000-P3 IT Administration Generalist/Multidiscipline - Career (P3) 2,378TW-MM-ENGY AIT000-P3 IT Administration Generalist/Multidiscipline - Career (P3) 280

29Aon

31

Page 59: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Professional/TechnicalLabor Reltns, Sr Specialist153 4

MHRC-SIRS A280-3 Labor Relations - Level 3 Administrative 66TW-MM-GEN AHR100-P3 Labor Relations - Career (P3) 119TW-MM-ENGY AHR100-P3 Labor Relations - Career (P3) 38

Learning & Dev, Sr Specialist154 4MHRC-SIRS A285-3 Training/Learning Development - Level 3 Administrative 1,938RADFORD 6033 Organizational Development Specialist 3 30TW-MM-GEN AHR130-P3 Employee Development/Training Generalist/Multidiscipline - Career

(P3)1,515

TW-MM-ENGY AHR130-P3 Employee Development/Training Generalist/Multidiscipline - Career (P3)

255

Mgmt Data Anlys, Sr Specialist155 4TW-MM-GEN AEM020-P3 Management Data Analysis - Career (P3) 312TW-MM-ENGY AEM020-P3 Management Data Analysis - Career (P3) No Data

Modelg, Fcstg & Econ Anlys, Sr Spec156 16MHRC-SIRS A490-3 Metric and Data Analysis - Level 3 Administrative 407TW-MM-GEN AEM000-P3 Data Science/Analytics and Business Intelligence

Generalist/Multidiscipline - Career (P3)2,240

TW-MM-ENGY AEM000-P3 Data Science/Analytics and Business Intelligence Generalist/Multidiscipline - Career (P3)

237

Planning, Sr Spec157 212TW-MM-ENGY APM530-P3 Electric Transmission and/or Distribution Project Management -

Career (Professional)397

Power Systems Planner 2158 10TW-MM-ENGY AZE530-P3 Electric System/Grid Planning Engineering - Career (P3) 321

Process Tech Spec, Sr Specialist159 9TW-MM-GEN AZT050-P3 Process Technical Specialty - Career (P3) 114TW-MM-ENGY AZT050-P3 Process Technical Specialty - Career (P3) 20

Proprietary Telcom Sys, Sr Specialist160 30TW-MM-ENGY EDD090-P3 Proprietary Telecommunications Systems - Career (P3) 56

Q A Methods, Sr Specialist161 10MHRC-SIRS A073-3 Quality Analysis - Level 3 Administrative 1,266TW-MM-GEN AQY000-P3 Quality Assurance Methods Generalist/Multidiscipline - Career (P3) 1,922TW-MM-ENGY AQY000-P3 Quality Assurance Methods Generalist/Multidiscipline - Career (P3) 59

Q Cntrl / Inspection, Sr Specialist162 65MHRC-SIRS T435-3 Quality Control, Analysis and Test Services - Level 3 Technical 1,378TW-MM-GEN AZT060-P3 Quality Control/Inspection Technical Specialty - Career (P3) 654TW-MM-ENGY AZT060-P3 Quality Control/Inspection Technical Specialty - Career (P3) 9

Rates, Sr Specialist163 9TW-MM-ENGY AFT090-P3 Rates - Career (P3) 173

Senior Specialist164 2MHRC-SIRS A022-3 Auditing - IT Compliance - Level 3 Administrative 190RADFORD 6053 Information Systems Auditor 3 18TW-MM-GEN AFU020-P3 IS Audit - Career (P3) 187TW-MM-ENGY AFU020-P3 IS Audit - Career (P3) 40

30Aon

32

Page 60: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Professional/TechnicalSenior Specialist165 1

RADFORD 6193 Financial Reporting Analyst/Mgr 3 30TW-MM-GEN AFB020-P3 Financial Reporting - Career (P3) 614TW-MM-ENGY AFB020-P3 Financial Reporting - Career (P3) 84

Senior Specialist166 2MHRC-SIRS A420-3 Product Design - Graphic - Level 3 Administrative No DataTW-MM-GEN ACA120-P3 Creative Design Services - Career (P3) 747TW-MM-ENGY ACA120-P3 Creative Design Services - Career (P3) 65

Senior Specialist167 3MHRC-SIRS T008-3 Occupational Safety and Health - Level 3 Technical 636RADFORD 6333 Environmental Health & Safety Engineer 3 60TW-MM-GEN AHS030-P3 Health and Safety - Career (P3) 706TW-MM-ENGY AHS030-P3 Health and Safety - Career (P3) 306

Senior Specialist168 2TW-MM-ENGY EMT000-P3 Energy Trading Generalist/Multidiscipline - Career (P3) 41

Senior Specialist169 2TW-MM-ENGY EMU020-P3 Energy Trading Contract Administration - Career (P3) 34

Senior Specialist170 1MHRC-SIRS A293-3 Compensation - Level 3 Administrative 312RADFORD 6243 Compensation Analyst 3 29TW-MM-GEN AHR020-P3 Compensation Generalist/Multidiscipline - Career (P3) 590TW-MM-ENGY AHR020-P3 Compensation Generalist/Multidiscipline - Career (P3) 90

Senior Specialist171 2MHRC-SIRS A296-3 Diversity Workforce Management - Level 3 Administrative 34RADFORD 6683 Diversity and Inclusion Analyst 3 17TW-MM-GEN AHR110-P3 Diversity/Equal Employment Opportunity Generalist/Multidiscipline -

Career (P3)31

TW-MM-ENGY AHR110-P3 Diversity/Equal Employment Opportunity Generalist/Multidiscipline - Career (P3)

16

Senior Specialist172 1TW-MM-GEN AHR030-P3 Compensation - Executive Compensation - Career (P3) 26TW-MM-ENGY AHR030-P3 Compensation - Executive Compensation - Career (P3) 6

Senior Specialist173 2MHRC-SIRS A299-3 Human Resources Business Partner - Level 3 Administrative 1,723RADFORD 6203 Human Resources Representative 3 44TW-MM-GEN AHR000-P3 HR Generalist/Consultant Generalist/Multidiscipline - Career (P3) 4,749TW-MM-ENGY AHR000-P3 HR Generalist/Consultant Generalist/Multidiscipline - Career (P3) 331

Senior Specialist174 3MHRC-SIRS T038-3 Human Resources Information Systems (HRIS) - Level 3 Technical 334RADFORD 6273 HRIS Analyst 3 30TW-MM-GEN AHR150-P3 Human Resources Information Systems - Career (P3) 751TW-MM-ENGY AHR150-P3 Human Resources Information Systems - Career (P3) 69

Senior Specialist175 2MHRC-SIRS A281-3 Talent Acquisition - Level 3 Administrative 1,688RADFORD 6223 Staffing/Employment Representative 3 459TW-MM-GEN AHR140-P3 Recruitment Generalist/Multidiscipline - Career (P3) 3,039TW-MM-ENGY AHR140-P3 Recruitment Generalist/Multidiscipline - Career (P3) 190

31Aon

33

Page 61: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Professional/TechnicalSenior Specialist176 1

FOU-SEC 335 Investigator III 394MHRC-SIRS A458-3 Security Investigator - Level 3 Administrative 151RADFORD 6713 Security Analyst 3 95

Senior Specialist177 1RADFORD 6693 IT Vendor Relations Spec/Mgr 3 221TW-MM-GEN AIT110-P3 IT Outsourcing Management - Career (P3) 5TW-MM-ENGY AIT110-P3 IT Outsourcing Management - Career (P3) No Data

Senior Specialist178 1MHRC-SIRS S226-3 Systems Architecture - Information Technology - Level 3

Management157

RADFORD 5203 Systems Design/Architecture Engineer 3 992TW-MM-GEN AID030-P3 IT Architecture (Systems Design) - Career (P3) 3,324TW-MM-ENGY AID030-P3 IT Architecture (Systems Design) - Career (P3) 309

Senior Specialist179 2MHRC-SIRS T029-3 Network Engineering - Level 3 Technical 2,181RADFORD 4823 Network Planning Engineer 3 766TW-MM-GEN AID090-P3 Network Planning and Implementation - Career (P3) 688TW-MM-ENGY AID090-P3 Network Planning and Implementation - Career (P3) 102

Senior Specialist180 2TW-MM-GEN ALS000-P3 Legal Support Generalist/Multidiscipline - Career (P3) 168TW-MM-ENGY ALS000-P3 Legal Support Generalist/Multidiscipline - Career (P3) 18

Senior Specialist181 1TW-MM-ENGY EEM000-P3 Meteorology Generalist/Multidiscipline - Career (P3) 16

Senior Specialist182 2MHRC-SIRS T071-3 Data Science and Modeling - Level 3 Technical 361RADFORD 6703 Data Scientist 3 205TW-MM-GEN AEM060-P3 Data Science - Career (P3) 485TW-MM-ENGY AEM060-P3 Data Science - Career (P3) No Data

Senior Specialist183 2RADFORD 5563 Marketing Communications Specialist 3 67TW-MM-GEN AMK020-P3 Advertising/Marketing Communications - Career (P3) 1,238TW-MM-ENGY AMK020-P3 Advertising/Marketing Communications - Career (P3) 33

Senior Specialist184 2TW-MM-GEN AMK090-P3 Marketing Program Management - Career (P3) 113TW-MM-ENGY AMK090-P3 Marketing Program Management - Career (P3) 64

Senior Specialist185 2MHRC-SIRS A250-3 Marketing Research/Planning - Level 3 Administrative 623RADFORD 5603 Market Research Analyst 3 69TW-MM-GEN AMK000-P3 Marketing Generalist/Multidiscipline - Career (P3) 3,237TW-MM-ENGY AMK000-P3 Marketing Generalist/Multidiscipline - Career (P3) 112

Senior Specialist186 1TW-MM-GEN AMK113-P3 Online Community Management - Career (P3) 12TW-MM-ENGY AMK113-P3 Online Community Management - Career (P3) No Data

32Aon

34

Page 62: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Professional/TechnicalSenior Specialist187 2

MHRC-SIRS A424-3 Internet/Digital Web Marketing - Level 3 Administrative 364RADFORD 5493 Web Producer/Executive Producer 3 92TW-MM-GEN AMK120-P3 Digital Content Management - Career (P3) 383TW-MM-ENGY AMK120-P3 Digital Content Management - Career (P3) 15

Senior Specialist188 2MHRC-SIRS A411-3 Media Production - Level 3 Administrative 227TW-MM-GEN AMK140-P3 Digital Multimedia Production - Career (P3) 104TW-MM-ENGY AMK140-P3 Digital Multimedia Production - Career (P3) 5

Senior Specialist189 1RADFORD 6353 Project (Construction) Mgr 3 597TW-MM-GEN APM020-P3 Facilities Construction Project Management - Career (P3) 1,145TW-MM-ENGY APM020-P3 Facilities Construction Project Management - Career (P3) 127

Senior Specialist190 3MHRC-SIRS A480-3 Project Management - Level 3 Administrative 7,797RADFORD 6633 Project (Admin) Mgr 3 674TW-MM-GEN APM000-P3 Project/Program Management Generalist/Multidiscipline - Career

(P3)11,920

TW-MM-ENGY APM000-P3 Project/Program Management Generalist/Multidiscipline - Career (P3)

1,158

Senior Specialist191 1TW-MM-ENGY APM027-P3 Construction Project Control Services - Career (P3) 252

Senior Specialist192 3RADFORD 5313 Technical Writer 3 168

Senior Specialist193 3MHRC-SIRS A451-3 Regulatory Compliance - Level 3 Administrative 2,057RADFORD 55013 Regulatory Affairs Specialist 3 46TW-MM-GEN ACA050-P3 Regulatory Affairs and Compliance - Career (P3) 1,266TW-MM-ENGY ACA050-P3 Regulatory Affairs and Compliance - Career (P3) 248

Senior Specialist194 2MHRC-SIRS A451-3 Regulatory Compliance - Level 3 Administrative 2,057RADFORD 5943 Regulatory Compliance Analyst/Mgr 3 30TW-MM-ENGY ACA540-P3 Regulatory Compliance - Technical Rules and Standards - Career

(P3)82

Senior Specialist195 1TW-MM-GEN AFY-P3 Risk Management - Career (P3) 385TW-MM-ENGY AFY-P3 Risk Management - Career (P3) 75

Senior Specialist196 3MHRC-SIRS A080-3 Financial Analysis - Level 3 Administrative 6,153RADFORD 6003 Financial Analyst 3 647TW-MM-GEN AFT000-P3 Financial Analysis and Tax Generalist/Multidiscipline - Career (P3) 789TW-MM-ENGY AFT000-P3 Financial Analysis and Tax Generalist/Multidiscipline - Career (P3) 213

Senior Specialist197 2MHRC-SIRS T021-3 Chemistry - Level 3 Technical 2,494RADFORD 5383 Chemist 3 291TW-MM-GEN AZT110-P3 Chemistry Technical Specialty - Career (P3) 164TW-MM-ENGY AZT110-P3 Chemistry Technical Specialty - Career (P3) No Data

33Aon

35

Page 63: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Professional/TechnicalSenior Specialist198 1

TW-MM-ENGY AZT544-P3 Electric Transmission and/or Distribution Technical Specialty - Career (P3)

84

Senior Specialist199 2TW-MM-GEN AZT130-P3 Technical Documentation Control - Career (P3) 358TW-MM-ENGY AZT130-P3 Technical Documentation Control - Career (P3) No Data

Senior Specialist200 2MHRC-SIRS A136-3 Worker's Compensation Claims Analysis - Level 3 Administrative 56TW-MM-GEN AHS070-P3 Workers' Compensation Case Management - Career (P3) 125TW-MM-ENGY AHS070-P3 Workers' Compensation Case Management - Career (P3) 30

Sup Chain Dev & Opt, Sr Specialist201 5MHRC-SIRS A376-3 Supply Chain Planning - Level 3 Administrative 1,855TW-MM-GEN ASC010-P3 Supply Chain Development and Optimization - Career (P3) 937TW-MM-ENGY ASC010-P3 Supply Chain Development and Optimization - Career (P3) 49

Tech Purchasing, Sr Specialist202 23TW-MM-GEN ASC090-P3 Technical Purchasing - Career (P3) 372TW-MM-ENGY ASC090-P3 Technical Purchasing - Career (P3) 13

Tech Spec, Sr Specialist203 63RADFORD 5823 Technical Support Engineer 3 153TW-MM-GEN AZT000-P3 Technical Specialty/Skilled Trade Generalist/Multidiscipline -

Career (P3)1,153

TW-MM-ENGY AZT000-P3 Technical Specialty/Skilled Trade Generalist/Multidiscipline - Career (P3)

416

Tech Training, Sr Specialist204 20MHRC-SIRS A286-3 Training - Technical Product - Level 3 Administrative 1,234TW-MM-GEN AHR134-P3 Technical Training - Career (P3) 363TW-MM-ENGY AHR134-P3 Technical Training - Career (P3) 808

Vgtatn Mgmt & For Gnrlst, Sr Spec205 23TW-MM-GEN EVM000-P3 Vegetation Management and Forestry Generalist/Multidiscipline -

Career (P3)No Data

TW-MM-ENGY EVM000-P3 Vegetation Management and Forestry Generalist/Multidiscipline - Career (P3)

275

Acct Mgmt, Advisor206 10RADFORD 5694 Account Services Mgr 4 37TW-MM-GEN CAM000-S4 Account/Relationship Management Generalist/Multidiscipline -

Expert (S4)2,892

TW-MM-ENGY CAM000-S4 Account/Relationship Management Generalist/Multidiscipline - Expert (S4)

265

Acctg, Advisor207 9MHRC-SIRS A100-4 Accounting - General - Level 4 Administrative 1,640RADFORD 6104 Accountant (General) 4 172TW-MM-GEN AFB000-P4 Accounting Generalist/Multidiscipline - Specialist (P4) 779TW-MM-ENGY AFB000-P4 Accounting Generalist/Multidiscipline - Specialist (P4) 327

Advisor208 2RADFORD 6194 Financial Reporting Analyst/Mgr 4 14TW-MM-GEN AFB020-P4 Financial Reporting - Specialist (P4) 206TW-MM-ENGY AFB020-P4 Financial Reporting - Specialist (P4) 39

34Aon

36

Page 64: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Professional/TechnicalAdvisor209 3

TW-MM-GEN ACA110-P4 Creative Writing Services - Specialist (P4) 96TW-MM-ENGY ACA110-P4 Creative Writing Services - Specialist (P4) 12

Advisor210 1MHRC-SIRS A457-4 Regulatory Compliance - Environmental - Level 4 Administrative 196RADFORD 6334 Environmental Health & Safety Engineer 4 48TW-MM-GEN ACA060-P4 Environmental Affairs and Compliance - Specialist (P4) 87TW-MM-ENGY ACA060-P4 Environmental Affairs and Compliance - Specialist (P4) 63

Advisor211 2TW-MM-GEN ACA080-P4 Lobbying - Specialist (P4) No DataTW-MM-ENGY ACA080-P4 Lobbying - Specialist (P4) 24

Advisor212 3TW-MM-ENGY ACA500-P4 Economic Development - Specialist (P4) 74

Advisor213 1TW-EMT EMM080-P4 Energy Deal Structuring - Specialist (P4) 33

Advisor214 2TW-MM-ENGY EMT000-P4 Energy Trading Generalist/Multidiscipline - Specialist (P4) 52

Advisor215 1TW-MM-ENGY EFS000-P4 Energy Supply Generalist/Multidiscipline - Specialist (P4) 16

Advisor216 1MHRC-SIRS A040-4 Budgeting - Level 4 Administrative 587TW-MM-GEN AFT020-P4 Budget Analysis - Specialist (P4) 290TW-MM-ENGY AFT020-P4 Budget Analysis - Specialist (P4) 210

Advisor217 1MHRC-SIRS A130-4 Insurance/Risk Management - Level 4 Administrative 76RADFORD 6024 Risk Analyst 4 54TW-MM-GEN AFT080-P4 Insurance Risk - Specialist (P4) 84TW-MM-ENGY AFT080-P4 Insurance Risk - Specialist (P4) 32

Advisor218 2MHRC-SIRS A133-4 Cash Management - Level 4 Administrative 100RADFORD 6134 Treasury Analyst 4 24TW-MM-GEN AFT030-P4 Treasury Operations - Specialist (P4) 185TW-MM-ENGY AFT030-P4 Treasury Operations - Specialist (P4) 46

Advisor219 3MHRC-SIRS A275-4 Employee Benefits - Level 4 Administrative 283RADFORD 6254 Benefits Analyst 4 40TW-MM-GEN AHR060-P4 Benefits - Specialist (P4) 369TW-MM-ENGY AHR060-P4 Benefits - Specialist (P4) 58

Advisor220 3MHRC-SIRS A296-4 Diversity Workforce Management - Level 4 Administrative 57RADFORD 6684 Diversity and Inclusion Analyst 4 55TW-MM-GEN AHR110-P4 Diversity/Equal Employment Opportunity Generalist/Multidiscipline -

Specialist (P4)68

TW-MM-ENGY AHR110-P4 Diversity/Equal Employment Opportunity Generalist/Multidiscipline - Specialist (P4)

12

35Aon

37

Page 65: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Professional/TechnicalAdvisor221 1

MHRC-SIRS A299-4 Human Resources Business Partner - Level 4 Administrative 1,587RADFORD 6204 Human Resources Representative 4 33TW-MM-GEN AHR000-P4 HR Generalist/Consultant Generalist/Multidiscipline - Specialist (P4) 3,085TW-MM-ENGY AHR000-P4 HR Generalist/Consultant Generalist/Multidiscipline - Specialist (P4) 266

Advisor222 1MHRC-SIRS T038-4 Human Resources Information Systems (HRIS) - Level 4 Technical 273RADFORD 6274 HRIS Analyst 4 47TW-MM-GEN AHR150-P4 Human Resources Information Systems - Specialist (P4) 361TW-MM-ENGY AHR150-P4 Human Resources Information Systems - Specialist (P4) 50

Advisor223 1RADFORD R06034 Human Resources - All Professional Roll-Up 4 753TW-MM-GEN AHR-P4 Human Resources - Specialist (P4) 8,346TW-MM-ENGY AHR-P4 Human Resources - Specialist (P4) 892

Advisor224 1MHRC-SIRS A280-4 Labor Relations - Level 4 Administrative 169TW-MM-GEN AHR100-P4 Labor Relations - Specialist (P4) 198TW-MM-ENGY AHR100-P4 Labor Relations - Specialist (P4) 31

Advisor225 2MHRC-SIRS A287-4 Organization Development - Level 4 Administrative 358TW-MM-GEN AHR132-P4 Management Development - Specialist (P4) 34TW-MM-ENGY AHR132-P4 Management Development - Specialist (P4) 12

Advisor226 1MHRC-SIRS A285-4 Training/Learning Development - Level 4 Administrative 1,668RADFORD 6034 Organizational Development Specialist 4 45TW-MM-GEN AHR130-P4 Employee Development/Training Generalist/Multidiscipline -

Specialist (P4)998

TW-MM-ENGY AHR130-P4 Employee Development/Training Generalist/Multidiscipline - Specialist (P4)

76

Advisor227 1MHRC-SIRS A287-4 Organization Development - Level 4 Administrative 358RADFORD 6034 Organizational Development Specialist 4 45TW-MM-GEN AHR120-P4 Organization Development - Specialist (P4) 313TW-MM-ENGY AHR120-P4 Organization Development - Specialist (P4) 35

Advisor228 1MHRC-SIRS A137-4 Equity Administration - Level 4 Administrative 14RADFORD 6264 Stock Plan Administrator 4 12TW-MM-GEN AHR070-P4 Pension Plan Administration - Specialist (P4) 13TW-MM-ENGY AHR070-P4 Pension Plan Administration - Specialist (P4) No Data

Advisor229 3MHRC-SIRS A286-4 Training - Technical Product - Level 4 Administrative 812RADFORD 5894 Technical Course Developer 4 25TW-MM-GEN AHR134-P4 Technical Training - Specialist (P4) 114TW-MM-ENGY AHR134-P4 Technical Training - Specialist (P4) 181

Advisor230 2MHRC-SIRS A281-4 Talent Acquisition - Level 4 Administrative 943RADFORD 6224 Staffing/Employment Representative 4 338TW-MM-GEN AHR140-P4 Recruitment Generalist/Multidiscipline - Specialist (P4) 1,363TW-MM-ENGY AHR140-P4 Recruitment Generalist/Multidiscipline - Specialist (P4) 36

36Aon

38

Page 66: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Professional/TechnicalAdvisor231 2

TW-MM-ENGY AIT560-P4 Critical Infrastructure Protection Compliance Audit - Specialist (P4) 20

Advisor232 1TW-MM-GEN AID055-P4 Application Development Support - Specialist (P4) 335TW-MM-ENGY AID055-P4 Application Development Support - Specialist (P4) 56

Advisor233 1MHRC-SIRS T012-4 Software Development - Level 4 Technical 2,617RADFORD 5104 Software Development Engineer 4 4,437TW-MM-GEN AID010-P4 Application Development - Specialist (P4) 8,999TW-MM-ENGY AID010-P4 Application Development - Specialist (P4) 817

Advisor234 2MHRC-SIRS T073-4 Database Engineering - Level 4 Technical 230RADFORD 6594 Database Engineer 4 70TW-MM-GEN AID070-P4 Database Warehousing/Mining - Specialist (P4) 368TW-MM-ENGY AID070-P4 Database Warehousing/Mining - Specialist (P4) 20

Advisor235 1MHRC-SIRS T029-4 Network Engineering - Level 4 Technical 2,277RADFORD 4824 Network Planning Engineer 4 1,073TW-MM-GEN AID090-P4 Network Planning and Implementation - Specialist (P4) 485TW-MM-ENGY AID090-P4 Network Planning and Implementation - Specialist (P4) 49

Advisor236 3EMPS-WORKS ATTY-L3 Intermediate Attorney 183HILDE-LAW STA Staff Attorney 742MHRC-SIRS U001-4 Law - General - Level 4 Technical 485TW-MM-GEN ALG000-P4 Legal Generalist/Multidiscipline - Specialist (P4) 1,294TW-MM-ENGY ALG000-P4 Legal Generalist/Multidiscipline - Specialist (P4) 227

Advisor237 1EMPS-WORKS ATTY-L3 Intermediate Attorney 183HILDE-LAW STA Staff Attorney 742MHRC-SIRS U001-4 Law - General - Level 4 Technical 485TW-MM-GEN ALG000-P4 Legal Generalist/Multidiscipline - Specialist (P4) 1,294TW-MM-ENGY ALG000-P4 Legal Generalist/Multidiscipline - Specialist (P4) 227

Advisor238 1TW-MM-GEN ALG065-P4 Corporate Governance - Specialist (P4) 15TW-MM-ENGY ALG065-P4 Corporate Governance - Specialist (P4) No Data

Advisor239 1RADFORD 6494 Data Informatics Analyst 4 190TW-MM-GEN AEM020-P4 Management Data Analysis - Specialist (P4) 114TW-MM-ENGY AEM020-P4 Management Data Analysis - Specialist (P4) No Data

Advisor240 1TW-MM-GEN AMK070-P4 Brand Marketing - Specialist (P4) 213TW-MM-ENGY AMK070-P4 Brand Marketing - Specialist (P4) No Data

Advisor241 1MHRC-SIRS A244-4 Product Marketing - Level 4 Administrative 1,676TW-MM-GEN AMK050-P4 Product Management - Specialist (P4) 5,319TW-MM-ENGY AMK050-P4 Product Management - Specialist (P4) No Data

37Aon

39

Page 67: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Professional/TechnicalAdvisor242 3

TW-MM-GEN APM030-P4 Engineering Project Management - Specialist (P4) 3,614TW-MM-ENGY APM030-P4 Engineering Project Management - Specialist (P4) No Data

Advisor243 3TW-MM-GEN APM032-P4 Engineering Project Design - Specialist (P4) No DataTW-MM-ENGY APM032-P4 Engineering Project Design - Specialist (P4) 33

Advisor244 3TW-MM-GEN APM020-P4 Facilities Construction Project Management - Specialist (P4) 943TW-MM-ENGY APM020-P4 Facilities Construction Project Management - Specialist (P4) 156

Advisor245 2TW-MM-GEN APM011-P4 Human Resources Project Management - Specialist (P4) 29TW-MM-ENGY APM011-P4 Human Resources Project Management - Specialist (P4) No Data

Advisor246 1MHRC-SIRS A361-4 Facilities Management - Level 4 Administrative 151TW-MM-GEN ARE020-P4 Facilities Management - Specialist (P4) 451TW-MM-ENGY ARE020-P4 Facilities Management - Specialist (P4) 21

Advisor247 2TW-MM-GEN AFY-P4 Risk Management - Specialist (P4) 243TW-MM-ENGY AFY-P4 Risk Management - Specialist (P4) 81

Advisor248 1RADFORD 6024 Risk Analyst 4 54TW-MM-GEN AFY000-P4 Risk Management Generalist/Multidiscipline - Specialist (P4) 243TW-MM-ENGY AFY000-P4 Risk Management Generalist/Multidiscipline - Specialist (P4) 81

Advisor249 1TW-MM-GEN ACD016-P4 Digital Strategy - Specialist (P4) 6TW-MM-ENGY ACD016-P4 Digital Strategy - Specialist (P4) No Data

Advisor250 1MHRC-SIRS A407-4 Acquisitions, Alliances and Licensing - Level 4 Administrative 149TW-MM-GEN ACD050-P4 Mergers and Acquisitions - Specialist (P4) 34TW-MM-ENGY ACD050-P4 Mergers and Acquisitions - Specialist (P4) No Data

Advisor251 2MHRC-SIRS A376-4 Supply Chain Planning - Level 4 Administrative 1,196TW-MM-GEN ASC010-P4 Supply Chain Development and Optimization - Specialist (P4) 732TW-MM-ENGY ASC010-P4 Supply Chain Development and Optimization - Specialist (P4) 33

Advisor252 3MHRC-SIRS A324-4 Supplier Diversity - Level 4 Administrative 20TW-MM-GEN ASC013-P4 Supplier Diversity Program Management - Specialist (P4) No DataTW-MM-ENGY ASC013-P4 Supplier Diversity Program Management - Specialist (P4) No Data

Advisor253 2TW-MM-GEN CUT020-P4 Application Engineering - Specialist (P4) 426TW-MM-ENGY CUT020-P4 Application Engineering - Specialist (P4) No Data

Audits Advisor254 7MHRC-SIRS A020-4 Auditing - Level 4 Administrative 471RADFORD 6174 Internal Auditor 4 72TW-MM-GEN AFU010-P4 General Audit - Specialist (P4) 423TW-MM-ENGY AFU010-P4 General Audit - Specialist (P4) 96

38Aon

40

Page 68: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Professional/TechnicalBus Ops Anlys, Advisor255 95

MHRC-SIRS A400-4 Administration - Generalist - Level 4 Administrative 2,269RADFORD 4684 Business Process Analyst 4 208TW-MM-GEN AEM070-P4 Business Operations Analysis - Specialist (P4) 1,376TW-MM-ENGY AEM070-P4 Business Operations Analysis - Specialist (P4) 313

Bus Process Imprvmt, Advisor256 8MHRC-SIRS A301-4 Business Process Analysis - Level 4 Administrative 3,613RADFORD 4684 Business Process Analyst 4 208TW-MM-GEN AQY020-P4 Business Process Improvement - Specialist (P4) 2,164TW-MM-ENGY AQY020-P4 Business Process Improvement - Specialist (P4) 365

Bus Sys Anlys, Advisor257 4MHRC-SIRS A301-4 Business Process Analysis - Level 4 Administrative 3,613RADFORD 6464 Business Systems Analyst 4 611TW-MM-GEN AID020-P4 Business Systems Analysis - Specialist (P4) 7,362TW-MM-ENGY AID020-P4 Business Systems Analysis - Specialist (P4) 578

Business Continuation, Advisor258 13MHRC-SIRS A459-4 Business Continuity - Level 4 Administrative 182TW-MM-GEN AAY010-P4 Business Continuation - Specialist (P4) 53TW-MM-ENGY AAY010-P4 Business Continuation - Specialist (P4) 36

Business Controls, Advisor259 8MHRC-SIRS A022-4 Auditing - IT Compliance - Level 4 Administrative 163RADFORD 6054 Information Systems Auditor 4 27TW-MM-GEN AFU020-P4 IS Audit - Specialist (P4) 95TW-MM-ENGY AFU020-P4 IS Audit - Specialist (P4) 32

Client Svc Del Mgmt, Advisor260 14TW-MM-GEN CDM000-S4 Client Service Delivery Management Generalist/Multidiscipline -

Expert (S4)590

TW-MM-ENGY CDM000-S4 Client Service Delivery Management Generalist/Multidiscipline - Expert (S4)

No Data

Comp, Advisor261 4MHRC-SIRS A293-4 Compensation - Level 4 Administrative 328RADFORD 6244 Compensation Analyst 4 50TW-MM-GEN AHR020-P4 Compensation Generalist/Multidiscipline - Specialist (P4) 371TW-MM-ENGY AHR020-P4 Compensation Generalist/Multidiscipline - Specialist (P4) 39

Contract Admin, Advisor262 10MHRC-SIRS A150-4 Contracts Administration - Level 4 Administrative 2,826TW-MM-GEN ALS020-P4 Contract Administration - Specialist (P4) 1,778TW-MM-ENGY ALS020-P4 Contract Administration - Specialist (P4) 222

Corp Comm, Advisor263 8MHRC-SIRS A260-4 Communications - External - Level 4 Administrative 591RADFORD 5564 Marketing Communications Specialist 4 93TW-MM-GEN ACA000-P4 Corporate Affairs/Communications Generalist/Multidiscipline -

Specialist (P4)249

TW-MM-ENGY ACA000-P4 Corporate Affairs/Communications Generalist/Multidiscipline - Specialist (P4)

94

Creative Dsgn Svcs, Advisor264 5TW-MM-GEN ACA120-P4 Creative Design Services - Specialist (P4) 269TW-MM-ENGY ACA120-P4 Creative Design Services - Specialist (P4) 20

39Aon

41

Page 69: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Professional/TechnicalElec Sys/Grid & Blk Pwr Trng, Advisor265 6

TW-MM-ENGY ETT000-P4 Electric System/Grid and Bulk Power Training Generalist/Multidiscipline - Specialist (P4)

67

Elec Trans & / Or Distrib Prj Mgr266 93TW-MM-ENGY APM530-P4 Electric Transmission and/or Distribution Project Management -

Specialist (P4)479

Engineer 3268 192MHRC-SIRS T412-4 Engineering Design - Level 4 Technical 3,334RADFORD 5124 Engineer 4 259TW-MM-GEN AZE000-P4 Engineering Generalist/Multidiscipline - Specialist (P4) 6,418TW-MM-ENGY AZE000-P4 Engineering Generalist/Multidiscipline - Specialist (P4) 3,525

Engy Effcncy / Cnsvrtion, Advisor269 57TW-MM-ENGY EDE000-P4 Energy Efficiency/Conservation Generalist/Multidiscipline -

Specialist (P4)108

Engy Mgmt Sys (EMS) Dev, Advisor270 9MHRC-SIRS T012-4 Software Development - Level 4 Technical 2,617RADFORD 5104 Software Development Engineer 4 4,437TW-MM-ENGY AID500-P4 Energy Management System Software Development - Specialist

(P4)89

Engy Mktg & Trdg Financl Anlys, Advisor271 5TW-MM-ENGY EML010-P4 Energy Marketing and Trading Financial Analysis - Specialist (P4) 69

Engy Trdg Ops / Support, Advisor272 6TW-MM-ENGY EMU000-P4 Energy Trading Operations/Support Generalist/Multidiscipline -

Specialist (P4)9

Envir Science, Advisor273 55MHRC-SIRS A457-4 Regulatory Compliance - Environmental - Level 4 Administrative 196TW-MM-GEN AHS010-P4 Environmental Science - Specialist (P4) 157TW-MM-ENGY AHS010-P4 Environmental Science - Specialist (P4) 429

Financl Anlys, Advisor274 22MHRC-SIRS A080-4 Financial Analysis - Level 4 Administrative 4,960RADFORD 6004 Financial Analyst 4 693TW-MM-GEN AFT010-P4 Financial Analysis - Specialist (P4) 6,800TW-MM-ENGY AFT010-P4 Financial Analysis - Specialist (P4) 456

Govt Reltns, Advisor275 34MHRC-SIRS A454-4 Government Affairs - Level 4 Administrative 199RADFORD 5934 Government Relations Specialist/Mgr 4 25TW-MM-GEN ACA070-P4 Government Relations - Specialist (P4) 281TW-MM-ENGY ACA070-P4 Government Relations - Specialist (P4) 151

Health & Sfty, Advisor276 40MHRC-SIRS T008-4 Occupational Safety and Health - Level 4 Technical 395RADFORD 6334 Environmental Health & Safety Engineer 4 48TW-MM-GEN AHS030-P4 Health and Safety - Specialist (P4) 272TW-MM-ENGY AHS030-P4 Health and Safety - Specialist (P4) 134

Info Tchnlgy Prj Mgr277 46MHRC-SIRS T350-4 Project Management - Information Technology - Level 4 Technical 2,628RADFORD 6624 Project (Information Systems) Mgr 4 157TW-MM-GEN APM010-P4 Information Technology Project Management - Specialist (P4) 3,350TW-MM-ENGY APM010-P4 Information Technology Project Management - Specialist (P4) 273

40Aon

42

Page 70: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Professional/TechnicalInvestigations, Advisor278 5

FOU-SEC 334 Senior Investigator IV 233MHRC-SIRS A458-4 Security Investigator - Level 4 Administrative 57RADFORD 6714 Security Analyst 4 92

IS Security, Advisor279 34MHRC-SIRS T049-4 Computer Systems Security - Level 4 Technical 1,994RADFORD 6584 Information Security Analyst 4 143TW-MM-GEN AIT070-P4 IS and Cyber Security - Specialist (P4) 1,669TW-MM-ENGY AIT070-P4 IS and Cyber Security - Specialist (P4) 169

IT Arch (Systems Design), Advisor280 14MHRC-SIRS S226-4 Systems Architecture - Information Technology - Level 4

Management326

RADFORD 5204 Systems Design/Architecture Engineer 4 1,392TW-MM-GEN AID030-P4 IT Architecture (Systems Design) - Specialist (P4) 4,806TW-MM-ENGY AID030-P4 IT Architecture (Systems Design) - Specialist (P4) 280

IT Dev, Advisor281 5RADFORD 6444 Systems Programmer 4 36TW-MM-GEN AID000-P4 IT Development Generalist/Multidiscipline - Specialist (P4) 3,697TW-MM-ENGY AID000-P4 IT Development Generalist/Multidiscipline - Specialist (P4) 317

IT Operations, Advisor282 7MHRC-SIRS A405-4 Information Systems - Generic (Administrative) - Level 4

Administrative336

TW-MM-GEN AIT000-P4 IT Administration Generalist/Multidiscipline - Specialist (P4) 1,668TW-MM-ENGY AIT000-P4 IT Administration Generalist/Multidiscipline - Specialist (P4) 195

IT Outsrcing Mgmt, Advisor283 30RADFORD 6694 IT Vendor Relations Spec/Mgr 4 266TW-MM-GEN AIT110-P4 IT Outsourcing Management - Specialist (P4) 12TW-MM-ENGY AIT110-P4 IT Outsourcing Management - Specialist (P4) No Data

Lgl Support, Advisor284 4TW-MM-GEN ALS000-P4 Legal Support Generalist/Multidiscipline - Specialist (P4) 79TW-MM-ENGY ALS000-P4 Legal Support Generalist/Multidiscipline - Specialist (P4) 15

Major Cnstrn Prj Mgr285 22TW-MM-ENGY APM510-P4 Major Construction Project Management - Specialist (P4) 162

Materials Mgmt, Advisor286 12MHRC-SIRS A375-4 Material Planning and Control - Level 4 Administrative 892RADFORD 4404 Materials Planner 4 91TW-MM-GEN ASC020-P4 Materials Management - Specialist (P4) 141TW-MM-ENGY ASC020-P4 Materials Management - Specialist (P4) 37

Mktg Comm, Advisor287 5RADFORD 5564 Marketing Communications Specialist 4 93TW-MM-GEN AMK020-P4 Advertising/Marketing Communications - Specialist (P4) 800TW-MM-ENGY AMK020-P4 Advertising/Marketing Communications - Specialist (P4) 8

Mktg Prgm Mgmt, Advisor288 4TW-MM-GEN AMK090-P4 Marketing Program Management - Specialist (P4) 92TW-MM-ENGY AMK090-P4 Marketing Program Management - Specialist (P4) 38

41Aon

43

Page 71: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Professional/TechnicalModelg, Fcstg & Econ Anlys, Advisor289 25

MHRC-SIRS A490-4 Metric and Data Analysis - Level 4 Administrative 246TW-MM-GEN AEM000-P4 Data Science/Analytics and Business Intelligence

Generalist/Multidiscipline - Specialist (P4)1,147

TW-MM-ENGY AEM000-P4 Data Science/Analytics and Business Intelligence Generalist/Multidiscipline - Specialist (P4)

200

Planning, Advisor290 68TW-MM-GEN APM000-P4 Project/Program Management Generalist/Multidiscipline - Specialist

(P4)10,382

TW-MM-GEN APM020-P4 Facilities Construction Project Management - Specialist (Professional)

943

TW-MM-ENGY APM000-P4 Project/Program Management Generalist/Multidiscipline - Specialist (P4)

795

TW-MM-ENGY APM020-P4 Facilities Construction Project Management - Specialist (Professional)

156

TW-MM-ENGY APM530-P4 Electric Transmission and/or Distribution Project Management - Specialist (Professional)

479

TW-MM-ENGY EGF020-P4 Fossil Power Maintenance Planning - Specialist (P4) 66

Power Systems Planner 3291 18TW-MM-ENGY AZE530-P4 Electric System/Grid Planning Engineering - Specialist (P4) 142

Prdctve Anlytcs/Data Science, Advisor292 11MHRC-SIRS T071-4 Data Science and Modeling - Level 4 Technical 232RADFORD 6704 Data Scientist 4 181TW-MM-GEN AEM060-P4 Data Science - Specialist (P4) 288TW-MM-ENGY AEM060-P4 Data Science - Specialist (P4) No Data

Prj Mgr293 65MHRC-SIRS A480-4 Project Management - Level 4 Administrative 8,749RADFORD 6634 Project (Admin) Mgr 4 712TW-MM-GEN APM000-P4 Project/Program Management Generalist/Multidiscipline - Specialist

(P4)10,382

TW-MM-ENGY APM000-P4 Project/Program Management Generalist/Multidiscipline - Specialist (P4)

795

Proj Cntrl Svcs Prj Mgr294 5TW-MM-ENGY APM027-P4 Construction Project Control Services - Specialist (P4) 92

Proprietary Telcom Sys, Advisor295 25TW-MM-ENGY EDD090-P4 Proprietary Telecommunications Systems - Specialist (P4) 40

Q A Methods, Advisor296 14MHRC-SIRS A073-4 Quality Analysis - Level 4 Administrative 660TW-MM-GEN AQY000-P4 Quality Assurance Methods Generalist/Multidiscipline - Specialist

(P4)1,472

TW-MM-ENGY AQY000-P4 Quality Assurance Methods Generalist/Multidiscipline - Specialist (P4)

41

Q Cntrl / Inspection, Advisor297 17MHRC-SIRS T435-4 Quality Control, Analysis and Test Services - Level 4 Technical 310TW-MM-GEN AZT060-P4 Quality Control/Inspection Technical Specialty - Specialist (P4) 247TW-MM-ENGY AZT060-P4 Quality Control/Inspection Technical Specialty - Specialist (P4) No Data

Rates, Advisor298 4TW-MM-ENGY AFT090-P4 Rates - Specialist (P4) 116

42Aon

44

Page 72: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Professional/TechnicalReal Estate & Fclties, Advisor299 12

MHRC-SIRS A366-4 Real Estate Management - Level 4 Administrative 297RADFORD 6314 Real Estate Specialist/Mgr 4 21TW-MM-GEN ARE000-P4 Real Estate and Facilities Generalist/Multidiscipline - Specialist (P4) 97TW-MM-ENGY ARE000-P4 Real Estate and Facilities Generalist/Multidiscipline - Specialist (P4) 12

Reg Affairs & Compl, Advisor300 36MHRC-SIRS A451-4 Regulatory Compliance - Level 4 Administrative 1,148RADFORD 55014 Regulatory Affairs Specialist 4 33TW-MM-GEN ACA050-P4 Regulatory Affairs and Compliance - Specialist (P4) 732TW-MM-ENGY ACA050-P4 Regulatory Affairs and Compliance - Specialist (P4) 309

Reg Compl Tech Ruls & Stds, Advisor301 12MHRC-SIRS A451-4 Regulatory Compliance - Level 4 Administrative 1,148RADFORD 5944 Regulatory Compliance Analyst/Mgr 4 64TW-MM-ENGY ACA540-P4 Regulatory Compliance - Technical Rules and Standards -

Specialist (P4)37

Security, Advisor302 4MHRC-SIRS A458-4 Security Investigator - Level 4 Administrative 57RADFORD 6714 Security Analyst 4 92TW-MM-GEN AAY000-P4 Security Generalist/Multidiscipline - Specialist (P4) 610TW-MM-ENGY AAY000-P4 Security Generalist/Multidiscipline - Specialist (P4) 86

Social Media Mktg, Advisor303 4MHRC-SIRS S131-4 Social Media and E-Communications - Level 4 Management 16RADFORD 5424 Social Media Relationships Specialist 4 147TW-MM-GEN AMK112-P4 Social Media Marketing - Specialist (P4) 55TW-MM-ENGY AMK112-P4 Social Media Marketing - Specialist (P4) No Data

Strgc Plng, Advisor304 4MHRC-SIRS A398-4 Strategic Planning - Level 4 Administrative 454RADFORD 5674 Strategic Business Developer 4 213TW-MM-GEN ACD010-P4 Strategic Planning - Specialist (P4) 343TW-MM-ENGY ACD010-P4 Strategic Planning - Specialist (P4) 27

Sup Chain, Advisor305 6MHRC-SIRS A376-4 Supply Chain Planning - Level 4 Administrative 1,196TW-MM-GEN ASC000-P4 Supply Chain and Logistics Generalist/Multidiscipline - Specialist

(P4)801

TW-MM-ENGY ASC000-P4 Supply Chain and Logistics Generalist/Multidiscipline - Specialist (P4)

59

Tax, Advisor306 8MHRC-SIRS A080-4 Financial Analysis - Level 4 Administrative 4,960RADFORD 6004 Financial Analyst 4 693TW-MM-GEN AFT000-P4 Financial Analysis and Tax Generalist/Multidiscipline - Specialist

(P4)385

TW-MM-ENGY AFT000-P4 Financial Analysis and Tax Generalist/Multidiscipline - Specialist (P4)

114

Tech Purchasing, Advisor307 40TW-MM-GEN ASC090-P4 Technical Purchasing - Specialist (P4) 300TW-MM-ENGY ASC090-P4 Technical Purchasing - Specialist (P4) 12

43Aon

45

Page 73: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Professional/TechnicalTech Spec, Advisor308 28

RADFORD 5824 Technical Support Engineer 4 97TW-MM-GEN AZT000-P4 Technical Specialty/Skilled Trade Generalist/Multidiscipline -

Specialist (P4)665

TW-MM-ENGY AZT000-P4 Technical Specialty/Skilled Trade Generalist/Multidiscipline - Specialist (P4)

378

Trade Shws / Evnts, Advisor309 4MHRC-SIRS A393-4 Trade Show Planning - Level 4 Administrative 95RADFORD 5544 Event Coordinator 4 54TW-MM-GEN AMK100-P4 Trade Shows/Events - Specialist (P4) 164TW-MM-ENGY AMK100-P4 Trade Shows/Events - Specialist (P4) No Data

Web Cntnt Mgmt / Prdctn, Advisor310 5MHRC-SIRS A424-4 Internet/Digital Web Marketing - Level 4 Administrative 337RADFORD 5494 Web Producer/Executive Producer 4 100TW-MM-GEN AMK120-P4 Digital Content Management - Specialist (P4) 124TW-MM-ENGY AMK120-P4 Digital Content Management - Specialist (P4) 9

Workers Comp, Advisor311 9MHRC-SIRS A136-4 Worker's Compensation Claims Analysis - Level 4 Administrative 9TW-MM-GEN AHS070-P4 Workers' Compensation Case Management - Specialist (P4) 9TW-MM-ENGY AHS070-P4 Workers' Compensation Case Management - Specialist (P4) No Data

Bus Ops Anlys, Sr Advisor312 46MHRC-SIRS A400-5 Administration - Generalist - Level 5 Administrative 1,487RADFORD 4685 Business Process Analyst 5 115TW-MM-GEN AEM070-P5 Business Operations Analysis - Master (P5) 188TW-MM-ENGY AEM070-P5 Business Operations Analysis - Master (P5) 22

Bus Process Imprvmt, Sr Advisor313 10MHRC-SIRS A301-5 Business Process Analysis - Level 5 Administrative 1,183RADFORD 4685 Business Process Analyst 5 115TW-MM-GEN AQY020-P5 Business Process Improvement - Master (P5) 377TW-MM-ENGY AQY020-P5 Business Process Improvement - Master (P5) 52

Business Continuation, Sr Advisor314 10MHRC-SIRS A459-5 Business Continuity - Level 5 Administrative 40TW-MM-GEN AAY010-P5 Business Continuation - Master (P5) No DataTW-MM-ENGY AAY010-P5 Business Continuation - Master (P5) No Data

Client Svc Del Mgmt, Sr Advisor315 19TW-MM-GEN CDM000-S5 Client Service Delivery Management Generalist/Multidiscipline -

Senior Expert (S5)248

TW-MM-ENGY CDM000-S5 Client Service Delivery Management Generalist/Multidiscipline - Senior Expert (S5)

No Data

Corp Comm, Sr Advisor316 15MHRC-SIRS A260-5 Communications - External - Level 5 Administrative 315RADFORD 5565 Marketing Communications Specialist 5 34TW-MM-GEN ACA000-P5 Corporate Affairs/Communications Generalist/Multidiscipline -

Master (P5)106

TW-MM-ENGY ACA000-P5 Corporate Affairs/Communications Generalist/Multidiscipline - Master (P5)

36

44Aon

46

Page 74: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Professional/TechnicalEnvir Affairs & Compl, Sr Advisor317 10

MHRC-SIRS A457-5 Regulatory Compliance - Environmental - Level 5 Administrative 54RADFORD 6335 Environmental Health & Safety Engineer 5 7TW-MM-GEN ACA060-P5 Environmental Affairs and Compliance - Master (P5) 13TW-MM-ENGY ACA060-P5 Environmental Affairs and Compliance - Master (P5) 22

Envir Science, Sr Advisor318 23MHRC-SIRS A457-5 Regulatory Compliance - Environmental - Level 5 Administrative 54TW-MM-GEN AHS010-P5 Environmental Science - Master (P5) 26TW-MM-ENGY AHS010-P5 Environmental Science - Master (P5) 36

Financl Anlys, Sr Advisor319 27MHRC-SIRS A080-5 Financial Analysis - Level 5 Administrative 1,145RADFORD 6005 Financial Analyst 5 251TW-MM-GEN AFT010-P5 Financial Analysis - Master (P5) 1,816TW-MM-ENGY AFT010-P5 Financial Analysis - Master (P5) 117

Govt Reltns, Sr Advisor320 10MHRC-SIRS A454-5 Government Affairs - Level 5 Administrative 294RADFORD 5935 Government Relations Specialist/Mgr 5 30TW-MM-GEN ACA070-P5 Government Relations - Master (P5) 193TW-MM-ENGY ACA070-P5 Government Relations - Master (P5) 42

Health & Sfty, Sr Advisor321 8MHRC-SIRS T008-5 Occupational Safety and Health - Level 5 Technical 154RADFORD 6335 Environmental Health & Safety Engineer 5 7TW-MM-GEN AHS030-P5 Health and Safety - Master (P5) 122TW-MM-ENGY AHS030-P5 Health and Safety - Master (P5) No Data

HR Gnrlst / Consult, Sr Advisor322 15MHRC-SIRS A299-5 Human Resources Business Partner - Level 5 Administrative 528RADFORD 6205 Human Resources Representative 5 18TW-MM-GEN AHR000-P5 HR Generalist/Consultant Generalist/Multidiscipline - Master (P5) 897TW-MM-ENGY AHR000-P5 HR Generalist/Consultant Generalist/Multidiscipline - Master (P5) 21

Investigations, Sr Advisor323 10RADFORD 6715 Security Analyst 5 157

IS Security, Sr Advisor324 8MHRC-SIRS T049-5 Computer Systems Security - Level 5 Technical 681RADFORD 6585 Information Security Analyst 5 101TW-MM-GEN AIT070-P5 IS and Cyber Security - Master (P5) 455TW-MM-ENGY AIT070-P5 IS and Cyber Security - Master (P5) 32

IT Arch (Systems Design), Sr Advisor325 15MHRC-SIRS S226-5 Systems Architecture - Information Technology - Level 5

Management186

RADFORD 5205 Systems Design/Architecture Engineer 5 1,242TW-MM-GEN AID030-P5 IT Architecture (Systems Design) - Master (P5) 2,020TW-MM-ENGY AID030-P5 IT Architecture (Systems Design) - Master (P5) 97

IT Asset Mgmt, Sr Advisor326 6RADFORD 6695 IT Vendor Relations Spec/Mgr 5 127TW-MM-GEN AIT100-P5 IT Asset Management - Master (P5) No DataTW-MM-ENGY AIT100-P5 IT Asset Management - Master (P5) No Data

45Aon

47

Page 75: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Professional/TechnicalIT Dev, Sr Advisor327 7

RADFORD 6445 Systems Programmer 5 27TW-MM-GEN AID000-P5 IT Development Generalist/Multidiscipline - Master (P5) 1,089TW-MM-ENGY AID000-P5 IT Development Generalist/Multidiscipline - Master (P5) 49

IT Operations, Sr Advisor328 5MHRC-SIRS A405-5 Information Systems - Generic (Administrative) - Level 5

Administrative43

TW-MM-GEN AIT000-P5 IT Administration Generalist/Multidiscipline - Master (P5) 281TW-MM-ENGY AIT000-P5 IT Administration Generalist/Multidiscipline - Master (P5) 16

IT Outsrcing Mgmt, Sr Advisor329 19RADFORD 6695 IT Vendor Relations Spec/Mgr 5 127TW-MM-GEN AIT110-P5 IT Outsourcing Management - Master (P5) No DataTW-MM-ENGY AIT110-P5 IT Outsourcing Management - Master (P5) No Data

IT Svc Del & Relation Mgmt, Sr Advisor330 6RADFORD 5705 Client Relationship Mgr 5 424TW-MM-GEN AIT120-P5 IT Service Delivery and Relationship Management - Master (P5) 20TW-MM-ENGY AIT120-P5 IT Service Delivery and Relationship Management - Master (P5) No Data

Learning & Dev, Sr Advisor331 4MHRC-SIRS A285-5 Training/Learning Development - Level 5 Administrative 336RADFORD R06035 Human Resources - All Professional Roll-Up 5 356TW-MM-GEN AHR130-P5 Employee Development/Training Generalist/Multidiscipline - Master

(P5)206

TW-MM-ENGY AHR130-P5 Employee Development/Training Generalist/Multidiscipline - Master (P5)

8

Modelg, Fcstg & Econ Anlys, Sr Advisor332 22MHRC-SIRS A490-5 Metric and Data Analysis - Level 5 Administrative 66TW-MM-GEN AEM000-P5 Data Science/Analytics and Business Intelligence

Generalist/Multidiscipline - Master (P5)333

TW-MM-ENGY AEM000-P5 Data Science/Analytics and Business Intelligence Generalist/Multidiscipline - Master (P5)

60

Org Dev, Sr Advisor333 8MHRC-SIRS A287-5 Organization Development - Level 5 Administrative 157RADFORD 6035 Organizational Development Specialist 5 38TW-MM-GEN AHR120-P5 Organization Development - Master (P5) 97TW-MM-ENGY AHR120-P5 Organization Development - Master (P5) No Data

Q A Methods, Sr Advisor334 6MHRC-SIRS A073-5 Quality Analysis - Level 5 Administrative 94TW-MM-GEN AQY000-P5 Quality Assurance Methods Generalist/Multidiscipline - Master (P5) 224TW-MM-ENGY AQY000-P5 Quality Assurance Methods Generalist/Multidiscipline - Master (P5) 8

Rates, Sr Advisor335 13TW-MM-ENGY AFT090-P5 Rates - Master (P5) 28

Reg Affairs & Compl, Sr Advisor336 42MHRC-SIRS A451-5 Regulatory Compliance - Level 5 Administrative 459RADFORD 55015 Regulatory Affairs Specialist 5 83TW-MM-GEN ACA050-P5 Regulatory Affairs and Compliance - Master (P5) 201TW-MM-ENGY ACA050-P5 Regulatory Affairs and Compliance - Master (P5) 153

46Aon

48

Page 76: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Professional/TechnicalReg Compl Tech Ruls & Stds, Sr Advisor337 12

MHRC-SIRS A451-5 Regulatory Compliance - Level 5 Administrative 459RADFORD 5945 Regulatory Compliance Analyst/Mgr 5 23TW-MM-ENGY ACA540-P5 Regulatory Compliance - Technical Rules and Standards - Master

(P5)No Data

Senior Engineer338 94MHRC-SIRS T412-5 Engineering Design - Level 5 Technical 931RADFORD 5125 Engineer 5 176TW-MM-GEN AZE000-P5 Engineering Generalist/Multidiscipline - Master (P5) 1,816TW-MM-ENGY AZE000-P5 Engineering Generalist/Multidiscipline - Master (P5) 826

Senior Power Systems Planner339 7TW-MM-ENGY AZE530-P5 Electric System/Grid Planning Engineering - Master (P5) 36

Senior Advisor340 2TW-MM-GEN AFU-P5 Audit and Financial/Business Controls - Master (P5) 245TW-MM-ENGY AFU-P5 Audit and Financial/Business Controls - Master (P5) 49

Senior Advisor341 1MHRC-SIRS A020-5 Auditing - Level 5 Administrative 129RADFORD 6175 Internal Auditor 5 28TW-MM-GEN AFU010-P5 General Audit - Master (P5) 92TW-MM-ENGY AFU010-P5 General Audit - Master (P5) 33

Senior Advisor342 1MHRC-SIRS A022-5 Auditing - IT Compliance - Level 5 Administrative 66TW-MM-GEN AFU020-P5 IS Audit - Master (P5) 9TW-MM-ENGY AFU020-P5 IS Audit - Master (P5) No Data

Senior Advisor343 1MHRC-SIRS A100-5 Accounting - General - Level 5 Administrative 358RADFORD 6105 Accountant (General) 5 78TW-MM-GEN AFB000-P5 Accounting Generalist/Multidiscipline - Master (P5) 168TW-MM-ENGY AFB000-P5 Accounting Generalist/Multidiscipline - Master (P5) 14

Senior Advisor344 1RADFORD 6195 Financial Reporting Analyst/Mgr 5 111TW-MM-GEN AFB020-P5 Financial Reporting - Master (P5) 45TW-MM-ENGY AFB020-P5 Financial Reporting - Master (P5) No Data

Senior Advisor345 1MHRC-SIRS A100-5 Accounting - General - Level 5 Administrative 358RADFORD 6105 Accountant (General) 5 78TW-MM-GEN AFB010-P5 General Accounting - Master (P5) 226TW-MM-ENGY AFB010-P5 General Accounting - Master (P5) 48

Senior Advisor346 1RADFORD 6115 Payroll Analyst 5 17TW-MM-GEN AFB070-P5 Payroll - Master (P5) 8TW-MM-ENGY AFB070-P5 Payroll - Master (P5) No Data

Senior Advisor347 1RADFORD 5695 Account Services Mgr 5 14TW-MM-GEN CAM000-S5 Account/Relationship Management Generalist/Multidiscipline -

Senior Expert (S5)982

TW-MM-ENGY CAM000-S5 Account/Relationship Management Generalist/Multidiscipline - Senior Expert (S5)

26

47Aon

49

Page 77: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Professional/TechnicalSenior Advisor348 3

MHRC-SIRS A262-5 Corporate Social Responsibility - Level 5 Administrative 66TW-MM-GEN ACA040-P5 Corporate Giving - Master (P5) No DataTW-MM-ENGY ACA040-P5 Corporate Giving - Master (P5) No Data

Senior Advisor349 1RADFORD 5625 Marketing Publications Writer 5 29TW-MM-GEN ACA110-P5 Creative Writing Services - Master (P5) No DataTW-MM-ENGY ACA110-P5 Creative Writing Services - Master (P5) No Data

Senior Advisor350 2MHRC-SIRS A139-5 Investor Relations - Level 5 Administrative 12RADFORD 6185 Investor Relations Specialist 5 40TW-MM-GEN ACA090-P5 Investor Relations - Master (P5) 10TW-MM-ENGY ACA090-P5 Investor Relations - Master (P5) No Data

Senior Advisor351 1MHRC-SIRS A260-5 Communications - External - Level 5 Administrative 315RADFORD 5515 Public Relations Representative 5 43TW-MM-GEN ACA010-P5 Public Relations - Master (P5) 100TW-MM-ENGY ACA010-P5 Public Relations - Master (P5) No Data

Senior Advisor352 1MHRC-SIRS T036-5 Engineering - Environmental, Health and Safety - Level 5 Technical 211RADFORD 6335 Environmental Health & Safety Engineer 5 7TW-MM-GEN AHS000-P5 Environmental Health and Safety Generalist/Multidiscipline - Master

(P5)146

TW-MM-ENGY AHS000-P5 Environmental Health and Safety Generalist/Multidiscipline - Master (P5)

12

Senior Advisor353 2MHRC-SIRS T023-5 Hygiene - Industrial - Level 5 Technical 72TW-MM-GEN AHS040-P5 Industrial Hygiene - Master (P5) No DataTW-MM-ENGY AHS040-P5 Industrial Hygiene - Master (P5) No Data

Senior Advisor354 1MHRC-SIRS T227-5 Engineering - Environmental - Level 5 Technical 94TW-MM-GEN AZE120-P5 Environmental Engineering - Master (P5) 102TW-MM-ENGY AZE120-P5 Environmental Engineering - Master (P5) 14

Senior Advisor355 1MHRC-SIRS A130-5 Insurance/Risk Management - Level 5 Administrative 27RADFORD 6025 Risk Analyst 5 180TW-MM-GEN AFT080-P5 Insurance Risk - Master (P5) 8TW-MM-ENGY AFT080-P5 Insurance Risk - Master (P5) No Data

Senior Advisor356 2MHRC-SIRS A275-5 Employee Benefits - Level 5 Administrative 81RADFORD 6255 Benefits Analyst 5 18TW-MM-GEN AHR060-P5 Benefits - Master (P5) 73TW-MM-ENGY AHR060-P5 Benefits - Master (P5) 8

Senior Advisor357 2MHRC-SIRS A293-5 Compensation - Level 5 Administrative 183RADFORD 6245 Compensation Analyst 5 27TW-MM-GEN AHR020-P5 Compensation Generalist/Multidiscipline - Master (P5) 136TW-MM-ENGY AHR020-P5 Compensation Generalist/Multidiscipline - Master (P5) No Data

48Aon

50

Page 78: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Professional/TechnicalSenior Advisor358 1

MHRC-SIRS A280-5 Labor Relations - Level 5 Administrative 30TW-MM-GEN AHR100-P5 Labor Relations - Master (P5) 26TW-MM-ENGY AHR100-P5 Labor Relations - Master (P5) No Data

Senior Advisor359 3MHRC-SIRS A287-5 Organization Development - Level 5 Administrative 157TW-MM-GEN AHR132-P5 Management Development - Master (P5) No DataTW-MM-ENGY AHR132-P5 Management Development - Master (P5) No Data

Senior Advisor360 1MHRC-SIRS A281-5 Talent Acquisition - Level 5 Administrative 181RADFORD 6225 Staffing/Employment Representative 5 99TW-MM-GEN AHR140-P5 Recruitment Generalist/Multidiscipline - Master (P5) 116TW-MM-ENGY AHR140-P5 Recruitment Generalist/Multidiscipline - Master (P5) No Data

Senior Advisor361 2RADFORD 5795 Workforce Analyst/Mgr 5 49TW-MM-GEN AHR122-P5 Workforce Analytics - Master (P5) No DataTW-MM-ENGY AHR122-P5 Workforce Analytics - Master (P5) No Data

Senior Advisor362 3MHRC-SIRS T052-5 Systems Architecture - Information Technology - Level 5 Technical 1,356RADFORD 5205 Systems Design/Architecture Engineer 5 1,242TW-MM-ENGY AID510-P5 Energy Management System Architecture - Master (P5) No Data

Senior Advisor363 2MHRC-SIRS T029-5 Network Engineering - Level 5 Technical 514RADFORD 4825 Network Planning Engineer 5 300TW-MM-GEN AID090-P5 Network Planning and Implementation - Master (P5) 141TW-MM-ENGY AID090-P5 Network Planning and Implementation - Master (P5) No Data

Senior Advisor364 1MHRC-SIRS U004-5 Law - Tax - Level 5 Technical 10TW-MM-GEN ALG080-P5 Tax Law - Master (P5) No DataTW-MM-ENGY ALG080-P5 Tax Law - Master (P5) No Data

Senior Advisor365 2MHRC-SIRS A150-5 Contracts Administration - Level 5 Administrative 991TW-MM-GEN ALS020-P5 Contract Administration - Master (P5) 522TW-MM-ENGY ALS020-P5 Contract Administration - Master (P5) 25

Senior Advisor366 2TW-MM-GEN ALS000-P5 Legal Support Generalist/Multidiscipline - Master (P5) 32TW-MM-ENGY ALS000-P5 Legal Support Generalist/Multidiscipline - Master (P5) No Data

Senior Advisor367 3MHRC-SIRS T071-5 Data Science and Modeling - Level 5 Technical 100RADFORD 6705 Data Scientist 5 48TW-MM-GEN AEM060-P5 Data Science - Master (P5) 97TW-MM-ENGY AEM060-P5 Data Science - Master (P5) No Data

Senior Advisor368 1MHRC-SIRS A235-5 Promotion/Advertising - Level 5 Administrative 181TW-MM-GEN AMK025-P5 Advertising - Master (P5) No DataTW-MM-ENGY AMK025-P5 Advertising - Master (P5) No Data

49Aon

51

Page 79: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Professional/TechnicalSenior Advisor369 2

RADFORD 5565 Marketing Communications Specialist 5 34TW-MM-GEN AMK020-P5 Advertising/Marketing Communications - Master (P5) 217TW-MM-ENGY AMK020-P5 Advertising/Marketing Communications - Master (P5) No Data

Senior Advisor370 1MHRC-SIRS A250-5 Marketing Research/Planning - Level 5 Administrative 381RADFORD 5605 Market Research Analyst 5 34TW-MM-GEN AMK000-P5 Marketing Generalist/Multidiscipline - Master (P5) 612TW-MM-ENGY AMK000-P5 Marketing Generalist/Multidiscipline - Master (P5) No Data

Senior Advisor371 2MHRC-SIRS A244-5 Product Marketing - Level 5 Administrative 276TW-MM-GEN AMK050-P5 Product Management - Master (P5) 1,869TW-MM-ENGY AMK050-P5 Product Management - Master (P5) No Data

Senior Advisor372 3RADFORD 5545 Event Coordinator 5 14TW-MM-GEN AMK100-P5 Trade Shows/Events - Master (P5) 22TW-MM-ENGY AMK100-P5 Trade Shows/Events - Master (P5) No Data

Senior Advisor373 2MHRC-SIRS A424-5 Internet/Digital Web Marketing - Level 5 Administrative 74RADFORD 5495 Web Producer/Executive Producer 5 87TW-MM-GEN AMK120-P5 Digital Content Management - Master (P5) 17TW-MM-ENGY AMK120-P5 Digital Content Management - Master (P5) No Data

Senior Advisor374 3MHRC-SIRS A361-5 Facilities Management - Level 5 Administrative 50TW-MM-GEN ARE020-P5 Facilities Management - Master (P5) 73TW-MM-ENGY ARE020-P5 Facilities Management - Master (P5) No Data

Senior Advisor375 1MHRC-SIRS A366-5 Real Estate Management - Level 5 Administrative 42RADFORD 6315 Real Estate Specialist/Mgr 5 67TW-MM-GEN ARE000-P5 Real Estate and Facilities Generalist/Multidiscipline - Master (P5) 5TW-MM-ENGY ARE000-P5 Real Estate and Facilities Generalist/Multidiscipline - Master (P5) No Data

Senior Advisor376 3TW-MM-GEN AFY-P5 Risk Management - Master (P5) 73TW-MM-ENGY AFY-P5 Risk Management - Master (P5) 9

Senior Advisor377 3MHRC-SIRS A398-5 Strategic Planning - Level 5 Administrative 508TW-MM-GEN ACD000-P5 Strategic Planning/Corporate Development

Generalist/Multidiscipline - Master (P5)338

TW-MM-ENGY ACD000-P5 Strategic Planning/Corporate Development Generalist/Multidiscipline - Master (P5)

13

Senior Advisor378 3MHRC-SIRS A375-5 Material Planning and Control - Level 5 Administrative 123RADFORD 4405 Materials Planner 5 234TW-MM-GEN ASC020-P5 Materials Management - Master (P5) No DataTW-MM-ENGY ASC020-P5 Materials Management - Master (P5) No Data

50Aon

52

Page 80: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Professional/TechnicalSenior Advisor379 2

MHRC-SIRS A376-5 Supply Chain Planning - Level 5 Administrative 225TW-MM-GEN ASC010-P5 Supply Chain Development and Optimization - Master (P5) 217TW-MM-ENGY ASC010-P5 Supply Chain Development and Optimization - Master (P5) No Data

Senior Advisor380 3RADFORD 6715 Security Analyst 5 157TW-MM-GEN AAY000-P5 Security Generalist/Multidiscipline - Master (P5) 138TW-MM-ENGY AAY000-P5 Security Generalist/Multidiscipline - Master (P5) No Data

Senior Advisor381 2MHRC-SIRS A120-5 Accounting - Tax - Level 5 Administrative 178RADFORD 6125 Tax Accountant 5 27TW-MM-GEN AFT060-P5 Tax Planning and Research - Master (P5) 8TW-MM-ENGY AFT060-P5 Tax Planning and Research - Master (P5) No Data

Senior Advisor382 1MHRC-SIRS A120-5 Accounting - Tax - Level 5 Administrative 178RADFORD 6125 Tax Accountant 5 27TW-MM-GEN AFT050-P5 Tax Reporting and Compliance - Master (P5) 257TW-MM-ENGY AFT050-P5 Tax Reporting and Compliance - Master (P5) 48

Senior Advisor383 1MHRC-SIRS U040-5 Pilot - Level 5 Technical 266TW-MM-GEN AAT050-P5 Aviation - Pilots - Master (P5) 172TW-MM-ENGY AAT050-P5 Aviation - Pilots - Master (P5) No Data

Strgc Plng, Sr Advisor384 17MHRC-SIRS A398-5 Strategic Planning - Level 5 Administrative 508RADFORD 5675 Strategic Business Developer 5 205TW-MM-GEN ACD010-P5 Strategic Planning - Master (P5) 209TW-MM-ENGY ACD010-P5 Strategic Planning - Master (P5) No Data

Sup Chain, Sr Advisor385 7MHRC-SIRS A376-5 Supply Chain Planning - Level 5 Administrative 225TW-MM-GEN ASC000-P5 Supply Chain and Logistics Generalist/Multidiscipline - Master (P5) 87TW-MM-ENGY ASC000-P5 Supply Chain and Logistics Generalist/Multidiscipline - Master (P5) No Data

Tax, Sr Advisor386 5MHRC-SIRS A080-5 Financial Analysis - Level 5 Administrative 1,145RADFORD 6005 Financial Analyst 5 251TW-MM-GEN AFT000-P5 Financial Analysis and Tax Generalist/Multidiscipline - Master (P5) 82TW-MM-ENGY AFT000-P5 Financial Analysis and Tax Generalist/Multidiscipline - Master (P5) 8

Tech Spec, Sr Advisor387 20RADFORD 5825 Technical Support Engineer 5 44TW-MM-GEN AZT000-P5 Technical Specialty/Skilled Trade Generalist/Multidiscipline -

Master (P5)24

TW-MM-ENGY AZT000-P5 Technical Specialty/Skilled Trade Generalist/Multidiscipline - Master (P5)

No Data

Tech Training, Sr Advisor388 4MHRC-SIRS A286-5 Training - Technical Product - Level 5 Administrative 329RADFORD 5895 Technical Course Developer 5 210TW-MM-GEN AHR134-P5 Technical Training - Master (P5) 12TW-MM-ENGY AHR134-P5 Technical Training - Master (P5) No Data

51Aon

53

Page 81: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Professional/TechnicalConsulting Engineer389 8

MHRC-SIRS T412-6 Engineering Design - Level 6 Technical No DataRADFORD 5126 Engineer 6 570TW-MM-GEN AZE000-P6 Engineering Generalist/Multidiscipline - Renowned Expert (P6) 204TW-MM-ENGY AZE000-P6 Engineering Generalist/Multidiscipline - Renowned Expert (P6) 69

Mgr390 2TW-MM-GEN ALG065-M2 Corporate Governance - Manager (M2) 8TW-MM-ENGY ALG065-M2 Corporate Governance - Manager (M2) No Data

52Aon

54

Page 82: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Manager/SupervisorSup391 1

MHRC-SIRS S176-2 Human Resources Business Partner - Level 2 Management 349RADFORD 3202 Human Resources Mgmt 2 177TW-MM-GEN AHR-M1 Human Resources - Supervisor (M1) 1,814TW-MM-ENGY AHR-M1 Human Resources - Supervisor (M1) 286

Sup392 3RADFORD 2792 Technical Support Mgmt 2 758TW-MM-GEN AZT-M1 Technical Specialty/Skilled Trade - Supervisor (M1) 8,359TW-MM-ENGY AZT-M1 Technical Specialty/Skilled Trade - Supervisor (M1) 760

Sup393 1TW-MM-GEN EVM-M1 Vegetation Management and Forestry - Supervisor

(Supervisory/Management)No Data

TW-MM-ENGY EVM-M1 Vegetation Management and Forestry - Supervisor (Supervisory/Management)

118

Sup394 1MHRC-SIRS S972-2 Worker's Compensation Claims Analysis - Level 2 Management No DataTW-MM-GEN AHS070-M1 Workers' Compensation Case Management - Supervisor (M1) 9TW-MM-ENGY AHS070-M1 Workers' Compensation Case Management - Supervisor (M1) No Data

Sup, Apparatus395 5TW-MM-ENGY EDD-M1 Energy Delivery/Distribution - Supervisor (Supervisory/Management) 6,697

Sup, Cnstrn396 12TW-MM-ENGY EDD-M1 Energy Delivery/Distribution - Supervisor (Supervisory/Management) 6,697

Sup, Engy Del / Distrib397 12TW-MM-ENGY EDD-M1 Energy Delivery/Distribution - Supervisor (Supervisory/Management) 6,697

Sup, Field398 78TW-MM-ENGY EDD-M1 Energy Delivery/Distribution - Supervisor (Supervisory/Management) 6,697

Sup, General Foreman399 82TW-MM-ENGY EDD-M1 Energy Delivery/Distribution - Supervisor (Supervisory/Management) 6,697

Sup, Project General Sup400 38TW-MM-ENGY EDD-M1 Energy Delivery/Distribution - Supervisor (Supervisory/Management) 6,697

Sup, Real Estate & Fclties401 5MHRC-SIRS S305-2 Real Estate Management - Level 2 Management 39RADFORD 3312 Real Estate Mgmt 2 25TW-MM-GEN ARE-M1 Real Estate and Facilities - Supervisor (M1) 1,977TW-MM-ENGY ARE-M1 Real Estate and Facilities - Supervisor (M1) 364

Sup, Substn Ops402 5TW-MM-ENGY EDD-M1 Energy Delivery/Distribution - Supervisor (Supervisory/Management) 6,697

Eng Sr Prj Mgr405 5TW-MM-GEN APM030-P5 Engineering Project Management - Master (P5) 1,386TW-MM-ENGY APM030-P5 Engineering Project Management - Master (P5) No Data

Fclties Cnstrn Sr Prj Mgr406 7RADFORD 6355 Project (Construction) Mgr 5 128TW-MM-GEN APM020-P5 Facilities Construction Project Management - Master (P5) 245TW-MM-ENGY APM020-P5 Facilities Construction Project Management - Master (P5) No Data

53Aon

55

Page 83: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Manager/SupervisorInfo Tchnlgy Sr Prj Mgr407 6

MHRC-SIRS T350-5 Project Management - Information Technology - Level 5 Technical 1,092RADFORD 6625 Project (Information Systems) Mgr 5 112TW-MM-GEN APM010-P5 Information Technology Project Management - Master (P5) 965TW-MM-ENGY APM010-P5 Information Technology Project Management - Master (P5) 73

Major Cnstrn Sr Prj Mgr408 8TW-MM-ENGY APM510-P5 Major Construction Project Management - Master (P5) 16

Senior Attorney410 57EMPS-WORKS ATTY-L4 Senior Attorney 323HILDE-LAW SEC Senior Counsel 1,253MHRC-SIRS U001-5 Law - General - Level 5 Technical 970

Senior Advisor412 2TW-MM-GEN APM050-P5 Product Development Project/Program Management - Master (P5) 492TW-MM-ENGY APM050-P5 Product Development Project/Program Management - Master (P5) No Data

Sr Prj Mgr413 43MHRC-SIRS A480-5 Project Management - Level 5 Administrative 3,410RADFORD 6635 Project (Admin) Mgr 5 468TW-MM-GEN APM000-P5 Project/Program Management Generalist/Multidiscipline - Master

(P5)3,737

TW-MM-ENGY APM000-P5 Project/Program Management Generalist/Multidiscipline - Master (P5)

292

Mgr414 3TW-MM-GEN CAM-M2 Account/Relationship Management - Manager (M2) 2,315TW-MM-ENGY CAM-M2 Account/Relationship Management - Manager (M2) 134

Mgr415 1MHRC-SIRS S332-3 Administration - Generalist - Level 3 Management 320TW-MM-GEN AAS-M2 Administrative Services - Manager (M2) 3,349TW-MM-ENGY AAS-M2 Administrative Services - Manager (M2) 147

Mgr416 3MHRC-SIRS S063-3 Customer Service - Level 3 Management 840RADFORD 2803 Customer Service Mgmt 3 105TW-MM-GEN AMS-M2 Customer Support/Operations - Manager (M2) 5,378TW-MM-ENGY AMS-M2 Customer Support/Operations - Manager (M2) 545

Mgr417 1TW-MM-ENGY ETT-M2 Electric System/Grid and Bulk Power Training - Manager

(Supervisory/Management)25

Mgr418 1MHRC-SIRS S213-3 Computer Systems Security - Level 3 Management 346RADFORD 3583 Information Security Mgmt 3 25TW-MM-GEN AIT070-M2 IS and Cyber Security - Manager (M2) 442TW-MM-ENGY AIT070-M2 IS and Cyber Security - Manager (M2) 118

Mgr419 2RADFORD 3433 IT Support Mgmt 3 10TW-MM-GEN AIT020-M2 IT Help Desk Support - Manager (M2) 665TW-MM-ENGY AIT020-M2 IT Help Desk Support - Manager (M2) 29

Mgr420 2TW-MM-GEN ALS-M2 Legal Support - Manager (M2) 922TW-MM-ENGY ALS-M2 Legal Support - Manager (M2) 139

54Aon

56

Page 84: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Manager/SupervisorMgr421 1

MHRC-SIRS S132-3 Marketing - Multiple Functions - Level 3 Management 315RADFORD 2503 Marketing Mgmt 3 206TW-MM-GEN AMK-M2 Marketing - Manager (M2) 7,682TW-MM-ENGY AMK-M2 Marketing - Manager (M2) 281

Mgr422 1MHRC-SIRS S905-3 Regulatory Compliance - Level 3 Management 429RADFORD 15023 Regulatory Affairs Mgmt 3 231TW-MM-GEN ACA050-M2 Regulatory Affairs and Compliance - Manager (M2) 430TW-MM-GEN ACA070-M2 Government Relations - Manager (M2) 140TW-MM-ENGY ACA050-M2 Regulatory Affairs and Compliance - Manager (M2) 212TW-MM-ENGY ACA070-M2 Government Relations - Manager (M2) 72TW-MM-ENGY ACA540-M2 Regulatory Compliance - Technical Rules and Standards -

Manager (M2)23

Mgr423 2MHRC-SIRS S720-3 Supply Chain Planning - Level 3 Management 598RADFORD 1463 Supply Chain/Procurement Mgmt 3 70TW-MM-GEN ASC000-M2 Supply Chain and Logistics Generalist/Multidiscipline - Manager

(M2)3,558

TW-MM-ENGY ASC000-M2 Supply Chain and Logistics Generalist/Multidiscipline - Manager (M2)

110

Mgr424 1MHRC-SIRS S454-3 Business Continuity - Level 3 Management 27RADFORD 2913 Business Continuity Mgmt 3 19TW-MM-GEN AAY010-M2 Business Continuation - Manager (M2) 27TW-MM-ENGY AAY010-M2 Business Continuation - Manager (M2) 36

Mgr425 1RADFORD 3343 Security Mgmt 3 79TW-MM-GEN AAY-M2 Security - Manager (M2) 695TW-MM-ENGY AAY-M2 Security - Manager (M2) 279

Mgr426 1TW-MM-GEN AAT050-M2 Aviation - Pilots - Manager (M2) 50TW-MM-ENGY AAT050-M2 Aviation - Pilots - Manager (M2) 9

Mgr427 1MHRC-SIRS S972-3 Worker's Compensation Claims Analysis - Level 3 Management 18TW-MM-GEN AHS070-M2 Workers' Compensation Case Management - Manager (M2) 41TW-MM-ENGY AHS070-M2 Workers' Compensation Case Management - Manager (M2) 6

Mgr, Acctg428 5MHRC-SIRS S009-3 Accounting - General - Level 3 Management 1,401RADFORD 3103 Accounting Mgmt 3 148TW-MM-GEN AFB-M2 Accounting - Manager (M2) 6,696TW-MM-ENGY AFB-M2 Accounting - Manager (M2) 753

Mgr, Bus Ops Anlys429 19MHRC-SIRS S212-3 Business Process Analysis - Level 3 Management 569RADFORD 1683 Business Process Mgmt 3 62TW-MM-GEN AEM070-M2 Business Operations Analysis - Manager (M2) 820TW-MM-ENGY AEM070-M2 Business Operations Analysis - Manager (M2) 249

55Aon

57

Page 85: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Manager/SupervisorMgr, Contract Admin430 4

MHRC-SIRS S027-3 Contracts Administration - Level 3 Management 776TW-MM-GEN ALS020-M2 Contract Administration - Manager (M2) 707TW-MM-ENGY ALS020-M2 Contract Administration - Manager (M2) 87

Mgr, Elect Trans Ops431 7TW-MM-ENGY ETO-M2 Electric Transmission Operations - Manager

(Supervisory/Management)198

Mgr, Eng432 51MHRC-SIRS S465-3 Engineering Design - Level 3 Management 533RADFORD 2373 Engineering (Generic) Mgmt 3 213TW-MM-GEN AZE-M2 Engineering - Manager (M2) 8,912TW-MM-ENGY AZE-M2 Engineering - Manager (M2) 3,649

Mgr, Engy Del / Distrib433 27TW-MM-ENGY EDD-M2 Energy Delivery/Distribution - Manager (Supervisory/Management) 1,860

Mgr, Engy Effcncy434 14TW-MM-ENGY EDE-M2 Energy Efficiency/Conservation - Manager

(Supervisory/Management)108

Mgr, Health & Sfty435 7MHRC-SIRS S152-3 Occupational Safety and Health - Level 3 Management 261RADFORD 3383 Environmental Health & Safety Mgmt 3 32TW-MM-GEN AHS030-M2 Health and Safety - Manager (M2) 353TW-MM-ENGY AHS030-M2 Health and Safety - Manager (M2) 115

Mgr, Hum Resources436 10MHRC-SIRS S176-3 Human Resources Business Partner - Level 3 Management 752RADFORD 3203 Human Resources Mgmt 3 54TW-MM-GEN AHR-M2 Human Resources - Manager (M2) 6,946TW-MM-ENGY AHR-M2 Human Resources - Manager (M2) 658

Mgr, IT Dev437 4TW-MM-GEN AID-M2 IT Development - Manager (M2) 11,592TW-MM-ENGY AID-M2 IT Development - Manager (M2) 902

Mgr, IT Ops438 7RADFORD R03403 Information Technology - All Mgmt Roll-Up 3 541TW-MM-GEN AIT-M2 IT Administration - Manager (M2) 5,977TW-MM-ENGY AIT-M2 IT Administration - Manager (M2) 598

Mgr, Modeling, Fcstg & Econ Anlys439 5MHRC-SIRS S205-3 Data Science and Modeling - Level 3 Management 36MHRC-SIRS S230-3 Business Intelligence Analysis - Level 3 Management 118RADFORD 2983 Data Science Mgmt 3 164TW-MM-GEN AEM-M2 Data Science/Analytics and Business Intelligence - Manager (M2) 1,548TW-MM-ENGY AEM-M2 Data Science/Analytics and Business Intelligence - Manager (M2) 414

Mgr, Op Mid440 16TW-MM-ENGY EDD-M2 Energy Delivery/Distribution - Manager (Supervisory/Management) 1,860

Mgr, Project Mgmt441 15MHRC-SIRS S623-3 Project Management - Level 3 Management 2,462RADFORD 3633 Project/Program (Admin) Mgmt 3 179TW-MM-GEN APM-M2 Project/Program Management - Manager (M2) 10,936TW-MM-ENGY APM-M2 Project/Program Management - Manager (M2) 1,404

56Aon

58

Page 86: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Manager/SupervisorMgr, Q A / Process Imprvmt442 4

TW-MM-GEN AQY-M2 Quality Assurance Methods - Manager (M2) 3,516TW-MM-ENGY AQY-M2 Quality Assurance Methods - Manager (M2) 427

Mgr, Real Estate & Fclties443 8MHRC-SIRS S305-3 Real Estate Management - Level 3 Management 128RADFORD 3313 Real Estate Mgmt 3 12TW-MM-GEN ARE-M2 Real Estate and Facilities - Manager (M2) 2,266TW-MM-ENGY ARE-M2 Real Estate and Facilities - Manager (M2) 293

Mgr, Sfty & Training444 6TW-MM-GEN AHS050-M2 Safety - Manager (M2) 396TW-MM-ENGY AHS050-M2 Safety - Manager (M2) 109TW-MM-ENGY ETT-M2 Electric System/Grid and Bulk Power Training - Manager

(Supervisory/Management)25

Mgr, Tech Spec445 24RADFORD 2793 Technical Support Mgmt 3 43TW-MM-GEN AZT-M2 Technical Specialty/Skilled Trade - Manager (M2) 3,540TW-MM-ENGY AZT-M2 Technical Specialty/Skilled Trade - Manager (M2) 368

Mgr, Trnsprtn Svcs446 7TW-MM-GEN AAT-M2 Transportation Services and Administration - Manager (M2) 1,812TW-MM-ENGY AAT-M2 Transportation Services and Administration - Manager (M2) 145

Mgr, Vegetation Mgmt & Forestry447 4TW-MM-GEN EVM-M2 Vegetation Management and Forestry - Manager

(Supervisory/Management)No Data

TW-MM-ENGY EVM-M2 Vegetation Management and Forestry - Manager (Supervisory/Management)

82

Sr Mgr448 1MHRC-SIRS S903-4 Government Affairs - Level 4 Management 157RADFORD 2934 Government Relations Mgmt 4 21TW-MM-GEN ACA070-M3 Government Relations - Senior Manager (M3) 164TW-MM-ENGY ACA070-M3 Government Relations - Senior Manager (M3) 62

Sr Mgr449 2TW-MM-GEN AFT090-M3 Rates - Senior Manager (M3) No DataTW-MM-ENGY AFT090-M3 Rates - Senior Manager (M3) 48

Sr Mgr450 1RADFORD 3264 Employee Relations/Shared Services Mgmt 4 11TW-MM-GEN AHR160-M3 HR Service Center - Senior Manager (M3) 87TW-MM-ENGY AHR160-M3 HR Service Center - Senior Manager (M3) No Data

Sr Mgr451 1MHRC-SIRS S213-4 Computer Systems Security - Level 4 Management 269RADFORD 3584 Information Security Mgmt 4 37TW-MM-GEN AIT070-M3 IS and Cyber Security - Senior Manager (M3) 401TW-MM-ENGY AIT070-M3 IS and Cyber Security - Senior Manager (M3) 53

Sr Mgr452 1RADFORD 3434 IT Support Mgmt 4 235TW-MM-GEN AIT020-M3 IT Help Desk Support - Senior Manager (M3) 154TW-MM-ENGY AIT020-M3 IT Help Desk Support - Senior Manager (M3) No Data

57Aon

59

Page 87: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Manager/SupervisorSr Mgr453 1

TW-MM-GEN ALS-M3 Legal Support - Senior Manager (M3) 529TW-MM-ENGY ALS-M3 Legal Support - Senior Manager (M3) 41

Sr Mgr454 3MHRC-SIRS S132-4 Marketing - Multiple Functions - Level 4 Management 423RADFORD 2504 Marketing Mgmt 4 295TW-MM-GEN AMK-M3 Marketing - Senior Manager (M3) 7,152TW-MM-ENGY AMK-M3 Marketing - Senior Manager (M3) 93

Sr Mgr455 1MHRC-SIRS S305-4 Real Estate Management - Level 4 Management 110RADFORD 3314 Real Estate Mgmt 4 21TW-MM-GEN ARE-M3 Real Estate and Facilities - Senior Manager (M3) 1,033TW-MM-ENGY ARE-M3 Real Estate and Facilities - Senior Manager (M3) 99

Sr Mgr456 1TW-MM-GEN AFY-M3 Risk Management - Senior Manager (M3) 174TW-MM-ENGY AFY-M3 Risk Management - Senior Manager (M3) 31

Sr Mgr457 3MHRC-SIRS S287-4 Logistics Management - Level 4 Management 470RADFORD 1414 Logistics Mgmt 4 27TW-MM-GEN ASC030-M3 Logistics - Senior Manager (M3) 918TW-MM-ENGY ASC030-M3 Logistics - Senior Manager (M3) No Data

Sr Mgr458 1RADFORD 3344 Security Mgmt 4 48TW-MM-GEN AAY-M3 Security - Senior Manager (M3) 360TW-MM-ENGY AAY-M3 Security - Senior Manager (M3) 90

Sr Mgr459 1TW-MM-GEN AAT050-M3 Aviation - Pilots - Senior Manager (M3) 30TW-MM-ENGY AAT050-M3 Aviation - Pilots - Senior Manager (M3) No Data

Sr Mgr460 2TW-MM-GEN AAT-M3 Transportation Services and Administration - Senior Manager (M3) 166TW-MM-ENGY AAT-M3 Transportation Services and Administration - Senior Manager (M3) 27

Sr Mgr461 3MHRC-SIRS S972-4 Worker's Compensation Claims Analysis - Level 4 Management 7TW-MM-GEN AHS070-M3 Workers' Compensation Case Management - Senior Manager (M3) 5TW-MM-ENGY AHS070-M3 Workers' Compensation Case Management - Senior Manager (M3) No Data

Sr Mgr, Account Mgmt462 8TW-MM-GEN CAM-M3 Account/Relationship Management - Senior Manager (M3) 2,177TW-MM-ENGY CAM-M3 Account/Relationship Management - Senior Manager (M3) 54

Sr Mgr, Acctg463 6MHRC-SIRS S009-4 Accounting - General - Level 4 Management 1,077RADFORD 3104 Accounting Mgmt 4 82TW-MM-GEN AFB-M3 Accounting - Senior Manager (M3) 3,106TW-MM-ENGY AFB-M3 Accounting - Senior Manager (M3) 284

58Aon

60

Page 88: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Manager/SupervisorSr Mgr, Audit464 7

MHRC-SIRS S001-4 Auditing - Level 4 Management 254RADFORD 3054 Internal Audit Mgmt 4 31TW-MM-GEN AFU010-M3 General Audit - Senior Manager (M3) 269TW-MM-ENGY AFU010-M3 General Audit - Senior Manager (M3) 17

Sr Mgr, Bus Cont465 5MHRC-SIRS S454-4 Business Continuity - Level 4 Management 31RADFORD 2914 Business Continuity Mgmt 4 11TW-MM-GEN AAY010-M3 Business Continuation - Senior Manager (M3) 8TW-MM-ENGY AAY010-M3 Business Continuation - Senior Manager (M3) No Data

Sr Mgr, Bus Ops Anlys466 18MHRC-SIRS S212-4 Business Process Analysis - Level 4 Management 815RADFORD 1684 Business Process Mgmt 4 76TW-MM-GEN AEM070-M3 Business Operations Analysis - Senior Manager (M3) 565TW-MM-ENGY AEM070-M3 Business Operations Analysis - Senior Manager (M3) 56

Sr Mgr, Communications467 4MHRC-SIRS S134-4 Communications - External - Level 4 Management 239RADFORD 2524 Marketing Communications Mgmt 4 63TW-MM-GEN ACA-M3 Corporate Affairs/Communications - Senior Manager (M3) 2,184TW-MM-ENGY ACA-M3 Corporate Affairs/Communications - Senior Manager (M3) 433

Sr Mgr, Eng468 34MHRC-SIRS S465-4 Engineering Design - Level 4 Management 222RADFORD 2374 Engineering (Generic) Mgmt 4 176TW-MM-GEN AZE-M3 Engineering - Senior Manager (M3) 6,318TW-MM-ENGY AZE-M3 Engineering - Senior Manager (M3) 1,147

Sr Mgr, Engy Del / Distrib469 24TW-MM-ENGY EDD-M3 Energy Delivery/Distribution - Senior Manager

(Supervisory/Management)405

Sr Mgr, Engy Effcncy470 11TW-MM-ENGY EDE-M3 Energy Efficiency/Conservation - Senior Manager

(Supervisory/Management)29

Sr Mgr, Engy Mktg & Trdg471 4TW-MM-ENGY EML-M3 Energy Marketing and Trading - Senior Manager

(Supervisory/Management)5

Sr Mgr, Engy Trdg Ops472 6TW-EMT EMU-M3 Energy Trading Operations/Support - Senior Manager (M3) 65

Sr Mgr, Envir473 15MHRC-SIRS S906-4 Regulatory Compliance - Environmental - Level 4 Management 62TW-MM-GEN AHS010-M3 Environmental Science - Senior Manager (M3) 56TW-MM-ENGY AHS010-M3 Environmental Science - Senior Manager (M3) 50

Sr Mgr, Finance474 11MHRC-SIRS S007-4 Financial Analysis - Level 4 Management 2,374TW-MM-GEN AFT-M3 Financial Analysis and Tax - Senior Manager (M3) 5,377TW-MM-ENGY AFT-M3 Financial Analysis and Tax - Senior Manager (M3) 371

59Aon

61

Page 89: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Manager/SupervisorSr Mgr, Health & Sfty475 4

MHRC-SIRS S152-4 Occupational Safety and Health - Level 4 Management 124RADFORD 3384 Environmental Health & Safety Mgmt 4 23TW-MM-GEN AHS030-M3 Health and Safety - Senior Manager (M3) 108TW-MM-ENGY AHS030-M3 Health and Safety - Senior Manager (M3) 28

Sr Mgr, Hum Resources476 15MHRC-SIRS S176-4 Human Resources Business Partner - Level 4 Management 946RADFORD 3204 Human Resources Mgmt 4 65TW-MM-GEN AHR-M3 Human Resources - Senior Manager (M3) 4,742TW-MM-ENGY AHR-M3 Human Resources - Senior Manager (M3) 273

Sr Mgr, IT Dev477 9TW-MM-GEN AID-M3 IT Development - Senior Manager (M3) 9,425TW-MM-ENGY AID-M3 IT Development - Senior Manager (M3) 289

Sr Mgr, IT Ops478 9RADFORD R03404 Information Technology - All Mgmt Roll-Up 4 675TW-MM-GEN AIT-M3 IT Administration - Senior Manager (M3) 3,462TW-MM-ENGY AIT-M3 IT Administration - Senior Manager (M3) 149

Sr Mgr, Modeling, Fcstg & Econ Anlys479 10MHRC-SIRS S205-4 Data Science and Modeling - Level 4 Management 73MHRC-SIRS S230-4 Business Intelligence Analysis - Level 4 Management 128RADFORD 2984 Data Science Mgmt 4 63TW-MM-GEN AEM-M3 Data Science/Analytics and Business Intelligence - Senior Manager

(M3)1,398

TW-MM-ENGY AEM-M3 Data Science/Analytics and Business Intelligence - Senior Manager (M3)

124

Sr Mgr, Project Mgmt480 49MHRC-SIRS S623-4 Project Management - Level 4 Management 2,189RADFORD 3634 Project/Program (Admin) Mgmt 4 177TW-MM-GEN APM-M3 Project/Program Management - Senior Manager (M3) 10,290TW-MM-ENGY APM-M3 Project/Program Management - Senior Manager (M3) 613

Sr Mgr, Q A / Process Imprvmt481 5TW-MM-GEN AQY-M3 Quality Assurance Methods - Senior Manager (M3) 2,183TW-MM-ENGY AQY-M3 Quality Assurance Methods - Senior Manager (M3) 104

Sr Mgr, Reg Affairs & Compl482 14MHRC-SIRS S905-4 Regulatory Compliance - Level 4 Management 467RADFORD 15024 Regulatory Affairs Mgmt 4 192TW-MM-GEN ACA050-M3 Regulatory Affairs and Compliance - Senior Manager (M3) 323TW-MM-GEN ACA070-M3 Government Relations - Senior Manager (M3) 164TW-MM-ENGY ACA050-M3 Regulatory Affairs and Compliance - Senior Manager (M3) 183TW-MM-ENGY ACA070-M3 Government Relations - Senior Manager (M3) 62TW-MM-ENGY ACA540-M3 Regulatory Compliance - Technical Rules and Standards - Senior

Manager (M3)7

Sr Mgr, Strategic Plng / Corp Dev483 8MHRC-SIRS S355-4 Strategic Planning - Level 4 Management 265RADFORD 2964 Strategic Planning/Analytics Mgmt 4 91TW-MM-GEN ACD-M3 Strategic Planning/Corporate Development - Senior Manager (M3) 1,269TW-MM-ENGY ACD-M3 Strategic Planning/Corporate Development - Senior Manager (M3) 96

60Aon

62

Page 90: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Manager/SupervisorSr Mgr, Supply Chain484 10

MHRC-SIRS S720-4 Supply Chain Planning - Level 4 Management 559RADFORD 1464 Supply Chain/Procurement Mgmt 4 102TW-MM-GEN ASC000-M3 Supply Chain and Logistics Generalist/Multidiscipline - Senior

Manager (M3)2,336

TW-MM-ENGY ASC000-M3 Supply Chain and Logistics Generalist/Multidiscipline - Senior Manager (M3)

74

Sr Mgr, Tech Spec485 12RADFORD 2794 Technical Support Mgmt 4 43TW-MM-GEN AZT-M3 Technical Specialty/Skilled Trade - Senior Manager (M3) 670TW-MM-ENGY AZT-M3 Technical Specialty/Skilled Trade - Senior Manager (M3) 74

Director486 1TW-EXE-ENGY AFB001-EX Assistant Financial Controller 27TW-EXE-GEN AFB001-EX Assistant Financial Controller 17

Director487 1HILDE-LAW DGC Deputy General Counsel 228TW-EXE-ENGY ALG002-EX Deputy General Counsel 32TW-EXE-GEN ALG002-EX Deputy General Counsel 10

Director488 2HILDE-LAW DGC Deputy General Counsel 228TW-EXE-ENGY ALG002-EX Deputy General Counsel 32TW-EXE-GEN ALG002-EX Deputy General Counsel 10

Director489 1TW-EXE-ENGY AAB003-EX Division Head 34

Director490 1TW-EXE-ENGY AIC020-EX Information Technology Function Head 20TW-EXE-GEN AIC020-EX Information Technology Function Head 10

Director491 1TW-EXE-ENGY CAM010-EX National/Global Accounts Executive 288

Director492 1TW-EXE-ENGY AFT080-EX Top Insurance Executive 12TW-EXE-GEN AFT080-EX Top Insurance Executive 5

Director493 1TW-EXE-ENGY ACA001-EX Communications Executive (Second Level) 15TW-EXE-GEN ACA001-EX Communications Executive (Second Level) 5

Director494 1TW-EXE-ENGY ARE020-EX Top Facilities Management Executive 28TW-EXE-GEN ARE020-EX Top Facilities Management Executive No Data

Director495 1TW-EXE-ENGY AMS020-EX Top Customer Contact/Call Center Executive 6

Director496 1TW-EXE-ENGY AIC010-EX Top Information and Cyber Security Executive 24TW-EXE-GEN AIC010-EX Top Information and Cyber Security Executive 5

Director497 1TW-EXE-GEN ETS010-EX Top Electric System/Grid Operations Executive (ISO/RTO) 6

61Aon

63

Page 91: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Manager/SupervisorDirector498 1

TW-EXE-GEN ETS010-EX Top Electric System/Grid Operations Executive (ISO/RTO) 6

Director499 1TW-EXE-ENGY AIC020-EX Information Technology Function Head 20TW-EXE-GEN AIC020-EX Information Technology Function Head 10

Director500 1TW-EXE-ENGY AFY000-EX Top Risk Management Executive 5TW-EXE-GEN AFY000-EX Top Risk Management Executive 5

Director501 1TW-EXE-ENGY ACA001-EX Communications Executive (Second Level) 15TW-EXE-GEN ACA001-EX Communications Executive (Second Level) 5

Director502 1TW-EXE-ENGY ASC002-EX Supply Chain Executive (Second Level) 39TW-EXE-GEN ASC002-EX Supply Chain Executive (Second Level) 9

Director503 1TW-EXE-ENGY AFT051-EX Tax Executive (Second Level) 42TW-EXE-GEN AFT051-EX Tax Executive (Second Level) 11

Director504 1TW-EXE-ENGY AID010-EX Top Applications Development Executive 6TW-EXE-GEN AID010-EX Top Applications Development Executive 5

Director505 1TW-EXE-ENGY AHR003-EX Human Resources Executive (Second Level) 42TW-EXE-GEN AHR003-EX Human Resources Executive (Second Level) No Data

Director506 1TW-EXE-ENGY AHR010-EX Top Compensation and Benefits Executive 12TW-EXE-GEN AHR010-EX Top Compensation and Benefits Executive 19

Director507 1TW-EXE-ENGY AGA000-EX Chief of Staff to CEO/President 36TW-EXE-GEN AGA000-EX Chief of Staff to CEO/President 5

Director508 1TW-EXE-GEN EGF000-EX Top Fossil Power Generation Operations Executive 12

Director509 1TW-EXE-ENGY AFT036-EX Top Investment Portfolio Management Executive 5

Director510 1TW-EXE-GEN AZC500-EX Top Power Construction Executive 9

Director511 1TW-EXE-ENGY AFB001-EX Assistant Financial Controller 9TW-EXE-GEN AFB001-EX Assistant Financial Controller 12

Director & Managing Attorney512 12EMPS-WORKS ATTY-M1 Managing Attorney 151HILDE-LAW SCH Section Head 632

Managing Director513 1TW-EXE-ENGY AFT051-EX Tax Executive (Second Level) 42TW-EXE-GEN AFT051-EX Tax Executive (Second Level) 5

62Aon

64

Page 92: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Manager/SupervisorManaging Director514 1

TW-EXE-GEN ETO003-EX Top Electric System Planning Executive 10

Managing Director515 1TW-EXE-GEN AFT090-EX Top Rates Executive 12

Managing Director516 1TW-EXE-ENGY AIC035-EX Top Technology Platforms Executive 25TW-EXE-GEN AIC035-EX Top Technology Platforms Executive No Data

Prin Mgr517 3MHRC-SIRS S134-5 Communications - External - Level 5 Management 228RADFORD 2525 Marketing Communications Mgmt 5 870TW-MM-GEN ACA-M4 Corporate Affairs/Communications - Group Manager (M4) 1,497TW-MM-ENGY ACA-M4 Corporate Affairs/Communications - Group Manager (M4) 312

Prin Mgr518 1TW-EMT EMU-M4 Energy Trading Operations/Support - Group Manager (M4) 13

Prin Mgr519 1TW-MM-GEN ALS-M4 Legal Support - Group Manager (M4) 237TW-MM-ENGY ALS-M4 Legal Support - Group Manager (M4) 18

Prin Mgr520 3MHRC-SIRS S132-5 Marketing - Multiple Functions - Level 5 Management 281RADFORD 2505 Marketing Mgmt 5 2,977TW-MM-GEN AMK-M4 Marketing - Group Manager (M4) 4,173TW-MM-ENGY AMK-M4 Marketing - Group Manager (M4) 59

Prin Mgr521 1TW-MM-GEN AQY-M4 Quality Assurance Methods - Group Manager (M4) 956TW-MM-ENGY AQY-M4 Quality Assurance Methods - Group Manager (M4) 42

Prin Mgr522 2MHRC-SIRS S305-5 Real Estate Management - Level 5 Management 54RADFORD 3315 Real Estate Mgmt 5 162TW-MM-GEN ARE-M4 Real Estate and Facilities - Group Manager (M4) 307TW-MM-ENGY ARE-M4 Real Estate and Facilities - Group Manager (M4) 19

Prin Mgr523 2TW-MM-GEN AFY-M4 Risk Management - Group Manager (M4) 127TW-MM-ENGY AFY-M4 Risk Management - Group Manager (M4) 30

Prin Mgr524 3MHRC-SIRS S355-5 Strategic Planning - Level 5 Management 296RADFORD 2965 Strategic Planning/Analytics Mgmt 5 1,058TW-MM-GEN ACD-M4 Strategic Planning/Corporate Development - Group Manager (M4) 981TW-MM-ENGY ACD-M4 Strategic Planning/Corporate Development - Group Manager (M4) 88

Prin Mgr525 1MHRC-SIRS S287-5 Logistics Management - Level 5 Management 142RADFORD 1415 Logistics Mgmt 5 264TW-MM-GEN ASC030-M4 Logistics - Group Manager (M4) 189TW-MM-ENGY ASC030-M4 Logistics - Group Manager (M4) No Data

63Aon

65

Page 93: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Manager/SupervisorPrin Mgr526 1

RADFORD 3345 Security Mgmt 5 265TW-MM-GEN AAY-M4 Security - Group Manager (M4) 165TW-MM-ENGY AAY-M4 Security - Group Manager (M4) 38

Prin Mgr527 3MHRC-SIRS S275-5 Accounting - Tax Compliance - Level 5 Management No DataRADFORD 3085 Tax Mgmt 5 846TW-MM-GEN AFT050-M4 Tax Reporting and Compliance - Group Manager (M4) 454TW-MM-ENGY AFT050-M4 Tax Reporting and Compliance - Group Manager (M4) 43

Prin Mgr528 2TW-MM-GEN AAT-M4 Transportation Services and Administration - Group Manager (M4) 62TW-MM-ENGY AAT-M4 Transportation Services and Administration - Group Manager (M4) 5

Prin Mgr529 2RADFORD 2795 Technical Support Mgmt 5 865TW-MM-GEN AZT-M4 Technical Specialty/Skilled Trade - Group Manager (M4) 223TW-MM-ENGY AZT-M4 Technical Specialty/Skilled Trade - Group Manager (M4) 12

Prin Mgr, Account Mgmt530 4TW-MM-GEN CAM-M4 Account/Relationship Management - Group Manager (M4) 1,079TW-MM-ENGY CAM-M4 Account/Relationship Management - Group Manager (M4) 18

Prin Mgr, Acctg531 4MHRC-SIRS S009-5 Accounting - General - Level 5 Management 392RADFORD 3105 Accounting Mgmt 5 1,079TW-MM-GEN AFB-M4 Accounting - Group Manager (M4) 1,327TW-MM-ENGY AFB-M4 Accounting - Group Manager (M4) 130

Prin Mgr, Bus Ops Anlys532 7MHRC-SIRS S212-5 Business Process Analysis - Level 5 Management 342RADFORD 1685 Business Process Mgmt 5 785TW-MM-GEN AEM070-M4 Business Operations Analysis - Group Manager (M4) 306TW-MM-ENGY AEM070-M4 Business Operations Analysis - Group Manager (M4) 33

Prin Mgr, Elect Trans Ops533 4TW-MM-ENGY ETO-M4 Electric Transmission Operations - Group Manager

(Supervisory/Management)29

Prin Mgr, Eng534 12MHRC-SIRS S465-5 Engineering Design - Level 5 Management 115RADFORD 2375 Engineering (Generic) Mgmt 5 1,019TW-MM-GEN AZE-M4 Engineering - Group Manager (M4) 2,492TW-MM-ENGY AZE-M4 Engineering - Group Manager (M4) 410

Prin Mgr, Engy Del / Distrib535 17TW-MM-ENGY EDD-M4 Energy Delivery/Distribution - Group Manager

(Supervisory/Management)225

Prin Mgr, Engy Effcncy536 4TW-MM-ENGY EDE-M4 Energy Efficiency/Conservation - Group Manager

(Supervisory/Management)5

Prin Mgr, Engy Mktg & Trdg537 6TW-EMT EML-M4 Energy Marketing and Trading - Group Manager (M4) 16

64Aon

66

Page 94: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Manager/SupervisorPrin Mgr, Finance538 10

MHRC-SIRS S007-5 Financial Analysis - Level 5 Management 1,285TW-MM-GEN AFT-M4 Financial Analysis and Tax - Group Manager (M4) 2,994TW-MM-ENGY AFT-M4 Financial Analysis and Tax - Group Manager (M4) 220

Prin Mgr, Govt Relations539 5MHRC-SIRS S903-5 Government Affairs - Level 5 Management 256RADFORD 2935 Government Relations Mgmt 5 307TW-MM-GEN ACA070-M4 Government Relations - Group Manager (M4) 198TW-MM-ENGY ACA070-M4 Government Relations - Group Manager (M4) 59

Prin Mgr, Health & Sfty540 5MHRC-SIRS S152-5 Occupational Safety and Health - Level 5 Management 66RADFORD 3385 Environmental Health & Safety Mgmt 5 212TW-MM-GEN AHS030-M4 Health and Safety - Group Manager (M4) 57TW-MM-ENGY AHS030-M4 Health and Safety - Group Manager (M4) 18

Prin Mgr, Hum Resources541 13MHRC-SIRS S176-5 Human Resources Business Partner - Level 5 Management 783RADFORD 3205 Human Resources Mgmt 5 1,226TW-MM-GEN AHR-M4 Human Resources - Group Manager (M4) 2,568TW-MM-ENGY AHR-M4 Human Resources - Group Manager (M4) 148

Prin Mgr, IT Dev542 5TW-MM-GEN AID-M4 IT Development - Group Manager (M4) 3,140TW-MM-ENGY AID-M4 IT Development - Group Manager (M4) 127

Prin Mgr, IT Ops543 5RADFORD R03405 Information Technology - All Mgmt Roll-Up 5 8,154TW-MM-GEN AIT-M4 IT Administration - Group Manager (M4) 1,294TW-MM-ENGY AIT-M4 IT Administration - Group Manager (M4) 85

Prin Mgr, Modeling, Fcstg & Econ Anlys544 7MHRC-SIRS S205-5 Data Science and Modeling - Level 5 Management 22MHRC-SIRS S230-5 Business Intelligence Analysis - Level 5 Management 102RADFORD 2985 Data Science Mgmt 5 63TW-MM-GEN AEM-M4 Data Science/Analytics and Business Intelligence - Group Manager

(M4)562

TW-MM-ENGY AEM-M4 Data Science/Analytics and Business Intelligence - Group Manager (M4)

69

Prin Mgr, Project Mgmt545 23MHRC-SIRS S623-5 Project Management - Level 5 Management 817RADFORD 3635 Project/Program (Admin) Mgmt 5 1,759TW-MM-GEN APM-M4 Project/Program Management - Group Manager (M4) 3,179TW-MM-ENGY APM-M4 Project/Program Management - Group Manager (M4) 296

Prin Mgr, Reg Affairs & Compl546 18MHRC-SIRS S905-5 Regulatory Compliance - Level 5 Management 397RADFORD 15025 Regulatory Affairs Mgmt 5 193TW-MM-GEN ACA050-M4 Regulatory Affairs and Compliance - Group Manager (M4) 274TW-MM-GEN ACA070-M4 Government Relations - Group Manager (M4) 198TW-MM-ENGY ACA050-M4 Regulatory Affairs and Compliance - Group Manager (M4) 117TW-MM-ENGY ACA070-M4 Government Relations - Group Manager (M4) 59TW-MM-ENGY ACA540-M4 Regulatory Compliance - Technical Rules and Standards - Group

Manager (M4)No Data

65Aon

67

Page 95: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

Manager/SupervisorPrin Mgr, Supply Chain547 6

MHRC-SIRS S720-5 Supply Chain Planning - Level 5 Management 370RADFORD 1465 Supply Chain/Procurement Mgmt 5 1,400TW-MM-GEN ASC000-M4 Supply Chain and Logistics Generalist/Multidiscipline - Group

Manager (M4)766

TW-MM-ENGY ASC000-M4 Supply Chain and Logistics Generalist/Multidiscipline - Group Manager (M4)

38

66Aon

68

Page 96: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

ExecutiveVP548 1

SMUD 6 Director, Treasury & Treasurer 1TW-EXE-ENGY AFT030-EX Treasurer 8TW-EXE-GEN AFT030-EX - Total

SampleTreasurer 12

VP549 1SMUD 7 Director, Marketing & Corporate Communications, Director, Retail

Product Delivery & Sales, Director Advanced Energy Solutions3

TW-EXE-ENGY AMK000-EX Top Marketing Executive 26TW-EXE-GEN AMK000-EX Top Marketing Executive 8

VP550 1SMUD 8 Director, Grid Planning, Director Distribution Operations

Maintenance2

TW-EXE-GEN EDD010-EX - Noncorporate

Top Power Distribution Systems Executive 20

VP551 1TW-EXE-ENGY ACA090-EX - Corporate Top Investor Relations Executive 11TW-EXE-GEN ACA090-EX - Corporate Top Investor Relations Executive 6

VP552 1SMUD 9 Deputy General Counsel - Government Affairs 1TW-EXE-GEN ACA055-EX -

NoncorporateTop State/Region/Province/Local Regulatory Affairs Executive 6

VP553 1TW-EXE-ENGY AFT050-EX - Corporate Top Tax Executive 12TW-EXE-GEN AFT050-EX - Corporate Top Tax Executive 6

VP554 1SMUD 10 Director, Substations, Telecomm & Metering Assets, Director, Grid

Planning2

TW-EXE-GEN ETO000-EX - Noncorporate

Top Transmission Systems Executive 5

VP555 1SMUD 11 Director, IT Infrastructure & Operations, Director, IT Projects and

Applications2

TW-EXE-ENGY AIC002-EX Top Information Technology Executive 12TW-EXE-GEN AIC002-EX Top Information Technology Executive 5

SVP & CFO, SCE556 1SMUD 1 Chief Financial Officer 1TW-EXE-ENGY AFA000-EX -

NoncorporateCFO/Top Financial Officer 8

TW-EXE-GEN AFA000-EX - Total Sample

CFO/Top Financial Officer 17

SVP & General Counsel557 1SMUD 2 Chief Legal Officer 1TW-EXE-ENGY ALG000-EX Top Legal Executive 43TW-EXE-GEN ALG000-EX Top Legal Executive 15

SVP558 1SMUD 3 Chief Customer Officer 1TW-EXE-ENGY ACA005-EX Top Public Relations and Internal Communications Executive 19TW-EXE-GEN ACA005-EX - Total

SampleTop Public Relations and Internal Communications Executive 8

67Aon

69

Page 97: :RUNSDSHUV - sce.comFILE/WPSCE06V0… · strategy to increase cash compensation, which was below market norms in the 2018 Study, and reduce . SCE’s average base pay increased overall

Workpaper – Southern California Edison / 2021 General Rate Case

Exhibit No. SCE-06 Vol.03 Pt 02

Witnesses: M. Bennett

Source Job Code Job TitleStudy # and

# SCEEEs

# of SurveyIncumbents

ExecutiveSVP Transmission & Distribution559 1

SMUD 4 Chief Grid Strategy & Operations Officer 1TW-EXE-GEN ETN000-EX Top Transmission and Distribution Systems Executive (Combined

Function)10

SVP560 1SMUD 5 Director, Human Resources, Diversity & Inclusion 1TW-EXE-ENGY AHR000-EX - Corporate Top Human Resources Executive 15TW-EXE-GEN AHR000-EX - Corporate Top Human Resources Executive 9

Chief Executive Officer SCE561 1TW-EXE-GEN AAB500-EX -

NoncorporateTop Regulated Energy Delivery Business Executive 6

EVP562 1TW-EXE-ENGY ALG000-EX - Corporate Top Legal Executive 16TW-EXE-GEN ALG000-EX - Corporate Top Legal Executive 11

EVP563 1TW-EXE-ENGY AFA000-EX - Corporate CFO/Top Financial Officer 18TW-EXE-GEN AFA000-EX - Corporate CFO/Top Financial Officer 11

President and CEO, EIX564 1TW-EXE-ENGY AAA000-EX - Corporate Chief Executive Officer 18TW-EXE-GEN AAA000-EX - Corporate Chief Executive Officer 11

68Aon

70