What does Subscription Stacking, Dunning and Annual Plans conclude, in numbers, about “Carving Out a Subscription Layer: the Ratio of Must-Have Use to the Billing Period”?

Answer: A subscription layer stands up when must-have uses in each billing period clearly exceed the value threshold. In an uneven population the ratio must reach about 2 for a first-renewal rate of seven in ten; in an even population about 1.31 suffices. Even at high usage, part of an uneven population does not use the product at all in a period, so first-month churn has a floor set by composition. With illustrative parameters, a monthly layer beats an outright sale only at about six must-have uses a month, and much of the extra money that quarterly billing collects comes from customers who barely use the product, which makes it the most fragile revenue in the base.

Scope of the numbers: Its subscriber counts, prices, churn, recovery and discount rates are illustrative, all calculations are generated by its programs, and none corresponds to a real customer or transaction. It is not legal, accounting, tax or investment advice and promises no level of income; "steady" means only that revenue can be anticipated, with premises and failure conditions stated.

中文版

Data table

The numbers below are printed verbatim by the chapter's Python program and can be reproduced by running it. standard-library Python onlyprinted values that match the answer: 1.31

uses per cycle m renew u*1 u*=2 u*=3 (shape k = 1.5)
0.50.350 0.107 0.031
1.00.535 0.256 0.117
2.00.719 0.479 0.307
3.00.808 0.615 0.455
4.00.858 0.702 0.561
6.00.911 0.803 0.696
8.00.937 0.858 0.775
mean uses needed for a first-renewal rate of 0.70
u*1 k = 1.5: 1.85 k = 10: 1.28 ratio m/u*: 1.85
u*2 k = 1.5: 3.97 k = 10: 2.62 ratio m/u*: 1.98
u*3 k = 1.5: 6.08 k = 10: 3.92 ratio m/u*: 2.03
share with zero uses even at m8, k = 1.5 0.063
ratio m/u* for u*2 when k = 10 1.31
Show the full program
# Chapter 3. p31: first-renewal rate as a function of must-have usage.
# Uses in one billing cycle are Poisson with a person-level rate that is
# Gamma-distributed (shape k), so uses are negative binomial with mean m.
# A subscriber renews only if the cycle held at least u* uses that
# justify the price. k, u* and the target rate 0.70 are illustrative.
import math


def p_at_least(u, m, k):
    if u <= 0:
        return 1.0
    p = k / (k + m)
    terms = []
    for x in range(u):
        lg = math.lgamma(x + k) - math.lgamma(k) - math.lgamma(x + 1)
        terms.append(math.exp(lg + k * math.log(p) + x * math.log(1 - p)))
    return 1.0 - math.fsum(terms)


def m_needed(u, k, target):
    lo, hi = 1e-6, 200.0
    for _ in range(100):
        mid = (lo + hi) / 2.0
        if p_at_least(u, mid, k) < target:
            lo = mid
        else:
            hi = mid
    return hi


K = 1.5
print("uses per cycle m   renew u*=1   u*=2   u*=3   (shape k = 1.5)")
for m in (0.5, 1.0, 2.0, 3.0, 4.0, 6.0, 8.0):
    print("%15.1f  %11.3f  %5.3f  %5.3f" % (
        m, p_at_least(1, m, K), p_at_least(2, m, K), p_at_least(3, m, K)))
print()
print("mean uses needed for a first-renewal rate of 0.70")
for u in (1, 2, 3):
    print("  u* = %d   k = 1.5: %5.2f   k = 10: %5.2f   ratio m/u*: %4.2f" % (
        u, m_needed(u, K, 0.70), m_needed(u, 10.0, 0.70),
        m_needed(u, K, 0.70) / u))
print("share with zero uses even at m = 8, k = 1.5    %.3f" % (
    1.0 - p_at_least(1, 8.0, K)))
print("ratio m/u* for u* = 2 when k = 10                %.2f" % (
    m_needed(2, 10.0, 0.70) / 2))

Single source and citation

Fan, Y. (2026). Stacking Monthly Recurring Revenue, Involuntary-Churn Dunning Recovery and Upfront Annual Cash Lock-In (Version 1.0.0), Chapter 3: Carving Out a Subscription Layer: the Ratio of Must-Have Use to the Billing Period. 5D Library. DOI pending

DOI pending · monograph page goes live after publication · 5DL-B-367 · v1.0.0 · CC-BY-NC-ND-4.0

BibTeX
@book{fan2026367,
  author    = {Fan, Yafu},
  title     = {Stacking Monthly Recurring Revenue, Involuntary-Churn Dunning Recovery and Upfront Annual Cash Lock-In},
  year      = {2026},
  publisher = {5D Library},
  edition   = {1.0.0},
  note      = {DOI pending}
}

Other chapter answers in this book