← Guides & Articles
Guides & Articles

How to Build a Daily Transport Plan Without Excel (With Example)

By Zineb Bakhtaoui · · 5 min read

Contents

  1. How transport plans are built today
  2. What manual planning really costs
  3. What a good daily plan needs
  4. A worked example: 40 orders, 6 trucks
  5. 7 rules to write down before you automate
  6. Excel vs ERP vs TMS
  7. Where Freterium fits
  8. How to start
  9. Key takeaways
  10. FAQ

What happens to your transport plan when your best planner goes on holiday? In many companies we met, the honest answer is: it slows down. The rules that decide which truck goes where, and in what order, live in one person’s head and one Excel file.

In our calls with logistics teams in Morocco, the GCC and beyond, this was the problem we heard most.

A daily transport plan shouldn’t take hours: it should be built from your rules in minutes, and checked by your planners.

→ Book a demo

How transport plans are built today

In most of the companies we met, the plan is built in one of three ways, often all three at once:

  • In Excel, as orders come in. The planner adds each order to a truck, one line at a time.
  • From memory. Customers are grouped by “known routes” that only experienced planners understand.
  • By WhatsApp. The final plan is sent to drivers and carriers in messages and calls.

Several teams told us this takes 2 to 3 hours every morning.

What manual planning really costs

Time, every day

Two to three hours of a skilled person’s morning, every working day, before the first truck leaves.

Half-full trucks

Without a way to compare options, the first plan that works is the plan that leaves. Space that was never used is paid for anyway.

Know-how that sits with one or two people

The rules live in the planner’s head. When that person is on leave, the operation slows down.

No second chance

One late truck or one urgent order, and the plan starts again from zero.

What a good daily plan needs

A good plan respects the same constraints your planner already juggles:

  • Orders: what, how much, for whom, by when
  • Customers: addresses, delivery time windows, unloading rules
  • Trucks: your own fleet, rented trucks and carriers, with their capacities
  • Costs: what each truck or carrier costs per trip, per km or per stop
  • Business rules: priority customers, products that can’t travel together, maximum stops per truck

A worked example: 40 orders, 6 trucks

Example with illustrative figures, not taken from a client.

A distributor has 40 orders for tomorrow and 6 trucks: 4 of its own (two 10-tonne, two 5-tonne) and 2 from a carrier. Customers accept deliveries between 7:00 and 13:00, and three of them are priority stores.

By hand: the planner groups orders by area, as usual, and fills trucks until they look full. All 6 trucks go out. Two of them leave about half full, and a priority store gets its delivery at 12:30.

From rules: the same orders, trucks and time windows go into a TMS. It tests many combinations and proposes a plan where the priority stores are served first and the loads are grouped better, so one truck may not be needed. The planner checks it, moves one order the system couldn’t know about, and sends it.

The point is not that the software knows better. It’s that it can compare far more options than a person can in a morning, while the planner keeps the final word.

7 rules to write down before you automate

These are the rules your planner applies without thinking. Writing them down is the first step, whatever tool you use:

  1. Delivery time windows for each customer
  2. Truck capacities in weight, volume and pallets
  3. Which trucks can go where (city access, road restrictions, unloading docks)
  4. Priority customers and urgent orders
  5. Products that can’t travel together
  6. Maximum stops or hours per truck and driver
  7. Cost per truck or carrier, so the plan can choose the cheapest option that works

Excel vs ERP vs TMS

  • Excel: free and flexible, but the plan depends on one person and can’t compare options.
  • ERP: holds the orders, but rarely builds the daily route plan or follows the trucks.
  • Transport management system (TMS): builds the plan from your rules, sends it to drivers and carriers, and follows each delivery.

Where Freterium fits: from orders to a plan your team checks

Freterium is a transport management system (TMS) used by shippers, distributors and logistics providers in Morocco, the GCC and beyond. For daily planning, it covers:

  • Order import from your ERP or from Excel
  • Route optimisation with your rules: time windows, truck sizes, your fleet and your carriers
  • Several trips per truck in the same day
  • A plan your planners review and adjust before it’s sent
  • Trips sent to drivers’ mobile app and to carriers, with real-time tracking

→ Book a demo

How to start without changing everything at once

  1. Write down your planning rules (the list above).
  2. Clean your customer addresses.
  3. Start with one depot or one region.
  4. Run the automatic plan next to the manual plan for two weeks and compare them.
  5. Extend to the other depots.

Key takeaways

  • Many teams spend 2 to 3 hours a day building the transport plan by hand.
  • The real costs are half-full trucks, dependence on a few people and plans that restart from zero.
  • Writing down your planning rules is the first step, with or without software.
  • With a TMS, planners check the plan instead of building it.

→ Book a demo

FAQ

What is a transport management system (TMS)?
A transport management system, also called transportation management software, is a platform for planning, dispatching, tracking and billing road transport, with a company’s own fleet and its carriers.

Can a TMS replace transport planning in Excel?
Yes. It imports the same orders and applies your planning rules automatically, so the team stops rebuilding the plan by hand each day.

Does a TMS work with my own trucks and my carriers?
Yes. The plan can mix your own fleet, rented trucks and subcontracted carriers, each with its own capacity and costs.

What happens when a truck is late or an urgent order arrives?
The plan can be updated during the day without starting from zero, and drivers receive the change in their app.

How long does it take to start planning with a TMS?
Most of the work is preparing the data: customer addresses, trucks and rules. Starting with one depot keeps the first phase short.

Related articles: What Logistics Teams in Morocco and the GCC Told Us in 2026 · Carrier Invoice Guide for Shippers