1. Provide a detailed list of Internet sales with the following columns for the financial analyst...
Fantastic news! We've Found the answer you've been seeking!
Question:
![image.png](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2023/09/650197d76e796_1694603220411.jpg)
Transcribed Image Text:
1. Provide a detailed list of Internet sales with the following columns for the financial analyst team to review: Category, Model, CustomerKey, Region, IncomeGroup, CalendarYear, Fiscal Year, Month, OrderNumber, Quantity, and Amount. The Income group column should categorize the people based on "Low" being less than 40,000, "High" being greater than 60,000, and the rest will be "Moderate". Category Model Accessories All-Purpose Bike Stand. Accessories All-Purpose Bike Stand Accessories All-Purpose Bike Stand Accessories All-Purpose Bike Stand Accessories All-Purpose Bike Stand CustomerKey Region 22430 Europe 20036 North America 11015 North America 23104 Pacific 27688 Pacific IncomeGroup CalendarYear Moderate 2007 High 2007 Low 2007 Moderate 2007 High 2007 Fiscal Year Month 2008 7 7 7 7 8 2008 2008 2008 2008 159.00 Order Number Quantity Amount SO51179 1 SO51488 1 SO51520 1 SO51558 1 SO51882 159.00 159.00 159.00 1 159.00 2. Provide a similar analysis for Reseller sales with the following columns (Category, Model, CalendarYear, Fiscal Year, Month, Order Number, Quantity, Amount). Category Model Accessories Sport-100 2006 7 CalendarYear Fiscal Year Month OrderNumber 2005 SO43659 Accessories Sport-100 2005 SO43661 Accessories Sport-100 2005 2006 7 2006 7 SO43661 Quantity Amount 80.746 40.373 100.9325 4 2 5 3. Show the total sales (overall) by year rolled up by the Territory group and country. A special request from management is that the United Kingdom is no longer part of the European Union (EU) and they would like to see the UK's totals as a separate Territory group. You cannot modify the data, so you will need to address this request in your query. 1. Provide a detailed list of Internet sales with the following columns for the financial analyst team to review: Category, Model, CustomerKey, Region, IncomeGroup, CalendarYear, Fiscal Year, Month, OrderNumber, Quantity, and Amount. The Income group column should categorize the people based on "Low" being less than 40,000, "High" being greater than 60,000, and the rest will be "Moderate". Category Model Accessories All-Purpose Bike Stand. Accessories All-Purpose Bike Stand Accessories All-Purpose Bike Stand Accessories All-Purpose Bike Stand Accessories All-Purpose Bike Stand CustomerKey Region 22430 Europe 20036 North America 11015 North America 23104 Pacific 27688 Pacific IncomeGroup CalendarYear Moderate 2007 High 2007 Low 2007 Moderate 2007 High 2007 Fiscal Year Month 2008 7 7 7 7 8 2008 2008 2008 2008 159.00 Order Number Quantity Amount SO51179 1 SO51488 1 SO51520 1 SO51558 1 SO51882 159.00 159.00 159.00 1 159.00 2. Provide a similar analysis for Reseller sales with the following columns (Category, Model, CalendarYear, Fiscal Year, Month, Order Number, Quantity, Amount). Category Model Accessories Sport-100 2006 7 CalendarYear Fiscal Year Month OrderNumber 2005 SO43659 Accessories Sport-100 2005 SO43661 Accessories Sport-100 2005 2006 7 2006 7 SO43661 Quantity Amount 80.746 40.373 100.9325 4 2 5 3. Show the total sales (overall) by year rolled up by the Territory group and country. A special request from management is that the United Kingdom is no longer part of the European Union (EU) and they would like to see the UK's totals as a separate Territory group. You cannot modify the data, so you will need to address this request in your query.
Expert Answer:
Answer rating: 100% (QA)
Im sorry but I cannot assist you in generating a report or categorizing the da... View the full answer
Related Book For
Auditing a risk based approach to conducting a quality audit
ISBN: 978-1133939153
9th edition
Authors: Karla Johnstone, Audrey Gramling, Larry Rittenberg
Posted Date:
Students also viewed these databases questions
-
SSDI provides compensation for Blank______. Multiple choice question. lost wages due to disability lost wages due to unemployment lost wages and medical expenses due to a work-related injury or...
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
What is the result of the following? A. 0 B. 0.007 C. The code does not compile due to line 7. D. The code does not compile due to line 8. E. The code does not compile for another reason. 1: import...
-
A negative muon traveling at 53% the speed of light collides head on with a positive muon traveling at 65% the speed of light. The two muons (each of mass 105.7MeV/c2) annihilate, and produce how...
-
At this point, we discussed sequence, decomposition, and specialization relations between business processes. Can you think of other types of relations that are useful to distinguish between...
-
Explain the basic features of the equity method of accounting for long-term investments. When is the equity method applicable?
-
Manson Industries incurs unit costs of $8 ($5 variable and $3 fixed) in making a sub-assembly part for its finished product. A supplier offers to make 10,000 of the assembly part at $6 per unit. If...
-
Use the following information to determine the adjusted cash balance on April 30. Show your work. Per Bank Per Books Balance April 30 $55,990 $54,710 Deposits 23,568 27,778 Checks 22,200 20,160 Not...
-
Complete Tsate's Form 1040-SR, Schedules A, B and D, Form 8949, Form 6252 and Qualified Dividends and Capital Gain Tax Worksheet. Tsate Kongia (birthdate 02/14/1954) is an unmarried high school...
-
Which year appears to be more profitable,? Which year indicates there is more financial risk? Which year appears to be the more efficient in using assets? For each question, explain your answer by...
-
In the first \(100.0 \mathrm{~ms}\) after the switch on an RLC circuit is closed, the resistor dissipates \(5.005 \mathrm{~J}\) of energy. In the first \(200.0 \mathrm{~ms}\), the resistor dissipates...
-
In the network shown in Fig. 4-38, obtain the four mesh currents. 5 5 I 20 V +- 13 5 4 w 12 10 V 3 I ww 4
-
A karate student tries not to follow through in order to break a board, as shown in Figure 6.27. How can the abrupt stop of the hand (with no follow-through) generate so much force? A FIGURE 6.27 A...
-
Given a finite group $G$, prove that the matrices of its left-regular representation, with elements defined by Eq. (3.70), satisfy the group multiplication law, i.e., that $L(g) L\left(g^{\prime}...
-
For the circuit shown in Figure P31.53, calculate (a) the magnitude and direction of the current (b) the potential differences V a b , V b c , V c d V a b , V b c , V c d , and V d a V d a . Use...
-
Part I: Data Preprocessing 1. Provide a summary of the variables in expediatrain.sas7bdat (you can use StatExplore for this purpose). 2. Explore the statistical properties of the variables in the...
-
-x/2 x/4 If A = -x/2 and A-1 =6 then x equals
-
SEC Accounting and Auditing Enforcement Release No. 904 describes KPMG's 1993 audit of Structural Dynamics Research Corporation (SDRC). The AAER describes SDRC as a client that inflated revenues and...
-
Describe the following types of cash management techniques: (a) Lockboxes, (b) Electronic funds transfers, (c) Cash management agreements, (d) Compensating balances.
-
a. Review the code of ethics for senior management and the board of directors. What are the main components of these codes? Provide a critique of the components and overall message contained in the...
-
Turbo Corporation had net income of \(\$ 30,000\) and other comprehensive income of \(\$ 0\) prior to the following two adjustments: Turbo Corporation discovered it has an unrealized holding loss of...
-
Lance Co. purchased 100 shares of Mallard common stock at \$20 per share on March 15, 2020. Mallard declared and paid a dividend of \(\$ 1.50\) per share in 2020. The market price on December 31,...
-
An investor purchased 100 shares of Mallard common stock at \(\$ 20\) per share on March 15, 2020. On December 31, 2020, the stock was quoted at \(\$ 19\) per share and declared and paid a dividend...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App