Measured project / purchasing workbook

Aggregate and Fill Order Comparison

Compare an exact measured takeoff against source-backed bag, volume and weight quotes, supplier minimums, order increments, density scenarios and delivery.

Aggregate and fill ordering comparison

What this worksheet covers

Compare exact supplier units, minimums, increments and delivered costs for one measured material identity.

Purchasing arithmetic from measured takeoffs and exact supplier conversions. No universal density, material substitution, compaction advice or live prices.

Import a saved measurement

Select a source, then an existing field with the same measurement unit. Add region or station rows first when needed. Confirm physical meaning and datum; importing a number does not approve a design or replace the rest of the required measurements.

Source projectSource measurementDestination field

Required measured volume (ft³)

Import saved measurements to preserve provenance or enter measured cubic feet.Exact material identitySelected quote ID (blank compares without adding an order)Separate reserve (%)Supplier-documented loose order factor

Supplier quotes

Supplier quotes 1

Quote IDSupplierExact matching material identityDated quote (YYYY-MM-DD)Quote unitDocumented volume per bag (ft³)Required for bags only. Leave unknown for bulk volume quotes.Documented loose density (lb/ft³)Required for weight orders; leave unknown when ordering by volume.Low density scenario (lb/ft³)Required for weight orders; leave unknown when ordering by volume.High density scenario (lb/ft³)Required for weight orders; leave unknown when ordering by volume.Quote price per unitMinimum order unitsSupplier order incrementDelivery chargeEnter the confirmed amount; zero only when explicitly confirmed.Other fees including any fee taxEnter the confirmed amount; zero only when explicitly confirmed.Confirmed applicable tax (%)Enter the confirmed amount; zero only when explicitly confirmed.The entered tax applies to delivery

Exact material / conversion source

Manufacturer or supplierExact productModel / SKUSource document URLDocument edition / supplied drawingSource-check date (YYYY-MM-DD)Applicable facts, units and conditionsI checked these entries against this exact source

1 of 8 supported rows

Enter the measured layout and selected product information, then calculate. Exact schedules and a drawing appear here.

Calculation reference

Method and limits

Compare dated quotes for the same exact material identity. The result separates measured volume, loose-order conversion, supplier minimums, increments and delivered cost.

Convert only with documented content

Start with required volume, selected reserve and a documented loose-order factor. Quoted cubic-foot units contain 1 ft³; cubic-yard units contain 27 ft³. A short-ton unit contains 2,000 ÷ documented density lb/ft³ cubic feet. Bag units use the exact entered bag content. Weight quotes also require a density sensitivity range bracketing the selected density; its alternate orders show conversion sensitivity, not predicted compaction.

order volume = measured volume × (1 + reserve/100) × loose-order factor

Minimum first, increment second

Convert order volume to quoted units, take the greater of that requirement and the supplier minimum, then round up once to the supplier increment. Fractional bulk increments are supported; bags require whole minimums and increments. Capacity minus order volume is purchasing surplus. Up to eight supplier quotes can be compared, but only the selected supplier contributes a material line.

purchased units = increment × ceil(max(order volume/content per unit, minimum)/increment)

A receipt requires complete terms

Enter the exact supplier/material source, quote date, unit price, delivery, other fees, tax and whether delivery is taxable. Missing cost terms stay unknown rather than becoming zero. No live prices, universal densities, substitution equivalence or compaction design are inferred.

Arithmetic checked against the current calculation source on 1 October 2026. Product instructions remain the exact records entered in this worksheet; recording a source is not external approval.

All calculator methods