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
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
- Chapter 1 · A Queueing Network of Four Teams and Its Bottleneck
- Chapter 2 · Work Pushed into the Bottleneck, Communication Channels and Variability
- Chapter 4 · The Margin Dilution Matrix and the Limits of "Cut 30%"
- Chapter 5 · A Fixed Base Fee plus a Share of the Gain: Contracts under Double Moral Hazard
- Chapter 6 · Paying for Results: Stepped Shares, Attitudes to Risk and Measuring the Baseline
- Chapter 7 · The Guanzi's "Cheng Ma" and "Qing Zhong II", Song Market Exchange and the Monopoly Goods Bureau, and the Han Feizi's "Holding the Name to the Reality"
- Chapter 8 · Finding the Bottleneck in the Logs, a Contract Ledger and a Pre-Registered Switchback Experiment