Before discount / month
£16,800.12
Quote
P&G new quote-Shaving(v1)
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 new quote
Project
Shaving
Author
Richard
Created
23 Apr 2026, 14:49
Edited
23 Apr 2026, 14:50
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 | 33 | 2,500 | Off | 0 | 0 | 3 | £0.00 | £15,486.89 |
| Total costs | 0 | 0 | 0 | 3 | £0.00 | £15,486.89 | ||||
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 | 10 hours at £150.00 / hour | £1,500.00 | £ - | £ - | 200% | 66.67% | £4,500.00 | £ - | £ - | Manual prompt setup effort and one-off implementation work. |
| Total | Prompt setup totals | £1,500.00 | £ - | £ - | - | - | £4,500.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 £15,486.89 / month | £15,486.89 | £185,842.70 | 0% | 0% | £15,486.89 | £185,842.70 | 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 | £495.00 | £5,940.00 | 0% | 0% | £495.00 | £5,940.00 | Allocated share of the Databricks instance based on the quote's data processing tenancy. |
| Hosting | Selected hosting tenancy cost £1,150.00 / month | £1,150.00 | £13,800.00 | 0% | 0% | £1,150.00 | £13,800.00 | Allocated platform hosting cost for the selected tenancy. |
| Total | Open Router £15,486.89 + SerpApi £0.00 + Databricks £495.00 + Hosting £1,150.00 / month | £17,131.89 | £205,582.70 | 0% | 0% | £17,131.89 | £205,582.70 | 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 | 1 monthly; £20.63 / hour, x2.5 multiplier | £61.89 | £742.68 | 150% | 60% | £154.73 | £1,856.70 | Per-dashboard human-in-the-loop data cleansing based on configured cadence hours, runs, and markup multiplier. |
| Hosting Support | Tenancy-adjusted managed support services £1,200.00 / month | £1,200.00 | £14,400.00 | 0% | 0% | £1,200.00 | £14,400.00 | Managed hosting support lines from Global Settings, excluding customer support tickets. |
| Customer Support | 51-100 users customer support tier at £800.00 / month | £800.00 | £9,600.00 | 0% | 0% | £800.00 | £9,600.00 | User-tier customer support cost based on expected tickets and blended cost per ticket. |
| Total | Data cleansing £61.89 + support £2,000.00 / month (51-100 users customer support tier) | £2,061.89 | £24,742.68 | 0% | 0% | £2,061.89 | £24,742.68 | Data cleansing plus tenancy-adjusted support lines and customer support driven by the selected user tier. |
Model Sight License Fee
100 seats (51-100) + 1,320,012 prompts / month + 1 included dashboard
Before discount / year
£201,601.44
After discount / month
£16,800.12
After discount / year
£201,601.44
Fee to Client
| Category | One-off | By Month | By Year |
|---|---|---|---|
| Prompt Setup | £4,500.00 | £ - | £ - |
| Usage | £ - | £17,131.89 | £205,582.70 |
| Support & Maitenance | £ - | £2,061.89 | £24,742.68 |
| Model Sight License Fee | £ - | £16,800.12 | £201,601.44 |
| Total Fee to Client | £4,500.00 | £35,993.90 | £431,926.82 |
Summary
| Metric | Value |
|---|---|
| Total client TCO for year | £436,426.82 |
| Total per brand per year | £436,426.82 |
| Total per brand per month | £36,368.90 |
| Total per market per year | £13,225.06 |
| Total per market per month | £1,102.09 |
| Total per dashboard per year | £436,426.82 |
| Total per dashboard per month | £36,368.90 |
Total client annual fees
£431,926.82
Total client annual TCO
£436,426.82