What's new?
Try the ready-to-use reports in the demo for free
Right now, you can try out over 30 custom reports, a dashboard builder, and use the formula builder for your individual calculations!
14 day trial period
No credit card required
Margin Calculator
Business calculator
See the true impact of each product: the calculator provides quick insights into essential retail KPIs. Understand which items strengthen profitability and which ones hold it back.
Are manual calculations and formulas taking up too much of your time? Try Datawiz BI
Datawiz — your tool for instant analytics and control
Sales Analysis
Ready-to-use reports give you the full picture of sales: by products, categories, and brands. Spot top-performing SKUs and identify items that drag down profitability.
Details
FAQ
The free Business Calculator from Datawiz is fast and easy to use. To start an online calculation:
- go to the Business Calculator page;
- enter the required data in the input fields using the arrows or manually;
- click on the "Calculate" button.
To change the currency in the Business Calculator for calculating indicators online, you need to click on the "Сurrency" field and select the desired option from the drop-down list.
You can correct the entered data in the calculator online by using the arrows or manually changing numbers.
To clear the calculation results, click the "Reset" button.
To clear the calculation results, click the "Reset" button.
The selling price is the price at which a product is sold. It is calculated using one of the formulas:
- Selling price = Cost price + (Cost price * Markup, % ÷ 100)
- Selling Price = Cost price + (Cost price * Margin, % ÷ (100 - Margin, %))
The calculation of profit for the store can be made according to the formulas:
- Profit (gross) per unit = Selling Price - Cost Price
- Profit (gross) by store = Sales - Sales Cost
Margin, % is the amount of profit that the chain receives for every $100 of sales. It shows the profitability of goods and the efficiency of the store.
In absolute terms, margin and gross profit are the same. The formula for calculating these indicators is the same: Price - Cost Price.
However, the calculation of the margin in percentage form will differ and reflect the profitability of the goods.
However, the calculation of the margin in percentage form will differ and reflect the profitability of the goods.
Margin is calculated in percentage form by using one of the following formulas:
- Margin, % = (Price - Cost Price) ÷ Price * 100%
- Margin, % = Markup, % ÷ (100 + Markup, %) * 100%
Markup,% is an additional value on the cost price of the goods, which shows how much the profit is added to each $100 of purchased goods. The markup is calculated from the purchase price (cost price) of goods.
The calculation of the markup in percentage form is made according to one of the formulas:
- Markup, % = (Price - Cost Price) ÷ Cost Price * 100%
- Markup, % = Margin, % ÷ (100% - Margin, %) * 100%
The additional value in price is actually the markup or margin in absolute terms. But it should be understood that the margin is used in the context of the purchase price (cost price), and the margin is used in the context of the selling price. At the same time, in percentage terms, the values of the margin and the markup differ significantly.
Read more about the differences between the margin and the markup in the article.
Read more about the differences between the margin and the markup in the article.
The inventory turnover ratio shows how many turns (from purchase to sale) the goods performed during the selected period. This indicator allows you to evaluate the sales speed of goods, identify non-selling goods and optimize the assortment of the chain.
It means that during the selected period, all goods completed 1.5 turns - from purchase to sale.
Days sales in inventory - indicates how many days the good takes to complete one turn. In other words, how many days one turn lasts: from the purchase of goods to their sale.
It means that one turn (from purchase to sale) of goods in the chain lasts 4 days. This fact should be taken into account for scheduling the supply of goods.
Inventory turnover indicators have a different positive trend:
! The desired situation for the retailer: ↑ Turnover ratio and ↓ Days sales in inventory, which indicate an acceleration in the turnovers of goods and the release of funds from circulation.
Read more about turnover ratio, their content, and calculation algorithms in the article.
- The increase in the Inventory turnover ratio (turns) indicates an acceleration in sales;
- The decrease in the Days sales in inventory (days) confirms the fact that the goods are sold in fewer days.
! The desired situation for the retailer: ↑ Turnover ratio and ↓ Days sales in inventory, which indicate an acceleration in the turnovers of goods and the release of funds from circulation.
Read more about turnover ratio, their content, and calculation algorithms in the article.
