EN
Inventory and Products

How Do You Plan Seasonal Product Inventory? A Course on Demand Scenarios, the Critical Ratio, Order Quantity, Early Markdowns and End-of-Season Stock Carryover

How do you plan seasonal product inventory? Demand scenarios, the critical ratio, order quantity, early markdowns and end-of-season carryover: an 8-lesson guide with examples.

Contents 14 sections
  1. What will you be able to do by the end of this training?
  2. Lesson 1: Why is inventory planning different for seasonal products?
  3. Lesson 2: How do you set out demand scenarios?
  4. Lesson 3: What do overstock and understock cost, and how do you find the critical ratio?
  5. Lesson 4: How do you choose the order quantity based on expected profit?
  6. Lesson 5: How do you read the expected stock flow?
  7. Lesson 6: How do you track sales pace during the season, and when does an early markdown make sense?
  8. Lesson 7: What do you do with stock left at the end of the season?
  9. Lesson 8: How do you track a seasonal inventory plan?
  10. What are the most common mistakes in planning seasonal product inventory?
  11. How does NetKasam make seasonal inventory tracking easier?
  12. Mini quiz: Test what you have learned
  13. Conclusion: Calculate the critical ratio for one seasonal product
  14. Frequently Asked Questions About Seasonal Product Inventory

In September you're ordering winter coats. The supplier produces a single batch, with no second round; you'll sell exactly as many coats as you order. Buy too few and there will be no coats on the shelf in January, and customers will go to a competitor. Buy too many and in February you'll be left with hundreds of coats and forced to sell below purchase price. That's the challenge of seasonal products: there's no second chance, but there are two different ways to get it wrong.

This article is not a narrative but an 8-lesson practical course. We will answer the question how do you plan seasonal product inventory using a single-batch coat order: how to set out demand scenarios, the cost of overstock and understock, choosing the order quantity with the critical ratio, size allocation, in-season tracking and the early markdown decision, the end-of-season close and tracking indicators. At the end there is a mini quiz with an answer key. For safety stock on products with continuous demand, see the article how to calculate safety stock; this article explains the different logic of products that can't be reordered.

What will you be able to do by the end of this training?

In short: You will set out demand scenarios, calculate the cost of overstock and understock, determine the order quantity with the critical ratio, track inventory during the season and plan the end of the season.

Course mapSix steps of the seasonal inventory plan
  1. 01
    DemandWrite down three to five scenarios and their probabilities.
  2. 02
    CostFind the overstock and understock costs.
  3. 03
    RatioCalculate the critical ratio.
  4. 04
    QuantityCompare expected profit and split it across sizes.
  5. 05
    TrackingCheck the sales pace during the season.
  6. 06
    CloseDecide whether to clear or carry over the remaining stock.

The 8 lessons of the course: (1) what makes seasonal products different, (2) demand scenarios, (3) overstock and understock costs, (4) order quantity, (5) expected stock flow and size allocation, (6) in-season tracking and early markdowns, (7) end-of-season close and carryover, (8) tracking indicators.

Lesson 1: Why is inventory planning different for seasonal products?

In short: A seasonal product has a short selling life and is ordered once; so reorder point and safety stock logic doesn't work, and a single quantity decision is made.

FeatureContinuous productSeasonal product
Number of ordersRepeatedSingle batch or very limited
Error costReorder when stock runs outUnderstock: lost sales; overstock: clearance at a discount
Main measureInventory turnover, safety stockExpected profit, critical ratio
Remaining stockCarried into the next periodLoses value or creates a carryover cost

The decision rests on two separate risks. The overstock risk is that leftover product goes cheap at the end of the season. The understock risk is that there's no product left to sell even though there is demand. Businesses mostly focus on the first risk, because leftover stock is visible; understock is invisible, because lost sales don't appear in any record. Yet for high-margin products, the second risk is more expensive. We looked at inventory turnover for continuous products in the article how to calculate inventory turnover; for a seasonal product, what matters is not turnover but the outcome of a single batch.

Example business: an e-commerce business selling winter coats, with a purchase cost of ₺400 per coat, a selling price of ₺800, and clearing leftover coats at ₺300 at the end of the season. For simplicity, other costs such as shipping, commission and returns are kept separate, and only the purchase, selling and end-of-season prices are compared.

Lesson 2: How do you set out demand scenarios?

