How to make salary structure of Rs.13000 Per Month?

Hello, i am vikas - recently join small company. please tell me how i can make salary structure of Rs 13000/- 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 calculated or used formula for special allowance and bonus? - Prashanth

Particulars Amount Rs. (Per month) Amount Rs. (Per annum)
Basic 4550 54600
H R A 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 %ages you have used to calculate the components Divya?

What are the %ages you have used to calculate the components Divya?

Prashant B Ingawale can you tell me what are % use ?

Particulars Amount Rs. (Per month) Amount Rs. (Per annum)
Basic =B9*35% =B2*12
H R A =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

Divya Mishra can you share the excel working sheet.