Understanding the profit or margin on unsold inventory can offer valuable insights into your pricing strategy and potential earnings. While this analysis assumes that all inventory will sell at full price, without discounts, which isn’t always the case, it’s still a useful way to gauge whether you're on track to meet your profit goals or if adjustments are needed.
By using a few targeted calculations, you can assess the potential profit and profit margins of your current inventory based on its cost and retail value.
Preparing the inventory report
To begin, open a Dusty Inventory report, which is essentially an Inventory report with specific filters. To turn it into a full Inventory report, you’ll need to remove two filters:
- Open the Filters panel.
- Remove the filters: Is Dusty is Yes and Quantity on Hand is greater than 0.
- Click Run to rerun the report.
After the filters are removed, you’ll get a true inventory report and have a complete view of your inventory.
Adding measures
Profit is a function of Total minus Cost. To calculate profit, you’ll need both the Total Cost, which is already included in the report, and the Total Retail Value.
For the Total Retail Value, navigate to Item Metrics > On Hand > Total Retail Value, add it to the report, and run it.
To streamline the data, click the gear icon (Settings) for Days Since Sold and Days Since Received and select Remove.
This simplifies the report to include only the data needed for profit analysis.
Calculating profit potential
Profit is the Total minus Cost. Now that your report includes both cost and retail value, you can calculate profit potential using a table calculation.
- Navigate to Custom Fields > Table Calculation.
- Search and add Total Retail Value.
- Include a subtraction symbol to the calculation.
- Search and add Total Cost.
- Optionally, set the number type to your desired currency.
- Optionally, add a clear title for the calculation, such as Profit Potential.
- Save the calculation.
Your report now includes a field that displays how much line profit you could make if you sold your entire inventory at full price.
Calculating potential profit margin
Now that you have your profit potential, you can calculate your potential profit margin. Profit margins are the profit of a sale compared to the full retail price of the sale.
- Navigate to Custom Fields > Table calculations.
- Click the gear icon (Settings) beside Profit Potential and select Duplicate the Profit Potential calculation.
- Then, edit the new calculation by clicking the gear icon (Settings) and selecting Edit.
- Add parentheses around the profit formula to maintain the order of operations.
- Include a forward slash and divide the result by the Total Retail Value.
-
Change the number type to Percent.
-
Optionally, rename the calculation, for example, Margin Potential.
-
Save the calculation.
The results will display in your report.
These are the exact formulas used:
- Profit Potential:
${cl_item_facts.retail_value} - ${cl_item_facts.cost_value} - Margin Potential:
(${cl_item_facts.retail_value} - ${cl_item_facts.cost_value}) / ${cl_item_facts.retail_value}
These calculations help you understand your inventory’s earning potential.