Calc's for 'F' at HVAC in a Hurry

	B	C	D	F	G	H	I	J	K	L	M	N	O	P	Q
1
2	Example Calc's for 'F' at HVAC in a Hurry
3	These calculations support a blog post, which you can find here:
4	THE ONE METRIC FOR INNOVATION ACCOUNTING (AND HOW TO USE IT)
5
6	Cost to Release a Successful Feature: F
7	Cost/Successful Story Point in March	$3,851	This is a measurement just for the month of March- per story point
8
9	Team Cost: c_$			Team Cost: g
10	Item	Value	Notes	Item	Value	Notes
11	Average Comp.	$132,000	annual, blended across team of ten: 7 dev's, 1 designer, 1 test engineer, 1 embedded SRE (DevOps)	GCP	$2,100	this is low now because of early release; includes dev and test instances
12	Team Size	10		Firebase	$200
13	Loading	30%	for benefits, taxes, individuals' IT equipment (computer, etc.)	CI System	$350	for benefits, taxes, individuals' IT equipment (computer, etc.)
14				Misc. Subscriptions	$700
15	TEAM COST: c$	$143,000	/month	TEAM COST: g	$3,350	/month
16
17	Release Content: f_e & r_f			Portion of Successful Features s_d
18	Item	Value	Notes	Item	Value	Notes
19	r_f	18%	Estimate of dev. time spent on bug fixes and unplanned test and deploy work	Actual Story Points (Mar.)	84	This is all our story points for March
20	actual story points	84	This is all our story points for March	Sucessful Features, Post Testing	38	These are the story points for the features where our target DV exceeded our 'line in the sand'
21	'true' f_e	102.4	f_e with an rf of 0%: Velocity with perfect pipeline; just for comparison purposes- not in calc.	PORTION SUCCESSFUL	45.24%
22	RELEASE CONTENT	84	story points/month
23	COST/STORY POINT	$1,742	cost/story point/month
24
25
26	copyright COWAN+						Value for 'F' Varying c_$ and s_d
27									Average Team Comp. (Unloaded)
28									$102,000	$112,000	$122,000	$132,000	$142,000	$152,000	$162,000
29						Portion Successful		10.2%	$13,236	$14,495	$15,755	$17,014	$18,274	$19,533	$20,793
30								15.2%	$8,893	$9,740	$10,586	$11,432	$12,278	$13,125	$13,971
31								20.2%	$6,696	$7,334	$7,971	$8,608	$9,245	$9,882	$10,520
32								25.2%	$5,370	$5,881	$6,392	$6,903	$7,414	$7,925	$8,436
33								30.2%	$4,482	$4,908	$5,335	$5,761	$6,188	$6,614	$7,041
34								35.2%	$3,846	$4,212	$4,578	$4,944	$5,310	$5,676	$6,042
35								40.2%	$3,368	$3,689	$4,009	$4,330	$4,650	$4,971	$5,291
36								45.2%	$2,996	$3,281	$3,566	$3,851	$4,136	$4,421	$4,706
37								50.2%	$2,698	$2,954	$3,211	$3,468	$3,725	$3,981	$4,238
38								55.2%	$2,454	$2,687	$2,921	$3,154	$3,387	$3,621	$3,854
39								60.2%	$2,250	$2,464	$2,678	$2,892	$3,106	$3,320	$3,534
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