Aligning Top-Down Financial Plans with Bottom-Up Item Plans in Apparel

The misalignment that costs millions

Top-down planning starts with financial targets: revenue by period, margin goals, and OTB budgets. Bottom-up planning starts with product decisions: which styles, how many units, what price points, what delivery dates.

In a well-run planning process, these two approaches converge — the sum of all bottom-up product decisions fits within the top-down financial framework. In reality, they almost never do on the first pass.

The CEO targets $8M for the season. The planner builds an OTB budget of $3.2M in receipt cost to support that target at 60% margin. The buying team builds style-level plans that total $3.9M in receipt cost — 22% over budget. Nobody catches the gap until the orders are placed. The result: overbuying, cash strain, and excess inventory.

This is the single most common planning failure in apparel brands between $2M and $50M in revenue.

Why the gap exists

Optimism bias in bottom-up planning

When buyers plan at the style level, every style looks like a winner. "This one will sell through at 75%." "This category is trending." "The fabric is amazing." Optimism is a feature of good merchandising instinct — but it systematically inflates the plan.

Revenue targets set without OTB input

Many brands set revenue targets based on growth goals ("We want to grow 30% this year") without checking whether the available capital, vendor terms, and warehouse capacity can support that growth. The financial target becomes a number that merchandising has to hit — whether or not the underlying plan can actually deliver.

No formal reconciliation checkpoint

Most growing brands lack a formal step where someone says: "The sum of all style-level plans is $3.9M, but OTB is $3.2M. We need to cut $700K." Without this checkpoint, the bottom-up plan becomes the actual plan — and the overbuying is baked in.

The reconciliation process

Step 1: Set top-down targets first

Start with the financial framework:

| Metric | Formula | Example | |--------|---------|---------| | Target net sales | Strategic goal | $8,000,000 | | Target IMU | Pricing strategy | 62% | | Receipt cost budget | Net sales × (1 - IMU) | $3,040,000 | | Markdown allowance | Historical rate × net sales | $800,000 (10%) | | MMU target | After markdowns | 55% | | OTB available | Receipt budget - on-order | $3,040,000 |

This is your financial ceiling. Everything below must fit within it.

Step 2: Build bottom-up by category

Break OTB into category-level budgets based on historical contribution and strategic direction:

| Category | Revenue contribution | OTB allocation | |----------|---------------------|---------------| | Women's tops | 35% | $1,064,000 | | Women's bottoms | 25% | $760,000 | | Men's | 20% | $608,000 | | Outerwear | 12% | $364,800 | | Accessories | 8% | $243,200 |

Step 3: Buyers plan within category budgets

Each buyer plans styles, colors, sizes, and quantities within their allocated OTB. This is the bottom-up component: real product decisions constrained by real financial guardrails.

Step 4: Reconcile

Compare the sum of all bottom-up category plans against the top-down OTB. Three outcomes:

Under budget: Rare but healthy. You have open OTB to chase winners in-season or add opportunistic buys. Resist the urge to fill the budget with marginal styles.

On budget (within 3%): Ideal. Proceed to buy placement.

Over budget: Most common. You need to cut. The cutting process should be systematic:

1. →Cut the lowest-confidence styles first — new categories, unproven silhouettes, fashion-forward bets
2. →Reduce depth on mid-confidence styles — buy 200 units instead of 300
3. →Protect core performers — styles with proven sell-through get full planned depth
4. →Never cut equally across the board — "everyone cuts 15%" penalizes strong categories and protects weak ones

Step 5: Lock and track

Once the plan reconciles, lock it. Track actual receipts against plan weekly. Any deviation (late deliveries, cancellations, added orders) adjusts the OTB balance.

Middle-out: the hybrid approach

Some brands use a third approach — middle-out planning — where category managers set category-level plans that are informed by both financial targets and product-level knowledge, then submit those plans upward for financial reconciliation and downward for style-level detail.

This works well when you have experienced category managers who understand both the financial framework and the product landscape. For smaller brands without dedicated category managers, the two-step top-down/bottom-up approach is more practical.

Where this breaks in spreadsheets

The reconciliation process requires:

• →A top-down OTB model (typically one spreadsheet)
• →Bottom-up style plans by category (typically separate files per buyer)
• →A reconciliation view that compares the two

In spreadsheets, this reconciliation is a manual process:

1. →Each buyer emails their plan
2. →Someone consolidates the plans into one view
3. →The consolidated total is compared to OTB
4. →Cuts are negotiated in a meeting
5. →Buyers update their files
6. →Someone re-consolidates to verify the cuts landed correctly

This cycle takes 3–5 days. In a connected planning system, it's immediate — the sum of all style-level plans is always visible against the OTB ceiling, and the system flags the variance in real time.

Further reading

• →What Is Open-to-Buy Planning? — the financial framework that sets the ceiling
• →Integrated Business Planning for Retail — connecting finance, merchandising, and operations
• →Scenario Planning for Retail — modeling different financial scenarios
• →The Excess Inventory Crisis — what happens when reconciliation fails
• →Mastering Apparel Operations — the full operational chain from plan to execution