QCon DevOps financial analysis

	A	B	C	D
1	Common Project Assumptions
2	Name	Amount	Units	Notes
3	Team size	8	developers/testers/ops
4	Developer compensation	$125,000.00	US dollars	average developer/tester/ops compensation for the team
5	Project cost	$1,000,000.00	per year
6
7	Current productivity assumptions
8	Developer productivity	5	hours per day
9	Developer working days	240	days per year
10
11	Environment provisioning
12	Current environment provisioning assumptions
13	Dev environment justification paperwork	8	hours
14	Dev environment manual specification process	80	hours
15	Dev environment modifications post spec	12	hours
16	Dev environment provisioning execution by ops	100	hours
17
18	Test environment justification paperwork	16	hours
19	Test environment manual specification process	16	hours
20	Test environment modifications post spec	32	hours
21	Test environment ops configuration assistance	16	hours
22	Test environment meetings	8	hours
23	Test environment provisioning execution by ops	120	hours
24	Lost developer productivity due to delays in test configs	32	hours
25
26	Residual developer lost productivity due to time splitting	32	hours
27
28	Total lost developer hours/deploy due to current environment provisioning	472	hours
29
30
31	Future state environment provisioning assumptions
32	Dev environment justification paperwork	0	hours
33	Dev environment automated specification process	0	hours	Assumption: base configuration scripts for standard environments
34	Dev environment automated configuration boot up	0.5	hours
35
36	Test environment justification paperwork	2	hours
37	Test environment manual specification process	0	hours
38	Test environment modifications post spec	0	hours
39	Test environment ops configuration assistance	0	hours
40	Test environment meetings	4	hours
41	Lost developer productivity due to delays in test configs	0	hours
42
43	Residual developer lost productivity due to time splitting	0	hours
44
45	Total lost developer hours/deploy due to current environment provisioning	6.5	hours
46
47
48	Calculations
49	Developer cost per hour based on salary	$104.17
50	Cost for current environment provisioning	$49,166.67
51	Cost for future environment provisioning	$677.08
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