Calculating and Interpreting Human Resource Data (AQA A Level Business): Revision Note

Exam code: 7132

Steve Vorster

Written by: Steve Vorster

Reviewed by: Lisa Eades

Updated on

Using data to make HR decisions

  • Businesses collect and analyse HR data to make informed decisions that help improve performance, reduce costs, and plan for future workforce needs

Why HR data matters

Diagram showing uses of HR data: identifying problems, planning ahead, controlling costs, and improving performance, connected to a central circle.
Human resource data helps managers to be more effective
  • Identify problems

    • High labour turnover or rising costs may indicate poor working conditions, low morale or training gaps

  • Plan ahead

    • Workforce data informs recruitment, training, succession planning, and budgeting

  • Improve performance

    • Tracking productivity or absenteeism helps managers take action to boost efficiency

  • Control costs

    • Monitoring labour cost per unit and employee costs as a percentage of turnover helps businesses stay competitive

Strategic workforce planning

  • Data-driven planning helps ensure the business has the right number of people, with the right skills, in the right roles. For example:

    • A retailer planning to open new stores can use HR data to forecast how many staff it will need and how much it will cost

    • A manufacturer may use productivity data to decide whether it needs to recruit more staff or invest in automation

  • Good HR planning based on reliable data supports long-term business success and helps avoid costly mistakes like overstaffing or skill shortages

Labour turnover

  • Labour turnover measures the proportion of employees leaving a business during a specific time period

  • It is expressed as a percentage and is calculated using the formula

Labour space turnover space equals space fraction numerator Number space of space staff space leaving space cross times space 100 over denominator Average space number space of space staff end fraction

Internal and external factors that affect labour turnover

  • A rising rate of labour turnover can signal internal human resource management problems such as

    • Poor management leading to workers losing commitment

    • A poor recruitment and selection approach leading to staff leaving soon after starting their job

    • Low wage levels compared to those that could be earned elsewhere

  • External factors can also increase labour turnover in a business

    • A buoyant local economy where workers are attracted to employment opportunities elsewhere 

    • Improved transport links that provide an opportunity for workers to seek work across a wider geographical area

The consequences of high labour turnover

Problems

Opportunities

  • Increased recruitment and selection costs

  • Increased induction and training costs

  • Lower productivity levels as workers settle into new roles

  • Workers with existing skills can be recruited to reduce the need for training

  • New ideas and creativity introduced to the business

  • New perspective and approaches to problem-solving can improve business performance

Worked Example

In 2022, Domus Construction Ltd employed 7,200 workers, six percent of whom worked at the head office.

During 2022, fifty-four head office employees left the business.

Calculate the labour turnover of Domus Construction's head office in 2022.

[3]

Step 1 - Calculate the number of head office workers

0.06 space space space cross times space space space 7 comma 200 space space space space space space equals space space space space space space 432 space workers    (1)

Step 2 - Apply the labour turnover formula

Labour space Turnover space equals fraction numerator Number space of space Staff space Leaving over denominator Total space Number space of space Staff end fraction space space cross times space 100

Labour space Turnover space equals 54 over 432 space space equals space 0.125 space cross times space 100 space equals space 12.5 percent sign space (2)

Labour productivity

  • Labour productivity measures output per worker during a specified period of time

    • It is expressed as a number of units and calculated using the formula

      Labour space productivity space equals space fraction numerator Output over denominator Number space of space workers end fraction

  • Businesses aim to increase the level of labour productivity to improve competitiveness

Higher labour productivity improves businesses competitiveness
Higher labour productivity improves businesses competitiveness

Worked Example

The table shows the number of pairs of luxury wool socks produced by Sock Mania in 2023 and 2024

Year

Units Produced

2023

46,000

2024

69,000

In 2023 Sock Mania employed 50 staff. In 2024 the number of staff employed by the business increased by 20%

Calculate the percentage change in labour productivity between 2021 and 2022.

[4]

Step 1 - Calculate the labour productivity for 2023

equals space fraction numerator 46 comma 000 space units over denominator 50 space workers end fraction space space space space space

equals space 920 space units space per space worker space     (1)      

 Step 2 - Calculate the labour productivity for 2024

equals space fraction numerator space 69 comma 000 space units over denominator space 60 space workers end fraction space space space space space

equals space 1 comma 150 space units space per space worker space space    (1)      

Step 3 - Calculate the percentage difference between the two years ((new-old) / old)

equals space fraction numerator space 1 comma 150 space minus space 920 space units over denominator 920 space units end fraction space space space cross times space space space space space 100 space space space

equals space 25 space percent sign space    (1)      

