Compare the products.
Compare the products.
1. What is the year over year growth (CAGR) in units and as a percentage?
a. What are the Top 3 products that had the largest increase in units sold and largest decrease in units sold. What is the percentage increase and percentage decrease?
b. What percentage of total units and dollars sales do the top 5 best products represent? (think 80/20/115 rule)
c. How many products are outside the top 5 and what percentage of Units and Dollars do they represent?
3. Compare Selling Country Sales
a. Which country had the highest growth in units and which had the highest growth as a percentage
b. What percentage of sales revenue goes thru each Country?
4. Compare Selling Channels
a. Which Channel had the highest growth in units and which had the highest growth as a percentage
b. What percentage of sales revenue goes thru Channel?
5. Sales by Month
a. Calculate the growth by month ( ex. How many more units were Jan to Jan) by Unit and as a percentage. You have to do all Months.
b. Which month has highest growth in units and which had the highest percentage growth rate (percentage)?
c. Calculate the growth Month to Date in sales by Unit and as a percentage. (Jan = Jan, Feb= Jan + Feb, March = Jan + Feb + March, etc.

