Generating the cost center profitability report

Unified Glossary

Basics of using a Ramco iEnterprise Series 4.0  Web Page

Using Online Help

The “Cost Center Profitability Report” page appears.

Finance Book

Use the drop-down list box to select the finance book. The system lists all the finance books for the login company and organization unit as defined in the “Organization Setup” business component.. The system displays “ALL” by default.

Year

Use the drop-down list box to select the year for which the report needs to be run. The system lists all the “Active” financial years. The system displays the current financial year by default.

Fin. Period

 

Use the drop-down list box to select the financial period in the specified financial year for which the report needs to be run. The system lists all the financial periods for the selected financial year.

The system displays the profitability for the financial period that you specify here. The system displays the current financial year, by default.

CC Structure Id

The identification number of the cost center structure (Alphanumeric, 10).

Specify the cost center structure for which the profitability report needs to be run. The report displays the profitability details of all the cost centers in the structure that you specify here.

Help facility available.

CE Structure Id

The identification number of the cost element structure (Alphanumeric, 10). Specify the cost element structure in which the profitability report needs to be run. The report will display the values against all the cost elements mapped to the specified cost element structure, for the specified period.

Help facility available

Amount In

The integer format in which the values for the report is displayed. The system displays the following values: Actuals, Billion, Million and, Thousands. The system displays “Actuals”, by default.

Cost Center From

If the report needs to be run for any specific cost center/s, the same can be specified in this field. Specify in this field, the first cost center in the range of cost centers, for which the report needs to be run. You can enter the cost center in full or specify it partially using the “*” character. The system retrieves all cost centers that are similar to the number entered here.

To

The last cost center in the range of cost centers, for which the report needs to be run.  Ensure that the value entered here is greater than the value entered in  the “Cost Center From” field. You can enter the cost center in full or specify it partially using the “*” character. The system retrieves all cost centers that are similar to the number entered here.

Note: You must not specify any CC Structure ID, if you want to specify individual cost centers.

CC Report Option

Use the drop-down list box to specify the report option. The system lists the following values: CC Group and CC Detail.

  • To see the profitability details at the group level, select “CC Group”. The report  displays  the profitability of all the groups cost center mapped to the CC Structure ID or the From and Cost Center To fields.

 

  • Select “CC Detail”, if you want to see the profitability details for each of the detailed cost centers mapped to the CC structure or the From and Cost Center To fields. The system displays “CC Group”, by default.

Include Allocation

Use the drop-down list box to indicate whether you want the report  to include the amount of  allocations made by other cost centers, which includes the real-time processing allocated values to the values  of the cost centers as specified in the “CC Structure ID” field or the From and Cost Center To fields.  The system displays “No”, by default.

Allocation Report Method

Use the drop-down list box to select the method of allocation to be used for inclusion of allocation values. The allocation report type selected for the specified period must be defined in the “Cost Allocation” business component, and the run number associated to the allocation must be in “Processed“ status.

If the “Include Allocation” field is set to “Yes”, the system lists all the report types that are defined in the “Cost Allocation” business component. Otherwise, the system leaves the field blank.

Note: You must not specify any allocation report method, if you have selected “No” in the "Include Allocation" field.

CE Display Level

Use the drop-down list box to select the levels at which the cost elements mapped to the CE Structure should be displayed in the report. All the levels available in the given CE structure ID will get loaded. Select the minimum number to display the structure at its lowest level and the maximum number to display the highest level.

Budget No

Enter the number identifying the budget whose details needs to be compared with the actuals. (Alphanumeric, 10). Mandatory. The budget must be of  type “Cost Center-Cost Element”, and must be a valid budget.

If this field is left blank, the columns on budgeted value in the report will be left blank. Ensure that the value entered here is a valid budget number as defined in the “Cost Budget” business component.

Help facility available

Note: The budget you specify must be a cost center-cost element wise budget.

Version #

The number identifying the version of the budget, (Decimal). Mandatory.  Ensure that the value entered here exists for the budget number and is in “Active” status as defined in the “Cost Budget” business component.

Forecast #

The identification number of the forecast. Provide the Forecast # the details of which needs to be compared with the actuals. If this field is left blank then the columns on forecasted value in the report will be left blank. Ensure that the forecast# entered here is a valid forecast number as defined in the “Revenue Forecasting” business component.

Help facility available

Amendment #

The identification number of the amendment associated with the forecast.  Ensure that the value entered here exists for the forecast number.

Help facility available.

Report Option

Use the drop-down list box to specify the type of the report. The system displays the following options: CC Profitability and Productivity Analysis. Defining formulae in the formula builder is a pre-requisite, to run the Productivity report.