hi friend please help me this is detail of employee .i have to prepare a excell sheet for this pay roll .it's my assignment .kindly help me friends ...i tryed but i dont know how to deduct hra etc all the pay roll deduction ...if u can please help me ..my id is jai.sap(at rate of )yahoocom
a . head 6 to 8 members cts is 600000-800000
b. assistant manager -12 members -400000-600000
c.engineers -12 members -200000-400000
d. supervisor -30 members -100000-200000
e.unskilled -20 members- less than 100000
sir i done one pay roll for A
gross salary is 50000
basic 15000 50000*30/100
hra 10000 50000*20/100
city compensation 15000 50000*30/100
conveyance all 9600 800 per month
99600
deduction
esi employee 875 50000*1.75%
esi employer 2375 50000*4.75%
epf employer 6000 50000*12/100
epf employee 6000 50000*12/100
salary is 84350
is this right friends ...is this way we put pay roll for individual ?
From India, Karur
a . head 6 to 8 members cts is 600000-800000
b. assistant manager -12 members -400000-600000
c.engineers -12 members -200000-400000
d. supervisor -30 members -100000-200000
e.unskilled -20 members- less than 100000
sir i done one pay roll for A
gross salary is 50000
basic 15000 50000*30/100
hra 10000 50000*20/100
city compensation 15000 50000*30/100
conveyance all 9600 800 per month
99600
deduction
esi employee 875 50000*1.75%
esi employer 2375 50000*4.75%
epf employer 6000 50000*12/100
epf employee 6000 50000*12/100
salary is 84350
is this right friends ...is this way we put pay roll for individual ?
From India, Karur
Subject - Re: Ctc
hi friend please help me this is detail of employee .i have to prepare a excell sheet for this pay roll .it's my assignment .kindly help me friends ...i tryed but i dont know how to deduct hra etc all the pay roll deduction ...if u can please help me ..my id is jai.sap(at rate of )yahoocom
a . head 6 to 8 members cts is 600000-800000
b. assistant manager -12 members -400000-600000
c.engineers -12 members -200000-400000
d. supervisor -30 members -100000-200000
e.unskilled -20 members- less than 100000
sir i done one pay roll for A
gross salary is 50000
basic 15000 50000*30/100
hra 10000 50000*20/100
city compensation 15000 50000*30/100
conveyance all 9600 800 per month
99600
deduction
esi employee 875 50000*1.75%
esi employer 2375 50000*4.75%
epf employer 6000 50000*12/100
epf employee 6000 50000*12/100
salary is 84350
is this right friends ...is this way we put pay roll for individual ?
From India, Karur
hi friend please help me this is detail of employee .i have to prepare a excell sheet for this pay roll .it's my assignment .kindly help me friends ...i tryed but i dont know how to deduct hra etc all the pay roll deduction ...if u can please help me ..my id is jai.sap(at rate of )yahoocom
a . head 6 to 8 members cts is 600000-800000
b. assistant manager -12 members -400000-600000
c.engineers -12 members -200000-400000
d. supervisor -30 members -100000-200000
e.unskilled -20 members- less than 100000
sir i done one pay roll for A
gross salary is 50000
basic 15000 50000*30/100
hra 10000 50000*20/100
city compensation 15000 50000*30/100
conveyance all 9600 800 per month
99600
deduction
esi employee 875 50000*1.75%
esi employer 2375 50000*4.75%
epf employer 6000 50000*12/100
epf employee 6000 50000*12/100
salary is 84350
is this right friends ...is this way we put pay roll for individual ?
From India, Karur
if we see the global economy, there are several developed countries where pension schemes have failed.
example california public employees retirement system
we are also in a state of flux..
from defined benefits to defined contribution....
due to lack of transparency/ infrastructure etc in developing countries, returns are higher in developing countries Vis a vis the developed nations ( see the metro financing at 4% pa and that also involves a moratorium till a critical point is reached)..
mathematically admin charges can be added up
but then the premise is faulty or inadequate:
as we do not discount for other costs like IT/ telecom/ process costs..
From India, Delhi
41example california public employees retirement system
we are also in a state of flux..
from defined benefits to defined contribution....
due to lack of transparency/ infrastructure etc in developing countries, returns are higher in developing countries Vis a vis the developed nations ( see the metro financing at 4% pa and that also involves a moratorium till a critical point is reached)..
mathematically admin charges can be added up
but then the premise is faulty or inadequate:
as we do not discount for other costs like IT/ telecom/ process costs..
From India, Delhi
Find answers from people who have previously dealt with business and work issues similar to yours - Please Register and Log In to CiteHR and post your query.
CTC Calculator.xls