Holiday Sales Forecast Example (Filled Template + Download)

Photo by RDNE Stock project on Pexels

Look, I get it. You can read a dozen articles about forecasting methods, but what you really need is to see the actual numbers.

Here's the thing: most forecasting guides stop at theory. They tell you to "apply seasonality" and "calculate safety stock" but never show you what that looks like with real SKUs, real uplift percentages, and real purchase order quantities.

In this guide, I'm walking you through a complete holiday sales forecast example—filled out with actual numbers—so you can see exactly how baseline sales, holiday uplift factors, promotional plans, and lead times translate into SKU-level demand projections, safety stock calculations, and final PO quantities with receive windows. You'll grab the Google Sheets template, see how each formula works, and learn to adapt it for your catalog. By the end, you'll have a repeatable system for building Q4 buy plans that protect margins while minimizing stockouts.

Forecast Assumptions & Methodology

This filled example forecasts Q4 2025 demand for a small apparel brand selling 5 core SKUs through their Shopify store. The forecast covers October through December, capturing early holiday shopping, Black Friday/Cyber Monday, and final gift-buying weeks. Here's how we built it:

We started with baseline sales from Q4 2024 (non-promotional weeks), normalized to average daily units (ADU) per SKU. From there, we applied three key adjustments:

1. Holiday Uplift Factor

According to National Retail Federation research, holiday sales typically lift 15-40% above baseline depending on category. For this example, we used conservative uplift percentages:

• October (Early Holiday): +25% vs. baseline
• November (Black Friday week): +150% vs. baseline
• December (Peak Gift): +80% vs. baseline

2. Promotional Multipliers

We layered promotional events on top of base holiday uplift. Black Friday/Cyber Monday received an additional 2.0x multiplier for 5 days. December flash sales got 1.3x for 3-day windows. These stack multiplicatively—so a Black Friday SKU sees baseline × 2.5 (holiday) × 2.0 (promo) = 5.0x normal volume.

3. Lead Time & Service Level Inputs

Each SKU has a supplier lead time (30-45 days in this example) and target service level (95% in-stock rate). We used these to calculate safety stock buffers accounting for demand and lead time variability. The service-level method ensures 95% of customer orders ship without backorders.

Key Assumptions Table

This methodology is conservative by design. We'd rather have 5-10% excess inventory than miss peak-week sales. You can adjust uplift percentages and service levels based on your risk tolerance and cash flow constraints.

For a complete walkthrough of the forecasting workflow (including when to freeze your forecast and how to handle mid-season replans), see our Holiday Demand Forecast Template guide.

Demand Build-Up by SKU

Here's where theory becomes numbers. Let me show you exactly how we calculated weekly demand for each SKU, building from baseline through holiday uplift and promotional spikes.

Example SKU: Women's Cable Knit Sweater (SKU-001)

Baseline Daily Units (ADU): 8 units/day (from Q4 2024 average)

Here's how demand scales across Q4 2025:

Total Q4 Demand for SKU-001: 1,247 units (sum of all weekly totals)

Full SKU Portfolio Demand Summary

Repeating this process across all five SKUs in our example catalog:

