Operations

Wholesale Order Volume Forecast: Cohort Method for Production Planning

Wholesale Order Volume Forecast: Cohort Method for Production Planning

You forecast wholesale order volume by multiplying the number of active accounts in each retailer tier by their expected first-order size and reorder rate, then applying seasonal multipliers to monthly totals. This cohort-based method requires a spreadsheet, your historical order data, and estimates for accounts you have not yet closed.

Why cohort-based forecasting works for new brands

Wholesale order patterns differ by retailer type. A boutique placing a $400 first order typically reorders every 90 days at 60 percent of the original size. A regional chain placing a $2,000 first order may reorder every 60 days at 80 percent. Grouping accounts by tier and modeling each tier separately produces a more accurate forecast than applying one average reorder rate across all customers.

This method uses the patterns you can observe in your first 10 to 20 wholesale accounts to project the next 50. It does not require purchase history for every SKU or machine learning models.

Step 1: Define retailer tiers and collect baseline data

Create three to five tiers based on store count, revenue, or geographic reach. A common structure for consumer product brands:

  • Tier 1: Independent boutiques, single location, $300 to $800 first order
  • Tier 2: Small chains, 2 to 5 locations, $1,000 to $2,500 first order
  • Tier 3: Regional chains, 6 to 20 locations, $3,000 to $8,000 first order

For each tier, calculate the average first-order size from your existing accounts. If you have fewer than three accounts in a tier, use the minimum order value you set for that tier as the starting estimate.

Next, measure the reorder rate. Count how many accounts in each tier placed a second order within 120 days of their first order. Divide that number by the total accounts that have been active for at least 120 days. A brand with 12 Tier 1 accounts where 7 reordered within 120 days has a 58 percent reorder rate for that tier.

Record the average reorder size as a percentage of the first order. If first orders averaged $500 and second orders averaged $350, the reorder size is 70 percent.

Step 2: Build the monthly cohort model

Open a spreadsheet with months in rows and retailer tiers in columns. For each tier, create three sub-columns: new accounts expected that month, reorders expected that month, and total order volume.

Enter the number of new accounts you expect to close each month in each tier. If you are running outreach or working with a sales team, base this on your pipeline conversion rate. A brand sending 200 emails per month with a 3 percent close rate expects 6 new accounts per month. Allocate those 6 across tiers based on your target mix.

For reorders, look back at the months when you added accounts. An account added in January that reorders every 90 days will place a second order in April. Mark one reorder in April for that tier. Repeat for every cohort. After three or four months, you will see a pattern: each monthly cohort of new accounts generates a wave of reorders 60 to 120 days later.

Multiply new accounts by average first-order size. Multiply reorders by first-order size times the reorder percentage. Sum the two for total monthly volume by tier. Add tiers together for total monthly wholesale order volume.

Example calculation for one tier

Tier 1 boutiques, April forecast:

  • New accounts expected: 4
  • Average first order: $500
  • New account volume: 4 times $500 = $2,000
  • Reorders expected: 5 (from January cohort, 90 days later)
  • Reorder size: $500 times 70% = $350
  • Reorder volume: 5 times $350 = $1,750
  • Total April volume, Tier 1: $3,750

Repeat for each tier and month. A brand forecasting six months ahead will have six rows, one per month, with volume broken out by tier and summed across all tiers.

Step 3: Apply seasonal multipliers

Wholesale order volume in consumer products typically peaks before key retail seasons. Apparel and home goods see higher order volume in July and August (fall/holiday inventory) and January and February (spring inventory). Food and beverage brands often see a spike in October and November as retailers stock for holiday gifting.

Review your order history by month. Divide each month's total volume by your average monthly volume to get a seasonal index. A month with $8,000 in orders when the average month is $5,000 has an index of 1.6. A month with $3,000 has an index of 0.6.

If you have less than 12 months of history, use industry norms as a starting point and adjust once you have data. Apply the seasonal multiplier to your cohort-based forecast for each month. If your model predicts $10,000 in base volume for August and your seasonal index for August is 1.4, forecast $14,000.

Step 4: Adjust for order timing and lead time

Retailers do not order the day they need inventory. They order based on your lead time plus a buffer. If you promise 4-week lead times, most buyers will order 5 to 6 weeks before they need stock on the shelf.

Shift your forecast forward by your lead time to convert order volume into production volume. Orders you receive in April with a 4-week lead time require production to start in April for May delivery. For production planning, the April order forecast drives April production capacity, not May.

If you offer prepay or deposit terms, orders typically arrive closer to the delivery date because the buyer is committing cash. If you offer net terms, orders may arrive further in advance as buyers lock in allocation.

Step 5: Track forecast accuracy and refine

Compare your forecast to actual orders each month. Calculate the percentage difference between forecasted volume and actual volume by tier. A forecast of $12,000 with actual orders of $10,500 is 12.5 percent under.

After three months, review which assumptions were wrong. Common adjustments:

  • Reorder rates were lower than expected because sell-through at retail was slower
  • First-order sizes were smaller because buyers tested with a partial assortment
  • New account acquisition was slower because outreach conversion dropped
  • Seasonal multipliers were too aggressive for a new brand without established retailer relationships

Update your tier averages and reorder rates with actual data every quarter. The forecast becomes more accurate as your sample size grows.

When to add complexity

The cohort-based model assumes reorder rates and sizes stay consistent within a tier. It does not account for SKU mix, retailer churn, or changes in your product line. Add those variables when:

  • You have 50 or more active accounts and enough data to model churn by cohort
  • SKU-level forecasting matters because production constraints or ingredient costs vary significantly by product
  • You are managing multiple sales channels and need to allocate inventory between wholesale and direct-to-consumer

Before adding complexity, confirm the simple model is consistently within 20 percent of actual volume. If it is not, the issue is usually bad assumptions about reorder rates or new account acquisition, not missing variables.

How Get Wholesale Orders helps

Get Wholesale Orders provides a live dashboard that tracks wholesale orders by retailer tier, order date, and delivery date. The CRM logs every new account and reorder, so you can calculate tier-specific reorder rates and first-order averages without manual data entry. Reporting shows order volume by month, which feeds directly into seasonal multiplier calculations.

Next step

Open a spreadsheet and create columns for each retailer tier you sell to. Enter the number of active accounts in each tier, the average first-order size, and the percentage that reordered within 90 days. Multiply those three numbers together to estimate next quarter's reorder volume, then add your expected new account volume. That single calculation will tell you whether your current production capacity is enough or whether you need to adjust.

← Back to all insights

Ready to grow your wholesale channel?

Tell us about your product and where you want to sell. We'll help you take the first step.