Chat with us, powered by LiveChat pls look at the docs 21FallB Flavor Total Gallons Sold Same Qtr Last Yr Vanilla 54,853.00 C | Max paper
  

pls look at the docs

21FallB

Flavor Total Gallons Sold Same Qtr Last Yr
Vanilla 54,853.00
Chocolate 76,363.00
Strawberry 22,307.00
Maple Walnut 11,190.00
Praline 14,128.00
Butter Pecan 16,008.00
Chocolate Chip 34,930.00
Mint Chocolate Chip 18,534.00
Cookie Dough 22,991.00
Rocky Road 16,227.00
Fudge Swirl 18,276.00
Peach 23,179.00
Pumpkin 5,149.00
Marshmallow Fudge 5,161.00
Coffee 43,188.00
Mocha Chip 32,764.00
Raspberry
Watermelon 19,258.00
Cinnamon Spice – 0
FOR FA2017 USE ONLY
FNU-1

Flavor-21FallB

Unit Conversions:
Pints per Gallon 8.00
Gallons per Tub 10.00
Flavor #Pints Containers Sold Current Qtr #Gallons Containers Sold Current Qtr #Tubs Used Current Qtr
Vanilla 147,829 6,927 1,148.15
Chocolate 215,191 17,104 5,895.33
Strawberry 30,253 3,231 1,887.84
Maple Walnut 51,762 2,489 535.01
Praline 68,612 2,532 819.58
Butter Pecan 34,525 2,571 132.63
Chocolate Chip 89,193 4,222 1,782.90
Mint Chocolate Chip 100,305 1,229 354.01
Cookie Dough 82,110 2,736 1,023.65
Rocky Road 41,568 3,430 979.84
Fudge Swirl 57,171 2,800 1,357.90
Peach 59,227 1,423 1,110.52
Pumpkin – 0 – 0 – 0
Marshmallow Fudge 7,620 650 268.37
Coffee 228,592 5,547 2,081.75
Mocha Chip 117,849 4,742 185.74
Raspberry – 0 – 0 – 0
Watermelon 54,154 2,423 1,478.99
Cinnamon Spice – 0 – 0 – 0
Chocolate Fudge 52,747 3,083 158.11
Cherry Vanilla 69,125 3,536 1,437.34
FOR FA2017 USE ONLY
FNU-1

Stores-21FallB

Store# Sales
101 2,559
102 9,439
103 8,829
104 13,440
105 1,624
106 1,686
107 12,296
108 18,041
109 5,291
110 12,646
111 14,399
112 11,221
113 8,740
114 12,200
115 18,444
116 17,578
117 1,393
118 7,933
119 9,347
120 1,644
121 607
122 15,000
123 16,260
124 1,912
125 14,840
126 12,273
127 1,363
128 2,511
129 4,866
130 5,733
131 4,643
132 6,758
133 5,761
134 12,754
135 6,978
136 10,603
137 15,278
138 5,918
139 3,475
140 16,061
141 13,633
142 5,750
143 10,693
144 13,421
145 2,216
146 5,913
147 16,567
148 9,486
149 8,146
150 12,380
151 7,197
152 17,090
153 1,347
154 5,997
155 15,750
156 6,425
157 4,734
158 11,067
159 15,513
160 3,320
161 14,248
162 3,131
163 931
164 14,497
165 12,605
166 4,578
167 5,192
168 10,127
169 15,405
170 2,509
171 14,243
172 15,951
173 2,898
174 11,366
175 8,152
176 3,928
177 19,340
178 9,673
179 19,088
180 7,556
181 17,311
182 15,331
183 12,061
184 17,106
185 9,170
186 6,539
187 14,784
188 8,991
189 1,353
190 7,795
191 – 0
192 13,857
193 11,129
194 14,897
195 10,308
196 9,037
197 18,210
198 20,503
199 13,689
200 5,456
201 11,350
202 10,000
203 6,153
204 15,577
205 7,636
206 4,648
207 1,216
208 8,419
209 9,755
210 2,478
211 14,092
212 8,326
213 8,821
214 1,362
215 4,779
216 10,073
217 12,956
218 13,721
219 11,264
220 15,370
221 12,920
222 14,555
223 15,748
224 18,827
225 6,865
226 3,528
227 8,410
228 16,427
229 852
230 2,326
231 11,893
232 261
233 16,355
234 12,345
235 13,690
236 15,876
237 9,083
238 3,079
239 6,091
240 3,644
241 1,035
242 2,343
243 11,346
244 3,573
245 6,351
246 12,052
247 7,659
248 16,054
249 4,476
250 7,953
251 7,568
252 10,006
253 6,886
254 7,862
255 1,438
256 4,054
257 10,662
258 8,683
259 13,904
260 11,232
261 12,709
262 3,301
263 5,956
264 3,415
265 8,810
266 9,361
267 11,871
268 7,574
269 12,939
270 9,425
271 7,127
272 2,125
273 10,927
274 19,181
275 15,955
276 1,661
277 1,131
278 1,226
279 4,853
280 12,355
281 6,454
282 14,284
283 1,856
284 1,371
285 14,971
286 11,443
287 9,361
288 3,581
289 3,922
290 1,945
291 8,468
292 17,420
293 8,301
294 6,601
295 12,385
296 4,494
297 15,570
298 2,386
299 9,109
300 5,181
301 8,935

SiteA-21FallB

Respondent# Age Category Income #Desserts Out per Month #Meals Out per Month
1000 22-25 6000 4 5
1001 30-35 102000 5 15
1002 26-30 76000 3 24
1003 18-21 43000 1 16
1004 30-35 103000 12 4
1005 26-30 51000 9 19
1006 30-35 24000 1 8
1007 30-35 105000 18 12
1008 30-35 25000 14 7
1009 30-35 103000 5 20
1010 30-35 79000 1 0
1011 18-21 34000 0 6
1012 22-25 31000 4 12
1013 18-21 33000 0 3
1014 18-21 7000 1 5
1015 over 35 53000 1 8
1016 30-35 45000 1 2
1017 26-30 24000 11 3
1018 30-35 101000 11 13
1019 18-21 35000 0 3
1020 30-35 34000 3 13
1021 26-30 77000 1 21
1022 18-21 10000 1 10
1023 22-25 23000 1 2
1024 18-21 13000 0 0
1025 22-25 10000 13 20
1026 26-30 76000 5 11
1027 over 35 21000 4 2
1028 22-25 10000 14 6
1029 over 35 102000 12 13
1030 18-21 12000 0 3
1031 18-21 15000 1 7
1032 26-30 101000 12 7
1033 22-25 11000 3 5
1034 22-25 54000 13 9
1035 22-25 24000 6 3
1036 26-30 23000 6 11
1037 18-21 12000 0 2
1038 30-35 76000 1 4
1039 22-25 35000 20 10
1040 30-35 103000 2 7
1041 18-21 9000 0 4
1042 22-25 13000 8 1
1043 22-25 24000 21 2
1044 30-35 24000 9 3
1045 18-21 22000 0 19
1046 18-21 9000 1 3
1047 26-30 8000 10 3
1048 22-25 8000 15 5
1049 22-25 54000 15 14
1050 22-25 42000 21 23
1051 22-25 53000 13 10
1052 22-25 7000 4 4
1053 18-21 41000 1 10
1054 30-35 104000 3 16
1055 26-30 55000 20 13
1056 18-21 33000 0 2
1057 18-21 33000 0 7
1058 30-35 103000 7 17
1059 26-30 34000 6 11
1060 18-21 13000 0 1
1061 26-30 80000 18 1
1062 over 35 104000 8 11
1063 30-35 9000 1 3
1064 18-21 33000 1 10
1065 22-25 101000 7 12
1066 30-35 7000 2 2
1067 over 35 54000 7 8
1068 26-30 25000 2 2
1069 26-30 51000 7 3
1070 26-30 34000 3 8
1071 18-21 21000 0 3
1072 30-35 45000 10 18
1073 26-30 34000 3 4
1074 18-21 7000 0 12
1075 over 35 11000 21 2
1076 26-30 21000 25 2
1077 18-21 7000 0 1
1078 22-25 53000 5 9
1079 over 35 21000 2 7
1080 18-21 35000 0 9
1081 30-35 102000 14 15
1082 26-30 8000 2 3
1083 30-35 104000 9 16
1084 26-30 24000 18 3
1085 18-21 43000 0 1
1086 18-21 33000 1 3
1087 18-21 31000 0 6
1088 26-30 9000 18 1
1089 over 35 14000 8 4
1090 22-25 77000 13 6
1091 18-21 13000 1 4
1092 26-30 23000 11 3
1093 26-30 43000 23 15
1094 18-21 12000 1 5
1095 22-25 78000 17 2
1096 18-21 32000 0 3
1097 22-25 77000 12 5
1098 22-25 105000 17 21
1099 18-21 6000 1 9
1100 18-21 42000 1 9
1101 over 35 103000 8 2
1102 22-25 8000 4 1
1103 26-30 14000 5 1
1104 26-30 78000 5 8
1105 26-30 34000 5 3
1106 over 35 105000 0 1
FNU-1