In short: Instead of a single demand forecast, you write down three to five scenarios and the probability of each. Last season's sales are the starting point, but out-of-stock days must be corrected for.

Use four pieces of information when setting out scenarios. First, last season's unit sales. Second, the number of days the product was out of stock that season: if the product sold out, real demand is higher than sales. Third, the expected change for this year: a new channel, the campaign calendar, a price change. Fourth, the first-week sales pace of similar products at the start of the season. You can find the detailed method for sales forecasting in the article how to forecast sales.

ScenarioSeason demandProbabilityCumulative probability
Weak season800 units%10%10
Low1,000 units%20%30
Expected1,200 units%40%70
High1,400 units%20%90
Very strong season1,600 units%10%100

Average demand is 800 × 0.10 + 1,000 × 0.20 + 1,200 × 0.40 + 1,400 × 0.20 + 1,600 × 0.10 = 80 + 200 + 480 + 280 + 160 = 1,200 units. Check that the probabilities add up to 100%. The probabilities aren't certain knowledge but your judgment; what matters is writing them all down and staying consistent. If you have no data from last season, match the new product to a similar product's sales curve and keep the gap between scenarios wider.

Lesson 3: What do overstock and understock cost, and how do you find the critical ratio?

In short: Each missing unit costs as much as the profit forgone, and each excess unit costs the difference between the purchase price and the end-of-season price. The ratio of these two costs gives the critical ratio and determines the order quantity.

FormulaFour formulas for the critical ratio
  1. Understock cost = Selling price − Purchase cost
  2. Overstock cost = Purchase cost − End-of-season price
  3. Critical ratio = Understock cost ÷ (Understock cost + Overstock cost)
  4. Order quantity = The first demand level whose cumulative probability reaches or exceeds the critical ratio

Prepared with sample values.

In the example, the understock cost is 800 − 400 = ₺400, the overstock cost is 400 − 300 = ₺100, and the critical ratio is 400 ÷ (400 + 100) = 0.80. What it means: when you order one additional unit, it's worth ordering if the probability of that unit selling is above 80%, and not worth it if below. In the cumulative probability table, the first level that reaches or exceeds 80% is 1,400 units (90%). So the order quantity is 1,400.

SituationUnderstock costOverstock costCritical ratioRecommended quantity
Example: selling price 800, end of season 300400 ₺100 ₺0,801,400 units
End-of-season price ₺200400 ₺200 ₺0,671,200 units
Selling price ₺600, end of season ₺300200 ₺100 ₺0,671,200 units
Can be sold at cost (₺400) at the end of the season400 ₺0 ₺1,001,600 units

The table shows how the rule matches intuition: the harder it gets to clear the product at the end of the season (higher overstock cost) or the lower the margin, the less you order; if clearing is easy and the margin is high, the more you order. The same logic works in reverse for low-margin products: if the margin is low, ordering below the average is better. That's why the rule "order the average demand" is correct only when the two costs are equal (critical ratio 0.5).

Recommended readingHow Do You Clear Dead Stock?

Lesson 4: How do you choose the order quantity based on expected profit?

In short: For each order quantity, you calculate the profit in the five scenarios and weight it by probability. The quantity that gives the highest expected profit turns out to be the same as the result you found with the critical ratio.

Profit formula: Selling price × units sold + end-of-season price × units left − purchase cost × order quantity. For example, if you order 1,400 units and demand comes in at 1,000: 800 × 1,000 = ₺800,000 in sales, 400 units are left, 300 × 400 = ₺120,000 in end-of-season revenue, 400 × 1,400 = ₺560,000 in cost; profit is 800,000 + 120,000 − 560,000 = ₺360,000.

OrderDemand 800Demand 1,000Demand 1,200Demand 1,400Demand 1,600Expected profit
800 units320.000320.000320.000320.000320.000320.000 ₺
1,000 units300.000400.000400.000400.000400.000390.000 ₺
1,200 units280.000380.000480.000480.000480.000440.000 ₺
1,400 units260.000360.000460.000560.000560.000450.000 ₺
1,600 units240.000340.000440.000540.000640.000440.000 ₺
ChartExpected profit: ordering 1,400 units is highest, 1,200 (the average demand) is second
  1. Order of 800 units₺320,000
  2. Order of 1,000 units₺390,000
  3. Order of 1,200 units₺440,000
  4. Order of 1,400 units₺450,000
  5. Order of 1,600 units₺440,000

