What the project brings in — fixed price, milestones, billed time, re-invoiced costs — against what it costs — team hours at their hourly cost, purchases, expenses. Change the lines: the calculation follows.
What the project brings in
The team's time
RoleHoursHourly cost (F)
Other costs
Project margin
3,130,000 F
that is 59.2% of revenue
Revenue5,285,000 F
of which billed time1,200,000 F
Costs2,155,000 F
of which team time1,620,000 F
Hours spent220 h
Revenue per hour spent24,023 F
Average cost of an hour7,364 F
Amounts excluding VAT. Example: replace with your figures.
In Odoo: this table is read in the project itself. Hours come from timesheets at each employee's hourly cost, purchases and expenses from their analytic distribution, revenue from the invoices.
The method
What the calculation does.
Revenue
Fixed price + milestones + billed hours × rate + re-invoiced costs: 5,285,000 F in the example.
Team time
Hours × hourly cost, role by role: 220 h for 1,620,000 F.
Other costs
Purchases and subcontracting, expenses: 535,000 F.
Margin
5,285,000 − 2,155,000 = 3,130,000 F, i.e. 59.2%; 24,023 F of revenue per hour spent.