D G H 1 Order Number Order Date Region Rep Product Ordered Units Ordered Price per...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
D G H 1 Order Number Order Date Region Rep Product Ordered Units Ordered Price per Unit Total Sales 8 $ 10 $ 20 $ 8 $ 9 $ 10 $ 23 $ 9 $ 19.00 $ 152.00 9.00 $ 90.00 2 001 04-Jan East Hanks Paper 002 04-Jan East Hanks Pens 003 05-Jan East Hanks Sticky Notes Envelopes Paper 8.50 $ 170.00 004 06-Jan East Allen 4.50 36.00 Smith 19.00 $ 171.00 9.00 $ 8.50 $ 195.50 005 06-Jan East East 6 006 07-Jan Smith Pens 90.00 007 08-Jan South Harris Sticky Notes Hanks Envelopes Moore Paper Midwest Phillips Paper 008 08-Jan East West 4.50 $ 19.00 $ 190.00 19.00 $ 190.00 $ 212.50 9 40.50 009 09-Jan 10 $ 10 $ 25 $ 10 010 10-Jan 10-Jan 11 011 South Wilson Sticky Notes Garcia Envelopes Paper Раper Sticky Notes Moore Envelopes Paper 12 8.50 012 11-Jan West 10 $ 11 $ 10 $ 27 $ 9 $ 4.50 24 $ 209.00 $ 190.00 $ 229.50 13 45.00 14 013 12-Jan South Harris 19.00 014 12-Jan East Allen 19.00 15 16 015 13-Jan East Smith 8.50 West 4.50 $ 19.00 $ 228.00 9.00 $ 8.50 $ 255.00 4.50 $ 17 016 14-Jan 40.50 017 14-Jan East Allen 12 $ 10 $ 30 $ 7 $ 13 $ 10 $ 18 018 15-Jan 16-Jan 16-Jan 19 West Garcia Pens 90.00 Midwest Johnson Sticky Notes Brown Envelopes Brown Paper Pens Midwest Johnson Sticky Notes Brown Envelopes Wilson Paper 20 019 21 020 South 31.50 021 17-Jan South 19.00 $ 247.00 22 022 18-Jan East Hanks 9.00 $ 8.50 $ 246.50 4.50 $ 19.00 $ 266.00 9.00 $ 8.50 $ 238.00 23 90.00 023 18-Jan 29 $ 12 $ 24 25 024 19-Jan South 54.00 025 20-Jan South 14 $ 10 $ 26 026 20-Jan South Brown Pens 90.00 27 Sticky Notes Envelopes 027 21-Jan East Allen 28 $ 13 $ 28 028 22-Jan South Harris Midwest Johnson Paper Harris 4.50 $ 19.00 $ 285.00 9.00 $ 8.50 $ 178.50 4.50 $ 19.00 $ 247.00 19.00 $ 228.00 8.50 $ 195.50 29 58.50 029 22-Jan 15 $ 11 $ 21 $ 9 $ 13 $ 12 $ 23 $ 8 $ 11 $ 13 $ 24 $ 30 31 030 23-Jan South Pens 99.00 031 24-Jan Midwest Johnson Sticky Notes 32 032 24-Jan East Allen Envelopes 40.50 33 Harris Paper Paper Midwest Peters Sticky Notes Wilson Envelopes Midwest Johnson Paper Wilson Paper Garcia Sticky Notes Midwest Johnson Envelopes Paper Midwest Johnson Pens Midwest Peters Sticky Notes 34 033 25-Jan South 35 034 26-Jan East Smith 38 035 26-Jan 036 27-Jan South 4.50 $ 19.00 $ 209.00 37 36.00 38 037 28-Jan 038 28-Jan South 19.00 $ 247.00 8.50 $ 204.00 39 40 039 29-Jan West 040 30-Jan 11 $ 8 $ 10 $ 27 $ 4.50 24 49.50 $ 152.00 $4 41 42 041 30-Jan East Allen 19.00 042 9.00 31-Jan 01-Feb 43 90.00 44 043 8.50 $ 229.50 Products Available Price per Unit $19.00 per case $ 9.00 per box $ 8.50 per package $ 4.50 per box Paper Pens Sticky Notes Envelopes Create Pivot Table(s) and determine the following information while analyzing the data: 1. Which product has the highest total units ordered and the highest total sales? (Enter your Units Ordered to the nearest whole unit and your Total Sales to 2 decimal places.) Product Total Units Ordered Total Sales 2. Which rep has the highest total sales for each region? (Enter your Total Sales to 2 decimal places.) Region Rep Name Total Sales East Midwest South West 3. What is the total annual sales for each region? (Enter your Total Sales to 2 decimal places.) Region Total Sales East Midwest South West 4. Using the data from requirement 3, determine the sales percentage for each region. (Enter your Sales Percentage to the nearest whole percent.) Sales Region Percentage % % % East Midwest South West % 5. Now, using the Pivot Table, determine the monthly sales earned by each region. Identify the regions that had the highest and lowest monthly sales for the entire year. (Enter your Total Sales to 2 decimal places.) Region Month Total Sales Region with Highest Earning Month Region with Lowest Earning Month D G H 1 Order Number Order Date Region Rep Product Ordered Units Ordered Price per Unit Total Sales 8 $ 10 $ 20 $ 8 $ 9 $ 10 $ 23 $ 9 $ 19.00 $ 152.00 9.00 $ 90.00 2 001 04-Jan East Hanks Paper 002 04-Jan East Hanks Pens 003 05-Jan East Hanks Sticky Notes Envelopes Paper 8.50 $ 170.00 004 06-Jan East Allen 4.50 36.00 Smith 19.00 $ 171.00 9.00 $ 8.50 $ 195.50 005 06-Jan East East 6 006 07-Jan Smith Pens 90.00 007 08-Jan South Harris Sticky Notes Hanks Envelopes Moore Paper Midwest Phillips Paper 008 08-Jan East West 4.50 $ 19.00 $ 190.00 19.00 $ 190.00 $ 212.50 9 40.50 009 09-Jan 10 $ 10 $ 25 $ 10 010 10-Jan 10-Jan 11 011 South Wilson Sticky Notes Garcia Envelopes Paper Раper Sticky Notes Moore Envelopes Paper 12 8.50 012 11-Jan West 10 $ 11 $ 10 $ 27 $ 9 $ 4.50 24 $ 209.00 $ 190.00 $ 229.50 13 45.00 14 013 12-Jan South Harris 19.00 014 12-Jan East Allen 19.00 15 16 015 13-Jan East Smith 8.50 West 4.50 $ 19.00 $ 228.00 9.00 $ 8.50 $ 255.00 4.50 $ 17 016 14-Jan 40.50 017 14-Jan East Allen 12 $ 10 $ 30 $ 7 $ 13 $ 10 $ 18 018 15-Jan 16-Jan 16-Jan 19 West Garcia Pens 90.00 Midwest Johnson Sticky Notes Brown Envelopes Brown Paper Pens Midwest Johnson Sticky Notes Brown Envelopes Wilson Paper 20 019 21 020 South 31.50 021 17-Jan South 19.00 $ 247.00 22 022 18-Jan East Hanks 9.00 $ 8.50 $ 246.50 4.50 $ 19.00 $ 266.00 9.00 $ 8.50 $ 238.00 23 90.00 023 18-Jan 29 $ 12 $ 24 25 024 19-Jan South 54.00 025 20-Jan South 14 $ 10 $ 26 026 20-Jan South Brown Pens 90.00 27 Sticky Notes Envelopes 027 21-Jan East Allen 28 $ 13 $ 28 028 22-Jan South Harris Midwest Johnson Paper Harris 4.50 $ 19.00 $ 285.00 9.00 $ 8.50 $ 178.50 4.50 $ 19.00 $ 247.00 19.00 $ 228.00 8.50 $ 195.50 29 58.50 029 22-Jan 15 $ 11 $ 21 $ 9 $ 13 $ 12 $ 23 $ 8 $ 11 $ 13 $ 24 $ 30 31 030 23-Jan South Pens 99.00 031 24-Jan Midwest Johnson Sticky Notes 32 032 24-Jan East Allen Envelopes 40.50 33 Harris Paper Paper Midwest Peters Sticky Notes Wilson Envelopes Midwest Johnson Paper Wilson Paper Garcia Sticky Notes Midwest Johnson Envelopes Paper Midwest Johnson Pens Midwest Peters Sticky Notes 34 033 25-Jan South 35 034 26-Jan East Smith 38 035 26-Jan 036 27-Jan South 4.50 $ 19.00 $ 209.00 37 36.00 38 037 28-Jan 038 28-Jan South 19.00 $ 247.00 8.50 $ 204.00 39 40 039 29-Jan West 040 30-Jan 11 $ 8 $ 10 $ 27 $ 4.50 24 49.50 $ 152.00 $4 41 42 041 30-Jan East Allen 19.00 042 9.00 31-Jan 01-Feb 43 90.00 44 043 8.50 $ 229.50 Products Available Price per Unit $19.00 per case $ 9.00 per box $ 8.50 per package $ 4.50 per box Paper Pens Sticky Notes Envelopes Create Pivot Table(s) and determine the following information while analyzing the data: 1. Which product has the highest total units ordered and the highest total sales? (Enter your Units Ordered to the nearest whole unit and your Total Sales to 2 decimal places.) Product Total Units Ordered Total Sales 2. Which rep has the highest total sales for each region? (Enter your Total Sales to 2 decimal places.) Region Rep Name Total Sales East Midwest South West 3. What is the total annual sales for each region? (Enter your Total Sales to 2 decimal places.) Region Total Sales East Midwest South West 4. Using the data from requirement 3, determine the sales percentage for each region. (Enter your Sales Percentage to the nearest whole percent.) Sales Region Percentage % % % East Midwest South West % 5. Now, using the Pivot Table, determine the monthly sales earned by each region. Identify the regions that had the highest and lowest monthly sales for the entire year. (Enter your Total Sales to 2 decimal places.) Region Month Total Sales Region with Highest Earning Month Region with Lowest Earning Month
Expert Answer:
Answer rating: 100% (QA)
Solution 1 unH osidesegl TOtal sales papes 169 3211 pens 639 sticky Notes 277 23545... View the full answer
Related Book For
Accounting
ISBN: 978-0324662962
23rd Edition
Authors: Jonathan E. Duchac, James M. Reeve, Carl S. Warren
Posted Date:
Students also viewed these accounting questions
-
Given the following data: Per Unit Total Sales $15 $45,000 Less variable expenses 9 27,000 Contribution margin 6 18,000 Less fixed expenses 12,000 Net income $ 6,000 If sales decrease by 500 units,...
-
Consider the following data set: -0.02 -0.05 -0.03 0.01 0.13 25th 50th percentile 75th percentile 0.12 0.12 Click here for the Excel Data File a-1. Calculate the 25th, 50th, and 75th percentiles....
-
Beginning inventory, purchases, and sales data for tennis rackets are as follows: April 3 Inventory 20 units @ $12 11 Purchase 14 units $18 14 Sale 25 units 21 Purchase 10 units $19 25 Sale 15 units...
-
A bank reconciliation takes time and must balance. An employee was struggling in balancing the bank reconciliation. Her supervisor told her to plug (make an unsupported entry for) the difference,...
-
What happens if the auditor disagrees with managements assessment of internal control?
-
The ship has a weight of 4(16 6 ) lb and center of gravity at G. Two tugboats of negligible weight are used to turn it. If each tugboat pushes on it with a force of T = 2000 lb, determine the initial...
-
The in-plane shear modulus, \(G_{12}\), of a carbon/epoxy lamina is to be measured by using the rail shear test shown in Figure 10.36. The test is conducted on a 10 in. \(\times 10 \mathrm{in} ....
-
Due to rapid employee turnover in the accounting department, the following transactions involving intangible assets were improperly recorded by Neitzke Corporation in 2012. 1. Neitzke developed a new...
-
A corporation buys $2.5 million (face value) of a 20-year bond with a 5% semi-annual coupon priced at 102.25 with a duration of 16.36. What position should the corporation take in a 10-year zero...
-
Which statement concerning TQM in services is false a Service quality often depends upon the courtesy of the sales person b Service quality often depends upon how problems are handled c Service...
-
This essay consists of looking for information on the Internet related to the topic: Harassment work and prepare an essay to submit. Include at least 3-5 journal articles. Of the reading present at...
-
Define merge sort. What are the advantages of merge sort?
-
Describe in brief, the terms related to the graph: in-degree, out-degree, nodes and edges.
-
Why Sorting algorithms are important?
-
How do you insert a new element in a BST?
-
What are the applications of graph data structure?
-
You re out in space, on a rotating wheel - shaped space station of radius 7 7 3 7 7 3 m . . You feel planted firmly on the floor , , due to artificial gravity. The gravity you experience is Earth -...
-
When is the indirect pattern appropriate, and what are the benefits of using it?
-
Sweet Water Inc. bottles and distributes spring water. On July 15 of the current year, Sweet Water Inc. reacquired 24,000 shares of its common stock at $60 per share. On August 10, Sweet Water Inc....
-
At the end of the current year, Accounts Receivable has a balance of $750,000; Allowance for Doubtful Accounts has a credit balance of $11,250; and net sales for the year total $4,150,000. Using the...
-
Accrued salaries of $4,950 owed to employees for December 30 and 31 are not considered in preparing the financial statements for the year ended December 31. Indicate which items will be erroneously...
-
In a/an ................ system, neither mass nor energy transfer takes place across its boundary.
-
In a ................, mass, momentum and energy may flow.
-
Potential energy is an ................ property.
Study smarter with the SolutionInn App