Project Overview
Managing large-scale infrastructure projects requires precision, speed, and complete visibility across operations. In this high-speed rail project, the efficient supply of stone aggregates was critical to maintaining construction timelines.
Hourglass IT developed a custom software solution to streamline and optimize the entire aggregate supply chain—resulting in faster operations, improved accuracy, and significantly reduced payment cycles.
Project Summary
Industry
Infrastructure / Transportation
Project Type
High-Speed Rail Construction
Material Managed
~13 Million Metric Tons of Stone Aggregates
Locations
Multiple sites across several hundred kilometres
Solution
Custom Supply Chain Management Software
The Challenge
The project involved managing massive volumes of stone aggregates transported daily by trucks from multiple suppliers and quarries to different construction sites.
Key Issues
- Heavy reliance on Excel for tracking trips and loads
- Lack of visibility into operational efficiency
- Difficulty in tracking supplier contributions
- Manual and time-consuming cost calculations
- Delays in invoice approvals and supplier payments
- No centralized system for managing logistics data
Despite tracking data, decision-makers lacked actionable insights to optimize performance and reduce costs.
The Solution
Hourglass IT developed a custom-built software application to automate and centralize the entire supply chain process.
Core Capabilities
🚚
Automated Trip & Load Tracking
Captures truck trips, loads per trip, and supplier data. Eliminates manual data entry errors entirely.
📊
Advanced Cost Calculation Engine
Calculates transportation and material costs, computing from both source and destination points.
🏗
Master Configuration Setup
Distance mapping between quarries and sites, with standard load and operational parameters.
📈
Supplier Performance Tracking
Tracks individual supplier contributions and provides clear visibility into supplier efficiency.
📄
Smart Reporting System
Generates detailed, downloadable reports with supplier-wise and site-wise analytics on demand.
✅
Integrated Approval Workflow
Internal approval system for faster invoice validation, streamlining billing and payment processes.
Key Results & Business Impact
🚀
Operational Efficiency
Significant reduction in manual effort and faster processing of logistics data across all sites.
📊
Improved Visibility
Real-time insights into supply chain performance enabling better decision-making at every level.
💰
Cost Optimization
Accurate automated cost calculations eliminated financial discrepancies and overpayments.
⏱
Faster Payment Cycle
30 days → 7 days
Payment processing cycle reduced dramatically, improving supplier relationships.
🔄
Streamlined Workflow
Centralized system replaced multiple spreadsheets. Improved coordination across teams.
Before vs. After
| Before Implementation |
After Implementation |
| Excel-based tracking |
Centralized software system |
| Manual calculations |
Automated cost computation |
| Limited visibility |
Real-time insights |
| Delayed payments (30 days) |
Faster payments (7 days) |
| Data silos across teams |
Integrated, unified workflow |
Why This Solution Worked
- Tailored specifically to project requirements
- Automated complex calculations and workflows
- Centralized all operations into one system
- Scalable to handle large data volumes
- Reduced dependency on manual processes
Technology Approach
Custom-Built Scalable Architecture
Secure Data Handling
Cloud-Ready Deployment
User-Friendly Dashboard Interface
Business Value Delivered
This solution not only improved operational efficiency but also enhanced financial transparency and supplier relationships—making the entire supply chain faster, smarter, and more reliable.
By replacing fragmented, manual processes with a unified digital platform, Hourglass IT delivered a measurable impact across every dimension of the operation: from daily logistics tracking to long-term strategic visibility.
