Purpose of the lesson
Compare actual customer orders with planned deliveries, identify stock, warehouse and transport constraints, and coordinate a revised delivery schedule according to approved customer priorities.
Practical outcome
By the end of this lesson, you must be able to:
- Identify variances between actual orders and planned deliveries.
- Create and maintain a delivery-variance register.
- Identify transport and warehouse capacity constraints.
- Realign delivery schedules according to customer priorities.
- Reallocate transport capacity.
- Place supplier back orders for stock shortages.
- Resolve demand-and-supply imbalances.
- Distinguish and manage hard and soft constraints.
- Align production schedules with revised operational requirements.
1. Gather the required information
Obtain:
- Actual customer orders on hand
- Original customer-order schedule
- Planned delivery schedule
- Customer-priority list
- Current stock report
- Back-order report
- Warehouse picking and loading capacity
- Vehicle and driver availability
- Vehicle capacities
- Route plan
- Supplier-order and replenishment information
- Production schedule
- Customer delivery windows
- Current operational exceptions
Confirm that all information relates to the same planning period.
2. Compare actual orders with planned deliveries
For every actual order, compare:
- Customer
- SKU
- Quantity
- Delivery location
- Planned delivery date
- Requested delivery date
- Priority
- Stock allocation
- Route allocation
Use:
Quantity variance = Actual order quantity − Planned quantity
Delivery-date variance = Revised or actual date − Planned date
A delivery occurring after the planned date represents a delay.
Delivery-comparison schedule
| Customer | SKU | Planned quantity | Actual quantity | Planned delivery | Required delivery | Variance |
|---|---|---|---|---|---|---|
| Customer A | SKU-01 | 400 | 500 | 10 July | 10 July | +100 units |
| Customer B | SKU-02 | 300 | 300 | 11 July | 9 July | Two days earlier |
3. Create a variance register
Record all differences requiring action.
| Reference | Variance | Cause | Operational effect | Priority | Required action |
|---|---|---|---|---|---|
| ORD-101 | Quantity increased by 100 | Customer amendment | Vehicle capacity exceeded | High | Reallocate vehicle |
| ORD-102 | Delivery required earlier | Urgent demand | Picking date changes | High | Revise warehouse plan |
Include variances relating to:
- Quantity
- SKU
- Customer
- Delivery date
- Delivery location
- Stock availability
- Vehicle allocation
- Route sequence
- Warehouse readiness
- Supplier replenishment
Confirm each variance before changing the schedule.
4. Identify transport-capacity constraints
Compare revised delivery requirements with:
- Vehicle weight limits
- Volume and pallet capacity
- Driver availability
- Vehicle operating condition
- Route duration
- Delivery windows
- Vehicle-access restrictions
- Product-handling requirements
- Transport-provider capacity
Calculate:
Vehicle utilisation = Planned load ÷ Available vehicle capacity × 100
A route exceeding 100% capacity is not feasible.
Transport-capacity register
| Route | Required pallets | Available pallets | Difference | Constraint |
|---|---|---|---|---|
| R01 | 14 | 12 | −2 | Insufficient pallet capacity |
| R02 | 6 | 8 | 2 | Capacity available |
5. Identify warehouse-capacity constraints
Check whether the warehouse can support the revised delivery plan.
Consider:
- Stock availability
- Picking labour
- Picking rate
- Equipment availability
- Staging space
- Loading bays
- Packing capacity
- Order cut-off times
- Dispatch deadlines
- Competing inbound activities
Calculate:
Required picking hours = Units to pick ÷ Picking rate
Compare the required hours with the available labour hours before the planned dispatch.
6. Classify hard and soft constraints
Hard constraints
Hard constraints cannot be exceeded without making the plan unsafe, unlawful or impossible.
Examples include:
- Legal vehicle-load limits
- Unavailable stock
- Closed customer receiving facility
- Product incompatibility
- Required safety controls
- Equipment incapable of handling the load
- Mandatory delivery restrictions
Soft constraints
Soft constraints may be adjusted with approval.
Examples include:
- Preferred delivery time
- Normal route sequence
- Planned employee allocation
- Preferred vehicle
- Standard order frequency
- Internal scheduling preferences
Resolve hard constraints first. Adjust soft constraints only through authorised decisions.
7. Realign deliveries according to customer priorities
Where all orders cannot be delivered as planned:
- Confirm the available stock and operational capacity.
- Apply the approved customer-priority rules.
- Identify orders that can be delivered in full.
- Identify orders requiring split or delayed delivery.
- Allocate available vehicles and warehouse resources.
- Confirm feasible delivery dates.
- Obtain approval.
- Communicate changes to customers and affected teams.
Realigned delivery schedule
| Customer | Priority | Order quantity | Allocated quantity | Vehicle | Original delivery | Revised delivery |
|---|---|---|---|---|---|---|
| Customer A | 1 | 500 | 500 | Truck 1 | 10 July | 10 July |
| Customer B | 2 | 400 | 250 | Truck 2 | 10 July | 10 July |
| Customer B | 2 | 400 | 150 | Truck 2 | 10 July | 12 July |
8. Reallocate transport capacity
Use the revised delivery plan to adjust:
- Vehicle assignments
- Route sequence
- Driver assignments
- Departure times
- Customer groupings
- Load composition
- Third-party transport requirements
Possible actions include:
- Move an order to a vehicle with available capacity.
- Split the order across two routes.
- Combine compatible deliveries.
- Change the delivery sequence.
- Appoint an approved transport provider.
- Reschedule a lower-priority delivery.
- Arrange an additional trip where operationally feasible.
Recalculate utilisation after every material change.
9. Manage stock shortages and supplier back orders
For every shortage:
- Confirm the affected SKU and quantity.
- Identify the affected customer orders.
- Review existing supplier orders.
- Determine the earliest available replenishment date.
- Create or update the supplier back order.
- Link it to the affected customer requirement.
- Revise the warehouse and delivery schedules.
- Monitor the supplier commitment.
Supplier back-order record
| Supplier | SKU | Outstanding quantity | Required date | Confirmed date | Affected customer | Status |
|---|---|---|---|---|---|---|
| Supplier A | SKU-01 | 200 | 9 July | 11 July | Customer B | Open |
10. Resolve demand-and-supply imbalances
A demand-and-supply imbalance occurs when available and expected supply cannot meet customer demand at the required time.
Possible responses include:
- Expedite an existing purchase order.
- Place a supplier back order.
- Use an approved alternative supplier.
- Transfer stock between facilities.
- Allocate an approved substitute product.
- Increase authorised production.
- Split customer deliveries.
- Change a delivery date.
- Reallocate stock by customer priority.
Evaluate the effect of each option on:
- Cost
- Customer service
- Inventory
- Production
- Warehouse operations
- Transport
- Supplier commitments
11. Align the production schedule
Where customer-order or delivery changes affect production:
- Confirm the revised SKU quantities.
- Review production capacity.
- Change production priorities where authorised.
- Check material availability.
- Coordinate line and employee requirements.
- Revise completion dates.
- Update warehouse picking and transport schedules.
- Record unresolved conflicts.
Do not revise production requirements without communicating the consequences to production, procurement and warehouse teams.
12. Coordinate the revised schedules
Ensure that the following schedules agree:
Supplier and replenishment schedule
↓
Production schedule
↓
Warehouse picking and loading schedule
↓
Transport and route schedule
↓
Customer delivery commitment
Check that:
- Stock will be available before picking.
- Production will finish before dispatch.
- Warehouse capacity supports loading.
- Vehicles can carry the planned loads.
- Routes meet customer delivery windows.
- Back orders are reflected across all affected schedules.
13. Communicate schedule changes
Issue an approved schedule-change notice showing:
- Order and customer affected
- Original commitment
- Revised commitment
- Reason for the change
- Operational impact
- Required action
- Responsible person
- Approval
- Communication date
Notify:
- Customer service
- Customer or end user
- Warehouse
- Transport
- Production
- Procurement
- Supplier, where relevant
- Finance, where cost or billing changes
14. Monitor execution
Track:
- Picking completion
- Loading and dispatch
- Vehicle movement
- Delivery status
- Proof of delivery
- Supplier back orders
- Stock receipts
- Production output
- Outstanding customer quantities
- New variances
Escalate deviations that threaten approved customer priorities or delivery commitments.
Practical task
You are provided with actual customer orders, planned delivery schedules, customer priorities, stock shortages and warehouse and transport constraints.
Complete the following:
- Compare actual orders with planned deliveries.
- Prepare a delivery-variance register.
- Identify transport-capacity constraints.
- Identify warehouse-capacity constraints.
- Classify relevant hard and soft constraints.
- Realign deliveries according to customer priorities.
- Reallocate transport capacity.
- Create supplier back orders for stock shortages.
- Resolve procurement demand-and-supply imbalances.
- Align the production schedule with revised operational requirements.
- Submit the coordinated and approved schedules.
Required evidence
Include the following in your Portfolio of Evidence:
- Actual customer-order list
- Original delivery schedule
- Delivery-variance register
- Transport-capacity calculations
- Warehouse-capacity calculations
- Hard-and-soft-constraint register
- Initial and revised delivery schedules
- Revised vehicle and route allocations
- Supplier back-order records
- Updated production schedule
- Schedule-change communications
- Evidence of approval
- Completed observation checklist
- Learner declaration of authenticity
Competence checklist
| Assessment criterion | Competent | Not yet competent | Comments |
|---|---|---|---|
| Identify variances between actual orders and planned deliveries | |||
| Create a complete variance register | |||
| Identify transport-capacity constraints | |||
| Identify warehouse-capacity constraints | |||
| Distinguish hard and soft constraints | |||
| Realign deliveries according to customer priorities | |||
| Identify stock shortages and create supplier back orders | |||
| Reallocate transport capacity using the revised plan | |||
| Resolve demand-and-supply imbalances | |||
| Align production schedules with operational plans | |||
| Coordinate all affected operational schedules | |||
| Submit complete supporting evidence |
Lesson Summary
To coordinate transport and distribution activities, compare actual customer orders with planned deliveries and record all variances. Test the revised requirements against stock, warehouse and transport capacity, and distinguish non-negotiable hard constraints from adjustable soft constraints. Realign deliveries using approved customer priorities, reallocate vehicle capacity and create supplier back orders for stock shortages. Coordinate changes with production, procurement and warehouse schedules, communicate approved revisions and monitor execution until all customer commitments are resolved.