Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesRetail & E-commercePricing & MerchandisingPromotion & Markdown Planner

SpreadsheetPricing & MerchandisingFree

Promotion & Markdown Planner

Plan promotions with discount, baseline and marketing cost, then compare actual sales and profit with business as usual to see which deals to repeat, plus the units needed to break even.

Shown with sample data

Colour

Promotion & Markdown Planner

Plan promotions with discount, baseline and marketing cost, then compare actual sales and profit with business as usual to see which deals to repeat, plus the units needed to break even.

Promotions run
5
Promo revenue
$4,388
Profit vs baseline
-$454.20
Gained or lost against doing nothing
Worth repeating
2
Profit vs baseline by promotion
  • Autumn hoodie week$152.70
  • Candle bundle$27
  • Mug gift with purchase-$116
  • Tote flash sale-$183.30
  • Winter beanie BOGO-$334.60
Profit vs baseline by type
  • % off$152.70
  • Bundle$27
  • Gift with purchase-$116
  • Flash sale-$183.30
  • BOGO-$334.60

How to use it

  1. 1Add each planned promotion with type, dates, product, prices, discount, baseline units and marketing cost.
  2. 2Before launch, check Break-even units: can you realistically sell that many?
  3. 3After it ends, type actual units sold.
  4. 4Repeat the promotions marked Repeat and rethink the rest.

In this workbook

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

About this template

Run promotions that make money, not just sales. For each promotion, record the type, dates, product, regular price, unit cost, discount, the units you would normally sell in that period and any marketing spend. Before it runs, the planner tells you how many units you need to sell to make the same profit as doing nothing. Afterwards, add actual units to see revenue, profit, uplift and the real profit gained or lost, with a verdict on whether to repeat it. A summary compares promotion types.

Who it’s for

  • Planning a promotional calendar
  • Judging markdowns and seasonal sales
  • Deciding which deals to repeat

What’s included

  • Promotions sheet: Every promotion with its break-even and results.
  • By type sheet: Which kinds of promotion pay off.

How to use it

  1. 1Add each planned promotion with type, dates, product, prices, discount, baseline units and marketing cost.
  2. 2Before launch, check Break-even units: can you realistically sell that many?
  3. 3After it ends, type actual units sold.
  4. 4Repeat the promotions marked Repeat and rethink the rest.

Tips

  • A 25% discount on a 50% margin product needs double the units just to stand still.
  • Use baseline units from the same weeks last year, not your best week.

Questions

What is break-even units?

The units you must sell at the promotional price, after marketing cost, to earn the same profit as the baseline at full price.

How is the verdict decided?

Repeat if profit beat the baseline, Rethink if it fell short, and Planned until actual units are entered.

Related searchespromotion plannermarkdownsale planningdiscount calendarpromotion roibreak-even

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

Promotion & Markdown Planner

Plan promotions with discount, baseline and marketing cost, then compare actual sales and profit with business as usual to see which deals to repeat, plus the units needed to break even.

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