The Star 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 Star’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 A 1 Order # City 2 2141 3 2917 4 2104 5 2662 6 1105 7 2054 8 2908 9 2167 10 1646 11 2762 12 1534 B с Customer Fairfield Supermarkets Fairfield Duluth Albany Albany Joliet Albany Allentown Fairfield Dawson Foods Fairfield Dawson Foods Allentown All Foods Inc Roanoke Wood Grocery Red Barn Foods North Side Food City Grocery Dawson Foods City Grocery The Sweet Shoppe D Package 6 oz. bag 5 lb. bag 1.6 lb. bag 4.5 lb. giant bear 6 oz. bag 5 lb. bag 1.6 lb. bag 6 oz. bag 1.6 lb. bag 6 oz. bag 1.6 lb. bag E Quantity Gross Profit 310.00 198.00 327.75 153.65 110.00 391.50 334.65 280.00 172.50 400.00 217.35 F 310 $ 44 $ 95 $ 7 $ 110 $ 87 $ 97 $ 280 $ 50 $ 400 $ 63 $