Margin Worked ($)

This metric represents the margin calculated by FBO for financial transactions, distributed across the actual work dates rather than the transaction processing date. It provides a more accurate view of margin earned over time, enabling better weekly, monthly, and quarterly reporting.

The margin is calculated using the same formula as Margin Billed, but is allocated daily based on when the work was performed.

Rules & Criteria:

• Formula: Margin Worked = Bill Amount (before Sales Tax) – Client Discount Amount – Accrued Rebate Amount (not actual rebate) – Consultant Pay Amount (before Sales Tax, includes Vacation Pay) – Employer Burden Amount (CPP, QPP, QPIP, Health Tax, EI, etc.) – Stat Holiday Accrued Amount (estimated) – Accrued CPP / EI Over-Cap Amount (after burden max is reached)
• Work Date Allocation Methods:
  1. Timesheet Transactions: Margin is split across workdays based on the ratio of units (hours, days, shifts, etc.) entered per day vs. total units in the period.
  • Assumes a single unit type is used (e.g., hours over words).
  • Vacation pay is only subtracted when taken and paid.
  2. VMS Import (Daily Feed):
  • Same logic as timesheet transactions.
  3. VMS Import (Weekly Feed):
  • Margin is evenly distributed across business days (excluding weekends).
  • Does not account for statutory holidays or vacation.
  • Assumes no weekend work.
  • Uses primary unit type only (e.g., hours > days > shifts > words).
  4. Manual Transaction:
  • Margin is evenly distributed across business days (excluding weekends) from Transaction Start Date to Transaction End Date.
  • Does not account for statutory holidays or vacation.
  • Assumes no weekend work.
  • Uses primary unit type only (e.g., hours > days > shifts > words).

Currency:

All amounts are converted to the internal company currency (e.g., CDN$, US$) using the same exchange service as NetSuite. BI does not perform additional currency conversion.

Date Context:

The work date is used for reporting, not the transaction processing date.
⚠️ Important Notes:

• This metric is NOT intended for commission calculations.
• It may closely align with Transaction Margin Billed if the reporting period matches, but they are not penny-for-penny comparable.
• For commissionable margin, refer to Forma.

Exclusion

• PermPlacement Margins are excluded from the Transaction Margin Worked calculation. They are only included in the Transaction Margin Billed metric.

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.

Additional Notes:

• If the same person is both Sales and Recruiter, they receive both recognitions, but the margin is not double-counted.
• If multiple Sales or Recruiters are associated, each receives 100% recognition, but the total margin is still counted only once.

Phase 2:

The FBO will be modified to support a recognition split in cases where there are more than one salesperson or recruiter for a Transaction. Once that change is made in FBO, it will be reflected in this report. Currently, this is planned to be rolled out in August.