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

The Answer is in the image, click to view ...

Question: 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

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Educational Objectives: After successfully completing this assignment, the student should be able to accomplish the following: Use a loop structure to read user input of unknown size through std::cin...

MGMT8370 Assignment 1 Due: June 5th, 2022 Points: 10 Weight: 15% Late Assignments: 10% reduced grade per day (Maximum of 3 days) Assignments submitted more than 3 days late will receive a zero About...

This is to be done in C++: Educational Objectives: After successfully completing this assignment, the student should be able to accomplish the following: Use a loop structure to read user input of...

About the Assignment: It is often challenging to remove personal biases when making decisions. This individual assignment relates to problem-solving and decision-making. Some group work is needed;...

I know its a bit harsh but see if you can finish it in before tomorrow? thanks QUEENSLAND UNIVERSITY OF TECHNOLOGY QUT Business School School of Accountancy AYN416 Financial Accounting 1 Semester 2...

I have an accounting assignment need to be finished asap. QUEENSLAND UNIVERSITY OF TECHNOLOGY QUT Business School School of Accountancy AYN416 Financial Accounting 1 Semester 1 2017 Integrated...

MNG3702/101/3/2016 Tutorial Letter 101/3/2016 Strategy Implementation and Control MNG3702 Semesters 1 and 2 Department of Business Management PLEASE NOTE: This tutorial letter contains important...

I only need answers for 3.1, 3.4, 3.5, 4.3, 5.3, 5.5, 5.6, 6.3, 6.8 (b, c, f, h, k, m), and 7.2. 1 Submission Instructions Note that for each homework assignment, only some of the exercises will be...

8. Problem 3.4.12. What multiple of a = the result orthogonal to ? Factor 1 [1] 4 - [8] into QR with orthonormal vectors in Q. should be subtracted from a2 to make

Of all students enrolled at a large undergraduate university, 19% are seniors, 23% are juniors, 27% are sophomores, and 31% are freshmen. A sample of 200 students taken from this university by the...

To be classified as an adequately capitalized commercial bank under the Basel capital accord | | | after 2 0 1 9 the commercial mush have a tier | risk based capital ratio of atleast _ _ _ _ and a...

Within a continuously competitive global business environment, publicly held companies face constant pressure to generate and report positive financial results. Unfortunately, some leaders may be...

If you were responsible for designing a basic skills/literacy training program, what approach would you take? How would you determine the effectiveness of this program?

Colleges and universities are primarily service enterprises. What key components would you include in customer service training for college employees, such as security or records office staff, who...

Why is it important to coach employees with performance problems, as well as employees who are performing well?