As a managed service provider, you probably track many key metrics to calculate account profitability, SLA compliance, resource utilization, product margin, net operating income, and more. While the use for some of these metrics depend largely on the size of your operation and your clientele, here's an interesting KPI that can give you insight into dollars-made-per-hour.
Customer effective rate (CER): It is a measure of how your customers are effectively using the engineer's time against what they are paying for. This KPI helps you asses the general profitability of the account, asses the performance ratio of engineers' time vs the dollars made.
To build this report using Analytics Plus, you need to create a couple of query tables (the queries are given below), and create an aggregate formula on "Query2" to calculate the Customer Effective Rate (formula included below).
Aggregate formula to calculate 'Customer effective rate':
sum("Query 2"."Total Bill Amount")/sum("Query 2"."Total Time Spent (Hrs)")
Fill the axes with fields as listed below:
X-axis: Account (Actual)
Y-axis: Customer effective rate (Actual)
Text: Customer effective rate (Actual)