Creating a Budget Forecast 

Purpose

The process shows how you can plan a budget forecast. You can estimate the available budget up until the end of the fiscal year.

Prerequisites

As the data is based on monthly values and the base values change for the forecast, you must plan the forecast a few times. Use report FM_FORECAST_UPDATE to do this at the start of each month.  You must activate InfoCubes PU_C51 and  0PU_C02 in Business Content with the dependant objects.

In addition to this, you must activate planning areas 4PSBP11,4PSBFCMP, 4PSBFCPL with their dependant objects (planning level, planning function, planning parameter), and the global planning sequence FMFCSQ so that these are available in transaction BPS0.

You must then check the content of the following variables in multi-planning area (4PSBFCMP) and make changes if necessary.

●     Budget category for commitment budget (BUTCATCB)

●     Budget category for payment budget (BUCATPB)

●     FM area (FMAREA)

●     Fiscal year (FISCYEAR)

●     Valid periods (PERI)

●     Availability ledger (AVCLED)

●     Version (VERSION)

●     Value types budget (VTYPEBUD)

●     Value types commitment/actual (VTYPEACT)

●     Future periods (PERIFUT)

Process Flow

       1.      Calculation of overall commitment of period 1 through to current period.

       2.      Calculation of average value for each period: Division of overall commitments by the number of months (period 1 – current period).

       3.      Calculation of future commitments: multiplication of periodic average value (from step 2) with the number of periods still open (current period + 1 until end of the period).

       4.      Addition of overall commitment (from step 1) with the future commitments (from step 3).

Postings that were already posted on a period later than the current period are not included in the forecast.

 

Result

You have planned a budget forecast.