Course Project

MGMT404_Worksheets_Template_v3.xlsx

Home >Human Resource Management homework help >Course Project

B. Stakeholder Engagement Plan

[Complete the stakeholder engagement plan by 1) Identifying the people, group, or department that could impact or be impacted by the project, and their role in the project; and categorize them as primary (i.e., those that are directly impacted), secondary (i.e., those that are indirectly impacted), or key stakeholders (i.e., those that have high influence or high interest in the project. 2) Analyzing the stakeholders based on their level of influence & interest and determine what are their needs and key interests. 3) Strategizing how to engage with stakeholders based on the stakeholder analysis & the prescribed engagement strategy table below. The strategy owner could the project manager, program manager, internal project sponsor, the Project Management Office, or any team member suitable for the job. 4) Use the prescribed engagement strategies described below to help you select the engagement strategy and the strategic approach . 5) Identify 3 more stakeholders in addition to the 12 stakeholders listed in the Getta Byte project Week 2 video and complete the rest of the matrix.]
Stakeholder Engagement Plan: Stakeholder Register
Project Name:						Project Manager:			Date:
Stakeholder Identification			Stakeholder Analysis			Engagement Strategy
Stakeholder	Role	Category	Influence (H / L)	Interest (H / L)	Key Interests & Needs	Strategy	Strategic Approach	Strategy Owner	Engagement Frequency & Method
Haywood U. Buzzoff	CEO	Key	High	High	Project deadline & company savings. Needs weekly updates.	MANAGE	Keep them involved in decisions. Meet face to face.	PM	Weekly Meetings
Instructions For Completing This Document
Stakeholder: Identify the people, group, or department that could impact or be impacted by the project, and their role in the project
Stakeholder's Role: Enter the stakeholder's role in the project.
Category: categorize stakeholders as primary (i.e., those that are directly impacted), secondary (i.e., those that are indirectly impacted), or key stakeholders (i.e., those that have high influence or high interest in the project. )
Influence: Enter the stakeholder's level of influence in the project. (Select high or low.)
Interest: Analyzing the stakeholders based on their level of influence & interest. (Select high or low.)
Key Interest: This information will required meeting with the stakeholder or a SME that is familiar with the stakeholder's need. For this assignment be creative
Engagement Strategy: Based on the stakeholders' Influence & Interest level select the "Prescribed Engagment Strategy" as presented in the table below
Strategic Approach: Enter a "Strategic Approach or Action Plan" based on the the "Prescribed Engagment Strategy" as presented in the table below
Strategy Owner: The strategy owner could the project manager, program manager, internal project sponsor, the Project Management Office, or any team member suitable for the job.
Engagement Frequency & Method: Frequency Ex: Daily, Weekly, Monthly; Method: Ex: Face to Face, Meetings, Text, Webex, Phone Call, Etc.
PRESCRIBED ENGAGEMENT STRATEGY
Influence	Interest	Strategy	Strategic Approach or Plan of Action
High	High	MANAGE	* Manage closely by keeping them involved in project decission. * Engage them on regular basis * Work to maintain relationship.
High	Low	SATISFY	* Keep satisfied by meeting their needs * Meet in person: Engage and consult * Work to increase their low interest level
Low	High	INFORM	* Make use of their high interest through involvement. * Consult on their area of interest; their high interest makes them a supporter/ambassador.
Low	Low	MONITOR	* Monitor communication for changes in influene and interest. * Keep them updated
Note 1 : When stakeholders have a mediun influence and or mediun interest, use a mix strategy approach. Note 2: The strategic engagement approach should also consider the individual stakeholders' needs and interest in the project

C. Communications Mgmt. Plan

COMMUNICATIONS MANAGEMENT PLAN
Project Name:
Project Manager Name:
Project Description:
ID	Communicaton Vehicle	Target Audience	Description/Purpose	Frequency	Sender	Distribution Vehicle	Internal / External?	Comments
0	Weekly status meeting	Project Team	Project status updates	Weekly	Project Manager	Meeting	Internal Only	Full Team meeting we will invite stakeholders when necessary.
0
Column	Instructions For Completing This Document
	Complete the Project Name, NC, Project Manager Name, and Project Description fields
	For each identified communication, complete the following.
