Operations Management Problem Solutions
Budget: $30 – $250 USD
Please complete the following problems from Chapter 3
Hint: LCL cannot be negative. if it is negative, adjust to zero.
Chapter 3:
Problem 4
Problem 12
Problem 19
Problem 24 - use the data to calculate Cpk and Cp (standard deviation is 0.05667). Is this process capable of meeting the design standard at a four-sigma level? Explain.
Problem 25 a only, (Hint, calculate both cpk and cp).
Please show all your calculations (not only answers). Highlight answer please
The Excel file below has data for your problems (go to the question chapter tab, copy and paste to your own Excel sheet or Word document). Do not solve in the given Excel sheet.
Data from Excel for homework,
The Excel file below contains data for your problems (please refer to the relevant chapter tab, copy and paste the data into your Excel sheet). Do not solve in the given data Excel sheet. Please show steps to the answers, not only the answers.
Direct formula (i may have not used direct formula). See my Excel sheets.
C Chart formula, copy and paste it to Excel and include numbers
Calculate UCL:
Formula: =center_line + 3*SQRT(center_line).
Calculate LCL:
Formula: =MAX(0, center_line - 3*SQRT(center_line))
P chart, copy and paste it to Excel and include numbers
UCL = p-bar + 3 * sqrt((p-bar * (1 – p-bar)) / n)
LCL = p-bar – 3 * sqrt((p-bar * (1 – p-bar)) / n)
X bar R char formula, copy and paste it to Excel and include numbers
X-bar chart UCL = X̄ + A₂R̄ and LCL = X̄ - A₂R̄; R chart UCL = D₄R̄ and LCL = D₃R̄.C Chart formula, copy and paste it to Excel and include numbers
Calculate UCL:
Formula: =center_line + 3*SQRT(center_line).
Calculate LCL:
Formula: =MAX(0, center_line - 3*SQRT(center_line))
P chart, copy and paste it to Excel and include numbers
UCL = p-bar + 3 * sqrt((p-bar * (1 – p-bar)) / n)
LCL = p-bar – 3 * sqrt((p-bar * (1 – p-bar)) / n)
X bar R char formula, copy and paste it to Excel and include numbers
X-bar chart UCL = X̄ + A₂R̄ and LCL = X̄ - A₂R̄; R chart UCL = D₄R̄ and LCL = D₃R̄.
nterpreting Cp:
Cp < 1 – Process is not capable, output frequently outside specification limits
Cp = 1 – Process is just barely capable, 99.73% of output within specification limits
Cp > 1 – Process is capable, 99.73% of output within specification limits
Cp > 1.33 – Process is highly capable, with 99.99% of output within specification limits
Interpreting Cpk:
Cpk < 1 – Process is not capable, output frequently outside specification limits
Cpk = 1 – Process is just barely capable, 99.73% of output within specification limits
Cpk > 1 – Process is capable, 99.73% of output within specification limits
Cpk > 1.33 – Process is highly capable, with 99.99% of output within specification limits
Hint: LCL cannot be negative. if it is negative, adjust to zero.
Chapter 3:
Problem 4
Problem 12
Problem 19
Problem 24 - use the data to calculate Cpk and Cp (standard deviation is 0.05667). Is this process capable of meeting the design standard at a four-sigma level? Explain.
Problem 25 a only, (Hint, calculate both cpk and cp).
Please show all your calculations (not only answers). Highlight answer please
The Excel file below has data for your problems (go to the question chapter tab, copy and paste to your own Excel sheet or Word document). Do not solve in the given Excel sheet.
Data from Excel for homework,
The Excel file below contains data for your problems (please refer to the relevant chapter tab, copy and paste the data into your Excel sheet). Do not solve in the given data Excel sheet. Please show steps to the answers, not only the answers.
Direct formula (i may have not used direct formula). See my Excel sheets.
C Chart formula, copy and paste it to Excel and include numbers
Calculate UCL:
Formula: =center_line + 3*SQRT(center_line).
Calculate LCL:
Formula: =MAX(0, center_line - 3*SQRT(center_line))
P chart, copy and paste it to Excel and include numbers
UCL = p-bar + 3 * sqrt((p-bar * (1 – p-bar)) / n)
LCL = p-bar – 3 * sqrt((p-bar * (1 – p-bar)) / n)
X bar R char formula, copy and paste it to Excel and include numbers
X-bar chart UCL = X̄ + A₂R̄ and LCL = X̄ - A₂R̄; R chart UCL = D₄R̄ and LCL = D₃R̄.C Chart formula, copy and paste it to Excel and include numbers
Calculate UCL:
Formula: =center_line + 3*SQRT(center_line).
Calculate LCL:
Formula: =MAX(0, center_line - 3*SQRT(center_line))
P chart, copy and paste it to Excel and include numbers
UCL = p-bar + 3 * sqrt((p-bar * (1 – p-bar)) / n)
LCL = p-bar – 3 * sqrt((p-bar * (1 – p-bar)) / n)
X bar R char formula, copy and paste it to Excel and include numbers
X-bar chart UCL = X̄ + A₂R̄ and LCL = X̄ - A₂R̄; R chart UCL = D₄R̄ and LCL = D₃R̄.
nterpreting Cp:
Cp < 1 – Process is not capable, output frequently outside specification limits
Cp = 1 – Process is just barely capable, 99.73% of output within specification limits
Cp > 1 – Process is capable, 99.73% of output within specification limits
Cp > 1.33 – Process is highly capable, with 99.99% of output within specification limits
Interpreting Cpk:
Cpk < 1 – Process is not capable, output frequently outside specification limits
Cpk = 1 – Process is just barely capable, 99.73% of output within specification limits
Cpk > 1 – Process is capable, 99.73% of output within specification limits
Cpk > 1.33 – Process is highly capable, with 99.99% of output within specification limits