1. 2013_Technology_PlugIn_T3.pdf file

This is the PDF assignment instructions that you need to read through in order to finish the assignment 5. In the end of this PDF document, under the "Making Business Decisions" section, the question number 2. "Coffee Trends" is your assignment.

2. You must use this data file: T3_JittersCoffee_Data.xlsx

3. You need to find out the amount of revenue by stores (north and south) and products (Decaf, French Roast, ...) and create the following table

Store	Decaf	French Roast	Hazelnut	Irish Cream	Regular	Vanilla	Grand Total
North
South
Grand Total

4. Base on the table you have created, recommend 4 top selling coffees.

5. Once you finished your assignment, please submit the Excel file to Canvas -> Assignments -> Excel 5

Key
Jitters = North
Bean Scene = South
Product	Month	Store	Revenue
Regular	January	North	4320
Regular	February	North	4500
Regular	March	North	3528
Regular	April	North	3960
Regular	May	North	3996
Regular	June	North	3960
Regular	July	North	3960
Regular	August	North	4230
Regular	September	North	4230
Regular	October	North	4275
Regular	November	North	4365
Regular	December	North	4455
Regular	January	South	3960
Regular	February	South	4230
Regular	March	South	4230
Regular	April	South	4275
Regular	May	South	4365
Regular	June	South	4455
Regular	July	South	4128
Regular	August	South	4176
Regular	September	South	3936
Regular	October	South	4090
Regular	November	South	3936
Regular	December	South	4350
Decaf	January	North	4350
Decaf	February	North	4350
Decaf	March	North	4350
Decaf	April	North	3610
Decaf	May	North	3640
Decaf	June	North	3610
Decaf	July	North	2210
Decaf	August	North	2430
Decaf	September	North	2430
Decaf	October	North	2460
Decaf	November	North	2540
Decaf	December	North	2310
Decaf	January	South	2620
Decaf	February	South	2450
Decaf	March	South	2430
Decaf	April	South	2480
Decaf	May	South	2540
Decaf	June	South	2610
Decaf	July	South	2340
Decaf	August	South	2380
Decaf	September	South	2540
Decaf	October	South	2310
Decaf	November	South	2400
Decaf	December	South	2320
French Roast	January	North	2290
French Roast	February	North	5290
French Roast	March	North	4320
French Roast	April	North	4500
French Roast	May	North	3528
French Roast	June	North	3960
French Roast	July	North	3996
French Roast	August	North	3960
French Roast	September	North	3960
French Roast	October	North	4230
French Roast	November	North	4230
French Roast	December	North	4275
French Roast	January	South	4365
French Roast	February	South	4455
French Roast	March	South	3960
French Roast	April	South	4230
French Roast	May	South	4230
French Roast	June	South	4275
French Roast	July	South	4365
French Roast	August	South	4455
French Roast	September	South	4128
French Roast	October	South	4176
French Roast	November	South	3936
French Roast	December	South	4090
Vanilla	January	North	3936
Vanilla	February	North	4350
Vanilla	March	North	4350
Vanilla	April	North	4350
Vanilla	May	North	4350
Vanilla	June	North	3610
Vanilla	July	North	3640
Vanilla	August	North	3610
Vanilla	September	North	2210
Vanilla	October	North	2430
Vanilla	November	North	2430
Vanilla	December	North	2460
Vanilla	January	South	2540
Vanilla	February	South	2310
Vanilla	March	South	2620
Vanilla	April	South	2450
Vanilla	May	South	2430
Vanilla	June	South	2480
Vanilla	July	South	2540
Vanilla	August	South	2610
Vanilla	September	South	2340
Vanilla	October	South	2380
Vanilla	November	South	2540
Vanilla	December	South	2310
Irish Cream	January	North	2400
Irish Cream	February	North	2320
Irish Cream	March	North	2290
Irish Cream	April	North	5290
Irish Cream	May	North	4350
Irish Cream	June	North	4350
Irish Cream	July	North	4350
Irish Cream	August	North	4350
Irish Cream	September	North	3610
Irish Cream	October	North	3640
Irish Cream	November	North	3610
Irish Cream	December	North	2210
Irish Cream	January	South	2430
Irish Cream	February	South	2430
Irish Cream	March	South	2460
Irish Cream	April	South	2540
Irish Cream	May	South	2310
Irish Cream	June	South	2620
Irish Cream	July	South	2450
Irish Cream	August	South	2430
Irish Cream	September	South	2480
Irish Cream	October	South	2540
Irish Cream	November	South	2610
Irish Cream	December	South	4350
Hazelnut	January	North	3610
Hazelnut	February	North	3640
Hazelnut	March	North	3610
Hazelnut	April	North	2210
Hazelnut	May	North	2430
Hazelnut	June	North	2430
Hazelnut	July	North	2460
Hazelnut	August	North	2540
Hazelnut	September	North	2310
Hazelnut	October	North	2620
Hazelnut	November	North	2450
Hazelnut	December	North	2430
Hazelnut	January	South	2480
Hazelnut	February	South	2540
Hazelnut	March	South	2610
Hazelnut	April	South	2340
Hazelnut	May	South	2380
Hazelnut	June	South	2540
Hazelnut	July	South	2310
Hazelnut	August	South	2400
Hazelnut	September	South	2320
Hazelnut	October	South	2290
Hazelnut	November	South	5290
Hazelnut	December	South	4320