31 A B C D E F G H J 19 1234567822222222222222220 29 3 Product Description...

Transcribed Image Text:

31 A B C D E F G H J 19 1234567822222222222222220 29 3 Product Description Pale Ale 5 Imperial IPA IPA Imperial Stout Stout Sum of Revenue 11020 7320 Wheat 23500 Stout 27090 Imperial Stout 16150 Wheat 10710 IPA 10 Grand Total 95790 Imperial IPA Pale Ale 0 Employee ID Sum of Revenue +1006 46540 Imperial IPA 6000 18000 Imperial Stout 10290 16000 IPA 10700 14000 12000 Pale Ale 6935 10000 Stout 7395 8000 Wheat 5220 6000 +1007 49250 4000 Imperial IPA 1320 2000 Imperial Stout 16800 0 IPA 12800 Pale Ale 4085 Stout 8755 Wheat 5490 Grand Total 95790 Imperial IPA Imperial Stout IPA Pale Ale Total 5000 10000 15000 20000 25000 Q1. Based on the screenshot of the Pivot Chart shown above: (a) What are the three top selling product? (b) Which employee is generating more revenue to Slainte? (c) How much revenue does this employee (in (b)) generate for each of the top three selling product? 1006 Stout Wheat Imperial IPA Imperial Stout 1007 IPA Pale Ale Total Stout Wheat 30000 31 A B C D E F G H J 19 1234567822222222222222220 29 3 Product Description Pale Ale 5 Imperial IPA IPA Imperial Stout Stout Sum of Revenue 11020 7320 Wheat 23500 Stout 27090 Imperial Stout 16150 Wheat 10710 IPA 10 Grand Total 95790 Imperial IPA Pale Ale 0 Employee ID Sum of Revenue +1006 46540 Imperial IPA 6000 18000 Imperial Stout 10290 16000 IPA 10700 14000 12000 Pale Ale 6935 10000 Stout 7395 8000 Wheat 5220 6000 +1007 49250 4000 Imperial IPA 1320 2000 Imperial Stout 16800 0 IPA 12800 Pale Ale 4085 Stout 8755 Wheat 5490 Grand Total 95790 Imperial IPA Imperial Stout IPA Pale Ale Total 5000 10000 15000 20000 25000 Q1. Based on the screenshot of the Pivot Chart shown above: (a) What are the three top selling product? (b) Which employee is generating more revenue to Slainte? (c) How much revenue does this employee (in (b)) generate for each of the top three selling product? 1006 Stout Wheat Imperial IPA Imperial Stout 1007 IPA Pale Ale Total Stout Wheat 30000