A	ID: A unique ID number is used to identify the communication within the communication matrix.
B	Communication Vehicle: This column should be populated with a description of the type of communication that will be conducted.
C	Target Audience: This field should be populated with a description of the target audience for this communication vehicle.
D	Description/Purpose: This field should be populated with a description of the purpose of the communication.
E	Frequency: This field should be populated with the frequency of which the communication will be distributed.
F	Owner: This field should be populated with the name of the owner of the communication.
G	Distribution Vehicle: This field should be populated with the type of distribution vehicle that will be used to disseminate the communication.
H	Internal/External: This field should indicate if the communication is for internal, external, or both internal and external distribution.
I	Comments: This column should be populated with any additional comments.

US Holidays

Don't Change this page. This information is used in other pages.

HOLIDAYS

Year

2021

2022

2023

2024

2025

Date

Name

Type

Date

Type

Date

Name

Type

Details

Date

Name

Type

Details

Date

Name

Type

Details

1-Jan

Friday

New Year's Day

Federal Holiday

1-Jan

Saturday

Federal Holiday

1-Jan

Sunday

New Year's Day

Federal Holiday

1-Jan

Monday

New Year's Day

Federal Holiday

1-Jan

Wednesday

New Year's Day

Federal Holiday

18-Jan

Monday

Martin Luther King Jr. Day

Federal Holiday

17-Jan

Monday

Federal Holiday

2-Jan

Monday

Day off for New Year's Day

Federal Holiday

15-Jan

Monday

Martin Luther King Jr. Day

Federal Holiday

20-Jan

Monday

Martin Luther King Jr. Day

Federal Holiday

20-Jan

Wednesday

Inauguration Day

Federal Holiday

21-Feb

Monday

Federal Holiday

16-Jan

Monday

Martin Luther King Jr. Day

Federal Holiday

19-Feb

Monday

Presidents' Day

Federal Holiday

20-Jan

Monday

Inauguration Day

Federal Holiday

DC, MD*, VA*

15-Feb

Monday

Presidents' Day

Federal Holiday

30-May

Monday

Federal Holiday

20-Feb

Monday

Presidents' Day

Federal Holiday

27-May

Monday

Memorial Day

Federal Holiday

17-Feb

Monday

Presidents' Day

Federal Holiday

31-May

Monday

Memorial Day

Federal Holiday

19-Jun

Sunday

Federal Holiday

29-May

Monday

Memorial Day

Federal Holiday

19-Jun

Wednesday

Juneteenth

Federal Holiday

26-May

Monday

Memorial Day

Federal Holiday

18-Jun

Friday

Day off for Juneteenth

Federal Holiday

20-Jun

Monday

Federal Holiday

19-Jun

Monday

Juneteenth

Federal Holiday

4-Jul

Thursday

Independence Day

Federal Holiday

19-Jun

Thursday

Juneteenth

Federal Holiday

19-Jun

Saturday

Juneteenth

Federal Holiday

4-Jul

Monday

Federal Holiday

4-Jul

Tuesday

Independence Day

Federal Holiday

2-Sep

Monday

Labor Day

Federal Holiday

4-Jul

Friday

Independence Day

Federal Holiday

4-Jul

Sunday

Independence Day

Federal Holiday

5-Sep

Monday

Federal Holiday

4-Sep

Monday

Labor Day

Federal Holiday

14-Oct

Monday

Columbus Day

Federal Holiday

1-Sep

Monday

Labor Day

Federal Holiday

5-Jul

Monday

Day off for Independence Day

Federal Holiday

10-Oct

Monday

Federal Holiday

9-Oct

Monday

Columbus Day

Federal Holiday

11-Nov

Monday

Veterans Day

Federal Holiday

13-Oct

Monday

Columbus Day

Federal Holiday

6-Sep

Monday

Labor Day

Federal Holiday

11-Nov

