Outsourcing or Hiring - A spreadsheet for modelling an answer

	A	B	D	E	F	G
1	Key figures to input		Results
2
3	Employee	Fill in cells in yellow	Monthly cost ($)	Contractor	Employee	Who to pick
4	Hours you expect your employee to work in a working day (Working Hours)	8
5	Hours in a working day you expect your employee to devote to producing the same output as you'd expect from your contractor (Output Capacity)	6	Mixed resourcing	$24,638	$31,462	Contractor
6	Output Capacity in a year	1314	Most senior contractor provides all services	$54,750	$31,462	Employee
7	Output Capacity in a month	110	Mid-level contractor provides all services	$27,375	$31,462	Contractor
8			Entry-level contractor provides all services	$10,950	$31,462	Contractor
9	Salary - headline rate	$20,000
10	Total employee costs - yearly	$377,540
11	Total employee costs - monthly	$31,462	Monthly Output Capacity (hours)	Contractor	Employee	Who to pick
12
13	Contractor or retainer		Mixed resourcing	207.65	110	Contractor
14	Senior - rate per hour	$500	Most senior contractor provides all services	62.92	110	Employee
15	Mid-level - rate per hour	$250	Mid-level contractor provides all services	125.85	110	Contractor
16	Entry level - rate per hour	$100	Entry-level contractor provides all services	314.62	110	Contractor
17
18	Mixture of resourcing
19	Senior - percentage of total work done by senior contractor	20%
20	Mid-level - percentage of total work done by mid-level contractor	30%
21	Entry level - percentage of total work done by entry level contractor	50%
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