3 Replies Latest reply on Oct 5, 2018 8:54 PM by Alex Martino

    How to visualize the impact of sales mix on total average price

    Alex Martino

      I have a dummy sheet that I created.

       

      I have two product segments with two months of data.

       

      The average price for each product goes UP month over month. HOWEVER, the total average price goes down because the PRODUCT MIX changed to a heavier weight on the lower priced item.

       

      I created tabs that show product price changes, and product mix changes, but I'm trying to figure out a way to depict the impact of the mix movement towards the lower priced item in the product mix. I don't know how to do it. I was thinking you could do an area map with sales mix and then color code for price but that doesn't really help.

       

      Any thoughts?

       

      Spreadsheet attached.