ABCDEFGHIJKLMNOPQRSTU
1
TIME UNIT (e.g. year, quarter, month)
2
TOTAL COSTS PER TIME UNIT£700
3
PriceNumber of sales per time unit% contribution to costsContribution to costs per saleNet Profit Margin per sale
4
Product 1£102530.00%£8.40£1.60
5
Product 2£102550.00%£14.00-£4.00
6
Product 3£255020.00%£2.80£22.20
7
Product 4£510.00%£0.00£5.00
8
Product 5£510.00%£0.00£5.00
9
Product 6£510.00%£0.00£5.00
10
Product 7£510.00%£0.00£5.00
11
12
13
TOTAL104100.00%
14
15
16
NET PROFIT PER CUSTOMER LIFETIME CALCULATORS
17
18
SINGLE SPENDProduct 1Product 2Product 3Product 4Product 5Product 6Product 7CUSTOMER LIFETIME NET PROFIT
19
Customer Type 11000000£1.60
20
Customer Type 20100000-£4.00
21
Customer Type 30010000£22.20
22
23
24
SEQUENTIAL SPEND PER UNITProduct 1Product 2Product 3Product 4Product 5Product 6Product 7CUSTOMER LIFETIME NET PROFIT
25
Customer Type 11010000£23.80
26
Customer Type 20100000-£4.00
27
Customer Type 30110000£18.20
28
29
30
RECURRING SPEND PER UNITProduct 1Product 2Product 3Product 4Product 5Product 6Product 7PER SALE NET PROFITNO. OF UNITS Client StaysCUSTOMER LIFETIME NET PROFIT
31
Customer Type 11000000£1.601£1.60
32
Customer Type 20100000-£4.003-£12.00
33
Customer Type 30010000£22.204£88.80
34
35
36
37
REFERRALS
38
39
SINGLE SPENDCUSTOMER LIFETIME NET PROFITREFERRALSTRUE CUSTOMER LIFETIME NET PROFIT
40
Customer Type 1£1.601£3.20
41
Customer Type 2-£4.001-£8.00
42
Customer Type 3£22.201£44.40
43
44
45
SEQUENTIAL SPEND PER UNITCUSTOMER LIFETIME NET PROFITREFERRALSTRUE CUSTOMER LIFETIME NET PROFIT
46
Customer Type 1£23.801£47.60
47
Customer Type 2-£4.000-£4.00
48
Customer Type 3£18.201£36.40
49
50
51
RECURRING SPEND PER UNITCUSTOMER LIFETIME NET PROFITREFERRALSTRUE CUSTOMER LIFETIME NET PROFIT
52
Customer Type 1£1.601£3.20
53
Customer Type 2-£12.001-£24.00
54
Customer Type 3£88.801£177.60
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100