Efficiency frontier for 2018

Calculation of the improvement potential given some advertising expenditure and sales amount. Improvement is the difference between what was actually spent and what needed to be spent in marketing efforts by car and channel type in order to be efficient (slack - input = improvement).

# A tibble: 17 x 8
   DMU    Digital Outdoor Press Radio Sat.TV TV.Nat TV.Reg
   <chr>    <dbl>   <dbl> <dbl> <dbl>  <dbl>  <dbl>  <dbl>
 1 car 1      0       0    0      0      0      0      0  
 2 car 2      0       0    0      0      0      0      0  
 3 car 3     18.8     0   72.4   19.0   98.8   40.0   18.3
 4 car 4      0       0    0      0      0      0      0  
 5 car 5      0       0    0      0      0      0      0  
 6 car 6      0       0   43.3   16.0   76.1   27.7    0  
 7 car 7     39.1     0    2.37   0     71.6   11.6    0  
 8 car 8     86.9    34.4  0     86      0     16.0    0  
 9 car 9      0       0    0      0      0      0      0  
10 car 10    63.8    73.9  0     59.0    0      0      0  
11 car 11     0       0    0      0      0      0      0  
12 car 12    23.7     0   22.2   57.6    0      0      0  
13 car 13     0       0    0      0      0      0    NaN  
14 car 14     0       0    0      0      0    NaN      0  
15 car 15     0       0    0      0      0      0      0  
16 car 16     0       0   78.1    2.6    0     63.9    0  
17 car 17    31.2     0   66.7    0     48.6   23.9    0  

Network of peers according to their efficiency functions

Which brand is similar to what other brand? (arrows point from inefficient to 100% efficient networks). It shows that “Car 4” is 100% efficient on its own, but no other brand has the same efficiency function.