Friday

Federal Holiday

10-Nov

Friday

Day off for Veterans Day

Federal Holiday

28-Nov

Thursday

Thanksgiving Day

Federal Holiday

11-Nov

Tuesday

Veterans Day

Federal Holiday

11-Oct

Monday

Columbus Day

Federal Holiday

24-Nov

Thursday

Federal Holiday

11-Nov

Saturday

Veterans Day

Federal Holiday

25-Dec

Wednesday

Christmas Day

Federal Holiday

27-Nov

Thursday

Thanksgiving Day

Federal Holiday

11-Nov

Thursday

Veterans Day

Federal Holiday

25-Dec

Sunday

Federal Holiday

23-Nov

Thursday

Thanksgiving Day

Federal Holiday

25-Dec

Thursday

Christmas Day

Federal Holiday

25-Nov

Thursday

Thanksgiving Day

Federal Holiday

26-Dec

Monday

Federal Holiday

25-Dec

Monday

Christmas Day

Federal Holiday

24-Dec

Friday

Day off for Christmas Day

Federal Holiday

25-Dec

Saturday

Christmas Day

Federal Holiday

31-Dec

Friday

Day off for New Year's Day

Federal Holiday

HOLIDAYS

2021

2022

2023

2024

2025

1-Jan

18-Jan

17-Jan

2-Jan

15-Jan

20-Jan

21-Feb

16-Jan

19-Feb

20-Jan

15-Feb

30-May

20-Feb

27-May

17-Feb

31-May

19-Jun

29-May

19-Jun

26-May

18-Jun

20-Jun

19-Jun

4-Jul

19-Jun

4-Jul

2-Sep

4-Jul

5-Sep

4-Sep

14-Oct

1-Sep

5-Jul

10-Oct

9-Oct

11-Nov

13-Oct

6-Sep

11-Nov

10-Nov

28-Nov

11-Nov

11-Oct

24-Nov

11-Nov

25-Dec

27-Nov

11-Nov

25-Dec

23-Nov

25-Dec

25-Nov

26-Dec

25-Dec

24-Dec

25-Dec

31-Dec

E. GANTT CHART

	PROJECT TITLE:								COMPANY NAME
	Project Manager:								Student's Name												Jane Doe																													ENTER ONLY INFORMATION IN THE YELLOW CELLS!
		Project Start:	Mon, 3-Jan-22																																															Project start date is the same as your course start date
		Today:	Mon, 3-Jan-22
		Display Week:	1					Jan 3, 2022							Jan 10, 2022							Jan 17, 2022							Jan 24, 2022							Jan 31, 2022							Feb 7, 2022							Feb 14, 2022							Feb 21, 2022							Feb 28, 2022							Mar 7, 2022							Mar 14, 2022							Mar 21, 2022							Mar 28, 2022							Apr 4, 2022							Apr 11, 2022							Apr 18, 2022							Apr 25, 2022							May 2, 2022							May 9, 2022							May 16, 2022							May 23, 2022							May 30, 2022							Jun 6, 2022
								3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	1	2	3	4	5	6	7	8	9	10	11	12
