Follow

ID235 - Technician Profitability Report - Overview & Sample

ID235 helps determine who your most profitable technicians are, especially when they work on equipment outside their territory. Do you have a technician that gets paid way above average and you wonder if they are worth it? This report uses the assumption that if Tech A works on a machine then all clicks run from that call until a different tech works on it belong to Tech A. We can then tell how many clicks each tech is effectively servicing and from that pull the rest of the profitability numbers and then show clicks and profit by tech. This report is a summary, use the ID235 eView named "CEOJuice ID235 Tech Profit" to drill in for details, email help@ceojuice.com if you don't see the eView.

Data is based on invoiced calls only (not closed but not yet invoiced).

This alert requires you must have ECI's analytics package in place and updating properly in order for this alert to return useful results.

ScreenShot.png

Supplies are included in cost, we look at all equipment on a contract that could take the same supply item and distribute costs across all.

 

Notes:

1) Click values for CM or PM calls only also available. # of Calls is 'all call types'

3) Two numbers now provided, Profit$ showing call profit after supply costs accounted for, Profit$NoSupp not considering supply costs. 

4) Clicks/profit are 'earned' on a given call when a new call is closed on the same Eqp,at which point tech on previous call gets credit for all activity between previous call and just-closed call. Clicks are per meter tables, revenue is per-day between calls per analytics tables.

4) Revenue data taken from analytics tables, therefore validity varies based on how recently any given contract has billed overages (revenue for a period is not complete until overage is billed and posted back across covered periods). Click #s are not so constrained, data is solid in all cases.

To validate this data use the eview called CEOJuice ID235 Tech Profit data as shown below. Please note eView is analytics data which updates nightly, so a direct comparison of eView to ID235 email will only validate on day of ID235 email.

You will want to filter the eview by the technician you are currently trying to validate. You will also want to filter it by the month that the tech profit you are validating is for. You will want to use the Next Call Close Date to filter the month. As noted above, Clicks/profit are 'earned' on a given call when a new call is closed on the same Eqp,at which point tech on previous call gets credit for all activity between previous call and just-closed call. This is why you filter by Next Call Close Date.

We're still looking at whether we can add functionality to sum data and such inside the eview itself, so right now you will need to export it to manipulate the data for validation.

Once you export the eview you can use a row for your Totals and insert a formula in each of the cells to SUM the data in that column that you are validating. You will notice that the eview has a lot more data than what is shown on the output of this alert. Those columns of data will be explained at the end of this post.

1) BW Click is the actual BW Clicks/Copies Between Calls (CBCBW). As noted above, Clicks/profit are 'earned' on a given call when a new call is closed on the same Eqp,at which point tech on previous call gets credit for all activity between previous call and just-closed call. Clicks are per meter tables. So this is the total BW clicks between the new call that was closed and the last call prior to that for this technician.

2) Color Clicks is the actual Color Clicks/Copies Between Calls. Same as above (CBCColor).

3) Total Clicks is the actual Total Clicks Between Calls (BW + Color). Same as above (CBCTotal).

4) Revenue is your actual Call Revenue. This is the total of the amount that was billed for any billable calls plus the percentage of contract revenue designated as service revenue. As noted above, we look at the percentage of costs from the contract that is attributed to service to determine the percentage of revenue that we attribute to service revenue.

5) Labor Costs are determined based on your Burden Rate times the number of hours the tech spent working on equipment as documented in the Service Call labor record.

   **Please see THIS LINK for Burden Rates, Travel Costs, Mileage Best Practice

6) Travel Costs is your travel costs associated to all the calls for that technician. There is a few ways to calculate travel costs in EA. Some companies calculate travel costs based on the mileage rate per mile (Mileage Costs) that they pay the technician (1). Some companies calculate a travel cost per hour (2). Some companies add their Burden Rate to the travel hours to calculate travel cost (3). Also some companies inflate their Burden Rate to cover travel costs, in which case, your travel costs will be included in Labor Costs. Travel Costs are set under Tools/Options/Service Calls, as shown below. The default setting for this alert is Travel Cost + Mileage Costs. You can set whether you want just Travel Cost, just Mileage Cost, Both or Neither to be included in your Call Costs via VariableW for this alert.

7) Parts Costs are the costs associated with the parts used on the service calls.

8) Supply Costs (Supply ProRate in the eview) are rolled up for like model for the life of the contract and then prorated back down on a per-day per-machine basis.

9) Profit $ w/Supply (Call Profit) is your Profit $ with supplies factored into the number. Call Revenue minus Call Costs.

10) Profit $ no/Supply is your Profit $ without supplies factored into the number. #8 Supply Costs (Supply ProRate) minus #9 Call Profit.

11) GM % w/Supply is your Gross Margin percentage with supplies factored into the number. #9 Profit $ w/Supply (Call Profit) divided by #4 Revenue (Call Revenue).

12) GM % no/Supply is your Gross Margin percentage without supplies factored into the number. #10 Profit $ no/Supply divided by #4 Revenue (Call Revenue).

Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request

2 Comments

  • 0
    Avatar
    Michael Hippler

    What would make this tool complete is the ability to drill down. Our delivery driver looks very profitable and some of the click counts appear to be very suspect.

     

  • 0
    Avatar
    Juice Support

    Michael, we added an eView, it probably has not been installed for you yet but it will have all that info.

Please sign in to leave a comment.
Powered by Zendesk