The Gertz Gummy Bear Company manufactures a variety of gummy bear candies. The gummy bears are available

Question:

The Gertz 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 Gertz’s open sales orders, or backorders, in an Excel file.


image


For each of the situations listed below, assume that you would create a pivot table from the open orders data set to answer each question. 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 what type of calculation you would use to summarize the value field.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?

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

Step by Step Answer:

Related Book For  book-img-for-question

Managerial Accounting

ISBN: 9780137858514

7th Edition

Authors: Karen W. Braun, Wendy M. Tietz

Question Posted: