Price Matrix Multiplier and Gross Margin Calculator for Distributors
A multiplier on cost looks simple until discounts, rebates and freight arrive. This calculator shows the margin that actually lands and solves for the multiplier you need to hit a target.
Your numbers
Current vendor cost per unit before rebate and freight.
Sell price divided by cost. A multiplier of 1.35 is a 35 percent markup.
Contract or negotiated discount applied after the matrix.
Expected net rebate as a percent of purchases.
Your results
Single-item model. Real margin varies with mix, rebate tiers and actual freight.
Gross margin percent by multiplier
Sweeps Matrix multiplier from 1 to 2, holding your other inputs fixed.
Margin leakage review
Optional: have us show how invoiced margin could be compared against intended pricing rules, read-only.
Optional. The tool and every export work without this. No spam.
How to use it
Enter the replacement cost and the multiplier your pricing setup applies, whether that lives in a price library in Prophet 21, a matrix in Eclipse, or a spreadsheet. Add the customer discount, the vendor rebate you expect and inbound freight as a percent of cost. The tool returns net price, landed cost, margin in dollars and percent, and the multiplier required to reach your target margin.
- Use replacement cost for forward pricing, average cost for historical analysis.
- Rebate should be the net, earned amount, not the headline tier.
- Check margin at the lowest discount tier a customer can reach.
Markup versus margin
Markup is profit over cost, margin is profit over price. A multiplier of 1.35 gives a 35 percent markup but only about a 26 percent margin before any discount. The required multiplier is net landed cost divided by (1 minus target margin) divided by (1 minus discount), then divided by raw cost. Confusing the two is the most common reason distributors under-price.
Reading the chart
The curve shows margin rising with the multiplier but flattening. Near a multiplier of 1.0 you earn nothing after freight and discount, so small changes there matter far more than the same change at 1.8. Use it to see how much margin a 0.05 change in a price page buys.
Common mistakes
Do not apply a rebate you have not earned, and do not ignore that discounts compound with matrix overrides. Also remember that a price library change affects every customer on that rule, so test the new multiplier against your top accounts before you release it.
Frequently Asked Questions
What is the difference between markup and margin?
Markup divides profit by cost; margin divides profit by selling price. A 25 percent margin equals a 33.3 percent markup. Distributors who quote margins but set markups routinely under-price by several points.
Why is my margin lower than the multiplier suggests?
Discounts, freight, rebate timing and cost changes all move it. A 1.35 multiplier with a 5 percent discount and 3 percent freight falls well below the 26 percent margin the multiplier implies on paper.
Does this work for Eclipse matrix pricing?
The math applies to any cost-plus multiplier approach, including Eclipse matrices and P21 price pages or libraries. It does not read your system, so enter the values you see there.
Can I use selling price instead of cost?
Yes, if you work backwards. Set the multiplier to 1 and enter your selling price as cost to see margin against net landed cost, then adjust inputs.
Netray can help analyze existing pricing rules and invoiced margin from your ERP data to find where the effective margin differs from the intended one.
Related Tools
Distributor GMROI and Inventory Turns Calculator
Calculate GMROI, inventory turns and days of inventory for a branch, vendor line or product group, and see how inventory levels move the return.
Supply Chain & InventoryDistributor Backorder Cost and Fill Rate Calculator
Convert line fill rate into the annual cost of backorders, and see the value of improving fill rate by one point.
Costing & FinanceVendor Early Pay Discount Worksheet
List your vendors' payment terms, see the annualized return of taking each discount and the dollars saved, and export to Excel.
ERP OperationsGross Margin by Product Calculator
Calculate true gross margin for a single product line, including freight and commission, and see the annual gross profit each SKU contributes.
More Epicor tools
See all- Prophet 21 Inventory Replenishment Calculator
- Prophet 21 Pricing Library Design Worksheet
- Prophet 21 Upgrade Checklist
- Prophet 21 Data Cleanup Checklist
- Prophet 21 Special Order Request Form Template
- Prophet 21 Vendor Return Authorization Request Template
- P21 Dead Stock Hold vs Liquidate Calculator
- Prophet 21 Inventory by Location SQL Generator
- Prophet 21 Open Order and Backorder SQL Generator