What is the most popular Size for wine and for spirits

Assignment Help Accounting Basics

Reference no: EM132750670

Question - 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 (SalesFINAL6302019) and their purchase price file (2019PurchasePricesJun ) with the cost of each inventory item. Traditional spreadsheets cannot process all of the data, requiring the use of Tableau to complete due diligence.

The Bibitor, LLC CFO 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.

Required - Assist the CFO in creating Worksheets and Dashboards to answer these questions:

1- What is the total Sales Dollars and percentage breakdown of wine and spirits?

2- What is the most popular Size for wine and for spirits based on Sales Dollars and Quantity (include the total Sales Dollars and Quantity in your answer)? Provide the CFO with some reasons why this is important for managing the business.

3- Who is the most popular Vendor for wine and for spirits based on Sales Dollars and Quantity (include the total Sales Dollars and Quantity in your answer)? Provide the CFO with some reasons why this is important for managing the business.

4- Which Stores have the highest and lowest weighted average sales price for wine and spirits? How does the weighted average sales price compare to a simple average of Sales Prices for SKUs (Brands) in each Store? What does a large difference between the simple average and the weighted average mean?

5- What seasons/months are sales the highest and lowest? Provide the CFO with some reasons why this is important for managing the business.

Reference no: EM132750670

Questions Cloud

Describes the relationship between osha and labor unions : Describes the relationship between OSHA and labor unions? Many unions have safety provisions complementing OSHA rules and requirements.

What amount of Interest Revenue should Fullbright recognize : The goods have an inventory cost on Fullbright's books of $240,000. What amount of Interest Revenue should Fullbright recognize in 2017

Internal conflicts of the inventory management system : Describe the internal conflicts of the inventory management System and its collision with the firms profitability.

What are some of the diversity ramifications : What are some of the diversity ramifications, and how do health care organizations characterize components such as various minority programs?

What is the most popular Size for wine and for spirits : What is the most popular Size for wine and for spirits based on Sales Dollars and Quantity (include the total Sales Dollars and Quantity in your answer)

Did the nba educate members on issue management : Did the NBA educate its members on issue management before becoming tied to the China market? If not, what steps of the issue management process

Which is advantage to top-down planning management approach : Which is an advantage to top-down planning management approach? senior management may not be in the best position to. objectively view the future

What do you recommend management do in given situation : Workers in the Administrative Unit view the strategic development plan that was implemented in 2016 as ineffective as it relates to career development.

Why do organizations need both grievance procedures : Why do organizations need both grievance and disciplinary procedures? What is the role played by the supervisor in handling grievances?

User Account

All Pages