Henry Innis Economic Value XXX - Google Sheets

JavaScript isn't enabled in your browser, so this file can't be opened. Enable and reload.

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y
1	NB: Billable Work Only	Work won (directly contributed to win/client relationship)
2		Yearly Cost	$70,000.00
3		Hourly Rate (Strategist)	165
4		Hourly Rate (Strategist)	165
5		Total capacity	1800
6
7	Date	Statement Of Work	Hours (Strategy)	Capacity (Year)	Hours (Business)	Value to Strategy	Value To Business
8
9	1/7/2015	XXX CMI	456	25.33%	456	$75,240.00	$4,700.00
10	1/10/2015	XXX Subscriber Acquisition Program	38	2.11%	120	$6,270.00	$19,800.00
11	1/6/2016	XXX Program	33	1.83%	71	$5,445.00	$11,715.00
12	1/6/2016	XXX Crisis Management	26	1.44%	19	$4,290.00	$3,135.00
13	1/6/2016	XXX Phase One	140	7.78%	268	$23,100.00	$44,220.00
14
15
16		Total strategy hours	693			$2,465.10
17		Total value to strategy	$114,345.00			$4,347.75
18		Total capacity on projects/campaigns	38.50%			$6,812.85
19						$61,812.85
20		Total work won	$83,570.00
21		Total as (%) of salary	119.39%					Total won output			Project work (not won)
22								Total Capacity	1800		Total Hours	546
23								Total Retained Capacity	25.33%		Value To Biz	$90,090.00
24								Total Project Hours	38.50%		Capacity	30.33%
25								Capacity Used	63.83%
26											Total biz value
27								Total direct output			Billable Hours	2241
28								Business Value (retained)	$68,400.00		Value To Biz	$369,765
29								Business Value (work won)	$114,345.00		Capacity	124.50%
30								Value multiple	2.61		Multiple	5.28
31								Total attributed value	$182,745.00
32
33								Total effort output
34		Retainers						Total capacity used	94.17%
35		Monthly Costs	$6,250.00					Value multiple	3.86
36		Strategist	160					Total business value	$270,105.00
37		Hourly Rate (Strategist)	180
38		Total capacity	150
39
40		Retainer	Hours	% Capacity	Business Value Per Month	Multiple on cost	Previous Value	Increase (%)
41		XXX	16	10.67%	$2,400.00	0.38	N/A
42		XXX	6	4.00%	$900.00	0.14	N/A
43		XXX	10	6.67%	$1,500.00	0.24	N/A
44		XXX	6	4.00%	$900.00	0.14	N/A
45
46
47
48		Total monthly retained capacity	25.33%
49		Total monthly labour costs	$6,250.00
50
51		Total monthly retained value	$5,700.00
52		Total monthly ROI multiple	0.91
53
54
55
56
57
58		Effort (one off, haven't won the work)
59		Yearly Cost	$70,000.00
60		Hourly Rate (Strategist)	160
61		Hourly Rate (Strategist)	180
62		Total capacity	1800
63
64		Project	Hours	Capacity (Year)	Hours (Business)	Value to Strategy	City
65	XX	XXX	250	13.89%	666	$37,500.00	Sydney
66	XX	XXX	50	2.78%	300	$7,500.00	Sydney
67		XXX	30	1.67%	TBC	$4,500.00	Sydney
68		XXX	60	3.33%	TBC	$9,000.00	Sydney
69		XXX	40	2.22%	TBC	$6,000.00	Sydney
70		FY17 Pack	20	1.11%	TBC	$3,000.00	Sydney
71		XXX	50	2.78%	TBC	$7,500.00	Sydney
72	XX	Search Campaign	12	0.67%	TBC	$1,800.00	Sydney
73	XX	Xero Campaign	34	1.89%	TBC	$5,100.00	Sydney
74
75
76
77
78
79
80
81
82
83
84		Total strategy hours	546
85		Total value to strategy	$87,360.00
86		Total capacity on projects/campaigns	30.33%
87
88
89
90		TOTAL VALUE OF PROJECTS WORKED ON
91		Account	Previous YoY Comparison
92
93
94
95
96
97
98
99
100