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
|
Categories: HR Tags: HR Budget Format