-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) GE’s approach to innovation in the past

Original price was: £ 50.00.Current price is: £ 10.00.
Add to cart
Question To what extent Jeff Imelt’s strategy aligned with The requirements of the 21st century business environment?825 words GE’s resources &
-50%
Placeholder

(Solution) marketing analysis (e.g., SWOT, STP, or the marketing mix) to identify the key marketing challenges Proximie faces

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
Question Challenges (400 words) Conduct a thorough marketing analysis (e.g., SWOT, STP, or the marketing mix) to identify the key
-75%
Placeholder

(Solution) 7HR01 Question 1 (AC 1.1) Provide an overview of the three main perspectives on employment relations, unitarist, pluralist and radical

Original price was: £ 40.00.Current price is: £ 10.00.
Add to cart
Solution The unitarist perspective considers the organisation as a whole and emphasise that shared goals exist amongst all employees, managers,
-33%
Placeholder

(Solution) Prime L&D 5CO02 Evidence-based practice

Original price was: £ 15.00.Current price is: £ 10.00.
Add to cart
Solution 5C002 Q1(AC1.1) Evaluate the concept of evidence-based practice (EBP) and provide two examples of where Technivara could use it
-50%
Placeholder

(Solution) CIPD Level 5 Oakwood 5HR02 Talent management and workforce planning

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
Solution Organisations Placing Themselves in Competitive Labor Markets ParcelCare – an experienced and trustworthy national parcel and package delivery service
-67%
Placeholder

(Solution) CIPS PSE Introduction ROSHN Organisation

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Solution 1.0 Introduction 1.1 ROSHN Organisation In this assignment , ROSHN organisation has been selected for evaluation. The organisation under