HR Budget Format in Excel Sheet
Please find attached an Excel Format for HR Budget.
| DEPT :HR | |||||||||||||
| Recruitment Expenses (Staff, Executives, Managers) | |||||||||||||
| Value in Rupees | |||||||||||||
| PARTICUALRS | Jan’04 | Feb’04 | Mar’04 | Apr’04 | May’04 | Jun’04 | Jul’04 | Aug’04 | Sep’04 | Oct’04 | Nov’04 | Dec’04 | TOTAL |
| Consultants | |||||||||||||
| We have filled up 13 positions in last year (4 exe & 9 staff) (6 thru consultants & 7 thru referals & Data Base) | |||||||||||||
| (out of 13 / 9 new positions & 4 replacements) | |||||||||||||
| Consultants fees approx. 8.33 % of annual fringe | |||||||||||||
| Ave. salary of Staff = Rs.6500/- x 15 % hike = 7475/- x 12 = 89700/- x 8.33 % =7472 x 9 positions = 67248 X 45 % thru consultans = Rs.30260/- | 30260 | ||||||||||||
| Ave. salary of exe. = Rs.12125/- x 15 % hike = 13,945/- x 12 = 167340 x 8.33 % = 13939 x 4 positions =55757 x 45 % thru consultans = Rs.25090 | 25090 | ||||||||||||
| Naukri.com | |||||||||||||
| Registration of 5 Hot Jobs | 9000 | ||||||||||||
| TOTAL | 64350 | ||||||||||||
| DEPT :HR | |||||||||||||
| Recruitment Expenses (Staff, Executives, Managers) | |||||||||||||
| Value in Rupees | |||||||||||||
| PARTICUALRS | Jan’04 | Feb’04 | Mar’04 | Apr’04 | May’04 | Jun’04 | Jul’04 | Aug’04 | Sep’04 | Oct’04 | Nov’04 | Dec’04 | TOTAL |
| Consultants | |||||||||||||
| We have filled up 13 positions in last year (4 exe & 9 staff) (6 thru consultants & 7 thru referals & Data Base) | |||||||||||||
| (out of 13 / 9 new positions & 4 replacements) | |||||||||||||
| Consultants fees approx. 8.33 % of annual fringe | |||||||||||||
| Ave. salary of Staff = Rs.6500/- x 15 % hike = 7475/- x 12 = 89700/- x 8.33 % =7472 x 9 positions = 67248 X 45 % thru consultans = Rs.30260/- | 30260 | ||||||||||||
| Ave. salary of exe. = Rs.12125/- x 15 % hike = 13,945/- x 12 = 167340 x 8.33 % = 13939 x 4 positions =55757 x 45 % thru consultans = Rs.25090 | 25090 | ||||||||||||
| Naukri.com | |||||||||||||
| Registration of 5 Hot Jobs | 9000 | ||||||||||||
| TOTAL | 64350
|
||||||||||||
Click Here To Download HR Budget Format