How Can We Help?

Search for answers or browse our knowledge base.

Home | Releases | iOffice

< All Topics
Print

Product Sales Analysis Report

Location: Reports > Products > Product Sales Analysis

Close analysis of product sales from a given date range, broken down by product brand.

Use Cases by Role

  • Salon Owner: Salon owners who are considering switching out different product brands can reference this report to see which ones are the most successful.
  • Salon Manager: Salon managers are able to use this report to determine which product brands should be stocked more frequently, based on sales numbers.
  • Salon Employee: Frontline salon staff such as stylists and receptionists can reference this report when they have questions about which brands are performing best in their salon.

Data Filters

  • Select Stores: Clicking or tapping here will open the interface that allows the user to select the store(s) that will be be used for the report.
  • Enter Date Range: Clicking or tapping into this field will generate a calendar interface for the user to select a single date, or a date range.
  • Monthly: Filling in this checkbox will populate two drop-down menus where users can select specific months and years, as opposed to traditional date range.
  • Show Store Breakdown: This box should be checked if multiple salons are being used for the purposes of the report.
  • Generate Report: Clicking or tapping on this button will generate the report based on the other filter criteria.

Metrics Tracked

  • Brand: The Product Brand associated with the sales.
  • Total Cost: The total cost to the salon for the items sold under this brand.
  • Total Sales: The dollar value of sales revenue generated by this product Brand.
  • % Total Sales: The percentage of sales associated with this product Brand, compared to all sales of products in the date range.
  • % Margin: The percentage value of the profit margin associated with the product sales in this brand.
  • In Stock $: The retail value of all items currently in stock that are associated with this brand.
  • % Total Stock: The percentage value of items sold under this brand, compared to stock totals.
  • Stock/Cost: The stock numbers of this item compared to its cost.
  • Totals: Each column will have totals tabulated at the bottom of the report.

Report Calculations

  • % Total Sales: The total sales number for this row divided by the Total at the bottom of the report for the same column then multiply that result by 100.
  • % Margin: Total Sales minus Total Cost. Then take that result and divide it by Total Sales. Take that final result and multiply by 100. Example – Cost $8.60 Total Sales $21.50 – Margin 21.50-8.60 = 12.90 then 12.90 divided by 21.50 = 0.6 multiplied by 100 is your final answer of a 60% margin.
  • % Total Stock: The In Stock $ number for this row divided by the Total at the bottom of the report for the same column then multiply that result by 100.
Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
Previous Product Order Report
Next Product Sales Detail Report

Leave a Reply

Your email address will not be published. Required fields are marked *

Table of Contents