investment recovery performance benchmarking...2017/07/07 · of companies that said non-hazardous...

CAPS Research2017 Investment Recovery Performance Benchmarking Report

Release Date: July 7, 2017

© 2017, Arizona Board of Regents on behalf of Arizona State University.1

A.

For the entire company:Less than $500 million 3% $500 million - $1 billion 3%$1 billiion - $5 billion 20% $5 billion - $10 billion 25%$10 billion - $25 billion 30% $25 billion - $50 billion 3%$50 billion - $100 billion 12% Greater than $100 billion 3%

For the business units to which IR services were provided:Less than $500 million 15% $500 million - $1 billion 5%$1 billiion - $5 billion 22% $5 billion - $10 billion 20%$10 billion - $25 billion 23% $25 billion - $50 billion 7%$50 billion - $100 billion 5% Greater than $100 billion 3%

B.

Entire company: 84%

Multiple locations or business units: 13%

A single location or business unit: 3%

Percent of participants that reported the following revenue ranges

Percent of companies reporting at the following level:

Entire company: Multiple locations or business units:

A single location or business unit:




C. Percent of companies that use the following organizational structure to perform the Investment Recovery function:

IR Program ManagementCentralized 83%Decentralized 17%

IR Operations/ServicesCentralized 61%Decentralized 39%

D. Geographic areas to which Investment Recovery services are provided:

North America (NAFTA) 74%Global 30%

0%10%20%30%40%50%60%70%80%90%

IR Program Management IR Operations Services

Global

North America (NAFTA)

0% 10% 20% 30% 40% 50% 60% 70% 80%




E. Investment Recovery directly reports to:

CEO/President 0%Executive V.P. 3%Vice President 21%Director 23%Manager 44%Supervisor 5%Other 3%

Deputy Commissioner; Managing Director

F. Functional area Investment Recovery directly reports to:

Supply/Purchasing/Sourcing/ Materials Management 80%Finance/Controller 3%Maintenance 2%Operations 13%Environmental 0%Other 2%

Inventory Control Management

0% 10% 20% 30% 40% 50%

OtherSupervisor

ManagerDirector

Vice PresidentExecutive V.P.CEO/President

0% 10% 20% 30% 40% 50% 60% 70% 80%

Other

Environmental

Operations

Maintenance

Finance/Controller

Supply/Purchasing/Sourcing/Materials…




G.

Aerospace & Defense 7%Automotive & Transport 2%Chemical 7%Consumer Products 2%Electronics 3%Food 2%Government 8%Industrial Manufacturing 2%Metals & Mining 3%Oil & Gas 15%Pharmaceuticals 2%Telecommunications 3%Utilities 39%Other 7%

Financial Services; Healthcare

H.

Type of Industry that best describes each company:

On average, the IR function serviced 675 company locations or facilities with a median of 60. When the largest data point is removed, the average is 118.

0.0% 5.0% 10.0% 15.0% 20.0% 25.0% 30.0% 35.0% 40.0%

OtherUtilities

TelecommunicationsPharmaceuticals

Oil & GasMetals & Mining

Industrial ManufacturingGovernment

FoodElectronics

Consumer ProductsChemical

Automotive & TransportAerospace & Defense




I. The most effective tools used for the disposition of assets: (A rating of 1 = least effective and a rating of 5 = most effective)

Tool Average RatingIncrease Decrease No Change

Auctions 4.1 29.5% 4.5% 65.9%eAuctions 4.0 38.6% 2.3% 59.1%3rd-Party Sellers or Brokers 4.0 38.3% 0.0% 61.7%Email 3.7 20.5% 6.8% 72.7%Intranet 3.6 26.1% 6.5% 67.4%Internet posting 3.5 31.8% 4.5% 63.6%Social media 2.7 25.6% 2.3% 72.1%Special Apps 2.3 14.3% 2.4% 83.3%Catalogs 2.2 9.3% 9.3% 81.4%Commercial Ads 2.2 7.1% 4.8% 88.1%Telemarketing 1.8 9.8% 0.0% 90.2%Flyers/Mailers 1.5 2.4% 7.1% 90.5%Fax 1.1 0.0% 9.8% 90.2%Other 3.0 0.0% 0.0% 100.0%

Expected Change in Use




J. Investment Recovery services provided:

