Question 1 – Creating a WBS 92 Points

For this question you are required to create a WBS using Project Libre as per the lecture notes. Please pay attention to the grading rubric to understand how this question is graded. Once you have completed setting up the WBS in project libre save it as a project libre file (.pod). Attach this file to your Blackboard submission.

Build a WBS for an IT project of your choice, this could be the development of a software application, installation and set up of a database, building of a website etc. The WBS should meet the following criteria:

There will be 12 main tasks.

Each main task will contain a minimum of 7 subtasks, which are properly tabbed within the associated main task such that Project Libre shows each main task group with a black line. (see

below)

The total length of the project should be a minimum of six months.

Each subtask should be granular enough that it represents an appropriate work package (the whole purpose of building a WBS)

Each task name is descriptive and is contextually appropriate.

Each task will have a duration associated with it.

Each task will have a start date and an end date.

Each task will have a predecessor.

Each task will have a resource associated with it.

The project team will be made up of 12 resources.

Resources are assigned based upon resources loaded into Project Libre (Use the resource tab) vs hardcoding resource names into each cell of the WBS.

The predecessors will be set up such that there will be a minimum of three paths to completion of the project. (see example below)

Grading Rubric

Question Element

Points

12 main tasks with 7 subtasks

21

Subtasks tabbed properly

5

Total Project Length min 6 months

1

Granular subtasks

5

Descriptive and appropriate subtasks

5

Duration attached to each task

5

Start/End date for each task

5

Predecessors for each task

10

Resource associated with each task

5

12 resources used

5

Resources are loaded into Project Libre

5

Minimum of three completion paths

20

TOTAL

92

Question 2 – Critical Path 5 Points

Based upon the work completed in question 1 , calculate the critical path of the project in days as per the lecture notes.

Question 3 – Cash Flow Projection 122 Points

Using the template below create a 6 month Cash Flow, as per the lecture notes, using Excel. Once completed attach the excel file to your blackboard upload list of files.

Build your cash flow based upon the following assumptions:

Each month $5,000 is invested in the project.

Every second month you receive a progress payment of $10,000

The project Manager is paid $12.5K per month.

There are 15 consultants on the team not including the project manager.

Each consultant is paid $8.3K per month.

The flight cost for each consultant is as follows:

o Consultant 1 $800 return trip

o Consultant 2 $900 return trip

o Consultant 3 $400 return trip

o Consultant 4 $300 return trip

o Consultant 5 $1900 return trip

o Consultant 6 $1200 return trip

o Consultant 7 $1300 return trip

o Consultant 8 $2100 return trip

o Consultant 9 $500 return trip

o Consultant 10 $800 return trip

o Consultant 11 $1800 return trip

o Consultant 12 $400 return trip

o Consultant 13 $900 return trip

o Consultant 14 $700 return trip

o Consultant 15 $2100 return trip

Each consultant works three weeks onsite and one week offsite on a rotating basis in teams of 5. Consultants 1-5 start onsite in week 1. Consultants’ 6-10 start onsite in week 2 and consultants’ 11-15 start onsite in week 3. All consultants work remotely when not onsite.

No consultant lives in the city where the project is taking place.

Consultants are paid a $75 per diem for meals when onsite.

Each hotel night costs $175.00.

Liability insurance costs $400/month.

Software subscriptions cost $150.00/month.

Client is taken to dinner every other month starting in January at a cost of $700.00.

There is a catered meeting each week at a cost of $150/meeting.

Project started January 1, 2020.

All costs must take into account the actual calendar dates associated with the project, therefore you must determin how many days are in each week to accurately calculate lodging and meal costs as each consultant flys home every Friday and back onsite Monday morning.

Grading Rubric

Question Element

Points

Accurate investment entry – 6 months

1

Accurate progress payment entry – 6 months

1

Accurate PM salary entry – 6 months

1

Accurate consultant salary entry – 6 months

1

Accurate consultant flight cost entry – 6 months

30

Accurate consultant meal cost entry – 6 months

30

Accurate consultant lodging entry – 6 months

30

Accurate liability insurance entry – 6 months

1

Accurate software subscription entry – 6 months

1

Accurate client entertainment entry – 6 months

3

Accurate meeting cost entry – 6 months

3

Accurate Opening Balance – 6 months

10

Accurate closing Balance – 6 months

10

TOTAL

122

Question 4 – Cause Effect Diagram 20 Points

Draw a Cause/Effect diagram as per the lecture notes to diagnose possible causes for the effect – “lost database connectivity”. Your diagram should have 5 cause categories with 7 causes within each category. Submit a screen shot of the cause effect diagram.

Question 5 – Scatter Diagram 6 Points

Based upon the data set below draw a scatter diagram as per the lecture notes and identify the type of correlation shown in the plot. Submit a screen shot of the scatter diagram and clearly label the type of correlation.

Dropped Connections

Device Temperature (deg C)

1

21

3

22.5

2

23

3

24.16666667

4

25.16666667

4

26.16666667

5

27.16666667

5

28.16666667

6

29.16666667

6

30.16666667

6

31.16666667

7

32.16666667

8

33.16666667

8

34.16666667

8

35.16666667

9

36.16666667

9

37.16666667

10

38.16666667

11

39.16666667

11

40.16666667

Grading Rubric

Question Element

Points

Accurate scatter diagram

5

Correct correlation label.

1

TOTAL

6

Question 6 – RBS 23 Points

Build a risk breakdown structure, as per the lecture notes, for an IT project of your choice. The RBS should have 7 main categories and 7 appropriate, specific and measurable risks under each category. . Submit a screen shot of the RBS.

Grading Rubric

Question Element

Points

7 Appropriate main categories

3

49 appropriate, measurable risks.

20

TOTAL

23

Question 7 – Probability and Impact Matrix 11 Points

Based upon the work completed in question 6, draw a probability and impact matrix as per the lecture notes and appropriately plot each of the 49 risks on the matrix. Each point should be labeled with a # corresponding to the risk number from a table which should accompany the matrix for look up purposes. Submit a screen shot of the probability impact matrix and associated look up table.

Question Element

Points

Appropriate matrix layout

3

Accurate look up table

3

49 risks are appropriately plotted

5

TOTAL

11

Submission Instructions

The upload link for this test can be found under the test link on blackboard. For this test you will upload four files under the same submission, to do so simply browse your computer for each file and attach. It is your responsibility to ensure that all files have uploaded properly and that all files can be opened.

This test will require 4 files to be uploaded:

File 1 Signed Declaration of Understanding

File 2 .pod file (office Libre) – Question 1

File 3 excel file – Question 3

File 4 PDF answer sheet which contains answers to the following questions:

Question 2 – critical path

Question 4 – cause and effect diagram

Question 5 – scatter diagram

Question 6 – RBS

Question 7 – probability impact matrix

Before uploading please ensure a signed Declaration of understanding is included in your submission. Submissions without a signed declaration of understanding will not be graded.

Order Now

Payment Methods

All online transactions are done using all major Credit Cards or Electronic Check through PayPal. These are safe, secure, and efficient online payment methods.

Our customer support team is here to answer your questions. Ask us anything!

👋 Hi, how can I help?