Surcharge Tables and Pass-Through Amounts
This lesson is part of the course
In this lesson
You find the energy surcharge band of each month with an approximate XLOOKUP, calculate an alloy pass-through per kilogram and measure what both surcharges added to eight months of invoices.
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