Primary Service Provided

Service Occasionally Provided

Service Not Provided

Sales (material & equipment) 79.7% 13.6% 6.8%Recycling 68.3% 20.0% 11.7%Redeployment 51.7% 34.5% 13.8%Inventory reclamation 43.3% 38.3% 18.3%Non-hazardous waste stream management 33.9% 28.8% 37.3%

Used equipment searches 28.1% 33.3% 38.6%Donations 25.9% 43.1% 31.0%Dismantling/Demolition 24.6% 35.1% 40.4%Appraisals 22.4% 48.3% 29.3%Hazardous waste stream management 20.7% 31.0% 48.3%Other 21.2% 3.0% 75.8%

Of companies that said Hazardous waste stream management is a Primary Service Provided, 50% have employees dedicated exclusively to this activity.Of companies that said Non-hazardous waste stream management is a Primary Service Provided, 65% have employees dedicated exclusively to this activity.




# Benchmarks Mean Median Minimum MaximumNumber of

ParticipantsPrevious

Report Mean

Financial Information

1 Total cost benefit: $7,413,572 $4,395,966 $23,500 $32,982,000 48 $11,865,559

2 Total cost benefit dollars to operating expense dollars:This ratio should reflect XX:1 21 11 0 90 38 49

3 Total cost benefit dollars per transaction: $18,399 $8,289 $0 $160,000 36 $22,756

4 Total cost benefit provided by each investment recovery employee: $1,987,847 $1,125,000 $7,833 $11,383,982 47 $3,870,713

5 Total cost benefit provided by each exempt investment recovery employee: $3,471,934 $2,060,483 $7,833 $15,980,000 42 $5,856,106

6 Investment recovery third-party sales as a percent of total cost benefit: 25.7% 19.7% 0.0% 77.8% 34 23.9%

7 Net third-party sales as a percent of total cost benefit: 17.8% 8.8% 0.0% 66.7% 36 22.7%

8 Gross sales dollars as a percent of total cost benefit: 83.8% 98.2% 0.0% 100.0% 48 74.3%

Internal transfers/redeployments as a percent of total cost benefit: 11.9% 0.8% 0.0% 92.3% 48 20.4%

Other cost avoidance as a percent of total cost benefit: 4.4% 0.0% 0.0% 57.4% 48 5.3%

9 Operating expense per investment recovery employee including outsourcing expenses: $121,363 $102,500 $19,077 $302,500 37 $117,448

Operating expense per investment recovery employee excluding outsourcing expenses: $118,003 $106,250 $19,077 $250,000 36 $104,110






Report Mean

10Company IR employees operating expense for salaries and payroll-related expenses as a percent of total operating expense:

80.9% 94.2% 0.0% 100.0% 38 83.9%

Non-allocated expenses as a percent of total operating expense: 2.3% 0.0% 0.0% 36.7% 38 1.9%

IT (Infrastructure and desktop support) expenses as a percent of total operating expense: 0.7% 0.0% 0.0% 8.7% 38 2.8%

Business systems expenses as a percent of total operating expense: 2.1% 0.0% 0.0% 55.6% 38 0.3%

Allocated expenses as a percent of total operating expense: 2.0% 0.0% 0.0% 54.5% 38 1.6%

In-house IR contractors/consultants operating expense as a percent of total operating expense: 2.5% 0.0% 0.0% 39.2% 38 1.8%

Direct cost of outsourced IR services as a percent of total operating expense: 7.1% 0.0% 0.0% 100.0% 38 3.6%

Other costs as a percent of total operating expense: 2.4% 1.2% 0.0% 14.6% 38 4.1%

11 Operating expense per transaction: $1,811 $804 $4 $8,857 30 $1,415






Report Mean

Investment Recovery Processes and Best Practices

12 Percent of organizations that outsource some IR activities or services: 76.7% 60 75.0%

Percent of organizations that chose the following as one of the top five activities/services outsourced in 2016: 46

Auctions 65.2% 72.4%

Recycling/Scrap 63.0% 75.9%

Dismantling/Demolition 54.3% 44.8%

eAuction sales 34.8% 41.4%

Appraisals 34.8% 27.6%

Bid or negotiated sales 34.8% 27.6%

Environmental services 26.1% 24.1%

