Tatsiana BandziukRetail & Fashion Analytics
Book a Consultation

Free templates

Free Open-to-Buy Excel Template and Retail KPI Dashboard Checklist

Two working files from real retail projects, sent by email. Placeholder content until the final versions are uploaded.

MonthBuy planSoldSell-throughOTB left
M142031174%109
M238035894%22
M345540288%53

preview · open-to-buy sheet

Open-to-Buy Excel Template for Retail Planning

Units, cost, margin and phasing by month and market, with the three checks that stop the model drifting mid-season.

  • Sell-through defined and documented
  • Stock cover per category and market
  • Full-price share and markdown depth
  • Returns rate in the same model
  • One owner per report page

preview · dashboard checklist

Retail KPI Dashboard Checklist for Power BI

Twelve checks before a retail dashboard goes to the commercial team — definitions, owners and refresh.

What Is Inside the Retail Analytics Templates

  • Open-to-buy sheet with monthly phasing and margin calculation
  • Size and colour curve tab fed from cleaned sales history
  • Definition sheet: how each retail KPI is calculated and by whom
  • Dashboard checklist with the twelve pre-launch checks
  • A one-page note on handing the model to a planning team

Get Both Retail Analytics Templates by Email

One email with both files. No newsletter, no sharing of your address.

Power BI and Excel courses for retail analysts — coming soon. No newsletter, no sharing of your address.

Related Retail Analytics Articles

Power BI

How to Calculate Sell-Through Rate in Power BI

The DAX pattern, the two denominators retailers confuse, and how to show it by week.

Assortment

How to Build a Size Curve from Last Season’s Sales Data

Cleaning returns and stock-outs out of the data before you trust the size split.

Product data

Product Attribute Standards That Survive Three Markets

A practical attribute dictionary for PLM, with rules for colour, season and composition.