Job Cost Odd-One-Out
Job Cost Odd-One-Out
Demo only. These jobs are made up. Nothing is connected to your books.
A closed job book for an East County shop. Two of these money columns are quietly recording the same spend, which hides the one line that does not fit.
24 closed jobs loaded. Nothing has been checked yet.
Closed jobs (made up)
Parts comes off the supplier invoice. Materials comes off the job sheet. On these jobs they are two records of the same spend.
What does not match
Hit Find the odd one. and the reason shows up here, in words.
A spread is how far a job usually sits from the middle on that line, so a line at 12 spreads is twelve times the normal wobble.
How this is figured
- Scale the columns. Hours, dollars and minutes cannot be compared as they are, so each column is measured against its own middle value and its own typical distance from that middle. The middle rather than the average, because an average is dragged toward whatever is unusual, and the unusual thing is what we are looking for.
- Drop the duplicate direction. If two columns turn out to be one number recorded twice, they are folded into one. Keeping both counts that spend twice and makes the whole book look like it moves together.
- Flag the point farthest from the normal cluster. With the columns on the same footing and the duplicate gone, measure how far each job sits from the middle of the pack, and report the farthest one plus whichever line put it there.
That is linear algebra on a small table, not a forecast. It does not learn, it has no opinion about what a job should cost, and it cannot tell a typo from a real equipment run. It only says which line does not match the others. Totals are left out of the arithmetic on purpose: a total is labor plus materials plus permits, so scoring it would count those three a second time and the biggest job would always win.
The rest of the chain
- Respond fast Instant Lead Response
- Follow up Lead Follow-up
- Win the job Ridgeview Remodeling
- Ask for the review Review Ask
- Check the books Job Cost Odd-One-Out You are here
Want this run on your own book?
This page only knows about made-up jobs. Pointing the same arithmetic at a real export is a conversation, not a button, and it starts with what your books already look like.