A reader named John wrote to me with the scenario above, and my first thought was: They need a Sankey diagram.