Key Activities Gap Analysis - Sample Spreadsheet (for external use).xlsx

	A	B	C	D	E	F	N	O	P	Q
1
2		CURRENT STATE		FUTURE STATE			Annual Team Analysis
3		Hours Worked / Week	50	Hours Worked / Week	50	GAP HOURS / Week		Current State	Future State	Increase in Hours on Key Activities
4	SC Time Usage	100%	50	100%	50	0	# of SCs	40	40
5	* Discovery	5%	2.5	10%	5	2.5	Key Activity Hours / Year	60,320	82160	21,840
6	* Improving Product Knowledge	4%	2	4%	2	0	Other Activities / Year	43,680	21840	-21,840
7	* Planning and Architecting	12%	6	15%	7.5	1.5
8	* POCs (setup and maintain)	10%	5	13%	6.5	1.5
9	* RFPs	7%	3.5	7%	3.5	0
10	* Strategic Consulting Calls	5%	2.5	10%	5	2.5
11	* Technical Demos (Prep & Delivery)	15%	7.5	20%	10	2.5
12	Repeititve Micro Intro Demos	8%	4	2%	1	-3			INCREASE IN KEY ACTIVITIES
13	Repetitive Standard Demos	10%	5	2%	1	-4			36%
14	Repetitive Closing and FAQ Demos (Standard Demo)	8%	4	2%	1	-3
15	Customer Support	6%	3	5%	2.5	-0.5
16	Training & Mentoring	5%	2.5	5%	2.5	0
17	Troubleshooting	5%	2.5	5%	2.5	0
18
19		CURRENT STATE		FUTURE STATE
20		Hours Worked / Week	50	Hours Worked / Week	50	GAP HOURS / Week
21	SC Time Usage					0
22	Key Activities	58%	29	79%	39.5	10.5
23	Other Activities	42%	21	21%	10.5	-10.5
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
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