Generating the cost center profitability report
Select the “Cost Center Profitability Report” link under “EDK Reports – Management Accounting” business component.
The “Cost Center Profitability Report” page appears.
Enter the following fields to provide the criteria for generating the Cost Center Profitability report:
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.
|
|
|
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. |
Click the “Print” pushbutton to view the required report.