Savings vs Baseline by Department with SUMIFS
This lesson is part of the course
In this lesson
You build each department's FY2027 ZBB budget from its funded packages and calculate the savings against the FY2026 baseline, in dollars and in percent.
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