merchmix

MFP (WSSI)

WSSI stays current through the week.

Sales, stock, intake and OTB update in seconds. Adjust assumptions, preview the financial effect and commit approved changes without losing access to earlier versions.

A workbook can outgrow its workstation.

Most fashion teams run MFP (WSSI) in a spreadsheet until the seasons, categories and stores outgrow one file. The file behind merchmix carried a substantial trading position. Keeping it usable became a job itself.

65 MB
File size
45
Tabs
3 years
Historical data
$100M
Budget
10 hours
A week rebuilding

Fiscal periods anchor the editable grid.

Weekly planning follows your retail calendar. Scope, measures and assumptions stay together through the preview.

  1. Scope

    Select brand, category, subcategory, store and financial year before reviewing the position.

  2. Weekly measures

    Review sales, stock, intake, actuals, budget and OTB together, with the financial context beside your assumptions.

  3. Style scenarios

    Select a scenario for each style within OTB, markdown and transfer capacity.

  4. Preview

    Adjust assumptions and inspect the resulting grid before committing the revision.

    CORE · WSSI

    One category. Every week.

    Scenario preview

    Lakefashion · Blouses · All stores · FY2027

    Six-week sales$108,000
    Closing stock · W111,850 units
    Cover · W117.1 weeks
    MeasureW06ActualW07ActualW08ForecastW09ForecastW10ForecastW11Forecast
    Sales budgetAUD$14,400$16,000$17,600$19,200$20,000$20,800
    Sales actual / forecastAUD$14,400$16,000$17,600$19,200$20,000$20,800
    Sales unitsUnits180200220240250260
    Opening stockUnits1,8001,8201,8201,9001,8601,910
    IntakeUnits200200300200300200
    Closing stockUnits1,8201,8201,9001,8601,9101,850
    Weeks of coverWeeks10.19.18.67.87.67.1
    Gross margin%60.0%60.0%60.0%60.0%60.0%60.0%

    W06–W07 actuals stay fixed. Sales +10% adjusts W08–W11 only; intake stays unchanged. Cover = closing stock ÷ that week’s sales units.

    Illustrative data · AUD · $80 selling price and $32 unit cost

  5. Commit

    Commit the approved planning changes. Examining a scenario and making it the trading position are separate steps.

Versions

Earlier versions remain part of the document.

Compare or restore a previous WSSI before committing. Revised budgets can be approved and synchronised into the grid.

CORE · COMMIT HISTORY

The decision stays on record.

Example history

Lakefashion · Blouses · FY2027 · September

Intake rephased

Deferred $12,000 of September intake into October to match supplier timing.

MeasureV02V03
Sales forecast$107,333$115,920
Intake budget$112,000$112,000
Open to buy$18,400$18,400

Compare the selected version with V03. Restoring creates a draft; the original versions remain in history.

Select a version to inspect its values and decision note.

Illustrative versions and reviewers · no live document changes

Scope + author + decision

Financial exposure accompanies the proposed correction.

yukti presents a rebalance with affected products and forecast context. Simulate its estimated effect, approve execution and inspect the recorded outcome.

Inputs and constraints

Budgets and actuals meet inside WSSI.

Approved targets synchronise from Budget Builder. Demand baselines give weekly and monthly forecast context. OTB and markdown capacity constrain style scenarios.

Within core, WSSI retains its working history.

Scenarios, previews, restoration and approved commits share a merchandise planning workspace. This is the product behind the weekly task.

Questions, answered.

Can merchmix replace our WSSI spreadsheet?

Yes. It plans weekly sales, stock and intake, works out OTB, and tracks actuals against plan every week, without a file to rebuild each season.

Does it work for fashion seasons, categories and sizes?

Yes. Plan by season, then by category down to subcategory and store, week by week. Size curves sit alongside, so the intake you plan arrives in the sizes that sell.

What happens to our ERP?

It stays the system of record. merchmix reads from it, and anything written back is approved first and logged.

How long does the move take?

Live in 12 to 15 weeks. Start with a free six-week proof of concept on your own data, no contract.

Can I recover last week's version?

Yes. Compare versions or restore an earlier WSSI, then commit the approved planning changes.

What if the budget moves after approval?

Budget scenarios support revisions and controlled reopening. Approve the chosen version and synchronise it into WSSI.

Does phasing survive a mid-season reforecast?

Yes. Completed trading weeks retain locked actuals, while future weekly phasing can be preserved, re-curved, or recalculated when top-line projections shift.

How do markdowns reconcile with the other lines?

Planned markdowns dynamically update forecast sales velocity, closing stock valuation, and gross margin in the WSSI grid, keeping open-to-buy budgets aligned.

Testing includes an actual trading worksheet.

Free 6-week POC on your own data, no contract. Revise an assumption, compare a version and inspect the committed result. Start with a 1-hour demo with sales and product.

Updated 27 October 2026