FMCG Dashboard is a tool designed to evaluate the success of reaching your company targets. A preconfigured set of high- and low-level Key Performance Indicators (KPIs) these will allow you to monitor and demonstrate the performance of your business and to further focus on important company processes.

Fast Moving Consumer Goods (FMCG) KPIs reflect branch-characteristic elements like: fast-moving products, time and cost efficiency of supply chains, the short sale cycle and continuous optimisation of the stock assortment.

FMCG Dashboard offers over twenty predefined KPIs. The application allows you to build your own Dashboard which reflects your own business structure and can equally  affect a positive change. Set of chosen KPIs in connection with your sales data visualise and document your success.

 

FMCG Dashboard – example configuration

 

• Access to the predefined KPIs can be configured in context of a User or a User role in the company. User defined KPIs can be created with the use of simple SQL Queries.

• Filters for the KPIs can be configured in relation to the data and business needs.

• Sales data can be stored and introduced directly from Oracle database or imported from other data source.

• Export of diagrams to Excel and PDF format is possible.

 

Some of the KPIs available in the FMCG Dashboard

Turnover Total and Planned

This allows you to calculate and current and the value of the Total Turnover net for all articles in your assortment and all the stores in your company structure since the start of the business year, reduced by returns amount, with consideration of single months revenue and compare it to the Planned Turnover net. Additionally Turnover from the previous year can also be shown.

 

Turnover Store

Allows you to calculate and present the value of monthly Turnover Store net for all articles in your assortment and stores chosen within the filters, reduced by returns amount. Additionally the average monthly Turnover Store for all stores in your company structure is calculated and presented as a reference value.

 

Turnover %

Allows you to calculate and visualise the percentage relation between value of Total Turnover net for the chosen within filters articles and article groups and the Total Turnover net for all articles in your assortment, reduced by returns amount, since the start of the business year.

 

OTIF (DELIVERY ON-TIME AND IN-FULL)

Allows you to measure delivery performance and quality within a supply chain depending on the supplier chosen within the filter. OTIF is calculated with use of formula (on-time deliveries / total deliveries) * (in-full deliveries / total deliveries). Depending on the business needs it is possible to use also a factor (quality deliveries / total deliveries). Additionally a reference Supplier or AVG Supplier values can be shown.

 

Average Time to Sell

Allows you to estimate how long it takes to sell articles from product groups chosen within the filter (time in days between delivery date and date of sale). Very important FMCG KPI in relation with sales data will provide information useful to reduce storage and labor costs and to precisely plan delivery times. User filter can be defined on article group or article level.

 

Sold within freshness date

Allows you to estimate the percentage of assortment from product groups chosen within the filter which is being sold within the due date. It is very important FMCG KPI which in relation with the sales data will provide the necessary information useful to find a compromise between product availability and selling the article within expiration date. A filter can be defined on article group or article level.