Keep the decision fields together.
- Event date
- Required arrival date
- Working-day or calendar-day rule
- Arrival buffer
- Brief and artwork
- Sample and revision
- Final specification and roster
- Production
- Inspection and packing
- Transport and customs
Plan backwards from the required arrival date across brief, artwork, samples, roster approval, production, inspection, freight and buffer.
The important fields remain readable on this page. The Excel file adds editable cells, dropdowns, checks or formulas where relevant.
| Stage | Decision |
|---|---|
| Brief & scope | Products, quantities, destination and arrival |
| Artwork & sample | Files, placement and approval scope |
| Final approval | Specification, roster and production release |
| Production & inspection | Separate confirmed stages |
| Transport & buffer | Freight, customs, final delivery and event protection |
Fictional worked example. Every duration is an editable planning assumption, not a KITOEM lead-time promise.
| Stage | Illustrative dates | Duration basis | Owner | Start trigger |
|---|---|---|---|---|
| Brief & product scope | 04-10 May | 5 working days | Buyer project lead | Event date, destination and product lines available |
| Artwork confirmation | 11-17 May | 5 working days | Buyer artwork owner + supplier | Usable artwork files and placement brief available |
| Sample development | 18 May-07 Jun | 15 working days | Supplier development team | Artwork direction and sample scope confirmed |
| Sample review + one revision | 08-14 Jun | 5 working days | Buyer approver | Sample received; one consolidated feedback round |
| Roster & specification freeze | 15-17 Jun | 3 working days | Buyer roster owner | Revision accepted; product chart and roster ready |
| Production | 18 Jun-22 Jul | 25 working days | Supplier production lead | Written release conditions satisfied |
| Inspection & packing | 23-27 Jul | 3 working days | Supplier quality/packing owner | Production complete; check plan and packing list available |
| Transport & customs | 28 Jul-10 Aug | 10 working days | Agreed logistics owner | Shipment released with required documents |
| Arrival protection buffer | 11-19 Aug | 7 working days | Buyer project lead | Shipment arrival tracked against 20 Aug target |
Enter the event date and the earlier required arrival date.
Choose working days or calendar days for the planning model.
Replace every demonstration duration with the written project assumption.
Work backwards through freight, production and approvals.
Record the actual start condition for each stage.
Using the match date as the delivery date.
Calling production time the total lead time.
Forgetting sample review and roster approval.
Treating the editable demonstration durations as a supplier commitment.
No. They are editable demonstration assumptions and must be replaced by the written plan for the actual project.
Production completion, dispatch, customs, final delivery and arrival are different milestones with different responsibilities.
Yes. The workbook lets you switch between working-day and calendar-day calculations.