Definition: This is the average number of units sold per day when the product was in stock. Note: Out-of-stock days are not included. Also needs a date filter to determine what date range we are taking an average of. Equation: Total amount sold / days in stock Example: This metric is used in a lot of other calculat…
Definition: The average cost amount for a product or an aggregated level of products Note: This only includes products that have costs Equation: Total Costs / Total Units Example: Average Cost per Unit gives the retailer the opportunity to see if costs for a product or a group of products is getting too high. Seein…
Definition: How much profit is going to cover the costs. Note: An average of markup at a product level Equation: average of (Gross Margin / Costs) or average of (Profit / Costs) Example: Retailers want to see average markup to be over 100%. If it is over 100% the profit of the sale has covered the cost. If the valu…
Click [here][1] for an explanation of aggregations of: * In Stock Average Units per Day * Estimated Days Remaining * Minimum Suggested Order [1]: https://www.loom.com/share/bd87a689959d4229a78b5f7493e10392
Definition: The average amount the product was sold for. The amount someone, on average, paid for a product. Note: Takes discounting into consideration but not cost of goods. Equation: Total Revenue / Total Units Example: Average Item Price is used to understand how much people are paying for a product or an aggreg…