Create a column for each bag-in bag-out (BIBO) offer, plus columns for quote date, currency, assumptions and exclusions. Enter the unit price, delivery charges and separately quoted coordination. Use the same period for every offer.
Calculate the recurring portion
For each replacement item, multiply the quoted unit price by the buyer’s expected quantity for the comparison period. Add any fixed service fees and site-side costs included in the buyer's budget. State which costs are estimates and who supplied them.
Compare changes that move the decision
Recalculate if replacement quantities, lead times or service charges differ materially. Record the data needed to update the sheet and ask the bidder to clarify any missing line before award.





















