VanillaPM
Sign in Get started free Dashboard
Free calculator

Order-by date calculator

A free order-by date calculator for procurement. Enter the date an item is needed on site and its lead time to get the latest date to order it, the days left, and whether it is on track, due soon or late.

Order byneeded on site − lead time
Status
Days left to order
Order by = needed on site − lead time
Days left = order by − today
Download as Excel (.xlsx) The spreadsheet has live formulas: change the yellow cells and it recalculates.

The rule

An item needed on site on a given date, with a lead time of so many days, must be ordered by:

order by = needed on site − lead time

The lead time is everything between deciding to buy and having it on site: specification sign-off, tendering, approvals, manufacturing, shipping and customs. Long-lead items (chillers, lifts, façade glass, specialist equipment) can take months and quietly become the critical path.

Status

  • Late: the order-by date has passed. Every day now comes off the schedule or costs money to expedite.
  • Due soon: within 30 days. Start the purchase now.
  • On track: more than 30 days away.

VanillaPM uses the same rule in a project's procurement plan, so packages that need ordering soon show up before they hold the work up.

Common mistakes

  • Quoting the supplier's manufacturing time as the lead time, without your own approvals and shipping.
  • Working back from the installation start instead of the date the item must be on site.
  • Not checking the order-by date again when the schedule moves.

The spreadsheet download has a list for up to 30 items, each with its own order-by date and status.

See it used on a real project: Pr5 · Plan and manage procurement