-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) CIPS PDC Royal Commission for Alula Managing Risk of Increased Costs

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Solution 2.3 Risk of Increased Costs As evidenced in Heravi and Mohammadian (2021) the cost overruns risk is as a
-75%
Placeholder

(Solution) CIPS MER Developing Contracts

Original price was: £ 40.00.Current price is: £ 10.00.
Add to cart
In summary, this report has focused on evaluation the selection criteria and sourcing strategies for enabling appropriate selection of suppliers for goods, services and works. Through a focus on Ericsson organisation different spend categories, a set of sourcing approaches have been identified. The approaches have been evaluated through the application of different tools and techniques. This is with different available data from Ericsson spend categories being evaluated in detail. Further, for the different approaches, the risk analysis and potential challenges impacting their implementation. The findings indicate that there is no one-size-fits all approach for selection criteria and sourcing strategies. The best practice is dependent on the organisation category of spend and suppliers availability. A set of recommendations can be provided for successful formulation of selection criteria and sourcing strategies. These include;
  • In SWOT analysis, one of the identified weakness is failure to use technologies in their sourcing approach. As a best practice, Ericsson can make investments in modernised technology including AI, machine learning in improving their sourcing strategies
  • Since there is no one-size-fits all approach of selection criteria and sourcing strategies, the best practice would be to harness collaborative and partnerships relations for success of their sourcing.
  • Pursue a holistic L&D practices by the PS&M in order to understand the best sourcing approach which would be in a position of enhancing the overall process of sourcing
  • Further, from the risk analysis, some of the risks identified are not UpToDate. Hence, it is important continuously updating supply chain networks for identifying potential risks which are internal and external.
-80%
Placeholder

(Solution) Amended CIPD 5C003 Professional Behaviours and Valuing People

Original price was: £ 50.00.Current price is: £ 10.00.
Add to cart
Solution   Task One 1.1 Professional; Meaning of People Professional Professional A professional is a derivative of a profession. As
-67%
Placeholder

(Solution) 7CO03 Learning Plan own approaches to decision-making on complex issues, taking ownership to remedy mistakes

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Solution Assessment criterion 12 To be able to assess own approaches to decision-making on complex issues, taking ownership to remedy
-50%
Placeholder

(Solution) CIPD 7C002 Question 14: CIPD Purpose champion better work and working lives

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
CIPD LEVEL 7 7C002- People Management & Development Strategies for Performance
-67%
Placeholder

(New) CIPD Level 7 7C001- Work and Working Lives in a Changing Business Environment

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Solution Question 3- Populations Ageing Rapidly; Challenges for People Professionals In United Nations (2024) report, it noted that the ageing