Sales City $7,451 Los Angeles Feb $11,221 Los Angeles Jun $9,525 San Francisco Jun $3,986 San...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Sales City $7,451 Los Angeles Feb $11,221 Los Angeles Jun $9,525 San Francisco Jun $3,986 San Diego May $11,667 San Diego Apri $11,649 San Francisco Mar $9,010 San Diego Feb Feb $5,686 Los Angeles Jan $9,121 San Francisco Mar $8,703 San Francisco Apr $4,369 San Diego $5,936 Los Angeles $9,990 San Diego May Joe $5,217 San Diego Apr Bill $5,582 San Francisco Apr Joe $7,913 Los Angeles Jun Jane Feb $8,581 San Francisco Jan Joe $7,472 San Diego Feb Bill $4,716 San Francisco Feb $3,020 San Diego Jan $11,552 San Francisco Apr $8,507 Los Angeles Mar $8,573 San Francisco Mar $4,827 San Diego Jun $11,146 San Diego $10,898 San Diego Date Sales Rep Type Wine Bill Joe Jane Jane Red Organic Red Bill Jane Jane Joe Jane Jane Jane Bill Joe Jane Jane Joe Bill Jane Jun Joe Apri Jane Organic White Red Red Red Organic Red Organic White Organic White Red White Red Red White Organic Red White White Red Organic Red What are the total sales by person? Bill $ 245,921.00 Joe $ 251,513.00 Jane $ 269,805.00 $245,921.00 Bill Total Sales by Person Red Red Red $251,513.00 Joe $269,805.00 Jane What were the total sales of red wine in California over the last six month? Bill $ 95,536.00 Joe $ 101,154.00 Jane $ 77,475.00 $10,424 San Francisco Apr Bill $6,077 Los Angeles Apr Bill Jane $4,908 Los Angeles Feb $4,652 San Francisco Jan Jane Apri Joe $7,498 San Diego $4,641 San Diego $10,440 San Diego Jun Bill Jan Jane $4,168 San Diego Joe Mar $4,031 San Francisco Feb Bill $4,031 San Francisco Feb. Jane $7,498 San Diego Apr Jane $8,305 San Diego Feb Jane Jane Joe $4,788 San Francisco May $11,953 San Diego May Jane Jane Jane Joe $11,482 San Francisco Jun $11,959 San Diego Jan $8,681 San Francisco Jun $10,399 Los Angeles Mar $11,310 Los Angeles Feb Joe $6,981 San Francisco Jun Jane $8,758 Los Angeles May Jane $9,837 San Diego May Bill $4,276 San Francisco Apr Joe Bill Joe Joe Joe $7,515 San Francisco Apr Bill $10,497 Los Angeles May Bill $8,587 San Francisco Jan $7,373 Los Angeles Feb $8,722 San Francisco Jan $5,607 San Francisco Jun $11,029 San Francisco Jan Bill $6,262 San Francisco Mar Bill $9,432 San Diego May $6,685 San Diego $3,913 San Diego $7,642 Los Angeles Lan cao main rao v Bill Apri Joe Jan Joe Mar Bill AA.. Jame White White White White Organic White White Red White White Organic Red White White Red White Organic Red Red Organic Organic Red White Red Red White White Red White White Organic Organic Organic Red Organic JAZA. $95,536.00 Red Bill Total Sales Red Wine $299,361.00 $101,154.00 Red Joe Which Type of wine were the best and and worst sellers? Red $ 299,361.00 White $ 301,704.00 Organic $ 154,953.00 Sales by Type of Wine $301,704.00 $77,475.00 Red Jane $154,953.00 Jan Joe $3,913 San Diego $7,642 Los Angeles Mar Bill $9,549 San Diego Mar Jane $9,014 San Diego Feb Bill $7,390 San Francisco May Jane $3,390 Los Angeles Feb Jane Bill Joe Jane Bill Joe Bill $4,670 San Francisco Juni Joe $8,535 Los Angeles Jun $9,112 San Francisco May $8,197 San Francisco Jan $3,287 Los Angeles Jan $6,388 Los Angeles Apr $9,887 San Diego Jan $6,326 Los Angeles Feb $10,694 Los Angeles Jan Joe $9,779 San Francisco Jun $10,157 San Francisco May $5,286 San Francisco Jan $8,516 Los Angeles $7,177 San Diego $6,312 Los Angeles $5,546 San Diego Joe Bill Joe $5,294 San Francisco Jan $7,879 San Francisco Mar $6,437 San Francisco Jun $6,061 San Diego Jan $7,763 San Francisco Jun $5,761 Los Angeles Jun Jane Jane Bill $9,248 San Francisco Apr Joe Joe Bill Jane Joe May Bill Apr Bill May Joe Feb Bill Jane Jane Bill $10,919 San Francisco Feb $11,498 Los Angeles Jani $8,950 San Diego May Mar Joe $9,133 Los Angeles $9,332 San Francisco Apr Bill $5,437 Los Angeles Joe Feb $7,914 San Diego Feb Joe Red Organic White White Organic Red Organic Red Red Red Red White Red Organic White Red Red Red White White Organic Red White White Red Organic White Red Organic White White White White Red White White Red White Organic $7,914 San Diego Feb Joe $8,559 Los Angeles May Jane $8,274 San Francisco Mar Bill $3,877 San Diego Jan $3,407 San Francisco Jan $5,605 San Diego Jun Jane Bill Jane White Red White Organic Red Red Sales City $7,451 Los Angeles Feb $11,221 Los Angeles Jun $9,525 San Francisco Jun $3,986 San Diego May $11,667 San Diego Apri $11,649 San Francisco Mar $9,010 San Diego Feb Feb $5,686 Los Angeles Jan $9,121 San Francisco Mar $8,703 San Francisco Apr $4,369 San Diego $5,936 Los Angeles $9,990 San Diego May Joe $5,217 San Diego Apr Bill $5,582 San Francisco Apr Joe $7,913 Los Angeles Jun Jane Feb $8,581 San Francisco Jan Joe $7,472 San Diego Feb Bill $4,716 San Francisco Feb $3,020 San Diego Jan $11,552 San Francisco Apr $8,507 Los Angeles Mar $8,573 San Francisco Mar $4,827 San Diego Jun $11,146 San Diego $10,898 San Diego Date Sales Rep Type Wine Bill Joe Jane Jane Red Organic Red Bill Jane Jane Joe Jane Jane Jane Bill Joe Jane Jane Joe Bill Jane Jun Joe Apri Jane Organic White Red Red Red Organic Red Organic White Organic White Red White Red Red White Organic Red White White Red Organic Red What are the total sales by person? Bill $ 245,921.00 Joe $ 251,513.00 Jane $ 269,805.00 $245,921.00 Bill Total Sales by Person Red Red Red $251,513.00 Joe $269,805.00 Jane What were the total sales of red wine in California over the last six month? Bill $ 95,536.00 Joe $ 101,154.00 Jane $ 77,475.00 $10,424 San Francisco Apr Bill $6,077 Los Angeles Apr Bill Jane $4,908 Los Angeles Feb $4,652 San Francisco Jan Jane Apri Joe $7,498 San Diego $4,641 San Diego $10,440 San Diego Jun Bill Jan Jane $4,168 San Diego Joe Mar $4,031 San Francisco Feb Bill $4,031 San Francisco Feb. Jane $7,498 San Diego Apr Jane $8,305 San Diego Feb Jane Jane Joe $4,788 San Francisco May $11,953 San Diego May Jane Jane Jane Joe $11,482 San Francisco Jun $11,959 San Diego Jan $8,681 San Francisco Jun $10,399 Los Angeles Mar $11,310 Los Angeles Feb Joe $6,981 San Francisco Jun Jane $8,758 Los Angeles May Jane $9,837 San Diego May Bill $4,276 San Francisco Apr Joe Bill Joe Joe Joe $7,515 San Francisco Apr Bill $10,497 Los Angeles May Bill $8,587 San Francisco Jan $7,373 Los Angeles Feb $8,722 San Francisco Jan $5,607 San Francisco Jun $11,029 San Francisco Jan Bill $6,262 San Francisco Mar Bill $9,432 San Diego May $6,685 San Diego $3,913 San Diego $7,642 Los Angeles Lan cao main rao v Bill Apri Joe Jan Joe Mar Bill AA.. Jame White White White White Organic White White Red White White Organic Red White White Red White Organic Red Red Organic Organic Red White Red Red White White Red White White Organic Organic Organic Red Organic JAZA. $95,536.00 Red Bill Total Sales Red Wine $299,361.00 $101,154.00 Red Joe Which Type of wine were the best and and worst sellers? Red $ 299,361.00 White $ 301,704.00 Organic $ 154,953.00 Sales by Type of Wine $301,704.00 $77,475.00 Red Jane $154,953.00 Jan Joe $3,913 San Diego $7,642 Los Angeles Mar Bill $9,549 San Diego Mar Jane $9,014 San Diego Feb Bill $7,390 San Francisco May Jane $3,390 Los Angeles Feb Jane Bill Joe Jane Bill Joe Bill $4,670 San Francisco Juni Joe $8,535 Los Angeles Jun $9,112 San Francisco May $8,197 San Francisco Jan $3,287 Los Angeles Jan $6,388 Los Angeles Apr $9,887 San Diego Jan $6,326 Los Angeles Feb $10,694 Los Angeles Jan Joe $9,779 San Francisco Jun $10,157 San Francisco May $5,286 San Francisco Jan $8,516 Los Angeles $7,177 San Diego $6,312 Los Angeles $5,546 San Diego Joe Bill Joe $5,294 San Francisco Jan $7,879 San Francisco Mar $6,437 San Francisco Jun $6,061 San Diego Jan $7,763 San Francisco Jun $5,761 Los Angeles Jun Jane Jane Bill $9,248 San Francisco Apr Joe Joe Bill Jane Joe May Bill Apr Bill May Joe Feb Bill Jane Jane Bill $10,919 San Francisco Feb $11,498 Los Angeles Jani $8,950 San Diego May Mar Joe $9,133 Los Angeles $9,332 San Francisco Apr Bill $5,437 Los Angeles Joe Feb $7,914 San Diego Feb Joe Red Organic White White Organic Red Organic Red Red Red Red White Red Organic White Red Red Red White White Organic Red White White Red Organic White Red Organic White White White White Red White White Red White Organic $7,914 San Diego Feb Joe $8,559 Los Angeles May Jane $8,274 San Francisco Mar Bill $3,877 San Diego Jan $3,407 San Francisco Jan $5,605 San Diego Jun Jane Bill Jane White Red White Organic Red Red
Expert Answer:
Answer rating: 100% (QA)
To find the total sales by person we need to sum up the sales amounts for each salesperson Heres the ... View the full answer
Related Book For
Introduction to Management Science A Modeling and Cases Studies Approach with Spreadsheets
ISBN: 978-0078024061
5th edition
Authors: Frederick S. Hillier, Mark S. Hillier
Posted Date:
Students also viewed these accounting questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
You have been hired by the Regional Real Estate Company to help them analyze real estate data. One of the companys Pacific region salespeople just returned to the office with a newly designed...
-
(a) Do an additive time series model on the tornado data using years 1998 through Dec. 2018. The months of 2019 will be used for a holdout sample Make sure that the assumptions are valid. Interpret...
-
Raheem & Co. purchased a fixed asset on 1.4.2018 for Rs.2,50,000. Depreciation is to be provided @10% annually according to the Straight-line method. The books are closed on 31st March every year....
-
Males under the age of 25 must pay far higher auto insurance premiums than females in this age group. How does this fact relate to statistical discrimination? Statistical discrimination implies that...
-
Redo the example in Figure 22.8, assuming that the real option is a put option allowing the company to abandon the R&D program if commercial prospects are sufficiently poor at year 2. Use put-call...
-
On a Sunday afternoon in 2005 at a busy hospital in the Pacific Northwest, computers started running slower and documents would not print. By Monday morning, the situation became worse as more...
-
Mike and Melissa form the equal MM Partnership. Mike contributes cash of $40,000 and land (fair market value of $100,000, adjusted basis of $120,000), and Melissa contributes the assets of her sole...
-
During the year ended 30 June 2015 Barry Ltd, pays quarterly tax installments as follows: $4000 on 28 October 2014 $11 000 on 28 February 2015 $12 000 on 28 April 2015 On 30 June 2015, Barry Ltd...
-
Evaluate the matrix elements (or expectation values) given below. If any vanishes, explain why it vanishes using simple symmetry (or other) arguments. [In (a) and (b), |nlm stands for the energy...
-
JC, a 58-year-old patient, has been recently diagnosed with hypertension. His resting blood pressure is 158/92. He is prescribed hydrochlorothiazide 50 mg/day and told to eat foods rich in potassium....
-
Question 4 (2 points) South Street Stitching Company (South Street) manufactures and sells a variety of handmade purses, wallets, and laptop bags. South Street provided the following information...
-
Third Ltd acquired its 80 per cent interest and Investment in Rock Ltd is $306,160 on 1 July 2013. At that date the capital and reserves of Rock Ltd were: Share capital $172,000 Retained earnings...
-
On 31 December 2017, Snow Lake Pty Ltd purchased computers on credit for $60,000 plus GST. It has an expected useful life of 4 years and a residual value of $3,000 plus GST and assuming the balance...
-
1. Explain how the reinforcement learning and social learning approaches are similar and dissimilar to one another. 2. Assume you belong to a student organization on campus. Discuss in detail how the...
-
Graph the equation -5x + 2y = 10 by plotting points.
-
Businesses Being a Force of Good Companies committed to CSR and sustainability (can also be called corporate sustainability) often look to the UN Sustainable Development Goals and the UN Global...
-
The diameter of a sphere is 18 in. Find the largest volume of regular pyramid of altitude 15 in. that can be cut from the sphere if the pyramid is (a) square, (b) pentagonal, (c) hexagonal, and (d)...
-
Read the referenced article that fully describes the management science study summarized in the application vignette presented in Section 4.3. Briefly describe how spreadsheet modeling was applied in...
-
a. Formulate and solve a linear programming model for this problem. b. What is your resulting recommendation to the school board? After seeing your recommendation, the school board expresses concern...
-
Read the referenced article that fully describes the management science study summarized in the application vignette presented in Section 13.5. Briefly describe how computer simulation was applied in...
-
Decision scope categorizes decisions into three broad areas of managerial decision making. These three areas are operational control, management control, and strategic planning. In your own words,...
-
Write a two-page report explaining the two basic strategies that S&S, Inc. can pursue and the three different strategic positions that it can adopt. Include in your report a discussion and examples...
-
Information technology is continually changing the nature of accounting and the role of accountants. Write a two-page report describing what you think the nature of the accounting function in a large...
Study smarter with the SolutionInn App