How Is the Variability of Profitability of Infinity’s Customers Across Different Product Lines?
Autor: Sharon • February 15, 2018 • 526 Words (3 Pages) • 824 Views
...
- What are insights of product cross-holding?
CC+M:
Top 10% of Customers create 24.2% of total profits
Top 20% create 41.4% of profits
Profitable customers create 115.8% of profits
10% of customers are unprofitable?
Case Processing Summary
Cases
Included
Excluded
Total
N
Percent
N
Percent
N
Percent
Total Profit * Percentile Group of TotalProfit
1000
99.8%
2
0.2%
1002
100.0%
Case Summaries
Total Profit
Percentile Group of TotalProfit
N
Mean
Sum
% of Total Sum
1
100
776.60
77660
24.2%
2
100
549.63
54963
17.2%
3
99
469.40
46471
14.5%
4
100
417.50
41750
13.0%
5
99
375.96
37220
11.6%
6
101
340.42
34382
10.7%
7
103
299.51
30850
9.6%
8
98
263.36
25809
8.1%
9
100
220.16
22016
6.9%
10
100
-507.44
-50744
-15.8%
Total
1000
320.38
320377
100.0%
[pic 4]
CA+M:
Top 10% of Customers create 28.2% of total profits
Top 20% create 44.4% of profits
Profitable customers create 111.1% of profits
10% of customers are unprofitable?
Case Processing Summary
Cases
Included
Excluded
Total
N
Percent
N
Percent
N
Percent
Total Profit * Percentile Group of TotalProfit
1000
99.8%
2
0.2%
1002
100.0%
Case Summaries
Total Profit
Percentile Group of TotalProfit
N
Mean
Sum
% of Total Sum
1
100
769.09
76909
28.2%
2
100
442.18
44218
16.2%
3
99
380.17
37637
...