| BUS472 Unit 3 Assignment Template |
| 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 | High |
| 5. Poor spec. performance | Low |
| 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 | Why? |
| 1 |
| 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 = .3 | 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 | 60 | 1.35 | 1.12 | $ 18 |
| Chuck | 80 | 1.75 | 1.12 | $ 31 |
| Bob | 80 | 1.35 | 0 | $ 9 |
| Penny | 40 | 1.75 | 1.12 | $ 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 | $ 100 | $ 600 | $ 100 |
| Prototyping | $ 1,200 | $ 200 | $ 800 | $ 200 |
| Full Design | $ 2,400 | $ 400 | $ 1,000 | $ 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 | Complexity |
| Input | 8 | Low |
| Output | 6 | Low |
| Interfaces | 15 | High |
| Queries | 5 | High |
| Files | 25 | Medium |
| Complexity Weighting |
| Function | Low | Medium | High | Total |
| Input | 2 x | 4 x | 6 x |
| Output | 3 x | 6 x | 12 x |
| Interfaces | 6 x | 12 x | 18 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: |
jacknael
BUS472_U3_Assignment_Excel_Template.xlsx
