Vistabeans Coffee Shop Assignment for BUS 410 Research Methods

The instructions below specify creation of a report with 3 or more visualizations.Read the solution memo carefully to understand how it relates to the dataset provided.Replicate the six visualizations embedded in the memo.Upload the completed file by clicking on the link for this assignment.

Vistabeans Coffee Shop - Solution

Requirements

Assume you are Alma Nelson and use Tableau to analyze Vistabeans profitability. Your deliverables include:

1.You have to write a report with recommendations as to how the company can maximize profit. Your report should include outputs from Tableau. Your report should contain at least 3 visualizations to support your recommendations.

2.Deliver a presentation to Eli and Sarah summarizing how the company can maximize profit. Your presentation should include outputs from Tableau.

Recommendations will vary; however, the following recommendations are likely given the dataset.

Discontinue sales of low profit items.

Adjust marketing expenditures.

Investigate potential inventory and accounting errors.

Visualizations will also vary; however, the following visualizations are likely given the dataset.

Line graphs

Bar graphs

Map graphs

Report Formats will vary unless specific format instructions are provided.

Grading Rubrics will vary depending on the instructor's actual assignment; however, the following grading rubric could be used for the case requirements.

Requirement

Point Allocation

You have to write a report with recommendations as to how the company can maximize profit. Your report should include outputs from Tableau. Your report should contain at least 3 visualizations to support your recommendations.

Points Possible = 50

Report is grammatically correct and contained at least three recommendations supported by at least three visualizations (50 points).

Report is grammatically correct and contained two recommendations supported by at least three visualizations (25 points).

Report contained less than two recommendations (0 points, even if supported by at least three visualizations).

Deliver a presentation to Eli and Sarah summarizing how the company can maximize profit. Your presentation should include outputs from Tableau.

Points Possible = 50

Evidence of preparation, clear and articulate, and use of at least three visualizations in presentation (50 points).

Evidence of preparation, clear and articulate, and use of two visualizations in presentation (25 points)

No Evidence of preparation, or not clear and articulate, or less than two visualizations in presentation (0 points)

Total Points Possible 100

Examples of Visualizations and Student Analyses

Examples of the visualizations and explanations that might be included in the presentations and reports are included on the following pages. Note: these examples are from actual student reports that were submitted as part of the case efficacy testing.

General Information:

\fWest Inventory vs Sales 180K 171,183 160K 161,801 161,801 . 171,183 Market Central East 140K South 136,020 West 136.020 120K 117,405 17,405 Inventory 100K 80K 60K 40K 20K OK 35K 35.197 33,653 34,385 35,699 32.639 34,166 31,746. 34,779 30K 25K 20K 15K 10K 5K OK 2012 Q1 2012 Q2 2012 Q3 2012 Q4 2013 Q1 Quarter of Date 2013 Q2 2013 Q3 2013 Q4 The trends of sum of Inventory and sum of Sales for Date Quarter. Color shows details about Market.Marketing of Caffe Mocha Product 100K 84.904 78,162 Sales 50K OK 20K 19,686 17.346 15,880 15K Marketing 12, 166 11:362 10K 9.766 10, 112 9.846 7,126 5:472 6.108 5K 4.658 2.946 OK 55.804 40K Profit 27 231 29.053 29.502 29.869 24, 164 20K 17,678 11:375 13.989 10.065 4,890 6.154 -231 Amaretto Caffe Latte Caffe Chamomile Colombian Darjeeling Decaf Mocha Decaf Irish Earl Grey Green Tea Lemon Mint Espresso Cream Regular Espresso Sum of Sales, sum of Marketing and sum of Profit for each Product.Green Tea Product Measure Names Amaretto Caffe Latte Green Tea Regular Espresso Cogs Profit Sales 35K Total Expenses 30K 25K- 20K Value 15K 10K- 5K OK Cogs Profit Sales Total Cogs Profit Sales Total Cogs Profit Sales Total Cogs Profit Sales Total Expenses Expenses Expenses Expenses Cogs, Profit, Sales and Total Expenses for each Product. Color shows details about Cogs, Profit, Sales and Total Expenses. The view is filtered on Product, which keeps Amaretto, Caffe atte, Green Tea and Regular Espresso.Caffe Latte Market Product Product South West Caffe Latte Market 4K South West 2K OK -.......... Caffe Latte Inventory -2K -4K 800 600 Sales 400 200 January 2012 March 2012 May 2012 July 2012 September 2012 November 2012 January 2012 March 2012 May 2012 July 2012 September 2012 November 2012 Month of Date Month of Date The trends of sum of Inventory and sum of Sales for Date Month broken down by Market vs. Product. For pane Sum of Inventory: Color shows details about Product. For pane Sum of Sales: Color shows details about Market. The view is filtered on Market, Product and Exclusions (MONTH(Date),Product). The Market filter keeps South and West. The Product filter keeps Caffe Latte. The Exclusions (MONTH(Date),Product) filter keeps 311 members.The trends of sum of Sales and sum of Profit for Date Month broken down by Market. Profit Sales OK 1K 2K 3K 4K 5K- OK 2K- 4K- 6K 8K 10K 12K Sheet 1 January February March April May June July Central August September October November December January February March April May June East July August Color shows details about Date Year. September October November December January Market / Date February March April May June South July August September October November December January February March April May June West July August September October November December 2013 2012 Year of Date