Ruzic_Tristan_minicase7

00 group ice cream product 201 1419 14 19 202 516 516

Info iconThis preview shows page 1. Sign up to view the full content.

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

Unformatted text preview: am Product $ 2.01 1419 14 19 $ 2.02 516 516 $ 2.04 962 962 $ 2.05 1465 14 65 $ 2.06 1771 1771 $ 2.11 1727 1727 509 509 $ 2.12 $ 2.13 $ 2.15 $ 2.16 $ 2.17 $ 2.19 $ 2.21 903 1487 1827 1339 925 1674 903 14 87 1827 1339 925 1674 97737 37514 60223 97737 Ben and Jerry's Edies T ot al Result Question 3: Sum - Units Mon Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec T ot al Result Region east ice cream 604 2257 2249 3430 2611 3392 3830 1176 4237 2222 2376 2987 31371 Group west T ot al Result ice cream 5014 5618 2620 4 877 5626 7875 1463 4 893 3570 6181 2897 6289 4769 8599 2202 3378 2565 6802 3011 5233 3747 6123 1216 4 203 38700 70071 Overall, ice-cream sales are greater in the Western region than they are in the East . I believe this is due to the fact that on average, states in the West generally stay warmer for longer than they do in the East. I do not believe that seasonality effects the sales of ice-cream that drastically in the Western region because as we notice on the pivot table above, January (which is one of the coldest months), has the highest number of ice-cream sales, unlike the Eastern region where it has the least. Question 4 : Sum - Revenue Regi...
View Full Document

Ask a homework question - tutors are online