This report produces a series of figures (quantity of trips, quantity of time, etc., as compared to revenue) designed to help you assess profitability of work as connected to each of your HighVolumeClients, comparing between such parties, and to your nonHighVolumeClient work (again, both at a group level and individually).
The underlying mechanics are as follows:
Please note that, for margin figures to be accurate, the user-query-provided trip - cost and hourly - cost figures must, in turn, be accurate. It raises the question as to how you arrive at such figures. Our suggestion is, run the report once using whatever seat-ofthe-pants guess you wish, for these figures. Run once, the report will provide total trips for the period and total on-the-job hours for the period. Go to your financial accounting and find what your total expenses were for the period. Figure half the total expense as trip cost, and divide by quantity of trips to get per-trip-cost. Figure the other half as hourly/time cost, and divide by total hours to get hourly cost. Then run the report again with these figures.
As another note, please observe that even if your provided cost-basis figures are not accurately, you’ll likely still have valid comparisons between one HighVolumeClient and another, and between HighVolumeClients and non-HVC work.