All Collections
Material Costing
Add weighted Price (TCO management) to individual Material
Add weighted Price (TCO management) to individual Material
Krishna Patel avatar
Written by Krishna Patel
Updated over a week ago

In order to add weighted prices automatically to material prices, first you need to defined the rule in Weighted Price Rules in the configurations. The following drivers are available for define the rules:

  • MFGR

  • Part Class/Part Type

  • Supplier

  • In Stock

  • Lead Time

  • NCNR

  • Authorized Reseller

  • Excess QTY

  • Payment Terms

  • Preferred Supplier

  • Customer.

  1. Navigate to Configuration > Materials > Weighted price rules.

2. Click on ‘+’ to add new rule.

  • Name the rule.

  • Define the percentage. This percentage can also be defined as a negative value.

  • Then select the desired driver and logic and save it.

  • You can also edit the pre-defined rules.

After updating pricing for the parts, the weighted price is automatically added to the Material Price based on the defined rules. You will see the following information in the CQPS screen:

  • TCO Price Percentage: sum of percentages based on rules if it satisfied the conditions defined in the Weighted price rules.

  • TCO Drivers: shows name of drivers who are satisfied the conditions.

  • TCO Unit Price: Weighted price calculated as Unit Price * (1 + {precentage})

  • TCO Total Price: Weighted total price calculated as Unit Price * Order QTY * (1 + {precentage})

Note: Users need to enable TCO Price Percentage, TCO Unit Price, TCO Total Price, and TCO Drivers columns from the grid to observe the results.

Did this answer your question?