Sample HR Budget Spreadsheet
Plan HR budget on yearly basis. All expenses related with pay roll divided into two major divisions like direct expenses & Indirect expenses.
In direct expenses take salary -all forms, esi, epf contributions involved by the employer,staff duty meal,training and development etc.
In In-direct expenses take staff welfare, uniform, insurance,annual day, bonus,gratuity, lave salary etc. All expenses to be projected accurately by HR head and presented to the Management for approval.
In this capital expenses to be projected separately for example some thing to be purchased as first time like computer, cafeteria kitchen equipments etc.
Just go through the attachment file which will suit with your requirements.
| #REF! | Proposed Expenditure for | ||||||||||||||||
| Till Dec’08 | Till Dec’09 | variance | variance | Particulars | 2010 APRIL | 2010 MAY | 2010 JUNE | 2010 JULY | 2010 AUG | 2010 SEPTEM | 2010 OCTO | 2010 NOVEM | 2010 DECEM | 2011 JAN. | 2011 FEB | 2011 MAR | TOTAL FY 2010-11 |
| Rs. Lacs | Rs. Lacs | Rs. Lacs | % | Rs. Lacs | Rs. Lacs | Rs. Lacs | Rs. Lacs | Rs. Lacs | Rs. Lacs | Rs. Lacs | Rs. Lacs | Rs. Lacs | Rs. Lacs | Rs. Lacs | Rs. Lacs | Rs. Lacs | |
| DIRECT SALARY | |||||||||||||||||
| Salary – Direct | |||||||||||||||||
| Salary-Deputation | |||||||||||||||||
| Casuals | |||||||||||||||||
| Co’s Contribution to PF | |||||||||||||||||
| Co’s Contribution to ESI | |||||||||||||||||
| Outsourcing (Incl Gardening) | |||||||||||||||||
| Staff Duty Meal | |||||||||||||||||
| Uniforms | |||||||||||||||||
| Recruitment/Training | |||||||||||||||||
| Sub-Total | |||||||||||||||||
| INDIRECT SALARY | |||||||||||||||||
| Bonus/ Exgratia | |||||||||||||||||
| Leave Encashment | |||||||||||||||||
| Medical Reimbursement | |||||||||||||||||
| Leave Travel Allowance | |||||||||||||||||
| Trainees Stipend | |||||||||||||||||
| Medical check up | |||||||||||||||||
| Staff Welfare | |||||||||||||||||
| Gratuity | |||||||||||||||||
| Staff Accommodation | |||||||||||||||||
| Sub-Total | |||||||||||||||||
| Total | |||||||||||||||||
Click Here To Download Prepare HR Budget