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.

Forecasts with deficits

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.

Select the forecast and actuals to calculate the deficit

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.

Selecting the forecast measure and period over which to distribute the deficit

3. Set the distribution method

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

Distribution methods

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.

Deficit distributed equally between Feb and March

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

Forecasts with different values

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

Equal deficit distribution

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

Deficit distribution based on weights

Last updated

Was this helpful?