Estimated price revision impact (by customer/SKU)
From the current/new prices and purchase volume, we calculate the increase/decrease in sales and gross profit and rank the customers x SKUs that have the greatest impact.
???? (must read)
?? data is processed within the browser (no server submission).
Calculate the impact of price revisions (sales/gross profit)
Step 1: Data entry
Header row recommended. Column names are automatically mapped.
manual input
| ??? ??er name (or customer ID) | SKU (or product name) | quantity | Current unit price | New unit price | Cost price (unit price) | Current unit price by customer | New unit price by customer | memo |
|---|
Scenario setting (easily reducing demand)
Step 2: Compare multiple scenarios with quantity coefficients
The quantity coefficient will be multiplied by the revised quantity (e.g. -5% → 0.95x).
Impact ranking by customer/SKU
Step 3: ??
Influence ranking (customer x SKU)
| customer | SKU | Quantity (after adjustment) | Current sales | Sales after revision | Sales difference | Current gross profit | Revised gross profit | gross profit difference | Contribution % of gross profit difference |
|---|
simple graph
Gross profit difference Top 10 (horizontal bar)
CSV output
Example file name: price-impact_2026-02-06_scn-qty-5.csv
How to calculate sales and gross profit for price increases (assumptions and formulas)
Adjusted quantity: quantity_after = quantity × quantity factor
Sales_now = current unit price × quantity / sales_after = new unit price × quantity_after
Gross profit_now = (current unit price - cost price) × quantity / gross profit_after = (new unit price - cost price) × quantity_after
Sales difference = Sales_after - Sales_now / Gross profit difference = Gross profit_after - Gross profit_now
Aggregation: Total by customer, SKU, and overall
?? ?? ?? (Decrease in demand/Special unit price/Graph)
I would also like to see a decrease in demand (decrease in quantity)
If you enter -5% etc. in the "Quantity Coefficient" in the scenario settings, you can make a trial calculation assuming that the quantity changes by the coefficient. You can also create multiple scenarios and compare them.
There are special unit prices for each customer.
If you enter in the "Current unit price by customer" or "New unit price by customer" columns in the input table, it will be applied preferentially as the unit price for that customer (if the field is blank, the standard unit price will be used).
I want to graph
Major differences (gross profit difference/sales difference) can be displayed in a simple graph on your browser. If you want to analyze it further, you can output it as CSV and process it with a spreadsheet, etc.
???? (must read)
This tool is a trial calculation based on the entered conditions. It does not guarantee or predict future sales or profits.
Confidential information such as customer name, unit price, and cost may be included. Please handle it according to company rules.
If possible, please anonymize (customer ID) input.
price change impact calculator / margin impact analysis