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 ).
26th June 2014 From India, New Delhi

Attached Files (Download Requires Membership)

My_Assignment 1- CTC Design and Atte.rar (21.1 KB, 638 views)

Hi, Please attach your file one more time, this attachment is not opening.
26th June 2014 From India, Mumbai

Hello Aditya, Here I have attached the file again . And looking for your feedback so that I can improve my work.. Thanks
26th June 2014 From India, New Delhi

Attached Files (Download Requires Membership)

My_Assignment 1- CTC Design and Atte.zip (21.2 KB, 362 views)

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
26th June 2014 From India, Mumbai

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
26th June 2014 From India, New Delhi

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
27th June 2014 From India, Mumbai

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
27th June 2014 From India, Hyderabad

Hi Priyanka, Enclosing herewith the CTC Calculator which shall help you a lot to understand it. Regards, Pushkar
27th June 2014 From India, Delhi

Attached Files (Download Requires Membership)

CTC - Design Calculator.xls (33.5 KB, 1000 views)

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
27th June 2014 From India, Gurgaon