Holiday Sales Forecasting for Makers — Start with Inventory, Not Revenue
Most holiday forecasting advice tells makers to project revenue first. That's backwards. Here's how to forecast from production capacity and materials availability — so you actually have product to sell.
Every November, the same thing happens. Orders arrive faster than expected. You run out of a key material. You have to pause your shop mid-rush while you wait for a supplier delivery. You leave money on the table, and you’re exhausted.
The fix isn’t “order more stuff earlier.” It’s forecasting properly — and most holiday forecasting advice for makers gets the sequence exactly backwards.
The popular approach: project how much revenue you want to make in Q4, work backwards to figure out how many products that requires, and then figure out what materials you need. Revenue first, inventory second.
But if you make things, that logic doesn’t hold. Your revenue in Q4 is bounded by how much you can physically produce. And how much you can produce is bounded by what materials you have on hand, how much time you have to make things, and how early you start building stock.
So the right sequence is: inventory first, revenue second.
This post walks through how to do holiday sales forecasting the maker way — starting from what you can actually produce and building up from there.
Why Revenue-First Forecasting Fails Makers
Here’s a quick illustration of the problem.
Say you want to make $10,000 in November and December. Each of your main products sells for $40, so that’s 250 units. Great — put that in a spreadsheet and work backwards to your materials.
But what does 250 units actually require in terms of your time? If each unit takes 45 minutes to make, that’s 187.5 hours of production time. Over eight weeks (October and November), that’s about 23 hours per week, on top of running your business, handling orders, packing, and everything else.
Does that actually fit into your schedule? Maybe. Maybe not. And if it doesn’t, the revenue target was fiction from the start.
The bigger issue is materials. Your supplier for a key component has a 3-week lead time. If you don’t place that order before mid-September, it won’t arrive until October — and by then, you’ve lost 2-3 weeks of your stock-build window.
Revenue-first forecasting skips both of these constraints. Inventory-first forecasting starts with them.
Step 1 — Look at Last Year’s Sales Data
Before you can plan, you need to know what actually happened last year. Not your best guess — the actual numbers.
Pull your order history from October, November, and December. For each month, you want:
- Total orders and revenue
- Units sold by product (which products drove Q4 sales?)
- Peak days or weeks (was it a steady ramp, or did Black Friday week do the heavy lifting?)
- What ran out (if you had to pause listings or decline orders, note when and why)
If you’ve been using inventory software, this data is easy to pull. If you were working from spreadsheets, piece it together as best you can.
The handmade business seasonal sales calendar we published earlier this year shows real order data from 1,200+ Craftybase sellers. November runs at 50% above average monthly volume. December peaks at 70% above average. The week of Black Friday (week 47) is typically the single biggest week of the year — often 2.5–3x a normal week.
That pattern holds across niches and selling channels. Plan for that shape, not a smooth linear ramp.
Step 2 — Calculate Your Production Capacity
This is the step most makers skip. Before you can forecast what you’ll sell, you need to know what you can actually make.
Work through these questions for your Q4 window (typically October through mid-December, about 10–11 weeks):
Available hours per week: How many hours can you realistically dedicate to making? Be honest about the difference between “making hours” and total work hours — admin, packing, customer service, and listing management eat into the day too.
Units per hour by product: How long does each product actually take to produce — including drying or curing time, packaging, and quality checks? Batch production changes this number significantly. (Making 12 soaps at once is faster per unit than making 1 soap at a time.)
Batch size constraints: Do any products have minimum batch sizes, curing periods, or kiln schedules that limit how fast you can produce? A candle maker who can only fire 4 batches per week has a hard ceiling that no amount of extra materials can solve.
Once you have these numbers, the math is simple:
Available hours per week × weeks in window × units per hour = maximum production capacity
If your maximum production capacity for the 10-week window is 300 units, your forecasted revenue is the revenue from 300 units — not a number you made up in a spreadsheet.
That’s your ceiling. Everything else is about getting as close to that ceiling as possible.
Step 3 — Plan Your Materials Ordering
Now that you know how much you can produce, you can calculate what materials that requires.
Pull up your recipes or bills of materials for each product you plan to make. For each material, you need:
- Quantity required per unit
- Current stock on hand
- Supplier lead time (how long from order to delivery?)
- Minimum order quantities (do you have to buy in larger volumes?)
Calculate how much of each material your production plan requires, subtract what you have on hand, and the difference is what you need to order. Factor in a 10–15% buffer for waste, batch failures, or unexpected demand.
Then count backwards from your first production date to determine the order deadline. If you need materials by October 1st and your supplier takes 3 weeks, your order needs to go in by September 10th.
The reorder point formula is useful here — specifically for recurring materials you use year-round. But for a holiday production build, you’re doing a one-time demand calculation on top of your regular reorder rhythm.
A common mistake: forgetting about packaging materials. Tissue paper, boxes, poly mailers, ribbon — these all have lead times. And they always seem to run out the week before Christmas when every supplier is back-ordered.
Step 4 — Set Your Stock-Build Timeline
Knowing what you need to produce and what materials you need to order is one thing. Actually scheduling it into your calendar is another.
Work backwards from your target “ready by” date. If you want to have your full stock build complete before November 1st (so you’re not producing during the rush), that means:
- Production plan needs to be done by October 31st
- All materials need to arrive by October 1st (leaves a week buffer)
- Orders need to be placed by September 10th (3-week lead time + buffer)
Map this onto your actual calendar. Add in any life constraints — school holidays, events, other commitments — and adjust the plan to fit.
If the timeline doesn’t work out, your options are:
- Start earlier (can you begin your stock build in August instead of September?)
- Narrow your product range (can you focus on your top 3 sellers instead of 8?)
- Set a lower production target and manage expectations on stock levels
All three are valid. Deciding this in April is infinitely better than discovering the problem in October.
Step 5 — Now Project Your Revenue
With your production capacity and timeline defined, the revenue forecast is actually quite simple.
Take your planned unit count for each product. Apply your expected sell-through rate (not 100% — be realistic about what’s likely to sell vs. what might carry over to January). Multiply by price.
That’s your Q4 revenue forecast.
It’s not aspirational. It’s grounded in what you can actually make and sell. And that groundedness is the whole point — a forecast that leads to real preparation is worth far more than an optimistic number that leaves you scrambling in November.
One more thing: build a “stretch scenario.” If demand runs hot — say, 20% above your base case — do you have materials on hand to respond? Can you run a weekend production sprint? Knowing in advance what your upside looks like (and whether you can capture it) is part of a complete holiday plan.
Using Software to Track This
The manual version of all this — spreadsheets, handwritten timelines, calculations on paper — works. It’s just slow and error-prone, especially when you have multiple products and multiple suppliers.
Craftybase tracks your materials inventory in real time, stores your recipes with exact material quantities per unit, and gives you stock-level visibility across all your products. When you’re planning your holiday production run, you can see exactly how many units your current materials can support — and get alerts when stock drops below your reorder threshold.
It also pulls your order history from connected stores (Etsy, Shopify, WooCommerce, and others), so the sales data analysis from Step 1 is already waiting for you rather than something you have to compile manually.
If you’re still running your Q4 planning from a spreadsheet, try Craftybase free for 14 days and see how much faster the whole process becomes.
Frequently Asked Questions
When should makers start their holiday sales forecasting?
Most makers should start their holiday sales forecasting in July or August, with materials orders placed by mid-September at the latest. The constraint is supplier lead time — if key materials take 3–4 weeks to arrive, you need to order in September to begin a serious production build in October. Starting the planning process earlier (April or May) gives you time to identify material gaps and shop around for better suppliers or pricing before you're under time pressure.
How do I forecast holiday sales if I don't have last year's data?
If it's your first Q4, use the production-capacity method as your anchor: calculate how much you can physically make in your stock-build window, and plan materials accordingly. For revenue expectations, industry data shows November and December typically run 50–70% above a maker's average monthly volume — apply that multiplier to your current monthly average as a baseline, then adjust for your specific niche and channels. It's better to build conservatively and sell out than to over-produce in your first year.
What's the biggest mistake makers make when planning for the holiday rush?
Starting too late. The most common error is beginning the stock build in October, when supplier lead times and production constraints mean you can't realistically have enough product ready by Black Friday. A close second is forgetting packaging materials — tissue paper, boxes, and poly mailers frequently back-order in October and November, and running out of packaging mid-rush is just as business-stopping as running out of materials.
How much safety stock should I hold for Q4?
A 15–20% buffer above your calculated material requirement is a reasonable starting point for Q4. This accounts for batch failures, supplier shortfalls, and demand running above your base forecast. For materials with long lead times (3+ weeks) or unreliable suppliers, push that buffer to 25%. For perishable or time-sensitive materials, keep the buffer lower to avoid waste. Craftybase's reorder alerts can help you track when you're drawing down into buffer territory during the rush.
Should I raise my prices for the holiday season?
Not usually — but you may want to introduce premium bundles or gift sets that carry a higher average order value. Raising base prices for the holiday season can damage customer trust and trigger negative reviews. A better approach: use Q4 as an opportunity to test premium price points on new products or limited editions, where buyers don't have a price anchor. If your production capacity is genuinely limited, consider capping listings or introducing a waitlist rather than raising prices on existing products.
