Dock Scheduling for a Small Warehouse: Slot Rules and AI Reminders

Coding Liquids tutorial cover featuring Sagnik Bhattacharya for Dock Scheduling for a Small Warehouse: Slot Rules and AI Reminders.
Coding Liquids tutorial cover featuring Sagnik Bhattacharya for Dock Scheduling for a Small Warehouse: Slot Rules and AI Reminders.

Book each truck into a fixed slot sized to its load type, for example 30 minutes for a parcel van, 60 for a palletised delivery and 90 or more for a mixed or floor-loaded container, with a 15-minute buffer between. Keep every booking on one shared calendar and let AI draft the confirmations and reminders from it.

The catch is that slot lengths are your own measurements, not an industry table. Time your last twenty receipts before choosing numbers, and add a late-arrival rule that everyone sees in writing. Without that rule, one truck that turns up an hour late pushes the whole day back, and the schedule loses its authority within a week.

Follow me on Instagram@sagnikteaches

Measure your own unload times first

Dock software vendors publish guides with typical slot lengths, and they vary a lot because loads vary. Your pallets, your forklift and your door layout decide the real figure. Spend one week writing three times against each arrival: when the truck reached the gate, when unloading started, and when the door was free again. A paper clipboard is fine. If staff will not keep a clipboard, a phone note works.

Connect on LinkedInSagnik Bhattacharya

Then group the arrivals by load type and take the middle figure, not the average of the best days. Illustrative figures for an independent bookshop's distribution unit might look like this:

Subscribe on YouTube@sagnikteaches
Load typeMedian door timeSlot you book
Parcel van, under 40 cartons14 minutes30 minutes
Single pallet, tail-lift or forklift22 minutes30 minutes
Four to eight pallets, one SKU per pallet38 minutes60 minutes
Mixed pallets with checks against a purchase order55 minutes75 minutes
Floor-loaded 40-foot container2 hours 40 minutes3 hours 30 minutes

The gap between median and slot is your cushion. A rule of thumb is median plus 25 to 40 per cent, rounded to the next 15 minutes, then adjusted after a month of real data. Do not use the fastest time you ever recorded. Slots built on best-case times produce queues on ordinary days.

The Complete Excel Course with AI Integration thumbnail

The Complete Excel Course with AI Integration

From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.

By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner

Buy now

A main worked example: one door, one day

Take a removals firm that runs a small storage warehouse with a single loading door and one forklift. It receives packing materials in the morning and collects customer crates in the afternoon. Before scheduling, drivers arrived whenever they liked. The yard team was busiest between 9:30 and 11:00, when three trucks arrived within twenty minutes of one another and two waited on the road.

The manager timed a week of arrivals and chose these rules:

  1. Door open 07:30 to 16:30, with a 12:30 to 13:00 gap for the forklift driver's break.
  2. Slot lengths by load: 30, 60 or 75 minutes for this site's loads, from the table above.
  3. 15-minute buffer after every slot, to clear paperwork and sweep the apron.
  4. Two "flex" slots a day, 10:30 and 14:30, held empty for overruns and emergencies.
  5. Late rule: a truck more than 15 minutes late loses its slot and joins the queue after the next confirmed booking.

The day then looks like this, in illustrative figures:

TimeBookingSlotBuffer to
07:30Packing supplier, 6 pallets60 min08:45
08:45Parcel carrier, 25 cartons30 min09:30
09:30Pallet network drop, 3 pallets30 min10:15
10:30Flex slot60 min11:45
11:45Crate collection (customer van)30 min12:30
13:00Mixed delivery with PO check75 min14:30
14:30Flex slot60 min15:45

That is five firm bookings and two flex windows on one door in a nine-hour day, with the break accounted for and 45 minutes spare at the end for a late collection.

Check the grid the way the manager did, by adding each slot and its buffer to the start time: 07:30 plus 60 plus 15 lands on 08:45, 08:45 plus 30 plus 15 on 09:30, and so on down the column. One row that does not add up is how double bookings start, so do this sum whenever you edit the day by hand.

In week one two trucks overran by ten minutes and the flex slots absorbed it. Without them, the afternoon would have slid. The manager's measure of success was simple: trucks waiting on the road at 11:00 fell from two or three to none within three weeks. That figure is invented for illustration; yours should come from your own gate log.

Buffers, flex slots and why they are not waste

A buffer is the gap between the end of one slot and the start of the next. It covers signing paperwork, a pallet that needs re-stacking, a driver who needs to call their office. A flex slot is a whole window held back each morning and afternoon. Owners dislike empty windows, but a schedule with none turns every overrun into a queue.

Size buffers by the cost of delay. If a door is the only one and a missed slot leaves a driver on an hourly rate waiting, 15 minutes is cheap insurance. If you run four doors and trucks can swap, 5 to 10 may do. Review the buffer after four weeks: if flex slots are never used, shrink them; if they are used every day, the slot lengths are too tight, and the fix is longer slots, not more flex.

Priority loads that bend the rules