SiteB-21FallB

Respondent# Age Category Income #Desserts Out per Month #Meals Out per Month
2000 30-35 75000 0 13
2001 30-35 30000 10 7
2002 26-30 5000 4 24
2003 18-21 20000 0 5
2004 30-35 100000 5 16
2005 26-30 20000 10 19
2006 30-35 75000 8 9
2007 30-35 100000 10 5
2008 30-35 30000 5 9
2009 30-35 75000 4 13
2010 30-35 100000 4 4
2011 18-21 30000 7 5
2012 22-25 5000 9 14
2013 18-21 30000 0 3
2014 18-21 30000 0 13
2015 over 35 100000 0 17
2016 30-35 100000 7 3
2017 26-30 50000 4 5
2018 30-35 100000 17 14
2019 18-21 20000 10 8
2020 30-35 75000 13 9
2021 26-30 10000 2 23
2022 18-21 5000 11 8
2023 30-35 40000 0 7
2024 30-35 30000 15 10
2025 22-25 50000 2 16
2026 over 35 10000 4 2
2027 over 35 40000 12 3
2028 22-25 30000 14 15
2029 over 35 40000 10 12
2030 18-21 10000 0 0
2031 18-21 10000 8 13
2032 26-30 40000 0 6
2033 22-25 30000 16 22
2034 22-25 30000 3 27
2035 22-25 20000 6 6
2036 26-30 5000 7 20
2037 18-21 20000 19 7
2038 30-35 5000 8 14
2039 22-25 5000 5 6
2040 30-35 40000 1 14
2041 18-21 40000 8 19
2042 over 35 10000 6 3
2043 22-25 100000 2 28
2044 over 35 50000 24 9
2045 18-21 10000 5 7
2046 18-21 10000 18 13
2047 26-30 5000 2 17
2048 22-25 10000 2 5
2049 22-25 100000 3 17
2050 22-25 30000 4 14
2051 22-25 30000 11 25
2052 22-25 20000 1 9
2053 18-21 30000 18 19
2054 over 35 20000 19 4
2055 26-30 30000 12 9
2056 18-21 10000 5 17
2057 18-21 40000 11 5
2058 30-35 100000 1 4
2059 26-30 20000 1 11
2060 18-21 20000 14 5
2061 26-30 40000 3 3
2062 over 35 50000 2 3
2063 30-35 30000 10 4
2064 18-21 10000 9 1
2065 22-25 75000 9 9
2066 30-35 100000 8 4
2067 over 35 100000 15 11
2068 over 35 20000 1 2
2069 over 35 50000 2 10
2070 26-30 100000 2 25
2071 18-21 20000 23 13
2072 30-35 75000 18 1
2073 26-30 10000 3 8
2074 18-21 5000 17 21
2075 over 35 10000 2 3
2076 26-30 30000 8 4
2077 18-21 5000 20 12
2078 22-25 5000 0 6
2079 over 35 100000 7 15
2080 18-21 40000 14 23
2081 30-35 40000 0 12
2082 26-30 30000 18 9
2083 30-35 100000 3 15
2084 30-35 30000 17 19
2085 18-21 5000 8 6
2086 18-21 20000 1 9
2087 18-21 30000 3 21
2088 26-30 100000 2 24
2089 over 35 100000 15 6
2090 22-25 20000 4 17
2091 18-21 30000 1 13
2092 26-30 100000 12 13
2093 26-30 20000 1 9
2094 18-21 10000 6 9
2095 22-25 5000 17 18
2096 18-21 10000 0 22
2097 22-25 20000 4 13
2098 22-25 100000 0 5
2099 18-21 10000 6 7
2100 18-21 10000 11 3
2101 over 35 40000 15 2
2102 22-25 75000 2 6
2103 30-35 30000 5 14
2104 26-30 5000 2 11
2105 30-35 100000 1 4
2106 over 35 10000 10 7

Current

Quality Control Data for TZBlazer Skis
Mfg ID# Size Style Date Manufactured Production Line Friction Coefficient Torsion Strength Ski Cost
12134 174 A 11/17 1 0.82 2.21 $ 54.50
12135 174 A 11/17 1 0.49 1.94 54.50
12139 174 A 11/17 1 0.52 2.03 54.50
12140 167 A 11/17 1 0.63 2.24 45.50
12142 167 A 11/17 1 0.64 2.28 45.50
12144 167 A 11/17 1 1.28 2.31 45.50
12145 174 A 11/17 1 0.45 2.02 54.50
12146 167 A 11/17 1 1.13 2.05 45.50
12148 167 E 11/18 1 0.43 2.27 55.50
12149 174 E 11/18 1 0.47 2.31 64.50
12154 174 E 11/18 1 0.97 2.23 64.50
12156 174 E 11/18 1 0.81 2.11 64.50
12160 174 E 11/19 1 0.68 2.22 64.50
12161 174 E 11/19 1 0.67 2.08 64.50
12162 181 E 11/19 1 0.95 2.01 70.50
12136 181 R 11/17 2 1.32 2.35 82.50
12137 181 R 11/17 2 0.75 1.73 82.50
12138 181 R 11/17 2 0.92 2.08 82.50
12141 181 R 11/17 2 0.46 2.26 82.50
12143 174 R 11/17 2 1.04 2.24 76.50
12147 181 A 11/18 2 0.90 2.01 60.50
12150 167 A 11/18 2 0.97 2.00 45.50
12151 181 A 11/18 2 0.49 2.08 60.50
12152 181 A 11/18 2 0.75 2.17 60.50
12153 167 A 11/18 2 0.30 3.22 45.50
12155 181 E 11/18 2 1.01 2.24 70.50
12157 181 E 11/19 2 0.84 2.34 70.50
12158 174 E 11/19 2 0.68 2.10 64.50
12159 181 A 11/19 2 0.58 2.33 70.50

