31 October, 2026 0 comments Leave a comment
Last Updated: October 31, 2026
Quick Summary
To manage spirit wear inventory without leftovers, track every size and color variant in a shared spreadsheet and order to a demand forecast based on last year's sell-through rather than a vendor minimum. Run preorders of 10 to 14 days to confirm demand, then order exactly what came in plus a small buffer.
- Track each size and color combination as its own spreadsheet row, not just the item name.
- Set a reorder point from vendor lead time plus a buffer for game weeks.
- Divide your adjusted base demand by a target sell-through rate, then round down.
- Order exactly what a preorder brings in plus a 5-10% buffer for late joiners.
- Plan for a 5-10% exchange rate and hold a reserve of adult medium and large.
Table of Contents
- Why School Spirit Wear Inventory Goes Wrong
- Building a School Merchandise Inventory Spreadsheet That Works
- Forecasting Demand: How Much Spirit Wear Should a School Order?
- Running a Spirit Wear Preorder Instead of Guessing
- Using a Spirit Wear Size Chart to Plan Size Curves
- A Spirit Wear Order Form Template That Prevents Mistakes
- Receiving, Storing, and Counting Stock Through the School Year
- Cutting Leftover Stock Before It Becomes a Markdown
- Frequently Asked Questions
Why School Spirit Wear Inventory Goes Wrong
Most spirit wear programs don't fail at the design stage. They fail at the storage closet.
A booster club orders 400 shirts in a single size run, sells 260, and spends the rest of the year storing boxes nobody wants. The problem isn't enthusiasm.
This guide from The Ultimate Bow walks through the full workflow: forecasting, preorders, size curves, tracking, and clearing leftovers before they become a markdown. If you want the bigger picture on ordering and design decisions, our guide to custom team spirit gear for schools connects the dots.
Here's what most guides get wrong: they treat spirit wear inventory as a buying problem. It's a tracking problem first.
Building a School Merchandise Inventory Spreadsheet That Works
A school merchandise inventory spreadsheet is a shared tracking file that records every product variant, its quantity on hand, and its reorder status. It replaces the notebook-and-guesswork approach that leaves volunteers hunting through boxes in October.
You don't need software. A shared spreadsheet works fine, as long as it tracks the right things.
Columns to Track at the Variant Level
Track each size and color combination as its own row. "Hoodie" is not a row. "Hoodie, navy, adult medium" is a row.
- Item name and design name
- Color
- Size
- Vendor and order date
- Quantity ordered
- Quantity received
- Quantity sold
- Stock on hand
- Unit cost
- Reorder point
- Notes
Update the sold column after every sale event. A spreadsheet that's two weeks stale is worse than no spreadsheet.
Reorder Points and Stockout Alerts
A reorder point is the stock level that triggers a new order. Set it based on how long your vendor takes to deliver plus a buffer for game weeks.
If a restock takes two weeks and you sell roughly 15 hoodies a week during season, a reorder point around 35 units keeps you covered. Set the number once, review it after each season, and stop reordering from memory.
Add a simple alert column. A formula that flags any row where stock on hand drops below the reorder point turns a passive spreadsheet into a working tool.
Forecasting Demand: How Much Spirit Wear Should a School Order?
Start with last year's sell-through, not a gut feeling. Sell-through rate is the share of units you ordered that actually sold. For example, if you ordered 300 shirts and sold 240, your sell-through is 80%.
But sell-through alone won't tell you how many units to order this year. You need a school-specific demand forecast that blends four inputs: enrollment, past sales, the event calendar, and preorder data. Here's a practical method organizers can run in a spreadsheet.
Step 1: Build a Base Demand Number
Pull last season's units sold per item. If you sold 240 shirts, that's your base. Adjust for changes in enrollment by applying the same percentage change to the base. Adjust again for event count, if you added a fall festival and a homecoming week, add a buffer for each event based on last year's per-event sales.
Step 2: Apply a Target Sell-Through Rate
Divide your adjusted base by your target sell-through rate. If you want to sell through 85% of what you order (a common target for spirit wear), divide by 0.85. Round down, not up. This gives you a starting order quantity that leaves room for late demand without overbuying.
Step 3: Layer in Preorder Data
If you run a preorder, use confirmed demand in place of a forecast. Order exactly what came in, plus a small buffer (5-10%) for late joiners and exchanges. Preorder data is the most reliable input you'll ever have, use it whenever the item allows.
Worked Example: 200-Unit Order
Suppose you sold 180 hoodies last year, enrollment is flat, and you're adding one new event. You estimate the new event adds 15 units. Adjusted base = 195. Target sell-through = 85%. Order quantity = 195 ÷ 0.85 ≈ 229, rounded down to 225. If a preorder brings in 200 confirmed orders, order 210-220 instead.
Small squads should order conservatively. If you're planning for a squad of 15, a smaller order often makes more sense than a bulk buy. For budget-friendly package options that show realistic scope, see our best budget spirit gear packages for small squads.
Watch out: ordering to hit a vendor minimum is the fastest way to create leftover stock. Order what you can sell, then add a small buffer for late joiners.
Running a Spirit Wear Preorder Instead of Guessing
A spirit wear preorder collects orders and payment before you place the bulk order. It turns demand forecasting into demand confirmation.
The workflow is simple:
- Open a preorder window of 10 to 14 days
- Publish the size chart and design mockups
- Collect orders through a form or online store
- Close the window and order exactly what came in, plus a small buffer
- Deliver 2 to 3 weeks after close
Preorders work best for new designs, event-specific items, and anything with a high unit cost. They work poorly for items families expect to buy on the spot at a game.
Custom bows can be a strong preorder item because they build buy-in before the season starts. Read why custom cheer bows build team unity for the case for making them part of your preorder.
Using a Spirit Wear Size Chart to Plan Size Curves
A spirit wear size chart maps expected demand across sizes so you order the right mix, not just the right total. Ordering 200 mediums and 20 smalls is how you end up with a closet full of mediums.
Build Your Curve from Actual Order Data
Start with last season's order history, not a generic template. If you don't have it yet, use the spread below and refine it next season. The key is to track youth and adult sizes separately, schools often blend them and end up short on youth smalls and long on adult 3XL.
| Size | Share of Orders | 200-Unit Order |
|---|---|---|
| Youth small | 8% | 16 |
| Youth medium | 10% | 20 |
| Youth large | 10% | 20 |
| Adult small | 12% | 24 |
| Adult medium | 20% | 40 |
| Adult large | 18% | 36 |
| Adult XL | 12% | 24 |
| Adult 2XL | 7% | 14 |
| Adult 3XL | 3% | 6 |
Account for Exchanges and Stranded Inventory
Even a good size curve produces some exchanges. Plan for a 5-10% exchange rate on apparel, and hold a small reserve of the most common sizes (adult medium and large) to cover swaps without reordering. Less common variants, youth small, adult 3XL, are where inventory gets stranded. Order these conservatively and consider made-to-order or preorder-only for extended sizes.
Inclusive Sizing Without Overstock
Include extended sizes. Families notice when 3XL isn't offered, and inclusive sizing builds goodwill that carries into next season's sales. But don't stock extended sizes deeply, offer them through preorder or a short window, then order to confirmed demand. This keeps the size chart inclusive without creating dead stock.
A Spirit Wear Order Form Template That Prevents Mistakes
Most order errors come from the form, not the fulfillment. Use this template for every order cycle.
Spirit Wear Order Form
- Student or athlete name: __________
- Team or grade: __________
- Item and design: __________
- Color: __________
- Size (circle one): YS / YM / YL / AS / AM / AL / AXL / 2XL / 3XL
- Personalization (name or number): __________
- Quantity: __________
- Unit price: __________
- Total due: __________
- Payment method: cash / check / online
- Order window closes: __________
- Pickup date and location: __________
- Volunteer initials: __________
Three rules make this form work. Require a size circle, not a written size. Record payment at the point of order. And keep one master copy that matches the spreadsheet rows exactly.
Receiving, Storing, and Counting Stock Through the School Year
Count every delivery against the packing slip before you put anything away. Short shipments caught on day one get fixed. Short shipments caught in November usually don't.
Store by item and size, labeled clearly. Keep the best-sellers near the door and the slow movers on the back shelf where you'll see them.
Run a physical count once a month during season. Compare it to the spreadsheet, note the variance, and correct it. Small mismatches are normal.
Cutting Leftover Stock Before It Becomes a Markdown
Leftover stock loses value every week it sits. Move it early, while the season still has momentum.
- Bundle slow sizes with best-sellers
- Offer a team package discount on remaining sets
- Run a flash sale at a home game
- Donate remaining basics to a school program and log the goodwill
- Carry forward only items you know will sell next year
Record what didn't sell and why. Before you reorder anything next season, check our guidance on what fabric works best for custom team uniforms so your reorder decisions start from the right material.
Watch out: discounting too late. A markdown in week two of the season recovers more than the same markdown in June.
Spirit wear inventory gets messy when nobody owns the spreadsheet.
At The Ultimate Bow, we help squads skip the guesswork on accessories entirely. Our Custom Designs studio lets you request custom bow designs for your team.
Get started with The Ultimate Bow and build a spirit wear lineup your team actually wears.
Frequently Asked Questions
How do schools keep track of spirit wear inventory?
Most schools track spirit wear inventory in a shared spreadsheet organized by product variant, meaning each style, color, and size gets its own row. Record stock on hand, units sold, and a reorder point for each row, then update it after every sale and delivery. Counting physical stock monthly and reconciling it against the sheet catches shrinkage and mis-scans early. Keep the sheet simple enough that a new volunteer can update it quickly.
Should a school sell spirit wear through preorders or keep items in stock?
Preorders work best for new designs, seasonal drops, and anything with a school logo, because you collect orders and sizes before buying and avoid leftover stock. Keep a small in-stock core of best-selling t-shirts and hoodies for walk-up sales at games and the school store. Many programs run both: a spirit wear preorder window of two to three weeks for each new design, plus a standing stock of proven items. Track sell-through rate on the in-stock items so you know which ones earn their shelf space.
How can a school avoid leftover spirit wear?
Order to demand instead of ordering to a hunch. Use last year's sales history by size and color, run a preorder so you buy only what families committed to, and cap the product lineup at a few strong designs rather than a wide assortment. After each sale window, review sell-through rate by variant and mark down slow sizes early rather than at the end of the year. Contingency stock should be limited to the sizes your spirit wear size chart shows as most common, so extras actually sell.
When should a school reorder popular spirit wear sizes?
Set a reorder point for each size variant, typically triggered when stock on hand drops to the level you expect to sell during the supplier's lead time plus a small buffer. For fast movers like adult medium and large t-shirts, check inventory levels weekly during peak season. For accessories such as cheer bows, reorder when the remaining count covers roughly one home game. Review your reorder points after each season using sales history, and adjust upward for sizes that stocked out.
Comments