-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) ICS Learn CIPD Level 5 Advances in Digital Learning and Development (5OS02)

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
Solution 1.1 The impact of technology on the design and delivery of L&D In recent years, technology has greatly changed
-67%
Placeholder

(Solution) CIPD Level 3 3CO04 Essentials of people practice Assessment ID / CIPD_3CO04_23_01

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Solution Task 1 Recruitment and selection  Stages of the Employee Lifecycle Clean Quarter Ltd, a budding start-up conceived by friends
-50%
Placeholder

(Solution) CIPD 5C003- Professional Behaviours and Valuing People

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
Solution Table of Contents Task- Professional and Ethical Behaviours. 2 1.1 People Professionalism.. 2 1.2 People practice’s personal and ethical
-75%
Placeholder

(Solution) AC1.1 Explain how organisations strategically position themselves in competitive labour markets

Original price was: £ 40.00.Current price is: £ 10.00.
Add to cart
Solution According to Brown et al. (2019), a competitive labor market occurs when numerous companies vie for a small pool
-50%
Placeholder

(Solution) New PSE Sourcing Essentials ROSHN Syndicate Cohort

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
This report makes use of the case study of ROSHN — Saudi Arabia’s leading real estate developer having the responsibilities of delivering quality homes. ROSNH plays an important role in the organization of construction activity in KSA and currently owns more than sixty percent in the market of residence construction. The key findings evidence that procurement practices of the organization are orderly with keen emphasis on the relationship it has with the suppliers so as to deliver construction materials in the shortest times and most efficient costs possible. The key findings evidence that an effective sourcing approaches will work to strengthen ROSHN’s procurement systems, minimize supply-chain vulnerabilities, and centralize costs for the organisation while offering the organization compliance with burgeoning sustainability shifts in the constructions industry. The following paper assesses the current sourcing initiatives and provides several critical suggestions that can strengthen procurement and supply chain. The key recommendations arising from this analysis include:
  • ROSHN should incorporate Porter’s Five Forces and PESTLE analysis into the organization’s Vendor Management Team (VMT)
  • The expansion of the approved list of suppliers by not less than fifteen percent in the course of the next year is vital in eliminating reliance on a few suppliers.
  • Improving eSourcing tools especially eAuctions to apply competitive pressures and lower costs of procurement. This will solve the problem of inefficiency in the tendering process and increase transparency while RHOSN already has efficient technology solutions for engaging suppliers.
  • Obligatory implementation of a supplier sustainability program that identifies suppliers with high levels of CS
-67%
Placeholder

(Solution) New 5HR01 (AC2.3) Distinguish between third-party conciliation, mediation and arbitration

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Solution (AC2.3) Distinguish between third-party conciliation, mediation and arbitration. Short references should be added into your narrative below. Please remember to