Question

In: Operations Management

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

Solutions

Expert Solution

There are no formulas. Only select the entire data and go to insert - > insert pivot table

keosha answered 1 year ago
Next > < Previous

Related Solutions

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
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...
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...
2. For the following total revenue and total cost functions of a firm: TR = 800Q...
2. For the following total revenue and total cost functions of a firm: TR = 800Q – 10Q2 TC = (2/3)Q3 -30Q2 + 672Q +4000 (a) Determine the level of output at which the firm maximizes total profit (b) Calculate the profit (need step by step, please)
Consider the following data: quantity total cost total revenue 0 3 0 1 9 12 2...
Consider the following data: quantity total cost total revenue 0 3 0 1 9 12 2 16 24 3 24 36 4 33 48 5 45 60 6 58 72 7 74 84 a. Calculate the profit for each quantity. How many units should this firm produce to maximize profit? b. Calculate MR for each quantity. Calculate MC for each quantity. Does the profit-maximizing formula support your answer from part a? c. Is this firm perfectly competitive? How do you...
Create a class named Salesperson. Data fields for Salesperson include an integer ID number and a...
Create a class named Salesperson. Data fields for Salesperson include an integer ID number and a doubleannual sales amount. Methods include a constructor that requires values for both data fields, as well as get and set methods for each of the data fields. Write an application named DemoSalesperson that declares an array of 10 Salesperson objects. Set each ID number to 9999 and each sales value to zero. Display the 10 Salesperson objects. public class DemoSalesperson { public static void...
Complete the following cost and revenue schedule.    Price Quantity Demanded Total Revenue Marginal Revenue Total...
Complete the following cost and revenue schedule.    Price Quantity Demanded Total Revenue Marginal Revenue Total Cost Marginal Cost Average Total Cost 200 0 240 180 10 360 160 20 500 140 30 660 120 40 840 100 50 1040 80 60 1260 60 70 1500 40 80 1760 20 90 2040 a. At what rate of output are profits maximized within this range? b. What are total profits at that output rate?
For each of the following, identify whether total revenue rises, falls, or remains constant:
For each of the following, identify whether total revenue rises, falls, or remains constant: (a) Demand is inelastic and price falls.   (b) Demand is elastic and price rises   (c) Demand is unit elastic and price rises   (d) Demand is inelastic and price rises   (e) Demand is elastic and price falls.
1. Total revenue minus total cost is equal to a. the rate of return b.marginal revenue...
1. Total revenue minus total cost is equal to a. the rate of return b.marginal revenue c.profit d.net cost 2. The Wax Works sells 400 candles at a price of $10 per candle. The Wax Works' total costs for producing 400 candles are $500. The Wax Works' economic profit is ____ 3.if diminishing marginal returns have already set in for The Picture Perfect Framing Store and the marginal product of the fifth picture framer is 20, then the marginal product...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT