Bookings and demand dashboard
Hypothetical. Not a client, not a result.
// The problem
A museum and a family of attractions see ticket sales in one system and reseller sales in emails, so pricing and staffing are set on last year's guesses.
// What we would build
A dashboard that reads the booking system, resellers and the till into one model, so managers see demand by day, product and channel, how far ahead guests book, and which channels pay for themselves.
// What is in it
- Bookings by day, product and channel
- How far ahead guests book, by season
- Channel costs set against what each brings in
- Capacity used against capacity offered
- Exports for finance and the board
// Stack
- Next.js
- PostgreSQL
- dbt
- Booking and till interfaces
- DigitalOcean
// estimate
- Build
- ≈ US$36,200 to US$55,300, delivered within 14 weeksCAD 51,600 to 78,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.9 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 resellers and agencies
- 1 to 4 weeks
How it is paid
- Deposit 30%
- CAD 15,480 to 23,640
- Discovery 6.6%
- CAD 3,405.60 to 5,200.80
- Design approved 6.6%
- CAD 3,405.60 to 5,200.80
- Core features 20%
- CAD 10,320 to 15,760
- Full build 13.3%
- CAD 6,862.80 to 10,480.40
- Testing and fixes 6.6%
- CAD 3,405.60 to 5,200.80
- Launch 6.9%
- CAD 3,560.40 to 5,437.20
- Holdback, 30 days after launch (10%)
- CAD 5,160 to 7,880