| 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: |
Trayvon1996
BUS472_U3_Assignment_Excel_Template.xlsx
