Siebel Consumer Goods Guide > Trade Funds >

Forecasting Accrual Funds (End User)

Account managers or administrators might want to forecast the amount of revenue that an accrual fund will generate. They can forecast using any of the Administration Fund views or using the Funds view for an account. The forecast calculation is based on SVP baseline records that are associated with the fund. When the user clicks the Forecast button, the appropriate SVP baseline records are used to forecast the accrual fund. The following rules determine the baseline records that are used:

• The start and end dates of the baseline record must be within the effective start and end dates of the source product.
• The account of the baseline record must be the same account for the source product.
• The product of the baseline record must be the same as the source product.

These SVP baseline records are associated with an accrual fund in much the same way that SVP baseline records are associated with account promotions.

After the SVP baseline records are associated with the accrual fund, adjustments are made for partial weeks. Then the SVP baseline records are rolled up to the source product, where the Accrual Rate or Accrual % is applied to calculate the forecast for source products. Then, the forecast for each source product is rolled up to the account accrual fund.

This task is a step in Process of Managing Trade Funds.

To create a forecast for an accrual fund

1. Navigate to the Accounts screen, then the Accounts List view.
2. Drill down on the Name field hyperlink for an account, and click the Funds view tab.
3. In the Funds list, select an accrual fund record, and click Forecast.

   The appropriate baseline records are associated with the fund, and the Forecast field for the fund is populated.

After you create the forecast for the accrual fund, you can examine the forecasted revenue for the fund and for each source product that is associated with the fund.

To review the forecasted revenue for accrual funds and associated source products

1. Navigate to the Accounts screen, then the Accounts List view.
2. Drill down on the Name field hyperlink for an account, and click the Funds view tab.
3. In the Funds list, select an accrual fund record for which you created a forecast.
4. Examine the Forecast field for this record.

   This field is the forecasted value of the fund and is calculated from the rollup of the Forecast field from all source products.

5. Scroll down, and click the Source Products view tab.
6. For each source product examine the following fields:
   • Est Total Volume. This field is the rolled-up value of the Estimated Total Volume of all the SVP baseline records associated with this source product. This field is also adjusted for partial periods.
   • Forecast. This field is calculated as follows:
     • If the basis is cases, the Est Total Volume multiplied by the Accrual Rate of the source product.
     • If the basis is revenue, the Est Total Volume multiplied by the Accrual %.