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 44/69 2 ID First Name Last Name Department Title 3 2956 Michael Goldstein Engineering Engineer 4 4123 Steve Ballmer Engineering Engineer 5 3117 Frederich Bednarczyk Engineering Engineer 6 2122 Yuan Chang Engineering Engineer 7 2451 Francine Detweiler Engineering Engineer B 2896 Samuel Gates Engineering Engineer 2768 Phyllis Leonard Engineering Engineer 0 1119 Sharad Manispour Engineering Manager 1 2344 Nemesha Mehta Engineering Engineer 2 3210 Carmen Ortega-Molina Engineering Engineer 3 2002 Edgar Rothrock Engineering Engineer 4 3015 Patti Stonesifer Engineering Engineer $ 2678 Koshi Yamamoto Engineering Engineer 5 2733 John Zumkowski Engineering Staff 7 3314 Svetlana Kartashev Human Resources Staff 4006 Alice Rovik Human Resources Manager 2042 Hillary Cushner Management Staff 1851 Melinda English Management Manager 1355 Barbara Grabowski Management Manager 1173 Roberta Kurzweil Management Manager 1441 James Van Horn Management Manager 1042 Maria Andretti Marketing CSR 1032 Hillary Flintsteel Marketing Staff 1009 Kevin Grundies Marketing CSR Employee Dat Salary Hire Date Birth Date Gender Clearance 51,000 4/11/97 3/7/63 M TS 42,900 5/1/02 4/14770 M 56,700 5/14/99 5/27/70 M 46,540 9/5/95 3/4/64 M 56,700 10/10/95 4/29/70 F S 66,300 1/28/97 4/10174 M S 59,800 12/13/96 712170 F 54,500 10/13/90 M S 65,000 10/1/95 2/12/65 F S 46,000 9/16/99 3/28/52 F S 53,300 2/8/94 3/21/70 M S 64,300 7/6/98 3/10/66 F S 49,600 11/16/95 1/24/63 F S 33,000 4/18/96 12/12/72 M TS 38,000 11/5/01 5/3/82 N 43,000 12/1/01 1/26/55 M S 32,000 8/26/94 5/6/61 F 62,040 10/1/93 2/14/56 F 75,700 10/13/92 4/10/65 63.000 6/16/92 12/22/58 F S 66,500 12/18/92 2/3/58 M S 42,500 3/21/90 8/20/70 F 34,500 3/21/90 8/22/58 38.900 12/24/89 3/4/61 M za 2 2 2 2 2 2 2 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 44/69 2 ID First Name Last Name Department Title 3 2956 Michael Goldstein Engineering Engineer 4 4123 Steve Ballmer Engineering Engineer 5 3117 Frederich Bednarczyk Engineering Engineer 6 2122 Yuan Chang Engineering Engineer 7 2451 Francine Detweiler Engineering Engineer B 2896 Samuel Gates Engineering Engineer 2768 Phyllis Leonard Engineering Engineer 0 1119 Sharad Manispour Engineering Manager 1 2344 Nemesha Mehta Engineering Engineer 2 3210 Carmen Ortega-Molina Engineering Engineer 3 2002 Edgar Rothrock Engineering Engineer 4 3015 Patti Stonesifer Engineering Engineer $ 2678 Koshi Yamamoto Engineering Engineer 5 2733 John Zumkowski Engineering Staff 7 3314 Svetlana Kartashev Human Resources Staff 4006 Alice Rovik Human Resources Manager 2042 Hillary Cushner Management Staff 1851 Melinda English Management Manager 1355 Barbara Grabowski Management Manager 1173 Roberta Kurzweil Management Manager 1441 James Van Horn Management Manager 1042 Maria Andretti Marketing CSR 1032 Hillary Flintsteel Marketing Staff 1009 Kevin Grundies Marketing CSR Employee Dat Salary Hire Date Birth Date Gender Clearance 51,000 4/11/97 3/7/63 M TS 42,900 5/1/02 4/14770 M 56,700 5/14/99 5/27/70 M 46,540 9/5/95 3/4/64 M 56,700 10/10/95 4/29/70 F S 66,300 1/28/97 4/10174 M S 59,800 12/13/96 712170 F 54,500 10/13/90 M S 65,000 10/1/95 2/12/65 F S 46,000 9/16/99 3/28/52 F S 53,300 2/8/94 3/21/70 M S 64,300 7/6/98 3/10/66 F S 49,600 11/16/95 1/24/63 F S 33,000 4/18/96 12/12/72 M TS 38,000 11/5/01 5/3/82 N 43,000 12/1/01 1/26/55 M S 32,000 8/26/94 5/6/61 F 62,040 10/1/93 2/14/56 F 75,700 10/13/92 4/10/65 63.000 6/16/92 12/22/58 F S 66,500 12/18/92 2/3/58 M S 42,500 3/21/90 8/20/70 F 34,500 3/21/90 8/22/58 38.900 12/24/89 3/4/61 M za 2 2 2 2 2 2 2