Question

In: Operations Management

On November 1, 2013 John Adams, a customer service representative of Americo Drilling Supplies (ADS), was...

On November 1, 2013 John Adams, a customer service representative of Americo Drilling Supplies (ADS), was summoned to the Houston office 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 light-weighted.

The light-weight bags were initially detected by one of DCI’s 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. ADS’s 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 almost 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 issue 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 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, Texas 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 (see Excel dataset). Ten bagswere sampled and weighted each hour.   

e. Is there any differences between performances of three shifts? Hint: (Carve out the morning, afternoon, and night shift data into three columns and graph their averages. Explain your findings based on graph.

Sample # Time Average (X-bar) Smallest Largest Range
1 6:00 AM 25.2 24.9 25.7
2 7 25.4 25.3 26.2
3 8 25.2 25.1 26.4
4 9 25.5 25.2 26.1
5 10 25.1 25.2 26.3
6 11 25.5 24.9 25.7
7 12 Noon 25.1 24.8 25.3
8 1:00 PM 25 24.5 25.4
9 2 24.7 23.9 25.1
10 3 25.1 23.9 25.2
11 4 24.5 24.2 25.3
12 5 24.7 24.9 25.3
13 6 24.8 24.2 25
14 7 24.4 24 25
15 8 25 23.6 25.2
16 9 24.8 24.4 25.4
17 10 23.9 24.9 25.3
18 11 24.1 23.9 25.1
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.1 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

Solutions

Expert Solution

For each sample, compute Range = Largest - Smallest

Compute Xbarbar (Average of Xbar of 72 samples) and Rbar (Average of Range of 72 samples)

Rest of the steps of statistical process control are following

Conclusion:

3 R values are outside the control limits. Therefore, based on R-chart, the process is not in control.

36 Xbar values are outside the control limits. Therefore, based on Xbar-chart, the process is not in control


Related Solutions

A customer service representative must spend different amounts of time with each customer to resolve various...
A customer service representative must spend different amounts of time with each customer to resolve various concerns. The amount of time (minutes) spent with each customer can be modeled by an uniform distribution that spans from 10 to 20 minutes. a.) What is the variance? b.) State f(x) c.) Find P(12 < x < 15.5). d.) If samples of size 20 are drawn, what is the probability that the sample mean is less than 13?
Consider the job of customer service representative who takes telephone calls from customers of a retailer...
Consider the job of customer service representative who takes telephone calls from customers of a retailer that sells online and through catalogs. HR is conducting job design on this job. What measures can an employer take to design this job to make it motivating? What measures can an employer take to design this job to make it ergonomic? Be specific and elaborate.
Question: Confirmation number Customer Name Recorded balance $ confirmed by customer 1 Representative Corporation $5,000 Confirmation...
Question: Confirmation number Customer Name Recorded balance $ confirmed by customer 1 Representative Corporation $5,000 Confirmation not recieved 2 Illustration LLC $8,000 $8,000 3 Selection Partnership $10,000 $9,800 4 Specimen Inc. (a related party) $2,000,000 $1,950,000 Q4-ii. On the basis of the accounts receivable confirmation results received (as presented above), what are the conclusions for each of the sample items selected? Confirmation Number Evaluation of Results: (A)Fail/Exception; (B)Pass/No Exception; or (C) Cannot be Determined [Put only 1 letter below] 1...
On 1 December 2013, John and Patty Driver formed a corporation called Susquehanna Equipment Rentals. The...
On 1 December 2013, John and Patty Driver formed a corporation called Susquehanna Equipment Rentals. The new corporation was able to begin operations immediately by purchasing the assets and taking over the location of Rent-It, an equipment rental company that was going out of business. The newly formed company uses the following accounts: ******USA FORMA******USA FORMAT******USA FORMA******USA FORMA******USA FORMA******USA FORMA****** Cash Share Capital Accounts Receivable Retained Earnings Prepaid Rent Dividends Unexpired Insurance Income Summary Office Supplies Rental Fees Earned Rental...
On 1 December 2013, John and Patty Driver formed a corporation called Susquehanna Equipment Rentals. The...
On 1 December 2013, John and Patty Driver formed a corporation called Susquehanna Equipment Rentals. The new corporation was able to begin operations immediately by purchasing the assets and taking over the location of Rent-It, an equipment rental company that was going out of business. The newly formed company uses the following accounts:    Cash Share Capital Accounts Receivable Retained Earnings Prepaid Rent Dividends Unexpired Insurance Income Summary Office Supplies Rental Fees Earned Rental Equipment Salaries Expense Accumulated Depreciation: Rental...
On November 1, 2017, Bernard Company (a U.S.-based company) sold merchandise to a foreign customer for...
On November 1, 2017, Bernard Company (a U.S.-based company) sold merchandise to a foreign customer for 120,000 FCUs with payment to be received on April 30, 2018. At the date of sale, Bernard entered into a six-month forward contract to sell 120,000 FCUs. The company properly designates the forward contract as a cash flow hedge of a foreign currency receivable. The following exchange rates apply: Date Spot Rate Forward Rate (to April 30, 2018) November 1, 2017 $ 0.23 $...
On November 1, 2017, Bernard Company (a U.S.-based company) sold merchandise to a foreign customer for...
On November 1, 2017, Bernard Company (a U.S.-based company) sold merchandise to a foreign customer for 150,000 FCUs with payment to be received on April 30, 2018. At the date of sale, Bernard entered into a six-month forward contract to sell 150,000 FCUs. The company properly designates the forward contract as a cash flow hedge of a foreign currency receivable. The following exchange rates apply: Date Spot Rate Forward Rate (to April 30, 2018) November 1, 2017 $ 0.26 $...
On November 1, 2017, Bernard Company (a U.S.-based company) sold merchandise to a foreign customer for...
On November 1, 2017, Bernard Company (a U.S.-based company) sold merchandise to a foreign customer for 250,000 FCUs with payment to be received on April 30, 2018. At the date of sale, Bernard entered into a six-month forward contract to sell 250,000 FCUs. The company properly designates the forward contract as a cash flow hedge of a foreign currency receivable. The following exchange rates apply: Date Spot Rate Forward Rate (to April 30, 2018) November 1, 2017 $ 0.36 $...
On November 1, 2017, Bernard Company (a U.S.-based company) sold merchandise to a foreign customer for...
On November 1, 2017, Bernard Company (a U.S.-based company) sold merchandise to a foreign customer for 190,000 FCUs with payment to be received on April 30, 2018. At the date of sale, Bernard entered into a six-month forward contract to sell 190,000 FCUs. The company properly designates the forward contract as a cash flow hedge of a foreign currency receivable. The following exchange rates apply: Date Spot Rate Forward Rate (to April 30, 2018) November 1, 2017 $ 0.30 $...
On November 1, 2017, Bernard Company (a U.S.-based company) sold merchandise to a foreign customer for...
On November 1, 2017, Bernard Company (a U.S.-based company) sold merchandise to a foreign customer for 170,000 FCUs with payment to be received on April 30, 2018. At the date of sale, Bernard entered into a six-month forward contract to sell 170,000 FCUs. The company properly designates the forward contract as a cash flow hedge of a foreign currency receivable. The following exchange rates apply: Date Spot Rate Forward Rate (to April 30, 2018) November 1, 2017 $ 0.28 $...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT