Pricing & Quoting Intelligence
Restoring Pricing Discipline Across a 48-Person Sales Organization
Industry
Industrial & MRO
Scale
$265M Revenue
Duration
20 Weeks
Location
Columbus, Ohio
Engagement
AI Consulting
Executive Summary
The VP of Commercial Operations at a 14-branch industrial distributor in Columbus, Ohio had watched gross margin decline for five consecutive quarters while revenue grew steadily. The root cause was structural: 48 sales reps pricing by instinct through a Prophet 21 system whose pricing matrices hadn't been recalibrated in over two years. We embedded pricing and quoting intelligence directly into the existing ERP, delivering measurable margin recovery within two quarters.
Business Impact
+160bp
Gross margin improvement
29%
Faster quote turnaround
11%
Revenue per rep increase
24%
Discount variability reduced
The Situation
The distributor served manufacturing, maintenance, and facility management customers across multiple states. Revenue grew at 4-6% annually, but gross margin had eroded in each of the last five quarters — a pattern leadership traced to the quoting process, not the market.
Margin leakage was behavioral and structural — not market-driven.
- Discount behavior varied by up to 800 basis points between highest and lowest-margin reps on the same categories
- Pricing approval required manager sign-off below a threshold so low that most quotes passed without review
- Quote turnaround on complex orders averaged 2.6 days — too slow for competitive project bids
- Account profitability was shared monthly as a PDF that branch managers admitted they skimmed
- Cross-sell identification depended entirely on individual rep knowledge with no systematic replication
- Prophet 21 captured every transaction but generated no forward-looking intelligence from it
The data to solve the problem existed inside the ERP. Nobody was using it at the point of decision.
The Challenge
Forty-eight reps were making thousands of pricing decisions weekly with no structured guidance at the moment the decision was made. Margin feedback arrived after the fact — in monthly reports and quarterly reviews — weeks after the damage was done.
The pricing matrices were stale, built on cost-plus multipliers that hadn't been recalibrated in over two years. The approval process added friction without adding intelligence — managers approved on instinct, the same thing reps were doing one level down.
- Pricing guidance was static while costs, competition, and customer behavior had all shifted
- Margin visibility was retrospective — leadership saw erosion in the P&L, not at the point of quote
- The approval workflow slowed complex quotes without improving pricing quality
The Solution
We analyzed 24 months of transaction-level data across all 48 reps and 14 branches. The analysis confirmed that competitors weren't forcing prices down — the distributor's own pricing habits were. Intelligence was embedded directly into the Prophet 21 quoting workflow, surfacing margin impact on the same screen where the rep built the quote.
The system analyzed signals including:
- Transaction-level pricing across 48 reps, 14 branches, and 27 months of history
- Win/loss patterns correlated with pricing levels and response time
- SKU-level contribution margin by customer segment and purchasing volume
- Discount cadence by individual rep — depth, frequency, and product patterns
- Account-level purchasing trajectory and growth signals
- Competitive pricing benchmarks where available
Intelligence surfaced at the point of decision — not after the order was shipped.
The Challenge
Forty-eight reps were making thousands of pricing decisions weekly with no structured guidance at the moment the decision was made. Margin feedback arrived after the fact — in monthly reports and quarterly reviews — weeks after the damage was done.
The pricing matrices were stale, built on cost-plus multipliers that hadn't been recalibrated in over two years. The approval process added friction without adding intelligence — managers approved on instinct, the same thing reps were doing one level down.
- Pricing guidance was static while costs, competition, and customer behavior had all shifted
- Margin visibility was retrospective — leadership saw erosion in the P&L, not at the point of quote
- The approval workflow slowed complex quotes without improving pricing quality
The Solution
We analyzed 24 months of transaction-level data across all 48 reps and 14 branches. The analysis confirmed that competitors weren't forcing prices down — the distributor's own pricing habits were. Intelligence was embedded directly into the Prophet 21 quoting workflow, surfacing margin impact on the same screen where the rep built the quote.
The system analyzed signals including:
- Transaction-level pricing across 48 reps, 14 branches, and 27 months of history
- Win/loss patterns correlated with pricing levels and response time
- SKU-level contribution margin by customer segment and purchasing volume
- Discount cadence by individual rep — depth, frequency, and product patterns
- Account-level purchasing trajectory and growth signals
- Competitive pricing benchmarks where available
Intelligence surfaced at the point of decision — not after the order was shipped.
Implementation
Deployment occurred over a 01 – 05 period.
AI Pricing Recommendation Engine
Dynamic pricing guidance by SKU, customer, and deal context — trained on the distributor's own transaction history.
Real-Time Margin Guardrails
Margin impact on every quote line item inside Prophet 21, with structured escalation replacing manual approval bottlenecks.
Account Profitability Dashboards
Daily account-level views of margin contribution, discount trends, and cross-sell gaps — replacing the monthly PDF.
Data Consolidation
Transaction data from 14 branches unified with automated daily refresh after three weeks of historical cleanup.
ERP-Native Deployment
Entire intelligence layer inside the existing Prophet 21 interface — same screens, same workflow, better information.
AI Pricing Recommendation Engine
Dynamic pricing guidance by SKU, customer, and deal context — trained on the distributor's own transaction history.
Real-Time Margin Guardrails
Margin impact on every quote line item inside Prophet 21, with structured escalation replacing manual approval bottlenecks.
Account Profitability Dashboards
Daily account-level views of margin contribution, discount trends, and cross-sell gaps — replacing the monthly PDF.
Data Consolidation
Transaction data from 14 branches unified with automated daily refresh after three weeks of historical cleanup.
ERP-Native Deployment
Entire intelligence layer inside the existing Prophet 21 interface — same screens, same workflow, better information.
Strategic Impact
Pricing Discipline Without Rigidity
Reps retained full discretion. The 24% reduction in discount variability came from better information, not enforcement — reps naturally made tighter decisions when margin impact was visible.
Operational Continuity
94% adoption within the first month. Two training sessions for inside sales, one for field. No workflow disruption — the intelligence enhanced the existing process rather than competing with it.
Compounding Intelligence
By month four, recommendations were measurably more accurate than at launch. Every quote processed taught the model which pricing strategies worked for which customer segments.
Key Takeaway
In industrial distribution, pricing precision compounds across thousands of daily decisions. This distributor invested in intelligence at the exact point where margin is won or lost — the quoting process. By embedding it inside the system 48 reps already used every day, adoption was immediate, friction was minimal, and results were measurable within one quarter.
Related Engagements
Inventory Intelligence
The Director of Procurement at a 7-branch industrial distributor in Minneapolis had known about the excess inventory for two years. The catalog exceeded 200,000 active SKUs, inventory sat at $42M, and...
SPA & Rebate Intelligence
The VP of Purchasing at a 5-branch industrial distributor in Edmonton discovered the problem during year-end reconciliation: her team had missed a volume tier with their second-largest supplier — a ma...
Customer Wallet Share Intelligence
The SVP of Sales at a 9-branch industrial distributor in Milwaukee suspected her team was capturing only a fraction of what their accounts actually spent on MRO. She was right — but the fraction was w...