What does Studio Overbooking, Prepaid Float and Ascension conclude, in numbers, about “Harvest the Breakage or Get the Sessions Used: Where NPV Reverses”?

Answer: Chapter 5 finds where net present values reverse: a card without reminders is worth 663.5, an activated card without plan sales 468.6, and the order reverses once plan uptake reaches 0.0632; with reminders the best moment for the offer is session 8, without them session 3.

Scope of the numbers: Its clients, prices, rates and costs are illustrative models; all calculations are generated by its programs; the book is not financial, accounting, legal or medical advice and makes no claim about the effect of any treatment or service. 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. printed values that match the answer: 0.0632, 468.6, 663.5

harvest value with renewal 0.00 / 0.05 / 0.10: 663.5 / 694.3 / 728.1
activate, by renewal r_A and plan uptake q
r_Aq=0.00q=0.02q=0.05q=0.10q needed
0.05468.6540.1647.2825.80.0632
0.30610.3681.8788.9967.50.0235
0.50805.1876.5983.61162.20.0000
0.701182.31253.81360.91539.50.0000
Show the full program
# Chapter 5. p09: Harvest the breakage, or get the sessions used? Per
# card sold at 800 (sessions cost 35 each to serve). Harvest: no
# reminders; 3.90 sessions used (p07, first gap 25 days); renewal r_H.
# Activate: reminders cost 20 a card; 9.49 sessions used; renewal r_A;
# 0.992 of clients reach session 7, where a share q buys an annual plan
# with a margin of 3600. A renewing client buys the same card a year
# later, so with monthly discount 0.01 the value of a card stream is
# V = M / (1 - r * d), d = 1.01^-12. No sampling.
D = 1.01 ** -12
C, PRICE, PLAN, REACH7 = 35.0, 800.0, 3600.0, 0.992

def value(margin, r, extra=0.0):
    first = margin + extra
    return first + r * D * margin / (1 - r * D)

def harvest(r_h):
    return value(PRICE - C * 3.90, r_h)

def activate(r_a, q):
    return value(PRICE - C * 9.49 - 20.0, r_a, REACH7 * q * PLAN)

def breakeven_q(r_h, r_a):
    gap = harvest(r_h) - activate(r_a, 0.0)
    return max(0.0, gap / (REACH7 * PLAN))

if __name__ == "__main__":
    print("   harvest value with renewal 0.00 / 0.05 / 0.10: "
          "{:.1f} / {:.1f} / {:.1f}".format(harvest(0.0), harvest(0.05),
                                            harvest(0.10)))
    print("   activate, by renewal r_A and plan uptake q")
    print("     r_A     q=0.00    q=0.02    q=0.05    q=0.10   q needed")
    for r_a in (0.05, 0.30, 0.50, 0.70):
        row = [activate(r_a, q) for q in (0.0, 0.02, 0.05, 0.10)]
        print("     {:4.2f}  ".format(r_a) + "  ".join(
            "{:8.1f}".format(v) for v in row) +
            "  {:8.4f}".format(breakeven_q(0.05, r_a)))

Single source and citation

Fan, Y. (2026). Appointment Studio Overbooking Queues, Prepaid Float Dynamics and High-Ticket Ascension Ladders (Version 1.0.0), Chapter 5: Harvest the Breakage or Get the Sessions Used: Where NPV Reverses. 5D Library. DOI pending

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

BibTeX
@book{fan2026107,
  author    = {Fan, Yafu},
  title     = {Appointment Studio Overbooking Queues, Prepaid Float Dynamics and High-Ticket Ascension Ladders},
  year      = {2026},
  publisher = {5D Library},
  edition   = {1.0.0},
  note      = {DOI pending}
}

Other chapter answers in this book