The Efficiency by Agreement Report shows you how well you are pricing your agreements by comparing the value of the work done on an agreement and what was invoiced for that work.  We allow you to also see which members worked on the agreements. The bottom line of the report shows the total hours, total shadow billable, total invoiced labor and the average efficiency for the range of months.

The report is a very good indicator during the current month to see if the value of the work for an agreement is on target with the labor revenue for the agreement. In the third week of the month, run this report with a filter set to the current month only. You can see:
1. The agreements that have not been worked on (no shadow billable and zero efficiency).
2. The value of the time put into the agreement at this point of the month is more than the revenue for the labor (shadow billable more than value of the revenue and efficiency < 1.0)

The report can be filtered :

(1) Client - Choose one client, or all clients. If no option is selected, the default is all clients.
(2) Date Range - Pick from the Quick Select predefined date ranges or customize by selecting a 'from' month and a 'to' month.
(3) Account Manager - Filter on a specific account manager. The filter defaults to all account managers.
(4)  Agreement Category - Select an agreement category or several categories. If you do not select a category, the system defaults to include all agreement categories.
(5) Client Types - Select a client type or multiple client types. If you do not select a client type, the system defaults to include all client types.
(6) Exclude Internal Clients - Do not include internal clients, even if there is revenue and costs.
(7) Exclude expired agreements - If checked, all expired agreements will be excluded.

You can download the report to a PDF file, an Excel/CSV spreadsheet, or into a 'report basket' (+) to be downloaded at a future time (see highlighted area below).

The body of the report contains all agreements selected (either for a single client or all clients) for the specified time period.  A summary of the total hours worked for this agreement, shadow billable, invoiced labor and efficiency are displayed. To drill down and see a breakdown of the members who put in time for this project, click the '+' highlighted in yellow below.

The next level of the report shows the members who worked on the agreement, their role and their specific hours, shadow billable, invoiced labor and efficiency.

Here is an example of Client 19430 for the previous month. The client has two labor agreements, Agreement 63 and agreement 294 which generate labor revenue.  Efficiency of each member is the same as the efficiency for Agreement 63 for the month. In the case of Agreement 294, no one worked on this agreement during the month. A line with "Unearned Agreement Labor Revenue" shows no Shadow Billable, but Invoiced Labor. For the given month, there is no attributed labor to any member and no efficiency.

Now let's look at Client 19340 over the past six months.   We know the hours invoiced and the shadow billable since we know the members who worked on the agreement. Therefore we can calculate the Efficiency for the time period (invoiced labor/shadow billable) for each engineer. Depending on when they worked on the agreement and what portion of the time expended each month, their efficiencies are different over time.

To see who worked on these agreements, click the '+' next to the client.  For Agreement 63, many members worked on the agreement over the past 6 months. The top row (highlighted in yellow) shows the overall hours, shadow billable, invoiced labor and efficiency. Each line of the detail shows this data for each member who put in any time under the agreement.  For Agreement 294, a few members put in time.  There is also invoiced labor in a month when no member put in time. This is designated as Unearned Agreement Labor Revenue.

The report can be sorted by each column by using the up/down arrows next to each metric. The arrows act as a toggle to sort the data in ascending or descending order for the individual metric. For example, if you want to sort the data by Efficiency in ascending order, click on the arrows next to Efficiency title. The first toggle click will always be in ascending order. If you wanted to see the data in descending order, click the toggle arrows a second time (highlighted in yellow).

The bottom row of the report shows the hours, shadow billable and invoiced labor totals for the time period. An average efficiency rate is calculated for all agreements listed for the time period.