Sales Volume Forecasting Agent
Forecasts sales volumes and margin from term contracts, nominations and the pipeline.
- Industry
- Oil & Gas
- Department
- Sales
- Team
- Deal Conversion
- Kind
- Decision-maker
- Approver
- Head of Trading
- Code
- SAL-17
It forecasts sales volume and margin by product and month from term contract volumes, buyer nominations, spot pipeline by stage and seasonality, and sets it against supply from the refinery and terminals. It decides the commit forecast and submits it to the trading and supply plan.
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 trading and risk management system: term contract volumes, buyer nominations, the spot pipeline and the supply plan for the period..
- 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 Head of Trading with its reasoning before anything goes out.
- 07Acts
Once approved, it acts in the trading and risk management system: it submits the approved sales forecast to the supply plan. and records what was done.
What it works with
Your knowledge, your systems, your people.
Knows
The forecasting method: stage probabilities for spot deals, nomination accuracy history, seasonality by product, margin assumptions and the supply plan interface.
Reads from
the trading and risk management system: term contract volumes, buyer nominations, the spot pipeline and the supply plan for the period.
Acts in
the trading and risk management system: it submits the approved sales forecast to the supply plan.
Hands back
An object with by_product (a list, each with product, term_volume, spot_commit, best_case, margin_usd and supply_available), total_commit, variance_to_submitted_percent, slipping (a list) and assumptions (a list).
Asks a person when
Its commit differs from the leads' submitted commit by more than 10 percent, the forecast exceeds available supply, or it is submitted for a period already in the supply plan.
Settings
Your limits, set by your managers.
| Setting | Default | What it controls |
|---|---|---|
| Stage probabilities | offer 20, negotiation 50, agreed 80, contracted 100 | Comma-separated stage and percent. |
| Probability that counts as commit (%) | 80 | Deals at or above this count. |
| Lookback (days) | 180 | For conversion and nomination accuracy. |
| Slip flag (days) | 14 | Deals slipping this much are flagged. |
| Variance that needs the approver (%) | 10 | Against the leads' commit. |
Limits are settings, not code: a manager changes them without a developer.
Rules it always follows
- Term volumes are adjusted by each buyer's nomination accuracy over 180 days; spot deals use offer 20, negotiation 50, agreed 80, contracted 100.
- Commit counts deals at 80 percent or more.
- The forecast never exceeds supply available from the refinery and terminals; any gap is named.
- Flag deals slipping 14 days; a variance of 10 percent from the leads' commit needs the Head of Trading.
See the Sales Volume 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.