The Margin Analysis Report (Clients)

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:

  1. ‍The system begins by looking, one-by-one, at each SalesJournal entry (Paycode 1 or 2) that fits within the user-specified date range.  It tallies sale amounts on this basis.
  2. ‍For each such entry, it seeks to find a matching JobRecord.
  3. ‍If from the JobRecord it appears the sale involved a POS situation (system looks in the job’s historical narrative for the phrase "(POS context)"), the transaction is excluded from the main tally figures (in such a case there will be a note at the report bottom that tallies POS items separately).
  4. ‍It tallies quantity of trips, on each job, by reading in the narrative job history.
  5. ‍It tallies time on spent, on each job, by reading in the narrative job history.
  6. ‍It tallies cost of parts used by searching for job-matching entries in the PartsProcess file, archived-PartsProcess file and InventoryJournal (quickkey entries for direct review of these contexts are, respectively, F8, Ctrl-F8 and F10>Review-Purchases-and-Usage).
  7. ‍It tallies LaborCost on the basis of user-provided trip-cost multiplied by quantity, then adds user-provided hourly-cost multiplied by time spent.

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.