Sales Forecasting Agent
Forecasts revenue from pipeline stage and velocity.
- Industry
- Hotel
- Department
- Sales
- Team
- Deal Conversion
- Kind
- Decision-maker
- Approver
- Revenue Manager
- Code
- SAL-17
It forecasts group and event revenue by month from the pipeline stages (enquiry, tentative, definite) and actualisation history, including rooms picked up against blocks. It submits the forecast to the revenue meeting.
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 sales and catering system: the pipeline and pickup history..
- 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 Revenue Manager with its reasoning before anything goes out.
- 07Acts
Once approved, it acts in the revenue management system: it submits the group forecast. and records what was done.
What it works with
Your knowledge, your systems, your people.
Knows
The forecasting method: stage probabilities, pickup history, wash factors and the forecast calendar.
Reads from
the sales and catering system: the pipeline and pickup history.
Acts in
the revenue management system: it submits the group forecast.
Hands back
An object with months (a list, each with month, room_nights, room_revenue_usd, fb_revenue_usd), change_percent and notes.
Asks a person when
The forecast moves 10 percent or more.
Settings
Your limits, set by your managers.
| Setting | Default | What it controls |
|---|---|---|
| Stage probabilities | enquiry 10, prospect 25, tentative 50, definite 95 | Comma-separated stage and percent. |
| Expected wash on blocks (%) | 12 | Rooms expected to drop from blocks. |
| Flag tentatives past option by (days) | 3 | These are flagged. |
| Variance alert (%) | 10 | Changes this large are explained. |
Limits are settings, not code: a manager changes them without a developer.
Rules it always follows
- Weight by enquiry 10, prospect 25, tentative 50, definite 95.
- Apply 12 percent wash to definite blocks.
- Flag tentatives 3 days past option.
- Explain changes of 10 percent from last forecast.
See the Sales 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.