-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) 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
-75%
Placeholder

(Solution) 5C003 Discuss (two) strategies for designing and ensuring inclusive people practices. (AC 2.2)

Original price was: £ 40.00.Current price is: £ 10.00.
Add to cart
Solution Lack of employees Engagement Lack of employee engagement refers to when workers feel disconnected from their work and organization
-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.
-67%
Placeholder

(Solution) CIPD New Level 5 5C002- Evidence-based Practice

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Solution 5C002- Evidence-based Practice   Table of Contents Executive Summary. 2 Introduction. 2 Section One- Report. 2 1.1 Evidence-based practice.
-67%
Placeholder

(Solution) CIPD New 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) CIPS Advanced Level Commercial Management Assessment

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
  • In summary, this business report has evaluated the global commercial strategy within Eco2Solar organisation. As a best practice of leveraging on competitive advantage and market dominance, organisation strategy has been identified as instrumental.
  • The findings of this report indicate that there exist a direct relationship between the strategy and corporate, business, functional structures. This is with various methods which include predictive and descriptive approaches used in the analysis of supply chain.
  • By leveraging on various tools such as Pestle generic strategies, Mendelow stakeholders’ analysis and risk register, the need for resources and also stakeholders’ involvement in the commercial strategy has been evaluated.
  • This is while managing costs overruns and supply chains managed appropriately.