-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

-75%
Placeholder

(Solution) 5CO01(AC2.4) Discuss models to show how change is experienced

Original price was: £ 40.00.Current price is: £ 10.00.
Add to cart
Solution (Solution) 5CO01(AC2.4) Discuss models to show how change is experienced In order to demonstrate the experience of change in
-75%
Placeholder

(Solution) New CIPD Assessment ID/CIPD_3CO02_23_01 Principles of analytics

Original price was: £ 40.00.Current price is: £ 10.00.
Add to cart
Solution » Section one 1.1 Definition of Evidence-Based Practice: Evidence-based practice involves utilizing various sources of information when making decisions
-75%
Placeholder

(Solution) CIPS Oman LNG LLC Advanced Practitioner Corporate Award- APCM

Original price was: £ 40.00.Current price is: £ 10.00.
Add to cart
  • In summary, this report has established a category plan by focusing on facilities management in Oman LNG organisation.
  • A summary of the category plan has been noted as appropriate to develop appropriate category guided by goals and objectives of an organisation, maximising value, mitigating risks, goods and services supply managed appropriately. In this case, the category plan is in tandem with retailers and business portfolio to pursue their client’s needs.
  • The data and information has been obtained by using techniques which include Kraljic matrix, SWOT analysis, STEEPLE analysis, Porter’s 5 Forces analysis and industrial lifecycle and more have been adopted for internal and external aspects essential for prioritisation.
  • This is for effective risks and management issues.
  • The category plan prioritise on areas of communication, support system and managing entire risks by establishing effective category management.
-80%
Placeholder

(Solution) CIPD 7OS05 Major Ways People Practice Vary Globally

Original price was: £ 50.00.Current price is: £ 10.00.
Add to cart
Solution Task 2- Report 1.0 Introduction In modern business environment, with organisations interested in becoming international in their scope and
-50%
Placeholder

(Solution) CIPD 5HR02 (AC3.3) Explain the impact of dysfunctional employee turnover

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
Solution (AC3.3) Explain the impact of dysfunctional employee turnover. Short references should be added into your narrative below. Please remember to
-33%
Placeholder

(Solution) Question 1 (AC 1.1) 7C002 it is a mistake for people management specialists to distance themselves from administrative activity in favour of strategic work

Original price was: £ 15.00.Current price is: £ 10.00.
Add to cart
Solution Question 1 (AC 1.1)- To what extent do you agree with the view that it is a mistake for