CMG needed a desktop application to automate the generation of freight rates from carrier-provided Excel files. The existing process involved manual mapping of spreadsheet columns and rate calculations, which was time-consuming and prone to errors.
Automate freight rate generation from Excel files.
Eliminate manual data entry and calculation errors.
Support different transportation modes such as LTL and TL.
Allow users to map columns from varying carrier spreadsheets.
Generate updated rate files quickly and accurately.
Improve operational efficiency and turnaround time.
Toyaja Solution
Toyaja designed and developed a Windows-based Freight Rate Generation System using VB.NET.
Key Deliverables
User-friendly desktop application.
Import and read carrier Excel spreadsheets.
Dynamic column mapping functionality.
Support for multiple transportation modes (LTL, TL, etc.).
Selection of reference rate files.
Automated freight rate calculations and pricing logic.
Write calculated rates back to Excel files.
Validation and testing framework.
Application setup and deployment package for Windows environments.
Technology Highlights
VB.NET Desktop Application
Microsoft Excel Integration
Automated Rate Calculation Engine
Dynamic Data Mapping
Windows 7, 8, and 10 Compatibility
Outcome
Reduced manual effort in freight rate generation.
Improved accuracy and consistency of pricing calculations.
Accelerated processing of carrier rate files.
Enabled users to work with multiple spreadsheet formats without modification.
Increased operational productivity and reduced turnaround time.
Delivered a scalable pricing tool that could be enhanced with additional carrier pricing models.
