merchmix

WSSI (MFP)

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.

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 synchronized 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 synchronize 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 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 synchronize 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.