Tag Archives: forecast

Spotlight of the Week: Applying Advanced Filters on Your Data

Wednesday, March 31st, 2010

Update forecast screen to show data on single pageOne of the more popular features in the Right90 Next Generation Forecaster is the ability to use advanced filtering beyond just searching and browsing your hierarchies. How can filtering help you? By getting you only the data you want to see on your forecast view. As an example, many forecasters and managers want a view of the forecast for a specific time horizon and to filter out any opportunities that have no revenue impact for that time frame.

To take advantage of advanced filtering, first update the forecast screen so that you have all your rows of data on one page. (Page size options are dynamically determined in Right90 and can be selected under the “Update” screen.)

If you find you still have too much data to fit on one page, you can reduce the amount of data you’re viewing three ways:

  1. Narrow your search — by selecting a particular person’s forecast or a certain geography
  2. Reduce the length of time that you’re viewing — from 2 years of forecast to 6 months, or less
  3. Remove the quantity, price or revenue columns – if they are not needed.

Apply a data filter to your forecastOnce you have all the data on one page as you like it, select the “Filter” option in your menu across the top. Fill out the pop up screen (including the details under “More Options”) and hit “Apply” in the bottom right corner.

After applying your advanced filters, you can even take it one step further – group your data to view an even more manageable set of data on your screen.

Spotlight of the Week: A Simple Way to Evaluate the Quality of Your Forecast

Wednesday, March 24th, 2010

Measuring forecast accuracy is one of the most popular ways to measure the quality of your forecast.  However, we’d like to suggest some other simple but very valuable analyses you can do to help build confidence in your forecast data.  At a minimum, knowing when the forecast was last updated will give you an indication as to how good the data is.  We’re not talking about the date the forecast was “due” to be updated by the sales team but rather the last time a particular opportunity changed. This is one way our customers determine how complete their forecast is.

On the Right90 Forecast screen, there are two key “viewable” fields that help you understand if your forecast is complete:

  • “Last forecasted date” field tells you when the quantity or price for that particular line item was last forecasted
  • “Last updated field” tells you when anything else associated with that line item was updated (i.e. the stage of the opportunity, market application, or other custom fields you have set up).

Before analyzing “last forecasted data” results, we have two more tips for streamlining your view and maximizing the functionality available in the Next Generation Forecaster. First, when you have your forecast data on one page in Right90, filter out zero revenue rows to reduce the amount of unnecessary data. Try filtering revenue greater than zero for just the current month. Then, sort by clicking on the “last forecasted date” column header to bring the older items to the top so that you can focus on items that may not be up to date.

Obtain a quality sales forecast using filtersIn the example to the right, you can clearly see that quantity and price forecast updates were made in January 2010.

As both a forecaster and a manager, reviewing when the forecast was last changed helps you quickly spot areas that may need a second look.  Catching outdated information along the way will help build confidence in your forecast data and improve your forecast accuracy.  Have you used these techniques to evaluate the quality of your forecast, or do you have another favorite technique to share?

Spotlight of the Week: Managing to the Exceptions

Tuesday, February 9th, 2010

Many forecast processes and systems lack the ability to view data at a high level and then drill down and diagnose specific problem areas in a way that lets you manage exceptions by customers, products or regions of your business.

The Right90 Analysis screen does just that through the use of a “breakdown panel”. To access the “breakdown panel”, just click on any numeric value on your main Right90 Analysis screen.

How can this help you save time? If a particular customer, product or region looks out of line, then just click on the number to get more detailed insight. You can continue to drill down to the lowest level of detail associated with the data available to the Right90 application.

Managing Exceptions in a Sales Forecast

Use Right90 to manage exceptions in your sales forecast.

Let’s look at the example to the right where we’re comparing the current forecast to actuals or shipments in Right90 for the year. You can quickly see that the shipments are 18% less than the forecast for the Americas region.

If you click on the total Americas revenue number listed in the table, the breakdown panel appears letting you know which areas within that region, product families and types of customers are responsible for the difference.

If you drill down yet another level on the customer type, then you can identify which specific accounts have contributed to the shortfall.

So, looking at higher level data and only drilling down to the detail when you need the specifics allows you to save time and focus on just the exceptions!

Right90 and the Sales 2.0 Alliance

Thursday, February 4th, 2010
Right90 Selcted for Sales 2.0 Alliance

Right90 is a founding member of the Sales 2.0 Alliance

We are excited to be a founding member of the Sales 2.0 Alliance. More and more, we are seeing market-leading companies make smart investments in technology and services to maximize sales performance and sales achievement. With Sales 2.0, we and our partners have a comprehensive suite of applications that give sales and marketing executives the power to get more done with the resources they have, get better visibility into how the sales engine is performing, manage risk and have a systematic way to measure and improve overall sales performance.

The Sales 2.0 collection of applications build on the foundation of today’s ubiquitous CRM systems to focus on the key business processes that drive higher revenue production, better margins, more revenue visibility and predictability that companies need and want to have best-in-class sales execution. Our goal is to equip sales people, sales executives and marketing departments with everything they need to deliver the best possible sales results. Working together as the leaders in the sales and marketing space, we (the members of the Sales 2.0 Alliance) are focused on helping sales departments be the best they can be, using state-of-the-art technology to minimize the time they spend on overhead and maximize the time they spend being effective and booking deals.

Sales 2.0 represents a focus on helping companies achieve best-in-class sales results. We at Right90 have always focused on maximizing the business value of technology. This announcement is just the beginning. Stay tuned!