Equipment refurbishment 15.2% 17.2%

Surplus identification/characterization 13.0% 24.1%

Offsite surplus storage/management 10.9% 13.8%

Internal surplus redeployment 10.9% 6.9%

Used equipment searches 8.7% 10.3%

Internal staff augmentation 4.3% 13.8%

Other 8.7% 3.4%

13 Average number of transactions per IR employee: 1,108 141 6 30,004 35 321

Broker sales; Economic development; IT hardware equipment and IT salvage sales; Website creation






Report Mean

14 Internal transfers/redeployments as a percent of total transactions: 17.1% 3.3% 0.0% 100.0% 40 23.9%

Third-party sales transactions as a percent of total transactions: 82.9% 96.7% 0.0% 100.0% 40 76.1%

15 Percent of organizations that require the use of Investment Recovery for disposal of surplus assets: 61.0% 59 67.6%

Percent of organizations that encourage the use of Investment Recovery for disposal of surplus assets: 28.8% 59 24.3%

Percent of organizations that have no policy regarding the use of Investment Recovery: 10.2% 59 8.1%

16 Percent of IR groups active in efforts to support sustainability requirements (e.g., landfill avoidance) 77.2% 57 87.8%

Of those IR groups, percent that are active in the following areas: 44

Landfill avoidance/Recycling 93.2% 100.0%

Employee education 65.9% 52.9%

Seek new diversions of waste streams 61.4% 61.8%

Hazmat handling/processing 61.4% 44.1%

Cradle-to-grave waste stream management 47.7% 52.9%

Sustainable metrics as top company goals 47.7% 41.2%

Water conservation 29.5% 29.4%

Composting/biofuel 25.0% 23.5%

Other 2.3% 0.0%






Report Mean

17 On a scale of 1 - 5, average rating of the following statements (1 = Strongly Disagree, 5 = Strongly Agree):

Senior executives understand the value of Investment Recovery 3.7 60 3.7

Operations managers understand the value of Investment Recovery 3.8 60 3.9

18 Percent of organization's identified surplus assets managed: 73.0% 92.5% 0.0% 100.0% 58 76.8%

19Average number of days surplus assets are typically held or considered for redeployment before being marketed for external sale:

163 60 0 3600 52 160

When supported by policy, average number of days assets are held prior to being marketed for external sale: 76 60 0 365 21 136






Report Mean

In Place Planning Still an Opportunity Not Planned Number of

Participants

20 Percent of organizations that reported implementation of the following Investment Recovery Association best practices:

72.9% 18.6% 5.1% 3.4% 59

Strong Visible Management Support 67.8% 6.8% 20.3% 5.1% 59

59.3% 10.2% 27.1% 3.4% 59

External Networking 57.6% 13.6% 23.7% 5.1% 59

56.9% 15.5% 22.4% 5.2% 58

Supplier/Contractor Diversity Program 50.9% 7.0% 24.6% 17.5% 57

40.7% 25.4% 28.8% 5.1% 59

39.0% 16.9% 23.7% 20.3% 59

39.0% 6.8% 42.4% 11.9% 59

37.9% 17.2% 32.8% 12.1% 58

30.5% 20.3% 40.7% 8.5% 59

Utilization of the Triple Bottom Line (people, planet, profit) 26.8% 8.9% 37.5% 26.8% 56

Capture of Carbon Credits 20.0% 10.9% 21.8% 47.3% 55

21 Other IR processes considered by organizations as good/best practices: See Addendum A

Internet/intranet Utilization for Sales/Redeployment

Surplus Prevention and Return-to-Supplier processes

Value Chain (Decision Hierarchy) Approach to Surplus Asset Disposition

Surplus Asset Management Processes (identification, valuation, data base visibility, surplus matched with demand, etc.)

Regular Reporting of Metrics and Successes

Surplus and Refurbished Assets Considered before Buying New

Early Involvement with Other Corporate Activities (capital projects, real estate sales, upgrades, demolition, divestitures, plant shut-downs, etc.)

Supplier Integration and Support (IR service provider contracts in place, equipment refurbishment programs, integrated processes, etc.)






Report Mean

Electronic Commerce

22 Percent of total sales that resulted from the use of the Internet/intranet:

External sales via Internet Posting (excluding eAuctions): 18.3% 5.0% 0.0% 100.0% 45 15.6%

