At the bottom of every scenario and budget, you'll see several totals.
Here's what they all mean:
- Employee Count (ee count) - The number of employees you have in your scenario.
- Current Wages - If everyone in this scenario made their current wages for an entire year. It is an annualized number that has nothing to do with your start and end dates that you assigned to the scenario.
- C. Ratio - The average compa ratio of all employees in the scenario, based on their current wages.
- Increase - The difference between “New Wages” and “Current Wages.”
- New Wages - If everyone in this scenario made their new wages for an entire year. Again, it is an annualized number that has nothing to do with your start and end dates that you assigned to the scenario.
- Adj. New Wages - This total takes into consideration your start date, end date, and custom date/employee anniversary (depending on which you selected). It gives you the total you will actually spend, given that part of the year will be spent at old wages, and part of the time will be spent at new wages.
- Adj. Increase - This total also takes into consideration your start date, end date, and custom date/employee anniversary. It looks at the amount of time you accounted for in your scenario, how much it would cost to pay everyone at your current wages for that amount of time, and the difference between that number, and your adjusted new wages number.
- Proj. C. Ratio - The average compa ratio of your employees after these increases.
Let's look at an example
John Doe makes $10,000, has a midpoint of $15,000 and he qualified for a 10% raise. The budget year is from January 1 – December 31. The effective date is July 1. Here are what his totals would look like:
Employee Count | Current Wages | C. Ratio | Increase | New Wages | Adj. New Wages | Adj. Increase | Proj. C. Ratio |
1 | $10,000 | 66.67% | $1,000 (10%) | $11,000 | $10,500 | $500 | 73.33% |
Adjusted New Wages and Adjusted Increase take into consideration that John Doe would make $10,000 from Jan 1 – June 30, and would make $11,000 from July 1 – December 31.