Price Increase Impact Wholesale Tools
English
English 日本語 ລາວ Монгол Oʻzbekcha Тоҷикӣ Кыргызча Қазақша Azərbaycan Հայերեն ქართული العربية Български বাংলা čeština Dansk Deutsch Ελληνικά Español Eesti Suomi Français हिन्दी ગુજરાતી ಕನ್ನಡ मराठी മലയാളം Srpski Slovenčina Slovenščina Kiswahili Hrvatski Magyar Indonesia Italiano 한국어 Lietuvių Latviešu Nederlands Norsk Svenska Polski Português Română Русский Українська Беларуская Shqip اردو தமிழ் తెలుగు Türkçe ภาษาไทย Tiếng Việt 简体中文 繁體中文 עברית ខ្មែរ Melayu မြန်မာ ਪੰਜਾਬੀ සිංහල Tagalog नेपाली فارسی
Calculated in your browser Prioritize by customer x SKU Works without cost input Share only on explicit action

Price Increase Impact Estimator by Customer and SKU

Estimate revenue and gross profit changes at the customer x SKU level from current prices, new prices, and quantities, then rank the customers and SKUs with the biggest impact.

How to use it

  1. Enter customer, SKU, current quantity, current price, and new price in the table, or paste them from a spreadsheet.
  2. If you also want gross profit impact, enable cost mode and enter either a unit cost or separate current and new costs.
  3. Adjust the new quantity assumption, ranking metric, display count, and price basis when needed.
  4. Click Run estimate and review the customer x SKU, customer-level, and SKU-level rankings.
  5. Take the result out as CSV, TSV, or a shareable URL.

Examples

Price increase with quantity held flat

Input: Customer A / SKU-001 / current quantity 1200 / current price 12.00 / new price 12.80 / unit cost 8.20

Output: Revenue delta and gross profit delta both turn positive, so the combination rises to the top of the customer x SKU ranking.

Price increase with an expected drop in quantity

Input: Customer B / SKU-004 / current quantity 1000 / new quantity 900 / current price 5.00 / new price 5.50 / unit cost 3.20

Output: Even though the unit price rises, the revenue delta is smaller, which changes the ranking order.

FAQ

I do not know the new quantity yet

Leave the new quantity blank and the tool will use the current quantity by default. You can switch that behavior to a global change rate when needed.

Can I use it without cost data?

Yes. Set cost mode to none and the tool will rank revenue impact only.

Can I use it for a price decrease instead of a price increase?

Yes. If the new price is below the current price, the combination is ranked as a negative impact.

Can I compare multiple currencies at the same time?

Not within one scenario. Standardize the currency before you compare rows together.

Does the share URL contain my data?

Yes. The share URL contains input values, so use coded customer names and coded pricing when the data is sensitive.

Glossary

Revenue delta

The total revenue under the new condition minus the total revenue under the current condition.

Gross profit delta

The total gross profit under the new condition minus the total gross profit under the current condition. It is calculated only when cost is provided.

Customer x SKU

The smallest aggregation unit in the tool: one specific customer and one specific SKU together.

Impact share

The share of total absolute impact contributed by each row under the selected ranking metric.

Formulas

  1. Current revenue = current quantity x current price
  2. New revenue = new quantity x new price
  3. Revenue delta = new revenue - current revenue
  4. Current gross profit = current quantity x (current price - current cost)
  5. New gross profit = new quantity x (new price - new cost)
  6. Gross profit delta = new gross profit - current gross profit

Notes

  • This tool supports scenario analysis only. It does not perform demand forecasting or automatic price optimization.
  • Align your internal assumptions before input: tax basis, time period, and whether the cost is current or new.
  • Because share URLs include input values, avoid sending real customer names or confidential prices in plain text.