Salary Structure For 12,000/- - Xls Download

hi all friends,
i want a salary structure for Rs 12,000/- per month. the employee working in BPO/KPO as a HR Assistant. no telephone bill and no petrol or Travell allowance
Regards
Ram

Hi Ram,
Salary Structure for Rs.12,000/- is
Basic - 40% on Gross
HRA - 40% for Non Metros and 50% for Metros
Conveyance - 800/- Fixed permonth
Remainig Other Allowance
Regards
T. Sivakumar

Dear N. Rambabu,
I have attached herewith salary annexure excel format. this may help you.
You can only enter values in yellow cells.

Hi,
split the salary to get the benifits.
CTC12000Basic 35%4200HRA (Basic 40%)1680Con800Medical1250employer pf 12%0Child Edu Chess200Personal pay3870Gross Salary12000PF 12%504PT150ESI210864Take Home11136
regards
prabhakar

suhaskhambe's worksheet is a protected simple worksheet and is unnecessarily made complicated by hiding the the cell values. I do not think any great adventure in hiding and protecting such a simple worksheet.
Shivakumar has made things simple for Rambabu. He has shown only Salary and not CTC, as desired by Rambabu. Well done.

Dear Mr. Rambabu,
Appended is the salary structure for Rs.12000 (not to be regarded as exhaustive)

Dear friend,
Please see the structure as required.
V. BALAJI

hi balaji
thanks for the details.
im in process to restructure the salary components which are helpful to employee & employer.
attendance allowance & performance allowance, does it have any limit?
not sure but allowances are taxable?
also would like to know what is EDN
regds
manish

hi friends,
Can u explain about gratuity and Annuity fund??Is it compulasaory in private firms?
regards
vidya

There is no limit to imagination. There are thousands of ways to arrive at Gross 12000. It all depend upon how you follow the rules and what is the policy. It just amaze me when people calculate DA @ 50% of the basic. Is DA a static thing? According to me DA is linked to consumers Price Index and it is very very volatile. How can one fix the %age of DA.
If you cannot do justice with the different components of the Salary, keep it lump-sum 12000.