Description
Purpose of Assignment
The purpose of this assignment is for students to learn how to apply Statistical Process Control Methods to a business process.
Resources
Microsoft® Excel® and PowerPoint®
Assignment Steps
Select a complex continuous process from your personal life or work. The process can be the same as in Week 1 assignment.
Complete the following:
- Use Microsoft® Excel® to calculate the defined process metrics including variation and process capability.
- Use Microsoft® Excel® and PowerPoint® to develop and display a control chart for the process.
Evaluate the control chart and process metrics using Statistical Process Control (SPC) methods.
Evaluate whether the process could benefit from the use of Six Sigma tools.
Develop a 525-word executive summary in which you describe your Statistical Process Control project and include the control chart with SPC.
Format your assignment according to APA guidelines.
Submit your assignment.
NOTE: For this assignment you will turn in the following:
1.525-word executive summary in APA format.
- Evaluate the control chart and process metrics using Statistical Process Control (SPC) methods.
- Evaluate whether the process could benefit from the use of Six Sigma tools.
2.Microsoft® Excel® chart showing process metrics including variation and process capability.
3. Microsoft® Excel® and PowerPoint® showing your control chart for the process.

Explanation & Answer

Attached.
Statistical Process Control Methods
I.
II.
Executive Summary
Complex Continuous process
III.
Process Metrics
IV.
Process Control
V.
VI.
Process Control Chart
Determination if Process could benefit from Six Sigma
Statistical Process Control Methods
Pine Health
Client Account Manager Process
Presented by:
Institutional Affiliation:
Process Control Background
✓ The process under control assessment is the client account manager process in enhancing
customer relationship at Pine Health with an objective of reducing the response time taken
by the provide feedback.
✓ The measuring metric include
➢ Overall time-taken between a client making an individual request and receiving feedback
from the organization.
Control Chart and Process Capability
Process Capability
Upper Specification Limit
60
Lower Specification Limit
5
Standard deviation
4
Process Capability= (USL-LSL)/6ơ
Process capability index
2.29
Remarks
✓ Based on the chart the process
is in control because the
inspection time lies between
the upper and lower control
limits.
✓ The process capability index is
2.29 greater than one; thus, the
process is in control.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Average time
Date
5.10.2019
5.10.2019
5.10.2019...
