Ranking Packages by Benefit-to-Cost with RANK and Cumulative Cost
This lesson is part of the course
In this lesson
You rank all twelve increments of four departments by benefit-to-cost and calculate the cumulative cost in rank order without sorting the list.
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
- The Cost Baseline: Last Year's Actuals by Category Locked
- Cost Drivers and Unit Costs: Rebuilding Costs from Activity Locked
- Decision Packages: Minimum, Current and Enhanced Levels Locked
- Ranking Packages by Benefit-to-Cost with RANK and Cumulative Cost Locked
- The Funding Line: Cut-Off at the Budget Cap Locked
- Savings vs Baseline by Department with SUMIFS Locked
- Incremental vs Zero-Based Budget: The Side-by-Side Comparison Locked
- ZBB Tracking Dashboard: Budget vs Actual and Savings Captured Locked