HighLow

Analysis of QC Data Extreme Values
Top 5 (Highest) Bottom 5 (Lowest)
Friction Coefficient Torsion Strength Friction Coefficient Torsion Strength
1
2
3
4
5

Figure2.15

Quality Control Data for TZBlazer Skis
Mfg ID# Size Style Date Manufactured Production Line Friction Coefficient Torsion Strength Ski Cost
12134 174 A 11/17 1 0.82 2.21 $ 54.50
12135 174 A 11/17 1 0.49 1.94 54.50
12139 174 A 11/17 1 0.52 2.03 54.50
12140 167 A 11/17 1 0.63 2.24 45.50
12142 167 A 11/17 1 0.64 2.28 45.50
12144 167 A 11/17 1 1.28 2.31 45.50
12145 174 A 11/17 1 0.45 2.02 54.50
12146 167 A 11/17 1 1.13 2.05 45.50
12148 167 E 11/18 1 0.43 2.27 55.50
12149 174 E 11/18 1 0.47 2.31 64.50
12154 174 E 11/18 1 0.97 2.23 64.50
12156 174 E 11/18 1 0.81 2.11 64.50
12160 174 E 11/19 1 0.68 2.22 64.50
12161 174 E 11/19 1 0.67 2.08 64.50
12162 181 E 11/19 1 0.95 2.01 70.50
12136 181 R 11/17 2 1.32 2.35 82.50
12137 181 R 11/17 2 0.75 1.73 82.50
12138 181 R 11/17 2 0.92 2.08 82.50
12141 181 R 11/17 2 0.46 2.26 82.50
12143 174 R 11/17 2 1.04 2.24 76.50
12147 181 A 11/18 2 0.90 2.01 60.50
12150 167 A 11/18 2 0.97 2.00 45.50
12151 181 A 11/18 2 0.49 2.08 60.50
12152 181 A 11/18 2 0.75 2.17 60.50
12153 167 A 11/18 2 0.30 3.22 45.50
12155 181 E 11/18 2 1.01 2.24 70.50
12157 181 E 11/19 2 0.84 2.34 70.50
12158 174 E 11/19 2 0.68 2.10 64.50
12159 181 A 11/19 2 0.58 2.33 70.50

Figure2.16

Quality Control Data for TZBlazer Skis
Mfg ID# Size Style Date Manufactured Production Line Friction Coefficient Torsion Strength Ski Cost
12134 174 A 11/17 1 0.82 2.21 $ 54.50
12135 174 A 11/17 1 0.49 1.94 54.50
12139 174 A 11/17 1 0.52 2.03 54.50
12140 167 A 11/17 1 0.63 2.24 45.50
12142 167 A 11/17 1 0.64 2.28 45.50
12144 167 A 11/17 1 1.28 2.31 45.50
12145 174 A 11/17 1 0.45 2.02 54.50
12146 167 A 11/17 1 1.13 2.05 45.50
12148 167 E 11/18 1 0.43 2.27 55.50
12149 174 E 11/18 1 0.47 2.31 64.50
12154 174 E 11/18 1 0.97 2.23 64.50
12156 174 E 11/18 1 0.81 2.11 64.50
12160 174 E 11/19 1 0.68 2.22 64.50
12161 174 E 11/19 1 0.67 2.08 64.50
12162 181 E 11/19 1 0.95 2.01 70.50
12136 181 R 11/17 2 1.32 2.35 82.50
12137 181 R 11/17 2 0.75 1.73 82.50
12138 181 R 11/17 2 0.92 2.08 82.50
12141 181 R 11/17 2 0.46 2.26 82.50
12143 174 R 11/17 2 1.04 2.24 76.50
12147 181 A 11/18 2 0.90 2.01 60.50
12150 167 A 11/18 2 0.97 2.00 45.50
12151 181 A 11/18 2 0.49 2.08 60.50
12152 181 A 11/18 2 0.75 2.17 60.50
12153 167 A 11/18 2 0.30 3.22 45.50
12155 181 E 11/18 2 1.01 2.24 70.50
12157 181 E 11/19 2 0.84 2.34 70.50
12158 174 E 11/19 2 0.68 2.10 64.50
12159 181 A 11/19 2 0.58 2.33 70.50

Figure2.17

Quality Control Data for TZBlazer Skis
Mfg ID# Size Style Date Manufactured Production Line Friction Coefficient Torsion Strength Ski Cost
12134 174 A 11/17 1 0.82 2.21 $ 54.50
12135 174 A 11/17 1 0.49 1.94 54.50
12139 174 A 11/17 1 0.52 2.03 54.50
12140 167 A 11/17 1 0.63 2.24 45.50
12142 167 A 11/17 1 0.64 2.28 45.50
12144 167 A 11/17 1 1.28 2.31 45.50
12145 174 A 11/17 1 0.45 2.02 54.50
12146 167 A 11/17 1 1.13 2.05 45.50
12148 167 E 11/18 1 0.43 2.27 55.50
12149 174 E 11/18 1 0.47 2.31 64.50
12154 174 E 11/18 1 0.97 2.23 64.50
12156 174 E 11/18 1 0.81 2.11 64.50
12160 174 E 11/19 1 0.68 2.22 64.50
12161 174 E 11/19 1 0.67 2.08 64.50
12162 181 E 11/19 1 0.95 2.01 70.50
12136 181 R 11/17 2 1.32 2.35 82.50
12137 181 R 11/17 2 0.75 1.73 82.50
12138 181 R 11/17 2 0.92 2.08 82.50
12141 181 R 11/17 2 0.46 2.26 82.50
12143 174 R 11/17 2 1.04 2.24 76.50
12147 181 A 11/18 2 0.90 2.01 60.50
12150 167 A 11/18 2 0.97 2.00 45.50
12151 181 A 11/18 2 0.49 2.08 60.50
12152 181 A 11/18 2 0.75 2.17 60.50
12153 167 A 11/18 2 0.30 3.22 45.50
12155 181 E 11/18 2 1.01 2.24 70.50
12157 181 E 11/19 2 0.84 2.34 70.50
12158 174 E 11/19 2 0.68 2.10 64.50
12159 181 A 11/19 2 0.58 2.33 70.50
29 0.76 2.19 $ 1,803.50
# of Skis Average Average Total Value

Figure2.18

Figure2.19

