Siebel Consumer Goods Guide > Trade Funds >

Forecasting Accrual Funds (End User)

Key account managers or administrators may wish to be able to forecast the amount of revenue that will be generated from an accrual fund. They can do this through any of the Administration Fund views or through the Funds view for an account. The forecast calculation is based on SVP baseline records that are associated with the fund. The user clicks the Forecast button and the appropriate SVP baseline records and calculates the total estimated shipment that will be used to forecast the accrual fund. The baseline records that are used are dependent upon the following rules:

• 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 as that of the source product.
• The product of the baseline record must be the same as that of the source product.

These records are associated with an accrual fund in much the same way that SVP baseline records are associated with 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 per 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 > Accounts List view.
2. Drill down on the Name field hyperlink for a selected 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.

When you have created the forecast for the accrual fund, you can examine the forecasted revenue for both the fund and for each Source Product associated with the fund.

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

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

   This value 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 value is the rolled-up value of the Estimated Total Volume of all the SVP baseline records associated with this source product. This value is also adjusted for partial periods.
   • Forecast. The value of this field is calculated by multiplying the Est Total Volume by the Accrual Rate of the of the source product if the basis is cases OR by multiplying the Est Total Volume by the Accrual % if the basis is revenue.