|
Siebel Deal Management Workbench User Guide > Analyzing the Current Market for a Line Item > About the Market Variability Analysis Graph >
Additional Information in the Market Variability Analysis
The following fields display additional market variability analysis data and metrics. Information About the Current Deal
The Current Deal fields, described in Table 5, show data for the current deal line item. If this heading reads Selected Quote, then the fields shown are for the deal (dot or revision triangle) currently clicked on the Market Variability Analysis graph.
Table 5. Current Deal (or Selected Quote) Fields
|
|
Account |
The name of the customer associated with this deal price for this line item. |
Deal |
The name of the deal that contains the current line item. |
Revision |
The deal revision number. |
TY |
The deal type. Currently, where Q indicates Quote is the only valid deal type. |
Start Date |
The start date of the period for which product data is included in the graph shown. |
End Date |
The end date of the period for which product data is included in the graph shown. |
Quantity |
The quantity of the current line item quoted on the deal. |
IP |
The invoice price proposed for the current deal line item. |
PP |
The corresponding pocket price for the current deal line item. |
PM% |
The pocket margin percent, which is the current line item's pocket margin divided by the its pocket revenue. |
Status |
The quote status, as defined for your organization's implementation of Siebel DMW. A price administrator can map the status values for Approved, Lost, and Won quotes in Siebel Deal Management. For more information on mapping the status values, see Siebel Deal Management Administration Guide. |
Information About Performance Metrics
The performance metrics fields, described in Table 6, are calculated for each status, and include only those deals meeting the selection criteria.
Table 6. Performance Metrics Fields
|
|
Average Pocket Price |
The sum of the line item pocket prices for the current product divided by the total number of deals (based on the deals that filter through the graph selection criteria only). |
Average Invoice Price |
The sum of the line item invoice prices for the current product divided by the total number of deals (based on the deals that filtered through the current graph selection criteria only). |
Maximum Pocket Price |
The maximum pocket price for the current product (based on the deals that filtered through the current graph selection criteria only). |
Maximum Invoice Price |
The maximum invoice price for the current product (based on the deals that filtered through the current graph selection criteria only). |
Minimum Pocket Price |
The minimum pocket price for the current product, based on the deals that pass through the filter. |
Minimum Invoice Price |
The minimum invoice price for the current product (based on the deals that filtered through the current graph selection criteria only). |
Total Impacted Pocket Revenue |
The sum of the pocket revenues for all of the line items for the current product for all the potentially affected deals (based on the deals that filtered through the current graph selection criteria only). |
Total Impacted Invoice Revenue |
The sum of the invoice revenue of all of the line items for the current product for all the potentially affected deals (based on the deals that filtered through the current graph selection criteria only). Each red dot on the Variability Analysis graph represents the current line item on another deal. Move the pointer over each dot to see the customer name. |
Total Impacted Pocket Revenue Delta |
The sum of the pocket revenues for all of the line items for the current product for all the potentially affected deals minus the sum of the product of the current invoice price and the quantities of all of the line items for the current product for all the potentially affected deals (based on the deals that filtered through the current graph selection criteria only). |
Total Impacted Invoice Revenue Delta |
The sum of the invoice revenues for all of the line items for the current product for all the potentially affected deals, minus the sum of the product of the current invoice price and the quantities of all of the line items for the current product for all the potentially affected deals (based on the deals that filter through the graph selection criteria only). This revenue is at stake if you grant the price to all other customers with deals that filtered through the current graph selection criteria. |
Information About Potential Impacted Customers
The Potential Impacted Customers table on the Market Variability Analysis screen lists the customers potentially affected and their deal line items for the product in the current deal line item that are for a higher price or quantity (or both). The Potential Impacted Customer fields are described in Table 7.
Table 7. Potential Impacted Customer Fields
|
|
Account |
Name of the customer on the potentially affected deal. |
TY |
The deal type. Currently, where Q indicates Quote is the only currently valid deal type.) |
Start Date |
The start date of the period from which the deal is effective. |
Quantity |
The quantity of the current line item on the affected deal. |
IP |
The invoice price of the current line item on the affected deal. |
PP |
The pocket price of the current line item on the affected deal. |
PM% |
The pocket margin percent, which is the pocket margin of the current line item on the affected deal divided by its pocket revenue. |
Status |
The status of the affected deal in Siebel Deal Management. |
Quantity (Actuals Shipped) |
The quantity of the product on this deal that has been shipped. |
Shipped % |
The percentage of the total quantity of the current product ordered on this deal that has been shipped. This percentage is calculated as follows: the line item shipped quantity divided by the line item quantity. |
Information About Scaling in the Market Variability Analysis Graph
The following scaling is applied in the Market Variability Analysis graph: The Market Variability Analysis graph displays X (quantity) and Y (price) axis values within 10% below the minimum and 10% above the maximum values represented in the data: Upper Y Bound is equal to Max(Y)+((Max(Y)-Min(Y))*.1)
Lower Y Bound is equal to Min(Y)-((Max(Y)-Min(Y))*.1)
Upper X Bound is equal to Max(X)+((Max(X)-Min(X))*.1)
Lower X Bound is equal to Min(X)-((Max(X)-Min(X))*.1)
Siebel DMW calculates the position and slope of the regression line in the Market Variability Analysis graph using the least squares linear regression method: Y = MX + B where: M is the slope. Slope is the angle of the regression line relative to the horizonal. B is the y-intercept point (where the regression line intercepts the y-axis). Siebel DMW calculates the recommended price point (invoice or pocket) as the slope multiplied by the current deal quantity plus the y-intercept. M * [Quantity] + B Siebel DMW calculates the recommended quantity point as the current deal price minus the y- intercept divided by the slope: RecQty = ([Price] - B)/M
| 
