-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) CIPS FIDIC Terms and Conditions PDC

Original price was: £ 40.00.Current price is: £ 10.00.
Add to cart
  • This report evaluates the terms and conditions that are applicable in a contract management process to improve its implementation.
  • By referencing FIDIC organisation terms and conditions, their effectiveness in mitigating issues with time, unethical, quality, costs and performance management has been evaluated.
  • These terms and conditions are grouped into the goods quality, guidelines of goods and services inspection, communication, and time extension.
  • Part of the analysis involves the evaluation of performance measures essential to improve management and monitoring of the stakeholder’s involvement in the contract process.
  • At the end, battle of forms has been evaluated, which involves failure to agree on set terms and conditions.
  • To solve this, short-term rule and long-term rule and Lord Deming could be adopted.
-67%
Placeholder

(Solution) CIPD Level 7 7HR02 Question 3 (AC 3.1) short and a long-term approach that could be implemented to meet the current and future demand for talent

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Solution Question 3 (AC 3.1) To further enhance the organisation’s workforce planning, evaluate a short and a long-term approach that
-80%
Placeholder

(Solution) New 7C001 Level 7 Question 10 (AC 3.2) mantra ‘people support what they help to create’ should underpin the approach taken by managers when restructuring an organisation

Original price was: £ 50.00.Current price is: £ 10.00.
Add to cart
Solution Question 10- 1,007 Words As defined by Amarantou et al. (2018), resistance to change in an organisation refers to
-67%
Placeholder

(Solution) CIPD 5CO03 Professional behaviours and valuing people Assessment ID / CIPD_5CO03_23_01

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
-67%
Placeholder

(Solution) CIPD 7C004 Task 3.1 Costs of options of collection and data analysis

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Solution The entire planning is cost-intensive and would cost SAR5,000 for completion. The surveys answering would be for approximately 15
-67%
Placeholder

(Solution) CIPD AC 1.2 Tribunal and courts system in enforcing employment law

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Solution The Employment Tribunals (ETs) do not operate through an inherent jurisdiction but depend on parliament for their statutory powers.