Before discount / month
£24,525.48
Quote
P&G Test-Monthly Runs(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 Test
Project
Monthly Runs
Author
Richard
Created
13 Apr 2026, 09:14
Edited
22 Apr 2026, 14:29
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 | Grooming - Braun | 1 | 39 | 300 | On | 11,700 | 4 | 5 | £71.89 | £2,569.92 |
| 2 | Grooming - Shave | 1 | 41 | 300 | On | 12,300 | 5 | 5 | £75.57 | £2,736.39 |
| 3 | OralCare - Oral-B | 1 | 30 | 300 | On | 9,000 | 5 | 5 | £55.30 | £2,002.26 |
| 4 | OralCare - Dentures | 1 | 5 | 300 | On | 1,500 | 5 | 5 | £9.22 | £333.78 |
| 5 | PHC | 1 | 12 | 300 | On | 3,600 | 5 | 5 | £22.12 | £800.96 |
| 6 | BabyCare | 1 | 11 | 300 | On | 3,300 | 5 | 5 | £20.28 | £734.22 |
| 7 | Fabric | 1 | 30 | 300 | On | 9,000 | 5 | 5 | £55.30 | £2,002.26 |
| 8 | HomeCare | 1 | 28 | 300 | On | 8,400 | 5 | 5 | £51.61 | £1,868.78 |
| 9 | Beauty | 1 | 29 | 300 | On | 8,700 | 5 | 5 | £53.45 | £1,935.52 |
| 10 | Clearblue | 1 | 29 | 300 | On | 8,700 | 5 | 5 | £53.45 | £1,935.52 |
| 11 | FemCare | 1 | 13 | 300 | On | 3,900 | 5 | 5 | £23.96 | £867.69 |
| 12 | Old Spice | 1 | 28 | 300 | On | 8,400 | 5 | 5 | £51.61 | £1,868.78 |
| 13 | New one to show capability | 1 | 10 | 600 | Off | 0 | 0 | 2 | £0.00 | £3,051.13 |
| Total costs | 12 | 88,500 | 59 | 62 | £543.75 | £22,707.21 | ||||
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 | 15 hours at £150.00 / hour | £2,250.00 | £ - | £ - | 200% | 66.67% | £6,750.00 | £ - | £ - | Manual prompt setup effort and one-off implementation work. |
| Total | Prompt setup totals | £2,250.00 | £ - | £ - | - | - | £6,750.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 £22,707.21 / month | £22,707.21 | £272,486.48 | 0% | 0% | £22,707.21 | £272,486.48 | Recurring LLM execution cost from dashboard selections, extraction, AI Mode extraction checks, and brand mapping. |
| SerpApi | 12 Google AI Mode dashboards, 88,500 searches / month on Searcher | £543.75 | £6,525.00 | 0% | 0% | £543.75 | £6,525.00 | Tiered SerpApi search-plan cost for dashboards where Google AI Mode is enabled. |
| Databricks | Single-tenant data processing on full instance £4,950.00 / month | £4,950.00 | £59,400.00 | 0% | 0% | £4,950.00 | £59,400.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 £22,707.21 + SerpApi £543.75 + Databricks £4,950.00 + Hosting £230.00 / month | £28,430.96 | £341,171.48 | 0% | 0% | £28,430.96 | £341,171.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 | 13 monthly; £20.63 / hour, x2.5 multiplier | £804.57 | £9,654.84 | 150% | 60% | £2,011.42 | £24,137.10 | Per-dashboard human-in-the-loop data cleansing based on configured cadence hours, runs, and markup multiplier. |
| Hosting Support | Tenancy-adjusted managed support services £0.00 / month | £0.00 | £0.00 | 100% | 50% | £0.00 | £0.00 | Managed hosting support lines from Global Settings, excluding customer support tickets. |
| Customer Support | 25-50 users customer support tier at £400.00 / month | £400.00 | £4,800.00 | 100% | 50% | £800.00 | £9,600.00 | User-tier customer support cost based on expected tickets and blended cost per ticket. |
| Total | Data cleansing £804.57 + support £400.00 / month (25-50 users customer support tier) | £1,204.57 | £14,454.84 | 100% | 50% | £2,409.14 | £28,909.68 | Data cleansing plus tenancy-adjusted support lines and customer support driven by the selected user tier. |
Model Sight License Fee
50 seats (25-50) + 450,048 prompts / month + 1 included dashboard + 12 additional dashboards at £1,500.00 / month
Before discount / year
£294,305.76
After discount / month
£22,072.93
After discount / year
£264,875.18
Fee to Client
| Category | One-off | By Month | By Year |
|---|---|---|---|
| Prompt Setup | £6,750.00 | £ - | £ - |
| Usage | £ - | £28,430.96 | £341,171.48 |
| Support & Maitenance | £ - | £2,409.14 | £28,909.68 |
| Model Sight License Fee | £ - | £22,072.93 | £264,875.18 |
| Total Fee to Client | £6,750.00 | £52,913.03 | £634,956.35 |
Summary
| Metric | Value |
|---|---|
| Total client TCO for year | £641,706.35 |
| Total per brand per year | £49,362.03 |
| Total per brand per month | £4,113.50 |
| Total per market per year | £2,103.96 |
| Total per market per month | £175.33 |
| Total per dashboard per year | £49,362.03 |
| Total per dashboard per month | £4,113.50 |
Total client annual fees
£634,956.35
Total client annual TCO
£641,706.35