Submit the Excel document containing your work on the SPC project. All answers should be recorded in the Excel document, or you may type the memos and the answers in a separate Word document.
SPC Project Instructions
SPC Project Instructions.docxPreview the document
SPC Project Instructions
Complete SPC Project (Submit this week) – See details below in blue.
PLEASE NOTE: If the population standard deviation is provided, then use it for this project, otherwise if it is not provided, then refer to Table S6.1 in your textbook (page 251 in the Pearson 13th edition).
There are two cases in this project. Below are the details on the two cases in the SPC Project (Based on Chapter 6S Statistical Process Control). In this module, there is an Excel spreadsheet labeled SPC Project – BLANK New_2019 that has the sample data and includes spaces to add your SPC Control Chart data (for Case 1) and includes the data to build the SPC Charts in Case 2. That Excel file should be submitted during Week 4. Make sure to substitute your name for the word BLANK when you save the Excel file.
Case 1: Frito-Lay Salt Test
Read the first case (Frito-Lay) description below.
Watch the video in this module for the Frito-Lay case (the video must be watched in its entirety to get full credit).
You must also submit a Word document containing a memo to Angela McCormack and answering the additional two questions.
Case 1 Description
Frito-Lay, the multi-billion-dollar snack food giant, produces billions of pounds of product every year at its dozens of U.S. and Canadian plants. From the farming of potatoes-in Florida, North Carolina, and Michigan-to factory and to retail stores, the ingredients and final product of Lay’s chips, for example, are inspected at least 11 times: in the field, before unloading at the plant, after washing and peeling, at the sizing station, at the fryer, after seasoning when bagged (for weight), at carton filling, in the warehouse, and as they are placed on the store shelf by Frito-Lay personnel. Similar inspections take place for its other famous products, including Cheetos, Fritos, Ruffles, and Tostitos.
In addition to these employee inspections, the firm uses proprietary vision systems to look for defective potato chips. Chips are pulled off the high-speed line and checked twice if the vision system senses them to be too brown.
The company follows the very strict standards of the American Institute of Baking (AIB), standards that are much tougher than those of the U.S Food and Drug Administration. Two unannounced AIB site visits per year keep Frito-Lay’s plant on their toes. Scores, consistently in the “excellent” range, are posted, and every employee knows exactly how the plant is doing.
There are two key metrics in Frito-Lay’s continuous improvement quality program: (1) total customer complaints (measured on a complaints per million bag basis) and (2) hourly or daily statistical process control scores (for oil, moisture, seasoning, and salt content, for chip thickness, for fryer temperature, and for weight).
In the Florida plant, Angela McCormack, who holds engineering and MBA degrees, oversees a 15-member quality assurance staff. They watch all aspects of quality, including training employees on the factory floor, monitoring automated processing equipment, and developing and updating statistical process control (SPC) charts. The upper and lower control limits for one check point, salt content in Lay’s chip, are 2.22% (UCL) and 1.98% (LCL), respectively. To see exactly how the limits are created using SPC, watch the Frito Lay Control Charts video in the Module below that accompanies this case.
In the Excel document (below in this Module) you are going to create a new set of UCL and LCL measurements based on the below sample data and using the provided population parameter for standard deviation. Calculate the measurements and show your work.
Angela is evaluating a new salt process delivery system and wants to know if the upper and lower control limits at 3 standard deviations for the new system will meet the upper and lower controls specifications currently used (2.22 and 1.98). The population standard deviation is s = .07 and each sample is n=4. In a Word document, write a memo to Angela explaining whether or not the new salination process (from which we obtained the sample data) is delivering a new set of UCL/LCL measurements that is within the specifications set by the current set of control limits. In other words, does the new set of UCL/LCL measurement exceed the prior limits (meaning it is unacceptable) or equals or is less than the current specifications?
Additionally, in the same Word document, answer the following two critical thinking questions about Frito-Lay’s current quality process.
Question 1: How much of an improvement in variability did Frito-Lay make by implementing SPC?
Question 2: What are the steps Karen Engels and Barbara Boudreau go through as part of a testing cycle?
The data (in percent) from the initial trial samples using the new salting process are:
Case 2: Stensil Fertilizer and Chemical Co. Inorganic Fertilizer Testing
Read the second case (Stensil) description below (also found in the Excel file, second tab).
Watch the second video in this module which explains how to build an SPC chart in Excel (the video must be watched in its entirety to get full credit).
You must also submit a Word document containing a memo to Bill Evans, Quality Control Manager for Stensil.
Case 2 Description
Stensil Fertilizer and Chemical Company produces both organic and inorganic fertilizers. Organic fertilizers are generally safe, but inorganic fertilizers are carefully monitored by the EPA due to the presence of hazardous waste materials (hazmat). Most bags contain some hazardous content, but theoretically there should be none. The EPA allowable specification is 90 parts per million (PPM). The quality control department at Stensil feels that there is no problem with hazardous material content, which has been averaging just over 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 the EPA, suggest that a control chart be set up to monitor hazmat content. Five samples will be tested per day and plotted as one point on the chart. Use the data in Table 1 to set up the control limits. Then, after the limits are in place for this process, use Table 2 to determine whether or not the process remains in control for the week of September 6—10.
The Excel file includes a second tab for the Stensil Fertilizer Case (Case 2). This is the data you need for the problem. Build an appropriate SPC X-bar Chart and R-chart for the Table 1 data on this tab of the Excel worksheet.
Then, test to determine whether the Table 2 data indicates the process is under control for that period. Show your work for this part in the same Excel worksheet and submit it.
Assuming the role of Quality Control Analyst, write a memo (using Word) to the Manager of Quality Control for Stensil Fertilizer & Chemical Company (Bill Evans) explaining the process you went through and making a recommendation regarding current hazmat levels in Stensil’s fertilizer.
The United States is home to the absolute generally famous and productive chronic executioners ever. Names, for example, Ted Bundy, Gary Ridgeway, and the Zodiac Killer have become easily recognized names because of the horrendous idea of their violations. One of the most productive chronic executioners in American history is John Wayne Gacy. Nicknamed the Killer Clown in light of his calling, Gacy assaulted and killed at any rate 33 adolescent young men and youngsters somewhere in the range of 1972 and 1978, which is one of the most elevated realized casualty tallies. Gacy's story has become so notable that his violations have been included in mainstream society and TV shows, for example, American Horror Story: Hotel and Criminal Minds. Criminological science has, and proceeds to, assume a significant job in the addressing of the case and distinguishing proof of the people in question. John Wayne Gacy's set of experiences of sexual and psychological mistreatment was instrumental in arousing agent's curiosity of him as a suspect. John Wayne Gacy was brought into the world on March 17, 1942, in Chicago, Illinois. Being the lone child out of three kids, Gacy had a stressed relationship with his dad, who drank vigorously and was frequently injurious towards the whole family (Sullivan and Maiken 48). In 1949, a temporary worker, who was a family companion, would stroke Gacy during rides in his truck; nonetheless, Gacy never uncovered these experiences to his folks because of a paranoid fear of revenge from his dad (Foreman 54). His dad's mental maltreatment proceeded into his young grown-up years, and Gacy moved to Las Vegas where he worked quickly in the emergency vehicle administration prior to turning into a morgue specialist (Sullivan and Maiken 50). As a morgue specialist, Gacy was intensely associated with the preserving cycle and conceded that one night, he moved into the casket of a perished high school kid and touched the body (Cahill and Ewing 46). Stunned at himself, Gacy re-visitations of Chicago to live with his family and graduates from Northwestern Business College in 1963, and acknowledges an administration learner position with Nunn-Bush Shoe Company. In 1964, Gacy is moved to Springfield and meets his future spouse, Marlynn Myers. In Springfield, Gacy has his subsequent gay experience when a collaborator shakily performed oral sex on him (London 11:7). Gacy moves to Waterloo, Iowa, and starts a family with Myers. Be that as it may, after routinely undermining his significant other with whores, Gacy submits his previously known rape in 1967 upon Donald Vorhees. In the coming months, Gacy explicitly mishandles a few different adolescents and is captured and accused of oral homosexuality (Sullivan and Maiken 60). On December 3, 1968, Gacy is indicted and condemned to ten years at the Anamosa State Penitentiary. Gacy turns into a model prisoner at Anamosa and is conceded parole in June of 1970, an only a short time after his condemning. He had to migrate to Chicago and live with his mom and notice a 10:00PM time limit. Not exactly a year later, Gacy is accused again of explicitly attacking an adolescent kid however the young didn't show up in court, so the charges were dropped. Gacy was known by numerous individuals in his locale to be an ardent volunteer and being dynamic in network legislative issues. His job as "Pogo the Clown" the jokester started in 1975 when Gacy joined a neighborhood "Carefree Joker" comedian club that consistently performed at gathering pledges occasions. On January 3, 1972, Gacy submits his first homicide of Timothy McCoy, a 16-year old kid venturing out from Michigan to Omaha. Guaranteeing that McCoy went into his room employing a kitchen blade, Gacy gets into an actual fight with McCoy prior to cutting him consistently in the chest. In the wake of understanding that McCoy had absentmindedly strolled into the stay with the blade while attempting to get ready breakfast, Gacy covers the body in his unfinished plumbing space. Gacy conceded in the meetings following his capture that slaughtering McCoy gave him a "mind-desensitizing climax", expressing that this homicide was the point at which he "understood passing was a definitive rush" (Cahill and Ewing 349). Just about 2 years after the fact, Gacy submits his second homicide of a unidentified youngster. Gacy choked the kid prior to stuffing the body in his storage room prior to covering him (Cahill 349). In 1975, Gacy's business was developing rapidly and his craving for youngsters developed with it. Gacy regularly tricked youngsters under his work to his home, persuading them to place themselves in binds, and assaulting and tormenting them prior to choking them (Cahill 169-170). A large portion of Gacy's homicides occurred somewhere in the range of 1976 and 1978, the first of this time occurring in April 1976. Huge numbers of the young people that were killed during this time were covered in an unfinished plumbing space under Gacy's home. For the rest of the killings, Gacy confessed to losing five bodies the I-55 extension into the Des Plaines River; be that as it may, just four of the bodies were ever recuperated (Linedecker 152). In December 1978, Gacy meets Robert Jerome Piest, a 15-year old kid working at a drug store and offers him an occupation at Gacy's firm. Piest advises his mom regarding this and neglects to restore that night. The Piest family records a missing individual's report and the drug specialist advises police that Gacy would doubtlessly be the man that Jerome addressed about a work. When addressed by the police, Gacy denied any contribution in Piest's vanishing. Nonetheless, the police were not persuaded, and Gacy's set of experiences of sexual maltreatment and battery incited the police to look through his home. Among the things found at Gacy's home were a 1975 secondary school class ring with the initials J.A.S., various driver's licenses, cuffs, dress that was excessively little for Gacy, and a receipt for the drug store that Piest had worked at. Throughout the span of the following not many days, agents got different calls and tips about Gacy's rapes and the secretive vanishings of Gacy's representatives. The class ring was in the long run followed back to John A. Szyc, one of Gacy's casualties in 1977. Futhermore, after analyzing Gacy's vehicle, specialists found a little group of strands looking like human hair, which were shipped off the labs for additional investigation. That very night, search canines were utilized to recognize any hint of Piest in Gacy's vehicle, and one of the canines showed that Piest had, indeed, been available in the vehicle. On December 20, 1977, under the pressure of consistent police observation and examination, Gacy admits to more than 30 killings and educates his attorney and companion where the bodies were covered, both in the unfinished plumbing space and the stream. 26 casualties were found in the unfinished plumbing space and 4 in the stream. Gacy is captured, indicted for 33 homicides, and condemned to death by deadly infusion. He endeavored a craziness supplication however was denied, and was executed on May 10, 1994. There were a few legal markers that examiners used to attach Gacy to the homicides. A portion of these include fiber examination, dental and radiology records, utilizing the decay cycle of the human body, and facial remaking in distinguishing the people in question. Specialists discovered filaments that looked like human hair in both Gacy's vehicle and close to the unfinished plumbing space where the bodies were covered. Notwithstanding these hair tests, examiners likewise discovered strands that contained hints of Gacy's blood and semen in a similar zone. Blood having a place with the casualties was found on a portion of the filaments, which would later straightforwardly attach Gacy to the wrongdoings. The filaments in Gacy's vehicle were examined by measurable researchers and coordinated Piest's hair tests. Besides, the pursuit canines that verified that Piest had been in Gacy's vehicle showed this by a "passing response", which told examiners that Piest's dead body had been within Gacy's vehicle. Out of Gacy's 33 known casualties, just 25 were ever convincingly distinguished. Huge numbers of Gacy's casualties had comparable actual portrayals and were in this way difficult to recognize by simply asking general society. To distinguish the people in question, examiners went to Betty Pat Gatliff, a pioneer in criminological science and facial reproduction. Facial remaking is the way toward reproducing the facial highlights of a person by utilizing their remaining parts. Certain facial highlights, for example, facial structures, nasal structure, and by and large face shape can be valuable in distinguishing a casualty even long in the afterlife. By utilizing these highlights, and with the assistance of program, criminological examiners can make a picture of an individual's face, which is instrumental in recognizing casualties after their bodies have rotted. Facial reproduction should be possible in a few measurements. Two-dimensional facial reproductions is utilized with skull radiographs and depend on pre-demise photos and data. Be that as it may, this isn't really ideal in light of the fact that cranial highlights are not generally noticeable or at the correct scale (Downing). To get a practical and more precise portrayal of the casualty's face, a craftsman and a criminological anthropologist are generally essential (Downing). Three-dimensional facial remaking is finished by models or high goal, three-dimensional pictures. PC programs can make facial reproductions by controlling checked photos of the remaining parts and use approximations to reproduce facial highlights. These will in general create results that don't look fake (Reichs and Craig 491). In some cases, specialists will utilize a strategy called superimposition as a procedure for facial remaking. Sadly, it's anything but an ordinarily utilized strategy, as it expects specialists to have some information about the character of the remaining parts they are managing. By superimposing a photo of a person over the skeletal remaining parts, agents can check whether the facial highlights line up with the anatomical highlights, permitting them to recognize a casualty. On account of John Wayne Gacy's casualties, specialists had the option to utilize facial remaking to distinguish nine of the bodies found in the unfinished plumbing space. The accompanying realistic shows the facial recreations of these nine casualties: Since facial remaking was insufficient to recognize the entirety of the v>GET ANSWER