Accountancy Data Visualization Competition

Here are a few concepts you’ll need to understand to succeed at this case:

• Profit Margin = Profit / Revenue = (Revenue – Cost) / Revenue
• Product sales mix is the percentage of total sales that a single product represents. For instance, assume you sell Product A and Product B.
  • Total Sales of Product A = 100 units x $4 per unit = $400
  • Total Sales of Product B = 200 units x $3 per unit = $600
  • Total Sales = $400 + $600 = $1000
  • Product A’s Sales Mix = $400 / $1000 = 40%
  • Product B’s Sales Mix = $600 / $1000 = 60%

How would a change in product sales mix influence the overall average profit margin?

Software

• Students may use any data visualization software they like to create the graphs that will be part of their data visualization story. However, we recommend one of the following:
  • Tableau - https://www.tableau.com/academic/students
  • Microsoft Power BI Desktop - https://powerbi.microsoft.com/en-us/downloads/
  • Microsoft Excel (Google Sheets can also generate graphs)

What To Expect

• The case data and instructions will be distributed to participating teams on or before Monday, March 4, 2024.
  • You will receive data about LeGrind Coffee's sales, customers, inventory and cash receipts. You will need to understand, combine, and prepare this data to analyze LeGrind's profit margin over time and explain why it is changing.
• You will submit a copy of your presentation by Friday, April 5, 2024. 
• You will present your analysis to a panel of judges on Saturday, April 6, 2024.

Presentation

• Presentations will be limited to 15 minutes. Ten (10) minutes for the presentation and two to three (2-3) minutes for questions from the judges.
• Your presentation should be a in PowerPoint file.

Submission Requirements

• Please email a copy of your PowerPoint presentation to Matt Pickard (mpickard@niu.edu) by the end of the day on Friday, April 5, 2024.