Building and Maintaining a Material Price Database
An estimate is only as current as its prices. A structured, dated price database is the difference between a live estimating capability and a stale spreadsheet.
Structure
| Field | Purpose |
|---|---|
| Category / sub-category | Group for browsing and reporting (Cement, Rebar, Pipe, Cable…) |
| Description + specification | Unambiguous — size, grade, standard |
| Unit | Purchase unit (bag, length, kg, m³, set) |
| Price | Current unit price, currency noted |
| Price date + source | When and where — a quote, an invoice, a published index |
| Region | Prices vary by island/city — tag them |
Update cadence by volatility
| Volatility | Items | Update |
|---|---|---|
| High | Steel, fuel, copper, cement, asphalt | Monthly |
| Medium | Aggregates, timber, pipe, tiles | Quarterly |
| Low | Hardware, sundries, fixtures | Half-yearly |
Sourcing prices
- Live supplier quotations for a real project — the best source; feed the winning prices back in.
- Published construction material price indices and government reference prices.
- Trade counter list prices minus a typical discount, as a fallback.
Keep history
Do not overwrite — keep the old price with its date. A price history lets you compute escalation, defend a rate to a client, and spot a supplier’s outlier quote.
Currency
For international work, store a base-currency price and convert at estimate time, or store per-region local prices. Never mix currencies in one rate build-up without noting the conversion date.
EngEst Pro ships with 80+ materials at real market prices and lets you add your own, set custom categories and units, tag regions, and bulk-adjust prices — the Material Database feeds every calculator’s BOM.
Put this on autopilot with EngEst Pro
Create a free EngEst Pro account — 5 projects a month, all 8 calculators, PDF BOQ export. No credit card required.
Create Free Account → Run your first estimate in under 10 minutes.