Template:ManualDoc:P800199

From InfiniteERP Wiki
Jump to: navigation, search

The Project Profitability report is used to monitor the planned and real cost related to a project.

The following information is displayed on the report:

Planned Services and Expenses:

  • Revenue: the amount from the field Service Revenue on the multiphase project
  • Cost: the amount from the field Services Provided Cost on the multiphase project
  • Outsource: the amount from the field Outsourced Cost on the multiphase project
  • Margin%: the margin from the field Planned Service Margin % on the multiphase project. The planned service margin % is calculated using the formula: (Service Revenue - Services Provided Cost - Outsourced Cost) x 100/Service Revenue.
  • Reinvoicing: the amount from the field Reinvoiced Expenses on the multiphase project
  • Expenses: the amount from the field Planned Expenses on the multiphase project
  • Margin%: the margin from the field Planned Expenses Margin % on the multiphase project. The planned expenses margin % is calculated using the formula: (Reinvoiced Expenses - Planned Expenses) x 100/Reinvoiced Expenses.
  • Gross margin: overall planned margin for the project
    • Gross margin amount: calculated using the formula: (Service Revenue - Services Provided Cost - Outsourced Cost) + (Reinvoiced Expenses - Planned Expenses).
    • Gross margin percentage: calculated using the formula: ((Service Revenue - Services Provided Cost - Outsourced Cost) + (Reinvoiced Expenses - Planned Expenses)) x100/(Service Renevue + Reinvoiced Expenses)

Real Services and Expenses:

  • Revenue: cost reflected on sales invoices for the customer for:
    • reinvoicing of outsourced work by a third party.
    • invoicing of the cost for completed project phases.
    • only sales invoice lines with service type products will be taken into account.
  • Cost: cost of worked hours based on processed time sheets multiplied by the cost that is linked to the salary category of the employee at the expense date.
  • Outsource: cost of worked hours executed by a third party based on purchases invoices.
  • Margin%: real margin for services based on the formula: (Revenue - Cost -Outsource) x 100/Revenue
  • Reinvoicing: expenses invoiced to the customer on sales invoices for:
    • purchased goods related to the project
    • invoiceable item expenses.
    • only sales invoice lines with products whose type is not service will be taken into account.
  • Expenses: real expenses based on purchase invoices for:
    • purchased goods related to the project from a vendor
    • reimbursement for item expenses for an employee.
  • Margin%: real margin for expenses based on the formula: (Reinvoicing - Expenses) x 100/Reinvoicing
  • Gross margin: overall real margin for the project.
    • Gross margin amount: calculated using the formula: (Revenue - Cost - Outsource) + (Reinvoicing - Expenses)
    • Gross margin percentage: calculated using the formula: ((Revenue - Cost - Outsource) + (Reinvoicing - Expenses)) x 100/(Revenue + Reinvoicing)
  • Collected: amount that was collected from the customer for the sales invoices related to the project


PS800199.png