WBS	TASKS	PROGRESS	START	END	Task Duration	Total Hours	DAYS Vertex42.com Templates: DAYS: This column calculates the duration of the task in calendar days. The duration includes both the Start and End dates.	M	T	W	T	F	S	S	M	T	W	T	F	S	S	M	T	W	T	F	S	S	M	T	W	T	F	S	S	M	T	W	T	F	S	S	M	T	W	T	F	S	S	M	T	W	T	F	S	S	M	T	W	T	F	S	S	M	T	W	T	F	S	S	M	T	W	T	F	S	S	M	T	W	T	F	S	S	M	T	W	T	F	S	S	M	T	W	T	F	S	S	M	T	W	T	F	S	S	M	T	W	T	F	S	S	M	T	W	T	F	S	S	M	T	W	T	F	S	S	M	T	W	T	F	S	S	M	T	W	T	F	S	S	M	T	W	T	F	S	S	M	T	W	T	F	S	S	M	T	W	T	F	S	S	M	T	W	T	F	S	S
1	Project Title		Mon, 3-Jan-22	Thu, 12, May,22	92	736	130
	M:
	Task 1	0%	Mon, 3-Jan-22	Fri, 7, Jan,22	5	40	5
	Task 2	0%	Mon, 10-Jan-22	Wed, 12, Jan,22	3	24	3
	Task 3	0%	Thu, 13-Jan-22	Tue, 18, Jan,22	3	24	6
	Task 4	0%	Wed, 19-Jan-22	Fri, 21, Jan,22	3	24	3
	Task 5	0%	Mon, 24-Jan-22	Wed, 26, Jan,22	3	24	3
	Task 6	0%	Thu, 27-Jan-22	Mon, 31, Jan,22	3	24	5
	Task 7	0%	Tue, 1-Feb-22	Thu, 3, Feb,22	3	24	3
	Task 8	0%	Fri, 4-Feb-22	Tue, 8, Feb,22	3	24	5
	Task 9	0%	Wed, 9-Feb-22	Fri, 11, Feb,22	3	24	3
	Task 10	0%	Mon, 14-Feb-22	Wed, 16, Feb,22	3	24	3
	Task 11	0%	Thu, 17-Feb-22	Tue, 22, Feb,22	3	24	6
	Task 12	0%	Wed, 23-Feb-22	Fri, 25, Feb,22	3	24	3
	Task 13	0%	Mon, 28-Feb-22	Wed, 2, Mar,22	3	24	3
	Task 14	0%	Thu, 3-Mar-22	Mon, 7, Mar,22	3	24	5
	Task 15	0%	Tue, 8-Mar-22	Thu, 10, Mar,22	3	24	3
	Task 16	0%	Fri, 11-Mar-22	Tue, 15, Mar,22	3	24	5
	Task 17	0%	Wed, 16-Mar-22	Fri, 18, Mar,22	3	24	3
	Task 18	0%	Mon, 21-Mar-22	Wed, 23, Mar,22	3	24	3
	Task 19	0%	Thu, 24-Mar-22	Mon, 28, Mar,22	3	24	5
	Task 20	0%	Tue, 29-Mar-22	Thu, 31, Mar,22	3	24	3
	Task 21	0%	Fri, 1-Apr-22	Tue, 5, Apr,22	3	24	5
	Task 22	0%	Wed, 6-Apr-22	Fri, 8, Apr,22	3	24	3
	Task 23	0%	Mon, 11-Apr-22	Wed, 13, Apr,22	3	24	3
	Task 24	0%	Thu, 14-Apr-22	Mon, 18, Apr,22	3	24	5
	Task 25	0%	Tue, 19-Apr-22	Thu, 21, Apr,22	3	24	3
	Task 26	0%	Fri, 22-Apr-22	Tue, 26, Apr,22	3	24	5
	Task 27	0%	Wed, 27-Apr-22	Fri, 29, Apr,22	3	24	3
	Task 28	0%	Mon, 2-May-22	Wed, 4, May,22	3	24	3
	Task 29	0%	Thu, 5-May-22	Mon, 9, May,22	3	24
	Task 30	0%	Tue, 10-May-22	Thu, 12, May,22	3	24
			Total (days & hrs)		92	736
				Sat, 13, Jan,18
	FOLLOW THE STEPS BELOW
HOW TO USE THIS DOCUMENT TO CREATE YOUR PROJECT GANTT CHART
The user only needs to enter values in those cells colored yellow to create the Gantt Chart
1)	Enter a valid Project Start date. Valid dates are between 1-Jan-21 to 31-Dec-25. To use other dates, change or remove the cell data validation
	feature. For Project Start date, use the start date of the current session.