Some freight earns a better slot: chilled goods, a customer's day-critical stock, anything that triggers a penalty for lateness. Write a short priority list, no more than three categories, and put those loads at the start of a half-day when the dock is clean. A priority list with ten entries is no priority list.

The late-arrival rule, written so drivers accept it

Every dock schedule lives or dies on one rule: what happens when a truck is late. Without it, the person on the door makes the decision on the spot, inconsistently, and some carriers learn that lateness is free. Decide these four points in advance:

  • The grace window. Fifteen minutes is a sensible starting point for short slots; for long slots you might allow thirty.
  • What lateness costs. Lose the slot and re-book, or wait for the next gap. Choose one.
  • How you handle a driver stuck in traffic who rang ahead. A phone call before the slot can extend the grace. Reward notice.
  • Repeat offenders. After three late arrivals in a month, you speak to the carrier's office, not the driver.

Print the rule on the confirmation and on a sign at the gate. If you are a small site dealing with larger carriers, expect some to push back; the answer is to apply the rule evenly and show the gate log.

Confirmation and reminder wording, drafted by AI

This is where the AI earns its keep. Writing the same email forty times a week is dull, and a vague one causes phone calls. Give a chat assistant your fixed details once, in a Project or a saved instruction, and ask for a confirmation from each booking row:

You write dock appointment confirmations for a small warehouse. Use only the fields I give you. Keep each message under 120 words, plain text, no emojis.

Always include: carrier, reference, date, door, slot start and end, load type, what to bring (delivery note and PO number), the late rule, and a phone number to ring if running late.

Late rule text, word for word: "If you arrive more than 15 minutes after your slot start, your slot is released and you will be placed after the next confirmed booking."

BOOKING: Carrier A | ref 88123 | Tue 14 | Door 1 | 09:30-10:15 | 3 pallets | PO 4410

An illustrative result:

Subject: Dock appointment confirmed: Tue 14, 09:30, ref 88123. Hello, your delivery is booked at Door 1 from 09:30 to 10:15 (3 pallets, PO 4410). Please bring your delivery note showing the PO number. If you arrive more than 15 minutes after your slot start, your slot is released and you will be placed after the next confirmed booking. If you are running late, call the gatehouse on [phone number]. Thank you.

What to fix in it: the model may add a friendly closing line you did not ask for, change "released" to "cancelled", or drop the PO number. Cheap checks catch these. Keep the late rule as a block of fixed text the AI must copy, as above, instead of letting it paraphrase. If your data is held in a sheet, the cleaner route is to fill a template with a mail merge and use the AI only for the odd exception message. See how AI reads delivery notes for the paperwork side of the same arrival.

Reminder timing that carriers will tolerate

Two reminders are enough: one the working day before, with the slot and the late rule, and one on the morning for any carrier who has not confirmed. More than that and drivers start ignoring them. Tell the AI the send times as data in the booking row, so you can later build the sends into a tool that schedules them.

One shared calendar as the single source of truth

Dock schedules fall apart when two versions exist: the whiteboard in the office and the email thread. Pick a shared calendar in Google Calendar or Outlook and make a rule that nothing is booked unless it is in the calendar. Create one calendar per door, so a glance shows which door is free. Colour-code by load type if you wish.

A workable layout for each event:

  • Title: carrier, load type, number of pallets, reference.
  • Location field: the door number.
  • Description: PO numbers, special handling, driver's phone, and a line saying "confirmed sent".
  • Guests: the receiving clerk and the forklift driver, so the day appears on their phones.

Permissions matter. Let a few named people create and edit events; give everyone else view-only access. In Google Calendar's sharing settings that means "Make changes and manage sharing" for the manager, "Make changes and see event details" for the receiving clerk, and "See event details" for the yard team; Outlook has similar levels under its own names. Check each calendar product's help page for current sharing options, as labels and plan limits change. A calendar that anybody can drag events around on will eventually be wrong.

When bookings arrive by email, a model can turn them into calendar-ready rows. Paste the email and ask for "carrier, date, requested time, load type, pallets, PO" as a table, then check it before entering it. The model sometimes reads "Thursday" as the wrong date near a month end, so enter dates yourself. For the bigger picture of AI and calendars, can AI manage your calendar sets out what is safe to hand over.

Handling the awkward bookings

A sample of cases that do not fit the grid, with the answer to each:

  • A truck needs two doors. Book both calendars with the same reference, and add a note so nobody gives one away.
  • A carrier will not give a time. Offer a half-day window with a priority slot at the start. If they still cannot commit, schedule them last of the day.
  • An unplanned arrival. Use the flex slot if it is free; otherwise offer the next gap and log it as "unbooked". Count those weekly. A rising count means a carrier is ignoring the system.
  • Collections and deliveries together. Give outbound loads their own slots and, if possible, their own hours. Mixing both on one door at 10:00 is where most queues start.
  • A holiday week. Cut slot capacity in advance and tell carriers. A tutoring centre with textbook deliveries, for example, may see everything arrive in the week before term starts.

Putting a price on a queue

