Multi-centre dashboard
Hypothetical. Not a client, not a result.
// The problem
The director of a group of centres sees enrolment, attendance, fees and staffing in separate spreadsheets, each kept a little differently by each centre.
// What we would build
A dashboard that reads enrolment, attendance, fees and staff hours into one model, so the director sees occupancy, waitlist length, fees owed and staff hours by centre and room, measured the same way everywhere.
// What is in it
- Occupancy and waitlist by centre and age group
- Attendance against enrolment
- Fees billed, paid and owed
- Staff hours against children in care
- Exports for the board and funders
// Stack
- Next.js
- PostgreSQL
- dbt
- AWS
// estimate
- Build
- ≈ US$49,100 to US$75,000, delivered within 14 weeksCAD 69,900 to 106,800
- Hosting
- ≈ US$176 a monthCAD 250 a month
- Support
- ≈ US$1,000 a monthCAD 1,425 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.4 to 3.4 weeks
- Core features
- 1.9 to 2.9 weeks
- Full build
- 1.4 to 1.9 weeks
- Testing and fixes
- 0.9 to 1.4 weeks
- Launch
- 0.9 to 1.4 weeks
How it is paid
- Deposit 30%
- CAD 20,970 to 32,040
- Discovery 6.6%
- CAD 4,613.40 to 7,048.80
- Design approved 6.6%
- CAD 4,613.40 to 7,048.80
- Core features 20%
- CAD 13,980 to 21,360
- Full build 13.3%
- CAD 9,296.70 to 14,204.40
- Testing and fixes 6.6%
- CAD 4,613.40 to 7,048.80
- Launch 6.9%
- CAD 4,823.10 to 7,369.20
- Holdback, 30 days after launch (10%)
- CAD 6,990 to 10,680