Analytics
1. Using the data in the excel sheet provided, make a comparison on financial impact between a 60/40 split and a 65/35 split where 60% is Basic and 40% Allowances: who would loose and who would gain, how much and what does it mean to our Company?
2. What would it mean financially to the Company if we change from the current 30 and 42 calendar days leave to 25 and 28 working days leave, given that the 28 would be for Job Grade 14 and above?
>Sheet 0
,500
, 0
10 , 52
, 1 9 30 0,54 9 30 3
42 8 30 ,509
42 ,200
,5 42 8 30 ,786
8 30 10 30 ,4 15 42 7 30 ,9 7 30 9 30 ,574
8 30 16 42 10 30 24,500 38,250 8 30 9 30 12 42 8 30 9 30 17 42 12 42 14 42 12 42 15 42 8 30 14 42 9 30 9 30 10 30 17 42 15 42 Gaining Losing Out 61 60:40 Split
Gaining Losing Out 183 61
Gaining Losing Out 0.75 0.25 60:40 Split Gaining Losing Out 183 61
1
Mixed Split
Emp.ID
Name
Job Grade
Annual Leave
Basic Salary
Current Gross
1
John
10
3
2
5
3
9
25
2
Peter
30
20
7
35
4
8
3
Mary
79,879
11
6
4
Angi
54,476
74,7
26
5
Thierry
13
42
13,
28
20,283
6
Kayla
15
8,154
20,385
7
Ella
16
25,842
8
Mabel
12
18
27
33
9
Eric
14
40,584
58,084
10
Nelly
46,5
36
66
11
Fana
33,253
50,753
12
Shan
22
19
37,825
13
Omer
30,000
44,666
14
Lily
15,590
24
23
15
Marline
7,300
11,967
16
Xira
20,824
34
17
Emilia
50,000
64,840
18
Emile
24,500
38,250
19
Roland
20
Glen
7,767
13,350
21
Ricard
25,011
41,801
22
Geny
27,5
61
44,351
23
Macknel
24,000
37,750
24
Neris
25,002
41,792
25
Dillard
7,439
12,106
26
Blend
19,768
34,991
27
Jude
8,500
13,167
28
Ryan
13,622
22,955
29
Juliette
16,072
29,822
30
Lucy
23,176
40,020
31
Passy
7,186
11,853
32
Aaron
15,853
26,080
33
Joan
27,512
44,415
34
McMillan
49,750
70,000
35
Felix
17,963
25,259
36
Fongang
14,896
21,896
Sheet8
Gaining
Losing Out
66
178
183
27%
73%
75%
25%
Gaining Losing Out 0.75 0.25 XDO_METADATA
BI Publisher
Version
XDO 6.0
Version 1
Template Code
DPE_ERN_DED_RPT_v1.xsl
Last Modified Date :
last modified by :
tdexter
Data Constraints:
XDO_?S_GROSS_SALARY?
XDO_?S_NET_SALARY?