Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesRetail & E-commercePricing & MerchandisingOpen-to-Buy Plan

SpreadsheetPricing & MerchandisingFree

Open-to-Buy Plan

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

Shown with sample data

Colour

Open-to-Buy Plan

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

Planned purchases
$235,600
Already on order
$145,000
Open to buy
$90,600
Overbought lines
1
Planned sales by department
  • Womenswear$106,000
  • Menswear$64,000
  • Accessories$34,000
  • Home$29,000
Share of planned sales by department
  • Womenswear$106,00045%
  • Menswear$64,00027%
  • Accessories$34,00015%
  • Home$29,00012%

How to use it

  1. 1Plan sales by department from last year and trend.
  2. 2Set end-of-month stock from your target stock turn.
  3. 3Enter opening stock and orders already placed.
  4. 4Buy only within the open-to-buy; a negative figure means you are overbought.

In this workbook

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

About this template

Open-to-buy is the discipline that stops retailers over-buying. For each department and month enter planned sales, markdowns, the stock you want to end with, opening stock and what is already on order; the sheet calculates planned purchases and the open-to-buy still available, at retail value.

Who it’s for

  • Seasonal buying budgets
  • Keeping cash out of slow stock
  • Giving buyers a clear monthly limit

What’s included

  • Plan sheet: One row per department per month. All values at retail.
  • Summary by Department sheet: Planned sales and Planned purchases and the number of entries for each department, calculated from the Plan sheet.

How to use it

  1. 1Plan sales by department from last year and trend.
  2. 2Set end-of-month stock from your target stock turn.
  3. 3Enter opening stock and orders already placed.
  4. 4Buy only within the open-to-buy; a negative figure means you are overbought.

Questions

How is open-to-buy calculated?

Planned sales + planned markdowns + planned end-of-month stock − opening stock − stock on order. All figures at retail value.

Related searchesopen to buyotb planretail merchandise planningpurchase budget retailinventory buying plan

Details

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

Download a copy

Downloads need a free account.

SpreadsheetPricing & MerchandisingFree

Open-to-Buy Plan

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

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
Advanced
Price
Free

Your copy is private to you.

More pricing & merchandising templates

View all
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
Promotion & Markdown Planner
Task
SepOctNov
Winter beanie BOGO
Autumn hoodie week
Candle bundle
Tote flash sale
Mug gift with purchase
Black Friday tees
SpreadsheetPricing & Merchandising

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.

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