This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full 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
- Winter '11