-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) CIPD 5C002 (AC1.2) Evaluate a range of analysis tools and methods including how they can be applied to diagnose organisational issues, challenges and opportunities

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
Solution (AC1.2) Evaluate a range of analysis tools and methods including how they can be applied to diagnose organisational issues, challenges
-75%
Placeholder

Assessment ID/CIPD_5CO01_23_01 Organisational performance and culture in practice

Original price was: £ 40.00.Current price is: £ 10.00.
Add to cart
Solution Organisation structures The organisation structure is defined in Sarwar et al. (2020) as representing the outline of how organisation
-80%
Placeholder

(Solution) 7CO02 People management and development strategies for performance

Original price was: £ 50.00.Current price is: £ 10.00.
Add to cart
Solution 7C002: People Management and Development Strategies for Performance Question 1 Over the years, owing to dynamism of Human Resource
-75%
Placeholder

(Solution) CIPS Oman LNG LLC Advanced Practitioner Corporate Award- APCM

Original price was: £ 40.00.Current price is: £ 10.00.
Add to cart
  • In summary, this report has established a category plan by focusing on facilities management in Oman LNG organisation.
  • A summary of the category plan has been noted as appropriate to develop appropriate category guided by goals and objectives of an organisation, maximising value, mitigating risks, goods and services supply managed appropriately. In this case, the category plan is in tandem with retailers and business portfolio to pursue their client’s needs.
  • The data and information has been obtained by using techniques which include Kraljic matrix, SWOT analysis, STEEPLE analysis, Porter’s 5 Forces analysis and industrial lifecycle and more have been adopted for internal and external aspects essential for prioritisation.
  • This is for effective risks and management issues.
  • The category plan prioritise on areas of communication, support system and managing entire risks by establishing effective category management.
-80%
Placeholder

(Solution) CIPS ADNOC Cohort 15 Practitioner PSE Sourcing Essentials

Original price was: £ 50.00.Current price is: £ 10.00.
Add to cart
  • In summary, in this report, sourcing approaches have been evaluated.
  • By focusing on ADNOC fuel main category of spend and other spend categories, the sourcing approaches have been identified to include multiple, single, dual, and sole.
  • In ADNOC, the procurement process includes a detailed process that is defined by the transitioning of sourced products and services to the organisation.
  • The identified spend categories are strategic, leverage, bottleneck, and non-critical items. Also, the products have been categorised into those with high-profit implications, risks incurred, and reliable.
  • In the identified area of spend, multiple sourcing is preferred due to the critical nature of the identified spend category.
-75%
Placeholder

(Solution) CIPD 5CO02 measure the impact and value of people practice

Original price was: £ 40.00.Current price is: £ 10.00.
Add to cart
Solution Explain how to measure the impact and value of people practice using a variety of (two) methods. (AC 3.2)