Product Families: Rolling SKUs Up for the Planning Horizon
This lesson is part of the course
In this lesson
You roll ten SKU forecasts up into three product families with SUMIFS and COUNTIF, total each family over six months in one SUMPRODUCT and measure its share of the volume: the level at which every S&OP meeting talks.
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
- Product Families: Rolling SKUs Up for the Planning Horizon Locked
- Consensus Demand: Statistical Forecast, Adjustments & the Change Log Locked
- Capacity Check: Hours per Unit, Utilisation & Gaps by Month Locked
- Closing the Gap: Overtime, Extra Shifts or Building Ahead Locked
- Projected Inventory: Closing Stock, Days of Cover & the Target Band Locked
- Level vs Chase: Two Production Strategies Costed Side by Side Locked
- Scenarios: Upside and Downside Demand Against Capacity Locked
- The Financial View & the Monthly S&OP Pack Locked