Statistical PERT™ (SPERT™) Estimation Worksheet for Revenue Forecasting
UPDATED for 2023! To be used in conjunction with Evaluating Benefits: Getting Statistical (Part 2). This template evaluates uncertain revenue. Probabilities describe the area under the curve to the right of the planning estimate, answering the question, "What is the probability of earning at least $X or more revenue?" To use this template, enter 3-point, revenue estimates under the Pessimistic, Most Likely and Optimistic columns. Choose a confidence value for the Most Likely estimate under the Most Likely Confidence column. Examine the SPERT probabilistic estimates for various confidence levels: Show/hide columns O through Z. Choose whether you want unskewed (it uses the mode) or skewed (it uses the estimated mean).
Version 5 includes:
- SPERT Normal Scheduler, which lets project managers create a probabilistic schedule by estimating their project's critical path at either the task or activity level
- SPERT Normal - CFD Charts, which creates a visual picture of an agile (or any other) team's workflow process using a dynamically-drawn, cumulative flow diagram (CFD). CFDs are popular among some agile teams who use a Kanban board and are interested in their flow.
- NEW for 2023: 2023 federal holidays and other time-off dates plus other minor tweaks
Version 4 included these new features:
- New Monte Carlo simulation worksheet simulates a single, random variable 10,000 times, then charts the results using a dynamic histogram
- New agile burn-up chart visually forecasts three probabilistic agile delivery dates using historical data
- Specify an explicit standard deviation for any uncertainty on any worksheet
Related Content
Evaluating Benefits: Getting Statistical (Part 1)
byEvaluating Benefits: Getting Statistical (Part 2)
byEvaluating Benefits: Getting Statistical (Part 3)
byRisk Management Starts Sooner Than You Think
byGetting Beta with Statistical PERT
byStatistical PERT™ (SPERT™) Estimation Worksheet
PREMIUM deliverable
by
Statistical PERT® Beta Edition
deliverable
by
People who downloaded this item also downloaded . . .
Project Plan/Project Definition
PREMIUM deliverable
At-a-Glance Weekly Project Status Report
PREMIUM deliverable
Statistical PERT™ (SPERT™) Estimation Worksheet
PREMIUM deliverable
by
4,465
Downloads
Reviews (13)
Login/join to subscribe
Page:
Page:
ADVERTISEMENTS
|
"If a man will begin with certainties, he shall end in doubts; but if he will be content to begin with doubts, he shall end in certainties." - Francis Bacon |
