Repair yard work orders, rescued
Hypothetical. Not a client, not a result.
// The problem
A ship repair yard paid a vendor to replace its Access database for work orders and equipment maintenance; the rebuild stalled half done, and the yard still runs on the old database.
// What we would build
An architecture review first, with a written finding on what in the stalled build is worth keeping, then a rescue: the work-order system finished on the parts that hold up, an Android tablet app for the yard floor, equipment maintenance schedules, and every record moved from Access and checked. Hours and parts post to QuickBooks Online. Maintenance intervals are the ones your engineers set.
// What is in it
- An architecture review of the stalled build, in writing
- Work orders by vessel, job and trade, with hours and parts
- An Android tablet app for the yard floor, with photos
- Maintenance schedules for cranes, lifts and shop equipment
- Every record moved from Access and checked line by line
- Hours and parts posted to QuickBooks Online
// Stack
- Next.js
- Kotlin for Android
- PostgreSQL
- QuickBooks Online API
- DigitalOcean
// estimate
- Build
- ≈ US$107,000 to US$163,000, delivered within 28 weeksCAD 151,700 to 232,000
- Hosting
- ≈ US$176 a monthCAD 250 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
- Data mapping and sandbox connection
- 0.4 weeks
- Design approved
- 4.9 to 7.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
- Sync built and reconciled in sandbox
- 1.4 to 1.9 weeks
- Testing and fixes
- 0.4 to 0.9 weeks
- Store submission
- 0.9 to 1.4 weeks
- Launch
- 0.9 to 1.4 weeks
- Live cutover
- 0.9 to 1.4 weeks
- Hypercare
- 0.9 to 1.4 weeks
Outside our hands, and added to the calendar
- App store review
- 1 week
How it is paid
- Deposit 20%
- CAD 30,340 to 46,400
- Discovery 7.5%
- CAD 11,377.50 to 17,400.00
- Data mapping and sandbox connection 1.9%
- CAD 2,882.30 to 4,408.00
- Design approved 7.5%
- CAD 11,377.50 to 17,400.00
- Core features 7.7%
- CAD 11,680.90 to 17,864.00
- Full build 5.1%
- CAD 7,736.70 to 11,832.00
- First build on devices 15%
- CAD 22,755 to 34,800
- Sync built and reconciled in sandbox 5.8%
- CAD 8,798.60 to 13,456.00
- Testing and fixes 2.5%
- CAD 3,792.50 to 5,800.00
- Store submission 5%
- CAD 7,585 to 11,600
- Launch 7.5%
- CAD 11,377.50 to 17,400.00
- Live cutover 1.9%
- CAD 2,882.30 to 4,408.00
- Hypercare 2.6%
- CAD 3,944.20 to 6,032.00
- Holdback, 30 days after launch (10%)
- CAD 15,170 to 23,200