A pre-order demand forecast helps you decide how much inventory, cash, staffing, and fulfillment capacity to prepare before opening sales. This reusable worksheet turns waitlist activity, survey responses, traffic assumptions, and operational limits into conservative, expected, and high-demand scenarios you can review before every launch.
Overview
A pre-order is both a sales opportunity and an operational commitment. Even when customers pay before production or fulfillment, you still need to estimate what those orders will require. A useful preorder demand forecast does not pretend to know the exact result. It makes assumptions visible, shows the consequences of being wrong, and gives your team a basis for decisions.
Start with four separate numbers:
- Qualified audience: people who can realistically buy, not every page visitor or social follower.
- Expected conversion: the share of qualified prospects likely to place an order during the campaign.
- Average order size: units, seats, subscriptions, or packages per customer.
- Operational capacity: the maximum quantity your suppliers, team, support operation, and fulfillment process can handle.
The basic calculation is:
Forecasted orders = qualified prospects × expected conversion rate
Then calculate demand in the unit that matters to operations:
Forecasted units = forecasted orders × average units per order
For subscriptions or software, replace units with seats, accounts, onboarding projects, or support hours. A demand forecast should also separate paid orders from softer signals such as email sign-ups, survey interest, and reminder requests. A person on a prelaunch landing page may be showing interest without making a purchase commitment.
Checklist by scenario
1. Build the demand-forecast worksheet
Put the following fields in a spreadsheet or launch operations document. Keep one row for each acquisition channel so your assumptions are easy to change.
| Input | What to record | Example assumption |
|---|---|---|
| Channel | Email, paid search, community, partner, organic, or direct | Waitlist email |
| Reachable prospects | People likely to see the offer during the campaign | 1,000 |
| Purchase conversion | Estimated percentage that will buy | 5% |
| Orders | Reachable prospects multiplied by conversion | 50 |
| Average order size | Units, seats, or subscriptions per order | 1.2 |
| Demand | Orders multiplied by average order size | 60 units |
| Timing | Expected order pattern by day or week | Front-loaded |
Use a range rather than a single conversion rate when the evidence is limited. Record the source of each assumption: a previous launch, a small test, a survey, a waitlist segment, or an explicitly labeled planning estimate. This makes the model easier to improve after launch.
2. Compare conservative, expected, and high-demand outcomes
Use three scenarios to avoid planning only for the result you hope to achieve. The figures below are illustrative assumptions, not benchmarks. Replace them with your own audience size, channel data, pricing, and capacity.
| Scenario | Qualified prospects | Conversion | Orders | Units per order | Units needed |
|---|---|---|---|---|---|
| Conservative | 800 | 2% | 16 | 1.1 | 18 |
| Expected | 1,000 | 5% | 50 | 1.2 | 60 |
| High demand | 1,300 | 8% | 104 | 1.3 | 136 |
Round quantities according to how your business actually operates. If a supplier requires production in batches, model batch sizes rather than rounding casually. If a support team can handle only a fixed number of onboarding calls, treat that limit as a constraint and decide whether to stagger access, simplify onboarding, or cap sales.
3. Translate the forecast into inventory and cash flow
For physical products, calculate the required stock separately from the sales forecast:
Planned production quantity = expected demand + approved buffer − usable existing stock
The buffer should reflect genuine uncertainty, not an automatic percentage. Consider supplier minimums, defect or replacement needs, component lead times, packaging, and the cost of unused stock. If production cannot be increased quickly, compare the cost of excess inventory with the customer impact of delaying fulfillment.
For cash flow, map money in and money out by date. Include payment processing, taxes where applicable, refunds, deposits to suppliers, packaging, freight, storage, software, customer support, and any balance due before delivery. A pre-order can improve upfront cash while still creating a timing gap if supplier payments arrive before the collected funds are available for use.
Use the pre-order pricing strategy guide to document deposits, discounts, tiers, and refund rules before forecasting revenue. Forecast gross cash collected and net usable cash as separate figures.
4. Plan staffing and fulfillment capacity
Convert demand into work. Estimate the number of support tickets, address changes, onboarding sessions, packing actions, quality checks, and delivery exceptions created by each order. For software, include account provisioning, implementation, documentation, and technical support. For a physical product, include receiving, inspection, kitting, labeling, and dispatch.
Create a capacity table with three columns: work type, available capacity per period, and demand under each scenario. If expected demand exceeds capacity, choose an operational response before opening sales: a phased release, a delivery window, a quantity cap, a waitlist for later batches, or a simpler fulfillment process.
What to double-check
- Waitlist quality: Segment subscribers by source, product interest, geography, company size, or stated purchase timing. A large unsegmented list is less useful than a smaller list with clear intent.
- Survey signals: Treat “interested” responses as directional. Ask about the specific offer, price range, quantity, timing, and the problem the buyer is trying to solve. Compare stated intent with a stronger action, such as requesting early access or submitting payment details.
- Channel differences: Do not apply one conversion assumption to every source. Existing customers, referrals, cold traffic, communities, and launch-platform visitors may have different levels of trust and purchase intent.
- Offer mechanics: Check whether a discount, deposit, bundle, limited quantity, or subscription term changes average order size and cancellation behavior. Document assumptions rather than hiding them inside one conversion rate.
- Timing: Model the first day, first week, and full campaign separately. A launch may be front-loaded, gradual, or dependent on a later announcement. Staffing and cash requirements follow the timing, not just the final total.
- Geography and delivery: Review shipping zones, duties, address validation, delivery promises, packaging requirements, and regional service limitations before accepting orders.
- Measurement: Make sure your preorder page analytics distinguish visits, sign-ups, checkout starts, completed orders, refunds, and cancellations.
Common mistakes
Counting every waitlist entry as a likely order. Use waitlist data to estimate interest, then apply a scenario-based conversion assumption. Segment new sign-ups from people who have taken a stronger action.
Forecasting revenue without forecasting obligations. Revenue does not show how many units must be produced, when supplier invoices are due, or how much support customers will need. Pair every sales estimate with a capacity and cash-flow view.
Using a single optimistic model. A high-demand outcome is useful for stress testing, but it should not silently become the production plan. Keep the expected case visible and define what triggers a move to the high-demand response.
Ignoring refunds and changes. Include a planning allowance for cancellations, failed payments, address changes, replacements, and customer service. The appropriate assumption depends on your offer and audience; use your own observed data when available.
Making commitments before confirming constraints. Do not promise a delivery window until suppliers, payment timing, staffing, and fulfillment capacity have been checked together. The pre-order fulfillment workflow can help connect the campaign forecast to the handoff process.
Failing to preserve the model. Save the original assumptions and the actual results. The gap between them is more useful than a revised forecast that erases what was originally expected.
When to revisit
Review the forecast before opening sales, after meaningful new waitlist or survey data arrives, and during each weekly campaign review. Recalculate whenever the price, offer, audience, channel mix, delivery promise, supplier lead time, or payment workflow changes. Revisit it before seasonal planning cycles as well, because traffic patterns and operational capacity may differ from an ordinary launch.
At each review, update five items:
- Actual qualified prospects by channel.
- Observed sign-up, checkout, purchase, refund, and cancellation rates.
- Current orders, units, seats, or subscriptions committed.
- Remaining inventory, cash available, supplier commitments, and team capacity.
- The trigger for moving from the conservative plan to the expected or high-demand response.
Finish with one decision, not just a revised spreadsheet: increase production, hold capacity, adjust the delivery window, pause a channel, cap orders, or continue collecting data. A forecast earns its place in launch operations when it changes a practical commitment. For a broader preparation sequence, use the pre-order campaign checklist, then return to this worksheet whenever the inputs change.