What is the standard deviation of individual bags

Assignment Help Operation Management
Reference no: EM13854025

SPC CASE ANALYSIS: AMERICO DRILLING SUPPLIES - 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 agents 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 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 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 contacted, and Adams was sent to investigate the complaint and to issue a 5% 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 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 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 50 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 September 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 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 prepared the following table. Six 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.

Insert all graphs and provide analysis in this word file after every question. Only The Word 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.

b- What is the standard deviation of individual bags if sample averages are based on 6 bags? Explain your finding. Hint: σx-bar = σ/sqrt(n). Having σx-bar based on part b calculation, solve for σ given n= 6

c- Construct a time series plot of all four variables (two graphs: one includes avg., smallest, and largest and the other has range) and discuss your findings based on the graphs.

d- Construct X-bar and R Charts, graph, and discuss your findings based on the control charts. Is it out of control? Why? Explain.

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.

f- Use One Way Analysis of Variance (ANOVA) to compare the three groups (shifts) to test if there is significant differences in the performance of three shift averages. Use Alpha =0.01. Can you conclude that night shift is to be blamed for most of the variation? Expalin

g- Assume Tolerance limits of 50±1.75 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.

h- Redo part g for all three shifts separately and determine their Cpk. Note that you must find mean and standard deviation for each shift separately.

i- If the process average is adjusted to 50.0 lbs. and process standard deviation is reduced by 40%, what is the new Cpk? Are you comfortable for making such recommendation to management? Explain.

j- Find the control limits for an X-bar and R chart if a new improved process has average of 50.5 lbs. and R-bar of 1.2 lbs. Assume n=5 for new process control.

k- Provide complete conclusion regarding your findings and make recommendations regarding the filling process in your conclusion paragraph.

I am having difficulty doing this assignment. Please help me work it out. I am hoping all the answer is correct.

Attachment:- case analysis dataset.rar

Reference no: EM13854025

Questions Cloud

Banking system leads to an increase in fed funds rate : Which of the following is a rate that should theoretically serve as a floor for the Fed funds rate? A dealer is said to be running a "matched book" if. An increase in the supply of reserves in the banking system leads to an increase in the Fed funds ..
Consumers attempt to maximize their utility based : Economists assume that consumers attempt to maximize their utility based upon their preferences, income and price of commodities. Do you see any weakness of the above are you aware of any example of irrational behavior by consumers (or yourself)?
How processes interact and impact our employees : Discuss the pros and cons of the tool providing evidence and examples of the use of the tool. Provide recommendations to a future tool user
The demand for the product of business : The demand for the product of a business is given by q = 50 - 2p. If the price of the product is p = 10 dollars, the revenue is
What is the standard deviation of individual bags : Calculate the Range Column in Excel and find mean and standard deviations for Average Weight, Smallest, Largest, and Range columns and What is the standard deviation of individual bags if sample averages are based on 6 bags.
Prepare the required aje for wannebee corporation : Prepare the Required AJE for WanneBee Corporation
Theoretically serve as a floor for the fed funds rate : Which of the following is a rate that should theoretically serve as a floor for the Fed funds rate? A dealer is said to be running a "matched book" if. An increase in the supply of reserves in the banking system leads to an increase in the Fed funds ..
When entrepreneurs are investing their own money : When entrepreneurs are investing their own money, how do they decide which projects they should undertake? When political decision-makers allocate the funds of others (taxpayers), how do they decide which projects to support? Explain.
Demand is inelastic and marginal revenue is negative : If a monopolistic firm (price searcher) can sell 9 units at a price of $100 each but must reduce its price to $80 in order to sell 10 units, then Demand is inelastic and marginal revenue is negative. Marginal revenue is falling but is above price

Reviews

Write a Review

 

Operation Management Questions & Answers

  Analyze the potential pitfalls in capital budgeting practice

Analyze the potential pitfalls in his capital budgeting practices that George should be aware of.

  What is the ultimate goal of change management

What is the ultimate goal of change management?

  How a u.s. company that has fallen victim

Make a recommendation on how a U.S. company that has fallen victim to this Chinese practice should respond so as to protect its intellectual property.

  Evaluate cost of lying off workers

December demand rates of production crew both 1,600 units per month. Cost of hiring additional workers is $5,000 per 100 units. Cost of lying off workers is $7,500 per 100 units. Evaluate this plan.

  The elixer drug company produces a drug from two ingredients

The Elixer Drug Company produces a drug from two ingredients. Each ingredient contains the same three antibiotics, in different proportions. One gram of ingredient 1 contributes 3 units, and 1 gram of ingredient 2 contributes 1 unit of antibiotic

  The term project scope refers to

The term project scope refers to- the final result of the project, key deliverables in the project plan, the strategic business objective, work required to complete the project

  Question 1 you are the operations manager of a firm that

question 1 you are the operations manager of a firm that uses the continuous-review inventory control system. suppose

  How to integrate the existing watch networking standards

You have been asked to design and deliver a Microsoft PowerPoint presentation to your team regarding the upgrade and the integration of the WATCH network into SHG's Active Directory forest.

  How does its performance compare to that of its competitors

The typical length for a response to one question is one to two complete paragraphs ?be succinct in your responses as business writing avoids verboseness, but also be specific in providing support for your analysis. How has LVMH been performing? How ..

  Compute the annual total cost

Compute the annual total cost (i.e. the Purchase cost + Ordering cost + Holding cost). (Please read the question more than once)

  Explain straight-line method of depreciation

Approximately one year later, the hospital is approached by Harmon Technology salesperson, Jane Black, who indicated that purchasing the scanner in 2011 from Faital Inc. was a mistake.

  What forms of interpersonal power are evident

What forms of interpersonal power are evident in the case and why. In what ways do the two faces of power appear in this case. Please explain your answer. Does the firing of John Lasseter from Disney Studios and the events leading up to his firing ..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd