Case Problem 4 Data File needed for this Case Problem: Quality.xlsx Karleton Manufacturing Carmen…
Case Problem 4
Data File needed for this Case Problem: Quality.xlsx
Karleton Manufacturing Carmen Garza is a quality control
manager at Karleton Manufacturing, a
manufacturing plant located in Trotwood, Ohio. One project
that Carmen oversees is the manufacture
of tin cans for a major food company. The can widths must be
consistent. To compensate for the fact
that metal working tools tend to wear down during the day,
the pressure behind the tools is increased
as the blades become worn. Quality control technicians
monitor the process to check that it remains
in control creating cans
Case Problem 4
Data File needed for this Case Problem: Quality.xlsx
Karleton Manufacturing Carmen Garza is a quality control
manager at Karleton Manufacturing, a
manufacturing plant located in Trotwood, Ohio. One project
that Carmen oversees is the manufacture
of tin cans for a major food company. The can widths must be
consistent. To compensate for the fact
that metal working tools tend to wear down during the day,
the pressure behind the tools is increased
as the blades become worn. Quality control technicians
monitor the process to check that it remains
in control creating cans whose widths are neither too
narrow nor too wide. Carmen has recorded the
widths of four cans from 39 batches in an Excel workbook
that she wants to use to determine whether
the process is in control. One standard for determining
whether a process is in control is whether
the average value from a process batch falls within the
lower and upper control limits. The workbook
itself is in need of quality control as some of the formulas
are not calculating correctly. You will fix
these and then enter the remainder of the formulas needed in
the worksheet. Complete the following:
1. Open the Quality workbook located in the Excel3 _
Case4 folder included with your Data Files,
and then save the workbook as Quality Control Analysis in
the location specified by your instructor.
