Waitlist off the old database
Hypothetical. Not a client, not a result.
// The problem
A nonprofit housing provider runs its waitlist, offers and annual income reviews in a Microsoft Access database built years ago by a volunteer who has since left, and only one staff member knows how to run it.
// What we would build
We start with a short review of the old database, the forms behind it and how your staff really use it, and write down what to keep and what to drop. Then we rebuild it as a web system, move every applicant and household across with a check against the old totals, and retire the Access file. Applicants can see their status online in English and French. Priority rules are the ones your board and funder set.
// What is in it
- A written review of the old database before any rebuild starts
- Applicants, households and priority categories moved across and reconciled
- Offers, refusals and move-ins recorded against each unit
- Annual income reviews with reminders and document uploads
- Applicants check their own status online, in English and French
- Reports for your funder from the same records
// Stack
- Next.js
- PostgreSQL
- Access export scripts
- AWS Canada
// estimate
- Build
- ≈ US$94,400 to US$144,000, delivered within 20 weeksCAD 134,400 to 205,500
- Hosting
- ≈ US$492 a monthCAD 700 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
- 3.4 to 5.4 weeks
- Core features
- 2.9 to 4.9 weeks
- Full build
- 1.9 to 3.4 weeks
- Testing and fixes
- 0.9 weeks
- Charges checked against last year's files
- 0.9 to 1.4 weeks
- Launch
- 0.9 to 1.4 weeks
Outside our hands, and added to the calendar
- API access from your software vendor
- 1 to 4 weeks
How it is paid
- Deposit 20%
- CAD 26,880 to 41,100
- Discovery 6.8%
- CAD 9,139.20 to 13,974.00
- Design approved 6.8%
- CAD 9,139.20 to 13,974.00
- Core features 20.4%
- CAD 27,417.60 to 41,922.00
- Full build 13.6%
- CAD 18,278.40 to 27,948.00
- Testing and fixes 6.8%
- CAD 9,139.20 to 13,974.00
- Charges checked against last year's files 8.7%
- CAD 11,692.80 to 17,878.50
- Launch 6.9%
- CAD 9,273.60 to 14,179.50
- Holdback, 30 days after launch (10%)
- CAD 13,440 to 20,550