2)	Today 's date will activate a red line maker marker,\|\|, on the calendar. You could enter the date manually or enter the Excel funtion =Today()
3)	The Display Week number will show the week at the beginning of the calendar display, always starting on Monday.
4)	TASKS (column D): Enter the names of the Tasks for the project. The template was created for a project with 30 tasks. Delete Task ROWS as needed
5)	Task Duration column: Enter the duration for each task in days.
6)	Pink columns indicate weekend days Sat. and Sunday. These dates are blocked for work.
7)	Dark Orange Cells are Holidays. These dates are blocked for work.
8)	Light orange cells represent the number of days in the "Task Durantion" Column. Ex: If a task duration = 3, them 3 orange cells will be displayed to represent
	each day & the Total Hours will be calculated automatically.
9)	If your project is divided in Milestones, you could group the tasks under a milestoned by hilighting the rows with different colors.
10)	Row 10 has been formatted to help you adding Milestones titles to your project, by copying the ROW 10 and INSERTING IT as needed.
	NOTE: COPY ROW 10 EVERYTIME BEFORE INSERTING IT TO DENOTE A DIFFERENT MILESTONE GROUP.
11)	Enter Milestone name under task column.
12)	Calculate the START * END dates for each milestones using the Min and Max function. See as example cell G8 and H8
13)	Complete the WBS index column. The WBS index numbers for the project can be found on the WBS for the Getta Byte project presented in week 4 Canvas Lesson.
14)	Print Page 1 in PDF, take an snip of it and paste in the Word Document template.
NOTE: WHAT HAPPENS IF YOU DELETE A TASK X? The formulas in the start and end cells will not work. In that case, the student will need to enter Start and End dates manually.

F. RESOURCES & BUDGET

	Project Resources Allocation & Budgeting
[Note: Some of the Getta Byte Project information has been entered using black font for demonstration purposes. Information entered in blue must be revised according to your assignment. Please watch the video in the Week 5 Canvas lesson related to your project. Read the instruction on "HOW TO USE THIS DOCUMENT TO CALCULATE THE PROJECT BUDGET" for more information. ]										PROJECT TEAM ASSIGNMENTS TO TASK
Methodology										Table 4 a. TEAM ASSIGNMENTS					Table 4 b. TASK DURATIONS
1	Determine the manpower/skills and resource requirements needed for the project ( i.e., Work , Materials, Fixed Cost)									A	B	C	D	E	WBS	TASK NAME	Task Duration (Days)	Task (Hrs)
2	Determine the Team Skills/capabilities to do the work									1	1	1	1	1	1.1.1	T1: Gather user requirements	5	40
3	Determine the skill gaps and decide whether to oursource or adding more team member with the skills still needed									1	1	1	1	1	1.1.2	T2: Gather customer requirements	5	40
	a cost-benefit and risk analysis on oursoucing vs. inhouse.									1	1	1	1	1	1.2.1	T3:	3	24
4	Allocate resources to tasks (to create a resource schedule) and calculate budget requirements									1	1	1	1	1	1.2.2	T4:	3	24
										0	0	1	1	1	1.2.3	T5:	3	24
										0	0	0	0	1	1.3.1	T6	3	24
Project Resources Allocation & Budgeting										0	0	0	0	1	1.3.2	T7	3	24
										0	0	0	0	1	1.3.3	T8	3	24
Table 1. RESOURCE TYPE: WORK										0	0	0	0	1	1.3.4	T9	3	24
Skills Required for project		Qty.	Resource Name	AVAL. %	Hr. Rate	Assigned Tasks	Hrs. Required	Estimated Work Cost		0	0	0	0	1	1.4.1	T10	3	24
A	Project Manager	1	IMMA PAYNE	100%	$4	1.1.1, 1.1.2, 1.2.1, 1.2.2,1.2.3, 1.5.1, 1.5.2, 1.5.3, 1.6.1	224	$ 896		0	0	0	0	1	1.4.2	T11	3	24
B	Developer 1	1	Enter name	100%	$4	1.x.x, 1.x.x., …	200	$ 800		0	0	0	0	1	1.4.3	T12	3	24
C	Developer 2	1	Enter name	100%	$4	1.x.x, 1.x.x., …	224	$ 896		1	0	0	0	1	1.5.1	T13: Develop Training modules	3	24
D	Data Architect	1	Enter name	100%	$5	1.x.x, 1.x.x., …	224	$ 1,120		1	1	1	1	1	1.5.2	T14	3	24
E	Data Specialist	1	Enter name	50%	$6	1.x.x, 1.x.x., …	416	$ 1,248		1	1	1	1	1	1.5.3	T15	3	24
										1	1	1	1	1	1.6.1	T16	3	24
