Salary Break Up In Different Slabs - Xls Download

Hi Seema,
Very informative for new HR professionals. Can u pl guide me hw did u calculate the PF, ESI, Ex gratia & IT
Regards
Deep

Hi Seema ! :lol:
Thanx a million, apart, could u help me out on the salary slab for a SME. The company working is a 15+ Cr. Turnover Engineering organisation with ISO9001:2000 certification.
The managment have asked me to provide them the salary slab for the various job positions in our organisation, viz., how much has to pay in the starting, increments/pay revision in an year.
How much has to pay for fresher, of 1 year/2 yr/3 yr/4 yr/5 yr; 5 - 10 yr, 10 - 15 yr & 15-20 yr experience ?
I shall be posting the same after sorting out the positions in the forum.
Hope u'll guide me on this
rgds
HRP

hai
60% of Gross should be in basic
40% of basic should be HRA depending on Class of city
Rest all amount can be bifurcated into different heads such as all purpose allowance ,special allowance, retaining allowance etc.
for tax exception against reimburusement
Rs750/- Books and periodicals
Rs.1250/-Medical Allowances
Rs.5000/-Driver Salary
Rs. 1500/- Food allowances
Rs.4000/- or so for conveyance expenses
Telephone /mobile bills
Electricity /water bills

Hello Seema,
Nice working !!!!!
One has to make small changes considering recent bonus implications upto Rs. 10000.00 as per recent notifications
Do you have any gradation and salary scales with designations etc. I will be happy if i get some inputs.
Thank you
Divyang

Hi Shobhini,
Here is the tax calculation
Hope this will help you....
Regards,
Seema

Hi ,
What Phanikanth say is correct add Graduit in Labilites and Proff Ded in Deduction and one more thing can be added in deduction is for Insurance and Canteen.
PF is from basic salary @ 12 % EPF is from the basic 6500 % that is it will be Rs.541/- only for Pension scheme.
Lavanya

Hi Seema,
I have gone through the break up. I seems fine but wanted to know why you haven't added the reinburse amount, you could have actually added it in the CTC and then show it in the deductions.
More over wanted to know what is the percentage of employee and employer contribution towards ESIC you have taken.
Regards,
Babita Rajan

Hi Babita,
ESI is contributed from both the sides Employee as well as Employer.
It is been calculated on the basis of Gross salary per month and the maximum ceiling is 10000 Rs./Month.
The contribution from both the sides is as below-
Employee Side- 1.75% of gross/month
So if gross of an employee is 8000/month then
ESI contribution would be 8000*1.75% = 140 Rupees
Employer side- 4.75% of gross/month
ESI contribution would be 8000* 4.75% = 380 Rupees.
Regards,
Amit Seth.

Dear Seema
insert a row for gratuity @4.88%, and, FBT rates are 6% on total reimbursement. (for the reimbursement heads you have selected) Company can even recover the FBT if its a big amount for the organisation, or may consider as pART OF ctc.
regards
Prasoon

Can some one help me in
Tax exemption limit / Proportion of % for tax on Books and periodicals, Fuel Reimbursement,Uniform allowance, washing allowance,education and child tuition Telephone and mobile reimbursement while making an offer to new candidate.
rgds