HR Budget (Costing) template

This template calculate the budgeted cost of a fixed staff establishment (HR budget) in a small – to medium size enterprise. The template considers the following inputs to calculate budgeted cost:

1. Basic salary and annual increments. (The template calculates ICOS [improvement in conditions of service]).

2. Service bonus.

3. Pension fund contributions.

4. Medical aid contributions

5. Travel and accommodation allowances.

6. Vehicle allowances.

7. Entertainment allowances.

8. Labour allowances.

9. Unemployment insurance cost.

10. Statutory provisions.

11. Other HR-related cost.

The template also alignment budget estimates with annual cash flow periods (months). It further align HR cost with the main components (departments and divisions) on the staff establishment of the organisation.

The template produces the following reports:

1. A detailed summary of estimated HR costs.

2. A report of cash flow projections (estimates).

3. A summary report of HR budgeted cost.

4. A report of HR costs by main department and divisions.

The template has been designed for practitioners involved in (and responsible for) calculating employee costs based on posts on an organisational staff establishment. It is best suited for organisations or enterprises with up to 15 main departments or divisions on the organisational structure and not more than 150 posts on the staff establishment.