Business KPI of CEO Dashboard for Consumer Packed Goods

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.


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.


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.


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 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 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.


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.
