-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
-50%
Placeholder

(Solution) New 5HR01 (AC1.4) Explain the concept of better working lives and how this can be designed

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
Solution (AC1.4) Explain the concept of better working lives and how this can be designed. Short references should be added into
-67%
Placeholder

(Solution) Muscat University Module Name: Research Methods in Logistics and Supply Chain Management Module Code: ILRML Dissertation Proposal

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Solution Declaration   I declare that I have personally prepared this assignment. The work is my own, carried out personally
-67%
Placeholder

(Solution) CIPS Advanced level Leadership & Management in Procurement and Supply

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
  • In summary, this report has focused on evaluating the impact of approaches to leadership and management in an organisation.
  • To achieve this, a focus on Eco2Solar organisation has been prioritised where it has been established that the organisation current success in a project intended to achieve 2,000 installation in different apartments can be credited to their astute leadership and management.
  • This equally evidence the organisation position dominating UK solar sector.
  • These findings have been affirmed by PESTLE analysis of external factors, RACI Matrix among other tools which have been used.
-67%
Placeholder

(Solution) CIPD Oakwood Assessment ID / CIPD_5OS06_23_01 5OS06 Leadership and management development

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Solution Section one – Questions   Analyse the external factors that drive the need for leadership and management within the
-67%
Placeholder

(Solution) CIPS ROSHN Contract Terms and Conditions

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
  • In this assessment, an evaluation of ROSHN company contract terms and conditions have been evaluated.
  • By selecting Facilities Management Contract, its effectiveness in ensuring quality issues, time extension risk, costs overruns and unethical practices has been evaluated.
  • Further, the importance of performance measures and management in ROSHN company practices has been prioritised for evaluation.
  • The contract terms and conditions have been quoted for evidencing the success of the contract implementation.
  • In this assessment, the findings evidence that ROSHN facilities management spend category is characterised by various issues which are stipulated by the terms and conditions.
  • The relevance of this is ensuring success in managing the overall faced challenges. By reviewing the different terms and conditions, the issues related to performance management, force majeure, costs, indemnity, risk management and insurance have been put into account.
  • Also, the battle of forms have been evaluated with the best practice in their management identified.