The Gertz Gummy Bear Company manufactures a variety of gummy bear candies. The gummy bears are available in the following packages: a 6-ounce bag, a 1.6-pound bag, a 5-pound bag, and a 4.5-pound single giant bear box. The following is a sample of Gertz’s open sales orders, or backorders, in an Excel file.

For each of the situations listed below, assume that you would create a pivot table from the open orders data set to answer each question. Indicate which field you would use for the Rows box, which field (if any) you would use for the Columns box, and which field you would use for the Values box. Also indicate what type of calculation you would use to summarize the value field.1. How much gross profit will be generated by each packaging option?2. How much gross profit will be generated by each customer?3. How much gross profit will be generated by the open orders in each city?4. How much gross profit will be generated by each packaging option for each customer?5. How much gross profit will be generated by each packaging option in each city?

Transcribed Image Text:

A A 1 Order # City 2 2890 3 1545 Duluth Allentown Roanoke Joliet Norwalk Danbury Albany Duluth 4 1733 5 1918 6 1570 7 2106 8 2511 9 1400 10 1169 Allentown 11 1435 12 2043 Albany Duluth Customer Lake Grocery The Sweet Shoppe Wood Grocery The Sweet Shoppe The Sweet Shoppe Danbury Grocers North Side Food Lake Grocery Uptown Foods City Grocery Lake Grocery D Package 6 oz. bag 6 oz. bag 1.6 lb. bag 6 oz. bag 5 lb. bag 6 oz. bag 4.5 lb. giant bear 6 oz. bag 6 oz. bag 1.6 lb. bag 6 oz. bag E F Quantity Gross Profit 240.00 370.00 200.10 280.00 175.50 70.00 131.70 240 $ 370 $ 58 $ 280 $ 39 $ 70 $ 6 $ 350 $ 170 $ 85 $ 390 $ 350.00 170.00 293.25 390.00