Lab system rescue
Hypothetical. Not a client, not a result.
// The problem
A chemical producer's lab runs on an Access database with Excel macros built fifteen years ago, its author has left, and it no longer opens on the new laptops.
// What we would build
An architecture review of the old lab system first, with a written plan, then a web-based lab system that keeps every sample, specification and result: samples logged and labelled, results entered or imported, certificates of analysis issued from the record for your quality lead to approve, and years of history moved and checked.
// What is in it
- An architecture review and a written plan before any code changes
- Samples, specifications and results moved from the old database and reconciled
- Results entered or imported, checked against the specification
- Certificates of analysis issued from the record, approved by your quality lead
- Products and customers read from your ERP
- SDS references kept with each product and version
// Stack
- Next.js
- PostgreSQL
- ERP API
- PDF generation
- AWS Canada
// estimate
- Build
- ≈ US$116,000 to US$178,000, delivered within 23 weeksCAD 165,300 to 252,900
- Hosting
- ≈ US$492 a monthCAD 700 a month
- Support
- ≈ US$2,500 a monthCAD 3,565 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.4 to 4.4 weeks
- SDS versioning rules agreed with your regulatory lead
- 1.9 to 3.4 weeks
- Core features
- 3.4 to 5.9 weeks
- Full build
- 2.4 to 3.9 weeks
- Testing and fixes
- 0.9 to 1.9 weeks
- Launch
- 0.9 to 1.4 weeks
Outside our hands, and added to the calendar
- ERP API access from your vendor
- 1 to 4 weeks
How it is paid
- Deposit 20%
- CAD 33,060 to 50,580
- Discovery 6.8%
- CAD 11,240.40 to 17,197.20
- Design approved 6.8%
- CAD 11,240.40 to 17,197.20
- SDS versioning rules agreed with your regulatory lead 8.7%
- CAD 14,381.10 to 22,002.30
- Core features 20.4%
- CAD 33,721.20 to 51,591.60
- Full build 13.6%
- CAD 22,480.80 to 34,394.40
- Testing and fixes 6.8%
- CAD 11,240.40 to 17,197.20
- Launch 6.9%
- CAD 11,405.70 to 17,450.10
- Holdback, 30 days after launch (10%)
- CAD 16,530 to 25,290