Prepared with example values. Expected profit is the probability-weighted average of the five demand scenarios.

An example of the expected profit calculation: for 1,400 units, 0.10 × 260,000 + 0.20 × 360,000 + 0.40 × 460,000 + 0.20 × 560,000 + 0.10 × 560,000 = 26,000 + 72,000 + 184,000 + 112,000 + 56,000 = ₺450,000. For 1,200 units: 0.10 × 280,000 + 0.20 × 380,000 + 0.70 × 480,000 = 28,000 + 76,000 + 336,000 = ₺440,000. The difference is only ₺10,000; the fact that the critical ratio result and the table point to the same place also shows the calculation is correct.

So, 1,400 or 1,200? Expected profit points to 1,400, but the worst case adds a note: if demand comes in at 800, an order of 1,400 units earns ₺260,000 and an order of 1,200 earns ₺280,000; in other words, in the worst case the gap between the two decisions is ₺20,000. For a business short on cash, the ₺80,000 purchase cost of the extra 200 coats can be risky; in that case 1,200 is the more balanced choice. Assess the cash side together with the article how to prepare a cash flow statement. The expected profit calculation shows the decision that gives the best average outcome, not the safest decision.

Lesson 5: How do you read the expected inventory flow?

In short: The expected outcome of a 1,400-unit order: about 1,180 units sell during the season and 220 units are left at season end; the probability of demand exceeding the order is only 10%.

ChartExpected flow of a 1,400-unit order: 1,180 units sell during the season, 220 units are left at season end
  • Sold during the season (expected)₺1,18084.3%
  • Left at season end (expected)₺22015.7%

Prepared with sample values.

Expected sales: 800 × 0.10 + 1,000 × 0.20 + 1,200 × 0.40 + 1,400 × 0.30 = 80 + 200 + 480 + 420 = 1,180 units; in the last term, the scenarios with demand of 1,400 and 1,600 (30% in total) sell the entire order. Expected leftover: 600 × 0.10 + 400 × 0.20 + 200 × 0.40 = 60 + 80 + 80 = 220 units. The probability of a stockout is only the scenario where demand comes in at 1,600, 10%; in that case, 200 units of demand go unmet.

ItemExpected value
In-season sales revenue1.180 × 800 = 944.000 ₺
End-of-season revenue220 × 300 = 66.000 ₺
Purchase cost1.400 × 400 = 560.000 ₺
Expected profit944.000 + 66.000 − 560.000 = 450.000 ₺
ChartExpected profit flow of a 1,400-unit order: ₺450,000
  1. In-season sales revenue (expected)₺944,000
  2. End-of-season clearance revenue (expected)₺66,000
  3. Purchase cost−₺560,000
  4. Expected profit₺450,000

Prepared with sample values. Total: 944,000 + 66,000 − 560,000 = ₺450,000.

Don't forget to split the seasonal plan into variants such as size and color. The same 1,400 units are distributed according to your own sales share from last season: for example S 15% (210 units), M 30% (420 units), L 30% (420 units), XL 25% (350 units); 1,400 units in total. Deviating from the numbers in which sizes actually sell creates excess stock in one size and shortages in another. You can find inventory tracking for products with variants in the article how to manage products with variants on marketplaces.

Lesson 6: How do you monitor sales velocity during the season, and when does an early discount make sense?

In short: Mid-season, you compare actual sales with the plan and forecast end-of-season sales. If sales velocity is low, an early discount is profitable only if it lifts demand above the required rate.

In a 12-week season, planned sales at the end of week 6 were 590 units (half of the expected total of 1,180); actual sales were 480 units, meaning 81% of plan. At this pace, season sales come to 480 ÷ 590 × 1,180 ≈ 960 units, leaving 440 units. Remaining stock is 1,400 − 480 = 920 units; if another 480 sell in the second half, 440 units are left at season end.

If you apply an early 20% discount (800 → ₺640), sales in the second half rise, but your unit revenue falls. Let's compare the options by second-half revenue. Without a discount: 480 × 800 = ₺384,000 in sales + 440 × 300 = ₺132,000 in clearance = ₺516,000.

Sales lift from the discountSecond-half salesRevenue (₺640 × sales + ₺300 × leftover)Difference vs. no discount
%25600 units384.000 + 96.000 = 480.000 ₺−36.000 ₺
47% (break-even)≈706 units≈516.000 ₺≈0
%60768 units491.520 + 45.600 = 537.120 ₺+21.120 ₺
%80864 units552.960 + 16.800 = 569.760 ₺+53.760 ₺

