Statistics Process Improvement Project PPT?

Dr Jesus

Process_Improvement_Project_Requirements_122017-2.ppt

Home >Mathematics homework help >Statistics homework help >Statistics Process Improvement Project PPT?

Process Improvement Project

Project Selection Criteria:

Select an issue or opportunity that can be written as a problem statement.
Must be within your sphere of influence.
Is not an attempt to solve world hunger.
Uses data that is accessible to you or can be collected in a reasonable amount of effort/time.
You have the ability to measure the current and future state. You have access to baseline data or can collect it.
Preferably uses more continuous data (rather than all discrete data).
Fixing this problem will provide value. You should develop a business case to support working this issue (consider your time and others when calculating ROI.)

Examples:

Improve product quality

Reduce expenses

Improve the output of your organization

Decrease wait time

Page 1

1) Executive Summary :: Storyboard (should be presented in 1 PowerPoint slide)

Follow the DMAIC steps
Include the problem statement and baseline
Utilize at least 5 different tools/techniques (present relevant key tools to best tell your story).
Be readable; summarize and condense exhibits where necessary
Use arrows, call out boxes, and balloons to highlight questions and key learnings
Display data/charts supporting your findings and conclusions
Show results or expected results

Process Improvement Project

-Requirements-

Page 2

The final submission should be 1 file, in slide format, created in PowerPoint.

It should include 2 parts:

Executive summary slide – 1 slide Storyboard (specific requirements below).

2) Back-up slides – additional 5-15 slides (specific requirements pgs. 3-4). This is not a repeat/copy of your storyboard. The back-up slides should detail and support the content of your storyboard.

*************************************************************************************************************

2) Back-up slides - following the Storyboard include 5-15 slides containing the answers to the following questions.

DEFINE

What is your goal? How will you know if you’ve been successful?
Have clear operational definitions been established for your inputs and outputs?
What is the process you’re trying to improve? What are the current steps of the process?

MEASURE

Include your Data Measurement Plan or Data Stratification Tree (examples on pgs. 5-6).
What type of data did you collect (cost, cycle time, changeover time, yield, machine utilization, scrap, rework, defects, inventory)?
Was that data continuous or discrete?
Did you collect your own data or did you use existing data?
How much data did you collect and why? What is your ideal sample size using the sample size formula? What is the risk if you collected fewer samples?
How was your data collected? Describe the methods you used to collect it.
Where could you have measurement error? How much measurement error do you have? What could you do to minimize your measurement error?

Process Improvement Project

-Requirements-

Page 3

2) Back-up slides continued:

ANALYZE

What tools did you use to analyze the data? (Utilize at least 5 different tools/techniques and show evidence and detail of the tool/technique).
What is the data telling you? What did you discover?
What is the SQL for the old and new process?

IMPROVE

What solutions did you propose and/or implement? Did you successfully improve your process? What did you learn about your process?

CONTROL

How will you use this information to “hold the gains” of your improvement or make the next round of improvements in your process?

Process Improvement Project

-Requirements-

Page 4

Data Stratification Tree

Questions About Process

Stratification factors

X Variables

Measurements

New Orders

Time of year (mo.)

Training

Skill level

Wait time

(Output Y)

Does the Sales Rep have the right skills to improve selling more orders?

Are orders impacted by the sales rep skill-levels (systems, product, pricing, listening, ability to follow the process)?

Pricing Issue

Customer attitude

No.of backorders

Do new orders vary by month ?

% of orders per Sales Rep by skill level type
average & range of Sales Rep skill levels

What % of the calls are order related?

Do new orders change by the receptiveness of the customer?

Are orders impacted by call wait time?

Are orders impacted by pricing issues?

Are orders impacted by whether or not the Sales Rep follows the written process?

Do new orders vary by the availability of the product (not on backorder)?

Type of call

Written process

% type of call

wait time for each call

customer attitude rating by order type

% of calls transferred to OB due to pricing issues

mystery call /silent monitoring results (points per call)

% of orders resulting in backorders

total orders placed by month
% new orders are of total orders
% new order revenue of total revenue by month

no. of hours of training per month

Are orders impacted by call duration?

Call duration

Average call duration for xyz order vs. other orders

Do the current targets impact orders?

Target settings (calls, orders, revenue)

calls, orders, total rev, rev per mo. per Sales Rep

Page 5

Data Measurement Plan

Performance Measure

Data Source and Location

Target

Sample

Size

Who Will Collect

Data

When Will Data Be Collected

How Will Data Be Collected

% type of call

No. of inbound calls per day

order revenue per Sales Rep per month

Total revenue per month

Revenue per month by product type

Manual data collection

Susie

Develop rating scale & assess performance

John’s training spreadsheet

Use data collection form

Manual data collection

Manual data collection

Manual data collection

IB performance reports

Susie

Use data collection form

Use data collection form

Use data collection form

Use data collection form

John

5/11-6/2

5/20

5/12

1000 calls

500 orders

Pull from report

Leanne

By 6/3

28 mo

5/11 - 6/2

tbd

5/11 - 6/2

Manual data collection

Manual data collection

tbd

Monthly mystery call results

Leanne

By 6/3

Compile Pamela’s data

500 orders

12 mo

28 mo

28mo

28 mo

Leanne

ytd

Obtain from other team

Aspect reports

Leanne

% of orders per Sales Rep by skill level type
average & range of Sales Rep skill levels

wait time for each call

customer attitude rating by order type

% of calls transferred to OB due to pricing issues

mystery call /silent monitoring results (points per call)

% of orders resulting in backorders

total orders placed by month
% new orders are of total orders
% order revenue of total revenue by month

no. of hours of training per month

Average call duration for new order vs. other

calls, orders, total rev, per Sales Rep per month

N/A

IB performance reports

Pull from report

Susie

By 6/3

28 mo

IB performance reports

Pull from report

IB performance reports

Pull from report

IB performance reports

Pull from report

SN report

Pull from report

By 6/3

Susie

Susie

Susie

By 6/3

Page 6

DEFINE

MEASURE

Name of your project

Team

Launch

Define

Measure

Analyze

Control

Improve

Key Dates --->

ANALYZE

IMPROVE

Process owner: or your Name

Storyboard

template

CONTROL

Page 7

Process Improvement Project

-Rubric-

Page 8

Content Requirements	Possible Points
A) An executive summary is provided in the storyboard format including: Is the storyboard presented in 1 PowerPoint slide? Follows DMAIC? Are tools/graphs/charts used and clearly visible? Do they support findings and conclusions Are arrows, call-out boxes, etc. used to summarize, highlight questions and key learnings? Are expected results clear? And next steps noted?	5.0
B)Is it a cohesive presentation opening with the business process and problem statement? The back-up slides (5-15) detail and support the storyboard content.	2.0
C) Was the success measure clearly identified, operationally defined and baseline identified? (Was the data identified as continuous or discrete, includes SQL?)	3.0
D) Was the data measurement plan or data stratification tree included?	1.0
E) Was the data collection method identified?	1.0
F) Was there rationale for the sample size taken? Use of the formula? Is there any reference to measurement error and how to minimize?	1.0
G) Are at least 5 different tools and techniques clearly identified? Are the tools linked/ pertinent to the data analysis?	5.0
H) Does the data analysis clearly tie to the problem conclusion? Is the “discovery” clear to the reader?	2.0
Total	20