Remove Negotiation Remove Sales Analytics Remove Sales Management Remove Transportation
article thumbnail

Pricing Analysis in Excel: Make A Price Corridor in Three Simple Steps

QYMATIX

Although this type of in-depth analysis requires advanced price analytics, a price corridor is a useful first step to visualise past price developments and to apply predictive analytics using Excel. Sales managers can use a price corridor to determine the optimal price for each customer and product.

B2B 52
article thumbnail

Build a Price Corridor using B2B Pricing Analytics – Example

QYMATIX

To perform this kind of pricing analytics all discounts and bonuses should be explicitly allocated by product or product group. Transport, freight costs and taxes should be flatted out. Customers within the corridor have an acceptable relationship between conditions granted and annual sales and do not require any action.

B2B 52