-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

-75%
Placeholder

(Solution) CIPD 5CO02 measure the impact and value of people practice

Original price was: £ 40.00.Current price is: £ 10.00.
Add to cart
Solution Explain how to measure the impact and value of people practice using a variety of (two) methods. (AC 3.2)
-67%
Placeholder

(Solution) CIPD 7C002 Question 9: employee relations issues

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Solution Post COVID-19 pandemic, the employee relations issues have increased. To support this, People Management (2023) noted that employees had
-75%
Placeholder

(Solution) Oakwood International 5HR02 Talent management and workforce planning

Original price was: £ 40.00.Current price is: £ 10.00.
Add to cart
Solution Briefing paper Questions (AC1.1) Explain how organisations strategically position themselves in competitive labour markets. Short references should be added into
-50%
Placeholder

(Solution) 5OS04 Question 3 (AC 1.3) tension in multi-national companies between a wish to adhere to global corporate standards and norms when managing people

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
Solution Question 3 (AC 1.3) Explain why there is typically some tension in multi-national companies between a wish to adhere
-75%
Placeholder

(Solution) CIPD 7C001 developments in technology currently affecting the management of people within your organisation

Original price was: £ 40.00.Current price is: £ 10.00.
Add to cart
  •  2 examples of technology and how it affects managing people in my organisation explained effectively
  • Second example geared more towards the management of people rather than what the technology does.
  • Again, multiple references have been provided in this answer and a wider depth and breadth of research assisted in your evaluation.
  • Some context around the organisation (size, sector etc.)  have been provided with beneficial to set the scene for your evaluations.
-33%
Placeholder

(Solution) New Brief CIPD Level 5 5C001 Oakwood International

Original price was: £ 15.00.Current price is: £ 10.00.
Add to cart
Solution Task- Questions 1.1 An organisation structure has a direct correlation with performance (Akpa et al., 2021). This is since