The Challenge

The service departments across multiple dealership locations were running blind. Technicians worked from paper tickets, managers had no visibility into shop capacity, and tracking performance meant hours of manual spreadsheet work at the end of each month.

The parts department had similar problems. Open orders lived in the dealer management system but required clicking through multiple screens to get basic information. Nobody could quickly answer "where's my order?" without a five-minute hunt through the DMS.

The client needed real-time visibility into both departments, tight integration with their existing dealer management system, and dashboards that could surface actionable insights without replacing their core business systems.

Service Scheduling System

The service side launched first, giving shop managers a live view of everything happening in their bays.

Real-time Dashboard

The main screen shows all active work orders with status indicators updated in real-time. Managers can see at a glance:

  • Which technicians are working on what
  • Time elapsed vs. estimated completion
  • Jobs waiting for parts
  • Upcoming scheduled appointments
  • Bay utilization across the shop

DMS Integration

The system pulls directly from their dealer management system rather than requiring duplicate data entry. Work orders, customer info, equipment details, and parts allocation all sync automatically. When a tech updates status in the dashboard, it writes back to the DMS.

KPI Tracking

Built-in analytics give managers the numbers they actually care about:

  • Tech efficiency: Billed hours vs. clock hours per technician
  • Bay turnover: Average job duration by service type
  • Parts delays: Time lost waiting on parts availability
  • Schedule accuracy: Estimated vs. actual completion times
  • Revenue per bay: Daily and monthly revenue by work area

Workflow Management

Technicians get a simplified view showing only their assigned jobs. They can update status, flag parts issues, and log time without navigating the full DMS interface. Less clicking means more wrenching.

Parts Order Tracking

After seeing what the service dashboard could do, the parts department wanted their own visibility tools.

Open Order Management

The parts team now has a single screen showing every open order with filters for:

  • Customer name or account number
  • Date range (when the order was opened)
  • Assigned salesperson
  • Shipping method (will-call, delivery, drop-ship)
  • Order status and age

Color coding highlights orders that have been open too long, making it easy to spot problems before customers start calling.

Allocation and Lead Times

Both the service and parts dashboards tie into the parts inventory system. Users can instantly see:

  • Whether parts are in stock and allocated to their order
  • Current lead times for backordered items

This visibility reduced "where's my part?" phone calls significantly since customers and service writers could get answers immediately.

Revenue Analytics

The parts department tracks performance at multiple levels:

  • Daily invoicing: Number of invoices and revenue by salesperson
  • Monthly trends: Month-over-month comparison for each location
  • Yearly rollups: Annual performance tracking per salesman
  • Location comparison: Side-by-side metrics across all dealership locations

Managers can drill down from company-wide numbers to individual salesperson performance in a few clicks.

Technical Implementation

Architecture

  • Backend: C# REST API handling business logic and DMS communication
  • Frontend: Vanilla JavaScript with real-time updates via polling
  • Integration: Direct SQL connection to DMS database (read) with API callbacks (write)

Real-time Updates

The dashboards refresh automatically without requiring page reloads. Service bay status, parts order changes, and new work orders appear within seconds of being entered in the DMS.

Multi-location Support

Each location sees their own data by default, but managers with proper permissions can view and compare across all sites. The system respects the existing DMS security model for user access.

Performance

Queries against the DMS are optimized to minimize load on the production system. Frequently accessed data is cached locally with smart invalidation when source records change.

The Results

Service Department

  • Shop visibility: Managers went from zero real-time insight to complete bay status at a glance
  • Reduced phone calls: Service writers stopped interrupting techs to ask "how much longer?"
  • Faster parts escalation: Delays flagged immediately instead of discovered at job completion
  • Monthly reporting: KPI reports that took hours now generate in seconds

Parts Department

  • Order transparency: Any team member can answer customer status questions immediately
  • Aging visibility: Open orders older than 7 days automatically highlighted for follow-up
  • Revenue tracking: Daily sales performance visible to both salespeople and management
  • Cross-location insights: First time leadership could compare performance across all sites

What Made This Project Work

The key was integration rather than replacement. The dealership had years of data and established workflows in their DMS. Building dashboards that read from and wrote back to that system meant zero disruption to existing processes.

Staff adopted the new tools quickly because they reduced clicks and provided information that was previously buried. Nobody had to learn a new way of doing their job, they just got better visibility into work they were already doing.