Customer Projection Visualization

Formula and Explanation

Formula:
For month m < contract:
T(m) = m × (salespeople × newCustomersPerWeekday × 20)

For month m ≥ contract:
T(m) = (salespeople × newCustomersPerWeekday × 20 × contract) + R(m – contract),

where R(0) = 0 and for i = 1,2,..., (m – contract):
R(i) = retention × (R(i – 1) + (salespeople × newCustomersPerWeekday × 20)).

Explanation:
Monthly sign-ups are calculated using the number of salespeople and the new customers each secures per weekday (assuming 20 weekdays per month). For the duration of the contract period, customers are "locked in." Once a customer’s contract expires, they enter a retention phase where a fixed percentage is kept each month.

Enter parameters and click "Calculate Projection" to see the limit and threshold info.