Calculating Retail Business Data
Why Maths Matters in Retail
Every retail business handles numbers daily — from working out how much profit a product makes to tracking how many customers walk through the door. Being able to calculate and interpret these figures is an essential skill for anyone working in retail. This lesson covers the core mathematical techniques you need: percentages, averages, profit, mark-up and footfall. For each one you will see the formula and a straightforward worked example using realistic retail figures.
Percentages and Percentage Change
A percentage expresses one number as a fraction of another out of 100. To find what percentage one value is of another, divide the part by the whole and multiply by 100.
Formula: Percentage = (Part ÷ Whole) × 100
Worked example: A clothing store sells 40 jackets out of a total stock of 160 items. What percentage of stock are jackets? (40 ÷ 160) × 100 = 25%. Jackets make up 25% of total stock.
Percentage change shows how much a figure has risen or fallen compared with its original value.
Formula: Percentage change = ((New value − Original value) ÷ Original value) × 100
Worked example: A supermarket’s weekly sales were £8,000 last month and £10,000 this month. Percentage change = ((10,000 − 8,000) ÷ 8,000) × 100 = (2,000 ÷ 8,000) × 100 = 25%. Sales have increased by 25%. A negative result means a decrease.
Fractions and Ratios
Fractions are used to express part of a whole (e.g. ½ of stock sold). Ratios compare two or more quantities directly and are often used to describe the split between values such as online versus in-store sales.
Worked example: A retailer makes 300 sales in a week — 200 in-store and 100 online. The ratio of in-store to online sales is 200:100. Simplify by dividing both numbers by 100, giving a ratio of 2:1. This means two sales are made in-store for every one made online. Ratios are always simplified to their lowest whole numbers.
Percentage = (Part ÷ Whole) × 100. Percentage change = ((New − Original) ÷ Original) × 100. A positive result is an increase; a negative result is a decrease. Always read the question carefully to identify which number is the “original” (the starting point).
Averages: Mean, Median and Mode
Retail businesses use averages to summarise large sets of data — for example, average daily sales or average transaction value. There are three types of average to know.
Mean — add all the values together and divide by how many there are. This is the most commonly used average in retail data.
Worked example: A convenience store’s daily sales for five days were: £420, £380, £510, £460, £430. Mean = (420 + 380 + 510 + 460 + 430) ÷ 5 = 2,200 ÷ 5 = £440.
Median — arrange the values in order from smallest to largest; the median is the middle value. If there is an even number of values, find the mean of the two middle numbers.
Worked example: Using the same five figures in order: £380, £420, £430, £460, £510. The middle value is the third number: £430. The median daily sales figure is £430.
Mode — the value that appears most often. The mode is useful for identifying the most common price point or best-selling product.
Worked example: A sports retailer sells trainers in sizes 6, 7, 8, 8, 9, 8, 10. The mode (most frequent) is size 8. The retailer knows to stock more of that size.
Mean = sum of all values ÷ number of values. Median = middle value when data are ordered (or mean of the two middle values for an even set). Mode = the most frequently occurring value. All three are valid “averages” — the exam may ask for a specific one, so read the question carefully.
Profit
Profit is the money a business keeps after paying all its costs. It is one of the most important measures of business performance.
Formula: Profit = Revenue − Costs
Worked example: A gift shop earns £15,000 in sales revenue in one month. Its total costs (rent, wages, stock, utilities) are £11,500. Profit = £15,000 − £11,500 = £3,500. If costs were higher than revenue the result would be negative, meaning a loss.
Although the exam focuses on the basic profit formula, it is helpful to understand the difference. Gross profit is revenue minus the direct cost of the goods sold (the cost of buying in the stock). Net profit then subtracts all other operating costs — rent, wages, utilities and so on — from the gross profit. For the purposes of this qualification, “profit” typically refers to net profit: total revenue minus total costs. Always use the formula given in the question if one is provided.
Percentage Profit Margin
The percentage profit margin shows how profitable a business is relative to its sales. It allows fair comparison between businesses of different sizes.
Formula: Percentage profit margin = (Profit ÷ Revenue) × 100
Worked example: Using the gift shop above: profit = £3,500 and revenue = £15,000. Percentage profit margin = (3,500 ÷ 15,000) × 100 = 23.3% (rounded to one decimal place). This means the business keeps approximately 23p of every £1 of sales as profit.
Mark-Up
Mark-up is the amount added to the cost price of a product to set its selling price. It is expressed as a percentage of the cost price (unlike profit margin, which uses revenue as the base).
Formula: Mark-up (%) = ((Selling price − Cost price) ÷ Cost price) × 100
Worked example: A bookshop buys a novel for £5 (cost price) and sells it for £8 (selling price). Mark-up = ((8 − 5) ÷ 5) × 100 = (3 ÷ 5) × 100 = 60%. The bookshop has marked up the product by 60% on cost. Retailers use mark-up to help cover costs and make a gross profit on each item sold.
Both figures measure profitability on a single product, but they use a different base number in the calculation. Mark-up divides the profit by the cost price; percentage profit margin divides the profit by the selling price (revenue). Using the bookshop example: selling price £8, cost price £5, profit £3. Mark-up = (3 ÷ 5) × 100 = 60%. Profit margin = (3 ÷ 8) × 100 = 37.5%. Mark-up will always give a higher percentage than profit margin for the same product. Knowing which formula to use depends on what the question asks.
Sales and Footfall Calculations
Sales revenue is the total income a business receives from selling goods or services. Footfall measures how many customers enter a store in a given period. Both are key performance indicators in retail.
Sales revenue formula: Sales revenue = Price per unit × Number of units sold
Worked example: A pharmacy sells 250 bottles of shampoo at £4 each. Sales revenue = £4 × 250 = £1,000.
Conversion rate formula: Conversion rate (%) = (Number of sales ÷ Footfall) × 100
Worked example: On Saturday 800 customers entered a fashion store and 120 made a purchase. Conversion rate = (120 ÷ 800) × 100 = 15%. Only 15% of visitors converted to buyers, which might prompt the manager to investigate pricing or product range.