Case Studies / Macomb Sales & Service
Duplicate work orders fell by 99% after the move to Airtable
- Client
- Macomb Sales & Service
- Industry
- Commercial service
- Services
- Systems
- Tools
- Airtable
Macomb Sales & Service, a Metro Detroit commercial service company for foodservice, refrigeration, and HVAC equipment, moved work orders and inventory into Airtable. The build tracks about 6,000 location points and cut duplicate work orders by 99%.
- 99%
- Fewer duplicate work orders
- About 6,000
- Location points tracked
The challenge
The form and spreadsheet workflow could not keep up
Macomb Sales & Service is a Metro Detroit commercial service company for foodservice, refrigeration, and HVAC equipment. The form-and-spreadsheet workflow could not keep up with service volume, parts needs, and billing prep.
What we built
Work orders, equipment history, and inventory in Airtable
ProsperSpark rebuilt the workflow in Airtable so technicians can confirm parts on site and send billing-ready parts and pricing back to the office. The published description says the system tracks about 6,000 location points and cut duplicates to nearly zero. The page headline states a 99% cut in duplicate work orders.
Full original write-up
Commercial Services Company Cut 99% Duplicate Work Orders and Billed Faster
~275-305
total hours/year saved (technician + office + admin)
99%
reduction in duplicate work orders
6,000
inventory-location points tracked
The Bottom Line
Macomb Sales & Service is a Metro Detroit commercial service company for foodservice, refrigeration, and HVAC equipment. Their form-and-spreadsheet workflow couldn’t keep up with service volume, parts needs, and billing prep. ProsperSpark rebuilt the workflow in Airtable, connecting work orders, equipment history, and inventory so technicians can confirm parts on-site and send billing-ready parts and pricing back to the office.
Situation
Macomb Sales & Service supports high-urgency service calls across commercial environments, including food service, healthcare, senior living, hotels and schools. Repeat calls and multiple stakeholders often reported the same issue, which created duplicate work and scheduling noise.
That led to two core problems:
- Duplicate work orders: repeat requests created ~1–2 duplicate work orders per week.
- Slow history + parts visibility: equipment service history and part availability weren’t reliably connected, making it harder to answer questions like “what’s been done here before?” quickly.
They also stock a large quantity of OEM parts and rely on speed to restore operations. The back-office system needed to match that reality.
Solution
ProsperSpark implemented a centralized Airtable system that ties together:
- Work orders (intake, scheduling, statuses, billing-ready queues)
- Customers + locations
- Equipment records + service history (nearly 5,000 equipment records)
- Inventory (about 3,000 parts across the shop and trucks)
- Technician-facing portals to update jobs from the field
How the workflow runs now
- Intake + de-dupe: Office logs inbound requests and checks for duplicates before dispatching.
- Dispatch: Scheduler assigns work orders to technicians each day.
- Field execution: Techs open their queue in an Airtable portal, review equipment details/history, and record work completed.
- Parts capture at closeout: Techs select parts used and quantities during closeout.
- Inventory stays accurate: Parts are reduced from the right location (truck or shop).
- Billing-ready output: Pricing is already attached. Completed work orders move to a billing-ready queue for the office.
- Waiting on parts: A “waiting on parts” status tracks delays and supports quick follow-up job creation once parts arrive.
Results
Higher first-visit completion (Operational impact)
Techs can check parts availability (truck or shop) while on-site. If the part is available, they can often complete the repair the same day instead of ordering parts and returning later. (Operational outcome based on the new workflow; exact % not provided.)
Duplicate work orders nearly eliminated (Estimated)
Duplicate requests used to create ~1–2 duplicate work orders per week. Now it “almost never” happens. (Estimate provided by client.)
Faster, cleaner invoicing (Workflow impact)
Previously, the office had to look up parts used to price invoices. Now technicians select parts and quantities during the work order update, and the office has pricing ready for invoicing.
Let's make your tech work for you, not the other way around. Schedule a FREE no-pressure chat with us today.
Book now
At a Glance
Client Macomb Sales & Service
Industry Commercial HVAC + refrigeration + foodservice equipment/repair
Organization
- 24/7 service model serving hospitals, senior living, restaurants, hotels, colleges/schools, and more
- Focus on fast response and keeping customers operational
Business Challenge
- Duplicate requests created repeat work and scheduling noise (Estimated)
- Parts availability wasn’t easy to confirm in the field
- Invoicing required manual part + price lookups
Services
- Airtable system design + implementation
- Workflow redesign for service operations
- Inventory structure + technician portal build
Tools
- Airtable
- QuickBooks
- Fillout
- AutoQuotes
Market Considerations
- Service businesses win on response time, accuracy, and follow-through. The system has to support that pace.
- Inventory visibility matters most at the moment of service, not after the fact.
- Equipment history needs to be tied to locations and units, or it won’t get used.
Key Takeaways
- Capture parts used at job closeout in the field, and invoicing gets simpler automatically.
- De-dupe at intake prevents downstream waste (dispatch, tech time, billing confusion).
- Linking equipment history to work orders turns “tribal knowledge” into a usable record.
Want results like these?
Tell us what's slowing your team down. We'll walk you through what we'd build.
