Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Service Management Operations, Strategy, Information Technology

Authors: James A Fitzsimmons, Mona J Fitzsimmons

6th Edition

0077228499, 9780077228491

More Books

Students also viewed these General Management questions