Portfolio Impact: Budget Effect by Category and a Chart
This lesson is part of the course
In this lesson
You turn ten reviewed contracts into a budget impact: spend × change per contract, totals by category with SUMIFS or SUMPRODUCT, the weighted impact % of the whole portfolio and a column chart for the budget meeting.
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 Adjustment Formula: Fixed, Material and Labour Shares Locked
- Base Dates, Review Dates and Index Lags Locked
- Caps, Floors and Collars – Per Year and Cumulative Locked
- Thresholds and Sharing Bands Locked
- Surcharge Tables and Pass-Through Amounts Locked
- Fixed Escalation vs Index-Linked: Which Is Cheaper? Locked
- Checking a Supplier's Price Claim Locked
- Portfolio Impact: Budget Effect by Category and a Chart Locked