Example projectWeb app
Multi-location sales and labour dashboard
Hypothetical. Not a client, not a result.
// The problem
A franchise owner with eight locations gets sales from the point of sale, labour from the scheduler and delivery from three marketplaces, each in its own report.
// What we would build
A dashboard that reads the point of sale, the scheduler and the delivery marketplaces into one model, so the owner sees sales, labour cost and delivery share by location and by hour, compared fairly.
// What is in it
- Sales by location, daypart and channel
- Labour cost as a share of sales, by hour
- Delivery marketplace share and commission
- Locations compared on the same terms
- Exports for the accountant and franchisor
// Stack
- Next.js
- PostgreSQL
- dbt
- Point of sale and scheduling interfaces
- DigitalOcean
// estimate
- Build
- ≈ US$34,200 to US$52,300, delivered within 13 weeksCAD 48,700 to 74,500
- 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 point of sale vendor
- 1 to 4 weeks
How it is paid
- Deposit 30%
- CAD 14,610 to 22,350
- Discovery 6.6%
- CAD 3,214.20 to 4,917.00
- Design approved 6.6%
- CAD 3,214.20 to 4,917.00
- Core features 20%
- CAD 9,740 to 14,900
- Full build 13.3%
- CAD 6,477.10 to 9,908.50
- Testing and fixes 6.6%
- CAD 3,214.20 to 4,917.00
- Launch 6.9%
- CAD 3,360.30 to 5,140.50
- Holdback, 30 days after launch (10%)
- CAD 4,870 to 7,450