Subscription product operations

Subscription expansion attribution calculator

Exact sequential bridge: change seats first at old price, then price across ending seats, then usage. Components may be negative; no interaction is double counted.

Your numbers

Use the units shown. Results update as you change valid inputs.

YOUR RESULT

Exact sequential bridge: change seats first at old price, then price across ending seats, then usage. Components may be negative; no interaction is double counted.

THE NUMBERS, EXPLAINED

How to use this calculator.

Exact sequential bridge: change seats first at old price, then price across ending seats, then usage. Components may be negative; no interaction is double counted.

Start with your inputs

Enter beginning paid seats, ending paid seats, beginning recurring price per seat (currency), ending recurring price per seat (currency), beginning recurring usage charge (currency), ending recurring usage charge (currency). Keep amounts in the units shown on each field. The example is a starting point, not a recommended value.

InputExample value
Beginning paid seats10
Ending paid seats12
Beginning recurring price per seat (currency)20
Ending recurring price per seat (currency)25
Beginning recurring usage charge (currency)100
Ending recurring usage charge (currency)150

A worked example

With the example inputs above, seat-count contribution to revenue change is 40. Change the inputs to explore your own scenario.

All results for the example inputs above
ResultExample answer
Seat-count contribution to revenue change40
Plan-price contribution to revenue change60
Usage contribution to revenue change50
Total recurring-revenue change (currency)150

How this is calculated

Seat-count contribution to revenue change

Value seat changes at the beginning seat price.

Plan-price contribution to revenue change

Value price changes across ending seats, allocating interaction here.

Usage contribution to revenue change

Subtract beginning usage revenue from ending usage revenue.

Total recurring-revenue change (currency)

Reconcile the three components to actual revenue change.

Symbols and units
a
Beginning paid seats
b
Ending paid seats
c
Beginning recurring price per seat (currency)
d
Ending recurring price per seat (currency)
e
Beginning recurring usage charge (currency)
f
Ending recurring usage charge (currency)

Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.

Assumptions and limits

Exact sequential bridge: change seats first at old price, then price across ending seats, then usage. Components may be negative; no interaction is double counted.

Calculations use the values you enter. Blank or invalid inputs show an error instead of silently substituting zero. Results are displayed to useful precision; calculations retain the underlying numeric precision.

Questions about this tool

What does the result tell me?

Seat-count contribution to revenue change; Plan-price contribution to revenue change; Usage contribution to revenue change; Total recurring-revenue change (currency). The result applies to the method and inputs described above. Check the units and assumptions before using it in a decision.

Why might another calculator differ?

Differences in units, rounding, timing or model definitions can produce different answers. Compare the input definitions and the method, rather than only the final number. For this tool: Exact sequential bridge: change seats first at old price, then price across ending seats, then usage. Components may be negative; no interaction is double counted.

Are my inputs stored or sent to AI?

Calculations on this page happen in your browser. The separate AI question finder sends its submitted conversation to OpenAI; these calculator fields are not sent. Favourites and recent tool names are stored locally. A shared link contains the inputs you choose to include.

Further reading

OpenStax: Describe and Identify Cost Drivers ↗

Background reading; this does not imply endorsement or independent review of SumFizz.

Review status

Software example and browser checks are recorded in our quality report. No external expert review is claimed. Created with coding assistance; calculations run as ordinary browser code.

Read the quality report →