Schedule Acceleration: Optimizer Example | Vose Software

ModelRisk Optimizer example · Projects and construction

Schedule Acceleration Chosen by the Optimizer

Which activities should be accelerated, at least cost, for an 80% chance of opening the bridge within the contract?

  • Complexity: ★★★★★
  • Free Excel workbook (PC-10)
  • Needs ModelRisk with the Optimizer: free trial

From the model’s saved run

The Optimizer’s plan against the starting plan

The accelerations of the two plans, and how each performs on the same simulated projects.

Completion — S-curves
DecisionUnitStarting planOptimizer’s planChange
A Design: second design team1 = yes–––
C Demolition: extra possessions1 = yes–––
D North piling: second piling rig1 = yes–yesadded
E South piling: second piling rig1 = yes–yesadded
F River pier: pre-cast pier units1 = yes–yesadded
K Deck slab: pre-cast deck units1 = yes–––
MeasureUnitStarting planOptimizer’s planChange
Cost of the accelerationsUS$k0190190
Chance of finishing within the contractchance57.8%82.7%25.0%✔ better
Completion, P50weeks43.641.8−1.8✔ better
Completion, P80weeks45.643.8−1.8✔ better
Completion, meanweeks43.641.9−1.7✔ better
Programme with most likely durationsweeks40.038.6−1.4✔ better
P80 completion datedate14 Jan 20281 Jan 2028
Contract durationweeks4444
On-time chance required (Inputs sheet)chance80%80%

Programme: most likely durations and no flood, the deterministic schedule (Network sheet, section 6).

The business question

A council's road bridge replacement takes 40 weeks with most likely durations, and the contract allows 44. But durations run long and parallel paths merge, so the chance of finishing on time is under 60% (PC-03). Six activities can be accelerated at a price: more designers, extra railway possessions, a second piling rig at either abutment, pre-cast pier units or pre-cast deck units.

Which are worth buying?

Who it is for
Planners, project managers and contractors who prepare, review or recover programmes.
Main outputs
The Optimizer's choice of accelerations against a starting plan with none (PC-03's programme) · for both plans: the cost of the accelerations, the chance of finishing within the contract, P50 and P80 completion and the programme with most likely durations · each activity's criticality index under both plans · the completion S-curves.

What the Optimizer decides

The Optimizer changes the blue cells: 1 accelerates the activity, 0 does it the normal way. The starting plan accelerates nothing: PC-03's programme.

DecisionStarting planOptimizer’s plan
A Design: second design teamNoNo
C Demolition: extra possessionsNoNo
D North piling: second piling rigNoYes
E South piling: second piling rigNoYes
F River pier: pre-cast pier unitsNoYes
K Deck slab: pre-cast deck unitsNoNo
Goal
Minimise the cost of the accelerations
Limit
Chance of finishing on time at least 80%

The Optimizer’s run: Vertex Detector, 64 plans tried, each on 10,000 samples, in 8.0 seconds.

How the model works

Four sheets after this one, read from left to right. Each one feeds the next.

  1. Inputs sheet

    The start date, the contract duration and the chance of meeting it that is required. The flood risk to the river pier; and for each of six activities, the share of its duration that accelerating it saves and what that costs.

  2. Decisions sheet

    The six cells the Optimizer changes, one per activity that can be accelerated: 1 to accelerate it, 0 not to. The starting plan accelerates nothing. The goal is the least cost of the accelerations. The limit is the chance of finishing within the contract.

  3. Network sheet

    Each iteration draws every duration once. Both plans use the same draws, shortened by their own accelerations, and each is scheduled forwards and backwards: its completion, whether it meets the contract and which activities are critical are outputs. Both plans' programmes with most likely durations are calculated too.

  4. Results sheet

    Both plans on the same simulated projects: the cost, the chance of finishing within the contract, P50 and P80 completion, the S-curves, and how often each activity is critical under each plan.

ModelRisk techniques

  • ModelRisk Optimizer: six yes/no decisions
  • Cheapest plan as a value goal
  • On-time chance as a probability limit
  • PERT network with a flood risk
  • Criticality of both plans

Find similar models

The results in detail

Which activities are critical

Criticality index: how often the activity is on the critical path in the simulation, under each plan.

Criticality index — starting plan and Optimizer’s plan
ActivityProgramme criticalStarting plan criticalityOptimizer’s plan criticalityAccelerated in the plan
A Design and approvalsyes100%100%no
B Site set-up and traffic managementyes99%96%–
C Demolish the old bridgeyes99%96%no
D North abutment pilingyes38%40%yes
E South abutment pilingyes43%45%yes
F River pier19%10%yes
G Fabricate steel girders (off site)1%4%–
H North abutment wallsyes38%40%–
I South abutment wallsyes43%45%–
J Deliver and erect girdersyes100%100%–
K Deck slabyes100%100%no
L Waterproofing and surfacingyes92%92%–
M Parapets and finishes8%8%–
N Approach road tie-ins0%0%–
O Testing and openingyes100%100%–

Programme: critical in the starting plan's programme. Accelerated: in the Optimizer’s plan (– = not an option).

How to read these results

  • The starting plan — PC-03's programme, with nothing accelerated — finishes within the 44-week contract in under 60% of the simulated projects, well short of the 80% required.
  • The Optimizer buys a second piling rig at each abutment and pre-cast units for the river pier, for about US$190k. The chance of finishing on time rises to a little over 80%, and P80 completion falls by about two weeks, to within the contract.
  • The pier is not on the 40-week critical path, and on paper its pre-cast units save nothing: the programme is the same with or without them. Accelerate only the pilings and the chance stalls at about three in four, because the pier, with its flood risk, then sets the pace in over a third of the projects.

    With all three accelerated, it does so in about one in ten.

  • Design, demolition and the deck lie on every path, so time saved there counts in full. But each saves only about a week, for US$140k–160k, and no plan that uses them reaches 80% for less.
  • Try a 90% requirement on the Inputs sheet and run the Optimizer again: it adds the pre-cast deck units as well, and the cost rises by about three-quarters.

