URGENT: Executive overview

profileProjectManager
Risk_Analysis_Matrix_Workbook1.xls
Home>Business & Finance homework help>Management homework help>URGENT: Executive overview

Risk List

Risk Management Matrix
ID Risk Title Date Rank Phase Prob Impact Exp Effect Mitigation Trigger Event Contingency
What will happen if the risk occurs? What will you do to try to stop the risk? What do you think will trigger the event? What are your backup plans if the risk should occur?
1 Contract obligations inadequately fulfilled 5/5 1 Project Contract Approval 90% 10 9.00 Refusal of payments and refusal to acknowledge contract Transfer Refusal to sign contract, payment refusual Allow third party to intervene if both parties can't come to an agreement over payments. Insert check-off list into client contract and have them initial each obligation to be fulfilled
2 Lack of communication within constructed teams 5/5 1 Communication 85% 10 8.50 Project work delayed, misinterpretations of what's expected, unmeasured goals Mitigate Lack in quality of work produced, specifications/requirements not met, project activities doesn't begin or start as scheduled causing schedule delays Setup more frequent mandatory meetings on a weekly basis
3 Loss of data 5/5 1 Software Deployment 80% 10 8.00 Data may be potentially lost Mitigate File corruption, system viruses, power failures, malware malfunctioning Continuously backup data
4 Requirements clearly defined within the scope 5/5 1 Develop Scope Statement 80% 10 8.00 No rework is needed on the project, requirements met and project has the opportunity to complete on time Exploit Satisfied Stakeholders Schedule regular meeting with stakeholder, ensuring project needs are constantly met as the project began to progress
5 Poorly built database utilized to retrieve information 5/5 1 Software Design 77% 10 7.70 Data not properly aligned with table construction Mitigate Inaccurate information display to end user Ensure all schema diagrams are reviewed in depth to prevent misalignment of data and inaccurate data retrieval
6 Difficult time defining functionality & content requirements 1 Business Requirements Gathered 76% 10 7.60 Software not functioning to its full capacity, may not be user-friendly, rework required, developers unclear about results Mitigate Specifications not recorded accurately, developers delay coding process until issue resolved Schedule meetings with stakeholder to clarify functionality and content requirements
7 Inadequate privacy of data or data security 1 Database Security 75% 10 7.50 Information of client data is vulnerable and misused, company data exposed and compromised, lead to breach of data, lawsuit, compromise integrity of company Transfer System is hacked causing data breaches, configuration system not configured properly, malicious software downloaded Best to transfer risk to a third party vendor to establish layers of security levels on the server, and limit access to the main server
8 Goldplatting 1 Scope, Software Development 73% 10 7.30 Budget & schedule overruns Mitigate Deviation from the plan, with additional work added that's not reflected in the scope statement Only complete work within the scope of the project, additional work must be approved via change management process
9 Project Scope Creep (stakeholders want to make changes to the project that will impact schedule, cost, quality) 1 Scope 72% 10 7.20 Schedule delays, missed milestones, cost of project rises, quality of project has the potential to decrease Mitigate Client not satisfied, client want to add additional work to the current project Ensure stakeholders are engaged at all time via frequent meetings, obtain constant feedback through each phase of the project
10 Server, hardware, software crashes 1 Deploy Software 70% 10 7.00 Loss of data, delayed ability to utilize software Mitigate Considerable amounts of users are accessing site at same time, server space limited and can't support large amounts of data Install backup sever to rollback to the last point of time to restore the most recent information and data saved
12 Scripting Errors 1 Software Development 65% 7 4.55 Page not accessible, hinder student progress and working ability Mitigate User click a link, buttom, or icon and receive a loading error Reconfigure the system files
11 System difficult to navigate and not user-friendly 1 Train End Users 60% 6 3.60 End user frustrated during navigation, system may not be utilized Mitigate Decreased user interaction, software rarely accessed Devise plan to increase system usability
24 Finances are not properly tracked 1 Budgeting 60% 10 6.00 Budget overruns Mitigate Rising cost of project Keep budgeted change logs documentation up to date as changes occur causing increase in scope
23 Resource allocation not properly disbursed 1 Scheduling 50% 9 4.50 Inaccurate cost estimations Mitigate Over/under resource allocation Utilize resource leaveling to balance out resource allocation, or compensate for under allocation
25 Lagging productivity 2 Scheduling 50% 10 5.00 Missed milestones Mitigate Activities are not completed within designated dates assigned Weekly status meetings to address project progress
17 Site is sufficently user friendly 2 45% 7 3.15 More user profiles created Enhance Increased site traffic Ensure server have enough capacity to handle large amounts of data
16 Software completed earlier than scheduled 2 Schedule 40% 8 3.20 End user training can start sooner than expected Enhance Project ahead of schedule Obtain highly skilled human resources
21 Conflicting resources 2 Operational 40% 8 3.20 Decrease in resource allocation Mitigate Resources not available when needed Ensure resources are avaiable during specified timeframes
15 User upload inappropiate content 2 35% 7 2.45 Organizational policies violated Mitigate inapropiate pics/documents are uploading during profile setup, or test uploading Review any documents and pictures uploaded before posting, user should agree to all terms and conditions applicable
13 Software not loading at high speeds 3 Q&A Testing 30% 4 1.20 Information and images blurred, time consuming, system time out, Mitigate Not enough memory Increase storage to accommodate large files (graphics, data, and etc.)
22 Reduction in software functionality 3 Q&A Testing 30% 2 0.60 Quality lessened to stay within designated budget constraints Mitigate Technical issues increase, more incident tickets opened Discover areas where cost can be compensated to allow for better quality
20 Employee turnover 3 HR 25% 6 1.50 Cause schedule delays Mitigate Developers decide to leave Reassign resources, or hire more human resources to fill gap
14 Not esthetically appealing to users 3 20% 3 0.60 Decrease in number of user profiles created Accept User revert to previously documented processess Redesign prototype, use contingency reserves
18 Integragtion testing doesn't pose any errors 3 Q&A Testing 20% 2 0.40 User acceptance testing can start early Exploit Software pass user acceptance criteria, delivarbles accepted by owners User signs-off and software implemented as soon as possible
19 Unplanned changes to user environment 3 10% 3 0.30 Software unresponsive to changes Mitigate Compatibility issues arise Reference project constraints associated with the project
0.00
High Risk = 1 0.00
Medium Risk = 2 0.00
Low Risk = 3 0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
&LForm P-4&C&"Arial,Bold"&8 Project Manager: Name (816) XXX-XXXX
Release that this risk affects. This could be used for tracking risks specific to a cycle in a spiral development project for example.
Probability that this event will occur
Relative Impact of the event. 1-10
What adverse events can be expected if risk occurs?
What actions can we take to avoid having the risk event occur?
How do we know when the risk event has happened? What indications can we look for?
If the event occurs, what can we do to limit the effects of the risk?
The product of the Prob and Impact fields. Higher numbers are bad.
Date the risk was identified
Rank of this risk. A risk will have a higher rank if it has become more likely, has occurred, or if the team feels it is in some way more important than other risks. This is a subjective measure.

