Cost Accounting for Manufacturing Work Orders
Oracle Cost Accounting provides costing and accounting functionality for these manufacturing work order types:
-
Process and discrete manufacturing work orders
-
Standard and non-standard work orders
-
Orderless manufacturing
After a work order is released in manufacturing execution, it can be interfaced to cost accounting. These transactions reported for the work orders get interfaced to costing and are processed by costing:
-
Component issues and returns
-
Resource charging and reversals
-
Product completions and returns
-
Scrap transactions
-
Work order close
-
Work in Process Cost Adjustments
Component Issues and Returns
The component transactions are costed based on the cost method of the component.
Cost Method |
Component Cost |
---|---|
Standard Cost |
Uses current standard cost of the component. |
Perpetual Average |
Uses current perpetual average cost of the component. |
Actual Cost |
Uses the cost of the specific layer from which the component was issued by the cost processor. |
Resource Charging and Reversals
Resource transactions are costed based on the resource cost set up in Manage Resource Costs and published to cost accounting. For all cost methods, you need to define the resource rates in a cost scenario. You need to first create a cost scenario for your cost organization and cost book combination. You then define the resource rates in the cost scenario and publish the cost scenario so that the resource rates are used for accounting.
Product Completions and Returns
All product completions are costed with an estimated cost as provisional completions and their actual cost is calculated when the work order is closed. The estimated cost used for the product completion is based on the cost method and the corresponding provisional completions option set in the item cost profile of the product.
Cost Method |
Provisional Completions Options |
---|---|
Standard Cost |
Value at standard cost |
Perpetual Average |
|
Actual Cost |
|
-
Even if you're using the Actual Cost or Perpetual Average cost method, you can create a standard cost for any item.
-
If you set value at work order close, product completions are costed with the actual cost incurred for the work order when the work order close is processed. The product completion transactions won't be processed until work order is closed and will remain uncosted.
Scrap Transactions
The cost of scrap reported against a work order is calculated based on the actual cost incurred till the operation where the scrap has been reported. The scrap accounting is based on these parameters that are setup in the item cost profile.
-
The operation scrap valuation option is used to decide when the scrap transactions are processed.
-
Value at work order close: Bunches all the scrap transactions together and processes them at work order close.
-
Value immediately and at work order close: The scrap transaction is processed as soon as the cost processor encounters it and then corrects the value at work order close, if necessary. This option leads to more transactions than the previous option.
-
Value at cost cutoff date and at work order close: This option is used for long running batches. The scrap transaction is processed on the cost cutoff date, which is usually the month end, and is corrected at work order close, if necessary.
-
-
The operation scrap accounting option indicates how to account for the scrap transactions.
-
Include in inventory: The cost of the scrap is included in the inventory value. In essence, the cost of the scrap is spread over the good products produced in the work order. The scrap transaction is ignored by the cost processor and the distribution processor and is marked accordingly.
-
Expense: The cost of the scrap is expensed out from the work order.
-
-
The Estimated Scrap transaction absorbs the costs due to the additional material used at each operation. An Estimated Scrap transaction is recorded for each completion of an operation that has operation yield associated with it. This is supported for all cost methods.
Estimated Scrap Quantity = Operation Completion Quantity * (1 - Operation Yield)/Operation Yield
Accounting entries for Estimated Scrap are listed here.
Accounting Line Type Debit Credit Work in Process X Estimated Scrap Absorption X If an operation completion transaction is reversed, the estimated scrap gets reversed through an Estimated Scrap Return transaction.
Accounting Line Type Debit Credit Estimated Scrap Absorption X Work in Process X
Work Order Close
When the work order is closed, costing ensures that all the transactions reported for the work order are successfully costed. After successfully processing all transactions, these events are created in costing.
-
If the product is costed using actual cost or perpetual average, product cost adjustment transactions are created. After the work order is closed, cost processor calculates the actual cost for the product based on all the material and resource transactions reported for the work order. If there is a difference between this actual cost and the estimated cost used for the provisional completions, product cost adjustments are created.
-
The scrap costs are recalculated and necessary adjustments are created if the costs are different from the ones that were considered earlier. The actual scrap transaction reported in work orders that have operation yield associated with it are processed with the Operation Scrap Accounting option of Expense, irrespective of the value set up in the cost profile.
-
If the product is costed using standard cost, then the cost processor compares the components and resources used for the work order with the work definition used to roll up the product and creates these variances.
Variance
Description
Material Rate Variance
The difference in cost when the rate used for the component during cost rollup is different from the rate used while costing the component issue transaction.
Material Substitution Variance
The difference in cost when an item in the work definition isn't used in the work order or when an item that isn't in the work definition is used in the work order.
Material Usage Variance
The difference in cost when the quantity used in the work order is different from the quantity specified in the work definition.
Resource Rate Variance
The difference in cost when the rate used for the resource during cost rollup is different from the rate used while costing the resource charging transaction.
Resource Substitution Variance
The difference in cost when a resource specified in the work definition isn't used in the work order or when a resource that isn't in the work definition is used in the work order.
Resource Efficiency Variance
The difference in cost when the actual usage of resource is different from the one that's specified in the work definition.
Batch Size Variance
The difference in cost for items and resources that have a usage basis of 'fixed' and the quantity used in the work order.
Job Close Variance
This is used to accommodate any variances that the cost processor can't identify as one of those defined earlier. Also, if the standard cost of the product is manually setup and not through the cost rollup process, then the entire cost of components and resources is marked as job close variance.
Yield Variance
The difference between the planned output (from the work definition) and the actual output.
Work in Process Cost Adjustments
These are the work order cost adjustments.
-
Work in Process Material Standard Cost Adjustment - Captures the change in the standard cost of components for work orders that are in the Released and Completed status.
-
Work in Process Resource Cost Adjustment - Captures the change in cost of resources for work orders that are in the Released and Completed status.
-
Work in Process Product Cost Adjustment - The cost of product completions is estimated based on the provisional completions options set in the cost profile. After the work order is closed, the cost of the work order is recalculated and compared against the earlier estimated cost. The difference, if any, is accounted as cost adjustment. This cost adjustment is applicable only if the products are costed using the Actual or Perpetual Average cost methods.
-
Work in Process Scrap Cost Adjustment - Scrap can be accounted each time it's reported or at the end of the work order based on the scrap valuation option set in the cost profile. If scrap is accounted as soon as it's reported, then the actual cost accumulated in the operation till that point of time is considered. Scrap is recalculated at the work order close and if the value is different, then this cost adjustment is created.