-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

-50%
Placeholder

(Solution) 5C003 personal and ethical values (one of each), with examples of how these are evident in your work (AC 1.2)

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
Solution One of my core personal values is empathy. I believe that understanding and sharing the feelings of others is
-67%
Placeholder

(Solution) 5C003 Task One –Professional and ethical behaviours

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Solution Task one – Questions   Appraise what it means to be a people professional. (AC 1.1) Short references should
-50%
Placeholder

(Solution) 7C003 Self-evaluate personal and professional integrity in relation to ethical practice, professional courage and influence, and valuing people

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
Solution Learning Outcome 1: Be able to model principles and values that promote inclusivity aimed at maximising the contribution that
-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
-80%
Placeholder

(Solution) CIPS ADNOC Sourcing Essentials PSE

Original price was: £ 50.00.Current price is: £ 10.00.
Add to cart
  • For the current report, the sourcing approaches identified and in-depth explained are informed by the ADNOC chemicals sourcing.
  • In tandem with the different spend categories, different sourcing approaches for the spend have been applied with a supplier appraisal generated at the end.
  • Through an in-depth analysis, sourcing strategies evaluating in areas of multiple, single, dual and sole. For procuring the chemicals, multiple sourcing is the best practice due to the procurement process characteristic.
  • As evidenced from Kraljic analysis matrix, suppliers relations are noted with chemicals procurement being a leverage category.
  • The Carter’s 10Cs model is applicable to pursue suppliers appraisal for chemicals sourcing supplier appraisal.
-50%
Placeholder

(Solution) CIPS APGLM Organisation Sources of Power

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
Solution Stakeholders Analysis For HWE organisation case, stakeholders are categorised to internal, connected and external categories. These are as evidenced