Daily challenge · Monday 1 December 2025MEDIUM
Tune the demand forecast mix
Leadership wants a weighted read on the forecast versus actual run-rate for priority segments. Build the weighted metrics and variance so the mix updates automatically.
Goal
Multiply each segment's forecast and actual units by its weight, surface the variance per segment, and then roll everything into weighted totals and an aggregate variance.
Columns E and F should multiply the units by column D. In J2 and J3 sum the weighted columns. In J4 subtract the weighted forecast total from the weighted actual total.