Levi Strauss interview question

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