Audit Work Progress

!

-'

-

- $

,

#

#*

6

=#

#

$

$

. 6

# $ %

$

7

+

, % 4

2

&

&

5

5

2

2

5

2

<

+
2

&

>

5

5

(

5

&

2

! 6, * *-

30

&

!.!-

! $

2

(

&

2

"# $ %

* *

*,

!- # 8

# $ %

#+ # -

! 9+# !!

: ,* 7 *,

<#

;

!

'

"# $ %

* + #7*,8 , #-0/ !-

#

!0* !0

! ;

9

*

*-. *

*) #!

-#

# +6

+

1

#6*! - # *,

!* + . /0

+

'

,- #+#*! # ,-

)*+

!

,!

,!

,!

Status Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

(based on TeamMate time entries)
Status Legend: E-- exited with the Committee; O -- ongoing; NS -- not started; FC--field work complete

Internal Audit Department
Calculation of Remaining Audit Resources in 2011

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
Internal Auditor 2
Internal Auditor 3
Senior Auditor 1
Senior Auditor 2 *
Performance Auditor 1 *
Audit Manager

450
450
450
450
450
450
225

Subtotal
less
*8 weeks to fill Senior Auditor Position #2
* New position effective July 2011

2,925

Estimated Total Available Audit Resources
(in hours) from Sept. thru December 2011

2,700

"a"

Original Work Plan Audit Hours
Consumed thru August 2011
Remaining per the original 2011 work plan

8,900
5,500
3,400

"b"

shortage of the originally planned hours (see
"b") as compared to the estimated remaining
resources available (see "a")

(700)

"c"

(225)

Based on the estimated shortage (see "c"), we recommend carrying forward approx. 2 to 3
audits to the 2012 work plan.