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
New to Epicor Prophet 21? Start with the Epicor Prophet 21 guide and toolkit.
Keep exploring
Free tools
- Prophet 21 Pricing Library Design WorksheetPlan each price page: who it applies to, which product group, the cost basis and multiplier, and the resulting gross margin, before anyone keys it into the system.
- Prophet 21 Inventory Replenishment CalculatorWork out order point, safety stock, EOQ and a max level for a distribution item, then compare against what your P21 replenishment parameters say.
- Prophet 21 Data Cleanup ChecklistA checklist for cleaning item, customer, vendor, pricing and inventory data in Prophet 21 before an upgrade, migration or reporting project.
ERP fixes and how-tos
- How to Add AI to Prophet 21 On-Premises Without Moving Your DataPrivate AI assistant for Epicor Prophet 21 on-prem: SQL Server views, P21 API options, local LLM, role and location filters, audit and rollout steps.
- Epicor Prophet 21 API Documentation: Which API to Use and Where to Find the DocsThe Prophet 21 API options explained: Data Service (OData), Middleware and SOAP style services, how authentication works, and how to choose.
- Epicor Eclipse or Prophet 21: how a distributor should make the decisionA blunt decision guide for CIOs on Epicor Eclipse versus Prophet 21: what to ask Epicor, which factors matter, and how to avoid a costly migration mistake.
Integrations
- How to add AI agents to Epicor Prophet 21How to add AI agents to Epicor Prophet 21: a tool layer over the P21 APIs and SQL Server views, distribution workflows, human approval and on-prem hosting.
- How to use ChatGPT with Epicor Prophet 21Using ChatGPT with Epicor Prophet 21: custom GPT actions, exports versus live access, enterprise data controls and when a private model fits better.