External sales via eAuctions: 20.9% 1.0% 0.0% 100.0% 46 9.3%

External sales via 3rd-party sellers or brokers (excluding eAuctions): 45.5% 40.0% 0.0% 100.0% 48 31.4%

23 Redeployment via intranet - percent of total transfers: 24.8% 0.0% 0.0% 100.0% 55 21.6%

24Percent of organizations in which the IR function is responsible for locating and purchasing used machinery and equipment:

11.7% 60 20.5%

25 Percent of organizations that use the following types of information systems for internal redeployment and surplus sales: 56

Combined company-wide redeployment and surplus sales system, web-based 28.6% 10.3%

Separate company-wide redeployment and surplus sales systems, both web-based 7.1% 10.3%

Separate company-wide redeployment and surplus sales systems, only surplus sales system web-based 5.4% 7.7%

One internal deployment system, plus multiple surplus sales systems, some web-based 8.9% 10.3%

No web-based information systems - use posted spreadsheets, lists, faxes, and/or email only 37.5% 46.2%

Other 12.5% 15.4%






Report Mean

26 Percent of organizations that use the following web-based technologies to promote surplus sales: 55

Maintain own company surplus sales website 34.5% 26.3%Actively submit company surplus sales website(s) to search engines for indexing 7.3% 13.2%

Maintain and use database or email list of prospective buyers 43.6% 55.3%

Rely solely on outside contract sales and auction firms 38.2% 39.5%

Rely on third-party websites for marketing of surplus 40.0% 34.2%

Investment Recovery Staffing

27 Investment recovery employees as a percent of total organization employees: 0.2% 0.0% 0.0% 2.7% 55 0.1%

Exempt investment recovery employees as a percent of total IR employees: 63.3% 60.0% 0.0% 100.0% 51 66.3%

Non-exempt investment recovery employees as a percent of total IR employees: 25.0% 0.0% 0.0% 100.0% 51 25.6%

In-house contractors as a percent of total IR employees: 11.7% 0.0% 0.0% 100.0% 51 8.1%

28 Percent of FTE IR employees that have:

Bachelor's degree 54.7% 50.0% 0.0% 100.0% 51 43.3%

Master's degree 24.6% 10.0% 0.0% 100.0% 39 15.5%

CMIR Certification 22.7% 10.0% 0.0% 100.0% 36 23.9%

Professional certification 20.2% 11.0% 0.0% 100.0% 35 15.5%

Less than 5 years of IR experience 38.9% 31.5% 0.0% 100.0% 58 31.9%

Between 5 and 15 years of IR experience 39.8% 33.0% 0.0% 100.0% 58 45.4%

More than 15 years of IR experience 21.2% 0.0% 0.0% 100.0% 58 20.1%






Report Mean

29 Percent of organizations in which the IR function has been in place for: 61

0 - 5 years 19.7%

6 - 10 years 11.5%

More than 10 years 68.9%

30 Average spend for training per investment recovery employee: $650 $388 $0 $3,000 48 $817

31 Percent of organizations that attend the Investment Recovery Association's annual conference: 67.8% 59 75.0%

32a Investment Recovery Salaries:

Level I (Top Position) - Function Head, Investment Recovery

Title See Addendum B

Reports to (Title) See Addendum B

Salary Range

Minimum $98,133 $90,000 $50,000 $180,000 21 $93,196

Maximum $130,808 $120,000 $10,000 $250,000 21 $130,861

Average salary $125,948 $116,000 $93,000 $210,000 22 $105,421

Number of employees supervised

Direct 7 5 0 25 31 9

Indirect 15 5 0 100 24 23






Report Mean

32b Level II - Sr. Investment Recovery Representative

Title See Addendum C

Salary Range

Minimum $70,098 $72,750 $33,000 $90,000 23 $70,930

Maximum $100,317 $98,000 $50,000 $140,000 23 $99,885

Number of employees in position 2 1 0 6 29 2

Average salary $86,806 $86,000 $42,000 $125,000 24 $81,708

32c Level III - Investment Recovery Representative

Title See Addendum D

Salary Range

Minimum $55,900 $60,850 $30,000 $68,000 10 $52,392

Maximum $85,480 $85,000 $72,000 $100,000 10 $78,019


