Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesSales & CRMPipeline & OpportunityPrice List

SpreadsheetPipeline & OpportunityFree

Price List

Set list prices from cost and target margin, add volume-discount tiers and check every tier still clears your margin floor.

Shown with sample data

Colour

Price List

Set list prices from cost and target margin, add volume-discount tiers and check every tier still clears your margin floor.

Products
11
Average target margin
44%
Average margin at tier 4
31%
Your deepest discount
Products below floor
2
Quote total
$2,315
Quote margin
39%
Lines at a discount tier
4
Margin at deepest tier by product
  • English breakfast, 100 bags45.1%
  • Organic sencha, 250 g loose45.1%
  • Vanilla syrup, 750 ml39%
  • Salted caramel syrup, 750 ml39%
  • House espresso blend, 1 kg32.9%
  • Colombia Huila single origin, 1 kg32.9%
  • Decaf Swiss Water process, 1 kg29.2%
  • Stainless milk jug, 600 ml26.8%

How to use it

  1. 1Set your tier thresholds, tier discounts and minimum acceptable margin on the Settings sheet.
  2. 2List each product with its SKU, landed unit cost and target margin on the Price list sheet.
  3. 3Fix any product marked Below floor by raising its target margin or reducing the tier discount.
  4. 4Price an order on the Quote sheet by typing the SKU and quantity; the tier is applied automatically.
  5. 5Export the Price list sheet (hide the cost columns) to send to customers.

In this workbook

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

About this template

A price list that is worked out, not guessed. Enter each product’s unit cost and the margin you want; the sheet sets the list price, calculates markup and three volume-discount tiers from the thresholds on the Settings sheet, and flags any product whose deepest discount falls below your minimum margin. A Quote sheet then prices any order at the right tier automatically.

Who it’s for

  • Wholesale and trade price lists
  • Reviewing prices after supplier cost increases
  • Giving sales reps discount tiers they cannot get wrong
  • Pricing quotes for volume orders

What’s included

  • Price list sheet: Every product with cost, list price and tier prices.
  • Quote sheet: Price an order at the right volume tier.
  • Settings sheet: Volume tiers and your margin floor.

How to use it

  1. 1Set your tier thresholds, tier discounts and minimum acceptable margin on the Settings sheet.
  2. 2List each product with its SKU, landed unit cost and target margin on the Price list sheet.
  3. 3Fix any product marked Below floor by raising its target margin or reducing the tier discount.
  4. 4Price an order on the Quote sheet by typing the SKU and quantity; the tier is applied automatically.
  5. 5Export the Price list sheet (hide the cost columns) to send to customers.

Tips

  • Margin and markup are different: a 40% margin is a 67% markup. Set prices from margin so discounts never surprise you.
  • Use landed cost (product, freight, duty and packaging), not just the supplier’s invoice price.
  • Review costs every quarter; a 5% cost rise on a 30% margin product cuts its profit by more than 11%.
  • Hide or delete the cost, margin and floor columns before sharing the list with customers.

Questions

How do I calculate a selling price from cost and margin?

Price = cost ÷ (1 − margin). A product costing $12 with a 40% target margin sells for $12 ÷ 0.60 = $20. The sheet does this for every row.

What is the difference between margin and markup?

Margin is profit as a share of the selling price; markup is profit as a share of cost. A $20 price on a $12 cost is a 40% margin and a 67% markup.

How should I set volume discount tiers?

Base the thresholds on real order sizes (look at your order history) and make each tier worth reaching, typically 3–8% per step. Check that the deepest tier still covers your costs and minimum margin, which the Floor check column does for you.

Should I show my costs on a price list?

No. Keep cost and margin columns for internal use only. Export a customer version showing SKU, product and the price per tier.

Related searchesprice list templatewholesale price listvolume discount pricingtiered pricing calculatorproduct price listmargin pricing sheet

Details

Format
Spreadsheet
Category
Pipeline & Opportunity
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetPipeline & OpportunityFree

Price List

Set list prices from cost and target margin, add volume-discount tiers and check every tier still clears your margin floor.

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
Pipeline & Opportunity
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More pipeline & opportunity templates

View all
Sales Pipeline CRM3 sheets

Open pipeline

$270,400

Weighted forecast

$89,550

Won

$18,000

Pipeline value by stage
$101k
$68k
$54k
$47k
$18k
LeadQualifiedProposalNegotiationWon
SpreadsheetPipeline & Opportunity

Sales Pipeline CRM

Deals by stage with weighted forecast, deal age, overdue follow-ups, win rate and a scorecard for every rep.

10 min setupPreview
Deal Qualification Scorecard (MEDDIC)2 sheets

Open pipeline

$384,000

Qualified pipeline

$172,000

Strong deals

3

Qualified value by stage
$88k
$84k
ProposalNegotiation
SpreadsheetPipeline & Opportunity

Deal Qualification Scorecard (MEDDIC)

Score every open deal on the six MEDDIC questions and see which are real and which need work.

10 min setupPreview

Annual Sales Plan: FY2027

Company: Company name Owner: Name, VP Sales Version: 1.0 Approved by: CEO / CFO Date: Date

1. Executive summary

In FY2027 we will grow bookings from $8.4M to $11.0M (+31%). Growth comes from three places: expanding the mid-market segment where win rates are highest, a new partner channel, and a dedicated expansion motion for

Keep this to one paragraph: the number, where it comes from and what it needs.

2. Last year in review

MetricFY2026 targetFY2026 actual
Bookings$8.0M$8.4M
New customers140128

What worked: Discovery training lifted win rates; mid-market outbound pod booked 40% of new pipeline. What did not: SMB inbound volume fell 18%; partner deals were ad hoc with no registration process.

DocumentPipeline & Opportunity

Annual Sales Plan

Turn next year’s revenue number into targets by segment, quarterly phasing, coverage, initiatives and a budget.

60 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