Quality data warehouse
Hypothetical. Not a client, not a result.
// The problem
A composites maker's QC results, batch yields, customer complaints and supplier lots sit in two ERPs and the lab's spreadsheets, and the monthly quality review is a week of copying.
// What we would build
A data warehouse that takes in QC results, batch records, complaints and supplier lots from both ERPs and the lab, and shows dashboards for plant managers and the quality team: yields by line, results against specification, complaints by product and supplier. We host and run it for you in a Canadian region.
// What is in it
- QC results, batches, complaints and supplier lots joined in one warehouse
- Yield and right-first-time by line, product and shift
- Results against specification over time, with drifts flagged
- Complaints traced to batches and supplier lots
- Hosting, backups and monitoring run for you
// Stack
- PostgreSQL
- dbt
- ERP APIs
- Next.js
- Apache Superset
- AWS Canada
// estimate
- Build
- ≈ US$66,000 to US$101,000, delivered within 16 weeksCAD 94,000 to 143,800
- Hosting
- ≈ US$492 a monthCAD 700 a month
- Support
- ≈ US$5,010 a monthCAD 7,135 a month
Prices in your currency are estimates from today's Bank of Canada rate. All invoicing is in CAD or USD.
Timeline by milestone
- Discovery
- 2.9 to 3.4 weeks
- Design approved
- 2.9 to 4.4 weeks
- Core features
- 2.4 to 3.9 weeks
- Full build
- 1.4 to 2.4 weeks
- Testing and fixes
- 0.9 to 1.4 weeks
- Launch
- 0.9 to 1.4 weeks
Outside our hands, and added to the calendar
- ERP API access from each vendor
- 1 to 4 weeks
How it is paid
- Deposit 20%
- CAD 18,800 to 28,760
- Discovery 7.7%
- CAD 7,238.00 to 11,072.60
- Design approved 7.7%
- CAD 7,238.00 to 11,072.60
- Core features 23.3%
- CAD 21,902.00 to 33,505.40
- Full build 15.5%
- CAD 14,570 to 22,289
- Testing and fixes 7.7%
- CAD 7,238.00 to 11,072.60
- Launch 8.1%
- CAD 7,614.00 to 11,647.80
- Holdback, 30 days after launch (10%)
- CAD 9,400 to 14,380