merchmix.

BUDGET BUILDER

Set the number once, and hold the whole year to it.

Budgets, scenarios and the marketing spend that follows them, built in one workspace and synced into the weekly plan. Nothing gets rekeyed, and nothing drifts.

Budget master files list showing versioned budgets across four financial years.

BUDGET MASTER FILES

Know which budget
is the real one.

Most retailers have four versions of the budget and no agreement on which is current. Master files hold one plan per financial year, versioned, with the status on the front of the card. Approved is approved. Superseded is visibly superseded. Scenario work sits underneath the master it came from instead of in someone's downloads folder.

One master per year

Corporate allocation plans and structures in a single list.

Status on the card

Draft, approved and superseded, visible before anyone opens anything.

Versions underneath

Every version tied to the master it came from.

Grid or table

Browse the plans or work the list.

Budget Builder workspace showing a full year weekly plan rolled up across the product hierarchy.

BUDGET WORKSPACE

Plan at the level you think,
roll up to the level you report.

The budget grid runs the full hierarchy, from total business down through department, category and sub-category. Set a number anywhere and the rollups resolve around it. This is where merchandise financial planning starts, so the open to buy position every downstream decision reads from is set here rather than reconstructed later. Switch the period without exporting, and change what you are looking at without leaving the grid.

Full hierarchy

Total to department to category to sub-category, rolled up live.

Four period views

Week, month, quarter and half on one grid.

Six measures

Sales, units, ASP, growth, profit and cost.

Submit for review

The plan goes into approval rather than into an email, and the approved version is the one that syncs.

Profit Workspace showing scenario levers and the resulting profit against the base plan.

PROFIT WORKSPACE

Ask what the plan is worth
before you commit to it.

Six levers sit against the plan: volume, price, cost, markdown depth, price elasticity and mix. Move any of them and the scenario profit resolves immediately against the base, with the gap in gross profit shown in cash and percent. Set a profit goal and the workspace distributes it across weeks and categories for you, or set the cells yourself and let the goal solve around what you fixed.

Six levers

Volume, ASP, COGS, markdown, elasticity and margin mix.

Scenario against base

The variance in cash and percent, live as you move.

Auto-solve

Distribute a profit goal across weeks and categories.

Populate the grid

Take the scenario into the plan when it is right.

Scenario sandboxes showing concurrent modelling branches forked from a budget.

SCENARIO SANDBOXES

Model the downside
without touching the plan.

Fork the current allocation into an isolated track, name it for what it tests, and work it without any risk to the approved number. Run several at once. Every branch stays attached to the master it came from, so the comparison is like for like rather than two spreadsheets that started from different places.

Fork the matrix

Clone the current allocation into its own workspace.

Named tracks

A sandbox per question, not a file per person.

Concurrent branches

Several scenarios open at the same time.

Tied to the master

Every branch traceable to its source plan.

Merchmix Intelligence reading a budget, with an executive overview and insights backed by evidence and assignable actions.

MERCHMIX INTELLIGENCE

Get the plan read
before the board reads it.

Merchmix Intelligence reviews the budget and writes the executive overview: what the plan assumes, where the growth sits, and what has to be true for it to land. Findings come back as signals, insights, actions and risks, each tagged to the team that owns it and the moment it matters. The verdict moves with the plan. The same workspace has returned on plan for one budget and conservative for another.

Executive overview

The plan summarised in prose, not a chart to interpret.

Signals, insights, actions, risks

Counted, and grouped by where the detail sits.

Tagged by owner and timing

Planning, buying, finance and marketing, before sign-off or this month.

Evidence underneath

Every insight opens onto the numbers behind it and the recommended actions.

Marketing Budget workspace showing weekly spend derived from the approved sales budget across the product hierarchy.

MARKETING BUDGET

Build the marketing budget
out of the sales budget, not beside it.

The marketing budget derives from the approved sales budget, so spend is planned against the same numbers the business is committed to. Work it derived or set targets directly, at department, category or sub-category grain, on a weekly grid with the trading calendar laid over it so the money lands where the events are.

Derived from approved sales

One source, no second set of numbers.

Three grains

Department, category or sub-category.

Trading calendar overlaid

Spend planned around the events, not after them.

Marketing to sales ratio

The relationship visible while you plan it.

Every budget rolls up cleanly, and once leadership approves, it's locked. The board sees one version of the truth.

Melanie Pells

Senior Marketer, Sydney, Australia

Melanie Pells on setting one budget the whole business works from

One sync, and the whole plan inherits the number.

The approved budget syncs straight into WSSI. From there it reaches everything else, because WSSI is the source the rest of the platform reads from. The open to buy position, the seasonal forecast, continuity, assortment planning, allocation, planogram and the trade reviews all work off the same committed number, so nobody rebuilds it and nobody argues about whose version is right.

Plan the spend, then watch it against the plan.

Promo Calendar

Promotion dates land where planning and buying can see them, so the range and the intake are built around them.

Marketing Plan

The approved budget becomes the channel allocation across performance, owned, earned and brand.

Spend tracking

Actuals against plan on the same weekly grid, pulled in through connectors rather than keyed.

Sales against spend

Spend, orders, revenue and variance in one view, because the marketing budget and the sales budget came from the same place.

Everything you need to know about budget planning

Merchandise financial planning sets a retailer's sales, stock, intake and margin targets for a season before the range is built, usually at department and category level. It produces the open to buy position that governs how much can be committed, and every downstream decision, from range planning to allocation to markdown, reads from it. Done in spreadsheets it tends to drift, because the version the buyer is working from and the version finance signed off stop matching within a few weeks. Done in one system it holds, because there is only one plan and everything downstream inherits it rather than restating it.

Onboard Merchmix for your budget planning.

A six week proof of concept on your own data, in a private sandbox, with onboarding included.