Batch records with QC
Hypothetical. Not a client, not a result.
// The problem
A specialty chemicals plant runs batches from printed tickets, operators write weights by hand, QC results are in a separate spreadsheet, and tracing a customer complaint back to raw material lots takes days.
// What we would build
Electronic batch records on rugged Android scanners at each station: the operator scans each raw material lot, the scale weight is read, not typed, and steps follow the approved formulation. QC results are read from lab instruments against the batch, and each drum is labelled from the record. Formulations are restricted by role, with every view logged.
// What is in it
- Batch tickets from the approved formulation, step by step, on the plant floor
- Raw material lots scanned in, and weights read from the scale
- QC results read from instruments and set against the specification
- Drum and tote labels printed from the record, never typed
- Lot genealogy from raw material to customer shipment, in one search
- Rugged scanners, mobile computers, label printers and labels listed by quantity
// Stack
- Next.js
- Kotlin for Android
- PostgreSQL
- Instrument and scale interfaces
- ERP API
- AWS Canada
// estimate
- Build
- ≈ US$184,000 to US$282,000, delivered within 38 weeksCAD 262,200 to 400,900
- Hosting
- ≈ US$492 a monthCAD 700 a month
- Support
- ≈ US$5,010 a monthCAD 7,135 a month
- Hardware
- ≈ US$20,100CAD 28,650
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
- Discovery and site walk-through
- 0.4 weeks
- Design approved
- 6.9 to 11.9 weeks
- Core features
- 1.9 to 2.9 weeks
- Full build
- 0.9 to 1.9 weeks
- First build on devices
- 2.4 to 4.4 weeks
- Stock, receiving and transfers
- 2.9 to 4.9 weeks
- Tracking and devices working
- 1.9 to 3.4 weeks
- Testing and fixes
- 0.4 weeks
- Store submission
- 0.4 weeks
- Pilot site live
- 2.9 to 3.4 weeks
- Launch
- 0.9 to 1.4 weeks
- Rollout
- 0.9 to 1.4 weeks
Outside our hands, and added to the calendar
- App store review
- 1 week
- Hardware delivery, after it is ordered
- 2 to 6 weeks
- ERP API access from your vendor
- 1 to 4 weeks
How it is paid
- Deposit 20%
- CAD 52,440 to 80,180
- Discovery 4.7%
- CAD 12,323.40 to 18,842.30
- Discovery and site walk-through 3.7%
- CAD 9,701.40 to 14,833.30
- Design approved 8.4%
- CAD 22,024.80 to 33,675.60
- Core features 4.8%
- CAD 12,585.60 to 19,243.20
- Full build 3.2%
- CAD 8,390.40 to 12,828.80
- First build on devices 9.4%
- CAD 24,646.80 to 37,684.60
- Stock, receiving and transfers 11.1%
- CAD 29,104.20 to 44,499.90
- Tracking and devices working 7.4%
- CAD 19,402.80 to 29,666.60
- Testing and fixes 1.6%
- CAD 4,195.20 to 6,414.40
- Store submission 3.1%
- CAD 8,128.20 to 12,427.90
- Pilot site live 3.7%
- CAD 9,701.40 to 14,833.30
- Launch 4.7%
- CAD 12,323.40 to 18,842.30
- Rollout 4.2%
- CAD 11,012.40 to 16,837.80
- Holdback, 30 days after launch (10%)
- CAD 26,220 to 40,090
- Rugged barcode scanner x 6
- CAD 10,560. Billed up front, at cost, outside the milestones
- Mobile computer with scanner x 4
- CAD 7,040. Billed up front, at cost, outside the milestones
- Industrial label printer x 2
- CAD 4,760. Billed up front, at cost, outside the milestones
- Labels and ribbons, starter stock x 20
- CAD 6,000. Billed up front, at cost, outside the milestones
- Corded barcode scanner, for our build and testing
- CAD 290. Billed up front, at cost, outside the milestones