Stock Valuation sourced measures and KPIs
This table shows the Stock Valuation measures that are sourced directly in Data Warehouse.
Most measures have Avg, Max, Min, and Sum aggregations. For cases where this does not apply, the available aggregations are indicated in this table:
| Measure | Description |
|---|---|
| Average Amt | Inventory value of the item according to the average value in the division currency |
| Comp A01 Cost | Amount for costing component A01 multiplied by the sellable quantity |
| Comp A02 Cost | Amount for costing component A02 multiplied by the sellable quantity |
| Comp A03 Cost | Amount for costing component A03 multiplied by the sellable quantity |
| Comp A04 Cost | Amount for costing component A04 multiplied by the sellable quantity |
| Comp A05 Cost | Amount for costing component A05 multiplied by the sellable quantity |
| Comp B01 Cost | Amount for costing component B01 multiplied by the sellable quantity |
| Comp B02 Cost | Amount for costing component B02 multiplied by the sellable quantity |
| Comp B03 Cost | Amount for costing component B03 multiplied by the sellable quantity |
| Comp B04 Cost | Amount for costing component B04 multiplied by the sellable quantity |
| Comp B05 Cost | Amount for costing component B05 multiplied by the sellable quantity |
| Comp B06 Cost | Amount for costing component B06 multiplied by the sellable quantity |
| Comp B07 Cost | Amount for costing component B07 multiplied by the sellable quantity |
| Comp B08 Cost | Amount for costing component B08 multiplied by the sellable quantity |
| Comp B09 Cost | Amount for costing component B09 multiplied by the sellable quantity |
| Comp B10 Cost | Amount for costing component B10 multiplied by the sellable quantity |
| Comp B11 Cost | Amount for costing component B11 multiplied by the sellable quantity |
| Comp B12 Cost | Amount for costing component B12 multiplied by the sellable quantity |
| Comp B13 Cost | Amount for costing component B13 multiplied by the sellable quantity |
| Comp B14 Cost | Amount for costing component B14 multiplied by the sellable quantity |
| Comp C01 Cost | Amount for costing component C01 multiplied by the sellable quantity |
| Comp C02 Cost | Amount for costing component C02 multiplied by the sellable quantity |
| Comp D01 Cost | Amount for costing component D01 multiplied by the sellable quantity |
| Comp D02 Cost | Amount for costing component D02 multiplied by the sellable quantity |
| Comp E01 Cost | Amount for costing component E01 multiplied by the sellable quantity |
| Comp E02 Cost | Amount for costing component E02 multiplied by the sellable quantity |
| Comp E03 Cost | Amount for costing component E03 multiplied by the sellable quantity |
| Comp E04 Cost | Amount for costing component E04 multiplied by the sellable quantity |
| Comp E05 Cost | Amount for costing component E05 multiplied by the sellable quantity |
| Comp E06 Cost | Amount for costing component E06 multiplied by the sellable quantity |
| Comp E07 Cost | Amount for costing component E07 multiplied by the sellable quantity |
| Comp E08 Cost | Amount for costing component E08 multiplied by the sellable quantity |
| Comp E09 Cost | Amount for costing component E09 multiplied by the sellable quantity |
| Comp E10 Cost | Amount for costing component E10 multiplied by the sellable quantity |
| Demand Qty – Bucket 1 | Demand quantity for an item for bucket 1 as defined in CAS025 |
| Demand Qty – Bucket 2 | Demand quantity for an item for bucket 2 as defined in CAS025 |
| Demand Qty – Bucket 3 | Demand quantity for an item for bucket 3 as defined in CAS025 |
| Demand Qty – Bucket 4 | Demand quantity for an item for bucket 4 as defined in CAS025 |
| Demand Qty – Bucket 5 | Demand quantity for an item for bucket 5 as defined in CAS025 |
| Depr Amt – Bucket 1 | Amount by which the net sales value for an item is depreciated for bucket 1 based on historic consumption |
| Depr Amt – Bucket 2 | Amount by which the net sales value for an item is depreciated for bucket 2 based on historic consumption |
| Depr Amt – Bucket 3 | Amount by which the net sales value for an item is depreciated for bucket 3 based on historic consumption |
| Depr Amt – Bucket 4 | Amount by which the net sales value for an item is depreciated for bucket 4 based on historic consumption |
| Depr Amt – Bucket 5 | Amount by which the net sales value for an item is depreciated for bucket 5 based on historic consumption |
| Element 1 Cost | Total amount of components with costing element equal to 1 multiplied by the sellable quantity |
| Element 2 Cost | Total amount of components with costing element equal to 2 multiplied by the sellable quantity |
| Element 3 Cost | Total amount of components with costing element equal to 3 multiplied by the sellable quantity |
| Element 4 Cost | Total amount of components with costing element equal to 4 multiplied by the sellable quantity |
| Element 5 Cost | Total amount of components with costing element equal to 5 multiplied by the sellable quantity |
| Element 6 Cost | Total amount of components with costing element equal to 6 multiplied by the sellable quantity |
| Element 7 Cost | Total amount of components with costing element equal to 7 multiplied by the sellable quantity |
| Element 8 Cost | Total amount of components with costing element equal to 8 multiplied by the sellable quantity |
| Element 9 Cost | Total amount of components with costing element equal to 9 multiplied by the sellable quantity |
| FIFO Adjustment | FIFO amount minus the replacement cost |
| FIFO Amt | Inventory value of item according to FIFO in the division currency |
| FIFO Unit Price | FIFO amount divided by the sellable quantity Aggregations: Avg, Max, Min |
| Inv Value – IAS2 | Inventory value which is the lowest, non-zero amount of either outgoing value or sales value |
| Inv Value – Manual | Manually entered inventory value of the item |
| Inv Value – Outgoing | Inventory value of the item according to the replacement method |
| Inv Value – Replacement Cost | Inventory value of the item according to the replacement cost method |
| Inv Value – Sales Value | The difference between the inventory valuation balance and excess quantity on each inventory valuation date |
| LIFO Amt | Inventory value of the item according to LIFO in the division currency |
| Material Cost | Total amount of costing components A01-A05 representing material costs multiplied by the sellable quantity |
| Operation Cost | Total amount of costing components B01-B14 representing operation costs multiplied by the sellable quantity |
| Product Overhead Cost | Total amount of costing components E01-E10 representing product costs multiplied by the sellable quantity |
| Rejected Qty | The rejected on-hand balance (status 3) on each inventory valuation date |
| Sellable Qty | The on-hand balance (status 2) on each inventory valuation date |
| Subcontract Cost | Total amount of costing components D01 and D02 representing subcontract costs multiplied by the sellable quantity |
| Tool Cost | Total amount of costing components C01 and C02 representing tool costs multiplied by the sellable quantity |
| Total Demand Qty | Sum of demand quantity buckets 1-5 |
| Total Depr Amt | Sum of depreciation amount buckets 1-5 |
| Total On Hand Qty | Sum of sellable, unsellable, and rejected quantities |
| Total Production Cost | Total amount of all costing components multiplied by the sellable quantity |
| Unsellable Qty | The on-hand balance for inspection (status 1) on each inventory valuation date |