Hi Chetana,
Calculating Salary Costs and Increases
Q. Can someone please help me to calculate:
The total salary cost
Average salary cost
Average salary increase in an organization.
Need the formulas.....
A. It's simple mathematics, and let me explain it this way:
1. Total salary cost: Be clear to add all the components of the salary, both monthly and annual; this includes insurance premiums and PF contributions by the company, et al. Add up all this for all employees to give the total salary cost.
2. Average salary cost: Once you have the total salary cost, divide this by the number of employees. Use the department-wise/location-wise, function-wise costs to be compared/benchmarked with other locations/industry standards.
3. Average salary increase:
a. Calculate (This year's total salary - previous year's total salary)
b. Divide a by this year's total salary.
c. Multiply the product by 100.
Voila, you would get the answer! Hope this helps you.
Cheerio,
Rajat Joshi