Blog
Practical notes for buyers who work with supplier files: price increases, quotes, price breaks, landed cost and part numbers — with worked examples you can reuse in a spreadsheet.
Quotes and landed cost ·
Allocating freight and duty across the lines of an order
One freight bill, four order lines: split by value, quantity, weight or per line, side by side — when each is fair, where duty fits in, and rounding that adds up.
Price lists ·
Check a supplier price increase line by line
A supplier announces "about 5 %". Measure what it costs you: per-unit changes, the increase weighted by what you buy, and the lines to question before you accept.
Quotes and landed cost ·
Comparing quotes with different price breaks and minimum orders
The lowest unit price is often not the cheapest quote. A worked example with price breaks, a minimum order, order multiples and freight, with Excel formulas.
Price lists ·
Supplier part number, MPN or GTIN: which to match on
Who assigns each identifier, what it identifies, and which to match a supplier price list on — with a cross-reference sheet and an EAN check-digit formula.
Price lists ·
Update your price list from a supplier's new file
Bring a supplier's new prices into your own item list in Excel without pasting over it: a clean key, unmatched items kept, statuses, a review and an effective date.