Question: PLEASE DO NOT POST AN ANSWER ALREADY WRITTEN. There are several but they have different answers. Please show excel formulas if you can. Burpsy Cola

PLEASE DO NOT POST AN ANSWER ALREADY WRITTEN. There are several but they have different answers. Please show excel formulas if you can.

Burpsy Cola has been producing fine carbonated beverages since 1926 in Stinking Creek, Tennessee. The current product line includes a number of flavors and packaging options. Many of their products are packed in 16 ounce cans that are then packed in 6-pack, 12-pack, and 24-pack boxes. The cans all have decorative labeling that includes sophisticated silkscreen images of local celebrities (like Jeff Carrier, Postmaster and Emcee at the Moonshine Bar and Comedy Club). More importantly, every cans label states that the can contains 16 fluid ounces of tasty carbonated beverage. It is important that the label and the cans contents agree at levels the federal government mandates for truth in labeling. The gummint, as the townspeople call it, mandates that 16 ounce cans must contain at least 15.5 ounces and no more than 16.5 ounces to meet their standards. Gerry Ross is the production manager at Burpsy Cola. He is ultimately responsible for all aspects of manufacturing and packaging of the companys products. Today he is concerned about the can-filling line for one of their most popular products, Persimmon Soda. He has been sampling output from the Persimmon production line for several days, and the results are shown below: Observations (can volume in ounces)

PLEASE DO NOT POST AN ANSWER ALREADY WRITTEN.

Please answer the following questions related to Gerrys analysis.

a) Please calculate the process capability (Cpk) for Gerrys analysis. Use the mean and standard deviation from Gerrys samples above to calculate the process capability. Once you calculate the number, please state briefly (three sentences or less) what the number indicates about the process.

b) Please use the data above to prepare control limits needed for the construction of an chart and an R chart. Assume a confidence level of 3. Draw the charts.

Observations (can volume in ounces) Sample Number 1 1 4 5 N 3 3 15.83 15.93 15.85 16.12 2 15.85 16.01 WN 3 16.00 2 16.02 16.00 15.91 15.85 15.86 16.01 15.94 15.94 15.68 16.12 16.12 15.93 4 15.74 15.83 15.93 16.10 16.20 15.74 5 16.21 16.14 6 15.94 16.03 15.88

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!