-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

-80%
Placeholder

(Solution) CIPD Level 5 ICS Learn Equality, diversity and inclusion (5OS05)

Original price was: £ 50.00.Current price is: £ 10.00.
Add to cart
Solution SECTION 1 1.1 Assessment of the Value of Equality, Diversity, and Inclusion in Organisations      Equality Equality allows all employees,
-67%
Placeholder

(Solution) CIPD Level 5 5C001- Organisational Performance and Culture in Practice

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Solution Practice     Answers to the Questions 1.1 Organisation Structures Evaluation Organisation structure 1 (My organisation)-Hierarchical Organisation Structure In
-86%
Placeholder

(Solution) 5CO03 Appraise what it means to be a people professional

Original price was: £ 70.00.Current price is: £ 10.00.
Add to cart
Solution Appraise what it means to be a people professional. (AC 1.1) Short references should be added into your narrative
-75%
Placeholder

(Solution) CIPS Sourcing Essentials PSE Saudi Downtown Company

Original price was: £ 40.00.Current price is: £ 10.00.
Add to cart
  • In this report, an evaluation of various sourcing approaches used in sourcing has been pursued.
  • Through a focus on Saudi Downtown Company (SDC), sourcing of Information Technology (IT) systems post COVID due to popularity of remote working in the different departments has been identified as the spend area.
  • In the evaluation process, ifferent tools including Mendelow Matrix, Kraljic Matrix, SWOT analysis, Hierarchy of need, and Peter Block Grid have been adopted in the analysis.
  • The different sourcing approaches have been identified and their influence for the organisation best practice noted. At the end, by using Cater’s 10C’s tool, supplier appraisal has been carried out for the identified spend area.
The findings in this assessment evidence that SDC adopts various sourcing approaches for their different spend categories.  There is nevertheless a challenge in embracing strategic sourcing in their operations. Further, the organisation use different sourcing approaches including multiple sourcing, single sourcing, sole sourcing and dual sourcing. All these sourcing approaches are distinct and involved in engagement of different suppliers, only one supplier involved, monopolistic suppliers engaged and suppliers with demands which conflict respectively. In line with the findings and conclusions obtained in this assessment, various recommendations have been suggested for SDC. They include;
  • To select best sourcing approach informed by the characteristics of their spend categories
  • Ensure various legislations and policies are initiated to aid use of technologies and innovation in their sourcing process
  • Implement a fully streamlined PS&M strategy with entire stakeholders interests prioritised
  • Improve information flow and supporting their sourcing strategy by leverage on different approaches (RFQ, RFP and e-Auction) integrated to product lifecycle
 
-67%
Placeholder

(Solution) CIPS PSE ROSHN Procurement/ Commercial Function

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Solution ROSHN operates a fully independent PS&M department mandated with the responsibility of generating an approved supplier list framework agreements.
-67%
Placeholder

(Solution) 5OS06 Leadership and management development Learner Assessment Brief Assessment ID / CIPD_5OS06_23_01

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Solution (Solution) 5OS06 Leadership and management development Learner Assessment Brief Section one – Questions   Analyse the external factors that