Estimating: from spreadsheet to central cost model
Non-residential contractor, around 120 staff · 14 weeks to go-live
- Situation
- Four estimators each used their own variant of the same Excel model, with diverging price lists.
- Challenge
- Quotations were not comparable, margins varied and handovers during absence were painful.
- Solution
- A central cost model with a managed price and norm base, versioning per quotation, validation rules and automatic quotation generation.
Measurable results
- Lead time per quotation cut from about 3 days to roughly 1
- Price deviations visible before submission
- One shared norm library for the whole team
- Structural post-calculation feeding back into ratios
Technology used
- React
- TypeScript
- PostgreSQL
- ERP REST integration
- Document generation

