Google Sheet Risk Register Template 24_27 - Procurement Approach Risk Register Template.xlsx

	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	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM
1	Risk Register
2	[Procurement Approach]
3	Project:		[Name]
4	Project Manager:		[Name]
5	Development Stage:		[Decision Point]
6

7	Risk Information					Risk Analysis																							Response			Risk Tracking						Notes
8	Risk Number (1)	Risk Category (2)	Risk Topic (3)	Impact Phase (4)	Risk Description (5)	Consequence of Risk (6)	RAG Analysis											Expected Value Analysis									Monte Carlo Simulation (10c)		Risk Response Method (12)	Risk Allocation (13)	Risk Allocation Notes (14)	Monitoring and Control (14)						Risk Closure Notes (15)	Lessons Learned/Contract Notes (16)
9							Probability Range (7)	Cost Impact (8a)					Schedule Impact (8b)					Probability (9)	Cost Impact (10a)				Schedule Impact (10b)				Monte Carlo Simulation (10c)					Risk Owner	Response Action/ Strategy to Mitigate Risk	Planned Mitigation Cost ($)	Risk Review Dates	Status and Review Comments	Is Risk on Critical Path?
10							Probability Range (7)	Consequence	Probability Rank	Consequence Rank	Impact Rank	Risk Impact	Consequence	Probability Rank	Consequence Rank	Impact Rank	Risk Impact	Probability (9)	Min ($000)	Most Likely ($000)	Max ($000)	Risk Value ($000)	Min (Mos.)	Most Likely (Mos.)	Max (Mos.)	Risk Value (Mos.)	Distribution Type	Modeling Notes				Risk Owner	Response Action/ Strategy to Mitigate Risk	Planned Mitigation Cost ($)	Risk Review Dates	Status and Review Comments	Is Risk on Critical Path?
11	1.01	Planning and Approvals	Procurement Process	Development					0	0	0	0		0	0	0	0					0				0.0
12	1.02	Planning and Approvals	Permitting	Development					0	0	0	0		0	0	0	0					0				0.0
13	1.03	Planning and Approvals	NEPA Approvals	Development					0	0	0	0		0	0	0	0					0				0.0
14	1.04	Planning and Approvals	NEPA Approvals	Development					0	0	0	0		0	0	0	0					0				0.0
15	1.05	Planning and Approvals	Design Approvals	Development					0	0	0	0		0	0	0	0					0				0.0
16	1.06	Planning and Approvals	Design Approvals	Development					0	0	0	0		0	0	0	0					0				0.0
17	1.07	Planning and Approvals	Historic / Cultural Resources	Construction					0	0	0	0		0	0	0	0					0				0.0
18	2.01	Legislative / Policy	Legislative Change	Development					0	0	0	0		0	0	0	0					0				0.0
19	2.02	Legislative / Policy	Regional / Local Support	Development					0	0	0	0		0	0	0	0					0				0.0
20	2.03	Legislative / Policy	Political / Policy Change	Development					0	0	0	0		0	0	0	0					0				0.0
21	2.04	Legislative / Policy	Legal Challenge	Development					0	0	0	0		0	0	0	0					0				0.0
22	3.01	Commercial / Procurement	Market Interest	Development					0	0	0	0		0	0	0	0					0				0.0
23	3.02	Commercial / Procurement	Bonding	Development					0	0	0	0		0	0	0	0					0				0.0
24	3.03	Commercial / Procurement	Insurance	Development					0	0	0	0		0	0	0	0					0				0.0
25	3.04	Commercial / Procurement	Contract Failure / Dispute	Implementation					0	0	0	0		0	0	0	0					0				0.0
26	3.05	Commercial / Procurement	Construction Inflation	Construction					0	0	0	0		0	0	0	0					0				0.0
27	3.06	Commercial / Procurement	Adverse Weather Conditions	Implementation					0	0	0	0		0	0	0	0					0				0.0
28	4.01	Funding/ Finance	Cost / Availability of Finance	Development					0	0	0	0		0	0	0	0					0				0.0
29	4.02	Funding/ Finance	Financing	Development					0	0	0	0		0	0	0	0					0				0.0
30	4.03	Funding/ Finance	Public Funding	Development					0	0	0	0		0	0	0	0					0				0.0
31	4.04	Funding/ Finance	Financial Model	Development					0	0	0	0		0	0	0	0					0				0.0
32	5.01	Environmental	Hazmat Discovered	Implementation					0	0	0	0		0	0	0	0					0				0.0
33	5.02	Environmental	Hazmat Introduced	Implementation					0	0	0	0		0	0	0	0					0				0.0
34	5.03	Environmental	Endangered Species	Implementation					0	0	0	0		0	0	0	0					0				0.0
35	6.01	ROW/ Utilities	Unknown Utilities	Implementation					0	0	0	0		0	0	0	0					0				0.0
36	6.02	ROW/ Utilities	Uncooperative Utility Companies	Implementation					0	0	0	0		0	0	0	0					0				0.0
37	6.03	ROW/ Utilities	ROW Acquisition	Development					0	0	0	0		0	0	0	0					0				0.0
38	6.04	ROW/ Utilities	ROW Acquisition	Development					0	0	0	0		0	0	0	0					0				0.0
39	6.05	ROW/ Utilities	ROW Acquisition	Implementation					0	0	0	0		0	0	0	0					0				0.0
40	7.01	Design	Design Criteria / Technical Provisions	Development					0	0	0	0		0	0	0	0					0				0.0
41	7.02	Design	Project Scope	Implementation					0	0	0	0		0	0	0	0					0				0.0
42	7.03	Design	Project Requirements	Implementation					0	0	0	0		0	0	0	0					0				0.0
43	7.04	Design	Reference Information Data	Implementation					0	0	0	0		0	0	0	0					0				0.0
44	7.05	Design	NS Railroad Crossing	Implementation					0	0	0	0		0	0	0	0					0				0.0
45	7.06	Design	Frontage Roads	Implementation					0	0	0	0		0	0	0	0					0				0.0
46	7.07	Design	Security	Implementation					0	0	0	0		0	0	0	0					0				0.0
47	7.08	Design	Drainage	Implementation					0	0	0	0		0	0	0	0					0				0.0
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66						Risk Allocation Options
67						Agency
68						Contractor
69						Concessionaire
70						Shared
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