As RFQ responses come in, you can potentially see the various results comparative to your "Ref Savings". You’ll see this in the Spend and Savings tab within your RFQ's Responses page in Quoting.
Calculations
Calculations are done at line level and aggregated here for the entire RFQ. Depending on the number of formulas, you can continue scrolling right to view all of the available results. If one of the fields in the formula is blank, then the formula will not calculate.
More information on the Spend and Savings equations utilized for calculations are available by clicking on the "?" tooltip. This will open the "Spend and Savings Equations" in a side bar on the right and provide you with access to the underlying calculations.
Set Criteria
By default, the Savings & Spend formulas are calculated based on Unit Cost price (Quote Price * Markup). Additional functionality allows you to calculate savings based on another custom column of your choice by clicking on Set Criteria.
Click on the "Select Column" dropdown to choose the column you want to be used for the Savings calculations. Then click on Save to finish modifying your Set Criteria selection.
For example, if you are looking to add other costs to the Quote Price, and thereby create a Total Cost (custom column), then you can choose to see the Savings calculated based on this Total Cost. To add additional custom columns to the “Set Criteria” modal, as an admin you will need to enable the “Available to Scenarios” option under the Internal Rule in demand and part category templates.
Refresh Savings Formulas
To allow you to control when the Spend and Savings calculations should update, you must click on the Refresh Savings button to trigger updates whenever prices, ref prices, ref quota or quotas change.
The usage of “Ref” in the formula title refers to the "Ref. Quota" being used in the calculation (e.g. Ref A2A Savings). Formulas for calculations at line level that aggregations are based on:
- REF A2A SAVINGS % : REF A2A SAVINGS / REF A2A SPEND * 100
- REF AUC SAVINGS % : REF AUC SAVINGS / REF AUC SPEND * 100
- A2A SAVINGS % : A2A SAVINGS / A2A SPEND * 100
- AUC SAVINGS % : AUC SAVINGS / AUC SPEND * 100
- REF A2A TARGET SAVINGS %: REF A2A TARGET SAVINGS / REF A2A SPEND
- REF AUC TARGET SAVINGS % : REF AUC TARGET SAVINGS / REF AUC SPEND
- REF A2A SPEND : Ref. Unit Cost * Ref. Quota / 100 * Qty 1
- REF A2A SAVINGS: (Ref. Unit Cost - Unit Cost) * Ref. Quota / 100 * Qty 1
- REF AUC SPEND: Ref AUC * Ref. Quota / 100 * Qty 1
- REF AUC SAVINGS: (Ref AUC - Unit Cost) * Ref. Quota / 100 * Qty 1
- REF ACTUAL SPEND: Unit Cost * (Ref. Quota/100) * Qty
- ACTUAL SPEND: Unit Cost * Quota / 100 * Qty 1
- EXCESS COST: (Orderable Qty - Requested Qty) * Unit Cost * Quota / 100.
- A2A SAVINGS: (Ref. Unit Cost - Unit Cost) * Quota / 100 * Qty 1
- A2A SPEND: Ref. UC * Quota / 100 * Qty 1
- REF A2A TARGET SAVINGS: (Ref. Unit Cost - (Target Price * Markup)) * Ref. Quota / 100 * Qty 1
- AUC SPEND: Ref AUC * Quota / 100 * Qty 1
- AUC SAVINGS: (Ref AUC - Unit Cost) * Quota / 100* Qty 1
- SAM (Supplier Applicable Market): sum(Spend) for the supplier selected or for the supplier selected and their competitors, where Spend = Ref AUC for an IPN, Plant & Subcontractor group
- Qty 1 (This is visible whenever a supplier has been selected from under the Suppliers tab.)
The "Ref. Price 1 Savings" and "Market Price 1 Savings %" are shown only at the line level in the Supplier Responses table.
- Ref Price 1 Savings = 100 - [(Price 1 / Ref. Unit Price)*100]
This type of savings does not take into account "Quota", as it is just showing the percentage change from what the price supplier responded with in the "Ref. Unit Price".
- Market Price 1 Savings % = 100 - [(Price 1 / Web Price)*100]
- Market Trend is displayed as it is recorded in BOM Insight with a percentage representing an increase or decrease. This refers to 1M Market Trend, currently shown on part intelligence.