The Clayton 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.

For each of the situations listed below, assume that you would create a PivotTable from the open orders data set to answer the question. In this exercise, profitability is measured by total gross profit. 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 how you would sort the PivotTable.

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 cities are 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 1 Order # Customer 2 43755 3 70844 4 62936 49850 75869 27704 18279 13199 77539 37912 87355 Dawson Foods B 5 6 7 8 9 10 11 12 Lester Foods City Grocery Burton Foods Burton Foods Smith Co op Forest Supermarkets Dawson Foods City Grocery Dawson Foods Easton Groceries с City Sherrodsville Akron Norwalk Rockford Hayward Forest Forest Akron Dayton Norwalk Dayton D Product Size Pack of 6, 36 oz. boxes 24 oz. box 10.6 oz. box 36 oz. box 24 oz. box Pack of 6, 36 oz. boxes 24 oz. box 36 oz. box 36 oz. box 24 oz. box 24 oz. box E F Quantity Gross Profit 803.00 216.00 547.20 114.40 378.00 248.20 526.50 79.20 171.60 68.85 44.55 220 $ 160 $ 380 $ 52 $ 280 $ 68 $ 390 $ 36 $ 78 $ 51 $ 33 $