Utilisation and project margin dashboard
Hypothetical. Not a client, not a result.
// The problem
An architecture practice sees time in one system, invoices in another and project budgets in spreadsheets, and learns a project ran over only when it is finished.
// What we would build
A dashboard that reads time, billing and project budgets into one model, so partners see utilisation by person and team, and budget used against fees earned on every project, week by week.
// What is in it
- Utilisation by person, team and office
- Budget used against fees earned, per project
- Work in progress and unbilled time
- Forecast load for the coming weeks
- Exports for partners and the accountant
// Stack
- Next.js
- PostgreSQL
- dbt
- Time and billing interfaces
- DigitalOcean
// estimate
- Build
- ≈ US$34,300 to US$52,500, delivered within 13 weeksCAD 48,900 to 74,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.4 to 2.4 weeks
- Full build
- 0.9 to 1.4 weeks
- Testing and fixes
- 0.9 to 1.4 weeks
- Launch
- 0.9 to 1.4 weeks
Outside our hands, and added to the calendar
- Interface access from your practice management vendor
- 1 to 4 weeks
How it is paid
- Deposit 30%
- CAD 14,670 to 22,440
- Discovery 6.6%
- CAD 3,227.40 to 4,936.80
- Design approved 6.6%
- CAD 3,227.40 to 4,936.80
- Core features 20%
- CAD 9,780 to 14,960
- Full build 13.3%
- CAD 6,503.70 to 9,948.40
- Testing and fixes 6.6%
- CAD 3,227.40 to 4,936.80
- Launch 6.9%
- CAD 3,374.10 to 5,161.20
- Holdback, 30 days after launch (10%)
- CAD 4,890 to 7,480