Cost Sheet by Cost Center Report

The Cost Sheet by Cost Center Report gives you a report on the generated cost sheets for a particular cost center or a range of cost centers. Tell me more

Select the “Cost Sheet by Cost Center Report” link under the “Reports – Management Accounting” business component.

The “Cost Sheet by Cost Center Report” page appears.

Enter the following field in the “Search Criteria” group box:

Cost Center Structure ID

A unique number identifying the structure of the cost center for which you want to generate the cost sheet by cost center report (Alphanumeric, 10). The cost center structure ID must be mapped to the “CSET” component. If the structure ID is entered in this field, the cost sheet is generated for the cost center that is mapped to the given structure ID.

Note: If this field is blank, then the cost sheet is generated for all the cost centers.

Level

A unique number identifying the level in which you want to generate the cost sheet by cost center report (Decimal). The level is valid only when the structure ID is provided. If the level number is provided, the cost sheet will be generated for all the cost centers, which is mapped at the given level.

Note: If this field is blank, then the cost sheet is generated for all the cost centers under the given structure ID.

Cost Center / Unit From

The starting code in the range of codes identifying the cost center / unit from which you want to generate the cost sheet by cost center report (Alphanumeric, 32). The cost center / unit code must have been defined in the “CSET” component.

Note: If this field is blank, it will be replaced by the minimum valid detail cost center ID.

If the value entered in this field is invalid, then the invalid value will be replaced by a valid succeeding cost center.

If the structure ID is entered, then the value in this field will be replaced by a valid minimum cost center within the given structure id.

The ending code in the range of codes identifying the cost center / unit from which you want generate the cost sheet by cost center report (Alphanumeric, 32). The cost center / unit code must have been defined in the “CSET” component. The code entered here must be greater than the code entered in the “Cost Center / Unit From” field.

Note: If this field is blank, it will be replaced by the maximum valid detail cost center ID.

If the value entered in this field is invalid, then the invalid value will be replaced by a valid preceding cost center.

If the structure ID is entered, then the value in this field will be replaced by a valid maximum cost center within the given structure id.

Center / Unit Type

Use the drop-down list box to select the type of cost center / unit for which you want generate the cost sheet by cost center report. The cost center type must be mapped to the “CSET” component. The system displays “All” by default on the launch of the page.

Note: Only the cost center / unit of the specified type that is defined in the cost setup parameters is valid.

Cost Element From

The starting code in the range of codes identifying the cost element for which you want to generate the cost sheet by cost center report (Alphanumeric, 32). The cost element code must have been defined in the “CSET” component.

Note: If this field is blank, it will be replaced by the minimum valid detail cost element ID.

If the value entered in this field is invalid, then the invalid value will be replaced by a valid succeeding cost element.

The ending code in the range of codes identifying the cost element for which you want to generate the cost sheet by cost center report (Alphanumeric, 32). The cost element code must have been defined in the “CSET” component. The code entered here must be greater than the code entered in the “Cost Element From” field.

Note: If this field is blank, it will be replaced by the maximum valid detail cost element ID.

If the value entered in this field is invalid, then the invalid value will be replaced by a valid preceding cost element.

Cost Element Type

Use the drop-down list box to select the type of cost element for which you want to generate the cost sheet by cost center report. You can select from “All”, “Normal”, “Allocation”, and “Activity”. The system displays “All” by default on the launch of the page.

Note: Only the cost element of the specified type that is defined in the cost setup parameters is valid.

Year	Use the drop-down list box to select the year from which you want to generate the cost sheet by cost center report. All the values mapped to the “CSET” component and the concatenated start and end dates of all the MAC accounting years are available for selection in the ascending order. The system displays the current accounting year by default on the launch of the page.
Period	Use the drop-down list box to select the period from which you want to generate the cost sheet by cost center report. All the values mapped to the “CSET” component and the concatenated start and end dates of all the MAC accounting periods are available for selection in the ascending order. The system displays the current accounting period by default on the launch of the page.
Date Option	Use the drop-down list box to select the date option in which you want to generate the cost sheet by cost center report. You can select from “Both”, “Period” and “Year”. The system displays “Both” by default on the launch of the page.
Allocation Preview	Use the drop-down list box to select the value to include the allocation preview. You can select from “Yes” and “No”. The system displays “No” by default on the launch of the page.

Note: If Yes is selected and the period is open, then Cost Sheet will be generated to the Allocation simulation process.