Average salary $72,652 $74,000 $60,000 $80,000 11 $59,635

32d Level IV - Associate Investment Recovery Representative (Clerical, Support Staff)

Title See Addendum E

Salary Range

Minimum $43,225 $41,000 $35,000 $55,500 8 $40,598

Maximum $63,300 $60,000 $55,000 $80,100 8 $59,298


Average salary $61,364 $57,455 $50,000 $85,000 8 $56,121

Average number of union workers 1 1 0 3 9 3

Average number of contract/temporary workers 0 0 0 0 6






Report Mean

Paid by Employer Paid by Employee

Joint Contribution

33 Company Benefits:

Professional Support:

Professional License Fees 78.3% 17.4% 4.3% 46

Professional Society Dues 84.8% 15.2% 0.0% 46

Professional Publications 85.4% 12.5% 2.1% 48

Continuing Education 79.6% 12.2% 8.2% 49Attendance at Investment Recovery Association Conference 83.3% 16.7% 0.0% 48




Addendum A

Benchmark 21: Other Investment Recovery Best Practices

A fully integrated, dedicated Investment Recovery Program with supportive policies and procedures, metrics, annual goals and membership and involvement in the Investment Recovery Association.Automated transmittal of surplus assets from property management system directly to redeployment system.Buyer database sharing with other utilities.Catalyst life-cycle management.Clear policy how to price IR assets for sale.Collection and accountability of scrap sales.[Company] has an extensive recycling program that is primarily managed and reported for the entire Corporation by Investment Recovery. Not aware of another recycling program that is this extensive in the industry. Continuing to reduce our footprint to the environment.Contracts from competitive bidding work best.Defined progression plan for Investment Recovery Specialist.Donation of wood poles and reels to individuals for personal projects. Donations.Having vendors pay via ACH.Identification and elimination of single point vulnerability as it pertains to Investment Recovery Specialists skill sets. In the field, some Operations groups are taking a very active role in identifying surplus items, relocating and storing these items where appropriate, and promoting them across the company. Manage web based auction store front.Primary supply chain processes are tracking surplus materials and equipment and utilizing these for new purchasing requirements where possible, or using third party brokers where redeployment is unlikely.Recycling ink and toner cartridges.Reverse Supply Chain.Scrap paid monthly for all pickups vs per load.Selling to employees through intranet sales.Sustainable reuse with local community.Using workshop to brainstorm opportunities and assign stream leaders for various stream of waste.We adhere to guidelines set by our Capital Accounting Department and FERC to process the proceeds recovered for surplus and salvage assets.Working with a 3rd party to market our surplus machinery.




Benchmark 31: Level I Title Level I Reports to:

Asset Recovery Manager Asset ManagerDirector Category DirectorDirector, Surplus Division Chief Operation Officer (2 responses)Exess Programs Manager Deputy Commissioner OperationsFacilities Director Director (3 responses)Facilities Engineering Sr Mgr Director - Supply ChainFossil Materials management manager Director of OperationsGlobal Facilities Director Director Supply Chain ManagementGlobal MRO Service Lead Director, Trans & Materials Mgmt., Supply Chain ManagementInventory Manager EVP of Supply ChainInvestment Recovery Coordinator Executive VPInvestment Recovery Director Global MRO category managerIR Supervisor (2 responses) Global Operations and Inventory Management ManagerManager (2 responses) Indirect DirectorManager Non-Operation Material Manager (2 responses)Manager of Asset Control and Recovery Manager Material ServicesManager, Asset Accountability Manager of Supply Chain ManagementManager, Inventory Optimization, Asset Recovery & Recycling Manager Procurement OperationsManager, Investment Recovery (3 responses) Manager, Asset ManagementManager, Materials Management Managing DirectorProcurement Manager Managing Director, Supply Chain Strategy and SupportProgram Manager Procurement DirectorProperty Disposal Officer Program Management Director, Finance & Business OperationsSenior Manager Property Programs ManagerSenior Manager Program Decision Support Senior DirectorSenior Manager Senior ManagerSourcing Manager Supervisor, General Supply Chain SpecialistSupervisor, Investment Recovery & Material Master Data Supply Chain ManagerSupervisor, Materials Management SVP OperationsSupply Chain Supervisor Investment Recovery Vice President Business Operations and Technical SupportVice President, Corporate ProcurementVP of Engineering

