Add-ons like flocking, tree netting or stands can lift a weekend's revenue noticeably. Multiplying trees sold by the share of customers who buy the add-on and its price shows the extra dollars, which you add to base tree sales.
120 trees with 25% buying a $12 add-on adds $360.00 on top of $7,800.00 in tree sales.
The example
Three worked examples. Change any yellow input in the practice workbook and the results recalculate.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Case | Trees | Price | Take rate | Add-on | Add-on revenue | Total |
| 2 | Weekend | 120 | $65 | 25.0% | $12 | $360.00 | $8,160.00 |
| 3 | Opening | 300 | $75 | 30.0% | $15 | $1,350.00 | $23,850.00 |
| 4 | Late season | 80 | $45 | 10.0% | $10 | $80.00 | $3,680.00 |
The formula
Here is the formula, built directly from the inputs:
How it works
Here is the logic, one piece at a time:
B2*D2is customers taking the add-on.*E2prices them.B2*C2is base tree sales.- Add
F2for the total.
Keep every number in its own input cell so the formula never needs editing.
Try it: interactive demo
Enter the values below.
Variations
Add-on share of sales
Portion of revenue from the add-on.
Needed take rate
Take rate for $500 of add-ons.
Pitfalls & errors
Use the share of customers who actually buy, not the share you hope will.
Enter the take rate as 25% or 0.25.
Track take rate by day so you can stock the add-on.
Practice workbook
Frequently asked questions
Why model the take rate?
Can I add a second add-on?
Stop fighting formulas. Learn them in a day.
This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class