Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesRetail & E-commercePricing & MerchandisingProduct Bundle Pricing Calculator

SpreadsheetPricing & MerchandisingFree

Product Bundle Pricing Calculator

Build bundles from your products, set a bundle price and see the customer saving, bundle margin and how it compares with selling items alone.

Shown with sample data

Colour

Product Bundle Pricing Calculator

Build bundles from your products, set a bundle price and see the customer saving, bundle margin and how it compares with selling items alone.

Bundles
6
Average discount
15%
Average bundle margin
43%
Margin given up vs standalone
8.6%
Bundles to rework
1
Average product margin
53%
Bundle margin by bundle
  • Espresso starter kit47.3%
  • Coffee and tamper duo45.7%
  • Barista pro set45.2%
  • Syrup trio44.9%
  • Café restock pack43.5%
  • Tea lover’s gift box28.6%

How to use it

  1. 1List every product on the Products sheet with landed unit cost and standalone price.
  2. 2Set your minimum bundle margin and the smallest discount customers notice on the Settings sheet.
  3. 3On the Bundle items sheet, add each SKU and quantity that goes in each bundle.
  4. 4Set a bundle price on the Bundles sheet and adjust until the verdict reads Good.
  5. 5Compare profit per bundle with the profit from a typical single-item order.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Bundles raise average order value, but an over-generous discount gives away the margin they were meant to create. List your products with cost and standalone price, build each bundle from SKUs and quantities, and set a bundle price; the calculator shows the standalone value, the customer’s saving in dollars and percent, the bundle’s margin against the same items sold separately, profit per bundle and a verdict that flags bundles whose discount is too deep or too small to notice.

Who it’s for

  • Gift sets and holiday bundles
  • Starter kits and “complete the set” offers
  • Clearing slow-moving stock alongside best-sellers
  • Testing bundle prices before a promotion

What’s included

  • Bundles sheet: Each bundle’s price, saving and margin.
  • Bundle items sheet: The SKUs and quantities in each bundle.
  • Products sheet: Cost and standalone price of every product.
  • Settings sheet: Your bundle rules.

How to use it

  1. 1List every product on the Products sheet with landed unit cost and standalone price.
  2. 2Set your minimum bundle margin and the smallest discount customers notice on the Settings sheet.
  3. 3On the Bundle items sheet, add each SKU and quantity that goes in each bundle.
  4. 4Set a bundle price on the Bundles sheet and adjust until the verdict reads Good.
  5. 5Compare profit per bundle with the profit from a typical single-item order.

Tips

  • A bundle discount of 10–20% is common; below about 5% customers rarely notice, above 25% you usually give away too much.
  • Pair a best-seller with a slower item to move stock, but only if the slow item is something customers genuinely want with it.
  • Show the saving in dollars on the product page (“Save $14”) as well as the percentage.
  • Remember extra packaging or kitting costs; add them as a product line if they apply.

Questions

How do I price a product bundle?

Add up the standalone prices of the items, decide on a discount that is noticeable but protects margin, and check the bundle margin against your minimum. Bundle margin = (bundle price − total cost) ÷ bundle price.

Do bundles reduce profit?

Per item, usually yes, because of the discount. They can increase total profit if they raise average order value, move slow stock or win customers who would not otherwise buy. Compare profit per bundle with your typical order profit.

What is a good bundle discount?

Often 10–20% off the combined standalone price. Test in your own store: the right discount is the smallest one that lifts conversion.

Related searchesproduct bundle pricingbundle pricing calculatorbundle discount calculatorkit pricing spreadsheetgift set pricingbundle margin calculator

Details

Format
Spreadsheet
Category
Pricing & Merchandising
Sheets
4
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetPricing & MerchandisingFree

Product Bundle Pricing Calculator

Build bundles from your products, set a bundle price and see the customer saving, bundle margin and how it compares with selling items alone.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Pricing & Merchandising
Sheets
4
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More pricing & merchandising templates

View all
Open-to-Buy Plan2 sheets

Planned purchases

$235,600

Already on order

$145,000

Open to buy

$90,600

ABCD
1MonthDepartmentPlanned salesPlanned markdowns
2DecWomenswear$64,000$6,400
3DecMenswear$38,000$3,000
4DecAccessories$22,000$1,500
5DecHome$18,000$1,200
Plan
SpreadsheetPricing & Merchandising

Open-to-Buy Plan

Plan purchases by department and month from sales, markdowns and target stock, and see what is left to spend.

10 min setupPreview
Holiday Season Retail Planner3 sheets

Season target

$84,500

Planned growth on last year

17%

Sales so far

$5,120

ABCD
1EventDatePromotion planSales target
2Singles’ DayNov 1115% off sitewide, email + social$4,500
3Black FridayNov 2725% off best-sellers; doorbuster bundle$22,000
4Small Business SaturdayNov 28In-store event, gift with purchase$6,500
5Cyber MondayNov 30Free shipping + 20% off online$15,000
Key dates
SpreadsheetPricing & Merchandising

Holiday Season Retail Planner

Key peak-season dates with sales targets against last year, live results, and stock cover checked against the weeks left in the season.

10 min setupPreview
Retail Pricing Calculator2 sheets

Average actual margin

61%

Below target

1

ABCD
1ProductChannelUnit costTarget margin
2Organic cotton teeWebsite$8.4060%
3Organic cotton teeEtsy$8.4060%
4Soy candle: cedarWebsite$6.1065%
5Soy candle: cedarAmazon$6.1065%
Pricing
SpreadsheetPricing & Merchandising

Retail Pricing Calculator

Set prices from cost with target margin, marketplace fees and psychological rounding.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