Sourced measures and KPIs
This table shows the measures that are sourced directly in Data Warehouse:
| 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 |
| 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 |
| Obsolete Inv Value % | Percentage of the inventory value considered as obsolete during inventory valuation |
| 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 |