Worker turnover rate in the supermarket and grocery stores industry in New Zealand
2013 Q1–2023 Q1, % of total jobs
Quarter | % of total jobs |
---|---|
2013 Q1 | 12.1% |
2013 Q2 | 13.2% |
2013 Q3 | 10.7% |
2013 Q4 | 11.6% |
2014 Q1 | 12.7% |
2014 Q2 | 14.9% |
2014 Q3 | 12.3% |
2014 Q4 | 12.8% |
2015 Q1 | 13.1% |
2015 Q2 | 13.9% |
2015 Q3 | 11.2% |
2015 Q4 | 13.4% |
2016 Q1 | 13.8% |
2016 Q2 | 13.5% |
2016 Q3 | 12.5% |
2016 Q4 | 13.8% |
2017 Q1 | 15.5% |
2017 Q2 | 14.1% |
2017 Q3 | 11.9% |
2017 Q4 | 13.7% |
2018 Q1 | 14.9% |
2018 Q2 | 15.1% |
2018 Q3 | 12.1% |
2018 Q4 | 13.7% |
2019 Q1 | 15.6% |
2019 Q2 | 14.7% |
2019 Q3 | 12.5% |
2019 Q4 | 13.7% |
2020 Q1 | 14.7% |
2020 Q2 | 14.3% |
2020 Q3 | 8.9% |
2020 Q4 | 10.8% |
2021 Q1 | 12.9% |
2021 Q2 | 13.8% |
2021 Q3 | 14.6% |
2021 Q4 | 14.4% |
2022 Q1 | 18.3% |
2022 Q2 | 17.6% |
2022 Q3 | 15.1% |
2022 Q4 | 16% |
2023 Q1 | 16.5% |
Definitions
Job: a unique employer-employee pair present on an EMS in the reference quarter.
Full-quarter jobs: jobs that exist continuously over the reference quarter.
Total filled jobs: The number of jobs (defined as an employer-employee match) on the 15th of the middle month of the reference quarter. Does not distinguish between part-time and full-time jobs.
Accessions: The number of employees who have joined employers since the previous reference date.
Separations: The number of employees who have left employers since the previous reference date.
Worker turnover rate: The ratio of the average of the total accessions and separations to the average of the total jobs in the reference quarter (t) and the previous quarter (t-1), as represented in the formula:
[ (accessions + separations)/2 ] / [ (jobs(t) + jobs(t-1))/2 ].
Job creation: The number of jobs created, since the previous reference date, when businesses expand or start up. For example, a business employing 100 workers with 10 accessions and five separations has job creation of five.
Job destruction: The number of jobs lost, since the previous reference date, when businesses contract or shut down. For example, a business employing 100 workers with five accessions and 15 separations has job destruction of 10.
Job turnover rate: The ratio of the average of the total creations and destructions to the average of the total jobs in the reference quarter (t) and the previous quarter (t-1), as represented in the formula:
[ (creation + destruction)/2 ] / [ (jobs(t) + jobs(t-1))/2 ].
Mean/median earnings: Mean (average) or median earnings of all full-quarter jobs.
Mean/median earnings for continuing jobs: Mean (average) or median earnings for jobs that were full-quarter in the reference quarter and previous quarters.
Mean/median earnings for new hires: Mean (average) or median earnings for jobs that were full-quarter in the reference quarter and began sometime in the previous quarter, but were not present in the four previous quarters.
Mean/median earnings ratio: The ratio of the mean or median earnings for new hires to the mean or median earnings for continuing jobs.
Total earnings: The sum of all earnings paid in the reference quarter, including employees with invalid IRD identifiers and individuals under 15 years of age.
For more information
Inclusions
LEED covers all individuals (‘employees’) who receive income from which tax is deducted at source. These payments are made by organisations that are registered with Inland Revenue. Note that the data from LEED includes social assistance payments, such as paid parental leave, student allowances, benefits, pensions, and Accident Compensation Corporation payments, although these are excluded from the quarterly measures.
The fundamental basis of the LEED quarterly measures is ‘jobs’.
For inclusion in the LEED quarterly statistics, the job must:
- relate to a person 15 years of age and over
- have PAYE tax deducted at source
- be in relation to ‘paid employment’ rather than a social assistance payment
- have a valid IRD identifier.
An exception is the total earnings measure, which includes all jobs with PAYE tax deducted at source (irrespective of age and IRD identifier) apart from those relating to social assistance payments.
All the earnings measures represent quarterly earnings inclusive of tax. They include payments reported as lump sums to Inland Revenue.
Data provided by
Dataset name
Linked Employer-Employee Dataset: LEED measures by industry (based on ANZSIC06) March 2023 quarter
Webpage:
How to find the data
Data is displayed at URL provided. All variables were selected to create this dataset. Duplicate industries were removed prior to import.
Import & extraction details
File as imported: Linked Employer-Employee Dataset: LEED measures by industry (based on ANZSIC06) March 2023 quarter
From the dataset Linked Employer-Employee Dataset: LEED measures by industry (based on ANZSIC06) March 2023 quarter, this data was extracted:
- Rows: 2-335,116
- Column: 11
- Provided: 335,115 data points
This data forms the table Jobs - All LEED measures by detailed industry 1999 Q2–2023 Q1.
Dataset originally released on:
July 26, 2024
About this dataset
The LEED dataset is created by linking a longitudinal employer series from the Stats NZ Business Register to a longitudinal series of EMS payroll data from Inland Revenue.
Purpose of collection
Official quarterly statistics produced from LEED measure labour market dynamics at various levels – including industry, region, territorial authority, firm size, sector, sex, and age – providing an insight into the operation of New Zealand's labour market. Stats NZ releases other official labour market statistics that show changes in employment at an aggregate level. Statistics from LEED, such as job and worker flows, help to explain what causes these aggregate movements and are therefore useful for explaining changes in the labour market.