Scheduling with licence tracking
Hypothetical. Not a client, not a result.
// The problem
A security firm builds its schedule in an old spreadsheet full of macros that one person understands, and finds out a guard's licence has lapsed only when a client asks.
// What we would build
We replace the spreadsheet with a scheduling app that fills posts from qualified guards, tracks licence, first aid and site training expiry dates, warns before anything lapses, and sends approved hours to payroll. Licence rules come from your compliance lead.
// What is in it
- Posts and shifts filled only from guards qualified for the site
- Licence, first aid and site training expiry tracked with warnings
- Shift offers and swaps by text message
- Approved hours sent to payroll
- The old spreadsheet's data moved across and checked with you
// Stack
- Next.js
- PostgreSQL
- Twilio
- Payroll API
- DigitalOcean Toronto
// estimate
- Build
- ≈ US$59,300 to US$90,700, delivered within 16 weeksCAD 84,500 to 129,200
- 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
- 1.9 to 3.4 weeks
- Full build
- 1.4 to 2.4 weeks
- Testing and fixes
- 0.9 to 1.4 weeks
- Launch
- 0.9 to 1.4 weeks
How it is paid
- Deposit 20%
- CAD 16,900 to 25,840
- Discovery 7.7%
- CAD 6,506.50 to 9,948.40
- Design approved 7.7%
- CAD 6,506.50 to 9,948.40
- Core features 23.3%
- CAD 19,688.50 to 30,103.60
- Full build 15.5%
- CAD 13,097.50 to 20,026.00
- Testing and fixes 7.7%
- CAD 6,506.50 to 9,948.40
- Launch 8.1%
- CAD 6,844.50 to 10,465.20
- Holdback, 30 days after launch (10%)
- CAD 8,450 to 12,920