Company Type
Ezote, an online auction startup; low-cost, on-demand route planning for distributed carriers across the U.S.
What Drove the Need
Distributed carriers needed low-cost, on-demand routing with delivery instructions updated during the day
Business Impact
Distributed carriers received routed, instruction-level daily schedules updated through the day — part of the operating model taken from idea to operation in 5.5 months (Case 53)
Systems/Data Integration
Outlook email as the transport; MapPoint for routing
Design
Real-time XML extraction from MS Access → automated Outlook email to the distribution network by employee number → hotspot downlink → automatic upload into the driver's Access application and MapPoint for route creation and updates
Technology Stack
MS Outlook; MS Access; MS MapPoint
XML extraction and automated email distribution
Mobile Fleet Scheduling & Dispatching Application
Logistics application sending customer orders from the corporate office to trucks and drivers for real-time routing: XML extraction from Access, automated email distribution by employee number, Wi-Fi hotspot downlink, and automatic upload into a custom Access application and MapPoint to create and update daily routes.
