Use PivotTables to find the number of sales transactions by product and region, total amount of revenue
Question:
Use PivotTables to find the number of sales transactions by product and region, total amount of revenue by region, and total revenue by region and product in the Sales Transactions database.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 69% (13 reviews)
Sales Transactions July 14 Cust ID Region Transaction Code Amount Product 10001 East 93816545 2019 DVD 10002 West 74083490 1785 DVD 10003 North 64942368 2398 DVD 10004 West 70560957 2351 Book 10005 So...View the full answer
Answered By
Zubair Ahmed
I am pursuing chartered Accountancy from ICAI. I have completed my graduation in commerce from SOL. I am CA-Final Student. I choose CA because it provides me a practical exposure in finance and taxation which helps in teaching with point of practical aspect. I just don't teach how to prepare financial statements. I have practically prepared various financial statements of various entities of different industries. For me knowledge is not just around text book, it is around the practical scenarios you have.
0.00
0 Reviews
10+ Question Solved
Related Book For
Business Analytics Methods Models and Decisions
ISBN: 978-0321997821
2nd edition
Authors: James R. Evans
Question Posted:
Students also viewed these Business Communication questions
-
Use PivotTables to find the number of loans by different purposes, marital status, and credit risk in the Excel file Credit Risk Data. Illustrate the results on a PivotChart.
-
In the Excel file Cell Phone Survey, use PivotTables to find the average for each of the numerical variables for different cell phone carriers and gender of respondents.
-
The Excel file Cell Phone Survey reports opinions of a sample of consumers regarding the signal strength, value for the dollar, and customer service for their cell phone carriers. Use PivotTables to...
-
What (if anything) is wrong with each of the following statements? a. if (a > b) then c = 0; b. if a > b { c = 0; } c. if (a > b) c = 0; d. if (a > b) c = 0 else b = 0;
-
Turn to Figure and find the S& P 60 future. a. Suppose you buy one contract for March delivery. If the contract closes in March at a price of 720, what will your profit be? b. How many March...
-
The time for 65% consolidation of a 19-mm clay specimen (drained at top and bottom) in the laboratory is 10 minutes. How long will it take for a 4-m-thick clay layer in the field to undergo 40%...
-
Two pumps are under consideration: Determine the interest rate at which the two pumps are competitive. Installed cost Service life A $10,000 1 yr B $18,000 2 yr
-
Juras Inc. and Hinson Inc. have the following operating data: a. Compute the operating leverage for Juras Inc. and Hinson Inc. b. How much would income from operations increase for each company if...
-
Cost overruns and extraordinary spending by healthcare organizations harms the sustainability of the healthcare organization. Through activity-based costing (ABC), the healthcare industry is working...
-
Prevosti Farms and Sugarhouse pays its employees according to their job classification. The following employees make up Sugarhouse's staff: Employee Number Name and Address Payroll information...
-
Create a PivotTable to find the average amount of travel expenses for each sales representative in the Excel file Travel Expenses. Illustrate your results with a PivotChart.
-
Create a PivotTable for the data in the Excel file Weddings to analyze the wedding cost by type of payor and value rating. What conclusions do you reach?
-
What is meant by consumer surplus? How is it calculated?
-
Cosby Company purchased a new plant asset on April 1, 2015, at a cost of 774,000. It was estimated to have a service life of 20 years and a residual value of 60,000. Cosbys accounting period is the...
-
On March 10, 2017, No Doubt Company sells equipment that it purchased for \($240\),000 on August 20, 2010. It was originally estimated that the equipment would have a life of 12 years and a residual...
-
Financial Statement Analysis Cases Case 1 Commonwealth Edison Co. The following article about Commonwealth Edison Co. (USA) appeared in the Wall Street Journal. Bond Markets Giant Commonwealth Edison...
-
Shanahan Construction Company has entered into a contract beginning January 1, 2015, to build a parking complex. It has been estimated that the complex will cost \($600\),000 and will take 3 years to...
-
Meng Group is preparing the comparative financial statements for the annual report to its shareholders for fiscal years ended May 31, 2015, and May 31, 2016 (yen in thousands). The income from...
-
Write and solve a problem about the flying time between a pair of cities shown on the cellphone screen for Exercises 7172. Do not use the pairs in Exercise 71 or Exercise 72. Begin by determining a...
-
A fuel pump sends gasoline from a car's fuel tank to the engine at a rate of 5.88 10-2 kg/s. The density of the gasoline is 735 kg/m3, and the radius of the fuel line is 3.18 10-3 m. What is the...
-
Given the following diagram, determine the total system reliability if the individual component reliabilities are: A = 0.94, B = 0.90, and C = 0.87. B A
-
A simple electronic assembly consists of two components in a series configuration with reliabilities as shown in the figure below. (Design Option A) Engineers would like to increase the reliability...
-
A simple electronic assembly consists of two components in a series configuration with reliabilities as shown in the figure below. (Design Option A) Engineers would like to increase the reliability...
-
A cylindrical log is cut as shown to form a park bench. Find: a. The area of triangle OAB in m. [2] b. The volume of the log in m. [3] B 70% 40 cm 3m
-
Security issues in today's workplace. Identify the different types of potential security issues an employer may have to deal with. Give examples to illustrate each of these potential security...
-
Research on the Internet and identify an emerging security issue. Describe the issue and its origin. Provide an example of this new security issue. Discuss the impacts of the security issue and...
Study smarter with the SolutionInn App