Siebel Forecasting Guide > Common High-Level Forecast Usage Scenarios >

Opportunity Product Forecasting

A company needs to forecast both opportunity and product revenues related to opportunities, but only wants to see forecast details by opportunity.

Administrator Usage Scenario

The administrator defines an opportunity product forecast series. The Auto Forecast Search Spec is set as follows: [Product] IS NOT NULL and [Calculated Primary Flag] = 'N'. This search pulls product revenue line items that have a product indicated into the forecast.

End User Revenue Scenario

  • Create a new opportunity.
  • Associate and create product revenue line items using either the New Record command, revenue scripts, or revenue plans.
  • Use the Revenues list or spreadsheet views to edit and maintain product revenues (add quantity, cost, margin, price, and product line).
  • Use revenue charts and reports to graphically display data and to perform ad hoc analysis. For example, create charts and reports with the parameters revenue by opportunity or quantity by opportunity.

End User Forecast Scenario

  • Create an opportunity product forecast.
  • In the Details view, use the spreadsheet and chart views to evaluate and adjust product revenues.
  • Use charts and reports to view product revenues by opportunity and to see aggregates of product quantity and revenue by opportunity.
  • Use queries to view live forecast details by opportunity. Preconfigured, these queries are set up to query by product.
  • Adjust and submit forecasts.

NOTE:  To rollup total quantity, the administrator needs to expose the quantity rollup in the total forecast. This is a simple configuration procedure. Also to use the forecast queries to filter opportunities, the administrator needs to configure this.

About Forecasting Opportunity Products

The Expected Delivery Date field in the Opportunities screen > Products view determines the column (month) into which that product falls in the forecasting views. For example, several opportunity products can be combined into one product forecast record. The value that is seen for January for product x might be an aggregation of several opportunity product records. If the date on one of those records is changed, thereby knocking it out of the forecast, other records might still remain with slightly lower quantities or a slightly different average price.

Siebel Forecasting Guide