Holiday lighting quotes combine linear footage on the roofline with per-item charges such as trees and bushes. Takedown and storage is usually a percentage of the install. Separating the pieces keeps quotes consistent across crews and shows customers exactly what they are paying for.
140 ft at $4.50 plus 2 trees at $60 is a $750 install; takedown and storage at 30% is $225.
The example
Three homes. Larger homes with more trees raise both the install and the takedown fee.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Case | Feet | Rate/ft | Trees | Tree fee | Install | Takedown |
| 2 | Ranch | 140 | $4.50 | 2 | $60 | $750.00 | $225.00 |
| 3 | Two-story | 210 | $5.00 | 3 | $60 | $1,230.00 | $369.00 |
| 4 | Estate | 420 | $5.50 | 6 | $75 | $2,760.00 | $828.00 |
The formula
Add the footage charge to the per-tree charge; takedown is a share of that total:
How it works
Here is the logic, one piece at a time:
B2*C2prices the roofline footage.D2*E2prices the trees.- The takedown fee is 30% of the install, rounded to cents.
Keep the takedown percentage in its own cell so you can change it without touching the formulas.
Try it: interactive demo
Enter roofline feet, per-foot rate, trees and tree fee.
Variations
Quote with a minimum
Never quote below a $300 minimum.
Total season price
Install plus takedown.
Pitfalls & errors
Do not hard-code the takedown rate inside the formula; put it in a cell.
Measure rooflines from the ground with a laser measure; estimates from photos drift.
Show install and takedown as two lines on the quote.
Practice workbook
Frequently asked questions
Why charge takedown separately?
What about timers and extension cords?
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