BI Clarity Hub

Hourly Margin (Billed)

Detailed information for "Hourly Margin (Billed)".

Finance
Custom
Measure
FBO

Technical Definition

N/A

Business Definition

This metric estimates the margin earned per hour worked, based on the Margin Billed. It helps assess profitability at a granular level by dividing the total margin by the number of hours worked during the transaction period.
This is a useful indicator for understanding margin efficiency across hourly assignments.

How to use it

Note

Rules & Criteria:

  • Calculation: Hourly Margin = Margin Billed ÷ Total Hours Worked
  • Only transactions with unit types of hourly or daily are included.
    • Daily units are converted to hourly using the Hours/Day setup in the Work Order.
  • Transactions with other unit types (e.g., words, shifts) are excluded.
  • The Transaction Date is used for reporting, not the actual work date.
  • All data is sourced directly from FBO, using actual timesheet units and margin values.

Recognition:

  • Sales: Any person listed as Job Owner or Additional Job Owner on the Work Order in FBO.
  • Recruiter: Any person with a recruiter role tied to the Work Order in FBO.
  • Recognition follows the same logic as Margin Billed:
    • If the same person is both Sales and Recruiter, they receive both recognitions, but the margin is not double-counted.
    • Multiple Sales or Recruiters each receive 100% recognition, but the total margin is counted only once.
ID: 3d69573b-4537-46ab-8244-8b184fa7174d