Quality Control Data for TZBlazer Skis
Mfg ID# Size Style Date Manufactured Production Line Friction Coefficient Torsion Strength Ski Cost Rank Friction Coefficient Rank Torsion Strength
12134 174 A 11/17 1 0.82 2.21 $ 54.50 18 15
12135 174 A 11/17 1 0.49 1.94 54.50 6 28
12139 174 A 11/17 1 0.52 2.03 54.50 8 23
12140 167 A 11/17 1 0.63 2.24 45.50 10 10
12142 167 A 11/17 1 0.64 2.28 45.50 11 7
12144 167 A 11/17 1 1.28 2.31 45.50 28 5
12145 174 A 11/17 1 0.45 2.02 54.50 3 24
12146 167 A 11/17 1 1.13 2.05 45.50 27 22
12148 167 E 11/18 1 0.43 2.27 55.50 2 8
12149 174 E 11/18 1 0.47 2.31 64.50 5 5
12154 174 E 11/18 1 0.97 2.23 64.50 23 13
12156 174 E 11/18 1 0.81 2.11 64.50 17 17
12160 174 E 11/19 1 0.68 2.22 64.50 13 14
12161 174 E 11/19 1 0.67 2.08 64.50 12 19
12162 181 E 11/19 1 0.95 2.01 70.50 22 25
12136 181 R 11/17 2 1.32 2.35 82.50 29 2
12137 181 R 11/17 2 0.75 1.73 82.50 15 29
12138 181 R 11/17 2 0.92 2.08 82.50 21 19
12141 181 R 11/17 2 0.46 2.26 82.50 4 9
12143 174 R 11/17 2 1.04 2.24 76.50 26 10
12147 181 A 11/18 2 0.90 2.01 60.50 20 25
12150 167 A 11/18 2 0.97 2.00 45.50 23 27
12151 181 A 11/18 2 0.49 2.08 60.50 6 19
12152 181 A 11/18 2 0.75 2.17 60.50 15 16
12153 167 A 11/18 2 0.30 3.22 45.50 1 1
12155 181 E 11/18 2 1.01 2.24 70.50 25 10
12157 181 E 11/19 2 0.84 2.34 70.50 19 3
12158 174 E 11/19 2 0.68 2.10 64.50 13 18
12159 181 A 11/19 2 0.58 2.33 70.50 9 4
29 0.76 2.19 $ 1,803.50
# of Skis Average Average Total Value

Figure2.20

Analysis of QC Data Extreme Values
Top 5 (Highest) Bottom 5 (Lowest)
Friction Coefficient Torsion Strength Friction Coefficient Torsion Strength
1
2
3
4
5

Figure2.21

Analysis of QC Data Extreme Values
Top 5 (Highest) Bottom 5 (Lowest)
Friction Coefficient Torsion Strength Friction Coefficient Torsion Strength
1 1.32 3.22
2 1.28 2.35
3 1.13 2.34
4 1.04 2.33
5 1.01 2.31

Figure2.22

Analysis of QC Data Extreme Values
Top 5 (Highest) Bottom 5 (Lowest)
Friction Coefficient Torsion Strength Friction Coefficient Torsion Strength
1 1.32 3.22 0.30 1.73
2 1.28 2.35 0.43 1.94
3 1.13 2.34 0.45 2.00
4 1.04 2.33 0.46 2.01
5 1.01 2.31 0.47 2.01

Figure2.23

Quality Control Data for TZBlazer Skis
MFG ID# Size Style Date Manufactured Production Line Friction Coefficient Torsion Strength Inspector ID Shipped
12134 174 A 11/17 1 0.82 2.21 A313 TRUE
12135 174 a 11/17 1 0.49 1.94 A328 FALSE
12139 174 A 11/17 1 0.52 2.03 B224 TRUE
12140 167 A 11/17 1 0.63 2.24 B224 TRUE
12142 167 A 11/17 1 0.64 2.28 AA313 TRUE
12144 167 A 11/17 1 1.28 2.31 A417 TRUE
12145 174 A 11/17 1 0.45 2.02 A313 TRUE
12146 167 AA 11/17 1 1.13 2.05 B313 TRUE
12148 167 E 11/18 1 0.43 2.27 C321 TRUE
12149 174 E 11/18 1 0.47 2.31 C321 TRUE
12154 174 E 11/18 1 0.97 2.23 A328 FALSE
# In style A – text 7
# Size 167 – numerical value 5
# Shipped – Boolean value 9
# sizes equal to value in cell F18 167 5
# > 1.0 FC 2
# from inspectors starting with A 6
# from inspectors with ID# with any letter followed by 313 3

Figure2.24

Quality Control Data for TZBlazer Skis
Mfg ID# Size Style Date Manufactured Production Line Friction Coefficient Torsion Strength Ski Cost Rank Friction Coefficient Rank Torsion Strength
12134 174 A 11/17 1 0.82 2.21 $ 54.50 18 15
12135 174 A 11/17 1 0.49 1.94 54.50 6 28
12139 174 A 11/17 1 0.52 2.03 54.50 8 23
12140 167 A 11/17 1 0.63 2.24 45.50 10 10
12142 167 A 11/17 1 0.64 2.28 45.50 11 7
12144 167 A 11/17 1 1.28 2.31 45.50 28 5
12145 174 A 11/17 1 0.45 2.02 54.50 3 24
12146 167 A 11/17 1 1.13 2.05 45.50 27 22
12148 167 E 11/18 1 0.43 2.27 55.50 2 8
12149 174 E 11/18 1 0.47 2.31 64.50 5 5
12154 174 E 11/18 1 0.97 2.23 64.50 23 13
12156 174 E 11/18 1 0.81 2.11 64.50 17 17
12160 174 E 11/19 1 0.68 2.22 64.50 13 14
12161 174 E 11/19 1 0.67 2.08 64.50 12 19
12162 181 E 11/19 1 0.95 2.01 70.50 22 25
12136 181 R 11/17 2 1.32 2.35 82.50 29 2
12137 181 R 11/17 2 0.75 1.73 82.50 15 29
12138 181 R 11/17 2 0.92 2.08 82.50 21 19
12141 181 R 11/17 2 0.46 2.26 82.50 4 9
12143 174 R 11/17 2 1.04 2.24 76.50 26 10
12147 181 A 11/18 2 0.90 2.01 60.50 20 25
12150 167 A 11/18 2 0.97 2.00 45.50 23 27
12151 181 A 11/18 2 0.49 2.08 60.50 6 19
12152 181 A 11/18 2 0.75 2.17 60.50 15 16
12153 167 A 11/18 2 0.30 3.22 45.50 1 1
12155 181 E 11/18 2 1.01 2.24 70.50 25 10
12157 181 E 11/19 2 0.84 2.34 70.50 19 3
12158 174 E 11/19 2 0.68 2.10 64.50 13 18
12159 181 A 11/19 2 0.58 2.33 70.50 9 4
29 0.76 2.19 $ 1,803.50
# of Skis Average Average Total Value
# Rejected 2 2

Figure2.25

