Comparative Statement (CS) Calculator
Enter up to 5 suppliers and 20 items. Discounts, VAT and delivery charges are applied per supplier; the lowest evaluated offer (L1) and item-wise lowest prices are found automatically.
Fictional example loaded. Replace the values with your own figures.
Enter your figures and press Calculate. Results, Excel/PDF downloads and the WhatsApp group link appear here.
Formulas and assumptions
- Line value = quantity × unit price. Subtotal = sum of line values for the items a supplier quoted.
- Grand total = subtotal − discount + VAT/tax (when prices exclude it) + delivery/other charges.
- Only suppliers that quoted every item and meet the specification are ranked; L1 is the lowest grand total.
- Item-wise lowest basket = sum of quantity × lowest compliant unit price for each item (before discounts and charges).
- Price spread = (highest − lowest) ÷ lowest unit price for that item.
Important
Generated by ProcureBest.com from user-supplied inputs. Estimates only — not official rates or professional advice.