Analyzing Profits

Analyzing Profits

Now that we’ve visualized our sales data, let’s calculate and analyze the profits for each ice cream flavor.

16. Calculate total sales by flavor and month

First, let’s calculate the total sales for each flavor and month:

17. Calculate total profits

Now, let’s calculate the total profits for each ice cream flavor. We’ll do this by multiplying the sales by the price per scoop and then summing up the results.

18. Visualize total profits by flavor

Let’s create a bar chart to visualize the total profits for each ice cream flavor:

These exercises have given us valuable insights into the profitability of each ice cream flavor. In the next and final section, we’ll summarize our findings and discuss potential business recommendations based on our analysis.