CHEM10: Reduce unnecessary discounting by evaluating competitive price match requests

📽️ Check out a video demonstration for this use case, here.

Use Case Situation Description

Reducing unnecessary discounting through competitive price match evaluation offers streamlined profitability, maintaining pricing integrity while meeting customer expectations. This approach prevents profit erosion, promotes consistent pricing, and preserves brand value. It enhances profit margins, minimizes revenue loss, and ensures competitiveness without compromising business sustainability. In this use case, we will look at how you can do that in Pricefx.

User Role(s) and Business Objective

Sales or Pricing Analyst, Sales Representative, Pricing or Product Manager 

Business Objective

Our business has numerous customers who are priced on a market basis for a product, and many of them split their business across multiple suppliers.  From time to time, competitors may seek to take business from us by lowering price in situations where like products are being sold.  We need a way to evaluate these situations quickly for proper customer response to retain business. 

Complication

When a customer calls our sales representative presenting a competitive price challenge, they expect us to know our business and markets and to be able to provide an immediate response.  Sales must present the situation via phone or email to our pricing and product teams, and it seems to take forever to get a response, sometimes costing us valuable business when the customer gets impatient and moves on to do business with the competitor.  Delays on our end occur due to many factors, including lack of comparative pricing data, availability of people, and things just getting lost in messaging and communication systems.   

Capability Needed

A way to submit a price request that will get a rapid response by providing automated analysis of the competitive situation, using relevant pricing data from similar customers, and getting the immediate attention of any needed approvers.  

Benefit(s)

Existing business will be retained at appropriate pricing levels. 

KPIs

For these situations, (1) a measure of total volume, revenue, gross margin, or contribution margin at risk (for the specific deal, and cumulatively), and (2) cumulative win/loss percentage. 

Calculations
  • Total volume = Total pounds., kilograms, Metric Tons, square feet, or gallons from sales records 

  • Total revenue = Sum of volumes * selling price 

  • Total gross margin = Total revenue – rebates – total cost 

  • Total contribution margin = Total revenue – rebates – total variable cost 

  • Win/loss percentage = (Total deals won / Total opportunities) * 100 


Prescriptive Design Requirements

As a [Pricing Manager/Sales Rep], I want to reduce unnecessary discounting by evaluating competitive price match requests so I can quickly respond to customers and make sure:

  • customers are priced on a market basis for a product

  • evaluate market changes quickly for proper customer response to retain business. 

The overall design requirements are summarized in these articles:

Functional and Non-functional Requirements

These are the functional requirements for this use case:

Complication:

When a customer calls our sales representative presenting a competitive price challenge, they expect us to know our business and markets and to be able to provide an immediate response.  Sales must present the situation via phone or email to our pricing and product teams, and it seems to take forever to get a response, sometimes costing us valuable business when the customer gets impatient and moves on to do business with the competitor.  Delays on our end occur due to many factors, including lack of comparative pricing data, availability of people, and things just getting lost in messaging and communication systems.  

Capability Needed:

A way to submit a price request that will get a rapid response by providing automated analysis of the competitive situation, using relevant pricing data from similar customers, and getting the immediate attention of any needed approvers.   

Benefit:

Existing business will be retained at appropriate pricing levels.  

KPIs:

For these situations, (1) a measure of total volume, revenue, gross margin, or contribution margin at risk (for the specific deal, and cumulatively), and (2) cumulative win/loss percentage.  

  • Calculations:  

    • Total volume = Total pounds., kilograms, Metric Tons, square feet, or gallons from sales records 

    • Total revenue = Sum of volumes * selling price  

    • Total gross margin = Total revenue – rebates – total cost

The following sections should be available to the calculation results of the quote on line item level: 

image-20230822-115907.png

When revising a deal, per line the current active quantity (per approved deal) and the delta quantity (per revision) should be visible. Similar for the invoice price and the margin / margin %.  

image-20230822-115945.png

Another section should contain competitor pricing. It should show the median, plus the lowest competitor price. Showing the 5 competitors will show a list with the corresponding prices. 

