CIPD Assessment Activity 3RAI Activity 1-Investigation and use of Data

Solution/Answer

 3 Years Turnover Rates (Occupational Groups, Reasons for Leaving and Peaks and Troughs Through each Year

As noted by Kovner et al. (2014), the turnover rates are a representative of the employees leaving an organisation percentages annually. In order to record and analyse the Al Ain Zoo company data, it is essential to put into consideration the number of employees leaving every occupational group in the last three years. In this case, the occupational groups in the company are as shown in table 1 below;

Department Abbreviation
Procurement and Contracts Department PCD
General Services Department

 

 GSD
Operations Department

 

 OD
Facilities Management Department

 

 FMD
Life Sciences Department

 

 LSD
Strategic Planning and Enterprise Risk Management Office Department

 

 SPD
Finance Department

 

 FD
Marketing and Corporate Communication Department

 

 MCCD
Sheikh Zayed Desert Learning Center Department

 

 SZD
Human Resources Department

 

 HRD
Projects Management Department

 

 PMD
Director General Office Department

 

 DGOD
Information Technology Department

 

 IT
Environment Health and Safety Department

 

 EHS

Table 1: Departments in the organisation

Turnover rate= Total Leaving/mean (EMP-Beginning, EMP-End) Percent (Turnover rate)

Department 2016 2017 2018
PCD Employee B.O.Y =8

Employee E.O. Y=7

Total Leaving = 1

%= (8+7)2 = 7.5

1/7.5× 100

=13.3%

 Employee B.O.Y =7

Employee E.O. Y=5

Total Leaving = 2

%= (7+5)2 = 6

2/6× 100

=33%

 Employee B.O.Y =8

Employee E.O. Y=7

Total Leaving = 1

%= (8+7)2 = 7.5

1/7.5× 100

=13.3%
GSD Employee B.O.Y =9

Employee E.O. Y=7

Total Leaving = 2

%= (9+7)2 = 8

2/8× 100

=25%

 Employee B.O.Y =7

Employee E.O. Y=5

Total Leaving = 2

%= (7+5)2 = 6

2/6× 100

=33.3%

 Employee B.O.Y =5

Employee E.O. Y=5

Total Leaving = 0

%= (5+5)2 = 5

1/0× 100

=0%
OD Employee B.O.Y =19

Employee E.O. Y=15

Total Leaving = 5

%= (19+15)2 = 17

5/17× 100

=29%

 Employee B.O.Y =15

Employee E.O. Y=13

Total Leaving = 2

%= (15+13)2 = 19

2/19× 100

=10.5%

 Employee B.O.Y =14

Employee E.O. Y=10

Total Leaving = 4

%= (14+10)2 = 12

4/12× 100

=33.3%
FMD Employee B.O.Y =10

Employee E.O. Y=9

Total Leaving = 1

%= (10+9)2 = 9.5

1/9.5× 100

=11%

 Employee B.O.Y =9

Employee E.O. Y=7

Total Leaving = 2

%= (9+7)2 = 8

2/8× 100

=25%

 Employee B.O.Y =7

Employee E.O. Y=5

Total Leaving = 2

%= (7+5)2 = 6

2/6× 100

=33%
LSD Employee B.O.Y =31

Employee E.O. Y=28

Total Leaving = 3

%= (31+28)2 = 29.5

3/29.5× 100

=10%

 Employee B.O.Y =28

Employee E.O. Y=24

Total Leaving = 4

%= (28+24)2 = 26

1/26× 100

=3.8%

 Employee B.O.Y =26

Employee E.O. Y=24

Total Leaving = 2

%= (26+24)2 = 25

2/25× 100

=8%
SPD Employee B.O.Y =2

Employee E.O. Y=1

Total Leaving = 1

%= (2+1)2 = 1.5

1/1.5× 100

=66%

 Employee B.O.Y =3

Employee E.O. Y=2

Total Leaving = 1

%= (3+2)2 = 2.5

1/2.5× 100

=40%

 Employee B.O.Y =1

Employee E.O. Y=1

Total Leaving = 1

%= (1+1)2 = 2

1/2× 100

=50%
FD Employee B.O.Y =3

Employee E.O. Y=3

Total Leaving = 0

%= (3+3)2 = 3

1/0× 100

=0%

 Employee B.O.Y =3

Employee E.O. Y=2

Total Leaving = 1

%= (3+2)2 = 2.5

1/2.5× 100

=40%

 Employee B.O.Y =2

Employee E.O. Y=1

Total Leaving = 1

%= (2+1)2 = 1.5

1/1.5× 100

=66%
MCCD Employee B.O.Y =1

Employee E.O. Y=1

Total Leaving = 1

%= (1+1)2 = 2

1/2× 100

=50%

 Employee B.O.Y =1

Employee E.O. Y=0

Total Leaving = 1

%= (1+0)2 = 0.5

1/0.5× 100

=200%

 Employee B.O.Y =0

Employee E.O. Y=0

Total Leaving = 0

%= (0+0)2 =0

0/0× 100

=0%
SZD Employee B.O.Y =2

Employee E.O. Y=2

Total Leaving = 0

%= (2+2)2 = 2

1/0× 100

=0%

 Employee B.O.Y =1

Employee E.O. Y=1

Total Leaving = 1

%= (1+1)2 = 2

1/2× 100

=50%

 Employee B.O.Y =1

Employee E.O. Y=0

Total Leaving = 1

%= (1+0)2 = 0.5

1/0.5× 100

=200%
HRD Employee B.O.Y =3

Employee E.O. Y=2

Total Leaving = 1

%= (3+2)2 = 2.5

1/2.5× 100

=40%

 Employee B.O.Y =2

Employee E.O. Y=2

Total Leaving = 0

%= (2+2)2 = 2

1/0× 100

=0%

 Employee B.O.Y =2

Employee E.O. Y=2

Total Leaving = 0

%= (2+2)2 = 2

1/0× 100

=0%
PMD Employee B.O.Y =3

Employee E.O. Y=2

Total Leaving = 1

%= (3+2)2 = 2.5

1/2.5× 100

=40%

 Employee B.O.Y =8

Employee E.O. Y=7

Total Leaving = 1

%= (8+7)2 = 7.5

1/7.5× 100

=13.3%

 Employee B.O.Y =3

Employee E.O. Y=2

Total Leaving = 1

%= (3+2)2 = 2.5

1/2.5× 100

=40%
DGOD Employee B.O.Y =3

Employee E.O. Y=3

Total Leaving = 0

%= (3+3)2 = 3

0/3× 100

=0%

 Employee B.O.Y =3

Employee E.O. Y=2

Total Leaving = 1

%= (3+2)2 = 2.5

1/2.5× 100

=40%

 Employee B.O.Y =3

Employee E.O. Y=2

Total Leaving = 1

%= (3+2)2 = 2.5

1/2.5× 100

=40%
IT Employee B.O.Y =2

Employee E.O. Y=2

Total Leaving = 0

%= (2+2)2 = 2

1/0× 100

=0%

 Employee B.O.Y =1

Employee E.O. Y=0

Total Leaving = 1

%= (1+0)2 = 0.5

1/0.5× 100

=200%

 Employee B.O.Y =1

Employee E.O. Y=1

Total Leaving = 1

%= (1+1)2 = 2

1/2× 100

=50%
EHS Employee B.O.Y =1

Employee E.O. Y=1

Total Leaving = 1

%= (1+1)2 = 2

1/2× 100

=50%

 Employee B.O.Y =2

Employee E.O. Y=2

Total Leaving = 0

%= (2+2)2 = 2

0/2× 100

=0%

 Employee B.O.Y =2

Employee E.O. Y=2

Total Leaving = 0

%= (2+2)2 = 2

1/0× 100

=0%

Table 2: Al Ain Company Turnover Rates

Graph 1: Al Ain Company Turnover Rates

Reasons for Leaving the Organisation

  1. Termination for Disciplinary Reasons
  2. Retirement
  3. Resignation
  4. Termination
  5. According to Employment Contract Condition
  6. Executive Council Decree
  7. Unfit for the Job during Probationary Period
Department 2016 2017 2018
PCD 0 1,1,1,1,1,1,3 0
GSD 3,2 1,2 0
OD 3,4,3,4,5 2,1 7,6,4
FMD 5 5,6 5,4
LSD 4,3,1 1,1,1,2 4,5
SPD 1 1 1
FD 1,2,3 1 7
MCCD 1 3 5
SZD 0 1 2,1
HRD 1 0 0
PMD 1 7 5
DGOD 0 1 1
IT 0 5 7
EHS 1 0 0

Graph 2: Employees reasons for leaving

Taking into consideration the table and graphs above, different reasons for leaving the AL Ain company have been provided. It is evident that all the professional levels have different reasons prompting their employees to leave their organisation. The identified reasons included Termination for Disciplinary Reasons, Retirement, Resignation and Termination. Others included According to Employment Contract Condition, Executive Council Decree, and Unfit for the Job during Probationary Period. The termination for disciplinary reasons topped the reasons for employee dismissal from the company.

Peaks and Troughs Through Each Year

Please click the paypal icon below to receive this assessment for only $15