Owners sometimes ask whether this effort is worth it. A quick sum answers that. Say a landscaping company runs a small yard that receives bagged soil, stone and plant stock, and its supplier trucks wait an average of 35 minutes twice a week. If the haulier's waiting time is charged at $60 an hour and the supplier passes it on, that is about $70 a week or $3,640 a year. If the yard also pays two staff to stand idle during the wait, add their wages. These are invented figures, but the shape is real: waiting time is a cost that appears on someone's invoice, and a schedule that halves it pays for an afternoon's setup quickly. Put your own rates in the sum before you decide how much effort to spend.

A before and after of a booking request

The before is a real-looking email a carrier might send: "Hi, we have 5 pallets for you sometime Thursday, driver will ring when near." An assistant given your rules turns it into a reply: "Thanks. Thursday has a 60-minute slot at 08:45 or 13:30 on Door 1. Which suits? Please send your PO number and a driver phone number, and note the late rule below." The after reply does three things the original email did not: it offers a real slot, asks for the missing data, and states the late rule. Repeated over a week, it removes most of the phone calls.

A tutoring centre as a second example

A tutoring centre does not look like a warehouse, yet it receives three textbook deliveries a term into one back door and one storeroom. The same method applies at a smaller scale: one door, 60-minute slots in the early morning before lessons, no deliveries between 15:30 and 18:30 when students arrive, and a confirmation email that tells the courier which door to use and who to ring. The slot rule that matters here is not length but exclusion windows, times when the dock is closed for safety reasons because children are on site.

What to track to see if it is working

Keep a small sheet with one row per arrival: booked slot, actual arrival, start, finish, and a reason code for any overrun. After four weeks work out three numbers: on-time arrivals as a share of all bookings, average door time against the slot you booked, and trucks waiting more than 15 minutes. Paste the sheet into an AI chat and ask for the pattern by carrier and by weekday, then check two of its sums by hand. The pattern usually points to one or two carriers and one weekday that cause most of the trouble.

A realistic scenario of how it goes wrong: the schedule is introduced, but the receiving clerk keeps accepting early trucks "to be helpful". Within three weeks carriers learn that early beats booked, and arrivals bunch again at the start of the day. The remedy is the early-arrival rule in the confirmation, followed by the clerk actually holding to it. A schedule only works when the person at the gate enforces it kindly and consistently.

When a calendar stops being enough

A shared calendar copes with roughly one door, a dozen regular carriers and a few bookings a day. Signs you have outgrown it: you spend an hour a day arranging slots by phone, carriers want to book themselves, you need reports by carrier, or you run several doors across sites. At that point look at dedicated dock appointment tools, many of which offer carrier self-booking pages and reminders. Check each vendor's current pricing and plan limits directly, because they change, and ask whether a free tier exists for a single site. Our overview of AI tools for warehousing compares what small operators actually need.

Staffing is the other half of the equation. A clean schedule shows you the peaks, so you can plan who is on shift; warehouse labour planning from order volumes uses the same idea from the other direction. And because the busiest slots are when the forklift works hardest, a daily forklift checklist is worth doing before the first truck, not after the first near miss.

A seven-day rollout plan

  1. Days 1 to 3: time the arrivals, group by load type, calculate slots.
  2. Day 4: create the door calendars, set permissions and write the rules, including the late rule, on one page.
  3. Day 5: set up the AI instruction with the fixed late-rule text and test it on five real bookings.
  4. Day 6: email your regular carriers the new process, with the first week's bookings attached.
  5. Day 7: go live, with the gate log open on the clerk's desk.

Review at four weeks. Change the slot lengths, not the rules, if the numbers say so. Keep the late rule steady, because a rule that moves is a rule people stop believing.

Dock scheduling questions from small warehouses

How many dock doors do I need before appointments help?

Even one door benefits once two or more carriers can turn up in the same hour. The point is to stop arrivals bunching, not to match a door count. With one door, slots and a firm late rule often do more than any software.

Should carriers book themselves?

A booking page is nice once you have a dozen regular carriers. Until then a shared calendar and a short email request is easier to run. Move to self-booking when you spend more than an hour a day on the phone arranging slots.

What if a driver arrives early?

Decide the rule in advance. A common one is that early arrivals wait until their slot unless the door is free and the next slot is clear. Write that rule into every confirmation so drivers are not surprised.

Can AI decide who gets which door?

It can suggest a layout from your rules, but you should own the rules. Give it door types, slot lengths and priority customers, and treat its output as a draft you drag into the calendar.

Do reminders really reduce no-shows?

I won't quote a percentage because I can't verify one. Try it: track missed and late slots for four weeks before reminders and four weeks after, and let your own numbers decide.

Further reads

Sources: Google Calendar Help (share a calendar, permission levels); dock appointment software vendor pages for the self-booking idea. Slot times in the examples are illustrative planning figures, not industry standards.

Want your dock slots and reminders running by themselves?

On a 1:1 call we'll look at how trucks are booked today, work out slot rules for your load mix, and decide whether a shared calendar and AI-written reminders are enough or software is worth paying for.

Book a 1:1 call with me