Bibitor, LLC asked you to complete due diligence on their wine and spirits business. Bibitor has 79 retail locations with approximately $484 million in sales. Their CFO is at the forefront of data analytics and created a Storyline the company uses for making decisions about their stores. To facilitate the investigation, you have Bibitor’s sales file with more than 13 million records and their purchase price file with the cost of each inventory item. Traditional spreadsheets cannot process all of the data, requiring the use of Tableau to complete your due diligence. Prior to using Tableau, the CFO provides you with two Dashboards from their Sales Profitability Storyline for the 12-months ended June 30, 2019. The Company uses a different visualization software package. Your visualization will look different, but the data is the same

Required: 1. Using these two Dashboards, describe Sales and Cost of Goods Sold (COGS) in a short memo. In your memo, include a discussion about: • The total number of stores • Total Sales and Cost of Goods Sold for the company • The average and median Sales and Cost of Goods Sold per store • The 5 largest and smallest stores based on Sales and Cost of Goods Sold • Are the 5 largest/smallest stores based on Sales the same as the 5 largest/smallest based on Cost of Goods Sold? Would you expect them to be the same? What could cause differences?

Answer rating: 100% (QA)

Bibitor has 79 retail locations with approximately 484 million in sales Their CFO is at the forefront of data analytics and created a Storyline the company uses for making decisions about their stores ... View the full answer