-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

Placeholder

(Solution) 5C003 People practice solution for a policy/initiative

Read more
Solution For this question, people practice issue selected is employees turnover. This represent the number of individuals leaving an organisation
-50%
Placeholder

(Solution) 5OS04 Question 2 (AC 1.2) benefits to your company of employing people in an international context following the takeover

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
Solution Question 2(AC 1.2) Employing people in an international context after the takeover will provide three key benefits: Access to
-67%
Placeholder

(Solution) CIPD Question 4: Using Job Evaluations for Determining Reward Decisions

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Solution 4.0 Question 4: Using Job Evaluations for Determining Reward Decisions 4.1 Introduction Adopting the definition of ACAS (2023), job
-86%
Placeholder

(Solution) New CIPD 5C001: Orgnanisational Performance and Culture in Practice

Original price was: £ 70.00.Current price is: £ 10.00.
Add to cart
Solution Table of Contents LO1. 2 1.1 Organisation structures; reasons underpinning. 2 Functional Structure. 2 Divisional Structure. 2 Matrix Structure.
-80%
Placeholder

(Solution) CIPD 7OS05 Effective Management of Talent in International Organisations

Original price was: £ 50.00.Current price is: £ 10.00.
Add to cart
Solution 3.1 Effective Management of Talent in International Organisations An active management of talents entail a set of approaches as
-67%
Placeholder

(Solution) CIPS New Developing Value Through Procurement & Supply; Managing Expenditures with Suppliers (PDV)

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
In these modules “Developing value through procurement and supply and managing expenditures with suppliers”, a report is developed focusing on procurement supply and management (PS&M) function to achieve value for money outcomes. The organisation of focus is Qatar Railways Company (QRC) in sourcing for catering services. Part of this report also entail evaluating approaches of management of costs for the catering services. The data used to generate the findings in this report has been sourced by use of internal documents in QRC, available research from reputable sources and suppliers analysis. Further, various theories and models have been used from CIPS Module notes and guidance (STEEPLED, Mendelow, Kraljic and Suppliers Preferencing and more ) to generate appropriate findings. The main findings in this report evidence that QRC works with many stakeholders for success in their PS&M and specifically sourcing for catering services. Further, with QRC operating in a competitive oligopolistic market environment, achieving value for money outcomes in their PS&M operations is essential. The major findings is that the organisation uses a strategic approach in achieving value for money outcomes. The approach has its advantages and disadvantages with areas of improvement identified in the recommendations. From the identified findings of analysis, a set of gaps have been identified which can be managed by identified recommendations;
  • Pursue detailed analysis of stakeholders positioning to ensure overall interests are prioritised
  • For catering services, engage different potential suppliers to avoid monopolistic demand and supply hindering competitiveness
  • Engage PS&M experts and specialists to acquire knowledge on improving value for money outcomes
  • Reviewing budgetary allocation in catering services sourcing and include modernisation of their sourcing