Question
Recently Georgian Chemical customers have complained regarding the sulphate content of one of the companys products. Every customer allows some sulphate content, but theoretically there
Recently Georgian Chemical customers have complained regarding the sulphate content of one of the companys products. Every customer allows some sulphate content, but theoretically there should be none. The usual customer specification is 90 parts per million (ppm) sulphate. The quality control department at Georgian Chemical feels that there is no problem with sulphate content, which has been averaging approximately 50 ppm. The production department estimates that a substantial investment would be required to lower the amount of this contaminant. These two departments, after consulting with the marketing department and customers, suggest that a control chart be set up to monitor sulphate content. Five samples were tested each day for the month of September, with the results included in the file: Georgian Chemical Sulphate Data.xlsx. The September data is to be used to establish control limits for this process (note: from historical data, Georgian Chemical knows that the process standard deviation is 12.87 ppm). With the control limits in place, Georgian continues to monitor the proces s for the first 10 days of October, with results also included in the file: Georgian Chemical Sulphate Data.xlsx. Your Tasks 1. Develop an x-chart for the average sulphate level: Use September and historical data to determine the process average and control limits (use 3-sigma). Plot the actual results for October on the control chart. Determine if the process is in-control or out-of-control. Prepare the chart and associated data analysis in Excel. 2. Develop an R-chart for the range of sulphate levels: Use September data to determine the average range and control limits (refer to Table 3.1 in the textbook Chapter 3). Plot the actual results for October on the control chart. Determine if the process is in-control or out-of-control. Prepare the chart and associated data analysis in Excel. 3. Prepare a written report on sulphate levels at Georgian Chemical. The report should include: A clear description of the issue being evaluated. A clear description on the approach used to analyze the issue. Images of the 2 control charts noted above. A clear response to the question: does the process remain in-control in October? Commentary to support your conclusion. 4. Please note this additional guidance: Your report should be prepared as a standalone document, meaning your analysis and conclusions should be complete and clear without needing to refer to the Excel file. The Excel file must also to be submitted, but will only be checked to ensure that you have used the correct approach in your analysis. Ensure the control charts are clearly and appropriately labeled (title and each axis), including units of measure as appropriate.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started