Material Costing
      Back to home
      1. LearnCQ
      2. QuoteCQ
      3. Material Costing

      QuoteCQ: How to compare the ERP price vs. the Quoted price

      Comparing current pricing against the last buy price is important to negotiate better deals with your vendors. Here is how QuoteCQ can help you on streamlining this process.

      Previous considerations and concepts

      • The ERP price is the same as the unit price for a certain component you bought from a certain supplier, captured in your ERP system. 
      • When negotiating, the goal is to get that certain component at a better price; meaning we negotiate to get a price that is lower than the current price I bought the component for. 
      • In other words, we could also say that, when negotiating, the ERP Price or Current Price is like the target price.
      • Comparing your current component price against the new price you're quoting will give you visibility on the market situation, as well as it will help you to negotiate with your current vendor or make decisions on your preferred suppliers changes.

      Here is how you can do this using QuoteCQ:

      1. Populate your ERP Price (Target Price) in your BOM.

        There are two ways you can populate the Target Price in your Bill of Materials:

        1. Add a column in your BOM file to indicate the target price per line.
        2. Use an FTP Data Source to connect your ERP information and populate automatically the Target Price information per line.
      2. Use the material costing tab as usual.
        Run the APIs, send Bid Sheets, use Manual Pricing, Historical Pricing or any other source of information, and make selections among the collected data.
      3. Make selections using the Target Price filter
        Upon clicking in AutoSelect > Advanced Options, use the Filter For > Price to limit the supplier selections to those whose unit price is lower than your target price.
      4. Use the Target Price Variance information to compare or make decisions based on the target price (ERP) against the quoted information.
        1. CQ Price Selector (CQPS) 
          In the CQPS Screen, there are three columns available for the Target Price: Target Price, Target Price Variance $, and Target Price Variance %.
        2. Auto Select lines to be sent based on target price variance value
        3. In the Review tab, the Negative Target Price Variance filter will display the line items where the selected price is higher than the target price.

      In summary, this function will allow you to identify what items you can get a lower price for than the price you lastly paid, as well as negotiating with your current vendors lower prices.