Scribd
Upload
2 views4 pages

Employee Salary Breakdown and Analysis

The document contains a salary breakdown for ten employees, detailing their basic salary, transportation allowance (TA), dearness allowance (DA), house rent allowance (HRA), and provident fund (CPF). Each employee's gross salary is also provided. The data is organized in a tabular format across multiple pages.

Uploaded by

sanoopswarup578
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as ODS, PDF, TXT or read online on Scribd
2 views4 pages

Employee Salary Breakdown and Analysis

The document contains a salary breakdown for ten employees, detailing their basic salary, transportation allowance (TA), dearness allowance (DA), house rent allowance (HRA), and provident fund (CPF). Each employee's gross salary is also provided. The data is organized in a tabular format across multiple pages.

Uploaded by

sanoopswarup578
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as ODS, PDF, TXT or read online on Scribd

Sheet1

S no. Name Basic Salary TA(6%) DA(14%) HRA(10%) CPF(3%)


1 Amit 12000 720 1680 1200 360
2 Manu 9000 540 1260 900 270
3 Ramesh 15000 900 2100 1500 450
4 Santosh 8500 510 1190 850 255
5 Suresh 15600 936 2184 1560 468
6 Hareesh 9800 588 1372 980 294
7 Maneesh 16500 990 2310 1650 495
8 Mukesh 14600 876 2044 1460 438
9 Ganesh 14900 894 2086 1490 447
10 Sumesh 12800 768 1792 1280 384

Salary of employees
25000

20000
CPF(3%)
15000 Basic Salary
TA(6%)
DA(14%)
10000
HRA(10%)
Gross Salary
5000

0
it u h sh sh sh h h h h
A m an es to re ee ees k es nes es
M m n u r a m
Ra Sa S Ha an M
u
G Su
M

Page 1
Sheet1

Gross Salary
15960
11970
19950
11305
20748
13034
21945
19418
19817
17024

CPF(3%)
Basic Salary
TA(6%)
DA(14%)
HRA(10%)
Gross Salary

h
es
m
Su

Page 2
Sheet1

Page 3
Sheet1

Page 4

You might also like