Capstone Project Information Company: Organix Cereals (a fictional company) is a small producer of specialty organic breakfast cereal. Its signature product is Gluten-Free Organic Crispies, sold directly online to consumers. The company sells approximately 4 million boxes annually. Box label weight: 623 grams Price per box: $6.00 Cost of goods sold (per box): $4.00 (based on historical mean weight of 625 grams) Company Standards: In the automated packaging process, equipment is set to fill boxes with a mean weight of 625 grams and a standard deviation of 6 grams. This is the company standard for the box weights. As a small, independent producer of breakfast cereals, Organix uses older equipment and technology in its packaging process. Accordingly, the process results in boxes that are not always packed with exactly 623 grams (weight stated on label). The company sets the equipment to a target weight slightly higher than the weight stated on the box label to avoid penalties imposed by government inspectors if the box weights do not meet the government standards, and to ensure that customers receive the amount of cereal for which they pay. This is a common industry practice. Government Standards: Failure to meet government standards can result in fines of $200,000 or more, litigation, and negative publicity for the company and its brand. The government is not concerned if the company is overfilling boxes. 1.Penalties can be assessed against a company when any individual package weighs less than the Maximum Allowable Variation (MAV). The Maximum Allowable Variation (MAV) is the limit of “reasonable variation” for an individual package based on the NIST Handbook 133.The MAV is 23.5 grams below the declared box label weight of 623 grams. The lowest allowable weight, LMAV, is found by taking the label weight minus the MAV. 2.The company can also be penalized if the average package weight does not at least meet the declared box label weight of 623 grams. Data: The company recently took a random sample of 500 boxes of their signature cereal and measured their exact weights. The goals of this internal audit were to determine whether (1.) the company is meeting the targets set by management, and (2.) the company is in compliance with government regulations. The data that resulted from this sample can be found on the Excel workbook labeled Capstone Project Data SS2021. Analysis: Three templates are provided to guide your analysis. Your group must submit all three completed templates along with the final report in BlackBoard. The questions in the templates include the minimum requirements for your analysis in this project. Your group may choose to do additional statistical and business analysis beyond the minimum requirements in the templates. For Template 1, you will use the data on the tab labeled Cereal Weights. This data will also be used for the first part of Template 2. Also for Template 2 you will use data found on the tab labeled Weights after Adjustment. For Template 3 you will use the data found on the tab labeled Weights and Speeds. Hint: Whenever you calculate descriptive statistics using Excel, remember to check not only Summary Statistics but also Confidence Level (defaults to 95% confidence) to save your group some time when required to calculate interval estimates (confidence intervals). Keep in mind that the statistical analysis required in the templates is the minimum analysis required. Capstone Project Part 1 Template Descriptive Statistics: Using Excel, calculate the following descriptive statistics and then interpret the results in context using a business perspective. The analysis/interpretation should tell management what the descriptive statistic is revealing about the performance of the packaging process. Excel sheet:3 Speed Setting (Boxes Per Minute) Actual Box Weight 30 633.2242 30 633.1766 30 633.1218 30 633.1188 30 633.1122 30 633.1114 30 631.9987 30 632.8714 30 633.0902 30 633.0505 30 633.0093 30 633.0088 30 633.0075 30 633.0067 30 633.0055 30 632.9979 30 632.9898 30 632.8887 30 632.7764 30 631.7997 32 629.7675 32 628.5659 32 628.4444 32 628.2141 32 629.9966 32 631.5454 32 628.3111 32 628.1105 32 628.1006 32 628.0301 32 628.0203 32 628.0107 32 628.0102 32 628.0061 32 628.0003 32 628.0002 32 627.9999 32 627.9944 32 627.8878 32 627.7675 35 626.0017 35 625.5552 35 625.3337 35 625.2451 35 625.1004 35 625.1922 35 625.0707 35 625.0444 35 625.0267 35 625.0092 35 624.6061 35 625.7712 35 625.0076 35 625.0063 35 624.9999 35 624.9988 35 624.8889 35 624.8886 35 624.7978 35 623.7777 38 616.7716 38 615.3136 38 615.2655 38 615.2244 38 615.2243 38 615.1776 38 615.0907 38 615.0807 38 615.0444 38 615.0522 38 615.0303 38 615.0201 38 615.0102 38 615.0018 38 615.0008 38 616.1212 38 616.4545 38 614.9997 38 614.9929 38 614.7899 40 612.0106 40 611.0082 40 611.0007 40 611.0001 40 610.6844 40 610.6663 40 610.5516 40 610.5004 40 610.3323 40 610.3024 40 610.1447 40 610.1201 40 610.1161 40 610.2021 40 610.0202 40 610.0099 40 610.0175 40 610.0002 40 609.9997 40 611.2888

