Skip to main content

Insights: Result per Employee

Written by Simplicate Support

The Result per employee report shows whether the selling value of an employee's hours is in a healthy ratio to the cost price. As long as the result is positive, the selling value of the hours covers the cost price; the closer to 0 or the further into the negative, the less the selling value covers.


Report structure

At the top is the filter bar; below it are the Average result in period chart, the Result per employee and Result per manager charts, and the Detail view (the table). The report expresses the result as percentages.


Average result in period

Tracks the trend of the total result across periods. This shows whether your employees' cost prices — for example due to salary changes — remain in balance with the selling rates. Write-offs also reduce the percentage: the selling value of the hours then comes out lower.


Result per employee

Compares the achieved result side by side per employee, so you can see whose selling value comfortably covers the cost price and whose result falls short.


Result per manager

Groups the same result per manager, so you can compare the picture at team level.


Detail view

The table shows the underlying figures per employee and how the result is composed. Use Columns to choose which columns are visible and use Export to download the data. Click through on an employee to see the result trend per employee and track the impact of cost price and rate changes.


Columns in the table


KPIs

KPI

Explanation

Cost price of scheduled hours

The cost price of all scheduled hours of the employee in the period.

Billable

The selling value of the billable hours.

Result

The billable value minus the cost price of the scheduled hours.

Result (percentage)

The result as a percentage of the billable value.


Dimensions

  • Employee


Filters

Use Add filter to add filters; use Reset filters to reset everything.


Dimensions

  • Period

  • Team

  • Manager

  • Employee


How the result is calculated

The result percentage per employee is calculated as follows:

(Billable − Cost price of scheduled hours) / Billable × 100%

Example: (1,000 − 300) / 1,000 × 100% = 70% result.
Example 2: (4,980 − 7,600) / 4,980 × 100% = −52.6% result.


Example with correction: an employee registers 20 hours on a time and expenses service at a selling rate of € 100, with a cost price of € 80 per hour. Of the 20 hours, 18 hours are invoiceable and 2 hours are written off.

Billable = 18 × € 100 = € 1,800.
Cost price of scheduled hours = 20 × € 80 = € 1,600.
((1,800 − 1,600) / 1,800) × 100 = 11.11% result.


Note: if an employee achieves a result of 100%, the full selling value of the registered hours is considered as the result. This likely means the employee's cost price has not been filled in in the schedule. The cost prices in this calculation go back up to 2 years.

Did this answer your question?