Quality Control Data for TZBlazer Skis
Mfg ID# Size Style Date Manufactured Production Line Friction Coefficient Torsion Strength Ski Cost Rank Friction Coefficient Rank Torsion Strength
12134 174 A 11/17 1 0.82 2.21 $ 54.50 16 13
12135 174 A 11/17 1 1.94 54.50 26
12139 174 A 11/17 1 0.52 2.03 54.50 7 21
12140 167 A 11/17 1 0.63 2.24 45.50 9 8
12142 167 A 11/17 1 0.64 2.28 45.50 10 5
12144 167 A 11/17 1 1.28 45.50 26
12145 174 A 11/17 1 0.45 2.02 54.50 3 22
12146 167 A 11/17 1 1.13 2.05 45.50 25 20
12148 167 E 11/18 1 0.43 2.27 55.50 2 6
12149 174 E 11/18 1 0.47 2.31 64.50 5 4
12154 174 E 11/18 1 0.97 2.23 64.50 21 11
12156 174 E 11/18 1 0.81 2.11 64.50 15 15
12160 174 E 11/19 1 0.68 2.22 64.50 12 12
12161 174 E 11/19 1 0.67 2.08 64.50 11 17
12162 181 E 11/19 1 0.95 2.01 70.50 20 23
12136 181 R 11/17 2 1.32 82.50 27
12137 181 R 11/17 2 1.73 82.50 27
12138 181 R 11/17 2 0.92 2.08 82.50 19 17
12141 181 R 11/17 2 0.46 2.26 82.50 4 7
12143 174 R 11/17 2 1.04 2.24 76.50 24 8
12147 181 A 11/18 2 0.90 2.01 60.50 18 23
12150 167 A 11/18 2 0.97 2.00 45.50 21 25
12151 181 A 11/18 2 0.49 2.08 60.50 6 17
12152 181 A 11/18 2 0.75 2.17 60.50 14 14
12153 167 A 11/18 2 0.30 3.22 45.50 1 1
12155 181 E 11/18 2 1.01 2.24 70.50 23 8
12157 181 E 11/19 2 0.84 2.34 70.50 17 2
12158 174 E 11/19 2 0.68 2.10 64.50 12 16
12159 181 A 11/19 2 0.58 2.33 70.50 8 3
29 0.77 2.18 $ 1,803.50
# of Skis Average Average Total Value
# Rejected 2 2

Figure2.26

Quality Control Data for TZBlazer Skis
Mfg ID# Size Style Date Manufactured Production Line Friction Coefficient Torsion Strength Ski Cost Rank Friction Coefficient Rank Torsion Strength
12134 174 A 11/17 1 0.82 2.21 $ 54.50 16 13
12135 174 A 11/17 1 1.94 54.50 26
12139 174 A 11/17 1 0.52 2.03 54.50 7 21
12140 167 A 11/17 1 0.63 2.24 45.50 9 8
12142 167 A 11/17 1 0.64 2.28 45.50 10 5
12144 167 A 11/17 1 1.28 45.50 26
12145 174 A 11/17 1 0.45 2.02 54.50 3 22
12146 167 A 11/17 1 1.13 2.05 45.50 25 20
12148 167 E 11/18 1 0.43 2.27 55.50 2 6
12149 174 E 11/18 1 0.47 2.31 64.50 5 4
12154 174 E 11/18 1 0.97 2.23 64.50 21 11
12156 174 E 11/18 1 0.81 2.11 64.50 15 15
12160 174 E 11/19 1 0.68 2.22 64.50 12 12
12161 174 E 11/19 1 0.67 2.08 64.50 11 17
12162 181 E 11/19 1 0.95 2.01 70.50 20 23
12136 181 R 11/17 2 1.32 82.50 27
12137 181 R 11/17 2 1.73 82.50 27
12138 181 R 11/17 2 0.92 2.08 82.50 19 17
12141 181 R 11/17 2 0.46 2.26 82.50 4 7
12143 174 R 11/17 2 1.04 2.24 76.50 24 8
12147 181 A 11/18 2 0.90 2.01 60.50 18 23
12150 167 A 11/18 2 0.97 2.00 45.50 21 25
12151 181 A 11/18 2 0.49 2.08 60.50 6 17
12152 181 A 11/18 2 0.75 2.17 60.50 14 14
12153 167 A 11/18 2 0.30 3.22 45.50 1 1
12155 181 E 11/18 2 1.01 2.24 70.50 23 8
12157 181 E 11/19 2 0.84 2.34 70.50 17 2
12158 174 E 11/19 2 0.68 2.10 64.50 12 16
12159 181 A 11/19 2 0.58 2.33 70.50 8 3
29 0.77 2.18 $ 1,803.50
# of Skis Average Average Total Value
# Rejected 2 2 $ 265.00

Figure2.27

Quality Control Data for TZBlazer Skis
Mfg ID# Size Style Date Manufactured Production Line Friction Coefficient Torsion Strength Ski Cost Rank Friction Coefficient Rank Torsion Strength
12134 174 A 11/17 1 0.82 2.21 $ 54.50 16 13
12135 174 A 11/17 1 1.94 54.50 26
12139 174 A 11/17 1 0.52 2.03 54.50 7 21
12140 167 A 11/17 1 0.63 2.24 45.50 9 8
12142 167 A 11/17 1 0.64 2.28 45.50 10 5
12144 167 A 11/17 1 1.28 45.50 26
12145 174 A 11/17 1 0.45 2.02 54.50 3 22
12146 167 A 11/17 1 1.13 2.05 45.50 25 20
12148 167 E 11/18 1 0.43 2.27 55.50 2 6
12149 174 E 11/18 1 0.47 2.31 64.50 5 4
12154 174 E 11/18 1 0.97 2.23 64.50 21 11
12156 174 E 11/18 1 0.81 2.11 64.50 15 15
12160 174 E 11/19 1 0.68 2.22 64.50 12 12
12161 174 E 11/19 1 0.67 2.08 64.50 11 17
12162 181 E 11/19 1 0.95 2.01 70.50 20 23
12136 181 R 11/17 2 1.32 82.50 27
12137 181 R 11/17 2 1.73 82.50 27
12138 181 R 11/17 2 0.92 2.08 82.50 19 17
12141 181 R 11/17 2 0.46 2.26 82.50 4 7
12143 174 R 11/17 2 1.04 2.24 76.50 24 8
12147 181 A 11/18 2 0.90 2.01 60.50 18 23
12150 167 A 11/18 2 0.97 2.00 45.50 21 25
12151 181 A 11/18 2 0.49 2.08 60.50 6 17
12152 181 A 11/18 2 0.75 2.17 60.50 14 14
12153 167 A 11/18 2 0.30 3.22 45.50 1 1
12155 181 E 11/18 2 1.01 2.24 70.50 23 8
12157 181 E 11/19 2 0.84 2.34 70.50 17 2
12158 174 E 11/19 2 0.68 2.10 64.50 12 16
12159 181 A 11/19 2 0.58 2.33 70.50 8 3
29 0.77 2.18 $ 1,803.50
# of Skis Average Average Total Value
# Rejected 2 2 $ 128.00

1

2

3

4

5

6

A

B

C

D

Mfg

ID#

Size

Style

Date

Manufactured

12134

174

A

11/17

12135

174

A

11/17

12139

174

A

11/17

12140

167

A

11/17

Quality Control Data for TZBlazer Skis

Current

Quality Control Data for TZBlazer Skis
Mfg ID# Size Style Date Manufactured Production Line Friction Coefficient Torsion Strength
12134 174 A 11/17 1 0.82 2.21
12135 174 A 11/17 1 0.49 1.94
12139 174 A 11/17 1 0.52 2.03
12140 167 A 11/17 1 0.63 2.24
12142 167 A 11/17 1 0.64 2.28
12144 167 A 11/17 1 1.28 2.31
12145 174 A 11/17 1 0.45 2.02
12146 167 A 11/17 1 1.13 2.05
12148 167 E 11/18 1 0.43 2.27
12149 174 E 11/18 1 0.47 2.31
12154 174 E 11/18 1 0.97 2.23
12156 174 E 11/18 1 0.81 2.11
12160 174 E 11/19 1 0.68 2.22
12161 174 E 11/19 1 0.67 2.08
12162 181 E 11/19 1 0.95 2.01
12136 181 R 11/17 2 1.32 2.35
12137 181 R 11/17 2 0.75 1.73
12138 181 R 11/17 2 0.92 2.08
12141 181 R 11/17 2 0.46 2.26
12143 174 R 11/17 2 1.04 2.24
12147 181 A 11/18 2 0.90 2.01
12150 167 A 11/18 2 0.97 2.00
12151 181 A 11/18 2 0.49 2.08
12152 181 A 11/18 2 0.75 2.17
12153 167 A 11/18 2 0.30 3.22
12155 181 E 11/18 2 1.01 2.24
12157 181 E 11/19 2 0.84 2.34
12158 174 E 11/19 2 0.68 2.10
12159 181 A 11/19 2 0.58 2.33
Mean 0.76 2.19
Median 0.75 2.21
Mode 0.49 2.24
Standard Deviation 0.26 0.25

