Example 3 - Stacks, Consolidation & References

June 11, 2025

Change the manufacturing cost for all line items by adjusting the manufacturing_cost_per_m2 parameter in the raw_materials facet

Set a minimum Margin Threshold for the quote through the low_margin_threshold parameter in the gross_margin facet

Site Quotation

The site quotation table shows the calculations for the selected site.
The consolidated figures for all of the sites are shown above the table.

For all sites:
Total Cost Total Offer Profit Gross Margin
Item Steel Used m2 Item Cost Unit Price Quantity Line Cost Line Offer Gross Margin
No matching records found.
Site Profit:

Steel suppliers

The steel suppliers table calculates the average cost of supply based on the purchase and transportation costs from several suppliers using the steel_suppliers facet.

Supplier Steel Cost
m2		 Transport Cost m2 Supplier Cost m2
No matching records found.
Average:

Create and populate the noSheet table:

The raw materials facet:

The line items facet:

The gross margin facet:

The consolidation facet:

The steel suppliers facet: