After sorting products by annual usage value from largest to smallest, add each value to the values above it. Divide that cumulative amount by the grand total. The running sum includes the current item. Ties use SKU as a stable secondary sort so repeated reports agree.
You work on Pine Harbor Distribution's fictional planning file. Before calculating, check the time period, the unit and which business event each input records. Keep those definitions in the workbook so another analyst can reproduce the result. The first task gives you the steps. Later tasks use new quantities, a boundary case and a handoff to another planner. Your answer is recalculated on a second copy of the inputs, so enter a formula rather than a number copied from the example.
Calculate (value before this SKU plus this SKU value) divided by total annual usage value.