Seasonal Business Inventory Planning: How Much to Stock

For a seasonal business, the right stock level is not "as much as you can sell in a great year" but the quantity that balances two losses: the profit you miss when you run out and the money you lose on stock left over after the season. A practical method is to forecast demand from last season, set a range, use the critical ratio to decide where in that range to stock, and buy in tranches so that you can correct course. The worked example below shows the maths for a Diwali gift-box trader.

Why seasonal inventory is different

A grocery shop can reorder every week. A business selling Diwali hampers, rakhis, school uniforms, woollens, wedding wear or summer coolers often gets one or two chances to buy, and most of its annual profit comes in a few weeks. That creates three problems:

• Forecasting risk: one wrong guess affects the whole year.
• Cash strain: stock has to be paid for weeks before customers pay you.
• Markdown risk: after the season, leftover stock sells only at a discount, or not at all.

Planning therefore has two halves: how much to buy, and how to pay for it.

Step 1: Build the demand estimate

1. Start with last season's units sold, not revenue, so price changes do not distort the picture. Separate items that sold out early, because their true demand was higher than recorded sales.
2. Adjust for known changes: a new outlet, a lost corporate client, a competitor opening nearby, a shift in festival dates.
3. Apply a cautious growth figure. A 10% assumption is easier to defend than 30%.
4. Set a range, not a single number. If sales in the past three seasons were 3,700, 4,000 and 4,300 units, your uncertainty is roughly a few hundred units either way.

Step 2: Work out the cost of being wrong

If missing a sale costs more than being left with a unit, stock above your average estimate. If leftover stock is very costly, for example perishable sweets or fashion items, stock below it.

Worked example: Diwali gift boxes

The figures are illustrative. A Delhi dry-fruit trader sells corporate and retail Diwali gift boxes.

• Last season's sales: 4,000 boxes; this year's estimate with 10% growth: 4,400 boxes
• Uncertainty: in a typical year actual demand lands within about ±600 boxes of the estimate (one standard deviation)
• Cost per box (excluding GST): ₹600
• Selling price (excluding GST): ₹950
• Post-Diwali clearance price for leftover boxes: ₹400

Step 1 — underage cost. ₹950 − ₹600 = ₹350 lost on each missed sale.

Step 2 — overage cost. ₹600 − ₹400 = ₹200 lost on each leftover box.

Step 3 — critical ratio. ₹350 ÷ (₹350 + ₹200) = 0.636. The trader should stock enough to meet demand about 64% of the time.

Step 4 — convert to a quantity. For a normal distribution, the 63.6th percentile is about 0.35 standard deviations above the average. Stock = 4,400 + 0.35 × 600 = 4,610, rounded to 4,600 boxes.

Testing the decision

Gross profit under three stock levels and three demand outcomes, using profit = ₹950 × boxes sold at full price + ₹400 × leftover boxes − ₹600 × boxes bought:

Check the middle cell: 4,400 × ₹950 = ₹41,80,000 plus 200 × ₹400 = ₹80,000, total revenue ₹42,60,000, minus cost 4,600 × ₹600 = ₹27,60,000, gives ₹15,00,000.

The 4,600 row is never the worst outcome and does best in the most likely case. Buying 5,200 only pays off in a boom year; buying 4,000 caps profit even when demand is strong.

Step 3: Buy in tranches

Tranche buying reduces the cost of a wrong forecast.

1. First order (about 60%): 2,760 boxes, placed early when suppliers have capacity and prices are firm.
2. Checkpoint: three to four weeks before the festival, compare corporate orders booked and early retail sales with the same point last year.
3. Second order (remaining 40%, adjustable): about 1,840 boxes if sales are on track, fewer if they are behind, more if ahead and the supplier can deliver in time.

Agree the second-tranche lead time and price with your supplier in advance. The ability to reorder is worth paying a little extra per unit.

Step 4: Plan the cash

Buying 4,600 boxes at ₹600 needs ₹27,60,000. Most of it is paid before much revenue arrives, and corporate buyers may take 30 days or more to pay.

Illustrative funding plan

• Own funds kept aside from the year: ₹10,00,000
• Cash credit or overdraft drawn for the peak: ₹17,60,000
• Interest at an illustrative 11% a year for 60 days: ₹17,60,000 × 11% × 60 ÷ 365 = ₹31,824.66

At the 4,400-box demand outcome, gross profit after this interest is ₹15,00,000 − ₹31,824.66 = ₹14,68,175.34, before rent, staff and other overheads.

A seasonal peak is exactly what a working capital limit is designed for. A term loan would leave you paying interest for years on money you need for two months; see working capital loan vs term loan. Corporate dues can be pulled forward through invoice discounting if needed.

The season stretches your cash conversion cycle sharply for a few weeks, so build a week-by-week cash forecast, not just a monthly one.

Step 5: Decide clearance before the season

The overage cost in the example assumed leftovers sell at ₹400. That only holds if you have a plan: bundle offers in the week after Diwali, bulk sale to another trader or institutional buyer, or repacking into smaller packs. For perishables, check the shelf life; if boxes cannot be sold after the season, the salvage value is close to zero, the overage cost rises to ₹600, the critical ratio falls to 350 ÷ 950 = 0.368, and you should stock below your average estimate.

Managing the off-season

Seasonal businesses also need to survive the quiet months. Keep fixed costs flexible, pay yourself a steady monthly draw from a reserve rather than spending the peak profit, and set aside GST and advance tax as you earn. Our guide on budgeting with irregular income covers the owner's side of this.

Common mistakes

• Forecasting from revenue instead of units when prices have changed.
• Ignoring items that sold out early, which hides real demand.
• Buying everything in one go to get a slightly lower unit price.
• Not agreeing a clearance channel in advance.
• Funding stock with expensive short-term personal loans or credit cards.
• Counting GST-inclusive prices as revenue; use GST-exclusive figures for margins.

Key takeaways

• Seasonal stock should balance the profit lost on missed sales against the loss on leftover stock.
• Critical ratio = underage cost ÷ (underage + overage cost); in the illustrative example it was 0.636, pointing to about 4,600 boxes against a 4,400 estimate.
• Buy in tranches with a checkpoint so a wrong forecast can be corrected.
• Fund the peak with own funds and a working capital limit; 60 days of ₹17.6 lakh at 11% cost about ₹31,825 in the example.
• Fix the clearance plan before the season; perishable stock calls for buying below the average estimate.