CTC Design - let me know if I have done it correctly or not - RAR Download

I have attached a document in which I have prepared Attendance sheet for ten employees and also designed CTC for 2 employees. And some Queries are also put into the sheet please help me in this..... Please check the sheet once and as I am doing it for first time so please let me know if I have done it correctly or not ( or please mention if I am wrong anywhere ).

Hi,
Please attach your file one more time, this attachment is not opening.

Hello Aditya,
Here I have attached the file again .
And looking for your feedback so that I can improve my work..
Thanks

Hi Maya,
I have seen your attachment
1. when you dont know the gross that time take CTC and devide by 12
2. take employer contributions
3. and use this formula
Gross = Monthly CTC-Employer Contribution
2.ESI ceiling limit is 15000
3. Same formula for sepaerating Employer Contribution from CTC
Gross= CTC-Employer contribution
4.Yes Graduity is only employer contribution and contribuion rate is 4.81% of basic

Hi Aditya
Thank you for your reply.
I got your point. Please also mention whether I have designed the Salary structure correctly or not ??????
Also please mention the improvement area ????????
How to calculate TDS and PT ???????
Regards
Priyanka

Hi,
You have designed salary strucher correctly.
PT is on total earnings of particular month
If your working in Maharashtra then PT slab
5000 - Nil
5001 to 10000 - 175
10001 and above - 200 and for Feb Month 300

Hi,
professional Tax (PT) varies between each states (of India) and, in a state, between the local governance systems (like Municipal Corporation, Panchayat etc). As per your state norms check for PT slab.
For TDS, download the tax calculator as link provided below. Explanation also available in the tax calculator
Nithya's Tax Calculator
regs
Narayan

Hi Priyanka,
Enclosing herewith the CTC Calculator which shall help you a lot to understand it.
Regards,
Pushkar

ECN aaaa
FINAL GRADE 5
PAYROLL LOCATION OTHERS
VEHICLE N
DEPENDENT (IF CHILD) Y
ANNUAL CTC 600000
MONTHLY CTC 50000
BASIC 25000
HRA 13056
TRANSPORT ALLOWANCE 800
CHILD EDUCATION ALLOWANCE 200
CITY ALLOWANCE (IF ANY) 0
SPECIAL ALLOWANCE 0
MONTHLY GROSS 39056
HELPER ALLOWANCE 0
BUSINESS ATTIRE 5000
MEDICAL 1042
BONUS 700
EMPLOYER'S PF 3000
MONTHLY GRATUITY 1202
ANNUAL CTC 600000
MONTHLY CTC 50000