Know where every piece of equipment is, on every site
MEP-C-GROUP runs many construction sites in parallel, with a fleet of equipment, materials and parts constantly moving between the warehouse and the sites. Tracking was done on spreadsheets and over the phone, with no reliable overview. We built a custom tool that centralises the inventory, traces every installed component and alerts before a shortage hits.
- Client
- MEP-C-GROUP
- Sector
- Construction · MEP (mechanical, electrical, plumbing)
- Region
- Houston, Texas, USA
- Type
- Custom management software
- Stack
- Java · JavaFX · Spring Boot · PostgreSQL
- Use
- Inventory, traceability and restocking across sites
A material fleet impossible to track on spreadsheets
Between the warehouse and the sites, material moved constantly, but tracking stayed manual. No one knew for sure what was available, what was installed or what was missing. Spreadsheets were never up to date, and shortages were discovered too late, mid-site.
- No reliable overview of available material and its location.
- Spreadsheets and paper tracking never up to date across sites.
- Shortages discovered mid-site, delaying the work.
- No traceability of what had actually been installed, and where.
One inventory, shared between the warehouse and the sites
We centralised all material in a single database, fed at every movement. Each piece of equipment, material or part is tracked from the warehouse to its installation on a site, with thresholds that trigger restocking before a shortage.
- 1Catalogue the material
Every piece of equipment, material and part is recorded in a central database with its characteristics.
- 2Track movements
Inbound, outbound and transfers between the warehouse and sites are logged continuously.
- 3Traceability at install
Each installed component is linked to its site, so you know exactly what is where.
- 4Restocking alerts
Thresholds automatically trigger an alert as soon as a stock drops below the minimum.
What the software does
- Centralised inventory
A single database for all material: equipment, materials and parts.
- Multi-site tracking
The location and status of every item, from the warehouse to the sites.
- Component traceability
The history of every installed component, linked to its site.
- Restocking alerts
Per-item thresholds that warn before stock runs out.
- Stock movements
Inbound, outbound and transfers logged, for always-accurate stock.
- Reports & exports
Inventory statements and exports for management and accounting.
A material fleet finally under control
By replacing spreadsheets with a single, up-to-date database, the software gave MEP-C-GROUP a clear view of its material and reduced the shortages that delayed sites.
Before / after
| Indicator | Before | After |
|---|---|---|
| View on material | Scattered spreadsheets | Single real-time database |
| Locating equipment | Over the phone | In seconds |
| Shortages on site | Frequent | Rare |
| Component traceability | Non-existent | Complete |
| Restocking | At the last minute | On early alert |
Wasting time hunting for your equipment?
Let’s talk about the custom tool that could centralise your inventory and make your sites reliable.