Distribute deficit

After a forecast is defined, it is a common occurrence for the actual values to fall short of the forecasted values. The difference between the actuals and the forecast is termed the deficit. With Inforiver, you can distribute the deficit among open forecast periods.

To demonstrate this feature, we have created a forecast for Q1 2025 and allocated 100k - distributed equally among January, February, and March. The January forecast has been closed since actuals are available. The forecast for January is 33.33k, but the actual sales are only 18.54k. Let's see how to distribute this deficit.

1. Select the forecast measure and click on the distribute deficit option

From the Measures Compared dropdowns, you can select the measures for which the deficit is being calculated. In this case, we have calculated the deficit between Forecast and Sales. The calculated deficit is 14,790.84.

2. Select the forecast measure and distribution range

If you have multiple forecast measures in your report, from the Distribute to dropdown, select the forecast to which the deficit should be distributed. Click on the calendar icon to choose the period for distribution.

3. Set the distribution method

There are two methods for distribution, we'll look at an example for each of them.

In this scenario, both Feb and March have the same forecast values, so equal distribution and distribution by weights would have the same outcome. The deficit of 14k has been distributed equally between the Feb and March forecasts and added to the existing forecasted value.

Let's consider a scenario where the forecasts for Feb and Mar have different values.

a) Distribute equally: The deficit of 599.11 will be distributed between the forecasts for Feb and March.

b) Distribute by weights: The deficit of 599.11 will be distributed between the forecasts for Feb and March based on their weights.