Can I import a bill of materials from Excel?

Yes. A BOM is imported from a spreadsheet or built line by line from the catalog, with manual lines for machine time and assembly labour.

Does it handle Canadian and US dollars?

Yes. The exchange rate is set per project, and costs and prices show in CAD or USD without a side calculation.

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 custom work usually lives in a spreadsheet: a margin calculator someone built years ago, a price sheet beside it, and a currency cell that may or may not have been updated. The Margin Calculator brings that into Modustra IQ, where it is attached to the part, the revision, and the quote that depends on it.

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

Each save is recorded, so the pricing history of a part is there the next time it is quoted, along with notes on assumptions and sourcing. Drawings, PDFs, and STEP models attach to the revision, with STEP files opening in the built-in 3D viewer. When the numbers are right, the costed 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, with a refresh when costs change.

Currency

Set the exchange rate per project and show costs and prices in CAD or USD without a side calculation.

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. A BOM is imported from a spreadsheet or built line by line from the catalog, with manual lines for machine time and assembly labour.
Does it handle Canadian and US dollars?: Yes. The exchange rate is set per project, and costs and prices show in CAD or USD without a side calculation.
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.