The Clayton Cereal Corporation produces corn flakes and packages them in four different package sizes: a 10.6-ounce

Question:

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?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: