RVJosé Ramón Vergara
Book a diagnosticES
Back to work
Logística · Cotización

Cross-border freight quote tool

From an Excel rate sheet to consistent quotes in seconds, for regional expansion.

Role
Strategist · Builder
Stack
Google Apps Script · Sheets · Reglas de negocio
Cross-border freight quote tool
RVSystem in production
ContextLogística · CotizaciónOutcomeConsistent quotes in seconds
01

The problem

Quoting cross-border shipments relied on an Excel rate sheet and each person’s judgment: slow, inconsistent and hard to scale to a new market.

02

The system

I built a tool that applies the rate sheet and commercial rules to return a consistent quote in seconds, with assumptions governed in one place. I used it to support regional expansion.

Google Apps ScriptSheetsReglas de negocio
SignalSystemDecision
OutcomeConsistent quotes in seconds
03 · What changed
03

What changed

The work had to be felt in the operation.

  1. 01

    Consistent quotes in seconds

  2. 02

    Rates and rules in one place

  3. 03

    Direct support for regional expansion

Do you have a similar operating challenge?