Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Term

Definition/Calculation

Value

Value = Addition Price = Quantity × Unit Price

For agreements with an annual billing cycle, Total Value is divided by 12 to show the monthly value.

BilledSum of [ (Actual Quantity × Unit Price) + Service Total ] for all invoices within the selected date range
Addition CostsSum of (Actual Quantity × Unit Cost) for all invoices within the selected date range

Can be included or excluded using the slicer
ProfitBilled - (Addition Costs + Labor Costs)
MarginProfit ÷ Billed
Actual Labor HoursTotal recorded hours for an agreement
Effective Rate(Billed - Addition Costs) ÷ Labor Hours (if labor hours is < 1, then it is rounded off to 1)
Contribution RateProfit ÷ Labor Hours (if labor hours is < 1, then it is rounded off to 1)
Ave. Hourly Labor Rate

Average of all hourly labor rate of all active technicians with a work type tagging

Target Hours

Budgeted hours to achieve the Target Total Cost Margin %, which can be set in the ConnectWise Settings for App Packages dashboard.

Calculation:
{ [Target Total Cost Margin % - (Addition Costs ÷ Billed) ] × Billed } ÷ Average Hourly Labor Rate

...