image-20230822-120019.png

The analytics section will show the following elements: 

  • Margin alert gauge 

  • Inline analytics chart that shows a bar chart over time with the revenue and the average price of the period for that product and customer combination 

  • Inline analytics for benchmark chart: this shows a scatter chart that has different transactions for a period of time (last 3 months) for this product, with the price and volume on the axis 

  • Margin break-even:

    image-20230822-135221.png
  • This chart shows the quantity vs. revenue (absolute) and plotted what the delta in volume should be with the new (lower) price to land on the same absolute margin. 

  • Margin break-even: similar as the previous one, but then showing the margin (absolute) instead as revenue (absolute)

    image-20230822-135303.png
  • Header waterfall showing a general overview of the header waterfall of the revised agreement

image-20230822-135356.png
  • Item waterfall showing an overview of the item waterfall of the revised item 

Non-functional requirements

This use case has as a prerequisite that CHEM01 - Improve long-term agreement profitability by automating complex formula-based pricing, or CHEM09 - Improve margin, speed, and quote win rate with guided selling and decisions support, have been implemented. CHEM10 is an extension of these. 

Reporting and Dashboards

This use case has the dashboards and reports as described in the functional requirements section. You can check them all here.

Measures, Calculation and Decision-making KPIs

See the user stories for relevant measures, here.

Scope Validation and Project Readiness

During the scope validation process we are ensuring that the project deliverables are completed according to the agreed scope and quality standard by asking the following questions.

Scope Validation and Project Readiness Workshop – Validation Questions & Answers: 

Q1: For competitive analysis, do you have regional competitive data? (e.g. sales region, channel) 

A1:

Q2: For sales analysis, are there any regional attributes to take into account when benchmarking prices? (e.g. sales region, channel) 

 A2:


User Stories

These are the user stories and epics that make up this use case.

Epic: Information revision at header level

As a Sales Rep/Pricing Manager/Pricing Administrator, when I’m revising my agreement, I want to have inline analytics to view several decision supporting metrics to compare the new price to the previous price.

User Story Name - Revision information on header level

I want to: See the difference on deal header level in several basic metrics like price between the active price and the revised price 

so I can: Use this information to make a decision 

Acceptance Criteria:

In the header calculation results I have a section called ‘Revision’ that has the following metrics (active = from current active agreement; delta = revised agreement -/- active agreement): 

  • Active quantity 

  • Delta quantity 

  • Active Invoice Price 

  • Delta invoice price 

  • Active margin 

  • Delta margin 

  • Active margin % 

  • Delta margin % 


User Story Name - Competitor information on item level 

I want to: See the prices of my competitors on line item level  

so I can: Use this information to properly position my price against the competition 

Acceptance Criteria:

Metrics to be shown are, all for the same product: 

  • The median price of all competitors 

  • Top 5 competitors including their prices in a pop-up 

  • The lowest competitor price


User Story Name - Margin alert 

I want to: See a margin gauge on line item level 

so I can: Quickly see if this item meets the margin targets 

Acceptance Criteria:

  • There is a company parameter table allowing me to show margin % thresholds per product group to be used in this gauge 

  • The gauge has three areas, red, amber and green 


User Story Name - Inline analytics 

I want to: See on line item level a bar chart over time with revenue and price information 

so I can: Make a good judgement of the new price looking at volume and price trends 

Acceptance Criteria:

  • Clicking the link opens a time series bar chart with for that customer/product combination the revenue per month for the last 24 months, plus the average price per month 


User Story Name - Inline analytics for benchmark 

I want to: See a scatter chart for each transaction for this product  

so I can: See all prices and related volumes for which this product is sold 

Acceptance Criteria:

  • Clicking the link opens a scatter chart, showing all transactions for this product over the last three months, showing the price and the volume 


User Story Name - Revenue break-even

I want to: See a line chart showing how much the volume must increase to have the same revenue 

so I can: Judge whether the new price will deliver the same revenue 

