MRO serialised parts tracking
Hypothetical. Not a client, not a result.
// The problem
A maintenance, repair and overhaul shop tracks serialised parts on paper travellers and in its ERP, and assembling a part's full history for a customer audit takes days.
// What we would build
A web system and an Android app on rugged mobile computers that scan each part's barcode or data matrix mark at every step, record inspections, repairs and modifications against its serial number, and hold the full history on servers in the shop, with access to controlled data limited to the people your designated official approves.
// What is in it
- Parts scanned by barcode or data matrix at receiving, each work step and release
- Inspections, repairs and modifications recorded against the serial number
- The full history of a part, built in seconds for a customer or an auditor
- Work orders and parts read from the ERP
- Servers on premises, with access to controlled data set by role
- Rugged scanners, mobile computers and label printers listed by quantity
// Stack
- Next.js
- Kotlin for Android
- PostgreSQL
- ERP integration
- On-premise servers
// estimate
- Build
- ≈ US$196,000 to US$299,000, delivered within 42 weeksCAD 278,800 to 425,200
- Support
- ≈ US$5,010 a monthCAD 7,135 a month
- Hardware
- ≈ US$50,000 to US$70,400CAD 71,150 to 100,250
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
- 3.9 to 6.4 weeks
- Access rules reviewed with your designated official
- 3.4 to 5.4 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
- 3.4 to 5.4 weeks
- Tracking and devices working
- 2.4 to 3.9 weeks
- Testing and fixes
- 0.4 weeks
- Store submission
- 0.4 weeks
- Pilot site live
- 2.9 to 3.4 weeks
- Security review questions answered
- 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
- Hardware delivery, after it is ordered
- 2 to 6 weeks
- App store review
- 1 week
- Security review and vendor onboarding
- 4 to 8 weeks
- ERP test access from your IT team
- 1 to 4 weeks
How it is paid
- Deposit 20%
- CAD 55,760 to 85,040
- Discovery 3.5%
- CAD 9,758 to 14,882
- Discovery and site walk-through 3%
- CAD 8,364 to 12,756
- Design approved 6.5%
- CAD 18,122 to 27,638
- Access rules reviewed with your designated official 7.7%
- CAD 21,467.60 to 32,740.40
- Core features 3.6%
- CAD 10,036.80 to 15,307.20
- Full build 2.4%
- CAD 6,691.20 to 10,204.80
- First build on devices 7%
- CAD 19,516 to 29,764
- Stock, receiving and transfers 9%
- CAD 25,092 to 38,268
- Tracking and devices working 6%
- CAD 16,728 to 25,512
- Testing and fixes 1.2%
- CAD 3,345.60 to 5,102.40
- Store submission 2.3%
- CAD 6,412.40 to 9,779.60
- Pilot site live 3%
- CAD 8,364 to 12,756
- Security review questions answered 7.7%
- CAD 21,467.60 to 32,740.40
- Launch 3.5%
- CAD 9,758 to 14,882
- Rollout 3.6%
- CAD 10,036.80 to 15,307.20
- Holdback, 30 days after launch (10%)
- CAD 27,880 to 42,520
- Rack server x 2
- CAD 28,500 to 57,600. Billed up front, at cost, outside the milestones
- Rugged barcode scanner x 10
- CAD 17,600. Billed up front, at cost, outside the milestones
- Mobile computer with scanner x 10
- CAD 17,600. 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 8
- CAD 2,400. 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