-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 APGM Tools and Technique to Map Categories of Direct and Indirect Expenditure

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Solution 5.0 Tools and Technique to Map Categories of Direct and Indirect Expenditure 5.1 Definition of Terms An expenditure is
-50%
Placeholder

(Solution) 7C003 Demonstrate appropriate influencing style to communicate and engage different audiences

Original price was: £ 20.00.Current price is: £ 10.00.
Add to cart
Solution Learning Outcome 4: Be able to influence others during decision-making while showing courage and conviction.   Assessment criterion 13
-75%
Placeholder

(Solution) CIPD 5C003 Recognise how personal and ethical values can be applied in the context of people practice. (AC 1.2)

Original price was: £ 40.00.Current price is: £ 10.00.
Add to cart
Solution (Solution) CIPD 5C003 Recognise how personal and ethical values can be applied in the context of people practice. (AC
-67%
Placeholder

(Solution) CIPD 5HR03 Task One–Report Section One

Original price was: £ 30.00.Current price is: £ 10.00.
Add to cart
Solution Task One – Report Section Once   Evaluate the principles of reward and its importance to organisational culture and
-75%
Placeholder

(Solution) New CIPS Corporate Award Advanced Practitioner (CAAP) Project proposal

Original price was: £ 40.00.Current price is: £ 10.00.
Add to cart
Today, in oil and gas sector in UAE, it is encountering immense pressures from different stakeholders for addressing tendering process in their contracts management. Nevertheless, there exist less literature which has evaluate the implication of incorporation of technologies for enhancing issues linked with accessing, delivering timelines and input. This is through developing a system which enhance one-on-one communication reducing the entire contracts evaluation cycle. The process would have a positive implication on ADNOC and their different suppliers by managing issues associated with access, timeline of provision, communication, paper usage and input therefore reduced tendering evaluation process. The different deliverables for the current project would include the following;
  • Improved engagement of different stakeholders in tendering process of contracts process
  • Increased costs savings by reducing communication barriers and also reducing the number of employees working in tendering process
  • An effective data management and recording for ensuring success in evaluation and use of the data for contracts tendering process metrics
  • Effective management of issues in the contracts evaluation and recommend best strategies in their mitigation during tendering process
  • To effectively pursue trend analysis to understand the history of evaluations and effectively use the data in managing tendering process
-80%
Placeholder

(Solution) CIPD DPG 7C001- Work and Working Lives in a Changing Business Environment

Original price was: £ 50.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