six sigma project final
TRANSCRIPT
Copyright © 2015 Raytheon Company. All rights reserved. Customer Success Is Our Mission is a registered trademark of Raytheon Company.
R6s Specialist Project: Profit Impact Reporting
Kristin PerezFinancial Analyst I, FP&ASecure Sensor Solutions
2
Visualize
3
Problem and Opportunity StatementsProblem Statement:SAS and S3 are experiencing inconsistencies in the profit impact reporting process.
Opportunity Statement:A standard process for profit impact reporting that yields consistent results.
Visualize
4
Commit
5
Sponsor:Eric Del Ricci
Let’s Talk CommitmentCommit
Resources:1) Mike Strollo2) Scott Killian
6
Prioritize
7
Current State: Process Flow Diagram
S3 SAS
Prioritize
Data Retrieval:- CART- EDIT+
Data Scrubbing:-Remove pending items-Remove rejected items-Remove inventory items
Upper level management requests
weekly profit impact results
Analyst organizes data and sends to
Sr. Analyst for review of accuracy
Analyst emails data to team and upper
management for review
Quarterly profit impact results are formally
submitted
Analyst submits results
Data Retrieval:- CART- EDIT+- CSR
Data Scrubbing:-Remove pending items-Remove rejected items-Remove inventory items-Remove Complete Flags
8
Current State: Data Retrieval Process
Prioritize
S3
SAS
DELTA
EDIT + CART
$1.5M$29.9M
$0
$29.9M $1.5M
$0
Inconsistency is NOT a result of data retrieval process
9
Current State: Data Scrubbing ProcessPrioritize
Process inconsistency is due to data scrubbing approach
EDIT + CART CSR
S3
SAS
DELTA
$1.4M
$1.9M$29.9M
$1.0
$28.9M
$0.5M $2.7M
$2.7M
N/A
10
Characterize
11
Fishbone Diagram: Causal Analysis
PEOPLE PROCESS
TOOLS
New employee
Complete Flag items removed by SAS, but not S3 (CART)
Additional system tool is being utilized by SAS, but not S3
(CSR)
SAS manipulated EDIT+ data
whereas S3 did not
Lack of communicationData scrubbing
process is driving
inconsistencies
Characterize
C = constantN = noiseX = variable
CX X
X
X
12
Improve
13
Impact Matrix
LL
H
H
Effo
rtImpact
CART and EDIT+ Data Scrub Processes
CSR Process
Improve
Priorities were established based on impact and effort required
Primary Focus
14
Improvement RecommendationsImprove
S3
SAS
SAS & S3
- Implement removal of Complete Flags (CART)
- Implement data retrieval comparison (EDIT+)
- Institute quarterly reconciliation to ensure consistency going forward
15
Future State: Process Flow Diagram
Data Retrieval:- CART- EDIT+
Data Scrubbing:-Remove pending items-Remove rejected items-Remove inventory items
Upper level management requests
weekly profit impact results
Analyst organizes data and sends to
Sr. Analyst for review of accuracy
Analyst emails data to team and upper
management for review
S3 SAS
Improve
Quarterly profit impact results are formally
submitted
Analyst submits results
Data Retrieval:- CART- EDIT+- CSR
Data Scrubbing:-Remove pending items-Remove rejected items-Remove inventory items-Remove Complete Flags
Analyst removes Complete Flag items
as part of new process
NEW
16
Achieve
17
NO DELTAS
Consistency Is The End GoalAchieve
1) Measurable Change Implemented: As a result of process modification, there is no delta in the EDIT+ and CART data scrubbing process for Q1
2) Next Steps: Investigate implementation of the CSR tool (next priority)