I need an excel expert with matrices

In the attached Excel spreadsheet, you will find two data tabs: ALL_range tab has a list of all “mother” SKUs in the portfolio with the indication of the lowest available price and the category of the SKU (ring, earring, necklace and bracelet); on the SALES tab you find all sales information per SKUs per a certain time period. Using 2 data tables provided in this spreadsheet, please build the matrix which shows what is the count of SKUs in each price segment per category and how much revenue and orders each combo (price x category) drive. The matrix needs to allow me to answer these questions: 1) What are the key price x category segments in the portfolio? Why? 2) Please make a recommendation on where (price x category) we can discontinue some SKUs and where we need to launch more products? Why? Notes: 4 Price segments are: <$100, $101 - $250, $251 - $500, $501+ Categories are: Ring, Earring, Necklace, Bracelet The data sets which are needed for this analysis are mother SKU count, Revenue ($) and number of units sold (#). There is much more information in those tabs then you need for your analysis. Only use what you need for the matrix. Please use revenue and unit sales on the net basis.