Question
SPC CASE ANALYSIS: AMERICO DRILLING SUPPLIES MGT 3332 Spring 2017 On November 1, 2013 John Adams, a customer service representative of Americo Drilling Supplies (ADS),
SPC CASE ANALYSIS: AMERICO DRILLING SUPPLIES
MGT 3332 Spring 2017
On November 1, 2013 John Adams, a customer service representative of Americo Drilling Supplies (ADS), was summoned to the Houston warehouse of Drilling Contractors, Inc. (DCI), to inspect three boxcars of mud-treating agents that ADS had shipped to the Houston firm. DCI had filed a complaint that the 25 Pound bags of treating agents that it had just received from ADS were short-weight by approximately 5%.
The light-weight bags were initially detected by one of DCIs receiving clerks, who noticed that the rail road side scale tickets indicated that the net weights were significantly less on all three of the boxcars than those of identical shipments received on October 25, 2013. ADSs traffic department was called to determine if lighter-weight dunnage or pallets were used on the shipments. (This might explain the lighter weights.) ADS indicated, however, that no changes had been made in the loading or palletizing procedures. Hence, DCI randomly checked 25 of the bags and discovered that the average net weight was 24.5 pounds. Consequently, they concluded that the sample indicated a significance short-weight. ADS, was then contacted, and Adams was sent to investigate the complaint and to estimate credit to DCI.
DCI, however, was not completely satisfied with only the issuance of credit for the short shipment. The charts followed by their mud engineers on the drilling platforms were based on 25-pound bags of treating agents. Lighter-weight bags might result in poor chemical control during the drilling operation and might adversely affect drilling efficiency. (Mud-treating agents are used to control the pH and other chemical properties of the open during drilling operations.) This could cause severe economic consequences because of the extremely high cost of oil and natural gas well-drilling operations. Consequently, special use instructions had to accompany the delivery of these shipments to the drilling platforms. Moreover, the light-weight shipments had to be isolated in DCI warehouse, causing extra handling and poor space utilization. Hence, Adams was informed that CDI might seek a new supplier of mud-treating agents if in the future it received bags that deviated significantly below 25 pounds.
The quality control department at ADS suspected that the light-weight bags may have resulted from growing pains at the Orange plant. Because of the earlier energy crises, oil and natural gas exploration activity had greatly increased. This increased activity, in turn, created increased demand for products produced by related industries, including drilling muds. Consequently, ADS had to expand from one shift (6 A.M. to 2 P.M.) to a two-shift (2 P.M. to 10 P.M.) operation in Mid 2011s, and finally to a three-shift operation (24 hours per day) in January of 2013.
The additional night shift bagging crew was staffed entirely by new employees. The most experienced foremen were temporarily assigned to supervise the night shift. Most emphasis was placed on increasing the output of bags to meet the ever-increasing demand. It was suspected that only occasional reminders were made to double-check the bag weight feeder. (A double check is performed by systematically weighting a bag on a scale to determine if the proper weight is being loaded by the weight-feeder. If there is significant deviation from 25 pounds, corrective adjustments are made to the weight-release mechanism.)
To verify this expectation, the quantity control staff at ADS randomly sampled the bag output and prepared the following table. Five bags were sampled and weighted each hour.
ANALYSIS
Assume you are John Adams of ADS. Based on the following analysis, prepare a report to be submitted to both ADS and DCI executives regarding the status of the filling process at ADS and recommend method to improve quality control at the filling station. Use the data provided in the Excel data file.
SPC Data Set
n= 5 | Morning | |||||
Samples of size 5 were taken to find X-bar | Afternoon | |||||
Night | ||||||
Sample # | Time | Average (X-bar) | Smallest | Largest | ||
1 | 6:00 AM | 25.2 | 24.7 | 25.7 | ||
2 | 7 | 25.4 | 24.1 | 26.2 | ||
3 | 8 | 25.2 | 24.6 | 26.4 | ||
4 | 9 | 25.5 | 25.2 | 26.1 | ||
5 | 10 | 25.1 | 24.2 | 26.3 | ||
6 | 11 | 25.5 | 24.6 | 26.7 | ||
7 | 12 Noon | 25.1 | 24.5 | 25.4 | ||
8 | 1:00 PM | 25 | 24.5 | 25.4 | ||
9 | 2 | 24.7 | 23.9 | 25.6 | ||
10 | 3 | 25.1 | 23.9 | 25.8 | ||
11 | 4 | 24.5 | 24.2 | 26.3 | ||
12 | 5 | 24.7 | 23.9 | 26.3 | ||
13 | 6 | 24.8 | 24.2 | 25.7 | ||
14 | 7 | 24.4 | 24 | 25.3 | ||
15 | 8 | 25 | 23.6 | 26.2 | ||
16 | 9 | 24.8 | 24.4 | 27.4 | ||
17 | 10 | 23.9 | 22.9 | 24.7 | ||
18 | 11 | 24.2 | 23.9 | 25.8 | ||
19 | 12 Mid Night | 23.9 | 23.1 | 25.2 | ||
20 | 1:00 AM | 23.7 | 22.6 | 24.7 | ||
21 | 2 | 23.8 | 22.7 | 24.6 | ||
22 | 3 | 23.9 | 22.8 | 24 | ||
23 | 4 | 23.5 | 22.5 | 24.1 | ||
24 | 5 | 24.1 | 22.1 | 24.6 | ||
25 | 6 | 25 | 24.6 | 25.1 | ||
26 | 7 | 25.2 | 24.2 | 26.1 | ||
27 | 8 | 25 | 24 | 25.5 | ||
28 | 9 | 25 | 24.4 | 26.7 | ||
29 | 10 | 25.1 | 24.6 | 26.8 | ||
30 | 11 | 25.2 | 24 | 26.3 | ||
31 | 12 Noon | 25.2 | 23.8 | 26.4 | ||
32 | 1:00 PM | 25.3 | 24.4 | 26.1 | ||
33 | 2 | 24.9 | 23.6 | 26 | ||
34 | 3 | 24.6 | 23.8 | 26.7 | ||
35 | 4 | 24.4 | 23.7 | 25.9 | ||
36 | 5 | 24.7 | 23.9 | 25.1 | ||
37 | 6 | 24.5 | 23.2 | 26.2 | ||
38 | 7 | 24.6 | 24.1 | 26.7 | ||
39 | 8 | 24.2 | 23.2 | 24.9 | ||
40 | 9 | 24.4 | 24.2 | 25.1 | ||
41 | 10 | 24.4 | 23.6 | 25.2 | ||
42 | 11 | 23.8 | 23.1 | 25 | ||
43 | 12 Midnight | 24.1 | 23.2 | 25.4 | ||
44 | 1:00 AM | 23.8 | 23.4 | 26.7 | ||
45 | 2 | 23.6 | 23 | 25.2 | ||
46 | 3 | 24.5 | 23.4 | 25 | ||
47 | 4 | 23.4 | 22.7 | 23.8 | ||
48 | 5 | 23.7 | 22.9 | 24.5 | ||
49 | 6 | 25.1 | 23.8 | 25.4 | ||
50 | 7 | 24.8 | 23.4 | 25.6 | ||
51 | 8 | 24.8 | 23 | 26.8 | ||
52 | 9 | 25.2 | 24.1 | 25.7 | ||
53 | 10 | 25.2 | 24.8 | 25.4 | ||
54 | 11 | 25.4 | 24.5 | 25.7 | ||
55 | 12 Noon | 25.2 | 23.7 | 25.9 | ||
56 | 1PM | 24.9 | 23.7 | 26.2 | ||
57 | 2 | 24.6 | 23.4 | 26 | ||
58 | 3 | 24.7 | 23.8 | 25.8 | ||
59 | 4 | 24.8 | 24.1 | 25.6 | ||
60 | 5 | 24.3 | 23.9 | 26.2 | ||
61 | 6 | 24.6 | 22.8 | 24.7 | ||
62 | 7 | 24.6 | 23.7 | 25 | ||
63 | 8 | 24.4 | 22.9 | 24.8 | ||
64 | 9 | 24.6 | 22.2 | 24.9 | ||
65 | 10 | 24.4 | 23.1 | 25.1 | ||
66 | 11 | 23.9 | 22 | 25.2 | ||
67 | 12 Midnight | 23.5 | 22.1 | 24.2 | ||
68 | 1:00 AM | 23.4 | 22.3 | 24 | ||
69 | 2 | 24 | 23.8 | 25 | ||
70 | 3 | 23.8 | 23.1 | 24.6 | ||
71 | 4 | 23.9 | 23.2 | 24.5 | ||
72 | 5 | 23.5 | 22.3 | 25.1 |
Question: Assume Tolerance limit of 251.50 lbs. is specified in the sales contract and find the Process Capability index Cpk. Explain what it indicates and if process is capable to meet contractual agreement.
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