Risk Matrix

Risk Matrix
Impact 9-10 0 0 3 8 2
7-8 0 3 1 1 0
5-6 0 1 1 0 0 Zone Total: 14
3-4 2 1 0 0 0 Zone Total: 5
1-2 1 1 0 0 0 Zone Total: 6
1-20% 21-40% 41-60% 61-80% 81-100%
Probability
&LForm P-4&C&"Arial,Bold"&8 Project Manager: Name (816) XXX-XXXX

CriteriaSheet

Do NOT Edit this sheet. This sheet provides the formulas for the Matrix Sheet
1-2 3-4 5-6 7-8 9-10
1-20% 1-20% 1-20% 1-20% 1-20%
Prob Impact Prob Impact Result Prob Impact Prob Impact Result Prob Impact Prob Impact Result Prob Impact Prob Impact Result Prob Impact Prob Impact Result
1% 1 1% 2 1 1% 3 1% 4 2 1% 5 1% 6 0 1% 7 1% 8 0 1% 9 1% 10 0
2% 1 2% 2 2% 3 2% 4 2% 5 2% 6 2% 7 2% 8 2% 9 2% 10
3% 1 3% 2 3% 3 3% 4 3% 5 3% 6 3% 7 3% 8 3% 9 3% 10
4% 1 4% 2 4% 3 4% 4 4% 5 4% 6 4% 7 4% 8 4% 9 4% 10
5% 1 5% 2 5% 3 5% 4 5% 5 5% 6 5% 7 5% 8 5% 9 5% 10
6% 1 6% 2 6% 3 6% 4 6% 5 6% 6 6% 7 6% 8 6% 9 6% 10
7% 1 7% 2 7% 3 7% 4 7% 5 7% 6 7% 7 7% 8 7% 9 7% 10
8% 1 8% 2 8% 3 8% 4 8% 5 8% 6 8% 7 8% 8 8% 9 8% 10
9% 1 9% 2 9% 3 9% 4 9% 5 9% 6 9% 7 9% 8 9% 9 9% 10
10% 1 10% 2 10% 3 10% 4 10% 5 10% 6 10% 7 10% 8 10% 9 10% 10
11% 1 11% 2 11% 3 11% 4 11% 5 11% 6 11% 7 11% 8 11% 9 11% 10
12% 1 12% 2 12% 3 12% 4 12% 5 12% 6 12% 7 12% 8 12% 9 12% 10
13% 1 13% 2 13% 3 13% 4 13% 5 13% 6 13% 7 13% 8 13% 9 13% 10
14% 1 14% 2 14% 3 14% 4 14% 5 14% 6 14% 7 14% 8 14% 9 14% 10
15% 1 15% 2 15% 3 15% 4 15% 5 15% 6 15% 7 15% 8 15% 9 15% 10
16% 1 16% 2 16% 3 16% 4 16% 5 16% 6 16% 7 16% 8 16% 9 16% 10
17% 1 17% 2 17% 3 17% 4 17% 5 17% 6 17% 7 17% 8 17% 9 17% 10
18% 1 18% 2 18% 3 18% 4 18% 5 18% 6 18% 7 18% 8 18% 9 18% 10
19% 1 19% 2 19% 3 19% 4 19% 5 19% 6 19% 7 19% 8 19% 9 19% 10
20% 1 20% 2 20% 3 20% 4 20% 5 20% 6 20% 7 20% 8 20% 9 20% 10
21-40% 21-40% 21-40% 21-40% 21-40%
Prob Impact Prob Impact Result Prob Impact Prob Impact Result Prob Impact Prob Impact Result Prob Impact Prob Impact Result Prob Impact Prob Impact Result
21% 1 21% 2 1 21% 3 21% 4 1 21% 5 21% 6 1 21% 7 21% 8 3 21% 9 21% 10 0
22% 1 22% 2 22% 3 22% 4 22% 5 22% 6 22% 7 22% 8 22% 9 22% 10
23% 1 23% 2 23% 3 23% 4 23% 5 23% 6 23% 7 23% 8 23% 9 23% 10
24% 1 24% 2 24% 3 24% 4 24% 5 24% 6 24% 7 24% 8 24% 9 24% 10
25% 1 25% 2 25% 3 25% 4 25% 5 25% 6 25% 7 25% 8 25% 9 25% 10
26% 1 26% 2 26% 3 26% 4 26% 5 26% 6 26% 7 26% 8 26% 9 26% 10
27% 1 27% 2 27% 3 27% 4 27% 5 27% 6 27% 7 27% 8 27% 9 27% 10
28% 1 28% 2 28% 3 28% 4 28% 5 28% 6 28% 7 28% 8 28% 9 28% 10
29% 1 29% 2 29% 3 29% 4 29% 5 29% 6 29% 7 29% 8 29% 9 29% 10
30% 1 30% 2 30% 3 30% 4 30% 5 30% 6 30% 7 30% 8 30% 9 30% 10
31% 1 31% 2 31% 3 31% 4 31% 5 31% 6 31% 7 31% 8 31% 9 31% 10
32% 1 32% 2 32% 3 32% 4 32% 5 32% 6 32% 7 32% 8 32% 9 32% 10
33% 1 33% 2 33% 3 33% 4 33% 5 33% 6 33% 7 33% 8 33% 9 33% 10
34% 1 34% 2 34% 3 34% 4 34% 5 34% 6 34% 7 34% 8 34% 9 34% 10
35% 1 35% 2 35% 3 35% 4 35% 5 35% 6 35% 7 35% 8 35% 9 35% 10
36% 1 36% 2 36% 3 36% 4 36% 5 36% 6 36% 7 36% 8 36% 9 36% 10
37% 1 37% 2 37% 3 37% 4 37% 5 37% 6 37% 7 37% 8 37% 9 37% 10
38% 1 38% 2 38% 3 38% 4 38% 5 38% 6 38% 7 38% 8 38% 9 38% 10
39% 1 39% 2 39% 3 39% 4 39% 5 39% 6 39% 7 39% 8 39% 9 39% 10
40% 1 40% 2 40% 3 40% 4 40% 5 40% 6 40% 7 40% 8 40% 9 40% 10
41-60% 41-60% 41-60% 41-60% 41-60%
Prob Impact Prob Impact Result Prob Impact Prob Impact Result Prob Impact Prob Impact Result Prob Impact Prob Impact Result Prob Impact Prob Impact Result
41% 1 41% 2 0 41% 3 41% 4 0 41% 5 41% 6 1 41% 7 41% 8 1 41% 9 41% 10 3
42% 1 42% 2 42% 3 42% 4 42% 5 42% 6 42% 7 42% 8 42% 9 42% 10
43% 1 43% 2 43% 3 43% 4 43% 5 43% 6 43% 7 43% 8 43% 9 43% 10
44% 1 44% 2 44% 3 44% 4 44% 5 44% 6 44% 7 44% 8 44% 9 44% 10
45% 1 45% 2 45% 3 45% 4 45% 5 45% 6 45% 7 45% 8 45% 9 45% 10
46% 1 46% 2 46% 3 46% 4 46% 5 46% 6 46% 7 46% 8 46% 9 46% 10
47% 1 47% 2 47% 3 47% 4 47% 5 47% 6 47% 7 47% 8 47% 9 47% 10
48% 1 48% 2 48% 3 48% 4 48% 5 48% 6 48% 7 48% 8 48% 9 48% 10
49% 1 49% 2 49% 3 49% 4 49% 5 49% 6 49% 7 49% 8 49% 9 49% 10
50% 1 50% 2 50% 3 50% 4 50% 5 50% 6 50% 7 50% 8 50% 9 50% 10
51% 1 51% 2 51% 3 51% 4 51% 5 51% 6 51% 7 51% 8 51% 9 51% 10
52% 1 52% 2 52% 3 52% 4 52% 5 52% 6 52% 7 52% 8 52% 9 52% 10
53% 1 53% 2 53% 3 53% 4 53% 5 53% 6 53% 7 53% 8 53% 9 53% 10
54% 1 54% 2 54% 3 54% 4 54% 5 54% 6 54% 7 54% 8 54% 9 54% 10
55% 1 55% 2 55% 3 55% 4 55% 5 55% 6 55% 7 55% 8 55% 9 55% 10
56% 1 56% 2 56% 3 56% 4 56% 5 56% 6 56% 7 56% 8 56% 9 56% 10
57% 1 57% 2 57% 3 57% 4 57% 5 57% 6 57% 7 57% 8 57% 9 57% 10
58% 1 58% 2 58% 3 58% 4 58% 5 58% 6 58% 7 58% 8 58% 9 58% 10
59% 1 59% 2 59% 3 59% 4 59% 5 59% 6 59% 7 59% 8 59% 9 59% 10
60% 1 60% 2 60% 3 60% 4 60% 5 60% 6 60% 7 60% 8 60% 9 60% 10
61-80% 61-80% 61-80% 61-80% 61-80%
Prob Impact Prob Impact Result Prob Impact Prob Impact Result Prob Impact Prob Impact Result Prob Impact Prob Impact Result Prob Impact Prob Impact Result
61% 1 61% 2 0 61% 3 61% 4 0 61% 5 61% 6 0 61% 7 61% 8 1 61% 9 61% 10 8
62% 1 62% 2 62% 3 62% 4 62% 5 62% 6 62% 7 62% 8 62% 9 62% 10
63% 1 63% 2 63% 3 63% 4 63% 5 63% 6 63% 7 63% 8 63% 9 63% 10
64% 1 64% 2 64% 3 64% 4 64% 5 64% 6 64% 7 64% 8 64% 9 64% 10
65% 1 65% 2 65% 3 65% 4 65% 5 65% 6 65% 7 65% 8 65% 9 65% 10
66% 1 66% 2 66% 3 66% 4 66% 5 66% 6 66% 7 66% 8 66% 9 66% 10
67% 1 67% 2 67% 3 67% 4 67% 5 67% 6 67% 7 67% 8 67% 9 67% 10
68% 1 68% 2 68% 3 68% 4 68% 5 68% 6 68% 7 68% 8 68% 9 68% 10
69% 1 69% 2 69% 3 69% 4 69% 5 69% 6 69% 7 69% 8 69% 9 69% 10
70% 1 70% 2 70% 3 70% 4 70% 5 70% 6 70% 7 70% 8 70% 9 70% 10
71% 1 71% 2 71% 3 71% 4 71% 5 71% 6 71% 7 71% 8 71% 9 71% 10
72% 1 72% 2 72% 3 72% 4 72% 5 72% 6 72% 7 72% 8 72% 9 72% 10
73% 1 73% 2 73% 3 73% 4 73% 5 73% 6 73% 7 73% 8 73% 9 73% 10
74% 1 74% 2 74% 3 74% 4 74% 5 74% 6 74% 7 74% 8 74% 9 74% 10
75% 1 75% 2 75% 3 75% 4 75% 5 75% 6 75% 7 75% 8 75% 9 75% 10
76% 1 76% 2 76% 3 76% 4 76% 5 76% 6 76% 7 76% 8 76% 9 76% 10
77% 1 77% 2 77% 3 77% 4 77% 5 77% 6 77% 7 77% 8 77% 9 77% 10
78% 1 78% 2 78% 3 78% 4 78% 5 78% 6 78% 7 78% 8 78% 9 78% 10
79% 1 79% 2 79% 3 79% 4 79% 5 79% 6 79% 7 79% 8 79% 9 79% 10
80% 1 80% 2 80% 3 80% 4 80% 5 80% 6 80% 7 80% 8 80% 9 80% 10
81-100% 81-100% 81-100% 81-100% 81-100%
Prob Impact Prob Impact Result Prob Impact Prob Impact Result Prob Impact Prob Impact Result Prob Impact Prob Impact Result Prob Impact Prob Impact Result
81% 1 81% 2 0 81% 3 81% 4 0 81% 5 81% 6 0 81% 7 81% 8 0 81% 9 81% 10 2
82% 1 82% 2 82% 3 82% 4 82% 5 82% 6 82% 7 82% 8 82% 9 82% 10
83% 1 83% 2 83% 3 83% 4 83% 5 83% 6 83% 7 83% 8 83% 9 83% 10
84% 1 84% 2 84% 3 84% 4 84% 5 84% 6 84% 7 84% 8 84% 9 84% 10
85% 1 85% 2 85% 3 85% 4 85% 5 85% 6 85% 7 85% 8 85% 9 85% 10
86% 1 86% 2 86% 3 86% 4 86% 5 86% 6 86% 7 86% 8 86% 9 86% 10
87% 1 87% 2 87% 3 87% 4 87% 5 87% 6 87% 7 87% 8 87% 9 87% 10
88% 1 88% 2 88% 3 88% 4 88% 5 88% 6 88% 7 88% 8 88% 9 88% 10
89% 1 89% 2 89% 3 89% 4 89% 5 89% 6 89% 7 89% 8 89% 9 89% 10
90% 1 90% 2 90% 3 90% 4 90% 5 90% 6 90% 7 90% 8 90% 9 90% 10
91% 1 91% 2 91% 3 91% 4 91% 5 91% 6 91% 7 91% 8 91% 9 91% 10
92% 1 92% 2 92% 3 92% 4 92% 5 92% 6 92% 7 92% 8 92% 9 92% 10
93% 1 93% 2 93% 3 93% 4 93% 5 93% 6 93% 7 93% 8 93% 9 93% 10
94% 1 94% 2 94% 3 94% 4 94% 5 94% 6 94% 7 94% 8 94% 9 94% 10
95% 1 95% 2 95% 3 95% 4 95% 5 95% 6 95% 7 95% 8 95% 9 95% 10
96% 1 96% 2 96% 3 96% 4 96% 5 96% 6 96% 7 96% 8 96% 9 96% 10
97% 1 97% 2 97% 3 97% 4 97% 5 97% 6 97% 7 97% 8 97% 9 97% 10
98% 1 98% 2 98% 3 98% 4 98% 5 98% 6 98% 7 98% 8 98% 9 98% 10
99% 1 99% 2 99% 3 99% 4 99% 5 99% 6 99% 7 99% 8 99% 9 99% 10
100% 1 100% 2 100% 3 100% 4 100% 5 100% 6 100% 7 100% 8 100% 9 100% 10
&LForm P-4&C&"Arial,Bold"&8 Project Manager: Name (816) XXX-XXXX