Addendum B




Addendum C

Benchmark 31: Level II Titles (Sr. Investment Recovery Representative)

Asset Recovery AdministratorAsset Recovery Principle SpecialistBusiness AnalystDirector, Corporate ProcurementInv Recovery CoordinatorInventory Control SpecialistInvestment Recovery Analyst (3 responses)Investment Recovery CoordinatorInvestment Recovery ManagerInvestment Recovery Specialist (2 responses)Investment Recovery Specialist lInvestment Recovery Specialist, SrIR ConsultantMaterials AnalystProgram ManagerProject ManagerProperty Disposal SpecialistProperty ManagerSenior Asset Recovery CoordinatorSenior Investment Recovery SpecialistSenior IR PlannerSenior Supply Business AnalystSourcing Specialist IIISpecialistSr Materials ManagementSr Sourcing AnalystSr. Analyst, Inventory SystemsSupply Person Leader




Addendum D

Asset Disposition Analyst Investment Recovery Specialist llAsset Recovery Associate Specialist IR PlannerAsset Recovery Coordinator MDC SupervisorBusiness Information Technician Property and Receipt Control SpecialistDivision Surplus Equipment Administrator Purchasing Coordinator IInventory Control Specialist Site Procurement OperationsInvestment Recovery Specialist (2 responses) Supply Person

Addendum E

Administrator (2 responses) Material SpecialistBusiness Support Rep Reclamation ProcessorInventory Control Specialist Senior Support SpecialistInvestment Recovery Technician and Admin Supply Chain ClerkMaterial Processor Supply Tech

Benchmark 31: Level III (Investment Recovery Representative) Titles

Benchmark 31: Level IV (Associate Investment Recovery Representative) Titles


Investment Recovery Association Members Release Date: July 7, 2017




Report Mean



















Report Mean


85.3% 94.2% 39.7% 100.0% 26 83.9%














Report Mean

















Other 3.6% 3.4%

13 Average number of transactions per IR employee: 1,560 173 6 30,004 24 321







Report Mean
















Other 0.0% 0.0%






Report Mean






80 30 0 1000 35 160







Report Mean


Participants


83.8% 16.2% 0.0% 0.0% 37


70.3% 16.2% 13.5% 0.0% 37


70.3% 13.5% 16.2% 0.0% 37


45.9% 32.4% 21.6% 0.0% 37

54.1% 16.2% 21.6% 8.1% 37

35.1% 8.1% 43.2% 13.5% 37

47.2% 16.7% 27.8% 8.3% 36

37.8% 21.6% 32.4% 8.1% 37

















Report Mean

Electronic Commerce







5.3% 38 20.5%







Other 13.9% 15.4%






Report Mean













Master's degree 27.6% 17.0% 0.0% 100.0% 25 15.5%











Report Mean


0 - 5 years 13.2%

6 - 10 years 5.3%








Salary Range

Minimum $96,433 $90,000 $50,000 $180,000 18 $93,196

Maximum $129,276 $120,000 $10,000 $250,000 18 $130,861

Average salary $126,467 $115,000 $93,000 $210,000 19 $105,421


Direct 6 4 0 23 23 9

Indirect 11 5 0 75 17 23






Report Mean



Salary Range

Minimum $70,793 $72,750 $33,000 $90,000 21 $70,930

Maximum $100,824 $98,000 $50,000 $140,000 21 $99,885


Average salary $88,291 $87,000 $42,000 $125,000 21 $81,708



Salary Range

Minimum $58,778 $62,000 $40,000 $68,000 9 $52,392

Maximum $83,867 $85,000 $72,000 $96,800 9 $78,019


Average salary $72,652 $74,000 $60,000 $80,000 11 $59,635



Salary Range

Minimum $43,225 $41,000 $35,000 $55,500 8 $40,598

Maximum $63,300 $60,000 $55,000 $80,100 8 $59,298


Average salary $61,364 $57,455 $50,000 $85,000 8 $56,121








Report Mean


Joint Contribution








Oil & Gas Release Date: July 7, 2017




Report Mean



3 Total cost benefit dollars per transaction: $46,354 $24,000 $5,000 $160,000 5 $22,756



