Basis of reporting
Our basis of reporting outlines the reporting period, entities covered, and the scope and quality of the data.
Reporting period and data collection procedures
This health report (the 'Report') includes volume and revenue data for PepsiCo products sold in the UK & Ireland by our four businesses: Walkers, Juice, Quaker and Beverages ("Franchise"). The majority of data and information covers the period January 2008 to December 2008. Data reviewed as part of the external assurance cover January 2008 to December 2008.
The financial data for this Report is collected once a year at the end of the financial year. The Planning teams for each one of the businesses will consolidate the volume and revenue data for the latest financial year, with volume and gross revenue detail by SKU (stock keeping unit). SKUs represent larger collations of our individual packets, cartons or other servings - for example a pallet containing a number of multipacks. The Corporate Planning team collects the data from the planning teams and combines it with the nutritional data to produce the KPIs and data analysis included in this Report.
The nutrition information in the database is derived from formula recipe datasheets. The origin of these data varies according to brand but values are derived from either a) chemical analysis of the product itself either in-house or commissioned from an independent laboratory or b) published food tables or c) calculation based on analytical data on ingredients. Nutritional values are updated as recipes are adapted. The data in this Report covers the nutritional profiles of the products in our portfolio as they were at January 2008, and does not take account of any reformulation carried out during that year.
Scope of data
The Corporate Planning team collects the annual top line data by SKU from the planning teams around February - March. The data are provided in excel spreadsheets. The data are kept by each one of the businesses in separate databases (Business Objects is the key database for Walkers, Juice and Quaker) which are managed by the Planning teams and Sales force, and maintained by the IT function.
Separately the PepsiCo UK Nutrition team provides nutritional information on several measures for each flavour sold by the company (i.e. Walkers Ready Salted crisps, Tropicana Orange Original with juicy bits, Snack a Jacks Crispy Cheese, Pepsi Max) for the equivalent time period.
In order to combine the SKU information (e.g. '87749: 14-bag multipack display) with the nutritional information (e.g. fat level/serving or salt level/serving by flavour) further data treatment needs to take place so we can translate the SKU information into detail by flavour.
For example, a "14-bag multipack display" SKU actually contains 96 x 14 bags of 25g each. Each set of 14 bags further breaks down into 4 bags of Ready Salted crisps, 3 bags of Roast Chicken, 3 bags of Smoky Bacon and 4 bags of Steak and Onion - each with a slightly different nutritional profile. This is particularly relevant for the Walkers data given the size of the portfolio (almost 400 SKUs in 2008) as well as the variety and complexity of what goes into these SKUs.
Significant work was done for the purpose of this Report, which can be used for the next Report. However, new SKUs have been launched in 2009 so further data analysis will be needed for these in future. Some analysis was also needed for the Juice, Quaker and Franchise businesses.
The products / brands included in each business are:
- Walkers: includes all the crisps and snacks sold by Walkers (Walkers Core, Doritos, Baked, Nobby's Nuts, French Fries, Monster Munch, Max, Quavers, Sensations, Squares, SunBites, Wotsits)
- Juice: Tropicana, Copella, PJs and Naked. PJs was delisted in 2008 so it will not be included in our future reporting
- Quaker: Cereals - Oat So Simple, Quaker Cereal, Scott's Porage, Oat bars; CCRS (crackers, crisp bread, rice and salty): Snack a Jacks and Seasons
- Franchise (Beverages): Pepsi and 7-UP varieties
The Franchise nature of part of the business, where we supply concentrate mixes to our bottler Britvic Soft Drinks plc, means we do not have access to equivalent financial data. We have therefore used volume data on several portfolio-wide metrics.
Excluded products
A small proportion of our UK products (for example 4% of our Walkers sales revenue) are distributed through a variety of retail and other channels (for example, the charity FareShare) towards the end of their shelf life. It is not possible to provide nutritional data on these products, and they have not been included in our analysis.
There is a small number of other products for which nutritional information is not available for the full calendar year - for example, those introduced to or withdrawn from the UK market during the data period (2008):
- Tropicana Spirit, which accounted for 0.84% of our Juice portfolio volume
- V Water, Lipton Ice Tea and Gatorade. Together, the volume sold in 2008 from these three brands made up 1.75% of our Franchise volume.
Quality of the data
The volume and gross revenue data provided by the Planning teams and included in this Report are the official 2008 data that were audited and consolidated into the PepsiCo Global Profit and Loss accounts and annual reports.
Comparability of data in future years will be impacted by:
- Products which have been delisted
- New products coming to the market
- Evolution of the nutritional information i.e. where products are reformulated to be lower in nutrients such as sodium, saturated fat
We will evolve our processes to incorporate these changes.
For a detailed explanation of our data definitions, collection methods, and basis of calculation please download a PDF of the Key data table here.
Download PepsiCo Health Report Key data (343KB, pdf)
Criteria and definitions - other key pledges
Download a PDF of the Criteria and definitions - other key pledges table from the Health Report 2010.
Follow Us