ERP Migration & SelectionFree calculatorPDF, Excel, Word exportSAP S/4HANA

SAP Migration Schedule Risk PERT Calculator

A single go-live date hides how uncertain it is. A three-point estimate shows the spread, and the confidence level tells you how much reserve you need to promise a date you can keep.

Your numbers

months

Everything goes well; about a 5 percent chance of being this fast or faster.

months

Your honest single-point plan.

months

Serious but realistic setbacks such as failed rehearsals or late data cleansing.

$ per month

Total monthly team and vendor cost.

Your results

Duration to commit at chosen confidence
21 months
Duration you can promise with the selected probability.
Cost of the schedule reserve
$883,702
Budget needed if the reserve is fully used.
PERT expected duration
19 months
Weighted mean of the three points.
Standard deviation
2.3333
Spread of the estimate in months.
Z score for chosen confidence
0.8416
Schedule reserve over expected
2 months

PERT assumes a roughly normal total duration and independent risks. Real programs have correlated risks; treat the output as a discussion aid.

Save results:

Committed duration vs optimistic estimate

Sweeps Optimistic duration from 6 to 18, holding your other inputs fixed.

Schedule risk review

Optional: share your three-point estimates and we will highlight where reserve is usually underestimated.

Optional. The tool and every export work without this. No spam.

How to use it

Ask the program team for three numbers for the full duration: optimistic, most likely and pessimistic. Do this independently, then compare. Pick the confidence level the sponsor wants for the committed date. The calculator returns the PERT expected duration, the standard deviation, and the duration to commit at that level, with the cost of the schedule reserve based on your monthly burn rate.

  • Collect estimates from several leads separately
  • Keep pessimistic realistic, not catastrophic
  • Choose confidence with the sponsor, not alone
  • Review monthly as rehearsals complete

The formula

Expected duration is (optimistic + 4 x most likely + pessimistic) / 6. Standard deviation is (pessimistic - optimistic) / 6. The commitment duration is expected plus z times the standard deviation, where z comes from the inverse normal distribution for your confidence level; at 80 percent z is about 0.84 and at 90 percent about 1.28. The difference between commitment and expected duration is the reserve, which multiplied by the burn rate gives its cost.

Common mistakes

Teams often set the pessimistic case too close to the likely one, which understates risk, or treat PERT as a prediction rather than a model. If critical-path risks are correlated, such as late data cleansing causing both test and cutover delays, true uncertainty is wider than shown. Use the reserve cost to start an honest conversation about contingency instead of hiding it inside task estimates.

Frequently Asked Questions

Why divide by six?

In the PERT approximation, the range between optimistic and pessimistic covers about six standard deviations of a roughly bell-shaped distribution, so one sixth of the range is the standard deviation.

Which confidence level should I commit to?

Many sponsors accept 80 percent for internal plans and 90 percent for external or contractual dates. Higher confidence costs more reserve, so make the trade-off explicit.

Does this replace critical path analysis?

No. It summarises uncertainty at the program level. Use a schedule with a critical path and, if needed, a Monte Carlo tool for detailed risk analysis.

Can I use weeks instead of months?

Yes, as long as all three estimates use the same unit. The labels say months, but the arithmetic is unit-free; adjust the burn rate to the same period.

Netray can build a private assistant over your plans, risk logs and status reports to help track schedule drift across workstreams.

Talk to an ExpertExplore More Free Tools

Related Tools

SAP

S/4HANA Conversion Downtime Window Calculator

Estimate the business downtime of an ECC to S/4HANA conversion and check whether it fits your cutover weekend.

ERP Migration & Selection

SAP Migration Project Team Cost Calculator

Budget the people cost of an S/4HANA program including internal staff, backfill and contingency.

ERP Migration & Selection

S/4HANA Migration Risk Register Worksheet

A ready-to-edit risk register for SAP migration programs with scoring, owners and mitigations.

ERP Migration & Selection

S/4HANA Migration Business Case NPV Calculator

Test whether your S/4HANA investment pays back, and how sensitive it is to benefit realisation.

More ERP Migration & Selection tools

See all
Back to All Tools