Generating budget details

What you can do in this page

Glossary

Basics of using Ramco Enterprise series web page

This page allows you to generate a new budget. Tell me more

The “Generate Budget” page appears.

The system displays the following:

Budget No

The number identifying the budget.

Version No

The number identifying the budget version.

Status

The status of the budget. It could be “Fresh”.

 
  • Fresh – indicates a newly created budget. A budget in this status can be modified and authorized.

Description

The description of the budget.

Aggregate / Period

Indicates whether a comprehensive budget or a budget for a period is to be defined. It could be “Aggregate” or “Period”.

 
  • Aggregate – indicates that the budget is a comprehensive budget defined for a date range. This aggregate budget can be split among the MAC periods that are present in the effective date range as per specific seasonality patterns.

 
  • Period – indicates that the budget is defined for MAC periods that are covered in the date range during which the budget is effective. If the parameter “Control Totals for Budgets” has been set as “Yes”, an authorized aggregate budget must be available earlier for a period budget to be created.

Definition Type

Indicates the entity for which the budget is to be defined. It could be “Cost Center”, “Cost Center - Cost Element”, “Cost Center - Product” or “Cost Element – Product”.

 
  • Cost Center – indicates that the budget is being defined for a detail cost center.

 
  • Cost Center – Cost Element – indicates that the budgeted amounts and quantities are specified at the cost element level for the individual cost centers. This type of budget is used in analysis, comparison or reporting purposes.

 
  • Cost Center – Product – indicates that the budget amounts and values are specified for the item and the item variants for consumption or product output from a cost center for an accounting period. This type of budget is used to generate material variance reports for cost centers.

Budget Type

Indicates the type of the budget. It could be “Quantity”, “Value” or “Both”.

Budget Org Unit

The organization unit for which the budget is being defined.

Generation Basis

Use the drop-down list box to select the basis in which the budget must be generated. You can select from “Budget”, “Actuals”, “Estimate” or “Consolidation”.

 
  • Budget – indicates that the new budget would be generated based on the specified budget and version number.

 
  • Actuals – indicates that the new budget would be generated based on the “Actuals” that have been incurred for a specified range of earlier accounting periods.

 
  • Estimate – indicates that the new budget would be generated based on a selected budget and the actual costs incurred during a specified range of accounting periods.

 
  • Consolidation – indicates that the new budget would be generated based on multiple budgets that have to be consolidated.

 

The system displays “Budget” by default on launch of the page.

Note: If the budget is an “Aggregate” budget then “Estimate” must not be selected as “Generation Basis”.

Budget No

The number identifying the budget (Alphanumeric, 10). The budget number entered in this field must be a valid budget number and must be in “Active” status. This budget must also be of the same definition type, aggregate / period and budget type as the one selected in the corresponding budget header.

 

Help facility available

Note: This field must be left blank if “Actuals” or “Consolidation” has been selected as the “Generation Basis”.

Version No

The number identifying the budget version (Alphanumeric, 4). The version number entered in this field must be a valid version for the budget number entered in the “Budget No” field and must be in “Active” status.

 

Press <Enter> key.

 

The system retrieves and displays the details of the budget in the relevant fields.

Note: This field must be left blank if “Actuals” or “Consolidation” is selected as the “Generation Basis”.

The system displays the following in the “Budgets” group box:

Start Date

The effective date of the budget.

End Date

The expiry date of the budget.

Note: All the fields in this group box must be left blank if “Budget” or “Consolidation” has been selected as the “Generation Basis”. 

From Period

Use the drop-down list box to select the date from which the actual costs must be considered for generating the new budget. All the start dates of the MAC periods that have been defined for MAC years that are in the “Open” or “Closed” status will be available for selection in the chronological order. The system displays “Blank” by default on launch of the page.

Note: The date selected in this field must be before the date selected in the “To Period” field. The date selected in this field must be before the date selected as the “Effective Date” of the budget header.

To Period

Use the drop-down list box to select the date till which the actual costs must be considered for generating the new budget. All the end dates of the MAC periods that have been defined for MAC years that are in the “Open” or “Closed” status will be available for selection in the chronological order. The system displays “Blank” by default on launch of the page.

Note: The date selected in this field must be before the date selected as the “Expiry Date” of the budget header.

Percentage Increase or Decrease

The percentage of increase or decrease to be applied on the selected budget and actual values (Integer). A negative value can be specified to signify the decrease.

Note: This field must be left blank if “Consolidation” has been selected as the “Generation Basis”.

Maintain Seasonality

Check the box to adopt the seasonality pattern while generating a period budget. 

Note: This field must be left unchecked if “Consolidation” has been selected as the “Generation Basis”.

Budget Type

Use the drop-down list box to indicate whether an increase or decrease percentage is to be applied on the value, quantity or on both value and quantity when the type of the budget based on which the new budget is generated is “Both”. You can select from “Quantity”, “Value” or “Both”.

From Period

Use the drop down list box to select the period start date from which the increase or decrease in percentage is to be applied for a period budget. All the start dates of the MAC periods that have been defined for MAC years that are in the “Open” status will be available for selection in the chronological order. The system displays the earliest “Open” MAC period by default.

Note: The date selected in this field must be before the date selected in the “To Period” field.  The system displays the effective date selected while creating budget header by default if an “Aggregate” budget is to be generated.

To Period

