Tuesday, May 28, 2013

Types of Costing

Summary
 
Oracle Cost Management provides several alternative cost methods.  Generally, each Inventory Organization has its own perpetual cost method.  The available methods are Standard, Average, FIFO, and LIFO Costing.  We will describe these perpetual methods first and provide some guidance on selecting the costing method.  At the end , we will discuss the optional periodic cost methods.
 
Standard Costing
 
Standard Costing is the original costing method that Oracle had for manufacturing and distribution customers.  In Standard Costing, each item has a cost defined for each inventory organization.  Different Inventory Organizations can have either the same or different standard costs.  The costs can be directly defined or rolled up from components and lower level assemblies.
 
Organizations that use Standard Costing control their cost by reviewing variances. 
 
An item that is bought with a purchase order price different from the standard cost generates a Purchase Price Variance (PPV).  If the invoice is different from the purchase order price, it generates an Invoice Price Variance (IPV). 
 
An assembly that is built has a standard cost.  Each job that produces assemblies may create variances.  Oracle separates the variances for material, resources (labor or machines), overhead, and outside processing (OSP).
 
Inventory moves around the organization and is tracked at its standard cost.  When the actual cost is different from the standard cost, a variance is created.
 
 
Actual cost methods
 
Oracle has three perpetual actual cost methods.  They are actual in that they are not based on standards.  Each of the methods is considered as Generally Accepted Accounting Principle (GAAP).  The actual methods are Average Costing, FIFO, and LIFO.  We will compare and contrast these methods.
 
Average Costing
 
Every receipt in Average Costing may change the average cost.  The purchase order receipt is valued at the purchase order price plus the material overhead that may be applied at the time of delivery to inventory.  This cost is included in the pool of costs for that item.  The total cost for the item is divided by the new quantity and a new average cost is calculated.  This new cost will be use for issue transactions of this item.  If an invoice is matched to a receipt, the IPV can be moved to inventory, changing the average cost.
 
Accounting for interorganization transfers is similar to purchase order receipt.  However, the timing of the reaveraging is based on the change in ownership (the FOB point).
 
When an assembly is completed from a job in Oracle Work In Process (WIP), the cost of the completion is relieved from the job and goes into inventory.  As with the receipt above, a new average cost is calculated.
 
Cost can be changed manually with an Average Cost Update transaction.
 
FIFO Costing (First In First Out)
 
Every delivery of a receipt in FIFO Costing creates a new cost layer.  The purchase order receipt is valued at the purchase order price plus the material overhead that may be applied at the time of delivery to inventory.  This cost is the cost for the new layer.  Each layer’s cost is kept separate but we do display a FIFO cost that is a weighted average of all the layers.  Issue transactions (consumption) will use the first layer first.  Issues that require a combination of layers are costed at the weighted average of the appropriate combination.
 
Accounting for interorganization transfers is similar to purchase order receipt.  However, the timing of the creation of layers is based on the change in ownership (the FOB point).
 
When an assembly is completed from a job in Oracle Work In Process (WIP), the cost of the completion is relieved from the job and goes into inventory, creating a new layer for the assembly. 
 
How do I pick the costing method?
 
Usually a company already has a costing method.  They will be reluctant to change their costing method because both the stock holders and the taxing bodies will need a complex explanation of the reasons and the results.  In government terms, this requirement is a Cost Impact Study.  Our job is to tailor our costing methods to help them avoid the dreaded Cost Impact Study.
 
However you may be asked the pros and cons of the different methods.  This question is similar to asking, “Which religion should I join?”  It’s a rhetorical question.  They probably want to know what cost methods we support and how well we support them.
 
 
Attributes of Standard Costing compared to actual costing.
 
Variances place the responsibility very specifically.  Each variance account can be the responsibility of a particular person.  After standards are set, job performance is primarily determined by the person’s variance.
 
Product Managers are responsible for their sales and gross margin based on standard cost.
 
Much of the accounting effort is setting standards and analyzing variances.
 
Since transactions are costed at standard costs, they can be costed before actual cost are collected.
 
Attributes of actual costing compared to standard costing.
 
Since transactions are costed at actual cost, variances are rare.  IPV can be included in the item unit cost.
 
Since items are transacted at actual cost, cost should be collected before issuing the item.  Receipts and issues are costed in the same sequence as the transactions are entered.  Allowing inventory to have a negative quantity balance may introduce variances.
 
