|
|
|
|
|
This page allows you to generate a flexible budget.
Select the “Generate Flexible Budget” link under the “Cost Budget” business component.
The “Generate Flexible Budget” page appears.
Enter the following details:
|
Budget No. |
The unique number identifying the budget for which the flexible budget is to be generated (Alphanumeric, 10). Mandatory. Budget number must be in the active status. |
|
Version No. |
The version number of the budget for which the flexible budget is to be generated (Alphanumeric, 4). Mandatory. Version number must be in the active status. |
|
Start Date |
Use the drop-down list box to select the starting date for the flexible budget. If Aggregate/Period of the Budget No./Version No. is 'Aggregate', the Start Date displays the 'Effective date' and the End date, the 'Expiry date' of the Budget Header |
|
End Date |
Use the drop-down list box to select the ending date for the flexible budget. End date must be later than the start date. |
|
Variance For Individual Period |
Check the box if variance is for the individual period. If Aggregate/Period of the Budget No. /Version No. is 'Period', the checkbox is displayed checked. If the Aggregate/Period of the Budget No. /Version No. is 'Aggregate', the checkbox is displayed unchecked. |
Click the “Get Details” pushbutton to fetch the details in the multiline.
The system displays the following in the “Budget Details “ multiline:
|
Accounting Period |
The accounting period of the budget. |
|
Cost Center / Unit |
The code identifying the cost center or unit associated with the budget. |
|
Basic Activity Element |
The code identifying the activity cost element defined in the “Cost Setup” business component. |
|
Budget Qty. |
The budgeted quantity. |
Ø Enter the following field details in the “Budget Details” multiline:
|
Actual Qty. |
The actual quantity as against the budgeted quantity (Integer, 28) |
Click the “Save Details” pushbutton to save the details.
The system computes Flex Factor = Actual Quantity of Basic Activity Element (BAE as in the ML) / Budget Quantity of BAE (from 'Budget Values')
If Process Parameter - 'Variability for Flexible Budgeting' is set to 'Rate', then for each row in the Budget Values, where the CE Type is 'Normal' or 'Allocation' the system computes Variable Amounts = Budget Amount * Var. Rate and Fixed Amount = Budget Amount - Variable Amount and updates these values in 'Budget Values' against the corresponding CC-CE row
If Process Parameter - 'Variability for Flexible Budgeting' is set to 'Percentage', then for each row in the Budget Values, where the CE Type is 'Normal' or 'Allocation' the system computes Variable Amounts = Budget Amount * Var. Percentage / 100 and Fixed Amount = Budget Amount - Variable Amount and updates these values in 'Budget Values' against the corresponding CC-CE row
For each row in the 'Budget Values' where CE Type is 'Activity', the system computes Flexed Quantity = Budget Quantity * Flex Factor, Flexed Amount = Budget Amount * Flex Factor. For each row in the 'Budget Values' where CE Type is 'Normal' or 'Allocation', the system computes Flexed Quantity = Budget Quantity * Flex Factor Flexed Amount = (Variable Amount * Flex Factor) + Fixed Amount Store these values in temp as 'Flexed Values'
The system computes Variances quantity as follows: Volume Variance Qty = Budget Quantity - Flexed Quantity Volume Variance Value = Budget Amount - Flexed Amount Flex Bud Variance Qty = Flexed Quantity - Actual Quantity Flex Bud Variance Value = Flexed Amount - Actual Amount Total Quantity Variance = Volume Variance Qty + Flex Bud Variance Qty Total Value Variance = Volume Variance Value + Flex Bud Variance Value Store these Variances in temp along with the 'Flexed Values'
The system computes Variances % as follows: Volume Variance Qty % = Volume Variance Qty * 100 / Budget Quantity Volume Variance Value % = Volume Variance Value * 100 / Budget Amount Flex Bud Variance Qty% = Flex Bud Variance Qty *100 / Flexed Quantity Flex Bud Variance Value % = Flex Bud Variance Value * 100 / Flexed Amount Total Quantity Variance % = Total Quantity Variance * 100 / Budget Quantity Total Value Variance % = Total Value Variance * 100 / Budget Amount Store these Variances in temp along with the 'Flexed Values'
The system saves the Flexible Budget for the Budget No. /Version No. and refreshes the screen with the saved Flexible Budget Details of the Budget No. /Version No.
Enter the following fields:
|
Report Type |
Use the drop-down list box to select the report type. You can select from “Flexible Budget Listing” or “Flexible Budget Report.” Mandatory. If Report Type Combo is Flexible Budget Listing, you can view and print Flexible Budget Listing. If Report Type Combo is Flexible Budget Report, you can view and print the Flexible Budget Report for the Budget No. / Version No. |
|
Variance Option |
Use the drop-down list box to select the variance option. You can select from “Flat” or “Percentage.” |
Click the “View Report” pushbutton to view the flexible budget details.
Click the “Print Details” pushbutton to print the flexible budget details.
To proceed, carry out the following
Select the “Select Flexible Budget” link to view the flexible budget details.
