Excel Sheet For Audit Planning
Comp T'put Value Stability Mngmnt Control Time Env Since Last Audit Weighting assigned in the planning phase 2 2
Views 97 Downloads 3 File size 41KB
Recommend stories
- Author / Uploaded
- Dennis Bacay
Citation preview
Comp
T'put
Value
Stability Mngmnt
Control Time Env Since Last Audit
Weighting assigned in the planning phase
2
2
2
4
3
4
4
ENTITIES Finance Marketing Engineering HR IT Sales
3 1 3 2 3 2
2 2 2 1 3 2
3 2 3 1 3 3
2 2 1 3 3 2
2 2 2 2 2 2
3 2 3 1 1 1
2 2 2 2 2 2
In the above examples, each function in the portfolio is assessed against each of the Planning 1-3, where 1 = low/good and 3 = high/bad. So, Finance is "high" when it comes to complexity, Any value system could be used. So, multiplying each function by its weighting and the weighting given to each Planning Criteria score; so for Finance 3*2+2*2+3*2+2*4+2*3+3*4+2*4 = 50. Risk Estimated Cumulative Score Mandays Mandays Finance IT Engineering Marketing Sales HR
50 48 46 40 40 38
30 40 60 20 50 20
70 130 150 200 220
Risk Score
50 40 46 38 48 40