Optimizing Product Portfolios

How to make sensible decisions when faced with a proliferation of SKUs and Customers? If you do not have access to expensive software, excel can work and can help generate the right visuals.