Generating contribution analysis report
|
|
|
|
|
This page allows you to generate a cost center wise contribution analysis report. Tell me more.
Select the “Contribution Analysis” link present under “Analysis Tool” business component.
The “Contribution Analysis” page appears.
Enter the following fields:
|
Business Unit |
Use the drop-down list box to select the business unit for which the contribution analysis report is being generated. All the business units of the company to which the “Analysis Tool” has been mapped, will be available for selection. The system displays the first value by default on launch of the page. |
|
Cost Center Structure ID. |
The code identifying the cost center structure based on which the contribution analysis report is being generated (Alphanumeric, 10). |
|
Help facility available |
|
|
Cost Center |
The code identifying the cost center for which contribution analysis report is being generated (Alphanumeric, 10). Mandatory. |
|
Help facility available |
Note: If the type of the cost center entered in this field is “Group” then the “Cost Center Structure ID” field must not be left blank.
|
Cost Element Structure ID. |
The code identifying the cost element structure for which contribution analysis report is being generated (Alphanumeric, 10). |
|
Help facility available |
|
|
Row ID. |
The number identifying the specific row of the cost element structure whose cost elements are considered in the contribution analysis (Alphanumeric, 10). |
Note: if value is entered in this field, then the “Cost Element Structure ID” field must not be left blank.
|
Item Code From |
The starting code in the range of codes identifying the item for which the contribution analysis report is being generated (Alphanumeric, 32). |
|
To |
The ending code in the range of codes identifying the item for which the contribution analysis report is being generated (Alphanumeric, 32). |
Note: The value entered in this field must be greater than the value entered in the “Item Code From” field.
|
Item Group |
The code identifying the item group whose items are considered for the contribution analysis (Alphanumeric, 25). |
|
Item Variant From |
The starting code in the range of codes identifying the item variant based on which the contribution analysis report is being generated (Alphanumeric, 8). |
|
To |
The ending code in the range of codes identifying the item variant based on which the contribution analysis report is being generated (Alphanumeric, 8). |
|
Allocation Preview |
Check this box if allocated costs from the cost centers are to be taken into account in the contribution analysis report. |
Note: If this field is checked then the fields “Item Code From”, “To”, “Item Group”, “Item Variant From” and “To” must be left blank.
|
Display Item Information |
Use the drop down list box to specify whether the Item wise Cost Element Details must be displayed or not. The combo would be loaded with Yes and No. The system displays “Yes” by default on launch of the page |
|
Cost Type |
Use the drop-down list box to select the type of cost that is considered in the contribution analysis. You can select from “Actual Cost”, “Standard Cost” or “Rollup Cost”. The system displays the first value by default on launch of the page. |
|
Standard Cost Option |
Use the drop-down list box to specify the type of standard cost that must be considered for the contribution analysis. You can select from “Actual”, “Budget” or “Manual”. The system displays “NULL” by default on launch of the page. |
Note: Values in this field will be available for selection only if “Standard Cost” option has been selected in the “Cost Type” field.
|
Production Location |
Use the drop-down list box to select the organization unit in which the items were produced. All the organization units that belong to the selected business unit in which “Order Definition Settlement and Costing” business component has been deployed will be available for selection, along with “All”. The system displays “All” by default on launch of the page. |
Note: Values will be available for selection in this field only if the value selected in the "Cost Type" field is "Actual Cost"
|
Start Date |
Use the drop-down list box to select the start date of the financial year for which the contribution analysis report is being generated. All the start dates of the financial years that have been defined for the selected business unit will be available for selection in descending order. The system displays the start date of the financial year within which the system date lies by default on launch of the page. |
|
End Date |
Use the drop-down list box to select the end date of the financial year for which the contribution analysis report is being generated. All the end dates of the financial years that have been defined for the selected business unit will be available for selection in descending order. The system displays the end date of the financial year within which the system date lies by default on launch of the page. |
Note: Date selected in this field must be greater than the date selected in the “Start Date” field.
|
Report Option |
Use the drop down list box to select the option to launch the report. The combo would be loaded with "Behavior", "Traceability", "Behavior - Across companies" and "Traceability - Across companies". By default it is displayed with "Behavior". |
Click the “Get Details” pushbutton to retrieve the cost element details.
The system retrieves and displays the revenue and normal cost element details from the “Cost Setup” business component, based on the data entered in the header.
Enter the following field in the “Revenue Cost Element” multiline:
|
Cost Element |
The code identifying the revenue cost element, which is under consideration for the contribution analysis report (Alphanumeric, 32). |
|
Help facility available |
The system displays the following in the “Revenue Cost Element” multiline:
|
Desc. |
The description pertaining to the revenue cost element. |
|
Behavior |
The behavior of the revenue cost element and the cost center mapping, which could be “Fixed Cost” or “Variable Cost”. |
|
Traceability |
A specification of the traceability of the costs which could be “Direct” or “Indirect”. |
Enter the following field in the “Normal Cost Element” multiline:
|
Cost Element |
The code identifying the normal cost element, which is under consideration for the contribution analysis report (Alphanumeric, 32). |
|
Help facility available |
The system displays the following in the “Normal Cost Element” multiline:
|
Desc. |
The description pertaining to the normal cost element. |
|
Behavior |
The behavior of the normal cost element and the cost center mapping, which could be “Fixed Cost” or “Variable Cost”. |
|
Traceability |
A specification of the traceability of the costs which could be “Direct” or “Indirect”. |
Profit Calculation Logic for Contribution Analysis:
If “Allocation Preview” field has not been checked then the system retreives the Actual Revenue Cost from the “MAC Incorporation” business component.
If “Allocation Preview” field has been checked then the system retreives the Allocation Revenue Cost from the “Cost Allocation” business component.
If “Cost Type” has been set as “Standard Cost” then the system retrieves the Standard Manufacture Cost (Fixed and Variable) from the “Standard Item Costs” business component.
If the “Cost Type” has been set as “Actual Cost” then the system retrieves the Actual Manufacture Cost (Fixed and Variable) from the “Order Definition Settlement and Costing” business component.
If the “Cost Type” has been set as “Rollup Cost” then the system retrieves the Rollup Manufacture Cost (Fixed and Variable) from the “DP Cost Rollup” business component.
Manufacturing Variable Cost
Product of “Quantity of item code, variant for the respective Revenue Cost Element” and the “Per unit Variable Cost Rate”.
Note: The above values are retrieved from the “MAC Incorporation”, “Cost Allocation”, “Standard Item Costs”, “DP Cost Rollup” and “Order Definition Settlement and Costing” business components as mentioned above.
Manufacturing Fixed Cost
Product of “Quantity of item code, variant for the respective Revenue Cost Element” and the “Per unit Fixed Cost Rate”.
Note: The above values are retrieved from the “MAC Incorporation”, “Cost Allocation”, “Standard Item Costs”, “DP Cost Rollup” and “Order Definition Settlement and Costing” business components as mentioned above.
Actual Non-Manufacturing Cost
If “Allocation Preview” field has not been checked then the Actual Non-Manufacturing Cost (Fixed and Variable) are retrieved from the “MAC Incorporation” business component.
Allocation Non-Manufacturing Cost
If “Allocation Preview” field has been checked then the Allocation Non-Manufacturing Cost (Fixed and Variable) are retrieved from the “Cost Allocation” business component.
Total Variable and Fixed Costs
The system calculates the Total Variable Costs to be the sum total of the Variable Manufacturing Costs and Variable Non-Manufacturing Costs.
The system calculates the Total Fixed Costs to be the sum total of the Fixed Manufacturing Costs and Fixed Non-Manufacturing Costs.
Profit
The system calculates the Profit as the Total Sales less the Total Variable Cost and the Total Fixed Costs.
Click the “Preview” pushbutton to preview the contribution analysis report.
The system executes the profit calculation logic and displays the contribution analysis report in form of a crystal report.
To proceed, carry out the following
Select the “Distribute Normal Cost Elements” link at the bottom of the page to distribute normal cost elements.
Select the “View Inter BU Cost Centers / Elements Mapping” link at the bottom of the page to distribute normal cost elements. Visible only when the report option is Behavior - Across companies and Traceability - Across companies.
Generating contribution analysis report – An overview
You can specify the business unit for which the report is being generated. You must also specify the cost center based on which the report is being generated. If the cost center specified here is a group cost center, then the corresponding cost center structure must also be specified. The cost element structure and the row of the cost element structure from which the cost elements are taken for consideration in the report, can also be specified.
This page also allows you to retrieve cost centers based on item details. Cost centers that have been mapped to particular items can be retrieved by specifying a range of item codes, item group and item variants. You can also specify whether allocated costs from the cost centers can be included for analysis in the report.
This page also allows you to specify the type of cost, the type of standard cost and the production location based on which the cost centers must be retrieved. You can also specify the start date and the end date of the financial year for which the contribution analysis report is to be generated. The system retrieves and displays the normal and revenue cost elements based on the above details. The required cost elements can be selected to generate the report. The report can be previewed as a crystal report, can be directly printed or can be redirected to an Excel spreadsheet.
Mandatory
“Business Unit” must have been defined in the “Organization Setup” business component.
“Cost Center” must have been defined in the “Cost Setup” business component.
“Cost Element” (Normal and Revenue) must have been defined in the “Cost Setup” business component.
Optional
“Cost Center Structure ID” must have been defined in the “Cost Setup” business component.
“Item Code”, “Item Variant” and “Item Group” must have been defined in the “Item Administration” business component.