Grievance case files, rebuilt
Hypothetical. Not a client, not a result.
// The problem
A union tracks grievances in an old Access database on one staff computer, with deadlines in a paper diary, and nobody is sure every step was filed in time.
// What we would build
We begin with a short review of the old database and how cases move through it. Then we move every case into a web app where each grievance has its steps, deadlines from your agreement, documents and notes, stewards see their own cases, and staff are warned before a deadline passes.
// What is in it
- A review of the old database and a plain plan before we build
- Every past case moved in and checked with your staff
- Steps and deadlines set from your agreement, with warnings
- Documents and notes kept with each case
- Stewards see their own cases; staff see all of them
// Stack
- Next.js
- PostgreSQL
- Access import
- DigitalOcean Toronto
// estimate
- Build
- ≈ US$70,300 to US$108,000, delivered within 17 weeksCAD 100,100 to 153,100
- 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
- Design approved
- 2.9 to 4.9 weeks
- Core features
- 2.4 to 3.9 weeks
- Full build
- 1.4 to 2.4 weeks
- Testing and fixes
- 0.9 weeks
- Moved records checked with your staff
- 0.9 weeks
- Launch
- 0.9 to 1.4 weeks
How it is paid
- Deposit 20%
- CAD 20,020 to 30,620
- Discovery 6.8%
- CAD 6,806.80 to 10,410.80
- Design approved 6.8%
- CAD 6,806.80 to 10,410.80
- Core features 20.4%
- CAD 20,420.40 to 31,232.40
- Full build 13.6%
- CAD 13,613.60 to 20,821.60
- Testing and fixes 6.8%
- CAD 6,806.80 to 10,410.80
- Moved records checked with your staff 8.7%
- CAD 8,708.70 to 13,319.70
- Launch 6.9%
- CAD 6,906.90 to 10,563.90
- Holdback, 30 days after launch (10%)
- CAD 10,010 to 15,310