WORK COST								$ 4,960.00	Hrs. Required	P M	Developer 1	Developer 2	Data Architect	Data Analyst			Days	Hrs	1
										224	200	224	224	416		PROJECT DURATION	52	416
Table 2. RESOURCE TYPE: MATERIAL
Material		Qty.	Unit Cost	Notes				Estimated Material Cost		Note. Enter a 1 in colums A through E when a resource has been assigned to tasks on the left, otherwise enter a 0. For your assignment Column A indicate the task assigned to the Project Manager (i.e., Ima Payne) according to wk5 Getta Byte video in your Canvas Lesson
1	Software	1	$ 50,000	Assigned to activity 1.2.3				$ 50,000
2	PCs	3	$ 1,000	Needed for remote work				$ 3,000
3
MATERIAL COST								$ 53,000
Table 3. RESOURCE TYPE: FIXED COST										HOW TO USE THIS DOCUMENT TO CALCULATE THE PROJECT BUDGET
Skill Gap Required		Qty.	Contractor, Co.	Assigned Tasks				Estimated Fixed Cost		This document will help you to calculate the budget for the project (i.e., work budget, material budget, Fixed Cost budget.) Watch the Getta Byte video in the week 5 Canvas lesson. Locate Timeframes [1:03] & [2:25]
a	Developer of training modules	1	John Doe, ABC	1.51. Develop Training Modules				$ 10,000		1)	Enter the resources required for the project, corresponding to: the Skills, Materials, and Skills Gap in Tables 1, 2, and 3 respectively. (Column D)
b	Trainer	1	Jane Doe, XYZ	1.5.3 Conduct Training				$ 5,000		2)	Determine the quantity needed in tables 1, 2, and 3. (Column E)
FIXED COST								$ 15,000		3)	Table 1. (Blue font needs to be revised according to Wk 5 video. Don't change the black font.)
										4)	Enter the team member's name with the required skills in the Resource Name column, Table 1
										5)	Enter the team member's availability in the "Resource Availability" column. Use a 100% for team members assigned fully to the project. If a member is avalable for your project 4 hrs a day, then enter 50% (Ex. Nonia Business )
										6)	Enter resources' hourly rates.
										7)	Table 4 b. Enter task Names and Tasks duration in day. (Do not enter the Milestones & Don't change the black or white font since it has been entered or calculated for you), use information from timefreame [2:25 ].
										8)	Table 4 a. Enter a 1 in columns A through E when a resource has been assigned to a task on table 4b, otherwise enter a 0. Column A has been entered for you. Blue font in column B, C, D, and E has to be reviewed. This information is found on the transcripts of video 5.
										9)	Table 1. Enter the "Assigned Tasks" using the WBS index in Table 4b and the information you completed in Table 4 a.
										10)	Table 1. The "Total hrs. required" for each resource (i.e., A, B, C, D, and E) is automatically calculated for you in the last row of table 4, using the excel function: =SUMPRODUCT(array1, array2]. For Ex. see the required hours for A (i.., Ima Payne, the Project Manager) in cell "O25" and cell "J18"
										11)	Table 1. The "Estimated Work Cost" = Resource Availability * Hourly rate * Total hrs. required. This is automatically calculated for you.
										12)	Table 2. The "Estimated Material Cost" = Quantity * Unit Cost. Enter the in information for Software material in the week 5 transcript. Use row 2 and 3 to enter any other material that might be needed for the project.
										13)	Table 3. The information for this table is not provided in the week 5 video. The font is blue are suggestions, which you can modify.
										14)	The PLANNED PROJECT BUDGET figure is automatically created using the information from Tables 1, 2 and, 3
										15 )	Print Page 1 in PDF, take an snip of it and paste in the Word Document template.

