Answered step by step
Verified Expert Solution
Question
1 Approved Answer
BIBITOR, LLC DATASET SUPPORTING MATERIAL Brand Analysis of June 30, 2023 Bibitor, LLC. Incorporating Tableau. Case Information: The CFO of Bibitor, LLC asked you to
BIBITOR, LLC DATASET SUPPORTING MATERIAL Brand Analysis of June 30, 2023 Bibitor, LLC. Incorporating Tableau. Case Information: The CFO of Bibitor, LLC asked you to analyze brand profitability of the wine and spirits business.1 Bibitor has 68 retail locations with approximately $512 million in sales. Their CFO is at the forefront of data analytics and would like a more user-friendly way of looking at the information they use to make decisions about their stores. The CFO wants to improve her understanding of Bibitors inventory management by investigating the most profitable brands by dollars and percentage. Additionally, the CFO wants to evaluate the inventory management system by examining the days inventory outstanding ratio, stockouts, and seasonal brands. To facilitate the initial investigation, you have Bibitors sales file with a sample of their usual 12 million records and their purchase price file with the cost of each inventory item. Traditional spreadsheets struggle to process all the data, requiring the use of other software to complete the analysis. Below are snapshots of the tables she uses. Part 1: The CFO wants you to improve these visualizations to make them more appealing and address these items: What are the top 5 Brands with the highest gross margin in dollars versus percentage? Why are they different Brands? Why are there blanks cells in the Gross Margin Percentage by Brand dashboard? Is the gross margin percentage in the Grand Total column of the Gross Margin Percentage by Brand dashboard calculated using a simple average of the quarters or is it a weighted average for the brand? Compare the top 5 Brands in the Gross Margin Dollars by Brand Dashboard. - What kind of spirit (rum, whiskey, or vodka) appears to be most important to company profitability based on the top 5 brands? - Why is this important to know? Calculations you may need: - Gross Margin = (Sales Dollars COGS) - Gross Margin % = sum of Gross Margin/ sum of Sales Dollars
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started