Sections

SalesProfitReceipt QtyStocksPriceCost of salesAvg Receipt PriceFinance metricsTurnsLoyaltyPlansRefundsPostingsRelocationDiscountLaboratoryOtherPromotional metricsSales QtyProblem Products Store ManagerAvailabilitySupplierAssortment activityProduct LayoutOrder/DeliveryWrite-offsPOS-terminal
Metrics
>
Finance metrics

FINANCE METRICS

Sections:

Metrics - group of metrics on Datawiz BI service

There is a list of metrics of the group "Finance metrics".

Access to viewing metrics according to the user's role is determined by the administrator. To expand access, contact your administrator.

 

the amount of profit per 100 monetary units of turnover.

the difference between the product profitability for the selected period and the  product profitability for the previous period.

indirect tax which is included in the product price and paid by the clients.

the difference between the VAT for the selected period and the VAT for the previous period.

the difference between the VAT for the selected period and the VAT for the previous period, calculated as a percentage.

tax which is included in the price of the products (luxury products, tobacco, alcohol, precious metals, etc.), and paid by the clients.

the difference between the excise for the selected period and the excise for the previous period.

the difference between the excise for the selected period and the excise for the previous period, calculated as a percentage.

the percentage of the profit from the primecost of sales.

Note! The calculation of the mark-up will differ at the level of products.

the difference between the mark-up for the selected period and the mark-up for the previous period metrics.

the percentage of the profit from the sales.

At the level of categories/subcategories the value of Margin,% is equal to the value of product profitability,%.

Note! The calculation of the margin will differ at the level of products.

the difference between the margin for the selected period and the margin for the previous period.

the percentage of the profit from the average inventory in monetary units. The metric characterizes the efficiency of investing in products.

the difference between the GMROI for the selected period and the GMROI for the previous period.

the number of days provided by suppliers to pay the bill for the delivered products.

the difference between the postponement in days for the selected period and the postponement in days for the previous period.

the difference between the postponement in days for the selected period and for the previous period, calculated as a percentage.

number of days during which own current assets perform one turnover. Negative value of financial cycle means that the product rotates longer than the delay from the supplier is active. In this case, you need to change the deferral agreement with the supplier or affect the acceleration of turnover. A positive value indicates how many days money from clients arrives faster than it should be returned to suppliers for the products.

Note! The financial cycle is calculated for each product of the store first. Then these metrics are calculated for the store, category, brand by calculating their average value.

shows how much money the store saves on the product due to the delay.

Note! The financial accumulation is calculated for each product of the store first, and then the metrics are calculated for the store, category, brand. For this purpose, it is necessary to add metrics of financial accumulation of the separate products of the corresponding level (store / category / brand).
Note! The average number of sales of one product (when calculating the financial accumulation) takes into account all the days of the selected period (The sum of products sold for the selected period / Number of days (weeks) in the period).

shows how much you can earn if you put the financial savings in the bank.

Note! The cost of capital is calculated for each store product first. Then the metrics for the store, category, brand are calculated by summing them.