# gg-3 - average amount of a snack sale at all locations...

This preview shows pages 1–2. Sign up to view the full content.

Pivot Table Day 2 1 Pivot Tables Day 1 Preparation Problems ( Key ) R: 3/19/10 With the source data (file: Western-Regional_DataSet.xls) provided with this tutorial, answer the following questions: 1. How much bicycle revenue did the Provo store receive in the month of October? \$ 450 2. How many bicycles did Provo sell in the month of October? 4 3. What was the total revenue received from pajamas comprising all three months and all three stores? \$308.00 4. a). What is the average sum of revenue received for snacks in San Jose for all three months? Hint: you can get the sum of the snack revenue in the pivot table. Then you must divide the sum by the number of months (3) outside of the pivot table. \$10.33 b). What is the average monthly snack revenue received for snacks in all three store? Hint: you can get the sum of the revenue amounts in the pivot table and then you must divide the sum by 9 (3 months X 3 stores) outside of the pivot table. \$12.67 c). What is the average amount of a snack sale at San Jose? What is the

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: average amount of a snack sale at all locations combined? \$4.43, \$4.56 5. What are the top three items sold in total revenue in the San Jose store? Bicycle, Shirt, Shoes – Hint make sure that it is Sum of Amount 6. What percentage of the total revenue of all stores combined for all months did all the stores achieve in October? 30.47% Pivot Table Day 2 2 7. What store would you feel is the best seller? What is the trend in revenue over the three months, Why do you think it was this way? What would you suggest the stores do to increase their sales? The best seller is the Provo Store. The trend is that there was not a large increase in revenue between the months of September and October; however in November there was a large increase in revenue. This is probably due to the increase in sales attributable to the holiday season. All three stores should focus on bike sales since bikes seem to be a major revenue generator....
View Full Document

{[ snackBarMessage ]}

### Page1 / 2

gg-3 - average amount of a snack sale at all locations...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online