-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

-33%
Placeholder

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

Original price was: £ 15.00.Current price is: £ 10.00.
Add to cart
Solution Briefing paper Questions (AC1.1) Evaluate the concept of evidence-based practice including how it can be applied to decision-making in people
-75%
Placeholder

(Solution) LEADERSHIP AND MANAGEMENT ISSUES: Change Management and Ensuring Employee’s Productivity and Performance

Original price was: £ 40.00.Current price is: £ 10.00.
Add to cart
Solution Introduction Leadership and management are vital issues in organisational growth and development. However, Azad et al. (2017) note that
-67%
Placeholder

(Solution) CIPD Explain different methods of performance review. (AC4.3)

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Solution Explain different methods of performance review. (AC4.3) If you use secondary sources you should include your short references in
-67%
Placeholder

(Solution) New 7C001 Level 7 Question 1 The Trend Towards Greater Globalisation of International Business Activity

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Solution  
-50%
Placeholder

(Solution) CIPD Level 5 Oakwood 5CO02 Evidence-based practice

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
Solution Briefing paper Questions (AC1.1) Evaluate the concept of evidence-based practice including how it can be applied to decision-making in people
-50%
Placeholder

(Solution) CIPS Saudi Syndicate Cohort 1 (Practitioner) PIN

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
 This report is concerned with exploring diverse sourcing approaches in procurement and supply management (PS&M) for implementation in the IT category in today’s business environment. The basis for this analysis is the IT procurement strategy at ROSHN, one of Saudi Arabia’s key contributors to its Vision 2030. Data, which have been gathered from ROSHN’s internal documents have been used to achieve the aim of the report and some strategic frameworks were applied such Mendelow’s Matrix, STEEPLE and Kraljic Matrix. The findings here indicate that ROSHN’s preferred approach is to multiple source the services to ensure a degree of flexibility and to balance the risks involved in what is fundamentally a competitive and fast changing market. Multiple sourcing is used to increase vendor options and pricing competitiveness, while sole or single sourcing is used in very limited case. Further it indicates that where dual sourcing is employed, the diverse solutions or vendor capabilities will be required to meet the extensive project requirements that ROSHN has for smart community development. ROSHN’s application of supplier appraisal tools in the IT category will achieve value for money, quality, and meet its strategic goals. Based on these findings, several gaps were identified that can be managed through the following recommendations:
  • Internal and external analyses should be carried out in order to pinpoint the best or most effective sourcing strategies for IT.
  • A broader sourcing appraisal strategy should be introduced within the procurement policies and practices.
  • Improve in focus in managing effective sourcing strategies based on organisational objectives.
  • Broader inclusion of stakeholders in the procurement process, in order to enhance sourcing strategy effectiveness.
  • Capacity development initiatives should be implemented in the PS&M practices, especially within IT category.