Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesRetail & E-commercePricing & MerchandisingSupplier Price Comparison

SpreadsheetPricing & MerchandisingFree

Supplier Price Comparison

Quotes from several suppliers per product with landed unit cost, minimum order cost, lead time and samples, a ranking per product, and the yearly saving from switching to the best quote.

Shown with sample data

Colour

Supplier Price Comparison

Quotes from several suppliers per product with landed unit cost, minimum order cost, lead time and samples, a ranking per product, and the yearly saving from switching to the best quote.

Products
4
Yearly saving available
$600
Switching to best approved quotes
Above target cost
1
Quotes collected
9
Yearly saving by product
  • Organic cotton tee$360
  • Soy candle 200 g$144
  • Ceramic mug$96
Landed cost by supplier
  • PrintBlank Co$8.70
  • EcoWear Supply$8.50
  • GreenThread$8.40
  • Glow Wholesale$6.20
  • WickHouse$6.10
  • ToteMakers$5
  • BagCo$4.90
  • ClayWorks$4.80

How to use it

  1. 1List each product on the Products sheet with your target landed cost, monthly volume and current supplier.
  2. 2Add every quote on the Quotes sheet with price, shipping per unit, minimum order, lead time and quote date.
  3. 3Mark Sample approved once you have checked quality.
  4. 4Review Best supplier and Yearly saving before reordering.

In this workbook

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

About this template

Source smarter. For each product, record quotes from several suppliers with unit price, shipping per unit, minimum order, lead time and whether you have approved a sample. The sheet works out the landed unit cost and the cash needed for a minimum order, ranks every supplier for each product, and shows how much more each costs than the cheapest. The Products sheet compares the best approved quote with your target cost and your current supplier, and works out the yearly saving from switching.

Who it’s for

  • Shops and online sellers sourcing stock
  • Annual supplier reviews
  • Checking margins before launching a product

What’s included

  • Products sheet: Each product with its best approved quote and the saving from switching.
  • Quotes sheet: Every supplier quote with landed cost and rank.

How to use it

  1. 1List each product on the Products sheet with your target landed cost, monthly volume and current supplier.
  2. 2Add every quote on the Quotes sheet with price, shipping per unit, minimum order, lead time and quote date.
  3. 3Mark Sample approved once you have checked quality.
  4. 4Review Best supplier and Yearly saving before reordering.

Tips

  • Compare landed cost, not unit price: shipping and duties can flip the cheapest option.
  • A low minimum order and short lead time are worth paying a little more for on new products.

Questions

Which quotes can be the best supplier?

Only quotes with an approved sample, ranked by landed unit cost.

How is the yearly saving worked out?

(Current supplier's landed cost − best landed cost) × monthly volume × 12.

Related searchessupplier price comparisonwholesale pricessourcingpurchasinglanded costsupplier quotes

Details

Format
Spreadsheet
Category
Pricing & Merchandising
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetPricing & MerchandisingFree

Supplier Price Comparison

Quotes from several suppliers per product with landed unit cost, minimum order cost, lead time and samples, a ranking per product, and the yearly saving from switching to the best quote.

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
2
Setup
10 min
Level
Beginner
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