Two ZIPs and a date. Give us the MABD and we'll tell you when it has to leave the dock. Give us the ship date and we'll tell you when it lands.
Drop in an Excel or CSV file with an origin ZIP and a destination ZIP on each row. Other columns are fine, and they come back untouched. Add an MABD or ship date column and we'll date every row. Your file stays in your browser. Nothing gets uploaded.
Miles. Each ZIP sits at its geographic center. We measure the straight line between them and multiply by 1.25 to account for how highways actually bend, which gives us road miles.
Transit. Road miles divided by miles per day, rounded up to a whole day. One day minimum.
Dates. Transit days count on the calendar because trucks run weekends. From an MABD, we count back to the ship date. With "Ship weekdays only" checked, a Saturday or Sunday ship date moves back to Friday. From a ship date, we count forward to the MABD. With "Deliver weekdays only" checked, a Saturday or Sunday arrival moves out to Monday.
Lists. Each row gets the same math. A row with an MABD gets a ship date. A row with only a ship date gets an MABD. If a row has both, we work from the MABD and flag any scheduled ship date that's too late to make it. Miles per day comes from the setting above.
This is a planning number. It doesn't know about appointment windows, holidays, team drivers or the receiver who won't answer the phone.
Right product. Right shelf. Right day.