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 | Z | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Cyber Defense Matrix - Do not modify top matrix manually - update projects at the bottom | |||||||||||||||||||||||||
2 | ||||||||||||||||||||||||||
3 | Team1 | Identify | Protect | Detect | Respond | Recover | OpEx per asset class | CapEx per asset class | FTE per asset class | |||||||||||||||||
4 | Expense Type | OpEx | CapEx | FTEs | OpEx | CapEx | FTEs | OpEx | CapEx | FTEs | OpEx | CapEx | FTEs | OpEx | CapEx | FTEs | ||||||||||
5 | Devices | $299,000.00 | $30,600.00 | 0.864 | $0.00 | $0.00 | 0 | $499,000.00 | $54,600.00 | 1.464 | $502,000.00 | $54,800.00 | 1.472 | $0.00 | $0.00 | 0 | $1,300,000.00 | $140,000.00 | 3.8 | |||||||
6 | Applications | $99,000.00 | $6,600.00 | 0.264 | $0.00 | $0.00 | 0 | $99,000.00 | $6,600.00 | 0.264 | $102,000.00 | $6,800.00 | 0.272 | $0.00 | $0.00 | 0 | $300,000.00 | $20,000.00 | 0.8 | |||||||
7 | Networks | $99,000.00 | $6,600.00 | 0.264 | $0.00 | $0.00 | 0 | $99,000.00 | $6,600.00 | 0.264 | $102,000.00 | $6,800.00 | 0.272 | $0.00 | $0.00 | 0 | $300,000.00 | $20,000.00 | 0.8 | |||||||
8 | Data | $99,000.00 | $6,600.00 | 0.264 | $0.00 | $0.00 | 0 | $99,000.00 | $6,600.00 | 0.264 | $102,000.00 | $6,800.00 | 0.272 | $0.00 | $0.00 | 0 | $300,000.00 | $20,000.00 | 0.8 | |||||||
9 | Users | $99,000.00 | $6,600.00 | 0.264 | $100,000.00 | $50,000.00 | 5 | $99,000.00 | $6,600.00 | 0.264 | $102,000.00 | $6,800.00 | 0.272 | $0.00 | $0.00 | 0 | $400,000.00 | $70,000.00 | 5.8 | |||||||
10 | Sub-Totals by function | $695,000.00 | $57,000.00 | 1.92 | $100,000.00 | $50,000.00 | 5 | $895,000.00 | $81,000.00 | 2.52 | $910,000.00 | $82,000.00 | 2.56 | $0.00 | $0.00 | 0 | $2,600,000.00 | $270,000.00 | 12 | |||||||
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 Cost | Split by Asset Classes | Split by Function | |||||||||||||||||||||||
25 | OPEX | CAPEX | FTEs | |||||||||||||||||||||||
26 | $1,000,000.00 | $120,000.00 | 3 | Devices | 100.00% | Identify | 20.00% | |||||||||||||||||||
27 | Applications | 0.00% | Protect | 0.00% | ||||||||||||||||||||||
28 | Networks | 0.00% | Detect | 40.00% | ||||||||||||||||||||||
29 | Data | 0.00% | Respond | 40.00% | ||||||||||||||||||||||
30 | Users | 0.00% | Recover | 0.00% | ||||||||||||||||||||||
31 | 100.00% | 100.00% | ||||||||||||||||||||||||
32 | ||||||||||||||||||||||||||
33 | Program1 | Identify | Protect | Detect | Respond | Recover | ||||||||||||||||||||
34 | ThreatButtEDR | OpEx | CapEx | FTEs | OpEx | CapEx | FTEs | OpEx | CapEx | FTEs | OpEx | CapEx | FTEs | OpEx | CapEx | FTEs | ||||||||||
35 | Devices | $200,000.00 | $24,000.00 | 0.6 | $0.00 | $0.00 | 0 | $400,000.00 | $48,000.00 | 1.2 | $400,000.00 | $48,000.00 | 1.2 | $0.00 | $0.00 | 0 | ||||||||||
36 | Applications | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | ||||||||||
37 | Networks | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | ||||||||||
38 | Data | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | ||||||||||
39 | Users | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | ||||||||||
40 | Sub-Totals | $200,000.00 | $24,000.00 | 0.6 | $0.00 | $0.00 | 0 | $400,000.00 | $48,000.00 | 1.2 | $400,000.00 | $48,000.00 | 1.2 | $0.00 | $0.00 | 0 | ||||||||||
41 | ||||||||||||||||||||||||||
42 | Calculation Checks | Red if mismatch | ||||||||||||||||||||||||
43 | Total OPEX | $1,000,000.00 | ||||||||||||||||||||||||
44 | Total CAPEX | $120,000.00 | ||||||||||||||||||||||||
45 | Total FTEs | 3 | ||||||||||||||||||||||||
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 Cost | Split by Asset Classes | Split by Function | |||||||||||||||||||||||
54 | OPEX | CAPEX | FTEs | |||||||||||||||||||||||
55 | $100,000.00 | $50,000.00 | 5 | Devices | 0.00% | Identify | 0.00% | |||||||||||||||||||
56 | Applications | 0.00% | Protect | 100.00% | ||||||||||||||||||||||
57 | Networks | 0.00% | Detect | 0.00% | ||||||||||||||||||||||
58 | Data | 0.00% | Respond | 0.00% | ||||||||||||||||||||||
59 | Users | 100.00% | Recover | 0.00% | ||||||||||||||||||||||
60 | 100.00% | 100.00% | ||||||||||||||||||||||||
61 | ||||||||||||||||||||||||||
62 | Program2 | Identify | Protect | Detect | Respond | Recover | ||||||||||||||||||||
63 | DLP | OpEx | CapEx | FTEs | OpEx | CapEx | FTEs | OpEx | CapEx | FTEs | OpEx | CapEx | FTEs | OpEx | CapEx | FTEs | ||||||||||
64 | Devices | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | ||||||||||
65 | Applications | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | ||||||||||
66 | Networks | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | ||||||||||
67 | Data | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | ||||||||||
68 | Users | $0.00 | $0.00 | 0 | $100,000.00 | $50,000.00 | 5 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | ||||||||||
69 | Sub-Totals | $0.00 | $0.00 | 0 | $100,000.00 | $50,000.00 | 5 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | ||||||||||
70 | ||||||||||||||||||||||||||
71 | Calculation Checks | Red if mismatch | ||||||||||||||||||||||||
72 | Total OPEX | $100,000.00 | ||||||||||||||||||||||||
73 | Total CAPEX | $50,000.00 | ||||||||||||||||||||||||
74 | Total FTEs | 5 | ||||||||||||||||||||||||
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 Cost | Split by Asset Classes | Split by Function | |||||||||||||||||||||||
83 | OPEX | CAPEX | FTEs | |||||||||||||||||||||||
84 | $1,500,000.00 | $100,000.00 | 4 | Devices | 20.00% | Identify | 33.00% | |||||||||||||||||||
85 | Applications | 20.00% | Protect | 0.00% | ||||||||||||||||||||||
86 | Networks | 20.00% | Detect | 33.00% | ||||||||||||||||||||||
87 | Data | 20.00% | Respond | 34.00% | ||||||||||||||||||||||
88 | Users | 20.00% | Recover | 0.00% | ||||||||||||||||||||||
89 | 100.00% | 100.00% | ||||||||||||||||||||||||
90 | ||||||||||||||||||||||||||
91 | Program3 | Identify | Protect | Detect | Respond | Recover | ||||||||||||||||||||
92 | MFA | OpEx | CapEx | FTEs | OpEx | CapEx | FTEs | OpEx | CapEx | FTEs | OpEx | CapEx | FTEs | OpEx | CapEx | FTEs | ||||||||||
93 | Devices | $99,000.00 | $6,600.00 | 0.264 | $0.00 | $0.00 | 0 | $99,000.00 | $6,600.00 | 0.264 | $102,000.00 | $6,800.00 | 0.272 | $0.00 | $0.00 | 0 | ||||||||||
94 | Applications | $99,000.00 | $6,600.00 | 0.264 | $0.00 | $0.00 | 0 | $99,000.00 | $6,600.00 | 0.264 | $102,000.00 | $6,800.00 | 0.272 | $0.00 | $0.00 | 0 | ||||||||||
95 | Networks | $99,000.00 | $6,600.00 | 0.264 | $0.00 | $0.00 | 0 | $99,000.00 | $6,600.00 | 0.264 | $102,000.00 | $6,800.00 | 0.272 | $0.00 | $0.00 | 0 | ||||||||||
96 | Data | $99,000.00 | $6,600.00 | 0.264 | $0.00 | $0.00 | 0 | $99,000.00 | $6,600.00 | 0.264 | $102,000.00 | $6,800.00 | 0.272 | $0.00 | $0.00 | 0 | ||||||||||
97 | Users | $99,000.00 | $6,600.00 | 0.264 | $0.00 | $0.00 | 0 | $99,000.00 | $6,600.00 | 0.264 | $102,000.00 | $6,800.00 | 0.272 | $0.00 | $0.00 | 0 | ||||||||||
98 | Sub-Totals | $495,000.00 | $33,000.00 | 1.32 | $0.00 | $0.00 | 0 | $495,000.00 | $33,000.00 | 1.32 | $510,000.00 | $34,000.00 | 1.36 | $0.00 | $0.00 | 0 | ||||||||||
99 | ||||||||||||||||||||||||||
100 | Calculation Checks | Red if mismatch |