Unit 3 Assignment: Risk Analysis & Budgeting Using Excel
Excel file is the the template file that is offered for you to work on.
>Sheet 72 Unit Assignment Template
High . Poor spec. performance
Low Why? 1 = .3
1.12 80 1.35 0 1.75 1.12 $ 100 $ 100 $ 800 $ 200 $ 400 $ 1,000 Complexity 8 Low 6 Low High 5 High Medium 6 x 2
1
BUS
4
3
Instructions: Fill in the only the yellow fields:
1. Qualitative Risk Assessment
Identified risk factors
Likelihood
1. Key team members pulled off project
High
2. Chance of economic downturn
Low
3. Project funding cut
Medium
4. Project scope changes
5
Based on the above risk factors and likelihood, how would you rate the consequences (use your own judgement) and offer why.
Consequence
Why?
1
2
3
4
5
For example if you were to classify all risks with a medium consequence, then populate the numbers as follows:
Now that you have the likelihood and consequence for each risk, populate the risk number(s) in the below matrix.
Consequence Consequence
Low Medium High Low Medium High
Likelihood High Likelihood High
1, 4
Medium Medium 3
Low Low
2, 5
2. Risk Mitigation Strategies
From the five risks from above, what would be your suggested risk mitigation approach. Justify your reason for choosing.
Mitigation Approach
2
3
4
5
If you were to prioritize your efforts, which risk factors would you address first? Why?
3. Quantitative Risk Assessment
Assume the following information:
Probability of Failure
Consequences of Failure
Maturity = .3
Cost = .1
Complexity
Schedule = .7
Dependency = .5
Performance = .5
Calculate the overall risk factor for this project:
Pf=
Cf=
RF=
How would you classify this level of risk:
Why:
4. Cost of Labor
Compute the cost of labor for the following team members
Name
Hours Needed
Overhead Charge
Personal Time Rate
Hourly Rate
Fully Loaded Labor Cost
Sandy
6
0
1.35
1.12
$ 1
8
Chuck
80
1.75
$ 31
Bob
$ 9
Penny
40
$ 30
5. Planned and Cumulative Costs
Compute the Plan and Cumulate costs for the project:
Work Package
Budget
Week 1
Week 2
Week 3
Week 4
Week 5
Staffing
$ 500
$ 400
$ 100
Blueprinting
$ 800
$ 600
Prototyping
$ 1,200
$ 200
Full Design
$ 2,400
$ 1,000
Plan:
Cumulative:
6. Complexity Cost Weighting
Consider the data provided below and compute the total estimated of function points
Function
Number of Screens
Input
Output
Interfaces
15
Queries
Files
25
Complexity Weighting
Function Low Medium High
Total
Input
2 x
4 x
6 x
Output
3 x
12 x
Interfaces 6 x 12 x
1
8 x
Queries 4 x 6 x 8 x
Files 2 x 4 x 8 x
Calculate the total expected cost of the project:
Assume that each resource can complete five function points per month and each programmer costs $4,000 per month.
Total Number of Functions:
Total Number of person-months needed:
Total cost for the Project: