-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) 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
-80%
Placeholder

Task 1 – Initial Self Assessment and Plan (7CO03)(23)

Original price was: £ 50.00.Current price is: £ 10.00.
Add to cart
Question At the start of your programme, you will carry out a self-assessment of your knowledge and skill in each
-67%
Placeholder

(Solution) 7HR01 Question 2 (AC 2.2) how the current labour market and organisational strategy impacts the management of employment relations within the organisation

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Solution Career Development Strategy at Saudi Aramco As the leader of the oil and gas industry, Saudi Aramco has a
-50%
Placeholder

(Solution) New CIPD Level 5 5CO03 Professional behaviours and valuing people

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
Solution 1.1 People Professional To be a people professional, as defined by the CIPD Profession Map, means to embody the
-50%
Placeholder

(Solution) CIPS Module 3 Risk of Extension of Time

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
Solution Extension of time is identified as “a strategy for a contractor requesting for an increase in the timeline which
-50%
Placeholder

(Solution) New CIPS Sourcing Essentials (PSE) TAQA Water Solutions

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
This report evaluates and contrasts various sourcing strategies within the SWS (Sustainable Water Solution) organisation, focusing on the health and safety (HS&E) category of spend during the COVID-19 pandemic, which necessitated remote working. To assess the different sourcing strategies, tools such as the Kraljic analysis, Mendelow's stakeholder analysis, the business hierarchy of needs, and the SWOT analysis were employed. Additionally, the Peter Block Grid was used to categorise stakeholders based on their interests and positions related to the sourcing strategies. In the supplier evaluation for the HS&E category of spend within SWS, Carter's 10Cs methodology was applied to assess different sourcing strategies. The results indicate that SWS should adopt a strategic sourcing approach to sustain its leadership in the sustainability and water management industry while maximising efficiency. The sourcing strategies include multiple sourcing (engaging with multiple suppliers), single sourcing (working with one supplier), sole sourcing (working with a monopolistic supplier), and dual sourcing (working with two suppliers who might have conflicting demands). In conclusion, the recommendations for SWS's sourcing strategies in the HS&E category of spend are as follows:
  • Determine the most suitable sourcing strategy based on the characteristics of the spend category.
  • Ensure procurement policies are comprehensive and prioritize health and safety standards.
  • Simplify the procurement process while considering the interests of all stakeholders.
  • Upgrade the current Ariba/SAP system to enhance information flow and support various sourcing methods such as RFQ, RFP, negotiation, and e-auction throughout the product lifecycle