Compare With

Use the drop-down list box to select the comparison for which you want to generate the cost sheet by cost center report. You can select from blank, “Actuals”, “Budget” and “Allocated Budget”. The system displays blank by default on the launch of the page.

Note: Based on the selection made in this field the comparison of the cost sheet by cost center is done.

Budget No.

A unique number identifying the budget for which you want to generate the cost sheet by cost center report (Decimal).

Note: If the “Budget” and “Allocated Budget” is selected in the “Compare With” field, then the “Budget No” is mandatory.

Version No

A unique number identifying the version for which you want to generate the cost sheet by cost center report (Decimal).

Note: If the “Budget” and “Allocated Budget” is selected in the “Compare With” field, then the “Budget No” is mandatory.

Year

Use the drop-down list box to select the year from which you want to generate the cost sheet by cost center report. All the values mapped to the “CSET” component and the concatenated start and end dates of all the MAC accounting years are available for selection in the ascending order. The system displays the current accounting year by default on the launch of the page.

Note: If the “Compare With” is selected, then this field is mandatory.

Period

Use the drop-down list box to select the period from which you want to generate the cost sheet by cost center report. All the values mapped to the “CSET” component and the concatenated start and end dates of all the MAC accounting periods are available for selection in the ascending order. The system displays the current accounting period by default on the launch of the page.

Note: If the “Compare With” is selected, then this field is mandatory.

Variance Option

Use the drop-down list box to select the variance option in which you want to generate the cost sheet by cost center report. You can select from blank, “Flat” and “Percentage”. The system displays “Flat” by default on the launch of the page.

Note: If the “Compare With” is selected, then this field is mandatory.

Filter Basis	Use the drop-down list box to select the filter basis for which you want to generate the cost sheet by cost center report. You can select from blank, “Quantity Variance” and “Value Variance”. The system displays blank by default on the launch of the page.
Filter Option	Use the drop-down list box to select the filter option for which you want to generate the cost sheet by cost center report. You can select from blank, “>”, “>=”, “=”, “<=” and “<”. The system displays blank by default on the launch of the page.
Percentage / Value	The number identifying the percentage / value for which you want to generate the cost sheet by cost center report (Decimal).

Note: If this field is entered, then the “Filter Basis” and the “Filter Option” are mandatory.

Click the “View” pushbutton to view the cost sheet by cost center report.
Click the “Print” pushbutton to print the cost sheet by cost center report.

The system prints the cost sheet by cost center report based on the values entered in the search criteria.

The system generated 12 types of report layouts.

Comparison of Period with the Actuals, Budget and Allocated Budget (3 Reports):

In these reports you can view the details for the values entered in the search criteria. You can view the report layout based on the cost element. The report also displays the quantity and value of the actual periods, the quantity and value for the comparison period and the quantity and value for the variance period. You can also view the element type and the description of the comparisons.

Comparison of Year To Date with the Actuals, Budget and Allocated Budget (3 Reports):

In these reports you can view the details for the values entered in the search criteria. You can view the report layout based on the cost element. The report also displays the quantity and value of the year to date actuals, the quantity and value for the year to date comparison and the quantity and value for the year to date variance. You can also element type and the description of the comparisons.

Comparison of Both – Period and Year To Date (3 Reports):

In these reports you can view the details for the values entered in the search criteria. You can view the report layout classified into the fixed expenses / revenues, the fixed expenses / revenue total, the variable expenses / revenues, and the variable expenses / revenues total. The report also displays the quantity and value of the period actuals, the quantity and value for the comparison period, the quantity and value for the variance period, the quantity and value of the year to date actuals, the quantity and value for the year to date comparison and the quantity and value for the year to date variance. You can also element type and the description of the comparisons.

Cost Sheet by Cost Center Report – An overview

This page allows you to generate twelve different report layouts. You can generate a report by selecting a range of Cost Centers, Center / Unit Type, range of Cost Elements, Cost Element Type, a Cost Center Structure ID, Level, Accounting Year, Accounting Period, Data Option and Allocation Preview combination. You can also compare these fields with the Actuals, the Budget and the Allocated Budget for a given Period, Year to Date and Both which gives you an output of twelve report layouts. On comparison the details can be viewed in the Flat or Percentage values. You can also select the filters for the basis, the option and for the variances for which you can view it as the quantity variance or the value variance. You can also choose the report to be displayed for a Period, Year to Date or Both.