Step 4 - Identify whether the percentage difference is an increase or decrease

  • Labour productivity has increased by 25%     (1 mark)

Employee costs as a percentage of turnover

  • This metric shows how much of a business’s revenue is spent on paying employees

    • It helps assess how efficiently the workforce is being used

  • It is calculated using the formula:

Employee space costs space as space percent sign space of space turnover equals space fraction numerator Employee space costs over denominator Turnover end fraction space straight x space 100

Worked Example

In the 2022–2023 financial year, Tesla had:

  • Revenue = £5,297 million

  • Employee costs = £2,894 million

Calculate the employee costs as a % of turnover between 2022 and 2023.

[2]

Step 1 - Substitute the values into the formula

Employee space costs space as space straight a space percent sign space of space turnover space equals space fraction numerator Employee space costs over denominator Turnover end fraction space straight x space 100
equals fraction numerator space 2 comma 894 space million over denominator 5 comma 297 space million end fraction space straight x space 100    (1)      

Step 2 - Present the final answer

  • 54.6% of turnover was spent paying staff    (1)      

Labour cost per unit

  • Labour cost per unit measures how much it costs in wages to produce one unit of output

    • It is a key piece of data to assist with pricing and cost control decisions

  • It is calculated using the formula:

Labour space cost space per space unit equals space space fraction numerator Number space of space units space produced ​ space over denominator Total space weekly space wages space end fraction space

Worked Example

Assume each employee is paid £250 per week.

Number of employees

Total weekly wages (£)

Output (number of units)

Labour productivity (units per employee)

Labour cost per unit (£)

80

20,000

800

10

£25

100

2,500

25

40

10,000

1,200

30

£8.33

60

15,000

1,000

16.67

£15

Calculate the labour cost per unit when there are 100 employees.

[2]

Step 1 - Calculate total weekly wages for 100 employees

Total weekly wages = 100 × £250

= £25,000    (1)      

Step 2 - Calculate the labour cost per unit

Labour space cost space per space unit space equals space fraction numerator 2 comma 500 over denominator 25000 end fraction
equals space £ 10 space per space unit     (1)      

Influences on employee costs as a percentage of turnover

  1. Wage levels and contracts

    • High wages, overtime pay or generous bonuses will raise employee costs

  2. Productivity

    • More productive staff reduce the cost per unit and lower the ratio

  3. Technology

    • Automation can reduce the need for labour, cutting costs

  4. Industry type

    • Labour-intensive industries like hospitality usually have higher employee costs than capital-intensive ones like manufacturing

  5. Revenue performance

    • A fall in revenue (e.g. due to low demand) makes employee costs look higher, even if wages haven’t changed

Examples of how HR data supports decision-making

  • Labour turnover

    • High staff turnover might lead a business to invest in better training, improve management, or raise pay to improve retention

      • For example, in 2022, NHS England faced high nurse turnover. It responded with improved retention schemes, including flexible working, leadership development, and mentorship programmes

  • Labour productivity

    • Falling productivity could trigger a review of equipment, working conditions, or staff training needs

      • For example, Royal Mail invested in automated parcel sorting and upskilled employees in response to falling productivity during peak online shopping seasons

  • Labour cost per unit

    • Rising labour costs may push a business to automate processes or reallocate staff more efficiently

      • For example, Greggs introduced more self-serve tills and centralised some baking operations to reduce labour costs per unit across stores

  • Employee costs as % of turnover

    • If employee costs are growing faster than revenue, the business may need to restructure or freeze recruitment

      • For example, Marks & Spencer faced rising wage costs and declining revenues in some departments. It responded by closing underperforming stores and streamlining staff roles

You've read 0 of your 5 free revision notes this week

Unlock more, it's free!

Join the 100,000+ Students that ❤️ Save My Exams

the (exam) results speak for themselves:

Did this page help you?

Steve Vorster

Author: Steve Vorster

Expertise: Economics & Business Subject Lead

Steve has taught A Level, GCSE, IGCSE Business and Economics - as well as IBDP Economics and Business Management. He is an IBDP Examiner and IGCSE textbook author. His students regularly achieve 90-100% in their final exams. Steve has been the Assistant Head of Sixth Form for a school in Devon, and Head of Economics at the world's largest International school in Singapore. He loves to create resources which speed up student learning and are easily accessible by all.

Lisa Eades

Reviewer: Lisa Eades

Expertise: Business Content Creator

Lisa has taught A Level, GCSE, BTEC and IBDP Business for over 20 years and is a senior Examiner for Edexcel. Lisa has been a successful Head of Department in Kent and has offered private Business tuition to students across the UK. Lisa loves to create imaginative and accessible resources which engage learners and build their passion for the subject.