-75%
Awaiting product image
Click to enlarge

(Solution) CIPD Avado SECTION 2 1.4 Data Analysis

New User Gifts

First Order Deal get Ksh 200 Off.

KaribuCustomer

Original price was: £ 40.00.Current price is: £ 10.00.

Payment Methods:

Description

Solution

SECTION 2

1.4 Data Analysis

To calculate the percentage turnover for each department, I used the formula:

Turnover Percentage= (Total Employees/Leavers​) ×100

2020

  • Administration: 4/22×100=18.2%
  • Maintenance: 5/9×100=55.6%
  • Marketing: 0/4×100=0%
  • Production: 70/231×100=30.3%
  • People Team: 1/6×100=16.7%
  • Research & Design: 1/4×100=25%
  • Sales: 19/42×100=45.2%
  • Packing & Dispatch: 21/36×100=58.3%
  • Finance: 2/5×100=40%

2021

  • Administration: 8/20×100=40%
  • Maintenance: 3/8×100=37.5%
  • Marketing: 0/4×100=0%
  • Production: 3/2198×100=16.2%
  • People Team: 0/6×100=0%
  • Research & Design: 0/3×100=0%
  • Sales: 3/35×100=8.6%
  • Packing & Despatch: 6/15×100=40%
  • Finance: 0/4×100=0%

2022

  • Administration: 9/20×100=45%
  • Maintenance: 3/8×100=37.5%
  • Marketing: 1/4×100=25%
  • Production: 3/8178×100=21.3%
  • People Team: 3/6×100=50%
  • Research & Design: 0/4×100=0%
  • Sales: 0/40×100=0%
  • Packing & Despatch: 8/16×100=50%
  • Finance: 0/4×100=0%

2023

  • Administration: 2/18×100=11.1%
  • Maintenance: 1/7×100=14.3%
  • Marketing: 0/4×100=0%
  • Production: 29/181×100=16%
  • People Team: 2/5×100=40%
  • Research & Design: 1/4×100=25%
  • Sales: 2/45×100=4.4%
  • Packing & Despatch: 3/15×100=20%
  • Finance: 0/3×100=0%

To calculate the overall turnover rate for the entire organization each year, we sum the total number of leavers and total employees, then apply the turnover formula:

Overall Turnover Percentage= (Total Employees/Total Leavers​) ×100

2020:

  • Total employees = 359
  • Total leavers = 123
  • Turnover: 123359×100=34.3%

2021:

  • Total employees = 285
  • Total leavers = 52
  • Turnover: 52285×100=18.2%

2022:

  • Total employees = 275
  • Total leavers = 62
  • Turnover: 62275×100=22.5%

2023:

  • Total employees = 282
  • Total leavers = 40
  • Turnover: 40282×100=14.2%

Data Presentation

  1. Bar Graph-The following is the Bar Graph presenting the year-wise Turnover percentages of each department (2020-2023). It has a graphical display of the turnover rates by department making it less time consuming to determine departments with high or little turnover in the previous years.

Please click the following icon to access this assessment in full

 

Related Papers

-80%
Placeholder

(Solution) CIPD 7OS05 Workplace Cultures Varying Globally

Original price was: £ 50.00.Current price is: £ 10.00.
Add to cart
Solution 2.2 Workplace Cultures Varying Globally Globally, workplace cultures vary globally in areas of maintaining, renewal and shaping organisations viability.
-50%
Placeholder

(Solution) 5C003 Discuss, with examples, how you have, or would, achieve both of these (AC 2.2)

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
Solution 2.2 Designing an Inclusive People Practice Initiative To design an inclusive people practice initiative and ensure its inclusivity after
-50%
Placeholder

(Solution) Oakwood Assessment ID / CIPD_3CO04_24_01 3CO04 Essentials of people practice

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
Solution Task one – Written Advice Questions   (AC1.1) Explain each stage of the employee life cycle and the role
-67%
Placeholder

(Solution) CIPD AC 4.3: Main principles of maternity, paternity, and adoption rights in the context of employment rights

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Solution Statutory maternity, paternity and adoption rights in the UK apply before and after birth and adoption. Paternity and Adoption
-80%
Placeholder

(Solution) Oakwood International 5CO02 Evidence-based practice Assessment ID / CIPD_5CO02_23_01

Original price was: £ 50.00.Current price is: £ 10.00.
Add to cart
Solution Section One – Report Questions Evaluate the concept of evidence-based practice including how it can be applied to decision-making
-33%
Placeholder

(Solution) CIPD New Brief 5HR01- Employment Relationship Management

Original price was: £ 15.00.Current price is: £ 10.00.
Add to cart
Solution – Employment Relationship Management   Table of Contents Briefing Paper. 2 1.1 Employee involvement and participation. 2 Differences of