-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

FIN501 Corporate and Managerial Finance Determinants of Trade Credit

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
Solution Abstract In this project, an evaluation of the determinants of trade credit has been pursued. By focusing on Saudi
-75%
Placeholder

(Solution) New CIPS PIN Effective Negotiation in Procurement and Supply

Original price was: £ 40.00.Current price is: £ 10.00.
Add to cart
Solution Executive Summary This Corporate Award Program Integrative Report generates a basis for commercial negotiation for Petroleum Development of Oman
-50%
Placeholder

(Solution) New CIPD Level 5 Assessment ID / CIPD_5CO03_24_01 5CO03 Professional behaviours and valuing people

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
Solution Briefing paper Questions   (AC1.1) Appraise what it means to be a people professional. Short references should be added into
-67%
Placeholder

(Solution) CIPD Level 7 Assessment 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 1 From the reviewed literature, there lacks a universal common definition of globalisation. Nevertheless, WTO (2023) identify globalisation
-50%
Placeholder

(Solution) New CIPS PDV Market Analysis; Procurement Role in Value for Money Outcomes

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
Solution 3.1 Brief Market Analysis In Grand View Research (2024) report, the global in-flight and rail sector catering services market
-33%
Placeholder

(Solution) CIPD Level 7 Advanced Diploma in Strategic People Management – Unit 7CO04 Business Research in People Practice

Original price was: £ 15.00.Current price is: £ 10.00.
Add to cart
Solution Section A: Learner Details Learner Name: Your full name     Course Title: CIPD Level 7 Advanced Diploma in