merchmix

For planners

Rebuilding the plan is no longer necessary.

Your skill is knowing what to change. core keeps sales, stock, intake and margin on the same MFP (WSSI) grid, freeing you to challenge the assumptions.

CORE · CONTINUITY PLANNING

One style. The whole week.

Arizona sandal · FY27 · W33–W38 · Illustrative plan

W33–W36 actuals496 units
Against forecast+16 units
W37–W38 outlook290 units
Weekly stock, sales & intakeActuals through W36
MeasureW33ActualW34ActualW35ActualW36ActualW37ForecastW38Forecast
Sales · original forecast110120120130140150
Sales · actual112118128138——
Sales · working forecast————140150
Variance · units+2-2+8+8——
Intake · units0240002400
Closing stock · units848970842704804654

PLANNING NOTE · BLACK

Actuals are 16 units above forecast. Keep the incoming delivery in view before adding depth.

Review the assumption, then keep the snapshot.

Closing stock = opening + intake − sales. Forecasts use whole units; other stock movements are zero. Demo snapshots last until reload.

Enough of reconciling separate files.

The WSSI story behind merchmix included 10 hours a week rebuilding the spreadsheet, before any trading call.

Before

You assemble the actuals before the meeting. You reconcile buying against a separate OTB sheet.

After

You review the actuals in the weekly grid. You check buying against the live OTB position.

Signed off needn't mean typed again.

Approvals, commitments and quantities should reach your next task without another reconciliation.

  1. Budget changes

    Re-keying the signed-off position means checking totals again. Your approved budget flows into the weekly plan without that second entry.

  2. Buying commitments

    Reconciling what buying committed comes too late. Orders count against OTB when raised; the remaining budget is checked before approval.

  3. Size curves

    Deferred analysis leaves yesterday's mix in the next buy. Quantities by size and store reflect sales and stock cover; approved recommendations enter your range plan.

Sizing takes less out of the week.

“You have no idea how much time you've saved me. At least 7 or 8 hours a week.”

A planning lead at a fashion retailer, on size analysis.

Corrections need fewer manual steps.

Spotting the shortfall starts another job. yukti proposes and executes a rebalance, raises replenishment and creates purchase orders, taking the follow-through off your desk.

Explaining discrepancies can leave the agenda.

Your buyer needs the remaining spend; your CEO needs performance against commitment. Both use the same position, without a discussion about whose spreadsheet is current.

Less calculation leaves room for judgment.

If the machine does the math, what remains? You set assumptions, challenge forecasts and approve corrections or let them run. Recovered time goes into choosing which commercial risks are worth taking.

Questions, answered.

Can I change the forecast myself?

Yes. Edit the grid at department, category or subcategory level. Compare or restore earlier versions without losing the previous position.

What happens when buying raises a PO?

It counts against OTB when raised. The remaining budget is checked before approval.

Do I still have to assemble the trade pack?

Performance against budget and last year, best and worst sellers, and actions arrive in your inbox every Monday, compiled from the weekly grid.

Do I have to replace everything together?

No. Start with core or core plus and add the wider platform later.

No commitment before testing the fit.

Free 6-week POC on your own data, no contract. Test your budget, weekly grid and first trade pack. Start with a 1-hour demo with sales and product.

Updated 15 September 2026