Case Information

The XYZ Company manufactures boat anchors in a variety of sizes, shapes, and weights. The combination of these three design elements is optimized to produce anchors that are appropriate for a variety of boats, waterways, currents, wind, and wave action. The anchors are made from a mixture of three metals that are melted together and then poured into molds by a robot controlled by a computer.

The 25 lbs. anchors are made in batches of 10,000, which requires one 8-hour work shift, and are shipped to 3,500 retail stores across the United States and Canada. The 25 lbs. anchors have been manufactured using the same process and the same blend of materials for 5 years. The XYZ Company has designed the manufacturing process to produce anchors with a mean weight of 25 lbs. and with a standard deviation of 1 lb. The anchor weights produced by this process are normally distributed.

The company monitors the stability (consistency of quality) of its manufacturing process by testing 1% of its production for each batch. It selects the units for testing by programming the production computer to divert every 100^thanchor from the end of the production line. To determine the first unit selected for testing, the computer uses a random number between 1 and 100 to select the number of the first anchor diverted and then continues with every 100^thanchor from that point until the end of the production run for that batch. An inspector removes each of the diverted anchors, inspects it for manufacturing defects and then weighs the anchor on a high-precision digital scale. The scale is recalibrated after each unit is weighed to assure perfect measurements. The sample anchor weights are recorded in the digital scale and then downloaded to an excel spreadsheet. The spreadsheet for the sample anchor weights for the last production run is attached.

Case Information

The XYZ Company manufactures boat anchors in a variety of sizes, shapes, and weights. The combination of these three design elements is optimized to produce anchors that are appropriate for a variety of boats, waterways, currents, wind, and wave action. The anchors are made from a mixture of three metals that are melted together and then poured into molds by a robot controlled by a computer.

The 25 lbs. anchors are made in batches of 10,000, which requires one 8-hour work shift, and are shipped to 3,500 retail stores across the United States and Canada. The 25 lbs. anchors have been manufactured using the same process and the same blend of materials for 5 years. The XYZ Company has designed the manufacturing process to produce anchors with a mean weight of 25 lbs. and with a standard deviation of 1 lb. The anchor weights produced by this process are normally distributed.

AutoSave O OFF ~ 9 5 6 68: MBA 503 - Section 1 Exam - Spreadsheet Attachment - Saved to my Mac Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) 11 A A ag Wrap Text v General Insert v Ex Delete v Paste BIUV MVAv Merge & Center v $ 9 Conditional Format Cell Sort & Find 8 Analyze Sensitivity ormatting as lable Styles Format Filter Select Data * Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates 012 fx A B C D E G H K M N O P Q R S T U V W X Z Data Set Random Number Generator =RANDBETWEEN(1, 29 5 Line Weight Sample Sample 6 Item (lbs. ) Size Mear Minimum Maximum 29 24.242 100 24.54654 20.09 26.38 129 23.393 229 24.124 329 25.20 Bin Freq. Histogram - 25 lbs. Boat Anchors (n = 100) 129 22.624 20.00 O 529 26.003 20.50 25 OF 629 24.857 21.0 20 729 22.425 21.50 15 329 26.279 22.00 UPNO Frequency 16 929 24.428 22.50 10 1029 23.00 23.00 5 1129 24.424 23.50 1229 25.345 24.00 1329 23.977 24.50 22 20.00 20.50 1.00 21.50 22.00 2.50 2.00 23.50 24.00 24.50 25 50 25.00 26.00 26.50 More 1429 21.56 25.00 Anchor Weight (Ibs.) 1529 24.231 25.50 18 1629 24.205 6.0 1729 24.243 26.50 1829 23.958 More 1929 20.091 2029 25.675 2129 26.384 Bin Frequency Histogram - 25 lbs. Boat Anchors (n = 100) 2229 23.652 20 0 30 2329 25.916 21 50 INP 2429 22.448 22 40 2529 24.179 23 7 2629 25.176 24 13 equenc 2729 25.090 25 39 8 20 2829 24.73 26 30 36 23.886 27 8 10 2929 3029 24.84 More ol O 38 3129 24.494 20 21 22 23 24 25 26 27 More Sheet1 + 100% O C JUN 2 5 9 W X XLSX