A true Return-on-Investment (ROI) calculation is the holy grail of promotion key performance indicators (KPIs), but CPG companies struggle to understand both the forecasted ROI when planning a promotion and the actual ROI for promotions that have run. So, how do you create the proper processes to calculate ROI?
To be successful, it’s important to understand one fundamental requirement: You must have forecasted and actual base volume. Why? Because the “return” in ROI is the “extra” sales (incremental) you attribute to the promotion tactics that are used: reduced prices, displays, advertising. To calculate incremental, you need to establish what sales are when promotion offers are not present.
Read on to understand the information you will need to calculate the ROI of a promotion, and how to do it.
Step #1 – Determine ‘Base’ Volume. The first decision point here is the type of volume you are using in the ROI calculation: shipments or retail sales (AKA POS, consumption). We recommend using retail sales as the volume basis so that the KPI reflects the effectiveness of the promotion offers to the shopper. If that is not possible, use shipments in your ROI calculation.
The goal in defining base volume is to establish how many units will be sold at their everyday price with no display or advertising. There are multiple methods for establishing base volume:
Step #2 – Determine the two ends of a promotion. There are different dimensions to this. The first dimension is volume. As previously stated, you need to define the type of volume you’re using for promotion measurement and window of promotion. E.g. If this is retail sales, it is the start and end date of the promotional offers to the shopper. The second dimension is spending. The “investment” input to the ROI calculation needs to include all spending that supports the promotion. If this is a scan allowance, you must calculate the spending during the dates of the shopper offer. If the spending is a billback or OI, you must consider the spending that occurred during the shipment window of the promotion.
Step #3- Calculate “Return.” Return is the gross margin earned by the “extra” or incremental sales. To calculate this, you subtract base volume from total to identify incremental sales. You then, 1) calculate Incremental Gross Revenue by multiplying incremental sales by the list price of the product, and 2) calculate Incremental Cost of Goods Sold (COGS) by multiplying incremental sales by the COGS factor for the product(s). Return is calculated by subtracting Incremental COGS from Incremental Gross Revenue.
Step #4- Calculate “Investment.” Investment is spending required to generate the Return. For this calculate the total variable allowances (scans, OIs, billbacks) and fixed fees. Decide if you want to include EDLP in the investment. Determine if you want to include all EDLP or just incremental EDLP. Make sure you do this across customers.
Step #5- Calculate ROI. Divide the Return by the Investment.
Software like BluePlanner TPM by UpClear automates the management of the data, calculation of KPIs, and creation of reporting that enables you to understand the performance of promotions.
To see more on calculating ROI on promotions, see How to Calculate Promotional ROI – Start With 5 Key Building Blocks.
UpClear est une société de logiciels et l'éditeur de Blue, une plateforme d'intelligence utilisée par les marques de biens de consommation. Nous proposons une solution globale de gestion de la croissance du chiffre d'affaires, comprenant des fonctionnalités pour la gestion des prix (TPM), la gestion des offres (TPO), la planification intégrée des stocks (IBP) et la gestion de la croissance du chiffre d'affaires (RGM). Notre mission est de donner aux marques les moyens d'optimiser leurs performances en matière de chiffre d'affaires et le retour sur investissement de leurs actions commerciales grâce à un logiciel intelligent et collaboratif, offrant une source unique de données fiables, une automatisation rationalisée et des informations exploitables.
La plateforme Blue RGM Intelligence prend en charge l'ensemble des processus de gestion des revenus, du brut au net : planification opérationnelle annuelle, planification des comptes et exécution. Les solutions s'appuient sur l'analyse de données, l'intelligence artificielle et la gestion des données, qui permettent de relier les équipes et les systèmes d'entreprise.
Nous sommes là pour vous aider.
[email protected]
