-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

-80%
Placeholder

(Solution) CIPS ADNOC APCM Advanced Category Management

Original price was: £ 50.00.Current price is: £ 10.00.
Add to cart
  • In conclusion, this assessment has focused on developing an evaluation of the contractual terms and impact on power distribution in Abu Dhabi National Oil Company (ADNOC)  and risk of supplier and organisation has been evaluated.
  • A general contract used in ADNOC purchasing of goods has been used for achieving the aim of this assessment. Also, desk research and statistics have been used for the purpose of generating the expected findings.
  • The findings indicate that the terms and conditions clearly stipulate on risks and power distribution between ADNOC and their suppliers of the gas turbines. This has been identified by application of various tools and models relevant for this assessment.
-67%
Placeholder

(Solution) CIPD 7OS05 Ways of Organisations Expanding their Activities Internationally

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Solution 3.0 Ways of Organisations Expanding their Activities Internationally People practice professionals are core for shaping corporate strategy and culture
-75%
Placeholder

(Solution) Oakwood International 5HR02 Talent management and workforce planning

Original price was: £ 40.00.Current price is: £ 10.00.
Add to cart
Solution Briefing paper Questions (AC1.1) Explain how organisations strategically position themselves in competitive labour markets. Short references should be added into
-80%
Placeholder

(Solution) CIPS New PDV- Driving Value Through Procurement and Supply; Managing Expenditures with Suppliers

Original price was: £ 50.00.Current price is: £ 10.00.
Add to cart
  •  Based on the above discussion, this paper has demonstrated that procurement and supply functions in an organisation are critical in reducing costs, ensuring cost-effectiveness and value for money.
  • The procurement department at RCU is key to preventing adverse effects resulting from the adoption of new technology within the industry.
  • Each organization has its set of rules and blueprints that determine the procurement and supply activities. These rules are beneficial to the organization in several ways, which include improving financial stability, lowering business risk, increasing employee performance, and creating better supplier relationships.
  • Investors’ involvement in the procurement and supply process is critical since it facilitates business transformation.
  • Effective procurement and supply management is important to organizations because it is central to the success of organization. The procurement department at RCU focused on the purchase of IT software as the area of spend.
-67%
Placeholder

(Solution) CIPD 50S02- Advances in Digital Learning and Development

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Solution Table of Contents Task 1- Written Response. 2 1.1 Development of technology and digital collaboration. 2 Learning Management System
-50%
Placeholder

(Solution) CIPD Oakwood International 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