-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

-67%
Placeholder

(Solution) Links to Strategic Workforce Planning Modules

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Solution Module Practice Focus Your evaluative review must address the practice focus of 4 modules from your programme. In the
-80%
Placeholder

(Solution) CIPD Explain different recruitment methods and when it is appropriate to use them. (AC1.3)

Original price was: £ 50.00.Current price is: £ 10.00.
Add to cart
Solution Job Fairs- For Jaspreet and Caroline, they can come up with a table and displaying material pertaining to their
-67%
Placeholder

(Solution) CIPD 7C002 Question 8: High performance work practices

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Solution Concept of High Performance Work Practices According to CIPD (2022), the High Performance Work Practices (HPWP) is identified as
-80%
Placeholder

(Solution) CIPS Final Project Advanced Practitioner Corporate Award (APPR)

Original price was: £ 50.00.Current price is: £ 10.00.
Add to cart
Solution Selected Title: Proposal for the Installation of Solar Photovoltaic (PV) System on the North Block building rooftop within the
-80%
Placeholder

(Solution) CIPS ADNOC APCM Advanced Category Management

Original price was: £ 50.00.Current price is: £ 10.00.
Add to cart
  • In conclusion, this assessment has focused on developing an evaluation of the contractual terms and impact on power distribution in Abu Dhabi National Oil Company (ADNOC)  and risk of supplier and organisation has been evaluated.
  • A general contract used in ADNOC purchasing of goods has been used for achieving the aim of this assessment. Also, desk research and statistics have been used for the purpose of generating the expected findings.
  • The findings indicate that the terms and conditions clearly stipulate on risks and power distribution between ADNOC and their suppliers of the gas turbines. This has been identified by application of various tools and models relevant for this assessment.
-75%
Placeholder

Assessment ID/CIPD_5CO01_23_01 Organisational performance and culture in practice

Original price was: £ 40.00.Current price is: £ 10.00.
Add to cart
Solution Organisation structures The organisation structure is defined in Sarwar et al. (2020) as representing the outline of how organisation