JD Edwards Manufacturing Best Practices: Actual & Standard Costs

Configuring actual and standard costs is the first step for a smooth manufacturing workflow. In this blog post, I offer tips to determine such costs in Oracle JD Edwards (JDE).

All manufacturing companies struggle to define the unit cost of their products, even though this seems to be a simple task. Perhaps this is because determining the cost of an item is just a summary of all the incoming materials with a dash of some labor – and voila! You have the
calculated target cost.

Sounds good, right? Well, things always become more complex when you realize that the calculation of all costs is not at all straight forward. In fact, the more accurate you hope to be, the more complicated the task becomes.

You usually start by determining the standard cost of raw materials. This may seem to be easy until you ask yourself: “what happens with the bulk materials I don’t want to track?” These materials are also important in determining the total cost of the item.

If you skip this step, you’ll soon realize that the next step is to determine the labor costs. Again, you may think this is simple, but it gradually increases in complexity whenever you need more accuracy. You may start to feel like calculating an item’s standard cost will be a nightmare, so you decide that determining the item’s actual cost will be the solution to all of your problems.

Required Setup: Actual Cost

Here are the steps to follow when determining and implementing the Actual Cost method in Oracle JD Edwards (JDE):

  • Change the item cost level to ‘3.’

When you are using actual cost for your finished goods, you need to make sure that no costs of the finished goods will enter in to conflict. It’s safe to have one cost at the levels of Branch Plant, Item, Location and Lot; this combination will allow you to use costs properly.

If you set inventory cost to 02 (the average cost), consider that this cost is not supported by Oracle even though, in my experience, it would work with actual cost calculation.

  • Set Inventory Cost method for finish goods to ‘09’ (actual cost).

Remember that actual cost will not be updated unless you complete from a work order.

  • Set Purchase Cost to method 01, 02, 07, 08.
  • Add the standard routing containing all operations to build the item.
    • Add the standard BOM containing all materials to build the item.
      • Adding the standard WC rates or labor rates depends on the model you choose.
        • Freeze WC rates.

        Manufacturing Accounting Setup:

        • Configure DMAAIs.
        1. 3110 Inventory/Raw Materials
        2. 3120 Work in Process
        3. 3130 Sub-Assembly/Finished Goods
        4. 3210 Clear Work in Process (just for actual cost)
        5. 3401 Accruals

        Variance DMAAIs will not be used since the system does not record any variance from standard cost calculations that is not needed for actual cost.

        From here, you have all you need to start working with Actual Cost. With the Actual Cost method, you can add Parts list and Routing on the fly. The standard BOM and the standard routing will be added just for reference.

        Now you have to decide which cost you will use to manage your raw materials. In general, you can follow some rules to determine how the available costs in Oracle JD Edwards (JDE) can be used. In my experience, no cost method is better than 01, 02 and 07 Costs as they can be managed in JDE and used with actual cost.

        Here is a list of those costs:

        • 01 – Last In Cost: this cost is the recommended for items with no additional costs associated with the purchase of the item.

        Remember if you are using actual cost on the finish goods, 01 cost should only be used for purchased items.

        • 02 – Average Cost: use this cost when the variance of the purchase cost goes from moderate to high.

        Remember if you are using actual cost on the finish goods, 02 cost is used only for purchased items if you are using landed costs. The additional cost will not be updated to the WO once material is issued to the WO.

        • 07 – Standard Cost: use this cost when the variance of the purchase cost goes unchained during a long period.
        • 09 – Actual Cost: use this cost for sub assemblies in case they are part of the Parts List.

        There’s more to explore at Smartbridge.com!

        Sign up to be notified when we publish articles, news, videos and more!