Calculate Profit in the Time Control Report

In this FAQ, we will cover the following topics:

1. Create a Time Control Report

2. Calculate Profit

2.1 Formula Used

2.2 Definition of Calculation Elements

3. How does GEM-CAR perform this calculation automatically?

1. Create a Time Control Report

To generate a time control report, click on Human Resources > Reports > Control Time.

Then, enter the following information:

• Employee
• Jobs
• Type
• Start date
• End date
• Order by

Click on Send.

You will receive a report containing the following information:

• Human Resources
• Bay
• Jobs
• Date
• Day
• Start
• End
• Total Time
• Task
• Planned Time
• Rate
• Cost
• Profit

2. Calculate Profit

The financial profit in GEM-CAR’s time tracking report is calculated by comparing the time estimated to complete a job with the time actually spent by the technician, then applying the hourly rate.

2.1 Formula Used

Financial profit = (planned time - actual time) x hourly rate

2.2 Definition of Calculation Elements

1. Planned Time (Scheduled Time)

• This is the time planned to complete a task.
• It is defined when the appointment or estimate is created.
• Example: a repair may be estimated at 6.00 hours.

2. Actual Time (Total Time)

• This is the time actually worked by the technician.
• It comes directly from the time clock.
• Example: the technician worked 25.17 hours.

3. Hourly Rate (Rate)

• This corresponds to the employee’s hourly cost (salary or internal cost).
• Example: $30.00/hour

Example

• Actual time = 25.17 h
• Hourly rate = $30.00

Cost Calculation:

Note: This amount corresponds to the “Cost” column.

Profit Calculation

Let’s suppose:

• Estimated time = 6.00 h
• Actual time = 25.17 h
• Rate = $30

Interpretation:

• If the result is negative → loss (the work took longer than expected)
• If the result is positive → profit (the work was completed faster than expected)

3. How does GEM-CAR perform this calculation automatically?

In GEM-CAR:

1. The system retrieves:

• The planned time from the appointment or estimate
• The actual time from employee time logs
• The hourly rate configured in the employee record

2. It automatically calculates:

• The cost = Actual time × rate
• The profit = (Scheduled time − Actual time) × rate

3. The results are displayed in the report:

• Total time → actual time
• Scheduled time → planned time
• Rate → hourly cost
• Cost → labor cost
• Profit → financial performance

Note:

• Estimated time measures expected performance
• Actual time measures actual performance
• Profit shows work efficiency

This is a key indicator for analyzing operational profitability and technician productivity.