Maintain Budget Forecasts {MEBO-1}

This two-Block option offers the facility to do budget forecasting for single cost centres or groups of cost centres, for a specific Parameter Set Code.

In the first block the user will select the cost centres for which projections must be done, and the accumulated results of the calculations are displayed. In the second block the user can do single calculations, and choose one of the projections to be copied as the final projection.

The system allows for the following projections if Yearly Budget.:

Projection on a percentage basis: the user can enter a percentage and the system will apply the specified percentage to the present budget figures.
Linear projection: the existence of historical figures is a prerequisite for this option; the system will calculate projected budget figures based on the historical values.
Pro-rated projection: the user can specify a total amount available for the specified range of cost centres or GLAs, and the system will allocate this amount pro-rated on the basis of the present budget.

If Monthly Budget:

Selective Month projection: the user can specify a Selective Budgeting Code, the system will calculate the average budget figure based on the historical values of the year and months of the selective budgeting code.
Projection on a percentage basis: the user can enter a percentage and the system will apply the specified percentage to the present budget figures.
Linear projection: the existence of historical figures is a prerequisite for this option; the system will calculate projected budget figures based on the historical values.
Pro-rated projection: the user can specify a total amount available for the specified range of cost centres or GLAs, and the system will allocate this amount pro-rated on the basis of the present budget.

MONTHLY budgets do not use any of the requested budget information for the calculation on the forecasts. All the information is selected from the GL.
If the year and cycle used is less than the Year and Cycle of the budget subsystem "BC" then use actual general ledger information else use budget general ledger information.

When forecasts are done for a Primary budget, the forecast calculation is based on cycles less than the budget cycle. E.g. For the forecast of a Primary budget information for the last 3 month must be used, the budget year is 2002 cycle 9, then it will use 2002 cycles 6, 7 and 8 for its information

When forecasts are done for a Revised budget the forecast calculation is based on cycles from the budget cycle . E.g. For the forecast of a Revise budget information for the last 3 month must be used, the budget year is 2002 cycle 9, then it will select 2002 cycles 7, 8 and 9.

Fields in the option:

Block 1: Budget Forecasting

Field	Type & Length	Description
Parameter Set Code	A4	The parameter set code for which the forecast must be performed.The system will display the following information of the Parameter Set Code: Description Primary or Revised Budget The Budget Period: If Yearly parameter set then only the Year, else Monthly the Year and Cycle of the Budget data. No adjustment to the parameter set data will be allowed if the approved budget values was posted to the General Ledger. The following three fields must be used only if the user does not what to see all the parameter set code budget forecast records. These fields are used to target specific records and may be used in any combination.
Cost Centre	A4	If a calculation for a single cost centre is to be done, the code of the detail cost centre must be entered. The system will also allow entering of consolidation cost centres. Not mandatory. The Cost Centre Description will display.
Type	A1	The cursor will not go to this field, and the system only displays the status of the cost centre entered under A. above. The value can be (C)consolidation or a (D)etail.
Account	A8	This field is not mandatory but if a calculation for a single GLA is to be done, the code of the account must be entered. If forecasting is to be done for all budget accounts linked to a cost centres, this field may be left blank.
Category	N3	This field can be completed if calculations must be done for all the accounts belonging to a specific account category
Total	N15	This is display-only fields and the system will calculate the values on the <SAVE> command. The calculated total will always be the total for the specified corresponding information.
Account Total	N15	This is a display-only field and if an account is entered in field "Account" above, the system will calculate the total for the specified cost centre/account combination, on the <NEXT BLOCK> command.
Category Total	N15	This is a display-only field and if an account category is entered in field "Category" above, the system will calculate the total for the specified category, on the <NEXT BLOCK> command.
Forecast Total	N15	This is a display-only field and the system will calculate the total "forecast value" for the whole file on the <NEXT BLOCK> command.
Must Forecasting (I)nclude / (E)xclude Adjustment Amount?	A1	(I)nclude (E)xclude. Must individual forecasting include any budget adjustment transactions not linked to the transaction type, linked to event FJ, budget transactions not originating from the expense budget system.
Do you wish to do major Calculations?	A1	If the answer is (N)o, the user can do single projections, on the linear, percentage and/or selective month basis, in block 2. If the answer is (Y)es, the system will offer a menu of choices for batch calculations. The menu prompts the user as follows: Enter The Parameter Set Code (A4): Select one of the following: From/To Cost Centre Consolidation Cost Centre Enter selection: If the response is 1 then Supply the starting Cost Centre Supply the ending Cost Centre If the response is 2 then Supply the Consolidation Cost Centre Select one of the following: From/to Category From/to Account Enter selection: If the response is 1 then Supply the starting category Supply the ending category If the response is 2 then Supply the starting account Supply the ending account Select Projection Method: Percentage projection Linear projection Pro-rated projection Selective Months (Only Valid for Monthly Budgets) Q. Exit Request If the response is 1 then Supply the percentage value If the response is 2 then The program goes to the prompt: Must Adjustment Values be (I)ncluded/(E)xcluded If the response is 3 then Supply the value to pro-rate Must Adjustment Values be (I)ncluded/(E)xcluded Must existing values be overwritten (Y)es /(N)o If the answer is (Y)es, the system will calculate new values and replace all existing values. If the answer is (N)o, the system will only insert new values into GLAs where no values exist. On execution of 'RUN', the system will perform the calculation. On the execution of 'EXIT', the user will be returned to block 1.

Example:

Block 2: Budget Detail Values

Field	Type & Length	Description
GLA	A4 + A8	The GL-Allocation for which a forecast is done. If a GLA does not exist, the system will respond with a warning: "GLA does not exist for this year", but it will allow updating of the transaction. The user can print all "invalid" GLA's with budget transaction against it (Menu option {MEBOR1-7}), and then create these on option {FCSO-6}.
Account Type	A1	Displays the the type of account, e.g. (R)evenue or (E)xpense, will be displayed.
% Value	N3.2	Percentage to be calculated on present year's budget figure. The result will be displayed in field "Value" below.
Value	N15.2	This is a display-only field and if a percentage is entered in field "% Value" above, the system will calculate this value.
Pro-rata	A1	This is a display-only field and if a pro-rata calculations were done, the system will insert a (Y)es into this field and the value will be displayed in field "Pro-rata Value" below.
Pro-rata Value	N15.2	This is a display-only field and if a pro-rata calculation was done, the system will display the value here.
Linear	A1	Indicate with a (Y)es if a linear projection should be done. The result will be displayed in field "Value" below.
Value	N15.2	This is a display-only field and if a (Y)es is entered in field "Linear" above, the system will calculate this value.
Copy	A1	The user will indicate in this field which one of the aforementioned values should be copied as forecast budget. The user can enter percentage, linear or pro-rata, and the applicable value will be copied to the final corecast value. The copy of the values can also be done via menu option {MEBO-2}.
Final Forecast Value	N15.2	Displays the value copied as final forecast for the GL-allocation.

Example:

Processing Rules
	No special processing rules

Date	System Version	By Whom	Job	Description
10-Jan-2007	v01.0.0.0	Bea Swart	t135460	New manual format.
02-Apr-2007	v01.0.0.0	Amanda Nell	t135460	New image
08-Dec-2008	v01.0.0.1	Marchand	t152121	manual Corrections