Epicor Quote Price and Quantity Break Calculator
Quoting a job shop part comes down to two ideas: spread the setup over the lot, and apply margin correctly. This calculator does both, and its chart shows the quantity break curve you can use to fill the quantity columns on an Epicor quote.
Your numbers
Plating, heat treat, anodize or similar.
Labor plus machine burden from the resource group.
Your results
Gross margin is profit as a share of price. Markup is profit as a share of cost. They are not interchangeable.
Unit cost and price vs quantity
Sweeps Quote quantity from 1 to 500, holding your other inputs fixed.
Quote accuracy check
Optional: compare your quoted cost with actual job cost for closed jobs in your Epicor data.
Optional. The tool and every export work without this. No spam.
How to use it
Enter material and outside processing per unit, run hours and the burdened hourly rate from the resource group, then the setup hours and rate for the lot. Choose the quote quantity and the margin you must earn. Read the price per unit, then drag the quantity slider to see the price at each break. Copy the unit prices for the quantities you want to offer into the quote lines, or into a quantity-break structure in Epicor Quote Entry.
- Quote several quantities, not just the one asked for
- Add scrap or yield loss to material before entering it
- Include inspection and packaging in the run hours
Margin versus markup
A 30 percent markup on cost is a 23 percent margin on price. Quoting 30 percent markup when the business needs a 30 percent margin leaves money on the table on every order. The formula here divides cost by one minus the margin, which guarantees the margin you type is the margin you earn. The markup output shows the equivalent value so you can talk to people who think in either terms.
Why the price drops with quantity
Setup is a fixed cost for the lot, so it falls per unit as quantity rises, while material and run cost stay flat. In the default example, one unit carries over 250 dollars of setup, while at 500 it is under 60 cents. The curve is steep at small quantities and flat beyond a certain point, which tells you where additional break points stop being worth offering.
Common mistakes
Estimators often under-count setup hours for first-time parts, or forget outside processing minimum charges and freight. Material price quotes also expire, so check the date on them. Finally, remember that a quote built on a standard routing is only as good as the resource group rates behind it; if the rate is stale, every quote is skewed in the same direction.
Frequently Asked Questions
Can I enter several quantity breaks in Epicor?
Epicor quotes support multiple quantities on a quote line, each with its own price. Use this tool to compute the unit price at each quantity and enter them. Verify against how your version handles quantity breaks.
What margin should I target?
It depends on your overhead structure and market. Many job shops target between 25 and 40 percent gross margin on price after burden. Use your historical average from closed jobs as a baseline.
How is margin different from markup?
Margin is profit divided by price; markup is profit divided by cost. A 25 percent margin equals a 33 percent markup. Mixing them up is a very common quoting error and this calculator shows both.
Does it include scrap?
Not separately. Increase the material cost per unit and run hours to cover expected scrap or yield loss, or divide by the expected yield before entering the values.
If you want quotes priced automatically from historical job cost in Epicor, with a reviewer in the loop, we can scope that with you.
Related Tools
Epicor Resource Group Burden Rate Calculator
Convert monthly overhead and productive hours into a burden rate per hour, add labor, and see the cost per piece for a routing operation.
EpicorEpicor EOQ and Lot Sizing Calculator
Compute economic order quantity, orders per year and total annual cost, then round to the multiple you enter in Epicor.
EpicorEpicor Job Cost Variance Worksheet
Compare estimated and actual material, labor and burden for closed jobs, and rank where the largest overruns occur.
EpicorEpicor Shop Floor OEE Calculator
Calculate OEE from planned time, downtime, ideal cycle time, count and rejects, then test how much downtime cuts OEE.
More Epicor tools
See all- Epicor Kinetic Job Status Reference
- Epicor BAQ Query Template Generator
- Epicor BPM Directive Design Template
- Epicor DMT Import Template Worksheet (Part and BOM)
- Epicor MRP Run Checklist
- Epicor Kinetic Upgrade Checklist
- Epicor REST API v2 URL Builder
- Epicor Security Group Design Worksheet
- Epicor Kinetic Customization Change Request Form Template