- Industry
- Retail
- Department
- Finance
- Team
- Planning and Compliance
- Kind
- Investigator
- Approver
- Finance Controller
- Code
- FIN-09
It builds store, channel and category budgets from the sales plan, margin plan and cost drivers, and tracks actuals against them weekly. It explains each material variance, separating like-for-like sales, new or closed stores, markdowns, shrink, wage hours and one-offs. **The problem it solves:** Why actual sales, margin or costs differ from budget in the period, by driver.
How it works
6 steps, and a person signs off before step 6.
- 01Looks it up
Finds the record the request is about in the merchandise planning system: the sales and margin plan with actuals by store, channel and category, and the cost actuals from the ERP's general ledger..
- 02Reads the request
Works out what is being asked and what a complete answer needs.
- 03Checks the facts
Checks figures, dates and rules against the source records, not from memory.
- 04Works it through
Weighs competing explanations against the evidence and shows which one holds up.
- 05Asks a person
Hands the work to Finance Controller with its reasoning before anything goes out.
- 06Acts
Once approved, it acts in the ERP's budgeting module: it records the variance commentary against each line. and records what was done.
What it works with
Your knowledge, your systems, your people.
Knows
The budget model: the sales and margin plan by store, channel and category, the cost drivers (wage hours per sales, rent, energy, delivery cost per order), the store openings and closures, and the variance materiality rules.
Reads from
the merchandise planning system: the sales and margin plan with actuals by store, channel and category, and the cost actuals from the ERP's general ledger.
Acts in
the ERP's budgeting module: it records the variance commentary against each line.
Hands back
An object with lines (a list of line, budget, actual, variance and variance_percent), explanations (a list of line, driver, amount, evidence and confidence) and actions (a list).
Asks a person when
The analysis points to a store, region or category owner's decision, or proposes a reforecast.
Settings
Your limits, set by your managers.
| Setting | Default | What it controls |
|---|---|---|
| Material variance (%) | 5 | A line this far from budget is explained. |
| Material variance (USD) | 25000 | A line this far from budget is explained, whatever the percentage. |
| Split like-for-like from new and closed stores | On | When on, sales variances are split between like-for-like stores and stores opened or closed. |
Limits are settings, not code: a manager changes them without a developer.
Rules it always follows
- Explain any line off budget by 5 percent or 25000, whichever is hit first.
- When on is true, split sales variances between like-for-like stores and stores opened, closed or refitted.
- Split margin variances into sales mix, markdown, shrink and cost price.
- Weigh at least two explanations for each variance and say what evidence supports each; separate timing from real changes.
- Never re-budget to close a variance; propose a reforecast to the forecasting agent instead.
See the Budgeting Agent agent on your own work.
We’ll run it on a sample of your work and show you what your approver would see.