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 annual billing cycle, Total Value is divided by 12 to show monthly value

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

Can be included/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
Contribution RateProfit / Labor Hours
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

...