Status Legend:
E
-- exited with the Committee
;
O -- ongoing
;
NS -- not started;
FC--field work complete
Status
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
!"#$%
"#$%
&
'
(
)*+'
,-#+#*!#,-#
!*+./01
2 &
!$30,%4
5
#6*!-#*,!#*
2
#+6*+#7*,8,#-0/!-
& 5
,!
-#!9+#!!
2
*)#!
2
##$%
& 5
,!
*-.*,!-#8
*:,*7*,#+#-
9**
2
!.!-!6,**-*,
2
2 &
!;#$%
& 5
,!
!0*!0.67
(
+
;$++
2
+
$$
#
5
<#
-$<
5
-'=#
>
!-6
Audit Work Progress
(based on TeamMate time entries)
Assumptions
1. 16 weeks remaining in the year (Sept. thru Dec.)
2. 25% administrative (training, vacation, sick, holiday, etc)
3. audit manager at 50% for audit work
Internal Auditor 1 450
Internal Auditor 2 450
Internal Auditor 3 450
Senior Auditor 1 450
Senior Auditor 2
*
450
Performance Auditor 1 * 450
Audit Manager 225
Subtotal 2,925
less
*
8 weeks to fill Senior Auditor Position #2
(225)
* New position effective July 2011
Original Work Plan Audit Hours 8,900
Consumed thru August 2011 5,500
Remaining per the original 2011 work plan
3,400
"b"
Based on the estimated shortage (see "c"), we recommend carrying forward approx. 2 to 3
audits to the 2012 work plan.
Internal Audit Department
Calculation of Remaining Audit Resources in 2011
Estimated Total Available Audit Resources
(in hours) from Sept. thru December 2011
2,700
"a"
shortage of the originally planned hours (see
"b") as compared to the estimated remaining
resources available (see "a")
(700) "c"
