Site Planning & Progress Kit

When to use it

During execution planning: compare required quantity with crew output to estimate a reviewable duration.

Productivity: output per working day, not completion percentage.

What you get after purchase

  • Planning and progress calculator for four main activities: quantity, output per crew, crews, completed work and budget.
  • Duration and remaining days per activity, plus earned-value weighted progress.
  • SPI from approved plans and CPI from incurred cost, a final-cost estimate and trade-specific recovery crews after readiness waits, with three comparison charts.
  • 39 inputs link four trades to approved planned progress, incurred actual cost, remaining cost and readiness waits. Three tables and three charts cover progress, cost and required crews; SPI uses activity plans, not time elapsed, and recovery crews remain trade-specific. Final cost = actual + remaining; no contractual finish is inferred from SPI or assumed parallel execution.
  • Bilingual Excel file: activity tracker with automatic durations and earned value, a weekly S-curve with SPI, CPI, estimate at completion and a chart, a three-week look-ahead with constraint checks and PPC, and a daily site report form.
  • Gift book: Construction Management Book.

A fixed-number teaching example, open to everyone before purchase, so you can see how it works.

Supporting your chances of success

This kit combines precise calculations with guidance and organisation to help you work towards your goal. We help you organise inputs, understand options and assess strengths and risks, then suggest practical steps suited to its subject — such as pricing, cash flow or marketing.

Guidance supports decisions, not guaranteed success; estimates depend on the accuracy of your inputs.

Understand the kit step by step

The kit connects delivery quantities with baseline, budget, cost and readiness. Keep duration and weighted progress, but never infer planned value from elapsed time or combine unlike trade crews. Approved activity plans provide targets, measurement provides earned value, and incurred cost provides financial performance.

What to prepare before starting

Gather four trade quantities, single-crew productivity, crew counts, accepted completed work and budgets. Bring approved planned percentages at review, incurred cost, remaining estimates and readiness waits. Use one scope and reporting date for measurement and cost.

From information to a decision

  1. Duration = quantity ÷ (single-crew output × crews). Excavation and plaster crews are not interchangeable.
  2. Budget × measured completion gives EV; budget × approved planned completion gives PV. Overall progress is budget-weighted, not an average of percentages.
  3. SPI=EV÷PV and CPI=EV÷AC; zero denominators mean unavailable, not success or zero performance.
  4. Final estimate = incurred actual cost + remaining cost estimate. Compare it with budget; constant-CPI forecast is a separate scenario, never added to it.
  5. Subtract readiness wait from remaining days; round required crews up separately by trade. No finite recovery plan exists once the window is exhausted.
  6. In Excel align review date and weekend pattern, update measurement and weekly increments, then reconcile earned value. PPC uses due commitments only; record delivery evidence and constraint owner.

A simple example to explain the idea

Integrated case: budget399000; earned138200; approved planned164750; SPI≈0.839 and CPI≈0.886 at incurred cost156000. Remaining estimate271000 gives final427000, an overrun28000. With30 working days left,5200m² plaster at25m² per crew-day and10 readiness days needs11 crews versus6 current:5 extra only if independent work fronts exist. Small duration case:240m²÷(40×2)=3 days.

These figures are illustrative, not approved prices or guaranteed forecasts; they may differ from the worked example below.

How to interpret and use the result

Calculator charts are snapshots, not invented history: plan versus measurement, budget versus final cost, and current versus recovery crews. Excel S-curve uses actual weekly increments. Extra crews do not establish parallel feasibility, and SPI does not establish finish date.

A common mistake to avoid

This is not a linked critical-path programme. SPI returns to1 at completion even when late; actual finish needs separate measurement. Excel counts a working start as day one and shifts nonworking starts to the next workday. Review project-specific holidays separately; the workbook offers weekend patterns.

Reading the detailed operating plan

39 inputs link four trades to approved planned progress, incurred actual cost, remaining cost and readiness waits. Three tables and three charts cover progress, cost and required crews; SPI uses activity plans, not time elapsed, and recovery crews remain trade-specific. Final cost = actual + remaining; no contractual finish is inferred from SPI or assumed parallel execution.

Gift book with the kit

Construction Management Book

After payment you choose the book edition — bilingual or English — and it is added to your library with the kit.