|
|
|
|
|
This report provides the details of the value added cost or the standard cost. Report Information.
Select the “Costed Multi Level Bill” link under the “DP Reports”.
The “Costed Multi Level Bill” page appears.
Enter the following field in the “Report Filters” group box:
|
From Item Code |
The starting code in the range of item codes for which the costed multi level bill report is to be viewed. Mandatory. You can also enter the code in full or specify it partially using the “*” character. The system retrieves all the codes that are similar to the value entered here. |
|
To Item Code |
The ending code in the range of item codes for which the costed multi level bill report is to be viewed. You can enter the code in full or specify it partially using the “*” character. The system retrieves all the codes that are similar to the value entered here. |
|
Qty. |
The quantity of the item. If the field is left blank then the system displays “1” by default. |
|
PS Category |
Use the drop-down list box to select the PS category. You can select from “Production”, “Costing” or “Engineering”. The system displays “Production” by default on launch of the page. |
|
Plant |
Use the drop-down list box to select the valid plants where the items are identified. The system retrieves the warehouse organization units. In case if the component is taking only one item organization unit, then the system automatically displays “CIM” organization unit by default. Else in case if the component is taking multiple organization units, then the system displays that organization unit that is marked as default plant in "Maintain Item - Manufacturing Information", page. Or else if no plant is marked as default in case of multiple item organization units, then the system display the first organization unit by default on launch of the page. |
|
Warehouse Code |
The code identifying the warehouse in which the item is identified. The system displays the standard warehouse of the default plant by default on launch of the page. |
Click the “Generate Report” pushbutton to view the details of the value added cost for all input items for a given item code.
Based on the specification in the report filter, the system generates the report.
If no value is specified in the search criteria then none of the details are retrieved.
If “From Item Code” is only specified, then the system generates the report for all the item codes that are greater than or equal to “From Item Code”.
If “To Item Code” is specified, then the system generates the report for all the item codes that are less than or equal to “To Item Code”.
Costed Multi Level Bill – An Overview
The value added cost is calculated for all the input Items defined for a specific item. For the input items, if the source is “Purchase” then the value added cost refers to the “Material Cost”. If the source “Manufacture” then the value added cost refers to the “Process Cost”. Any discrepancy in the standard cost can be viewed using this report. The product structure and process plan for the items are also displayed as a part of the report
This page allows you to set the criteria for the set of items. You must specify a specific item or range of items to generate the costed multi level bill. The quantity of the end item, plan and warehouse where the items are identified can also be set as a part of the search criteria. You can also select the product structure category as “Production”, “Costing” or “Engineering” in the search filter.
The report generates the costed multi level bill for the specified item. The cost details are displayed at each level. The report displays the items (input and end items), quantity of each item along with the corresponding product structure and process plan attached to the item. The value added cost of each input item is retrieved and displayed from inventory based on the nature of the cost. For the manufacturing items, value added cost indicates the process cost. For the items purchased or subcontracted, value added cost indicates the material cost. The value added cost of all the input items is added to arrive at the standard cost of the end time. If the standard cost is modified in inventory, the date of modification is captured in this report. Let us consider an example with the following information:
|
Level |
Item Code |
Source |
Material Cost |
Process Cost |
|
0 |
ITEM A |
M |
||
|
1 |
ITEM B |
P |
100 |
|
|
1 |
ITEM C |
M |
120 |
|
|
1 |
ITEM D |
P |
110 |
|
|
2 |
ITEM E |
P |
175 |
|
|
3 |
ITEM F |
M |
75 |
|
|
3 |
ITEM G |
M |
135 |
From the above table, the value added cost for the item A is calculated and displayed as follows:
|
Level |
Item Code |
Source |
Value Added Cost |
PS No |
PP No |
|
0 |
ITEM A |
M |
715 |
PSITEMA |
PPITEMA |
|
1 |
ITEM B |
P |
100 |
||
|
1 |
ITEM C |
M |
120 |
PSITEMC |
PPITEMC |
|
2 |
ITEM E |
P |
175 |
||
|
3 |
ITEM F |
M |
75 |
PSITEMF |
PPITEMF |
|
3 |
ITEM G |
M |
135 |
PSITEMG |
PPITEMG |
|
1 |
ITEM D |
P |
110 |
In the above table, the value added cost for the end item – ITEM A is displayed by adding the material and process cost of each input item. The cost is calculated and retrieved from inventory. All the transactions are displayed for the business unit, item, plant, warehouse and quantity. The total standard cost is also displayed.