Break-even: 640 × x + 300 × (920 − x) = 516,000 → 340 × x = 240,000 → x ≈ 706 units, meaning a sales increase of 706 ÷ 480 − 1 ≈ 47%. If the discount brings in fewer sales than this threshold, its cost is selling products that would otherwise be left at season end at a higher price. The key lesson is this: an early discount is not a "safety" measure but a calculated decision. If it is not expected to lift sales this much, waiting for end-of-season clearance is more profitable than discounting the product; if it is, an early discount both reduces leftover stock and prevents an end-of-season price drop. For the safe limit of price discounts, see how to discount without losing money and the discount calculator tool.

Lesson 7: What do you do with leftover stock at season end?

In short: There are two options for leftover stock: clearing it at season end or carrying it over to the next season. Carrying over makes sense only when the product is highly likely to sell again next season.

In the example, the options for each leftover coat are: clear it now at ₺300 or carry it over to the next season. Assumptions for carrying over: since it will be less current next season it can sell for ₺600, there is a monthly financing cost of 4% for 9 months (400 × 0.04 × 9 = ₺144) and a storage risk. If the probability of the carried-over product selling is p, the expected net value is 600 × p − 144.

Probability of sellingExpected net valueDifference vs. clearanceDecision
%50600 × 0,5 − 144 = 156 ₺−144 ₺Clear now
%70600 × 0,7 − 144 = 276 ₺−24 ₺Clear now
74% (break-even)600 × 0,74 − 144 = 300 ₺0No difference
%90600 × 0,9 − 144 = 396 ₺+96 ₺Carry over

Break-even probability: 600 × p − 144 = 300 → p = 444 ÷ 600 = 74%. So if you are not more than 74% sure it will sell next season, clearing it today at ₺300 is the better choice. For classic products that don't go out of fashion, the probability is high; for trend-driven products, it is low. For ways to clear dead stock, channel choice and bundling, see the article how to clear dead stock.

In NetKasam, with the stock movements report you can see in which warehouse and which variant leftover products sit throughout the season, list products on online sales channels via XML, and set a critical stock level to get an alert when stock drops to that level. For distributing products across channels, the article how to sync marketplace inventory is a useful complement. For end-of-season balancing between warehouses, see the article how to transfer stock between warehouses.

Lesson 8: How do you monitor a seasonal inventory plan?

In short: Track five indicators: in-season sell-through rate, remaining stock, the gap between planned and actual sales, the number of stockout days and realized profit. At season end, write the plan and the actuals side by side.

IndicatorSample valueHow it is calculated
In-season sell-through rate%84,3Sold ÷ Ordered (1,180 ÷ 1,400)
Remaining stock220 unitsOrdered − Sold
Plan deviation81% (week 6)Actual ÷ Planned (480 ÷ 590)
Stockout probability%10Probability of scenarios where demand exceeds the order
Expected profit450.000 ₺Probability-weighted average of scenario profits
Takeaways from the exampleFour numbers from the seasonal inventory example
  • 0.80critical ratio (shortage ₺400, excess ₺100)
  • 1,400 unitsthe order that maximizes expected profit
  • 47%sales lift needed for an early discount to be profitable
  • 74%probability of reselling needed for a carry-over decision

At season end, compare the plan with actuals and update the scenario probabilities. If actual demand came in at 1,000, raise the probability you assign to the weak scenario next season. Evaluate each season with the question "did I make the right decision?" rather than "did I forecast demand correctly?": a good decision can produce a bad outcome; if the weak season with a 10% probability arrives, a profit of ₺260,000 does not show that the decision was wrong, only that the risk materialized. To do weekly tracking together with your other reports, see the article how to prepare a weekly management report.

Recommended readingHow to Make a Sales Forecast?

What are the most common mistakes in seasonal product inventory planning?

  1. Ordering the average demand. If the margin is high, above average is better; if it is low, below average is better.
  2. Missing lost sales. Demand on stockout days does not appear in the records.
  3. Working with a single scenario. A forecast without probabilities hides the risk.
  4. Splitting sizes evenly. Stock not distributed by sales share runs out in one size and is left over in another.
  5. Skipping mid-season checks. Even if sales velocity is low, it is noticed too late.
  6. Discounting early without doing the math. A discount that does not lift sales enough is lost profit.
  7. Making carry-over a habit. Stock carried over without calculating holding cost and the probability of selling becomes a burden.