Comparison

Analysis of Statistical Values – Current Data vs. Historical Data
Friction Coefficient Torsion Strength
Value: Historical Current Difference %Difference Historical Current Difference %Difference
Mean 0.76 0.76 2.27 2.19
Median 0.73 0.75 2.24 2.21
Mode 0.53 0.49 2.15 2.24
Standard Deviation 0.27 0.26 0.24 0.25

Figure2.4

Quality Control Data for TZBlazer Skis
Mfg ID# Size Style Date Manufactured Production Line Friction Coefficient Torsion Strength
12134 174 A 11/17 1 0.82 2.21
12135 174 A 11/17 1 0.49 1.94
12139 174 A 11/17 1 0.52 2.03
12140 167 A 11/17 1 0.63 2.24
12142 167 A 11/17 1 0.64 2.28
12144 167 A 11/17 1 1.28 2.31
12145 174 A 11/17 1 0.45 2.02
12146 167 A 11/17 1 1.13 2.05
12148 167 E 11/18 1 0.43 2.27
12149 174 E 11/18 1 0.47 2.31
12154 174 E 11/18 1 0.97 2.23
12156 174 E 11/18 1 0.81 2.11
12160 174 E 11/19 1 0.68 2.22
12161 174 E 11/19 1 0.67 2.08
12162 181 E 11/19 1 0.95 2.01
12136 181 R 11/17 2 1.32 2.35
12137 181 R 11/17 2 0.75 1.7345
12138 181 R 11/17 2 0.92 2.08
12141 181 R 11/17 2 0.46 2.26
12143 174 R 11/17 2 1.04 2.24
12147 181 A 11/18 2 0.90 2.01
12150 167 A 11/18 2 0.97 2.00001
12151 181 A 11/18 2 0.49 2.08
12152 181 A 11/18 2 0.75 2.17
12153 167 A 11/18 2 0.30 3.216
12155 181 E 11/18 2 1.01 2.24
12157 181 E 11/19 2 0.84 2.34
12158 174 E 11/19 2 0.68 2.1
12159 181 A 11/19 2 0.58 2.33

Figure2.5

Quality Control Data for TZBlazer Skis
Mfg ID# Size Style Date Manufactured Production Line Friction Coefficient Torsion Strength
12134 174 A 11/17 1 0.82 2.21 2.21
12135 174 A 11/17 1 0.49 1.94 1.94
12139 174 A 11/17 1 0.52 2.03 2.03
12140 167 A 11/17 1 0.63 2.24 2.24
12142 167 A 11/17 1 0.64 2.28 2.28
12144 167 A 11/17 1 1.28 2.31 2.31
12145 174 A 11/17 1 0.45 2.02 2.02
12146 167 A 11/17 1 1.13 2.05 2.05
12148 167 E 11/18 1 0.43 2.27 2.27
12149 174 E 11/18 1 0.47 2.31 2.31
12154 174 E 11/18 1 0.97 2.23 2.23
12156 174 E 11/18 1 0.81 2.11 2.11
12160 174 E 11/19 1 0.68 2.22 2.22
12161 174 E 11/19 1 0.67 2.08 2.08
12162 181 E 11/19 1 0.95 2.01 2.01
12136 181 R 11/17 2 1.32 2.35 2.35
12137 181 R 11/17 2 0.75 1.7345 1.73
12138 181 R 11/17 2 0.92 2.08 2.08
12141 181 R 11/17 2 0.46 2.26 2.26
12143 174 R 11/17 2 1.04 2.24 2.24
12147 181 A 11/18 2 0.90 2.01 2.01
12150 167 A 11/18 2 0.97 2.00001 2.00
12151 181 A 11/18 2 0.49 2.08 2.08
12152 181 A 11/18 2 0.75 2.17 2.17
12153 167 A 11/18 2 0.30 3.216 3.22
12155 181 E 11/18 2 1.01 2.24 2.24
12157 181 E 11/19 2 0.84 2.34 2.34
12158 174 E 11/19 2 0.68 2.1 2.10
12159 181 A 11/19 2 0.58 2.33 2.33

Figure2.6

Figure2.7

Quality Control Data for TZBlazer Skis
Mfg ID# Size Style Date Manufactured Production Line Friction Coefficient Torsion Strength
12134 174 A 11/17 1 0.82 2.21
12135 174 A 11/17 1 0.49 1.94
12139 174 A 11/17 1 0.52 2.03
12140 167 A 11/17 1 0.63 2.24
12142 167 A 11/17 1 0.64 2.28
12144 167 A 11/17 1 1.28 2.31
12145 174 A 11/17 1 0.45 2.02
12146 167 A 11/17 1 1.13 2.05
12148 167 E 11/18 1 0.43 2.27
12149 174 E 11/18 1 0.47 2.31
12154 174 E 11/18 1 0.97 2.23
12156 174 E 11/18 1 0.81 2.11
12160 174 E 11/19 1 0.68 2.22
12161 174 E 11/19 1 0.67 2.08
12162 181 E 11/19 1 0.95 2.01
12136 181 R 11/17 2 1.32 2.35
12137 181 R 11/17 2 0.75 1.73
12138 181 R 11/17 2 0.92 2.08
12141 181 R 11/17 2 0.46 2.26
12143 174 R 11/17 2 1.04 2.24
12147 181 A 11/18 2 0.90 2.01
12150 167 A 11/18 2 0.97 2.00
12151 181 A 11/18 2 0.49 2.08
12152 181 A 11/18 2 0.75 2.17
12153 167 A 11/18 2 0.30 3.22
12155 181 E 11/18 2 1.01 2.24
12157 181 E 11/19 2 0.84 2.34
12158 174 E 11/19 2 0.68 2.10
12159 181 A 11/19 2 0.58 2.33

Figure2.8

Figure2.9

