-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 New Sourcing Essentials (PSE)

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Solution Executive Summary In this report, sourcing approaches for a spend category in Crown Commercial Service (CCS) has been evaluated.
-50%
Placeholder

(Solution) CIPD 5HR02 (AC3.1) Discuss factors that influence why people choose to leave or remain in organisations.

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
Solution (AC3.1) Discuss factors that influence why people choose to leave or remain in organisations. Short references should be added
-75%
Placeholder

(Solution) 7C003 3.1 Curiosity and passion for deep learning

Original price was: £ 40.00.Current price is: £ 10.00.
Add to cart
Solution Assessment criterion 3.1 Demonstrate curiosity and passion for deep learning. Competence achieved Initial ability (scale 0-10) = 7/10 Competence
-67%
Placeholder

(Solution) CIPS PSE ROSHN Procurement/ Commercial Function

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Solution ROSHN operates a fully independent PS&M department mandated with the responsibility of generating an approved supplier list framework agreements.
-50%
Placeholder

(Solution) New CIPD AVADO 5HR01- Employment Relationship Management

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
Solution 5HR01- Employment Relationship Management   Table of Contents Briefing Paper. 2 1.1 Employee involvement and participation. 2 Differences of
-75%
Placeholder

(Solution) CIPS FIDIC Contracts Advanced Practitioner Corporate Award (APCE)

Original price was: £ 40.00.Current price is: £ 10.00.
Add to cart
  • In this report, an evaluation of a contract by Oracle which is FIDIC guiding their construction projects in more than 67 countries globally has been carried out.
  • It is evident from the analysis that there are varying contractual terms having an influence on the power and risk distribution between a supplier and an organisation.
  • The rationale of this is that a contract is a legally enforceable agreement between different parties with specific acts or practices to be put into account.
  • The core report areas of focus of focus has included the issues of price, quality, construction projects delivery timeline and health and safety have been put into account on the extent in which the risk and power are distributed between the contractor and the organisations.
  • In the components identified, it is evident that irrespective of whether the buyer or supplier executes the risk or power.
  • Through the application of different tools such as Mendelow stakeholders matrix, SWOT analysis and others, distinct issues and risks characterised by various challenges in the construction projects execution with their mitigation approaches and risks have been evidenced.
  • As evidenced from the Kraljic analysis, it is evident that contractual terms have a strategic relevance in the context of Oracle informing on their holistic leveraging on the risks and powers of the contract.
  • In situations where Oracle fails in leveraging on contract holistic risks power balance, warrant and also insurance cover is used.