Similarly, completions from WIP should be processed after the charges to the job.  The WIP cost processor will cost all those charges before it costs the completion transaction.  If some charges are incomplete, an algorithm provides an approximate cost.
 
Product Managers are responsible for their sales and gross margin based on actual cost.
 
Accounting effort is reduced.  Cost history and trends subtitute for variance analysis
 
 
Attributes of Average Costing
Average Costing is an actual costing method.  Transactions are costed at the average cost of the item in the Inventory Organization.
Each receipt of an item causes the item’s average unit cost to be recalculated.
IPV can be posted automatically or with a review step.
An Average Cost Updated can be used to change the item unit cost.
 
Attributes of FIFO Costing (First In First Out)
 
FIFO costing is an actual costing method.  Each receipt creates a separate layer with a separate cost. 
A Layer Cost Update can be used to change the item unit cost one layer at a time.
The issues are costed based on the assumption that the first layer  created is the first layer consumed.  The physical consumption may or may not be FIFO.
Returns create new layers rather than adjusting existing layers.
Layers of components are held in WIP jobs.
The only times the system will specify a layer are the Return to Vendor (RTV) and Assembly Return transactions.  It uses the appropriate Purchase Order Layer of WIP job.
 
Attributes of LIFO Costing (Last In First Out)
 
LIFO is the same as FIFO except that the consumption rule is opposite.
 
Perpetual versus Periodic Costing Methods
 
Each Inventory Organization must select a perpetual costing method from the four available methods.  These methods are perpetual in that transactions are costed during the accounting period.  Optionally, periodic costing methods can recost the transactions without disturbing the original cost.  Although preliminary periodic costing can be run during the period, the final periodic costing is run after the accounting period close.
 
Periodic Costing
 
Periodic Average Costing (PAC) and Incremental LIFO costing are optional cost methods.
One or both can be cost all the transactions in a period without disturbing the perpetual costs.  Each periodic costing method can create one or more user defined cost types.  The cost types may differ from each other by calendar, rates, or status (open period).
 
Only one cost type should be transferred to General Ledger.  In Brazil, some companies use monthly PAC and do not distribute their perpetual costing method’s transactions.  The system provides strong warning if more than one cost type has a transfer to General Ledger enabled.
 
Incremental LIFO is only used in Italy.
 
Periodic Costing can be the most accurate costing method.
By recosting after the period, you can
·         Match invoices to receipts including additional invoices for freight, duty, and tax.
·         Use fully absorbed resource rates based on the actual costs and actual usage.
·         Use fully absorbed overhead rates.
·         Recost all the jobs based on the just calculated costs of components.
 
You can combine inventory organizations within a Legal Entity to arrive at a periodic average cost for that Organization Cost Group.
 
You can specify periods of a month, quarter, year, or all three.
You can set up cost types with different rates.
 
You can use the PAC cost to set standard costs or compare them to your perpetual actual cost.
 
Remember: Only one cost type should be transferred to General Ledger.  A perpetual costing method must be specified and may be used to provide management information during the period.  If you intend to transfer a PAC cost type to General Ledger, do not transfer the perpetual methods cost type to General Ledger.
 
 
Summary
 
Oracle Cost Management cost all transactions in manufacturing and does the accounting for these transactions.  Costing can occur immediately after the transaction or can be over a year later.  Besides Standard Costing we provide several different actual costing methods.

Sunday, May 5, 2013

Difference between Create Accounting - Cost Management and Create Accounting – Receiving


What is the difference between Create Accounting - Cost Management and  Create Accounting – Receiving?
     A)    Create Accounting - Receiving belongs to Purchase Module - Added to Cost Management Module - It processes transactions from Receiving Subledger. 

"Create Accounting - Receiving" only accounts for Expense destination PO Receipt. 
Create Accounting - Cost Management request creates accrual journal entries, accrual reversals, and multi-period journal entries. 
The transaction will then be passed to GL via the Create Accounting – Cost Management program. 
The process categories for this include: 
Inventory  ,Manual,  Receiving,  Third Party Merge,  Work in Process 


"Create Accounting - Cost Management" accounts for all transactions costed by EBS Cost Management, which includes:  - Expense destination PO Receipt  ,All Inventory transactions including inventory destination POs  , WIP transactions, Accrual Write Off transactions



 Note:

 Create Accounting - Receiving is a wrapper to include an additional parameter application_id (for PO in this case), because Costing is creating accounting for the whole SCM and different applications.

When you run Create Accounting - Cost Management, you are supposed to run it from a responsibility associated with application_id=707 (cost management). In this case, it will process all accounting events from Inventory, WIP, and Receiving (defined by their SLA event entity).

