You are the head of an ore mining company that supplies the Lodge Cast Iron company with ore to use in their cast iron cookware. As with many manufacturers, consistency of inputs is key, so part of your contract is that Lodge Cast Iron takes random samples of the ore you provide and checks the density. If the ore density each month remains within three standard deviations from the mean for the measurement period (April – August), you receive a bonus payment of $450,000 per month.
BUS509 – Descriptive Analytics and
Decisions
Unit 2 Assignment: Performance Management of an Iron Ore Factory
Due Date: 11:59 pm EST Sunday of Unit 2
Points: 100
Overview:
You are the head of an ore mining company that supplies the Lodge Cast Iron company
with ore to use in their cast iron cookware. As with many manufacturers, consistency of
inputs is key, so part of your contract is that Lodge Cast Iron takes random samples of
the ore you provide and checks the density. If the ore density each month remains
within three standard deviations from the mean for the measurement period (April –
August), you receive a bonus payment of $450,000 per month.
Instructions:
•
•
•
Using the data given on the average Ore Pulp Density for each day calculate the
mean (average), and the upper and lower control limits using 3x standard
deviation.
Create a control chart that is well labeled with descriptive titles and axis labels.
Create a Slide that includes the chart, and a bullet point or two about the bonus
payment you are expecting.
Requirements:
•
•
A one-page slide including the chart and bullet point(s) about the bonus payment
you are expecting. The slide is well formatted.
Excel workbook showing your formulas and work.
Be sure to read the criteria below by which your work will be evaluated before
you write and again after you write.
Evaluation Rubric
Criteria
Correct Mean,
and Standard
Deviation
Chart Exercise
and PowerPoint
slide
Bullet point(s)
Exemplary
35
Mean and Standard
Deviation data and
formulas are correct
45
Chart and clear, well
labeled and easily
digestible. Slide is well
formatted and
professional.
20
Bonus amount is correct,
details of what month you
were out of range, and
your overall performance
included
Proficient
19-34
Formula has minor errors
Deficient
0-18
Formula incorrect or data
missing.
30-44
Chart displays data, but
not easily understandable
or labeled. Slide is
formatted and readable.
0-29
Chart does not include
data, or data is not
readable by an average
reader. Slide is
unformatted or unclear.
0-11
Bonus amount is incorrect
or missing.
12-19
Bonus amount is correct
Date
2017-04-01
2017-04-02
2017-04-03
2017-04-04
2017-04-05
2017-04-06
2017-04-07
2017-04-08
2017-04-09
2017-04-10
2017-04-11
2017-04-12
2017-04-13
2017-04-14
2017-04-15
2017-04-16
2017-04-17
2017-04-18
2017-04-19
2017-04-20
2017-04-21
2017-04-22
2017-04-23
2017-04-24
2017-04-25
2017-04-26
2017-04-27
2017-04-28
2017-04-29
2017-04-30
2017-05-01
2017-05-02
2017-05-03
2017-05-04
2017-05-05
2017-05-06
2017-05-07
2017-05-08
2017-05-09
2017-05-10
2017-05-11
2017-05-12
2017-05-13
2017-05-14
2017-05-15
2017-05-16
Average of Starch Flow Average of Ore Pulp Flow
Average of Ore Pulp Density
1,993.74
399.66
1.74
1,941.66
399.85
1.74
1,885.65
398.49
1.69
2,060.08
400.05
1.68
2,043.83
400.33
1.69
1,911.48
399.83
1.73
1,936.21
400.36
1.74
1,979.95
399.31
1.74
2,084.56
399.72
1.71
1,890.92
398.22
1.67
1,175.63
388.58
1.61
1,739.02
399.79
1.72
2,030.01
399.46
1.74
1,879.15
399.75
1.72
1,974.23
399.84
1.76
2,001.61
399.88
1.74
1,716.63
399.60
1.70
1,694.05
399.45
1.66
2,048.75
399.81
1.67
2,116.25
399.90
1.71
1,790.74
399.71
1.70
1,885.63
399.71
1.67
1,826.67
400.05
1.65
2,018.48
400.12
1.69
1,250.75
403.81
1.60
2,008.89
399.89
1.70
2,105.49
400.09
1.72
1,948.71
401.45
1.66
2,001.14
398.55
1.74
1,771.57
408.19
1.71
1,806.30
399.36
1.69
1,872.93
400.04
1.72
2,073.10
400.38
1.73
2,303.07
410.07
1.73
3,356.06
402.56
1.62
2,923.60
400.12
1.65
3,675.13
399.80
1.70
3,435.89
399.51
1.72
2,805.89
399.99
1.66
1,501.31
402.11
1.56
2,941.78
403.33
1.68
3,029.58
400.30
1.68
3,885.06
402.21
1.68
3,671.20
405.90
1.65
3,070.70
402.51
1.66
3,174.39
400.46
1.63
2017-05-17
2017-05-18
2017-05-19
2017-05-20
2017-05-21
2017-05-22
2017-05-23
2017-05-24
2017-05-25
2017-05-26
2017-05-27
2017-05-28
2017-05-29
2017-05-30
2017-05-31
2017-06-01
2017-06-02
2017-06-03
2017-06-04
2017-06-05
2017-06-06
2017-06-07
2017-06-08
2017-06-09
2017-06-10
2017-06-11
2017-06-12
2017-06-13
2017-06-14
2017-06-15
2017-06-16
2017-06-17
2017-06-18
2017-06-19
2017-06-20
2017-06-21
2017-06-22
2017-06-23
2017-06-24
2017-06-25
2017-06-26
2017-06-27
2017-06-28
2017-06-29
2017-06-30
2017-07-01
2017-07-02
3,234.01
3,310.28
3,106.03
2,959.81
3,281.40
3,089.30
2,986.31
2,213.08
2,972.94
2,902.93
2,864.52
3,215.59
2,812.95
3,041.98
2,474.27
2,977.81
2,608.29
2,627.18
2,942.44
2,980.25
2,741.99
2,261.38
3,289.69
3,637.21
3,796.04
3,772.13
3,403.10
3,286.16
2,891.71
2,790.12
2,617.64
3,481.85
3,286.76
3,479.74
3,244.91
1,552.39
2,388.71
2,469.29
2,940.65
3,085.82
4,178.15
3,320.93
3,321.33
3,220.64
3,522.05
3,749.02
3,055.34
399.50
400.29
400.35
400.07
400.06
399.55
400.07
398.72
400.25
400.99
400.64
399.29
400.40
399.95
400.66
400.11
399.79
400.49
400.63
399.93
399.98
399.80
399.52
400.27
400.05
399.90
400.45
400.07
400.33
400.70
399.69
401.22
400.27
402.28
402.98
396.54
400.48
399.65
400.13
400.55
400.57
400.22
402.37
399.92
401.06
400.10
399.75
1.71
1.69
1.65
1.64
1.64
1.65
1.67
1.59
1.65
1.65
1.64
1.63
1.60
1.66
1.62
1.67
1.65
1.65
1.64
1.67
1.65
1.61
1.65
1.67
1.68
1.68
1.65
1.64
1.66
1.60
1.62
1.68
1.67
1.70
1.70
1.58
1.68
1.68
1.68
1.70
1.71
1.66
1.70
1.70
1.70
1.70
1.62
2017-07-03
2017-07-04
2017-07-05
2017-07-06
2017-07-07
2017-07-08
2017-07-09
2017-07-10
2017-07-11
2017-07-12
2017-07-13
2017-07-14
2017-07-15
2017-07-16
2017-07-17
2017-07-18
2017-07-19
2017-07-20
2017-07-21
2017-07-22
2017-07-23
2017-07-24
2017-07-25
2017-07-26
2017-07-27
2017-07-28
2017-07-29
2017-07-30
2017-07-31
2017-08-01
2017-08-02
2017-08-03
2017-08-04
2017-08-05
2017-08-06
2017-08-07
2017-08-08
2017-08-09
2017-08-10
2017-08-11
2017-08-12
2017-08-13
2017-08-14
2017-08-15
2017-08-16
2017-08-17
2017-08-18
2,746.46
1,781.44
2,655.32
2,674.62
3,763.88
3,579.46
3,466.74
3,631.38
3,007.18
3,342.37
3,382.21
3,881.02
3,272.48
3,642.23
3,494.25
4,018.75
4,390.65
3,236.77
3,688.84
2,959.62
3,406.21
3,609.57
3,835.83
3,603.91
2,962.92
2,948.39
3,588.84
3,132.18
2,828.40
2,590.87
2,264.86
2,871.49
3,247.33
3,530.26
2,718.90
2,673.87
3,289.43
2,956.94
3,043.96
3,630.35
3,252.00
4,165.58
2,860.15
3,269.74
3,120.68
1,936.99
2,978.99
400.21
400.17
400.86
396.60
400.51
399.77
400.24
400.15
400.56
400.11
401.90
400.18
399.80
400.91
399.99
399.70
401.98
404.16
399.94
400.09
399.98
400.30
400.13
400.42
400.24
399.46
400.97
400.35
391.17
390.99
387.25
387.93
384.52
393.44
383.15
382.17
386.40
379.89
383.38
387.27
387.09
388.47
381.24
389.95
395.80
388.32
388.41
1.65
1.64
1.65
1.60
1.69
1.71
1.71
1.71
1.69
1.70
1.64
1.71
1.69
1.69
1.69
1.70
1.72
1.69
1.70
1.70
1.70
1.69
1.71
1.70
1.68
1.64
1.70
1.71
1.67
1.69
1.62
1.68
1.71
1.70
1.70
1.68
1.71
1.69
1.68
1.70
1.68
1.69
1.70
1.69
1.70
1.63
1.67
2017-08-19
2017-08-20
2017-08-21
2017-08-22
2017-08-23
2017-08-24
2017-08-25
2017-08-26
2017-08-27
2017-08-28
2017-08-29
2017-08-30
2017-08-31
Grand Total
3,442.74
2,988.37
2,951.95
3,487.45
3,365.72
2,985.45
2,826.51
2,930.86
2,982.88
3,029.66
2,906.90
3,030.77
3,417.03
2,855.53
393.08
386.75
385.44
387.74
385.26
386.70
387.48
385.81
389.81
397.40
385.02
388.28
385.36
397.67
1.71
1.71
1.70
1.71
1.69
1.70
1.67
1.70
1.68
1.70
1.69
1.66
1.69
1.68

Purchase answer to see full
attachment