710 likes | 916 Views
US OP SOX 404 Steering Committee Presentation September 20, 2006. Agenda. Q3 Key Activities 5 min Business Review/Controls at Risk 15 min Segregation of Duties Update 10 min Management Assessment 10 min
E N D
US OP SOX 404Steering Committee Presentation September 20, 2006
Agenda • Q3 Key Activities 5 min • Business Review/Controls at Risk 15 min • Segregation of Duties Update 10 min • Management Assessment 10 min • IT Project Update 10 min • Embedding 5 min • Other Business – Next Meeting 5 min 1 09-20-06
Key Activities for Q3 Sign-off 3 09-20-06
Business Controls At Risk by CoB As of 9/14/2006 DE = 96% Effective OE = 79% Effective 5 09-20-06
OP US SOX 404 – Shell US Without IT – DE 6 09-20-06
OP US SOX 404 – Shell US Without IT – DE Details of Weekly Changes Report - 9/14/06 7 09-20-06
Operating Effectiveness – Round III Testing • 79 existing controls and 15 new controls (estimate) require OE testing (94 total) • 15 Annual controls cannot be tested until 2007 • Plan dependent upon availability of control evidence which is driven by the operational effective date • Testing team plans to test all controls available for testing prior to October 23 Q3 cutoff 8 09-20-06
ISPO CONTROLS – Without IT 9 09-20-06
What remains Status as of August 31, 2006 Excludes Stusco (additional 267 for Stusco not included) Deerpark (65) excluded due to SOX relevance, 2nd priority because they are isolated 11 09-20-06
How we will resolve the remaining • Excludes Stusco – Stusco users with SOD cases and access to 4099 company codes will be evaluated based on the same rigor to ensure system risks are mitigated (in September) • Deerpark excluded due to SOX relevance, 2nd priority because they are isolated • We will consider SODs remediated after Financial Director has signed the compensating control forms or risk waiver. New controls will be added in September 2006 and tested for Q3 sign off. 12 09-20-06
Key Lessons from 2Q PDW and Audit • Improve control valuations • Provide gross balances that tie into SAP/FIRST (proof) • Provide valuations for each compensating control • Confirm compensating control provides supporting assertions • Keep stronger evidence • Start as soon as control failure known • Strengthen key direct company level controls e.g. MJEs, accruals, FIFO, Variance analysis on Accounts and LE to Actual with tolerances • Comprehensive review of all BCIs and non-SOX audits • Strengthen ISP reviews • Awareness of control effectiveness • Awareness of in-house compensating control “Painful to Fail” 14 09-20-06
Q3 Management Assessment - Overview • AoO Sign-off in GreenLight by October 24th • Q3 Changes From Q2 • All controls In-Scope (including compensating controls) must be fully DE & OE tested • No exception granted for: • Remediated/Not Retested • Quarterly • Annual Controls(Once a year controls – no exception)(Year end controls Q4/Q1 – granted exception) • Q3 Sign-off Process Identical to Q2 for: • GreenLight/Non-GreenLight assurance process • Design and operational effectiveness evaluation • Confirmation of design and operating effectiveness for controls operated by ISPs and ESPs • Deficiency Evaluation for Financial Impact using ProcessDeficiency Workbook (includes ISP controls) submitted by Nov 3rd 16 09-20-06
Q3 Management Assessment – Key Activities 17 09-20-06
IAF Audit Status – Lubricants (Round II) • Fair Opinion(combined Business and IT audit) • Findings • High – Sales & Receivables - Verification of price changes is not effective when using a small review sample; Blocked sales orders released without being corrected; Customer Service Representatives can create sales orders and credits; Missing detective control for authorized customer master data changes • Medium – Jiffy Lube sales STATS tool not tested • Medium – Several business testing populations not correct or not verified • Medium – Lubes control references to SOPUS not accurate 19 09-20-06
IAF Audit Status – Lubricants (Round II) • Design Effectiveness • Business & AEC – 40 are effective, 6 are N3 or N5 • IT (C11) – 50 are effective • Operationally Effectiveness • Business & AEC – 9 are effective, 2 are N3 • IT (C11) – 16 are effective, 1 is N3 • Review of Project Testing • Business & AEC – 5 are effective, 6 are TN2, 2 are TN3 • IT (C11) – 10 are effective, 4 are TN2, 3 are TN3 20 09-20-06
DE Status – as of 09/14 22 09-20-06
OE Status – as of 09/14 23 09-20-06
Q3/Q4 Plans 24 09-20-06
Summary/Expectations • Make All Controls Effective • Remediated / Not Retested • New ACD’s to design walk-through & test (FIFO, SOD) • Deficiency evaluation – challenges by FCC & IAF • Limit new controls (No changes preferable) – Follow change approvals • Focus on ISPO Interface Matrix & Pastelink • New monthly ACD’s must operate in September to be tested for Q3. • Relevant BCI’s and non-SOX audits considered for impact to key controls in Greenlight – load test record & fail control until remediated. 26 09-20-06
Embedding Status • SOX Giveaways to Permanent Organization • Confirming numbers with Focal Points • EUC C13 Training – 4 courses scheduled • September 21, 26 (2), 28 • Audience approximately 50+ attendees • Knowledge Survey • Retakes are in progress and scheduled to be complete 9/22 • Scores on retakes 70% and below went out to individuals 9/15 • Daily updates being sent on unsuccessful retakes • Everyone will receive scores after 9/22 deadline 28 09-20-06
Motiva Agenda • Business Review/Controls At Risks • Internal Audit 31 09-20-06
Business Controls At Risk by CoB As of 9/14/2006 DE = 95% Effective OE = 85% Effective 33 09-20-06
OP US SOX 404 – Motiva Without IT – DE 34 09-20-06
OP US SOX 404 – Motiva Without IT – DE Details of Weekly Changes Report - 9/14/06 35 09-20-06
Operating Effectiveness – Round III Testing • 20 Motiva controls require OE testing • 3 controls cannot be tested until 2007 • 11 of the remaining 17 controls are quarterly awaiting confirmation for 2nd quarter test • Testing substantially complete by 10/20/06 36 09-20-06
ISPO CONTROLS – Without IT 37 09-20-06
Motiva Internal Audit Update VERBAL UPDATE – LINDA LARSON 39 09-20-06
Action Item Log Overview • Open Action Items • 1 open item remains • Closed Items • 3 closed items from last meeting • 157 items have been closed 43 09-20-06
Open Action Items 44 09-20-06
Closed Action Items 45 09-20-06
‘06 Estimates – Comparison – Staff (Without IT) '06 Actual Staff Count by Month '06 January 85 ’06 June 77 '06 February 84 ‘07 July 72 ’06 March 84 ’08 August 62 ’06 April 76 ’06 May 80 '06 Year-End Staff Count Planned '06 T&R 20 FTE '06 LE 20% + Remediation 45 FTE '06 LE 40% Remediation 48 FTE 47 09-20-06
‘06 Estimates – Comparison – Staff – With Regional IT '06 Actual Staff Count by Month '06 January 108 ’06 June 104 '06 February 107 ‘07 July 102 ’06 March 102 ’08 August 91 ’06 April 98 ’06 May 103 48 09-20-06
‘06 Estimates – Comparison – Staff – With Total IT '06 Actual Staff Count by Month '06 January 133 ’06 June 132 '06 February 132 ‘07 July 130 ’06 March 130 ’08 August 114 ’06 April 127 ’06 May 133 49 09-20-06