Model Sight

Model Sight Calculator

Version 3.0

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

Edit quote

Cost Summary Data Volumes Formula Guide

Finance Formula Guide

This tab explains the commercial model from the same server-side calculations that drive the calculator and cost summary. Each formula below shows the actual quote inputs substituted into the logic so finance can reconcile the totals.

Dashboard Workload Logic

Each dashboard converts prompt assumptions into monthly run volumes before any pricing is applied.

Client prompt runs per month

client prompts x runs per month, summed across all dashboards

This is the base monthly volume for direct client prompts.

0 x 4 = 0

Brand-market prompt runs per month

brand prompts x brands x markets x runs per month, summed across all dashboards

This creates the scaled research workload across brand-market combinations.

2500 x 1 x 33 x 4 = 330,000

Google AI Mode searches per month

for enabled dashboards: client prompt runs + brand-market prompt runs

Google AI Mode uses SerpApi search-plan capacity only on dashboards where the feature is enabled.

0 = 0 searches per month

Total prompts per month for ModelSight licensing

client prompt runs + brand-market prompt runs + extraction runs + brand-mapping runs

The platform license charges on total prompt activity across the quote, not just dashboard-selected LLM rows.

1,320,012 prompts per month

OpenRouter and Data Processing Costs

Operational usage cost starts with dashboard LLM pricing in GBP and then adds Databricks before markup.

OpenRouter monthly cost

sum of monthly GBP for every selected dashboard model row, including fixed extraction and brand-mapping rows

This is the pure LLM run cost after USD model prices are converted to GBP using the quote exchange rate.

£15,486.89 per month

SerpApi monthly cost

smallest SerpApi tier where tier search cap >= total Google AI Mode searches, then convert USD to GBP

SerpApi pricing is tiered, so the quote uses the first plan that fully covers the enabled dashboard search volume.

No Google AI Mode dashboards enabled = £0.00 per month

Databricks monthly cost

full Databricks instance monthly cost x selected data processing tenancy %

Single tenant uses 100% of the instance. Multi-tenant uses the global Databricks multi-tenant percentage from settings.

£4,950.00 x 10% = £495.00 per month

Usage cost before markup

OpenRouter monthly cost + SerpApi monthly cost + Databricks monthly cost + Hosting monthly cost

SerpApi, Databricks, and hosting costs are added to the LLM run cost before usage markup is applied.

£15,486.89 + £0.00 + £495.00 + £1,150.00 = £17,131.89 per month, £205,582.70 per year

Usage fee to client

usage cost x (1 + usage markup %)

The sell price is the cost base plus the quote-level usage markup.

£205,582.70 x (1 + 0%) = £205,582.70 per year

Hosting, Support, and License Fees

Recurring non-usage charges are priced independently and then combined into annual fees.

Support and maintenance cost before markup

data cleansing monthly cost + support monthly cost

Support combines people-in-the-loop data cleansing with tenancy-adjusted support lines and the customer support tier matched to the quote's user count.

£61.89 + £2,000.00 = £2,061.89 per month, £24,742.68 per year

Support and maintenance fee to client

support and maintenance cost x (1 + support/maintenance markup %)

The recurring service fee is applied to the tenancy-adjusted cost base.

£24,742.68 x (1 + 0%) = £24,742.68 per year

ModelSight license before discount

(users x price per user for tier) + (total prompts per month x price per prompt) + (additional dashboards x price per additional dashboard)

Seat pricing comes from the active user tier, prompt pricing comes from total monthly prompt volume, and the first dashboard is included before additional dashboard charges apply.

(100 x £36.00) + (1,320,012 x £0.01) + (0 x £1,500.00) = £16,800.12 per month

ModelSight license after discount

license annual fee x (1 - license discount %)

The quote-level license discount only affects the license line, not usage or hosting/support.

£201,601.44 x (1 - 0%) = £201,601.44 per year

First-Year Totals

Annual fees are the recurring sell-price lines. TCO adds the one-off prompt setup fee for year one.

Prompt setup fee to client

prompt setup hours x prompt setup cost per hour x (1 + prompt setup markup %)

This is a one-off implementation charge and is not included in annual recurring fees.

10 x £150.00 x (1 + 200%) = £4,500.00 one-off, from cost base £1,500.00

Total client annual fees

usage fee annual + support/maintenance fee annual + discounted license fee annual

This is the recurring commercial run-rate for a full year.

£205,582.70 + £24,742.68 + £201,601.44 = £431,926.82

Total client annual TCO

total client annual fees + prompt setup one-off fee

The TCO shown on the quote is a first-year number because it includes the one-off setup fee.

£431,926.82 + £4,500.00 = £436,426.82

Dashboard Formula Guide

Each dashboard below shows how workload volumes are built up before model pricing is applied.

Dashboard 1

4 runs per month, 3 selected model rows, 2 fixed model rows, £15,486.89 OpenRouter cost per month, Google AI Mode disabled.

Client prompt runs per month

client prompts x runs per month

This is the direct prompt volume for the dashboard before brand-market scaling.

0 x 4 = 0

Brand-market prompt runs per month

brand prompts x brands x markets x runs per month

This is the core scaled workload for market-by-brand analysis.

2,500 x 1 x 33 x 4 = 330,000

Extraction runs per month

max(brand-market prompt runs, client prompt runs) x extraction prompts

Extraction uses whichever workload base is active, then multiplies by the extraction prompt count from settings.

max(330,000, 0) x 3 = 990,000

Brand-mapping runs per month

brands x runs per month x brand-mapping prompts

Brand mapping scales by brand count only, with prompt count coming from the global Brand Mapping Prompts setting.

1 x 4 x 3 = 12

Google AI Mode searches per month

if enabled: client prompt runs + brand-market prompt runs, else 0

Only enabled dashboards consume SerpApi search-plan capacity.

Disabled = 0 searches per month, 0 allocated SerpApi cost

Dashboard OpenRouter monthly cost

sum of all online, offline, extraction, and brand-mapping model rows for this dashboard

Selected dashboard LLMs price the client and brand-market prompts. Fixed rows cover extraction, AI Mode extraction checks, and brand mapping from global settings.

3 online + 0 offline + 2 fixed rows = £15,486.89 per month