6 Investment recovery third-party sales as a percent of total cost benefit: 28.7% 4 23.9%

7 Net third-party sales as a percent of total cost benefit: 25.8% 4 22.7%




Benchmarks not displayed contained insufficient data to report.






Report Mean

















Other 16.7% 3.4%

13 Average number of transactions per IR employee: 80 4 321







Report Mean
















Other 16.7% 0.0%






Report Mean






561 60 30 3600 7 160

When supported by policy, average number of days assets are held prior to being marketed for external sale: 60 4 136






Report Mean


Participants


33.3% 44.4% 11.1% 11.1% 9


55.6% 11.1% 33.3% 0.0% 9


25.0% 50.0% 25.0% 0.0% 8


55.6% 22.2% 0.0% 22.2% 9

33.3% 22.2% 11.1% 33.3% 9

22.2% 11.1% 55.6% 11.1% 9

11.1% 22.2% 44.4% 22.2% 9

33.3% 22.2% 44.4% 0.0% 9

















Report Mean

Electronic Commerce







11.1% 9 20.5%







Other 0.0% 15.4%






Report Mean






















Report Mean


0 - 5 years 44.4%

6 - 10 years 11.1%





Joint Contribution








All Utilities Release Date: July 7, 2017




Report Mean



















Report Mean


86.9% 95.7% 41.4% 100.0% 18 83.9%














Report Mean

















Other 0.0% 3.4%

13 Average number of transactions per IR employee: 335 141 16 1,640 15 321







Report Mean
















Other 0.0% 0.0%






Report Mean






105 50 0 1000 21 160







Report Mean


Participants


87.5% 12.5% 0.0% 0.0% 24


66.7% 16.7% 16.7% 0.0% 24


75.0% 12.5% 12.5% 0.0% 24


37.5% 33.3% 29.2% 0.0% 24

41.7% 16.7% 25.0% 16.7% 24

25.0% 4.2% 50.0% 20.8% 24

47.8% 17.4% 30.4% 4.3% 23

25.0% 20.8% 50.0% 4.2% 24

















Report Mean

Electronic Commerce







4.2% 24 20.5%







Other 19.0% 15.4%






Report Mean













Master's degree 29.9% 16.5% 0.0% 100.0% 18 15.5%











Report Mean


0 - 5 years 8.3%

6 - 10 years 4.2%








Salary Range

Minimum $98,400 $90,000 $60,000 $180,000 12 $93,196

Maximum $133,748 $122,500 $10,000 $250,000 12 $130,861

Average salary $128,989 $115,000 $98,000 $210,000 12 $105,421


Direct 7 5 0 23 15 9

Indirect 16 1 0 75 10 23






Report Mean



Salary Range

Minimum $70,116 $71,375 $50,000 $90,000 16 $70,930

Maximum $102,100 $97,500 $76,000 $140,000 16 $99,885


Average salary $88,707 $82,500 $70,000 $125,000 16 $81,708



Salary Range

Minimum $57,329 $62,000 $40,000 $65,000 7 $52,392

Maximum $83,000 $85,000 $72,000 $92,000 7 $78,019


Average salary $71,830 $72,000 $60,000 $80,000 9 $59,635



Salary Range

Minimum $42,357 $40,000 $35,000 $55,500 7 $40,598

Maximum $60,900 $60,000 $55,000 $69,300 7 $59,298


Average salary $60,601 $54,910 $50,000 $85,000 7 $56,121








Report Mean


Joint Contribution








Utilities with Revenue >$5B Release Date: July 7, 2017




Report Mean


1 Total cost benefit: $12,255,680 $11,875,000 $1,500,000 $29,000,000 14 $11,865,559


3 Total cost benefit dollars per transaction: $26,361 $20,132 $2,306 $94,444 10 $22,756


5 Total cost benefit provided by each exempt investment recovery employee: $6,779,406 $6,726,258 $1,635,504 $15,980,000 13 $5,856,106













Report Mean


85.7% 95.0% 41.4% 99.0% 12 83.9%














Report Mean




Auctions 100.0% 72.4%













Other 0.0% 3.4%

13 Average number of transactions per IR employee: 407 217 16 1,640 10 321







Report Mean
















Other 0.0% 0.0%






Report Mean






143 90 0 1000 13 160

