Cost Management

This section provides information about Oracle Fusion SCM Analytics Cost Management subject area metric details.

Topics

Cost Management - COGS and Gross Margin

These metrics will be used in the Analytics Currency (AC) and Cost Currency fact folder for the Subject Area. Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Cost Distribution Accounting Date to convert to the analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric Metric Definition
Recognized Cost of Good Sold This metric is calculated as the sum of recognized cost of good sold.
Recognized Revenue This metric is calculated as the sum of recognized revenue.
Recognized Gross Margin This metric is calculated as the sum of recognized gross margin.
Recognized Gross Margin Percentage This metric is calculated as the recognized gross margin divided by total gross margin.
Unrecognized Cost of Good Sold This metric is calculated as the sum of unrecognized cost of goods sold.
Unrecognized Revenue This metric is calculated as the sum of unrecognized revenue.
Unrecognized Gross Margin This metric is calculated as the sum of unrecognized gross margin.
Unrecognized Gross Margin Percentage This metric is calculated as the unrecognized gross margin divided by total gross margin.

Cost Management - Cost Accounting

These metrics will be used in the Ledger Currency and Cost Currency fact folder for the Subject Area. Metrics in these folders show amounts in their respective currencies.

Metric Metric Definition
Transaction Quantity This metric is calculated as sum of quantity in primary unit of measure.
Costed Quantity This metric is calculated as sum of quantity in costing unit of measure.
Transaction Debit Amount This metric shows the debit amount for the transactions.
Transaction Credit Amount This metric shows the credit amount for the transactions.
Transaction Net Amount This metric shows the activity amount of the transactions. Where activity amount = Sum of debit amount - Sum of credit amount.
Accounted Debit Amount This metric shows the accounted debit amount for the transactions.
Accounted Credit Amount This metric shows the accounted credit amount for the transactions.
Accounted Net Amount This metric shows the activity amount of the transactions. Where activity amount = Sum of accounted debit amount - Sum of accounted credit amount.

Cost Management - Inventory Valuations

These metrics will be used in the Analytics Currency (AC) and Cost Currency fact folder in the Subject Area. Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Period End Date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric Metric Definition
Costed OnHand Quantity This metric shows onhand balance for a given period.
Unit Cost This metric shows unit cost for a given period.
Costed OnHand Amount This metric shows costed onhand balance for a given period.
Accounted OnHand Amount This metric shows accounted onhand balance for a given period.
Unaccounted OnHand Amount This metric shows unaccounted onhand balance for a given period.

Cost Management - Item Cost

These metrics will be used in the Analytics Currency (AC) and Cost Currency fact folder in the Subject Area. Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Cost Effective Start Date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric Metric Definition
Unit Cost This metric shows average unit cost by distinct item and distinct valuation unit for a given period.
Material Cost This metric shows average material cost by distinct item and distinct valuation unit for a given period.
Material Overhead Cost This metric shows average material overhead cost by distinct item and distinct valuation unit for a given period.
Resource Cost This metric shows average resource cost by distinct item and distinct valuation unit for a given period.
Overhead Cost This metric shows average overhead cost by distinct item and distinct valuation unit for a given period.
Profit in Inventory This metric shows average profit in inventory cost by distinct item and distinct valuation unit for a given period.
Material Cost % This metric shows average material cost percentage of the average unit cost for a given period.
Material Overhead Cost % This metric shows average material overhead cost percentage of the average unit cost for a given period.
Resource Cost % This metric shows average resource cost percentage of the average unit cost for a given period.
Overhead Cost % This metric shows average overhead cost percentage of the average unit cost for a given period.
Profit in Inventory % This metric shows average profit in inventory cost percentage of the average unit cost for a given period.

Cost Management - Work Order Costing (Preview)

The fact folders in this subject area shows the metrics details below.

Metric Metric Definition
Output Cost Sum of value of completed work orders.
Component Cost Sum of value of materials issued to work orders.
Resource Cost Sum of value of actual resource hours charged to work orders.
Scrap Cost - Expensed Sum of value of scrap generated in work orders.
Scrap Cost - Absorbed in Inventory Sum of value of scrap generated in work orders.
WIP Balance Sum of undergoing production costs for work orders are not closed.
Variance Cost Sum of material usage variance quantity multiplied with cost for completed and closed work orders.