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

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

1 Expert Approved Answer

Step: 1 Unlock

Based on the information in the pivot table a Three Top Sellin... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

On January 1 , 2 0 2 4 , the Allegheny Corporation purchased equipment for $ 3 0 7 , 0 0 0 . The estimated service life of the equipment is 1 0 years and the estimated residual value is $ 2 1 , 0 0 0...

1 A B D E F G H J K M N 2 3 Date GE 4 5 Monthly Returns 8/1/1997 -0.113772 -0.05414 9/2/1997 0.0881428 0.1005412 HD PG -0.133441 0.0368967 6 10/1/1997 -0.052176 0.0672522 -0.012266 7 8 9 10 11...

You are analyzing the leverage of two firms and you note the following (all values in millions of dollars): Debt Book Equity Market Equity Operating Income Interest Expense Firm A 495.54 ...

Using the data please provide answer what other ways might you slice sales revenue to help management understand performance? Lab 4 1 SlaintePivot Updated .XLSX Z File Edit View Insert Format Data...

Using this data answer how much total revenue did the top-selling product generate overall? View Insert Format Data Tools Help Z Q Menus 6 0 8 5 100% - $ % . . .00 123 Defaul 10 G5 x 23 A B C D E F G...

Tax Return Problem: Partnership Instructions: Please complete the required federal partnership income tax return forms for AAA Fast Plumbing for the 2014 tax year based upon the facts presented...

Sales_Order_Quantity_Sold Product_Sale Price 12 105 8 5 85 105 120 6 Product_Code 2004 2005 2004 2002 2001 2004 2004 2003 2004 5 2 95 105 105 8 11 3 100 105 100 2003 7 3 100 95 1 8 7 1 Sales Order_ID...

Job Order costing project ACCT-2302 Project Excel Template Please do the excel template so I can put it correctly. Thanks You work for Thunderduck Custom Tables Inc. This is the first month of...

NOTE: Throughout this lab, every time a screenshot is requested, use your computer's screenshot tool, and paste each screenshot to the same Word document. Label each screenshot in accordance to what...

ACBZ420 Accounting Information Systems, Semester 2 2022. Assignment 3: Dashboard Design and Financial Modelling Due Date: Week 11. Friday 14 October 2022. 11:55pm (evening) AEST Weighting/Value: 20%...

The market value of common stock of a firm is $400 million. The market value of preferred stock is $60 million. The market value of debt is $140 million. The yield to maturity of debt is 5.8% and the...

A town with a population of 164,250 persons who live in 39,050 households is considering introducing a recycling program that would require residents to separate paper from their household waste so...

The least suitable bond for Nadine, a retired widow dependent on steady interest income, is: 5 - year floating rate bond Why? Floating Rate Bonds have variable interest payments tied to a benchmark...

Sunland Company issued $535,000 of 5-year, 5% bonds at 96 on January 1, 2020. The bonds pay interest annually. Prepare the journal entry to record the issuance of the bonds. (Credit account titles...

Use the percentage method of withholding, a FICA rate of 6.2%, a Medicare rate of 1.45%, an SDI rate of 1%, and a state withholding tax of 3.4%. One withholding allowance is $73.08 when paid weekly....

As of November 1, 2017. Mr. Bai decided to open an ice cream shop in Hangzhou. The business will be known as Dairy Queen. During November, Diary Queen entered into the On Nov 11", Dairy Queen paid...

Is it fair that retailers can charge different prices to different consumers for essentially the same product?

Explain in detail how the content, style, and essentials of your news release will help you persuade the public to your point of view.

A shaft carries five masses A, B, C, D and E which revolve at the same radius in planes which are equidistant from one another. The magnitude of the masses in planes A, C and D are 50 kg, 40 kg and...

A professor is conducting research on memory. She shows her subjects (volunteers from her Intro Psych course) a list of words on the computer, with some of the words being food items and the rest of...

Ten long-term psychiatric patients were questioned about how many times they were visited by family members during the previous month. Their responses were as follows: Find (a) The mode, (b) The...

Political theorist Karl Marx is known for his theory that the working class, to put an end to capitalism and establish a communist society, would eventually rise up and overthrow the upper-class...

Given this complexity of interacting variables in human sciences, to what extent is it even possible to single out identiable causes? Is reductionism the only way to identify such causes? How are...

Will children from poor families catch up with children in better circumstances, once placed in an enriched environment?

Are the effects of poverty irreversible?