Run the Optimizer yourself. Open the workbook, open the Optimizer from the ModelRisk ribbon (the saved task opens with it) and press Start; then simulate to compare the plans.

Inputs and assumptions

Every assumption in the model, with its uncertainty and where it comes from. The figures are illustrative.

Programme and target 3 inputs

When the work starts, what the contract allows, and how sure the council wants to be.

AssumptionUnitValue
Start dateNotice to proceed (1 March 2027).date1 Mar 2027
Contract durationCompletion date in the contract: 44 weeks after the start.weeks44
On-time chance requiredThe chance of finishing within the contract that the Optimizer must reach: the council wants P80 or better.chance80%
Risk event 2 inputs

A flood stops work in the river until the water level drops.

AssumptionUnitUncertaintyLowMost likelyHigh
Chance of a flood during the pier worksGauge records: one flood in four winters over the cofferdam's design level.chanceFixed25%
Delay to the river pier from a floodPumping out, inspection and repair of the cofferdam.weeksRisk event · PERT2.03.06.0
Acceleration: time saved 6 inputs

The share of the activity's duration saved if it is accelerated, whatever the duration turns out to be.

AssumptionUnitValue
Design: a second design teamMore designers, and fortnightly reviews with the highway authority instead of one at the end.of its duration10%
Demolition: extra railway possessionsTwo more night possessions a week; the railway charges for each one.of its duration25%
North abutment piling: a second piling rigTwo rigs share the piles; mobilisation and pile testing take as long as before.of its duration20%
South abutment piling: a second piling rigA heavier second rig for the softer ground near the river bank.of its duration20%
River pier: pre-cast pier unitsPier shafts cast off site and lifted into the cofferdam. A flood delays the work as much as before.of its duration25%
Deck slab: pre-cast deck unitsPre-cast planks as permanent formwork: less concrete poured and cured on site.of its duration20%
Acceleration: cost 6 inputs

The extra cost of each acceleration, paid if it is chosen.

AssumptionUnitValue
Design: a second design teamTwo more designers through the design period, and the extra reviews.US$ thousand160
Demolition: extra railway possessionsPossession fees and night-time rates.US$ thousand150
North abutment piling: a second piling rigSecond rig and crew: mobilisation, hire and operators.US$ thousand65
South abutment piling: a second piling rigA heavier rig: higher mobilisation and hire.US$ thousand70
River pier: pre-cast pier unitsCasting yard, transport and a larger crane, less the work saved in the river.US$ thousand55
Deck slab: pre-cast deck unitsPlanks, transport and a larger crane, less the formwork saved.US$ thousand140

Units and conventions

Time
Weeks from the start of the project; dates are the start date plus whole weeks.
Money
US$ thousand (US$k): the extra cost of each acceleration over the normal method.
Accelerate
1 = the activity is accelerated, 0 = it is done the normal way. Accelerating saves a fixed share of the activity's duration, whatever that duration turns out to be.
Critical
An activity is critical in an iteration if it has no float. Its criticality index is the share of iterations in which it is critical.
Programme
The schedule with most likely durations and no flood: the deterministic programme a planner would draw.

Key assumptions and limitations

Logic
Finish-to-start links only, no lags; resources are not limited; accelerating one activity does not slow another.
Acceleration
Each saves a fixed share of its activity's duration for a fixed cost, paid whether or not it turns out to be needed. It does not shorten the flood delay.
Independence
Durations are independent of each other; in practice common causes (productivity, weather) can link them.
Optimizer
Each plan the Optimizer tries is judged on the same 10,000 simulated projects (common random numbers, seed 1) as the simulation on the Results sheet, so plans are compared fairly and the limit the Optimizer met holds on the Results sheet too.
Data
The project, the durations and the acceleration options are invented for this example.

How to use it

  1. Enter your durations on the Network sheet, and your contract, the chance required, the flood risk and your acceleration options on the Inputs sheet.
  2. On the ModelRisk ribbon, open the Optimizer: the task is saved in this workbook. Press Start. When it finishes, apply the best solution: the 1s and 0s on the Decisions sheet change.
  3. Run a simulation from the ModelRisk ribbon (10,000 samples with a fixed seed are set) to compare the new plan with the starting plan on the Results sheet.
  4. To watch the search from the beginning, copy the starting plan onto the Optimizer’s plan first. To see why the 40-week critical path misleads, accelerate only the two pilings and simulate.

ModelRisk functions used

ModelRisk Optimizer
Chooses which activities to accelerate: least cost of the accelerations, with the chance of finishing within the contract at least the chance required.
VosePERT
Each activity's duration from its low, most likely and high estimates.
VoseRiskEvent, VosePERTObject
The flood: no delay, or a PERT number of weeks.
VoseInput, VoseOutput
Name the durations and the outputs of both plans, including whether each activity is critical.
VoseSimProbability, VoseSimPercentile
The chance of finishing on time and the completion percentiles of both plans.
VoseSimMean
The mean completion and each activity's criticality index under both plans.

Further reading

  • Monte Carlo simulation explained (Vose guide)
  • Hulett, D. T. (2009). Practical Schedule Risk Analysis. Gower.
  • Kelley, J. E. (1961). Critical-path planning and scheduling: mathematical basis. Operations Research 9(3), 296–320.
  • PC-03 Schedule risk on a project network: the same bridge and network, with the criticality index and merge bias explained.