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