Valuing Inventories in SAP using Mixed Costing

Valuing Inventories in SAP using Mixed Costing

Overview

Mixed Costing allows customers to cost materials as a mix of multiple procurement sources. As a simple example, Mix Product cost of a procured material could be the weighted average of purchase price from multiple vendors (i.e. vendors is “procurement alternative” for Mixed Costing). SAP allows you to define the weightage for each procurement alternative. This Product cost using Mixed Costing would be more representative of the cost of the material as opposed to (for example) selecting the Purchase Price of any single vendor.

 

Assumptions for this blog

I will assume you have already configured SAP Product Costing; I will only demonstrate that part of configuration necessary to explain the scenario in this blog. The demo system I used for this blog is set up for Material Ledger; this setup is not mandatory to execute this scenario. This blog will demonstrate scenario for Legal / Company Code currency valuation; this scenario and result will apply similarly to the other valuations.

 

What am I demonstrating

In this blog, I will demonstrate how Mixed Costing works in SAP. I will use a simple example of Mixed Costing of a procured material. The concept will work very similarly for a manufactured product.

I will use the example of Product “Bomber Jacket 8” I used in another blog “Valuing Inventories using Purchasing documents”. To keep the two blogs independent, I will repeat some of the data, and master data set up in this blog.

 

Purchasing Info Record

The retail company in our scenario sources product “Bomber Jacket 8” from 3 vendors. The Purchasing Info Record for the 3 Vendors is shown below.

Xi Chi Dong in China

Purchasing Info Record for Vendor 75011

 

Deshbandhu Industries in Bangladesh

Purchasing Info Record for Vendor 75012

 

Southern Cross Clothing in Australia

Purchasing Info Record for Vendor 75013

 

The summary of Purchase cost is as below

Summary of Purchasing Info Records

 

Steps to set up Mixed Costing

  1. Display / Define the Quantity Structure Type for Mixed Costing
  2. Define Costing Versions for Mixed Costing
  3. Define the Procurement Alternatives
  4. Define the Mixing Ratios
  5. Execute Product Costing Estimate for the material

 

Display / Define the Quantity Structure Type available for Mixed Costing

You can display this in configuration menu as below.

[IMG] Controlling > Product Cost Controlling > Selected Functions in Material Costing > Mixed Costing > Define Quantity Structure Types

Quantity Structure type for Mixed Costing

Quantity Structure type for Mixed Costing

You will not require to make any changes to this table. It defines an entry “MIX” for Mixed Costing; the quantity structure defined for each material is modifiable and valid for the fiscal year only (i.e. you have to create a new Mixed Costing Ratio every year) and it will check whether the total of procurement mixing ratio is 100%. This standard configuration so defined is sufficient.

 

Define Costing Versions for Mixed Costing

[IMG] Controlling > Product Cost Controlling > Selected Functions in Material Costing > Mixed Costing > Define Costing Versions

Costing Versions

Costing Versions

This configuration would already be set up for Product Costing of all materials. The only change is to add value “MIX” in the Quantity Structure Type 1 field. This field expects a value for quantity structure for Mixed Costing. We have defined the value previously as “MIX”.

 

Define the Procurement Alternatives

[SAP Menu] Accounting > Controlling > Product Cost Controlling > Product Cost Planning > Material Costing > Master Data for Mixed Cost Estimate > Edit Procurement Alternatives

Transaction Code: CK91N

Here we define the various sources of “procurement alternatives” of the material. “Procurement” is defined by the field Process Category. In this field you can define the following procurement/ process categories:

Define Procurement Alternatives for Mixed Costing

Define Procurement Alternatives for Mixed Costing

 

  • BB Purchase Order: Procurement alternative for purchase orders using vendor and purchasing organisation. If you do not enter vendor, it will pick price from Material Master
  • BBV Procurement (change involving stock): Procurement alternative using opening stock of the material
  • BF Production: Procurement alternative for in-house production using Bill of Material (BOM), and Routing
  • BL Subcontracting: Procurement alternative for subcontracting using Bill of Material (BOM), and (optionally) vendor and purchasing organisation
  • BU Stock Transfer: Procurement alternative if you source most volumes from another plant

