Monthly overview of Tech Profit broken down by clicks, costs, and revenue
Jump to Overview | Samples | Variables | Alert Functionality | Best Practices & Tips | Related Alerts
Overview
Overview
It can be a challenge determining 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 alert 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 get details, email us if you don't see the eView.
Run Schedule: 1st of each month
Type of Output: Email & eView
* * *
Sample
Sample
* * *
Variables
Variables
Variable W: Call Costs calculated use costs for TRAVEL and MILEAGE, Enter BOTH or NEITHER (if left blank, defaults to BOTH)
Variable X: Custom Property assigned in employee record identifying who is FieldTech
Variable Y: Branch Number(s) to consider (separated by comma, leave blank for ALL)
* * *
Alert Functionality
Alert Functionality
-Data is based on invoiced calls only (not closed but not yet invoiced).
-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.
-# of calls as well as BW and Color Click values are based on ALL Call Type categories (not just Corrective Maintenance).
-Clicks and profit are 'earned' on a given call when a new call is closed on the same equipment. At that point, the tech from the previous call gets credit for all activity between previous call and the just closed call. Clicks are per meter tables and revenue is per day between call per our analytics tables.
-Revenue data taken from CEO Juice background 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 updates nightly (from CEO Juice background tables), 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).
* * *
Best Practices & Tips
Best Practices & Tips
-eView found under System eViews:
- See THIS LINK for Burden Rates, Travel Costs, Mileage Best Practices
* * *
Related Alerts
Related Alerts
None at this time
* * *
2 Comments