New to HR: How Do I Create a Salary Structure for Rs 13,000 Monthly?

Hello, I am Vikas, recently joined a small company. Please tell me how I can create a salary structure of Rs 13,000 per month.

Particulars Monthly (Rs.) Yearly ( Rs. )
Gross Pay Components

Basic Salary 5200 62400
House Rent Allowance 2080 24960
Special Allowance 2796 33552
Conveyance Allowance 1600 19200
Special Allowance 0 0
 A Monthly Total 11676 140112

Annual benefits
Medical Allowance* 0 0
Leave Traval Allowance** 0 0
Bonus** 700 8400
B Total Annual Benefit 700 8400

Annualized Retirals

Provident Fund - Employer Contribution 624 7488
 C Total Annualized Retirals 624 7488
Total Cost to Company (A+B+C) 13000 156000

How did you calculate or use the formula for special allowance and bonus? - Prashanth

Particulars | Amount Rs. (Per month) | Amount Rs. (Per annum)
Basic | 4550 | 54600
HRA | 2275 | 27300
Conveyance Allowance | 1600 | 19200
Medical Allowance | 1250 | 15000
LTA | 4000 | 48000
Employers' PF Contribution | 546 | 6552
Special Allowance | 0 | 0
Total Salary | 13000 | 156000
Employee PF Deduction | 546 | 6552
Employee ESI Deduction | 228 | 2730
TDS* | 0 | 0
Professional Tax | 200 | 2400
Total Deductions | 974 | 11682
Net Salary | 12027 | 144318

Particulars Amount Rs. (Per month) Amount Rs. (Per annum) Basic 4912 58949 H R A 2456 29474 Conveyance Allowance 1600 19200 Medical Allowance 1250 15000 LTA 4000 48000 Employers' PF Contribution 589 7074 Special Allowance 0 0 Total Salary 14035 168425 Employee PF Deduction 589 7074 Employee ESI Deduction 246 2947 TDS* 0 0 Professional Tax 200 2400 Total Deductions 1035 12421 Net Salary 13000 156004

This is for 13k in hand. The previous one was 13k as gross

What are the percentages you have used to calculate the components, Divya?

What are the percentages you have used to calculate the components, Divya?

Salary Structure Calculation

Particulars Amount Rs. (Per month) Amount Rs. (Per annum)

Basic =B9*35% =B2*12

HRA =B2/2 =B3*12

Conveyance Allowance =IF(B9-(B2+B3)>1600,1600,CB170-(B2+B3)) =B4*12

Medical Allowance =IF(B9-(B2+B3+B4)>1250,1250,B9-(B2+B3+B4)) =B5*12

LTA 4000 =B6*12

Employers' PF Contribution =IF(B2>=15000,1800,IF(B2<15000,B2*12%,0)) =B7*12

Special Allowance =IF(B9>(B2+B3+B4+B5+B6+B7),B9-(B2+B3+B4+B5+B6+B7),0) =B8*12

Total Salary =C9/12 156000

Employee PF Deduction =IF(B2>=15000,1800,IF(B2<15000,B2*12%,0)) =B10*12

Employee ESI Deduction =IF(B9<=21000,B9*1.75%,0) =B11*12

TDS* 0 0

Professional Tax 200 =B13*12

Total Deductions =B13+B11+B10 =B14*12

Net Salary =B9-B14 =C9-C14

Please review the corrected text for any further adjustments.