Can I import a bill of materials from Excel?

Yes. Import a BOM from a spreadsheet, or build it line by line from the catalog and add manual lines for machine time and assembly labour.

Does it handle Canadian and US dollars?

Yes. You set the exchange rate for each project, and costs and prices show in CAD or USD.

How are quantity price breaks handled?

Define your discount levels once and the calculator shows the selling price, margin in dollars, and margin percentage at every quantity break.

Is pricing history kept?

Yes. Every save is recorded with notes on assumptions and sourcing, so you can see how a part was priced the last time it was quoted.

Margin Calculator for BOM costing and quoting

The Modustra IQ Margin Calculator imports a bill of materials, costs it with parts and labour, sets the margin, and shows the price at every quantity break before it goes on a quote.

Pricing for custom work usually lives in a spreadsheet: a margin calculator someone built years ago, a price sheet next to it, and an exchange-rate cell nobody's sure was updated. The Margin Calculator moves all of that into Modustra IQ, tied to the part, the revision, and the quote that uses it.

You start with the bill of materials. Import it from a spreadsheet or build it from the catalog, then add manual lines for machine time and assembly labour. Each line's quantity, unit cost, and extended cost roll up to a total. Set a cost multiplier or type in a list price, define your discount levels, and the calculator shows selling price, margin in dollars, and margin percentage at every quantity break, in CAD or USD at the exchange rate you set for the project.

Every save is recorded, so the next time you quote a part, its pricing history is right there, along with your notes on assumptions and sourcing. Drawings, PDFs, and STEP models attach to the revision, and STEP files open in the built-in 3D viewer. When the numbers look right, the part goes straight onto a quote.

A look at it

The Modustra IQ margin calculator: a cost multiplier of 3 giving a list price of $893 CAD, discount levels of 0, 10, 20, 30 and 35 percent, and a table of selling price, margin in dollars and margin percentage for volumes of 1, 2 to 9, 10 to 99, 100 to 399 and 400 and up, with the historical pricing section starting below. — Discounts & margin: list price from the cost multiplier, then selling price and margin at every quantity break.

What's inside

Import a BOM

Bring a bill of materials in from a spreadsheet, or build it line by line from the catalog.

Parts & labour

Catalog parts, manual lines, machine time, and assembly labour costed together. Refresh the costs when prices change.

Currency

Set the exchange rate for each project and see costs and prices in CAD or USD, with no side calculations.

Price breaks & margin

Define discount levels once and see selling price, margin, and margin percentage at each volume.

Pricing history

Every save is recorded, so you can see how a part was priced the last time it was quoted.

Drawings & STEP files

PDFs, drawings, and 3D models attach to the revision, and STEP files open in the built-in viewer.

See it in motion

A spreadsheet BOM imported and costed, priced across quantity breaks, then carried into a quote. 63 seconds, no sound, typing sped up.

Frequently asked questions

Can I import a bill of materials from Excel?: Yes. Import a BOM from a spreadsheet, or build it line by line from the catalog and add manual lines for machine time and assembly labour.
Does it handle Canadian and US dollars?: Yes. You set the exchange rate for each project, and costs and prices show in CAD or USD.
How are quantity price breaks handled?: Define your discount levels once and the calculator shows the selling price, margin in dollars, and margin percentage at every quantity break.
Is pricing history kept?: Yes. Every save is recorded with notes on assumptions and sourcing, so you can see how a part was priced the last time it was quoted.

Explore the other features: CRM, Revision & Drawing Control, Production, ERP, or check the plans and pricing.