Short description

Explanation of short description

Sales volume in 100 kg

Sales to consumers in equivalised units

 

Sales in 100 EANs

Sales to consumers in selling units

 

Sales value in DKK1000

Sales in value (incl. VAT) to consumers

 

Price per kilo

The price (incl. VAT) paid by the consumer per equivalised unit

 

Price per EAN

The price in kroner (incl. VAT) paid by the consumer per selling unit

 

Average weight per EAN

The average weight per selling unit in grams, millilitres etc.

 

 

Sales in kg per weighted distribution point and Sales in equivalised units per weighted distribution point should be used cautiously if the weighted distribution of the product is low (under 20).

The example below relates to the dictionary EFSTAND. This dictionary can be used for all reports, regardless of the period and the unit into which data are converted.

 

Short description

Explanation of short description

Volume share

The volume share is calculated on the basis of sales of Product #1 in the report, i.e. the total market in the report.

Volume share of segment




The share of the total volume sold of a specific segment accounted for by the product selected. You can define your own segment by cumulating a number of products of your choice in the report. Alternatively you can choose a pre-defined segment, if available in the report.

Volume share of selling









The share of the sales volume of the total market (Product #1) in shops selling the selected product accounted for by that product. As weighted distribution is included in the formula, and as weighted distribution is based on the percentage of total value sales of the product class accounted for by the individual shop, the formula should be used with great care if the weighted distribution of the product is low (i.e. under 20), especially if the price of the product is relatively low. Do not use the CUM or ROLL function with this formula.

Value share

The value share is calculated on the basis of sales of Product #1 in the report, i.e. the total market in the report.

Value share of segment



The share of value sales of a specific segment accounted for by the product selected. You can define your own segment by cumulating a number of products of your choice in the report. Alternatively you can choose a pre-defined segment, if available in the report.


 

Short description

Explanation of short description

Value share of selling





The share of value sales of the total market (Product #1) in shops selling the selected product accounted for by that product. The formula should be used with great care if the weighted distribution of the product is low (i.e. under 20), especially if the price of the product is relatively low. Do not use the CUM or ROLL function with this formula.

Numeric selling distribution








Numeric selling distribution is calculated on the basis of whether the product selected was sold by the individual shops during a specific week. In four-weekly reports numeric selling distribution is the average for the four weeks making up the period in question. If you cumulate two or more periods, this custom item will calculate the same type of average as above. You should never cumulate two or more products if you wish to know their total distribution: the resulting figures will merely be averages instead of showing the actual total distribution of the products.

Weighted selling distribution












Weighted selling distribution is based on the percentage of total value sales of the product class accounted for by the individual shop selling the product class.

Weighted selling distribution is calculated on the basis of whether the product selected was sold by the individual shops during a specific week. In four-weekly reports weighted selling distribution is the average for the four weeks making up the period in question. If you cumulate two or more periods, this custom item will calculate the same type of average as above. You should never cumulate two or more products if you wish to know their total distribution: the resulting figures will merely be averages instead of showing the actual total distribution of the products.

Chain share of grocery trade volume

The percentage of the sales volume in the grocery trade of the product class or of a particular product accounted for by a specific chain/market split.

Chain share of grocery trade value

The percentage of the value sales in the grocery trade of the product class or of a particular product accounted for by a specific chain/ market split.


 

Short description

Explanation of short description

Contrib. to share of grocery trade vol.



Contributions to share of grocery trade volume: Shows how the total share of volume breaks down on the chains/market splits in the report. The share of volume is calculated on the basis of sales in the grocery trade of Product #1 in the report, i.e. the total market in the report.

Contr. to sh. of groc. tr. vol. of segm.




Contributions to share of grocery trade volume of segment: Shows how the total share of volume breaks down on the chains/market splits in the report. The share of volume is calculated on the basis of total sales in the grocery trade of a specific segment. You can define your own segment by cumulating a number of products of your choice in the report. Alternatively you can choose a pre-defined segment, if available in the report.

Contrib. to share of grocery trade val.


Contribution to share of grocery trade value: Shows how the total share of value breaks down on the chains/market splits in the report. The share of value is calculated on the basis of sales in the grocery trade of Product #1 in the report, i.e. the total market in the report.

Contr. To sh. of groc. tr. val. of segm.




Contributions to share of grocery trade value of segment: Shows how the total share of value breaks down on the chains/market splits in the report. The share of value is calculated on the basis of total sales in the grocery trade of a specific segment. You can define your own segment by cumulating a number of products of your choice in the report. Alternatively you can choose a pre-defined segment, if available in the report.

Percentage change in vol. on last period


Percentage change in volume on last period: The percentage change in the share of the sales volume of the total market (Product #1) accounted for by the selected product compared to the last period.

Percentage change in val. share on last period

Percentage change in value share on last period: The percentage change in the share of value sales of the total market accounted for by the selected product (Product #1) compared to the last period.

Price index for product class

The price of the selected product in relation to the total market (Product #1), an equivalised price stated as an index number.


 

Short description

Explanation of short description

Relative price per EAN


The price (as an index number) of the selected product compared to a product of your choice. The price used in the calculation is the price per EAN (selling unit).

Relative price per equivalised unit

The price (as an index number) of the selected product compared to a product of your choice. The price used in the calculation is the price per equivalised unit.

Relative sales volume per EAN

The sales volume (as an index number) of the selected product compared to a product of your choice. The calculation is based on sales per EAN (selling unit).

Relative sales volume per equiv. unit

Relative sales volume per equivalised unit: The sales volume (as an index number) of the product selected compared to a product of your choice. The calculation is based on sales per equivalised unit.

Cost (in DKK 1000) of lost distribution

Shows the potential increase in the sales value of the selected product if its distribution is increased to the level of a product or total of your choice.

 

 

The last example relates to the three dictionaries with the designations EP4WEEK, EPWEEK and EPMAN, as the case may be. These dictionaries may be used for all reports of four weekly, weekly and monthly data, respectively, regardless of the unit into which data are converted.

 

 

Short description

Explanation of short description

Volume trend

The change in sales volume (as a percentage) compared to the corresponding period of the previous year.

Value trend

The change in sales value (as a percentage) compared to the corresponding period of the previous year.

Price trend (equivalised units)


Price trend based on equivalised units: The change in the price per equivalised unit (as a percentage) compared to the corresponding period of the previous year.


 

Short description

Explanation of short description

Year to date 2000


Totals for the periods of the current year  including the last period for which data has been reported.  This custom item is updated once a year.  

Whole year 1999



Totals for the periods of which 1999 consists. As some years have 53 weeks and we operate with a year consisting of 52 weeks, the periods for which data is reported do not always coincide with the calendar year. Data reported for 1999 thus relates to the period from Week 03, 1999 to Week 02, 2000.

Whole year 1998




Totals for the periods of which 1998 consists. As some years have 53 weeks and we operate with a year consisting of 52 weeks, the periods for which data is reported do not always coincide with the calendar year. Data reported for 1998 thus relates to the period from Week 04, 1998 to Week 02, 1999.

Moving annual total year ago


Totals for the 52 weeks up to and including the period of the previous year which corresponds to the last period for which data has been reported in the current year.

Moving annual total last period

Totals for the last 52 weeks up to and including the last period for which data has been reported in the current year.

Year to date 1999

Totals for the periods of the current year up to and including the last period for which data has been reported. This custom item is updated once a year.

Year to date 1998


Totals for the periods of the current year up to and including the last period for which data has been reported. This custom item is updated once a year.