please post excel charts!!!!

Frito-Lay's Quality-Controlled Potato Chips 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 plants 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 complaint 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 checkpoint, salt content in Lay's chips, are 2.22% and 1.98%, respectively. To see exactly how these limits are created using SPC, watch the video that accompanies this case. I 1. Angela is now going to evaluate 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 control specifications noted earlier. She picks a sample of four each hour for 5 hours. The data (in percent) from the initial trial samples are: Sample 1: 1.99,2.0,2.08,1.99 Sample 2:1.98,2.11,2.15,2.06 Sample 3:2.01,2.08,2.14,2.16 Sample 4:2.18,2.01,2.23,1.98 Sample 5:2.20,2.10.2.20,2.05 Analyze the data and draw the x and R control charts in Microsoft Excel including the upper and lower control limits. (Hint: There is no population standard deviation available so you need to get A2,D3 and D4 for upper and lower limits) 2. Given these data and your analysis, what conclusion do you, as a Frito Lays quality control inspector, draw from this process? What report do you issue to your supervisor Angela? If the current pattern of the data continues, what will happen in the next 10 hours of operations? Explain your findings and decision based on the data analysis. 3. What are the advantages and disadvantages of Frito-Lay drivers stocking their customers' shelves