When supported by policy, average number of days assets are held prior to being marketed for external sale: i.d. 136






Report Mean


Participants


86.7% 13.3% 0.0% 0.0% 15


66.7% 20.0% 13.3% 0.0% 15


80.0% 6.7% 13.3% 0.0% 15


26.7% 33.3% 40.0% 0.0% 15

33.3% 26.7% 26.7% 13.3% 15

20.0% 0.0% 60.0% 20.0% 15

53.3% 20.0% 20.0% 6.7% 15

20.0% 33.3% 40.0% 6.7% 15

















Report Mean

Electronic Commerce







6.7% 15 20.5%







Other 30.8% 15.4%






Report Mean













Master's degree 26.2% 16.5% 0.0% 100.0% 10 15.5%











Report Mean


0 - 5 years 6.7%

6 - 10 years 0.0%








Salary Range

Minimum $95,200 $90,000 $60,000 $180,000 9 $93,196

Maximum $128,330 $120,000 $10,000 $250,000 9 $130,861

Average salary $133,318 $115,000 $100,000 $210,000 9 $105,421


Direct 7 5 2 15 11 9

Indirect 19 4 0 75 6 23






Report Mean



Salary Range

Minimum $71,373 $70,000 $50,000 $90,000 11 $70,930

Maximum $101,200 $98,000 $76,000 $140,000 11 $99,885


Average salary $87,780 $80,000 $75,000 $120,000 10 $81,708



Salary Range

Minimum $60,217 $62,000 $53,300 $65,000 6 $52,392

Maximum $84,333 $85,000 $72,000 $92,000 6 $78,019


Average salary $73,424 $75,971 $60,000 $80,000 7 $59,635



Salary Range

Minimum $41,750 $40,000 $35,000 $55,500 6 $40,598

Maximum $61,050 $60,000 $55,000 $69,300 6 $59,298


Average salary $55,842 $53,000 $50,000 $69,300 5 $56,121


Average number of contract/temporary workers i.d.






Report Mean


Joint Contribution







i.d. indicates insufficient data


Utilities with Revenue <$5B Release Date: July 7, 2017




Report Mean





4 Total cost benefit provided by each investment recovery employee: $550,152 $521,875 $58,750 $1,260,000 8 $3,870,713

5 Total cost benefit provided by each exempt investment recovery employee: $1,006,553 $865,493 $313,333 $2,235,000 6 $5,856,106













Report Mean


89.2% 96.9% 49.6% 100.0% 6 83.9%














Report Mean

















Other 0.0% 3.4%

13 Average number of transactions per IR employee: 191 53 21 675 5 321







Report Mean
















Other 0.0% 0.0%






Report Mean






44 25 0 180 8 160

When supported by policy, average number of days assets are held prior to being marketed for external sale: i.d. 136






Report Mean


Participants


88.9% 11.1% 0.0% 0.0% 9


66.7% 11.1% 22.2% 0.0% 9


66.7% 22.2% 11.1% 0.0% 9


55.6% 33.3% 11.1% 0.0% 9

55.6% 0.0% 22.2% 22.2% 9

33.3% 11.1% 33.3% 22.2% 9

37.5% 12.5% 50.0% 0.0% 8

33.3% 0.0% 66.7% 0.0% 9

















Report Mean

Electronic Commerce







0.0% 9 20.5%







Other 0.0% 15.4%






Report Mean













Master's degree 34.5% 13.0% 0.0% 100.0% 8 15.5%











Report Mean


0 - 5 years 11.1%

6 - 10 years 11.1%








Salary Range

Minimum i.d. $93,196

Maximum i.d. $130,861

Average salary i.d. $105,421


Direct 9 4 9

Indirect 10 4 23






Report Mean



Salary Range

Minimum $67,350 $72,750 $50,000 $85,000 5 $70,930

Maximum $104,080 $97,000 $90,000 $135,000 5 $99,885


Average salary $90,250 $88,750 $70,000 $125,000 6 $81,708



Salary Range



Number of employees in position i.d. 3




Salary Range



Number of employees in position i.d. 5


Average number of union workers i.d. 3

Average number of contract/temporary workers i.d.






Report Mean


Joint Contribution







i.d. indicates insufficient data

investment recovery performance benchmarking...2017/07/07 · of companies that said non-hazardous...

Documents