Question

In: Operations Management

Create a Pivot Table to compile the following information: 1. The total revenue for each salesperson...

Create a Pivot Table to compile the following information:

1. The total revenue for each salesperson

2. For each salesperson, the total revenue by product

3. Total revenue generated by each salesperson broken down by location

Please provide excel formulas and solutions

https://drive.google.com/open?id=16kL_VoQlIsOCaioggkjnGBFR_GvCrSGM

Solutions

Expert Solution

Solution-

I have attached the file in the google drive(link is below). I have solved each question separately for your understanding.

https://drive.google.com/open?id=1LeIkpmordWz2GVpIZn1fj9EDUqrsxB2h

Also here is the screenshot of the final solution-

keosha answered 11 months ago
Next > < Previous

Related Solutions

Create a PivotTable to combile the following information: 1. The total revenue for each salesperson 2....
Create a PivotTable to combile the following information: 1. The total revenue for each salesperson 2. For each salesperson, the total revenue by product 3. Total revenue generated by each salesperson broken down by location Please provide excel formulas and solutions https://drive.google.com/open?id=16kL_VoQlIsOCaioggkjnGBFR_GvCrSGM
Complete Table 1 by computing the Total Revenue, Marginal Revenue, Total Cost, and Profit columns, each...
Complete Table 1 by computing the Total Revenue, Marginal Revenue, Total Cost, and Profit columns, each rounded to two decimal places. The cost of duplicating a video on a DVD and mailing the DVD, the Marginal Cost, is $5.56. (1 point) Table 1 Suggested Donation per DVD Request Anticipated Number of DVD Requests Total Revenue Marginal Revenue Total Cost Profit $19.00 0 $15.00 2 $9.50 5 $7.75 9 $3.00 15 $0.00 24 b. The President wants the GSTCG to provide...
Complete Table 1 by computing the Total Revenue, Marginal Revenue, Total Cost, and Profit columns, each...
Complete Table 1 by computing the Total Revenue, Marginal Revenue, Total Cost, and Profit columns, each rounded to two decimal places. The cost of duplicating a video on a DVD and mailing the DVD, the Marginal Cost, is $5.56. (1 point) Suggested Donation per DVD Request Anticipated Number of DVD Requests Total Revenue Marginal Revenue Total Cost Profit $19.00 0 $15.00 2 $9.50 5 $7.75 9 $3.00 15 $0.00 24 The President wants the GSTCG to provide videos to generate...
Problem Statement: 1: Using a pivot table, show in an appropriate chart the total number of...
Problem Statement: 1: Using a pivot table, show in an appropriate chart the total number of confirmed voters by percentage and by age group in the United States 2: What conclusions do you draw from the study and chart? State Age Total Population Citizen Population Registered Voters Confirmed Voters Alabama 18 to 24 439000 428000 212000 155000 Alabama 25 to 34 576000 535000 359000 271000 Alabama 35 to 44 615000 582000 410000 330000 Alabama 45 to 64 1297000 1275000 1051000...
The table shows total cost and total revenue information for a perfectly (or purely) competitive firm....
The table shows total cost and total revenue information for a perfectly (or purely) competitive firm. Quantity Total cost Total revenue 00 500500 00 11 600600 135135 22 710710 270270 33 830830 405405 44 960960 540540 55 11001100 675675 66 12501250 810810 77 14101410 945945 88 15801580 10801080 99 17601760 12151215 1010 19501950 13501350 Firms earning a loss will sometimes shut down in the short run. What quantity will the firm produce if it shuts down in the short run?...
4) Consider total cost and total revenue given in the following table: Quantity 0 1 2...
4) Consider total cost and total revenue given in the following table: Quantity 0 1 2 3 4 5 6 7 7 Total Cost $120 150 160 170 190 230 300 410 610 Total Revenue $0 70 140 210 280 350 420 490 560 A. Create a table that includes the fixed cost at each level of output as well as the variable cost at each level of output. If capital is fixed and the firm uses 10 units of...
1. When you used a data model to create a Pivot Table, you receive some errors....
1. When you used a data model to create a Pivot Table, you receive some errors. Which is the likely reason? Select an answer: Your Pivot Table was created from an Excel table. Your Pivot Table contains empty cells. Your Pivot Table did not update changes to your Excel table. Your relationships were not properly defined. 2. When you are creating relationships between tables, the unique values for each row are known as the _____. Select an answer: index data...
Consider total cost and total revenue, given in the following table: In the final column, enter...
Consider total cost and total revenue, given in the following table: In the final column, enter profit for each quantity. (Note: If the firm suffers a loss, enter a negative number in the appropriate cell.) Problems and Applications Q4 Ball Bearings, Inc., faces costs of production as follows: Quantity Total Fixed Costs Total Variable Costs (Dollars) (Dollars) 0 100 0 1 100 50 2 100 70 3 100 90 4 100 140 5 100 200 6 100 360 Complete the...
Use the table to answer the following questions Output Total Revenue Total Cost 0 0 30...
Use the table to answer the following questions Output Total Revenue Total Cost 0 0 30 1 40 55 2 80 98 3 120 125 4 160 152 5 200 180 a) What is the price of the product? b) What is the marginal revenue from the fourth unit output? c) What is the profit, when firm produce 5 units?
1. The basic data structure for a Pivot Table is A. a pie chart B. a...
1. The basic data structure for a Pivot Table is A. a pie chart B. a line chart C. a decision variable D. an uncontrollable E. a multidimensional cube 2. Which traits can describe big data? A. All of the above B. None of the above C. High speed D. High variety E. High volume 3. When you only have one data series to visualize, you do need to add a legend. True False 4. Which of the following would...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT