Import a PivotTable into Cell C$3$ summarizing each Supplier in rows, then calculate an average price, formatted as currency. Calculate a sum of spend as $\%$ of column total, and label as $"\%$ of Spend." Duplicate your PivotTable in cell C$13,$ but replacing Suppliers with Parts, and in C$30,$ but replacing Suppliers with Locations. Sort all three PivotTables in descending order by $\%$ of Spend.