Value of focus - let customers go

Value of focus - let customers go : Sheet1


1
2
3	Non focused: out of 5 companies, only 1 is really exactly as your last customer for the most important metrics
4	Focused: 1/2 companies you engage with are in focus
5
6			Focused	Not focused
7		Time spent to No	1	25	hours
8		Time spent to Yes	15	15	hours
9		Lead time	3	6	weeks
10		Hours to close	16	115	hours
11
12		Cost / hour	€100.00
13		Salaries	€6,000
14
15
16		People	2
17		Hours per week	40
18						Week	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24
19						Sales hours	80	80	80	80	80	80	80	80	80	80	80	80	80	80	80	80	80	80	80	80	80	80	80	80
20						Closed deals No Focus					0.6956521739	0.6956521739	0.6956521739	0.6956521739	0.6956521739	0.6956521739	0.6956521739	0.6956521739	0.6956521739	0.6956521739	0.6956521739	0.6956521739	0.6956521739	0.6956521739	0.6956521739	0.6956521739	0.6956521739	0.6956521739	0.6956521739	0.6956521739
21						Sum closed eals no focus						0.6956521739	1.391304348	2.086956522	2.782608696	3.47826087	4.173913043	4.869565217	5.565217391	6.260869565	6.956521739	7.652173913	8.347826087	9.043478261	9.739130435	10.43478261	11.13043478	11.82608696	12.52173913	13.2173913
22						Closed deals Focus			5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5
23										5	10	15	20	25	30	35	40	45	50	55	60	65	70	75	80	85	90	95	100	105
24						New people							1				1				1				1					1
25						New hours								40	40	40	40	80	80	80	80	120	120	120	120	160	160	160	160	160
26						Deals closed new ppl F										2.5	2.5	2.5	2.5	5	5	5	5	7.5	7.5	7.5	7.5	10	10	10
27						Sum deals new ppl											2.5	5	7.5	10	15	20	25	30	37.5	45	52.5	60	70	80
28						Deals closed new ppl NF												0.347826087	0.347826087	0.347826087	0.347826087	0.6956521739	0.6956521739	0.6956521739	0.6956521739	1.043478261	1.043478261	1.043478261	1.043478261	1.391304348
29
30
31
32						Sum deals Not Focused						0.6956521739	1.391304348	2.086956522	2.782608696	3.47826087	4.173913043	5.217391304	5.913043478	6.608695652	7.304347826	8.347826087	9.043478261	9.739130435	10.43478261	11.47826087	12.17391304	12.86956522	13.56521739	14.60869565
33						Sum deals Focused	0	0	0	5	10	15	20	25	30	35	42.5	50	57.5	65	75	85	95	105	117.5	130	142.5	155	170	185
34
35						Costs
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59