The Crosby Cereal Corporation produces corn flakes and packages them in four different package sizes: a 10.6-ounce box, a 24-ounce box, a 36-ounce box, and a pack of six 36-ounce boxes. The following is a sample of the company’s open sales orders, or 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 the open orders for each product size? Which product size is the most profitable?
2. How much gross profit will be generated by the open orders for each customer? Which customer is the most profitable?
3. How much gross profit will be generated by the open orders in each city? Which city is the most profitable?
4. How much gross profit will be generated by each product size within each city?
5. How much gross profit will be generated by each customer within each city?

Transcribed Image Text:

A A 1 Order # Customer 2 1001 3 1002 4 1003 5 1004 6 1005 7 1006 8 1007 9 1008 10 1009 11 1010 12 B Clark Grocers Schnall Grocery Rockford Grocers Forest Supermarkets Dawson Foods Rockford Grocers Burton Foods Schnall Grocery Dawson Foods Dawson Foods 1011 Easton Groceries C D Product Size 24 oz. box 24 oz. box 10.6 oz. box 36 oz. box 10.6 oz. box 10.6 oz. box City Clarksville Davenport Rockford Forest Victorville Rockford Rockford Pack of 6, 36 oz. boxes 10.6 oz. box 36 oz. box 36 oz. box 36 oz. box Davenport Victorville Victorville Norwalk F Quantity Gross Profit 85 $ 114.75 82 $ 110.70 390 $ 561.60 31 $ 68.20 120 $ 172.80 210 $ 302.40 120.45 316.80 182.60 209.00 160.60 33 $ 220 $ 83 $ 95 $ 73 $