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
27th October 2010 From India, Hyderabad

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
27th October 2010 From India, Hyderabad

Dear N. Rambabu, I have attached herewith salary annexure excel format. this may help you. You can only enter values in yellow cells.
27th October 2010 From India, Mumbai

Attached Files (Download Requires Membership)

Salary Annexure.xls (37.0 KB, 15759 views)

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
28th October 2010 From India, Bangalore

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.
28th October 2010 From India, Chandigarh

Dear Mr. Rambabu, Appended is the salary structure for Rs.12000 (not to be regarded as exhaustive)
28th October 2010 From India, Mumbai

Attached Files (Download Requires Membership)

Salary calculation.xls (8.9 KB, 7370 views)

Dear friend, Please see the structure as required. V. BALAJI
29th October 2010 From India, Madras

Attached Files (Download Requires Membership)

salary structure-12 K.xls (20.0 KB, 6306 views)

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
29th October 2010 From India, New Delhi

hi friends, Can u explain about gratuity and Annuity fund??Is it compulasaory in private firms? regards vidya
29th October 2010 From India, Kottayam

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.
29th October 2010 From India, Chandigarh