Levi Strauss Interview Question

Do a pivot table and vlookup based on the data provided.