Use Race Sales Data to Forecast Fundraiser Merch — A Practical Template for Clubs
A practical template for using race sales and registration data to forecast merch sizes, styles, and margins with less leftover inventory.
Use Race Sales Data to Forecast Fundraiser Merch — A Practical Template for Clubs
Clubs and race directors often treat merchandise ordering like a guessing game: estimate a few sizes, print a stack of shirts, hope the table sells out, and then spend weeks dealing with leftovers. That approach is expensive, especially for charity races and expo booths where profit margin depends on tight control of inventory, style mix, and size distribution. The better method is surprisingly simple: use the data you already have from registrations, race sales, and on-site purchasing to build a lightweight inventory model that predicts what runners will actually buy. If you need a broader event-planning context, our guide to capacity decisions shows how small datasets can drive big operational wins.
In marathon communities, merch is not just revenue; it is identity. A club hoodie, finisher tee, or charity cap tells a story, and that story becomes stronger when the item is available in the right style and the right size at the right time. This guide gives you a practical template for merchandise forecasting that works whether you’re managing a local club fundraiser, a marathon expo table, or a destination race booth. For teams that want to think in terms of dashboards and operating rhythm, the principles here align closely with the approach in real-time retail query platforms and turning audience data into product intelligence.
1) Why Race Merch Forecasting Matters More Than Most Clubs Think
Merch Is a Profit Engine, Not a Side Project
At many events, merchandise looks like a branding expense until someone runs the numbers. A few dozen unsold premium hoodies can wipe out the gains from a solid race-day booth, while a sold-out popular size can mean lost profit and frustrated runners who were ready to buy. That is why merchandise forecasting should be treated like a mini revenue model, not a locker-room afterthought. The same discipline that helps teams manage seasonal demand in subscription budgeting or timing major purchases like a CFO applies directly to club fundraising.
The Hidden Cost of Leftover Inventory
Unsold merch ties up cash, storage space, and attention. If a club buys 120 shirts in the wrong size mix, the leftover units usually get discounted, donated, or shoved into a closet until they become obsolete. Worse, if a race director over-orders one style because it looked good in a mockup, the team may end up paying twice: once in excess inventory and again in missed opportunities to sell the style participants actually wanted. Smart clubs think about inventory the way event operators think about contingency planning, similar to the practical mindset in last-minute event savings and booking package deals—you want flexibility, not locked-in waste.
Why Marathon Audiences Are Predictable Enough to Model
Running events have repeatable patterns. Men’s and women’s size curves tend to be relatively stable at the club level, youth and volunteer demand are easy to segment, and registration data often reveals who is local versus traveling, first-time versus repeat participant, or charity runner versus competitive entrant. That means you can forecast with simple segmentation rather than expensive software. This is where the experience-based thinking from analytics maturity models becomes useful: start with descriptive data, then move toward decision rules that tell you what to stock.
2) The Minimum Data You Need to Build a Useful Inventory Model
Registration Data: Your Primary Demand Signal
Your registration system already contains much of what you need. Collect the number of runners registered by gender, age band, club affiliation, event type, and ordering history if merch is added during signup. If you offer a size selector, that is gold because it gives you direct demand intent before race day. You do not need a complex data warehouse to begin; you only need a consistent export that you can sort into a spreadsheet. The logic is similar to the small-data methods used in small data wins and the operational discipline behind query-trend monitoring—except here you are tracking running merch, not search intent.
Historical Sales Data: The Best Predictor of What Will Move
Past race sales matter because event merch is often more repeatable than people expect. A spring 10K that sold out medium and large tees last year will likely show the same pattern this year if the participant mix is similar. Create a simple lookup table for each race or event type with units sold by item, style, and size. If your club also sells at an expo, capture booth traffic by hour so you can see whether sales spike before packet pickup closes or after the first wave of early attendees. For a useful lens on how recurring demand can be modeled from historical behavior, see product intelligence from metrics and predictive query design.
Operational Context: Not All Demand Is About Size
Some events sell out because of style, not capacity. A premium quarter-zip may outperform a basic tee even if the tee is the safer inventory bet. Location matters too: destination races, charity galas, and expo booths near the finish line often attract more impulse buying than post-race club meetings. That is why a strong forecasting template should include event type, price point, and weather conditions, not just runner counts. If your team handles multiple sites, the logistics mindset in cross-border logistics hubs and capacity planning can help you structure inventory by venue rather than by guesswork.
3) The Practical Forecasting Template: A Spreadsheet Clubs Can Actually Use
Step 1: Segment the Population
Start with runner segments that have clear merch behavior. A practical breakdown is: registered runners, club members, volunteers, spectators, and late walk-up buyers. Then split runners by whether they pre-ordered merch during registration, because pre-orders are the strongest demand signal you have. From there, create a second layer of segmentation by size group: XS, S, M, L, XL, and 2XL+, plus any youth sizes if your event serves families. This is similar to the way smarter operators separate demand buckets in creator product intelligence and the structured way teams assess churn and retention in signal dashboards.
Step 2: Apply a Simple Conversion Rate
Use your historical conversion rate to estimate how many people will buy each item. For example, if 42% of runners bought a race shirt last year and your event has 500 registrants this year, start with a baseline demand of 210 units. Then adjust for known factors: a better route, a stronger charity story, or a more attractive design may increase conversions, while bad weather or a late venue change may reduce them. Keep your assumptions visible in the sheet so the team can review them before placing the order. This is the same mindset as structuring ad inventory around volatility—you do not need a perfect forecast, just a defensible one.
Step 3: Allocate Size Distribution
Once you know how many units to buy, split them by size using your previous size distribution or a default model. A common adult shirt curve for endurance events may lean heavily toward M, L, and XL, with smaller volumes in XS, S, and 2XL+. If you have no prior data, start with a conservative curve and adjust after your first event. For example: XS 4%, S 12%, M 28%, L 30%, XL 18%, 2XL 6%, 3XL 2%. That is not universal, but it is a useful starting point because it reflects the reality that many active adult populations skew middle-to-larger in apparel fit. For a broader look at aligning product choices with audience behavior, our piece on what brands should demand from agencies using agentic tools reinforces the value of clearly defined assumptions.
4) A Merch Forecasting Table You Can Copy and Adapt
The table below is a simple inventory model for a charity marathon booth selling one tee style and one hoodie style. Use it as a template, then swap in your own numbers based on registration counts, historical sales, and margin goals.
| Item | Expected Buyers | Unit Cost | Sell Price | Gross Margin | Suggested Size Mix |
|---|---|---|---|---|---|
| Event Tee | 220 | $8.50 | $25 | 66% | XS 4%, S 12%, M 28%, L 30%, XL 18%, 2XL+ 8% |
| Premium Tee | 110 | $11.00 | $32 | 66% | XS 4%, S 10%, M 27%, L 31%, XL 18%, 2XL+ 10% |
| Zip Hoodie | 70 | $24.00 | $58 | 59% | XS 3%, S 10%, M 26%, L 30%, XL 20%, 2XL+ 11% |
| Volunteer Tee | 45 | $7.50 | $18 | 58% | S 15%, M 30%, L 30%, XL 20%, 2XL+ 5% |
| Trucker Hat | 90 | $6.00 | $22 | 73% | One size fits most |
Notice that the table does not try to predict perfection. It gives you a starting point based on likely demand and profitable items. For clubs, a spreadsheet like this is far more useful than a vague “order a bunch of mediums” conversation. The same logic applies to careful product selection in deal tracking and high-value consumer picks: concentration on items with the best probability of movement and margin.
5) How to Forecast Size Distribution Without Overcomplicating It
Use Registration Data First, Not Guesswork
If your registration form includes shirt size, that data should lead the forecast. The key is to compare ordered sizes with actual pickups and returns, because some runners select a size they think they want and then choose differently when they see the finished garment. To avoid distortions, track the difference between pre-order size and final distribution by event. Over time, you will build a club-specific pattern that is much more accurate than generic “average runner” assumptions. This is the same practical skepticism found in avoiding hype in wellness tech: trust observable behavior, not marketing folklore.
Adjust for Gender, Event Type, and Team Culture
Size curves are not one-size-fits-all. A competitive club with a lot of younger runners may have a different curve than a charity-heavy community race with families and volunteers. If your event includes youth participants or walk/run entrants, do not force those buyers into the adult distribution. Build separate lines for youth, adult women’s fit, adult unisex fit, and extended sizes if your supplier offers them. When event audiences vary by community, as discussed in human-centric nonprofit storytelling, your merch strategy should reflect that diversity instead of flattening it.
Order Buffers by Size, Not by Hope
A common mistake is to overbuy every size equally “just in case.” A better method is to add buffer stock only where the data says sell-through will be highest. For example, if mediums and larges sell fastest, add 10%-15% buffer there while keeping XS and 2XL+ closer to baseline. If you are selling at an expo and replenishment is impossible, bias your buffer toward the sizes that historically move first. That approach mirrors the caution used in authenticated provenance systems and privacy notice design: define the system, then limit the risk points.
6) Choosing Styles That Sell: Tee, Tank, Hoodie, or Hat?
Match Style to Weather, Venue, and Emotion
Merch sales are not driven by utility alone. A lightweight tee sells because it feels like a race souvenir, while a hoodie sells because it feels like a reward and a status marker. Warm-weather events often favor singlets, tees, hats, and visors, while cool-season races support long-sleeve shirts and zip hoodies. If your race is destination-based, think like a travel planner: people often buy items they can wear immediately on the trip or later to remember the experience. For inspiration on matching product choice with destination behavior, see weekend travel planning and what makes a flight deal actually good for outdoor trips.
Limit Style Overlap to Protect Cash Flow
Every extra style multiplies your risk. If you order a tee, long sleeve, hoodie, and tank in every size, you create four inventory models instead of one. A smaller club should usually choose one hero item and one accessory item rather than trying to satisfy every taste. That keeps cash available for event operations, marketing, and charitable donations. When in doubt, remember the lesson from new versus open-box buying: variety is not value if it increases the chance of regret.
Use Limited Editions to Create Scarcity Without Waste
Scarcity can help an event move merch quickly, but only if it is intentional. Limited edition colorways, finisher-only graphics, or sponsor-exclusive items can create urgency and protect margin, especially when paired with pre-order cutoffs. The key is to make the “limited” part genuine and transparent. That strategy resembles the careful storytelling behind authentic founder narratives: people respond to honesty and specificity, not manufactured hype.
7) How to Improve Forecast Accuracy Year Over Year
Track the Right KPIs
To get better at merchandise forecasting, measure the basics consistently. The most useful KPIs are sell-through rate, gross margin, leftover units by size, forecast error, and pre-order conversion rate. You should also track average order value if merch is bundled with registration or sponsorship perks. A club that reviews these metrics after every event will improve much faster than one that only checks revenue at the end of the day. If you want a broader framework for measurement, the article on descriptive to prescriptive analytics is a helpful companion.
Run Post-Event Reviews Like a Mini Retail Audit
After each fundraiser or expo, compare what you expected to sell against what actually sold. Break out results by item, size, and sales channel. Ask three questions: What sold faster than expected? What sat too long? What did buyers ask for that you did not stock? Those answers become your next order guide. This is the same continuous-improvement cycle that high-performing teams use in real-time signal dashboards and volatile ad inventory planning.
Keep a Simple Forecast Log
For each event, save a one-page record: attendance, registration mix, merch prices, sizes ordered, units sold, leftover units, and notes about weather or race-day conditions. Over time, that log becomes your most valuable forecasting asset because it lets you learn from your own audience rather than from generic industry averages. If you want to expand from one event to many, this is the same logic used in capacity decision frameworks and predictive query systems.
8) A Practical Buying Workflow for Clubs and Race Directors
Six Weeks Out: Build the First Forecast
Start with registration counts and last year’s sales, then create your baseline unit plan. At this stage, you are not ordering; you are defining the range. Assign a low, expected, and high scenario for each merch category so you can see how risk changes with demand. If your order minimums are high, compare multiple suppliers or print techniques before locking the design, much like comparing the best options in budget timing and event discount strategy.
Three Weeks Out: Lock Sizes, Then Rebalance
Once the pre-order deadline closes, finalize your size curve and remove emotional bias from the decision. If the medium and large buckets are clearly leading, rebalance inventory away from fringe sizes unless your audience data strongly suggests otherwise. This is also the time to review style mix and decide whether a second item should be added or whether you should stay focused on your hero product. At this stage, good merch forecasting is really a form of disciplined procurement.
Event Week: Prepare for On-Site Replenishment Rules
For expo sales and charity booths, create a one-page restock rule before the event begins. For example, if a size drops below five units and sales velocity is high, shift one unit from another size; if a style sells out, move accessories to the front of the table; if weather turns hot, push hats and tanks. This is where the operational thinking from logistics hubs and inventory structure during volatility becomes especially useful.
9) What Good Forecasting Looks Like in the Real World
Case Example: Charity Half Marathon Booth
Imagine a charity half marathon with 600 participants, 200 volunteers, and a small expo booth. Last year the club sold 175 tees and 40 hoodies, but finished with 28 leftover medium tees and 12 leftover XL hoodies. This year, the team uses registration data and pre-order trends to predict 190 tees and 50 hoodies, then adjusts the size curve to add 10% more large and XL shirts while trimming XS and 2XL+ slightly. The result: better sell-through, fewer markdowns, and stronger cash flow for the charity partner. That is merchandise forecasting working exactly as it should.
Case Example: Local Club Fundraiser
A local club running a fundraiser through a community booth might have lower attendance but better conversion because members are already motivated buyers. In that case, the best strategy is often a narrow product line with a high-margin accessory, such as hats, socks, or mugs, paired with one hero apparel item. Smaller groups should not imitate large races by ordering too many SKUs. The point is to maximize profit margin per square foot of table space, which echoes the discipline in accessory deal tracking and squeezing value from limited inventory budgets.
Case Example: Destination Marathon Expo
A destination race booth has a different pattern because attendees often buy emotionally and travel light. They want items that fit in a suitcase, signal participation, and make sense as gifts. Forecasting should favor lighter apparel, compact accessories, and styles tied to the destination or course landmark. For race directors, the question is not just “what will sell?” but “what will people be glad they bought before they left town?” That is the same consumer logic behind value-focused travel shopping and friction-reducing booking systems.
10) Common Forecasting Mistakes and How to Avoid Them
Overordering Based on Optimism
The most common error is assuming every event will outperform the last one. Enthusiasm is not a forecast. If you are planning for growth, do it deliberately by increasing only one or two variables at a time, such as total units or one high-demand size, rather than expanding everything. Clubs that stay grounded usually keep a better profit margin and less dead stock.
Ignoring Channel Differences
Sales from pre-registration, packet pickup, and race-day booth traffic are not the same. Pre-registration favors certainty and convenience, while booth sales depend more on emotion, visibility, and impulse. If you lump them together, your model will miss the mechanics of why the product sold. Similar channel-specific thinking shows up in authentic content strategy and travel deal evaluation.
Failing to Review Supplier Constraints
Sometimes the forecast is right but the supply plan is not. Minimum order quantities, print lead times, and size availability can distort the perfect mix you want to buy. Always confirm supplier constraints before finalizing the inventory model so your decision is operationally realistic. This is a classic case of aligning strategy with execution, much like the practical checklists used in robust system design and logistics planning.
Pro Tip: If you only have enough data to do one thing, track size distribution by item and event type. That single habit will reduce leftover inventory faster than adding more product categories.
11) FAQ: Merchandise Forecasting for Clubs and Race Directors
How much historical data do we need before making a reliable merch forecast?
Even one prior event can help if the participant mix is similar. With two to three events, you can begin to identify patterns by size, style, and channel. If you only have one race, use registration data plus conservative buffers and revisit the forecast after the first wave of sales.
Should we forecast by total units or by revenue?
Both matter, but units should come first because leftover inventory is a physical problem, not just a financial one. Once unit counts are set, use revenue and margin to choose which styles deserve more shelf space or deeper investment.
What if our registration form does not collect shirt sizes?
Use a short pre-event survey, voluntary merch pre-orders, or past pickup behavior as proxies. Going forward, add a size field to the registration process if possible, because direct size data is the most valuable signal in your model.
How do we forecast for volunteers and race staff?
Keep volunteer demand in a separate bucket. Volunteers often have different size preferences than runners and may prefer practical fits over event souvenirs. Treat them as their own segment so they do not distort the runner size curve.
What is the safest starting point for a first-time merch order?
Choose one hero apparel item and one accessory, then order slightly more of the median sizes than the extremes. Avoid too many styles until you have at least one complete sales cycle of data.
How can we protect profit margin without raising prices too much?
Improve margin by reducing dead stock, limiting unnecessary SKUs, negotiating better unit costs, and prioritizing items with strong sell-through. Often the biggest profit lift comes from not overbuying, not from charging significantly more.
Conclusion: Treat Merch Like a Forecastable Product Line
Clubs and race directors do not need enterprise software to make better merchandise decisions. They need a repeatable process: capture the right data, segment the audience, forecast demand by item and size, and review actual sales after every event. That simple discipline is what turns merch from a gamble into a reliable fundraising engine. It also makes the event feel more professional, because runners can buy what they want without the awkward experience of seeing the popular sizes vanish too early.
To keep building your event operations playbook, pair this guide with product intelligence frameworks, analytics maturity thinking, and capacity planning methods. If your team can forecast a race shirt correctly, you can forecast a lot more than shirts—you can build a healthier club budget, a cleaner booth operation, and a better experience for every runner who stops by.
Related Reading
- Beat Dynamic Pricing: Tools and Tactics When Brands Use AI to Change Prices in Real Time - Useful for understanding how pricing volatility affects merch margins.
- Earnings Season Playbook: Structure Your Ad Inventory for a Volatile Quarter - A strong analog for managing event inventory under demand swings.
- Design Patterns for Real-Time Retail Query Platforms - Helpful if you want a more advanced forecasting dashboard.
- Real-Time AI Pulse: Building an Internal News and Signal Dashboard for R&D Teams - Shows how to create a recurring review rhythm for data-driven decisions.
- Setting Up a Cross-Border Logistics Hub - Great for clubs managing multiple venues, shipments, or expo touchpoints.
Related Topics
Marcus Ellison
Senior SEO Editor
Senior editor and content strategist. Writing about technology, design, and the future of digital media. Follow along for deep dives into the industry's moving parts.
Up Next
More stories handpicked for you
Smart Textiles for Runners: Which wearable garments actually help marathon performance?
Athleisure, Rentals and Race Travel: How Europe’s apparel trends shape marathon packing
Maximizing Your Marathon Training: The Role of Mental Resilience
How Sport-Jacket Tech Predicts What to Wear for Variable Marathon Weather
The Supply Chain Behind Your Race Jacket: Why Popular Styles Sell Out — and How to Avoid It
From Our Network
Trending stories across our publication group