2. Coffee Trends College chums Hannah Baltzan and Tyler Phillips are working on opening a third espresso drive through stand in Highlands Ranch, Colorado, called Brewed Awakening. Their 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_JittersCoffee_Data.xlsx for you to perform the analysis that will support your recommendation, Styles D7 X for 4500 E E Data Data A B D 1 Key 2 Jitters = North 3 Bean Scene = South 4 5 Product Month Store Revenue 6 Regular January North 4320 7 Regular February North 4500 8 Regular March North 3528 9 Regular April North 3960 10 Regular May North 3996 11 Regular June North 3960 12 Regular July North 3960 13 Regular August North 4230 14 Regular September North 4230 15 Regular October North 4275 16 Regular November North 4365 17 Regular December North 4455 18 Regular January South 3960 19 Regular February South 4230 20 Regular March South 4230 21 Regular April South 4275 22 Regular May South 4365 23 Regular June South 4455 24 Regular July South 4128 25 Regular August South 4176 26 Regular September South 3936 Sheet1 15 Managi Cell Styles Styles DZ X for 4500 a Files E a Pata g_Data a On_Data 26 Regular 27 Regular 28 Regular 29 Regular 30 Decaf 31 Decaf 32 Decaf 33 Decaf 34 Decaf 35 Decaf 36 Decaf 37 Decaf 38 Decaf 39 Decaf 40 Decaf 41 Decaf 42 Decaf 43 Decaf 44 Decaf 45 Decaf 46 Decaf 47 Decaf 48 Decaf 49 Deca 50 Decaf 61 Decaf B 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 3936 4090 3936 4350 4350 4350 4350 3610 3640 3610 2210 2430 2430 2460 2540 2310 2620 2450 2430 2480 2540 2610 2340 2380 2540 2310 Sheet1 o nagi Cell Styles Styles D7 for 4500 E ta ta 51 Decal October South 52 Decaf November South 53 Decaf December South 54 French Roast January North 55 French Roast February North 56 French Roast March North 57 French Roast April North 58 French Roast May North 59 French Roast June North 60 French Roast July North 61 French Roast August North 62 French Roast September North 63 French Roast October North 64 French Roast November North 65 French Roast December North 66 French Roast January South 67 French Roast February South 68 French Roast March South 69 French Roast April South 70 French Roast May South 71 French Roast June South 72 French Roast July South 73 French Roast August South 74 French Roast September South 75 French Roast October South 76 French Roast November South Sheet1 2310 2400 2320 2290 5290 4320 4500 3528 3960 3996 3960 3960 4230 4230 4275 4365 4455 3960 4230 4230 4275 4365 4455 4128 4176 3936 File Home essed Folder Review Vi ents Clipboard Insert Page Layout Formulas Data % Conditional Formatting Formatas Table Alignment Number Dell Styles Styles Font ons Manage Cells Ed DZ fr 4500 ata Files E G ata Data ing Data ata tion_Data July A B 75 French Roast October South 76 French Roast November South 77 French Roast December South 78 Vanilla January North 79 Vanilla February North 80 Vanilla March North 81 Vanilla April North 82 Vanilla May North 83 Vanilla June North 84 Vanilla North 85 Vanilla August North 86 Vanilla September North 87 Vanilla October North 88 Vanilla November North 89 Vanilla December North 90 Vanilla January South 91 Vanilla February South 92 Vanilla March South 93 Vanilla April South 94 Vanilla May South 95 Vanilla June South 96 Vanilla July South 97 Vanilla August South 98 Vanilla September South 99 Vanilla October South 100 Vanilla November South Sheet1 4176 3936 4090 3936 4350 4350 4350 4350 3610 3640 3610 2210 2430 2430 2460 2540 2310 2620 2450 2430 2480 2540 2610 2340 2380 2540 o Et 19 D7 4500 E Pata Data A 99 Vanilla 100 Vanilla 101 Vanilla 102 Irish Cream 103 Irish Cream 104 Irish Cream 105 Irish Cream 106 Irish Cream 107 Irish Cream 108 Irish Cream 109 Irish Cream 110 Irish Cream 111 Irish Cream 112 Irish Cream 113 Irish Cream 114 Irish Cream 115 Irish Cream 116 Irish Cream 117 Irish Cream 118 Irish Cream 119 Irish Cream 120 Irish Cream 121 Irish Cream 122 Irish Cream 123 Irish Cream 124 Irish Cream B 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 D 2380 2540 2310 2400 2320 2290 5290 4350 4350 4350 4350 3610 3640 3610 2210 2430 2430 2460 2540 2310 2620 2450 2430 2480 2540 2610 Sheet1 Manag 12 Cell Styles Styles D7 X for 4500 Files E F ta Data _Data 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 B C 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 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 Sheet1