MEP Lead-Time Calendars: Convert Working Days into Dated Milestones

Original illustrative engineering schematic. The worked calculation below uses explicit example inputs.
A quotation stating a ten-day lead time does not yet provide a usable delivery date. The ten days may mean working days, calendar days, or a duration that starts only after approved drawings and payment. The factory, carrier and site can operate different calendars. Adding the numbers as though all days are interchangeable can create an apparently comfortable programme that is already late on paper.
This article is a deterministic scheduling example for an ordinary MEP equipment package. It is not a supplier promise, a customs forecast or advice about contractual entitlement. Dates and shutdowns below are invented assumptions. No national holiday calendar is being asserted. Obtain the actual calendar and commercial start conditions from the responsible parties before making a delivery commitment.
1. Establish the release boundary
Define release as the point when all prerequisites for the supplier duration are satisfied, not merely the date an enquiry was issued. In the example, an approved package is released at the end of Monday, 26 October 2026. The first counted manufacturing day is the next eligible factory day. If the supplier counts the release day or applies an earlier daily cutoff, that is a different model and must be stated.
Assume the factory works Monday through Friday, excludes weekends, and has one additional shutdown on Friday, 30 October. Manufacturing takes ten eligible factory days. Shipping then takes three calendar days, counted after manufacturing completion. Site receiving works Sunday through Thursday, with Friday and Saturday unavailable. These separate assumptions are deliberate; they are not defaults to impose on a real supplier or Qatar project.
2. Count the factory days explicitly
The first three factory days are 27, 28 and 29 October. The assumed 30 October shutdown and the following weekend are skipped. Days four through eight fall on 2–6 November. The next weekend is skipped, and days nine and ten are 9 and 10 November. Manufacturing therefore completes at the end of Tuesday, 10 November, under the stated full-day counting convention.
Release boundary: end of 26 October 2026.
Ten factory working days, with the stated shutdown: completion 10 November.
Three calendar transit days after completion: nominal arrival 13 November.
Next available Sunday–Thursday receiving day: 15 November 2026.
The nominal arrival is Friday, so the assumed site receiving calendar moves receipt to Sunday. This does not mean the carrier waits free of charge or can safely hold equipment anywhere. Storage, booking and unloading arrangements remain separate practical questions. The milestone means only that 15 November is the next eligible receiving date in this example.

Original illustrative estimating graphic. Inputs are hypothetical and do not establish project performance.
3. Make the spreadsheet reproduce the counting rule
Microsoft documents WORKDAY.INTL as a workday-offset function with custom weekends and an optional exclusion list. For the factory calculation, use a real date cell for 26 October, an offset of ten, weekend code 1 for Saturday/Sunday, and a holiday-range cell containing the assumed 30 October shutdown. Format the returned serial value as a date. Avoid ambiguous text dates that can change meaning with spreadsheet locale.
Factory finish = WORKDAY.INTL(DATE(2026,10,26),10,1,ShutdownDates).
Nominal arrival = FactoryFinish + 3.
First eligible receipt on or after arrival = WORKDAY.INTL(NominalArrival − 1,1,7,SiteExclusions).
Weekend code 7 excludes Friday and Saturday; SiteExclusions must contain actual agreed exclusions, if any.
Subtracting one day before advancing one eligible day makes the receiving formula include the arrival date when it is already a permitted receiving day. Without that boundary adjustment, an eligible arrival could be pushed unnecessarily to the next workday. This formula is an original implementation example, not a claim that a purchased template contains it. Check it against a visible calendar before relying on the output.
4. Compare the shortcuts without hiding their assumptions
Adding ten calendar days to the release date gives 5 November rather than the modelled factory finish of 10 November. Adding three more calendar days gives 8 November, which happens to be an eligible receiving day. The shortcut therefore places receipt seven calendar days earlier than the properly separated example. Ignoring only the factory shutdown gives completion on 9 November and nominal arrival on 12 November, avoiding the receiving weekend.
That one-day factory difference changes the receipt milestone by three calendar days in this example, from Thursday to Sunday. It illustrates a calendar interaction, not a claim that every one-day delay has a three-day effect. The outcome depends on the release date, transit convention and receiving calendar. Test the actual dates instead of applying a universal delay multiplier.
5. Preserve the schedule logic around the date
The GAO Schedule Assessment Guide treats reliable schedules as linked models with justified durations and resource availability. A correct workday calculation for one package does not establish the project critical path or available float. Receiving may precede inspection, movement to the installation area, installation and commissioning. Each activity needs its own applicable calendar and predecessor relationship; a spreadsheet date should not silently replace that network.
Before adopting the milestone, record the release prerequisites, start-day convention, supplier workweek, shutdown source, transit-day basis, receiving restrictions and update owner. For partial days, timezone cutoffs or shift-based production, use a suitably detailed schedule rather than forcing everything into integer dates. The practical next step is to replace a bare lead-time number with these dated assumptions. The MEP Estimators Handbook provides a broader estimating and tender-review reference, without implying that it supplies the example calendar or guarantees delivery.
Continue the calculation review
Sources and calculation basis
Primary references checked on 25 October 2026. The worked examples and diagrams are original illustrative calculations, not manufacturer selections or project approvals. Apply the stated limitations and the requirements governing the actual project.

Comments