Versions Compared

Key

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

...

Dashboard Name

Description

Agreement Profitability - SummaryThe Summary dashboard shows total billed, margin, effective rate, contribution rate, and profit per agreement type. It also contains graphs showing the monthly trend for the KPIs.
Agreement Profitability - Agreement Details

The Agreement Details dashboard shows a breakdown of the same key metrics from the Summary Dashboard but on a per agreement-company level.

It also contains graphs that show the trend of the following: labor hours vs the target, profit margin %.

Agreement Profitability - Margin ReviewThe Margin Review dashboard contains a table that displays all companies under each agreement type with their monthly margins. This allows users to see the trend and determine which companies should be looked into.

Terms and Calculations Used

Dashboard Name

Description

BilledTotal amount of all invoices billed for an agreement
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
Target Budgeted hours to achieve a certain profit margin

Agreement Profitability - Summary Dashboard

...