Retail Planby RetailNorthstar
// Templates

Size curve template

A ready-to-use Excel size curve template for apparel buying — plan size-level buys by style, color, channel, or region, with size-level units that calculate from your total and percentages automatically.

// What is inside
  • A size % row across XS–XXL that you set per style
  • A size-units row that auto-calculates as Total × Size %
  • Total units field that drives the whole size break
  • Per-style, per-color rows for channel or region differences
  • Sample data showing a complete worked size curve
// Fields
StyleColorTotal UnitsXSSMLXLXXLSize %Size-level UnitsChannel/Region Notes
Get the Size Curve Template

Free. Enter your details and the download starts immediately.

We’ll only use this to send relevant planning content. No spam.

// Who this is for

Buyers and planners who need to turn a total buy into the right units per size. It fits apparel teams managing size breaks across stores, ecommerce, and regions that each sell a different shape.

// How to use it
  1. Enter the style, color, and total units for the buy.
  2. Set the size percentages across XS–XXL so they sum to 100%.
  3. Read the size-level units row, which calculates each size as Total × its percentage.
  4. Add a row per channel or region where the curve differs, and note it in the channel/region column.
// When this template starts to break

This template is useful when the workflow is owned by one person or one small team. It starts to break when multiple teams need the same version of the plan, when inputs change frequently, or when decisions need to flow into assortment, buying, purchase orders, production, and allocation.

// From spreadsheet to connected plan

Use the spreadsheet to get started. When the process becomes too manual, RetailNorthstar connects the plan, assortment, buy, PO, and production workflow.

Download the template →See RetailNorthstar →
// What RetailNorthstar automates

RetailNorthstar helps automate size-level buying and purchase order generation from connected assortment and demand plans. From line plan to production, RetailNorthstar connects merchandising, design, buying, sourcing, and operations in one workflow.

Related: size curve calculator and how to calculate size curves.

// FAQ

Frequently asked questions

What is a size curve?
A size curve is the percentage breakdown of how a style sells or should be bought across sizes — for example XS 5%, S 20%, M 30%, L 25%, XL 15%, XXL 5%. Applying the curve to a total buy gives the units to order in each size.
How does this size curve template work?
Enter the total units for a style/color and the size percentages across XS–XXL. The template shows a size % row and a size-units row, where each size-level unit count is calculated as Total × that size percentage. Sample data is included to show the structure.
Can I use different size curves by channel or region?
Yes. Add a row per style and color and use the channel/region notes column to capture which split applies. Stores, ecommerce, and different regions often need different curves, so keeping them on separate rows keeps each buy accurate.
Why do size percentages need to total 100%?
The size-level units are derived from the total units multiplied by each size percentage, so the percentages should sum to 100% for the size buy to match the planned total. If they do not, the size-level units will not reconcile to the total.

A spreadsheet size curve works for a handful of styles. RetailNorthstar derives size-level buys from connected assortment and demand plans and carries them straight into purchase orders.

Book a Demo →See it on RetailNorthstar →