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
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)
12 main tasks with 7 subtasks
Subtasks tabbed properly
Total Project Length min 6 months
Descriptive and appropriate subtasks
Duration attached to each task
Start/End date for each task
Predecessors for each task
Resource associated with each task
12 resources used
Resources are loaded into Project Libre
Minimum of three completion paths
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.
Accurate investment entry – 6 months
Accurate progress payment entry – 6 months
Accurate PM salary entry – 6 months
Accurate consultant salary entry – 6 months
Accurate consultant flight cost entry – 6 months
Accurate consultant meal cost entry – 6 months
Accurate consultant lodging entry – 6 months
Accurate liability insurance entry – 6 months
Accurate software subscription entry – 6 months
Accurate client entertainment entry – 6 months
Accurate meeting cost entry – 6 months
Accurate Opening Balance – 6 months
Accurate closing Balance – 6 months
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.
Device Temperature (deg C)
Accurate scatter diagram
Correct correlation label.
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.
7 Appropriate main categories
49 appropriate, measurable risks.
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.
Appropriate matrix layout
Accurate look up table
49 risks are appropriately plotted
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.
Such a cheap price for your free time and healthy sleep
All online transactions are done using all major Credit Cards or Electronic Check through PayPal. These are safe, secure, and efficient online payment methods.