| Literature DB >> 36033054 |
Aixin Cai1, Maohong Liu2,3, Huan Liu4.
Abstract
The performance evaluation is one of the most important organizational management strategies used to guide the sales behavior of sales staff. However, it should be work process-oriented or sales result-oriented has become a dilemma for the management when evaluating employees' performance. Therefore, comprehensively evaluating the work process and sales results has become a challenge when it comes to salespeople performance appraisal. To solve this dilemma, this research builds a salesperson performance evaluation model which considering both of work efficiency and effectiveness, based on the decision tree model. Specifically, we use the Data Envelopment Analysis (DEA) model to quantify the work efficiency of salespeople and measure the work effectiveness by amount of sales. Moreover, this research proposes an advanced integrated DEA model by integrating the self-evaluation DEA models, peer-evaluation DEA models, and Gini impurity, which is identified to be more stable compared with the current DEA model. Finally, a case study of a Chinese liquor company is introduced to illustrate the applicability and feasibility of the salesperson performance evaluation model. The proposed model is applied to evaluate the performance of the salespeople, and a set of comprehensive and objective sales performance evaluation results are obtained. The estimated results can provide feasible sales management suggestions for the company in diagnosing work problems of salespeople.Entities:
Keywords: Gini impurity; data envelopment analysis; decision tree; performance evaluation; salespeople management
Year: 2022 PMID: 36033054 PMCID: PMC9416928 DOI: 10.3389/fpsyg.2022.923198
Source DB: PubMed Journal: Front Psychol ISSN: 1664-1078
Figure 1Salesperson performance evaluation framework and logic.
Figure 2The salespeople performance evaluation model.
The variables and definitions.
|
|
|
|
|
|---|---|---|---|
| Working hours | The working length reflects how hardworking are the salesperson (Sujan, | Working hours = End of work time – Start of work time | The data is obtained from the salesperson punching in the sales work data recording system. |
| The number of customer visits | The number of customer visits indicate the salesperson's work attitude (Lussier and Hall, | The number of customer visits is measured by adding up the number of times a salesperson visits a customer in a month. Customers can be visited multiple times, and the number of customer visits increases by 1 for each customer visit by a salesperson. | The sales work data recording system can automatically obtain the visit time and positioning when salesperson visits a customer. So we obtain the frequency of customer visits through the records. |
| Regional market potential | This variable reflects the market consumption potential (Boles et al., | Regional market potential is measured by the total number of developed and undeveloped customers in the region. | The quantity information of product sales objects in various regions of Wuhan is obtained from Baidu Map and |
| Sales | Monthly sales reflect sales results (Churchill et al., | Sales is measured by adding up the amount of all orders filled by salespeople in a month. | The data is obtained from the sales work data recording system. After a customer places an order, the system automatically generates the order and displays specific sales information, including product name, product unit price, product quantity, total amount, etc. |
| Order volume | The monthly order volume reflects sales results and selling characteristics (Boles et al., | Order volume is measured by the sum of all orders filled by salespeople in a month. | The data is obtained from the sales work data recording system. |
| Sales volume | The number of products sold by the salesperson reflects sales results and selling characteristics (Boles et al., | Sales volume is measured by adding up the number of all items in all orders sold by a salesperson in a month. | The data is obtained from the sales work data recording system. |
Comprehensive work efficiency measured by the Gini impurity-based integrated DEA model.
|
|
|
|
|
|
|
|
|
|---|---|---|---|---|---|---|---|
| 1 | 0.51 | 0.19 | 0.18 | 0.13 | 0.13 | 0.12 | 0.21 |
| 2 | 0.70 | 0.35 | 0.33 | 0.24 | 0.25 | 0.22 | 0.34 |
| 3 | 0.42 | 0.40 | 0.33 | 0.22 | 0.22 | 0.21 | 0.30 |
| 4 | 1.00 | 1.00 | 0.81 | 0.57 | 1.00 | 0.52 | 0.81 |
| 5 | 0.63 | 0.56 | 0.55 | 0.39 | 0.45 | 0.21 | 0.46 |
| 6 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 0.61 | 0.93 |
| 7 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 0.41 | 0.90 |
| 8 | 0.37 | 0.24 | 0.19 | 0.14 | 0.14 | 0.13 | 0.20 |
| 9 | 0.54 | 0.32 | 0.32 | 0.29 | 0.29 | 0.22 | 0.33 |
| 10 | 0.57 | 0.26 | 0.26 | 0.21 | 0.21 | 0.18 | 0.28 |
| 11 | 0.56 | 0.33 | 0.33 | 0.26 | 0.27 | 0.22 | 0.33 |
| 12 | 1.00 | 0.72 | 0.71 | 0.40 | 0.42 | 0.17 | 0.56 |
| 13 | 1.00 | 1.00 | 0.84 | 0.70 | 1.00 | 0.53 | 0.84 |
| 14 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 0.24 | 0.87 |
| 15 | 0.39 | 0.26 | 0.25 | 0.18 | 0.20 | 0.08 | 0.22 |
| 16 | 0.99 | 0.98 | 0.97 | 0.91 | 0.98 | 0.61 | 0.91 |
| 17 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 0.18 | 0.86 |
| 18 | 0.53 | 0.24 | 0.23 | 0.19 | 0.20 | 0.15 | 0.25 |
| 19 | 0.82 | 0.78 | 0.75 | 0.65 | 0.65 | 0.43 | 0.68 |
| 20 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 0.64 | 0.94 |
| 21 | 0.40 | 0.35 | 0.27 | 0.22 | 0.22 | 0.19 | 0.27 |
| 22 | 0.94 | 0.84 | 0.82 | 0.65 | 0.65 | 0.44 | 0.72 |
| 23 | 0.67 | 0.17 | 0.14 | 0.11 | 0.12 | 0.09 | 0.21 |
| 24 | 0.74 | 0.84 | 0.74 | 0.50 | 0.56 | 0.45 | 0.63 |
| 25 | 1.00 | 1.00 | 0.97 | 0.57 | 1.00 | 0.49 | 0.84 |
| 26 | 0.84 | 0.90 | 0.82 | 0.52 | 0.72 | 0.51 | 0.72 |
| 27 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 0.27 | 0.88 |
| 28 | 0.75 | 0.65 | 0.60 | 0.43 | 0.43 | 0.27 | 0.52 |
| 29 | 0.92 | 0.45 | 0.33 | 0.26 | 0.30 | 0.21 | 0.41 |
| 30 | 0.94 | 0.53 | 0.53 | 0.29 | 0.39 | 0.20 | 0.48 |
| 31 | 0.55 | 0.14 | 0.14 | 0.12 | 0.12 | 0.10 | 0.19 |
| 32 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 0.30 | 0.88 |
| 33 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 0.56 | 0.93 |
| 34 | 0.28 | 0.36 | 0.17 | 0.13 | 0.13 | 0.10 | 0.19 |
| 35 | 0.39 | 0.24 | 0.21 | 0.16 | 0.16 | 0.14 | 0.21 |
| 36 | 1.00 | 1.00 | 0.92 | 0.60 | 1.00 | 0.57 | 0.85 |
| 37 | 0.57 | 0.19 | 0.17 | 0.14 | 0.14 | 0.12 | 0.22 |
| 38 | 1.00 | 0.84 | 0.79 | 0.62 | 0.68 | 0.21 | 0.69 |
| 39 | 0.99 | 0.99 | 0.98 | 0.90 | 0.91 | 0.59 | 0.89 |
| 40 | 0.88 | 0.93 | 0.87 | 0.80 | 0.83 | 0.54 | 0.81 |
| 41 | 0.34 | 0.25 | 0.19 | 0.11 | 0.11 | 0.11 | 0.18 |
| 42 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 0.64 | 0.94 |
| 43 | 0.74 | 0.95 | 0.72 | 0.25 | 0.26 | 0.18 | 0.51 |
| 44 | 0.83 | 0.79 | 0.79 | 0.64 | 0.67 | 0.46 | 0.69 |
| 45 | 0.72 | 0.84 | 0.71 | 0.48 | 0.65 | 0.45 | 0.64 |
| 46 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 0.28 | 0.88 |
| 47 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 0.45 | 0.91 |
| 48 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 0.78 | 0.96 |
| 49 | 0.38 | 0.25 | 0.20 | 0.15 | 0.15 | 0.14 | 0.21 |
| 50 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 0.71 | 0.95 |
| 51 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 0.71 | 0.95 |
| 52 | 1.00 | 0.93 | 0.89 | 0.54 | 0.71 | 0.24 | 0.71 |
| 53 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 0.64 | 0.94 |
| 54 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 0.20 | 0.86 |
| 55 | 1.00 | 1.00 | 0.81 | 0.59 | 1.00 | 0.50 | 0.81 |
| 56 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 0.60 | 0.93 |
| 57 | 0.80 | 0.88 | 0.78 | 0.50 | 0.70 | 0.48 | 0.69 |
| 58 | 0.86 | 0.81 | 0.80 | 0.61 | 0.62 | 0.53 | 0.70 |
| 59 | 0.98 | 0.99 | 0.81 | 0.51 | 0.83 | 0.51 | 0.77 |
| 60 | 1.00 | 0.90 | 0.83 | 0.61 | 0.61 | 0.44 | 0.73 |
| 61 | 0.64 | 0.72 | 0.60 | 0.35 | 0.48 | 0.38 | 0.52 |
In order to protect the information of the salespeople, their names are indicated by numbers.
Salesperson performance classification based on integrated DEA with Gini impurity.
|
|
|
|
|
|---|---|---|---|
| 1 | 0.21 | 9,240.48 | Problematic |
| 2 | 0.34 | 16,768.00 | Problematic |
| 3 | 0.3 | 21,187.48 | Bottleneck |
| 4 | 0.81 | 62,024.83 | Training-needed |
| 5 | 0.46 | 18,216.00 | Opportunistic |
| 6 | 0.93 | 93,073.00 | Benchmark |
| 7 | 0.9 | 39,802.00 | Opportunistic |
| 8 | 0.2 | 18,968.84 | Bottleneck |
| 9 | 0.33 | 18,157.43 | Bottleneck |
| 10 | 0.28 | 13,278.00 | Problematic |
| 11 | 0.33 | 16,987.52 | Problematic |
| 12 | 0.56 | 12,616.00 | Strength-sparing |
| 13 | 0.84 | 51,546.00 | Training-needed |
| 14 | 0.87 | 15,610.99 | Strength-sparing |
| 15 | 0.22 | 11,624.00 | Problematic |
| 16 | 0.91 | 52,712.00 | Less-motivated |
| 17 | 0.86 | 20,773.00 | Opportunistic |
| 18 | 0.25 | 9,346.00 | Problematic |
| 19 | 0.68 | 73,604.75 | Diligent |
| 20 | 0.94 | 102,107.04 | Benchmark |
| 21 | 0.27 | 24,992.04 | Bottleneck |
| 22 | 0.72 | 68,749.91 | Training-needed |
| 23 | 0.21 | 3,912.00 | Problematic |
| 24 | 0.63 | 63,701.98 | Training-needed |
| 25 | 0.84 | 32,509.00 | Opportunistic |
| 26 | 0.72 | 76,838.29 | Diligent |
| 27 | 0.88 | 30,074.00 | Opportunistic |
| 28 | 0.52 | 59,586.00 | Training-needed |
| 29 | 0.41 | 19,633.86 | Bottleneck |
| 30 | 0.48 | 18,452.00 | Opportunistic |
| 31 | 0.19 | 9,644.22 | Problematic |
| 32 | 0.88 | 20,882.00 | Opportunistic |
| 33 | 0.93 | 27,609.00 | Opportunistic |
| 34 | 0.19 | 28,826.30 | Bottleneck |
| 35 | 0.21 | 14,200.00 | Problematic |
| 36 | 0.85 | 89,316.80 | Benchmark |
| 37 | 0.22 | 11,362.00 | Problematic |
| 38 | 0.69 | 19,798.00 | Opportunistic |
| 39 | 0.89 | 89,563.38 | Benchmark |
| 40 | 0.81 | 78,951.18 | Benchmark |
| 41 | 0.18 | 15,170.20 | Problematic |
| 42 | 0.94 | 59,569.00 | Less-motivated |
| 43 | 0.51 | 90,834.00 | Diligent |
| 44 | 0.69 | 75,650.00 | Diligent |
| 45 | 0.64 | 82,602.84 | Diligent |
| 46 | 0.88 | 19,690.00 | Opportunistic |
| 47 | 0.91 | 84,910.00 | Benchmark |
| 48 | 0.96 | 66,727.75 | Less-motivated |
| 49 | 0.21 | 17,628.00 | Bottleneck |
| 50 | 0.95 | 57,887.48 | Less-motivated |
| 51 | 0.95 | 59,424.69 | Less-motivated |
| 52 | 0.71 | 14,886.00 | Strength-sparing |
| 53 | 0.94 | 57,753.44 | Less-motivated |
| 54 | 0.86 | 4,094.00 | Strength-sparing |
| 55 | 0.81 | 81,505.02 | Diligent |
| 56 | 0.93 | 70,088.32 | Less-motivated |
| 57 | 0.69 | 80,961.10 | Diligent |
| 58 | 0.7 | 49,189.33 | Training-needed |
| 59 | 0.77 | 88,071.88 | Diligent |
| 60 | 0.73 | 58,974.16 | Training-needed |
| 61 | 0.52 | 59,988.59 | Training-needed |
In order to protect the information of the salespeople, their names are indicated by numbers.
Figure 3Average personnel input, work efficiency and sales in each type of salesperson.