Buying and supplier planning
Backward packaging schedule
Backward packaging schedule planner subtracting contingency, transit, production, proof and design days from a target date to show start date and stage ranges.
Use this planner to work backward from a target delivery date through contingency, transit, production, proof and design. It returns a start-by date and contiguous stage ranges in calendar days, using UTC date arithmetic. Enter written stage durations; defaults are placeholders, not Teal lead-time promises.
Use this tool
Inputs stay in this tab. Results are planning estimates.
Downloads a plain text report of your inputs, results and limitations.
What this backward planner calculates
Packaging Timeline Planner builds a backward packaging schedule from one target delivery date. It subtracts contingency, transit, production, proof and design durations in that order and returns the required Start by date plus a date range for each stage. The calculation uses calendar days and UTC date arithmetic so daylight-saving changes do not shift the result. It is a date arithmetic checklist, not a capacity model. The example durations in the fields are placeholders, not Teal lead-time promises. Obtain written stage durations before using the result as a plan.
Entering the target delivery date
Enter the target delivery date in launch using YYYY-MM-DD, for example 2030-06-30. The field is text because the planner needs an unambiguous date string. The tool rejects values that do not match the pattern and values such as 2030-02-30 that are not real calendar dates. That date is the finish boundary for contingency and the anchor for the whole backward chain. If you move the target one day later, every stage date moves one day later while the entered durations stay unchanged. A time of day, local cut-off or timezone is not modeled. If the delivery commitment is expressed with a local cut-off, this planner still treats it as a date-only target.
Setting stage durations in calendar days
Five integer fields define the sequential calendar-day durations: design and specification, proof and revision, confirmed production, transit, and contingency. Each field accepts whole numbers from 0 to 1000 days. Enter durations that already include weekends and holidays, because the planner counts every calendar day. It does not use a business-day calendar, skip weekends, or model parallel work. Zero produces a zero-day row at the same boundary date. Keep production tied to confirmed production days rather than an optimistic estimate. Design and proof should reflect the revision cycle you actually expect. Contingency is a duration, not a promise that the risk is covered.
Reading the backward stage sequence
The output begins with Start by, the earliest date in the backward chain. Below it are five rows in forward chronological order: Design, Proof, Production, Transit and Contingency. Each row shows the calculated start date, the finish boundary, and the entered calendar-day count. Although the calculation runs backward from the target, the display reads forward so the handoffs are easier to inspect. Rows are contiguous in the model. The finish of Design is the start of Proof, and so on through Contingency, which ends at the target delivery date. The Start by date is a derived boundary, not a confirmed appointment.
Worked example: baseline schedule
With the default target 2030-06-30 and durations design 7, proof 7, production 14, transit 5 and contingency 7, the total is 40 calendar days. The planner returns Start by 2030-05-21. Design is 2030-05-21 to 2030-05-28, Proof is 2030-05-28 to 2030-06-04, Production is 2030-06-04 to 2030-06-18, Transit is 2030-06-18 to 2030-06-23, and Contingency is 2030-06-23 to 2030-06-30. This scenario uses placeholder durations only; replace them with written stage durations.
Worked example: one extra proof week
Change proof from 7 to 14 calendar days and leave every other input unchanged. The planner still uses 2030-06-30 and returns Start by 2030-05-14, seven days earlier than the baseline. Design moves to 2030-05-14 to 2030-05-21. Proof moves to 2030-05-21 to 2030-06-04 with 14 calendar days. Production, transit and contingency keep their baseline ranges because they are anchored to the unchanged target and sit after proof in forward order. The longer proof consumes time earlier in the chain, so the start date moves, not the delivery date.
Edge cases and operational limits
Two edge cases matter. A zero-day stage still appears with the same start and finish boundary and a zero-day count, so do not read its presence as work being performed. Contingency is positioned at the end of the sequence, immediately before the target, not at the beginning as a reserve. Increasing contingency moves the contingency start and all earlier stages earlier while the target stays fixed. The planner does not model parallel proofing, overlapping production, shipping cut-offs, or business-day calendars. Its output is a screening schedule, so get written stage durations and check any assumptions outside this calculator. Record which durations came from a supplier and which are internal estimates so the schedule can be revised when written durations change.
Questions about backward packaging schedule
How does the planner handle weekends and public holidays?
Every entered duration is treated as calendar days, so weekends and public holidays are counted inside the stage. The planner does not apply a business-day calendar or skip non-working dates. Use durations that already reflect your working calendar, or convert working days to calendar days before entry.
Why does increasing contingency move the start date rather than the delivery date?
The target date is fixed as the anchor. Contingency sits immediately before that target in the stage sequence, so extra contingency days push the contingency start earlier and all preceding stages earlier. The delivery date itself does not move unless you change the target date.
What does a zero-day stage look like in the result?
A zero entry still creates a row. Its calculated start and finish boundary are the same date, and the row reports 0 calendar days. That keeps the stage visible in the sequence but does not add elapsed time or force a gap.
Can I schedule design and proof at the same time?
No. The planner subtracts design, proof, production, transit and contingency sequentially, with no overlap or parallel branch. If your process runs design and proof together, this tool cannot represent that relationship directly. Combine the work into one duration or treat the result as a screening schedule.
Sources and further reading
- Original worksheet method: The original calculation or decision rules, units, examples and limitations are explained on this page; this is not an external performance standard.