The Franklin 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 pivot tables 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 2 3 1 Order # Customer 45788 Dell Foods 49994 Quick Market 63823 Quick Market 37697 City Grocery 74318 Dawson Foods 58621 Schnall Grocery 13046 Burton Foods City Grocery 61094 B 4567899 10 74366 Clark Grocers 11 77953 Forest Supermarkets 12 14502 Dawson Foods C City Lowell Hillsboro Hillsboro Akron Forest D Product Size 24 oz. box 10.6 oz. box 24 oz. box 36 oz. box 36 oz. box Davenport 10.6 oz. box Hayward 10.6 oz. box Akron Forest Forest Pack of 6, 36 oz. boxes Clarksville 36 oz. box 10.6 oz. box 24 oz. box E F Quantity Gross Profit 31.05 141.12 94.50 308.00 23 $ 98 $ 70 $ 140 $ 44 $ 66 $ 72 $ 270 $ 82 $ 77 $ 97 $ 96.80 95.04 103.68 985.50 180.40 110.88 130.95