Budget & Dashboard: Forecast at Completion, Variance, Cost per Document & a Chart
This lesson is part of the course
In this lesson
You forecast each phase's final cost from actual spend and progress, total the forecast variance with SUMPRODUCT, compute the cost per reviewed document and chart budget against actual spend.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- From Gigabytes to Documents: Custodians, Sources & the Review Population Locked
- The Culling Funnel: De-Duplication, Date Filters, Search Hits & Families Locked
- Review Staffing: Docs per Hour, Working Days, Reviewer Headcount & Cost by Tier Locked
- Prioritised Review: Batch Richness, Cumulative Finds & the Gain Curve Locked
- Sampling the Discard Set: Elusion, Missed Documents, Recall & Margin of Error Locked
- Quality Control: Overturn Rates by Reviewer, Retraining Flags & Missed Calls Locked
- Withheld & Produced: Counts, Pages and Page Numbers with Leading Zeros Locked
- Budget & Dashboard: Forecast at Completion, Variance, Cost per Document & a Chart Locked