Knowledge Base

Project Profitability Report

  • 67views
  • February 7, 2024

Project Profitability Report

The Project Profitability Report displays the profitability and utilization of each employee, derived from the Timesheets generated.

To view this report, you can go to:

> Home > Projects > Reports > Project Profitability

This report shows the Project Profitability with the following data:

  • Timesheet
  • Salary Slip generated using the Timesheet
  • Sales Invoice generated using the Timesheet

Calculation of Utilization

The employee’s utilization is determined by calculating the total billed hours from the Timesheet, the working days from the Salary Slip, and the standard working hours from the HR Settings.

The formula for Utilization is as follows,

Utilization = Total Billed Hours / (Working Days * Standard Working Hours)

Calculation of Profit

The profit is computed based on the gross pay from the Salary Slip, the grand total from the Sales Invoice, and the utilization.

The formula for Profit is as follows,

Profit = Grand Total - Gross Pay * Utilization

Calculation of Fractional Cost

The fractional cost is determined based on the gross pay from the Salary Slip and utilization.

The formula for Fractional Cost is as follows,

Fractional Cost = Gross Pay * Utilization