Quality Control Data for TZBlazer Skis
Mfg ID# Size Style Date Manufactured Production Line Friction Coefficient Torsion Strength
12134 174 A 11/17 1 0.82 2.21
12135 174 A 11/17 1 0.49 1.94
12139 174 A 11/17 1 0.52 2.03
12140 167 A 11/17 1 0.63 2.24
12142 167 A 11/17 1 0.64 2.28
12144 167 A 11/17 1 1.28 2.31
12145 174 A 11/17 1 0.45 2.02
12146 167 A 11/17 1 1.13 2.05
12148 167 E 11/18 1 0.43 2.27
12149 174 E 11/18 1 0.47 2.31
12154 174 E 11/18 1 0.97 2.23
12156 174 E 11/18 1 0.81 2.11
12160 174 E 11/19 1 0.68 2.22
12161 174 E 11/19 1 0.67 2.08
12162 181 E 11/19 1 0.95 2.01
12136 181 R 11/17 2 1.32 2.35
12137 181 R 11/17 2 0.75 1.73
12138 181 R 11/17 2 0.92 2.08
12141 181 R 11/17 2 0.46 2.26
12143 174 R 11/17 2 1.04 2.24
12147 181 A 11/18 2 0.90 2.01
12150 167 A 11/18 2 0.97 2.00
12151 181 A 11/18 2 0.49 2.08
12152 181 A 11/18 2 0.75 2.17
12153 167 A 11/18 2 0.30 3.22
12155 181 E 11/18 2 1.01 2.24
12157 181 E 11/19 2 0.84 2.34
12158 174 E 11/19 2 0.68 2.10
12159 181 A 11/19 2 0.58 2.33
Mean 0.76 2.19
Median 0.75 2.21
Mode 0.49 2.24
Standard Deviation 0.26 0.25

Figure2.10

Quality Control Data for TZBlazer Skis
Mfg ID# Size Style Date Manufactured Production Line Friction Coefficient Torsion Strength
12134 174 A 11/17 1 0.82 2.21
12135 174 A 11/17 1 0.49 1.94
12139 174 A 11/17 1 0.52 2.03
12140 167 A 11/17 1 0.63 2.24
12142 167 A 11/17 1 0.64 2.28
12144 167 A 11/17 1 1.28 2.31
12145 174 A 11/17 1 0.45 2.02
12146 167 A 11/17 1 1.13 2.05
12148 167 E 11/18 1 0.43 2.27
12149 174 E 11/18 1 0.47 2.31
12154 174 E 11/18 1 0.97 2.23
12156 174 E 11/18 1 0.81 2.11
12160 174 E 11/19 1 0.68 2.22
12161 174 E 11/19 1 0.67 2.08
12162 181 E 11/19 1 0.95 2.01
12136 181 R 11/17 2 1.32 2.35
12137 181 R 11/17 2 0.75 1.73
12138 181 R 11/17 2 0.92 2.08
12141 181 R 11/17 2 0.46 2.26
12143 174 R 11/17 2 1.04 2.24
12147 181 A 11/18 2 0.90 2.01
12150 167 A 11/18 2 0.97 2.00
12151 181 A 11/18 2 0.49 2.08
12152 181 A 11/18 2 0.75 2.17
12153 167 A 11/18 2 0.30 3.22
12155 181 E 11/18 2 1.01 2.24
12157 181 E 11/19 2 0.84 2.34
12158 174 E 11/19 2 0.68 2.10
12159 181 A 11/19 2 0.58 2.33
Mean 0.76 2.19
Median 0.75 2.21
Mode 0.49 2.24
Standard Deviation 0.26 0.25

Figure2.11

Quality Control Data for TZBlazer Skis
Mfg ID# Size Style Date Manufactured Production Line Friction Coefficient Torsion Strength
12134 174 A 11/17 1 0.82 2.21
12135 174 A 11/17 1 0.49 1.94
12139 174 A 11/17 1 0.52 2.03
12140 167 A 11/17 1 0.63 2.24
12142 167 A 11/17 1 0.64 2.28
12144 167 A 11/17 1 1.28 2.31
12145 174 A 11/17 1 0.45 2.02
12146 167 A 11/17 1 1.13 2.05
12148 167 E 11/18 1 0.43 2.27
12149 174 E 11/18 1 0.47 2.31
12154 174 E 11/18 1 0.97 2.23
12156 174 E 11/18 1 0.81 2.11
12160 174 E 11/19 1 0.68 2.22
12161 174 E 11/19 1 0.67 2.08
12162 181 E 11/19 1 0.95 2.01
12136 181 R 11/17 2 1.32 2.35
12137 181 R 11/17 2 0.75 1.73
12138 181 R 11/17 2 0.92 2.08
12141 181 R 11/17 2 0.46 2.26
12143 174 R 11/17 2 1.04 2.24
12147 181 A 11/18 2 0.90 2.01
12150 167 A 11/18 2 0.97 2.00
12151 181 A 11/18 2 0.49 2.08
12152 181 A 11/18 2 0.75 2.17
12153 167 A 11/18 2 0.30 3.22
12155 181 E 11/18 2 1.01 2.24
12157 181 E 11/19 2 0.84 2.34
12158 174 E 11/19 2 0.68 2.10
12159 181 A 11/19 2 0.58 2.33
Mean 0.76 2.19
Median 0.75 2.21
Mode 0.49 2.24
Standard Deviation 0.26 0.25

Figure2.12a

Analysis of Statistical Values – Current Data vs. Historical Data
Friction Coefficient Torsion Strength
Value: Historical Current Difference %Difference Historical Current Difference %Difference
Mean 0.76 0.76 2.27 2.19
Median 0.73 0.75 2.24 2.21
Mode 0.53 0.49 2.15 2.24
Standard Deviation 0.27 0.26 0.24 0.25

Figure2.12b

Analysis of Statistical Values – Current Data vs. Historical Data
Friction Coefficient Torsion Strength
Value: Historical Current Difference %Difference Historical Current Difference %Difference
Mean 0.76 0.76 2.27 2.19
Median 0.73 0.75 2.24 2.21
Mode 0.53 0.49 2.15 2.24
Standard Deviation 0.27 0.26 0.24 0.25

Figure2.13

Analysis of Statistical Values – Current Data vs. Historical Data
Friction Coefficient Torsion Strength
Value: Historical Current Difference %Difference Historical Current Difference %Difference
Mean 0.76 0.76 -0.003 2.27 2.19
Median 0.73 0.75 0.020 2.24 2.21
Mode 0.53 0.49 -0.040 2.15 2.24
Standard Deviation 0.27 0.26 -0.008 0.24 0.25

Figure2.14

Analysis of Statistical Values – Current Data vs. Historical Data
Friction Coefficient Torsion Strength
Value: Historical Current Difference %Difference Historical Current Difference %Difference
Mean 0.76 0.76 -0.003 -0.41% 2.27 2.19 -0.082 -3.60%
Median 0.73 0.75 0.020 2.74% 2.24 2.21 -0.030 -1.34%
Mode 0.53 0.49 -0.040 -7.55% 2.15 2.24 0.090 4.19%
Standard Deviation 0.27 0.26 -0.008 -2.95% 0.24 0.25 0.005 2.29%

1

2

3

4

5

6

A

B

C

D

Mfg ID#

Size

Style

Date

Manufactured

12134

174

A

11/17

12135

174

A

11/17

12139

174

A

11/17

12140

167

A

11/17

Quality Control Data for TZBlazer Skis

1

WEEK # 3 – EXERCISES CHAPTER # 2

Exercise Ch2-1: Level 1 – Analyzing Sales for Crèmes Ice Cream
Judd Hemming is the eastern regional marketing manager for Crèmes Ice Cream. Each quarter,
he completes two separate analyses: an analysis comparing ice cream flavor sales volumes from
all regional locations with the same quarter sales volumes from the previous year, and an analysis
comparing total sales in dollars, including mean, median, mode, and standard deviation, of sales
by store.

