Worksheet for content strategy business case
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRST
1
en français:
2
https://docs.google.com/spreadsheets/d/1qfWk3qejVO8JeCmvl3AOPblBT7LkopAC3QpgbTOIbD0/edit#gid=2048247025
3
4
Ready to start your content strategy work? Contact info@scriptorium.com
5
www.scriptorium.com
6
7
Reuse
8
Total number of pages/topics10000Assumptions
9
Current reuse, percentage10%Cost of tech comm (per hour)$50.00
10
Estimated reuse with new strategy25%Hours required to write one topic2
11
Increase in pages/topics reused1,500
12
13
Cost per topic$100.00
14
Cost savings from reuse$150,000.00
15
16
Localization
17
Total number of pages/topics10000Assumptions
18
Number of target languages12Words per page250
19
Current localization cost$3,000,000.00Percentage of localization cost associated with formatting25%
20
Localization with automated formatting$2,250,000.00Cost of localization, per word$0.10
21
Cost savings from localization$750,000.00
22
23
Automated formatting
24
Number of authors10Assumptions
25
Percent of author time spent on formatting40.00%Percentage of author time spent on formatting20%
26
Hours spent on formatting, per author, per year680Working hours, per year1700
27
Cost of formatting, per author, per year$34,000.00
28
29
Cost of formatting time, total, per year$340,000.00
30
31
Increasing velocity
32
Localization wait time after source language completion, weeks12Assumptions
33
New localization wait time, weeks6Time value of money5.00%
34
Product revenue in localized markets, yearly$50,000,000.00
35
Increased revenue, year 1$5,769,230.77
36
37
Revenue from velocity increase$288,461.54
38
39
TOTAL$1,528,461.54
40
41
Costs
42
43
Number of authors10Assumptions
44
Content management system$0.00Authoring tool, per seat$500.00
45
Authoring tools$5,000.00Publishing tool$8,000.00
46
Publishing tools$8,000.00Total number of pages/topics$10,000.00
47
Other tools$1,300.00Cost of migration, per page/topic$10.00
48
Tool configuration/integration$0.00Training required, days5
49
Content migration$100,000.00Cost per training day$2,000.00
50
Training$8,333.33Maximum class size12
51
Ongoing support, %age of initial cost10.00%
52
Year 1 cost$122,633.33
53
Year 2+ cost$12,263.33
54
55
56
Year 1 total ROI$1,405,828.21
57
Year 2 total ROI$1,516,198.21
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...
Main menu