Fig. 2 MANPOWER BUDGET

Project Manager Developer 1 Developer 2 Data Architect Data Specialist 0 0 0 0 0

Project Manager Developer 1 Developer 2 Data Architect Data Specialist 896 800 896 1120 1248 Project Manager Developer 1 Developer 2 Data Architect Data Specialist

Fig. 1 PLANNED PROJECT BUDGET

Manpower Cost Material Cost Fixed Cost 4960 53000 15000

Manpower Cost Material Cost Fixed Cost

Fig. 3 HOURS REQUIRED & MANPOWER COST

BUDGET REQUIRED

Project Manager Developer 1 Developer 2 Data Architect Data Specialist 896 800 896 1120 1248 TEAM ROLE/SKILS Project Manager Developer 1 Developer 2 Data Architect Data Specialist TOTAL TASK HRS. REQUIRED

Project Manager Developer 1 Developer 2 Data Architect Data Specialist 224 200 224 224 416

team member's role

TEAM MEMBER COST ($)

team member number of Hours required FOR project

G. RISK REGISTER

RISK MANAGEMENT: RISK REGISTER

[Note: Some of the Getta Byte Project information has been entered using black font for demonstration purposes. Please watch the video in the week 6 Canvas lesson related to your project. Scroll to the bottom on the register risk register matrix and read the instruction on "HOW TO USE THIS DOCUMENT". You must identified 4 negative risks and 2 positive risk and complete the risk management process ]

IDENTIFY RISK

PERFORM QUALITATIVE RISK ASSESSMENT

PLAN RISK RESPONSE

IMPLEMENT RISK PLAN

MONITOR RISK

WBS

Task Name

RBS Category

Risk Identified (Description)

Root Cause of the Risk

Risk Impact + / -

Prob.

Impact on Cost

Impact on Sch.

Impact on Quality

Risk Score

Risk Owner

Risk Strategy + / -

Risk Response Plan

Risk Action Owner

Risk Status

Negative

NEGATIVE RISK

1.4.3

Transfer Data

Organizational

Network Capacity (Failure during uploads)

Low bandwidth

Negative Impact on Schedule

Network Services

- Mitigate

* Review bandwidth requirements * Research best vendors for needs * Select vendor for high bandwidth * Conduct network assessment and troubleshoot prior to migration

Don Testit (Developer)

Active

1.4.2

Map fields

Technical

Data errors

Field mapping errors,

Negative Impact on Schedule

0.4

Data Architect

- Accept

Hugh Duitt (Data architech)

Active

1.4.1

Validate Data

Technical

Customer data integrity

* Script errors * Database mismatch

Negative Impact on Schedule

Data Specialist

- Mitigate

* Validate data on data sample

Nonia Buziness (Data Specialist)

Active

1.1.1

Gather Requirement from users

External

Scope definition (Users interviewed for gathering of requirements did not the experience nor background to provide information.)

Users interviewed did not have experience in the billing department

Negative Impact on Schedule, Budget, Quality

3.2

Project Manager

- Mitigate

* Be selective when interviewing users. * Users must have worked in the billing dpt. two years or more and must be familiar with billing processes * User must have operational & technical background.

Imma Payne Proj. Manager)

Expired

POSITIVE RISKS

1.2.3

Execute Purchase

External

Planning: Significant savings on software purchase if bougth on Black Friday

Holiday coming up

Positive Impact on Budget

Project Manager

+ Exploit

* Enter new actrivities in WBS to ensure actions are taken * Meet with mgmt and vendor * Delay purchase to Black Friday

Imma Payne (Proj. Manager)

Active

1.5.1

Develop Training with Vendor

External

Market: Off the shelf training modules could be available

Training modules available in the market

Positive Impact on Schedule

2.4

Project Manager

+ Enhance

* Gather software requirements * Understand features and functionality. * Reseach the market for off the shelf modules * Meet with vendor and team to determine suitability

Imma Payne (Proj. Manager)

