-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) Global Strategic Supply Chain APPR Questionnaire APPR

Original price was: £ 50.00.Current price is: £ 10.00.
Add to cart
  • This sample is a questionnaire which can be used in APPR Project
  • You can get a similar proposal based on these guidelines
-50%
Placeholder

(Solution) CIPD 7C002 Question 8: High Performance Work Practices Benefit Employers and Employees

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
Solution High Performance Work Practices; Importance to Organisations In different published literature, high performance work practices (HPWP) is defined as
-67%
Placeholder

(Solution) CIPS PDC Royal Commission for Alula Managing Risk of Poor Quality

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
In this second assessment, through a focus on Royal Commission for Alula (RCU) organisation, contract terms and conditions have been evaluated. The evaluation has focused on the effectiveness of these terms and conditions in;
  • Ensuring management of risks of poor quality, extension of time, costs increase and unethical practices
  • Making sure appropriate performance measures are monitored and managed
Also, as part of this report, the battle of forms have been evaluated with the best practice in ensuring management of these battle of forms identified. This has also been reflected in this assessment recommendation for ensuring organisation own terms and conditions are used. Apart from quoting the relevant terms and conditions, a set of tools have been used (specifications analysis, risk register, Mendelow analysis among others). For instance, by using standardisation valuation model, the importance of the contract in context of RCU has been identified. Further, through Mendelow analysis of different stakeholders, the relationship with contracts has been established. Further, by using a risk register, the best practice in managing the risk of extension of time has been evaluated.
-17%
Placeholder

(Solution) 7C001 Values-based recruitment

Original price was: £ 12.00.Current price is: £ 10.00.
Add to cart
Solution Values-based recruitment is the process of ensuring that employees are hired based on the values and beliefs of the
-50%
Placeholder

(Solution) CIPD Level 5 ICS Learn Wellbeing at Work (5OS07)

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
Solution Table of Contents Task One- Written Paper on Wellbeing at Work. 2 1.1 Theories; Application on Issues in Workplace.
-33%
Placeholder

(Solution) CIPD 5C002 decision-making processes that Technivara could apply

Original price was: £ 15.00.Current price is: £ 10.00.
Add to cart
Solution Q4 AC 1.4: Explain two decision-making processes that Technivara could apply to ensure that effective outcomes are achieved. Good