Keeping a rate base accurate enough to quote from

A rate is a small contract with metadata attached

The price itself is the least interesting part. What makes it usable is everything around it: the lane and direction, the mode and equipment it applies to, the commodities it covers or excludes, the period during which it is valid, the currency, the conditions attached, and a reference back to the agreement it came from. A number without that context cannot safely be quoted by anyone who was not in the negotiation. That context is also what allows a disputed invoice to be settled quickly, because the basis on which the price was offered can be reconstructed rather than argued about.

The buy side and the sell side are different objects

Purchase rates come from carrier agreements and change on the carrier's cadence. Selling prices belong to customers and change on commercial cadence. Treating them as one table forces the business either to expose its buying to sales staff or to maintain two disconnected sets that drift apart. The workable arrangement holds both, linked by rules that derive a selling price from a purchase price plus a defined margin, with named exceptions for customers who have negotiated something specific. That way a carrier increase propagates visibly rather than silently eroding the spread.

Expiry is the dominant failure mode

Quoting from a lapsed rate is the most common and most expensive error in the discipline, and it is nearly always a process failure rather than a mistake of judgement. Rates should expire automatically at their stated date and become unquotable rather than merely marked as old, with a deliberate decision required to extend them. Surcharge tables complicate this because they move on their own schedule, independently of the base rate they attach to. A base held for a season with fuel-linked and currency adjustments revised more often needs both components dated separately, or the combined price will be wrong while each half looks correct.

Ownership and change control

Somebody must own the rate base, and it should not be everybody. Uncontrolled editing produces duplicates, contradictory entries for the same lane and prices nobody can trace to an agreement. A short list of people authorised to load and amend, with an audit trail showing who changed what and when, prevents most of it. Overrides need the same treatment. Allowing sales staff to quote below the derived price is often commercially necessary, but it should be recorded as an override against a named approver rather than typed over the top of the calculation.

Frequently asked questions

Why keep customer selling prices separate from carrier buying rates?

Because they change for different reasons and on different cycles. Linking them by a margin rule lets a purchase increase flow through visibly, while keeping negotiated customer prices as explicit exceptions rather than as untraceable edits.

What is the practical harm of an expired rate staying quotable?

The price is offered and accepted, then the purchase is made at the current level, and the difference is discovered when the supplier invoice is matched. By then the customer has a written offer and the spread has already gone.