Active

Refer to Section E.

Refer to Section F

You risk socre is calculated from the probability times the highest risk score (1-5) divided by 5 to give an average risk score between 1 and 5

Score between 4 and 5

Score between 2 and 3.99

Score between 0 and 1.99

HOW TO USE THIS DOCUMENT

This document is a tool to create the risk register for your project. Please watch the "Getta Byte - Risk Management" video listed on the week 6 Canvas Lesson. Also, review the video transcript. The information in the video for risks IDs 1, 2, and 3 have been entered in the riks register as examples. The student job is to identify 4 negative and 2 positive risks. Two Positive risks have also been identified and entered for you as examples.

ID: Enter IDs for the 4 negative and 2 positive you must identified. To Identify individual project risks, review the project tasks located in the Project Schedule-sections E.1 and/or the Gantt Chart - section E.2

WBS: Enter the WBS number of the risk you have identified. ther Using the RBS located in this to the right determine the risk category.

Task Name: Enter the name of the tasks you have identified as having a risk.

RBS Category: Select the risk category by clicking on the any cell on this column to visualize the dropdown menu and make a selection

Risk Identified: Enter the risk you have identified and describe it.

Root Cause: Determine the root cause of the risk. This information is critical to be able to create a risk plan

Impact (+ or -) : Select the Impact of the risk on the project objectives by clicking on the any cell on this column to visualize the dropdown menu and make a selection. Project objectives are to keep on target the budget, the schedule, and the quality of the project. If the impact is negative, this is a negative risk. If the impact is positive, This is a positive risk.

Probability: Ask the question "what is likelihood of occurrence of the identified risk?" Enter a number between 1 and 5. When the probability of occurrenc is: very high enter a 5, high enter a 4, medium enter a 3, low enter a 2, very low enter a 1

Impact: Enter a number between 1 and 5 for columns J, K, and L . When theimpact on the project "XXX" objective is: very high enter a 5, high enter a 4, medium enter a 3, low enter a 2, very low enter a 1

Risk Score: The Risk Score is calculated by multiplying the PROBABILITY of occurrence times the highest risk IMPACT (among C, Sc,Q) & dividing the product by 5 for normalization purposes.

10)

Risk Owner: The risk owner is a subject matter expert from the core team or from a different department who is familiar with the project task. Therefore the risk owner is suitable to create a risk response plan. Cell in this column has a dropdown menu with particular expertise that could be found within the core team or in other departments. Please select one according to the area of the risk you have identified.

11)

Risk Stragegy (+ or -) : This column presents Risk respoose strategies for negative & positive risks. Select a suitable strategy. Strategies for negative Risks include: Escalate,Avoid, Transfer, Mitigate, & Accept. Strategies for positive Risks include: Escalate, Enhance, Exploit, Share, & Accept

12)

Risk Response Plan: Enter the action plan for the strategy you have selected.

13)

Action Owner: The risk owner are in charge to ensure the implementation of the risk response plan, It is a member of the team working of the task

14)

Status: Select from the dropdown menu the status of the risk

15 )

Print Page 1 in PDF, take an snip of it and paste in the Word Document for you course project.

Tables used

Risk Owners	Effect/Impact	Resource Name
Project Manager	Negative Impact on Schedule	Imma Payne (Proj. Manager)
Developer 1	Negative Impact on Budget	Don Testit (Developer)
Developer 2	Negative Impact on Quality	Kurt Anser (Developer)
Data Architect	Negative Impact on Schedule, Budget, Quality	Hugh Duitt (Data architech)
Data Specialist	Positive Impact on Schedule	Nonia Buziness (Data Specialist)
Asst. PM	Positive Impact on Budget
PMO	Positive Impact on Quality
Network Services	Positive Impact on Schedule, Budget , Quality
Other
	Example
Risk Strategies	RISK Category
- Escalade	Technical
- Avoid	External
- Transfer	Organizational
- Mitigate	Proj. Mgmt.
- Accept
+ Escalate
+ Enhance
+ Exploit
+ Share
+ Accept