Customers_Vehicles.csv
40 customers. Vehicle, mileage, last visit, contact preference and consent, no-show history.
It’s September 23, 2026. Tomorrow your shop has technician hours nobody has sold. Empty bays, paid techs, real money walking out the door.
You have 40 customers, 80 past repair orders, and 27 pieces of work these customers were already told they needed and said no to. You also have exactly what’s open tomorrow, by skill and by time window.
The trap is obvious once you see it: the most expensive declined job in the file is worthless if there’s no tech with that skill free tomorrow afternoon.
40 customers. Vehicle, mileage, last visit, contact preference and consent, no-show history.
80 prior repair orders. Dates, mileage, what was done, what was spent, advisor notes.
27 known opportunities. Estimated value, labor time, skill needed, why they said no.
Recent no-shows and outreach attempts.
Service codes, labor estimates, typical price, skill category.
Open technician hours by skill and time window, September 24.
You cannot diagnose. Nothing gets recommended that isn't already on the record as declined or due.
No invented safety claims. No “your brakes are dangerous” unless the file says so.
Consent and contact preference are real constraints.
The capacity grid doesn't move. You fill what's open, not what you wish were open.
Public tools only.
Who gets contacted, and what makes them a better use of a phone call than the person you skipped?
Does the work you picked actually fit in the hours you have?
What does a service manager need in front of him at 7 AM tomorrow to run this?