For each salesperson, display a breakdown of units sold as well as revenue, showing the results for
Question:
For each salesperson, display a breakdown of units sold as well as revenue, showing the results for each product by region.
Transcribed Image Text:
B 4 Trans Number Name 10 Betsy 11 Ashley 15 Zaret 16 Emilee 567 7 8 68 9 10 11 12 13 14 15 16 17 18 19 20 21 22222 23 24 25 45 Emilee 46 Ashley 58 Cristina 60 Jen 69 Cristina 77 Cristina 81 Jen 86 Jen 87 Emilee 98 Jen 108 Cici 114 Betsy 116 Zaret 119 Colleen 131 Jen 133 Betsy 140 Jen Date с D Product 8/7/2006 lip gloss 11/29/2004 mascara 9/20/2006 foundation 4/12/2004 mascara 9/20/2006 lip gloss 8/9/2005 mascara 4/12/2004 foundation 10/27/2004 mascara 1/23/2005 eye liner 1/15/2004 mascara 1/10/2006 lip gloss 8/9/2005 eye liner 8/31/2005 eye liner 4/12/2004 lip gloss 8/31/2005 lip gloss 9/22/2005 lipstick 6/24/2006 eye liner 5/22/2006 eye liner 11/29/2004 mascara 7/9/2004 mascara 6/28/2004 eye liner E Units F Dollars 24 $ 43 $ -8 $ 45 $ 2 $ 93 $ 34 $ 89 $ 73 $ 27 $ 69 $ -2 $ 5 $ 92 $ -10 $ 77 $ 22 $ 20 $ 56 $ 11 $ 80 $ Location 73.50 east 130.84 east (21.99) east 137.39 east 7.85 east 280.69 east 104.09 east 269.09 east 221.41 east 83.29 east 208.69 east (4.24) east 17.03 east G 277.54 east (28.41) east 233.33 east 68.07 east 62.37 east 168.87 east 34.42 east 242.50 east
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 80% (10 reviews)
To display the breakdown of units sold and revenue by product and region for each salesperson we need to organize the given data into a table format H...View the full answer
Answered By
User l_917591
As a Business Management graduate from Moi University, I had the opportunity to work as a tutor for undergraduate students in the same field. This experience allowed me to apply the theoretical knowledge I had gained in a practical setting, while also honing my teaching and communication skills.
As a tutor, I was responsible for conducting tutorial sessions, grading assignments and exams, and providing feedback and support to my students. I also assisted with the preparation of course materials and collaborated with other tutors and professors to ensure consistency in teaching and assessment.
0.00
0 Reviews
10+ Question Solved
Related Book For
Microsoft Excel Data Analysis And Business Modeling
ISBN: 9780137613663
7th Edition
Authors: Wayne Winston
Question Posted:
Students also viewed these Business questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The management of a supermarket wants to find if there is a relationship between the number of times a specific product is promoted on the intercom system in the store and the number of units of that...
-
Googles ease of use and superior search results have propelled the search engine to its num- ber one status, ousting the early dominance of competitors such as WebCrawler and Infos- eek. Even later...
-
The Globe and Mail compiled a list of the top 100 public companies in Canada according to profit. Leading the list is the Toronto- Dominion Bank, followed by the Bank of Nova Scotia. The following...
-
The following information was gathered for the XYZ economy: velocity of money = 3.8 times; average price level = $85; and real output = 10,000 units. a. What is the nominal GDP for the XYZ economy?...
-
Suppose you desperately need technical advice on an Apple Inc. product. You have several options. Four of them are: (a) Call Apples technical support; (b) use Apples online customer support; (c) use...
-
Kendra, Cogley, and Mei share income and loss in a 3:2:1 ratio. The partners have decided to liquidate their partnership. On the day of liquidation their balance sheet appears as follows. (2c) Cr....
-
A risky $400,000 investment is expected to generate the following cash flows: a. If the firms cost of capital is 10 percent, should the investment be made? b. An alternative use for the $400,000 is a...
-
Which of the following criteria must be met for a company to be an S corporation? A. The corporation must have more than one class of stock. B. Shareholders must be other corporations or...
-
Ms Watanabe is trying to take advantage of the large difference of interest rates between the US and Japan. She is planning to borrow yen in Japan, covert them immediatelly to USD and invest the USD...
-
Find the largest transaction (in terms of revenue) for each product. B 4 Trans Number Name 10 Betsy 11 Ashley 15 Zaret 16 Emilee 45 Emilee 46 Ashley 58 Cristina 60 Jen 69 Cristina 77 Cristina 81 Jen...
-
Find the average dollar amount per transaction by region. B 4 Trans Number Name 10 Betsy 11 Ashley 15 Zaret 16 Emilee 567 7 8 68 9 10 11 12 13 14 15 16 17 18 19 20 21 22222 23 24 25 45 Emilee 46...
-
You expect to receive $25,000 at graduation in two years. You plan on investing it at 9 percent until you have $160,000. How long will you wait from now? (Better than the situation in Question 9, but...
-
Because her insurance agency is in a lakeside community, Adriana always asks her homeowners clients what boating activities they engage in, and she is sure to add the Watercraft endorsement...
-
1. Among all assumptions in CVP analysis, which one do you think is the most critical? Explain. 2. How will you change the cost-volume-profit analysis if the assumption (you identify in the previous...
-
Construct a confidence interval for p-P2 at the given level of confidence. x =26, n =229, x2 = 31, n = 302, 95% confidence The researchers are % confident the difference between the two population...
-
AP 9-2 (Moving Expenses) In May of the current year, following a dispute with her immediate superior, Ms. Elaine Fox resigned from her job in Halifax and began to look for other employment. She was...
-
Minimize the number of states in the following DFA: A b b a a a b b b E B a a
-
What are monetary misstatements? What mistakes can cause a monetary misstatement?
-
Tarick Toys Company manufactures video game consoles and accounts for product costs using process costing. The following information is available regarding its June inventories. The following...
-
Discuss how the worldwide trend toward urbanization is affecting opportunities for international marketing.
-
Discuss how slower population growth will affect businesses in your local community.
-
Discuss the impact of changes in the size and use of technology in the 1829 age group on marketing strategy planning in the United States.
-
Which of the following statement about swaps is least accurate? A. In a plain vanilla interest rate swap, the notional principal is swapped. B. The default problem [i.e. default risk] is the most...
-
7. How much would be in your savings account in nine years after depositing $340 today if the bank pays 9 percent per year? (Do not round intermediate calculations. Round your answer to 2 decimal...
-
Critically evaluate the dividend valuation model and the earnings multiple models
Study smarter with the SolutionInn App