How does NetKasam make seasonal inventory tracking easier?

  • Variant-based product structure. Separate inventory tracking for sub-breakdowns such as size and color, with unlimited variants (inventory management).
  • Stock movements report. You see incoming, outgoing and remaining stock by product and warehouse.
  • Critical stock alert. You get a notification when a product drops to the level you set during the season.
  • Multiple warehouses. You track seasonal stock across branches and warehouses together and balance it between warehouses (branch and warehouse management).
  • Sales channels via XML. You list products on online sales channels.
  • Saved reports. You save sales and inventory reports, export them to Excel and compare the plan with actuals (reports).
  • Bookkeeping is free. e-Invoice, customer and supplier accounts, inventory, cash, bank and expense management are free in every plan; see the pricing page for details.

Mini quiz: Test what you have learned

In short: Answer the 5 questions below, then compare with the answer key. 4 or 5 correct shows you have completed the training.

  1. If the purchase cost is ₺100, the selling price is ₺250 and the end-of-season price is ₺60, what are the shortage and excess stock costs and the critical ratio?
  2. If demand is 100 units (30%), 200 units (50%) or 300 units (20%), how many units do you order with this critical ratio?
  3. If you order 200 units and demand comes in at 100, what is the profit?
  4. Out of 500 units of stock, 410 sold during the season. What is the sell-through rate?
  5. A leftover product can be cleared now at ₺60; if carried over, it can sell for ₺150 next season, with a holding cost of ₺30 per unit. What is the minimum probability of selling needed to carry it over?

Answer key:

  1. Shortage cost 250 − 100 = ₺150; excess cost 100 − 60 = ₺40; critical ratio 150 ÷ 190 = 0.79.
  2. Cumulative probabilities are 30%, 80%, 100%. The first level to reach or exceed 0.79 is 80%, i.e., 200 units.
  3. 250 × 100 + 60 × 100 − 100 × 200 = 25.000 + 6.000 − 20.000 = 11.000 ₺.
  4. 410 ÷ 500 = %82.
  5. 150 × p − 30 = 60 → p = 90 ÷ 150 = 60%.

Frequently Asked Questions About Seasonal Product Inventory

How do you plan seasonal product inventory?

You set out probability-weighted demand scenarios, find the critical ratio from the cost of overstock and understock, and order the first quantity whose cumulative probability reaches this ratio.

What is the critical ratio?

It is the understock cost divided by the sum of the understock and overstock costs. If the probability of an additional unit selling is higher than this ratio, it makes sense to order that unit.

Why shouldn't I order just the average demand?

The costs of understock and overstock aren't equal. If the margin is high, understock is more expensive and ordering above the average increases expected profit; if the margin is low, ordering below it does.

How are demand scenarios determined?

You use last season's sales, a correction for out-of-stock days, this year's channel and campaign changes and the first-week sales pace of similar products.

Should I discount mid-season?

You should if the discount is expected to increase sales by more than the rate at which revenue equals undiscounted revenue. In the example, this threshold is about 47%.

Should I carry over the remaining stock or clear it?

Carrying over makes sense if the probability of the product selling again next season is higher than the break-even probability calculated from the carryover price and the holding cost; otherwise, clearing it is the better choice.

How is stock allocated across sizes?

The total order is divided according to last season's sales share by size. If there's no share distribution, the distribution of similar products is the starting point.

How does NetKasam help with seasonal inventory tracking?

It offers a variant product structure, an inventory movements report, critical stock alerts, multiple warehouses, sales channels via XML and saved reports; bookkeeping is free.

Conclusion: Calculate the critical ratio for a seasonal product

The most useful thing you can do today is to write down three numbers for the product that ties up the most stock this season: the shortage cost (selling price minus purchase cost), the excess stock cost (purchase cost minus end-of-season price) and their critical ratio. Then look at last season's sales and build five scenarios. The critical ratio will push your order quantity above or below the average; that direction is the most important piece of information for your decision.

Bookkeeping Is Now Completely Free

Manage your bookkeeping and e-Invoice operations with NetKasam without paying a thing. Customer and supplier accounts, inventory, collections and more in one panel, completely free.

Start FreeInventory Tracking

Read similar articles

19 free tools

Commission, shipping, VAT and profit calculations in your browser, no sign-up needed.

All tools