KPI Calculations - Sales Out

This guide shows you how the Key Performance Indicators are calculated for Sales Out Promotions.

This guide is only of relevance if you have the promotion module in effectmanager. 

Some of the Key Performance Indicators, in effectmanager, are based on how the subsidy calculation is set in the Promotion's General Tab. 

If you are looking for a guide that shows you how KPIs are calculated, for Sales In promotions, please see our guide KPI Calculations - Sales In

Below we will go through the KPIs for Promotions where the subsidy is based on Sales Out in effectmanager.

We will go through the KPIs in the following Promotion Reports:

Subsidy Calculations_Sales out 1.0

KPIs in the Promotion Supplier Finance Report

KPIs in the Promotion Finance Report is divided into Baseline KPIs and Promotion KPIs.

If you need a guide that shows you how to find your promotion's Finance report, please see our guide Promotion's Supplier Finance Report

Finance Report Sales Out 1.2

Baseline KPIs are used for calculating your promotion's Opportunity Cost and Volume lift

effectmanager can make an automatic calculation of your Baseline, or you can manually upload your Baseline's Sales figures to effectmanager.

If you need a guide that shows you how to upload Baseline to effectmanager, please see our guide How to upload Baseline.  

Baseline KPIs 1.2

Promotion KPIs are used for calculating all your promotion's finance. 
For Sales Out promotions, the Unit subsidy and Percent Subsidy calculations are based on Actual Sales Out during the promotion period. 

👍Pro-tip: Make sure all your prices are updated, to have your promotion finance calculated correctly. 

FINANCE KPIs - Sales Out 1.1

Download an example of the KPIs used for the Promotion's Finance Report

KPIs in the Promotion Supplier P&L

Go to the top of the article

Key Measures for the Promotion P&L shows both Total P&L and Product Group P&L but uses the same calculations. In the example below, we only have one Product Group on the promotion, and therefore the Total P&L equals the Product Group P&L. 

If you need a guide that shows you how to find your promotion's P&L report, please see our guide Promotion's supplier P&L report

👍Pro-tip: NS/L is mapped to the Promotion based on a match on Period, Chain, and Internal Number.

P&L Sales Out 1.1P&L Key Measure in effectmanager P&L KPIs 1.4

P&L Product KPIs 1.1

KPIs in the Promotion Supplier P&L (Sales Out)

Go to the top of the article

KPIs in the Promotion P&L Sales Out Report is divided into YOUR KPIs and Chain KPIs. Below we will go through the KPIs in the report.

KPIs, where Sales In might be used for calculations, will be marked with red in the KPI overviews. 

🔴OBS! If your Subsidy Calculations in Promotion Editor is set to Sales In. Then Sales In figures will be used for this calculation in the P&L Sales Out. 

If you need a guide that shows you how to find your promotion's Finance report, please see our guide Promotion's Supplier Finance Report

YOUR KPIs will provide you with financial insights such as Gross Turnover, Invoiced Turnover, and Net Turnover - based on this you will also see your Share of Net Turnover.
See Calculations

CHAIN KPIs will provide you with the Chain's Financial statement for the promotion.
See Calculations

👍Pro-tip: All this financial information can be used for evaluating your promotions at planned and confirmed stages, so see what you pay in Trade Spend. At the completed stage this financial information helps you evaluate your promotions. 

P&L Sales Out 3.0

YOUR - P&L (Sales Out) Key Measure in effectmanager

P&L (Sales Out) KPI - Sales Out 1.3

CHAIN - P&L (Sales Out) Key Measure in effectmanager

P&L (Sales Out)CHAIN KPI - Sales Out 1.2

Download our printer-friendly guide here