A package bundles items at a discount to the a-la-carte total. Summing item prices, applying the bundle discount, and showing the savings is how you build and price tiers.
The example
Items total $900, 15% bundle off.
| A | B | |
|---|---|---|
| 1 | Item | Value |
| 2 | A-la-carte | $900 |
| 3 | Package (−15%) | → $765 |
The formula
The formula:
How it works
How it works:
- SUMPRODUCT(qty, price) totals the a-la-carte value of the included items.
- Multiply by (1 − bundle discount) for the package price.
- Client savings = a-la-carte total − package price.
- Check the package still profits: package price − total item cost > 0.
Discount the bundle, but never below cost. A package discount drives bookings and raises the average sale, but the math has to clear: subtract the included items’ cost (not retail) from the discounted package price to confirm it still profits. Anchoring the package against a higher a-la-carte total also makes the savings feel real — show both numbers on the price sheet.
Try it: interactive demo
A-la-carte total and bundle discount %.
Variations
Client savings
A-la-carte − package:
Package profit
Above item cost:
Effective discount
Saved share:
Pitfalls & errors
Profit at cost. Check the package against item cost, not retail.
SUMPRODUCT for totals. Multiply quantities by prices in one step.
Show both numbers. Anchor savings against the a-la-carte total.
Practice workbook
Frequently asked questions
How do I price a photography package in Excel?
How do I show client savings?
How do I make sure the package profits?
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