Tag Archives: sales forecasting

Spotlight of the Week: How is Your Forecast Changing Over Time?

Thursday, August 12th, 2010

One of the most helpful views of the forecast in Right90 can be found in Change Analytics™ — which is where our customers quickly and easily monitor how their forecast is evolving over time. So what’s so interesting and valuable? Right90 Change Analytics allows you to create a chart of the forecast which compares how different regions, various product families, top customers, or key sales team members compare to each other. This visual representation of your aggregated forecast provides helpful trending information and allows you to more quickly respond to changing market conditions.

Track Changes in Change AnalyticsFor example, the chart to the right shows that the 2010 forecast for Apple has increased by $26M in the last 6 months — with most of that contribution coming in Services forecast as detailed in the Change Summary to the right of the graph.

The other two lines on the chart represent the forecast for two of your other key accounts — Sony and Verizon Wireless. Changing the “Focused On” from Apple to either of these other two allows you to quickly toggle between each customer to understand what’s driving the forecast changes.

Since we’re capturing forecast changes by customer, product, and region, you have a lot of flexibility in determining the type of comparisons you want to see on the graph and also which views of the Change Summary detail on the right will be most meaningful. Get started today by going to Right90 Change Analytics, select “Create New View” in the top right corner of the screen, and start learning more about how your forecast is changing.

Spotlight of the Week: Top 3 Ways to Use Right90 Comparative Analytics

Thursday, July 22nd, 2010

Why should you use Right90 Comparative Analytics — also known as the Analyze screen? The Analyze screen provides a rolled up view of your forecast by customer, product, region, or user in a table view.  While you have the option to drill down to see more details, you’re not bogged down with all those details. In addition to just viewing the forecast, here are three other popular ways to use Analyze:

  1. Use top-3-ways-comparative-analyticsyour snapshots to compare your forecast at points in time — for example, how has the 2010 forecast changed from the beginning of the year to today?  In this example, we’re looking at the variance by region.
  2. Compare top-3-ways-comparative-analyticsyour forecast to targets or goals so that you can keep track of how you’re doing against your objectives. In this example, we can see how each sales person is delivering against their targets.
  3. Compare top-3-ways-comparative-analyticsyour forecast to actuals or shipments to monitor attainment during the quarter. In this example, we can see attainment by customer.

Whenever you get a view of the data that you’ll want to see on a regular basis, save time by creating a Favorite. If you don’t have targets or actuals in Right90, your Right90 Administrator can help facilitate getting that data so you can take full advantage of Right90 Comparative Analytics to help identify and manage exceptions in your business.

S&OP: What’s Next After 30 Years?

Wednesday, July 14th, 2010

S&OP BalanceAs its forefathers including Oliver Wight would remind us, S&OP is a very mature process. The objective of S&OP: to align demand and supply in a financially sound manner. Sounds simple, yes? Yet after more than 30 years of practice, most companies still struggle to achieve success with S&OP. AMR Research’s current survey (as presented by Jane Barrett) found that 67% of companies are stuck at Stage Two of what AMR describes are the four stages of S&OP maturity. Let’s look at the state of S&OP practices today and some key implications of recent S&OP and Integrated Business Planning (IBP) research from AMR and Gartner, Inc.

We all know the importance of effective sales and marketing organizations. Especially in a fast-changing economy, sales and marketing effectiveness drives profitability disproportionately. When sales, marketing and channel partners (the “front office”) are effectively engaged with finance, demand planning and supply chain (the “back office”), the company fires on all cylinders. Case in point, Bob Johnson of Gartner Inc. recently presented research demonstrating it was excellence in the front-office side of S&OP that had the greatest impact on allowing many semiconductor companies to stay profitable during the last downturn. The ideal process starts with the front office accurately sizing up the total future demand, or shall we say, revenue potential.  The inputs to S&OP from the front office are bottom-up forecasts of both units (volume) and ASP (price) from sales reps, marketing/product managers and their executives. This rich forecast becomes the baseline for finance, demand planning and supply chain to engage.  Strategic S&OP issues and scenarios can then be escalated to executives for evaluation, while past performance and forward-looking metrics are assessed. The end result? The products customers want are built, and available for delivery, to their delight!

Guess what’s the #1 gap in S&OP today? AMR’s 2010 survey ranked sales and marketing input as the most important aspect of S&OP, yet one of worst performing areas. S&OP leaders assume the demand planning process can adequately incorporate sales and marketing forecasting, including new product forecasts. However, the tools they use to manage the process—demand planning applications—were not built for the sales and marketing people managing sales pipelines, new product launches and marketing campaigns. Even S&OP solutions like Demantra and SAP APO (demand planning applications with S&OP lipstick) lack the basic capabilities needed by sales and marketing—such as an intuitive user-interface and real-time data integration with CRM systems like Oracle CRM On Demand and salesforce.com’s Sales Cloud. It’s no surprise that 51% of companies still use Excel spreadsheets and the like for S&OP (per AMR’s 2010 S&OP survey). But when go-to-market strategies, or detailed sales forecast inputs are incorporated from Excel spreadsheets, accuracy and credibility are lost with operations, and therefore the possibility of reaching reaching a high level of S&OP maturity. Note that on the “OP” side in contrast, supply chain applications (often well-entrenched from over the past decade) can provide a reasonable means to gauge the capability to meet demand (AKA supply planning) and even quickly gauge the impact of S&OP scenarios.

So what lies ahead? S&OP has a bright future. Notably Tim Payne, Research Director, Gartner, Inc., predicts the market for S&OP solutions will grow at around 15% to 20% per year for the next few years1. The challenge for companies wanting to evolve from a reactive S&OP process to one that is collaborating and orchestrating is to get effective S&OP engagement from sales and marketing, including their executives. In my next post, we’ll take a look at how Right90 customers are reaching greater S&OP maturity with a purpose-built forecasting solution for sales and marketing that effectively engages sales and marketing. Even the executives.

1MarketScope for Sales and Operations Planning, 20 October 2009

Spotlight of the Week: Copy/Paste Rows Special

Friday, July 2nd, 2010

Have you ever wanted to copy your run-rate forecast from the previous 6 months to the next 6 months? Or have you ever needed to copy forecast data from a similar product’s current quarter forecast to another product’s current quarter forecast? What if you’d just like to copy last quarter’s actuals data for a product to be the starting point for the next quarter’s forecast for that product?

All of these examples and many other requirements can be met with the Right90 “Copy/Paste Rows Special” functionality available on the Forecast screen. While a separate, more basic Copy/Paste row option enables you to quickly copy an entire row of data from one line item to another, “Copy/Paste Rows Special” gives you more advanced capabilities to copy and paste data selectively as well as for multiple lines of data. With this feature, you can:

  • Copy data from specific lines from one time range to another
  • Copy data from specific lines to different lines within a selected time range
  • Copy data from specific lines from one plan to another plan that’s at the same level of detail.

Here’s a simple example to help you get acquainted with this time saving feature. Let’s copy several months of forecast for 3 products to the same months for 3 different products. (more…)