Proceed as in Problem 1, but now create a pivot table that has two fields from the
Question:
Proceed as in Problem 1, but now create a pivot table that has two fields from the Products table, Product Family and Product Department, in the Rows area and two fields from the Stores table, Country and Region, in the Columns area. Use this to find the percentage of revenue from any product family or any product department that comes from any country or any region of any country. That is, a single pivot table should answer all such questions. For example, you should find that 17.48% of all revenue from the Seafood department comes from the Central region of Mexico?
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 60% (5 reviews)
Sum of Revenue Country Region Canada Canada Total Mexico Mexico Total USA USA Total Grand Total ProductFamily ProductDepartment Canada West Mexico Cen...View the full answer
Answered By
JAPHETH KOGEI
Hi there. I'm here to assist you to score the highest marks on your assignments and homework. My areas of specialisation are:
Auditing, Financial Accounting, Macroeconomics, Monetary-economics, Business-administration, Advanced-accounting, Corporate Finance, Professional-accounting-ethics, Corporate governance, Financial-risk-analysis, Financial-budgeting, Corporate-social-responsibility, Statistics, Business management, logic, Critical thinking,
So, I look forward to helping you solve your academic problem.
I enjoy teaching and tutoring university and high school students. During my free time, I also read books on motivation, leadership, comedy, emotional intelligence, critical thinking, nature, human nature, innovation, persuasion, performance, negotiations, goals, power, time management, wealth, debates, sales, and finance. Additionally, I am a panellist on an FM radio program on Sunday mornings where we discuss current affairs.
I travel three times a year either to the USA, Europe and around Africa.
As a university student in the USA, I enjoyed interacting with people from different cultures and ethnic groups. Together with friends, we travelled widely in the USA and in Europe (UK, France, Denmark, Germany, Turkey, etc).
So, I look forward to tutoring you. I believe that it will be exciting to meet them.
3.00+
2+ Reviews
10+ Question Solved
Related Book For
Business Analytics Data Analysis and Decision Making
ISBN: 978-1305947542
6th edition
Authors: S. Christian Albright, Wayne L. Winston
Question Posted:
Students also viewed these Statistics questions
-
Using the Elecmart Sales file from this section, experiment with slicers as follows. a. Create a pivot table that shows the average of TotalCost, broken down by Region in the row area and Time in the...
-
The Access database file Foodmart.mdb mentioned earlier has the tables and relationships shown in Figure 17.1. Import the tables into an Excel Data Model. Then create a pivot table that shows, for...
-
The file Adventure Works.cub contains sales data on biking and related products. It was created in Microsoft SQL Server software and stored as an offline cube. There are two dimension hierarchies,...
-
Determine the force P needed to support the 100 lb weight. Each pulley has a weight of 10 lb. Also determine the reactions at A and B. Figure 2 in
-
Determining the proper costing system Professor Julia Silverman received the following e-mail message. I dont know if you remember me. I am Tim Wallace. I was in your introductory accounting class a...
-
To spark interest in choosing accounting as a major, the Accounting Students Association at South Willow University is sponsoring an accounting contest. Students across campus are invited to create...
-
Consider a binomial model with three dates as introduced at the end of Sect. 6.3 (with \(t \in\{0,1,2\}\) ) and a contingent claim with payoff \(f\left(s_{2} ight)\), where \(s_{2}\) denotes the...
-
At December 31,2016, Fako Travel Agency has an Accounts Receivable balance of $96,000. Allowance for Doubtful Accounts has a credit balance of $830 before the year-end adjustment. Service revenue...
-
Travel agency owners have key salespeople contacts for their suppliers, such as cruise line and tour operator Business Development Managers. Therefore as a professional buyer of travel products, the...
-
Jackie serves as the vice president for network development for a large, midwestern healthcare system. She has worked with many rural and semirural hospitals to improve efficiency by offering shared...
-
The file P17_26.xlsx contains Gender, Age, Education, and Success (Yes/No) data of 1000 people. The purpose is to see how a classification tree method can use the first three variables to classify...
-
The file P17_05.xlsx contains data on 100 consumers who drink beer. Some of them prefer light beer, and others prefer regular beer. A major beer producer believes that the following variables might...
-
A trough for feeding cattle is 4 meters long and its cross sections are isosceles triangles with the two equal sides being 1/2 meter (see figure). The angle between the two sides is θ....
-
Use the information in the ledger accounts. Nov. 8 Nov. 30 114,000 9,600 Cash Land Building Nov. 1 144,000 Nov. 8 40,320 Nov. 8 84,000 Nov. 8 70,320 Nov. 25 Nov. 30 14,400 1,680 Nov. 15 Office...
-
At a recent team meeting, two staff members discussed the pros and cons of hashing and encryption. In the end, both agreed that companies would prefer to use encryption over hashing. They did not see...
-
Debtors are among the elements of current assets, which refer to the value of debts owed to the establishment by others, and it is normal for some debtors to fail to pay the value of the debts owed...
-
1. What type of business would potentially use the percentage of completion method for revenue recognition? 2. Would it be better for a business to have a deferred tax asset, a deferred tax...
-
Review the ANU 2022 Socially Responsible Investment Report (focus on the first two pages, read the rest of the report if you are interested), to answer the following questions: a) What is responsible...
-
Stork Corporation (E & P of $850,000) has 1,000 shares of common stock outstanding. The shares are owned by the following individuals: Lana Johnson, 400 shares; Lori Jones (Lanas mother), 200 shares;...
-
For the following exercises, find the inverse of the function and graph both the function and its inverse. f(x) = 4 x 2 , x 0
-
The file P17_22.xlsx contains the following data on 84 people: annual income, amount invested in the stock market, and a 0-1 variable on whether they subscribe to the Wall Street Journal. a. Use...
-
The file P17_10.xlsx contains customer data on acceptance of products with various attributes. This is explained more fully in the file. There are three potential Yes/No dependent variables, Acceptl,...
-
Play Things is developing a new Miley Cyrus doll. The company has made the following assumptions: The doll will sell for a random number of years from 1 to 10. Each of these 10 possibilities is...
-
A bank can either invest money for three months at 4.00% or for nine months at 4.50%. Ignoring actual/360 day count adjustments for the purpose of this question, the three against nine FRA quote the...
-
Shuggy Otis, an executive at Slapfish Corp. (SC) intends to retire in 11 years. SC just announced that it will start depositing $500.00 at the end of each quarter into each of its workers' retirement...
-
On January 1, the Hanover Beverage Company replaced the palletizing machine on one of its juice lines. The cost of the machine was $195,000. The machine's expected life is five years or 480,000...
Study smarter with the SolutionInn App