-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 5HR01- Employment Relationship Management

Original price was: £ 70.00.Current price is: £ 10.00.
Add to cart
Solution Table of Contents Task- Written Answers to the Following. 2 1.1 Review of Emerging Developments of Approaches to Employee
-50%
Placeholder

(Solution) CIPS Advanced Level Final Project Proposal

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
Solution (Solution) CIPS Advanced Level Final Project Proposal Selected Title Improving Contract Management in Onshore and Offshore construction services in
-75%
Placeholder

(Solution) CIPS Advanced Level Advanced Practitioner Corporate Award (APDP)

Original price was: £ 40.00.Current price is: £ 10.00.
Add to cart
  •  In summary, this assessment, has focused on evaluating the process of leading a project team for implementing a new category management.
  • For achieving this, British American Tobacco (BAT) in Malaysia has been used as an organisation of interest.
  • The selected category of spend is technology and particularly the procurement of high speed machines for meeting the market demand. The rationale of this is that as an international organisation, BAT organisation engages both local and international suppliers in sourcing of technology.
  • Considering this high demand, there has been challenges which sustainability of their sourcing approach. Therefore, BAT has been prompted to invest in a system which is modernised for ensuring modernisation of the procurement and supply process in BAT.
  • For the Procurement and Supply Management (PS&M) tasked with the responsibility of procuring the technology system tend to take part in learning and development strategies, improving the suppliers relations, increasing  alternation of the suppliers relations, high-level inclusion of stakeholders and to transform technology.
-80%
Placeholder

(Solution) CIPD Assessment ID/CIPD_5CO02_23_01 Evidence-based practice

Original price was: £ 50.00.Current price is: £ 10.00.
Add to cart
Solution Concept of evidence-based practice Definitions Evidence-based practice (EBP) is a process where research evidence is used to guide strategic
-33%
Placeholder

(Solution) Question 1 (AC 1.1) 7C002 it is a mistake for people management specialists to distance themselves from administrative activity in favour of strategic work

Original price was: £ 15.00.Current price is: £ 10.00.
Add to cart
Solution Question 1 (AC 1.1)- To what extent do you agree with the view that it is a mistake for
-75%
Placeholder

(Solution) 5HR03 (AC3.3) Explain approaches to job evaluation

Original price was: £ 40.00.Current price is: £ 10.00.
Add to cart
Solution Formal approach: Factor comparison Factor comparison entails comparing jobs against a number of predetermined job related factors for instance