We’ve got a new home: Visit us here: https://analyticsdefined.com/

Data Envelopment Analysis is a Performance Measurement technique which is used for comparing the performances of similar units of an organization. The units for which we are doing the performance analysis are called Decision Making Units (DMU). For example, we can compare all the McDonald’s outlets operating in the Delhi NCR Region to find out which outlet is doing good and which one is not and then recommend some actions to bad ones to perform better. DEA has wide applications in all industries including hospitals, banks, universities etc. This technique calculates the efficiencies of all DMUs by taking a set of input and output variables (which are generally the most important business metrics of the organization) and then set a benchmark. The most important advantage of this techniques is that it can handle the multiple input and output variables which are generally not comparable to each other. DEA techniques are very popular in Operations Research and it uses concepts of Linear Programming to formulate and solve the problem at hand.

Example

Now we know what DEA is, let us solve a problem to clarify the concept behind DEA. Imagine yourself as the owner of ABC Stores, a chain of lifestyle retail stores in India having six outlets (here they will be called as DMUs) at Delhi, Mumbai, Bangalore, Chennai, Kolkata and Hyederabad. You want to find out which outlet is efficient and which ones are inefficient and then benchmark the most efficient one to recommend improvements to inefficient outlets. Just to make our life easier consider a 2 input and 2 output problem. Number of Employees and Management time/week as inputs and Number of dresses sold/week, number of accessories sold/week as outputs

The following table shows the values for above-mentioned input and output factors

Store Location Number of Employees Management Time/Week Number of Dresses Sold/Week Number of Accessories Sold/Week
Delhi 51 38 169 119
Mumbai 60 45 243 167
Bangalore 43 33 173 158
Chennai 53 43 216 138
Kolkata 43 38 155 161
Hyderabad 44 35 169 157

Now the efficiency for each DMU can be calculated as follows

equ

where u1, u2, v1, and v2 are respective weights of the output, input factors. But how to calculate these weights? To find out these weights we need to solve Linear Programming problems for each DMU (if we have n DMUs then we need to solve n Linear Programming problems)

Linear Programming Formulation

As we have six DMUs in this case, we need solve 6 different LP problems. I will show you how to formulate LP for one DMU, let’s take DMU1 (Delhi) for example.

Objective Function:

equ

Since our objective function is fractional, it is still not formulated as an LP problem. So we will make our denominator equal to 1 and treat it as a constraint. Modified LP problem will look like

Objective Function:

equ

This is the final LP formulation for DMU1 (Delhi). Similarly, we need to formulate the LP for DMUs as well

Implementation in R

There are numerous packages in R such as lpSolve, Benchmarking, FEAR to do DEA Analysis. In this example, I am using rDEA package

equ

equ

Results and Interpretation

equ

Efficiency Delhi Mumbai Bangalore Chennai Kolkata Hyderabad
Delhi 0.8254 0 0.6435 0.0730 0 0.0000 0
Mumbai 1.0000 0 1.0000 0.0000 0 0.0000 0
Bangalore 1.0000 0 0.0000 1.0000 0 0.0000 0
Chennai 1.0000 0 0.0000 0.0000 1 0.0000 0
Kolkata 1.0000 0 0.0000 0.0000 0 1.0000 0
Hyderabad 0.9686 0 0.0000 0.8546 0 0.1365 0

It is clearly evident from the above table, except Delhi and Hyderabad outlets remaining outlets are efficient. So what improvement should we recommend to Delhi and Hyderabad (inefficient ones) so that they can perform at par with the efficient outlets? This can be done by using shadow prices (lambda values from above table). For the inefficient DMUs Delhi and Hyderabad, the benchmarks DMUs are Mumbai, Bangalore, Chennai and Kolkata and their corresponding shadow prices are 0.6435, 0.0730, 0 and 0 respectively for Delhi. Therefore the recommendation for Delhi is as follows

equ

Delhi DMU is overusing their number of employees by 9.25 units and also, they are giving 6.63 hours of Management time more than their efficient DMUs. So, they should reduce take the Number of Employees and Management Time/Week by that amount. The similar comparison can be done Hyderabad DMU.

Final Notes

DEA is a very powerful technique for performance measurement and widely used across the industry. Try this technique to find out efficiencies of any units that piques your interest. You can even find out performance analysis of IPL teams once this season gets over and recommend for improvement for next season.