Old Salty’s Pretzels sells its gourmet pretzels to grocery stores throughout the United States. An excerpt from a data set of sales transactions from the past year is displayed below.

For each of the following questions, identify the three fields from Old Salty’s data set that would be used to create a pivot table to answer each question. (The field names are Order #, City, Customer, Region, Salesperson #, Package, Quantity, and Gross Profit.)1. How much gross profit was generated in each region for each of the four package options?2. How many of each of the package options were sold in each city?3. How much gross profit was generated by each salesperson within each region?4. How many packages of any type were sold in each city by each salesperson?5. How many packages of any type were sold within each city in each region?6. How much gross profit was generated by each package type for each customer?

Transcribed Image Text:

1 Order # City Customer 2 57-2225 Annandale Annandale Supermarkets 3 50-1979 Brentwood Red Barn Foods 33-2747 Reading North Side Food 71-2766 Reading 24-2220 Brookfield City Grocery Dawson Foods 7 52-2589 Reading 8 18-2953 Carmel City Grocery The Sweet Shoppe Dawson Foods 456 9 70-1543 Annandale 10 47-1454 Annandale Dawson Foods 11 57-1020 Carmel Supreme Foods Region South South North North East North West South South West D E Salesperson # Package 38 29 38 27 19 26 10 22 32 16 24-pack carton Single serving Single serving Single serving Single serving 16-ounce bag Single serving 24-pack carton 16-ounce bag Single serving G Quantity Gross Profit 310 198 99 $ 350 $ 330 $ 180 $ 260 $ 81 $ 120 $ H 99 $ 69 $ 180 $ 328 154 110 392 335 280 173 400