Sales Forecasting with Q360 v23.02
In this MasterClass webinar, we explore Sales Forecasting methodology and functionality within Q360 with hosts Roman Burchart and Brad Malone
This webinar was recorded on May 29, 2024. View or download slide deck here
Agenda:
- Introduction / Context | 03:08
- Discussion between Roman Burchart and Brad Malone
- What do we see most often?
- Roles | 04:33
- Sales Reps
- Sales Engineers
- Sales Managers
- Execs and Finance
- Operations
- Mock Sales Management Meeting – Immature (with Q360 demo) | 07:20
- Sales Opportunities – Key Opportunity Form Attributes | 12:30
- Interest: Sales Funnel > Sales Process
- (see also) Sales Funnel / Mark Complete
- Sale Type
- Value
- Gross Profit
- Entered Date
- Install Finish
- Close Date
- Update Reminder / Reminder Comment
- Set Reminder / Copy URL
- Source
- SIC
- RMR
- Status
- Probability
- Won / Lost (Reason, Date)
- Lag Time (not a field) – defaults to 30 days from Close (starts straight line revenue calculation based on equipment and labor forecasts)
- Interest: Sales Funnel > Sales Process
- Poll 1: How disciplined are your Sales Reps? | 14:37
- Sales Cadence | 15:50
- Key Sales Reports and Dashboards (with Q360 demo) | 17:56
- Sales Forecast | 18:20
- View Funnel | 19:26
- Sales Opp Review | 20:17
- Sales Bookings | 21:22
- Dashboard: Sales Opportunities (Q0249) | 22:36
- Mock Sales Management Meeting – Mature (with Q360 demo) | 24:08
- Poll 2: How well do Sales Managers review Sales Forecasts with their Sales Reps? | 27:42
- Sales Management to Execs – Pipeline Update Ops / Finance (with Q360 demo) | 29:37
- Labor Capacity Forecast | 30:53
- One Dashboard | 34:15
- Poll 3: How well do Sales Managers communicate future sales and their impact to Operations / Finance / General Management? | 36:05
- Q & A (see questions and answers below) | 38:15
- Poll 4: Would you like to be contacted regarding further training on Sales Forecasting in Q360? Would you like to be contacted regarding further training on Sales Reports in Q360? | 50:17
- Wrap Up and References | 50:58
Prefer to view or download this MasterClass slide deck?
Interested in learning more?
- MasterClass: Boost Sales Success with Q360 v23.02
- Release Highlights v23.02
- Contact Solutions360 Customer Care team at support@solutions360.com to schedule your upgrade to Q360 v23.02
Q & A – Answers to relevant questions submitted during the live webinar may be found below. If your team is interested in additional training options, please reach out to your Customer Care Team.
A funnel step represents a chronological “checklist” to move through each Funnel Phase – when the Phase is complete, the Probability % is updated based on the funnel setup (e.g. from 10% to 25%). Activities are more explicit in nature and are typically where notes are kept for the Sales Person and others to keep track of and have a documented history. There may be one to many activities correlated to a funnel step and some companies name their Activities to correlate to the Funnel Step, but they do not have to. So, in the case where they do correlate it will feel duplicative – but the purpose of the two items is distinct and therefore both will require completion.
There can be multiple funnels established to correlate to the Interest of the Opportunity. We typically see 4 – 6, with the most common being: Bid-build, Design-Build, Design-only, Service Agreement, and Box. Each funnel may have different phases with different probabilities per phase – a Design-Build (relationship) Opportunity will usually have greater probabilities than a Bid-Build due to the nature of the sale. Funnels usually top out at “Verbal Agreement” with a 90% probability. A Won Opportunity will be converted into a project and selected as “W” in the Won/Lost Reason drop down menu with a corresponding Won reason. A Lost Opportunity will be displayed as an “L” and an applicable reason code. Both Won and Lost Opportunities should have the “Won/Lost” date field annotated with the applicable date. The reason codes give the organization insights into past trends and help to intelligently inform future decisions.
Funnel (Opportunity) value may be adjusted directly on the Sales Forecast (within the grid), or on the opportunity itself using the EDIT function. Please also see our Help Center for additional content related to this topic.
Probability % takes into consideration the entire pipeline, including the weighted total. Typically, the funnel step you are in will drive your percentage. Each funnel step will be assigned a percentage toward opportunity completion (fully booked). Funnel configuration within Q360 is very flexible – your company may wish to track funnel steps in larger increments e.g. 10%, 25%, 50%, 90%, or may prefer to divide the funnel into much smaller steps. Generally, we recommend no more than 10 or so funnel steps – too many steps are difficult to track and it is easy to forget to close small funnel steps – this may result in inaccurate probability percentages.
This is often an organizational culture conversation. Some Sales people think optimism is helpful – most Executives want realism – especially with regards to forecasting costs and revenue. With some of the new Probability fields, a Sales Rep and Manager can have the best of both worlds – one probability driven by the funnel phases, the second a more subjective probability entered by the Sales Rep – usually geared towards a shorter timeframe.
Activities are added directly to an opportunity and are an excellent tool we can use to track communications with the customer, notable changes to requirements/needs, and other important information. We recommend creating activities after each communication with a customer – this creates a searchable historical record for later use as needed. The latest entered activity date will appear on the Sales Forecast and hovering over the red chat bubble in that column will display the comment associated with that activity. As a part of activity input in Q360, you may set an Opportunity Reminder – see our Help Center articles and core procedures for more information about both activities and reminders.
This varies by company, depending on your company’s defined milestones. Typically, any time there is a dollar value associated with something that might come to fruition, we recommend tracking that as an opportunity. An opportunity differs from a prospect when it starts to involve focused effort – at this point, you should be keeping detailed notes in Q360 and consider moving into the sales funnel.
We recommend using the Q360 “Set Reminder” function for this purpose – see this feature demonstrated in this webinar.
Yes, this may be done via the Sales Forecast. Highlight one or more opportunity rows, right click and select “Change Close Date.” You may also close each individually on the Sales Forecast by placing the grid in EDIT mode and double clicking on the Close Date you wish to change.
Sometimes. Very large items involved may warrant creating a new opportunity for this type of change order. More often than not, these will be handled as quotes against projects, but you could create a quote and link it to an opportunity. It really depends on how your company prefers to handle this.
Scroll to top