Unit 3 Assignment: Risk Analysis & Budgeting Using Excel

Excel file is the the template file that is offered for you to work on.

2

>Sheet

1

72 Unit

Assignment Template

High

. Poor spec. performance

Low

1
2
3
4
5
Consequence Consequence
Low Medium High Low Medium High
Likelihood High Likelihood High

Medium Medium 3
Low Low

Why?

1
2
3
4
5

= .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

Function Low Medium High

Input

Output

6 x

Interfaces 6 x 12 x

Queries 4 x 6 x 8 x
Files 2 x 4 x 8 x

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?
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.
1, 4
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
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
Total
	2 x			4 x				6 x
3 x		12 x
1		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: