-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

-86%
Placeholder

(Solution) New CIPD 5C001: Orgnanisational Performance and Culture in Practice

Original price was: £ 70.00.Current price is: £ 10.00.
Add to cart
Solution Table of Contents LO1. 2 1.1 Organisation structures; reasons underpinning. 2 Functional Structure. 2 Divisional Structure. 2 Matrix Structure.
-67%
Placeholder

(Solution) CIPD 5CO02 principles of critical thinking

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Solution Explain the principles of critical thinking including how you apply these to your own and others’ ideas. (AC 1.3)
-23%
Placeholder

(Solution) University of Northampton Managing Operations and the Supply Chain AS1: Aramis Project

Original price was: £ 13.00.Current price is: £ 10.00.
Add to cart
Solution Executive Summary The purpose of this report is to present a strategic assessment of the Aramis Carbon Capture and
-67%
Placeholder

(Solution) CIPS Category Plan Implementation, Challenges Faced and Solutions

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
  • In this report, a category plan for Oracle in office materials category of spend has been developed.
  • Category planning has been noted to be a practice where category plans are established aligned with clients business objectives strategically to maximise value, risk reduction, and supply of goods and/or services effective management.
  • Therefore, the Oracle category plan is in tandem with retail and business portfolio objectives to advance clients' needs. The process is applicable in enhancing value maximisation, reducing risks, and goods and services supply management.
  • The applied data inform this assessment findings obtained using techniques such as Kraljic Matrix, Market Structure, PORTER’s 5, and SWOT analysis.
  • Further, existing data focusing on insights of market competition and TCO is successfully analysed.
  • Eventually, a successful category plan implementation has been developed, identifying challenges and approaches for mitigating the difficulties identified.
-50%
Placeholder

(Solution) CIPD 7C002 Question 14: CIPD Purpose champion better work and working lives

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
CIPD LEVEL 7 7C002- People Management & Development Strategies for Performance
-67%
Placeholder

(Solution) CIPD Summarise the main points of discrimination legislation. (AC3.3)

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Solution Summarise the main points of discrimination legislation. (AC3.3) If you use secondary sources you should include your short references