-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 Management of Resources to Support Development and Strategy Implementation

Original price was: £ 50.00.Current price is: £ 10.00.
Add to cart
Solution According to Negri et al. (2021), in implementing a corporate strategy, people and capital are prioritised. This is for
-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
-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
-67%
Placeholder

Assessment ID/CIPD_5HR02_22_01 Talent management and workforce planning

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Solution Table of Content AC 1.1 ……………………………………………………………………………………………………………….7 AC 1.2 ……………………………………………………………………………………………………………….8 AC 1.3 …………………………………………..……………………………………………………………………9 AC 2.1 ………………………………………………………..…………………………………………….………10 AC 2.2……………………………………………………………………………………………………..………..11 AC 2.3…………………………………………………………………………….…………………………………12
-50%
Placeholder

(Solution) CIPD 5HR02- Talent Management and Workforce Planning

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
Solution Competitive Labour Markets Competitive labour markets exist when there are many employers and employees actively competing for each other.
-67%
Placeholder

(Solution) CIPS PDC Royal Commission for Alula Managing Risk of Poor Quality

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
In this second assessment, through a focus on Royal Commission for Alula (RCU) organisation, contract terms and conditions have been evaluated. The evaluation has focused on the effectiveness of these terms and conditions in;
  • Ensuring management of risks of poor quality, extension of time, costs increase and unethical practices
  • Making sure appropriate performance measures are monitored and managed
Also, as part of this report, the battle of forms have been evaluated with the best practice in ensuring management of these battle of forms identified. This has also been reflected in this assessment recommendation for ensuring organisation own terms and conditions are used. Apart from quoting the relevant terms and conditions, a set of tools have been used (specifications analysis, risk register, Mendelow analysis among others). For instance, by using standardisation valuation model, the importance of the contract in context of RCU has been identified. Further, through Mendelow analysis of different stakeholders, the relationship with contracts has been established. Further, by using a risk register, the best practice in managing the risk of extension of time has been evaluated.