SupConf Basic Headcount Model
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
2
KeyCalculations
3
Tickets1300actual valueSalaries
4
Tickets per agent325Agents Req54.4$215,000
5
Agents per manager8Specialists Req10.6$52,000
6
Agents per specialist10Managers Req10.9375$75,000
7
Mgr free time20%Total$342,000
8
Agent free time10%
9
10
SalariesTicket Change30%
11
Agent$43,000Total Tickets1690
12
Specialist$52,000Agents Req65.8$258,000
13
Manager$75,000Specialists Req10.7$52,000
14
Managers Req21.09375$150,000
15
Total$460,000
16
17
Total Cost Change
-$118,000
18
19
*This model is only as accurate as the assumptions made in the key.
20
21
22
23
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
Loading...
 
 
 
Edit Locked Sample Model
Sample Model
 
 
Main menu