Gender Count of Base Salary

F 20
M 30 F
Total Result 50 20%

Total Result
50%

M
30%
 F
20%
Sum of Base Salary Department
Region Admin Corporate Finance HR IT Logistics Operations Purchase
Central 125,100 122,700 79,300 ### 34,200
East 111,900 82,100 ### 48,300 512,900 82,100
North 318,600 84,500 76,200 ### 281,000 125,000
South 167,000 ### 76,200 81,500
West 118,200 ### ### 287,900 129,300
Total Result 410,300 553,200 ### ### ### ### 757,900 207,100
7000000

6000000

5000000 Sales & Mktg

Purchase
4000000 Operations
Logistics
IT
3000000
HR
Finance
2000000
Corporate
Department Admin
1000000

0
Central East North South West Total
Result
 Sales & Mktg Total Result
418,800 1,061,200
1,120,900
156,800 1,172,900
485,000 1,257,000
158,900 1,121,500
1,219,500 5,733,500

Sales & Mktg

Purchase
Operations
Logistics
IT
HR
Finance
Corporate
Department Admin

t
Average of Base Salary Gender
Designation F M 231,850
VP
221,500
Asst Manager 47,550 44,975
Executive 33,440 34,000 127,614
Sr Mgr
122,400
GM 308,533 291,500 M
Manager 82,380 80,283 Manager
80,283
Sr Mgr 122,400 127,614 82,380
VP 221,500 231,850 291,500
GM
308,533
34,000
Executive
33,440
44,975
Asst Manager
47,550
- 50,000 100,000 150,000 200,000 250,000 300,0
0
33

00 200,000 250,000 300,000 350,000

Base Salary Count of Base Salary
0-49999 13
50000-99999 17 0-
100000-149999 10 49999
13%
200000-249999 6
250000-299999 3
300000-350000 1 0-49999
50000-
Total Result 50 99999 50000-99999
Total Result 17%
50% 100000-1499
200000-2499
250000-2999
300000-3500
Total Result
200000
300000-350000 250000-299999 - 100000
1% 3% 249999 -
6% 149999
10%
50000- 0-49999
99999 50000-99999
17% 100000-149999
200000-249999
250000-299999
300000-350000
Total Result

100000
-
149999
10%
Count of Base Salary Gender
Years F M
2018 14 3 3
2019 2 6
2020 12 5 7
2021 2 7
2022 10 3 5

2020; 7
2023 4 2
8
2024 1
M
Gender F

2021; 7

2022; 5
6
2019; 6

2023; 2
2018; 3

2020; 5

2023; 4
2018; 3

2022; 3
2
2019; 2

2021; 2