Notice the concentration risk: SKU-002 (Men's Flannel) represents 42% of total Q4 demand. A stockout here would be catastrophic. That's why safety stock calculations (next section) are critical—they tell us exactly how much buffer to hold for high-volume, high-impact SKUs.

The spreadsheet includes weekly demand broken out for all 13 weeks. You can adjust uplift percentages, add or remove promotional periods, and immediately see the impact on total units. For step-by-step instructions on building this from scratch, check out our complete forecasting guide.

Safety Stock & Reorder Points

Demand forecasts tell you what you expect to sell. Safety stock tells you how much extra to hold so you don't run out when demand spikes or shipments arrive late.

We use the service-level method because it accounts for both demand variability and lead time variability. Here's the formula:

Safety Stock = Z × √((σ_demand² × ALT) + (ADU² × σ_LT²))

Where:

• Z = Z-score for service level (1.65 for 95%, 1.96 for 97.5%, 2.33 for 99%)
• σ_demand = Standard deviation of daily demand
• ALT = Average lead time in days
• ADU = Average daily units
• σ_LT = Standard deviation of lead time

This method is more accurate than simple "weeks of supply" rules because it mathematically adjusts for SKU-specific risk. High-variability items get larger buffers; stable sellers get smaller ones.

For a deep-dive on this formula (including when to use simpler methods), see our Safety Stock Calculator guide.

Safety Stock Example: SKU-001 (Women's Cable Knit Sweater)

Let's calculate safety stock for our bestseller during peak season:

Inputs:

• ADU (peak period): 19 units/day
• σ_demand: 4.75 units/day (25% of ADU, based on Q4 2024 std dev)
• ALT: 35 days (supplier average)
• σ_LT: 5 days (supplier variability)
• Service Level: 95% (Z = 1.65)

Calculation:

Safety Stock = 1.65 × √((4.75² × 35) + (19² × 5²))
= 1.65 × √(789.38 + 9,025)
= 1.65 × √9,814.38
= 1.65 × 99.07
= 164 units

Reorder Point: (ADU × ALT) + Safety Stock = (19 × 35) + 164 = 665 + 164 = 829 units

Translation: When inventory for SKU-001 drops to 829 units, trigger a replenishment order. The 164-unit safety stock buffer protects against demand spikes (like an influencer post going viral) and late shipments (like port delays).

Full Portfolio Safety Stock Summary

That $15,420 is your insurance policy against stockouts. It sits in inventory but protects $50,000+ in potential lost sales during Q4. The math works.

PO Quantities & Receive Windows

Now we translate demand forecasts and safety stock into actual purchase orders. The goal: ensure inventory arrives before you need it, without tying up too much cash too early.

PO Quantity Formula:

PO Qty = (Total Period Demand) + (Safety Stock) - (Current Inventory) - (Inbound POs)

We split Q4 into three purchase orders to align with inventory velocity and cash flow:

• PO #1 (Receive by Oct 1): Covers October + November early weeks + builds safety stock
• PO #2 (Receive by Nov 15): Covers BFCM surge
• PO #3 (Receive by Dec 1): Covers December peak gift weeks

PO Schedule: SKU-001 (Women's Cable Knit Sweater)

Starting inventory (Sept 30): 200 units

Why split into three POs? Cash flow and risk mitigation. One massive PO locks up capital early and leaves you exposed if demand patterns shift. Three smaller POs let you adjust quantities based on October performance before committing to December inventory.

Full Portfolio PO Summary

Receive Window Recommendations:

• PO-001: Receive by Oct 1 (order by Aug 27, assuming 35-day lead time). Builds base inventory + safety stock before early holiday shopping starts.
• PO-002: Receive by Nov 15 (order by Oct 11). Arrives 9 days before BFCM to cover the surge without over-committing in October.
• PO-003: Receive by Dec 1 (order by Oct 27). Covers final gift-buying weeks; order date allows you to assess November performance before finalizing quantities.

For more on expediting rules, vendor SLAs, and what to do when shipments run late, see our stockout prevention playbook.

Sensitivity Analysis (±10% Demand, ±5 Days Lead Time)

Forecasts are educated guesses. Sensitivity analysis shows you how wrong you can be before things break.

We tested four scenarios for SKU-001 (our highest-volume item):

Key Insights:

• If demand comes in 10% higher than forecast, you need an extra $4,225 in inventory for this one SKU—manageable with expedited mid-season POs.
• If lead times extend 5 days (common during port congestion), safety stock increases 27% (164 → 208 units). Factor this into cash planning.
• The worst-case scenario (demand up 20%, lead time up 7 days) adds $8,075 cost but still keeps stockout risk under 12%. That's the power of safety stock buffers.

Portfolio-Level Sensitivity

Running the same analysis across all SKUs:

In the worst-case scenario, you'd need an additional $29,300 in inventory ($154,230 vs. $124,930 base). If your cash reserves or credit line can't absorb a 23% variance, consider lowering service levels on slower SKUs (like SKU-004 and SKU-005) to free up working capital for heroes (SKU-001 and SKU-002).

For proactive monitoring strategies and when to trigger mid-season replans, see our peak-season management guide.

Download & How to Adapt This Template

This example becomes your template. Here's how to adapt it for your catalog.

What's Included in the Download

The Google Sheets template contains four tabs:

1. Assumptions: Input your baseline data, uplift percentages, promo dates, lead times, service levels. All calculations auto-update when you change these.
2. SKU Forecast: Weekly demand build-up for up to 50 SKUs. Add/remove rows as needed. Formulas are unlocked so you can customize.
3. Safety Stock: Service-level calculator with Z-score lookup. Plug in your demand variability and lead time σ; outputs safety stock and reorder points per SKU.
4. PO Planner: Three-PO schedule with order dates, receive windows, quantities, and costs. Adjust PO split (2, 3, or 4 orders) based on your supplier terms.

Step-by-Step Adaptation Guide

Step 1: Export Your Historical Data

Pull Q4 2024 sales data from your ecommerce platform. You need:

• SKU-level daily units sold (Oct 1 - Dec 31, 2024)
• Exclude promotional days initially (we'll layer those back in)
• Calculate average daily units (ADU) and standard deviation (σ_demand) per SKU

Step 2: Populate the Assumptions Tab

Enter your:

• Baseline ADU per SKU
• Holiday uplift percentages (start with our estimates, refine based on your 2024 actuals)
• Promotional event dates and multipliers
• Supplier lead times (average and std dev)
• Target service levels (95% is standard; 99% for bestsellers, 90% for accessories)

Step 3: Review Auto-Generated Forecasts

The SKU Forecast tab auto-calculates weekly demand. Review for sanity:

• Do peak weeks align with your promo calendar?
• Are any SKUs showing unrealistic spikes (e.g., 10x vs. baseline)?
• Adjust uplift percentages or promo multipliers if needed

Step 4: Calculate Safety Stock

The Safety Stock tab uses your inputs to calculate buffers. If safety stock seems excessive (e.g., 50%+ of total demand), either:

• Lower service level target (95% → 90%)
• Negotiate faster lead times with supplier
• Accept higher stockout risk on low-margin items

Step 5: Generate PO Schedule

The PO Planner tab splits total buy quantities across receive windows. Adjust:

• Number of POs (2-4 depending on lead time flexibility)
• Receive dates (work backward from first sale date minus lead time)
• PO split percentages (heavier weighting to PO-001 if you want more buffer)

Step 6: Run Sensitivity Analysis

Duplicate the forecast tab, adjust demand +10% and lead time +5 days. How much does total investment change? Can your working capital absorb it? If not, prioritize high-velocity SKUs and reduce coverage on slower items.

Additional Resources

Need more guidance? Check these related articles:

• Holiday Demand Forecast Template (2025) - Complete forecasting methodology
• Safety Stock Calculator for Ecommerce - Deep dive on service-level math
• How to Avoid Stockouts During Peak Season - 10-step prevention playbook
• Peak-Season Inventory Management - Weekly replan rituals and vendor SLAs

Frequently Asked Questions

Conclusion

You just walked through a complete holiday sales forecast, from baseline demand to final PO quantities with receive windows. Here's what you learned:

Forecasting isn't guessing—it's structured math. You start with historical baselines, layer on holiday uplift and promotional spikes, calculate safety stock using service levels, and translate everything into purchase orders timed to arrive when you need them. This example showed you the actual numbers for five SKUs across 13 weeks, including the formulas behind every calculation.

The template is yours to adapt. Change the uplift percentages, adjust service levels, add or remove promotional periods, and immediately see the impact on your Q4 buy plan. Run sensitivity analysis to understand your risk exposure. Review weekly and adjust as actual sales data comes in.

Retailers who forecast methodically outperform reactive buyers by 25%+ margin because they optimize inventory dollars and minimize lost sales. According to research from McKinsey & Company, companies that implement demand forecasting see 10-20% reductions in inventory carrying costs while improving product availability by 5-10%.

The work you put into forecasting now saves tens of thousands in Q4 chaos later.

Your next steps:

1. Download the template and populate your SKU data
2. Calculate safety stock using the service-level method
3. Generate your PO schedule and confirm lead times with suppliers
4. Set calendar reminders for weekly forecast reviews starting Oct 1
5. Configure back-in-stock alerts as your backup for forecast misses

Continue Learning:

• Complete Guide: Holiday Demand Forecast Template (2025)
• Safety Stock Calculator for Ecommerce (Service-Level Method)
• How to Avoid Stockouts During Peak Season: 10-Step Playbook
• Back in Stock Alerts: Best Shopify Apps (Features, Setup, Pricing)