For the purpose of this blog, I will use Purchase Order as the process category to perform Mixed Costing. I have used the above 3 vendors as Procurement Alternatives.

Define your Procurement Alternatives

Define your Procurement Alternatives

 

Define the Mixing Ratios

[SAP Menu] Accounting > Controlling > Product Cost Controlling > Product Cost Planning > Material Costing > Master Data for Mixed Cost Estimate > Mixing Ratios > Create/ Change

Transaction Code: CK94

Define your Mixing Ratios

Define the mixing ratio for the procurement alternatives you defined in the previous step. Mixing Ratio is defined by:

  • Material
  • Plant
  • Fiscal Year – we configured this in step 1
  • Quantity Structure Type “MIX”

You define the percentage mixing ratio. The total should be 100% else it will give an error message. The indicator in “MR” column will default if the ratio is not zero. If the ratio is zero, you can select the “MR” indicator. This indicator will define whether the procurement alternative should be included in the cost estimate. Since the ratio is zero, the procurement alternative will appear in the cost estimate as “information” with zero dollars. If you deselect the indicator it will not appear in the cost estimate at all.

Execute Product Costing Estimate for the material

Transaction Code: CK11N or CK40N

Cost Estimate for Mixed Costing-result

Cost Estimate for Mixed Costing-result

When you execute the cost estimate for the material, it will calculate the weighted average cost of the material based on the mixing ratios. The Itemisation and Costing Structure will list the Procurement alternatives against which “MR” indicator was selected in step 4.

You will notice an indicator “Mixed Costing” on the top right corner of the Cost Estimate screen.

Once a product is costed, the subsequent steps to save, review, mark, and release are the same as the Cost Estimate process for any other material.

 

Conclusion

You can selectively use mixing ratio for specific materials that are procured from multiple sources to estimate a more accurate Product Cost for the material. The functionality allows you to mix production as procurement alternative. Hence, for example, for a material that is partially produced in-house and partially subcontracted and partially procured as a finished product, you could set up the Procurement Alternative to reflect the material cost as a weighting of the mixing ratio from the multiple “procurement alternatives”.

 

Please Share

I hope this blog has helped you understand the functionality of Mixed Costing. Please do leave your comments below whether this article was helpful; and whether you have any suggestions/ comments; or if you would like to share your experience.

I strongly recommend you share this blog with your network using one of the social media icons at the top or bottom of this page.

You should subscribe to a newsletter from this blog using the rss icon on the top right of this page. You will receive an email when new content is published on this website.

—————————————————————

Rajesh is an accomplished and successful Finance professional with over 20 years experience in Finance processes and related technologies. He is a qualified accountant; he has worked in Finance departments of multinational companies. With this strong foundation in Finance, he has managed to successfully implement best-in-class Finance processes in IT (primarily SAP). Over the last few years, Rajesh has led Finance teams on large SAP implementations and provided his insights and experience to provide a workable and an improved solution for his customers. Rajesh is a SAP Certified Application Professional.

Comments

  1. Dear Rajesh,

    Thanks for your posting, this blog is very useful.
    We have 2 production plants and 1 selling plant. The products will be transferred from each production plant to the selling plant. We want the product standard in the selling plant is the average of the 3 standard costs of production plants. So I use mix costing in the selling plant following your steps, but the process category I choose Stock Transfer, and fill the production plants. When I run ck11n in the selling plant, the result is not as expected. I expect it will calculate/average from the standard cost of the respected production plant. But the result is the existing standard cost of the selling plant divided by the ratio.
    eg. Existing std cost in selling plant is $ 800. Std costs in production plants are $500 and $700, with ratio 50 : 50, I expect the result of ck11n in selling plant is $600 with item 1 $250 and item 2 $350. But the result is $800 with item 1 $400 and item 2 $400. What is wrong ? Pls help. Thanks.

    Best regards,
    Naning

Leave a Reply

CommentLuv badge