Sheet1

Risk ID Risk Date Risk Name Risk Rank Risk Phase Risk Probability Impact (1-10) Exp Effect Mitigation Trigger Event Contingency
1 3/17/18 Contract obligations inadequetly fulfilled High Project Charter Approval 0.9 10 9 Refusal of payments and refusal to acknowledge contract Transfer Refusal to sign contract, payment refusual Allow third party to intervene if both parties can't come to an agreement over payments. Insert check-off list into client contract and have them initial each obligation to be fulfilled
2 3/5/18 to 4/21/18 Lack of communication within constructed teams High All Phases 0.85 10 8.5 Project work delayed, miinterpretations of what's expected, unmeasured goals Mitigate Lack in quality of work produced, specifications/requirements not met, project activities doesn't begin or start as scheduled causeing schedule delays Setup more frequent mandatory meetings on a weekly basis
3 4/19/18 Loss of data High Deployed Software 0.8 10 8 Data may be potentially lost Mitigate File corruption, system viruses, power failures, malware misfunctioning Continuously backup data
4 3/23/18 Requirements clearly defined within the scope High Business Requirements Gathered 0.8 10 8 No rework is needed on the project, requirements met and project has the opportunity to complete on time Exploit Satisfied Stakeholders Schedule regular meeting with stakeholder, ensuring project needs are constantly met as the project began to progress
5 3/30/18 Poorly built database utilized to retrieve information High Design Completion 0.77 10 7.7 Data not properly aligned with table construction Mitigate Inaccurate information display to end user Ensure all schema diagrams are reviewed in depth to prevent misalignment of data and inaccurate data retrieval
6 3/13/18 Difficult time defining functionality & content requirements High Scope 0.76 10 7.6 Sotware not functioning to its full capacity, may not be user-friendly, rework required, developers unclear about results Mitigate Specifications not recorded accurately, developers delay coding process until issue resolved Schedule meetings with stakeholder to clarify functionality and content requirements
7 4/19/18 Inadequate privacy of data or data security High Deployed Software 0.75 10 7.5 Information of client data is vulnerable and misused, company data exposed and comprimised, lead to breach of data, lawsuit, compromise integrity of company Transfer System is hacked causing data breaches, configuration system not configured properly, malicious software downloaded Best to transfer risk to a third party vendor to establish layers of security levels on the server, and limit access to the main server
8 3/30/18 Goldplatting High Design Completion 0.73 10 7.3 Budget & schedule overruns Mitigate Deviation from the plan, with additonal work added that's not reflected in the scope statement Only complete work within the scope of the project, additional work must be approved via change management process
9 3/13/18 Project Scope Creep (stakeholders want to make changes to the project that will impact schedule, cost, quality) High Project Approval 0.72 10 7.2 Schedule delays, missed milestones, cost of project rises, quality of project has the potential to decrease Mitigate Client not satisfied, client want to add additional work to the curent project Ensure stakeholders are engaged at all time via frequent meetings, obtain constant feedback through each phase of the project
10 4/19/18 Server, hardware, software crashes High Deployed Software 0.7 10 7 Loss of data, delayed ability to utilize software Mitigate Considerable amounts of users are accessing site at same time, server space limited and can't support large amounts of data Install backup sever to rollback to the last point of time to restore the most recent information and data saved `
Low (1-3)
Medium (4-6)
High (7-10)