A custom web application designed for a sand and gravel supply company, used daily by dozens of employees. The system features a dashboard for tracking quotes in progress, a detailed quote management interface for entering order information, and an interactive map view integrated with Google Maps. This cloud-based solution streamlines the quote-to-order process, allowing users to manage products, pricing, and truck assignments while visualizing mine locations and inventories directly on a map.
Description
Pell Software developed a fully custom, cloud-based, web application developed for a materials supply company specializing in sand and gravel distribution. This cloud-based system streamlines daily operations for dozens of users across the organization. At its core, the application features a comprehensive dashboard that provides real-time visibility into quotes in progress, enabling efficient tracking and management of potential orders.
The system’s quote management interface allows users to input detailed order information, including product specifications, quantities, designated truck types for material transport, and pricing details. This intuitive interface combines a traditional Create/Edit screen with an innovative map view, leveraging Google Maps integration to visualize mine locations. Users can interact directly with the map, clicking on specific sites to access product inventories for each location.
By seamlessly blending order management with geospatial data, this web application optimizes the quote-to-order process, enhancing decision-making and operational efficiency for the company’s sand and gravel supply chain. The system’s user-friendly design and powerful features make it an indispensable tool for managing quotations and streamlining the overall materials ordering process.
Major Features
- Secure storage of sensitive data including customer information, product details, and pricing.
- Real-time integration with Google Maps for visualization of mine locations and product availability.
- Cloud-based solution built on modern web technologies, ensuring scalability and performance for dozens of daily users.
- Interactive map view allowing users to click on locations and view site-specific product inventories.
- Custom dashboard displaying quotes in progress and other key business metrics.
- Comprehensive quote and order management system, handling various material types, quantities, and pricing.
- Employee portal for secure login, order placement, and real-time order tracking.
- Role-based access control, providing different features and data visibility based on user type (e.g., employee, manager).
Client
Client Description
Select Sand & Gravel is a leading provider of construction materials and hauling services across Texas and Oklahoma. From its founding in the early 1980s, Select Sand & Gravel has grown to serve major metropolitan areas including Dallas, Fort Worth, Austin, San Antonio, Houston, Midland/Odessa, and Oklahoma City. In June 2022, the company transitioned to an employee-owned structure, joining the Teamshares network and reinforcing its commitment to customer satisfaction and reliable delivery.
Date Completed
We started work on this application in March 2023, with the initial phase being completed in June 2023, and have been constantly improving and maintaining it ever since including the addition of new features and adjustments of existing features.
Technologies Used & Keywords
Enterprise Resource Planning (ERP) System, Material Management Software, Custom Construction Supply Chain Solution, Custom Routing Software, Custom Route Calculation