2024; 1
0
2018 2019 2020 2021 2022 2023 2024
S.No. Name Gender Department Region Designation Level Base Salary
1 Aanchal Sangwan F Sales & Mktg South GM L2 350,000
2 Aditi Varshney F Sales & Mktg Central Executive L8 32,700
3 Ankit Rai M Sales & Mktg South Sr Mgr L4 135,000
4 Ankit Tiwari M Finance East Manager L5 82,100
5 Aquib Khan M Sales & Mktg West Manager L5 77,500
6 Aradhana Chauhan F Finance South Manager L6 80,600
7 Ashutosh Kumar M Admin Central Sr Mgr L5 125,100
8 Ashutosh Pathak M Sales & Mktg North Manager L5 79,300
9 Ayushi Verma F Corporate Central Sr Mgr L5 122,700
10 Bavita Chaudhary F Corporate East Sr Mgr L5 111,900
11 Chetan Gupta M Corporate North VP L3 233,900
12 Deepu Singh Amit Sin M IT North Sr Mgr L4 130,800
13 Dhruv Tomar M Purchase East Manager L5 82,100
14 Divaker Sharma M Admin West Sr Mgr L4 118,200
15 Gaurav Agrawal M Purchase North Sr Mgr L4 125,000
16 Gaurav Yadav M Admin South Executive L8 34,200
17 Ghalib Gheyas M Admin South Sr Mgr L4 132,800
18 Govind Kumar M Sales & Mktg Central Manager L5 79,100
19 Javed Alam M Operations East GM L2 291,500
20 Mansi Gopal Ji Singh F Operations West Asst Manager L6 45,300
21 Manya Chaturvedi F IT East Executive L7 32,700
22 Md Sarvar Alam M Operations East VP L4 221,400
23 Mohd Ainan Najam M Sales & Mktg West Manager L5 81,400
24 Naman Varshney M IT East Manager L5 81,000
25 Nivesh Agrawal M Logistics East Asst Manager L6 48,300
26 Padma F Logistics North GM L2 281,000
27 Parul Yadav F Finance North Manager L5 84,500
28 Payal Chauhan F Sales & Mktg Central Manager L5 84,600
29 Pooja Kumari F Sales & Mktg North Manager L6 77,500
30 Pooja Verma F Finance West GM L3 294,600
31 Poonam Verma F Logistics West VP L3 220,600
32 Pranjul Sharma M Finance South Manager L6 79,900
33 Prashant Kumar Yadav M Logistics West Executive L8 33,800
34 Pratibha Chaturvedi F Logistics West Executive L7 33,500
35 Radha Upadhyay F HR North Executive L7 34,100
36 Rashmi Bisht F Finance South Asst Manager L6 49,800
37 Rishabh Paliwal M HR North Asst Manager L6 42,100
38 Rishi Dev Tripathi M Finance South VP L3 237,000
39 Rishikesh Ranjan M HR South Manager L6 76,200
40 Sanjeev Biswas M Finance Central Manager L5 79,300
41 Sapna Singh F Sales & Mktg Central VP L3 222,400
42 Satyam Pandey M IT East Asst Manager L6 43,500
43 Shivani Sisodiya F HR West Sr Mgr L4 132,600
44 Soumya Sharma F Operations Central Executive L7 34,200
45 Surya Prakash Gupta M IT Central Asst Manager L6 46,000
46 Tejasvi Bhargava M Operations South Manager L5 81,500
47 Utkarsh Gupta M Operations West Manager L5 84,000
48 Vikram Anand M IT Central VP L3 235,100
49 Vishnu Shukla M IT East Sr Mgr L4 126,400
50 Yukta Paliwal F Corporate North Manager L5 84,700
DOJ
10-Mar-18
2-Jan-24
17-Mar-20
23-Apr-21
19-Oct-21
9-Feb-21
8-Feb-20
14-Aug-20
27-Jul-20
25-Apr-20
20-Oct-18
1-Oct-19
6-Sep-21
27-Dec-19
19-Feb-20
29-Jun-23
4-Oct-19
19-Jul-21
27-Apr-18
27-Jul-22
28-Aug-23
9-Jun-19
13-Jun-21
14-Sep-20
4-Apr-22
3-Feb-18
12-Aug-21
21-Oct-20
1-Mar-22
11-Jun-18
26-Jun-19
2-Sep-20
20-Dec-23
23-Apr-23
19-May-23
30-Sep-22
24-Aug-22
14-Feb-19
18-Aug-21
22-Dec-21
22-Sep-19
19-Oct-22
18-Jun-20
9-May-23
13-Aug-22
 4-Mar-22
13-Oct-20
4-Jul-18
8-Dec-19
30-Nov-20
 EMPLOYEE DATA
GENDER RATIO REGION WISE DEPARTMENT W
F 7000000
20%
6000000

5000000

4000000
Total Result
50%
3000000

2000000

1000000
M
30%
0
Central East North South

FILTERS COUNT OF PEOPLE IN SAL

This shape represents a slicer. Slicers are supported in Excel 2010 or later.
0-
49999
If the shape was modified in an earlier version of Excel, or if the workbook 13%
was saved in Excel 2003 or earlier, the slicer cannot be used.

Total Result
50%
Timeline: Works in Excel or higher. Do not move or resize.

200
300000-350000 250000-299999 -
1% 3% 2499
6%
 EMPLOYEE DATA DASHBOARD
N WISE DEPARTMENT WISE TOTAL SALARY DESIGNATION WISE AVERAGE SALARY OF M/F

231,850
VP
221,500

127,614
Sr Mgr
Sales & Mktg 122,400
M
Purchase
80,283
Operations Manager
Logistics 82,380
IT 291,500
HR GM
308,533
Finance
Corporate 34,000
Department Admin Executive
33,440

44,975
Asst Manager
47,550

entral East North South West Total - 50,000 100,000 150,000 200,000 250,000 300,000
Result

OUNT OF PEOPLE IN SALARY GROUPS NO.OF MALES/FEMALES WITH THE DATE OF JOIN
14
0-
49999
13% 12

10

2020; 7
50000- 0-49999
99999 50000-99999 8
ult
17% 100000-149999
200000-249999

2021; 7

2022; 5
100000 6
2019; 6

2023; 2
- 250000-299999
2018; 3

149999 300000-350000
10% 4
Total Result
2020; 5

200000

2023; 4
2018; 3

2022; 3
000-350000 250000-299999 - 2
2019; 2

2021; 2

1% 3% 249999
6%
0
2018 2019 2020 2021 2022 2023
VERAGE SALARY OF M/F

500
8,533

0,000 200,000 250,000 300,000 350,000

WITH THE DATE OF JOINING

M
2021; 7

2022; 5

Gender F
2023; 2
2023; 4
2022; 3
2021; 2

2024; 1

20 2021 2022 2023 2024