IC-IT-Prioritization-Matrix-Template_Google_sheet

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	S	T	U
1	IT PRIORITIZATION MATRIX TEMPLATE

2	Enter scores in the chart below. Use whole numbers zero through five (0–5) to calculate the Requirements Prioritization Score.			CRITERIA WEIGHT Total weight values should equal 100.								TOTAL WEIGHT (100)
3				30	15	15	30	0	0	0	10	100	CONFLICT?
4	REQUIREMENT	PROJECT LEAD	DETAILS	BUSINESS VALUE ADDED	BUSINESS RISK	IMPLEMENTATION CHALLENGES	RESOURCES REQUIRED	COMPLIANCE	RELATIONSHIP TO REQUIREMENTS	URGENCY	COMPETITIVE EDGE	TOTAL SCORE	YES/NO				CRITERIA SCORE	SCORE VALUE	CONFLICT KEY
5	Update user information security	Kyle	Reconfigure encryption	2	3	2	3				2	49	NO				0	0%	YES
6	Operating system upgrade for all office staff	Anthony	Upgrade from last years model	2	1	1	2				1	32	YES				1	20%	NO
7	Redesign app UI	Mariana	To include in-app purchasing	5	4	5	4				5	91	NO				2	40%
8												0					3	60%
9												0					4	80%
10												0					5	100%
11												0
12												0
13												0
14
15	PROJECT CALENDAR
16	PROJECT DESCRIPTION	TEAM MEMBER/TITLE	CURRENT/PROPOSED	JAN	FEB	MAR	APR	MAY	JUNE	JULY	AUG	SEPT	OCT	NOV	DEC	JAN
17	Update user information security	Kyle	CURRENT
18	Update user information security	Software Security Developer	PROPOSED
19	Operating system upgrade for all office staff	Anthony	CURRENT
20	Operating system upgrade for all office staff	Office Tech Support	PROPOSED
21	Redesign app UI	Mariana	CURRENT
22	Redesign app UI	UX/UI Design	PROPOSED
23			CURRENT
24			PROPOSED
25			CURRENT
26			PROPOSED
27			CURRENT
28			PROPOSED
29
30	CLICK HERE TO CREATE IN SMARTSHEET
31
32
33
34
35
36
37
38
39
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