Capstone Project Information Company: Organix Cereals (a fictional company) is a small producer of specialty organic breakfast cereal. Its signature product is Gluten-Free Organic Crispies, sold directly online to consumers. The company sells approximately 4 million boxes annually. Box label weight: 623 grams Price per box: $6.00 Cost of goods sold (per box): $4.00 (based on historical mean weight of 625 grams) Company Standards: In the automated packaging process, equipment is set to fill boxes with a mean weight of 625 grams and a standard deviation of 6 grams. This is the company standard for the box weights. As a small, independent producer of breakfast cereals, Organix uses older equipment and technology in its packaging process. Accordingly, the process results in boxes that are not always packed with exactly 623 grams (weight stated on label). The company sets the equipment to a target weight slightly higher than the weight stated on the box label to avoid penalties imposed by government inspectors if the box weights do not meet the government standards, and to ensure that customers receive the amount of cereal for which they pay. This is a common industry practice. Government Standards: Failure to meet government standards can result in fines of $200,000 or more, litigation, and negative publicity for the company and its brand. The government is not concerned if the company is overfilling boxes. 1.Penalties can be assessed against a company when any individual package weighs less than the Maximum Allowable Variation (MAV). The Maximum Allowable Variation (MAV) is the limit of “reasonable variation” for an individual package based on the NIST Handbook 133.The MAV is 23.5 grams below the declared box label weight of 623 grams. The lowest allowable weight, LMAV, is found by taking the label weight minus the MAV. 2.The company can also be penalized if the average package weight does not at least meet the declared box label weight of 623 grams. Data: The company recently took a random sample of 500 boxes of their signature cereal and measured their exact weights. The goals of this internal audit were to determine whether (1.) the company is meeting the targets set by management, and (2.) the company is in compliance with government regulations. The data that resulted from this sample can be found on the Excel workbook labeled Capstone Project Data SS2021. Analysis: Three templates are provided to guide your analysis. Your group must submit all three completed templates along with the final report in BlackBoard. The questions in the templates include the minimum requirements for your analysis in this project. Your group may choose to do additional statistical and business analysis beyond the minimum requirements in the templates. For Template 1, you will use the data on the tab labeled Cereal Weights. This data will also be used for the first part of Template 2. Also for Template 2 you will use data found on the tab labeled Weights after Adjustment. For Template 3 you will use the data found on the tab labeled Weights and Speeds. Hint: Whenever you calculate descriptive statistics using Excel, remember to check not only Summary Statistics but also Confidence Level (defaults to 95% confidence) to save your group some time when required to calculate interval estimates (confidence intervals). Keep in mind that the statistical analysis required in the templates is the minimum analysis required. Capstone Project Part 1 Template Descriptive Statistics: Using Excel, calculate the following descriptive statistics and then interpret the results in context using a business perspective. The analysis/interpretation should tell management what the descriptive statistic is revealing about the performance of the packaging process. Excel sheet:3 Speed Setting (Boxes Per Minute) Actual Box Weight 30 633.2242 30 633.1766 30 633.1218 30 633.1188 30 633.1122 30 633.1114 30 631.9987 30 632.8714 30 633.0902 30 633.0505 30 633.0093 30 633.0088 30 633.0075 30 633.0067 30 633.0055 30 632.9979 30 632.9898 30 632.8887 30 632.7764 30 631.7997 32 629.7675 32 628.5659 32 628.4444 32 628.2141 32 629.9966 32 631.5454 32 628.3111 32 628.1105 32 628.1006 32 628.0301 32 628.0203 32 628.0107 32 628.0102 32 628.0061 32 628.0003 32 628.0002 32 627.9999 32 627.9944 32 627.8878 32 627.7675 35 626.0017 35 625.5552 35 625.3337 35 625.2451 35 625.1004 35 625.1922 35 625.0707 35 625.0444 35 625.0267 35 625.0092 35 624.6061 35 625.7712 35 625.0076 35 625.0063 35 624.9999 35 624.9988 35 624.8889 35 624.8886 35 624.7978 35 623.7777 38 616.7716 38 615.3136 38 615.2655 38 615.2244 38 615.2243 38 615.1776 38 615.0907 38 615.0807 38 615.0444 38 615.0522 38 615.0303 38 615.0201 38 615.0102 38 615.0018 38 615.0008 38 616.1212 38 616.4545 38 614.9997 38 614.9929 38 614.7899 40 612.0106 40 611.0082 40 611.0007 40 611.0001 40 610.6844 40 610.6663 40 610.5516 40 610.5004 40 610.3323 40 610.3024 40 610.1447 40 610.1201 40 610.1161 40 610.2021 40 610.0202 40 610.0099 40 610.0175 40 610.0002 40 609.9997 40 611.2888