Use the drop-down list box to select the period end date till which the increase or decrease in percentage is to be applied. All the end dates of the MAC periods that have been defined for MAC years that are in the “Open” status will be available for selection in the chronological order. The system displays the latest “Open” MAC period by default.

Note: The system displays the expiry date selected while creating budget header by default if an “Aggregate” budget is to be generated.

The system displays the following in the “Consolidation Details” multiline:

Note: The system retrieves the details of all the budgets that are available for the same duration of the new budget if the “Generation Basis” is selected as “Consolidated”.

Budget No

The number identifying the budget.

Version No

The number identifying the budget version.

Budget Span

The date range covered by the budget. The system displays the effective date and the expiry date of the budget.

The system generates the budget details based on the selected parameters. The budgeted amounts are saved in the base currency and the parallel base currency (if applicable) of the company. The system updates the status of the budget as “Fresh”.

The system generates the budget details based on the selected parameters. The budgeted amounts are saved in the base currency and the parallel base currency (if applicable) of the company. The system updates the status of the budget as “Active”.

The system displays the following:

Created By

The login ID of the user who created the budget.

Created Date

The date on which the budget was created.

To proceed, carry out the following

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Generating budget details – An overview

Activity Overview

This page provides you the facility to generate different types of budgets. You can generate a new “Period” or an “Aggregate” budget based on existing budgets. You can generate a budget based on the actuals that have been incurred for an earlier accounting period. You can generate a new budget based on the budget and the actuals that have been incurred for a previous accounting period. You can also generate a new budget based on multiple budgets that have been consolidated.

This page also allows you to increase or decrease the selected budgets or actuals while generating the new budget. You can also retain the proportion of the budgeted or actual amounts that have been incurred for the accounting periods. You can enter the number identifying the budget and version of the budget based on which you want to generate the new budget. Similarly, you can also select an accounting period and generate a budget based on the actuals that have been incurred during the selected period. The seasonal pattern would help retain the values of the respective periods of the parent budget.

When the new budget is generated based on the budget, the actuals or a combination of a budget and actuals of a previous accounting period, the system calculates the per day rate as the average of the budget and the actuals and subsequently generates the budget as the product of per day rate and the number of days that comprise the duration of the new budget.

The system saves the budgeted amount in the base currency of the company. If a parallel base currency is applicable for the company, the system also saves the budgeted amount in the parallel base currency of the company. The system updates the status of the budget as “Fresh”. The system also stores the login ID of the user and the system date along with newly created budget details.

This page also allows you to authorize the budget during the generation process. The system updates the status of the budget as “Active”. The system also stores the login ID of the user and the system date along with newly created budget details.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

What you can do in this page

Set basis of generation

Generate a new budget based on existing budget

Generate a new budget based on “Actuals”

Generate a new budget based on an “Estimate”

Generate a new budget based on multiple budgets

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Set basis of generation

You can select the basis in which the new budget must be generated. You can generate a budget based on an old budget or based on the actuals that have been incurred for a selected accounting period. Similarly, you can also generate a budget based on the budget and the actuals for an accounting period and a budget based on multiple budgets that have been consolidated.

Generate a new budget based on existing budget

You can generate a new budget based on an existing budget. You can enter the budget and the version number based on which the new budget must be generated. You can also increase or decrease the budget by a specified percentage. The selected old budget must be of the same budget type and definition type as that of the new budget. You can also retain the apportionment of the budgeted amount and quantity for the various accounting periods.  The system calculates the per day rate as the average of the budget and subsequently generates the budget as the product of per day rate and the number of days that comprise the duration of the new budget.

Note: You can set the budget type field if the budget type of the new budget is “Both”. 

. Note: You can set the “From Period” and “To Period” if the Aggregate / period type of the new budget is ” period”. 

The system generates a new budget in the “Fresh” status.

The system generates a new budget in the “Active” status.

Generate a new budget based on “Actuals”

You can generate a new budget based on the actual costs that have been incurred during a previous accounting period.  You can also increase or decrease the actuals by a specified percentage. You can also retain the proportion in which the actuals have been incurred in the selected accounting period. The system calculates the per day rate as the average of the actuals and subsequently generates the budget as the product of per day rate and the number of days that comprise the duration of the new budget.

Note: You can set the budget type field if the budget type of the new budget is “Both”. 

. Note: You can set the start and end dates if the budget period type of the new budget is ” period”. 

The system generates a new budget in the “Fresh” status.

The system generates a new budget in the “Active” status.

Generate a new budget based on an “Estimate”

You can generate a new budget based on an estimate of the budget and the actuals that have been incurred.  You can also increase or decrease the actuals by a specified percentage. You can also retain the proportion in which the actuals have been incurred against the budget. The system calculates the per day rate as the average of the budget and the actuals and subsequently generates the budget as the product of per day rate and the number of days that comprise the duration of the new budget.

Note: You can set the budget type field if the budget type of the new budget is “Both”. 

 Note: You can set the start and end dates if the budget period type of the new budget is ” period”. 

The system generates a new budget in the “Fresh” status.

The system generates a new budget in the “Active” status.

Generate a new budget based on multiple budgets

You can generate a new budget based on multiple budgets that have been created. You can consolidate budgets that have been defined for the accounting period.

The system retrieves all the budgets that are of the same budget type and definition type and that have been defined for the same duration as the new budget and within the start date and end date of the new budget.

The system generates a new budget in the “Fresh” status.

The system generates a new budget in the “Active” status.