What does Bottlenecks, Cannibalization and Advisory Pricing conclude, in numbers, about “Self-Cannibalization in a Product Line: Nested Logit and Diversion Ratios”?

Answer: Chapter 3 computes diversion ratios with a nested logit model: delisting the lowest-contributing 30% of SKUs raises profit by 5.3% in the baseline model, mainly through demand diverted to higher-margin products.

Scope of the numbers: Team capacities, demand parameters, margins, noise and contract parameters are illustrative or synthetic; all data are generated by its programs; the book is not investment, legal or tax advice. Marked boxes separate published evidence, runnable Python calculations (16 programs), classical sources and the author's hypotheses.

中文版

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: 5.3

   delist B5, B4, B3 (lowest contribution)
   units 4,921 -> 4,539; revenue RM 1,007,776 -> 1,010,436
   profit RM 282,460 -> 297,334 (+5.3%)
   parts: listing costs saved RM 7,500
          margin lost on delisted SKUs RM -17,786
          recaptured by the flagship RM 9,877
          recaptured by other SKUs RM 15,282
   flagship capped at 1,094 units: RM 282,460 -> 287,456 (+1.8%)

Key formula

\[s_j = \frac{e^{\delta_j/\lambda_g}}{D_g}\cdot\frac{D_g^{\lambda_g}}{e^{u_0} + \sum_h D_h^{\lambda_h}},\qquad D_g = \sum_{k \in g} e^{\delta_k/\lambda_g},\]
Show the full program
# Chapter 3. p06: Pareto pruning - delist the 30% of SKUs (3 of 10) with
# the lowest contribution (units x margin - listing cost) and recompute
# profit with the demand of p05. Each listed SKU costs RM 2,500 a month
# (inventory, listings, photos, support). The gain is split into its
# parts; then the flagship is capped at its current output (no spare
# capacity), so demand diverted to it beyond the cap is lost.
import importlib.util

def load(name):
    spec = importlib.util.spec_from_file_location(name, name + ".py")
    m = importlib.util.module_from_spec(spec)
    spec.loader.exec_module(m)
    return m

p05 = load("p05_nested_logit")
FIXED = 2500.0
MARGIN = {s[0]: s[3] for s in p05.SKUS}
PRICE = {s[0]: s[2] for s in p05.SKUS}
N = p05.SHOPPERS

def units(active, cap_f=None):
    s = p05.shares(active)
    u = {j: N * s[j] for j in active}
    if cap_f is not None and "F" in u:
        u["F"] = min(u["F"], cap_f)
    return u

def profit(active, cap_f=None):
    u = units(active, cap_f)
    return sum(u[j] * MARGIN[j] for j in u) - FIXED * len(active)

def tail(active, k):
    u = units(active)
    return sorted(active, key=lambda j: u[j] * MARGIN[j] - FIXED)[:k]

if __name__ == "__main__":
    allv = list(p05.ALL)
    cut = tail(allv, 3)
    kept = [j for j in allv if j not in cut]
    u0, u1 = units(allv), units(kept)
    p0, p1 = profit(allv), profit(kept)
    print("   delist {} (lowest contribution)".format(", ".join(cut)))
    print("   units {:,.0f} -> {:,.0f}; revenue RM {:,.0f} -> {:,.0f}".format(
        sum(u0.values()), sum(u1.values()),
        sum(u0[j] * PRICE[j] for j in u0),
        sum(u1[j] * PRICE[j] for j in u1)))
    print("   profit RM {:,.0f} -> {:,.0f} ({:+.1%})".format(
        p0, p1, p1 / p0 - 1))
    lost = sum(u0[j] * MARGIN[j] for j in cut)
    to_f = (u1["F"] - u0["F"]) * MARGIN["F"]
    other = sum((u1[j] - u0[j]) * MARGIN[j] for j in kept if j != "F")
    print("   parts: listing costs saved RM {:,.0f}".format(3 * FIXED))
    print("          margin lost on delisted SKUs RM {:,.0f}".format(-lost))
    print("          recaptured by the flagship RM {:,.0f}".format(to_f))
    print("          recaptured by other SKUs RM {:,.0f}".format(other))
    cap = u0["F"]
    q0, q1 = profit(allv, cap), profit(kept, cap)
    print("   flagship capped at {:,.0f} units: RM {:,.0f} -> {:,.0f}"
          " ({:+.1%})".format(cap, q0, q1, q1 / q0 - 1))

Single source and citation

Fan, Y. (2026). Enterprise Bottleneck Diagnostics, SKU Cannibalization Audits and Automation Return Bounds (Version 1.0.0), Chapter 3: Self-Cannibalization in a Product Line: Nested Logit and Diversion Ratios. 5D Library. https://doi.org/10.5281/zenodo.24090217

DOI: 10.5281/zenodo.24090217 · Read the monograph · 5DL-B-083 · v1.0.0 · CC-BY-NC-ND-4.0

BibTeX
@book{fan2026083,
  author    = {Fan, Yafu},
  title     = {Enterprise Bottleneck Diagnostics, SKU Cannibalization Audits and Automation Return Bounds},
  year      = {2026},
  publisher = {5D Library},
  edition   = {1.0.0},
  doi       = {10.5281/zenodo.24090217},
  url       = {https://doi.org/10.5281/zenodo.24090217}
}

Other chapter answers in this book