Acceptance Criteria:

  • Clicking the button opens a line chart, with the price and quantity on the axis 

  • There are two lines: one for the current price vs the volume, and one for the new price vs the volume 

  • Highlighted are: 

  • the current price and the current volume 

  • the new price and the break-even volume (this is calculated based on the current absolute revenue, divided by the new price per unit) 


User Story Name - Margin break-even

I want to: See a line chart showing how much the volume must increase to have the same margin 

so I can: Judge whether the new price will deliver the same margin 

Acceptance Criteria:

  • Clicking the button opens a line chart, with the price and quantity on the axis 

  • There are two lines: one for the current price vs the volume, and one for the new price vs the volume 

  • Highlighted are: 

  • the current price and the current volume 

the new price and the break-even volume (this is calculated based on the current absolute magin, divided by the new margin per unit) 


User Story Name - Header waterfall 

I want to: See the header waterfall of this agreement 

so I can: Use this overall header information in my pricing decision 

Acceptance Criteria:

  • Clicking the button opens the waterfall of this complete agreement 

  • Only waterfall items that are available in Pricefx can be show (e.g. if rebate information is not available yet, this cannot be part of the waterfall) 

  • A typical waterfall will include the list price, the invoice price where the discount can be back calculated, and the margin based on the cost of the item 


User Story Name - Item waterfall 

I want to: See the item  waterfall

so I can: Use this item information in my pricing decision

Acceptance Criteria:

  • Clicking the button opens the waterfall of the selected item 

  • Only waterfall items that are available in Pricefx can be show (e.g. if rebate information is not available yet, this cannot be part of the waterfall) 

  • A typical waterfall will include the list price, the invoice price where the discount can be back calculated, and the margin based on the cost of the item – this waterfall will not be as complete as the price analyzer waterfall 

Epic: Inbound data for vizualization in dashboards

As a Sales Rep/Pricing Manager/Pricing Administrator I want to forecast data so I can use it in further analysis.

User Story Name - Competitive data

I want to: I want to store forecast data on product level in Pricefx 

so I can: So I can use that in my analysis 

Acceptance Criteria: Data to be loaded in Pricefx Data Source table either manually through Pricefx Excel Client, or automatically integrated via using CSV file placed on a Pricefx dedicated SFTP folder on a pre-agreed frequency.  

Must have column definition: Date, Competitor ID, Competitor Name, Product-id, price, currency 


User Story Name - Invoice line items

I want to: I need to have my invoice line items

so I can: Use this data is several metrics  

Acceptance Criteria: Data to be loaded in Pricefx Data Source table either manually through Pricefx Excel Client, or automatically integrated via using CSV file placed on a Pricefx dedicated SFTP folder on a pre-agreed frequency. 

Must have column definition: Unique transaction ID, Date, Customer-id, Document type, Product-id, quantity, all relevant waterfall elements 


User Story Name - Cost data 

I want to: I want to store cost data on product level in Pricefx 

so I can: So I can use that to project margins 

Acceptance Criteria: Data to be loaded in Pricefx Data Source table either manually through Pricefx Excel Client, or automatically integrated via using CSV file placed on a Pricefx dedicated SFTP folder on a pre-agreed frequency. 

Must have column definition: Date, Product-id, cost per unit, currency


Data Requirements

The following tables can be either manually loaded in Pricefx via Pricefx Excel Client or can be automatically integrated using CSV files in a Pricefx dedicated SFTP folder: 

  • Price Waterfall data (typically based in invoice line items) 


Out-of-Scope

Out-of-scope business functions and features can be configured, but are not included in the Chemical Industry Catalog.

  • Implementing quotes or agreements; this use case is an add-on to CHEM01 - Improve long-term agreement profitability by automating complex formula-based pricing, and/or CHEM09 - Improve margin, speed, and quote win rate with guided selling and decisions support.

  • Any Reporting and Dashboards, other than the ones explicitly mentioned above 

  • Notifications and alerts 

  • API method integration 

  • Customer-Facing templates 


Solution Design

The solution design for this use case is still in progress and will be published as soon as it becomes available.