Question: Excel PIVOT TABLES. For each question, create a new pivotable: Find during each month the percentage of sales generated by each salesperson Determine the units

  1. Excel PIVOT TABLES. For each question, create a new pivotable:
    1. Find during each month the percentage of sales generated by each salesperson
    2. Determine the units sold by each salesperson of each product. Use a Slicer to summarize sales during January-March. Create a Chart to determine the revenue brought in by each salesperson for each location. You may create a PivotTable with a PivotChart or use the regular Excel Chart functions. Your chart must show a title, and labels on both axis.
    3. ProductSalespersonMonthLocationUnitsRevenue
      Napoleon (piece)CharleneNovemberEast99$ 346.50
      Napoleon (piece)CharleneJanuaryEast32$ 112.00
      Fresh fruit tart--tropicalCharleneDecemberEast35$ 630.00
      Sacher torteCharleneFebruaryEast37$ 1,110.00
      Napoleon (piece)CharleneAugustEast38$ 133.00
      Vanilla éclairCharleneDecemberEast84$ 294.00
      Pear CharlotteCharleneOctoberEast60$ 1,500.00
      Tahiti (vanilla-rum) cakeCharleneJuneEast86$ 2,752.00
      Raspberry CharlotteCharleneAugustEast60$ 1,500.00
      Caramel éclairCharleneMarchEast30$ 105.00
      Petits fours, per 12DamonJanuaryEast84$ 1,344.00
      Vanilla éclairDamonSeptemberEast75$ 262.50
      Petits fours, per 12DamonNovemberEast85$ 1,360.00
      Raspberry CharlotteDamonAugustEast77$ 1,925.00
      Orange-passion flanDamonFebruaryEast17$ 391.00
      Tahiti (vanilla-rum) cakeDamonNovemberEast79$ 2,528.00
      Tahiti (vanilla-rum) cakeDamonJanuaryEast100$ 3,200.00
      Opéra torteDamonDecemberEast76$ 2,432.00
      Napoleon (piece)DamonAugustEast21$ 73.50
      Napoleon (piece)DamonMarchEast89$ 311.50
      Chocolate éclairHongOctoberEast66$ 231.00
      Praliné torteHongMayEast29$ 870.00
      Orange-passion flanHongJulyEast64$ 1,472.00
      Sacher torteHongNovemberEast82$ 2,460.00
      Napoleon (piece)HongAugustEast45$ 157.50
      Pear CharlotteHongSeptemberEast55$ 1,375.00

Step by Step Solution

★★★★★

3.48 Rating (171 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

a The percenta... View full answer

blur-text-image
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 General Management Questions!

Q:

What is the percentage of sales forecasting method? What are some of the limitations financial analysts should be aware of in applying this method?

Q:

When utilizing the percentage of sales approach, managers: I. Estimate company sales based on a desired level of net income and the current profit margin. II. Consider only those assets that vary...

Q:

To begin, consider the percentage of sales formula used to determine external funds needed. External Required assets EFN = (A/S)DS Spontaneous Increase in funds = increase in increase in retained...

Q:

For each of the cases in problem 7.25 determine if a heat pump satisfies the first law (energy equation) and if it violates the second law? a. Q.H = 6 kW, Q.L = 4 kW, W. = 2 kW b. Q.H = 6 kW, Q.L = 0...

Q:

Find complex numbers t = z1 + z2 and s = z1 - z2, both in polar form, for each of the following pairs: (a) z2 2 + j3, z2 1 j3, (b) z1 3, z2 - - j3, (c) z1 0- 330, z2 3 -30, (d) z1 3 30, z2 3...

Q:

Problems 112 and 113 raise the question of the reliability of the bearing pair on the shaft. Since the combined reliabilities R is R1 R2 , what is the reliability of the two bearings (probability...

Q:

For each of the plane stress states listed below, draw a Mohrs circle diagram properly labeled, find the principal normal and shear stresses, and determine the angle from the x axis to 1. Draw stress...

Q:

The figure is a schematic drawing of a countershaft that supports two V-belt pulleys. For each pulley, the belt tensions are parallel. For pulley A consider the loose belt tension is 15 percent of...

Q:

Calculate Ka for each of the following acids, given its pKa. Rank the compounds in order of decreasing acidity. (a) Aspirin: pKa = 3.48 (b) Vitamin C (ascorbic acid): pKa = 4.17 (c) Formic acid...

Q:

Consider a heat engine and heat pump connected as shown in figure P.7.38. Assume TH1 = TH2 > Tamb and determine for each of the three cases if the setup satisfy the first law and/or violates the 2nd...

Q:

The following convertible securities will have a dilutive impact on earnings per share: (1) 10% convertible preferred stock with dividends of $7,000 declared during the year and shares convertible...

Q:

Your answer is partially correct. Culver Company expects to produce 1,392,000 units of Product XX in 2022. Monthly production is expected to range from 92,800 to 139,200 units. Budgeted variable...

Q:

Treating the county dataset as the population of US counties, create the dataframe my. SRS that samples from county and represents a simple random sample of n = 250 individual counties from all...

Q:

Jetson Ltd imports inventory from Germany Ltd and on 1 June ordered goods worth Euro 200000 The inventory is delivered on 15 July and payment is made on July 31. Jetson Ltd took out a hedge on 1 June...

Q:

The ABC Company has net written premiums in the amount of $4.12 billion and a policyholders' surplus of $2.84 billion. LMN Inc. has net written premiums in the amount of $9.85 billion and a...

Q:

Assignment #1 Directions: Read and answer the questions below.This assignment is to be completed in two steps.Step One of the assignment is due on October 7, 2021, before class.For Step One, you are...

Q:

Exercise 04-07 On October 1 of the current year, C's e... On October 1 of the current year, C's employer provided him with the use of a car. The car was leased for a monthly cost of $850 (including...

Q:

Starr Co. had sales revenue of $540,000 in 2014. Other items recorded during the year were: Cost of goods sold ..................................................... $330,000 Salaries and wages...

Q:

losses from passive activities that cannot be deducted currently are carried over for up to 5 subsequent years. true or false

Q:

The owners equity accounts for Alexander International are shown here: Common stock ($.50 par value) ...$ 20,000 Capital surplus.........285,000 Retained earnings 6.......38,120 Total owners...

Q:

Paper Submarine Manufacturing is investigating a lockbox system to reduce its collection time. It has determined the following: Average number of payments per day..... 385 Average value of...

Q:

Come and Go Bank offers your firm a discount interest loan at 9 percent for up to $25 million and, in addition, requires you to maintain a 5 percent compensating balance against the amount borrowed....

Q:

Suppose that you are trying to choose which of two IT projects to accept. Your company employs three primary selection criteria for evaluating all IT projects: 1) proven technology, 2) ease of...

Q:

1) Who are Rollss principal project management stakeholders? How would you design stakeholder management strategies to address their concerns? 2) Given the financial risks inherent in developing a...

Q:

The following table shows a breakdown of the 113th U.S. Congress by party affiliation. a. A member of Congress is selected at random. What is the probability of selecting a Republican? b. Given that...