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_A | q=0.00 | q=0.02 | q=0.05 | q=0.10 | q needed |
| 0.05 | 468.6 | 540.1 | 647.2 | 825.8 | 0.0632 |
| 0.30 | 610.3 | 681.8 | 788.9 | 967.5 | 0.0235 |
| 0.50 | 805.1 | 876.5 | 983.6 | 1162.2 | 0.0000 |
| 0.70 | 1182.3 | 1253.8 | 1360.9 | 1539.5 | 0.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
- Chapter 1 · No-Shows, Deposits and the Price of an Empty Chair
- Chapter 2 · Overbooking: Airline Arithmetic in the Treatment Room
- Chapter 3 · The Float and the Breakage of Prepaid Cards
- Chapter 4 · Is the "Fourth-Session Cliff" a Law or a Parameter?
- Chapter 6 · Intro Sessions and Annual Plans: The Arithmetic of a Two-Stage Funnel
- Chapter 7 · The Guanzi's Tiring Labour, the Reserve of the Jiaozi and Airline Revenue Management
- Chapter 8 · Practice: One Studio's Week and One Test Protocol