When you run Create Accounting - Receiving, it will only process the accounting events from Receiving

Thursday, May 2, 2013

Lot Split & Merge



Lot Split & Merge


1) How are lot split and lot merge and lot and serial genealogy supported in inventory organizations?

     Lot split and merge and are supported in Oracle Inventory and Oracle Warehouse Management organizations and they are available only when Oracle Warehouse Management is installed. Lot and serial genealogy are supported in both Inventory and Oracle Warehouse Management organizations. 


2) How do you perform a manual split and an autosplit?

    You can perform a manual split and autosplit in the same window. To perform an autosplit, in the start page, enter the Num Lot field or Ea Lot Qty field, then the <Auto Split> button appears. Select <Auto Split>. On the next page, the system generates the resulting lots and calculates the resulting quantity automatically. When you perform an autosplit, you cannot change the resulting quantity for each resulting lot and the starting lot must split into at least two resulting lots.

To perform a manual split, from, the Start page, skip the NUM Lots and Ea Lot Qty fields, and select <Save / Result>. The Result page opens. In the Result page, you generate the lot and enter the result request manually. You can split the lot in to another lot with manual splitting.

3) When should full lot splits be used, and when should partial lot splits be used?

    The ability to split lots into new lots allows for more exact inventory tracking by lot attributes. If some key lot attributes for a quantity within a lot no longer match the attributes of the rest of the lot, then that portion of the lot should be split into a new lot. In this example, should you have a partial quantity lot split, or a full quantity lot split?

Proposed solution: In this situation you should perform a partial quantity lot split. This places the quantity that has different lot attributes into a new lot. The quantity that still has the same lot attributes remains in the same lot number.

When new lots are created at WIP Completion, the quantity at the parent lot will usually be fully split into the child lot.

4) What cost group is associated with the new lot formed during lot split?

     During lot split, the cost group of the parent low is assigned to the new lot.

5) What lot attributes are carried over to the resulting lot when two lots are merged?

    When two lots are merged the resulting lot takes the attributes from the lot that has the higher quantity. When two lots of the same quantity are merged, the lot attributes of the first parent lot are carried over to the resulting lot.

6) Can two lots of different items be merged?

   No, this not currently supported.

Saturday, January 19, 2013

Overview of Supply chain management


Supply chain management (SCM) is the management of a network of interconnected businesses involved in the provision of product and service packages required by the end customers in a supply chain. Supply chain management spans all movement and storage of raw materials, work-in-process inventory, and finished goods from point of origin to point of consumption.

Supply chain management is the control of the supply chain as a process from supplier to manufacturer to wholesaler to retailer to consumer. Supply chain management does not involve only the movement of a physical product through the chain but also any data that goes along with the product (such as order status information, payment schedules, and so) and the actual entities that handle the product from stage to stage of the supply chain. 

There are essentially three goals of SCM:

  •  To reduce inventory
  •  To increase the speed of transactions with real-time data exchange,
  •  And to increase revenue by satisfying customer demands more efficiently.



    WHAT IS BASIC COMPONENT OF SCM?


    As per Supply-Chain Operations Reference-model  which has been developed by Supply-Chain Council. This model organized and focused on the five primary management

    1.      PLAN
    2.      SOURCE
    3.      MAKE
    4.      DELIVER
    5.      RETURN

    1. Plan: This is vital part of SCM philosophy, where the companies normally need to make strategy for managing all the resource that go towards fulfilling the customer demand for the product and services that they offers. A big piece of planning is developing a set of matrices to monitor the Supply chain so that it would be efficient, cost effective and deliver high quality and value to the customer.

    2. Source: It means processes that procure goods and services to meet planned or actual demand. This part of SCM consists of selecting right suppliers that will deliver the good and services that need to create your product. Developing a set of pricing, delivery and payment process with supplier is important. Also this will also take care of managing the inventory of goods, and services you receive from your suppliers, including receiving shipping, verifying them, transferring them into various facilities and authorizing supplier payment.

    3. Make: This is basically a step where your company starts fulfilling the request or BUILT for products into finished state to meet planned or actual demand. Schedule activity necessary for production, testing, packaging and preparation for delivery.

    4. Deliver: This is also called Logistic Process. This is the processes that provide finished goods and services to meet planned or actual demand, typically including order management, transportation management, and distribution management.

    5. Return - This is real pain of SCM model, which defined as processes associated with returning or receiving returned products for any reason.