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
Tickets1000actual valueSalaries
4
Tickets per agent250Agents Req54.0$225,000
5
Agents per manager6
6
Managers Req21$170,000
7
Mgr free time50%Total$395,000
8
Agent free time10%
9
10
SalariesTicket Change46%
11
Agent$45,000Total Tickets1460
12
Agents Req65.0$270,000
13
Manager$85,000
14
Managers Req22$170,000
15
Total$440,000
16
17
Total Cost Change
-$45,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...
 
 
 
Sample Model
Edit Locked Sample Model
 
 
Main menu