Purpose of the lesson
Use stock information, replenishment plans, customer-order schedules, vehicle capacity and route allocations to prepare an achievable transport and distribution schedule.
Practical outcome
By the end of this lesson, you must be able to:
- Confirm stock availability.
- Verify the stock-replenishment plan.
- Identify stock shortages and their effect on deliveries.
- Convert customer-order schedules into transport-route plans.
- Compare required loads with available transport capacity.
- Identify route and capacity constraints.
- Revise the transport plan when constraints occur.
1. Gather the required information
Obtain:
- Customer-order schedule
- Customer delivery addresses
- Requested delivery dates and time windows
- SKU and quantity information
- Stock-on-hand report
- Stock allocated to other orders
- Replenishment schedule
- Vehicle register
- Vehicle load capacities
- Driver availability
- Existing route allocations
- Loading and dispatch capacity
- Transport lead times
- Road, access and delivery restrictions
Confirm that all information covers the same planning period.
2. Confirm stock availability
Check whether sufficient stock is available for every scheduled customer order.
Use:
Available stock = Stock on hand − Reserved stock − Damaged or unavailable stock
Then calculate:
Projected stock balance = Available stock + Planned receipts − Scheduled demand
Example:
- Stock on hand: 1,200 units
- Reserved stock: 200 units
- Damaged stock: 50 units
- Planned receipts: 300 units
- Scheduled demand: 1,100 units
Available stock = 1,200 − 200 − 50 = 950 units
Projected balance = 950 + 300 − 1,100 = 150 units
A negative balance indicates a shortage.
Stock-availability template
| SKU | Stock on hand | Reserved | Unavailable | Planned receipts | Scheduled demand | Projected balance |
|---|---|---|---|---|---|---|
| SKU-001 | 1,200 | 200 | 50 | 300 | 1,100 | 150 |
| SKU-002 | 600 | 100 | 20 | 0 | 550 | −70 |
3. Verify the replenishment plan
For each planned receipt, confirm:
- SKU and quantity
- Supplier or production source
- Expected receipt date and time
- Current order status
- Lead time
- Delivery reliability
- Quality-inspection requirements
- Whether the stock will be available before dispatch
Do not allocate planned stock to a customer delivery unless the expected receipt date supports the loading and dispatch schedule.
Classify each receipt as:
- Confirmed
- At risk
- Delayed
- Cancelled
- Received
4. Assess the effect of stock shortages
When you identify a shortage:
- Identify the affected SKU.
- Calculate the shortage quantity.
- Identify affected customer orders.
- Check customer priority and delivery commitments.
- Determine when replenishment will become available.
- Evaluate possible corrective actions.
- update the customer-order and transport schedules.
- Communicate the change to authorised stakeholders.
Possible corrective actions include:
- Expedite replenishment.
- Transfer stock from another warehouse.
- Substitute an approved product.
- Split the customer delivery.
- Reallocate stock according to approved priorities.
- Change the dispatch date.
- Agree on a revised delivery date.
Record the effect of each decision on cost, service and other customers.
Shortage-impact register
| SKU | Shortage | Affected customer | Original delivery | Corrective action | Revised delivery |
|---|---|---|---|---|---|
| SKU-002 | 70 units | Customer B | 12 July | Split delivery | 12 and 15 July |
5. Confirm transport requirements
Convert each customer order into a transport requirement.
Record:
- Customer and destination
- Delivery date and time window
- Product and quantity
- Weight
- Volume
- Number of pallets or containers
- Handling requirements
- Vehicle requirements
- Loading location
- Estimated travel and unloading time
Use the controlling capacity measure. A vehicle may have enough weight capacity but insufficient floor space or volume.
6. Confirm available transport capacity
Prepare a vehicle-capacity register.
| Vehicle | Maximum weight | Pallet capacity | Volume | Driver available | Operational status |
|---|---|---|---|---|---|
| Truck 1 | 8,000 kg | 12 pallets | 35 m³ | Yes | Available |
| Truck 2 | 4,000 kg | 6 pallets | 18 m³ | Yes | Available |
| Truck 3 | 8,000 kg | 12 pallets | 35 m³ | No | Unavailable |
Check:
- Vehicle roadworthiness
- Licence and permit requirements
- Driver availability
- Maintenance schedules
- Fuel availability
- Product compatibility
- Temperature-control requirements
- Customer-site access restrictions
- Operating and driving-time restrictions
7. Calculate vehicle utilisation
Use:
Weight utilisation = Planned load weight ÷ Vehicle weight capacity × 100
If a truck with an 8,000 kg capacity carries 6,400 kg:
Weight utilisation = 6,400 ÷ 8,000 × 100 = 80%
Also calculate volume or pallet utilisation where relevant.
Pallet utilisation = Pallets loaded ÷ Vehicle pallet capacity × 100
The vehicle must remain within every applicable capacity and safety limit.
8. Allocate customers to routes
Group customers into practical routes by considering:
- Geographic location
- Delivery sequence
- Required delivery windows
- Vehicle capacity
- Road conditions
- Distance and travel time
- Customer unloading time
- Depot operating hours
- Product compatibility
- Vehicle-access restrictions
- Return-load opportunities
A route must be achievable within the available operating period.
Route-planning template
| Route | Vehicle | Driver | Customers | Departure | Planned return | Load | Capacity utilisation |
|---|---|---|---|---|---|---|---|
| R01 | Truck 1 | Driver A | A, B and C | 06:00 | 15:30 | 9 pallets | 75% |
| R02 | Truck 2 | Driver B | D and E | 07:00 | 14:00 | 6 pallets | 100% |
9. Determine the delivery sequence
Sequence deliveries to meet customer commitments while reducing unnecessary distance and delays.
Consider:
- Priority customers
- Fixed delivery appointments
- Vehicle-access times
- Geographic proximity
- Product-handling requirements
- Unloading duration
- Traffic and road conditions
- Vehicle return time
For deliveries from Johannesburg to customers in Pretoria and Polokwane, consider whether combining them on one route remains practical after accounting for delivery windows, distance and vehicle capacity.
10. Compare route demand with capacity
For each route, compare:
| Requirement | Available capacity |
|---|---|
| Total load weight | Vehicle weight limit |
| Total volume | Vehicle volume capacity |
| Number of pallets | Pallet positions |
| Route duration | Driver and vehicle operating time |
| Delivery requirements | Vehicle capability |
| Number of routes | Available vehicles and drivers |
Do not approve a route that exceeds a legal, safety, vehicle or operational limit.
11. Identify transport constraints
Record constraints such as:
- Insufficient vehicle capacity
- Vehicle breakdowns
- Driver shortages
- Conflicting delivery windows
- Excessive route duration
- Restricted customer access
- Stock becoming available after dispatch
- Incompatible products
- Loading-bay congestion
- Road closures or infrastructure disruptions
- Long-distance delivery requirements
- Unexpected increases in customer demand
Constraint register
| Constraint | Affected route | Operational effect | Corrective action | Responsible person |
|---|---|---|---|---|
| Vehicle unavailable | R02 | Two deliveries at risk | Appoint approved carrier | Transport planner |
12. Revise the route plan
When the original plan is not achievable:
- Confirm the constraint.
- Identify affected customers and orders.
- Determine alternative routes or resources.
- assess cost, time, capacity and service effects.
- Select an authorised solution.
- revise the route schedule.
- Communicate the change.
- Monitor the revised plan.
Possible revisions include:
- Reallocate customers between routes.
- Change the delivery sequence.
- Use another available vehicle.
- Appoint an approved third-party transporter.
- Split a load.
- Consolidate compatible loads.
- Reschedule a delivery.
- Expedite stock.
- Transfer stock from another location.
Maintain the original plan and revised version as evidence of the decision.
13. Prepare the final transport schedule
Include:
| Required field | Details |
|---|---|
| Route number | Unique route reference |
| Delivery date | Planned dispatch and delivery date |
| Vehicle and driver | Assigned resources |
| Departure time | Planned depot departure |
| Customer sequence | Ordered list of delivery points |
| Order references | Orders allocated to the route |
| Load details | SKUs, quantities, weight, volume or pallets |
| Delivery windows | Agreed customer times |
| Route duration | Estimated travel and service time |
| Return time | Expected depot return |
| Constraints | Known risks or limitations |
| Status | Planned, approved, dispatched or completed |
Obtain the required operational approval before releasing the schedule.
14. Monitor the schedule
During execution:
- Confirm loading completion.
- Record the departure time.
- Track route progress.
- Record arrival and departure at each customer.
- Monitor delivery exceptions.
- Communicate delays.
- Obtain proof of delivery.
- Record undelivered or returned stock.
- Compare actual performance with the plan.
- Update relevant systems and records.
Use results such as on-time delivery, vehicle utilisation and transport cost per unit to improve future schedules.
Practical task
You are provided with a case study containing stock availability, replenishment information, transport capacity, customer-order schedules and existing customer-route allocations.
Complete the following:
- Confirm available stock by SKU.
- Verify the stock-replenishment plan.
- Identify shortages.
- Determine how each shortage affects customer deliveries.
- Convert customer-order schedules into a transport-route plan.
- Assign customers, vehicles and drivers to routes.
- Calculate capacity utilisation.
- Identify transport-capacity and route constraints.
- Revise the route plan to resolve identified constraints.
- Submit the final achievable transport schedule.
Required evidence
Include the following in your Portfolio of Evidence:
- Source customer-order schedule
- Stock-availability report
- Verified replenishment plan
- Stock-availability calculations
- Shortage-impact register
- Vehicle and driver capacity register
- Initial transport-route plan
- Capacity-utilisation calculations
- Constraint register
- Revised and approved route plan
- Evidence of schedule monitoring or review
- Learner declaration of authenticity
Competence checklist
| Assessment criterion | Competent | Not yet competent | Comments |
|---|---|---|---|
| Confirm stock availability accurately | |||
| Verify a comprehensive stock-replenishment plan | |||
| Identify stock shortages | |||
| Determine the effect of shortages on customer deliveries | |||
| Convert customer-order schedules into route plans | |||
| Compare route requirements with transport capacity | |||
| Identify vehicle and route constraints | |||
| Calculate capacity utilisation correctly | |||
| Revise the route plan appropriately | |||
| Produce an achievable transport and distribution schedule | |||
| Submit complete supporting evidence |
Lesson Summary
To prepare a transport and distribution schedule, confirm stock and planned replenishment before allocating customer orders to routes. Translate each order into weight, volume, pallet, timing and handling requirements, and compare these requirements with available vehicles and drivers. Identify shortages, capacity limitations and route conflicts, then revise the plan using authorised alternatives. Finalise an achievable schedule, obtain approval and retain the calculations, constraints, revisions and monitoring records as practical evidence.