Attach Rates, Plan Revenue and Contribution by Channel
This lesson is part of the course
In this lesson
You summarise a day of fictional orders by channel with SUMIFS: units, plans, attach rate and plan revenue, then the contribution after expected claims and channel commission, and the pooled attach rate of all channels.
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
- Failure Curves: Monthly Rates, Survival and Cumulative Failure Locked
- Expected Claims per Sales Cohort and the Claims Calendar Locked
- Cost per Claim and the Repair-or-Replace Rule Locked
- Standard Warranty Cost per Unit Sold and as % of Revenue Locked
- Pricing an Extended Warranty: Expected Cost, Margin, Price Points and Loss Ratio Locked
- Attach Rates, Plan Revenue and Contribution by Channel Locked
- Service Contract P&L: Earned Revenue, Pro-Rata Refunds and Claims by Year Locked
- Warranty Dashboard: Claims vs Expectation, Top Failing Product and a Trend Chart Locked