Statistical Process Control Methods

User Generated

ne3mbb1986

Business Finance

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.

Assignment Steps

Resources: Microsoft® Excel® and PowerPoint®

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 consistent with APA guidelines.

This assignment is 3 parts

1. Excel

2. Power Point

3. Word document with a minimum 525 words

Reference minimum 3

APA format and in-text citation

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hello. I have attached the answer. kindly confirm, thanks

The Statistical control project
application in a business model
practice
The Control Charts

Control Chart
Actual and Ideal Distributions comparisons
1
0.9
0.8
0.7
0.6
0.5
0.4
0.3
0.2
0.1
0
300

400

500

Actual

600

Ideal

700

Formulas used for the Calculation of
Process Capability such as Variation
• Process Capability

Process Capability Index


application of Statistical Process Control Methods to a business process
calculation of the defined process metrics including variation and process capability.

VARIABLES
Target
USL

500
600

LSL

400

Data

538
553
531
513
519
516
507
s=USL-LSL/12
532
540
554
492
Value
518
400
554 416,66667
510 433,33333
516
450
466,66667
483,33333
500
516,66667
533,33333
550
566,66667
583,33333
600

Cp =
K=
Cpk =
or Cpk =

1,772 Goal is Cp = 2
-0,262 Goal is K = 0

Control Charts

2,237 Goal is Cpk = 2
1,308 smallest

Comparison of Actual and Ideal D
Cp = (USL_LSL)/6 sigma
K = (target - mean)/(USL-LSL)/2
Cpk = smallest of :{(mean - LSL)/3sigma or
(USL - mean)/3sigma}
mean
526,20
sigma
18,81
s=USL-LSL/12
16,67 Cp=2.0

1
0,9

0,8
0,7
0,6
0,5

Actual
1,472E-10
3,806E-08
4,486E-06
0,0002411
0,0059048
0,0659435
0,3357393
0,7792882
0,8246312
0,3978205
0,0874944
0,0087728
0,000401

Ideal
Target
1,515E-08
USL
3,713E-06
LSL
0,0003347
0,011093...


Anonymous
Excellent! Definitely coming back for more study materials.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags