Salary calculator

[avisoft20]

Hello,

I want Calculate my salary .table given below

Condition :

PF =Y/N
PF Limit =15000
PF% =12%
EDLI % =1.36%
ESIC =21000
ESI % Employee=1.75%
ESI % Employer = 4.75%

Gross Salary=15000
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD="align: center"]Earnings [/TD]
[TD][TABLE="width: 55"]
<tbody>[TR]
[TD="class: xl65, width: 55, align: center"]Amount[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 163"]
<tbody>[TR]
[TD="class: xl65, width: 163, align: center"]Deductions [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 60"]
<tbody>[TR]
[TD="class: xl65, width: 60, align: center"]Amount[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]Basic [/TD]
[TD][/TD]
[TD]P.F.Contribution[/TD]
[TD="align: center"]A[/TD]
[/TR]
[TR]
[TD]HRA [/TD]
[TD="align: center"][/TD]
[TD]E.S.I.C.Contribution[/TD]
[TD="align: center"]B[/TD]
[/TR]
[TR]
[TD]Conveyance[/TD]
[TD="align: center"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 163"]
<tbody>[TR]
[TD="class: xl65, width: 163"]Gross Salary[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][/TD]
[TD][TABLE="width: 163"]
<tbody>[TR]
[TD="class: xl65, width: 163"]Total Deductions [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]A+2[/TD]
[/TR]
[TR]
[TD][TABLE="width: 163"]
<tbody>[TR]
[TD="class: xl65, width: 163"]Take Home of Salary [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]P.F.Employer[/TD]
[TD="align: center"][/TD]
[TD]P.F.Employer[/TD]
[TD="align: center"]C[/TD]
[/TR]
[TR]
[TD]EDLI 1.36% P.F. Employer[/TD]
[TD="align: center"][/TD]
[TD]EDLI 1.36% P.F. Employer[/TD]
[TD="align: center"]D[/TD]
[/TR]
[TR]
[TD]E.S.I.C. Employer[/TD]
[TD="align: center"][/TD]
[TD][TABLE="width: 163"]
<tbody>[TR]
[TD="class: xl65, width: 163"]E.S.I.C.Employer[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]E[/TD]
[/TR]
[TR]
[TD]Gross CTC[/TD]
[TD="align: center"]Manual fill.[/TD]
[TD][TABLE="width: 163"]
<tbody>[TR]
[TD="class: xl65, width: 163"]Total Deductions [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]C+D+E[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]



1.How to calculate Basic ?
2.How to calculate HRA ?
3.How to calculate convance ?
4.PF Employer ?
5.How to calculate EDIL 1.36% P.F Employer ?
6.How to calculate E.S.I.C ?

 

[avisoft20]

Hello,

I want Calculate my salary .table given below

Condition :

PF =Y/N
PF Limit =15000
PF% =12%
EDLI % =1.36%
ESIC =21000
ESI % Employee=1.75%
ESI % Employer = 4.75%

Gross Salary=15000
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD="align: center"]Earnings [/TD]
[TD][TABLE="width: 55"]
<tbody>[TR]
[TD="class: xl65, width: 55, align: center"]Amount[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 163"]
<tbody>[TR]
[TD="class: xl65, width: 163, align: center"]Deductions [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 60"]
<tbody>[TR]
[TD="class: xl65, width: 60, align: center"]Amount[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]Basic[/TD]
[TD][/TD]
[TD]P.F.Contribution[/TD]
[TD="align: center"]A[/TD]
[/TR]
[TR]
[TD]HRA[/TD]
[TD="align: center"][/TD]
[TD]E.S.I.C.Contribution[/TD]
[TD="align: center"]B[/TD]
[/TR]
[TR]
[TD]Conveyance[/TD]
[TD="align: center"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 163"]
<tbody>[TR]
[TD="class: xl65, width: 163"]Gross Salary[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][/TD]
[TD][TABLE="width: 163"]
<tbody>[TR]
[TD="class: xl65, width: 163"]Total Deductions [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]A+2[/TD]
[/TR]
[TR]
[TD][TABLE="width: 163"]
<tbody>[TR]
[TD="class: xl65, width: 163"]Take Home of Salary [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]P.F.Employer[/TD]
[TD="align: center"][/TD]
[TD]P.F.Employer[/TD]
[TD="align: center"]C[/TD]
[/TR]
[TR]
[TD]EDLI 1.36% P.F. Employer[/TD]
[TD="align: center"][/TD]
[TD]EDLI 1.36% P.F. Employer[/TD]
[TD="align: center"]D[/TD]
[/TR]
[TR]
[TD]E.S.I.C. Employer[/TD]
[TD="align: center"][/TD]
[TD][TABLE="width: 163"]
<tbody>[TR]
[TD="class: xl65, width: 163"]E.S.I.C.Employer[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]E[/TD]
[/TR]
[TR]
[TD]Gross CTC[/TD]
[TD="align: center"]Manual fill.[/TD]
[TD][TABLE="width: 163"]
<tbody>[TR]
[TD="class: xl65, width: 163"]Total Deductions [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]C+D+E[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]



1.How to calculate Basic ?
2.How to calculate HRA ?
3.How to calculate convance ?
4.PF Employer ?
5.How to calculate EDIL 1.36% P.F Employer ?
6.How to calculate E.S.I.C ?

https://drive.google.com/open?id=0B17z_s6IAc2KNUpIZkx0Wm9GRG8

 

[avisoft20]

anybody can help me pls.