Sales by Flavor in Gallons
The first analysis, sales by flavor, compares the total quantities sold in gallons. The data collected
provides for each flavor the number of pints, gallons, and 10-gallon tubs sold for all stores. Pints
and gallons are sold directly to the public, whereas 10-gallon tubs are used for in-store sales of
cones, cups, and specialty items such as sundaes and banana splits. To eliminate any impact of
pricing changes or special promotions, Judd uses the ice cream volumes in gallons to compare
sales by flavor. Judd has asked for your help this quarter in completing this analysis. He created
two workbook files:

– StartFileCreme.xlsx, which contains the current quarter’s sales on a worksheet named
Flavors

– StartFileHCreme.xlsx, which contains the corresponding historical quarterly data for the
previous year on a worksheet named HFlavors.

For convenience, the flavors in both data sets are in identical order except for two new flavors
introduced this year, which appear at the bottom of the current data set.

Keep in mind the following conversions when analyzing this data:

• There are 8 pints per gallon.
• Each tub holds 10 gallons.

Also, when calculating values for 10-gallon tubs, Judd has asked you to use the convention of
rounding down the values to the nearest whole tub.

Sales by Store in Dollars
The second analysis you need to complete is to summarize sales in dollars by store and compare
the result with the previous year’s sales. The Stores worksheet in the same workbook contains
sales by store for the current quarter in dollars rounded to the nearest thousand dollars. You need
to calculate some basic statistics for store sales. In the same quarter of the previous year, these
values were:

• Mean: $8,817
• Median: $8,000
• Mode: $5,500
• Standard Deviation: $2,920

When writing formulas, be certain to use the most efficient method, including the use of functions
as well as relative and absolute cell referencing.
Complete the following:
1. Open the workbook named StartFileCreme.xlsx attached with the data of the assignment, and
then save it as 2-1-Crème-Current-Sales-Analysis-Your-Name.xlsx.

2. On the Flavors worksheet, for the current quarter, calculate the total number of gallons sold
for each favor. Place this calculation in the column adjacent to the data provided (Column E). Above
the list of flavors, in a separate area, list and clearly label the conversion values. Remember to
round down the tub quantities to the nearest whole tub when completing the calculation.

2

WEEK # 3 – EXERCISES CHAPTER # 2

Total number of gallons sold =
#Pints Containers Sold Current Qtr / Pints per Gallon +
#Gallons Containers Sold Current Qtr +
#Tubs Used Current Qtr * Gallons per Tub
Use Absolute reference in the cells yellow highlight

3. Add another column in which to enter the total number of gallons from last year. Copy the
values for the total amount of ice cream sold for the corresponding flavor for last year from the
StartFileHCreme.xlsx workbook in the Chapter 2 folder into the newly added column of the Flavors
worksheet.

4. Calculate the overall total and mean number of gallons sold for all flavors for this quarter and
for this quarter last year. (Note: Include all flavors in your calculation, whether or not there are sales
for them in a given year.). Use the SUM and AVERAGE Function

5. Calculate for each flavor the percent of total gallons Current this flavor represents compared
with total sales for the current quarter of all flavors. Copy this formula to the adjacent column to
calculate the percent of total gallons this flavor represents compared with historical total sales.

6. In the two adjacent columns, calculate for each flavor and for the totals the difference and percent
difference in sales. Assume a positive value represents an increase in sales. Flavors without sales
in the previous year should be left blank. (These cells should be completely empty.)

TROUBLESHOOTING: In order to complete this step successfully, pay attention to the order of
precedence rules when writing the formula. Percent difference is defined as the difference between
the new values minus the old value divided by the old value, so specifying the order in which the
operations must occur is critical.

7. Switch to the Stores worksheet. Calculate the total sales, mean, median, mode, and standard
deviation for this data set. Label the cells so that they can be easily identified.

8. On the same worksheet, set up a table to analyze the change and percent change of each of
these statistical values as compared with the historical values.
Based on the changes, explain on the worksheet (just below your analysis) whether the stores are
doing better this year, and if sales in stores are more or less likely to vary from mean sales than
they did last year.

9. Based on sales to all stores and total gallons sold for the current quarter, what is the price of a
gallon of ice cream on average? Write a formula to determine this value and place it below the
statistical analysis on the Stores worksheet.

10. Add appropriate worksheet titles and formatting to make the worksheets easy to read.

11. Add your name and date at the end of the exercise

12. Save and close the 2-1-Crème-Current-Sales-Analysis-Your-Name.xlsx workbook.

3

WEEK # 3 – EXERCISES CHAPTER # 2

The solution should be similar to:
In the Flavor worksheet:

In the Store worksheet:

4

WEEK # 3 – EXERCISES CHAPTER # 2

Exercise Ch2-2: Level 2- Analyzing Demographic Data for Your
Restaurant.
You have recently decided to open a restaurant that you plan to name “Select your Restaurant
Name”. In your restaurant, you plan to feature specialty desserts, along with fine cuisine. One
critical decision you must make is where to locate the restaurant. Right now, you are considering
two different locations—one near a large retail area on the fringe of several affluent suburbs (site
A), and the other in the downtown district (site B). Before making the decision, you hired a local
market research firm to provide you with some demographics of the areas and the specific dining
habits of the local population that frequent other restaurants in these areas. You have entered the
raw results of this research on several worksheets in the StartFileYourRestaurante.xlsx
workbook.

Each worksheet (SiteA and SiteB) contains the detailed responses of each of the participants of
the study, including questions about their age, their income, and the number of meals and
desserts they eat outside of their homes per month.

Table 2.15 shows the breakdown of the age categories and corresponding income level closest
to the respondent’s own income.

Complete the following:
1. Open the workbook named StartFileYourRestaurante.xlsx attached with the data of the
assignment, and then save it as 2-2-YourRestaurante-Demog-Analysis-Your-Name.xlxs.

2. On the SiteA and SiteB worksheets, rank each respondent by the number of meals they eat
out per month and the number of desserts they eat out per month, respectively— ranking from
most meals and desserts out to the least. Freeze the panes of the window on each worksheet to
make the category headings at the top visible at all times.

3. On a separate worksheet named Compare, calculate the difference and percent difference of
the mean and standard deviation for the data sets (A and B) for the number of meals and number
of desserts per month obtained. On the same worksheet, set up a table to list the four highest
number of desserts per month from each data set (A and B) and the ten lowest number of meals
eaten out by respondents for each of the data sets (A and B). Below the data, discuss how these
values differ between the data sets, and recommend either A or B for further analysis, highlighted
in pink.

5

WEEK # 3 – EXERCISES CHAPTER # 2

4. On a separate worksheet named Summary, determine the following for the location you think
should be selected:
• The total number of respondents

• The total number of respondents with incomes at or above $90,000
• The total number of respondents who eat fewer than three desserts out each month
• The total number of meals eaten out per month reported by respondents who earn at
least $50,000
• The total number of desserts per month reported by respondents who are in the
31 to 35 or over 35 age categories

5. Include appropriate titles, labels, and formatting so that the worksheets are easy to read.

6. Add your name and date at the end of the exercise

7. Save and close the 2-2-YourRestaurante-Demog-Analysis-Your-Name.xlxs workbook.

6

WEEK # 3 – EXERCISES CHAPTER # 2

NOTE:
For Step 2
For SiteA Calculate the RANK for Column F & G

For SiteB Calculate the RANK for Column F & G

7

WEEK # 3 – EXERCISES CHAPTER # 2

For Step 3
Add a new Tab to Compare:

For Step 4
Add a new Tab to Summary:

error: Content is protected !!