Business KPI of CEO Dashboard for General Merchandise

Business KPI of CEO Dashboard for Consumer Packed Goods

 

Revenue and Cost Sold Products

Revenue and Cost Sold Products

Analysis of retailer’s total revenue from customers during the specific period has remarkable insights. The management dashboard has the advantage to not only aggregate it by the month but also by day, week, Quarterly and yearly.

This KPI aggregates total cost paid to suppliers, packaging and storage over a specified period.

Revenue by Products Category

This KPI differentiates categories of main storage items on the basis of high revenue to low revenue and can be sought to analyze the trends.

Revenue Distribution by main Products Category
Margin value

Margin value

It is important for stakeholders to know a businesses’ earnings after deducting the earnings which are spent mostly on suppliers of goods and complementary packaging.

Margin Ratio

This analysis shows the ratio of earnings comparing to the costs of sold products.

Margin Ratio
Number of Transactions

Number of Transactions

Shows the total number of transactions during a specified period and the dynamic compared to previous periods. Generally aggregated by month, as well can be shown by day, week, quarter, year.

Number of Customers

This KPI shows the number of our unique customers who made the transaction, after which each customer is identified with a unique ID through a loyalty program.

Number of Customers
New-Repeat Customers

New/Repeat Customers

It shows the number of customers newly acquired by retailers in the reporting period and the number of customers the store manages to attract but acquired in the previous period.

Average Frequency

The data shows how many times on average the consumer visited the retailer over the reporting period.

Average Frequency
Average Transaction Value

Average Transaction Value

The average amount spent on one transaction.

 

Average no. Items/transaction

It shows the size of an average shopping cart of the consumer base.

Average no. Items-transaction
Average Recency-days

Average Recency, days

Shows on average the length and the time in days since the customer’s last transaction.

Inventory Days

This KPI shows on average, what time, usually days, the Store keeps the inventory until sold.

Inventory Days
Markdown Value

Markdown Value

It aggregates total lost due to the sale of markdown products - sold below the Cost Price paid to Suppliers, usually because of the close expiry date.

Wastage Value

Aggregates total cost for food and complementary packaging of all the SKUs that cannot be sold due to expiry date or other quality issues.

Wastage Value