Versions Compared

Key

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

...

Term

Definition/Calculation

Value

Sum of addition price for all agreements

If annual, monthly value is from Total Value divided by 12

If monthly, with addition price, Value = addition price

If, then Value = Addition Price = Quantity * Unit Price
If , then Value = Service Total of invoice

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

BilledSum of (Actual Quantity * Unit Price) for all invoices within selected date range
Addition CostsSum of (Actual Quantity * Unit Cost) for all invoices within selected date rangeBilledTotal billed of invoices
ProfitBilled - (Addition Costs + Labor Costs)
MarginProfit / BilledAddition CostsProduct cost for an agreement
Actual Labor HoursTotal recorded hours for an agreement
Effective Rate(Billed - Addition Costs) / Labor Hours
Contribution RateProfit / Labor Hours
Ave. Hourly Labor Rate

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

Target HoursTarget 

Budgeted hours to achieve

a certain profit margin

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

Agreement Profitability - Summary Dashboard

...