Financial Forecasting Agent
Forecasts revenue, costs and profitability.
- Industry
- Retail
- Department
- Finance
- Team
- Planning and Compliance
- Kind
- Decision-maker
- Approver
- Finance Controller
- Code
- FIN-10
It forecasts sales, gross margin, costs and profit by channel and category for the rest of the year from trading to date, the promotion calendar, the store opening plan and the season's markdown plan. It proposes the reforecast and shows what each assumption is worth.
How it works
7 steps, and a person signs off before step 7.
- 01Looks it up
Finds the record the request is about in the merchandise planning system: trading to date, the promotion calendar, the markdown plan and the store opening plan, with costs 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.
- 04Forecasts, when it decides
Projects what each option will cost or return before it recommends one.
- 05Works it through
Prepares the draft, match, recommendation or reply, with its sources.
- 06Asks a person
Hands the work to Finance Controller with its reasoning before anything goes out.
- 07Acts
Once approved, it acts in the ERP's budgeting module: it saves the forecast as a draft version for review. and records what was done.
What it works with
Your knowledge, your systems, your people.
Knows
The forecasting model: the seasonal curves by category, the promotion lift and markdown assumptions, the store opening and closure plan, the wage and delivery cost drivers, and the reforecast process.
Reads from
the merchandise planning system: trading to date, the promotion calendar, the markdown plan and the store opening plan, with costs from the ERP's general ledger.
Acts in
the ERP's budgeting module: it saves the forecast as a draft version for review.
Hands back
An object with by_month (a list of month, sales, gross_margin, costs and profit), by_channel (a list), assumptions (a list of assumption, value and profit_effect), full_year_profit and change_vs_last_forecast.
Asks a person when
The forecast changes full-year profit by more than 3 percent, or changes an assumption set by the board.
Settings
Your limits, set by your managers.
| Setting | Default | What it controls |
|---|---|---|
| Like-for-like growth assumption (%) | 2 | The like-for-like sales growth used unless trading says otherwise. |
| Weeks of trading that shift the forecast | 8 | The last this many weeks of trading set the run rate. |
| Markdown as a share of sales (%) | 12 | The markdown cost assumed unless the markdown plan says otherwise. |
| Profit change that triggers a reforecast (%) | 3 | A forecast profit change above this is proposed as a formal reforecast. |
Limits are settings, not code: a manager changes them without a developer.
Rules it always follows
- Set the run rate from the last 8 weeks, adjusted for seasonality and the promotion calendar.
- Use 2 percent like-for-like growth and 12 percent markdown unless the evidence supports a change, and say when it does.
- Add stores from their opening date and remove closed stores from their closing date.
- Show the profit effect of each assumption so owners can see what drives the change.
- A forecast profit change of more than 3 percent is proposed as a formal reforecast.
See the Financial Forecasting Agent agent on your own work.
We’ll run it on a sample of your work and show you what your approver would see.