The Jamboree 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 Jamboree’s open sales orders (backorders) in an Excel file. Access the full data set online in the MyLab Accounting exercise.

Using the full data set online, create PivotTables to answer the following questions about the existing open orders.

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 1234 SOTONE 5 6 7 8 9 10 11 12 A Order #City 1210 Racine 2051 Danbury 2183 Lakewood 1273 Albany 2477 Fairfield 1797 Allentown 1593 Joliet B 1369 Fairfield 2231 Albany Racine 1764 2984 Albany C Customer Dell Foods The Sweet Shoppe The Sweet Shoppe City Grocery Fairfield Supermarkets The Sweet Shoppe Canton Foods Dawson Foods City Grocery The Sweet Shoppe City Grocery D Product 6 oz. bag 1.6 lb. bag 1.6 lb. bag 4.5 lb. giant bear 1.6 lb. bag 6 oz. bag 6 oz. bag 1.6 lb. bag 5 lb. bag 1.6 lb. bag 1.6 lb. bag E Quantity Gross Profit 260.00 258.75 279.45 175.60 210.45 190.00 110.00 196.65 373.50 341.55 238.05 260 $ 75 $ 81 $ 8 $ 61 $ 190 $ 110 $ 57 $ 83 $ 99 $ 69 $