-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

-67%
Placeholder

(Solution) Assessment ID / CIPD_5CO02_23_01 5CO02 Evidence-based practice

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Solution Section One – Report Questions Evaluate the concept of evidence-based practice including how it can be applied to decision-making
-33%
Placeholder

(Solution) CIPD 5C002 how people practices could add value at Technivara and identify two methods that might be used to measure the impact of these people practices

Original price was: £ 15.00.Current price is: £ 10.00.
Add to cart
Solution People Practices Adding Value The effectiveness of Technivara may be influenced by human resource management (HRM) practices, which aim
-50%
Placeholder

(Solution) CIPS ROSHN Sourcing Essentials- PSE

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
  • In this report, the area of focus is on different sourcing approaches which can be used in procurement and supply management (PS&M) in contemporary business environment. This is through the focus of ROSHN organisation in Design Building category of spend.
  • To achieve the intended aim of this report, data has been sourced from the organisation internal documents, different CIPS modules and models (Mendelow, STEEPLE and Kraljic). The key findings include ROSHN prefeed approach being multiple sourcing owing to the high-level of market competitiveness. This is with sole and single approaches preferred when only one supplier is being engaged owing to differences in organisation needs.
  • Also, the findings evidence that single sourcing prevail in an event many suppliers are available, but an organisation decides to go for one.  Another finding in this report is that dual sourcing is used when different methods/options for sourcing are embraced and put in place.
  • Finally, through the application of supplier appraisal tool, focusing on the Design Building spend area, an evaluation has been put into account. The result from the appraisal using Carter’s 10C’s evidence organisation success to achieve value for money outcomes and improved market development.
Taking into account of the main findings from this report, gaps have been identified which can be managed by following these recommendations;
  • Internal and external analysis to identify most appropriate sourcing strategy
  • Broad sourcing appraisal strategy need to be introduced
  • Focus on managing successful sourcing strategy as part of organisation policy and practices
  • Involve more stakeholders as part of their operations for success in sourcing strategy
  • Pursuing capacity development initiatives for PS&M understanding of relevance of different PS&M
Placeholder

(Solution) CIPD 5HR03 different types of benefits offered by organisations and the merits of each. (AC 1.4)

Read more
Solution Benefit CIPD (2023) defines benefit is an advantage or profit gained from something that helps or assists employees to
-67%
Placeholder

(Solution) CIPD Oakwood Assessment ID / CIPD_5OS06_23_01 5OS06 Leadership and management development

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Solution Section one – Questions   Analyse the external factors that drive the need for leadership and management within the
-50%
Placeholder

(Solution) 5CO03 Recognise when and how you would raise matters which conflict with ethical values or legislation. (AC1.4)

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
Solution Recognise when and how you would raise matters which conflict with ethical values or legislation. (AC1.4) a) where you