Name: Capstone Project Information Company: Organix Cereals (a fictional com
Uploaded: 2024-03-20T07:06:16.000Z
Channel: Bartleby
Description: Capstone Project Information Company: Organix Cereals (a fictional company) is a small producer of specialty organic breakfast cereal. Its signature product is Gluten-Free Organic Crispies, sold directly online to consumers. The company sells approxi

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Concept explainers

Topic Video

Question

Capstone Project Information

Company: Organix Cereals (a fictional company) is a small producer of specialty organic breakfast cereal. Its signature product is Gluten-Free Organic Crispies, sold directly online to consumers. The company sells approximately 4 million boxes annually.

Box label weight: 623 grams

Price per box: $6.00

Cost of goods sold (per box): $4.00 (based on historical mean weight of 625 grams)

Company Standards: In the automated packaging process, equipment is set to fill boxes with a mean weight of 625 grams and a standard deviation of 6 grams. This is the company standard for the box weights. As a small, independent producer of breakfast cereals, Organix uses older equipment and technology in its packaging process. Accordingly, the process results in boxes that are not always packed with exactly 623 grams (weight stated on label).

The company sets the equipment to a target weight slightly higher than the weight stated on the box label to avoid penalties imposed by government inspectors if the box weights do not meet the government standards, and to ensure that customers receive the amount of cereal for which they pay. This is a common industry practice.

Government Standards: Failure to meet government standards can result in fines of $200,000 or more, litigation, and negative publicity for the company and its brand. The government is not concerned if the company is overfilling boxes.

1.Penalties can be assessed against a company when any individual package weighs less than the Maximum Allowable Variation (MAV). The Maximum Allowable Variation (MAV) is the limit of “reasonable variation” for an individual package based on the NIST Handbook 133.The MAV is 23.5 grams below the declared box label weight of 623 grams. The lowest allowable weight, LMAV, is found by taking the label weight minus the MAV.

2.The company can also be penalized if the average package weight does not at least meet the declared box label weight of 623 grams.

Data: The company recently took a random sample of 500 boxes of their signature cereal and measured their exact weights. The goals of this internal audit were to determine whether (1.) the company is meeting the targets set by management, and (2.) the company is in compliance with government regulations. The data that resulted from this sample can be found on the Excel workbook labeled Capstone Project Data SS2021.

Analysis: Three templates are provided to guide your analysis. Your group must submit all three completed templates along with the final report in BlackBoard. The questions in the templates include the minimum requirements for your analysis in this project. Your group may choose to do additional statistical and business analysis beyond the minimum requirements in the templates.

For Template 1, you will use the data on the tab labeled Cereal Weights. This data will also be used for the first part of Template 2. Also for Template 2 you will use data found on the tab labeled Weights after Adjustment. For Template 3 you will use the data found on the tab labeled Weights and Speeds.

Hint: Whenever you calculate descriptive statistics using Excel, remember to check not only Summary Statistics but also Confidence Level (defaults to 95% confidence) to save your group some time when required to calculate interval estimates (confidence intervals).

Keep in mind that the statistical analysis required in the templates is the minimum analysis required.

Capstone Project Part 1 Template

Descriptive Statistics: Using Excel, calculate the following descriptive statistics and then interpret the results in context using a business perspective. The analysis/interpretation should tell management what the descriptive statistic is revealing about the performance of the packaging process.

Excel sheet:3

Speed Setting (Boxes Per Minute)	Actual Box Weight
30	633.2242
30	633.1766
30	633.1218
30	633.1188
30	633.1122
30	633.1114
30	631.9987
30	632.8714
30	633.0902
30	633.0505
30	633.0093
30	633.0088
30	633.0075
30	633.0067
30	633.0055
30	632.9979
30	632.9898
30	632.8887
30	632.7764
30	631.7997
32	629.7675
32	628.5659
32	628.4444
32	628.2141
32	629.9966
32	631.5454
32	628.3111
32	628.1105
32	628.1006
32	628.0301
32	628.0203
32	628.0107
32	628.0102
32	628.0061
32	628.0003
32	628.0002
32	627.9999
32	627.9944
32	627.8878
32	627.7675
35	626.0017
35	625.5552
35	625.3337
35	625.2451
35	625.1004
35	625.1922
35	625.0707
35	625.0444
35	625.0267
35	625.0092
35	624.6061
35	625.7712
35	625.0076
35	625.0063
35	624.9999
35	624.9988
35	624.8889
35	624.8886
35	624.7978
35	623.7777
38	616.7716
38	615.3136
38	615.2655
38	615.2244
38	615.2243
38	615.1776
38	615.0907
38	615.0807
38	615.0444
38	615.0522
38	615.0303
38	615.0201
38	615.0102
38	615.0018
38	615.0008
38	616.1212
38	616.4545
38	614.9997
38	614.9929
38	614.7899
40	612.0106
40	611.0082
40	611.0007
40	611.0001
40	610.6844
40	610.6663
40	610.5516
40	610.5004
40	610.3323
40	610.3024
40	610.1447
40	610.1201
40	610.1161
40	610.2021
40	610.0202
40	610.0099
40	610.0175
40	610.0002
40	609.9997
40	611.2888

Decoriptive statictioc: Using Excel, calculate the folowing descriptive statistics and then
Interpret the resuts in context using a business perspective. The analysisinterpretation should
tell management what the descrptive statistic is revealing about the performance of the
packaging process.
The highest bOK weight produced by the packaging process is
638.8639 grams, which is 15.8639 grams above the declared
Descriptive
Statistic
|Analysis/interpretation
Value
Highect Value
638.8639 box label weight of E23 grams. It is also 39.3639 grams above
The packaging process produces boxes with the average
weight of 618.5784 grams, which is 4.4216 grams below the
618.5784 declared box label weight of 623 grams. This could result in
penalization. The packaging process should be reassessed to
LMAV. Ir the packaging process continues to produce boxes
with weights close to the highest value, the company will be
safe from fines litigation, and negative pubicity as it meets
government standards: however, the packaging process should
be evaluated to see if producing boxes with this high of a weight
is sustainable.
Mean
determine where the inefficiency lies.
The median of the data set (exact weights of 500 random
boxes) is dose to the mean, so there is not a large amount of
Or the 500 random boxes sample, 68.2% of the boxes were
341:500 below the declared box label weight. This could result in
0.6820 penalization and heavily suggests a redesign of the packaging
68.2000% process to ensure that the large majority of the boxes produced
Median
618.7498 skewness, and the data is doser to a symmetrical distribution
Proportion of
For the packaging process, this means that the majority of
boxes have a weight around the mean weight.
boxec below
label welght
The box weight that the packaging process most often
produces is at or very close to 618.5069 grams, which is also
meet company targets.
Of the 500 random boxes sample, only 31.8% of the boxes are
above the dedared box label weight. This is considerably less
Proportion of
boxes above
labol welght
159:500
Mode
618.50E9 very close to the average weight.
0.3180 than 1 in every 2 boxes, which heavily suggests that a
31.8000% restructure of the packaging process is needed to ensure that
the company meets management standards and avoids
Each collected weight sample can be expected to be around
+8.5923 grams away from the average weight. The MAV s
23.5 grams, which is more than 2 times greater than the
standard devilation. This shows that 95% of the boxes produced
will be within 2 standard deviations (17.1846 grams) of the
average weight.
negative consequences
Or the 500 random boxes sample, 3.0% of the boxes were
below the LMAV (599.50 grams). The presence of boxes that
do not meet the lowest allowable weight could result in the
3.0000% company receiving fines, Igation, and negative publicity, which
all have detrimental effect on the company's prosperity. It is
essential to restructure the packaging process to make sure this
atandard
8.5923
Proportion of
boxec below
Devlation
15:500
0.0300 /
LMAV
This range (54.29 grams) gives the basic spread of the data
set. In the most extreme cases, the packaging process can
produce boxes that are 54.2900 grams apart in weight, which is
two times the MAV (23.5 grams). This shows that the packaging
process needs to be reevaluated to become more consistent
and decrease the spread of bax weights.
does not continue
The average box weight (618.5784 grams) is about 0.1714
grams less than the median box weight (618.7498) which
negatively means that the data is slighty skewed to the left. Slightly more
skewed of the baxes produced are less than the average bax weight. It
Is important for the company to reevaluate their packaging
process as a significant amount of the boxes from the sample
Range
54.2900
let
akewnecc
The lowest box weight produced by the packaging process s
584.5739 grams, which is 38.4261 grams below the declared
584.5739 box label weight of 623 grams. It is also 14.9261 grams below
LMAV. I the packaging process continues to produce boxes
show that the oompany is failing to meet management targets
and govermment requlations
Lowest Value
with weights close to the lowest value, the company will fal to
meet govemment standards and will face negative
consenuences

Definition Definition Measure of central tendency that is the average of a given data set. The mean value is evaluated as the quotient of the sum of all observations by the sample size. The mean, in contrast to a median, is affected by extreme values. Very large or very small values can distract the mean from the center of the data. Arithmetic mean: The most common type of mean is the arithmetic mean. It is evaluated using the formula: μ = 1 N ∑ i = 1 N x i Other types of means are the geometric mean, logarithmic mean, and harmonic mean. Geometric mean: The nth root of the product of n observations from a data set is defined as the geometric mean of the set: G = x 1 x 2 ... x n n Logarithmic mean: The difference of the natural logarithms of the two numbers, divided by the difference between the numbers is the logarithmic mean of the two numbers. The logarithmic mean is used particularly in heat transfer and mass transfer. ln x 2 − ln x 1 x 2 − x 1 Harmonic mean: The inverse of the arithmetic mean of the inverses of all the numbers in a data set is the harmonic mean of the data. 1 1 x 1 + 1 x 2 + ...

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Centre, Spread, and Shape of a Distribution$

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.