Skip to content
Solved Assignments

MGT 3332 SPC case analysis: Americo Drilling Supplies� Fall 2015

This assignment provides an SPC case analysis for Americo Drilling Supplies, covering quality control methods.

Preview 4 of 10 pages

See the first 4 pages exactly as they appear in the document.

  1. Page 1
    Read page 1 as text

    1 SPC CASE ANALYSIS : AMERICO DRILLING SUPPLIES MGT 3332 – Fall 2015 Dr. Nayebpour In November 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 agent s that ADS had shipped to the Houston firm. DCI had filed a complaint that the 50 Pound bags of treating agents that it had just received from ADS were short - weight by approximately 5%. The light - weight bags were initial ly 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 shipme nts received on October 25, 2013 . ADS ’s traffic department was called to determine if lighter - weight dunnage or pal lets 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 50 of the bags and discovered that the average net weight was 47.51 pounds. They noted from past shipments that the bag net weights averaged exactly 50.0 pounds, with an acceptable standard deviation of 1.2 pounds. Consequently, they concluded that the sample indicated a significance short - weight. ADS , was then contact ed, and Adams was sent to investigate the complaint an d to issue a 5% credit to DCI . DCI , however, was not completely satisfied with only the issuance of credit for the sho r t shipment. The charts followed by their mud engineers on the drilling platforms were based on 50 - 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

  2. Page 2
  3. Page 3
    Read page 3 as text

    2 to be isolated in DCI warehouse, causing extra handling and poor space utilization. Hence, Adams was informed that CDI might seek a new sup plier of mud - treating agents if in the future it received bags that deviated significantly below 50 pounds. The qualit y control department at ADS suspected that the light - weight bags may have resulted from “gr owing pains” at the O range 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 drill ing 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 2011 s , and finally to a three - shift operation (24 ho urs per day) in September of 2013 . The additional night shift bagging crew was staffed entirely by new employees. The most experienced foremen were temporarily assigned to sup ervise 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 50 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 p repared the following table . Six bags were sampled and weighted each hour.

  4. Page 4
    Read page 4 as text

    3 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. Insert all graphs and provide analysis in this word file after every question . Only The Wor d file is graded . a - Calculate the Range Column in Excel (Largest - Smallest) and find mean and standard deviations for Average Weight, Smallest, Largest, and Range columns. After calculating the range column the obtained values (mean and standard deviations) for the 4 columns is calculated. The obtained output is given below, Average (X - bar) Smallest Largest Range Mean 49.1694 47.3111 51.1125 3.8014 Standard Deviation 1.2557 1.9406 1.5690 1.5102 b - What is the standard deviation of individual bags i f sample averages are based on 6 bags? Explain your finding. Hint: x - bar = /sqrt(n). Having x - bar based on part b cal culation, solve for given n= 6 In part a we calculated the standard deviation for sample averages based on a sample size 6 hence using the given formula, Standard deviation of individual bags = 𝑆𝐷 𝑓𝑜𝑟 𝑎𝑣𝑒𝑟𝑎𝑔𝑒 ∗ ඥ 𝑠𝑎𝑚𝑝𝑙𝑒 𝑠𝑖𝑧𝑒 = 1 . 2557 ∗ √ 6 = 3.075824

6 more pages in the full document

Unlock it once and it stays in your library, ready to chat with or turn into flashcards.

Unlock the full document

More Business Management study materials

See all

Study this document with CramX

Once it is in your library, every tool can work from it.