ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Cyber Defense Matrix - Do not modify top matrix manually - update projects at the bottom
2
3
Team1IdentifyProtectDetectRespondRecoverOpEx per asset classCapEx per asset classFTE per asset class
4
Expense TypeOpExCapExFTEsOpExCapExFTEsOpExCapExFTEsOpExCapExFTEsOpExCapExFTEs
5
Devices$299,000.00$30,600.000.864$0.00$0.000$499,000.00$54,600.001.464$502,000.00$54,800.001.472$0.00$0.000$1,300,000.00$140,000.003.8
6
Applications$99,000.00$6,600.000.264$0.00$0.000$99,000.00$6,600.000.264$102,000.00$6,800.000.272$0.00$0.000$300,000.00$20,000.000.8
7
Networks$99,000.00$6,600.000.264$0.00$0.000$99,000.00$6,600.000.264$102,000.00$6,800.000.272$0.00$0.000$300,000.00$20,000.000.8
8
Data$99,000.00$6,600.000.264$0.00$0.000$99,000.00$6,600.000.264$102,000.00$6,800.000.272$0.00$0.000$300,000.00$20,000.000.8
9
Users$99,000.00$6,600.000.264$100,000.00$50,000.005$99,000.00$6,600.000.264$102,000.00$6,800.000.272$0.00$0.000$400,000.00$70,000.005.8
10
Sub-Totals by function$695,000.00$57,000.001.92$100,000.00$50,000.005$895,000.00$81,000.002.52$910,000.00$82,000.002.56$0.00$0.000$2,600,000.00$270,000.0012
11
12
13
Instructions
14
15
Costs are in USD. FTEs in number of FTEs (Fractions are OK)
16
Heatmap represents biggest expense areas,biggest FTE involvement areas, and the same for totals. As it is a heat map, RED just means more
17
One tab per team, division or group.
18
Make sure the Aggregate tab takes into account additional tabs if you add them.
19
Do not touch the top table in the tabs, enter projects below, and they will get populated.
20
Enter costs on the right, populate Function and Asset Type Splits
21
22
23
Program - Project or Process 1
24
Program Estimated CostSplit by Asset ClassesSplit by Function
25
OPEXCAPEXFTEs
26
$1,000,000.00$120,000.003Devices100.00%Identify20.00%
27
Applications0.00%Protect0.00%
28
Networks0.00%Detect40.00%
29
Data0.00%Respond40.00%
30
Users0.00%Recover0.00%
31
100.00%100.00%
32
33
Program1IdentifyProtectDetectRespondRecover
34
ThreatButtEDR
OpExCapExFTEsOpExCapExFTEsOpExCapExFTEsOpExCapExFTEsOpExCapExFTEs
35
Devices$200,000.00$24,000.000.6$0.00$0.000$400,000.00$48,000.001.2$400,000.00$48,000.001.2$0.00$0.000
36
Applications$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000
37
Networks$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000
38
Data$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000
39
Users$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000
40
Sub-Totals$200,000.00$24,000.000.6$0.00$0.000$400,000.00$48,000.001.2$400,000.00$48,000.001.2$0.00$0.000
41
42
Calculation Checks
Red if mismatch
43
Total OPEX$1,000,000.00
44
Total CAPEX$120,000.00
45
Total FTEs3
46
47
These should match up - any mismatch indicates that splits are not complete up to 100%, or that something else in the table is broken or missing.
48
49
50
51
52
User Awareness
53
Program Estimated CostSplit by Asset ClassesSplit by Function
54
OPEXCAPEXFTEs
55
$100,000.00$50,000.005Devices0.00%Identify0.00%
56
Applications0.00%Protect100.00%
57
Networks0.00%Detect0.00%
58
Data0.00%Respond0.00%
59
Users100.00%Recover0.00%
60
100.00%100.00%
61
62
Program2IdentifyProtectDetectRespondRecover
63
DLPOpExCapExFTEsOpExCapExFTEsOpExCapExFTEsOpExCapExFTEsOpExCapExFTEs
64
Devices$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000
65
Applications$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000
66
Networks$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000
67
Data$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000$0.00$0.000
68
Users$0.00$0.000$100,000.00$50,000.005$0.00$0.000$0.00$0.000$0.00$0.000
69
Sub-Totals$0.00$0.000$100,000.00$50,000.005$0.00$0.000$0.00$0.000$0.00$0.000
70
71
Calculation Checks
Red if mismatch
72
Total OPEX$100,000.00
73
Total CAPEX$50,000.00
74
Total FTEs5
75
76
These should match up - any mismatch indicates that splits are not complete up to 100%, or that something else in the table is broken or missing.
77
78
79
80
81
Logging and monitoring
82
Program Estimated CostSplit by Asset ClassesSplit by Function
83
OPEXCAPEXFTEs
84
$1,500,000.00$100,000.004Devices20.00%Identify33.00%
85
Applications20.00%Protect0.00%
86
Networks20.00%Detect33.00%
87
Data20.00%Respond34.00%
88
Users20.00%Recover0.00%
89
100.00%100.00%
90
91
Program3IdentifyProtectDetectRespondRecover
92
MFAOpExCapExFTEsOpExCapExFTEsOpExCapExFTEsOpExCapExFTEsOpExCapExFTEs
93
Devices$99,000.00$6,600.000.264$0.00$0.000$99,000.00$6,600.000.264$102,000.00$6,800.000.272$0.00$0.000
94
Applications$99,000.00$6,600.000.264$0.00$0.000$99,000.00$6,600.000.264$102,000.00$6,800.000.272$0.00$0.000
95
Networks$99,000.00$6,600.000.264$0.00$0.000$99,000.00$6,600.000.264$102,000.00$6,800.000.272$0.00$0.000
96
Data$99,000.00$6,600.000.264$0.00$0.000$99,000.00$6,600.000.264$102,000.00$6,800.000.272$0.00$0.000
97
Users$99,000.00$6,600.000.264$0.00$0.000$99,000.00$6,600.000.264$102,000.00$6,800.000.272$0.00$0.000
98
Sub-Totals$495,000.00$33,000.001.32$0.00$0.000$495,000.00$33,000.001.32$510,000.00$34,000.001.36$0.00$0.000
99
100
Calculation Checks
Red if mismatch