need help on question 4 please
ACCT 3110 Fall 2019 Tableau Data Visualization Project Assignment Company Background You will be analyzing data from Bibitor, LLC, a wine and spirits business. Bibitor has 79 retail locations and approximately $441 million in sales, The Bibitor, LLC CFO wants some additional analysis using Tableau. She is interested in differences between wine and spirits across the entire organization. She wants to know the differences in Sales Dollars and Quantities between the two categories, popular bottle sizes for wine and spirits, and the most popular vendor for wine and spirits. She is also interested in certain information at the Store level of detail. A. = Low Font Paragraph Styles Create and Share Request Adobe PDF Signatures late To keep up-to-date with security updates, fixes, and improvements, choose Che... Check Analysis Tasks Answer Sheet Question 1 a What are total sales for spirits? $281,175,718 b. What are total sales for wine? $159,895,796 c. What percentage of total sales is due to spirits? 63.75% d. What percentage of total sales is due to wine? 36.25% e. Include your pie charts for total sales by classification and percentage by classification Be sure the mark label feature is turned on. 36.25% Classification 63.75% Question 2 Which store has the highest average sales price per bottle sold for spirits? Store 76 b. Which store has the highest average sales price per bottle sold for wine? Store 3 c. Which store has the lowest average sales price per bottle sold for spirits Store29 d. Which store has the lowest average sales price per bottle sold for wine? Store 14 Question 3 a. What is the highest sales month? December b. What is the lowest sales math? February c. What are total sales for the month of March? $28,988,412 d. What are total sales for the month of December for spirits only? $30,741,557 e. Include your visualization used to answer part a and b (should be a line graph). Be sure the mark label feature is turned on. = Font Paragraph Styles Lrt Create and Share Request Adobe PDF Signatures date To keep up-to-date with security updates, fixes, and improvements, choose Che... Check for 275 Question 4 (3 points) Given the project findings, discuss what these findings mean for the company, and changes they may make to the business based on this information. Your answer should be 2 to 4 paragraphs in length. Do not simply repeat your answers from the previous questions. 24 of 394 Words trump Apewa ACCT 3110 Fall 2019 Tableau Data Visualization Project Assignment Company Background You will be analyzing data from Bibitor, LLC, a wine and spirits business. Bibitor has 79 retail locations and approximately $441 million in sales, The Bibitor, LLC CFO wants some additional analysis using Tableau. She is interested in differences between wine and spirits across the entire organization. She wants to know the differences in Sales Dollars and Quantities between the two categories, popular bottle sizes for wine and spirits, and the most popular vendor for wine and spirits. She is also interested in certain information at the Store level of detail. A. = Low Font Paragraph Styles Create and Share Request Adobe PDF Signatures late To keep up-to-date with security updates, fixes, and improvements, choose Che... Check Analysis Tasks Answer Sheet Question 1 a What are total sales for spirits? $281,175,718 b. What are total sales for wine? $159,895,796 c. What percentage of total sales is due to spirits? 63.75% d. What percentage of total sales is due to wine? 36.25% e. Include your pie charts for total sales by classification and percentage by classification Be sure the mark label feature is turned on. 36.25% Classification 63.75% Question 2 Which store has the highest average sales price per bottle sold for spirits? Store 76 b. Which store has the highest average sales price per bottle sold for wine? Store 3 c. Which store has the lowest average sales price per bottle sold for spirits Store29 d. Which store has the lowest average sales price per bottle sold for wine? Store 14 Question 3 a. What is the highest sales month? December b. What is the lowest sales math? February c. What are total sales for the month of March? $28,988,412 d. What are total sales for the month of December for spirits only? $30,741,557 e. Include your visualization used to answer part a and b (should be a line graph). Be sure the mark label feature is turned on. = Font Paragraph Styles Lrt Create and Share Request Adobe PDF Signatures date To keep up-to-date with security updates, fixes, and improvements, choose Che... Check for 275 Question 4 (3 points) Given the project findings, discuss what these findings mean for the company, and changes they may make to the business based on this information. Your answer should be 2 to 4 paragraphs in length. Do not simply repeat your answers from the previous questions. 24 of 394 Words trump Apewa
