Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

31 A B C D E F G H J 19 1234567822222222222222220 29 3 Product Description Pale Ale 5 Imperial IPA IPA Imperial Stout

image

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Based on the information in the pivot table a Three Top Sellin... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Elementary Statistics In Social Research Essentials

Authors: Jack A. Levin, James Alan Fox

3rd Edition

0205638007, 978-0205638000

Students also viewed these Accounting questions

Question

What are the strengths and weaknesses of arguments by analogy?

Answered: 1 week ago

Question

Example FJF preemptive

Answered: 1 week ago

Question

Define Administration and Management

Answered: 1 week ago

Question

Define organisational structure

Answered: 1 week ago

Question

Are the effects of poverty irreversible?

Answered: 1 week ago