Before discount / month
£3,060.24
Quote
P&G-2DBs; 300 prompts per DB - 01.05.26(v1 copy)
Quote assumptions are saved independently from Global Settings. Use the Data Volumes tab to inspect OpenRouter and Google AI Mode usage, then move to Cost Summary for the enterprise-style commercial table.
Client
P&G
Project
2DBs; 300 prompts per DB - 01.05.26
Author
Richard Clifford
Created
5 May 2026, 11:18
Edited
5 May 2026, 11:31
Commercial Settings
Quote-level markup, setup, and discount settings that drive the commercial rollup.
Dashboard Cost Table
Workbook-style monthly cost view for each dashboard, with a final totals row across the full quote.
| # LoBs | LoB | Brands | Markets | LOB Prompts | Google AI | AI Searches PM | Offline LLMs | Online LLMs | SerpApi costs PM | OpenRouter costs PM |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Dashboard 1 | 1 | 5 | 300 | Off | 0 | 0 | 3 | £0.00 | £818.14 |
| 2 | Dashboard 2 | 1 | 5 | 300 | Off | 0 | 0 | 3 | £0.00 | £818.14 |
| Total costs | 0 | 0 | 0 | 6 | £0.00 | £1,636.29 | ||||
Quote Cost Rollup
The rollup shows OpenRouter, SerpApi, and quote-level costs before the final commercial total.
Set up
| Category | Notes | Cost: One-off | Cost: Monthly | Cost: Annual | Markup | Margin | Fee to client: One-off | Fee to client: Monthly | Fee to client: Annual | Comments |
|---|---|---|---|---|---|---|---|---|---|---|
| Prompt Setup | 0 hours at £0.00 / hour | £0.00 | £ - | £ - | 0% | 0% | £0.00 | £ - | £ - | Manual prompt setup effort and one-off implementation work. |
| Total | Prompt setup totals | £0.00 | £ - | £ - | - | - | £0.00 | £ - | £ - | Set up totals. |
Usage Costs
| Category | Notes | Cost: Monthly | Cost: Annual | Markup | Margin | Fee to client: Monthly | Fee to client: Annual | Comments |
|---|---|---|---|---|---|---|---|---|
| OpenRouter | Selected dashboard LLMs £1,636.29 / month | £1,636.29 | £19,635.48 | 0% | 0% | £1,636.29 | £19,635.48 | Recurring LLM execution cost from dashboard selections, extraction, AI Mode extraction checks, and brand mapping. |
| SerpApi | Google AI Mode disabled on all dashboards | £0.00 | £0.00 | 0% | 0% | £0.00 | £0.00 | Tiered SerpApi search-plan cost for dashboards where Google AI Mode is enabled. |
| Databricks | Multi-tenant data processing on full instance £4,950.00 / month | £990.00 | £11,880.00 | 0% | 0% | £990.00 | £11,880.00 | Allocated share of the Databricks instance based on the quote's data processing tenancy. |
| Hosting | Selected hosting tenancy cost £230.00 / month | £230.00 | £2,760.00 | 100% | 50% | £460.00 | £5,520.00 | Allocated platform hosting cost for the selected tenancy. |
| Total | Open Router £1,636.29 + SerpApi £0.00 + Databricks £990.00 + Hosting £230.00 / month | £2,856.29 | £34,275.48 | 0% | 0% | £2,856.29 | £34,275.48 | Combined recurring usage cost from OpenRouter, SerpApi, Databricks, and hosting. |
Support & Maintenance
| Category | Notes | Cost: Monthly | Cost: Annual | Markup | Margin | Fee to client: Monthly | Fee to client: Annual | Comments |
|---|---|---|---|---|---|---|---|---|
| Data Cleansing | 2 weekly; £20.63 / hour, x2.5 multiplier | £330.08 | £3,960.96 | 150% | 60% | £825.20 | £9,902.40 | Per-dashboard human-in-the-loop data cleansing based on configured cadence hours, runs, and markup multiplier. |
| Hosting Support | Tenancy-adjusted managed support services £400.00 / month | £400.00 | £4,800.00 | 100% | 50% | £800.00 | £9,600.00 | Managed hosting support lines from Global Settings, excluding customer support tickets. |
| Customer Support | 1-24 users customer support tier at £200.00 / month | £200.00 | £2,400.00 | 100% | 50% | £400.00 | £4,800.00 | User-tier customer support cost based on expected tickets and blended cost per ticket. |
| Total | Data cleansing £330.08 + support £600.00 / month (1-24 users customer support tier) | £930.08 | £11,160.96 | 100% | 50% | £1,860.16 | £22,321.92 | Data cleansing plus tenancy-adjusted support lines and customer support driven by the selected user tier. |
Model Sight License Fee
24 seats (1-24) + 48,024 prompts / month + 1 included dashboard + 1 additional dashboard at £1,500.00 / month
Before discount / year
£36,722.88
After discount / month
£3,060.24
After discount / year
£36,722.88
Fee to Client
| Category | One-off | By Month | By Year |
|---|---|---|---|
| Prompt Setup | £0.00 | £ - | £ - |
| Usage | £ - | £2,856.29 | £34,275.48 |
| Support & Maitenance | £ - | £1,860.16 | £22,321.92 |
| Model Sight License Fee | £ - | £3,060.24 | £36,722.88 |
| Total Fee to Client | £0.00 | £7,776.69 | £93,320.28 |
Summary
| Metric | Value |
|---|---|
| Total client TCO for year | £93,320.28 |
| Total per brand per year | £46,660.14 |
| Total per brand per month | £3,888.34 |
| Total per market per year | £9,332.03 |
| Total per market per month | £777.67 |
| Total per dashboard per year | £46,660.14 |
| Total per dashboard per month | £3,888.34 |
Total client annual fees
£93,320.28
Total client annual TCO
£93,320.28