MES dashboard and technician app
Hypothetical. Not a client, not a result.
// The problem
A three-line plant tracks output, downtime and scrap in a spreadsheet filled in at the end of each shift, so problems are found a day late.
// What we would build
A web dashboard fed live from the lines' PLCs through an edge gateway, with an iOS and Android app technicians use to log downtime reasons, close work orders and photograph faults.
// What is in it
- Raw materials and work in progress scanned at receiving and at each station
- Production orders and scrap posted to QuickBooks Online, built on the QuickBooks Online API
- Live OEE, throughput and scrap per line, per shift and per product
- Downtime reasons logged on the phone at the machine, with photos
- Work orders raised, assigned and closed from the app, offline on the floor
- An edge gateway reading OPC UA and Modbus, with a small on-site server
- Shift handover report generated, not typed
- Roles for operators, technicians, supervisors and the plant manager
// Stack
- Next.js
- React Native
- PostgreSQL with TimescaleDB
- OPC UA and Modbus gateway
- AWS
// estimate
- Build
- ≈ US$176,000 to US$270,000, delivered within 44 weeksCAD 251,100 to 384,000
- Hosting
- ≈ US$492 a monthCAD 700 a month
- Support
- ≈ US$2,500 a monthCAD 3,565 a month
- Hardware
- ≈ US$16,400 to US$19,900CAD 23,330 to 28,330
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
- Data mapping and sandbox connection
- 0.4 weeks
- Discovery and site walk-through
- 0.4 weeks
- Design approved
- 8.9 to 15.4 weeks
- Core features
- 1.4 to 2.4 weeks
- Full build
- 0.9 to 1.9 weeks
- First build on devices
- 2.9 to 4.4 weeks
- Sync built and reconciled in sandbox
- 0.9 to 1.9 weeks
- Stock, receiving and transfers
- 2.4 to 4.4 weeks
- Tracking and devices working
- 1.9 to 2.9 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
- Live cutover
- 0.9 to 1.4 weeks
- Hypercare
- 0.9 to 1.4 weeks
- Rollout
- 0.9 to 1.4 weeks
Outside our hands, and added to the calendar
- Hardware delivery, after it is ordered
- 2 to 6 weeks
- App store review
- 1 week
How it is paid
- Deposit 20%
- CAD 50,220 to 76,800
- Discovery 4.7%
- CAD 11,801.70 to 18,048.00
- Data mapping and sandbox connection 0.9%
- CAD 2,259.90 to 3,456.00
- Discovery and site walk-through 3%
- CAD 7,533 to 11,520
- Design approved 7.8%
- CAD 19,585.80 to 29,952.00
- Core features 3.9%
- CAD 9,792.90 to 14,976.00
- Full build 2.6%
- CAD 6,528.60 to 9,984.00
- First build on devices 10.4%
- CAD 26,114.40 to 39,936.00
- Sync built and reconciled in sandbox 2.9%
- CAD 7,281.90 to 11,136.00
- Stock, receiving and transfers 9.2%
- CAD 23,101.20 to 35,328.00
- Tracking and devices working 6.1%
- CAD 15,317.10 to 23,424.00
- Testing and fixes 1.3%
- CAD 3,264.30 to 4,992.00
- Store submission 3.4%
- CAD 8,537.40 to 13,056.00
- Pilot site live 3%
- CAD 7,533 to 11,520
- Launch 4.7%
- CAD 11,801.70 to 18,048.00
- Live cutover 0.9%
- CAD 2,259.90 to 3,456.00
- Hypercare 0.9%
- CAD 2,259.90 to 3,456.00
- Rollout 4.3%
- CAD 10,797.30 to 16,512.00
- Holdback, 30 days after launch (10%)
- CAD 25,110 to 38,400
- Entry server x 1
- CAD 4,200 to 9,200. Billed up front, at cost, outside the milestones
- Rugged barcode scanner x 8
- CAD 14,080. Billed up front, at cost, outside the milestones
- Industrial label printer x 2
- CAD 4,760. 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