IN Production Errors Established in 2000, t-shirts.com has rapidly become the place to find order, and save on T-shirts One huge selling factor is that the company manufactures its own T-shirts. However, the quality manager for the production plant, Kasey Harnish, has noticed an unacceptable number of defec- Live T-Shirts being produced. You have been hired to assist Kasey in understanding where the problems are concentrated. He suggests using Excel's PivotTable Feature to perform an analysis and has provided you with a data file, T3 Tshirt Production Data File.xlsx. The following is a brlet definition of the information within the data file: Batch: A unique number that Identifies each batch or group of products produced. Product: A unique number that identifies each product. Machine: A unique number that identifies each machine on which products are produced. Employee: A unique number that identifies each employee producing products. Batch Size: The number of products produced in a given batch. Num Defect: The number of defective products produced in a given batch, 2. Coffee Tronds College chums Hannah Baltzan and Tyler Phillips are working on opening a third espresso drive through stand in Highlands Ranch, Colorado, called Brewed Awakening. Thelr original drive through stand, Jitters, and their second espresso stand, Bean Scene, have done well in their current locations in Englewood, Colorado, five miles away. Since Hannah and Tyler want to start with low overhead, they need assistance analyzing the data from the past year on the different types of coffee and amounts that they sold from both stands. Hannah and Tyler would like a rec ommendation of the four top sellers to start offering when Brewed Awakening opens. They have provided you with the data file T3 Jitters Coffee Data File.xlsx for you to perform the analysis that will support your recommendation. > Question 1 Production Data Which employee number had the greatest number of defects 2 How many defects did the employee produce ? Which product had the greatest number of defects ? What was the number of defects for the product Question 2 Coffee Data . Which product had the greatest revenue ? What was the amount of revenue Which Store had the greatest monthly revenue - What was the store 2 What was the month and What was the revenue for the month? 0 . 1 Format Painter = = TE 21 Clipboard Font Aligr E2 X fi 500 G H H 500 OWN- 6 66 500 NN F 1 BATCH SIZE NUM DEFECTIVE 16 10000 16 4 5000 16 1000 16 1000 16 7 5000 16 10000 16 9 10000 16 10 5000 16 11 16 12 500 16 13 1000 16 14 5000 16 15 10000 16 16 10000 16 17 5000 16 18 500 16 19 500 16 20 500 16 21 1000 16 22 10000 16 23 10000 16 24 10000 16 25 5000 16 26 1000 16 27 1000 16 28 5000 16 29 10000 16 30 500 16 31 500 16 32 10000 16 33 500 16 34 5000 16 35 1000 16 36 1000 16 37 5000 16 38 500 16 39 10000 16 40 5000 16 41 1000 16 42 1000 16 43 5000 16 44 10000 16 45 500 16 Sheet1 3.2 0.16 0.32 1.6 1.6 0.32 0.16 0.16 0.32 3.2 3.2 1.6 0.32 0.16 0.16 0.32 3.2 3.2 32 1.6 0.16 0.16 0.16 0.32 1.6 15 0.32 0.16 32 32 0.16 32 0.32 16 16 0.32 32 0.16 0.32 16 16 0.32 0.15 32 19 Font Alignment E2 > fx 500 E F G J K NO bbbbbbbb 5000 1000 1000 5000 10000 500 500 10000 500 5000 1000 1000 5000 500 10000 500 5000 1000 1000 5000 500 10000 5000 1000 1000 5000 10000 500 500 10000 500 10000 5000 1000 500 500 10000 5000 H 0.32 16 1.6 0.32 0.16 3.2 3.2 0.16 3.2 0.32 1.6 1.6 0.32 3.2 0.16 3.2 0.32 1.6 16 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 0.32 3 3.2 0.16 0.32 1.6 1.6 0.32 0.16 32 32 0.16 3.2 0.16 0.32 1.6 32 32 0.16 0.32 Sheet1 - 11 ili In Format Painter Clipboard 12 Font 21 AI F16 * Fax A E F G > 85 Vanilla 86 Vanilla 87 Vanilla 88 Vanilla 89 Vanilla 90 Vanilla 91 Vanilla 92 Vanilla 93 Vanilla 94 Vanilla 95 Vanilla 96 Vanilla 97 Vanilla 98 Vanilla 99 Vanilla 100 Vanilla 101 Vanilla 102 Insh Cream 103 Insh Cream 104 Insh Cream 105 Irish Cream 106 Insh Cream 107 trish Cream 108 Irish Crean 109 Irish Cream 110 Irish Cream 11 Inish Cream 112 Insh Cream 113 Irish Cream 114 Insh Cream 115 Insh Cream 116 Irish Cream 117 Irish Cream 118 Inch Cream 119 Wish Cream 120 Insh Cream 121 Irish Cream 122 Irish Cream 123 Insh Cream 124 Irish Cream 125 insh Cream 125 Hazelnut 127 Hazelnut 120 Hazelnut 129 Hari B August North September North October North November North December North January South February South March South April South May South June South July South August South September South October South November South December South January North February North March North April North May North June North July North August North September North October North November North December North January South February South March South April South May South Gune South July South August South September South October South November South December South January North February Sort March North North Sheet1 D 3610 2210 2430 2430 2460 2540 2310 2520 2450 2430 2480 2540 2610 2340 2380 2540 2310 2400 2320 2290 5290 4350 4350 4350 4350 3610 3540 3610 2219 2430 2430 2460 2500 2310 2620 2450 2430 2:50 25.00 2610 4350 3510 3640 3610 2210 Clipboard 17 Font 22 F16 fo E UL F G 118 Irish Cream 119 Irish Cream 120 Irish Cream 121 Irish Cream 122 Irish Cream 123 Irish Cream 124 Irish Cream 125 Irish Cream 126 Hazelnut 127 Hazelnut 128 Hazelnut 129 Hazelnut 130 Hazelnut 131 Hazelnut 132 Hazelnut 133 Hazelnut 134 Hazelnut 135 Hazelnut 136 Hazelnut 137 Hazelnut 138 Hazelnut 139 Hazelnut 140 Hazelnut 141 Hazelnut 142 Hazelnut 143 Hazelnut 144 Hazelnut 145 Hazelnut 146 Hazelnut 147 Hazelnut 148 Hazelnut 149 Hazelnut 150 151 152 153 B May South June South July South August South September South October South November South December South January North February North March North April North May North June North July North August North September North October North November North December North January South February South March South April South May South June South July South August South September South October South November South December South D 2310 2620 2450 2430 2480 2540 2610 4350 3610 3640 3610 2210 2430 2430 2460 2540 2310 2620 2450 2430 2480 2540 2610 2340 2380 2540 2310 2400 2320 2290 5290 4320 + C G MACHINE 5 7 6 8 6 7 8 CD OF 6 7 5 7 8 6 7 5 BATCH 1 3 2 3 4 6 5 6 8 7 19 10 9 11 10 12 11 13 12 14 13 15 14 16 15 17 16 18 17 19 18 20 19 21 20 22 21 23 24 25 26 27 28 29 28 30 31 30 32 31 33 32 34 33 35 34 36 35 37 36 38 37 39 38 40 39 41 40 42 41 43 42 44 43 45 44 7 6 B PRODUCT 10 20 30 30 20 20 30 10 10 30 20 30 10 30 30 10 10 10 10 20 10 20 30 30 20 20 20 30 30 30 10 10 20 30 30 20 10 30 10 10 20 20 30 20 Sheet1 haco 09 Ch 00 00 00 O OOOOooh oooh % D EMPLOYEE 3333 5555 2222 4444 3333 1111 2222 3333 1111 5555 3333 4444 2222 3333 1111 1111 1111 4444 3333 2222 5555 3333 4444 2222 5555 1111 2222 3333 4444 5555 4444 5555 3333 2222 4444 1111 3333 2222 4444 2222 2222 2222 2222 3333 E BATCH SIZE 500 10000 5000 1000 1000 5000 10000 10000 5000 500 500 1000 5000 10000 10000 5000 500 500 500 1000 10000 10000 10000 5000 1000 1000 5000 10000 500 500 10000 500 5000 1000 1000 5000 500 10000 5000 1000 1000 5000 10000 500 F NUM DEFECTIVE 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 8 7 8 7 5 7 8 7 8 ON 5 + LL- G Lord bbb D ED - ppo 40 39 41 40 42 41 43 42 44 43 45 44 46 45 47 46 48 47 49 48 50 49 51 50 52 51 53 52 54 53 55 54 56 55 57 56 58 57 59 58 60 59 61 60 62 61 63 62 64 63 65 64 66 65 67 66 68 67 69 68 70 69 71 70 72 71 73 72 74 73 75 74 76 75 77 76 78 79 10 10 20 20 30 20 30 20 20 30 30 10 10 10 10 20 10 20 30 30 20 20 20 30 30 30 10 10 20 30 20 10 30 30 30 20 10 10 6 5 6 8 6 7 8 7 5 8 6 7 5 6 7 7 6 5 D 4444 2222 2222 2222 2222 3333 1111 4444 2222 5555 4444 5555 1111 2222 3333 4444 5555 2222 1111 3333 2222 4444 3333 5555 4444 1111 2222 1111 2222 3333 4444 2222 5555 4444 5555 3333 1111 5555 E 5000 1000 1000 5000 10000 500 500 10000 500 5000 1000 1000 5000 500 10000 500 500++ 1000 1000 F 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 5000 6 7 8 8 6 7 5 6 500 10000 5000 1000 1000 5000 10000 500 500 10000 500 10000 5000 1000 500 500 10000 5000 - Dr. 6 7 8 6 dumn = Cat w = = arc T5 16 7 7 IN Production Errors Established in 2000, t-shirts.com has rapidly become the place to find order, and save on T-shirts One huge selling factor is that the company manufactures its own T-shirts. However, the quality manager for the production plant, Kasey Harnish, has noticed an unacceptable number of defec- Live T-Shirts being produced. You have been hired to assist Kasey in understanding where the problems are concentrated. He suggests using Excel's PivotTable Feature to perform an analysis and has provided you with a data file, T3 Tshirt Production Data File.xlsx. The following is a brlet definition of the information within the data file: Batch: A unique number that Identifies each batch or group of products produced. Product: A unique number that identifies each product. Machine: A unique number that identifies each machine on which products are produced. Employee: A unique number that identifies each employee producing products. Batch Size: The number of products produced in a given batch. Num Defect: The number of defective products produced in a given batch, 2. Coffee Tronds College chums Hannah Baltzan and Tyler Phillips are working on opening a third espresso drive through stand in Highlands Ranch, Colorado, called Brewed Awakening. Thelr original drive through stand, Jitters, and their second espresso stand, Bean Scene, have done well in their current locations in Englewood, Colorado, five miles away. Since Hannah and Tyler want to start with low overhead, they need assistance analyzing the data from the past year on the different types of coffee and amounts that they sold from both stands. Hannah and Tyler would like a rec ommendation of the four top sellers to start offering when Brewed Awakening opens. They have provided you with the data file T3 Jitters Coffee Data File.xlsx for you to perform the analysis that will support your recommendation. > Question 1 Production Data Which employee number had the greatest number of defects 2 How many defects did the employee produce ? Which product had the greatest number of defects ? What was the number of defects for the product Question 2 Coffee Data . Which product had the greatest revenue ? What was the amount of revenue Which Store had the greatest monthly revenue - What was the store 2 What was the month and What was the revenue for the month? 0 . 1 Format Painter = = TE 21 Clipboard Font Aligr E2 X fi 500 G H H 500 OWN- 6 66 500 NN F 1 BATCH SIZE NUM DEFECTIVE 16 10000 16 4 5000 16 1000 16 1000 16 7 5000 16 10000 16 9 10000 16 10 5000 16 11 16 12 500 16 13 1000 16 14 5000 16 15 10000 16 16 10000 16 17 5000 16 18 500 16 19 500 16 20 500 16 21 1000 16 22 10000 16 23 10000 16 24 10000 16 25 5000 16 26 1000 16 27 1000 16 28 5000 16 29 10000 16 30 500 16 31 500 16 32 10000 16 33 500 16 34 5000 16 35 1000 16 36 1000 16 37 5000 16 38 500 16 39 10000 16 40 5000 16 41 1000 16 42 1000 16 43 5000 16 44 10000 16 45 500 16 Sheet1 3.2 0.16 0.32 1.6 1.6 0.32 0.16 0.16 0.32 3.2 3.2 1.6 0.32 0.16 0.16 0.32 3.2 3.2 32 1.6 0.16 0.16 0.16 0.32 1.6 15 0.32 0.16 32 32 0.16 32 0.32 16 16 0.32 32 0.16 0.32 16 16 0.32 0.15 32 19 Font Alignment E2 > fx 500 E F G J K NO bbbbbbbb 5000 1000 1000 5000 10000 500 500 10000 500 5000 1000 1000 5000 500 10000 500 5000 1000 1000 5000 500 10000 5000 1000 1000 5000 10000 500 500 10000 500 10000 5000 1000 500 500 10000 5000 H 0.32 16 1.6 0.32 0.16 3.2 3.2 0.16 3.2 0.32 1.6 1.6 0.32 3.2 0.16 3.2 0.32 1.6 16 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 0.32 3 3.2 0.16 0.32 1.6 1.6 0.32 0.16 32 32 0.16 3.2 0.16 0.32 1.6 32 32 0.16 0.32 Sheet1 - 11 ili In Format Painter Clipboard 12 Font 21 AI F16 * Fax A E F G > 85 Vanilla 86 Vanilla 87 Vanilla 88 Vanilla 89 Vanilla 90 Vanilla 91 Vanilla 92 Vanilla 93 Vanilla 94 Vanilla 95 Vanilla 96 Vanilla 97 Vanilla 98 Vanilla 99 Vanilla 100 Vanilla 101 Vanilla 102 Insh Cream 103 Insh Cream 104 Insh Cream 105 Irish Cream 106 Insh Cream 107 trish Cream 108 Irish Crean 109 Irish Cream 110 Irish Cream 11 Inish Cream 112 Insh Cream 113 Irish Cream 114 Insh Cream 115 Insh Cream 116 Irish Cream 117 Irish Cream 118 Inch Cream 119 Wish Cream 120 Insh Cream 121 Irish Cream 122 Irish Cream 123 Insh Cream 124 Irish Cream 125 insh Cream 125 Hazelnut 127 Hazelnut 120 Hazelnut 129 Hari B August North September North October North November North December North January South February South March South April South May South June South July South August South September South October South November South December South January North February North March North April North May North June North July North August North September North October North November North December North January South February South March South April South May South Gune South July South August South September South October South November South December South January North February Sort March North North Sheet1 D 3610 2210 2430 2430 2460 2540 2310 2520 2450 2430 2480 2540 2610 2340 2380 2540 2310 2400 2320 2290 5290 4350 4350 4350 4350 3610 3540 3610 2219 2430 2430 2460 2500 2310 2620 2450 2430 2:50 25.00 2610 4350 3510 3640 3610 2210 Clipboard 17 Font 22 F16 fo E UL F G 118 Irish Cream 119 Irish Cream 120 Irish Cream 121 Irish Cream 122 Irish Cream 123 Irish Cream 124 Irish Cream 125 Irish Cream 126 Hazelnut 127 Hazelnut 128 Hazelnut 129 Hazelnut 130 Hazelnut 131 Hazelnut 132 Hazelnut 133 Hazelnut 134 Hazelnut 135 Hazelnut 136 Hazelnut 137 Hazelnut 138 Hazelnut 139 Hazelnut 140 Hazelnut 141 Hazelnut 142 Hazelnut 143 Hazelnut 144 Hazelnut 145 Hazelnut 146 Hazelnut 147 Hazelnut 148 Hazelnut 149 Hazelnut 150 151 152 153 B May South June South July South August South September South October South November South December South January North February North March North April North May North June North July North August North September North October North November North December North January South February South March South April South May South June South July South August South September South October South November South December South D 2310 2620 2450 2430 2480 2540 2610 4350 3610 3640 3610 2210 2430 2430 2460 2540 2310 2620 2450 2430 2480 2540 2610 2340 2380 2540 2310 2400 2320 2290 5290 4320 + C G MACHINE 5 7 6 8 6 7 8 CD OF 6 7 5 7 8 6 7 5 BATCH 1 3 2 3 4 6 5 6 8 7 19 10 9 11 10 12 11 13 12 14 13 15 14 16 15 17 16 18 17 19 18 20 19 21 20 22 21 23 24 25 26 27 28 29 28 30 31 30 32 31 33 32 34 33 35 34 36 35 37 36 38 37 39 38 40 39 41 40 42 41 43 42 44 43 45 44 7 6 B PRODUCT 10 20 30 30 20 20 30 10 10 30 20 30 10 30 30 10 10 10 10 20 10 20 30 30 20 20 20 30 30 30 10 10 20 30 30 20 10 30 10 10 20 20 30 20 Sheet1 haco 09 Ch 00 00 00 O OOOOooh oooh % D EMPLOYEE 3333 5555 2222 4444 3333 1111 2222 3333 1111 5555 3333 4444 2222 3333 1111 1111 1111 4444 3333 2222 5555 3333 4444 2222 5555 1111 2222 3333 4444 5555 4444 5555 3333 2222 4444 1111 3333 2222 4444 2222 2222 2222 2222 3333 E BATCH SIZE 500 10000 5000 1000 1000 5000 10000 10000 5000 500 500 1000 5000 10000 10000 5000 500 500 500 1000 10000 10000 10000 5000 1000 1000 5000 10000 500 500 10000 500 5000 1000 1000 5000 500 10000 5000 1000 1000 5000 10000 500 F NUM DEFECTIVE 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 8 7 8 7 5 7 8 7 8 ON 5 + LL- G Lord bbb D ED - ppo 40 39 41 40 42 41 43 42 44 43 45 44 46 45 47 46 48 47 49 48 50 49 51 50 52 51 53 52 54 53 55 54 56 55 57 56 58 57 59 58 60 59 61 60 62 61 63 62 64 63 65 64 66 65 67 66 68 67 69 68 70 69 71 70 72 71 73 72 74 73 75 74 76 75 77 76 78 79 10 10 20 20 30 20 30 20 20 30 30 10 10 10 10 20 10 20 30 30 20 20 20 30 30 30 10 10 20 30 20 10 30 30 30 20 10 10 6 5 6 8 6 7 8 7 5 8 6 7 5 6 7 7 6 5 D 4444 2222 2222 2222 2222 3333 1111 4444 2222 5555 4444 5555 1111 2222 3333 4444 5555 2222 1111 3333 2222 4444 3333 5555 4444 1111 2222 1111 2222 3333 4444 2222 5555 4444 5555 3333 1111 5555 E 5000 1000 1000 5000 10000 500 500 10000 500 5000 1000 1000 5000 500 10000 500 500++ 1000 1000 F 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 5000 6 7 8 8 6 7 5 6 500 10000 5000 1000 1000 5000 10000 500 500 10000 500 10000 5000 1000 500 500 10000 5000 - Dr. 6 7 8 6 dumn = Cat w = = arc T5 16 7 7